wuye / MicroCommunit

  -- 为测试项目1 (2026051218100021) 和测试项目2 (2026051291650038) 补充6个新菜单组

  -- 执行前检查：这些 gc_id 不应已存在
  
  -- ========================================

  -- 测试项目1 (2026051218100021)

  -- ========================================
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_01', '20260511101', '轨迹监控', '2026051218100021', '测试项目1', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_02', '20260511102', '打卡管理', '2026051218100021', '测试项目1', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_03', '20260511103', '保安巡更', '2026051218100021', '测试项目1', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_04', '20260511104', '保洁作业', '2026051218100021', '测试项目1', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_05', '20260511105', '工单管理', '2026051218100021', '测试项目1', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C1_06', '20260511106', '人员管理', '2026051218100021', '测试项目1', NOW(), '0');

  
  -- ========================================

  -- 测试项目2 (2026051291650038)

  -- ========================================
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_01', '20260511101', '轨迹监控', '2026051291650038', '测试项目2', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_02', '20260511102', '打卡管理', '2026051291650038', '测试项目2', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_03', '20260511103', '保安巡更', '2026051291650038', '测试项目2', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_04', '20260511104', '保洁作业', '2026051291650038', '测试项目2', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_05', '20260511105', '工单管理', '2026051291650038', '测试项目2', NOW(), '0');

  
  INSERT INTO m_menu_group_community (gc_id, g_id, name, community_id, community_name, create_time, status_cd)

  VALUES ('GC_CM_C2_06', '20260511106', '人员管理', '2026051291650038', '测试项目2', NOW(), '0');