Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: extcal_2usersextcal_2users

extcal_2users

Table comments : Table for calendar 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 
lastvisit  datetime No  0000-00-00 00:00:00 
email  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 


 Indexes :
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 email
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 email
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
email INDEX None email
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 email
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 email
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 :
Type Usage
Data 916 Bytes
Index 4,096 Bytes
Total 5,012 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 7
Row length ø 130
Row size  ø 716 Bytes
Next Autoindex 8
Creation Oct 23, 2017 at 11:21 AM
Last update Apr 01, 2018 at 12:30 AM
Last check Apr 01, 2018 at 12:30 AM