-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3307
-- Généré le : jeu. 16 déc. 2021 à 20:31
-- Version du serveur :  10.4.13-MariaDB
-- Version de PHP : 7.4.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Base de données : `bd-nationale-prod`
--

-- --------------------------------------------------------

--
-- Structure de la table `dahira`
--

DROP TABLE IF EXISTS `dahira`;
CREATE TABLE IF NOT EXISTS `dahira` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `federation_id` int(11) DEFAULT NULL,
  `dieuwrine_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_postal` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_creation` date DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_18DDD7EBB781A52D` (`dieuwrine_id`),
  KEY `IDX_18DDD7EB6A03EFC5` (`federation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `dahira`
--

INSERT INTO `dahira` (`id`, `federation_id`, `dieuwrine_id`, `nom`, `code_postal`, `date_creation`, `is_deleted`) VALUES
(1, 1, NULL, 'Touba Valenciennes', '59300', '2006-06-07', 0),
(2, 1, NULL, 'Touba Rouen', '76000', '2016-01-07', 0),
(3, 3, NULL, 'Touba Besançon', '25000', NULL, 0),
(4, 5, NULL, 'Touba Clermont', '60600', NULL, 0),
(5, 5, NULL, 'Touba Limoges', '87000', NULL, 0),
(6, 5, NULL, 'Touba Roanne', '42300', NULL, 0),
(7, 5, NULL, 'Touba Saint Etienne', '42000', NULL, 0),
(8, 5, NULL, 'Touba Orléans', '45000', NULL, 0),
(9, 5, NULL, 'Touba Tours', '37000', NULL, 0),
(10, 5, NULL, 'Touba Poitiers', '86000', NULL, 0),
(11, 3, NULL, 'Touba Dijon', '21000', NULL, 0),
(13, 3, NULL, 'Touba Mulhouse', '68100', NULL, 0),
(14, 3, NULL, 'Touba Strasbourg', '67000', NULL, 0),
(15, 3, NULL, 'Touba Nancy', '54000', NULL, 0),
(16, 3, NULL, 'Touba Metz', '57000', NULL, 0),
(18, 3, NULL, 'Touba Luxembourg', '1111', NULL, 0),
(19, 3, NULL, 'Touba Reims', '51100', NULL, 0),
(20, 1, NULL, 'Touba Lille', '59000', NULL, 0),
(21, 1, NULL, 'Touba Le Havre', '76310', NULL, 0),
(22, 1, NULL, 'Touba Caen', '14000', NULL, 0),
(23, 1, NULL, 'Touba Amiens', '80000', NULL, 0),
(24, 1, NULL, 'Touba Béthune', '62400', NULL, 0),
(25, 1, NULL, 'Touba Saint-Quentin', '2100', NULL, 0),
(26, 4, NULL, 'Touba Nantes', '44000', NULL, 0),
(27, 4, NULL, 'Touba Brest', '29200', NULL, 0),
(28, 4, NULL, 'Touba Lannion', '22300', NULL, 0),
(29, 4, NULL, 'Touba Lorient', '56100', NULL, 0),
(30, 4, NULL, 'Touba Rennes', '35000', NULL, 0),
(31, 4, NULL, 'Touba Saint nazaire', '44600', NULL, 0),
(32, 4, NULL, 'Touba Angers', '49000', NULL, 0),
(33, 4, NULL, 'Touba Le Mans', '72000', NULL, 0),
(34, 2, NULL, 'Touba Marseille', '13000', NULL, 0),
(35, 2, NULL, 'Touba Toulouse', '31000', NULL, 0),
(36, 2, NULL, 'Touba Cannes', '6400', NULL, 0),
(37, 2, NULL, 'Touba Avignon', '84000', NULL, 0),
(38, 2, NULL, 'Touba Toulon', '83000', NULL, 0),
(39, 2, NULL, 'Touba Chambery', '73000', NULL, 0),
(40, 2, NULL, 'Touba Beziers', '34500', NULL, 0),
(41, 2, NULL, 'Touba Nimes', '30000', NULL, 0),
(42, 2, NULL, 'Touba Narbonne', '11100', NULL, 0),
(43, 2, NULL, 'Touba Perpignan', '66000', NULL, 0),
(44, 2, NULL, 'Touba Valence', '26000', NULL, 0),
(45, 2, NULL, 'Touba Grenoble', '38000', NULL, 0),
(46, 2, NULL, 'Touba Bayonne', '64100', NULL, 0),
(47, 2, NULL, 'Touba Bordeaux', '33000', NULL, 0),
(48, 2, NULL, 'Touba Pau', '64000', NULL, 0),
(49, 1, NULL, 'Touba Evreux', '27000', NULL, 0),
(50, 2, NULL, 'Touba Nice', '6000', NULL, 0),
(51, 5, NULL, 'Touba Lyon', '69000', NULL, 0),
(52, 6, NULL, 'Touba Aulnay', '93600', NULL, 0),
(53, 6, NULL, 'Touba Taverny', '95150', NULL, 0),
(54, 6, NULL, 'Touba Diawartoulah', '99999', NULL, 0),
(55, 6, NULL, 'Touba Hizboulahi', '99999', NULL, 0),
(56, 6, NULL, 'Touba Marahib', '99999', NULL, 0),
(57, 3, NULL, 'Touba Belfort', '90000', NULL, 0);

-- --------------------------------------------------------

--
-- Structure de la table `diplome`
--

DROP TABLE IF EXISTS `diplome`;
CREATE TABLE IF NOT EXISTS `diplome` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `diplome`
--

INSERT INTO `diplome` (`id`, `nom`) VALUES
(1, 'CAP'),
(3, 'BAC Pro'),
(4, 'BAC'),
(5, 'Bac + 1'),
(6, 'Bac + 2 : DUT, BTS, DEUG, etc'),
(7, 'Bac + 3 : Licence, Licence Pro, etc'),
(8, 'Bac + 4 : Mastrise, Master 1, etc'),
(10, 'Bac + 5 : Master, Ingénieur'),
(11, 'Bac + 6 : Mastère, MBA, etc'),
(12, 'Bac + 8: Doctorat, Diplome Medecine'),
(13, 'Bac + 8 >'),
(14, 'Autres');

-- --------------------------------------------------------

--
-- Structure de la table `domaine`
--

DROP TABLE IF EXISTS `domaine`;
CREATE TABLE IF NOT EXISTS `domaine` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `domaine`
--

INSERT INTO `domaine` (`id`, `nom`) VALUES
(1, 'Agriculture, Élevage, Aquaculture\r\n'),
(2, 'Génie Civil, Travaux Publique, Architechture, Batiment\r\n'),
(3, 'Génie Industriel, Mécanique, Fluide\r\n'),
(4, 'Industries de process'),
(5, 'Matériaux souples, bois, industries graphiques'),
(6, 'Maintenance'),
(7, 'Ingénieurs, cadres de l’industrie'),
(8, 'Transport, Logistique, Qualité\r\n'),
(9, 'Artisanat'),
(10, 'Gestion, administration des entreprises'),
(11, 'Informatique, Data Sciences, Big Data Etc..\r\n'),
(12, 'Enseignant, Chercheur, Formateur\r\n'),
(13, 'Droit, Juriste, Politique, Fiscalité\r\n'),
(14, 'Banque, Finance, Assurance, Comptabilité\r\n'),
(15, 'Commerce, Marketing, Communication\r\n\r\n'),
(16, 'Hôtellerie - Restauration - Tourisme\r\n'),
(17, 'Services aux particuliers et aux collectivités'),
(18, 'Industries Graphiques , Communication, Audiovisuel, Multimedia, Journalisme\r\n'),
(19, 'Médecine, Pharmacie, Santé Et Métier Médical Et Paramedical\r\n'),
(21, 'Action sociale, culturelle et sportive'),
(22, 'Sciences Sociales, Histoire, Géographie\r\n'),
(23, 'Biologie, Science De La Vie Et De La Terre'),
(24, 'Télécom, Réseau, Electronique, Electricité, Robotique, Electrotechnique'),
(25, 'Sciences, Mathématique, Physique');

-- --------------------------------------------------------

--
-- Structure de la table `federation`
--

DROP TABLE IF EXISTS `federation`;
CREATE TABLE IF NOT EXISTS `federation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `federation`
--

INSERT INTO `federation` (`id`, `nom`) VALUES
(1, 'Fédération Nord'),
(2, 'Fédération Sud'),
(3, 'Fédération Est'),
(4, 'Fédération Ouest'),
(5, 'Fédération Centre'),
(6, 'Fédération Ile de France');

-- --------------------------------------------------------

--
-- Structure de la table `personne`
--

DROP TABLE IF EXISTS `personne`;
CREATE TABLE IF NOT EXISTS `personne` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dahira_id` int(11) NOT NULL,
  `statut_id` int(11) NOT NULL,
  `diplome_id` int(11) DEFAULT NULL,
  `domaine_id` int(11) DEFAULT NULL,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(13) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profession` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `entreprise` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FCEC9EFF5ED07D8` (`dahira_id`),
  KEY `IDX_FCEC9EFF6203804` (`statut_id`),
  KEY `IDX_FCEC9EF26F859E2` (`diplome_id`),
  KEY `IDX_FCEC9EF4272FC9F` (`domaine_id`)
) ENGINE=InnoDB AUTO_INCREMENT=459 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `personne`
--

INSERT INTO `personne` (`id`, `dahira_id`, `statut_id`, `diplome_id`, `domaine_id`, `nom`, `prenom`, `adresse`, `email`, `telephone`, `profession`, `entreprise`, `password`, `is_deleted`) VALUES
(1, 10, 2, 7, 23, 'Sarr', 'Baye Moustapha ', '13 rue des Carmes 86000 POITIERS ', 'taphi10@gmail.com', '+33644905892', NULL, NULL, NULL, 0),
(2, 8, 6, 14, 16, 'Kasse', 'Sokhna Aminata Mbacke ', '7 avenue du parc de l etuvee', 'amikasse94@gmail.com', '+33633406900', NULL, NULL, NULL, 0),
(3, 8, 6, 3, 8, 'Boye diop', 'Ismaila', '7 av du parc de l etuvee', 'iboye2008@hotmail.com', '+33749042544', NULL, NULL, NULL, 0),
(4, 8, 2, 6, 3, 'Seye', 'Ousmane', '19 rue Henri Troyat', 'seyeousmane37@gmail.com', '+33753490410', NULL, NULL, NULL, 0),
(5, 8, 1, 10, 1, 'AIDARA', 'Mariama', '25 rue des Gargonnes 45500 Poully-Lez-Gien', 'mariamaaidara@gmail.com', '+33754536675', NULL, NULL, NULL, 0),
(6, 8, 2, 6, 3, 'Seye', 'Ousmane', '19 rue Henri Troyat', 'seyeousmane37@gmail.com', '+33753490410', NULL, NULL, NULL, 0),
(7, 8, 6, 10, 8, 'SECK', 'Ndiaga', '2, place Konrad Adenauer', 'seck.ndiaga@yahoo.fr', '+33661402899', NULL, NULL, NULL, 0),
(8, 5, 6, 1, 8, 'Koyate ', 'AMADOU MAKHTAR', '8 square du luxembourg 87220 Feytiat', 'jeankoyate@gmail.com', '+33699937918', NULL, NULL, NULL, 0),
(9, 51, 1, 10, 16, 'Balla', 'Gueye', '6 rue Roger Salengro', 'englishloverkoki@hotmail.com', '+33643558969', NULL, NULL, NULL, 0),
(10, 51, 6, 8, 15, 'Sarr Diouf ', 'Khadi ', '33B Route de genas', 'skhadi87@yahoo.fr', '+33685840598', NULL, NULL, NULL, 0),
(11, 9, 1, 10, 11, 'SALL', 'Pape Moussa', '5 allée de la chassepiniere ', 'pamsall@yahoo.fr', '+33624735211', NULL, NULL, NULL, 0),
(12, 9, 2, 8, 25, 'DIOUF', 'Serigne Fallou', 'Parc grandmont Rue F.Bonamy', 'diouf.fallou470@gmail.com', '+33753754821', NULL, NULL, NULL, 0),
(13, 9, 6, 14, 14, 'Zimmer', 'Georges Ahmadou ', '4 Rue Santos Dumont', 'georges.zimmer42@yahoo.com', '+33618918203', NULL, NULL, NULL, 0),
(14, 51, 1, 10, 11, 'DIOUF', 'Mamadou', '33 route de Genas BAT B 69120 Vaulx-en-Velin ', 'mdiouf.mamadou@gmail.com', '+33624130602', NULL, NULL, NULL, 0),
(15, 10, 6, 6, 24, 'DIOP', 'Abdou', '21 Rue Jean Richard Bloch ', 'diop20031999@gmail.com', '+33783148010', NULL, NULL, NULL, 0),
(16, 10, 2, 7, 25, 'Faye', 'Mbaye', '19 rue Jean Richard Bloch ', 'mbayef789@gmail.com', '+33753136568', NULL, NULL, NULL, 0),
(17, 10, 6, 14, 24, 'FALL', 'Thierno Ibrahima ', '11 rue Raoul Follereau cité Descartes ', 'fallthiernoibrahima@gmail.com', '+33755798208', NULL, NULL, NULL, 0),
(18, 10, 6, 7, 22, 'Kasse ', 'Ahmadou bamba ', 'Résidence Marie curie bat c ch 210', 'cheikhounacasset95@gmail.com', '+33749974740', NULL, NULL, NULL, 0),
(19, 7, 2, 5, 23, 'Diop ', 'Ibrahima ', '10 rue Lakanal 49000 Angers ', 'ibrahimadiop1204@gmail.com', '+33605906703', NULL, NULL, NULL, 0),
(20, 10, 2, 10, 11, 'NDIAYE ', 'Moustapha', '21 rue jean Richard bloch', 'tapha1824@gmail.com', '+33763477308', NULL, NULL, NULL, 0),
(21, 10, 6, 14, 24, 'FALL', 'Thierno Ibrahima ', '11 rue Raoul Follereau cité Descartes ', 'fallthiernoibrahima@gmail.com', '+33755798208', NULL, NULL, NULL, 0),
(22, 8, 6, 8, 22, 'Fall ', 'Modou ', '6 rue Gaspard Coriolis ', 'serignemodoufall55@gmail.com', '+33605866692', NULL, NULL, NULL, 0),
(23, 51, 1, 10, 11, 'DIOUF', 'Assane', '81 Rue Léon Blum 69100 Villeurbanne ', 'assanehome@yahoo.fr', '+33610144296', NULL, NULL, NULL, 0),
(24, 51, 1, 10, 11, 'DIOUF', 'Assane', '81 Rue Léon Blum 69100 Villeurbanne ', 'assanehome@yahoo.fr', '+33610144296', NULL, NULL, NULL, 0),
(25, 51, 1, 10, 23, 'Faye', 'Oumar ', '11 impasse richard 69100 Villeurbanne ', 'oumarsg8@gmail.com', '+33652752645', NULL, NULL, NULL, 0),
(26, 51, 6, 10, 24, 'Ndiaye', 'Abdou Khadre', '46 boulevard du 11 Novembre 1918, 69100 Villeurbanne ', 'djilyazur@gmail.com', '+33661584071', NULL, NULL, NULL, 0),
(27, 51, 6, 8, 14, 'DIENG', 'Ousmane', '02 rue Soeur bouvier', 'ousmanedieng230@gmail.com', '+33617938416', NULL, NULL, NULL, 0),
(28, 51, 6, 10, 5, 'Ndiaye', 'Assane', '10 rue Félix Rollet ', 'ndiayeassane980@yahoo.fr', '+33615677369', NULL, NULL, NULL, 0),
(29, 51, 3, 10, 25, 'Fall', 'Medoune', 'Lyon', 'medounefall06@gmail.com', '+33782064438', NULL, NULL, NULL, 0),
(30, 51, 6, 7, 24, 'Sene ', 'Birame ', '323bis cours Émile zola ', 'Biramesene97@gmail.com', '+33767054195', NULL, NULL, NULL, 0),
(31, 51, 2, 6, 11, 'Diagne ', 'Sada ', '5 Chemin du Grand Roule ', 'sada.diagne@epsi.fr', '+33774647443', NULL, NULL, NULL, 0),
(32, 51, 6, 10, 15, 'Diouf', 'Papa Moussa', '47 rue germain 69006', 'papmodiouf@hotmail.fr', '+33614328717', NULL, NULL, NULL, 0),
(33, 51, 6, 7, 22, 'Diagne ', 'Mama', '33 rue Louise Michel 69200 Vénissieux', 'diagnemama07@gmail.com', '+33753817510', NULL, NULL, NULL, 0),
(34, 51, 6, 11, 2, 'Gueye', 'Mame Bousso', 'Villeurbanne ', 'boumase@yahoo.fr', '+33650078755', NULL, NULL, NULL, 0),
(35, 51, 6, 8, 14, 'BA', 'Oumar ', '2 rue soeur bouvier', 'seydina54oumar@gmail.com', '+33605827618', NULL, NULL, NULL, 0),
(36, 51, 6, 7, 24, 'DIA', 'Demba', 'Evron 53600', 'diademba675@gmail.com', '+33751853166', NULL, NULL, NULL, 0),
(37, 51, 1, 7, 3, 'Fall', 'Mouhamadou Yatma Ndiawar', '22 Rue Albert Camus', 'yatmafall@gmail.com', '+33753582463', NULL, NULL, NULL, 0),
(38, 51, 2, 7, 19, 'Samb', 'Adji Ngoné ', '1 rue Maria Casarès ', 'adjingone14@gmail.com', '+33751326018', NULL, NULL, NULL, 0),
(39, 51, 6, 11, 2, 'Gueye', 'Mame Bousso', 'Villeurbanne ', 'boumase@yahoo.fr', '+33650078755', NULL, NULL, NULL, 0),
(40, 51, 6, 10, 24, 'SECK', 'Mouhamadou Melo ', '6 Rue Marcel Cerdan 69009', 'meloseck@gmail.com', '+33751871853', NULL, NULL, NULL, 0),
(41, 10, 6, 10, 24, 'NIACKO', 'Youssouph', '20 Rue le Mattre', 'youniacko@yahoo.fr', '+33766803672', NULL, NULL, NULL, 0),
(42, 51, 1, 10, 11, 'Gueye ', 'Mame fatim ', '6 rue Marcel Cerdan 69009 ', 'mamefatimgueye@yahoo.fr', '+33695701426', NULL, NULL, NULL, 0),
(43, 51, 6, 10, 24, 'Cisse', 'Mariama', '150 grande rue de saint clair 69300', 'cissemareme@gmail.com', '+33783985960', NULL, NULL, NULL, 0),
(44, 51, 6, 10, 24, 'Cisse', 'Mariama', '150 grande rue de saint clair 69300', 'cissemareme@gmail.com', '+33783985960', NULL, NULL, NULL, 0),
(47, 51, 2, 6, 3, 'Seck', 'Amy', '33 RUE DU 14 JUILLET', 'amyseck1998a@gmail.com', '+33605816254', NULL, NULL, NULL, 0),
(48, 8, 2, 6, 3, 'Seck ', 'Amy', '33 RUE DU 14 JUILLET', 'amyseck1998a@gmail.com', '+33605816254', NULL, NULL, NULL, 0),
(49, 51, 6, 10, 22, 'Gueye ', 'Sokhna Astou ', '74 avenue de la république 77340 Pontault-combault (région parisienne)', 'sokhnaastou.gueye@gmail.com', '+33753057821', NULL, NULL, NULL, 0),
(50, 51, 1, 10, 11, 'DIOUF', 'Assane', '81 Rue Léon Blum 69100 Villeurbanne ', 'assanehome@yahoo.fr', '+33610144296', NULL, NULL, NULL, 0),
(51, 51, 6, 4, 24, 'DRAMÉ', 'Mamadou Lamine', '128 cours Gambetta ', 'malamine09@gmail.com', '+33767351433', NULL, NULL, NULL, 0),
(52, 51, 1, 10, 12, 'FALL', 'ASSANE', '46 Boulevard du 11 Novembre 1918', 'fall_assane@hotmail.fr', '+33647073036', NULL, NULL, NULL, 0),
(53, 51, 6, 10, 24, 'Ndiaye', 'Abdou Khadre', '46 boulevard du 11 Novembre 1918, 69100 Villeurbanne ', 'djilyazur@gmail.com', '+33661584071', NULL, NULL, NULL, 0),
(55, 8, 6, 5, 22, 'Gaye Seck', 'Sophie', '3 rue de vendôme ', 'soohiagaye99@gmail.com', '+33751456246', NULL, NULL, NULL, 0),
(56, 51, 6, 10, 14, 'FAYE', 'Abdou Lahad', '30 Rue Professeur Florence', 'lahadfaye12@gmail.com', '+33755474612', NULL, NULL, NULL, 0),
(57, 51, 2, 7, 25, 'CISSE ', 'Alfousseyni ', '37 Rue Descartes 69100 Villeurbanne ', 'cissealfou8@gmail.com', '+33753065094', NULL, NULL, NULL, 0),
(58, 10, 6, 7, 22, 'Kasse ', 'Ahmadou bamba ', 'Résidence Marie curie bat c ch 210', 'cheikhounacasset95@gmail.com', '+33749974740', NULL, NULL, NULL, 0),
(59, 19, 1, 10, 12, 'GUENE ', 'Ngary', '2 rue des sources ', 'guenengary@gmail.com', '+33633897369', NULL, NULL, NULL, 0),
(60, 32, 6, 14, 15, 'Kane', 'Oumar ', '139 rue de la Chalouere ', 'kane.oumar@yahoo.fr', '+33678308926', NULL, NULL, NULL, 0),
(61, 31, 1, 10, 13, 'Thiongane', 'Moustapha ', '9 rue de Beaumont - Verdun ', 'thionganemoustapha@yahoo.fr', '+33652024092', NULL, NULL, NULL, 0),
(62, 31, 6, 10, 2, 'BA', 'Serigne Saliou', '60 rue Michel Ange', 'bayesale1997@gmail.com', '+33766840103', NULL, NULL, NULL, 0),
(63, 32, 2, 8, 16, 'MBAYE', 'Mor', '3 ALLEE DU HARAS', 'mbayemor176@gmail.com', '+33753334705', NULL, NULL, NULL, 0),
(64, 32, 2, 10, 25, 'Diop', 'Ahmed fadel', '1rue Léon pavot', 'ahmedfadeldiop@hotmail.com', '+33751555226', NULL, NULL, NULL, 0),
(65, 33, 6, 7, 14, 'Ba ', 'El hadji malick ', '19 rue hippolyte lecornué ', 'elhadjimalickba1@gmaim.com', '+33619774621', NULL, NULL, NULL, 0),
(66, 27, 6, 8, 14, 'NIANG ', 'Seynou ', '13 rue le moyne de la borderie 29200 ', 'seynouniang@yahoo.fr', '+33661333286', NULL, NULL, NULL, 0),
(67, 32, 6, 10, 8, 'Sylla', 'Serigne Ibrahima ', '23 Allée des Anémones ', 'serigne-ibrahima@hotmail.fr', '+33698140207', NULL, NULL, NULL, 0),
(68, 19, 6, 7, 22, 'FALL', 'Mame Diarra ', '1 RUE GISELE FREUND', 'falldiarra997@gmail.com', '+33753325069', NULL, NULL, NULL, 0),
(69, 19, 6, 5, 22, 'Seck', 'Pape Mamour ', '13 rue doyen denis leroy  35000', 'seckpapemamour5@gmail.com', '+33665122545', NULL, NULL, NULL, 0),
(70, 19, 2, 5, 11, 'Tall', 'Badara', '3 rue de Belfort ', 'tallbadara18@gmail.com', '+33751398319', NULL, NULL, NULL, 0),
(71, 19, 6, 6, 14, 'Diagne', 'Mame Diarra', '6 Avenue Jacqueline de Romilly ', 'mdiarra.diagne04@gmail.com', '+33668730422', NULL, NULL, NULL, 0),
(72, 31, 6, 10, 8, 'LO', 'Pape', '124 boulevard Émile zola', 'originalbayefall@yahoo.fr', '+33619440491', NULL, NULL, NULL, 0),
(73, 32, 6, 10, 2, 'NDIAYE ', 'Bamba ', 'Angers ', 'bambatwo@yahoo.fr', '+33673477855', NULL, NULL, NULL, 0),
(74, 27, 2, 7, 3, 'Niang ', 'Mouhamed', '5 rue bosquet', 'Mouhamedniangf@gmail.com', '+33753135172', NULL, NULL, NULL, 0),
(75, 19, 1, 10, 25, 'Sall ', 'Papa', '35 avenue de la Verrerie ', 'fadal131328@outlook.fr', '+33621852313', NULL, NULL, NULL, 0),
(76, 27, 6, 8, 24, 'Thiam', 'Adiara', 'Rue de kerzudal', 'reginaadiara@gmail.com', '+33661955582', NULL, NULL, NULL, 0),
(77, 33, 1, 7, 1, 'Fall', 'Elhadji ndiomb', '123 avenue Rhin et Danube ', 'elopa13@icloud.com', '+33752922913', NULL, NULL, NULL, 0),
(78, 19, 1, 10, 11, 'Niang ', 'Fallou', '5 allée du guadel 35510 cesson sevigné ', 'faadilou.niang@gmail.com', '+33652971686', NULL, NULL, NULL, 0),
(79, 26, 6, 7, 8, 'Fall', 'Saliou', '38 rue Antoine watteau ', 'serignesaliou44600@gmail.com', '+33781529879', NULL, NULL, NULL, 0),
(80, 19, 6, 10, 2, 'GUEYE ', 'Mouhamadou Lamine ', 'Rennes', 'mlamine.gueye@outlook.fr', '+33629344224', NULL, NULL, NULL, 0),
(81, 29, 6, 10, 24, 'Niang ', 'Mouhamadou Bamba', '23 rue Armand guillemot ', 'mbniangg@gmail.com', '+33648835434', NULL, NULL, NULL, 0),
(82, 33, 2, 8, 16, 'Fall', 'Cheikh Ibra ', '18 Avenue Auguste Bartholdi ', 'mamecheikhfall95@gmail.com', '+33768589983', NULL, NULL, NULL, 0),
(83, 27, 6, 10, 24, 'Ndiaye ', 'Alioune laba ', '04 rue du Vannetais 29200 Brest ', 'aliounelaba@gmail.com', '+33605537394', NULL, NULL, NULL, 0),
(84, 27, 2, 5, 11, 'Dieng ', 'Khadim', '3 Rue Henri de Bournazel', 'mamematy3@hotmail.com', '+33751561960', NULL, NULL, NULL, 0),
(85, 27, 6, 10, 14, 'SARR', 'Pathé ', '23, Rue Des Ruffins', 'pathesarr24@gmail.com', '+33767337667', NULL, NULL, NULL, 0),
(86, 29, 2, 5, 3, 'LO ', 'Abdou Khadre ', '41rue du Pasteur Luther King', 'Loabdoukhadre86@gmail.com', '+33755263160', NULL, NULL, NULL, 0),
(87, 27, 2, 7, 11, 'Ndiaye ', 'Cheikh ', '17 rue kergorju ', 'ndiayecheikh0396@gmail.com', '+33767579565', NULL, NULL, NULL, 0),
(88, 27, 6, 10, 24, 'Diop', 'Daouda', '7 rue saint marc ', 'maldirous93@gmail.com', '+33769348407', NULL, NULL, NULL, 0),
(89, 31, 6, 10, 8, 'LO', 'BINTA', '124 boulevard Emile Zola', 'lomebi@live.fr', '+33783597621', NULL, NULL, NULL, 0),
(90, 26, 6, 10, 11, 'Lopes ', 'Ibrahima ', '14 RUE DE prefailles', 'iboulopes@gmail.com', '+33682828774', NULL, NULL, NULL, 0),
(91, 32, 6, 1, 8, 'Ndoye', 'Ousseynou', '15 Rue Trémolières', 'Weuzby@live.fr', '+33699102925', NULL, NULL, NULL, 0),
(92, 26, 2, 7, 3, 'Fall', 'Mouhamadou fallou', '44000', 'falloufall0650@gmail.com', '+33749674294', NULL, NULL, NULL, 0),
(93, 27, 6, 8, 24, 'SARR', 'Papa Boubacar', '20 rue commandant groix', 'sarrpapaboubacar@gmail.com', '+33644993992', NULL, NULL, NULL, 0),
(94, 31, 6, 3, 8, 'Ngom', 'Serigne saliou', '57 allée Stéphane grappelli ', 'saaliou4@gmail.com', '+33761092821', NULL, NULL, NULL, 0),
(95, 31, 6, 10, 24, 'Dianor ', 'Ramatoulaye ', '60 rue Michel ange ', 'ramadianor4@gmail.com', '+33758031223', NULL, NULL, NULL, 0),
(96, 31, 1, 10, 11, 'DIOP', 'Mame Diarra', '10 rue des Hibiscus', 'diarra.mame@outlook.com', '+33769735438', NULL, NULL, NULL, 0),
(97, 31, 6, 10, 8, 'DIOP', 'Mohameth', 'Saint-Nazaire', 'mohamethdiop@hotmail.com', '+33623666568', NULL, NULL, NULL, 0),
(98, 31, 1, 10, 3, 'Seye', 'Fatoumata', '20 boulevard Laennec', 'fatima.seye@gmail.com', '+33646754936', NULL, NULL, NULL, 0),
(99, 33, 2, 8, 25, 'Gningue ', 'Saliou', '77 avenue Rubillard ', 'saliougningue97@gmail.com', '+33758693231', NULL, NULL, NULL, 0),
(100, 33, 2, 10, 25, 'NDIAYE', 'Gora', '16 BOULEVARD CHARLES NICOLLE', 'ndiayegora95@gmail.com', '+33753717584', NULL, NULL, NULL, 0),
(101, 33, 6, 8, 22, 'KEITA', 'Alpha Yaya', '8 avenue General de Gaulle ', 'keitajr08@gmail.com', '+33605708446', NULL, NULL, NULL, 0),
(102, 31, 6, 14, 2, 'NIANG', 'Abdou Khadre', '124 boulevard Emile Zola', 'niangsaer1310@gmail.com', '+33676477650', NULL, NULL, NULL, 0),
(103, 19, 6, 7, 22, 'Thiam', 'Khadim', '14 square du Docteur Guérin', 'khadimthiam1994@gmail.com', '+33766610177', NULL, NULL, NULL, 0),
(104, 19, 6, 7, 22, 'Dieng', 'Abdou', '5 ALLEE DU GUADEL', 'dienga707@gmail.com', '+33753542737', NULL, NULL, NULL, 0),
(105, 19, 6, 8, 15, 'Niang', 'Magatte ', '10 rue Doyen Denis leroy', 'seenayaayfaal@gmail.com', '+33605912850', NULL, NULL, NULL, 0),
(106, 19, 6, 8, 15, 'gueye', 'Ousmane', 'Rennes', 'usmane.gueye@glail.com', '+33753084102', NULL, NULL, NULL, 0),
(107, 19, 2, 7, 1, 'Gaye ', 'Bousso', '14 avenue Jorge semprun appt 503', 'gayebousso10@gmail.com', '+33788703542', NULL, NULL, NULL, 0),
(108, 31, 6, 3, 24, 'NDIAYE', 'ISMAILA', '37 RUE PIERRE MENDES', 'ausndiaya@gmail.com', '+33753844613', NULL, NULL, NULL, 0),
(109, 31, 6, 1, 2, 'Thiam', 'Abdou ', '10 Rue Paul Brousse ', 'Abdoukhafforthiam@hotmail.com', '+33755283034', NULL, NULL, NULL, 0),
(110, 31, 6, 3, 16, 'Ndiaye', 'Yaye Daour ', '37 rue Pierre Mendes', 'yayedaourndiaye@gaiml.com', '+33605735716', NULL, NULL, NULL, 0),
(111, 19, 6, 10, 24, 'NDIAYE', 'Momar Talla', '14 Mail Félix Leclerc 35135 Chantepie', 'momar4t@gmail.com', '+33613689819', NULL, NULL, NULL, 0),
(112, 27, 2, 10, 25, 'Mballo', 'Mouhamadou Lamine', '20 Rue du commandant groix ', 'mballolamine93@gmail.com', '+33753578664', NULL, NULL, NULL, 0),
(113, 27, 1, 14, 19, 'BEYE', 'CIRE', '218 Banell Kerganten penmarch 29760', 'cirebeye@gmail.com', '+33672746859', NULL, NULL, NULL, 0),
(114, 27, 6, 6, 24, 'Fall', 'Cheikh anta ', '17 rué Kergorju ', 'fall01cheikh@gmail.com', '+33783996963', NULL, NULL, NULL, 0),
(115, 27, 6, 7, 14, 'Ndiaye', 'Pape', '9rue Gavarni Brest', 'deguenoundiaye@gmail.com', '+33763561806', NULL, NULL, NULL, 0),
(116, 31, 6, 6, 8, 'Kane', 'Galaye', '06 Rue Olympe de gouges ', 'fallouamina0609@gmail.com', '+33628097209', NULL, NULL, NULL, 0),
(117, 27, 6, 4, 16, 'FAYE', 'Macodou', '7 Square Swansea, 29200 Brest', 'allou1918@hotmail.com', '+33618238434', NULL, NULL, NULL, 0),
(118, 27, 6, 4, 2, 'Sene', 'Abdoulaye', '2 rue marechal clauzel', 'laye1996@hotmail.fr', '+33616178396', NULL, NULL, NULL, 0),
(119, 27, 6, 11, 14, 'SENE ', 'Moussa Ndome', '17 Rue Kergorju Brest 29200', 'mnsene15@gmail.com', '+33767368406', NULL, NULL, NULL, 0),
(120, 27, 6, 7, 14, 'Seye', 'Baye Mamadou ', '4 Rue du Quercy ', 'seyekaramna@gmail.com', '+33751219259', NULL, NULL, NULL, 0),
(121, 32, 6, 14, 2, 'Ndir', 'Magaye', '6bis rue des Capucine', 'nogayendir@gmail.com', '+33751232555', NULL, NULL, NULL, 0),
(122, 27, 6, 7, 14, 'Diop', 'Alima', '5 Rue de Glasgow ', 'diopsadya@hotmail.com', '+33616935347', NULL, NULL, NULL, 0),
(123, 19, 6, 7, 8, 'NDIAYE', 'ISMAILA', '34 mail LéonBlum', 'ndiayercl@gmail.com', '+33681636500', NULL, NULL, NULL, 0),
(124, 27, 2, 10, 13, 'DIOP ', 'Amadou Fall Canar ', 'Canar1994@gmail.com ', 'canar1994@gmail.com', '+33761386327', NULL, NULL, NULL, 0),
(125, 27, 6, 6, 11, 'NDIAYE', 'Mohamed', '14 route de la Wantzenau', 'mohamed18ndiaye@gmail.com', '+33753645142', NULL, NULL, NULL, 0),
(126, 32, 1, 13, 12, 'Diop', 'khadim', '58 rue pierre Blandin 49000', 'khadimdiops@hotmail.com', '+33638341758', NULL, NULL, NULL, 0),
(127, 19, 6, 11, 14, 'Tine', 'Adiouma ', 'Rennes', 'adioumatine@gmail.com', '+33689896826', NULL, NULL, NULL, 0),
(128, 32, 2, 10, 11, 'Niang', 'Hamet', '63 boulevard Henri dunant ', 'hamettniang@gmail.com', '+33753310607', NULL, NULL, NULL, 0),
(129, 32, 2, 4, 25, 'Sagna ', 'Mouhamadou', '58 rue Pierre Blandin ', 'mouhamedsagna434@gmail.com', '+33627890222', NULL, NULL, NULL, 0),
(130, 32, 1, 14, 3, 'tall', 'oumar', '20 rue du petit  noyer', 'bigfadish@hotmail.fr', '+33673226031', NULL, NULL, NULL, 0),
(131, 32, 2, 8, 11, 'Dieng', 'Mor talla', 'Rue de la reux West campus', 'diengmortalla4@gmail.com', '+33753113914', NULL, NULL, NULL, 0),
(132, 32, 6, 7, 14, 'GAYE', 'Fatou', '5 rue prébaudelle 49100 Angers ', 'fagay09@gmail.com', '+33753650558', NULL, NULL, NULL, 0),
(133, 32, 1, 10, 11, 'Samb', 'Elhadji', '12 avenue Mazarin', 'as.4.samb@gmail.com', '+33766867185', NULL, NULL, NULL, 0),
(134, 32, 6, 10, 8, 'SENE', 'Alioune', '6 Square des Cèdres', 'kopsene@yahoo.fr', '+33651594035', NULL, NULL, NULL, 0),
(135, 33, 1, 10, 11, 'Diop', 'Ousmane ', 'Ousmane.diop92@hotmail.com ', 'ousmane.diop92@hotmail.com', '+33645563164', NULL, NULL, NULL, 0),
(136, 33, 1, 10, 11, 'Diop', 'Ousmane ', 'Ousmane.diop92@hotmail.com ', 'ousmane.diop92@hotmail.com', '+33645563164', NULL, NULL, NULL, 0),
(137, 31, 6, 10, 24, 'NDIAYE ', 'Papa Maniang ', '60 Rue Michel Ange', 'papamaniangndiaye@gmail.com', '+33758905615', NULL, NULL, NULL, 0),
(138, 33, 6, 14, 15, 'Fall', 'Adja Sokhna', '139 rue des Maillets ', 'sokhna.fall@hotmail.fr', '+33634398277', NULL, NULL, NULL, 0),
(139, 26, 6, 6, 16, 'Camara', 'Ndeye maimouna', '43 rue du bois herce', 'diouf44100@gmail.com', '+33695683681', NULL, NULL, NULL, 0),
(140, 26, 2, 12, 25, 'SARR ', 'Serigne ', '120 boulevard des Poilus 44300 Nantes ', 'sserigne96@gmail.com', '+33625764315', NULL, NULL, NULL, 0),
(141, 26, 6, 10, 22, 'Ndiaye', 'Serigne Modou Bousso', '12 rue Toronto', 'smbousso621@gmail.com', '+33662931888', NULL, NULL, NULL, 0),
(142, 26, 1, 11, 11, 'SALL', 'Mame Asta', '113 boulevard de la prairie au duc', 'sallmameasta@gmail.com', '+33652468288', NULL, NULL, NULL, 0),
(143, 52, 6, 10, 24, 'KHARMA', 'El hadji Mamadou', '15 Chemin De Meaux, Batiment A1', 'kharma.mamadou@yahoo.fr', '+33602073659', NULL, NULL, NULL, 0),
(144, 53, 6, 10, 24, 'Diaw', 'Khadimou', '50 avenue Aristide briand 92220 Bagneux', 'khadimou.diaw@gmail.com', '+33660502588', NULL, NULL, NULL, 0),
(145, 52, 6, 8, 15, 'Ndiaye', 'Papa Demba', '88 avenue Jean Jaurès Pantin ', 'paapdembandiaye@gmail.com', '+33758654757', NULL, NULL, NULL, 0),
(146, 52, 6, 10, 15, 'Niang', 'Dethie Sarr', '19 Rie Caillaux 75013 Paris', 'dsniang@gmail.com', '+33698653228', NULL, NULL, NULL, 0),
(147, 54, 3, 10, 11, 'DIENG', 'ALIOUNE', '3 RUE HENRI ROSSIGNOL', 'aliounedieng8@hotmail.com', '+33770005677', NULL, NULL, NULL, 0),
(148, 54, 2, 8, 11, 'Gueye', 'Papa Adiouma ', '53 Boulevard de Pesaro, Nanterre 92000', 'gueyepapaadiouma@gmail.com', '+33786140955', NULL, NULL, NULL, 0),
(149, 53, 6, 10, 24, 'Fall', 'KABARO ', 'Paris 17ieme ', 'fall.kabaro@gmail.com', '+33752447005', NULL, NULL, NULL, 0),
(150, 54, 1, 10, 11, 'DIENG', 'Fallou', '2 allée des tilleuls, Neuilly-Sur-Marne, 93330', 'fallou.dieng1853@gmail.com', '+33665314656', NULL, NULL, NULL, 0),
(151, 54, 5, 14, 16, 'Toure', 'Coumba Ndoffene ', '5 rue montmagny 95410 groslay chez Clement Biankazi ', 'ndoffene0494@gmail.com', '+33758241900', NULL, NULL, NULL, 0),
(152, 53, 1, 12, 19, 'Fame', 'Mohamed', '66 rue du Bac', 'mfame25@gmail.com', '+33638874083', NULL, NULL, NULL, 0),
(153, 53, 2, 10, 25, 'Diouf', 'Mbaye', 'ÃŽle de France', 'dioufmbaye85@gmail.com', '+33650510432', NULL, NULL, NULL, 0),
(154, 29, 6, 8, 2, 'Amar', 'Khadim', '6 rue jean lagarde,56100 Lorient ', 'amarkhadim09@gmail.com', '+33669571698', NULL, NULL, NULL, 0),
(155, 54, 2, 8, 13, 'Diop', 'Aladji', '26 rue auguste Meunier ', 'fiindary@gmail.com', '+33751145145', NULL, NULL, NULL, 0),
(156, 54, 6, 10, 15, 'FAYE', 'Diene', '95d, Avenue de la république, 94500 Champigny-sur-Marne ', 'dienefaye12@yahoo.fr', '+33754234860', NULL, NULL, NULL, 0),
(157, 54, 2, 7, 3, 'Gueye', 'Mbacke', '23 RUE ARMAND GUILLAUMOT, 23', 'gueyembacke3@gmail.com', '+33758261013', NULL, NULL, NULL, 0),
(158, 56, 6, 10, 2, 'Ba', 'Ibrahima', '21 rue du général colin', 'ibrahima2003ba@yahoo.fr', '+33624594510', NULL, NULL, NULL, 0),
(159, 53, 6, 10, 24, 'Fall', 'Abdoulaye', '18 cours des merveilles 95800 cergy', 'abdoulayefall@laposte.net', '+33768483647', NULL, NULL, NULL, 0),
(160, 52, 6, 11, 2, 'Gueye', 'Galass', '2 rue edgar quinet, 93360, Neuilly plaisance', 'galass.agn@gmail.com', '+33659684992', NULL, NULL, NULL, 0),
(161, 53, 6, 10, 24, 'DIOUF', 'Badou', '11 Rue Jacquard', 'muntakha@gmail.com', '+33781637642', NULL, NULL, NULL, 0),
(162, 54, 6, 10, 2, 'Niang', 'Alioune Alexandre', '102 Rue Juliette Savar 94000 Créteil', 'aliounealex@hotmail.fr', '+33753900677', NULL, NULL, NULL, 0),
(163, 54, 6, 7, 8, 'WADE', 'Nourou', '2 boulevard georges Méliès', 'nourouwade84@gmail.com', '+33766527682', NULL, NULL, NULL, 0),
(164, 54, 6, 10, 3, 'Diagne', 'Fallou', '17 impasse de la chapelle', 'm.diagnefallou@gmail.com', '+33761759377', NULL, NULL, NULL, 0),
(165, 54, 6, 10, 24, 'NDIAYE', 'Modou', '36 rue Gambetta', 'modou.ndiayebayefall@gmail.com', '+33620469857', NULL, NULL, NULL, 0),
(166, 52, 1, 10, 11, 'LO ', 'Khadim', '25 avenue André rouy', 'khadimrassoul_lo@yahoo.fr', '+33666885938', NULL, NULL, NULL, 0),
(167, 54, 6, 10, 14, 'Djite ', 'Djiby ', '11 rue du Castel Creteil ', 'djite86@gmail.com', '+33773396076', NULL, NULL, NULL, 0),
(168, 56, 6, 10, 14, 'DIACK', 'Seydina Mouhammad', '5 rue du bel air, 78570 Andresy', 'diackseydina@gmail.com', '+33665328054', NULL, NULL, NULL, 0),
(169, 54, 1, 11, 12, 'Gueye ', 'Mamadou ', '63 Avenue De La liberation', 'lotagueye@yahoo.fr', '+33676975530', NULL, NULL, NULL, 0),
(170, 54, 6, 10, 3, 'Diagne', 'Fallou', '17 impasse de la chapelle', 'm.diagnefallou@gmail.com', '+33761759377', NULL, NULL, NULL, 0),
(171, 54, 6, 6, 24, 'SALL', 'Aliou', '6 Rue Jean Lagarde', 'Aliou10.sall@gmail.com', '+33766355770', NULL, NULL, NULL, 0),
(172, 53, 6, 10, 2, 'KANE', 'Mbaye', '3 rue albert thomas 91200 Athis-Mons ', 'kane.mbaye@gmail.com', '+33782870702', NULL, NULL, NULL, 0),
(173, 53, 6, 10, 15, 'FAYE', 'Diene', '95d, Avenue de la république, 94500 Champigny-sur-Marne ', 'dienefaye12@yahoo.fr', '+33754234860', NULL, NULL, NULL, 0),
(174, 53, 6, 14, 2, 'Diop', 'Mamadou Moustapha ', '108 Avenue Martin Luther King', 'mouride-50@hotmail.fr', '+33752171783', NULL, NULL, NULL, 0),
(175, 53, 1, 10, 11, 'DIALLO', 'Mama', '154 RUE MAURICE BERTEAUX', 'Diallomama1@gmail.com', '+33769662955', NULL, NULL, NULL, 0),
(176, 54, 6, 6, 24, 'Thiam', 'Mame Diarra', '81 rue de Paris ', 'salihate23@gmail.com', '+33626401476', NULL, NULL, NULL, 0),
(177, 54, 1, 3, 16, 'Diallo', 'Ndiombane', '139 rue du verger', 'ndiombane@hotmail.com', '+33651336725', NULL, NULL, NULL, 0),
(178, 54, 6, 10, 14, 'BITEYE', 'Mame Bousso', '18 passage des Chalets 93300 Aubervilliers ', 'mame.biteye@hotmail.fr', '+33667194869', NULL, NULL, NULL, 0),
(179, 56, 6, 10, 24, 'SYLLA', 'Maguette', 'Val De Marne', 'maguy.sylla@gmail.com', '+33607618122', NULL, NULL, NULL, 0),
(180, 52, 6, 3, 2, 'Niane ', 'Serigne Mouhamadane ', '2 rue des Tritons 78180 Montigny le Bretonneux ', 'serigneniane0599@gmail.com', '+33783551517', NULL, NULL, NULL, 0),
(181, 54, 6, 10, 14, 'Lo', 'Serigne modou', '27 Avenue president Salvador Allende ', 'doumo19@hotmail.com', '+33618552262', NULL, NULL, NULL, 0),
(182, 53, 6, 10, 2, 'Diao', 'Khadim', '6 rue Duguay Trouin ', 'khadiao87@yahoo.fr', '+33643010917', NULL, NULL, NULL, 0),
(183, 52, 6, 14, 2, 'Gueye', 'Dame', '1 Rue du docteur schweitzer', 'gueyedame.gd@gmail.com', '+33605867476', NULL, NULL, NULL, 0),
(184, 52, 6, 14, 2, 'Gueye', 'Dame', '1 Rue du docteur schweitzer', 'gueyedame.gd@gmail.com', '+33605867476', NULL, NULL, NULL, 0),
(185, 52, 6, 14, 2, 'Gueye', 'Dame', '1 Rue du docteur schweitzer', 'gueyedame.gd@gmail.com', '+33605867476', NULL, NULL, NULL, 0),
(186, 53, 6, 4, 8, 'Samb ', 'Mouhamed ', '21 rue du conseil national de la résistance 91700 Fleury-Mérogis ', 'momoteranga1@hotmail.fr', '+33698141168', NULL, NULL, NULL, 0),
(187, 54, 6, 8, 22, 'DOUCOURE', 'Lamine', 'Résidence universitaire Lacroix Saint sylvere', 'douxelam@gmail.com', '+33758320613', NULL, NULL, NULL, 0),
(188, 54, 6, 7, 5, 'Ndiaye', 'Pape Mor', '64 boulevard Stalingrad Vitry sur Seine ', 'Papemorndiaye224@gmail.com', '+33762938675', NULL, NULL, NULL, 0),
(189, 54, 1, 8, 16, 'Mbodj', 'Thiara', '19 parc des Courtillières 93500 Pantin ', 'cthiara@yahoo.fr', '+33624054907', NULL, NULL, NULL, 0),
(190, 56, 2, 11, 1, 'Kante', 'Tanor fall', '7, Chemin Des Prunais 94350 Villiers sur Marne ', 'tanor111@yahoo.fr', '+33755427015', NULL, NULL, NULL, 0),
(191, 53, 6, 6, 8, 'Kassé', 'Dame', '103 avenue de la division Leclerc 93430', 'damekass@yahoo.fr', '+33659082851', NULL, NULL, NULL, 0),
(192, 55, 6, 10, 14, 'Fall', 'Aziz', 'Vélizy-villacoublay', 'marketplacefa@gmail.com', '+33753846820', NULL, NULL, NULL, 0),
(193, 54, 6, 14, 8, 'Niane', 'Bassirou', '178 rue de Crimée ', 'bassfata93@gmail.com', '+33651404093', NULL, NULL, NULL, 0),
(194, 54, 6, 8, 22, 'DOUCOURE', 'Lamine', 'Résidence universitaire Lacroix Saint sylvere', 'douxelam@gmail.com', '+33758320613', NULL, NULL, NULL, 0),
(195, 54, 2, 8, 11, 'Gueye', 'Papa Adiouma ', '53 Boulevard de Pesaro, Nanterre 92000', 'gueyepapaadiouma@gmail.com', '+33786140955', NULL, NULL, NULL, 0),
(196, 56, 6, 11, 14, 'KANE ', 'Mandiaye ', '37 C avenue Louis Bréguet 78140 Velizy Villacoublay ', 'kanemandiaye@gmail.com', '+33669165026', NULL, NULL, NULL, 0),
(197, 52, 6, 3, 24, 'SEYE', 'Assane ', '33 rue de Torcy 77360 VAIRES SUR MARNE ', 'seyefara07@gmail.com', '+33646172840', NULL, NULL, NULL, 0),
(198, 55, 6, 7, 2, 'Ndiaye', 'Khadim ', 'Montrouge ', 'khadimndiaye0707@gmail.com', '+33695930601', NULL, NULL, NULL, 0),
(199, 54, 6, 7, 8, 'Ndiaye ', 'Aly', '4  RUE DES ECOLES', 'ndiayeali93@gmail.com', '+33650013315', NULL, NULL, NULL, 0),
(200, 53, 2, 7, 16, 'LEYE', 'MAWO', 'Rue 5 des Marnaudes chez Gaye samb', 'mawoleye84@gmail.com', '+33782008997', NULL, NULL, NULL, 0),
(201, 52, 6, 11, 14, 'Kanté ', 'Amidou ', '6 rue du chÃ¢teau 92250 la garenne colombes ', 'amidou.k.kante@gmail.com', '+33695318579', NULL, NULL, NULL, 0),
(202, 54, 6, 10, 2, 'FALL', 'Moustapha bassirou', '165 Rue de Charonne, Chambre 715', 'moustapha.b.fall@gmail.com', '+33751842856', NULL, NULL, NULL, 0),
(203, 55, 6, 1, 8, 'NDIAYE ', 'SOULEYMANE', '18 RUE  DE CHAUMONT', 'julndiaye@hotmail.com', '+33755411549', NULL, NULL, NULL, 0),
(204, 8, 6, 10, 14, 'DIAITE', 'ALPHA', '11 RUE GERMAINE TILLION 45140 SAINT JEAN DE LA RUELLE ', 'alphadiaite@yahoo.fr', '+33612166039', NULL, NULL, NULL, 0),
(205, 53, 1, 10, 23, 'Leye', 'Fallou', '26 boulevards du champy richardets', 'leyefallou@yahoo.fr', '+33658758638', NULL, NULL, NULL, 0),
(206, 55, 3, 10, 11, 'COUNDOUL', 'Momar', '91430, Igny, France', 'coundoulexo@gmail.com', '+33667545520', NULL, NULL, NULL, 0),
(207, 52, 6, 1, 8, 'SOW', 'samba', '82 rue du Moutier,  porte E213', 'sow_samba@hotmail.com', '+33751068747', NULL, NULL, NULL, 0),
(208, 55, 1, 6, 11, 'Coundoul', 'Ndeye', '91430 Igny', 'ndeye.coundoune@gmail.com', '+33634335679', NULL, NULL, NULL, 0),
(209, 55, 1, 10, 11, 'Aw', 'Abdoulaye', '5 allée des zinnias', 'abdoulayeaw89@hotmail.com', '+33758569221', NULL, NULL, NULL, 0),
(210, 55, 6, 10, 24, 'TALL', 'Seyni', '129 Boulevard Ney', 'seynicniicoo@gmail.com', '+33662253134', NULL, NULL, NULL, 0),
(211, 53, 3, 10, 3, 'Mbaye', 'El Hadji Falilou ', 'adafalilou@gmail.com', 'adafalilou@gmail.com', '+33768094544', NULL, NULL, NULL, 0),
(212, 55, 1, 10, 11, 'NDIAYE ', 'Assane ', 'Cergy 95800', 'andiaye0510@gmail.com', '+33659535739', NULL, NULL, NULL, 0),
(213, 55, 2, 10, 11, 'DIEDHIOU', 'Khady Adiama', '15 Avenue de la Résistance, 93100 Montreuil ', 'adiamakhady95@gmail.com', '+33758299854', NULL, NULL, NULL, 0),
(214, 55, 6, 6, 14, 'Sogodogo ', 'Abdourahmane ', '02, rue de Verdun 60100 Creil ', 'dousogo100@gmail.com', '+33753286253', NULL, NULL, NULL, 0),
(215, 56, 6, 11, 14, 'KANE ', 'Mandiaye ', '37 C avenue Louis Bréguet 78140 Velizy Villacoublay ', 'kanemandiaye@gmail.com', '+33669165026', NULL, NULL, NULL, 0),
(216, 52, 6, 14, 8, 'Mbodj', 'Bassirou ', '58 boulevard de Strasbourg 75010 Paris ', 'mbassirou@hotmail.fr', '+33610832975', NULL, NULL, NULL, 0),
(218, 54, 2, 8, 23, 'DIOP', 'Marieme Diarra Bousso', '33 boulevard gallieni', 'mariemediarra93@gmail.com', '+33699242119', NULL, NULL, NULL, 0),
(219, 53, 6, 10, 14, 'Fall', 'Massourang', '101 rue de Villiers 78300 Poissy', 'papamassourang@gmail.com', '+33626048838', NULL, NULL, NULL, 0),
(220, 52, 1, 10, 11, 'GADJI', 'Baba', '29, Rue de la Division Leclerc', 'babagadji@yahoo.fr', '+33665043343', NULL, NULL, NULL, 0),
(221, 54, 2, 6, 19, 'Fall', 'Mame bousso', '3 rue auguste poullain 93200 Saint-Denis ', 'boussofall37@gmail.com', '+33782837686', NULL, NULL, NULL, 0),
(222, 56, 6, 10, 14, 'Danfa', 'Fodé', '64 Boulevard de Stalingrad 94400 Vitry sur Seine ', 'danfode@gmail.com', '+33651935048', NULL, NULL, NULL, 0),
(223, 56, 1, 4, 16, 'sylla', 'cheickh ahmadou bamba ', '25 bis Boulevard Armand Leprince 78700 conflans ', 'syllaahmadou@hotmail.fr', '+33614136131', NULL, NULL, NULL, 0),
(224, 52, 1, 10, 11, 'Gueye', 'Malick', 'Massy', 'mgueye-@hotmail.fr', '+33755079808', NULL, NULL, NULL, 0),
(225, 55, 6, 10, 22, 'Leye', 'Mame Mor', 'Orleans ', 'mamemor7010@gmail.com', '+33769719242', NULL, NULL, NULL, 0),
(226, 54, 2, 7, 3, 'Diallo', 'Aboubakry ', '1rue du terme boréal 77127 lieusaint ', 'sadboudiallo40@gmail.com', '+33755118659', NULL, NULL, NULL, 0),
(227, 53, 6, 4, 8, 'Samb ', 'Mouhamed ', '21 rue du conseil national de la résistance 91700 Fleury-Mérogis ', 'momoteranga1@hotmail.fr', '+33698141168', NULL, NULL, NULL, 0),
(228, 54, 6, 8, 22, 'DOUCOURE', 'Lamine', 'Résidence universitaire Lacroix Saint sylvere', 'douxelam@gmail.com', '+33758320613', NULL, NULL, NULL, 0),
(229, 53, 1, 12, 3, 'Thiam', 'Abdoulahad ', '100 rue du General De Gaulle', 'abdoulahad.thiam@gmail.com', '+33760587929', NULL, NULL, NULL, 0),
(230, 1, 6, 10, 24, 'Diouf', 'Mouhamed Moustapha ', 'Valenciennes ', 'mouhataphadiouf@gmail.com', '+33753773225', NULL, NULL, NULL, 0),
(231, 55, 1, 12, 11, 'NDOYE', 'Bada ', 'Sartrouville ', 'dstndoye@gmail.com', '+33664442756', NULL, NULL, NULL, 0),
(232, 53, 1, 12, 3, 'Thiam', 'Abdoulahad ', '100 rue du General De Gaulle', 'abdoulahad.thiam@gmail.com', '+33760587929', NULL, NULL, NULL, 0),
(233, 53, 1, 10, 3, 'Thiam', 'Papa Massaer', '4 Rue du Capitaine Bastien 77000 melun ', 'papemasse53@hotmail.com', '+33619880865', NULL, NULL, NULL, 0),
(234, 57, 6, 7, 24, 'Mbaye', 'Ahma', '02 villa charles gambon 91000 Evry', 'mbaye.ahma@gmail.com', '+33758170201', NULL, NULL, NULL, 0),
(235, 55, 1, 14, 16, 'Christophe paille dit', 'Modou Mbacke ', '13 rue recluziere 07100 annonay', 'modoukara28@yahoo.fr', '+33785310809', NULL, NULL, NULL, 0),
(236, 53, 3, 10, 3, 'Mbaye', 'El Hadji Falilou ', 'adafalilou@gmail.com', 'adafalilou@gmail.com', '+33768094544', NULL, NULL, NULL, 0),
(237, 52, 6, 14, 8, 'Mbodj', 'Bassirou ', '58 boulevard de Strasbourg 75010 Paris ', 'mbassirou@hotmail.fr', '+33610832975', NULL, NULL, NULL, 0),
(238, 54, 6, 10, 14, 'BITEYE', 'Mame Bousso', '18 passage des Chalets 93300 Aubervilliers ', 'mame.biteye@hotmail.fr', '+33667194869', NULL, NULL, NULL, 0),
(239, 55, 6, 8, 15, 'Ndiaye', 'Thierno', '2 rue du lieutenant menieux', 'ndiaye.thiernolo1@gmail.com', '+33788762651', NULL, NULL, NULL, 0),
(240, 55, 6, 7, 15, 'Seck', 'Cheikh Ahmed Tidiane', '2 Rue Soeur Bouvier, Residence Fort Saint Irenée Bat Vieux Fort Appt A108A', 'seck404@gmail.com', '+33758185276', NULL, NULL, NULL, 0),
(241, 54, 2, 5, 19, 'Kandé ', 'Korca-Anna', '18 allées des renoncules 93140 Bondy ', 'anna.kand@yahoo.com', '+33650573363', NULL, NULL, NULL, 0),
(242, 54, 2, 4, 13, 'Gueye', 'Mame Diarra', 'Nanterre ', 'sokhnahdiarra@gmail.com', '+33652479450', NULL, NULL, NULL, 0),
(243, 54, 5, 14, 16, 'Toure', 'Coumba', '5 rue montmagny', 'ndoffene0494@gmail.com', '+33758241900', NULL, NULL, NULL, 0),
(244, 54, 6, 5, 22, 'Mar', 'papa alioune', '50 allee daniel fery', 'papaalioune05@hotmail.fr', '+33652612520', NULL, NULL, NULL, 0),
(245, 54, 1, 10, 11, 'Diouf', 'Mamadou ', '108 Boulevard de la Reine 78000 versailles ', 'mahmadan92@gmail.com', '+33787811093', NULL, NULL, NULL, 0),
(246, 54, 6, 10, 2, 'Diaite', 'Lamine', '4 avenue de la gaité 93220 gagny ', 'mouhamadou.diaite@gmail.com', '+33652450258', NULL, NULL, NULL, 0),
(247, 3, 6, 10, 22, 'Diop', 'Serigne Moustapha Bassirou ', 'BesanÃ§on ', 'bassirou089@yahoo.fr', '+33769048795', NULL, NULL, NULL, 0),
(248, 53, 6, 11, 14, 'GUEYE', 'Ndiack', '14 Allée des Bigaradiers', 'ndiackgueye@gmail.com', '+33608639920', NULL, NULL, NULL, 0),
(249, 56, 6, 10, 15, 'DIACK', 'Astou', '5, rue du Bel Air 78570 ANDRESY ', 'astou.samb.diouf@gmail.com', '+33677560982', NULL, NULL, NULL, 0),
(250, 54, 6, 10, 2, 'Diaite', 'Lamine', '4 avenue de la gaité 93220 gagny ', 'mouhamadou.diaite@gmail.com', '+33652450258', NULL, NULL, NULL, 0),
(251, 54, 6, 10, 2, 'NDIAYE', 'TOUBA', '2 Boulevard Georges Melies 94360 Bry-Sur-Marne', 'toubandiaye92@gmail.com', '+33754561425', NULL, NULL, NULL, 0),
(252, 54, 1, 10, 13, 'Kane', 'AÃ¯ssatou Barry', '12 rue valentin conrart 91200 Athis-mons ', 'satoubarry@yahoo.fr', '+33668044082', NULL, NULL, NULL, 0),
(253, 52, 6, 10, 14, 'Sall', 'El Hadji Mansour', '36 rue Michelet 94460 Valenton ', 'mansallfr@yahoo.fr', '+33670208220', NULL, NULL, NULL, 0),
(254, 52, 6, 10, 14, 'Seck', 'Ndeye', '35 boulevard carnot', 'seckdaye@yahoo.fr', '+33658651830', NULL, NULL, NULL, 0),
(255, 53, 1, 8, 25, 'SENE', 'Mamadou Lamine', '6 Avenue de Bourgogne , Appartement 201', 'karamena89@gmail.com', '+33758608043', NULL, NULL, NULL, 0),
(256, 53, 6, 11, 22, 'Ba', 'Seydina Omar', 'Evry', 'baomar1313@gmail.com', '+33767132506', NULL, NULL, NULL, 0),
(257, 55, 6, 1, 8, 'NDIAYE ', 'SOULEYMANE', '18 rue de Chaumont 77 165 saint-soupplets ', 'julndiaye@hotmail.com', '+33755411549', NULL, NULL, NULL, 0),
(258, 55, 6, 14, 8, 'Sylla', 'Khadim', '2 allée Gagarine Ivry-sur-Seine ', 'khadimbayfall@hotmail.fr', '+33611282286', NULL, NULL, NULL, 0),
(259, 55, 6, 10, 2, 'FALL', 'Mame Cheikh Ibra ', '41 rue du chÃ¢teau Landon Paris ', 'fallmame.c@gmail.com', '+33614842648', NULL, NULL, NULL, 0),
(260, 52, 6, 14, 12, 'DIENG', 'Fatou Diaw', 's/c Mme SENE 23 rue Auguste Blanqui 93700 DRANCY', 'Adjafatoudieng96@gmail.com', '+33652595807', NULL, NULL, NULL, 0),
(261, 56, 6, 11, 15, 'DIOUF', 'BLAISE', '189 Avenue Paul Vaillant COUTURIER', 'Gallass1945@gmail.com', '+221775348956', NULL, NULL, NULL, 0),
(262, 54, 1, 10, 12, 'SOW', 'Mahmadane', '8 rue des pépinières 94400 vitry sur seine ', 'mahmadanesow@gmail.com', '+33784449837', NULL, NULL, NULL, 0),
(263, 54, 1, 10, 12, 'SOW', 'Mahmadane', '8 rue des pépinières 94400 vitry sur seine ', 'mahmadanesow@gmail.com', '+33784449837', NULL, NULL, NULL, 0),
(264, 55, 6, 14, 8, 'Sylla', 'Khadim', '2 allée Gagarine Ivry-sur-Seine ', 'khadimbayfall@hotmail.fr', '+33611282286', NULL, NULL, NULL, 0),
(265, 53, 1, 10, 3, 'Sow', 'Ousseynou', '12B Avenue Mazarin 91380 Chilly-Mazarin', 'ousseynou.sow@hotmail.fr', '+33620898628', NULL, NULL, NULL, 0),
(266, 54, 6, 6, 22, 'Sow', 'Makane', '24, rue des Brandons 77380 Combs la Ville', 'makanesow22@gmail.com', '+33763237535', NULL, NULL, NULL, 0),
(267, 53, 1, 10, 12, 'MBAYE', 'Serigne Mountakha', '8 Allee Paul Verlaine', 'takha72000@yahoo.fr', '+33624002405', NULL, NULL, NULL, 0),
(268, 34, 3, 6, 1, 'Sall ', 'Doudou ', 'Résidence timone 1 BÃ¢timent A5,  4 rue des Fenals', 'saldoudou@yahoo.fr', '+33625312435', NULL, NULL, NULL, 0),
(269, 34, 6, 1, 14, 'GUEYE', 'MAREME', '38 AVENUE GEORGES BRAQUE , LES IRIS', 'maremegueye39@gmail.com', '+33605558863', NULL, NULL, NULL, 0),
(270, 34, 6, 14, 2, 'Niang', 'Ousmane', '213 boulevard rabatau  13010 Marseille ', 'niangouzous@hotmail.fr', '+33698647690', NULL, NULL, NULL, 0),
(271, 34, 2, 8, 25, 'DIOP', 'Moustapha', '38,Boulevard Jean Moulin,13005 Marseille', 'mmoustapha.94@hotmail.com', '+33605508429', NULL, NULL, NULL, 0),
(272, 34, 6, 4, 8, 'ILLIASSOU', 'Mahaman', '36 Boulevard marie Joseph', 'illiassou.mahaman@gmail.com', '+33624507552', NULL, NULL, NULL, 0),
(273, 34, 2, 10, 11, 'DIOUF', 'Abdoul Ahad ', '38 boulevard Jean Moulin, 13005 Marseille ', 'dioufabdoulahad1989@gmail.com', '+33753477275', NULL, NULL, NULL, 0),
(274, 34, 6, 7, 15, 'sarr', 'Seydina Alioune ', '23 rue Mathieu Stillati Marseille ', 'sarraliou10@gmail.com', '+33758428749', NULL, NULL, NULL, 0),
(275, 34, 2, 10, 11, 'Thiaw', 'Souleymane', '73 rue hoche', 'Souleymanethiaw1@gmail.com', '+33753222949', NULL, NULL, NULL, 0),
(276, 34, 6, 4, 15, 'Thiaw', 'Nadine', '35 rue auphan ', 'nadthw@gmail.com', '+33618996957', NULL, NULL, NULL, 0),
(277, 16, 6, 10, 14, 'Gueye ', 'Seynabou ', 'Cité u saulcy ', 'yayenabouza@gmail.com', '+33758396462', NULL, NULL, NULL, 0),
(278, 16, 1, 11, 3, 'Fall', 'Abdou', '10 route de borny ', 'zoomus11@hotmail.fr', '+33760829396', NULL, NULL, NULL, 0),
(279, 34, 6, 5, 22, 'Faye', 'Boure', '12 rue d aix 13001marseille', 'fayeboure250@gmail.com', '+33767912839', NULL, NULL, NULL, 0),
(280, 34, 6, 10, 14, 'Pouye', 'Mame Diarra', '31 rue Basly', 'radiapouye@gnaol.com', '+33605510145', NULL, NULL, NULL, 0),
(281, 34, 1, 11, 3, 'Fall', 'Abdou', '10 route de borny ', 'zoomus11@hotmail.fr', '+33760829396', NULL, NULL, NULL, 0),
(282, 34, 6, 10, 14, 'Pouye', 'Mame Diarra', '31 rue Basly', 'radiapouye@gnaol.com', '+33605510145', NULL, NULL, NULL, 0),
(283, 16, 6, 5, 24, 'Ba', 'Baye Serigne', '2 rue du Général Delestraint', 'bayeserigne1420@gmail.com', '+33772281018', NULL, NULL, NULL, 0),
(284, 16, 6, 5, 24, 'Ba', 'Baye Serigne', '2 rue du Général Delestraint', 'bayeserigne1420@gmail.com', '+33772281018', NULL, NULL, NULL, 0),
(285, 54, 6, 7, 2, 'GUEYE', 'CHEIKH Massamba', '13 Allée de la noiseraie 93160', 'gueyecheikhmassamba@gmail.com', '+33605809383', NULL, NULL, NULL, 0),
(286, 52, 6, 10, 2, 'DIOUF', 'Ibrahima', '32 rue Camille Claudel', 'ibrahima.diouff@gmail.com', '+33602656882', NULL, NULL, NULL, 0),
(287, 52, 6, 11, 14, 'Fall', 'Inssa', '60 Avenue du Bontemps  95800 CERGY', 'inssafall@hotmail.com', '+33652097666', NULL, NULL, NULL, 0),
(288, 50, 1, 10, 12, 'Mbaye', 'Mamadou', '103, Avenue Henry Dunant', 'ccf2010@hotmail.fr', '+33627660045', NULL, NULL, NULL, 0),
(289, 50, 6, 14, 14, 'TOURE', 'Abdoul Khadre Nasir', '151 avenue Jean Jaurès 92120 Montrouge', 'abdoukhadrenasir@gmail.com', '+33778258499', NULL, NULL, NULL, 0),
(290, 34, 2, 5, 25, 'SECK', 'Mouhamed', '168 Rue De Crimée', 'ameth98seck@gmail.com', '+33755234991', NULL, NULL, NULL, 0),
(291, 53, 6, 4, 8, 'Samb ', 'Mouhamed ', '21 rue du conseil national de la résistance 91700 Fleury-Mérogis ', 'momoteranga1@hotmail.fr', '+33698141168', NULL, NULL, NULL, 0),
(292, 53, 6, 7, 22, 'Fall', 'Niaye ', '5 Avenue des hautes bruyères ', 'niayeperso@gmail.com', '+33663435089', NULL, NULL, NULL, 0),
(293, 34, 6, 10, 22, 'DOUCOURE ', 'Cheikh ', '18 Impasse de la Touche 86340 Aslonnes ', 'padoucoure@yahoo.fr', '+33650607183', NULL, NULL, NULL, 0),
(294, 34, 6, 10, 24, 'LO', 'Birane', '24 rue Saint Charles', 'lo.birane07@gmail.com', '+33660686349', NULL, NULL, NULL, 0),
(295, 56, 6, 11, 14, 'KANE ', 'Mandiaye ', '37 C avenue Louis Bréguet 78140 Velizy Villacoublay ', 'kanemandiaye@gmail.com', '+33669165026', NULL, NULL, NULL, 0),
(296, 53, 1, 12, 19, 'Fame', 'Mohamed', '66 rue du Bac', 'mfame25@gmail.com', '+33638874083', NULL, NULL, NULL, 0),
(297, 34, 1, 3, 16, 'Diallo', 'Ndiombane', '139 rue du verger', 'ndiombane@hotmail.com', '+33651336725', NULL, NULL, NULL, 0),
(298, 42, 1, 12, 12, 'Gueye', 'Aliou', '8 rue gentille Cohen 11100', 'gueyelune485@yahoo.com', '+33648312110', NULL, NULL, NULL, 0),
(299, 37, 1, 10, 1, 'DIENG', 'MBACKE', '29 avenue de la synagogue', 'mbackedieng231@gmail.com', '+33629826102', NULL, NULL, NULL, 0),
(300, 37, 1, 7, 3, 'NDIAYE ', 'Pape Ibrahima ', '2 Rue du Gardian 84000 AVIGNON ', 'pape_iba@hotmail.com', '+33625855643', NULL, NULL, NULL, 0),
(301, 37, 2, 7, 1, 'Faye ', 'Ibrahima ', '18 Rue Lantern', 'fayeibrahima101@gmail.com', '+33667204410', NULL, NULL, NULL, 0),
(302, 37, 6, 6, 14, 'GUEYE ', 'Ousmane', '24 bis rue sainte Catherine ', 'ousmanehueye92@gmail.com', '+33768511941', NULL, NULL, NULL, 0),
(303, 38, 2, 8, 25, 'Dia', 'Ibra Khary', '04 rue Baudin', 'ibrakhary94@gmail.com', '+33605521950', NULL, NULL, NULL, 0),
(304, 38, 2, 7, 25, 'Dieng', 'Maimouna', 'Rue 657 avenue 1er BIMP', 'maimounadieng002@gmail.com', '+33758289907', NULL, NULL, NULL, 0),
(305, 38, 6, 6, 24, 'Ngamb', 'Adama', '659 chemin de chateau vallon ollioules', 'adamangamb99@gmail.com', '+33658646123', NULL, NULL, NULL, 0),
(306, 38, 1, 10, 11, 'Diaw', 'Idy', 'Toulon', 'Idrissadiao28@gmail.com', '+33760767469', NULL, NULL, NULL, 0),
(307, 38, 2, 7, 13, 'Kebe', 'Aly', '45, rue Gimelli 83000', 'kebeali94@gmail.com', '+33758613204', NULL, NULL, NULL, 0),
(308, 38, 2, 8, 25, 'BEYE', 'Cheikh Darou ', '657 avenue du premier bimp 83130 résidence le faron Q-357', 'cheikhdaroubeye@gmail.com', '+33661747896', NULL, NULL, NULL, 0),
(309, 38, 2, 10, 25, 'Niane', 'Ibra', '100 boulevard jean noble 83000', 'nianeibra1712@gmail.com', '+33751495551', NULL, NULL, NULL, 0),
(310, 38, 2, 6, 25, 'FAYE', 'Aliou', '657 Avenue du 1ère BIMP', 'alioufaye639@gmail.com', '+33619927734', NULL, NULL, NULL, 0),
(311, 38, 2, 7, 13, 'Kebe', 'Aly', '45, rue Gimelli 83000', 'kebeali94@gmail.com', '+33758613204', NULL, NULL, NULL, 0),
(312, 37, 6, 8, 22, 'Diouf', 'Cheikh Mbacké', '24 bis', 'dioufcheikhmbacke07@yahoo.com', '+33751331042', NULL, NULL, NULL, 0),
(313, 37, 6, 8, 22, 'Diouf', 'Cheikh Mbacké', '24 bis', 'dioufcheikhmbacke07@yahoo.com', '+33751331042', NULL, NULL, NULL, 0),
(314, 37, 1, 10, 11, 'Kane', 'Ababacar', '2, Rue du Guardian, Avignon', 'kanesean@hotmail.com', '+33769307673', NULL, NULL, NULL, 0),
(315, 34, 6, 6, 24, 'Tall', 'Khadim', '169 Rue de Crimée 13003 Marseille', 'tallkhadim50@gmail.com', '+33749127204', NULL, NULL, NULL, 0),
(316, 34, 6, 8, 8, 'Ndao', 'Mouride  nar', '2 rue du genie chez mr dieng', 'narndao@yahoo.fr', '+33644763655', NULL, NULL, NULL, 0),
(317, 34, 2, 10, 23, 'Coulibaly', 'Pape Moussa', '24 rue du 141e RIA 13003 ', 'pmc7.pc@gmail.com', '+33611857023', NULL, NULL, NULL, 0),
(318, 34, 6, 1, 14, 'GUEYE', 'MAREME', '38 Avenue Georges Braque, les iris bat 25 13014 marseille', 'maremegueye39@gmail.com', '+33605558863', NULL, NULL, NULL, 0),
(319, 34, 2, 7, 11, 'Fall', 'Bara', '145 bis boulevard baille ', 'barafall770@gmail.com', '+33751521328', NULL, NULL, NULL, 0),
(321, 34, 2, 6, 25, 'TOURE', 'Moussa', '21 Boulevard Charles Nedelec ', 'mtoure1599@gmail.com', '+33659557190', NULL, NULL, NULL, 0),
(322, 34, 6, 14, 2, 'Niang', 'Ousmane', '213 boulevard rabatau 13010 Marseille ', 'niangouzous@hotmail.fr', '+33698647690', NULL, NULL, NULL, 0),
(323, 34, 6, 10, 24, 'Diaw', 'Mamadou Abdou Aziz', '129 Av du Merlan', 'maazizdiaw@gmail.com', '+33658591305', NULL, NULL, NULL, 0),
(324, 34, 2, 10, 11, 'Ndiaye', 'Moustapha', '38 boulevard jean Moulin', 'tapha1824@gmail.com', '+33763477308', NULL, NULL, NULL, 0),
(325, 34, 1, 10, 11, 'Gueye', 'MOUHAMED', '02 rue Gorde', 'gueyenioro2012@gmail.com', '+33605232472', NULL, NULL, NULL, 0),
(326, 34, 1, 10, 12, 'Sambe', 'Birame', '18 rue Raphael ', 'biramesambe@gmail.com', '+33760347977', NULL, NULL, NULL, 0),
(327, 34, 6, 4, 15, 'Thiaw ', 'Nadine ', '35 rue auphan ', 'nadthw@gmail.com', '+33618996957', NULL, NULL, NULL, 0),
(328, 34, 2, 7, 25, 'Sadj', 'Cheikh Moussa', 'Marseille ', 'moussalilsadj@gmail.com', '+33612194463', NULL, NULL, NULL, 0),
(329, 34, 1, 1, 16, 'Sarr', 'Gora', '1, rue  neoule les oliviers c4 appt.510', 'association.refane@free.fr', '+33781435171', NULL, NULL, NULL, 0),
(330, 34, 6, 14, 15, 'Gueye', 'Modou', '12 ru mission de france 13001', 'modou745@gmail.com', '+33753926223', NULL, NULL, NULL, 0),
(332, 50, 1, 10, 11, 'AMAR', 'Mourtalla', '04 rue Caffarelli, 06000', 'amar.mourtada.touba@gmail.com', '+33767807709', NULL, NULL, NULL, 0),
(333, 45, 6, 10, 2, 'Amar', 'Mamadou', '61 route de lyon', 'mamadouamar@hotmail.com', '+33688518287', NULL, NULL, NULL, 0),
(334, 50, 6, 7, 14, 'Gueye ', 'Serigne Moustapha Mbacké ', 'Avenue Mirabeau ', 'amdygueye@yahoo.fr', '+33612928285', NULL, NULL, NULL, 0),
(335, 37, 6, 11, 22, 'gueye', 'khady', 'Résidence le pré du collège 2. Rue des ives 84270 Vedene ', 'khadychou@hotmail.com', '+33613813636', NULL, NULL, NULL, 0),
(336, 34, 6, 8, 15, 'Diaw', 'Khadim Rassoul', '14 avenue de la Porte des Poissonniers, 75018', 'khadimrassouldiaw@gmail.com', '+33751211170', NULL, NULL, NULL, 0),
(337, 34, 2, 7, 25, 'Gueye', 'Ndeye Awa', '129 Avenue du Merlan 13014 ', 'ndeyeawagueye2000@icloud.com', '+33758370762', NULL, NULL, NULL, 0),
(338, 47, 1, 10, 11, 'Mbaye', 'Aliou', '19 Rue Jean moulin', 'alioumbaye83@gmail.com', '+33761166224', NULL, NULL, NULL, 0),
(339, 38, 2, 8, 25, 'Diouf ', 'Mamadou ', '657av du BIMP residence le Coudon ch 117F ', 'mamadoudiouf171@gmail.com', '+33754180504', NULL, NULL, NULL, 0),
(340, 38, 2, 8, 25, 'NDAO', 'Cheikh', '657 avenue du 1re BIMP', 'ndaondanane1@gmail.com', '+33758332465', NULL, NULL, NULL, 0),
(341, 37, 6, 14, 15, 'Diop', 'Maip', '12 avenue Paul Claudel ', 'diopmaip65@gmail.com', '+33624428899', NULL, NULL, NULL, 0),
(342, 38, 6, 8, 14, 'Ndiaye', 'Fatou', '45 rue emile gimelli ', 'fatou.sr.ndiaye@gmail.com', '+33664874231', NULL, NULL, NULL, 0),
(343, 38, 2, 7, 25, 'Dieng', 'Maimouna', 'Rue 657 avenue 1er BIMP', 'maimounadieng002@gmail.com', '+33758289907', NULL, NULL, NULL, 0),
(344, 38, 2, 8, 25, 'Kande', 'Thierno', '657, avenue du premier BIMP la GARDE ', 'thierkan.wilsh@gmail.com', '+33753920869', NULL, NULL, NULL, 0),
(345, 38, 6, 10, 22, 'Fall', 'Mbaye', '657,av du 1er bimp  83000', 'rajaab2008@gmail.com', '+33758506554', NULL, NULL, NULL, 0),
(347, 34, 6, 14, 2, 'Niang', 'Ousmane', '213 boulevard rabatau 13010 Marseille ', 'niangouzous@hotmail.fr', '+33698647690', NULL, NULL, NULL, 0),
(348, 43, 6, 7, 24, 'MBOW', 'Serigne Abdou Lahat', '26 Avenue Alfred Sauvy', 'abdoulahat04@gmail.com', '+33695019122', NULL, NULL, NULL, 0),
(349, 35, 1, 10, 25, 'NDIAYE', 'Mame Mbénda', '40, Avenue Pierre Mendes France ', 'ndiayegainde2000@yahoo.fr', '+33606563323', NULL, NULL, NULL, 0),
(350, 35, 6, 1, 24, 'Sylla', 'Aziz', '9 rue des chamois', 'azizsylla25@gmail.com', '+33609322536', NULL, NULL, NULL, 0),
(351, 35, 2, 8, 3, 'GUEYE', 'Alassane', '17 Avenue du Colonel Roche', 'asoubiaguey@gmail.com', '+33614185940', NULL, NULL, NULL, 0),
(352, 35, 1, 10, 11, 'SEYE', 'Mohamadou Falilou ', '120 avenue roger Salengro ', 'falilouseye91@gmail.com', '+33650915967', NULL, NULL, NULL, 0),
(353, 35, 2, 6, 25, 'Ndiaye', 'Modou Madeguene', '118 route de Narbonne ', 'zikofatou98@gmail.com', '+33749799000', NULL, NULL, NULL, 0),
(354, 35, 2, 10, 23, 'CISSE', 'Dame', '7 Allée des sciences Appliquées', 'cissedame@hotmail.fr', '+33758402383', NULL, NULL, NULL, 0),
(355, 35, 2, 6, 25, 'Ndiaye', 'Modou Madeguene', '118 route de Narbonne ', 'zikofatou98@gmail.com', '+33749799000', NULL, NULL, NULL, 0),
(356, 35, 4, 10, 23, 'Lo', 'Adama', '2 chemin de Pelleport', 'adama26@hotmail.fr', '+33619601798', NULL, NULL, NULL, 0),
(357, 35, 2, 8, 3, 'GUEYE', 'Alassane', '17 Avenue du Colonel Roche', 'asoubiaguey@gmail.com', '+33614185940', NULL, NULL, NULL, 0),
(358, 34, 6, 10, 14, 'Dioume ', 'Maguette ', '369 bd national ', 'maguette.dioume@yahoo.fr', '+33611655842', NULL, NULL, NULL, 0),
(359, 2, 2, 14, 11, 'THIOUB ', 'Babacar ', '30 Rue Julien Grimau Saint Etienne du Rouvray ', 'thioubabacar7@gmail.com', '+33602360705', NULL, NULL, NULL, 0),
(360, 23, 1, 10, 2, 'FAYE', 'MODOU', '7 Rue Georges Guynemer apt 63, 80080 Amiens', 'mdfaye026@gmail.com', '+33782723046', NULL, NULL, NULL, 0),
(361, 1, 2, 6, 4, 'Gueye', 'El hadji Malick', '1 place du Hainaut logement 6', 'gueye.elm17@gmail.com', '+33605770341', NULL, NULL, NULL, 0),
(362, 2, 1, 12, 11, 'Thioune', 'Elhadji', '2 Allée des Jardins Arcadie 64600 Anglet', 'amadouthioune@gmail.com', '+33755444030', NULL, NULL, NULL, 0),
(363, 21, 4, 14, 15, 'Samb ', 'Mactar ', '174 rue corot residence bois ardent 50000 Saint-Lô', 'mactar1976@outlook.fr', '+33698495213', NULL, NULL, NULL, 0),
(364, 2, 5, 10, 13, 'KEBE', 'Mayoro', '2 rue Pablo Neruda Appartement 005', 'mayorokebe@hotmail.fr', '+33768324527', NULL, NULL, NULL, 0),
(365, 21, 1, 11, 2, 'NDIAYE ', 'Ousmane', '6, rue des capucins 76700 HARFLEUR ', 'ousmania2001@yahoo.fr', '+33782915083', NULL, NULL, NULL, 0),
(366, 23, 2, 7, 1, 'MBENGUE', 'Adjia Bineta', '43 RUE DU 8E BCP', 'adjiabinetambengue@gmail.com', '+33752723427', NULL, NULL, NULL, 0),
(367, 2, 5, 12, 2, 'Kaba', 'Mariama', '114 Rue Joseph Hue B071 Deville les Rouen 76250', 'kaba_mariama@yahoo.com', '+33628046168', NULL, NULL, NULL, 0),
(368, 2, 2, 10, 11, 'FALL', 'Khadim', '', 'khadimlotsant@gmail.com', '+33667606593', NULL, NULL, NULL, 0),
(369, 2, 1, 10, 3, 'Touré', 'Mame Bousso', '21 Avenue de Caen 76100 Rouen', 'mameboussotoure.mbt@gmail.com', '+33752917232', NULL, NULL, NULL, 0),
(370, 2, 2, 7, 4, 'DIOUF', 'Mouhamadou', '35 rue du maréchal juin', 'Mouhamadou.diouf@etu.univ-rouen.fr', '+33695147238', NULL, NULL, NULL, 0),
(371, 2, 2, 7, 22, 'Ba', 'Mamadou', '13 Boulevard André siegfried Mont saint Aignan  76130', 'mouhamedba49@gmail.com', '+33753921950', NULL, NULL, NULL, 0),
(372, 23, 2, 7, 19, 'Mbacke', 'Baye cheikh khady', '20 rue de noyon ', 'bayecheikh.bachire@gmail.com', '+33758587168', NULL, NULL, NULL, 0),
(373, 23, 1, 10, 2, 'Ndiaye ', 'Pape Cheikh', '7 allée des riez, Amiens', 'cheikhbayefcb@hotmail.fr', '+33753692580', NULL, NULL, NULL, 0),
(374, 49, 2, 5, 10, 'Sene', 'Astou Siga', '18 rue Jean vast Fjt', 'astousigasene@gmail.com', '+33768958741', NULL, NULL, NULL, 0);
INSERT INTO `personne` (`id`, `dahira_id`, `statut_id`, `diplome_id`, `domaine_id`, `nom`, `prenom`, `adresse`, `email`, `telephone`, `profession`, `entreprise`, `password`, `is_deleted`) VALUES
(375, 1, 2, 5, 7, 'Diouf', 'Yacine', '8 Rue Emile loubat 59300', 'yaciinee41@gmail.com', '+33651197080', NULL, NULL, NULL, 0),
(376, 1, 2, 8, 8, 'Mboup', 'Malick', '83 c rue Roger salengro ', 'malick901@hotmail.fr', '+33637688891', NULL, NULL, NULL, 0),
(377, 1, 2, 8, 11, 'Diouf', 'Mouhamed Moustapha ', '8 rue Emile Loubat ', 'mouhataphadiouf@gmail.com', '+33753773225', NULL, NULL, NULL, 0),
(378, 1, 2, 10, 11, 'SECK', 'Oumar', '2 rue du chemin Vert résidence Jules Mousseron BAT E009 ', 'seck.oumar@yahoo.fr', '+33768591398', NULL, NULL, NULL, 0),
(379, 21, 2, 7, 22, 'Ndiaye', 'Mouhamadou Mady', '124 rue jules lecesne ', 'mouhamadoumadyndiaye@hotmail.fr', '+33751524806', NULL, NULL, NULL, 0),
(380, 23, 2, 1, 2, 'Ndiaye ', 'El hadji Abdou', '646,rue de Cagny 80088 Amiens', 'elhadjabdoumbamba13@gmail.com', '+33758882360', NULL, NULL, NULL, 0),
(381, 23, 2, 7, 1, 'Sougou', 'Fatou kiné', '2 rue saint fiacre amiens', 'Kinishsougou@gmail.com', '+33752897355', NULL, NULL, NULL, 0),
(382, 2, 1, 6, 11, 'Gaye', 'Alimatou', '17 avenue de la mare aux daims Batiment C , appartement C203', 'alimatougaye98@gmail.com', '+33766839063', NULL, NULL, NULL, 0),
(383, 21, 2, 6, 11, 'Sarr', 'Sokhna aicha', '135 Rue Jules Lecesne ', 'sokhnaaichasarr@gmail.com', '+33659599100', NULL, NULL, NULL, 0),
(384, 2, 2, 8, 19, 'LO', 'Baye Aliou', '11 Boulevard Siegfried', 'lobaye2011@gmail.com', '+33605848304', NULL, NULL, NULL, 0),
(385, 22, 2, 11, 1, 'Dieng', 'Cheikhou', '33 rue de la Haie vigne', 'Cheikhououmar.dien23@em-normandie.fr', '+33656879907', NULL, NULL, NULL, 0),
(386, 2, 2, 7, 19, 'Seye', 'Ndiolle', '53 boulevard andré siegfried 76130 Mont-saint-aignan', 'ndiolleseye@gmail.com', '+33615319683', NULL, NULL, NULL, 0),
(387, 21, 1, 10, 12, 'Gueye ', 'Modou ', '', 'gueyemodou08@yahoo.fr', '+33675788147', NULL, NULL, NULL, 0),
(388, 2, 2, 8, 22, 'FALL', 'Kharachi', '2 Rue Pablo Neruda', 'kharachi27@gmail.com', '+33671358091', NULL, NULL, NULL, 0),
(389, 1, 2, 8, 3, 'THIAM', 'Mamadou Moustapha Mbacke', '47 Avenue Saint Roch 59300 Valenciennes ', 'moustaphathiam27@gmail.com', '+33780848590', NULL, NULL, NULL, 0),
(390, 1, 2, 7, 3, 'DIOP', 'Abdoulaye', '8 Rue Emile Loubat, Résidence Jules Marmottan, Appt 324', 'diop99abdoulaye@gmail.com', '+33769104909', NULL, NULL, NULL, 0),
(391, 1, 2, 10, 11, 'Seck', 'Abdoulaye', 'Rue du chemin vert ', 'abdoulayeseck1994@yahoo.fr', '+33754284410', NULL, NULL, NULL, 0),
(392, 1, 2, 7, 3, 'Diaw', 'Mouhamed lamine', '1 place du Hainaut', 'diawameth0097@gmail.com', '+33658085140', NULL, NULL, NULL, 0),
(393, 1, 2, 7, 11, 'NGOM', 'Baye Khaly ', '8 rue Emile loubat appt 226', 'bkngom@gmail.com', '+33755851575', NULL, NULL, NULL, 0),
(394, 1, 1, 10, 7, 'SYLLA', 'adama', '98 Rue Jean Jaures, Apt A 33', 'ibrahima.ibzo.sylla@gmail.com', '+33770469091', NULL, NULL, NULL, 0),
(395, 23, 3, 14, 2, 'MBENGUE', 'Serigne Abdou Khaffor', 'Chemin de Vauvoix Batiment LE TAILLIS APPT.9 80080 AMIENS ', 'khafmbengue806@gmail.com', '+33753030304', NULL, NULL, NULL, 0),
(396, 1, 2, 7, 4, 'Fall', 'Soxna Ayda', '17 rue du profond sens 59300 Valenciennes ', 'soxnaaydafall@gmail.com', '+33614313451', NULL, NULL, NULL, 0),
(397, 1, 2, 10, 11, 'Fall', 'Mbacke', '02 Rue gromaire ', 'mbackedjilo03@gmail.com', '+33605995211', NULL, NULL, NULL, 0),
(398, 1, 2, 6, 3, 'DIEYE', 'Khadim', '67 avenue albert 1er', 'khadimdieye97@gmail.com', '+33755307615', NULL, NULL, NULL, 0),
(399, 1, 2, 7, 11, 'Fall', 'Cheikh Ahmet tidiane', '74 rue du Rempart ', 'atfalll96@gmail.com', '+33752973469', NULL, NULL, NULL, 0),
(400, 1, 2, 7, 6, 'Gueye', 'Aladji saliou laye', '5 Rue Abel de Pujol ', 'salioulaye3@gmail.com', '+33699490820', NULL, NULL, NULL, 0),
(401, 1, 5, 10, 7, 'Sow', 'Yaya', '4, rue des godets Valenciennes ', 'yayasow100@gmail.com', '+33758758370', NULL, NULL, NULL, 0),
(402, 1, 2, 7, 3, 'Niang', 'Ahmadou Khadim', '41 rue du Rempart ', 'niangahmadoukhadim@gmail.com', '+33752877455', NULL, NULL, NULL, 0),
(403, 1, 2, 10, 3, 'DIOUF', 'Aminata', '67 Rue de Famars 59300 Valenciennes ', 'aminaa.juuf@gmail.com', '+33621208792', NULL, NULL, NULL, 0),
(404, 1, 1, 10, 11, 'SECK', 'Ibrahima ', '8 Rue Simon Leboucq appartement 51', 'p.ibrahima.seck@gmail.com', '+33751033340', NULL, NULL, NULL, 0),
(405, 1, 2, 6, 21, 'Sylla', 'Nabil Moustapha ', '174 rue du Chemin Vert Aulnoy-lez-Valenciennes ', 'mabylsylla@gmail.com', '+33621789799', NULL, NULL, NULL, 0),
(406, 21, 2, 10, 10, 'Diop', 'Absa', '29 rue labédoyère 76600 Le Havre', 'diop.absa@outlook.fr', '+33614120404', NULL, NULL, NULL, 0),
(407, 1, 5, 10, 11, 'FAYE ', 'Daouda ', '3 allée pierre Bérégovoy ', 'faydaoudaa@gmail.com', '+33754296400', NULL, NULL, NULL, 0),
(408, 21, 2, 6, 2, 'GUEYE', 'MOR', '6 Rue de Soquence, 76600 Le Havre ', 'morgueye21@gmail.com', '+33766898928', NULL, NULL, NULL, 0),
(409, 21, 2, 8, 2, 'Touré', 'Mountakha', '36 rue Boris Vian', 'mountakha1705@gmail.com', '+33758916344', NULL, NULL, NULL, 0),
(410, 21, 2, 7, 19, 'SEYE', 'Mouhamadou Falilou', '36 rue Boris Vian, 76610 Le Havre', 'fallouseye999@gmail.com', '+33751308085', NULL, NULL, NULL, 0),
(411, 21, 1, 14, 21, 'Tine', 'Ibrahima', '26rue du docteur lamaze 76600', 'ibrahimatine09@gmail.com', '+33752587557', NULL, NULL, NULL, 0),
(412, 21, 2, 5, 21, 'Diop ', 'Sokhna Maye ', '5 rue docteur lecadre ', 'Sokhnamayediop5@gmail.com', '+33624373362', NULL, NULL, NULL, 0),
(413, 23, 1, 5, 8, 'Gningue', 'Demba', '7 rue Georges Guynemer 80080', 'gning29@hotmail.com', '+33615416595', NULL, NULL, NULL, 0),
(414, 23, 2, 8, 10, 'Mbacke', 'Abdou Lahad', '1 allée du Bastion de Saint Paul, 80080 Amiens', 'mbackeabdoulahad70@gmail.com', '+33758871992', NULL, NULL, NULL, 0),
(415, 23, 5, 8, 13, 'Moreira', 'Alexis', '30,Rue vulfran warmé', 'lexical17@gmail.com', '+33767903126', NULL, NULL, NULL, 0),
(416, 2, 1, 4, 15, 'Gueye', 'Oumy', 'Rue Henri Gadeau de Kerville apt 89 esci', 'oumypene@yahoo.fr', '+33679331646', NULL, NULL, NULL, 0),
(417, 23, 2, 8, 12, 'Ndiaye ', 'Mame Fatou ', '15,route de Rouen 80000 Amiens ', 'ndiayemamefatou46@gmail.com', '+33753757792', NULL, NULL, NULL, 0),
(418, 21, 2, 10, 2, 'Mbacke', 'Elhadji Falilou', '76 rue Jean Jacques Rousseau ', 'falilou-mbacke@outlook.com', '+33743304909', NULL, NULL, NULL, 0),
(419, 23, 2, 6, 10, 'Kourouma', 'Mouhamadou Rassouloulahi', '20 rue le Mattre ', 'mouhamadou.kourouma@outlook.com', '+33782857646', NULL, NULL, NULL, 0),
(420, 1, 2, 7, 12, 'Thiam ', 'Abdou Khadre Mbacke ', '174 rue du Chemin Vert Valenciennes ', 'abdoukhadre017@gmail.com', '+33751149237', NULL, NULL, NULL, 0),
(421, 1, 2, 5, 12, 'NDIAYE', 'Massamba', '34 rue Védrines', 'ndiayemassamba604@gmail.com', '+33753223751', NULL, NULL, NULL, 0),
(422, 23, 2, 10, 12, 'Ndiaye', 'Cheikh ibrahima ', '20 rue de noyon', 'ndyecheikh@gmail.com', '+33668186555', NULL, NULL, NULL, 0),
(423, 21, 1, 7, 8, 'Ngom', 'Ahmadou bamba', '24 RUE RENE BAHEUX', 'khadimbamba4@hotmail.com', '+33695571955', NULL, NULL, NULL, 0),
(424, 2, 1, 14, 3, 'Coulibaly', 'Djibril', '257 rue Garibaldi 76300 Sotteville-lès-Rouen', 'mbasa1@hotmail.fr', '+33695560744', NULL, NULL, NULL, 0),
(425, 49, 5, 4, 8, 'Sene', 'Abdoulaye', '2 Rue Rabelais 27000 Evreux', 'layesene313@gmail.com', '+33605572309', NULL, NULL, NULL, 0),
(426, 2, 1, 10, 11, 'Faye', 'Abdoulaye', '30 rue du bois des chanoines 27370 La Saussaye ', 'aabdoulayefaye@gmail.com', '+33676987858', NULL, NULL, NULL, 0),
(427, 21, 1, 7, 15, 'FALL usage NDIAYE', 'Fatou MBACKE ', '6, Rue des Capucins', 'ndiaye.ndiaye.fatou11@yahoo.fr', '+33621891891', NULL, NULL, NULL, 0),
(428, 49, 1, 14, 3, 'Diack', 'Babacar', '18 rue marinière rira 27000Evreux chez fall abdou appt411', 'mbayediack2011@gmail.com', '+33762635292', NULL, NULL, NULL, 0),
(429, 49, 1, 14, 2, 'Diatta ', 'ousmane ', '3 rue du 8 mai 1945 apt: 36 . 27000 Evreux.  France ', 'ousmanediatta1979@gmail.com', '+33770904570', NULL, NULL, NULL, 0),
(430, 49, 5, 4, 18, 'Gueye ', 'Mouhamadou Mansour ', '18 rue marniere riga 27000 Evreux', 'roumans05@gmail.com', '+33766384610', NULL, NULL, NULL, 0),
(431, 49, 2, 7, 10, 'Tall', 'Serigne', '63 rue Saint Germain App 39', 'serignekassetall@gmail.com', '+33767270196', NULL, NULL, NULL, 0),
(432, 49, 1, 10, 2, 'Ndime', 'El Hadji Moussa', '13 rue Julien Foucaud 27180 Saint Sébastien de Morsent porte numéro 820', 'elhadjimoussandime@yahoo.fr', '+33769816538', NULL, NULL, NULL, 0),
(433, 1, 1, 12, 7, 'NDAO', 'Bada', '34 rue Védrines, Valenciennes', 'Badandao@hotmail.com', '+33684099735', NULL, NULL, NULL, 0),
(434, 49, 2, 7, 19, 'Gaulard', 'Mame diarra', '8 allée des bombyx', 'mame-diarra27@hotmail.fr', '+33659901235', NULL, NULL, NULL, 0),
(435, 2, 2, 5, 12, 'Ndiaye ', 'Cheikh Mbacke', '73 rue du maréchal de lattre de tassigny', 'cheikhmbackbbt@Gmail.com', '+33753300450', NULL, NULL, NULL, 0),
(436, 2, 2, 7, 11, 'Gueye', 'Serigne Saliou', '17 André Siegfried 76130 Mont St Aignan', 'gueyeserignesaliou66@gmail.com', '+33769055122', NULL, NULL, NULL, 0),
(437, 2, 2, 4, 7, 'Seye', 'Khadim Gor', '711 rue de la mare dyel 76460 ', 'seyegor23@hotmail.fr', '+33662036057', NULL, NULL, NULL, 0),
(438, 2, 2, 10, 19, 'Sylla', 'Binta', 'Rouen', 'syllabinta14@gmail.com', '+33698997310', NULL, NULL, NULL, 0),
(439, 2, 1, 4, 15, 'Diouf', 'Ndeye Fatou', '22 Rue Du Général Leclerc 76000 Rouen ', 'nfcoquais@gmail.com', '+33650349266', NULL, NULL, NULL, 0),
(440, 2, 2, 6, 7, 'THIAM', 'Sokhna', '28 rue du madrillet ', 'skhnthiam000@gmail.com', '+33783522342', NULL, NULL, NULL, 0),
(441, 2, 2, 6, 11, 'SENE', 'Mouhamad', '35 rue du marechal juin residence du bois poussin 363', 'amethsenem@gmail.com', '+33751090984', NULL, NULL, NULL, 0),
(442, 2, 2, 7, 12, 'FALL', 'Abdoulahi', '17 avenue de la Mare aux Daims ', 'abdoulahifall02@gmail.com', '+33753671604', NULL, NULL, NULL, 0),
(443, 2, 2, 10, 2, 'Dia', 'Elhadji malick', '35 rue du Maréchal juin mont Saint aignan 76130 ', 'el.malickdia@hotmail.fr', '+33751021811', NULL, NULL, NULL, 0),
(444, 49, 5, 4, 8, 'Seck ', 'Bassirou ', '16 rue chateaubriant 123 27000 Evreux ', 'basseck4@gmail.com', '+33758942652', NULL, NULL, NULL, 0),
(445, 2, 5, 10, 2, 'Faye', 'Mame Diarra Bousso ', '60 avenue de Caen,76100 Rouen', 'diadiabouss@gmail.com', '+33769578934', NULL, NULL, NULL, 0),
(446, 49, 1, 10, 3, 'Kamara', 'Aminata', '13 rue Julien Foucaud 27180 Saint Sébastien de Morsent', 'kamaraaminata2016@gmail.com', '+33605634345', NULL, NULL, NULL, 0),
(447, 49, 5, 4, 19, 'Diatta ', 'Seynabou ', '3 rue du 8 mai 1945 immeuble sureau appt 36', 'seynabousnedai@glail.com', '+33666732507', NULL, NULL, NULL, 0),
(448, 49, 1, 4, 15, 'Bathily ', 'Dicko', '17 rue Michelet 27000 Evreux ', 'dbathily672@gmail.com', '+33669732145', NULL, NULL, NULL, 0),
(449, 49, 1, 1, 2, 'Fall', 'Elhadji madior', 'Rue prosper Mérimée  27000 evreux', 'elhadjimadior.fall@laposte.net', '+33751320726', NULL, NULL, NULL, 0),
(450, 21, 2, 7, 8, 'Djitté', ' Ndeye Siga', '92 rue Hélène ', 'siga300198@gmail.com', '+33755058362', NULL, NULL, NULL, 0),
(451, 21, 2, 5, 22, 'Lo', 'Serigne Modou', '3 rue Louise Michel 76610', 'modoulodaroulo196@gmail.com', '+33605514178', NULL, NULL, NULL, 0),
(452, 20, 2, 8, 11, 'Diop', 'Mohamed ', '1 rue de la Fourche Bailly Romainvilliers 77700 ', 'diopmohamed@hotmail.com', '+33767626243', NULL, NULL, NULL, 0),
(453, 21, 1, 7, 21, 'AGNE', 'Abdoul Aziz', 'adresse abdou', 'aziz.3a@hotmail.fr', '+33760116668', NULL, NULL, NULL, 0),
(454, 20, 2, 6, 11, 'Mbaye', 'Baye cheikh', 'Roubaix ', 'mbayecheikh8593@gmail.vom', '+33753933483', NULL, NULL, NULL, 0),
(455, 20, 2, 6, 11, 'SENE', 'Mamadou ', '8 rue camille saint saëns 59650 ', 'Sene951410@gmail.com', '+33774384645', NULL, NULL, NULL, 0),
(456, 23, 2, 6, 10, 'FALL', 'Mame Bousso', '12 rue pasteur ', 'mameboussofall9@gmail.com', '+33783579892', NULL, NULL, NULL, 0),
(457, 21, 2, 5, 22, 'Diop ', 'Sokhna Maye ', '5 rue docteur lecadre ', 'Smayediop97@gmail.com', '+33624373362', NULL, NULL, NULL, 0),
(458, 1, 2, 7, 3, 'Loum', 'Mame Diarra Bousso', '8 rue Emile Loubat 59300 Famars', 'coumbadiarra99@gmail.com', '+33652027566', NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Structure de la table `statut`
--

DROP TABLE IF EXISTS `statut`;
CREATE TABLE IF NOT EXISTS `statut` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `statut`
--

INSERT INTO `statut` (`id`, `nom`) VALUES
(1, 'Salarié'),
(2, 'Etudiant'),
(3, 'Entrepreneur'),
(4, 'Commerçant'),
(5, 'Ouvrier'),
(6, 'Autre');

-- --------------------------------------------------------

--
-- Structure de la table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `personne_id` int(11) DEFAULT NULL,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`),
  UNIQUE KEY `UNIQ_8D93D649A21BD112` (`personne_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Déchargement des données de la table `user`
--

INSERT INTO `user` (`id`, `personne_id`, `email`, `roles`, `password`, `password_requested_at`, `token`, `last_login`) VALUES
(4, NULL, 'p.ibrahima.seck@gmail.com', 'a:1:{i:0;s:13:\"ROLE_NATIONAL\";}', '$2y$13$zCYBfIvXv19LSJ3WKNOU9OCQIjspKF8iXaPSSUvBQxT0.b5lm/nc.', NULL, NULL, '2021-12-15 23:57:55');

-- --------------------------------------------------------

--
-- Structure de la table `users_api`
--

DROP TABLE IF EXISTS `users_api`;
CREATE TABLE IF NOT EXISTS `users_api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `roles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`roles`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9EDE4F39F85E0677` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Contraintes pour les tables déchargées
--

--
-- Contraintes pour la table `dahira`
--
ALTER TABLE `dahira`
  ADD CONSTRAINT `FK_18DDD7EB6A03EFC5` FOREIGN KEY (`federation_id`) REFERENCES `federation` (`id`),
  ADD CONSTRAINT `FK_18DDD7EBB781A52D` FOREIGN KEY (`dieuwrine_id`) REFERENCES `personne` (`id`);

--
-- Contraintes pour la table `personne`
--
ALTER TABLE `personne`
  ADD CONSTRAINT `FK_FCEC9EF26F859E2` FOREIGN KEY (`diplome_id`) REFERENCES `diplome` (`id`),
  ADD CONSTRAINT `FK_FCEC9EF4272FC9F` FOREIGN KEY (`domaine_id`) REFERENCES `domaine` (`id`),
  ADD CONSTRAINT `FK_FCEC9EFF5ED07D8` FOREIGN KEY (`dahira_id`) REFERENCES `dahira` (`id`),
  ADD CONSTRAINT `FK_FCEC9EFF6203804` FOREIGN KEY (`statut_id`) REFERENCES `statut` (`id`);

--
-- Contraintes pour la table `user`
--
ALTER TABLE `user`
  ADD CONSTRAINT `FK_8D93D649A21BD112` FOREIGN KEY (`personne_id`) REFERENCES `personne` (`id`);
COMMIT;

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