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