mysql.puroparty.com
puroparty
jos_weblinks
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_weblinks
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| catid | int(11) | No | 0 |
| sid | int(11) | No | 0 |
| title | varchar(250) | No | |
| alias | varchar(255) | No | |
| url | varchar(250) | No | |
| description | text | No | |
| date | datetime | No | 0000-00-00 00:00:00 |
| hits | int(11) | No | 0 |
| published | tinyint(1) | No | 0 |
| checked_out | int(11) | No | 0 |
| checked_out_time | datetime | No | 0000-00-00 00:00:00 |
| ordering | int(11) | No | 0 |
| archived | tinyint(1) | No | 0 |
| approved | tinyint(1) | No | 1 |
| params | text | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 6 | id | |
| id_2 | UNIQUE | 6 | id | |
| title_2 | UNIQUE | 6 | title | |
| alias_2 | UNIQUE | 6 | alias | |
| url_2 | UNIQUE | 6 | url | |
| ordering_2 | UNIQUE | 6 | ordering | |
| id_3 | UNIQUE | 6 | id | |
| url_5 | UNIQUE | 6 | url | |
| ordering_4 | UNIQUE | 6 | ordering | |
| title_6 | UNIQUE | 6 | title | |
| alias_4 | UNIQUE | 6 | alias | |
| id_5 | UNIQUE | 6 | id | |
| url_7 | UNIQUE | 6 | url | |
| ordering_6 | UNIQUE | 6 | ordering | |
| alias_8 | UNIQUE | 6 | alias | |
| title_8 | UNIQUE | 6 | title | |
| catid | INDEX | None | catid | |
| published | ||||
| archived | ||||
| id | INDEX | None | id | |
| catid_2 | INDEX | None | catid | |
| sid | INDEX | None | sid | |
| title | INDEX | None | title | |
| alias | INDEX | None | alias | |
| url | INDEX | None | url | |
| date | INDEX | None | date | |
| hits | INDEX | None | hits | |
| published | INDEX | None | published | |
| checked_out | INDEX | None | checked_out | |
| checked_out_time | INDEX | None | checked_out_time | |
| ordering | INDEX | None | ordering | |
| archived | INDEX | None | archived | |
| approved | INDEX | None | approved | |
| ordering_3 | INDEX | None | ordering | |
| checked_out_2 | INDEX | None | checked_out | |
| catid_3 | INDEX | None | catid | |
| url_4 | INDEX | None | url | |
| published_2 | INDEX | None | published | |
| title_4 | INDEX | None | title | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| alias_5 | INDEX | None | alias | |
| id_4 | INDEX | None | id | |
| approved_2 | INDEX | None | approved | |
| date_2 | INDEX | None | date | |
| hits_2 | INDEX | None | hits | |
| archived_2 | INDEX | None | archived | |
| sid_2 | INDEX | None | sid | |
| ordering_5 | INDEX | None | ordering | |
| catid_4 | INDEX | None | catid | |
| alias_9 | INDEX | None | alias | |
| id_6 | INDEX | None | id | |
| approved_3 | INDEX | None | approved | |
| title_3 | INDEX | None | title | |
| alias_3 | INDEX | None | alias | |
| url_3 | INDEX | None | url | |
| description | INDEX | None | description | |
| params | INDEX | None | params | |
| title_5 | INDEX | None | title | |
| params_2 | INDEX | None | params | |
| url_6 | INDEX | None | url | |
| description_2 | INDEX | None | description | |
| alias_6 | INDEX | None | alias | |
| alias_7 | INDEX | None | alias | |
| title_7 | INDEX | None | title | |
| description_3 | INDEX | None | description | |
| url_8 | INDEX | None | url | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||