-- phpMyAdmin SQL Dump -- version 5.1.1 -- 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 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Base de données : `ewa_bd` -- -- -------------------------------------------------------- -- -- Structure de la table `admins` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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` -- DROP TABLE IF EXISTS `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 `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; CREATE TABLE IF NOT EXISTS `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Structure de la table `patients` -- DROP TABLE IF EXISTS `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 `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; CREATE TABLE IF NOT EXISTS `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Structure de la table `sos` -- DROP TABLE IF EXISTS `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 `users` -- DROP TABLE IF EXISTS `users`; CREATE TABLE IF NOT EXISTS `users` ( `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `role` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `statut` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'enable', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC; -- -- Déchargement des données de la table `users` -- INSERT INTO `users` (`id`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `role`, `statut`) VALUES (1, 'dagodasi@gmail.com', NULL, '$2y$10$/7BBwI06Why4fA.UciZEiOnW0jbodgbyu8AeqpvjHlbRZeRz1Uv.m', NULL, '2023-02-21 04:12:45', '2023-02-21 04:12:45', 'patient', 'enable'), (2, 'dagodassiange@gmail.com', NULL, '$2y$10$JMPkQsaId1Oy2pVPcbS1BOP5H4r4KYIfb66IXs4Zyq88JPaR/QI3y', NULL, '2023-02-21 09:14:08', '2023-02-21 09:14:08', 'patient', 'enable'), (6, 'info@cliniquepalmeraie.ci', NULL, '$2y$10$2RzvmMdcp7pnfBhQjl4KBu/IyDT5KVmZqlBwMFPsNay.agIieGr5C', NULL, '2023-02-21 12:38:30', '2023-02-21 12:38:30', 'clinique', 'enable'), (8, 'ange.dago@akassoh.ci', '0000-00-00 00:00:00', '$2y$10$JMPkQsaId1Oy2pVPcbS1BOP5H4r4KYIfb66IXs4Zyq88JPaR/QI3y', '', '2023-02-28 07:43:21', '2023-02-28 07:43:21', 'admin', 'enable'), (10, 'aglebeemilie@gmail.com', NULL, '$2y$10$xGHo6.MJ/LjILvw82MiUNu2oH81dpca8AdBtaieONx/pI5YRETKWq', NULL, '2023-03-15 17:51:18', '2023-03-20 17:14:08', 'patient', 'enable'), (17, 'info@longuevie.com', NULL, '$2y$10$CzelTfCBRO90hTPeSG8BN.hCKtEp3dvIUed7VV.XYp9c1IsXj87F.', NULL, '2023-03-20 11:44:02', '2023-03-20 17:12:47', 'clinique', 'disable'); -- -------------------------------------------------------- -- -- Structure de la table `villes` -- DROP TABLE IF EXISTS `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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;