#删除用户名唯一性索引 ALTER TABLE `user` DROP INDEX `ak_user_username`; ALTER TABLE `sb_sponsorlicense` ADD COLUMN `legalPersonNo` varchar(50) NULL COMMENT '法人身份证号' AFTER `currencybf`; ALTER TABLE `security_company` ADD COLUMN `legalPersonNo` varchar(50) NULL COMMENT '法人身份证号' AFTER `areacode`; update security_company set legalPersonNo = principal_id;