PATCH - MàJ de la BDD Régions et Dépts Européens.

[LeorLindel]

Voici une mise à jour à effectuer sur votre base de données concernant les régions et départements européens.
Ces régions ou départements tiennent compte de la normalisation ISO 3166-1 et 3166-2.
Leurs noms étant écrit avec les entités HTML, aucun problème d'encodage n'est à craindre.

Effectuer cette requête dans votre panneau PhpMyAdmin via l'onglet SQL :

Code: Tout sélectionner


--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
  `country_id` int(11) NOT NULL auto_increment,
  `name` varchar(128) collate utf8_bin NOT NULL,
  `iso_code_2` varchar(2) collate utf8_bin NOT NULL default '',
  `iso_code_3` varchar(3) collate utf8_bin NOT NULL default '',
  `address_format` text collate utf8_bin NOT NULL,
  PRIMARY KEY  (`country_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`country_id`, `name`, `iso_code_2`, `iso_code_3`, `address_format`) VALUES
(040,'Austria','AT','AUT','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(056,'Belgium','BE','BEL','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(100,'Bulgaria','BG','BGR','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(196,'Cyprus','CY','CYP','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(203,'Czech Republic','CZ','CZE','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(208,'Denmark','DK','DNK','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(233,'Estonia','EE','EST','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(246,'Finland','FI','FIN','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(250,'France','FR','FRA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(276,'Germany','DE','DEU','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(300,'Greece','GR','GRC','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(348,'Hungary','HU','HUN','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(372,'Ireland','IE','IRL','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(380,'Italy','IT','ITA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(428,'Latvia','LV','LVA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(440,'Lithuania','LT','LTU','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(442,'Luxembourg','LU','LUX','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(470,'Malta','MT','MLT','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(528,'Netherlands','NL','NLD','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(616,'Poland','PL','POL','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(620,'Portugal','PT','PRT','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(642,'Romania','RO','ROM','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(703,'Slovakia (Slovak Republic)','SK','SVK','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(705,'Slovenia','SI','SVN','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(724,'Spain','ES','ESP','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(752,'Sweden','SE','SWE','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
(826,'United Kingdom','GB','GBR','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}');


--
-- Table structure for table `zone`
--

DROP TABLE IF EXISTS `zone`;
CREATE TABLE `zone` (
  `zone_id` int(11) NOT NULL auto_increment,
  `country_id` int(11) NOT NULL,
  `code` varchar(32) collate utf8_bin NOT NULL default '',
  `name` varchar(128) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`zone_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Autriche
--

INSERT INTO zone VALUES (NULL,40,'AT-1','Burgenland');
INSERT INTO zone VALUES (NULL,40,'AT-2','Kärnten');
INSERT INTO zone VALUES (NULL,40,'AT-3','Niederöesterreich');
INSERT INTO zone VALUES (NULL,40,'AT-4','Oberöesterreich');
INSERT INTO zone VALUES (NULL,40,'AT-5','Salzburg');
INSERT INTO zone VALUES (NULL,40,'AT-6','Steiermark');
INSERT INTO zone VALUES (NULL,40,'AT-7','Tirol');
INSERT INTO zone VALUES (NULL,40,'AT-8','Vorarlberg');
INSERT INTO zone VALUES (NULL,40,'AT-9','Wien');

--
-- Belgique
--

INSERT INTO zone VALUES (NULL,56,'BE-BRU','Brüssel-Hauptstadt');
INSERT INTO zone VALUES (NULL,56,'BE-VAN','Antwerpen');
INSERT INTO zone VALUES (NULL,56,'BE-VBR','Brabant Wallon');
INSERT INTO zone VALUES (NULL,56,'BE-WHT','Hainaut');
INSERT INTO zone VALUES (NULL,56,'BE-WLG','Liege');
INSERT INTO zone VALUES (NULL,56,'BE-VLI','Limburg');
INSERT INTO zone VALUES (NULL,56,'BE-WLX','Luxembourg');
INSERT INTO zone VALUES (NULL,56,'BE-WNA','Namur');
INSERT INTO zone VALUES (NULL,56,'BE-VOV','Oost-Vlaanderen');
INSERT INTO zone VALUES (NULL,56,'BE-VBR','Vlaams Brabant');
INSERT INTO zone VALUES (NULL,56,'BE-VWV','West-Vlaanderen');

--
-- Bulgarie
--

INSERT INTO zone VALUES (NULL,100,'BG-01','Blagoevgrad');
INSERT INTO zone VALUES (NULL,100,'BG-02','Burgas');
INSERT INTO zone VALUES (NULL,100,'BG-08','Dobrich');
INSERT INTO zone VALUES (NULL,100,'BG-07','Gabrovo');
INSERT INTO zone VALUES (NULL,100,'BG-26','Haskovo');
INSERT INTO zone VALUES (NULL,100,'BG-09','Kardjali');
INSERT INTO zone VALUES (NULL,100,'BG-10','Kyustendil');
INSERT INTO zone VALUES (NULL,100,'BG-11','Lovech');
INSERT INTO zone VALUES (NULL,100,'BG-12','Montana');
INSERT INTO zone VALUES (NULL,100,'BG-13','Pazardjik');
INSERT INTO zone VALUES (NULL,100,'BG-14','Pernik');
INSERT INTO zone VALUES (NULL,100,'BG-15','Pleven');
INSERT INTO zone VALUES (NULL,100,'BG-16','Plovdiv');
INSERT INTO zone VALUES (NULL,100,'BG-17','Razgrad');
INSERT INTO zone VALUES (NULL,100,'BG-18','Ruse');
INSERT INTO zone VALUES (NULL,100,'BG-27','Shumen');
INSERT INTO zone VALUES (NULL,100,'BG-19','Silistra');
INSERT INTO zone VALUES (NULL,100,'BG-20','Sliven');
INSERT INTO zone VALUES (NULL,100,'BG-21','Smolyan');
INSERT INTO zone VALUES (NULL,100,'BG-22','Sofia City');
INSERT INTO zone VALUES (NULL,100,'BG-23','Sofia Province');
INSERT INTO zone VALUES (NULL,100,'BG-24','Stara Zagora');
INSERT INTO zone VALUES (NULL,100,'BG-25','Targovishte');
INSERT INTO zone VALUES (NULL,100,'BG-03','Varna');
INSERT INTO zone VALUES (NULL,100,'BG-04','Veliko Tarnovo');
INSERT INTO zone VALUES (NULL,100,'BG-05','Vidin');
INSERT INTO zone VALUES (NULL,100,'BG-06','Vratza');
INSERT INTO zone VALUES (NULL,100,'BG-28','Yambol');

--
-- Chypre
--

INSERT INTO zone VALUES (NULL,196,'CY-04','Ammochostos');
INSERT INTO zone VALUES (NULL,196,'CY-06','Keryneia');
INSERT INTO zone VALUES (NULL,196,'CY-03','Larnaka');
INSERT INTO zone VALUES (NULL,196,'CY-01','Lefkosia');
INSERT INTO zone VALUES (NULL,196,'CY-02','Lemesos');
INSERT INTO zone VALUES (NULL,196,'CY-05','Pafos');

--
-- République tchèque
--

INSERT INTO zone VALUES (NULL,203,'CZ-US','Ústecký');
INSERT INTO zone VALUES (NULL,203,'CZ-JC','Jihočeský');
INSERT INTO zone VALUES (NULL,203,'CZ-JM','Jihomoravský');
INSERT INTO zone VALUES (NULL,203,'CZ-KA','Karlovarský');
INSERT INTO zone VALUES (NULL,203,'CZ-KR','Královéhradecký');
INSERT INTO zone VALUES (NULL,203,'CZ-LI','Liberecký');
INSERT INTO zone VALUES (NULL,203,'CZ-MO','Moravskoslezský');
INSERT INTO zone VALUES (NULL,203,'CZ-OL','Olomoucký');
INSERT INTO zone VALUES (NULL,203,'CZ-PA','Pardubický');
INSERT INTO zone VALUES (NULL,203,'CZ-PL','Plzeňský');
INSERT INTO zone VALUES (NULL,203,'CZ-PR','Hlavní město Praha');
INSERT INTO zone VALUES (NULL,203,'CZ-ST','Středočeský');
INSERT INTO zone VALUES (NULL,203,'CZ-VY','Vysočina');
INSERT INTO zone VALUES (NULL,203,'CZ-ZL','Zlínský');

--
-- Danemark
--

INSERT INTO zone VALUES (NULL,208,'DK-84','Hovedstaden');
INSERT INTO zone VALUES (NULL,208,'DK-82','Midtjylland');
INSERT INTO zone VALUES (NULL,208,'DK-81','Nordjylland');
INSERT INTO zone VALUES (NULL,208,'DK-85','Sjælland');
INSERT INTO zone VALUES (NULL,208,'DK-83','Syddanmark');

--
-- Estonie
--

INSERT INTO zone VALUES (NULL,233,'EE-37','Harjumaa (Tallinn)');
INSERT INTO zone VALUES (NULL,233,'EE-39','Hiiumaa (Kardla)');
INSERT INTO zone VALUES (NULL,233,'EE-44','Ida-Virumaa (Johvi)');
INSERT INTO zone VALUES (NULL,233,'EE-51','Jarvamaa (Paide)');
INSERT INTO zone VALUES (NULL,233,'EE-49','Jogevamaa (Jogeva)');
INSERT INTO zone VALUES (NULL,233,'EE-59','Laane-Virumaa (Rakvere)');
INSERT INTO zone VALUES (NULL,233,'EE-57','Laanemaa (Haapsalu)');
INSERT INTO zone VALUES (NULL,233,'EE-67','Parnumaa (Parnu)');
INSERT INTO zone VALUES (NULL,233,'EE-65','Polvamaa (Polva)');
INSERT INTO zone VALUES (NULL,233,'EE-70','Raplamaa (Rapla)');
INSERT INTO zone VALUES (NULL,233,'EE-74','Saaremaa (Kuessaare)');
INSERT INTO zone VALUES (NULL,233,'EE-78','Tartumaa (Tartu)');
INSERT INTO zone VALUES (NULL,233,'EE-82','Valgamaa (Valga)');
INSERT INTO zone VALUES (NULL,233,'EE-84','Viljandimaa (Viljandi)');
INSERT INTO zone VALUES (NULL,233,'EE-86','Vorumaa (Voru)');

--
-- Finlande
--

INSERT INTO zone VALUES (NULL,246,'FI-AL','Ahvenanmaan Laani');
INSERT INTO zone VALUES (NULL,246,'FI-ES','Etela-Suomen Laani');
INSERT INTO zone VALUES (NULL,246,'FI-IS','Ita-Suomen Laani');
INSERT INTO zone VALUES (NULL,246,'FI-LS','Lansi-Suomen Laani');
INSERT INTO zone VALUES (NULL,246,'FI-LL','Lapin Lanani');
INSERT INTO zone VALUES (NULL,246,'FI-OL','Oulun Laani');

--
-- France
--

INSERT INTO zone VALUES (NULL,250,'FR-01','Ain');
INSERT INTO zone VALUES (NULL,250,'FR-02','Aisne');
INSERT INTO zone VALUES (NULL,250,'FR-03','Allier');
INSERT INTO zone VALUES (NULL,250,'FR-04','Alpes-de-Haute-Provence');
INSERT INTO zone VALUES (NULL,250,'FR-05','Hautes-Alpes');
INSERT INTO zone VALUES (NULL,250,'FR-06','Alpes-Maritimes');
INSERT INTO zone VALUES (NULL,250,'FR-07','Ardèche');
INSERT INTO zone VALUES (NULL,250,'FR-08','Ardennes');
INSERT INTO zone VALUES (NULL,250,'FR-09','Ariège');
INSERT INTO zone VALUES (NULL,250,'FR-10','Aube');
INSERT INTO zone VALUES (NULL,250,'FR-11','Aude');
INSERT INTO zone VALUES (NULL,250,'FR-12','Aveyron');
INSERT INTO zone VALUES (NULL,250,'FR-13','Bouches-du-Rhône');
INSERT INTO zone VALUES (NULL,250,'FR-14','Calvados');
INSERT INTO zone VALUES (NULL,250,'FR-15','Cantal');
INSERT INTO zone VALUES (NULL,250,'FR-16','Charente');
INSERT INTO zone VALUES (NULL,250,'FR-17','Charente-Maritime');
INSERT INTO zone VALUES (NULL,250,'FR-18','Cher');
INSERT INTO zone VALUES (NULL,250,'FR-19','Corrèze');
INSERT INTO zone VALUES (NULL,250,'FR-2A','Corse-du-Sud');
INSERT INTO zone VALUES (NULL,250,'FR-2B','Haute-Corse');
INSERT INTO zone VALUES (NULL,250,'FR-21','Côte-d''or');
INSERT INTO zone VALUES (NULL,250,'FR-22','Côtes-d''Armor');
INSERT INTO zone VALUES (NULL,250,'FR-23','Creuse');
INSERT INTO zone VALUES (NULL,250,'FR-24','Dordogne');
INSERT INTO zone VALUES (NULL,250,'FR-25','Doubs');
INSERT INTO zone VALUES (NULL,250,'FR-26','Drôme');
INSERT INTO zone VALUES (NULL,250,'FR-27','Eure');
INSERT INTO zone VALUES (NULL,250,'FR-28','Eure-et-Loir');
INSERT INTO zone VALUES (NULL,250,'FR-29','Finistère');
INSERT INTO zone VALUES (NULL,250,'FR-30','Gard');
INSERT INTO zone VALUES (NULL,250,'FR-31','Haute-Garonne');
INSERT INTO zone VALUES (NULL,250,'FR-32','Gers');
INSERT INTO zone VALUES (NULL,250,'FR-33','Gironde');
INSERT INTO zone VALUES (NULL,250,'FR-34','Hérault');
INSERT INTO zone VALUES (NULL,250,'FR-35','Ille-et-Vilaine');
INSERT INTO zone VALUES (NULL,250,'FR-36','Indre');
INSERT INTO zone VALUES (NULL,250,'FR-37','Indre-et-Loire');
INSERT INTO zone VALUES (NULL,250,'FR-38','Isére');
INSERT INTO zone VALUES (NULL,250,'FR-39','Jura');
INSERT INTO zone VALUES (NULL,250,'FR-40','Landes');
INSERT INTO zone VALUES (NULL,250,'FR-41','Loir-et-Cher');
INSERT INTO zone VALUES (NULL,250,'FR-42','Loire');
INSERT INTO zone VALUES (NULL,250,'FR-43','Haute-Loire');
INSERT INTO zone VALUES (NULL,250,'FR-44','Loire-Atlantique');
INSERT INTO zone VALUES (NULL,250,'FR-45','Loiret');
INSERT INTO zone VALUES (NULL,250,'FR-46','Lot');
INSERT INTO zone VALUES (NULL,250,'FR-47','Lot-et-Garonne');
INSERT INTO zone VALUES (NULL,250,'FR-48','Lozère');
INSERT INTO zone VALUES (NULL,250,'FR-49','Maine-et-Loire');
INSERT INTO zone VALUES (NULL,250,'FR-50','Manche');
INSERT INTO zone VALUES (NULL,250,'FR-51','Marne');
INSERT INTO zone VALUES (NULL,250,'FR-52','Haute-Marne');
INSERT INTO zone VALUES (NULL,250,'FR-53','Mayenne');
INSERT INTO zone VALUES (NULL,250,'FR-54','Meurthe-et-Moselle');
INSERT INTO zone VALUES (NULL,250,'FR-55','Meuse');
INSERT INTO zone VALUES (NULL,250,'FR-56','Morbihan');
INSERT INTO zone VALUES (NULL,250,'FR-57','Moselle');
INSERT INTO zone VALUES (NULL,250,'FR-58','Nièvre');
INSERT INTO zone VALUES (NULL,250,'FR-59','Nord');
INSERT INTO zone VALUES (NULL,250,'FR-60','Oise');
INSERT INTO zone VALUES (NULL,250,'FR-61','Orne');
INSERT INTO zone VALUES (NULL,250,'FR-62','Pas-de-Calais');
INSERT INTO zone VALUES (NULL,250,'FR-63','Puy-de-Dôme');
INSERT INTO zone VALUES (NULL,250,'FR-64','Pyrénées-Atlantiques');
INSERT INTO zone VALUES (NULL,250,'FR-65','Hautes-Pyrénées');
INSERT INTO zone VALUES (NULL,250,'FR-66','Pyrénées-Orientales');
INSERT INTO zone VALUES (NULL,250,'FR-67','Bas-Rhin');
INSERT INTO zone VALUES (NULL,250,'FR-68','Haut-Rhin');
INSERT INTO zone VALUES (NULL,250,'FR-69','Rhône');
INSERT INTO zone VALUES (NULL,250,'FR-70','Haute-Saône');
INSERT INTO zone VALUES (NULL,250,'FR-71','Saône-et-Loire');
INSERT INTO zone VALUES (NULL,250,'FR-72','Sarthe');
INSERT INTO zone VALUES (NULL,250,'FR-73','Savoie');
INSERT INTO zone VALUES (NULL,250,'FR-74','Haute-Savoie');
INSERT INTO zone VALUES (NULL,250,'FR-75','Paris');
INSERT INTO zone VALUES (NULL,250,'FR-76','Seine-Maritime');
INSERT INTO zone VALUES (NULL,250,'FR-77','Seine-et-Marne');
INSERT INTO zone VALUES (NULL,250,'FR-78','Yvelines');
INSERT INTO zone VALUES (NULL,250,'FR-79','Deux-Sèvres');
INSERT INTO zone VALUES (NULL,250,'FR-80','Somme');
INSERT INTO zone VALUES (NULL,250,'FR-81','Tarn');
INSERT INTO zone VALUES (NULL,250,'FR-82','Tarn-et-Garonne');
INSERT INTO zone VALUES (NULL,250,'FR-83','Var');
INSERT INTO zone VALUES (NULL,250,'FR-84','Vaucluse');
INSERT INTO zone VALUES (NULL,250,'FR-85','Vendée');
INSERT INTO zone VALUES (NULL,250,'FR-86','Vienne');
INSERT INTO zone VALUES (NULL,250,'FR-87','Haute-Vienne');
INSERT INTO zone VALUES (NULL,250,'FR-88','Vosges');
INSERT INTO zone VALUES (NULL,250,'FR-89','Yonne');
INSERT INTO zone VALUES (NULL,250,'FR-90','Territoire-de-Belfort');
INSERT INTO zone VALUES (NULL,250,'FR-91','Essonne');
INSERT INTO zone VALUES (NULL,250,'FR-92','Hauts-de-Seine');
INSERT INTO zone VALUES (NULL,250,'FR-93','Seine-St-Denis');
INSERT INTO zone VALUES (NULL,250,'FR-94','Val-de-Marne');
INSERT INTO zone VALUES (NULL,250,'FR-95','Val-d''Oise');
INSERT INTO zone VALUES (NULL,250,'FR-GP','Guadeloupe');
INSERT INTO zone VALUES (NULL,250,'FR-MQ','Martinique');
INSERT INTO zone VALUES (NULL,250,'FR-GF','Guyane');
INSERT INTO zone VALUES (NULL,250,'FR-RE','La Réunion');
INSERT INTO zone VALUES (NULL,250,'FR-BL','Saint-Barthélemy');
INSERT INTO zone VALUES (NULL,250,'FR-MF','Saint-Martin');
INSERT INTO zone VALUES (NULL,250,'FR-PM','Saint-Pierre-et-Miquelon');
INSERT INTO zone VALUES (NULL,250,'FR-YT','Mayotte');
INSERT INTO zone VALUES (NULL,250,'FR-TF','Terres-Australes-et-Antarctiques');
INSERT INTO zone VALUES (NULL,250,'FR-WF','Wallis-et-Futuna');
INSERT INTO zone VALUES (NULL,250,'FR-PF','Polynésie-Française');
INSERT INTO zone VALUES (NULL,250,'FR-NC','Nouvelle-Calédonie');

--
-- Allemagne
--

INSERT INTO zone VALUES (NULL,276,'DE-BW','Baden-Württemberg');
INSERT INTO zone VALUES (NULL,276,'DE-BY','Bayern');
INSERT INTO zone VALUES (NULL,276,'DE-BE','Berlin');
INSERT INTO zone VALUES (NULL,276,'DE-BB','Brandenburg');
INSERT INTO zone VALUES (NULL,276,'DE-HB','Bremen');
INSERT INTO zone VALUES (NULL,276,'DE-HH','Hamburg');
INSERT INTO zone VALUES (NULL,276,'DE-HE','Hessen');
INSERT INTO zone VALUES (NULL,276,'DE-MV','Mecklenburg-Vorpommern');
INSERT INTO zone VALUES (NULL,276,'DE-NI','Niedersachsen');
INSERT INTO zone VALUES (NULL,276,'DE-NW','Nordrhein-Westfalen');
INSERT INTO zone VALUES (NULL,276,'DE-RP','Rheinland-Pfalz');
INSERT INTO zone VALUES (NULL,276,'DE-SL','Saarland');
INSERT INTO zone VALUES (NULL,276,'DE-SN','Sachsen');
INSERT INTO zone VALUES (NULL,276,'DE-ST','Sachsen-Anhalt');
INSERT INTO zone VALUES (NULL,276,'DE-SH','Schleswig-Holstein');
INSERT INTO zone VALUES (NULL,276,'DE-TH','Thüringen');

--
-- Grèce
--

INSERT INTO zone VALUES (NULL,300,'GR-13','Achaea');
INSERT INTO zone VALUES (NULL,300,'GR-01','Aetolia-Acarnania');
INSERT INTO zone VALUES (NULL,300,'GR-12','Arcadia');
INSERT INTO zone VALUES (NULL,300,'GR-11','Argolis');
INSERT INTO zone VALUES (NULL,300,'GR-31','Arta');
INSERT INTO zone VALUES (NULL,300,'GR-A1','Athens');
INSERT INTO zone VALUES (NULL,300,'GR-03','Boeotia');
INSERT INTO zone VALUES (NULL,300,'GR-64','Chalkidiki');
INSERT INTO zone VALUES (NULL,300,'GR-94','Chania');
INSERT INTO zone VALUES (NULL,300,'GR-85','Chios');
INSERT INTO zone VALUES (NULL,300,'GR-22','Corfu');
INSERT INTO zone VALUES (NULL,300,'GR-15','Corinthia');
INSERT INTO zone VALUES (NULL,300,'GR-82','Cyclades');
INSERT INTO zone VALUES (NULL,300,'GR-81','Dodecanese');
INSERT INTO zone VALUES (NULL,300,'GR-52','Drama');
INSERT INTO zone VALUES (NULL,300,'GR-A1','East Attica');
INSERT INTO zone VALUES (NULL,300,'GR-04','Euboea');
INSERT INTO zone VALUES (NULL,300,'GR-71','Evros');
INSERT INTO zone VALUES (NULL,300,'GR-05','Evrytania');
INSERT INTO zone VALUES (NULL,300,'GR-63','Florina');
INSERT INTO zone VALUES (NULL,300,'GR-51','Grevena');
INSERT INTO zone VALUES (NULL,300,'GR-91','Heraklion');
INSERT INTO zone VALUES (NULL,300,'GR-14','Ilia');
INSERT INTO zone VALUES (NULL,300,'GR-53','Imathia');
INSERT INTO zone VALUES (NULL,300,'GR-33','Ioannina');
INSERT INTO zone VALUES (NULL,300,'GR-41','Karditsa');
INSERT INTO zone VALUES (NULL,300,'GR-56','Kastoria');
INSERT INTO zone VALUES (NULL,300,'GR-55','Kavala');
INSERT INTO zone VALUES (NULL,300,'GR-23','Kefalonia and Ithaca');
INSERT INTO zone VALUES (NULL,300,'GR-57','Kilkis');
INSERT INTO zone VALUES (NULL,300,'GR-58','Kozani');
INSERT INTO zone VALUES (NULL,300,'GR-16','Laconia');
INSERT INTO zone VALUES (NULL,300,'GR-42','Larissa');
INSERT INTO zone VALUES (NULL,300,'GR-92','Lasithi');
INSERT INTO zone VALUES (NULL,300,'GR-24','Lefkada');
INSERT INTO zone VALUES (NULL,300,'GR-83','Lesbos');
INSERT INTO zone VALUES (NULL,300,'GR-43','Magnesia');
INSERT INTO zone VALUES (NULL,300,'GR-17','Messinia');
INSERT INTO zone VALUES (NULL,300,'GR-59','Pella');
INSERT INTO zone VALUES (NULL,300,'GR-07','Phocis');
INSERT INTO zone VALUES (NULL,300,'GR-06','Phthiotis');
INSERT INTO zone VALUES (NULL,300,'GR-61','Pieria');
INSERT INTO zone VALUES (NULL,300,'GR-69','Piraeus');
INSERT INTO zone VALUES (NULL,300,'GR-34','Preveza');
INSERT INTO zone VALUES (NULL,300,'GR-93','Rethymno');
INSERT INTO zone VALUES (NULL,300,'GR-73','Rhodope');
INSERT INTO zone VALUES (NULL,300,'GR-84','Samos');
INSERT INTO zone VALUES (NULL,300,'GR-62','Serres');
INSERT INTO zone VALUES (NULL,300,'GR-32','Thesprotia');
INSERT INTO zone VALUES (NULL,300,'GR-54','Thessaloniki');
INSERT INTO zone VALUES (NULL,300,'GR-44','Trikala');
INSERT INTO zone VALUES (NULL,300,'GR-A1','West Attica');
INSERT INTO zone VALUES (NULL,300,'GR-72','Xanthi');
INSERT INTO zone VALUES (NULL,300,'GR-21','Zakynthos');

--
-- Hongrie
--

INSERT INTO zone VALUES (NULL,348,'HU-BK','Bács-Kiskun');
INSERT INTO zone VALUES (NULL,348,'HU-BA','Baranya');
INSERT INTO zone VALUES (NULL,348,'HU-BE','Békés');
INSERT INTO zone VALUES (NULL,348,'HU-BZ','Borsod-Abaúj-Zemplén');
INSERT INTO zone VALUES (NULL,348,'HU-CS','Csongrád');
INSERT INTO zone VALUES (NULL,348,'HU-FE','Fejér');
INSERT INTO zone VALUES (NULL,348,'HU-GS','Győr-Moson-Sopron');
INSERT INTO zone VALUES (NULL,348,'HU-HB','Hajdú-Bihar');
INSERT INTO zone VALUES (NULL,348,'HU-HE','Heves');
INSERT INTO zone VALUES (NULL,348,'HU-JN','Jász-Nagykun-Szolnok');
INSERT INTO zone VALUES (NULL,348,'HU-KE','Komárom-Esztergom');
INSERT INTO zone VALUES (NULL,348,'HU-NO','Nógrád');
INSERT INTO zone VALUES (NULL,348,'HU-PE','Pest');
INSERT INTO zone VALUES (NULL,348,'HU-SO','Somogy');
INSERT INTO zone VALUES (NULL,348,'HU-SZ','Szabolcs-Szatmár-Bereg');
INSERT INTO zone VALUES (NULL,348,'HU-TO','Tolna');
INSERT INTO zone VALUES (NULL,348,'HU-VA','Vas');
INSERT INTO zone VALUES (NULL,348,'HU-VE','Veszprém');
INSERT INTO zone VALUES (NULL,348,'HU-ZA','Zala');

--
-- Irlande
--

INSERT INTO zone VALUES (NULL,372,'IE-CW','Carlow');
INSERT INTO zone VALUES (NULL,372,'IE-CN','Cavan');
INSERT INTO zone VALUES (NULL,372,'IE-CE','Clare');
INSERT INTO zone VALUES (NULL,372,'IE-C','Cork');
INSERT INTO zone VALUES (NULL,372,'IE-DL','Donegal');
INSERT INTO zone VALUES (NULL,372,'IE-D','Dublin');
INSERT INTO zone VALUES (NULL,372,'IE-G','Galway');
INSERT INTO zone VALUES (NULL,372,'IE-KY','Kerry');
INSERT INTO zone VALUES (NULL,372,'IE-KE','Kildare');
INSERT INTO zone VALUES (NULL,372,'IE-KK','Kilkenny');
INSERT INTO zone VALUES (NULL,372,'IE-LS','Laois');
INSERT INTO zone VALUES (NULL,372,'IE-LM','Leitrim');
INSERT INTO zone VALUES (NULL,372,'IE-LK','Limerick');
INSERT INTO zone VALUES (NULL,372,'IE-LD','Longford');
INSERT INTO zone VALUES (NULL,372,'IE-LH','Louth');
INSERT INTO zone VALUES (NULL,372,'IE-MO','Mayo');
INSERT INTO zone VALUES (NULL,372,'IE-MH','Meath');
INSERT INTO zone VALUES (NULL,372,'IE-MN','Monaghan');
INSERT INTO zone VALUES (NULL,372,'IE-OY','Offaly');
INSERT INTO zone VALUES (NULL,372,'IE-RN','Roscommon');
INSERT INTO zone VALUES (NULL,372,'IE-SO','Sligo');
INSERT INTO zone VALUES (NULL,372,'IE-TA','Tipperary');
INSERT INTO zone VALUES (NULL,372,'IE-WD','Waterford');
INSERT INTO zone VALUES (NULL,372,'IE-WH','Westmeath');
INSERT INTO zone VALUES (NULL,372,'IE-WX','Wexford');
INSERT INTO zone VALUES (NULL,372,'IE-WW','Wicklow');

--
-- Italie
--

INSERT INTO zone VALUES (NULL,380,'IT-AG','Agrigento');
INSERT INTO zone VALUES (NULL,380,'IT-AL','Alessandria');
INSERT INTO zone VALUES (NULL,380,'IT-AN','Ancona');
INSERT INTO zone VALUES (NULL,380,'IT-AO','Aosta');
INSERT INTO zone VALUES (NULL,380,'IT-AR','Arezzo');
INSERT INTO zone VALUES (NULL,380,'IT-AP','Ascoli Piceno');
INSERT INTO zone VALUES (NULL,380,'IT-AT','Asti');
INSERT INTO zone VALUES (NULL,380,'IT-AV','Avellino');
INSERT INTO zone VALUES (NULL,380,'IT-BA','Bari');
INSERT INTO zone VALUES (NULL,380,'','Barletta-Andria-Trani');
INSERT INTO zone VALUES (NULL,380,'IT-BL','Belluno');
INSERT INTO zone VALUES (NULL,380,'IT-BN','Benevento');
INSERT INTO zone VALUES (NULL,380,'IT-BG','Bergamo');
INSERT INTO zone VALUES (NULL,380,'IT-BI','Biella');
INSERT INTO zone VALUES (NULL,380,'IT-BO','Bologna');
INSERT INTO zone VALUES (NULL,380,'IT-BZ','Bolzano');
INSERT INTO zone VALUES (NULL,380,'IT-BS','Brescia');
INSERT INTO zone VALUES (NULL,380,'IT-BR','Brindisi');
INSERT INTO zone VALUES (NULL,380,'IT-CA','Cagliari');
INSERT INTO zone VALUES (NULL,380,'IT-CL','Caltanissetta');
INSERT INTO zone VALUES (NULL,380,'IT-CB','Campobasso');
INSERT INTO zone VALUES (NULL,380,'IT-CI','Carbonia-Iglesias');
INSERT INTO zone VALUES (NULL,380,'IT-CE','Caserta');
INSERT INTO zone VALUES (NULL,380,'IT-CT','Catania');
INSERT INTO zone VALUES (NULL,380,'IT-CZ','Catanzaro');
INSERT INTO zone VALUES (NULL,380,'IT-CH','Chieti');
INSERT INTO zone VALUES (NULL,380,'IT-CO','Como');
INSERT INTO zone VALUES (NULL,380,'IT-CS','Cosenza');
INSERT INTO zone VALUES (NULL,380,'IT-CR','Cremona');
INSERT INTO zone VALUES (NULL,380,'IT-KR','Crotone');
INSERT INTO zone VALUES (NULL,380,'IT-CN','Cuneo');
INSERT INTO zone VALUES (NULL,380,'IT-EN','Enna');
INSERT INTO zone VALUES (NULL,380,'','Fermo');
INSERT INTO zone VALUES (NULL,380,'IT-FE','Ferrara');
INSERT INTO zone VALUES (NULL,380,'IT-FI','Firenze');
INSERT INTO zone VALUES (NULL,380,'IT-FE','Foggia');
INSERT INTO zone VALUES (NULL,380,'IT-FO','Forlì-Cesena');
INSERT INTO zone VALUES (NULL,380,'IT-FR','Frosinone');
INSERT INTO zone VALUES (NULL,380,'IT-GE','Genova');
INSERT INTO zone VALUES (NULL,380,'IT-GO','Gorizia');
INSERT INTO zone VALUES (NULL,380,'IT-GR','Grosseto');
INSERT INTO zone VALUES (NULL,380,'IT-IM','Imperia');
INSERT INTO zone VALUES (NULL,380,'IT-IS','Isernia');
INSERT INTO zone VALUES (NULL,380,'IT-AQ','L''Aquila');
INSERT INTO zone VALUES (NULL,380,'IT-SP','La Spezia');
INSERT INTO zone VALUES (NULL,380,'IT-LT','Latina');
INSERT INTO zone VALUES (NULL,380,'IT-LE','Lecce');
INSERT INTO zone VALUES (NULL,380,'IT-LC','Lecco');
INSERT INTO zone VALUES (NULL,380,'IT-LI','Livorno');
INSERT INTO zone VALUES (NULL,380,'IT-LO','Lodi');
INSERT INTO zone VALUES (NULL,380,'IT-LU','Lucca');
INSERT INTO zone VALUES (NULL,380,'IT-MC','Macerata');
INSERT INTO zone VALUES (NULL,380,'IT-MN','Mantova');
INSERT INTO zone VALUES (NULL,380,'IT-MS','Massa-Carrara');
INSERT INTO zone VALUES (NULL,380,'IT-MT','Matera');
INSERT INTO zone VALUES (NULL,380,'IT-MA','Medio Campidano');
INSERT INTO zone VALUES (NULL,380,'IT-ME','Messina');
INSERT INTO zone VALUES (NULL,380,'IT-MI','Milano');
INSERT INTO zone VALUES (NULL,380,'IT-MO','Modena');
INSERT INTO zone VALUES (NULL,380,'','Monza e della Brianza');
INSERT INTO zone VALUES (NULL,380,'IT-NA','Napoli');
INSERT INTO zone VALUES (NULL,380,'IT-NO','Novara');
INSERT INTO zone VALUES (NULL,380,'IT-NU','Nuoro');
INSERT INTO zone VALUES (NULL,380,'IT-OG','Ogliastra');
INSERT INTO zone VALUES (NULL,380,'IT-OL','Olbia-Tempio');
INSERT INTO zone VALUES (NULL,380,'IT-OR','Oristano');
INSERT INTO zone VALUES (NULL,380,'IT-PD','Padova');
INSERT INTO zone VALUES (NULL,380,'IT-PA','Palermo');
INSERT INTO zone VALUES (NULL,380,'IT-PR','Parma');
INSERT INTO zone VALUES (NULL,380,'IT-PG','Perugia');
INSERT INTO zone VALUES (NULL,380,'IT-PV','Pavia');
INSERT INTO zone VALUES (NULL,380,'IT-PS','Pesaro e Urbino');
INSERT INTO zone VALUES (NULL,380,'IT-PE','Pescara');
INSERT INTO zone VALUES (NULL,380,'IT-PC','Piacenza');
INSERT INTO zone VALUES (NULL,380,'IT-PI','Pisa');
INSERT INTO zone VALUES (NULL,380,'IT-PT','Pistoia');
INSERT INTO zone VALUES (NULL,380,'IT-PN','Pordenone');
INSERT INTO zone VALUES (NULL,380,'IT-PZ','Potenza');
INSERT INTO zone VALUES (NULL,380,'IT-PO','Prato');
INSERT INTO zone VALUES (NULL,380,'IT-RG','Ragusa');
INSERT INTO zone VALUES (NULL,380,'IT-RA','Ravenna');
INSERT INTO zone VALUES (NULL,380,'IT-RC','Reggio di Calabria');
INSERT INTO zone VALUES (NULL,380,'IT-RE','Reggio Emilia');
INSERT INTO zone VALUES (NULL,380,'IT-RI','Rieti');
INSERT INTO zone VALUES (NULL,380,'IT-RN','Rimini');
INSERT INTO zone VALUES (NULL,380,'IT-RM','Roma');
INSERT INTO zone VALUES (NULL,380,'IT-RO','Rovigo');
INSERT INTO zone VALUES (NULL,380,'IT-SA','Salerno');
INSERT INTO zone VALUES (NULL,380,'IT-SS','Sassari');
INSERT INTO zone VALUES (NULL,380,'IT-SV','Savona');
INSERT INTO zone VALUES (NULL,380,'IT-SI','Siena');
INSERT INTO zone VALUES (NULL,380,'IT-SR','Siracusa');
INSERT INTO zone VALUES (NULL,380,'IT-SO','Sondrio');
INSERT INTO zone VALUES (NULL,380,'IT-TA','Taranto');
INSERT INTO zone VALUES (NULL,380,'IT-TE','Teramo');
INSERT INTO zone VALUES (NULL,380,'IT-TR','Terni');
INSERT INTO zone VALUES (NULL,380,'IT-TO','Torino');
INSERT INTO zone VALUES (NULL,380,'IT-TP','Trapani');
INSERT INTO zone VALUES (NULL,380,'IT-TN','Trento');
INSERT INTO zone VALUES (NULL,380,'IT-TV','Treviso');
INSERT INTO zone VALUES (NULL,380,'IT-TS','Trieste');
INSERT INTO zone VALUES (NULL,380,'IT-UD','Udine');
INSERT INTO zone VALUES (NULL,380,'IT-VA','Varese');
INSERT INTO zone VALUES (NULL,380,'IT-VE','Venezia');
INSERT INTO zone VALUES (NULL,380,'IT-VB','Verbano-Cusio-Ossola');
INSERT INTO zone VALUES (NULL,380,'IT-VC','Vercelli');
INSERT INTO zone VALUES (NULL,380,'IT-VR','Verona');
INSERT INTO zone VALUES (NULL,380,'IT-VV','Vibo Valentia');
INSERT INTO zone VALUES (NULL,380,'IT-VI','Vicenza');
INSERT INTO zone VALUES (NULL,380,'IT-VT','Viterbo');

--
-- Lettonie
--

INSERT INTO zone VALUES (NULL,428,'LV-AI','Aizkraukles');
INSERT INTO zone VALUES (NULL,428,'LV-AL','Aluksnes');
INSERT INTO zone VALUES (NULL,428,'LV-BL','Balvu');
INSERT INTO zone VALUES (NULL,428,'LV-BU','Bauskas');
INSERT INTO zone VALUES (NULL,428,'LV-CE','Cesu');
INSERT INTO zone VALUES (NULL,428,'LV-DGV','Daugavpils');
INSERT INTO zone VALUES (NULL,428,'LV-DO','Dobeles');
INSERT INTO zone VALUES (NULL,428,'LV-GU','Gulbenes');
INSERT INTO zone VALUES (NULL,428,'LV-JK','Jekabpils');
INSERT INTO zone VALUES (NULL,428,'LV-JL','Jelgavas');
INSERT INTO zone VALUES (NULL,428,'LV-KR','Kraslavas');
INSERT INTO zone VALUES (NULL,428,'LV-KU','Kuldigas');
INSERT INTO zone VALUES (NULL,428,'LV-LPX','Liepajas');
INSERT INTO zone VALUES (NULL,428,'LV-LM','Limbazu');
INSERT INTO zone VALUES (NULL,428,'LV-LU','Ludzas');
INSERT INTO zone VALUES (NULL,428,'LV-MA','Madonas');
INSERT INTO zone VALUES (NULL,428,'LV-OG','Ogres');
INSERT INTO zone VALUES (NULL,428,'LV-PR','Preilu');
INSERT INTO zone VALUES (NULL,428,'LV-RE','Rezeknes');
INSERT INTO zone VALUES (NULL,428,'LV-RIX','Rigas');
INSERT INTO zone VALUES (NULL,428,'LV-SA','Saldus');
INSERT INTO zone VALUES (NULL,428,'LV-TA','Talsu');
INSERT INTO zone VALUES (NULL,428,'LV-TU','Tukuma');
INSERT INTO zone VALUES (NULL,428,'LV-VK','Valkas');
INSERT INTO zone VALUES (NULL,428,'LV-VM','Valmieras');
INSERT INTO zone VALUES (NULL,428,'LV-VEN','Ventspils');

--
-- Lituanie
--

INSERT INTO zone VALUES (NULL,440,'LT-AL','Alytaus');
INSERT INTO zone VALUES (NULL,440,'LT-KU','Kauno');
INSERT INTO zone VALUES (NULL,440,'LT-KL','Klaipėdos');
INSERT INTO zone VALUES (NULL,440,'LT-MR','Marijampolės');
INSERT INTO zone VALUES (NULL,440,'LT-PN','Panevėžio');
INSERT INTO zone VALUES (NULL,440,'LT-SA','Šiaulių');
INSERT INTO zone VALUES (NULL,440,'LT-TA','Tauragės');
INSERT INTO zone VALUES (NULL,440,'LT-TE','Telšių');
INSERT INTO zone VALUES (NULL,440,'LT-UT','Utenos');
INSERT INTO zone VALUES (NULL,440,'LT-VL','Vilniaus');

--
-- Luxembourg
--

INSERT INTO zone VALUES (NULL,442,'LU-D','Diekirch');
INSERT INTO zone VALUES (NULL,442,'LU-G','Grevenmacher');
INSERT INTO zone VALUES (NULL,442,'LU-L','Luxembourg');

--
-- Malte
--

INSERT INTO zone VALUES (NULL,470,'MT-01','Attard');
INSERT INTO zone VALUES (NULL,470,'MT-02','Balzan');
INSERT INTO zone VALUES (NULL,470,'MT-03','Birgu');
INSERT INTO zone VALUES (NULL,470,'MT-04','Birkirkara');
INSERT INTO zone VALUES (NULL,470,'MT-05','Birzebbuga');
INSERT INTO zone VALUES (NULL,470,'MT-06','Bormla');
INSERT INTO zone VALUES (NULL,470,'MT-07','Dingli');
INSERT INTO zone VALUES (NULL,470,'MT-08','Fgura');
INSERT INTO zone VALUES (NULL,470,'MT-09','Floriana');
INSERT INTO zone VALUES (NULL,470,'MT-10','Fontana');
INSERT INTO zone VALUES (NULL,470,'MT-11','Gudja');
INSERT INTO zone VALUES (NULL,470,'MT-12','Gzira');
INSERT INTO zone VALUES (NULL,470,'MT-13','Ghain-Sielem');
INSERT INTO zone VALUES (NULL,470,'MT-14','Gharb');
INSERT INTO zone VALUES (NULL,470,'MT-15','Gargur');
INSERT INTO zone VALUES (NULL,470,'MT-16','Ghasri');
INSERT INTO zone VALUES (NULL,470,'MT-17','Gaxaq');
INSERT INTO zone VALUES (NULL,470,'MT-18','Hamrun');
INSERT INTO zone VALUES (NULL,470,'MT-19','Iklin');
INSERT INTO zone VALUES (NULL,470,'MT-20','Isla');
INSERT INTO zone VALUES (NULL,470,'MT-21','Kalkara');
INSERT INTO zone VALUES (NULL,470,'MT-22','Kercem');
INSERT INTO zone VALUES (NULL,470,'MT-23','Kirkop');
INSERT INTO zone VALUES (NULL,470,'MT-24','Lija');
INSERT INTO zone VALUES (NULL,470,'MT-25','Luqa');
INSERT INTO zone VALUES (NULL,470,'MT-26','Marsa');
INSERT INTO zone VALUES (NULL,470,'MT-27','Marsaskala');
INSERT INTO zone VALUES (NULL,470,'MT-28','Marsaxlokk');
INSERT INTO zone VALUES (NULL,470,'MT-29','Mdina');
INSERT INTO zone VALUES (NULL,470,'MT-30','Melliea');
INSERT INTO zone VALUES (NULL,470,'MT-31','Mgarr');
INSERT INTO zone VALUES (NULL,470,'MT-32','Mosta');
INSERT INTO zone VALUES (NULL,470,'MT-33','Mqabba');
INSERT INTO zone VALUES (NULL,470,'MT-34','Msida');
INSERT INTO zone VALUES (NULL,470,'MT-35','Mtarfa');
INSERT INTO zone VALUES (NULL,470,'MT-36','Munxar');
INSERT INTO zone VALUES (NULL,470,'MT-37','Nadur');
INSERT INTO zone VALUES (NULL,470,'MT-38','Naxxar');
INSERT INTO zone VALUES (NULL,470,'MT-39','Paola');
INSERT INTO zone VALUES (NULL,470,'MT-40','Pembroke');
INSERT INTO zone VALUES (NULL,470,'MT-41','Pieta');
INSERT INTO zone VALUES (NULL,470,'QAL','Qala');
INSERT INTO zone VALUES (NULL,470,'QOR','Qormi');
INSERT INTO zone VALUES (NULL,470,'QRE','Qrendi');
INSERT INTO zone VALUES (NULL,470,'RAB','Rabat');
INSERT INTO zone VALUES (NULL,470,'SAF','Safi');
INSERT INTO zone VALUES (NULL,470,'SGI','San Giljan');
INSERT INTO zone VALUES (NULL,470,'SGW','San Gwann');
INSERT INTO zone VALUES (NULL,470,'SLA','San Lawrenz');
INSERT INTO zone VALUES (NULL,470,'MT-51','San Pawl il-Bahar');
INSERT INTO zone VALUES (NULL,470,'MT-52','Sannat');
INSERT INTO zone VALUES (NULL,470,'MT-53','Santa Lucija');
INSERT INTO zone VALUES (NULL,470,'MT-54','Santa Venera');
INSERT INTO zone VALUES (NULL,470,'MT-55','Siggiewi');
INSERT INTO zone VALUES (NULL,470,'MT-56','Sliema');
INSERT INTO zone VALUES (NULL,470,'MT-57','Swieqi');
INSERT INTO zone VALUES (NULL,470,'TXB','Ta Xbiex');
INSERT INTO zone VALUES (NULL,470,'TRX','Tarxien');
INSERT INTO zone VALUES (NULL,470,'VLT','Valletta');
INSERT INTO zone VALUES (NULL,470,'VIC','Victoria');
INSERT INTO zone VALUES (NULL,470,'XEW','Xewkija');
INSERT INTO zone VALUES (NULL,470,'XGJ','Xgajra');
INSERT INTO zone VALUES (NULL,470,'ZBR','Zabbar');
INSERT INTO zone VALUES (NULL,470,'ZBG','Zebbug');
INSERT INTO zone VALUES (NULL,470,'MT-67','Zejtun');
INSERT INTO zone VALUES (NULL,470,'MT-68','Zurrieq');

--
-- Pays-Bas
--

INSERT INTO zone VALUES (NULL,528,'NL-DR','Drenthe');
INSERT INTO zone VALUES (NULL,528,'NL-FL','Flevoland');
INSERT INTO zone VALUES (NULL,528,'NL-FR','Friesland');
INSERT INTO zone VALUES (NULL,528,'NL-GE','Gelderland');
INSERT INTO zone VALUES (NULL,528,'NL-GR','Groningen');
INSERT INTO zone VALUES (NULL,528,'NL-LI','Limburg');
INSERT INTO zone VALUES (NULL,528,'NL-NB','Noord Brabant');
INSERT INTO zone VALUES (NULL,528,'NL-NH','Noord Holland');
INSERT INTO zone VALUES (NULL,528,'NL-OV','Overijssel');
INSERT INTO zone VALUES (NULL,528,'NL-UT','Utrecht');
INSERT INTO zone VALUES (NULL,528,'NL-ZE','Zeeland');
INSERT INTO zone VALUES (NULL,528,'NL-ZH','Zuid Holland');

--
-- Pologne
--

INSERT INTO zone VALUES (NULL,616,'PL-DS','Dolnośląskie');
INSERT INTO zone VALUES (NULL,616,'PL-KP','Kujawsko-Pomorskie');
INSERT INTO zone VALUES (NULL,616,'PL-LD','Łódzkie');
INSERT INTO zone VALUES (NULL,616,'PL-LU','Lubelskie');
INSERT INTO zone VALUES (NULL,616,'PL-LB','Lubuskie');
INSERT INTO zone VALUES (NULL,616,'PL-MA','Małopolskie');
INSERT INTO zone VALUES (NULL,616,'PL-MZ','Mazowieckie');
INSERT INTO zone VALUES (NULL,616,'PL-OP','Opolskie');
INSERT INTO zone VALUES (NULL,616,'PL-PK','Podkarpackie');
INSERT INTO zone VALUES (NULL,616,'PL-PD','Podlaskie');
INSERT INTO zone VALUES (NULL,616,'PL-PM','Pomorskie');
INSERT INTO zone VALUES (NULL,616,'PL-SL','Slaskie');
INSERT INTO zone VALUES (NULL,616,'PL-SK','Świętokrzyskie');
INSERT INTO zone VALUES (NULL,616,'PL-WN','Warmińsko-Mazurskie');
INSERT INTO zone VALUES (NULL,616,'PL-WP','Wielkopolskie');
INSERT INTO zone VALUES (NULL,616,'PL-ZP','Zachodniopomorskie');

--
-- Portugal
--

INSERT INTO zone VALUES (NULL,620,'PT-20','Açores');
INSERT INTO zone VALUES (NULL,620,'PT-01','Aveiro');
INSERT INTO zone VALUES (NULL,620,'PT-02','Beja');
INSERT INTO zone VALUES (NULL,620,'PT-03','Braga');
INSERT INTO zone VALUES (NULL,620,'PT-04','Bragança');
INSERT INTO zone VALUES (NULL,620,'PT-05','Castelo Branco');
INSERT INTO zone VALUES (NULL,620,'PT-06','Coimbra');
INSERT INTO zone VALUES (NULL,620,'PT-07','Évora');
INSERT INTO zone VALUES (NULL,620,'PT-08','Faro');
INSERT INTO zone VALUES (NULL,620,'PT-09','Guarda');
INSERT INTO zone VALUES (NULL,620,'PT-10','Leiria');
INSERT INTO zone VALUES (NULL,620,'PT-11','Lisboa');
INSERT INTO zone VALUES (NULL,620,'PT-30','Madeira');
INSERT INTO zone VALUES (NULL,620,'PT-12','Portalegre');
INSERT INTO zone VALUES (NULL,620,'PT-13','Porto');
INSERT INTO zone VALUES (NULL,620,'PT-14','Santarém');
INSERT INTO zone VALUES (NULL,620,'PT-15','Setúbal');
INSERT INTO zone VALUES (NULL,620,'PT-16','Viana do Castelo');
INSERT INTO zone VALUES (NULL,620,'PT-17','Vila Real');
INSERT INTO zone VALUES (NULL,620,'PT-18','Viseu');

--
-- Roumanie
--

INSERT INTO zone VALUES (NULL,642,'RO-AB','Alba');
INSERT INTO zone VALUES (NULL,642,'RO-AR','Arad');
INSERT INTO zone VALUES (NULL,642,'RO-AG','Arges');
INSERT INTO zone VALUES (NULL,642,'RO-BC','Bacau');
INSERT INTO zone VALUES (NULL,642,'RO-BH','Bihor');
INSERT INTO zone VALUES (NULL,642,'RO-BN','Bistriţa-Năsăud');
INSERT INTO zone VALUES (NULL,642,'RO-BT','Botoşani');
INSERT INTO zone VALUES (NULL,642,'RO-BV','Braşov');
INSERT INTO zone VALUES (NULL,642,'RO-BR','Brăila');
INSERT INTO zone VALUES (NULL,642,'RO-B','Bucureşti');
INSERT INTO zone VALUES (NULL,642,'RO-BZ','Buzău');
INSERT INTO zone VALUES (NULL,642,'RO-CS','Caraş-Severin');
INSERT INTO zone VALUES (NULL,642,'RO-CL','Călăraşi');
INSERT INTO zone VALUES (NULL,642,'RO-CJ','Cluj');
INSERT INTO zone VALUES (NULL,642,'RO-CT','Constanţa');
INSERT INTO zone VALUES (NULL,642,'RO-CV','Covasna');
INSERT INTO zone VALUES (NULL,642,'RO-DB','Dâmboviţa');
INSERT INTO zone VALUES (NULL,642,'RO-DJ','Dolj');
INSERT INTO zone VALUES (NULL,642,'RO-GL','Galaţi');
INSERT INTO zone VALUES (NULL,642,'RO-GR','Giurgiu');
INSERT INTO zone VALUES (NULL,642,'RO-GJ','Gorj');
INSERT INTO zone VALUES (NULL,642,'RO-HR','Harghita');
INSERT INTO zone VALUES (NULL,642,'RO-HD','Hunedoara');
INSERT INTO zone VALUES (NULL,642,'RO-IL','Ialomiţa');
INSERT INTO zone VALUES (NULL,642,'RO-IS','Iaşi');
INSERT INTO zone VALUES (NULL,642,'RO-IF','Ilfov');
INSERT INTO zone VALUES (NULL,642,'RO-MM','Maramureş');
INSERT INTO zone VALUES (NULL,642,'RO-MH','Mehedinţi');
INSERT INTO zone VALUES (NULL,642,'RO-MS','Mureş');
INSERT INTO zone VALUES (NULL,642,'RO-NT','Neamţ');
INSERT INTO zone VALUES (NULL,642,'RO-OT','Olt');
INSERT INTO zone VALUES (NULL,642,'RO-PH','Prahova');
INSERT INTO zone VALUES (NULL,642,'RO-SM','Satu-Mare');
INSERT INTO zone VALUES (NULL,642,'RO-SJ','Sălaj');
INSERT INTO zone VALUES (NULL,642,'RO-SB','Sibiu');
INSERT INTO zone VALUES (NULL,642,'RO-SV','Suceava');
INSERT INTO zone VALUES (NULL,642,'RO-TR','Teleorman');
INSERT INTO zone VALUES (NULL,642,'RO-TM','Timiş');
INSERT INTO zone VALUES (NULL,642,'RO-TL','Tulcea');
INSERT INTO zone VALUES (NULL,642,'RO-VS','Vaslui');
INSERT INTO zone VALUES (NULL,642,'RO-VL','Valcea');
INSERT INTO zone VALUES (NULL,642,'RO-VN','Vrancea');

--
-- Slovaquie
--

INSERT INTO zone VALUES (NULL,703,'SK-BC','Banskobystrický');
INSERT INTO zone VALUES (NULL,703,'SK-BL','Bratislavský');
INSERT INTO zone VALUES (NULL,703,'SK-KI','Košický');
INSERT INTO zone VALUES (NULL,703,'SK-NI','Nitriansky');
INSERT INTO zone VALUES (NULL,703,'SK-PV','Prešovský');
INSERT INTO zone VALUES (NULL,703,'SK-TC','Trenčiansky');
INSERT INTO zone VALUES (NULL,703,'SK-TA','Trnavský');
INSERT INTO zone VALUES (NULL,703,'SK-ZI','Žilinský');

--
-- Slovénie
--

INSERT INTO zone VALUES (NULL,705,'','Gorenjska');
INSERT INTO zone VALUES (NULL,705,'','Goriška');
INSERT INTO zone VALUES (NULL,705,'','Jugovzhodna Slovenija');
INSERT INTO zone VALUES (NULL,705,'','Koroška');
INSERT INTO zone VALUES (NULL,705,'','Notranjsko-kraška');
INSERT INTO zone VALUES (NULL,705,'','Obalno-kraška');
INSERT INTO zone VALUES (NULL,705,'','Osrednjeslovenska');
INSERT INTO zone VALUES (NULL,705,'','Podravska');
INSERT INTO zone VALUES (NULL,705,'','Pomurska');
INSERT INTO zone VALUES (NULL,705,'','Savinjska');
INSERT INTO zone VALUES (NULL,705,'','Spodnjeposavska');
INSERT INTO zone VALUES (NULL,705,'','Zasavska');

--
-- Espagne
--

INSERT INTO zone VALUES (NULL, 724,'ES-AV','Álava');
INSERT INTO zone VALUES (NULL, 724,'ES-AB','Albacete');
INSERT INTO zone VALUES (NULL, 724,'ES-A','Alicante');
INSERT INTO zone VALUES (NULL, 724,'ES-AL','Almeria');
INSERT INTO zone VALUES (NULL, 724,'ES-O','Asturias');
INSERT INTO zone VALUES (NULL, 724,'ES-VI','Ávila');
INSERT INTO zone VALUES (NULL, 724,'ES-BA','Badajoz');
INSERT INTO zone VALUES (NULL, 724,'ES-B','Barcelona');
INSERT INTO zone VALUES (NULL, 724,'ES-BU','Burgos');
INSERT INTO zone VALUES (NULL, 724,'ES-CC','Cáceres');
INSERT INTO zone VALUES (NULL, 724,'ES-CA','Cádiz');
INSERT INTO zone VALUES (NULL, 724,'ES-S','Cantabria');
INSERT INTO zone VALUES (NULL, 724,'ES-CS','Castellón');
INSERT INTO zone VALUES (NULL, 724,'ES-CE','Ceuta');
INSERT INTO zone VALUES (NULL, 724,'ES-CR','Ciudad Real');
INSERT INTO zone VALUES (NULL, 724,'ES-CO','Córdoba');
INSERT INTO zone VALUES (NULL, 724,'ES-CU','Cuenca');
INSERT INTO zone VALUES (NULL, 724,'ES-GI','Girona');
INSERT INTO zone VALUES (NULL, 724,'ES-GR','Granada');
INSERT INTO zone VALUES (NULL, 724,'ES-GU','Guadalajara');
INSERT INTO zone VALUES (NULL, 724,'ES-SS','Guipúzcoa');
INSERT INTO zone VALUES (NULL, 724,'ES-H','Huelva');
INSERT INTO zone VALUES (NULL, 724,'ES-HU','Huesca');
INSERT INTO zone VALUES (NULL, 724,'ES-PM','Islas Baleares');
INSERT INTO zone VALUES (NULL, 724,'ES-J','Jaén');
INSERT INTO zone VALUES (NULL, 724,'ES-C','La Coruña');
INSERT INTO zone VALUES (NULL, 724,'ES-LO','La Rioja');
INSERT INTO zone VALUES (NULL, 724,'ES-GC','Las Palmas');
INSERT INTO zone VALUES (NULL, 724,'ES-LE','León');
INSERT INTO zone VALUES (NULL, 724,'ES-L','Lleida');
INSERT INTO zone VALUES (NULL, 724,'ES-LU','Lugo');
INSERT INTO zone VALUES (NULL, 724,'ES-M','Madrid');
INSERT INTO zone VALUES (NULL, 724,'ES-MA','Málaga');
INSERT INTO zone VALUES (NULL, 724,'ES-ML','Melilla');
INSERT INTO zone VALUES (NULL, 724,'ES-MU','Murcia');
INSERT INTO zone VALUES (NULL, 724,'ES-NA','Navarra');
INSERT INTO zone VALUES (NULL, 724,'ES-OR','Ourense');
INSERT INTO zone VALUES (NULL, 724,'ES-P','Palencia');
INSERT INTO zone VALUES (NULL, 724,'ES-PO','Pontevedra');
INSERT INTO zone VALUES (NULL, 724,'ES-SA','Salamanca');
INSERT INTO zone VALUES (NULL, 724,'ES-TF','Santa Cruz de Tenerife');
INSERT INTO zone VALUES (NULL, 724,'ES-SG','Segovia');
INSERT INTO zone VALUES (NULL, 724,'ES-SE','Sevilla');
INSERT INTO zone VALUES (NULL, 724,'ES-SO','Soria');
INSERT INTO zone VALUES (NULL, 724,'ES-T','Tarragona');
INSERT INTO zone VALUES (NULL, 724,'ES-TE','Teruel');
INSERT INTO zone VALUES (NULL, 724,'ES-TO','Toledo');
INSERT INTO zone VALUES (NULL, 724,'ES-V','Valencia');
INSERT INTO zone VALUES (NULL, 724,'ES-VA','Valladolid');
INSERT INTO zone VALUES (NULL, 724,'ES-BI','Vizcaya');
INSERT INTO zone VALUES (NULL, 724,'ES-ZA','Zamora');
INSERT INTO zone VALUES (NULL, 724,'ES-Z','Zaragoza');

--
-- Suède
--

INSERT INTO zone VALUES (NULL,752,'SE-K','Blekinge');
INSERT INTO zone VALUES (NULL,752,'SE-W','Dalarnas');
INSERT INTO zone VALUES (NULL,752,'SE-I','Gotland');
INSERT INTO zone VALUES (NULL,752,'SE-X','Gävleborg');
INSERT INTO zone VALUES (NULL,752,'SE-N','Halland');
INSERT INTO zone VALUES (NULL,752,'SE-Z','Jämtland');
INSERT INTO zone VALUES (NULL,752,'SE-F','Jönköping');
INSERT INTO zone VALUES (NULL,752,'SE-H','Kalmar');
INSERT INTO zone VALUES (NULL,752,'SE-G','Kronoberg');
INSERT INTO zone VALUES (NULL,752,'SE-BD','Norrbotten');
INSERT INTO zone VALUES (NULL,752,'SE-M','Skåne');
INSERT INTO zone VALUES (NULL,752,'SE-AB','Stockholm');
INSERT INTO zone VALUES (NULL,752,'SE-D','Södermanland');
INSERT INTO zone VALUES (NULL,752,'SE-C','Uppsala');
INSERT INTO zone VALUES (NULL,752,'SE-S','Värmland');
INSERT INTO zone VALUES (NULL,752,'SE-AC','Västerbotten');
INSERT INTO zone VALUES (NULL,752,'SE-Y','Västernorrland');
INSERT INTO zone VALUES (NULL,752,'SE-U','Västmanland');
INSERT INTO zone VALUES (NULL,752,'SE-O','Västra Götaland');
INSERT INTO zone VALUES (NULL,752,'SE-T','Örebro');
INSERT INTO zone VALUES (NULL,752,'SE-E','Östergötland');

--
-- Royaume-Uni
--

INSERT INTO zone VALUES (NULL,826,'GB-ABE','Aberdeen City');
INSERT INTO zone VALUES (NULL,826,'GB-ABD','Aberdeenshire');
INSERT INTO zone VALUES (NULL,826,'GB-ANS','Angus');
INSERT INTO zone VALUES (NULL,826,'GB-ANT','Antrim');
INSERT INTO zone VALUES (NULL,826,'GB-ARD','Ards');
INSERT INTO zone VALUES (NULL,826,'GB-AGB','Argyll and Bute');
INSERT INTO zone VALUES (NULL,826,'GB-ARM','Armagh');
INSERT INTO zone VALUES (NULL,826,'GB-BLA','Ballymena');
INSERT INTO zone VALUES (NULL,826,'GB-BLY','Ballymoney');
INSERT INTO zone VALUES (NULL,826,'GB-BNB','Banbridge');
INSERT INTO zone VALUES (NULL,826,'GB-BAS','Bath and North East Somerset');
INSERT INTO zone VALUES (NULL,826,'GB-BDF','Bedfordshire');
INSERT INTO zone VALUES (NULL,826,'GB-BFS','Belfast');
INSERT INTO zone VALUES (NULL,826,'GB-WBK','Berkshire');
INSERT INTO zone VALUES (NULL,826,'GB-BGW','Blaenau Gwent');
INSERT INTO zone VALUES (NULL,826,'GB-BGE','Bridgend');
INSERT INTO zone VALUES (NULL,826,'GB-BKM','Buckinghamshire');
INSERT INTO zone VALUES (NULL,826,'GB-CAY','Caerphilly');
INSERT INTO zone VALUES (NULL,826,'GB-CAM','Cambridgeshire');
INSERT INTO zone VALUES (NULL,826,'GB-CRF','Cardiff');
INSERT INTO zone VALUES (NULL,826,'GB-CMN','Carmarthenshire');
INSERT INTO zone VALUES (NULL,826,'GB-CKF','Carrickfergus');
INSERT INTO zone VALUES (NULL,826,'GB-CSR','Castlereagh');
INSERT INTO zone VALUES (NULL,826,'GB-CGN','Ceredigion');
INSERT INTO zone VALUES (NULL,826,'GB-CHS','Cheshire');
INSERT INTO zone VALUES (NULL,826,'GB-BST','City of Bristol');
INSERT INTO zone VALUES (NULL,826,'GB-EDH','City of Edinburgh');
INSERT INTO zone VALUES (NULL,826,'GB-CLK','Clackmannanshire');
INSERT INTO zone VALUES (NULL,826,'GB-CLR','Coleraine');
INSERT INTO zone VALUES (NULL,826,'GB-CWY','Conwy');
INSERT INTO zone VALUES (NULL,826,'GB-CKT','Cookstown');
INSERT INTO zone VALUES (NULL,826,'GB-CON','Cornwall');
INSERT INTO zone VALUES (NULL,826,'GB-CGV','Craigavon');
INSERT INTO zone VALUES (NULL,826,'GB-CMA','Cumbria');
INSERT INTO zone VALUES (NULL,826,'GB-DEN','Denbighshire');
INSERT INTO zone VALUES (NULL,826,'GB-DBY','Derbyshire');
INSERT INTO zone VALUES (NULL,826,'GB-DRY','Derry City');
INSERT INTO zone VALUES (NULL,826,'GB-DEV','Devon');
INSERT INTO zone VALUES (NULL,826,'GB-DOR','Dorset');
INSERT INTO zone VALUES (NULL,826,'GB-DOW','Down');
INSERT INTO zone VALUES (NULL,826,'GB-DGY','Dumfries and Galloway');
INSERT INTO zone VALUES (NULL,826,'GB-DND','Dundee City');
INSERT INTO zone VALUES (NULL,826,'GB-DGN','Dungannon');
INSERT INTO zone VALUES (NULL,826,'GB-DUR','Durham');
INSERT INTO zone VALUES (NULL,826,'GB-EAY','East Ayrshire');
INSERT INTO zone VALUES (NULL,826,'GB-EDU','East Dunbartonshire');
INSERT INTO zone VALUES (NULL,826,'GB-ELN','East Lothian');
INSERT INTO zone VALUES (NULL,826,'GB-ERW','East Renfrewshire');
INSERT INTO zone VALUES (NULL,826,'GB-ERY','East Riding of Yorkshire');
INSERT INTO zone VALUES (NULL,826,'GB-ESX','East Sussex');
INSERT INTO zone VALUES (NULL,826,'GB-ELS','Eilean Siar');
INSERT INTO zone VALUES (NULL,826,'GB-ESS','Essex');
INSERT INTO zone VALUES (NULL,826,'GB-FAL','Falkirk');
INSERT INTO zone VALUES (NULL,826,'GB-FER','Fermanagh');
INSERT INTO zone VALUES (NULL,826,'GB-FIF','Fife');
INSERT INTO zone VALUES (NULL,826,'GB-FLN','Flintshire');
INSERT INTO zone VALUES (NULL,826,'GB-GLG','Glasgow City');
INSERT INTO zone VALUES (NULL,826,'GB-GLS','Gloucestershire');
INSERT INTO zone VALUES (NULL,826,'GB-LND','Greater London');
INSERT INTO zone VALUES (NULL,826,'GB-MAN','Greater Manchester');
INSERT INTO zone VALUES (NULL,826,'GB-GSY','Guernsey');
INSERT INTO zone VALUES (NULL,826,'GB-GWN','Gwynedd');
INSERT INTO zone VALUES (NULL,826,'GB-HAM','Hampshire');
INSERT INTO zone VALUES (NULL,826,'GB-HEF','Herefordshire');
INSERT INTO zone VALUES (NULL,826,'GB-HRT','Hertfordshire');
INSERT INTO zone VALUES (NULL,826,'GB-HLD','Highland');
INSERT INTO zone VALUES (NULL,826,'GB-IVC','Inverclyde');
INSERT INTO zone VALUES (NULL,826,'GB-AGY','Isle of Anglesey');
INSERT INTO zone VALUES (NULL,826,'GB-IOW','Isle of Wight');
INSERT INTO zone VALUES (NULL,826,'GB-JSY','Jersey');
INSERT INTO zone VALUES (NULL,826,'GB-KEN','Kent');
INSERT INTO zone VALUES (NULL,826,'GB-LAN','Lancashire');
INSERT INTO zone VALUES (NULL,826,'GB-LRN','Larne');
INSERT INTO zone VALUES (NULL,826,'GB-LEC','Leicestershire');
INSERT INTO zone VALUES (NULL,826,'GB-LMV','Limavady');
INSERT INTO zone VALUES (NULL,826,'GB-LIN','Lincolnshire');
INSERT INTO zone VALUES (NULL,826,'GB-LSB','Lisburn');
INSERT INTO zone VALUES (NULL,826,'GB-MFT','Magherafelt');
INSERT INTO zone VALUES (NULL,826,'','Merseyside');
INSERT INTO zone VALUES (NULL,826,'GB-MTY','Merthyr Tydfil');
INSERT INTO zone VALUES (NULL,826,'GB-MLN','Midlothian');
INSERT INTO zone VALUES (NULL,826,'GB-MON','Monmouthshire');
INSERT INTO zone VALUES (NULL,826,'GB-MRY','Moray');
INSERT INTO zone VALUES (NULL,826,'GB-MYL','Moyle');
INSERT INTO zone VALUES (NULL,826,'GB-NTL','Neath Port Talbot');
INSERT INTO zone VALUES (NULL,826,'GB-NWP','Newport');
INSERT INTO zone VALUES (NULL,826,'GB-NYM','Newry and Mourne');
INSERT INTO zone VALUES (NULL,826,'GB-NTA','Newtownabbey');
INSERT INTO zone VALUES (NULL,826,'GB-NFK','Norfolk');
INSERT INTO zone VALUES (NULL,826,'GB-NAY','North Ayrshire');
INSERT INTO zone VALUES (NULL,826,'GB-NDN','North Down');
INSERT INTO zone VALUES (NULL,826,'GB-NLK','North Lanarkshire');
INSERT INTO zone VALUES (NULL,826,'GB-NYK','North Yorkshire');
INSERT INTO zone VALUES (NULL,826,'GB-NTH','Northamptonshire');
INSERT INTO zone VALUES (NULL,826,'GB-NBL','Northumberland');
INSERT INTO zone VALUES (NULL,826,'GB-NTT','Nottinghamshire');
INSERT INTO zone VALUES (NULL,826,'GB-OMH','Omagh');
INSERT INTO zone VALUES (NULL,826,'GB-ORK','Orkney Islands');
INSERT INTO zone VALUES (NULL,826,'GB-OXF','Oxfordshire');
INSERT INTO zone VALUES (NULL,826,'GB-PEM','Pembrokeshire');
INSERT INTO zone VALUES (NULL,826,'GB-PKN','Perth and Kinross');
INSERT INTO zone VALUES (NULL,826,'GB-POW','Powys');
INSERT INTO zone VALUES (NULL,826,'GB-RFW','Renfrewshire');
INSERT INTO zone VALUES (NULL,826,'GB-RCT','Rhondda Cynon Taff');
INSERT INTO zone VALUES (NULL,826,'GB-RUT','Rutland');
INSERT INTO zone VALUES (NULL,826,'GB-SCB','Scottish Borders');
INSERT INTO zone VALUES (NULL,826,'GB-ZET','Shetland Islands');
INSERT INTO zone VALUES (NULL,826,'GB-SHR','Shropshire');
INSERT INTO zone VALUES (NULL,826,'GB-SOM','Somerset');
INSERT INTO zone VALUES (NULL,826,'GB-SAY','South Ayrshire');
INSERT INTO zone VALUES (NULL,826,'GB-SLK','South Lanarkshire');
INSERT INTO zone VALUES (NULL,826,'GB-YOR','South Yorkshire');
INSERT INTO zone VALUES (NULL,826,'GB-STB','Strabane');
INSERT INTO zone VALUES (NULL,826,'GB-STS','Staffordshire');
INSERT INTO zone VALUES (NULL,826,'GB-STG','Stirling');
INSERT INTO zone VALUES (NULL,826,'GB-SFK','Suffolk');
INSERT INTO zone VALUES (NULL,826,'GB-SRY','Surrey');
INSERT INTO zone VALUES (NULL,826,'GB-SWA','Swansea');
INSERT INTO zone VALUES (NULL,826,'GB-VGL','The Vale of Glamorgan');
INSERT INTO zone VALUES (NULL,826,'GB-TOF','Torfaen');
INSERT INTO zone VALUES (NULL,826,'','Tyne and Wear');
INSERT INTO zone VALUES (NULL,826,'GB-WAR','Warwickshire');
INSERT INTO zone VALUES (NULL,826,'GB-WDU','West Dunbartonshire');
INSERT INTO zone VALUES (NULL,826,'GB-WLN','West Lothian');
INSERT INTO zone VALUES (NULL,826,'','West Midlands');
INSERT INTO zone VALUES (NULL,826,'GB-WSX','West Sussex');
INSERT INTO zone VALUES (NULL,826,'GB-YOR','West Yorkshire');
INSERT INTO zone VALUES (NULL,826,'GB-WIL','Wiltshire');
INSERT INTO zone VALUES (NULL,826,'GB-WOR','Worcestershire');
INSERT INTO zone VALUES (NULL,826,'GB-WRX','Wrexham');

[GuinnessBoy]

L'empêcheur de tourner en rond est de retour. LOL

C'est pas mal ce truc mais bon nombre de boutiques ont une clientèle nationale ou ne souhaitent pas exporter.

Ce serai bien d'avoir à disposition une version light avec juste la France et une version moins light avec france et pays francophones limitrophes. C'est moins lourd à trainer et surtout cela limite les inscriptions et les commandes vers des zones ou on ne le souhaite pas livrer.

A moins bien entendu que cela se paramètre quelque part dans Open-Cart ?

J'ai pas encore tout exploré.

Code: Tout sélectionner


    --
    -- Table structure for table `country`
    --

    DROP TABLE IF EXISTS `country`;
    CREATE TABLE `country` (
      `country_id` int(11) NOT NULL auto_increment,
      `name` varchar(128) collate utf8_bin NOT NULL,
      `iso_code_2` varchar(2) collate utf8_bin NOT NULL default '',
      `iso_code_3` varchar(3) collate utf8_bin NOT NULL default '',
      `address_format` text collate utf8_bin NOT NULL,
      PRIMARY KEY  (`country_id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

    --
    -- Dumping data for table `country`
    --

    INSERT INTO `country` (`country_id`, `name`, `iso_code_2`, `iso_code_3`, `address_format`) VALUES
    (056,'Belgium','BE','BEL','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
    (250,'France','FR','FRA','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}'),
    (442,'Luxembourg','LU','LUX','{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city} {postcode}\r\n{zone}\r\n{country}');



    --
    -- Table structure for table `zone`
    --

    DROP TABLE IF EXISTS `zone`;
    CREATE TABLE `zone` (
      `zone_id` int(11) NOT NULL auto_increment,
      `country_id` int(11) NOT NULL,
      `code` varchar(32) collate utf8_bin NOT NULL default '',
      `name` varchar(128) collate utf8_bin NOT NULL,
      PRIMARY KEY  (`zone_id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

    --
    -- Belgique
    --

    INSERT INTO zone VALUES (NULL,56,'BE-BRU','Brüssel-Hauptstadt');
    INSERT INTO zone VALUES (NULL,56,'BE-VAN','Antwerpen');
    INSERT INTO zone VALUES (NULL,56,'BE-VBR','Brabant Wallon');
    INSERT INTO zone VALUES (NULL,56,'BE-WHT','Hainaut');
    INSERT INTO zone VALUES (NULL,56,'BE-WLG','Liege');
    INSERT INTO zone VALUES (NULL,56,'BE-VLI','Limburg');
    INSERT INTO zone VALUES (NULL,56,'BE-WLX','Luxembourg');
    INSERT INTO zone VALUES (NULL,56,'BE-WNA','Namur');
    INSERT INTO zone VALUES (NULL,56,'BE-VOV','Oost-Vlaanderen');
    INSERT INTO zone VALUES (NULL,56,'BE-VBR','Vlaams Brabant');
    INSERT INTO zone VALUES (NULL,56,'BE-VWV','West-Vlaanderen');

    --
    -- France
    --

    INSERT INTO zone VALUES (NULL,250,'FR-01','Ain');
    INSERT INTO zone VALUES (NULL,250,'FR-02','Aisne');
    INSERT INTO zone VALUES (NULL,250,'FR-03','Allier');
    INSERT INTO zone VALUES (NULL,250,'FR-04','Alpes-de-Haute-Provence');
    INSERT INTO zone VALUES (NULL,250,'FR-05','Hautes-Alpes');
    INSERT INTO zone VALUES (NULL,250,'FR-06','Alpes-Maritimes');
    INSERT INTO zone VALUES (NULL,250,'FR-07','Ardèche');
    INSERT INTO zone VALUES (NULL,250,'FR-08','Ardennes');
    INSERT INTO zone VALUES (NULL,250,'FR-09','Ariège');
    INSERT INTO zone VALUES (NULL,250,'FR-10','Aube');
    INSERT INTO zone VALUES (NULL,250,'FR-11','Aude');
    INSERT INTO zone VALUES (NULL,250,'FR-12','Aveyron');
    INSERT INTO zone VALUES (NULL,250,'FR-13','Bouches-du-Rhône');
    INSERT INTO zone VALUES (NULL,250,'FR-14','Calvados');
    INSERT INTO zone VALUES (NULL,250,'FR-15','Cantal');
    INSERT INTO zone VALUES (NULL,250,'FR-16','Charente');
    INSERT INTO zone VALUES (NULL,250,'FR-17','Charente-Maritime');
    INSERT INTO zone VALUES (NULL,250,'FR-18','Cher');
    INSERT INTO zone VALUES (NULL,250,'FR-19','Corrèze');
    INSERT INTO zone VALUES (NULL,250,'FR-2A','Corse-du-Sud');
    INSERT INTO zone VALUES (NULL,250,'FR-2B','Haute-Corse');
    INSERT INTO zone VALUES (NULL,250,'FR-21','Côte-d''or');
    INSERT INTO zone VALUES (NULL,250,'FR-22','Côtes-d''Armor');
    INSERT INTO zone VALUES (NULL,250,'FR-23','Creuse');
    INSERT INTO zone VALUES (NULL,250,'FR-24','Dordogne');
    INSERT INTO zone VALUES (NULL,250,'FR-25','Doubs');
    INSERT INTO zone VALUES (NULL,250,'FR-26','Drôme');
    INSERT INTO zone VALUES (NULL,250,'FR-27','Eure');
    INSERT INTO zone VALUES (NULL,250,'FR-28','Eure-et-Loir');
    INSERT INTO zone VALUES (NULL,250,'FR-29','Finistère');
    INSERT INTO zone VALUES (NULL,250,'FR-30','Gard');
    INSERT INTO zone VALUES (NULL,250,'FR-31','Haute-Garonne');
    INSERT INTO zone VALUES (NULL,250,'FR-32','Gers');
    INSERT INTO zone VALUES (NULL,250,'FR-33','Gironde');
    INSERT INTO zone VALUES (NULL,250,'FR-34','Hérault');
    INSERT INTO zone VALUES (NULL,250,'FR-35','Ille-et-Vilaine');
    INSERT INTO zone VALUES (NULL,250,'FR-36','Indre');
    INSERT INTO zone VALUES (NULL,250,'FR-37','Indre-et-Loire');
    INSERT INTO zone VALUES (NULL,250,'FR-38','Isére');
    INSERT INTO zone VALUES (NULL,250,'FR-39','Jura');
    INSERT INTO zone VALUES (NULL,250,'FR-40','Landes');
    INSERT INTO zone VALUES (NULL,250,'FR-41','Loir-et-Cher');
    INSERT INTO zone VALUES (NULL,250,'FR-42','Loire');
    INSERT INTO zone VALUES (NULL,250,'FR-43','Haute-Loire');
    INSERT INTO zone VALUES (NULL,250,'FR-44','Loire-Atlantique');
    INSERT INTO zone VALUES (NULL,250,'FR-45','Loiret');
    INSERT INTO zone VALUES (NULL,250,'FR-46','Lot');
    INSERT INTO zone VALUES (NULL,250,'FR-47','Lot-et-Garonne');
    INSERT INTO zone VALUES (NULL,250,'FR-48','Lozère');
    INSERT INTO zone VALUES (NULL,250,'FR-49','Maine-et-Loire');
    INSERT INTO zone VALUES (NULL,250,'FR-50','Manche');
    INSERT INTO zone VALUES (NULL,250,'FR-51','Marne');
    INSERT INTO zone VALUES (NULL,250,'FR-52','Haute-Marne');
    INSERT INTO zone VALUES (NULL,250,'FR-53','Mayenne');
    INSERT INTO zone VALUES (NULL,250,'FR-54','Meurthe-et-Moselle');
    INSERT INTO zone VALUES (NULL,250,'FR-55','Meuse');
    INSERT INTO zone VALUES (NULL,250,'FR-56','Morbihan');
    INSERT INTO zone VALUES (NULL,250,'FR-57','Moselle');
    INSERT INTO zone VALUES (NULL,250,'FR-58','Nièvre');
    INSERT INTO zone VALUES (NULL,250,'FR-59','Nord');
    INSERT INTO zone VALUES (NULL,250,'FR-60','Oise');
    INSERT INTO zone VALUES (NULL,250,'FR-61','Orne');
    INSERT INTO zone VALUES (NULL,250,'FR-62','Pas-de-Calais');
    INSERT INTO zone VALUES (NULL,250,'FR-63','Puy-de-Dôme');
    INSERT INTO zone VALUES (NULL,250,'FR-64','Pyrénées-Atlantiques');
    INSERT INTO zone VALUES (NULL,250,'FR-65','Hautes-Pyrénées');
    INSERT INTO zone VALUES (NULL,250,'FR-66','Pyrénées-Orientales');
    INSERT INTO zone VALUES (NULL,250,'FR-67','Bas-Rhin');
    INSERT INTO zone VALUES (NULL,250,'FR-68','Haut-Rhin');
    INSERT INTO zone VALUES (NULL,250,'FR-69','Rhône');
    INSERT INTO zone VALUES (NULL,250,'FR-70','Haute-Saône');
    INSERT INTO zone VALUES (NULL,250,'FR-71','Saône-et-Loire');
    INSERT INTO zone VALUES (NULL,250,'FR-72','Sarthe');
    INSERT INTO zone VALUES (NULL,250,'FR-73','Savoie');
    INSERT INTO zone VALUES (NULL,250,'FR-74','Haute-Savoie');
    INSERT INTO zone VALUES (NULL,250,'FR-75','Paris');
    INSERT INTO zone VALUES (NULL,250,'FR-76','Seine-Maritime');
    INSERT INTO zone VALUES (NULL,250,'FR-77','Seine-et-Marne');
    INSERT INTO zone VALUES (NULL,250,'FR-78','Yvelines');
    INSERT INTO zone VALUES (NULL,250,'FR-79','Deux-Sèvres');
    INSERT INTO zone VALUES (NULL,250,'FR-80','Somme');
    INSERT INTO zone VALUES (NULL,250,'FR-81','Tarn');
    INSERT INTO zone VALUES (NULL,250,'FR-82','Tarn-et-Garonne');
    INSERT INTO zone VALUES (NULL,250,'FR-83','Var');
    INSERT INTO zone VALUES (NULL,250,'FR-84','Vaucluse');
    INSERT INTO zone VALUES (NULL,250,'FR-85','Vendée');
    INSERT INTO zone VALUES (NULL,250,'FR-86','Vienne');
    INSERT INTO zone VALUES (NULL,250,'FR-87','Haute-Vienne');
    INSERT INTO zone VALUES (NULL,250,'FR-88','Vosges');
    INSERT INTO zone VALUES (NULL,250,'FR-89','Yonne');
    INSERT INTO zone VALUES (NULL,250,'FR-90','Territoire-de-Belfort');
    INSERT INTO zone VALUES (NULL,250,'FR-91','Essonne');
    INSERT INTO zone VALUES (NULL,250,'FR-92','Hauts-de-Seine');
    INSERT INTO zone VALUES (NULL,250,'FR-93','Seine-St-Denis');
    INSERT INTO zone VALUES (NULL,250,'FR-94','Val-de-Marne');
    INSERT INTO zone VALUES (NULL,250,'FR-95','Val-d''Oise');
    INSERT INTO zone VALUES (NULL,250,'FR-GP','Guadeloupe');
    INSERT INTO zone VALUES (NULL,250,'FR-MQ','Martinique');
    INSERT INTO zone VALUES (NULL,250,'FR-GF','Guyane');
    INSERT INTO zone VALUES (NULL,250,'FR-RE','La Réunion');
    INSERT INTO zone VALUES (NULL,250,'FR-BL','Saint-Barthélemy');
    INSERT INTO zone VALUES (NULL,250,'FR-MF','Saint-Martin');
    INSERT INTO zone VALUES (NULL,250,'FR-PM','Saint-Pierre-et-Miquelon');
    INSERT INTO zone VALUES (NULL,250,'FR-YT','Mayotte');
    INSERT INTO zone VALUES (NULL,250,'FR-TF','Terres-Australes-et-Antarctiques');
    INSERT INTO zone VALUES (NULL,250,'FR-WF','Wallis-et-Futuna');
    INSERT INTO zone VALUES (NULL,250,'FR-PF','Polynésie-Française');
    INSERT INTO zone VALUES (NULL,250,'FR-NC','Nouvelle-Calédonie');

    --
    -- Luxembourg
    --

    INSERT INTO zone VALUES (NULL,442,'LU-D','Diekirch');
    INSERT INTO zone VALUES (NULL,442,'LU-G','Grevenmacher');
    INSERT INTO zone VALUES (NULL,442,'LU-L','Luxembourg');




[LeorLindel]

La version qui va sortir en français comprend la base initiale, à savoir l'internationale. Pour la France et les états de la communauté européenne il suffit d'appliquer ce patch justement.

[LeorLindel]

Complément d'information.

Si vous installer la version v1.4.3 en français il vous faut aussi faire le modification de l'ID de la France dans le module colissimo, à savoir 250 à la place de 74.

Dans le fichier admin/controller/shipping/colissimo.php,

- remplacer ligne 118

Code: Tout sélectionner

        $this->data['default_country'] = 74 ;


Par :

Code: Tout sélectionner

        $this->data['default_country'] = 250 ;


- remplacer ligne 255

Code: Tout sélectionner

      $settings  =  array('country' => '74') ;


Par :

Code: Tout sélectionner

      $settings  =  array('country' => '250') ;