📄 sqlserver.sql

📁 LiteBlaster 是一款基于 .NET Framework 原创的 ASP.NET 论坛系统。后台程序库采用 C#/VB.NET 编写
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
	[BookmarkTopics] [ntext] NULL,
	[JoinTime] [datetime] NOT NULL,
	[LastLogin] [datetime] NULL CONSTRAINT [DF_Users_LastLogin]  DEFAULT (getdate()),
	[LoginCount] [int] NULL CONSTRAINT [DF_Users_LoginCount]  DEFAULT ((0)),
	[PostCount] [int] NULL CONSTRAINT [DF_Users_PostCount]  DEFAULT ((0)),
	[TopicCount] [int] NULL CONSTRAINT [DF_Users_TopicCount]  DEFAULT ((0)),
	[BestCount] [int] NULL CONSTRAINT [DF_Users_BestCount]  DEFAULT ((0)),
	[EP] [int] NULL CONSTRAINT [DF_Users_EP]  DEFAULT ((0)),
	[Locked] [bit] NULL CONSTRAINT [DF_Users_Locked]  DEFAULT ((0)),
	[Comment] [nvarchar](255) NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Users]') AND name = N'IX_Users')
CREATE NONCLUSTERED INDEX [IX_Users] ON [Users] 
(
	[Name] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Uploads]    脚本日期: 06/02/2007 12:55:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Uploads]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Uploads](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[PostID] [int] NOT NULL,
	[UserName] [nvarchar](20) NOT NULL,
	[FileName] [nvarchar](255) NOT NULL,
	[FileType] [nvarchar](10) NOT NULL,
	[FileSize] [int] NOT NULL,
	[ServerSideName] [nvarchar](255) NOT NULL,
	[Description] [nvarchar](255) NULL,
	[MinEP] [int] NULL CONSTRAINT [DF_Uploads_MinEP]  DEFAULT ((0)),
	[DownTimes] [int] NULL CONSTRAINT [DF_Uploads_DownTimes]  DEFAULT ((0)),
	[UploadTime] [datetime] NOT NULL,
 CONSTRAINT [PK_Uploads] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Uploads]') AND name = N'IX_Uploads')
CREATE UNIQUE NONCLUSTERED INDEX [IX_Uploads] ON [Uploads] 
(
	[ServerSideName] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Topics]    脚本日期: 06/02/2007 12:55:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Topics]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Topics](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Title] [nvarchar](100) NOT NULL,
	[BoardID] [int] NOT NULL,
	[UserName] [nvarchar](20) NOT NULL,
	[PostTime] [datetime] NOT NULL,
	[Best] [bit] NULL CONSTRAINT [DF_Topics_Best]  DEFAULT ((0)),
	[OnTop] [bit] NULL CONSTRAINT [DF_Topics_SetTop]  DEFAULT ((0)),
	[Striking] [bit] NULL CONSTRAINT [DF_Topics_Striking]  DEFAULT ((0)),
	[Closed] [bit] NULL CONSTRAINT [DF_Topics_Closed]  DEFAULT ((0)),
	[Locked] [bit] NULL CONSTRAINT [DF_Topics_Locked]  DEFAULT ((0)),
	[Attachment] [tinyint] NULL CONSTRAINT [DF_Topics_HasVote]  DEFAULT ((0)),
	[BestAnswerID] [int] NULL CONSTRAINT [DF_Topics_BestAnswerID]  DEFAULT ((0)),
	[HitCount] [int] NULL CONSTRAINT [DF_Topics_HitCount]  DEFAULT ((0)),
	[ReplyCount] [smallint] NULL CONSTRAINT [DF_Topics_ReplyCount]  DEFAULT ((0)),
	[DeletedCount] [smallint] NULL CONSTRAINT [DF_Topics_DeletedCount]  DEFAULT ((0)),
	[Remark] [int] NULL CONSTRAINT [DF_Topics_Remark]  DEFAULT ((0)),
	[LastPostUserName] [nvarchar](20) NULL,
	[LastPostTime] [datetime] NULL CONSTRAINT [DF_Topics_LastPostTime]  DEFAULT (getdate()),
	[NotifyPosterWhenReplied] [bit] NULL CONSTRAINT [DF_Topics_NotifyPosterWhenReplied]  DEFAULT ((0)),
 CONSTRAINT [PK_Topics] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Topics]') AND name = N'IX_Topics')
CREATE NONCLUSTERED INDEX [IX_Topics] ON [Topics] 
(
	[BoardID] ASC,
	[UserName] ASC,
	[PostTime] ASC,
	[LastPostTime] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Sections]    脚本日期: 06/02/2007 12:54:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Sections]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Sections](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Title] [nvarchar](30) NOT NULL,
	[Sequence] [datetime] NOT NULL,
 CONSTRAINT [PK_Sections] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Sections]') AND name = N'IX_Sections')
CREATE NONCLUSTERED INDEX [IX_Sections] ON [Sections] 
(
	[Sequence] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Posts]    脚本日期: 06/02/2007 12:54:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Posts]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Posts](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[TopicID] [int] NOT NULL,
	[UserName] [nvarchar](20) NOT NULL,
	[PostTime] [datetime] NOT NULL,
	[LastOperator] [nvarchar](20) NULL,
	[LastEditTime] [datetime] NULL CONSTRAINT [DF_Posts_LastEditTime]  DEFAULT (getdate()),
	[IP] [nvarchar](30) NULL CONSTRAINT [DF_Posts_IP]  DEFAULT (N'(没有记录)'),
	[Floor] [smallint] NULL CONSTRAINT [DF_Posts_Floor]  DEFAULT ((0)),
	[Remark] [int] NULL CONSTRAINT [DF_Posts_Remark]  DEFAULT ((0)),
	[UploadCount] [smallint] NULL CONSTRAINT [DF_Posts_UploadID]  DEFAULT ((0)),
	[Status] [tinyint] NULL CONSTRAINT [DF_Posts_Deleted]  DEFAULT ((0)),
	[MoodEnabled] [bit] NULL CONSTRAINT [DF_Posts_MoodEnabled]  DEFAULT ((0)),
	[CodeEnabled] [bit] NULL CONSTRAINT [DF_Posts_CodeEnabled]  DEFAULT ((0)),
	[ExtraReason] [nvarchar](50) NULL,
	[Body] [ntext] NOT NULL,
 CONSTRAINT [PK_Posts] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Posts]') AND name = N'IX_Posts')
CREATE NONCLUSTERED INDEX [IX_Posts] ON [Posts] 
(
	[TopicID] ASC,
	[UserName] ASC,
	[Floor] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Groups]    脚本日期: 06/02/2007 12:54:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Groups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Groups](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Type] [tinyint] NULL CONSTRAINT [DF_Groups_Type]  DEFAULT ((1)),
	[Title] [nvarchar](20) NOT NULL,
	[MinEP] [int] NOT NULL CONSTRAINT [DF_Groups_MinEP]  DEFAULT ((-2147483648.)),
	[CanCustomTitle] [bit] NULL CONSTRAINT [DF_Groups_CanCustomTitle]  DEFAULT ((0)),
	[CanCustomFace] [bit] NULL CONSTRAINT [DF_Groups_CanCustomFace]  DEFAULT ((0)),
	[CanListBoards] [bit] NULL CONSTRAINT [DF_Groups_CanListBoards]  DEFAULT ((0)),
	[CanListTopics] [bit] NULL CONSTRAINT [DF_Groups_CanListTopics]  DEFAULT ((0)),
	[CanListPosts] [bit] NULL CONSTRAINT [DF_Groups_CanListReplies]  DEFAULT ((0)),
	[CanPostTopics] [bit] NULL CONSTRAINT [DF_Groups_CanPostTopics]  DEFAULT ((0)),
	[CanMoveOwnTopics] [bit] NULL CONSTRAINT [DF_Groups_CanMoveOwnTopics]  DEFAULT ((0)),
	[CanMakeOwnTopicsStriking] [bit] NULL CONSTRAINT [DF_Groups_CanMakeOwnTopicsStriking]  DEFAULT ((0)),
	[CanReplyTopics] [bit] NULL CONSTRAINT [DF_Groups_CanReplyTopics]  DEFAULT ((0)),
	[CanEditOwnPosts] [bit] NULL CONSTRAINT [DF_Groups_CanEditOwnPost]  DEFAULT ((0)),
	[CanReadRestrictedPosts] [bit] NULL CONSTRAINT [DF_Groups_CanReadRestrictedPost]  DEFAULT ((0)),
	[CanPostRestrictedPosts] [bit] NULL CONSTRAINT [DF_Groups_CanPostRestrictedPost]  DEFAULT ((0)),
	[CanEnterMoods] [bit] NULL CONSTRAINT [DF_Groups_CanEnterMood]  DEFAULT ((0)),
	[CanEnterCodes] [bit] NULL CONSTRAINT [DF_Groups_CanEnterCode]  DEFAULT ((0)),
	[CanPostVotes] [bit] NULL CONSTRAINT [DF_Groups_CanPostVote]  DEFAULT ((0)),
	[CanJoinVotes] [bit] NULL CONSTRAINT [DF_Groups_CanJoinVote]  DEFAULT ((0)),
	[CanBookmark] [bit] NULL CONSTRAINT [DF_Groups_CanBookmark]  DEFAULT ((0)),
	[CanViewUserInfo] [bit] NULL CONSTRAINT [DF_Groups_CanViewUserInfo]  DEFAULT ((0)),
	[CanViewIP] [bit] NULL CONSTRAINT [DF_Groups_CanViewIP]  DEFAULT ((0)),
	[CanUploadFiles] [bit] NULL CONSTRAINT [DF_Groups_CanUploadFiles]  DEFAULT ((0)),
	[CanDownloadFiles] [bit] NULL CONSTRAINT [DF_Groups_CanDownloadFiles]  DEFAULT ((0)),
	[CanSendMessages] [bit] NULL CONSTRAINT [DF_Groups_CanSendMessages]  DEFAULT ((0)),
 CONSTRAINT [PK_Groups] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[Setup]    脚本日期: 06/02/2007 12:54:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Setup]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Setup](
	[ForumTitle] [nvarchar](50) NOT NULL,
	[ForumDomain] [nvarchar](255) NOT NULL CONSTRAINT [DF_Setup_ForumDomain]  DEFAULT (N'http://localhost/'),
	[ForumLogoPath] [nvarchar](255) NULL,
	[ForumAd] [ntext] NULL,
	[ForbiddenUserNames] [ntext] NULL,
	[Badwords] [ntext] NULL,
	[TopicCount] [int] NULL CONSTRAINT [DF_Setup_TopicCount]  DEFAULT ((0)),
	[PostCount] [int] NULL CONSTRAINT [DF_Setup_PostCount]  DEFAULT ((0)),
	[UserCount] [int] NULL CONSTRAINT [DF_Setup_UserCount]  DEFAULT ((0)),
	[MaxOnlineCount] [int] NULL CONSTRAINT [DF_Setup_MaxOnlineCount]  DEFAULT ((0)),
	[MaxOnlineTime] [datetime] NULL CONSTRAINT [DF_Setup_MaxOnlineTime]  DEFAULT (getdate()),
	[MoodEnabled] [bit] NULL CONSTRAINT [DF_Setup_MoodEnabled]  DEFAULT ((1)),
	[CodeEnabled] [bit] NULL CONSTRAINT [DF_Setup_CodeEnabled]  DEFAULT ((1)),
	[VoteEnabled] [bit] NULL CONSTRAINT [DF_Setup_VoteEnabled]  DEFAULT ((1)),
	[UploadSizeLimit] [int] NULL CONSTRAINT [DF_Setup_UploadSizeLimit]  DEFAULT ((600000)),
	[UploadCountLimitPerPost] [int] NULL CONSTRAINT [DF_Setup_UploadCountLimitPerPost]  DEFAULT ((2)),
	[UploadTypeLimit] [nvarchar](255) NULL,
	[EPRemarkLimitPerTopic] [int] NULL CONSTRAINT [DF_Setup_EPRemarkLimitPerTopic]  DEFAULT ((30)),
	[EPRemarkLimitPerPost] [int] NULL CONSTRAINT [DF_Setup_EPRemarkLimitPerPost]  DEFAULT ((5)),
	[MaintainingOnStart] [bit] NULL CONSTRAINT [DF_Setup_MaintainingOnStart]  DEFAULT ((0)),
	[LockNewUser] [bit] NULL CONSTRAINT [DF_Setup_LockNewUser]  DEFAULT ((0)),
	[NotifyAdminWhenRegInfoChanged] [bit] NULL CONSTRAINT [DF_Setup_NotifyAdminWhenRegInfoChanged]  DEFAULT ((1)),
	[SystemEmailSmtpServer] [nvarchar](255) NULL,
	[SystemEmailSslEnabled] [bit] NULL CONSTRAINT [DF_Setup_SystemEmailSslEnabled]  DEFAULT ((0)),
	[SystemEmailAddress] [nvarchar](100) NULL,
	[SystemEmailUserName] [nvarchar](50) NULL,
	[SystemEmailPassword] [nvarchar](50) NULL,
	[LastRegUser] [nvarchar](20) NULL,
	[Copyright] [nvarchar](255) NULL,
	[Maintain] [nvarchar](255) NULL,
	[Product] [nvarchar](20) NULL,
	[Version] [nvarchar](20) NULL,
	[OtherInfo] [nvarchar](255) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[Broadcast]    脚本日期: 06/02/2007 12:53:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Broadcast]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Broadcast](
	[Title] [nvarchar](255) NOT NULL,
	[Link] [nvarchar](255) NULL,
	[AddTime] [datetime] NOT NULL
) ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[EPGain]    脚本日期: 06/02/2007 12:53:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[EPGain]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [EPGain](
	[Login] [int] NULL,
	[CustomTitle] [int] NULL,
	[CustomFace] [int] NULL,
	[PostTopic] [int] NULL,
	[ReplyTopic] [int] NULL,
	[PostRestrictedPost] [int] NULL,
	[MakeOwnTopicStriking] [int] NULL,
	[RemoveOwnPost] [int] NULL,
	[BestTopic] [int] NULL,
	[BestAnswer] [int] NULL,
	[PostVote] [int] NULL,
	[JoinVote] [int] NULL,
	[UploadFile] [int] NULL,
	[DownloadFile] [int] NULL,
	[SendMessage] [int] NULL
) ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[ExtraAccess]    脚本日期: 06/02/2007 12:53:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[ExtraAccess]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [ExtraAccess](
	[UserID] [int] NOT NULL,
	[BoardID] [int] NOT NULL,
	[AccessType] [tinyint] NULL CONSTRAINT [DF_ExtraAccess_Readonly]  DEFAULT ((0)),
	[ExpiringTime] [datetime] NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[ExtraAccess]') AND name = N'IX_ExtraAccess')
CREATE NONCLUSTERED INDEX [IX_ExtraAccess] ON [ExtraAccess] 
(
	[UserID] ASC,
	[BoardID] ASC
) ON [PRIMARY]
GO
上一页 12
⌨️ 快捷键说明

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