序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | |||
2 | Guid | varchar | 200 | 0 | 是 | 内容Guid | ||||
3 | page | ntext | 16 | 0 | 是 | 页面数据 | ||||
4 | comp | ntext | 16 | 0 | 是 | 压缩后的Json | ||||
5 | CDate | datetime | 8 | 3 | 是 | 创建时间 | ||||
6 | UPDate | datetime | 8 | 3 | 是 | 修改时间 | ||||
7 | UserID | int | 4 | 0 | 是 | 用户ID | ||||
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 | 是 | 标注页面元信息 | ||||
13 | Resource | ntext | 16 | 0 | 是 | 引入的JS和CSS资源 | ||||
14 | Path | nvarchar | 500 | 0 | 是 | 页面路径,给予路由定位,示例:/dir/index | ||||
15 | ZType | int | 4 | 0 | 是 | 0:普通页面,1:模板,2:全局组件 | ||||
16 | TlpID | int | 4 | 0 | 是 | 模板ID | ||||
17 | SiteID | int | 4 | 0 | 是 | IsTemplate,该页面是否为一个模板页 | ||||
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 | 是 |
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
TRUNCATE table ZL_Design_Page