--
-- Host: localhost    Database: ceterisprime_messager
-- ------------------------------------------------------


--
-- Table structure for table `alerts`
--

CREATE TABLE `alerts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `severity` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`details`)),
  `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`context`)),
  `fingerprint` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `occurrence_count` int(11) NOT NULL DEFAULT 1,
  `auto_correctable` tinyint(1) NOT NULL DEFAULT 0,
  `correction_action` varchar(255) DEFAULT NULL,
  `correction_result` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`correction_result`)),
  `resolved_at` timestamp NULL DEFAULT NULL,
  `resolution_notes` text DEFAULT NULL,
  `last_occurrence_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `alerts_status_type_index` (`status`,`type`),
  KEY `alerts_status_auto_correctable_index` (`status`,`auto_correctable`),
  KEY `alerts_fingerprint_index` (`fingerprint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `alerts`
--


--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` VALUES
('ceteris-connect-messager-cache-illuminate:queue:restart','i:1773960481;',2089320481),
('messager-cache-illuminate:queue:restart','i:1773426028;',2088786028);

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache_locks`
--


--
-- Table structure for table `collector_executions`
--

CREATE TABLE `collector_executions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `collector_name` varchar(255) NOT NULL,
  `command` varchar(255) NOT NULL,
  `parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`parameters`)),
  `status` enum('running','success','failed') NOT NULL DEFAULT 'running',
  `exit_code` int(11) DEFAULT NULL,
  `output` text DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `duration` decimal(8,2) DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `collector_executions_status_index` (`status`),
  KEY `collector_executions_created_at_index` (`created_at`),
  KEY `collector_executions_collector_name_index` (`collector_name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `collector_executions`
--

INSERT INTO `collector_executions` VALUES
(1,'Fichiers BMP (FTP)','collect:bmp-files','{\"force\": false, \"limit\": 50, \"waveTo\": null, \"markRead\": false, \"bmpDateTo\": null, \"sinceType\": \"preset\", \"waveForce\": false, \"waveLimit\": null, \"waveSince\": null, \"periodCode\": null, \"bmpDateFrom\": null, \"sinceCustom\": null, \"sincePreset\": \"now\"}','success',0,'? Début de la collecte BMP...\r\n\r\n? Date de collecte: 2026-02-17 (aujourd\'hui)\r\n\r\n? Résultats de la collecte:\r\n\r\n  ❌ Sales Report:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *link_sales_report_20260217.csv\r\n\r\n  ❌ Credit Limit:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *credit_limit_log_20260217.csv\r\n\r\n  ❌ Subagents:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *subagents_20260217.csv\r\n\r\n? Résumé:\r\n+------------------+--------+\r\n| Métrique         | Valeur |\r\n+------------------+--------+\r\n| Fichiers traités | 3      |\r\n| Succès           | 0      |\r\n| Échecs           | 3      |\r\n| Taux de succès   | 0%     |\r\n+------------------+--------+\r\n\r\n⚠️  Fichiers en échec:\r\n   - sales: Aucun fichier trouvé\r\n   - credit: Aucun fichier trouvé\r\n   - subagents: Aucun fichier trouvé\r\n\r\n✅ Collecte BMP terminée\r\n',NULL,1.07,'2026-02-17 08:08:11','2026-02-17 08:08:12','2026-02-17 08:08:11','2026-02-17 08:08:12'),
(2,'Fichiers BMP (FTP)','collect:bmp-files','{\"force\": false, \"limit\": 50, \"waveTo\": null, \"markRead\": false, \"bmpDateTo\": null, \"sinceType\": \"preset\", \"waveForce\": false, \"waveLimit\": null, \"waveSince\": null, \"periodCode\": null, \"bmpDateFrom\": null, \"sinceCustom\": null, \"sincePreset\": \"now\"}','success',0,'? Début de la collecte BMP...\r\n\r\n? Date de collecte: 2026-02-17 (aujourd\'hui)\r\n\r\n? Résultats de la collecte:\r\n\r\n  ❌ Sales Report:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *link_sales_report_20260217.csv\r\n\r\n  ❌ Credit Limit:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *credit_limit_log_20260217.csv\r\n\r\n  ❌ Subagents:\r\n     Erreur: Aucun fichier trouvé\r\n     Pattern: *subagents_20260217.csv\r\n\r\n? Résumé:\r\n+------------------+--------+\r\n| Métrique         | Valeur |\r\n+------------------+--------+\r\n| Fichiers traités | 3      |\r\n| Succès           | 0      |\r\n| Échecs           | 3      |\r\n| Taux de succès   | 0%     |\r\n+------------------+--------+\r\n\r\n⚠️  Fichiers en échec:\r\n   - sales: Aucun fichier trouvé\r\n   - credit: Aucun fichier trouvé\r\n   - subagents: Aucun fichier trouvé\r\n\r\n✅ Collecte BMP terminée\r\n',NULL,0.64,'2026-02-17 08:08:45','2026-02-17 08:08:45','2026-02-17 08:08:45','2026-02-17 08:08:45'),
(3,'BMP via SPC API','collect:bmp-from-spc-v2','{\"force\": false, \"limit\": 50, \"waveTo\": null, \"markRead\": false, \"bmpDateTo\": \"2025-12-31\", \"sinceType\": \"preset\", \"waveForce\": false, \"waveLimit\": null, \"waveSince\": null, \"periodCode\": null, \"bmpDateFrom\": \"2025-12-01\", \"sinceCustom\": null, \"sincePreset\": \"now\"}','failed',NULL,NULL,'Période de collecte trop longue (31 jours). Utilisez --force pour forcer.',NULL,'2026-02-17 10:13:06','2026-02-17 10:13:19','2026-02-17 10:13:06','2026-02-17 10:13:19'),
(4,'Emails bancaires','collect:banking-emails-v2','{\"force\": false, \"limit\": 50, \"waveTo\": null, \"markRead\": false, \"bmpDateTo\": null, \"sinceType\": \"preset\", \"waveForce\": false, \"waveLimit\": null, \"waveSince\": null, \"periodCode\": null, \"bmpDateFrom\": null, \"sinceCustom\": null, \"sincePreset\": \"now\"}','success',0,'? Démarrage de la collecte BANK\r\n\r\n? Message de traçabilité créé (ID: 4)\r\n\r\n╔══════════════════════════════════════════════════════════════╗\r\n║  Collecte emails bancaires - compta@estair.travel           ║\r\n╚══════════════════════════════════════════════════════════════╝\r\n\r\n? Configuration:\r\n   • Depuis: 2026-02-22 13:30:06\r\n   • Limite: 50 emails\r\n   • Marquer comme lu: Non\r\n\r\n? Connexion à IMAP...\r\n✅ Connecté\r\n\r\nℹ️  Aucun email trouvé\r\n✅ Collecte terminée avec succès\r\n\r\n\r\n╔══════════════════════════════════════════════════════════════╗\r\n║  RÉSUMÉ DE LA COLLECTE EMAILS BANCAIRES                      ║\r\n╚══════════════════════════════════════════════════════════════╝\r\n   • Total emails: 0\r\n   • Traités: 0\r\n   • Succès: 0\r\n\r\n',NULL,8.32,'2026-02-22 13:29:59','2026-02-22 13:30:07','2026-02-22 13:29:59','2026-02-22 13:30:07'),
(5,'Transactions Wave','collect:wave-transactions-v2','{\"sinceType\":\"preset\",\"sincePreset\":\"now\",\"sinceCustom\":null,\"limit\":50,\"markRead\":false,\"force\":false,\"bmpDateFrom\":null,\"bmpDateTo\":null,\"periodCode\":null,\"waveSince\":\"2025-12-01T00:00\",\"waveTo\":\"2025-12-31T00:00\",\"waveLimit\":null,\"waveForce\":true}','failed',NULL,NULL,'No query results for model [App\\Models\\Domain].',NULL,'2026-03-20 02:54:55','2026-03-20 02:54:55','2026-03-20 02:54:55','2026-03-20 02:54:55'),
(6,'Transactions Wave','collect:wave-transactions-v2','{\"sinceType\":\"preset\",\"sincePreset\":\"now\",\"sinceCustom\":null,\"limit\":50,\"markRead\":false,\"force\":false,\"bmpDateFrom\":null,\"bmpDateTo\":null,\"periodCode\":null,\"waveSince\":\"2025-12-01T00:00\",\"waveTo\":\"2025-12-31T00:00\",\"waveLimit\":null,\"waveForce\":true}','failed',NULL,NULL,'No query results for model [App\\Models\\Domain].',NULL,'2026-03-20 02:55:57','2026-03-20 02:55:57','2026-03-20 02:55:57','2026-03-20 02:55:57'),
(7,'Transactions Wave','collect:wave-transactions-v2','{\"sinceType\":\"preset\",\"sincePreset\":\"now\",\"sinceCustom\":null,\"limit\":50,\"markRead\":false,\"force\":false,\"bmpDateFrom\":null,\"bmpDateTo\":null,\"periodCode\":null,\"waveSince\":\"2025-12-01T00:00\",\"waveTo\":\"2025-12-31T00:00\",\"waveLimit\":null,\"waveForce\":true}','failed',NULL,NULL,'No query results for model [App\\Models\\Domain].',NULL,'2026-03-20 03:05:34','2026-03-20 03:05:35','2026-03-20 03:05:34','2026-03-20 03:05:35');

--
-- Table structure for table `dlq_messages`
--

CREATE TABLE `dlq_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `original_message_id` bigint(20) unsigned NOT NULL,
  `domain_id` bigint(20) unsigned NOT NULL,
  `tenant_id` varchar(255) DEFAULT NULL,
  `queue_name` varchar(255) NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payload`)),
  `last_error_message` text NOT NULL,
  `last_error_code` varchar(50) DEFAULT NULL,
  `error_type` enum('temporary','permanent','unknown') NOT NULL DEFAULT 'unknown',
  `total_attempts` int(11) NOT NULL DEFAULT 0,
  `status` enum('pending','replayed','discarded') NOT NULL DEFAULT 'pending',
  `replayed_at` timestamp NULL DEFAULT NULL,
  `replayed_message_id` bigint(20) unsigned DEFAULT NULL,
  `moved_to_dlq_at` timestamp NOT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `dlq_messages_original_message_id_foreign` (`original_message_id`),
  KEY `dlq_messages_replayed_message_id_foreign` (`replayed_message_id`),
  KEY `dlq_messages_status_created_at_index` (`status`,`created_at`),
  KEY `dlq_messages_domain_id_status_index` (`domain_id`,`status`),
  KEY `dlq_messages_error_type_status_index` (`error_type`,`status`),
  KEY `dlq_messages_tenant_id_index` (`tenant_id`),
  CONSTRAINT `dlq_messages_domain_id_foreign` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dlq_messages_original_message_id_foreign` FOREIGN KEY (`original_message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `dlq_messages_replayed_message_id_foreign` FOREIGN KEY (`replayed_message_id`) REFERENCES `messages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `dlq_messages`
--


--
-- Table structure for table `domains`
--

CREATE TABLE `domains` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` varchar(255) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `environment` varchar(255) NOT NULL DEFAULT 'production',
  `webhook_url` varchar(500) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  `api_token` varchar(255) DEFAULT NULL,
  `max_retry_attempts` int(11) NOT NULL DEFAULT 3,
  `retry_delay_minutes` int(11) NOT NULL DEFAULT 5,
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`config`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `domains_is_active_index` (`is_active`),
  KEY `domains_tenant_id_index` (`tenant_id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `domains`
--

INSERT INTO `domains` VALUES
(1,NULL,'Amadeus GDS Operations (Dev)','amadeus','development','http://127.0.0.1:5100/api/v1/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,'{\"priority\": \"medium\", \"description\": \"Synchronisation continue des états de ventes via SPC\", \"sync_continuous\": true, \"batch_processing\": false}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(2,NULL,'Amadeus GDS Operations (Prod)','amadeus','production','http://127.0.0.1:5100/api/v1/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,'{\"priority\": \"medium\", \"description\": \"Synchronisation continue des états de ventes via SPC\", \"sync_continuous\": true, \"batch_processing\": false}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(3,NULL,'Banking Integration (Dev)','bancaire','development','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"critical\", \"countries\": [\"CI\", \"GN\", \"SN\", \"CV\"], \"providers\": [\"ecobank\", \"wave\", \"orange_money\"]}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(4,NULL,'Banking Integration (Prod)','bancaire','production','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"critical\", \"countries\": [\"CI\", \"GN\", \"SN\", \"CV\"], \"providers\": [\"ecobank\", \"wave\", \"orange_money\"]}',1,'2025-10-06 13:42:41','2025-10-27 18:43:41'),
(5,NULL,'BMP Data Collection (Dev)','bmp','development','http://127.0.0.1:8110/v1/messager/webhook/bmp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"high\", \"file_types\": [\"sales_report\", \"credit_limit\", \"subagents\"], \"daily_collection\": true}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(6,NULL,'BMP Data Collection (Prod)','bmp','production','http://127.0.0.1:8110/v1/messager/webhook/bmp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"high\", \"file_types\": [\"sales_report\", \"credit_limit\", \"subagents\"], \"daily_collection\": true}',1,'2025-10-06 13:57:03','2025-10-27 18:43:41'),
(7,NULL,'Estair Unified Gateway','estair','development','http://127.0.0.1:8110','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"routing\": \"dynamic\", \"category\": \"gateway\", \"description\": \"Point d\'entrée unique pour tous les messages Estair (SPC, BMP, BSP, RHC, etc.)\", \"subcategory\": \"estair\", \"accept_domains\": [\"spc_selling\", \"spc_appro\", \"spc_bmp\", \"spc_bsp\", \"spc_rhc\"]}',1,'2025-10-27 18:43:41','2025-11-21 10:36:59'),
(8,NULL,'Estair Backend API (Prod)','estair','production','http://127.0.0.1:8110','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,NULL,1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(9,NULL,'SPC Selling Platform Operations','spc_selling','development','http://127.0.0.1:5100/api/v1/selenium/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,1,'{\"queue\": \"spc_selling\", \"timeout\": 120, \"category\": \"selenium\", \"description\": \"Opérations Amadeus Selling Platform (PNR, tickets, etc.)\", \"subcategory\": \"selling\", \"dedupe_field\": \"execution_uuid\", \"max_attempts\": 3, \"retry_strategy\": \"exponential\", \"selenium_token\": \"spc_last_unified_HdK92mPzX7qYw3Lv5BnJt8Rf4Cg6Ua0S\", \"callback_domain\": \"messager_selling\", \"response_config\": {\"expected_fields\": [\"status\", \"data\"]}, \"response_handler\": \"json\", \"notify_on_failure\": true, \"selenium_endpoint\": \"http://localhost:5100/api/v1/selenium/execute\", \"retry_delay_minutes\": 2, \"dedupe_window_minutes\": 60, \"notification_channels\": [\"teams\", \"email\"]}',1,'2025-09-30 15:18:35','2025-11-21 18:42:35'),
(10,NULL,'SPC Selling Platform Operations','spc_selling','production','http://127.0.0.1:5100/api/v1/selenium/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,1,'{\"headers\": {\"Authorization\": \"Bearer estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1\"}, \"priority\": \"medium\", \"description\": \"Domaine pour synchronisation continue des états de ventes\", \"spc_auth_token\": \"estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1\", \"sync_continuous\": true, \"batch_processing\": false}',1,'2025-09-30 15:18:35','2025-10-03 20:51:13'),
(11,NULL,'Services Bancaires Estair (Dev)','estair_bancaire','development','http://localhost:8110/v1/messager/webhook/bank',NULL,'estair_bank_z12wCTXnRFsWBQWEZIfLQCdGluBo78ns',5,2,'{\"priority\": \"critical\", \"countries\": [\"CI\", \"GN\", \"SN\", \"CV\"], \"providers\": [\"ecobank\", \"wave\", \"orange_money\"], \"description\": \"Domaine pour emails Ecobank et callbacks Wave/Orange Money\", \"fifo_enabled\": true}',1,'2025-09-30 15:18:35','2025-10-03 15:39:33'),
(12,NULL,'Services Bancaires Estair (Prod)','estair_bancaire','production','http://localhost:8110/v1/messager/webhook/bank',NULL,'estair_bank_z12wCTXnRFsWBQWEZIfLQCdGluBo78ns',5,2,'{\"priority\": \"critical\", \"countries\": [\"CI\", \"GN\", \"SN\", \"CV\"], \"providers\": [\"ecobank\", \"wave\", \"orange_money\"], \"description\": \"Domaine pour emails Ecobank et callbacks Wave/Orange Money\", \"fifo_enabled\": true}',1,'2025-09-30 15:18:35','2025-10-03 15:39:33'),
(13,NULL,'BMP Data Collection Estair (Dev)','estair_bmp','development','http://127.0.0.1:8110/v1/messager/webhook/bmp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',5,2,'{\"priority\": \"high\", \"file_types\": [\"sales_report\", \"credit_limit\", \"subagents\"], \"description\": \"Domaine pour collecte quotidienne des fichiers BMP via FTP\", \"fifo_enabled\": true, \"daily_collection\": true, \"processing_order\": [\"sales\", \"credit\", \"subagents\"]}',1,'2025-09-30 19:37:18','2025-09-30 19:37:18'),
(14,NULL,'BMP Data Collection Estair (Prod)','estair_bmp','production','http://127.0.0.1:8110/v1/messager/webhook/bmp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',5,2,'{\"priority\": \"high\", \"file_types\": [\"sales_report\", \"credit_limit\", \"subagents\"], \"description\": \"Domaine pour collecte quotidienne des fichiers BMP via FTP\", \"fifo_enabled\": true, \"daily_collection\": true, \"processing_order\": [\"sales\", \"credit\", \"subagents\"]}',1,'2025-09-30 19:37:18','2025-09-30 19:37:18'),
(15,NULL,'Opérations Financières Estair','estair_financial','development','http://localhost:8110/v1/messager/webhook/financial',NULL,'estair_financial_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,'{\"queues\": [\"financial_mouvements\", \"financial_daily_credits\", \"financial_loads\", \"financial_cancellations\"], \"priority\": \"critical\", \"description\": \"Domaine pour les mouvements financiers (load, unload, daily_credit, cancel_credit)\", \"fifo_enabled\": true, \"mouvement_types\": [\"credit\", \"debit\", \"load\", \"unload\", \"daily_credit\", \"cancel_credit\"]}',1,'2025-10-22 18:51:37','2025-10-23 18:32:34'),
(16,NULL,'Opérations Financières Estair','estair_financial','production','http://localhost:8110/v1/messager/webhook/financial',NULL,'estair_financial_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,'{\"queues\": [\"financial_mouvements\", \"financial_daily_credits\", \"financial_loads\", \"financial_cancellations\"], \"priority\": \"critical\", \"description\": \"Domaine pour les mouvements financiers (load, unload, daily_credit, cancel_credit)\", \"fifo_enabled\": true, \"mouvement_types\": [\"credit\", \"debit\", \"load\", \"unload\", \"daily_credit\", \"cancel_credit\"]}',1,'2025-10-22 18:51:37','2025-10-23 18:32:34'),
(17,NULL,'Helpdesk Estair (Dev)','estair_helpdesk','development','http://localhost:8110/v1/messager/webhook/helpdesk',NULL,'estair_help_iHzZfT3ZjJ3h4gi8pfvRscic1BC5m21p',3,5,'{\"priority\": \"high\", \"description\": \"Domaine pour validation finance des requêtes clients\", \"approval_required\": true, \"manual_validation\": true}',1,'2025-09-30 15:18:35','2025-09-30 19:37:18'),
(18,NULL,'Helpdesk Estair (Prod)','estair_helpdesk','production','http://localhost:8110/v1/messager/webhook/helpdesk',NULL,'estair_help_iHzZfT3ZjJ3h4gi8pfvRscic1BC5m21p',3,5,'{\"priority\": \"high\", \"description\": \"Domaine pour validation finance des requêtes clients\", \"approval_required\": true, \"manual_validation\": true}',1,'2025-09-30 15:18:35','2025-09-30 19:37:18'),
(19,NULL,'Paiements Orange Money - Estair (Dev)','estair_orange','development','http://localhost:8110/v1/messager/webhook/bank',NULL,'dK6tZVkSl1wr1XgARy6nNDOLheM3aYXj',3,5,'{\"provider\": \"orange_money\", \"queue_name\": \"payment_orange\"}',1,'2025-10-08 16:23:58','2025-10-08 16:23:58'),
(20,NULL,'Paiements Orange Money - Estair (Prod)','estair_orange','production','http://localhost:8110/v1/messager/webhook/bank',NULL,'dK6tZVkSl1wr1XgARy6nNDOLheM3aYXj',3,5,'{\"provider\": \"orange_money\", \"queue_name\": \"payment_orange\"}',1,'2025-10-08 16:23:58','2025-10-08 16:23:58'),
(21,NULL,'Paiements Wave - Estair (Dev)','estair_wave','development','http://localhost:8110/v1/messager/webhook/bank',NULL,'dzzk1VJQlshPLv0nr9RrvOq2btpzej6T',3,5,'{\"provider\": \"wave\", \"queue_name\": \"payment_wave\"}',1,'2025-10-08 16:23:58','2025-10-08 16:23:58'),
(22,NULL,'Paiements Wave - Estair (Prod)','estair_wave','production','http://localhost:8110/v1/messager/webhook/bank',NULL,'dzzk1VJQlshPLv0nr9RrvOq2btpzej6T',3,5,'{\"provider\": \"wave\", \"queue_name\": \"payment_wave\"}',1,'2025-10-08 16:23:58','2025-10-08 16:23:58'),
(23,NULL,'Financial Mouvements (Dev)','financial','development','http://localhost:8110/v1/messager/webhook/financial','estair_dev_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','dom_dev_financial_Xw5Qm8Tn3Pk7Lt2Yh9Bj6Cd4Ua0Zs1Nr',3,5,'{\"queues\": [\"financial_mouvements\", \"financial_daily_credits\", \"financial_loads\", \"financial_cancellations\"], \"priority\": \"critical\", \"mouvement_types\": [\"credit\", \"debit\", \"load\", \"unload\", \"daily_credit\", \"cancel_credit\"]}',1,'2025-10-27 18:43:41','2025-10-27 19:17:31'),
(24,NULL,'Financial Mouvements (Prod)','financial','production','http://localhost:8110/v1/messager/webhook/financial','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','estair_financial_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,5,'{\"queues\": [\"financial_mouvements\", \"financial_daily_credits\", \"financial_loads\", \"financial_cancellations\"], \"priority\": \"critical\", \"mouvement_types\": [\"credit\", \"debit\", \"load\", \"unload\", \"daily_credit\", \"cancel_credit\"]}',1,'2025-10-27 18:43:41','2025-10-27 19:17:31'),
(25,NULL,'FTP Air Watcher (Dev)','ftp_air','development','http://127.0.0.1:8110/v1/messager/webhook/air','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,NULL,1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(26,NULL,'FTP Air Watcher (Prod)','ftp_air','production','http://127.0.0.1:8110/v1/messager/webhook/air','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,NULL,1,'2025-10-02 15:03:34','2025-10-27 18:43:41'),
(27,NULL,'Helpdesk Finance Validation (Dev)','helpdesk','development','http://127.0.0.1:8110/v1/messager/webhook/helpdesk','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"high\", \"approval_required\": true, \"manual_validation\": true}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(28,NULL,'Helpdesk Finance Validation (Prod)','helpdesk','production','http://127.0.0.1:8110/v1/messager/webhook/helpdesk','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"priority\": \"high\", \"approval_required\": true, \"manual_validation\": true}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(29,NULL,'IATA BSP Reports (Dev)','estair_bsp','development','http://127.0.0.1:8110/v1/messager/webhook/bsp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"notes\": [\"Le ZIP BSP contient 2 PDFs: BILLSUM et BILLDET\", \"Les 2 messages sont créés en séquence\"], \"source\": \"spc\", \"data_types\": [\"bsp_summary\", \"bsp_details\"], \"description\": \"Rapports IATA BSP collectés depuis SPC\"}',1,'2025-10-27 18:43:41','2025-10-27 19:17:31'),
(30,NULL,'IATA BSP Reports (Prod)','estair_bsp','production','http://127.0.0.1:8110/v1/messager/webhook/bsp','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"notes\": [\"Le ZIP BSP contient 2 PDFs: BILLSUM et BILLDET\", \"Les 2 messages sont créés en séquence\"], \"source\": \"spc\", \"data_types\": [\"bsp_summary\", \"bsp_details\"], \"description\": \"Rapports IATA BSP collectés depuis SPC\"}',1,'2025-10-27 18:43:41','2025-10-27 19:17:31'),
(31,NULL,'IATA RHC Reports (Dev)','estair_rhc','development','http://127.0.0.1:8110/v1/messager/webhook/rhc','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"source\": \"spc\", \"data_types\": [\"rhc_report\"], \"description\": \"Rapports IATA RHC collectés depuis SPC\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(32,NULL,'IATA RHC Reports (Prod)','estair_rhc','production','http://127.0.0.1:8110/v1/messager/webhook/rhc','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"source\": \"spc\", \"data_types\": [\"rhc_report\"], \"description\": \"Rapports IATA RHC collectés depuis SPC\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(33,NULL,'Orange Money Provider (Dev)','orange_money','development','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"provider\": \"orange_money\", \"queue_name\": \"payment_orange\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(34,NULL,'Orange Money Provider (Prod)','orange_money','production','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"provider\": \"orange_money\", \"queue_name\": \"payment_orange\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(35,NULL,'SPC Selenium API (Dev)','spc','development','http://127.0.0.1:5100',NULL,'spc_dev_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1Rs',3,2,NULL,1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(36,NULL,'SPC Selenium API (Prod)','spc','production','http://127.0.0.1:5100',NULL,'spc_prod_X8vTn5Qm2Yw9Hk6Bj7Cd4Ng3Ua0Zs1Lr',3,2,NULL,1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(37,NULL,'SPC BMP Collection (Dev)','spc_bmp','development','http://127.0.0.1:5100/api/v1/bmp/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-29 19:32:45'),
(38,NULL,'SPC BMP Collection (Prod)','spc_bmp','production','http://127.0.0.1:5100/api/v1/bmp/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(39,NULL,'SPC BSP Collection (Dev)','spc_bsp','development','http://127.0.0.1:5100/api/v1/bsp/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(40,NULL,'SPC BSP Collection (Prod)','spc_bsp','production','http://127.0.0.1:5100/api/v1/bsp/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(41,NULL,'SPC RHC Collection (Dev)','spc_rhc','development','http://127.0.0.1:5100/api/v1/rhc/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(42,NULL,'SPC RHC Collection (Prod)','spc_rhc','production','http://127.0.0.1:5100/api/v1/rhc/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(43,NULL,'SPC Callback to Estair (Dev)','spc_webhook','development','http://127.0.0.1:8110/v1/messager/webhook/spc','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(44,NULL,'SPC Callback to Estair (Prod)','spc_webhook','production','http://127.0.0.1:8110/v1/messager/webhook/spc','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,2,NULL,1,'2025-10-27 19:17:31','2025-10-27 19:17:31'),
(45,NULL,'Wave Payment Provider (Dev)','wave','development','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"provider\": \"wave\", \"queue_name\": \"payment_wave\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(46,NULL,'Wave Payment Provider (Prod)','wave','production','http://127.0.0.1:8110/v1/messager/webhook/bank','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"provider\": \"wave\", \"queue_name\": \"payment_wave\"}',1,'2025-10-27 18:43:41','2025-10-27 18:43:41'),
(49,NULL,'Messager BMP Webhook (Dev)','messager_bmp','development','http://localhost:8112/api/v1/bmp/webhook',NULL,'msg_bmp_dev_e03b2be266a4586f3890ac3434014234',3,2,NULL,1,'2025-10-29 18:26:21','2025-10-29 18:26:21'),
(50,NULL,'Messager BMP Webhook (Prod)','messager_bmp','production','http://localhost:8112/api/v1/bmp/webhook',NULL,'msg_bmp_prod_36cdb19e25f5da0e004482da0204921f',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(51,NULL,'Messager BSP Webhook (Dev)','messager_bsp','development','http://localhost:8112/api/v1/bsp/webhook',NULL,'msg_bsp_dev_c7f76288358c9713f60c89cb985e5d35',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(52,NULL,'Messager BSP Webhook (Prod)','messager_bsp','production','http://localhost:8112/api/v1/bsp/webhook',NULL,'msg_bsp_prod_66abbf3e764860a20d0cb31f72340873',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(53,NULL,'Messager RHC Webhook (Dev)','messager_rhc','development','http://localhost:8112/api/v1/rhc/webhook',NULL,'msg_rhc_dev_3a05338aba384836da718b3f11383e57',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(54,NULL,'Messager RHC Webhook (Prod)','messager_rhc','production','http://localhost:8112/api/v1/rhc/webhook',NULL,'msg_rhc_prod_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(55,NULL,'Amadeus BMP Approvisionnement','spc_appro','development','http://127.0.0.1:5100/api/v1/appro/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,5,'{\"queue\": \"spc_appro\", \"source\": \"estair\", \"priority\": \"critical\", \"webhooks\": {\"estair\": {\"url\": \"/api/messager/webhook/appro\", \"method\": \"POST\", \"timeout\": 120, \"description\": \"Webhook pour notifier Estair du résultat d\'appro BMP\"}}, \"description\": \"Domaine pour l\'approvisionnement BMP via SPC (TRÈS HAUTE PRIORITÉ)\", \"spc_endpoint\": \"http://localhost:5100/api/v1/appro/execute\", \"retry_strategy\": {\"max_attempts\": 3, \"timeout_seconds\": 120, \"behavior_on_failure\": \"mark_as_failed_no_callback\"}}',1,'2025-11-17 11:00:31','2025-11-19 13:02:53'),
(56,NULL,'Amadeus BMP Approvisionnement','spc_appro','production','http://127.0.0.1:5100/api/v1/appro/execute',NULL,'estair_spc_M9pXq4vBn7ZkLt2Yw8HjFr3Cd6Ng5Ua1',3,5,'{\"queue\": \"spc_appro\", \"source\": \"estair\", \"priority\": \"critical\", \"webhooks\": {\"estair\": {\"url\": \"/api/messager/webhook/appro\", \"method\": \"POST\", \"timeout\": 120, \"description\": \"Webhook pour notifier Estair du résultat d\'appro BMP\"}}, \"description\": \"Domaine pour l\'approvisionnement BMP via SPC (TRÈS HAUTE PRIORITÉ)\", \"spc_endpoint\": \"http://localhost:3002/api/v1/appro/execute\", \"retry_strategy\": {\"max_attempts\": 3, \"timeout_seconds\": 120, \"behavior_on_failure\": \"mark_as_failed_no_callback\"}}',1,'2025-11-17 11:00:31','2025-11-19 13:02:53'),
(57,NULL,'Messager Appro Webhook (Dev)','messager_appro','development','http://localhost:8112/api/v1/appro/webhook',NULL,'msg_appro_dev_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(58,NULL,'Messager Appro Webhook (Prod)','messager_appro','production','http://localhost:8112/api/v1/appro/webhook',NULL,'msg_appro_prod_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(59,NULL,'Estair BMP Approvisionnement','estair_appro','development','http://localhost:8110/v1/messager/webhook/appro','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"queue\": \"bmp_appro\", \"source\": \"estair\", \"priority\": \"critical\", \"webhooks\": {\"estair\": {\"url\": \"/api/messager/webhook/appro\", \"method\": \"POST\", \"timeout\": 120, \"description\": \"Webhook pour notifier Estair du résultat d\'appro BMP\"}}, \"description\": \"Domaine pour l\'approvisionnement BMP via SPC (TRÈS HAUTE PRIORITÉ)\", \"spc_endpoint\": \"http://localhost:5100/api/v1/appro/execute\", \"retry_strategy\": {\"max_attempts\": 3, \"timeout_seconds\": 120, \"behavior_on_failure\": \"mark_as_failed_no_callback\"}}',1,'2025-11-18 14:35:01','2025-11-18 14:35:01'),
(60,NULL,'Estair BMP Approvisionnement','estair_appro','production','http://localhost:8110/v1/messager/webhook/appro','estair_messager_K7p9Qx3Wn2Vm5Lt8Yh6Bj4Cd1Ng0Ua9Zs','lw2Xz6Hfiip0iond498BbHT5OrHHSQ_za4l1EbH53p9-p5AT9K_1H-lRIRBwN5R77VSlUWKJIGq6hTkFo4I_Tg',3,5,'{\"queue\": \"bmp_appro\", \"source\": \"estair\", \"priority\": \"critical\", \"webhooks\": {\"estair\": {\"url\": \"/api/messager/webhook/appro\", \"method\": \"POST\", \"timeout\": 120, \"description\": \"Webhook pour notifier Estair du résultat d\'appro BMP\"}}, \"description\": \"Domaine pour l\'approvisionnement BMP via SPC (TRÈS HAUTE PRIORITÉ)\", \"spc_endpoint\": \"http://localhost:5100/api/v1/appro/execute\", \"retry_strategy\": {\"max_attempts\": 3, \"timeout_seconds\": 120, \"behavior_on_failure\": \"mark_as_failed_no_callback\"}}',1,'2025-11-18 14:35:01','2025-11-18 14:35:01'),
(62,NULL,'Messager Selling Callback','messager_selling','development','http://localhost:8112/api/v1/selling/webhook',NULL,'messager_selling_Trhu18pNgiX8sBpzlBDq7uyr6yIrZE0v',3,5,'{\"queue\": \"messager_selling\", \"category\": \"callback\", \"description\": \"Callback des résultats Selenium Selling vers Estair\", \"subcategory\": \"selling\", \"max_attempts\": 3, \"target_domain\": \"estair_selling\", \"retry_delay_minutes\": 1}',1,'2025-11-21 10:03:04','2025-11-21 18:42:35'),
(63,NULL,'Estair Selling Webhook (Dev)','estair_selling','development','http://localhost:8110/v1/messager/webhook/selling',NULL,'estair_selling_TEeoZAk1GHsCaXl6Yvisq8AWd17iBFIV',3,5,'{\"queue\": \"estair_selling\", \"category\": \"webhook\", \"description\": \"Réception des résultats Selling dans Estair\", \"subcategory\": \"selling\", \"max_attempts\": 3, \"retry_delay_minutes\": 1}',1,'2025-11-21 10:03:04','2025-11-21 18:42:35'),
(64,NULL,'Estair Selling Webhook (Prod)','estair_selling','production','http://localhost:8110/v1/messager/webhook/selling',NULL,'estair_selling_TEeoZAk1GHsCaXl6Yvisq8AWd17iBFIV',3,5,'{\"queue\": \"estair_selling\", \"category\": \"webhook\", \"description\": \"Réception des résultats Selling dans Estair\", \"subcategory\": \"selling\", \"max_attempts\": 3, \"retry_delay_minutes\": 1}',1,'2025-11-21 10:03:04','2025-11-21 18:42:35'),
(65,NULL,'Messager Wave Webhook (Dev)','messager_wave','development','http://localhost:8112/api/v1/wave/webhook',NULL,'msg_wave_dev_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(66,NULL,'Messager Wave Webhook (Prod)','messager_wave','production','http://localhost:8112/api/v1/wave/webhook',NULL,'msg_wave_prod_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(67,NULL,'Messager Bank Webhook (Dev)','messager_bank','development','http://localhost:8112/api/v1/bank/webhook',NULL,'msg_bank_dev_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22'),
(68,NULL,'Messager Bank Webhook (Prod)','messager_bank','production','http://localhost:8112/api/v1/bank/webhook',NULL,'msg_bank_prod_124c654193e7875517efa82914b69f9e',3,2,NULL,1,'2025-10-29 18:26:22','2025-10-29 18:26:22');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `message_executions`
--

CREATE TABLE `message_executions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message_id` bigint(20) unsigned NOT NULL,
  `attempt` int(11) NOT NULL,
  `started_at` timestamp NOT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `execution_time_ms` int(11) DEFAULT NULL,
  `context` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`context`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `message_executions_message_id_attempt_index` (`message_id`,`attempt`),
  KEY `message_executions_started_at_index` (`started_at`),
  CONSTRAINT `message_executions_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `message_executions`
--

INSERT INTO `message_executions` VALUES
(1,1,1,'2026-02-17 10:13:47','2026-02-17 10:13:57',NULL,10471,'{\"queue\": \"bmp_daily_collection\", \"job_id\": 1, \"bmp_lock_acquired\": false}','2026-02-17 10:13:47','2026-02-17 10:13:57'),
(2,2,1,'2026-02-17 10:13:57','2026-02-17 10:13:58',NULL,836,'{\"queue\": \"bmp_daily_collection\", \"job_id\": 2, \"bmp_lock_acquired\": false}','2026-02-17 10:13:57','2026-02-17 10:13:58'),
(3,3,1,'2026-02-17 10:13:58','2026-02-17 10:14:00',NULL,1627,'{\"queue\": \"bmp_daily_collection\", \"job_id\": 3, \"bmp_lock_acquired\": false}','2026-02-17 10:13:58','2026-02-17 10:14:00'),
(4,6,1,'2026-02-23 15:04:21','2026-02-23 15:04:37',NULL,15480,'{\"queue\": \"payment_wave\", \"job_id\": 4, \"bmp_lock_acquired\": false}','2026-02-23 15:04:21','2026-02-23 15:04:37');

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `domain_id` bigint(20) unsigned NOT NULL,
  `tenant_id` varchar(255) DEFAULT NULL,
  `mouvement_id` varchar(255) DEFAULT NULL,
  `queue_name` varchar(255) NOT NULL DEFAULT 'default',
  `message_id` varchar(255) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `sequence_group` varchar(255) DEFAULT NULL,
  `sequence_order` int(11) NOT NULL DEFAULT 0,
  `previous_message_id` bigint(20) unsigned DEFAULT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payload`)),
  `status` enum('pending','dispatched','processing','completed','failed','cancelled') DEFAULT 'pending',
  `attempts` int(11) NOT NULL DEFAULT 0,
  `max_attempts` int(11) NOT NULL DEFAULT 3,
  `scheduled_at` timestamp NULL DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `completed_at` timestamp NULL DEFAULT NULL,
  `failed_at` timestamp NULL DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `processing_time_ms` int(11) DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_unique_domain_mouvement` (`domain_id`,`mouvement_id`),
  KEY `messages_status_scheduled_at_index` (`status`,`scheduled_at`),
  KEY `messages_domain_id_sequence_group_sequence_order_index` (`domain_id`,`sequence_group`,`sequence_order`),
  KEY `messages_previous_message_id_index` (`previous_message_id`),
  KEY `messages_created_at_index` (`created_at`),
  KEY `messages_failed_at_index` (`failed_at`),
  KEY `messages_tenant_id_index` (`tenant_id`),
  KEY `messages_message_id_index` (`message_id`),
  CONSTRAINT `messages_domain_id_foreign` FOREIGN KEY (`domain_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE,
  CONSTRAINT `messages_previous_message_id_foreign` FOREIGN KEY (`previous_message_id`) REFERENCES `messages` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` VALUES
(1,13,NULL,NULL,'bmp_daily_collection',NULL,NULL,NULL,0,NULL,'{\"type\": \"bmp_sales\", \"source\": \"ftp_bmp\", \"file_data\": {\"size\": 17203, \"filename\": \"584138_link_sales_report_20251031.csv\", \"folder_id\": 4, \"nb_elements\": 20, \"content_base64\": \"[encoded data, 22940 characters]\"}, \"processed_at\": \"2026-02-17T10:13:43.563582Z\", \"collection_date\": \"2025-10-31T00:00:00.000000Z\"}','completed',0,3,NULL,'2026-02-17 10:13:47','2026-02-17 10:13:57',NULL,NULL,10471,NULL,'2026-02-17 10:13:43','2026-02-17 10:13:57',NULL),
(2,13,NULL,NULL,'bmp_daily_collection',NULL,NULL,NULL,0,NULL,'{\"type\": \"bmp_credit\", \"source\": \"ftp_bmp\", \"file_data\": {\"size\": 15105, \"filename\": \"584136_credit_limit_log_20251031.csv\", \"folder_id\": 20, \"nb_elements\": 94, \"content_base64\": \"[encoded data, 20140 characters]\"}, \"processed_at\": \"2026-02-17T10:13:45.178498Z\", \"collection_date\": \"2025-10-31T00:00:00.000000Z\"}','completed',0,3,NULL,'2026-02-17 10:13:57','2026-02-17 10:13:58',NULL,NULL,836,NULL,'2026-02-17 10:13:45','2026-02-17 10:13:58',NULL),
(3,13,NULL,NULL,'bmp_daily_collection',NULL,NULL,NULL,0,NULL,'{\"type\": \"bmp_subagents\", \"source\": \"ftp_bmp\", \"file_data\": {\"size\": 38174, \"filename\": \"584140_subagents_20251031.csv\", \"folder_id\": 3, \"nb_elements\": 291, \"content_base64\": \"[encoded data, 50900 characters]\"}, \"processed_at\": \"2026-02-17T10:13:45.445610Z\", \"collection_date\": \"2025-10-31T00:00:00.000000Z\"}','completed',0,3,NULL,'2026-02-17 10:13:58','2026-02-17 10:14:00',NULL,NULL,1627,NULL,'2026-02-17 10:13:45','2026-02-17 10:14:00',NULL),
(4,67,NULL,NULL,'messager_bank',NULL,NULL,'collect_banking_email_20260222133006',0,NULL,'{\"type\": \"collection_request\", \"source\": \"banking_email\", \"trigger\": \"web\", \"parameters\": {\"limit\": 50, \"since\": \"2026-02-22T13:30:06.748734Z\", \"mark_as_read\": false}, \"collection_started_at\": \"2026-02-22T13:30:06.752860Z\"}','completed',0,3,NULL,NULL,'2026-02-22 13:30:07',NULL,NULL,NULL,NULL,'2026-02-22 13:30:06','2026-02-22 13:30:07',NULL),
(5,65,NULL,NULL,'messager_wave',NULL,NULL,'collect_wave_20260223150407',0,NULL,'{\"type\": \"collection_request\", \"source\": \"wave\", \"trigger\": \"cron\", \"parameters\": {\"to\": null, \"limit\": null, \"since\": null}, \"collection_started_at\": \"2026-02-23T15:04:07.552662Z\"}','completed',0,3,NULL,NULL,'2026-02-23 15:04:14',NULL,NULL,NULL,NULL,'2026-02-23 15:04:07','2026-02-23 15:04:14',NULL),
(6,21,NULL,NULL,'payment_wave',NULL,NULL,NULL,0,NULL,'{\"type\": \"payment_wave_retrieve\", \"source\": \"wave_retrieve\", \"provider\": \"wave\", \"raw_transaction\": {\"fee\": \"909\", \"amount\": \"89991\", \"balance\": \"89991\", \"currency\": \"XOF\", \"timestamp\": \"2026-02-23T09:21:13Z\", \"transaction_id\": \"T_ZSMC7WQJ3Z24YIR5\", \"transaction_type\": \"merchant_payment\", \"counterparty_name\": \"Ake A L M\", \"counterparty_mobile\": \"+2250768071289\"}, \"transaction_data\": {\"fee\": \"909\", \"status\": \"completed\", \"amount_net\": \"89991\", \"amount_total\": 90900, \"sender_mobile\": \"+2250768071289\", \"account_number\": \"WAVE CI\", \"transaction_id\": \"T_ZSMC7WQJ3Z24YIR5\", \"transaction_date\": \"2026-02-23T09:21:13Z\", \"transaction_type\": \"merchant_payment\", \"counterparty_mobile\": \"+2250768071289\", \"is_agent_transaction\": false}}','completed',0,3,'2026-02-23 15:04:17','2026-02-23 15:04:21','2026-02-23 15:04:37',NULL,NULL,15480,NULL,'2026-02-23 15:04:12','2026-02-23 15:04:37',NULL);

--
-- Table structure for table `migrations`
--

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES
(1,'0001_01_01_000000_create_users_table',1),
(2,'0001_01_01_000001_create_cache_table',1),
(3,'0001_01_01_000002_create_jobs_table',1),
(4,'2025_08_22_211229_create_domains_table',1),
(5,'2025_08_22_211248_create_messages_table',1),
(6,'2025_08_22_211545_create_message_executions_table',1),
(7,'2025_10_05_201140_create_processing_logs_table',1),
(8,'2025_10_06_165032_add_api_key_to_domains_table',1),
(9,'2025_10_27_184110_add_environment_to_domains_table',2),
(10,'2025_11_21_090016_add_mouvement_id_to_messages_table',3),
(11,'2025_11_25_193653_create_collector_executions_table',4),
(12,'2026_01_15_123514_change_scheduled_at_default_to_null_in_messages_table',5),
(13,'2026_02_20_120000_add_dispatched_status_to_messages_table',6),
(14,'2026_02_22_150000_create_alerts_table',6),
(15,'2026_02_23_000001_create_dlq_messages_table',7),
(16,'2026_02_23_000002_add_tenant_id_to_messages_and_domains',7);

--
-- Table structure for table `password_reset_tokens`
--

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

--
-- Dumping data for table `password_reset_tokens`
--


--
-- Table structure for table `processing_logs`
--

CREATE TABLE `processing_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `message_id` bigint(20) unsigned DEFAULT NULL,
  `source_type` varchar(50) NOT NULL,
  `source_identifier` varchar(255) DEFAULT NULL,
  `target_system` varchar(50) NOT NULL DEFAULT 'estair',
  `target_endpoint` varchar(255) DEFAULT NULL,
  `data_type` varchar(50) NOT NULL,
  `line_number` int(11) DEFAULT NULL COMMENT 'Pour fichiers CSV/multi-lignes',
  `raw_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Données source originales' CHECK (json_valid(`raw_data`)),
  `status` enum('pending','processing','success','failed','skipped') NOT NULL DEFAULT 'pending',
  `target_table` varchar(50) DEFAULT NULL COMMENT 'Table cible si connu',
  `target_record_id` bigint(20) unsigned DEFAULT NULL COMMENT 'ID enregistrement créé',
  `response_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Réponse du système cible' CHECK (json_valid(`response_data`)),
  `error_message` text DEFAULT NULL,
  `error_code` varchar(50) DEFAULT NULL,
  `error_type` enum('temporary','permanent','unknown') DEFAULT NULL,
  `retry_count` int(11) NOT NULL DEFAULT 0,
  `max_retries` int(11) NOT NULL DEFAULT 3,
  `last_retry_at` timestamp NULL DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Données additionnelles (domain, queue, etc.)' CHECK (json_valid(`metadata`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `processing_logs_source_type_status_index` (`source_type`,`status`),
  KEY `processing_logs_target_system_status_index` (`target_system`,`status`),
  KEY `processing_logs_data_type_status_index` (`data_type`,`status`),
  KEY `processing_logs_status_retry_count_index` (`status`,`retry_count`),
  KEY `processing_logs_created_at_status_index` (`created_at`,`status`),
  KEY `processing_logs_message_id_status_index` (`message_id`,`status`),
  KEY `processing_logs_source_type_index` (`source_type`),
  KEY `processing_logs_target_system_index` (`target_system`),
  KEY `processing_logs_data_type_index` (`data_type`),
  KEY `processing_logs_status_index` (`status`),
  KEY `processing_logs_error_code_index` (`error_code`),
  CONSTRAINT `processing_logs_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `processing_logs`
--

INSERT INTO `processing_logs` VALUES
(1,1,'ftp_bmp','584138_link_sales_report_20251031.csv','estair',NULL,'bmp_sales',NULL,'{\"pattern\": \"*link_sales_report_20251031.csv\", \"filename\": \"584138_link_sales_report_20251031.csv\", \"file_size\": 17203, \"local_path\": \"C:\\\\Dev\\\\ceteris-connect-poc\\\\connect\\\\application\\\\messager\\\\storage\\\\app/bmp/584138_link_sales_report_20251031.csv\", \"nb_elements\": 20, \"remote_path\": \"/20251031/attached/584138_link_sales_report_20251031.csv\"}','success','messages',1,'{\"filename\": \"584138_link_sales_report_20251031.csv\", \"file_size\": 17203, \"nb_elements\": 20}',NULL,NULL,NULL,0,3,NULL,'2026-02-17 10:13:44',NULL,'2026-02-17 10:13:43','2026-02-17 10:13:44'),
(2,2,'ftp_bmp','584136_credit_limit_log_20251031.csv','estair',NULL,'bmp_credit',NULL,'{\"pattern\": \"*credit_limit_log_20251031.csv\", \"filename\": \"584136_credit_limit_log_20251031.csv\", \"file_size\": 15105, \"local_path\": \"C:\\\\Dev\\\\ceteris-connect-poc\\\\connect\\\\application\\\\messager\\\\storage\\\\app/bmp/584136_credit_limit_log_20251031.csv\", \"nb_elements\": 94, \"remote_path\": \"/20251031/attached/584136_credit_limit_log_20251031.csv\"}','success','messages',2,'{\"filename\": \"584136_credit_limit_log_20251031.csv\", \"file_size\": 15105, \"nb_elements\": 94}',NULL,NULL,NULL,0,3,NULL,'2026-02-17 10:13:45',NULL,'2026-02-17 10:13:45','2026-02-17 10:13:45'),
(3,3,'ftp_bmp','584140_subagents_20251031.csv','estair',NULL,'bmp_subagents',NULL,'{\"pattern\": \"*subagents_20251031.csv\", \"filename\": \"584140_subagents_20251031.csv\", \"file_size\": 38174, \"local_path\": \"C:\\\\Dev\\\\ceteris-connect-poc\\\\connect\\\\application\\\\messager\\\\storage\\\\app/bmp/584140_subagents_20251031.csv\", \"nb_elements\": 291, \"remote_path\": \"/20251031/attached/584140_subagents_20251031.csv\"}','success','messages',3,'{\"filename\": \"584140_subagents_20251031.csv\", \"file_size\": 38174, \"nb_elements\": 291}',NULL,NULL,NULL,0,3,NULL,'2026-02-17 10:13:45',NULL,'2026-02-17 10:13:45','2026-02-17 10:13:45'),
(4,6,'wave_retrieve','T_ZSMC7WQJ3Z24YIR5','estair',NULL,'payment_wave',NULL,NULL,'pending',NULL,NULL,NULL,NULL,NULL,NULL,0,3,NULL,NULL,NULL,'2026-02-23 15:04:12','2026-02-23 15:04:12');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` VALUES
('4CuRTDhFvDBss3msTZg8kOJM4qt29lsyxnz0KwHn',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoibUZSRk83eFNtRWlrakFZMW9lM3hHcGFVbjhiRk56VHZvY2JvcHNaUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAxMi9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1771768420),
('8EwcVyebHB0kAYck73WwvpVRVMcD9dfMR15Cfv0o',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTo4OntzOjY6Il90b2tlbiI7czo0MDoiZVFIamIwTHZ0TXYxVTFrZ0c3VDNzaGpZWjRxMlVkQzVkNGlSN3cxTSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAxMi9kYXNoYm9hcmQvY29sbGVjdG9ycy9oaXN0b3J5IjtzOjU6InJvdXRlIjtzOjI4OiJkYXNoYm9hcmQuY29sbGVjdG9ycy5oaXN0b3J5Ijt9czo4OiJzc29fdXNlciI7YTozOntzOjc6InN1Y2Nlc3MiO2I6MTtzOjc6Im1lc3NhZ2UiO3M6MTI6IlVzZXIgZGV0YWlscyI7czo0OiJkYXRhIjthOjExOntzOjQ6InV1aWQiO3M6MzY6ImE4NjBjYTAwLWZmNjktNDIzOS1hZjM1LWVjY2M3YTA5ZGQ4MiI7czo5OiJmaXJzdG5hbWUiO3M6OToiTmljZXBob3JlIjtzOjg6Imxhc3RuYW1lIjtzOjc6IkFMTEFHTE8iO3M6ODoiZnVsbG5hbWUiO3M6MTc6Ik5pY2VwaG9yZSBBTExBR0xPIjtzOjU6InBob25lIjtzOjI3OiJuaWNlcGhvcmUuYWxsYWdsb0BnbWFpbC5jb20iO3M6NToiZW1haWwiO3M6Mjc6Im5pY2VwaG9yZS5hbGxhZ2xvQGdtYWlsLmNvbSI7czo5OiJiaXJ0aGRhdGUiO3M6MDoiIjtzOjE3OiJwbGFjZV9vZl9iaXJ0aGRheSI7czowOiIiO3M6NDoiY2l0eSI7czowOiIiO3M6NzoiYWRkcmVzcyI7czowOiIiO3M6MTA6Im9jY3VwYXRpb24iO3M6MDoiIjt9fXM6OToic3NvX3Rva2VuIjtzOjE0ODI6ImV5SmhiR2NpT2lKU1V6STFOaUlzSW5SNWNDSWdPaUFpU2xkVUlpd2lhMmxrSWlBNklDSlhiVTgwYjFOTFNHZEtiSEpUYjBsS1VqQjFUMlpxUzB4RGFESjZaamRGTldoTU5YZExhR1p4U0RCM0luMC5leUpsZUhBaU9qRTNOekU0TmpFME1UWXNJbWxoZENJNk1UYzNNVGcxT1RZeE5pd2lhblJwSWpvaU1ESm1NMlEzWkdZdE1UUm1ZUzAwTW1ZeExXSmtOamN0T1RobU1UWXlNVFF4TmpFeUlpd2lhWE56SWpvaWFIUjBjSE02THk5clpYbGpiRzloYXk1aGJHTjViMjR0Y0dGeWRHNWxjbk11WTI5dEwzSmxZV3h0Y3k5alpYUmxjbWx6SWl3aVlYVmtJam9pWVdOamIzVnVkQ0lzSW5OMVlpSTZJbUU0TmpCallUQXdMV1ptTmprdE5ESXpPUzFoWmpNMUxXVmpZMk0zWVRBNVpHUTRNaUlzSW5SNWNDSTZJa0psWVhKbGNpSXNJbUY2Y0NJNkltTnZibTVsWTNRaUxDSnpaWE56YVc5dVgzTjBZWFJsSWpvaVkyTXdOemd4TmpNdE9HRXdaaTAwT1RCakxXRmhPRGN0TTJSak4yUXdNV0prTVdSaklpd2lZV055SWpvaU1TSXNJbUZzYkc5M1pXUXRiM0pwWjJsdWN5STZXeUl2S2lKZExDSnlaV0ZzYlY5aFkyTmxjM01pT25zaWNtOXNaWE1pT2xzaWIyWm1iR2x1WlY5aFkyTmxjM01pTENKMWJXRmZZWFYwYUc5eWFYcGhkR2x2YmlJc0ltUmxabUYxYkhRdGNtOXNaWE10WTJWMFpYSnBjeUpkZlN3aWNtVnpiM1Z5WTJWZllXTmpaWE56SWpwN0ltRmpZMjkxYm5RaU9uc2ljbTlzWlhNaU9sc2liV0Z1WVdkbExXRmpZMjkxYm5RaUxDSnRZVzVoWjJVdFlXTmpiM1Z1ZEMxc2FXNXJjeUlzSW5acFpYY3RjSEp2Wm1sc1pTSmRmWDBzSW5OamIzQmxJam9pYjNCbGJtbGtJSEJ5YjJacGJHVWdaVzFoYVd3aUxDSnphV1FpT2lKall6QTNPREUyTXkwNFlUQm1MVFE1TUdNdFlXRTROeTB6WkdNM1pEQXhZbVF4WkdNaUxDSmxiV0ZwYkY5MlpYSnBabWxsWkNJNmRISjFaU3dpYm1GdFpTSTZJazVwWTJWd2FHOXlaU0JCVEV4QlIweFBJaXdpY0hKbFptVnljbVZrWDNWelpYSnVZVzFsSWpvaWJtbGpaWEJvYjNKbExtRnNiR0ZuYkc5QVoyMWhhV3d1WTI5dElpd2laMmwyWlc1ZmJtRnRaU0k2SWs1cFkyVndhRzl5WlNJc0ltWmhiV2xzZVY5dVlXMWxJam9pUVV4TVFVZE1UeUlzSW1WdFlXbHNJam9pYm1salpYQm9iM0psTG1Gc2JHRm5iRzlBWjIxaGFXd3VZMjl0SW4wLlRJQ0NxaEIwN29FbXIzNE5qMUtXTXFGS0hvckNfbnlIdGp1OTkxWmVYVVpMSlJjcEl1bEhZVkF1eGJZNFAxTHhQT283WlhUODFXemFmYmQxeHBHMDlhZENpUG1reWRUMVRVVUhiaUs3SDFFWlhlbmt2ZDVVU0RtaHVtLW9ZbUNRRzZuY0JDNHdtMGdGYThBLWQ2MzZDLWtXekZXVGtxRXV6WjhRZ01wWmdtNFFHZGNVazlKM25pbGExMHpxbVdScDdGclllWmFZSGVXNFc1cGI2Q3VKV09DWThpdmVxd2RPRlVOd3pOVG9VM3MyM20zQTFlU1BSUm4tWERuRG9MaTI1QklYMkM2T0JpRy1MWExrYTlNcnliMW5VNzNYMmhvVmVsU2lCWFV5OF9IYW5yalpPaUItVkR3LXNzZjl3bGVKX3VVZF9SSHZKMmlkWkpWZ3p3UDZjdyI7czo5OiJzc29fc2V0dXAiO3M6MTQ6ImVzdGFpcl9jb25uZWN0IjtzOjE0OiJzc29fZXhwaXJlc19hdCI7TzoyNToiSWxsdW1pbmF0ZVxTdXBwb3J0XENhcmJvbiI6Mzp7czo0OiJkYXRlIjtzOjI2OiIyMDI2LTAzLTI1IDE1OjIwOjM5LjY2MTE0NiI7czoxMzoidGltZXpvbmVfdHlwZSI7aTozO3M6ODoidGltZXpvbmUiO3M6MzoiVVRDIjt9czoxMjoic3NvX3JlbWVtYmVyIjtiOjE7fQ==',1771860039),
('brBBUksPBPfCP0w0UW42XinOH5IHd9LdqVjT1gvc',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTo3OntzOjY6Il90b2tlbiI7czo0MDoiRHJ1bVROMFJzNTRCbGxhVGZIVGpLOEtiemR3WXltVjN0bmZwa0JHQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTA6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAxMi9kYXNoYm9hcmQvY29sbGVjdG9ycy9oaXN0b3J5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo4OiJzc29fdXNlciI7YTozOntzOjc6InN1Y2Nlc3MiO2I6MTtzOjc6Im1lc3NhZ2UiO3M6MTI6IlVzZXIgZGV0YWlscyI7czo0OiJkYXRhIjthOjExOntzOjQ6InV1aWQiO3M6MzY6ImE4NjBjYTAwLWZmNjktNDIzOS1hZjM1LWVjY2M3YTA5ZGQ4MiI7czo5OiJmaXJzdG5hbWUiO3M6OToiTmljZXBob3JlIjtzOjg6Imxhc3RuYW1lIjtzOjc6IkFMTEFHTE8iO3M6ODoiZnVsbG5hbWUiO3M6MTc6Ik5pY2VwaG9yZSBBTExBR0xPIjtzOjU6InBob25lIjtzOjI3OiJuaWNlcGhvcmUuYWxsYWdsb0BnbWFpbC5jb20iO3M6NToiZW1haWwiO3M6Mjc6Im5pY2VwaG9yZS5hbGxhZ2xvQGdtYWlsLmNvbSI7czo5OiJiaXJ0aGRhdGUiO3M6MDoiIjtzOjE3OiJwbGFjZV9vZl9iaXJ0aGRheSI7czowOiIiO3M6NDoiY2l0eSI7czowOiIiO3M6NzoiYWRkcmVzcyI7czowOiIiO3M6MTA6Im9jY3VwYXRpb24iO3M6MDoiIjt9fXM6OToic3NvX3Rva2VuIjtzOjE0ODI6ImV5SmhiR2NpT2lKU1V6STFOaUlzSW5SNWNDSWdPaUFpU2xkVUlpd2lhMmxrSWlBNklDSlhiVTgwYjFOTFNHZEtiSEpUYjBsS1VqQjFUMlpxUzB4RGFESjZaamRGTldoTU5YZExhR1p4U0RCM0luMC5leUpsZUhBaU9qRTNOekUzTmprd05EQXNJbWxoZENJNk1UYzNNVGMyTnpJME1Dd2lhblJwSWpvaVlqaGpZelZpTXpRdE1XSmhZUzAwTnpGa0xUa3haR1V0Tm1Fd09UTmpPRFF6Tm1FMElpd2lhWE56SWpvaWFIUjBjSE02THk5clpYbGpiRzloYXk1aGJHTjViMjR0Y0dGeWRHNWxjbk11WTI5dEwzSmxZV3h0Y3k5alpYUmxjbWx6SWl3aVlYVmtJam9pWVdOamIzVnVkQ0lzSW5OMVlpSTZJbUU0TmpCallUQXdMV1ptTmprdE5ESXpPUzFoWmpNMUxXVmpZMk0zWVRBNVpHUTRNaUlzSW5SNWNDSTZJa0psWVhKbGNpSXNJbUY2Y0NJNkltTnZibTVsWTNRaUxDSnpaWE56YVc5dVgzTjBZWFJsSWpvaU1EbGtNV1kyWmpFdE16WTBPUzAwWW1Nd0xUZ3hPRE10WXpnelpHWTBNekEwWTJGbElpd2lZV055SWpvaU1TSXNJbUZzYkc5M1pXUXRiM0pwWjJsdWN5STZXeUl2S2lKZExDSnlaV0ZzYlY5aFkyTmxjM01pT25zaWNtOXNaWE1pT2xzaWIyWm1iR2x1WlY5aFkyTmxjM01pTENKMWJXRmZZWFYwYUc5eWFYcGhkR2x2YmlJc0ltUmxabUYxYkhRdGNtOXNaWE10WTJWMFpYSnBjeUpkZlN3aWNtVnpiM1Z5WTJWZllXTmpaWE56SWpwN0ltRmpZMjkxYm5RaU9uc2ljbTlzWlhNaU9sc2liV0Z1WVdkbExXRmpZMjkxYm5RaUxDSnRZVzVoWjJVdFlXTmpiM1Z1ZEMxc2FXNXJjeUlzSW5acFpYY3RjSEp2Wm1sc1pTSmRmWDBzSW5OamIzQmxJam9pYjNCbGJtbGtJSEJ5YjJacGJHVWdaVzFoYVd3aUxDSnphV1FpT2lJd09XUXhaalptTVMwek5qUTVMVFJpWXpBdE9ERTRNeTFqT0ROa1pqUXpNRFJqWVdVaUxDSmxiV0ZwYkY5MlpYSnBabWxsWkNJNmRISjFaU3dpYm1GdFpTSTZJazVwWTJWd2FHOXlaU0JCVEV4QlIweFBJaXdpY0hKbFptVnljbVZrWDNWelpYSnVZVzFsSWpvaWJtbGpaWEJvYjNKbExtRnNiR0ZuYkc5QVoyMWhhV3d1WTI5dElpd2laMmwyWlc1ZmJtRnRaU0k2SWs1cFkyVndhRzl5WlNJc0ltWmhiV2xzZVY5dVlXMWxJam9pUVV4TVFVZE1UeUlzSW1WdFlXbHNJam9pYm1salpYQm9iM0psTG1Gc2JHRm5iRzlBWjIxaGFXd3VZMjl0SW4wLmJ1RVpTQkxiekJScWlqMU1OZWFYOElCbjBmY3lpaVJGalVfeFFaRGNxRWdpTEh2SlEyWjhIbTdCczFRMU5JdVpfQURmTnFEbGZKNmphbUFSSTZwdUh6QXVuV2c2WG9fSVFNNEZLN254MkkyWlRwbjRlbGNsNHphU3MzR3pTd1BEVEd5d2NHVmRNQWJPUWI2TnNQeEJHc2NuRTZycjNndkQxUm9YOENfWmtnZE1oNmItb1pnbGFIWE9CdG00bC03anY5ZGl6bGlPaWx0Vzc4QzhoYVBzUW5odGlCc1ZWT3NlVmxYb1FxWmU4VmV6bG93VUdEaFBaakFDd29XbUdlbk1FRDBod0YyaGFfQ3lTNzVGd1NKT2lMdWxhYnh2SFIyNWN2azlrWmxxN1pjaE5QMzlwUW51bUw5R0ZZMFB5SjVhZkZpa1R5YldLc2pmMGlMNENHc3RJUSI7czo5OiJzc29fc2V0dXAiO3M6MTQ6ImVzdGFpcl9jb25uZWN0IjtzOjE0OiJzc29fZXhwaXJlc19hdCI7TzoyNToiSWxsdW1pbmF0ZVxTdXBwb3J0XENhcmJvbiI6Mzp7czo0OiJkYXRlIjtzOjI2OiIyMDI2LTAyLTIyIDIxOjQ5OjE5LjUxODU0NyI7czoxMzoidGltZXpvbmVfdHlwZSI7aTozO3M6ODoidGltZXpvbmUiO3M6MzoiVVRDIjt9fQ==',1771768159),
('cilP6WwvpO8PAiBTkqFOkFBuVfptdOZSpqctKXZt',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiM3pzMUVXc2FLNzNwcWVPUFg1ZGdoeXRNRWtoVEFpWnZqTnZIaFdYeCI7czo1OiJlcnJvciI7czoyMzoiVmV1aWxsZXogdm91cyBjb25uZWN0ZXIiO3M6NjoiX2ZsYXNoIjthOjI6e3M6MzoibmV3IjthOjA6e31zOjM6Im9sZCI7YToxOntpOjA7czo1OiJlcnJvciI7fX1zOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czozMToiaHR0cDovL2xvY2FsaG9zdDo4MDEyL2Rhc2hib2FyZCI7czo1OiJyb3V0ZSI7czoxNToiZGFzaGJvYXJkLmluZGV4Ijt9fQ==',1771859884),
('Kw2Ysci5ge3OOHqINAza9YD0C2rRO0BoonTSsXBQ',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoib0Q1VlVXMVFGbDdoYmhXNFFBOW5udkRHRkhuYU5CV2h2Ylp6TVBuNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAxMi9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1771766895),
('lddJ9MwamHDS3W93AIlcsaFohEMbds4nXHnoxQUa',NULL,'::1','curl/7.61.1','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTHpIUDNGYVliOUR1dFZLbjFhbnpIejVLTWRjQVkxcmdzeTlCbHE1cyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODExMiI7czo1OiJyb3V0ZSI7czoyNzoiZ2VuZXJhdGVkOjp1MFBod1U4NmlKc0t6Y3VLIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1773446994),
('MUAit70G7Zzut43ZlLx357WyGpExTYGqzktx1t1p',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiekpUZzdLdHhvY0FjYmNCOUZMMUlIZEwySVlwTkd1SXNaUFRNQmpvRCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAxMi9sb2dpbiI7czo1OiJyb3V0ZSI7czo1OiJsb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1771859884),
('ocdTSH6XaPZNTtpmtIELaK5hDH1VaPu0FXwSOceb',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:147.0) Gecko/20100101 Firefox/147.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZHNOeGtnbnFrYVNZNVhkVTNGU3ZBb25VdkE4RTR2d0RZUmlhUTZiaCI7czo1OiJlcnJvciI7czoyMzoiVmV1aWxsZXogdm91cyBjb25uZWN0ZXIiO3M6NjoiX2ZsYXNoIjthOjI6e3M6MzoibmV3IjthOjA6e31zOjM6Im9sZCI7YToxOntpOjA7czo1OiJlcnJvciI7fX1zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0MjoiaHR0cDovL2xvY2FsaG9zdDo4MDEyL2Rhc2hib2FyZC9jb2xsZWN0b3JzIjt9fQ==',1771768419);

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES
(1,'Admin','admin@messager.local',NULL,'$2y$12$p2RKqlHEsgOOxUk6nny1aeVrFM5aWsQ.2hogYRipuRHcp3v6l1x52','IYBfwiHW7UM9PZkXoH2icNyM4hnPgaNYid8nwlyVTp64q7SwLhEFSEQtUukH','2025-10-02 15:52:16','2025-10-02 15:52:16');


