ALTER TABLE `sb_firearms`
ADD COLUMN `firearmcertification`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '发证单位' AFTER `firearmsstate`;
ADD COLUMN `usename`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领用人' AFTER `remarks`;
ADD COLUMN `usedate`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领用时间' AFTER `usename`;
ADD COLUMN `useexplain`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '领用说明' AFTER `usedate`;