Database: puropartypuroparty
Table: email_user_accessemail_user_access
An index has been added on userid (Query took 0.0395 sec)
ALTER TABLE `email_user_access` ADD INDEX ( `userid` )
 [Edit] [Create PHP Code]

InnoDB free: 803840 kB

   Field  Type Collation Attributes Null Default Extra Action
   int(11)     Yes    Change Drop Primary Index Unique Fulltext
   varchar(255) utf8_general_ci   Yes  NULL    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
id_2 UNIQUE Edit Drop id
id_3 UNIQUE Edit Drop id
id_6 UNIQUE Edit Drop id
id_7 UNIQUE Edit Drop id
email_user_access_userid_idx INDEX Edit Drop userid
userid INDEX Edit Drop userid
area INDEX Edit Drop area
id INDEX Edit Drop id
id_4 INDEX Edit Drop id
userid_2 INDEX Edit Drop userid
area_2 INDEX Edit Drop area
area_3 INDEX Edit Drop area
id_5 INDEX Edit Drop id
userid_3 INDEX Edit Drop userid
id_8 INDEX Edit Drop id
userid_4 INDEX Edit Drop userid
area_4 INDEX Edit Drop area
id_9 INDEX Edit Drop id
area_5 INDEX Edit Drop area
userid_5 INDEX Edit Drop userid
userid_6 INDEX Edit Drop userid
Create an index on  columns  
Space usage: 
Type Usage
Data 16,384 Bytes
Index 344,064 Bytes
Total 360,448 Bytes
Row Statistic: 
Statements Value
Format dynamic
Collation utf8_general_ci
Creation Mar 17, 2018 at 10:14 PM

Run SQL query/queries on database puropartyDocumentation     Fields: 
Or Location of the textfile: 
 Location of the textfile: 
   (Max: 2,048KB)
Character set of the file: