Server: mysql.puroparty.com

Database: puroparty

Table: email_lists

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	listid	int(11)			No		auto_increment
	name	varchar(255)	utf8_general_ci		Yes	NULL
	ownername	varchar(255)	utf8_general_ci		Yes	NULL
	owneremail	varchar(100)	utf8_general_ci		Yes	NULL
	bounceemail	varchar(100)	utf8_general_ci		Yes	NULL
	replytoemail	varchar(100)	utf8_general_ci		Yes	NULL
	bounceserver	varchar(100)	utf8_general_ci		Yes	NULL
	bounceusername	varchar(100)	utf8_general_ci		Yes	NULL
	bouncepassword	varchar(100)	utf8_general_ci		Yes	NULL
	extramailsettings	varchar(100)	utf8_general_ci		Yes	NULL
	companyname	varchar(255)	utf8_general_ci		Yes	NULL
	companyaddress	varchar(255)	utf8_general_ci		Yes	NULL
	companyphone	varchar(20)	utf8_general_ci		Yes	NULL
	format	char(1)	utf8_general_ci		Yes	NULL
	notifyowner	char(1)	utf8_general_ci		Yes	0
	imapaccount	char(1)	utf8_general_ci		Yes	0
	createdate	int(11)			Yes	0
	subscribecount	int(11)			Yes	0
	unsubscribecount	int(11)			Yes	0
	bouncecount	int(11)			Yes	0
	processbounce	char(1)	utf8_general_ci		Yes	0
	agreedelete	char(1)	utf8_general_ci		Yes	0
	visiblefields	text	utf8_general_ci		No
	ownerid	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 listid name ownername owneremail bounceemail replytoemail bounceserver bounceusername bouncepassword extramailsettings companyname companyaddress companyphone format notifyowner imapaccount createdate subscribecount unsubscribecount bouncecount processbounce agreedelete visiblefields ownerid

Structure Browse SQL Search Insert Export Operations Empty Drop

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 16  listid listid_2 UNIQUE 16  listid listid_4 UNIQUE 16  listid listid_6 UNIQUE 16  listid name_2 UNIQUE 16  name createdate_2 UNIQUE 16  createdate name_3 UNIQUE 16  name createdate_3 UNIQUE 16  createdate createdate_5 UNIQUE 16  createdate email_lists_owner_idx INDEX 2  ownerid listid INDEX 16  listid name INDEX 16  name ownername INDEX 8  ownername owneremail INDEX 4  owneremail bounceemail INDEX 4  bounceemail replytoemail INDEX 4  replytoemail bounceserver INDEX 4  bounceserver bounceusername INDEX 4  bounceusername bouncepassword INDEX 4  bouncepassword extramailsettings INDEX 2  extramailsettings companyname INDEX 4  companyname companyaddress INDEX 8  companyaddress companyphone INDEX 4  companyphone format INDEX 2  format notifyowner INDEX 4  notifyowner imapaccount INDEX 2  imapaccount createdate INDEX 16  createdate subscribecount INDEX 16  subscribecount unsubscribecount INDEX 16  unsubscribecount bouncecount INDEX 2  bouncecount processbounce INDEX 4  processbounce agreedelete INDEX 4  agreedelete ownerid INDEX 2  ownerid replytoemail_2 INDEX 4  replytoemail bounceemail_2 INDEX 4  bounceemail companyname_2 INDEX 4  companyname extramailsettings_2 INDEX 2  extramailsettings processbounce_2 INDEX 4  processbounce unsubscribecount_2 INDEX 16  unsubscribecount bouncecount_2 INDEX 2  bouncecount bouncepassword_2 INDEX 4  bouncepassword ownerid_2 INDEX 2  ownerid bounceusername_2 INDEX 4  bounceusername companyaddress_2 INDEX 8  companyaddress name_4 INDEX 16  name listid_3 INDEX 16  listid agreedelete_2 INDEX 4  agreedelete ownername_2 INDEX 8  ownername bounceserver_2 INDEX 4  bounceserver owneremail_2 INDEX 4  owneremail subscribecount_2 INDEX 16  subscribecount format_2 INDEX 2  format notifyowner_2 INDEX 4  notifyowner createdate_4 INDEX 16  createdate companyphone_2 INDEX 4  companyphone imapaccount_2 INDEX 2  imapaccount bounceserver_3 INDEX 4  bounceserver listid_5 INDEX 16  listid replytoemail_3 INDEX 4  replytoemail extramailsettings_3 INDEX 2  extramailsettings bounceusername_3 INDEX 4  bounceusername name_5 INDEX 16  name ownerid_3 INDEX 2  ownerid bounceemail_3 INDEX 4  bounceemail 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 19 Creation Mar 29, 2024 at 02:48 AM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_lists` ADD INDEX(`bouncecount`)		listid name ownername owneremail bounceemail replytoemail bounceserver bounceusername bouncepassword extramailsettings companyname companyaddress companyphone format notifyowner imapaccount createdate subscribecount unsubscribecount bouncecount processbounce agreedelete visiblefields ownerid
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