v1_migrate_department.sql
16.6 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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (34, 1, '董事办', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (35, 1, '总经办', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (36, 1, '制造中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (37, 1, '采购部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (38, 1, '财务部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (39, 1, '人资部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (40, 1, '行政部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (41, 1, '仓储部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (42, 1, '技术部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (43, 1, '电商部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (44, 1, '品管部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (45, 1, '市场部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (46, 1, '销管部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (47, 1, '物流部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (48, 1, '体验馆', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (49, 1, '生产部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (50, 1, '设备机修', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (51, 1, '生管部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (52, 1, '服务小组', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (53, 1, '财务部', '', 180, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (54, 1, '采购部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (55, 1, '总经办', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (56, 1, '电商部', '', 63, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (57, 1, '董事办', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (58, 1, '产品部', '', 179, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (59, 1, '品管部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (60, 1, '人资部', '', 181, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (61, 1, '体验馆', '', 179, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (62, 1, '行政部', '', 181, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (63, 1, '营销中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (64, 1, '供应链中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (65, 1, '市场部', '', 63, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (66, 1, '仓储部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (67, 1, '销管物流部', '', 63, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (68, 1, '仓储部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (69, 1, '生产部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (70, 1, '设备研发部', '', 179, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (71, 1, '生管部', '', 64, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (72, 1, '销售部', '', 63, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (81, 1, '项目部', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (82, 1, '伴素', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (83, 1, '大客户部', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (84, 1, '北方区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (85, 1, '华北大区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (86, 1, '福建区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (87, 1, '湖南区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (88, 1, '琼粤区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (89, 1, '浙江区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (90, 1, '湖北区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (91, 1, '苏赣区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (92, 1, '鲁皖区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (93, 1, '魔芋线', '', 69, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (113, 1, '陕宁区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (116, 1, '四川区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (121, 1, '黔东南A区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (136, 1, '滇渝区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (147, 1, '黔桂区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (148, 1, '其他区域', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (149, 1, '广西省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (150, 1, '海南省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (151, 1, '河南省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (152, 1, '京津冀省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (178, 1, '信息部', '', 180, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (179, 1, '产品中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (180, 1, '服务中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (181, 1, '人力行政部', '', 180, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (183, 1, '福建省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (184, 1, '广东省区', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (185, 1, '运营中心', '', 0, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (188, 1, '大客户部B', '', 72, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);
INSERT INTO sys.department(id, company_id, name, code, parent_id, department_heads, is_root, sort, created_at, updated_at, deleted_at, version, is_del) VALUES (189, 1, '数据组', '', 180, '[]', false, 1, 1718088344, 1718088344, 0, 0, 0);