fix_menu_group_community.sql
2.89 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
-- 为测试小区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');