表名:ZL_Design_Page












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40   
2Guidvarchar2000    内容Guid
3pagentext160    页面数据
4compntext160    压缩后的Json
5CDatedatetime83    创建时间
6UPDatedatetime83    修改时间
7UserIDint40    用户ID
8UserNamenvarchar1000    用户
9Remindnvarchar1000    备注
10labelArrntext160    标签集合
11Titlenvarchar500    页面标题
12Metanvarchar40000    标注页面元信息
13Resourcentext160    引入的JS和CSS资源
14Pathnvarchar5000    页面路径,给予路由定位,示例:/dir/index
15ZTypeint40    0:普通页面,1:模板,2:全局组件
16TlpIDint40    模板ID
17SiteIDint40    IsTemplate,该页面是否为一个模板页
18OrderIDint40    订单编号
19scencentext160    场景,仅用于场景设计
20PreviewImgnvarchar40000    预览图
21ThumbImgnvarchar5000    缩略图
22Statusint40     
23Scorefloat80    评分
24Seflagnvarchar5000    系统标识
25AccessPwdnvarchar2000    访问密码
26CUserint40     

简要说明:

PC站点页面表

GO
CREATE TABLE [dbo].[ZL_Design_Page](
[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_Page] 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_Page] ON
INSERT [ZL_Design_Page] ([ID],[Guid],[page],[comp],[CDate],[UPDate],[UserID],[Title],[Path],[ZType],[TlpID],[SiteID]) VALUES ( 1,N'2aac33e9-dced-4d2c-90df-07d9ac16bc4d',N'{"bgconfig":{"type":"","url":"","post":""}}',N'["{\"dataMod\":{\"list\":[{\"name\":\"图片1\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p1.jpg\",\"target\":\"\",\"click\":null,\"css\":\"active\",\"layout\":{\"width\":\"25%\"}},{\"name\":\"图片2\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p2.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"25%\"}},{\"name\":\"图片3\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p3.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"25%\"}},{\"name\":\"图片4\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p4.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"25%\"}},{\"name\":\"图片5\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p5.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"50%\"}},{\"name\":\"图片6\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p6.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"25%\"}},{\"name\":\"图片7\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/p7.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\",\"layout\":{\"width\":\"25%\"}}]},\"config\":{\"type\":\"gallery_group\",\"compid\":\"\",\"css\":\"candrag                              \",\"style\":\"width: 100%; position: absolute; top: 647px; left: -2px;\"}}","{\"dataMod\":{\"html\":\"<p style=\\\"text-align: center;\\\"><img src=\\\"/Site/1/UploadFiles/6359590634460885153044002.jpg\\\" title=\\\"1.jpg\\\" alt=\\\"1.jpg\\\"/></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; line-height: 21.6px; white-space: normal; text-align: center; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-size: 18px; font-family: 微软雅黑; color: rgb(0, 0, 0);\\\">专业设计</span></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; white-space: normal; text-align: center; line-height: 2em; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-family: 微软雅黑; font-size: 13px;\\\">设计是把一种计划、规划、设想通过视觉的形式传达出来的活动过</span></p><p><br/></p>\"},\"config\":{\"type\":\"ueditor\",\"css\":\"candrag                              \",\"style\":\"position: absolute; top: 425px; left: 5px; width: 278px; height: 190px;\"}}","{\"dataMod\":{\"html\":\"<p style=\\\"text-align: center;\\\"><img src=\\\"/Site/1/UploadFiles/6359590638296805749457645.jpg\\\" title=\\\"2.jpg\\\" alt=\\\"2.jpg\\\"/></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; line-height: 21.6px; white-space: normal; text-align: center; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-size: 18px; font-family: 微软雅黑; color: rgb(0, 0, 0);\\\">品牌策划</span></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; white-space: normal; text-align: center; line-height: 2em; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-family: 微软雅黑; font-size: 13px;\\\">品牌是给拥有者带来溢价、产生增值的一种无形的资产。</span></p><p><br/></p>\"},\"config\":{\"type\":\"ueditor\",\"css\":\"candrag                              \",\"style\":\"position: absolute; top: 422px; left: 293px; width: 275px; height: 189px;\"}}","{\"dataMod\":{\"html\":\"<p style=\\\"text-align: center;\\\"><img src=\\\"/Site/1/UploadFiles/6359590639787390702903244.jpg\\\" title=\\\"3.jpg\\\" alt=\\\"3.jpg\\\"/></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; line-height: 21.6px; white-space: normal; text-align: center; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-size: 18px; font-family: 微软雅黑; color: rgb(0, 0, 0);\\\">视觉效果</span></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; white-space: normal; text-align: center; line-height: 2em; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-family: 微软雅黑; font-size: 13px;\\\">通过视觉,人和动物获得对机体生</span><span style=\\\"font-family: 微软雅黑; font-size: 13px;\\\">存具有重要意义的各种信息。</span></p><p><br/></p>\"},\"config\":{\"type\":\"ueditor\",\"css\":\"candrag                              \",\"style\":\"position: absolute; top: 421px; left: 583px; width: 287px; height: 188px;\"}}","{\"dataMod\":{\"html\":\"<p style=\\\"text-align: center;\\\"><img src=\\\"/Site/1/UploadFiles/6359590642103122825428423.jpg\\\" title=\\\"4.jpg\\\" alt=\\\"4.jpg\\\"/></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; line-height: 21.6px; white-space: normal; text-align: center; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-size: 18px; font-family: 微软雅黑; color: rgb(0, 0, 0);\\\">业务推广</span></p><p style=\\\"margin-top: 0px; margin-bottom: 0px; color: rgb(102, 102, 102); font-family: 微软雅黑, 宋体; font-size: 12px; white-space: normal; text-align: center; line-height: 2em; background-color: rgb(255, 255, 255);\\\"><span style=\\\"font-family: 微软雅黑; font-size: 13px;\\\">把自己通过传统的四大媒体广告让更多的人了解、接受。</span></p><p><br/></p>\"},\"config\":{\"type\":\"ueditor\",\"css\":\"candrag                              \",\"style\":\"position: absolute; top: 423px; left: 874px; width: 282px; height: 188px;\"}}"]',N'2016/4/5 14:29:17',N'2016/4/20 19:50:00',1,N'我的页面_20160405',N'/index',0,1,1)
INSERT [ZL_Design_Page] ([ID],[Guid],[page],[comp],[CDate],[UPDate],[UserID],[Title],[Path],[ZType],[TlpID],[SiteID]) VALUES ( 2,N'8c9958ad-4a22-45c6-a281-44f6d607c371',N'{"bgconfig":{"type":"","url":"","post":""}}',N'["{\"dataMod\":{\"list\":[]},\"config\":{\"type\":\"list\",\"compid\":\"\",\"css\":\"candrag                         \",\"style\":\"width: 957.778px; position: absolute; top: 387.997px; left: 107.99px; height: 27.7778px;\"}}"]',N'2016/4/5 14:32:41',N'2016/4/20 18:22:14',1,N'我的页面_20160405',N'/list',0,1,1)
INSERT [ZL_Design_Page] ([ID],[Guid],[page],[comp],[CDate],[UPDate],[UserID],[Title],[Path],[ZType],[TlpID],[SiteID]) VALUES ( 3,N'3fec778f-a77b-4343-b8e6-fa7f13691713',N'{"bgconfig":{"type":"","url":"","post":""}}',N'["{\"dataMod\":{\"list\":[]},\"config\":{\"type\":\"content\",\"compid\":\"\",\"css\":\"candrag              \",\"style\":\"width: 960px; position: absolute; top: 444.993px; left: 87.3611px;\"}}"]',N'2016/4/5 14:33:06',N'2016/4/20 18:20:59',1,N'我的页面_20160405',N'/Content',0,1,1)
INSERT [ZL_Design_Page] ([ID],[Guid],[page],[comp],[CDate],[UPDate],[UserID],[Title],[Path],[ZType],[TlpID],[SiteID]) VALUES ( 4,N'2aac33e9-dced-4d2c-90df-07d9ac16bc88',N'{"bgconfig":{"type":"","url":"","post":""}}',N'["{\"dataMod\":{\"src\":\"/Site/1/UploadFiles/logo.jpg\"},\"config\":{\"type\":\"image\",\"compid\":\"logo\",\"css\":\"onlydrag     \",\"style\":\"position: absolute; top: 47px; left: 16.9861px;\",\"imgstyle\":\"width: 200px; height: 47px; margin: 0px; resize: none; position: static; zoom: 1; display: block;\"}}","{\"dataMod\":{\"items\":[{\"href\":\"/List?NodeID=88\",\"name\":\"友情链接\",\"css\":\"\"},{\"href\":\"/List?NodeID=16\",\"name\":\"手机数码\",\"css\":\"\"},{\"href\":\"/List?NodeID=87\",\"name\":\"人才招聘\",\"css\":\"\"},{\"href\":\"/List?NodeID=13\",\"name\":\"时尚\",\"css\":\"\"},{\"href\":\"/List?NodeID=89\",\"name\":\"计算机资料\",\"css\":\"\"}]},\"config\":{\"type\":\"menu\",\"compid\":\"h1\",\"css\":\"candrag                        \",\"style\":\"position: absolute; top: 44px; left: 259px; width: 911px; height: 70px;\"}}","{\"dataMod\":{\"list\":[{\"name\":\"标题1\",\"tip\":\"\",\"orderid\":1,\"url\":\"/Design/tlp/P001/Style/Images/banner1.jpg\",\"target\":\"\",\"click\":null,\"css\":\"active\"},{\"name\":\"标题2\",\"tip\":\"\",\"orderid\":2,\"url\":\"/Design/tlp/P001/Style/Images/banner2.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\"},{\"name\":\"标题3\",\"tip\":\"\",\"orderid\":3,\"url\":\"/Design/tlp/P001/Style/Images/banner3.jpg\",\"target\":\"\",\"click\":null,\"css\":\"\"}]},\"config\":{\"type\":\"gallery\",\"compid\":\"\",\"css\":\"dragy                    \",\"style\":\"width: 100%; left: 0px; position: absolute; top: 116px;\",\"bodyid\":\"mainBody\"}}","{\"dataMod\":{},\"config\":{\"type\":\"div\",\"compid\":\"div\",\"bodyid\":\"mainBody\",\"css\":\"candrag                        \",\"style\":\"border-color: rgb(231, 231, 231); width: 100%; height: 30px; position: absolute; top: 3px; left: 4px; background-color: rgb(248, 248, 248);\"}}","{\"dataMod\":{\"text\":\"在线收藏 | 设为首页\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                           \",\"style\":\"position: relative; z-index: 1; font-size: 12px; left: 791px; top: 8px;\",\"bodyid\":\"midBody\"}}","{\"dataMod\":{\"text\":\"联系电话:0795-88654423\"},\"config\":{\"type\":\"text\",\"compid\":\"comp1\",\"css\":\"candrag                             \",\"style\":\"position: relative; z-index: 1; font-size: 12px; left: 820px; top: 10px;\",\"bodyid\":\"midBody\"}}"]',N'2016/4/5 14:29:17',N'2016/4/20 18:56:52',1,N'我的页面_20160405',N'/nav',2,1,1)
SET IDENTITY_INSERT [ZL_Design_Page] OFF

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

detele from ZL_Design_Page

--注意:将删除整个表

drop table ZL_Design_Page

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

TRUNCATE table ZL_Design_Page