GO
CREATE TABLE [dbo].[ZL_Special](
[SpecID] [int] IDENTITY(1,1) NOT NULL,
[SpecName] [nvarchar](50) NOT NULL,
[SpecDir] [nvarchar](50) NOT NULL,
[SpecDesc] [nvarchar](255) NULL,
[OpenType] [bit] NULL CONSTRAINT [DF_ZL_Special_OpenType]  DEFAULT (0),
[SpecCate] [int] NOT NULL,
[ListFileExt] [int] NULL,
[ListTemplate] [nvarchar](255) NULL,
[ListFileRule] [int] NULL CONSTRAINT [DF_ZL_Special_ListFileRule]  DEFAULT (0),
[SpecDescriptive] [nvarchar] (255) NOT NULL,
[SpecKeyword] [nvarchar] (255) NOT NULL,
[SpecPicUrl] [nvarchar] (255) NOT NULL,
[SpecTips] [nvarchar] (255) NOT NULL,
[Pid] [int] NOT NULL,
[CDate] [datetime] NULL,
[CUser] [nvarchar](255) NULL,
[EditDate] [datetime] NULL,
[OrderID] [int] NULL,
CONSTRAINT [PK_ZL_Special] PRIMARY KEY CLUSTERED
(
[SpecID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题目录' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecDir'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecDesc'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'打开方式' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'OpenType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'所属专题类别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecCate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'扩展名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'ListFileExt'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'列表页模板' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'ListTemplate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'列表页文件名规则' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'ListFileRule'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'描述' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecDescriptive'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'关键字' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecKeyword'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题图片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecPicUrl'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专题提示' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Special', @level2type=N'COLUMN', @level2name=N'SpecTips'