-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : dim. 16 juil. 2023 à 13:41
-- Version du serveur : 8.0.27
-- Version de PHP : 7.4.26

START TRANSACTION;



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

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

--
-- Structure de la table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `admins_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `admins` (`id`, `name`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'Dago Dassi', 8, '2023-02-28 08:03:49', '2023-02-28 08:03:49');

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

--
-- Structure de la table `analyses`
--

CREATE TABLE IF NOT EXISTS `analyses` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `analyses` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(10, 'Ecographie', '2023-02-21 17:20:06', '2023-02-21 17:20:06'),
(11, 'ECG', '2023-02-21 17:20:15', '2023-02-21 17:20:15'),
(12, 'NFS', '2023-02-21 17:20:28', '2023-02-21 17:20:28'),
(13, 'CRP', '2023-02-21 17:22:03', '2023-02-21 17:22:03'),
(14, 'Ecographie pelvienne', '2023-03-07 17:57:20', '2023-03-07 17:57:20');

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

--
-- Structure de la table `analyse_clinique`
--

CREATE TABLE IF NOT EXISTS `analyse_clinique` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `analyse_id` bigint UNSIGNED NOT NULL,
  `clinique_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `analyse_clinique_analyse_id_foreign` (`analyse_id`),
  KEY `analyse_clinique_clinique_id_foreign` (`clinique_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `analyse_clinique` (`id`, `analyse_id`, `clinique_id`, `created_at`, `updated_at`, `description`, `price`) VALUES
(1, 10, 1, NULL, NULL, 'Ecographie abdominale', 15000),
(5, 10, 3503, '2023-03-06 14:10:57', '2023-03-06 14:10:57', 'Ecographie abdominale', 11000),
(9, 10, 3504, '2023-03-06 14:11:31', '2023-03-06 14:11:31', 'Ecographie abdominale', 10000),
(13, 14, 1, NULL, NULL, 'Ecographie pelvienne', 20000),
(14, 11, 1, NULL, NULL, 'Electro-cardiogramme', 50000);

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

--
-- Structure de la table `cliniques`
--

CREATE TABLE IF NOT EXISTS `cliniques` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `localisation` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `telephone` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lon` float NOT NULL,
  `lat` float NOT NULL,
  `commune_id` bigint UNSIGNED NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cliniques_user_id_foreign` (`user_id`),
  KEY `commune_id` (`commune_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4087 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `cliniques` (`id`, `localisation`, `created_at`, `updated_at`, `user_id`, `telephone`, `name`, `lon`, `lat`, `commune_id`) VALUES
(1, 'Palmeraie rue ministre', '2023-02-21 12:38:31', '2023-02-21 12:38:31', 6, '000000000', 'Centre médical de la palmeraie', 0, 0, 1),
(3503, 'ci', '2023-02-23 14:56:56', '2023-02-23 14:56:56', 6, '0000000000', 'Dispensaire diocésain sœur Catherine', 5.3391, -4.09819, 1),
(3504, 'ci', '2023-02-23 14:56:56', '2023-02-23 14:56:56', 6, '0000000000', 'Centre Hospitalier Universitaire de Yopougon', 5.35843, -4.08984, 11),
(3505, 'ci', '2023-02-23 14:56:56', '2023-02-23 14:56:56', 6, '0000000000', 'Centre Hospitalier Universitaire de Treichville', 5.29158, -4.00357, 11),
(3506, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Centre de Transfusion Sanguine30 64 08 69', 6.82783, -5.2626, 11),
(3507, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'CHR de Yamoussoukro', 6.81751, -5.27726, 11),
(3508, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Hôpital de police du Plateau', 5.33641, -4.02312, 11),
(3509, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Baptist Hospital', 9.81726, -3.3462, 11),
(3510, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Centre Medical et d\'Imagerie Diagnostique (CMIDA)', 5.29512, -3.98051, 11),
(3511, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Infirmerie INPHB Centre', 6.87875, -5.22744, 11),
(3512, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Clinique les Grâces', 5.28759, -3.9779, 11),
(3513, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Hopital Général de Oumé', 6.37878, -5.41866, 11),
(3514, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Clinique Paul Simon', 6.3827, -5.41515, 11),
(3515, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Grande Endemie', 5.46673, -3.20832, 11),
(3516, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Centre Hospitalier Universitaire', 7.69965, -5.03638, 11),
(3517, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Polyclinique Internationale Sainte Anne-Marie (PISAM)', 5.33684, -4.01335, 11),
(3518, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Centre hospitalier universitaire de Cocody (CHU de Cocody)', 5.34234, -3.99385, 11),
(3519, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Hopital General d\'Alépé', 5.50279, -3.66243, 11),
(3520, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Formation sanitaire municipal de Zimbabwe', 4.76081, -6.66547, 11),
(3521, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Hôpital Général de Bonoua', 5.27458, -3.59127, 11),
(3522, 'ci', '2023-02-23 14:56:57', '2023-02-23 14:56:57', 6, '0000000000', 'Hopital HPD Dabou', 5.32942, -4.38882, 11),
(3523, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'centre medical social', 5.39041, -4.01654, 11),
(3524, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Clinique Saint Augustin', 6.82458, -5.27725, 11),
(3525, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Clinique Saint-Michel', 5.34715, -4.08768, 11),
(3526, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Hopital Militaire', 5.78531, -6.60659, 11),
(3527, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Hopital general', 7.45875, -4.33692, 11),
(3528, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Hôpital Général de Daoukro', 7.05782, -3.97158, 11),
(3529, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Centre de Santé Urbaine de Bonon', 6.92676, -6.05388, 11),
(3530, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Hôpital Générale d\'Agboville', 5.91977, -4.21629, 11),
(3531, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.32588, -4.10722, 11),
(3532, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'CSU Tafiré', 9.07019, -5.1558, 11),
(3533, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Clinique Perle', 6.37705, -5.41649, 11),
(3534, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Medico Scolaire Oumé', 6.37911, -5.41491, 11),
(3535, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Polyclinique Le Panthéon Médical', 5.35345, -3.95754, 11),
(3536, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', 'Hôpital Saint-Joseph Moscati', 6.81321, -5.29096, 11),
(3537, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.31964, -6.53106, 11),
(3538, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.31922, -6.53111, 11),
(3539, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.31936, -6.53112, 11),
(3540, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.31952, -6.53144, 11),
(3541, 'ci', '2023-02-23 14:56:58', '2023-02-23 14:56:58', 6, '0000000000', '', 5.3194, -6.53086, 11),
(3542, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', '', 5.31981, -6.53125, 11),
(3543, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', '', 5.31959, -6.53135, 11),
(3544, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', '', 5.3193, -6.5309, 11),
(3545, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', '', 5.31927, -6.531, 11),
(3546, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Clinique St Thérèse', 7.39885, -7.5491, 11),
(3547, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', '', 6.96891, -3.90719, 11),
(3548, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Hôpital d\'Arrah', 6.68192, -3.96656, 11),
(3549, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Grandes Endemies', 7.39604, -7.55103, 11),
(3550, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Hopital General', 6.65444, -4.21191, 11),
(3551, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Centre Médical Chardy', 5.3238, -4.01614, 11),
(3552, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Hopital General de Grand-Bassam', 5.2079, -3.73576, 11),
(3553, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Clinique Sainte Rita de Cascia', 5.34081, -4.08767, 0),
(3554, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Nouvelle Clinique Farah', 5.31066, -3.98647, 15),
(3555, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Centre de Santé Urbain Diaye Bernard', 6.75222, -7.33657, 15),
(3556, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Centre de Santé Urbain Diaye Bernard', 6.75198, -7.33664, 15),
(3557, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Clinique Procréa', 5.36498, -3.96193, 15),
(3558, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Agefosyn', 5.32455, -4.09025, 15),
(3559, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Centre Hospitalier Régional de Gagnoa', 6.12604, -5.94459, 15),
(3560, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Dispensaire Urbain de Gagnoa', 6.12657, -5.94959, 15),
(3561, 'ci', '2023-02-23 14:56:59', '2023-02-23 14:56:59', 6, '0000000000', 'Hôpital Mère-Enfant de Bingerville', 5.36194, -3.88396, 15),
(3562, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'PMI Bingerville', 5.35623, -3.89092, 15),
(3563, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'centre de santé', 6.66891, -5.14892, 15),
(3564, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Hôpital préfectoral de Boundiali', 9.51849, -6.48288, 15),
(3565, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Centre de Santé Urbain de Madinani', 9.61097, -6.94633, 15),
(3566, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Coordination des Promoteurs de Groupes Poser Zone de Bouaké', 7.72694, -4.99857, 15),
(3567, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Coordination des Promoteurs de Groupes Poser Zone de Bouaké', 7.72764, -4.99894, 15),
(3568, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Coordination des Promoteurs de Groupes Poser Zone de Bouaké', 7.72779, -4.99874, 15),
(3569, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Maternité Municipale Deleguée de Zimbabwe', 4.76109, -6.66562, 15),
(3570, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', '', 7.39666, -7.56747, 15),
(3571, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Centre hospitalier', 5.45713, -3.97441, 15),
(3572, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Centre Hospitalier Rural', 6.33381, -4.86042, 15),
(3573, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Centre de Santé urbain Azaguié', 5.64598, -4.07738, 15),
(3574, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Maternité de Natio Kobadara', 9.48705, -5.60787, 15),
(3575, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Maternité de Natio Kobadara', 9.48721, -5.60788, 0),
(3576, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Maternité de Natio Kobadara', 9.48726, -5.60768, 20),
(3577, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Maternité de Natio Kobadara', 9.48728, -5.60783, 20),
(3578, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Hôpital Général de Bocanda', 7.06114, -4.50307, 20),
(3579, 'ci', '2023-02-23 14:57:00', '2023-02-23 14:57:00', 6, '0000000000', 'Centre de Santé de Niambezaria', 5.66025, -5.75715, 20),
(3580, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Croix Rouge Boundiali', 9.51772, -6.48401, 0),
(3581, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Case de Santé', 6.90172, -6.40135, 0),
(3582, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Centre Hospitalier Charismatique Eugene 1er', 5.305, -3.95979, 13),
(3583, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Centre Medico-Churigical AMSU', 6.90248, -6.45213, 13),
(3584, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hopital General d\'Anyama;Hopital general d\'Anyama', 5.50098, -4.04585, 13),
(3585, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hopital des soeurs catholique ( Don orion)', 5.49984, -4.04841, 13),
(3586, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hopital Generale', 7.65189, -3.99557, 13),
(3587, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Clinique de Cocody cité des arts - Association medicale de la;Clinique de Cocody cité des arts - Association medicale de la grâce', 5.3442, -3.99917, 13),
(3588, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', '', 5.13596, -3.28988, 13),
(3589, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hopital général de Guiglo', 6.54415, -7.48224, 13),
(3590, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital Militaire d\'Abidjan', 5.38132, -4.00742, 13),
(3591, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital général de Port-Bouët', 5.2629, -3.9621, 13),
(3592, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hopital Général d\'Abobo', 5.42372, -4.01636, 13),
(3593, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital général de Yopougon-Attié', 5.34144, -4.08005, 13),
(3594, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital Houphouët-Boigny', 5.44312, -4.00773, 13),
(3595, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital Général de Fresco', 5.1029, -5.58718, 13),
(3596, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Médico-Scolaire', 6.73146, -3.48637, 13),
(3597, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital Général de Méagui', 5.40672, -6.55876, 13),
(3598, 'ci', '2023-02-23 14:57:01', '2023-02-23 14:57:01', 6, '0000000000', 'Hôpital Générale d\'Adiaké', 5.28521, -3.29881, 13),
(3599, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Polyclinique de l\'Indenié', 5.33838, -4.01907, 13),
(3600, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Hôpital général de Bingerville', 5.3603, -3.8853, 0),
(3601, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Hôpital psychiatrique de Bingerville', 5.36029, -3.88312, 0),
(3602, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'CHR Korhogo', 9.44318, -5.63182, 25),
(3603, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de Santé Urbain de Koko-Ton', 9.46111, -5.63946, 25),
(3604, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Hopital Général de Kouibly', 7.25689, -7.23765, 25),
(3605, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de Santé rural deTrokpadrou', 7.31998, -7.47113, 25),
(3606, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de Santé Urbain de Sipilou', 7.86043, -8.09636, 25),
(3607, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre Hospitalier Régional d\'Abengourou', 6.73085, -3.48375, 25),
(3608, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de santé urbain', 6.5211, -8.29524, 25),
(3609, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Hôpital Général', 8.14394, -5.10511, 25),
(3610, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Polyclinique Groupe Médical du Plateau', 5.32071, -4.01414, 25),
(3611, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre Don Orionne de Bonoua', 5.27637, -3.58603, 25),
(3612, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Hôpital Géneral de Duékoué', 6.74309, -7.34339, 25),
(3613, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'CHR de bondoukou', 8.04075, -2.79315, 25),
(3614, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de Santé Urbain Diaye Bernard', 6.75211, -7.33674, 25),
(3615, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Centre de Santé Urbain Maternité Henriette Konan Bédié', 4.77827, -6.65179, 25),
(3616, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'Polyclinique internationale Divine grâc;Polyclinique internationale Divine grâce', 5.36876, -3.95212, 25),
(3617, 'ci', '2023-02-23 14:57:02', '2023-02-23 14:57:02', 6, '0000000000', 'CSR N\'ZIKRO', 5.39388, -3.39712, 25),
(3618, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'District Sanitaire d\'Aboisso', 5.47472, -3.20654, 25),
(3619, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Chr Dimbokro', 6.65396, -4.69641, 25),
(3620, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Hôpital Henriette Bédié l\'Avocatier', 5.43872, -4.02419, 25),
(3621, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Hôpital général de Taabo', 6.26969, -5.07074, 25),
(3622, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Maternité de Natio Kobadara', 9.48724, -5.60783, 25),
(3623, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Centre de santé urbain NDA', 6.64429, -4.70223, 25),
(3624, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Centre de Santé d\'Akounougbé', 5.18304, -3.17611, 25),
(3625, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Maternité', 7.69434, -5.21195, 25),
(3626, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Hôpital Psychiatrique de Bouaké', 7.67579, -5.04181, 25),
(3627, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'HÔPITAL GÉNÉRAL DE GUEYO', 5.69183, -6.07271, 25),
(3628, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Centre Anti-Tuberculeux de Bouaké', 7.70245, -5.03789, 25),
(3629, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Dispensaire de Tié-N\'Diékro', 7.42423, -4.76541, 25),
(3630, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Maternité de Tié-N\'Diékro', 7.42353, -4.7648, 25),
(3631, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Hôpital Général', 5.32024, -4.37942, 25),
(3632, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Hôpital Général de Tiassalé', 5.89085, -4.82424, 25),
(3633, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Centre Hospitalier Régional de San Pédro', 4.74641, -6.63627, 25),
(3634, 'ci', '2023-02-23 14:57:03', '2023-02-23 14:57:03', 6, '0000000000', 'Cabinet Medical Chinois Le Temple De La Guerrison', 4.77905, -6.65643, 25),
(3635, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Formation de Santé Municipale Déléguée Dominique Ouattara', 4.77152, -6.6631, 25),
(3636, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Institut d\'hygène publique de san pedro', 4.7451, -6.63876, 25),
(3637, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre antituberculeux', 4.74558, -6.63841, 25),
(3638, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Hôpital Général de Sinfra', 6.62302, -5.91521, 25),
(3639, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Hôpital General', 5.7858, -6.60342, 25),
(3640, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre Hospitalier Rural', 6.33392, -4.86037, 25),
(3641, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Hôpital général d\'azopé', 6.10313, -3.86057, 25),
(3642, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Criemosse man', 7.40436, -7.55402, 25),
(3643, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Sainte famille', 7.4108, -7.53581, 25),
(3644, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre de santé urbain grand gbapleu', 7.40908, -7.52981, 25),
(3645, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre Hospitalier Régional de Man', 7.40638, -7.54781, 25),
(3646, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Infirmerie St Jean', 7.42401, -7.55117, 25),
(3647, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Infirmerie Saint Jean', 7.4229, -7.54993, 25),
(3648, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Infirmerie Privée sans Frontière', 7.41705, -7.55117, 25),
(3649, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Infirmerie guyonal', 7.4121, -7.5428, 25),
(3650, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre de santé urbain de Gbêpleu(HKB)', 7.41066, -7.56536, 25),
(3651, 'ci', '2023-02-23 14:57:04', '2023-02-23 14:57:04', 6, '0000000000', 'Centre de Santé Urbain PMI', 7.40979, -7.55209, 25),
(3652, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre médical firdaoss', 7.40521, -7.54598, 25),
(3653, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre médical la providence', 7.40968, -7.53603, 25),
(3654, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Maternité Kennedy 2', 6.88926, -6.47001, 25),
(3655, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de Santé Don Tonino', 6.86182, -6.42994, 25),
(3656, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de santé rural de Derahouan', 6.89871, -6.41052, 25),
(3657, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Maternité Alassane Ouattara', 6.86486, -6.46266, 25),
(3658, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Dispensaire Rural d\'Iguela', 7.72671, -3.22867, 25),
(3659, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'HM-SP', 4.76161, -6.64487, 25),
(3660, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Institut National d\'hygiène publique', 6.87434, -6.45267, 25),
(3661, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de Santé Urbain', 6.8558, -6.44038, 25),
(3662, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de santé anti tuberculeux', 6.88927, -6.452, 25),
(3663, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre Hospitalier Régional', 6.88267, -6.43962, 25),
(3664, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de santé Donata', 4.73772, -6.65582, 25),
(3665, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Protection Maternelle et Infantile', 4.77158, -6.65429, 25),
(3666, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de santé le remontant', 4.77592, -6.66608, 25),
(3667, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', '', 4.76467, -6.66292, 25),
(3668, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Centre de santé', 5.46721, -3.20672, 25),
(3669, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Hôpital général de Marcory', 5.30069, -3.9833, 25),
(3670, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Hôpital municipal de Vridi', 5.26432, -3.98514, 25),
(3671, 'ci', '2023-02-23 14:57:05', '2023-02-23 14:57:05', 6, '0000000000', 'Hôpital Général de Treichville', 5.3111, -4.00799, 25),
(3672, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hôpital général de Koumassi', 5.28748, -3.96947, 25),
(3673, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hôpital général d\'Adjamé', 5.34884, -4.02463, 25),
(3674, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'CHU d\'Angré', 5.4009, -3.95756, 25),
(3675, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Centre de Santé Urbain de Sinématiali', 9.57501, -5.4007, 25),
(3676, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Maternité de Sinématiali', 9.58688, -5.38423, 25),
(3677, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Institut national d’hygiène publique Antenne Yopougon', 5.32575, -4.05702, 25),
(3678, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Centre de santé urbain', 8.21489, -5.12351, 25),
(3679, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Centre de santé urbain de buyo plateau', 6.27629, -6.99593, 25),
(3680, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Centre de Santé', 9.07165, -5.77367, 25),
(3681, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'PMI Bingerville', 5.35617, -3.89107, 25),
(3682, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hôpital Général de Bangolo', 7.01518, -7.48453, 25),
(3683, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hopital de Botro', 7.84846, -5.31151, 25),
(3684, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Dispensaire', 7.55409, -7.53158, 25),
(3685, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Centre de Santé Urbain de Noé', 5.28329, -2.79589, 25),
(3686, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Maternité de Yorobodi', 8.11507, -3.68647, 25),
(3687, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', '', 4.65409, -6.92262, 25),
(3688, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Coordination des Promoteurs de Groupes Poser Zone de Bouaké', 7.72735, -4.99861, 25),
(3689, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Formation Sanitaire Urbaine de Dar Es Salam', 7.71956, -5.03476, 25),
(3690, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hôpital général de Tabou', 4.41694, -7.35666, 25),
(3691, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Hôpital Materno-Infantile Akwaba-Catalunya', 7.73653, -5.0092, 25),
(3692, 'ci', '2023-02-23 14:57:06', '2023-02-23 14:57:06', 6, '0000000000', 'Formation sanitaire municipal de Zimbabwe', 4.76094, -6.66547, 25),
(3693, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Centre Médical Reel Santé', 4.76536, -6.67736, 25),
(3694, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Centre de Santé Urbain Dafci Cathedrale 2', 4.77742, -6.68671, 25),
(3695, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Hopital de la cité exploitation', 5.77433, -6.62746, 25),
(3696, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Centre de Santé', 6.90013, -6.40275, 25),
(3697, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Institut National d\'hygiène publique', 6.87433, -6.45267, 25),
(3698, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Hôpital Islamique de Daloa', 6.85391, -6.44628, 25),
(3699, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'SEMPA(syndicat des entreprises des manutention et de transit des ports Abidjan/San Pedro) médico-social', 4.73687, -6.61991, 25),
(3700, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Infirmerie le levin', 4.77054, -6.68132, 0),
(3701, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Infirmerie Nabo Felix', 4.77758, -6.65513, 30),
(3702, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Dispensaire de noukpoudou', 6.39468, -6.90397, 30),
(3703, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Centre de Santé Sainte Famille', 6.84704, -5.2567, 30),
(3704, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Protection Maternelle et Infantile (PMI) Yamoussoukro', 6.8268, -5.2738, 30),
(3705, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Hopital général de Sassandra', 4.95555, -6.0838, 30),
(3706, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'centre ophtamologique de KAMI', 6.8882, -5.28038, 30),
(3707, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'pharmacie xiliwangha', 6.80095, -5.27301, 30),
(3708, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', '', 5.38054, -3.93658, 30),
(3709, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'CENTRE DE SANTE ARIKOKAHA', 8.78736, -5.19719, 30),
(3710, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Centre Hospitalier d\'Odienné', 9.50259, -7.55994, 30),
(3711, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Clinique Siloé', 5.22018, -3.73645, 30),
(3712, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Maternité Urbaine de Williamsville', 5.36722, -4.02327, 30),
(3713, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Clinique médicale Koko', 5.31144, -3.97348, 30),
(3714, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Clinique Axe optique', 5.2939, -3.95585, 30),
(3715, 'ci', '2023-02-23 14:57:07', '2023-02-23 14:57:07', 6, '0000000000', 'Clinique Liring', 5.29813, -3.97077, 30),
(3716, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique centrale d\'Abobo', 5.41093, -4.00687, 30),
(3717, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Harmonie', 5.30556, -4.01165, 30),
(3718, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique La Mascotte', 5.30704, -4.01387, 30),
(3719, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Médicale Sainte-Philomène', 5.35697, -3.97954, 30),
(3720, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Centre Médical M\'Baphouet', 5.21139, -3.73715, 30),
(3721, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique', 5.3078, -3.9747, 30),
(3722, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Fatima', 5.42038, -4.01508, 30),
(3723, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Centre de Santé Yaou', 5.24096, -3.63293, 30),
(3724, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Kassidy', 5.24444, -3.62951, 30),
(3725, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', '', 5.35969, -3.99593, 30),
(3726, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Dispensaire Rural', 5.4735, -3.8008, 30),
(3727, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Tortues', 5.20795, -3.73254, 30),
(3728, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Cabinet dentaire Faddoul', 5.32507, -4.01942, 30),
(3729, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Esther de Grand-Bassam', 5.21957, -3.74369, 30),
(3730, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique externat saint paul', 5.32587, -4.02142, 30),
(3731, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Polyclinique Saint-Jacques', 5.35642, -4.00106, 30),
(3732, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Dispensaire Medico-Scolaire', 5.19632, -3.73972, 30),
(3733, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Cabinet Médical La Rose', 5.20771, -3.7385, 30),
(3734, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Clinique Médicale la Colombe', 5.38321, -3.98598, 30),
(3735, 'ci', '2023-02-23 14:57:08', '2023-02-23 14:57:08', 6, '0000000000', 'Labo Prothèse Dentaire Coco', 5.32233, -4.05529, 30),
(3736, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Polyclinique de Yopougon', 5.32246, -4.05449, 30),
(3737, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Laboratoire de Prothèse Dentaire', 5.32348, -4.05753, 30),
(3738, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Cabinet Dentaire de la Zone 4', 5.28704, -3.98627, 30),
(3739, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique Médicale Rima', 5.28552, -3.97686, 30),
(3740, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique johanna', 5.30166, -3.97334, 30),
(3741, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Dispensaire de Gnintitoigui 1', 5.31947, -6.5311, 30),
(3742, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', '', 7.44829, -7.39837, 30),
(3743, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique Béatitudes', 5.3488, -3.99582, 30),
(3744, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique la Providence', 5.34731, -4.00957, 30),
(3745, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique Keita', 6.11337, -5.93485, 30),
(3746, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique le Ghery', 6.14235, -5.9524, 30),
(3747, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique médicale Les Oliviers', 5.3331, -4.06207, 30),
(3748, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Cabinet Médical Christal', 6.73948, -7.34523, 30),
(3749, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique Médicale Djama Soutra', 6.73772, -7.351, 30),
(3750, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Association des Volontaire pour la Protection de l\'Enfance', 6.73919, -7.35418, 30),
(3751, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique AIBEF', 6.7368, -7.34338, 30),
(3752, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Clinique Sainte Anne-Marie', 6.74549, -7.34508, 30),
(3753, 'ci', '2023-02-23 14:57:09', '2023-02-23 14:57:09', 6, '0000000000', 'Dispensaire Soeurs Salésiennes', 6.73918, -7.34264, 30),
(3754, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Maternité d’Attecoubé', 5.35301, -4.03474, 30),
(3755, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique médicale Les grâces', 5.43881, -4.04, 30),
(3756, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique Médicale Latrille', 5.35816, -3.99991, 30),
(3757, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique Emmanuel', 6.83848, -5.25533, 30),
(3758, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Poly Clinic Deux Plateaux', 5.36324, -3.99911, 30),
(3759, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Maternité Badéya', 9.46125, -5.6589, 30),
(3760, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'CSR BOZI SATIMACI', 6.88031, -5.58162, 30),
(3761, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique Aibef', 6.81035, -5.26924, 30),
(3762, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique médicale Vie', 5.34682, -4.08869, 30),
(3763, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'La Nouvelle Clinique Remah', 5.36431, -4.00051, 30),
(3764, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique La Rochelle', 5.31869, -4.01337, 30),
(3765, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique Medico-Churigical Le banco', 5.35546, -4.08056, 30),
(3766, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'District sanitaire Aboisso', 5.38303, -3.3902, 30),
(3767, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Maternité', 5.46946, -4.19065, 30),
(3768, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Institut National de l\'Hygiène Publique', 5.24072, -3.89593, 30),
(3769, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Polyclinique Sacré-Cœur', 5.36463, -3.97981, 30),
(3770, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Centre de Santé Chrétien de Bouaké Zone', 7.70369, -5.05664, 30),
(3771, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', '', 5.80415, -6.78504, 30),
(3772, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Polyclinique Danga', 5.34014, -4.00892, 30),
(3773, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Centre de santé rural', 7.59354, -5.16608, 30),
(3774, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Espace réservé au future hôpital internationale de Yamoussoukro', 6.83336, -5.25177, 30),
(3775, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Centre Médical Pasteur', 4.74784, -6.6306, 30),
(3776, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique le rocher', 4.73935, -6.63199, 30),
(3777, 'ci', '2023-02-23 14:57:10', '2023-02-23 14:57:10', 6, '0000000000', 'Clinique Saint Josué', 7.64852, -5.02593, 30),
(3778, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Médico-Chirurgicale Nanan', 7.68246, -5.03829, 30),
(3779, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Maternité de Kotiakoffikro', 7.73454, -5.03039, 30),
(3780, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Polyclinique Sainte Fraternité', 7.69453, -5.02763, 30),
(3781, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Centrale de San-Pédro', 4.74781, -6.62961, 30),
(3782, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Notre Dame de San Pedro', 4.7445, -6.63541, 30),
(3783, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Nouvelle Polyclinique du Centre', 7.7073, -5.0266, 30),
(3784, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'CSU DE GABIADJI', 5.01567, -6.55423, 30),
(3785, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Centrale d\'Abobo Centre', 5.42368, -4.0143, 30),
(3786, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique médicale Sainte Thérèse d’Avila', 5.31973, -4.09425, 30),
(3787, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Maternité d\'Attiekoi', 5.54093, -3.96825, 30),
(3788, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Garage auto', 5.35574, -4.06582, 30),
(3789, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Cabinet Dentaire Ivoire', 7.6832, -5.02827, 30),
(3790, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique HMS Plateau', 5.32051, -4.01285, 30),
(3791, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique La Sentinelle Santé', 7.71297, -5.04349, 30),
(3792, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Service Scolaire et Universitaire Bouaké 3', 7.71339, -5.03112, 30),
(3793, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Cem Chic', 7.71394, -5.02601, 30),
(3794, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Médicale Reine Pokou', 7.68577, -5.04979, 30),
(3795, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Centre Hospitalier Régional', 6.81768, -5.27745, 30),
(3796, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Centre Médical Berthel', 7.72705, -5.04987, 30),
(3797, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Santé pour Tous', 7.72328, -4.99398, 30),
(3798, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Polyclinique Nouvelle de Belleville', 7.71511, -5.00045, 30),
(3799, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Polyclinique Kennedy', 7.68728, -5.01109, 30),
(3800, 'ci', '2023-02-23 14:57:11', '2023-02-23 14:57:11', 6, '0000000000', 'Clinique Médoco-Chirurgicale Saint-Martin', 7.68726, -5.01189, 30),
(3801, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre Jean-Baptiste Vatelot', 7.72341, -5.06465, 30),
(3802, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Service de Santé Scolaire et Universitaire II Nimbo', 7.68062, -5.0246, 30),
(3803, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre de Santé Universitaire Campus 2', 7.67938, -5.07807, 30),
(3804, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Clinique Médicale Sainte Madeleine', 7.6815, -5.02599, 30),
(3805, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Clinique Médicale Étoile du Commerce', 7.68076, -5.03328, 30),
(3806, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Clinique Médicale Bouaké', 7.68241, -5.02346, 30),
(3807, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Aosi Action', 7.67819, -5.01711, 30),
(3808, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre De Santé Communautaire', 7.68117, -5.01856, 30),
(3809, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Institut National d\'Hygiène Publique', 7.6829, -5.03522, 30),
(3810, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Hôpital Saint-Camille', 7.70111, -5.03839, 30),
(3811, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre de Santé Universitaire Campus 1', 7.68582, -5.0676, 30),
(3812, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre de Santé Universitaire Campus 1', 7.68536, -5.06781, 30),
(3813, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'CEMENA', 7.68253, -5.03887, 30),
(3814, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'infirmerie Medical', 4.74964, -6.6277, 30),
(3815, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Clinique la rosette', 4.74586, -6.63933, 30),
(3816, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Prothèse dentaire', 4.76883, -6.66767, 30),
(3817, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre Médical Chinois', 4.77094, -6.64655, 30),
(3818, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Centre de Santé Les Archanges', 4.77089, -6.64653, 30),
(3819, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Clinique', 4.76754, -6.66834, 30),
(3820, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', '', 4.75443, -6.64222, 30),
(3821, 'ci', '2023-02-23 14:57:12', '2023-02-23 14:57:12', 6, '0000000000', 'Infirmerie Saint Chekinael', 4.78163, -6.64784, 30),
(3822, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Chinoise', 4.78149, -6.64745, 30),
(3823, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Seweke 2', 4.77217, -6.64639, 30),
(3824, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Association Ivoirienne pour le Bien Être Familial', 4.7724, -6.64835, 30),
(3825, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Centre Medicale Pierre et Marie Curie', 4.77946, -6.65048, 30),
(3826, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique médicale chirurgicale l\'Emmanuel', 4.77826, -6.65223, 30),
(3827, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique dentaire ROSYL', 4.74253, -6.63244, 30),
(3828, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Centre Medical d\'orphtamologie Iris Chez Dr. Assa', 4.74463, -6.63604, 30),
(3829, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique orientale Novabio', 4.76613, -6.67493, 30),
(3830, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Centre de Soins Pour Ulcers De Buruli', 4.73771, -6.65509, 30),
(3831, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', '', 4.76795, -6.66709, 30),
(3832, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Maya', 4.75462, -6.69402, 30),
(3833, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Mayan Kassy', 5.78146, -6.60757, 30),
(3834, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Centre de secours Yvette de Soubré', 5.77821, -6.59437, 30),
(3835, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Chinoise', 5.78455, -6.59645, 30),
(3836, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique', 5.79166, -6.59581, 30),
(3837, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Infirmerie Privée d\'Abattoir', 5.78342, -6.57815, 30),
(3838, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique Paramédicale', 5.78036, -6.58172, 30),
(3839, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Institut Medicale IAMC Santé', 5.78505, -6.59137, 30),
(3840, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique chinoise', 5.78464, -6.59219, 30),
(3841, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique privée', 5.7768, -6.58718, 30),
(3842, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Clinique les Oliviers', 5.78326, -6.58805, 30),
(3843, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Labo de prothèse dentaire', 5.78433, -6.59521, 30),
(3844, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Centre paramedical la paix', 5.79221, -6.58459, 30),
(3845, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'Infirmerie Privée', 5.78436, -6.5866, 30),
(3846, 'ci', '2023-02-23 14:57:13', '2023-02-23 14:57:13', 6, '0000000000', 'centre de soins chinois', 5.78776, -6.60089, 30),
(3847, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique PARA_Medical le prix du pardon', 5.7994, -6.58664, 30),
(3848, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Mory', 5.79794, -6.592, 30),
(3849, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Infirmerie', 5.79294, -6.6016, 30),
(3850, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Chinoise', 5.78073, -6.59194, 30),
(3851, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Infirmerie', 5.42091, -4.46901, 30),
(3852, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Nouvelle Espérance', 5.3458, -3.95647, 30),
(3853, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Médicale St Jean Baptiste', 5.35144, -4.06, 30),
(3854, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Médicale Spécialisée', 5.36323, -4.00097, 30),
(3855, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Laboratoire Moderne Prothèse Dentaire', 5.34122, -4.06794, 30),
(3856, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique le rocher', 5.37096, -4.00116, 30),
(3857, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Du Lavage', 5.34085, -4.07234, 30),
(3858, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Médicale Les Orchidées', 5.33832, -4.08392, 30),
(3859, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Chinoise', 5.34653, -4.06745, 30),
(3860, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique AIBEF', 5.34277, -4.08008, 30),
(3861, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Cabinet Dentaire', 5.34221, -4.07401, 30),
(3862, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Cabinet Dentaire', 5.33976, -4.0737, 30),
(3863, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique Gnanmiensa', 5.38064, -4.09826, 30),
(3864, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Clinique espace médical micao', 5.3819, -4.0957, 30),
(3865, 'ci', '2023-02-23 14:57:14', '2023-02-23 14:57:14', 6, '0000000000', 'Laboratoire de Prothèse Dentaire', 5.3423, -4.07587, 30),
(3866, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique médicale Queen Latifat', 5.33644, -4.09816, 30),
(3867, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique Medicale Jean et Marie', 5.33754, -4.06581, 30),
(3868, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinque le chandelier', 5.3478, -4.09956, 30),
(3869, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique saint sauveur', 5.34977, -4.10023, 30),
(3870, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique Chinoise', 5.3353, -4.10142, 30),
(3871, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique', 5.3667, -4.09491, 30),
(3872, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Laboratoire Dentaire', 5.35344, -4.07177, 30),
(3873, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Cabinet Dentaire', 5.32973, -4.05008, 30),
(3874, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Clinique Chinoise', 5.33162, -4.0558, 30),
(3875, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Hopital Toit Rouge', 5.33134, -4.05621, 30),
(3876, 'ci', '2023-02-23 14:57:15', '2023-02-23 14:57:15', 6, '0000000000', 'Hôpital AFO Sud', 5.34717, -4.09307, 30),
(3877, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Médico Chirugicale Saint Raphael', 5.3438, -4.09958, 30),
(3878, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Médicale Mont Carmel', 5.35506, -4.09844, 30),
(3879, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Médicale le Bélier', 5.35514, -4.09892, 30),
(3880, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique medicale', 5.34916, -4.09373, 30),
(3881, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique medicale houphouet', 5.35047, -4.09505, 30),
(3882, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Ste Jane-Leora', 5.35102, -4.09733, 30),
(3883, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique medicale Mont Carmel', 5.35506, -4.09844, 30),
(3884, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Ste jane-leora', 5.351, -4.09727, 30),
(3885, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique le belier', 5.35514, -4.09892, 30),
(3886, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique GOSPA', 5.3429, -4.00461, 30),
(3887, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Cabinet dentaire', 5.33905, -4.00387, 30),
(3888, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Cabinet Dentaire', 5.43746, -4.05566, 30),
(3889, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique ONG Santé Côte d\'Ivoire', 5.44293, -4.05352, 30),
(3890, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique', 5.42906, -4.0329, 30),
(3891, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Privée Bouakally', 5.29073, -3.96014, 30),
(3892, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Privé Saint Ornella', 5.44373, -4.08057, 30),
(3893, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique spirituel JHSG', 5.42653, -4.02271, 30);
INSERT INTO `cliniques` (`id`, `localisation`, `created_at`, `updated_at`, `user_id`, `telephone`, `name`, `lon`, `lat`, `commune_id`) VALUES
(3894, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Privée Saint Horeb', 5.44284, -4.04781, 30),
(3895, 'ci', '2023-02-23 14:57:16', '2023-02-23 14:57:16', 6, '0000000000', 'Clinique Sainte Nancy 21263368', 5.3085, -3.99493, 30),
(3896, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique Saint Pierre Legrand', 5.36368, -3.97541, 30),
(3897, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre de santé scolaire et universitaire', 6.10364, -3.8615, 30),
(3898, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Cabinet dentaire Ave Maria', 5.36813, -3.96314, 30),
(3899, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique de l\'amitié Mère Thérèse', 5.31826, -4.1095, 30),
(3900, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre de Soins Otcho de Songon', 5.3246, -4.25593, 30),
(3901, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Dispensaire de GNIPPI 2', 5.67146, -6.6442, 30),
(3902, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre anti-tuberculeux', 7.39562, -7.55057, 30),
(3903, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre de santé scolaire et universitaire de Man', 7.39518, -7.55067, 30),
(3904, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre Medico-social focolari', 7.3967, -7.56744, 30),
(3905, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Amour du prochain', 7.39136, -7.53981, 30),
(3906, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique Bichat', 7.41462, -7.54612, 30),
(3907, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Cabinet dentaire', 7.40709, -7.55437, 30),
(3908, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique ledical saint david', 6.72827, -3.50819, 30),
(3909, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Centre de santé communautaire de Tankesse', 7.36511, -3.20339, 30),
(3910, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Cabinet Dentaire', 6.8816, -6.45635, 30),
(3911, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique Afro-asiatique', 6.89122, -6.42635, 30),
(3912, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Laboratoire Dentaire Fadkady', 6.86762, -6.45118, 30),
(3913, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique Huberson', 6.876, -6.46018, 30),
(3914, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'MaximumtBl Group', 6.90149, -6.44577, 30),
(3915, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique Tosseta', 6.8605, -6.43572, 30),
(3916, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Climique Social Santé Pour Tous', 6.86965, -6.44494, 30),
(3917, 'ci', '2023-02-23 14:57:17', '2023-02-23 14:57:17', 6, '0000000000', 'Clinique médicale Kehassemon', 6.87671, -6.47747, 30),
(3918, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Infirmerie Privée Kaoka', 6.86828, -6.45609, 30),
(3919, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Infirmerie Privée', 6.88809, -6.46293, 30),
(3920, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Infirmerie Etablissement Ali Coulibaly', 6.85432, -6.44095, 30),
(3921, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique médicale oasis santé', 5.34775, -4.07308, 30),
(3922, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Cabinet Dentaire TOURE', 6.88546, -6.44703, 30),
(3923, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Sainte Famille', 6.88252, -6.45689, 30),
(3924, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique médicale Grâce Divine', 6.87985, -6.45746, 30),
(3925, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Cabinet Dentaire du Grand Marché', 6.88158, -6.45615, 30),
(3926, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique El Rapha', 6.85733, -6.43764, 30),
(3927, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Médicale Solidarité', 6.8947, -6.45067, 30),
(3928, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Antilope', 6.89624, -6.43793, 30),
(3929, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Médicale Espoir', 6.90097, -6.44202, 30),
(3930, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Sainte Vie', 6.9097, -6.45142, 30),
(3931, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'clinique de tonton BERTIN', 4.78117, -6.65668, 30),
(3932, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Cabinet dentaire gendarmerie', 4.76204, -6.64466, 30),
(3933, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Afrique Noire', 4.76567, -6.6669, 30),
(3934, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Espace Médical Santé', 4.74414, -6.63229, 30),
(3935, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique la Grâce', 4.75985, -6.69183, 30),
(3936, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Infirmerie privée du bien-être', 4.78287, -6.66579, 30),
(3937, 'ci', '2023-02-23 14:57:18', '2023-02-23 14:57:18', 6, '0000000000', 'Clinique Sainte Jane-Leora', 5.35098, -4.09715, 30),
(3938, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique Paul Marie', 5.46052, -4.07246, 30),
(3939, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique médicale Saint Viateur', 5.35896, -3.95299, 30),
(3940, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique médicale d’Angré', 5.40403, -3.98643, 30),
(3941, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique médicale Saint Viateur', 5.35892, -3.95286, 30),
(3942, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'centre de santé d\'apkessekro', 6.7323, -5.30526, 30),
(3943, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Maternité Privée Touré', 7.71414, -4.99276, 30),
(3944, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Institut National d\'Hygiène Publique', 5.44192, -4.04413, 30),
(3945, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Institut National d’Hygiène Publique de Treichville', 5.29433, -4.0051, 30),
(3946, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique médicale Les oliviers', 5.35186, -4.06172, 30),
(3947, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Saint sauveur', 5.32713, -4.09657, 30),
(3948, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique médicale Le jourdain', 5.24179, -3.89955, 30),
(3949, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Ong Ivoire Santé', 5.43253, -4.06648, 30),
(3950, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Centre de santé de kouetinfla', 6.61816, -6.04623, 30),
(3951, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Centre de santé', 6.6517, -5.80829, 30),
(3952, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Centre de santé rural', 6.48883, -6.39071, 30),
(3953, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Clinique les Myriades', 5.31074, -3.99099, 30),
(3954, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Hôpital Général de Mankono', 8.06707, -6.19095, 30),
(3955, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Hôpital général de Tiebissou', 7.1598, -5.22331, 30),
(3956, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', '', 8.02296, -6.17889, 30),
(3957, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Lokaha 2', 9.56384, -5.3723, 30),
(3958, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Centre Médical Sainte Famille de Grand-Bassam', 5.2151, -3.7645, 30),
(3959, 'ci', '2023-02-23 14:57:19', '2023-02-23 14:57:19', 6, '0000000000', 'Centre médical Afrique futur', 5.47032, -4.03486, 30),
(3960, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de traitement des maladies infectieuses', 5.50166, -4.04629, 30),
(3961, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Hôpital Général de Grand-Lahou', 5.25776, -5.00493, 30),
(3962, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Clinique Saint-Jean de Dieu', 5.2627, -4.99767, 30),
(3963, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre Médical Kine Fatima', 5.21963, -3.72841, 30),
(3964, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 5.68627, -4.51505, 30),
(3965, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Hopital de toumodi', 6.55348, -5.01808, 30),
(3966, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'baaba', 5.37083, -4.00008, 30),
(3967, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de Santé Rural d\'Eticoon', 5.92722, -4.9641, 30),
(3968, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 5.57529, -5.25314, 30),
(3969, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Hôpital général de Guitry', 5.52346, -5.24167, 30),
(3970, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de santé de Kouta', 5.48612, -5.23052, 30),
(3971, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 6.0485, -6.10312, 30),
(3972, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de Santé NDA', 5.83721, -5.34987, 30),
(3973, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 6.11693, -6.53446, 30),
(3974, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de Santé Rural de Gnippi 2', 5.67349, -6.64465, 30),
(3975, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Dispensaire Rural de Gnakaradigui', 5.72062, -6.6307, 30),
(3976, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 5.90006, -5.16072, 30),
(3977, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de Santé Urbain d\'Iboguhé', 6.55127, -6.84813, 30),
(3978, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', 'Centre de sante', 6.49467, -6.63337, 30),
(3979, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 7.11562, -7.55375, 30),
(3980, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 7.52925, -7.62938, 30),
(3981, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 7.18351, -7.57437, 30),
(3982, 'ci', '2023-02-23 14:57:20', '2023-02-23 14:57:20', 6, '0000000000', '', 7.95203, -7.67635, 30),
(3983, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de santé urbain de Kaniasso', 9.81529, -7.51195, 30),
(3984, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Régional de Banankoro', 9.81526, -7.38668, 30),
(3985, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Urbain de Kaniasso', 9.81578, -7.51179, 30),
(3986, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', '', 9.53543, -6.48967, 30),
(3987, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Rural', 9.54819, -5.49214, 30),
(3988, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', '', 9.56423, -5.52497, 30),
(3989, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', '', 9.58185, -5.50368, 30),
(3990, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', '', 8.06394, -5.25233, 30),
(3991, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Hôpital de Gbon', 9.83177, -6.45043, 30),
(3992, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Yadibikro', 7.10902, -5.34875, 30),
(3993, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Urbain de Molonou', 7.15786, -5.36615, 30),
(3994, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'MÉDICO-SCOLAIRE', 7.26879, -8.14831, 30),
(3995, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', '', 6.64029, -5.65566, 30),
(3996, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Dispensaire Rural de Zangue', 6.43027, -5.35812, 30),
(3997, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Rural de Kayeta', 6.6399, -5.65574, 30),
(3998, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Urbain de Kononfla', 6.65021, -5.60959, 30),
(3999, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Urbain de Assié-Koumassi', 6.77001, -4.29223, 30),
(4000, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Rural Assoum I', 9.23049, -3.0639, 30),
(4001, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Dispensaire Rural de Kaflandé', 9.10034, -3.15236, 30),
(4002, 'ci', '2023-02-23 14:57:21', '2023-02-23 14:57:21', 6, '0000000000', 'Centre de Santé Rural de Varale', 9.65636, -3.27992, 30),
(4003, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', '', 8.4917, -3.12489, 30),
(4004, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Dispensaire Rural de Bogofa', 8.61414, -3.1599, 30),
(4005, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Dispensaire Rural de Sanguinari', 8.82812, -3.17897, 30),
(4006, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Dispensaire Rural de Tefrodouo', 8.55938, -3.12156, 30),
(4007, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', '', 9.41675, -3.10566, 30),
(4008, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', '', 8.39893, -3.09859, 30),
(4009, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Hôpital Général d\'Agnibilekro', 7.12744, -3.19931, 30),
(4010, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de Santé Urbain d\'Amelekia', 6.82516, -3.56963, 30),
(4011, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de Santé Rural Boukro', 7.66632, -3.21617, 30),
(4012, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de Santé de Diemba', 7.20081, -3.10539, 30),
(4013, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Hôpital général de Doropo', 9.80925, -3.3374, 30),
(4014, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de Santé Urbain de Lolobo', 6.95429, -5.26743, 30),
(4015, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Ong Eveil', 8.04395, -2.80005, 30),
(4016, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de santé rural de Kouta', 5.48629, -5.23059, 30),
(4017, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'INHP TREICHVILLE', 5.30641, -4.00259, 30),
(4018, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Hôpital Régional de Divo', 5.84259, -5.35559, 30),
(4019, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', '', 7.18658, -5.28655, 30),
(4020, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', '', 9.89724, -6.50168, 30),
(4021, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Clinique Notre Dame de Lourdes', 5.33549, -4.08888, 30),
(4022, 'ci', '2023-02-23 14:57:22', '2023-02-23 14:57:22', 6, '0000000000', 'Centre de Santé Rural', 8.33147, -3.06677, 30),
(4023, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de Santé', 6.02021, -6.38909, 30),
(4024, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de Santé Urbain de Songon', 5.31877, -4.20241, 30),
(4025, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Dispensaire Rural', 8.94719, -3.18239, 30),
(4026, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Cabinet Médical Succar', 5.32391, -4.01597, 30),
(4027, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de Santé de Guepahouo', 6.47876, -5.70628, 30),
(4028, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Hôpital de Vavoua', 7.38918, -6.47968, 30),
(4029, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Dispensaire', 5.29562, -3.38223, 30),
(4030, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Polyclinique La Sisangue', 9.45544, -5.63143, 30),
(4031, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'PMI MAN', 7.41059, -7.55249, 30),
(4032, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Clinique Sainte Justine', 5.39778, -3.96907, 30),
(4033, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Clinique Chinoise', 6.56093, -5.01849, 30),
(4034, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de Santé Palazzolo', 7.13794, -3.19816, 30),
(4035, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'CHR de Guiglo', 6.54414, -7.48224, 30),
(4036, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre Médical Riviera AmbassadeCMRA', 5.33795, -3.98143, 30),
(4037, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de santé', 6.64443, -4.18406, 30),
(4038, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Hôpital Saint Jean-Baptiste de Bôdô', 5.89778, -4.69328, 30),
(4039, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Centre de Santé Rural de Moutcho', 5.95452, -4.18802, 30),
(4040, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Cabinet Dentaire Azur', 5.34571, -3.99751, 30),
(4041, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Clinique St Gabrielle', 5.38761, -3.99258, 30),
(4042, 'ci', '2023-02-23 14:57:23', '2023-02-23 14:57:23', 6, '0000000000', 'Cabinet Dentaire', 5.39782, -3.99133, 30),
(4043, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Espace Bio médical Robinson International', 5.40402, -3.99044, 30),
(4044, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Centre De Soins Kennedy', 5.42017, -4.0085, 30),
(4045, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique Médicale Sacré Coeur', 5.37878, -3.98847, 30),
(4046, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Cabinet De Santé Phytothérapie', 5.4001, -3.99108, 30),
(4047, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique Médicale', 5.41856, -4.009, 30),
(4048, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Cabinet Dentaire', 5.39788, -3.99133, 30),
(4049, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Petit Hôpital', 5.43229, -4.0253, 30),
(4050, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique Médical Sika Abobo', 5.43851, -4.01605, 30),
(4051, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Centre Communautaire De Kennedy-Clouetcha', 5.42353, -4.00047, 30),
(4052, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Centre De Thermothérapie', 5.37199, -3.97085, 30),
(4053, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Antenne d\'Hygiène Publique d\'Abobo', 5.42234, -3.98987, 30),
(4054, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Centre de Santé', 5.40577, -4.00107, 30),
(4055, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Bio Pharma', 5.4137, -4.00318, 30),
(4056, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique Medicale Wimin de Bidjante', 5.34457, -4.03135, 30),
(4057, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Infirmerie Privés Le Temps', 5.34064, -4.02862, 30),
(4058, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Infirmerie', 5.34017, -4.02741, 30),
(4059, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique Chinoise', 5.3423, -4.02896, 30),
(4060, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Nouvelle Clinique d\'Adjame', 5.34085, -4.02753, 30),
(4061, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Cabinet dentaire Sainte Rita de Cascia', 5.34061, -4.08735, 30),
(4062, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique la Grâce des Lacs', 6.81572, -5.2665, 30),
(4063, 'ci', '2023-02-23 14:57:24', '2023-02-23 14:57:24', 6, '0000000000', 'Clinique C2H', 5.35818, -3.9265, 30),
(4064, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Complexe sanitaire Henriette Konan Bédié de Blockhaus', 5.32421, -4.00151, 30),
(4065, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Centre Médical Spécialisé Soumeya', 5.40827, -3.98799, 30),
(4066, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Cabinet Dentaire', 5.33626, -4.00253, 30),
(4067, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'cabinet dentaire', 5.38365, -3.97354, 30),
(4068, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Cabinet dentaire 9ème tranches', 5.37176, -3.93089, 30),
(4069, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Centre médico chirurgical d\'abobo', 5.43992, -4.0227, 30),
(4070, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Centre de santé urbain à base communautaire abobo BC', 5.4448, -4.01731, 30),
(4071, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Nouvelle Clinique Marie Eliana', 5.35235, -3.97508, 30),
(4072, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Clinique médicale janick', 5.37154, -3.96443, 30),
(4073, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Cabinet dentaire Lorika', 5.36332, -3.95944, 30),
(4074, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Cabinet dentaire MEFKA sarl', 5.37312, -3.92833, 30),
(4075, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Groupe médical de l\'amitié', 5.34789, -3.9549, 30),
(4076, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Hôpital général de Tiapoum', 5.13516, -3.02421, 30),
(4077, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Clinique Médicale Source de Vie', 5.47161, -3.20479, 30),
(4078, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Clinique Américaine d\'Abidjan Sarl', 5.38385, -3.97838, 30),
(4079, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'District Sanitaire de Tiapoum', 5.13532, -3.02437, 30),
(4080, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Centre de Sante n\'badon', 5.33147, -3.93583, 30),
(4081, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Centre de Santé des douanes', 5.33117, -4.00939, 30),
(4082, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Clinique Saint georges', 5.38481, -3.98496, 30),
(4083, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Labo dentaire', 5.42712, -4.01922, 30),
(4084, 'ci', '2023-02-23 14:57:25', '2023-02-23 14:57:25', 6, '0000000000', 'Hôpital Général Sakassou', 7.44617, -5.29094, 30),
(4085, 'ci', '2023-02-23 14:57:26', '2023-02-23 14:57:26', 6, '0000000000', 'District Sanitaire de Sakassou', 7.44333, -5.28911, 30),
(4086, 'Akeikoi près du petit marché', '2023-03-20 11:44:02', '2023-03-20 11:44:02', 17, '000000000', 'Longue vie', 0, 0, 1);

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

--
-- Structure de la table `clinique_patient`
--

CREATE TABLE IF NOT EXISTS `clinique_patient` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `patient_id` bigint UNSIGNED NOT NULL,
  `clinique_id` bigint UNSIGNED NOT NULL,
  `statut` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disponibilite_id` bigint UNSIGNED NOT NULL,
  `analyse_clinique_id` bigint UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `heure` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `clinique_patient_patient_id_foreign` (`patient_id`),
  KEY `clinique_patient_clinique_id_foreign` (`clinique_id`),
  KEY `clinique_patient_disponibilite_id_foreign` (`disponibilite_id`),
  KEY `clinique_patient_analyse_clinique_id_foreign` (`analyse_clinique_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `clinique_patient` (`id`, `patient_id`, `clinique_id`, `statut`, `disponibilite_id`, `analyse_clinique_id`, `date`, `heure`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'A venir', 7, 1, '2023-03-19', '22:03:59', '2023-03-19 22:35:59', '2023-03-19 22:35:59'),
(2, 1, 1, 'A venir', 1, 14, '2023-03-19', '22:03:20', '2023-03-19 22:50:20', '2023-03-19 22:50:20'),
(3, 1, 1, 'A venir', 2, 1, '2023-03-20', '16:03:27', '2023-03-20 16:55:27', '2023-03-20 16:55:27'),
(4, 1, 1, 'A venir', 7, 14, '2023-03-20', '16:03:16', '2023-03-20 16:58:16', '2023-03-20 16:58:16');

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

--
-- Structure de la table `communes`
--

CREATE TABLE IF NOT EXISTS `communes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `communes` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(1, 'Abobo', '2023-03-07 21:45:54', '2023-03-07 21:45:54'),
(2, 'Adjamé', '2023-03-07 21:45:54', '2023-03-07 21:45:54'),
(3, 'Attecoubé', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(4, 'Cocody', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(5, 'Koumassi', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(6, 'Marcory', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(7, 'Plateau', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(8, 'Port-Bouët', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(9, 'Treichville', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(10, 'Yopougon', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(11, 'Anyama', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(12, 'Bingerville', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(13, 'Songon', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(14, 'Alépé', '2023-03-07 21:45:55', '2023-03-07 21:45:55'),
(15, 'Oghwyapo', '2023-03-07 21:45:56', '2023-03-07 21:45:56'),
(16, 'Dabou', '2023-03-07 21:45:56', '2023-03-07 21:45:56'),
(17, 'Sikensi', '2023-03-07 21:45:56', '2023-03-07 21:45:56'),
(18, 'Grand-Lahou', '2023-03-07 21:45:56', '2023-03-07 21:45:56'),
(19, 'Jacqueville', '2023-03-07 21:45:56', '2023-03-07 21:45:56'),
(20, 'Tiassalé', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(21, 'Taabo', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(22, 'Dikodougou', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(23, 'Guiembé', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(24, 'Karakoro', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(25, 'Korhogo', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(26, 'Komborodougou', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(27, 'M\'bengué', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(28, 'Napiélédougou', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(29, 'Niofoin', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(30, 'Tioroniaradougou', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(31, 'Sinematiali', '2023-03-07 21:45:57', '2023-03-07 21:45:57'),
(32, 'Sirasso', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(33, 'Gbon', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(34, 'Boundiali', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(35, 'Kasséré', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(36, 'Kolia', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(37, 'Kouto', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(38, 'Diawala', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(39, 'Ferkessedougou', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(40, 'Kong', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(41, 'Koumbala', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(42, 'Niellé', '2023-03-07 21:45:58', '2023-03-07 21:45:58'),
(43, 'Ouangolodougou', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(44, 'Kanakono', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(45, 'Tengréla', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(46, 'Aboisso', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(47, 'Ayamé', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(48, 'Bianouan', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(49, 'Maféré', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(50, 'Tiapoum', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(51, 'Adiaké', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(52, 'Assinie-mafia', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(53, 'Etuéboué', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(54, 'Grand-Bassam', '2023-03-07 21:45:59', '2023-03-07 21:45:59'),
(55, 'Bonoua', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(56, 'Bediala', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(57, 'Daloa', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(58, 'Gadouan', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(59, 'Gboguhé', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(60, 'Zaïbo', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(61, 'Zoukougbeu', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(62, 'Boguedia', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(63, 'Iboguhe', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(64, 'Issia', '2023-03-07 21:46:00', '2023-03-07 21:46:00'),
(65, 'Saïoua', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(66, 'Dania', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(67, 'Seitifla', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(68, 'Vavoua', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(69, 'Agboville', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(70, 'Azaguié', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(71, 'Cechi', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(72, 'Grand morie', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(73, 'Oress-krobou', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(74, 'Rubino', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(75, 'Adzopé', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(76, 'Agou', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(77, 'Afféry', '2023-03-07 21:46:01', '2023-03-07 21:46:01'),
(78, 'Becedi-brignan', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(79, 'Akoupé', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(80, 'Assikoi', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(81, 'Yakassé-Attobrou', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(82, 'Abengourou', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(83, 'Bettié', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(84, 'Niablé', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(85, 'Agnibilékrou', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(86, 'Diabo', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(87, 'Djebonoua', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(88, 'Brobo', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(89, 'Botro', '2023-03-07 21:46:02', '2023-03-07 21:46:02'),
(90, 'Bouaké', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(91, 'Languibonou', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(92, 'Beoumi', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(93, 'Bodokro', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(94, 'Ando-kekrenou', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(95, 'Kondrobo', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(96, 'Bassawa', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(97, 'Bonieredougou', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(98, 'Dabakala', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(99, 'Foumbolo', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(100, 'Satama-Sokoro', '2023-03-07 21:46:03', '2023-03-07 21:46:03'),
(101, 'Satama-Sokouro', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(102, 'Fronan', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(103, 'Katiola', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(104, 'Niakaramandougou', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(105, 'Tafiré', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(106, 'Tortiya', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(107, 'Timbe', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(108, 'Sakassou', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(109, 'Tomoudi-sakassou', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(110, 'Man', '2023-03-07 21:46:04', '2023-03-07 21:46:04'),
(111, 'Facobly', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(112, 'Kouibly', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(113, 'Logoualé', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(114, 'Sangouiné', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(115, 'Semien', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(116, 'Niadrou', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(117, 'Totrodrou', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(118, 'Bangolo', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(119, 'Dieouzon', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(120, 'Zeo', '2023-03-07 21:46:05', '2023-03-07 21:46:05'),
(121, 'Zou', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(122, 'Biankouma', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(123, 'Gbonné', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(124, 'Sipilou', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(125, 'Danané', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(126, 'Bin-Houyé', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(127, 'Zouan-Hounien', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(128, 'Mahapleu', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(129, 'Divo', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(130, 'Fresco', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(131, 'Guitry', '2023-03-07 21:46:06', '2023-03-07 21:46:06'),
(132, 'Hiré', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(133, 'YOCOBOUE', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(134, 'Lakota', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(135, 'NIAMBEZARIA', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(136, 'Zikisso', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(137, 'Bayota', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(138, 'Gagnoa', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(139, 'Gnagbodougnoa', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(140, 'Guibéroua', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(141, 'Ouragahio', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(142, 'Diégonéfla', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(143, 'Oumé', '2023-03-07 21:46:07', '2023-03-07 21:46:07'),
(144, 'Yamoussoukro', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(145, 'Didiévi', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(146, 'Attiegouakro', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(147, 'Tiébissou', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(148, 'Tié-N’diekro', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(149, 'Toumodi', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(150, 'Djékanou', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(151, 'Angoda', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(152, 'Kpouebo', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(153, 'Kokoumbo', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(154, 'Duékoué', '2023-03-07 21:46:08', '2023-03-07 21:46:08'),
(155, 'BAGOHOUO', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(156, 'GBAPLEU', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(157, 'GUEHIEBLY', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(158, 'GUEZON', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(159, 'Bloléquin', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(160, 'Guiglo', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(161, 'Taï', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(162, 'Toulepleu', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(163, 'BAKOUBLY', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(164, 'PEHE', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(165, 'TIOBLY', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(166, 'Bondoukou', '2023-03-07 21:46:09', '2023-03-07 21:46:09'),
(167, 'Goumere', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(168, 'Tabagne', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(169, 'Taoudi', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(170, 'Sorobango', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(171, 'Sapli', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(172, 'Sandégué', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(173, 'Bouna', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(174, 'Doropo', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(175, 'Nassian', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(176, 'Tehini', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(177, 'Tanda', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(178, 'Assuefry', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(179, 'Kouassi-datekro', '2023-03-07 21:46:10', '2023-03-07 21:46:10'),
(180, 'Transua', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(181, 'Tankesse', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(182, 'Booko', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(183, 'Borotou', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(184, 'Guintéguéla', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(185, 'Koonan', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(186, 'Koro', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(187, 'Ouaninou', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(188, 'Touba', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(189, 'FOUNGBESSO', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(190, 'Grand-Béréby', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(191, 'San-Pédro', '2023-03-07 21:46:11', '2023-03-07 21:46:11'),
(192, 'GUEYO', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(193, 'Sassandra', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(194, 'SAGO', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(195, 'Buyo', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(196, 'Grand-Zattry', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(197, 'Méagui', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(198, 'OKROUYO', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(199, 'Soubré', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(200, 'Grabo', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(201, 'Tabou', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(202, 'Dimbokro', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(203, 'Anoumaba', '2023-03-07 21:46:12', '2023-03-07 21:46:12'),
(204, 'Arrah', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(205, 'Bongouanou', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(206, 'M\'batto', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(207, 'Tiemelékro', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(208, 'Bocanda', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(209, 'Daoukro', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(210, 'Ettrokro', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(211, 'Kouassi-Kouassikro', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(212, 'Ouellé', '2023-03-07 21:46:13', '2023-03-07 21:46:13'),
(213, 'M\'bahiakro', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(214, 'Banguera', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(215, 'Koffi-amonkro', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(216, 'Prikro', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(217, 'Bonon', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(218, 'Bouaflé', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(219, 'Sinfra', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(220, 'Kouetinfla', '2023-03-07 21:46:14', '2023-03-07 21:46:14'),
(221, 'Bazre', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(222, 'Konefla', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(223, 'Gohitafla', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(224, 'Zuénoula', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(225, 'Dianra', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(226, 'Kongasso', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(227, 'Kounahiri', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(228, 'Mankono', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(229, 'Marandallah', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(230, 'Sarhala', '2023-03-07 21:46:15', '2023-03-07 21:46:15'),
(231, 'Tieningboue', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(232, 'Djibrosso', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(233, 'Dualla', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(234, 'Kani', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(235, 'Massala', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(236, 'Morondo', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(237, 'Seguela', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(238, 'Sifié', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(239, 'Worofla', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(240, 'Bako', '2023-03-07 21:46:16', '2023-03-07 21:46:16'),
(241, 'Dioulatiédougou', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(242, 'Gbeleban', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(243, 'Goulia', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(244, 'Kaniasso', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(245, 'Madinani', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(246, 'Minignan', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(247, 'Odienné', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(248, 'Samatiguila', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(249, 'Séguélon', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(250, 'Seydougou', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(251, 'Tiémé', '2023-03-07 21:46:17', '2023-03-07 21:46:17'),
(252, 'Tienko', '2023-03-07 21:46:17', '2023-03-07 21:46:17');

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

--
-- Structure de la table `disponibilites`
--

CREATE TABLE IF NOT EXISTS `disponibilites` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `jour` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  `starttime` time NOT NULL,
  `endtime` time NOT NULL,
  `clinique_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `disponibilites_clinique_id_foreign` (`clinique_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `disponibilites` (`id`, `jour`, `starttime`, `endtime`, `clinique_id`, `created_at`, `updated_at`) VALUES
(1, 'Lundi', '07:20:00', '12:00:00', 1, '2023-03-08 09:54:14', '2023-03-08 09:54:14'),
(2, 'Mardi', '07:00:00', '12:00:00', 1, '2023-03-08 09:55:04', '2023-03-08 09:55:04'),
(3, 'Mercredi', '07:00:00', '12:00:00', 1, '2023-03-08 09:55:25', '2023-03-08 09:55:25'),
(7, 'Samedi', '07:00:00', '17:00:00', 1, '2023-03-15 18:30:44', '2023-03-15 18:30:44'),
(8, 'Dimanche', '07:30:00', '17:00:00', 1, '2023-03-20 17:03:03', '2023-03-20 17:03:03');

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

--
-- Structure de la table `failed_jobs`
--

CREATE TABLE IF NOT EXISTS `failed_jobs` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

--
-- Structure de la table `migrations`
--

CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(6, '2014_10_12_000000_create_users_table', 1),
(7, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(10, '2023_02_20_124546_create_patients_table', 1),
(11, '2023_02_20_142428_update_patient', 2),
(12, '2023_02_20_144847_update_patient', 3),
(13, '2023_02_20_145438_update_patient', 4),
(14, '2023_02_20_151041_create_cliniques_table', 5),
(15, '2023_02_21_041442_update_users', 6),
(16, '2023_02_21_091023_update_cliniques', 7),
(17, '2023_02_21_114917_update_clinique', 8),
(18, '2023_02_21_143356_delete_name_in_user', 9),
(19, '2023_02_21_143555_add_name_in_patient', 9),
(20, '2023_02_21_144331_add_name_in_clinique', 9),
(21, '2023_02_21_151153_create_rdvs_table', 10),
(22, '2023_02_21_154142_create_analyses_table', 10),
(23, '2023_02_21_163333_create_analyse_clinique', 11),
(24, '2023_02_23_135048_add_colums_long_lat_ville_commune_at_clinique', 12),
(25, '2023_02_23_135118_add_colums_long_lat_ville_commune_at_cliniques', 12),
(26, '2023_02_27_152218_add_statut_at_clinique_patient', 13),
(27, '2023_02_28_072714_create_admins_table', 14),
(28, '2023_03_06_145200_create_villes', 15),
(31, '2023_03_06_145328_create_communes', 16),
(32, '2023_03_06_152718_update_cliniques', 16),
(33, '2023_03_07_183425_update_analyse_clinique', 16),
(36, '2023_03_07_221610_update_rdv', 17),
(37, '2023_03_08_073625_create_disponibilites_table', 17),
(40, '2023_03_08_141527_update_rdv', 18),
(41, '2023_03_08_144620_update_rdv', 19),
(42, '2023_03_08_155048_update_rdv', 20),
(43, '2023_03_09_145943_update_rdv', 21),
(44, '2023_03_14_121959_update_clinique_patient', 22),
(45, '2023_03_14_122511_update_clinique_patient', 23),
(46, '2023_03_16_044952_update_clinique_patient', 24),
(47, '2023_03_19_211037_update_clinique_patient', 24),
(48, '2023_03_19_220403_create_clinique_patient', 25),
(49, '2023_03_19_225733_sos', 26),
(50, '2023_03_19_225841_create_sos', 26),
(51, '2023_03_19_231111_update_sos', 27),
(52, '2023_03_20_110521_update_users', 28);

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

--
-- Structure de la table `patients`
--

CREATE TABLE IF NOT EXISTS `patients` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `habitation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `genre` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `patients_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `patients` (`id`, `habitation`, `genre`, `telephone`, `user_id`, `created_at`, `updated_at`, `name`) VALUES
(1, NULL, NULL, '0556582645', 2, '2023-02-21 09:14:08', '2023-02-21 09:14:08', 'Dago Ange'),
(4, NULL, NULL, '0769480137', 10, '2023-03-15 17:51:19', '2023-03-15 17:51:19', 'AGLEBE EMILIE');

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

--
-- Structure de la table `sos`
--

CREATE TABLE IF NOT EXISTS `sos` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom_prenoms` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `analyse_id` bigint UNSIGNED NOT NULL,
  `commune_id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `statut` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sos_analyse_id_foreign` (`analyse_id`),
  KEY `sos_commune_id_foreign` (`commune_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `sos` (`id`, `nom_prenoms`, `telephone`, `email`, `analyse_id`, `commune_id`, `created_at`, `updated_at`, `statut`) VALUES
(1, 'Dago ANge', '0769480137', 'dagodasi@gmail.com', 10, 1, '2023-03-20 07:01:27', '2023-03-20 07:01:27', 'A venir'),
(2, 'Dago ANge', '0556582645', 'ange.dago@inov-groupe.com', 11, 1, '2023-03-20 17:06:50', '2023-03-20 17:06:50', 'A venir');

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

--
-- Structure de la table `villes`
--

CREATE TABLE IF NOT EXISTS `villes` (
  `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `nom` (`nom`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;

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

INSERT INTO `villes` (`id`, `nom`, `created_at`, `updated_at`) VALUES
(1, 'Abidjan', '2023-03-06 15:09:27', '2023-03-06 15:09:27'),
(11, 'Anyama', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(12, 'Bingervile', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(13, 'Songon', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(14, 'Alepe', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(15, 'Oghwyapo', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(16, 'Dabou', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(17, 'Sikensi', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(18, 'Grand-Lahou', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(19, 'Jacqueville', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(20, 'Tiassale', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(21, 'Taabo', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(22, 'Dikodougou', '2023-03-06 15:09:28', '2023-03-06 15:09:28'),
(23, 'Guiembe', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(24, 'Karakoro', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(25, 'Korhogo', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(26, 'Komborodougou', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(27, 'M\'bengue', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(28, 'Napieledougou', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(29, 'Niofoin', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(30, 'Tioroniaradougou', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(31, 'Sinematiali', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(32, 'Sirasso', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(33, 'Gbon', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(34, 'Boundiali', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(35, 'Kassere', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(36, 'Kolia', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(37, 'Kouto', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(38, 'Diawala', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(39, 'Ferkessedougou', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(40, 'Kong', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(41, 'Koumbala', '2023-03-06 15:09:29', '2023-03-06 15:09:29'),
(42, 'Nielle', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(43, 'Ouangolodougou', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(44, 'Kanakono', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(45, 'Tengrela', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(46, 'Aboisso', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(47, 'Ayame', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(48, 'Bianouan', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(49, 'Mafere', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(50, 'Tiapoum', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(51, 'Adiake', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(52, 'Assinie-mafia', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(53, 'Etueboue', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(54, 'Grand-bassam', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(55, 'Bonoua', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(56, 'Bediala', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(57, 'Daloa', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(58, 'Gadouan', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(59, 'Gboguhe', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(60, 'Zaïbo', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(61, 'Zoukougbeu', '2023-03-06 15:09:30', '2023-03-06 15:09:30'),
(62, 'Boguedia', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(63, 'Iboguhe', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(64, 'Issia', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(65, 'Saïoua', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(66, 'Dania', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(67, 'Seitifla', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(68, 'Vavoua', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(69, 'Agboville', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(70, 'Azaguie', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(71, 'Cechi', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(72, 'Grand morie', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(73, 'Oress-krobou', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(74, 'Rubino', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(75, 'Adzope', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(76, 'Agou', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(77, 'Affery', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(78, 'Becedi-brignan', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(79, 'Akoupe', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(80, 'Assikoi', '2023-03-06 15:09:31', '2023-03-06 15:09:31'),
(81, 'Yakasse-attobrou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(82, 'Abengourou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(83, 'Bettie', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(84, 'Niable', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(85, 'Agnibilekrou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(86, 'Diabo', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(87, 'Djebonoua', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(88, 'Brobo', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(89, 'Botro', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(90, 'Bouake', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(91, 'Languibonou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(92, 'Beoumi', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(93, 'Bodokro', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(94, 'Ando-kekrenou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(95, 'Kondrobo', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(96, 'Bassawa', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(97, 'Bonieredougou', '2023-03-06 15:09:32', '2023-03-06 15:09:32'),
(98, 'Dabakala', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(99, 'Foumbolo', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(100, 'Satama-sokoro', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(101, 'Satama-sokouro', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(102, 'Fronan', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(103, 'Katiola', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(104, 'Niakaramandougou', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(105, 'Tafire', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(106, 'Tortiya', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(107, 'Timbe', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(108, 'Sakassou', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(109, 'Tomoudi-sakassou', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(110, 'Man', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(111, 'Facobly', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(112, 'Kouibly', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(113, 'Logouale', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(114, 'Sangouine', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(115, 'Semien', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(116, 'Niadrou', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(117, 'Totrodrou', '2023-03-06 15:09:33', '2023-03-06 15:09:33'),
(118, 'Bangolo', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(119, 'Dieouzon', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(120, 'Zeo', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(121, 'Zou', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(122, 'Biankouma', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(123, 'Gbonne', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(124, 'Sipilou', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(125, 'Danane', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(126, 'Bin-houye', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(127, 'Zouan-hounien', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(128, 'Mahapleu', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(129, 'DIVO', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(130, 'FRESCO', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(131, 'GUITRY', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(132, 'HIRE', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(133, 'YOCOBOUE', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(134, 'LAKOTA', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(135, 'NIAMBEZARIA', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(136, 'ZIKISSO', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(137, 'Bayota', '2023-03-06 15:09:34', '2023-03-06 15:09:34'),
(138, 'Gagnoa', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(139, 'Gnagbodougnoa', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(140, 'Guiberoua', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(141, 'Ouragahio', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(142, 'Diegonefla', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(143, 'Oume', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(144, 'Yamoussoukro', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(145, 'Didievi', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(146, 'Attiegouakro', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(147, 'Tiebissou', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(148, 'Tie-n’diekro', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(149, 'Toumodi', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(150, 'Djekanou', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(151, 'Angoda', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(152, 'Kpouebo', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(153, 'Kokoumbo', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(154, 'DUEKOUE', '2023-03-06 15:09:35', '2023-03-06 15:09:35'),
(155, 'BAGOHOUO', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(156, 'GBAPLEU', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(157, 'GUEHIEBLY', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(158, 'GUEZON', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(159, 'BLOLEQUIN', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(160, 'GUIGLO', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(161, 'TAÏ', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(162, 'TOULEPLEU', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(163, 'BAKOUBLY', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(164, 'PEHE', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(165, 'TIOBLY', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(166, 'Bondoukou', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(167, 'Goumere', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(168, 'Tabagne', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(169, 'Taoudi', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(170, 'Sorobango', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(171, 'Sapli', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(172, 'Sandegue', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(173, 'Bouna', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(174, 'Doropo', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(175, 'Nassian', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(176, 'Tehini', '2023-03-06 15:09:36', '2023-03-06 15:09:36'),
(177, 'Tanda', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(178, 'Assuefry', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(179, 'Kouassi-datekro', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(180, 'Transua', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(181, 'Tankesse', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(182, 'BOOKO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(183, 'BOROTOU', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(184, 'GUINTEGUELA', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(185, 'KOONAN', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(186, 'KORO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(187, 'OUANINOU', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(188, 'TOUBA', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(189, 'FOUNGBESSO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(190, 'GRAND-BEREBY', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(191, 'SAN-PEDRO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(192, 'GUEYO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(193, 'SASSANDRA', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(194, 'SAGO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(195, 'BUYO', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(196, 'GRAND-ZATTRY', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(197, 'MEAGUI', '2023-03-06 15:09:37', '2023-03-06 15:09:37'),
(198, 'OKROUYO', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(199, 'SOUBRE', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(200, 'GRABO', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(201, 'TABOU', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(202, 'Dimbokro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(203, 'Anoumaba', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(204, 'Arrah', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(205, 'Bongouanou', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(206, 'M\'batto', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(207, 'Tiemelekro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(208, 'Bocanda', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(209, 'Daoukro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(210, 'Ettrokro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(211, 'Kouassi-kouassikro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(212, 'Ouelle', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(213, 'M\'bahiakro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(214, 'Banguera', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(215, 'Koffi-amonkro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(216, 'Prikro', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(217, 'Bonon', '2023-03-06 15:09:38', '2023-03-06 15:09:38'),
(218, 'Bouafle', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(219, 'Sinfra', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(220, 'Kouetinfla', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(221, 'Bazre', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(222, 'Konefla', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(223, 'Gohitafla', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(224, 'Zuenoula', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(225, 'Dianra', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(226, 'Kongasso', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(227, 'Kounahiri', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(228, 'Mankono', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(229, 'Marandallah', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(230, 'Sarhala', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(231, 'Tieningboue', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(232, 'Djibrosso', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(233, 'Dualla', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(234, 'Kani', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(235, 'Massala', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(236, 'Morondo', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(237, 'Seguela', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(238, 'Sifie', '2023-03-06 15:09:39', '2023-03-06 15:09:39'),
(239, 'Worofla', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(240, 'Bako', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(241, 'Dioulatiedougou', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(242, 'Gbeleban', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(243, 'Goulia', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(244, 'Kaniasso', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(245, 'Madinani', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(246, 'Minignan', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(247, 'Odienne', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(248, 'Samatiguila', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(249, 'Seguelon', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(250, 'Seydougou', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(251, 'Tieme', '2023-03-06 15:09:40', '2023-03-06 15:09:40'),
(252, 'Tienko', '2023-03-06 15:09:40', '2023-03-06 15:09:40');

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

--
-- Contraintes pour la table `admins`
--
ALTER TABLE `admins`
  ADD CONSTRAINT `admins_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `analyse_clinique`
--
ALTER TABLE `analyse_clinique`
  ADD CONSTRAINT `analyse_clinique_analyse_id_foreign` FOREIGN KEY (`analyse_id`) REFERENCES `analyses` (`id`),
  ADD CONSTRAINT `analyse_clinique_clinique_id_foreign` FOREIGN KEY (`clinique_id`) REFERENCES `cliniques` (`id`);

--
-- Contraintes pour la table `cliniques`
--
ALTER TABLE `cliniques`
  ADD CONSTRAINT `cliniques_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `clinique_patient`
--
ALTER TABLE `clinique_patient`
  ADD CONSTRAINT `clinique_patient_analyse_clinique_id_foreign` FOREIGN KEY (`analyse_clinique_id`) REFERENCES `analyse_clinique` (`id`),
  ADD CONSTRAINT `clinique_patient_clinique_id_foreign` FOREIGN KEY (`clinique_id`) REFERENCES `cliniques` (`id`),
  ADD CONSTRAINT `clinique_patient_disponibilite_id_foreign` FOREIGN KEY (`disponibilite_id`) REFERENCES `disponibilites` (`id`),
  ADD CONSTRAINT `clinique_patient_patient_id_foreign` FOREIGN KEY (`patient_id`) REFERENCES `patients` (`id`);

--
-- Contraintes pour la table `disponibilites`
--
ALTER TABLE `disponibilites`
  ADD CONSTRAINT `disponibilites_clinique_id_foreign` FOREIGN KEY (`clinique_id`) REFERENCES `cliniques` (`id`);

--
-- Contraintes pour la table `patients`
--
ALTER TABLE `patients`
  ADD CONSTRAINT `patients_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `sos`
--
ALTER TABLE `sos`
  ADD CONSTRAINT `sos_analyse_id_foreign` FOREIGN KEY (`analyse_id`) REFERENCES `analyses` (`id`),
  ADD CONSTRAINT `sos_commune_id_foreign` FOREIGN KEY (`commune_id`) REFERENCES `communes` (`id`);
COMMIT;

