java-bbc/db/2023-11-13-添加签约类目审核.sql

USE yami_bbc;

# 添加平台端签约审核配置
insert into `tz_sys_config` (`param_key`, `param_value`, `remark`)
values ('SIGNING_SWITCH_CONFIG', '{\"signingAudit\":false}', '签约类目配置');

# 添加平台菜单 parent_id 415 对应店铺管理
INSERT INTO `tz_sys_menu`(`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`) VALUES
    (947, 415, '', 'shop:sign:audit', 2, '', 0, 0),
    (948, 415, '', 'shop:sign:page', 2, '', 0, 0);

INSERT INTO `tz_sys_menu_lang`(`menu_id`, `lang`, `name`) VALUES
    (947, 0, '审核签约申请'),
    (948, 0, '签约申请审核列表');

# 添加商家菜单 parent_id 24 对应店铺设置
INSERT INTO `tz_shop_menu`(`menu_id`, `parent_id`, `url`, `perms`, `type`, `icon`, `order_num`, `hidden`) VALUES
    (508, 24, '', 'shop:signCategory:view', 2, '', 0, 0),
    (509, 24, '', 'shop:signCategory:cancel', 2, '', 0, 0);

INSERT INTO `tz_shop_menu_lang`(`menu_id`, `lang`, `name`) VALUES
    (508, 0, '查看签约类目申请'),
    (509, 0, '撤销签约类目申请');