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

   Field  Type Collation Attributes Null Default Extra Action
   bigint(20)   UNSIGNED No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(60) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(64) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   varchar(60) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(250) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   tinyint(2)     No    Change Drop Primary Index Unique Fulltext
   tinyint(2)     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 ID
ID_2 UNIQUE Edit Drop ID
user_login_2 UNIQUE Edit Drop user_login
user_pass_2 UNIQUE Edit Drop user_pass
user_nicename_3 UNIQUE Edit Drop user_nicename
user_email_2 UNIQUE Edit Drop user_email
user_registered_2 UNIQUE Edit Drop user_registered
display_name_2 UNIQUE Edit Drop display_name
user_pass_4 UNIQUE Edit Drop user_pass
user_registered_3 UNIQUE Edit Drop user_registered
user_nicename_7 UNIQUE Edit Drop user_nicename
display_name_6 UNIQUE Edit Drop display_name
ID_4 UNIQUE Edit Drop ID
user_email_6 UNIQUE Edit Drop user_email
user_login_6 UNIQUE Edit Drop user_login
user_registered_5 UNIQUE Edit Drop user_registered
user_login_key INDEX None  Edit Drop user_login
user_nicename INDEX None  Edit Drop user_nicename
ID INDEX None  Edit Drop ID
user_login INDEX None  Edit Drop user_login
user_pass INDEX None  Edit Drop user_pass
user_nicename_2 INDEX None  Edit Drop user_nicename
user_email INDEX None  Edit Drop user_email
user_url INDEX None  Edit Drop user_url
user_registered INDEX None  Edit Drop user_registered
user_activation_key INDEX None  Edit Drop user_activation_key
user_status INDEX None  Edit Drop user_status
display_name INDEX None  Edit Drop display_name
spam INDEX None  Edit Drop spam
deleted INDEX None  Edit Drop deleted
user_email_4 INDEX None  Edit Drop user_email
ID_3 INDEX None  Edit Drop ID
user_login_4 INDEX None  Edit Drop user_login
user_nicename_6 INDEX None  Edit Drop user_nicename
spam_2 INDEX None  Edit Drop spam
user_activation_key_4 INDEX None  Edit Drop user_activation_key
user_url_3 INDEX None  Edit Drop user_url
user_status_2 INDEX None  Edit Drop user_status
display_name_5 INDEX None  Edit Drop display_name
user_pass_6 INDEX None  Edit Drop user_pass
deleted_2 INDEX None  Edit Drop deleted
user_registered_4 INDEX None  Edit Drop user_registered
ID_5 INDEX None  Edit Drop ID
spam_3 INDEX None  Edit Drop spam
user_email_7 INDEX None  Edit Drop user_email
user_status_3 INDEX None  Edit Drop user_status
user_activation_key_5 INDEX None  Edit Drop user_activation_key
user_login_3 FULLTEXT None  Edit Drop user_login
user_pass_3 FULLTEXT None  Edit Drop user_pass
user_nicename_4 FULLTEXT None  Edit Drop user_nicename
user_email_3 FULLTEXT None  Edit Drop user_email
user_url_2 FULLTEXT None  Edit Drop user_url
user_activation_key_2 FULLTEXT None  Edit Drop user_activation_key
display_name_3 FULLTEXT None  Edit Drop display_name
user_nicename_5 FULLTEXT None  Edit Drop user_nicename
user_activation_key_3 FULLTEXT None  Edit Drop user_activation_key
user_pass_5 FULLTEXT None  Edit Drop user_pass
display_name_4 FULLTEXT None  Edit Drop display_name
user_email_5 FULLTEXT None  Edit Drop user_email
user_login_5 FULLTEXT None  Edit Drop user_login
user_url_4 FULLTEXT None  Edit Drop user_url
user_url_5 FULLTEXT None  Edit Drop user_url
user_nicename_8 FULLTEXT None  Edit Drop user_nicename
user_pass_7 FULLTEXT None  Edit Drop user_pass
Create an index on  columns  
 
Space usage: 
Type Usage
Data 644 Bytes
Index 3,072 Bytes
Total 3,716 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 6
Row length ø 107
Row size  ø 619 Bytes
Next Autoindex 7
Creation Dec 14, 2017 at 03:33 AM
Last update Dec 14, 2017 at 03:33 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: