table.sql

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

/****** Object:  Trigger dbo.Trig_Forum_BookMarks    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Trig_Forum_BookMarks]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Trig_Forum_BookMarks]
GO

/****** Object:  Trigger dbo.Trig_Forum_Info    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Trig_Forum_Info]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[Trig_Forum_Info]
GO

/****** Object:  Table [dbo].[Address]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Address]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Address]
GO

/****** Object:  Table [dbo].[Forum_Admin]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Admin]
GO

/****** Object:  Table [dbo].[Forum_BBSNews]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_BBSNews]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_BBSNews]
GO

/****** Object:  Table [dbo].[Forum_Board]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Board]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Board]
GO

/****** Object:  Table [dbo].[Forum_BookMarks]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_BookMarks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_BookMarks]
GO

/****** Object:  Table [dbo].[Forum_Class]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Class]
GO

/****** Object:  Table [dbo].[Forum_Code]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Code]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Code]
GO

/****** Object:  Table [dbo].[Forum_Config]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Config]
GO

/****** Object:  Table [dbo].[Forum_Friend]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Friend]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Friend]
GO

/****** Object:  Table [dbo].[Forum_Info]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Info]
GO

/****** Object:  Table [dbo].[Forum_Info_Offline]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Info_Offline]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Info_Offline]
GO

/****** Object:  Table [dbo].[Forum_Link]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Link]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Link]
GO

/****** Object:  Table [dbo].[Forum_Mail]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Mail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Mail]
GO

/****** Object:  Table [dbo].[Forum_Online]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Online]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Online]
GO

/****** Object:  Table [dbo].[Forum_SmallPaper]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_SmallPaper]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_SmallPaper]
GO

/****** Object:  Table [dbo].[Forum_Sms]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Sms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Sms]
GO

/****** Object:  Table [dbo].[Forum_Users]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Users]
GO

/****** Object:  Table [dbo].[Forum_Users_Class]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Users_Class]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Users_Class]
GO

/****** Object:  Table [dbo].[Forum_Users_Config]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Users_Config]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Users_Config]
GO

/****** Object:  Table [dbo].[Forum_Vote]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_Vote]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_Vote]
GO

/****** Object:  Table [dbo].[Forum_VoteUser]    Script Date: 2002-12-14 15:27:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum_VoteUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum_VoteUser]
GO

/****** Object:  Table [dbo].[Address]    Script Date: 2002-12-14 15:27:33 ******/
CREATE TABLE [dbo].[Address] (
	[ip1] [float] NULL ,
	[ip2] [float] NULL ,
	[country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[city] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Admin]    Script Date: 2002-12-14 15:27:33 ******/
CREATE TABLE [dbo].[Forum_Admin] (
	[Forum_Admin_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Admin_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Admin_Pwd] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_BBSNews]    Script Date: 2002-12-14 15:27:33 ******/
CREATE TABLE [dbo].[Forum_BBSNews] (
	[Forum_BBSNews_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_BBSNews_Title] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_BBSNews_Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_BBSNews_UserName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_BBSNews_AddTime] [datetime] NULL ,
	[Forum_BBSNews_BoardID] [int] NULL ,
	[isdel] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Board]    Script Date: 2002-12-14 15:27:34 ******/
CREATE TABLE [dbo].[Forum_Board] (
	[Forum_Board_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Board_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Class_Id] [int] NULL ,
	[Forum_Board_Mark] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_Admin] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_PicUrl] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_Hidden] [int] NULL ,
	[Forum_Board_Users] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_Class] [int] NULL ,
	[Forum_Board_Post] [int] NULL ,
	[Forum_Board_Repost] [int] NULL ,
	[Forum_Board_LastPostId] [int] NULL ,
	[Forum_Board_LastPostTitle] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_LastPostUsers] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_LastPostDate] [datetime] NULL ,
	[Forum_Board_TaxisNo] [int] NULL ,
	[Forum_Board_AttachPath] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_AttachSize] [int] NULL ,
	[Forum_Board_AttachType] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Board_AttachVirtualPath] [nvarchar] (255) 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_BookMarks]    Script Date: 2002-12-14 15:27:34 ******/
CREATE TABLE [dbo].[Forum_BookMarks] (
	[Forum_BookMark_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_BookMark_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_BookMark_Des] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_Id] [int] NULL ,
	[Forum_Board_Id] [int] NULL ,
	[Forum_User_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_BookMark_Time] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Class]    Script Date: 2002-12-14 15:27:34 ******/
CREATE TABLE [dbo].[Forum_Class] (
	[Forum_Class_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Class_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Class_TaxisNo] [int] NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Code]    Script Date: 2002-12-14 15:27:34 ******/
CREATE TABLE [dbo].[Forum_Code] (
	[Forum_Code_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Code_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Code_Color] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isdel] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Config]    Script Date: 2002-12-14 15:27:35 ******/
CREATE TABLE [dbo].[Forum_Config] (
	[Forum_Config_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Config_Model] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Url] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Logo] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_BadWords] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Timezone] [int] NULL ,
	[Forum_Config_ListPagesize] [int] NULL ,
	[Forum_Config_ViewPageSize] [int] NULL ,
	[Forum_Config_IpView] [int] NULL ,
	[Forum_Config_Sms] [int] NULL ,
	[Forum_Config_Sound] [int] NULL ,
	[Forum_Config_TableBgcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_TableFontcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_HeadBgcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_HeadFontcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_BodyBgcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_BodyFontcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_AlertBgcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_AlertFontcolor] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Postnew] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Votenew] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Postold] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_SmallPaper] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Config_Active] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Friend]    Script Date: 2002-12-14 15:27:35 ******/
CREATE TABLE [dbo].[Forum_Friend] (
	[Forum_Friend_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Friend_Users] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Friend_Name] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Friend_InputDate] [datetime] NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Info]    Script Date: 2002-12-14 15:27:35 ******/
CREATE TABLE [dbo].[Forum_Info] (
	[Forum_Info_Id] [int] IDENTITY (1, 1) NOT NULL ,
	[Forum_Info_BoardId] [int] NULL ,
	[Forum_Info_ParentId] [int] NULL ,
	[Forum_Info_RootId] [int] NULL ,
	[Forum_Info_Times] [int] NULL ,
	[Forum_Info_Users] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_IsTop] [int] NULL ,
	[Forum_Info_IsLock] [int] NULL ,
	[Forum_Info_IsGood] [int] NULL ,
	[Forum_Info_IsVote] [int] NULL ,
	[Forum_Info_VoteId] [int] NULL ,
	[Forum_Info_Pic] [int] NULL ,
	[Forum_Info_Title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_Body] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_InputDate] [datetime] NULL ,
	[Forum_Info_Hit] [int] NULL ,
	[Forum_Info_Revert] [int] NULL ,
	[Forum_Info_RevertDate] [datetime] NULL ,
	[Forum_Info_RevertUsers] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_Ip] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum_Info_Exp] [int] NULL ,
	[Forum_Info_Lns] [int] NULL ,
	[Forum_Info_IsRe] [int] NULL ,
	[Forum_Info_IsMail] [int] NULL ,
	[Isdel] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Forum_Info_Offline]    Script Date: 2002-12-14 15:27:36 ******/