Server: mysql.puroparty.com | Database: puroparty | Table: photopost_iponline |
Field | Type | Null | Default |
---|---|---|---|
userid | varchar(128) | No | |
ipaddr | varchar(75) | No | |
date | int(11) | Yes | NULL |
what | varchar(64) | No | |
item | varchar(16) | No |
Keyname | Type | Cardinality | Field | |
---|---|---|---|---|
PRIMARY | PRIMARY | 1 | ipaddr | |
userid_2 | UNIQUE | 1 | userid | |
ipaddr_2 | UNIQUE | 1 | ipaddr | |
what_2 | UNIQUE | 1 | what | |
item_2 | UNIQUE | 1 | item | |
userid_4 | UNIQUE | 1 | userid | |
item_4 | UNIQUE | 1 | item | |
ipaddr_4 | UNIQUE | 1 | ipaddr | |
what_6 | UNIQUE | 1 | what | |
item_7 | UNIQUE | 1 | item | |
userid_7 | UNIQUE | 1 | userid | |
what_8 | UNIQUE | 1 | what | |
ipaddr_8 | UNIQUE | 1 | ipaddr | |
item_12 | UNIQUE | 1 | item | |
userid_11 | UNIQUE | 1 | userid | |
ipaddr_11 | UNIQUE | 1 | ipaddr | |
what_12 | UNIQUE | 1 | what | |
userid_14 | UNIQUE | 1 | userid | |
ipaddr_13 | UNIQUE | 1 | ipaddr | |
date_2 | UNIQUE | None | date | |
date_4 | UNIQUE | None | date | |
date_6 | UNIQUE | None | date | |
date_8 | UNIQUE | None | date | |
date_10 | UNIQUE | None | date | |
userid | INDEX | None | userid | |
ipaddr | INDEX | None | ipaddr | |
date | INDEX | None | date | |
what | INDEX | None | what | |
item | INDEX | None | item | |
what_5 | INDEX | None | what | |
date_3 | INDEX | None | date | |
userid_5 | INDEX | None | userid | |
item_6 | INDEX | None | item | |
ipaddr_6 | INDEX | None | ipaddr | |
date_5 | INDEX | None | date | |
item_8 | INDEX | None | item | |
what_9 | INDEX | None | what | |
userid_8 | INDEX | None | userid | |
ipaddr_9 | INDEX | None | ipaddr | |
item_10 | INDEX | None | item | |
date_7 | INDEX | None | date | |
userid_10 | INDEX | None | userid | |
what_11 | INDEX | None | what | |
userid_13 | INDEX | None | userid | |
ipaddr_12 | INDEX | None | ipaddr | |
date_9 | INDEX | None | date | |
userid_3 | INDEX | None | userid | |
ipaddr_3 | INDEX | None | ipaddr | |
what_3 | INDEX | None | what | |
item_3 | INDEX | None | item | |
what_4 | INDEX | None | what | |
ipaddr_5 | INDEX | None | ipaddr | |
item_5 | INDEX | None | item | |
userid_6 | INDEX | None | userid | |
what_7 | INDEX | None | what | |
item_9 | INDEX | None | item | |
ipaddr_7 | INDEX | None | ipaddr | |
userid_9 | INDEX | None | userid | |
what_10 | INDEX | None | what | |
item_11 | INDEX | None | item | |
ipaddr_10 | INDEX | None | ipaddr | |
userid_12 | INDEX | None | userid | |
userid_15 | INDEX | None | userid | |
ipaddr_14 | INDEX | None | ipaddr |
Space usage :
|
Row Statistic :
|