ALTER TABLE `sb_personcertificate`
ADD COLUMN `companyid`  int(11) NULL DEFAULT NULL COMMENT '公司ID' AFTER `district`,
ADD COLUMN `personid`  int(11) NULL DEFAULT NULL COMMENT '保安员ID' AFTER `companyid`,
ADD COLUMN `id_card_front`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证正面' AFTER `personid`,
ADD COLUMN `id_card_reverse`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证反面' AFTER `id_card_front`,
ADD COLUMN `health_examination`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '县级以上医院出具的体检证明' AFTER `id_card_reverse`,
ADD COLUMN `edu_photo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '初中以上学历证明原件' AFTER `health_examination`,
ADD COLUMN `nocrime_photo`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '无违法犯罪记录证明' AFTER `edu_photo`;