ALTER TABLE `country` ADD `eu` ENUM( 'n', 'y' ) NOT NULL DEFAULT 'n';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'BE';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'BG';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'DK';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'DE';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'EE';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'FI';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'FR';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'GR';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'IE';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'IT';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'HR';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'LV';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'LT';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'LU';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'MT';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'NL';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'AT';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'PL';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'PT';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'RO';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'SE';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'SK';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'SI';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'ES';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'CZ';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'HU';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'GB';
UPDATE `country` SET `eu` = 'y' WHERE `iso` = 'CY';