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`;

-- 2024-7-9 求职人员认领按钮权限
INSERT INTO sys_function_code VALUES ('T01030109', '求职人员认领', 'T010301', 9);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T01030109');

-- 2024-7-10 求职人员个人荣誉表
CREATE TABLE `pc_honor`  (
  `HonorID` varchar(50) NOT NULL,
  `JobUserID` varchar(50) NULL,
  `HonorName` varchar(255) NULL,
  `GetTime` datetime NULL,
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`HonorID`)
);