Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_newsletters

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	statid	int(11)			No	0
	queueid	int(11)			Yes	0
	jobid	int(11)			Yes	0
	starttime	int(11)			Yes	0
	finishtime	int(11)			Yes	0
	htmlrecipients	int(11)			Yes	0
	textrecipients	int(11)			Yes	0
	multipartrecipients	int(11)			Yes	0
	trackopens	char(1)	utf8_general_ci		Yes	0
	tracklinks	char(1)	utf8_general_ci		Yes	0
	bouncecount_soft	int(11)			Yes	0
	bouncecount_hard	int(11)			Yes	0
	bouncecount_unknown	int(11)			Yes	0
	unsubscribecount	int(11)			Yes	0
	newsletterid	int(11)			Yes	0
	sendfromname	varchar(200)	utf8_general_ci		Yes	NULL
	sendfromemail	varchar(200)	utf8_general_ci		Yes	NULL
	bounceemail	varchar(200)	utf8_general_ci		Yes	NULL
	replytoemail	varchar(200)	utf8_general_ci		Yes	NULL
	charset	varchar(200)	utf8_general_ci		Yes	NULL
	sendinformation	mediumtext	utf8_general_ci		Yes	NULL
	sendsize	int(11)			Yes	0
	sentby	int(11)			Yes	0
	notifyowner	char(1)	utf8_general_ci		Yes	0
	linkclicks	int(11)			Yes	0
	emailopens	int(11)			Yes	0
	emailforwards	int(11)			Yes	0
	emailopens_unique	int(11)			Yes	0
	htmlopens	int(11)			Yes	0
	htmlopens_unique	int(11)			Yes	0
	textopens	int(11)			Yes	0
	textopens_unique	int(11)			Yes	0
	hiddenby	int(11)			Yes	0
	sendtestmode	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 statid queueid jobid starttime finishtime htmlrecipients textrecipients multipartrecipients trackopens tracklinks bouncecount_soft bouncecount_hard bouncecount_unknown unsubscribecount newsletterid sendfromname sendfromemail bounceemail replytoemail charset sendinformation sendsize sentby notifyowner linkclicks emailopens emailforwards emailopens_unique htmlopens htmlopens_unique textopens textopens_unique hiddenby sendtestmode

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 13  statid statid_2 UNIQUE 13  statid queueid_2 UNIQUE 13  queueid jobid_2 UNIQUE 13  jobid starttime_2 UNIQUE 13  starttime queueid_3 UNIQUE 13  queueid starttime_3 UNIQUE 13  starttime jobid_4 UNIQUE 13  jobid email_stats_newsletters_queue_idx INDEX 13  queueid email_stats_newsletters_sentby_idx INDEX 2  sentby statid INDEX 13  statid queueid INDEX 13  queueid jobid INDEX 13  jobid starttime INDEX 13  starttime finishtime INDEX 13  finishtime htmlrecipients INDEX 2  htmlrecipients textrecipients INDEX 2  textrecipients multipartrecipients INDEX 13  multipartrecipients trackopens INDEX 2  trackopens tracklinks INDEX 4  tracklinks bouncecount_soft INDEX 2  bouncecount_soft bouncecount_hard INDEX 2  bouncecount_hard bouncecount_unknown INDEX 2  bouncecount_unknown unsubscribecount INDEX 13  unsubscribecount newsletterid INDEX 13  newsletterid sendfromname INDEX 13  sendfromname sendfromemail INDEX 6  sendfromemail bounceemail INDEX 6  bounceemail replytoemail INDEX 6  replytoemail charset INDEX 2  charset sendsize INDEX 13  sendsize sentby INDEX 2  sentby notifyowner INDEX 2  notifyowner linkclicks INDEX 13  linkclicks emailopens INDEX 13  emailopens emailforwards INDEX 2  emailforwards emailopens_unique INDEX 13  emailopens_unique htmlopens INDEX 13  htmlopens htmlopens_unique INDEX 13  htmlopens_unique textopens INDEX 2  textopens textopens_unique INDEX 2  textopens_unique hiddenby INDEX 4  hiddenby sendtestmode INDEX 2  sendtestmode bouncecount_unknown_2 INDEX 2  bouncecount_unknown multipartrecipients_2 INDEX 13  multipartrecipients textopens_2 INDEX 2  textopens sendfromname_2 INDEX 13  sendfromname sendtestmode_2 INDEX 2  sendtestmode emailopens_2 INDEX 13  emailopens charset_2 INDEX 2  charset trackopens_2 INDEX 2  trackopens statid_3 INDEX 13  statid htmlrecipients_2 INDEX 2  htmlrecipients jobid_3 INDEX 13  jobid emailopens_unique_2 INDEX 13  emailopens_unique finishtime_2 INDEX 13  finishtime tracklinks_2 INDEX 4  tracklinks notifyowner_2 INDEX 2  notifyowner bounceemail_2 INDEX 6  bounceemail starttime_4 INDEX 13  starttime queueid_4 INDEX 13  queueid unsubscribecount_2 INDEX 13  unsubscribecount bouncecount_soft_2 INDEX 2  bouncecount_soft sentby_2 INDEX 2  sentby Create an index on  columns

Space usage:  Type Usage Data 65,536 Bytes Index 1,008 KB Total 1,072 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Creation Mar 28, 2024 at 07:53 AM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_stats_newsletters` ADD UNIQUE(`queueid`)		statid queueid jobid starttime finishtime htmlrecipients textrecipients multipartrecipients trackopens tracklinks bouncecount_soft bouncecount_hard bouncecount_unknown unsubscribecount newsletterid sendfromname sendfromemail bounceemail replytoemail charset sendinformation sendsize sentby notifyowner linkclicks emailopens emailforwards emailopens_unique htmlopens htmlopens_unique textopens textopens_unique hiddenby sendtestmode
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