表名：ZL_AdZone

序号列名数据类型长度小数位标识主键外键允许空默认值说明
1ZoneIDint40是是 否 广告版位ID
2ZoneNamenvarchar1000   是 广告版位名称
3ZoneJSNamenvarchar1000   是 JS文件名
4ZoneIntronvarchar2550   是 版位介绍
5ZoneTypeint40   是0版位类型
6DefaultSettingbit10   否1是否默认设置
7ZoneSettingnvarchar2550   是 具体自定义设置信息
8ZoneWidthint40   是0版位宽度
9ZoneHeightint40   是0版位高度
10Activebit10   否0是否活动
11ShowTypeint40   是0显示方式
12UpdateTimedatetime83   否getdate创建时间
13Salesint40   否 是否开放用户申请

简要说明：

广告模型表

GO
CREATE TABLE [dbo].[ZL_AdZone](
[ZoneID] [int] IDENTITY(1,1) NOT NULL,
[ZoneName] [nvarchar](100) NULL,
[ZoneJSName] [nvarchar](100) NULL,
[ZoneIntro] [nvarchar](255) NULL,
[ZoneType] [int] NULL CONSTRAINT [DF_ZL_AdZone_ZoneType]  DEFAULT (0),
[DefaultSetting] [bit] NOT NULL CONSTRAINT [DF_ZL_AdZone_DefaultSetting]  DEFAULT (1),
[ZoneSetting] [nvarchar](255) NULL,
[ZoneWidth] [int] NULL CONSTRAINT [DF_ZL_AdZone_ZoneWidth]  DEFAULT (0),
[ZoneHeight] [int] NULL CONSTRAINT [DF_ZL_AdZone_ZoneHeight]  DEFAULT (0),
[Active] [bit] NOT NULL CONSTRAINT [DF_ZL_AdZone_Active]  DEFAULT (0),
[ShowType] [int] NULL CONSTRAINT [DF_ZL_AdZone_ShowType]  DEFAULT (0),
[UpdateTime] [datetime] NOT NULL CONSTRAINT [DF_ZL_AdZone_UpdateTime]  DEFAULT (getdate()),
[Sales] [int] NOT NULL,
CONSTRAINT [PK_ZL_AdZone] PRIMARY KEY CLUSTERED
([ZoneID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'JS文件名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneJSName'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版位介绍' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneIntro'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版位类型' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否默认设置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'DefaultSetting'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'具体自定义设置信息' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneSetting'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版位宽度' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneWidth'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'版位高度' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ZoneHeight'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否活动' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'Active'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'显示方式' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'ShowType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_AdZone', @level2type=N'COLUMN', @level2name=N'UpdateTime'


--注意：将清空全表数据

detele from ZL_AdZone

--注意：将删除整个表

drop table ZL_AdZone

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_AdZone