Server: mysql.puroparty.com

Database: puroparty

Table: photopost_cache

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	id	tinyint(1)			No	1
	timestamp	int(15)			No	0
	statscache	mediumtext	latin1_swedish_ci		Yes	NULL
	recentcache	mediumtext	latin1_swedish_ci		Yes	NULL
	popularcache	mediumtext	latin1_swedish_ci		Yes	NULL
	randomcache	mediumtext	latin1_swedish_ci		Yes	NULL
	calcache	mediumtext	latin1_swedish_ci		Yes	NULL
	catcache	mediumtext	latin1_swedish_ci		Yes	NULL
	catprops	mediumtext	latin1_swedish_ci		Yes	NULL
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After id timestamp statscache recentcache popularcache randomcache calcache catcache catprops

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 1  id id_3 UNIQUE 1  id timestamp_2 UNIQUE 1  timestamp id_4 UNIQUE 1  id timestamp_4 UNIQUE 1  timestamp id_6 UNIQUE 1  id timestamp_6 UNIQUE 1  timestamp id_8 UNIQUE 1  id id_11 UNIQUE 1  id timestamp_9 UNIQUE 1  timestamp timestamp_10 UNIQUE 1  timestamp id_12 UNIQUE 1  id id_13 UNIQUE 1  id id_14 UNIQUE 1  id id_15 UNIQUE 1  id id_16 UNIQUE 1  id id_17 UNIQUE 1  id id INDEX None  id id_2 INDEX None  id timestamp INDEX None  timestamp timestamp_3 INDEX None  timestamp id_5 INDEX None  id timestamp_5 INDEX None  timestamp id_7 INDEX None  id timestamp_7 INDEX None  timestamp id_9 INDEX None  id id_10 INDEX None  id timestamp_8 INDEX None  timestamp statscache FULLTEXT None  statscache recentcache FULLTEXT None  recentcache popularcache FULLTEXT None  popularcache randomcache FULLTEXT None  randomcache calcache FULLTEXT None  calcache catcache FULLTEXT None  catcache catprops FULLTEXT None  catprops calcache_2 FULLTEXT None  calcache catprops_2 FULLTEXT None  catprops recentcache_2 FULLTEXT None  recentcache popularcache_2 FULLTEXT None  popularcache catcache_2 FULLTEXT None  catcache randomcache_2 FULLTEXT None  randomcache statscache_2 FULLTEXT None  statscache catprops_3 FULLTEXT None  catprops calcache_3 FULLTEXT None  calcache recentcache_3 FULLTEXT None  recentcache randomcache_3 FULLTEXT None  randomcache catcache_3 FULLTEXT None  catcache popularcache_3 FULLTEXT None  popularcache statscache_3 FULLTEXT None  statscache catprops_4 FULLTEXT None  catprops recentcache_4 FULLTEXT None  recentcache randomcache_4 FULLTEXT None  randomcache calcache_4 FULLTEXT None  calcache statscache_4 FULLTEXT None  statscache recentcache_5 FULLTEXT None  recentcache popularcache_4 FULLTEXT None  popularcache randomcache_5 FULLTEXT None  randomcache calcache_5 FULLTEXT None  calcache catcache_4 FULLTEXT None  catcache catprops_5 FULLTEXT None  catprops popularcache_5 FULLTEXT None  popularcache catcache_5 FULLTEXT None  catcache statscache_5 FULLTEXT None  statscache catprops_6 FULLTEXT None  catprops Create an index on  columns

Space usage:  Type Usage Data 6,552 Bytes Index 3,072 Bytes Total 9,624 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 1 Row length ø 6,552 Row size  ø 9,624 Bytes Creation Nov 14, 2021 at 05:35 AM Last update Nov 14, 2021 at 05:35 AM Last check Mar 29, 2024 at 07:45 AM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `photopost_cache` ADD INDEX(`randomcache`)		id timestamp statscache recentcache popularcache randomcache calcache catcache catprops
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