Server: mysql.puroparty.com | Database: puroparty | Table: bak_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 | 0 | id | |
id_2 | UNIQUE | 0 | id | |
catid_3 | UNIQUE | 0 | catid | |
sid_2 | UNIQUE | 0 | sid | |
title_2 | UNIQUE | 0 | title | |
alias_2 | UNIQUE | 0 | alias | |
url_2 | UNIQUE | 0 | url | |
date_2 | UNIQUE | 0 | date | |
hits_2 | UNIQUE | 0 | hits | |
published_2 | UNIQUE | 0 | published | |
checked_out_2 | UNIQUE | 0 | checked_out | |
checked_out_time_2 | UNIQUE | 0 | checked_out_time | |
ordering_2 | UNIQUE | 0 | ordering | |
archived_2 | UNIQUE | 0 | archived | |
approved_2 | UNIQUE | 0 | approved | |
catid_4 | UNIQUE | 0 | catid | |
checked_out_time_3 | UNIQUE | 0 | checked_out_time | |
title_5 | UNIQUE | 0 | title | |
hits_4 | UNIQUE | 0 | hits | |
checked_out_3 | UNIQUE | 0 | checked_out | |
date_4 | UNIQUE | 0 | date | |
sid_4 | UNIQUE | 0 | sid | |
published_4 | UNIQUE | 0 | published | |
url_6 | UNIQUE | 0 | url | |
approved_3 | UNIQUE | 0 | approved | |
alias_5 | UNIQUE | 0 | alias | |
id_4 | UNIQUE | 0 | id | |
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 | |
hits_3 | INDEX | None | hits | |
date_3 | INDEX | None | date | |
id_3 | INDEX | None | id | |
catid_5 | INDEX | None | catid | |
sid_3 | INDEX | None | sid | |
archived_3 | INDEX | None | archived | |
url_4 | INDEX | None | url | |
published_3 | INDEX | None | published | |
title_6 | INDEX | None | title | |
alias_4 | INDEX | None | alias | |
checked_out_4 | INDEX | None | checked_out | |
title_3 | INDEX | None | title | |
alias_3 | INDEX | None | alias | |
url_3 | INDEX | None | url | |
description | INDEX | None | description | |
params | INDEX | None | params | |
title_4 | INDEX | None | title | |
url_5 | INDEX | None | url | |
params_2 | INDEX | None | params | |
description_2 | INDEX | None | description | |
alias_6 | INDEX | None | alias |
Space usage :
|
Row Statistic :
|