cs_schema.sql

解压即可使用

ALTER TABLE [dbo].[cs_Threads] ADD CONSTRAINT [PK_cs_Threads] PRIMARY KEY CLUSTERED  ([ThreadID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Posts_InCategories] ADD CONSTRAINT [PK_cs_PostsInCategories] PRIMARY KEY CLUSTERED  ([CategoryID], [PostID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_PostRating] ADD CONSTRAINT [IX_cs_PostRating] UNIQUE NONCLUSTERED  ([UserID], [ThreadID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SiteMappings] ADD CONSTRAINT [PK_cs_SiteMappings] PRIMARY KEY CLUSTERED  ([SettingsID], [SiteID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_PostMetadata] ADD CONSTRAINT [PK_cs_PostMetadata] PRIMARY KEY CLUSTERED  ([PostID], [MetaKey])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Urls] ADD CONSTRAINT [PK_cs_Urls] PRIMARY KEY CLUSTERED  ([UrlID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_CodeServiceType] ADD CONSTRAINT [PK_SERVICE_TYPE_CODE] PRIMARY KEY CLUSTERED  ([ServiceTypeCode])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SectionPermissions] ADD CONSTRAINT [PK_cs_SectionPermissions] PRIMARY KEY CLUSTERED  ([SettingsID], [SectionID], [RoleID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Moderators] ADD CONSTRAINT [PK_Moderators] PRIMARY KEY CLUSTERED  ([UserID], [SectionID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SectionsRead] ADD CONSTRAINT [IX_ForumsReadByDate] UNIQUE NONCLUSTERED  ([SectionID], [UserID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SectionsRead] ADD CONSTRAINT [PK_cs_SectionsRead] PRIMARY KEY CLUSTERED  ([UserID], [SectionID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_UsersOnline] ADD CONSTRAINT [IX_cs_UsersOnline] UNIQUE NONCLUSTERED  ([UserID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_PostEditNotes] ADD CONSTRAINT [IX_cs_PostEditNotes] UNIQUE CLUSTERED  ([PostID] DESC)
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_PostEditNotes] ADD CONSTRAINT [PK_cs_PostEditNotes] PRIMARY KEY NONCLUSTERED  ([PostID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Referrals] ADD CONSTRAINT [PK_cs_Referrals] PRIMARY KEY CLUSTERED  ([SettingsID], [SectionID], [PostID], [UrlID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Post_Categories] ADD CONSTRAINT [PK_forums_Categories] PRIMARY KEY CLUSTERED  ([CategoryID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Post_Categories] ADD CONSTRAINT [IX_forums_Post_CategoryName_Type] UNIQUE NONCLUSTERED  ([CategoryType], [Name], [SectionID], [SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_ApplicationType] ADD CONSTRAINT [PK_cs_ApplicationType] PRIMARY KEY CLUSTERED  ([ApplicationType])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Reports] ADD CONSTRAINT [PK_REPORTS] PRIMARY KEY CLUSTERED  ([ReportID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_weblog_Posts] ADD CONSTRAINT [PK_blog_Posts] PRIMARY KEY CLUSTERED  ([PostID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Services] ADD CONSTRAINT [PK_SERVICE_ID] PRIMARY KEY CLUSTERED  ([ServiceID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Services] ADD CONSTRAINT [UK_SERVICE_NAME] UNIQUE NONCLUSTERED  ([ServiceName])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_UserProfile] ADD CONSTRAINT [PK_cs_UserProfile] PRIMARY KEY CLUSTERED  ([UserID], [SettingsID])
GO
 CREATE  INDEX [IX_cs_UserProfile_MembershipID] ON [dbo].[cs_UserProfile]([MembershipID]) ON [PRIMARY]
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_TrackedSections] ADD CONSTRAINT [IX_cs_TrackedSections] UNIQUE CLUSTERED  ([SectionID], [UserID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Ranks] ADD CONSTRAINT [PK_RANK_ID] PRIMARY KEY CLUSTERED  ([RankID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Ranks] ADD CONSTRAINT [UK_RANK_NAME] UNIQUE NONCLUSTERED  ([RankName])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_ServiceSchedule] ADD CONSTRAINT [PK_SERVICE_SCHEDULE] PRIMARY KEY CLUSTERED  ([ServiceID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_ModerationAction] ADD CONSTRAINT [IX_cs_ModerationAction] UNIQUE CLUSTERED  ([ModerationAction], [SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_ModerationAction] ADD CONSTRAINT [PK_cs_ModerationAction] PRIMARY KEY NONCLUSTERED  ([ModerationAction], [SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_BlockedIpAddresses] ADD CONSTRAINT [PK_cs_BlockedIpAddresses] PRIMARY KEY CLUSTERED  ([IpID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_ProductPermissions] ADD CONSTRAINT [PK_cs_ProductPermissions] PRIMARY KEY CLUSTERED  ([SettingsID], [ApplicationType], [RoleID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Styles] ADD CONSTRAINT [PK_STYLE] PRIMARY KEY CLUSTERED  ([StyleID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Groups] ADD CONSTRAINT [IX_cs_Groups_Validation] UNIQUE NONCLUSTERED  ([SettingsID], [Name], [ApplicationType])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Groups] ADD CONSTRAINT [PK_Group] PRIMARY KEY CLUSTERED  ([SettingsID], [GroupID], [ApplicationType])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Censorship] ADD CONSTRAINT [PK_CENSORSHIP] PRIMARY KEY CLUSTERED  ([WordID], [SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Censorship] ADD CONSTRAINT [UK_CENSORSHIP] UNIQUE NONCLUSTERED  ([SettingsID], [Word])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Sites] ADD CONSTRAINT [PK_cs_Sites] PRIMARY KEY CLUSTERED  ([SiteID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_CodeScheduleType] ADD CONSTRAINT [PK_CODE_SCHEDULE_TYPE] PRIMARY KEY CLUSTERED  ([ScheduleTypeCode])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SiteSettings] ADD CONSTRAINT [PK_cs_SiteSettings] PRIMARY KEY CLUSTERED  ([SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_DisallowedNames] ADD CONSTRAINT [PK_DISALLOWED_NAME] PRIMARY KEY CLUSTERED  ([DisallowedName], [SettingsID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Smilies] ADD CONSTRAINT [PK_SMILIES_ID] PRIMARY KEY CLUSTERED  ([SmileyID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Smilies] ADD CONSTRAINT [IX_cs_Smilies] UNIQUE  NONCLUSTERED ( [SmileyCode],[SettingsID] )  ON [PRIMARY]
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Sections] ADD CONSTRAINT [PK_cs_Sections] PRIMARY KEY CLUSTERED  ([SettingsID], [SectionID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_Sections] ADD CONSTRAINT [IX_cs_Sections_Validation] UNIQUE NONCLUSTERED  ([SettingsID], [ApplicationKey], [ApplicationType])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
ALTER TABLE [dbo].[cs_SearchBarrel] WITH NOCHECK ADD
CONSTRAINT [FK_cs_SearchBarrel_cs_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[cs_Posts] ([PostID]) ON DELETE CASCADE NOT FOR REPLICATION,
CONSTRAINT [FK_cs_SearchBarrel_cs_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[cs_Threads] ([ThreadID]) ON DELETE CASCADE NOT FOR REPLICATION
ALTER TABLE [dbo].[cs_ThreadsRead] WITH NOCHECK ADD
CONSTRAINT [FK_cs_ThreadsRead_cs_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[cs_Threads] ([ThreadID]) ON DELETE CASCADE NOT FOR REPLICATION
ALTER TABLE [dbo].[cs_TrackedThreads] WITH NOCHECK ADD
CONSTRAINT [FK_cs_TrackedThreads_cs_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[cs_Threads] ([ThreadID]) ON DELETE CASCADE NOT FOR REPLICATION
ALTER TABLE [dbo].[cs_PostRating] ADD
CONSTRAINT [FK_cs_PostRating_cs_UserProfile] FOREIGN KEY ([UserID], [SettingsID]) REFERENCES [dbo].[cs_UserProfile] ([UserID], [SettingsID]) ON DELETE CASCADE,
CONSTRAINT [FK_cs_PostRating_cs_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[cs_Threads] ([ThreadID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_SectionPermissions] ADD
CONSTRAINT [FK_cs_SectionPermissions_SectionID] FOREIGN KEY ([SettingsID], [SectionID]) REFERENCES [dbo].[cs_Sections] ([SettingsID], [SectionID]),
CONSTRAINT [FK_cs_SectionPermissions_RoleID] FOREIGN KEY ([RoleID]) REFERENCES [dbo].[aspnet_Roles] ([RoleId])
ALTER TABLE [dbo].[cs_ProductPermissions] ADD
CONSTRAINT [FK_cs_ProductPermissions_ApplicationType] FOREIGN KEY ([ApplicationType]) REFERENCES [dbo].[cs_ApplicationType] ([ApplicationType]),
CONSTRAINT [FK_cs_ProductPermission_SettingsID] FOREIGN KEY ([SettingsID]) REFERENCES [dbo].[cs_SiteSettings] ([SettingsID]),
CONSTRAINT [FK_cs_ProductPermissions_RoleID] FOREIGN KEY ([RoleID]) REFERENCES [dbo].[aspnet_Roles] ([RoleId])
ALTER TABLE [dbo].[cs_Services] ADD
CONSTRAINT [FK_SERVICE_TYPE_CODE] FOREIGN KEY ([ServiceTypeCode]) REFERENCES [dbo].[cs_CodeServiceType] ([ServiceTypeCode])
ALTER TABLE [dbo].[cs_Referrals] ADD
CONSTRAINT [FK_cs_Referrals_cs_Urls] FOREIGN KEY ([UrlID]) REFERENCES [dbo].[cs_Urls] ([UrlID])
ALTER TABLE [dbo].[cs_weblog_Posts] ADD
CONSTRAINT [FK_blog_Posts_cs_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[cs_Posts] ([PostID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_UserAvatar] ADD
CONSTRAINT [FK_cs_UserAvatar_cs_Images] FOREIGN KEY ([ImageID]) REFERENCES [dbo].[cs_Images] ([ImageID]) ON DELETE CASCADE,
CONSTRAINT [FK_cs_UserAvatar_cs_UserProfile] FOREIGN KEY ([UserID], [SettingsID]) REFERENCES [dbo].[cs_UserProfile] ([UserID], [SettingsID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_nntp_Posts] ADD
CONSTRAINT [FK_cs_nntp_Posts_cs_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[cs_Posts] ([PostID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_PostEditNotes] ADD
CONSTRAINT [FK_cs_PostEditNotes_cs_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[cs_Posts] ([PostID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_PostMetadata] ADD
CONSTRAINT [FK_cs_PostMetadata_cs_Posts] FOREIGN KEY ([PostID]) REFERENCES [dbo].[cs_Posts] ([PostID]) ON DELETE CASCADE
ALTER TABLE [dbo].[cs_ServiceSchedule] ADD
CONSTRAINT [FK_SCHEDULE_TYPE_CD] FOREIGN KEY ([ScheduleTypeCode]) REFERENCES [dbo].[cs_CodeScheduleType] ([ScheduleTypeCode]),
CONSTRAINT [FK_SERVICE_ID] FOREIGN KEY ([ServiceID]) REFERENCES [dbo].[cs_Services] ([ServiceID])
ALTER TABLE [dbo].[cs_Links] ADD
CONSTRAINT [FK_cs_Links_cs_LinkCategories] FOREIGN KEY ([LinkCategoryID]) REFERENCES [dbo].[cs_LinkCategories] ([LinkCategoryID])
ALTER TABLE [dbo].[cs_Posts] ADD
CONSTRAINT [FK_cs_Posts_cs_Threads] FOREIGN KEY ([ThreadID]) REFERENCES [dbo].[cs_Threads] ([ThreadID])
ALTER TABLE [dbo].[cs_ModerationAudit] ADD
CONSTRAINT [ID] PRIMARY KEY CLUSTERED ([ID])
ALTER TABLE cs_UserProfile ADD Constraint [FK_cs_Users] FOREIGN KEY  ([UserID]) REFERENCES [cs_Users] ([UserID])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
CREATE CLUSTERED INDEX [IX_cs_ForumPingback] ON [dbo].[cs_ForumPingback] ([SectionID])
CREATE CLUSTERED INDEX [IX_cs_PrivateMessages] ON [dbo].[cs_PrivateMessages] ([UserID])
CREATE CLUSTERED INDEX [IX_PostsRead] ON [dbo].[cs_ThreadsRead] ([UserID])
CREATE CLUSTERED INDEX [IX_cs_UserAvatar_1] ON [dbo].[cs_UserAvatar] ([UserID])
CREATE CLUSTERED INDEX [IX_cs_Votes] ON [dbo].[cs_Votes] ([PostID])
CREATE CLUSTERED INDEX [IX_cs_VoteSummary] ON [dbo].[cs_VoteSummary] ([PostID])
CREATE NONCLUSTERED INDEX [IX_AnonymousUsers] ON [dbo].[cs_AnonymousUsers] ([LastLogin])
CREATE NONCLUSTERED INDEX [IX_cs_EmailQueue] ON [dbo].[cs_EmailQueue] ([EmailID])
CREATE NONCLUSTERED INDEX [IX_cs_ModerationAudit] ON [dbo].[cs_ModerationAudit] ([ModerationAction])
CREATE NONCLUSTERED INDEX [IX_cs_ModerationAudit_ModeratedOn] ON [dbo].[cs_ModerationAudit]([ModeratedOn])
CREATE NONCLUSTERED INDEX [IX_cs_PostAttachments] ON [dbo].[cs_PostAttachments] ([PostID])
CREATE NONCLUSTERED INDEX [IX_Posts_ThreadID] ON [dbo].[cs_Posts] ([ThreadID])
CREATE NONCLUSTERED INDEX [IX_Posts_ParentID] ON [dbo].[cs_Posts] ([ParentID])
CREATE NONCLUSTERED INDEX [IX_Posts_PostDate] ON [dbo].[cs_Posts] ([UserID], [PostDate])
CREATE NONCLUSTERED INDEX [IX_Posts_SectionID] ON [dbo].[cs_Posts] ([SectionID])
CREATE NONCLUSTERED INDEX [SectionID_Approved] ON [dbo].[cs_Posts] ([SectionID], [IsApproved])
CREATE NONCLUSTERED INDEX [IX_Posts_PostLevel] ON [dbo].[cs_Posts] ([PostLevel])
CREATE NONCLUSTERED INDEX [IX_Posts_SortOrder] ON [dbo].[cs_Posts] ([SortOrder])
CREATE NONCLUSTERED INDEX [IX_cs_Posts_SectionID_SettingsID] ON [dbo].[cs_Posts] ([SectionID], [SettingsID])
CREATE NONCLUSTERED INDEX [IX_Posts_Approved] ON [dbo].[cs_Posts] ([IsApproved])
CREATE NONCLUSTERED INDEX [IX_cs_PrivateMessages_1] ON [dbo].[cs_PrivateMessages] ([ThreadID])
CREATE NONCLUSTERED INDEX [IX_forums_SearchWordDictionary] ON [dbo].[cs_SearchIgnoreWords] ([WordHash])
CREATE NONCLUSTERED INDEX [IX_Section_Active] ON [dbo].[cs_Sections] ([SettingsID], [IsActive])
CREATE NONCLUSTERED INDEX [IX_ForumsRead] ON [dbo].[cs_SectionsRead] ([SectionID])
CREATE NONCLUSTERED INDEX [IX_forums_MostActiveUsers] ON [dbo].[cs_statistics_User] ([TotalPosts] DESC)
CREATE NONCLUSTERED INDEX [IX_cs_Threads] ON [dbo].[cs_Threads] ([SectionID], [ThreadID] DESC)
CREATE NONCLUSTERED INDEX [IX_cs_Threads_1] ON [dbo].[cs_Threads] ([SectionID], [StickyDate] DESC)
CREATE NONCLUSTERED INDEX [IX_cs_Threads_StickyDate] ON [dbo].[cs_Threads] ([SectionID], [StickyDate], [IsApproved])
CREATE NONCLUSTERED INDEX [IX_cs_Threads_ThreadID_SectionID_UserID] ON [dbo].[cs_Threads] ([SettingsID], [SectionID], [StickyDate])
CREATE NONCLUSTERED INDEX [IX_PostsRead_1] ON [dbo].[cs_ThreadsRead] ([ThreadID])
CREATE NONCLUSTERED INDEX [IX_cs_UserAvatar] ON [dbo].[cs_UserAvatar] ([UserID])
CREATE NONCLUSTERED INDEX [IX_cs_UserProfile] ON [dbo].[cs_UserProfile] ([TotalPosts] DESC)
CREATE NONCLUSTERED INDEX [IX_cs_UsersOnline_1] ON [dbo].[cs_UsersOnline] ([LastActivity])
CREATE CLUSTERED INDEX [IX_cs_TrackedThreads_ThreadID_UserID] ON [dbo].[cs_TrackedThreads] ([ThreadID], [UserID])
CREATE  INDEX [IX_cs_Posts_Thread_Sort] ON [dbo].[cs_Posts]([ThreadID], [SortOrder]) ON [PRIMARY]
CREATE  INDEX [IX_cs_Posts_InCategories_PostID] ON [dbo].[cs_Posts_InCategories]([PostID]) ON [PRIMARY]
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER cs_Group_Delete ON cs_Groups 
FOR DELETE 
AS
BEGIN
	DELETE cs_Sections WHERE GroupID IN (SELECT GroupID FROM DELETED)
END
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error