-- Dump de la table: geo_departement
-- Généré le: 2025-06-28 16:12:06
-- Base source: aef
-- Phase: phase1_reference

-- MySQL dump 10.13  Distrib 5.5.62, for debian-linux-gnu (i686)
--
-- Host: nj151-003.eu.clouddb.ovh.net    Database: aef
-- ------------------------------------------------------
-- Server version	8.0.41-32

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `geo_departement`
--

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

--
-- Dumping routines for database 'aef'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-06-28 16:12:06
