shanxia2.0/docs/sql/insert_menu_storage_entry_info.sql

-- 样本入库信息菜单（位于样本接收信息与储存证管理之间）
-- 注意：插入后需将储存证管理及之后的 order_num +1

-- 1. 新增菜单
INSERT INTO `sys_menu` (
  `id`, `menu_name`, `parent_id`, `menu_type`, `path`, `component`, `perms`,
  `is_frame`, `visible`, `status`, `tenant_no`, `order_num`, `remark`,
  `create_by`, `create_dept_id`, `create_time`, `update_by`, `update_time`, `del_flag`
) VALUES (
  '50000000000000000000000000000012',
  '样本入库信息',
  '50000000000000000000000000000001',
  'C',
  'storage-entry-info',
  '/cell-storage/storage-entry-info/index',
  'cell-storage:storage-entry-info:list',
  1, '1', '1', 'zkxw', 7, NULL,
  NULL, '', NOW(), NULL, NOW(), 0
);

-- 2. 后续菜单 order_num +1
UPDATE `sys_menu` SET `order_num` = `order_num` + 1
WHERE `parent_id` = '50000000000000000000000000000001'
  AND `order_num` >= 7;