Server:
mysql.puroparty.com
Database:
puroparty
Table:
phorum_messages
Modify an index
Index name :
("PRIMARY"
must
be the name of and
only of
a primary key!)
Index type :
INDEX
UNIQUE
FULLTEXT
Fields :
Field
Size
-- Ignore --
message_id [int(10) unsigned]
forum_id [int(10) unsigned]
thread [int(10) unsigned]
parent_id [int(10) unsigned]
author [varchar(37)]
subject [varchar(255)]
body [text]
email [varchar(100)]
ip [varchar(255)]
status [tinyint(4)]
msgid [varchar(100)]
modifystamp [int(10) unsigned]
user_id [int(10) unsigned]
thread_count [int(10) unsigned]
moderator_post [tinyint(3) unsigned]
sort [tinyint(4)]
datestamp [int(10) unsigned]
meta [mediumtext]
viewcount [int(10) unsigned]
closed [tinyint(4)]
Add to index
column(s)