Database: puropartypuroparty
Table: email_banned_emailsemail_banned_emails
An index has been added on bandate (Query took 0.0406 sec)
ALTER TABLE `email_banned_emails` ADD UNIQUE (
 [Edit] [Create PHP Code]

InnoDB free: 799744 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(10) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes  NULL    Change Drop Primary Index Unique Fulltext
With selected: Check All  /  Uncheck All     With selected:  

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

Indexes: Documentation
Keyname Type Cardinality Action Field
banid_2 UNIQUE Edit Drop banid
banid_3 UNIQUE Edit Drop banid
banid_6 UNIQUE Edit Drop banid
banid_8 UNIQUE Edit Drop banid
banid_9 UNIQUE Edit Drop banid
banid_11 UNIQUE Edit Drop banid
email_banned_emails_list_email_idx UNIQUE Edit Drop list
emailaddress_2 UNIQUE Edit Drop emailaddress
list_2 UNIQUE Edit Drop list
bandate_2 UNIQUE Edit Drop bandate
list_3 UNIQUE Edit Drop list
emailaddress_3 UNIQUE Edit Drop emailaddress
bandate_3 UNIQUE Edit Drop bandate
emailaddress_5 UNIQUE Edit Drop emailaddress
bandate_5 UNIQUE Edit Drop bandate
list_6 UNIQUE Edit Drop list
emailaddress_8 UNIQUE Edit Drop emailaddress
list_8 UNIQUE Edit Drop list
bandate_8 UNIQUE Edit Drop bandate
emailaddress_9 UNIQUE Edit Drop emailaddress
list_9 UNIQUE Edit Drop list
bandate_9 UNIQUE Edit Drop bandate
emailaddress_11 UNIQUE Edit Drop emailaddress
list_11 UNIQUE Edit Drop list
emailaddress_12 UNIQUE Edit Drop emailaddress
list_14 UNIQUE Edit Drop list
bandate_11 UNIQUE Edit Drop bandate
banid INDEX Edit Drop banid
emailaddress INDEX Edit Drop emailaddress
list INDEX Edit Drop list
bandate INDEX Edit Drop bandate
emailaddress_4 INDEX Edit Drop emailaddress
list_4 INDEX Edit Drop list
banid_4 INDEX Edit Drop banid
bandate_4 INDEX Edit Drop bandate
list_5 INDEX Edit Drop list
banid_5 INDEX Edit Drop banid
bandate_6 INDEX Edit Drop bandate
emailaddress_6 INDEX Edit Drop emailaddress
banid_7 INDEX Edit Drop banid
emailaddress_7 INDEX Edit Drop emailaddress
list_7 INDEX Edit Drop list
bandate_7 INDEX Edit Drop bandate
emailaddress_10 INDEX Edit Drop emailaddress
list_10 INDEX Edit Drop list
banid_10 INDEX Edit Drop banid
bandate_10 INDEX Edit Drop bandate
list_12 INDEX Edit Drop list
list_13 INDEX Edit Drop list
emailaddress_13 INDEX Edit Drop emailaddress
banid_12 INDEX Edit Drop banid
Create an index on  columns  
Space usage: 
Type Usage
Data 16,384 Bytes
Index 835,584 Bytes
Total 851,968 Bytes
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 1
Creation Mar 23, 2018 at 06:55 PM

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