Server: mysql.puroparty.com

Database: puroparty

Table: email_autoresponders

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	autoresponderid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		Yes	NULL
	subject	varchar(255)	utf8_general_ci		Yes	NULL
	format	char(1)	utf8_general_ci		Yes	NULL
	textbody	longtext	utf8_general_ci		Yes	NULL
	htmlbody	longtext	utf8_general_ci		Yes	NULL
	createdate	int(11)			Yes	0
	active	int(11)			Yes	0
	hoursaftersubscription	int(11)			Yes	0
	ownerid	int(11)			No	0
	searchcriteria	mediumtext	utf8_general_ci		Yes	NULL
	listid	int(11)			Yes	0
	tracklinks	char(1)	utf8_general_ci		Yes	1
	trackopens	char(1)	utf8_general_ci		Yes	1
	multipart	char(1)	utf8_general_ci		Yes	1
	queueid	int(11)			Yes	0
	sendfromname	varchar(255)	utf8_general_ci		Yes	NULL
	sendfromemail	varchar(255)	utf8_general_ci		Yes	NULL
	replytoemail	varchar(255)	utf8_general_ci		Yes	NULL
	bounceemail	varchar(255)	utf8_general_ci		Yes	NULL
	charset	varchar(255)	utf8_general_ci		Yes	NULL
	embedimages	char(1)	utf8_general_ci		Yes	0
	to_firstname	int(11)			Yes	0
	to_lastname	int(11)			Yes	0
	autorespondersize	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 autoresponderid name subject format textbody htmlbody createdate active hoursaftersubscription ownerid searchcriteria listid tracklinks trackopens multipart queueid sendfromname sendfromemail replytoemail bounceemail charset embedimages to_firstname to_lastname autorespondersize

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  autoresponderid autoresponderid_2 UNIQUE 0  autoresponderid ownerid_2 UNIQUE 0  ownerid autoresponderid_3 UNIQUE 0  autoresponderid name_2 UNIQUE 0  name subject_2 UNIQUE 0  subject format_2 UNIQUE 0  format createdate_2 UNIQUE 0  createdate active_2 UNIQUE 0  active hoursaftersubscription_2 UNIQUE 0  hoursaftersubscription listid_2 UNIQUE 0  listid tracklinks_2 UNIQUE 0  tracklinks trackopens_2 UNIQUE 0  trackopens multipart_2 UNIQUE 0  multipart queueid_2 UNIQUE 0  queueid sendfromname_2 UNIQUE 0  sendfromname sendfromemail_2 UNIQUE 0  sendfromemail replytoemail_2 UNIQUE 0  replytoemail bounceemail_2 UNIQUE 0  bounceemail charset_2 UNIQUE 0  charset embedimages_2 UNIQUE 0  embedimages to_firstname_2 UNIQUE 0  to_firstname to_lastname_2 UNIQUE 0  to_lastname autorespondersize_2 UNIQUE 0  autorespondersize bounceemail_3 UNIQUE 0  bounceemail format_3 UNIQUE 0  format multipart_3 UNIQUE 0  multipart trackopens_3 UNIQUE 0  trackopens name_4 UNIQUE 0  name createdate_3 UNIQUE 0  createdate email_autoresponders_owner_idx INDEX 0  ownerid email_autoresponders_list_idx INDEX 0  listid email_autoresponders_queue_idx INDEX 0  queueid autoresponderid INDEX 0  autoresponderid name INDEX 0  name subject INDEX 0  subject format INDEX 0  format createdate INDEX 0  createdate active INDEX 0  active hoursaftersubscription INDEX 0  hoursaftersubscription ownerid INDEX 0  ownerid listid INDEX 0  listid tracklinks INDEX 0  tracklinks trackopens INDEX 0  trackopens multipart INDEX 0  multipart queueid INDEX 0  queueid sendfromname INDEX 0  sendfromname sendfromemail INDEX 0  sendfromemail replytoemail INDEX 0  replytoemail bounceemail INDEX 0  bounceemail charset INDEX 0  charset embedimages INDEX 0  embedimages to_firstname INDEX 0  to_firstname to_lastname INDEX 0  to_lastname autorespondersize INDEX 0  autorespondersize name_3 INDEX 0  name autorespondersize_3 INDEX 0  autorespondersize sendfromemail_3 INDEX 0  sendfromemail active_3 INDEX 0  active tracklinks_3 INDEX 0  tracklinks to_lastname_3 INDEX 0  to_lastname queueid_3 INDEX 0  queueid ownerid_3 INDEX 0  ownerid subject_3 INDEX 0  subject 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 dynamic Collation utf8_general_ci Next Autoindex 1 Creation Apr 16, 2024 at 12:29 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_autoresponders` WHERE 1		autoresponderid name subject format textbody htmlbody createdate active hoursaftersubscription ownerid searchcriteria listid tracklinks trackopens multipart queueid sendfromname sendfromemail replytoemail bounceemail charset embedimages to_firstname to_lastname autorespondersize
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