watershed_menu_minimal.sql 1.7 KB

123456789101112131415161718192021222324
  1. -- 流域管理模块菜单配置
  2. -- 1. 添加流域管理主菜单
  3. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  4. VALUES (2000, '流域管理', 0, 1, 'watershed', NULL, 'M', '0', '0', '', 'water');
  5. -- 2. 添加流域平台子菜单
  6. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  7. VALUES (2001, '流域平台', 2000, 1, 'hydrological', 'watershed/hydrological/index', 'C', '0', '0', 'watershed:hydrological:list', 'monitor');
  8. -- 3. 添加机电设备管理子菜单
  9. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  10. VALUES (2002, '机电设备', 2000, 2, 'equipment', 'watershed/equipment/index', 'C', '0', '0', 'watershed:equipment:list', 'list');
  11. -- 4. 添加流域模型子菜单
  12. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  13. VALUES (2003, '流域模型', 2000, 3, 'model', 'watershed/model/index', 'C', '0', '0', 'watershed:model:list', 'build');
  14. -- 5. 添加水利设施子菜单
  15. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  16. VALUES (2004, '水利设施', 2000, 4, 'facility', 'watershed/facility/index', 'C', '0', '0', 'watershed:facility:list', 'tree');
  17. -- 6. 添加实时监控子菜单
  18. INSERT INTO SYS_MENU (menu_id, menu_name, parent_id, order_num, path, component, menu_type, visible, status, perms, icon)
  19. VALUES (2005, '实时监控', 2000, 5, 'monitor', 'watershed/monitor/index', 'C', '0', '0', 'watershed:monitor:list', 'chart');