ALTER TABLE `sb_personcertificate`
ADD COLUMN `written_score`  int NULL DEFAULT NULL COMMENT '笔试成绩' AFTER `censor_status`,
ADD COLUMN `operate_score`  int NULL DEFAULT NULL COMMENT '实操成绩' AFTER `written_score`,
ADD COLUMN `sum_score`  int NULL DEFAULT NULL COMMENT '总成绩' AFTER `operate_score`,
ADD COLUMN `card_state`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '制证状态   1已制证  0未制证' AFTER `sum_score`,
ADD COLUMN `test_state`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考试状态 1通过0不通过' AFTER `card_state`,
ADD COLUMN `fingercard_state`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '指纹卡号状态1已录0未录' AFTER `test_state`,
ADD COLUMN `fee_state`  varchar(3) NULL DEFAULT NULL COMMENT '缴费状态  1已缴费  0 未缴费' AFTER `fingercard_state`,
ADD COLUMN `exam_state`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '考试安排状态1已安排，0未安排' AFTER `fee_state`;


ALTER TABLE `security_person`
ADD COLUMN `censor_status`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '审查状态003审查通过，004审查不通过' AFTER `areacode`;
