DB_51aspx/2014年/图标update sql2014-9-18/图标添加912-酒店.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

select count(*) from [wx_PicStore] where  [picTemplates]='酒店'

select * from [wx_PicStore]where  [picTemplates]='酒店'

--delete  from [wx_PicStore] where  [picTemplates]='酒店'
-- 紫色
--
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('最新活动' ,'/images/templates/tubiao_zi/jiudian/27.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',1,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('在线留言' ,'/images/templates/tubiao_zi/jiudian/26.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',2,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('一键拨号' ,'/images/templates/tubiao_zi/jiudian/25.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',3,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('洗衣间' ,'/images/templates/tubiao_zi/jiudian/24.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',4,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('微名片' ,'/images/templates/tubiao_zi/jiudian/23.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',6,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('客房展示' ,'/images/templates/tubiao_zi/jiudian/22.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',6,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('客房清洁' ,'/images/templates/tubiao_zi/jiudian/21.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',7,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('客房查询' ,'/images/templates/tubiao_zi/jiudian/20.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',8,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('咖啡厅' ,'/images/templates/tubiao_zi/jiudian/19.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',9,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('酒水预订' ,'/images/templates/tubiao_zi/jiudian/18.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',10,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('酒店信息' ,'/images/templates/tubiao_zi/jiudian/17.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',11,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('酒店菜单' ,'/images/templates/tubiao_zi/jiudian/16.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',12,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('酒吧' ,'/images/templates/tubiao_zi/jiudian/15.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',13,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('程车预定' ,'/images/templates/tubiao_zi/jiudian/14.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',14,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('机票预定' ,'/images/templates/tubiao_zi/jiudian/13.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',16,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('会员优惠' ,'/images/templates/tubiao_zi/jiudian/12.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',16,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('豪华音响' ,'/images/templates/tubiao_zi/jiudian/11.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',17,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('行李托运' ,'/images/templates/tubiao_zi/jiudian/10.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',18,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('公共澡堂' ,'/images/templates/tubiao_zi/jiudian/9.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',19,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('分享' ,'/images/templates/tubiao_zi/jiudian/8.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',20,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('酒店管理' ,'/images/templates/tubiao_zi/jiudian/7.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',21,'zi');
 
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('分店管理' ,'/images/templates/tubiao_zi/jiudian/6.png' ,'酒店',6,'分类icon','','李朴','2016-9-12',22,'zi');