dxbbs

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_BoardTopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DXBBS_BoardTopicProc] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_BoardTopTopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DXBBS_BoardTopTopicProc] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_CommonProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DXBBS_CommonProc] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DXBBS_TopicProc]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[DXBBS_TopicProc] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_Advertisement]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[$TablePrefix_Forum_Advertisement] CREATE TABLE [dbo].[$TablePrefix_Forum_Advertisement]( [ID] [int] IDENTITY(1,1) NOT NULL, [Title] [nchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [IsUsing] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Advertisement_IsUsing] DEFAULT ((0)), [Orders] [int] NULL, [AddTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Advertisement_AddTime] DEFAULT (getdate()), CONSTRAINT [PK_$TablePrefix_Forum_Advertisement] PRIMARY KEY CLUSTERED ( [ID] ASC ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_Board]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[$TablePrefix_Forum_Board] CREATE TABLE [dbo].[$TablePrefix_Forum_Board]( [ID] [int] NOT NULL, [FatherID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_FatherID] DEFAULT ((0)), [FatherPath] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Depth] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_Depth] DEFAULT ((0)), [RootID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_RootID] DEFAULT ((0)), [ChildNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildNum] DEFAULT ((0)), [Orders] [int] NULL, [ChildOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildOrderType] DEFAULT ((0)), [ChildLineNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ChildLineNum] DEFAULT ((0)), [BoardName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [AllowTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_AllowTopic] DEFAULT ((0)), [ShowType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ShowType] DEFAULT ((0)), [NeedConfirm] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_NeedConfirm] DEFAULT ((0)), [Locked] [int] NULL, [TitleColor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [BoardRule] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [Master] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL, [MasterID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL, [Photo] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL, [Logo] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [TopicCount] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TopicCount] DEFAULT ((0)), [TotalTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TotalTopic] DEFAULT ((0)), [TotalReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TotalReply] DEFAULT ((0)), [TodayTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TodayTopic] DEFAULT ((0)), [TodayReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TodayReply] DEFAULT ((0)), [ActiveBoardID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveBoardID] DEFAULT ((0)), [ActiveTopicID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveTopicID] DEFAULT ((0)), [ActiveTopicTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [ActiveUser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [ActiveUserID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveUserID] DEFAULT ((0)), [ActiveTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ActiveTime] DEFAULT (getdate()), [LevelID] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [TeamID] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [PowerType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_PowerType] DEFAULT ((0)), [TopicOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TopicOrderType] DEFAULT ((0)), [TopicPerPage] [int] NULL, [ReplyPerPage] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_ReplyPerPage] DEFAULT ((0)), [TemplateID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_TemplateID] DEFAULT ((0)), [SkinID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_SkinID] DEFAULT ((0)), [AddTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_Board_AddTime] DEFAULT (getdate()) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[$TablePrefix_Forum_BoardRecycle]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[$TablePrefix_Forum_BoardRecycle] CREATE TABLE [dbo].[$TablePrefix_Forum_BoardRecycle]( [ID] [int] NOT NULL, [FatherID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_FatherID] DEFAULT ((0)), [FatherPath] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [Depth] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_Depth] DEFAULT ((0)), [RootID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_RootID] DEFAULT ((0)), [ChildNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildNum] DEFAULT ((0)), [Orders] [int] NULL, [ChildOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildOrderType] DEFAULT ((0)), [ChildLineNum] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ChildLineNum] DEFAULT ((0)), [BoardName] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [AllowTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_AllowTopic] DEFAULT ((0)), [ShowType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ShowType] DEFAULT ((0)), [NeedConfirm] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_NeedConfirm] DEFAULT ((0)), [Locked] [int] NULL, [TitleColor] [nvarchar](10) COLLATE Chinese_PRC_CI_AS NULL, [Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [BoardRule] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [Master] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL, [MasterID] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL, [Photo] [nvarchar](250) COLLATE Chinese_PRC_CI_AS NULL, [Logo] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [TopicCount] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TopicCount] DEFAULT ((0)), [TotalTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TotalTopic] DEFAULT ((0)), [TotalReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TotalReply] DEFAULT ((0)), [TodayTopic] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TodayTopic] DEFAULT ((0)), [TodayReply] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TodayReply] DEFAULT ((0)), [ActiveBoardID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveBoardID] DEFAULT ((0)), [ActiveTopicID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveTopicID] DEFAULT ((0)), [ActiveTopicTitle] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [ActiveUser] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL, [ActiveUserID] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveUserID] DEFAULT ((0)), [ActiveTime] [datetime] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_ActiveTime] DEFAULT (getdate()), [LevelID] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [TeamID] [ntext] COLLATE Chinese_PRC_CI_AS NULL, [PowerType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_PowerType] DEFAULT ((0)), [TopicOrderType] [int] NULL CONSTRAINT [DF_$TablePrefix_Forum_BoardRecycle_TopicOrderType]