cs_schema.sql

community server 源码

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_statistics_User]
(
[UserID] [int] NOT NULL CONSTRAINT [DF_cs_statistics_User_UserID] DEFAULT (0),
[TotalPosts] [int] NOT NULL CONSTRAINT [DF_forums_MostActiveUsers_TotalPosts] DEFAULT (0),
[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_ThreadsRead]
(
[UserID] [int] NOT NULL,
[GroupID] [int] NOT NULL CONSTRAINT [DF_cs_ThreadsRead_GroupID] DEFAULT (0),
[SectionID] [int] NOT NULL CONSTRAINT [DF_cs_ThreadsRead_SectionID] DEFAULT (0),
[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_Posts]
(
[PostID] [int] NOT NULL IDENTITY(1, 1),
[ThreadID] [int] NOT NULL,
[ParentID] [int] NOT NULL,
[PostAuthor] [nvarchar] (64) NULL CONSTRAINT [DF_cs_Posts_Username] DEFAULT (''),
[UserID] [int] NOT NULL,
[SectionID] [int] NOT NULL CONSTRAINT [DF_Posts_SectionID] DEFAULT (1),
[PostLevel] [int] NOT NULL,
[SortOrder] [int] NOT NULL,
[Subject] [nvarchar] (256) NULL,
[PostDate] [datetime] NOT NULL CONSTRAINT [DF_Posts_PostDate] DEFAULT (getdate()),
[IsApproved] [bit] NOT NULL CONSTRAINT [DF_Posts_Approved] DEFAULT (1),
[IsLocked] [bit] NOT NULL CONSTRAINT [DF_cs_Posts_IsLocked] DEFAULT (0),
[IsIndexed] [bit] NOT NULL CONSTRAINT [DF_cs_Posts_IsIndexed] DEFAULT (0),
[TotalViews] [int] NOT NULL CONSTRAINT [DF_Posts_Views] DEFAULT (0),
[Body] [ntext] NULL CONSTRAINT [DF__Posts__Body2__0B27A5C0] DEFAULT (''),
[FormattedBody] [ntext] NULL,
[IPAddress] [nvarchar] (32) NULL CONSTRAINT [DF_cs_Posts_IPAddress] DEFAULT (N'000.000.000.000'),
[PostType] [int] NOT NULL CONSTRAINT [DF__posts__PostType__290D0E62] DEFAULT (0),
[EmoticonID] [int] NOT NULL CONSTRAINT [DF_cs_Posts_EmoticonID] DEFAULT (0),
[PropertyNames] [ntext] NULL,
[PropertyValues] [ntext] NULL,
[SettingsID] [int] NULL,
[AggViews] [int] NOT NULL CONSTRAINT [DF__forums_Po__AggVi__78D3EB5B] DEFAULT (0),
[PostConfiguration] [int] NOT NULL DEFAULT (0),
[PostName] NVARCHAR(256),
[UserTime] DATETIME CONSTRAINT cs_Post_UserTimeDefaultValue DEFAULT(GetDate()),
[ApplicationPostType] INT NOT NULL CONSTRAINT cs_Post_ApplicationTypeDefaultValue DEFAULT(1),
[Points] [int] NOT NULL CONSTRAINT [DF_cs_Posts_Points] DEFAULT (0),
[RatingSum] [int] NOT NULL CONSTRAINT [DF_cs_Posts_RatingSum] DEFAULT (0),
[TotalRatings] [int] NOT NULL CONSTRAINT [DF_cs_Posts_TotalRatings] DEFAULT (0),
[PointsUpdated] [datetime] NOT NULL CONSTRAINT [DF_cs_Posts_PointsUpdated] DEFAULT (getdate())
)

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_SearchBarrel]
(
[WordHash] [int] NOT NULL,
[Word] [nvarchar] (64) NULL CONSTRAINT [DF_cs_SearchBarrel_word] DEFAULT (''),
[PostID] [int] NOT NULL,
[ThreadID] [int] NOT NULL CONSTRAINT [DF_cs_SearchBarrel_threadId_1] DEFAULT (0),
[SectionID] [int] NOT NULL CONSTRAINT [DF_cs_SearchBarrel_SectionID] DEFAULT (0),
[Weight] [float] NOT NULL CONSTRAINT [DF_cs_SearchBarrel_weight] DEFAULT (0),
[SettingsID] [int] NULL
)

 CREATE  CLUSTERED  INDEX [WordHash_SectionID_CLX_IDX] ON [dbo].[cs_SearchBarrel]([WordHash], [SectionID]) 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

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_ProductPermissions]
(
[SettingsID] [int] NOT NULL,
[ApplicationType] [smallint] 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 OFF
GO


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

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_nntp_Posts]
(
[PostID] [int] NOT NULL CONSTRAINT [DF_cs_nntp_Posts_PostID] DEFAULT (0),
[SectionID] [int] NOT NULL CONSTRAINT [DF_cs_nntp_Posts_SectionID] DEFAULT (0),
[NntpPostID] [int] NOT NULL,
[NntpUniqueID] [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_ServiceSchedule]
(
[ServiceID] [int] NOT NULL,
[ScheduleName] [varchar] (30) NULL,
[MachineName] [varchar] (128) NULL,
[StartDate] [datetime] NOT NULL,
[EndDate] [datetime] NULL,
[ServiceParameters] [varchar] (256) NULL,
[ScheduleTypeCode] [int] NOT NULL,
[RunTimeHour] [int] NOT NULL,
[RunTimeMinute] [int] NOT NULL,
[DelayHour] [int] NULL,
[DelayMinute] [int] NULL,
[RunDaily] [binary] (8) NULL,
[RunWeekly] [binary] (8) NULL,
[RunMonthly] [binary] (12) NULL,
[RunYearly] [tinyint] NULL,
[RunOnce] [tinyint] NULL,
[LastRunTime] [datetime] NULL,
[NextRunTime] [datetime] 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_PostEditNotes]
(
[PostID] [int] NOT NULL,
[EditNotes] [nvarchar] (4000) 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_PostMetadata]
(
[PostID] [int] NOT NULL,
[MetaKey] [nvarchar] (50) NOT NULL,
[MetaType] [nvarchar] (50) NOT NULL,
[MetaValue] [nvarchar] (50) 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 function [dbo].[GetAnonymousUserID]
(
	@SettingsID int
)
RETURNS int
as
BEGIN
	Declare @UserID int
	Set @UserID = (Select cs_UserID FROM cs_vw_Users_FullUser where SettingsID = @SettingsID and IsAnonymous = 1)
	RETURN @UserID
END








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_Censorship]
(
[SettingsID] [int] NOT NULL,
[WordID] [int] NOT NULL IDENTITY(1, 1),
[Word] [nvarchar] (20) NULL,
[Replacement] [nvarchar] (20) 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_DisallowedNames]
(
[DisallowedName] [nvarchar] (64) 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_Groups]
(
[SettingsID] [int] NOT NULL CONSTRAINT [DF_cs_Groups_SettingsID] DEFAULT (0),
[GroupID] [int] NOT NULL IDENTITY(1, 1),
[Name] [nvarchar] (256) NULL,
[NewsgroupName] [nvarchar] (256) NULL CONSTRAINT [DF_cs_Groups_NewsgroupFriendlyName] DEFAULT (''),
[SortOrder] [int] NOT NULL CONSTRAINT [DF__ForumGrou__SortO__25518C17] DEFAULT (0),
[ApplicationType] [smallint] NOT NULL CONSTRAINT [DF_cs_Groups_ApplicationType] DEFAULT (0),
[Description] [nvarchar](1000) NOT NULL CONSTRAINT [DF_cs_Groups_Description] 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_nntp_Newsgroups]
(
[SectionID] [int] NOT NULL,
[NntpGroup] [nvarchar] (256) NULL,
[NntpServer] [nvarchar] (100) 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_Posts_InCategories]
(
[CategoryID] [int] NOT NULL,
[PostID] [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_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