alter table COUNTRY add column COUNTRY_NATIONALITY longtext;

update COUNTRY set NATIONALITY = '__xpto__' where NATIONALITY is null or NATIONALITY = '';
update COUNTRY set COUNTRY.COUNTRY_NATIONALITY = concat('pt', length(replace(COUNTRY.NATIONALITY, "__xpto__", "")), ':', replace(COUNTRY.NATIONALITY, "__xpto__", "")); 
update COUNTRY set COUNTRY_NATIONALITY = NULL WHERE COUNTRY_NATIONALITY = "pt0:en0:";
update COUNTRY set COUNTRY_NATIONALITY = replace(COUNTRY.COUNTRY_NATIONALITY, "pt0:", "");
update COUNTRY set COUNTRY_NATIONALITY = replace(COUNTRY.COUNTRY_NATIONALITY, "en0:", "");

ALTER TABLE COUNTRY CHANGE COLUMN NAME NAME VARCHAR(255);
ALTER TABLE COUNTRY CHANGE COLUMN NATIONALITY NATIONALITY VARCHAR(255);
ALTER TABLE COUNTRY CHANGE COLUMN CODE CODE VARCHAR(255);
alter table COUNTRY add key `U1` (`NAME`,`NATIONALITY`,`CODE`);
alter table COUNTRY drop column NATIONALITY;