mysql.puroparty.com
puroparty
photopost_categories
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: photopost_categories
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(12) | No | |
| catname | varchar(255) | No | |
| description | varchar(255) | Yes | NULL |
| catorder | mediumint(4) | No | 9999 |
| thumbs | varchar(4) | No | yes |
| parent | int(5) | No | 0 |
| header | varchar(200) | Yes | NULL |
| footer | varchar(200) | Yes | NULL |
| headtags | varchar(200) | Yes | NULL |
| private | varchar(5) | No | no |
| ugnoview | varchar(255) | Yes | NULL |
| ugnoupload | varchar(255) | Yes | NULL |
| ugnopost | varchar(255) | Yes | NULL |
| ugnovote | varchar(255) | Yes | NULL |
| ugnoanno | varchar(255) | Yes | NULL |
| children | text | Yes | NULL |
| albums | text | Yes | NULL |
| subalbum | int(12) | No | 0 |
| lastpost | int(11) | Yes | NULL |
| lastphoto | int(11) | Yes | NULL |
| photos | int(11) | Yes | 0 |
| posts | int(11) | Yes | 0 |
| password | varchar(24) | Yes | NULL |
| cattype | varchar(4) | No | c |
| theme | varchar(32) | Yes | NULL |
| thumbtype | int(2) | Yes | 0 |
| catdepth | varchar(6) | Yes | NULL |
| watermark | varchar(250) | No | |
| sortorder | int(2) | No | 1 |
| extra1 | varchar(250) | Yes | NULL |
| extra2 | varchar(250) | Yes | NULL |
| extra3 | varchar(250) | Yes | NULL |
| extra4 | varchar(250) | Yes | NULL |
| extra5 | varchar(250) | Yes | NULL |
| extra6 | varchar(250) | Yes | NULL |
| thumbnail | int(15) | No | 0 |
| maximages | int(12) | No | 0 |
| canzip | char(3) | No | no |
| frames | varchar(32) | No | 0 |
| intro | char(3) | No | no |
| introtitle | varchar(128) | Yes | NULL |
| introcopy | text | Yes | NULL |
| moderators | text | Yes | NULL |
| numextra | int(3) | No | 0 |
| ratingtype | int(1) | No | 0 |
| takevotes | int(1) | No | 0 |
| ismember | smallint(1) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 3 | id | |
| id_2 | UNIQUE | 3 | id | |
| catname_2 | UNIQUE | 3 | catname | |
| sortorder_2 | UNIQUE | 3 | sortorder | |
| description_2 | UNIQUE | None | description | |
| header_2 | UNIQUE | None | header | |
| footer_2 | UNIQUE | None | footer | |
| headtags_2 | UNIQUE | None | headtags | |
| ugnoview_2 | UNIQUE | None | ugnoview | |
| ugnoupload_2 | UNIQUE | None | ugnoupload | |
| ugnopost_2 | UNIQUE | None | ugnopost | |
| ugnovote_2 | UNIQUE | None | ugnovote | |
| ugnoanno_2 | UNIQUE | None | ugnoanno | |
| photos_2 | UNIQUE | None | photos | |
| password_2 | UNIQUE | None | password | |
| theme_2 | UNIQUE | None | theme | |
| catdepth_2 | UNIQUE | None | catdepth | |
| parent | INDEX | None | parent | |
| id | INDEX | None | id | |
| catname | INDEX | None | catname | |
| description | INDEX | None | description | |
| catorder | INDEX | None | catorder | |
| thumbs | INDEX | None | thumbs | |
| parent_2 | INDEX | None | parent | |
| header | INDEX | None | header | |
| footer | INDEX | None | footer | |
| headtags | INDEX | None | headtags | |
| private | INDEX | None | private | |
| ugnoview | INDEX | None | ugnoview | |
| ugnoupload | INDEX | None | ugnoupload | |
| ugnopost | INDEX | None | ugnopost | |
| ugnovote | INDEX | None | ugnovote | |
| ugnoanno | INDEX | None | ugnoanno | |
| subalbum | INDEX | None | subalbum | |
| lastpost | INDEX | None | lastpost | |
| lastphoto | INDEX | None | lastphoto | |
| photos | INDEX | None | photos | |
| posts | INDEX | None | posts | |
| password | INDEX | None | password | |
| cattype | INDEX | None | cattype | |
| theme | INDEX | None | theme | |
| thumbtype | INDEX | None | thumbtype | |
| catdepth | INDEX | None | catdepth | |
| watermark | INDEX | None | watermark | |
| sortorder | INDEX | None | sortorder | |
| catname_3 | INDEX | None | catname | |
| description_3 | INDEX | None | description | |
| thumbs_2 | INDEX | None | thumbs | |
| header_3 | INDEX | None | header | |
| footer_3 | INDEX | None | footer | |
| headtags_3 | INDEX | None | headtags | |
| private_2 | INDEX | None | private | |
| ugnoview_3 | INDEX | None | ugnoview | |
| ugnoupload_3 | INDEX | None | ugnoupload | |
| ugnopost_3 | INDEX | None | ugnopost | |
| ugnovote_3 | INDEX | None | ugnovote | |
| ugnoanno_3 | INDEX | None | ugnoanno | |
| children | INDEX | None | children | |
| albums | INDEX | None | albums | |
| password_3 | INDEX | None | password | |
| cattype_2 | INDEX | None | cattype | |
| theme_3 | INDEX | None | theme | |
| catdepth_3 | INDEX | None | catdepth | |
| watermark_2 | INDEX | None | watermark | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||