java-bbc/db/2023-12-04-修改菜单描述和补充消息模板.sql

USE yami_bbc;

# 修改菜单描述
UPDATE
    `tz_sys_menu_lang`
SET
    `name` = "获取路径分析详情"
WHERE
    `menu_id` = 1046;

UPDATE
    `tz_sys_menu_lang`
SET
    `name` = "获取用户分析详情"
WHERE
    `menu_id` = 1047;


ALTER TABLE `tz_pay_info`
    ADD COLUMN `biz_user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '第三方系统userid';

#消息模板补充
INSERT INTO `tz_notify_template` ( `send_type`, `message`, `template_types`, `template_code`, `mp_code`,`status`, `msg_type`, `create_time`) values
(106, '商品${spuName}已被平台下架，点击去查看。', '3','', '', 1, 2, '2020-07-01 16:43:54'),
(107, '商品${spuName}审核成功，点击去查看。', '3','', '', 1, 2, '2020-07-01 16:43:54'),
(110, '活动${activityName}已被平台下架，点击去查看。', '3','', '', 1, 2, '2020-07-01 16:43:54'),
(111, '活动${activityName}审核成功，点击去查看。', '3','', '', 1, 2, '2020-07-01 16:43:54');