--
-- Host: localhost    Database: faildaily
-- ------------------------------------------------------


--
-- Table structure for table `badge_definitions`
--

CREATE TABLE `badge_definitions` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rarity` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `requirement_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `requirement_value` int NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_badge_definitions_category` (`category`),
  KEY `idx_badge_definitions_rarity` (`rarity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `badge_definitions`
--

INSERT INTO `badge_definitions` VALUES ('active-member','Membre Actif','Se connecter 100 jours non-consécutifs','person-outline','PERSEVERANCE','rare','login_days',100,'2025-08-08 16:34:14'),('all-categories','Touche-à-tout','Poster un fail dans chaque catégorie','apps-outline','SPECIAL','epic','categories_used',5,'2025-08-10 13:58:59'),('beta-tester','Testeur Bêta','Participer à la phase de test','construct-outline','SPECIAL','epic','beta_participation',1,'2025-08-08 16:34:14'),('birthday-badge','Anniversaire FailDaily','Être présent lors de l\'anniversaire de l\'app','gift-outline','SPECIAL','rare','anniversary_participation',1,'2025-08-08 16:34:14'),('bounce-back','Rebond','Se relever après un fail difficile','arrow-up-outline','RESILIENCE','common','bounce_back_count',1,'2025-08-08 16:34:14'),('class-clown','Rigolo de Service','Recevoir 100 réactions de rire au total','musical-note-outline','HUMOUR','rare','total_laughs',100,'2025-08-08 16:34:14'),('comeback-king','Roi du Comeback','Reprendre après une pause de 30 jours','refresh-outline','PERSEVERANCE','rare','comeback_count',1,'2025-08-08 16:34:14'),('comedian','Comédien','Un fail qui a fait rire 50 personnes','theater-outline','HUMOUR','rare','laugh_reactions',50,'2025-08-08 16:34:14'),('community-helper','Assistant Communautaire','Aider 10 membres de la communauté','people-outline','ENTRAIDE','rare','help_count',10,'2025-08-08 16:34:14'),('community-pillar','Pilier de la Communauté','Être actif pendant 6 mois consécutifs','home-outline','ENTRAIDE','legendary','active_months',6,'2025-08-08 16:34:14'),('courage-hearts-10','Cœur Brave','Recevoir 10 cœurs de courage','heart-outline','COURAGE','common','reactions_received',10,'2025-08-08 16:34:14'),('courage-hearts-100','Héros du Courage','Recevoir 100 cœurs de courage','medal-outline','COURAGE','epic','reactions_received',100,'2025-08-08 16:34:14'),('courage-hearts-50','Cœur Courageux','Recevoir 50 cœurs de courage','heart-outline','COURAGE','rare','reactions_received',50,'2025-08-08 16:34:14'),('courage-hearts-500','Légende du Courage','Recevoir 500 cœurs de courage','trophy-outline','COURAGE','legendary','reactions_received',500,'2025-08-08 16:34:14'),('daily-streak-100','Centurion','100 jours de partage consécutifs','shield-outline','PERSEVERANCE','epic','streak_days',100,'2025-08-08 16:34:14'),('daily-streak-14','Déterminé','14 jours de partage consécutifs','flame-outline','PERSEVERANCE','rare','streak_days',14,'2025-08-08 16:34:14'),('daily-streak-3','Régulier','3 jours de partage consécutifs','checkmark-outline','PERSEVERANCE','common','streak_days',3,'2025-08-08 16:34:14'),('daily-streak-30','Marathonien','30 jours de partage consécutifs','fitness-outline','PERSEVERANCE','rare','streak_days',30,'2025-08-08 16:34:14'),('daily-streak-365','Immortel','365 jours de partage consécutifs','infinite-outline','PERSEVERANCE','legendary','streak_days',365,'2025-08-08 16:34:14'),('daily-streak-60','Titan de la Régularité','60 jours de partage consécutifs','barbell-outline','PERSEVERANCE','epic','streak_days',60,'2025-08-08 16:34:14'),('daily-streak-7','Persévérant','7 jours de partage consécutifs','calendar-outline','PERSEVERANCE','common','streak_days',7,'2025-08-08 16:34:14'),('discussion-starter','Lanceur de Débats','Créer 25 discussions populaires','chatbubbles-outline','ENTRAIDE','epic','popular_discussions',25,'2025-08-08 16:34:14'),('early-adopter','Pionnier','Membre des 1000 premiers utilisateurs','flag-outline','SPECIAL','legendary','user_rank',1000,'2025-08-08 16:34:14'),('empathy-expert','Expert en Empathie','Donner 25 réactions d\'empathie','sad-outline','ENTRAIDE','common','empathy_given',25,'2025-08-08 16:34:14'),('fail-master-365','Chroniqueur Légendaire','Partager 365 fails (un an !)','calendar-number-outline','COURAGE','legendary','fail_count',365,'2025-08-08 16:34:14'),('fails-10','Courageux','Poster 10 fails','trophy-outline','COURAGE','rare','fail_count',10,'2025-08-10 13:58:59'),('fails-100','Légende du Courage','Poster 100 fails','diamond-outline','COURAGE','legendary','fail_count',100,'2025-08-10 13:58:59'),('fails-25','Maître du Courage','Poster 25 fails','star-outline','COURAGE','epic','fail_count',25,'2025-08-10 13:58:59'),('fails-5','Apprenti Courage','Poster 5 fails','ribbon-outline','COURAGE','common','fail_count',5,'2025-08-10 13:58:59'),('fails-50','Vétéran du Courage','Poster 50 fails','shield-outline','COURAGE','epic','fail_count',50,'2025-08-10 13:58:59'),('first-fail','Premier Pas','Félicitations pour votre premier fail partagé !','footsteps-outline','COURAGE','common','fail_count',1,'2025-08-08 16:22:31'),('first-reaction','Première Réaction','Recevoir votre première réaction','heart-outline','COURAGE','common','first_reaction',1,'2025-08-08 16:43:44'),('funny-fail','Comédien Amateur','Un fail qui a fait rire 25 personnes','happy-outline','HUMOUR','common','laugh_reactions',25,'2025-08-08 16:34:14'),('globetrotter','Globe-Trotter','Partager des fails de 10 pays différents','airplane-outline','SPECIAL','legendary','countries_count',10,'2025-08-08 16:34:14'),('good-vibes','Bonnes Vibrations','Donner 1000 réactions positives au total','thumbs-up-outline','ENTRAIDE','epic','positive_reactions',1000,'2025-08-08 16:34:14'),('guardian-angel','Ange Gardien','Aider 25 membres de la communauté','medical-outline','ENTRAIDE','epic','help_count',25,'2025-08-08 16:34:14'),('holiday-spirit','Esprit des Fêtes','Partager pendant les vacances','snow-outline','SPECIAL','rare','holiday_fails',5,'2025-08-08 16:34:14'),('humor-king','Roi du Rire','Un fail qui a fait rire 100 personnes','sparkles-outline','HUMOUR','epic','laugh_reactions',100,'2025-08-08 16:34:14'),('inspiration','Source d\'Inspiration','Inspirer 100 autres utilisateurs','bulb-outline','RESILIENCE','legendary','inspired_users',100,'2025-08-08 16:34:14'),('iron-will','Volonté de Fer','Repartager après 10 échecs consécutifs','hammer-outline','PERSEVERANCE','legendary','resilience_count',10,'2025-08-08 16:34:14'),('laughter-legend','Légende du Rire','Recevoir 1000 réactions de rire au total','star-outline','HUMOUR','legendary','total_laughs',1000,'2025-08-08 16:34:14'),('life-coach','Coach de Vie','Aider 100 personnes avec des conseils','fitness-outline','ENTRAIDE','legendary','advice_given',100,'2025-08-08 16:34:14'),('mentor','Mentor','Commenter constructivement 100 fails','chatbox-outline','ENTRAIDE','rare','helpful_comments',100,'2025-08-08 16:34:14'),('midnight-warrior','Guerrier de Minuit','Partager un fail après minuit','moon-outline','SPECIAL','common','midnight_fail',1,'2025-08-08 16:34:14'),('mood-lifter','Remonteur de Moral','50 fails marqués comme \"drôles\"','sunny-outline','HUMOUR','epic','funny_fails',50,'2025-08-08 16:34:14'),('never-give-up','Jamais Abandonner','Maintenir 5 streaks de plus de 7 jours','flag-outline','PERSEVERANCE','epic','long_streaks',5,'2025-08-08 16:34:14'),('new-year-resolution','Résolution du Nouvel An','Partager un fail le 1er janvier','calendar-outline','SPECIAL','rare','new_year_fail',1,'2025-08-08 16:34:14'),('phoenix','Phénix','Renaître de 10 échecs majeurs','flame-outline','RESILIENCE','epic','major_comebacks',10,'2025-08-08 16:34:14'),('power-user','Utilisateur Expert','Utiliser toutes les fonctionnalités de l\'app','settings-outline','SPECIAL','epic','features_used',10,'2025-08-08 16:34:14'),('reactions-10','Supporteur','Donner 10 réactions','people-outline','ENTRAIDE','common','reaction_given',10,'2025-08-10 13:58:59'),('reactions-100','Super Supporteur','Donner 100 réactions','heart-circle-outline','ENTRAIDE','epic','reaction_given',100,'2025-08-10 13:58:59'),('reactions-25','Supporteur Actif','Donner 25 réactions','heart-half-outline','ENTRAIDE','common','reaction_given',25,'2025-08-10 13:58:59'),('reactions-250','Maître du Support','Donner 250 réactions','heart-half-outline','ENTRAIDE','legendary','reaction_given',250,'2025-08-10 13:58:59'),('reactions-50','Grand Supporteur','Donner 50 réactions','heart','ENTRAIDE','rare','reaction_given',50,'2025-08-10 13:58:59'),('resilience-champion','Champion de Résilience','Partager 20 fails de résilience','refresh-outline','RESILIENCE','rare','resilience_fails',20,'2025-08-08 16:34:14'),('resilience-rookie','Apprenti Résilient','Partager 5 fails de résilience','leaf-outline','RESILIENCE','common','resilience_fails',5,'2025-08-08 16:34:14'),('socializer','Sociable','Interagir avec 50 utilisateurs différents','people-circle-outline','ENTRAIDE','rare','unique_interactions',50,'2025-08-08 16:34:14'),('stand-up-master','Maître du Stand-Up','Recevoir 500 réactions de rire au total','mic-outline','HUMOUR','epic','total_laughs',500,'2025-08-08 16:34:14'),('supportive-soul','Âme Bienveillante','Donner 50 réactions de soutien','heart-half-outline','ENTRAIDE','common','support_given',50,'2025-08-08 16:34:14'),('survivor','Survivant','Surmonter 50 défis personnels','shield-checkmark-outline','RESILIENCE','legendary','challenges_overcome',50,'2025-08-08 16:34:14'),('trend-setter','Créateur de Tendances','Lancer 5 tendances dans la communauté','trending-up-outline','SPECIAL','legendary','trends_created',5,'2025-08-08 16:34:14'),('unbreakable','Incassable','Maintenir un état d\'esprit positif 100 jours','diamond-outline','RESILIENCE','epic','positive_days',100,'2025-08-08 16:34:14'),('viral-laugh','Sensation Virale','Un fail qui a fait rire 500 personnes','trending-up-outline','HUMOUR','legendary','laugh_reactions',500,'2025-08-08 16:34:14'),('weekend-warrior','Guerrier du Weekend','Partager 50 fails le weekend','bicycle-outline','SPECIAL','rare','weekend_fails',50,'2025-08-08 16:34:14'),('wise-counselor','Conseiller Sage','Commenter constructivement 250 fails','library-outline','ENTRAIDE','epic','helpful_comments',250,'2025-08-08 16:34:14');

--
-- Table structure for table `comment_moderation`
--

CREATE TABLE `comment_moderation` (
  `comment_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('under_review','hidden','approved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'under_review',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`comment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment_moderation`
--

INSERT INTO `comment_moderation` VALUES ('2de94425-b0cd-4466-b026-a72f0747af94','hidden','2025-08-26 13:19:58','2025-08-26 13:19:58'),('null','approved','2025-08-26 13:20:12','2025-08-26 13:20:12');

--
-- Table structure for table `comment_reactions`
--

CREATE TABLE `comment_reactions` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_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,
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'like',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_comment_user` (`comment_id`,`user_id`),
  KEY `idx_comment` (`comment_id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment_reactions`
--


--
-- Table structure for table `comment_reports`
--

CREATE TABLE `comment_reports` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment_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,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_report_comment_user` (`comment_id`,`user_id`),
  KEY `idx_comment` (`comment_id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comment_reports`
--

INSERT INTO `comment_reports` VALUES ('a9616206-a684-46de-b8c4-1a7a08ae05cc','2de94425-b0cd-4466-b026-a72f0747af94','9f92d99e-5f70-427e-aebd-68ca8b727bd4',NULL,'2025-08-26 13:19:58');

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fail_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,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_encouragement` 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`),
  KEY `idx_comments_fail_id` (`fail_id`),
  KEY `comments_user_id_fkey` (`user_id`),
  CONSTRAINT `comments_fail_id_fkey` FOREIGN KEY (`fail_id`) REFERENCES `fails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `comments_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 `comments`
--

INSERT INTO `comments` VALUES ('2de94425-b0cd-4466-b026-a72f0747af94','965883d5-c51b-4ccb-a7e4-e90aecc49016','9f92d99e-5f70-427e-aebd-68ca8b727bd4','nouveau commenatire',1,'2025-08-26 11:06:46','2025-08-26 11:06:46'),('49116b23-f484-4ed1-a782-f8f18d289847','85efade8-0857-40a9-a790-8253c270157f','9f92d99e-5f70-427e-aebd-68ca8b727bd4','test',1,'2025-08-26 10:53:49','2025-08-26 10:53:49'),('72aa00ee-8d9d-4367-9200-a69ea65ca502','0f29dcc0-0b48-47cd-b0c5-dd1adc225198','814b7d10-b3d4-4921-ab47-a388bec6c7fb','zzzzz',1,'2025-09-02 08:44:42','2025-09-02 08:44:42'),('9e3c449e-3ec1-44b8-9963-adbb57fa1e0b','85efade8-0857-40a9-a790-8253c270157f','9f92d99e-5f70-427e-aebd-68ca8b727bd4','test',1,'2025-08-26 10:57:58','2025-08-26 10:57:58'),('bc4fe6ed-0cab-44d2-a5e8-a6cee2a04889','965883d5-c51b-4ccb-a7e4-e90aecc49016','9f92d99e-5f70-427e-aebd-68ca8b727bd4','tyui',1,'2025-08-26 11:03:13','2025-08-26 11:03:13'),('c47f4366-7a2f-4c43-a252-89e55e791181','bb77e2b0-8576-4984-9ebc-29d8262d5741','9f92d99e-5f70-427e-aebd-68ca8b727bd4','azdeferzf',1,'2025-09-05 12:58:43','2025-09-05 12:58:43');

--
-- Table structure for table `fail_moderation`
--

CREATE TABLE `fail_moderation` (
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('under_review','hidden','approved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'under_review',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`fail_id`),
  CONSTRAINT `fk_fail_moderation_fail` FOREIGN KEY (`fail_id`) REFERENCES `fails` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fail_moderation`
--

INSERT INTO `fail_moderation` VALUES ('0f29dcc0-0b48-47cd-b0c5-dd1adc225198','approved','2025-09-05 12:05:32','2025-09-05 12:05:32'),('bb77e2b0-8576-4984-9ebc-29d8262d5741','approved','2025-09-05 12:58:34','2025-09-05 12:58:34');

--
-- Table structure for table `fail_reactions_archive`
--

CREATE TABLE `fail_reactions_archive` (
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reactions_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `archived_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`fail_id`),
  KEY `idx_archived_at` (`archived_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fail_reactions_archive`
--

INSERT INTO `fail_reactions_archive` VALUES ('0f29dcc0-0b48-47cd-b0c5-dd1adc225198','{\"laugh\": 0, \"courage\": 0, \"empathy\": 0, \"support\": 0}','2025-08-27 09:05:38'),('85efade8-0857-40a9-a790-8253c270157f','{\"laugh\": 0, \"courage\": 0, \"empathy\": 0, \"support\": 0}','2025-08-27 09:05:38'),('965883d5-c51b-4ccb-a7e4-e90aecc49016','{\"laugh\": 0, \"courage\": 0, \"empathy\": 0, \"support\": 0}','2025-08-27 09:05:38');

--
-- Table structure for table `fail_reports`
--

CREATE TABLE `fail_reports` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fail_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,
  `reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_fail_report` (`fail_id`,`user_id`),
  KEY `idx_fail_reports_fail` (`fail_id`),
  KEY `idx_fail_reports_user` (`user_id`),
  CONSTRAINT `fk_fail_reports_fail` FOREIGN KEY (`fail_id`) REFERENCES `fails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_fail_reports_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `fail_reports`
--

INSERT INTO `fail_reports` VALUES ('58fad36e-4376-4b9b-a51e-89204c21cb28','bb77e2b0-8576-4984-9ebc-29d8262d5741','9f92d99e-5f70-427e-aebd-68ca8b727bd4',NULL,'2025-09-05 12:58:27'),('cc358d5d-28ae-4d95-9aa1-121bd3426437','0f29dcc0-0b48-47cd-b0c5-dd1adc225198','9f92d99e-5f70-427e-aebd-68ca8b727bd4',NULL,'2025-09-05 12:05:23');

--
-- Table structure for table `fails`
--

CREATE TABLE `fails` (
  `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,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_anonyme` tinyint(1) DEFAULT '1',
  `comments_count` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_fails_user_id` (`user_id`),
  KEY `idx_fails_created_at` (`created_at`),
  CONSTRAINT `fails_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 `fails`
--

INSERT INTO `fails` VALUES ('0f29dcc0-0b48-47cd-b0c5-dd1adc225198','814b7d10-b3d4-4921-ab47-a388bec6c7fb','fails test 1 : jeudi adulte test 1','poste du premie fails','humour',NULL,0,1,'2025-08-21 09:51:05','2025-09-02 08:44:42'),('163e58c9-ca4e-4af2-88de-ece06cc678e1','9f92d99e-5f70-427e-aebd-68ca8b727bd4','eryv jggik hfykb','ivuxkvuc ugivu. 8g8h','perseverance',NULL,0,0,'2025-09-05 21:34:23','2025-09-05 21:34:23'),('2d55f82e-8ba2-4189-a897-a1a588eaff95','9f92d99e-5f70-427e-aebd-68ca8b727bd4','dddddddddddddd','ddddddddddddddddd','special',NULL,0,0,'2025-09-03 11:34:44','2025-09-03 11:34:44'),('3577b475-85a3-4d21-b6cf-51df98450772','9f92d99e-5f70-427e-aebd-68ca8b727bd4','test voir si auto valider ou non','je verifie si mon fail peut etre signalé ou non','cuisine',NULL,0,0,'2025-09-03 11:54:19','2025-09-03 11:54:19'),('62b3be3e-c742-4eb2-b7b2-d5f012812633','9f92d99e-5f70-427e-aebd-68ca8b727bd4','pablo','azdgrtyjrtyhdrsgerzg','bricolage',NULL,0,0,'2025-09-05 12:59:15','2025-09-05 12:59:15'),('85efade8-0857-40a9-a790-8253c270157f','57a2560d-b065-44f3-96c8-3b0d2e5b569b','samedi test fails anonyme 1','je cree cette fois ci un fails en anonyme dans la categorie sprot','sport',NULL,1,2,'2025-08-23 08:18:57','2025-08-26 12:54:22'),('965883d5-c51b-4ccb-a7e4-e90aecc49016','57a2560d-b065-44f3-96c8-3b0d2e5b569b','samedi test fails public 1','je vais rentrer un fails en public pour que pseudo et avatar soit afficher, cree categorie technologie','technologie',NULL,0,2,'2025-08-23 08:17:15','2025-08-26 12:54:13'),('a490ccd7-ba67-47cb-ad30-aeb08f1be8c8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','zzzzzzzzzzzzzzz','aaaaaaaaaaaaaaaaa','special',NULL,0,0,'2025-09-03 11:55:06','2025-09-03 11:55:06'),('b7737594-7fe3-4894-966e-4a785d5d7832','9f92d99e-5f70-427e-aebd-68ca8b727bd4','test badges 2','deuxieme test','travail',NULL,0,0,'2025-09-03 11:26:41','2025-09-03 11:26:41'),('bb77e2b0-8576-4984-9ebc-29d8262d5741','9f92d99e-5f70-427e-aebd-68ca8b727bd4','new test badges et validation','je devrais recevoir le badges des 5 fails e tpas de validation automatique','transport',NULL,0,1,'2025-09-03 12:05:07','2025-09-05 12:58:43');

--
-- Table structure for table `legal_documents`
--

CREATE TABLE `legal_documents` (
  `id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `version` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type` enum('terms','privacy','community_rules','data_policy') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_required` tinyint(1) DEFAULT '1',
  `is_active` 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`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `legal_documents`
--

INSERT INTO `legal_documents` VALUES ('1467b3d1-7a0d-11f0-b0ea-345a608f406b','Conditions d\'utilisation','Conditions générales d\'utilisation de FailDaily...','1.0','terms',1,1,'2025-08-15 19:21:44','2025-08-15 19:21:44'),('14687bb6-7a0d-11f0-b0ea-345a608f406b','Politique de confidentialité','Politique de protection des données personnelles...','1.0','privacy',1,1,'2025-08-15 19:21:44','2025-08-15 19:21:44'),('14688815-7a0d-11f0-b0ea-345a608f406b','Règles de la communauté','Règles de conduite et modération de la communauté...','1.0','community_rules',1,1,'2025-08-15 19:21:44','2025-08-15 19:21:44'),('1468b92e-7a0d-11f0-b0ea-345a608f406b','Politique des données','Comment nous collectons et utilisons vos données...','1.0','data_policy',1,1,'2025-08-15 19:21:44','2025-08-15 19:21:44');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `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,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `bio` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `registration_completed` tinyint(1) DEFAULT '0',
  `legal_consent` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `age_verification` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `preferences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `stats` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci COMMENT 'JSON data',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `username` (`username`),
  CONSTRAINT `profiles_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 `profiles`
--

INSERT INTO `profiles` VALUES ('12811165-7e6c-11f0-b1c5-345a608f406b','814b7d10-b3d4-4921-ab47-a388bec6c7fb',NULL,'jeudi test adulte 1','assets/profil/face.png',NULL,1,'{\"birthDate\":\"1981-08-20\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-21T08:51:48.030Z\"}','{\"birthDate\":\"1981-08-20\",\"age\":44,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-21 08:51:48','2025-09-02 08:46:51'),('1437f075-7f4b-11f0-b1c5-345a608f406b','5efe0f4e-ea21-4418-9e15-5e361c43b3f8',NULL,'Test Public User',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-22T11:28:08.642Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-22 11:28:08','2025-08-22 11:28:08'),('19e041cf-8713-11f0-b1c5-345a608f406b','293c74c1-371b-45e0-b548-77dff333b8e9',NULL,'User 1756717654854-edit','/uploads/avatars/avatar-293c74c1-371b-45e0-b548-77dff333b8e9-1756717656984-927346697.png','Bio e2e',1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:35.631Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:35','2025-09-01 09:07:36'),('1b5eb3e3-8713-11f0-b1c5-345a608f406b','58570b71-7bde-4266-b35c-03e59c0f82e7',NULL,'AdminTmp',NULL,NULL,1,'{\"birthDate\":\"1988-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:38.172Z\"}','{\"birthDate\":\"1988-01-01\",\"age\":37,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:38','2025-09-01 09:07:38'),('1c0c4e2c-8713-11f0-b1c5-345a608f406b','33e10cbd-a3cf-4259-8098-f3b33e3ec8bc',NULL,'Teen',NULL,NULL,0,'{\"birthDate\":\"2010-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:39.313Z\"}','{\"birthDate\":\"2010-01-01\",\"age\":15,\"verified\":true,\"needsParentalConsent\":true,\"parentalConsentStatus\":\"rejected\",\"parentalApprovedAt\":\"2025-09-01T09:07:39.340Z\",\"parentalRevokedAt\":\"2025-09-01T09:07:39.380Z\",\"parentalRejectedAt\":\"2025-09-01T09:07:39.434Z\"}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:39','2025-09-01 09:07:39'),('1cb0c593-8713-11f0-b1c5-345a608f406b','4ede043a-da02-4f5b-aa4c-c45bee9a714a',NULL,'AdminC',NULL,NULL,1,'{\"birthDate\":\"1986-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:40.381Z\"}','{\"birthDate\":\"1986-01-01\",\"age\":39,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:40','2025-09-01 09:07:40'),('1d4c32ad-8713-11f0-b1c5-345a608f406b','ae6d53e7-9ab0-4b49-ada8-86bd09d48e6f',NULL,'TeenC',NULL,NULL,1,'{\"birthDate\":\"2010-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:41.412Z\"}','{\"birthDate\":\"2010-01-01\",\"age\":15,\"verified\":true,\"needsParentalConsent\":false,\"parentalConsentStatus\":\"approved\",\"parentalApprovedAt\":\"2025-09-01T09:07:41.454Z\"}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:41','2025-09-01 09:07:41'),('1deb4199-8713-11f0-b1c5-345a608f406b','a66d8aa0-3ce4-49e7-ac31-2b2f3ca8693c',NULL,'Test User 1756717662014',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:42.450Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:42','2025-09-01 09:07:42'),('1e9547d2-8713-11f0-b1c5-345a608f406b','19261451-4bec-46df-947b-ed2a111c0801',NULL,'AdminIS',NULL,NULL,1,'{\"birthDate\":\"1985-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:43.566Z\"}','{\"birthDate\":\"1985-01-01\",\"age\":40,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:43','2025-09-01 09:07:43'),('1f24382e-8713-11f0-b1c5-345a608f406b','2030c326-c4fc-45dd-a8f3-f941e0aa8dea',NULL,'U1',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:44.506Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:44','2025-09-01 09:07:44'),('1f5eeb98-8713-11f0-b1c5-345a608f406b','afb563b2-ec82-491f-b8ff-39fd35f30833',NULL,'U2',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:44.890Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:44','2025-09-01 09:07:44'),('1fd585b6-8713-11f0-b1c5-345a608f406b','bea3f8c3-f962-48ac-891a-604f278cdb09',NULL,'U15',NULL,NULL,0,'{\"birthDate\":\"2010-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:45.666Z\"}','{\"birthDate\":\"2010-01-01\",\"age\":15,\"verified\":true,\"needsParentalConsent\":true,\"parentalConsentStatus\":\"pending\"}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:45','2025-09-01 09:07:45'),('2031e8f3-8713-11f0-b1c5-345a608f406b','6b7baec3-c870-4f1d-a256-45d31ed5f893',NULL,'Adult',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:46.273Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:46','2025-09-01 09:07:46'),('20a305a7-8713-11f0-b1c5-345a608f406b','9d774ace-1dff-4ac9-8091-66e84e57a516',NULL,'AdminUser',NULL,NULL,1,'{\"birthDate\":\"1988-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:47.013Z\"}','{\"birthDate\":\"1988-01-01\",\"age\":37,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:47','2025-09-01 09:07:47'),('2135583d-8713-11f0-b1c5-345a608f406b','957f8d77-8311-4377-b3fc-b9b53ab29beb',NULL,'TeenUser',NULL,NULL,0,'{\"birthDate\":\"2010-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:47.974Z\"}','{\"birthDate\":\"2010-01-01\",\"age\":15,\"verified\":true,\"needsParentalConsent\":true,\"parentalConsentStatus\":\"pending\"}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:47','2025-09-01 09:07:47'),('21a44a27-8713-11f0-b1c5-345a608f406b','12c637c8-450c-4159-9beb-817aca67e9a1',NULL,'AdminF',NULL,NULL,1,'{\"birthDate\":\"1987-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:48.699Z\"}','{\"birthDate\":\"1987-01-01\",\"age\":38,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:48','2025-09-01 09:07:48'),('224cd6eb-8713-11f0-b1c5-345a608f406b','4919f0d5-91e1-4956-9698-c440aeea22f5',NULL,'TeenF',NULL,NULL,0,'{\"birthDate\":\"2010-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:07:49.805Z\"}','{\"birthDate\":\"2010-01-01\",\"age\":15,\"verified\":true,\"needsParentalConsent\":true,\"parentalConsentStatus\":\"pending\"}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:07:49','2025-09-01 09:07:49'),('25f1d946-8726-11f0-b1c5-345a608f406b','964e2edd-34d2-4a2d-a7a5-132b8bf5c4db',NULL,'TestUser1756725835755',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:23:56.357Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:23:56','2025-09-01 11:23:56'),('36b81632-8184-11f0-b1c5-345a608f406b','3eec9236-40db-46ca-ae18-9b089bef0e75',NULL,'Lundi 25 test 1',NULL,NULL,1,'{\"birthDate\":\"1981-08-20\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-25T07:22:10.188Z\"}','{\"birthDate\":\"1981-08-20\",\"age\":44,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-25 07:22:10','2025-08-25 07:22:10'),('3bc1e005-8715-11f0-b1c5-345a608f406b','2212f5ba-bfe1-4241-b275-42771e59479c',NULL,'User 1756718570811-edit','/uploads/avatars/avatar-2212f5ba-bfe1-4241-b275-42771e59479c-1756718572572-645623208.png','Bio e2e',1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:22:51.502Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:22:51','2025-09-01 09:22:52'),('3d8f0774-8715-11f0-b1c5-345a608f406b','fc91570c-8955-48ba-b4d6-9833ff4e5b4f',NULL,'Test User 1756718574108',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:22:54.530Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:22:54','2025-09-01 09:22:54'),('3e2279d9-872b-11f0-b1c5-345a608f406b','4780ee5f-c43d-4bfb-9add-72a1e6650552',NULL,'TestUser1756728023447',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T12:00:24.422Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 12:00:24','2025-09-01 12:00:24'),('56070d3d-8198-11f0-b1c5-345a608f406b','411dd9ff-9673-48c9-838a-50b49074fff0',NULL,'Test User',NULL,NULL,1,'{\"birthDate\":null,\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-25T09:46:12.674Z\"}','{\"birthDate\":null,\"age\":null,\"verified\":false}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-25 09:46:12','2025-08-25 09:46:12'),('5b51d48d-8250-11f0-b1c5-345a608f406b','9f92d99e-5f70-427e-aebd-68ca8b727bd4',NULL,'Taaazzz','assets/profil/face.png',NULL,1,'{\"birthDate\":\"1981-08-20\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-26T07:43:28.943Z\"}','{\"birthDate\":\"1981-08-20\",\"age\":44,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 8.0}','2025-08-26 07:43:28','2025-09-01 12:22:51'),('786dbb58-8726-11f0-b1c5-345a608f406b','6ab7b2cd-1de5-4e2f-9307-4322d425e4b4',NULL,'NewTestUser',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:26:14.741Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:26:14','2025-09-01 11:26:14'),('84c2554b-872a-11f0-b1c5-345a608f406b','52c50814-0c3d-4b34-a02f-eea3e37d159d',NULL,'TestUser1756727712652',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:55:13.417Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:55:13','2025-09-01 11:55:13'),('8f36231f-7fa0-11f0-b1c5-345a608f406b','57a2560d-b065-44f3-96c8-3b0d2e5b569b',NULL,'vendredi test 1',NULL,NULL,1,'{\"birthDate\":\"1981-08-20\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-22T21:40:02.257Z\"}','{\"birthDate\":\"1981-08-20\",\"age\":44,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-22 21:40:02','2025-08-22 21:40:02'),('925e7861-8724-11f0-b1c5-345a608f406b','3c08247a-be19-4c54-b703-96c8a8b7867f',NULL,'TestUser1756725158288',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:39.245Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:39','2025-09-01 11:12:39'),('935c4668-8724-11f0-b1c5-345a608f406b','5d79191e-ec05-40a0-a85f-ecc8b6287f94',NULL,'Test Login User 1756725160513',NULL,NULL,1,'{\"birthDate\":\"2000-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:40.933Z\"}','{\"birthDate\":\"2000-09-01\",\"age\":25,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:40','2025-09-01 11:12:40'),('96227d9d-8724-11f0-b1c5-345a608f406b','6b008c16-0b01-4b64-b3d0-f3c4e679a1e8',NULL,'Test JWT User 1756725165043',NULL,NULL,1,'{\"birthDate\":\"2003-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:45.587Z\"}','{\"birthDate\":\"2003-09-01\",\"age\":22,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:45','2025-09-01 11:12:45'),('990ad5f1-8724-11f0-b1c5-345a608f406b','5fea328a-4169-427f-b0b1-1c17e6511c5f',NULL,'Profile Updated 1756725170489',NULL,'Bio de test mise à jour',1,'{\"birthDate\":\"2000-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:50.465Z\"}','{\"birthDate\":\"2000-09-01\",\"age\":25,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:50','2025-09-01 11:12:50'),('9a0e8f56-8724-11f0-b1c5-345a608f406b','dde0e53b-b2f4-4c60-9141-6d0867d8a85f',NULL,'Avatar Test 1756725171521','/uploads/avatars/avatar-dde0e53b-b2f4-4c60-9141-6d0867d8a85f-1756725172189-430348131.png',NULL,1,'{\"birthDate\":\"1995-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:52.168Z\"}','{\"birthDate\":\"1995-09-01\",\"age\":30,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:52','2025-09-01 11:12:52'),('9b093c19-8724-11f0-b1c5-345a608f406b','7680bede-44ea-496a-9e31-5a2e060f25cf',NULL,'Upload Image Test 1756725173230',NULL,NULL,1,'{\"birthDate\":\"2003-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:53.810Z\"}','{\"birthDate\":\"2003-09-01\",\"age\":22,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:53','2025-09-01 11:12:53'),('9c00fe5d-8724-11f0-b1c5-345a608f406b','cd3cb757-9d12-4438-911f-0f9f2ac2ca95',NULL,'Test Fails User 1756725174849',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:55.434Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:55','2025-09-01 11:12:55'),('9d15bf18-8724-11f0-b1c5-345a608f406b','7e087b9c-2f45-4e77-8471-a6cebbf2de13',NULL,'Test Retrieval User 1756725176592',NULL,NULL,1,'{\"birthDate\":null,\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:57.247Z\"}','{\"birthDate\":null,\"verified\":false}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:57','2025-09-01 11:12:57'),('9e2bd86b-8724-11f0-b1c5-345a608f406b','f276cf04-dea1-4bb0-bd21-337d34749686',NULL,'CommentUser 1756725178537',NULL,NULL,1,'{\"birthDate\":\"2000-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:12:59.071Z\"}','{\"birthDate\":\"2000-09-01\",\"age\":25,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:12:59','2025-09-01 11:12:59'),('9f1993b1-8724-11f0-b1c5-345a608f406b','fda4cf09-0d1e-468c-8096-1caa46b782cc',NULL,'U Author 1756725180100',NULL,NULL,1,'{\"birthDate\":\"2000-09-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:13:00.628Z\"}','{\"birthDate\":\"2000-09-01\",\"age\":25,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:13:00','2025-09-01 11:13:00'),('a0223869-8724-11f0-b1c5-345a608f406b','e1da10bd-4b07-418d-9581-ea72e5b13a10',NULL,'Utilisateur Intégration Test 1756725181656',NULL,NULL,1,'{\"birthDate\":null,\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:13:02.362Z\"}','{\"birthDate\":null,\"verified\":false}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:13:02','2025-09-01 11:13:02'),('b41be59c-7f4c-11f0-b1c5-345a608f406b','d096d562-988d-44be-bd9a-55272e9ed9ff',NULL,'Test User 1755862785778',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-08-22T11:39:46.413Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-08-22 11:39:46','2025-08-22 11:39:46'),('ba5e93b3-8729-11f0-b1c5-345a608f406b','e10fbd52-b906-4504-8e13-7c7b7c451afa',NULL,'TestUser1756727373156',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:49:33.862Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:49:33','2025-09-01 11:49:33'),('e2cf9d6d-8716-11f0-b1c5-345a608f406b','75c74d79-8cda-4c6b-8c08-c0dfa06043ca',NULL,'User 1756719280609-edit','/uploads/avatars/avatar-75c74d79-8cda-4c6b-8c08-c0dfa06043ca-1756719282399-181412019.png','Bio e2e',1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:34:41.266Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:34:41','2025-09-01 09:34:42'),('e3fbb1df-8716-11f0-b1c5-345a608f406b','fe8d5a37-d3db-49dc-850e-532aae96868c',NULL,'Test User 1756719282631',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T09:34:43.240Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 09:34:43','2025-09-01 09:34:43'),('f59299f7-8729-11f0-b1c5-345a608f406b','2c735258-4f82-42cf-99ec-31b9939193b5',NULL,'TestUser1756727472430',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:51:13.189Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:51:13','2025-09-01 11:51:13'),('f9671155-88bd-11f0-b1c5-345a608f406b','79440d6f-4010-42f8-9e24-3371ee140cf3',NULL,'TestUser1756900995697',NULL,NULL,1,'{\"birthDate\":null,\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-03T12:03:16.291Z\"}','{\"birthDate\":null,\"verified\":false}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-03 12:03:16','2025-09-03 12:03:16'),('fe438482-872a-11f0-b1c5-345a608f406b','f78778ce-ed8f-4d6b-abad-2d8055bd923c',NULL,'TestUser1756727916408',NULL,NULL,1,'{\"birthDate\":\"1990-01-01\",\"agreeToTerms\":true,\"acceptedAt\":\"2025-09-01T11:58:37.266Z\"}','{\"birthDate\":\"1990-01-01\",\"age\":35,\"verified\":true}','{}','{\"badges\": [], \"totalFails\": 0, \"couragePoints\": 0}','2025-09-01 11:58:37','2025-09-01 11:58:37');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `profiles_before_insert` BEFORE INSERT ON `profiles` FOR EACH ROW BEGIN
    IF NEW.preferences IS NULL THEN
        SET NEW.preferences = '{}';
    END IF;
    IF NEW.stats IS NULL THEN
        SET NEW.stats = '{"badges": [], "totalFails": 0, "couragePoints": 0}';
    END IF;
END */;;
DELIMITER ;

--
-- Table structure for table `reaction_logs`
--

CREATE TABLE `reaction_logs` (
  `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,
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `fail_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fail_author_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reaction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `points_awarded` int DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ip_address` varchar(45) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reaction_logs`
--

INSERT INTO `reaction_logs` VALUES ('264c5a8f-009e-45eb-9569-fa9887497a10','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'bb77e2b0-8576-4984-9ebc-29d8262d5741','new test badges et validation','Taaazzz','courage',0,'2025-09-05 12:58:39','93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:58:39'),('42fc9eaa-4b22-4030-8c8d-d562e970e464','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'62b3be3e-c742-4eb2-b7b2-d5f012812633','pablo','Taaazzz','empathy',0,'2025-09-05 12:59:21','93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:59:21');

--
-- Table structure for table `reactions`
--

CREATE TABLE `reactions` (
  `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,
  `fail_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `reaction_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_fail_reaction` (`user_id`,`fail_id`),
  KEY `idx_reactions_fail_id` (`fail_id`),
  KEY `idx_reactions_user_id` (`user_id`),
  CONSTRAINT `reactions_fail_id_fkey` FOREIGN KEY (`fail_id`) REFERENCES `fails` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reactions_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 `reactions`
--

INSERT INTO `reactions` VALUES ('2040f91e-edf1-4cdf-99fa-c15d64cafc25','9f92d99e-5f70-427e-aebd-68ca8b727bd4','85efade8-0857-40a9-a790-8253c270157f','support','2025-09-01 12:22:17'),('325898c1-943e-4c4e-b2ae-99e69c813454','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bb77e2b0-8576-4984-9ebc-29d8262d5741','courage','2025-09-05 12:58:39'),('5c18bb2d-cd68-4b54-8045-aaaca336791c','814b7d10-b3d4-4921-ab47-a388bec6c7fb','0f29dcc0-0b48-47cd-b0c5-dd1adc225198','courage','2025-08-21 11:49:45'),('6e1276ea-7967-4051-a47d-28a9ecffb54d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','62b3be3e-c742-4eb2-b7b2-d5f012812633','empathy','2025-09-05 12:59:21'),('7ca813bf-c38a-43c9-9515-8746420de24c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','965883d5-c51b-4ccb-a7e4-e90aecc49016','empathy','2025-09-01 12:22:20'),('e6b1454e-2d89-4187-818c-9b6175709838','9f92d99e-5f70-427e-aebd-68ca8b727bd4','0f29dcc0-0b48-47cd-b0c5-dd1adc225198','empathy','2025-08-27 07:43:59'),('f80fb208-79a7-4a21-a7c3-e0bc9d27f6c0','57a2560d-b065-44f3-96c8-3b0d2e5b569b','965883d5-c51b-4ccb-a7e4-e90aecc49016','courage','2025-08-23 08:45:07');

--
-- 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`
--

INSERT INTO `system_logs` VALUES ('0088109b-8aa0-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 21:33:45','2025-09-05 21:33:45'),('00e88646-8aa0-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 21:33:46','2025-09-05 21:33:46'),('01478f25-8a58-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:23','2025-09-05 12:58:23'),('01621d88-8a58-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:23','2025-09-05 12:58:23'),('01906798-8a58-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:23','2025-09-05 12:58:23'),('03b4f99f-8a58-11f0-a2bd-46ed285863ba','warning','Fail reported','fail_report','{\"failId\":\"bb77e2b0-8576-4984-9ebc-29d8262d5741\",\"reason\":null,\"reports\":1,\"threshold\":3,\"autoHidden\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:27','2025-09-05 12:58:27'),('0b6239b6-8a58-11f0-a2bd-46ed285863ba','info','Reaction added','reaction_add','{\"failId\":\"bb77e2b0-8576-4984-9ebc-29d8262d5741\",\"reactionType\":\"courage\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:40','2025-09-05 12:58:40'),('0dae7853-8a58-11f0-a2bd-46ed285863ba','info','Comment added','comment_add','{\"commentId\":\"c47f4366-7a2f-4c43-a252-89e55e791181\",\"failId\":\"bb77e2b0-8576-4984-9ebc-29d8262d5741\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:58:43','2025-09-05 12:58:43'),('1761589a-8aa0-11f0-a2bd-46ed285863ba','info','Fail created','fail_create','{\"failId\":\"163e58c9-ca4e-4af2-88de-ece06cc678e1\",\"title\":\"eryv jggik hfykb\",\"category\":\"perseverance\",\"is_anonyme\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 21:34:24','2025-09-05 21:34:24'),('20e2207b-8a58-11f0-a2bd-46ed285863ba','info','Fail created','fail_create','{\"failId\":\"62b3be3e-c742-4eb2-b7b2-d5f012812633\",\"title\":\"pablo\",\"category\":\"bricolage\",\"is_anonyme\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:59:16','2025-09-05 12:59:16'),('246120d9-8a58-11f0-a2bd-46ed285863ba','info','Reaction added','reaction_add','{\"failId\":\"62b3be3e-c742-4eb2-b7b2-d5f012812633\",\"reactionType\":\"empathy\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:59:22','2025-09-05 12:59:22'),('50db50ed-8a54-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:31:58','2025-09-05 12:31:58'),('56589282-6d4a-4707-a1e4-fb8ce05a4f42','warning','Table badges vidée par admin','table_truncate','{\"tableName\":\"badges\",\"isAuthTable\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:03:29','2025-09-03 13:03:29'),('5d647912-69f5-4a6e-95c2-4fad78e92662','warning','Table user_badges vidée par admin','table_truncate','{\"tableName\":\"user_badges\",\"isAuthTable\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:05:46','2025-09-03 13:05:46'),('5e6c48b0-88c6-11f0-b1c5-345a608f406b','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:03:21','2025-09-03 13:03:21'),('719d3cf9-c20d-4007-ac01-babd8c7970a8','warning','Vidage en masse de 2/2 tables','bulk_truncate','{\"tables\":[\"user_preferences\",\"parental_consents\"],\"results\":[{\"table\":\"user_preferences\",\"success\":true},{\"table\":\"parental_consents\",\"success\":true}],\"isAuthTables\":true}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:03:13','2025-09-03 13:03:13'),('738f0ee9-8c86-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-08 07:35:54','2025-09-08 07:35:54'),('73c968e6-8c86-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-08 07:35:54','2025-09-08 07:35:54'),('87517aae-8a50-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"test@test.com\"}','411dd9ff-9673-48c9-838a-50b49074fff0','2025-09-05 12:04:52','2025-09-05 12:04:52'),('8dfa16b2-88c6-11f0-b1c5-345a608f406b','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:04:41','2025-09-03 13:04:41'),('90c96297-8a50-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:05:07','2025-09-05 12:05:07'),('90ff369c-8a50-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:05:08','2025-09-05 12:05:08'),('9a328474-8a50-11f0-a2bd-46ed285863ba','warning','Fail reported','fail_report','{\"failId\":\"0f29dcc0-0b48-47cd-b0c5-dd1adc225198\",\"reason\":null,\"reports\":1,\"threshold\":3,\"autoHidden\":false}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:05:23','2025-09-05 12:05:23'),('a4aee7dc-8a59-11f0-a2bd-46ed285863ba','info','User logout','user_logout',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 13:10:06','2025-09-05 13:10:06'),('a88b6e51-8a4e-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"test@test.com\"}','411dd9ff-9673-48c9-838a-50b49074fff0','2025-09-05 11:51:28','2025-09-05 11:51:28'),('b4803f12-88c6-11f0-b1c5-345a608f406b','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-03 13:05:46','2025-09-03 13:05:46'),('c2cd8490-8a52-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-05 12:20:50','2025-09-05 12:20:50'),('d5a359ed-8c93-11f0-a2bd-46ed285863ba','info','User login','user_login','{\"email\":\"bruno@taaazzz.be\"}','9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-08 09:11:42','2025-09-08 09:11:42'),('d5dc9b6a-8c93-11f0-a2bd-46ed285863ba','info','Profile fetched','profile_get',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-08 09:11:42','2025-09-08 09:11:42'),('e1c75c3b-8c87-11f0-a2bd-46ed285863ba','info','User logout','user_logout',NULL,'9f92d99e-5f70-427e-aebd-68ca8b727bd4','2025-09-08 07:46:08','2025-09-08 07:46:08');

--
-- 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 ('00686d54-602c-4e80-88bc-286c5f6c18cc','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:50:10','2025-08-21 09:50:10'),('013f4eb1-7fab-4de3-a4a7-844c75461bf0','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:38:53','2025-09-03 12:38:53'),('01432207-12ce-459e-909a-2e54f8e7ffb0','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 08:14:56','2025-08-26 08:14:56'),('0281f4a1-13e3-4e46-a641-ba4a534ec108','4919f0d5-91e1-4956-9698-c440aeea22f5','teen.1756717669234@test.local','TeenF','register','{\"email\":\"teen.1756717669234@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:49','2025-09-01 09:07:49'),('02af98ed-dd95-4dfb-be7a-2fb61217e9e0','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:06:00','2025-08-21 09:06:00'),('02b6ca6d-c284-43e0-9ca0-d084ba6f2926','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 11:07:01','2025-08-21 11:07:01'),('02e21c6c-9a1d-4fe2-a87d-b1ddeac6c36e','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:37:16','2025-08-21 09:37:16'),('03ea48f4-f152-44b5-ac32-e8d0eaa7c8a9','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-02 08:44:32','2025-09-02 08:44:32'),('055508f2-f76c-45e8-8922-e6230bd950b7','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-02 09:06:16','2025-09-02 09:06:16'),('07225c28-580c-48b3-a14d-d3ac9ba934ff','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','bb77e2b0-8576-4984-9ebc-29d8262d5741','courage','93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:58:40','2025-09-05 12:58:40'),('0af6b3bf-141c-44c4-846d-5f0881ebd1e8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:58:23','2025-09-05 12:58:23'),('10bd1386-cfa0-4c05-88a9-af857c097837','58570b71-7bde-4266-b35c-03e59c0f82e7','adm.1756717657387@test.local','AdminTmp','login','{\"email\":\"adm.1756717657387@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:38','2025-09-01 09:07:38'),('1201397e-0fa4-4e50-9034-46cd4ee731fe','f78778ce-ed8f-4d6b-abad-2d8055bd923c','test-1756727916408@example.com','TestUser1756727916408','register','{\"email\":\"test-1756727916408@example.com\"}',NULL,NULL,'::1','node-fetch','2025-09-01 11:58:37','2025-09-01 11:58:37'),('12d44d21-6252-41b5-a931-e2dc7ff914ce','2c735258-4f82-42cf-99ec-31b9939193b5','test-1756727472430@example.com','TestUser1756727472430','register','{\"email\":\"test-1756727472430@example.com\"}',NULL,NULL,'::1','node-fetch','2025-09-01 11:51:13','2025-09-01 11:51:13'),('13b80e09-57d4-4a6f-8fd6-8db0a4e63cfe','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-23 09:10:38','2025-08-23 09:10:38'),('13ba0ae1-5396-4253-90bc-d1530a1660e7','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-03 12:37:42','2025-09-03 12:37:42'),('13c6a03e-f45c-47c2-96bb-b9bb51acc4fc','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-08 07:35:54','2025-09-08 07:35:54'),('13dd5e81-f437-4742-96d8-638437c2fbe1','d096d562-988d-44be-bd9a-55272e9ed9ff','temp.test.1755862785778@test.local','Test User 1755862785778','register','{\"email\":\"temp.test.1755862785778@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-08-22 11:39:46','2025-08-22 11:39:46'),('1481a2e6-1475-4cd3-a63e-02885c1461d3','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 13:00:22','2025-09-03 13:00:22'),('15cca170-06f8-44eb-8122-b7a74d1b64b3','2212f5ba-bfe1-4241-b275-42771e59479c','e2e.1756718570811@journey.local','User 1756718570811','register','{\"email\":\"e2e.1756718570811@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:22:51','2025-09-01 09:22:51'),('15ec1792-aa4a-48fb-b283-85c8596d1cf0','52c50814-0c3d-4b34-a02f-eea3e37d159d','test-1756727712652@example.com','TestUser1756727712652','register','{\"email\":\"test-1756727712652@example.com\"}',NULL,NULL,'::1','node-fetch','2025-09-01 11:55:13','2025-09-01 11:55:13'),('18b4a727-9969-4466-916a-3e38c1353e74','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 07:54:09','2025-08-27 07:54:09'),('193f0312-3112-4edc-85ad-a3cf7b673d92','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 07:38:13','2025-08-27 07:38:13'),('199fe062-8395-4039-b102-3f1cd73e61b0','d096d562-988d-44be-bd9a-55272e9ed9ff','temp.test.1755862785778@test.local','Test User 1755862785778','login','{\"email\":\"temp.test.1755862785778@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-08-22 11:39:47','2025-08-22 11:39:47'),('1b01a4cb-eef8-4a13-aa5e-0aa5d6b5b27e','12c637c8-450c-4159-9beb-817aca67e9a1','adm.1756717668294@test.local','AdminF','login','{\"email\":\"adm.1756717668294@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:49','2025-09-01 09:07:49'),('1b22adb0-517b-4a13-afae-385579707b9e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:34:02','2025-09-03 12:34:02'),('1d1b2b83-e256-4c8b-85d4-eff7044df11b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:49:36','2025-09-03 12:49:36'),('20c945fa-4a7b-4e97-a64e-b7ae2be69c24','5efe0f4e-ea21-4418-9e15-5e361c43b3f8','test.public.1755862087925@example.com','Test Public User','register','{\"email\":\"test.public.1755862087925@example.com\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-08-22 11:28:08','2025-08-22 11:28:08'),('21311184-29b7-44af-b9c4-0279bba69956','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-01 12:33:46','2025-09-01 12:33:46'),('28ae6dd8-ad02-4e4a-9ffd-bf56b6599cd6','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 10:00:34','2025-08-21 10:00:34'),('290dcacf-92fa-42be-86e2-e426686ae922','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 10:53:01','2025-08-21 10:53:01'),('2ddd8fd2-e561-4770-800c-16a943b64cf1','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:50:30','2025-08-21 09:50:30'),('2f976084-f76b-4958-af31-59730c78e265','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee',NULL,'create_fail','{\"title\":\"samedi test fails public 1\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-23 08:17:15','2025-08-23 08:17:15'),('2fa2f2cb-e424-453d-9523-9138380f173e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 08:22:05','2025-08-26 08:22:05'),('3087c7c2-3ad0-426b-b5e1-afcf39aa1828','4780ee5f-c43d-4bfb-9add-72a1e6650552','test-1756728023447@example.com','TestUser1756728023447','register','{\"email\":\"test-1756728023447@example.com\"}',NULL,NULL,'::1','node-fetch','2025-09-01 12:00:24','2025-09-01 12:00:24'),('30ca79fe-d51f-46c2-ae88-39bfa3dc976e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 11:53:52','2025-08-26 11:53:52'),('33d33aea-9e1b-4dcf-9fbd-df3a863d35c9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','register','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 07:43:28','2025-08-26 07:43:28'),('34a01487-8ee6-479b-9730-c08ef080c0c9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 12:48:24','2025-08-27 12:48:24'),('34c21d16-673e-4692-931a-868f3f081267','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:44:09','2025-09-03 12:44:09'),('3693e545-73ba-4709-8a29-dfbcd9445deb','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:28:55','2025-08-21 09:28:55'),('36b466f4-1dcb-460d-b503-ef6b3003b43b','fc91570c-8955-48ba-b4d6-9833ff4e5b4f','temp.test.1756718574108@test.local','Test User 1756718574108','register','{\"email\":\"temp.test.1756718574108@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:22:54','2025-09-01 09:22:54'),('3ce575a3-85b8-4ab3-83c7-dacd4e739157','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 06:59:20','2025-08-27 06:59:20'),('3d2bb915-ebe5-4b45-ac42-2e5e47e8a7f8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:37:17','2025-09-03 12:37:17'),('3dd1f517-dd5b-41a7-890b-ae8d2cf0093a','e1da10bd-4b07-418d-9581-ea72e5b13a10','test.1756725181656@faildaily.com','Utilisateur Intégration Test 1756725181656','login','{\"email\":\"test.1756725181656@faildaily.com\"}',NULL,NULL,'::1','node','2025-09-01 11:13:02','2025-09-01 11:13:02'),('40f0037d-648c-4725-b184-f9d8626c5a8e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 13:30:13','2025-08-26 13:30:13'),('4399e570-014d-481d-8a5e-46712cfd22db','3eec9236-40db-46ca-ae18-9b089bef0e75','vfr@vfr.vfr','Lundi 25 test 1','register','{\"email\":\"vfr@vfr.vfr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-25 07:22:10','2025-08-25 07:22:10'),('44231b66-fae4-4fee-ab18-d85b60bdc4c5','a66d8aa0-3ce4-49e7-ac31-2b2f3ca8693c','temp.test.1756717662014@test.local','Test User 1756717662014','login','{\"email\":\"temp.test.1756717662014@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:42','2025-09-01 09:07:42'),('445605ab-055a-4b69-a5e9-ee11282e4bd5','6b008c16-0b01-4b64-b3d0-f3c4e679a1e8','test.1756725165043@faildaily.com','Test JWT User 1756725165043','login','{\"email\":\"test.1756725165043@faildaily.com\"}',NULL,NULL,'::1','node','2025-09-01 11:12:46','2025-09-01 11:12:46'),('44c8bf4b-3762-47a8-8898-009e8199dd27','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 11:49:42','2025-08-26 11:49:42'),('493f126f-3871-42c4-aa3b-17e3438a238b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','85efade8-0857-40a9-a790-8253c270157f','laugh','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-01 12:22:14','2025-09-01 12:22:14'),('4ad519c0-ea12-4ae8-88ac-f5f307f0051b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 07:10:08','2025-08-27 07:10:08'),('4bfe15b9-fad6-4b38-8629-b26097fd4963','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','curl/8.14.1','2025-09-03 12:38:37','2025-09-03 12:38:37'),('53e9a010-1971-4681-a0ff-864d1c5bd47a','afb563b2-ec82-491f-b8ff-39fd35f30833','u.1756717664526@test.local','U2','register','{\"email\":\"u.1756717664526@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:44','2025-09-01 09:07:44'),('540b775c-8016-4513-b397-f46e384332fb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:43:49','2025-08-27 08:43:49'),('54f3d2a9-2425-4fc7-8f75-b8ad028dc596','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 10:41:35','2025-08-21 10:41:35'),('555dc245-49ac-4464-ab9d-555e11d3013c','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-25 13:31:28','2025-08-25 13:31:28'),('57b1800b-3f16-4675-a946-9576d527fbbd','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 09:51:43','2025-08-27 09:51:43'),('592ab2fb-8670-47c8-b979-74fcd0c18cc7','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 12:01:56','2025-08-21 12:01:56'),('5dfcc9fb-869c-4d9e-b123-30f4fedf8619','fc91570c-8955-48ba-b4d6-9833ff4e5b4f','temp.test.1756718574108@test.local','Test User 1756718574108','login','{\"email\":\"temp.test.1756718574108@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:22:54','2025-09-01 09:22:54'),('5e86a708-c38a-4f58-80e5-e5a7ff1de6a3','411dd9ff-9673-48c9-838a-50b49074fff0','test@test.com','Test User','login','{\"email\":\"test@test.com\"}',NULL,NULL,'93.20.25.180','curl/8.14.1','2025-09-05 12:04:51','2025-09-05 12:04:51'),('5fbc6d36-7354-4af3-b32a-62578aa9405f','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 13:03:13','2025-09-03 13:03:13'),('6022ad7f-a4b6-4cc9-8a8d-7f06c98bcfbe','79440d6f-4010-42f8-9e24-3371ee140cf3','test-1756900995697@example.com','TestUser1756900995697','register','{\"email\":\"test-1756900995697@example.com\"}',NULL,NULL,'::1','','2025-09-03 12:03:16','2025-09-03 12:03:16'),('6051acf3-3654-40d4-a8fa-18c0807757a1','2030c326-c4fc-45dd-a8f3-f941e0aa8dea','u.1756717664095@test.local','U1','register','{\"email\":\"u.1756717664095@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:44','2025-09-01 09:07:44'),('63146e56-aa22-4428-b270-758cf27338bf','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','62b3be3e-c742-4eb2-b7b2-d5f012812633','empathy','93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:59:21','2025-09-05 12:59:21'),('648d2377-43c8-46b3-b044-a22b4e408499','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 12:05:07','2025-09-05 12:05:07'),('65654b58-2dd8-462b-b50d-150c3939969a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','85efade8-0857-40a9-a790-8253c270157f','courage','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 09:33:04','2025-08-27 09:33:04'),('7052dbe0-0d78-41d9-ab2c-96f1a0db6083','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 10:59:55','2025-08-21 10:59:55'),('717918fa-c190-4da9-af4f-8cd8d01b9504','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:15:06','2025-08-21 09:15:06'),('73c581ef-7d8a-449e-8402-49842ec8f920','a66d8aa0-3ce4-49e7-ac31-2b2f3ca8693c','temp.test.1756717662014@test.local','Test User 1756717662014','register','{\"email\":\"temp.test.1756717662014@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:42','2025-09-01 09:07:42'),('74be9599-6e82-43aa-a3c6-68a4874fca45','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 11:34:10','2025-08-26 11:34:10'),('782175cb-2458-4982-8e3f-a278d36cbf5d','6ab7b2cd-1de5-4e2f-9307-4322d425e4b4','newtest12345@test.com','NewTestUser','login','{\"email\":\"newtest12345@test.com\"}',NULL,NULL,'::1','curl/8.14.1','2025-09-01 11:26:29','2025-09-01 11:26:29'),('7a5e33eb-3490-4f6d-9572-1835b7d45944','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:10:32','2025-08-22 22:10:32'),('8053e109-961e-4d35-ab31-10570ed3efba','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 12:28:12','2025-08-27 12:28:12'),('80852f00-768c-499c-8c33-e18f25a9075c','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:28:43','2025-08-27 08:28:43'),('815f716c-a209-4ba4-8a6a-5cc115b8ec49','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee','vendredi test 1','register','{\"email\":\"tre@rte.ee\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 21:40:02','2025-08-22 21:40:02'),('81e73958-c7ca-4ff7-8157-8d2ad328b37d','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'78.123.96.159','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36','2025-09-05 21:33:45','2025-09-05 21:33:45'),('81f85dbc-494b-424f-81a3-01ea5e14aeb2','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 08:35:13','2025-08-26 08:35:13'),('83994a5f-6f19-4c7a-9f37-80c6f27b4ed7','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 11:15:02','2025-08-21 11:15:02'),('83bed0bc-dee5-44ce-b834-0a22011eb910','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-03 10:55:07','2025-09-03 10:55:07'),('85c0ccc2-4319-4d8d-a5ef-50fe1660c28d','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 11:41:42','2025-08-21 11:41:42'),('86fe16d9-86c3-4bcb-9ad1-2a1cf90ac354','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-25 08:47:47','2025-08-25 08:47:47'),('87b60d00-8523-4429-a596-e4eb62adf556','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 11:35:57','2025-08-26 11:35:57'),('8be4bdcb-5c25-47eb-9214-ce8113a19027','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','85efade8-0857-40a9-a790-8253c270157f','empathy','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:39:58','2025-08-27 11:39:58'),('8e72dede-d532-4812-880c-a85a5eac842d','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee','vendredi test 1','login','{\"email\":\"tre@rte.ee\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:28:20','2025-08-22 22:28:20'),('8f32ce86-e7d9-49f6-90a3-030d811b82a1','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','85efade8-0857-40a9-a790-8253c270157f','courage','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:39:56','2025-08-27 11:39:56'),('91eaa83f-2648-4567-990f-b2b31e0ff080','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 13:11:41','2025-08-26 13:11:41'),('91f5ec49-87b1-4c53-b788-a6f143814925','4ede043a-da02-4f5b-aa4c-c45bee9a714a','adm.1756717659772@test.local','AdminC','login','{\"email\":\"adm.1756717659772@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:41','2025-09-01 09:07:41'),('93d0c42c-1c35-4ee4-b47f-6a93e909b391','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 08:34:50','2025-08-26 08:34:50'),('93d5d2f5-a4bd-46e1-b5ec-2256ddbd3dbf','7e087b9c-2f45-4e77-8471-a6cebbf2de13','test.1756725176592@faildaily.com','Test Retrieval User 1756725176592','register','{\"email\":\"test.1756725176592@faildaily.com\"}',NULL,NULL,'::1','node','2025-09-01 11:12:57','2025-09-01 11:12:57'),('94809be8-9ede-4fc3-acaf-2b931b6c4ac9','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','85efade8-0857-40a9-a790-8253c270157f','empathy','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:33:45','2025-08-27 08:33:45'),('94b3b98f-3dab-4276-bf22-f3d3e7aff7c8','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-03 13:01:34','2025-09-03 13:01:34'),('967da4ad-7fd0-4ae6-b103-8bf47f312aa7','411dd9ff-9673-48c9-838a-50b49074fff0','test@test.com','Test User','register','{\"email\":\"test@test.com\"}',NULL,NULL,'::1','curl/8.14.1','2025-08-25 09:46:12','2025-08-25 09:46:12'),('9a1b99ca-ff9b-4e6d-a4f7-e264a5906c8a','2212f5ba-bfe1-4241-b275-42771e59479c','e2e.1756718570811@journey.local','User 1756718570811','login','{\"email\":\"e2e.1756718570811@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:22:52','2025-09-01 09:22:52'),('9b706e19-6112-4ff2-a3d9-e195b8a78a53','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:03:02','2025-08-22 22:03:02'),('9dbc1461-e95f-4703-819c-362b099f66e6','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-05 13:10:06','2025-09-05 13:10:06'),('9dc39c98-c8db-4040-8828-6741b1d4c1c3','e1da10bd-4b07-418d-9581-ea72e5b13a10','test.1756725181656@faildaily.com',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','node','2025-09-01 11:13:03','2025-09-01 11:13:03'),('9eadc9d5-5226-4754-bcfe-966dc168e1ab','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','85efade8-0857-40a9-a790-8253c270157f','support','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:46:48','2025-08-27 11:46:48'),('a02d1b39-88d8-41d8-962f-31a9bc8e4921','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 12:09:33','2025-08-27 12:09:33'),('a4fa6736-2f70-46dc-82bd-3b4c32923248','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','965883d5-c51b-4ccb-a7e4-e90aecc49016','support','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 12:28:21','2025-08-27 12:28:21'),('a521f3a7-e9f6-4111-97b2-c5935d30d779','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 13:11:54','2025-08-26 13:11:54'),('a68c8082-66da-43fe-b46f-03705108020a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 12:25:38','2025-08-26 12:25:38'),('a76a4c60-79b2-4d85-878e-ba9d1545cd68','fe8d5a37-d3db-49dc-850e-532aae96868c','temp.test.1756719282631@test.local','Test User 1756719282631','register','{\"email\":\"temp.test.1756719282631@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:34:43','2025-09-01 09:34:43'),('a78c2dd1-95e8-4bb9-901e-1bce8a793580','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','85efade8-0857-40a9-a790-8253c270157f','empathy','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:46:44','2025-08-27 11:46:44'),('ab3dca6b-50e0-4ddc-b90e-579e79c4c86d','9d774ace-1dff-4ac9-8091-66e84e57a516','adm.1756717666568@test.local','AdminUser','register','{\"email\":\"adm.1756717666568@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:47','2025-09-01 09:07:47'),('ad4cff51-6325-446c-bb60-034b9234288f','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 08:47:35','2025-08-26 08:47:35'),('ae4b02d0-f68c-4973-91d6-820445a02621','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 12:15:51','2025-08-26 12:15:51'),('b0606fdd-e6a0-4302-b469-b86f55514d2c','293c74c1-371b-45e0-b548-77dff333b8e9','e2e.1756717654854@journey.local','User 1756717654854','register','{\"email\":\"e2e.1756717654854@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:35','2025-09-01 09:07:35'),('b14a2a76-16a3-4f8c-96f6-d7d887c7fdd0','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-08 07:46:08','2025-09-08 07:46:08'),('b15006af-fe49-451a-a7a0-2f4db6f604b6','58570b71-7bde-4266-b35c-03e59c0f82e7','adm.1756717657387@test.local','AdminTmp','register','{\"email\":\"adm.1756717657387@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:38','2025-09-01 09:07:38'),('b4250761-b1f2-4f10-8e85-07168f6c48c8','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:10:17','2025-08-21 09:10:17'),('b5ca5ff1-3908-41e9-8a2a-33c663208d2a','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','curl/8.14.1','2025-09-03 12:37:30','2025-09-03 12:37:30'),('b6b0c6e8-2494-472f-a66b-dcb40c6dc0cb','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','85efade8-0857-40a9-a790-8253c270157f','support','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-01 12:22:17','2025-09-01 12:22:17'),('b7094f63-ccb9-4e53-a15d-47cb30a38b07','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 12:44:38','2025-09-03 12:44:38'),('b7563fc6-df12-4305-a19e-c91f40643c9a','19261451-4bec-46df-947b-ed2a111c0801','adm.1756717663149@test.local','AdminIS','login','{\"email\":\"adm.1756717663149@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:44','2025-09-01 09:07:44'),('b7fd08c1-ff3d-4e48-b1bc-ed8f9de0ea21','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','85efade8-0857-40a9-a790-8253c270157f','courage','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:33:39','2025-08-27 08:33:39'),('ba160b8d-509e-4147-91a7-6f47d9a9721b','6b7baec3-c870-4f1d-a256-45d31ed5f893','adult.1756717665706@test.local','Adult','register','{\"email\":\"adult.1756717665706@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:46','2025-09-01 09:07:46'),('ba695871-4845-4490-adf6-3e1d22126504','5d79191e-ec05-40a0-a85f-ecc8b6287f94','test.1756725160513@faildaily.com','Test Login User 1756725160513','login','{\"email\":\"test.1756725160513@faildaily.com\"}',NULL,NULL,'::1','node','2025-09-01 11:12:41','2025-09-01 11:12:41'),('bb4cedf7-5a89-4342-9855-61209ac355a8','ae6d53e7-9ab0-4b49-ada8-86bd09d48e6f','teen.1756717661025@test.local','TeenC','register','{\"email\":\"teen.1756717661025@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:41','2025-09-01 09:07:41'),('bcad8ea2-a112-4a94-b054-5ceb95e6acfb','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'create_fail','{\"title\":\"fails test 1 : jeudi adulte test 1\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:51:05','2025-08-21 09:51:05'),('bcc22f9a-070f-48f7-8006-2b97d841fd68','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 11:39:27','2025-08-21 11:39:27'),('bd54fea2-cf7a-44a4-a990-3bf58169419f','12c637c8-450c-4159-9beb-817aca67e9a1','adm.1756717668294@test.local','AdminF','register','{\"email\":\"adm.1756717668294@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:48','2025-09-01 09:07:48'),('bde9945d-6916-4093-94db-7d5e03bcc53f','e10fbd52-b906-4504-8e13-7c7b7c451afa','test-1756727373156@example.com','TestUser1756727373156','register','{\"email\":\"test-1756727373156@example.com\"}',NULL,NULL,'::1','node-fetch','2025-09-01 11:49:33','2025-09-01 11:49:33'),('c12572a0-4af7-40f1-8418-6616d5baceb1','293c74c1-371b-45e0-b548-77dff333b8e9','e2e.1756717654854@journey.local','User 1756717654854','login','{\"email\":\"e2e.1756717654854@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:36','2025-09-01 09:07:36'),('c13a64ce-bccd-4f34-a256-901f5c94c57f','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-03 12:50:51','2025-09-03 12:50:51'),('c1a3d888-5d19-4077-9222-702f4f376956','33e10cbd-a3cf-4259-8098-f3b33e3ec8bc','teen.1756717658787@test.local','Teen','register','{\"email\":\"teen.1756717658787@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:39','2025-09-01 09:07:39'),('c1db7702-207e-477b-9144-cf55314bec9a','5efe0f4e-ea21-4418-9e15-5e361c43b3f8','test.public.1755862087925@example.com','Test Public User','login','{\"email\":\"test.public.1755862087925@example.com\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-08-22 11:28:09','2025-08-22 11:28:09'),('c3a575ea-1eaa-40d2-bf36-895aa89b31b5','9d774ace-1dff-4ac9-8091-66e84e57a516','adm.1756717666568@test.local','AdminUser','login','{\"email\":\"adm.1756717666568@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:47','2025-09-01 09:07:47'),('c5b831c2-8c98-489d-81e7-dc7e4c1d7d56','bea3f8c3-f962-48ac-891a-604f278cdb09','u15.1756717665266@test.local','U15','register','{\"email\":\"u15.1756717665266@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:45','2025-09-01 09:07:45'),('c5fc3361-5299-4415-aff9-c5a6d9174070','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'93.20.25.180','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-08 09:11:42','2025-09-08 09:11:42'),('c7ca0f56-b7a7-4eed-a2c8-e79c7079d032','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"support\"}','85efade8-0857-40a9-a790-8253c270157f','support','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:33:46','2025-08-27 08:33:46'),('cc825aa0-84be-4086-bff4-02fead106563','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 07:43:52','2025-08-26 07:43:52'),('cd53de5f-2b34-4b38-a47d-a1287a6c0c97','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-25 09:08:07','2025-08-25 09:08:07'),('cd6001ad-1101-45fc-b7c2-4cf096e3d857','19261451-4bec-46df-947b-ed2a111c0801','adm.1756717663149@test.local','AdminIS','register','{\"email\":\"adm.1756717663149@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:43','2025-09-01 09:07:43'),('cf6850b9-5130-4d4a-8690-ec3a6776089c','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:27:53','2025-08-22 22:27:53'),('d0a8c43d-7bcc-4066-8c0b-cbda916f0c87','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-01 12:22:09','2025-09-01 12:22:09'),('d13ee542-698a-40b5-916a-d97f57f1d3ec','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 10:53:38','2025-08-26 10:53:38'),('d1887c63-9525-4fcb-9092-25a4d402aecc','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:40:32','2025-08-21 09:40:32'),('d309b77e-f044-44f6-bc4e-8aa70082e300','957f8d77-8311-4377-b3fc-b9b53ab29beb','teen.1756717667504@test.local','TeenUser','register','{\"email\":\"teen.1756717667504@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:47','2025-09-01 09:07:47'),('d72241b5-893e-47b3-b0a6-82e80e94a599','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee','vendredi test 1','login','{\"email\":\"tre@rte.ee\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:10:45','2025-08-22 22:10:45'),('d9f1da8f-5e44-46db-ba92-eca1ca15a400','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','curl/8.14.1','2025-09-03 13:04:41','2025-09-03 13:04:41'),('da40483c-8f9f-4f88-ac21-fd74c9bdaa49','75c74d79-8cda-4c6b-8c08-c0dfa06043ca','e2e.1756719280609@journey.local','User 1756719280609','register','{\"email\":\"e2e.1756719280609@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:34:41','2025-09-01 09:34:41'),('dd98307c-ad97-42de-ae93-b9e004f45095','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','','2025-09-03 13:05:46','2025-09-03 13:05:46'),('ddfceb4f-d012-4a93-89b4-ce49596f5e2e','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 09:31:26','2025-08-27 09:31:26'),('df3ae67b-78a1-4513-8e06-5010c44e4899','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','85efade8-0857-40a9-a790-8253c270157f','laugh','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:33:44','2025-08-27 08:33:44'),('e026296f-0ee4-4ce7-a8ba-e44454796684','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','curl/8.14.1','2025-09-03 13:03:21','2025-09-03 13:03:21'),('e0dfbfd5-6324-40af-b1a4-c6b976d1e20d','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-26 07:23:36','2025-08-26 07:23:36'),('e288cf8b-34ea-4a62-88c6-680f04468e35','3eec9236-40db-46ca-ae18-9b089bef0e75','vfr@vfr.vfr',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-25 07:54:17','2025-08-25 07:54:17'),('e6694d2a-a58d-45ef-9e50-4925f0bfe250','fe8d5a37-d3db-49dc-850e-532aae96868c','temp.test.1756719282631@test.local','Test User 1756719282631','login','{\"email\":\"temp.test.1756719282631@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:34:43','2025-09-01 09:34:43'),('e96ae342-70df-49ab-bbfa-c1f14a80d908','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be','Taaazzz','login','{\"email\":\"bruno@taaazzz.be\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:33:47','2025-08-27 11:33:47'),('ea7e4897-d392-49d7-a60a-5a6751b96314','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee',NULL,'create_fail','{\"title\":\"samedi test fails anonyme 1\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-23 08:18:57','2025-08-23 08:18:57'),('eaba0c06-19b6-4ebd-9d2e-152139645746','4ede043a-da02-4f5b-aa4c-c45bee9a714a','adm.1756717659772@test.local','AdminC','register','{\"email\":\"adm.1756717659772@test.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:07:40','2025-09-01 09:07:40'),('eba530f6-b300-4c34-8b4d-f45fe17c255f','411dd9ff-9673-48c9-838a-50b49074fff0','test@test.com','Test User','login','{\"email\":\"test@test.com\"}',NULL,NULL,'93.20.25.180','curl/8.14.1','2025-09-05 11:51:28','2025-09-05 11:51:28'),('f18ee623-3c02-4620-9e9e-ef1bde1c05e0','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 11:33:46','2025-08-21 11:33:46'),('f1fdce03-fa5b-4de5-aff9-5d12d964d751','411dd9ff-9673-48c9-838a-50b49074fff0','test@test.com','Test User','login','{\"email\":\"test@test.com\"}',NULL,NULL,'::1','curl/8.14.1','2025-08-25 09:47:02','2025-08-25 09:47:02'),('f3f5a71e-2898-49c4-a336-49aedfb21cee','e1da10bd-4b07-418d-9581-ea72e5b13a10','test.1756725181656@faildaily.com','Utilisateur Intégration Test 1756725181656','register','{\"email\":\"test.1756725181656@faildaily.com\"}',NULL,NULL,'::1','node','2025-09-01 11:13:02','2025-09-01 11:13:02'),('f4be9bd7-1fc7-4af2-b8c6-bf41bbb6feca','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','85efade8-0857-40a9-a790-8253c270157f','laugh','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:33:31','2025-08-27 08:33:31'),('f532ffd0-2fb6-4fe3-9896-02da97f20f34','75c74d79-8cda-4c6b-8c08-c0dfa06043ca','e2e.1756719280609@journey.local','User 1756719280609','login','{\"email\":\"e2e.1756719280609@journey.local\"}',NULL,NULL,'::ffff:127.0.0.1','','2025-09-01 09:34:41','2025-09-01 09:34:41'),('f5644a49-9d7f-429f-a40b-12aa923c1c0b','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','85efade8-0857-40a9-a790-8253c270157f','empathy','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 12:37:06','2025-08-27 12:37:06'),('f5c0ea30-1954-4c19-809e-bff561c91984','814b7d10-b3d4-4921-ab47-a388bec6c7fb',NULL,NULL,'register','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,NULL,NULL,'2025-08-21 08:51:48','2025-08-21 08:51:48'),('f70e140a-5ab1-4821-8387-a9a02b0e16dd','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:12:47','2025-08-21 09:12:47'),('f798a5a8-bd40-4657-937b-998ece59cc8b','57a2560d-b065-44f3-96c8-3b0d2e5b569b','tre@rte.ee',NULL,'logout','{\"reason\":\"user_logout\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-23 09:01:42','2025-08-23 09:01:42'),('f8dd1ac2-fdc9-44c7-8502-0c5ac7542ba6','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','85efade8-0857-40a9-a790-8253c270157f','laugh','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 09:33:14','2025-08-27 09:33:14'),('f9f981c5-2476-44ee-837a-bc951a8157db','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-22 22:10:21','2025-08-22 22:10:21'),('fa3e985a-37ac-4dfd-a0c3-efb854bcbce2','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"courage\"}','85efade8-0857-40a9-a790-8253c270157f','courage','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 08:28:47','2025-08-27 08:28:47'),('fb5438d5-fe37-4367-80cf-9ea7c35f27a2','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"empathy\"}','965883d5-c51b-4ccb-a7e4-e90aecc49016','empathy','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-09-01 12:22:20','2025-09-01 12:22:20'),('fc11a360-1b76-43dc-bbe3-9e2a4495bfdf','814b7d10-b3d4-4921-ab47-a388bec6c7fb','adulte1@adulte.fr','jeudi test adulte 1','login','{\"email\":\"adulte1@adulte.fr\"}',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-21 09:25:03','2025-08-21 09:25:03'),('ff6e9b42-1e5e-4947-bcb0-e1bc06dc5076','9f92d99e-5f70-427e-aebd-68ca8b727bd4','bruno@taaazzz.be',NULL,'reaction','{\"reactionType\":\"laugh\"}','85efade8-0857-40a9-a790-8253c270157f','laugh','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36','2025-08-27 11:40:20','2025-08-27 11:40:20');

--
-- 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`),
  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 ('5cb73d2d-1263-43dc-85d3-f781e8befab2','9f92d99e-5f70-427e-aebd-68ca8b727bd4','first-fail','2025-09-05 12:59:16','2025-09-05 12:59:16'),('7aca15df-b216-4b49-b202-5cae70d2edd5','9f92d99e-5f70-427e-aebd-68ca8b727bd4','fails-5','2025-09-05 12:59:16','2025-09-05 12:59:16');

--
-- 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 ('01e51936-54be-4284-9558-d4c3d1fdf621','814b7d10-b3d4-4921-ab47-a388bec6c7fb',2,'comment_create','0f29dcc0-0b48-47cd-b0c5-dd1adc225198',NULL,NULL,'2025-09-02 08:44:42'),('0c7eeef6-cfcf-4acc-9e74-998927ac0eee','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','a490ccd7-ba67-47cb-ad30-aeb08f1be8c8',NULL,NULL,'2025-09-03 11:55:06'),('201289df-95c2-47dc-be2f-685b33739b24','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','965883d5-c51b-4ccb-a7e4-e90aecc49016','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 12:28:21'),('21c8fe3e-32c0-4bee-8df2-0a9c36397e11','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:33:44'),('4f7b40bb-c9fa-4fb5-9c89-c01329384a26','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:33:31'),('5149df52-438e-46c0-b771-ba2b9efa30f2','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create',NULL,NULL,NULL,'2025-09-03 11:13:08'),('59cf03e8-d64c-4d14-8b7c-a5d9175dd7d2','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create',NULL,NULL,NULL,'2025-09-03 11:21:23'),('68d28fa6-7a3a-44d2-88d1-addbd848450b','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','163e58c9-ca4e-4af2-88de-ece06cc678e1',NULL,NULL,'2025-09-05 21:34:23'),('6d5cd2a4-6c83-442f-9fe9-0d297a05ef2b','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','b7737594-7fe3-4894-966e-4a785d5d7832',NULL,NULL,'2025-09-03 11:26:41'),('6f13d3c9-ed95-4640-ac39-4d3fae7a6c2e','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','2d55f82e-8ba2-4189-a897-a1a588eaff95',NULL,NULL,'2025-09-03 11:34:44'),('8b466c2f-58b0-4fac-9e70-15ef8c8471e9','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','bb77e2b0-8576-4984-9ebc-29d8262d5741',NULL,NULL,'2025-09-03 12:05:08'),('a0ad4f62-cb34-48ce-94e2-24303e47ce87','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:33:46'),('a3a4d051-d5a1-45c1-90ca-ce6cf3dd2a87','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','3577b475-85a3-4d21-b6cf-51df98450772',NULL,NULL,'2025-09-03 11:54:19'),('aadd2516-5fba-4fc6-a3ce-aab6280f14f8','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 11:46:48'),('ae020df8-e26c-4915-bf73-986146b58c1d','57a2560d-b065-44f3-96c8-3b0d2e5b569b',5,'reaction','85efade8-0857-40a9-a790-8253c270157f','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 09:33:04'),('af6396b6-567a-4102-ab47-de938b21e05a','57a2560d-b065-44f3-96c8-3b0d2e5b569b',2,'reaction','965883d5-c51b-4ccb-a7e4-e90aecc49016','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-09-01 12:22:20'),('ba12363a-c298-43ff-b531-52788120ee45','9f92d99e-5f70-427e-aebd-68ca8b727bd4',2,'comment_create','bb77e2b0-8576-4984-9ebc-29d8262d5741',NULL,NULL,'2025-09-05 12:58:43'),('bc0ecc37-b54e-41a9-8460-528d8993d71f','57a2560d-b065-44f3-96c8-3b0d2e5b569b',2,'reaction','85efade8-0857-40a9-a790-8253c270157f','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 11:46:44'),('c2b4c969-8132-4d3a-86d2-5c66cd85ce10','9f92d99e-5f70-427e-aebd-68ca8b727bd4',10,'fail_create','62b3be3e-c742-4eb2-b7b2-d5f012812633',NULL,NULL,'2025-09-05 12:59:15'),('ca8f557f-7777-4f8d-a58a-98ab3a25ea4b','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-09-01 12:22:14'),('cfcd9dad-38a3-49c5-b102-3398bba356fa','57a2560d-b065-44f3-96c8-3b0d2e5b569b',2,'reaction','85efade8-0857-40a9-a790-8253c270157f','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:33:45'),('d172f5c0-f9e5-486b-93ce-d84db0519b20','57a2560d-b065-44f3-96c8-3b0d2e5b569b',5,'reaction','85efade8-0857-40a9-a790-8253c270157f','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:28:47'),('d604a881-4a25-4ab9-8210-5ec744d61690','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','support','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-09-01 12:22:17'),('deed0f69-b6eb-41f8-91c1-e303a392b98a','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 09:33:14'),('f23165fd-0a47-4382-bb8e-0c9457297153','57a2560d-b065-44f3-96c8-3b0d2e5b569b',5,'reaction','85efade8-0857-40a9-a790-8253c270157f','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 11:39:56'),('f3ba781d-ba76-436c-a7ee-9f224a4984f1','57a2560d-b065-44f3-96c8-3b0d2e5b569b',5,'reaction','85efade8-0857-40a9-a790-8253c270157f','courage','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 08:33:39'),('f7574cfb-d085-4061-baac-d408bc7ac6e1','57a2560d-b065-44f3-96c8-3b0d2e5b569b',2,'reaction','85efade8-0857-40a9-a790-8253c270157f','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 12:37:06'),('f84f1390-f5f3-49a7-887f-0818645a2216','57a2560d-b065-44f3-96c8-3b0d2e5b569b',3,'reaction','85efade8-0857-40a9-a790-8253c270157f','laugh','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 11:40:20'),('ffb91f16-a17d-4f4b-8cc6-af8927b19a9f','57a2560d-b065-44f3-96c8-3b0d2e5b569b',2,'reaction','85efade8-0857-40a9-a790-8253c270157f','empathy','{\"fromUser\":\"9f92d99e-5f70-427e-aebd-68ca8b727bd4\"}','2025-08-27 11:39:58');

--
-- 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 ('57a2560d-b065-44f3-96c8-3b0d2e5b569b',57,'2025-08-27 08:28:47','2025-09-01 12:22:20'),('814b7d10-b3d4-4921-ab47-a388bec6c7fb',2,'2025-09-02 08:44:42','2025-09-02 08:44:42'),('9f92d99e-5f70-427e-aebd-68ca8b727bd4',92,'2025-09-03 11:13:08','2025-09-05 21:34:23');

--
-- 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`
--


--
-- 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`*/;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `users_after_insert` AFTER INSERT ON `users` FOR EACH ROW BEGIN
    INSERT INTO profiles (id, user_id, preferences, stats) 
    VALUES (UUID(), NEW.id, '{}', '{"badges": [], "totalFails": 0, "couragePoints": 0}');
END */;;
DELIMITER ;

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

/*!50001 DROP VIEW IF EXISTS `user_profiles_complete`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` 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`))) */;


