ALTER TABLE `sb_legalchange`
ADD COLUMN `legalcensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原法定代表人审查状态' AFTER `district`,
ADD COLUMN `ndlegalcensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拟定法定代表人审查状态' AFTER `legalcensorstatus`,
ADD COLUMN `chargecensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位负责人审查状态(0 未审查 1 审查通过 2审查不通过）' AFTER `ndlegalcensorstatus`;


ALTER TABLE `sb_crosscompany`
ADD COLUMN `legalcensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人审核状态' AFTER `szss`,
ADD COLUMN `chargecensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位负责人审查状态(0 未审查 1 审查通过 2审查不通过）' AFTER `legalcensorstatus`;


ALTER TABLE `sb_confesscompany`
ADD COLUMN `legalcensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人审查状态' AFTER `szss`,
ADD COLUMN `chargecensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人审查状态' AFTER `legalcensorstatus`;


ALTER TABLE `sb_subsidiary`
ADD COLUMN `legalcensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人审查状态' AFTER `szss`,
ADD COLUMN `chargecensorstatus`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人审查状态' AFTER `legalcensorstatus`;