表名:ZL_Design_Scence












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2Guidvarchar2000    场景Guid
3pagentext160    场景页面详情
4compntext160    场景组件
5CDatedatetime83     
6UPDatedatetime83    更新时间
7UserIDint40     
8UserNamenvarchar1000    用户名称
9Remindnvarchar1000     
10labelArrntext160    标签数组
11Titlenvarchar500    场景标题
12Metanvarchar40000    页面META
13Resourcentext160    页面资源
14Pathnvarchar5000    页面路径
15ZTypeint40     
16TlpIDint40    模板ID
17SiteIDint40    所属站点
18OrderIDint40     
19scencentext160    场景信息
20PreviewImgnvarchar40000    预览图片
21ThumbImgnvarchar5000    缩略图
22Statusint40     
23Scorefloat80    评分
24Seflagnvarchar5000    系统标识
25AccessPwdnvarchar2000    访问密码
26CUserint40     

简要说明:

H5场景表

GO
CREATE TABLE [dbo].[ZL_Design_Scence](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Guid] [varchar](200) NULL,
[page] [ntext] NULL,
[comp] [ntext] NULL,
[CDate] [datetime] NULL,
[UPDate] [datetime] NULL,
[UserID] [int] NULL,
[UserName] [nvarchar](100) NULL,
[Remind] [nvarchar](100) NULL,
[labelArr] [ntext] NULL,
[Title] [nvarchar](50) NULL,
[Meta] [nvarchar](4000) NULL,
[Resource] [ntext] NULL,
[Path] [nvarchar](500) NULL,
[ZType] [int] NULL,
[TlpID] [int] NULL,
[SiteID] [int] NULL,
[OrderID] [int] NULL,
[scence] [ntext] NULL,
[PreviewImg] [nvarchar](4000) NULL,
[ThumbImg] [nvarchar](500) NULL,
[Status] [int] NULL,
[Score] [float] NULL,
[Seflag] [nvarchar](500) NULL,
[AccessPwd] [nvarchar](200) NULL,
[CUser] [int] NULL,
CONSTRAINT [PK_ZL_Design_Scence] PRIMARY KEY CLUSTERED
([ID] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


SET IDENTITY_INSERT [ZL_Design_Scence] ON
INSERT [ZL_Design_Scence] ([ID],[Status],[Guid],[page],[comp],[CDate],[UPDate],[UserID],[UserName],[Title],[Path],[ZType],[TlpID],[SiteID],[OrderID],[scence]) VALUES ( 1,0,N'4e965ec8-2cf5-42f0-93e5-b94598d6e05d',N'{"bk":"[{\"type\":\"image\",\"url\":\"/UploadFiles/User/admin1/20160708/20160708XYJ6PA.jpg\",\"post\":\"\",\"pageid\":\"1\"},{\"type\":\"image\",\"url\":\"/UploadFiles/User/admin1/20160708/20160708xdNyuk.jpg\",\"post\":\"\",\"pageid\":\"2\"},{\"type\":\"image\",\"url\":\"/UploadFiles/User/admin1/20160708/20160708PUmvsl.jpg\",\"post\":\"\",\"pageid\":\"3\"}]","music":"null","scence_conf":"{\"effect\":\"slide\",\"direction\":\"vertical\",\"autoplay\":0,\"loop\":false}"}',N'["{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/icon.jpg\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag                  fadeIn \",\"style\":\"position:absolute;top:85px;bottom:342px;left:238px;right:108px;width:148px;height:151px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 148px; height: 151px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":\"0.5\",\"delay\":0,\"effect\":\"fadeIn\",\"time\":1}}}","{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/puple.png\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag                  rubberBand \",\"style\":\"position:absolute;top:33px;bottom:381px;left:421px;right:14px;width:175px;height:183px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 175px; height: 183px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":0,\"effect\":\"rubberBand\",\"time\":1}}}","{\"dataMod\":{\"text\":\"攻略秘籍\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       fadeInLeft \",\"style\":\"position:absolute;top:248px;bottom:280px;left:178px;right:43px;width:638px;height:61px;z-index:4;font-size:70px;color:rgb(255, 255, 255);\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":\"0.5\",\"delay\":\"1\",\"effect\":\"fadeInLeft\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"text\":\"最新攻略一手掌握\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     fadeInRight \",\"style\":\"position:absolute;top:341px;bottom:-195px;left:186px;right:-64px;width:638px;height:41px;font-size:32px;color:rgb(255, 255, 255);\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":\"0.5\",\"delay\":\"1\",\"effect\":\"fadeInRight\",\"time\":1}}}","{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/page1mobile.png\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag                  fadeInUp \",\"style\":\"position:absolute;top:561px;bottom:24px;left:59px;right:17px;width:494px;height:435px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 494px; height: 435px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"2\",\"effect\":\"fadeInUp\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/page1mobile_pic.png\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag                  fadeInDown \",\"style\":\"position:absolute;top:547px;bottom:50px;left:36px;right:35px;width:463px;height:371px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 463px; height: 371px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"2.5\",\"effect\":\"fadeInDown\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/page4mobile.png\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag                     \",\"style\":\"position:absolute;top:39px;bottom:218px;left:121px;right:49px;width:416px;height:516px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 416px; height: 516px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":0,\"effect\":\"zoomInUp\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"text\":\"无须\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                      \",\"style\":\"position:absolute;top:605px;bottom:154px;left:124px;right:139px;width:638px;height:48px;font-size:35px;color:rgb(0, 0, 0);\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"bounceIn\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"text\":\"切出 , 随时\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                     \",\"style\":\"position:absolute;top:597px;bottom:-267px;left:206px;right:-66px;width:638px;height:58px;font-size:44px;color:rgb(237, 127, 6);\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"bounceIn\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"text\":\"查阅\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                      \",\"style\":\"position:absolute;top:606px;bottom:151px;left:429px;right:-56px;width:638px;height:46px;font-size:35px;color:rgb(0, 0, 0);\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"bounceIn\",\"time\":1}}}","{\"dataMod\":{\"text\":\"游戏攻略两不误\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                                                      \",\"style\":\"position:absolute;top:667px;bottom:114px;left:126px;right:-13px;width:638px;height:48px;font-size:35px;color:rgb(0, 0, 0);\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"bounceIn\",\"time\":1,\"count\":1}}}","{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/page2mobile.png\"},\"config\":{\"type\":\"image\",\"compid\":\"image\",\"css\":\"onlydrag           \",\"style\":\"position:absolute;top:30px;bottom:195px;left:167px;right:62px;width:304px;height:580px;font-size:14px;color:rgb(51, 51, 51);\",\"imgstyle\":\"width: 304px; height: 580px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":0,\"effect\":\"bounceInDown\",\"time\":1}}}","{\"dataMod\":{\"text\":\"攻略秘册APP2.3\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                     \",\"style\":\"position:absolute;top:667px;bottom:-289px;left:104px;right:-14px;width:638px;height:42px;font-size:35px;color:rgb(0, 0, 0);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":0,\"effect\":\"bounceIn\",\"time\":1}}}","{\"dataMod\":{\"text\":\"重磅升级\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                     \",\"style\":\"position:absolute;top:662px;bottom:-290px;left:383px;right:-15px;width:638px;height:48px;font-size:41px;color:rgb(245, 167, 4);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":0,\"effect\":\"bounceIn\",\"time\":1}}}","{\"dataMod\":{\"text\":\" 1.改进了搜索机制,搜索更准确\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                   \",\"style\":\"position:absolute;top:744px;bottom:-316px;left:103px;right:-38px;width:638px;height:4px;font-size:21px;color:rgb(92, 195, 232);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":\"0.8\",\"delay\":\"0.1\",\"effect\":\"slideInRight\",\"time\":1}}}","{\"dataMod\":{\"text\":\" 2.增加游戏精选内容,更好的浏览攻略\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                  \",\"style\":\"position:absolute;top:792px;bottom:-314px;left:101px;right:-38px;width:638px;height:42px;font-size:21px;color:rgb(92, 195, 232);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":\"0.8\",\"delay\":\"0.2\",\"effect\":\"slideInRight\",\"time\":1}}}","{\"dataMod\":{\"text\":\"3.增加了按名称筛选和按类型筛选的功能\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                  \",\"style\":\"position:absolute;top:843px;bottom:-312px;left:97px;right:-38px;width:638px;height:33px;font-size:21px;color:rgb(92, 195, 232);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":\"0.8\",\"delay\":\"0.3\",\"effect\":\"slideInRight\",\"time\":1}}}","{\"dataMod\":{\"text\":\"4.增加了一些提高用户体验的新功能\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                                                                                                                                                                                                                                                                                                                                        \",\"style\":\"position:absolute;top:890px;bottom:-312px;left:97px;right:-39px;width:638px;height:35px;font-size:21px;color:rgb(92, 195, 232);\",\"bodyid\":\"mainBody3\",\"animate\":{\"enabled\":true,\"duration\":\"0.8\",\"delay\":\"0.4\",\"effect\":\"slideInRight\",\"time\":1}}}","{\"dataMod\":{\"text\":\"轩辕剑外传穹之扉、梦幻西游、我的世界已首\"},\"config\":{\"type\":\"text\",\"compid\":\"comp6\",\"css\":\"candrag                                                                                                                          \",\"style\":\"position:absolute;top:724px;left:122px;width:638px;height:32px;font-size:21px;\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"lightSpeedIn\",\"count\":1}}}","{\"dataMod\":{\"value\":\"立即下载\",\"html\":\"\"},\"config\":{\"type\":\"button\",\"compid\":\"\",\"css\":\"candrag                           \",\"class\":\"btn btn-primary\",\"bgcolor\":\"\",\"width\":300,\"height\":60,\"fontsize\":\"33px\",\"style\":\"position:relative;top:408px;left:168px;width:300px;height:60px;\",\"htm\":\"操作按钮\",\"bodyid\":\"mainBody1\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"1.5\",\"effect\":\"lightSpeedIn\",\"count\":1}}}","{\"dataMod\":{\"text\":\"发完整剧情攻略,各热门游戏主线、支\"},\"config\":{\"type\":\"text\",\"compid\":\"comp6\",\"css\":\"candrag                                                                                                                          \",\"style\":\"position:absolute;top:760px;left:122px;width:638px;height:44px;font-size:21px;\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"lightSpeedIn\",\"count\":1}}}","{\"dataMod\":{\"text\":\"线、剧情一体的攻略,是玩家必备的游\"},\"config\":{\"type\":\"text\",\"compid\":\"comp6\",\"css\":\"candrag                                                                                                                          \",\"style\":\"position:absolute;top:798px;left:124px;width:638px;height:36px;font-size:21px;\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"lightSpeedIn\",\"count\":1}}}","{\"dataMod\":{\"text\":\"戏百科全书\"},\"config\":{\"type\":\"text\",\"compid\":\"comp6\",\"css\":\"candrag                                                                                                                            \",\"style\":\"position:absolute;top:842px;left:124px;width:638px;height:36px;font-size:21px;\",\"bodyid\":\"mainBody2\",\"animate\":{\"enabled\":true,\"duration\":1,\"delay\":\"0.5\",\"effect\":\"lightSpeedIn\",\"count\":1}}}"]',N'2016/6/23 8:54:45',N'2016/7/9 11:36:19',1,N'admin',N'页面_20160623',N'/LIy7BA',1,2,1,1,N'[{"id":1,"title":"","order":1},{"id":2,"title":"","order":2},{"id":3,"title":"","order":3}]')
SET IDENTITY_INSERT [ZL_Design_Scence] OFF

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

detele from ZL_Design_Scence

--注意:将删除整个表

drop table ZL_Design_Scence

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

TRUNCATE table ZL_Design_Scence