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

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
   longtext utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(2) 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
   char(1) utf8_general_ci   Yes    Change Drop Primary Index Unique Fulltext
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   char(1) 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
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 formid
formid_2 UNIQUE Edit Drop formid
formid_3 UNIQUE Edit Drop formid
formid_6 UNIQUE Edit Drop formid
formid_7 UNIQUE Edit Drop formid
name_2 UNIQUE Edit Drop name
design_2 UNIQUE Edit Drop design
createdate_2 UNIQUE Edit Drop createdate
createdate_3 UNIQUE Edit Drop createdate
name_3 UNIQUE Edit Drop name
design_4 UNIQUE Edit Drop design
name_6 UNIQUE Edit Drop name
design_6 UNIQUE Edit Drop design
name_7 UNIQUE Edit Drop name
design_8 UNIQUE Edit Drop design
createdate_6 UNIQUE Edit Drop createdate
name_9 UNIQUE Edit Drop name
design_9 UNIQUE Edit Drop design
formid INDEX Edit Drop formid
name INDEX Edit Drop name
design INDEX Edit Drop design
chooseformat INDEX Edit Drop chooseformat
changeformat INDEX Edit Drop changeformat
sendthanks INDEX Edit Drop sendthanks
requireconfirm INDEX Edit Drop requireconfirm
ownerid INDEX Edit Drop ownerid
formtype INDEX Edit Drop formtype
createdate INDEX Edit Drop createdate
contactform INDEX Edit Drop contactform
usecaptcha INDEX Edit Drop usecaptcha
design_3 INDEX Edit Drop design
usecaptcha_2 INDEX Edit Drop usecaptcha
formtype_2 INDEX Edit Drop formtype
createdate_4 INDEX Edit Drop createdate
formid_4 INDEX Edit Drop formid
requireconfirm_2 INDEX Edit Drop requireconfirm
ownerid_2 INDEX Edit Drop ownerid
chooseformat_2 INDEX Edit Drop chooseformat
changeformat_2 INDEX Edit Drop changeformat
sendthanks_2 INDEX Edit Drop sendthanks
name_4 INDEX Edit Drop name
contactform_2 INDEX Edit Drop contactform
ownerid_3 INDEX Edit Drop ownerid
formid_5 INDEX Edit Drop formid
name_5 INDEX Edit Drop name
design_5 INDEX Edit Drop design
chooseformat_3 INDEX Edit Drop chooseformat
changeformat_3 INDEX Edit Drop changeformat
sendthanks_3 INDEX Edit Drop sendthanks
requireconfirm_3 INDEX Edit Drop requireconfirm
design_7 INDEX Edit Drop design
formtype_3 INDEX Edit Drop formtype
chooseformat_4 INDEX Edit Drop chooseformat
requireconfirm_4 INDEX Edit Drop requireconfirm
ownerid_4 INDEX Edit Drop ownerid
createdate_5 INDEX Edit Drop createdate
usecaptcha_3 INDEX Edit Drop usecaptcha
formid_8 INDEX Edit Drop formid
name_8 INDEX Edit Drop name
contactform_3 INDEX Edit Drop contactform
changeformat_4 INDEX Edit Drop changeformat
sendthanks_4 INDEX Edit Drop sendthanks
requireconfirm_5 INDEX Edit Drop requireconfirm
formtype_4 INDEX Edit Drop formtype
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 4
Creation Mar 21, 2018 at 01:45 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: