

ALTER TABLE `sb_personcertificate`
MODIFY COLUMN `id`  BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID' FIRST ;

ALTER TABLE `sys_approval`
MODIFY COLUMN `businessid`  bigint(20) NULL DEFAULT NULL COMMENT '业务ID' AFTER `businesstype`;

ALTER TABLE `security_certificate`
MODIFY COLUMN `securitypersonid`  bigint(20) NULL DEFAULT NULL COMMENT '保安员资格证申报ID' AFTER `zzzt`;

ALTER TABLE `sb_family`
MODIFY COLUMN `personcertificateid`  bigint(20) NULL DEFAULT NULL COMMENT '保安员证申请ID' AFTER `post`;


ALTER TABLE `sb_personworkexperience`
MODIFY COLUMN `personcertificateid`  bigint(20) NULL DEFAULT NULL COMMENT '保安员证申请ID' AFTER `post`;


ALTER TABLE `sb_personcertificate`
MODIFY COLUMN `nowAddress`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '现住地址' AFTER `healthStatus`;



