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

phorum_users

Field Type Null Default
user_id  int(10) No   
username  varchar(50) No   
password  varchar(50) No   
cookie_sessid_lt  varchar(50) No   
sessid_st  varchar(50) No   
sessid_st_timeout  int(10) No 
password_temp  varchar(50) No   
email  varchar(100) No   
email_temp  varchar(110) No   
hide_email  tinyint(1) No 
active  tinyint(1) No 
user_data  text Yes  NULL 
signature  text Yes  NULL 
threaded_list  tinyint(4) No 
posts  int(10) No 
admin  tinyint(1) No 
threaded_read  tinyint(4) No 
date_added  int(10) No 
date_last_active  int(10) No 
last_active_forum  int(10) No 
hide_activity  tinyint(1) No 
show_signature  tinyint(1) No 
email_notify  tinyint(1) No 
pm_email_notify  tinyint(1) No 
tz_offset  tinyint(2) No  -99 
is_dst  tinyint(1) No 
user_language  varchar(100) No   
user_template  varchar(100) No   
moderator_data  text Yes  NULL 
moderation_email  tinyint(2) No 


 Indexes :
Keyname Type Cardinality Field
PRIMARY PRIMARY 1 user_id
username UNIQUE 1 username
user_id_2 UNIQUE 1 user_id
username_3 UNIQUE 1 username
password_2 UNIQUE 1 password
cookie_sessid_lt_3 UNIQUE 1 cookie_sessid_lt
sessid_st_3 UNIQUE 1 sessid_st
sessid_st_timeout_2 UNIQUE 1 sessid_st_timeout
password_temp_2 UNIQUE 1 password_temp
email_2 UNIQUE 1 email
email_temp_3 UNIQUE 1 email_temp
hide_email_2 UNIQUE 1 hide_email
active_3 UNIQUE 1 active
threaded_list_2 UNIQUE 1 threaded_list
posts_2 UNIQUE 1 posts
admin_2 UNIQUE 1 admin
threaded_read_2 UNIQUE 1 threaded_read
date_added_3 UNIQUE 1 date_added
date_last_active_2 UNIQUE 1 date_last_active
last_active_forum_2 UNIQUE 1 last_active_forum
hide_activity_2 UNIQUE 1 hide_activity
show_signature_2 UNIQUE 1 show_signature
email_notify_2 UNIQUE 1 email_notify
pm_email_notify_2 UNIQUE 1 pm_email_notify
tz_offset_2 UNIQUE 1 tz_offset
active INDEX None active
userpass INDEX None username
password
sessid_st INDEX None sessid_st
cookie_sessid_lt INDEX None cookie_sessid_lt
activity INDEX None date_last_active
hide_activity
last_active_forum
date_added INDEX None date_added
email_temp INDEX None email_temp
user_id INDEX None user_id
username_2 INDEX None username
password INDEX None password
cookie_sessid_lt_2 INDEX None cookie_sessid_lt
sessid_st_2 INDEX None sessid_st
sessid_st_timeout INDEX None sessid_st_timeout
password_temp INDEX None password_temp
email INDEX None email
email_temp_2 INDEX None email_temp
hide_email INDEX None hide_email
active_2 INDEX None active
threaded_list INDEX None threaded_list
posts INDEX None posts
admin INDEX None admin
threaded_read INDEX None threaded_read
date_added_2 INDEX None date_added
date_last_active INDEX None date_last_active
last_active_forum INDEX None last_active_forum
hide_activity INDEX None hide_activity
show_signature INDEX None show_signature
email_notify INDEX None email_notify
pm_email_notify INDEX None pm_email_notify
tz_offset INDEX None tz_offset
username_4 INDEX None username
password_3 INDEX None password
cookie_sessid_lt_4 INDEX None cookie_sessid_lt
sessid_st_4 INDEX None sessid_st
password_temp_3 INDEX None password_temp
email_3 INDEX None email
email_temp_4 INDEX None email_temp
user_data INDEX None user_data
signature INDEX None signature


 Space usage :
Type Usage
Data 160 Bytes
Index 4,096 Bytes
Total 4,256 Bytes
   Row Statistic :
Statements Value
Format dynamic
Rows 1
Row length ø 160
Row size  ø 4,256 Bytes
Next Autoindex 2
Creation Oct 09, 2017 at 12:13 AM
Last update Oct 09, 2017 at 12:13 AM