2020-019-cf-002.sql 722 B

1234567891011121314
  1. USE DCP;
  2. ALTER TABLE `dcp`.`base_personnel_info`
  3. MODIFY COLUMN `original_duty` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '曾任职务' AFTER `work_unit`;
  4. ALTER TABLE `dcp`.`base_personnel_info`
  5. MODIFY COLUMN `current_duty` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '现任职务' AFTER `original_duty`;
  6. ALTER TABLE `dcp`.`base_personnel_entity`
  7. MODIFY COLUMN `original_duty` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '曾任职务' AFTER `work_unit`;
  8. ALTER TABLE `dcp`.`base_personnel_entity`
  9. MODIFY COLUMN `current_duty` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '现任职务' AFTER `original_duty`;
  10. /*
  11. 已执行161,159
  12. */