Database: puropartypuroparty
Table: email_customfield_listsemail_customfield_lists
An index has been added on fieldid (Query took 0.0524 sec)
ALTER TABLE `email_customfield_lists` ADD INDEX ( `fieldid` )
 [Edit] [Create PHP Code]

InnoDB free: 774144 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     No    Change Drop Primary Index Unique Fulltext
   int(11)     No    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
email_customfield_lists_field_list_idx UNIQUE Edit Drop fieldid
cflid_2 UNIQUE Edit Drop cflid
cflid_3 UNIQUE Edit Drop cflid
cflid_5 UNIQUE Edit Drop cflid
cflid_8 UNIQUE Edit Drop cflid
cflid_9 UNIQUE Edit Drop cflid
cflid_13 UNIQUE Edit Drop cflid
cflid_14 UNIQUE Edit Drop cflid
cflid_16 UNIQUE Edit Drop cflid
cflid INDEX Edit Drop cflid
fieldid INDEX Edit Drop fieldid
listid INDEX Edit Drop listid
fieldid_2 INDEX Edit Drop fieldid
listid_2 INDEX Edit Drop listid
cflid_4 INDEX Edit Drop cflid
fieldid_3 INDEX Edit Drop fieldid
cflid_6 INDEX Edit Drop cflid
listid_3 INDEX Edit Drop listid
cflid_7 INDEX Edit Drop cflid
fieldid_4 INDEX Edit Drop fieldid
listid_4 INDEX Edit Drop listid
fieldid_5 INDEX Edit Drop fieldid
cflid_10 INDEX Edit Drop cflid
listid_5 INDEX Edit Drop listid
fieldid_6 INDEX Edit Drop fieldid
cflid_11 INDEX Edit Drop cflid
fieldid_7 INDEX Edit Drop fieldid
listid_6 INDEX Edit Drop listid
cflid_12 INDEX Edit Drop cflid
cflid_15 INDEX Edit Drop cflid
fieldid_8 INDEX Edit Drop fieldid
listid_7 INDEX Edit Drop listid
listid_8 INDEX Edit Drop listid
fieldid_9 INDEX Edit Drop fieldid
Create an index on  columns  
Space usage: 
Type Usage
Data 16,384 Bytes
Index 557,056 Bytes
Total 573,440 Bytes
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Next Autoindex 25
Creation Jun 22, 2018 at 03:05 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: