-- Dump de la table: geo_departement_i18n
-- 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_i18n`
--

LOCK TABLES `geo_departement_i18n` WRITE;
/*!40000 ALTER TABLE `geo_departement_i18n` DISABLE KEYS */;
INSERT INTO `geo_departement_i18n` (`id`, `culture`, `departement`, `normalized_departement`) VALUES (1,'en_EN','Ain','ain'),(2,'en_EN','Aisne','aisne'),(3,'en_EN','Allier','allier'),(4,'en_EN','Alpes-de-Haute-Provence','alpes-de-haute-provence'),(5,'en_EN','Hautes-Alpes','hautes-alpes'),(6,'en_EN','Alpes-Maritimes','alpes-maritimes'),(7,'en_EN','Ardèche','ardeche'),(8,'en_EN','Ardennes','ardennes'),(9,'en_EN','Ariège','ariege'),(10,'en_EN','Aube','aube'),(11,'en_EN','Aude','aude'),(12,'en_EN','Aveyron','aveyron'),(13,'en_EN','Bouches-du-Rhône','bouches-du-rhone'),(14,'en_EN','Calvados','calvados'),(15,'en_EN','Cantal','cantal'),(16,'en_EN','Charente','charente'),(17,'en_EN','Charente-Maritime','charente-maritime'),(18,'en_EN','Cher','cher'),(19,'en_EN','Corrèze','correze'),(20,'en_EN','Corse','corse'),(21,'en_EN','Côte d\'or','cote-d-or'),(22,'en_EN','Côtes d\'armor','cotes-d-armor'),(23,'en_EN','Creuse','creuse'),(24,'en_EN','Dordogne','dordogne'),(25,'en_EN','Doubs','doubs'),(26,'en_EN','Drôme','drome'),(27,'en_EN','Eure','eure'),(28,'en_EN','Eure-et-Loir','eure-et-loir'),(29,'en_EN','Finistère','finistere'),(30,'en_EN','Gard','gard'),(31,'en_EN','Haute-Garonne','haute-garonne'),(32,'en_EN','Gers','gers'),(33,'en_EN','Gironde','gironde'),(34,'en_EN','Hérault','herault'),(35,'en_EN','Ille-et-Vilaine','ille-et-vilaine'),(36,'en_EN','Indre','indre'),(37,'en_EN','Indre-et-Loire','indre-et-loire'),(38,'en_EN','Isère','isere'),(39,'en_EN','Jura','jura'),(40,'en_EN','Landes','landes'),(41,'en_EN','Loir-et-Cher','loir-et-cher'),(42,'en_EN','Loire','loire'),(43,'en_EN','Haute-Loire','haute-loire'),(44,'en_EN','Loire-Atlantique','loire-atlantique'),(45,'en_EN','Loiret','loiret'),(46,'en_EN','Lot','lot'),(47,'en_EN','Lot-et-Garonne','lot-et-garonne'),(48,'en_EN','Lozère','lozere'),(49,'en_EN','Maine-et-Loire','maine-et-loire'),(50,'en_EN','Manche','manche'),(51,'en_EN','Marne','marne'),(52,'en_EN','Haute-Marne','haute-marne'),(53,'en_EN','Mayenne','mayenne'),(54,'en_EN','Meurthe-et-Moselle','meurthe-et-moselle'),(55,'en_EN','Meuse','meuse'),(56,'en_EN','Morbihan','morbihan'),(57,'en_EN','Moselle','moselle'),(58,'en_EN','Nièvre','nievre'),(59,'en_EN','Nord','nord'),(60,'en_EN','Oise','oise'),(61,'en_EN','Orne','orne'),(62,'en_EN','Pas-de-Calais','pas-de-calais'),(63,'en_EN','Puy-de-Dôme','puy-de-dome'),(64,'en_EN','Pyrénées Atlantiques','pyrenees-atlantiques'),(65,'en_EN','Hautes-Pyrénées','hautes-pyrenees'),(66,'en_EN','Pyrénées Orientales','pyrenees-orientales'),(67,'en_EN','Bas-Rhin','bas-rhin'),(68,'en_EN','Haut-Rhin','haut-rhin'),(69,'en_EN','Rhône','rhone'),(70,'en_EN','Haute-Saône','haute-saone'),(71,'en_EN','Saône et Loire','saone-et-loire'),(72,'en_EN','Sarthe','sarthe'),(73,'en_EN','Savoie','savoie'),(74,'en_EN','Haute-Savoie','haute-savoie'),(75,'en_EN','Paris','paris'),(76,'en_EN','Seine-Maritime','seine-maritime'),(77,'en_EN','Seine-et-Marne','seine-et-marne'),(78,'en_EN','Yvelines','yvelines'),(79,'en_EN','Deux-Sèvres','deux-sevres'),(80,'en_EN','Somme','somme'),(81,'en_EN','Tarn','tarn'),(82,'en_EN','Tarn-et-Garonne','tarn-et-garonne'),(83,'en_EN','Var','var'),(84,'en_EN','Vaucluse','vaucluse'),(85,'en_EN','Vendée','vendee'),(86,'en_EN','Vienne','vienne'),(87,'en_EN','Haute-Vienne','haute-vienne'),(88,'en_EN','Vosges','vosges'),(89,'en_EN','Yonne','yonne'),(90,'en_EN','Territoire de Belfort','territoire-de-belfort'),(91,'en_EN','Essonne','essonne'),(92,'en_EN','Hauts-de-Seine','hauts-de-seine'),(93,'en_EN','Seine-Saint-Denis','seine-saint-denis'),(94,'en_EN','Val-de-Marne','val-de-marne'),(95,'en_EN','Val-d\'Oise','val-d-oise'),(1,'fr','Ain','ain'),(2,'fr','Aisne','aisne'),(3,'fr','Allier','allier'),(4,'fr','Alpes-de-Haute-Provence','alpes-de-haute-provence'),(5,'fr','Hautes-Alpes','hautes-alpes'),(6,'fr','Alpes-Maritimes','alpes-maritimes'),(7,'fr','Ard','ardeche'),(8,'fr','Ardennes','ardennes'),(9,'fr','Ari','ariege'),(10,'fr','Aube','aube'),(11,'fr','Aude','aude'),(12,'fr','Aveyron','aveyron'),(13,'fr','Bouches-du-Rh','bouches-du-rhone'),(14,'fr','Calvados','calvados'),(15,'fr','Cantal','cantal'),(16,'fr','Charente','charente'),(17,'fr','Charente-Maritime','charente-maritime'),(18,'fr','Cher','cher'),(19,'fr','Corr','correze'),(20,'fr','Corse','corse'),(21,'fr','C','cote-d-or'),(22,'fr','C','cotes-d-armor'),(23,'fr','Creuse','creuse'),(24,'fr','Dordogne','dordogne'),(25,'fr','Doubs','doubs'),(26,'fr','Dr','drome'),(27,'fr','Eure','eure'),(28,'fr','Eure-et-Loir','eure-et-loir'),(29,'fr','Finist','finistere'),(30,'fr','Gard','gard'),(31,'fr','Haute-Garonne','haute-garonne'),(32,'fr','Gers','gers'),(33,'fr','Gironde','gironde'),(34,'fr','H','herault'),(35,'fr','Ille-et-Vilaine','ille-et-vilaine'),(36,'fr','Indre','indre'),(37,'fr','Indre-et-Loire','indre-et-loire'),(38,'fr','Is','isere'),(39,'fr','Jura','jura'),(40,'fr','Landes','landes'),(41,'fr','Loir-et-Cher','loir-et-cher'),(42,'fr','Loire','loire'),(43,'fr','Haute-Loire','haute-loire'),(44,'fr','Loire-Atlantique','loire-atlantique'),(45,'fr','Loiret','loiret'),(46,'fr','Lot','lot'),(47,'fr','Lot-et-Garonne','lot-et-garonne'),(48,'fr','Loz','lozere'),(49,'fr','Maine-et-Loire','maine-et-loire'),(50,'fr','Manche','manche'),(51,'fr','Marne','marne'),(52,'fr','Haute-Marne','haute-marne'),(53,'fr','Mayenne','mayenne'),(54,'fr','Meurthe-et-Moselle','meurthe-et-moselle'),(55,'fr','Meuse','meuse'),(56,'fr','Morbihan','morbihan'),(57,'fr','Moselle','moselle'),(58,'fr','Ni','nievre'),(59,'fr','Nord','nord'),(60,'fr','Oise','oise'),(61,'fr','Orne','orne'),(62,'fr','Pas-de-Calais','pas-de-calais'),(63,'fr','Puy-de-D','puy-de-dome'),(64,'fr','Pyr','pyrenees-atlantiques'),(65,'fr','Hautes-Pyr','hautes-pyrenees'),(66,'fr','Pyr','pyrenees-orientales'),(67,'fr','Bas-Rhin','bas-rhin'),(68,'fr','Haut-Rhin','haut-rhin'),(69,'fr','Rh','rhone'),(70,'fr','Haute-Sa','haute-saone'),(71,'fr','Sa','saone-et-loire'),(72,'fr','Sarthe','sarthe'),(73,'fr','Savoie','savoie'),(74,'fr','Haute-Savoie','haute-savoie'),(75,'fr','Paris','paris'),(76,'fr','Seine-Maritime','seine-maritime'),(77,'fr','Seine-et-Marne','seine-et-marne'),(78,'fr','Yvelines','yvelines'),(79,'fr','Deux-S','deux-sevres'),(80,'fr','Somme','somme'),(81,'fr','Tarn','tarn'),(82,'fr','Tarn-et-Garonne','tarn-et-garonne'),(83,'fr','Var','var'),(84,'fr','Vaucluse','vaucluse'),(85,'fr','Vend','vendee'),(86,'fr','Vienne','vienne'),(87,'fr','Haute-Vienne','haute-vienne'),(88,'fr','Vosges','vosges'),(89,'fr','Yonne','yonne'),(90,'fr','Territoire de Belfort','territoire-de-belfort'),(91,'fr','Essonne','essonne'),(92,'fr','Hauts-de-Seine','hauts-de-seine'),(93,'fr','Seine-Saint-Denis','seine-saint-denis'),(94,'fr','Val-de-Marne','val-de-marne'),(95,'fr','Val-d\'Oise','val-d-oise'),(975,'en_EN','Anvers','anvers');
/*!40000 ALTER TABLE `geo_departement_i18n` 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
