ALTER TABLE `security_company`
ADD COLUMN `active`  bit(1) NULL DEFAULT 1 AFTER `update_by`;

ALTER TABLE `security_company`
MODIFY COLUMN `human_defense_level`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '人力防范等级' AFTER `company_type`;

ALTER TABLE `user`
DROP INDEX `ak_user_username`;

ALTER TABLE `security_company`
ADD COLUMN `areacode`  varchar(50) NULL AFTER `area`;