Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_banned_emailsemail_banned_emails
An index has been added on emailaddress (Query took 0.0692 sec)
SQL-query: 
ALTER TABLE `email_banned_emails` ADD UNIQUE (
`emailaddress`
)
 [Edit] [Create PHP Code]


InnoDB free: 775168 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
PRIMARY PRIMARY Edit Drop banid
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
banid_14 UNIQUE Edit Drop banid
email_banned_emails_list_email_idx UNIQUE Edit Drop list
emailaddress
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
bandate_12 UNIQUE Edit Drop bandate
emailaddress_15 UNIQUE Edit Drop emailaddress
list_16 UNIQUE Edit Drop list
bandate_14 UNIQUE Edit Drop bandate
emailaddress_16 UNIQUE Edit Drop emailaddress
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
banid_13 INDEX Edit Drop banid
emailaddress_14 INDEX Edit Drop emailaddress
list_15 INDEX Edit Drop list
bandate_13 INDEX Edit Drop bandate
banid_15 INDEX Edit Drop banid
bandate_15 INDEX Edit Drop bandate
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 1,008 KB
Total 1,024 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 1
Creation Jun 23, 2018 at 02:14 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: