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

   Field  Type Collation Attributes Null Default Extra Action
   varchar(200) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(60) 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
   datetime     No  0000-00-00 00:00:00    Change Drop Primary Index Unique Fulltext
   tinyint(1)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   Yes  NULL    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 path
path_2 UNIQUE Edit Drop path
user_login_2 UNIQUE Edit Drop user_login
user_email_2 UNIQUE Edit Drop user_email
registered_2 UNIQUE Edit Drop registered
activated_2 UNIQUE Edit Drop activated
activation_key_3 UNIQUE Edit Drop activation_key
user_login_4 UNIQUE Edit Drop user_login
user_email_4 UNIQUE Edit Drop user_email
path_4 UNIQUE Edit Drop path
registered_3 UNIQUE Edit Drop registered
activation_key_6 UNIQUE Edit Drop activation_key
activated_4 UNIQUE Edit Drop activated
user_login_7 UNIQUE Edit Drop user_login
user_email_9 UNIQUE Edit Drop user_email
registered_5 UNIQUE Edit Drop registered
path_8 UNIQUE Edit Drop path
activation_key_10 UNIQUE Edit Drop activation_key
activated_6 UNIQUE Edit Drop activated
activation_key INDEX None  Edit Drop activation_key
domain INDEX None  Edit Drop domain
domain_2 INDEX None  Edit Drop domain
path INDEX None  Edit Drop path
user_login INDEX None  Edit Drop user_login
user_email INDEX None  Edit Drop user_email
registered INDEX None  Edit Drop registered
activated INDEX None  Edit Drop activated
active INDEX None  Edit Drop active
activation_key_2 INDEX None  Edit Drop activation_key
path_5 INDEX None  Edit Drop path
registered_4 INDEX None  Edit Drop registered
active_2 INDEX None  Edit Drop active
activated_3 INDEX None  Edit Drop activated
domain_5 INDEX None  Edit Drop domain
activation_key_7 INDEX None  Edit Drop activation_key
user_login_6 INDEX None  Edit Drop user_login
user_email_6 INDEX None  Edit Drop user_email
user_email_8 INDEX None  Edit Drop user_email
domain_6 INDEX None  Edit Drop domain
activation_key_9 INDEX None  Edit Drop activation_key
registered_6 INDEX None  Edit Drop registered
user_login_9 INDEX None  Edit Drop user_login
path_9 INDEX None  Edit Drop path
activated_5 INDEX None  Edit Drop activated
domain_3 FULLTEXT None  Edit Drop domain
path_3 FULLTEXT None  Edit Drop path
title FULLTEXT None  Edit Drop title
user_login_3 FULLTEXT None  Edit Drop user_login
user_email_3 FULLTEXT None  Edit Drop user_email
activation_key_4 FULLTEXT None  Edit Drop activation_key
meta FULLTEXT None  Edit Drop meta
domain_4 FULLTEXT None  Edit Drop domain
meta_2 FULLTEXT None  Edit Drop meta
activation_key_5 FULLTEXT None  Edit Drop activation_key
user_login_5 FULLTEXT None  Edit Drop user_login
user_email_5 FULLTEXT None  Edit Drop user_email
path_6 FULLTEXT None  Edit Drop path
title_2 FULLTEXT None  Edit Drop title
user_email_7 FULLTEXT None  Edit Drop user_email
activation_key_8 FULLTEXT None  Edit Drop activation_key
user_login_8 FULLTEXT None  Edit Drop user_login
meta_3 FULLTEXT None  Edit Drop meta
path_7 FULLTEXT None  Edit Drop path
title_3 FULLTEXT None  Edit Drop title
Create an index on  columns  
 
Space usage: 
Type Usage
Data 612 Bytes
Index 3,072 Bytes
Total 3,684 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Rows 4
Row length ø 153
Row size  ø 921 Bytes
Creation Nov 04, 2017 at 06:48 PM
Last update Nov 04, 2017 at 06:48 PM

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: