ALTER TABLE `sb_confesscompany`
MODIFY COLUMN `Legalnationality`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人国籍' AFTER `Legalphone`;



ALTER TABLE `sb_armtrainorg`
ADD COLUMN `orgarea`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '培训场地面积（平方米）' AFTER `policeid`;



ALTER TABLE `sb_confesscompany`
ADD COLUMN `companycode`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位编码' AFTER `chargecensorstatus`,
ADD COLUMN `baorgcode`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理备案机关编码' AFTER `companycode`,
ADD COLUMN `baorgname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '受理备案机关名称' AFTER `baorgcode`,
ADD COLUMN `baorgdate`  datetime NULL DEFAULT NULL COMMENT '备案日期' AFTER `baorgname`;
ADD COLUMN `isauto`  bit(1) NULL DEFAULT NULL COMMENT '是否手动添加（公安）' AFTER `baorgdate`;