Server: mysql.puroparty.com

Database: puroparty

Table: email_stats_emailforwards

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 738304 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	forwardid	int(11)			No		auto_increment
	forwardtime	int(11)			Yes	0
	forwardip	varchar(20)	utf8_general_ci		Yes	NULL
	subscriberid	int(11)			Yes	NULL
	statid	int(11)			Yes	0
	subscribed	int(11)			Yes	0
	listid	int(11)			Yes	NULL
	emailaddress	varchar(255)	utf8_general_ci		Yes	NULL
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 forwardid forwardtime forwardip subscriberid statid subscribed listid emailaddress

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  forwardid forwardid_2 UNIQUE 0  forwardid forwardid_4 UNIQUE 0  forwardid forwardid_6 UNIQUE 0  forwardid forwardtime_2 UNIQUE 0  forwardtime forwardip_2 UNIQUE 0  forwardip subscriberid_2 UNIQUE 0  subscriberid statid_2 UNIQUE 0  statid subscribed_2 UNIQUE 0  subscribed listid_2 UNIQUE 0  listid emailaddress_2 UNIQUE 0  emailaddress statid_3 UNIQUE 0  statid forwardip_3 UNIQUE 0  forwardip forwardtime_3 UNIQUE 0  forwardtime subscribed_4 UNIQUE 0  subscribed listid_4 UNIQUE 0  listid emailaddress_4 UNIQUE 0  emailaddress subscriberid_4 UNIQUE 0  subscriberid forwardip_5 UNIQUE 0  forwardip subscriberid_5 UNIQUE 0  subscriberid emailaddress_5 UNIQUE 0  emailaddress forwardtime_5 UNIQUE 0  forwardtime subscribed_6 UNIQUE 0  subscribed statid_6 UNIQUE 0  statid listid_6 UNIQUE 0  listid listid_7 UNIQUE 0  listid statid_7 UNIQUE 0  statid emailaddress_8 UNIQUE 0  emailaddress subscribed_8 UNIQUE 0  subscribed forwardip_7 UNIQUE 0  forwardip forwardtime_7 UNIQUE 0  forwardtime subscriberid_8 UNIQUE 0  subscriberid email_stats_emailforwards_subscriberid_idx INDEX 0  subscriberid email_stats_emailforwards_statid_idx INDEX 0  statid email_stats_emailforwards_listid_idx INDEX 0  listid forwardid INDEX 0  forwardid forwardtime INDEX 0  forwardtime forwardip INDEX 0  forwardip subscriberid INDEX 0  subscriberid statid INDEX 0  statid subscribed INDEX 0  subscribed listid INDEX 0  listid emailaddress INDEX 0  emailaddress statid_4 INDEX 0  statid subscribed_3 INDEX 0  subscribed forwardtime_4 INDEX 0  forwardtime listid_3 INDEX 0  listid forwardid_3 INDEX 0  forwardid emailaddress_3 INDEX 0  emailaddress subscriberid_3 INDEX 0  subscriberid forwardip_4 INDEX 0  forwardip forwardid_5 INDEX 0  forwardid emailaddress_6 INDEX 0  emailaddress subscriberid_6 INDEX 0  subscriberid statid_5 INDEX 0  statid listid_5 INDEX 0  listid subscribed_5 INDEX 0  subscribed forwardtime_6 INDEX 0  forwardtime forwardip_6 INDEX 0  forwardip emailaddress_7 INDEX 0  emailaddress subscribed_7 INDEX 0  subscribed listid_8 INDEX 0  listid subscriberid_7 INDEX 0  subscriberid statid_8 INDEX 0  statid 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 Mar 15, 2024 at 08:17 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_stats_emailforwards` WHERE 1		forwardid forwardtime forwardip subscriberid statid subscribed listid emailaddress
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