ALTER TABLE `security_person`
MODIFY COLUMN `exp`  int(11) NULL DEFAULT 0 COMMENT '工作年限' AFTER `id_card_reverse`,
MODIFY COLUMN `guard_status`  int(11) NULL DEFAULT 3 COMMENT '在岗状态' AFTER `star_level`;

update security_person set insured = FALSE where insured is null;
update security_person set guard_status = 3 where guard_status is null;
update security_person set exp = 0 where exp is null;

ALTER TABLE `security_person`
MODIFY COLUMN `edu`  int(10) NULL DEFAULT 4 COMMENT '学历' AFTER `blood`;


update security_person set edu='4' where edu is null;