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

InnoDB free: 775168 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
   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
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 templateid
templateid_2 UNIQUE Edit Drop templateid
ownerid_2 UNIQUE Edit Drop ownerid
templateid_4 UNIQUE Edit Drop templateid
ownerid_4 UNIQUE Edit Drop ownerid
templateid_6 UNIQUE Edit Drop templateid
ownerid_6 UNIQUE Edit Drop ownerid
templateid_7 UNIQUE Edit Drop templateid
ownerid_8 UNIQUE Edit Drop ownerid
ownerid_9 UNIQUE Edit Drop ownerid
name_2 UNIQUE Edit Drop name
format_2 UNIQUE Edit Drop format
createdate_2 UNIQUE Edit Drop createdate
active_2 UNIQUE Edit Drop active
isglobal_2 UNIQUE Edit Drop isglobal
isglobal_3 UNIQUE Edit Drop isglobal
active_3 UNIQUE Edit Drop active
name_3 UNIQUE Edit Drop name
format_4 UNIQUE Edit Drop format
createdate_4 UNIQUE Edit Drop createdate
format_6 UNIQUE Edit Drop format
isglobal_5 UNIQUE Edit Drop isglobal
createdate_6 UNIQUE Edit Drop createdate
active_5 UNIQUE Edit Drop active
name_6 UNIQUE Edit Drop name
name_7 UNIQUE Edit Drop name
isglobal_7 UNIQUE Edit Drop isglobal
format_8 UNIQUE Edit Drop format
active_7 UNIQUE Edit Drop active
createdate_8 UNIQUE Edit Drop createdate
format_9 UNIQUE Edit Drop format
isglobal_10 UNIQUE Edit Drop isglobal
isglobal_11 UNIQUE Edit Drop isglobal
email_templates_owner_idx INDEX Edit Drop ownerid
templateid INDEX Edit Drop templateid
name INDEX Edit Drop name
format INDEX Edit Drop format
createdate INDEX Edit Drop createdate
active INDEX Edit Drop active
isglobal INDEX Edit Drop isglobal
ownerid INDEX Edit Drop ownerid
format_3 INDEX Edit Drop format
ownerid_3 INDEX Edit Drop ownerid
templateid_3 INDEX Edit Drop templateid
createdate_3 INDEX Edit Drop createdate
isglobal_4 INDEX Edit Drop isglobal
name_4 INDEX Edit Drop name
active_4 INDEX Edit Drop active
format_5 INDEX Edit Drop format
templateid_5 INDEX Edit Drop templateid
createdate_5 INDEX Edit Drop createdate
name_5 INDEX Edit Drop name
isglobal_6 INDEX Edit Drop isglobal
ownerid_5 INDEX Edit Drop ownerid
active_6 INDEX Edit Drop active
name_8 INDEX Edit Drop name
format_7 INDEX Edit Drop format
isglobal_8 INDEX Edit Drop isglobal
createdate_7 INDEX Edit Drop createdate
ownerid_7 INDEX Edit Drop ownerid
templateid_8 INDEX Edit Drop templateid
active_8 INDEX Edit Drop active
isglobal_9 INDEX Edit Drop isglobal
format_10 INDEX Edit Drop format
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 Apr 08, 2018 at 04:36 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: