mysql.puroparty.com
puroparty
photopost_photos
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: photopost_photos
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(10) | No | |
| user | varchar(50) | No | |
| userid | int(8) | No | 0 |
| cat | int(11) | No | 0 |
| storeid | int(12) | No | 0 |
| storecat | int(12) | No | 0 |
| date | int(15) | No | 0 |
| title | varchar(75) | Yes | |
| description | text | Yes | NULL |
| keywords | varchar(150) | Yes | NULL |
| bigimage | varchar(100) | No | |
| width | smallint(6) | Yes | NULL |
| height | smallint(4) | Yes | NULL |
| filesize | int(10) | Yes | 0 |
| views | int(10) | No | 0 |
| medwidth | int(12) | Yes | 0 |
| medheight | smallint(6) | Yes | 0 |
| medsize | mediumint(9) | Yes | 0 |
| approved | tinyint(2) | No | 0 |
| lastpost | int(15) | No | 0 |
| rating | float(12,2) | No | 0.00 |
| watermarked | varchar(5) | No | no |
| allowprint | varchar(5) | No | yes |
| extra1 | varchar(255) | Yes | NULL |
| extra2 | varchar(255) | Yes | NULL |
| extra3 | varchar(255) | Yes | NULL |
| extra4 | varchar(255) | Yes | NULL |
| extra5 | varchar(255) | Yes | NULL |
| extra6 | varchar(255) | Yes | NULL |
| disporder | int(5) | No | 99999 |
| ipaddress | varchar(32) | Yes | 0 |
| numcom | int(8) | No | 0 |
| lastposter | varchar(255) | Yes | NULL |
| lastpid | int(8) | No | 0 |
| allowrate | int(1) | No | 1 |
| allowcoms | int(1) | No | 1 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 5 | id | |
| id_2 | UNIQUE | 5 | id | |
| date_2 | UNIQUE | 5 | date | |
| bigimage_3 | UNIQUE | 5 | bigimage | |
| lastpost_2 | UNIQUE | 5 | lastpost | |
| title_2 | UNIQUE | None | title | |
| filesize_2 | UNIQUE | None | filesize | |
| lastposter_2 | UNIQUE | None | lastposter | |
| userid | INDEX | None | userid | |
| cat | INDEX | None | cat | |
| bigimage | INDEX | None | bigimage | |
| cat | ||||
| id | INDEX | None | id | |
| user | INDEX | None | user | |
| userid_2 | INDEX | None | userid | |
| cat_2 | INDEX | None | cat | |
| storeid | INDEX | None | storeid | |
| storecat | INDEX | None | storecat | |
| date | INDEX | None | date | |
| title | INDEX | None | title | |
| keywords | INDEX | None | keywords | |
| bigimage_2 | INDEX | None | bigimage | |
| width | INDEX | None | width | |
| height | INDEX | None | height | |
| filesize | INDEX | None | filesize | |
| views | INDEX | None | views | |
| medwidth | INDEX | None | medwidth | |
| medheight | INDEX | None | medheight | |
| medsize | INDEX | None | medsize | |
| approved | INDEX | None | approved | |
| lastpost | INDEX | None | lastpost | |
| rating | INDEX | None | rating | |
| watermarked | INDEX | None | watermarked | |
| allowprint | INDEX | None | allowprint | |
| extra1 | INDEX | None | extra1 | |
| extra2 | INDEX | None | extra2 | |
| extra3 | INDEX | None | extra3 | |
| extra4 | INDEX | None | extra4 | |
| extra5 | INDEX | None | extra5 | |
| extra6 | INDEX | None | extra6 | |
| disporder | INDEX | None | disporder | |
| ipaddress | INDEX | None | ipaddress | |
| numcom | INDEX | None | numcom | |
| lastposter | INDEX | None | lastposter | |
| lastpid | INDEX | None | lastpid | |
| allowrate | INDEX | None | allowrate | |
| allowcoms | INDEX | None | allowcoms | |
| lastposter_4 | INDEX | None | lastposter | |
| lastpost_3 | INDEX | None | lastpost | |
| approved_2 | INDEX | None | approved | |
| user_2 | INDEX | None | user | |
| title_3 | INDEX | None | title | |
| description | INDEX | None | description | |
| keywords_2 | INDEX | None | keywords | |
| bigimage_4 | INDEX | None | bigimage | |
| watermarked_2 | INDEX | None | watermarked | |
| allowprint_2 | INDEX | None | allowprint | |
| extra1_2 | INDEX | None | extra1 | |
| extra2_2 | INDEX | None | extra2 | |
| extra3_2 | INDEX | None | extra3 | |
| extra4_2 | INDEX | None | extra4 | |
| extra5_2 | INDEX | None | extra5 | |
| extra6_2 | INDEX | None | extra6 | |
| ipaddress_2 | INDEX | None | ipaddress | |
| lastposter_3 | INDEX | None | lastposter | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||