Server: mysql.puroparty.com | Database: puroparty | Table: photopost_ipcache |
Field | Type | Null | Default |
---|---|---|---|
id | int(10) | No | |
userid | int(25) | No | 0 |
ipaddr | varchar(75) | No | |
date | int(11) | Yes | NULL |
type | varchar(4) | No | |
photo | int(10) | No | 0 |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 0 | id | |
id_2 | UNIQUE | 0 | id | |
userid_2 | UNIQUE | 0 | userid | |
ipaddr_2 | UNIQUE | 0 | ipaddr | |
type_2 | UNIQUE | 0 | type | |
photo_2 | UNIQUE | 0 | photo | |
id_3 | UNIQUE | 0 | id | |
photo_3 | UNIQUE | 0 | photo | |
type_5 | UNIQUE | 0 | type | |
ipaddr_6 | UNIQUE | 0 | ipaddr | |
userid_4 | UNIQUE | 0 | userid | |
photo_5 | UNIQUE | 0 | photo | |
type_7 | UNIQUE | 0 | type | |
id_6 | UNIQUE | 0 | id | |
ipaddr_9 | UNIQUE | 0 | ipaddr | |
userid_6 | UNIQUE | 0 | userid | |
photo_7 | UNIQUE | 0 | photo | |
type_11 | UNIQUE | 0 | type | |
id_8 | UNIQUE | 0 | id | |
ipaddr_12 | UNIQUE | 0 | ipaddr | |
id_10 | UNIQUE | 0 | id | |
userid_9 | UNIQUE | 0 | userid | |
ipaddr_14 | UNIQUE | 0 | ipaddr | |
date_2 | UNIQUE | None | date | |
date_4 | UNIQUE | None | date | |
date_6 | UNIQUE | None | date | |
date_9 | UNIQUE | None | date | |
id | INDEX | None | id | |
userid | INDEX | None | userid | |
ipaddr | INDEX | None | ipaddr | |
date | INDEX | None | date | |
type | INDEX | None | type | |
photo | INDEX | None | photo | |
ipaddr_4 | INDEX | None | ipaddr | |
date_3 | INDEX | None | date | |
userid_3 | INDEX | None | userid | |
id_4 | INDEX | None | id | |
type_6 | INDEX | None | type | |
photo_4 | INDEX | None | photo | |
ipaddr_7 | INDEX | None | ipaddr | |
date_5 | INDEX | None | date | |
type_9 | INDEX | None | type | |
userid_5 | INDEX | None | userid | |
id_5 | INDEX | None | id | |
photo_6 | INDEX | None | photo | |
date_7 | INDEX | None | date | |
ipaddr_11 | INDEX | None | ipaddr | |
type_12 | INDEX | None | type | |
userid_7 | INDEX | None | userid | |
id_7 | INDEX | None | id | |
photo_8 | INDEX | None | photo | |
id_9 | INDEX | None | id | |
userid_8 | INDEX | None | userid | |
ipaddr_13 | INDEX | None | ipaddr | |
date_8 | INDEX | None | date | |
ipaddr_3 | INDEX | None | ipaddr | |
type_3 | INDEX | None | type | |
ipaddr_5 | INDEX | None | ipaddr | |
type_4 | INDEX | None | type | |
ipaddr_8 | INDEX | None | ipaddr | |
type_8 | INDEX | None | type | |
type_10 | INDEX | None | type | |
ipaddr_10 | INDEX | None | ipaddr | |
ipaddr_15 | INDEX | None | ipaddr |
Space usage :
|
Row Statistic :
|