mineBusinessMenu.sql 3.6 KB

1234567891011121314151617181920212223242526272829303132
  1. -- 菜单 new SQL
  2. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  3. VALUES (164953884266498, '我的商机', DEFAULT, '69', null, 'mineBusiness', 'business/mineBusiness/index', 'mineBusiness', null, 1, 'business:mineBusiness:list', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  4. -- 按钮 new SQL
  5. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  6. VALUES (164953884266499, '我的商机查询', DEFAULT, 164953884266498, null, '', '', '', null, 3, 'business:mineBusiness:query', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  7. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  8. VALUES (164953884266500, '我的商机新增', DEFAULT, 164953884266498, null, '', '', '', null, 3, 'business:mineBusiness:add', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  9. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  10. VALUES (164953884266501, '我的商机修改', DEFAULT, 164953884266498, null, '', '', '', null, 3, 'business:mineBusiness:edit', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  11. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  12. VALUES (164953884266502, '我的商机删除', DEFAULT, 164953884266498, null, '', '', '', null, 3, 'business:mineBusiness:remove', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  13. INSERT INTO menu (id, menu_name, menu_code, pid, app_id, path, component, router_name, icon, menu_type, perms, is_cache, is_frame, visible, remark, create_by, owner_by, create_time, update_by, update_time, is_delete, enabled, sort)
  14. VALUES (164953884266503, '我的商机导出', DEFAULT, 164953884266498, null, '', '', '', null, 3, 'business:mineBusiness:export', 0, 0, false, ' ', 1, 0, sysdate(), null, null, 0, 1, 1);
  15. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  16. values (0, 1, 1, null, 164953884266498, 1, sysdate(), null, 0);
  17. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  18. values (0, 1, 1, null, 164953884266499, 1, sysdate(), null, 0);
  19. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  20. values (0, 1, 1, null, 164953884266500, 1, sysdate(), null, 0);
  21. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  22. values (0, 1, 1, null, 164953884266501, 1, sysdate(), null, 0);
  23. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  24. values (0, 1, 1, null, 164953884266502, 1, sysdate(), null, 0);
  25. insert into role_menu (is_delete, role_id, sort, update_time, menu_id, create_by, create_time, update_by, enabled)
  26. values (0, 1, 1, null, 164953884266503, 1, sysdate(), null, 0);