mysql.puroparty.com
puroparty
extcal_2users
| Server: mysql.puroparty.com
|
Database: puroparty
|
Table: extcal_2users
|
| Field | Type | Null | Default |
|---|---|---|---|
| user_id | int(11) | No | |
| username | varchar(30) | No | |
| password | varchar(64) | No | |
| firstname | varchar(64) | Yes | |
| lastname | varchar(64) | Yes | |
| group_id | int(11) | No | 2 |
| lastvisit | datetime | No | 0000-00-00 00:00:00 |
| varchar(255) | No | ||
| user_regdate | datetime | No | 0000-00-00 00:00:00 |
| user_lang | varchar(255) | No | |
| user_website | varchar(255) | No | |
| user_location | varchar(255) | No | |
| user_occupation | varchar(255) | No | |
| reg_key | varchar(64) | Yes | NULL |
| user_status | tinyint(1) | No | 0 |
| Keyname | Type | Cardinality | Field | |
|---|---|---|---|---|
| PRIMARY | PRIMARY | 7 | user_id | |
| username | UNIQUE | 7 | username | |
| user_id_2 | UNIQUE | 7 | user_id | |
| username_3 | UNIQUE | 7 | username | |
| password_2 | UNIQUE | 7 | password | |
| lastvisit_2 | UNIQUE | 7 | lastvisit | |
| email_2 | UNIQUE | 7 | ||
| user_regdate_2 | UNIQUE | 7 | user_regdate | |
| password_4 | UNIQUE | 7 | password | |
| user_regdate_3 | UNIQUE | 7 | user_regdate | |
| username_5 | UNIQUE | 7 | username | |
| user_id_4 | UNIQUE | 7 | user_id | |
| lastvisit_4 | UNIQUE | 7 | lastvisit | |
| email_5 | UNIQUE | 7 | ||
| user_location_5 | UNIQUE | 7 | user_location | |
| reg_key_2 | UNIQUE | None | reg_key | |
| reg_key_5 | UNIQUE | None | reg_key | |
| user_id | INDEX | None | user_id | |
| username_2 | INDEX | None | username | |
| password | INDEX | None | password | |
| firstname | INDEX | None | firstname | |
| lastname | INDEX | None | lastname | |
| group_id | INDEX | None | group_id | |
| lastvisit | INDEX | None | lastvisit | |
| INDEX | None | |||
| user_regdate | INDEX | None | user_regdate | |
| user_lang | INDEX | None | user_lang | |
| user_website | INDEX | None | user_website | |
| user_location | INDEX | None | user_location | |
| user_occupation | INDEX | None | user_occupation | |
| reg_key | INDEX | None | reg_key | |
| user_status | INDEX | None | user_status | |
| user_lang_3 | INDEX | None | user_lang | |
| user_website_3 | INDEX | None | user_website | |
| password_6 | INDEX | None | password | |
| user_id_3 | INDEX | None | user_id | |
| email_4 | INDEX | None | ||
| user_occupation_3 | INDEX | None | user_occupation | |
| lastname_3 | INDEX | None | lastname | |
| username_6 | INDEX | None | username | |
| user_location_3 | INDEX | None | user_location | |
| lastvisit_3 | INDEX | None | lastvisit | |
| group_id_2 | INDEX | None | group_id | |
| firstname_4 | INDEX | None | firstname | |
| user_regdate_4 | INDEX | None | user_regdate | |
| reg_key_6 | INDEX | None | reg_key | |
| user_status_2 | INDEX | None | user_status | |
| username_4 | INDEX | None | username | |
| password_3 | INDEX | None | password | |
| firstname_2 | INDEX | None | firstname | |
| lastname_2 | INDEX | None | lastname | |
| email_3 | INDEX | None | ||
| user_lang_2 | INDEX | None | user_lang | |
| user_website_2 | INDEX | None | user_website | |
| user_location_2 | INDEX | None | user_location | |
| user_occupation_2 | INDEX | None | user_occupation | |
| reg_key_3 | INDEX | None | reg_key | |
| password_5 | INDEX | None | password | |
| firstname_3 | INDEX | None | firstname | |
| reg_key_4 | INDEX | None | reg_key | |
| user_location_4 | INDEX | None | user_location | |
| user_lang_4 | INDEX | None | user_lang | |
| lastname_4 | INDEX | None | lastname | |
| username_7 | INDEX | None | username | |
Space usage :
|
Row Statistic :
|
|||||||||||||||||||||||||||||||