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

-- 2024.06.18 企业表新增注册资本类型字段，字典表新增注册资本类型字典
insert into sys_dictionary values ('RegisteredCapitalType','注册资本类型','10','1');
INSERT INTO sys_dictionary_item  VALUES (uuid(), '', 'RegisteredCapitalType', 1, '万元(人民币)', 10, 1, 0),
(uuid(), '', 'RegisteredCapitalType', 2, '万元(港币)', 20, 1, 0),
       (uuid(), '', 'RegisteredCapitalType', 3, '万元(美元)', 30, 1, 0),
       (uuid(), '', 'RegisteredCapitalType', 4, '万元(欧元)', 40, 1, 0),
       (uuid(), '', 'RegisteredCapitalType', 5, '万元(日元)', 50, 1, 0),
       (uuid(), '', 'RegisteredCapitalType', 6, '万元(其他)', 60, 1, 0);

alter table pc_company add column RegisteredCapitalType int  comment '注册资本类型' AFTER RegisteredCapital;
update pc_company set RegisteredCapitalType =1