Here's the alter script from a stock database that you could apply.
ALTER TABLE [dbo].[FORUM_BADWORDS] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[B_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_GROUPS] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[GROUP_KEY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_GROUP_NAMES] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[GROUP_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_NAMEFILTER] WITH NOCHECK ADD
PRIMARY KEY CLUSTERED
(
[N_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_ALLOWED_MEMBERS] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC373] PRIMARY KEY NONCLUSTERED
(
[MEMBER_ID],
[FORUM_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_CATEGORY] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC1] DEFAULT (1) FOR [CAT_STATUS],
CONSTRAINT [FORUM_SnitzC1020] DEFAULT (0) FOR [CAT_MODERATION],
CONSTRAINT [FORUM_SnitzC1021] DEFAULT (0) FOR [CAT_SUBSCRIPTION],
CONSTRAINT [FORUM_SnitzC1022] DEFAULT (1) FOR [CAT_ORDER],
CONSTRAINT [FORUM_SnitzC2] PRIMARY KEY NONCLUSTERED
(
[CAT_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_CONFIG_NEW] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC38] PRIMARY KEY NONCLUSTERED
(
[ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_FORUM] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC39] DEFAULT (0) FOR [CAT_ID],
CONSTRAINT [FORUM_SnitzC40] DEFAULT (1) FOR [F_STATUS],
CONSTRAINT [FORUM_SnitzC41] DEFAULT (0) FOR [F_MAIL],
CONSTRAINT [FORUM_SnitzC42] DEFAULT (0) FOR [F_TOPICS],
CONSTRAINT [FORUM_SnitzC43] DEFAULT (0) FOR [F_COUNT],
CONSTRAINT [FORUM_SnitzC44] DEFAULT ('') FOR [F_LAST_POST],
CONSTRAINT [FORUM_SnitzC45] DEFAULT (0) FOR [F_PRIVATEFORUMS],
CONSTRAINT [FORUM_SnitzC46] DEFAULT (0) FOR [F_TYPE],
CONSTRAINT [FORUM_SnitzC47] DEFAULT ('000.000.000.000') FOR [F_IP],
CONSTRAINT [DF__FORUM_FOR__F_DEF__4CA06362] DEFAULT (30) FOR [F_DEFAULTDAYS],
CONSTRAINT [DF__FORUM_FOR__F_COU__4D94879B] DEFAULT (1) FOR [F_COUNT_M_POSTS],
CONSTRAINT [FORUM_SnitzC1018] DEFAULT (0) FOR [F_MODERATION],
CONSTRAINT [FORUM_SnitzC1019] DEFAULT (0) FOR [F_SUBSCRIPTION],
CONSTRAINT [FORUM_SnitzC1025] DEFAULT (1) FOR [F_ORDER],
CONSTRAINT [FORUM_SnitzC1026] DEFAULT ('') FOR [F_L_ARCHIVE],
CONSTRAINT [FORUM_SnitzC1027] DEFAULT (30) FOR [F_ARCHIVE_SCHED],
CONSTRAINT [FORUM_SnitzC1028] DEFAULT ('') FOR [F_L_DELETE],
CONSTRAINT [FORUM_SnitzC1029] DEFAULT (365) FOR [F_DELETE_SCHED],
CONSTRAINT [FORUM_SnitzC48] PRIMARY KEY NONCLUSTERED
(
[CAT_ID],
[FORUM_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_MEMBERS] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC49] DEFAULT (1) FOR [M_STATUS],
CONSTRAINT [DF__FORUM_MEM__M_NAM__5629CD9C] DEFAULT ('') FOR [M_NAME],
CONSTRAINT [DF__FORUM_MEM__M_USE__571DF1D5] DEFAULT ('') FOR [M_USERNAME],
CONSTRAINT [DF__FORUM_MEM__M_PAS__5812160E] DEFAULT ('') FOR [M_PASSWORD],
CONSTRAINT [DF__FORUM_MEM__M_EMA__59063A47] DEFAULT ('') FOR [M_EMAIL],
CONSTRAINT [DF__FORUM_MEM__M_COU__59FA5E80] DEFAULT ('') FOR [M_COUNTRY],
CONSTRAINT [DF__FORUM_MEM__M_HOM__5AEE82B9] DEFAULT ('') FOR [M_HOMEPAGE],
CONSTRAINT [DF__FORUM_MEM__M_SIG__5BE2A6F2] DEFAULT ('') FOR [M_SIG],
CONSTRAINT [DF__FORUM_MEM__M_VIE__5CD6CB2B] DEFAULT (1) FOR [M_VIEW_SIG],
CONSTRAINT [DF__FORUM_MEM__M_SIG__5DCAEF64] DEFAULT (1) FOR [M_SIG_DEFAULT],
CONSTRAINT [FORUM_SnitzC50] DEFAULT (1) FOR [M_DEFAULT_VIEW],
CONSTRAINT [FORUM_SnitzC51] DEFAULT (1) FOR [M_LEVEL],
CONSTRAINT [DF__FORUM_MEM__M_AIM__5EBF139D] DEFAULT ('') FOR [M_AIM],
CONSTRAINT [DF__FORUM_MEM__M_ICQ__5FB337D6] DEFAULT ('') FOR [M_ICQ],
CONSTRAINT [DF__FORUM_MEM__M_MSN__60A75C0F] DEFAULT ('') FOR [M_MSN],
CONSTRAINT [DF__FORUM_MEM__M_YAH__619B8048] DEFAULT ('') FOR [M_YAHOO],
CONSTRAINT [DF__FORUM_MEM__M_POS__628FA481] DEFAULT ('0') FOR [M_POSTS],
CONSTRAINT [FORUM_SnitzC52] DEFAULT ('') FOR [M_DATE],
CONSTRAINT [DF__FORUM_MEM__M_LAS__6383C8BA] DEFAULT ('') FOR [M_LASTHEREDATE],
CONSTRAINT [DF__FORUM_MEM__M_LAS__6477ECF3] DEFAULT ('') FOR [M_LASTPOSTDATE],
CONSTRAINT [DF__FORUM_MEM__M_TIT__656C112C] DEFAULT ('') FOR [M_TITLE],
CONSTRAINT [FORUM_SnitzC53] DEFAULT (0) FOR [M_SUBSCRIPTION],
CONSTRAINT [FORUM_SnitzC54] DEFAULT (0) FOR [M_HIDE_EMAIL],
CONSTRAINT [FORUM_SnitzC55] DEFAULT (1) FOR [M_RECEIVE_EMAIL],
CONSTRAINT [FORUM_SnitzC56] DEFAULT ('000.000.000.000') FOR [M_LAST_IP],
CONSTRAINT [FORUM_SnitzC57] DEFAULT ('000.000.000.000') FOR [M_IP],
CONSTRAINT [FORUM_SnitzC0369] DEFAULT ('') FOR [M_FIRSTNAME],
CONSTRAINT [FORUM_SnitzC0370] DEFAULT ('') FOR [M_LASTNAME],
CONSTRAINT [FORUM_SnitzC0371] DEFAULT ('') FOR [M_OCCUPATION],
CONSTRAINT [FORUM_SnitzC0372] DEFAULT ('') FOR [M_SEX],
CONSTRAINT [FORUM_SnitzC0373] DEFAULT ('') FOR [M_AGE],
CONSTRAINT [DF__FORUM_MEM__M_DOB__6B24EA82] DEFAULT ('') FOR [M_DOB],
CONSTRAINT [DF__FORUM_MEM__M_HOB__6C190EBB] DEFAULT ('') FOR [M_HOBBIES],
CONSTRAINT [DF__FORUM_MEM__M_LNE__6D0D32F4] DEFAULT ('') FOR [M_LNEWS],
CONSTRAINT [DF__FORUM_MEM__M_QUO__6E01572D] DEFAULT ('') FOR [M_QUOTE],
CONSTRAINT [DF__FORUM_MEM__M_BIO__6EF57B66] DEFAULT ('') FOR [M_BIO],
CONSTRAINT [FORUM_SnitzC0374] DEFAULT ('') FOR [M_MARSTATUS],
CONSTRAINT [FORUM_SnitzC0375] DEFAULT ('') FOR [M_LINK1],
CONSTRAINT [FORUM_SnitzC0376] DEFAULT ('') FOR [M_LINK2],
CONSTRAINT [FORUM_SnitzC0377] DEFAULT ('') FOR [M_CITY],
CONSTRAINT [FORUM_SnitzC0379] DEFAULT ('') FOR [M_STATE],
CONSTRAINT [FORUM_SnitzC0378] DEFAULT ('') FOR [M_PHOTO_URL],
CONSTRAINT [DF__FORUM_MEM__M_KEY__75A278F5] DEFAULT ('') FOR [M_KEY],
CONSTRAINT [DF__FORUM_MEM__M_NEW__76969D2E] DEFAULT ('') FOR [M_NEWEMAIL],
CONSTRAINT [DF__FORUM_MEM__M_PWK__778AC167] DEFAULT ('') FOR [M_PWKEY],
CONSTRAINT [DF__FORUM_MEM__M_SHA__787EE5A0] DEFAULT (1) FOR [M_SHA256],
CONSTRAINT [FORUM_SnitzC58] PRIMARY KEY NONCLUSTERED
(
[MEMBER_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_MEMBERS_PENDING] WITH NOCHECK ADD
CONSTRAINT [DF__FORUM_MEM__M_NAM__7A672E12] DEFAULT ('') FOR [M_NAME],
CONSTRAINT [DF__FORUM_MEM__M_USE__7B5B524B] DEFAULT ('') FOR [M_USERNAME],
CONSTRAINT [DF__FORUM_MEM__M_PAS__7C4F7684] DEFAULT ('') FOR [M_PASSWORD],
CONSTRAINT [DF__FORUM_MEM__M_EMA__7D439ABD] DEFAULT ('') FOR [M_EMAIL],
CONSTRAINT [DF__FORUM_MEM__M_COU__7E37BEF6] DEFAULT ('') FOR [M_COUNTRY],
CONSTRAINT [DF__FORUM_MEM__M_HOM__7F2BE32F] DEFAULT ('') FOR [M_HOMEPAGE],
CONSTRAINT [DF__FORUM_MEM__M_SIG__00200768] DEFAULT ('') FOR [M_SIG],
CONSTRAINT [DF__FORUM_MEM__M_VIE__01142BA1] DEFAULT (1) FOR [M_VIEW_SIG],
CONSTRAINT [DF__FORUM_MEM__M_SIG__02084FDA] DEFAULT (1) FOR [M_SIG_DEFAULT],
CONSTRAINT [DF__FORUM_MEM__M_AIM__02FC7413] DEFAULT ('') FOR [M_AIM],
CONSTRAINT [DF__FORUM_MEM__M_ICQ__03F0984C] DEFAULT ('') FOR [M_ICQ],
CONSTRAINT [DF__FORUM_MEM__M_MSN__04E4BC85] DEFAULT ('') FOR [M_MSN],
CONSTRAINT [DF__FORUM_MEM__M_YAH__05D8E0BE] DEFAULT ('') FOR [M_YAHOO],
CONSTRAINT [DF__FORUM_MEM__M_POS__06CD04F7] DEFAULT ('0') FOR [M_POSTS],
CONSTRAINT [DF__FORUM_MEM__M_LAS__07C12930] DEFAULT ('') FOR [M_LASTHEREDATE],
CONSTRAINT [DF__FORUM_MEM__M_LAS__08B54D69] DEFAULT ('') FOR [M_LASTPOSTDATE],
CONSTRAINT [DF__FORUM_MEM__M_TIT__09A971A2] DEFAULT ('') FOR [M_TITLE],
CONSTRAINT [DF__FORUM_MEM__M_HID__0A9D95DB] DEFAULT (0) FOR [M_HIDE_EMAIL],
CONSTRAINT [DF__FORUM_MEM__M_REC__0B91BA14] DEFAULT (1) FOR [M_RECEIVE_EMAIL],
CONSTRAINT [DF__FORUM_MEM__M_FIR__0C85DE4D] DEFAULT ('') FOR [M_FIRSTNAME],
CONSTRAINT [DF__FORUM_MEM__M_LAS__0D7A0286] DEFAULT ('') FOR [M_LASTNAME],
CONSTRAINT [DF__FORUM_MEM__M_OCC__0E6E26BF] DEFAULT ('') FOR [M_OCCUPATION],
CONSTRAINT [DF__FORUM_MEM__M_SEX__0F624AF8] DEFAULT ('') FOR [M_SEX],
CONSTRAINT [DF__FORUM_MEM__M_AGE__10566F31] DEFAULT ('') FOR [M_AGE],
CONSTRAINT [DF__FORUM_MEM__M_DOB__114A936A] DEFAULT ('') FOR [M_DOB],
CONSTRAINT [DF__FORUM_MEM__M_HOB__123EB7A3] DEFAULT ('') FOR [M_HOBBIES],
CONSTRAINT [DF__FORUM_MEM__M_LNE__1332DBDC] DEFAULT ('') FOR [M_LNEWS],
CONSTRAINT [DF__FORUM_MEM__M_QUO__14270015] DEFAULT ('') FOR [M_QUOTE],
CONSTRAINT [DF__FORUM_MEM__M_BIO__151B244E] DEFAULT ('') FOR [M_BIO],
CONSTRAINT [DF__FORUM_MEM__M_MAR__160F4887] DEFAULT ('') FOR [M_MARSTATUS],
CONSTRAINT [DF__FORUM_MEM__M_LIN__17036CC0] DEFAULT ('') FOR [M_LINK1],
CONSTRAINT [DF__FORUM_MEM__M_LIN__17F790F9] DEFAULT ('') FOR [M_LINK2],
CONSTRAINT [DF__FORUM_MEM__M_CIT__18EBB532] DEFAULT ('') FOR [M_CITY],
CONSTRAINT [DF__FORUM_MEM__M_STA__19DFD96B] DEFAULT ('') FOR [M_STATE],
CONSTRAINT [DF__FORUM_MEM__M_PHO__1AD3FDA4] DEFAULT ('') FOR [M_PHOTO_URL],
CONSTRAINT [DF__FORUM_MEM__M_KEY__1BC821DD] DEFAULT ('') FOR [M_KEY],
CONSTRAINT [DF__FORUM_MEM__M_NEW__1CBC4616] DEFAULT ('') FOR [M_NEWEMAIL],
CONSTRAINT [DF__FORUM_MEM__M_PWK__1DB06A4F] DEFAULT ('') FOR [M_PWKEY],
CONSTRAINT [DF__FORUM_MEM__M_APP__1EA48E88] DEFAULT ('') FOR [M_APPROVE],
CONSTRAINT [DF__FORUM_MEM__M_SHA__1F98B2C1] DEFAULT (1) FOR [M_SHA256]
GO
ALTER TABLE [dbo].[FORUM_MODERATOR] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC59] DEFAULT (0) FOR [FORUM_ID],
CONSTRAINT [FORUM_SnitzC60] DEFAULT (0) FOR [MEMBER_ID],
CONSTRAINT [FORUM_SnitzC61] DEFAULT (0) FOR [MOD_TYPE],
CONSTRAINT [FORUM_SnitzC62] PRIMARY KEY NONCLUSTERED
(
[MOD_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_REPLY] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC63] DEFAULT (0) FOR [CAT_ID],
CONSTRAINT [FORUM_SnitzC64] DEFAULT (0) FOR [FORUM_ID],
CONSTRAINT [FORUM_SnitzC65] DEFAULT (0) FOR [TOPIC_ID],
CONSTRAINT [FORUM_SnitzC66] DEFAULT (0) FOR [R_MAIL],
CONSTRAINT [FORUM_SnitzC67] DEFAULT (0) FOR [R_AUTHOR],
CONSTRAINT [FORUM_SnitzC68] DEFAULT ('') FOR [R_DATE],
CONSTRAINT [FORUM_SnitzC69] DEFAULT ('000.000.000.000') FOR [R_IP],
CONSTRAINT [FORUM_SnitzC1017] DEFAULT (0) FOR [R_STATUS],
CONSTRAINT [FORUM_SnitzC70] PRIMARY KEY NONCLUSTERED
(
[CAT_ID],
[FORUM_ID],
[TOPIC_ID],
[REPLY_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_TOPICS] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC71] DEFAULT (0) FOR [CAT_ID],
CONSTRAINT [FORUM_SnitzC72] DEFAULT (0) FOR [FORUM_ID],
CONSTRAINT [FORUM_SnitzC73] DEFAULT (1) FOR [T_STATUS],
CONSTRAINT [FORUM_SnitzC74] DEFAULT (0) FOR [T_MAIL],
CONSTRAINT [FORUM_SnitzC75] DEFAULT (0) FOR [T_AUTHOR],
CONSTRAINT [FORUM_SnitzC76] DEFAULT (0) FOR [T_REPLIES],
CONSTRAINT [FORUM_SnitzC77] DEFAULT (0) FOR [T_VIEW_COUNT],
CONSTRAINT [FORUM_SnitzC78] DEFAULT ('') FOR [T_LAST_POST],
CONSTRAINT [FORUM_SnitzC79] DEFAULT ('') FOR [T_DATE],
CONSTRAINT [FORUM_SnitzC80] DEFAULT (0) FOR [T_LAST_POSTER],
CONSTRAINT [FORUM_SnitzC81] DEFAULT ('000.000.000.000') FOR [T_IP],
CONSTRAINT [FORUM_SnitzC82] DEFAULT (0) FOR [T_ARCHIVE_FLAG],
CONSTRAINT [DF__FORUM_TOP__T_STI__245D67DE] DEFAULT (0) FOR [T_STICKY],
CONSTRAINT [DF__FORUM_TOP__T_SIG__25518C17] DEFAULT (0) FOR [T_SIG],
CONSTRAINT [FORUM_SnitzC83] PRIMARY KEY NONCLUSTERED
(
[CAT_ID],
[FORUM_ID],
[TOPIC_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FORUM_TOTALS] WITH NOCHECK ADD
CONSTRAINT [FORUM_SnitzC84] DEFAULT (0) FOR [COUNT_ID],
CONSTRAINT [FORUM_SnitzC85] DEFAULT (0) FOR [P_COUNT],
CONSTRAINT [FORUM_SnitzC86] DEFAULT (0) FOR [T_COUNT],
CONSTRAINT [FORUM_SnitzC87] DEFAULT (0) FOR [U_COUNT],
CONSTRAINT [FORUM_SnitzC88] PRIMARY KEY NONCLUSTERED
(
[COUNT_ID]
) ON [PRIMARY]
GO
CREATE INDEX [FORUM_CATEGORY_CAT_ID] ON [dbo].[FORUM_CATEGORY]([CAT_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_CATEGORY_CAT_STATUS] ON [dbo].[FORUM_CATEGORY]([CAT_STATUS]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_CAT_ID] ON [dbo].[FORUM_FORUM]([CAT_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_F_CAT] ON [dbo].[FORUM_FORUM]([CAT_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_FORUM_ID] ON [dbo].[FORUM_FORUM]([FORUM_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_MEMBERS_MEMBER_ID] ON [dbo].[FORUM_MEMBERS]([MEMBER_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_MODERATOR_FORUM_ID] ON [dbo].[FORUM_MODERATOR]([FORUM_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_MODERATORS_MEMBER_ID] ON [dbo].[FORUM_MODERATOR]([MEMBER_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_REPLY_R_AUTHOR] ON [dbo].[FORUM_REPLY]([R_AUTHOR]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_REPLY_CATFORTOP_ID] ON [dbo].[FORUM_REPLY]([CAT_ID], [FORUM_ID], [TOPIC_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_FORUM_ID] ON [dbo].[FORUM_REPLY]([FORUM_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_REPLY_ID] ON [dbo].[FORUM_REPLY]([REPLY_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_REPLY_TOPIC_ID] ON [dbo].[FORUM_REPLY]([TOPIC_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_TOPICS_CAT_ID_FORUM_ID] ON [dbo].[FORUM_TOPICS]([CAT_ID], [FORUM_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_TOPICS_T_AUTHOR] ON [dbo].[FORUM_TOPICS]([T_AUTHOR]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_TOPICS_CAT_ID] ON [dbo].[FORUM_TOPICS]([CAT_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_FORUM_ID] ON [dbo].[FORUM_TOPICS]([FORUM_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_TOPICS_TOPIC_ID] ON [dbo].[FORUM_TOPICS]([TOPIC_ID]) ON [PRIMARY]
GO
CREATE INDEX [FORUM_TOPICS_CAT_FOR_TOP] ON [dbo].[FORUM_TOPICS]([CAT_ID], [FORUM_ID], [TOPIC_ID]) ON [PRIMARY]
GO
Topic Locked
Posted - 06 October 2004 : 16:09:12
) to go delving further.