-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mar. 14 jan. 2025 à 10:13
-- Version du serveur : 5.7.33
-- Version de PHP : 8.1.1

START TRANSACTION;



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

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

--
-- Structure de la table `banque_infos`
--

CREATE TABLE `banque_infos` (
  `id` int(11) NOT NULL,
  `bic` varchar(255) DEFAULT NULL,
  `nom` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `adresse` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `banque_infos` (`id`, `bic`, `nom`, `contact`, `email`, `adresse`, `status`, `created_at`, `updated_at`) VALUES
(1, 'BNKSBFJS', 'CAECE', NULL, NULL, NULL, 1, '2024-09-18 13:38:04', '2024-09-18 13:38:04');

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

--
-- Structure de la table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL,
  `msisdn` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `code_service` varchar(255) DEFAULT NULL,
  `libelle` varchar(255) DEFAULT NULL,
  `devise` varchar(255) DEFAULT NULL,
  `key` varchar(255) DEFAULT NULL,
  `active_date` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1);

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

--
-- Structure de la table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `reports`
--

CREATE TABLE `reports` (
  `id` int(11) NOT NULL,
  `fileName` text,
  `fullPath` text,
  `nom_client` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `ReportName` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Structure de la table `serveurs`
--

CREATE TABLE `serveurs` (
  `id` int(11) NOT NULL,
  `code_agence` varchar(100) NOT NULL,
  `libelle_agence` varchar(255) DEFAULT NULL,
  `type_agence` varchar(200) DEFAULT NULL,
  `ip_agence` varchar(100) NOT NULL,
  `bd_agence` varchar(255) NOT NULL,
  `login_sa` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `port` int(11) DEFAULT '1433',
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `serveurs` (`id`, `code_agence`, `libelle_agence`, `type_agence`, `ip_agence`, `bd_agence`, `login_sa`, `password`, `port`, `status`, `created_at`, `updated_at`) VALUES
(1, '000', 'AGENCE CAECE DE BAMAKO', 'Caisse mére', '192.100.101.241', 'SAF_CAECE_30001', 'sa', 'eyJpdiI6IjlVSFllRmJSa0xGNFB6ZGI0aEZhRnc9PSIsInZhbHVlIjoicWM0cTk0REhodms1NThMU2RyQTVJQT09IiwibWFjIjoiOTlkNmM5ZjdkMGRjOTYzMmYzYmNjNDc1MjM0MTM4MzhjMWEyZDZhMjZiNTBmZGUyZmQ5ZDlhMDAwYjlmMmJjMSIsInRhZyI6IiJ9', 1433, 1, '2023-12-07 15:38:06', '2024-01-29 16:10:18'),
(2, '001', 'AGENCE DE BADALABOUGOU', 'Caisse mére', '192.100.101.237', 'SAF_CAECE_30001', 'intercaisse', 'eyJpdiI6IkJYeVJuVk1UTENQci9CZm1JMFZPRWc9PSIsInZhbHVlIjoiU21mdW9uOTlMZVUwZ2RnMGJqbTc2UT09IiwibWFjIjoiZjU3YjQzZjY2NzkwMDY0OWZmNGNmMjY5ZDVmZDk1NzdmYzNmNTNkZGIxMmQwYmQzMWEzMjIxZjgxMzlhNjRlNiIsInRhZyI6IiJ9', 1433, 1, '2023-12-07 23:00:00', '2023-12-07 15:56:22'),
(3, '01', 'UNION', 'Caisse mére', '192.100.101.22', 'SAF_CAECE_UNION', 'intercaisse', '•–—', 1433, 1, '2023-12-08 23:00:00', '2023-12-08 23:00:00'),
(4, '100', 'AGENCE CAECE DE KAYES', 'Caisse mére', '192.100.101.169', 'SAF_KAYES_30004', 'intercaisse', '•–—', 1433, 1, '2023-12-09 23:00:00', '2023-12-09 23:00:00'),
(5, '101', 'AGENCE CAECE DE KITA', 'PS', '192.100.101.106', 'SAF_CAECE_KITA', 'intercaisse', '•–—', 1433, 1, '2023-12-10 23:00:00', '2023-12-10 23:00:00'),
(6, '102', 'AGENCE DE KENIEBA', 'PS', '192.100.101.111', 'SAF_CAECE_30102', 'intercaisse', '•–—', 1433, 1, '2023-12-11 23:00:00', '2023-12-11 23:00:00'),
(7, '103', 'AGENCE DE DIEMA', 'PS', '192.100.101.79', 'SAF_CAECE_30103', 'intercaisse', '•–—', 1433, 1, '2023-12-12 23:00:00', '2023-12-12 23:00:00'),
(8, '200', 'AGENCE CAECE DE KOULIKORO', 'PS', '192.100.101.156', 'SAF_CAECE_30005', 'intercaisse', '•–—', 1433, 1, '2023-12-13 23:00:00', '2023-12-13 23:00:00'),
(9, '201', 'AGENCE CAECE DE KATI', 'PS', '192.100.101.109', 'SAF_CAECE_30201', 'intercaisse', '•–—', 1433, 1, '2023-12-14 23:00:00', '2023-12-14 23:00:00'),
(10, '202', 'AGENCE CAECE DE FANA', 'PS', '192.100.101.113', 'SAF_CAECE_30202', 'intercaisse', '•–—', 1433, 1, '2023-12-15 23:00:00', '2023-12-15 23:00:00'),
(11, '203', 'AGENCE CAECE DE NARA', 'PS', '192.100.101.107', 'SAF_CAECE_NARA', 'intercaisse', '•–—', 1433, 1, '2023-12-16 23:00:00', '2023-12-16 23:00:00'),
(12, '204', 'AGENCE CAECE DE KANGABA', 'PS', '192.100.101.104', 'SAF_KANGABA_30204', 'intercaisse', '•–—', 1433, 1, '2023-12-17 23:00:00', '2023-12-17 23:00:00'),
(13, '205', 'AGENCE CAECE DE MOURDIAH', 'PS', '.', 'SAF_CAECE_30205', 'intercaisse', '•–—', 1433, 1, '2023-12-18 23:00:00', '2023-12-18 23:00:00'),
(14, '206', 'AGENCE CAECE DE FALLOU', 'PS', '.', 'SAF_CAECE_30206', 'intercaisse', '•–—', 1433, 1, '2023-12-19 23:00:00', '2023-12-19 23:00:00'),
(15, '207', 'AGENCE CAECE DE DILLY', 'PS', '.', 'SAF_CAECE_30207', 'intercaisse', '•–—', 1433, 1, '2023-12-20 23:00:00', '2023-12-20 23:00:00'),
(16, '208', 'AGENCE CAECE DE KOLOKANI', 'PS', '192.100.101.244', 'SAF_CAECE_30208', 'intercaisse', '•–—', 1433, 1, '2023-12-21 23:00:00', '2023-12-21 23:00:00'),
(17, '209', 'AGENCE CAECE DE BANAMBA', 'PS', 'DESKTOP-1NMH4P8', 'CAECE_BANAMBA', 'sa', 'eyJpdiI6IkJndG5sRkRxQTE3dThidkZNdjlUR1E9PSIsInZhbHVlIjoiQ1pJb2FLcXlDSlk5S3dSNXIreTNMdz09IiwibWFjIjoiNTZlNDBhNjVhM2UzZTU1ZDIzNDhmY2ZmN2I1ZWVhODA1OTQ5M2I2YTA3NzZmNTc4YzFhNDcwMGUxYWI4Nzk1NiIsInRhZyI6IiJ9', 1433, 1, '2023-12-22 23:00:00', '2024-10-11 10:52:24'),
(18, '210', 'AGENCE DE DIDIENI', 'PS', '192.100.101.60', 'SAF_CAECE_30210', 'intercaisse', '•–—', 1433, 1, '2023-12-23 23:00:00', '2023-12-23 23:00:00'),
(19, '211', 'AGENCE CAECE DE DIOILA', 'PS', '192.100.101.52', 'SAF_CAECE_30211', 'intercaisse', '•–—', 1433, 1, '2023-12-24 23:00:00', '2023-12-24 23:00:00'),
(20, '300', 'AGENCE CAECE DE SIKASSO', 'Caisse mére', '192.100.101.143', 'SAF_CAECE_30003', 'intercaisse', '•–—', 1433, 1, '2023-12-25 23:00:00', '2023-12-25 23:00:00'),
(21, '301', 'AGENCE CAECE DE BOUGOUNI', 'PS', '192.100.101.112', 'SAF_CAECE_30301', 'intercaisse', '•–—', 1433, 1, '2023-12-26 23:00:00', '2023-12-26 23:00:00'),
(22, '302', 'AGENCE CAECE DE KOUTIALA', 'PS', '192.100.101.103', 'SAF_CAECE_30302', 'intercaisse', '•–—', 1433, 1, '2023-12-27 23:00:00', '2023-12-27 23:00:00'),
(23, '303', 'AGENCE CAECE DE KADIOLO', 'PS', '192.100.101.114', 'SAF_CAECE_30303', 'intercaisse', '•–—', 1433, 1, '2023-12-28 23:00:00', '2023-12-28 23:00:00'),
(24, '304', 'AGENCE CAECE DE LOULOUNI', 'PS', '192.100.101.218', 'SAF_CAECE_30304', 'intercaisse', '•–—', 1433, 1, '2023-12-29 23:00:00', '2023-12-29 23:00:00'),
(25, '400', 'AGENCE CAECE DE SEGOU', 'Caisse mére', '192.100.101.181', 'SAF_CAECE_30002', 'intercaisse', '•–—', 1433, 1, '2023-12-30 23:00:00', '2023-12-30 23:00:00'),
(26, '401', 'AGENCE CAECE DE NIONO', 'PS', '192.100.101.115', 'SAF_CAECE_30401', 'intercaisse', '•–—', 1433, 1, '2023-12-31 23:00:00', '2023-12-31 23:00:00'),
(27, '402', 'AGENCE CAECE DE BLA', 'PS', '192.100.101.243', 'SAF_CAECE_30402', 'intercaisse', '•–—', 1433, 1, '2024-01-01 23:00:00', '2024-01-01 23:00:00'),
(28, '403', 'AGENCE CAECE DE SAN', 'PS', '192.100.101.116', 'SAF_CAECE_30403', 'intercaisse', '•–—', 1433, 1, '2024-01-02 23:00:00', '2024-01-02 23:00:00'),
(29, '404', 'AGENCE CAECE DE MACINA', 'PS', '192.100.101.117', 'SAF_MACINA_30404', 'intercaisse', '•–—', 1433, 1, '2024-01-03 23:00:00', '2024-01-03 23:00:00'),
(30, '405', 'AGENCE CAECE DE KONOBOUGOU', 'PS', '.', 'SAF_CAECE_30405', 'intercaisse', '•–—', 1433, 1, '2024-01-04 23:00:00', '2024-01-04 23:00:00'),
(31, '406', 'AGENCE DE BAROUELI', 'PS', '192.100.101.80', 'SAF_CAECE_30406', 'intercaisse', '•–—', 1433, 1, '2024-01-05 23:00:00', '2024-01-05 23:00:00'),
(32, '500', 'AGENCE CAECE DE MOPTI', 'Caisse mére', '192.100.101.238', 'SAF_MOPTI_30500', 'intercaisse', '•–—', 1433, 1, '2024-01-06 23:00:00', '2024-01-06 23:00:00'),
(33, '501', 'AGENCE CAECE DE BANDIAGARA', 'PS', '192.100.101.90', 'SAF_CAECE_30501', 'intercaisse', '•–—', 1433, 1, '2024-01-07 23:00:00', '2024-01-07 23:00:00');

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

--
-- Structure de la table `sql_logs`
--

CREATE TABLE `sql_logs` (
  `id` int(11) NOT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(225) DEFAULT NULL,
  `req_sql` text,
  `data` text,
  `time` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `traces`
--

CREATE TABLE `traces` (
  `id` int(11) NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(225) DEFAULT NULL,
  `action` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nom` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prenom` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `adresse` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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,
  `status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `nom`, `prenom`, `phone`, `adresse`, `email`, `email_verified_at`, `password`, `remember_token`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Camara', 'Baniamey', '71417839', 'Bamako, Mali', 'moulaye@gmail.com', NULL, '$2y$10$YNamTDt4EswVYIzl2Wkbw.oiZVIRhq7m6VKSWbV2SA2LLLruozayO', 'hzU8bDMthUvlOCCvxyJuf5O2FAd9oGax9DvdhwE2e19VYb476iwqXGGGeDrP', 1, '2024-09-18 09:05:13', '2024-09-18 09:17:05');

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

--
-- Structure de la table `user_credentials`
--

CREATE TABLE `user_credentials` (
  `id` int(11) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `last_user_id_update` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `user_credentials` (`id`, `username`, `password`, `last_user_id_update`, `status`, `created_at`, `updated_at`) VALUES
(1, 'wscaece', 'Caece@2024', 1, 1, '2025-01-13 17:01:44', '2025-01-13 17:35:03');

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

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

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

--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

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

--
-- Index pour la table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

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

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

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

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

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

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

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

--
-- AUTO_INCREMENT pour la table `clients`
--
ALTER TABLE `clients`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT pour la table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT pour la table `sql_logs`
--
ALTER TABLE `sql_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `traces`
--
ALTER TABLE `traces`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

