mysql.puroparty.com
puroparty
jos_newsfeeds
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_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 | 8 | id | |
| id_2 | UNIQUE | 8 | id | |
| alias_2 | UNIQUE | 8 | alias | |
| ordering_2 | UNIQUE | 8 | ordering | |
| ordering_3 | UNIQUE | 8 | ordering | |
| alias_5 | UNIQUE | 8 | alias | |
| id_4 | UNIQUE | 8 | id | |
| id_6 | UNIQUE | 8 | id | |
| alias_8 | UNIQUE | 8 | alias | |
| ordering_6 | UNIQUE | 8 | ordering | |
| checked_out_time_4 | UNIQUE | 8 | checked_out_time | |
| 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 | |
| catid_3 | INDEX | None | catid | |
| alias_4 | INDEX | None | alias | |
| checked_out_time_2 | INDEX | None | checked_out_time | |
| checked_out_2 | INDEX | None | checked_out | |
| published_3 | INDEX | None | published | |
| rtl_2 | INDEX | None | rtl | |
| cache_time_2 | INDEX | None | cache_time | |
| numarticles_2 | INDEX | None | numarticles | |
| id_3 | INDEX | None | id | |
| ordering_4 | INDEX | None | ordering | |
| filename_4 | INDEX | None | filename | |
| rtl_3 | INDEX | None | rtl | |
| ordering_5 | INDEX | None | ordering | |
| catid_4 | INDEX | None | catid | |
| id_5 | INDEX | None | id | |
| published_4 | INDEX | None | published | |
| cache_time_3 | INDEX | None | cache_time | |
| checked_out_time_3 | INDEX | None | checked_out_time | |
| alias_7 | INDEX | None | alias | |
| checked_out_3 | INDEX | None | checked_out | |
| numarticles_3 | INDEX | None | numarticles | |
| filename_6 | INDEX | None | filename | |
| id_7 | INDEX | None | id | |
| published_5 | INDEX | None | published | |
| catid_5 | INDEX | None | catid | |
| name | INDEX | None | name | |
| alias_3 | INDEX | None | alias | |
| link | INDEX | None | link | |
| filename_2 | INDEX | None | filename | |
| link_2 | INDEX | None | link | |
| name_2 | INDEX | None | name | |
| filename_3 | INDEX | None | filename | |
| alias_6 | INDEX | None | alias | |
| link_3 | INDEX | None | link | |
| name_3 | INDEX | None | name | |
| filename_5 | INDEX | None | filename | |
| alias_9 | INDEX | None | alias | |
| link_4 | INDEX | None | link | |
| link_5 | INDEX | None | link | |
| name_4 | INDEX | None | name | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||