-
Notifications
You must be signed in to change notification settings - Fork 0
/
init_position.sql
35 lines (35 loc) · 5.06 KB
/
init_position.sql
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
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0000000000', '总经理', '', null, true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0100000000', '客服经理', '', '0000000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0101000000', '顾客管理员', '', '0100000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0102000000', '信息员', '', '0100000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0200000000', '服务总监', '', '0000000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0201000000', '保险部经理', '', '0200000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0201010000', '事故专员', '', '0201000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0201020000', '电话车险销售员', '','0201000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202000000', '服务经理', '', '0200000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202010000', '非技术内训师', '', '0202000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202020000', '索赔员', '', '0202000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202030000', '前台主管', '', '0202000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202030100', '服务顾问', '', '0202030000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0203030101', '实习服务顾问', '', '0202030100', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202030200', '休息区服务专员', '','0202030000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0202040000', '网络管理员', '', '0202000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0203000000', '配件经理', '', '0200000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0203010000', '库管员', '', '0203000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0203020000', '配件计划员', '', '0203000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204000000', '技术经理', '', '0200000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204010000', '技术内训师', '', '0204000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204020000', '质检员', '', '0204000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030000', '车间主管', '', '0204000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030100', '机电组长', '', '0204030000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030101', '机电技师', '', '0204030100', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030102', '机电学徒', '', '0204030100', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030200', '钣金组长', '', '0204030000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030201', '钣金技师', '', '0204030200', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030202', '钣金学徒', '', '0204030200', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030300', '漆工组长', '', '0204030000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030301', '漆工技师', '', '0204030300', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204030302', '漆工学徒', '', '0204030300', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204040000', 'PDI专员', '', '0204000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204050000', '救急专员', '', '0204000000', true);
INSERT INTO `t_position` (`ID`, `NAME`, `DESCRIPTION`, `LEADER_ID`, `ENABLED`) VALUES('0204060000', '废料收集员', '', '0204000000', true);