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

-- 登入appi替换
UPDATE sys_setting SET value = 'wxa9bd66952a99ea71' WHERE name = 'login_wx_mini_appid';

-- 快递鸟编辑
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 = '1629060104' WHERE title = '微信商户号';
UPDATE sys_setting SET value = 'wxa9bd66952a99ea71' WHERE title='微信appid';
UPDATE sys_setting SET value = '611efc8171b8a9f3d679f3f45ae45280' WHERE title='微信apikey';
update sys_setting set value='12378987568fWnkflqafsnkJBKBKFEKB' where title='微信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,680, '/', '直播', '2020-12-30 17:32:45', 1, 2, '/live' from vendor_resources;
INSERT INTO `vendor_resources`
select max(resources_id)+1 resources_id,681, '/', '直播列表', '2020-12-30 17:33:30', 1, 3, '/live/decorate_live' from vendor_resources;
INSERT INTO `vendor_resources`
select max(resources_id)+1 resources_id,681, '/', '直播商品', '2020-12-30 17:33:30', 1, 3, '/live/goods_live' from vendor_resources;

-- 暂时不用
-- select max(resources_id)+1 resources_id,681, '/', '直播商品添加', '2020-12-30 17:33:30', 1, 3, '/live/goods_live_edit' from vendor_resources;
-- INSERT INTO `vendor_resources`
-- select max(resources_id)+1 resources_id,681, '/', '直播间商品添加', '2020-12-30 17:33:30', 1, 3, '/live/live_room_goods_edit' 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 ;
INSERT INTO `b2b2c`.`vendor_resources_roles`
select max(resources_roles_id)+1 resources_roles_id,683, 2,'2021-04-22 15:25:28' from vendor_resources_roles ;

-- 暂时不用
-- select max(resources_roles_id)+1 resources_roles_id,684, 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,685, 2,'2021-04-22 15:25:28' from vendor_resources_roles ;

-- 腾讯云短信配置
update sys_setting set value = '1400711079' where name = 'notification_sms_app_id';
update sys_setting set value = '华阳生态' where name = 'notification_sms_content_signature';
update sys_setting set value = '1482995' where name = 'notification_sms_tplid';
update sys_setting set value = 'AKIDVpui4e8MJzRcXTGp9E7k9H9l7BzZv1qP' where name = 'notification_sms_secret';
update sys_setting set value = 'OWOzJM9gz2oLeomWzDCwQfeMo0vazHI4' where name = 'notification_sms_secret_key';
INSERT INTO `sys_setting` VALUES ('notification_sms_tplid1', '注册短信模板ID', '1482995', NULL, 1);
INSERT INTO `sys_setting` VALUES ('notification_sms_tplid2', '登入短信模板ID', '1482995', NULL, 1);
INSERT INTO `sys_setting` VALUES ('notification_sms_tplid3', '找回密码短信模板ID', '1483619', NULL, 1);

-- 关闭测试金额
UPDATE sys_setting SET  value = '0' WHERE name = 'alipay_test_enable_h5';
UPDATE sys_setting SET value = '0' WHERE name = 'wxpay_test_enable_h5';

-- 修改店铺佣金
update store_grade set price = '0.01';

-- 直播不显示
-- update sys_system_resource set state = 0 where front_path like '%/bussset_live%'
delete from sys_system_resource where front_path like '%/bussset_live%'