shanxia2.0/backend/scripts/migrate_20261008_rename_plan_cert_menu.sql

-- 将「危化品证上传」菜单更名为「合法使用证明上传」
-- 测试库 / 生产库均可幂等执行

UPDATE `sys_menu`
SET `menu_name` = '合法使用证明上传',
    `remark` = '含易制爆产品的运输计划：上传合法使用证明',
    `order_num` = 4,
    `update_by` = 'system',
    `update_time` = NOW()
WHERE `id` = 'PL_PLAN_CERT'
  AND `del_flag` = 0;

UPDATE `sys_menu`
SET `order_num` = 3,
    `update_by` = 'system',
    `update_time` = NOW()
WHERE `id` = 'PL_PURCHASE_CERT'
  AND `del_flag` = 0;

UPDATE `sys_menu`
SET `menu_name` = '合法使用证明列表',
    `update_by` = 'system',
    `update_time` = NOW()
WHERE `id` = 'E87E4287B1C5440F84F51B3153A246E1'
  AND `del_flag` = 0;

UPDATE `sys_menu`
SET `menu_name` = '上传合法使用证明',
    `update_by` = 'system',
    `update_time` = NOW()
WHERE `id` = 'PL_PLAN_CERT_U'
  AND `del_flag` = 0;