CREATE TABLE LOGIN_ALIAS_TEMP LIKE LOGIN_ALIAS;
INSERT INTO LOGIN_ALIAS_TEMP SELECT * FROM LOGIN_ALIAS GROUP BY ALIAS;
ALTER TABLE LOGIN_ALIAS_TEMP DROP COLUMN TYPE;
ALTER TABLE LOGIN_ALIAS_TEMP DROP COLUMN ROLE_TYPE;
RENAME TABLE LOGIN_ALIAS TO LOGIN_ALIAS_BACKUP;
RENAME TABLE LOGIN_ALIAS_TEMP TO LOGIN_ALIAS;
