cs_schema.sql

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

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
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

CREATE TABLE [dbo].[cs_AnonymousUsers] (
	[UserID] [char] (36) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastLogin] [datetime] NOT NULL ,
	[LastAction] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[IPAddress] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ApplicationType] (
	[ApplicationType] [smallint] NOT NULL ,
	[ApplicationName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_BlockedIpAddresses] (
	[IpID] [int] IDENTITY (1, 1) NOT NULL ,
	[Address] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Reason] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Censorship] (
	[SettingsID] [int] NOT NULL ,
	[WordID] [int] IDENTITY (1, 1) NOT NULL ,
	[Word] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Replacement] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_CodeScheduleType] (
	[ScheduleTypeCode] [int] IDENTITY (1, 1) NOT NULL ,
	[ScheduleDescription] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_CodeServiceType] (
	[ServiceTypeCode] [int] IDENTITY (1, 1) NOT NULL ,
	[ServiceTypeDescription] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_DisallowedNames] (
	[DisallowedName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SettingsID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_EmailQueue] (
	[EmailID] [uniqueidentifier] NOT NULL ,
	[emailPriority] [int] NOT NULL ,
	[emailBodyFormat] [int] NOT NULL ,
	[emailTo] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[emailCc] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[emailBcc] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailFrom] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailSubject] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[EmailBody] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[NextTryTime] [datetime] NOT NULL ,
	[NumberOfTries] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Exceptions] (
	[ExceptionID] [int] IDENTITY (1, 1) NOT NULL ,
	[ExceptionHash] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NOT NULL ,
	[Category] [int] NOT NULL ,
	[Exception] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ExceptionMessage] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[IPAddress] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserAgent] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[HttpReferrer] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[HttpVerb] [nvarchar] (24) COLLATE Chinese_PRC_CI_AS NULL ,
	[PathAndQuery] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[DateCreated] [datetime] NOT NULL ,
	[DateLastOccurred] [datetime] NOT NULL ,
	[Frequency] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ForumPingback] (
	[SectionID] [int] NOT NULL ,
	[Pingback] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[Count] [int] NOT NULL ,
	[LastUpdated] [datetime] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Groups] (
	[SettingsID] [int] NOT NULL ,
	[GroupID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsgroupName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SortOrder] [int] NOT NULL ,
	[ApplicationType] [smallint] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Images] (
	[ImageID] [int] IDENTITY (1, 1) NOT NULL ,
	[Length] [int] NOT NULL ,
	[ContentType] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [image] NOT NULL ,
	[DateLastUpdated] [datetime] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_LinkCategories] (
	[LinkCategoryID] [int] IDENTITY (1, 1) NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[Name] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsEnabled] [bit] NOT NULL ,
	[SortOrder] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Links] (
	[LinkID] [int] IDENTITY (1, 1) NOT NULL ,
	[LinkCategoryID] [int] NOT NULL ,
	[Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsEnabled] [bit] NOT NULL ,
	[SortOrder] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Messages] (
	[MessageID] [int] NOT NULL ,
	[Language] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ModerationAction] (
	[ModerationAction] [int] NOT NULL ,
	[Description] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[TotalActions] [int] NOT NULL ,
	[SettingsID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ModerationAudit] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ModerationAction] [int] NOT NULL ,
	[PostID] [int] NULL ,
	[UserID] [int] NULL ,
	[SectionID] [int] NULL ,
	[ModeratorID] [int] NOT NULL ,
	[ModeratedOn] [datetime] NOT NULL ,
	[Notes] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Moderators] (
	[UserID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[GroupID] [int] NOT NULL ,
	[DateCreated] [datetime] NOT NULL ,
	[EmailNotification] [bit] NOT NULL ,
	[PostsModerated] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_PostAttachments] (
	[AttachmentID] [uniqueidentifier] NOT NULL ,
	[PostID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[Created] [datetime] NOT NULL ,
	[FileName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[RealFileName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [image] NOT NULL ,
	[ContentType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ContentSize] [int] NOT NULL ,
	[DownloadCount] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_PostEditNotes] (
	[PostID] [int] NOT NULL ,
	[EditNotes] [nvarchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_PostMetadata] (
	[PostID] [int] NOT NULL ,
	[MetaKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MetaType] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MetaValue] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_PostRating] (
	[UserID] [int] NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[Rating] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Post_Categories] (
	[CategoryID] [int] IDENTITY (1000, 1) NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[Name] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[CategoryType] [smallint] NOT NULL ,
	[IsEnabled] [bit] NOT NULL ,
	[ParentID] [int] NOT NULL ,
	[Description] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL ,
	[Path] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TotalThreads] [int] NOT NULL ,
	[MostRecentPostDate] [datetime] NULL ,
	[TotalSubThreads] [int] NOT NULL ,
	[MostRecentSubPostDate] [datetime] NULL ,
	[DateCreated] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Posts] (
	[PostID] [int] IDENTITY (1, 1) NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[ParentID] [int] NOT NULL ,
	[PostAuthor] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[PostLevel] [int] NOT NULL ,
	[SortOrder] [int] NOT NULL ,
	[Subject] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostDate] [datetime] NOT NULL ,
	[IsApproved] [bit] NOT NULL ,
	[IsLocked] [bit] NOT NULL ,
	[IsIndexed] [bit] NOT NULL ,
	[TotalViews] [int] NOT NULL ,
	[Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[FormattedBody] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[IPAddress] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostType] [int] NOT NULL ,
	[EmoticonID] [int] NOT NULL ,
	[PropertyNames] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PropertyValues] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL ,
	[AggViews] [int] NOT NULL ,
	[PostConfiguration] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

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

CREATE TABLE [dbo].[cs_Posts_InCategories] (
	[CategoryID] [int] NOT NULL ,
	[PostID] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_PrivateMessages] (
	[UserID] [int] NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Ranks] (
	[RankID] [int] IDENTITY (1, 1) NOT NULL ,
	[RankName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostingCountMin] [int] NULL ,
	[PostingCountMax] [int] NULL ,
	[RankIconUrl] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Referrals] (
	[ReferralID] [int] IDENTITY (1000, 1) NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[PostID] [int] NOT NULL ,
	[UrlID] [int] NOT NULL ,
	[Hits] [int] NOT NULL ,
	[LastDate] [datetime] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Reports] (
	[ReportID] [int] IDENTITY (1, 1) NOT NULL ,
	[ReportName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Active] [bit] NOT NULL ,
	[ReportCommand] [varchar] (6500) COLLATE Chinese_PRC_CI_AS NULL ,
	[ReportScript] [text] COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SchemaVersion] (
	[Major] [int] NOT NULL ,
	[Minor] [int] NOT NULL ,
	[Patch] [int] NOT NULL ,
	[InstallDate] [datetime] NOT NULL