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

InnoDB free: 780288 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) 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 forwardid
forwardid_2 UNIQUE Edit Drop forwardid
forwardid_4 UNIQUE Edit Drop forwardid
forwardid_6 UNIQUE Edit Drop forwardid
forwardtime_2 UNIQUE Edit Drop forwardtime
forwardip_2 UNIQUE Edit Drop forwardip
subscriberid_2 UNIQUE Edit Drop subscriberid
statid_2 UNIQUE Edit Drop statid
subscribed_2 UNIQUE Edit Drop subscribed
listid_2 UNIQUE Edit Drop listid
emailaddress_2 UNIQUE Edit Drop emailaddress
statid_3 UNIQUE Edit Drop statid
forwardip_3 UNIQUE Edit Drop forwardip
forwardtime_3 UNIQUE Edit Drop forwardtime
subscribed_4 UNIQUE Edit Drop subscribed
listid_4 UNIQUE Edit Drop listid
emailaddress_4 UNIQUE Edit Drop emailaddress
subscriberid_4 UNIQUE Edit Drop subscriberid
forwardip_5 UNIQUE Edit Drop forwardip
subscriberid_5 UNIQUE Edit Drop subscriberid
emailaddress_5 UNIQUE Edit Drop emailaddress
forwardtime_5 UNIQUE Edit Drop forwardtime
subscribed_6 UNIQUE Edit Drop subscribed
statid_6 UNIQUE Edit Drop statid
listid_6 UNIQUE Edit Drop listid
listid_7 UNIQUE Edit Drop listid
statid_7 UNIQUE Edit Drop statid
emailaddress_8 UNIQUE Edit Drop emailaddress
subscribed_8 UNIQUE Edit Drop subscribed
forwardip_7 UNIQUE Edit Drop forwardip
forwardtime_7 UNIQUE Edit Drop forwardtime
subscriberid_8 UNIQUE Edit Drop subscriberid
email_stats_emailforwards_subscriberid_idx INDEX Edit Drop subscriberid
email_stats_emailforwards_statid_idx INDEX Edit Drop statid
email_stats_emailforwards_listid_idx INDEX Edit Drop listid
forwardid INDEX Edit Drop forwardid
forwardtime INDEX Edit Drop forwardtime
forwardip INDEX Edit Drop forwardip
subscriberid INDEX Edit Drop subscriberid
statid INDEX Edit Drop statid
subscribed INDEX Edit Drop subscribed
listid INDEX Edit Drop listid
emailaddress INDEX Edit Drop emailaddress
statid_4 INDEX Edit Drop statid
subscribed_3 INDEX Edit Drop subscribed
forwardtime_4 INDEX Edit Drop forwardtime
listid_3 INDEX Edit Drop listid
forwardid_3 INDEX Edit Drop forwardid
emailaddress_3 INDEX Edit Drop emailaddress
subscriberid_3 INDEX Edit Drop subscriberid
forwardip_4 INDEX Edit Drop forwardip
forwardid_5 INDEX Edit Drop forwardid
emailaddress_6 INDEX Edit Drop emailaddress
subscriberid_6 INDEX Edit Drop subscriberid
statid_5 INDEX Edit Drop statid
listid_5 INDEX Edit Drop listid
subscribed_5 INDEX Edit Drop subscribed
forwardtime_6 INDEX Edit Drop forwardtime
forwardip_6 INDEX Edit Drop forwardip
emailaddress_7 INDEX Edit Drop emailaddress
subscribed_7 INDEX Edit Drop subscribed
listid_8 INDEX Edit Drop listid
subscriberid_7 INDEX Edit Drop subscriberid
statid_8 INDEX Edit Drop statid
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 Mar 15, 2018 at 06:22 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: