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

jos_users

Field Type Null Default
id  int(11) No   
name  varchar(255) No   
username  varchar(150) No   
email  varchar(100) No   
password  varchar(100) No   
usertype  varchar(25) No   
block  tinyint(4) No 
sendEmail  tinyint(4) Yes 
gid  tinyint(3) No 
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   


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 id
id_2 UNIQUE 1 id
name_2 UNIQUE 1 name
username_3 UNIQUE 1 username
email_3 UNIQUE 1 email
password_2 UNIQUE 1 password
usertype_3 UNIQUE 1 usertype
block_2 UNIQUE 1 block
gid_2 UNIQUE 1 gid
registerDate_2 UNIQUE 1 registerDate
lastvisitDate_2 UNIQUE 1 lastvisitDate
activation_2 UNIQUE 1 activation
activation_4 UNIQUE 1 activation
name_4 UNIQUE 1 name
id_3 UNIQUE 1 id
password_4 UNIQUE 1 password
block_3 UNIQUE 1 block
email_5 UNIQUE 1 email
username_7 UNIQUE 1 username
lastvisitDate_3 UNIQUE 1 lastvisitDate
usertype_6 UNIQUE 1 usertype
sendEmail_2 UNIQUE None sendEmail
usertype INDEX None usertype
idx_name INDEX None name
gid_block INDEX None gid
block
username INDEX None username
email INDEX None email
id INDEX None id
name INDEX None name
username_2 INDEX None username
email_2 INDEX None email
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
activation_5 INDEX None activation
username_5 INDEX None username
email_6 INDEX None email
id_4 INDEX None id
sendEmail_3 INDEX None sendEmail
block_4 INDEX None block
password_6 INDEX None password
gid_3 INDEX None gid
registerDate_3 INDEX None registerDate
usertype_7 INDEX None usertype
name_6 INDEX None name
lastvisitDate_4 INDEX None lastvisitDate
name_3 INDEX None name
username_4 INDEX None username
email_4 INDEX None email
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_5 INDEX None name
password_5 INDEX None password
username_6 INDEX None username
email_7 INDEX None email
activation_6 INDEX None activation


 Space usage :
Type Usage
Data 156 Bytes
Index 4,096 Bytes
Total 4,252 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 1
Row length ø 156
Row size  ø 4,252 Bytes
Next Autoindex 63
Creation Oct 23, 2017 at 07:51 AM
Last update Mar 24, 2018 at 12:38 AM
Last check Mar 24, 2018 at 12:38 AM