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

InnoDB free: 778240 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
   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 172  Edit Drop summaryid
summaryid_2 UNIQUE 172  Edit Drop summaryid
summaryid_3 UNIQUE 172  Edit Drop summaryid
summaryid_5 UNIQUE 172  Edit Drop summaryid
summaryid_7 UNIQUE 172  Edit Drop summaryid
summaryid_9 UNIQUE 172  Edit Drop summaryid
summaryid_11 UNIQUE 172  Edit Drop summaryid
summaryid_13 UNIQUE 172  Edit Drop summaryid
email_user_stats_emailsperhour_statid_idx INDEX 172  Edit Drop statid
email_user_stats_emailsperhour_userid_idx INDEX Edit Drop userid
summaryid INDEX 172  Edit Drop summaryid
statid INDEX 172  Edit Drop statid
sendtime INDEX 172  Edit Drop sendtime
emailssent INDEX 86  Edit Drop emailssent
userid INDEX Edit Drop userid
statid_2 INDEX 172  Edit Drop statid
userid_2 INDEX Edit Drop userid
summaryid_4 INDEX 172  Edit Drop summaryid
emailssent_2 INDEX 86  Edit Drop emailssent
sendtime_2 INDEX 172  Edit Drop sendtime
statid_3 INDEX 172  Edit Drop statid
userid_3 INDEX Edit Drop userid
summaryid_6 INDEX 172  Edit Drop summaryid
sendtime_3 INDEX 172  Edit Drop sendtime
emailssent_3 INDEX 86  Edit Drop emailssent
statid_4 INDEX 172  Edit Drop statid
sendtime_4 INDEX 172  Edit Drop sendtime
userid_4 INDEX Edit Drop userid
summaryid_8 INDEX 172  Edit Drop summaryid
emailssent_4 INDEX 86  Edit Drop emailssent
summaryid_10 INDEX 172  Edit Drop summaryid
statid_5 INDEX 172  Edit Drop statid
userid_5 INDEX Edit Drop userid
summaryid_12 INDEX 172  Edit Drop summaryid
statid_6 INDEX 172  Edit Drop statid
sendtime_5 INDEX 172  Edit Drop sendtime
emailssent_5 INDEX 86  Edit Drop emailssent
userid_6 INDEX Edit Drop userid
emailssent_6 INDEX 86  Edit Drop emailssent
sendtime_6 INDEX 172  Edit Drop sendtime
Create an index on  columns  
 
Space usage: 
Type Usage
Data 16,384 Bytes
Index 638,976 Bytes
Total 655,360 Bytes
 
Row Statistic: 
Statements Value
Format fixed
Collation utf8_general_ci
Next Autoindex 173
Creation Apr 23, 2018 at 07:07 AM

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: