cs_schema.sql

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

GO

CREATE TABLE [dbo].[cs_weblog_Posts] (
	[PostID] [int] NOT NULL ,
	[PostName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Excerpt] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitleUrl] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostConfig] [int] NOT NULL ,
	[BlogPostType] [tinyint] NOT NULL ,
	[SettingsID] [int] NULL ,
	[BloggerTime] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_weblog_Weblogs] (
	[SectionID] [int] NOT NULL ,
	[MostRecentPostID] [int] NOT NULL ,
	[MostRecentPostDate] [datetime] NOT NULL ,
	[MostRecentPostName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentPostAuthorID] [int] NOT NULL ,
	[MostRecentPostAuthor] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentPostSubject] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentArticleID] [int] NOT NULL ,
	[MostRecentArticleDate] [datetime] NOT NULL ,
	[MostRecentArticleName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentArticleAuthorID] [int] NOT NULL ,
	[MostRecentArticleAuthor] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentArticleSubject] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostCount] [int] NOT NULL ,
	[ArticleCount] [int] NOT NULL ,
	[CommentCount] [int] NOT NULL ,
	[TrackbackCount] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[cs_ApplicationType] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_ApplicationType] PRIMARY KEY  CLUSTERED 
	(
		[ApplicationType]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_BlockedIpAddresses] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_BlockedIpAddresses] PRIMARY KEY  CLUSTERED 
	(
		[IpID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Censorship] WITH NOCHECK ADD 
	CONSTRAINT [PK_CENSORSHIP] PRIMARY KEY  CLUSTERED 
	(
		[WordID],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_CodeScheduleType] WITH NOCHECK ADD 
	CONSTRAINT [PK_CODE_SCHEDULE_TYPE] PRIMARY KEY  CLUSTERED 
	(
		[ScheduleTypeCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_CodeServiceType] WITH NOCHECK ADD 
	CONSTRAINT [PK_SERVICE_TYPE_CODE] PRIMARY KEY  CLUSTERED 
	(
		[ServiceTypeCode]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_DisallowedNames] WITH NOCHECK ADD 
	CONSTRAINT [PK_DISALLOWED_NAME] PRIMARY KEY  CLUSTERED 
	(
		[DisallowedName],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Groups] WITH NOCHECK ADD 
	CONSTRAINT [PK_Group] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[GroupID],
		[ApplicationType]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Images] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Images] PRIMARY KEY  CLUSTERED 
	(
		[ImageID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_LinkCategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_LinkCategories] PRIMARY KEY  CLUSTERED 
	(
		[LinkCategoryID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Links] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Links] PRIMARY KEY  CLUSTERED 
	(
		[LinkID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ModerationAction] WITH NOCHECK ADD 
	CONSTRAINT [IX_cs_ModerationAction] UNIQUE  CLUSTERED 
	(
		[ModerationAction],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ModerationAudit] WITH NOCHECK ADD 
	CONSTRAINT [ID] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Moderators] WITH NOCHECK ADD 
	CONSTRAINT [PK_Moderators] PRIMARY KEY  CLUSTERED 
	(
		[UserID],
		[SectionID],
		[GroupID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_PostAttachments] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_PostAttachments] PRIMARY KEY  CLUSTERED 
	(
		[AttachmentID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_PostEditNotes] WITH NOCHECK ADD 
	CONSTRAINT [IX_cs_PostEditNotes] UNIQUE  CLUSTERED 
	(
		[PostID] DESC 
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_PostMetadata] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_PostMetadata] PRIMARY KEY  CLUSTERED 
	(
		[PostID],
		[MetaKey]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Post_Categories] WITH NOCHECK ADD 
	CONSTRAINT [PK_forums_Categories] PRIMARY KEY  CLUSTERED 
	(
		[CategoryID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Posts] WITH NOCHECK ADD 
	CONSTRAINT [PK_Posts] PRIMARY KEY  CLUSTERED 
	(
		[PostID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Posts_InCategories] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_PostsInCategories] PRIMARY KEY  CLUSTERED 
	(
		[CategoryID],
		[PostID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ProductPermissions] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_ProductPermissions] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[ApplicationType],
		[RoleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Ranks] WITH NOCHECK ADD 
	CONSTRAINT [PK_RANK_ID] PRIMARY KEY  CLUSTERED 
	(
		[RankID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Referrals] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Referrals] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[SectionID],
		[PostID],
		[UrlID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Reports] WITH NOCHECK ADD 
	CONSTRAINT [PK_REPORTS] PRIMARY KEY  CLUSTERED 
	(
		[ReportID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SchemaVersion] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_SchemaVersion] PRIMARY KEY  CLUSTERED 
	(
		[Major],
		[Minor],
		[Patch]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SectionPermissions] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_SectionPermissions] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[SectionID],
		[RoleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Sections] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Sections] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[SectionID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SectionsRead] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_SectionsRead] PRIMARY KEY  CLUSTERED 
	(
		[UserID],
		[SectionID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_ServiceSchedule] WITH NOCHECK ADD 
	CONSTRAINT [PK_SERVICE_SCHEDULE] PRIMARY KEY  CLUSTERED 
	(
		[ServiceID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Services] WITH NOCHECK ADD 
	CONSTRAINT [PK_SERVICE_ID] PRIMARY KEY  CLUSTERED 
	(
		[ServiceID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SiteMappings] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_SiteMappings] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[SiteID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_SiteSettings] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_SiteSettings] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Sites] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Sites] PRIMARY KEY  CLUSTERED 
	(
		[SiteID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Smilies] WITH NOCHECK ADD 
	CONSTRAINT [PK_SMILIES_ID] PRIMARY KEY  CLUSTERED 
	(
		[SmileyID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Styles] WITH NOCHECK ADD 
	CONSTRAINT [PK_STYLE] PRIMARY KEY  CLUSTERED 
	(
		[StyleID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Threads] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Threads] PRIMARY KEY  CLUSTERED 
	(
		[ThreadID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_TrackedSections] WITH NOCHECK ADD 
	CONSTRAINT [IX_cs_TrackedSections] UNIQUE  CLUSTERED 
	(
		[SectionID],
		[UserID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Urls] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_Urls] PRIMARY KEY  CLUSTERED 
	(
		[UrlID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_UserProfile] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_UserProfile] PRIMARY KEY  CLUSTERED 
	(
		[UserID],
		[SettingsID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_Users] WITH NOCHECK ADD 
	CONSTRAINT [PK__cs_Users__6D0D32F4] PRIMARY KEY  CLUSTERED 
	(
		[UserID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_statistics_Site] WITH NOCHECK ADD 
	CONSTRAINT [PK_forums_Statistics] PRIMARY KEY  CLUSTERED 
	(
		[DateCreated] DESC 
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_weblog_Posts] WITH NOCHECK ADD 
	CONSTRAINT [PK_blog_Posts] PRIMARY KEY  CLUSTERED 
	(
		[PostID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[cs_weblog_Weblogs] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_weblog_Weblogs] PRIMARY KEY  CLUSTERED 
	(
		[SectionID]
	)  ON [PRIMARY] 
GO

 CREATE  CLUSTERED  INDEX [IX_cs_ForumPingback] ON [dbo].[cs_ForumPingback]([SectionID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_cs_PrivateMessages] ON [dbo].[cs_PrivateMessages]([UserID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [WordHash_SectionID_CLX_IDX] ON [dbo].[cs_SearchBarrel]([WordHash], [SectionID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_PostsRead] ON [dbo].[cs_ThreadsRead]([UserID]) ON [PRIMARY]
GO

 CREATE  CLUSTERED  INDEX [IX_cs_TrackedThreads_ThreadID_UserID] ON [dbo].[cs_TrackedThreads]([ThreadID], [UserID]) ON [PRIMARY]
GO

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