Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_module_trackeremail_module_tracker
An index has been added on statid (Query took 0.0532 sec)
SQL-query: 
ALTER TABLE `email_module_tracker` ADD INDEX ( `statid` )
 [Edit] [Create PHP Code]


InnoDB free: 775168 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   varchar(50) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   int(11)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   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 statid
stattype
trackername
statid_2 UNIQUE Edit Drop statid
statid_4 UNIQUE Edit Drop statid
statid_5 UNIQUE Edit Drop statid
statid_7 UNIQUE Edit Drop statid
statid_10 UNIQUE Edit Drop statid
statid_13 UNIQUE Edit Drop statid
statid_14 UNIQUE Edit Drop statid
statid INDEX Edit Drop statid
stattype INDEX Edit Drop stattype
trackername INDEX Edit Drop trackername
newsletterid INDEX Edit Drop newsletterid
statid_3 INDEX Edit Drop statid
newsletterid_2 INDEX Edit Drop newsletterid
stattype_2 INDEX Edit Drop stattype
trackername_2 INDEX Edit Drop trackername
stattype_3 INDEX Edit Drop stattype
statid_6 INDEX Edit Drop statid
trackername_3 INDEX Edit Drop trackername
newsletterid_3 INDEX Edit Drop newsletterid
statid_8 INDEX Edit Drop statid
stattype_4 INDEX Edit Drop stattype
newsletterid_4 INDEX Edit Drop newsletterid
trackername_4 INDEX Edit Drop trackername
statid_9 INDEX Edit Drop statid
stattype_5 INDEX Edit Drop stattype
statid_11 INDEX Edit Drop statid
newsletterid_5 INDEX Edit Drop newsletterid
trackername_5 INDEX Edit Drop trackername
newsletterid_6 INDEX Edit Drop newsletterid
stattype_6 INDEX Edit Drop stattype
trackername_6 INDEX Edit Drop trackername
statid_12 INDEX Edit Drop statid
stattype_7 INDEX Edit Drop stattype
trackername_7 INDEX Edit Drop trackername
newsletterid_7 INDEX Edit Drop newsletterid
statid_15 INDEX Edit Drop statid
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 589,824 Bytes
Total 606,208 Bytes
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Jun 25, 2018 at 11:59 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: