-- MySQL dump 10.13  Distrib 5.5.62, for debian-linux-gnu (i686)
--
-- Host: fcefrancxdck867a.mysql.db    Database: fcefrancxdck867a
-- ------------------------------------------------------
-- Server version	8.0.45-36

/*!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 */;

--
-- Table structure for table `activite`
--

DROP TABLE IF EXISTS `activite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activite_audit`
--

DROP TABLE IF EXISTS `activite_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activite_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activite_preinscription`
--

DROP TABLE IF EXISTS `activite_preinscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activite_preinscription` (
  `preinscription_id` int NOT NULL,
  `activite_id` int NOT NULL,
  PRIMARY KEY (`preinscription_id`,`activite_id`),
  KEY `IDX_B99766598337288` (`preinscription_id`),
  KEY `IDX_B99766599B0F88B1` (`activite_id`),
  CONSTRAINT `FK_B99766598337288` FOREIGN KEY (`preinscription_id`) REFERENCES `preinscription` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_B99766599B0F88B1` FOREIGN KEY (`activite_id`) REFERENCES `activite` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activite_user`
--

DROP TABLE IF EXISTS `activite_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activite_user` (
  `activite_id` int NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`activite_id`),
  KEY `IDX_FA43CF3BA76ED395` (`user_id`),
  KEY `IDX_FA43CF3B9B0F88B1` (`activite_id`),
  CONSTRAINT `FK_FA43CF3B9B0F88B1` FOREIGN KEY (`activite_id`) REFERENCES `activite` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_FA43CF3BA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `activiteparent`
--

DROP TABLE IF EXISTS `activiteparent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `activiteparent` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `annonce`
--

DROP TABLE IF EXISTS `annonce`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annonce` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `annonce_cat_id` int DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `date_publication` datetime NOT NULL,
  `date_fin` datetime NOT NULL,
  `date_creation` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `IDX_F65593E5A76ED395` (`user_id`),
  KEY `IDX_F65593E5860AAA5D` (`annonce_cat_id`),
  CONSTRAINT `FK_F65593E5860AAA5D` FOREIGN KEY (`annonce_cat_id`) REFERENCES `annoncecat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_F65593E5A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=179 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `annonce_audit`
--

DROP TABLE IF EXISTS `annonce_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annonce_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `annonce_cat_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `description` longtext,
  `date_publication` datetime DEFAULT NULL,
  `date_fin` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `annoncecat`
--

DROP TABLE IF EXISTS `annoncecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annoncecat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `annoncecat_audit`
--

DROP TABLE IF EXISTS `annoncecat_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `annoncecat_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `article`
--

DROP TABLE IF EXISTS `article`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article` (
  `id` int NOT NULL AUTO_INCREMENT,
  `article_cat_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `resume` longtext,
  `description` longtext NOT NULL,
  `date` date NOT NULL,
  `slug` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_23A0E66989D9B62` (`slug`),
  KEY `IDX_23A0E668C6A3EC3` (`article_cat_id`),
  KEY `IDX_23A0E66EA9FDD75` (`media_id`),
  CONSTRAINT `FK_23A0E668C6A3EC3` FOREIGN KEY (`article_cat_id`) REFERENCES `articlecat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_23A0E66EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `article_audit`
--

DROP TABLE IF EXISTS `article_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `article_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `article_cat_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `resume` longtext,
  `description` longtext,
  `date` date DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `articlecat`
--

DROP TABLE IF EXISTS `articlecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `articlecat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `slug` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8A8B0004989D9B62` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `bureaunational`
--

DROP TABLE IF EXISTS `bureaunational`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bureaunational` (
  `id` int NOT NULL AUTO_INCREMENT,
  `photo` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `prenom` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `fonction` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `mission` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `fb` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tw` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `viadeo` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `linked` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `google` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `tel` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `mail` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_83EFE8C814B78418` (`photo`),
  KEY `IDX_83EFE8C856CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_83EFE8C814B78418` FOREIGN KEY (`photo`) REFERENCES `media__media` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_83EFE8C856CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `classification__category`
--

DROP TABLE IF EXISTS `classification__category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classification__category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT NULL,
  `context` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `position` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_43629B36727ACA70` (`parent_id`),
  KEY `IDX_43629B36E25D857E` (`context`),
  KEY `IDX_43629B36EA9FDD75` (`media_id`),
  CONSTRAINT `FK_43629B36727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `classification__category` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_43629B36E25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_43629B36EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `classification__collection`
--

DROP TABLE IF EXISTS `classification__collection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classification__collection` (
  `id` int NOT NULL AUTO_INCREMENT,
  `context` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_collection` (`slug`,`context`),
  KEY `IDX_A406B56AE25D857E` (`context`),
  KEY `IDX_A406B56AEA9FDD75` (`media_id`),
  CONSTRAINT `FK_A406B56AE25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_A406B56AEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `classification__context`
--

DROP TABLE IF EXISTS `classification__context`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classification__context` (
  `id` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `classification__tag`
--

DROP TABLE IF EXISTS `classification__tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classification__tag` (
  `id` int NOT NULL AUTO_INCREMENT,
  `context` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_context` (`slug`,`context`),
  KEY `IDX_CA57A1C7E25D857E` (`context`),
  CONSTRAINT `FK_CA57A1C7E25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `contact`
--

DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `firstname` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `societe` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `localisation` varchar(512) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `code_postal` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `request` longtext COLLATE utf8mb3_unicode_ci,
  `date_created` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5676 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cotisationnational`
--

DROP TABLE IF EXISTS `cotisationnational`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cotisationnational` (
  `id` int NOT NULL AUTO_INCREMENT,
  `min_salarie` int NOT NULL,
  `max_salarie` int NOT NULL,
  `montant` int NOT NULL,
  `reversement` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `cotisationnational_audit`
--

DROP TABLE IF EXISTS `cotisationnational_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cotisationnational_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `min_salarie` int DEFAULT NULL,
  `max_salarie` int DEFAULT NULL,
  `montant` int DEFAULT NULL,
  `reversement` int DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `credits`
--

DROP TABLE IF EXISTS `credits`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `credits` (
  `id` int NOT NULL,
  `payment_instruction_id` int NOT NULL,
  `payment_id` int DEFAULT NULL,
  `attention_required` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `credited_amount` decimal(10,5) NOT NULL,
  `crediting_amount` decimal(10,5) NOT NULL,
  `reversing_amount` decimal(10,5) NOT NULL,
  `state` smallint NOT NULL,
  `target_amount` decimal(10,5) NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegation`
--

DROP TABLE IF EXISTS `delegation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `bureau` longtext,
  `presse` longtext,
  `partenariats` longtext,
  `presentation` longtext,
  `mail` varchar(2058) DEFAULT NULL,
  `mailing_password` longtext,
  `newsletter` longtext,
  `img1` int DEFAULT NULL,
  `img2` int DEFAULT NULL,
  `img3` int DEFAULT NULL,
  `img4` int DEFAULT NULL,
  `img5` int DEFAULT NULL,
  `img6` int DEFAULT NULL,
  `cotisation` int DEFAULT NULL,
  `paypal_account` varchar(200) DEFAULT NULL,
  `cheque_adresse` longtext,
  `region_id` int DEFAULT NULL,
  `slug` varchar(128) NOT NULL,
  `media_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_292F436D989D9B62` (`slug`),
  KEY `IDX_292F436D98260155` (`region_id`),
  KEY `IDX_292F436D5C07C2BC` (`img1`),
  KEY `IDX_292F436DC50E9306` (`img2`),
  KEY `IDX_292F436DB209A390` (`img3`),
  KEY `IDX_292F436D2C6D3633` (`img4`),
  KEY `IDX_292F436D5B6A06A5` (`img5`),
  KEY `IDX_292F436DC263571F` (`img6`),
  KEY `IDX_292F436DEA9FDD75` (`media_id`),
  CONSTRAINT `FK_292F436D2C6D3633` FOREIGN KEY (`img4`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436D5B6A06A5` FOREIGN KEY (`img5`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436D5C07C2BC` FOREIGN KEY (`img1`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436D98260155` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436DB209A390` FOREIGN KEY (`img3`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436DC263571F` FOREIGN KEY (`img6`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436DC50E9306` FOREIGN KEY (`img2`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_292F436DEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=5580 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegation_audit`
--

DROP TABLE IF EXISTS `delegation_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegation_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `bureau` longtext,
  `presse` longtext,
  `partenariats` longtext,
  `revtype` varchar(4) NOT NULL,
  `presentation` longtext,
  `mailing_password` longtext,
  `newsletter` longtext,
  `img1` int DEFAULT NULL,
  `img2` int DEFAULT NULL,
  `img3` int DEFAULT NULL,
  `img4` int DEFAULT NULL,
  `img5` int DEFAULT NULL,
  `img6` int DEFAULT NULL,
  `cotisation` int DEFAULT NULL,
  `paypal_account` varchar(200) DEFAULT NULL,
  `cheque_adresse` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegation_region`
--

DROP TABLE IF EXISTS `delegation_region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegation_region` (
  `delegation_id` int NOT NULL,
  `region_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationalbum`
--

DROP TABLE IF EXISTS `delegationalbum`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationalbum` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delegation_id` int DEFAULT NULL,
  `album` longtext,
  `file` varchar(2048) DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `description` longtext,
  PRIMARY KEY (`id`),
  KEY `IDX_A6CCB45A56CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_A6CCB45A56CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationalbum_audit`
--

DROP TABLE IF EXISTS `delegationalbum_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationalbum_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `delegation_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `album` longtext,
  `revtype` varchar(4) NOT NULL,
  `date` date DEFAULT NULL,
  `description` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationbureau`
--

DROP TABLE IF EXISTS `delegationbureau`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationbureau` (
  `id` int NOT NULL AUTO_INCREMENT,
  `photo` int DEFAULT NULL,
  `nom` varchar(255) NOT NULL,
  `prenom` varchar(255) NOT NULL,
  `fonction` varchar(255) NOT NULL,
  `delegation_id` int DEFAULT NULL,
  `fb` varchar(255) DEFAULT NULL,
  `tw` varchar(255) DEFAULT NULL,
  `viadeo` varchar(255) DEFAULT NULL,
  `linked` varchar(255) DEFAULT NULL,
  `google` varchar(255) DEFAULT NULL,
  `mission` longtext NOT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `mail` varchar(255) DEFAULT NULL,
  `position` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_729B22DE14B78418` (`photo`),
  KEY `IDX_729B22DE56CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_729B22DE14B78418` FOREIGN KEY (`photo`) REFERENCES `media__media` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_729B22DE56CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=1253 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationcommunication`
--

DROP TABLE IF EXISTS `delegationcommunication`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationcommunication` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delegationcommunicationcat_id` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `file` int DEFAULT NULL,
  `video` varchar(255) DEFAULT NULL,
  `album` varchar(255) DEFAULT NULL,
  `site` varchar(255) DEFAULT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_51A139C08C9F3610` (`file`),
  KEY `IDX_51A139C0C3DD57E7` (`delegationcommunicationcat_id`),
  KEY `IDX_51A139C056CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_51A139C056CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_51A139C08C9F3610` FOREIGN KEY (`file`) REFERENCES `media__media` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_51A139C0C3DD57E7` FOREIGN KEY (`delegationcommunicationcat_id`) REFERENCES `delegationcommunicationcat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationcommunicationcat`
--

DROP TABLE IF EXISTS `delegationcommunicationcat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationcommunicationcat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `media_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A0A4CB7DEA9FDD75` (`media_id`),
  CONSTRAINT `FK_A0A4CB7DEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationpartenaire`
--

DROP TABLE IF EXISTS `delegationpartenaire`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationpartenaire` (
  `id` int NOT NULL AUTO_INCREMENT,
  `img` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `societe` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `partenaire_cat_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8B8A1FC4BBC2C8AC` (`img`),
  KEY `IDX_8B8A1FC456CBBCF5` (`delegation_id`),
  KEY `IDX_8B8A1FC4CDD01090` (`partenaire_cat_id`),
  CONSTRAINT `FK_8B8A1FC456CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8B8A1FC4BBC2C8AC` FOREIGN KEY (`img`) REFERENCES `media__media` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_8B8A1FC4CDD01090` FOREIGN KEY (`partenaire_cat_id`) REFERENCES `partenairecat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationrecompense`
--

DROP TABLE IF EXISTS `delegationrecompense`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationrecompense` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delegationrecompensecat_id` int DEFAULT NULL,
  `img` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `nom` varchar(255) NOT NULL,
  `soustitre` varchar(255) DEFAULT NULL,
  `text` longtext NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A7EE7C691FE387F1` (`delegationrecompensecat_id`),
  KEY `IDX_A7EE7C69BBC2C8AC` (`img`),
  KEY `IDX_A7EE7C6956CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_A7EE7C691FE387F1` FOREIGN KEY (`delegationrecompensecat_id`) REFERENCES `delegationrecompensecat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_A7EE7C6956CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_A7EE7C69BBC2C8AC` FOREIGN KEY (`img`) REFERENCES `media__media` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=128 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `delegationrecompensecat`
--

DROP TABLE IF EXISTS `delegationrecompensecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `delegationrecompensecat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `soustitre` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `doc`
--

DROP TABLE IF EXISTS `doc`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `region_id` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `titre` varchar(255) NOT NULL,
  `description` longtext,
  `date_publication` datetime NOT NULL,
  `level` longtext COMMENT '(DC2Type:array)',
  `cat_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8641FD64A76ED395` (`user_id`),
  KEY `IDX_8641FD6498260155` (`region_id`),
  KEY `IDX_8641FD6456CBBCF5` (`delegation_id`),
  KEY `IDX_8641FD64E6ADA943` (`cat_id`),
  KEY `IDX_8641FD64EA9FDD75` (`media_id`),
  CONSTRAINT `FK_8641FD6456CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8641FD6498260155` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8641FD64A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8641FD64E6ADA943` FOREIGN KEY (`cat_id`) REFERENCES `doccat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8641FD64EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=1465 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `doc_audit`
--

DROP TABLE IF EXISTS `doc_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doc_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `region_id` int DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `description` longtext,
  `date_publication` datetime DEFAULT NULL,
  `level` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `cat_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `doccat`
--

DROP TABLE IF EXISTS `doccat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doccat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `parent_id` int DEFAULT NULL,
  `ordre` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7149CE24727ACA70` (`parent_id`),
  CONSTRAINT `FK_7149CE24727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `doccat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `doccat_audit`
--

DROP TABLE IF EXISTS `doccat_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `doccat_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `parent_id` int DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `ordre` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `evenement`
--

DROP TABLE IF EXISTS `evenement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `evenement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `mailing_url` varchar(255) DEFAULT NULL,
  `delegation_id` int DEFAULT NULL,
  `date` datetime NOT NULL,
  `public` tinyint(1) NOT NULL,
  `inscription` tinyint(1) NOT NULL,
  `public_inscription` tinyint(1) NOT NULL,
  `is_free` tinyint(1) NOT NULL,
  `montant` double DEFAULT NULL,
  `resume` longtext,
  `is_region` tinyint(1) NOT NULL,
  `is_international` tinyint(1) NOT NULL,
  `is_national` tinyint(1) NOT NULL,
  `media_id` int DEFAULT NULL,
  `date_fin` datetime DEFAULT NULL,
  `montant_nonadherente` double DEFAULT NULL,
  `slug` varchar(128) NOT NULL,
  `weezeventLink` varchar(255) DEFAULT NULL,
  `date_creation` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B26681E989D9B62` (`slug`),
  KEY `IDX_B26681E56CBBCF5` (`delegation_id`),
  KEY `IDX_B26681EEA9FDD75` (`media_id`),
  CONSTRAINT `FK_B26681E56CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_B26681EEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2489 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `evenement_audit`
--

DROP TABLE IF EXISTS `evenement_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `evenement_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `delegation_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `description` longtext,
  `mailing_url` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `public` tinyint(1) DEFAULT NULL,
  `inscription` tinyint(1) DEFAULT NULL,
  `public_inscription` tinyint(1) DEFAULT NULL,
  `is_free` tinyint(1) DEFAULT NULL,
  `montant` double DEFAULT NULL,
  `resume` longtext,
  `is_region` tinyint(1) DEFAULT NULL,
  `is_international` tinyint(1) DEFAULT NULL,
  `is_national` tinyint(1) DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `date_fin` datetime DEFAULT NULL,
  `montant_nonadherente` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `evenementinscription`
--

DROP TABLE IF EXISTS `evenementinscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `evenementinscription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `evenement_id` int DEFAULT NULL,
  `commentaire` longtext,
  `type_paiement` varchar(255) DEFAULT NULL,
  `valid_paiement` tinyint(1) DEFAULT NULL,
  `date_inscription` date NOT NULL,
  `date_paiement` datetime DEFAULT NULL,
  `paypal_id` varchar(20) DEFAULT NULL,
  `montant` double DEFAULT NULL,
  `invite_nom` varchar(255) DEFAULT NULL,
  `invite_prenom` varchar(255) DEFAULT NULL,
  `invite_mail` varchar(255) DEFAULT NULL,
  `invite_soc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_CCA1BAE0A76ED395` (`user_id`),
  KEY `IDX_CCA1BAE0FD02F13` (`evenement_id`),
  CONSTRAINT `FK_CCA1BAE0A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_CCA1BAE0FD02F13` FOREIGN KEY (`evenement_id`) REFERENCES `evenement` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=2465 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `evenementinscription_audit`
--

DROP TABLE IF EXISTS `evenementinscription_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `evenementinscription_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `evenement_id` int DEFAULT NULL,
  `commentaire` longtext,
  `type_paiement` varchar(255) DEFAULT NULL,
  `valid_paiement` tinyint(1) DEFAULT NULL,
  `date_inscription` date DEFAULT NULL,
  `date_paiement` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `paypal_id` varchar(20) DEFAULT NULL,
  `montant` double DEFAULT NULL,
  `invite_nom` varchar(255) DEFAULT NULL,
  `invite_prenom` varchar(255) DEFAULT NULL,
  `invite_mail` varchar(255) DEFAULT NULL,
  `invite_soc` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `evenementpart_audit`
--

DROP TABLE IF EXISTS `evenementpart_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `evenementpart_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `evenemnt_id` int DEFAULT NULL,
  `titre` varchar(255) DEFAULT NULL,
  `public_inscription` tinyint(1) DEFAULT NULL,
  `is_free` tinyint(1) DEFAULT NULL,
  `montant` double DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `financial_transactions`
--

DROP TABLE IF EXISTS `financial_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `financial_transactions` (
  `id` int NOT NULL,
  `credit_id` int DEFAULT NULL,
  `payment_id` int DEFAULT NULL,
  `extended_data` longtext,
  `processed_amount` decimal(10,5) NOT NULL,
  `reason_code` varchar(100) DEFAULT NULL,
  `reference_number` varchar(100) DEFAULT NULL,
  `requested_amount` decimal(10,5) NOT NULL,
  `response_code` varchar(100) DEFAULT NULL,
  `state` smallint NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `tracking_id` varchar(100) DEFAULT NULL,
  `transaction_type` smallint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `groups_audit`
--

DROP TABLE IF EXISTS `groups_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groups_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `roles` longtext COMMENT '(DC2Type:array)',
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `groupstmp`
--

DROP TABLE IF EXISTS `groupstmp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `groupstmp` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `roles` longtext NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F06D39705E237E06` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `international`
--

DROP TABLE IF EXISTS `international`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `international` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lib` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `landing`
--

DROP TABLE IF EXISTS `landing`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `landing` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(1024) NOT NULL,
  `prenom` varchar(1024) NOT NULL,
  `mail` varchar(2048) NOT NULL,
  `pays` varchar(2048) NOT NULL,
  `delegation_id` int NOT NULL,
  `accord` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FK_landing_delegation` (`delegation_id`),
  CONSTRAINT `FK_landing_delegation` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mandat`
--

DROP TABLE IF EXISTS `mandat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mandat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mandat_audit`
--

DROP TABLE IF EXISTS `mandat_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mandat_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `mandat_user`
--

DROP TABLE IF EXISTS `mandat_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mandat_user` (
  `mandat_id` int NOT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`mandat_id`),
  KEY `IDX_A504A823A76ED395` (`user_id`),
  KEY `IDX_A504A823C687DD98` (`mandat_id`),
  CONSTRAINT `FK_A504A823A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_A504A823C687DD98` FOREIGN KEY (`mandat_id`) REFERENCES `mandat` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__gallery`
--

DROP TABLE IF EXISTS `media__gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__gallery` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `context` varchar(64) NOT NULL,
  `default_format` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__gallery_audit`
--

DROP TABLE IF EXISTS `media__gallery_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__gallery_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `context` varchar(255) DEFAULT NULL,
  `default_format` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__gallery_media`
--

DROP TABLE IF EXISTS `media__gallery_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__gallery_media` (
  `id` int NOT NULL AUTO_INCREMENT,
  `gallery_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `position` int NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_80D4C5414E7AF8F` (`gallery_id`),
  KEY `IDX_80D4C541EA9FDD75` (`media_id`),
  CONSTRAINT `FK_80D4C5414E7AF8F` FOREIGN KEY (`gallery_id`) REFERENCES `media__gallery` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_80D4C541EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__gallery_media_audit`
--

DROP TABLE IF EXISTS `media__gallery_media_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__gallery_media_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `gallery_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `position` int DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__media`
--

DROP TABLE IF EXISTS `media__media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__media` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `enabled` tinyint(1) NOT NULL,
  `provider_name` varchar(255) NOT NULL,
  `provider_status` int NOT NULL,
  `provider_reference` varchar(255) NOT NULL,
  `provider_metadata` longtext COMMENT '(DC2Type:json)',
  `width` int DEFAULT NULL,
  `height` int DEFAULT NULL,
  `length` decimal(10,0) DEFAULT NULL,
  `content_type` varchar(255) DEFAULT NULL,
  `content_size` int DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `context` varchar(64) DEFAULT NULL,
  `cdn_is_flushable` tinyint(1) DEFAULT NULL,
  `cdn_flush_at` datetime DEFAULT NULL,
  `cdn_status` int DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `category_id` int DEFAULT NULL,
  `cdn_flush_identifier` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5C6DD74E12469DE2` (`category_id`),
  CONSTRAINT `FK_5C6DD74E12469DE2` FOREIGN KEY (`category_id`) REFERENCES `classification__category` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=23963 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `media__media_audit`
--

DROP TABLE IF EXISTS `media__media_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `media__media_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `enabled` tinyint(1) DEFAULT NULL,
  `provider_name` varchar(255) DEFAULT NULL,
  `provider_status` int DEFAULT NULL,
  `provider_reference` varchar(255) DEFAULT NULL,
  `provider_metadata` longtext COMMENT '(DC2Type:array)',
  `width` int DEFAULT NULL,
  `height` int DEFAULT NULL,
  `length` decimal(10,0) DEFAULT NULL,
  `content_type` varchar(64) DEFAULT NULL,
  `content_size` int DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `author_name` varchar(255) DEFAULT NULL,
  `context` varchar(16) DEFAULT NULL,
  `cdn_is_flushable` tinyint(1) DEFAULT NULL,
  `cdn_flush_at` datetime DEFAULT NULL,
  `cdn_status` int DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `newsletter`
--

DROP TABLE IF EXISTS `newsletter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `newsletter` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_7E8585C8E7927C74` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3064 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `page`
--

DROP TABLE IF EXISTS `page`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `page` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `date` datetime DEFAULT NULL,
  `rubrique` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `slug` varchar(128) COLLATE utf8mb3_unicode_ci NOT NULL,
  `position` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_140AB620989D9B62` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `paiement`
--

DROP TABLE IF EXISTS `paiement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paiement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `date_paiement` datetime DEFAULT NULL,
  `is_cotisation` tinyint(1) NOT NULL,
  `montant` double NOT NULL,
  `inscription_id` int DEFAULT NULL,
  `droit_entree` double DEFAULT NULL,
  `national` double DEFAULT NULL,
  `local` double DEFAULT NULL,
  `honoraire` double DEFAULT NULL,
  `sympathisant` double DEFAULT NULL,
  `annee_cotisation` int DEFAULT NULL,
  `paypal_id` varchar(1024) DEFAULT NULL,
  `droit_entree_reversement` double DEFAULT NULL,
  `national_reversement` double DEFAULT NULL,
  `honoraire_reversement` double DEFAULT NULL,
  `sympathisant_reversement` double DEFAULT NULL,
  `date_reversement` datetime DEFAULT NULL,
  `reversement_recu` tinyint(1) DEFAULT NULL,
  `motif_modification` varchar(2058) DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  `user_id_modification` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_B1DC7A1E5DAC5993` (`inscription_id`),
  KEY `IDX_B1DC7A1EA76ED395` (`user_id`),
  CONSTRAINT `FK_B1DC7A1E5DAC5993` FOREIGN KEY (`inscription_id`) REFERENCES `evenementinscription` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_B1DC7A1EA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=25504 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `paiement_audit`
--

DROP TABLE IF EXISTS `paiement_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paiement_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `inscription_id` int DEFAULT NULL,
  `date_paiement` datetime DEFAULT NULL,
  `paypal_id` varchar(20) DEFAULT NULL,
  `annee_cotisation` int DEFAULT NULL,
  `is_cotisation` tinyint(1) DEFAULT NULL,
  `montant` double DEFAULT NULL,
  `droit_entree` double DEFAULT NULL,
  `national` double DEFAULT NULL,
  `local` double DEFAULT NULL,
  `honoraire` double DEFAULT NULL,
  `sympathisant` double DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `droit_entree_reversement` double DEFAULT NULL,
  `national_reversement` double DEFAULT NULL,
  `honoraire_reversement` double DEFAULT NULL,
  `sympathisant_reversement` double DEFAULT NULL,
  `date_reversement` datetime DEFAULT NULL,
  `reversement_recu` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `partenaire`
--

DROP TABLE IF EXISTS `partenaire`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `partenaire` (
  `id` int NOT NULL AUTO_INCREMENT,
  `partenaire_cat_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `titre` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb3_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_32FFA373CDD01090` (`partenaire_cat_id`),
  KEY `IDX_32FFA373EA9FDD75` (`media_id`),
  CONSTRAINT `FK_32FFA373CDD01090` FOREIGN KEY (`partenaire_cat_id`) REFERENCES `partenairecat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_32FFA373EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `partenairecat`
--

DROP TABLE IF EXISTS `partenairecat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `partenairecat` (
  `id` int NOT NULL AUTO_INCREMENT,
  `titre` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `past_presidente`
--

DROP TABLE IF EXISTS `past_presidente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `past_presidente` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `is_passed` tinyint(1) DEFAULT '1',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1D8D79B4A76ED395` (`user_id`),
  CONSTRAINT `FK_1D8D79B4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=356 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `payment_instructions`
--

DROP TABLE IF EXISTS `payment_instructions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payment_instructions` (
  `id` int NOT NULL,
  `amount` decimal(10,5) NOT NULL,
  `approved_amount` decimal(10,5) NOT NULL,
  `approving_amount` decimal(10,5) NOT NULL,
  `created_at` datetime NOT NULL,
  `credited_amount` decimal(10,5) NOT NULL,
  `crediting_amount` decimal(10,5) NOT NULL,
  `currency` varchar(3) NOT NULL,
  `deposited_amount` decimal(10,5) NOT NULL,
  `depositing_amount` decimal(10,5) NOT NULL,
  `extended_data` longtext NOT NULL,
  `payment_system_name` varchar(100) NOT NULL,
  `reversing_approved_amount` decimal(10,5) NOT NULL,
  `reversing_credited_amount` decimal(10,5) NOT NULL,
  `reversing_deposited_amount` decimal(10,5) NOT NULL,
  `state` smallint NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `payments` (
  `id` int NOT NULL,
  `payment_instruction_id` int NOT NULL,
  `approved_amount` decimal(10,5) NOT NULL,
  `approving_amount` decimal(10,5) NOT NULL,
  `credited_amount` decimal(10,5) NOT NULL,
  `crediting_amount` decimal(10,5) NOT NULL,
  `deposited_amount` decimal(10,5) NOT NULL,
  `depositing_amount` decimal(10,5) NOT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `reversing_approved_amount` decimal(10,5) NOT NULL,
  `reversing_credited_amount` decimal(10,5) NOT NULL,
  `reversing_deposited_amount` decimal(10,5) NOT NULL,
  `state` smallint NOT NULL,
  `target_amount` decimal(10,5) NOT NULL,
  `attention_required` tinyint(1) NOT NULL,
  `expired` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `preinscription`
--

DROP TABLE IF EXISTS `preinscription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `preinscription` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) NOT NULL,
  `prenom` varchar(255) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `birthday` date NOT NULL,
  `societe` varchar(255) NOT NULL,
  `nomCommercial` varchar(1024) DEFAULT NULL,
  `adresse` longtext,
  `cp` varchar(20) DEFAULT NULL,
  `ville` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `photo_id` int DEFAULT NULL,
  `commentaire` longtext,
  `delegation_id` int DEFAULT NULL,
  `status_id` int DEFAULT NULL,
  `created` datetime NOT NULL,
  `media_id` int DEFAULT NULL,
  `siret` longtext,
  `naf` longtext,
  `ca` longtext,
  `salarie` longtext,
  `fonction` longtext,
  `comm` longtext,
  `descriptif` longtext,
  `activiteParent_id` int DEFAULT NULL,
  `siret2` varchar(124) DEFAULT NULL,
  `nomCommercial2` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_649A5F6F56CBBCF5` (`delegation_id`),
  KEY `IDX_649A5F6F6BF700BD` (`status_id`),
  KEY `IDX_649A5F6FEA9FDD75` (`media_id`),
  KEY `IDX_649A5F6F43D3DCDB` (`activiteParent_id`),
  KEY `IDX_649A5F6F7E9E4C8C` (`photo_id`),
  CONSTRAINT `FK_649A5F6F43D3DCDB` FOREIGN KEY (`activiteParent_id`) REFERENCES `activiteparent` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_649A5F6F56CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_649A5F6F6BF700BD` FOREIGN KEY (`status_id`) REFERENCES `preinscriptionstatus` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_649A5F6FEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `preinscription_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=6949 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `preinscription_audit`
--

DROP TABLE IF EXISTS `preinscription_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `preinscription_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `delegation_id` int DEFAULT NULL,
  `status_id` int DEFAULT NULL,
  `nom` varchar(255) DEFAULT NULL,
  `prenom` varchar(255) DEFAULT NULL,
  `mail` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `societe` varchar(255) DEFAULT NULL,
  `adresse` longtext,
  `cp` varchar(20) DEFAULT NULL,
  `ville` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `commentaire` longtext,
  `created` datetime DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `media_id` int DEFAULT NULL,
  `siret` longtext,
  `naf` longtext,
  `ca` longtext,
  `salarie` longtext,
  `fonction` longtext,
  `comm` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `preinscriptionstatus`
--

DROP TABLE IF EXISTS `preinscriptionstatus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `preinscriptionstatus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `region`
--

DROP TABLE IF EXISTS `region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `region` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `mailing_password` longtext,
  `url_img` varchar(255) DEFAULT NULL,
  `dr_nom` varchar(255) DEFAULT NULL,
  `dr_prenom` varchar(255) DEFAULT NULL,
  `dr_tel` varchar(255) DEFAULT NULL,
  `dr_mail` varchar(255) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `region_audit`
--

DROP TABLE IF EXISTS `region_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `region_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `mailing_password` longtext,
  `url_img` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `revisions`
--

DROP TABLE IF EXISTS `revisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `revisions` (
  `id` int NOT NULL,
  `timestamp` datetime NOT NULL,
  `username` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `username_canonical` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_canonical` varchar(255) NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `locked` tinyint(1) NOT NULL,
  `expired` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  `confirmation_token` varchar(255) DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext NOT NULL COMMENT '(DC2Type:array)',
  `credentials_expired` tinyint(1) NOT NULL,
  `credentials_expire_at` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `two_step_code` varchar(255) DEFAULT NULL,
  `nom` varchar(255) DEFAULT NULL,
  `prenom` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `formation` longtext,
  `langue` longtext,
  `societe` varchar(255) DEFAULT NULL,
  `nomCommercial` varchar(1024) DEFAULT NULL,
  `adresse` longtext,
  `cp` varchar(20) DEFAULT NULL,
  `ville` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `ca` varchar(255) DEFAULT NULL,
  `salarie` varchar(255) DEFAULT NULL,
  `perso` longtext,
  `photo` varchar(255) DEFAULT NULL,
  `descriptif` longtext,
  `anneeAdhesion` int DEFAULT NULL,
  `adminComm` longtext,
  `statut_id` int DEFAULT NULL,
  `siret` varchar(255) DEFAULT NULL,
  `naf` varchar(255) DEFAULT NULL,
  `fonction` longtext,
  `kbis` varchar(255) DEFAULT NULL,
  `date_of_birth` datetime DEFAULT NULL,
  `firstname` varchar(64) DEFAULT NULL,
  `lastname` varchar(64) DEFAULT NULL,
  `website` varchar(64) DEFAULT NULL,
  `biography` varchar(1000) DEFAULT NULL,
  `gender` varchar(1) DEFAULT NULL,
  `locale` varchar(8) DEFAULT NULL,
  `timezone` varchar(64) DEFAULT NULL,
  `phone` varchar(64) DEFAULT NULL,
  `facebook_uid` varchar(255) DEFAULT NULL,
  `facebook_name` varchar(255) DEFAULT NULL,
  `facebook_data` longtext COMMENT '(DC2Type:json)',
  `twitter_uid` varchar(255) DEFAULT NULL,
  `twitter_name` varchar(255) DEFAULT NULL,
  `twitter_data` longtext COMMENT '(DC2Type:json)',
  `gplus_uid` varchar(255) DEFAULT NULL,
  `gplus_name` varchar(255) DEFAULT NULL,
  `gplus_data` longtext COMMENT '(DC2Type:json)',
  `token` varchar(255) DEFAULT NULL,
  `activiteParent_id` int DEFAULT NULL,
  `media_id` int DEFAULT NULL,
  `officeMember` tinyint(1) DEFAULT '0',
  `order_member` int DEFAULT NULL,
  `site_internet` varchar(255) DEFAULT NULL,
  `formation_n_da` varchar(1024) DEFAULT NULL,
  `formation_label` varchar(1024) DEFAULT NULL,
  `siret2` varchar(124) DEFAULT NULL,
  `nomCommercial2` varchar(1024) DEFAULT NULL,
  `mongo_id` varchar(24) DEFAULT NULL COMMENT 'MongoDB ObjectID source',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D64992FC23A8` (`username_canonical`),
  UNIQUE KEY `UNIQ_8D93D649A0D96FBF` (`email_canonical`),
  UNIQUE KEY `mongo_id` (`mongo_id`),
  KEY `IDX_8D93D649F6203804` (`statut_id`),
  KEY `IDX_8D93D64943D3DCDB` (`activiteParent_id`),
  KEY `IDX_8D93D649EA9FDD75` (`media_id`),
  KEY `idx_user_mongo_id` (`mongo_id`),
  CONSTRAINT `FK_8D93D64943D3DCDB` FOREIGN KEY (`activiteParent_id`) REFERENCES `activiteparent` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8D93D649EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8D93D649F6203804` FOREIGN KEY (`statut_id`) REFERENCES `userstatut` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=7341 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_audit`
--

DROP TABLE IF EXISTS `user_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `username_canonical` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `email_canonical` varchar(255) DEFAULT NULL,
  `enabled` tinyint(1) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `locked` tinyint(1) DEFAULT NULL,
  `expired` tinyint(1) DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  `confirmation_token` varchar(255) DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COMMENT '(DC2Type:array)',
  `credentials_expired` tinyint(1) DEFAULT NULL,
  `credentials_expire_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `two_step_code` varchar(255) DEFAULT NULL,
  `revtype` varchar(4) NOT NULL,
  `nom` varchar(255) DEFAULT NULL,
  `prenom` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `formation` longtext,
  `langue` longtext,
  `societe` varchar(255) DEFAULT NULL,
  `adresse` longtext,
  `cp` varchar(20) DEFAULT NULL,
  `ville` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `telephone` varchar(20) DEFAULT NULL,
  `ca` varchar(255) DEFAULT NULL,
  `salarie` varchar(255) DEFAULT NULL,
  `perso` longtext,
  `photo` varchar(255) DEFAULT NULL,
  `descriptif` longtext,
  `anneeAdhesion` int DEFAULT NULL,
  `adminComm` longtext,
  `statut_id` int DEFAULT NULL,
  `siret` varchar(255) DEFAULT NULL,
  `naf` varchar(255) DEFAULT NULL,
  `fonction` longtext,
  `kbis` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_delegation`
--

DROP TABLE IF EXISTS `user_delegation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_delegation` (
  `user_id` int NOT NULL,
  `delegation_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`delegation_id`),
  KEY `IDX_8E488581A76ED395` (`user_id`),
  KEY `IDX_8E48858156CBBCF5` (`delegation_id`),
  CONSTRAINT `FK_8E48858156CBBCF5` FOREIGN KEY (`delegation_id`) REFERENCES `delegation` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `FK_8E488581A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_group`
--

DROP TABLE IF EXISTS `user_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_group` (
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`group_id`),
  KEY `IDX_8F02BF9DA76ED395` (`user_id`),
  KEY `IDX_8F02BF9DFE54D947` (`group_id`),
  CONSTRAINT `FK_8F02BF9DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK_8F02BF9DFE54D947` FOREIGN KEY (`group_id`) REFERENCES `groupstmp` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `user_international`
--

DROP TABLE IF EXISTS `user_international`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_international` (
  `user_id` int NOT NULL,
  `international_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`international_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `userstatut`
--

DROP TABLE IF EXISTS `userstatut`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userstatut` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `reversement` int NOT NULL,
  `montant` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `userstatut_audit`
--

DROP TABLE IF EXISTS `userstatut_audit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `userstatut_audit` (
  `id` int NOT NULL,
  `rev` int NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `reversement` int DEFAULT NULL,
  `montant` int DEFAULT NULL,
  `revtype` varchar(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;
/*!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 2026-05-19 18:36:28
