--
-- Host: localhost    Database: 2kbes_website
-- ------------------------------------------------------


--
-- Table structure for table `abonnements`
--

CREATE TABLE `abonnements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `actif` tinyint(1) NOT NULL,
  `dateInscription` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `abonnements`
--


--
-- Table structure for table `acl_classes`
--

CREATE TABLE `acl_classes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class_type` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_69DD750638A36066` (`class_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_classes`
--


--
-- Table structure for table `acl_entries`
--

CREATE TABLE `acl_entries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int(10) unsigned NOT NULL,
  `object_identity_id` int(10) unsigned DEFAULT NULL,
  `security_identity_id` int(10) unsigned NOT NULL,
  `field_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ace_order` smallint(5) unsigned NOT NULL,
  `mask` int(11) NOT NULL,
  `granting` tinyint(1) NOT NULL,
  `granting_strategy` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `audit_success` tinyint(1) NOT NULL,
  `audit_failure` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_46C8B806EA000B103D9AB4A64DEF17BCE4289BF4` (`class_id`,`object_identity_id`,`field_name`,`ace_order`),
  KEY `IDX_46C8B806EA000B103D9AB4A6DF9183C9` (`class_id`,`object_identity_id`,`security_identity_id`),
  KEY `IDX_46C8B806EA000B10` (`class_id`),
  KEY `IDX_46C8B8063D9AB4A6` (`object_identity_id`),
  KEY `IDX_46C8B806DF9183C9` (`security_identity_id`),
  CONSTRAINT `FK_46C8B8063D9AB4A6` FOREIGN KEY (`object_identity_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_46C8B806DF9183C9` FOREIGN KEY (`security_identity_id`) REFERENCES `acl_security_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_46C8B806EA000B10` FOREIGN KEY (`class_id`) REFERENCES `acl_classes` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_entries`
--


--
-- Table structure for table `acl_object_identities`
--

CREATE TABLE `acl_object_identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_object_identity_id` int(10) unsigned DEFAULT NULL,
  `class_id` int(10) unsigned NOT NULL,
  `object_identifier` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `entries_inheriting` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9407E5494B12AD6EA000B10` (`object_identifier`,`class_id`),
  KEY `IDX_9407E54977FA751A` (`parent_object_identity_id`),
  CONSTRAINT `FK_9407E54977FA751A` FOREIGN KEY (`parent_object_identity_id`) REFERENCES `acl_object_identities` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_object_identities`
--


--
-- Table structure for table `acl_object_identity_ancestors`
--

CREATE TABLE `acl_object_identity_ancestors` (
  `object_identity_id` int(10) unsigned NOT NULL,
  `ancestor_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`object_identity_id`,`ancestor_id`),
  KEY `IDX_825DE2993D9AB4A6` (`object_identity_id`),
  KEY `IDX_825DE299C671CEA1` (`ancestor_id`),
  CONSTRAINT `FK_825DE2993D9AB4A6` FOREIGN KEY (`object_identity_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_825DE299C671CEA1` FOREIGN KEY (`ancestor_id`) REFERENCES `acl_object_identities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_object_identity_ancestors`
--


--
-- Table structure for table `acl_security_identities`
--

CREATE TABLE `acl_security_identities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `username` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8835EE78772E836AF85E0677` (`identifier`,`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acl_security_identities`
--


--
-- Table structure for table `annonces`
--

CREATE TABLE `annonces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `texte1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreation` datetime NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `boutontext` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `boutonurl` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_CB988C6F3DA5256D` (`image_id`),
  CONSTRAINT `FK_CB988C6F3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `annonces`
--

INSERT INTO `annonces` VALUES (1,NULL,'Une monde de jeu illimite','Avec 2K-BES, plus besoin de vous deplacer pour jouer! Il suffit de vous connecter via notre app mobile ou sur notre site!','0000-00-00 00:00:00',1,'Jouez maintenant','http://2kbes.s2telsolutions.ca/'),(2,NULL,'Votre  meilleur outil, CHALA!','Saviez-vous que plus de 2 a 3 joueurs sur 5 consulte regulierement leur chala avant de jouer?','0000-00-00 00:00:00',1,'Parcourez notre Chala','http://2kbes.s2telsolutions.ca/'),(3,NULL,'Il a gagne plus de $140 000 USD en un seul jeu','Voulez-vous gagner? Sortez le grand jeu maintenant!','0000-00-00 00:00:00',1,'Cliquez ici','http://2kbes.s2telsolutions.ca/');

--
-- Table structure for table `cellule`
--

CREATE TABLE `cellule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `actif` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cellule`
--


--
-- Table structure for table `cellulemembre`
--

CREATE TABLE `cellulemembre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cellule_id` int(11) DEFAULT NULL,
  `bergeragneau_id` int(11) DEFAULT NULL,
  `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `actif` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_3E2101AD96299DA6` (`cellule_id`),
  KEY `IDX_3E2101AD137DB223` (`bergeragneau_id`),
  CONSTRAINT `FK_3E2101AD137DB223` FOREIGN KEY (`bergeragneau_id`) REFERENCES `membres` (`id`),
  CONSTRAINT `FK_3E2101AD96299DA6` FOREIGN KEY (`cellule_id`) REFERENCES `cellule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cellulemembre`
--


--
-- Table structure for table `choralesgroupes`
--

CREATE TABLE `choralesgroupes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `nature` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vision` longtext COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `style` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `dateCreation` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_7E43EB5B3DA5256D` (`image_id`),
  CONSTRAINT `FK_7E43EB5B3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `choralesgroupes`
--


--
-- Table structure for table `choralesgroupesmembres`
--

CREATE TABLE `choralesgroupesmembres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membres_id` int(11) NOT NULL,
  `chorales_id` int(11) NOT NULL,
  `fonction` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateIntegration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_90A840A671128C5C` (`membres_id`),
  KEY `IDX_90A840A6EE81BED4` (`chorales_id`),
  CONSTRAINT `FK_90A840A671128C5C` FOREIGN KEY (`membres_id`) REFERENCES `membres` (`id`),
  CONSTRAINT `FK_90A840A6EE81BED4` FOREIGN KEY (`chorales_id`) REFERENCES `choralesgroupes` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `choralesgroupesmembres`
--


--
-- Table structure for table `classestructure`
--

CREATE TABLE `classestructure` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `departement_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `device` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_7B0FBA243DA5256D` (`image_id`),
  KEY `IDX_7B0FBA24CCF9E01E` (`departement_id`),
  CONSTRAINT `FK_7B0FBA243DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_7B0FBA24CCF9E01E` FOREIGN KEY (`departement_id`) REFERENCES `departements` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classestructure`
--


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

CREATE TABLE `classification__category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `position` int(11) 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,
  CONSTRAINT `FK_43629B36E25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`),
  CONSTRAINT `FK_43629B36EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__category`
--

INSERT INTO `classification__category` VALUES (1,NULL,'default',NULL,'default',1,'default','default',NULL,'2018-08-14 18:44:26','2018-08-14 18:44:26'),(2,NULL,'galerie',NULL,'galerie',1,'galerie','galerie',NULL,'2018-09-20 18:24:53','2018-09-20 18:24:53');

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

CREATE TABLE `classification__collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_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_A406B56A12469DE2` (`category_id`),
  KEY `IDX_A406B56AE25D857E` (`context`),
  KEY `IDX_A406B56AEA9FDD75` (`media_id`),
  CONSTRAINT `FK_A406B56A12469DE2` FOREIGN KEY (`category_id`) REFERENCES `classification__category` (`id`),
  CONSTRAINT `FK_A406B56AE25D857E` FOREIGN KEY (`context`) REFERENCES `classification__context` (`id`),
  CONSTRAINT `FK_A406B56AEA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__collection`
--


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

CREATE TABLE `classification__context` (
  `id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_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=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__context`
--

INSERT INTO `classification__context` VALUES ('default','default',1,'2018-08-14 18:44:26','2018-08-14 18:44:26'),('galerie','galerie',1,'2018-09-20 18:24:53','2018-09-20 18:24:53');

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

CREATE TABLE `classification__tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `context` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `classification__tag`
--


--
-- Table structure for table `cradorations`
--

CREATE TABLE `cradorations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_37EC979D3DA5256D` (`image_id`),
  CONSTRAINT `FK_37EC979D3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cradorations`
--


--
-- Table structure for table `cradorationsmembres`
--

CREATE TABLE `cradorationsmembres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membres_id` int(11) NOT NULL,
  `coeurs_id` int(11) NOT NULL,
  `voix` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_57EE385D71128C5C` (`membres_id`),
  KEY `IDX_57EE385D6BD54417` (`coeurs_id`),
  CONSTRAINT `FK_57EE385D6BD54417` FOREIGN KEY (`coeurs_id`) REFERENCES `cradorations` (`id`),
  CONSTRAINT `FK_57EE385D71128C5C` FOREIGN KEY (`membres_id`) REFERENCES `membres` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cradorationsmembres`
--


--
-- Table structure for table `departements`
--

CREATE TABLE `departements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `vision` longtext COLLATE utf8_unicode_ci NOT NULL,
  `concerner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_CF7489B23DA5256D` (`image_id`),
  CONSTRAINT `FK_CF7489B23DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `departements`
--


--
-- Table structure for table `departementsmembres`
--

CREATE TABLE `departementsmembres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membres_id` int(11) NOT NULL,
  `departement_id` int(11) NOT NULL,
  `affectation_id` int(11) DEFAULT NULL,
  `fonction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateIntegration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F563405A71128C5C` (`membres_id`),
  KEY `IDX_F563405ACCF9E01E` (`departement_id`),
  KEY `IDX_F563405A6D0ABA22` (`affectation_id`),
  CONSTRAINT `FK_F563405A6D0ABA22` FOREIGN KEY (`affectation_id`) REFERENCES `classestructure` (`id`),
  CONSTRAINT `FK_F563405A71128C5C` FOREIGN KEY (`membres_id`) REFERENCES `membres` (`id`),
  CONSTRAINT `FK_F563405ACCF9E01E` FOREIGN KEY (`departement_id`) REFERENCES `departements` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `departementsmembres`
--


--
-- Table structure for table `donation`
--

CREATE TABLE `donation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `concerne` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `montant` double NOT NULL,
  `pays` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `donation`
--


--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreation` datetime NOT NULL,
  `dateEvent` datetime NOT NULL,
  `concerner` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `duree` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `miniImage_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5387574A3DA5256D` (`image_id`),
  UNIQUE KEY `UNIQ_5387574A78AE985A` (`miniImage_id`),
  KEY `IDX_5387574AA76ED395` (`user_id`),
  CONSTRAINT `FK_5387574A3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_5387574A78AE985A` FOREIGN KEY (`miniImage_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_5387574AA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `events`
--


--
-- Table structure for table `fos_user_group`
--

CREATE TABLE `fos_user_group` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_583D1F3E5E237E06` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fos_user_group`
--


--
-- Table structure for table `fos_user_user_group`
--

CREATE TABLE `fos_user_user_group` (
  `user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`group_id`),
  KEY `IDX_B3C77447A76ED395` (`user_id`),
  KEY `IDX_B3C77447FE54D947` (`group_id`),
  CONSTRAINT `FK_B3C77447A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B3C77447FE54D947` FOREIGN KEY (`group_id`) REFERENCES `fos_user_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fos_user_user_group`
--


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

CREATE TABLE `media__gallery` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `context` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `default_format` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_3C02B7F53DA5256D` (`image_id`),
  CONSTRAINT `FK_3C02B7F53DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__gallery`
--

INSERT INTO `media__gallery` VALUES (1,NULL,'partnerGallery','default','default_galeriepartner',1,'2018-09-20 19:15:30','2018-09-20 18:55:35',NULL);

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

CREATE TABLE `media__gallery_media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gallery_id` int(11) DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `position` int(11) 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`),
  CONSTRAINT `FK_80D4C541EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__gallery_media`
--

INSERT INTO `media__gallery_media` VALUES (1,1,16,1,0,'2018-09-20 19:15:30','2018-09-20 18:55:35'),(2,1,17,2,0,'2018-09-20 19:15:30','2018-09-20 19:15:30'),(3,1,19,3,0,'2018-09-20 19:15:30','2018-09-20 19:15:30'),(4,1,20,4,0,'2018-09-20 19:15:30','2018-09-20 19:15:30'),(5,1,21,5,0,'2018-09-20 19:15:30','2018-09-20 19:15:30'),(6,1,22,6,0,'2018-09-20 19:15:30','2018-09-20 19:15:30'),(7,1,23,7,0,'2018-09-20 19:15:30','2018-09-20 19:15:30');

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

CREATE TABLE `media__media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imageparallele_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `enabled` tinyint(1) NOT NULL,
  `provider_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_status` int(11) NOT NULL,
  `provider_reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_metadata` longtext COLLATE utf8_unicode_ci COMMENT '(DC2Type:json)',
  `width` int(11) DEFAULT NULL,
  `height` int(11) DEFAULT NULL,
  `length` decimal(10,0) DEFAULT NULL,
  `content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content_size` int(11) DEFAULT NULL,
  `copyright` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `context` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cdn_is_flushable` tinyint(1) DEFAULT NULL,
  `cdn_flush_identifier` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cdn_flush_at` datetime DEFAULT NULL,
  `cdn_status` int(11) DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `textA` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `textA1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `textB` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `textC` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `boutonTitre` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `boutonUrl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5C6DD74EBC5BBB82` (`imageparallele_id`),
  KEY `IDX_5C6DD74E12469DE2` (`category_id`),
  CONSTRAINT `FK_5C6DD74E12469DE2` FOREIGN KEY (`category_id`) REFERENCES `classification__category` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_5C6DD74EBC5BBB82` FOREIGN KEY (`imageparallele_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `media__media`
--

INSERT INTO `media__media` VALUES (5,NULL,2,'logo.JPG',NULL,0,'sonata.media.provider.image',1,'a2c7f8dbe7de7cfb56b2a549a72ef91436956985.jpeg','{\"filename\":\"logo.JPG\"}',1024,965,NULL,'image/jpeg',106687,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:29:57','2018-09-20 18:29:57',NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,2,'partner1.png',NULL,0,'sonata.media.provider.image',1,'893ba458c0c661760b898ec231e4270fa24ca7e4.png','{\"filename\":\"partner1.png\"}',160,60,NULL,'image/png',4212,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:34:16','2018-09-20 18:34:16',NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,2,'partner2.png',NULL,0,'sonata.media.provider.image',1,'9f6cbf15bcebc6b699594a941ccd81b3cd180d31.png','{\"filename\":\"partner2.png\"}',160,60,NULL,'image/png',5322,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:34:49','2018-09-20 18:34:49',NULL,NULL,NULL,NULL,NULL,NULL),(8,NULL,2,'partner3.png',NULL,0,'sonata.media.provider.image',1,'ee3114ed7d0ef4649072ee77f504aea41b75679a.png','{\"filename\":\"partner3.png\"}',160,60,NULL,'image/png',9172,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:35:15','2018-09-20 18:35:15',NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,2,'partner4.png',NULL,0,'sonata.media.provider.image',1,'f9b502729fd21c0a847421c90d1fb75d41c89d3c.png','{\"filename\":\"partner4.png\"}',160,60,NULL,'image/png',7266,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:35:45','2018-09-20 18:35:45',NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,2,'partner5.png',NULL,0,'sonata.media.provider.image',1,'050b5d0c311f51d3a2013892d8795563206ed241.png','{\"filename\":\"partner5.png\"}',160,60,NULL,'image/png',3709,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:36:17','2018-09-20 18:36:17',NULL,NULL,NULL,NULL,NULL,NULL),(11,NULL,2,'partner1.png',NULL,0,'sonata.media.provider.image',1,'3240b0b395aa1026350a3a30ccd3f208881c419a.png','{\"filename\":\"partner1.png\"}',160,60,NULL,'image/png',4212,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:36:46','2018-09-20 18:36:46',NULL,NULL,NULL,NULL,NULL,NULL),(12,NULL,2,'partner2.png',NULL,0,'sonata.media.provider.image',1,'77b082758c55323c28720bc22e398b2657f0d9ee.png','{\"filename\":\"partner2.png\"}',160,60,NULL,'image/png',5322,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:37:23','2018-09-20 18:37:23',NULL,NULL,NULL,NULL,NULL,NULL),(13,NULL,2,'partner3.png',NULL,0,'sonata.media.provider.image',1,'d2df43e476bc11afe827c67b2a9b15a611d3d7cf.png','{\"filename\":\"partner3.png\"}',160,60,NULL,'image/png',9172,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:37:44','2018-09-20 18:37:44',NULL,NULL,NULL,NULL,NULL,NULL),(14,NULL,2,'partner4.png',NULL,0,'sonata.media.provider.image',1,'4f41f8d858e52cde23a0f0fd93730e1100f630c8.png','{\"filename\":\"partner4.png\"}',160,60,NULL,'image/png',7266,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:39:21','2018-09-20 18:39:21',NULL,NULL,NULL,NULL,NULL,NULL),(15,NULL,2,'partner5.png',NULL,0,'sonata.media.provider.image',1,'18246adf18b51deda330769e2af3737e18e769e5.png','{\"filename\":\"partner5.png\"}',160,60,NULL,'image/png',3709,NULL,NULL,'galerie',NULL,NULL,NULL,NULL,'2018-09-20 18:39:50','2018-09-20 18:39:50',NULL,NULL,NULL,NULL,NULL,NULL),(16,NULL,1,'partner1.png',NULL,0,'sonata.media.provider.image',1,'1261cc6819a9cf2f5800f7e89bf8d41ec8088c73.png','{\"filename\":\"partner1.png\"}',160,60,NULL,'image/png',4212,NULL,NULL,'default',0,NULL,NULL,NULL,'2018-09-20 18:43:23','2018-09-20 18:43:01',NULL,NULL,NULL,NULL,NULL,NULL),(17,NULL,1,'partner2.png',NULL,0,'sonata.media.provider.image',1,'84fdd3c1de77d192a0f1080e407f2f52e9ce32e7.png','{\"filename\":\"partner2.png\"}',160,60,NULL,'image/png',5322,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 18:43:54','2018-09-20 18:43:54',NULL,NULL,NULL,NULL,NULL,NULL),(18,NULL,1,'partner2.png',NULL,0,'sonata.media.provider.image',1,'31a62e2672a1eb69bc30ee448e8a08238aaa4e6b.png','{\"filename\":\"partner2.png\"}',160,60,NULL,'image/png',5322,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 18:43:58','2018-09-20 18:43:58',NULL,NULL,NULL,NULL,NULL,NULL),(19,NULL,1,'partner3.png',NULL,0,'sonata.media.provider.image',1,'9a39588007ccf32e0bde8f93b40d0d6912346748.png','{\"filename\":\"partner3.png\"}',160,60,NULL,'image/png',9172,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 18:44:22','2018-09-20 18:44:22',NULL,NULL,NULL,NULL,NULL,NULL),(20,NULL,1,'partner4.png',NULL,0,'sonata.media.provider.image',1,'da870edae27b3219a56d43397964e0527898f09d.png','{\"filename\":\"partner4.png\"}',160,60,NULL,'image/png',7266,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 18:44:47','2018-09-20 18:44:47',NULL,NULL,NULL,NULL,NULL,NULL),(21,NULL,1,'partner5.png',NULL,0,'sonata.media.provider.image',1,'7279047f4362041b935f3899fa5cc4dd0cba0b93.png','{\"filename\":\"partner5.png\"}',160,60,NULL,'image/png',3709,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 18:45:06','2018-09-20 18:45:06',NULL,NULL,NULL,NULL,NULL,NULL),(22,NULL,1,'partner1.png',NULL,0,'sonata.media.provider.image',1,'cb4a0ebde3b5c448b7aec578f7f73fe64d1b92ce.png','{\"filename\":\"partner1.png\"}',160,60,NULL,'image/png',4212,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 19:14:45','2018-09-20 19:14:45',NULL,NULL,NULL,NULL,NULL,NULL),(23,NULL,1,'partner3.png',NULL,0,'sonata.media.provider.image',1,'d32f61011ba63e4fe7bee16b7ba269781c6f123f.png','{\"filename\":\"partner3.png\"}',160,60,NULL,'image/png',9172,NULL,NULL,'default',NULL,NULL,NULL,NULL,'2018-09-20 19:15:22','2018-09-20 19:15:22',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `meditation`
--

CREATE TABLE `meditation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hitcounter` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `published_at` date NOT NULL,
  `is_status` tinyint(1) NOT NULL,
  `homeImage_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_443D69533DA5256D` (`image_id`),
  UNIQUE KEY `UNIQ_443D69535BB6D1E` (`homeImage_id`),
  KEY `IDX_443D6953A76ED395` (`user_id`),
  CONSTRAINT `FK_443D69533DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_443D69535BB6D1E` FOREIGN KEY (`homeImage_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_443D6953A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `meditation`
--


--
-- Table structure for table `membres`
--

CREATE TABLE `membres` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `nom` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `prenom` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sexe` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `age` date NOT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephone1` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephone2` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lieuDeNaissance` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nationalite` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `statut` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nomPrenomConjoint` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephoneConjoint` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nombreEnfant` int(11) DEFAULT NULL,
  `groupeSanguin` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alergies` longtext COLLATE utf8_unicode_ci,
  `maladie` longtext COLLATE utf8_unicode_ci,
  `niveauEtude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `profession` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nomprenomPersonneReference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telephonePersonneReference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateConversion` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dateAffiliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codeMembre` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `nif` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `dejaBaptise` tinyint(1) NOT NULL,
  `EgliseMission` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lattitudeGPS` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitudeGPS` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_594AE39C3DA5256D` (`image_id`),
  CONSTRAINT `FK_594AE39C3DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `membres`
--


--
-- Table structure for table `menagers`
--

CREATE TABLE `menagers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membre_id` int(11) DEFAULT NULL,
  `secteur` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `horaire` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5D06C4156A99F74A` (`membre_id`),
  CONSTRAINT `FK_5D06C4156A99F74A` FOREIGN KEY (`membre_id`) REFERENCES `membres` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `menagers`
--


--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `telephone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `message`
--


--
-- Table structure for table `musicien`
--

CREATE TABLE `musicien` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membre_id` int(11) DEFAULT NULL,
  `instrument` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_551D84236A99F74A` (`membre_id`),
  CONSTRAINT `FK_551D84236A99F74A` FOREIGN KEY (`membre_id`) REFERENCES `membres` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `musicien`
--


--
-- Table structure for table `news__comment`
--

CREATE TABLE `news__comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8_unicode_ci NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A90210404B89032C` (`post_id`),
  CONSTRAINT `FK_A90210404B89032C` FOREIGN KEY (`post_id`) REFERENCES `news__post` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news__comment`
--


--
-- Table structure for table `news__post`
--

CREATE TABLE `news__post` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `author_id` int(11) DEFAULT NULL,
  `collection_id` int(11) DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `abstract` longtext COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `raw_content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `content_formatter` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `publication_date_start` datetime DEFAULT NULL,
  `comments_enabled` tinyint(1) NOT NULL,
  `comments_close_at` datetime DEFAULT NULL,
  `comments_default_status` int(11) NOT NULL,
  `comments_count` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `hitcounter` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7D109BC812469DE2` (`category_id`),
  KEY `IDX_7D109BC83DA5256D` (`image_id`),
  KEY `IDX_7D109BC8F675F31B` (`author_id`),
  KEY `IDX_7D109BC8514956FD` (`collection_id`),
  CONSTRAINT `FK_7D109BC812469DE2` FOREIGN KEY (`category_id`) REFERENCES `classification__category` (`id`),
  CONSTRAINT `FK_7D109BC83DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_7D109BC8514956FD` FOREIGN KEY (`collection_id`) REFERENCES `classification__collection` (`id`),
  CONSTRAINT `FK_7D109BC8F675F31B` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news__post`
--


--
-- Table structure for table `news__post_tag`
--

CREATE TABLE `news__post_tag` (
  `post_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`post_id`,`tag_id`),
  KEY `IDX_682B20514B89032C` (`post_id`),
  KEY `IDX_682B2051BAD26311` (`tag_id`),
  CONSTRAINT `FK_682B20514B89032C` FOREIGN KEY (`post_id`) REFERENCES `news__post` (`id`),
  CONSTRAINT `FK_682B2051BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `classification__tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `news__post_tag`
--


--
-- Table structure for table `notification__message`
--

CREATE TABLE `notification__message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `body` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:json)',
  `state` int(11) NOT NULL,
  `restart_count` int(11) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `started_at` datetime DEFAULT NULL,
  `completed_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_message_state_idx` (`state`),
  KEY `notification_message_created_at_idx` (`created_at`),
  KEY `idx_state` (`state`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notification__message`
--


--
-- Table structure for table `ouvriers`
--

CREATE TABLE `ouvriers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `membre_id` int(11) DEFAULT NULL,
  `fonction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateDeMinistere` date NOT NULL,
  `mission` longtext COLLATE utf8_unicode_ci NOT NULL,
  `poste` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `niveau` int(11) NOT NULL,
  `biographie` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_50E745313DA5256D` (`image_id`),
  UNIQUE KEY `UNIQ_50E745316A99F74A` (`membre_id`),
  CONSTRAINT `FK_50E745313DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`),
  CONSTRAINT `FK_50E745316A99F74A` FOREIGN KEY (`membre_id`) REFERENCES `membres` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ouvriers`
--


--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8_unicode_ci NOT NULL,
  `relatedPage` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `Image_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_2074E5756C6E55B5` (`nom`),
  UNIQUE KEY `UNIQ_2074E575C4D3473B` (`Image_id`),
  CONSTRAINT `FK_2074E575C4D3473B` FOREIGN KEY (`Image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `pages`
--


--
-- Table structure for table `priererequete`
--

CREATE TABLE `priererequete` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `statut` tinyint(1) NOT NULL,
  `requete` longtext COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `priererequete`
--


--
-- Table structure for table `rapport`
--

CREATE TABLE `rapport` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cellule_id` int(11) DEFAULT NULL,
  `titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL,
  `datecreation` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BE34A09C96299DA6` (`cellule_id`),
  CONSTRAINT `FK_BE34A09C96299DA6` FOREIGN KEY (`cellule_id`) REFERENCES `cellule` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `rapport`
--


--
-- Table structure for table `ressouces`
--

CREATE TABLE `ressouces` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `messager_id` int(11) DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `hitcounter` int(11) NOT NULL,
  `titre` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `section` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `contenu` longtext COLLATE utf8_unicode_ci NOT NULL,
  `resume` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `statut` tinyint(1) NOT NULL,
  `dateDeCreation` datetime NOT NULL,
  `dateDePredication` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_2CF59ED4EA9FDD75` (`media_id`),
  KEY `IDX_2CF59ED41D2C383F` (`messager_id`),
  CONSTRAINT `FK_2CF59ED41D2C383F` FOREIGN KEY (`messager_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_2CF59ED4EA9FDD75` FOREIGN KEY (`media_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ressouces`
--


--
-- Table structure for table `ressources_tags`
--

CREATE TABLE `ressources_tags` (
  `tags_id` int(11) NOT NULL,
  `ressources_id` int(11) NOT NULL,
  PRIMARY KEY (`tags_id`,`ressources_id`),
  KEY `IDX_D663A5F48D7B4FB4` (`tags_id`),
  KEY `IDX_D663A5F43C361826` (`ressources_id`),
  CONSTRAINT `FK_D663A5F43C361826` FOREIGN KEY (`ressources_id`) REFERENCES `ressouces` (`id`),
  CONSTRAINT `FK_D663A5F48D7B4FB4` FOREIGN KEY (`tags_id`) REFERENCES `classification__tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ressources_tags`
--


--
-- Table structure for table `scootbrigade`
--

CREATE TABLE `scootbrigade` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image_id` int(11) NOT NULL,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `vision` longtext COLLATE utf8_unicode_ci NOT NULL,
  `slogans` longtext COLLATE utf8_unicode_ci NOT NULL,
  `dateCreation` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_77575A533DA5256D` (`image_id`),
  CONSTRAINT `FK_77575A533DA5256D` FOREIGN KEY (`image_id`) REFERENCES `media__media` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scootbrigade`
--


--
-- Table structure for table `scootbrigademembre`
--

CREATE TABLE `scootbrigademembre` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membres_id` int(11) NOT NULL,
  `departement_id` int(11) NOT NULL,
  `fonction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ploton` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9691FD471128C5C` (`membres_id`),
  KEY `IDX_9691FD4CCF9E01E` (`departement_id`),
  CONSTRAINT `FK_9691FD471128C5C` FOREIGN KEY (`membres_id`) REFERENCES `membres` (`id`),
  CONSTRAINT `FK_9691FD4CCF9E01E` FOREIGN KEY (`departement_id`) REFERENCES `scootbrigade` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `scootbrigademembre`
--


--
-- Table structure for table `tchalam_tchala`
--

CREATE TABLE `tchalam_tchala` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `numbers` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datecreated` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `datemodified` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `label_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `label_ht` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `tchalam_tchala`
--


--
-- Table structure for table `temoignages`
--

CREATE TABLE `temoignages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contenu` longtext COLLATE utf8_unicode_ci NOT NULL,
  `temoin` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `categorie` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `temoignages`
--


--
-- Table structure for table `total_view`
--

CREATE TABLE `total_view` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `counter` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `total_view`
--


--
-- Table structure for table `verset`
--

CREATE TABLE `verset` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `verset` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dateCreation` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `verset`
--


--
-- Table structure for table `visiteurs`
--

CREATE TABLE `visiteurs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `latitude` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `longitude` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  `visiteAt` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `visiteurs`
--



