EmploymentSite/doc/待更新脚本.txt

-- 2024-6-17 求职人员统计菜单与权限数据
INSERT INTO sys_function_code VALUES ('T010504', '求职人员统计', 'T0105', 4);
INSERT INTO `sys_menu` VALUES ('T010504', 4, '求职人员统计', NULL, 'views/statistics/JobUserCount', '/JobUserCount', 'T0105', NULL, 0, 1, 1, 'T010504', 1, NULL,NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010504');

-- 2024-6-18 求职人员服务记录表
CREATE TABLE `employmentsitedb`.`pc_jobuser_service`  (
  `ServiceID` varchar(50) NOT NULL,
  `JobUserID` varchar(50) NULL,
  `ServiceContent` varchar(255) NULL,
  `ServiceTime` datetime NULL,
  `ServiceUserID` varchar(50) NULL,
  `CreateUserID` varchar(50) NULL,
  `CreateTime` datetime NULL,
  `ModifyUserID` varchar(50) NULL,
  `ModifyTime` datetime NULL,
  PRIMARY KEY (`ServiceID`)
);