Skip to content
Find file Normal view History Permalink
upd_0072.sql 1.49 KiB
Newer Older
Marius Cramer's avatar
Added country information
Marius Cramer committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 
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';