use kgraph;

delete FROM `sys_menu` where menu_name like '%构建流程%';
delete FROM `sys_menu` where menu_name like '%检查点管理%';
delete FROM `sys_menu` where menu_name like '%排故流程%';


INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('检查点管理', 2066, 0, 'piont', 'suport/piont/index', NULL, 1, 0, 'C', '0', '0', 'suport:piont:list', '#', 'admin', '2023-05-28 03:15:20', 'admin', '2023-05-31 03:07:30', '检查点管理菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '检查点管理查询', @parentId, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:piont:query', '#', 'admin', '2023-05-28 03:15:20', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '检查点管理新增', @parentId, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:piont:add', '#', 'admin', '2023-05-28 03:15:20', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '检查点管理修改', @parentId, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:piont:edit', '#', 'admin', '2023-05-28 03:15:20', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '检查点管理删除', @parentId, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:piont:remove', '#', 'admin', '2023-05-28 03:15:20', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '检查点管理导出', @parentId, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:piont:export', '#', 'admin', '2023-05-28 03:15:20', '', NULL, '');

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ('排故流程', 2066, 1, 'flow', 'suport/flow/index', NULL, 1, 0, 'C', '0', '0', 'suport:flow:list', '#', 'admin', '2023-05-28 03:15:47', 'admin', '2023-05-29 08:29:50', '构建流程菜单');

-- 按钮父菜单ID
SELECT @parentId := LAST_INSERT_ID();

INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '构建流程查询', @parentId, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:flow:query', '#', 'admin', '2023-05-28 03:15:47', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '构建流程新增', @parentId, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:flow:add', '#', 'admin', '2023-05-28 03:15:47', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '构建流程修改', @parentId, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:flow:edit', '#', 'admin', '2023-05-28 03:15:47', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '构建流程删除', @parentId, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:flow:remove', '#', 'admin', '2023-05-28 03:15:47', '', NULL, '');
INSERT INTO `sys_menu` (`menu_name`, `parent_id`, `order_num`, `path`, `component`, `query`, `is_frame`, `is_cache`, `menu_type`, `visible`, `status`, `perms`, `icon`, `create_by`, `create_time`, `update_by`, `update_time`, `remark`) VALUES ( '构建流程导出', @parentId, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'suport:flow:export', '#', 'admin', '2023-05-28 03:15:47', '', NULL, '');

commit;
