-- =====================================================
-- 水利工程运行管理系统 - 业务菜单SQL
-- Dameng (DM)
-- 按旧版 6 大模块组织结构
-- =====================================================

SET IDENTITY_INSERT SYS_MENU ON;

-- =====================================================
-- 根菜单 - 水利工程管理系统
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2000, '水利工程管理系统', 0, 0, 'slgc', null, 'SlgcRoot', 1, 0, 'M', 0, 0, null, 'guide', 'admin', SYSDATE());

-- =====================================================
-- 首页（默认落地页）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2001, '首页', 2000, 0, 'intro', 'index', 'SystemIntro', 1, 0, 'C', 0, 0, null, 'guide', 'admin', SYSDATE());

-- =====================================================
-- 1. 工程基本信息
--    对应旧版 gc_wco_index.html：水库/堤防/水闸/泵站 + WCO
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2100, '工程基本信息', 2000, 1, 'proj', null, 'ProjBase', 1, 0, 'M', 0, 0, null, 'guide', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2101, '工程资料', 2100, 1, 'gc', 'slgc/gc/index', 'ProjGc', 1, 0, 'C', 0, 0, 'slgc:gc:list', 'guide', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2102, '堤防管理', 2100, 2, 'dike', 'slgc/dike/index', 'ProjDike', 1, 0, 'C', 0, 0, 'slgc:dike:list', 'trend', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2103, '水库管理', 2100, 3, 'reservoir', 'slgc/reservoir/index', 'ProjReservoir', 1, 0, 'C', 0, 0, 'slgc:reservoir:list', 'data-analysis', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2104, '水闸管理', 2100, 4, 'pust', 'slgc/pust/index', 'ProjPust', 1, 0, 'C', 0, 0, 'slgc:pust:list', 'switch', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2105, '泵站管理', 2100, 5, 'waga', 'slgc/waga/index', 'ProjWaga', 1, 0, 'C', 0, 0, 'slgc:waga:list', 'setting', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2106, '综合概览', 2100, 6, 'overview', 'slgc/slgc/index', 'ProjOverview', 1, 0, 'C', 0, 0, 'slgc:overview:list', 'guide', 'admin', SYSDATE());

-- WCO 子模块（旧版工程基本信息的数据来源于 WCO API）
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2110, 'WCO工程', 2100, 7, 'wco', null, 'ProjWco', 1, 0, 'M', 0, 0, null, 'list', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2111, 'WCO首页', 2110, 1, 'index', 'slgc/wco/index', 'WcoIndex', 1, 0, 'C', 0, 0, 'slgc:wco:list', 'list', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2112, 'WCO堤防', 2110, 2, 'dike', 'slgc/wco/dike/index', 'WcoDike', 1, 0, 'C', 0, 0, 'slgc:wco:dike:list', 'trend', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2113, 'WCO水闸', 2110, 3, 'pust', 'slgc/wco/pust/index', 'WcoPust', 1, 0, 'C', 0, 0, 'slgc:wco:pust:list', 'switch', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2114, 'WCO水库', 2110, 4, 'reservoir', 'slgc/wco/reservoir/index', 'WcoReservoir', 1, 0, 'C', 0, 0, 'slgc:wco:reservoir:list', 'data-analysis', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2115, 'WCO泵站', 2110, 5, 'waga', 'slgc/wco/waga/index', 'WcoWaga', 1, 0, 'C', 0, 0, 'slgc:wco:waga:list', 'setting', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2116, 'WCO水闸KM', 2110, 6, 'km', 'slgc/wco/km/index', 'WcoKm', 1, 0, 'C', 0, 0, 'slgc:wco:km:list', 'switch', 'admin', SYSDATE());

-- =====================================================
-- 2. 直管工程（对应旧版 monitor.html）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2120, '直管工程', 2000, 2, 'monitor', 'slgc/monitor/index', 'DirectMonitor', 1, 0, 'C', 0, 0, 'slgc:monitor:list', 'monitor', 'admin', SYSDATE());

-- =====================================================
-- 3. 流域重要工程（对应旧版 gis.html + gis_sw.html）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2130, '流域重要工程', 2000, 3, 'gis', null, 'BasinGis', 1, 0, 'M', 0, 0, null, 'guide', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2131, 'GIS工程地图', 2130, 1, 'index', 'slgc/gis/index', 'GisMap', 1, 0, 'C', 0, 0, 'slgc:gis:list', 'guide', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2132, '水质水文监测', 2130, 2, 'water', 'slgc/gis/water', 'GisWater', 1, 0, 'C', 0, 0, 'slgc:gis:water', 'data-line', 'admin', SYSDATE());

-- =====================================================
-- 4. 水利工程管理考核（对应旧版 unit.html：水管单位考核）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2140, '水利工程管理考核', 2000, 4, 'assess', null, 'UnitAssess', 1, 0, 'M', 0, 0, null, 'user', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2141, '用水单位', 2140, 1, 'unit', 'slgc/unit/index', 'AssessUnit', 1, 0, 'C', 0, 0, 'slgc:unit:list', 'user', 'admin', SYSDATE());

-- =====================================================
-- 5. 工程管理标准化（对应旧版 cms_index.html：栏目/文章）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2150, '工程管理标准化', 2000, 5, 'standard', null, 'CmsStandard', 1, 0, 'M', 0, 0, null, 'documentation', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2151, '文章列表', 2150, 1, 'article', 'slgc/cms/article/index', 'CmsArticle', 1, 0, 'C', 0, 0, 'slgc:cms:article:list', 'list', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2152, '栏目管理', 2150, 2, 'category', 'slgc/cms/category/index', 'CmsCategory', 1, 0, 'C', 0, 0, 'slgc:cms:category:list', 'tree', 'admin', SYSDATE());

-- =====================================================
-- 6. 法规标准（对应旧版 szy_doc.html + szy_law.html）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2160, '法规标准', 2000, 6, 'legal', null, 'LegalStandard', 1, 0, 'M', 0, 0, null, 'documentation', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2161, '文档管理', 2160, 1, 'doc', 'slgc/doc/index', 'LegalDoc', 1, 0, 'C', 0, 0, 'slgc:doc:list', 'documentation', 'admin', SYSDATE());
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2162, '法规管理', 2160, 2, 'law', 'slgc/law/index', 'LegalLaw', 1, 0, 'C', 0, 0, 'slgc:law:list', 'documentation', 'admin', SYSDATE());

-- =====================================================
-- 其他功能（旧版也有的独立页面）
-- =====================================================

-- 工程概化图（对应旧版 ght.html）
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2170, '工程概化图', 2000, 7, 'ght', 'slgc/ght/index', 'GhtView', 1, 0, 'C', 0, 0, 'slgc:ght:list', 'list', 'admin', SYSDATE());

-- 工程进度监管（对应旧版 zggc.html）
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2180, '工程进度监管', 2000, 8, 'zggc', null, 'ZggcSupervise', 1, 0, 'M', 0, 0, null, 'warning', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2184, '工程监管', 2180, 3, 'index', 'slgc/zggc/index', 'ZggcList', 1, 0, 'C', 0, 0, 'slgc:zggc:list', 'list', 'admin', SYSDATE());

-- 预警管理
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2190, '预警管理', 2000, 9, 'earlywarning', 'slgc/earlywarning/index', 'EarlyWarning', 1, 0, 'C', 0, 0, 'slgc:earlywarning:list', 'warning', 'admin', SYSDATE());

-- 水功能区
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2200, '水功能区', 2000, 10, 'waterfunc', 'slgc/waterFunction/index', 'WaterFunc', 1, 0, 'C', 0, 0, 'slgc:waterfunc:list', 'data-line', 'admin', SYSDATE());

-- 水文信息
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2210, '水文信息', 2000, 11, 'hydrology', 'slgc/hydrology/index', 'HydrologyInfo', 1, 0, 'C', 0, 0, 'slgc:hydrology:list', 'data-line', 'admin', SYSDATE());

-- 污染源监控
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2220, '污染源监控', 2000, 12, 'wry', 'slgc/wry/index', 'WryMonitor', 1, 0, 'C', 0, 0, 'slgc:wry:list', 'warning', 'admin', SYSDATE());

-- =====================================================
-- 工程进度监管 - 子页面（视频监控、工程附件）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2181, '视频监控', 2180, 1, 'video', 'slgc/zggc/video/index', 'ZggcVideo', 1, 0, 'C', 1, 0, 'slgc:zggc:video', 'monitor', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2182, '工程附件', 2180, 2, 'file', 'slgc/zggc/file/index', 'ZggcFile', 1, 0, 'C', 1, 0, 'slgc:zggc:file', 'upload', 'admin', SYSDATE());

-- 实时指挥中心（对应旧版 zggc_port.html）
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2183, '实时指挥中心', 2180, 0, 'portal', 'slgc/zggc/portal', 'ZggcPortal', 1, 0, 'C', 0, 0, 'slgc:zggc:portal', 'monitor', 'admin', SYSDATE());

-- 流域重要工程 - 子页面（GIS监测、历史、风情、云图、台风）
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2221, 'GIS实时监测', 2130, 3, 'monitor', 'slgc/gis/monitor', 'GisMonitor', 1, 0, 'C', 0, 0, 'slgc:gis:monitor', 'monitor', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2222, 'GIS历史数据查询', 2130, 4, 'history', 'slgc/gis/history', 'GisHistory', 1, 0, 'C', 0, 0, 'slgc:gis:history', 'search', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2223, '风情数据', 2130, 5, 'wind', 'slgc/wind/index', 'WindData', 1, 0, 'C', 0, 0, 'slgc:wind:list', 'trend', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2224, '天气云图', 2130, 6, 'weather', 'slgc/weather/index', 'WeatherCloud', 1, 0, 'C', 0, 0, 'slgc:weather:list', 'cloud', 'admin', SYSDATE());

INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2225, '台风信息', 2130, 7, 'typhoon', 'slgc/typhoon/index', 'TyphoonInfo', 1, 0, 'C', 0, 0, 'slgc:typhoon:list', 'warning', 'admin', SYSDATE());

-- =====================================================
-- 新增：涉河项目管理（对应旧版 shgc，后端 ShgcController）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2230, '涉河项目管理', 2000, 13, 'shgc', 'slgc/shgc/index', 'ShgcMgr', 1, 0, 'C', 0, 0, 'slgc:shgc:list', 'documentation', 'admin', SYSDATE());

-- =====================================================
-- 新增：工程分布数据（对应旧版 gcfb，后端 GCFBController）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2231, '工程分布数据', 2000, 14, 'gcfb', 'slgc/gcfb/index', 'GcfbData', 1, 0, 'C', 0, 0, 'slgc:gcfb:list', 'guide', 'admin', SYSDATE());

-- =====================================================
-- 新增：防洪工程数据库（对应旧版 fhgc，后端 FhgcController）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2232, '防洪工程数据库', 2000, 15, 'fhgc', 'slgc/fhgc/index', 'FhgcDb', 1, 0, 'C', 0, 0, 'slgc:fhgc:list', 'warning', 'admin', SYSDATE());

-- =====================================================
-- 新增：三维数据管理（对应旧版 gis_sw.html，后端 SwController）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2233, '三维数据管理', 2000, 16, 'sw', 'slgc/sw/index', 'SwData', 1, 0, 'C', 0, 0, 'slgc:sw:list', 'data-analysis', 'admin', SYSDATE());

-- =====================================================
-- 新增：水量数据管理（对应旧版 water，后端 WaterController）
-- =====================================================
INSERT INTO SYS_MENU (MENU_ID, MENU_NAME, PARENT_ID, ORDER_NUM, PATH, COMPONENT, ROUTE_NAME, IS_FRAME, IS_CACHE, MENU_TYPE, VISIBLE, STATUS, PERMS, ICON, CREATE_BY, CREATE_TIME)
VALUES (2234, '水量数据管理', 2000, 17, 'water', 'slgc/water/index', 'WaterData', 1, 0, 'C', 0, 0, 'slgc:water:list', 'data-line', 'admin', SYSDATE());

SET IDENTITY_INSERT SYS_MENU OFF;
