Server: mysql.puroparty.com | Database: puroparty | Table: bak_content |
Field | Type | Null | Default |
---|---|---|---|
id | int(11) | No | |
title | varchar(255) | No | |
alias | varchar(255) | No | |
title_alias | varchar(255) | No | |
introtext | mediumtext | No | |
fulltext | mediumtext | No | |
state | tinyint(3) | No | 0 |
sectionid | int(11) | No | 0 |
mask | int(11) | No | 0 |
catid | int(11) | No | 0 |
created | datetime | No | 0000-00-00 00:00:00 |
created_by | int(11) | No | 0 |
created_by_alias | varchar(255) | No | |
modified | datetime | No | 0000-00-00 00:00:00 |
modified_by | int(11) | No | 0 |
checked_out | int(11) | No | 0 |
checked_out_time | datetime | No | 0000-00-00 00:00:00 |
publish_up | datetime | No | 0000-00-00 00:00:00 |
publish_down | datetime | No | 0000-00-00 00:00:00 |
images | text | No | |
urls | text | No | |
attribs | text | No | |
version | int(11) | No | 1 |
parentid | int(11) | No | 0 |
ordering | int(11) | No | 0 |
metakey | text | No | |
metadesc | text | No | |
access | int(11) | No | 0 |
hits | int(11) | No | 0 |
metadata | text | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | id | |
id_2 | UNIQUE | 0 | id | |
title_2 | UNIQUE | 0 | title | |
alias_2 | UNIQUE | 0 | alias | |
title_alias_2 | UNIQUE | 0 | title_alias | |
state_2 | UNIQUE | 0 | state | |
sectionid_2 | UNIQUE | 0 | sectionid | |
mask_2 | UNIQUE | 0 | mask | |
catid_2 | UNIQUE | 0 | catid | |
created_2 | UNIQUE | 0 | created | |
created_by_2 | UNIQUE | 0 | created_by | |
created_by_alias_2 | UNIQUE | 0 | created_by_alias | |
modified_2 | UNIQUE | 0 | modified | |
modified_by_2 | UNIQUE | 0 | modified_by | |
checked_out_2 | UNIQUE | 0 | checked_out | |
checked_out_time_2 | UNIQUE | 0 | checked_out_time | |
publish_up_2 | UNIQUE | 0 | publish_up | |
publish_down_2 | UNIQUE | 0 | publish_down | |
version_2 | UNIQUE | 0 | version | |
parentid_2 | UNIQUE | 0 | parentid | |
ordering_2 | UNIQUE | 0 | ordering | |
access_2 | UNIQUE | 0 | access | |
hits_2 | UNIQUE | 0 | hits | |
idx_section | INDEX | None | sectionid | |
idx_access | INDEX | None | access | |
idx_checkout | INDEX | None | checked_out | |
idx_state | INDEX | None | state | |
idx_catid | INDEX | None | catid | |
idx_createdby | INDEX | None | created_by | |
id | INDEX | None | id | |
title | INDEX | None | title | |
alias | INDEX | None | alias | |
title_alias | INDEX | None | title_alias | |
state | INDEX | None | state | |
sectionid | INDEX | None | sectionid | |
mask | INDEX | None | mask | |
catid | INDEX | None | catid | |
created | INDEX | None | created | |
created_by | INDEX | None | created_by | |
created_by_alias | INDEX | None | created_by_alias | |
modified | INDEX | None | modified | |
modified_by | INDEX | None | modified_by | |
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
publish_up | INDEX | None | publish_up | |
publish_down | INDEX | None | publish_down | |
version | INDEX | None | version | |
parentid | INDEX | None | parentid | |
ordering | INDEX | None | ordering | |
access | INDEX | None | access | |
hits | INDEX | None | hits | |
state_3 | INDEX | None | state | |
title_3 | INDEX | None | title | |
alias_3 | INDEX | None | alias | |
title_alias_3 | INDEX | None | title_alias | |
introtext | INDEX | None | introtext | |
fulltext | INDEX | None | fulltext | |
created_by_alias_3 | INDEX | None | created_by_alias | |
images | INDEX | None | images | |
urls | INDEX | None | urls | |
attribs | INDEX | None | attribs | |
metakey | INDEX | None | metakey | |
metadesc | INDEX | None | metadesc | |
metadata | INDEX | None | metadata |
Space usage :
|
Row Statistic :
|