序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | Guid | varchar | 200 | 0 | 是 | 场景Guid | ||||
3 | page | ntext | 16 | 0 | 是 | 场景页面详情 | ||||
4 | comp | ntext | 16 | 0 | 是 | 场景组件 | ||||
5 | CDate | datetime | 8 | 3 | 是 | |||||
6 | UPDate | datetime | 8 | 3 | 是 | 更新时间 | ||||
7 | UserID | int | 4 | 0 | 是 | |||||
8 | UserName | nvarchar | 100 | 0 | 是 | 用户名称 | ||||
9 | Remind | nvarchar | 100 | 0 | 是 | |||||
10 | labelArr | ntext | 16 | 0 | 是 | 标签数组 | ||||
11 | Title | nvarchar | 50 | 0 | 是 | 场景标题 | ||||
12 | Meta | nvarchar | 4000 | 0 | 是 | 页面META | ||||
13 | Resource | ntext | 16 | 0 | 是 | 页面资源 | ||||
14 | Path | nvarchar | 500 | 0 | 是 | 页面路径 | ||||
15 | ZType | int | 4 | 0 | 是 | |||||
16 | TlpID | int | 4 | 0 | 是 | 模板ID | ||||
17 | SiteID | int | 4 | 0 | 是 | 所属站点 | ||||
18 | OrderID | int | 4 | 0 | 是 | |||||
19 | scence | ntext | 16 | 0 | 是 | 场景信息 | ||||
20 | PreviewImg | nvarchar | 4000 | 0 | 是 | 预览图片 | ||||
21 | ThumbImg | nvarchar | 500 | 0 | 是 | 缩略图 | ||||
22 | Status | int | 4 | 0 | 是 | |||||
23 | Score | float | 8 | 0 | 是 | 评分 | ||||
24 | Seflag | nvarchar | 500 | 0 | 是 | 系统标识 | ||||
25 | AccessPwd | nvarchar | 200 | 0 | 是 | 访问密码 | ||||
26 | CUser | int | 4 | 0 | 是 |
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
TRUNCATE table ZL_Design_Scence