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%'

-- 支付宝支付关闭
update sys_setting set value = 0 where name = 'alipay_is_enable_h5';
update sys_setting set value = 0 where name = 'alipay_is_enable_pc';

-- 平台端短信消息模板 msg_member_tpl（会员）msg_store_tpl（商户）
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的售后单有新的变化，退款编号：{$afsSn}。"}' where tpl_code = 'after_sale_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"您关注的商品：{1}，马上就要开始了,请进场准备好,谢谢。"}' where tpl_code = 'appointment_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的账户于{$changeTime}发生了资金变动，描述：{$description}，当前可用金额：{$availableBalance}元，冻结金额：{$frozenBalance}元。"}' where tpl_code = 'balance_change_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您有一张优惠券将于{$expireTime}过期。"}' where tpl_code = 'coupon_expired_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的订单：{$orderSn}，已于{$deliveryTime}发货完成。"}' where tpl_code = 'goods_delivery_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的账户于{$changeTime}发生了积分变动，描述：{$description}，当前可用积分：{$availableIntegral}。"}' where tpl_code = 'integral_change_reminder';
update msg_member_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的订单：{$orderSn}，已于{$paymentTime}付款成功。"}' where tpl_code = 'payment_success_reminder';

update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您有新的结算单等待确认，开始时间：{$startTime}，结束时间：{$endTime}，结算单号：{$billSn}。"}' where tpl_code = 'bill_order_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的结算单平台已付款，请注意查收，结算单号：{$billSn}。"}' where tpl_code = 'bill_paid_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的商品没有通过审核。SPU：{$goodsName}。"}' where tpl_code = 'goods_audit_failure_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的商品库存不足，请及时补货。SPU：{$goodsName}，SKU：{$goodsSpec}。"}' where tpl_code = 'goods_stock_warning';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的商品{$goodsName}被违规下架，原因：{$reason}。"}' where tpl_code = 'goods_violation_off_shelf_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的退款单：{$refundSn}超期未处理，已自动同意买家退款申请。"}' where tpl_code = 'member_auto_refund_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的退货单：{$returnSn}超期未处理，已自动同意买家退货申请。"}' where tpl_code = 'member_auto_return_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您有一个退款单需要处理，退款单号：{$refundSn}。"}' where tpl_code = 'member_refund_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的退货单：{$returnSn}不处理收货超期未处理，已自动按弃货处理。"}' where tpl_code = 'member_return_auto_receive_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您有一个退货单需要处理，退货单号：{$returnSn}。"}' where tpl_code = 'member_return_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您有一个新订单需要处理，订单号：{$orderSn}。"}' where tpl_code = 'new_order_reminder';
update msg_store_tpl set sms_content = '{"templateId":"978409","templateContent":"{$siteName}您的店铺{$storeName}将于{$expireTime}到期，请尽快续签。"}' where tpl_code = 'store_end_reminder';

-- 关闭推手功能
update vendor_resources set state = 2 where content like '%推手%';