5.3.2、宁波市

1、添加市节点

宁波市的行政区划代码为330200，其下辖的6个市辖区、2个县和2个县级市的代码分别为：海曙区（330203）、江北区（330205）、北仑区（330206）、镇海区（330211）、鄞州区（330212）、奉化区（330213）、象山县（330225）、宁海县（330226）、余姚市（330281）、慈溪市（330282）

-- 添加市节点
INSERT INTO t_org_tree
(org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag)
VALUES(3302, 'node_sjyj', NULL, NULL, NULL, '宁波市', NULL, 2, NULL, 1, 3302, '1', '01', '3302', 0, 20250616, '2025-06-16 12:30:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

2、添加区（县）节点

海曙区（330203）、江北区（330205）、北仑区（330206）、镇海区（330211）、鄞州区（330212）、奉化区（330213）、象山县（330225）、宁海县（330226）、余姚市（330281）、慈溪市（330282）

INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330203, 'node_jyj', null, null, null, '海曙区', null, 3, null, 3302, 330203, '1', '01', '330203', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330205, 'node_jyj', null, null, null, '江北区', null, 3, null, 3302, 330205, '1', '01', '330205', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330206, 'node_jyj', null, null, null, '北仑区', null, 3, null, 3302, 330206, '1', '01', '330206', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330211, 'node_jyj', null, null, null, '镇海区', null, 3, null, 3302, 330211, '1', '01', '330211', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330212, 'node_jyj', null, null, null, '鄞州区', null, 3, null, 3302, 330212, '1', '01', '330212', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330213, 'node_jyj', null, null, null, '奉化区', null, 3, null, 3302, 330213, '1', '01', '330213', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330225, 'node_jyj', null, null, null, '象山县', null, 3, null, 3302, 330225, '1', '01', '330225', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330226, 'node_jyj', null, null, null, '宁海县', null, 3, null, 3302, 330226, '1', '01', '330226', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330281, 'node_jyj', null, null, null, '余姚市', null, 3, null, 3302, 330281, '1', '01', '330281', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);
INSERT INTO t_org_tree (org_id, org_type, org_code, org_serial_no, org_short_name, org_name, org_icon, org_level, org_intro, org_parent_id, org_order, org_status, source_type, source_value, is_delete, creator, create_time, modifyer, modify_time, tree_stage, term, source_id, school_dept_id, binding_count, status_flag) VALUES (330282, 'node_jyj', null, null, null, '慈溪市', null, 3, null, 3302, 330282, '1', '01', '330282', 0, 1, '2025-06-09 12:30:00', null, null, null, null, null, null, null, null);

4、添加区（县）管理员

• 增加 - 海曙区（330203）超管
• 增加 - 江北区（330205）超管
• 增加 - 北仑区（330206）超管

SET @org_name := '北仑区';
SET @admin_type := '超管';
SET @phone := '10033020699';
SET @idcard := '33020600000000000X';
SET @org_id := (SELECT org_id FROM t_org_tree
WHERE org_name = @org_name and org_type in  ('node_school','node_sydw','node_sjyj','node_jyj'));

call add_admin_user(@admin_type, @phone, @idcard, "{SHA}fHUrarqY8beFwIPC4PZZM9GiiOY=", 10, @org_id, 1);

• 增加 - 镇海区（330211）超管
• 增加 - 鄞州区（330212）超管
• 增加 - 奉化区（330213）超管
• 增加 - 象山县（330225）超管
• 增加 - 宁海县（330226）超管
• 增加 - 余姚市（330281）超管
• 增加 - 慈溪市（330282）超管