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

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(100) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext 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
   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
   longtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   longtext 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 pageid
pageid_2 UNIQUE Edit Drop pageid
pageid_3 UNIQUE Edit Drop pageid
pageid_6 UNIQUE Edit Drop pageid
pageid_7 UNIQUE Edit Drop pageid
pageid_10 UNIQUE Edit Drop pageid
pageid_11 UNIQUE Edit Drop pageid
pageid_14 UNIQUE Edit Drop pageid
email_form_pages_formid_idx INDEX Edit Drop formid
pageid INDEX Edit Drop pageid
formid INDEX Edit Drop formid
pagetype INDEX Edit Drop pagetype
url INDEX Edit Drop url
sendfromname INDEX Edit Drop sendfromname
sendfromemail INDEX Edit Drop sendfromemail
replytoemail INDEX Edit Drop replytoemail
bounceemail INDEX Edit Drop bounceemail
emailsubject INDEX Edit Drop emailsubject
emailsubject_2 INDEX Edit Drop emailsubject
pagetype_2 INDEX Edit Drop pagetype
sendfromemail_2 INDEX Edit Drop sendfromemail
url_2 INDEX Edit Drop url
replytoemail_2 INDEX Edit Drop replytoemail
formid_2 INDEX Edit Drop formid
bounceemail_2 INDEX Edit Drop bounceemail
sendfromname_2 INDEX Edit Drop sendfromname
pageid_4 INDEX Edit Drop pageid
url_3 INDEX Edit Drop url
bounceemail_3 INDEX Edit Drop bounceemail
sendfromname_3 INDEX Edit Drop sendfromname
replytoemail_3 INDEX Edit Drop replytoemail
sendfromemail_3 INDEX Edit Drop sendfromemail
pageid_5 INDEX Edit Drop pageid
formid_3 INDEX Edit Drop formid
pagetype_3 INDEX Edit Drop pagetype
emailsubject_3 INDEX Edit Drop emailsubject
replytoemail_4 INDEX Edit Drop replytoemail
pagetype_4 INDEX Edit Drop pagetype
sendfromemail_4 INDEX Edit Drop sendfromemail
emailsubject_4 INDEX Edit Drop emailsubject
formid_4 INDEX Edit Drop formid
url_4 INDEX Edit Drop url
pageid_8 INDEX Edit Drop pageid
sendfromname_4 INDEX Edit Drop sendfromname
bounceemail_4 INDEX Edit Drop bounceemail
replytoemail_5 INDEX Edit Drop replytoemail
pagetype_5 INDEX Edit Drop pagetype
formid_5 INDEX Edit Drop formid
pageid_9 INDEX Edit Drop pageid
bounceemail_5 INDEX Edit Drop bounceemail
emailsubject_5 INDEX Edit Drop emailsubject
replytoemail_6 INDEX Edit Drop replytoemail
sendfromname_5 INDEX Edit Drop sendfromname
url_5 INDEX Edit Drop url
sendfromemail_5 INDEX Edit Drop sendfromemail
emailsubject_6 INDEX Edit Drop emailsubject
pagetype_6 INDEX Edit Drop pagetype
sendfromemail_6 INDEX Edit Drop sendfromemail
url_6 INDEX Edit Drop url
formid_6 INDEX Edit Drop formid
pageid_12 INDEX Edit Drop pageid
sendfromemail_7 INDEX Edit Drop sendfromemail
pagetype_7 INDEX Edit Drop pagetype
pageid_13 INDEX Edit Drop pageid
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 25
Creation Apr 14, 2018 at 10:30 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: