1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- -- 登入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%'
|