cs_schema.sql

本系统是在asp版《在线文件管理器》的基础上设计制作

 CREATE  CLUSTERED  INDEX [IX_cs_VoteSummary] ON [dbo].[cs_VoteSummary]([PostID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_cs_Votes] ON [dbo].[cs_Votes]([PostID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_AnonymousUsers] ADD 
	CONSTRAINT [DF_AnonymousUsers_LastLogin] DEFAULT (getdate()) FOR [LastLogin],
	CONSTRAINT [DF_cs_AnonymousUsers_LastAction] DEFAULT ('') FOR [LastAction],
	CONSTRAINT [DF_cs_AnonymousUsers_IPAddress] DEFAULT (N'000.000.000.000') FOR [IPAddress]
GO

 CREATE  INDEX [IX_AnonymousUsers] ON [dbo].[cs_AnonymousUsers]([LastLogin]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Censorship] ADD 
	CONSTRAINT [UK_CENSORSHIP] UNIQUE  NONCLUSTERED 
	(
		[SettingsID],
		[Word]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_EmailQueue] ADD 
	CONSTRAINT [DF_cs_EmailQueue_EmailID] DEFAULT (newid()) FOR [EmailID],
	CONSTRAINT [DF_cs_EmailQueue_createdTimestamp] DEFAULT ('1979-1-1 12:00:00') FOR [NextTryTime],
	CONSTRAINT [DF_cs_EmailQueue_NumberOfTries] DEFAULT (0) FOR [NumberOfTries]
GO

 CREATE  INDEX [IX_cs_EmailQueue] ON [dbo].[cs_EmailQueue]([EmailID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Exceptions] ADD 
	CONSTRAINT [DF_cs_Exceptions_DateCreated] DEFAULT (getdate()) FOR [DateCreated],
	CONSTRAINT [DF_cs_Exceptions_Frequency] DEFAULT (0) FOR [Frequency],
	CONSTRAINT [IX_cs_Exceptions] UNIQUE  NONCLUSTERED 
	(
		[ExceptionID]
	)  ON [PRIMARY] ,
	CONSTRAINT [IX_cs_Exceptions_1] UNIQUE  NONCLUSTERED 
	(
		[ExceptionHash]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ForumPingback] ADD 
	CONSTRAINT [DF_cs_ForumPingback_Count] DEFAULT (0) FOR [Count],
	CONSTRAINT [DF_cs_ForumPingback_LastUpdated] DEFAULT (getdate()) FOR [LastUpdated]
GO

ALTER TABLE [dbo].[cs_Groups] ADD 
	CONSTRAINT [DF_cs_Groups_SettingsID] DEFAULT (0) FOR [SettingsID],
	CONSTRAINT [DF_cs_Groups_NewsgroupFriendlyName] DEFAULT ('') FOR [NewsgroupName],
	CONSTRAINT [DF__ForumGrou__SortO__25518C17] DEFAULT (0) FOR [SortOrder],
	CONSTRAINT [DF_cs_Groups_ApplicationType] DEFAULT (0) FOR [ApplicationType],
	CONSTRAINT [IX_cs_Groups_Validation] UNIQUE  NONCLUSTERED 
	(
		[SettingsID],
		[Name],
		[ApplicationType]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Images] ADD 
	CONSTRAINT [DF_cs_Images_DateLastUpdated] DEFAULT (getdate()) FOR [DateLastUpdated]
GO

ALTER TABLE [dbo].[cs_LinkCategories] ADD 
	CONSTRAINT [DF_cs_LinkCategories_SortOrder] DEFAULT (0) FOR [SortOrder]
GO

ALTER TABLE [dbo].[cs_Links] ADD 
	CONSTRAINT [DF_cs_Links_SortOrder] DEFAULT (0) FOR [SortOrder]
GO

ALTER TABLE [dbo].[cs_Messages] ADD 
	CONSTRAINT [DF_cs_Messages_Language] DEFAULT ('en-US') FOR [Language]
GO

ALTER TABLE [dbo].[cs_ModerationAction] ADD 
	CONSTRAINT [DF_cs_ModerationAction_TotalActions] DEFAULT (0) FOR [TotalActions],
	CONSTRAINT [PK_cs_ModerationAction] PRIMARY KEY  NONCLUSTERED 
	(
		[ModerationAction],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ModerationAudit] ADD 
	CONSTRAINT [DF_cs_ModerationAudit_ModeratedOn] DEFAULT (getdate()) FOR [ModeratedOn]
GO

 CREATE  INDEX [IX_cs_ModerationAudit] ON [dbo].[cs_ModerationAudit]([ModerationAction]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_ModerationAudit_ModeratedOn] ON [dbo].[cs_ModerationAudit]([ModeratedOn]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Moderators] ADD 
	CONSTRAINT [DF_cs_Moderators_DateCreated] DEFAULT (getdate()) FOR [DateCreated],
	CONSTRAINT [DF_cs_Moderators_EmailNotification] DEFAULT (0) FOR [EmailNotification],
	CONSTRAINT [DF_cs_Moderators_PostsModerated] DEFAULT (0) FOR [PostsModerated]
GO

ALTER TABLE [dbo].[cs_PostAttachments] ADD 
	CONSTRAINT [DF_cs_PostAttachments_AttachmentID] DEFAULT (newid()) FOR [AttachmentID],
	CONSTRAINT [DF_cs_PostAttachments_UserID] DEFAULT (0) FOR [UserID],
	CONSTRAINT [DF_cs_PostAttachments_Created] DEFAULT (getdate()) FOR [Created],
	CONSTRAINT [DF_cs_PostAttachments_DownloadCount] DEFAULT (0) FOR [DownloadCount]
GO

 CREATE  INDEX [IX_cs_PostAttachments] ON [dbo].[cs_PostAttachments]([PostID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_PostEditNotes] ADD 
	CONSTRAINT [PK_cs_PostEditNotes] PRIMARY KEY  NONCLUSTERED 
	(
		[PostID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_PostRating] ADD 
	CONSTRAINT [IX_cs_PostRating] UNIQUE  NONCLUSTERED 
	(
		[UserID],
		[ThreadID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Post_Categories] ADD 
	CONSTRAINT [DF_forums_Categories_ParentID] DEFAULT (0) FOR [ParentID],
	CONSTRAINT [DF_cs_Post_Categories_Path] DEFAULT ('/') FOR [Path],
	CONSTRAINT [DF_cs_Post_Categories_TotalThreads] DEFAULT (0) FOR [TotalThreads],
	CONSTRAINT [DF_cs_Post_Categories_TotalSubThreads] DEFAULT (0) FOR [TotalSubThreads],
	CONSTRAINT [DF_cs_Post_Categories_DateCreated] DEFAULT (getdate()) FOR [DateCreated],
	CONSTRAINT [IX_forums_Post_CategoryName_Type] UNIQUE  NONCLUSTERED 
	(
		[CategoryType],
		[Name],
		[SectionID],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Posts] ADD 
	CONSTRAINT [DF_cs_Posts_Username] DEFAULT ('') FOR [PostAuthor],
	CONSTRAINT [DF_Posts_SectionID] DEFAULT (1) FOR [SectionID],
	CONSTRAINT [DF_Posts_PostDate] DEFAULT (getdate()) FOR [PostDate],
	CONSTRAINT [DF_Posts_Approved] DEFAULT (1) FOR [IsApproved],
	CONSTRAINT [DF_cs_Posts_IsLocked] DEFAULT (0) FOR [IsLocked],
	CONSTRAINT [DF_cs_Posts_IsIndexed] DEFAULT (0) FOR [IsIndexed],
	CONSTRAINT [DF_Posts_Views] DEFAULT (0) FOR [TotalViews],
	CONSTRAINT [DF__Posts__Body2__0B27A5C0] DEFAULT ('') FOR [Body],
	CONSTRAINT [DF_cs_Posts_IPAddress] DEFAULT (N'000.000.000.000') FOR [IPAddress],
	CONSTRAINT [DF__posts__PostType__290D0E62] DEFAULT (0) FOR [PostType],
	CONSTRAINT [DF_cs_Posts_EmoticonID] DEFAULT (0) FOR [EmoticonID],
	CONSTRAINT [DF__forums_Po__AggVi__78D3EB5B] DEFAULT (0) FOR [AggViews],
	CONSTRAINT [DF__cs_Posts__PostCo__3F115E1A] DEFAULT (0) FOR [PostConfiguration]
GO

 CREATE  INDEX [IX_Posts_ThreadID] ON [dbo].[cs_Posts]([ThreadID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_ParentID] ON [dbo].[cs_Posts]([ParentID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_PostDate] ON [dbo].[cs_Posts]([UserID], [PostDate]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_SectionID] ON [dbo].[cs_Posts]([SectionID]) ON [PRIMARY]
GO

 CREATE  INDEX [SectionID_Approved] ON [dbo].[cs_Posts]([SectionID], [IsApproved]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_PostLevel] ON [dbo].[cs_Posts]([PostLevel]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_SortOrder] ON [dbo].[cs_Posts]([SortOrder]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Posts_SectionID_SettingsID] ON [dbo].[cs_Posts]([SectionID], [SettingsID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Posts_Approved] ON [dbo].[cs_Posts]([IsApproved]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Posts_Thread_Sort] ON [dbo].[cs_Posts]([ThreadID], [SortOrder]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Posts_InCategories_PostID] ON [dbo].[cs_Posts_InCategories]([PostID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_PrivateMessages_1] ON [dbo].[cs_PrivateMessages]([ThreadID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Ranks] ADD 
	CONSTRAINT [UK_RANK_NAME] UNIQUE  NONCLUSTERED 
	(
		[RankName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SearchBarrel] ADD 
	CONSTRAINT [DF_cs_SearchBarrel_word] DEFAULT ('') FOR [Word],
	CONSTRAINT [DF_cs_SearchBarrel_threadId_1] DEFAULT (0) FOR [ThreadID],
	CONSTRAINT [DF_cs_SearchBarrel_SectionID] DEFAULT (0) FOR [SectionID],
	CONSTRAINT [DF_cs_SearchBarrel_weight] DEFAULT (0) FOR [Weight],
	CONSTRAINT [IX_cs_SearchBarrel] UNIQUE  NONCLUSTERED 
	(
		[WordHash],
		[PostID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [Wordhash_PostID_Weight_IDX] ON [dbo].[cs_SearchBarrel]([WordHash], [PostID], [Weight]) ON [PRIMARY]
GO

 CREATE  INDEX [SectionID_IDX] ON [dbo].[cs_SearchBarrel]([SectionID]) ON [PRIMARY]
GO

 CREATE  INDEX [ThreadID_SettingsID_IDX] ON [dbo].[cs_SearchBarrel]([ThreadID], [SettingsID]) ON [PRIMARY]
GO

 CREATE  INDEX [PostID_SettingsID_IDX] ON [dbo].[cs_SearchBarrel]([PostID], [SettingsID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_forums_SearchWordDictionary] ON [dbo].[cs_SearchIgnoreWords]([WordHash]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Sections] ADD 
	CONSTRAINT [DF_cs_Sections_SettingsID] DEFAULT (0) FOR [SettingsID],
	CONSTRAINT [DF_Forums_Active] DEFAULT (1) FOR [IsActive],
	CONSTRAINT [DF__Forums__ParentID__01342732] DEFAULT (0) FOR [ParentID],
	CONSTRAINT [DF_cs_Sections_NewsgroupName] DEFAULT ('') FOR [NewsgroupName],
	CONSTRAINT [DF_Forums_DateCreated] DEFAULT (getdate()) FOR [DateCreated],
	CONSTRAINT [DF_cs_Sections_Url] DEFAULT ('') FOR [Url],
	CONSTRAINT [DF_Forums_Moderated] DEFAULT (0) FOR [IsModerated],
	CONSTRAINT [DF_Forums_DaysToView] DEFAULT (7) FOR [DaysToView],
	CONSTRAINT [DF_Forums_SortOrder] DEFAULT (0) FOR [SortOrder],
	CONSTRAINT [DF_Forums_TotalPosts] DEFAULT (0) FOR [TotalPosts],
	CONSTRAINT [DF_Forums_TotalThreads] DEFAULT (0) FOR [TotalThreads],
	CONSTRAINT [DF__forums__DisplayM__004002F9] DEFAULT (0) FOR [DisplayMask],
	CONSTRAINT [DF_cs_Sections_EnablePostStatistics] DEFAULT (1) FOR [EnablePostStatistics],
	CONSTRAINT [DF_cs_Sections_EnableAutoDelete] DEFAULT (0) FOR [EnableAutoDelete],
	CONSTRAINT [DF_cs_Sections_EnableAnonymousPosting] DEFAULT (0) FOR [EnableAnonymousPosting],
	CONSTRAINT [DF_cs_Sections_AutoDeleteThreshold] DEFAULT (90) FOR [AutoDeleteThreshold],
	CONSTRAINT [DF_Forums_MostRecentPostID] DEFAULT (0) FOR [MostRecentPostID],
	CONSTRAINT [DF_cs_Sections_MostRecentThreadID] DEFAULT (0) FOR [MostRecentThreadID],
	CONSTRAINT [DF_cs_Sections_MostRecentThreadReplies] DEFAULT (0) FOR [MostRecentThreadReplies],
	CONSTRAINT [DF_cs_Sections_MostRecentPostSubject] DEFAULT ('') FOR [MostRecentPostSubject],
	CONSTRAINT [DF_cs_Sections_MostRecentPostAuthor] DEFAULT ('') FOR [MostRecentPostAuthor],
	CONSTRAINT [DF_cs_Sections_MostRecentPostAuthorID] DEFAULT (0) FOR [MostRecentPostAuthorID],
	CONSTRAINT [DF_cs_Sections_MostRecentPostDate] DEFAULT ('1797-1-1') FOR [MostRecentPostDate],
	CONSTRAINT [DF_forums_cs_PostsToModerate] DEFAULT (0) FOR [PostsToModerate],
	CONSTRAINT [DF_cs_Sections_ForumType] DEFAULT (0) FOR [ForumType],
	CONSTRAINT [DF_cs_Sections_IsSearchable] DEFAULT (1) FOR [IsSearchable],
	CONSTRAINT [DF_cs_Sections_ApplicationType] DEFAULT (0) FOR [ApplicationType],
	CONSTRAINT [DF__forums_For__Path__75F77EB0] DEFAULT ('') FOR [Path],
	CONSTRAINT [IX_cs_Sections_Validation] UNIQUE  NONCLUSTERED 
	(
		[SettingsID],
		[ApplicationKey],
		[ApplicationType]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_Section_Active] ON [dbo].[cs_Sections]([SettingsID], [IsActive]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_SectionsRead] ADD 
	CONSTRAINT [DF_cs_SectionsRead_GroupID] DEFAULT (0) FOR [GroupID],
	CONSTRAINT [DF_ForumsReadByDate_MarkReadAfter] DEFAULT (0) FOR [MarkReadAfter],
	CONSTRAINT [DF_cs_SectionsRead_NewPosts] DEFAULT (1) FOR [NewPosts],
	CONSTRAINT [DF_ForumsRead_LastActivity] DEFAULT (getdate()) FOR [LastActivity],
	CONSTRAINT [IX_ForumsReadByDate] UNIQUE  NONCLUSTERED 
	(
		[SectionID],
		[UserID]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_ForumsRead] ON [dbo].[cs_SectionsRead]([SectionID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_Services] ADD 
	CONSTRAINT [UK_SERVICE_NAME] UNIQUE  NONCLUSTERED 
	(
		[ServiceName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SiteSettings] ADD 
	CONSTRAINT [DF_cs_SiteSettings_Enabled] DEFAULT (0) FOR [Disabled]
GO

ALTER TABLE [dbo].[cs_Smilies] ADD 
	CONSTRAINT [DF_cs_forums_BracketSafe] DEFAULT (0) FOR [BracketSafe],
	CONSTRAINT [IX_cs_Smilies] UNIQUE  NONCLUSTERED 
	(
		[SmileyCode],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Threads] ADD 
	CONSTRAINT [DF_cs_Threads_PostAuthor] DEFAULT ('') FOR [PostAuthor],
	CONSTRAINT [DF_cs_Threads_LastViewedDate] DEFAULT (getdate()) FOR [LastViewedDate],
	CONSTRAINT [DF_cs_Threads_TotalViews] DEFAULT (0) FOR [TotalViews],
	CONSTRAINT [DF_cs_Threads_TotalReplies] DEFAULT (0) FOR [TotalReplies],
	CONSTRAINT [DF_cs_Threads_MostRecentPostAuthor] DEFAULT ('') FOR [MostRecentPostAuthor],
	CONSTRAINT [DF_cs_Threads_IsApproved] DEFAULT (1) FOR [IsApproved],
	CONSTRAINT [DF_cs_Threads_RatingSum] DEFAULT (0) FOR [RatingSum],
	CONSTRAINT [DF_cs_Threads_TotalRating] DEFAULT (0) FOR [TotalRatings],
	CONSTRAINT [DF_cs_Threads_ThreadEmoticon] DEFAULT (0) FOR [ThreadEmoticonID],
	CONSTRAINT [DF_cs_Threads_ThreadStatus] DEFAULT (0) FOR [ThreadStatus]
GO

 CREATE  INDEX [IX_cs_Threads] ON [dbo].[cs_Threads]([SectionID], [ThreadID] DESC ) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Threads_1] ON [dbo].[cs_Threads]([SectionID], [StickyDate] DESC ) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Threads_StickyDate] ON [dbo].[cs_Threads]([SectionID], [StickyDate], [IsApproved]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_cs_Threads_ThreadID_SectionID_UserID] ON [dbo].[cs_Threads]([SettingsID], [SectionID], [StickyDate]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_ThreadsRead] ADD 
	CONSTRAINT [DF_cs_ThreadsRead_GroupID] DEFAULT (0) FOR [GroupID],
	CONSTRAINT [DF_cs_ThreadsRead_SectionID] DEFAULT (0) FOR [SectionID]
GO

 CREATE  INDEX [IX_PostsRead_1] ON [dbo].[cs_ThreadsRead]([ThreadID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_TrackedSections] ADD 
	CONSTRAINT [DF_cs_TrackedSections_SubscriptionType] DEFAULT (0) FOR [SubscriptionType],
	CONSTRAINT [DF_cs_TrackedSections_DateCreated] DEFAULT (getdate()) FOR [DateCreated]
GO

ALTER TABLE [dbo].[cs_TrackedThreads] ADD 
	CONSTRAINT [DF_ThreadTrackings_DateCreated] DEFAULT (getdate()) FOR [DateCreated]
GO

ALTER TABLE [dbo].[cs_UserAvatar] ADD 
	CONSTRAINT [DF_cs_UserAvatar_FileName] DEFAULT ('') FOR [FileName]
GO

 CREATE  INDEX [IX_cs_UserAvatar] ON [dbo].[cs_UserAvatar]([UserID]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_UserProfile] ADD 
	CONSTRAINT [DF_cs_UserProfile_TimeZone] DEFAULT ((-5)) FOR [TimeZone],
	CONSTRAINT [DF_cs_UserProfile_TotalPosts] DEFAULT (0) FOR [TotalPosts],
	CONSTRAINT [DF_cs_UserProfile_PostSortOrder] DEFAULT (0) FOR [PostSortOrder],
	CONSTRAINT [DF_cs_UserProfile_DatabaseQuota] DEFAULT (10240) FOR [DatabaseQuota],
	CONSTRAINT [DF_cs_UserProfile_DatabaseQuotaUsed] DEFAULT (0) FOR [DatabaseQuotaUsed],
	CONSTRAINT [DF_cs_UserProfile_Attributes] DEFAULT (0) FOR [PostRank],
	CONSTRAINT [DF_cs_UserProfile_IsAvatarApproved] DEFAULT (1) FOR [IsAvatarApproved],
	CONSTRAINT [DF_cs_UserProfile_IsTrusted] DEFAULT (0) FOR [ModerationLevel],
	CONSTRAINT [DF_cs_UserProfile_TrackYourPosts] DEFAULT (0) FOR [EnableThreadTracking],
	CONSTRAINT [DF_cs_UserProfile_ShowUnreadTopicsOnly] DEFAULT (0) FOR [EnableDisplayUnreadThreadsOnly],
	CONSTRAINT [DF_cs_UserProfile_EnableAvatar] DEFAULT (0) FOR [EnableAvatar],
	CONSTRAINT [DF_cs_UserProfile_EnableDisplayInMemberList] DEFAULT (1) FOR [EnableDisplayInMemberList