ALTER TABLE `sb_traincompanyapply` DROP COLUMN `gunnum`, ADD COLUMN `gunnum` int(11) NULL DEFAULT NULL COMMENT '防爆枪支数' AFTER `reply_state`, ADD COLUMN `ascriptionvehicle` int(11) NULL DEFAULT NULL COMMENT '专用运输车辆数' AFTER `gunnum`, ADD COLUMN `ascription` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产权归属' AFTER `ascriptionvehicle`; ALTER TABLE `sb_confesscompany` MODIFY COLUMN `Companytype` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `Address`;