📄 sqlserver.sql

📁 LiteBlaster 是一款基于 .NET Framework 原创的 ASP.NET 论坛系统。后台程序库采用 C#/VB.NET 编写
💻 SQL
📖 第 1 页 / 共 2 页
字号:
12 下一页
/****** 对象:  Table [dbo].[Friends]    脚本日期: 06/02/2007 12:53:57 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Friends]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Friends]
GO
/****** 对象:  Table [dbo].[IPAccess]    脚本日期: 06/02/2007 12:54:20 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[IPAccess]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [IPAccess]
GO
/****** 对象:  Table [dbo].[Links]    脚本日期: 06/02/2007 12:54:22 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Links]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Links]
GO
/****** 对象:  Table [dbo].[Messages]    脚本日期: 06/02/2007 12:54:26 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Messages]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Messages]
GO
/****** 对象:  Table [dbo].[Online]    脚本日期: 06/02/2007 12:54:29 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Online]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Online]
GO
/****** 对象:  Table [dbo].[Boards]    脚本日期: 06/02/2007 12:53:45 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Boards]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Boards]
GO
/****** 对象:  Table [dbo].[Help]    脚本日期: 06/02/2007 12:54:16 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Help]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Help]
GO
/****** 对象:  Table [dbo].[Votes]    脚本日期: 06/02/2007 12:55:50 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Votes]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Votes]
GO
/****** 对象:  Table [dbo].[Users]    脚本日期: 06/02/2007 12:55:41 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Users]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Users]
GO
/****** 对象:  Table [dbo].[Uploads]    脚本日期: 06/02/2007 12:55:16 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Uploads]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Uploads]
GO
/****** 对象:  Table [dbo].[Topics]    脚本日期: 06/02/2007 12:55:10 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Topics]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Topics]
GO
/****** 对象:  Table [dbo].[Sections]    脚本日期: 06/02/2007 12:54:40 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Sections]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Sections]
GO
/****** 对象:  Table [dbo].[Posts]    脚本日期: 06/02/2007 12:54:38 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Posts]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Posts]
GO
/****** 对象:  Table [dbo].[Groups]    脚本日期: 06/02/2007 12:54:13 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Groups]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Groups]
GO
/****** 对象:  Table [dbo].[Setup]    脚本日期: 06/02/2007 12:54:58 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Setup]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Setup]
GO
/****** 对象:  Table [dbo].[Broadcast]    脚本日期: 06/02/2007 12:53:47 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Broadcast]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [Broadcast]
GO
/****** 对象:  Table [dbo].[EPGain]    脚本日期: 06/02/2007 12:53:54 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[EPGain]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [EPGain]
GO
/****** 对象:  Table [dbo].[ExtraAccess]    脚本日期: 06/02/2007 12:53:56 ******/
IF  EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[ExtraAccess]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [ExtraAccess]
GO
/****** 对象:  Table [dbo].[Friends]    脚本日期: 06/02/2007 12:53:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Friends]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Friends](
	[UserName] [nvarchar](20) NOT NULL,
	[FriendName] [nvarchar](20) NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Friends]') AND name = N'IX_Friends')
CREATE NONCLUSTERED INDEX [IX_Friends] ON [Friends] 
(
	[UserName] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[IPAccess]    脚本日期: 06/02/2007 12:54:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[IPAccess]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [IPAccess](
	[IP] [nvarchar](30) NOT NULL,
	[UserName] [nvarchar](20) NULL,
	[AccessType] [tinyint] NULL CONSTRAINT [DF_IPAccess_AccessType]  DEFAULT ((0)),
	[ExpiringTime] [datetime] NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[IPAccess]') AND name = N'IX_IPAccess')
CREATE NONCLUSTERED INDEX [IX_IPAccess] ON [IPAccess] 
(
	[IP] ASC,
	[UserName] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Links]    脚本日期: 06/02/2007 12:54:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Links]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Links](
	[Title] [nvarchar](50) NULL,
	[Link] [nvarchar](255) NOT NULL,
	[LogoPath] [nvarchar](255) NULL
) ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[Messages]    脚本日期: 06/02/2007 12:54:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Messages]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Messages](
	[MsgFrom] [nvarchar](20) NULL,
	[MsgTo] [nvarchar](20) NOT NULL,
	[System] [bit] NULL CONSTRAINT [DF_Messages_System]  DEFAULT ((0)),
	[SendTime] [datetime] NOT NULL,
	[MsgRead] [bit] NULL CONSTRAINT [DF_Messages_MsgRead]  DEFAULT ((0)),
	[Body] [nvarchar](255) NOT NULL
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM dbo.sysindexes WHERE id = OBJECT_ID(N'[Messages]') AND name = N'IX_Messages')
CREATE NONCLUSTERED INDEX [IX_Messages] ON [Messages] 
(
	[MsgTo] ASC,
	[SendTime] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Online]    脚本日期: 06/02/2007 12:54:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Online]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Online](
	[UserName] [nvarchar](20) NOT NULL,
	[IP] [nvarchar](30) NULL CONSTRAINT [DF_Online_IP]  DEFAULT (N'(没有记录)'),
	[Hidden] [bit] NULL CONSTRAINT [DF_Online_Hidden]  DEFAULT ((0)),
 CONSTRAINT [PK_Online] PRIMARY KEY CLUSTERED 
(
	[UserName] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** 对象:  Table [dbo].[Boards]    脚本日期: 06/02/2007 12:53:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Boards]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Boards](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Name] [nvarchar](30) NOT NULL,
	[SectionID] [int] NOT NULL,
	[ParentID] [int] NOT NULL,
	[Depth] [tinyint] NOT NULL,
	[ChildrenIDs] [nvarchar](255) NULL,
	[Sequence] [datetime] NOT NULL,
	[Masters] [nvarchar](255) NULL,
	[Description] [nvarchar](255) NULL CONSTRAINT [DF_Boards_Description]  DEFAULT (N''),
	[PostCount] [int] NULL CONSTRAINT [DF_Boards_PostCount]  DEFAULT ((0)),
	[TopicCount] [int] NULL CONSTRAINT [DF_Boards_TopicCount]  DEFAULT ((0)),
	[LastPostID] [int] NULL CONSTRAINT [DF_Boards_LastPostID]  DEFAULT ((0)),
	[LogoPath] [nvarchar](255) NULL,
	[BestAnswerEnabled] [bit] NULL CONSTRAINT [DF_Boards_BestAnswerEnabled]  DEFAULT ((1)),
	[UploadEnabled] [bit] NULL CONSTRAINT [DF_Boards_UploadEnabled]  DEFAULT ((0)),
	[Status] [tinyint] NULL CONSTRAINT [DF_Boards_Status]  DEFAULT ((0)),
	[MinEP] [int] NULL CONSTRAINT [DF_Boards_MinEP]  DEFAULT ((0)),
	[ReadonlyGroups] [nvarchar](255) NULL,
	[ForbiddenGroups] [nvarchar](255) NULL,
	[Rules] [ntext] NULL CONSTRAINT [DF_Boards_Rules]  DEFAULT (N''),
 CONSTRAINT [PK_Boards] 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'[Boards]') AND name = N'IX_Boards')
CREATE NONCLUSTERED INDEX [IX_Boards] ON [Boards] 
(
	[SectionID] ASC,
	[Sequence] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Help]    脚本日期: 06/02/2007 12:54:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Help]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Help](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[ParentID] [int] NOT NULL,
	[Title] [nvarchar](50) NOT NULL,
	[Body] [ntext] NULL,
 CONSTRAINT [PK_Help] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM ::fn_listextendedproperty(N'MS_Description' , N'USER',N'dbo', N'TABLE',N'Help', N'COLUMN',N'ParentID'))
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'0 indicates a section of help' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Help', @level2type=N'COLUMN',@level2name=N'ParentID'
GO
/****** 对象:  Table [dbo].[Votes]    脚本日期: 06/02/2007 12:55:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Votes]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Votes](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[TopicID] [int] NOT NULL,
	[SurveyID] [int] NOT NULL,
	[Title] [nvarchar](255) NOT NULL,
	[Locked] [bit] NULL CONSTRAINT [DF_Votes_Closed]  DEFAULT ((0)),
	[OtherEnabled] [bit] NULL CONSTRAINT [DF__votes__OtherEnab__3F6663D5]  DEFAULT ('0'),
	[OptionLimit] [tinyint] NULL CONSTRAINT [DF_Votes_Multiple]  DEFAULT ((1)),
	[VoteTimes] [int] NULL CONSTRAINT [DF_Votes_VoteTimes]  DEFAULT ((0)),
	[Body] [ntext] NOT NULL,
	[Results] [ntext] NOT NULL,
	[OtherBody] [ntext] NULL,
	[OtherResults] [ntext] NULL,
	[Details] [ntext] NULL CONSTRAINT [DF_Votes_Details]  DEFAULT (N''),
 CONSTRAINT [PK_Votes] 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'[Votes]') AND name = N'IX_Votes')
CREATE NONCLUSTERED INDEX [IX_Votes] ON [Votes] 
(
	[TopicID] ASC,
	[SurveyID] ASC
) ON [PRIMARY]
GO
/****** 对象:  Table [dbo].[Users]    脚本日期: 06/02/2007 12:55:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[Users]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [Users](
	[ID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[Name] [nvarchar](20) NOT NULL,
	[RealName] [nvarchar](20) NOT NULL,
	[ShowRealName] [bit] NULL CONSTRAINT [DF_Users_ShowRealName]  DEFAULT ((0)),
	[Password] [nvarchar](40) NOT NULL,
	[Male] [bit] NULL CONSTRAINT [DF_Users_Male]  DEFAULT ((1)),
	[ShowGender] [bit] NULL CONSTRAINT [DF_Users_ShowGender]  DEFAULT ((1)),
	[Birthday] [datetime] NOT NULL,
	[ShowBirthday] [bit] NULL CONSTRAINT [DF_Users_ShowBirthday]  DEFAULT ((1)),
	[Email] [nvarchar](100) NOT NULL,
	[ShowEmail] [bit] NULL CONSTRAINT [DF_Users_ShowEmail]  DEFAULT ((1)),
	[Address] [nvarchar](255) NOT NULL,
	[ShowAddress] [bit] NULL CONSTRAINT [DF_Users_ShowAddress]  DEFAULT ((0)),
	[IM] [nvarchar](100) NULL,
	[ShowIM] [bit] NULL CONSTRAINT [DF_Users_ShowIM]  DEFAULT ((1)),
	[Question] [nvarchar](50) NOT NULL,
	[Answer] [nvarchar](40) NOT NULL,
	[CustomTitle] [nvarchar](20) NULL,
	[ComeFrom] [nvarchar](50) NULL,
	[Description] [nvarchar](255) NULL CONSTRAINT [DF_Users_Description]  DEFAULT (N''),
	[Signature] [nvarchar](255) NULL CONSTRAINT [DF_Users_Sign]  DEFAULT (N''),
	[FacePath] [nvarchar](255) NULL,
	[TopicCountPerPage] [int] NULL CONSTRAINT [DF_Users_TopicCountPerPage]  DEFAULT ((25)),
	[PostCountPerPage] [int] NULL CONSTRAINT [DF_Users_PostCountPerPage]  DEFAULT ((10)),
	[ParentBoardDisplayChildrenTopics] [bit] NULL CONSTRAINT [DF_Users_ParentBoardDisplayChildrenTopics]  DEFAULT ((0)),
	[TimeZone] [real] NULL CONSTRAINT [DF_Users_TimeZone]  DEFAULT ((8)),
	[TimeFormat] [nvarchar](50) NULL CONSTRAINT [DF_Users_TimeFormat]  DEFAULT (N'yyyy-MM-dd HH:mm'),
	[DSTMode] [tinyint] NULL CONSTRAINT [DF_Users_DSTMode]  DEFAULT ((0)),
	[GroupType] [tinyint] NULL CONSTRAINT [DF_Users_GroupType]  DEFAULT ((1)),
	[SecondGroup] [tinyint] NULL CONSTRAINT [DF_Users_SecondGroup]  DEFAULT ((0)),
	[MasterBoards] [nvarchar](255) NULL,
	[BookmarkBoards] [nvarchar](255) NULL,
12 下一页
⌨️ 快捷键说明

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