EmploymentSite/doc/待更新脚本.txt

-- 68 已更新
-- 2024-8-15 求职人员数据字典新增
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99101', '', 'JobStatus', 5, '升学深造', 5, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99102', '', 'JobStatus', 6, '出国', 6, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a99103', '', 'JobStatus', 7, '应征入伍', 7, 1, 0);
-- 求职人员表新增字段
ALTER TABLE `pc_jobuser` ADD COLUMN `EducationalSystem` INT NULL COMMENT '学制' AFTER `Latitude`,
ADD COLUMN `DifficultSituationID` INT NULL COMMENT '困难状况' AFTER `EducationalSystem`;
ALTER TABLE `pc_jobuser`
ADD COLUMN `OrdinaryPersonTypeID` int NULL COMMENT '人员类别' AFTER `DifficultSituationID`;
ALTER TABLE `pc_jobuser`
ADD COLUMN `EsHouseholdRegistration` varchar(255) NULL COMMENT '入学前户口所在地' AFTER `OrdinaryPersonTypeID`;
-- 求职人员困难状况数据字典
INSERT INTO sys_dictionary value('DifficultSituation', '求职人员困难状况', 201, 1);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10001', '', 'DifficultSituation', 0, '不属于困难情况', 1, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10002', '', 'DifficultSituation', 11, '零就业家庭', 2, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10003', '', 'DifficultSituation', 12, '低保家庭', 3, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10004', '', 'DifficultSituation', 20, '个人残疾', 4, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10005', '', 'DifficultSituation', 40, '农村贫困户', 5, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10006', '', 'DifficultSituation', 50, '优抚对象', 6, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10007', '', 'DifficultSituation', 60, '申请助学贷款', 7, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c2a10008', '', 'DifficultSituation', 90, '其他困难状况', 8, 1, 0);
-- 修改重点人员类别中的普通类别到人员类别字典中
INSERT INTO sys_dictionary value('OrdinaryPersonType', '求职人员类别', 202, 1);
UPDATE sys_dictionary_item SET DictionaryCode = 'OrdinaryPersonType' WHERE DictionaryCode = 'KeyPersonType' AND `Value` IN (1, 2,3,4,5,6,7,8,9,10,11,12);
-- 重点人员类别与普通人员类别增加"其他"类型
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c3b10001', '', 'OrdinaryPersonType', 0, '其他', 1, 1, 0);
INSERT INTO sys_dictionary_item value('36505ec8-966b-11ee-91fc-7085c3b10002', '', 'KeyPersonType', 0, '其他', 1, 1, 0);
-- 修改求职人员的重点人员类别与普通人员类别内容
UPDATE pc_jobuser SET OrdinaryPersonTypeID = KeyPersonTypeID WHERE KeyPersonTypeID IN (1,2,3,4,5,6,7,8,9,10,11,12);
UPDATE pc_jobuser SET OrdinaryPersonTypeID = 0 WHERE KeyPersonTypeID IN (13,14,15,16,17,18,19,20,21,22,23,24);
UPDATE pc_jobuser SET KeyPersonTypeID = 0 WHERE KeyPersonTypeID IN (1,2,3,4,5,6,7,8,9,10,11,12);