java-bbc/db/2024-09-10 菜单按钮权限调整.sql

USE yami_bbc;

# 修改获取用户流量分析详情对应的父级菜单
UPDATE
    `tz_sys_menu`
SET
    `parent_id` = 626
WHERE
    `menu_id` = 1047;

# 补充平台端按钮权限(791对应菜单为客服)
INSERT INTO `tz_sys_menu`(`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`)
VALUES (1187, 791, '', 'platform:order:pageUserOrder', 2, '', 0, 0);

INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`) VALUES
(1187, 0, '分页获取用户订单列表'),
(1187, 1, 'Retrieve user order list through pagination');

# 补充商家端按钮权限(216对应菜单为客服)
INSERT INTO `tz_shop_menu` (`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`)
VALUES (766, 216, '', 'order:order:pageUserOrder', 2, '', 0, 0);

INSERT INTO `tz_shop_menu_lang`(`menu_id`, `lang`, `name`) VALUES
(766, 0, '分页获取用户订单列表'),
(766, 1, 'Retrieve user order list through pagination');