cs_schema.sql

解压即可使用

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[cs_PostsArchive]
(
[PostID] [int] NOT NULL IDENTITY(1, 1),
[ThreadID] [int] NOT NULL,
[ParentID] [int] NOT NULL,
[PostLevel] [int] NOT NULL,
[SortOrder] [int] NOT NULL,
[Subject] [nvarchar] (256) NULL,
[PostDate] [datetime] NOT NULL,
[Approved] [bit] NOT NULL,
[SectionID] [int] NOT NULL,
[UserName] [nvarchar] (64) NULL,
[ThreadDate] [datetime] NOT NULL,
[TotalViews] [int] NOT NULL,
[IsLocked] [bit] NOT NULL,
[IsPinned] [bit] NOT NULL,
[PinnedDate] [datetime] NOT NULL,
[Body] [ntext] NULL,
[SettingsID] [int] NULL
)

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 TABLE [dbo].[cs_PrivateMessages]
(
[UserID] [int] NOT NULL,
[ThreadID] [int] NOT NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_Ranks]
(
[RankID] [int] NOT NULL IDENTITY(1, 1),
[RankName] [nvarchar] (30) NULL,
[PostingCountMin] [int] NULL,
[PostingCountMax] [int] NULL,
[RankIconUrl] [nvarchar] (256) NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_Reports]
(
[ReportID] [int] NOT NULL IDENTITY(1, 1),
[ReportName] [varchar] (20) NULL,
[Active] [bit] NOT NULL,
[ReportCommand] [varchar] (6500) NULL,
[ReportScript] [text] NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_SchemaVersion]
(
[Major] [int] NOT NULL,
[Minor] [int] NOT NULL,
[Patch] [int] NOT NULL,
[InstallDate] [datetime] NOT NULL
)
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 TABLE [dbo].[cs_SearchIgnoreWords]
(
[WordHash] [int] NOT NULL,
[Word] [nvarchar] (256) NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_SectionPermissions]
(
[SettingsID] [int] NOT NULL,
[SectionID] [int] NOT NULL,
[RoleID] [uniqueidentifier] NOT NULL,
[AllowMask] [binary] (8) NOT NULL,
[DenyMask] [binary] (8) NOT NULL
)
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 TABLE [dbo].[cs_Sections]
(
[SectionID] [int] NOT NULL IDENTITY(1, 1),
[SettingsID] [int] NOT NULL CONSTRAINT [DF_cs_Sections_SettingsID] DEFAULT (0),
[IsActive] [smallint] NOT NULL CONSTRAINT [DF_Forums_Active] DEFAULT (1),
[ParentID] [int] NOT NULL CONSTRAINT [DF__Forums__ParentID__01342732] DEFAULT (0),
[GroupID] [int] NOT NULL,
[Name] [nvarchar] (256) NULL,
[NewsgroupName] [nvarchar] (256) NULL CONSTRAINT [DF_cs_Sections_NewsgroupName] DEFAULT (''),
[Description] [nvarchar] (1000) NULL,
[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_Forums_DateCreated] DEFAULT (getdate()),
[Url] [nvarchar] (512) NULL CONSTRAINT [DF_cs_Sections_Url] DEFAULT (''),
[IsModerated] [smallint] NOT NULL CONSTRAINT [DF_Forums_Moderated] DEFAULT (0),
[DaysToView] [int] NOT NULL CONSTRAINT [DF_Forums_DaysToView] DEFAULT (7),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_Forums_SortOrder] DEFAULT (0),
[TotalPosts] [int] NOT NULL CONSTRAINT [DF_Forums_TotalPosts] DEFAULT (0),
[TotalThreads] [int] NOT NULL CONSTRAINT [DF_Forums_TotalThreads] DEFAULT (0),
[DisplayMask] [binary] (512) NOT NULL CONSTRAINT [DF__forums__DisplayM__004002F9] DEFAULT (0),
[EnablePostStatistics] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_EnablePostStatistics] DEFAULT (1),
[EnableAutoDelete] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_EnableAutoDelete] DEFAULT (0),
[EnableAnonymousPosting] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_EnableAnonymousPosting] DEFAULT (0),
[AutoDeleteThreshold] [int] NOT NULL CONSTRAINT [DF_cs_Sections_AutoDeleteThreshold] DEFAULT (90),
[MostRecentPostID] [int] NOT NULL CONSTRAINT [DF_Forums_MostRecentPostID] DEFAULT (0),
[MostRecentThreadID] [int] NOT NULL CONSTRAINT [DF_cs_Sections_MostRecentThreadID] DEFAULT (0),
[MostRecentThreadReplies] [int] NOT NULL CONSTRAINT [DF_cs_Sections_MostRecentThreadReplies] DEFAULT (0),
[MostRecentPostSubject] [nvarchar] (64) NULL CONSTRAINT [DF_cs_Sections_MostRecentPostSubject] DEFAULT (''),
[MostRecentPostAuthor] [nvarchar] (64) NULL CONSTRAINT [DF_cs_Sections_MostRecentPostAuthor] DEFAULT (''),
[MostRecentPostAuthorID] [int] NOT NULL CONSTRAINT [DF_cs_Sections_MostRecentPostAuthorID] DEFAULT (0),
[MostRecentPostDate] [datetime] NOT NULL CONSTRAINT [DF_cs_Sections_MostRecentPostDate] DEFAULT ('1/1/1797'),
[PostsToModerate] [int] NOT NULL CONSTRAINT [DF_forums_cs_PostsToModerate] DEFAULT (0),
[ForumType] [int] NOT NULL CONSTRAINT [DF_cs_Sections_ForumType] DEFAULT (0),
[IsSearchable] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_IsSearchable] DEFAULT (1),
[ApplicationType] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_ApplicationType] DEFAULT (0),
[ApplicationKey] [nvarchar] (256) NULL,
[PropertyNames] [ntext] NULL,
[PropertyValues] [ntext] NULL,
[Path] [varchar] (255) NOT NULL CONSTRAINT [DF__forums_For__Path__75F77EB0] DEFAULT ('')
)
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 TABLE [dbo].[cs_SiteMappings]
(
[SettingsID] [int] NOT NULL,
[SiteID] [int] NOT NULL
)
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 TABLE [dbo].[cs_Sites]
(
[SiteID] [int] NOT NULL IDENTITY(1000, 1),
[SiteUrl] [nvarchar] (512) NULL
)
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 TABLE [dbo].[cs_Styles]
(
[StyleID] [int] NOT NULL IDENTITY(1, 1),
[StyleName] [varchar] (30) NULL,
[StyleSheetTemplate] [varchar] (30) NULL,
[BodyBackgroundColor] [varchar] (6) NULL,
[BodyTextColor] [varchar] (6) NULL,
[LinkVisited] [varchar] (6) NULL,
[LinkHover] [varchar] (6) NULL,
[LinkActive] [varchar] (6) NULL,
[RowColorPrimary] [varchar] (6) NULL,
[RowColorSecondary] [varchar] (6) NULL,
[RowColorTertiary] [varchar] (6) NULL,
[RowClassPrimary] [varchar] (30) NULL,
[RowClassSecondary] [varchar] (30) NULL,
[RowClassTertiary] [varchar] (30) NULL,
[HeaderColorPrimary] [varchar] (6) NULL,
[HeaderColorSecondary] [varchar] (6) NULL,
[HeaderColorTertiary] [varchar] (6) NULL,
[HeaderStylePrimary] [varchar] (30) NULL,
[HeaderStyleSecondary] [varchar] (30) NULL,
[HeaderStyleTertiary] [varchar] (30) NULL,
[CellColorPrimary] [varchar] (6) NULL,
[CellColorSecondary] [varchar] (6) NULL,
[CellColorTertiary] [varchar] (6) NULL,
[CellClassPrimary] [varchar] (30) NULL,
[CellClassSecondary] [varchar] (30) NULL,
[CellClassTertiary] [varchar] (30) NULL,
[FontFacePrimary] [varchar] (30) NULL,
[FontFaceSecondary] [varchar] (30) NULL,
[FontFaceTertiary] [varchar] (30) NULL,
[FontSizePrimary] [smallint] NULL,
[FontSizeSecondary] [smallint] NULL,
[FontSizeTertiary] [smallint] NULL,
[FontColorPrimary] [varchar] (6) NULL,
[FontColorSecondary] [varchar] (6) NULL,
[FontColorTertiary] [varchar] (6) NULL,
[SpanClassPrimary] [varchar] (30) NULL,
[SpanClassSecondary] [varchar] (30) NULL,
[SpanClassTertiary] [varchar] (30) NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_Version]
(
[VERSION_MAJOR] [int] NOT NULL,
[VERSION_MINOR] [int] NOT NULL,
[VERSION_REVISION] [int] NOT NULL,
[VERSION_BUILD] [int] NOT NULL,
[SettingsID] [int] NULL
)
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 TABLE [dbo].[cs_Votes]
(
[PostID] [int] NOT NULL,
[UserID] [int] NOT NULL,
[Vote] [nvarchar] (2) NOT NULL,
[SettingsID] [int] NOT NULL
)
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 TABLE [dbo].[cs_VoteSummary]
(
[PostID] [int] NOT NULL,
[Vote] [nvarchar] (2) NULL,
[VoteCount] [int] NOT NULL,
[SettingsID] [int] NULL
)
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
SET ARITHABORT ON
GO
ALTER TABLE [dbo].[cs_SchemaVersion] ADD CONSTRAINT [PK_cs_SchemaVersion] PRIMARY KEY CLUSTERED  ([Major], [Minor], [Patch])
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_Images] ADD CONSTRAINT [PK_cs_Images] PRIMARY KEY CLUSTERED  ([ImageID])
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] ADD CONSTRAINT [PK_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_LinkCategories] ADD CONSTRAINT [PK_cs_LinkCategories] PRIMARY KEY CLUSTERED  ([LinkCategoryID])
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_Links] ADD CONSTRAINT [PK_cs_Links] PRIMARY KEY CLUSTERED  ([LinkID])
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_Exceptions] ADD CONSTRAINT [IX_cs_Exceptions] UNIQUE NONCLUSTERED  ([ExceptionID])
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_Exceptions] ADD CONSTRAINT [IX_cs_Exceptions_1] UNIQUE NONCLUSTERED  ([ExceptionHash])
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_statistics_Site] ADD CONSTRAINT [PK_forums_Statistics] PRIMARY KEY CLUSTERED  ([DateCreated] 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_SearchBarrel] ADD CONSTRAINT [IX_cs_SearchBarrel] UNIQUE NONCLUSTERED  ([WordHash], [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_weblog_Weblogs] ADD CONSTRAINT [PK_cs_weblog_Weblogs] PRIMARY KEY CLUSTERED  ([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