GO
CREATE TABLE [dbo].[ZL_Store_reg] (
[ID] [int]  IDENTITY (1, 1)  NOT NULL,
[UserID] [int]  NOT NULL,
[UserName] [nvarchar]  (255) NULL,
[StoreName] [varchar]  (50) NULL,
[StoreCredit] [int]  NULL DEFAULT (0),
[StoreCommendState] [int]  NULL DEFAULT (0),
[StoreState] [int]  NULL DEFAULT (0),
[StoreStyleID] [int]  NULL DEFAULT (0),
[StoreModelID] [int]  NULL,
[StoreStyle] [int]  NULL DEFAULT (0),
[AddTime] [datetime]  NULL DEFAULT (getdate()),
[area] [nvarchar]  (255) NULL DEFAULT (''),
[logo] [nvarchar]  (255) NULL DEFAULT (''),
[content] [ntext]  NULL DEFAULT (''),
[lxr] [nvarchar]  (255) NULL DEFAULT (''),
[tel] [nvarchar]  (255) NULL DEFAULT (''),
[addr] [nvarchar]  (255) NULL DEFAULT (''),
[weibo] [nvarchar]  (255) NULL DEFAULT (''),
[map] [ntext]  NULL DEFAULT (''),
[synopsis] [ntext]  NULL DEFAULT (''),
[pics] [ntext]  NULL DEFAULT (''),
[ShopType] [nvarchar]  (255) NULL DEFAULT (''),
[VideoUrl] [nvarchar]  (255) NULL DEFAULT (''))

ALTER TABLE [ZL_Store_reg] WITH NOCHECK ADD  CONSTRAINT [PK_ZL_Store_reg] PRIMARY KEY  NONCLUSTERED ( [ID] )
SET IDENTITY_INSERT [ZL_Store_reg] ON
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[weibo],[map]) VALUES ( 1,1,N'admin',N'逐浪网店',0,0,0,0,24,0,N'2017/1/10 17:59:11',N'上海,上海市,徐汇',N'/Template/v4/style/images/shop_store1.png',N'<h4 style="box-sizing: border-box; font-family: &quot;Microsoft Yahei&quot;, SimSun, Tahoma, Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(51, 51, 51); margin-top: 20px; margin-bottom: 10px; font-size: 18px; white-space: normal; background-color: rgb(255, 255, 255);">解决方案背景</h4><p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px;">网上商城是在为个人用户和企业用户提供人性化的全方位服务，努力为用户创造亲切、轻松和愉悦的购物环境，最大化地满足消费者日趋多样的购物需求。</p><h4 style="box-sizing: border-box; font-family: &quot;Microsoft Yahei&quot;, SimSun, Tahoma, Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(51, 51, 51); margin-top: 20px; margin-bottom: 10px; font-size: 18px; white-space: normal; background-color: rgb(255, 255, 255);">逐浪CMS解决方案的优势</h4><p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px;">网上商城是在为个人用户和企业用户提供人性化的全方位服务，努力为用户创造亲切、轻松和愉悦的购物环境，最大化地满足消费者日趋多样的购物需求。</p><h4 style="box-sizing: border-box; font-family: &quot;Microsoft Yahei&quot;, SimSun, Tahoma, Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(51, 51, 51); margin-top: 20px; margin-bottom: 10px; font-size: 18px; white-space: normal; background-color: rgb(255, 255, 255);">本案实施细节与亮点披露</h4><p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px;">网上商城是在为个人用户和企业用户提供人性化的全方位服务，努力为用户创造亲切、轻松和愉悦的购物环境，最大化地满足消费者日趋多样的购物需求。</p><h4 style="box-sizing: border-box; font-family: &quot;Microsoft Yahei&quot;, SimSun, Tahoma, Helvetica, Arial, sans-serif; line-height: 1.1; color: rgb(51, 51, 51); margin-top: 20px; margin-bottom: 10px; font-size: 18px; white-space: normal; background-color: rgb(255, 255, 255);">可应用范围</h4><p style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px;">网上商城是在为个人用户和企业用户提供人性化的全方位服务，努力为用户创造亲切、轻松和愉悦的购物环境，最大化地满足消费者日趋多样的购物需求。</p>',N'柳女士',N'021-50391046',N'上海市浦东新区海徐路2577号5幢125室',N'http://www.weibo.com/zoomla',N'121.630572,31.336614')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[logo],[content],[lxr],[tel],[addr]) VALUES ( 2,2,N'demo',0,0,0,0,24,0,N'2017/2/27 13:52:13',N'/Template/v4/style/images/shop_store.png',N'<p>水果超市：</p><p>我们供应各种水果</p>',N'小王',N'17607000246',N'北京')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[map],[synopsis]) VALUES ( 3,3,N'金狮蓝蒂',0,0,0,0,24,0,N'2017/4/10 17:32:48',N'上海,上海市,徐汇',N'System/Temp/20170328/20170328111854Alqv.jpg',N'<ul class="list list-paddingleft-2" style="margin-top: 10px; margin-bottom: 15px; width: 554.797px; padding: 0px 0px 0px 18px; white-space: normal; color: rgb(102, 102, 102); font-family: &quot;Hiragino Sans GB&quot;, &quot;WenQuanYi Micro Hei&quot;, tahoma, sans-serif; font-size: 14px; background-color: rgb(255, 255, 255);"><li><p>午市海鲜自助：11:10-14:00</p></li><li><p>最多可用餐2小时</p></li><li><p>午市使用时间：周一至周五11:10-14：00； 周六周日：10:45-14:15（法定节假日按周六周日执行）</p></li></ul><p><br/></p>',N'徐晓明',N'15677779999',N'松江区新松江路地中海购物中心4楼（奥莱小站内）',N'121.221797,31.044619',N'午市海鲜自助：11:10-14:00
最多可用餐2小时
午市使用时间：周一至周五11:10-14：00； 周六周日：10:45-14:15（法定节假日按周六周日执行）')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[map],[synopsis]) VALUES ( 4,4,N'炭香园自助烧烤',0,0,0,0,24,0,N'2017/4/10 17:36:38',N'上海,上海市,普陀',N'System/Temp/20170329/20170329140616rg2G.jpg',N'<p><strong style="white-space: normal;">烤肉类</strong>：烤牛外脊、牛舌、腊味牛舌、肥牛、牛排肉、炭香牛肉、秘制肥牛、LA牛排、胸叉肉、牛板筋\t、黑椒牛肉粒、肥牛小排、五花肉、大酱五花肉、辣酱五花肉、葡萄酒绿茶五花肉、梅花肉、炭香猪排、培根</p><p><img src="/UploadFiles/Image/20170328/6362629790316888706603497.jpg"/></p>',N'王先生',N'15677779998',N'松江区人民北路112号三楼（招商银行楼上）',N'121.234624,31.018148',N'炭香园自助烧烤以始终如一的美味和真诚，献给每一位客户。')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr]) VALUES ( 5,5,N'爱上木数码',0,0,0,0,24,0,N'2017/4/10 19:00:06',N'江西省,南昌,东湖',N'System/Temp/20170410/20170410190023ig1o.jpg',N'<p>开业十余年的品牌老店，专注数码，坚持与时俱进，不断尝试新事务...</p>',N'陈先生',N'15123234545',N'江西省南昌市东湖区梦时代广场')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 6,6,N'达芙妮鞋店',0,0,0,0,24,0,N'2017/4/11 8:45:18',N'江西省,南昌,西湖',N'System/Temp/20170411/20170411085101AMLt.jpg',N'<p>达芙妮精选，你的优质选择，让您足下生辉，神采飞扬</p>',N'郑先生',N'13245625454',N'南昌市西湖区朝阳水厂',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 7,7,N'梵蒂冈超市',0,0,0,0,24,0,N'2017/4/11 8:52:26',N'江西省,南昌,青山湖',N'System/Temp/20170411/20170411085206NqlR.jpg',N'<p>百姓居家，平常生活，您的选择是我们的追求</p>',N'张先生',N'15123224646',N'南昌市西湖区贤士二路口',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 8,8,N'瑞士军刀',0,0,0,0,24,0,N'2017/4/11 8:54:08',N'System/Temp/20170411/201704110854054jvM.jpg',N'<p>让您身临其境，体验前所未有的战争暴力场面，这不是战区，是战场</p>',N'常先生',N'15178786565',N'南昌市西湖区抚生路',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 9,9,N'百斯盾',0,0,0,0,24,0,N'2017/4/11 8:57:34',N'江西省,南昌,青云谱',N'System/Temp/20170411/20170411141447eIrp.jpg',N'<p>开业大酬宾，开业日凡至本店者均可享受5折优惠，百斯盾，让你从此与众不同</p>',N'余先生',N'15554659898',N'南昌市青云谱区正荣',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 10,10,N'艾玛',0,0,0,0,24,0,N'2017/4/11 9:03:21',N'江西省,南昌,湾里',N'System/Temp/20170411/20170411090301jPD5.jpg',N'<p>中国驰名商标，著名品牌，做您想要的电动车</p>',N'李先生',N'15165654545',N'南昌市湾里学府大道',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 11,11,N'键昌家园',0,0,0,0,24,0,N'2017/4/11 9:05:20',N'江西省,南昌,青山湖',N'System/Temp/20170411/20170411090447uMpd.jpg',N'<p>让老年朋友不再孤单，永远健康平安，给我们最优质的服务</p>',N'韩先生',N'15232324545',N'南昌市青山湖区江大南路',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 12,12,N'沃尔玛',0,0,0,0,24,0,N'2017/4/11 9:13:26',N'江西省,南昌,东湖',N'System/Temp/20170411/20170411091302Hrj7.jpg',N'<p>国际连锁超市，物品齐全，系统繁多，你的生活首选</p>',N'罗先生',N'18125253636',N'南昌市八一广场旁',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[logo],[content],[lxr],[tel],[addr],[ShopType]) VALUES ( 13,13,N'夏威夷果农',0,0,0,0,24,0,N'2017/4/11 9:14:57',N'System/Temp/20170411/201704111412030vFg.jpg',N'<p>来自大西洋，不，是太平洋彼岸的夏威夷，精选热卖，保证原汁原味，让您倾听大西洋，不，太平洋的浪声</p>',N'刘先生',N'15212123636',N'南昌市西湖区洪城路',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[pics],[ShopType]) VALUES ( 14,14,N'旧金山海归',0,0,0,0,24,0,N'2017/4/11 9:17:54',N'江西省,南昌,新建',N'System/Temp/20170411/20170411091629twCq.jpg',N'<p>来自太平洋彼岸的旧金山海归，不留恋硅谷科技，直卖硅谷科技</p>',N'海先生',N'15114145959',N'南昌市高新大道',N'[{"url":"System/field/images/20170411/20170411fa7yl0.jpg","desc":""},{"url":"System/field/images/20170411/20170411kVOsgT.jpg","desc":""},{"url":"System/field/images/20170411/20170411i74tYR.jpg","desc":""}]',N'普通店铺')
INSERT [ZL_Store_reg] ([ID],[UserID],[UserName],[StoreCredit],[StoreCommendState],[StoreState],[StoreStyleID],[StoreModelID],[StoreStyle],[AddTime],[area],[logo],[content],[lxr],[tel],[addr],[pics],[ShopType],[VideoUrl]) VALUES ( 15,15,N'农家乐',0,0,0,0,24,0,N'2017/4/11 9:37:19',N'江西省,南昌,进贤',N'System/Temp/20170411/20170411092538Yq6h.jpg',N'<p>瑶湖湾农家乐</p>',N'瑶湖湾',N'13012345678',N'瑶湖湾农家乐',N'[{"url":"System/field/images/20170411/201704116Mg8LT.jpg","desc":""},{"url":"System/field/images/20170411/20170411IRGgdd.jpg","desc":""}]',N'有机农庄',N'https://www.z01.com/10year.mp4')
SET IDENTITY_INSERT [ZL_Store_reg] OFF