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

   Field  Type Collation Attributes Null Default Extra Action
   int(10)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   varchar(50) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(110) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   int(10)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(4)     No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   int(10)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     No  -99    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) latin1_swedish_ci   No      Change Drop Primary Index Unique Fulltext
   text latin1_swedish_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   tinyint(2)   UNSIGNED No    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

Print viewPrint view    Propose table structurePropose table structureDocumentation
Add new fieldAdd new field: 


Indexes: Documentation
Keyname Type Cardinality Action Field
PRIMARY PRIMARY Edit Drop user_id
username UNIQUE Edit Drop username
user_id_2 UNIQUE Edit Drop user_id
username_3 UNIQUE Edit Drop username
password_2 UNIQUE Edit Drop password
cookie_sessid_lt_3 UNIQUE Edit Drop cookie_sessid_lt
sessid_st_3 UNIQUE Edit Drop sessid_st
sessid_st_timeout_2 UNIQUE Edit Drop sessid_st_timeout
password_temp_2 UNIQUE Edit Drop password_temp
email_2 UNIQUE Edit Drop email
email_temp_3 UNIQUE Edit Drop email_temp
hide_email_2 UNIQUE Edit Drop hide_email
active_3 UNIQUE Edit Drop active
threaded_list_2 UNIQUE Edit Drop threaded_list
posts_2 UNIQUE Edit Drop posts
admin_2 UNIQUE Edit Drop admin
threaded_read_2 UNIQUE Edit Drop threaded_read
date_added_3 UNIQUE Edit Drop date_added
date_last_active_2 UNIQUE Edit Drop date_last_active
last_active_forum_2 UNIQUE Edit Drop last_active_forum
hide_activity_2 UNIQUE Edit Drop hide_activity
show_signature_2 UNIQUE Edit Drop show_signature
email_notify_2 UNIQUE Edit Drop email_notify
pm_email_notify_2 UNIQUE Edit Drop pm_email_notify
tz_offset_2 UNIQUE Edit Drop tz_offset
active INDEX None  Edit Drop active
userpass INDEX None  Edit Drop username
password
sessid_st INDEX None  Edit Drop sessid_st
cookie_sessid_lt INDEX None  Edit Drop cookie_sessid_lt
activity INDEX None  Edit Drop date_last_active
hide_activity
last_active_forum
date_added INDEX None  Edit Drop date_added
email_temp INDEX None  Edit Drop email_temp
user_id INDEX None  Edit Drop user_id
username_2 INDEX None  Edit Drop username
password INDEX None  Edit Drop password
cookie_sessid_lt_2 INDEX None  Edit Drop cookie_sessid_lt
sessid_st_2 INDEX None  Edit Drop sessid_st
sessid_st_timeout INDEX None  Edit Drop sessid_st_timeout
password_temp INDEX None  Edit Drop password_temp
email INDEX None  Edit Drop email
email_temp_2 INDEX None  Edit Drop email_temp
hide_email INDEX None  Edit Drop hide_email
active_2 INDEX None  Edit Drop active
threaded_list INDEX None  Edit Drop threaded_list
posts INDEX None  Edit Drop posts
admin INDEX None  Edit Drop admin
threaded_read INDEX None  Edit Drop threaded_read
date_added_2 INDEX None  Edit Drop date_added
date_last_active INDEX None  Edit Drop date_last_active
last_active_forum INDEX None  Edit Drop last_active_forum
hide_activity INDEX None  Edit Drop hide_activity
show_signature INDEX None  Edit Drop show_signature
email_notify INDEX None  Edit Drop email_notify
pm_email_notify INDEX None  Edit Drop pm_email_notify
tz_offset INDEX None  Edit Drop tz_offset
username_4 FULLTEXT None  Edit Drop username
password_3 FULLTEXT None  Edit Drop password
cookie_sessid_lt_4 FULLTEXT None  Edit Drop cookie_sessid_lt
sessid_st_4 FULLTEXT None  Edit Drop sessid_st
password_temp_3 FULLTEXT None  Edit Drop password_temp
email_3 FULLTEXT None  Edit Drop email
email_temp_4 FULLTEXT None  Edit Drop email_temp
user_data FULLTEXT None  Edit Drop user_data
signature FULLTEXT None  Edit Drop signature
Create an index on  columns  
 
Space usage: 
Type Usage
Data 160 Bytes
Index 4,096 Bytes
Total 4,256 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation latin1_swedish_ci
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

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
  Compression:
                
Character set of the file: