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

InnoDB free: 779264 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     No    auto_increment  Change Drop Primary Index Unique Fulltext
   varchar(20) utf8_general_ci   Yes  NULL    Change Drop Primary Index Unique Fulltext
   varchar(100) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   char(1) utf8_general_ci   No    Change Drop Primary Index Unique Fulltext
   varchar(250) utf8_general_ci   No      Change Drop Primary Index Unique Fulltext
   text utf8_general_ci   No      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 1822  Edit Drop logid
logid_2 UNIQUE 1822  Edit Drop logid
logid_4 UNIQUE 1822  Edit Drop logid
logid_5 UNIQUE 1822  Edit Drop logid
logid_7 UNIQUE 1822  Edit Drop logid
logid_9 UNIQUE 1822  Edit Drop logid
logid_10 UNIQUE 1822  Edit Drop logid
logid_14 UNIQUE 1822  Edit Drop logid
logid INDEX 1822  Edit Drop logid
logtype INDEX Edit Drop logtype
logmodule INDEX Edit Drop logmodule
logseverity INDEX Edit Drop logseverity
logsummary INDEX 1822  Edit Drop logsummary
logdate INDEX 911  Edit Drop logdate
logdate_2 INDEX 911  Edit Drop logdate
logid_3 INDEX 1822  Edit Drop logid
logtype_2 INDEX Edit Drop logtype
logsummary_2 INDEX 1822  Edit Drop logsummary
logseverity_2 INDEX Edit Drop logseverity
logmodule_2 INDEX Edit Drop logmodule
logsummary_3 INDEX 1822  Edit Drop logsummary
logdate_3 INDEX 911  Edit Drop logdate
logid_6 INDEX 1822  Edit Drop logid
logtype_3 INDEX Edit Drop logtype
logmodule_3 INDEX Edit Drop logmodule
logseverity_3 INDEX Edit Drop logseverity
logseverity_4 INDEX Edit Drop logseverity
logdate_4 INDEX 911  Edit Drop logdate
logtype_4 INDEX Edit Drop logtype
logsummary_4 INDEX 1822  Edit Drop logsummary
logid_8 INDEX 1822  Edit Drop logid
logmodule_4 INDEX Edit Drop logmodule
logdate_5 INDEX 911  Edit Drop logdate
logseverity_5 INDEX Edit Drop logseverity
logmodule_5 INDEX Edit Drop logmodule
logdate_6 INDEX 911  Edit Drop logdate
logseverity_6 INDEX Edit Drop logseverity
logid_11 INDEX 1822  Edit Drop logid
logsummary_5 INDEX 1822  Edit Drop logsummary
logid_12 INDEX 1822  Edit Drop logid
logtype_5 INDEX Edit Drop logtype
logsummary_6 INDEX 1822  Edit Drop logsummary
logtype_6 INDEX Edit Drop logtype
logmodule_6 INDEX Edit Drop logmodule
logid_13 INDEX 1822  Edit Drop logid
logtype_7 INDEX Edit Drop logtype
logmodule_7 INDEX Edit Drop logmodule
logseverity_7 INDEX Edit Drop logseverity
logsummary_7 INDEX 1822  Edit Drop logsummary
logdate_7 INDEX 911  Edit Drop logdate
logseverity_8 INDEX Edit Drop logseverity
logid_15 INDEX 1822  Edit Drop logid
logdate_8 INDEX 911  Edit Drop logdate
logtype_8 INDEX Edit Drop logtype
logsummary_8 INDEX 1822  Edit Drop logsummary
logmodule_8 INDEX Edit Drop logmodule
logseverity_9 INDEX Edit Drop logseverity
logid_16 INDEX 1822  Edit Drop logid
logdate_9 INDEX 911  Edit Drop logdate
logtype_9 INDEX Edit Drop logtype
logmodule_9 INDEX Edit Drop logmodule
logsummary_9 INDEX 1822  Edit Drop logsummary
logsummary_10 INDEX 1822  Edit Drop logsummary
logmodule_10 INDEX Edit Drop logmodule
Create an index on  columns  
 
Space usage: 
Type Usage
Data 3,600 KB
Index 7,456 KB
Total 11,056 KB
 
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Next Autoindex 1,888
Creation May 24, 2018 at 03:34 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: