Server: mysql.puroparty.com | Database: puroparty | Table: extcal_users |
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 | 25 | user_id | |
username | UNIQUE | 25 | username | |
user_id_2 | UNIQUE | 25 | user_id | |
username_3 | UNIQUE | 25 | username | |
lastvisit_2 | UNIQUE | 25 | lastvisit | |
email_2 | UNIQUE | 25 | ||
user_regdate_2 | UNIQUE | 25 | user_regdate | |
user_regdate_3 | UNIQUE | 25 | user_regdate | |
lastvisit_4 | UNIQUE | 25 | lastvisit | |
username_7 | UNIQUE | 25 | username | |
user_id_4 | UNIQUE | 25 | user_id | |
email_5 | UNIQUE | 25 | ||
username_8 | UNIQUE | 25 | username | |
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 | |
firstname_3 | INDEX | None | firstname | |
user_id_3 | INDEX | None | user_id | |
lastvisit_3 | INDEX | None | lastvisit | |
username_5 | INDEX | None | username | |
reg_key_3 | INDEX | None | reg_key | |
lastname_4 | INDEX | None | lastname | |
password_3 | INDEX | None | password | |
user_regdate_4 | INDEX | None | user_regdate | |
group_id_2 | INDEX | None | group_id | |
user_status_2 | INDEX | None | user_status | |
user_lang_4 | INDEX | None | user_lang | |
user_occupation_4 | INDEX | None | user_occupation | |
user_website_4 | INDEX | None | user_website | |
email_6 | INDEX | None | ||
user_location_3 | INDEX | None | user_location | |
user_website_5 | INDEX | None | user_website | |
username_4 | INDEX | None | username | |
password_2 | 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_2 | INDEX | None | reg_key | |
lastname_3 | INDEX | None | lastname | |
firstname_4 | INDEX | None | firstname | |
username_6 | INDEX | None | username | |
email_4 | INDEX | None | ||
user_occupation_3 | INDEX | None | user_occupation | |
user_lang_3 | INDEX | None | user_lang | |
reg_key_4 | INDEX | None | reg_key | |
user_website_3 | INDEX | None | user_website | |
password_4 | INDEX | None | password | |
reg_key_5 | INDEX | None | reg_key |
Space usage :
|
Row Statistic :
|