cs_schema.sql

community server 源码

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 (''),
[EnablePostPoints] [smallint] NOT NULL CONSTRAINT [DF_cs_Sections_EnablePostPoints] DEFAULT (1),
[DiskUsage] [bigint] NOT NULL CONSTRAINT [DF_cs_Sections_DiskUsage] DEFAULT (0)
)
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
CREATE TABLE [dbo].[cs_Post_Categories_Parents](
	[CategoryID] [int] NOT NULL,
	[UpLevelID] [int] NOT NULL,
	[SectionID] [int] NOT NULL,
CONSTRAINT [PK_cs_Post_Category_Parent] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC,
	[UpLevelID] ASC
) ON [PRIMARY]
) 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 TABLE [dbo].[cs_PostRating]
(
	[UserID] [int] NOT NULL,
	[PostID] [int] NOT NULL,
	[Rating] [int] NOT NULL,
	[SettingsID] [int] NULL,
	[DateCreated] [datetime] NOT NULL CONSTRAINT [DF_cs_PostRating_DateCreated] DEFAULT (getdate())
)  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 TABLE [dbo].[cs_FavoritePosts]
(
	[FavoriteID] [int] IDENTITY (1, 1) NOT NULL ,
	[OwnerID] [int] NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[PostID] [int] NOT NULL ,
	[ApplicationType] [smallint] NOT NULL CONSTRAINT [DF_cs_FavoritePosts_ApplicationType] DEFAULT (9999)
) 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 TABLE [dbo].[cs_FavoriteSections]
(
	[FavoriteID] [int] IDENTITY (1, 1) NOT NULL ,
	[OwnerID] [int] NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[ApplicationType] [smallint] NOT NULL CONSTRAINT [DF_cs_FavoriteSections_ApplicationType] DEFAULT (9999)
) 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 TABLE [dbo].[cs_FavoriteUsers]
(
	[FavoriteID] [int] IDENTITY (1, 1) NOT NULL ,
	[OwnerID] [int] NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[ApplicationType] [smallint] NOT NULL CONSTRAINT [DF_cs_FavoriteUsers_ApplicationType] DEFAULT (9999)
) 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 TABLE [dbo].[files_Downloads] (
            [UserID] [int] NOT NULL ,
            [PostID] [int] NOT NULL ,
            [DownloadDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO
CREATE  INDEX [IX_files_Downloads_UserID] ON [dbo].[files_Downloads]([UserID]) ON [PRIMARY]
GO
CREATE  INDEX [IX_files_Downloads_PostID] ON [dbo].[files_Downloads]([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 TABLE [dbo].[cs_UrlRedirects] (
            [urlID] [int] IDENTITY (1, 1) NOT NULL ,
            [url] [nvarchar] (4000) NOT NULL ,
            [impressions] [int] NOT NULL ,
            [description] [nvarchar] (2000) NULL
) 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 TABLE [dbo].[cs_BannedAddresses] (
	[SettingsID] [int] NOT NULL ,
	[NetworkAddress] [nvarchar] (50) NOT NULL ,
	[BannedDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[cs_BannedAddresses] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_BannedAddresses] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[NetworkAddress]
	)  ON [PRIMARY] 
GO
ALTER TABLE [dbo].[cs_BannedAddresses] WITH NOCHECK ADD 
	CONSTRAINT [UK_cs_BannedAddresses] UNIQUE  NONCLUSTERED 
	(
		[NetworkAddress]
	)  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 TABLE [dbo].[cs_BannedNetworks] (
	[SettingsID] [int] NOT NULL ,
	[BannedNetworkID] [int] IDENTITY (1, 1) NOT NULL ,
	[StartingAddress] [nvarchar] (50) NOT NULL ,
	[EndingAddress] [nvarchar] (50) NOT NULL ,
	[BannedDate] [datetime] NULL 
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[cs_BannedNetworks] WITH NOCHECK ADD 
	CONSTRAINT [PK_cs_BannedNetworks] PRIMARY KEY  CLUSTERED 
	(
		[SettingsID],
		[BannedNetworkID]
	)  ON [PRIMARY] 
GO
ALTER TABLE [dbo].[cs_BannedNetworks] WITH NOCHECK ADD 
	CONSTRAINT [UK_cs_BannedNetworks] UNIQUE  NONCLUSTERED