Server: mysql.puroparty.com

Database: puroparty

Table: phorum_messages

Structure Browse SQL Search Insert Export Operations Empty Drop

	Field	Type	Collation	Attributes	Null	Default	Extra	Action
	message_id	int(10)		UNSIGNED	No		auto_increment
	forum_id	int(10)		UNSIGNED	No	0
	thread	int(10)		UNSIGNED	No	0
	parent_id	int(10)		UNSIGNED	No	0
	author	varchar(37)	latin1_swedish_ci		No
	subject	varchar(255)	latin1_swedish_ci		No
	body	text	latin1_swedish_ci		No
	email	varchar(100)	latin1_swedish_ci		No
	ip	varchar(255)	latin1_swedish_ci		No
	status	tinyint(4)			No	2
	msgid	varchar(100)	latin1_swedish_ci		No
	modifystamp	int(10)		UNSIGNED	No	0
	user_id	int(10)		UNSIGNED	No	0
	thread_count	int(10)		UNSIGNED	No	0
	moderator_post	tinyint(3)		UNSIGNED	No	0
	sort	tinyint(4)			No	2
	datestamp	int(10)		UNSIGNED	No	0
	meta	mediumtext	latin1_swedish_ci		Yes	NULL
	viewcount	int(10)		UNSIGNED	No	0
	closed	tinyint(4)			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 message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed

---

Indexes: Keyname Type Cardinality Action Field PRIMARY PRIMARY 3  message_id message_id_2 UNIQUE 3  message_id subject_2 UNIQUE 3  subject msgid_2 UNIQUE 3  msgid modifystamp_2 UNIQUE 3  modifystamp thread_count_2 UNIQUE 3  thread_count datestamp_2 UNIQUE 3  datestamp thread_count_3 UNIQUE 3  thread_count msgid_5 UNIQUE 3  msgid subject_4 UNIQUE 3  subject datestamp_4 UNIQUE 3  datestamp modifystamp_4 UNIQUE 3  modifystamp thread_message INDEX None  thread message_id thread_forum INDEX None  thread forum_id special_threads INDEX None  sort forum_id status_forum INDEX None  status forum_id list_page_float INDEX None  forum_id parent_id modifystamp list_page_flat INDEX None  forum_id parent_id thread post_count INDEX None  forum_id status parent_id dup_check INDEX None  forum_id author subject datestamp forum_max_message INDEX None  forum_id message_id status parent_id last_post_time INDEX None  forum_id status modifystamp next_prev_thread INDEX None  forum_id status thread user_id INDEX None  user_id message_id INDEX None  message_id forum_id INDEX None  forum_id thread INDEX None  thread parent_id INDEX None  parent_id author INDEX None  author subject INDEX None  subject email INDEX None  email ip INDEX None  ip status INDEX None  status msgid INDEX None  msgid modifystamp INDEX None  modifystamp user_id_2 INDEX None  user_id thread_count INDEX None  thread_count moderator_post INDEX None  moderator_post sort INDEX None  sort datestamp INDEX None  datestamp viewcount INDEX None  viewcount closed INDEX None  closed user_id_3 INDEX None  user_id modifystamp_3 INDEX None  modifystamp email_3 INDEX None  email msgid_4 INDEX None  msgid viewcount_2 INDEX None  viewcount forum_id_2 INDEX None  forum_id sort_2 INDEX None  sort moderator_post_2 INDEX None  moderator_post thread_2 INDEX None  thread parent_id_2 INDEX None  parent_id datestamp_3 INDEX None  datestamp thread_count_4 INDEX None  thread_count author_2 FULLTEXT None  author subject_3 FULLTEXT None  subject body FULLTEXT None  body email_2 FULLTEXT None  email ip_2 FULLTEXT None  ip msgid_3 FULLTEXT None  msgid meta FULLTEXT None  meta msgid_6 FULLTEXT None  msgid ip_3 FULLTEXT None  ip email_4 FULLTEXT None  email Create an index on  columns

Space usage:  Type Usage Data 868 Bytes Index 4,096 Bytes Total 4,964 Bytes

Row Statistic:  Statements Value Format dynamic Collation latin1_swedish_ci Rows 3 Row length ø 289 Row size  ø 1,655 Bytes Next Autoindex 4 Creation Oct 19, 2017 at 12:40 PM Last update Mar 24, 2024 at 11:04 AM Last check Mar 28, 2024 at 03:15 PM

---

Run SQL query/queries on database puroparty		Fields:
ALTER TABLE `phorum_messages` ADD UNIQUE(`viewcount`)		message_id forum_id thread parent_id author subject body email ip status msgid modifystamp user_id thread_count moderator_post sort datestamp meta viewcount closed
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