人事系统V1.4-220515已上线

ALTER TABLE `hr_staff_track` 
ADD COLUMN `hr_all_user_id` int(0) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'HrAllUser表ID' AFTER `id`;

ALTER TABLE `hr_talent_user` ADD  `interview_depart` varchar(50) NOT NULL DEFAULT '' COMMENT '面试部门id' AFTER `interview_area`;

ALTER TABLE `hr_talent_user` ADD `interview_depart_name` varchar(255) NOT NULL DEFAULT '' COMMENT '面试部门名称' AFTER `interview_depart`;

ALTER TABLE `hr_talent_user` ADD `interview_fail_reason` varchar(30) NOT NULL DEFAULT '' COMMENT '面试未取原因，1未录用，2录用未入职' AFTER `interview_depart_name`;

ALTER TABLE `hr_entry_message` 
ADD COLUMN `manager_userid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 0 COMMENT '钉钉主管领导id' AFTER `dept_id`;

ALTER TABLE `hr_register_user` 
ADD `bank_mobile` char(11) NOT NULL DEFAULT '' COMMENT '开户行手机号' AFTER `bank_name`;

ALTER TABLE `hr_entry_message` ADD `team_tag` varchar(255) NOT NULL DEFAULT '' COMMENT '团队标签' AFTER `sign_company`;

ALTER TABLE `hr_register_user` ADD `avatar` varchar(255) NOT NULL COMMENT '头像' AFTER `name`;

ALTER TABLE `hr_staff_track` modify `change_type` tinyint(2) NOT NULL COMMENT '1 : 部门 2：职位 3：职级 4：入职 5：转正 6：离职 7:合同签约公司';

ALTER TABLE `hr_entry_message` ADD `sign_company_change_date` varchar(20) NOT NULL COMMENT '合同公司变更日期' AFTER `sign_company`;

ALTER TABLE `hr_talent_user` 
ADD COLUMN `interview_status` tinyint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '面试员工类型' AFTER `interview_depart_name`;
ALTER TABLE `hr_talent_user` 
ADD COLUMN `interview_status_i18n` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '面试员工类型中文' AFTER `interview_status`;

CREATE TABLE `hr_all_users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `userid` varchar(25) NOT NULL DEFAULT '' COMMENT '钉钉ID',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT '姓名',
  `mobile` char(11) NOT NULL DEFAULT '' COMMENT '手机号',
  `status` varchar(10) NOT NULL DEFAULT '101' COMMENT '1面试(101面试中102面试未取103面试通过)2在职(201全职正式202兼职203实习204全职试用)3离职(301离职)',
  `register_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '花名册ID',
  `talent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '人才库ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_user` (`name`(191),`mobile`) USING BTREE COMMENT '用户名和手机号',
  KEY `idx_mobile` (`mobile`) USING BTREE COMMENT '手机号',
  KEY `idx_userid` (`userid`) USING BTREE COMMENT '钉钉ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `hr_logs_for_operate` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `before` text NOT NULL COMMENT '修改之前的内容',
  `after` text NOT NULL COMMENT '修改之后的内容',
  `change_module` varchar(50) NOT NULL COMMENT '修改模块 hr人事',
  `change_type` varchar(50) NOT NULL DEFAULT '' COMMENT '修改子模块 register花名册 interview_wait面试中 inner在职 delete离职等',
  `change_time` datetime NOT NULL COMMENT '修改时间',
  `admin_id` int(11) NOT NULL DEFAULT '2' COMMENT '后台管理员ID',
  `userid` varchar(50) NOT NULL DEFAULT '' COMMENT '修改人userid',
  `name` varchar(255) NOT NULL COMMENT '修改人',
  `mobile` varchar(11) NOT NULL COMMENT '修改人手机号',
  `create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_name_mobile` (`name`(191),`mobile`) USING BTREE COMMENT '姓名手机号索引',
  KEY `idx_type` (`change_type`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=209 DEFAULT CHARSET=utf8mb4 COMMENT='操作日志表';

update hr_talent_user set is_hire=0 where is_hire=1;