-- 2024-5-11招聘会新增字段
ALTER TABLE `pc_jobfairs`
ADD COLUMN `CompanyCount` int NULL COMMENT '企业数量' AFTER `ModifyTime`,
ADD COLUMN `Longitude` varchar(50) NULL COMMENT '经度' AFTER `CompanyCount`,
ADD COLUMN `Latitude` varchar(50) NULL COMMENT '纬度' AFTER `Longitude`;
ALTER TABLE `pc_jobfairs`
ADD COLUMN `BoothCount` int NULL COMMENT '摊位数' AFTER `Latitude`;
ALTER TABLE `pc_jobfairs`
ADD COLUMN `RegionCode` varchar(50) NULL COMMENT '所属县区' AFTER `BoothCount`;
ALTER TABLE `pc_jobfairs`
ADD COLUMN `JobFariDesc` varchar(255) NULL COMMENT '招聘会描述' AFTER `RegionCode`;

--2024.05.11 站点人员新增启用禁用功能
INSERT INTO  sys_function_code (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01010307', '启用禁用', 'T010103', 7);
--角色为市管理、区（县管理员）、驿站机构的所有人员，添加站点人员启用禁用权限
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('1ca3a0c1-167b-4f5e-a31b-ce0c3eee4d80','T01010307');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T01010307');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T01010307');

-- 2024-5-11 招聘会菜单与权限编码添加
INSERT INTO `sys_menu` VALUES ('T0109', 6, '招聘会管理', 'NotificationOutlined', NULL, '/jobFairs', 'T01', NULL, 0, 1, 1, 'T0109', 1, NULL);
INSERT INTO `sys_menu` VALUES ('T010901', 1, '招聘会信息', NULL, 'views/jobFairs/index', '/index', 'T0109', NULL, 0, 0, 1, 'T010901', 1, NULL);
INSERT INTO `sys_menu` VALUES ('T010902', 2, '招聘会新增', NULL, 'views/jobFairs/add', '/add', 'T0109', NULL, 0, 0, 1, 'T010902', 1, NULL);
INSERT INTO `sys_menu` VALUES ('T010903', 3, '招聘会修改', NULL, 'views/jobFairs/edit', '/edit', 'T0109', NULL, 0, 0, 1, 'T010903', 1, NULL);
INSERT INTO `sys_menu` VALUES ('T010905', 4, '招聘会详情', NULL, 'views/jobFairs/detail', '/detail', 'T0109', NULL, 0, 0, 1, 'T010901', 1, NULL);
INSERT INTO sys_function_code VALUES ('T0109', '招聘会管理', 'T01', 4);
INSERT INTO sys_function_code VALUES ('T010901', '查看', 'T0109', 1);
INSERT INTO sys_function_code VALUES ('T010902', '新增', 'T0109', 2);
INSERT INTO sys_function_code VALUES ('T010903', '编辑', 'T0109', 3);
INSERT INTO sys_function_code VALUES ('T010904', '删除', 'T0109', 4);

-- 2024-5-13 角色添加招聘会权限
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T0109');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010901');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010902');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010903');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('02184e9a-1ed8-461f-bfee-ae0c1df11e9e','T010904');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T0109');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010901');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010902');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010903');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('d6f0d433-7a58-497e-b203-d8309edebaba','T010904');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T0109');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('10a12f77-0958-4220-b9ce-07b9215046f2','T010901');