/****** 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 OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MainDirectoryContent]
GO

CREATE TABLE [dbo].[MainDirectoryContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MainDirectoryID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageHeader] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PageFooter] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_MainDirectoryContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_MainDirectory_ID] ON [dbo].[MainDirectoryContent]([MainDirectoryID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[MainDirectoryContent]  TO [public]
GO


/****** Object:  Table [dbo].[SubDirectoryContent]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SubDirectoryContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SubDirectoryContent]
GO

CREATE TABLE [dbo].[SubDirectoryContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SubDirectoryID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[WizardPreviousTitle] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[WizardNextTitle] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageHeader] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PageFooter] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_SubDirectoryContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_SubDirectory_ID] ON [dbo].[SubDirectoryContent]([SubDirectoryID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[SubDirectoryContent]  TO [public]
GO


/****** Object:  Table [dbo].[CommunityContent]    Script Date: 2009-7-10 19:03:33 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CommunityContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CommunityContent]
GO

CREATE TABLE [dbo].[CommunityContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[CommunityID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_CommunityContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Community_ID] ON [dbo].[CommunityContent]([CommunityID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[CommunityContent]  TO [public]
GO


/****** Object:  Table [dbo].[ForumContent]    Script Date: 2009-7-10 19:03:33 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ForumContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ForumContent]
GO

CREATE TABLE [dbo].[ForumContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ForumID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleTaskList] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleTaskListDescription] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleAdd] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleAddDescription] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleQuery] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommandTitleQueryDescription] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_ForumContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Forum_ID] ON [dbo].[ForumContent]([ForumID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[ForumContent]  TO [public]
GO


/****** Object:  Table [dbo].[UserForums]    Script Date: 2009-7-10 19:03:36 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserForums]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserForums]
GO

CREATE TABLE [dbo].[UserForums] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Forum] [int] NULL ,
	[ReadEnabled] [int] NULL ,
	[TopicWriteEnabled] [int] NULL ,
	[FollowUpWriteEnabled] [int] NULL ,
	CONSTRAINT [PK_UserForums] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[UserForums]  TO [public]
GO


/****** Object:  Table [dbo].[OptionContent]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[OptionContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[OptionContent]
GO

CREATE TABLE [dbo].[OptionContent] (
	[ID] [int] NULL ,
	[OptionID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[CatTitle] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (3000) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Option_ID] ON [dbo].[OptionContent]([OptionID]) ON [PRIMARY]
GO

 CREATE  INDEX [IX_OptionContent_ID] ON [dbo].[OptionContent]([ID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[OptionContent]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'ı', N'user', N'dbo', N'table', N'OptionContent', N'column', N'CatTitle'
GO
exec sp_addextendedproperty N'MS_Description', N'Ļ', N'user', N'dbo', N'table', N'OptionContent', N'column', N'Culture'
GO
exec sp_addextendedproperty N'MS_Description', N'ı', N'user', N'dbo', N'table', N'OptionContent', N'column', N'Description'
GO
exec sp_addextendedproperty N'MS_Description', N'Ӧ Option ¼ ID', N'user', N'dbo', N'table', N'OptionContent', N'column', N'OptionID'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'OptionContent', N'column', N'Title'


GO


/****** Object:  Table [dbo].[Forum]    Script Date: 2009-7-10 19:03:33 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Forum]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Forum]
GO

CREATE TABLE [dbo].[Forum] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[CommunityID] [int] NULL ,
	[Serial] [int] NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Moderator] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Public] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Forum] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Forum]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'Ӧ Community  ID', N'user', N'dbo', N'table', N'Forum', N'column', N'CommunityID'
GO
exec sp_addextendedproperty N'MS_Description', N'Զ', N'user', N'dbo', N'table', N'Forum', N'column', N'ID'
GO
exec sp_addextendedproperty N'MS_Description', N'̳б "lily,cici,35"', N'user', N'dbo', N'table', N'Forum', N'column', N'Moderator'
GO
exec sp_addextendedproperty N'MS_Description', N'ǰ Forum Ƿ񹫹 Forum ', N'user', N'dbo', N'table', N'Forum', N'column', N'Public'
GO
exec sp_addextendedproperty N'MS_Description', N' Serial Ŀڽеʾ', N'user', N'dbo', N'table', N'Forum', N'column', N'Serial'


GO


/****** Object:  Table [dbo].[UniqueNumber]    Script Date: 2009-7-10 19:03:36 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UniqueNumber]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UniqueNumber]
GO

CREATE TABLE [dbo].[UniqueNumber] (
	[Number] [int] NOT NULL 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[UniqueNumber]  TO [public]
GO


/****** Object:  Table [dbo].[KnowledgeComments]    Script Date: 2009-7-10 19:03:33 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KnowledgeComments]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KnowledgeComments]
GO

CREATE TABLE [dbo].[KnowledgeComments] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[KnowledgeContentID] [int] NULL ,
	[CommentsTime] [datetime] NULL ,
	[CommentsUser] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CommentsContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_KnowledgeComments] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_KnowledgeContent_ID] ON [dbo].[KnowledgeComments]([KnowledgeContentID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[KnowledgeComments]  TO [public]
GO


/****** Object:  Table [dbo].[Community]    Script Date: 2009-7-10 19:03:32 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Community]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Community]
GO

CREATE TABLE [dbo].[Community] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Serial] [int] NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[InActiveMainMenuIconMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ActiveMainMenuIconMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerContentLayer] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Community] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Community]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Community', N'column', N'ActiveMainMenuIconMap'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Community', N'column', N'BannerMap'
GO
exec sp_addextendedproperty N'MS_Description', N'Զ', N'user', N'dbo', N'table', N'Community', N'column', N'ID'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Community', N'column', N'InActiveMainMenuIconMap'
GO
exec sp_addextendedproperty N'MS_Description', N' Serial Ŀڽгִ', N'user', N'dbo', N'table', N'Community', N'column', N'Serial'


GO


/****** Object:  Table [dbo].[SeaParameter]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SeaParameter]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SeaParameter]
GO

CREATE TABLE [dbo].[SeaParameter] (
	[ID] [int] NOT NULL ,
	[Parameter] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Value] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_SeaParameter] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT  ON [dbo].[SeaParameter]  TO [public]
GO


/****** Object:  Table [dbo].[KnowledgeTags]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KnowledgeTags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KnowledgeTags]
GO

CREATE TABLE [dbo].[KnowledgeTags] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[KnowledgeContentID] [int] NULL ,
	[Tag] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_KnowledgeTags] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_KnowledgeContent_ID] ON [dbo].[KnowledgeTags]([KnowledgeContentID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[KnowledgeTags]  TO [public]
GO


/****** Object:  Table [dbo].[SubDirectory]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SubDirectory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SubDirectory]
GO

CREATE TABLE [dbo].[SubDirectory] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[MainDirectoryID] [int] NULL ,
	[Serial] [int] NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[UseBaseUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewWindow] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Overview] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Wizard] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Editor] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DedicatedTo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CommentsPermission] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_SubDirectory] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[SubDirectory]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N' New WindowΪ "true"Ϊ "false"', N'user', N'dbo', N'table', N'SubDirectory', N'column', N'NewWindow'
GO
exec sp_addextendedproperty N'MS_Description', N'кԽԽں', N'user', N'dbo', N'table', N'SubDirectory', N'column', N'Serial'
GO
exec sp_addextendedproperty N'MS_Description', N' Base UrlΪ "true"Ϊ "false"', N'user', N'dbo', N'table', N'SubDirectory', N'column', N'UseBaseUrl'


GO


/****** Object:  Table [dbo].[PageDirectoryContent]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PageDirectoryContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PageDirectoryContent]
GO

CREATE TABLE [dbo].[PageDirectoryContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PageDirectoryID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[SeoTitle] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[SeoDescription] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[SeoKeywords] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Description] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageHeader] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[PageFooter] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_PageDirectoryContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_PageDirectory_ID] ON [dbo].[PageDirectoryContent]([PageDirectoryID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[PageDirectoryContent]  TO [public]
GO


/****** Object:  Table [dbo].[Option]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Option]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Option]
GO

CREATE TABLE [dbo].[Option] (
	[ID] [int] NULL ,
	[Cat] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightIndent] [int] NULL CONSTRAINT [Option_Default_Constraint] DEFAULT (0),
	[Key] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Value] [nvarchar] (3000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Legend] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NumberOnly] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[TextArea] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MultiCulture] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ForTheme] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Validation] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Option_ID] ON [dbo].[Option]([ID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Option]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'ǰڵ Cat', N'user', N'dbo', N'table', N'Option', N'column', N'Cat'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Option', N'column', N'Key'
GO
exec sp_addextendedproperty N'MS_Description', N'һһ򼸸ĸʾǰ Option  Cat ʾͼеλá', N'user', N'dbo', N'table', N'Option', N'column', N'Legend'
GO
exec sp_addextendedproperty N'MS_Description', N'true/false', N'user', N'dbo', N'table', N'Option', N'column', N'NumberOnly'
GO
exec sp_addextendedproperty N'MS_Description', N'true/false', N'user', N'dbo', N'table', N'Option', N'column', N'TextArea'
GO
exec sp_addextendedproperty N'MS_Description', N'ֵ', N'user', N'dbo', N'table', N'Option', N'column', N'Value'


GO


/****** Object:  Table [dbo].[Users]    Script Date: 2009-7-10 19:03:37 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Users]
GO

CREATE TABLE [dbo].[Users] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Password] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[FirstName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LastName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Sex] [int] NULL ,
	[Tel] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Email] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Organization] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Remark] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[RegisterDate] [datetime] NULL ,
	[UserRole] [int] NULL ,
	CONSTRAINT [PK_Users] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Users]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'ʼ', N'user', N'dbo', N'table', N'Users', N'column', N'Email'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Users', N'column', N'FirstName'
GO
exec sp_addextendedproperty N'MS_Description', N'Զ', N'user', N'dbo', N'table', N'Users', N'column', N'ID'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'Users', N'column', N'LastName'
GO
exec sp_addextendedproperty N'MS_Description', N'û', N'user', N'dbo', N'table', N'Users', N'column', N'Name'
GO
exec sp_addextendedproperty N'MS_Description', N'룬ʽ', N'user', N'dbo', N'table', N'Users', N'column', N'Password'
GO
exec sp_addextendedproperty N'MS_Description', N'Ա', N'user', N'dbo', N'table', N'Users', N'column', N'Sex'
GO
exec sp_addextendedproperty N'MS_Description', N'绰', N'user', N'dbo', N'table', N'Users', N'column', N'Tel'
GO
exec sp_addextendedproperty N'MS_Description', N'ɫ - Admin, Community', N'user', N'dbo', N'table', N'Users', N'column', N'UserRole'


GO


/****** Object:  Table [dbo].[Knowledge]    Script Date: 2009-7-10 19:03:33 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Knowledge]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Knowledge]
GO

CREATE TABLE [dbo].[Knowledge] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PageDirectoryID] [int] NULL ,
	[Serial] [int] NULL ,
	[Editor] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DedicatedTo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CommentsPermission] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[UpdateTime] [datetime] NULL ,
	[Author] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Knowledge] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_Knowledge_Cat] ON [dbo].[Knowledge]([PageDirectoryID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Knowledge]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'Щûۣ , ûбȫעûۣʹá*κη߶ۣʹַ nullκۣʹánone.', N'user', N'dbo', N'table', N'Knowledge', N'column', N'CommentsPermission'
GO
exec sp_addextendedproperty N'MS_Description', N'רΪЩû׼"," ûȫעûߣá*ʹÿַ null', N'user', N'dbo', N'table', N'Knowledge', N'column', N'DedicatedTo'
GO
exec sp_addextendedproperty N'MS_Description', N'൱ ActivePageMenuName', N'user', N'dbo', N'table', N'Knowledge', N'column', N'PageDirectoryID'
GO
exec sp_addextendedproperty N'MS_Description', N'кԽԽں', N'user', N'dbo', N'table', N'Knowledge', N'column', N'Serial'


GO


/****** Object:  Table [dbo].[MainDirectory]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MainDirectory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MainDirectory]
GO

CREATE TABLE [dbo].[MainDirectory] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[Serial] [int] NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[UseBaseUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewWindow] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[System] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[InActiveMainMenuIconMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[ActiveMainMenuIconMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerMap] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerContentLayer] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Editor] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DedicatedTo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CommentsPermission] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_MainDirectory] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[MainDirectory]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'MainDirectory', N'column', N'ActiveMainMenuIconMap'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'MainDirectory', N'column', N'BannerMap'
GO
exec sp_addextendedproperty N'MS_Description', N'', N'user', N'dbo', N'table', N'MainDirectory', N'column', N'InActiveMainMenuIconMap'
GO
exec sp_addextendedproperty N'MS_Description', N'кţкԽģԽں', N'user', N'dbo', N'table', N'MainDirectory', N'column', N'Serial'
GO
exec sp_addextendedproperty N'MS_Description', N' System ˵Ϊ "true"Ϊ "false"', N'user', N'dbo', N'table', N'MainDirectory', N'column', N'System'


GO


/****** Object:  Table [dbo].[PageDirectory]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PageDirectory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PageDirectory]
GO

CREATE TABLE [dbo].[PageDirectory] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[SubDirectoryID] [int] NULL ,
	[Serial] [int] NULL ,
	[Name] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Url] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageSize] [int] NULL ,
	[UseBaseUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[NewWindow] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Overview] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[FastAccess] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Home] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RightIndent] [int] NULL CONSTRAINT [PageDirectory_Default_Constraint] DEFAULT (0),
	[jQuery] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[LogoHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[MainMenuHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BannerHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[BreadcrumbHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageMenuHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[PageBarHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[CopyrightHide] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Type] [int] NULL ,
	[Presentation] [int] NULL ,
	[ShowAuthor] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowUpdateTime] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowHitCount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowComments] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowStaticUrl] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowKnowledgeHtml] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ShowRelative] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Editor] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[DedicatedTo] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[CommentsPermission] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_PageDirectory] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[PageDirectory]  TO [public]
GO


exec sp_addextendedproperty N'MS_Description', N'Ƿٷб - true/false', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'FastAccess'
GO
exec sp_addextendedproperty N'MS_Description', N'ǷΪҳ - true/false', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'Home'
GO
exec sp_addextendedproperty N'MS_Description', N'Ƿ񵯳´ - true/false', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'NewWindow'
GO
exec sp_addextendedproperty N'MS_Description', N'ǰҳ Page Menu һҳ', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'PageMenuHide'
GO
exec sp_addextendedproperty N'MS_Description', N'֪ʶչʾʽ 1-ʾҳʾȫݣ    2-ֻʾ⣨ʾ⣬չʾݣ    3-ʾժҪʾժҪݣʾݣ', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'Presentation'
GO
exec sp_addextendedproperty N'MS_Description', N'кԽԽں', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'Serial'
GO
exec sp_addextendedproperty N'MS_Description', N'֪ʶͣ 1-֪ͨʶ   2-ʱ֪ʶ粩ͣŵ   3-ű֪ʶ Grossary,Faq,Ƹ', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'Type'
GO
exec sp_addextendedproperty N'MS_Description', N'Ƿʹû׼ Url - true/false', N'user', N'dbo', N'table', N'PageDirectory', N'column', N'UseBaseUrl'


GO


/****** Object:  Table [dbo].[Resources]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Resources]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Resources]
GO

CREATE TABLE [dbo].[Resources] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[LogicalPath] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[Tag] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_Resources] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[Resources]  TO [public]
GO


/****** Object:  Table [dbo].[ResourcesTags]    Script Date: 2009-7-10 19:03:35 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ResourcesTags]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ResourcesTags]
GO

CREATE TABLE [dbo].[ResourcesTags] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[ResourcesID] [int] NULL ,
	[Tag] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_ResourcesTags] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_Resources_ID] ON [dbo].[ResourcesTags]([ResourcesID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[ResourcesTags]  TO [public]
GO


/****** Object:  Table [dbo].[UserGroup]    Script Date: 2009-7-10 19:03:36 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserGroup]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserGroup]
GO

CREATE TABLE [dbo].[UserGroup] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[GroupName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[RegisterDefault] [int] NULL ,
	CONSTRAINT [PK_UserGroup] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[UserGroup]  TO [public]
GO


/****** Object:  Table [dbo].[UserGroups]    Script Date: 2009-7-10 19:03:36 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserGroups]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserGroups]
GO

CREATE TABLE [dbo].[UserGroups] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserGroupID] [int] NULL ,
	[User] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	CONSTRAINT [PK_UserGroups] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO

 CREATE  INDEX [IX_UserGroup_ID] ON [dbo].[UserGroups]([UserGroupID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[UserGroups]  TO [public]
GO


/****** Object:  Table [dbo].[KnowledgeContent]    Script Date: 2009-7-10 19:03:34 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[KnowledgeContent]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[KnowledgeContent]
GO

CREATE TABLE [dbo].[KnowledgeContent] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[KnowledgeID] [int] NULL ,
	[Culture] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[Template] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
	[Title] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL ,
	[TitleShow] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Content] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[Tag] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[Hidden] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Abstract] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
	[HitCount] [int] NULL ,
	CONSTRAINT [PK_KnowledgeContent] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

 CREATE  INDEX [IX_Knowledge_ID] ON [dbo].[KnowledgeContent]([KnowledgeID]) ON [PRIMARY]
GO

GRANT  SELECT ,  UPDATE ,  INSERT ,  DELETE  ON [dbo].[KnowledgeContent]  TO [public]
GO


