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

InnoDB free: 773120 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
   varchar(200) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   varchar(32) utf8_general_ci   Yes  NULL    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    Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   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    Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    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 36773  Edit Drop subscriberid
subscriberid_2 UNIQUE 36773  Edit Drop subscriberid
subscriberid_4 UNIQUE 36773  Edit Drop subscriberid
subscriberid_6 UNIQUE 36773  Edit Drop subscriberid
email_subscribers_email_list_idx UNIQUE 36773  Edit Drop emailaddress
listid
confirmcode_2 UNIQUE 36773  Edit Drop confirmcode
confirmcode_3 UNIQUE 36773  Edit Drop confirmcode
confirmcode_5 UNIQUE 36773  Edit Drop confirmcode
email_list_subscribers_sub_list_idx INDEX 36773  Edit Drop subscriberid
listid
email_subscribe_date_idx INDEX 1414  Edit Drop subscribedate
subscriberid INDEX 36773  Edit Drop subscriberid
listid INDEX 49  Edit Drop listid
emailaddress INDEX 36773  Edit Drop emailaddress
domainname INDEX 9193  Edit Drop domainname
format INDEX Edit Drop format
confirmed INDEX Edit Drop confirmed
confirmcode INDEX 36773  Edit Drop confirmcode
requestdate INDEX 3677  Edit Drop requestdate
requestip INDEX Edit Drop requestip
confirmdate INDEX 2451  Edit Drop confirmdate
confirmip INDEX Edit Drop confirmip
confirmip_2 INDEX Edit Drop confirmip
subscribedate INDEX 1935  Edit Drop subscribedate
bounced INDEX Edit Drop bounced
unsubscribed INDEX Edit Drop unsubscribed
unsubscribeconfirmed INDEX Edit Drop unsubscribeconfirmed
formid INDEX Edit Drop formid
emailaddress_2 INDEX 36773  Edit Drop emailaddress
requestip_2 INDEX Edit Drop requestip
listid_2 INDEX 79  Edit Drop listid
confirmip_3 INDEX Edit Drop confirmip
subscribedate_2 INDEX 2828  Edit Drop subscribedate
format_2 INDEX Edit Drop format
confirmed_2 INDEX Edit Drop confirmed
requestdate_2 INDEX 3677  Edit Drop requestdate
subscriberid_3 INDEX 36773  Edit Drop subscriberid
unsubscribed_2 INDEX 11  Edit Drop unsubscribed
unsubscribeconfirmed_2 INDEX Edit Drop unsubscribeconfirmed
confirmdate_2 INDEX 1935  Edit Drop confirmdate
formid_2 INDEX Edit Drop formid
domainname_2 INDEX 9193  Edit Drop domainname
confirmcode_4 INDEX 36773  Edit Drop confirmcode
bounced_2 INDEX Edit Drop bounced
confirmip_4 INDEX Edit Drop confirmip
requestip_3 INDEX Edit Drop requestip
emailaddress_3 INDEX 36773  Edit Drop emailaddress
listid_3 INDEX 49  Edit Drop listid
subscribedate_3 INDEX 2163  Edit Drop subscribedate
confirmip_5 INDEX Edit Drop confirmip
confirmed_3 INDEX Edit Drop confirmed
unsubscribed_3 INDEX 3064  Edit Drop unsubscribed
subscriberid_5 INDEX 36773  Edit Drop subscriberid
unsubscribeconfirmed_3 INDEX Edit Drop unsubscribeconfirmed
format_3 INDEX Edit Drop format
requestdate_3 INDEX 2626  Edit Drop requestdate
confirmdate_3 INDEX 2042  Edit Drop confirmdate
formid_3 INDEX Edit Drop formid
bounced_3 INDEX Edit Drop bounced
domainname_3 INDEX 12257  Edit Drop domainname
confirmcode_6 INDEX 36773  Edit Drop confirmcode
subscribedate_4 INDEX 2451  Edit Drop subscribedate
confirmcode_7 INDEX 36773  Edit Drop confirmcode
bounced_4 INDEX Edit Drop bounced
confirmed_4 INDEX Edit Drop confirmed
Create an index on  columns  
 
Space usage: 
Type Usage
Data 6,672 KB
Index 99,200 KB
Total 105,872 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 36,582
Creation Mar 19, 2018 at 05:47 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: