Server: mysql.puroparty.com

Database: puroparty

Table: bak_core_log_items

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	time_stamp	date			No	0000-00-00
	item_table	varchar(50)	utf8_general_ci		No
	item_id	int(11)		UNSIGNED	No	0
	hits	int(11)		UNSIGNED	No	0
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After time_stamp item_table item_id hits

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  time_stamp time_stamp_2 UNIQUE 0  time_stamp item_table_2 UNIQUE 0  item_table item_id_2 UNIQUE 0  item_id hits_2 UNIQUE 0  hits hits_3 UNIQUE 0  hits time_stamp_4 UNIQUE 0  time_stamp item_id_4 UNIQUE 0  item_id item_table_6 UNIQUE 0  item_table time_stamp_5 UNIQUE 0  time_stamp item_id_5 UNIQUE 0  item_id item_table_8 UNIQUE 0  item_table hits_6 UNIQUE 0  hits time_stamp_8 UNIQUE 0  time_stamp item_table_11 UNIQUE 0  item_table item_id_8 UNIQUE 0  item_id hits_8 UNIQUE 0  hits hits_9 UNIQUE 0  hits item_id_9 UNIQUE 0  item_id time_stamp_10 UNIQUE 0  time_stamp item_table_14 UNIQUE 0  item_table item_id_11 UNIQUE 0  item_id item_table_16 UNIQUE 0  item_table time_stamp_12 UNIQUE 0  time_stamp hits_11 UNIQUE 0  hits hits_12 UNIQUE 0  hits item_id_13 UNIQUE 0  item_id time_stamp_14 UNIQUE 0  time_stamp time_stamp_16 UNIQUE 0  time_stamp time_stamp INDEX None  time_stamp item_table INDEX None  item_table item_id INDEX None  item_id hits INDEX None  hits time_stamp_3 INDEX None  time_stamp item_id_3 INDEX None  item_id item_table_5 INDEX None  item_table hits_4 INDEX None  hits time_stamp_6 INDEX None  time_stamp hits_5 INDEX None  hits item_id_6 INDEX None  item_id item_table_9 INDEX None  item_table time_stamp_7 INDEX None  time_stamp item_table_10 INDEX None  item_table item_id_7 INDEX None  item_id hits_7 INDEX None  hits time_stamp_9 INDEX None  time_stamp item_id_10 INDEX None  item_id item_table_15 INDEX None  item_table hits_10 INDEX None  hits item_id_12 INDEX None  item_id item_table_17 INDEX None  item_table time_stamp_11 INDEX None  time_stamp time_stamp_13 INDEX None  time_stamp hits_13 INDEX None  hits item_id_14 INDEX None  item_id time_stamp_15 INDEX None  time_stamp item_table_20 INDEX None  item_table item_table_3 FULLTEXT None  item_table item_table_4 FULLTEXT None  item_table item_table_7 FULLTEXT None  item_table item_table_12 FULLTEXT None  item_table item_table_13 FULLTEXT None  item_table item_table_18 FULLTEXT None  item_table item_table_19 FULLTEXT None  item_table Create an index on  columns

Space usage:  Type Usage Data 0 Bytes Index 3,072 Bytes Total 3,072 Bytes

Row Statistic:  Statements Value Format dynamic Collation utf8_general_ci Rows 0 Creation Apr 12, 2018 at 09:19 PM Last update Mar 06, 2024 at 01:05 PM Last check Apr 19, 2024 at 12:15 AM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `bak_core_log_items` WHERE 1		time_stamp item_table item_id hits
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