Server: mysql.puroparty.com

Database: puroparty

Table: email_log_system_administrator

Structure Browse SQL Search Insert Export Operations Empty Drop

InnoDB free: 737280 kB

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	logid	int(11)			No		auto_increment
	loguserid	int(11)			No	0
	logip	varchar(30)	utf8_general_ci		No
	logdate	int(11)			No	0
	logtodo	varchar(100)	utf8_general_ci		No
	logdata	text	utf8_general_ci		No
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 loguserid logip logdate logtodo logdata

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  logid logid_2 UNIQUE 0  logid loguserid_2 UNIQUE 0  loguserid logip_2 UNIQUE 0  logip logdate_2 UNIQUE 0  logdate logtodo_2 UNIQUE 0  logtodo logid_4 UNIQUE 0  logid loguserid_4 UNIQUE 0  loguserid logdate_4 UNIQUE 0  logdate logtodo_4 UNIQUE 0  logtodo logip_4 UNIQUE 0  logip loguserid_5 UNIQUE 0  loguserid logid_5 UNIQUE 0  logid logdate_5 UNIQUE 0  logdate logtodo_6 UNIQUE 0  logtodo logip_6 UNIQUE 0  logip loguserid_8 UNIQUE 0  loguserid logid_8 UNIQUE 0  logid logdate_8 UNIQUE 0  logdate logtodo_8 UNIQUE 0  logtodo logip_8 UNIQUE 0  logip loguserid_9 UNIQUE 0  loguserid logid_10 UNIQUE 0  logid logtodo_9 UNIQUE 0  logtodo loguserid_11 UNIQUE 0  loguserid logip_9 UNIQUE 0  logip logid_12 UNIQUE 0  logid logdate_10 UNIQUE 0  logdate logdate_12 UNIQUE 0  logdate logid_14 UNIQUE 0  logid loguserid_14 UNIQUE 0  loguserid logid INDEX 0  logid loguserid INDEX 0  loguserid logip INDEX 0  logip logdate INDEX 0  logdate logtodo INDEX 0  logtodo logid_3 INDEX 0  logid logdate_3 INDEX 0  logdate loguserid_3 INDEX 0  loguserid logip_3 INDEX 0  logip logtodo_3 INDEX 0  logtodo loguserid_6 INDEX 0  loguserid logid_6 INDEX 0  logid logip_5 INDEX 0  logip logtodo_5 INDEX 0  logtodo logdate_6 INDEX 0  logdate logdate_7 INDEX 0  logdate loguserid_7 INDEX 0  loguserid logid_7 INDEX 0  logid logtodo_7 INDEX 0  logtodo logip_7 INDEX 0  logip logid_9 INDEX 0  logid logid_11 INDEX 0  logid loguserid_10 INDEX 0  loguserid loguserid_12 INDEX 0  loguserid logdate_9 INDEX 0  logdate logtodo_10 INDEX 0  logtodo logip_10 INDEX 0  logip logdate_11 INDEX 0  logdate logtodo_11 INDEX 0  logtodo logip_11 INDEX 0  logip logid_13 INDEX 0  logid loguserid_13 INDEX 0  loguserid logip_12 INDEX 0  logip 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 Jun 17, 2018 at 06:11 PM

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `email_log_system_administrator` WHERE 1		logid loguserid logip logdate logtodo logdata
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