EmploymentSite/doc/待更新脚本.txt

-- 2024-7-8 就业活动类型字典
INSERT INTO `sys_dictionary` VALUES ('JobFairActivityType', '就业活动类型', 109, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78001', '', 'JobFairActivityType', 1, '招聘活动', 1, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78002', '', 'JobFairActivityType', 2, '职业指导活动', 2, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78003', '', 'JobFairActivityType', 3, '政策宣传活动', 3, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78004', '', 'JobFairActivityType', 4, '对接活动', 4, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78005', '', 'JobFairActivityType', 5, '求职者对接活动', 5, 1, 1);
INSERT INTO `sys_dictionary_item` VALUES ('1ecc5294-51f6-4a10-add2-e63f7ac78006', '', 'JobFairActivityType', 6, '其他活动', 6, 1, 1);

-- 2024-7-8 就业活动增加字段
ALTER TABLE `pc_jobfairs` ADD COLUMN `ActivityType` int NULL COMMENT '招聘活动类型' AFTER `JobFariDesc`;
ALTER TABLE `pc_jobfairs` ADD COLUMN `SiteID` varchar(50) NULL COMMENT '所属驿站' AFTER `RegionCode`;