java-bbc/db/2024-04-01 客服菜单和短信改造.sql

# ！！看注释
# 短信sms4j改造，执行完sql后，重启服务，重新保存一遍平台端的短信配置

USE yami_bbc;

# 719为平台菜单中客服的菜单
UPDATE tz_sys_menu
SET icon = 'service', order_num = 12
WHERE menu_id = 719;

# 补充授权标识
# 626为'访客分析'
UPDATE tz_sys_menu
SET perms = 'platform:flowUserAnalysis:info'
WHERE
    menu_id = 626;


# 短信改造
update tz_sys_config set param_key = 'SMS_CONFIG', remark = '短信服务配置', param_value = REPLACE(param_value,'}',',\"smsType\":\"alibaba\"}')
where param_key = 'ALIDAYU_CONFIG';

delete from tz_notify_template where send_type in (12, 13 ,14);