-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mar. 24 fév. 2026 à 20:32
-- Version du serveur : 11.4.10-MariaDB
-- Version de PHP : 8.3.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données : `pexo5962_gym_tracker_db`
--
CREATE DATABASE IF NOT EXISTS `pexo5962_gym_tracker_db` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `pexo5962_gym_tracker_db`;

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

--
-- Structure de la table `communications`
--

DROP TABLE IF EXISTS `communications`;
CREATE TABLE IF NOT EXISTS `communications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL,
  `body` mediumtext NOT NULL,
  `body_plain` text DEFAULT NULL,
  `sent_by` varchar(36) NOT NULL,
  `sent_at` timestamp NULL DEFAULT current_timestamp(),
  `recipient_count` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_comm_sent_at` (`sent_at`),
  KEY `idx_comm_sent_by` (`sent_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `communication_drafts`
--

DROP TABLE IF EXISTS `communication_drafts`;
CREATE TABLE IF NOT EXISTS `communication_drafts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` mediumtext NOT NULL,
  `body_plain` text DEFAULT NULL,
  `created_by` varchar(36) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_draft_created_by` (`created_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `communication_recipients`
--

DROP TABLE IF EXISTS `communication_recipients`;
CREATE TABLE IF NOT EXISTS `communication_recipients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `communication_id` int(11) NOT NULL,
  `user_id` varchar(36) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_cr_communication` (`communication_id`),
  KEY `idx_cr_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `contact_tickets`
--

DROP TABLE IF EXISTS `contact_tickets`;
CREATE TABLE IF NOT EXISTS `contact_tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(36) NOT NULL,
  `subject_type` enum('suggestion','assistance','bug','autre') NOT NULL,
  `custom_subject` varchar(255) DEFAULT NULL,
  `status` enum('open','closed') NOT NULL DEFAULT 'open',
  `archived_at` timestamp NULL DEFAULT NULL,
  `archived_by` varchar(36) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`),
  KEY `idx_status_archived` (`status`,`archived_at`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `draft_logs`
--

DROP TABLE IF EXISTS `draft_logs`;
CREATE TABLE IF NOT EXISTS `draft_logs` (
  `id` varchar(36) NOT NULL,
  `user_id` varchar(36) NOT NULL,
  `draft_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`draft_data`)),
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_user_draft` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `email_change_tokens`
--

DROP TABLE IF EXISTS `email_change_tokens`;
CREATE TABLE IF NOT EXISTS `email_change_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(36) NOT NULL,
  `new_email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expires_at` timestamp NOT NULL,
  `used` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_ect_token` (`token`),
  KEY `idx_ect_user` (`user_id`),
  KEY `idx_ect_expires` (`expires_at`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_change_tokens` (`id`, `user_id`, `new_email`, `token`, `expires_at`, `used`, `created_at`) VALUES
(3, 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'hello@gymtracker.paranov.com', '33311b10d279b34d71c4af8fb00c09c51b411d7548be569553aae9f5ab007ac2', '2026-02-20 16:58:35', 1, '2026-02-19 16:58:35');

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

--
-- Structure de la table `email_templates`
--

DROP TABLE IF EXISTS `email_templates`;
CREATE TABLE IF NOT EXISTS `email_templates` (
  `id` varchar(36) NOT NULL,
  `template_key` varchar(50) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `html_body` mediumtext NOT NULL,
  `text_body` text DEFAULT NULL,
  `updated_by` varchar(36) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `template_key` (`template_key`),
  KEY `fk_email_templates_user` (`updated_by`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `email_templates` (`id`, `template_key`, `subject`, `html_body`, `text_body`, `updated_by`, `updated_at`) VALUES
('024f8acf-8662-4635-bc66-6c4cecad2e39', 'communication', '{{communicationSubject}}', '<!DOCTYPE html>\n<html lang=\"fr\">\n<head>\n  <meta charset=\"utf-8\">\n  <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\n  <title>{{communicationSubject}}</title>\n</head>\n<body style=\"margin: 0; padding: 0; font-family: -apple-system, BlinkMacSystemFont, \'Segoe UI\', Roboto, \'Helvetica Neue\', Arial, sans-serif; background-color: #f1f5f9;\">\n  <div style=\"max-width: 600px; margin: 0 auto; padding: 20px;\">\n    <div style=\"background: linear-gradient(135deg, #4f46e5, #6366f1); padding: 30px; text-align: center; border-radius: 12px 12px 0 0;\">\n      <h1 style=\"margin: 0; color: #ffffff; font-size: 24px; font-weight: 700; letter-spacing: -0.5px;\">GymTracker</h1>\n    </div>\n    <div style=\"background: #f8fafc; padding: 30px; border: 1px solid #e2e8f0; border-top: none; border-radius: 0 0 12px 12px;\">\n      <div style=\"background: #ffffff; padding: 24px; border-radius: 8px; border: 1px solid #e2e8f0; line-height: 1.6; color: #1e293b;\">\n        {{communicationBody}}\n      </div>\n      <p style=\"text-align: center; color: #64748b; font-size: 12px; margin-top: 24px; margin-bottom: 0;\">\n        Vous recevez cet email car vous êtes membre de GymTracker.<br>\n        Pour ne plus recevoir ces communications, rendez-vous dans vos\n        <a href=\"{{frontendUrl}}/#settings/preferences\" style=\"color: #4f46e5; text-decoration: underline;\">paramètres</a>.\n      </p>\n    </div>\n  </div>\n</body>\n</html>', '{{communicationBody}}\n\n---\nVous recevez cet email car vous êtes membre de GymTracker.\nPour vous désinscrire, rendez-vous dans vos paramètres : {{frontendUrl}}', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-24 13:17:15'),
('0df509e8-f2a6-4ea1-a4f7-69ec1d9ea479', 'welcome', 'Bienvenue sur GymTracker !', '<!DOCTYPE html>\n<html>\n<head>\n  <meta charset=\"utf-8\">\n  <style>\n    body { font-family: -apple-system, BlinkMacSystemFont, \'Segoe UI\', Roboto, \'Helvetica Neue\', Arial, sans-serif; line-height: 1.6; color: #333; }\n    .container { max-width: 600px; margin: 0 auto; padding: 20px; }\n    .header { background: linear-gradient(135deg, #4f46e5, #6366f1); color: white; padding: 30px; text-align: center; border-radius: 12px 12px 0 0; }\n    .content { background: #f8fafc; padding: 30px; border: 1px solid #e2e8f0; border-top: none; border-radius: 0 0 12px 12px; }\n    .button { display: inline-block; background: #4f46e5; color: white !important; padding: 14px 28px; text-decoration: none; border-radius: 8px; font-weight: 600; margin: 20px 0; }\n    .footer { text-align: center; color: #64748b; font-size: 12px; margin-top: 20px; }\n\n    /* --- FEATURE (améliorée) --- */\n    .feature {\n      padding: 14px 0;\n      border-bottom: 1px solid #e2e8f0;\n      display: flex;\n      align-items: flex-start;\n    }\n    .feature:last-child { border-bottom: none; }\n\n    .feature-icon {\n      font-size: 20px;\n      line-height: 1;\n      width: 26px;\n      text-align: center;\n      margin-right: 10px;\n      margin-top: 2px;\n      flex: 0 0 26px;\n    }\n\n    .feature-content {\n      display: block;\n      min-width: 0;\n    }\n\n    .feature-title {\n      display: block;\n      font-weight: 700;\n      color: #0f172a;\n      margin-bottom: 2px;\n      line-height: 1.35;\n    }\n\n    .feature-desc {\n      display: block;\n      color: #475569;\n      line-height: 1.45;\n      font-size: 15px;\n    }\n\n    @media only screen and (max-width: 480px) {\n      .feature {\n        padding: 12px 0;\n      }\n      .feature-icon {\n        font-size: 18px;\n        width: 22px;\n        margin-right: 8px;\n      }\n      .feature-desc {\n        font-size: 14px;\n      }\n    }\n  </style>\n</head>\n<body>\n  <div class=\"container\">\n    <div class=\"header\">\n      <h1 style=\"margin: 0; font-size: 28px;\">Bienvenue sur GymTracker !</h1>\n    </div>\n    <div class=\"content\">\n      <h2 style=\"margin-top: 0;\">Bonjour {{username}},</h2>\n      <p>Félicitations ! Votre compte GymTracker a été créé avec succès.</p>\n      <p>Voici ce que vous pouvez faire avec GymTracker :</p>\n\n      <div class=\"feature\">\n        <span class=\"feature-icon\">📝</span>\n        <span class=\"feature-content\">\n          <span class=\"feature-title\">Créer des templates de séances</span>\n          <span class=\"feature-desc\">Organisez vos entraînements avec des exercices et des sets prédéfinis</span>\n        </span>\n      </div>\n\n      <div class=\"feature\">\n        <span class=\"feature-icon\">💪</span>\n        <span class=\"feature-content\">\n          <span class=\"feature-title\">Logger vos séances</span>\n          <span class=\"feature-desc\">Enregistrez vos performances en temps réel</span>\n        </span>\n      </div>\n\n      <div class=\"feature\">\n        <span class=\"feature-icon\">📊</span>\n        <span class=\"feature-content\">\n          <span class=\"feature-title\">Suivre vos progrès</span>\n          <span class=\"feature-desc\">Visualisez votre progression avec des statistiques détaillées</span>\n        </span>\n      </div>\n\n      <div class=\"feature\">\n        <span class=\"feature-icon\">🔥</span>\n        <span class=\"feature-content\">\n          <span class=\"feature-title\">Heatmap corporelle</span>\n          <span class=\"feature-desc\">Voyez quels muscles vous travaillez le plus</span>\n        </span>\n      </div>\n\n      <p style=\"text-align: center;\">\n        <a href=\"{{frontendUrl}}\" class=\"button\">Commencer</a>\n      </p>\n    </div>\n    <div class=\"footer\">\n      <p>Cet email a été envoyé automatiquement lors de la création de votre compte GymTracker.</p>\n    </div>\n  </div>\n</body>\n</html>\n', 'Bienvenue sur GymTracker, {{username}} !\n\nVotre compte a été créé avec succès.\n\nVoici ce que vous pouvez faire :\n- Créer des templates de séances\n- Logger vos séances en temps réel\n- Suivre vos progrès avec des statistiques\n- Visualiser votre heatmap corporelle\n\nCommencez maintenant : {{frontendUrl}}\n\n---\nGymTracker', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-17 23:40:21');

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

--
-- Structure de la table `exercises`
--

DROP TABLE IF EXISTS `exercises`;
CREATE TABLE IF NOT EXISTS `exercises` (
  `id` varchar(36) NOT NULL,
  `user_id` varchar(36) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `muscle_group` varchar(100) NOT NULL,
  `category` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_global` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_muscle` (`user_id`,`muscle_group`),
  KEY `idx_user_name` (`user_id`,`name`),
  KEY `idx_global` (`is_global`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `exercises` (`id`, `user_id`, `name`, `muscle_group`, `category`, `notes`, `created_at`, `updated_at`, `is_global`, `created_by`) VALUES
('09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', NULL, 'Rowing haltères unilatéral', 'Dos', 'Force', NULL, '2026-02-08 22:03:10', '2026-02-08 22:03:10', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', NULL, 'Converging Shoulder Press [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-08 21:49:34', '2026-02-08 21:49:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('1cd35d53-38d0-403e-8e60-f209f1ca70d0', NULL, 'Seated row [Basic Fit]', 'Dos', 'Isolation', NULL, '2026-02-08 22:04:39', '2026-02-08 22:04:39', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('20b28ca2-4eb2-4678-b81e-581403940785', NULL, 'Curl haltères banc incliné 45°', 'Bras', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('2acbcc00-05e8-4138-9cd1-90abc352a604', NULL, 'Prone Leg Curl [Basic Fit]', 'Jambes', 'Isolation', NULL, '2026-02-08 21:58:34', '2026-02-08 21:58:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', NULL, 'Overhead triceps extensions haltères', 'Bras', 'Isolation', NULL, '2026-02-08 22:04:39', '2026-02-08 22:04:39', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('3ebc4567-c2bf-4b40-adaf-f92fdd238311', NULL, 'Shoulder Press [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-08 22:04:39', '2026-02-08 22:04:39', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('3f18fba0-d36f-4669-afd9-5ae5a9365bd9', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'L-Fly poulie H9 [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-05 23:37:11', '2026-02-08 22:12:11', 0, NULL),
('41263e7b-52c0-4de3-875e-e0fbbfd0972d', NULL, 'Seated Dip [Basic Fit]', 'Bras', 'Isolation', NULL, '2026-02-08 21:56:53', '2026-02-08 21:56:53', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('4668ba82-0038-4745-b597-b1c88a3c4cb7', NULL, 'Converging chest press [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-23 11:42:34', '2026-02-23 11:42:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('479164da-7957-423d-afe5-357966c47dcd', NULL, 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 'Bras', 'Isolation', NULL, '2026-02-08 21:58:20', '2026-02-08 21:58:20', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('47e65778-4cfa-48b7-af09-d8bebfe43fd2', NULL, 'Shrug haltères', 'Épaules', 'Force', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('487f326a-4615-4b7e-aff7-dd42e80b625d', NULL, 'Abdominal crunch [Basic Fit]', 'Abdominaux', 'Isolation', NULL, '2026-02-08 22:03:10', '2026-02-08 22:03:10', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('4d96caf1-2912-4c43-bafc-8ad8cd2c6498', NULL, 'Élévations latérales buste incliné sur banc', 'Épaules', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('51b12d28-34b6-411a-9d39-ce434064c5ac', NULL, 'Presse Inclinée [Basic Fit]', 'Jambes', 'Force', NULL, '2026-02-08 22:03:10', '2026-02-08 22:03:10', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('5261557e-5405-47b6-9cb0-82fcb274970b', NULL, 'Vertical chest press [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-08 21:56:32', '2026-02-08 21:56:32', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('6264be19-5c19-42b4-9b46-01d8d63d4d14', NULL, 'Delts machine [Fitness Park]', 'Épaules', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('6473c865-05e7-49de-8e1f-e6ea1476da9c', NULL, 'Leg Extension [Basic Fit]', 'Jambes', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('668ba904-9ea9-4d99-a204-035774c34507', NULL, 'Élévations latérales haltères', 'Épaules', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('6ca8fdcd-0491-4955-80ef-8357ba4e1da9', NULL, 'Tirage vertical pronation prise large [Basic Fit]', 'Dos', 'Isolation', NULL, '2026-02-08 21:56:32', '2026-02-08 21:59:44', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('6ea94b31-61c6-48b4-8e39-b3966c5236b6', NULL, 'Planche', 'Abdominaux', 'Gainage', NULL, '2026-02-08 22:11:13', '2026-02-08 22:11:13', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('70f6612b-223a-4834-b02d-198f2686834d', NULL, 'Lateral raise [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-22 13:32:02', '2026-02-22 13:32:02', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('75a5310d-e415-4f99-b892-8a4591bc77c2', NULL, 'Écartés inclinés haltères', 'Pectoraux', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('7b713765-6589-491f-a996-645a8622e802', NULL, 'Curl biceps haltères', 'Bras', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('8208ea2e-1d0e-4970-ae1b-3e4a8b3ea8f9', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Poulie vis à vis H9 [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-05 23:37:11', '2026-02-08 22:12:33', 0, NULL),
('837b4136-27c9-4222-8a66-680111fb57c0', NULL, 'Arm curl pupitre [Basic Fit]', 'Bras', 'Isolation', NULL, '2026-02-18 11:51:40', '2026-02-18 11:51:40', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('88647284-2b33-477d-b221-094aedb6b413', NULL, 'Butterfly inversé [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('88f067c6-aac7-44e8-a67d-2f12a37a43ac', NULL, 'Back Extension [Basic Fit]', 'Dos', 'Isolation', NULL, '2026-02-08 21:49:34', '2026-02-08 21:49:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('8a122806-9b4c-43bb-bf75-18ed7fb6c94e', NULL, 'Hip Abduction [Basic Fit]', 'Jambes', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('9151452b-cc1f-4a4d-8f75-2da5120cf276', NULL, 'Back squat', 'Jambes', 'Force', NULL, '2026-02-08 22:03:10', '2026-02-08 22:03:10', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('92c90bf0-fe47-46bf-8345-2911d1c04ca9', NULL, 'Butterfly [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('9320e1c0-09ab-46bb-9a7c-762e136841e5', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Low row H5 pronation focus arrière épaules [Fitness Park]', 'Épaules', 'Isolation', NULL, '2026-02-08 11:45:27', '2026-02-08 11:45:43', 0, NULL),
('9d342e22-a950-4aef-a304-6a9ff262efd0', NULL, 'Rowing arrière épaules poulie basse unilatéral [Basic Fit]', 'Épaules', 'Isolation', NULL, '2026-02-08 22:03:10', '2026-02-08 22:03:10', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('9e05044a-0b98-4494-b21c-3733ab8d6e07', NULL, 'Extensions triceps barre poulie haute [Basic Fit]', 'Bras', 'Isolation', NULL, '2026-02-08 21:58:20', '2026-02-08 21:58:20', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('a1030256-07c8-4d20-958a-51ae621345f5', NULL, 'Chest press [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-08 21:49:34', '2026-02-08 21:49:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('a2cdac7f-232e-487e-b756-7ee914746605', NULL, 'Développé militaire haltères', 'Épaules', 'Force', NULL, '2026-02-08 21:38:16', '2026-02-08 21:59:05', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('a48e70c6-d165-409f-81df-fa8d5025eccd', NULL, 'Rotary torso [Basic Fit]', 'Abdominaux', 'Isolation', NULL, '2026-02-15 12:24:40', '2026-02-15 12:24:40', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('a6ce4dfd-12bd-4881-863d-60cea2b8cc94', NULL, 'Extension triceps machine [ON AIR]', 'Bras', 'Isolation', NULL, '2026-02-08 21:45:03', '2026-02-08 21:45:03', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('abb2e085-d1f0-480f-a550-17505346efc9', NULL, 'Crunchs', 'Abdominaux', 'Poids du corps', NULL, '2026-02-09 16:50:16', '2026-02-09 16:50:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('bb930f98-785a-4e86-ac70-0592fd9940a3', NULL, 'Élévations frontales haltères', 'Épaules', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('be61b2c0-31ff-404a-bb79-21d1d94c6044', NULL, 'Tirage vertical prise neutre large [Basic Fit]', 'Dos', 'Isolation', NULL, '2026-02-08 21:56:32', '2026-02-08 21:56:32', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('c18ff6af-54f3-4e1e-8a5e-e094b32e5160', NULL, 'Butterfly inversé [Fitness Park]', 'Épaules', 'Isolation', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Poulie focus haut de pec H8 [Basic Fit]', 'Pectoraux', 'Isolation', NULL, '2026-02-05 23:37:11', '2026-02-08 22:12:02', 0, NULL),
('c7a36913-a24e-48e6-a4f0-eb34e2c2193d', NULL, 'Seated Leg Curl [Basic Fit]', 'Jambes', 'Isolation', NULL, '2026-02-08 21:56:53', '2026-02-08 21:56:53', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('c837e71d-17f5-4778-b90a-2f1215656426', NULL, 'Curl pupitre haltère unilatéral', 'Bras', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('cc827237-9767-4068-ad30-d87db444b700', NULL, 'Développé couché machine à disques [Basic Fit]', 'Pectoraux', 'Force', NULL, '2026-02-08 21:49:34', '2026-02-08 21:49:34', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('ccb31734-765f-4ab5-99b3-5df544005d60', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Course sur tapis', 'Cardio', 'Cardio', NULL, '2026-02-15 20:28:55', '2026-02-15 20:28:55', 0, NULL),
('ce2ba55b-b4ac-4369-b1da-75fda2cb7736', NULL, 'Développé incliné haltères', 'Pectoraux', 'Force', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('d5804002-6882-42bf-be2a-6b4410e1830c', NULL, 'Hip Adduction [Basic Fit]', 'Jambes', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('d75dc64b-afb4-48ea-976b-4018bc85214a', NULL, 'Rowing poulie basse unilatéral [Basic Fit]', 'Dos', 'Isolation', NULL, '2026-02-20 06:12:09', '2026-02-20 06:12:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('d8e8d29b-0fad-4ee5-99e6-99c177cd9898', NULL, 'Skull crusher haltères', 'Bras', 'Isolation', NULL, '2026-02-08 21:57:07', '2026-02-08 21:57:07', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('dcea8319-b1db-4815-8721-8db30421163d', NULL, 'Toe touches', 'Abdominaux', 'Poids du corps', NULL, '2026-02-09 16:51:01', '2026-02-09 16:51:01', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('e382f43a-8885-4395-aaea-a03df847ce77', NULL, 'Tractions', 'Dos', 'Poids du corps', NULL, '2026-02-08 21:57:07', '2026-02-08 21:57:07', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', NULL, 'Développé couché barre', 'Pectoraux', 'Force', NULL, '2026-02-08 21:38:16', '2026-02-08 21:59:26', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('edad72d2-46c5-46be-9fef-94ebfb5ff033', NULL, 'Développé couché haltères', 'Pectoraux', 'Force', NULL, '2026-02-08 21:38:16', '2026-02-08 21:38:16', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('ee31faa6-f4d6-49af-a048-15842f0537ee', NULL, 'Curl pupitre disques [ON AIR]', 'Bras', 'Isolation', NULL, '2026-02-08 21:43:09', '2026-02-08 21:43:09', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a'),
('fd1abea4-6347-4bc5-aec7-0a8505fd3545', NULL, 'Câble curl [ON AIR]', 'Bras', 'Isolation', NULL, '2026-02-08 21:49:34', '2026-02-15 20:25:51', 1, 'efcb0993-6668-4efe-8dea-6c71ad999c0a');

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

--
-- Structure de la table `exercise_impacted_muscles`
--

DROP TABLE IF EXISTS `exercise_impacted_muscles`;
CREATE TABLE IF NOT EXISTS `exercise_impacted_muscles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `exercise_id` varchar(36) NOT NULL,
  `muscle` varchar(100) NOT NULL,
  `factor` decimal(3,2) NOT NULL DEFAULT 1.00,
  PRIMARY KEY (`id`),
  KEY `idx_exercise` (`exercise_id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `exercise_impacted_muscles` (`id`, `exercise_id`, `muscle`, `factor`) VALUES
(75, '9320e1c0-09ab-46bb-9a7c-762e136841e5', 'Deltoïde Postérieur', 1.00),
(76, '9320e1c0-09ab-46bb-9a7c-762e136841e5', 'Trapèzes', 0.10),
(78, '88647284-2b33-477d-b221-094aedb6b413', 'Deltoïde Postérieur', 1.00),
(79, '88647284-2b33-477d-b221-094aedb6b413', 'Trapèzes', 0.10),
(80, 'c18ff6af-54f3-4e1e-8a5e-e094b32e5160', 'Deltoïde Postérieur', 1.00),
(81, 'c18ff6af-54f3-4e1e-8a5e-e094b32e5160', 'Trapèzes', 0.10),
(84, '20b28ca2-4eb2-4678-b81e-581403940785', 'Biceps', 1.00),
(85, '20b28ca2-4eb2-4678-b81e-581403940785', 'Avant-bras', 0.20),
(87, 'edad72d2-46c5-46be-9fef-94ebfb5ff033', 'Pectoraux', 1.00),
(90, '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Haut de Pectoraux', 1.00),
(91, '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Pectoraux', 0.70),
(92, 'bb930f98-785a-4e86-ac70-0592fd9940a3', 'Deltoïde Antérieur', 1.00),
(93, '668ba904-9ea9-4d99-a204-035774c34507', 'Deltoïde Latéral', 1.00),
(94, '4d96caf1-2912-4c43-bafc-8ad8cd2c6498', 'Deltoïde Postérieur', 1.00),
(95, '47e65778-4cfa-48b7-af09-d8bebfe43fd2', 'Trapèzes', 1.00),
(96, '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 'Pectoraux', 1.00),
(97, 'ee31faa6-f4d6-49af-a048-15842f0537ee', 'Biceps', 1.00),
(98, 'ee31faa6-f4d6-49af-a048-15842f0537ee', 'Avant-bras', 0.10),
(99, 'c837e71d-17f5-4778-b90a-2f1215656426', 'Biceps', 1.00),
(100, 'c837e71d-17f5-4778-b90a-2f1215656426', 'Avant-bras', 0.10),
(101, '6264be19-5c19-42b4-9b46-01d8d63d4d14', 'Deltoïde Latéral', 1.00),
(102, '8a122806-9b4c-43bb-bf75-18ed7fb6c94e', 'Abducteurs', 1.00),
(103, 'd5804002-6882-42bf-be2a-6b4410e1830c', 'Adducteurs', 1.00),
(104, '6473c865-05e7-49de-8e1f-e6ea1476da9c', 'Quadriceps', 1.00),
(105, 'a6ce4dfd-12bd-4881-863d-60cea2b8cc94', 'Triceps', 1.00),
(111, '7b713765-6589-491f-a996-645a8622e802', 'Biceps', 1.00),
(112, '7b713765-6589-491f-a996-645a8622e802', 'Avant-bras', 0.20),
(113, '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Lombaires', 1.00),
(116, 'a1030256-07c8-4d20-958a-51ae621345f5', 'Pectoraux', 1.00),
(117, '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Deltoïde Antérieur', 0.80),
(118, '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Deltoïde Latéral', 0.30),
(119, 'cc827237-9767-4068-ad30-d87db444b700', 'Pectoraux', 1.00),
(120, 'cc827237-9767-4068-ad30-d87db444b700', 'Haut de Pectoraux', 0.20),
(123, '5261557e-5405-47b6-9cb0-82fcb274970b', 'Haut de Pectoraux', 1.00),
(124, '5261557e-5405-47b6-9cb0-82fcb274970b', 'Pectoraux', 0.50),
(125, 'be61b2c0-31ff-404a-bb79-21d1d94c6044', 'Grand Dorsal', 1.00),
(126, 'be61b2c0-31ff-404a-bb79-21d1d94c6044', 'Rhomboïdes', 0.30),
(130, '41263e7b-52c0-4de3-875e-e0fbbfd0972d', 'Triceps', 1.00),
(131, 'c7a36913-a24e-48e6-a4f0-eb34e2c2193d', 'Ischio-jambiers', 1.00),
(132, 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Triceps', 1.00),
(133, 'e382f43a-8885-4395-aaea-a03df847ce77', 'Grand Dorsal', 1.00),
(134, '9e05044a-0b98-4494-b21c-3733ab8d6e07', 'Triceps', 1.00),
(135, '479164da-7957-423d-afe5-357966c47dcd', 'Triceps', 1.00),
(136, '2acbcc00-05e8-4138-9cd1-90abc352a604', 'Ischio-jambiers', 1.00),
(137, 'a2cdac7f-232e-487e-b756-7ee914746605', 'Deltoïde Latéral', 0.60),
(138, 'a2cdac7f-232e-487e-b756-7ee914746605', 'Deltoïde Antérieur', 1.00),
(139, 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Pectoraux', 1.00),
(140, '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Grand Dorsal', 1.00),
(141, '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Deltoïde Postérieur', 0.10),
(142, '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Rhomboïdes', 0.20),
(143, '51b12d28-34b6-411a-9d39-ce434064c5ac', 'Quadriceps', 1.00),
(144, '51b12d28-34b6-411a-9d39-ce434064c5ac', 'Fessiers', 0.50),
(145, '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Trapèzes', 0.20),
(146, '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Deltoïde Postérieur', 0.90),
(147, '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 'Rhomboïdes', 1.00),
(148, '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 'Grand Dorsal', 0.30),
(149, '9151452b-cc1f-4a4d-8f75-2da5120cf276', 'Fessiers', 0.30),
(150, '9151452b-cc1f-4a4d-8f75-2da5120cf276', 'Quadriceps', 0.80),
(151, '487f326a-4615-4b7e-aff7-dd42e80b625d', 'Abdominaux', 1.00),
(152, '3ebc4567-c2bf-4b40-adaf-f92fdd238311', 'Deltoïde Antérieur', 1.00),
(153, '3ebc4567-c2bf-4b40-adaf-f92fdd238311', 'Deltoïde Latéral', 0.20),
(154, '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Rhomboïdes', 1.00),
(155, '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Grand Dorsal', 0.30),
(156, '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Triceps', 1.00),
(159, '6ea94b31-61c6-48b4-8e39-b3966c5236b6', 'Abdominaux', 1.00),
(160, 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'Haut de Pectoraux', 1.00),
(161, '3f18fba0-d36f-4669-afd9-5ae5a9365bd9', 'Deltoïde Postérieur', 0.20),
(162, '8208ea2e-1d0e-4970-ae1b-3e4a8b3ea8f9', 'Pectoraux', 1.00),
(163, 'abb2e085-d1f0-480f-a550-17505346efc9', 'Abdominaux', 1.00),
(164, 'dcea8319-b1db-4815-8721-8db30421163d', 'Abdominaux', 1.00),
(165, 'dcea8319-b1db-4815-8721-8db30421163d', 'Obliques', 0.60),
(166, 'a48e70c6-d165-409f-81df-fa8d5025eccd', 'Abdominaux', 0.20),
(167, 'a48e70c6-d165-409f-81df-fa8d5025eccd', 'Obliques', 0.80),
(168, 'fd1abea4-6347-4bc5-aec7-0a8505fd3545', 'Biceps', 1.00),
(169, 'fd1abea4-6347-4bc5-aec7-0a8505fd3545', 'Avant-bras', 0.20),
(170, 'ccb31734-765f-4ab5-99b3-5df544005d60', 'Cardio', 1.00),
(173, '837b4136-27c9-4222-8a66-680111fb57c0', 'Biceps', 1.00),
(176, 'd75dc64b-afb4-48ea-976b-4018bc85214a', 'Grand Dorsal', 0.20),
(177, 'd75dc64b-afb4-48ea-976b-4018bc85214a', 'Rhomboïdes', 0.90),
(178, '70f6612b-223a-4834-b02d-198f2686834d', 'Deltoïde Latéral', 1.00),
(180, '4668ba82-0038-4745-b597-b1c88a3c4cb7', 'Pectoraux', 1.00);

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

--
-- Structure de la table `exercise_replacement_actions`
--

DROP TABLE IF EXISTS `exercise_replacement_actions`;
CREATE TABLE IF NOT EXISTS `exercise_replacement_actions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(36) NOT NULL,
  `custom_exercise_id` varchar(36) NOT NULL,
  `global_exercise_id` varchar(36) NOT NULL,
  `custom_exercise_name` varchar(255) NOT NULL,
  `global_exercise_name` varchar(255) NOT NULL,
  `status` enum('pending','accepted','rejected') NOT NULL DEFAULT 'pending',
  `update_history_names` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `resolved_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `custom_exercise_id` (`custom_exercise_id`),
  KEY `global_exercise_id` (`global_exercise_id`),
  KEY `idx_user_status` (`user_id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `exercise_replacement_actions` (`id`, `user_id`, `custom_exercise_id`, `global_exercise_id`, `custom_exercise_name`, `global_exercise_name`, `status`, `update_history_names`, `created_at`, `resolved_at`) VALUES
(37, 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'a2cdac7f-232e-487e-b756-7ee914746605', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé Militaire', 'Développé militaire haltères', 'accepted', 1, '2026-02-08 21:59:05', '2026-02-08 21:59:12'),
(38, 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Développé Couché barre', 'Développé couché barre', 'accepted', 1, '2026-02-08 21:59:26', '2026-02-08 21:59:29'),
(39, 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large', 'Tirage vertical pronation prise large [Basic Fit]', 'accepted', 1, '2026-02-08 21:59:44', '2026-02-08 21:59:49'),
(49, 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'fd1abea4-6347-4bc5-aec7-0a8505fd3545', 'fd1abea4-6347-4bc5-aec7-0a8505fd3545', 'Câble curl [Basic Fit]', 'Câble curl [ON AIR]', 'accepted', 1, '2026-02-15 20:25:51', '2026-02-15 20:26:14');

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

--
-- Structure de la table `member_invitations`
--

DROP TABLE IF EXISTS `member_invitations`;
CREATE TABLE IF NOT EXISTS `member_invitations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `token` varchar(255) NOT NULL,
  `invited_by` varchar(36) NOT NULL,
  `used` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `expires_at` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `invited_by` (`invited_by`),
  KEY `idx_token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
CREATE TABLE IF NOT EXISTS `password_reset_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(36) NOT NULL,
  `token` varchar(255) NOT NULL,
  `expires_at` timestamp NOT NULL,
  `used` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_token` (`token`),
  KEY `idx_user` (`user_id`),
  KEY `idx_expires` (`expires_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `ticket_messages`
--

DROP TABLE IF EXISTS `ticket_messages`;
CREATE TABLE IF NOT EXISTS `ticket_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) NOT NULL,
  `sender_id` varchar(36) NOT NULL,
  `content` text NOT NULL,
  `is_admin_reply` tinyint(1) NOT NULL DEFAULT 0,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_ticket` (`ticket_id`),
  KEY `idx_sender` (`sender_id`)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `ticket_message_attachments`
--

DROP TABLE IF EXISTS `ticket_message_attachments`;
CREATE TABLE IF NOT EXISTS `ticket_message_attachments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message_id` int(11) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `file_path` varchar(500) NOT NULL,
  `file_size` int(11) NOT NULL,
  `mime_type` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_message` (`message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` varchar(36) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password_hash` varchar(255) NOT NULL,
  `username` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `last_login` timestamp NULL DEFAULT NULL,
  `role` enum('owner','super_admin','admin','user') NOT NULL DEFAULT 'user',
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  KEY `idx_email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `email`, `password_hash`, `username`, `created_at`, `updated_at`, `last_login`, `role`) VALUES
('c642f74b-fe82-47a2-b373-8b271dfaea40', 'paradislorine@gmail.com', '$2a$12$bzPsK95Fsu2b757K0PM8XuQOL2E05gyj2bC3PfjmlNc0mIlqpgknq', 'Lolop34', '2026-02-13 21:41:26', '2026-02-18 18:22:57', NULL, 'user'),
('efcb0993-6668-4efe-8dea-6c71ad999c0a', 'hello@gymtracker.paranov.com', '$2a$12$3Gq3ShiJYhemp20GvmPhMeA8N3suEN2WXSGNn7kDFi0z8iNN.9T4.', 'cparadis', '2026-02-05 23:34:43', '2026-02-19 16:59:03', '2026-02-19 15:18:55', 'owner'),
('efcb0993-6668-4efe-8dea-6c71ad999c0b', 'corentinparadis34@gmail.com', '$2a$12$3Gq3ShiJYhemp20GvmPhMeA8N3suEN2WXSGNn7kDFi0z8iNN.9T4.', '[TEST]username', '2026-02-05 23:35:36', '2026-02-18 23:37:28', '2026-02-18 23:37:28', 'user');

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

--
-- Structure de la table `user_exercise_notes`
--

DROP TABLE IF EXISTS `user_exercise_notes`;
CREATE TABLE IF NOT EXISTS `user_exercise_notes` (
  `id` varchar(36) NOT NULL,
  `user_id` varchar(36) NOT NULL,
  `exercise_id` varchar(36) NOT NULL,
  `note` text NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `uq_user_exercise` (`user_id`,`exercise_id`),
  KEY `exercise_id` (`exercise_id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_exercise_notes` (`id`, `user_id`, `exercise_id`, `note`, `created_at`, `updated_at`) VALUES
('0224da51-28a9-47be-bdd9-444d1e7b5676', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 'Rear delt 4\nAssise 5', '2026-02-16 06:11:15', '2026-02-16 06:11:26'),
('343f1ee3-56d3-44c0-a01d-c6a16f5541e9', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '4668ba82-0038-4745-b597-b1c88a3c4cb7', 'Assise 6', '2026-02-23 11:43:47', '2026-02-23 11:43:47'),
('3491e1ec-5a8e-4d28-8524-ee5671d33037', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Réglage :\nPoitrine 3\nAssise 4', '2026-02-15 12:06:49', '2026-02-15 12:07:05'),
('6e8b4761-ea81-4227-bdc6-012a900cdfc0', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Assise 6', '2026-02-17 05:45:55', '2026-02-17 05:45:58'),
('8cc71c00-f3d1-4c70-ab24-adc04765d613', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '837b4136-27c9-4222-8a66-680111fb57c0', 'Exercice fait en unilatéral', '2026-02-18 11:52:50', '2026-02-18 11:52:55'),
('8fc10dda-2359-4317-9704-d5499bf8ac7e', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'a48e70c6-d165-409f-81df-fa8d5025eccd', 'Réglage assise 70° / -70°', '2026-02-15 12:25:15', '2026-02-15 12:25:25'),
('fa82ece7-82fd-4297-a648-986c95264438', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'a1030256-07c8-4d20-958a-51ae621345f5', 'Assise 5', '2026-02-16 05:27:14', '2026-02-16 05:36:36'),
('fc60414e-bbd9-412c-835c-c50c68c4799a', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Pieds 5\nLombaires 1\nOmoplates 6', '2026-02-15 12:37:54', '2026-02-15 12:38:11');

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

--
-- Structure de la table `user_preferences`
--

DROP TABLE IF EXISTS `user_preferences`;
CREATE TABLE IF NOT EXISTS `user_preferences` (
  `user_id` varchar(36) NOT NULL,
  `theme` enum('light','dark','auto') NOT NULL DEFAULT 'light',
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `receive_communications` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_preferences` (`user_id`, `theme`, `updated_at`, `receive_communications`) VALUES
('efcb0993-6668-4efe-8dea-6c71ad999c0a', 'auto', '2026-02-18 20:04:28', 1);

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

--
-- Structure de la table `workouts`
--

DROP TABLE IF EXISTS `workouts`;
CREATE TABLE IF NOT EXISTS `workouts` (
  `id` varchar(36) NOT NULL,
  `user_id` varchar(36) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_created` (`user_id`,`created_at` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workouts` (`id`, `user_id`, `title`, `description`, `created_at`, `updated_at`) VALUES
('1fb5a1da-7145-4f54-a09e-0dfbd8347f61', 'efcb0993-6668-4efe-8dea-6c71ad999c0b', 'Nouvelle Routine', NULL, '2026-02-18 22:35:07', '2026-02-18 22:35:07'),
('3461d87f-651d-42d1-ba5c-c3a4381fd3fb', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Séance dos', NULL, '2026-02-18 22:23:50', '2026-02-18 22:23:50'),
('7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Séance pecs', NULL, '2026-01-19 12:57:14', '2026-02-05 23:37:11'),
('d0f4341a-e248-44c6-95d8-5c030eb787e4', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', 'Séance Bras', 'Créée à partir de la séance du 19/01/2026', '2026-01-19 08:51:03', '2026-02-05 23:37:11');

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

--
-- Structure de la table `workout_exercises`
--

DROP TABLE IF EXISTS `workout_exercises`;
CREATE TABLE IF NOT EXISTS `workout_exercises` (
  `id` varchar(36) NOT NULL,
  `workout_id` varchar(36) NOT NULL,
  `exercise_id` varchar(36) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `superset_group_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exercise_id` (`exercise_id`),
  KEY `idx_workout` (`workout_id`),
  KEY `idx_position` (`workout_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_exercises` (`id`, `workout_id`, `exercise_id`, `position`, `notes`, `superset_group_id`) VALUES
('0fa6d10f-a559-4537-a972-268281596845', '7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 2, NULL, NULL),
('1002fa43-46e7-4a55-829e-9028f616f5a9', 'd0f4341a-e248-44c6-95d8-5c030eb787e4', '41263e7b-52c0-4de3-875e-e0fbbfd0972d', 2, NULL, NULL),
('44c3135d-d99f-4c7a-ad88-21268d75d398', 'd0f4341a-e248-44c6-95d8-5c030eb787e4', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 1, NULL, 'nix242'),
('45524f79-1d03-4fbd-83dc-731f7b0df06b', 'd0f4341a-e248-44c6-95d8-5c030eb787e4', 'c837e71d-17f5-4778-b90a-2f1215656426', 3, NULL, NULL),
('45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', '7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', 'ce2ba55b-b4ac-4369-b1da-75fda2cb7736', 3, NULL, NULL),
('718e9419-82bd-44a7-b0ae-b92a7f9a901f', '7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 0, NULL, NULL),
('c64ihfxt9', '3461d87f-651d-42d1-ba5c-c3a4381fd3fb', '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 1, NULL, NULL),
('ef0cb633-044f-4147-adce-2d0943d473a5', 'd0f4341a-e248-44c6-95d8-5c030eb787e4', '7b713765-6589-491f-a996-645a8622e802', 0, NULL, 'nix242'),
('f24f962b-d121-4019-9237-ba49c97613e7', 'd0f4341a-e248-44c6-95d8-5c030eb787e4', '479164da-7957-423d-afe5-357966c47dcd', 4, NULL, NULL),
('fab786e9-d8be-4cfd-b176-6ed7e171b2b6', '7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 1, NULL, NULL),
('hhszkfcgp', '3461d87f-651d-42d1-ba5c-c3a4381fd3fb', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 0, NULL, NULL),
('pd2jmrc16', '3461d87f-651d-42d1-ba5c-c3a4381fd3fb', 'be61b2c0-31ff-404a-bb79-21d1d94c6044', 2, NULL, NULL);

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

--
-- Structure de la table `workout_exercise_sets`
--

DROP TABLE IF EXISTS `workout_exercise_sets`;
CREATE TABLE IF NOT EXISTS `workout_exercise_sets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workout_exercise_id` varchar(36) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `reps` varchar(20) DEFAULT NULL,
  `weight` varchar(20) DEFAULT NULL,
  `rest_sec` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_workout_exercise` (`workout_exercise_id`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_exercise_sets` (`id`, `workout_exercise_id`, `position`, `reps`, `weight`, `rest_sec`) VALUES
(58, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 0, '16', '20', 60),
(59, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 1, '12', '60', 60),
(60, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 2, '10', '80', 60),
(61, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 3, '8', '90', 60),
(62, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 4, '4', '100', 60),
(63, '718e9419-82bd-44a7-b0ae-b92a7f9a901f', 5, '4', '100', 60),
(64, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 0, '0', '0', 60),
(65, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 1, NULL, NULL, 60),
(66, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 2, NULL, NULL, 60),
(67, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 3, NULL, NULL, 60),
(68, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 4, NULL, NULL, 60),
(69, 'fab786e9-d8be-4cfd-b176-6ed7e171b2b6', 5, NULL, NULL, 60),
(70, '0fa6d10f-a559-4537-a972-268281596845', 0, '10', '100', 60),
(71, '0fa6d10f-a559-4537-a972-268281596845', 1, NULL, NULL, 60),
(72, '0fa6d10f-a559-4537-a972-268281596845', 2, NULL, NULL, 60),
(73, '0fa6d10f-a559-4537-a972-268281596845', 3, NULL, NULL, 60),
(74, '0fa6d10f-a559-4537-a972-268281596845', 4, NULL, NULL, 60),
(75, '0fa6d10f-a559-4537-a972-268281596845', 5, NULL, NULL, 60),
(76, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 0, '0', '0', 60),
(77, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 1, NULL, NULL, 60),
(78, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 2, NULL, NULL, 60),
(79, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 3, NULL, NULL, 60),
(80, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 4, NULL, NULL, 60),
(81, '45ba42f1-8870-4ea8-b4f0-fdce7b2b92d0', 5, NULL, NULL, 60),
(82, 'ef0cb633-044f-4147-adce-2d0943d473a5', 0, '10', '16', 60),
(83, 'ef0cb633-044f-4147-adce-2d0943d473a5', 1, '10', '16', 60),
(84, 'ef0cb633-044f-4147-adce-2d0943d473a5', 2, '10', '20', 60),
(85, 'ef0cb633-044f-4147-adce-2d0943d473a5', 3, '6', '24', 60),
(86, 'ef0cb633-044f-4147-adce-2d0943d473a5', 4, '8', '24', 60),
(87, 'ef0cb633-044f-4147-adce-2d0943d473a5', 5, '6', '26', 60),
(88, 'ef0cb633-044f-4147-adce-2d0943d473a5', 6, '7', '26', 60),
(89, '44c3135d-d99f-4c7a-ad88-21268d75d398', 0, '12', '12', 60),
(90, '44c3135d-d99f-4c7a-ad88-21268d75d398', 1, '12', '12', 60),
(91, '44c3135d-d99f-4c7a-ad88-21268d75d398', 2, '12', '14', 60),
(92, '44c3135d-d99f-4c7a-ad88-21268d75d398', 3, '12', '16', 60),
(93, '44c3135d-d99f-4c7a-ad88-21268d75d398', 4, '12', '16', 60),
(94, '1002fa43-46e7-4a55-829e-9028f616f5a9', 0, '20', '36', 60),
(95, '1002fa43-46e7-4a55-829e-9028f616f5a9', 1, '12', '64', 60),
(96, '1002fa43-46e7-4a55-829e-9028f616f5a9', 2, '10', '91', 60),
(97, '1002fa43-46e7-4a55-829e-9028f616f5a9', 3, '10', '91', 60),
(98, '1002fa43-46e7-4a55-829e-9028f616f5a9', 4, '10', '96', 60),
(99, '45524f79-1d03-4fbd-83dc-731f7b0df06b', 0, '12', '16', 60),
(100, '45524f79-1d03-4fbd-83dc-731f7b0df06b', 1, '10', '18', 60),
(101, '45524f79-1d03-4fbd-83dc-731f7b0df06b', 2, '4', '24', 60),
(102, '45524f79-1d03-4fbd-83dc-731f7b0df06b', 3, '10', '20', 60),
(103, 'f24f962b-d121-4019-9237-ba49c97613e7', 0, '14', '9', 60),
(104, 'f24f962b-d121-4019-9237-ba49c97613e7', 1, '12', '14', 60),
(105, 'f24f962b-d121-4019-9237-ba49c97613e7', 2, '10', '14', 60),
(112, 'hhszkfcgp', 0, NULL, NULL, 60),
(113, 'c64ihfxt9', 0, NULL, NULL, 60),
(114, 'pd2jmrc16', 0, NULL, NULL, 60);

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

--
-- Structure de la table `workout_exercise_set_drops`
--

DROP TABLE IF EXISTS `workout_exercise_set_drops`;
CREATE TABLE IF NOT EXISTS `workout_exercise_set_drops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workout_set_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `reps` varchar(20) NOT NULL,
  `weight` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_set` (`workout_set_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_exercise_set_drops` (`id`, `workout_set_id`, `position`, `reps`, `weight`) VALUES
(3, 63, 0, '10', '80'),
(4, 63, 1, '12', '60');

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

--
-- Structure de la table `workout_logs`
--

DROP TABLE IF EXISTS `workout_logs`;
CREATE TABLE IF NOT EXISTS `workout_logs` (
  `id` varchar(36) NOT NULL,
  `user_id` varchar(36) NOT NULL,
  `date` timestamp NOT NULL,
  `title` varchar(255) NOT NULL,
  `duration_min` int(11) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  KEY `idx_user_date` (`user_id`,`date` DESC),
  KEY `idx_date` (`date` DESC)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_logs` (`id`, `user_id`, `date`, `title`, `duration_min`, `notes`, `created_at`, `updated_at`) VALUES
('08a76d6d-7e58-457c-b71c-feb797767a3b', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-25 15:36:12', 'Trapèzes lombaires avant épaule', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-18 14:56:05', 'Séance épaules', NULL, 'Un peu de mal à bien respirer sur cette séance...', '2026-02-05 23:37:12', '2026-02-05 23:37:12'),
('0f4fca72-20be-42c7-8cdc-f7140e1c9397', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-17 14:35:25', 'Séance Bras', NULL, NULL, '2026-02-05 23:37:12', '2026-02-05 23:37:12'),
('1fb229c2-4639-4e9b-aa8a-0654c55fb94c', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-20 16:07:41', 'Séance Bras avec Yael', NULL, NULL, '2026-02-05 23:37:12', '2026-02-08 21:40:06'),
('30b6d164-db79-489b-87e8-6e3185f1949e', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-01 12:06:26', 'Séance pecs biceps épaules', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('35cafb53-14a5-4682-b03e-1029c5a8846a', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-13 04:18:03', 'Séance épaules', NULL, NULL, '2026-02-13 05:29:11', '2026-02-13 05:29:11'),
('40881753-7cce-44fe-a99d-420c2fa9786d', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-10 04:20:41', 'Séance dos', NULL, NULL, '2026-02-10 05:28:34', '2026-02-10 05:28:34'),
('4b6b61f0-b177-4170-9605-67daba8af1ea', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-21 19:00:48', 'Renforcement arrière épaules', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('4c286964-6e09-4e36-bf7d-24c3198c5733', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-14 13:26:38', 'Séance bras', NULL, NULL, '2026-02-14 15:46:09', '2026-02-14 15:46:09'),
('4d2ad47e-2f1f-4294-a8ea-fbac3945c4c9', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-27 10:13:33', 'Séance dos', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('4fb0edb5-4991-474b-a210-da39fcced4e2', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-08 10:00:00', 'Séance épaules', NULL, NULL, '2026-02-06 13:35:52', '2026-02-09 07:10:27'),
('5437af5b-60cb-4be9-8936-9a90ec42eafc', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-20 04:03:39', 'Séance petit kiff mais doucement quand même', NULL, 'Pas beaucoup de force et pas ultra motivé.. a cause du manque de sommeil ?', '2026-02-20 05:17:48', '2026-02-20 06:08:57'),
('61bbb35b-6283-45a4-b1da-462354fb30ab', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-17 04:44:42', 'Séance épaules', NULL, 'Rapide car arrivé beaucoup trop tard à la salle et pas très grande forme non plus', '2026-02-17 06:06:24', '2026-02-17 06:06:24'),
('63fc8d0f-22e3-41ff-b0ee-d9cfa7d87a78', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-06 04:06:56', 'Séance pecs', NULL, NULL, '2026-02-06 05:38:46', '2026-02-06 06:20:44'),
('65f4c1fd-e210-4be4-9191-6dc865a69907', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-18 09:40:24', 'Séance Bras', NULL, NULL, '2026-02-18 10:40:30', '2026-02-18 10:40:30'),
('67758c81-9380-4be0-b2d3-ed06f999a943', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-04 04:38:11', 'Séance dos / biceps', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('685b545b-5e7e-4c4d-997b-29d1c8222843', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-23 10:00:00', 'Séance Épaules', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('7815396a-d80f-490c-8cda-a11955c7783a', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-09 15:51:39', 'Séance abdos', NULL, NULL, '2026-02-09 16:52:25', '2026-02-09 16:52:30'),
('85d0f8ca-a8a5-4474-8319-83636a052adf', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-31 09:33:17', 'Séance bras', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('8a28d825-ff0f-49ec-94f5-ed38916d1579', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-23 10:04:13', 'Séance pecs', NULL, NULL, '2026-02-23 11:57:49', '2026-02-23 11:57:49'),
('99e26b05-19d9-45c2-8481-9f3e4baffc59', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-28 03:53:58', 'Séance haut du corps wtf', NULL, NULL, '2026-02-05 23:37:11', '2026-02-08 17:15:11'),
('9dc84dd4-9ef8-4919-8fed-7643e37fd799', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-16 14:45:27', 'Séance Jambes avec Nico', NULL, NULL, '2026-02-05 23:37:12', '2026-02-15 20:27:12'),
('9e806f5b-cef8-41e5-b8f0-b5555f5923d9', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-09 10:00:55', 'Séance bras', NULL, NULL, '2026-02-09 11:33:14', '2026-02-09 11:33:14'),
('a3285fbc-573b-4088-8c71-0015b931e03c', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-29 04:11:27', 'Séance épaules bras', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('a4838740-c88d-44c9-b8f0-e5cfe274c11c', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-22 12:29:28', 'Séance épaules light', NULL, NULL, '2026-02-22 14:07:03', '2026-02-22 14:30:11'),
('b3e5d453-49ef-4090-a62a-81ec16565329', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-22 10:23:39', 'Séance pecs', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('bae5c71a-c35c-46c3-aadf-f82d0d042667', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-19 10:25:17', 'Séance dos', NULL, NULL, '2026-02-19 11:50:19', '2026-02-19 11:50:19'),
('c725332b-a1be-4c1b-a949-4a6f5d5323da', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-24 08:43:23', 'Sénce épaules bras', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('dbf2a01f-0c5e-46a8-8d12-0216ebb8bcbe', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-05 04:16:41', 'Séance dos / triceps', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('e1b8282c-f80f-4dcc-9854-eda0c004f5b5', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-26 18:52:14', 'Séance triceps', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('e570ca25-c86f-4a3c-96cc-5d141053501c', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-30 04:44:42', 'Séance pecs', NULL, NULL, '2026-02-05 23:37:11', '2026-02-05 23:37:11'),
('e6f52fb3-b466-4146-b6bf-5964f298cf88', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-01-19 04:55:31', 'Séance dos', NULL, 'Aucun grip sur le rowing haltères lourd, c\'est relou', '2026-02-05 23:37:12', '2026-02-05 23:37:12'),
('e94135e9-367a-4da9-ba68-c2357355e51b', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-16 04:24:58', 'Séance pecs', NULL, 'Pas de gros exos lourds car peu dormi', '2026-02-16 05:30:02', '2026-02-16 05:30:02'),
('ebe5ae38-e0b5-4ec1-a8c6-a9e2df4087f0', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-11 10:23:22', 'Séance pecs', NULL, NULL, '2026-02-11 11:46:31', '2026-02-11 11:46:31'),
('f0df9843-f1ba-4aa2-92a7-3023ae73b825', 'efcb0993-6668-4efe-8dea-6c71ad999c0a', '2026-02-15 10:33:45', 'Séance dos / abdos', NULL, 'Un peu limité par le timing pour rentrer et continuer les développements', '2026-02-15 12:23:50', '2026-02-15 12:29:14');

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

--
-- Structure de la table `workout_log_exercises`
--

DROP TABLE IF EXISTS `workout_log_exercises`;
CREATE TABLE IF NOT EXISTS `workout_log_exercises` (
  `id` varchar(36) NOT NULL,
  `workout_log_id` varchar(36) NOT NULL,
  `exercise_id` varchar(36) DEFAULT NULL,
  `exercise_name` varchar(255) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `notes` text DEFAULT NULL,
  `superset_group_id` varchar(36) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_log` (`workout_log_id`),
  KEY `idx_exercise` (`exercise_id`),
  KEY `idx_position` (`workout_log_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_log_exercises` (`id`, `workout_log_id`, `exercise_id`, `exercise_name`, `position`, `notes`, `superset_group_id`) VALUES
('00c6284e-718a-47f9-9b20-7719385fa31b', 'e6f52fb3-b466-4146-b6bf-5964f298cf88', '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 'Rowing haltères unilatéral', 2, NULL, NULL),
('02defe6c-1b3d-4bb3-b715-82c6c7854b28', '0f4fca72-20be-42c7-8cdc-f7140e1c9397', '41263e7b-52c0-4de3-875e-e0fbbfd0972d', 'Seated Dip [Basic Fit]', 2, NULL, NULL),
('0565e46d-de2f-49c6-a51f-2f7bf50dc692', '99e26b05-19d9-45c2-8481-9f3e4baffc59', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, NULL),
('0571817e-6120-4677-ac86-006773acdad7', 'dbf2a01f-0c5e-46a8-8d12-0216ebb8bcbe', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 2, NULL, NULL),
('07a3fcee-fc89-4f1d-a182-1194e6915193', '30b6d164-db79-489b-87e8-6e3185f1949e', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 2, NULL, NULL),
('08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', '9dc84dd4-9ef8-4919-8fed-7643e37fd799', '6473c865-05e7-49de-8e1f-e6ea1476da9c', 'Leg Extension [Basic Fit]', 2, NULL, NULL),
('0a3a0c46-c294-4402-93d4-41337515f316', '08a76d6d-7e58-457c-b71c-feb797767a3b', '47e65778-4cfa-48b7-af09-d8bebfe43fd2', 'Shrug haltères', 3, NULL, NULL),
('0b311190-3838-4f04-84c4-505138eba270', 'a3285fbc-573b-4088-8c71-0015b931e03c', '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Rowing arrière épaules poulie basse unilatéral [Basic Fit]', 3, NULL, NULL),
('0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 'c725332b-a1be-4c1b-a949-4a6f5d5323da', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, NULL),
('0e1985ff-549a-4386-9c0b-c74baea4ec8b', '0f4fca72-20be-42c7-8cdc-f7140e1c9397', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, 'jw09em'),
('0r3pj848h', '35cafb53-14a5-4682-b03e-1029c5a8846a', '88647284-2b33-477d-b221-094aedb6b413', 'Butterfly inversé [Basic Fit]', 2, 'Les 134 sont peut-être un peu trop lourds 😅', NULL),
('0vn0wgz8j', '7815396a-d80f-490c-8cda-a11955c7783a', 'dcea8319-b1db-4815-8721-8db30421163d', 'Toe touches', 1, NULL, NULL),
('11d6d163-a145-4a90-a522-1ef1dd8f1652', '1fb229c2-4639-4e9b-aa8a-0654c55fb94c', 'ee31faa6-f4d6-49af-a048-15842f0537ee', 'Curl pupitre disques [ON AIR]', 1, NULL, NULL),
('149c8eaf-bf30-4e60-acec-40cf63206d75', 'c725332b-a1be-4c1b-a949-4a6f5d5323da', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 1, NULL, NULL),
('1698ef4d-de0c-4225-9120-fdbd6333abec', '685b545b-5e7e-4c4d-997b-29d1c8222843', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 1, NULL, NULL),
('16e779b0-531d-4ece-a3a5-069a97f13a5b', '0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 2, NULL, NULL),
('192a3a9a-2eb8-4f03-b92a-0812c2df2182', '685b545b-5e7e-4c4d-997b-29d1c8222843', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé militaire haltères', 0, NULL, NULL),
('1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 'b3e5d453-49ef-4090-a62a-81ec16565329', 'ce2ba55b-b4ac-4369-b1da-75fda2cb7736', 'Développé incliné haltères', 1, NULL, NULL),
('1b3f2edd-6295-4d53-9817-61d71e1d7480', '0f4fca72-20be-42c7-8cdc-f7140e1c9397', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, 'jw09em'),
('1c338f7d-82c6-4f6c-bb15-c13083e227f2', '99e26b05-19d9-45c2-8481-9f3e4baffc59', '9e05044a-0b98-4494-b21c-3733ab8d6e07', 'Extensions triceps barre poulie haute [Basic Fit]', 3, NULL, NULL),
('1el6l7yij', 'ebe5ae38-e0b5-4ec1-a8c6-a9e2df4087f0', '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Écartés inclinés haltères', 1, NULL, NULL),
('1f96f836-049d-46ce-a3ca-615ca65b45aa', 'e570ca25-c86f-4a3c-96cc-5d141053501c', 'cc827237-9767-4068-ad30-d87db444b700', 'Développé couché machine à disques [Basic Fit]', 1, NULL, NULL),
('286920b4-4221-46f1-9774-aa0ed21592e2', '9dc84dd4-9ef8-4919-8fed-7643e37fd799', '8a122806-9b4c-43bb-bf75-18ed7fb6c94e', 'Hip Abduction [Basic Fit]', 0, NULL, NULL),
('2900816a-730e-4c90-8a27-4a9b6bd6e1f9', '4b6b61f0-b177-4170-9605-67daba8af1ea', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 0, NULL, NULL),
('2db1fde2-0765-4a7f-b847-6790fa54745e', '08a76d6d-7e58-457c-b71c-feb797767a3b', '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Back Extension [Basic Fit]', 2, NULL, NULL),
('2ec54efc-cd39-4a6f-9938-bcd151a88a3d', '4d2ad47e-2f1f-4294-a8ea-fbac3945c4c9', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 0, NULL, NULL),
('2k604nogv', 'ebe5ae38-e0b5-4ec1-a8c6-a9e2df4087f0', '5261557e-5405-47b6-9cb0-82fcb274970b', 'Vertical chest press [Basic Fit]', 2, NULL, NULL),
('30ac99a3-d504-4f10-aedf-060125735086', '99e26b05-19d9-45c2-8481-9f3e4baffc59', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 5, NULL, NULL),
('381e3d2a-3f63-47a9-8778-3ee228e1ebbc', '30b6d164-db79-489b-87e8-6e3185f1949e', 'c837e71d-17f5-4778-b90a-2f1215656426', 'Curl pupitre haltère unilatéral', 3, NULL, NULL),
('3igu28npq', '5437af5b-60cb-4be9-8936-9a90ec42eafc', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 3, NULL, NULL),
('48zo0an6g', '4fb0edb5-4991-474b-a210-da39fcced4e2', 'c18ff6af-54f3-4e1e-8a5e-e094b32e5160', 'Butterfly inversé [Fitness Park]', 2, NULL, NULL),
('493bc620-af1e-4fa8-96be-157c2029a111', '99e26b05-19d9-45c2-8481-9f3e4baffc59', '487f326a-4615-4b7e-aff7-dd42e80b625d', 'Abdominal crunch [Basic Fit]', 4, NULL, NULL),
('4c3485e4-dae5-4d10-9125-d7b10cef0e0c', '30b6d164-db79-489b-87e8-6e3185f1949e', '8208ea2e-1d0e-4970-ae1b-3e4a8b3ea8f9', 'Poulie vis à vis H9', 4, NULL, NULL),
('4efa5527-4f7c-43e7-8d05-217416c4258c', 'e570ca25-c86f-4a3c-96cc-5d141053501c', 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'Poulie focus haut de pec H8 [Basic Fit]', 2, NULL, NULL),
('4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', '9dc84dd4-9ef8-4919-8fed-7643e37fd799', 'd5804002-6882-42bf-be2a-6b4410e1830c', 'Hip Adduction [Basic Fit]', 1, NULL, NULL),
('5021dd09-988f-480d-810f-de26d8420a08', '99e26b05-19d9-45c2-8481-9f3e4baffc59', 'a1030256-07c8-4d20-958a-51ae621345f5', 'Chest press [Basic Fit]', 2, NULL, NULL),
('55c7040b-3463-48da-b11f-a788ea475d79', '0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', '3ebc4567-c2bf-4b40-adaf-f92fdd238311', 'Shoulder Press [Basic Fit]', 0, NULL, NULL),
('55d1gowbk', '4c286964-6e09-4e36-bf7d-24c3198c5733', '20b28ca2-4eb2-4678-b81e-581403940785', 'Curl haltères banc incliné 45°', 0, '1ère série à 24kg 6x3x3\n28kg 5x2\n2nde série à 24kg 6x4', 'nmfl6b'),
('55d6bf51-78cf-4510-b245-78db10627a4f', 'c725332b-a1be-4c1b-a949-4a6f5d5323da', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 2, NULL, NULL),
('58unf9yfu', '4fb0edb5-4991-474b-a210-da39fcced4e2', '9320e1c0-09ab-46bb-9a7c-762e136841e5', 'Low row H5 pronation focus arrière épaules [Fitness Park]', 3, NULL, NULL),
('5b272fb3-cc8c-4974-be9e-99ffbc54e3e3', 'b3e5d453-49ef-4090-a62a-81ec16565329', '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 'Butterfly [Basic Fit]', 2, NULL, NULL),
('5d56e55a-cb4c-451d-980a-387268974e59', '1fb229c2-4639-4e9b-aa8a-0654c55fb94c', 'fd1abea4-6347-4bc5-aec7-0a8505fd3545', 'Câble curl [ON AIR]', 2, NULL, NULL),
('5df9cc3a-38b3-4808-8b3d-59e50d63d232', '4d2ad47e-2f1f-4294-a8ea-fbac3945c4c9', 'be61b2c0-31ff-404a-bb79-21d1d94c6044', 'Tirage vertical prise neutre large [Basic Fit]', 2, NULL, NULL),
('5jo4b4i46', 'e94135e9-367a-4da9-ba68-c2357355e51b', 'a1030256-07c8-4d20-958a-51ae621345f5', 'Chest press [Basic Fit]', 0, NULL, NULL),
('64ac2c92-d26a-4b4d-b4e1-0799d944ce9b', 'c725332b-a1be-4c1b-a949-4a6f5d5323da', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 3, NULL, NULL),
('696pbkkk7', '5437af5b-60cb-4be9-8936-9a90ec42eafc', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 2, 'Sangles sur les 120kg', NULL),
('73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', '0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', '4d96caf1-2912-4c43-bafc-8ad8cd2c6498', 'Élévations latérales buste incliné sur banc', 3, NULL, NULL),
('7a276cf0-2049-416d-907d-4b7bd2e1904b', '85d0f8ca-a8a5-4474-8319-83636a052adf', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 2, NULL, NULL),
('84bfj2teh', 'a4838740-c88d-44c9-b8f0-e5cfe274c11c', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 2, NULL, 'ez4s04'),
('8669c72f-f205-461a-b34a-f21fec3a833b', '08a76d6d-7e58-457c-b71c-feb797767a3b', 'bb930f98-785a-4e86-ac70-0592fd9940a3', 'Élévations frontales haltères', 0, NULL, NULL),
('86e92ct3u', 'a4838740-c88d-44c9-b8f0-e5cfe274c11c', '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Rowing arrière épaules poulie basse unilatéral [Basic Fit]', 3, NULL, NULL),
('8a87aab2-26da-4c17-bfa5-3c637e461d4d', '67758c81-9380-4be0-b2d3-ed06f999a943', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 1, NULL, NULL),
('8ddf6f40-1a44-4319-b352-8e0441ce40b0', '1fb229c2-4639-4e9b-aa8a-0654c55fb94c', 'a6ce4dfd-12bd-4881-863d-60cea2b8cc94', 'Extension triceps machine [ON AIR]', 4, NULL, NULL),
('8f4nh3zrl', '4fb0edb5-4991-474b-a210-da39fcced4e2', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 1, NULL, NULL),
('910wjv305', 'a4838740-c88d-44c9-b8f0-e5cfe274c11c', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 1, NULL, 'ez4s04'),
('92796f55-8bfe-48c4-8191-131897e65b6e', '0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé militaire haltères', 1, NULL, NULL),
('9c48f6f4-8580-4c9d-b7ef-b304f5065189', 'e1b8282c-f80f-4dcc-9854-eda0c004f5b5', '41263e7b-52c0-4de3-875e-e0fbbfd0972d', 'Seated Dip [Basic Fit]', 1, NULL, NULL),
('a0799e3b-e3a0-4383-b81e-2ae6a5513711', '85d0f8ca-a8a5-4474-8319-83636a052adf', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, NULL),
('a18318aa-c27d-4181-a16b-44c646834650', '67758c81-9380-4be0-b2d3-ed06f999a943', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 0, NULL, NULL),
('a2af518f-a8c4-4e3c-852f-4d05d688a603', '85d0f8ca-a8a5-4474-8319-83636a052adf', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, NULL),
('a3565e2c-84cb-43c8-9167-edfcd61e44d8', 'e1b8282c-f80f-4dcc-9854-eda0c004f5b5', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 2, NULL, NULL),
('a5fb66af-e933-4616-b2c3-be5780b63e92', '0f4fca72-20be-42c7-8cdc-f7140e1c9397', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 4, NULL, NULL),
('a95b9a88-7c63-418a-89c8-81c91fae8d04', '08a76d6d-7e58-457c-b71c-feb797767a3b', '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Converging Shoulder Press [Basic Fit]', 1, NULL, NULL),
('abv3fi10r', '40881753-7cce-44fe-a99d-420c2fa9786d', '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Back Extension [Basic Fit]', 2, NULL, NULL),
('acl9lpqwk', '63fc8d0f-22e3-41ff-b0ee-d9cfa7d87a78', '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 'Butterfly [Basic Fit]', 2, NULL, NULL),
('ad40d3c8-8294-448c-85e4-7a3eeaab8096', '4d2ad47e-2f1f-4294-a8ea-fbac3945c4c9', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 3, NULL, NULL),
('ahjvxnnk9', '4c286964-6e09-4e36-bf7d-24c3198c5733', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, 'nmfl6b'),
('ay2v1m8r4', '9e806f5b-cef8-41e5-b8f0-b5555f5923d9', '41263e7b-52c0-4de3-875e-e0fbbfd0972d', 'Seated Dip [Basic Fit]', 3, NULL, NULL),
('b2953696-8767-4691-a9d9-49bbaa3e270a', 'a3285fbc-573b-4088-8c71-0015b931e03c', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, NULL),
('b2rfj873r', '4c286964-6e09-4e36-bf7d-24c3198c5733', 'c837e71d-17f5-4778-b90a-2f1215656426', 'Curl pupitre haltère unilatéral', 3, 'Assise réglée à 3 pour être confortable au curl', NULL),
('b50a86e1-284a-4eb7-a15d-6390632a874a', '1fb229c2-4639-4e9b-aa8a-0654c55fb94c', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 3, NULL, NULL),
('b6mo66uif', 'e94135e9-367a-4da9-ba68-c2357355e51b', '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Écartés inclinés haltères', 1, NULL, NULL),
('b898d5af-02b2-4e2f-9d53-7b36ab66f53b', '99e26b05-19d9-45c2-8481-9f3e4baffc59', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 0, NULL, NULL),
('ba7c7e88-b6ac-426f-9b41-039413239576', 'e6f52fb3-b466-4146-b6bf-5964f298cf88', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 0, NULL, NULL),
('bc696438-10ff-429f-943b-fe550800af79', 'e1b8282c-f80f-4dcc-9854-eda0c004f5b5', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 0, NULL, NULL),
('bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 'b3e5d453-49ef-4090-a62a-81ec16565329', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Développé couché barre', 0, NULL, NULL),
('blfyen5qa', '61bbb35b-6283-45a4-b1da-462354fb30ab', '88647284-2b33-477d-b221-094aedb6b413', 'Butterfly inversé [Basic Fit]', 1, NULL, NULL),
('bx7grpj91', '63fc8d0f-22e3-41ff-b0ee-d9cfa7d87a78', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Développé couché barre', 0, NULL, NULL),
('c47c8e8b-c24e-4af5-987c-9e238ebd0213', 'a3285fbc-573b-4088-8c71-0015b931e03c', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 2, NULL, NULL),
('c529c989-f412-4653-a5b3-3217311bfca2', '4d2ad47e-2f1f-4294-a8ea-fbac3945c4c9', '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 'Rowing haltères unilatéral', 1, NULL, NULL),
('c71ddd85-6479-4faf-bd8e-899da8a93310', 'dbf2a01f-0c5e-46a8-8d12-0216ebb8bcbe', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 1, NULL, NULL),
('cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 'dbf2a01f-0c5e-46a8-8d12-0216ebb8bcbe', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 0, NULL, NULL),
('ce2a1c80-80ad-4e39-a761-36605f98e4e0', '4b6b61f0-b177-4170-9605-67daba8af1ea', '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Rowing arrière épaules poulie basse unilatéral [Basic Fit]', 1, NULL, NULL),
('d0c2cab0-8a8f-4b93-b606-6b715ce0834b', 'e570ca25-c86f-4a3c-96cc-5d141053501c', '5261557e-5405-47b6-9cb0-82fcb274970b', 'Vertical chest press [Basic Fit]', 0, NULL, NULL),
('d8c9b425-b77b-4298-a3a9-c6ebe346d502', 'b3e5d453-49ef-4090-a62a-81ec16565329', '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Écartés inclinés haltères', 3, NULL, NULL),
('da15bfd9-6554-4cd6-b6d0-58fef9197055', '0f4fca72-20be-42c7-8cdc-f7140e1c9397', 'c837e71d-17f5-4778-b90a-2f1215656426', 'Curl pupitre haltère unilatéral', 3, NULL, NULL),
('deea1fcb-6ac8-40fa-bc36-379f3e47ca08', '9dc84dd4-9ef8-4919-8fed-7643e37fd799', '2acbcc00-05e8-4138-9cd1-90abc352a604', 'Prone Leg Curl [Basic Fit]', 3, NULL, NULL),
('df3b7785-1632-4d2b-9d7a-49b437b2a029', 'a3285fbc-573b-4088-8c71-0015b931e03c', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé militaire haltères', 1, NULL, NULL),
('e1f19416-fdee-405e-aff6-7ff69408e867', '685b545b-5e7e-4c4d-997b-29d1c8222843', '88647284-2b33-477d-b221-094aedb6b413', 'Butterfly inversé [Basic Fit]', 2, NULL, NULL),
('e39be2c5-1ff9-4ee9-857e-8cedff65ede1', 'dbf2a01f-0c5e-46a8-8d12-0216ebb8bcbe', 'c837e71d-17f5-4778-b90a-2f1215656426', 'Curl pupitre haltère unilatéral', 3, NULL, NULL),
('e9db3a22-e25a-4a90-8f73-62fa0679eb8d', '30b6d164-db79-489b-87e8-6e3185f1949e', 'edad72d2-46c5-46be-9fef-94ebfb5ff033', 'Développé couché haltères', 1, NULL, NULL),
('ede8130b-8a09-44b0-a011-730b1537f6c2', '30b6d164-db79-489b-87e8-6e3185f1949e', '20b28ca2-4eb2-4678-b81e-581403940785', 'Curl haltères banc incliné 45°', 0, NULL, NULL),
('eqju4dl8d', '35cafb53-14a5-4682-b03e-1029c5a8846a', '9d342e22-a950-4aef-a304-6a9ff262efd0', 'Rowing arrière épaules poulie basse unilatéral [Basic Fit]', 3, 'Un peu de mal à avoir une bonne forme sur les 25kg', NULL),
('ew1dor0yv', '40881753-7cce-44fe-a99d-420c2fa9786d', 'be61b2c0-31ff-404a-bb79-21d1d94c6044', 'Tirage vertical prise neutre large [Basic Fit]', 0, NULL, NULL),
('f3185304-ed5a-41bc-bf2a-4526bda9d87b', '30b6d164-db79-489b-87e8-6e3185f1949e', '3f18fba0-d36f-4669-afd9-5ae5a9365bd9', 'L-Fly poulie H9', 5, NULL, NULL),
('f3ba925c-e164-474e-81e7-486fb915c524', 'e6f52fb3-b466-4146-b6bf-5964f298cf88', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 1, NULL, NULL),
('f9178f4e-21f1-4f83-9127-b968b8b0f1a9', '1fb229c2-4639-4e9b-aa8a-0654c55fb94c', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, NULL),
('fd01c7c1-db51-4033-ae6b-9049d5798897', '0c1bb67d-fef1-4ccf-b31f-b3649e4bf218', 'bb930f98-785a-4e86-ac70-0592fd9940a3', 'Élévations frontales haltères', 4, NULL, NULL),
('fdd3f675-6d4d-44b3-8fcd-bfd928a7b3fa', '9dc84dd4-9ef8-4919-8fed-7643e37fd799', '51b12d28-34b6-411a-9d39-ce434064c5ac', 'Presse Inclinée [Basic Fit]', 4, NULL, NULL),
('fe6d3559-37d6-4375-bdc9-568d6119f099', '4b6b61f0-b177-4170-9605-67daba8af1ea', '88647284-2b33-477d-b221-094aedb6b413', 'Butterfly inversé [Basic Fit]', 2, NULL, NULL),
('fe881788-368b-4f48-866b-4efb9543b343', '4b6b61f0-b177-4170-9605-67daba8af1ea', '4d96caf1-2912-4c43-bafc-8ad8cd2c6498', 'Élévations latérales buste incliné sur banc', 3, NULL, NULL),
('ftg3pw6n5', '4c286964-6e09-4e36-bf7d-24c3198c5733', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 2, NULL, NULL),
('fzeado5ay', 'ebe5ae38-e0b5-4ec1-a8c6-a9e2df4087f0', 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'Poulie focus haut de pec H8 [Basic Fit]', 3, NULL, NULL),
('h46ulva40', 'ebe5ae38-e0b5-4ec1-a8c6-a9e2df4087f0', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Développé couché barre', 0, NULL, NULL),
('hkbxk9uo1', 'f0df9843-f1ba-4aa2-92a7-3023ae73b825', '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Back Extension [Basic Fit]', 3, 'Exercice fait sans se tenir jusqu\'à 113kg. Utilisation des poignées au delà pour faciliter le mouvement et soulager le dos', NULL),
('hz3lsr2gf', '9e806f5b-cef8-41e5-b8f0-b5555f5923d9', '479164da-7957-423d-afe5-357966c47dcd', 'Extensions triceps poulie haute corde unilatéral [Basic Fit]', 2, NULL, NULL),
('hzkvjec67', '65f4c1fd-e210-4be4-9191-6dc865a69907', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, 'nix242'),
('idf6ppw89', '4fb0edb5-4991-474b-a210-da39fcced4e2', '6264be19-5c19-42b4-9b46-01d8d63d4d14', 'Delts machine [Fitness Park]', 4, NULL, NULL),
('iy9vhntiu', '9e806f5b-cef8-41e5-b8f0-b5555f5923d9', 'c837e71d-17f5-4778-b90a-2f1215656426', 'Curl pupitre haltère unilatéral', 4, NULL, NULL),
('jisfmy9fv', '61bbb35b-6283-45a4-b1da-462354fb30ab', '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Converging Shoulder Press [Basic Fit]', 0, NULL, NULL),
('kg1foccwh', 'a4838740-c88d-44c9-b8f0-e5cfe274c11c', '14e3dea5-e7b5-4f8a-98bd-19b4b82497c3', 'Converging Shoulder Press [Basic Fit]', 0, NULL, NULL),
('l6w1bkiox', 'f0df9843-f1ba-4aa2-92a7-3023ae73b825', 'a48e70c6-d165-409f-81df-fa8d5025eccd', 'Rotary torso [Basic Fit]', 2, NULL, NULL),
('l7ao3ylpu', '63fc8d0f-22e3-41ff-b0ee-d9cfa7d87a78', 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'Poulie focus haut de pec H8', 1, NULL, NULL),
('lyvuulhbv', 'e94135e9-367a-4da9-ba68-c2357355e51b', '92c90bf0-fe47-46bf-8345-2911d1c04ca9', 'Butterfly [Basic Fit]', 3, NULL, NULL),
('nxsh3e960', '65f4c1fd-e210-4be4-9191-6dc865a69907', '837b4136-27c9-4222-8a66-680111fb57c0', 'Arm curl pupitre [Basic Fit]', 2, NULL, NULL),
('o9a328pk1', '7815396a-d80f-490c-8cda-a11955c7783a', 'abb2e085-d1f0-480f-a550-17505346efc9', 'Crunchs', 0, NULL, NULL),
('oed2mn8mi', 'f0df9843-f1ba-4aa2-92a7-3023ae73b825', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 0, 'Série à 86kg 6x2x2', NULL),
('p0mdlpsre', '5437af5b-60cb-4be9-8936-9a90ec42eafc', 'd75dc64b-afb4-48ea-976b-4018bc85214a', 'Rowing poulie basse unilatéral [Basic Fit]', 0, 'Sangles sur les 59kg', NULL),
('p0zjqsn7s', '8a28d825-ff0f-49ec-94f5-ed38916d1579', '75a5310d-e415-4f99-b892-8a4591bc77c2', 'Écartés inclinés haltères', 1, NULL, NULL),
('q940pd8jd', '40881753-7cce-44fe-a99d-420c2fa9786d', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 1, NULL, NULL),
('qyi3jnmnz', '65f4c1fd-e210-4be4-9191-6dc865a69907', '20b28ca2-4eb2-4678-b81e-581403940785', 'Curl haltères banc incliné 45°', 0, '26kg 6x3x3\n28kg 3x2x2\n2nde série à 24kg 6x4', 'nix242'),
('rsoqtw6z9', 'bae5c71a-c35c-46c3-aadf-f82d0d042667', '09a743aa-b3f7-4f59-96f1-7f1bf35f9b4f', 'Rowing haltères unilatéral', 1, 'Utilisation sangles de tirage sur les 50kg', NULL),
('rtzrohnha', 'f0df9843-f1ba-4aa2-92a7-3023ae73b825', '1cd35d53-38d0-403e-8e60-f209f1ca70d0', 'Seated row [Basic Fit]', 1, NULL, NULL),
('sbg329fzm', 'bae5c71a-c35c-46c3-aadf-f82d0d042667', '6ca8fdcd-0491-4955-80ef-8357ba4e1da9', 'Tirage vertical pronation prise large [Basic Fit]', 0, 'Utilisation des sangles de tirage pour les 107kg', NULL),
('tndhospv8', '5437af5b-60cb-4be9-8936-9a90ec42eafc', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 1, NULL, NULL),
('uky6zqyhr', '9e806f5b-cef8-41e5-b8f0-b5555f5923d9', '3ea3af4a-c0c5-4c4f-9e20-ad198b2df53b', 'Overhead triceps extensions haltères', 1, NULL, 'n83o4x'),
('unuwklgfk', '35cafb53-14a5-4682-b03e-1029c5a8846a', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé militaire haltères', 0, 'Grosses douleurs au genou gauche empêchant de monter les poids normalement', NULL),
('vikywmtqp', '4c286964-6e09-4e36-bf7d-24c3198c5733', 'd8e8d29b-0fad-4ee5-99e6-99c177cd9898', 'Skull crusher haltères', 4, NULL, NULL),
('vjmb3jptu', 'e94135e9-367a-4da9-ba68-c2357355e51b', 'c7035b15-9065-40b9-8690-b89c6e7d0d6e', 'Poulie focus haut de pec H8 [Basic Fit]', 2, NULL, NULL),
('wb0kim2mc', '8a28d825-ff0f-49ec-94f5-ed38916d1579', 'e9a7b8c9-8b5d-48c2-addd-80d569cb6c24', 'Développé couché barre', 0, 'Beaucoup de mal sur ma 2nde série à 100kg : 3x2x2', NULL),
('xcwlkmxuv', '4fb0edb5-4991-474b-a210-da39fcced4e2', 'a2cdac7f-232e-487e-b756-7ee914746605', 'Développé militaire haltères', 0, NULL, NULL),
('xuv9fwwfj', '35cafb53-14a5-4682-b03e-1029c5a8846a', '668ba904-9ea9-4d99-a204-035774c34507', 'Élévations latérales haltères', 1, NULL, NULL),
('yho48vp53', '7815396a-d80f-490c-8cda-a11955c7783a', '6ea94b31-61c6-48b4-8e39-b3966c5236b6', 'Planche', 2, NULL, NULL),
('z1ul528zw', 'bae5c71a-c35c-46c3-aadf-f82d0d042667', '88f067c6-aac7-44e8-a67d-2f12a37a43ac', 'Back Extension [Basic Fit]', 2, NULL, NULL),
('zk8dvxbyu', '9e806f5b-cef8-41e5-b8f0-b5555f5923d9', '7b713765-6589-491f-a996-645a8622e802', 'Curl biceps haltères', 0, NULL, 'n83o4x'),
('zqa536bm2', '8a28d825-ff0f-49ec-94f5-ed38916d1579', '4668ba82-0038-4745-b597-b1c88a3c4cb7', 'Converging chest press [Basic Fit]', 2, NULL, NULL);

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

--
-- Structure de la table `workout_log_exercise_sets`
--

DROP TABLE IF EXISTS `workout_log_exercise_sets`;
CREATE TABLE IF NOT EXISTS `workout_log_exercise_sets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workout_log_exercise_id` varchar(36) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `reps` int(11) NOT NULL,
  `weight` decimal(8,2) NOT NULL,
  `rpe` int(11) DEFAULT NULL,
  `completed` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_log_exercise` (`workout_log_exercise_id`,`position`)
) ENGINE=InnoDB AUTO_INCREMENT=2386 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_log_exercise_sets` (`id`, `workout_log_exercise_id`, `position`, `reps`, `weight`, `rpe`, `completed`) VALUES
(18, 'a18318aa-c27d-4181-a16b-44c646834650', 0, 16, 45.00, 7, 0),
(19, 'a18318aa-c27d-4181-a16b-44c646834650', 1, 16, 66.00, 7, 0),
(20, 'a18318aa-c27d-4181-a16b-44c646834650', 2, 12, 86.00, 7, 0),
(21, 'a18318aa-c27d-4181-a16b-44c646834650', 3, 10, 100.00, 7, 0),
(22, 'a18318aa-c27d-4181-a16b-44c646834650', 4, 10, 73.00, 7, 0),
(23, '8a87aab2-26da-4c17-bfa5-3c637e461d4d', 0, 12, 16.00, 7, 0),
(24, '8a87aab2-26da-4c17-bfa5-3c637e461d4d', 1, 12, 20.00, 7, 0),
(25, '8a87aab2-26da-4c17-bfa5-3c637e461d4d', 2, 10, 26.00, 7, 0),
(26, '8a87aab2-26da-4c17-bfa5-3c637e461d4d', 3, 4, 30.00, 7, 0),
(27, '8a87aab2-26da-4c17-bfa5-3c637e461d4d', 4, 10, 26.00, 7, 0),
(28, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 0, 12, 16.00, 7, 0),
(29, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 1, 10, 20.00, 7, 0),
(30, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 2, 10, 24.00, 7, 0),
(31, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 3, 5, 28.00, 7, 0),
(32, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 4, 10, 24.00, 7, 0),
(33, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 5, 10, 20.00, 7, 0),
(34, 'ede8130b-8a09-44b0-a011-730b1537f6c2', 6, 10, 20.00, 7, 0),
(35, 'e9db3a22-e25a-4a90-8f73-62fa0679eb8d', 0, 16, 20.00, 7, 0),
(36, 'e9db3a22-e25a-4a90-8f73-62fa0679eb8d', 1, 12, 30.00, 7, 0),
(37, 'e9db3a22-e25a-4a90-8f73-62fa0679eb8d', 2, 10, 40.00, 7, 0),
(38, 'e9db3a22-e25a-4a90-8f73-62fa0679eb8d', 3, 6, 46.00, 7, 0),
(39, 'e9db3a22-e25a-4a90-8f73-62fa0679eb8d', 4, 8, 40.00, 7, 0),
(40, '07a3fcee-fc89-4f1d-a182-1194e6915193', 0, 16, 12.00, 7, 0),
(41, '07a3fcee-fc89-4f1d-a182-1194e6915193', 1, 16, 16.00, 7, 0),
(42, '07a3fcee-fc89-4f1d-a182-1194e6915193', 2, 16, 18.00, 7, 0),
(43, '07a3fcee-fc89-4f1d-a182-1194e6915193', 3, 10, 20.00, 7, 0),
(44, '07a3fcee-fc89-4f1d-a182-1194e6915193', 4, 10, 20.00, 7, 0),
(45, '07a3fcee-fc89-4f1d-a182-1194e6915193', 5, 12, 16.00, 7, 0),
(46, '381e3d2a-3f63-47a9-8778-3ee228e1ebbc', 0, 12, 16.00, 7, 0),
(47, '381e3d2a-3f63-47a9-8778-3ee228e1ebbc', 1, 10, 20.00, 7, 0),
(48, '381e3d2a-3f63-47a9-8778-3ee228e1ebbc', 2, 4, 26.00, 7, 0),
(49, '381e3d2a-3f63-47a9-8778-3ee228e1ebbc', 3, 10, 20.00, 7, 0),
(50, '4c3485e4-dae5-4d10-9125-d7b10cef0e0c', 0, 10, 14.00, 7, 0),
(51, '4c3485e4-dae5-4d10-9125-d7b10cef0e0c', 1, 10, 23.00, 7, 0),
(52, 'f3185304-ed5a-41bc-bf2a-4526bda9d87b', 0, 10, 4.50, 7, 0),
(53, 'f3185304-ed5a-41bc-bf2a-4526bda9d87b', 1, 10, 4.50, 7, 0),
(54, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 0, 12, 16.00, 7, 0),
(55, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 1, 12, 20.00, 7, 0),
(56, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 2, 10, 26.00, 7, 0),
(57, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 3, 4, 30.00, 7, 0),
(58, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 4, 10, 26.00, 7, 0),
(59, 'a0799e3b-e3a0-4383-b81e-2ae6a5513711', 5, 8, 26.00, 7, 0),
(60, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 0, 12, 12.00, 7, 0),
(61, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 1, 12, 16.00, 7, 0),
(62, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 2, 10, 18.00, 7, 0),
(63, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 3, 5, 20.00, 7, 0),
(64, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 4, 10, 16.00, 7, 0),
(65, 'a2af518f-a8c4-4e3c-852f-4d05d688a603', 5, 10, 16.00, 7, 0),
(66, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 0, 12, 9.00, 7, 0),
(67, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 1, 12, 14.00, 7, 0),
(68, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 2, 10, 16.00, 7, 0),
(69, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 3, 12, 14.00, 7, 0),
(70, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 4, 12, 14.00, 7, 0),
(71, '7a276cf0-2049-416d-907d-4b7bd2e1904b', 5, 12, 14.00, 7, 0),
(84, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 0, 14, 16.00, 7, 0),
(85, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 1, 12, 20.00, 7, 0),
(86, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 2, 10, 26.00, 7, 0),
(87, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 3, 3, 30.00, 7, 0),
(88, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 4, 3, 30.00, 7, 0),
(89, 'b2953696-8767-4691-a9d9-49bbaa3e270a', 5, 6, 26.00, 7, 0),
(90, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 0, 20, 20.00, 7, 0),
(91, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 1, 10, 30.00, 7, 0),
(92, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 2, 10, 36.00, 7, 0),
(93, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 3, 8, 40.00, 7, 0),
(94, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 4, 5, 40.00, 7, 0),
(95, 'df3b7785-1632-4d2b-9d7a-49b437b2a029', 5, 11, 32.00, 7, 0),
(96, 'c47c8e8b-c24e-4af5-987c-9e238ebd0213', 0, 16, 8.00, 7, 0),
(97, 'c47c8e8b-c24e-4af5-987c-9e238ebd0213', 1, 16, 12.00, 7, 0),
(98, 'c47c8e8b-c24e-4af5-987c-9e238ebd0213', 2, 12, 16.00, 7, 0),
(99, 'c47c8e8b-c24e-4af5-987c-9e238ebd0213', 3, 10, 18.00, 7, 0),
(100, 'c47c8e8b-c24e-4af5-987c-9e238ebd0213', 4, 14, 12.00, 7, 0),
(101, '0b311190-3838-4f04-84c4-505138eba270', 0, 10, 11.00, 7, 0),
(102, '0b311190-3838-4f04-84c4-505138eba270', 1, 10, 11.00, 7, 0),
(103, '0b311190-3838-4f04-84c4-505138eba270', 2, 10, 11.00, 7, 0),
(131, '2ec54efc-cd39-4a6f-9938-bcd151a88a3d', 0, 16, 39.00, 7, 0),
(132, '2ec54efc-cd39-4a6f-9938-bcd151a88a3d', 1, 12, 52.00, 7, 0),
(133, '2ec54efc-cd39-4a6f-9938-bcd151a88a3d', 2, 12, 66.00, 7, 0),
(134, '2ec54efc-cd39-4a6f-9938-bcd151a88a3d', 3, 12, 79.00, 7, 0),
(135, '2ec54efc-cd39-4a6f-9938-bcd151a88a3d', 4, 6, 86.00, 7, 0),
(136, 'c529c989-f412-4653-a5b3-3217311bfca2', 0, 12, 26.00, 7, 0),
(137, 'c529c989-f412-4653-a5b3-3217311bfca2', 1, 12, 36.00, 7, 0),
(138, 'c529c989-f412-4653-a5b3-3217311bfca2', 2, 8, 46.00, 7, 0),
(139, 'c529c989-f412-4653-a5b3-3217311bfca2', 3, 8, 46.00, 7, 0),
(140, '5df9cc3a-38b3-4808-8b3d-59e50d63d232', 0, 12, 39.00, 7, 0),
(141, '5df9cc3a-38b3-4808-8b3d-59e50d63d232', 1, 12, 52.00, 7, 0),
(142, '5df9cc3a-38b3-4808-8b3d-59e50d63d232', 2, 12, 66.00, 7, 0),
(143, '5df9cc3a-38b3-4808-8b3d-59e50d63d232', 3, 10, 73.00, 7, 0),
(144, 'ad40d3c8-8294-448c-85e4-7a3eeaab8096', 0, 16, 45.00, 7, 0),
(145, 'ad40d3c8-8294-448c-85e4-7a3eeaab8096', 1, 12, 66.00, 7, 0),
(146, 'ad40d3c8-8294-448c-85e4-7a3eeaab8096', 2, 12, 86.00, 7, 0),
(147, 'ad40d3c8-8294-448c-85e4-7a3eeaab8096', 3, 8, 100.00, 7, 0),
(148, 'bc696438-10ff-429f-943b-fe550800af79', 0, 12, 10.00, 7, 0),
(149, 'bc696438-10ff-429f-943b-fe550800af79', 1, 12, 10.00, 7, 0),
(150, 'bc696438-10ff-429f-943b-fe550800af79', 2, 12, 14.00, 7, 0),
(151, 'bc696438-10ff-429f-943b-fe550800af79', 3, 12, 16.00, 7, 0),
(152, 'bc696438-10ff-429f-943b-fe550800af79', 4, 6, 18.00, 7, 0),
(153, 'bc696438-10ff-429f-943b-fe550800af79', 5, 5, 18.00, 7, 0),
(154, '9c48f6f4-8580-4c9d-b7ef-b304f5065189', 0, 10, 73.00, 7, 0),
(155, '9c48f6f4-8580-4c9d-b7ef-b304f5065189', 1, 10, 91.00, 7, 0),
(156, '9c48f6f4-8580-4c9d-b7ef-b304f5065189', 2, 10, 91.00, 7, 0),
(157, 'a3565e2c-84cb-43c8-9167-edfcd61e44d8', 0, 16, 9.00, 7, 0),
(158, 'a3565e2c-84cb-43c8-9167-edfcd61e44d8', 1, 14, 14.00, 7, 0),
(159, 'a3565e2c-84cb-43c8-9167-edfcd61e44d8', 2, 10, 14.00, 7, 0),
(160, 'a3565e2c-84cb-43c8-9167-edfcd61e44d8', 3, 10, 14.00, 7, 0),
(161, '8669c72f-f205-461a-b34a-f21fec3a833b', 0, 14, 8.00, 7, 0),
(162, '8669c72f-f205-461a-b34a-f21fec3a833b', 1, 12, 12.00, 7, 0),
(163, '8669c72f-f205-461a-b34a-f21fec3a833b', 2, 10, 14.00, 7, 0),
(164, '8669c72f-f205-461a-b34a-f21fec3a833b', 3, 10, 12.00, 7, 0),
(165, 'a95b9a88-7c63-418a-89c8-81c91fae8d04', 0, 12, 27.00, 7, 0),
(166, 'a95b9a88-7c63-418a-89c8-81c91fae8d04', 1, 12, 27.00, 7, 0),
(167, 'a95b9a88-7c63-418a-89c8-81c91fae8d04', 2, 10, 50.00, 7, 0),
(168, 'a95b9a88-7c63-418a-89c8-81c91fae8d04', 3, 3, 64.00, 7, 0),
(169, 'a95b9a88-7c63-418a-89c8-81c91fae8d04', 4, 6, 50.00, 7, 0),
(170, '2db1fde2-0765-4a7f-b847-6790fa54745e', 0, 10, 45.00, 7, 0),
(171, '2db1fde2-0765-4a7f-b847-6790fa54745e', 1, 10, 73.00, 7, 0),
(172, '2db1fde2-0765-4a7f-b847-6790fa54745e', 2, 12, 107.00, 7, 0),
(173, '2db1fde2-0765-4a7f-b847-6790fa54745e', 3, 10, 134.00, 7, 0),
(174, '2db1fde2-0765-4a7f-b847-6790fa54745e', 4, 10, 134.00, 7, 0),
(175, '0a3a0c46-c294-4402-93d4-41337515f316', 0, 12, 20.00, 7, 0),
(176, '0a3a0c46-c294-4402-93d4-41337515f316', 1, 12, 30.00, 7, 0),
(177, '0a3a0c46-c294-4402-93d4-41337515f316', 2, 12, 40.00, 7, 0),
(178, '0a3a0c46-c294-4402-93d4-41337515f316', 3, 10, 50.00, 7, 0),
(215, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 0, 16, 20.00, 7, 0),
(216, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 1, 12, 60.00, 7, 0),
(217, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 2, 10, 80.00, 7, 0),
(218, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 3, 10, 90.00, 7, 0),
(219, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 4, 5, 100.00, 7, 0),
(220, 'bdf1ca52-2d27-4976-b24a-fc99f5e1e19b', 5, 5, 100.00, 7, 0),
(221, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 0, 10, 22.00, 7, 0),
(222, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 1, 10, 26.00, 7, 0),
(223, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 2, 10, 32.00, 7, 0),
(224, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 3, 10, 36.00, 7, 0),
(225, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 4, 8, 36.00, 7, 0),
(226, '1ab1ee5f-1d95-457e-abc0-6b93f396d6ec', 5, 10, 26.00, 7, 0),
(227, '5b272fb3-cc8c-4974-be9e-99ffbc54e3e3', 0, 16, 52.00, 7, 0),
(228, '5b272fb3-cc8c-4974-be9e-99ffbc54e3e3', 1, 12, 100.00, 7, 0),
(229, '5b272fb3-cc8c-4974-be9e-99ffbc54e3e3', 2, 10, 120.00, 7, 0),
(230, '5b272fb3-cc8c-4974-be9e-99ffbc54e3e3', 3, 10, 134.00, 7, 0),
(231, 'd8c9b425-b77b-4298-a3a9-c6ebe346d502', 0, 10, 12.00, 7, 0),
(232, 'd8c9b425-b77b-4298-a3a9-c6ebe346d502', 1, 10, 12.00, 7, 0),
(233, 'd8c9b425-b77b-4298-a3a9-c6ebe346d502', 2, 10, 16.00, 7, 0),
(234, 'd8c9b425-b77b-4298-a3a9-c6ebe346d502', 3, 10, 16.00, 7, 0),
(235, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 0, 16, 39.00, 7, 0),
(236, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 1, 12, 45.00, 7, 0),
(237, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 2, 10, 66.00, 7, 0),
(238, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 3, 10, 73.00, 7, 0),
(239, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 4, 10, 86.00, 7, 0),
(240, '2900816a-730e-4c90-8a27-4a9b6bd6e1f9', 5, 12, 66.00, 7, 0),
(241, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 0, 10, 11.00, 7, 0),
(242, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 1, 10, 18.00, 7, 0),
(243, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 2, 10, 13.30, 7, 0),
(244, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 3, 12, 11.00, 7, 0),
(245, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 4, 14, 11.00, 7, 0),
(246, 'ce2a1c80-80ad-4e39-a761-36605f98e4e0', 5, 14, 11.00, 7, 0),
(247, 'fe6d3559-37d6-4375-bdc9-568d6119f099', 0, 10, 45.00, 7, 0),
(248, 'fe6d3559-37d6-4375-bdc9-568d6119f099', 1, 10, 73.00, 7, 0),
(249, 'fe6d3559-37d6-4375-bdc9-568d6119f099', 2, 10, 100.00, 7, 0),
(250, 'fe6d3559-37d6-4375-bdc9-568d6119f099', 3, 10, 113.00, 7, 0),
(251, 'fe6d3559-37d6-4375-bdc9-568d6119f099', 4, 10, 100.00, 7, 0),
(252, 'fe881788-368b-4f48-866b-4efb9543b343', 0, 16, 8.00, 7, 0),
(253, 'fe881788-368b-4f48-866b-4efb9543b343', 1, 12, 12.00, 7, 0),
(254, 'fe881788-368b-4f48-866b-4efb9543b343', 2, 12, 14.00, 7, 0),
(255, 'fe881788-368b-4f48-866b-4efb9543b343', 3, 12, 16.00, 7, 0),
(282, 'ba7c7e88-b6ac-426f-9b41-039413239576', 0, 16, 39.00, 7, 0),
(283, 'ba7c7e88-b6ac-426f-9b41-039413239576', 1, 12, 45.00, 7, 0),
(284, 'ba7c7e88-b6ac-426f-9b41-039413239576', 2, 10, 66.00, 7, 0),
(285, 'ba7c7e88-b6ac-426f-9b41-039413239576', 3, 10, 73.00, 7, 0),
(286, 'ba7c7e88-b6ac-426f-9b41-039413239576', 4, 8, 86.00, 7, 0),
(287, 'ba7c7e88-b6ac-426f-9b41-039413239576', 5, 10, 66.00, 7, 0),
(288, 'f3ba925c-e164-474e-81e7-486fb915c524', 0, 16, 39.00, 7, 0),
(289, 'f3ba925c-e164-474e-81e7-486fb915c524', 1, 12, 59.00, 7, 0),
(290, 'f3ba925c-e164-474e-81e7-486fb915c524', 2, 12, 79.00, 7, 0),
(291, 'f3ba925c-e164-474e-81e7-486fb915c524', 3, 8, 93.00, 7, 0),
(292, '00c6284e-718a-47f9-9b20-7719385fa31b', 0, 12, 26.00, 7, 0),
(293, '00c6284e-718a-47f9-9b20-7719385fa31b', 1, 10, 36.00, 7, 0),
(294, '00c6284e-718a-47f9-9b20-7719385fa31b', 2, 10, 42.00, 7, 0),
(295, '00c6284e-718a-47f9-9b20-7719385fa31b', 3, 6, 46.00, 7, 0),
(373, 'cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 0, 16, 9.00, 7, 1),
(374, 'cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 1, 14, 14.00, 7, 1),
(375, 'cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 2, 14, 14.00, 7, 1),
(376, 'cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 3, 14, 14.00, 7, 1),
(377, 'cb81fcc7-34ac-4ad6-9884-d33d0aaab813', 4, 14, 14.00, 7, 1),
(378, 'c71ddd85-6479-4faf-bd8e-899da8a93310', 0, 16, 39.00, 7, 1),
(379, 'c71ddd85-6479-4faf-bd8e-899da8a93310', 1, 12, 52.00, 7, 1),
(380, 'c71ddd85-6479-4faf-bd8e-899da8a93310', 2, 12, 79.00, 7, 1),
(381, 'c71ddd85-6479-4faf-bd8e-899da8a93310', 3, 9, 86.00, 7, 1),
(382, '0571817e-6120-4677-ac86-006773acdad7', 0, 12, 12.00, 7, 1),
(383, '0571817e-6120-4677-ac86-006773acdad7', 1, 12, 16.00, 7, 1),
(384, '0571817e-6120-4677-ac86-006773acdad7', 2, 10, 18.00, 7, 1),
(385, '0571817e-6120-4677-ac86-006773acdad7', 3, 6, 20.00, 7, 1),
(386, '0571817e-6120-4677-ac86-006773acdad7', 4, 10, 16.00, 7, 1),
(387, 'e39be2c5-1ff9-4ee9-857e-8cedff65ede1', 0, 10, 16.00, 7, 1),
(388, 'e39be2c5-1ff9-4ee9-857e-8cedff65ede1', 1, 12, 16.00, 7, 1),
(389, 'e39be2c5-1ff9-4ee9-857e-8cedff65ede1', 2, 12, 20.00, 7, 1),
(429, 'bx7grpj91', 0, 16, 20.00, 7, 1),
(430, 'bx7grpj91', 1, 12, 60.00, 7, 1),
(431, 'bx7grpj91', 2, 12, 80.00, 7, 1),
(432, 'bx7grpj91', 3, 6, 100.00, 7, 1),
(433, 'bx7grpj91', 4, 5, 100.00, 7, 1),
(434, 'bx7grpj91', 5, 4, 100.00, 7, 1),
(435, 'l7ao3ylpu', 0, 12, 14.00, 7, 0),
(436, 'l7ao3ylpu', 1, 12, 23.00, 7, 0),
(437, 'l7ao3ylpu', 2, 12, 32.00, 7, 0),
(438, 'l7ao3ylpu', 3, 6, 41.00, 7, 0),
(439, 'acl9lpqwk', 0, 12, 73.00, 7, 0),
(440, 'acl9lpqwk', 1, 12, 113.00, 7, 0),
(441, 'acl9lpqwk', 2, 12, 134.00, 7, 0),
(442, 'acl9lpqwk', 3, 12, 134.00, 7, 0),
(598, '55c7040b-3463-48da-b11f-a788ea475d79', 0, 12, 27.00, 7, 1),
(599, '55c7040b-3463-48da-b11f-a788ea475d79', 1, 12, 36.00, 7, 1),
(600, '55c7040b-3463-48da-b11f-a788ea475d79', 2, 12, 50.00, 7, 1),
(601, '55c7040b-3463-48da-b11f-a788ea475d79', 3, 12, 64.00, 7, 1),
(602, '55c7040b-3463-48da-b11f-a788ea475d79', 4, 10, 73.00, 7, 1),
(603, '55c7040b-3463-48da-b11f-a788ea475d79', 5, 12, 59.00, 7, 1),
(604, '92796f55-8bfe-48c4-8191-131897e65b6e', 0, 10, 20.00, 7, 1),
(605, '92796f55-8bfe-48c4-8191-131897e65b6e', 1, 12, 20.00, 7, 1),
(606, '92796f55-8bfe-48c4-8191-131897e65b6e', 2, 10, 26.00, 7, 1),
(607, '92796f55-8bfe-48c4-8191-131897e65b6e', 3, 8, 36.00, 7, 1),
(608, '92796f55-8bfe-48c4-8191-131897e65b6e', 4, 8, 32.00, 7, 1),
(609, '92796f55-8bfe-48c4-8191-131897e65b6e', 5, 10, 30.00, 7, 1),
(610, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 0, 16, 12.00, 7, 1),
(611, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 1, 14, 14.00, 7, 1),
(612, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 2, 12, 16.00, 7, 1),
(613, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 3, 12, 18.00, 7, 1),
(614, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 4, 12, 16.00, 7, 1),
(615, '16e779b0-531d-4ece-a3a5-069a97f13a5b', 5, 16, 12.00, 7, 1),
(616, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 0, 16, 7.00, 7, 1),
(617, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 1, 12, 12.00, 7, 1),
(618, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 2, 10, 12.00, 7, 1),
(619, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 3, 10, 14.00, 7, 1),
(620, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 4, 10, 12.00, 7, 1),
(621, '73cab9e1-6e83-4dab-bd3f-dc40f7bc058e', 5, 10, 12.00, 7, 1),
(622, 'fd01c7c1-db51-4033-ae6b-9049d5798897', 0, 10, 10.00, 7, 1),
(623, 'fd01c7c1-db51-4033-ae6b-9049d5798897', 1, 10, 12.00, 7, 1),
(624, 'fd01c7c1-db51-4033-ae6b-9049d5798897', 2, 6, 14.00, 7, 1),
(625, 'fd01c7c1-db51-4033-ae6b-9049d5798897', 3, 12, 12.00, 7, 1),
(653, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 0, 16, 16.00, 7, 1),
(654, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 1, 12, 20.00, 7, 1),
(655, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 2, 12, 26.00, 7, 1),
(656, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 3, 9, 36.00, 7, 1),
(657, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 4, 10, 32.00, 7, 1),
(658, '192a3a9a-2eb8-4f03-b92a-0812c2df2182', 5, 9, 32.00, 7, 1),
(659, '1698ef4d-de0c-4225-9120-fdbd6333abec', 0, 12, 12.00, 7, 1),
(660, '1698ef4d-de0c-4225-9120-fdbd6333abec', 1, 14, 14.00, 7, 1),
(661, '1698ef4d-de0c-4225-9120-fdbd6333abec', 2, 14, 16.00, 7, 1),
(662, '1698ef4d-de0c-4225-9120-fdbd6333abec', 3, 12, 18.00, 7, 1),
(663, '1698ef4d-de0c-4225-9120-fdbd6333abec', 4, 12, 18.00, 7, 1),
(664, '1698ef4d-de0c-4225-9120-fdbd6333abec', 5, 16, 12.00, 7, 1),
(665, 'e1f19416-fdee-405e-aff6-7ff69408e867', 0, 12, 52.00, 7, 1),
(666, 'e1f19416-fdee-405e-aff6-7ff69408e867', 1, 12, 73.00, 7, 1),
(667, 'e1f19416-fdee-405e-aff6-7ff69408e867', 2, 12, 100.00, 7, 1),
(668, 'e1f19416-fdee-405e-aff6-7ff69408e867', 3, 10, 120.00, 7, 1),
(669, 'e1f19416-fdee-405e-aff6-7ff69408e867', 4, 12, 100.00, 7, 1),
(929, 'd0c2cab0-8a8f-4b93-b606-6b715ce0834b', 0, 16, 40.00, 7, 1),
(930, 'd0c2cab0-8a8f-4b93-b606-6b715ce0834b', 1, 16, 40.00, 7, 1),
(931, 'd0c2cab0-8a8f-4b93-b606-6b715ce0834b', 2, 12, 80.00, 7, 1),
(932, 'd0c2cab0-8a8f-4b93-b606-6b715ce0834b', 3, 5, 100.00, 7, 1),
(933, '1f96f836-049d-46ce-a3ca-615ca65b45aa', 0, 10, 40.00, 7, 1),
(934, '1f96f836-049d-46ce-a3ca-615ca65b45aa', 1, 10, 80.00, 7, 1),
(935, '1f96f836-049d-46ce-a3ca-615ca65b45aa', 2, 10, 120.00, 7, 1),
(936, '1f96f836-049d-46ce-a3ca-615ca65b45aa', 3, 4, 140.00, 7, 1),
(937, '4efa5527-4f7c-43e7-8d05-217416c4258c', 0, 12, 14.00, 7, 1),
(938, '4efa5527-4f7c-43e7-8d05-217416c4258c', 1, 12, 23.00, 7, 1),
(939, '4efa5527-4f7c-43e7-8d05-217416c4258c', 2, 12, 32.00, 7, 1),
(940, '4efa5527-4f7c-43e7-8d05-217416c4258c', 3, 10, 41.00, 7, 1),
(967, 'xcwlkmxuv', 0, 26, 16.00, 7, 1),
(968, 'xcwlkmxuv', 1, 12, 24.00, 7, 1),
(969, 'xcwlkmxuv', 2, 12, 34.00, 7, 1),
(970, 'xcwlkmxuv', 3, 5, 40.00, 7, 1),
(971, 'xcwlkmxuv', 4, 4, 40.00, 7, 1),
(972, 'xcwlkmxuv', 5, 9, 36.00, 7, 1),
(973, '8f4nh3zrl', 0, 16, 12.00, 7, 1),
(974, '8f4nh3zrl', 1, 16, 16.00, 7, 1),
(975, '8f4nh3zrl', 2, 10, 20.00, 7, 1),
(976, '8f4nh3zrl', 3, 7, 22.00, 7, 1),
(977, '8f4nh3zrl', 4, 12, 18.00, 7, 1),
(978, '8f4nh3zrl', 5, 12, 18.00, 7, 1),
(979, '48zo0an6g', 0, 12, 15.00, 7, 1),
(980, '48zo0an6g', 1, 12, 25.00, 7, 1),
(981, '48zo0an6g', 2, 10, 35.00, 7, 1),
(982, '48zo0an6g', 3, 10, 35.00, 7, 1),
(983, '48zo0an6g', 4, 5, 45.00, 7, 1),
(984, '48zo0an6g', 5, 12, 30.00, 7, 1),
(985, '58unf9yfu', 0, 12, 30.00, 7, 1),
(986, '58unf9yfu', 1, 10, 30.00, 7, 1),
(987, '58unf9yfu', 2, 10, 30.00, 7, 1),
(988, '58unf9yfu', 3, 10, 30.00, 7, 1),
(989, 'idf6ppw89', 0, 16, 20.00, 7, 1),
(990, 'idf6ppw89', 1, 14, 40.00, 7, 1),
(991, 'idf6ppw89', 2, 10, 60.00, 7, 1),
(992, 'idf6ppw89', 3, 10, 50.00, 7, 1),
(1154, 'ew1dor0yv', 0, 12, 39.00, NULL, 1),
(1155, 'ew1dor0yv', 1, 12, 52.00, NULL, 1),
(1156, 'ew1dor0yv', 2, 12, 66.00, NULL, 1),
(1157, 'ew1dor0yv', 3, 10, 86.00, NULL, 0),
(1158, 'ew1dor0yv', 4, 4, 93.00, NULL, 0),
(1159, 'q940pd8jd', 0, 12, 52.00, NULL, 0),
(1160, 'q940pd8jd', 1, 12, 73.00, NULL, 0),
(1161, 'q940pd8jd', 2, 10, 93.00, NULL, 0),
(1162, 'q940pd8jd', 3, 10, 107.00, NULL, 0),
(1163, 'q940pd8jd', 4, 12, 86.00, NULL, 0),
(1164, 'abv3fi10r', 0, 12, 45.00, NULL, 0),
(1165, 'abv3fi10r', 1, 12, 73.00, NULL, 0),
(1166, 'abv3fi10r', 2, 12, 107.00, NULL, 0),
(1167, 'abv3fi10r', 3, 12, 134.00, NULL, 0),
(1168, 'o9a328pk1', 0, 15, 0.00, NULL, 1),
(1169, 'o9a328pk1', 1, 15, 0.00, NULL, 1),
(1170, 'o9a328pk1', 2, 15, 0.00, NULL, 1),
(1171, 'o9a328pk1', 3, 15, 0.00, NULL, 1),
(1172, 'o9a328pk1', 4, 15, 0.00, NULL, 1),
(1173, 'o9a328pk1', 5, 15, 0.00, NULL, 1),
(1174, '0vn0wgz8j', 0, 20, 0.00, NULL, 1),
(1175, '0vn0wgz8j', 1, 20, 0.00, NULL, 1),
(1176, '0vn0wgz8j', 2, 20, 0.00, NULL, 1),
(1177, '0vn0wgz8j', 3, 20, 0.00, NULL, 1),
(1178, 'yho48vp53', 0, 30, 0.00, NULL, 1),
(1179, 'yho48vp53', 1, 45, 0.00, NULL, 1),
(1180, 'yho48vp53', 2, 45, 0.00, NULL, 1),
(1181, 'yho48vp53', 3, 45, 0.00, NULL, 1),
(1261, 'h46ulva40', 0, 20, 20.00, 7, 1),
(1262, 'h46ulva40', 1, 12, 60.00, 7, 1),
(1263, 'h46ulva40', 2, 12, 80.00, 7, 1),
(1264, 'h46ulva40', 3, 6, 100.00, 7, 1),
(1265, 'h46ulva40', 4, 6, 100.00, 7, 1),
(1266, 'h46ulva40', 5, 5, 100.00, 7, 1),
(1267, '1el6l7yij', 0, 12, 12.00, 7, 1),
(1268, '1el6l7yij', 1, 12, 16.00, 7, 1),
(1269, '1el6l7yij', 2, 10, 20.00, 7, 1),
(1270, '1el6l7yij', 3, 6, 26.00, 7, 1),
(1271, '2k604nogv', 0, 16, 40.00, NULL, 1),
(1272, '2k604nogv', 1, 12, 80.00, NULL, 1),
(1273, '2k604nogv', 2, 5, 100.00, NULL, 1),
(1274, 'fzeado5ay', 0, 12, 14.00, NULL, 1),
(1275, 'fzeado5ay', 1, 12, 27.00, NULL, 1),
(1276, 'fzeado5ay', 2, 10, 36.00, NULL, 1),
(1277, 'fzeado5ay', 3, 10, 23.00, NULL, 1),
(1614, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 0, 10, 16.00, 7, 1),
(1615, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 1, 10, 20.00, 7, 1),
(1616, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 2, 10, 24.00, 7, 1),
(1617, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 3, 10, 26.00, 7, 1),
(1618, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 4, 8, 28.00, 7, 1),
(1619, 'f9178f4e-21f1-4f83-9127-b968b8b0f1a9', 5, 2, 30.00, 7, 1),
(1620, '11d6d163-a145-4a90-a522-1ef1dd8f1652', 0, 10, 20.00, 7, 1),
(1621, '11d6d163-a145-4a90-a522-1ef1dd8f1652', 1, 10, 40.00, 7, 1),
(1622, '11d6d163-a145-4a90-a522-1ef1dd8f1652', 2, 7, 50.00, 7, 1),
(1623, '11d6d163-a145-4a90-a522-1ef1dd8f1652', 3, 10, 40.00, 7, 1),
(1624, '11d6d163-a145-4a90-a522-1ef1dd8f1652', 4, 10, 30.00, 7, 1),
(1625, '5d56e55a-cb4c-451d-980a-387268974e59', 0, 10, 20.00, 7, 1),
(1626, '5d56e55a-cb4c-451d-980a-387268974e59', 1, 10, 27.50, 7, 1),
(1627, '5d56e55a-cb4c-451d-980a-387268974e59', 2, 10, 35.00, 7, 1),
(1628, '5d56e55a-cb4c-451d-980a-387268974e59', 3, 10, 40.00, 7, 1),
(1629, '5d56e55a-cb4c-451d-980a-387268974e59', 4, 3, 50.00, 7, 1),
(1630, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 0, 10, 8.00, 7, 1),
(1631, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 1, 12, 14.00, 7, 1),
(1632, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 2, 10, 16.00, 7, 1),
(1633, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 3, 10, 16.00, 7, 1),
(1634, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 4, 10, 14.00, 7, 1),
(1635, 'b50a86e1-284a-4eb7-a15d-6390632a874a', 5, 10, 12.00, 7, 1),
(1636, '8ddf6f40-1a44-4319-b352-8e0441ce40b0', 0, 10, 50.00, 7, 1),
(1637, '8ddf6f40-1a44-4319-b352-8e0441ce40b0', 1, 10, 60.00, 7, 1),
(1638, '8ddf6f40-1a44-4319-b352-8e0441ce40b0', 2, 6, 70.00, 7, 1),
(1639, '8ddf6f40-1a44-4319-b352-8e0441ce40b0', 3, 9, 70.00, 7, 1),
(1640, '286920b4-4221-46f1-9774-aa0ed21592e2', 0, 12, 25.00, 7, 1),
(1641, '286920b4-4221-46f1-9774-aa0ed21592e2', 1, 10, 39.00, 7, 1),
(1642, '286920b4-4221-46f1-9774-aa0ed21592e2', 2, 10, 52.00, 7, 1),
(1643, '286920b4-4221-46f1-9774-aa0ed21592e2', 3, 9, 66.00, 7, 1),
(1644, '286920b4-4221-46f1-9774-aa0ed21592e2', 4, 12, 52.00, 7, 1),
(1645, '286920b4-4221-46f1-9774-aa0ed21592e2', 5, 18, 39.00, 7, 1),
(1646, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 0, 20, 25.00, 7, 1),
(1647, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 1, 16, 45.00, 7, 1),
(1648, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 2, 10, 73.00, 7, 1),
(1649, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 3, 10, 86.00, 7, 1),
(1650, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 4, 10, 100.00, 7, 1),
(1651, '4fec674c-126a-4fc9-8bab-9f9c4e9a59f7', 5, 10, 63.00, 7, 1),
(1652, '08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', 0, 16, 45.00, 7, 1),
(1653, '08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', 1, 12, 73.00, 7, 1),
(1654, '08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', 2, 12, 100.00, 7, 1),
(1655, '08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', 3, 10, 116.00, 7, 1),
(1656, '08680dc9-fbf9-4ab9-b2be-8b8f1eccc6db', 4, 10, 113.00, 7, 1),
(1657, 'deea1fcb-6ac8-40fa-bc36-379f3e47ca08', 0, 12, 25.00, 7, 1),
(1658, 'deea1fcb-6ac8-40fa-bc36-379f3e47ca08', 1, 12, 45.00, 7, 1),
(1659, 'deea1fcb-6ac8-40fa-bc36-379f3e47ca08', 2, 10, 68.00, 7, 1),
(1660, 'deea1fcb-6ac8-40fa-bc36-379f3e47ca08', 3, 10, 54.00, 7, 1),
(1661, 'deea1fcb-6ac8-40fa-bc36-379f3e47ca08', 4, 10, 50.00, 7, 1),
(1662, 'fdd3f675-6d4d-44b3-8fcd-bfd928a7b3fa', 0, 10, 195.00, 7, 1),
(1663, 'fdd3f675-6d4d-44b3-8fcd-bfd928a7b3fa', 1, 5, 275.00, 7, 1),
(1664, 'fdd3f675-6d4d-44b3-8fcd-bfd928a7b3fa', 2, 2, 355.00, 7, 1),
(1665, 'unuwklgfk', 0, 16, 16.00, NULL, 1),
(1666, 'unuwklgfk', 1, 12, 24.00, NULL, 1),
(1667, 'unuwklgfk', 2, 12, 36.00, NULL, 1),
(1668, 'unuwklgfk', 3, 4, 40.00, NULL, 1),
(1669, 'xuv9fwwfj', 0, 16, 12.00, NULL, 1),
(1670, 'xuv9fwwfj', 1, 16, 16.00, NULL, 1),
(1671, 'xuv9fwwfj', 2, 11, 20.00, NULL, 1),
(1672, 'xuv9fwwfj', 3, 10, 20.00, NULL, 1),
(1673, 'xuv9fwwfj', 4, 12, 18.00, NULL, 1),
(1674, 'xuv9fwwfj', 5, 12, 18.00, NULL, 1),
(1675, '0r3pj848h', 0, 12, 52.00, NULL, 1),
(1676, '0r3pj848h', 1, 12, 79.00, NULL, 1),
(1677, '0r3pj848h', 2, 12, 107.00, NULL, 1),
(1678, '0r3pj848h', 3, 10, 134.00, NULL, 1),
(1679, '0r3pj848h', 4, 12, 100.00, NULL, 1),
(1680, 'eqju4dl8d', 0, 12, 11.00, NULL, 1),
(1681, 'eqju4dl8d', 1, 12, 18.00, NULL, 1),
(1682, 'eqju4dl8d', 2, 10, 20.30, NULL, 1),
(1683, 'eqju4dl8d', 3, 10, 25.00, NULL, 1),
(1820, 'zk8dvxbyu', 0, 14, 16.00, NULL, 1),
(1821, 'zk8dvxbyu', 1, 12, 20.00, NULL, 1),
(1822, 'zk8dvxbyu', 2, 10, 26.00, NULL, 1),
(1823, 'zk8dvxbyu', 3, 6, 28.00, NULL, 1),
(1824, 'zk8dvxbyu', 4, 10, 26.00, NULL, 1),
(1825, 'zk8dvxbyu', 5, 9, 26.00, NULL, 1),
(1826, 'uky6zqyhr', 0, 12, 12.00, NULL, 1),
(1827, 'uky6zqyhr', 1, 12, 16.00, NULL, 1),
(1828, 'uky6zqyhr', 2, 10, 18.00, NULL, 1),
(1829, 'uky6zqyhr', 3, 10, 18.00, NULL, 1),
(1830, 'uky6zqyhr', 4, 10, 18.00, NULL, 1),
(1831, 'uky6zqyhr', 5, 10, 16.00, NULL, 1),
(1832, 'hz3lsr2gf', 0, 16, 9.00, NULL, 1),
(1833, 'hz3lsr2gf', 1, 14, 14.00, NULL, 1),
(1834, 'hz3lsr2gf', 2, 12, 16.00, NULL, 1),
(1835, 'hz3lsr2gf', 3, 9, 16.00, NULL, 1),
(1836, 'hz3lsr2gf', 4, 10, 14.00, NULL, 1),
(1837, 'hz3lsr2gf', 5, 10, 9.00, NULL, 1),
(1838, 'ay2v1m8r4', 0, 10, 91.00, NULL, 1),
(1839, 'ay2v1m8r4', 1, 10, 91.00, NULL, 1),
(1840, 'iy9vhntiu', 0, 12, 16.00, NULL, 1),
(1841, 'iy9vhntiu', 1, 12, 20.00, NULL, 1),
(1842, 'iy9vhntiu', 2, 6, 24.00, NULL, 1),
(1843, 'iy9vhntiu', 3, 10, 20.00, NULL, 1),
(1844, '0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 0, 14, 16.00, 7, 1),
(1845, '0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 1, 10, 16.00, 7, 1),
(1846, '0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 2, 10, 24.00, 7, 1),
(1847, '0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 3, 4, 28.00, 7, 1),
(1848, '0c34182f-0c9a-4ce8-b6d1-f6e4fc948dc2', 4, 3, 30.00, 7, 1),
(1849, '149c8eaf-bf30-4e60-acec-40cf63206d75', 0, 10, 8.00, 7, 1),
(1850, '149c8eaf-bf30-4e60-acec-40cf63206d75', 1, 12, 12.00, 7, 1),
(1851, '149c8eaf-bf30-4e60-acec-40cf63206d75', 2, 12, 16.00, 7, 1),
(1852, '149c8eaf-bf30-4e60-acec-40cf63206d75', 3, 10, 16.00, 7, 1),
(1853, '149c8eaf-bf30-4e60-acec-40cf63206d75', 4, 10, 16.00, 7, 1),
(1854, '55d6bf51-78cf-4510-b245-78db10627a4f', 0, 12, 12.00, 7, 1),
(1855, '55d6bf51-78cf-4510-b245-78db10627a4f', 1, 14, 14.00, 7, 1),
(1856, '55d6bf51-78cf-4510-b245-78db10627a4f', 2, 12, 16.00, 7, 1),
(1857, '55d6bf51-78cf-4510-b245-78db10627a4f', 3, 12, 16.00, 7, 1),
(1858, '55d6bf51-78cf-4510-b245-78db10627a4f', 4, 10, 16.00, 7, 1),
(1859, '64ac2c92-d26a-4b4d-b4e1-0799d944ce9b', 0, 16, 9.00, 7, 1),
(1860, '64ac2c92-d26a-4b4d-b4e1-0799d944ce9b', 1, 12, 14.00, 7, 1),
(1861, '64ac2c92-d26a-4b4d-b4e1-0799d944ce9b', 2, 6, 18.00, 7, 1),
(1862, '64ac2c92-d26a-4b4d-b4e1-0799d944ce9b', 3, 11, 14.00, 7, 1),
(1863, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 0, 20, 8.00, 7, 1),
(1864, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 1, 16, 12.00, 7, 1),
(1865, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 2, 16, 16.00, 7, 1),
(1866, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 3, 16, 18.00, 7, 1),
(1867, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 4, 10, 20.00, 7, 1),
(1868, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 5, 10, 20.00, 7, 1),
(1869, 'b898d5af-02b2-4e2f-9d53-7b36ab66f53b', 6, 12, 16.00, 7, 1),
(1870, '0565e46d-de2f-49c6-a51f-2f7bf50dc692', 0, 12, 12.00, 7, 1),
(1871, '0565e46d-de2f-49c6-a51f-2f7bf50dc692', 1, 12, 14.00, 7, 1),
(1872, '0565e46d-de2f-49c6-a51f-2f7bf50dc692', 2, 12, 16.00, 7, 1),
(1873, '0565e46d-de2f-49c6-a51f-2f7bf50dc692', 3, 12, 18.00, 7, 1),
(1874, '5021dd09-988f-480d-810f-de26d8420a08', 0, 10, 39.00, 7, 1),
(1875, '5021dd09-988f-480d-810f-de26d8420a08', 1, 10, 66.00, 7, 1),
(1876, '5021dd09-988f-480d-810f-de26d8420a08', 2, 10, 93.00, 7, 1),
(1877, '1c338f7d-82c6-4f6c-bb15-c13083e227f2', 0, 10, 18.00, 7, 1),
(1878, '1c338f7d-82c6-4f6c-bb15-c13083e227f2', 1, 10, 18.00, 7, 1),
(1879, '1c338f7d-82c6-4f6c-bb15-c13083e227f2', 2, 10, 32.00, 7, 1),
(1880, '1c338f7d-82c6-4f6c-bb15-c13083e227f2', 3, 6, 41.00, 7, 1),
(1881, '1c338f7d-82c6-4f6c-bb15-c13083e227f2', 4, 12, 32.00, 7, 1),
(1882, '493bc620-af1e-4fa8-96be-157c2029a111', 0, 16, 27.00, 7, 1),
(1883, '493bc620-af1e-4fa8-96be-157c2029a111', 1, 12, 50.00, 7, 1),
(1884, '493bc620-af1e-4fa8-96be-157c2029a111', 2, 12, 68.00, 7, 1),
(1885, '493bc620-af1e-4fa8-96be-157c2029a111', 3, 10, 73.00, 7, 1),
(1886, '30ac99a3-d504-4f10-aedf-060125735086', 0, 12, 12.00, 7, 1),
(1887, '30ac99a3-d504-4f10-aedf-060125735086', 1, 12, 14.00, 7, 1),
(1888, '30ac99a3-d504-4f10-aedf-060125735086', 2, 12, 16.00, 7, 1),
(1889, '30ac99a3-d504-4f10-aedf-060125735086', 3, 10, 16.00, 7, 1),
(1890, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 0, 10, 16.00, 7, 1),
(1891, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 1, 10, 16.00, 7, 1),
(1892, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 2, 10, 20.00, 7, 1),
(1893, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 3, 6, 24.00, 7, 1),
(1894, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 4, 8, 24.00, 7, 1),
(1895, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 5, 6, 26.00, 7, 1),
(1896, '1b3f2edd-6295-4d53-9817-61d71e1d7480', 6, 7, 26.00, 7, 1),
(1897, '0e1985ff-549a-4386-9c0b-c74baea4ec8b', 0, 12, 12.00, 7, 1),
(1898, '0e1985ff-549a-4386-9c0b-c74baea4ec8b', 1, 12, 12.00, 7, 1),
(1899, '0e1985ff-549a-4386-9c0b-c74baea4ec8b', 2, 12, 14.00, 7, 1),
(1900, '0e1985ff-549a-4386-9c0b-c74baea4ec8b', 3, 12, 16.00, 7, 1),
(1901, '0e1985ff-549a-4386-9c0b-c74baea4ec8b', 4, 12, 16.00, 7, 1),
(1902, '02defe6c-1b3d-4bb3-b715-82c6c7854b28', 0, 20, 36.00, 7, 1),
(1903, '02defe6c-1b3d-4bb3-b715-82c6c7854b28', 1, 12, 64.00, 7, 1),
(1904, '02defe6c-1b3d-4bb3-b715-82c6c7854b28', 2, 10, 91.00, 7, 1),
(1905, '02defe6c-1b3d-4bb3-b715-82c6c7854b28', 3, 10, 91.00, 7, 1),
(1906, '02defe6c-1b3d-4bb3-b715-82c6c7854b28', 4, 10, 96.00, 7, 1),
(1907, 'da15bfd9-6554-4cd6-b6d0-58fef9197055', 0, 12, 16.00, 7, 1),
(1908, 'da15bfd9-6554-4cd6-b6d0-58fef9197055', 1, 10, 18.00, 7, 1),
(1909, 'da15bfd9-6554-4cd6-b6d0-58fef9197055', 2, 4, 24.00, 7, 1),
(1910, 'da15bfd9-6554-4cd6-b6d0-58fef9197055', 3, 10, 20.00, 7, 1),
(1911, 'a5fb66af-e933-4616-b2c3-be5780b63e92', 0, 14, 9.00, 7, 1),
(1912, 'a5fb66af-e933-4616-b2c3-be5780b63e92', 1, 12, 14.00, 7, 1),
(1913, 'a5fb66af-e933-4616-b2c3-be5780b63e92', 2, 10, 14.00, 7, 1),
(1914, '55d1gowbk', 0, 12, 16.00, NULL, 1),
(1915, '55d1gowbk', 1, 12, 20.00, NULL, 1),
(1916, '55d1gowbk', 2, 12, 24.00, NULL, 1),
(1917, '55d1gowbk', 3, 7, 28.00, NULL, 1),
(1918, '55d1gowbk', 4, 10, 24.00, NULL, 1),
(1919, '55d1gowbk', 5, 10, 20.00, NULL, 1),
(1920, 'ahjvxnnk9', 0, 16, 12.00, NULL, 1),
(1921, 'ahjvxnnk9', 1, 12, 16.00, NULL, 1),
(1922, 'ahjvxnnk9', 2, 12, 18.00, NULL, 1),
(1923, 'ahjvxnnk9', 3, 12, 18.00, NULL, 1),
(1924, 'ahjvxnnk9', 4, 10, 18.00, NULL, 1),
(1925, 'ahjvxnnk9', 5, 10, 16.00, NULL, 1),
(1926, 'ftg3pw6n5', 0, 16, 9.00, NULL, 1),
(1927, 'ftg3pw6n5', 1, 14, 14.00, NULL, 1),
(1928, 'ftg3pw6n5', 2, 12, 16.00, NULL, 1),
(1929, 'b2rfj873r', 0, 12, 16.00, NULL, 1),
(1930, 'b2rfj873r', 1, 12, 20.00, NULL, 1),
(1931, 'b2rfj873r', 2, 6, 24.00, NULL, 1),
(1932, 'b2rfj873r', 3, 10, 20.00, NULL, 1),
(1933, 'vikywmtqp', 0, 12, 12.00, NULL, 1),
(1934, 'vikywmtqp', 1, 12, 16.00, NULL, 1),
(1935, 'vikywmtqp', 2, 8, 20.00, NULL, 1),
(1936, 'vikywmtqp', 3, 10, 16.00, NULL, 1),
(1937, 'oed2mn8mi', 0, 16, 52.00, NULL, 1),
(1938, 'oed2mn8mi', 1, 12, 79.00, NULL, 1),
(1939, 'oed2mn8mi', 2, 8, 93.00, NULL, 1),
(1940, 'oed2mn8mi', 3, 10, 86.00, NULL, 1),
(1941, 'oed2mn8mi', 4, 12, 73.00, NULL, 1),
(1942, 'oed2mn8mi', 5, 12, 73.00, NULL, 1),
(1943, 'rtzrohnha', 0, 12, 52.00, NULL, 1),
(1944, 'rtzrohnha', 1, 12, 79.00, NULL, 1),
(1945, 'rtzrohnha', 2, 12, 107.00, NULL, 1),
(1946, 'rtzrohnha', 3, 12, 86.00, NULL, 1),
(1947, 'rtzrohnha', 4, 12, 86.00, NULL, 1),
(1948, 'l6w1bkiox', 0, 10, 27.00, NULL, 1),
(1949, 'l6w1bkiox', 1, 10, 45.00, NULL, 1),
(1950, 'l6w1bkiox', 2, 10, 64.00, NULL, 1),
(1951, 'l6w1bkiox', 3, 10, 50.00, NULL, 1),
(1952, 'hkbxk9uo1', 0, 12, 45.00, NULL, 1),
(1953, 'hkbxk9uo1', 1, 12, 86.00, NULL, 1),
(1954, 'hkbxk9uo1', 2, 12, 113.00, NULL, 1),
(1955, 'hkbxk9uo1', 3, 12, 134.00, NULL, 1),
(2081, 'jisfmy9fv', 0, 16, 18.00, NULL, 0),
(2082, 'jisfmy9fv', 1, 12, 27.00, NULL, 0),
(2083, 'jisfmy9fv', 2, 12, 41.00, NULL, 0),
(2084, 'jisfmy9fv', 3, 12, 54.00, NULL, 0),
(2085, 'blfyen5qa', 0, 16, 39.00, NULL, 0),
(2086, 'blfyen5qa', 1, 12, 52.00, NULL, 0),
(2087, 'blfyen5qa', 2, 12, 79.00, NULL, 0),
(2088, 'blfyen5qa', 3, 12, 79.00, NULL, 0),
(2089, 'blfyen5qa', 4, 12, 107.00, NULL, 0),
(2090, '5jo4b4i46', 0, 12, 39.00, NULL, 1),
(2091, '5jo4b4i46', 1, 12, 52.00, NULL, 1),
(2092, '5jo4b4i46', 2, 12, 73.00, NULL, 1),
(2093, '5jo4b4i46', 3, 12, 93.00, NULL, 1),
(2094, '5jo4b4i46', 4, 10, 107.00, NULL, 1),
(2095, '5jo4b4i46', 5, 10, 93.00, NULL, 1),
(2096, 'b6mo66uif', 0, 12, 12.00, NULL, 1),
(2097, 'b6mo66uif', 1, 12, 16.00, NULL, 1),
(2098, 'b6mo66uif', 2, 10, 20.00, NULL, 1),
(2099, 'b6mo66uif', 3, 10, 26.00, NULL, 1),
(2100, 'vjmb3jptu', 0, 12, 14.00, NULL, 1),
(2101, 'vjmb3jptu', 1, 12, 23.00, NULL, 1),
(2102, 'vjmb3jptu', 2, 12, 32.00, NULL, 1),
(2103, 'vjmb3jptu', 3, 12, 27.00, NULL, 1),
(2104, 'lyvuulhbv', 0, 12, 100.00, NULL, 1),
(2105, 'lyvuulhbv', 1, 10, 134.00, NULL, 1),
(2106, 'lyvuulhbv', 2, 10, 134.00, NULL, 1),
(2107, 'lyvuulhbv', 3, 10, 134.00, NULL, 1),
(2224, 'sbg329fzm', 0, 16, 52.00, 7, 1),
(2225, 'sbg329fzm', 1, 12, 79.00, 7, 1),
(2226, 'sbg329fzm', 2, 12, 66.00, 7, 1),
(2227, 'sbg329fzm', 3, 8, 93.00, 7, 1),
(2228, 'sbg329fzm', 4, 4, 107.00, 7, 1),
(2229, 'rsoqtw6z9', 0, 12, 26.00, 7, 1),
(2230, 'rsoqtw6z9', 1, 3, 36.00, 7, 1),
(2231, 'rsoqtw6z9', 2, 10, 50.00, 7, 1),
(2232, 'rsoqtw6z9', 3, 10, 50.00, 7, 1),
(2233, 'rsoqtw6z9', 4, 10, 50.00, 7, 1),
(2234, 'z1ul528zw', 0, 12, 45.00, NULL, 1),
(2235, 'z1ul528zw', 1, 12, 86.00, NULL, 1),
(2236, 'z1ul528zw', 2, 12, 113.00, NULL, 1),
(2237, 'z1ul528zw', 3, 12, 134.00, NULL, 0),
(2302, 'qyi3jnmnz', 0, 12, 16.00, 7, 1),
(2303, 'qyi3jnmnz', 1, 12, 20.00, 7, 1),
(2304, 'qyi3jnmnz', 2, 12, 26.00, 7, 1),
(2305, 'qyi3jnmnz', 3, 7, 28.00, 7, 1),
(2306, 'qyi3jnmnz', 4, 10, 24.00, 7, 1),
(2307, 'qyi3jnmnz', 5, 10, 20.00, 7, 1),
(2308, 'hzkvjec67', 0, 16, 12.00, 7, 1),
(2309, 'hzkvjec67', 1, 12, 16.00, 7, 1),
(2310, 'hzkvjec67', 2, 12, 18.00, 7, 1),
(2311, 'hzkvjec67', 3, 12, 18.00, 7, 1),
(2312, 'hzkvjec67', 4, 12, 18.00, 7, 1),
(2313, 'hzkvjec67', 5, 12, 16.00, 7, 1),
(2314, 'nxsh3e960', 0, 12, 23.00, NULL, 1),
(2315, 'nxsh3e960', 1, 12, 32.00, NULL, 1),
(2316, 'nxsh3e960', 2, 10, 41.00, NULL, 1),
(2332, 'kg1foccwh', 0, 16, 18.00, NULL, 1),
(2333, 'kg1foccwh', 1, 12, 32.00, NULL, 1),
(2334, 'kg1foccwh', 2, 12, 45.00, NULL, 1),
(2335, 'kg1foccwh', 3, 12, 54.00, NULL, 1),
(2336, 'kg1foccwh', 4, 5, 64.00, NULL, 1),
(2337, '910wjv305', 0, 16, 12.00, NULL, 1),
(2338, '910wjv305', 1, 16, 16.00, NULL, 1),
(2339, '910wjv305', 2, 12, 20.00, NULL, 1),
(2340, '910wjv305', 3, 8, 22.00, NULL, 1),
(2341, '910wjv305', 4, 10, 20.00, NULL, 1),
(2342, '910wjv305', 5, 16, 16.00, NULL, 0),
(2343, '84bfj2teh', 0, 16, 12.00, NULL, 1),
(2344, '84bfj2teh', 1, 10, 16.00, NULL, 1),
(2345, '84bfj2teh', 2, 12, 16.00, NULL, 1),
(2346, '84bfj2teh', 3, 10, 18.00, NULL, 1),
(2347, '84bfj2teh', 4, 6, 20.00, NULL, 1),
(2348, '84bfj2teh', 5, 10, 16.00, NULL, 0),
(2349, '86e92ct3u', 0, 16, 11.00, NULL, 0),
(2350, '86e92ct3u', 1, 12, 18.00, NULL, 0),
(2351, '86e92ct3u', 2, 12, 25.00, NULL, 0),
(2352, '86e92ct3u', 3, 10, 25.00, NULL, 0),
(2353, 'wb0kim2mc', 0, 16, 20.00, NULL, 0),
(2354, 'wb0kim2mc', 1, 16, 60.00, NULL, 0),
(2355, 'wb0kim2mc', 2, 14, 90.00, NULL, 0),
(2356, 'wb0kim2mc', 3, 7, 100.00, NULL, 0),
(2357, 'wb0kim2mc', 4, 7, 100.00, NULL, 0),
(2358, 'wb0kim2mc', 5, 10, 80.00, NULL, 0),
(2359, 'p0zjqsn7s', 0, 12, 12.00, NULL, 0),
(2360, 'p0zjqsn7s', 1, 12, 16.00, NULL, 0),
(2361, 'p0zjqsn7s', 2, 10, 20.00, NULL, 0),
(2362, 'p0zjqsn7s', 3, 5, 26.00, NULL, 0),
(2363, 'p0zjqsn7s', 4, 3, 30.00, NULL, 0),
(2364, 'p0zjqsn7s', 5, 12, 20.00, NULL, 0),
(2365, 'zqa536bm2', 0, 12, 39.00, NULL, 0),
(2366, 'zqa536bm2', 1, 12, 59.00, NULL, 0),
(2367, 'zqa536bm2', 2, 10, 73.00, NULL, 0),
(2368, 'zqa536bm2', 3, 12, 73.00, NULL, 0),
(2369, 'p0mdlpsre', 0, 12, 18.00, NULL, 1),
(2370, 'p0mdlpsre', 1, 12, 32.00, NULL, 1),
(2371, 'p0mdlpsre', 2, 12, 45.00, NULL, 1),
(2372, 'p0mdlpsre', 3, 10, 59.00, NULL, 1),
(2373, 'tndhospv8', 0, 16, 12.00, NULL, 1),
(2374, 'tndhospv8', 1, 12, 16.00, NULL, 1),
(2375, 'tndhospv8', 2, 14, 16.00, NULL, 1),
(2376, 'tndhospv8', 3, 16, 16.00, NULL, 1),
(2377, 'tndhospv8', 4, 12, 18.00, NULL, 1),
(2378, '696pbkkk7', 0, 12, 52.00, NULL, 1),
(2379, '696pbkkk7', 1, 12, 79.00, NULL, 1),
(2380, '696pbkkk7', 2, 3, 107.00, NULL, 1),
(2381, '696pbkkk7', 3, 4, 120.00, NULL, 1),
(2382, '3igu28npq', 0, 18, 12.00, NULL, 1),
(2383, '3igu28npq', 1, 12, 16.00, NULL, 1),
(2384, '3igu28npq', 2, 12, 16.00, NULL, 1),
(2385, '3igu28npq', 3, 10, 16.00, NULL, 1);

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

--
-- Structure de la table `workout_log_exercise_set_drops`
--

DROP TABLE IF EXISTS `workout_log_exercise_set_drops`;
CREATE TABLE IF NOT EXISTS `workout_log_exercise_set_drops` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workout_log_set_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  `reps` int(11) NOT NULL,
  `weight` decimal(8,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_set` (`workout_log_set_id`)
) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_log_exercise_set_drops` (`id`, `workout_log_set_id`, `position`, `reps`, `weight`) VALUES
(3, 22, 0, 10, 59.00),
(4, 26, 0, 10, 20.00),
(5, 43, 0, 10, 16.00),
(6, 44, 0, 10, 16.00),
(7, 48, 0, 10, 16.00),
(13, 135, 0, 8, 73.00),
(14, 135, 1, 10, 45.00),
(15, 147, 0, 10, 73.00),
(16, 147, 1, 10, 59.00),
(17, 168, 0, 6, 50.00),
(18, 168, 1, 3, 36.00),
(19, 169, 0, 8, 36.00),
(26, 220, 0, 9, 80.00),
(27, 220, 1, 10, 60.00),
(28, 230, 0, 10, 100.00),
(29, 239, 0, 9, 73.00),
(30, 239, 1, 10, 45.00),
(31, 255, 0, 10, 12.00),
(33, 286, 0, 8, 73.00),
(34, 286, 1, 8, 45.00),
(35, 291, 0, 8, 73.00),
(36, 291, 1, 10, 59.00),
(37, 295, 0, 4, 46.00),
(41, 381, 0, 10, 73.00),
(42, 381, 1, 10, 45.00),
(53, 434, 0, 10, 80.00),
(54, 434, 1, 10, 60.00),
(55, 438, 0, 10, 27.00),
(79, 613, 0, 12, 12.00),
(80, 624, 0, 6, 12.00),
(82, 662, 0, 12, 12.00),
(130, 932, 0, 6, 80.00),
(131, 932, 1, 12, 40.00),
(132, 936, 0, 4, 120.00),
(133, 936, 1, 10, 80.00),
(139, 972, 0, 12, 22.00),
(140, 976, 0, 10, 16.00),
(141, 978, 0, 10, 14.00),
(142, 978, 1, 10, 12.00),
(143, 983, 0, 10, 30.00),
(180, 1266, 0, 9, 80.00),
(181, 1266, 1, 10, 60.00),
(182, 1270, 0, 10, 20.00),
(183, 1273, 0, 6, 80.00),
(184, 1273, 1, 12, 40.00),
(185, 1276, 0, 10, 23.00),
(248, 1629, 0, 5, 35.00),
(249, 1672, 0, 10, 16.00),
(250, 1673, 0, 10, 14.00),
(251, 1673, 1, 10, 12.00),
(252, 1674, 0, 10, 14.00),
(253, 1674, 1, 10, 12.00),
(268, 1825, 0, 10, 18.00),
(269, 1842, 0, 10, 16.00),
(270, 1843, 0, 10, 16.00),
(271, 1847, 0, 3, 28.00),
(272, 1847, 1, 2, 28.00),
(273, 1848, 0, 10, 20.00),
(274, 1858, 0, 10, 12.00),
(275, 1861, 0, 10, 9.00),
(276, 1880, 0, 10, 27.00),
(277, 1909, 0, 12, 16.00),
(278, 1931, 0, 10, 16.00),
(279, 1932, 0, 12, 16.00),
(280, 1938, 0, 12, 52.00),
(281, 1939, 0, 8, 73.00),
(282, 1942, 0, 12, 52.00),
(283, 1947, 0, 10, 73.00),
(292, 2099, 0, 12, 20.00),
(317, 2228, 0, 5, 93.00),
(318, 2228, 1, 10, 73.00),
(319, 2230, 0, 3, 40.00),
(320, 2230, 1, 3, 44.00),
(323, 2336, 0, 5, 50.00),
(324, 2336, 1, 6, 36.00),
(325, 2358, 0, 10, 60.00);

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

--
-- Structure de la table `workout_tags`
--

DROP TABLE IF EXISTS `workout_tags`;
CREATE TABLE IF NOT EXISTS `workout_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workout_id` varchar(36) NOT NULL,
  `tag` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_workout` (`workout_id`),
  KEY `idx_tag` (`tag`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `workout_tags` (`id`, `workout_id`, `tag`) VALUES
(4, '7d3ff9b9-29b2-4b6f-bd24-dca35ccfb41e', 'Split'),
(5, 'd0f4341a-e248-44c6-95d8-5c030eb787e4', 'Split'),
(9, '3461d87f-651d-42d1-ba5c-c3a4381fd3fb', 'Split');

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

--
-- Contraintes pour la table `communications`
--
ALTER TABLE `communications`
  ADD CONSTRAINT `fk_communications_user` FOREIGN KEY (`sent_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `communication_drafts`
--
ALTER TABLE `communication_drafts`
  ADD CONSTRAINT `fk_comm_draft_user` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `communication_recipients`
--
ALTER TABLE `communication_recipients`
  ADD CONSTRAINT `fk_cr_communication` FOREIGN KEY (`communication_id`) REFERENCES `communications` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_cr_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Contraintes pour la table `contact_tickets`
--
ALTER TABLE `contact_tickets`
  ADD CONSTRAINT `contact_tickets_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `draft_logs`
--
ALTER TABLE `draft_logs`
  ADD CONSTRAINT `draft_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `email_change_tokens`
--
ALTER TABLE `email_change_tokens`
  ADD CONSTRAINT `fk_email_change_tokens_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `email_templates`
--
ALTER TABLE `email_templates`
  ADD CONSTRAINT `fk_email_templates_user` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Contraintes pour la table `exercises`
--
ALTER TABLE `exercises`
  ADD CONSTRAINT `exercises_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `exercise_impacted_muscles`
--
ALTER TABLE `exercise_impacted_muscles`
  ADD CONSTRAINT `exercise_impacted_muscles_ibfk_1` FOREIGN KEY (`exercise_id`) REFERENCES `exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `exercise_replacement_actions`
--
ALTER TABLE `exercise_replacement_actions`
  ADD CONSTRAINT `exercise_replacement_actions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exercise_replacement_actions_ibfk_2` FOREIGN KEY (`custom_exercise_id`) REFERENCES `exercises` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `exercise_replacement_actions_ibfk_3` FOREIGN KEY (`global_exercise_id`) REFERENCES `exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `member_invitations`
--
ALTER TABLE `member_invitations`
  ADD CONSTRAINT `member_invitations_ibfk_1` FOREIGN KEY (`invited_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD CONSTRAINT `password_reset_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ticket_messages`
--
ALTER TABLE `ticket_messages`
  ADD CONSTRAINT `ticket_messages_ibfk_1` FOREIGN KEY (`ticket_id`) REFERENCES `contact_tickets` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `ticket_messages_ibfk_2` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ticket_message_attachments`
--
ALTER TABLE `ticket_message_attachments`
  ADD CONSTRAINT `ticket_message_attachments_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `ticket_messages` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `user_exercise_notes`
--
ALTER TABLE `user_exercise_notes`
  ADD CONSTRAINT `user_exercise_notes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_exercise_notes_ibfk_2` FOREIGN KEY (`exercise_id`) REFERENCES `exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `user_preferences`
--
ALTER TABLE `user_preferences`
  ADD CONSTRAINT `fk_user_preferences_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workouts`
--
ALTER TABLE `workouts`
  ADD CONSTRAINT `workouts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_exercises`
--
ALTER TABLE `workout_exercises`
  ADD CONSTRAINT `workout_exercises_ibfk_1` FOREIGN KEY (`workout_id`) REFERENCES `workouts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `workout_exercises_ibfk_2` FOREIGN KEY (`exercise_id`) REFERENCES `exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_exercise_sets`
--
ALTER TABLE `workout_exercise_sets`
  ADD CONSTRAINT `workout_exercise_sets_ibfk_1` FOREIGN KEY (`workout_exercise_id`) REFERENCES `workout_exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_exercise_set_drops`
--
ALTER TABLE `workout_exercise_set_drops`
  ADD CONSTRAINT `workout_exercise_set_drops_ibfk_1` FOREIGN KEY (`workout_set_id`) REFERENCES `workout_exercise_sets` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_logs`
--
ALTER TABLE `workout_logs`
  ADD CONSTRAINT `workout_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_log_exercises`
--
ALTER TABLE `workout_log_exercises`
  ADD CONSTRAINT `fk_log_exercise_id` FOREIGN KEY (`exercise_id`) REFERENCES `exercises` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `workout_log_exercises_ibfk_1` FOREIGN KEY (`workout_log_id`) REFERENCES `workout_logs` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_log_exercise_sets`
--
ALTER TABLE `workout_log_exercise_sets`
  ADD CONSTRAINT `workout_log_exercise_sets_ibfk_1` FOREIGN KEY (`workout_log_exercise_id`) REFERENCES `workout_log_exercises` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_log_exercise_set_drops`
--
ALTER TABLE `workout_log_exercise_set_drops`
  ADD CONSTRAINT `workout_log_exercise_set_drops_ibfk_1` FOREIGN KEY (`workout_log_set_id`) REFERENCES `workout_log_exercise_sets` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `workout_tags`
--
ALTER TABLE `workout_tags`
  ADD CONSTRAINT `workout_tags_ibfk_1` FOREIGN KEY (`workout_id`) REFERENCES `workouts` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
