USE DCP; ALTER TABLE `base_personnel_entity` ADD COLUMN `id_type` varchar(64) COMMENT '证件类型' AFTER `nationality_dict`, ADD COLUMN `id_number` varchar(64) COMMENT '证件号码' AFTER `id_type`, ADD COLUMN `work_unit` varchar(1000) COMMENT '所在单位' AFTER `id_number`, ADD COLUMN `original_duty` varchar(64) COMMENT '曾任职务' AFTER `work_unit`, ADD COLUMN `current_duty` varchar(64) COMMENT '现任职务' AFTER `original_duty`, ADD COLUMN `photo` varchar(64) COMMENT '照片' AFTER `current_duty`, ADD COLUMN `highest_education` varchar(64) COMMENT '最高学历' AFTER `photo`, ADD COLUMN `highest_education_dict` varchar(64) COMMENT '最高学历代码' AFTER `highest_education`, ADD COLUMN `realname_validated_status` char(1) COMMENT '实名认证状态' AFTER `highest_education_dict` /** 已执行161,159 */