mysql.puroparty.com
puroparty
jos_session
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: jos_session
|
| Field | Type | Null | Default |
|---|---|---|---|
| username | varchar(150) | Yes | |
| time | varchar(14) | Yes | |
| session_id | varchar(200) | No | 0 |
| guest | tinyint(4) | Yes | 1 |
| userid | int(11) | Yes | 0 |
| usertype | varchar(50) | Yes | |
| gid | tinyint(3) | No | 0 |
| client_id | tinyint(3) | No | 0 |
| data | longtext | Yes | NULL |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 1 | session_id | 64 |
| session_id_2 | UNIQUE | 1 | session_id | |
| client_id_3 | UNIQUE | 1 | client_id | |
| gid_3 | UNIQUE | 1 | gid | |
| session_id_5 | UNIQUE | 1 | session_id | |
| gid_4 | UNIQUE | 1 | gid | |
| session_id_9 | UNIQUE | 1 | session_id | |
| client_id_5 | UNIQUE | 1 | client_id | |
| time_3 | UNIQUE | None | time | |
| userid_3 | UNIQUE | None | userid | |
| guest_3 | UNIQUE | None | guest | |
| usertype_5 | UNIQUE | None | usertype | |
| username_4 | UNIQUE | None | username | |
| time_7 | UNIQUE | None | time | |
| username_7 | UNIQUE | None | username | |
| usertype_6 | UNIQUE | None | usertype | |
| time_9 | UNIQUE | None | time | |
| guest_4 | UNIQUE | None | guest | |
| userid_6 | UNIQUE | None | userid | |
| userid_7 | UNIQUE | None | userid | |
| whosonline | INDEX | None | guest | |
| usertype | ||||
| userid | INDEX | None | userid | |
| time | INDEX | None | time | |
| username | INDEX | None | username | |
| time_2 | INDEX | None | time | |
| session_id | INDEX | None | session_id | |
| guest | INDEX | None | guest | |
| userid_2 | INDEX | None | userid | |
| usertype | INDEX | None | usertype | |
| gid | INDEX | None | gid | |
| client_id | INDEX | None | client_id | |
| client_id_2 | INDEX | None | client_id | |
| guest_2 | INDEX | None | guest | |
| gid_2 | INDEX | None | gid | |
| usertype_4 | INDEX | None | usertype | |
| session_id_4 | INDEX | None | session_id | |
| username_3 | INDEX | None | username | |
| time_5 | INDEX | None | time | |
| userid_4 | INDEX | None | userid | |
| username_6 | INDEX | None | username | |
| client_id_4 | INDEX | None | client_id | |
| userid_5 | INDEX | None | userid | |
| gid_5 | INDEX | None | gid | |
| usertype_7 | INDEX | None | usertype | |
| time_8 | INDEX | None | time | |
| session_id_8 | INDEX | None | session_id | |
| guest_5 | INDEX | None | guest | |
| username_9 | INDEX | None | username | |
| client_id_6 | INDEX | None | client_id | |
| username_2 | INDEX | None | username | |
| time_4 | INDEX | None | time | |
| session_id_3 | INDEX | None | session_id | |
| usertype_2 | INDEX | None | usertype | |
| data | INDEX | None | data | |
| usertype_3 | INDEX | None | usertype | |
| username_5 | INDEX | None | username | |
| time_6 | INDEX | None | time | |
| session_id_6 | INDEX | None | session_id | |
| data_2 | INDEX | None | data | |
| session_id_7 | INDEX | None | session_id | |
| usertype_8 | INDEX | None | usertype | |
| username_8 | INDEX | None | username | |
| time_10 | INDEX | None | time | |
| data_3 | INDEX | None | data | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||