-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `mhuat`
--
CREATE DATABASE IF NOT EXISTS `mhuat` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `mhuat`;

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

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

CREATE TABLE IF NOT EXISTS `banques` (
  `id_banque` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `to_etat_banques` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `directeur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_banque`),
  KEY `banque` (`banque`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

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

INSERT INTO `banques` (`id_banque`, `to_etat_banques`, `date`, `banque`, `directeur`) VALUES
(1, NULL, '2019-10-09', 13, 'Issaga Diagana');

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

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

CREATE TABLE IF NOT EXISTS `carrieres` (
  `idcarriere` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `date` date DEFAULT NULL,
  `r_n_m_a_p_d` int(10) UNSIGNED DEFAULT NULL,
  `statut` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idcarriere`),
  KEY `matricule` (`matricule`),
  KEY `r_n_m_a_p_d` (`r_n_m_a_p_d`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `carrieres_option`
--

CREATE TABLE IF NOT EXISTS `carrieres_option` (
  `idoption` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idoption`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `categorie_prime`
--

CREATE TABLE IF NOT EXISTS `categorie_prime` (
  `id_categorie_prime` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `categorie` varchar(255) DEFAULT NULL,
  `prime` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id_categorie_prime`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categorie_prime`
--

INSERT INTO `categorie_prime` (`id_categorie_prime`, `categorie`, `prime`) VALUES
(1, 'Secrétaire Général', '60000'),
(2, 'Chef de Service', '5000'),
(3, 'Directeur Général', '25000'),
(4, 'Chef Division', '5000'),
(5, 'Secrétaire', '6000'),
(6, 'Planton', '4000'),
(7, 'Chauffeur', '4000'),
(8, 'Directeur Adjoint', '15000'),
(9, 'Conseiller', '25000'),
(10, 'Administratif', '3000'),
(11, 'Délégué Régional', '20000'),
(12, 'Cadre', '8000'),
(13, 'Inspecteur', '20000'),
(14, 'Directeur', '20000'),
(15, 'Conseiller Technique chargé des Affaires Juridique', NULL),
(16, 'Conseiller Technique chargé de l\'habitat et de la Promotion Immobilière', NULL),
(17, 'Conseiller Technique chargé de l\'urbanisme et de la Topographie', NULL),
(18, 'Conseiller Technique chargé des Bâtiments et Equipements Publique', NULL),
(19, 'Cabinet du Ministre', '50000'),
(20, 'Société Nationale ISKAN', NULL),
(21, 'Agence de Développement Urbain (ADU)', NULL),
(22, 'Le Cabinet du Ministre', NULL),
(23, 'Société Nationale ISKAN', NULL),
(24, 'Agence de Développement Urbain (ADU)', NULL),
(25, 'Agence Mauritanienne d\'Exécution des Travaux (AMEXTIPE)', NULL),
(26, 'Le Chef de la Cellule de Communication', NULL),
(27, 'Le Chef de la Cellule de Communication', NULL),
(28, 'Société Nationale ISKAN', NULL),
(29, 'Agence de Développement Urbain (ADU)', NULL),
(30, 'Le Cabinet du Ministre', NULL),
(32, 'les directions centrales', NULL),
(33, 'Cabinet', '2000'),
(34, 'INSPECTEUR GENERAL', '50000'),
(35, 'Délégation Régionale', '20000'),
(37, 'Conseiller', NULL),
(38, 'Directeur Générale', NULL),
(39, 'Conseiller Chargé de Mission', NULL),
(40, 'Chef Division', NULL),
(118, 'Cadre - 2', '6000'),
(117, 'Agent comptable - 2', '8000'),
(46, 'Directeur Général Adjoint', NULL),
(48, 'Directeur Adjoint', NULL),
(49, 'Directeur Général Adjoint', NULL),
(50, 'TOPOGRAPHE', '3000'),
(52, 'Chargé de mission', '50000'),
(53, 'Conseiller Habitat', '50000'),
(54, 'Conseiller Bâtiments', '50000'),
(55, 'Conseiller Urbanisme', '50000'),
(56, 'Conseiller Juridique', '50000'),
(57, 'Conseiller Aménagement du Territoire', '50000'),
(58, 'DG BEP', '50000'),
(59, 'DGHU', '50000'),
(60, 'DG ATAR', '50000'),
(61, 'IG', NULL),
(62, 'Coordinateur Cellule Regroupement', '50000'),
(63, 'DGA BEP', '40000'),
(64, 'DAAF', '40000'),
(65, 'DEPC', '40000'),
(66, 'Cellule Informatique', '40000'),
(67, 'Chargé de la Communication', '40000'),
(68, 'DU/DGHU', '40000'),
(69, 'DE/DGBEP', '40000'),
(70, 'DT/DGBEP', '40000'),
(71, 'DCIG/DGATAR', '40000'),
(72, 'DH/DGHU', '40000'),
(73, 'DAT/DGATAR', '40000'),
(74, 'Délégué Régionale sud', '40000'),
(75, 'Délégué Régionale ouest', '40000'),
(76, 'Délégué Régionale nord', '40000'),
(77, 'Délégué Kiffa', '40000'),
(78, 'Délégué Néma', '40000'),
(79, 'Délégué Aïoun', '40000'),
(80, 'Délégué Akjoujt', '40000'),
(81, 'Délégué Aleg', '40000'),
(82, 'Délégué NDB', '40000'),
(83, 'Délégué Sélibaby', '40000'),
(84, 'Délégué Adrar', '40000'),
(85, 'Délégué Zouérat', '40000'),
(86, 'Délégué Rosso', '40000'),
(87, 'Chef de service DU', '30000'),
(88, 'Chef de service du personnel DAAF', '10000'),
(89, 'Chef de service Cabinet', '10000'),
(90, 'Chef de service des Marchés', '10000'),
(91, 'Chef de service DGATAR', '10000'),
(92, 'Chef de service DH', '10000'),
(93, 'Chef de service DEPC', '10000'),
(94, 'Technicien', '8000'),
(95, 'Agent comptable', '6000'),
(96, 'Agent administratif', '6000'),
(97, 'Garde du corps', '6000'),
(98, 'Agent contrôle', '6000'),
(99, 'Agent cartographie', '6000'),
(100, 'Agent technicien', '6000'),
(101, 'Agent topographe', '6000'),
(102, 'Femme de bureau', '4000'),
(103, 'Gardien', '4000'),
(104, 'Conducteur des Travaux Publique', '6000'),
(105, 'Chef d\'équipe', '4000'),
(106, 'Mécanicien', '4000'),
(107, 'Electricien', '4000'),
(108, 'Peintre', '4000'),
(109, 'Froid', '4000'),
(110, 'Manoeuvre', '4000'),
(111, 'INSPECTEUR GENERAL', '50000'),
(112, 'Conseiller Habitat', '50000'),
(113, 'DGAHU', '40000'),
(114, 'DGA ATAR', '40000'),
(115, 'DAAF', '40000'),
(116, 'DEPC', '40000');

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

--
-- Table structure for table `categorie_prime_backup_20191009143018`
--

CREATE TABLE IF NOT EXISTS `categorie_prime_backup_20191009143018` (
  `id_categorie_prime` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `categorie` varchar(255) DEFAULT NULL,
  `prime` decimal(10,0) DEFAULT NULL,
  PRIMARY KEY (`id_categorie_prime`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categorie_prime_backup_20191009143018`
--

INSERT INTO `categorie_prime_backup_20191009143018` (`id_categorie_prime`, `categorie`, `prime`) VALUES
(1, 'Secrétaire Général', '60000'),
(2, 'Chef de Service', '5000'),
(3, 'Directeur Général', '25000'),
(4, 'Chef Division', '5000'),
(5, 'Secrétaire', '3000'),
(6, 'Planton', '2000'),
(7, 'Chauffeur', '2000'),
(8, 'Directeur Adjoint', '15000'),
(9, 'Conseiller', '25000'),
(10, 'Administratif', '3000'),
(11, 'Délégué Régional', '20000'),
(12, 'Cadre', '4000'),
(13, 'Inspecteur', '20000'),
(14, 'Directeur', '20000');

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

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

CREATE TABLE IF NOT EXISTS `conges` (
  `id_conge` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_conge`),
  KEY `nom_prenom` (`nom_prenom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `conges_permissions`
--

CREATE TABLE IF NOT EXISTS `conges_permissions` (
  `idconge_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `date_recrutement_cp` date DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `annees_service` int(11) DEFAULT NULL,
  `date_depart_conge` varchar(255) DEFAULT NULL,
  `date_depart_retraite` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idconge_permission`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `curriculum_vitae`
--

CREATE TABLE IF NOT EXISTS `curriculum_vitae` (
  `idcv` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `curriculum_vitae` text,
  PRIMARY KEY (`idcv`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `cursus`
--

CREATE TABLE IF NOT EXISTS `cursus` (
  `idcursus` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `idinformation` int(10) UNSIGNED DEFAULT NULL,
  `annee` varchar(255) DEFAULT NULL,
  `duree` int(11) DEFAULT NULL,
  `emploi_activite` varchar(255) DEFAULT NULL,
  `employeur` varchar(255) DEFAULT NULL,
  `observations` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idcursus`),
  KEY `idinformation` (`idinformation`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `decomptes` (
  `iddecompte` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,2) DEFAULT NULL,
  `from_details` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iddecompte`),
  UNIQUE KEY `from_details_unique` (`from_details`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes`
--

CREATE TABLE IF NOT EXISTS `demandes` (
  `iddemande` int(4) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `date_demande` date DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `recrutement` int(10) UNSIGNED DEFAULT NULL,
  `date_depart_souhaite` date DEFAULT NULL,
  `date_depart_dernier` date DEFAULT NULL,
  `date_reprise` date DEFAULT NULL,
  `raison_permission` varchar(255) DEFAULT NULL,
  `adresse_abscence` varchar(255) DEFAULT NULL,
  `nbre_jour` int(11) DEFAULT NULL,
  `pj_conge` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iddemande`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes_conge`
--

CREATE TABLE IF NOT EXISTS `demandes_conge` (
  `idemandes_conge` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_demande_c` date DEFAULT NULL,
  `numero_conge` varchar(255) DEFAULT NULL,
  `date_depart_souhaite` date DEFAULT NULL,
  `date_retour_conge` date DEFAULT NULL,
  `jours_conge` int(11) DEFAULT NULL,
  `adresse_conge` varchar(255) DEFAULT NULL,
  `justificatif_conge` varchar(255) DEFAULT NULL,
  `observation` text,
  PRIMARY KEY (`idemandes_conge`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes_conge_m`
--

CREATE TABLE IF NOT EXISTS `demandes_conge_m` (
  `iddemande_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `date_demande_p` date DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `depart` date DEFAULT NULL,
  `retour` date DEFAULT NULL,
  `raison` varchar(255) DEFAULT NULL,
  `date_dernier_permission` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `adresse_permission` varchar(255) DEFAULT NULL,
  `justificatif_permission` varchar(255) DEFAULT NULL,
  `observation` text,
  PRIMARY KEY (`iddemande_permission`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes_conge_sg`
--

CREATE TABLE IF NOT EXISTS `demandes_conge_sg` (
  `iddemande_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `date_demande_p` date DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `depart` date DEFAULT NULL,
  `retour` date DEFAULT NULL,
  `raison` varchar(255) DEFAULT NULL,
  `date_dernier_permission` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `adresse_permission` varchar(255) DEFAULT NULL,
  `justificatif_permission` varchar(255) DEFAULT NULL,
  `observation` text,
  PRIMARY KEY (`iddemande_permission`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes_permission`
--

CREATE TABLE IF NOT EXISTS `demandes_permission` (
  `iddemande_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `date_demande_p` date DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `depart` date DEFAULT NULL,
  `retour` date DEFAULT NULL,
  `raison` varchar(255) DEFAULT NULL,
  `date_dernier_permission` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `adresse_permission` varchar(255) DEFAULT NULL,
  `justificatif_permission` varchar(255) DEFAULT NULL,
  `observation` text,
  PRIMARY KEY (`iddemande_permission`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `demandes_permissions`
--

CREATE TABLE IF NOT EXISTS `demandes_permissions` (
  `iddemande_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `date_demande_p` date DEFAULT NULL,
  `numero` varchar(255) DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `date_recrutement` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `depart` date DEFAULT NULL,
  `retour` date DEFAULT NULL,
  `raison` varchar(255) DEFAULT NULL,
  `date_dernier_permission` date DEFAULT NULL,
  `jours` int(11) DEFAULT NULL,
  `adresse_permission` varchar(255) DEFAULT NULL,
  `justificatif_permission` varchar(255) DEFAULT NULL,
  `observation` text,
  PRIMARY KEY (`iddemande_permission`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `details_decompte` (
  `iddetail_decompte` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`iddetail_decompte`),
  KEY `to_decomptes` (`to_decomptes`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `directions` (
  `iddirection` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_services` varchar(255) DEFAULT NULL,
  `from_division` varchar(255) DEFAULT NULL,
  `direction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iddirection`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

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

INSERT INTO `directions` (`iddirection`, `from_services`, `from_division`, `direction`) VALUES
(35, NULL, NULL, 'DG ATAR'),
(2, NULL, NULL, 'Les Directions centrales'),
(3, NULL, NULL, 'La Direction Générale de l\'habitat et de l\'Urbanisme'),
(4, NULL, NULL, 'Direction Générale des Batiments et des Equipements Publics'),
(5, NULL, NULL, 'Direction Générale de l\'Aménagement du Territoire et de l\'Action Régionale'),
(6, NULL, NULL, 'Direction des Etudes de la Programmation et de la Coopération'),
(7, NULL, NULL, 'Direction des Affaire Administratives et Financières'),
(8, NULL, NULL, 'Direction de l\'habitat et de la Promotion Immobiliére'),
(34, NULL, NULL, 'DAAF'),
(33, NULL, NULL, 'DELEGATION REGIONALE'),
(11, NULL, NULL, 'Direction de l\'Urbanisme et de la Topographie'),
(32, NULL, NULL, 'IG'),
(13, NULL, NULL, 'Direction des Etudes'),
(14, NULL, NULL, 'Direction de l\'Aménagement du Territoire'),
(15, NULL, NULL, 'Direction de la Cartographie et de l\'Information Géographique'),
(16, NULL, NULL, 'Cabinet'),
(17, NULL, NULL, 'INSPECTION GENERALE'),
(18, NULL, NULL, 'Délégation Régionale de GUIDIMAGHA'),
(19, NULL, NULL, 'Délégation Régionale de NKTT Nord'),
(20, NULL, NULL, 'Délégation Régionale de NDB'),
(21, NULL, NULL, 'Directeur générale'),
(22, NULL, NULL, 'Délégation Régionale Nema'),
(23, NULL, NULL, 'Délégation Régional de l\'Inchiri'),
(24, NULL, NULL, 'Délégation Régionale de AIOUN'),
(25, NULL, NULL, 'Délégation Régionale de TRARZA'),
(26, NULL, NULL, 'Délégation Régionale de NKTT'),
(27, NULL, NULL, 'Délégation Régionale de ASSABA'),
(28, NULL, NULL, 'Délégation Régionale de GORGOL'),
(29, NULL, NULL, 'Délégation Régionale de TIRESS Z'),
(30, NULL, NULL, 'Délégation Régionale de BRAKNA'),
(31, NULL, NULL, 'Délégation Régionale d\'ADRAR'),
(36, NULL, NULL, 'DEPC'),
(37, NULL, NULL, 'DGHU'),
(38, NULL, NULL, 'DGBEP');

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

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

CREATE TABLE IF NOT EXISTS `divisions` (
  `iddivision` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `division` varchar(255) DEFAULT NULL,
  `to_services` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`iddivision`),
  KEY `to_services` (`to_services`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `divisions`
--

INSERT INTO `divisions` (`iddivision`, `division`, `to_services`) VALUES
(4, 'Division du Suivi', NULL),
(5, 'Division études et recherches', NULL),
(6, 'Division du suivi des programme', NULL),
(7, 'Division des Agréments', NULL),
(8, 'Division du suivi des Programme Immobiliers', NULL),
(9, 'Division des Documents et Normes d\'Urbanisme', NULL),
(10, 'Division du controle des travaux,des plan de lotissement et du permis de construire', NULL),
(11, 'Division de Gestion du Domaine Public de Etat', NULL),
(12, 'Division de Production et d\'archivage des plans', NULL),
(13, 'Division des levés topographique', NULL),
(14, 'Division du suivi des quartiers précaires', NULL),
(15, 'Division des études architecturales', NULL),
(16, 'Division des études des structures et des lots spécialises', NULL),
(17, 'Division des expertises', NULL),
(18, 'Division des normes', NULL),
(19, 'Division des Agréments', NULL),
(20, 'Division des classification', NULL),
(21, 'Division élaboration des contrats et DAO', NULL),
(22, 'Division suivi de la passation des Marchés', NULL),
(23, 'Division des Marches', NULL),
(24, 'Division du patrimoine', NULL),
(27, 'Division de la Comptabilité', NULL),
(28, 'Division du Matériel', NULL),
(29, 'Division GESITION du Personel', NULL),
(30, 'Division Formation', NULL),
(31, 'Division Archivage', NULL),
(32, 'Division Commission des Marches', NULL);

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

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

CREATE TABLE IF NOT EXISTS `dossier_individuel` (
  `photo` varchar(40) DEFAULT NULL,
  `matricule` varchar(255) DEFAULT NULL,
  `iddindividuel` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom_prenom` varchar(255) DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `matrimoniale` varchar(255) DEFAULT NULL,
  `enfants` varchar(255) 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,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `categorie` int(10) UNSIGNED DEFAULT NULL,
  `statut` int(10) UNSIGNED DEFAULT NULL,
  `salaire` decimal(10,0) DEFAULT NULL,
  `prime_ts` int(10) UNSIGNED DEFAULT NULL,
  `compte` varchar(255) DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `total_income` decimal(10,0) DEFAULT '0',
  `total_expense` decimal(10,0) DEFAULT '0',
  `available_budget` decimal(10,0) DEFAULT '0',
  `dossier` varchar(255) DEFAULT NULL,
  `observation` text,
  `contrat` varchar(255) DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iddindividuel`),
  UNIQUE KEY `matricule_unique` (`matricule`),
  UNIQUE KEY `nni_unique` (`nni`),
  KEY `fonction` (`fonction`),
  KEY `direction` (`direction`),
  KEY `service` (`service`),
  KEY `division` (`division`),
  KEY `categorie` (`categorie`),
  KEY `statut` (`statut`),
  KEY `banque` (`banque`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8;

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

INSERT INTO `dossier_individuel` (`photo`, `matricule`, `iddindividuel`, `nom_prenom`, `date_naissance`, `matrimoniale`, `enfants`, `nni`, `telephone`, `courriel`, `postale`, `date_recrutement`, `fonction`, `direction`, `service`, `division`, `categorie`, `statut`, `salaire`, `prime_ts`, `compte`, `banque`, `total_income`, `total_expense`, `available_budget`, `dossier`, `observation`, `contrat`, `cv`) VALUES
(NULL, '1700068', 2, 'EL BETOUL MOCTAR', '2019-10-09', 'M', '6', '2962840169', '46454587', '46454587@', '42222', '2019-10-09', 82, 0, 0, NULL, 117, NULL, NULL, 117, '154400100127', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '88334P', 3, 'WANE BIRANE', '2019-10-09', 'M', '4', '8400705759', '47484411', NULL, NULL, '2019-10-09', 40, 0, NULL, NULL, 53, NULL, NULL, 53, '723921', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '43508Q', 4, 'DJIBRIL IDRISSA GUEYE', '2019-10-09', 'M', NULL, '3860485832', NULL, NULL, NULL, '2019-10-09', 88, 0, NULL, NULL, 101, NULL, NULL, 101, '2715300101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '101318C', 5, 'MOULAY ISMAIL MOULAY EL HACEN', '2019-10-09', 'M', '1', '4856735875', NULL, NULL, NULL, '2019-10-09', 69, 0, NULL, NULL, 82, NULL, NULL, 82, '10567', 12, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043509R', 6, 'AMINATA N\'DIAYE', '2019-10-09', 'M', NULL, '1202369030', '48417970', NULL, NULL, '2019-10-09', 61, 0, NULL, NULL, 74, NULL, '17', 74, '1126450101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097628R', 7, 'SIDI AHMED DEIDA', '2019-10-09', 'M', NULL, '9686405548', NULL, NULL, NULL, '2019-10-09', 63, 0, NULL, NULL, 76, NULL, NULL, 76, '3955840101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084906N', 8, 'AHMED DENNA', '2019-10-09', 'M', '1', '0119085931', NULL, NULL, NULL, '2019-10-09', 28, 0, NULL, NULL, 2, NULL, NULL, 2, '0120580006', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '044441E', 9, 'MOHAMED SOUEIDI', '2019-10-09', 'M', NULL, '8457385284', NULL, NULL, NULL, '2019-10-09', 22, 0, NULL, NULL, 35, NULL, NULL, 35, '6069', 12, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072094M', 10, 'MAIMOUNATOU MED SIDIYA', '2019-10-09', 'M', NULL, '4114331728', NULL, NULL, NULL, '2019-10-09', 22, 0, NULL, NULL, 35, NULL, NULL, 35, '52783B', 14, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097631U', 11, 'ANDERRAHMANE EL MOCTAR', '2019-10-09', NULL, NULL, '0596119709', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '3797090101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '093219Z', 12, 'MOHAMED EL MOCTAR ZAMEL', '2019-10-09', 'M', '2', '8063906142', NULL, NULL, NULL, '2019-10-09', 50, 0, NULL, NULL, 63, NULL, NULL, 63, '4783000395', 6, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '077620T', 13, 'HALIMA CAMARA', '2019-10-09', 'M', NULL, '5623272458', NULL, NULL, NULL, '2019-10-09', 34, 0, NULL, NULL, 34, NULL, NULL, 34, '9572', 12, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '058946W', 14, 'MOHAMED SALEM TAKIOULLAH', '2019-10-09', 'M', '5', '4484157323', '44685535', NULL, NULL, '2019-10-09', 34, 0, NULL, NULL, 34, NULL, NULL, 34, '3292860101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089073S', 15, 'MOHAMED KONE', '2019-10-09', 'M', NULL, '7212305021', NULL, NULL, NULL, '2019-10-09', 34, 0, NULL, NULL, 34, NULL, '14', 34, '1411220101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084256G', 16, 'CHEIKH YOUBA ZEINE', '2019-10-09', 'M', '5', '7299059493', '20907060', NULL, NULL, '2019-10-09', 21, 0, NULL, NULL, 34, NULL, NULL, 34, '2999830101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089086G', 17, 'JIDDOU HJIBOU', '2019-10-09', 'M', '2', '0120935042', '44480203', NULL, NULL, '2019-10-09', 52, 0, NULL, NULL, 65, NULL, NULL, 65, '4859', 10, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102790C', 18, 'ABDOU MOHAMED MAHMOUD ABDELLAH', '2019-10-09', 'M', NULL, '3463215930', NULL, NULL, NULL, '2019-10-09', 47, 0, NULL, NULL, 60, NULL, NULL, 60, '0127327', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097619G', 19, 'FATIMETOU MEIMOUNA ENNAHOUI', '2019-10-09', 'C', NULL, '6346292222', '36653096', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '107079', 15, '0', '0', '0', NULL, 'BIM', NULL, NULL),
(NULL, '054371Y', 20, 'BOUBACAR BA', '2019-10-09', 'M', NULL, '6899278649', NULL, NULL, NULL, '2019-10-09', 73, 0, NULL, NULL, 86, NULL, NULL, 86, '1126630101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072093L', 21, 'CHEIKH BABOU MED BABOU', '2019-10-09', 'M', '7', '4785506112', '44481256', NULL, NULL, '2019-10-09', 64, 0, NULL, NULL, 77, NULL, NULL, 77, '42443', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097621J', 22, 'MED MAHMOUD MBAYE', '2019-10-09', 'M', NULL, '3317748716', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '37958205012', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '101271B', 23, 'LY OUMAR', '2019-10-09', 'M', NULL, '3225551030', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '1542630101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089653Y', 24, 'FATIMETOU MED ABDALLAHI', '2019-10-09', NULL, NULL, '8616447339', NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '0014920003', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103181C', 25, 'YAHYA KANE', '2019-10-09', 'M', NULL, '5747345061', '49994496', NULL, NULL, '2019-10-09', 98, 0, NULL, NULL, 113, NULL, NULL, 113, '2493', 7, '0', '0', '0', NULL, 'BMI', NULL, NULL),
(NULL, '091721W', 26, 'CHEIKH AHMEDOU ELMINE EL ABASS', '2019-10-09', 'M', '3', '4237270886', '44007360', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '031032', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '07615C', 27, 'MARIEM M MED LEMINE', '2019-10-09', 'C', NULL, '5868366626', '33262227', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '107102', 15, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097630T', 28, 'SIDI AHMED MED LEMINE', '2019-10-09', 'M', '3', '9384946523', '46596911', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '102785', 15, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084168L', 29, 'MED MAHMOUD HAMDI AMAR', '2019-10-09', 'M', '4', '6727971622', '44489469', NULL, NULL, '2019-10-09', 99, 0, NULL, NULL, 114, NULL, NULL, 114, '5599', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084897D', 30, 'MALECK VALL', '2019-10-09', 'M', NULL, '1661636967', NULL, NULL, NULL, '2019-10-09', 58, 0, NULL, NULL, 71, NULL, NULL, 71, '8474', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089214W', 31, 'HOUSSEIN SIDI DIT (HOUMEINI)', '2019-10-09', 'M', NULL, '1466222416', '44485775', NULL, NULL, '2019-10-09', 39, 0, NULL, NULL, 52, NULL, NULL, 52, '24926/90', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097613A', 32, 'MAAOUYA MED KHALED', '2019-10-09', 'M', NULL, '3212515841', '46404986', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '204951/14', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097624M', 33, 'IBRAHIMA YAHYA NDONGO', '2019-10-09', 'M', '2', '6622326286', '48416980', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '75425', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102787Z', 34, 'MEINA SIDINA', '2019-10-09', 'C', NULL, '1251743679', NULL, NULL, NULL, '2019-10-09', 39, 0, NULL, NULL, 52, NULL, NULL, 52, '101872/15', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103096K', 35, 'MED MOUSTAPHA DEINE', '2019-10-09', 'M', '2', '7865101344', '41878944', NULL, NULL, '2019-10-09', 60, 0, NULL, NULL, 73, NULL, NULL, 73, '130125/34', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103089C', 36, 'EBOUBEKRIN YAHAYA', '2019-10-09', 'M', NULL, '5061532751', NULL, NULL, NULL, '2019-10-09', 22, 0, NULL, NULL, 35, NULL, NULL, 35, '130131/23', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043513W', 37, 'SYLLY GUELADIO DIABIRA', '2019-10-09', 'M', NULL, '5498576727', '44685532', NULL, NULL, '2019-10-09', 67, 0, NULL, NULL, 80, NULL, NULL, 80, '101681/06', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084909R', 38, 'MARIEM BAMBA', '2019-10-09', 'D', '2', '0429778677', '46457500', NULL, NULL, '2019-10-09', 59, 0, NULL, NULL, 72, NULL, NULL, 72, '0120480005', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103020C', 39, 'WELE ABDOULLAHI', '2019-10-09', 'M', NULL, '8775700872', NULL, NULL, NULL, '2019-10-09', 39, 0, NULL, NULL, 52, NULL, NULL, 52, '1338170101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089153E', 40, 'SIDI ABDOULLAH OULD MED LEZIZ', '2019-10-09', 'M', '4', '1692397607', NULL, NULL, NULL, '2019-10-09', 49, 0, NULL, NULL, 62, NULL, NULL, 62, '0133325762', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097617E', 41, 'ELMECHERI BEDA', '2019-10-09', 'M', '3', '5628224696', '22317402', '22317402', NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '96320001', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '09990M', 42, 'MOHAMED ABDELLAHI MED LEMINE CHIGEUR', '2019-10-09', 'C', NULL, '3019551413', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '0214480006', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '066736N', 43, 'MOUSSA MAMADOU SEIDOU', '2019-10-09', 'M', '5', '6715057122', '44685546', NULL, NULL, '2019-10-09', 68, 0, NULL, NULL, 81, NULL, NULL, 81, '27034/Q', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072090H', 44, 'MOHAMEDOU OULD AHMEDOU OULD SIDI AHMED', '2019-10-09', 'M', '4', '3386043991', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '26960S', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084907P', 45, 'BRAHIM EL KHALIL MED SID\'AMED', '2019-10-09', 'M', '3', '6561687512', '22068046', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '0121470008', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '091719T', 46, 'YEHEFDOU CHERIFE', '2019-10-09', 'M', '4', '1809488829', '22455616', NULL, NULL, '2019-10-09', 57, 0, NULL, NULL, 70, NULL, NULL, 70, '0155920003', 10, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103085Y', 47, 'ZEINEBOU MED KEYNA', '2019-10-09', 'M', NULL, '3877328621', '47790102', NULL, NULL, '2019-10-09', 28, 0, NULL, NULL, 2, NULL, NULL, 2, '195139/28', 13, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089652X', 48, 'SIDI MED BECHIR', '2019-10-09', 'M', NULL, '8314619326', '22380855', NULL, NULL, '2019-10-09', 43, 0, NULL, NULL, 56, NULL, NULL, 56, '1095340101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097620H', 49, 'ELY OULD EL MOCTAR', '2019-10-09', 'C', NULL, '1739874160', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '413790101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043511T', 50, 'CHERIF ABDOUL BA', '2019-10-09', 'M', '8', '2198315172', '49412305', NULL, NULL, '2019-10-09', 91, 0, NULL, NULL, 104, NULL, NULL, 104, '5113892', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '054510Z', 51, 'AHMED OULD DIAH', '2019-10-09', 'M', '3', '9977540087', '46579039', NULL, NULL, '2019-10-09', 78, 0, NULL, NULL, 91, NULL, NULL, 91, '5242723', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '071934N', 54, 'AHMEDOU OULD AHMEDOU BABA', '2019-10-09', 'M', NULL, '0477773695', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '0155912629', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084910S', 55, 'MOHAMED EL HASSEN EL MOKHTAR', '2019-10-09', 'M', NULL, '0784934671', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '1506480201', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103086Z', 56, 'AMINETOU FALL', '2019-10-09', 'M', NULL, '7574125788', '36212995', NULL, NULL, '2019-10-09', 28, 0, NULL, NULL, 2, NULL, NULL, 2, '1506820701', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '071933M', 57, 'BRAHIM AININA', '2019-10-09', 'M', NULL, '7434033247', NULL, NULL, NULL, '2019-10-09', 80, 0, NULL, NULL, 93, NULL, NULL, 93, '0155913437', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097616D', 58, 'MOHAMED YEDHALI HASSEN', '2019-10-09', 'M', '1', '2854381947', '22660166', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '1507082501', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072089G', 59, 'FATIMETOU CHEIKH MELEININE', '2019-10-09', 'V', NULL, '7122018100', '37240603', NULL, NULL, '2019-10-09', 81, 0, NULL, NULL, 94, NULL, NULL, 94, '52784C', 14, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072091J', 60, 'BABA OULD CHEIKH', '2019-10-09', 'M', NULL, '6665581496', '44489478', NULL, NULL, '2019-10-09', 71, 0, NULL, NULL, 84, NULL, NULL, 84, '52755L', 6, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '099844A', 61, 'FATIMETOU MED ABDELLAHI KHALIFA', '2019-10-09', 'D', '2', '9271678653', '34341310', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '4311720101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '014008A', 62, 'AHMEDOU OULD MED YAHYA', '2019-10-09', 'M', NULL, '0053988552', '36304792', NULL, NULL, '2019-10-09', 20, 0, NULL, NULL, 33, NULL, '22805', 33, '1156230101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '018501J', 63, 'AMADOU MOCTAR ABDELAYE SOW', '2019-10-09', 'M', NULL, '8133156091', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '11107', 12, '3309241001', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043514X', 64, 'MOUSSA SIDIBE', '2019-10-09', 'M', NULL, '0764028552', NULL, NULL, NULL, '2019-10-09', 88, 0, NULL, NULL, 101, NULL, NULL, 101, '3292820101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '046585F', 65, 'DIENG PAPA DAOUDA', '2019-10-09', 'M', NULL, '6037603981', NULL, NULL, NULL, '2019-10-09', 37, 0, NULL, NULL, 50, NULL, '13', 50, '1159600101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '054514D', 66, 'THIAM BABACAR', '2019-10-09', 'M', NULL, '4485381269', '22308676', NULL, NULL, '2019-10-09', 88, 0, NULL, NULL, 101, NULL, NULL, 101, '1246470101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '054515E', 67, 'EBY MOHAMED BEWA', '2019-10-09', 'M', NULL, '9360887419', '42144696', NULL, NULL, '2019-10-09', 62, 0, NULL, NULL, 75, NULL, NULL, 75, '1333360101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '054517G', 68, 'N\'DIAYE BOUBACAR', '2019-10-09', 'M', NULL, '7515570768', NULL, NULL, NULL, '2019-10-09', 88, 0, NULL, NULL, 101, NULL, NULL, 101, '1280820101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084916Z', 69, 'AZIZ MOHAMED ABDELLAHI', '2019-10-09', 'M', '3', '4355013366', '46877487', NULL, NULL, '2019-10-09', 79, 0, NULL, NULL, 92, NULL, NULL, 92, '1404830101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089574M', 70, 'AHMED MOHAMED EL MOUSTAPHA BOYA', '2019-10-09', 'M', NULL, '5776805222', '22128496', NULL, NULL, '2019-10-09', 78, 0, NULL, NULL, 91, NULL, NULL, 91, '1264280101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '091720U', 71, 'MOHAMED BRAHIM BOUBACAR', '2019-10-09', 'M', '1', '8502229936', '22956522', NULL, NULL, '2019-10-09', 56, 0, NULL, NULL, 69, NULL, NULL, 69, '3460460501', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097612Z', 72, 'MOHAMED AHMED SALEM MOULOUD', '2019-10-09', 'M', NULL, '8285081177', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '3785800501', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097614B', 73, 'MINT DEN MOHAMEDEN', '2019-10-09', 'C', NULL, '5119532786', '36298877', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '4067000101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097625N', 74, 'EL KHADIM AHMEDOU', '2019-10-09', 'M', NULL, '7104809621', '34232981', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '4066530501', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097626P', 75, 'MOHAMEDOU ZEINE HAMADI', '2019-10-09', 'C', NULL, '7854827104', '48383313', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '4066640101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097629S', 76, 'MOHAMED SALEM ELY', '2019-10-09', 'C', NULL, '6343242251', '37005545', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '9', 12, '4066560501', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102450H', 77, 'DIAGANA ISSAGHA', '2019-10-09', 'M', NULL, '8429064970', '44489472', NULL, NULL, '2019-10-09', 18, 0, NULL, NULL, 1, 2, NULL, 1, '1191430101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102999E', 78, 'MOUSSA GEYE', '2019-10-09', 'M', '7', '2893091443', '46415711', NULL, NULL, '2019-10-09', 45, 0, NULL, NULL, 58, NULL, NULL, 58, '2716610101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102789B', 79, 'IDRISSA TIRERA', '2019-10-09', 'M', NULL, '6941676476', NULL, NULL, NULL, '2019-10-09', 39, 0, NULL, NULL, 52, NULL, NULL, 52, '2537060101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084918B', 80, 'MOHAMED AMAR MOHAMEDEN', '2019-10-09', 'M', '2', '0372331591', '44481254', NULL, NULL, '2019-10-09', 65, 0, NULL, NULL, 78, NULL, NULL, 78, '2952690101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103088B', 81, 'MOHAMEDOU FALILOU SY', '2019-10-09', 'M', NULL, '7030446220', NULL, NULL, NULL, '2019-10-09', 70, 0, NULL, NULL, 83, NULL, NULL, 83, '1542591001', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103087A', 82, 'DINEG DJIBY HAROUNA', '2019-10-09', 'M', NULL, '444482940', '44489480', NULL, NULL, '2019-10-09', 72, 0, NULL, NULL, 85, 0, NULL, 85, '1543191001', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '074378U', 83, 'AHMED OULD SALECK', '2019-10-09', 'C', NULL, '8821715635', '36633773', NULL, NULL, '2019-10-09', 54, 0, NULL, NULL, 67, 0, '20', 67, '2536680101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '084915Y', 84, 'MOUJTABA MED SALECK', '2019-10-09', 'D', '1', '4551539634', NULL, NULL, NULL, '2019-10-09', 42, 0, NULL, NULL, 55, NULL, NULL, 55, '2999230101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089071Q', 85, 'DIKO ABDOUL', '2019-10-09', 'M', '4', '2293861724', '46513715', NULL, NULL, '2019-10-09', 24, 0, NULL, NULL, 9, NULL, '16', 9, '4337220101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103156A', 86, 'ABDELLAHI KHATAR SIDI CHEIKH', '2019-10-09', 'M', '5', '0843962081', '47797900', NULL, NULL, '2019-10-09', 28, 0, NULL, NULL, 2, NULL, '7', 2, '1542970101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '104667S', 87, 'NANA SELAMA LEBEID', '2019-10-09', 'D', '2', '4198066008', '46410707', NULL, NULL, '2019-10-09', 28, 0, NULL, NULL, 2, NULL, '6', 2, '1543370101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097627Q', 88, 'MOHAMED MAHMOUD TOURAD AHMED', '2019-10-09', 'M', '1', '7416041202', '37159291', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '4092770501', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '041136M', 89, 'MOHAMED EL MOCKTAR MOHAMED', '2019-10-09', 'M', NULL, '0822595309', NULL, NULL, NULL, '2019-10-09', 24, NULL, NULL, NULL, 9, NULL, '13', 9, '24059', 17, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '049674S', 90, 'SIDI ABD MOHAMED SALEH DIT/ JEKANI', '2019-10-09', 'M', NULL, '2151714138', NULL, NULL, NULL, '2019-10-09', 22, NULL, NULL, NULL, 35, NULL, '11', 35, '025947/4', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '057210J', 91, 'MOHAMED LAGHDAF MED ELY', '2019-10-09', 'M', NULL, '7712553615', NULL, NULL, NULL, '2019-10-09', 74, 0, NULL, NULL, 87, NULL, NULL, 87, '36597', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '057360X', 92, 'SY ABDOUL', '2019-10-09', 'M', NULL, '3236499770', '36332981', NULL, NULL, '2019-10-09', 74, 0, 0, NULL, 87, NULL, NULL, 87, '023996/2', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '076008R', 93, 'AISSATA NIANG', '2019-10-09', 'M', NULL, '0748663655', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '39143', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072092K', 94, 'BA ABOU GATTA', '2019-10-09', 'M', NULL, '5467754007', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '9', 12, '931433', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097623L', 95, 'AMINATA DAMBA BANDIA', '2019-10-09', 'M', NULL, '1973530670', '41060087', NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '71418', 16, '0', '0', '0', NULL, 'C.CHEQUE POSTAL', NULL, NULL),
(NULL, '1700088', 96, 'OUMAR MAM SEIDOU LY', '2019-10-09', 'M', NULL, '6324551030', NULL, NULL, NULL, '2019-10-09', 87, 0, NULL, NULL, 100, NULL, NULL, 100, '154263100114', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700181', 97, 'MED LEMINE ALIOUNE SIDI EL KORY', '2019-10-09', 'M', NULL, '9050217272', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '335062100162', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700003', 98, 'AHMED SALEM BOUKHARI', '2019-10-09', 'M', NULL, '2716268012', '47699089', NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, NULL, NULL, 7, '86816/46', 13, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700004', 99, 'AICHA CHERIF HAJI', '2019-10-09', 'M', NULL, '0297169104', '46414130', NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, '7', 5, '299309500147', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700005', 100, 'ALY SAMBA', '2019-10-09', 'M', '4', '7432295230', '46460440', NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, NULL, NULL, 7, '89579/19', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700008', 101, 'DJBRIL BOUCAR', '2019-10-09', 'M', NULL, '2728647928', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, '5', 6, '92170', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700010', 102, 'MOHAMED MAHMOUD CHEIN', '2019-10-09', 'M', '3', '6787701489', '46511711', NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '24589', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700013', 103, 'MOHAMED MAHMOUD OULD AHMED', '2019-10-09', 'M', '6', '6202568195', '22473542', NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '154288100110', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700163', 104, 'CHEIKH OULD DAADA', '2019-10-09', 'M', NULL, '3102246047', '46506375', NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '03005850009', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700018', 105, 'MOUSTAPHA AHMED DIODIA', '2019-10-09', 'M', NULL, '1420807307', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '11', 12, '298867100172', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700019', 106, 'SALKA MASAMBA FALL', '2019-10-09', NULL, NULL, '2586962744', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, 3, NULL, 5, '302141100106', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700509', 107, 'BOCAR THIALEL DIALO', '2019-10-09', NULL, NULL, '1521073103', NULL, NULL, NULL, '2019-10-09', 37, 0, NULL, NULL, 50, 3, '10', 50, '10782', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700510', 108, 'MINI GUENNA DIEH', '2019-10-09', NULL, NULL, '9682522347', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '11', 12, '30156', 16, '0', '0', '0', NULL, 'CENTRE CHEQUES POSTAUX', NULL, NULL),
(NULL, '0700511', 109, 'MARIEM KANE', '2019-10-09', 'M', '5', '0213040713', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '11', 12, '327873100156', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700516', 112, 'EBOUBECRINE YAHYA M\'haimid', '2019-10-09', 'M', NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, 0, '11', 12, '130131/23', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700526', 113, 'ZEINEBOU MOUSSA DIALLO', '2019-10-09', NULL, NULL, '6120588936', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '191268/39', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700531', 114, 'IBRA AMADOU SY', '2019-10-09', NULL, NULL, '6697794905', NULL, NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, NULL, '8', 7, '00142590007', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700533', 115, 'BARKA MAMADOU SALL PNP', '2019-10-09', NULL, NULL, '5868408239', NULL, NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, NULL, NULL, 7, '75063/14', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700017', 116, 'MOHAMED VADEL DAH BOWBA', '2019-10-09', NULL, NULL, '5731153045', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '302677100125', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700548', 117, 'BOUDY MAMADOU N\'DIAYE', '2019-10-09', NULL, NULL, '2032845006', NULL, NULL, NULL, '2019-10-09', 89, 0, NULL, NULL, 102, NULL, NULL, 102, '0014235000212', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700566', 118, 'MOHAMED DOWFA LOPEZ', '2019-10-09', NULL, NULL, '6595072681', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '7', 12, '59041/65', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700020', 119, 'ABDOURAHIM KOWRY SY', '2019-10-09', NULL, NULL, '8539714228', NULL, NULL, NULL, '2019-10-09', 83, 0, NULL, NULL, 96, 3, '8', 96, '309087100147', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700022', 120, 'BABA BEIDE EL MOCTAR', '2019-10-09', NULL, NULL, '4110279068', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, '10', 12, '150645550152', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700023', 121, 'BEIBATT BOUCHAME BOUCHAME', '2019-10-09', NULL, NULL, '6594700492', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '150688160116', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700026', 122, 'HOULEYE M\'BERLABA NIANG', '2019-10-09', NULL, NULL, '7821647866', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '212042566010', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700027', 219, 'El Moustapha Ahmed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '298867100172', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700028', 124, 'MOUSSA AHMED MOHAMEDOU', '2019-10-09', NULL, NULL, '3751381978', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '150688190185', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700029', 125, 'EL MOUSTAPHA OULEIDHOM SGHAIER', '2019-10-09', NULL, NULL, '2856051608', NULL, NULL, NULL, '2019-10-09', 86, 0, NULL, NULL, 99, NULL, NULL, 99, '76325/11', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700519', 126, 'KHEDAJA AHMED ELMEOULOUD', '2019-10-09', NULL, NULL, '6172505470', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, '7', 5, '309024100192', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700559', 127, 'ABDARAHMANE MALICK MALICK', '2019-10-09', NULL, NULL, '8720148584', '47777822', NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '48806/21', 10, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700036', 128, 'BRAHIM BOBACAR YARIM', '2019-10-09', NULL, NULL, '9792406372', NULL, NULL, NULL, '2019-10-09', 93, 0, NULL, NULL, 106, NULL, NULL, 106, '154311100149', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '0700573', 129, 'FATIMETOU MOHAMED  LEMIN SABAR', '2019-10-09', NULL, '1', '1170655268', '36671562', NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '50459/09', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700037', 130, 'CHEIKH BRAHIM M\'bodj', '2019-10-09', NULL, NULL, '0202069237', NULL, NULL, NULL, '2019-10-09', 94, 0, NULL, NULL, 107, NULL, NULL, 107, '154308100165', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700038', 131, 'CHEIKH MOHAMEDEN VALL OBODJE', '2019-10-09', NULL, NULL, '7786523778', NULL, NULL, NULL, '2019-10-09', 92, 0, NULL, NULL, 105, NULL, NULL, 105, '154315100160', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700040', 132, 'HACHEM BRAHIM BOUBACAR', '2019-10-09', NULL, NULL, '6649485704', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '154361100141', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700042', 133, 'LEGHWEYA CHEIKH SADE', '2019-10-09', NULL, NULL, '6851548829', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '154339100129', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700045', 134, 'M\'BAYE SIKHOU CISSOKO', '2019-10-09', NULL, NULL, '6395580153', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, '5', 6, '154330100177', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700051', 135, 'MOHAMED SID\'AHMED EL BECHIR', '2019-10-09', NULL, NULL, '5510281135', NULL, NULL, NULL, '2019-10-09', 95, 0, NULL, NULL, 108, NULL, NULL, 108, '154314100133', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700052', 136, 'MAOULOUD EL ATIGH SALICK', '2019-10-09', NULL, NULL, '3833220005', NULL, NULL, NULL, '2019-10-09', 97, 0, NULL, NULL, 110, NULL, NULL, 110, '154336100133', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700057', 137, 'SIDI MOHAMED MAHMOUD SALEM', '2019-10-09', NULL, NULL, '2606140226', NULL, NULL, NULL, '2019-10-09', 96, 0, NULL, NULL, 109, NULL, NULL, 109, '1504090009', 6, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700058', 138, 'SIDI GUEINE BOUGNEIBRE', '2019-10-09', NULL, NULL, '7826746186', NULL, NULL, NULL, '2019-10-09', 90, 0, NULL, NULL, 103, NULL, NULL, 103, '154248100194', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700061', 139, 'AICHETOU MOHAMED ABDALLAHI EL HASSEN', '2019-10-09', NULL, NULL, '0786752451', NULL, NULL, NULL, '2019-10-09', 82, 0, NULL, NULL, 95, NULL, NULL, 95, '00101620006', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700063', 140, 'AMINETOU BOUNA KENKO', '2019-10-09', NULL, NULL, '1931613090', NULL, NULL, NULL, '2019-10-09', 82, 0, NULL, NULL, 95, NULL, NULL, 95, '212036044010', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700067', 141, 'DAH BRAHIM BOUBACAR', '2019-10-09', NULL, NULL, '6652302390', NULL, NULL, NULL, '2019-10-09', 85, 0, NULL, NULL, 98, NULL, NULL, 98, '153209/25', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700069', 142, 'FATIMETOU SIDI EL MOKHTAR M\'BAREK', '2019-10-09', NULL, NULL, '6560091959', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '171699/39', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700070', 143, 'MOHAMED EL HAFED CHEIKH ZNEIKI', '2019-10-09', NULL, NULL, '9873027340', NULL, NULL, NULL, '2019-10-09', 82, 0, NULL, NULL, 95, NULL, NULL, 95, '41406', 17, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700072', 144, 'SID\'AHMED MOHAMED CHEINE', '2019-10-09', NULL, NULL, '6853941237', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '51979/08', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700077', 145, 'AGHEILA AHMEDOU LEKWEIRY', '2019-10-09', NULL, NULL, '5736819009', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '304105100172', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700078', 146, 'AMARNA MOHAMED BETTY', '2019-10-09', NULL, NULL, '1240691305', NULL, NULL, NULL, '2019-10-09', 85, 0, NULL, NULL, 95, NULL, NULL, 95, '154236100161', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700079', 147, 'DIAFARA IBRAHIMA BA', '2019-10-09', NULL, NULL, '0917457041', NULL, NULL, NULL, '2019-10-09', 88, 0, NULL, NULL, 101, NULL, NULL, 101, '118904100192', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700080', 148, 'BAMBA MOHAMED YAHYA BREIHMATT', '2019-10-09', NULL, NULL, '2459417541', NULL, NULL, NULL, '2019-10-09', 87, 0, NULL, NULL, 100, NULL, NULL, 100, '39563', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700081', 149, 'BEIBA ELBEKAYE SIDI ABDALLA', '2019-10-09', NULL, NULL, '0488284033', '32919132', NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '303106100165', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700082', 150, 'ABDERRAHMANE MAMADOU DIA', '2019-10-09', NULL, NULL, '9563059863', NULL, NULL, NULL, '2019-10-09', 38, 0, NULL, NULL, 12, NULL, NULL, 12, '42184', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700083', 151, 'DJIBY HAROUNA DIENG', '2019-10-09', NULL, NULL, '4444829740', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '6', NULL, '154319100171', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700084', 152, 'EL HASSEN FALL MOHAMED MOHAMED VALL', '2019-10-09', NULL, NULL, '6708003864', NULL, NULL, NULL, '2019-10-09', 85, 0, NULL, NULL, 98, NULL, NULL, 98, '154345100194', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700085', 153, 'EL HOUCEIN MOHAMEDHEN AHMEDNAH', '2019-10-09', NULL, NULL, '8644881822', NULL, NULL, NULL, '2019-10-09', 85, 0, NULL, NULL, 98, NULL, NULL, 98, '48818/82', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700086', 154, 'OUTHMANE N\'DIAYE EL HADJ MALICK DIA', '2019-10-09', NULL, NULL, '1064617390', NULL, NULL, NULL, '2019-10-09', 87, 0, NULL, NULL, 100, NULL, NULL, 100, '5392/89', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700087', 155, 'HOULEYE SILEYE DIA', '2019-10-09', NULL, NULL, '5288977090', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '303147100108', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700089', 156, 'MOHAMED BRAHIM ZEIDANE', '2019-10-09', NULL, NULL, '8982659975', NULL, NULL, NULL, '2019-10-09', 31, 0, NULL, NULL, 6, NULL, NULL, 6, '1542871100110', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700090', 157, 'MOHAMED AHMED SALEM KHATARY', '2019-10-09', NULL, NULL, '3780872985', NULL, NULL, NULL, '2019-10-09', 87, 0, NULL, NULL, 100, NULL, NULL, 100, '154481100180', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700091', 158, 'OUMAR MOHAMED H\'MEIDA', '2019-10-09', NULL, NULL, '6392383906', NULL, NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, 3, NULL, 7, '47243/54', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700094', 159, 'SEYIDA AOUBECK MAIMOUNE', '2019-10-09', NULL, NULL, '5276263300', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '5', NULL, '140100248456', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700098', 164, 'DIEYNABA HABIBOU THIAM', '2019-10-09', NULL, NULL, '0992487414', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '300925100157', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700101', 165, 'MARIEM MOHAMED BOUBAKAR', '2019-10-09', NULL, NULL, '2972520866', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '7', NULL, '00101600004', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700104', 166, 'SAMBA SOUVI N\'DIACK', '2019-10-09', NULL, NULL, '9776662690', NULL, NULL, NULL, '2019-10-09', 83, 0, NULL, NULL, 96, NULL, NULL, 96, '154323100182', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700105', 167, 'KHADIJETOU MAMADOU DIALLO', '2019-10-09', NULL, NULL, '5422878412', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '6', NULL, '327709100190', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700111', 168, 'MARIEME DAH LAGHLAL', '2019-10-09', NULL, NULL, '6286370569', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, 0, NULL, '6', 0, '01711240007', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700112', 169, 'MOHAMED AHMED HAMINE', '2019-10-09', NULL, NULL, '7094371742', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '5', NULL, '0100259536', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700116', 170, 'MOHAMED LAMRABOTT TEYIB', '2019-10-09', NULL, NULL, '5247061353', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '7', NULL, '327388100156', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700117', 171, 'SALEH BABA ELY MAHMOUD', '2019-10-09', NULL, NULL, '3387300529', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '6', NULL, '327373100139', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700120', 172, 'MARIEM EL BAR ELY', '2019-10-09', NULL, NULL, '9945513888', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '327256100181', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700121', 173, 'MOHAMED ALI AHMED MAHMOUD MOUDDI', '2019-10-09', NULL, NULL, '1489162916', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '01305110000', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700123', 174, 'EL MOKTAR BOURHANE MOHAMED ABDELLAHI', '2019-10-09', NULL, NULL, '8598681886', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '327258100138', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700129', 175, 'HEMED BRAHIM HEMEYADA', '2019-10-09', NULL, NULL, '9800742067', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '327195100183', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700133', 176, 'MOHAMEDOU BRAHIM BARKA', '2019-10-09', NULL, NULL, '5509187654', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '01651550000', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700065', 177, 'IBRAHIMA DAME FALL', '2019-10-09', NULL, NULL, '6298160531', NULL, NULL, NULL, '2019-10-09', 30, 0, NULL, NULL, 7, NULL, NULL, 7, '1506835001', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700135', 178, 'AHMEDOU MOHAMED SAFI', '2019-10-09', NULL, NULL, '3032004370', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '7', NULL, '46185/48', 13, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700137', 179, 'AMY AMARNA SAMBA EL VOULANY', '2019-10-09', NULL, NULL, '7031736902', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '8', NULL, '134267', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700142', 180, 'MOHAMED AHMED DIOP', '2019-10-09', NULL, NULL, '2897003844', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '134268', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700145', 181, 'SIDI ZEIN M\'HAIMED', '2019-10-09', NULL, NULL, '4421989635', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '134266', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700146', 182, 'ABDATT SID\'AHMED OULEIDOU', '2019-10-09', NULL, NULL, '4954073920', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '0150692920184', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700148', 183, 'FATIMETOU ELY M\'HAMED DICK', '2019-10-09', NULL, NULL, '2878785789', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '0150693330106', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700149', 184, 'HEBSSAYA MOHAMED SAMBA EL ABD', '2019-10-09', NULL, NULL, '9365373960', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '0150692790107', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700150', 185, 'LEGLAYB MOHAMED M\'HAIMMED', '2019-10-09', NULL, NULL, '5034805080', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '0150692930175', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700153', 186, 'BABA MAMADOU FALL', '2019-10-09', NULL, NULL, '1096943901', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '0150692780116', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700156', 187, 'ADAMA KALIDOU DIOP', '2019-10-09', NULL, NULL, '8227874554', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '6', NULL, '327696100130', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700157', 188, 'AMINA AZIZ CHEKROUNE', '2019-10-09', NULL, NULL, '6648357012', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '7', NULL, '171554/04', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700160', 189, 'MATY ALY MANE ALY MANE', '2019-10-09', NULL, NULL, '2950857177', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '7', NULL, '302975100120', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700161', 190, 'AHMETOU DEMDE LEKOUEIRY', '0000-00-00', NULL, NULL, '5017361376', NULL, NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '61180', NULL, '0', '0', '0', NULL, 'CENTRE CHEQUE POSTAUX', NULL, NULL),
(NULL, '1700162', 191, 'Moulaye Birame Isselmou', '2019-10-09', NULL, NULL, '1705661387', NULL, NULL, NULL, '2019-10-09', 30, NULL, NULL, NULL, 7, NULL, NULL, 7, '26737', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700166', 192, 'MOHAMED LEMINE MOHAMED VALL VALL', '2019-10-09', NULL, NULL, '3269216512', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '7', NULL, '026327488100140', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700171', 193, 'ISMAILA CIRE DEM', '2019-10-09', NULL, NULL, '4641591718', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '2164793010', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700168', 194, 'SLAME MOHAMED M\'BARECK', '2019-10-09', NULL, NULL, '9183373345', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '03010600008', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700169', 195, 'CHEIKH KABER AHMED', '2019-10-09', NULL, NULL, '4291901674', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '2164794010', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700176', 196, 'DEIJE ELWELY H\'MEIMED', '0000-00-00', NULL, NULL, '7291877128', NULL, NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '1031130', NULL, '0', '0', '0', NULL, 'CENTRE CHEQUES POSTAUX', NULL, NULL),
(NULL, '1700174', 197, 'DJIBY SADIO KONTE', '2019-10-09', NULL, NULL, '9510882496', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '34890', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700175', 198, 'KHDEIJA CHEIKH MOHAMED LEMINE', '2019-10-09', NULL, NULL, '8220728467', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '236554/2', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700178', 199, 'MOHAMED HIMIDE BRAHIM', '2019-10-09', NULL, NULL, '1394679387', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '5', NULL, '03764850101/38', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700179', 200, 'RAVA M\'HAMED KERKOUB', '0000-00-00', NULL, NULL, '6836368523', NULL, NULL, NULL, '0000-00-00', NULL, NULL, NULL, NULL, NULL, NULL, '6', NULL, '1031162', NULL, '0', '0', '0', NULL, 'CENTRE CHEQUES POSTAUX', NULL, NULL),
(NULL, '1700182', 201, 'MOULAY ISSELMOU BIRAME', '2019-10-09', NULL, NULL, '9738148161', NULL, NULL, NULL, '2019-10-09', NULL, 0, NULL, NULL, NULL, NULL, '7', NULL, '26737', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700183', 202, 'ISSAGA N\'GALAM WANE', '2019-10-09', NULL, NULL, '5302302271', NULL, NULL, NULL, '2019-10-09', 29, 0, NULL, NULL, 5, NULL, NULL, 5, '154488100175', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700184', 203, 'EL MOKTAR MOHAMED LEMINE DAHI', '2019-10-09', NULL, NULL, '9826431644', NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '7', NULL, '334940100166', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '088334B', 204, 'Wane Birane', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 40, NULL, NULL, NULL, 53, NULL, NULL, 53, '72 39 21', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '089071G', 205, 'Dicko Abdoul', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 41, NULL, NULL, NULL, 54, NULL, NULL, 54, '4 337 220 101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '057203B', 206, 'Dieng Aboubecrine', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 44, NULL, NULL, NULL, 57, NULL, NULL, 57, '01 55 51 10 986', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '104732N', 207, 'Yahya Babana Babana', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 46, NULL, NULL, NULL, 59, NULL, NULL, 59, '045 193 005 01-11', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '104733P', 208, 'Youssef Hmeity', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 51, NULL, NULL, NULL, 64, NULL, NULL, 64, '013042', 9, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '102788A', 209, 'Seyidi Mohamed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 34, NULL, NULL, NULL, 34, NULL, NULL, 34, '3000463', 11, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '077320T', 210, 'Halima Kamara', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 34, NULL, NULL, NULL, 13, NULL, NULL, 13, NULL, 12, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '91320K', 211, 'Melainine Cheikh Chewaf', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 53, NULL, NULL, NULL, 66, NULL, NULL, 66, NULL, 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '103097L', 212, 'Hamady Mohamed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 55, NULL, NULL, NULL, 68, NULL, NULL, 68, '43 62 36 01 01', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '13089C', 213, 'Eboubekrin Yahya', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 66, NULL, NULL, NULL, 79, NULL, NULL, 79, '130131-23', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '088907M', 214, 'Jemila Mohamed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 75, NULL, NULL, NULL, 88, NULL, NULL, 88, '1396620101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700006', 215, 'Aminetou Fall', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 76, NULL, NULL, NULL, 89, NULL, NULL, 89, '1506820701', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700016', 216, 'Zeinebou Keyna', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 76, NULL, NULL, NULL, 89, NULL, NULL, 89, '90000195139', 13, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700014', 217, 'Nana Salama', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 77, NULL, NULL, NULL, 90, NULL, NULL, 90, '01543370101-72', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '170002', 218, 'Abdallahi Sidi Cheikh', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 76, NULL, NULL, NULL, 89, NULL, NULL, 89, '1542970101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700027-2', 220, 'Baba Ahmed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '150645550152', 4, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097615C', 221, 'Marieme Mohamed Lemine', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '107102', 15, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '070509', 222, 'Bocar Diallo', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '10782', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '097618F', 223, 'Hadiyatou Kamara', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '40106430101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '072692K', 224, 'Ba Abou Gatta', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 12, NULL, NULL, 12, '931433', 3, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '099901M', 225, 'Mohamed Abdellahi Mohamed Lemine Chigz', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 38, NULL, NULL, NULL, 118, NULL, NULL, 118, '214480006', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '700365', 226, 'Mohamed Lopez', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 83, NULL, NULL, NULL, 96, NULL, NULL, 96, '5904165', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1200238', 227, 'Khadijetou Ismaila Cissé', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 29, NULL, NULL, NULL, 5, NULL, NULL, 5, '154162100103', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1200232', 228, 'Aicha Mohamed Bacar', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 29, NULL, NULL, NULL, 5, NULL, NULL, 5, '154108100100', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1200234', 229, 'Aminetou Cheikh', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 29, NULL, NULL, NULL, 5, NULL, NULL, 5, '1539790101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '100160T', 230, 'Cheikh El Bou', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 84, NULL, NULL, NULL, 97, NULL, NULL, 97, '0341638010159', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700027-3', 231, 'Mounina Mohamed', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 29, NULL, NULL, NULL, 5, NULL, NULL, 5, '309071100103', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043510S', 232, 'Harouna Mamadou', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 88, NULL, NULL, NULL, 101, NULL, NULL, 101, '8557', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '043508Q', 233, 'Djibril Idrissa Gueye', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 88, NULL, NULL, NULL, 101, NULL, NULL, 101, '2715300101', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1200123', 234, 'Fatimetou Mohamdane', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 89, NULL, NULL, NULL, 102, NULL, NULL, 102, '153874010149', 1, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '1700127', 235, 'Ibra Amadou Sy', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 30, NULL, NULL, NULL, 7, NULL, NULL, 7, '14259000728', 5, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '104873R', 236, 'Khaija Bouka', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, 19, NULL, NULL, 19, '28419-72', 2, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '099878M', 237, 'Ahmedou Sidi Med Med Moctar', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '4313090101', 1, '0', '0', '0', NULL, 'BMCI ALEG', NULL, NULL),
(NULL, '059325H', 238, 'Sid El Mahjoub Sidi Brahim', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 22, NULL, NULL, NULL, 35, NULL, NULL, 35, '9486', 18, '0', '0', '0', NULL, NULL, NULL, NULL),
(NULL, '046581F', 239, 'Dieng Papa Daouda', '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1159600101', 1, '0', '0', '0', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `dossier_individuel_backup_20191009134809`
--

CREATE TABLE IF NOT EXISTS `dossier_individuel_backup_20191009134809` (
  `photo` varchar(40) DEFAULT NULL,
  `matricule` varchar(255) DEFAULT NULL,
  `iddindividuel` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom_prenom` varchar(255) DEFAULT NULL,
  `date_naissance` date DEFAULT NULL,
  `matrimoniale` varchar(255) DEFAULT NULL,
  `enfants` varchar(255) 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,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `direction` int(10) UNSIGNED DEFAULT NULL,
  `service` int(10) UNSIGNED DEFAULT NULL,
  `division` int(10) UNSIGNED DEFAULT NULL,
  `categorie` int(10) UNSIGNED DEFAULT NULL,
  `statut` int(10) UNSIGNED DEFAULT NULL,
  `salaire` decimal(10,0) DEFAULT NULL,
  `prime_ts` int(10) UNSIGNED DEFAULT NULL,
  `compte` varchar(255) DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `total_income` decimal(10,0) DEFAULT '0',
  `total_expense` decimal(10,0) DEFAULT '0',
  `available_budget` decimal(10,0) DEFAULT '0',
  `dossier` varchar(255) DEFAULT NULL,
  `observation` text,
  `contrat` varchar(255) DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`iddindividuel`),
  UNIQUE KEY `matricule_unique` (`matricule`),
  UNIQUE KEY `nni_unique` (`nni`),
  KEY `fonction` (`fonction`),
  KEY `direction` (`direction`),
  KEY `service` (`service`),
  KEY `division` (`division`),
  KEY `categorie` (`categorie`),
  KEY `statut` (`statut`),
  KEY `banque` (`banque`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `dossier_individuel_backup_20191009134809`
--

INSERT INTO `dossier_individuel_backup_20191009134809` (`photo`, `matricule`, `iddindividuel`, `nom_prenom`, `date_naissance`, `matrimoniale`, `enfants`, `nni`, `telephone`, `courriel`, `postale`, `date_recrutement`, `fonction`, `direction`, `service`, `division`, `categorie`, `statut`, `salaire`, `prime_ts`, `compte`, `banque`, `total_income`, `total_expense`, `available_budget`, `dossier`, `observation`, `contrat`, `cv`) VALUES
(NULL, NULL, 1, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, '2019-10-09', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '6812fe15184791937.zip', NULL, 'f0b723091e78dcb73.pdf', '6c1ba109944a6f1ac.pdf');

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

--
-- Table structure for table `etat_banques`
--

CREATE TABLE IF NOT EXISTS `etat_banques` (
  `id_etat_banque` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_banque` int(10) UNSIGNED DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `salaire` int(10) UNSIGNED DEFAULT NULL,
  `montant` decimal(10,0) DEFAULT '0',
  `qte` decimal(10,0) DEFAULT '1',
  `total` decimal(10,0) DEFAULT NULL,
  `n_compte` int(10) UNSIGNED DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id_etat_banque`),
  KEY `from_banque` (`from_banque`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `etat_paiements`
--

CREATE TABLE IF NOT EXISTS `etat_paiements` (
  `id_etat_paiement` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `from_paiements` int(10) UNSIGNED DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `prime` int(10) UNSIGNED DEFAULT NULL,
  `montant` decimal(10,0) DEFAULT '0',
  `qte` decimal(10,0) DEFAULT '1',
  `total` decimal(10,0) DEFAULT NULL,
  `n_compte` int(10) UNSIGNED DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id_etat_paiement`),
  KEY `from_paiements` (`from_paiements`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM AUTO_INCREMENT=232 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `etat_paiements`
--

INSERT INTO `etat_paiements` (`id_etat_paiement`, `from_paiements`, `matricule`, `nom_prenom`, `fonction`, `prime`, `montant`, `qte`, `total`, `n_compte`, `banque`) VALUES
(1, 1, 62, 62, 62, 62, '2000', '1', NULL, 62, 62),
(2, 1, 63, 63, 63, 63, '8000', '1', NULL, 63, 63),
(3, 1, 89, 89, 89, 89, '25000', '1', NULL, 89, 89),
(4, 1, 233, 233, 233, 233, '6000', '1', NULL, 233, 233),
(5, 1, 6, 6, 6, 6, '40000', '1', NULL, 6, 6),
(6, 1, 232, 232, 232, 232, '6000', '1', NULL, 232, 232),
(7, 1, 50, 50, 50, 50, '6000', '1', NULL, 50, 50),
(8, 1, 37, 37, 37, 37, '40000', '1', NULL, 37, 37),
(9, 1, 64, 64, 64, 64, '6000', '1', NULL, 64, 64),
(10, 1, 9, 9, 9, 9, '20000', '1', NULL, 9, 9),
(11, 1, 239, 239, 239, 239, '0', '1', NULL, 239, 239),
(12, 1, 65, 65, 65, 65, '3000', '1', NULL, 65, 65),
(13, 1, 90, 90, 90, 90, '20000', '1', NULL, 90, 90),
(14, 1, 20, 20, 20, 20, '40000', '1', NULL, 20, 20),
(15, 1, 51, 51, 51, 51, '10000', '1', NULL, 51, 51),
(16, 1, 66, 66, 66, 66, '6000', '1', NULL, 66, 66),
(17, 1, 67, 67, 67, 67, '40000', '1', NULL, 67, 67),
(18, 1, 68, 68, 68, 68, '6000', '1', NULL, 68, 68),
(19, 1, 206, 206, 206, 206, '50000', '1', NULL, 206, 206),
(20, 1, 91, 91, 91, 91, '30000', '1', NULL, 91, 91),
(21, 1, 92, 92, 92, 92, '30000', '1', NULL, 92, 92),
(22, 1, 14, 14, 14, 14, '50000', '1', NULL, 14, 14),
(23, 1, 14, 14, 14, 14, '50000', '1', NULL, 14, 14),
(24, 1, 238, 238, 238, 238, '20000', '1', NULL, 238, 238),
(25, 1, 43, 43, 43, 43, '40000', '1', NULL, 43, 43),
(26, 1, 107, 107, 107, 107, '3000', '1', NULL, 107, 107),
(27, 1, 108, 108, 108, 108, '8000', '1', NULL, 108, 108),
(28, 1, 109, 109, 109, 109, '8000', '1', NULL, 109, 109),
(29, 1, 112, 112, 112, 112, '8000', '1', NULL, 112, 112),
(30, 1, 126, 126, 126, 126, '6000', '1', NULL, 126, 126),
(31, 1, 126, 126, 126, 126, '6000', '1', NULL, 126, 126),
(32, 1, 113, 113, 113, 113, '6000', '1', NULL, 113, 113),
(33, 1, 114, 114, 114, 114, '4000', '1', NULL, 114, 114),
(34, 1, 114, 114, 114, 114, '4000', '1', NULL, 114, 114),
(35, 1, 115, 115, 115, 115, '4000', '1', NULL, 115, 115),
(36, 1, 117, 117, 117, 117, '4000', '1', NULL, 117, 117),
(37, 1, 127, 127, 127, 127, '4000', '1', NULL, 127, 127),
(38, 1, 118, 118, 118, 118, '8000', '1', NULL, 118, 118),
(39, 1, 129, 129, 129, 129, '6000', '1', NULL, 129, 129),
(40, 1, 222, 222, 222, 222, '8000', '1', NULL, 222, 222),
(41, 1, 57, 57, 57, 57, '10000', '1', NULL, 57, 57),
(42, 1, 54, 54, 54, 54, '8000', '1', NULL, 54, 54),
(43, 1, 59, 59, 59, 59, '8000', '1', NULL, 59, 59),
(44, 1, 44, 44, 44, 44, '8000', '1', NULL, 44, 44),
(45, 1, 60, 60, 60, 60, '40000', '1', NULL, 60, 60),
(46, 1, 94, 94, 94, 94, '8000', '1', NULL, 94, 94),
(47, 1, 21, 21, 21, 21, '40000', '1', NULL, 21, 21),
(48, 1, 10, 10, 10, 10, '20000', '1', NULL, 10, 10),
(49, 1, 224, 224, 224, 224, '8000', '1', NULL, 224, 224),
(50, 1, 83, 83, 83, 83, '40000', '1', NULL, 83, 83),
(51, 1, 93, 93, 93, 93, '6000', '1', NULL, 93, 93),
(52, 1, 27, 27, 27, 27, '8000', '1', NULL, 27, 27),
(53, 1, 210, 210, 210, 210, '20000', '1', NULL, 210, 210),
(54, 1, 13, 13, 13, 13, '50000', '1', NULL, 13, 13),
(55, 1, 29, 29, 29, 29, '40000', '1', NULL, 29, 29),
(56, 1, 16, 16, 16, 16, '50000', '1', NULL, 16, 16),
(57, 1, 30, 30, 30, 30, '40000', '1', NULL, 30, 30),
(58, 1, 8, 8, 8, 8, '5000', '1', NULL, 8, 8),
(59, 1, 45, 45, 45, 45, '8000', '1', NULL, 45, 45),
(60, 1, 38, 38, 38, 38, '40000', '1', NULL, 38, 38),
(61, 1, 55, 55, 55, 55, '8000', '1', NULL, 55, 55),
(62, 1, 84, 84, 84, 84, '50000', '1', NULL, 84, 84),
(63, 1, 69, 69, 69, 69, '10000', '1', NULL, 69, 69),
(64, 1, 80, 80, 80, 80, '40000', '1', NULL, 80, 80),
(65, 1, 204, 204, 204, 204, '50000', '1', NULL, 204, 204),
(66, 1, 214, 214, 214, 214, '10000', '1', NULL, 214, 214),
(67, 1, 205, 205, 205, 205, '50000', '1', NULL, 205, 205),
(68, 1, 85, 85, 85, 85, '25000', '1', NULL, 85, 85),
(69, 1, 15, 15, 15, 15, '50000', '1', NULL, 15, 15),
(70, 1, 17, 17, 17, 17, '40000', '1', NULL, 17, 17),
(71, 1, 40, 40, 40, 40, '50000', '1', NULL, 40, 40),
(72, 1, 31, 31, 31, 31, '50000', '1', NULL, 31, 31),
(73, 1, 70, 70, 70, 70, '10000', '1', NULL, 70, 70),
(74, 1, 48, 48, 48, 48, '50000', '1', NULL, 48, 48),
(75, 1, 24, 24, 24, 24, '8000', '1', NULL, 24, 24),
(76, 1, 46, 46, 46, 46, '40000', '1', NULL, 46, 46),
(77, 1, 71, 71, 71, 71, '40000', '1', NULL, 71, 71),
(78, 1, 26, 26, 26, 26, '8000', '1', NULL, 26, 26),
(79, 1, 12, 12, 12, 12, '40000', '1', NULL, 12, 12),
(80, 1, 72, 72, 72, 72, '8000', '1', NULL, 72, 72),
(81, 1, 32, 32, 32, 32, '8000', '1', NULL, 32, 32),
(82, 1, 73, 73, 73, 73, '8000', '1', NULL, 73, 73),
(83, 1, 221, 221, 221, 221, '8000', '1', NULL, 221, 221),
(84, 1, 58, 58, 58, 58, '8000', '1', NULL, 58, 58),
(85, 1, 41, 41, 41, 41, '8000', '1', NULL, 41, 41),
(86, 1, 223, 223, 223, 223, '8000', '1', NULL, 223, 223),
(87, 1, 19, 19, 19, 19, '8000', '1', NULL, 19, 19),
(88, 1, 49, 49, 49, 49, '8000', '1', NULL, 49, 49),
(89, 1, 22, 22, 22, 22, '8000', '1', NULL, 22, 22),
(90, 1, 95, 95, 95, 95, '8000', '1', NULL, 95, 95),
(91, 1, 33, 33, 33, 33, '8000', '1', NULL, 33, 33),
(92, 1, 74, 74, 74, 74, '8000', '1', NULL, 74, 74),
(93, 1, 75, 75, 75, 75, '8000', '1', NULL, 75, 75),
(94, 1, 88, 88, 88, 88, '8000', '1', NULL, 88, 88),
(95, 1, 7, 7, 7, 7, '40000', '1', NULL, 7, 7),
(96, 1, 76, 76, 76, 76, '8000', '1', NULL, 76, 76),
(97, 1, 28, 28, 28, 28, '8000', '1', NULL, 28, 28),
(98, 1, 11, 11, 11, 11, '8000', '1', NULL, 11, 11),
(99, 1, 61, 61, 61, 61, '8000', '1', NULL, 61, 61),
(100, 1, 237, 237, 237, 237, '0', '1', NULL, 237, 237),
(101, 1, 225, 225, 225, 225, '6000', '1', NULL, 225, 225),
(102, 1, 42, 42, 42, 42, '8000', '1', NULL, 42, 42),
(103, 1, 230, 230, 230, 230, '6000', '1', NULL, 230, 230),
(104, 1, 23, 23, 23, 23, '8000', '1', NULL, 23, 23),
(105, 1, 5, 5, 5, 5, '40000', '1', NULL, 5, 5),
(106, 1, 77, 77, 77, 77, '60000', '1', NULL, 77, 77),
(107, 1, 34, 34, 34, 34, '50000', '1', NULL, 34, 34),
(108, 1, 209, 209, 209, 209, '50000', '1', NULL, 209, 209),
(109, 1, 79, 79, 79, 79, '50000', '1', NULL, 79, 79),
(110, 1, 18, 18, 18, 18, '50000', '1', NULL, 18, 18),
(111, 1, 78, 78, 78, 78, '50000', '1', NULL, 78, 78),
(112, 1, 39, 39, 39, 39, '50000', '1', NULL, 39, 39),
(113, 1, 47, 47, 47, 47, '50000', '1', NULL, 47, 47),
(114, 1, 56, 56, 56, 56, '50000', '1', NULL, 56, 56),
(115, 1, 82, 82, 82, 82, '40000', '1', NULL, 82, 82),
(116, 1, 81, 81, 81, 81, '40000', '1', NULL, 81, 81),
(117, 1, 36, 36, 36, 36, '20000', '1', NULL, 36, 36),
(118, 1, 35, 35, 35, 35, '40000', '1', NULL, 35, 35),
(119, 1, 212, 212, 212, 212, '40000', '1', NULL, 212, 212),
(120, 1, 86, 86, 86, 86, '50000', '1', NULL, 86, 86),
(121, 1, 25, 25, 25, 25, '40000', '1', NULL, 25, 25),
(122, 1, 87, 87, 87, 87, '5000', '1', NULL, 87, 87),
(123, 1, 207, 207, 207, 207, '50000', '1', NULL, 207, 207),
(124, 1, 208, 208, 208, 208, '40000', '1', NULL, 208, 208),
(125, 1, 234, 234, 234, 234, '40000', '1', NULL, 234, 234),
(126, 1, 228, 228, 228, 228, '6000', '1', NULL, 228, 228),
(127, 1, 229, 229, 229, 229, '6000', '1', NULL, 229, 229),
(128, 1, 227, 227, 227, 227, '6000', '1', NULL, 227, 227),
(129, 1, 213, 213, 213, 213, '40000', '1', NULL, 213, 213),
(130, 1, 98, 98, 98, 98, '4000', '1', NULL, 98, 98),
(131, 1, 99, 99, 99, 99, '6000', '1', NULL, 99, 99),
(132, 1, 100, 100, 100, 100, '4000', '1', NULL, 100, 100),
(133, 1, 215, 215, 215, 215, '10000', '1', NULL, 215, 215),
(134, 1, 101, 101, 101, 101, '4000', '1', NULL, 101, 101),
(135, 1, 102, 102, 102, 102, '4000', '1', NULL, 102, 102),
(136, 1, 103, 103, 103, 103, '4000', '1', NULL, 103, 103),
(137, 1, 217, 217, 217, 217, '10000', '1', NULL, 217, 217),
(138, 1, 216, 216, 216, 216, '10000', '1', NULL, 216, 216),
(139, 1, 116, 116, 116, 116, '6000', '1', NULL, 116, 116),
(140, 1, 105, 105, 105, 105, '8000', '1', NULL, 105, 105),
(141, 1, 106, 106, 106, 106, '6000', '1', NULL, 106, 106),
(142, 1, 218, 218, 218, 218, '10000', '1', NULL, 218, 218),
(143, 1, 119, 119, 119, 119, '6000', '1', NULL, 119, 119),
(144, 1, 120, 120, 120, 120, '8000', '1', NULL, 120, 120),
(145, 1, 121, 121, 121, 121, '4000', '1', NULL, 121, 121),
(146, 1, 122, 122, 122, 122, '6000', '1', NULL, 122, 122),
(147, 1, 219, 219, 219, 219, '8000', '1', NULL, 219, 219),
(148, 1, 220, 220, 220, 220, '8000', '1', NULL, 220, 220),
(149, 1, 231, 231, 231, 231, '6000', '1', NULL, 231, 231),
(150, 1, 124, 124, 124, 124, '8000', '1', NULL, 124, 124),
(151, 1, 125, 125, 125, 125, '6000', '1', NULL, 125, 125),
(152, 1, 128, 128, 128, 128, '4000', '1', NULL, 128, 128),
(153, 1, 130, 130, 130, 130, '4000', '1', NULL, 130, 130),
(154, 1, 131, 131, 131, 131, '4000', '1', NULL, 131, 131),
(155, 1, 132, 132, 132, 132, '4000', '1', NULL, 132, 132),
(156, 1, 133, 133, 133, 133, '6000', '1', NULL, 133, 133),
(157, 1, 134, 134, 134, 134, '4000', '1', NULL, 134, 134),
(158, 1, 135, 135, 135, 135, '4000', '1', NULL, 135, 135),
(159, 1, 136, 136, 136, 136, '4000', '1', NULL, 136, 136),
(160, 1, 137, 137, 137, 137, '4000', '1', NULL, 137, 137),
(161, 1, 138, 138, 138, 138, '4000', '1', NULL, 138, 138),
(162, 1, 139, 139, 139, 139, '6000', '1', NULL, 139, 139),
(163, 1, 140, 140, 140, 140, '6000', '1', NULL, 140, 140),
(164, 1, 177, 177, 177, 177, '4000', '1', NULL, 177, 177),
(165, 1, 141, 141, 141, 141, '4000', '1', NULL, 141, 141),
(166, 1, 2, 2, 2, 2, '8000', '1', NULL, 2, 2),
(167, 1, 142, 142, 142, 142, '6000', '1', NULL, 142, 142),
(168, 1, 143, 143, 143, 143, '6000', '1', NULL, 143, 143),
(169, 1, 144, 144, 144, 144, '4000', '1', NULL, 144, 144),
(170, 1, 145, 145, 145, 145, '6000', '1', NULL, 145, 145),
(171, 1, 146, 146, 146, 146, '6000', '1', NULL, 146, 146),
(172, 1, 147, 147, 147, 147, '6000', '1', NULL, 147, 147),
(173, 1, 148, 148, 148, 148, '6000', '1', NULL, 148, 148),
(174, 1, 149, 149, 149, 149, '6000', '1', NULL, 149, 149),
(175, 1, 150, 150, 150, 150, '8000', '1', NULL, 150, 150),
(176, 1, 151, 151, 151, 151, '0', '1', NULL, 151, 151),
(177, 1, 152, 152, 152, 152, '6000', '1', NULL, 152, 152),
(178, 1, 153, 153, 153, 153, '6000', '1', NULL, 153, 153),
(179, 1, 154, 154, 154, 154, '6000', '1', NULL, 154, 154),
(180, 1, 155, 155, 155, 155, '6000', '1', NULL, 155, 155),
(181, 1, 96, 96, 96, 96, '6000', '1', NULL, 96, 96),
(182, 1, 156, 156, 156, 156, '4000', '1', NULL, 156, 156),
(183, 1, 157, 157, 157, 157, '6000', '1', NULL, 157, 157),
(184, 1, 158, 158, 158, 158, '4000', '1', NULL, 158, 158),
(185, 1, 159, 159, 159, 159, '0', '1', NULL, 159, 159),
(186, 1, 164, 164, 164, 164, '6000', '1', NULL, 164, 164),
(187, 1, 165, 165, 165, 165, '0', '1', NULL, 165, 165),
(188, 1, 166, 166, 166, 166, '6000', '1', NULL, 166, 166),
(189, 1, 167, 167, 167, 167, '0', '1', NULL, 167, 167),
(190, 1, 168, 168, 168, 168, '0', '1', NULL, 168, 168),
(191, 1, 169, 169, 169, 169, '0', '1', NULL, 169, 169),
(192, 1, 170, 170, 170, 170, '0', '1', NULL, 170, 170),
(193, 1, 171, 171, 171, 171, '0', '1', NULL, 171, 171),
(194, 1, 211, 211, 211, 211, '4000', '1', NULL, 211, 211),
(195, 1, 3, 3, 3, 3, '50000', '1', NULL, 3, 3),
(196, 1, 226, 226, 226, 226, '6000', '1', NULL, 226, 226),
(197, 1, 4, 4, 4, 4, '6000', '1', NULL, 4, 4),
(198, 1, 172, 172, 172, 172, '0', '1', NULL, 172, 172),
(199, 1, 173, 173, 173, 173, '0', '1', NULL, 173, 173),
(200, 1, 174, 174, 174, 174, '0', '1', NULL, 174, 174),
(201, 1, 235, 235, 235, 235, '4000', '1', NULL, 235, 235),
(202, 1, 175, 175, 175, 175, '0', '1', NULL, 175, 175),
(203, 1, 176, 176, 176, 176, '0', '1', NULL, 176, 176),
(204, 1, 178, 178, 178, 178, '0', '1', NULL, 178, 178),
(205, 1, 179, 179, 179, 179, '0', '1', NULL, 179, 179),
(206, 1, 180, 180, 180, 180, '0', '1', NULL, 180, 180),
(207, 1, 181, 181, 181, 181, '0', '1', NULL, 181, 181),
(208, 1, 182, 182, 182, 182, '0', '1', NULL, 182, 182),
(209, 1, 183, 183, 183, 183, '0', '1', NULL, 183, 183),
(210, 1, 184, 184, 184, 184, '0', '1', NULL, 184, 184),
(211, 1, 185, 185, 185, 185, '0', '1', NULL, 185, 185),
(212, 1, 186, 186, 186, 186, '0', '1', NULL, 186, 186),
(213, 1, 187, 187, 187, 187, '0', '1', NULL, 187, 187),
(214, 1, 188, 188, 188, 188, '0', '1', NULL, 188, 188),
(215, 1, 189, 189, 189, 189, '0', '1', NULL, 189, 189),
(216, 1, 190, 190, 190, 190, '0', '1', NULL, 190, 190),
(217, 1, 191, 191, 191, 191, '4000', '1', NULL, 191, 191),
(218, 1, 104, 104, 104, 104, '4000', '1', NULL, 104, 104),
(219, 1, 192, 192, 192, 192, '0', '1', NULL, 192, 192),
(220, 1, 194, 194, 194, 194, '0', '1', NULL, 194, 194),
(221, 1, 195, 195, 195, 195, '0', '1', NULL, 195, 195),
(222, 1, 193, 193, 193, 193, '0', '1', NULL, 193, 193),
(223, 1, 197, 197, 197, 197, '0', '1', NULL, 197, 197),
(224, 1, 198, 198, 198, 198, '0', '1', NULL, 198, 198),
(225, 1, 196, 196, 196, 196, '0', '1', NULL, 196, 196),
(226, 1, 199, 199, 199, 199, '0', '1', NULL, 199, 199),
(227, 1, 200, 200, 200, 200, '0', '1', NULL, 200, 200),
(228, 1, 97, 97, 97, 97, '4000', '1', NULL, 97, 97),
(229, 1, 201, 201, 201, 201, '0', '1', NULL, 201, 201),
(230, 1, 202, 202, 202, 202, '6000', '1', NULL, 202, 202),
(231, 1, 203, 203, 203, 203, '0', '1', NULL, 203, 203);

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

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

CREATE TABLE IF NOT EXISTS `expenses` (
  `idexpense` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `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` decimal(10,0) 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,
  PRIMARY KEY (`idexpense`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `fiche_pointages` (
  `id_fiche_pointage` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_fiche_pointage`),
  KEY `from_pointage` (`from_pointage`),
  KEY `nom_prenom_fp` (`nom_prenom_fp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `fonctions` (
  `idfonction` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fonction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idfonction`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8;

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

INSERT INTO `fonctions` (`idfonction`, `fonction`) VALUES
(1, 'Conseiller Technique chargé des Affaires Juridique'),
(2, 'Conseiller Technique chargé de l\'habitat et de la Promotion Immobilière'),
(3, 'Conseiller Technique chargé de l\'urbanisme et de la Topographie'),
(4, 'Conseiller Technique chargé des Bâtiments et Equipements Publique'),
(5, 'Cabinet du Ministre'),
(6, 'Société Nationale ISKAN'),
(7, 'Agence de Développement Urbain (ADU)'),
(8, 'Le Cabinet du Ministre'),
(9, 'Société Nationale ISKAN'),
(10, 'Agence de Développement Urbain (ADU)'),
(11, 'Agence Mauritanienne d\'Exécution des Travaux (AMEXTIPE)'),
(12, 'Le Chef de la Cellule de Communication'),
(13, 'Le Chef de la Cellule de Communication'),
(39, 'Chargé de mission'),
(15, 'Société Nationale ISKAN'),
(16, 'Agence de Développement Urbain (ADU)'),
(17, 'Le Cabinet du Ministre'),
(18, 'Secretaire Général'),
(19, 'les directions centrales'),
(20, 'Cabinet'),
(21, 'INSPECTEUR GENERAL'),
(22, 'Délégation Régionale'),
(23, 'Délégué Régional'),
(24, 'Conseiller'),
(25, 'Directeur Générale'),
(26, 'Conseiller Chargé de Mission'),
(27, 'Chef Division'),
(28, 'Chef Service'),
(29, 'Secretaire'),
(30, 'Chauffeur'),
(31, 'Planton'),
(32, 'Cader'),
(33, 'Directeur Général Adjoint'),
(34, 'INSPECTEUR'),
(35, 'Directeur Adjoint'),
(36, 'Directeur Général Adjoint'),
(37, 'TOPOGRAPHE'),
(38, 'Cadre'),
(40, 'Conseiller Habitat'),
(41, 'Conseiller Bâtiments'),
(42, 'Conseiller Urbanisme'),
(43, 'Conseiller Juridique'),
(44, 'Conseiller Aménagement du Territoire'),
(45, 'DG BEP'),
(46, 'DGHU'),
(47, 'DG ATAR'),
(48, 'IG'),
(49, 'Coordinateur Cellule Regroupement'),
(50, 'DGA BEP'),
(51, 'DAAF'),
(52, 'DEPC'),
(53, 'Cellule Informatique'),
(54, 'Chargé de la Communication'),
(55, 'DU/DGHU'),
(56, 'DE/DGBEP'),
(57, 'DT/DGBEP'),
(58, 'DCIG/DGATAR'),
(59, 'DH/DGHU'),
(60, 'DAT/DGATAR'),
(61, 'Délégué Régionale sud'),
(62, 'Délégué Régionale ouest'),
(63, 'Délégué Régionale nord'),
(64, 'Délégué Kiffa'),
(65, 'Délégué Néma'),
(66, 'Délégué Aïoun'),
(67, 'Délégué Akjoujt'),
(68, 'Délégué Aleg'),
(69, 'Délégué NDB'),
(70, 'Délégué Sélibaby'),
(71, 'Délégué Adrar'),
(72, 'Délégué Zouérat'),
(73, 'Délégué Rosso'),
(74, 'Chef de service DU'),
(75, 'Chef de service du personnel DAAF'),
(76, 'Chef de service Cabinet'),
(77, 'Chef de service des Marchés'),
(78, 'Chef de service DGATAR'),
(79, 'Chef de service DH'),
(80, 'Chef de service DEPC'),
(81, 'Technicien'),
(82, 'Agent comptable'),
(83, 'Agent administratif'),
(84, 'Garde du corps'),
(85, 'Agent contrôle'),
(86, 'Agent cartographie'),
(87, 'Agent technicien'),
(88, 'Agent topographe'),
(89, 'Femme de bureau'),
(90, 'Gardien'),
(91, 'Conducteur des Travaux Publique'),
(92, 'Chef d\'équipe'),
(93, 'Mécanicien'),
(94, 'Electricien'),
(95, 'Peintre'),
(96, 'Froid'),
(97, 'Manoeuvre'),
(98, 'DGAHU'),
(99, 'DGA ATAR');

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

--
-- Table structure for table `fonctions_backup_20191009131947`
--

CREATE TABLE IF NOT EXISTS `fonctions_backup_20191009131947` (
  `idfonction` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `fonction` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idfonction`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fonctions_backup_20191009131947`
--

INSERT INTO `fonctions_backup_20191009131947` (`idfonction`, `fonction`) VALUES
(1, 'Conseiller Technique chargé des Affaires Juridique'),
(2, 'Conseiller Technique chargé de l\'habitat et de la Promotion Immobilière'),
(3, 'Conseiller Technique chargé de l\'urbanisme et de la Topographie'),
(4, 'Conseiller Technique chargé des Bâtiments et Equipements Publique'),
(5, 'Cabinet du Ministre'),
(6, 'Société Nationale ISKAN'),
(7, 'Agence de Développement Urbain (ADU)');

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

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

CREATE TABLE IF NOT EXISTS `formations` (
  `idformation` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`idformation`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `gestion_prime`
--

CREATE TABLE IF NOT EXISTS `gestion_prime` (
  `idgestion_prime` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date_prime` date DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `prime` decimal(10,0) UNSIGNED DEFAULT NULL,
  `compte` int(10) UNSIGNED DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `mois` varchar(255) DEFAULT NULL,
  `annee` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idgestion_prime`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `gestion_salaire`
--

CREATE TABLE IF NOT EXISTS `gestion_salaire` (
  `idgestion_salaire` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date_salaire` date DEFAULT NULL,
  `matricule` int(10) UNSIGNED DEFAULT NULL,
  `nom_prenom` int(10) UNSIGNED DEFAULT NULL,
  `fonction` int(10) UNSIGNED DEFAULT NULL,
  `salaire` decimal(10,0) UNSIGNED DEFAULT NULL,
  `compte` int(10) UNSIGNED DEFAULT NULL,
  `banque` int(10) UNSIGNED DEFAULT NULL,
  `mois` varchar(255) DEFAULT NULL,
  `annee` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idgestion_salaire`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `incomes`
--

CREATE TABLE IF NOT EXISTS `incomes` (
  `income_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `client` int(10) UNSIGNED DEFAULT NULL,
  `amount` decimal(10,0) DEFAULT '0',
  PRIMARY KEY (`income_id`),
  KEY `client` (`client`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `informations` (
  `idinformation` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`idinformation`),
  KEY `matricule` (`matricule`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `les_banques`
--

CREATE TABLE IF NOT EXISTS `les_banques` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `banque` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `les_banques`
--

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

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

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

CREATE TABLE IF NOT EXISTS `main` (
  `idmain` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `main` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idmain`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `membership_grouppermissions`
--

CREATE TABLE IF NOT EXISTS `membership_grouppermissions` (
  `permissionID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `groupID` int(10) UNSIGNED DEFAULT NULL,
  `tableName` varchar(100) DEFAULT NULL,
  `allowInsert` tinyint(4) NOT NULL DEFAULT '0',
  `allowView` tinyint(4) NOT NULL DEFAULT '0',
  `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
  `allowDelete` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`permissionID`),
  UNIQUE KEY `groupID_tableName` (`groupID`,`tableName`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `membership_grouppermissions`
--

INSERT INTO `membership_grouppermissions` (`permissionID`, `groupID`, `tableName`, `allowInsert`, `allowView`, `allowEdit`, `allowDelete`) VALUES
(1, 2, 'main', 1, 3, 3, 3),
(2, 2, 'dossier_individuel', 1, 3, 3, 3),
(3, 2, 'gestion_salaire', 1, 3, 3, 3),
(4, 2, 'gestion_prime', 1, 3, 3, 3),
(5, 2, 'paiements', 1, 3, 3, 3),
(6, 2, 'etat_paiements', 1, 3, 3, 3),
(7, 2, 'banques', 1, 3, 3, 3),
(8, 2, 'etat_banques', 1, 3, 3, 3),
(9, 2, 'pointages', 1, 3, 3, 3),
(10, 2, 'fiche_pointages', 1, 3, 3, 3),
(11, 2, 'permissions', 1, 3, 3, 3),
(12, 2, 'conges', 1, 3, 3, 3),
(13, 2, 'demandes_permission', 1, 3, 3, 3),
(14, 2, 'demandes_conge_m', 1, 3, 3, 3),
(15, 2, 'demandes_permissions', 1, 3, 3, 3),
(16, 2, 'demandes_conge_sg', 1, 3, 3, 3),
(17, 2, 'conges_permissions', 1, 3, 3, 3),
(18, 2, 'demandes_conge', 1, 3, 3, 3),
(19, 2, 'cursus', 1, 3, 3, 3),
(20, 2, 'formations', 1, 3, 3, 3),
(21, 2, 'informations', 1, 3, 3, 3),
(22, 2, 'carrieres', 1, 3, 3, 3),
(23, 2, 'demandes', 1, 3, 3, 3),
(24, 2, 'fonctions', 1, 3, 3, 3),
(25, 2, 'directions', 1, 3, 3, 3),
(26, 2, 'services', 1, 3, 3, 3),
(27, 2, 'divisions', 1, 3, 3, 3),
(28, 2, 'les_banques', 1, 3, 3, 3),
(29, 2, 'carrieres_option', 1, 3, 3, 3),
(30, 2, 'statut', 1, 3, 3, 3),
(31, 2, 'missions', 1, 3, 3, 3),
(32, 2, 'ordres_missions', 1, 3, 3, 3),
(33, 2, 'decomptes', 1, 3, 3, 3),
(34, 2, 'details_decompte', 1, 3, 3, 3),
(35, 2, 'incomes', 1, 3, 3, 3),
(36, 2, 'expenses', 1, 3, 3, 3),
(37, 2, 'categorie_prime', 1, 3, 3, 3),
(38, 2, 'curriculum_vitae', 1, 3, 3, 3);

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

--
-- Table structure for table `membership_groups`
--

CREATE TABLE IF NOT EXISTS `membership_groups` (
  `groupID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `description` text,
  `allowSignup` tinyint(4) DEFAULT NULL,
  `needsApproval` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`groupID`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `membership_groups`
--

INSERT INTO `membership_groups` (`groupID`, `name`, `description`, `allowSignup`, `needsApproval`) VALUES
(1, 'anonymous', 'Anonymous group created automatically on 2019-10-09', 0, 0),
(2, 'Admins', 'Admin group created automatically on 2019-10-09', 0, 1);

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

--
-- Table structure for table `membership_userpermissions`
--

CREATE TABLE IF NOT EXISTS `membership_userpermissions` (
  `permissionID` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `memberID` varchar(100) NOT NULL,
  `tableName` varchar(100) DEFAULT NULL,
  `allowInsert` tinyint(4) NOT NULL DEFAULT '0',
  `allowView` tinyint(4) NOT NULL DEFAULT '0',
  `allowEdit` tinyint(4) NOT NULL DEFAULT '0',
  `allowDelete` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`permissionID`),
  UNIQUE KEY `memberID_tableName` (`memberID`,`tableName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `membership_userrecords`
--

CREATE TABLE IF NOT EXISTS `membership_userrecords` (
  `recID` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `tableName` varchar(100) DEFAULT NULL,
  `pkValue` varchar(255) DEFAULT NULL,
  `memberID` varchar(100) DEFAULT NULL,
  `dateAdded` bigint(20) UNSIGNED DEFAULT NULL,
  `dateUpdated` bigint(20) UNSIGNED DEFAULT NULL,
  `groupID` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`recID`),
  UNIQUE KEY `tableName_pkValue` (`tableName`,`pkValue`(150)),
  KEY `pkValue` (`pkValue`),
  KEY `tableName` (`tableName`),
  KEY `memberID` (`memberID`),
  KEY `groupID` (`groupID`)
) ENGINE=MyISAM AUTO_INCREMENT=805 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `membership_userrecords`
--

INSERT INTO `membership_userrecords` (`recID`, `tableName`, `pkValue`, `memberID`, `dateAdded`, `dateUpdated`, `groupID`) VALUES
(360, 'fonctions', '39', 'mhuat', 1570629301, 1570629301, 2),
(2, 'statut', '1', 'mhuat', 1570626725, 1570626725, 2),
(3, 'statut', '2', 'mhuat', 1570626751, 1570626750, 2),
(4, 'fonctions', '1', 'mhuat', 1570626915, 1570626915, 2),
(5, 'fonctions', '2', 'mhuat', 1570626950, 1570626950, 2),
(6, 'fonctions', '3', 'mhuat', 1570626991, 1570626991, 2),
(7, 'fonctions', '4', 'mhuat', 1570627013, 1570627013, 2),
(8, 'fonctions', '5', 'mhuat', 1570627028, 1570627028, 2),
(9, 'fonctions', '6', 'mhuat', 1570627045, 1570627045, 2),
(10, 'fonctions', '7', 'mhuat', 1570627068, 1570627068, 2),
(11, 'fonctions', '8', 'mhuat', 1570627205, 1570627205, 2),
(12, 'fonctions', '9', 'mhuat', 1570627205, 1570627205, 2),
(13, 'fonctions', '10', 'mhuat', 1570627205, 1570627205, 2),
(14, 'fonctions', '11', 'mhuat', 1570627205, 1570627205, 2),
(15, 'fonctions', '12', 'mhuat', 1570627205, 1570627205, 2),
(16, 'fonctions', '13', 'mhuat', 1570627205, 1570627205, 2),
(76, 'services', '4', 'mhuat', 1570627557, 1570627557, 2),
(18, 'fonctions', '15', 'mhuat', 1570627205, 1570627205, 2),
(19, 'fonctions', '16', 'mhuat', 1570627205, 1570627205, 2),
(20, 'fonctions', '17', 'mhuat', 1570627205, 1570627205, 2),
(21, 'fonctions', '18', 'mhuat', 1570627205, 1570627205, 2),
(22, 'fonctions', '19', 'mhuat', 1570627205, 1570627205, 2),
(23, 'fonctions', '20', 'mhuat', 1570627205, 1570627205, 2),
(24, 'fonctions', '21', 'mhuat', 1570627205, 1570629318, 2),
(25, 'fonctions', '22', 'mhuat', 1570627205, 1570627205, 2),
(26, 'fonctions', '23', 'mhuat', 1570627205, 1570627205, 2),
(27, 'fonctions', '24', 'mhuat', 1570627205, 1570627205, 2),
(28, 'fonctions', '25', 'mhuat', 1570627205, 1570627205, 2),
(29, 'fonctions', '26', 'mhuat', 1570627205, 1570627205, 2),
(30, 'fonctions', '27', 'mhuat', 1570627205, 1570627205, 2),
(31, 'fonctions', '28', 'mhuat', 1570627205, 1570627205, 2),
(32, 'fonctions', '29', 'mhuat', 1570627205, 1570627205, 2),
(33, 'fonctions', '30', 'mhuat', 1570627205, 1570646815, 2),
(34, 'fonctions', '31', 'mhuat', 1570627205, 1570627205, 2),
(35, 'fonctions', '32', 'mhuat', 1570627205, 1570627205, 2),
(36, 'fonctions', '33', 'mhuat', 1570627205, 1570627205, 2),
(37, 'fonctions', '34', 'mhuat', 1570627205, 1570627205, 2),
(38, 'fonctions', '35', 'mhuat', 1570627205, 1570627205, 2),
(39, 'fonctions', '36', 'mhuat', 1570627205, 1570627205, 2),
(40, 'fonctions', '37', 'mhuat', 1570627205, 1570627205, 2),
(41, 'fonctions', '38', 'mhuat', 1570627205, 1570627205, 2),
(43, 'directions', '2', 'mhuat', 1570627399, 1570627399, 2),
(44, 'directions', '3', 'mhuat', 1570627399, 1570627399, 2),
(45, 'directions', '4', 'mhuat', 1570627399, 1570627399, 2),
(46, 'directions', '5', 'mhuat', 1570627399, 1570627399, 2),
(47, 'directions', '6', 'mhuat', 1570627399, 1570627399, 2),
(48, 'directions', '7', 'mhuat', 1570627399, 1570627399, 2),
(49, 'directions', '8', 'mhuat', 1570627399, 1570627399, 2),
(75, 'services', '3', 'mhuat', 1570627557, 1570627557, 2),
(112, 'divisions', '10', 'mhuat', 1570627899, 1570627899, 2),
(52, 'directions', '11', 'mhuat', 1570627399, 1570627399, 2),
(107, 'divisions', '5', 'mhuat', 1570627899, 1570627899, 2),
(54, 'directions', '13', 'mhuat', 1570627399, 1570627399, 2),
(55, 'directions', '14', 'mhuat', 1570627399, 1570627399, 2),
(56, 'directions', '15', 'mhuat', 1570627399, 1570627399, 2),
(57, 'directions', '16', 'mhuat', 1570627399, 1570627399, 2),
(58, 'directions', '17', 'mhuat', 1570627399, 1570627399, 2),
(59, 'directions', '18', 'mhuat', 1570627399, 1570627399, 2),
(60, 'directions', '19', 'mhuat', 1570627399, 1570627399, 2),
(61, 'directions', '20', 'mhuat', 1570627399, 1570627399, 2),
(62, 'directions', '21', 'mhuat', 1570627399, 1570627399, 2),
(63, 'directions', '22', 'mhuat', 1570627399, 1570627399, 2),
(64, 'directions', '23', 'mhuat', 1570627399, 1570627399, 2),
(65, 'directions', '24', 'mhuat', 1570627399, 1570627399, 2),
(66, 'directions', '25', 'mhuat', 1570627399, 1570627399, 2),
(67, 'directions', '26', 'mhuat', 1570627399, 1570627399, 2),
(68, 'directions', '27', 'mhuat', 1570627399, 1570627399, 2),
(69, 'directions', '28', 'mhuat', 1570627399, 1570627399, 2),
(70, 'directions', '29', 'mhuat', 1570627399, 1570627399, 2),
(71, 'directions', '30', 'mhuat', 1570627399, 1570627399, 2),
(72, 'directions', '31', 'mhuat', 1570627399, 1570627399, 2),
(111, 'divisions', '9', 'mhuat', 1570627899, 1570627899, 2),
(78, 'services', '6', 'mhuat', 1570627557, 1570627557, 2),
(79, 'services', '7', 'mhuat', 1570627557, 1570627787, 2),
(80, 'services', '8', 'mhuat', 1570627557, 1570627557, 2),
(81, 'services', '9', 'mhuat', 1570627557, 1570627557, 2),
(82, 'services', '10', 'mhuat', 1570627557, 1570627557, 2),
(83, 'services', '11', 'mhuat', 1570627557, 1570627557, 2),
(84, 'services', '12', 'mhuat', 1570627557, 1570627557, 2),
(85, 'services', '13', 'mhuat', 1570627557, 1570627557, 2),
(86, 'services', '14', 'mhuat', 1570627557, 1570627557, 2),
(110, 'divisions', '8', 'mhuat', 1570627899, 1570627899, 2),
(88, 'services', '16', 'mhuat', 1570627557, 1570627557, 2),
(89, 'services', '17', 'mhuat', 1570627557, 1570627557, 2),
(90, 'services', '18', 'mhuat', 1570627557, 1570627557, 2),
(109, 'divisions', '7', 'mhuat', 1570627899, 1570627899, 2),
(92, 'services', '20', 'mhuat', 1570627557, 1570627812, 2),
(93, 'services', '21', 'mhuat', 1570627557, 1570627557, 2),
(94, 'services', '22', 'mhuat', 1570627557, 1570627557, 2),
(136, 'categorie_prime', '2', 'mhuat', 1570628027, 1570628027, 2),
(106, 'divisions', '4', 'mhuat', 1570627899, 1570627899, 2),
(108, 'divisions', '6', 'mhuat', 1570627899, 1570627899, 2),
(99, 'services', '27', 'mhuat', 1570627557, 1570627557, 2),
(137, 'categorie_prime', '3', 'mhuat', 1570628041, 1570628041, 2),
(138, 'categorie_prime', '4', 'mhuat', 1570628056, 1570628056, 2),
(102, 'services', '30', 'mhuat', 1570627557, 1570627829, 2),
(113, 'divisions', '11', 'mhuat', 1570627899, 1570627899, 2),
(114, 'divisions', '12', 'mhuat', 1570627899, 1570627899, 2),
(115, 'divisions', '13', 'mhuat', 1570627899, 1570627899, 2),
(116, 'divisions', '14', 'mhuat', 1570627899, 1570627899, 2),
(117, 'divisions', '15', 'mhuat', 1570627899, 1570627899, 2),
(118, 'divisions', '16', 'mhuat', 1570627899, 1570627899, 2),
(119, 'divisions', '17', 'mhuat', 1570627899, 1570627899, 2),
(120, 'divisions', '18', 'mhuat', 1570627899, 1570627899, 2),
(121, 'divisions', '19', 'mhuat', 1570627899, 1570627899, 2),
(122, 'divisions', '20', 'mhuat', 1570627899, 1570627899, 2),
(123, 'divisions', '21', 'mhuat', 1570627899, 1570627899, 2),
(124, 'divisions', '22', 'mhuat', 1570627899, 1570627899, 2),
(125, 'divisions', '23', 'mhuat', 1570627899, 1570627899, 2),
(126, 'divisions', '24', 'mhuat', 1570627899, 1570627899, 2),
(135, 'categorie_prime', '1', 'mhuat', 1570628013, 1570629080, 2),
(129, 'divisions', '27', 'mhuat', 1570627899, 1570627899, 2),
(130, 'divisions', '28', 'mhuat', 1570627899, 1570627899, 2),
(131, 'divisions', '29', 'mhuat', 1570627899, 1570627899, 2),
(132, 'divisions', '30', 'mhuat', 1570627899, 1570627899, 2),
(133, 'divisions', '31', 'mhuat', 1570627899, 1570627899, 2),
(134, 'divisions', '32', 'mhuat', 1570627899, 1570627899, 2),
(139, 'categorie_prime', '5', 'mhuat', 1570628076, 1570632514, 2),
(140, 'categorie_prime', '6', 'mhuat', 1570628086, 1570632608, 2),
(141, 'categorie_prime', '7', 'mhuat', 1570628097, 1570632570, 2),
(142, 'categorie_prime', '8', 'mhuat', 1570628111, 1570628111, 2),
(143, 'categorie_prime', '9', 'mhuat', 1570628125, 1570628125, 2),
(144, 'categorie_prime', '10', 'mhuat', 1570628139, 1570628139, 2),
(145, 'categorie_prime', '11', 'mhuat', 1570628152, 1570628152, 2),
(146, 'categorie_prime', '12', 'mhuat', 1570628162, 1570632352, 2),
(147, 'categorie_prime', '13', 'mhuat', 1570628193, 1570628193, 2),
(148, 'categorie_prime', '14', 'mhuat', 1570628211, 1570628211, 2),
(149, 'les_banques', '1', 'mhuat', 1570628360, 1570628360, 2),
(150, 'les_banques', '2', 'mhuat', 1570628366, 1570645980, 2),
(151, 'les_banques', '3', 'mhuat', 1570628375, 1570628375, 2),
(152, 'les_banques', '4', 'mhuat', 1570628383, 1570628383, 2),
(153, 'les_banques', '5', 'mhuat', 1570628394, 1570628394, 2),
(154, 'les_banques', '6', 'mhuat', 1570628407, 1570628407, 2),
(155, 'les_banques', '7', 'mhuat', 1570628413, 1570628413, 2),
(563, 'dossier_individuel', '232', 'mhuat', 1570646258, 1570655798, 2),
(157, 'les_banques', '9', 'mhuat', 1570628424, 1570628424, 2),
(158, 'les_banques', '10', 'mhuat', 1570628431, 1570628431, 2),
(159, 'les_banques', '11', 'mhuat', 1570628437, 1570628437, 2),
(160, 'les_banques', '12', 'mhuat', 1570628444, 1570628444, 2),
(161, 'les_banques', '13', 'mhuat', 1570628606, 1570628606, 2),
(162, 'les_banques', '14', 'mhuat', 1570628620, 1570628620, 2),
(163, 'les_banques', '15', 'mhuat', 1570628630, 1570628630, 2),
(164, 'les_banques', '16', 'mhuat', 1570628637, 1570628637, 2),
(165, 'les_banques', '17', 'mhuat', 1570628659, 1570628659, 2),
(166, 'dossier_individuel', '2', 'mhuat', 1570628899, 1570641575, 2),
(167, 'dossier_individuel', '3', 'mhuat', 1570628899, 1570648159, 2),
(168, 'dossier_individuel', '4', 'mhuat', 1570628899, 1570648297, 2),
(169, 'dossier_individuel', '5', 'mhuat', 1570628899, 1570638456, 2),
(170, 'dossier_individuel', '6', 'mhuat', 1570628899, 1570637990, 2),
(171, 'dossier_individuel', '7', 'mhuat', 1570628899, 1570638107, 2),
(172, 'dossier_individuel', '8', 'mhuat', 1570628899, 1570648510, 2),
(173, 'dossier_individuel', '9', 'mhuat', 1570628899, 1570648568, 2),
(174, 'dossier_individuel', '10', 'mhuat', 1570628899, 1570648638, 2),
(175, 'dossier_individuel', '11', 'mhuat', 1570628899, 1570648703, 2),
(176, 'dossier_individuel', '12', 'mhuat', 1570628899, 1570636456, 2),
(177, 'dossier_individuel', '13', 'mhuat', 1570628899, 1570655278, 2),
(178, 'dossier_individuel', '14', 'mhuat', 1570628899, 1570655345, 2),
(179, 'dossier_individuel', '15', 'mhuat', 1570628899, 1570655313, 2),
(180, 'dossier_individuel', '16', 'mhuat', 1570628899, 1570634686, 2),
(181, 'dossier_individuel', '17', 'mhuat', 1570628899, 1570636875, 2),
(182, 'dossier_individuel', '18', 'mhuat', 1570628899, 1570636329, 2),
(183, 'dossier_individuel', '19', 'mhuat', 1570628899, 1570640736, 2),
(184, 'dossier_individuel', '20', 'mhuat', 1570628899, 1570638691, 2),
(185, 'dossier_individuel', '21', 'mhuat', 1570628899, 1570638157, 2),
(186, 'dossier_individuel', '22', 'mhuat', 1570628899, 1570640990, 2),
(187, 'dossier_individuel', '23', 'mhuat', 1570628899, 1570648811, 2),
(188, 'dossier_individuel', '24', 'mhuat', 1570628899, 1570648862, 2),
(189, 'dossier_individuel', '25', 'mhuat', 1570628899, 1570636574, 2),
(190, 'dossier_individuel', '26', 'mhuat', 1570628899, 1570640037, 2),
(191, 'dossier_individuel', '27', 'mhuat', 1570628899, 1570648946, 2),
(192, 'dossier_individuel', '28', 'mhuat', 1570628899, 1570640784, 2),
(193, 'dossier_individuel', '29', 'mhuat', 1570628899, 1570636709, 2),
(194, 'dossier_individuel', '30', 'mhuat', 1570628899, 1570637708, 2),
(195, 'dossier_individuel', '31', 'mhuat', 1570628899, 1570634526, 2),
(196, 'dossier_individuel', '32', 'mhuat', 1570628899, 1570640166, 2),
(197, 'dossier_individuel', '33', 'mhuat', 1570628899, 1570639597, 2),
(198, 'dossier_individuel', '34', 'mhuat', 1570628899, 1570634590, 2),
(199, 'dossier_individuel', '35', 'mhuat', 1570628899, 1570637875, 2),
(200, 'dossier_individuel', '36', 'mhuat', 1570628899, 1570650618, 2),
(201, 'dossier_individuel', '37', 'mhuat', 1570628899, 1570638349, 2),
(202, 'dossier_individuel', '38', 'mhuat', 1570628899, 1570637819, 2),
(203, 'dossier_individuel', '39', 'mhuat', 1570628899, 1570635440, 2),
(204, 'dossier_individuel', '40', 'mhuat', 1570628899, 1570636395, 2),
(205, 'dossier_individuel', '41', 'mhuat', 1570628899, 1570649089, 2),
(206, 'dossier_individuel', '42', 'mhuat', 1570628899, 1570649125, 2),
(207, 'dossier_individuel', '43', 'mhuat', 1570628899, 1570638406, 2),
(208, 'dossier_individuel', '44', 'mhuat', 1570628899, 1570649161, 2),
(209, 'dossier_individuel', '45', 'mhuat', 1570628899, 1570640345, 2),
(210, 'dossier_individuel', '46', 'mhuat', 1570628899, 1570637652, 2),
(211, 'dossier_individuel', '47', 'mhuat', 1570628899, 1570650605, 2),
(212, 'dossier_individuel', '48', 'mhuat', 1570628899, 1570635212, 2),
(213, 'dossier_individuel', '49', 'mhuat', 1570628899, 1570640868, 2),
(214, 'dossier_individuel', '50', 'mhuat', 1570628899, 1570647607, 2),
(215, 'dossier_individuel', '51', 'mhuat', 1570628899, 1570639348, 2),
(216, 'dossier_individuel', '54', 'mhuat', 1570628899, 1570649273, 2),
(217, 'dossier_individuel', '55', 'mhuat', 1570628899, 1570649341, 2),
(218, 'dossier_individuel', '56', 'mhuat', 1570628899, 1570650585, 2),
(219, 'dossier_individuel', '57', 'mhuat', 1570628899, 1570639553, 2),
(220, 'dossier_individuel', '58', 'mhuat', 1570628899, 1570649429, 2),
(221, 'dossier_individuel', '59', 'mhuat', 1570628899, 1570640084, 2),
(222, 'dossier_individuel', '60', 'mhuat', 1570628899, 1570638579, 2),
(223, 'dossier_individuel', '61', 'mhuat', 1570628899, 1570640400, 2),
(224, 'dossier_individuel', '62', 'mhuat', 1570628899, 1570649525, 2),
(225, 'dossier_individuel', '63', 'mhuat', 1570628899, 1570649564, 2),
(226, 'dossier_individuel', '64', 'mhuat', 1570628899, 1570646334, 2),
(227, 'dossier_individuel', '65', 'mhuat', 1570628899, 1570649673, 2),
(228, 'dossier_individuel', '66', 'mhuat', 1570628899, 1570646618, 2),
(229, 'dossier_individuel', '67', 'mhuat', 1570628899, 1570638042, 2),
(230, 'dossier_individuel', '68', 'mhuat', 1570628899, 1570646398, 2),
(231, 'dossier_individuel', '69', 'mhuat', 1570628899, 1570639455, 2),
(232, 'dossier_individuel', '70', 'mhuat', 1570628899, 1570639398, 2),
(233, 'dossier_individuel', '71', 'mhuat', 1570628899, 1570637594, 2),
(234, 'dossier_individuel', '72', 'mhuat', 1570628899, 1570640831, 2),
(235, 'dossier_individuel', '73', 'mhuat', 1570628899, 1570640123, 2),
(236, 'dossier_individuel', '74', 'mhuat', 1570628899, 1570640516, 2),
(237, 'dossier_individuel', '75', 'mhuat', 1570628899, 1570640624, 2),
(238, 'dossier_individuel', '76', 'mhuat', 1570628899, 1570649753, 2),
(239, 'dossier_individuel', '77', 'mhuat', 1570628899, 1570634425, 2),
(240, 'dossier_individuel', '78', 'mhuat', 1570628899, 1570635490, 2),
(241, 'dossier_individuel', '79', 'mhuat', 1570628899, 1570634397, 2),
(242, 'dossier_individuel', '80', 'mhuat', 1570628899, 1570638212, 2),
(243, 'dossier_individuel', '81', 'mhuat', 1570628899, 1570638517, 2),
(244, 'dossier_individuel', '82', 'mhuat', 1570628899, 1570638645, 2),
(245, 'dossier_individuel', '83', 'mhuat', 1570628899, 1570637435, 2),
(246, 'dossier_individuel', '84', 'mhuat', 1570628899, 1570635020, 2),
(247, 'dossier_individuel', '85', 'mhuat', 1570628899, 1570649839, 2),
(248, 'dossier_individuel', '86', 'mhuat', 1570628899, 1570649895, 2),
(249, 'dossier_individuel', '87', 'mhuat', 1570628899, 1570649923, 2),
(250, 'dossier_individuel', '88', 'mhuat', 1570628899, 1570640689, 2),
(251, 'dossier_individuel', '89', 'mhuat', 1570628899, 1570649957, 2),
(252, 'dossier_individuel', '90', 'mhuat', 1570628899, 1570649990, 2),
(253, 'dossier_individuel', '91', 'mhuat', 1570628899, 1570638742, 2),
(254, 'dossier_individuel', '92', 'mhuat', 1570628899, 1570639504, 2),
(255, 'dossier_individuel', '93', 'mhuat', 1570628899, 1570643161, 2),
(256, 'dossier_individuel', '94', 'mhuat', 1570628899, 1570650022, 2),
(257, 'dossier_individuel', '95', 'mhuat', 1570628899, 1570640302, 2),
(258, 'dossier_individuel', '96', 'mhuat', 1570628899, 1570646120, 2),
(259, 'dossier_individuel', '97', 'mhuat', 1570628899, 1570647397, 2),
(260, 'dossier_individuel', '98', 'mhuat', 1570628899, 1570646786, 2),
(261, 'dossier_individuel', '99', 'mhuat', 1570628899, 1570650058, 2),
(262, 'dossier_individuel', '100', 'mhuat', 1570628899, 1570647825, 2),
(263, 'dossier_individuel', '101', 'mhuat', 1570628899, 1570650084, 2),
(264, 'dossier_individuel', '102', 'mhuat', 1570628899, 1570647432, 2),
(265, 'dossier_individuel', '103', 'mhuat', 1570628899, 1570647292, 2),
(266, 'dossier_individuel', '104', 'mhuat', 1570628899, 1570647254, 2),
(267, 'dossier_individuel', '105', 'mhuat', 1570628899, 1570650118, 2),
(268, 'dossier_individuel', '106', 'mhuat', 1570628899, 1570642809, 2),
(269, 'dossier_individuel', '107', 'mhuat', 1570628899, 1570650801, 2),
(270, 'dossier_individuel', '108', 'mhuat', 1570628899, 1570650849, 2),
(271, 'dossier_individuel', '109', 'mhuat', 1570628899, 1570650878, 2),
(272, 'dossier_individuel', '112', 'mhuat', 1570628899, 1570650911, 2),
(273, 'dossier_individuel', '113', 'mhuat', 1570628899, 1570643022, 2),
(274, 'dossier_individuel', '114', 'mhuat', 1570628899, 1570650940, 2),
(275, 'dossier_individuel', '115', 'mhuat', 1570628899, 1570647069, 2),
(276, 'dossier_individuel', '116', 'mhuat', 1570628899, 1570642758, 2),
(277, 'dossier_individuel', '117', 'mhuat', 1570628899, 1570647996, 2),
(278, 'dossier_individuel', '118', 'mhuat', 1570628899, 1570650970, 2),
(279, 'dossier_individuel', '119', 'mhuat', 1570628899, 1570641842, 2),
(280, 'dossier_individuel', '120', 'mhuat', 1570628899, 1570650996, 2),
(281, 'dossier_individuel', '121', 'mhuat', 1570628899, 1570647519, 2),
(282, 'dossier_individuel', '122', 'mhuat', 1570628899, 1570643098, 2),
(548, 'dossier_individuel', '219', 'mhuat', 1570639727, 1570639759, 2),
(284, 'dossier_individuel', '124', 'mhuat', 1570628899, 1570639820, 2),
(285, 'dossier_individuel', '125', 'mhuat', 1570628899, 1570645872, 2),
(286, 'dossier_individuel', '126', 'mhuat', 1570628899, 1570651035, 2),
(287, 'dossier_individuel', '127', 'mhuat', 1570628899, 1570647477, 2),
(288, 'dossier_individuel', '128', 'mhuat', 1570628899, 1570647699, 2),
(289, 'dossier_individuel', '129', 'mhuat', 1570628899, 1570642672, 2),
(290, 'dossier_individuel', '130', 'mhuat', 1570628899, 1570647744, 2),
(291, 'dossier_individuel', '131', 'mhuat', 1570628899, 1570647653, 2),
(292, 'dossier_individuel', '132', 'mhuat', 1570628899, 1570647554, 2),
(293, 'dossier_individuel', '133', 'mhuat', 1570628899, 1570643401, 2),
(294, 'dossier_individuel', '134', 'mhuat', 1570628899, 1570651984, 2),
(295, 'dossier_individuel', '135', 'mhuat', 1570628899, 1570647785, 2),
(296, 'dossier_individuel', '136', 'mhuat', 1570628899, 1570647916, 2),
(297, 'dossier_individuel', '137', 'mhuat', 1570628899, 1570647862, 2),
(298, 'dossier_individuel', '138', 'mhuat', 1570628899, 1570647180, 2),
(299, 'dossier_individuel', '139', 'mhuat', 1570628899, 1570641630, 2),
(300, 'dossier_individuel', '140', 'mhuat', 1570628899, 1570641701, 2),
(301, 'dossier_individuel', '141', 'mhuat', 1570628899, 1570645831, 2),
(302, 'dossier_individuel', '142', 'mhuat', 1570628899, 1570642631, 2),
(303, 'dossier_individuel', '143', 'mhuat', 1570628899, 1570641752, 2),
(304, 'dossier_individuel', '144', 'mhuat', 1570628899, 1570647217, 2),
(305, 'dossier_individuel', '145', 'mhuat', 1570628899, 1570642472, 2),
(306, 'dossier_individuel', '146', 'mhuat', 1570628899, 1570645787, 2),
(307, 'dossier_individuel', '147', 'mhuat', 1570628899, 1570646447, 2),
(308, 'dossier_individuel', '148', 'mhuat', 1570628899, 1570646071, 2),
(309, 'dossier_individuel', '149', 'mhuat', 1570628899, 1570642513, 2),
(310, 'dossier_individuel', '150', 'mhuat', 1570628899, 1570641215, 2),
(311, 'dossier_individuel', '151', 'mhuat', 1570628899, 1570651576, 2),
(312, 'dossier_individuel', '152', 'mhuat', 1570628899, 1570643546, 2),
(313, 'dossier_individuel', '153', 'mhuat', 1570628899, 1570645672, 2),
(314, 'dossier_individuel', '154', 'mhuat', 1570628899, 1570646175, 2),
(315, 'dossier_individuel', '155', 'mhuat', 1570628899, 1570642406, 2),
(316, 'dossier_individuel', '156', 'mhuat', 1570628899, 1570647356, 2),
(317, 'dossier_individuel', '157', 'mhuat', 1570628899, 1570646216, 2),
(318, 'dossier_individuel', '158', 'mhuat', 1570628899, 1570648063, 2),
(319, 'dossier_individuel', '159', 'mhuat', 1570628899, 1570651603, 2),
(320, 'dossier_individuel', '164', 'mhuat', 1570628899, 1570642560, 2),
(321, 'dossier_individuel', '165', 'mhuat', 1570628899, 1570651620, 2),
(322, 'dossier_individuel', '166', 'mhuat', 1570628899, 1570641791, 2),
(323, 'dossier_individuel', '167', 'mhuat', 1570628899, 1570651634, 2),
(324, 'dossier_individuel', '168', 'mhuat', 1570628899, 1570651647, 2),
(325, 'dossier_individuel', '169', 'mhuat', 1570628899, 1570651668, 2),
(326, 'dossier_individuel', '170', 'mhuat', 1570628899, 1570651681, 2),
(327, 'dossier_individuel', '171', 'mhuat', 1570628899, 1570651705, 2),
(328, 'dossier_individuel', '172', 'mhuat', 1570628899, 1570651744, 2),
(329, 'dossier_individuel', '173', 'mhuat', 1570628899, 1570651832, 2),
(330, 'dossier_individuel', '174', 'mhuat', 1570628899, 1570651849, 2),
(331, 'dossier_individuel', '175', 'mhuat', 1570628899, 1570651863, 2),
(332, 'dossier_individuel', '176', 'mhuat', 1570628899, 1570651875, 2),
(333, 'dossier_individuel', '177', 'mhuat', 1570628899, 1570647127, 2),
(334, 'dossier_individuel', '178', 'mhuat', 1570628899, 1570652212, 2),
(335, 'dossier_individuel', '179', 'mhuat', 1570628899, 1570652226, 2),
(336, 'dossier_individuel', '180', 'mhuat', 1570628899, 1570652238, 2),
(337, 'dossier_individuel', '181', 'mhuat', 1570628899, 1570652251, 2),
(338, 'dossier_individuel', '182', 'mhuat', 1570628899, 1570652268, 2),
(339, 'dossier_individuel', '183', 'mhuat', 1570628899, 1570652282, 2),
(340, 'dossier_individuel', '184', 'mhuat', 1570628899, 1570652293, 2),
(341, 'dossier_individuel', '185', 'mhuat', 1570628899, 1570652311, 2),
(342, 'dossier_individuel', '186', 'mhuat', 1570628899, 1570652322, 2),
(343, 'dossier_individuel', '187', 'mhuat', 1570628899, 1570652332, 2),
(344, 'dossier_individuel', '188', 'mhuat', 1570628899, 1570652349, 2),
(345, 'dossier_individuel', '189', 'mhuat', 1570628899, 1570652360, 2),
(346, 'dossier_individuel', '190', 'mhuat', 1570628899, 1570628899, 2),
(347, 'dossier_individuel', '191', 'mhuat', 1570628899, 1570646936, 2),
(348, 'dossier_individuel', '192', 'mhuat', 1570628899, 1570652422, 2),
(349, 'dossier_individuel', '193', 'mhuat', 1570628899, 1570652437, 2),
(350, 'dossier_individuel', '194', 'mhuat', 1570628899, 1570652447, 2),
(351, 'dossier_individuel', '195', 'mhuat', 1570628899, 1570652460, 2),
(352, 'dossier_individuel', '196', 'mhuat', 1570628899, 1570628899, 2),
(353, 'dossier_individuel', '197', 'mhuat', 1570628899, 1570652484, 2),
(354, 'dossier_individuel', '198', 'mhuat', 1570628899, 1570652498, 2),
(355, 'dossier_individuel', '199', 'mhuat', 1570628899, 1570652509, 2),
(356, 'dossier_individuel', '200', 'mhuat', 1570628899, 1570628899, 2),
(357, 'dossier_individuel', '201', 'mhuat', 1570628899, 1570652527, 2),
(358, 'dossier_individuel', '202', 'mhuat', 1570628899, 1570642718, 2),
(359, 'dossier_individuel', '203', 'mhuat', 1570628899, 1570652541, 2),
(361, 'fonctions', '40', 'mhuat', 1570629344, 1570629344, 2),
(362, 'fonctions', '41', 'mhuat', 1570629378, 1570629378, 2),
(363, 'fonctions', '42', 'mhuat', 1570629520, 1570629520, 2),
(364, 'fonctions', '43', 'mhuat', 1570629529, 1570629529, 2),
(365, 'fonctions', '44', 'mhuat', 1570629550, 1570629550, 2),
(366, 'fonctions', '45', 'mhuat', 1570629559, 1570629559, 2),
(367, 'fonctions', '46', 'mhuat', 1570629566, 1570629566, 2),
(368, 'fonctions', '47', 'mhuat', 1570629584, 1570629584, 2),
(369, 'fonctions', '48', 'mhuat', 1570629687, 1570629687, 2),
(370, 'statut', '3', 'mhuat', 1570630105, 1570630105, 2),
(371, 'statut', '4', 'mhuat', 1570630121, 1570630121, 2),
(372, 'statut', '5', 'mhuat', 1570630130, 1570630130, 2),
(373, 'directions', '32', 'mhuat', 1570630171, 1570630171, 2),
(374, 'directions', '33', 'mhuat', 1570630215, 1570630215, 2),
(375, 'directions', '34', 'mhuat', 1570630231, 1570630231, 2),
(376, 'directions', '35', 'mhuat', 1570630503, 1570630503, 2),
(377, 'directions', '36', 'mhuat', 1570630515, 1570630515, 2),
(378, 'directions', '37', 'mhuat', 1570630525, 1570630525, 2),
(379, 'directions', '38', 'mhuat', 1570630538, 1570630538, 2),
(380, 'fonctions', '49', 'mhuat', 1570630647, 1570630647, 2),
(381, 'fonctions', '50', 'mhuat', 1570630674, 1570630674, 2),
(382, 'fonctions', '51', 'mhuat', 1570630685, 1570630685, 2),
(383, 'fonctions', '52', 'mhuat', 1570630692, 1570630692, 2),
(384, 'fonctions', '53', 'mhuat', 1570630720, 1570630720, 2),
(385, 'fonctions', '54', 'mhuat', 1570630730, 1570630730, 2),
(386, 'fonctions', '55', 'mhuat', 1570630741, 1570630741, 2),
(387, 'fonctions', '56', 'mhuat', 1570630751, 1570630751, 2),
(388, 'fonctions', '57', 'mhuat', 1570630777, 1570630777, 2),
(389, 'fonctions', '58', 'mhuat', 1570630796, 1570630796, 2),
(390, 'fonctions', '59', 'mhuat', 1570630805, 1570630805, 2),
(391, 'fonctions', '60', 'mhuat', 1570630815, 1570630815, 2),
(392, 'fonctions', '61', 'mhuat', 1570630835, 1570630835, 2),
(393, 'fonctions', '62', 'mhuat', 1570630844, 1570630844, 2),
(394, 'fonctions', '63', 'mhuat', 1570630849, 1570630849, 2),
(395, 'fonctions', '64', 'mhuat', 1570630860, 1570630860, 2),
(396, 'fonctions', '65', 'mhuat', 1570630866, 1570630866, 2),
(397, 'fonctions', '66', 'mhuat', 1570630876, 1570630876, 2),
(398, 'fonctions', '67', 'mhuat', 1570630886, 1570630886, 2),
(399, 'fonctions', '68', 'mhuat', 1570630891, 1570630891, 2),
(400, 'fonctions', '69', 'mhuat', 1570630898, 1570630898, 2),
(401, 'fonctions', '70', 'mhuat', 1570630910, 1570630910, 2),
(402, 'fonctions', '71', 'mhuat', 1570630916, 1570630916, 2),
(403, 'fonctions', '72', 'mhuat', 1570630927, 1570630927, 2),
(404, 'fonctions', '73', 'mhuat', 1570630936, 1570630936, 2),
(405, 'fonctions', '74', 'mhuat', 1570630950, 1570630950, 2),
(406, 'fonctions', '75', 'mhuat', 1570630964, 1570630964, 2),
(407, 'fonctions', '76', 'mhuat', 1570630980, 1570630980, 2),
(408, 'fonctions', '77', 'mhuat', 1570630994, 1570630994, 2),
(409, 'fonctions', '78', 'mhuat', 1570631014, 1570631014, 2),
(410, 'fonctions', '79', 'mhuat', 1570631022, 1570631022, 2),
(411, 'fonctions', '80', 'mhuat', 1570631036, 1570631036, 2),
(412, 'fonctions', '81', 'mhuat', 1570631049, 1570631049, 2),
(413, 'fonctions', '82', 'mhuat', 1570631073, 1570631073, 2),
(414, 'fonctions', '83', 'mhuat', 1570631083, 1570631083, 2),
(415, 'fonctions', '84', 'mhuat', 1570631098, 1570631098, 2),
(416, 'fonctions', '85', 'mhuat', 1570631113, 1570631113, 2),
(417, 'fonctions', '86', 'mhuat', 1570631130, 1570631130, 2),
(418, 'fonctions', '87', 'mhuat', 1570631138, 1570631138, 2),
(419, 'fonctions', '88', 'mhuat', 1570631151, 1570631151, 2),
(420, 'fonctions', '89', 'mhuat', 1570631160, 1570631160, 2),
(421, 'fonctions', '90', 'mhuat', 1570631175, 1570631175, 2),
(422, 'fonctions', '91', 'mhuat', 1570631196, 1570631196, 2),
(423, 'fonctions', '92', 'mhuat', 1570631206, 1570631206, 2),
(424, 'fonctions', '93', 'mhuat', 1570631215, 1570631215, 2),
(425, 'fonctions', '94', 'mhuat', 1570631222, 1570631222, 2),
(426, 'fonctions', '95', 'mhuat', 1570631233, 1570631233, 2),
(427, 'fonctions', '96', 'mhuat', 1570631239, 1570631239, 2),
(428, 'fonctions', '97', 'mhuat', 1570631249, 1570631249, 2),
(429, 'categorie_prime', '15', 'mhuat', 1570631424, 1570631424, 2),
(430, 'categorie_prime', '16', 'mhuat', 1570631424, 1570631424, 2),
(431, 'categorie_prime', '17', 'mhuat', 1570631424, 1570631424, 2),
(432, 'categorie_prime', '18', 'mhuat', 1570631424, 1570631424, 2),
(433, 'categorie_prime', '19', 'mhuat', 1570631424, 1570653945, 2),
(434, 'categorie_prime', '20', 'mhuat', 1570631424, 1570631424, 2),
(435, 'categorie_prime', '21', 'mhuat', 1570631424, 1570631424, 2),
(436, 'categorie_prime', '22', 'mhuat', 1570631424, 1570631424, 2),
(437, 'categorie_prime', '23', 'mhuat', 1570631424, 1570631424, 2),
(438, 'categorie_prime', '24', 'mhuat', 1570631424, 1570631424, 2),
(439, 'categorie_prime', '25', 'mhuat', 1570631424, 1570631424, 2),
(440, 'categorie_prime', '26', 'mhuat', 1570631424, 1570631424, 2),
(441, 'categorie_prime', '27', 'mhuat', 1570631424, 1570631424, 2),
(442, 'categorie_prime', '28', 'mhuat', 1570631424, 1570631424, 2),
(443, 'categorie_prime', '29', 'mhuat', 1570631424, 1570631424, 2),
(444, 'categorie_prime', '30', 'mhuat', 1570631424, 1570631424, 2),
(446, 'categorie_prime', '32', 'mhuat', 1570631424, 1570631424, 2),
(447, 'categorie_prime', '33', 'mhuat', 1570631424, 1570650507, 2),
(448, 'categorie_prime', '34', 'mhuat', 1570631424, 1570634750, 2),
(449, 'categorie_prime', '35', 'mhuat', 1570631424, 1570650324, 2),
(451, 'categorie_prime', '37', 'mhuat', 1570631424, 1570631424, 2),
(452, 'categorie_prime', '38', 'mhuat', 1570631424, 1570631424, 2),
(453, 'categorie_prime', '39', 'mhuat', 1570631424, 1570631424, 2),
(454, 'categorie_prime', '40', 'mhuat', 1570631424, 1570631424, 2),
(568, 'dossier_individuel', '237', 'mhuat', 1570654240, 1570654335, 2),
(567, 'dossier_individuel', '236', 'mhuat', 1570653798, 1570654047, 2),
(566, 'dossier_individuel', '235', 'mhuat', 1570646976, 1570647031, 2),
(549, 'dossier_individuel', '220', 'mhuat', 1570639958, 1570639990, 2),
(460, 'categorie_prime', '46', 'mhuat', 1570631424, 1570631424, 2),
(531, 'dossier_individuel', '204', 'mhuat', 1570634872, 1570634923, 2),
(462, 'categorie_prime', '48', 'mhuat', 1570631424, 1570631424, 2),
(463, 'categorie_prime', '49', 'mhuat', 1570631424, 1570631424, 2),
(464, 'categorie_prime', '50', 'mhuat', 1570631424, 1570650407, 2),
(532, 'dossier_individuel', '205', 'mhuat', 1570635114, 1570635161, 2),
(466, 'categorie_prime', '52', 'mhuat', 1570631424, 1570631459, 2),
(467, 'categorie_prime', '53', 'mhuat', 1570631424, 1570634940, 2),
(468, 'categorie_prime', '54', 'mhuat', 1570631424, 1570631533, 2),
(469, 'categorie_prime', '55', 'mhuat', 1570631424, 1570635046, 2),
(470, 'categorie_prime', '56', 'mhuat', 1570631424, 1570635228, 2),
(471, 'categorie_prime', '57', 'mhuat', 1570631424, 1570631603, 2),
(472, 'categorie_prime', '58', 'mhuat', 1570631424, 1570631646, 2),
(473, 'categorie_prime', '59', 'mhuat', 1570631424, 1570631664, 2),
(474, 'categorie_prime', '60', 'mhuat', 1570631424, 1570631683, 2),
(475, 'categorie_prime', '61', 'mhuat', 1570631424, 1570631424, 2),
(476, 'categorie_prime', '62', 'mhuat', 1570631424, 1570631707, 2),
(477, 'categorie_prime', '63', 'mhuat', 1570631424, 1570631728, 2),
(478, 'categorie_prime', '64', 'mhuat', 1570631424, 1570636816, 2),
(479, 'categorie_prime', '65', 'mhuat', 1570631424, 1570636890, 2),
(480, 'categorie_prime', '66', 'mhuat', 1570631424, 1570631887, 2),
(481, 'categorie_prime', '67', 'mhuat', 1570631424, 1570631922, 2),
(482, 'categorie_prime', '68', 'mhuat', 1570631424, 1570631948, 2),
(483, 'categorie_prime', '69', 'mhuat', 1570631424, 1570631969, 2),
(484, 'categorie_prime', '70', 'mhuat', 1570631424, 1570631984, 2),
(485, 'categorie_prime', '71', 'mhuat', 1570631424, 1570632002, 2),
(486, 'categorie_prime', '72', 'mhuat', 1570631424, 1570632017, 2),
(487, 'categorie_prime', '73', 'mhuat', 1570631424, 1570632032, 2),
(488, 'categorie_prime', '74', 'mhuat', 1570631424, 1570632051, 2),
(489, 'categorie_prime', '75', 'mhuat', 1570631424, 1570632189, 2),
(490, 'categorie_prime', '76', 'mhuat', 1570631424, 1570632184, 2),
(491, 'categorie_prime', '77', 'mhuat', 1570631424, 1570632180, 2),
(492, 'categorie_prime', '78', 'mhuat', 1570631424, 1570632176, 2),
(493, 'categorie_prime', '79', 'mhuat', 1570631424, 1570632172, 2),
(494, 'categorie_prime', '80', 'mhuat', 1570631424, 1570632168, 2),
(495, 'categorie_prime', '81', 'mhuat', 1570631424, 1570632164, 2),
(496, 'categorie_prime', '82', 'mhuat', 1570631424, 1570632159, 2),
(497, 'categorie_prime', '83', 'mhuat', 1570631424, 1570632156, 2),
(498, 'categorie_prime', '84', 'mhuat', 1570631424, 1570632152, 2),
(499, 'categorie_prime', '85', 'mhuat', 1570631424, 1570632146, 2),
(500, 'categorie_prime', '86', 'mhuat', 1570631424, 1570632141, 2),
(501, 'categorie_prime', '87', 'mhuat', 1570631424, 1570632317, 2),
(502, 'categorie_prime', '88', 'mhuat', 1570631424, 1570632308, 2),
(503, 'categorie_prime', '89', 'mhuat', 1570631424, 1570632299, 2),
(504, 'categorie_prime', '90', 'mhuat', 1570631424, 1570632290, 2),
(505, 'categorie_prime', '91', 'mhuat', 1570631424, 1570632274, 2),
(506, 'categorie_prime', '92', 'mhuat', 1570631424, 1570632263, 2),
(507, 'categorie_prime', '93', 'mhuat', 1570631424, 1570632254, 2),
(508, 'categorie_prime', '94', 'mhuat', 1570631424, 1570632371, 2),
(509, 'categorie_prime', '95', 'mhuat', 1570631424, 1570632413, 2),
(510, 'categorie_prime', '96', 'mhuat', 1570631424, 1570632406, 2),
(511, 'categorie_prime', '97', 'mhuat', 1570631424, 1570632530, 2),
(512, 'categorie_prime', '98', 'mhuat', 1570631424, 1570632451, 2),
(513, 'categorie_prime', '99', 'mhuat', 1570631424, 1570632490, 2),
(514, 'categorie_prime', '100', 'mhuat', 1570631424, 1570632472, 2),
(515, 'categorie_prime', '101', 'mhuat', 1570631424, 1570632481, 2),
(516, 'categorie_prime', '102', 'mhuat', 1570631424, 1570632552, 2),
(517, 'categorie_prime', '103', 'mhuat', 1570631424, 1570632587, 2),
(518, 'categorie_prime', '104', 'mhuat', 1570631424, 1570632632, 2),
(519, 'categorie_prime', '105', 'mhuat', 1570631424, 1570632650, 2),
(520, 'categorie_prime', '106', 'mhuat', 1570631424, 1570632664, 2),
(521, 'categorie_prime', '107', 'mhuat', 1570631424, 1570632678, 2),
(522, 'categorie_prime', '108', 'mhuat', 1570631424, 1570632693, 2),
(523, 'categorie_prime', '109', 'mhuat', 1570631424, 1570632706, 2),
(524, 'categorie_prime', '110', 'mhuat', 1570631424, 1570632720, 2),
(525, 'categorie_prime', '111', 'mhuat', 1570631479, 1570631479, 2),
(526, 'categorie_prime', '112', 'mhuat', 1570631495, 1570631495, 2),
(527, 'categorie_prime', '113', 'mhuat', 1570631771, 1570631771, 2),
(528, 'categorie_prime', '114', 'mhuat', 1570631812, 1570631812, 2),
(529, 'categorie_prime', '115', 'mhuat', 1570631836, 1570631836, 2),
(530, 'categorie_prime', '116', 'mhuat', 1570631857, 1570631857, 2),
(533, 'dossier_individuel', '206', 'mhuat', 1570635309, 1570635354, 2),
(534, 'dossier_individuel', '207', 'mhuat', 1570635554, 1570636204, 2),
(535, 'fonctions', '98', 'mhuat', 1570636512, 1570636512, 2),
(536, 'fonctions', '99', 'mhuat', 1570636655, 1570636655, 2),
(537, 'dossier_individuel', '208', 'mhuat', 1570636757, 1570636790, 2),
(538, 'dossier_individuel', '209', 'mhuat', 1570637009, 1570655242, 2),
(539, 'dossier_individuel', '210', 'mhuat', 1570637143, 1570637171, 2),
(540, 'dossier_individuel', '211', 'mhuat', 1570637215, 1570637246, 2),
(541, 'dossier_individuel', '212', 'mhuat', 1570637484, 1570637525, 2),
(542, 'dossier_individuel', '213', 'mhuat', 1570638265, 1570638302, 2),
(543, 'dossier_individuel', '214', 'mhuat', 1570638820, 1570638866, 2),
(544, 'dossier_individuel', '215', 'mhuat', 1570638901, 1570638951, 2),
(545, 'dossier_individuel', '216', 'mhuat', 1570638989, 1570639035, 2),
(546, 'dossier_individuel', '217', 'mhuat', 1570639072, 1570639110, 2),
(547, 'dossier_individuel', '218', 'mhuat', 1570639135, 1570639207, 2),
(550, 'dossier_individuel', '221', 'mhuat', 1570640221, 1570640251, 2),
(551, 'dossier_individuel', '222', 'mhuat', 1570640438, 1570640478, 2),
(552, 'dossier_individuel', '223', 'mhuat', 1570641257, 1570641294, 2),
(553, 'dossier_individuel', '224', 'mhuat', 1570641352, 1570641385, 2),
(554, 'categorie_prime', '117', 'mhuat', 1570641548, 1570641548, 2),
(555, 'dossier_individuel', '225', 'mhuat', 1570641952, 1570642076, 2),
(556, 'categorie_prime', '118', 'mhuat', 1570642020, 1570642020, 2),
(557, 'dossier_individuel', '226', 'mhuat', 1570642115, 1570642152, 2),
(558, 'dossier_individuel', '227', 'mhuat', 1570642245, 1570642285, 2),
(559, 'dossier_individuel', '228', 'mhuat', 1570642330, 1570642364, 2),
(560, 'dossier_individuel', '229', 'mhuat', 1570642856, 1570642960, 2),
(561, 'dossier_individuel', '230', 'mhuat', 1570643223, 1570643263, 2),
(562, 'dossier_individuel', '231', 'mhuat', 1570643322, 1570643358, 2),
(564, 'dossier_individuel', '233', 'mhuat', 1570646501, 1570646535, 2),
(565, 'dossier_individuel', '234', 'mhuat', 1570646655, 1570646688, 2),
(569, 'dossier_individuel', '238', 'mhuat', 1570654605, 1570654704, 2),
(570, 'les_banques', '18', 'mhuat', 1570654675, 1570654675, 2),
(571, 'dossier_individuel', '239', 'mhuat', 1570655600, 1570655659, 2),
(572, 'paiements', '1', 'mhuat', 1570656827, 1570662757, 2),
(573, 'etat_paiements', '1', 'mhuat', 1570656844, 1570656844, 2),
(574, 'etat_paiements', '2', 'mhuat', 1570656857, 1570656857, 2),
(575, 'etat_paiements', '3', 'mhuat', 1570656866, 1570656866, 2),
(576, 'etat_paiements', '4', 'mhuat', 1570656874, 1570656874, 2),
(577, 'etat_paiements', '5', 'mhuat', 1570656883, 1570656882, 2),
(578, 'etat_paiements', '6', 'mhuat', 1570656893, 1570656893, 2),
(579, 'etat_paiements', '7', 'mhuat', 1570656899, 1570656899, 2),
(580, 'etat_paiements', '8', 'mhuat', 1570656913, 1570656913, 2),
(581, 'etat_paiements', '9', 'mhuat', 1570656924, 1570656924, 2),
(582, 'etat_paiements', '10', 'mhuat', 1570656936, 1570656936, 2),
(583, 'etat_paiements', '11', 'mhuat', 1570656952, 1570656952, 2),
(584, 'etat_paiements', '12', 'mhuat', 1570656971, 1570656971, 2),
(585, 'etat_paiements', '13', 'mhuat', 1570657009, 1570657009, 2),
(586, 'etat_paiements', '14', 'mhuat', 1570657038, 1570657038, 2),
(587, 'etat_paiements', '15', 'mhuat', 1570657069, 1570657069, 2),
(588, 'etat_paiements', '16', 'mhuat', 1570657087, 1570657087, 2),
(589, 'etat_paiements', '17', 'mhuat', 1570657102, 1570657569, 2),
(590, 'etat_paiements', '18', 'mhuat', 1570657149, 1570657149, 2),
(591, 'etat_paiements', '19', 'mhuat', 1570657166, 1570657166, 2),
(592, 'etat_paiements', '20', 'mhuat', 1570657187, 1570657187, 2),
(593, 'etat_paiements', '21', 'mhuat', 1570657203, 1570657203, 2),
(594, 'etat_paiements', '22', 'mhuat', 1570657220, 1570657220, 2),
(595, 'etat_paiements', '23', 'mhuat', 1570657238, 1570657631, 2),
(596, 'etat_paiements', '24', 'mhuat', 1570657263, 1570657263, 2),
(597, 'etat_paiements', '25', 'mhuat', 1570657281, 1570657281, 2),
(598, 'etat_paiements', '26', 'mhuat', 1570657298, 1570657298, 2),
(599, 'etat_paiements', '27', 'mhuat', 1570657327, 1570657327, 2),
(600, 'etat_paiements', '28', 'mhuat', 1570657353, 1570657353, 2),
(601, 'etat_paiements', '29', 'mhuat', 1570657362, 1570657362, 2),
(602, 'etat_paiements', '30', 'mhuat', 1570657376, 1570657376, 2),
(603, 'etat_paiements', '31', 'mhuat', 1570657411, 1570657659, 2),
(604, 'etat_paiements', '32', 'mhuat', 1570657426, 1570657426, 2),
(605, 'etat_paiements', '33', 'mhuat', 1570657462, 1570657462, 2),
(606, 'etat_paiements', '34', 'mhuat', 1570657734, 1570657734, 2),
(607, 'etat_paiements', '35', 'mhuat', 1570657749, 1570657749, 2),
(608, 'etat_paiements', '36', 'mhuat', 1570657763, 1570657763, 2),
(609, 'etat_paiements', '37', 'mhuat', 1570657784, 1570657784, 2),
(610, 'etat_paiements', '38', 'mhuat', 1570657800, 1570657800, 2),
(611, 'etat_paiements', '39', 'mhuat', 1570657816, 1570657816, 2),
(612, 'etat_paiements', '40', 'mhuat', 1570657834, 1570657834, 2),
(613, 'etat_paiements', '41', 'mhuat', 1570657851, 1570657851, 2),
(614, 'etat_paiements', '42', 'mhuat', 1570657869, 1570657869, 2),
(615, 'etat_paiements', '43', 'mhuat', 1570657884, 1570657884, 2),
(616, 'etat_paiements', '44', 'mhuat', 1570657896, 1570657896, 2),
(617, 'etat_paiements', '45', 'mhuat', 1570657915, 1570657915, 2),
(618, 'etat_paiements', '46', 'mhuat', 1570657930, 1570657930, 2),
(619, 'etat_paiements', '47', 'mhuat', 1570657949, 1570657949, 2),
(620, 'etat_paiements', '48', 'mhuat', 1570657966, 1570657966, 2),
(621, 'etat_paiements', '49', 'mhuat', 1570658052, 1570658052, 2),
(622, 'etat_paiements', '50', 'mhuat', 1570658076, 1570658076, 2),
(623, 'etat_paiements', '51', 'mhuat', 1570658094, 1570658094, 2),
(624, 'etat_paiements', '52', 'mhuat', 1570658130, 1570658130, 2),
(625, 'etat_paiements', '53', 'mhuat', 1570658182, 1570658182, 2),
(626, 'etat_paiements', '54', 'mhuat', 1570658207, 1570658207, 2),
(627, 'etat_paiements', '55', 'mhuat', 1570658223, 1570658223, 2),
(628, 'etat_paiements', '56', 'mhuat', 1570658315, 1570658315, 2),
(629, 'etat_paiements', '57', 'mhuat', 1570658341, 1570658341, 2),
(630, 'etat_paiements', '58', 'mhuat', 1570658389, 1570658389, 2),
(631, 'etat_paiements', '59', 'mhuat', 1570658412, 1570658412, 2),
(632, 'etat_paiements', '60', 'mhuat', 1570658481, 1570658481, 2),
(633, 'etat_paiements', '61', 'mhuat', 1570658524, 1570658524, 2),
(634, 'etat_paiements', '62', 'mhuat', 1570658549, 1570658549, 2),
(635, 'etat_paiements', '63', 'mhuat', 1570658620, 1570658620, 2),
(636, 'etat_paiements', '64', 'mhuat', 1570658661, 1570658661, 2),
(637, 'etat_paiements', '65', 'mhuat', 1570658683, 1570658683, 2),
(638, 'etat_paiements', '66', 'mhuat', 1570658719, 1570658719, 2),
(639, 'etat_paiements', '67', 'mhuat', 1570658740, 1570658740, 2),
(640, 'etat_paiements', '68', 'mhuat', 1570658787, 1570658787, 2),
(641, 'etat_paiements', '69', 'mhuat', 1570658814, 1570658814, 2),
(642, 'etat_paiements', '70', 'mhuat', 1570658840, 1570658840, 2),
(643, 'etat_paiements', '71', 'mhuat', 1570658871, 1570658871, 2),
(644, 'etat_paiements', '72', 'mhuat', 1570658886, 1570658886, 2),
(645, 'etat_paiements', '73', 'mhuat', 1570658907, 1570658907, 2),
(646, 'etat_paiements', '74', 'mhuat', 1570658930, 1570658930, 2),
(647, 'etat_paiements', '75', 'mhuat', 1570658957, 1570658957, 2),
(648, 'etat_paiements', '76', 'mhuat', 1570658998, 1570658998, 2),
(649, 'etat_paiements', '77', 'mhuat', 1570659010, 1570659010, 2),
(650, 'etat_paiements', '78', 'mhuat', 1570659042, 1570659042, 2),
(651, 'etat_paiements', '79', 'mhuat', 1570659103, 1570659103, 2),
(652, 'etat_paiements', '80', 'mhuat', 1570659129, 1570659129, 2),
(653, 'etat_paiements', '81', 'mhuat', 1570659163, 1570659163, 2),
(654, 'etat_paiements', '82', 'mhuat', 1570659180, 1570659180, 2),
(655, 'etat_paiements', '83', 'mhuat', 1570659209, 1570659209, 2),
(656, 'etat_paiements', '84', 'mhuat', 1570659232, 1570659232, 2),
(657, 'etat_paiements', '85', 'mhuat', 1570659255, 1570659255, 2),
(658, 'etat_paiements', '86', 'mhuat', 1570659396, 1570659396, 2),
(659, 'etat_paiements', '87', 'mhuat', 1570659434, 1570659434, 2),
(660, 'etat_paiements', '88', 'mhuat', 1570659451, 1570659451, 2),
(661, 'etat_paiements', '89', 'mhuat', 1570659469, 1570659469, 2),
(662, 'etat_paiements', '90', 'mhuat', 1570659494, 1570659494, 2),
(663, 'etat_paiements', '91', 'mhuat', 1570659510, 1570659510, 2),
(664, 'etat_paiements', '92', 'mhuat', 1570659521, 1570659521, 2),
(665, 'etat_paiements', '93', 'mhuat', 1570659535, 1570659535, 2),
(666, 'etat_paiements', '94', 'mhuat', 1570659547, 1570659547, 2),
(667, 'etat_paiements', '95', 'mhuat', 1570659569, 1570659569, 2),
(668, 'etat_paiements', '96', 'mhuat', 1570659591, 1570659591, 2),
(669, 'etat_paiements', '97', 'mhuat', 1570659606, 1570659606, 2),
(670, 'etat_paiements', '98', 'mhuat', 1570659621, 1570659621, 2),
(671, 'etat_paiements', '99', 'mhuat', 1570659641, 1570659641, 2),
(672, 'etat_paiements', '100', 'mhuat', 1570659668, 1570659668, 2),
(673, 'etat_paiements', '101', 'mhuat', 1570659715, 1570659715, 2),
(674, 'etat_paiements', '102', 'mhuat', 1570659733, 1570659733, 2),
(675, 'etat_paiements', '103', 'mhuat', 1570659750, 1570659750, 2),
(676, 'etat_paiements', '104', 'mhuat', 1570659768, 1570659768, 2),
(677, 'etat_paiements', '105', 'mhuat', 1570659785, 1570659785, 2),
(678, 'etat_paiements', '106', 'mhuat', 1570659806, 1570659806, 2),
(679, 'etat_paiements', '107', 'mhuat', 1570659833, 1570659833, 2),
(680, 'etat_paiements', '108', 'mhuat', 1570659858, 1570659858, 2),
(681, 'etat_paiements', '109', 'mhuat', 1570659875, 1570659875, 2),
(682, 'etat_paiements', '110', 'mhuat', 1570659894, 1570659894, 2),
(683, 'etat_paiements', '111', 'mhuat', 1570659914, 1570659914, 2),
(684, 'etat_paiements', '112', 'mhuat', 1570659936, 1570659936, 2),
(685, 'etat_paiements', '113', 'mhuat', 1570659957, 1570659957, 2),
(686, 'etat_paiements', '114', 'mhuat', 1570659975, 1570659975, 2),
(687, 'etat_paiements', '115', 'mhuat', 1570659998, 1570659998, 2),
(688, 'etat_paiements', '116', 'mhuat', 1570660013, 1570660013, 2),
(689, 'etat_paiements', '117', 'mhuat', 1570660039, 1570660039, 2),
(690, 'etat_paiements', '118', 'mhuat', 1570660078, 1570660078, 2),
(691, 'etat_paiements', '119', 'mhuat', 1570660671, 1570660671, 2),
(692, 'etat_paiements', '120', 'mhuat', 1570660692, 1570660692, 2),
(693, 'etat_paiements', '121', 'mhuat', 1570660717, 1570660717, 2),
(694, 'etat_paiements', '122', 'mhuat', 1570660739, 1570660739, 2),
(695, 'etat_paiements', '123', 'mhuat', 1570660765, 1570660765, 2),
(696, 'etat_paiements', '124', 'mhuat', 1570660785, 1570660785, 2),
(697, 'etat_paiements', '125', 'mhuat', 1570660814, 1570660814, 2),
(698, 'etat_paiements', '126', 'mhuat', 1570660834, 1570660834, 2),
(699, 'etat_paiements', '127', 'mhuat', 1570660848, 1570660848, 2),
(700, 'etat_paiements', '128', 'mhuat', 1570660860, 1570660860, 2),
(701, 'etat_paiements', '129', 'mhuat', 1570660881, 1570660881, 2),
(702, 'etat_paiements', '130', 'mhuat', 1570660901, 1570660901, 2),
(703, 'etat_paiements', '131', 'mhuat', 1570660919, 1570660919, 2),
(704, 'etat_paiements', '132', 'mhuat', 1570660942, 1570660942, 2),
(705, 'etat_paiements', '133', 'mhuat', 1570660961, 1570660961, 2),
(706, 'etat_paiements', '134', 'mhuat', 1570660993, 1570660993, 2),
(707, 'etat_paiements', '135', 'mhuat', 1570661012, 1570661012, 2),
(708, 'etat_paiements', '136', 'mhuat', 1570661020, 1570661020, 2),
(709, 'etat_paiements', '137', 'mhuat', 1570661051, 1570661051, 2),
(710, 'etat_paiements', '138', 'mhuat', 1570661091, 1570661091, 2),
(711, 'etat_paiements', '139', 'mhuat', 1570661102, 1570661102, 2),
(712, 'etat_paiements', '140', 'mhuat', 1570661115, 1570661115, 2),
(713, 'etat_paiements', '141', 'mhuat', 1570661126, 1570661126, 2),
(714, 'etat_paiements', '142', 'mhuat', 1570661229, 1570661229, 2),
(715, 'etat_paiements', '143', 'mhuat', 1570661249, 1570661249, 2),
(716, 'etat_paiements', '144', 'mhuat', 1570661263, 1570661263, 2),
(717, 'etat_paiements', '145', 'mhuat', 1570661277, 1570661277, 2),
(718, 'etat_paiements', '146', 'mhuat', 1570661291, 1570661291, 2),
(719, 'etat_paiements', '147', 'mhuat', 1570661305, 1570661305, 2),
(720, 'etat_paiements', '148', 'mhuat', 1570661314, 1570661314, 2),
(721, 'etat_paiements', '149', 'mhuat', 1570661336, 1570661336, 2),
(722, 'etat_paiements', '150', 'mhuat', 1570661353, 1570661353, 2),
(723, 'etat_paiements', '151', 'mhuat', 1570661364, 1570661364, 2),
(724, 'etat_paiements', '152', 'mhuat', 1570661381, 1570661381, 2),
(725, 'etat_paiements', '153', 'mhuat', 1570661391, 1570661391, 2),
(726, 'etat_paiements', '154', 'mhuat', 1570661404, 1570661404, 2),
(727, 'etat_paiements', '155', 'mhuat', 1570661417, 1570661417, 2),
(728, 'etat_paiements', '156', 'mhuat', 1570661434, 1570661434, 2),
(729, 'etat_paiements', '157', 'mhuat', 1570661450, 1570661450, 2),
(730, 'etat_paiements', '158', 'mhuat', 1570661462, 1570661462, 2),
(731, 'etat_paiements', '159', 'mhuat', 1570661475, 1570661475, 2),
(732, 'etat_paiements', '160', 'mhuat', 1570661486, 1570661486, 2),
(733, 'etat_paiements', '161', 'mhuat', 1570661501, 1570661501, 2),
(734, 'etat_paiements', '162', 'mhuat', 1570661522, 1570661522, 2),
(735, 'etat_paiements', '163', 'mhuat', 1570661531, 1570661531, 2),
(736, 'etat_paiements', '164', 'mhuat', 1570661542, 1570661542, 2),
(737, 'etat_paiements', '165', 'mhuat', 1570661551, 1570661551, 2),
(738, 'etat_paiements', '166', 'mhuat', 1570661562, 1570661562, 2),
(739, 'etat_paiements', '167', 'mhuat', 1570661573, 1570661573, 2),
(740, 'etat_paiements', '168', 'mhuat', 1570661620, 1570661620, 2),
(741, 'etat_paiements', '169', 'mhuat', 1570661631, 1570661631, 2),
(742, 'etat_paiements', '170', 'mhuat', 1570661642, 1570661642, 2),
(743, 'etat_paiements', '171', 'mhuat', 1570661648, 1570661648, 2),
(744, 'etat_paiements', '172', 'mhuat', 1570661655, 1570661655, 2),
(745, 'etat_paiements', '173', 'mhuat', 1570661673, 1570661673, 2),
(746, 'etat_paiements', '174', 'mhuat', 1570661679, 1570661679, 2),
(747, 'etat_paiements', '175', 'mhuat', 1570661692, 1570661692, 2),
(748, 'etat_paiements', '176', 'mhuat', 1570661701, 1570661701, 2),
(749, 'etat_paiements', '177', 'mhuat', 1570661713, 1570661713, 2),
(750, 'etat_paiements', '178', 'mhuat', 1570661720, 1570661720, 2),
(751, 'etat_paiements', '179', 'mhuat', 1570661728, 1570661728, 2),
(752, 'etat_paiements', '180', 'mhuat', 1570661737, 1570661737, 2),
(753, 'etat_paiements', '181', 'mhuat', 1570661745, 1570661745, 2),
(754, 'etat_paiements', '182', 'mhuat', 1570661755, 1570661755, 2),
(755, 'etat_paiements', '183', 'mhuat', 1570661783, 1570661783, 2),
(756, 'etat_paiements', '184', 'mhuat', 1570661794, 1570661794, 2),
(757, 'etat_paiements', '185', 'mhuat', 1570661802, 1570661802, 2),
(758, 'etat_paiements', '186', 'mhuat', 1570661811, 1570661811, 2),
(759, 'etat_paiements', '187', 'mhuat', 1570661851, 1570661851, 2),
(760, 'etat_paiements', '188', 'mhuat', 1570661864, 1570661864, 2),
(761, 'etat_paiements', '189', 'mhuat', 1570661880, 1570661880, 2),
(762, 'etat_paiements', '190', 'mhuat', 1570661900, 1570661900, 2),
(763, 'etat_paiements', '191', 'mhuat', 1570661906, 1570661906, 2),
(764, 'etat_paiements', '192', 'mhuat', 1570661915, 1570661915, 2),
(765, 'etat_paiements', '193', 'mhuat', 1570661935, 1570661935, 2),
(766, 'etat_paiements', '194', 'mhuat', 1570661969, 1570661969, 2),
(767, 'etat_paiements', '195', 'mhuat', 1570661993, 1570661993, 2),
(768, 'etat_paiements', '196', 'mhuat', 1570662015, 1570662015, 2),
(769, 'etat_paiements', '197', 'mhuat', 1570662033, 1570662033, 2),
(770, 'etat_paiements', '198', 'mhuat', 1570662310, 1570662310, 2),
(771, 'etat_paiements', '199', 'mhuat', 1570662330, 1570662330, 2),
(772, 'etat_paiements', '200', 'mhuat', 1570662345, 1570662345, 2),
(773, 'etat_paiements', '201', 'mhuat', 1570662371, 1570662371, 2),
(774, 'etat_paiements', '202', 'mhuat', 1570662386, 1570662386, 2),
(775, 'etat_paiements', '203', 'mhuat', 1570662417, 1570662417, 2),
(776, 'etat_paiements', '204', 'mhuat', 1570662428, 1570662428, 2),
(777, 'etat_paiements', '205', 'mhuat', 1570662441, 1570662441, 2),
(778, 'etat_paiements', '206', 'mhuat', 1570662540, 1570662540, 2),
(779, 'etat_paiements', '207', 'mhuat', 1570662548, 1570662548, 2),
(780, 'etat_paiements', '208', 'mhuat', 1570662555, 1570662555, 2),
(781, 'etat_paiements', '209', 'mhuat', 1570662562, 1570662562, 2),
(782, 'etat_paiements', '210', 'mhuat', 1570662569, 1570662569, 2),
(783, 'etat_paiements', '211', 'mhuat', 1570662577, 1570662577, 2),
(784, 'etat_paiements', '212', 'mhuat', 1570662583, 1570662583, 2),
(785, 'etat_paiements', '213', 'mhuat', 1570662589, 1570662589, 2),
(786, 'etat_paiements', '214', 'mhuat', 1570662595, 1570662595, 2),
(787, 'etat_paiements', '215', 'mhuat', 1570662604, 1570662604, 2),
(788, 'etat_paiements', '216', 'mhuat', 1570662611, 1570662611, 2),
(789, 'etat_paiements', '217', 'mhuat', 1570662621, 1570662621, 2),
(790, 'etat_paiements', '218', 'mhuat', 1570662629, 1570662629, 2),
(791, 'etat_paiements', '219', 'mhuat', 1570662638, 1570662638, 2),
(792, 'etat_paiements', '220', 'mhuat', 1570662644, 1570662644, 2),
(793, 'etat_paiements', '221', 'mhuat', 1570662651, 1570662651, 2),
(794, 'etat_paiements', '222', 'mhuat', 1570662658, 1570662658, 2),
(795, 'etat_paiements', '223', 'mhuat', 1570662664, 1570662664, 2),
(796, 'etat_paiements', '224', 'mhuat', 1570662670, 1570662670, 2),
(797, 'etat_paiements', '225', 'mhuat', 1570662681, 1570662681, 2);
INSERT INTO `membership_userrecords` (`recID`, `tableName`, `pkValue`, `memberID`, `dateAdded`, `dateUpdated`, `groupID`) VALUES
(798, 'etat_paiements', '226', 'mhuat', 1570662688, 1570662688, 2),
(799, 'etat_paiements', '227', 'mhuat', 1570662694, 1570662694, 2),
(800, 'etat_paiements', '228', 'mhuat', 1570662703, 1570662703, 2),
(801, 'etat_paiements', '229', 'mhuat', 1570662712, 1570662712, 2),
(802, 'etat_paiements', '230', 'mhuat', 1570662720, 1570662720, 2),
(803, 'etat_paiements', '231', 'mhuat', 1570662730, 1570662730, 2),
(804, 'banques', '1', 'mhuat', 1570662839, 1570662839, 2);

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

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

CREATE TABLE IF NOT EXISTS `missions` (
  `id_mission` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_mission`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `ordres_missions` (
  `id_ordre_mission` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_ordre_mission`),
  KEY `from_mission` (`from_mission`),
  KEY `nom_prenom` (`nom_prenom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `paiements`
--

CREATE TABLE IF NOT EXISTS `paiements` (
  `id_paiement` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `du` varchar(255) DEFAULT NULL,
  `au` varchar(255) DEFAULT NULL,
  `to_etat_paiements` varchar(255) DEFAULT NULL,
  `directeur` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_paiement`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `paiements`
--

INSERT INTO `paiements` (`id_paiement`, `date`, `du`, `au`, `to_etat_paiements`, `directeur`) VALUES
(1, '2019-10-09', 'OCTOBRE', 'OCTOBRE', NULL, 'Issaga Diagana');

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

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

CREATE TABLE IF NOT EXISTS `permissions` (
  `id_permission` int(3) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id_permission`),
  KEY `nom_prenom` (`nom_prenom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `pointages` (
  `id_pointages` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `to_fiche_pointage` varchar(255) DEFAULT NULL,
  `structure` int(10) UNSIGNED DEFAULT NULL,
  `mois` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_pointages`),
  KEY `structure` (`structure`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

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

CREATE TABLE IF NOT EXISTS `services` (
  `idservice` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `service` varchar(255) DEFAULT NULL,
  `from_direction` int(10) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`idservice`),
  KEY `from_direction` (`from_direction`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`idservice`, `service`, `from_direction`) VALUES
(3, 'Le Service du Secrétarial central', NULL),
(4, 'Le Service de la Traduction', NULL),
(6, 'Service des études et suivi', NULL),
(7, 'Service de l\'habita social', 3),
(8, 'Service de la promotion immobilière', NULL),
(9, 'Service des Etudes et Normes Urbaines', NULL),
(10, 'Service du Controle Urbain', NULL),
(11, 'Service des Opération Urbaines et de la Topographie', NULL),
(12, 'Service des Etudes Techniques et Architecturales', NULL),
(13, 'Service du Controle Technique des Bàtiments', NULL),
(14, 'Service des Agréments et de la classification', NULL),
(16, 'Service des travaux neufs', NULL),
(17, 'Service des réhabilitations', NULL),
(18, 'Service suivi des chantiers', NULL),
(20, 'Service de Personnel', 7),
(21, 'Service des Marches', NULL),
(22, 'Service de la Comptabilité', NULL),
(27, 'Service des Marches', NULL),
(30, 'Chef Service', 8);

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

--
-- Table structure for table `statut`
--

CREATE TABLE IF NOT EXISTS `statut` (
  `idstatut` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `statut` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idstatut`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `statut`
--

INSERT INTO `statut` (`idstatut`, `statut`) VALUES
(1, 'SANS AFFECTATION'),
(2, 'CADRE'),
(3, 'PNP'),
(4, 'FONCTIONNAIRE'),
(5, 'AUTRE');
COMMIT;

