V2.3.sql

ALTER TABLE `zzgl_log_dgjl`
    ADD COLUMN `type` int(11) NULL COMMENT '1 转正 2调岗 3离职 4岗位删除员工 5 岗位添加员工' AFTER `comment`;

CREATE TABLE `yggl_emp_lzyy`
(
    `id`    int(11) NOT NULL,
    `value` varchar(255) NULL COMMENT '离职原因',
    PRIMARY KEY (`id`)
) COMMENT = '离职原因';

ALTER TABLE `yggl_emp_lzyy`
    MODIFY COLUMN `id` int(11) NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `timer_test`.`yggl_emp_lzyy`
    ADD COLUMN `org_code` int(11) NULL DEFAULT NULL COMMENT '企业Id' AFTER `value`;

ALTER TABLE `yggl_main_lzb`
    ADD COLUMN `lzyy_id` int(11) NULL COMMENT '离职原因Id' AFTER `query`,
MODIFY COLUMN `lzbz` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '离职去向（原离职备注）' AFTER `query`,
MODIFY COLUMN `lzyy` varchar(800) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原因说明（原离职原因）' AFTER `lzbz`;

ALTER TABLE yggl_main_emp`
    ADD COLUMN `zpgl_zj_id` int(11) NULL DEFAULT NULL COMMENT '职级字典id' AFTER `zpgl_gzdd_id`;

ALTER TABLE `timer_test`.`insure_user`
    ADD COLUMN `create_time` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间' AFTER `reason`;

CREATE TABLE ` yggl_main_importLog `  (
  ` id ` int(11) NOT NULL AUTO_INCREMENT,
  ` user_id ` int(11) NULL DEFAULT NULL COMMENT ''yggl_main_emp_empnum'',
  ` create_time ` datetime(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT ''导入时间'',
  ` success_num ` int(11) NULL DEFAULT NULL COMMENT ''成功条数'',
  ` err_num ` int(11) NULL DEFAULT NULL COMMENT ''失败条数'',
  ` org_code ` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (` id `) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

ALTER TABLE `timer_test`.`insure_user`
MODIFY COLUMN `apply_type` int(11) NULL DEFAULT NULL COMMENT '申请类型：1新增 2投保 3批改' AFTER `replace_trans_id`;