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

InnoDB free: 776192 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(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(20) 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
   char(1) utf8_general_ci   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
   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
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      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 16  Edit Drop listid
listid_2 UNIQUE 16  Edit Drop listid
listid_4 UNIQUE 16  Edit Drop listid
listid_6 UNIQUE 16  Edit Drop listid
name_2 UNIQUE 16  Edit Drop name
createdate_2 UNIQUE 16  Edit Drop createdate
name_3 UNIQUE 16  Edit Drop name
createdate_3 UNIQUE 16  Edit Drop createdate
createdate_5 UNIQUE 16  Edit Drop createdate
email_lists_owner_idx INDEX Edit Drop ownerid
listid INDEX 16  Edit Drop listid
name INDEX 16  Edit Drop name
ownername INDEX Edit Drop ownername
owneremail INDEX Edit Drop owneremail
bounceemail INDEX Edit Drop bounceemail
replytoemail INDEX Edit Drop replytoemail
bounceserver INDEX Edit Drop bounceserver
bounceusername INDEX Edit Drop bounceusername
bouncepassword INDEX Edit Drop bouncepassword
extramailsettings INDEX Edit Drop extramailsettings
companyname INDEX Edit Drop companyname
companyaddress INDEX Edit Drop companyaddress
companyphone INDEX Edit Drop companyphone
format INDEX Edit Drop format
notifyowner INDEX Edit Drop notifyowner
imapaccount INDEX Edit Drop imapaccount
createdate INDEX 16  Edit Drop createdate
subscribecount INDEX 16  Edit Drop subscribecount
unsubscribecount INDEX 16  Edit Drop unsubscribecount
bouncecount INDEX Edit Drop bouncecount
processbounce INDEX Edit Drop processbounce
agreedelete INDEX Edit Drop agreedelete
ownerid INDEX Edit Drop ownerid
replytoemail_2 INDEX Edit Drop replytoemail
bounceemail_2 INDEX Edit Drop bounceemail
companyname_2 INDEX Edit Drop companyname
extramailsettings_2 INDEX Edit Drop extramailsettings
processbounce_2 INDEX Edit Drop processbounce
unsubscribecount_2 INDEX 16  Edit Drop unsubscribecount
bouncecount_2 INDEX Edit Drop bouncecount
bouncepassword_2 INDEX Edit Drop bouncepassword
ownerid_2 INDEX Edit Drop ownerid
bounceusername_2 INDEX Edit Drop bounceusername
companyaddress_2 INDEX Edit Drop companyaddress
name_4 INDEX 16  Edit Drop name
listid_3 INDEX 16  Edit Drop listid
agreedelete_2 INDEX Edit Drop agreedelete
ownername_2 INDEX Edit Drop ownername
bounceserver_2 INDEX Edit Drop bounceserver
owneremail_2 INDEX Edit Drop owneremail
subscribecount_2 INDEX 16  Edit Drop subscribecount
format_2 INDEX Edit Drop format
notifyowner_2 INDEX Edit Drop notifyowner
createdate_4 INDEX 16  Edit Drop createdate
companyphone_2 INDEX Edit Drop companyphone
imapaccount_2 INDEX Edit Drop imapaccount
bounceserver_3 INDEX Edit Drop bounceserver
listid_5 INDEX 16  Edit Drop listid
replytoemail_3 INDEX Edit Drop replytoemail
extramailsettings_3 INDEX Edit Drop extramailsettings
bounceusername_3 INDEX Edit Drop bounceusername
name_5 INDEX 16  Edit Drop name
ownerid_3 INDEX Edit Drop ownerid
bounceemail_3 INDEX Edit Drop bounceemail
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 19
Creation Jun 12, 2018 at 03:29 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: