📄 cs_schema.sql

📁 本系统是在asp版《在线文件管理器》的基础上设计制作
💻 SQL
📖 第 1 页 / 共 5 页
字号:
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SearchBarrel] (
	[WordHash] [int] NOT NULL ,
	[Word] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostID] [int] NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[Weight] [float] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SearchIgnoreWords] (
	[WordHash] [int] NOT NULL ,
	[Word] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Sections] (
	[SectionID] [int] IDENTITY (1, 1) NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[IsActive] [smallint] NOT NULL ,
	[ParentID] [int] NOT NULL ,
	[GroupID] [int] NOT NULL ,
	[Name] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewsgroupName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[DateCreated] [datetime] NOT NULL ,
	[Url] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsModerated] [smallint] NOT NULL ,
	[DaysToView] [int] NOT NULL ,
	[SortOrder] [int] NOT NULL ,
	[TotalPosts] [int] NOT NULL ,
	[TotalThreads] [int] NOT NULL ,
	[DisplayMask] [binary] (512) NOT NULL ,
	[EnablePostStatistics] [smallint] NOT NULL ,
	[EnableAutoDelete] [smallint] NOT NULL ,
	[EnableAnonymousPosting] [smallint] NOT NULL ,
	[AutoDeleteThreshold] [int] NOT NULL ,
	[MostRecentPostID] [int] NOT NULL ,
	[MostRecentThreadID] [int] NOT NULL ,
	[MostRecentThreadReplies] [int] NOT NULL ,
	[MostRecentPostSubject] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentPostAuthor] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentPostAuthorID] [int] NOT NULL ,
	[MostRecentPostDate] [datetime] NOT NULL ,
	[PostsToModerate] [int] NOT NULL ,
	[ForumType] [int] NOT NULL ,
	[IsSearchable] [smallint] NOT NULL ,
	[ApplicationType] [smallint] NOT NULL ,
	[ApplicationKey] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[PropertyNames] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PropertyValues] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Path] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SectionsRead] (
	[GroupID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[MarkReadAfter] [int] NOT NULL ,
	[NewPosts] [bit] NOT NULL ,
	[LastActivity] [datetime] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ServiceSchedule] (
	[ServiceID] [int] NOT NULL ,
	[ScheduleName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[MachineName] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[StartDate] [datetime] NOT NULL ,
	[EndDate] [datetime] NULL ,
	[ServiceParameters] [varchar] (256) COLLATE Chinese_PRC_CI_AS 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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Services] (
	[ServiceID] [int] IDENTITY (1, 1) NOT NULL ,
	[ServiceName] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceTypeCode] [int] NULL ,
	[ServiceAssemblyPath] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceFullClassName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[ServiceWorkingDirectory] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SiteMappings] (
	[SettingsID] [int] NOT NULL ,
	[SiteID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_SiteSettings] (
	[SettingsID] [int] IDENTITY (1000, 1) NOT NULL ,
	[Disabled] [bit] NOT NULL ,
	[Version] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsXML] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsKey] [uniqueidentifier] NULL ,
	[ApplicationName] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Sites] (
	[SiteID] [int] IDENTITY (1000, 1) NOT NULL ,
	[SiteUrl] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Smilies] (
	[SmileyID] [int] IDENTITY (1, 1) NOT NULL ,
	[SmileyCode] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmileyUrl] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SmileyText] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[BracketSafe] [bit] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Styles] (
	[StyleID] [int] IDENTITY (1, 1) NOT NULL ,
	[StyleName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[StyleSheetTemplate] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[BodyBackgroundColor] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[BodyTextColor] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkVisited] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkHover] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[LinkActive] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowColorPrimary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowColorSecondary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowColorTertiary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowClassPrimary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowClassSecondary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[RowClassTertiary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderColorPrimary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderColorSecondary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderColorTertiary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderStylePrimary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderStyleSecondary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[HeaderStyleTertiary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellColorPrimary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellColorSecondary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellColorTertiary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellClassPrimary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellClassSecondary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[CellClassTertiary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontFacePrimary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontFaceSecondary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontFaceTertiary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontSizePrimary] [smallint] NULL ,
	[FontSizeSecondary] [smallint] NULL ,
	[FontSizeTertiary] [smallint] NULL ,
	[FontColorPrimary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontColorSecondary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[FontColorTertiary] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[SpanClassPrimary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SpanClassSecondary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SpanClassTertiary] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Threads] (
	[ThreadID] [int] IDENTITY (1, 1) NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[PostAuthor] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[PostDate] [datetime] NOT NULL ,
	[ThreadDate] [datetime] NOT NULL ,
	[LastViewedDate] [datetime] NOT NULL ,
	[StickyDate] [datetime] NOT NULL ,
	[TotalViews] [int] NOT NULL ,
	[TotalReplies] [int] NOT NULL ,
	[MostRecentPostAuthorID] [int] NOT NULL ,
	[MostRecentPostAuthor] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
	[MostRecentPostID] [int] NOT NULL ,
	[IsLocked] [bit] NOT NULL ,
	[IsSticky] [bit] NOT NULL ,
	[IsApproved] [bit] NOT NULL ,
	[RatingSum] [int] NOT NULL ,
	[TotalRatings] [int] NOT NULL ,
	[ThreadEmoticonID] [int] NOT NULL ,
	[ThreadStatus] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_ThreadsRead] (
	[UserID] [int] NOT NULL ,
	[GroupID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[ThreadID] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_TrackedSections] (
	[SectionID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[SubscriptionType] [int] NOT NULL ,
	[DateCreated] [datetime] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_TrackedThreads] (
	[ThreadID] [int] NOT NULL ,
	[UserID] [int] NULL ,
	[DateCreated] [datetime] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Urls] (
	[UrlID] [int] NOT NULL ,
	[Url] [nvarchar] (512) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_UserAvatar] (
	[UserID] [int] NOT NULL ,
	[ImageID] [int] NOT NULL ,
	[FileName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_UserProfile] (
	[UserID] [int] NOT NULL ,
	[TimeZone] [float] NOT NULL ,
	[TotalPosts] [int] NOT NULL ,
	[PostSortOrder] [int] NOT NULL ,
	[DatabaseQuota] [int] NOT NULL ,
	[DatabaseQuotaUsed] [int] NOT NULL ,
	[Birthday] [datetime] NULL ,
	[PostRank] [binary] (1) NOT NULL ,
	[IsAvatarApproved] [smallint] NOT NULL ,
	[ModerationLevel] [smallint] NOT NULL ,
	[EnableThreadTracking] [smallint] NOT NULL ,
	[EnableDisplayUnreadThreadsOnly] [smallint] NOT NULL ,
	[EnableAvatar] [smallint] NOT NULL ,
	[EnableDisplayInMemberList] [smallint] NOT NULL ,
	[EnablePrivateMessages] [smallint] NOT NULL ,
	[EnableOnlineStatus] [smallint] NOT NULL ,
	[EnableHtmlEmail] [smallint] NOT NULL ,
	[MembershipID] [uniqueidentifier] NOT NULL ,
	[SettingsID] [int] NOT NULL ,
	[PropertyNames] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PropertyValues] [ntext] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Users] (
	[MembershipID] [uniqueidentifier] NOT NULL ,
	[UserID] [int] IDENTITY (2100, 1) NOT NULL ,
	[Nickname] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ForceLogin] [bit] NOT NULL ,
	[UserAccountStatus] [smallint] NOT NULL ,
	[AppUserToken] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastActivity] [datetime] NOT NULL ,
	[LastAction] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[IPCreated] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[IPLastActivity] [nvarchar] (32) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_UsersOnline] (
	[UserID] [int] NOT NULL ,
	[LastActivity] [datetime] NOT NULL ,
	[LastAction] [nvarchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
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 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_VoteSummary] (
	[PostID] [int] NOT NULL ,
	[Vote] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[VoteCount] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_Votes] (
	[PostID] [int] NOT NULL ,
	[UserID] [int] NOT NULL ,
	[Vote] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SettingsID] [int] NOT NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_nntp_Newsgroups] (
	[SectionID] [int] NOT NULL ,
	[NntpGroup] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[NntpServer] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_nntp_Posts] (
	[PostID] [int] NOT NULL ,
	[SectionID] [int] NOT NULL ,
	[NntpPostID] [int] NOT NULL ,
	[NntpUniqueID] [nvarchar] (256) COLLATE Chinese_PRC_CI_AS NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_statistics_Site] (
	[DateCreated] [datetime] NOT NULL ,
	[TotalUsers] [int] NOT NULL ,
	[TotalPosts] [int] NOT NULL ,
	[TotalModerators] [int] NOT NULL ,
	[TotalModeratedPosts] [int] NOT NULL ,
	[TotalAnonymousUsers] [int] NOT NULL ,
	[TotalTopics] [int] NOT NULL ,
	[DaysPosts] [int] NOT NULL ,
	[DaysTopics] [int] NOT NULL ,
	[NewPostsInPast24Hours] [int] NOT NULL ,
	[NewThreadsInPast24Hours] [int] NOT NULL ,
	[NewUsersInPast24Hours] [int] NOT NULL ,
	[MostViewsPostID] [int] NOT NULL ,
	[MostActivePostID] [int] NOT NULL ,
	[MostActiveUserID] [int] NOT NULL ,
	[MostReadPostID] [int] NOT NULL ,
	[NewestUserID] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[cs_statistics_User] (
	[UserID] [int] NOT NULL ,
	[TotalPosts] [int] NOT NULL ,
	[SettingsID] [int] NULL 
) ON [PRIMARY]
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -