Server: mysql.puroparty.com | Database: puroparty | Table: bak_newsfeeds |
Field | Type | Null | Default |
---|---|---|---|
catid | int(11) | No | 0 |
id | int(11) | No | |
name | text | No | |
alias | varchar(255) | No | |
link | text | No | |
filename | varchar(200) | Yes | NULL |
published | tinyint(1) | No | 0 |
numarticles | int(11) | No | 1 |
cache_time | int(11) | No | 3600 |
checked_out | tinyint(3) | No | 0 |
checked_out_time | datetime | No | 0000-00-00 00:00:00 |
ordering | int(11) | No | 0 |
rtl | tinyint(4) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | id | |
catid_3 | UNIQUE | 0 | catid | |
id_2 | UNIQUE | 0 | id | |
alias_2 | UNIQUE | 0 | alias | |
published_3 | UNIQUE | 0 | published | |
numarticles_2 | UNIQUE | 0 | numarticles | |
cache_time_2 | UNIQUE | 0 | cache_time | |
checked_out_2 | UNIQUE | 0 | checked_out | |
checked_out_time_2 | UNIQUE | 0 | checked_out_time | |
ordering_2 | UNIQUE | 0 | ordering | |
rtl_2 | UNIQUE | 0 | rtl | |
checked_out_3 | UNIQUE | 0 | checked_out | |
catid_5 | UNIQUE | 0 | catid | |
cache_time_4 | UNIQUE | 0 | cache_time | |
alias_4 | UNIQUE | 0 | alias | |
ordering_4 | UNIQUE | 0 | ordering | |
rtl_4 | UNIQUE | 0 | rtl | |
checked_out_time_3 | UNIQUE | 0 | checked_out_time | |
published_5 | UNIQUE | 0 | published | |
id_4 | UNIQUE | 0 | id | |
numarticles_4 | UNIQUE | 0 | numarticles | |
numarticles_6 | UNIQUE | 0 | numarticles | |
filename_2 | UNIQUE | None | filename | |
filename_4 | UNIQUE | None | filename | |
published | INDEX | None | published | |
catid | INDEX | None | catid | |
catid_2 | INDEX | None | catid | |
id | INDEX | None | id | |
alias | INDEX | None | alias | |
filename | INDEX | None | filename | |
published_2 | INDEX | None | published | |
numarticles | INDEX | None | numarticles | |
cache_time | INDEX | None | cache_time | |
checked_out | INDEX | None | checked_out | |
checked_out_time | INDEX | None | checked_out_time | |
ordering | INDEX | None | ordering | |
rtl | INDEX | None | rtl | |
ordering_3 | INDEX | None | ordering | |
cache_time_3 | INDEX | None | cache_time | |
rtl_3 | INDEX | None | rtl | |
catid_4 | INDEX | None | catid | |
published_4 | INDEX | None | published | |
id_3 | INDEX | None | id | |
numarticles_3 | INDEX | None | numarticles | |
alias_5 | INDEX | None | alias | |
filename_5 | INDEX | None | filename | |
checked_out_time_4 | INDEX | None | checked_out_time | |
checked_out_4 | INDEX | None | checked_out | |
filename_7 | INDEX | None | filename | |
alias_7 | INDEX | None | alias | |
ordering_5 | INDEX | None | ordering | |
numarticles_5 | INDEX | None | numarticles | |
id_5 | INDEX | None | id | |
catid_6 | INDEX | None | catid | |
checked_out_time_5 | INDEX | None | checked_out_time | |
name | INDEX | None | name | |
alias_3 | INDEX | None | alias | |
link | INDEX | None | link | |
filename_3 | INDEX | None | filename | |
link_2 | INDEX | None | link | |
name_2 | INDEX | None | name | |
alias_6 | INDEX | None | alias | |
filename_6 | INDEX | None | filename | |
name_3 | INDEX | None | name |
Space usage :
|
Row Statistic :
|