SELECT @portugal_id:=ID_INTERNAL FROM COUNTRY WHERE COUNTRY.CODE = 'pt';
UPDATE PARTY SET KEY_NATIONALITY = @portugal_id WHERE KEY_NATIONALITY IS NULL AND OJB_CONCRETE_CLASS LIKE '%PERSON';

ALTER TABLE PARTY CHANGE COLUMN KEY_NATIONALITY KEY_NATIONALITY INT(11) DEFAULT 1;