Server: mysql.puroparty.com

Database: puroparty

Table: email_list_subscribers

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	subscriberid	int(11)			No		auto_increment
	listid	int(11)			No	0
	emailaddress	varchar(200)	utf8_general_ci		Yes	NULL
	domainname	varchar(100)	utf8_general_ci		Yes	NULL
	format	char(1)	utf8_general_ci		Yes	NULL
	confirmed	char(1)	utf8_general_ci		Yes	0
	confirmcode	varchar(32)	utf8_general_ci		Yes	NULL
	requestdate	int(11)			Yes	0
	requestip	varchar(20)	utf8_general_ci		Yes	NULL
	confirmdate	int(11)			Yes	0
	confirmip	varchar(20)	utf8_general_ci		Yes	NULL
	subscribedate	int(11)			Yes	0
	bounced	int(11)			Yes	0
	unsubscribed	int(11)			Yes	0
	unsubscribeconfirmed	char(1)	utf8_general_ci		Yes	0
	formid	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 subscriberid listid emailaddress domainname format confirmed confirmcode requestdate requestip confirmdate confirmip subscribedate bounced unsubscribed unsubscribeconfirmed formid

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 33536  subscriberid subscriberid_2 UNIQUE 33536  subscriberid subscriberid_4 UNIQUE 33536  subscriberid subscriberid_6 UNIQUE 33536  subscriberid email_subscribers_email_list_idx UNIQUE 33536  emailaddress listid confirmcode_2 UNIQUE 33536  confirmcode confirmcode_3 UNIQUE 33536  confirmcode confirmcode_5 UNIQUE 33536  confirmcode email_list_subscribers_sub_list_idx INDEX 33536  subscriberid listid email_subscribe_date_idx INDEX 3353  subscribedate subscriberid INDEX 33536  subscriberid listid INDEX 55  listid emailaddress INDEX 33536  emailaddress domainname INDEX 8384  domainname format INDEX 1  format confirmed INDEX 1  confirmed confirmcode INDEX 33536  confirmcode requestdate INDEX 2794  requestdate requestip INDEX 1  requestip confirmdate INDEX 3048  confirmdate confirmip INDEX 1  confirmip confirmip_2 INDEX 9  confirmip subscribedate INDEX 2235  subscribedate bounced INDEX 1  bounced unsubscribed INDEX 11  unsubscribed unsubscribeconfirmed INDEX 1  unsubscribeconfirmed formid INDEX 1  formid emailaddress_2 INDEX 33536  emailaddress requestip_2 INDEX 1  requestip listid_2 INDEX 55  listid confirmip_3 INDEX 9  confirmip subscribedate_2 INDEX 2395  subscribedate format_2 INDEX 1  format confirmed_2 INDEX 1  confirmed requestdate_2 INDEX 2235  requestdate subscriberid_3 INDEX 33536  subscriberid unsubscribed_2 INDEX 2794  unsubscribed unsubscribeconfirmed_2 INDEX 1  unsubscribeconfirmed confirmdate_2 INDEX 3353  confirmdate formid_2 INDEX 1  formid domainname_2 INDEX 8384  domainname confirmcode_4 INDEX 33536  confirmcode bounced_2 INDEX 1  bounced confirmip_4 INDEX 1  confirmip requestip_3 INDEX 1  requestip emailaddress_3 INDEX 33536  emailaddress listid_3 INDEX 18  listid subscribedate_3 INDEX 3048  subscribedate confirmip_5 INDEX 1  confirmip confirmed_3 INDEX 1  confirmed unsubscribed_3 INDEX 1  unsubscribed subscriberid_5 INDEX 33536  subscriberid unsubscribeconfirmed_3 INDEX 1  unsubscribeconfirmed format_3 INDEX 1  format requestdate_3 INDEX 3048  requestdate confirmdate_3 INDEX 3048  confirmdate formid_3 INDEX 1  formid bounced_3 INDEX 1  bounced domainname_3 INDEX 8384  domainname confirmcode_6 INDEX 33536  confirmcode subscribedate_4 INDEX 3353  subscribedate confirmcode_7 INDEX 33536  confirmcode bounced_4 INDEX 1  bounced confirmed_4 INDEX 1  confirmed Create an index on  columns

Space usage:  Type Usage Data 6,672 KB Index 99,200 KB Total 105,872 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 36,582 Creation Mar 19, 2018 at 05:47 AM

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `email_list_subscribers` ADD INDEX(`domainname`)		subscriberid listid emailaddress domainname format confirmed confirmcode requestdate requestip confirmdate confirmip subscribedate bounced unsubscribed unsubscribeconfirmed formid
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