
--
-- Table structure for table `revoked_tokens`
--

CREATE TABLE `revoked_tokens` (
  `jti` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` datetime NOT NULL,
  `revoked_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`jti`),
  KEY `idx_expires` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `revoked_tokens`
--


--
-- Table structure for table `security_logs`
--

CREATE TABLE `security_logs` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `severity` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `additional_data` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_event_type` (`event_type`),
  KEY `idx_severity` (`severity`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_ip_address` (`ip_address`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `security_logs`
--


--
-- Table structure for table `support_messages`
--

CREATE TABLE `support_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('bug','feature','general','content','technical','account') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general',
  `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `resolved_by` int DEFAULT NULL,
  `resolved_at` timestamp NULL DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('pending','in_progress','resolved','closed') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `priority` enum('low','medium','high','urgent') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser_info` json DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_type` (`type`),
  KEY `idx_status` (`status`),
  KEY `idx_priority` (`priority`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_status_priority` (`status`,`priority`),
  KEY `idx_type_status` (`type`,`status`),
  CONSTRAINT `support_messages_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `support_messages`
--

INSERT INTO `support_messages` VALUES (1,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','account','sqdvssdv','dsqvsfvsfbdgnfsh,fsgdbfvdqwcgbvnfg ,b ,nbvsdx',NULL,NULL,NULL,'bruno@taaazzz.be','pending','medium','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Mobile Safari/537.36','https://faildaily.com/tabs/profile','{\"language\": \"fr-FR\", \"platform\": \"Win32\", \"timestamp\": \"2026-02-12T20:11:06.326Z\", \"userAgent\": \"Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Mobile Safari/537.36\", \"cookieEnabled\": true}','2026-02-12 20:11:07','2026-02-12 20:11:07'),(2,NULL,'general','On test l\'envois de mail','estc-e que ça envois?',NULL,NULL,NULL,'contact@taaazzz-prog.fr','pending','medium','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','https://faildaily.com/tabs/profile','{\"language\": \"fr-FR\", \"platform\": \"Win32\", \"timestamp\": \"2026-03-04T12:24:43.841Z\", \"userAgent\": \"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36\", \"cookieEnabled\": true}','2026-03-04 12:24:45','2026-03-04 12:24:45');

--
-- Table structure for table `system_logs`
--

CREATE TABLE `system_logs` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `level` enum('info','warning','error','debug') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `system_logs_user_id_fkey` (`user_id`),
  CONSTRAINT `system_logs_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `system_logs`
--


--
-- Table structure for table `user_active_tokens`
--

CREATE TABLE `user_active_tokens` (
  `jti` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `platform` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_seen_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `expires_at` timestamp NOT NULL,
  PRIMARY KEY (`jti`),
  KEY `idx_uat_user` (`user_id`),
  KEY `idx_uat_expires` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_active_tokens`
--


--
-- Table structure for table `user_activities`
--

CREATE TABLE `user_activities` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `action` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reaction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_activities_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_activities`
--

INSERT INTO `user_activities` VALUES ('00a1c0b2-a006-4de9-8613-3f9426483752','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 00:36:01','2026-03-01 00:36:01'),('01f7d369-a099-43a2-9c51-ac610bca6532','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','1fec5d2e-a663-4acf-b47e-2893d4015bb9','courage','10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Mobile Safari/537.36','2026-02-12 19:46:24','2026-02-12 19:46:24'),('040518aa-a5e8-4ea6-8bde-b626b5a4d59a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 09:38:13','2026-03-06 09:38:13'),('05ab49ab-2ff5-4052-b11b-e5fa599db64a','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'176.149.158.195','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Safari/605.1.15','2026-03-05 06:58:44','2026-03-05 06:58:44'),('071f856a-52c1-4a9d-a5ec-cfcc6878eedf','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 12:33:19','2026-03-01 12:33:19'),('0906f9df-afbe-410e-a6a8-9fc89ffee43c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-02 19:27:42','2026-03-02 19:27:42'),('0d063b80-8521-41db-a4d3-19a99f3e87aa','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 08:04:03','2026-03-06 08:04:03'),('0f16236f-cfd9-47d1-a6f6-5722bf3610a0','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-09 19:13:26','2026-03-09 19:13:26'),('10ab880e-b480-4441-887b-37e5e0c733dc','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','register','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-02-28 23:16:38','2026-02-28 23:16:38'),('11b580a7-09ce-4beb-9e6f-a1827750dad2','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr','axel','login','{\"email\":\"axel@axel.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 16:36:46','2026-03-05 16:36:46'),('12a0571f-6da3-4e45-9d7b-17005c8af475','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-08 10:16:26','2026-03-08 10:16:26'),('1c021f41-3b0e-4af7-9b3c-f65a4a316968','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-21 18:14:47','2026-03-21 18:14:47'),('1dd29c65-19e5-43ad-8b3c-1be6b2a608bc','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:54:37','2026-03-05 20:54:37'),('1e0edd7f-5578-47f8-8970-fe1f5e0955e6','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','2026-03-21 10:28:54','2026-03-21 10:28:54'),('22d64b21-3a5d-45b0-9a40-42d7f6c32c9a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-08 10:18:21','2026-03-08 10:18:21'),('232d1182-351c-4a78-b481-69ba6592d544','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-02-28 23:17:13','2026-02-28 23:17:13'),('25c4d0d5-c68d-4d89-b616-30c91e52e992','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','9a5fb071-276c-4376-8204-e0644076f929','courage','10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-13 13:21:25','2026-02-13 13:21:25'),('2abdcd0a-a0cd-4772-95dd-353755086f0e','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"laugh\"}','9bd88682-128d-4f18-a8eb-056a9a017ada','laugh','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:08:08','2026-03-05 20:08:08'),('2c6a32d2-8321-466e-a339-558eb9642f19','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','0a2392bb-6832-4862-826b-5a566945902d','courage','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 15:52:02','2026-03-06 15:52:02'),('2da60889-874c-4b44-a7b3-2f1a9b35ae09','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-02-28 23:43:17','2026-02-28 23:43:17'),('2e9070b6-cf43-4c4d-82d9-6252aa8d0566','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-03 19:31:06','2026-03-03 19:31:06'),('30a9328f-2403-470c-b89f-db5a3dec9fe2','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-11 15:56:05','2026-03-11 15:56:05'),('30e539ad-c9ca-4f5d-aaa6-655106114546','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-04 20:37:40','2026-03-04 20:37:40'),('315b6d9b-386f-4d6e-9836-1d6f4f36166c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','2026-03-20 11:40:35','2026-03-20 11:40:35'),('37c2ee73-23fe-4d62-97c3-1e24d594b785','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','2e33947a-1978-4fb2-a5be-2bcd5f170f3b','empathy','10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-13 13:21:16','2026-02-13 13:21:16'),('3a854a94-64f1-404f-b29b-a753ba627891','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-07 09:41:02','2026-03-07 09:41:02'),('3ac00508-4942-44ef-85ed-8cf02407df06','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-02 16:44:05','2026-03-02 16:44:05'),('3b3f6fa0-1f06-4186-8a35-2993105a869c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','45cf117f-d5df-43b3-9831-5eb0683695b6','courage','172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 12:42:10','2026-03-01 12:42:10'),('3be9ac74-dbe4-41d3-979b-ccb2c33dbfaa','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-08 18:26:08','2026-03-08 18:26:08'),('3dcda1bb-dc5e-41e8-a3f3-4228c2457bfe','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"support\"}','07d9f0d9-e1ba-4e30-9ff4-b1ed72c26311','support','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-07 07:50:26','2026-03-07 07:50:26'),('3e47261e-c839-40f8-b795-9f2806d0290b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'79.91.177.111','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-08 14:10:19','2026-03-08 14:10:19'),('3e6cdba4-1c88-46b0-a3d5-bcffdddfeb48','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 00:56:53','2026-03-01 00:56:53'),('404bd733-937e-4fb6-a8c4-28fe3d96096c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-19 11:02:08','2026-03-19 11:02:08'),('40ec297e-d9d7-46a6-93a7-3ec1d7c3d68d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-20 16:51:47','2026-03-20 16:51:47'),('40fff6d1-9e3f-42e2-a4f4-2358bccde0ed','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-07 00:25:55','2026-03-07 00:25:55'),('421f5b82-dee4-4505-8b75-59230d7bb583','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"courage\"}','e6036d03-8064-42c2-ae56-14e4d5c21e5e','courage','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:08:04','2026-03-05 20:08:04'),('42b0f6f0-202b-4d02-9010-3c8a09cd7cff','9f4d32d6-743f-4a4d-a220-92416afaae63','creaalyas@gmail.com','Alice','login','{\"email\":\"creaalyas@gmail.com\"}',NULL,NULL,'88.177.207.79','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 09:51:49','2026-03-04 09:51:49'),('42d865c4-c745-49ff-b794-e3d7d55a7ea8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-12 16:01:14','2026-03-12 16:01:14'),('43ced981-f75d-4634-941c-ccc44ce9ddd4','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-07 10:25:29','2026-03-07 10:25:29'),('4513c11b-9632-41fa-9529-ce3dbabcadbb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-08 10:19:56','2026-03-08 10:19:56'),('4c5584ee-d339-463b-8c9e-9ef91a8c9a09','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 11:40:41','2026-03-01 11:40:41'),('4d3f353b-d7f2-4b6c-a9c3-ff9ca8f24afb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','e6036d03-8064-42c2-ae56-14e4d5c21e5e','courage','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 15:52:14','2026-03-06 15:52:14'),('4eeb63c5-f011-445f-828e-cdf5da2c884a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','cc3f5775-6b10-4036-9fdb-de7158976890','laugh','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-02 21:27:45','2026-03-02 21:27:45'),('5033eebe-664d-436f-a7e9-998147eae7f9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 16; SM-S921B Build/BP2A.250605.031.A3; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/146.0.7680.119 Mobile Safari/537.36','2026-03-20 20:47:07','2026-03-20 20:47:07'),('53aa5b82-43cf-40c4-9e88-4ebb16d344cb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-07 11:12:29','2026-03-07 11:12:29'),('5435366a-22ed-4eb7-9a51-03e4525e4b7e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-21 11:39:03','2026-03-21 11:39:03'),('546a0279-73a4-4a72-9a9f-72f94fcf7d86','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 16; SM-S921B Build/BP2A.250605.031.A3; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/146.0.7680.119 Mobile Safari/537.36','2026-03-20 19:48:31','2026-03-20 19:48:31'),('54a3feeb-0264-4b14-b53d-6b66a116883b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-18 18:12:35','2026-03-18 18:12:35'),('551c1855-b4e5-4be2-af9b-fc8828d9f725','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 00:35:26','2026-03-01 00:35:26'),('56f1cf24-5df8-44c7-a4d3-dbc16d4fd21e','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-03 16:47:09','2026-03-03 16:47:09'),('5b17a11c-a29e-4e5b-893c-6aa7b1154ef1','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"laugh\"}','b2d52b3c-eec8-4d38-b57f-68f771127341','laugh','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/17.5 Mobile/15A5370a Safari/602.1','2026-03-05 20:07:20','2026-03-05 20:07:20'),('5bdb5233-92b1-4c59-8c4a-33d0ca869bc8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-05 09:05:31','2026-03-05 09:05:31'),('5c1c30f6-64a4-4a3c-bf8a-c64401043695','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','0a2392bb-6832-4862-826b-5a566945902d','laugh','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 10:05:59','2026-03-04 10:05:59'),('5c2693c8-8ad7-451d-96bb-725d9c080b12','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 11:32:26','2026-03-01 11:32:26'),('5d90d87e-d791-4612-92b8-2eaac28478a5','7e523f2d-f01b-4e5a-b74c-02dd6e521453','reviewer@faildaily.com','TestUser','register','{\"email\":\"reviewer@faildaily.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-19 22:57:57','2026-03-19 22:57:57'),('5d97082c-869d-4f75-98f8-f10ae9d384c7','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-08 09:41:25','2026-03-08 09:41:25'),('5e8081a7-a93f-42ce-82cb-3252610b5271','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','8768b9dd-80b2-4948-b741-73b3abd1ccb7','support','10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-13 13:21:14','2026-02-13 13:21:14'),('5fb2f979-f1f8-4e3a-84f4-074d63822ce3','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','45cf117f-d5df-43b3-9831-5eb0683695b6','support','172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 13:05:09','2026-03-01 13:05:09'),('619cf63c-d1bf-4d1b-a829-81678b0f31ff','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-20 21:25:38','2026-03-20 21:25:38'),('6327d319-2849-4525-aaed-12bcf9620d55','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-02 16:18:11','2026-03-02 16:18:11'),('65044d0f-6e80-43d4-9b6b-50ff6b9f0971','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 10:07:28','2026-03-01 10:07:28'),('65de588e-83ff-4875-95e0-b5f00e64a592','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','0a2392bb-6832-4862-826b-5a566945902d','empathy','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 15:52:04','2026-03-06 15:52:04'),('68831edc-243b-4b7f-a362-39a76f474453','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Android 15; Mobile; rv:148.0) Gecko/148.0 Firefox/148.0','2026-03-20 13:49:15','2026-03-20 13:49:15'),('6a7b36c5-66d7-4878-b60c-71f01a8fdef5','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 16; SM-S921B Build/BP2A.250605.031.A3; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/146.0.7680.119 Mobile Safari/537.36','2026-03-20 21:21:42','2026-03-20 21:21:42'),('6aada464-7391-4ae1-bb65-e0e015f40edd','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-02-27 12:55:48','2026-02-27 12:55:48'),('6c6d4a84-99ee-4236-b6ea-4e3a9400d174','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr','axel','register','{\"email\":\"axel@axel.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 16:35:37','2026-03-05 16:35:37'),('6d33107e-2fec-4566-906a-7f7a3d98fbe6','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-08 09:42:00','2026-03-08 09:42:00'),('6d7671f8-933d-4a39-8c1a-1000399621d4','3afe8920-f82f-4362-8b69-d1aa204e1043','did.breit@hotmail.fr','Deider BREIT','register','{\"email\":\"did.breit@hotmail.fr\"}',NULL,NULL,'92.184.118.60','Mozilla/5.0 (Linux; Android 13; V2053 Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.104 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/549.0.0.61.62;IABMV/1;]','2026-03-08 14:15:14','2026-03-08 14:15:14'),('6db29922-9ca3-44cb-b091-b4f9d31d63b8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 12:29:20','2026-03-01 12:29:20'),('6f9ad17e-8057-445d-b052-b97aa163b19b','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-01 17:17:02','2026-03-01 17:17:02'),('77531f73-d983-4d63-be56-0893808f0053','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','0a2392bb-6832-4862-826b-5a566945902d','laugh','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 15:52:05','2026-03-06 15:52:05'),('79944f16-e9b0-4df4-9ff9-160bb8d602b5','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-12 19:56:19','2026-03-12 19:56:19'),('7d92414e-d07b-4c89-954a-02f549da82d3','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','d6107343-83e8-4eb1-ac47-a763b0fdca69','laugh','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-07 11:13:05','2026-03-07 11:13:05'),('8269a4b8-6ec9-4023-8fb0-0760fd31b86c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-08 17:21:11','2026-03-08 17:21:11'),('830b460b-0afe-4ed3-bceb-c544b0f32b4e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-18 16:47:56','2026-03-18 16:47:56'),('83c5e006-9019-49e6-bf13-273b177c8e63','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-07 07:46:51','2026-03-07 07:46:51'),('8411bee4-a037-4025-9285-439554362d03','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"laugh\"}','0a2392bb-6832-4862-826b-5a566945902d','laugh','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-04 10:37:27','2026-03-04 10:37:27'),('8ec9d093-1a4f-4586-a8b4-e64bd888071a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-09 19:13:54','2026-03-09 19:13:54'),('8efebb9c-4b15-464d-a1b2-bce5b097d6f7','c9538cf4-6cc2-4040-9e6c-45fa4c886616','contact@taaazzz-prog.fr','Nóttulfr','register','{\"email\":\"contact@taaazzz-prog.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 12:14:47','2026-03-04 12:14:47'),('9392603b-8f59-4921-ba91-57a8133fd568','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-06 20:57:54','2026-03-06 20:57:54'),('93c27bb5-52cd-43e6-a25e-4687d7a2bc7d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 10:05:54','2026-03-04 10:05:54'),('9422fd93-73ac-4c83-9702-c203d645934e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-02 22:13:13','2026-03-02 22:13:13'),('9513baa4-f652-4585-8479-92069a7fca95','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-02 17:07:23','2026-03-02 17:07:23'),('96b54ad3-95f7-45ec-a323-48c199d8213d','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"empathy\"}','8768b9dd-80b2-4948-b741-73b3abd1ccb7','empathy','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:07:55','2026-03-05 20:07:55'),('98d434d0-37fa-4eac-9e7f-240a78700124','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 19:21:32','2026-03-06 19:21:32'),('9aeab350-95fb-45b5-ab13-e4cc604c7ceb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-02-28 23:15:21','2026-02-28 23:15:21'),('9b56a706-a95e-436a-bec0-39fb4fb7721d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 17:49:44','2026-03-05 17:49:44'),('9c5d12d7-52e2-4c6f-9537-67d53075f60e','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-02-28 23:45:39','2026-02-28 23:45:39'),('a25d243a-26fc-4529-8873-263714151c1b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-17 16:13:19','2026-02-17 16:13:19'),('a34715b9-68ce-4b1a-8b1d-7599e03f7a10','0182cd19-331b-4b48-9ef6-7d30b5801a09','contact@taaazzz-prog.fr','Nóttulfr','register','{\"email\":\"contact@taaazzz-prog.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 20:33:55','2026-03-04 20:33:55'),('a399c993-7cb8-4811-b3eb-7db406700a51','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"empathy\"}','0a2392bb-6832-4862-826b-5a566945902d','empathy','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-04 10:37:40','2026-03-04 10:37:40'),('a3d07a6b-1470-4c8c-bd77-4f45ca187272','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'176.149.158.195','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Safari/605.1.15','2026-03-06 07:05:52','2026-03-06 07:05:52'),('a3df076c-4eca-44c6-99bb-8159108673ec','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-13 13:21:03','2026-02-13 13:21:03'),('a5b31b1d-ed9c-44a3-bc75-82fef35facca','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 19:12:57','2026-03-06 19:12:57'),('a5db638a-1c13-4457-b5cd-f773cdda3c08','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'79.91.177.67','Mozilla/5.0 (Linux; Android 16; SM-S921B Build/BP2A.250605.031.A3; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.79 Mobile Safari/537.36 [LinkedInApp]/2.248.64','2026-03-03 21:52:22','2026-03-03 21:52:22'),('a6a0c2c4-f63c-4df6-9d96-7ed5dde932e9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 10:48:26','2026-03-01 10:48:26'),('a7426658-d5f4-4dc4-992f-9757da34fbb9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-15 21:58:09','2026-02-15 21:58:09'),('a7b46770-e923-4d06-8f62-8faacbe793f7','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-09 12:16:49','2026-03-09 12:16:49'),('a9181013-73d8-4e25-87f4-53f129839a08','fd1c5842-0d44-4a33-83e6-42a896ead6e6','axel@axel.fr','axel','register','{\"email\":\"axel@axel.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 16:08:31','2026-03-05 16:08:31'),('a95b1dd4-2199-4aaa-ad0c-629ead928072','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-06 19:13:08','2026-03-06 19:13:08'),('ad116cfa-23f7-4d03-9274-ddae2796f529','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','2026-03-23 17:36:56','2026-03-23 17:36:56'),('ad5f2250-52bd-441f-bf7a-422a0ab9f59b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-18 20:59:37','2026-03-18 20:59:37'),('b01a5095-34ad-4565-8475-f7bbc363ea25','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','login','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-03 19:05:24','2026-03-03 19:05:24'),('b5deea11-a448-4cfc-92d8-17ed0b978f90','0182cd19-331b-4b48-9ef6-7d30b5801a09','contact@taaazzz-prog.fr','Nóttulfr','login','{\"email\":\"contact@taaazzz-prog.fr\"}',NULL,NULL,'128.79.24.162','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-28 20:01:38','2026-03-28 20:01:38'),('b659e733-0027-4cd6-9b67-006c39d4b979','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr','Alexia','register','{\"email\":\"aferney@live.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 26_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/23D127 Safari/604.1 [FBAN/FBIOS;FBAV/550.0.0.34.65;FBBV/890804754;FBDV/iPhone14,5;FBMD/iPhone;FBSN/iOS;FBSV/26.3;FBSS/3;FBID/phone;FBLC/fr_FR;FBOP/5;FBRV/894424164;IABMV/1]','2026-03-03 18:38:41','2026-03-03 18:38:41'),('b6832fc7-d1a0-43f8-a1e1-0295b59c4ca8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-01 18:36:16','2026-03-01 18:36:16'),('b68a738d-4850-4b48-ae63-66cfe66b6a12','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"empathy\"}','0a2392bb-6832-4862-826b-5a566945902d','empathy','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-04 10:37:35','2026-03-04 10:37:35'),('b7d10f99-4272-41ca-b661-8dec2e9a81f2','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 00:14:43','2026-03-01 00:14:43'),('bd186aa4-394d-44e0-a9db-7658222a2922','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','courage','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-09 19:13:51','2026-03-09 19:13:51'),('be4a8f46-5572-4c7e-984c-b18a7129677a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 11:39:31','2026-03-01 11:39:31'),('bed2e350-0279-44fa-9a69-a2d152649be3','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-08 10:18:50','2026-03-08 10:18:50'),('c30d9c8c-fa62-4ea6-9722-93e6aa4fcc2d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','d864bc7b-ae86-4ac1-92ac-9626b20906b0','laugh','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-09 19:14:10','2026-03-09 19:14:10'),('c359f731-04c8-4017-bcc8-86289db9c856','0182cd19-331b-4b48-9ef6-7d30b5801a09','contact@taaazzz-prog.fr','Nóttulfr','login','{\"email\":\"contact@taaazzz-prog.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','2026-03-20 11:41:24','2026-03-20 11:41:24'),('c9c070d4-23d2-4872-96bd-db66b1c6bd23','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-02 21:56:27','2026-03-02 21:56:27'),('cf6fc036-a831-40e5-844d-5c9abfd9462a','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"laugh\"}','0a2392bb-6832-4862-826b-5a566945902d','laugh','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-04 10:37:41','2026-03-04 10:37:41'),('db17b35f-9dd0-4c88-b37b-91d9121277aa','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','74877628-c353-45ef-bd7e-49b18dcf12d9','laugh','172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 12:50:23','2026-03-01 12:50:23'),('de8c95b8-1423-499b-a381-b6f50aa4b7f2','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"support\"}','b453999e-523a-4ccc-b83b-cc7f41b6994a','support','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:08:19','2026-03-05 20:08:19'),('dfc38733-9053-4ae6-b27b-f81d998b7a36','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','0ddb35d9-ae10-4a96-a3ba-645c25910019','laugh','10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36','2026-02-13 13:21:22','2026-02-13 13:21:22'),('e1b1ab00-b309-4a9f-bc59-62e853c67e00','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 18:18:30','2026-03-05 18:18:30'),('e77a2c77-64d3-4bb4-b5da-cbd093a8a2a2','846ccd15-b408-4bea-8089-085f28fc05bd','gunsjacques@gmail.com','Jack','register','{\"email\":\"gunsjacques@gmail.com\"}',NULL,NULL,'14.1.65.190','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.4 Safari/605.1.15','2026-03-12 13:27:21','2026-03-12 13:27:21'),('e814382a-f38d-431d-8221-27fccc621a9d','2cdfe08e-b1e3-405a-b11a-7a0921f1cf52','florian.blanchet@wanadoo.fr','Florian','register','{\"email\":\"florian.blanchet@wanadoo.fr\"}',NULL,NULL,'77.136.55.34','Mozilla/5.0 (Linux; Android 12; M2007J3SG Build/SKQ1.211006.001; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.52 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/548.1.0.51.64;IABMV/1;]','2026-03-03 18:41:42','2026-03-03 18:41:42'),('e83b8c40-fe7a-4ed8-910f-bb512327698d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','74877628-c353-45ef-bd7e-49b18dcf12d9','empathy','172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 13:05:17','2026-03-01 13:05:17'),('e864960b-c194-44fe-8344-dc292ec5196d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'172.22.0.1','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-01 12:27:03','2026-03-01 12:27:03'),('e91c7d17-932a-475b-ba6b-0dbcee34d009','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','8768b9dd-80b2-4948-b741-73b3abd1ccb7','empathy','10.0.0.2','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-02 12:14:03','2026-03-02 12:14:03'),('e958c48b-cf1b-4b4b-a2bf-cdfbb6024f5c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-14 16:09:58','2026-03-14 16:09:58'),('ea68505e-b80c-4e94-9a5c-56fbee8ca741','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','ec63e9d2-cadb-4317-9a9f-c255c305090c','support','10.0.0.2','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Mobile Safari/537.36','2026-02-12 20:09:36','2026-02-12 20:09:36'),('eb1e046f-4e87-4e7b-83d4-35d3929ff449','67093935-7c93-4f9c-9baf-e8ed97845d4a','aferney@live.fr',NULL,'reaction','{\"reactionType\":\"support\"}','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','2026-03-08 17:33:06','2026-03-08 17:33:06'),('ecaf02f4-2573-4e6d-bc97-ef36b9562eca','e96f77cb-e0ca-42ab-bd4f-e610dcce0c24','axel@axel.fr','axel','register','{\"email\":\"axel@axel.fr\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 15:35:34','2026-03-05 15:35:34'),('f6379300-bb1c-4ef1-bc11-f42b12c4d235','9f4d32d6-743f-4a4d-a220-92416afaae63','creaalyas@gmail.com','Alice','register','{\"email\":\"creaalyas@gmail.com\"}',NULL,NULL,'88.177.207.79','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-04 09:43:28','2026-03-04 09:43:28'),('f6d0c385-587f-469e-9164-3d629a77c6bc','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-07 18:23:45','2026-03-07 18:23:45'),('f9415046-e776-4a85-8bfe-2ca3ff42f37b','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"empathy\"}','d864bc7b-ae86-4ac1-92ac-9626b20906b0','empathy','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:08:06','2026-03-05 20:08:06'),('f95ff4c3-159e-4105-b1a5-2b58fac21ded','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','8768b9dd-80b2-4948-b741-73b3abd1ccb7','laugh','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-02 21:27:51','2026-03-02 21:27:51'),('fa323457-83c6-4534-b94a-55f09186e9cb','6bc4a168-ad13-4249-b94a-bc81efe0f764','taaazzzbg@gmail.com','Popeye','login','{\"email\":\"taaazzzbg@gmail.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','2026-03-06 17:35:35','2026-03-06 17:35:35'),('fafe16e0-5949-477a-88ac-a3cc2440b8fb','7e523f2d-f01b-4e5a-b74c-02dd6e521453','reviewer@faildaily.com','TestUser','login','{\"email\":\"reviewer@faildaily.com\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-20 11:34:04','2026-03-20 11:34:04'),('fba01298-5d77-4aee-901a-ccbbf151ea66','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:31:46','2026-03-05 20:31:46'),('fc81479c-81d6-41c0-b76b-b4fb7fe5ff6b','f7da525e-60b4-49c5-85f2-6bea484f9f65','axel@axel.fr',NULL,'reaction','{\"reactionType\":\"support\"}','2e33947a-1978-4fb2-a5be-2bcd5f170f3b','support','78.123.102.138','Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','2026-03-05 20:07:58','2026-03-05 20:07:58'),('feca4a19-9f2f-4bf1-9f0d-c650ca31cf31','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-18 17:20:09','2026-03-18 17:20:09');

--
-- Table structure for table `user_avatars`
--

CREATE TABLE `user_avatars` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail_url` text COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_avatars_user_id` (`user_id`),
  CONSTRAINT `fk_user_avatars_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_avatars`
--

INSERT INTO `user_avatars` VALUES ('277823c2-c752-480d-98c4-67f8671ffa5c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','/uploads/avatars/avatar-9f92d99e-5f70-427e-aebd-68ca8b727bd4-d14b0d65-e8b8-4148-9eb6-7de852a9a512_full.jpg','/uploads/avatars/avatar-9f92d99e-5f70-427e-aebd-68ca8b727bd4-d14b0d65-e8b8-4148-9eb6-7de852a9a512_thumb.jpg','2026-03-21 18:30:13'),('85bd8da8-8c85-4801-bd7d-b2901d70d958','0182cd19-331b-4b48-9ef6-7d30b5801a09','/uploads/avatars/avatar-0182cd19-331b-4b48-9ef6-7d30b5801a09-a7dd6f51-8ad7-417d-a55b-d9e6d4016e23_full.jpg','/uploads/avatars/avatar-0182cd19-331b-4b48-9ef6-7d30b5801a09-a7dd6f51-8ad7-417d-a55b-d9e6d4016e23_thumb.jpg','2026-03-21 10:26:00');

--
-- Table structure for table `user_badges`
--

CREATE TABLE `user_badges` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `badge_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `unlocked_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_badge` (`user_id`,`badge_id`),
  KEY `idx_user_badges_badge_id` (`badge_id`),
  KEY `idx_user_badges_unlocked` (`unlocked_at`),
  CONSTRAINT `user_badges_badge_id_fkey` FOREIGN KEY (`badge_id`) REFERENCES `badge_definitions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_badges_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_badges`
--

INSERT INTO `user_badges` VALUES ('08d5eb04-67f9-4a7f-9a04-4855ae7a5596','4357e8bf-efd9-4003-a4a3-fcff0750d2e3','first-reaction','2026-03-05 20:08:07','2026-03-05 20:08:07'),('08f83b6e-5618-41ee-9307-dc2e322ddc00','9f4d32d6-743f-4a4d-a220-92416afaae63','first-reaction','2026-03-04 10:06:00','2026-03-04 10:06:00'),('09b7a657-8242-4c91-ba15-fd5c48f0bb63','67093935-7c93-4f9c-9baf-e8ed97845d4a','early-adopter','2026-03-07 11:12:36','2026-03-07 11:12:36'),('0d3a055c-9c01-4264-8a40-1d58f4bb0c16','0c337fc6-c25c-4cfb-b7e1-12208057b796','first-reaction','2026-02-13 13:21:15','2026-02-13 13:21:15'),('1035d8aa-e9bb-4d84-93a6-5b8806898de6','e498b349-7d10-4fb1-be7a-7f33ca546656','first-reaction','2026-03-05 20:08:20','2026-03-05 20:08:20'),('180e3e6c-b699-491f-93dc-e403e297c38d','ad814031-ee37-4026-92d4-40fe9b6a5667','early-adopter','2026-02-13 13:21:26','2026-02-13 13:21:26'),('18c883c5-177e-430b-9ccd-839460ca6c30','e498b349-7d10-4fb1-be7a-7f33ca546656','midnight-warrior','2026-03-05 20:08:20','2026-03-05 20:08:20'),('1a38a2f7-f37b-479e-9d42-f5391562e1a8','0c337fc6-c25c-4cfb-b7e1-12208057b796','early-adopter','2026-02-13 13:21:15','2026-02-13 13:21:15'),('1acf98a0-9dda-4238-9b38-5d9abd375d53','67093935-7c93-4f9c-9baf-e8ed97845d4a','first-fail','2026-03-07 11:12:36','2026-03-07 11:12:36'),('1c97290d-21e8-47de-899b-8f8d4fa2cf4e','23d317f1-d4c5-4218-9606-16172172a981','early-adopter','2026-03-05 20:07:21','2026-03-05 20:07:21'),('21f00017-4da4-4e0b-b596-b3d71ac14262','3f95d5bf-a530-4756-86c6-581c8df4be07','first-fail','2026-03-05 20:08:09','2026-03-05 20:08:09'),('275470aa-355f-4f3e-8561-2d2c2e9a6c8d','e0d796fe-342b-4516-940f-ee4e738f2955','first-reaction','2026-02-13 13:21:23','2026-02-13 13:21:23'),('2ab58ebd-9828-4c46-8343-12042e341e97','e0d796fe-342b-4516-940f-ee4e738f2955','early-adopter','2026-02-13 13:21:22','2026-02-13 13:21:22'),('3d153e7a-3adb-4a15-afe6-30e4b603e2ff','e0d796fe-342b-4516-940f-ee4e738f2955','first-fail','2026-02-13 13:21:23','2026-02-13 13:21:23'),('42b1f839-2d80-4a3a-8a71-c3d0b52630a8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','early-adopter','2026-02-12 19:45:50','2026-02-12 19:45:50'),('47d75db0-c3b3-4327-843d-ed3fd277dff1','6bc4a168-ad13-4249-b94a-bc81efe0f764','first-fail','2026-02-28 23:18:00','2026-02-28 23:18:00'),('4a7eb2de-1c30-42c4-9cdd-6fa10f490b6e','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa','first-fail','2026-03-05 20:08:05','2026-03-05 20:08:05'),('4bb21cfb-2123-4813-b24c-7de7dfc4c739','ad814031-ee37-4026-92d4-40fe9b6a5667','first-fail','2026-02-13 13:21:26','2026-02-13 13:21:26'),('5a1b9cbf-cf81-4fd4-99e1-b2850d2d38d1','9f92d99e-5f70-427e-aebd-68ca8b727bd4','first-fail','2026-02-12 19:45:09','2026-02-12 19:45:09'),('60e28026-e882-4d6d-b606-bfda257b4a9c','0182cd19-331b-4b48-9ef6-7d30b5801a09','first-fail','2026-03-04 20:35:57','2026-03-04 20:35:57'),('69d7130a-e0a1-45c5-a651-f927881bf03c','6bc4a168-ad13-4249-b94a-bc81efe0f764','early-adopter','2026-02-28 23:23:06','2026-02-28 23:23:06'),('6a5f8bc8-6f26-4d1d-9152-92d6d975916d','23d317f1-d4c5-4218-9606-16172172a981','midnight-warrior','2026-03-05 20:07:21','2026-03-05 20:07:21'),('7c1920a6-06ba-47f0-a85d-8771e89d2a34','0b112aaf-06c8-43c0-8c58-d48089a11a11','early-adopter','2026-02-13 13:21:18','2026-02-13 13:21:18'),('80a5e0c5-56d6-41b5-b00c-e3fc4c3ce4b1','23d317f1-d4c5-4218-9606-16172172a981','first-fail','2026-03-05 20:07:21','2026-03-05 20:07:21'),('8527c3f0-5517-4930-a774-518a8c8d0f82','9f4d32d6-743f-4a4d-a220-92416afaae63','early-adopter','2026-03-04 09:53:36','2026-03-04 09:53:36'),('8a4ad603-49b4-4928-a3a1-6cb1a8b7c650','3f95d5bf-a530-4756-86c6-581c8df4be07','early-adopter','2026-03-05 20:08:08','2026-03-05 20:08:08'),('8d9f00b5-0932-4a71-ad89-ddb0af304d18','e498b349-7d10-4fb1-be7a-7f33ca546656','early-adopter','2026-03-05 20:08:20','2026-03-05 20:08:20'),('95287e2b-5652-40c1-9dd8-529f3eb27999','0182cd19-331b-4b48-9ef6-7d30b5801a09','early-adopter','2026-03-04 20:35:57','2026-03-04 20:35:57'),('9594bd5b-2d33-485d-9184-39fd31252551','9f4d32d6-743f-4a4d-a220-92416afaae63','first-fail','2026-03-04 09:53:36','2026-03-04 09:53:36'),('9accd330-e833-4174-b15e-ca715d87f9d9','0c337fc6-c25c-4cfb-b7e1-12208057b796','first-fail','2026-02-13 13:21:15','2026-02-13 13:21:15'),('a225e279-4b8d-4387-8bce-7b6b62fb24dd','0b112aaf-06c8-43c0-8c58-d48089a11a11','first-reaction','2026-02-13 13:21:18','2026-02-13 13:21:18'),('ad2b5cf0-35f0-4979-b526-d3c96f49a0a5','4357e8bf-efd9-4003-a4a3-fcff0750d2e3','early-adopter','2026-03-05 20:08:07','2026-03-05 20:08:07'),('b81df134-826b-463a-826e-45cca5d170ab','4357e8bf-efd9-4003-a4a3-fcff0750d2e3','first-fail','2026-03-05 20:08:07','2026-03-05 20:08:07'),('c17dd0dc-8014-4f8b-b51b-4378de7ce03d','23d317f1-d4c5-4218-9606-16172172a981','first-reaction','2026-03-05 20:07:21','2026-03-05 20:07:21'),('c4522914-7b0c-4809-b2b9-eb9aa91c3201','3f95d5bf-a530-4756-86c6-581c8df4be07','first-reaction','2026-03-05 20:08:09','2026-03-05 20:08:09'),('cfc60e27-3e11-4b95-a6c0-6611da937dd7','9f92d99e-5f70-427e-aebd-68ca8b727bd4','first-reaction','2026-03-07 07:50:27','2026-03-07 07:50:27'),('d607d949-a45c-4538-b414-f90e354a7714','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa','first-reaction','2026-03-05 20:08:05','2026-03-05 20:08:05'),('d798e042-3987-49ea-a575-2c7957b002db','ad814031-ee37-4026-92d4-40fe9b6a5667','first-reaction','2026-02-13 13:21:26','2026-02-13 13:21:26'),('dba15dd1-33a0-4881-8294-90a6753b0d49','e498b349-7d10-4fb1-be7a-7f33ca546656','first-fail','2026-03-05 20:08:20','2026-03-05 20:08:20'),('f4f4e1be-4885-40f2-a791-78ebf82b4b48','67093935-7c93-4f9c-9baf-e8ed97845d4a','first-reaction','2026-03-07 11:13:06','2026-03-07 11:13:06'),('f56b7646-81b7-4228-94ee-4d1d17c428b2','0b112aaf-06c8-43c0-8c58-d48089a11a11','first-fail','2026-02-13 13:21:18','2026-02-13 13:21:18'),('f8c7de36-12de-4589-a493-027dd2ef8faa','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa','early-adopter','2026-03-05 20:08:05','2026-03-05 20:08:05'),('fc97eeea-57ea-495a-9330-fba6c22a3181','846ccd15-b408-4bea-8089-085f28fc05bd','early-adopter','2026-03-12 13:31:10','2026-03-12 13:31:10'),('fdace839-9920-40f4-8408-2ec1f93349cc','9f92d99e-5f70-427e-aebd-68ca8b727bd4','beta-tester','2026-03-02 20:23:21','2026-03-02 20:23:21'),('fe6fe08e-2bf5-4cf4-973e-88575fb5e8e6','6bc4a168-ad13-4249-b94a-bc81efe0f764','first-reaction','2026-03-01 12:42:11','2026-03-01 12:42:11');

--
-- Table structure for table `user_blocks`
--

CREATE TABLE `user_blocks` (
  `blocker_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `blocked_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`blocker_id`,`blocked_id`),
  KEY `idx_user_blocks_blocked` (`blocked_id`),
  CONSTRAINT `fk_user_blocks_blocked` FOREIGN KEY (`blocked_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_user_blocks_blocker` FOREIGN KEY (`blocker_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_blocks`
--


--
-- Table structure for table `user_consents`
--

CREATE TABLE `user_consents` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `documents` json NOT NULL,
  `accepted_at` timestamp NULL DEFAULT NULL,
  `revoked_at` timestamp NULL DEFAULT NULL,
  `ip_address` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_user` (`user_id`),
  KEY `idx_user_consents_user` (`user_id`),
  CONSTRAINT `fk_user_consents_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Consentements lÔö£├óÔö¼┬«gaux des utilisateurs';

--
-- Dumping data for table `user_consents`
--

INSERT INTO `user_consents` VALUES ('0e501554-16ba-4eac-9bff-ff2f73366fc7','846ccd15-b408-4bea-8089-085f28fc05bd','[\"terms_of_service\", \"privacy-policy\"]','2026-03-12 13:27:21',NULL,'14.1.65.190','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.4 Safari/605.1.15','2026-03-12 13:27:21','2026-03-12 13:27:21'),('576e9993-ec68-45af-9045-3368bd9aa874','7e523f2d-f01b-4e5a-b74c-02dd6e521453','[\"terms_of_service\", \"privacy-policy\"]','2026-03-19 22:57:56',NULL,'78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','2026-03-19 22:57:56','2026-03-19 22:57:56'),('b0986a5e-fcc9-4b03-8fc5-a5f6945de1d3','3afe8920-f82f-4362-8b69-d1aa204e1043','[\"terms_of_service\", \"privacy-policy\"]','2026-03-08 14:15:14',NULL,'92.184.118.60','Mozilla/5.0 (Linux; Android 13; V2053 Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.104 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/549.0.0.61.62;IABMV/1;]','2026-03-08 14:15:14','2026-03-08 14:15:14');

--
-- Table structure for table `user_ip_history`
--

CREATE TABLE `user_ip_history` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `country_code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `first_seen` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `seen_count` int DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_user_ip` (`user_id`,`ip_address`),
  KEY `idx_user` (`user_id`),
  KEY `idx_country` (`country_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_ip_history`
--

INSERT INTO `user_ip_history` VALUES ('2d7186f0-fcaa-4ed8-b7b2-bdb60952225d','67093935-7c93-4f9c-9baf-e8ed97845d4a','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 18_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Mobile/15E148 Safari/604.1','FR','2026-03-03 19:05:25','2026-03-12 19:56:20',215),('495e3875-8a06-4a86-8f03-a5de57f52fbf','9f92d99e-5f70-427e-aebd-68ca8b727bd4','79.91.177.67','Mozilla/5.0 (Linux; Android 16; SM-S921B Build/BP2A.250605.031.A3; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.79 Mobile Safari/537.36 [LinkedInApp]/2.248.64','FR','2026-03-03 21:52:23','2026-03-03 21:53:13',13),('5ccd8d7e-c9fa-4c7d-b775-fc73ed7bff2c','9f4d32d6-743f-4a4d-a220-92416afaae63','88.177.207.79','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','FR','2026-03-04 09:51:50','2026-03-04 14:29:10',96),('6104d6fd-a0a9-4ced-a7cc-5bf852c3db89','3afe8920-f82f-4362-8b69-d1aa204e1043','92.184.118.60','Mozilla/5.0 (Linux; Android 13; V2053 Build/TP1A.220624.014; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/145.0.7632.104 Mobile Safari/537.36 [FB_IAB/FB4A;FBAV/549.0.0.61.62;IABMV/1;]','FR','2026-03-08 14:15:16','2026-03-08 14:15:48',8),('7b6c5f8e-063b-47a3-87c6-0dce3a597cb4','0182cd19-331b-4b48-9ef6-7d30b5801a09','78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','FR','2026-03-04 20:33:56','2026-03-21 10:28:35',79),('8ee3d194-4532-406a-b41a-fb1b96e39d40','0182cd19-331b-4b48-9ef6-7d30b5801a09','128.79.24.162','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','FR','2026-03-28 20:01:38','2026-03-29 20:00:57',918),('9563cdab-f1af-4f43-b50e-19c582cfbf66','9f92d99e-5f70-427e-aebd-68ca8b727bd4','78.123.102.138','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Mobile Safari/537.36','FR','2026-03-02 22:13:14','2026-03-23 17:37:58',2842),('9fb004c3-3f11-46e6-bf54-a9666047eb26','846ccd15-b408-4bea-8089-085f28fc05bd','14.1.65.190','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.4 Safari/605.1.15','NZ','2026-03-12 13:27:23','2026-03-12 14:33:37',55),('bb1c6fe1-c02b-4d5b-9f4b-055cdb6111fa','f7da525e-60b4-49c5-85f2-6bea484f9f65','78.123.102.138','Mozilla/5.0 (iPhone; CPU iPhone OS 15_0 like Mac OS X) AppleWebKit/603.1.30 (KHTML, like Gecko) Version/17.5 Mobile/15A5370a Safari/602.1','FR','2026-03-05 16:36:46','2026-03-05 20:14:45',910),('c0de6694-eda2-4f64-9c52-a7773728c43d','6e315d59-cb33-4403-8fdf-2e4326c4b5a1','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','FR','2026-03-04 19:59:19','2026-03-04 19:59:19',1),('cbd08019-861b-44a9-b206-3be80b040cc1','67093935-7c93-4f9c-9baf-e8ed97845d4a','176.149.158.195','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.3 Safari/605.1.15','FR','2026-03-05 06:58:45','2026-03-06 07:05:53',5),('e7031979-ff6a-445c-ac22-0bc98b170566','7e523f2d-f01b-4e5a-b74c-02dd6e521453','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/146.0.0.0 Safari/537.36','FR','2026-03-19 22:57:58','2026-03-20 16:51:18',3104),('ebe49271-b658-4010-b2a1-a5a82c4ff27b','6bc4a168-ad13-4249-b94a-bc81efe0f764','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','FR','2026-03-03 16:47:10','2026-03-07 23:30:11',2831),('ec97edfd-99f9-49f5-abff-900f6183562d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','79.91.177.111','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36','FR','2026-03-08 14:10:20','2026-03-08 14:12:13',26),('f1acf7ca-a3ec-4984-afc7-9cf0adcd0357','846ccd15-b408-4bea-8089-085f28fc05bd','150.228.187.22','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.4 Safari/605.1.15','US','2026-03-13 09:10:49','2026-03-13 09:19:23',15),('fd12944f-d5c4-4a1a-8c91-ec989a59ee09','c9538cf4-6cc2-4040-9e6c-45fa4c886616','78.123.102.138','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36','FR','2026-03-04 12:15:34','2026-03-04 15:08:51',771);

--
-- Table structure for table `user_legal_acceptances`
--

CREATE TABLE `user_legal_acceptances` (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `accepted_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `accepted_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_document` (`user_id`,`document_id`),
  KEY `idx_user_acceptances` (`user_id`),
  KEY `idx_document_acceptances` (`document_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_legal_acceptances`
--


--
-- Table structure for table `user_management_logs`
--

CREATE TABLE `user_management_logs` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `target_object_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_management_logs_admin_id_fkey` (`admin_id`),
  KEY `user_management_logs_target_user_id_fkey` (`target_user_id`),
  CONSTRAINT `user_management_logs_admin_id_fkey` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`),
  CONSTRAINT `user_management_logs_target_user_id_fkey` FOREIGN KEY (`target_user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_management_logs`
--


--
-- Table structure for table `user_point_events`
--

CREATE TABLE `user_point_events` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` int NOT NULL,
  `source` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reaction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_point_events_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_point_events`
--

INSERT INTO `user_point_events` VALUES ('045b9af1-5af2-417e-a7c5-9ebe241fb289','6bc4a168-ad13-4249-b94a-bc81efe0f764',5,'reaction','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-09 19:13:51'),('0588b0f1-c51e-4076-bd7c-9075d1ccc169','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','0a2392bb-6832-4862-826b-5a566945902d',NULL,NULL,'2026-03-04 10:07:23'),('05f0c7f5-2fb1-486a-b392-4b6729ec59cc','6bc4a168-ad13-4249-b94a-bc81efe0f764',3,'reaction','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-08 10:19:56'),('0cc22bc4-f2e0-4266-bb0f-36d3b531aedc','0c337fc6-c25c-4cfb-b7e1-12208057b796',3,'reaction','8768b9dd-80b2-4948-b741-73b3abd1ccb7','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-02 21:27:51'),('0da2069f-4bc7-4bab-af6a-3cf615575e4c','23d317f1-d4c5-4218-9606-16172172a981',3,'reaction','b2d52b3c-eec8-4d38-b57f-68f771127341','laugh','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:07:20'),('116aafe1-47a4-4dbd-a8ce-4972c87606c3','9f4d32d6-743f-4a4d-a220-92416afaae63',3,'reaction','0a2392bb-6832-4862-826b-5a566945902d','laugh','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-04 10:37:41'),('137ef7cd-cdb5-4060-9516-f9a1207e1a85','0182cd19-331b-4b48-9ef6-7d30b5801a09',10,'fail_create','fe29547d-0cec-4eb1-94b8-928e8e263498',NULL,NULL,'2026-03-04 20:35:56'),('14e1b504-53f1-44e7-b512-a6c0e2703d6b','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','3c39b5a4-271d-47dd-80c6-e4969f2b0c67',NULL,NULL,'2026-03-02 19:22:43'),('17314721-5d1f-478e-bbf6-9d777cbef492','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','74877628-c353-45ef-bd7e-49b18dcf12d9',NULL,NULL,'2026-02-17 16:15:17'),('183daf4b-ba07-4c8e-a55f-0acb14083cc9','6bc4a168-ad13-4249-b94a-bc81efe0f764',10,'fail_create','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0',NULL,NULL,'2026-03-07 22:42:48'),('19b0698d-811a-42dc-b35c-2144c2c3b80c','0c337fc6-c25c-4cfb-b7e1-12208057b796',2,'reaction','8768b9dd-80b2-4948-b741-73b3abd1ccb7','empathy','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:07:54'),('1a02d4b1-502c-4eec-a3a8-15b541933d25','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','74877628-c353-45ef-bd7e-49b18dcf12d9',NULL,NULL,'2026-03-01 12:43:19'),('1da0d637-50ae-4166-b2ca-531e193736e6','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','65b0fed1-ac6e-4862-bcf8-4f92b3b7884d',NULL,NULL,'2026-03-01 16:42:12'),('1edc876b-e71e-4175-b424-ae9a7f53c057','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','234eb44f-35a3-4c9d-9390-85edec96cb65',NULL,NULL,'2026-03-20 19:53:25'),('25ce12b2-c2ee-429e-9e70-e44789571938','6bc4a168-ad13-4249-b94a-bc81efe0f764',10,'fail_create','e927cefb-59df-4965-8da5-ac39ced93939',NULL,NULL,'2026-03-06 17:36:12'),('2791ee5e-6f13-4d6e-b592-0ba393ee3429','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','f5154783-5673-494b-b193-692904478ad3',NULL,NULL,'2026-03-02 20:56:39'),('27eb7f5e-d057-477a-8459-edad8771a282','6bc4a168-ad13-4249-b94a-bc81efe0f764',3,'reaction','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-08 17:33:06'),('2846921e-6791-427a-aff3-2b1d6ce1f35c','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','12d4082a-9be6-4d57-b832-848e7bdce616',NULL,NULL,'2026-03-01 13:31:04'),('2e3ab17d-78ef-46a5-b00a-bebc69296642','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','93789c00-758b-44ef-bff6-d9eb15bb4f1d',NULL,NULL,'2026-03-06 16:47:09'),('2ec4c632-43ef-439a-8535-9ec9f382f1fa','9f4d32d6-743f-4a4d-a220-92416afaae63',3,'reaction','0a2392bb-6832-4862-826b-5a566945902d','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-04 10:05:59'),('2f4fa50e-4c93-46ca-89b2-d7b6bc8e170c','9f4d32d6-743f-4a4d-a220-92416afaae63',5,'reaction','0a2392bb-6832-4862-826b-5a566945902d','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-06 15:52:01'),('3082e1ea-c7ed-41bd-ae97-907cb28f4348','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','fbf65b92-5913-4adc-82a3-60bba86a56f7',NULL,NULL,'2026-02-12 19:46:15'),('3738b7b0-5de7-4622-b738-978719bb4379','6bc4a168-ad13-4249-b94a-bc81efe0f764',5,'reaction','45cf117f-d5df-43b3-9831-5eb0683695b6','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-01 12:42:10'),('3a29d7b1-7076-4ae4-bf52-bad80ff39be5','9f92d99e-5f70-427e-aebd-68ca8b727bd4',-2,'fail_deleted_revoke_comment','e3722feb-53a1-4a85-8c3d-07bb8b61c9e9',NULL,NULL,'2026-02-12 20:10:09'),('3a93c12d-6d4e-406a-a985-fd0aaf6d00fc','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','74877628-c353-45ef-bd7e-49b18dcf12d9',NULL,NULL,'2026-03-01 12:50:17'),('3aac7ca6-5de7-41b5-88bc-42858ae6d4bc','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','8768b9dd-80b2-4948-b741-73b3abd1ccb7',NULL,NULL,'2026-03-02 21:56:54'),('41b95a6c-12b4-4e85-b680-2c3ddd0b57d0','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','f61e10ab-be44-4751-a268-b8d56089d295',NULL,NULL,'2026-03-06 15:52:33'),('47b1d174-d8a4-4148-acb5-87816c6aaaca','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','53742b6f-742f-42b3-aed5-0ffe1f008651',NULL,NULL,'2026-03-01 13:06:10'),('4eb1be93-3a80-4993-97f6-0593536dce61','9f92d99e-5f70-427e-aebd-68ca8b727bd4',-6,'fail_deleted_revoke_comment','74877628-c353-45ef-bd7e-49b18dcf12d9',NULL,NULL,'2026-03-01 17:16:36'),('506b76a7-0859-4620-ba5f-bfaf0a67fd3d','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','1fec5d2e-a663-4acf-b47e-2893d4015bb9',NULL,NULL,'2026-02-12 19:45:09'),('510b4114-79ed-4ca2-86a3-cd2377070754','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','ec63e9d2-cadb-4317-9a9f-c255c305090c',NULL,NULL,'2026-02-12 19:47:21'),('57466b26-497b-4526-b799-9acc59a55189','0b112aaf-06c8-43c0-8c58-d48089a11a11',3,'reaction','2e33947a-1978-4fb2-a5be-2bcd5f170f3b','support','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:07:58'),('59c18585-dc14-404b-acc1-b7fcfdcf0a24','846ccd15-b408-4bea-8089-085f28fc05bd',2,'comment_create','9a5fb071-276c-4376-8204-e0644076f929',NULL,NULL,'2026-03-12 13:31:10'),('60259eb5-5472-4ac7-9a2d-7b6740f82f6a','f7da525e-60b4-49c5-85f2-6bea484f9f65',10,'fail_create','17e08af8-5487-4e45-a53e-9932b6db457e',NULL,NULL,'2026-03-05 16:50:00'),('6505fba2-55a6-4e45-a2ec-2f52a0d4d046','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','5ec3f7eb-e297-4a0c-bd7b-d8ce36f11cca',NULL,NULL,'2026-03-07 11:12:39'),('67718156-93bd-4a8b-ac3f-3b9c91c5b6bf','9f4d32d6-743f-4a4d-a220-92416afaae63',2,'reaction','0a2392bb-6832-4862-826b-5a566945902d','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-06 15:52:04'),('6851a0ea-324b-4fc9-b4a5-91c911ae9453','9f4d32d6-743f-4a4d-a220-92416afaae63',-2,'reaction_remove','0a2392bb-6832-4862-826b-5a566945902d','empathy','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-04 10:37:40'),('6a23edc3-1d4d-4e46-8386-851842c80b91','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','cc3f5775-6b10-4036-9fdb-de7158976890',NULL,NULL,'2026-03-02 21:06:32'),('6bc2b31a-cdda-4ee7-a136-1c999e674e4b','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','2f94e0c6-15f2-40af-b709-dbbcd4ae9331',NULL,NULL,'2026-03-01 13:18:44'),('77410c50-9466-4eff-b22f-998eda886388','e498b349-7d10-4fb1-be7a-7f33ca546656',3,'reaction','b453999e-523a-4ccc-b83b-cc7f41b6994a','support','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:08:19'),('798e5d92-650d-458e-b2c0-3103d7a81c19','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa',5,'reaction','e6036d03-8064-42c2-ae56-14e4d5c21e5e','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-06 15:52:14'),('7ced37a9-5de4-48dc-b272-4c75e1f23d38','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','e3722feb-53a1-4a85-8c3d-07bb8b61c9e9',NULL,NULL,'2026-02-12 18:54:59'),('80a29105-2bd6-4902-8ae0-4d54a6208012','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','815c9b23-7ce8-4cec-b971-fbdb90b081dc',NULL,NULL,'2026-03-01 20:49:56'),('82481ba6-74be-43c4-8c83-2def327c56bc','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','d864bc7b-ae86-4ac1-92ac-9626b20906b0',NULL,NULL,'2026-03-09 19:14:46'),('84187968-e637-47cf-9a61-ae3fdad87679','6bc4a168-ad13-4249-b94a-bc81efe0f764',10,'fail_create','a1276151-f832-4508-909f-06a83d5ee2d3',NULL,NULL,'2026-03-03 17:51:46'),('8745aa5c-6618-495a-995a-83dc6de6df8a','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','74877628-c353-45ef-bd7e-49b18dcf12d9',NULL,NULL,'2026-02-12 23:27:57'),('8758c1c0-5852-46bb-a7a9-eefdff371f53','846ccd15-b408-4bea-8089-085f28fc05bd',2,'comment_create','9bd88682-128d-4f18-a8eb-056a9a017ada',NULL,NULL,'2026-03-12 13:36:06'),('8dac2b13-4cf5-4d98-8c98-35ce4fd6b4de','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','ec35c7f7-f20e-4f3a-894c-21e184ae8632',NULL,NULL,'2026-02-12 22:11:44'),('952ca616-7847-4057-9d99-6caa41261953','846ccd15-b408-4bea-8089-085f28fc05bd',2,'comment_create','e6036d03-8064-42c2-ae56-14e4d5c21e5e',NULL,NULL,'2026-03-12 13:34:18'),('98848924-39fb-41ee-b0ab-ddf2d86c34fe','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','0ecc901f-c72c-48dc-b51d-ce1cd22ce4f0',NULL,NULL,'2026-03-01 13:37:56'),('9a3ecbe3-3efc-49e2-9520-210275d1aa27','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','2f96a8f5-5265-49e4-8bd7-3ed40dd01338',NULL,NULL,'2026-03-06 16:46:06'),('9b897460-cfb0-4bf5-9cce-662c8ce25d2c','846ccd15-b408-4bea-8089-085f28fc05bd',2,'comment_create','d6107343-83e8-4eb1-ac47-a763b0fdca69',NULL,NULL,'2026-03-13 09:12:14'),('9f74e944-b073-4a70-9c06-6978faeda792','e0d796fe-342b-4516-940f-ee4e738f2955',3,'reaction','0ddb35d9-ae10-4a96-a3ba-645c25910019','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-02-13 13:21:21'),('a523d5f7-642b-4acd-8f42-44ed0e9e12d0','9f4d32d6-743f-4a4d-a220-92416afaae63',2,'reaction','0a2392bb-6832-4862-826b-5a566945902d','empathy','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-04 10:37:35'),('a8834e54-52a6-485e-bc62-9c029062b7e6','0c337fc6-c25c-4cfb-b7e1-12208057b796',3,'reaction','8768b9dd-80b2-4948-b741-73b3abd1ccb7','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-02-13 13:21:13'),('b5126754-b992-4f99-9ae5-120b1164fe0a','9f4d32d6-743f-4a4d-a220-92416afaae63',10,'fail_create','0a2392bb-6832-4862-826b-5a566945902d',NULL,NULL,'2026-03-04 09:53:34'),('b693e121-356f-43c6-a0b3-74862aaa71cf','9f92d99e-5f70-427e-aebd-68ca8b727bd4',3,'reaction','07d9f0d9-e1ba-4e30-9ff4-b1ed72c26311','support','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-07 07:50:26'),('b70934e2-6d4d-4ea0-bc33-5d4e5cee3238','0c337fc6-c25c-4cfb-b7e1-12208057b796',2,'reaction','8768b9dd-80b2-4948-b741-73b3abd1ccb7','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-02 12:14:03'),('b81c3ee1-8506-4161-a111-af1ce77a4bbb','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','2f2c970c-bbbb-4e89-8720-6d9b762b6703',NULL,NULL,'2026-03-02 21:01:23'),('bb58636e-523c-4ac7-bcd5-ab01a8717d70','6bc4a168-ad13-4249-b94a-bc81efe0f764',10,'fail_create','45cf117f-d5df-43b3-9831-5eb0683695b6',NULL,NULL,'2026-02-28 23:17:59'),('c9dfcd9c-74f2-4c42-9a32-e171f071f709','67093935-7c93-4f9c-9baf-e8ed97845d4a',10,'fail_create','d6107343-83e8-4eb1-ac47-a763b0fdca69',NULL,NULL,'2026-03-07 11:12:36'),('cb06b22c-d37e-4270-8699-e03af9ef3d44','3f95d5bf-a530-4756-86c6-581c8df4be07',3,'reaction','9bd88682-128d-4f18-a8eb-056a9a017ada','laugh','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:08:08'),('ce4cdc9a-de78-44e2-8762-c475065b96c8','6bc4a168-ad13-4249-b94a-bc81efe0f764',3,'reaction','45cf117f-d5df-43b3-9831-5eb0683695b6','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-01 13:05:09'),('d5fd6116-5510-4b6f-975b-03831e6827ec','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa',5,'reaction','e6036d03-8064-42c2-ae56-14e4d5c21e5e','courage','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:08:04'),('d5ff1b36-6258-4ebf-bef0-83c975819223','9f4d32d6-743f-4a4d-a220-92416afaae63',3,'reaction','0a2392bb-6832-4862-826b-5a566945902d','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-06 15:52:05'),('d75c0849-7306-437a-a810-adcfff4f48ef','67093935-7c93-4f9c-9baf-e8ed97845d4a',3,'reaction','d6107343-83e8-4eb1-ac47-a763b0fdca69','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-07 11:13:04'),('deb7d421-a826-4dc0-9d28-50646d5a6c05','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','07d9f0d9-e1ba-4e30-9ff4-b1ed72c26311',NULL,NULL,'2026-03-07 07:47:30'),('e1177ffa-76a5-4b03-b538-d5cc2ad201ef','9f4d32d6-743f-4a4d-a220-92416afaae63',3,'reaction','0a2392bb-6832-4862-826b-5a566945902d','laugh','{\"fromUser\":\"67093935-7c93-4f9c-9baf-e8ed97845d4a\"}','2026-03-04 10:37:27'),('e6495103-29a2-4166-9570-fba16dbd17c8','6bc4a168-ad13-4249-b94a-bc81efe0f764',-3,'fail_deleted_revoke','45cf117f-d5df-43b3-9831-5eb0683695b6',NULL,'{\"reason\":\"Fail deleted: revoke reaction points\"}','2026-03-01 17:17:11'),('e9aad8ef-5526-4c5d-a32f-32f01200ca8b','0b112aaf-06c8-43c0-8c58-d48089a11a11',2,'reaction','2e33947a-1978-4fb2-a5be-2bcd5f170f3b','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-02-13 13:21:16'),('e9b7ce29-a641-4568-93c0-6391502e07ff','4357e8bf-efd9-4003-a4a3-fcff0750d2e3',3,'reaction','d864bc7b-ae86-4ac1-92ac-9626b20906b0','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-09 19:14:10'),('efdf57b5-df9f-4817-b226-bd62afa5c009','ad814031-ee37-4026-92d4-40fe9b6a5667',5,'reaction','9a5fb071-276c-4376-8204-e0644076f929','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-02-13 13:21:25'),('f8abac03-3ead-4356-b056-07d4a0f1f898','4357e8bf-efd9-4003-a4a3-fcff0750d2e3',2,'reaction','d864bc7b-ae86-4ac1-92ac-9626b20906b0','empathy','{\"fromUser\":\"f7da525e-60b4-49c5-85f2-6bea484f9f65\"}','2026-03-05 20:08:06'),('fa70df73-53b2-4f35-a007-36a9c94d4d42','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','e3722feb-53a1-4a85-8c3d-07bb8b61c9e9',NULL,NULL,'2026-02-12 20:09:57'),('fef43efe-0a57-4b92-bc74-ef27c5b21815','6bc4a168-ad13-4249-b94a-bc81efe0f764',3,'reaction','3bbf24c7-9e5c-4966-a6b9-4499fe0039e0','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2026-03-09 19:13:54');

--
-- Table structure for table `user_points`
--

CREATE TABLE `user_points` (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `points_total` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_points`
--

INSERT INTO `user_points` VALUES ('0182cd19-331b-4b48-9ef6-7d30b5801a09',10,'2026-03-04 20:35:56','2026-03-04 20:35:56'),('0b112aaf-06c8-43c0-8c58-d48089a11a11',6,'2026-02-13 13:21:16','2026-03-05 20:07:58'),('0c337fc6-c25c-4cfb-b7e1-12208057b796',11,'2026-02-13 13:21:13','2026-03-05 20:07:54'),('23d317f1-d4c5-4218-9606-16172172a981',3,'2026-03-05 20:07:20','2026-03-05 20:07:20'),('3f95d5bf-a530-4756-86c6-581c8df4be07',3,'2026-03-05 20:08:08','2026-03-05 20:08:08'),('4357e8bf-efd9-4003-a4a3-fcff0750d2e3',5,'2026-03-05 20:08:06','2026-03-09 19:14:09'),('67093935-7c93-4f9c-9baf-e8ed97845d4a',13,'2026-03-07 11:12:35','2026-03-07 11:13:04'),('6bc4a168-ad13-4249-b94a-bc81efe0f764',70,'2026-02-28 23:17:59','2026-03-09 19:13:53'),('846ccd15-b408-4bea-8089-085f28fc05bd',8,'2026-03-12 13:31:10','2026-03-13 09:12:14'),('9f4d32d6-743f-4a4d-a220-92416afaae63',29,'2026-03-04 09:53:34','2026-03-06 15:52:05'),('9f92d99e-5f70-427e-aebd-68ca8b727bd4',331,'2026-02-12 18:54:59','2026-03-20 19:53:25'),('ad814031-ee37-4026-92d4-40fe9b6a5667',6,'2026-02-13 13:21:25','2026-02-13 13:21:28'),('bd9b0ecb-3dc3-42f1-b710-314da58f5ffa',10,'2026-03-05 20:08:04','2026-03-06 15:52:14'),('e0d796fe-342b-4516-940f-ee4e738f2955',4,'2026-02-13 13:21:21','2026-02-13 13:21:24'),('e498b349-7d10-4fb1-be7a-7f33ca546656',3,'2026-03-05 20:08:19','2026-03-05 20:08:19'),('f7da525e-60b4-49c5-85f2-6bea484f9f65',10,'2026-03-05 16:50:00','2026-03-05 16:50:00');

--
-- Table structure for table `user_preferences`
--

CREATE TABLE `user_preferences` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifications_enabled` tinyint(1) DEFAULT '1',
  `email_notifications` tinyint(1) DEFAULT '1',
  `push_notifications` tinyint(1) DEFAULT '1',
  `privacy_mode` tinyint(1) DEFAULT '0',
  `show_real_name` tinyint(1) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_preferences`
--


--
-- Table structure for table `user_privacy_settings`
--

CREATE TABLE `user_privacy_settings` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `public_profile` tinyint(1) NOT NULL DEFAULT '1',
  `show_stats` tinyint(1) NOT NULL DEFAULT '1',
  `show_badges` tinyint(1) DEFAULT '1',
  `allow_reactions` tinyint(1) DEFAULT '1',
  `allow_private_messages` tinyint(1) DEFAULT '0',
  `push_notifications` tinyint(1) DEFAULT '1',
  `email_notifications` tinyint(1) DEFAULT '0',
  `daily_reminders` tinyint(1) DEFAULT '1',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_settings` (`user_id`),
  KEY `idx_user_privacy` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_privacy_settings`
--

INSERT INTO `user_privacy_settings` VALUES ('2328de45-14ff-11f1-aed8-0242ac110021','6bc4a168-ad13-4249-b94a-bc81efe0f764',1,1,1,1,1,1,0,1,'2026-02-28 23:42:26','2026-03-06 17:36:52'),('afa746d2-08dc-11f1-b3e6-0242ac110021','03875a9c-def8-4dfd-a4a1-d0891d024afc',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74723-08dc-11f1-b3e6-0242ac110021','0397658b-1312-48ed-bae3-9b9595740d3c',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74741-08dc-11f1-b3e6-0242ac110021','08779c3e-81a6-4fc9-b7a0-4c5a3f47e207',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74756-08dc-11f1-b3e6-0242ac110021','08f497b3-0926-4443-96c1-edec23d9590e',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7476a-08dc-11f1-b3e6-0242ac110021','09433a12-76e4-4468-a222-354a6ae7a996',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7477d-08dc-11f1-b3e6-0242ac110021','0b112aaf-06c8-43c0-8c58-d48089a11a11',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74792-08dc-11f1-b3e6-0242ac110021','0c337fc6-c25c-4cfb-b7e1-12208057b796',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa747a4-08dc-11f1-b3e6-0242ac110021','114b3998-2a2e-4b72-a9a4-dc249674ab29',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa747b6-08dc-11f1-b3e6-0242ac110021','11b54c3b-5659-4b9e-9df5-827a7bfd5d1d',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa747ca-08dc-11f1-b3e6-0242ac110021','196cc304-ebc5-4ca2-8e13-4aaac8b00b7c',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa747dd-08dc-11f1-b3e6-0242ac110021','1b1081a4-afd5-4b4f-92f0-5cfb46572717',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa747ef-08dc-11f1-b3e6-0242ac110021','1da39e2c-ccb0-4966-a42e-968eaad10a0e',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74802-08dc-11f1-b3e6-0242ac110021','23d317f1-d4c5-4218-9606-16172172a981',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74814-08dc-11f1-b3e6-0242ac110021','27fd6d81-5d9f-41cb-a43f-b064bd4e35e1',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74825-08dc-11f1-b3e6-0242ac110021','2941586c-86c7-42de-bfe4-5185d8b2ecc8',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74837-08dc-11f1-b3e6-0242ac110021','2c505be4-7a3f-40b0-a5a9-d63465af1ecf',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74849-08dc-11f1-b3e6-0242ac110021','3183a915-75a6-4018-9c36-34b3f3fa603e',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7485c-08dc-11f1-b3e6-0242ac110021','337a479c-eec3-402a-a1fe-7dd2d49dce63',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa748da-08dc-11f1-b3e6-0242ac110021','356dc447-f42d-4739-8438-8c10c658b3b5',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa748ee-08dc-11f1-b3e6-0242ac110021','36529c08-87e0-4c8f-9593-b82f117554ce',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74900-08dc-11f1-b3e6-0242ac110021','36f75786-fa2a-4d2e-8ac5-6557ab2d025b',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74913-08dc-11f1-b3e6-0242ac110021','3a3a0965-8b33-4099-b9e7-ad7ad6c3d19f',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74928-08dc-11f1-b3e6-0242ac110021','3bf6b88e-078a-4d0f-a72e-666f43b24b68',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7493b-08dc-11f1-b3e6-0242ac110021','3d0f181a-7813-4e5d-acb6-4187c19396a5',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7494d-08dc-11f1-b3e6-0242ac110021','3f95d5bf-a530-4756-86c6-581c8df4be07',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa7495f-08dc-11f1-b3e6-0242ac110021','422c32fd-7dc2-427e-8be6-9f74c4f06fdc',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74971-08dc-11f1-b3e6-0242ac110021','4357e8bf-efd9-4003-a4a3-fcff0750d2e3',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74983-08dc-11f1-b3e6-0242ac110021','44ec5f2b-6c1b-4009-97d8-a29104737708',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74995-08dc-11f1-b3e6-0242ac110021','45bde58b-50ab-4dba-be52-b00f7e069ce3',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa749a7-08dc-11f1-b3e6-0242ac110021','45dde8b0-0b04-45fa-ba09-48f1d1508409',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa749bb-08dc-11f1-b3e6-0242ac110021','461de038-c273-4aa6-9ae3-76f3fd3e2b17',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa749ce-08dc-11f1-b3e6-0242ac110021','485e1d02-411b-47cf-b68a-ede85b6cc134',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa749e1-08dc-11f1-b3e6-0242ac110021','48a26c2a-9bff-4df9-840d-49ddf28b4466',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa749f3-08dc-11f1-b3e6-0242ac110021','498c7c83-2ee7-463d-b4eb-8558016d3eed',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a06-08dc-11f1-b3e6-0242ac110021','4a63cbc5-fc2d-4452-a056-c71c2cf880cf',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a46-08dc-11f1-b3e6-0242ac110021','4b49641e-ffe1-48b9-8a2f-95118b196b32',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a58-08dc-11f1-b3e6-0242ac110021','4b90ebdc-c0d2-4ddd-bae2-01f6b0bdc0be',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a6b-08dc-11f1-b3e6-0242ac110021','4ce9bc5b-144c-4ee9-b51f-bdb3571b9583',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a7d-08dc-11f1-b3e6-0242ac110021','504bf880-1a0e-41e1-b77b-8ea5b53a7329',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74a90-08dc-11f1-b3e6-0242ac110021','58ddde33-ab5e-44df-bb74-d8cbfc2cfb68',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74aa3-08dc-11f1-b3e6-0242ac110021','598d308a-03b2-466f-8c31-b618ba05f53c',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ab5-08dc-11f1-b3e6-0242ac110021','5c8b03c1-1c2a-4fea-a5ef-73441619385f',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ac7-08dc-11f1-b3e6-0242ac110021','6737e907-d997-454a-9932-e9a701fcbdf4',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ada-08dc-11f1-b3e6-0242ac110021','6832480a-bca2-4200-a09b-830d53cbb9b8',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74aed-08dc-11f1-b3e6-0242ac110021','69042452-2390-4233-b094-d8964554a7ff',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b00-08dc-11f1-b3e6-0242ac110021','6d947870-3e95-4e97-b282-81d05a3a90ec',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b13-08dc-11f1-b3e6-0242ac110021','70c81854-e0f6-4298-ae60-7b12121c2737',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b24-08dc-11f1-b3e6-0242ac110021','7119ccd5-50e3-4b1d-af10-e560f2e39669',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b37-08dc-11f1-b3e6-0242ac110021','73e1c2df-567b-4824-b39a-06b063067eff',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b49-08dc-11f1-b3e6-0242ac110021','75399513-8698-4c03-b284-140731b15590',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b5c-08dc-11f1-b3e6-0242ac110021','7935bc5d-d8b0-4e7d-85f8-4a35f324196e',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b6e-08dc-11f1-b3e6-0242ac110021','822d4ed4-3c08-45a2-8b25-88cb41094b7d',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74b80-08dc-11f1-b3e6-0242ac110021','829dcf30-aab0-497b-afe2-9a88cad3f74f',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74bc0-08dc-11f1-b3e6-0242ac110021','94c61158-3d04-47e0-8082-5466eed666c6',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74bd2-08dc-11f1-b3e6-0242ac110021','9531cfe1-f444-45c9-8757-ae768eea2304',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74be5-08dc-11f1-b3e6-0242ac110021','966f9b76-63b6-44ff-b02a-406879b58ebd',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74bf7-08dc-11f1-b3e6-0242ac110021','96db0ab3-603b-4382-ba0b-68ac33d86368',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c09-08dc-11f1-b3e6-0242ac110021','9c6227ba-4561-4b9a-b2af-536ab43b78ba',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c1a-08dc-11f1-b3e6-0242ac110021','9f92d99e-5f70-427e-aebd-68ca8b727bd4',1,1,1,1,1,1,0,1,'2026-02-13 13:05:35','2026-03-07 11:14:17'),('afa74c2c-08dc-11f1-b3e6-0242ac110021','a285ffdc-fb36-4387-9bcb-49d6c4295e5b',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c3f-08dc-11f1-b3e6-0242ac110021','a4bb37ac-c88a-4972-95c7-237725c3fdd9',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c52-08dc-11f1-b3e6-0242ac110021','a52db29e-836e-4ee2-82e8-b8886c57c1f5',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c64-08dc-11f1-b3e6-0242ac110021','a638127e-7edc-47ee-97b8-ef390b1a8000',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c76-08dc-11f1-b3e6-0242ac110021','acae74b8-8d8c-44a7-9795-200318793b59',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c88-08dc-11f1-b3e6-0242ac110021','ad814031-ee37-4026-92d4-40fe9b6a5667',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74c99-08dc-11f1-b3e6-0242ac110021','adfef930-4b02-4056-ade1-10e2cb2876a0',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74cab-08dc-11f1-b3e6-0242ac110021','afa3c5da-b99f-4f5f-b463-ab3d8d24e1db',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74cbc-08dc-11f1-b3e6-0242ac110021','b17f3a4b-00bd-4795-9d56-d6c5a88c130d',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ccf-08dc-11f1-b3e6-0242ac110021','b2762555-546e-44b8-b372-1a4472773407',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ce1-08dc-11f1-b3e6-0242ac110021','b2f20fbf-842d-488f-9cce-40a10b7a08d1',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74cf3-08dc-11f1-b3e6-0242ac110021','b3dbe544-def9-4315-a913-1d0267b69fe2',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d2e-08dc-11f1-b3e6-0242ac110021','b4e16832-7625-4368-af5a-452cd903b3b5',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d41-08dc-11f1-b3e6-0242ac110021','bd9b0ecb-3dc3-42f1-b710-314da58f5ffa',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d54-08dc-11f1-b3e6-0242ac110021','c9d49a8a-0541-4d49-853c-6a2aeeccc296',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d67-08dc-11f1-b3e6-0242ac110021','ca5e86ff-d144-4b87-98a3-2b0016280ee3',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d7a-08dc-11f1-b3e6-0242ac110021','ce54a437-4721-4b9c-ab28-9516ff19a856',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d8b-08dc-11f1-b3e6-0242ac110021','cf4d9ce2-0c04-4aca-abf1-9e855288caf9',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74d9e-08dc-11f1-b3e6-0242ac110021','d15cbb68-0b25-4c82-ab07-320831d07879',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74db1-08dc-11f1-b3e6-0242ac110021','d3df5ccf-1b3d-44ca-a04c-0c1cf37e40c2',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74dc3-08dc-11f1-b3e6-0242ac110021','d4cea428-660d-418a-aad0-3e23b3cdafc0',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74dd5-08dc-11f1-b3e6-0242ac110021','d55204a6-a615-487d-b1b2-f48a0d0c2f91',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74de7-08dc-11f1-b3e6-0242ac110021','d572b6a0-bc86-45eb-a780-215100761115',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74dfa-08dc-11f1-b3e6-0242ac110021','d758cb52-affc-42ab-8f76-c70d72032987',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e0e-08dc-11f1-b3e6-0242ac110021','d84ae8da-7a6b-46bc-b25d-e89e49239d75',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e21-08dc-11f1-b3e6-0242ac110021','de03108b-268f-4e82-9075-335fe48e8744',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e33-08dc-11f1-b3e6-0242ac110021','deff9eae-b655-441a-8938-131de43dc106',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e45-08dc-11f1-b3e6-0242ac110021','e0d796fe-342b-4516-940f-ee4e738f2955',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e57-08dc-11f1-b3e6-0242ac110021','e498b349-7d10-4fb1-be7a-7f33ca546656',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74e93-08dc-11f1-b3e6-0242ac110021','e5444141-4f0c-45fb-92b7-3b572aa09a0e',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ea5-08dc-11f1-b3e6-0242ac110021','e742e0b0-1097-48e1-a37a-ad549ce39d31',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74eb8-08dc-11f1-b3e6-0242ac110021','e76734c7-b9af-45d9-a16d-702f9d80b7e9',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ecc-08dc-11f1-b3e6-0242ac110021','e7e55fc9-df1f-430d-95a2-75c46b8cd35d',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ede-08dc-11f1-b3e6-0242ac110021','f06cfc40-4bcc-4b4a-a76a-b828e8fbdff2',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74ef0-08dc-11f1-b3e6-0242ac110021','f2377072-e01d-40dc-a0ec-88652f5be373',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f02-08dc-11f1-b3e6-0242ac110021','f46790ca-7471-4684-baea-c239bd826672',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f14-08dc-11f1-b3e6-0242ac110021','f4f91db4-961e-4170-954d-eae0850d18f7',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f25-08dc-11f1-b3e6-0242ac110021','f4fcca91-b810-4d68-b66e-490d8d96fdd2',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f37-08dc-11f1-b3e6-0242ac110021','f73e3c58-50aa-4b66-b78f-2498ca9b0b74',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f49-08dc-11f1-b3e6-0242ac110021','fa75a8d0-24a9-46a6-9a00-bcced6edef22',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f5b-08dc-11f1-b3e6-0242ac110021','fb37b82c-b33c-4260-88cb-3681d109b070',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('afa74f6d-08dc-11f1-b3e6-0242ac110021','fb7bf3ef-0966-4183-972b-7a75264e0f1f',1,1,1,1,0,1,0,1,'2026-02-13 13:05:35','2026-03-01 10:23:24'),('b7522251-1a16-11f1-8b5b-02420a0002c5','67093935-7c93-4f9c-9baf-e8ed97845d4a',1,1,1,1,1,1,0,1,'2026-03-07 11:13:49','2026-03-07 11:13:52'),('d090b02e-2451-11f1-a27c-02420a00020e','0182cd19-331b-4b48-9ef6-7d30b5801a09',1,1,1,1,0,1,0,1,'2026-03-20 11:42:03','2026-03-20 11:42:03');

--
-- Temporary view structure for view `user_profiles_complete`
--

/*!50001 DROP VIEW IF EXISTS `user_profiles_complete`*/;
/*!50001 CREATE VIEW `user_profiles_complete` AS SELECT 
 1 AS `user_id`,
 1 AS `email`,
 1 AS `email_confirmed`,
 1 AS `role`,
 1 AS `last_login`,
 1 AS `login_count`,
 1 AS `account_status`,
 1 AS `user_created_at`,
 1 AS `profile_id`,
 1 AS `username`,
 1 AS `display_name`,
 1 AS `avatar_url`,
 1 AS `bio`,
 1 AS `registration_completed`,
 1 AS `legal_consent`,
 1 AS `age_verification`,
 1 AS `preferences`,
 1 AS `stats`,
 1 AS `profile_created_at`,
 1 AS `profile_updated_at`,
 1 AS `is_currently_minor`,
 1 AS `calculated_age`,
 1 AS `legal_compliance_status`*/;

--
-- Temporary view structure for view `v_moderation_stats`
--

/*!50001 DROP VIEW IF EXISTS `v_moderation_stats`*/;
/*!50001 CREATE VIEW `v_moderation_stats` AS SELECT 
 1 AS `category`,
 1 AS `enabled`,
 1 AS `severity_threshold`,
 1 AS `description`,
 1 AS `blocks_total`,
 1 AS `blocks_last_7d`,
 1 AS `blocks_last_30d`*/;

--
-- Final view structure for view `logs_realtime`
--

/*!50001 DROP VIEW IF EXISTS `logs_realtime`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `logs_realtime` AS select `activity_logs`.`id` AS `id`,`activity_logs`.`level` AS `level`,`activity_logs`.`action` AS `action`,`activity_logs`.`message` AS `message`,`activity_logs`.`user_id` AS `user_id`,`activity_logs`.`created_at` AS `created_at` from `activity_logs` where (`activity_logs`.`created_at` >= (now() - interval 1 hour)) order by `activity_logs`.`created_at` desc */;

--
-- Final view structure for view `logs_stats`
--

/*!50001 DROP VIEW IF EXISTS `logs_stats`*/;

--
-- Final view structure for view `user_profiles_complete`
--

/*!50001 DROP VIEW IF EXISTS `user_profiles_complete`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `user_profiles_complete` AS select `u`.`id` AS `user_id`,`u`.`email` AS `email`,`u`.`email_confirmed` AS `email_confirmed`,`u`.`role` AS `role`,`u`.`last_login` AS `last_login`,`u`.`login_count` AS `login_count`,`u`.`account_status` AS `account_status`,`u`.`created_at` AS `user_created_at`,`p`.`id` AS `profile_id`,`p`.`username` AS `username`,`p`.`display_name` AS `display_name`,`p`.`avatar_url` AS `avatar_url`,`p`.`bio` AS `bio`,`p`.`registration_completed` AS `registration_completed`,`p`.`legal_consent` AS `legal_consent`,`p`.`age_verification` AS `age_verification`,`p`.`preferences` AS `preferences`,`p`.`stats` AS `stats`,`p`.`created_at` AS `profile_created_at`,`p`.`updated_at` AS `profile_updated_at`,(case when (json_extract(`p`.`age_verification`,'$.isMinor') = true) then true else false end) AS `is_currently_minor`,(case when (json_extract(`p`.`age_verification`,'$.birthDate') is not null) then timestampdiff(YEAR,str_to_date(json_unquote(json_extract(`p`.`age_verification`,'$.birthDate')),'%Y-%m-%d'),now()) else NULL end) AS `calculated_age`,(case when ((`p`.`legal_consent` is not null) and (`p`.`age_verification` is not null) and (`p`.`registration_completed` = true)) then 'compliant' else 'pending' end) AS `legal_compliance_status` from (`users` `u` left join `profiles` `p` on((`u`.`id` = `p`.`user_id`))) */;

--
-- Final view structure for view `v_moderation_stats`
--

/*!50001 DROP VIEW IF EXISTS `v_moderation_stats`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`faildaily_user`@`%` SQL SECURITY DEFINER */
/*!50001 VIEW `v_moderation_stats` AS select `ms`.`category` AS `category`,`ms`.`enabled` AS `enabled`,`ms`.`severity_threshold` AS `severity_threshold`,`ms`.`description` AS `description`,count(`sl`.`id`) AS `blocks_total`,count((case when (`sl`.`created_at` >= (now() - interval 7 day)) then 1 end)) AS `blocks_last_7d`,count((case when (`sl`.`created_at` >= (now() - interval 30 day)) then 1 end)) AS `blocks_last_30d` from (`moderation_settings` `ms` left join `system_logs` `sl` on(((`sl`.`action` in ('fail_blocked_moderation','comment_blocked_moderation')) and (`sl`.`details` like concat('%',`ms`.`category`,'%'))))) group by `ms`.`id`,`ms`.`category`,`ms`.`enabled`,`ms`.`severity_threshold`,`ms`.`description` */;


