Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_users

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	userid	int(11)			Yes	0
	statid	int(11)			No	0
	jobid	int(11)			Yes	0
	queuesize	int(11)			Yes	0
	queuetime	int(11)			Yes	0
Check All  /  Uncheck All     With selected:

Print view

Relation view

Propose table structure

Add new field:  At End of Table At Beginning of Table After userid statid jobid queuesize queuetime

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 75  statid statid_2 UNIQUE 75  statid statid_4 UNIQUE 75  statid statid_6 UNIQUE 75  statid statid_7 UNIQUE 75  statid statid_11 UNIQUE 75  statid statid_12 UNIQUE 75  statid statid_14 UNIQUE 75  statid statid_15 UNIQUE 75  statid jobid_2 UNIQUE 75  jobid queuetime_2 UNIQUE 75  queuetime jobid_3 UNIQUE 75  jobid queuetime_4 UNIQUE 75  queuetime jobid_5 UNIQUE 75  jobid queuetime_5 UNIQUE 75  queuetime jobid_7 UNIQUE 75  jobid queuetime_8 UNIQUE 75  queuetime queuetime_9 UNIQUE 75  queuetime jobid_9 UNIQUE 75  jobid jobid_11 UNIQUE 75  jobid jobid_13 UNIQUE 75  jobid queuetime_13 UNIQUE 75  queuetime queuetime_14 UNIQUE 75  queuetime jobid_15 UNIQUE 75  jobid email_stats_users_all_idx INDEX 75  userid queuetime queuesize email_stats_users_statid_idx INDEX 75  statid userid INDEX 2  userid statid INDEX 75  statid jobid INDEX 75  jobid queuesize INDEX 75  queuesize queuetime INDEX 75  queuetime statid_3 INDEX 75  statid userid_2 INDEX 2  userid queuetime_3 INDEX 75  queuetime queuesize_2 INDEX 75  queuesize jobid_4 INDEX 75  jobid userid_3 INDEX 2  userid statid_5 INDEX 75  statid queuetime_6 INDEX 75  queuetime jobid_6 INDEX 75  jobid queuesize_3 INDEX 75  queuesize statid_8 INDEX 75  statid userid_4 INDEX 2  userid queuetime_7 INDEX 75  queuetime queuesize_4 INDEX 75  queuesize jobid_8 INDEX 75  jobid statid_9 INDEX 75  statid queuesize_5 INDEX 75  queuesize statid_10 INDEX 75  statid userid_5 INDEX 2  userid queuetime_10 INDEX 75  queuetime queuetime_11 INDEX 75  queuetime jobid_10 INDEX 75  jobid userid_6 INDEX 2  userid queuesize_6 INDEX 75  queuesize userid_7 INDEX 2  userid statid_13 INDEX 75  statid jobid_12 INDEX 75  jobid queuesize_7 INDEX 75  queuesize queuetime_12 INDEX 75  queuetime jobid_14 INDEX 75  jobid userid_8 INDEX 2  userid statid_16 INDEX 75  statid statid_17 INDEX 75  statid 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 fixed Collation utf8_general_ci Creation Jun 21, 2018 at 06:23 PM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_stats_users` ADD PRIMARY KEY(`userid`)		userid statid jobid queuesize queuetime
Show this query here again
Or Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:      Autodetect   None   "gzipped"   "bzipped"
Character set of the file: armscii8 ascii big5 binary cp1250 cp1251 cp1256 cp1257 cp850 cp852 cp866 cp932 dec8 euckr gb2312 gbk geostd8 greek hebrew hp8 keybcs2 koi8r koi8u latin1 latin2 latin5 latin7 macce macroman sjis swe7 tis620 ucs2 ujis utf8