java-bbc/db/2024-11-19 移除门店端-消息管理.sql

USE yami_bbc;

# 删除消息管理相关菜单
DELETE FROM tz_shop_menu where menu_id in ('1022', '1023', '1024', '1025', '1026');
# 删除菜单语言
DELETE FROM tz_shop_menu_lang where menu_id in ('1022', '1023', '1024', '1025', '1026');

# 补充平台报表管理菜单
INSERT INTO `tz_sys_menu`(`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`, `router_name`)
VALUES
    (1049, 601, '', 'platform:form:pageRecommend', 2, '', 0, 0, ''),
    (1200, 602, '', 'platform:prodAnalysis:effectInfo', 2, '', 0, 0, '');


INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`)
VALUES
    (1049, 0, '分页获取');
    (1200, 0, '获取趋势详情'),
    (1200, 1, 'Get trend detail');

# 移除门店评分定时任务
USE xxl_job;

delete from xxl_job_info WHERE executor_handler = 'computeStationScore' ;

# !!! 通联支付新增配置，若开启了通联支付，需前往后台通联支付配置页面，重新配置微信支付需要的appId !!!