ds_b2b2c/b2b2c/sql/项目修改语句.sql

-- 快递鸟编辑
update sys_setting set value = '939bfad3-6fff-4cdb-973c-0200fc8d06a2' where name = 'express_apikey'; -- 快递鸟key
update sys_setting set value = '1755434' where name = 'express_ebusinessid'; -- 快递鸟id

-- 图片配置基本设置删除
delete from sys_setting where name in('main_site_logo','main_user_center_logo','main_user_forget_password_bg','main_user_logon_bg','main_user_register_bg','pc_home_bottom_adv')
update sys_system_resource set content = '发现装修' where resource_id = 327;
update sys_system_resource set content = '发现首页' where resource_id = 328;

-- 删除消息设置中的换货
delete from msg_store_tpl where tpl_name in('换货提醒','换货超期自动处理提醒');

-- 小程序
update sys_setting set value = 'wx43aba958092afe0c' where name = 'login_wx_mini_appid';
update sys_setting set value = '647d35cc24fc7996003168d44ea91a43' where name = 'login_wx_mini_appsecret';

-- 微信支付
update sys_setting set value='acAcsnklknskfnslalcn134643sljlda' where title='微信apikey';
update sys_setting set value='wx43aba958092afe0c' where title='微信appid';
update sys_setting set value='647d35cc24fc7996003168d44ea91a43' where title='微信appSecret';
update sys_setting set value='1489871402' where title='微信商户号';

--添加直播
update vendor_resources set state = 2 where resources_id in(471,472,473);
INSERT INTO `vendor_resources`
select max(resources_id)+1 resources_id,0, '/', '直播', '2020-12-30 17:31:52', 1, 1, '/' from vendor_resources;
INSERT INTO `vendor_resources`
select max(resources_id)+1 resources_id,max(resources_id), '/', '直播', '2020-12-30 17:32:45', 1, 2, '/live' from vendor_resources;
INSERT INTO `vendor_resources`
select max(resources_id)+1 resources_id,max(resources_id), '/', '直播列表', '2020-12-30 17:33:30', 1, 3, '/live/decorate_live' from vendor_resources;

-- 根据vendor_resources 配置
-- INSERT INTO `b2b2c`.`vendor_resources_roles`
-- select max(resources_roles_id)+1 resources_roles_id,680, 2,'2021-04-22 15:25:28' from vendor_resources_roles ;
-- INSERT INTO `b2b2c`.`vendor_resources_roles`
-- select max(resources_roles_id)+1 resources_roles_id,681, 2,'2021-04-22 15:25:28' from vendor_resources_roles ;
-- INSERT INTO `b2b2c`.`vendor_resources_roles`
-- select max(resources_roles_id)+1 resources_roles_id,682, 2,'2021-04-22 15:25:28' from vendor_resources_roles ;