Server: mysql.puroparty.com

Database: puroparty

Table: email_jobs

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	jobid	int(11)			No		auto_increment
	jobtype	varchar(255)	utf8_general_ci		Yes	NULL
	jobstatus	char(1)	utf8_general_ci		Yes	NULL
	jobtime	int(11)			Yes	0
	jobdetails	text	utf8_general_ci		Yes	NULL
	fkid	int(11)			Yes	0
	lastupdatetime	int(11)			Yes	0
	fktype	varchar(255)	utf8_general_ci		Yes	NULL
	queueid	int(11)			Yes	0
	ownerid	int(11)			Yes	0
	approved	int(11)			Yes	0
	authorisedtosend	int(11)			Yes	0
	resendcount	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 jobid jobtype jobstatus jobtime jobdetails fkid lastupdatetime fktype queueid ownerid approved authorisedtosend resendcount

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 70  jobid jobid_2 UNIQUE 70  jobid jobid_4 UNIQUE 70  jobid jobid_6 UNIQUE 70  jobid jobid_8 UNIQUE 70  jobid jobtime_2 UNIQUE 70  jobtime lastupdatetime_2 UNIQUE 70  lastupdatetime queueid_2 UNIQUE 70  queueid lastupdatetime_3 UNIQUE 70  lastupdatetime queueid_4 UNIQUE 70  queueid jobtime_4 UNIQUE 70  jobtime queueid_6 UNIQUE 70  queueid lastupdatetime_6 UNIQUE 70  lastupdatetime jobtime_6 UNIQUE 70  jobtime queueid_7 UNIQUE 70  queueid email_jobs_fkid_idx INDEX 70  fkid email_jobs_jobtime_idx INDEX 70  jobtime email_jobs_queue_idx INDEX 70  queueid email_jobs_owner_idx INDEX 1  ownerid jobid INDEX 70  jobid jobtype INDEX 1  jobtype jobstatus INDEX 5  jobstatus jobtime INDEX 70  jobtime fkid INDEX 70  fkid lastupdatetime INDEX 70  lastupdatetime fktype INDEX 1  fktype queueid INDEX 70  queueid ownerid INDEX 1  ownerid approved INDEX 1  approved authorisedtosend INDEX 1  authorisedtosend resendcount INDEX 3  resendcount jobstatus_2 INDEX 5  jobstatus ownerid_2 INDEX 1  ownerid resendcount_2 INDEX 3  resendcount approved_2 INDEX 1  approved queueid_3 INDEX 70  queueid jobtime_3 INDEX 70  jobtime fkid_2 INDEX 70  fkid lastupdatetime_4 INDEX 70  lastupdatetime jobtype_2 INDEX 1  jobtype jobid_3 INDEX 70  jobid authorisedtosend_2 INDEX 1  authorisedtosend fktype_2 INDEX 1  fktype jobid_5 INDEX 70  jobid resendcount_3 INDEX 3  resendcount fkid_3 INDEX 70  fkid lastupdatetime_5 INDEX 70  lastupdatetime queueid_5 INDEX 70  queueid jobtime_5 INDEX 70  jobtime ownerid_3 INDEX 1  ownerid jobstatus_3 INDEX 5  jobstatus approved_3 INDEX 1  approved jobid_7 INDEX 70  jobid authorisedtosend_3 INDEX 1  authorisedtosend jobtype_3 INDEX 1  jobtype fktype_3 INDEX 1  fktype resendcount_4 INDEX 3  resendcount fkid_4 INDEX 70  fkid fktype_4 INDEX 1  fktype authorisedtosend_4 INDEX 1  authorisedtosend lastupdatetime_7 INDEX 70  lastupdatetime jobtype_4 INDEX 1  jobtype queueid_8 INDEX 70  queueid fkid_5 INDEX 70  fkid Create an index on  columns

Space usage:  Type Usage Data 98,304 Bytes Index 1,008 KB Total 1,104 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 76 Creation Mar 18, 2024 at 06:32 PM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_jobs` ADD INDEX(`queueid`)		jobid jobtype jobstatus jobtime jobdetails fkid lastupdatetime fktype queueid ownerid approved authorisedtosend resendcount
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