Home Explore Help
Register Sign In
allen
/
kgraph_backgrand
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 72f42cce43
Branches Tags
kgraph_backgran...
/
sql
/
update20230529.sql

update20230529.sql 5.0 KB
History Raw

123456789101112131415161718192021222324252627282930 
  1. use kgraph;
    2. 

  2. 

  3. delete FROM `sys_menu` where menu_name like '%构建流程%';
    4. 

  4. delete FROM `sys_menu` where menu_name like '%检查点管理%';
    5. 

  5. delete FROM `sys_menu` where menu_name like '%排故流程%';
    6. 

  6. 

  7. 

  8. 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', '检查点管理菜单');
    9. 

  9. 

  10. -- 按钮父菜单ID
    11. 

  11. SELECT @parentId := LAST_INSERT_ID();
    12. 

  12. 

  13. 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, '');
    14. 

  14. 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, '');
    15. 

  15. 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, '');
    16. 

  16. 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, '');
    17. 

  17. 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, '');
    18. 

  18. 

  19. 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', '构建流程菜单');
    20. 

  20. 

  21. -- 按钮父菜单ID
    22. 

  22. SELECT @parentId := LAST_INSERT_ID();
    23. 

  23. 

  24. 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, '');
    25. 

  25. 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, '');
    26. 

  26. 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, '');
    27. 

  27. 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, '');
    28. 

  28. 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, '');
    29. 

  29. 

  30. commit;
    31.