-- ============================================================
-- 添加前台菜单标识字段
-- ============================================================
ALTER TABLE sys_menu ADD is_front VARCHAR2(1) DEFAULT '0';

-- ============================================================
-- 前台菜单初始化SQL
-- ============================================================

-- 前台首页（路由已在constantRoutes中定义）
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('首页', 0, 0, '/index', 'front/Home', NULL, 1, 0, 'C', '0', '0', 'front:index', 'dashboard', 'admin', SYSDATE, '前台首页', '1');

-- GIS地图展示
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('GIS地图展示', 0, 1, '/gis', 'front/Gis', NULL, 1, 0, 'C', '0', '0', 'front:gis', 'map', 'admin', SYSDATE, 'GIS地图展示', '1');

-- 数据查看
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('数据查看', 0, 2, '/data-common', 'front/DataCommon', NULL, 1, 0, 'C', '0', '0', 'front:data:common', 'table', 'admin', SYSDATE, '数据查看', '1');

-- 数据统计
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('数据统计', 0, 3, '/data-statistics', 'front/DataStatistics', NULL, 1, 0, 'C', '0', '0', 'front:data:statistics', 'chart', 'admin', SYSDATE, '数据统计', '1');

-- 新安江流域
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('新安江流域', 0, 4, '/xaj', 'front/Xaj', NULL, 1, 0, 'C', '0', '0', 'front:xaj', 'component', 'admin', SYSDATE, '新安江流域', '1');

-- 一河三湖
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('一河三湖', 0, 5, '/1h3h', 'front/OneThreeLake', NULL, 1, 0, 'C', '0', '0', 'front:lake', 'component', 'admin', SYSDATE, '一河三湖', '1');

-- 引江济太
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('引江济太', 0, 6, '/yjjt', 'front/Yjjt', NULL, 1, 0, 'C', '0', '0', 'front:yjjt', 'component', 'admin', SYSDATE, '引江济太', '1');

-- 水葫芦
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('水葫芦', 0, 7, '/shl', 'front/Shl', NULL, 1, 0, 'C', '0', '0', 'front:shl', 'component', 'admin', SYSDATE, '水葫芦', '1');

-- 系统管理
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('系统管理', 0, 8, '/systemmanage', 'front/SystemManage', NULL, 1, 0, 'C', '0', '0', 'front:system', 'system', 'admin', SYSDATE, '系统管理', '1');

-- 河湖长制
INSERT INTO sys_menu (menu_name, parent_id, order_num, path, component, query, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, remark, is_front)
VALUES ('河湖长制', 0, 9, '/document', 'front/Document', NULL, 1, 0, 'C', '0', '0', 'front:document', 'documentation', 'admin', SYSDATE, '河湖长制', '1');

COMMIT;