岗位类型更新
新字段
alter table job_category add column `industry` varchar(64) DEFAULT NULL COMMENT '行业';
alter table job_category add column `industry_name` varchar(64) DEFAULT NULL COMMENT '行业';
alter table job_category add column `job_type` varchar(64) DEFAULT NULL COMMENT '支付宝类型';
alter table job_category add column `job_type_name` varchar(64) DEFAULT NULL COMMENT '支付宝类型中文名称';更新job_category
-- 3 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售代表', industry='xiaoshou', job_type='xiaoshoudaibiao' WHERE id=3; -- 4 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售代表', industry='xiaoshou', job_type='xiaoshoudaibiao' WHERE id=4; -- 5 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售-其他', industry='xiaoshou', job_type='xiaoshou-qita' WHERE id=5; -- 6 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售-其他', industry='xiaoshou', job_type='xiaoshou-qita' WHERE id=6; -- 7 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售助理', industry='xiaoshou', job_type='xiaoshouzhuli' WHERE id=7 ; -- 8 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售助理', industry='xiaoshou', job_type='xiaoshouzhuli' WHERE id=8 ; -- 9 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售代表', industry='xiaoshou', job_type='xiaoshoudaibiao' WHERE id=9; -- 10 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='电话销售', industry='xiaoshou', job_type='dianhuaxiaoshou' WHERE id=10; -- 11 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='网络销售', industry='xiaoshou', job_type='wangluoxiaoshou' WHERE id=11; -- 12 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售顾问', industry='xiaoshou', job_type='xiaoshouguwen' WHERE id=12 ; -- 13 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售顾问', industry='xiaoshou', job_type='xiaoshouguwen' WHERE id=13 ; -- 14 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售代表', industry='xiaoshou', job_type='xiaoshoudaibiao' WHERE id=14; -- 15 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售-其他', industry='xiaoshou', job_type='xiaoshou-qita' WHERE id=15; -- 16 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> UPDATE job_category SET industry_name='销售', job_type_name='销售总监', industry='xiaoshou', job_type='xiaoshouzongjian' WHERE id=17 ; -- 17 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售经理', industry='xiaoshou', job_type='xiaoshoujingli' WHERE id=18 ; -- 18 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售经理', industry='xiaoshou', job_type='xiaoshoujingli' WHERE id=19 ; -- 19 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售总监', industry='xiaoshou', job_type='xiaoshouzongjian' WHERE id=20 ; -- 20 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售经理', industry='xiaoshou', job_type='xiaoshoujingli' WHERE id=21 ; -- 21 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==> ; UPDATE job_category SET industry_name='销售', job_type_name='销售经理', industry='xiaoshou', job_type='xiaoshoujingli' WHERE id=22 ; -- 22 -- 2023-05-26 13:56:22 | DEBUG | main | com.sunyard.easyrecruitment.system.mapper.JobCategoryMapper.updateById | ==>
修改于 2023-05-26 06:23:36