GO
CREATE TABLE [dbo].[ZL_Page](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Proname] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
 [PageTitle] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
 [KeyWords] [nvarchar](1000) COLLATE Chinese_PRC_CI_AS NULL,
 [Description] [nvarchar](2000) COLLATE Chinese_PRC_CI_AS NULL,
 [LOGO] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
 [Domain] [nvarchar](500) COLLATE Chinese_PRC_CI_AS NULL,
 [Style] [int] NULL,
 [HeadHeight] [int] NULL,
 [HeadColor] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
 [CommonModelID] [int] NOT NULL,
 [TableName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
 [Hits] [int] NULL,
 [InfoID] [int] NOT NULL,
 [Best] [int] NULL CONSTRAINT [DF_ZL_Page_Best]  DEFAULT (0),
 [Status] [int] NULL,
 [UserID] [int] NULL,
 [UserName] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
 [ParentPageID] [int] NULL,
 [ParentUserID] [int] NULL,
 [PageInfo] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
 [TopWords] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
 [BottonWords] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
 [CreateTime] [datetime] NULL,
 [NodeStyle] [int] NULL CONSTRAINT [DF_ZL_Page_NodeStyle]  DEFAULT (0),
 [HeadBackGround] [nvarchar](255) COLLATE Chinese_PRC_CI_AS NULL,
 CONSTRAINT [PK_ZL_Page] PRIMARY KEY CLUSTERED
(
 [ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'企业名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Proname'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'黄页标题' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'PageTitle'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'KeyWords'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Description'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'LOGO' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'LOGO'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'访问域名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Domain'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'风格' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Style'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'导航条高度' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'HeadHeight'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'导航条颜色' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'HeadColor'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'ZL_CommonModel中的ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'CommonModelID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'模型名称' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'TableName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'点击数' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Hits'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'模型内容ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'InfoID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'推荐级别' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Best'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'审核状态' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'Status'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'UserID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'UserName'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'上级黄页ID(上级商铺)' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'ParentPageID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'上级用户ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'ParentUserID'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'黄页说明' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'PageInfo'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'头部自定义HTML内容' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'TopWords'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'底部HTML内容' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'BottonWords'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'节点样式' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'NodeStyle'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'导航背景' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Page', @level2type=N'COLUMN',@level2name=N'HeadBackGround'