程序源码 主智CMS企业建站系统 v3.0 Build 090722_zhuzhicms（ASP.NET源码）.rar

/****** Object: Table [dbo].[UserRole] Script Date: 2009-7-10 19:03:37 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserRole]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UserRole] GO CREATE TABLE [dbo].[UserRole] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NameC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_UserRole] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] GO GRANT SELECT ON [dbo].[UserRole] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'UserRole', N'column', N'ID' GO exec sp_addextendedproperty N'MS_Description', N'角色名', N'user', N'dbo', N'table', N'UserRole', N'column', N'Name' GO exec sp_addextendedproperty N'MS_Description', N'中文角色名', N'user', N'dbo', N'table', N'UserRole', N'column', N'NameC' GO /****** Object: Table [dbo].[UserFlag] Script Date: 2009-7-10 19:03:36 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserFlag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[UserFlag] GO CREATE TABLE [dbo].[UserFlag] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NameC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_UserFlag] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] GO GRANT SELECT ON [dbo].[UserFlag] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'UserFlag', N'column', N'ID' GO /****** Object: Table [dbo].[Sex] Script Date: 2009-7-10 19:03:35 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sex]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Sex] GO CREATE TABLE [dbo].[Sex] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NameC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_Sex] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] GO GRANT SELECT ON [dbo].[Sex] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'Sex', N'column', N'ID' GO /****** Object: Table [dbo].[TopicStatus] Script Date: 2009-7-10 19:03:36 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TopicStatus]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TopicStatus] GO CREATE TABLE [dbo].[TopicStatus] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NameC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [Description] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [DescriptionC] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [IconName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_TopicStatus] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] GO GRANT SELECT ON [dbo].[TopicStatus] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'TopicStatus', N'column', N'ID' GO /****** Object: Table [dbo].[Topic] Script Date: 2009-7-10 19:03:36 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Topic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Topic] GO CREATE TABLE [dbo].[Topic] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ForumID] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [TopicStatus] [int] NULL CONSTRAINT [DF_Topic_TopicStatus] DEFAULT (1), [User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [PostTime] [datetime] NULL , [Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL , [Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [Hit] [int] NULL CONSTRAINT [DF_Topic_Hit] DEFAULT (0), [AttachmentName] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_Topic] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[Topic] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'附件路径，由于 URL 可能很长，所以取 2000', N'user', N'dbo', N'table', N'Topic', N'column', N'AttachmentName' GO exec sp_addextendedproperty N'MS_Description', N'内容，最多 3500 汉字', N'user', N'dbo', N'table', N'Topic', N'column', N'Content' GO exec sp_addextendedproperty N'MS_Description', N'论坛编号（来自 menu.xml），使用数字', N'user', N'dbo', N'table', N'Topic', N'column', N'ForumID' GO exec sp_addextendedproperty N'MS_Description', N'点击次数，每次运行 SP TopicSelect，该值都++', N'user', N'dbo', N'table', N'Topic', N'column', N'Hit' GO exec sp_addextendedproperty N'MS_Description', N'发表时间', N'user', N'dbo', N'table', N'Topic', N'column', N'PostTime' GO exec sp_addextendedproperty N'MS_Description', N'标题，最多 200 汉字', N'user', N'dbo', N'table', N'Topic', N'column', N'Title' GO exec sp_addextendedproperty N'MS_Description', N'主题状态，却省为 1 （空主题）', N'user', N'dbo', N'table', N'Topic', N'column', N'TopicStatus' GO exec sp_addextendedproperty N'MS_Description', N'用户 ID', N'user', N'dbo', N'table', N'Topic', N'column', N'User' GO /****** Object: Table [dbo].[FollowUp] Script Date: 2009-7-10 19:03:33 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FollowUp]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[FollowUp] GO CREATE TABLE [dbo].[FollowUp] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [TopicID] [int] NULL , [User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [PostTime] [datetime] NULL , [Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL , [AttachmentName] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_Message] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO GRANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[FollowUp] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'附件路径，由于 URL 可能很长，所以取 2000', N'user', N'dbo', N'table', N'FollowUp', N'column', N'AttachmentName' GO exec sp_addextendedproperty N'MS_Description', N'帖子内容，使用 ntext ，不限长度', N'user', N'dbo', N'table', N'FollowUp', N'column', N'Content' GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'FollowUp', N'column', N'ID' GO exec sp_addextendedproperty N'MS_Description', N'发帖时间', N'user', N'dbo', N'table', N'FollowUp', N'column', N'PostTime' GO exec sp_addextendedproperty N'MS_Description', N'主题 ID', N'user', N'dbo', N'table', N'FollowUp', N'column', N'TopicID' GO exec sp_addextendedproperty N'MS_Description', N'帖子用户', N'user', N'dbo', N'table', N'FollowUp', N'column', N'User' GO /****** Object: Table [dbo].[KeywordFlag] Script Date: 2009-7-10 19:03:33 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KeywordFlag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[KeywordFlag] GO CREATE TABLE [dbo].[KeywordFlag] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [NameC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL , CONSTRAINT [PK_KeywordFlag] PRIMARY KEY CLUSTERED ( [ID] ) ON [PRIMARY] ) ON [PRIMARY] GO GRANT SELECT ON [dbo].[KeywordFlag] TO [public] GO exec sp_addextendedproperty N'MS_Description', N'自动增长', N'user', N'dbo', N'table', N'KeywordFlag', N'column', N'ID' GO /****** Object: Table [dbo].[MainDirectoryContent] Script Date: 2009-7-10 19:03:34 ******/ if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MainDirectoryContent]') and OBJECTPR