Server: mysql.puroparty.commysql.puroparty.com
Database: puropartypuroparty
Table: email_autorespondersemail_autoresponders
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0039 sec)
SQL-query: 
SELECT *
FROM `email_autoresponders`
LIMIT 0 , 30
 [Edit] [Explain SQL] [Create PHP Code] [Refresh]


InnoDB free: 781312 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
   char(1) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext 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
   int(11)     No    Change Drop Primary Index Unique Fulltext
   mediumtext utf8_general_ci   Yes  NULL    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
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    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(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(255) utf8_general_ci   Yes  NULL    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
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 autoresponderid
autoresponderid_2 UNIQUE Edit Drop autoresponderid
ownerid_2 UNIQUE Edit Drop ownerid
autoresponderid_3 UNIQUE Edit Drop autoresponderid
name_2 UNIQUE Edit Drop name
subject_2 UNIQUE Edit Drop subject
format_2 UNIQUE Edit Drop format
createdate_2 UNIQUE Edit Drop createdate
active_2 UNIQUE Edit Drop active
hoursaftersubscription_2 UNIQUE Edit Drop hoursaftersubscription
listid_2 UNIQUE Edit Drop listid
tracklinks_2 UNIQUE Edit Drop tracklinks
trackopens_2 UNIQUE Edit Drop trackopens
multipart_2 UNIQUE Edit Drop multipart
queueid_2 UNIQUE Edit Drop queueid
sendfromname_2 UNIQUE Edit Drop sendfromname
sendfromemail_2 UNIQUE Edit Drop sendfromemail
replytoemail_2 UNIQUE Edit Drop replytoemail
bounceemail_2 UNIQUE Edit Drop bounceemail
charset_2 UNIQUE Edit Drop charset
embedimages_2 UNIQUE Edit Drop embedimages
to_firstname_2 UNIQUE Edit Drop to_firstname
to_lastname_2 UNIQUE Edit Drop to_lastname
autorespondersize_2 UNIQUE Edit Drop autorespondersize
bounceemail_3 UNIQUE Edit Drop bounceemail
format_3 UNIQUE Edit Drop format
multipart_3 UNIQUE Edit Drop multipart
trackopens_3 UNIQUE Edit Drop trackopens
name_4 UNIQUE Edit Drop name
createdate_3 UNIQUE Edit Drop createdate
email_autoresponders_owner_idx INDEX Edit Drop ownerid
email_autoresponders_list_idx INDEX Edit Drop listid
email_autoresponders_queue_idx INDEX Edit Drop queueid
autoresponderid INDEX Edit Drop autoresponderid
name INDEX Edit Drop name
subject INDEX Edit Drop subject
format INDEX Edit Drop format
createdate INDEX Edit Drop createdate
active INDEX Edit Drop active
hoursaftersubscription INDEX Edit Drop hoursaftersubscription
ownerid INDEX Edit Drop ownerid
listid INDEX Edit Drop listid
tracklinks INDEX Edit Drop tracklinks
trackopens INDEX Edit Drop trackopens
multipart INDEX Edit Drop multipart
queueid INDEX Edit Drop queueid
sendfromname INDEX Edit Drop sendfromname
sendfromemail INDEX Edit Drop sendfromemail
replytoemail INDEX Edit Drop replytoemail
bounceemail INDEX Edit Drop bounceemail
charset INDEX Edit Drop charset
embedimages INDEX Edit Drop embedimages
to_firstname INDEX Edit Drop to_firstname
to_lastname INDEX Edit Drop to_lastname
autorespondersize INDEX Edit Drop autorespondersize
name_3 INDEX Edit Drop name
autorespondersize_3 INDEX Edit Drop autorespondersize
sendfromemail_3 INDEX Edit Drop sendfromemail
active_3 INDEX Edit Drop active
tracklinks_3 INDEX Edit Drop tracklinks
to_lastname_3 INDEX Edit Drop to_lastname
queueid_3 INDEX Edit Drop queueid
ownerid_3 INDEX Edit Drop ownerid
subject_3 INDEX Edit Drop subject
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 04, 2018 at 03:21 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: