mysql.puroparty.com
puroparty
bak_users
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: bak_users
|
| Field | Type | Null | Default |
|---|---|---|---|
| id | int(11) | No | |
| name | varchar(255) | No | |
| username | varchar(150) | No | |
| varchar(100) | No | ||
| password | varchar(100) | No | |
| usertype | varchar(25) | No | |
| block | tinyint(4) | No | 0 |
| sendEmail | tinyint(4) | Yes | 0 |
| gid | tinyint(3) | No | 1 |
| registerDate | datetime | No | 0000-00-00 00:00:00 |
| lastvisitDate | datetime | No | 0000-00-00 00:00:00 |
| activation | varchar(100) | No | |
| params | text | No |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 0 | id | |
| id_2 | UNIQUE | 0 | id | |
| name_2 | UNIQUE | 0 | name | |
| username_3 | UNIQUE | 0 | username | |
| email_3 | UNIQUE | 0 | ||
| password_2 | UNIQUE | 0 | password | |
| usertype_3 | UNIQUE | 0 | usertype | |
| block_2 | UNIQUE | 0 | block | |
| gid_2 | UNIQUE | 0 | gid | |
| registerDate_2 | UNIQUE | 0 | registerDate | |
| lastvisitDate_2 | UNIQUE | 0 | lastvisitDate | |
| activation_2 | UNIQUE | 0 | activation | |
| registerDate_3 | UNIQUE | 0 | registerDate | |
| password_5 | UNIQUE | 0 | password | |
| lastvisitDate_4 | UNIQUE | 0 | lastvisitDate | |
| id_4 | UNIQUE | 0 | id | |
| gid_4 | UNIQUE | 0 | gid | |
| email_6 | UNIQUE | 0 | ||
| block_4 | UNIQUE | 0 | block | |
| name_6 | UNIQUE | 0 | name | |
| usertype_7 | UNIQUE | 0 | usertype | |
| activation_6 | UNIQUE | 0 | activation | |
| sendEmail_2 | UNIQUE | None | sendEmail | |
| sendEmail_3 | UNIQUE | None | sendEmail | |
| usertype | INDEX | None | usertype | |
| idx_name | INDEX | None | name | |
| gid_block | INDEX | None | gid | |
| block | ||||
| username | INDEX | None | username | |
| INDEX | None | |||
| id | INDEX | None | id | |
| name | INDEX | None | name | |
| username_2 | INDEX | None | username | |
| email_2 | INDEX | None | ||
| password | INDEX | None | password | |
| usertype_2 | INDEX | None | usertype | |
| block | INDEX | None | block | |
| sendEmail | INDEX | None | sendEmail | |
| gid | INDEX | None | gid | |
| registerDate | INDEX | None | registerDate | |
| lastvisitDate | INDEX | None | lastvisitDate | |
| activation | INDEX | None | activation | |
| lastvisitDate_3 | INDEX | None | lastvisitDate | |
| password_4 | INDEX | None | password | |
| username_5 | INDEX | None | username | |
| usertype_6 | INDEX | None | usertype | |
| id_3 | INDEX | None | id | |
| name_5 | INDEX | None | name | |
| gid_3 | INDEX | None | gid | |
| sendEmail_4 | INDEX | None | sendEmail | |
| block_3 | INDEX | None | block | |
| email_5 | INDEX | None | ||
| activation_4 | INDEX | None | activation | |
| name_3 | INDEX | None | name | |
| username_4 | INDEX | None | username | |
| email_4 | INDEX | None | ||
| password_3 | INDEX | None | password | |
| usertype_4 | INDEX | None | usertype | |
| activation_3 | INDEX | None | activation | |
| params | INDEX | None | params | |
| usertype_5 | INDEX | None | usertype | |
| name_4 | INDEX | None | name | |
| params_2 | INDEX | None | params | |
| activation_5 | INDEX | None | activation | |
| password_6 | INDEX | None | password | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||