INSERT INTO holiday_regions VALUES ('brittany','Brittany',0);
INSERT INTO holiday_regions VALUES ('normandy','Normandy',1);
INSERT INTO holiday_regions VALUES ('picardie','Picardie',2);
INSERT INTO holiday_regions VALUES ('nord','Nord - Pas de Calais',3);
INSERT INTO holiday_regions VALUES ('champ','Champagne - Ardenne',4);
INSERT INTO holiday_regions VALUES ('ile','Ile de France',5);
INSERT INTO holiday_regions VALUES ('lorra','Lorraine',6);
INSERT INTO holiday_regions VALUES ('alsa','Alsace',7);
INSERT INTO holiday_regions VALUES ('franc','Franche Comté',8);
INSERT INTO holiday_regions VALUES ('burgu','Burgundy',9);
INSERT INTO holiday_regions VALUES ('centre','Centre',10);
INSERT INTO holiday_regions VALUES ('pays','Pays de la Loire',11);
INSERT INTO holiday_regions VALUES ('poit','Poitou - Charentes',12);
INSERT INTO holiday_regions VALUES ('limo','Limousin',13);
INSERT INTO holiday_regions VALUES ('auver','Auvergne',14);
INSERT INTO holiday_regions VALUES ('rhone','Rhône - Alps',15);
INSERT INTO holiday_regions VALUES ('prove','Provence - Alps - Cóte d Azur',16);
INSERT INTO holiday_regions VALUES ('lang','Languedoc - Roussillon',17);
INSERT INTO holiday_regions VALUES ('midi','Midi - Pyrénéés',18);
INSERT INTO holiday_regions VALUES ('aquit','Aquitaine',19);
INSERT INTO holiday_regions VALUES ('cors','Corsica',20);