Server: mysql.puroparty.com

Database: puroparty

Table: email_log_system_system

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 739328 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	logid	int(11)			No		auto_increment
	logtype	varchar(20)	utf8_general_ci		Yes	NULL
	logmodule	varchar(100)	utf8_general_ci		No
	logseverity	char(1)	utf8_general_ci		No	4
	logsummary	varchar(250)	utf8_general_ci		No
	logmsg	text	utf8_general_ci		No
	logdate	int(11)			No	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 logid logtype logmodule logseverity logsummary logmsg logdate

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 5062  logid logid_2 UNIQUE 5062  logid logid_4 UNIQUE 5062  logid logid_5 UNIQUE 5062  logid logid_7 UNIQUE 5062  logid logid_9 UNIQUE 5062  logid logid_10 UNIQUE 5062  logid logid_14 UNIQUE 5062  logid logid INDEX 5062  logid logtype INDEX 2  logtype logmodule INDEX 2  logmodule logseverity INDEX 2  logseverity logsummary INDEX 5062  logsummary logdate INDEX 1265  logdate logdate_2 INDEX 1265  logdate logid_3 INDEX 5062  logid logtype_2 INDEX 2  logtype logsummary_2 INDEX 5062  logsummary logseverity_2 INDEX 2  logseverity logmodule_2 INDEX 2  logmodule logsummary_3 INDEX 5062  logsummary logdate_3 INDEX 1265  logdate logid_6 INDEX 5062  logid logtype_3 INDEX 2  logtype logmodule_3 INDEX 2  logmodule logseverity_3 INDEX 2  logseverity logseverity_4 INDEX 2  logseverity logdate_4 INDEX 1265  logdate logtype_4 INDEX 2  logtype logsummary_4 INDEX 5062  logsummary logid_8 INDEX 5062  logid logmodule_4 INDEX 2  logmodule logdate_5 INDEX 1265  logdate logseverity_5 INDEX 2  logseverity logmodule_5 INDEX 2  logmodule logdate_6 INDEX 1265  logdate logseverity_6 INDEX 2  logseverity logid_11 INDEX 5062  logid logsummary_5 INDEX 5062  logsummary logid_12 INDEX 5062  logid logtype_5 INDEX 2  logtype logsummary_6 INDEX 5062  logsummary logtype_6 INDEX 2  logtype logmodule_6 INDEX 2  logmodule logid_13 INDEX 5062  logid logtype_7 INDEX 2  logtype logmodule_7 INDEX 2  logmodule logseverity_7 INDEX 2  logseverity logsummary_7 INDEX 5062  logsummary logdate_7 INDEX 1265  logdate logseverity_8 INDEX 2  logseverity logid_15 INDEX 5062  logid logdate_8 INDEX 1265  logdate logtype_8 INDEX 2  logtype logsummary_8 INDEX 5062  logsummary logmodule_8 INDEX 2  logmodule logseverity_9 INDEX 2  logseverity logid_16 INDEX 5062  logid logdate_9 INDEX 1265  logdate logtype_9 INDEX 2  logtype logmodule_9 INDEX 2  logmodule logsummary_9 INDEX 5062  logsummary logsummary_10 INDEX 5062  logsummary logmodule_10 INDEX 2  logmodule Create an index on  columns

Space usage:  Type Usage Data 10,256 KB Index 28,560 KB Total 38,816 KB

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Next Autoindex 8,620 Creation May 24, 2018 at 03:34 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_log_system_system` WHERE 1		logid logtype logmodule logseverity logsummary logmsg logdate
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