Here's what the indexes should be.
POST
Unique
msgid
Non-Unique
isusenetpost
THREAD
Unique
msgid
Non-Unique
isusenetpost
Non-Unique
regpost
USENET_ARTICLE
Primary key
msgid
forum
USENET_ARTICLE_LOADER
Primary Key
msgid
Non-Unique
forum
USENET_REF
Primary Key
msgid
ref
USENET_REPLACE
Primary Key
id
Unique
original
USENET_SETTING
Primary Key
settingid
USENET_SPAM_FILTER
Primary Key
id
Non-Unique
forum
dtm
USENET_GROUP
Primary Key
newsgroup
USENET_OUTGOING
Primary Key
postid
Non-Unique
ref
USENET_SETTINGGROUP
Primary Key
settinggroupid
Unique
expression
|