alter table identity_user add column idnum varchar(50) not null, add constraint unique_identity_user_idnum unique (idnum), DROP INDEX `unique_identity_user_telephone`, MODIFY COLUMN `telephone` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL AFTER `name`; ALTER TABLE `tenant_users` DROP INDEX `unique_tenant_user_telephone`;