Server: mysql.puroparty.com

Database: puroparty

Table: phorum_files

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	file_id	int(11)			No		auto_increment
	user_id	int(11)			No	0
	filename	varchar(255)	latin1_swedish_ci		No
	filesize	int(11)			No	0
	file_data	mediumtext	latin1_swedish_ci		No
	add_datetime	int(10)		UNSIGNED	No	0
	message_id	int(10)		UNSIGNED	No	0
	link	varchar(10)	latin1_swedish_ci		No
Check All  /  Uncheck All     With selected:

---

Print view    Propose table structure

Add new field:  At End of Table At Beginning of Table After file_id user_id filename filesize file_data add_datetime message_id link

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 0  file_id file_id_2 UNIQUE 0  file_id user_id_2 UNIQUE 0  user_id filename_2 UNIQUE 0  filename filesize_2 UNIQUE 0  filesize add_datetime_3 UNIQUE 0  add_datetime message_id_2 UNIQUE 0  message_id link_2 UNIQUE 0  link file_id_3 UNIQUE 0  file_id add_datetime_4 UNIQUE 0  add_datetime filesize_3 UNIQUE 0  filesize filename_5 UNIQUE 0  filename link_5 UNIQUE 0  link user_id_4 UNIQUE 0  user_id message_id_4 UNIQUE 0  message_id filename_7 UNIQUE 0  filename message_id_5 UNIQUE 0  message_id file_id_5 UNIQUE 0  file_id add_datetime_6 UNIQUE 0  add_datetime link_9 UNIQUE 0  link user_id_5 UNIQUE 0  user_id filesize_5 UNIQUE 0  filesize file_id_7 UNIQUE 0  file_id message_id_7 UNIQUE 0  message_id filename_11 UNIQUE 0  filename message_id_8 UNIQUE 0  message_id add_datetime INDEX None  add_datetime message_id_link INDEX None  message_id link file_id INDEX None  file_id user_id INDEX None  user_id filename INDEX None  filename filesize INDEX None  filesize add_datetime_2 INDEX None  add_datetime message_id INDEX None  message_id link INDEX None  link message_id_3 INDEX None  message_id filename_6 INDEX None  filename file_id_4 INDEX None  file_id user_id_3 INDEX None  user_id link_6 INDEX None  link add_datetime_5 INDEX None  add_datetime filesize_4 INDEX None  filesize filename_8 INDEX None  filename link_7 INDEX None  link file_id_6 INDEX None  file_id message_id_6 INDEX None  message_id user_id_6 INDEX None  user_id add_datetime_7 INDEX None  add_datetime filesize_6 INDEX None  filesize link_10 INDEX None  link filename_10 INDEX None  filename user_id_7 INDEX None  user_id filename_3 FULLTEXT None  filename file_data FULLTEXT None  file_data link_3 FULLTEXT None  link link_4 FULLTEXT None  link file_data_2 FULLTEXT None  file_data filename_4 FULLTEXT None  filename link_8 FULLTEXT None  link filename_9 FULLTEXT None  filename file_data_3 FULLTEXT None  file_data link_11 FULLTEXT None  link file_data_4 FULLTEXT None  file_data link_12 FULLTEXT None  link 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 latin1_swedish_ci Rows 0 Next Autoindex 1 Creation Mar 05, 2018 at 04:25 PM Last update Mar 12, 2024 at 10:46 AM Last check Mar 20, 2024 at 03:13 AM

---

Run SQL query/queries on database puroparty		Fields:
SELECT * FROM `phorum_files` WHERE 1		file_id user_id filename filesize file_data add_datetime message_id link
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