-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:8889
-- Généré le :  Dim 27 oct. 2019 à 16:07
-- Version du serveur :  5.7.26
-- Version de PHP :  7.3.7


--
-- Base de données :  `auth_service`
--

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

--
-- Structure de la table `access`
--

CREATE TABLE `access` (
  `id` int(11) NOT NULL,
  `login` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `curseur` int(11) DEFAULT NULL,
  `last_access` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `access` (`id`, `login`, `ip`, `curseur`, `last_access`, `status`) VALUES
(1, 'pispa', '127.0.0.1', 0, '', 0);

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

--
-- Structure de la table `action`
--

CREATE TABLE `action` (
  `id` int(11) NOT NULL,
  `libelle` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  `module_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `action` (`id`, `libelle`, `route`, `status`, `date_creation`, `date_modification`, `module_id`) VALUES
(1, 'permissions entité', 'custom_permissions_entite', 1, NULL, NULL, 1),
(2, 'permissions entité (update)', 'custom_permissions_entite_update', 1, NULL, NULL, 1),
(3, 'permissions grant privileges', 'custom_permissions_setprivilege', 1, NULL, NULL, 2),
(4, 'API users Authentification', 'api_users_authentification', 1, NULL, NULL, 3),
(5, 'users (change status)', 'custom_users_status', 1, NULL, NULL, 3),
(6, 'permissions (generate)', 'custom_permissions_generate', 1, NULL, NULL, 2),
(7, 'API users (liste)', 'api_users_get_collection', 1, NULL, NULL, 3),
(8, 'API users (ajout)', 'api_users_post_collection', 1, NULL, NULL, 3),
(9, 'API users (détails)', 'api_users_get_item', 1, NULL, NULL, 3),
(10, 'API users (suppression)', 'api_users_delete_item', 1, NULL, NULL, 3),
(11, 'API users (modification)', 'api_users_put_item', 1, NULL, NULL, 3),
(12, 'API roles (liste)', 'api_roles_get_collection', 1, NULL, NULL, 4),
(13, 'API roles (ajout)', 'api_roles_post_collection', 1, NULL, NULL, 4),
(14, 'API roles (détails)', 'api_roles_get_item', 1, NULL, NULL, 4),
(15, 'API roles (suppression)', 'api_roles_delete_item', 1, NULL, NULL, 4),
(16, 'API roles (modification)', 'api_roles_put_item', 1, NULL, NULL, 4),
(17, 'API permissions (liste)', 'api_permissions_get_collection', 1, NULL, NULL, 1),
(18, 'API permissions (ajout)', 'api_permissions_post_collection', 1, NULL, NULL, 1),
(19, 'API permissions (détails)', 'api_permissions_get_item', 1, NULL, NULL, 1),
(20, 'API permissions (suppression)', 'api_permissions_delete_item', 1, NULL, NULL, 1),
(21, 'API permissions (modification)', 'api_permissions_put_item', 1, NULL, NULL, 1),
(22, 'API actions (liste)', 'api_actions_get_collection', 1, NULL, NULL, 5),
(23, 'API actions (ajout)', 'api_actions_post_collection', 1, NULL, NULL, 5),
(24, 'API actions (détails)', 'api_actions_get_item', 1, NULL, NULL, 5),
(25, 'API actions (suppression)', 'api_actions_delete_item', 1, NULL, NULL, 5),
(26, 'API actions (modification)', 'api_actions_put_item', 1, NULL, NULL, 5),
(27, 'API modules (liste)', 'api_modules_get_collection', 1, NULL, NULL, 6),
(28, 'API modules (ajout)', 'api_modules_post_collection', 1, NULL, NULL, 6),
(29, 'API modules (détails)', 'api_modules_get_item', 1, NULL, NULL, 6),
(30, 'API modules (suppression)', 'api_modules_delete_item', 1, NULL, NULL, 6),
(31, 'API modules (modification)', 'api_modules_put_item', 1, NULL, NULL, 6);

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

--
-- Structure de la table `agence`
--

CREATE TABLE `agence` (
  `id` int(11) NOT NULL,
  `code` varchar(21) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_postal` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codedrp_id` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_entite` varchar(11) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'poste',
  `nom` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tel` varchar(21) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `noeud` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT 'b0',
  `noeudct` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT 'b0',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  `bureau` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region_id` int(11) DEFAULT NULL,
  `departement_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `agence` (`id`, `code`, `code_postal`, `codedrp_id`, `code_entite`, `nom`, `email`, `tel`, `adresse`, `noeud`, `noeudct`, `status`, `date_creation`, `date_modification`, `bureau`, `region_id`, `departement_id`) VALUES
(1, '10100', '10100', '1', 'poste', 'DAKAR RP', 'bureaudakarrp@laposte.sn', '338690000', 'Dakar', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(2, '10270', '10700', '1', 'poste', 'DAKAR FANN', 'bureaufann@laposte.sn', '338250000', 'fann', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(3, '0', '0', '3', 'poste', 'DCP', 'dcp@laposte.sn', '339885555', 'dakar', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '0', 8, 24),
(6, '10', '0', '3', 'poste', 'DSI', 'dsi@laposte.sn', '338393564', 'dg laposte', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(7, '10023', '0', '1', 'poste', 'DRP  DAKAR', 'drp@laposte', '335559998', 'Dakar', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(8, '478', '0', '3', 'poste', 'CCB', 'ccb@laposte.sn', '338989656', 'dakar', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(9, '10027', '0', '2', 'poste', 'DRP  THIES', 'drpthies', '338989656', 'Thies', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(10, '10905', '21000', '2', 'poste', 'THIES RP', 'thies', '0', 'THIES', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(11, '10230', '13000', '1', 'poste', 'DAKAR PEYTAVIN', 'dakarpeytavin@laposte.sn', '338396788', 'dakar', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(12, '13450', '0', '1', 'poste', 'CAVEAU', 'caveau@laposte.sn', '338654253', 'DIRECTION GENERALE', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(15, '10042', '0', '3', 'poste', 'CAD', 'cad@gmail.com', '0', 'Dakar', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(16, '10010', '0', '3', 'poste', 'CT', 'ct@gmail.com', '0', 'dakar', 'b0', '', 1, NULL, NULL, '0', NULL, NULL),
(17, '10020', '0', '3', 'poste', 'CCH', 'cch@laposte.sn', '0', '', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(18, '10250', '0', '1', 'poste', 'MESSAGERIE', 'messagerie@gmail.com', '0', 'dakar', '', 'b0', 1, NULL, NULL, '1', NULL, NULL),
(19, '10067', '0', '3', 'poste', 'ENTREPOT', 'entrepot@gmail.com', '0', 'dakar', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(22, '10068', '0', '3', 'poste', 'DCG', 'dcg@gmail.com', '0', 'dakar', 'b0', 'b0', 1, NULL, NULL, '0', NULL, NULL),
(23, '10880', '26000', '7', 'poste', 'TAMBACOUNDA RP', 'tambarp@laposte.sn', '339813067', 'TAMBA', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(24, '10780', '20000', '1', 'poste', 'RUFISQUE', '@@@@@@@@', '33333333', 'Rufisque', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 1, 4),
(25, '10970', '10', '9', 'poste', 'ZIGUINCHOR RP', '', '33', 'ZIGUINCHOR ', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(26, '10140', '20100', '1', 'poste', 'BARGNY', 'bargny@laposte.sn', '333', 'Bargny', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 4),
(27, '10480', '10023', '8', 'poste', 'KAOLACK RP', 'kaolackrp@laposte.sn', '338303487', 'KAOLACK', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(28, '10025', '26000', '7', 'poste', 'DRP TAMBA', 'drptambalaposte.sn', '339655210', 'TAMBA', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(29, '10026', '36555', '9', 'poste', 'DRP ZIGUINCHOR', 'DRPZIG@laposte.sn', '339854123', 'ZIGUINCHOR', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(30, '10040', '24110', '6', 'poste', 'DRP LOUGA', 'drplg@laposte.sn', '339678521', 'LOUGA', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(31, '10039', '56981', '5', 'poste', 'DRP MATAM', 'matamdrp@laposte.sn', '336594211', 'matam', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(32, '10024', '23651', '4', 'poste', 'DRP ST LOUIS', 'drpsaintlouis]laposte.sn', '339612541', 'SAINT LOUIS', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(34, '10160', '24400', '8', 'poste', 'BIRKILANE', 'birkilane@laposte.sn', '339854512', 'REGION DE KAOLACK', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 4, 11),
(35, '10150', '27200', '9', 'poste', 'BIGNONA', 'bignona@laposte.sn', '339951246', 'EN FACE PREFECTURE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 43),
(37, '10820', '30001', '6', 'poste', 'SAKAL', '', '339670987', 'SAKAL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(39, '10220', '12700', '1', 'poste', 'DAKAR BUILDING', 'dakarbuilding@laposte.sn', '338526987', 'PLATEAU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(40, '10241', '13500', '1', 'poste', 'DAKAR COLOBANE', 'postecolobane@laposte.sn', '338542169', 'COLOBANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(41, '10260', '12900', '1', 'poste', 'DAKAR ETOILE', 'dakaretoile@laposte.sn', '38421587', 'PLATEAU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(42, '10275', '11500', '1', 'poste', 'DAKAR GRAND YOFF', 'dakargrandyoff@laposte.sn', '338254171', 'MARCHE GRAND YOFF', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(43, '10280', '11000', '1', 'poste', 'DAKAR LIBERTE', '', '338521470', 'LIBERTE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(44, '10290', '10500', '1', 'poste', 'DAKAR MEDINA', 'dakarmedina@laposte.sn', '338214752', 'ROND POINT MEDINA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(45, '10310', '12500', '1', 'poste', 'DAKAR PONTY', '', '338254123', 'AVENUE PONTY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(46, '10292', '10900', '1', 'poste', 'DAKAR NAFA', '', '338214569', 'VDN', 'b0', 'b0', 1, NULL, NULL, '1', 1, 1),
(47, '10295', '14000', '1', 'poste', 'PARCELLES ASSAINIES', '', '338216547', 'PARCELLES U14', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(48, '10515', '17500', '1', 'poste', 'KEUR MASSAR', '', '338231456', 'KEUR MASSAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 3),
(49, '10710', '16000', '1', 'poste', 'PIKINE', '', '338451278', 'PIKINE ', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 3),
(50, '10940', '17000', '1', 'poste', 'THIAROYE', '', '338265417', 'POSTE THIAROYE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 3),
(51, '10445', '13700', '1', 'poste', 'HLM5', '', '338562171', 'MARCHE HLM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(52, '10320', '12000', '1', 'poste', 'DAKAR  YOFF', '', '338256147', 'AEROPORT LSS', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(53, '10426', '15000', '1', 'poste', 'GUEDIAWAYE', '', '338265410', 'GUEDIAWAYE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 2),
(54, '10687', '12300', '1', 'poste', 'OUAKAM', '', '338124569', 'OUAKAM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(55, '10400', '10300', '1', 'poste', 'GOREE', '', '338251403', 'ILE DE GOREE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(56, '10837', '20000', '1', 'poste', 'SANGALKAM', '', '338254175', 'SANGALKAM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 4),
(57, '10968', '20000', '1', 'poste', 'YENE', '', '338214569', 'YENE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 4),
(62, '10112', '36004', '5', 'poste', 'AGNAM CIVOL', '', '339547896', 'AGNAM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(63, '10161', '36044', '5', 'poste', 'BOKILADJI', '', '338652147', 'BOKILADJI', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(64, '10163', '36008', '5', 'poste', 'BOKIDIAWE', '', '339587412', 'BOKIDIAWE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(65, '10335', '10335', '5', 'poste', 'DEMBANCANE', '', '339521478', 'DEMBANCANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(66, '10365', '36012', '5', 'poste', 'DONDOU', '', '339562177', 'DONDOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(67, '10470', '36032', '5', 'poste', 'KANEL', '', '339562147', 'KANEL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(68, '10590', '36000', '5', 'poste', 'MATAM', '', '339542147', 'MATAM', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(69, '10645', '36036', '5', 'poste', 'NDENDORY', '', '339751230', 'NDENDORY', 'b0', 'b0', 1, NULL, NULL, '1', 9, 28),
(70, '10675', '36010', '5', 'poste', 'NDOULOUMADJI DEMBE', '', '339562147', 'NDOULOUMADJI', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(71, '10677', '36014', '5', 'poste', 'NGUIDJILONE', '', '33952647', 'NGUIDJILONE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(72, '10683', '36002', '5', 'poste', 'OREFONDE', '', '339547866', 'OREFONDE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(73, '10689', '36002', '5', 'poste', 'OUROSSOGUI', '', '339542133', 'OUROSSOGUI', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(74, '10755', '36020', '5', 'poste', 'RANEROU', '', '339542178', 'RANEROU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 29),
(75, '10860', '36040', '5', 'poste', 'SEMME', '', '33956214', 'SEMME', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(76, '10865', '36023', '5', 'poste', 'SINTHIOU BAMAMBE', '', '339541287', 'SINTHIOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(77, '10930', '36006', '5', 'poste', 'THILOGNE', '', '3382541', 'THILOGNE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(78, '10965', '36042', '5', 'poste', 'WAOUNDE', '', '339547812', 'WAOUNDE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(79, '10966', '36030', '5', 'poste', 'WODOBERE', '', '335698421', 'WODOBERE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(80, '10190', '31009', '6', 'poste', 'COKI', '', '33', 'COKI', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(81, '10210', '31011', '6', 'poste', 'DAHRA', '', '33', 'DAHRA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(82, '10325', '30806', '6', 'poste', 'DAROU MARNANE', '', '33', 'DAROU MARNANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(83, '10330', '30804', '6', 'poste', 'DAROU MOUSTY', '', '33', 'DAROU MOUSTY', 'b0', 'b0', 1, NULL, NULL, '1', 8, 24),
(84, '10430', '30900', '6', 'poste', 'GUEOUL', '', '33', 'GUEOUL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(85, '10490', '30800', '6', 'poste', 'KEBEMER', '', '33', 'KEBEMER', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 8, 24),
(86, '10510', '30500', '6', 'poste', 'KELLE', '', '33', 'KELLE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 24),
(87, '10570', '31000', '6', 'poste', 'LOUGA', '', '33', 'LOUGA', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(88, '10600', '22100', '6', 'poste', 'MBACKE', '', '33', 'MBACKE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 2, 7),
(89, '10640', '30600', '6', 'poste', 'NDANDE', '', '33', 'NDANDE', 'b0', 'b0', 1, NULL, NULL, '1', 8, 24),
(90, '10670', '21800', '6', 'poste', 'NDOULO', '', '33', 'NDOULO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 2, 7),
(91, '10790', '30802', '6', 'poste', 'SAGATTA', '', '33', 'SAGATTA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 24),
(94, '10952', '22300', '6', 'poste', 'TOUBA', '', '33', 'TOUBA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 2, 7),
(96, '10130', '21400', '2', 'poste', 'BAMBEY', '', '33', 'BAMBEY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 2, 5),
(97, '10180', '20012', '2', 'poste', 'CAYAR', '', '33', 'CAYAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(98, '10340', '23012', '2', 'poste', 'NDIAGANIAO', '', '33', 'NDIAGANIAO', 'b0', 'b0', 1, NULL, NULL, '1', 13, 40),
(99, '10347', '23020', '2', 'poste', 'DIONEWAR', '', '33', 'DIONEWAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(100, '10450', '23015', '2', 'poste', 'JOAL', '', '33', 'JOAL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 40),
(101, '10520', '21200', '2', 'poste', 'KHOMBOLE', '', '33', 'KHOMBOLE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(102, '10610', '30005', '2', 'poste', 'MBORO', '', '33', 'MBORO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 42),
(103, '10620', '23000', '2', 'poste', 'MBOUR', '', '33', 'MBOUR', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 13, 40),
(104, '10630', '30400', '2', 'poste', 'MECKHE', '', '33', 'MECKHE', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(105, '10692', '23018', '2', 'poste', 'PALMARIN', '', '33', 'PALMARIN', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(106, '10700', '30402', '2', 'poste', 'PEKESSE', '', '33', 'PEKESSE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(107, '10720', '30200', '2', 'poste', 'PIRE', '', '33', 'PIRE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 26),
(108, '10740', '22600', '2', 'poste', 'POPENGUINE', '', '33', 'POPENGUINE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(109, '10750', '20600', '2', 'poste', 'POUT', '', '33', 'POUT', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(110, '10835', '23002', '2', 'poste', 'SALY', '', '33', 'SALY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 40),
(111, '10900', '21001', '2', 'poste', 'THIES ESCALE', '', '33', 'THIES ESCALE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(114, '10915', '23200', '2', 'poste', 'THIADIAYE', '', '33', 'THIADIAYE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(115, '10920', '30404', '2', 'poste', 'THILMAKHA', '', '33', 'THILMAKHA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(116, '10950', '30000', '2', 'poste', 'TIVAOUANE', '', '33', 'TIVAOUANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 42),
(117, '10957', '21300', '2', 'poste', 'TOUBATOUL', '', '33', 'TOUBATOUL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 41),
(118, '10110', '34100', '4', 'poste', 'AERE LAO', '', '33', 'AERE LAO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(119, '10170', '34700', '4', 'poste', 'CASCAS', '', '33', 'CASCAS', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(120, '10200', '32800', '4', 'poste', 'DAGANA', '', '33', 'DAGANA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 30),
(121, '10337', '34300', '4', 'poste', 'DEMETH', '', '33', 'DEMETH', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(122, '10362', '33900', '4', 'poste', 'DODEL', '', '33', 'DODEL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(123, '10385', '35500', '4', 'poste', 'GALOYA', '', '33', 'GALOYA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(124, '10387', '33500', '4', 'poste', 'GAMADJI SARE', '', '33', 'GAMADJI SARE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(125, '10395', '34900', '4', 'poste', 'GOLLERE', '', '33', 'GOLLERE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(126, '10615', '35100', '4', 'poste', 'MBOUMBA', '', '33', 'MBOUMBA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(127, '10638', '34500', '4', 'poste', 'MEDINA NDIATHBE', '', '33', 'MEDINA NDIATHBE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(128, '10650', '33700', '4', 'poste', 'NDIOUM', '', '33', 'NDIOUM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(129, '10679', '33200', '4', 'poste', 'NIANDANE', '', '33', 'NDIANDANE', 'b0', 'b0', 1, NULL, NULL, '1', 10, 31),
(130, '10705', '35300', '4', 'poste', 'PETE', '', '33', 'PETE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(131, '10730', '33300', '4', 'poste', 'PODOR', '', '33', 'PODOR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(132, '10760', '32600', '4', 'poste', 'RICHARD TOLL', '', '33', 'RICHARD TOLL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 32),
(133, '10765', '32200', '4', 'poste', 'ROSS BETHIO', '', '33', 'ROSS BETHIO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 32),
(134, '10770', '32400', '4', 'poste', 'ROSSO SENEGAL', '', '33', 'ROSSO SENEGAL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 32),
(135, '10800', '32000', '4', 'poste', 'SAINT LOUIS RP', '', '33', 'SAINT LOUIS RP', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 10, 32),
(136, '10815', '32002', '4', 'poste', 'SAINT LOUIS SOR', '', '33', 'SAINT LOUIS SOR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 32),
(137, '10830', '35700', '4', 'poste', 'SALDE', '', '33', 'SALDE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(138, '10910', '33100', '4', 'poste', 'THILLE BOUBACAR', '', '33', 'THILLE BOUBACAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 10, 31),
(139, '10115', '26506', '7', 'poste', 'AROUNDOU', 'harounanianghane@laposte.sn', '339547896', 'AROUNDOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(140, '10345', '26510', '7', 'poste', 'DIAWARA', 'cissesarr@laposte.sn', '3352145', 'DIAWARA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(141, '10125', '26508', '7', 'poste', 'BALLOU', '', '332645', 'BALLOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(142, '10120', '26500', '7', 'poste', 'BAKEL', '', '33254111', 'BAKEL', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 12, 36),
(143, '10377', '33333', '7', 'poste', 'FONGOLIMBY', '', '33256555', 'FONGOLIMBI', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(144, '10382', '26024', '7', 'poste', 'GABOU', '', '33652441', 'GABOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(145, '10397', '26504', '7', 'poste', 'GOLMY', '', '35845222', 'GOLMY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(146, '10420', '26020', '7', 'poste', 'GOUDIRY', '', '33658744', 'GOUDIRY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 37),
(147, '10500', '26005', '7', 'poste', 'KEDOUGOU', '', '33254178', 'KEDOUGOU', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 6, 18),
(148, '10530', '26022', '7', 'poste', 'KIDIRA', '', '2100333', 'KIDIRA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(149, '10545', '26018', '7', 'poste', 'KOTHIARY', '', '3325444', 'KOTHIARY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(150, '10552', '25400', '7', 'poste', 'KOUMPENTOUM', '', '33254444', 'KOUMPENTOUM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 38),
(151, '10555', '25800', '7', 'poste', 'KOUSSANAR', '', '33521478', 'KOUSSANAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(152, '10572', '25600', '7', 'poste', 'MAKACOLIBANTANG', '', '33254177', 'MAKACOLIBANTANG', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(153, '10577', '44444', '7', 'poste', 'MANDA DOUANE', '', '33265444', 'MANDA DOUANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(157, '10635', '26015', '7', 'poste', 'MEDINA GOUNASS', '', '332525655', 'MEDINA GOUNASS', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(158, '10637', '26002', '7', 'poste', 'MISSIRAH', '', '33684555', 'MISSIRAH', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(159, '10639', '26512', '7', 'poste', 'MOUDERY', '', '33856666', 'MOUDERY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(160, '10832', '26007', '7', 'poste', 'SALEMATA', '', '33956222', 'SALEMATA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 6, 19),
(161, '10838', '26009', '7', 'poste', 'SARAYA', '', '335682222', 'SARAYA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 6, 20),
(162, '10967', '26502', '7', 'poste', 'YAFERA', '', '33256124', 'YAFERA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 12, 39),
(163, '10560', '31013', '6', 'poste', 'LINGUERE', '', '33', 'LINGUERE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 8, 25),
(164, '10685', '23356', '5', 'poste', 'ORKADIERE', '', '33654455', 'ORKADIERE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(166, '10840', '20400', '1', 'poste', 'SEBIKHOTANE', '', '3354888', 'SEBIKOTANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 4),
(167, '10028', '24000', '8', 'poste', 'DRP KAOLACK', '', '33265456', 'DRP KAOLACK', 'b0', 'b0', 1, NULL, NULL, '2', NULL, NULL),
(168, '10255', '12000', '1', 'poste', 'DIAMALAYE', '', '3369898', 'DIAMALAYE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 1),
(169, '10322', '17000', '1', 'poste', 'ZAC MBAO', '', '33656565', 'ZAC MBAO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 1, 3),
(170, '10867', '36000', '5', 'poste', 'SINTHIOU GARBA', '', '33656565', 'SINTHIOU GARBA', 'b0', 'b0', 1, NULL, NULL, '1', 9, 28),
(171, '10447', '36000', '5', 'poste', 'HADOUBERE', '', '33695422', 'HADOUBERE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 9, 28),
(172, '10390', '24500', '8', 'poste', 'GANDIAYE', 'gandiaye@laposte.sn', '339396256', 'RUE NATIONALE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(173, '10164', '27009', '9', 'poste', 'CABROUSSE', 'cabrousse@laposte.sn', '339935137', 'CABROUSSE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(174, '10342', '27026', '9', 'poste', 'DIANAH MALARY', 'dianahmalary@laposte.sn', '339956405', 'DIANAH MALARY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(175, '10350', '27208', '9', 'poste', 'DIOULOULOU', 'diouloulou@laposte.sn', '339945101', 'DIOULOULOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(176, '10540', '27400', '9', 'poste', 'KOLDA', 'kolda@laposte.sn', '339961124', 'KOLDA', 'b0', '', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(177, '10580', '27019', '9', 'poste', 'MARSASSOUM', 'marsassoum@laposte.sn', '339958001', 'MARSASSOUM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(178, '10360', '21600', '8', 'poste', 'DIOURBEL', 'diourbel@laposte.sn', '339711380', 'DIOURBEL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 2, 6),
(179, '10370', '23600', '8', 'poste', 'FATICK', 'fatick@laposte.sn', '339491366', 'FATICK', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(180, '10375', '23400', '8', 'poste', 'FIMELA', 'fimela@laposte.sn', '339499360', 'FIMELA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(181, '10380', '24025', '8', 'poste', 'FOUNDIOUGNE', 'foundiougne@laposte.sn', '339481115', 'FOUDIOUGNE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 9),
(182, '10410', '24010', '8', 'poste', 'GOSSAS', 'gossas@laposte.sn', '339471149', 'gossas', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 10),
(183, '10440', '24006', '8', 'poste', 'GUINGUINEO', 'guinguineo@laposte.sn', '339473570', 'GUINGUINEO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 15),
(184, '10460', '24400', '8', 'poste', 'KAFFRINE', 'kaffrine@laposte', '339461019', 'Kaffrine', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 4, 12),
(185, '10485', '24001', '8', 'poste', 'KAOLACK NDORONG', 'kaolackndorong@laposte.sn', '339412296', 'KAOLACK NDORONG', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(186, '10550', '25200', '8', 'poste', 'KOUNGHEUL', 'koungheul@laposte.sn', '339467100', 'KOUNGHEUL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 4, 13),
(187, '10575', '24800', '8', 'poste', 'MALEME HODDAR', 'malemehoddar@laposte.sn', '339463602', 'MALEME HODDAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 4, 14),
(188, '10660', '24030', '8', 'poste', 'NDOFFANE', 'ndoffane@laposte.sn', '339432121', 'NDOFFANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(189, '10850', '27022', '9', 'poste', 'SEDHIOU', 'sedhiou@laposte.sn', '339951146', 'SEDHIOU', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 11, 35),
(190, '10885', '27402', '9', 'poste', 'TANAFF', 'tanaff@laposte.sn', '339959032', 'TANAFF', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(191, '10945', '27204', '9', 'poste', 'THIONK ESSYL', 'thionkessyl@laposte.sn', '339944072', 'THIONK ESSYL', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(192, '10960', '27406', '9', 'poste', 'VELINGARA', 'velingara@laposte.sn', '339971141', 'VELINGARA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(193, '10680', '24200', '8', 'poste', 'NIORO DU RIP', 'niorodurip@laposte.sn', '339443140', 'NIORO', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 17),
(194, '10870', '24016', '8', 'poste', 'SOKONE', 'sokone@laposte.sn', '339483144', 'SOKONE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(195, '10954', '24018', '8', 'poste', 'TOUBACOUTA', 'toubacouta@laposte.sn', '339487722', 'TOUBACOUTA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 9),
(196, '10355', '24022', '8', 'poste', 'DJILOR', 'djilor@laposte.sn', '339484031', 'DJILOR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(197, '10367', '24008', '8', 'poste', 'FASS KANE', 'fass@laposte.sn', '339425501', 'FASS KAOLACK', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(198, '10475', '24020', '8', 'poste', 'KARANG', 'karang@laposte.sn', '339493844', 'KARANG', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(199, '10875', '24027', '8', 'poste', 'SOUM', 'soum@laposte.sn', '339426043', 'SOUM', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(200, '10695', '24012', '8', 'poste', 'PASSY', 'passy@laposte.sn', '339485403', 'PASSY', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(201, '10349', '24014', '8', 'poste', 'DIOSSONG', 'diossong@laposte.sn', '33', 'DIOSSONG', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(202, '10465', '24034', '8', 'poste', 'KAHONE', 'kahone@laposte.sn', '33', 'KAHONE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(203, '10343', '27404', '9', 'poste', 'DIAOBE', 'diaobe@laposte.sn', '339926614', 'DIAOBE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(204, '10105', '27011', '9', 'poste', 'ADEANE', 'adeane@laposte.sn', '779049354', 'ADEANE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(205, '10215', '27007', '9', 'poste', 'ELINKINE', 'elinkine@laposte.sn', '778991252', 'ELINKINE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 44),
(206, '10344', '27015', '9', 'poste', 'DIATTACOUNDA', 'diattacounda@laposte.sn', '775650251', 'DIATTACOUNDA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(207, '10195', '27017', '9', 'poste', 'COUBALAN', 'coubalan@laposte.sn', '779819625', 'COUBALAN', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(208, '10862', '27202', '9', 'poste', 'SINDIAN', 'sindian@laposte.sn', '776089848', 'SINDIAN', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(209, '10123', '27206', '9', 'poste', 'BAILA', 'baila@laposte.sn', '772699454', 'BAILA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(210, '10425', '27013', '9', 'poste', 'GOUDOMP', 'goudomp@laposte.sn', '339955101', 'GOUDOMP', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 11, 34),
(211, '10162', '27024', '9', 'poste', 'BOUNKILING', 'bounkiling@laposte.sn', '339953170', 'BOUNKILING', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 45),
(212, '10690', '27005', '9', 'poste', 'OUSSOUYE', 'oussouye@laposte.sn', '339931112', 'OUSSOUYE', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 14, 44),
(213, '10969', '27001', '9', 'poste', 'ZIGUINCHOR ESCALE', 'ziguinchorescale@laposte.sn', '339915513', 'ZIGUINCHOR ESCALE', 'b0', 'b0', 1, NULL, NULL, '1', 14, 45),
(214, '10697', '27400', '9', 'poste', 'PATA', '', '221', 'PATA', 'b0', 'b0', 1, NULL, NULL, '1', 7, 22),
(215, '10636', '27400', '9', 'poste', 'MEDINA YORO  FOULA', '', '221', 'MEDINA YORO FOULA', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 7, 21),
(218, '10495', '27400', '9', 'poste', 'MEDINA MARI', '', '221', 'MEDINA MARI', 'b0', 'b0', 1, NULL, NULL, '1', 7, 21),
(219, '10678', '23018', '8', 'poste', 'NIAKHAR', '', '221', 'NIAKHAR', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 3, 8),
(220, '10353', '23600', '8', 'poste', 'DIOUROUP', '', '221', 'DIOUROUP', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(221, '10648', '24032', '8', 'poste', 'NDIEDIENG', '', '221', 'NDIEDIENG', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 5, 16),
(225, '10890', '0', '2', 'poste', 'THIENABA', '', '0', 'REGION DE THIES', 'b0', 'b0', 1, NULL, NULL, '1', 13, 41),
(226, '10346', '0', '2', 'poste', 'DIASS-AIBD', '', '0', 'REGION DE THIES', 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', '1', 13, 40),
(227, '10567', '0', '5', 'poste', 'KOBILO', '', '0', 'KOBILO', 'b0', 'b0', 1, NULL, NULL, '1', 9, 28),
(228, '10525', '0', '7', 'poste', 'KHOSSANTO', '', '0', 'KHOSSANTO', 'b0', 'b0', 1, NULL, NULL, '1', 6, 18),
(229, '101001', '10100', '1', 'poste', 'Potou', 'bureaudakarrp@laposte.sn', '338690000', 'Dakar', 'b0', 'b0', 1, NULL, NULL, '3', NULL, NULL),
(230, '102301', '13000', '1', 'poste', 'Touba Sandaga', 'dakarpeytavin@laposte.sn\r\n', '338396788', 'Dakar', 'b0', 'b0', 1, NULL, NULL, '3', 1, 1),
(231, '102801', '11000', '1', 'poste', 'HLM LIBERTE', '', '338521470', 'Liberté', 'b0', 'b0', 1, NULL, NULL, '3', 1, 1),
(232, '102802', '11000', '1', 'poste', 'SODIDA', '', '338521470', 'Sodida Dakar Liberte', 'b0', 'b0', 1, NULL, NULL, '3', 1, 1),
(233, '109051', '20100', '2', 'poste', 'NDIASSANE', '', '338989656', 'Thies', 'b0', 'b0', 1, NULL, NULL, '3', 13, 42),
(234, '106202', '23000', '2', 'poste', 'NGUEKHOKH', 'mbour', '33', 'Mbour', 'b0', 'b0', 1, NULL, NULL, '3', 13, 40),
(235, '106201', '23000', '2', 'poste', 'NGAPAROU', 'ngaparou', '33', 'Mbour', 'b0', 'b0', 1, NULL, NULL, '3', 13, 40),
(236, '10394', '32900', '4', 'poste', 'GAYA', '', '0', '10 km de DAGANA', 'b0', 'b0', 1, NULL, NULL, '1', 10, 30),
(237, '10785', '0', '6', 'poste', 'SADIO', '', '0', 'DRP LOUGA', 'b0', 'b0', 1, NULL, NULL, '1', 8, 26),
(238, '10005', '0', '1', 'poste', 'DIPA', '', '33', 'DAKAR', 'b0', 'b0', 1, NULL, NULL, '1', NULL, NULL),
(240, '10836', '0', '2', 'poste', 'SANDIARA', '', '33', 'DRP THIES', 'b0', 'b0', 1, NULL, NULL, '1', 13, 40),
(241, '10157', '', '', 'poste', 'BUREAU DE POSTE LOUGA ANNEXE QUARTIER ARTILLERIE', '', NULL, NULL, 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', NULL, 8, 26),
(242, '10633', '', '', 'poste', 'MEDINA MARY', '', NULL, NULL, 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', NULL, 7, 23),
(243, '10971', '', '', 'poste', 'BUREAU DE POSTE ZIGUINCHOR ESCALE QUARTIER ESCALE', '', NULL, NULL, 'b0', 'b0', 1, NULL, '2019-10-24 20:05:00', NULL, 14, 45);

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

--
-- Structure de la table `commune`
--

CREATE TABLE `commune` (
  `id` int(11) NOT NULL,
  `departement_id` int(11) DEFAULT NULL,
  `nom` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `commune` (`id`, `departement_id`, `nom`, `longitude`, `altitude`, `date_creation`, `date_modification`) VALUES
(1, 1, 'BISCUITERIE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(2, 1, 'CAMBERENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(3, 1, 'DIEUPPEUL DERKLE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(4, 1, 'FANN/POINT E/ AMITIE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(5, 1, 'GOREE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(6, 1, 'GRAND DAKAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(7, 1, 'GRAND YOFF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(8, 1, 'GUEULE TAPEE FASS COLOBANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(9, 1, 'HANN/ BEL AIR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(10, 1, 'HLM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(11, 1, 'MEDINA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(12, 1, 'MERMOZ/ SACRE -COEUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(13, 1, 'NGOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(14, 1, 'OUAKAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(15, 1, 'PARCELLES ASSAINIES', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(16, 1, 'PATTE D\'OIE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(17, 1, 'PLATEAU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(18, 1, 'SICAP LIBERTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(19, 1, 'YOFF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(20, 2, 'GOLF SUD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(21, 2, 'MEDINA GOUNASS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(22, 2, 'N\'DIAREME LIMAMOULAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(23, 2, 'SAM NOTAIRE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(24, 2, 'WAKHINANE NIMZATT', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(25, 3, 'DALIFORD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(26, 3, 'DIACK SAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(27, 3, 'DIAMAGUENE/SICAP M\'BAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(28, 3, 'DJIDAH THIAROYE KAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(29, 3, 'GUINAW RAIL NORD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(30, 3, 'GUINAW RAIL SUD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(31, 3, 'KEUR MASSAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(32, 3, 'MALIKA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(33, 3, 'MBAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(34, 3, 'PIKINE EST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(35, 3, 'PIKINE OUEST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(36, 3, 'PIKINE SUD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(37, 3, 'THIAROYE GARE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(38, 3, 'THIAROYE SUR MER', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(39, 3, 'YEUMBEUL NORD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(40, 3, 'YEUMBEUL SUD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(41, 4, 'BAMBYLOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(42, 4, 'BARGNY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(43, 4, 'DIAMNIADIO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(44, 4, 'JAXAAY PARCELLE NIAKOUL RAP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(45, 4, 'RUFISQUE CENTRE (NORD)', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(46, 4, 'RUFISQUE EST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(47, 4, 'RUFISQUE OUEST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(48, 4, 'SANGALKAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(49, 4, 'SEBIKOTANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(50, 4, 'SENDOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(51, 4, 'TIVAOUANE PEULH-NIAGHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(52, 4, 'YENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(53, 5, 'BABA GARAGE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(54, 5, 'BAMBEY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(55, 5, 'DANGALMA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(56, 5, 'DINGUIRAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(57, 5, 'GAWANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(58, 5, 'KEUR SAMBA KANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(59, 5, 'LAMBAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(60, 5, 'NDONDOL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(61, 5, 'NGOGOM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(62, 5, 'NGOYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(63, 5, 'REFANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(64, 5, 'THIAKAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(65, 6, 'DANKH SENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(66, 6, 'DIOURBEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(67, 6, 'GADE ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(68, 6, 'KEUR NGALGOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(69, 6, 'NDINDY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(70, 6, 'NDOULO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(71, 6, 'NGOHE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(72, 6, 'PATTAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(73, 6, 'TAIBA MOUTOUPHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(74, 6, 'TOCKY GARE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(75, 6, 'TOUBA LAPPE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(76, 6, 'TOURE MBONDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(77, 7, 'DALLA N\'GABOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(78, 7, 'DAROU NAHIM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(79, 7, 'DAROU SALAM TYP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(80, 7, 'DENDEYE GOUYE GUI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(81, 7, 'KAEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(82, 7, 'MADINA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(83, 7, 'MBACKE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(84, 7, 'MISSIRAH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(85, 7, 'NDIOUMANE T. THIEKENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(86, 7, 'NGHAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(87, 7, 'SADIO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(88, 7, 'TAIBA TIECKENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(89, 7, 'TAIF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(90, 7, 'TOUBA FALL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(91, 7, 'TOUBA MBOUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(92, 7, 'TOUBA MOSQUEE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(93, 8, 'DIAKHAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(94, 8, 'DIAOULE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(95, 8, 'DIARERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(96, 8, 'DIOFIOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(97, 8, 'DIOUROUP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(98, 8, 'DJILASSE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(99, 8, 'FATICK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(100, 8, 'FIMELA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(101, 8, 'LOUL-SESSENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(102, 8, 'MBELACADIAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(103, 8, 'NDIOB', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(104, 8, 'NGAYOKHEME', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(105, 8, 'NIAKHAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(106, 8, 'PALMARIN FACAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(107, 8, 'PATAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(108, 8, 'TATTAGUINE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(109, 8, 'THIARE NDIALGUI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(110, 9, 'BASSOUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(111, 9, 'DIAGANE BARKA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(112, 9, 'DIONEWAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(113, 9, 'DIOSSONG', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(114, 9, 'DJILOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(115, 9, 'DJIRNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(116, 9, 'FOUNDIOUGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(117, 9, 'KARANG POSTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(118, 9, 'KEUR SALOUM DIANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(119, 9, 'KEUR SAMBA GUEYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(120, 9, 'MBAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(121, 9, 'NIASSENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(122, 9, 'NIORO ALASSANE TALL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(123, 9, 'PASSY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(124, 9, 'SOKONE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(125, 9, 'SOUM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(126, 9, 'TOUBACOUTA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(127, 10, 'COLOBANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(128, 10, 'GOSSAS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(129, 10, 'MBAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(130, 10, 'NDIENE LAGANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(131, 10, 'OUADIOUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(132, 10, 'PATAR LIA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(133, 11, 'BIRKELANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(134, 11, 'DIAMAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(135, 11, 'KEUR MBOUCKI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(136, 11, 'MABO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(137, 11, 'MBEULEUP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(138, 11, 'NDIOGNICK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(139, 11, 'SEGRE GATTA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(140, 11, 'TOUBA MBELLA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(141, 12, 'BOULEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(142, 12, 'DIAMAGADIO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(143, 12, 'DIOKOUL M\'BELBOUCK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(144, 12, 'GNIBY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(145, 12, 'KAFFRINE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(146, 12, 'KAHI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(147, 12, 'KATHIOTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(148, 12, 'MEDINATOUL SALAM 2', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(149, 12, 'NGANDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(150, 13, 'FASS THIEKENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(151, 13, 'GAINTHE PATHE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(152, 13, 'IDA MOURIDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(153, 13, 'KOUNGUEUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(154, 13, 'LOUR ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(155, 13, 'MAKA YOP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(156, 13, 'MISSIRAH WADENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(157, 13, 'RIBOT ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(158, 13, 'SALY ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(159, 14, 'DAROU MINAM II', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(160, 14, 'DIANKE SOUF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(161, 14, 'MALEM HODDAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(162, 14, 'NDIOBENE SAMBA LAMO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(163, 14, 'NDIOUM N\'GAINTH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(164, 14, 'SAGNA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(165, 15, 'DARA MBOSS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(166, 15, 'FASS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(167, 15, 'GAGNICK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(168, 15, 'GUINGUINEO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(169, 15, 'KHELCOM BIRAME', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(170, 15, 'MBADAKHOUNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(171, 15, 'MBOSS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(172, 15, 'NDIAGO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(173, 15, 'NGATHIE NAOUDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(174, 15, 'NGUELOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(175, 15, 'OUROUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(176, 15, 'PANAL OUOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(177, 16, 'DYA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(178, 16, 'GANDIAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(179, 16, 'KAHONE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(180, 16, 'KAOLACK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(181, 16, 'KEUR BAKA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(182, 16, 'KEUR SOCE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(183, 16, 'LATMINGUE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(184, 16, 'NDIAFFATE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(185, 16, 'NDIEBEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(186, 16, 'NDIEDIENG', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(187, 16, 'NDOFFANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(188, 16, 'SIBASSOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(189, 16, 'THIARE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(190, 16, 'THIOMBY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(191, 17, 'DABALY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(192, 17, 'DAROU SALAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(193, 17, 'GAINTE KAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(194, 17, 'KAYEMOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(195, 17, 'KEUR MABA DIAKHOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(196, 17, 'KEUR MADIABEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(197, 17, 'KEUR MANDONGO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(198, 17, 'MEDINA-SABAKH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(199, 17, 'NDRAME ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(200, 17, 'NGAYENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(201, 17, 'NIORO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(202, 17, 'PAOSKOTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(203, 17, 'POROKHANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(204, 17, 'TAIBA NIASSENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(205, 17, 'WACK NGOUNA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(206, 18, 'BANDAFASSI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(207, 18, 'DIMBOLI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(208, 18, 'DINDIFELO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(209, 18, 'FONGOLEMBI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(210, 18, 'KEDOUGOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(211, 18, 'NINEFECHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(212, 18, 'TOMBORONKOTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(213, 19, 'DAKATELI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(214, 19, 'DAR SALAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(215, 19, 'ETHIOLO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(216, 19, 'KEVOYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(217, 19, 'OUBADJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(218, 19, 'SALEMATA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(219, 20, 'BEMBOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(220, 20, 'KHOSSANTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(221, 20, 'MEDINA BAFFE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(222, 20, 'MISSIRAH SIRIMANA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(223, 20, 'SABODALA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(224, 20, 'SARAYA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(225, 21, 'BAGADADJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(226, 21, 'COUMBACARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(227, 21, 'DABO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(228, 21, 'DIALAMBERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(229, 21, 'DIOULACOLON', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(230, 21, 'GUIRO YERO BOCAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(231, 21, 'KOLDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(232, 21, 'MAMPATIM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(233, 21, 'MEDINA CHERIF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(234, 21, 'MEDINA EL HADJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(235, 21, 'SALIKEGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(236, 21, 'SARE BIDJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(237, 21, 'SARE YOBA DIEGA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(238, 21, 'TANKANTO ESCALE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(239, 21, 'THIETTY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(240, 22, 'BADION', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(241, 22, 'BIGNARABE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(242, 22, 'BOUROUCO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(243, 22, 'DINGUIRAY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(244, 22, 'FAFACOUROU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(245, 22, 'KEREWANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(246, 22, 'KOULINTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(247, 22, 'MEDINA YORO FOULAH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(248, 22, 'NDORNA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(249, 22, 'NIAMING', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(250, 22, 'PATA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(251, 23, 'BONCONTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(252, 23, 'DIAOUBE-KABENDOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(253, 23, 'KABENDOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(254, 23, 'KANDIA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(255, 23, 'KANDIAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(256, 23, 'LINKERING', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(257, 23, 'MEDINA GOUNASSE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(258, 23, 'NEMATABA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(259, 23, 'OUASSADOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(260, 23, 'PAKOUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(261, 23, 'PAROUMBA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(262, 23, 'SARE COLY SALLE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(263, 23, 'SINTHIANG KOUNDARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(264, 23, 'VELINGARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(265, 24, 'BADEGNE OUOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(266, 24, 'DAROU MARNANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(267, 24, 'DAROU MOUSTY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(268, 24, 'DIOKOUL DIAWRIGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(269, 24, 'GEOUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(270, 24, 'KAB GAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(271, 24, 'KANENE NDIOB', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(272, 24, 'KEBEMER', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(273, 24, 'LORO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(274, 24, 'MBACKE CADIOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(275, 24, 'MBADIANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(276, 24, 'NDANDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(277, 24, 'NDOYENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(278, 24, 'NGOURANE OUOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(279, 24, 'SAGATTA GUETH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(280, 24, 'SAM YABAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(281, 24, 'THIEPPE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(282, 24, 'THIOLOM FALL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(283, 24, 'TOUBA MERINA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(284, 25, 'AFFE DJOLOFF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(285, 25, 'BARKEDJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(286, 25, 'BOULAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(287, 25, 'DAHRA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(288, 25, 'DEALI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(289, 25, 'DODJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(290, 25, 'GASSANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(291, 25, 'KAMB', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(292, 25, 'LABGAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(293, 25, 'LINGUERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(294, 25, 'MBEULEUKHE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(295, 25, 'MBOULA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(296, 25, 'OUARKHOH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(297, 25, 'SAGATTA DJOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(298, 25, 'TESSEKRE FORAGE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(299, 25, 'THIAMENE DJOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(300, 25, 'THIARGNY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(301, 25, 'THIEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(302, 25, 'YANG YANG', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(303, 26, 'GANDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(304, 26, 'GUET ARDO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(305, 26, 'KELLE GUEYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(306, 26, 'KEUR MOMAR SARR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(307, 26, 'KOKI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(308, 26, 'LEONA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(309, 26, 'LOUGA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(310, 26, 'MBEDIENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(311, 26, 'NDIAGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(312, 26, 'NGUER MALAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(313, 26, 'NGUEUNE SARR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(314, 26, 'NGUIDILE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(315, 26, 'NIOMRE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(316, 26, 'PETE OUARACK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(317, 26, 'SAKAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(318, 26, 'SYER', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(319, 26, 'THIAMENE CAYOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(320, 27, 'AOURE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(321, 27, 'BOKILADJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(322, 27, 'DEMBANCANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(323, 27, 'HAMADY OUNARE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(324, 27, 'KANEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(325, 27, 'NDENDORY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(326, 27, 'ODOBERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(327, 27, 'ORKADIERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(328, 27, 'OURO SIDY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(329, 27, 'SEMME', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(330, 27, 'SINTHIOU BAMANBE-BANADJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(331, 27, 'WAOUNDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(332, 28, 'AGNAM CIVOL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(333, 28, 'BOKIDIAWE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(334, 28, 'DABIA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(335, 28, 'DES AGNAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(336, 28, 'MATAM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(337, 28, 'NGUIDILOGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(338, 28, 'OGO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(339, 28, 'OREFONDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(340, 28, 'OUROSSOGUI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(341, 28, 'THILOGNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(342, 29, 'LOUGRE-THIOLY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(343, 29, 'OUDALAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(344, 29, 'RANEROU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(345, 29, 'VELINGARA RANEROU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(346, 30, '', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(347, 30, 'BOKHOL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(348, 30, 'DAGANA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(349, 30, 'DIAMA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(350, 30, 'GAE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(351, 30, 'MBANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(352, 30, 'NDOMBO SANDJIRY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(353, 30, 'NGNITH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(354, 30, 'RICHARD-TOLL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(355, 30, 'RONKH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(356, 30, 'ROSS-BETHIO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(357, 30, 'ROSSO-SENEGAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(358, 31, 'AERE LAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(359, 31, 'BODE LAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(360, 31, 'BOKE DIALLOUBE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(361, 31, 'CAS CAS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(362, 31, 'DEMETTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(363, 31, 'DODEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(364, 31, 'DOUNGA LAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(365, 31, 'FANAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(366, 31, 'GALOYA TOUCOULEUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(367, 31, 'GAMADJI SARE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(368, 31, 'GOLLORE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(369, 31, 'GUEDE CHANTIER', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(370, 31, 'GUEDE VILLAGE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(371, 31, 'MBOLO BIRANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(372, 31, 'MBOUMBA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(373, 31, 'MEDINA NDIATHBE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(374, 31, 'MERY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(375, 31, 'NAMAREL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(376, 31, 'NDIANDANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(377, 31, 'NDIAYENE PENDAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(378, 31, 'NDIOUM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(379, 31, 'PETE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(380, 31, 'PODOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(381, 31, 'WALALDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(382, 32, 'FASS NGOM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(383, 32, 'GANDON', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(384, 32, 'MPAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(385, 32, 'N\'DIEBENE GANDIOLE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(386, 32, 'SAINT-LOUIS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(387, 33, 'BOGHAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(388, 33, 'BONA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(389, 33, 'BOUNKILING', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(390, 33, 'DIACOUNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(391, 33, 'DIAMBATY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(392, 33, 'DIAROUME', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(393, 33, 'DJINANY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(394, 33, 'FAOUNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(395, 33, 'INOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(396, 33, 'KANDION MANGANA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(397, 33, 'MADINA WANDIFA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(398, 33, 'NDIAMACOUTA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(399, 33, 'NDIAMALATHIEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(400, 33, 'TANKON', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(401, 34, 'BAGHERE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(402, 34, 'DIATTACOUNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(403, 34, 'DIOUBOUDOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(404, 34, 'DJIBANAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(405, 34, 'GOUDOMP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(406, 34, 'KAOUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(407, 34, 'KARANTABA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(408, 34, 'KOLIBANTANG', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(409, 34, 'MANGAROUNGOU SANTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(410, 34, 'NIAGHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(411, 34, 'SAMINE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(412, 34, 'SIMBADI BALANTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(413, 34, 'SIMBANDI BRASSOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(414, 34, 'TANAFF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(415, 34, 'YARANG BALANTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(416, 35, 'BAMBALI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(417, 35, 'BENET BIJINI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(418, 35, 'DIANAH MALARY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(419, 35, 'DIANNAH BA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(420, 35, 'DIENDE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(421, 35, 'DJIBABOUYA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(422, 35, 'DJIREDJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(423, 35, 'KOUSSY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(424, 35, 'MARSASSOUM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(425, 35, 'OUDOUCAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(426, 35, 'SAKAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(427, 35, 'SAMA KANTA PEULH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(428, 35, 'SANSAMBA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(429, 35, 'SEDHIOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(430, 36, 'BAKEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(431, 36, 'BALLOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(432, 36, 'BELE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(433, 36, 'DIAWARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(434, 36, 'GABOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(435, 36, 'GATHIARY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(436, 36, 'KIDIRA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(437, 36, 'MADINA FOULBE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(438, 36, 'MOUDERY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(439, 36, 'SADATOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(440, 36, 'SINTHIOU-FISSA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(441, 36, 'TOUMBOURA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(442, 37, 'BALA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(443, 37, 'BANI ISRAEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(444, 37, 'BOUTOUCOUFARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(445, 37, 'BOYNGUEL BAMBA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(446, 37, 'DIANKE MAKHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(447, 37, 'DOUGUE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(448, 37, 'GOUDIRY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(449, 37, 'GOUMBAYEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(450, 37, 'KOAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(451, 37, 'KOMOTI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(452, 37, 'KOTHIARY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(453, 37, 'KOULOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(454, 37, 'KOUSSAN', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(455, 37, 'SINTHIOU BOCAR ALI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(456, 37, 'SINTHIOU MAMADOU BOUBOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(457, 38, 'BAMBA THIALENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(458, 38, 'KAHENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(459, 38, 'KOUMPENTOUM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(460, 38, 'KOUTHIA GAYDI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(461, 38, 'KOUTHIABA WOLOF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(462, 38, 'MALEM NIANI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(463, 38, 'MERETO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(464, 38, 'NDAME', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(465, 38, 'PASS KOTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(466, 38, 'PAYAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(467, 39, 'DIALACOTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(468, 39, 'KOUSSANAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(469, 39, 'MAKACOULIBATANG', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(470, 39, 'MISSIRAH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(471, 39, 'NETTE BOULOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(472, 39, 'NIANI TOUCOULEUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(473, 39, 'N\'DOGA BABACAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(474, 39, 'SINTHIOU MALEM', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(475, 39, 'TAMBACOUNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(476, 40, 'DIASS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(477, 40, 'FISSEL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(478, 40, 'GUEKOKH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(479, 40, 'JOAL- FADIOUTH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(480, 40, 'MALICOUNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(481, 40, 'MBOUR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(482, 40, 'NDIAGANIAO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(483, 40, 'NGAPAROU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(484, 40, 'NGUENIENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(485, 40, 'POPOGUINE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(486, 40, 'SALY PORTUDAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(487, 40, 'SANDIARA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(488, 40, 'SESSENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(489, 40, 'SINDIA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(490, 40, 'SOMONE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(491, 40, 'THIADIAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(492, 41, 'CAYAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(493, 41, 'DIENDER GUEDJI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(494, 41, 'FANDENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(495, 41, 'KEUR MOUSSA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(496, 41, 'KHOMBOLE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(497, 41, 'NGOUNDIANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(498, 41, 'NOTTO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(499, 41, 'N\'DIEYENE SIRAKH', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(500, 41, 'POUT', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(501, 41, 'TASSETTE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(502, 41, 'THIENABA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(503, 41, 'THIES EST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(504, 41, 'THIES NORD', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(505, 41, 'THIES OUEST', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(506, 41, 'TOUBA TOUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(507, 41, 'TOUTE LA COMMUNE DE THIES (EST OUEST NORD)', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(508, 42, 'CHERIF LO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(509, 42, 'DAROU KHOUDOSS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(510, 42, 'KOUL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(511, 42, 'MBAYENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(512, 42, 'MBORO', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(513, 42, 'MEKHE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(514, 42, 'MEOUANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(515, 42, 'MERINA DAKHAR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(516, 42, 'MONT- ROLLAND', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(517, 42, 'NGANDIOUF', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(518, 42, 'NIAKHENE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(519, 42, 'NOTTO GOUYE DIAMA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(520, 42, 'PAMBAL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(521, 42, 'PEKESSE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(522, 42, 'PIRE GOUREYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(523, 42, 'TAIBA NDIAYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(524, 42, 'THILMAKHA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(525, 42, 'TIVAOUANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(526, 42, 'TOUTE LA COMMUNE DE TIVAOUANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(527, 43, 'BALINGORE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(528, 43, 'BIGNONA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(529, 43, 'COUBALAN', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(530, 43, 'DIEGOUNE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(531, 43, 'DIOULOULOU', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(532, 43, 'DJIBIDIONE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(533, 43, 'DJINAKI', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(534, 43, 'KAFOUNTINE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(535, 43, 'KARTHIACK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(536, 43, 'KATABA I', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(537, 43, 'MANGAGOULACK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(538, 43, 'NIAMONE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(539, 43, 'OULAMPANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(540, 43, 'OUONCK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(541, 43, 'SINDIAN', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(542, 43, 'SUELLE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(543, 43, 'TENDOUCK', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(544, 43, 'TENGHORY', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(545, 43, 'THIONCK-ESSYL', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(546, 44, 'DJEMBERING', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(547, 44, 'MLOMP', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(548, 44, 'OUKOUT', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(549, 44, 'OUSSOUYE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(550, 44, 'SANTHIABA MANJACQUE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(551, 45, 'ADEANE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(552, 45, 'BOUTOUPA CAMARA COUNDA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(553, 45, 'ENAMPORE', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(554, 45, 'NIAGUIS', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(555, 45, 'NYASSIA', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00'),
(556, 45, 'ZIGUINCHOR', NULL, NULL, '2019-08-08 10:15:00', '2019-08-08 10:15:00');

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

--
-- Structure de la table `departement`
--

CREATE TABLE `departement` (
  `id` int(11) NOT NULL,
  `region_id` int(11) DEFAULT NULL,
  `nom` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `departement` (`id`, `region_id`, `nom`, `longitude`, `altitude`, `date_creation`, `date_modification`) VALUES
(1, 1, 'DAKAR', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(2, 1, 'GUEDIAWAYE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(3, 1, 'PIKINE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(4, 1, 'RUFISQUE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(5, 2, 'BAMBEY', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(6, 2, 'DIOURBEL', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(7, 2, 'MBACKE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(8, 3, 'FATICK', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(9, 3, 'FOUNDIOUGNE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(10, 3, 'GOSSAS', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(11, 4, 'BIRKELANE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(12, 4, 'KAFFRINE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(13, 4, 'KOUNGHEUL', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(14, 4, 'MALEM HODAR', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(15, 5, 'GUINGUINEO', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(16, 5, 'KAOLACK', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(17, 5, 'NIORO DU RIP', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(18, 6, 'KEDOUGOU', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(19, 6, 'SALEMATA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(20, 6, 'SARAYA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(21, 7, 'KOLDA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(22, 7, 'MEDINA YORO FOULAH', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(23, 7, 'VELINGARA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(24, 8, 'KEBEMER', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(25, 8, 'LINGUERE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(26, 8, 'LOUGA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(27, 9, 'KANEL', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(28, 9, 'MATAM', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(29, 9, 'RANEROU FERLO', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(30, 10, 'DAGANA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(31, 10, 'PODOR', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(32, 10, 'SAINT-LOUIS', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(33, 11, 'BOUNKILING', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(34, 11, 'GOUDOMP', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(35, 11, 'SEDHIOU', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(36, 12, 'BAKEL', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(37, 12, 'GOUDIRY', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(38, 12, 'KOUMPENTOUM', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(39, 12, 'TAMBACOUNDA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(40, 13, 'MBOUR', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(41, 13, 'THIES', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(42, 13, 'TIVAOUANE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(43, 14, 'BIGNONA', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(44, 14, 'OUSSOUYE', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28'),
(45, 14, 'ZIGUINCHOR', NULL, NULL, '2019-08-08 10:07:28', '2019-08-08 10:07:28');

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

--
-- Structure de la table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(14) COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migration_versions` (`version`, `executed_at`) VALUES
('20190126133541', '2019-01-26 13:35:50'),
('20190126134031', '2019-01-26 13:40:44'),
('20190218140829', '2019-02-18 14:08:44'),
('20190220233028', '2019-02-20 23:30:37'),
('20190221152324', '2019-02-21 15:23:34'),
('20190316182616', '2019-03-16 18:26:31'),
('20190331142030', '2019-03-31 14:20:45'),
('20190331181637', '2019-03-31 18:17:40'),
('20190331181858', '2019-03-31 18:19:13'),
('20190331191738', '2019-03-31 19:17:49'),
('20190331192200', '2019-03-31 19:22:12'),
('20190404155500', '2019-04-04 15:55:15'),
('20190423180725', '2019-04-23 18:07:39'),
('20190425161658', '2019-04-25 21:38:28'),
('20190426095314', '2019-04-26 09:53:26'),
('20190426100610', '2019-04-26 10:06:18'),
('20190428154732', '2019-04-28 15:47:46'),
('20190428155054', '2019-04-28 15:51:07'),
('20190630160647', '2019-06-30 16:07:04'),
('20190701151840', '2019-07-01 15:20:37'),
('20190701152650', '2019-07-01 15:27:04'),
('20190706180929', '2019-07-06 18:09:47'),
('20190825183040', '2019-08-25 18:32:22'),
('20190908195603', '2019-09-08 19:56:16'),
('20190921153732', '2019-09-21 15:37:46'),
('20191005131132', '2019-10-05 13:11:55'),
('20191005131428', '2019-10-05 13:14:34'),
('20191005133933', '2019-10-05 13:39:42'),
('20191005142036', '2019-10-05 14:20:46'),
('20191005172346', '2019-10-05 17:23:58'),
('20191012091715', '2019-10-12 09:18:10'),
('20191012093021', '2019-10-12 09:30:40'),
('20191012114109', '2019-10-12 11:41:31'),
('20191023191259', '2019-10-23 19:14:11'),
('20191023191442', '2019-10-23 19:14:51'),
('20191023192205', '2019-10-23 19:22:19'),
('20191023192825', '2019-10-23 19:28:37'),
('20191023192919', '2019-10-23 19:29:29'),
('20191023193055', '2019-10-23 19:31:05'),
('20191023193418', '2019-10-23 19:34:36'),
('20191023193532', '2019-10-23 19:35:41'),
('20191023194513', '2019-10-23 19:45:23'),
('20191023204943', '2019-10-23 20:49:55'),
('20191023205845', '2019-10-23 20:58:50'),
('20191023205941', '2019-10-23 20:59:45'),
('20191023213121', '2019-10-23 21:31:31'),
('20191024190613', '2019-10-24 19:06:29'),
('20191025220303', '2019-10-25 22:03:14'),
('20191025220529', '2019-10-25 22:06:05');

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

--
-- Structure de la table `module`
--

CREATE TABLE `module` (
  `id` int(11) NOT NULL,
  `libelle` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  `code_service` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_module` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `module` (`id`, `libelle`, `date_creation`, `date_modification`, `code_service`, `code_module`) VALUES
(1, 'Permissions Management', NULL, NULL, 'AUTH', 'permissions_management'),
(2, 'Permissions Refresh Actions', NULL, NULL, 'AUTH', 'permissions_refresh_actions'),
(3, 'Users Management', NULL, NULL, 'AUTH', 'users_management'),
(4, 'Roles Management', NULL, NULL, 'AUTH', 'roles_management'),
(5, 'Actions Management', NULL, NULL, 'AUTH', 'actions_management'),
(6, 'Modules Management', NULL, NULL, 'AUTH', 'modules_management');

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

--
-- Structure de la table `permission`
--

CREATE TABLE `permission` (
  `id` int(11) NOT NULL,
  `action_id` int(11) DEFAULT NULL,
  `code_entite` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` json NOT NULL,
  `status` tinyint(1) NOT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permission` (`id`, `action_id`, `code_entite`, `roles`, `status`, `date_creation`, `date_modification`) VALUES
(1, 1, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(2, 2, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(3, 3, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(4, 4, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(5, 5, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(6, 6, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(7, 7, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(8, 8, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(9, 9, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(10, 10, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(11, 11, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(12, 12, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(13, 13, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(14, 14, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(15, 15, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(16, 16, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(17, 17, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(18, 18, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(19, 19, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(20, 20, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(21, 21, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(22, 22, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(23, 23, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(24, 24, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(25, 25, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(26, 26, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(27, 27, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(28, 28, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(29, 29, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(30, 30, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(31, 31, 'BG_DIGIT', '[\"ROLE_ADMIN_BG_DIGIT\"]', 1, '2019-05-23 15:52:16', '2019-05-23 15:52:16'),
(32, 9, 'H4d8j', '[\"ROLE_USER_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(33, 11, 'H4d8j', '[\"ROLE_USER_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(34, 4, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(35, 5, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(36, 7, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(37, 8, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(38, 9, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(39, 10, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(40, 11, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(41, 22, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(42, 23, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(43, 24, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(44, 25, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(45, 26, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(46, 1, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(47, 2, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(48, 17, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(49, 18, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(50, 19, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(51, 20, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(52, 21, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(53, 12, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(54, 13, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(55, 14, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(56, 15, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(57, 16, 'H4d8j', '[\"ROLE_ADMIN_H4d8j\"]', 1, '2019-05-24 11:41:41', '2019-05-24 11:41:41'),
(58, 9, 'pwz6sav', '[\"ROLE_USER_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(59, 11, 'pwz6sav', '[\"ROLE_USER_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(60, 4, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(61, 5, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(62, 7, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(63, 8, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(64, 9, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(65, 10, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(66, 11, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(67, 22, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(68, 23, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(69, 24, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(70, 25, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(71, 26, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(72, 1, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(73, 2, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(74, 17, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(75, 18, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(76, 19, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(77, 20, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(78, 21, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(79, 12, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(80, 13, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(81, 14, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(82, 15, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(83, 16, 'pwz6sav', '[\"ROLE_ADMIN_pwz6sav\"]', 1, '2019-05-24 11:45:22', '2019-05-24 11:45:22'),
(84, 9, 'ADb9GJw', '[\"ROLE_USER_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(85, 11, 'ADb9GJw', '[\"ROLE_USER_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(86, 4, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(87, 5, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(88, 7, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(89, 8, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(90, 9, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(91, 10, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(92, 11, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(93, 22, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(94, 23, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(95, 24, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(96, 25, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(97, 26, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(98, 1, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(99, 2, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(100, 17, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(101, 18, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(102, 19, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(103, 20, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(104, 21, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(105, 12, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(106, 13, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(107, 14, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(108, 15, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(109, 16, 'ADb9GJw', '[\"ROLE_ADMIN_ADb9GJw\"]', 1, '2019-05-26 14:46:28', '2019-05-26 14:46:28'),
(110, 9, '3CT7bs', '[\"ROLE_USER_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(111, 11, '3CT7bs', '[\"ROLE_USER_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(112, 4, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(113, 5, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(114, 7, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(115, 8, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(116, 9, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(117, 10, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(118, 11, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(119, 22, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(120, 23, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(121, 24, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(122, 25, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(123, 26, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(124, 1, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(125, 2, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(126, 17, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(127, 18, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(128, 19, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(129, 20, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(130, 21, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(131, 12, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(132, 13, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(133, 14, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(134, 15, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(135, 16, '3CT7bs', '[\"ROLE_ADMIN_3CT7bs\"]', 1, '2019-06-12 09:14:58', '2019-06-12 09:14:58'),
(136, 9, 'MJckLpmXe', '[\"ROLE_USER_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(137, 11, 'MJckLpmXe', '[\"ROLE_USER_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(138, 4, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(139, 5, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(140, 7, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(141, 8, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(142, 9, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(143, 10, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(144, 11, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(145, 22, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(146, 23, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(147, 24, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(148, 25, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(149, 26, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(150, 1, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(151, 2, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(152, 17, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(153, 18, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(154, 19, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(155, 20, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(156, 21, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(157, 12, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(158, 13, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(159, 14, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(160, 15, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(161, 16, 'MJckLpmXe', '[\"ROLE_ADMIN_MJckLpmXe\"]', 1, '2019-06-12 09:15:25', '2019-06-12 09:15:25'),
(162, 9, 'Cup64S', '[\"ROLE_USER_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(163, 11, 'Cup64S', '[\"ROLE_USER_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(164, 4, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(165, 5, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(166, 7, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(167, 8, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(168, 9, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(169, 10, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(170, 11, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(171, 22, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(172, 23, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(173, 24, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(174, 25, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(175, 26, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(176, 1, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(177, 2, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(178, 17, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(179, 18, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(180, 19, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(181, 20, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(182, 21, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(183, 12, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(184, 13, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(185, 14, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(186, 15, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(187, 16, 'Cup64S', '[\"ROLE_ADMIN_Cup64S\"]', 1, '2019-06-12 09:23:32', '2019-06-12 09:23:32'),
(188, 9, 'LNDp', '[\"ROLE_USER_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(189, 11, 'LNDp', '[\"ROLE_USER_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(190, 4, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(191, 5, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(192, 7, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(193, 8, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(194, 9, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(195, 10, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(196, 11, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(197, 22, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(198, 23, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(199, 24, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(200, 25, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(201, 26, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(202, 1, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(203, 2, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(204, 17, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(205, 18, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(206, 19, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(207, 20, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(208, 21, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(209, 12, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(210, 13, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(211, 14, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(212, 15, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(213, 16, 'LNDp', '[\"ROLE_ADMIN_LNDp\"]', 1, '2019-06-12 09:31:47', '2019-06-12 09:31:47'),
(214, 9, 'GNazf', '[\"ROLE_USER_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(215, 11, 'GNazf', '[\"ROLE_USER_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(216, 4, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(217, 5, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(218, 7, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(219, 8, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(220, 9, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(221, 10, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(222, 11, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(223, 22, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(224, 23, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(225, 24, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(226, 25, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(227, 26, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(228, 1, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(229, 2, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(230, 17, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(231, 18, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(232, 19, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(233, 20, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(234, 21, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(235, 12, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(236, 13, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(237, 14, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(238, 15, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23'),
(239, 16, 'GNazf', '[\"ROLE_ADMIN_GNazf\"]', 1, '2019-06-12 09:32:23', '2019-06-12 09:32:23');

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

--
-- Structure de la table `point`
--

CREATE TABLE `point` (
  `id` int(11) NOT NULL,
  `code` varchar(21) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(110) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `region` varchar(61) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `departement` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `point` (`id`, `code`, `adresse`, `region`, `departement`) VALUES
(215, '10105', 'ZIGUINCHOR', 'ZIGUINCHOR', '45'),
(216, '10110', 'BUREAU DE POSTE AERO LAO QUARTIER HALAYBE', 'SAINT-LOUIS', '31'),
(217, '10112', 'BUREAU DE POSTE AGNAM CIVOL VILLAGE AGNAM CIVOL', 'MATAM', '28'),
(218, '10115', 'VILLAGE AROUNDOU', 'TAMBACOUNDA', '39'),
(219, '10123', 'VILLAGE DE BAILA', 'ZIGUINCHOR', '45'),
(220, '10120', 'BUREAU DE POSTE DE BAKEL QUARTIER NDIAYEGA 3', 'TAMBACOUNDA', '36'),
(221, '10125', 'BUREAU DE POSTE BALLOU VILLAGE BALLOU', 'TAMBACOUNDA', '39'),
(222, '10130', 'BUREAU DE POSTE DE BAMBEY QUARTIER ESCALE', 'DIOURBEL', '5'),
(223, '10140', 'BARGNY QUARTIER DAROU 1 RTE NATIONALE', 'DAKAR', '4'),
(224, '10150', 'BUREAU DE POSTE BIGNONA QUARTIER ESCALE', 'ZIGUINCHOR', '43'),
(225, '10160', 'BUREAU DE POSTE BIRKILANE QUARTIER ESCALE', 'KAOLACK', '11'),
(226, '10163', 'BUREAU DE POSTE BOKIDIAWE QUARTIER TIEWEL', 'MATAM', '28'),
(227, '10161', 'BUREAU DE POSTE BOKILADJI QUARTIER KIDING KANO', 'MATAM', '28'),
(228, '10162', 'BUREAU DE POSTE DE BOUNKILING BOUNKILING', 'ZIGUINCHOR', '45'),
(229, '10164', 'BUREAU DE POSTE DE CABROUSSE / CAP SKIRING QUARTIER NIALOU', 'ZIGUINCHOR', '45'),
(230, '10170', 'BUREAU DE POSTE CAS CAS QUARTIER ESCALE', 'SAINT-LOUIS', '31'),
(231, '10190', 'BUREAU DE POSTE DE COKI QUARTIER DEGGO', 'LOUGA', '26'),
(232, '10195', 'BUREAU DE COUBALAN ', 'ZIGUINCHOR', '45'),
(233, '10200', 'BUREAU DE POSTE DE DAGANA QUARTIER KAO', 'SAINT-LOUIS', '30'),
(234, '10210', 'BUREAU DE POSTE DAHRA QUARTIER DAROU RAHMANE', 'LOUGA', '26'),
(235, '10220', 'DAKAR PLATEAU IMMEUBLE BUILDING ADMINISTRATIF REZ DE C', 'DAKAR', '1'),
(236, '10241', 'AVENUE DU GENERAL DE GAULLE MONUMENT INDEPENDANCE', 'DAKAR', '1'),
(237, '10260', 'BUREAU DE DAKAR PLATEAU 9, RUE MANAORI IMMEUBLE BRILLIERE DE L\'I', 'DAKAR', '1'),
(238, '10270', 'AVENUE CHEIKH ANTA DIOP RUE AIME CESAIRE ANGLE CHEIKH ANTA DIOP', 'DAKAR', '1'),
(239, '10275', 'BUREAU DE POSTE DE GRAND-YOFF QUARTIER CASTORS DES NIAYES', 'DAKAR', '1'),
(240, '10445', 'HLM DERRIERE LE MARCHE', 'DAKAR', '1'),
(241, '10280', 'ALLEES CHEIKH SIDATHI AIDARA ROND POINT JET D\'EAU', 'DAKAR', '1'),
(242, '10290', 'ROND-POINT MEDINA BLAISE DIAGNE ANGLE MALICK SY', 'DAKAR', '1'),
(243, '10270', 'BUREAU DE LA VDN SACRE COEUR 3 ANCIENNE PISTE', 'DAKAR', '1'),
(244, '10687', 'OUAKAM QUARTIER GOUYE SOR', 'DAKAR', '1'),
(245, '10295', 'BUREAU DE POSTE DES PARCELLES ASSAINIES MARCHE PLLES ASSAINIES UNITE 17', 'DAKAR', '1'),
(246, '10230', 'BUREAU DE POSTE DE PEYTAVIN AVENUE ANDRE PEYTAVIN', 'DAKAR', '1'),
(247, '10710', 'BUREAU DE POSTE PIKINE QUARTIER PIKINE TALY BOUBESS', 'DAKAR', '3'),
(248, '10310', 'AVENUE GEORGES POMPIDOU IMMEUBLE POSTE PONTY ANGLE DENAIN', 'DAKAR', '1'),
(249, '10100', 'AVENUE DJILY MBAYE IMMEUBLE GRANDE POSTE', 'DAKAR', '1'),
(250, '10837', 'EN FACE GENDARMERIE SANGALKAM', 'DAKAR', '4'),
(251, '10280', 'BUREAU DE LA SODIDA DOMAINE INDUSTRIEL-HLM', 'DAKAR', '1'),
(252, '0', 'BUREAU DE SOUMBEDIOUNE CANAL GUEULE TAPEE', 'DAKAR', '1'),
(253, '10940', 'BUREAU DE POSTE THIAROYE MARCHE THIAROYE', 'DAKAR', '3'),
(254, '10230', 'AVENUE PDT LAMINE GUEYE CENTRE COMMERCIAL TOUBA SANDAGA', 'DAKAR', '1'),
(255, '10270', 'UNIVERSITE CHEIKH ANTA DIOP DAKAR', 'DAKAR', '1'),
(256, '10320', 'AEROPORT AEROPORT LEOPOLD SEDAR SENGHORDE DAKAR', 'DAKAR', '1'),
(257, '10325', 'BUREAU DE POSTE DE DAROU MARNANE', 'LOUGA', '26'),
(258, '10335', 'BUREAU DE POSTE DE DEMBAKANE QUARTIER COMON-KANI', 'MATAM', '28'),
(259, '10337', 'BUREAU DE POSTE DEMETH ILE A MORPHILE', 'SAINT-LOUIS', '31'),
(260, '10905', 'THIES', 'THIES', '41'),
(261, '10255', 'QUARTIER DIAMALAYE DAKAR', 'DAKAR', '1'),
(262, '10342', 'BUREAU DE POSTE DIANA MALARY QUARTIER ESCALE', 'KOLDA', '21'),
(263, '10343', 'VILLAGE DIAOBE', 'ZIGUINCHOR', '45'),
(264, '10346', 'COMMUNE DE DIASS', 'THIES', '40'),
(265, '10344', ' DIATTACOUNDA', 'ZIGUINCHOR', '45'),
(266, '10345', 'BUREAU DE POSTE DIAWARA QUARTIER BANGASSI', 'TAMBACOUNDA', '39'),
(267, '10375', 'VILLAGE DIOFFIOR', 'FATICK', '8'),
(268, '10347', 'BUREAU DE POSTE DE DIONEWAR QUARTIER MBINE MACK', 'FATICK', '8'),
(269, '10349', 'DIOSSONG', 'KAOLACK', '16'),
(270, '10350', 'BUREAU DE POSTE DIOULOULOU QUARTIER DOUMASSOU', 'ZIGUINCHOR', '45'),
(271, '10360', 'BUREAU DE POSTE DE DIOURBEL QUARTIER ESCALE', 'DIOURBEL', '6'),
(272, '10353', 'DIOUROUP', 'KAOLACK', '16'),
(273, '10355', 'DJILOR SALOUM', 'KAOLACK', '16'),
(274, '10362', 'BUREAU DE POSTE DODEL VILLAGE DE DODEL', 'SAINT-LOUIS', '31'),
(275, '10365', 'BUREAU DE POSTE DONDOU DONDOUNABE', 'MATAM', '28'),
(276, '10215', 'VILLAGE DE ELINKINE', 'Ziguinchor ', '44'),
(277, '10200', 'DAGANA', 'SAINT-LOUIS ', '30'),
(278, '10367', 'BUREAU DE POSTE DE FASS KANE KAOLACK', 'KAOLACK', '16'),
(279, '10370', 'BUREAU DE POSTE FATICK QUARTIER ESCALE FACE MARCHE CENTRAL', 'FATICK', '8'),
(280, '10375', 'FIMELA QUARTIER PINTOK', 'FATICK', '8'),
(281, '10377', 'BUREAU DE POSTE DE FONGOLEMI', 'TAMBACOUNDA', '39'),
(282, '10380', 'BUREAU DE POSTE FOUNDIOUGNE QUARTIER ESCALE', 'FATICK', '9'),
(283, '10382', 'GABOU', 'TAMBACOUNDA', '39'),
(284, '10385', 'BUREAU DE POSTE GALOYA QUARTIER GALOYA TOUCOULEUR', 'SAINT-LOUIS', '31'),
(285, '10387', 'BUREAU DE POSTE DE GAMADJI SARE', 'MATAM', '28'),
(286, '10390', 'BUREAU DE POSTE GANDIAYE QUARTIER ESCALE', 'KAOLACK', '16'),
(287, '10395', 'BUREAU DE POSTE DE GOLLERE QUARTIER NANAYE', 'SAINT-LOUIS', '31'),
(288, '10397', 'BUREAU DE POSTE GOLMY VILLAGE DE GOLMY', 'TAMBACOUNDA', '39'),
(289, '10400', 'BUREAU DE L\'ILE DE GOREE IMMEUBLE DU CHEVALIER DE BOUFFLERS', 'DAKAR', '1'),
(290, '10410', 'BUREAU DE POSTE GOSSAS QUARTIER ESCALE', 'FATICK', '10'),
(291, '10420', 'BUREAU DE POSTE GOUDIRY QUARTIER CAMPEMENT', 'TAMBACOUNDA', '37'),
(292, '10425', 'BUREAU DE POSTE GOUDOMP QUARTIER DOUMASSOU', 'SEDHIOU', '34'),
(293, '0', 'BUREAU DE POSTE ANNEXE DE GRAND THIES QUARTIER GRAND THIES', 'THIES', '41'),
(294, '10426', 'BUREAU DE POSTE GUEDIAWAYE QUARTIER SAM NOTAIRE', 'DAKAR', '2'),
(295, '10426', 'GUEDIAWAYE', 'DAKAR', '2'),
(296, '10430', 'BUREAU DE POSTE GUEOUL QUARTIER THILLA', 'LOUGA', '26'),
(297, '10440', 'BUREAU DE POSTE GUINGUINEO', 'KAOLACK', '15'),
(298, '10447', 'COMMUNE DE HADOUBERE', 'MATAM', '28'),
(299, '10450', 'BUREAU DE POSTE JOAL QUARTIER AFDAYE DIAMGUENE', 'THIES', '40'),
(300, '10460', 'BUREAU DE POSTE KAFFRINE QUARTIER ESCALE', 'KAFFRINE', '12'),
(301, '10465', 'KAHONE', 'KAOLACK', '16'),
(302, '10470', 'BUREAU DE POSTE KANEL QUARTIER THIELOL', 'MATAM', '28'),
(303, '10485', 'BUREAU DE POSTE KAOLACK NDORONG QUARTIER NDORONG', 'KAOLACK', '16'),
(304, '10480', 'BUREAU DE POSTE KAOLACK QUARTIER LEONA', 'KAOLACK', '16'),
(305, '10475', 'BUREAU DE POSTE DE KARANG REGION DE KAOLACK', 'KAOLACK', '16'),
(306, '10180', 'BUREAU DE POSTE KAYAR QUARTIER TENTE-YOFF EN FACE GARE ROUTIERE', 'THIES', '41'),
(307, '10490', 'BUREAU DE POSTE DE KEBEMER QUARTIER ESCALE', 'LOUGA', '24'),
(308, '10500', 'BUREAU DE POSTE KEDOUGOU QUARTIER DANDE MAYO', 'KEDOUGOU', '18'),
(309, '10510', 'BUREAU DE POSTE KELLE VILLAGE KELLE', 'LOUGA', '24'),
(310, '10680', 'KEUR AYIB', 'KAOLACK', '17'),
(311, '10680', 'KEUR MADIABEL', 'KAOLACK', '17'),
(312, '10515', 'DAKAR', 'DAKAR', '3'),
(313, '10520', 'BUREAU DE POSTE KHOMBOLE QUARTIER ESCALE', 'THIES', '41'),
(314, '10530', 'BUREAU DE POSTE KIDIRA QUARTIER LIBERTE', 'TAMBACOUNDA', '39'),
(315, '0', 'VILLAGE DE KOBILO SUR LA ROUTE NATIONALE ', 'MATAM', '28'),
(316, '10540', 'BUREAU DE POSTE KOLDA QUARTIER ESCALE', 'KOLDA', '21'),
(317, '10545', 'KOTHIARY', 'TAMBACOUNDA', '39'),
(318, '10552', 'BUREAU DE POSTE KOUMPENTOUM QUARTIER GUINAW RAIL', 'TAMBACOUNDA', '38'),
(319, '10550', 'BUREAU DE POSTE KOUNGHEUL QUARTIER ESCALE', 'KAFFRINE', '13'),
(320, '10555', 'BUREAU DE POSTE KOUSSANAR QUARTIER ESCALE', 'TAMBACOUNDA', '39'),
(321, '0', 'LAOL TAMBA', 'KEDOUGOU', '18'),
(322, '10560', 'BUREAU DE POSTE LINGUERE QUARTIER ESCALE', 'LOUGA', '25'),
(323, '10157', 'BUREAU DE POSTE LOUGA ANNEXE QUARTIER ARTILLERIE', 'LOUGA', '26'),
(324, '10570', 'BUREAU DE POSTE LOUGA RP QUARTIER GRAND LOUGA', 'LOUGA', '26'),
(325, '10572', 'BUREAU DE POSTE MACKACOLIBANTANG QUARTIER ESCALE', 'TAMBACOUNDA', '39'),
(326, '10575', 'BUREAU DE POSTE MALEM HODDAR QUARTIER GUINAW RAIL', 'KAFFRINE', '14'),
(327, '10577', 'SUR LA ROUTE DE MEDINA GOUNASS', 'KOLDA', '21'),
(328, '10580', 'BUREAU DE POSTE MARSASSOUM QUARTIER ESCALE', 'KOLDA', '21'),
(329, '10590', 'BUREAU DE POSTE MATAM QUARTIER TANTADJI', 'MATAM', '28'),
(330, '10600', 'BUREAU DE POSTE MBACKE QUARTIER ESCALE', 'DIOURBEL', '7'),
(331, '10610', 'BUREAU DE POSTE MBORO QUARTIER LASSERE', 'THIES', '42'),
(332, '10615', 'BUREAU DE POSTE MBOUMBA QUARTIER LEGAL GARAGE', 'SAINT-LOUIS', '31'),
(333, '10620', 'BUREAU DE POSTE MBOUR QUARTIER ESCALE', 'THIES', '40'),
(334, '0', 'QUARTIER MEDINE APRES CROISEMENT SALY', 'THIES', '40'),
(335, '0', 'GRAND MBOUR PRES DE LA DOUANE', 'THIES', '40'),
(336, '10905', 'MEDINA FALL', 'THIES', '41'),
(337, '10635', 'BUREAU DE POSTE MEDINA GOUMASS QUARTIER DAOU IDIARATOU', 'KOLDA', '21'),
(338, '10633', 'MEDINA MARY', 'Kolda', '23'),
(339, '10638', 'BUREAU DE POSTE MEDINA NDIATBE ILE A MORPHILE', 'SAINT-LOUIS', '31'),
(340, '10636', 'MEDINA YORO FOULAH', 'KOLDA', '21'),
(341, '10630', 'BUREAU DE POSTE MEKHE QUARTIER ESCALE', 'LOUGA', '24'),
(342, '10637', 'BUREAU DE POSTE DE MISSIRAH', 'TAMBACOUNDA', '39'),
(343, '10639', 'BUREAU DE POSTE MOUDERY QUARTIER KIMBAKA', 'TAMBACOUNDA', '39'),
(344, '0', 'BUREAU DE POSTE DE MPAL', 'SAINT-LOUIS', '32'),
(345, '10630', 'BUREAU DE POSTE NDANDE QUARTIERESCALE', 'LOUGA', '24'),
(346, '10637', 'BUREAU DE POSTE DE NDENDORY', 'MATAM', '28'),
(347, '10639', 'BUREAU DE POSTE NDIAGANIAO QUARTIER ESCALE', 'FATICK', '8'),
(348, '10630', 'NDIANDANE', 'SAINT-LOUIS', '31'),
(349, '10905', 'BUREAU DE POSTE DE NDIASSANE', 'THIES', '42'),
(350, '10648', 'NDIEDIENG', 'KAOLACK', '16'),
(351, '10650', 'BUREAU DE POSTE DE NDIOUM QUARTIER NDIANGA', 'SAINT-LOUIS', '31'),
(352, '10660', 'BUREAU DE POSTE NDOFFANE QUARTIER SIX-ROUTES', 'KAOLACK', '16'),
(353, '10670', 'BUREAU DE POSTE NDOULO QUARTIER ESCALE', 'DIOURBEL', '7'),
(354, '10675', 'BUREAU DE POSTE NDOULOUMADJI VILLAGE DE NDOULOUMADJI', 'MATAM', '28'),
(355, '10620', 'BUREAU DE POSTE NGAPAROU ROUTE DE SALY QUARTIER ROND-POINT', 'THIES', '40'),
(356, '10620', 'BUREAU DE POSTE DE NGUEKHOKH', 'THIES', '40'),
(357, '10677', 'BUREAU DE POSTE DE NGUIDJILONE VILLAGE DE NGUIDJILONE', 'MATAM', '28'),
(358, '10678', 'NIAKHAR', 'FATICK', '8'),
(359, '10680', 'BUREAU DE POSTE NIORO QUARTIER CENTRE', 'KAOLACK', '17'),
(360, '10480', 'Ocass', 'DAKAR', '1'),
(361, '10683', 'BUREAU DE POSTE OREFONDE VILLAGE OREFONDE', 'MATAM', '28'),
(362, '10685', 'ORKADIERE', 'MATAM', '28'),
(363, '10689', 'BUREAU DE POSTE OUROSSOGUI QUARTIER MODERNE', 'MATAM', '28'),
(364, '0', 'ANNEXE OUROSSOGUI MODERNE ROUTE NATIONALE', 'MATAM', '28'),
(365, '10690', 'BUREAU DE POSTE OUSSOUYE QUARTIER SOULEUCK', 'ZIGUINCHOR', '44'),
(366, '10692', 'BUREAU DE POSTE DE PALMARIN A PALMARIN', 'FATICK', '8'),
(367, '10695', 'BUREAU DE POSTE PASSY QUARTIER LEONA', 'KAOLACK', '16'),
(368, '0', 'commune de PATA', 'Kolda', '23'),
(369, '10700', 'BUREAU DE POSTE PEKESSE QUARTIER COMMERCIAL', 'THIES', '41'),
(370, '10705', 'BUREAU DE POSTE PETE QUARTIER SINTHIANE', 'SAINT-LOUIS', '31'),
(371, '10720', 'BUREAU DE POSTE PIRE VOIE FERREE', 'LOUGA', '26'),
(372, '10730', 'BUREAU DE POSTE PODOR QUARTIER MBODIENE', 'SAINT-LOUIS', '31'),
(373, '10740', 'BUREAU DE POSTE POPENGUINE QUARTIER ESCALE', 'THIES', '41'),
(374, '10750', 'BUREAU DE POSTE POUT QUARTIER POUT GARAGE', 'THIES', '41'),
(375, '10755', 'BUREAU DE POSTE DE RANEROU', 'MATAM', '29'),
(376, '10800', 'RAO', 'SAINT-LOUIS', '32'),
(377, '10760', 'BUREAU DE POSTE RICHARD-TOLL CITE SENEGAL', 'SAINT-LOUIS', '32'),
(378, '10765', 'BUREAU DE POSTE ROSS BETHIO QUARTIER ROSS', 'SAINT-LOUIS', '32'),
(379, '10770', 'BUREAU DE POSTE ROSSO-SENEGAL QUARTIER SANTHIABA 2', 'SAINT-LOUIS', '32'),
(380, '10780', 'BUREAU DE POSTE RUFISQUE QUARTIER KEURY KAO', 'DAKAR', '4'),
(381, '10790', 'BUREAU DE POSTE SAGATTA QUARTIER ESCALE', 'LOUGA', '24'),
(382, '10815', 'BUREAU DE POSTE SAINT LOUIS SOR QUARTIER SOR PRES DE LA POLICE DE SOR', 'SAINT-LOUIS', '32'),
(383, '10800', 'BUREAU DE POSTE SAINT LOUIS RECETTES PRI PRINCIPALES', 'SAINT-LOUIS', '32'),
(384, '10800', 'QUARTIER NDAR TOUTE', 'SAINT-LOUIS', '32'),
(385, '10820', 'BUREAU DE POSTE SAKAL VILLAGE DE SAKAL', 'LOUGA', '26'),
(386, '10830', 'BUREAU DE POSTE SALDE VILLAGE DE SALDE', 'SAINT-LOUIS', '31'),
(387, '10832', 'SALEMATA', 'KEDOUGOU ', '19'),
(388, '10835', 'SALY PORTUDAL', 'THIES', '40'),
(389, '10620', 'SANDIARA', 'THIES', '40'),
(390, '10838', 'BUREAU DE POSTE SARAYA VILLAGE DE SARAYA', 'KEDOUGOU', '20'),
(391, '10840', 'SEBIKHOTANE QUARTIER ESCALE', 'DAKAR', '4'),
(392, '10850', 'BUREAU DE POSTE SEDHIOU QUARTIER MANSSACOUNDA', 'SEDHIOU', '35'),
(393, '10860', 'BUREAU DE POSTE SEME QUARTIER GRANDE MOSQUEE', 'MATAM', '28'),
(394, '10480', 'SIBASSOR', 'KAOLACK', '16'),
(395, '10620', 'MBOUR', 'THIES', '40'),
(396, '10862', 'SINDIAN', 'ZIGUINCHOR', '45'),
(397, '10865', 'BUREAU DE POSTE SINTHIOU BAMAMBE QUARTIER NIAROUWAL', 'MATAM', '28'),
(398, '0', 'SINTHIOU GARGA', 'MATAM', '28'),
(399, '10870', 'BUREAU DE POSTE SOKONE QUARTIER LEONA', 'KAOLACK', '16'),
(400, '10620', 'SOMONE', 'THIES', '40'),
(401, '10875', 'BUREAU DE POSTE DE SOUM', 'KAOLACK', '16'),
(402, '0', 'TAIBA NIASSENE', 'KAOLACK', '17'),
(403, '10880', 'BUREAU DE POSTE TAMBACOUNDA QUARTIER LIBERTE', 'TAMBACOUNDA', '39'),
(404, '0', 'BUREAU DE TAMBACOUNDA-PONT QUARTIER PONT', 'TAMBACOUNDA', '39'),
(405, '10885', 'BUREAU DE POSTE TANAFF QUARTIER MASSACOUNDA', 'KOLDA', '21'),
(406, '10730', 'PODOR', 'SAINT-LOUIS', '31'),
(407, '10915', 'BUREAU DE POSTE THIADIAYE QUARTIER ESCALE', 'FATICK', '8'),
(408, '0', 'THIENABA', 'THIES', '41'),
(409, '10900', 'BUREAU DE POSTE THIES ESCALE QUARTIER ESCALE', 'THIES', '41'),
(410, '10905', 'BUREAU DE POSTE THIES RECETTES PRINCIPALES QUARTIER DIXIEME', 'THIES', '41'),
(411, '10910', 'BUREAU DE POSTE THILLE BOUBACAR MARCHE THILLE BOUBACAR', 'SAINT-LOUIS', '31'),
(412, '10920', 'BUREAU DE POSTE DE THILMAKHA', 'THIES', '41'),
(413, '10930', 'BUREAU DE POSTE THILOGNE QUARTIER DIABE SALANE', 'MATAM', '28'),
(414, '10945', 'BUREAU DE POSTE THIONK-ESSYL QUARTIER DAGA', 'ZIGUINCHOR', '45'),
(415, '10950', 'BUREAU DE POSTE TIVAOUANE GARE DE TIVAOUNE', 'THIES', '42'),
(416, '10952', 'BUREAU DE POSTE DE TOUBA QUARTIER TOUBA 28', 'DIOURBEL', '7'),
(417, '0', 'BUREAU DE POSTE DE DAROUKHOUDOSS DAROU KHOUDOSS', 'DIOURBEL', '7'),
(418, '0', 'BUREAU DE POSTE DE DAROU MOUSTY QUARTIER ESCALE', 'LOUGA', '24'),
(419, '10954', 'BUREAU DE POSTE TOUBACOUTA QUARTIER SOUCOUTA', 'FATICK', '9'),
(420, '10957', 'TOUBATOUL', 'THIES', '41'),
(421, '10960', 'BUREAU DE POSTE VELINGARA QUARTIER CENTRE 1', 'KOLDA', '21'),
(422, '10965', 'BUREAU DE POSTE WAOUNDE MARCHE WAOUNDE', 'MATAM', '28'),
(423, '10966', 'BUREAU DE POSTE WODOBERE QUARTIER BOUCHOURA', 'MATAM', '28'),
(424, '10967', 'BUREAU DE POSTE YAFERA VILLAGE DE YAFERA', 'TAMBACOUNDA', '39'),
(425, '10968', 'YENE', 'DAKAR ', '4'),
(426, '10322', 'ZAC MBAO', 'DAKAR', '3'),
(427, '10971', 'BUREAU DE POSTE ZIGUINCHOR ESCALE QUARTIER ESCALE', 'ZIGUINCHOR', '45'),
(428, '10970', 'BUREAU DE POSTE ZIGUINCHOR QUARTIER YAMA TOGNE', 'ZIGUINCHOR', '45');

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

--
-- Structure de la table `region`
--

CREATE TABLE `region` (
  `id` int(11) NOT NULL,
  `nom` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `longitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altitude` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `region` (`id`, `nom`, `longitude`, `altitude`, `date_creation`, `date_modification`) VALUES
(1, 'DAKAR', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(2, 'DIOURBEL', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(3, 'FATICK', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(4, 'KAFFRINE', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(5, 'KAOLACK', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(6, 'KEDOUGOU', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(7, 'KOLDA', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(8, 'LOUGA', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(9, 'MATAM', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(10, 'SAINT-LOUIS', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(11, 'SEDHIOU', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(12, 'TAMBACOUNDA', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(13, 'THIES', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07'),
(14, 'ZIGUINCHOR', NULL, NULL, '2019-08-08 09:59:07', '2019-08-08 09:59:07');

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

--
-- Structure de la table `role`
--

CREATE TABLE `role` (
  `id` int(11) NOT NULL,
  `libelle` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nom` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_creation` datetime DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  `status` tinyint(1) NOT NULL,
  `for_network` tinyint(1) NOT NULL DEFAULT '0',
  `is_internal` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role` (`id`, `libelle`, `nom`, `date_creation`, `date_modification`, `status`, `for_network`, `is_internal`) VALUES
(1, 'ROLE_ADMIN_BGDIGIT', 'PLATFORM ADMINISTRATOR ', NULL, NULL, 1, 1, 1),
(2, 'ROLE_USER_BGDIGIT', 'PLATFORM USER', NULL, NULL, 1, 1, 1),
(3, 'ROLE_TESTEUR_BGDIGIT', 'PLATFORM TESTEUR', '2019-02-21 15:23:50', NULL, 0, 1, 1),
(4, 'ROLE_ADMIN', 'ADMINISTRATOR', '2019-05-24 11:41:41', NULL, 1, 1, 0),
(5, 'ROLE_USER', 'USER', NULL, '2019-05-24 11:41:41', 1, 1, 0),
(18, 'ROLE_DAF', 'DAF', NULL, '2019-05-24 11:45:22', 1, 1, 0),
(19, 'ROLE_CAISSIER', 'CAISSIER', NULL, '2019-05-24 11:45:22', 1, 1, 0),
(20, 'ROLE_CA', 'CHEF AGENCE', NULL, '2019-05-24 11:45:22', 1, 1, 0),
(21, 'ROLE_USER_WALLET', 'WALLET USER', NULL, '2019-05-24 11:45:22', 1, 0, 0),
(22, 'ROLE_SUPERVISEUR', 'SUPERVISEUR', NULL, '2019-05-24 11:45:22', 1, 1, 0),
(23, 'ROLE_CONTROLLEUR', 'CONTROLLEUR', NULL, '2019-05-24 11:45:22', 1, 1, 0),
(24, 'ROLE_SUPPORT', 'SUPPORT', NULL, '2019-05-24 11:41:41', 1, 1, 0),
(25, 'ROLE_ADMIN_FINANCES', 'ADMIN FINANCES', NULL, '2019-05-24 11:45:22', 1, 1, 0);

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

--
-- Structure de la table `user_role`
--

CREATE TABLE `user_role` (
  `user_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_role` (`user_id`, `role_id`) VALUES
(5, 4),
(6, 4),
(7, 19),
(8, 20),
(11, 20),
(18, 21),
(21, 21),
(23, 21),
(24, 4),
(29, 4),
(32, 19);

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

--
-- Index pour la table `access`
--
ALTER TABLE `access`
  ADD PRIMARY KEY (`id`),
  ADD KEY `search_idx` (`login`,`ip`);

--
-- Index pour la table `action`
--
ALTER TABLE `action`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_47CC8C922C42079` (`route`),
  ADD KEY `IDX_47CC8C92AFC2B591` (`module_id`);

--
-- Index pour la table `agence`
--
ALTER TABLE `agence`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_64C19AA977153098` (`code`),
  ADD KEY `search_idx` (`code`,`code_entite`),
  ADD KEY `IDX_64C19AA9CCF9E01E` (`departement_id`);

--
-- Index pour la table `commune`
--
ALTER TABLE `commune`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E2E2D1EECCF9E01E` (`departement_id`);

--
-- Index pour la table `departement`
--
ALTER TABLE `departement`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_C1765B636C6E55B5` (`nom`),
  ADD KEY `IDX_C1765B6398260155` (`region_id`);

--
-- Index pour la table `migration_versions`
--
ALTER TABLE `migration_versions`
  ADD PRIMARY KEY (`version`);

--
-- Index pour la table `module`
--
ALTER TABLE `module`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_C242628A4D60759` (`libelle`),
  ADD UNIQUE KEY `UNIQ_C24262873A27E8A` (`code_module`);

--
-- Index pour la table `permission`
--
ALTER TABLE `permission`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_E04992AA9D32F035` (`action_id`);

--
-- Index pour la table `point`
--
ALTER TABLE `point`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `region`
--
ALTER TABLE `region`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_F62F1766C6E55B5` (`nom`);

--
-- Index pour la table `role`
--
ALTER TABLE `role`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_57698A6AA4D60759` (`libelle`);

--
-- Index pour la table `user_role`
--
ALTER TABLE `user_role`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `IDX_2DE8C6A3A76ED395` (`user_id`),
  ADD KEY `IDX_2DE8C6A3D60322AC` (`role_id`);

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

--
-- AUTO_INCREMENT pour la table `access`
--
ALTER TABLE `access`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `action`
--
ALTER TABLE `action`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT pour la table `agence`
--
ALTER TABLE `agence`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=244;

--
-- AUTO_INCREMENT pour la table `commune`
--
ALTER TABLE `commune`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=557;

--
-- AUTO_INCREMENT pour la table `departement`
--
ALTER TABLE `departement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT pour la table `module`
--
ALTER TABLE `module`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT pour la table `permission`
--
ALTER TABLE `permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=240;

--
-- AUTO_INCREMENT pour la table `point`
--
ALTER TABLE `point`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=429;

--
-- AUTO_INCREMENT pour la table `region`
--
ALTER TABLE `region`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT pour la table `role`
--
ALTER TABLE `role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

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

--
-- Contraintes pour la table `action`
--
ALTER TABLE `action`
  ADD CONSTRAINT `FK_47CC8C92AFC2B591` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`);

--
-- Contraintes pour la table `agence`
--
ALTER TABLE `agence`
  ADD CONSTRAINT `FK_64C19AA9CCF9E01E` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`);

--
-- Contraintes pour la table `commune`
--
ALTER TABLE `commune`
  ADD CONSTRAINT `FK_E2E2D1EECCF9E01E` FOREIGN KEY (`departement_id`) REFERENCES `departement` (`id`);

--
-- Contraintes pour la table `departement`
--
ALTER TABLE `departement`
  ADD CONSTRAINT `FK_C1765B6398260155` FOREIGN KEY (`region_id`) REFERENCES `region` (`id`);

--
-- Contraintes pour la table `permission`
--
ALTER TABLE `permission`
  ADD CONSTRAINT `FK_E04992AA9D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`);

--
-- Contraintes pour la table `user_role`
--
ALTER TABLE `user_role`
  ADD CONSTRAINT `FK_2DE8C6A3A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_2DE8C6A3D60322AC` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`) ON DELETE CASCADE;
