-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Hôte : localhost:3306 -- Généré le : dim. 07 sep. 2025 à 23:17 -- Version du serveur : 11.4.8-MariaDB -- Version de PHP : 8.4.10 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 : `lebackyard_iris_auth_app` -- CREATE DATABASE IF NOT EXISTS `iris_auth` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; USE `iris_auth`; -- -------------------------------------------------------- -- -- Structure de la table `api_keys` -- DROP TABLE IF EXISTS `api_keys`; CREATE TABLE `api_keys` ( `id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `name` varchar(150) DEFAULT NULL, `key` varchar(150) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `kc_realm` varchar(50) DEFAULT NULL, `kc_client_id` varchar(50) NOT NULL, `kc_client_secret` varchar(50) NOT NULL, `kc_ftp` tinyint(4) NOT NULL DEFAULT 0, `app_url` varchar(50) NOT NULL, `app_apikey` varchar(255) NOT NULL, `kc_public_filename` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Déchargement des données de la table `api_keys` -- INSERT INTO `api_keys` (`id`, `created_at`, `updated_at`, `name`, `key`, `is_active`, `kc_realm`, `kc_client_id`, `kc_client_secret`, `kc_ftp`, `app_url`, `app_apikey`, `kc_public_filename`) VALUES (1, '2025-03-12 23:35:51', '2025-03-12 23:35:51', 'AppKey_233551', 'a8bd7ddef0bb4af808eea8dbcb443fea0468ecd3aec65172551bcec6e5613743', 1, '', '', '', 1, '', '', ''), (2, '2025-03-13 09:10:25', '2025-03-13 09:10:25', 'AppKey_091025', 'a0a814d147d27c6716939c9a9a0606f5c1318e94625bcf08281301878a8832a5', 1, '', '', '', 1, '', '', ''), (3, '2025-03-19 13:05:50', '2025-03-19 13:05:50', 'AppKey_130550', 'c098bda3a7d47a1da7611f02c65a5e597bb4a306d6a30f68387df266f34cc385', 1, '', '', '', 1, '', '', ''), (4, '2025-03-19 13:08:05', '2025-03-19 13:08:05', 'AppKey_130805', '7756da0e9ea0b7b0d28c27b0c8b431712746a3769c8382c7cb719f1cec240b54', 1, '', '', '', 1, '', '', ''), (5, '2025-03-19 15:13:13', '2025-03-19 15:13:13', 'AppKey_151313', '2dcbcdbde913a41bb2ac994e31098286ef75ff33deb434659202bdf4e872ca3b', 1, '', '', '', 1, '', '', ''), (6, '2025-06-17 11:47:48', '2025-06-17 11:47:48', 'AppKey_114748', '6def1267807e1e790b77ee60d661f520a10506c81345d97a1741ddfa4d0201de', 1, 'Ceteris', 'ceteris', 'y0Z3myDaFk9xIQsOvEltLDpSKQlhFI9a', 0, 'https://estair-backend.alcyon-partners.net/v1', 'd485515018f0bac34af550fbdad18ac855a31e75c2c2895283c9ff557c6987f2cde3715807d33bf55424113147a614cfdca4', 'KEYCLOAK_publickey_ceteris.json'), (7, '2025-06-17 14:00:59', '2025-06-17 14:00:59', 'AppKey_140059', 'c795a0a84c18664e8a222979ca5e9111aeacae020515db80322b680d6b488175', 1, 'BDU', 'bdu', 'y0Z3myDaFk9xIQsOvEltLDpSKQlhFI9a', 0, 'https://iris.lebackyard-africa.com/v1', '9ff180c75ae61ecf0e5ad2530808fd5fd896da421edf4f17cc3ed8cf96e93fd4c9c728b05220c2247ece4bf00b3417cd67bb', 'KEYCLOAK_publickey.json'); -- -------------------------------------------------------- -- -- Structure de la table `cache` -- DROP TABLE IF EXISTS `cache`; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Structure de la table `migrations` -- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) 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, '0001_01_01_000001_create_cache_table', 1), (2, '2025_02_24_142023_create_api_keys', 1), (3, '2025_03_22_050437_create_user_codes_table', 2); -- -------------------------------------------------------- -- -- Structure de la table `user_codes` -- DROP TABLE IF EXISTS `user_codes`; CREATE TABLE `user_codes` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `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 `user_codes` -- INSERT INTO `user_codes` (`id`, `uuid`, `name`, `phone`, `code`, `created_at`, `updated_at`) VALUES (1, '5a8b803f-8d3e-43c2-a4af-1bb9ac58eb1f', '0a5ca26b2aab6144543397fbe691f9', '+2250123456789', '66484', '2025-03-22 05:50:27', '2025-03-22 05:50:27'), (2, 'f43fbcbf-b9d9-4016-8832-4de21c9b5dfa', '7c5e6767c12d1b293c53e5e9203f3b', '+2250788650263', '94747', '2025-03-23 12:52:54', '2025-04-03 15:09:57'), (3, '146a625e-6ded-4698-b051-3e40e018399c', '9fbe8289c24e3c39167b2f90eb4074', '+2250555555555', '95434', '2025-03-25 13:50:01', '2025-04-07 11:23:46'), (4, 'b8a422e8-241a-48bd-9ddb-d59a944cab5a', '3347f197c49ad9b5ae1fc208483eac', '+2250111111111', '70779', '2025-03-25 14:01:23', '2025-03-31 01:44:03'), (5, '35aecb7e-a89f-4ee1-a564-71b4ffa0c066', 'be62d7092ed9f9e223ed21dbd8d61c', '+2250546284618', '80812', '2025-03-25 14:07:42', '2025-05-16 18:14:22'), (6, 'bd0d7ac1-b488-48a3-9021-99c0c5c5bbf9', '44e39b0f5270f28a004a21a47033ec', '+2252222222222', '89239', '2025-03-25 17:19:06', '2025-03-25 17:19:06'), (7, 'cb8db9c6-593f-4daa-aa48-4c5302403a06', '3579d2eaaae3f68c66b7ba2a81e1aa', '+2250665588888', '93364', '2025-03-25 18:56:47', '2025-03-25 18:56:47'), (8, '09cab743-17a2-4200-9be3-e3cb3b153296', 'fc8f287270085bbdbb23567c2142b1', '+2250171667388', '73792', '2025-03-25 18:57:07', '2025-04-01 10:27:45'), (9, 'dc4f8772-bb2d-4a3f-b5a5-2d591232c48c', 'b78378009c7343aed5129efcfeb67e', '+2250599595559', '67462', '2025-03-25 20:01:30', '2025-03-25 20:01:30'), (10, 'bba67d89-af47-4b16-88b9-27a2b8003c37', '7f5e4b563e988122ff138ef8451a59', '+2250595959595', '95849', '2025-03-25 20:04:30', '2025-03-26 22:49:09'), (11, '3e9ddbd9-035e-413c-a8be-5b6fde7c8573', '37ee21c509f0e8e97f42d151b01644', '+2250999999999', '49463', '2025-03-25 20:05:56', '2025-03-25 20:05:56'), (12, '5a5d7c76-17fa-489f-a83e-a0f271cfccc4', 'b5d2a3abdaf059ac3483d5f9a34c76', '+2250888888888', '72541', '2025-03-25 20:10:50', '2025-04-03 14:38:36'), (13, '97846da6-2847-40c4-a653-76f2e5698db6', 'f153eae20b0c1505681cbf29ee6beb', '+2250696996969', '25102', '2025-03-25 20:11:20', '2025-03-25 20:11:20'), (14, '94eeefb1-ee4b-4c51-9d3c-327cb97bf2c1', '81fef302fd1df1fd9362af71b31fd3', '+2250444444444', '73857', '2025-03-25 20:19:41', '2025-03-25 20:19:41'), (15, 'd168f30f-f13c-4587-8074-a5579d202a7d', '412bb3aa178899ccf4bd843665f6be', '+2250333333333', '35054', '2025-03-25 20:20:09', '2025-03-25 22:58:33'), (16, '9ae24272-408d-467f-92f2-734618a24bce', '408609809ded4b137eddd3c0067bb1', '+2250666666666', '71647', '2025-03-25 20:24:38', '2025-04-01 15:40:08'), (17, '0e099fdf-4527-4b5f-9c10-e10a8339bbf6', 'a53c1844ee7f20b1240bf10eb24215', '+2250366666666', '28662', '2025-03-25 20:24:56', '2025-03-25 20:24:56'), (18, 'f830c8c4-b478-4624-b8d7-ed228d41e8d1', '8c0a80c7982679966fa2ec0d6a5155', '+2250366666667', '69403', '2025-03-25 20:25:23', '2025-03-25 20:25:23'), (19, '47d97886-7603-4d6a-bbbe-9c095ef29b61', 'd28888efa628662fabd10843ccc6bc', '+2250666666665', '91046', '2025-03-25 20:26:28', '2025-03-25 20:26:28'), (20, '5a4aa6a2-8c53-4b90-ac17-954ba7579d00', 'bbed4f0745e030a7aa1d5ba19ff330', '+2250222222222', '46915', '2025-03-25 22:57:38', '2025-03-27 01:58:45'), (21, '46a63d79-7265-4e75-a8e5-c896a7873d69', '0f2cee9181444c26f8bf31c23f24ef', '+2250121212121', '76459', '2025-03-25 23:00:05', '2025-03-26 01:47:03'), (22, '37d5e748-5ab9-4e7e-84a8-f3ec52739900', '298cc01583c69c6e5757f865d87cf0', '+2250757905270', '39953', '2025-03-25 23:45:57', '2025-03-30 14:16:32'), (23, '1c64e4bf-6b6e-4e80-b940-edf3fc9009ce', '19ec17adeffd5112018f2f94b1d7e7', '+2250131313131', '18485', '2025-03-26 00:02:42', '2025-03-26 00:02:42'), (24, '9de94f48-df16-4cf2-a717-ffb6566a8b77', '8a3f15ea2b2797718d300c8b15de9d', '+2250161616161', '99852', '2025-03-26 00:09:18', '2025-03-26 00:09:18'), (25, 'ca029fa0-7a62-4a97-9c15-e256afec38a7', '8b22b4e7103f73e8445f0723df6813', '+2250171717171', '19280', '2025-03-26 00:10:43', '2025-03-31 00:10:41'), (26, 'b884c990-ce44-463f-9056-094a921e6b27', '06fe3f881394664a3fff6239a91688', '+2250171717172', '38188', '2025-03-26 00:11:27', '2025-03-26 00:11:27'), (27, '40ed949b-f77c-4e21-8fdf-85b7b7e6fa7d', 'ae68565a0f19df3c75b7b0e21c1e84', '+2250919191919', '75162', '2025-03-26 00:14:57', '2025-03-26 00:14:57'), (28, '780eace1-6bf7-4a11-8305-a36316d97696', '327e3ecb7a8800a5e9f1eb5846d862', '+2250759730540', '84192', '2025-03-26 00:43:23', '2025-04-03 15:20:38'), (29, 'd894ea9d-8c42-4d5f-93d6-d4e830f056b3', '6f108c9b881a05bce28826dfc173c1', '+2250181918191', '75635', '2025-03-26 02:02:18', '2025-03-26 02:02:18'), (30, 'b1a92a5d-9594-4747-af09-687809690279', 'aba8c922e89c9963e12e10822152ae', '+2250787430901', '40464', '2025-03-26 08:12:26', '2025-04-03 11:20:35'), (31, '075e18eb-60c0-44aa-b780-fa0355d221af', 'f5f350d0cf8a7da0d62b41b36d29f5', '+2250788650267', '59037', '2025-03-26 08:56:09', '2025-03-26 08:56:09'), (32, '339635a0-65eb-4e8a-991b-0997fb0cc6d8', '487d25176b1a5353eab76ba5509f42', '+2250696969696', '94146', '2025-03-26 20:13:44', '2025-03-26 20:30:22'), (33, '20c7ca96-e396-46bc-9d5e-09a99271db31', '6ac3a672ff2041dd7738910c64993f', '+2250499494949', '24735', '2025-03-26 20:18:15', '2025-03-26 20:18:15'), (34, 'b1e3e4b2-f128-418b-af27-99b72b596d30', 'c036726ced6f7fdfcfd710a5377439', '+2250949499494', '93672', '2025-03-26 20:20:29', '2025-03-26 20:20:29'), (35, 'd5f9431a-6d1e-40ed-b715-dc5115e5836f', 'bcc369ee33839932850de843e159ea', '+2250599595959', '39078', '2025-03-26 20:22:47', '2025-03-26 20:29:19'), (36, '5afbc74b-4758-4b39-bf03-b83ff3367621', '7917bc18b464615bc79b105d35a569', '+2250696969699', '50283', '2025-03-26 20:39:01', '2025-03-26 20:39:01'), (37, '68810744-34fa-4854-9e65-d51e07eb3d27', '7fd453402f992b6dee1d423b119865', '+2250696996966', '54849', '2025-03-26 20:55:54', '2025-03-26 20:55:54'), (38, '77ba6e86-24f3-4e64-abc1-daf21bd4a749', 'c438b4be89b34a3a45ca3d3213644f', '+2250595959959', '24076', '2025-03-26 20:57:14', '2025-03-26 20:57:14'), (39, '18004717-11af-4ff5-86c3-4ec3972ea13e', '2e75c2816a2caa893a8f1459c12495', '+2250595959599', '97683', '2025-03-26 22:13:13', '2025-03-26 22:13:13'), (40, '08ab81e3-8fb4-49de-9523-6deffa4d67ba', '881d211884f3b7c56993c3460bd3eb', '+2250494494949', '63087', '2025-03-26 22:18:18', '2025-03-26 22:18:18'), (41, '073d48fd-1827-4c82-b573-9efea2242952', 'e4385d13c6ac3e5472669911df5e9a', '+2250669696969', '86331', '2025-03-26 22:41:37', '2025-03-26 22:41:37'), (42, 'e47e8223-654d-4af1-ba32-724df6dbdced', '8a2496f2b30bc4d21201fbb927613b', '+2250559959595', '27565', '2025-03-26 22:42:55', '2025-03-26 22:42:55'), (43, '45c27bcd-ebe2-4f8c-9637-170d00812c77', 'd418e1a39b5ac2343ec0552cd262d8', '+2250595959559', '12815', '2025-03-26 22:43:51', '2025-03-26 22:43:51'), (44, '3a1a7fcf-b841-4e0e-9a50-5d0c3f5dd326', 'fdd1fd8cab37fbd0616c41abaab10a', '+2250494994944', '69965', '2025-03-26 22:57:03', '2025-03-26 22:57:03'), (45, 'be832239-6e36-4aab-bd30-0bfca52deb64', '46bc98018f3047f6e648bf93af42e6', '+2250494949449', '37413', '2025-03-26 23:36:47', '2025-03-26 23:36:47'), (46, '546fa382-6d10-47a7-9260-cfa20a2ee51f', 'a638d7f7b8ef27d38d3943c5b7f81c', '+2250595955959', '52235', '2025-03-26 23:42:02', '2025-03-26 23:42:02'), (47, 'e05a8b9e-8b2d-495b-bb40-3c172d4df26f', '1f5bbc95637c2c465fe3c984e66ccb', '+33745096718', '57380', '2025-03-30 16:16:32', '2025-03-30 16:28:14'), (48, 'a5453137-ebef-4ac3-ae01-551da899ef44', '1657e4e9fabdf244f5e92c27a77af5', '+2250818181818', '99160', '2025-03-31 00:19:37', '2025-03-31 00:28:18'), (49, '4fd9f4cd-3186-460f-bdbd-daa3552fce58', '05d677f119f3654a132b157f69517d', '+2250555555559', '15493', '2025-03-31 00:47:41', '2025-03-31 00:47:41'), (50, 'a3dd3ba4-e2fe-43d9-b809-8611aebc3271', '7ef4b9646e8ea70041fc18d4b99202', '+2250555555888', '78838', '2025-03-31 01:08:20', '2025-03-31 01:08:20'), (51, '68fb727c-a6e8-4aee-923b-958db8d9acfb', '732cb5d30820cddd772e7a1b4af120', '+2250700252525', '85967', '2025-04-01 11:58:03', '2025-05-16 19:19:22'), (52, 'e0010cc2-4874-4563-98ef-695a50ba917f', '81b98a4a14b1675b7f9f878bb34676', '+2250555225555', '78069', '2025-04-01 15:36:18', '2025-04-01 15:36:18'), (53, '9f0b759d-5025-4148-a516-2edb3810f56b', 'fb2e297d358a705e3778018c15249b', '+2250555555556', '71582', '2025-04-02 05:03:02', '2025-04-02 05:03:02'), (54, '5dbeed0d-bb26-471b-bf68-fc9539c66a0d', 'fd4e9e13a7807e924fc39f8019a5fe', '+2252089022222', '34650', '2025-04-02 15:56:26', '2025-04-02 15:56:26'), (55, '12c6f23f-ab70-43ac-92ab-cad35d2adf3c', '42362628bdcb76b3cdfe533382e33b', '+2250787894240', '99542', '2025-04-03 12:42:31', '2025-04-03 12:42:31'), (56, '003a1015-55a6-4a1b-a72c-f61bcbb5d651', '49b649e8aeb248a4acb56029bd98f6', '+2250546284617', '93430', '2025-04-03 14:43:46', '2025-04-03 14:43:46'), (57, 'ec763367-da26-4f86-9a82-725266930b59', '459623b22967dae23cb4915166d2f1', '+2250787430903', '85462', '2025-04-03 14:45:08', '2025-04-03 14:45:08'), (58, '5d2d3e3a-3cf8-4cfe-9f86-327677584b1e', 'c9d24197f6bd6cce1cd5c96b755a5c', '+2250787430906', '47079', '2025-04-03 14:55:00', '2025-04-03 14:55:00'), (59, 'cc4571c2-8af6-44eb-833a-110beea80337', 'd6bc08351ad4b398f3ff808cdf9271', '+2250555555554', '30877', '2025-04-03 14:55:50', '2025-04-03 14:55:50'), (60, 'd049dccb-1e35-4044-b8c9-cd7a790394dd', '51e4e5408c4f9c23cac32d72883005', '+2250768068636', '55258', '2025-04-03 14:56:46', '2025-04-03 14:56:46'), (61, 'e06ba046-efa6-432e-9ee9-19c859cd91cc', '7231f1f18b9c7d012b348950966a0c', '+2250255555554', '74029', '2025-04-03 14:57:15', '2025-04-03 14:57:15'), (62, '45c8a0d7-7f7f-4be2-bd61-2e4ad3197916', '71c7b944997a2b8f9a0fbcb4736535', '+2250707765283', '73171', '2025-04-03 17:28:32', '2025-04-03 17:28:32'), (63, '57d1db5e-3719-4246-acc3-cf512949e4e0', '9bd6ff5321591fd6e014c28c7c1649', '+2250747710305', '54459', '2025-04-03 17:51:04', '2025-04-03 17:51:04'), (64, 'c8375291-caeb-4367-88c5-57c254a00d9b', 'a66f4c8232a877b9192f83ecf7c144', '+2250747949206', '62138', '2025-04-03 18:00:09', '2025-04-03 18:00:09'), (65, 'e509faf2-1f6d-4153-8779-b978926afcda', '6ac76f9ce00f9e2ffa80562ec7e43c', '+2250747949209', '44257', '2025-04-03 18:01:27', '2025-04-03 18:01:27'), (66, '2faf90fe-94a7-4469-8a96-111398297c5e', '5ddf1e0506a53ed4c0fc77e5d9af59', '+2250500572626', '71925', '2025-04-07 10:22:02', '2025-04-07 10:22:02'), (67, '16e5e3ec-9b3b-4d64-804e-423f22ad1a77', '6316428a2e0935745fc054bdd6192f', '+2250999999988', '60480', '2025-04-07 11:03:46', '2025-04-07 11:03:46'), (68, '78dd8c4c-fb93-458f-9a47-8ef3f77a37b9', '554476ed743f6ae0bc2f422a4eb23d', '+2250888886666', '44828', '2025-04-07 11:16:37', '2025-04-07 11:16:37'), (69, '89daf402-f792-44a1-85a9-ef4f6038386e', '638e52bc423207cfae32a9288f9971', '+2250669999999', '77000', '2025-04-07 11:21:58', '2025-04-07 11:21:58'), (70, '10647469-3e9c-47f5-be86-73842bc364dd', '13e231342bb9c47dcd946831526f35', '+2250999999888', '60771', '2025-04-07 15:24:57', '2025-04-07 15:24:57'), (71, '7f572d3c-0abe-4028-b684-173615396c8a', 'fc6fe881e0e69f523cd571aa6dd392', '+2250747711304', '85698', '2025-04-08 21:38:51', '2025-04-08 21:38:51'), (72, '87794759-19e7-45de-926f-66020a34e181', '75f8f9974be0ffa5b6bb322681c440', '+2250787430923', '32128', '2025-05-16 18:13:27', '2025-05-16 18:13:27'), (73, '504ed438-5170-4bd3-b3be-9bce2b6c36dd', '81887c5ebdbdd7683ad7f9f20b323b', '+2250787430921', '23623', '2025-05-16 18:13:56', '2025-05-16 18:23:00'), (74, '4574ae52-dbfa-4d26-958e-5c74131f229a', 'c07292873e9c74aec0cd6d704fd0eb', '+2250787430925', '96815', '2025-05-16 18:18:12', '2025-05-16 18:20:22'), (75, '263fc9d0-6f50-4ea1-8b19-cb86a6b9cbc8', '4c5f864a0d19c0ce30b5bedfbcba3d', '+2250787430930', '30322', '2025-05-16 18:23:20', '2025-05-16 18:23:20'), (76, '8308438c-1563-4690-9072-a68b54a7ae0a', '1aa42426976c0580100a56592ce9e4', '+2250787430939', '26178', '2025-05-16 19:49:03', '2025-05-16 19:49:03'), (77, '683b7988-952b-4d81-9a75-683069cfd91e', '88f6c7a02caf22ac8cdfaa0c55f711', '+2250787430940', '51740', '2025-05-16 19:52:35', '2025-05-16 19:52:35'), (78, '43bfe982-41d3-4ce7-b3ba-47523349aed5', 'ff90fb3cb859871218f65412da38c7', '+2250777777777', '38859', '2025-05-19 02:24:55', '2025-05-19 02:24:55'); -- -- Index pour les tables déchargées -- -- -- Index pour la table `api_keys` -- ALTER TABLE `api_keys` ADD PRIMARY KEY (`id`); -- -- Index pour la table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Index pour la table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Index pour la table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Index pour la table `user_codes` -- ALTER TABLE `user_codes` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT pour les tables déchargées -- -- -- AUTO_INCREMENT pour la table `api_keys` -- ALTER TABLE `api_keys` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- 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 `user_codes` -- ALTER TABLE `user_codes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79; 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 */;