127 lines
3.7 KiB
SQL
127 lines
3.7 KiB
SQL
--
|
|
-- Structure de la table `departements`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `departements` (
|
|
`numdep` char(3) NOT NULL DEFAULT '0',
|
|
`libdep` varchar(30) NOT NULL DEFAULT '',
|
|
`numreg` tinyint(4) NOT NULL DEFAULT '0',
|
|
`codeRegionInsee` tinyint(2) NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`numdep`)
|
|
) DEFAULT CHARSET=utf8;
|
|
|
|
--
|
|
-- Contenu de la table `departements`
|
|
--
|
|
|
|
INSERT INTO `departements` (`numdep`, `libdep`, `numreg`, `codeRegionInsee`) VALUES
|
|
('03', 'Allier', 3, 83),
|
|
('04', 'Alpes-de-Haute-Provence', 21, 93),
|
|
('02', 'Aisne', 19, 26),
|
|
('01', 'Ain', 22, 82),
|
|
('05', 'Hautes-Alpes', 21, 93),
|
|
('06', 'Alpes-Maritimes', 21, 93),
|
|
('07', 'Ardèche', 22, 82),
|
|
('08', 'Ardennes', 7, 21),
|
|
('09', 'Ariège', 15, 73),
|
|
('10', 'Aube', 7, 21),
|
|
('11', 'Aude', 11, 91),
|
|
('12', 'Aveyron', 15, 73),
|
|
('13', 'Bouches-du-Rhône', 21, 93),
|
|
('14', 'Calvados', 18, 25),
|
|
('15', 'Cantal', 3, 83),
|
|
('16', 'Charente', 20, 54),
|
|
('17', 'Charente-Maritime', 20, 54),
|
|
('18', 'Cher', 6, 24),
|
|
('19', 'Corrèze', 12, 74),
|
|
('2A', 'Corse-du-Sud', 8, 94),
|
|
('20', 'Corse', 8, 94),
|
|
('21', 'Côte-d''Or', 4, 26),
|
|
('22', 'Côtes-d''Armor', 5, 53),
|
|
('23', 'Creuse', 12, 74),
|
|
('24', 'Dordogne', 2, 72),
|
|
('25', 'Doubs', 9, 43),
|
|
('26', 'Drôme', 22, 82),
|
|
('27', 'Eure', 17, 23),
|
|
('28', 'Eure-et-Loir', 6, 24),
|
|
('29', 'Finistère', 5, 53),
|
|
('30', 'Gard', 11, 91),
|
|
('33', 'Gironde', 2, 72),
|
|
('32', 'Gers', 15, 73),
|
|
('34', 'Hérault', 11, 91),
|
|
('31', 'Haute-Garonne', 15, 73),
|
|
('36', 'Indre', 6, 24),
|
|
('37', 'Indre-et-Loire', 6, 24),
|
|
('35', 'Ille-et-Vilaine', 5, 53),
|
|
('39', 'Jura', 9, 43),
|
|
('38', 'Isère', 22, 82),
|
|
('40', 'Landes', 2, 72),
|
|
('41', 'Loir-et-Cher', 6, 24),
|
|
('42', 'Loire', 22, 82),
|
|
('43', 'Haute-Loire', 3, 83),
|
|
('44', 'Loire-Atlantique', 13, 52),
|
|
('45', 'Loiret', 6, 24),
|
|
('46', 'Lot', 15, 73),
|
|
('47', 'Lot-et-Garonne', 2, 72),
|
|
('48', 'Lozère', 11, 91),
|
|
('49', 'Maine-et-Loire', 13, 52),
|
|
('53', 'Mayenne', 13, 52),
|
|
('51', 'Marne', 7, 21),
|
|
('50', 'Manche', 18, 25),
|
|
('52', 'Haute-Marne', 7, 21),
|
|
('54', 'Meurthe-et-Moselle', 14, 41),
|
|
('56', 'Morbihan', 5, 53),
|
|
('55', 'Meuse', 14, 41),
|
|
('57', 'Moselle', 14, 41),
|
|
('58', 'Nièvre', 4, 26),
|
|
('59', 'Nord', 16, 31),
|
|
('60', 'Oise', 19, 26),
|
|
('62', 'Pas-de-Calais', 16, 31),
|
|
('61', 'Orne', 18, 25),
|
|
('63', 'Puy-de-Dôme', 3, 83),
|
|
('67', 'Bas-Rhin', 1, 42),
|
|
('68', 'Haut-Rhin', 1, 42),
|
|
('69', 'Rhône', 22, 82),
|
|
('64', 'Pyrénées-Atlantiques', 2, 72),
|
|
('65', 'Hautes-Pyrénées', 15, 73),
|
|
('66', 'Pyrénées-Orientales', 11, 91),
|
|
('70', 'Haute-Saône', 9, 43),
|
|
('71', 'Saône-et-Loire', 4, 26),
|
|
('72', 'Sarthe', 13, 52),
|
|
('73', 'Savoie', 22, 82),
|
|
('74', 'Haute-Savoie', 22, 82),
|
|
('75', 'Paris', 10, 11),
|
|
('76', 'Seine-Maritime', 17, 23),
|
|
('77', 'Seine-et-Marne', 10, 11),
|
|
('78', 'Yvelines', 10, 11),
|
|
('79', 'Deux-Sèvres', 20, 54),
|
|
('80', 'Somme', 19, 26),
|
|
('81', 'Tarn', 15, 73),
|
|
('82', 'Tarn-et-Garonne', 15, 73),
|
|
('83', 'Var', 21, 93),
|
|
('84', 'Vaucluse', 21, 93),
|
|
('85', 'Vendée', 13, 52),
|
|
('86', 'Vienne', 20, 54),
|
|
('87', 'Haute-Vienne', 12, 74),
|
|
('88', 'Vosges', 14, 41),
|
|
('89', 'Yonne', 4, 26),
|
|
('90', 'Territoire de Belfort', 9, 43),
|
|
('91', 'Essonne', 10, 11),
|
|
('92', 'Hauts-de-Seine', 10, 11),
|
|
('93', 'Seine-Saint-Denis', 10, 11),
|
|
('94', 'Val-de-Marne', 10, 11),
|
|
('95', 'Val-d''Oise', 10, 11),
|
|
('971', 'Guadeloupe', 23, 1),
|
|
('972', 'Martinique', 23, 2),
|
|
('973', 'Guyane', 23, 3),
|
|
('974', 'Réunion', 24, 4),
|
|
('200', 'Corse-du-Sud', 8, 94),
|
|
('201', 'Corse-du-Sud', 8, 94),
|
|
('202', 'Haute-Corse', 8, 94),
|
|
('976', 'Mayotte', 0, 0),
|
|
('988', 'Nouvelle-Calédonie', 0, 0),
|
|
('987', 'Polynésie-Française', 0, 0),
|
|
('975', 'Saint-Pierre-et-Miquelon', 0, 0),
|
|
('986', 'Wallis-et-Futuna', 0, 0),
|
|
('2B', 'Haute-Corse', 8, 94);
|