ALTER TABLE `security_traincompany`
MODIFY COLUMN `id`  int(11) NOT NULL AUTO_INCREMENT FIRST ,
ADD COLUMN `province`  varchar(50) NULL COMMENT '所在地省代码' AFTER `bz3`,
ADD COLUMN `city`  varchar(50) NULL COMMENT '所在地市代码' AFTER `province`,
ADD COLUMN `district`  varchar(50) NULL COMMENT '所在地县（区）代码' AFTER `city`;

ALTER TABLE `security_traincompany`
MODIFY COLUMN `szss`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在地省市县（区）' AFTER `fwlx`;