-- Adminer 4.7.0 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

SET NAMES utf8mb4;

DROP TABLE IF EXISTS `_departement`;
CREATE TABLE `_departement` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `numero` varchar(8) NOT NULL,
  `nom` varchar(128) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `_departement` (`ID`, `numero`, `nom`) VALUES
(1,	'01',	'Ain'),
(2,	'02',	'Aisne'),
(3,	'03',	'Allier'),
(4,	'04',	'Alpes-de-Haute-Provence'),
(5,	'06',	'Alpes-Maritimes'),
(6,	'07',	'Ardèche'),
(7,	'08',	'Ardennes'),
(8,	'09',	'Ariège'),
(9,	'10',	'Aube'),
(10,	'11',	'Aude'),
(11,	'12',	'Aveyron'),
(12,	'13',	'Bouches-du-Rhône'),
(13,	'14',	'Calvados'),
(14,	'16',	'Charente'),
(15,	'17',	'Charente-Maritime'),
(16,	'18',	'Cher'),
(17,	'19',	'Corrèze'),
(18,	'21',	'Côte-d\'Or'),
(19,	'22',	'Côtes-d\'Armor'),
(20,	'23',	'Creuse'),
(21,	'25',	'Doubs'),
(22,	'26',	'Drôme'),
(23,	'27',	'Eure'),
(24,	'28',	'Eure-et-Loir'),
(25,	'29',	'Finistère'),
(26,	'2A',	'Corse-du-Sud'),
(27,	'2B',	'Haute-Corse'),
(28,	'30',	'Gard'),
(29,	'31',	'Haute-Garonne'),
(30,	'32',	'Gers'),
(31,	'33',	'Gironde'),
(32,	'34',	'Hérault'),
(33,	'35',	'Ille-et-Vilaine'),
(34,	'36',	'Indre'),
(35,	'37',	'Indre-et-Loire'),
(36,	'38',	'Isère'),
(37,	'40',	'Landes'),
(38,	'41',	'Loir-et-Cher'),
(39,	'42',	'Loire'),
(40,	'43',	'Haute-Loire'),
(41,	'44',	'Loire-Atlantique'),
(42,	'45',	'Loiret'),
(43,	'46',	'Lot'),
(44,	'49',	'Maine-et-Loire'),
(45,	'50',	'Manche'),
(46,	'51',	'Marne'),
(47,	'52',	'Haute-Marne'),
(48,	'53',	'Mayenne'),
(49,	'54',	'Meurthe-et-Moselle'),
(50,	'56',	'Morbihan'),
(51,	'58',	'Nièvre'),
(52,	'59',	'Nord'),
(53,	'60',	'Oise'),
(54,	'62',	'Pas-de-Calais'),
(55,	'63',	'Puy-de-Dôme'),
(56,	'64',	'Pyrénées-Atlantiques'),
(57,	'65',	'Hautes-Pyrénées'),
(58,	'66',	'Pyrénées-Orientales'),
(59,	'67',	'Bas-Rhin'),
(60,	'70',	'Haute-Saône'),
(61,	'71',	'Saône-et-Loire'),
(62,	'72',	'Sarthe'),
(63,	'73',	'Savoie'),
(64,	'74',	'Haute-Savoie'),
(65,	'75',	'Paris'),
(66,	'76',	'Seine-Maritime'),
(67,	'77',	'Seine-et-Marne'),
(68,	'78',	'Yvelines'),
(69,	'79',	'Deux-Sèvres'),
(70,	'80',	'Somme'),
(71,	'81',	'Tarn'),
(72,	'82',	'Tarn-et-Garonne'),
(73,	'83',	'Var'),
(74,	'84',	'Vaucluse'),
(75,	'85',	'Vendée'),
(76,	'86',	'Vienne'),
(77,	'89',	'Yonne'),
(78,	'90',	'Territoire de Belfort'),
(79,	'91',	'Essonne'),
(80,	'92',	'Hauts-de-Seine'),
(81,	'93',	'Seine-Saint-Denis'),
(82,	'94',	'Val-de-Marne'),
(83,	'95',	'Val-d\'Oise'),
(84,	'971',	'Guadeloupe'),
(85,	'972',	'Martinique'),
(86,	'974',	'La Réunion'),
(87,	'75',	'Paris'),
(88,	'75',	'Paris'),
(89,	'75',	'Paris'),
(90,	'75',	'Paris'),
(91,	'75',	'Paris'),
(92,	'06',	'Alpes-Maritimes'),
(93,	'03',	'Allier'),
(94,	'75',	'Paris'),
(95,	'77',	'Seine-et-Marne'),
(96,	'75',	'Paris'),
(97,	'971',	'Guadeloupe');

-- 2020-02-27 20:19:21