-- phpMyAdmin SQL Dump
-- version 4.7.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Nov 25, 2019 at 07:06 AM
-- Server version: 5.6.40-84.0-log
-- PHP Version: 5.6.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Database: `etshawa8_mhuatmr`
--

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

--
-- Table structure for table `banques`
--

CREATE TABLE `banques` (
  `idbanque` int(10) UNSIGNED NOT NULL,
  `banque` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banques`
--

INSERT INTO `banques` (`idbanque`, `banque`) VALUES
(1, 'BMCI'),
(2, 'SGM'),
(3, 'BAMIS'),
(4, 'BCI'),
(5, 'BADHM'),
(6, 'BMI'),
(7, 'BEA'),
(8, 'ORABANK'),
(9, 'BPM'),
(10, 'BMS'),
(11, 'ATTIJARI BANK'),
(12, 'BADH'),
(13, 'CCP'),
(14, 'CHINGUITY BANK'),
(15, 'BANQUE AL MUAMELAT AS-SAH'),
(16, 'BNM'),
(17, 'BIM');

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

--
-- Table structure for table `carrieres`
--

CREATE TABLE `carrieres` (
  `idcarriere` int(10) UNSIGNED NOT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `date` date DEFAULT NULL,
  `r_n_m_a_p_d` varchar(255) DEFAULT NULL,
  `statut` varchar(255) NOT NULL,
  `observations` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `idcategorie` int(10) UNSIGNED NOT NULL,
  `categorie` varchar(255) DEFAULT NULL,
  `prime` decimal(10,0) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`idcategorie`, `categorie`, `prime`) VALUES
(1, 'CADRE', '4000'),
(2, 'AGENT', '3000'),
(3, 'SECRETAIRE', '3000'),
(4, 'CHAUFFEUR', '2000'),
(5, 'PLANTON', '2000'),
(6, 'AUTRES', '2000'),
(7, 'SECRETAIRE GENERAL', '30000'),
(8, 'CHARGES DE MISSION', '2500'),
(9, 'RESPONSABLE CELLULE REGROUPEMENT DES LOCALITES', '2500'),
(10, 'CONSEILLER', '2500'),
(11, 'INSPECTEUR GENERAL', '25000'),
(12, 'DIRECTEUR GENERAL', '2500'),
(13, 'DIRECTEUR GENERAL ADJOINT', '2000'),
(14, 'DIRECTEUR CENTRAL', '2000'),
(15, 'DELEGUE REGIONAL', '2000'),
(16, 'INSPECTEUR', '2000'),
(17, 'RESPONSABLE DE COMMUNICATION', '2000'),
(18, 'RESPONSABLE CELLULE INFORMATIQUE', '2000'),
(19, 'DIRECTEUR ADJOINT', '15000'),
(20, 'CHEF DE SERVICE', '5000'),
(21, 'CHEF DE DIVISION', '5000');

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

--
-- Table structure for table `conges`
--

CREATE TABLE `conges` (
  `id_conge` int(3) UNSIGNED ZEROFILL NOT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `num_fiche` varchar(255) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `directeur` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `decomptes`
--

CREATE TABLE `decomptes` (
  `iddecompte` int(10) UNSIGNED NOT NULL,
  `date_demande_c` date DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `nni` int(10) UNSIGNED DEFAULT NULL,
  `num_cpte` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` date DEFAULT NULL,
  `date_depart` date DEFAULT NULL,
  `anciennete` int(11) DEFAULT NULL,
  `salaire_m_m` decimal(10,0) DEFAULT NULL,
  `from_details` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `details_decompte`
--

CREATE TABLE `details_decompte` (
  `iddetail_decompte` int(3) UNSIGNED ZEROFILL NOT NULL,
  `tranches` varchar(255) DEFAULT NULL,
  `periodes` varchar(255) DEFAULT NULL,
  `pourcentage` decimal(10,2) DEFAULT NULL,
  `coef` decimal(10,1) DEFAULT NULL,
  `salaire_moyen` decimal(10,2) DEFAULT NULL,
  `montant` decimal(10,2) DEFAULT NULL,
  `mois_preavis` decimal(10,2) DEFAULT NULL,
  `mois_conge` decimal(10,2) DEFAULT NULL,
  `to_decomptes` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `directions`
--

CREATE TABLE `directions` (
  `iddirection` int(10) UNSIGNED NOT NULL,
  `direction` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `directions`
--

INSERT INTO `directions` (`iddirection`, `direction`) VALUES
(1, 'DGBEP'),
(2, 'DGHU'),
(3, 'DR'),
(4, 'DAAF'),
(5, 'CABINET'),
(6, 'IG'),
(7, 'DGATAR'),
(8, 'DEPC');

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

--
-- Table structure for table `divisions`
--

CREATE TABLE `divisions` (
  `iddivision` int(10) UNSIGNED NOT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `division` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `dossier_individuel`
--

CREATE TABLE `dossier_individuel` (
  `iddindividuel` int(10) UNSIGNED NOT NULL,
  `option_prime` int(10) UNSIGNED DEFAULT NULL,
  `matricule` varchar(255) DEFAULT NULL,
  `nom_prenom` varchar(255) DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `matrimoniale` varchar(255) DEFAULT NULL,
  `enfants` int(11) DEFAULT NULL,
  `nni` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `courriel` varchar(255) DEFAULT NULL,
  `postale` varchar(255) DEFAULT NULL,
  `date_recrutement` date DEFAULT NULL,
  `statut` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `categorie` int(10) UNSIGNED DEFAULT NULL,
  `anciennete` int(11) DEFAULT NULL,
  `salaire` decimal(10,0) DEFAULT '0',
  `prime` int(10) UNSIGNED DEFAULT NULL,
  `qty` int(10) UNSIGNED DEFAULT NULL,
  `total` decimal(10,0) DEFAULT NULL,
  `compte` varchar(255) DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  `dossier` varchar(255) DEFAULT NULL,
  `contrat` varchar(255) DEFAULT NULL,
  `photo` varchar(40) DEFAULT NULL,
  `observation` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dossier_individuel`
--

INSERT INTO `dossier_individuel` (`iddindividuel`, `option_prime`, `matricule`, `nom_prenom`, `date_naissance`, `age`, `matrimoniale`, `enfants`, `nni`, `telephone`, `courriel`, `postale`, `date_recrutement`, `statut`, `direction`, `fonction`, `service`, `division`, `categorie`, `anciennete`, `salaire`, `prime`, `qty`, `total`, `compte`, `banque`, `cv`, `dossier`, `contrat`, `photo`, `observation`) VALUES
(2, 1, '1700068', 'EL BETOUL MOCTAR', '2019-10-23', 0, NULL, NULL, '2962840169', NULL, NULL, NULL, '2019-10-23', 1, 4, 47, NULL, NULL, 2, 0, '0', 2, NULL, '0', NULL, NULL, 'd887927b79213461a.pdf', NULL, NULL, NULL, NULL),
(3, 1, '88334B', 'WANE BIRANE', '2019-10-23', 0, 'M', NULL, '8400705759', NULL, NULL, NULL, '2019-10-23', 3, 5, 4, NULL, NULL, 10, 0, '0', 10, NULL, '0', NULL, NULL, '47eccfc6ffcd439fc.pdf', NULL, NULL, NULL, NULL),
(4, 1, '43508Q', 'DJIBRIL IDRISSA GUEYE', '2019-10-23', 0, NULL, NULL, '3860485832', NULL, NULL, NULL, '2019-10-23', 2, 7, 54, NULL, NULL, 2, 0, '0', 2, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, 1, '101318C', 'MOULAY ISMAIL MOULAY EL HACEN', '2019-10-23', 0, NULL, NULL, '4856735875', NULL, NULL, NULL, '2019-10-23', 3, 7, 67, NULL, NULL, 13, 0, '0', 13, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, 1, '043509R', 'AMINATA N\'DIAYE', '2019-10-23', 0, NULL, NULL, '1202369030', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, 1, '097628R', 'SIDI AHMED DEIDA', '2019-10-23', 0, NULL, NULL, '9686405548', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, 1, '084906N', 'AHMED DENNA', '2019-10-23', 0, NULL, NULL, '119085931', NULL, NULL, NULL, '2019-10-23', 1, 2, NULL, NULL, NULL, 20, 0, '0', 20, NULL, '0', NULL, NULL, '48b2b66354a5e441c.pdf', NULL, NULL, NULL, NULL),
(9, 1, '044441E', 'MOHAMED SOUEIDI', '2019-10-23', 0, NULL, NULL, '8457385284', NULL, NULL, NULL, '2019-10-23', NULL, 5, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, 1, '072094M', 'MAIMOUNATOU MED SIDIYA', '2019-10-23', 0, NULL, NULL, '4114331728', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, 1, '097631U', 'ANDERRAHMANE EL MOCTAR', '2019-10-23', 0, NULL, NULL, '596119709', NULL, NULL, NULL, '2019-10-23', 2, 1, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'b06c0abba0b40c95a.pdf', NULL, NULL, NULL, NULL),
(12, 1, '093219Z', 'MOHAMED EL MOCTAR ZAMEL', '2019-10-23', 0, NULL, NULL, '8063906142', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f2a15e8989c34408b.pdf', NULL, NULL, NULL, NULL),
(13, 1, '077620T', 'HALIMA CAMARA', '2019-10-23', 0, NULL, NULL, '5623272458', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '96d393e36eefe9f07.pdf', NULL, NULL, NULL, NULL),
(14, 1, '058946W', 'MOHAMED SALEM TAKIOULLAH', '2019-10-23', 0, NULL, NULL, '4484157323', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, 1, '089073S', 'MOHAMED KONE', '2019-10-23', 0, NULL, NULL, '7212305021', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, 1, '084256G', 'CHEIKH YOUBA ZEINE', '2019-10-23', 0, NULL, NULL, '7299059493', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, 1, '089086G', 'JIDDOU HJIBOU', '2019-10-23', 0, NULL, NULL, '120935042', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '29c62190a15dc7bc9.pdf', NULL, NULL, NULL, NULL),
(18, 1, '102790C', 'ABDOU MOHAMED MAHMOUD ABDELLAH', '2019-10-23', 0, NULL, NULL, '3463215930', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'df48189bf5562ed57.pdf', NULL, NULL, NULL, NULL),
(19, 1, '097619G', 'FATIMETOU MEIMOUNA ENNAHOUI', '2019-10-23', 0, NULL, NULL, '6346292222', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '5eaa58a86b30a99c7.pdf', NULL, NULL, NULL, NULL),
(20, 1, '054371Y', 'BOUBACAR BA', '2019-10-23', 0, NULL, NULL, '6899278649', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, 1, '072093L', 'CHEIKH BABOU MED BABOU', '2019-10-23', 0, NULL, NULL, '4785506112', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, 1, '097621J', 'MED MAHMOUD MBAYE', '2019-10-23', 0, NULL, NULL, '3317748716', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'b15eaef6d81195a2d.pdf', NULL, NULL, NULL, NULL),
(23, 1, '101271B', 'LY OUMAR', '2019-10-23', 0, NULL, NULL, '3225551030', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, 1, '089653Y', 'FATIMETOU MED ABDALLAHI', '2019-10-23', 0, NULL, NULL, '8616447339', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, 1, '103181C', 'YAHYA KANE', '2019-10-23', 0, NULL, NULL, '5747345061', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '4ccd8af6fbb8d3435.pdf', NULL, NULL, NULL, NULL),
(26, 1, '091721W', 'CHEIKH AHMEDOU ELMINE EL ABASS', '2019-10-23', 0, NULL, NULL, '4237270886', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'ff881a7eafbc5dc5a.pdf', NULL, NULL, NULL, NULL),
(27, 1, '07615C', 'MARIEM M MED LEMINE', '2019-10-23', 0, NULL, NULL, '5868366626', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, 1, '097630T', 'SIDI AHMED MED LEMINE', '2019-10-23', 0, NULL, NULL, '9384946523', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, 1, '084168L', 'MED MAHMOUD HAMDI AMAR', '2019-10-23', 0, NULL, NULL, '6727971622', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f3bae230a8329edc0.pdf', NULL, NULL, NULL, NULL),
(30, 1, '084897D', 'MALECK VALL', '2019-10-23', 0, NULL, NULL, '1661636967', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '44b476e7b79253fc1.pdf', NULL, NULL, NULL, NULL),
(31, 1, '089214W', 'HOUSSEIN SIDI DIT (HOUMEINI)', '2019-10-23', 0, NULL, NULL, '1466222416', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '3f0f10530117424c8.pdf', NULL, NULL, NULL, NULL),
(32, 1, '097613A', 'MAAOUYA MED KHALED', '2019-10-23', 0, NULL, NULL, '3212515841', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'cee7d301dce58c40d.pdf', NULL, NULL, NULL, NULL),
(33, 1, '097624M', 'IBRAHIMA YAHYA NDONGO', '2019-10-23', 0, NULL, NULL, '6622326286', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, 1, '102787Z', 'MEINA SIDINA', '2019-10-23', 0, NULL, NULL, '1251743679', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, 1, '103096K', 'MED MOUSTAPHA DEINE', '2019-10-23', 0, NULL, NULL, '7865101344', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '60ff0692eea0cfe46.pdf', NULL, NULL, NULL, NULL),
(36, 1, '103089C', 'EBOUBEKRIN YAHAYA', '2019-10-23', 0, NULL, NULL, '5061532751', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, 1, '043513W', 'SYLLY GUELADIO DIABIRA', '2019-10-23', 0, NULL, NULL, '5498576727', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, 1, '084909R', 'MARIEM BAMBA', '2019-10-23', 0, NULL, NULL, '429778677', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '8d8485fdf082e31ec.pdf', NULL, NULL, NULL, NULL),
(39, 1, '103020C', 'WELE ABDOULLAHI', '2019-10-23', 0, NULL, NULL, '8775700872', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '48bde191ce2ffd842.pdf', NULL, NULL, NULL, NULL),
(40, 1, '089153E', 'SIDI ABDOULLAH OULD MED LEZIZ', '2019-10-23', 0, NULL, NULL, '1692397607', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '49a81279a68824893.pdf', NULL, NULL, NULL, NULL),
(41, 1, '097617E', 'ELMECHERI BEDA', '2019-10-23', 0, NULL, NULL, '5628224696', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, 1, '099901M', 'MOHAMED ABDELLAHI MED LEMINE CHIGZ', '2019-10-23', 0, NULL, NULL, '3019551413', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'e0ea0c35f83ec4fba.pdf', NULL, NULL, NULL, NULL),
(43, 1, '066736N', 'MOUSSA MAMADOU SEIDOU', '2019-10-23', 0, NULL, NULL, '6715057122', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, 1, '072090H', 'MOHAMEDOU OULD AHMEDOU OULD SIDI AHMED', '2019-10-23', 0, NULL, NULL, '3386043991', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(45, 1, '084907P', 'BRAHIM EL KHALIL MED SID\'AMED', '2019-10-23', 0, NULL, NULL, '6561687512', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'a342ee7e0c0f35595.pdf', NULL, NULL, NULL, NULL),
(46, 1, '091719T', 'YEHEFDOU CHERIFE', '2019-10-23', 0, NULL, NULL, '1809488829', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, 1, '103085Y', 'ZEINEBOU MED KEYNA', '2019-10-23', 0, NULL, NULL, '3877328621', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, 1, '089652X', 'SIDI MED BECHIR', '2019-10-23', 0, NULL, NULL, '8314619326', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '4eda5516dd0842adb.pdf', NULL, NULL, NULL, NULL),
(49, 1, '097620H', 'ELY OULD EL MOCTAR', '2019-10-23', 0, NULL, NULL, '1739874160', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '52bdb5d0f937bfa53.pdf', NULL, NULL, NULL, NULL),
(50, 1, '043511T', 'CHERIF ABDOUL BA', '2019-10-23', 0, NULL, NULL, '2198315172', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'dec9075fc1b60b633.pdf', NULL, NULL, NULL, NULL),
(51, 1, '054510Z', 'AHMED OULD DIAH', '2019-10-23', 0, NULL, NULL, '9977540087', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '0a1a23294a989b3f9.pdf', NULL, NULL, NULL, NULL),
(54, 1, '071934N', 'AHMEDOU OULD AHMEDOU BABA', '2019-10-23', 0, NULL, NULL, '477773695', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f43c7df448882b0aa.pdf', NULL, NULL, NULL, NULL),
(55, 1, '084910S', 'MOHAMED EL HASSEN EL MOKHTAR', '2019-10-23', 0, NULL, NULL, '784934671', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, 1, '1200234', 'Aminetou Cheikh', '2019-10-23', 0, NULL, NULL, '7574125788', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(57, 1, '071933M', 'BRAHIM AININA', '2019-10-23', 0, NULL, NULL, '7434033247', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '43a25ff6c3cad1502.pdf', NULL, NULL, NULL, NULL),
(58, 1, '097616D', 'MOHAMED YEDHALI HASSEN', '2019-10-23', 0, NULL, NULL, '2854381947', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(59, 1, '072089G', 'FATIMETOU CHEIKH MELEININE', '2019-10-23', 0, NULL, NULL, '7122018100', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'ebc8ba4eba9f12746.pdf', NULL, NULL, NULL, NULL),
(60, 1, '072091J', 'BABA OULD CHEIKH', '2019-10-23', 0, NULL, NULL, '6665581496', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(61, 1, '099844A', 'FATIMETOU MED ABDELLAHI KHALIFA', '2019-10-23', 0, NULL, NULL, '9271678653', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'cd8873d8abbb0d0b4.pdf', NULL, NULL, NULL, NULL),
(62, 1, '014008A', 'AHMEDOU OULD MED YAHYA', '2019-10-23', 0, NULL, NULL, '53988552', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '484dde6cf81091695.pdf', NULL, NULL, NULL, NULL),
(63, 1, '018501J', 'AMADOU MOCTAR ABDELAYE SOW', '2019-10-23', 0, NULL, NULL, '8133156091', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(64, 1, '043514X', 'MOUSSA SIDIBE', '2019-10-23', 0, NULL, NULL, '764028552', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(65, 1, '046585F', 'DIENG PAPA DAOUDA', '2019-10-23', 0, NULL, NULL, '6037603981', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(66, 1, '054514D', 'THIAM BABACAR', '2019-10-23', 0, NULL, NULL, '4485381269', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '4c6578fd8ddf5c1a2.pdf', NULL, NULL, NULL, NULL),
(67, 1, '054515E', 'EBY MOHAMED BEWA', '2019-10-23', 0, NULL, NULL, '9360887419', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(68, 1, '054517G', 'N\'DIAYE BOUBACAR', '2019-10-23', 0, NULL, NULL, '7515570768', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(69, 1, '084916Z', 'AZIZ MOHAMED ABDELLAHI', '2019-10-23', 0, NULL, NULL, '4355013366', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(70, 1, '089574M', 'AHMED MOHAMED EL MOUSTAPHA BOYA', '2019-10-23', 0, NULL, NULL, '5776805222', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'b88e26a9100a85bc6.pdf', NULL, NULL, NULL, NULL),
(71, 1, '091720U', 'MOHAMED BRAHIM BOUBACAR', '2019-10-23', 0, NULL, NULL, '8502229936', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'd019424ca9dcf58a2.pdf', NULL, NULL, NULL, NULL),
(72, 1, '097612Z', 'MOHAMED AHMED SALEM MOULOUD', '2019-10-23', 0, NULL, NULL, '8285081177', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(73, 1, '097614B', 'MINT DEN MOHAMEDEN', '2019-10-23', 0, NULL, NULL, '5119532786', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(74, 1, '097625N', 'EL KHADIM AHMEDOU', '2019-10-23', 0, NULL, NULL, '7104809621', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'a664f1822d6149e06.pdf', NULL, NULL, NULL, NULL),
(75, 1, '097626P', 'MOHAMEDOU ZEINE HAMADI', '2019-10-23', 0, NULL, NULL, '7854827104', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '3b899788af0f1ff90.pdf', NULL, NULL, NULL, NULL),
(76, 1, '097629S', 'MOHAMED SALEM ELY', '2019-10-23', 0, NULL, NULL, '6343242251', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '40bbba8f483c62e1a.pdf', NULL, NULL, NULL, NULL),
(77, 1, '102450H', 'DIAGANA ISSAGHA', '2019-10-23', 0, NULL, NULL, '8429064970', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(78, 1, '102999E', 'MOUSSA GEYE', '2019-10-23', 0, NULL, NULL, '2893091443', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(79, 1, '102789B', 'IDRISSA TIRERA', '2019-10-23', 0, NULL, NULL, '6941676476', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(80, 1, '084918B', 'MOHAMED AMAR MOHAMEDEN', '2019-10-23', 0, NULL, NULL, '372331591', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(81, 1, '103088B', 'MOHAMEDOU FALILOU SY', '2019-10-23', 0, NULL, NULL, '7030446220', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(82, 1, '103087A', 'DINEG DJIBY HAROUNA', '2019-10-23', 0, NULL, NULL, '444482940', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(83, 1, '074378U', 'AHMED OULD SALECK', '2019-10-23', 0, NULL, NULL, '8821715635', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(84, 1, '084915Y', 'MOUJTABA MED SALECK', '2019-10-23', 0, NULL, NULL, '4551539634', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(85, 1, '089071Q', 'DICKO ABDOUL', '2019-10-23', 0, NULL, NULL, '2293861724', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '233c629ab06c9a6d9.pdf', NULL, NULL, NULL, NULL),
(86, 1, '103156A', 'ABDELLAHI KHATAR SIDI CHEIKH', '2019-10-23', 0, NULL, NULL, '843962081', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(87, 1, '104667S', 'NANA SELAMA LEBEID', '2019-10-23', 0, NULL, NULL, '4198066008', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '79ef9564b0c8477f2.pdf', NULL, NULL, NULL, NULL),
(88, 1, '097627Q', 'MOHAMED MAHMOUD TOURAD AHMED', '2019-10-23', 0, NULL, NULL, '7416041202', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '909e3630de9af68c3.pdf', NULL, NULL, NULL, NULL),
(89, 1, '041136M', 'MOHAMED EL MOCKTAR MOHAMED', '2019-10-23', 0, NULL, NULL, '822595309', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(90, 1, '049674S', 'SIDI ABD MOHAMED SALEH DIT/ JEKANI', '2019-10-23', 0, NULL, NULL, '2151714138', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(91, 1, '057210J', 'MOHAMED LAGHDAF MED ELY', '2019-10-23', 0, NULL, NULL, '7712553615', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'e71efd286d2fe2b63.pdf', NULL, NULL, NULL, NULL),
(92, 1, '057360X', 'SY ABDOUL', '2019-10-23', 0, NULL, NULL, '3236499770', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '30bdd3b96391fbbe1.pdf', NULL, NULL, NULL, NULL),
(93, 1, '076008R', 'AISSATA NIANG', '2019-10-23', 0, NULL, NULL, '748663655', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'de701b92b277ee5d6.pdf', NULL, NULL, NULL, NULL),
(94, 1, '072092K', 'BA ABOU GATTA', '2019-10-23', 0, NULL, NULL, '5467754007', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '3467bb3f489a0e952.pdf', NULL, NULL, NULL, NULL),
(95, 1, '097623L', 'AMINATA DAMBA BANDIA', '2019-10-23', 0, NULL, NULL, '1973530670', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f7fb1e10bb71d26d3.pdf', NULL, NULL, NULL, NULL),
(96, 1, '1700088', 'OUMAR MAM SEIDOU LY', '2019-10-23', 0, NULL, NULL, '6324551030', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(97, 1, '1700181', 'MED LEMINE ALIOUNE SIDI EL KORY', '2019-10-23', 0, NULL, NULL, '9050217272', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(98, 1, '1700003', 'AHMED SALEM BOUKHARI', '2019-10-23', 0, NULL, NULL, '2716268012', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(99, 1, '1700004', 'AICHA CHERIF HAJI', '2019-10-23', 0, NULL, NULL, '297169104', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(100, 1, '1700005', 'ALY SAMBA', '2019-10-23', 0, NULL, NULL, '7432295230', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(101, 1, '1700008', 'DJBRIL BOUCAR', '2019-10-23', 0, NULL, NULL, '2728647928', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(102, 1, '1700010', 'MOHAMED MAHMOUD CHEIN', '2019-10-23', 0, NULL, NULL, '6787701489', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(103, 1, '1700013', 'MOHAMED MAHMOUD OULD AHMED', '2019-10-23', 0, NULL, NULL, '6202568195', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(104, 1, '1700163', 'CHEIKH OULD DAADA', '2019-10-23', 0, NULL, NULL, '3102246047', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(105, 1, '1700018', 'MOUSTAPHA AHMED DIODIA', '2019-10-23', 0, NULL, NULL, '1420807307', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '20f4928d291ce5fbb.pdf', NULL, NULL, NULL, NULL),
(106, 1, '1700019', 'SALKA MASAMBA FALL', '2019-10-23', 0, NULL, NULL, '2586962744', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '8f8b0657731904a95.pdf', NULL, NULL, NULL, NULL),
(107, 1, '700509', 'BOCAR THIALEL DIALO', '2019-10-23', 0, NULL, NULL, '1521073103', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(108, 1, '700510', 'MINI GUENNA DIEH', '2019-10-23', 0, NULL, NULL, '9682522347', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(109, 1, '700511', 'MARIEM KANE', '2019-10-23', 0, NULL, NULL, '213040713', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(112, 1, '700516', 'EBOUBECRINE YAHYA M\'haimid', '2019-10-23', 0, NULL, NULL, 'NULL', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(113, 1, '700526', 'ZEINEBOU MOUSSA DIALLO', '2019-10-23', 0, NULL, NULL, '6120588936', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '5ede72a22004f261a.pdf', NULL, NULL, NULL, NULL),
(114, 1, '700531', 'IBRA AMADOU SY', '2019-10-23', 0, NULL, NULL, '6697794905', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(115, 1, '700533', 'BARKA MAMADOU SALL', '2019-10-23', 0, NULL, NULL, '5868408239', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(116, 1, '1700017', 'MOHAMED VADEL DAH BOWBA', '2019-10-23', 0, NULL, NULL, '5731153045', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '68c7d5120f04b264f.pdf', NULL, NULL, NULL, NULL),
(117, 1, '700548', 'BOUDY MAMADOU N\'DIAYE', '2019-10-23', 0, NULL, NULL, '2032845006', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'd49e4e968b8f76986.pdf', NULL, NULL, NULL, NULL),
(118, 1, '700365', 'MOHAMED DOWFA LOPEZ', '2019-10-23', 0, NULL, NULL, '6595072681', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '6ebb53e75bbda5a20.pdf', NULL, NULL, NULL, NULL),
(119, 1, '1700020', 'ABDOURAHIM KOWRY SY', '2019-10-23', 0, NULL, NULL, '8539714228', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '3ffb8a2cb874ebb4b.pdf', NULL, NULL, NULL, NULL),
(120, 1, '1700022', 'BABA BEIDE EL MOCTAR', '2019-10-23', 0, NULL, NULL, '4110279068', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'a208a993c00a78751.pdf', NULL, NULL, NULL, NULL),
(121, 1, '1700023', 'BEIBATT BOUCHAME BOUCHAME', '2019-10-23', 0, NULL, NULL, '6594700492', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '2fc506883d2f320a0.pdf', NULL, NULL, NULL, NULL),
(122, 1, '1700026', 'HOULEYE M\'BERLABA NIANG', '2019-10-23', 0, NULL, NULL, '7821647866', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '29b97fe79fa0be1f7.pdf', NULL, NULL, NULL, NULL),
(124, 1, '1700028', 'MOUSSA AHMED MOHAMEDOU', '2019-10-23', 0, NULL, NULL, '3751381978', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '01b56540db5f14f4a.pdf', NULL, NULL, NULL, NULL),
(125, 1, '1700029', 'EL MOUSTAPHA OULEIDHOM SGHAIER', '2019-10-23', 0, NULL, NULL, '2856051608', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'eea3150b4cca22fa9.pdf', NULL, NULL, NULL, NULL),
(126, 1, '700519', 'KHEDAJA AHMED ELMEOULOUD', '2019-10-23', 0, NULL, NULL, '6172505470', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(127, 1, '700559', 'ABDARAHMANE MALICK MALICK', '2019-10-23', 0, NULL, NULL, '8720148584', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(128, 1, '1700036', 'BRAHIM BOBACAR YARIM', '2019-10-23', 0, NULL, NULL, '9792406372', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(129, 1, '700573', 'FATIMETOU MOHAMED  LEMIN SABAR', '2019-10-23', 0, NULL, NULL, '1170655268', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '57156583750b31e83.pdf', NULL, NULL, NULL, NULL),
(130, 1, '1700037', 'CHEIKH BRAHIM M\'bodj', '2019-10-23', 0, NULL, NULL, '202069237', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(131, 1, '1700038', 'CHEIKH MOHAMEDEN VALL OBODJE', '2019-10-23', 0, NULL, NULL, '7786523778', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(132, 1, '1700040', 'HACHEM BRAHIM BOUBACAR', '2019-10-23', 0, NULL, NULL, '6649485704', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(133, 1, '1700042', 'LEGHWEYA CHEIKH SADE', '2019-10-23', 0, NULL, NULL, '6851548829', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(134, 1, '1700045', 'M\'BAYE SIKHOU CISSOKO', '2019-10-23', 0, NULL, NULL, '6395580153', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(135, 1, '1700051', 'MOHAMED SID\'AHMED EL BECHIR', '2019-10-23', 0, NULL, NULL, '5510281135', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(136, 1, '1700052', 'MAOULOUD EL ATIGH SALICK', '2019-10-23', 0, NULL, NULL, '3833220005', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(137, 1, '1700057', 'SIDI MOHAMED MAHMOUD SALEM', '2019-10-23', 0, NULL, NULL, '2606140226', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(138, 1, '1700058', 'SIDI GUEINE BOUGNEIBRE', '2019-10-23', 0, NULL, NULL, '7826746186', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(139, 1, '1700061', 'AICHETOU MOHAMED ABDALLAHI EL HASSEN', '2019-10-23', 0, NULL, NULL, '786752451', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f667b6b670ec0990c.pdf', NULL, NULL, NULL, NULL),
(140, 1, '1700063', 'AMINETOU BOUNA KENKO', '2019-10-23', 0, NULL, NULL, '1931613090', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '1ed9fc9993412768d.pdf', NULL, NULL, NULL, NULL),
(141, 1, '1700067', 'DAH BRAHIM BOUBACAR', '2019-10-23', 0, NULL, NULL, '6652302390', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(142, 1, '1700069', 'FATIMETOU SIDI EL MOKHTAR M\'BAREK', '2019-10-23', 0, NULL, NULL, '6560091959', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f6dc4e30c8f7a0e7d.pdf', NULL, NULL, NULL, NULL),
(143, 1, '1700070', 'MOHAMED EL HAFED CHEIKH ZNEIKI', '2019-10-23', 0, NULL, NULL, '9873027340', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '19528d0a479d71ebe.pdf', NULL, NULL, NULL, NULL),
(144, 1, '1700072', 'SID\'AHMED MOHAMED CHEINE', '2019-10-23', 0, NULL, NULL, '6853941237', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(145, 1, '1700077', 'AGHEILA AHMEDOU LEKWEIRY', '2019-10-23', 0, NULL, NULL, '5736819009', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(146, 1, '1700078', 'AMARNA MOHAMED BETTY', '2019-10-23', 0, NULL, NULL, '1240691305', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(147, 1, '1700079', 'DIAFARA IBRAHIMA BA', '2019-10-23', 0, NULL, NULL, '917457041', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(148, 1, '1700080', 'BAMBA MOHAMED YAHYA BREIHMATT', '2019-10-23', 0, NULL, NULL, '2459417541', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(149, 1, '1700081', 'BEIBA ELBEKAYE SIDI ABDALLA', '2019-10-23', 0, NULL, NULL, '488284033', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(150, 1, '1700082', 'ABDERRAHMANE MAMADOU DIA', '2019-10-23', 0, NULL, NULL, '9563059863', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(151, 1, '1700083', 'DJIBY HAROUNA DIENG', '2019-10-23', 0, NULL, NULL, '4444829740', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(152, 1, '1700084', 'EL HASSEN FALL MOHAMED MOHAMED VALL', '2019-10-23', 0, NULL, NULL, '6708003864', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'f73113af0b2259224.pdf', NULL, NULL, NULL, NULL),
(153, 1, '1700085', 'EL HOUCEIN MOHAMEDHEN AHMEDNAH', '2019-10-23', 0, NULL, NULL, '8644881822', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(154, 1, '1700086', 'OUTHMANE N\'DIAYE EL HADJ MALICK DIA', '2019-10-23', 0, NULL, NULL, '1064617390', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'a916ac704f017eebb.pdf', NULL, NULL, NULL, NULL),
(155, 1, '1700087', 'HOULEYE SILEYE DIA', '2019-10-23', 0, NULL, NULL, '5288977090', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(156, 1, '1700089', 'MOHAMED BRAHIM ZEIDANE', '2019-10-23', 0, NULL, NULL, '8982659975', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(157, 1, '1700090', 'MOHAMED AHMED SALEM KHATARY', '2019-10-23', 0, NULL, NULL, '3780872985', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '0a857c7dcd44ea7e1.pdf', NULL, NULL, NULL, NULL),
(158, 1, '1700091', 'OUMAR MOHAMED H\'MEIDA', '2019-10-23', 0, NULL, NULL, '6392383906', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(159, 1, '1700094', 'SEYIDA AOUBECK MAIMOUNE', '2019-10-23', 0, NULL, NULL, '5276263300', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(164, 1, '1700098', 'DIEYNABA HABIBOU THIAM', '2019-10-23', 0, NULL, NULL, '992487414', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(165, 1, '1700101', 'MARIEM MOHAMED BOUBAKAR', '2019-10-23', 0, NULL, NULL, '2972520866', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(166, 1, '1700104', 'SAMBA SOUVI N\'DIACK', '2019-10-23', 0, NULL, NULL, '9776662690', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '70b2e1e59452e12de.pdf', NULL, NULL, NULL, NULL),
(167, 1, '1700105', 'KHADIJETOU MAMADOU DIALLO', '2019-10-23', 0, NULL, NULL, '5422878412', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(168, 1, '1700111', 'MARIEME DAH LAGHLAL', '2019-10-23', 0, NULL, NULL, '6286370569', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(169, 1, '1700112', 'MOHAMED AHMED HAMINE', '2019-10-23', 0, NULL, NULL, '7094371742', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(170, 1, '1700116', 'MOHAMED LAMRABOTT TEYIB', '2019-10-23', 0, NULL, NULL, '5247061353', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(171, 1, '1700117', 'SALEH BABA ELY MAHMOUD', '2019-10-23', 0, NULL, NULL, '3387300529', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(172, 1, '1700120', 'MARIEM EL BAR ELY', '2019-10-23', 0, NULL, NULL, '9945513888', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(173, 1, '1700121', 'MOHAMED ALI AHMED MAHMOUD MOUDDI', '2019-10-23', 0, NULL, NULL, '1489162916', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(174, 1, '1700123', 'EL MOKTAR BOURHANE MOHAMED ABDELLAHI', '2019-10-23', 0, NULL, NULL, '8598681886', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(175, 1, '1700129', 'HEMED BRAHIM HEMEYADA', '2019-10-23', 0, NULL, NULL, '9800742067', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(176, 1, '1700133', 'MOHAMEDOU BRAHIM BARKA', '2019-10-23', 0, NULL, NULL, '5509187654', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(177, 1, '1700065', 'IBRAHIMA DAME FALL', '2019-10-23', 0, NULL, NULL, '6298160531', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(178, 1, '1700135', 'AHMEDOU MOHAMED SAFI', '2019-10-23', 0, NULL, NULL, '3032004370', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(179, 1, '1700137', 'AMY AMARNA SAMBA EL VOULANY', '2019-10-23', 0, NULL, NULL, '7031736902', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(180, 1, '1700142', 'MOHAMED AHMED DIOP', '2019-10-23', 0, NULL, NULL, '2897003844', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(181, 1, '1700145', 'SIDI ZEIN M\'HAIMED', '2019-10-23', 0, NULL, NULL, '4421989635', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(182, 1, '1700146', 'ABDATT SID\'AHMED OULEIDOU', '2019-10-23', 0, NULL, NULL, '4954073920', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(183, 1, '1700148', 'FATIMETOU ELY M\'HAMED DICK', '2019-10-23', 0, NULL, NULL, '2878785789', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(184, 1, '1700149', 'HEBSSAYA MOHAMED SAMBA EL ABD', '2019-10-23', 0, NULL, NULL, '9365373960', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(185, 1, '1700150', 'LEGLAYB MOHAMED M\'HAIMMED', '2019-10-23', 0, NULL, NULL, '5034805080', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(186, 1, '1700153', 'BABA MAMADOU FALL', '2019-10-23', 0, NULL, NULL, '1096943901', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(187, 1, '1700156', 'ADAMA KALIDOU DIOP', '2019-10-23', 0, NULL, NULL, '8227874554', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(188, 1, '1700157', 'AMINA AZIZ CHEKROUNE', '2019-10-23', 0, NULL, NULL, '6648357012', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(189, 1, '1700160', 'MATY ALY MANE ALY MANE', '2019-10-23', 0, NULL, NULL, '2950857177', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(190, 1, '1700161', 'AHMETOU DEMDE LEKOUEIRY', '2019-10-23', 0, NULL, NULL, '5017361376', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(191, 1, '1700162', 'Moulaye Birame Isselmou', '2019-10-23', 0, NULL, NULL, '1705661387', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(192, 1, '1700166', 'MOHAMED LEMINE MOHAMED VALL VALL', '2019-10-23', 0, NULL, NULL, '3269216512', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(193, 1, '1700171', 'ISMAILA CIRE DEM', '2019-10-23', 0, NULL, NULL, '4641591718', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(194, 1, '1700168', 'SLAME MOHAMED M\'BARECK', '2019-10-23', 0, NULL, NULL, '9183373345', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(195, 1, '1700169', 'CHEIKH KABER AHMED', '2019-10-23', 0, NULL, NULL, '4291901674', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(196, 1, '1700176', 'DEIJE ELWELY H\'MEIMED', '2019-10-23', 0, NULL, NULL, '7291877128', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(197, 1, '1700174', 'DJIBY SADIO KONTE', '2019-10-23', 0, NULL, NULL, '9510882496', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(198, 1, '1700175', 'KHDEIJA CHEIKH MOHAMED LEMINE', '2019-10-23', 0, NULL, NULL, '8220728467', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(199, 1, '1700178', 'MOHAMED HIMIDE BRAHIM', '2019-10-23', 0, NULL, NULL, '1394679387', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(200, 1, '1700179', 'RAVA M\'HAMED KERKOUB', '2019-10-23', 0, NULL, NULL, '6836368523', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(201, 1, '1700182', 'MOULAY ISSELMOU BIRAME', '2019-10-23', 0, NULL, NULL, '9738148161', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(202, 1, '1700183', 'ISSAGA N\'GALAM WANE', '2019-10-23', 0, NULL, NULL, '5302302271', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'e562c992bcea35190.pdf', NULL, NULL, NULL, NULL),
(203, 1, '1700184', 'EL MOKTAR MOHAMED LEMINE DAHI', '2019-10-23', 0, NULL, NULL, '9826431644', NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(204, 1, '057203B', 'Dieng Aboubecrine', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'd7016b6527d1d4028.pdf', NULL, NULL, NULL, NULL),
(205, 1, '104732N', 'Yahya Babana Babana', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '072204329a60514af.pdf', NULL, NULL, NULL, NULL),
(206, 1, '104733P', 'Youssef Hmeity', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'ab8a9fa1eef3055af.pdf', NULL, NULL, NULL, NULL),
(207, 1, '102788A', 'Seyidi Mohamed', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'efb09ecf309e4325c.pdf', NULL, NULL, NULL, NULL),
(208, 1, '077320T', 'Halima Kamara', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(209, 1, '91320K', 'Melainine Cheikh Chewaf', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(210, 1, '103097L', 'Hamady Mohamed', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '1b3e547a720c740fe.pdf', NULL, NULL, NULL, NULL),
(211, 1, '13089C', 'Eboubekrin Yahya', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(212, 1, '088907M', 'Jemila Mohamed', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'fb72b36dadade1d76.pdf', NULL, NULL, NULL, NULL),
(213, 1, '1700006', 'Aminetou Fall', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '45c7bdd39f6471c58.pdf', NULL, NULL, NULL, NULL),
(214, 1, '1700016', 'Zeinebou Keyna', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(215, 1, '1700014', 'Nana Salama', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(216, 1, '170002', 'Abdallahi Sidi Cheikh', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(217, 1, '1700027', 'El Moustapha Ahmed', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(218, 1, '097615C', 'Marieme Mohamed Lemine', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '70248697894815d73.pdf', NULL, NULL, NULL, NULL),
(219, 1, '070509', 'Bocar Diallo', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '3eca22de876f6abc7.pdf', NULL, NULL, NULL, NULL),
(220, 1, '097618F', 'Hadiyatou Kamara', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(221, 1, '1200238', 'Khadijetou Ismaila Cissé', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'b73a4801c97ecfffe.pdf', NULL, NULL, NULL, NULL),
(222, 1, '1200232', 'Aicha Mohamed Bacar', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, 'c1d7b73a900861204.pdf', NULL, NULL, NULL, NULL),
(223, 1, '100160T', 'Cheikh El Bou', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(224, 1, '1700027-2', 'Mounina Mohamed', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, '2bca7764ca91c5c28.pdf', NULL, NULL, NULL, NULL),
(225, 1, '43510S', 'Harouna Mamadou', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(226, 1, '43514X', 'MOUSSA BOUKDAOUD SIDIBE', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(227, 1, '1200123', 'Fatimetou Mohamdane', '2019-10-23', 0, NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-23', NULL, NULL, NULL, NULL, NULL, NULL, 0, '0', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `idexpense` int(3) UNSIGNED ZEROFILL NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `date_saisie` date DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `client` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `amount` int(11) DEFAULT '0',
  `date_depart` date DEFAULT NULL,
  `date_retour` date DEFAULT NULL,
  `date_depart_derniere` date DEFAULT NULL,
  `adresse_absence` varchar(255) DEFAULT NULL,
  `departement` varchar(255) DEFAULT NULL,
  `signataire` varchar(255) DEFAULT NULL,
  `observations` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fiche_pointages`
--

CREATE TABLE `fiche_pointages` (
  `id_fiche_pointage` int(10) UNSIGNED NOT NULL,
  `from_pointage` int(10) UNSIGNED DEFAULT NULL,
  `date_fiche_pointage` date DEFAULT NULL,
  `nom_prenom_fp` int(10) UNSIGNED DEFAULT NULL,
  `fonction_fp` int(10) UNSIGNED DEFAULT NULL,
  `nni_fp` int(10) UNSIGNED DEFAULT NULL,
  `heure_arrive` time DEFAULT NULL,
  `heure_depart` time DEFAULT NULL,
  `emargement` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `fonctions`
--

CREATE TABLE `fonctions` (
  `idfonction` int(10) UNSIGNED NOT NULL,
  `fonction` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fonctions`
--

INSERT INTO `fonctions` (`idfonction`, `fonction`) VALUES
(1, 'SECRETAIRE GENERAL'),
(2, 'CHARGE DE MISSIONS'),
(3, 'INSPECTEUR GENERAL'),
(4, 'Conseiller Habitat'),
(5, 'Conseiller Bâtiments'),
(6, 'Conseiller Urbanisme'),
(7, 'Conseiller Juridique'),
(8, 'Conseiller Aménagement du Territoire'),
(9, 'DG BEP'),
(10, 'DGHU'),
(11, 'DG ATAR'),
(12, 'Coordinateur Cellule Regroupement'),
(13, 'DGA BEP'),
(14, 'DGA ATAR'),
(15, 'DAAF'),
(16, 'DEPC'),
(17, 'INSPECTEUR'),
(18, 'Cellule Informatique'),
(19, 'DU/DGHU'),
(20, 'DE/DGBEP'),
(21, 'DT/DGBEP'),
(22, 'DCIG/DGATAR'),
(23, 'DH/DGHU'),
(24, 'DAT/DGATAR'),
(25, 'DELEGUE REGIONALE/SUD'),
(26, 'DELEGUE REGIONALE/OUEST'),
(27, 'DELEGUE REGIONALE/NORD'),
(28, 'DELEGUE KIFFA'),
(29, 'DELEGUE NEMA'),
(30, 'DELEGUE AIOUN'),
(31, 'DELEGUE AKJOUJT'),
(32, 'DELEGUE ALEG'),
(33, 'DELEGUE NDB'),
(34, 'DELEGUE SELIBABY'),
(35, 'DELEGUE ADRAR'),
(36, 'DELEGUE ZOUERAT'),
(37, 'DELEGUE ROSSO'),
(38, 'Chef de service DU'),
(39, 'Chef de service du personnel DAAF'),
(40, 'Chef de service Cabinet'),
(41, 'CHEF SERVICE DES MARCHES'),
(42, 'Chef de service DGATAR'),
(43, 'Chef de service DH'),
(44, 'Chef de service DEPC'),
(45, 'Cadre'),
(46, 'Technicien'),
(47, 'Agent comptable'),
(48, 'Agent administratif'),
(49, 'SECRETAIRE'),
(50, 'Garde du corps'),
(51, 'Agent contrôle'),
(52, 'Agent cartographie'),
(53, 'Agent technicien'),
(54, 'Agent topographe'),
(55, 'Femme de bureau'),
(56, 'CHAUFFEUR'),
(57, 'Gardien'),
(58, 'PLANTON'),
(59, 'Conducteur des Travaux Publique'),
(60, 'Chef d\'équipe'),
(61, 'MECANICIEN'),
(62, 'Electricien'),
(63, 'Peintre'),
(64, 'Froid'),
(65, 'Manoeuvre'),
(66, 'TOPOGRAPHE'),
(67, 'DGADJOINT');

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

--
-- Table structure for table `formations`
--

CREATE TABLE `formations` (
  `idformation` int(10) UNSIGNED NOT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `specialisation` varchar(255) DEFAULT NULL,
  `annee` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `organisme` varchar(255) DEFAULT NULL,
  `lieu` varchar(255) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `duree` int(11) DEFAULT NULL,
  `effets` varchar(255) DEFAULT NULL,
  `resultat` varchar(255) DEFAULT NULL,
  `r_c_p` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `gestion_primes`
--

CREATE TABLE `gestion_primes` (
  `idgestion_prime` int(10) UNSIGNED NOT NULL,
  `echeance` int(10) UNSIGNED DEFAULT NULL,
  `date` date DEFAULT NULL,
  `mois` varchar(255) DEFAULT NULL,
  `signataire` varchar(255) DEFAULT NULL,
  `link` varchar(255) DEFAULT 'VALIDE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `gestion_primes`
--

INSERT INTO `gestion_primes` (`idgestion_prime`, `echeance`, `date`, `mois`, `signataire`, `link`) VALUES
(1, 2, '2019-10-01', 'AOUT - SEPTEMBRE', 'Issaga Diagana', 'VALIDE');

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

--
-- Table structure for table `informations`
--

CREATE TABLE `informations` (
  `idinformation` int(10) UNSIGNED NOT NULL,
  `situation` varchar(255) DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `education` varchar(255) DEFAULT NULL,
  `diplome_primordial` varchar(255) DEFAULT NULL,
  `date_diplome` date DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `lieu_diplome` varchar(255) DEFAULT NULL,
  `diplome_certificat` varchar(255) DEFAULT NULL,
  `specialite` varchar(255) DEFAULT NULL,
  `institution_specialite` varchar(255) DEFAULT NULL,
  `lieu_specialite` varchar(255) DEFAULT NULL,
  `langues` varchar(255) DEFAULT NULL,
  `arabe` blob,
  `francais` blob,
  `anglais` blob,
  `autres1` varchar(255) DEFAULT NULL,
  `autres2` blob,
  `informatique` varchar(255) DEFAULT NULL,
  `utilisation` varchar(255) DEFAULT NULL,
  `programmation` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `main`
--

CREATE TABLE `main` (
  `idmain` int(10) UNSIGNED NOT NULL,
  `main` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `missions`
--

CREATE TABLE `missions` (
  `id_mission` int(10) UNSIGNED NOT NULL,
  `to_mission` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `directeur` varchar(255) DEFAULT NULL,
  `destination` varchar(255) DEFAULT NULL,
  `motif` varchar(255) DEFAULT NULL,
  `date_depart` date DEFAULT NULL,
  `date_retour` date DEFAULT NULL,
  `moyen` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `ordres_missions`
--

CREATE TABLE `ordres_missions` (
  `id_ordre_mission` int(10) UNSIGNED NOT NULL,
  `from_mission` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id_permission` int(3) UNSIGNED ZEROFILL NOT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `num_fiche` varchar(255) DEFAULT NULL,
  `nature` varchar(255) DEFAULT NULL,
  `date_debut` date DEFAULT NULL,
  `date_fin` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `directeur` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `pointages`
--

CREATE TABLE `pointages` (
  `id_pointages` int(10) UNSIGNED NOT NULL,
  `to_fiche_pointage` varchar(255) DEFAULT NULL,
  `structure` int(10) UNSIGNED DEFAULT NULL,
  `mois` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `rythme_prime`
--

CREATE TABLE `rythme_prime` (
  `idrythme_prime` int(10) UNSIGNED NOT NULL,
  `rythme` int(11) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rythme_prime`
--

INSERT INTO `rythme_prime` (`idrythme_prime`, `rythme`) VALUES
(1, 1),
(2, 2);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `idservice` int(10) UNSIGNED NOT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `statuts`
--

CREATE TABLE `statuts` (
  `idstatut` int(10) UNSIGNED NOT NULL,
  `statut` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `statuts`
--

INSERT INTO `statuts` (`idstatut`, `statut`) VALUES
(1, 'PNP'),
(2, 'FONCTIONNAIRE'),
(3, 'TITULAIRE');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `banques`
--
ALTER TABLE `banques`
  ADD PRIMARY KEY (`idbanque`);

--
-- Indexes for table `carrieres`
--
ALTER TABLE `carrieres`
  ADD PRIMARY KEY (`idcarriere`),
  ADD KEY `matricule` (`matricule`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`idcategorie`);

--
-- Indexes for table `conges`
--
ALTER TABLE `conges`
  ADD PRIMARY KEY (`id_conge`),
  ADD KEY `nom_prenom` (`nom_prenom`);

--
-- Indexes for table `decomptes`
--
ALTER TABLE `decomptes`
  ADD PRIMARY KEY (`iddecompte`),
  ADD KEY `matricule` (`matricule`);

--
-- Indexes for table `details_decompte`
--
ALTER TABLE `details_decompte`
  ADD PRIMARY KEY (`iddetail_decompte`),
  ADD KEY `to_decomptes` (`to_decomptes`);

--
-- Indexes for table `directions`
--
ALTER TABLE `directions`
  ADD PRIMARY KEY (`iddirection`);

--
-- Indexes for table `divisions`
--
ALTER TABLE `divisions`
  ADD PRIMARY KEY (`iddivision`),
  ADD KEY `service` (`service`);

--
-- Indexes for table `dossier_individuel`
--
ALTER TABLE `dossier_individuel`
  ADD PRIMARY KEY (`iddindividuel`),
  ADD UNIQUE KEY `matricule_unique` (`matricule`),
  ADD UNIQUE KEY `nni_unique` (`nni`),
  ADD KEY `option_prime` (`option_prime`),
  ADD KEY `statut` (`statut`),
  ADD KEY `direction` (`direction`),
  ADD KEY `fonction` (`fonction`),
  ADD KEY `service` (`service`),
  ADD KEY `division` (`division`),
  ADD KEY `categorie` (`categorie`),
  ADD KEY `banque` (`banque`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`idexpense`),
  ADD KEY `matricule` (`matricule`);

--
-- Indexes for table `fiche_pointages`
--
ALTER TABLE `fiche_pointages`
  ADD PRIMARY KEY (`id_fiche_pointage`),
  ADD KEY `from_pointage` (`from_pointage`),
  ADD KEY `nom_prenom_fp` (`nom_prenom_fp`);

--
-- Indexes for table `fonctions`
--
ALTER TABLE `fonctions`
  ADD PRIMARY KEY (`idfonction`);

--
-- Indexes for table `formations`
--
ALTER TABLE `formations`
  ADD PRIMARY KEY (`idformation`),
  ADD KEY `matricule` (`matricule`);

--
-- Indexes for table `gestion_primes`
--
ALTER TABLE `gestion_primes`
  ADD PRIMARY KEY (`idgestion_prime`),
  ADD KEY `echeance` (`echeance`);

--
-- Indexes for table `informations`
--
ALTER TABLE `informations`
  ADD PRIMARY KEY (`idinformation`),
  ADD KEY `matricule` (`matricule`);

--
-- Indexes for table `main`
--
ALTER TABLE `main`
  ADD PRIMARY KEY (`idmain`);

--
-- Indexes for table `missions`
--
ALTER TABLE `missions`
  ADD PRIMARY KEY (`id_mission`);

--
-- Indexes for table `ordres_missions`
--
ALTER TABLE `ordres_missions`
  ADD PRIMARY KEY (`id_ordre_mission`),
  ADD KEY `from_mission` (`from_mission`),
  ADD KEY `nom_prenom` (`nom_prenom`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id_permission`),
  ADD KEY `nom_prenom` (`nom_prenom`);

--
-- Indexes for table `pointages`
--
ALTER TABLE `pointages`
  ADD PRIMARY KEY (`id_pointages`),
  ADD KEY `structure` (`structure`);

--
-- Indexes for table `rythme_prime`
--
ALTER TABLE `rythme_prime`
  ADD PRIMARY KEY (`idrythme_prime`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`idservice`),
  ADD KEY `direction` (`direction`);

--
-- Indexes for table `statuts`
--
ALTER TABLE `statuts`
  ADD PRIMARY KEY (`idstatut`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `banques`
--
ALTER TABLE `banques`
  MODIFY `idbanque` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `carrieres`
--
ALTER TABLE `carrieres`
  MODIFY `idcarriere` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `idcategorie` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;
--
-- AUTO_INCREMENT for table `conges`
--
ALTER TABLE `conges`
  MODIFY `id_conge` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `decomptes`
--
ALTER TABLE `decomptes`
  MODIFY `iddecompte` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `details_decompte`
--
ALTER TABLE `details_decompte`
  MODIFY `iddetail_decompte` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `directions`
--
ALTER TABLE `directions`
  MODIFY `iddirection` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `divisions`
--
ALTER TABLE `divisions`
  MODIFY `iddivision` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `dossier_individuel`
--
ALTER TABLE `dossier_individuel`
  MODIFY `iddindividuel` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=228;
--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `idexpense` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fiche_pointages`
--
ALTER TABLE `fiche_pointages`
  MODIFY `id_fiche_pointage` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `fonctions`
--
ALTER TABLE `fonctions`
  MODIFY `idfonction` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;
--
-- AUTO_INCREMENT for table `formations`
--
ALTER TABLE `formations`
  MODIFY `idformation` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `gestion_primes`
--
ALTER TABLE `gestion_primes`
  MODIFY `idgestion_prime` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `informations`
--
ALTER TABLE `informations`
  MODIFY `idinformation` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `main`
--
ALTER TABLE `main`
  MODIFY `idmain` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `missions`
--
ALTER TABLE `missions`
  MODIFY `id_mission` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `ordres_missions`
--
ALTER TABLE `ordres_missions`
  MODIFY `id_ordre_mission` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pointages`
--
ALTER TABLE `pointages`
  MODIFY `id_pointages` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `rythme_prime`
--
ALTER TABLE `rythme_prime`
  MODIFY `idrythme_prime` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `idservice` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `statuts`
--
ALTER TABLE `statuts`
  MODIFY `idstatut` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;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 */;
