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';
|
