PlugNT CMS内容管理系统v2.0(开源)

/****** 对象: 表 [dbo].[cms_article] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_article]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_article] GO /****** 对象: 表 [dbo].[cms_atcategory] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_atcategory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_atcategory] GO /****** 对象: 表 [dbo].[cms_fdkclass] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_fdkclass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_fdkclass] GO /****** 对象: 表 [dbo].[cms_friendlink] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_friendlink]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_friendlink] GO /****** 对象: 表 [dbo].[cms_groupadmin] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_groupadmin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_groupadmin] GO /****** 对象: 表 [dbo].[cms_grouppages] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_grouppages]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_grouppages] GO /****** 对象: 表 [dbo].[cms_user] 脚本日期: 2010-7-13 16:30:43 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[cms_user]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[cms_user] GO /****** 对象: 表 [dbo].[cms_article] 脚本日期: 2010-7-13 16:30:43 ******/ CREATE TABLE [dbo].[cms_article] ( [id] [int] IDENTITY (1, 1) NOT NULL , [no] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [pic] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [title] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [subtitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [keyword] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [description] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [clsno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [clslist] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [contents] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [jumpurl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [author] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [url] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [tip] [int] NULL , [tag] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [hits] [int] NULL , [orders] [int] NULL , [commend] [bit] NOT NULL , [stick] [bit] NOT NULL , [publish] [bit] NOT NULL , [switchs] [int] NULL , [addtime] [smalldatetime] NULL , [createpath] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [pagename] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** 对象: 表 [dbo].[cms_atcategory] 脚本日期: 2010-7-13 16:30:44 ******/ CREATE TABLE [dbo].[cms_atcategory] ( [id] [int] IDENTITY (1, 1) NOT NULL , [clsno] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [clsname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [clstag] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [clslist] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [clsparentno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [clslistlen] [int] NULL , [clsorder] [float] NULL , [indexfile] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [listfile] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [showfile] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL , [createpath] [nvarchar] (250) COLLATE Chinese_PRC_CI_AS NULL , [ismap] [smallint] NULL , [description] [ntext] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** 对象: 表 [dbo].[cms_fd�