update20230529.sql 1.7 KB

123456789101112131415161718
  1. use kgraph;
  2. ---- 按钮 SQL
  3. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  4. values('构建流程查询', @parentId, '1', '#', '', 1, 0, 'F', '0', '0', 'suport:flow:query', '#', 'admin', sysdate(), '', null, '');
  5. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  6. values('构建流程新增', @parentId, '2', '#', '', 1, 0, 'F', '0', '0', 'suport:flow:add', '#', 'admin', sysdate(), '', null, '');
  7. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  8. values('构建流程修改', @parentId, '3', '#', '', 1, 0, 'F', '0', '0', 'suport:flow:edit', '#', 'admin', sysdate(), '', null, '');
  9. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  10. values('构建流程删除', @parentId, '4', '#', '', 1, 0, 'F', '0', '0', 'suport:flow:remove', '#', 'admin', sysdate(), '', null, '');
  11. insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
  12. values('构建流程导出', @parentId, '5', '#', '', 1, 0, 'F', '0', '0', 'suport:flow:export', '#', 'admin', sysdate(), '', null, '');
  13. commit;