delete from hr_code where PARENT_NO='EMPLOYEE_HIGHEST_DEGREE';

insert into hr_code (CODE_NO,CODE_NAME,CODE_ORDER,PARENT_NO)values
('1','名誉博士','1','EMPLOYEE_HIGHEST_DEGREE'),
('2','博士','2','EMPLOYEE_HIGHEST_DEGREE'),
('201','哲学博士学位','201','EMPLOYEE_HIGHEST_DEGREE'),
('202','经济学博士学位','202','EMPLOYEE_HIGHEST_DEGREE'),
('203','法学博士学位','203','EMPLOYEE_HIGHEST_DEGREE'),
('204','教育学博士学位','204','EMPLOYEE_HIGHEST_DEGREE'),
('205','文学博士学位','205','EMPLOYEE_HIGHEST_DEGREE'),
('206','历史学博士学位','206','EMPLOYEE_HIGHEST_DEGREE'),
('207','理学博士学位','207','EMPLOYEE_HIGHEST_DEGREE'),
('208','工学博士学位','208','EMPLOYEE_HIGHEST_DEGREE'),
('209','农学博士学位','209','EMPLOYEE_HIGHEST_DEGREE'),
('210','医学博士学位','210','EMPLOYEE_HIGHEST_DEGREE'),
('211','军事学博士学位','211','EMPLOYEE_HIGHEST_DEGREE'),
('212','管理学博士学位','212','EMPLOYEE_HIGHEST_DEGREE'),
('213','临床医学博士专业学位','213','EMPLOYEE_HIGHEST_DEGREE'),
('214','兽医博士专业学位','214','EMPLOYEE_HIGHEST_DEGREE'),
('215','口腔医学博士专业学位','215','EMPLOYEE_HIGHEST_DEGREE'),
('3','硕士','3','EMPLOYEE_HIGHEST_DEGREE'),
('301','哲学硕士学位','301','EMPLOYEE_HIGHEST_DEGREE'),
('302','经济学硕士学位','302','EMPLOYEE_HIGHEST_DEGREE'),
('303','法学硕士学位','303','EMPLOYEE_HIGHEST_DEGREE'),
('304','教育学硕士学位','304','EMPLOYEE_HIGHEST_DEGREE'),
('305','文学硕士学位','305','EMPLOYEE_HIGHEST_DEGREE'),
('306','历史学硕士学位','306','EMPLOYEE_HIGHEST_DEGREE'),
('307','理学硕士学位','307','EMPLOYEE_HIGHEST_DEGREE'),
('308','工学硕士学位','308','EMPLOYEE_HIGHEST_DEGREE'),
('309','农学硕士学位','309','EMPLOYEE_HIGHEST_DEGREE'),
('310','医学硕士学位','310','EMPLOYEE_HIGHEST_DEGREE'),
('311','军事学硕士学位','311','EMPLOYEE_HIGHEST_DEGREE'),
('312','管理学硕士学位','312','EMPLOYEE_HIGHEST_DEGREE'),
('313','法律硕士专业学位','313','EMPLOYEE_HIGHEST_DEGREE'),
('314','教育硕士专业学位','314','EMPLOYEE_HIGHEST_DEGREE'),
('315','工程硕士专业学位','315','EMPLOYEE_HIGHEST_DEGREE'),
('316','建筑学硕士专业学位','316','EMPLOYEE_HIGHEST_DEGREE'),
('317','临床医学硕士专业学位','317','EMPLOYEE_HIGHEST_DEGREE'),
('318','工商管理硕士专业学位','318','EMPLOYEE_HIGHEST_DEGREE'),
('319','农业推广硕士专业学位','319','EMPLOYEE_HIGHEST_DEGREE'),
('320','兽医硕士专业学位','320','EMPLOYEE_HIGHEST_DEGREE'),
('321','公共管理硕士专业学位','321','EMPLOYEE_HIGHEST_DEGREE'),
('322','口腔医学硕士专业学位','322','EMPLOYEE_HIGHEST_DEGREE'),
('323','公共卫生硕士专业学位','323','EMPLOYEE_HIGHEST_DEGREE'),
('324','军事硕士专业学位','324','EMPLOYEE_HIGHEST_DEGREE'),
('325','会计硕士专业学位','325','EMPLOYEE_HIGHEST_DEGREE'),
('326','体育硕士专业学位','326','EMPLOYEE_HIGHEST_DEGREE'),
('327','艺术硕士专业学位','327','EMPLOYEE_HIGHEST_DEGREE'),
('328','风景园林硕士专业学位','328','EMPLOYEE_HIGHEST_DEGREE'),
('329','汉语国际教育硕士专业学位','329','EMPLOYEE_HIGHEST_DEGREE'),
('330','翻译硕士专业学位','330','EMPLOYEE_HIGHEST_DEGREE'),
('4','学士','4','EMPLOYEE_HIGHEST_DEGREE'),
('401','哲学学士学位','401','EMPLOYEE_HIGHEST_DEGREE'),
('402','经济学学士学位','402','EMPLOYEE_HIGHEST_DEGREE'),
('403','法学学士学位','403','EMPLOYEE_HIGHEST_DEGREE'),
('404','教育学学士学位','404','EMPLOYEE_HIGHEST_DEGREE'),
('405','文学学士学位','405','EMPLOYEE_HIGHEST_DEGREE'),
('406','历史学学士学位','406','EMPLOYEE_HIGHEST_DEGREE'),
('407','理学学士学位','407','EMPLOYEE_HIGHEST_DEGREE'),
('408','工学学士学位','408','EMPLOYEE_HIGHEST_DEGREE'),
('409','农学学士学位','409','EMPLOYEE_HIGHEST_DEGREE'),
('410','医学学士学位','410','EMPLOYEE_HIGHEST_DEGREE'),
('411','军事学学士学位','411','EMPLOYEE_HIGHEST_DEGREE'),
('412','管理学学士学位','412','EMPLOYEE_HIGHEST_DEGREE'),
('413','建筑学学士学位','413','EMPLOYEE_HIGHEST_DEGREE'),
('414','艺术学士学位','414','EMPLOYEE_HIGHEST_DEGREE'),
('9','无','9','EMPLOYEE_HIGHEST_DEGREE')