-- http://www.phpmyadmin.net
--
-- Client: localhost
-- G�n�r� le : Lun 28 Mai 2012 � 16:42
-- Version du serveur: 5.1.36
-- Version de PHP: 5.3.0

INSERT INTO `department` (`id`, `region_id`, name) VALUES ('1', '23', 'Ain');
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('2', '21', 'Aisne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('3', '4', 'Allier'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('4', '19', 'Alpes de haute provence'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('5', '19', 'Hautes alpes'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('6', '19', 'Alpes maritimes'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('7', '23', 'Ardèche'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('8', '9', 'Ardennes'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('9', '17', 'Ariège'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('10', '9', 'Aube'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('11', '14', 'Aude'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('12', '17', 'Aveyron'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('13', '19', 'Bouches du rhône'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('14', '5', 'Calvados'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('15', '4', 'Cantal'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('16', '22', 'Charente'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('17', '22', 'Charente maritime'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('18', '8', 'Cher'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('19', '15', 'Corrèze'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('21', '6', 'Côte d\'or'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('22', '7', 'Côtes d\'Armor'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('23', '15', 'Creuse'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('24', '3', 'Dordogne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('25', '11', 'Doubs'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('26', '23', 'Drome'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('27', '12', 'Eure'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('28', '8', 'Eure et Loir'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('29', '7', 'Finistère'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('30', '14', 'Gard'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('31', '17', 'Haute garonne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('32', '17', 'Gers'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('33', '3', 'Gironde'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('34', '14', 'Hérault'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('35', '7', 'Ile et Vilaine'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('36', '8', 'Indre'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('37', '8', 'Indre et Loire'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('38', '23', 'Isère'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('39', '11', 'Jura'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('40', '3', 'Landes'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('41', '8', 'Loir et Cher'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('42', '23', 'Loire'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('43', '4', 'Haute loire'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('44', '20', 'Loire Atlantique'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('45', '8', 'Loiret'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('46', '17', 'Lot'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('47', '3', 'Lot et Garonne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('48', '14', 'Lozère'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('49', '20', 'Maine et Loire'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('50', '5', 'Manche'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('51', '9', 'Marne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('52', '9', 'Haute Marne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('53', '20', 'Mayenne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('54', '16', 'Meurthe et Moselle'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('55', '16', 'Meuse'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('56', '7', 'Morbihan'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('57', '16', 'Moselle'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('58', '6', 'Nièvre'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('59', '18', 'Nord'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('60', '21', 'Oise'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('61', '5', 'Orne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('62', '18', 'Pas de Calais'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('63', '4', 'Puy de Dôme'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('64', '3', 'Pyrénées Atlantiques'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('65', '17', 'Hautes Pyrénées'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('66', '14', 'Pyrénées Orientales'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('67', '2', 'Bas Rhin'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('68', '2', 'Haut Rhin'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('69', '23', 'Rhône'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('70', '11', 'Haute Saône'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('71', '6', 'Saône et Loire'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('72', '20', 'Sarthe'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('73', '23', 'Savoie'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('74', '23', 'Haute Savoie'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('75', '13', 'Paris'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('76', '12', 'Seine Maritime'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('77', '13', 'Seine et Marne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('78', '13', 'Yvelines'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('79', '22', 'Deux Sèvres'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('80', '21', 'Somme'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('81', '17', 'Tarn'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('82', '17', 'Tarn et Garonne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('83', '19', 'Var'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('84', '19', 'Vaucluse'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('85', '20', 'Vendée'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('86', '22', 'Vienne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('87', '15', 'Haute Vienne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('88', '16', 'Vosge'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('89', '6', 'Yonne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('90', '11', 'Territoire de Belfort'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('91', '13', 'Essonne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('92', '13', 'Haut de seine'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('93', '13', 'Seine Saint Denis'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('94', '13', 'Val de Marne'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('95', '13', 'Val d\'Oise'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('101', '10', 'Corse du Sud'); 
INSERT INTO `department` (`id`, `region_id`, name) VALUES ('102', '10', 'Haute Corse');

