table.sql

asp.net 商业2.0论坛对理解论坛的制作很用帮助

CREATE TABLE [dbo].[Forum_Info_Offline] (
	[ID] [int] NOT NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Code] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Notes] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ParentID] [int] NULL ,
	[ReadOnly] [bit] NULL ,
	[Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[AddDate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Link]    Script Date: 2002-12-14 15:27:36 ******/
CREATE TABLE [dbo].[Forum_Link] (
	[Forum_Link_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Link_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Link_Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Link_Mark] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Mail]    Script Date: 2002-12-14 15:27:36 ******/
CREATE TABLE [dbo].[Forum_Mail] (
	[Forum_Mail_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Mail_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Mail_SmtpServer] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Mail_UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Mail_PassWord] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Mail_Html] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Mail_Priority] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Online]    Script Date: 2002-12-14 15:27:36 ******/
CREATE TABLE [dbo].[Forum_Online] (
	[Forum_Online_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Forum_Online_Class] [int] NULL ,
	[Forum_Online_Ip] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Online_System] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Online_Browser] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Online_Location] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Online_Action] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Online_LastLogin] [datetime] NULL ,
	[Forum_Online_Login] [datetime] NULL ,
	[Forum_Online_Now] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_SmallPaper]    Script Date: 2002-12-14 15:27:36 ******/
CREATE TABLE [dbo].[Forum_SmallPaper] (
	[Forum_SmallPaper_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_SmallPaper_BoardId] [int] NULL ,
	[Forum_SmallPaper_UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_SmallPaper_Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_SmallPaper_Addtime] [datetime] NULL ,
	[Forum_SmallPaper_Hits] [int] NULL ,
	[Forum_SmallPaper_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[isdel] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Sms]    Script Date: 2002-12-14 15:27:36 ******/
CREATE TABLE [dbo].[Forum_Sms] (
	[Forum_Sms_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Sms_Sender] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Sms_Incept] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Sms_Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Sms_Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Sms_IsRead] [int] NULL ,
	[Forum_Sms_DelI] [int] NULL ,
	[Forum_Sms_DelS] [int] NULL ,
	[Forum_Sms_IsSend] [int] NULL ,
	[Forum_Sms_InputDate] [datetime] NULL ,
	[Forum_Sms_Sign] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Users]    Script Date: 2002-12-14 15:27:37 ******/
CREATE TABLE [dbo].[Forum_Users] (
	[Forum_Users_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Users_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Pwd] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Ask] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Answer] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Email] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Gender] [int] NULL ,
	[Forum_Users_Birth] [datetime] NULL ,
	[Forum_Users_Honor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Head] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_HeadW] [int] NULL ,
	[Forum_Users_HeadH] [int] NULL ,
	[Forum_Users_HomePage] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Mobile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Qq] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Icq] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Msn] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Mark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_Remind] [int] NULL ,
	[Forum_Users_Class] [int] NULL ,
	[Forum_Users_Post] [int] NULL ,
	[Forum_Users_Weh] [int] NULL ,
	[Forum_Users_Exp] [int] NULL ,
	[Forum_Users_Lns] [int] NULL ,
	[Forum_Users_Reg] [datetime] NULL ,
	[Forum_Users_LastLogin] [datetime] NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Users_Class]    Script Date: 2002-12-14 15:27:37 ******/
CREATE TABLE [dbo].[Forum_Users_Class] (
	[Forum_Users_ClassId] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Users_ClassName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_ClassPic] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Users_ClassPost] [int] NULL ,
	[Forum_Users_ClassExp] [int] NULL ,
	[Forum_Users_ClassLns] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Users_Config]    Script Date: 2002-12-14 15:27:37 ******/
CREATE TABLE [dbo].[Forum_Users_Config] (
	[Forum_Users_ConfigId] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Users_WehReg] [int] NULL ,
	[Forum_Users_WehLogin] [int] NULL ,
	[Forum_Users_WehPost] [int] NULL ,
	[Forum_Users_WehRepost] [int] NULL ,
	[Forum_Users_WehGood] [int] NULL ,
	[Forum_Users_WehVote] [int] NULL ,
	[Forum_Users_WehDel] [int] NULL ,
	[Forum_Users_WehSmallPaper] [int] NULL ,
	[Forum_Users_ExpReg] [int] NULL ,
	[Forum_Users_ExpLogin] [int] NULL ,
	[Forum_Users_ExpPost] [int] NULL ,
	[Forum_Users_ExpRepost] [int] NULL ,
	[Forum_Users_ExpGood] [int] NULL ,
	[Forum_Users_ExpVote] [int] NULL ,
	[Forum_Users_ExpDel] [int] NULL ,
	[Forum_Users_LnsReg] [int] NULL ,
	[Forum_Users_LnsLogin] [int] NULL ,
	[Forum_Users_LnsPost] [int] NULL ,
	[Forum_Users_LnsRepost] [int] NULL ,
	[Forum_Users_LnsGood] [int] NULL ,
	[Forum_Users_LnsVote] [int] NULL ,
	[Forum_Users_LnsDel] [int] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Vote]    Script Date: 2002-12-14 15:27:37 ******/
CREATE TABLE [dbo].[Forum_Vote] (
	[Forum_Vote_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Vote_Title] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Vote_ItemNum] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Vote_Num] [int] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_VoteUser]    Script Date: 2002-12-14 15:27:38 ******/
CREATE TABLE [dbo].[Forum_VoteUser] (
	[Forum_VoteUser_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Vote_Id] [int] NULL ,
	[Forum_Vote_User] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Vote_Option] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Vote_Date] [datetime] NULL ,
	[Forum_Vote_Ip] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Forum_BookMarks] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_BookMarks] PRIMARY KEY  CLUSTERED 
	(
		[Forum_BookMark_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_Code] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_Code] PRIMARY KEY  CLUSTERED 
	(
		[Forum_Code_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_Config] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_Config] PRIMARY KEY  CLUSTERED 
	(
		[Forum_Config_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_Info_Offline] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_Info_Offline] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_Vote] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_Vote] PRIMARY KEY  CLUSTERED 
	(
		[Forum_Vote_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_VoteUser] WITH NOCHECK ADD 
	CONSTRAINT [PK_Forum_VoteUser] PRIMARY KEY  CLUSTERED 
	(
		[Forum_VoteUser_Id]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Forum_BBSNews] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_BBSNews_Forum_BBSNews_addtime] DEFAULT (getdate()) FOR [Forum_BBSNews_AddTime],
	CONSTRAINT [DF_Forum_BBSNews_isdel] DEFAULT (0) FOR [isdel]
GO

ALTER TABLE [dbo].[Forum_Board] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_Board_Forum_Board_LastPostDate] DEFAULT (getdate()) FOR [Forum_Board_LastPostDate]
GO

ALTER TABLE [dbo].[Forum_BookMarks] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_BookMarks_Forum_BookMark_Time] DEFAULT (getdate()) FOR [Forum_BookMark_Time]
GO

ALTER TABLE [dbo].[Forum_Class] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_Class_Forum_Class_TaxisNo] DEFAULT (0) FOR [Forum_Class_TaxisNo]
GO

ALTER TABLE [dbo].[Forum_Config] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_Config_Forum_Config_Sms] DEFAULT (0) FOR [Forum_Config_Sms],
	CONSTRAINT [DF_Forum_Config_Forum_Config_Sound] DEFAULT (0) FOR [Forum_Config_Sound]
GO

ALTER TABLE [dbo].[Forum_Info] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsTop] DEFAULT (0) FOR [Forum_Info_IsTop],
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsLock] DEFAULT (0) FOR [Forum_Info_IsLock],
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsGood] DEFAULT (0) FOR [Forum_Info_IsGood],
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsVote] DEFAULT (0) FOR [Forum_Info_IsVote],
	CONSTRAINT [DF_Forum_Info_Forum_Info_InputDate] DEFAULT (getdate()) FOR [Forum_Info_InputDate],
	CONSTRAINT [DF_Forum_Info_Forum_Info_Hit] DEFAULT (0) FOR [Forum_Info_Hit],
	CONSTRAINT [DF_Forum_Info_Forum_Info_Revert] DEFAULT (0) FOR [Forum_Info_Revert],
	CONSTRAINT [DF_Forum_Info_Forum_Info_RevertDate] DEFAULT (getdate()) FOR [Forum_Info_RevertDate],
	CONSTRAINT [DF_Forum_Info_Forum_Info_Exp] DEFAULT (0) FOR [Forum_Info_Exp],
	CONSTRAINT [DF_Forum_Info_Forum_Infp_Lns] DEFAULT (0) FOR [Forum_Info_Lns],
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsRe] DEFAULT (0) FOR [Forum_Info_IsRe],
	CONSTRAINT [DF_Forum_Info_Forum_Info_IsMail] DEFAULT (0) FOR [Forum_Info_IsMail]
GO

ALTER TABLE [dbo].[Forum_Info_Offline] WITH NOCHECK ADD 
	CONSTRAINT [DF_codeitems_AddDate] DEFAULT (getdate()) FOR [AddDate]
GO

ALTER TABLE [dbo].[Forum_SmallPaper] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_SmallPaper_Forum_SmallPaper_Addtime] DEFAULT (getdate()) FOR [Forum_SmallPaper_Addtime],
	CONSTRAINT [DF_Forum_SmallPaper_Forum_SmallPaper_Hits] DEFAULT (0) FOR [Forum_SmallPaper_Hits]
GO

ALTER TABLE [dbo].[Forum_Vote] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_Vote_Forum_Vote_Num] DEFAULT (0) FOR [Forum_Vote_Num]
GO

ALTER TABLE [dbo].[Forum_VoteUser] WITH NOCHECK ADD 
	CONSTRAINT [DF_Forum_VoteUser_Forum_Vote_Date] DEFAULT (getdate()) FOR [Forum_Vote_Date]
GO

 CREATE  INDEX [Forum_Info_Times_Index] ON [dbo].[Forum_Info]([Forum_Info_Times] DESC , [Forum_Info_BoardId] DESC ) ON [PRIMARY]
GO

 CREATE  INDEX [Forum_Info_RootId_Index] ON [dbo].[Forum_Info]([Forum_Info_RootId] DESC ) ON [PRIMARY]
GO