mysql.puroparty.com
puroparty
jos_content
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_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 | 43 | id | |
| id_2 | UNIQUE | 43 | id | |
| title_2 | UNIQUE | 43 | title | |
| alias_2 | UNIQUE | 43 | alias | |
| modified_2 | UNIQUE | 43 | modified | |
| 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 | |
| hits_2 | INDEX | None | hits | |
| title_alias_3 | INDEX | None | title_alias | |
| catid_2 | INDEX | None | catid | |
| alias_4 | INDEX | None | alias | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| parentid_2 | INDEX | None | parentid | |
| access_2 | INDEX | None | access | |
| created_2 | INDEX | None | created | |
| mask_2 | INDEX | None | mask | |
| state_2 | INDEX | None | state | |
| created_by_2 | INDEX | None | created_by | |
| ordering_2 | INDEX | None | ordering | |
| title_3 | INDEX | None | title | |
| alias_3 | INDEX | None | alias | |
| title_alias_2 | INDEX | None | title_alias | |
| introtext | INDEX | None | introtext | |
| fulltext | INDEX | None | fulltext | |
| created_by_alias_2 | 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 | |
| attribs_2 | INDEX | None | attribs | |
| fulltext_2 | INDEX | None | fulltext | |
| created_by_alias_3 | INDEX | None | created_by_alias | |
| title_alias_4 | INDEX | None | title_alias | |
| title_4 | INDEX | None | title | |
| metadesc_2 | INDEX | None | metadesc | |
| metakey_2 | INDEX | None | metakey | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||