表名:ZL_Pub












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Pubidint40  互动ID
2PubNamenvarchar2550    互动名称
3PubClassint40   0信息类别(0-内容 1-商城 2-黄页 3-店铺)
4PubTableNamenvarchar2550    互动数据表名
5PubTypeint40   0互动类型(0-评论 1-投票 2-活动 3-留言 4-问券调查 5-通用统计)
6PubOneOrMoreint40   0是否多条(0-无限制 1-每人限一条)
7PubIPOneOrMoreint40    重复IP提交信息次数
8PubTemplatenvarchar10000    模板地址
9PubLoadstrnvarchar10000    调用字符
10PubModelIDint40   0模型ID
11PubNodeIDnvarchar10000   0系统节点ID
12PubTemplateIDnvarchar10000   0黄页节点ID
13Pubinfontext160    说明
14PubIsTrueint40   0是否需要审核(0-不需要 1-需要审核)
15PubCodeint40   0是否需要验证码(0-不需要 1-需要)
16PubLoginint40   0是否需要登陆(0-不需要 1-需要)
17PubAddnumint40   0参与人数
18PubBindPubint40    绑定互动
19PubShowTypeint40   0投票显示方式(0-传统 1-柱状 2-圆形)
20PubInputTMnvarchar10000    提交窗口模板
21PubInputLoadStrnvarchar2550    调用提交窗口代码
22PubCreateTimedatetime83   getdate创建时间
23PubLoginUrlnvarchar2550    设置登陆地址
24PubOpenCommentint40    是否开启评论
25PubEndTimedatetime83    结束时间
26PubIsDelint40   0是否被删除 1-删除
27PubTimeSlotint40   10间隔时间,单位秒
28Pubkeepint40   7保留天数信息
29Puberrmsgnvarchar10000     
30PubGourlnvarchar10000    更新跳转地址
31PubSiteIDint40   0站点ID
32Publicint40   1公开
33PubPermissionsnvarchar2550    互动模块权限
34Intervalnvarchar200    投票间隔
35PubFlagint40    互动标识

简要说明:

互动模型表


GO
CREATE TABLE [dbo].[ZL_Pub](
[Pubid] [int] IDENTITY(1,1) NOT NULL,
[PubName] [nvarchar](255) NULL,
[PubClass] [int] NULL CONSTRAINT [DF_ZL_Pub_PubClass]  DEFAULT (0),
[PubTableName] [nvarchar](255) NULL,
[PubType] [int] NULL CONSTRAINT [DF_ZL_Pub_PubType]  DEFAULT (0),
[PubOneOrMore] [int] NULL CONSTRAINT [DF_ZL_Pub_PubOneOrMore]  DEFAULT (0),
[PubIPOneOrMore] [int] NULL,
[PubTemplate] [nvarchar](1000) NULL,
[PubLoadstr] [nvarchar](1000) NULL,
[PubModelID] [int] NULL CONSTRAINT [DF_ZL_Pub_PubModelID]  DEFAULT (0),
[PubNodeID] [nvarchar](1000) NULL CONSTRAINT [DF_ZL_Pub_PubNodeID]  DEFAULT (0),
[PubTemplateID] [nvarchar](1000) NULL CONSTRAINT [DF_ZL_Pub_PubTemplateID]  DEFAULT (0),
[Pubinfo] [ntext] NULL,
[PubIsTrue] [int] NULL CONSTRAINT [DF_ZL_Pub_PubIsTrue]  DEFAULT (0),
[PubCode] [int] NULL CONSTRAINT [DF_ZL_Pub_PubPubCode]  DEFAULT (0),
[PubLogin] [int] NULL CONSTRAINT [DF_ZL_Pub_PubNeedReg]  DEFAULT (0),
[PubAddnum] [int] NULL CONSTRAINT [DF_ZL_Pub_PubAddnum]  DEFAULT (0),
[PubBindPub] [int] NULL,
[PubShowType] [int] NULL CONSTRAINT [DF_ZL_Pub_PubShowType]  DEFAULT (0),
[PubInputTM] [nvarchar](1000) NULL,
[PubInputLoadStr] [nvarchar](255) NULL,
[PubCreateTime] [datetime] NULL CONSTRAINT [DF_ZL_Pub_PubCreateTime]  DEFAULT (getdate()),
[PubLoginUrl] [nvarchar](255) NULL,
[PubOpenComment] [int] NULL,
[PubEndTime] [datetime] NULL,
[PubIsDel] [int] NULL CONSTRAINT [DF_ZL_Pub_PubIsDel]  DEFAULT (0),
[PubTimeSlot] [int] NULL CONSTRAINT [DF_ZL_Pub_PubTimeSlot]  DEFAULT (10),
[Pubkeep] [int] NULL CONSTRAINT [DF_ZL_Pub_Pubkeep]  DEFAULT (7),
[Puberrmsg] [nvarchar](1000) NULL,
[PubGourl] [nvarchar](1000) NULL,
[PubSiteID] [int] NULL CONSTRAINT [DF_ZL_Pub_PubSiteID]  DEFAULT (0),
[Public] [int] NULL CONSTRAINT [DF_ZL_Pub_Public]  DEFAULT ((1)),
[PubPermissions] [nvarchar](255) NULL,
[Interval][nvarchar](20) NULL,
[PubFlag] [int] NULL,
 CONSTRAINT [PK_ZL_Pub] PRIMARY KEY CLUSTERED
(
[Pubid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubid'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'信息类别(0-内容 1-商城 2-黄页 3-店铺)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubClass'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动数据表名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTableName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'互动类型(0-评论 1-投票 2-活动 3-留言 4-问券调查 5-通用统计)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否多条(0-无限制 1-每人限一条)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubOneOrMore'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'重复IP提交信息次数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIPOneOrMore'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模板地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTemplate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调用字符' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLoadstr'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'模型ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubModelID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'系统节点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubNodeID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'黄页节点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTemplateID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubinfo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要审核(0-不需要 1-需要审核)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIsTrue'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要验证码(0-不需要 1-需要)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubCode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否需要登陆(0-不需要 1-需要)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLogin'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'参与人数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubAddnum'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'绑定互动' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubBindPub'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'投票显示方式(0-传统 1-柱状 2-圆形)' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubShowType'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提交窗口模板' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubInputTM'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'调用提交窗口代码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubInputLoadStr'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubCreateTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设置登陆地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubLoginUrl'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否开启评论' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubOpenComment'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'结束时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubEndTime'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否被删除 1-删除' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubIsDel'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'间隔时间,单位秒' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubTimeSlot'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保留天数信息' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Pubkeep'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'更新跳转地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubGourl'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'站点ID' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'PubSiteID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公开' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'ZL_Pub', @level2type=N'COLUMN', @level2name=N'Public'

GO
SET IDENTITY_INSERT [ZL_Pub] ON
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubNodeID],[PubTemplateID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 2,N'文章投票',0,N'ZL_Pub_WZTP',3,0,0,N'/互动模板/默认留言文章投票模板.html',N'WZTP',17,N'0',N'0',0,0,0,6,0,0,N'/互动模板/默认留言文章投票提交模板.html',N'WZTP',N'2016-1-28 17:21:01',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 3,N'在线调查',6,N'ZL_Pub_ZXDC',4,0,0,N'/互动模板/默认问券在线调查模板.html',N'ZXDC',18,0,0,0,1,0,0,N'/互动模板/默认问券在线调查提交模板.html',N'ZXDC',N'2016-5-6 9:56:05',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 4,N'提问',5,N'ZL_Pub_TW',3,0,0,N'/互动模板/默认留言提问模板.html',N'TW',21,0,0,0,2,0,0,N'/互动模板/默认留言提问提交模板.html',N'TW',N'2016-5-7 19:01:33',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 5,N'问题回答',0,N'ZL_Pub_WTHD',0,0,0,N'/互动模板/默认评论问题回答模板.html',N'WTHD',22,0,0,0,1,0,0,N'/互动模板/默认评论问题回答提交模板.html',N'WTHD',N'2016-5-7 19:01:52',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
INSERT [ZL_Pub] ([Pubid],[PubName],[PubClass],[PubTableName],[PubType],[PubOneOrMore],[PubIPOneOrMore],[PubTemplate],[PubLoadstr],[PubModelID],[PubIsTrue],[PubCode],[PubLogin],[PubAddnum],[PubBindPub],[PubShowType],[PubInputTM],[PubInputLoadStr],[PubCreateTime],[PubOpenComment],[PubEndTime],[PubIsDel],[PubTimeSlot],[Pubkeep],[Puberrmsg],[PubSiteID],[Public]) VALUES ( 6,N'最佳答案',0,N'ZL_Pub_ZJDA',0,0,0,N'/互动模板/默认评论最佳答案模板.html',N'ZJDA',23,0,0,0,0,0,0,N'/互动模板/默认评论最佳答案提交模板.html',N'ZJDA',N'2016-5-7 19:02:04',0,N'9999-12-31 23:59:59',0,10,99999999,N'该用户提交信息的数量已经达到上限!',0,1)
SET IDENTITY_INSERT [ZL_Pub] OFF

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

detele from ZL_Pub

--注意:将删除整个表

drop table ZL_Pub

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

TRUNCATE table ZL_Pub