FuJianModelPlatform/sql/watershed_menu_fixed.sql

-- 流域管理模块菜单配置
-- 1. 添加流域管理主菜单
INSERT INTO "SYS_MENU" VALUES (2000, '流域管理', 0, 1, 'watershed', NULL, '', 1, 0, 'M', '0', '0', '', 'water', 'admin', sysdate, '', NULL, '流域管理目录');

-- 2. 添加流域平台子菜单
INSERT INTO "SYS_MENU" VALUES (2001, '流域平台', 2000, 1, 'hydrological', 'watershed/hydrological/index', '', 1, 0, 'C', '0', '0', 'watershed:hydrological:list', 'monitor', 'admin', sysdate, '', NULL, '流域管理平台菜单');

-- 3. 添加机电设备管理子菜单
INSERT INTO "SYS_MENU" VALUES (2002, '机电设备', 2000, 2, 'equipment', 'watershed/equipment/index', '', 1, 0, 'C', '0', '0', 'watershed:equipment:list', 'list', 'admin', sysdate, '', NULL, '机电设备管理菜单');

-- 4. 添加流域模型管理子菜单
INSERT INTO "SYS_MENU" VALUES (2003, '流域模型', 2000, 3, 'model', 'watershed/model/index', '', 1, 0, 'C', '0', '0', 'watershed:model:list', 'build', 'admin', sysdate, '', NULL, '流域模型管理菜单');

-- 5. 添加水利设施管理子菜单
INSERT INTO "SYS_MENU" VALUES (2004, '水利设施', 2000, 4, 'facility', 'watershed/facility/index', '', 1, 0, 'C', '0', '0', 'watershed:facility:list', 'tree', 'admin', sysdate, '', NULL, '水利设施管理菜单');

-- 6. 流域平台按钮权限
INSERT INTO "SYS_MENU" VALUES (2005, '流域平台查询', 2001, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:query', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2006, '流域平台新增', 2001, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:add', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2007, '流域平台修改', 2001, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:edit', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2008, '流域平台删除', 2001, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:remove', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2009, '流域平台导出', 2001, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:hydrological:export', '#', 'admin', sysdate, '', NULL, '');

-- 7. 机电设备按钮权限
INSERT INTO "SYS_MENU" VALUES (2010, '机电设备查询', 2002, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:query', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2011, '机电设备新增', 2002, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:add', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2012, '机电设备修改', 2002, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:edit', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2013, '机电设备删除', 2002, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:remove', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2014, '机电设备导出', 2002, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:export', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2015, '设备监控', 2002, 6, '', '', '', 1, 0, 'F', '0', '0', 'watershed:equipment:monitor', '#', 'admin', sysdate, '', NULL, '');

-- 8. 流域模型按钮权限
INSERT INTO "SYS_MENU" VALUES (2016, '流域模型查询', 2003, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:query', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2017, '流域模型新增', 2003, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:add', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2018, '流域模型修改', 2003, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:edit', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2019, '流域模型删除', 2003, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:remove', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2020, '流域模型导出', 2003, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:export', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2021, '流域模型上传', 2003, 6, '', '', '', 1, 0, 'F', '0', '0', 'watershed:model:upload', '#', 'admin', sysdate, '', NULL, '');

-- 9. 水利设施按钮权限
INSERT INTO "SYS_MENU" VALUES (2022, '水利设施查询', 2004, 1, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:query', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2023, '水利设施新增', 2004, 2, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:add', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2024, '水利设施修改', 2004, 3, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:edit', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2025, '水利设施删除', 2004, 4, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:remove', '#', 'admin', sysdate, '', NULL, '');
INSERT INTO "SYS_MENU" VALUES (2026, '水利设施导出', 2004, 5, '', '', '', 1, 0, 'F', '0', '0', 'watershed:facility:export', '#', 'admin', sysdate, '', NULL, '');

-- 10. 给管理员角色分配流域管理权限
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2000);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2001);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2002);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2003);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2004);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2005);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2006);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2007);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2008);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2009);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2010);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2011);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2012);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2013);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2014);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2015);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2016);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2017);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2018);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2019);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2020);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2021);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2022);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2023);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2024);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2025);
INSERT INTO "SYS_ROLE_MENU" VALUES (1, 2026);