Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_autoresponders

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
	htmlrecipients	int(11)			Yes	0
	textrecipients	int(11)			Yes	0
	multipartrecipients	int(11)			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
	autoresponderid	int(11)			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
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 htmlrecipients textrecipients multipartrecipients bouncecount_soft bouncecount_hard bouncecount_unknown unsubscribecount autoresponderid linkclicks emailopens emailforwards emailopens_unique htmlopens htmlopens_unique textopens textopens_unique hiddenby

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  statid statid_2 UNIQUE 0  statid statid_3 UNIQUE 0  statid htmlrecipients_2 UNIQUE 0  htmlrecipients textrecipients_2 UNIQUE 0  textrecipients multipartrecipients_2 UNIQUE 0  multipartrecipients bouncecount_soft_2 UNIQUE 0  bouncecount_soft bouncecount_hard_2 UNIQUE 0  bouncecount_hard bouncecount_unknown_2 UNIQUE 0  bouncecount_unknown unsubscribecount_2 UNIQUE 0  unsubscribecount autoresponderid_2 UNIQUE 0  autoresponderid linkclicks_2 UNIQUE 0  linkclicks emailopens_2 UNIQUE 0  emailopens emailforwards_2 UNIQUE 0  emailforwards emailopens_unique_2 UNIQUE 0  emailopens_unique htmlopens_2 UNIQUE 0  htmlopens htmlopens_unique_2 UNIQUE 0  htmlopens_unique textopens_2 UNIQUE 0  textopens textopens_unique_2 UNIQUE 0  textopens_unique hiddenby_2 UNIQUE 0  hiddenby unsubscribecount_3 UNIQUE 0  unsubscribecount hiddenby_3 UNIQUE 0  hiddenby bouncecount_unknown_4 UNIQUE 0  bouncecount_unknown bouncecount_soft_3 UNIQUE 0  bouncecount_soft emailforwards_4 UNIQUE 0  emailforwards multipartrecipients_4 UNIQUE 0  multipartrecipients htmlrecipients_3 UNIQUE 0  htmlrecipients linkclicks_3 UNIQUE 0  linkclicks autoresponderid_3 UNIQUE 0  autoresponderid emailopens_3 UNIQUE 0  emailopens bouncecount_hard_3 UNIQUE 0  bouncecount_hard htmlopens_unique_3 UNIQUE 0  htmlopens_unique email_stats_autoresponders_statid_idx INDEX 0  statid email_stats_autoresponders_autoresponderid_idx INDEX 0  autoresponderid statid INDEX 0  statid htmlrecipients INDEX 0  htmlrecipients textrecipients INDEX 0  textrecipients multipartrecipients INDEX 0  multipartrecipients bouncecount_soft INDEX 0  bouncecount_soft bouncecount_hard INDEX 0  bouncecount_hard bouncecount_unknown INDEX 0  bouncecount_unknown unsubscribecount INDEX 0  unsubscribecount autoresponderid INDEX 0  autoresponderid linkclicks INDEX 0  linkclicks emailopens INDEX 0  emailopens emailforwards INDEX 0  emailforwards emailopens_unique INDEX 0  emailopens_unique htmlopens INDEX 0  htmlopens htmlopens_unique INDEX 0  htmlopens_unique textopens INDEX 0  textopens textopens_unique INDEX 0  textopens_unique hiddenby INDEX 0  hiddenby textopens_3 INDEX 0  textopens bouncecount_unknown_3 INDEX 0  bouncecount_unknown multipartrecipients_3 INDEX 0  multipartrecipients hiddenby_4 INDEX 0  hiddenby emailforwards_3 INDEX 0  emailforwards textopens_unique_3 INDEX 0  textopens_unique htmlrecipients_4 INDEX 0  htmlrecipients linkclicks_4 INDEX 0  linkclicks emailopens_4 INDEX 0  emailopens unsubscribecount_4 INDEX 0  unsubscribecount autoresponderid_4 INDEX 0  autoresponderid emailopens_unique_3 INDEX 0  emailopens_unique 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 Mar 20, 2024 at 11:34 AM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_stats_autoresponders` ADD UNIQUE(`htmlopens_unique`)		statid htmlrecipients textrecipients multipartrecipients bouncecount_soft bouncecount_hard bouncecount_unknown unsubscribecount autoresponderid linkclicks emailopens emailforwards emailopens_unique htmlopens htmlopens_unique textopens textopens_unique hiddenby
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