-- https://www.phpmyadmin.net/
--
-- Hôte : spixerkviadexdev.mysql.db
-- Généré le : mar. 04 nov. 2025 à 15:07
-- Version du serveur : 8.4.6-6
-- Version de PHP : 8.1.33

START TRANSACTION;



--
-- Base de données : `spixerkviadexdev`
--

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

--
-- Structure de la table `category`
--

CREATE TABLE `category` (
  `id` int NOT NULL,
  `label` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `category` (`id`, `label`) VALUES
(1, 'Course Ã  pied'),
(2, 'Trail'),
(3, 'VTT'),
(4, 'Triathlon'),
(5, 'Marathon'),
(6, 'Cyclisme sur route'),
(7, 'RandonnÃ©e');

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

--
-- Structure de la table `checkpoint_assignments`
--

CREATE TABLE `checkpoint_assignments` (
  `id` char(36) NOT NULL,
  `checkpoint_id` char(36) NOT NULL,
  `volunteer_user_id` char(36) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `clubs`
--

CREATE TABLE `clubs` (
  `id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `federation_id` char(36) DEFAULT NULL,
  `created_by` char(36) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `clubs` (`id`, `name`, `description`, `federation_id`, `created_by`, `created_at`, `updated_at`) VALUES
('06a2b44e-63ed-4ca5-8607-83936973253b', 'Spixer', 'Saint-Grégoire', NULL, '2f830f4b-fe0d-487e-9f59-616caccc4d78', '2025-11-03 09:00:04', '2025-11-03 09:00:04');

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

--
-- Structure de la table `club_memberships`
--

CREATE TABLE `club_memberships` (
  `id` int NOT NULL,
  `user_id` char(36) NOT NULL,
  `club_id` char(36) NOT NULL,
  `role` enum('admin','member','pending') NOT NULL DEFAULT 'pending',
  `license_number` varchar(255) DEFAULT NULL,
  `joined_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `club_memberships` (`id`, `user_id`, `club_id`, `role`, `license_number`, `joined_at`) VALUES
(1, '2f830f4b-fe0d-487e-9f59-616caccc4d78', '06a2b44e-63ed-4ca5-8607-83936973253b', 'admin', NULL, '2025-11-03 09:00:04');

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

--
-- Structure de la table `entity_images`
--

CREATE TABLE `entity_images` (
  `id` char(36) NOT NULL,
  `image_url` text NOT NULL,
  `entity_id` char(36) NOT NULL,
  `entity_type` enum('event','club','stage') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `entity_images` (`id`, `image_url`, `entity_id`, `entity_type`, `created_at`) VALUES
('bad86d43-d5c0-4023-ac69-60406fbaaa84', 'https://hds-spixer.s3.fr-par.scw.cloud/hds-spixer/event/d9a38ed0-3b7f-4b63-9ba8-b371ca79279a/ae9d0f14-7b6a-4c6c-9c6d-9d1501f95ad9.jpg', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'event', '2025-09-27 15:30:32');

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

--
-- Structure de la table `events`
--

CREATE TABLE `events` (
  `id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `label` varchar(100) DEFAULT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `organiser_id` char(36) DEFAULT NULL,
  `club_id` char(36) DEFAULT NULL,
  `PMR` tinyint(1) NOT NULL DEFAULT '0',
  `postal_code` varchar(10) NOT NULL,
  `address` text,
  `city` varchar(100) DEFAULT NULL,
  `region` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `lat` decimal(9,6) DEFAULT NULL,
  `long` decimal(9,6) DEFAULT NULL,
  `oneplan_path` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `events` (`id`, `name`, `description`, `label`, `start_time`, `end_time`, `created_at`, `updated_at`, `organiser_id`, `club_id`, `PMR`, `postal_code`, `address`, `city`, `region`, `country`, `lat`, `long`, `oneplan_path`) VALUES
('d9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'Enduro des Tertres St Gouëno 28/09/25', NULL, NULL, '2025-09-28 06:00:00', '2033-09-08 13:45:00', '2025-09-27 17:29:19', '2025-09-27 17:29:19', '2f830f4b-fe0d-487e-9f59-616caccc4d78', NULL, 0, '22330', NULL, 'Saint-Gouéno', NULL, NULL, 48.300080, -2.500006, NULL);

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

--
-- Structure de la table `event_volunteers`
--

CREATE TABLE `event_volunteers` (
  `id` char(36) NOT NULL,
  `user_id` char(36) NOT NULL,
  `event_id` char(36) NOT NULL,
  `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending',
  `role` varchar(255) DEFAULT NULL,
  `notes` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `federations`
--

CREATE TABLE `federations` (
  `id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `guest_profiles`
--

CREATE TABLE `guest_profiles` (
  `id` int NOT NULL,
  `managed_by_id` char(36) NOT NULL,
  `guest_user_id` char(36) NOT NULL,
  `status` enum('active','unlinked') NOT NULL DEFAULT 'active',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `newsletter_subscribers`
--

CREATE TABLE `newsletter_subscribers` (
  `id` int NOT NULL,
  `email` varchar(255) NOT NULL,
  `subscribed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `payments`
--

CREATE TABLE `payments` (
  `id` char(36) NOT NULL,
  `user_id` char(36) NOT NULL,
  `amount` int NOT NULL,
  `currency` varchar(3) NOT NULL,
  `status` varchar(255) NOT NULL,
  `stripe_payment_intent_id` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `price`
--

CREATE TABLE `price` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `amount` int NOT NULL,
  `currency` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `promo_codes`
--

CREATE TABLE `promo_codes` (
  `id` char(36) NOT NULL COMMENT 'UUID primary key',
  `code` varchar(50) NOT NULL COMMENT 'Promo code string (e.g., PARTNER2025)',
  `description` text COMMENT 'Human-readable description of the promo',
  `discount_type` enum('percentage','fixed_amount','free') NOT NULL DEFAULT 'percentage' COMMENT 'Type of discount calculation',
  `discount_value` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT 'Discount amount (percentage or fixed value)',
  `max_uses` int DEFAULT NULL COMMENT 'Maximum number of times code can be used (NULL = unlimited)',
  `uses_count` int NOT NULL DEFAULT '0' COMMENT 'Current number of times code has been used',
  `valid_from` datetime NOT NULL COMMENT 'Code becomes valid from this date/time',
  `valid_until` datetime NOT NULL COMMENT 'Code expires after this date/time',
  `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Whether code is currently active',
  `created_by` char(36) NOT NULL COMMENT 'User ID who created the promo code',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Promotional discount codes';

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

--
-- Structure de la table `rankings`
--

CREATE TABLE `rankings` (
  `id` char(36) NOT NULL,
  `stage_id` char(36) NOT NULL,
  `registration_id` char(36) NOT NULL,
  `rank_position` int DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `ranking_records`
--

CREATE TABLE `ranking_records` (
  `id` char(36) NOT NULL,
  `ranking_id` char(36) NOT NULL,
  `record_type` varchar(255) NOT NULL,
  `recorded_by_user_id` char(36) DEFAULT NULL,
  `captured_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bib_number` varchar(255) DEFAULT NULL,
  `latitude` double DEFAULT NULL,
  `longitude` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `registrations`
--

CREATE TABLE `registrations` (
  `id` char(36) NOT NULL,
  `user_id` char(36) NOT NULL,
  `stage_id` char(36) NOT NULL,
  `type` enum('runner','volunteer') DEFAULT 'runner',
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `bib_number` varchar(255) DEFAULT NULL,
  `promo_code_id` char(36) DEFAULT NULL COMMENT 'Promo code used for this registration',
  `original_price` decimal(10,2) DEFAULT NULL COMMENT 'Original stage price before discount',
  `final_price` decimal(10,2) DEFAULT NULL COMMENT 'Final price after discount',
  `discount_applied` decimal(10,2) DEFAULT NULL COMMENT 'Amount of discount applied'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `roles`
--

CREATE TABLE `roles` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `roles` (`id`, `name`) VALUES
(1, 'admin'),
(2, 'organizer'),
(3, 'runner'),
(4, 'volunteer');

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

--
-- Structure de la table `stages`
--

CREATE TABLE `stages` (
  `id` char(36) NOT NULL,
  `event_id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `registration_end_time` datetime DEFAULT NULL,
  `category_id` int DEFAULT NULL,
  `max_participants` int DEFAULT '100',
  `min_age` int DEFAULT NULL,
  `gpx_file_url` text,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `type` varchar(20) NOT NULL DEFAULT 'gpx',
  `lap_distance_meters` int DEFAULT NULL,
  `required_laps` int DEFAULT NULL,
  `total_distance_meters` int DEFAULT NULL,
  `bib_number_min` int DEFAULT NULL,
  `bib_number_max` int DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL COMMENT 'Stage registration price',
  `currency` varchar(3) DEFAULT 'EUR' COMMENT 'Price currency code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `stages` (`id`, `event_id`, `name`, `description`, `start_time`, `end_time`, `registration_end_time`, `category_id`, `max_participants`, `min_age`, `gpx_file_url`, `created_at`, `type`, `lap_distance_meters`, `required_laps`, `total_distance_meters`, `bib_number_min`, `bib_number_max`, `price`, `currency`) VALUES
('1a0d5f60-d751-4853-a209-75a708836a5c', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S6', 'Chapelle to Parking salle des fêtes', '2025-09-28 12:55:00', '2025-09-28 13:45:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:34:52', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR'),
('2c0ee8cb-6364-41b6-9944-d002bc37cdff', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S9', NULL, '2025-10-16 00:00:00', '2032-09-24 18:00:00', NULL, NULL, 100, NULL, NULL, '2025-09-28 10:37:45', 'point_to_point', NULL, NULL, 500, NULL, NULL, NULL, 'EUR'),
('2f2a282d-f56b-4190-9a41-52245bf6b2af', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S7', NULL, '2025-09-28 12:00:00', '2025-09-28 18:00:00', NULL, NULL, 100, NULL, NULL, '2025-09-28 10:37:16', 'point_to_point', NULL, NULL, 500, NULL, NULL, NULL, 'EUR'),
('51258747-6257-47c1-a50c-f67705dc6634', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S5', 'Start 2, butte étang to boules', '2025-09-28 10:45:00', '2025-09-28 13:15:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:34:45', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR'),
('7f4f4a24-7d1b-4269-99a9-517bb3c95776', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S2', 'Start 1, butte étang to Tennis', '2025-09-28 09:30:00', '2025-09-28 10:40:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:34:24', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR'),
('9cb12513-8c5f-46b2-b541-f77cd96292de', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S4', 'Route du tertre, derrière le stade to Droite Hangar rte kerfiac', '2025-09-28 10:30:00', '2025-09-28 11:55:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:34:39', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR'),
('c00435d5-b017-439a-8ef4-45cfb1ecba1f', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S8', NULL, '2025-09-28 12:00:00', '2025-09-28 18:00:00', NULL, NULL, 100, NULL, NULL, '2025-09-28 10:37:41', 'point_to_point', NULL, NULL, 500, NULL, NULL, NULL, 'EUR'),
('c1798787-2213-4c36-9170-17cf7f0a9494', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S1', 'Route du tertre, derrière le stade to Droite Hangar rte kerfiac', '2025-09-28 09:00:00', '2025-09-30 10:15:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:33:31', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR'),
('d945c9ab-ae36-4eea-baf6-ea2653a2af9c', 'd9a38ed0-3b7f-4b63-9ba8-b371ca79279a', 'S3', 'Chapelle to Gauche Hangar rte Kerfiac', '2025-09-28 10:00:00', '2025-09-28 11:15:00', NULL, NULL, 1000, NULL, NULL, '2025-09-27 17:34:31', 'point_to_point', NULL, NULL, 500, 0, 1000, NULL, 'EUR');

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

--
-- Structure de la table `stage_categories`
--

CREATE TABLE `stage_categories` (
  `id` char(36) NOT NULL,
  `label` varchar(255) NOT NULL,
  `group_name` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `stage_categories` (`id`, `label`, `group_name`) VALUES
('4eca902b-9bb8-11f0-b653-0242ac110005', 'Amateur', 'Competition Level'),
('4eca9458-9bb8-11f0-b653-0242ac110005', 'Elite', 'Competition Level'),
('4eca92ea-9bb8-11f0-b653-0242ac110005', 'Expert', 'Competition Level');

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

--
-- Structure de la table `stage_category_assignments`
--

CREATE TABLE `stage_category_assignments` (
  `stage_id` char(36) NOT NULL,
  `category_id` char(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `stage_category_assignments` (`stage_id`, `category_id`) VALUES
('1a0d5f60-d751-4853-a209-75a708836a5c', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('51258747-6257-47c1-a50c-f67705dc6634', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('7f4f4a24-7d1b-4269-99a9-517bb3c95776', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('9cb12513-8c5f-46b2-b541-f77cd96292de', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('c1798787-2213-4c36-9170-17cf7f0a9494', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('d945c9ab-ae36-4eea-baf6-ea2653a2af9c', '4eca902b-9bb8-11f0-b653-0242ac110005'),
('1a0d5f60-d751-4853-a209-75a708836a5c', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('51258747-6257-47c1-a50c-f67705dc6634', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('7f4f4a24-7d1b-4269-99a9-517bb3c95776', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('9cb12513-8c5f-46b2-b541-f77cd96292de', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('c1798787-2213-4c36-9170-17cf7f0a9494', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('d945c9ab-ae36-4eea-baf6-ea2653a2af9c', '4eca92ea-9bb8-11f0-b653-0242ac110005'),
('1a0d5f60-d751-4853-a209-75a708836a5c', '4eca9458-9bb8-11f0-b653-0242ac110005'),
('51258747-6257-47c1-a50c-f67705dc6634', '4eca9458-9bb8-11f0-b653-0242ac110005'),
('7f4f4a24-7d1b-4269-99a9-517bb3c95776', '4eca9458-9bb8-11f0-b653-0242ac110005'),
('9cb12513-8c5f-46b2-b541-f77cd96292de', '4eca9458-9bb8-11f0-b653-0242ac110005'),
('c1798787-2213-4c36-9170-17cf7f0a9494', '4eca9458-9bb8-11f0-b653-0242ac110005'),
('d945c9ab-ae36-4eea-baf6-ea2653a2af9c', '4eca9458-9bb8-11f0-b653-0242ac110005');

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

--
-- Structure de la table `stage_checkpoints`
--

CREATE TABLE `stage_checkpoints` (
  `id` char(36) NOT NULL,
  `stage_id` char(36) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `stage_checkpoints` (`id`, `stage_id`, `name`, `type`, `created_at`, `updated_at`) VALUES
('005aafdc-5aea-466a-8d4c-733b6fcf3e20', '2f2a282d-f56b-4190-9a41-52245bf6b2af', 'Start Line', 'start', '2025-09-28 08:37:16', '2025-09-28 08:37:16'),
('05dda5fd-8da2-4931-9717-9c2a1981c390', '51258747-6257-47c1-a50c-f67705dc6634', 'Finish Line', 'finish', '2025-09-27 15:34:45', '2025-09-27 15:34:45'),
('13d37c18-38f2-42dc-a7b2-c9554eeb051d', '7f4f4a24-7d1b-4269-99a9-517bb3c95776', 'Start Line', 'start', '2025-09-27 15:34:24', '2025-09-27 15:34:24'),
('27a56c99-718f-4660-b241-5f55725445dd', '7f4f4a24-7d1b-4269-99a9-517bb3c95776', 'Finish Line', 'finish', '2025-09-27 15:34:24', '2025-09-27 15:34:24'),
('35004681-06f3-4090-ab6f-2a6ac5a1b923', '1a0d5f60-d751-4853-a209-75a708836a5c', 'Start Line', 'start', '2025-09-27 15:34:52', '2025-09-27 15:34:52'),
('50154fb5-e179-488e-9c89-3b4c98edecdb', 'c00435d5-b017-439a-8ef4-45cfb1ecba1f', 'Finish Line', 'finish', '2025-09-28 08:37:41', '2025-09-28 08:37:41'),
('50d4c689-bb6f-4d97-8471-efbcc213245e', 'd945c9ab-ae36-4eea-baf6-ea2653a2af9c', 'Start Line', 'start', '2025-09-27 15:34:31', '2025-09-27 15:34:31'),
('5f2b0443-e7fa-4e7f-b8f6-86569f323315', '9cb12513-8c5f-46b2-b541-f77cd96292de', 'Start Line', 'start', '2025-09-27 15:34:39', '2025-09-27 15:34:39'),
('62b645be-c22f-48f5-9192-afe7c16311a2', '51258747-6257-47c1-a50c-f67705dc6634', 'Start Line', 'start', '2025-09-27 15:34:45', '2025-09-27 15:34:45'),
('7cbd13f1-0a70-462e-a933-c7180e6c6247', '2c0ee8cb-6364-41b6-9944-d002bc37cdff', 'Start Line', 'start', '2025-09-28 08:37:45', '2025-09-28 08:37:45'),
('7f194bfb-a28d-44ae-9b97-15ac43f4cccb', 'd945c9ab-ae36-4eea-baf6-ea2653a2af9c', 'Finish Line', 'finish', '2025-09-27 15:34:31', '2025-09-27 15:34:31'),
('845ffbc4-b93e-4bda-9709-69bec9aa0616', '2c0ee8cb-6364-41b6-9944-d002bc37cdff', 'Finish Line', 'finish', '2025-09-28 08:37:45', '2025-09-28 08:37:45'),
('a331e39f-73d9-4dc0-9cc8-f3db021f5ad7', '9cb12513-8c5f-46b2-b541-f77cd96292de', 'Finish Line', 'finish', '2025-09-27 15:34:39', '2025-09-27 15:34:39'),
('dee5ce42-794e-4faa-95a4-36ed4c4fd7ee', 'c00435d5-b017-439a-8ef4-45cfb1ecba1f', 'Start Line', 'start', '2025-09-28 08:37:41', '2025-09-28 08:37:41'),
('e97aa983-6ec6-4445-b5c6-39bef979952e', '1a0d5f60-d751-4853-a209-75a708836a5c', 'Finish Line', 'finish', '2025-09-27 15:34:52', '2025-09-27 15:34:52'),
('f439ce2f-d0ed-4b91-8b00-7e67b99858c4', '2f2a282d-f56b-4190-9a41-52245bf6b2af', 'Finish Line', 'finish', '2025-09-28 08:37:16', '2025-09-28 08:37:16'),
('f5b373ac-bd73-48f1-ac14-d703063d7ed6', 'c1798787-2213-4c36-9170-17cf7f0a9494', 'Start Line', 'start', '2025-09-27 15:33:31', '2025-09-27 15:33:31'),
('fbe03ae1-3b83-4c84-b5fc-02c4ecd4a9ea', 'c1798787-2213-4c36-9170-17cf7f0a9494', 'Finish Line', 'finish', '2025-09-27 15:33:31', '2025-09-27 15:33:31');

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

--
-- Structure de la table `user_favorite_categories`
--

CREATE TABLE `user_favorite_categories` (
  `id` int NOT NULL,
  `user_id` char(36) NOT NULL,
  `category_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

--
-- Structure de la table `user_informations`
--

CREATE TABLE `user_informations` (
  `id` int NOT NULL,
  `user_id` char(36) NOT NULL,
  `first_name` blob,
  `last_name` blob,
  `bio` blob,
  `avatar_url` text,
  `location` blob,
  `birthdate` timestamp NULL DEFAULT NULL,
  `is_premium_member` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `user_informations` (`id`, `user_id`, `first_name`, `last_name`, `bio`, `avatar_url`, `location`, `birthdate`, `is_premium_member`) VALUES
(2, '2f830f4b-fe0d-487e-9f59-616caccc4d78', NULL, NULL, NULL, NULL, NULL, NULL, 0),
(1057, 'f37e5b52-3920-4618-8b84-9aa7b21f891b', NULL, NULL, NULL, NULL, NULL, NULL, 0);

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

--
-- Structure de la table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` char(36) NOT NULL,
  `role_id` int NOT NULL,
  `stage_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `user_roles` (`user_id`, `role_id`, `stage_id`) VALUES
('2f830f4b-fe0d-487e-9f59-616caccc4d78', 1, NULL);

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

--
-- Structure de la table `video_events`
--

CREATE TABLE `video_events` (
  `id` int NOT NULL,
  `video_id` int NOT NULL,
  `ocr_text` text,
  `capture_timestamp` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `video_events` (`id`, `video_id`, `ocr_text`, `capture_timestamp`) VALUES
(48, 708015, 'No OCR', '2025-10-04 08:34:14'),
(49, 708015, 'No OCR', '2025-10-04 08:34:26'),
(50, 708015, '51', '2025-10-04 08:34:36'),
(51, 454454, 'No OCR', '2025-10-09 14:18:51'),
(52, 454454, 'No OCR', '2025-10-09 14:20:58'),
(53, 454454, 'No OCR', '2025-10-09 14:20:59'),
(54, 974524, 'No OCR', '2025-10-11 08:45:53'),
(55, 974524, 'No OCR', '2025-10-11 08:46:30'),
(56, 974524, 'No OCR', '2025-10-11 08:46:31'),
(57, 974524, '2', '2025-10-11 08:47:10'),
(58, 974524, '2', '2025-10-11 08:47:18'),
(59, 974524, '2', '2025-10-11 08:47:32'),
(60, 974524, '2', '2025-10-11 08:47:48'),
(61, 974524, '2', '2025-10-11 08:48:33'),
(62, 974524, '2', '2025-10-11 08:48:39'),
(63, 974524, '2', '2025-10-11 08:48:56'),
(64, 974524, '2', '2025-10-11 08:49:30'),
(65, 974524, '2', '2025-10-11 08:49:41'),
(66, 974524, '2', '2025-10-11 08:49:51'),
(67, 974524, '2', '2025-10-11 08:49:58'),
(68, 974524, '2', '2025-10-11 08:50:11'),
(69, 974524, '2', '2025-10-11 08:50:13'),
(70, 974524, '2', '2025-10-11 08:50:22'),
(71, 974524, '2', '2025-10-11 08:50:25'),
(72, 974524, '2', '2025-10-11 08:51:05'),
(73, 974524, '2', '2025-10-11 08:51:11'),
(74, 974524, '2', '2025-10-11 08:51:19'),
(75, 974524, 'No OCR', '2025-10-11 08:51:26'),
(76, 974524, 'No OCR', '2025-10-11 08:51:28'),
(77, 974524, '2', '2025-10-11 08:51:40'),
(78, 974524, '2', '2025-10-11 08:51:47'),
(79, 974524, '2', '2025-10-11 08:51:52'),
(80, 974524, '2', '2025-10-11 08:52:04'),
(81, 974524, '2', '2025-10-11 08:52:06'),
(82, 974524, '2', '2025-10-11 08:52:07'),
(83, 974524, '2', '2025-10-11 08:52:16'),
(84, 974524, '2', '2025-10-11 08:52:16'),
(85, 974524, '2', '2025-10-11 08:52:26'),
(86, 974524, '2', '2025-10-11 08:52:35'),
(87, 974524, '2', '2025-10-11 08:52:42'),
(88, 974524, '2', '2025-10-11 08:52:48'),
(89, 974524, '2', '2025-10-11 08:53:07'),
(90, 974524, '2', '2025-10-11 08:53:09'),
(91, 974524, '2', '2025-10-11 08:53:30'),
(92, 974524, '2', '2025-10-11 08:53:36'),
(93, 974524, '2', '2025-10-11 08:53:44'),
(94, 974524, '2', '2025-10-11 08:53:48'),
(95, 974524, 'No OCR', '2025-10-11 08:53:51'),
(96, 974524, 'No OCR', '2025-10-11 08:53:52'),
(97, 974524, '2', '2025-10-11 08:54:10'),
(98, 974524, '2', '2025-10-11 08:54:21'),
(99, 974524, '2', '2025-10-11 08:54:21'),
(100, 974524, '2', '2025-10-11 08:54:25'),
(101, 974524, '2', '2025-10-11 08:54:32'),
(102, 974524, 'No OCR', '2025-10-11 08:54:32'),
(103, 974524, 'No OCR', '2025-10-11 08:54:33'),
(104, 974524, '2', '2025-10-11 08:54:36'),
(105, 974524, '2', '2025-10-11 08:54:44'),
(106, 974524, '2', '2025-10-11 08:54:44'),
(107, 974524, '2', '2025-10-11 08:55:02'),
(108, 974524, 'No OCR', '2025-10-11 08:55:05'),
(109, 974524, '2', '2025-10-11 08:55:13'),
(110, 974524, '2', '2025-10-11 08:55:16'),
(111, 974524, '2', '2025-10-11 08:55:19'),
(112, 974524, 'No OCR', '2025-10-11 08:55:20'),
(113, 974524, '2', '2025-10-11 08:55:21'),
(114, 974524, 'No OCR', '2025-10-11 08:55:28'),
(115, 974524, 'No OCR', '2025-10-11 08:55:33'),
(116, 974524, '2', '2025-10-11 08:55:36'),
(117, 974524, '2', '2025-10-11 08:55:49'),
(118, 974524, 'No OCR', '2025-10-11 08:55:49'),
(119, 974524, '2', '2025-10-11 08:55:51'),
(120, 974524, 'No OCR', '2025-10-11 08:55:51'),
(121, 974524, '2', '2025-10-11 08:55:53'),
(122, 974524, '2', '2025-10-11 08:56:10'),
(123, 974524, '2', '2025-10-11 08:56:20'),
(124, 974524, 'No OCR', '2025-10-11 08:56:21'),
(125, 974524, 'No OCR', '2025-10-11 08:56:23'),
(126, 974524, '2', '2025-10-11 08:56:23'),
(127, 974524, 'No OCR', '2025-10-11 08:56:24'),
(128, 974524, 'No OCR', '2025-10-11 08:56:25'),
(129, 974524, 'No OCR', '2025-10-11 08:56:26'),
(130, 974524, '2', '2025-10-11 08:56:26'),
(131, 974524, '2', '2025-10-11 08:56:27'),
(132, 974524, '2', '2025-10-11 08:56:27'),
(133, 974524, '2', '2025-10-11 08:56:27'),
(134, 974524, '2', '2025-10-11 08:56:28'),
(135, 974524, '2', '2025-10-11 08:56:28'),
(136, 974524, 'No OCR', '2025-10-11 08:56:29'),
(137, 974524, '2', '2025-10-11 08:56:30'),
(138, 974524, '2', '2025-10-11 08:56:31'),
(139, 974524, 'No OCR', '2025-10-11 08:56:32'),
(140, 974524, '2', '2025-10-11 08:56:34'),
(141, 974524, '2', '2025-10-11 08:56:38'),
(142, 974524, 'No OCR', '2025-10-11 08:56:42'),
(143, 974524, 'No OCR', '2025-10-11 08:56:42'),
(144, 974524, '2', '2025-10-11 08:56:42'),
(145, 974524, '2', '2025-10-11 08:56:43'),
(146, 974524, '2', '2025-10-11 08:56:43'),
(147, 974524, 'No OCR', '2025-10-11 08:56:44'),
(148, 974524, 'No OCR', '2025-10-11 08:56:44'),
(149, 974524, 'No OCR', '2025-10-11 08:56:45'),
(150, 974524, 'No OCR', '2025-10-11 08:56:45'),
(151, 974524, 'No OCR', '2025-10-11 08:56:46'),
(152, 974524, '2', '2025-10-11 08:56:48'),
(153, 974524, 'No OCR', '2025-10-11 08:56:48'),
(154, 974524, 'No OCR', '2025-10-11 08:56:49'),
(155, 974524, 'No OCR', '2025-10-11 08:56:49'),
(156, 974524, 'No OCR', '2025-10-11 08:56:50'),
(157, 974524, '2', '2025-10-11 08:56:50'),
(158, 974524, 'No OCR', '2025-10-11 08:56:51'),
(159, 974524, 'No OCR', '2025-10-11 08:56:52'),
(160, 974524, 'No OCR', '2025-10-11 08:56:52'),
(161, 974524, '2', '2025-10-11 08:56:52'),
(162, 974524, '2', '2025-10-11 08:56:59'),
(163, 974524, '2', '2025-10-11 08:57:08'),
(164, 974524, '2', '2025-10-11 08:57:13'),
(165, 974524, 'No OCR', '2025-10-11 08:57:20'),
(166, 974524, '2', '2025-10-11 08:57:28'),
(167, 974524, '2', '2025-10-11 08:57:32'),
(168, 974524, '2', '2025-10-11 08:57:35'),
(169, 974524, '2', '2025-10-11 08:57:42'),
(170, 974524, '2', '2025-10-11 08:57:43'),
(171, 974524, '2', '2025-10-11 08:57:46'),
(172, 974524, '2', '2025-10-11 08:58:04'),
(173, 974524, '2', '2025-10-11 08:58:12'),
(174, 974524, '2', '2025-10-11 08:58:29'),
(175, 974524, '2', '2025-10-11 08:58:35'),
(176, 974524, '2', '2025-10-11 08:58:37'),
(177, 974524, '2', '2025-10-11 08:58:37'),
(178, 974524, 'No OCR', '2025-10-11 08:58:38'),
(179, 974524, '2', '2025-10-11 08:58:43'),
(180, 974524, '2', '2025-10-11 08:58:52'),
(181, 974524, 'No OCR', '2025-10-11 08:58:56'),
(182, 974524, '2', '2025-10-11 08:59:01'),
(183, 974524, '2', '2025-10-11 08:59:06'),
(184, 974524, '2', '2025-10-11 08:59:07'),
(185, 974524, '2', '2025-10-11 08:59:08'),
(186, 974524, '2', '2025-10-11 08:59:10'),
(187, 974524, '2', '2025-10-11 08:59:11'),
(188, 974524, 'No OCR', '2025-10-11 08:59:11'),
(189, 974524, '2', '2025-10-11 08:59:12'),
(190, 974524, '2', '2025-10-11 08:59:19'),
(191, 974524, '2', '2025-10-11 08:59:24'),
(192, 974524, '2', '2025-10-11 08:59:32'),
(193, 974524, 'No OCR', '2025-10-11 08:59:33'),
(194, 974524, '2', '2025-10-11 08:59:35'),
(195, 974524, 'No OCR', '2025-10-11 08:59:36'),
(196, 974524, 'No OCR', '2025-10-11 08:59:37'),
(197, 974524, 'No OCR', '2025-10-11 08:59:37'),
(198, 974524, 'No OCR', '2025-10-11 08:59:39'),
(199, 974524, '2', '2025-10-11 08:59:39'),
(200, 974524, 'No OCR', '2025-10-11 08:59:41'),
(201, 974524, '2', '2025-10-11 08:59:41'),
(202, 974524, 'No OCR', '2025-10-11 08:59:44'),
(203, 974524, '2', '2025-10-11 08:59:50'),
(204, 974524, '2', '2025-10-11 08:59:52'),
(205, 974524, '2', '2025-10-11 08:59:56'),
(206, 974524, 'No OCR', '2025-10-11 08:59:58'),
(207, 974524, 'No OCR', '2025-10-11 08:59:58'),
(208, 974524, '2', '2025-10-11 09:00:03'),
(209, 974524, '2', '2025-10-11 09:00:05'),
(210, 974524, 'No OCR', '2025-10-11 09:00:10'),
(211, 974524, 'No OCR', '2025-10-11 09:00:10'),
(212, 974524, '3', '2025-10-11 09:00:13'),
(213, 974524, 'No OCR', '2025-10-11 09:00:14'),
(214, 974524, '3', '2025-10-11 09:00:15'),
(215, 974524, 'No OCR', '2025-10-11 09:00:15'),
(216, 974524, 'No OCR', '2025-10-11 09:00:16'),
(217, 974524, 'No OCR', '2025-10-11 09:00:17'),
(218, 974524, 'No OCR', '2025-10-11 09:00:18'),
(219, 974524, 'No OCR', '2025-10-11 09:00:19'),
(220, 974524, 'No OCR', '2025-10-11 09:00:20'),
(221, 974524, 'No OCR', '2025-10-11 09:00:21'),
(222, 974524, 'No OCR', '2025-10-11 09:00:22'),
(223, 974524, 'No OCR', '2025-10-11 09:00:23'),
(224, 974524, '3', '2025-10-11 09:00:23'),
(225, 974524, 'No OCR', '2025-10-11 09:00:25'),
(226, 974524, '3', '2025-10-11 09:00:26'),
(227, 974524, '3', '2025-10-11 09:00:28'),
(228, 974524, '3', '2025-10-11 09:00:31'),
(229, 974524, '3', '2025-10-11 09:00:33'),
(230, 974524, '3', '2025-10-11 09:00:34'),
(231, 974524, '3', '2025-10-11 09:00:34'),
(232, 974524, '3', '2025-10-11 09:01:03'),
(233, 974524, '3', '2025-10-11 09:01:14'),
(234, 974524, '3', '2025-10-11 09:01:19'),
(235, 974524, '3', '2025-10-11 09:01:33'),
(236, 974524, '3', '2025-10-11 09:01:35'),
(237, 974524, '3', '2025-10-11 09:01:40'),
(238, 974524, '3', '2025-10-11 09:01:42'),
(239, 974524, '3', '2025-10-11 09:01:43'),
(240, 974524, '3', '2025-10-11 09:01:44'),
(241, 974524, '3', '2025-10-11 09:01:49'),
(242, 974524, 'No OCR', '2025-10-11 09:01:50'),
(243, 974524, 'No OCR', '2025-10-11 09:01:51'),
(244, 974524, 'No OCR', '2025-10-11 09:01:51'),
(245, 974524, '3', '2025-10-11 09:01:52'),
(246, 974524, '3', '2025-10-11 09:01:53'),
(247, 974524, 'No OCR', '2025-10-11 09:01:53'),
(248, 974524, 'No OCR', '2025-10-11 09:01:57'),
(249, 974524, '3', '2025-10-11 09:02:03'),
(250, 974524, '3', '2025-10-11 09:02:03'),
(251, 974524, '3', '2025-10-11 09:02:06'),
(252, 974524, '3', '2025-10-11 09:02:09'),
(253, 974524, '3', '2025-10-11 09:02:10'),
(254, 974524, '3', '2025-10-11 09:02:14'),
(255, 974524, '3', '2025-10-11 09:02:15'),
(256, 974524, '3', '2025-10-11 09:02:21'),
(257, 974524, '3', '2025-10-11 09:02:26'),
(258, 974524, '3', '2025-10-11 09:02:34'),
(259, 974524, '3', '2025-10-11 09:02:40'),
(260, 974524, '3', '2025-10-11 09:02:44'),
(261, 974524, '3', '2025-10-11 09:02:44'),
(262, 974524, '3', '2025-10-11 09:02:48'),
(263, 974524, '3', '2025-10-11 09:02:53'),
(264, 974524, '3', '2025-10-11 09:02:55'),
(265, 974524, '3', '2025-10-11 09:02:58'),
(266, 974524, '3', '2025-10-11 09:03:02'),
(267, 974524, '3', '2025-10-11 09:03:05'),
(268, 974524, '3', '2025-10-11 09:03:08'),
(269, 974524, '3', '2025-10-11 09:03:12'),
(270, 974524, '3', '2025-10-11 09:03:24'),
(271, 974524, '3', '2025-10-11 09:03:27'),
(272, 974524, '3', '2025-10-11 09:03:28'),
(273, 974524, '3', '2025-10-11 09:03:34'),
(274, 974524, '3', '2025-10-11 09:03:35'),
(275, 974524, '3', '2025-10-11 09:03:40'),
(276, 974524, '3', '2025-10-11 09:03:43'),
(277, 974524, '3', '2025-10-11 09:03:46'),
(278, 974524, '3', '2025-10-11 09:03:49'),
(279, 974524, '3', '2025-10-11 09:03:54'),
(280, 974524, '3', '2025-10-11 09:03:58'),
(281, 974524, '3', '2025-10-11 09:04:02'),
(282, 974524, '3', '2025-10-11 09:04:07'),
(283, 974524, '3', '2025-10-11 09:04:09'),
(284, 974524, '3', '2025-10-11 09:04:15'),
(285, 974524, '3', '2025-10-11 09:04:20'),
(286, 974524, '3', '2025-10-11 09:04:24'),
(287, 974524, '3', '2025-10-11 09:04:26'),
(288, 974524, 'No OCR', '2025-10-11 09:04:27'),
(289, 974524, 'No OCR', '2025-10-11 09:04:30'),
(290, 974524, '3', '2025-10-11 09:04:31'),
(291, 974524, '3', '2025-10-11 09:04:34'),
(292, 974524, '3', '2025-10-11 09:04:39'),
(293, 974524, '3', '2025-10-11 09:04:40'),
(294, 974524, '3', '2025-10-11 09:04:41'),
(295, 974524, '3', '2025-10-11 09:04:51'),
(296, 974524, '3', '2025-10-11 09:04:52'),
(297, 974524, 'No OCR', '2025-10-11 09:04:56'),
(298, 974524, '3', '2025-10-11 09:04:56'),
(299, 974524, 'No OCR', '2025-10-11 09:04:59'),
(300, 974524, 'No OCR', '2025-10-11 09:04:59'),
(301, 974524, 'No OCR', '2025-10-11 09:05:01'),
(302, 974524, '3', '2025-10-11 09:05:01'),
(303, 974524, 'No OCR', '2025-10-11 09:05:03'),
(304, 974524, 'No OCR', '2025-10-11 09:05:03'),
(305, 974524, '3', '2025-10-11 09:05:04'),
(306, 974524, 'No OCR', '2025-10-11 09:05:04'),
(307, 974524, '3', '2025-10-11 09:05:06'),
(308, 974524, '3', '2025-10-11 09:05:08'),
(309, 974524, '3', '2025-10-11 09:05:09'),
(310, 974524, '3', '2025-10-11 09:05:10'),
(311, 974524, '3', '2025-10-11 09:05:14'),
(312, 974524, '3', '2025-10-11 09:05:24'),
(313, 974524, '3', '2025-10-11 09:05:32'),
(314, 974524, '3', '2025-10-11 09:05:33'),
(315, 974524, '3', '2025-10-11 09:05:33'),
(316, 974524, '3', '2025-10-11 09:05:35'),
(317, 974524, '3', '2025-10-11 09:05:36'),
(318, 974524, '3', '2025-10-11 09:05:37'),
(319, 974524, 'No OCR', '2025-10-11 09:05:39'),
(320, 974524, '3', '2025-10-11 09:05:42'),
(321, 974524, '3', '2025-10-11 09:05:43'),
(322, 974524, '3', '2025-10-11 09:05:48'),
(323, 974524, '3', '2025-10-11 09:05:48'),
(324, 974524, '3', '2025-10-11 09:05:50'),
(325, 974524, '3', '2025-10-11 09:05:52'),
(326, 974524, '3', '2025-10-11 09:05:53'),
(327, 974524, '3', '2025-10-11 09:05:58'),
(328, 974524, 'No OCR', '2025-10-11 09:05:59'),
(329, 974524, '3', '2025-10-11 09:06:00'),
(330, 974524, 'No OCR', '2025-10-11 09:06:10'),
(331, 974524, '3', '2025-10-11 09:06:11'),
(332, 974524, '3', '2025-10-11 09:06:12'),
(333, 974524, '3', '2025-10-11 09:06:13'),
(334, 974524, '3', '2025-10-11 09:06:23'),
(335, 974524, '3', '2025-10-11 09:06:41'),
(336, 974524, '3', '2025-10-11 09:06:44'),
(337, 974524, '3', '2025-10-11 09:06:47'),
(338, 974524, '3', '2025-10-11 09:06:53'),
(339, 974524, '3', '2025-10-11 09:06:54'),
(340, 974524, '3', '2025-10-11 09:06:56'),
(341, 974524, '3', '2025-10-11 09:06:59'),
(342, 974524, '3', '2025-10-11 09:07:00'),
(343, 974524, '3', '2025-10-11 09:07:02'),
(344, 974524, '3', '2025-10-11 09:07:10'),
(345, 974524, '3', '2025-10-11 09:07:11'),
(346, 974524, '3', '2025-10-11 09:07:12'),
(347, 974524, 'No OCR', '2025-10-11 09:07:14'),
(348, 974524, '3', '2025-10-11 09:07:15'),
(349, 974524, '3', '2025-10-11 09:07:15'),
(350, 974524, '3', '2025-10-11 09:07:15'),
(351, 974524, '3', '2025-10-11 09:07:17'),
(352, 974524, '3', '2025-10-11 09:07:18'),
(353, 974524, '3', '2025-10-11 09:07:18'),
(354, 974524, '3', '2025-10-11 09:07:21'),
(355, 974524, '3', '2025-10-11 09:07:22'),
(356, 974524, '3', '2025-10-11 09:07:24'),
(357, 974524, '3', '2025-10-11 09:07:24'),
(358, 974524, '3', '2025-10-11 09:07:31'),
(359, 974524, '3', '2025-10-11 09:07:34'),
(360, 974524, '3', '2025-10-11 09:07:34'),
(361, 974524, '3', '2025-10-11 09:07:37'),
(362, 974524, '3', '2025-10-11 09:07:38'),
(363, 974524, '3', '2025-10-11 09:07:39'),
(364, 974524, '3', '2025-10-11 09:07:40'),
(365, 974524, '3', '2025-10-11 09:07:40'),
(366, 974524, '3', '2025-10-11 09:07:41'),
(367, 974524, '3', '2025-10-11 09:07:42'),
(368, 974524, '3', '2025-10-11 09:07:43'),
(369, 974524, '3', '2025-10-11 09:07:45'),
(370, 974524, '3', '2025-10-11 09:07:47'),
(371, 974524, 'No OCR', '2025-10-11 09:07:48'),
(372, 974524, '3', '2025-10-11 09:07:49'),
(373, 974524, '3', '2025-10-11 09:07:50'),
(374, 974524, '3', '2025-10-11 09:07:50'),
(375, 974524, '3', '2025-10-11 09:07:52'),
(376, 974524, '3', '2025-10-11 09:07:55'),
(377, 974524, '3', '2025-10-11 09:07:57'),
(378, 974524, '3', '2025-10-11 09:07:58'),
(379, 974524, '3', '2025-10-11 09:08:02'),
(380, 974524, '3', '2025-10-11 09:08:05'),
(381, 974524, '3', '2025-10-11 09:08:05'),
(382, 974524, '3', '2025-10-11 09:08:12'),
(383, 974524, 'No OCR', '2025-10-11 09:08:13'),
(384, 974524, '3', '2025-10-11 09:08:15'),
(385, 974524, 'No OCR', '2025-10-11 09:08:16'),
(386, 974524, '3', '2025-10-11 09:08:16'),
(387, 974524, 'No OCR', '2025-10-11 09:08:20'),
(388, 974524, '3', '2025-10-11 09:08:20'),
(389, 974524, 'No OCR', '2025-10-11 09:08:23'),
(390, 974524, 'No OCR', '2025-10-11 09:08:24'),
(391, 974524, 'No OCR', '2025-10-11 09:08:26'),
(392, 974524, 'No OCR', '2025-10-11 09:08:27'),
(393, 974524, '3', '2025-10-11 09:08:31'),
(394, 974524, '3', '2025-10-11 09:09:06'),
(395, 974524, '3', '2025-10-11 09:09:07'),
(396, 974524, 'No OCR', '2025-10-11 09:09:10'),
(397, 974524, 'No OCR', '2025-10-11 09:09:11'),
(398, 974524, '3', '2025-10-11 09:09:13'),
(399, 974524, '3', '2025-10-11 09:09:13'),
(400, 974524, '3', '2025-10-11 09:09:14'),
(401, 974524, 'No OCR', '2025-10-11 09:09:15'),
(402, 974524, '3', '2025-10-11 09:09:17'),
(403, 974524, 'No OCR', '2025-10-11 09:09:19'),
(404, 974524, 'No OCR', '2025-10-11 09:09:20'),
(405, 974524, '3', '2025-10-11 09:09:20'),
(406, 974524, 'No OCR', '2025-10-11 09:09:22'),
(407, 974524, 'No OCR', '2025-10-11 09:09:22'),
(408, 974524, 'No OCR', '2025-10-11 09:09:23'),
(409, 974524, 'No OCR', '2025-10-11 09:09:23'),
(410, 974524, 'No OCR', '2025-10-11 09:09:24'),
(411, 974524, 'No OCR', '2025-10-11 09:09:27'),
(412, 974524, '3', '2025-10-11 09:09:29'),
(413, 974524, '3', '2025-10-11 09:09:30'),
(414, 974524, 'No OCR', '2025-10-11 09:09:31'),
(415, 974524, 'No OCR', '2025-10-11 09:09:35'),
(416, 974524, '3', '2025-10-11 09:09:36'),
(417, 974524, 'No OCR', '2025-10-11 09:09:37'),
(418, 974524, 'No OCR', '2025-10-11 09:09:38'),
(419, 974524, '3', '2025-10-11 09:09:38'),
(420, 974524, '3', '2025-10-11 09:09:40'),
(421, 974524, 'No OCR', '2025-10-11 09:09:48'),
(422, 974524, '3', '2025-10-11 09:09:49'),
(423, 974524, '1', '2025-10-11 09:09:50'),
(424, 974524, '1', '2025-10-11 09:09:51'),
(425, 974524, '1', '2025-10-11 09:09:52'),
(426, 974524, 'No OCR', '2025-10-11 09:09:53'),
(427, 974524, '1', '2025-10-11 09:09:56'),
(428, 974524, '1', '2025-10-11 09:09:58'),
(429, 974524, '1', '2025-10-11 09:10:00'),
(430, 974524, '1', '2025-10-11 09:10:01'),
(431, 974524, '1', '2025-10-11 09:10:03'),
(432, 974524, '1', '2025-10-11 09:10:09'),
(433, 974524, '1', '2025-10-11 09:10:09'),
(434, 974524, '1', '2025-10-11 09:10:10'),
(435, 974524, '1', '2025-10-11 09:10:12'),
(436, 974524, '1', '2025-10-11 09:10:16'),
(437, 974524, '1', '2025-10-11 09:10:17'),
(438, 974524, '1', '2025-10-11 09:10:18'),
(439, 974524, '1', '2025-10-11 09:10:21'),
(440, 974524, '1', '2025-10-11 09:10:23'),
(441, 974524, '1', '2025-10-11 09:10:26'),
(442, 974524, '1', '2025-10-11 09:10:26'),
(443, 974524, '1', '2025-10-11 09:10:28'),
(444, 974524, '1', '2025-10-11 09:10:30'),
(445, 974524, '1', '2025-10-11 09:10:32'),
(446, 974524, '1', '2025-10-11 09:10:33'),
(447, 974524, '1', '2025-10-11 09:10:35'),
(448, 974524, '1', '2025-10-11 09:10:36'),
(449, 974524, '1', '2025-10-11 09:10:40'),
(450, 974524, '1', '2025-10-11 09:10:41'),
(451, 974524, '1', '2025-10-11 09:10:44'),
(452, 974524, '1', '2025-10-11 09:10:45'),
(453, 974524, '1', '2025-10-11 09:10:50'),
(454, 974524, '1', '2025-10-11 09:10:55'),
(455, 974524, '1', '2025-10-11 09:10:57'),
(456, 974524, '1', '2025-10-11 09:10:57'),
(457, 974524, '1', '2025-10-11 09:10:58'),
(458, 974524, '1', '2025-10-11 09:10:59'),
(459, 974524, '1', '2025-10-11 09:11:01'),
(460, 974524, '1', '2025-10-11 09:11:05'),
(461, 974524, '1', '2025-10-11 09:11:08'),
(462, 974524, '1', '2025-10-11 09:11:09'),
(463, 974524, '1', '2025-10-11 09:11:10'),
(464, 974524, '1', '2025-10-11 09:11:10'),
(465, 974524, '1', '2025-10-11 09:11:12'),
(466, 974524, '1', '2025-10-11 09:11:18'),
(467, 974524, '1', '2025-10-11 09:11:21'),
(468, 974524, '1', '2025-10-11 09:11:23'),
(469, 974524, '1', '2025-10-11 09:11:25'),
(470, 974524, '1', '2025-10-11 09:11:27'),
(471, 974524, '1', '2025-10-11 09:11:32'),
(472, 974524, '1', '2025-10-11 09:11:38'),
(473, 974524, '1', '2025-10-11 09:11:44'),
(474, 974524, '1', '2025-10-11 09:11:44'),
(475, 974524, '1', '2025-10-11 09:11:46'),
(476, 974524, '1', '2025-10-11 09:11:47'),
(477, 974524, '1', '2025-10-11 09:11:49'),
(478, 974524, '1', '2025-10-11 09:11:51'),
(479, 974524, '7', '2025-10-11 09:11:52'),
(480, 974524, '7', '2025-10-11 09:11:52'),
(481, 974524, '7', '2025-10-11 09:11:53'),
(482, 974524, '1', '2025-10-11 09:11:54'),
(483, 974524, '1', '2025-10-11 09:11:54'),
(484, 974524, '7', '2025-10-11 09:11:55'),
(485, 974524, '1', '2025-10-11 09:11:56'),
(486, 974524, '1', '2025-10-11 09:11:56'),
(487, 974524, '7', '2025-10-11 09:12:02'),
(488, 974524, '7', '2025-10-11 09:12:03'),
(489, 974524, '1', '2025-10-11 09:12:05'),
(490, 974524, '1', '2025-10-11 09:12:06'),
(491, 974524, '1', '2025-10-11 09:12:07'),
(492, 974524, '1', '2025-10-11 09:12:09'),
(493, 974524, '1', '2025-10-11 09:12:10'),
(494, 974524, '1', '2025-10-11 09:12:11'),
(495, 974524, '1', '2025-10-11 09:12:11'),
(496, 974524, '1', '2025-10-11 09:12:12'),
(497, 974524, '1', '2025-10-11 09:12:15'),
(498, 974524, '7', '2025-10-11 09:12:17'),
(499, 974524, '1', '2025-10-11 09:12:18'),
(500, 974524, '7', '2025-10-11 09:12:19'),
(501, 974524, '1', '2025-10-11 09:12:20'),
(502, 974524, '1', '2025-10-11 09:12:20'),
(503, 974524, '7', '2025-10-11 09:12:21'),
(504, 974524, '7', '2025-10-11 09:12:22'),
(505, 974524, '7', '2025-10-11 09:12:24'),
(506, 974524, '1', '2025-10-11 09:12:25'),
(507, 974524, '1', '2025-10-11 09:12:26'),
(508, 974524, '7', '2025-10-11 09:12:27'),
(509, 974524, '7', '2025-10-11 09:12:28'),
(510, 974524, '7', '2025-10-11 09:12:28'),
(511, 974524, '1', '2025-10-11 09:12:29'),
(512, 974524, '7', '2025-10-11 09:12:30'),
(513, 974524, '1', '2025-10-11 09:12:30'),
(514, 974524, '1', '2025-10-11 09:12:31'),
(515, 974524, '1', '2025-10-11 09:12:31'),
(516, 974524, '1', '2025-10-11 09:12:34'),
(517, 974524, '1', '2025-10-11 09:12:37'),
(518, 974524, '1', '2025-10-11 09:12:44'),
(519, 974524, '1', '2025-10-11 09:12:47'),
(520, 974524, '1', '2025-10-11 09:12:48'),
(521, 974524, '1', '2025-10-11 09:12:49'),
(522, 974524, '3', '2025-10-11 09:12:50'),
(523, 974524, '3', '2025-10-11 09:12:51'),
(524, 974524, '3', '2025-10-11 09:12:52'),
(525, 974524, '3', '2025-10-11 09:12:53'),
(526, 974524, '3', '2025-10-11 09:12:55'),
(527, 974524, '3', '2025-10-11 09:12:55'),
(528, 974524, '3', '2025-10-11 09:12:58'),
(529, 974524, '3', '2025-10-11 09:13:06'),
(530, 974524, '3', '2025-10-11 09:13:07'),
(531, 974524, '3', '2025-10-11 09:13:09'),
(532, 974524, '3', '2025-10-11 09:13:10'),
(533, 974524, '3', '2025-10-11 09:13:10'),
(534, 974524, '3', '2025-10-11 09:13:12'),
(535, 974524, '3', '2025-10-11 09:13:14'),
(536, 974524, '3', '2025-10-11 09:13:14'),
(537, 974524, '3', '2025-10-11 09:13:18'),
(538, 974524, '3', '2025-10-11 09:13:24'),
(539, 974524, '3', '2025-10-11 09:13:25'),
(540, 974524, '3', '2025-10-11 09:13:26'),
(541, 974524, '3', '2025-10-11 09:13:28'),
(542, 974524, '3', '2025-10-11 09:13:32'),
(543, 974524, '3', '2025-10-11 09:13:33'),
(544, 974524, '3', '2025-10-11 09:13:35'),
(545, 974524, '3', '2025-10-11 09:13:40'),
(546, 974524, '3', '2025-10-11 09:13:41'),
(547, 974524, '3', '2025-10-11 09:13:42'),
(548, 974524, '3', '2025-10-11 09:13:43'),
(549, 974524, '3', '2025-10-11 09:13:45'),
(550, 974524, '3', '2025-10-11 09:13:45'),
(551, 974524, '3', '2025-10-11 09:13:53'),
(552, 974524, '3', '2025-10-11 09:13:54'),
(553, 974524, '3', '2025-10-11 09:13:54'),
(554, 974524, '3', '2025-10-11 09:13:56'),
(555, 974524, '3', '2025-10-11 09:14:00'),
(556, 974524, '3', '2025-10-11 09:14:02'),
(557, 974524, '3', '2025-10-11 09:14:08'),
(558, 974524, '3', '2025-10-11 09:14:12'),
(559, 974524, '3', '2025-10-11 09:14:12'),
(560, 974524, '3', '2025-10-11 09:14:23'),
(561, 974524, '3', '2025-10-11 09:14:28'),
(562, 974524, '3', '2025-10-11 09:14:31'),
(563, 974524, '3', '2025-10-11 09:14:32'),
(564, 974524, '3', '2025-10-11 09:14:33'),
(565, 974524, '3', '2025-10-11 09:14:33'),
(566, 974524, '3', '2025-10-11 09:14:34'),
(567, 974524, '3', '2025-10-11 09:14:34'),
(568, 974524, '3', '2025-10-11 09:14:35'),
(569, 974524, '3', '2025-10-11 09:14:36'),
(570, 974524, '3', '2025-10-11 09:14:37'),
(571, 974524, '3', '2025-10-11 09:14:37'),
(572, 974524, '3', '2025-10-11 09:14:38'),
(573, 974524, '3', '2025-10-11 09:14:38'),
(574, 974524, '3', '2025-10-11 09:14:39'),
(575, 974524, '3', '2025-10-11 09:14:39'),
(576, 974524, '3', '2025-10-11 09:14:40'),
(577, 974524, '3', '2025-10-11 09:14:40'),
(578, 974524, '3', '2025-10-11 09:14:41'),
(579, 974524, '3', '2025-10-11 09:14:41'),
(580, 974524, '3', '2025-10-11 09:14:42'),
(581, 974524, '3', '2025-10-11 09:14:45'),
(582, 974524, '3', '2025-10-11 09:14:46'),
(583, 974524, '3', '2025-10-11 09:14:47'),
(584, 974524, '3', '2025-10-11 09:14:47'),
(585, 974524, '3', '2025-10-11 09:14:48'),
(586, 974524, '3', '2025-10-11 09:14:50'),
(587, 974524, '3', '2025-10-11 09:14:50'),
(588, 974524, '3', '2025-10-11 09:14:51'),
(589, 974524, '3', '2025-10-11 09:14:53'),
(590, 974524, '3', '2025-10-11 09:14:54'),
(591, 974524, '3', '2025-10-11 09:14:55'),
(592, 974524, '3', '2025-10-11 09:14:57'),
(593, 974524, '3', '2025-10-11 09:14:57'),
(594, 974524, '3', '2025-10-11 09:14:59'),
(595, 974524, '3', '2025-10-11 09:14:59'),
(596, 974524, '3', '2025-10-11 09:14:59'),
(597, 974524, '3', '2025-10-11 09:15:00'),
(598, 974524, '3', '2025-10-11 09:15:00'),
(599, 974524, '3', '2025-10-11 09:15:01'),
(600, 974524, '3', '2025-10-11 09:15:01'),
(601, 974524, '3', '2025-10-11 09:15:03'),
(602, 974524, '3', '2025-10-11 09:15:03'),
(603, 974524, '3', '2025-10-11 09:15:06'),
(604, 974524, '3', '2025-10-11 09:15:06'),
(605, 974524, '3', '2025-10-11 09:15:07'),
(606, 974524, '3', '2025-10-11 09:15:09'),
(607, 974524, '3', '2025-10-11 09:15:09'),
(608, 974524, '3', '2025-10-11 09:15:11'),
(609, 974524, '3', '2025-10-11 09:15:12'),
(610, 974524, '3', '2025-10-11 09:15:12'),
(611, 974524, '3', '2025-10-11 09:15:12'),
(612, 974524, '3', '2025-10-11 09:15:13'),
(613, 974524, '3', '2025-10-11 09:15:14'),
(614, 974524, '3', '2025-10-11 09:15:15'),
(615, 974524, '3', '2025-10-11 09:15:15'),
(616, 974524, '3', '2025-10-11 09:15:16'),
(617, 974524, '3', '2025-10-11 09:15:16'),
(618, 974524, '3', '2025-10-11 09:15:17'),
(619, 974524, '3', '2025-10-11 09:15:18'),
(620, 974524, '3', '2025-10-11 09:15:18'),
(621, 974524, '3', '2025-10-11 09:15:19'),
(622, 974524, '3', '2025-10-11 09:15:19'),
(623, 974524, '3', '2025-10-11 09:15:20'),
(624, 974524, '3', '2025-10-11 09:15:23'),
(625, 974524, '3', '2025-10-11 09:15:24'),
(626, 974524, '3', '2025-10-11 09:15:26'),
(627, 974524, '3', '2025-10-11 09:15:28'),
(628, 974524, '3', '2025-10-11 09:15:28'),
(629, 974524, '3', '2025-10-11 09:15:29'),
(630, 974524, '3', '2025-10-11 09:15:29'),
(631, 974524, '3', '2025-10-11 09:15:30'),
(632, 974524, '3', '2025-10-11 09:15:31'),
(633, 974524, '3', '2025-10-11 09:15:31'),
(634, 974524, '3', '2025-10-11 09:15:32'),
(635, 974524, '3', '2025-10-11 09:15:34'),
(636, 974524, '3', '2025-10-11 09:15:34'),
(637, 974524, '3', '2025-10-11 09:15:35'),
(638, 974524, '3', '2025-10-11 09:15:38'),
(639, 974524, '3', '2025-10-11 09:15:43'),
(640, 974524, '3', '2025-10-11 09:15:43'),
(641, 974524, '3', '2025-10-11 09:15:45'),
(642, 974524, '3', '2025-10-11 09:15:47'),
(643, 974524, '3', '2025-10-11 09:15:49'),
(644, 974524, '3', '2025-10-11 09:15:51'),
(645, 974524, '3', '2025-10-11 09:15:52'),
(646, 974524, '3', '2025-10-11 09:15:59'),
(647, 974524, '3', '2025-10-11 09:16:00'),
(648, 974524, '3', '2025-10-11 09:16:00'),
(649, 974524, '3', '2025-10-11 09:16:00'),
(650, 974524, '3', '2025-10-11 09:16:01'),
(651, 974524, '3', '2025-10-11 09:16:02'),
(652, 974524, '3', '2025-10-11 09:16:04'),
(653, 974524, '3', '2025-10-11 09:16:07'),
(654, 974524, '3', '2025-10-11 09:16:08'),
(655, 974524, '3', '2025-10-11 09:16:08'),
(656, 974524, '3', '2025-10-11 09:16:09'),
(657, 974524, '3', '2025-10-11 09:16:10'),
(658, 974524, '3', '2025-10-11 09:16:10'),
(659, 974524, '3', '2025-10-11 09:16:11'),
(660, 974524, '3', '2025-10-11 09:16:11'),
(661, 974524, '3', '2025-10-11 09:16:12'),
(662, 974524, '3', '2025-10-11 09:16:14'),
(663, 974524, '3', '2025-10-11 09:16:14'),
(664, 974524, '3', '2025-10-11 09:16:15'),
(665, 974524, '3', '2025-10-11 09:16:16'),
(666, 974524, '3', '2025-10-11 09:16:16'),
(667, 974524, '3', '2025-10-11 09:16:17'),
(668, 974524, '3', '2025-10-11 09:16:17'),
(669, 974524, '3', '2025-10-11 09:16:19'),
(670, 974524, '3', '2025-10-11 09:16:24'),
(671, 974524, '3', '2025-10-11 09:16:25'),
(672, 974524, '3', '2025-10-11 09:16:28'),
(673, 974524, '3', '2025-10-11 09:16:30'),
(674, 974524, '3', '2025-10-11 09:16:31'),
(675, 974524, '3', '2025-10-11 09:16:34'),
(676, 974524, '3', '2025-10-11 09:16:37'),
(677, 974524, '3', '2025-10-11 09:16:37'),
(678, 974524, '3', '2025-10-11 09:16:38'),
(679, 974524, '3', '2025-10-11 09:16:39'),
(680, 974524, '3', '2025-10-11 09:16:41'),
(681, 974524, '3', '2025-10-11 09:16:42'),
(682, 974524, '3', '2025-10-11 09:16:44'),
(683, 974524, '3', '2025-10-11 09:16:45'),
(684, 974524, '3', '2025-10-11 09:16:45'),
(685, 974524, '3', '2025-10-11 09:16:46'),
(686, 974524, '3', '2025-10-11 09:16:46'),
(687, 974524, '3', '2025-10-11 09:16:47'),
(688, 974524, '3', '2025-10-11 09:16:47'),
(689, 974524, '3', '2025-10-11 09:16:47'),
(690, 974524, '3', '2025-10-11 09:16:48'),
(691, 974524, '3', '2025-10-11 09:16:49'),
(692, 974524, '3', '2025-10-11 09:16:50'),
(693, 974524, '3', '2025-10-11 09:16:51'),
(694, 974524, '3', '2025-10-11 09:16:52'),
(695, 974524, '3', '2025-10-11 09:16:53'),
(696, 974524, '3', '2025-10-11 09:16:54'),
(697, 974524, '3', '2025-10-11 09:16:55'),
(698, 974524, '3', '2025-10-11 09:16:55'),
(699, 974524, '3', '2025-10-11 09:16:57'),
(700, 974524, '3', '2025-10-11 09:16:59'),
(701, 974524, '3', '2025-10-11 09:16:59'),
(702, 974524, '3', '2025-10-11 09:17:00'),
(703, 974524, '3', '2025-10-11 09:17:01'),
(704, 974524, '3', '2025-10-11 09:17:01'),
(705, 974524, '3', '2025-10-11 09:17:02'),
(706, 974524, '3', '2025-10-11 09:17:02'),
(707, 974524, '3', '2025-10-11 09:17:03'),
(708, 974524, '3', '2025-10-11 09:17:03'),
(709, 974524, '3', '2025-10-11 09:17:04'),
(710, 974524, '3', '2025-10-11 09:17:05'),
(711, 974524, '3', '2025-10-11 09:17:07'),
(712, 974524, '3', '2025-10-11 09:17:09'),
(713, 974524, '3', '2025-10-11 09:17:09'),
(714, 974524, '3', '2025-10-11 09:17:09'),
(715, 974524, '3', '2025-10-11 09:17:10'),
(716, 974524, '3', '2025-10-11 09:17:10'),
(717, 974524, '3', '2025-10-11 09:17:11'),
(718, 974524, '3', '2025-10-11 09:17:13'),
(719, 974524, '3', '2025-10-11 09:17:13'),
(720, 974524, '3', '2025-10-11 09:17:14'),
(721, 974524, '3', '2025-10-11 09:17:14'),
(722, 974524, '3', '2025-10-11 09:17:14'),
(723, 974524, '3', '2025-10-11 09:17:15'),
(724, 974524, '3', '2025-10-11 09:17:15'),
(725, 974524, '3', '2025-10-11 09:17:16'),
(726, 974524, '3', '2025-10-11 09:17:16'),
(727, 974524, '3', '2025-10-11 09:17:17'),
(728, 974524, '3', '2025-10-11 09:17:18'),
(729, 974524, '3', '2025-10-11 09:17:18'),
(730, 974524, '3', '2025-10-11 09:17:19'),
(731, 974524, '3', '2025-10-11 09:17:20'),
(732, 974524, '3', '2025-10-11 09:17:20'),
(733, 974524, '3', '2025-10-11 09:17:22'),
(734, 974524, '3', '2025-10-11 09:17:24'),
(735, 974524, '3', '2025-10-11 09:17:33'),
(736, 974524, '3', '2025-10-11 09:17:34'),
(737, 974524, '3', '2025-10-11 09:17:35'),
(738, 974524, '3', '2025-10-11 09:17:35'),
(739, 974524, '3', '2025-10-11 09:17:37'),
(740, 974524, '3', '2025-10-11 09:17:38'),
(741, 974524, '3', '2025-10-11 09:17:38'),
(742, 974524, '3', '2025-10-11 09:17:39'),
(743, 974524, '3', '2025-10-11 09:17:39'),
(744, 974524, '3', '2025-10-11 09:17:39'),
(745, 974524, '3', '2025-10-11 09:17:40'),
(746, 974524, '3', '2025-10-11 09:17:40'),
(747, 974524, '3', '2025-10-11 09:17:41'),
(748, 974524, '3', '2025-10-11 09:17:41'),
(749, 974524, '3', '2025-10-11 09:17:42'),
(750, 974524, '3', '2025-10-11 09:17:42'),
(751, 974524, '3', '2025-10-11 09:17:43'),
(752, 974524, '3', '2025-10-11 09:17:44'),
(753, 974524, '3', '2025-10-11 09:17:45'),
(754, 974524, '3', '2025-10-11 09:17:45'),
(755, 974524, '3', '2025-10-11 09:17:45'),
(756, 974524, '3', '2025-10-11 09:17:46'),
(757, 974524, '3', '2025-10-11 09:17:46'),
(758, 974524, '3', '2025-10-11 09:17:47'),
(759, 974524, '3', '2025-10-11 09:17:47'),
(760, 974524, '3', '2025-10-11 09:17:48'),
(761, 974524, '3', '2025-10-11 09:17:49'),
(762, 974524, '3', '2025-10-11 09:17:49'),
(763, 974524, '3', '2025-10-11 09:17:52'),
(764, 974524, 'No OCR', '2025-10-11 09:17:54'),
(765, 974524, 'No OCR', '2025-10-11 09:17:54'),
(766, 974524, '3', '2025-10-11 09:17:55'),
(767, 974524, '3', '2025-10-11 09:17:55'),
(768, 974524, '3', '2025-10-11 09:17:57'),
(769, 974524, '3', '2025-10-11 09:18:00'),
(770, 974524, '3', '2025-10-11 09:18:01'),
(771, 974524, '3', '2025-10-11 09:18:01'),
(772, 974524, '3', '2025-10-11 09:18:02'),
(773, 974524, '3', '2025-10-11 09:18:04'),
(774, 974524, '3', '2025-10-11 09:18:04'),
(775, 974524, '3', '2025-10-11 09:18:05'),
(776, 974524, '3', '2025-10-11 09:18:08'),
(777, 974524, '3', '2025-10-11 09:18:09'),
(778, 974524, '3', '2025-10-11 09:18:09'),
(779, 974524, '3', '2025-10-11 09:18:10'),
(780, 974524, '3', '2025-10-11 09:18:11'),
(781, 974524, '3', '2025-10-11 09:18:12'),
(782, 974524, '3', '2025-10-11 09:18:13'),
(783, 974524, '3', '2025-10-11 09:18:13'),
(784, 974524, '3', '2025-10-11 09:18:14'),
(785, 974524, '3', '2025-10-11 09:18:15'),
(786, 974524, '3', '2025-10-11 09:18:15'),
(787, 974524, '3', '2025-10-11 09:18:17'),
(788, 974524, '3', '2025-10-11 09:18:18'),
(789, 974524, '3', '2025-10-11 09:18:19'),
(790, 974524, '3', '2025-10-11 09:18:20'),
(791, 974524, '3', '2025-10-11 09:18:22'),
(792, 974524, '3', '2025-10-11 09:18:22'),
(793, 974524, '3', '2025-10-11 09:18:23'),
(794, 974524, '3', '2025-10-11 09:18:24'),
(795, 974524, '3', '2025-10-11 09:18:25'),
(796, 974524, '3', '2025-10-11 09:18:25'),
(797, 974524, '3', '2025-10-11 09:18:26'),
(798, 974524, '3', '2025-10-11 09:18:26'),
(799, 974524, '3', '2025-10-11 09:18:27'),
(800, 974524, '3', '2025-10-11 09:18:27'),
(801, 974524, '3', '2025-10-11 09:18:29'),
(802, 974524, '3', '2025-10-11 09:18:30'),
(803, 974524, '3', '2025-10-11 09:18:30'),
(804, 974524, '3', '2025-10-11 09:18:31'),
(805, 974524, '3', '2025-10-11 09:18:31'),
(806, 974524, '3', '2025-10-11 09:18:32'),
(807, 974524, '3', '2025-10-11 09:18:32'),
(808, 974524, '3', '2025-10-11 09:18:33'),
(809, 974524, '3', '2025-10-11 09:18:34'),
(810, 974524, '3', '2025-10-11 09:18:35'),
(811, 974524, '3', '2025-10-11 09:18:36'),
(812, 974524, '3', '2025-10-11 09:18:39'),
(813, 974524, '3', '2025-10-11 09:18:43'),
(814, 974524, '3', '2025-10-11 09:18:44'),
(815, 974524, '3', '2025-10-11 09:18:45'),
(816, 974524, '3', '2025-10-11 09:18:46'),
(817, 974524, '3', '2025-10-11 09:18:54'),
(818, 974524, '3', '2025-10-11 09:18:55'),
(819, 974524, '3', '2025-10-11 09:18:55'),
(820, 974524, '3', '2025-10-11 09:18:55'),
(821, 974524, '3', '2025-10-11 09:18:56'),
(822, 974524, '3', '2025-10-11 09:18:57'),
(823, 731783, 'No OCR', '2025-10-11 11:30:48'),
(824, 731783, 'No OCR', '2025-10-11 11:31:04'),
(825, 731783, 'No OCR', '2025-10-11 11:31:05'),
(826, 731783, 'No OCR', '2025-10-11 11:31:32'),
(827, 731783, 'No OCR', '2025-10-11 11:31:33'),
(828, 731783, 'No OCR', '2025-10-11 11:31:51'),
(829, 731783, 'No OCR', '2025-10-11 11:32:07'),
(830, 731783, 'No OCR', '2025-10-11 11:32:09'),
(831, 731783, 'No OCR', '2025-10-11 11:32:10'),
(832, 731783, 'No OCR', '2025-10-11 11:32:11'),
(833, 731783, 'No OCR', '2025-10-11 11:32:19'),
(834, 731783, 'No OCR', '2025-10-11 11:32:20'),
(835, 731783, 'No OCR', '2025-10-11 11:32:26'),
(836, 731783, 'No OCR', '2025-10-11 11:32:43'),
(837, 731783, 'No OCR', '2025-10-11 11:32:52'),
(838, 731783, 'No OCR', '2025-10-11 11:32:53'),
(839, 731783, 'No OCR', '2025-10-11 11:33:08'),
(840, 731783, 'No OCR', '2025-10-11 11:33:09'),
(841, 731783, 'No OCR', '2025-10-11 11:33:11'),
(842, 731783, 'No OCR', '2025-10-11 11:33:13'),
(843, 731783, 'No OCR', '2025-10-11 11:33:14'),
(844, 731783, 'No OCR', '2025-10-11 11:33:19'),
(845, 731783, 'No OCR', '2025-10-11 11:33:30'),
(846, 731783, 'No OCR', '2025-10-11 11:33:36'),
(847, 731783, 'No OCR', '2025-10-11 11:33:38'),
(848, 731783, 'No OCR', '2025-10-11 11:33:42'),
(849, 731783, 'No OCR', '2025-10-11 11:33:43'),
(850, 731783, 'No OCR', '2025-10-11 11:33:44'),
(851, 731783, 'No OCR', '2025-10-11 11:33:45'),
(852, 731783, 'No OCR', '2025-10-11 11:33:59'),
(853, 731783, 'No OCR', '2025-10-11 11:34:09'),
(854, 731783, '364', '2025-10-11 11:34:27'),
(855, 731783, '12', '2025-10-11 11:35:00'),
(856, 731783, '12', '2025-10-11 11:35:01'),
(857, 731783, '12', '2025-10-11 11:35:07'),
(858, 731783, '12', '2025-10-11 11:35:15'),
(859, 731783, '12', '2025-10-11 11:35:16'),
(860, 731783, '364', '2025-10-11 11:35:16'),
(861, 731783, '12', '2025-10-11 11:35:20'),
(862, 731783, '12', '2025-10-11 11:35:28'),
(863, 731783, '12', '2025-10-11 11:35:36'),
(864, 731783, '12', '2025-10-11 11:36:28'),
(865, 731783, '12', '2025-10-11 11:36:46'),
(866, 731783, '12', '2025-10-11 11:36:48'),
(867, 731783, '12', '2025-10-11 11:36:48'),
(868, 731783, '12', '2025-10-11 11:36:49'),
(869, 731783, '12', '2025-10-11 11:36:50'),
(870, 731783, '12', '2025-10-11 11:36:51'),
(871, 731783, '12', '2025-10-11 11:36:55'),
(872, 731783, '96, 552', '2025-10-11 11:37:01'),
(873, 731783, '96, 552', '2025-10-11 11:37:02'),
(874, 731783, '96, 552', '2025-10-11 11:37:06'),
(875, 731783, '96, 552', '2025-10-11 11:37:06'),
(876, 731783, '96, 552', '2025-10-11 11:37:08'),
(877, 731783, '96, 552', '2025-10-11 11:37:09'),
(878, 731783, '96, 552', '2025-10-11 11:37:09'),
(879, 731783, '96, 552', '2025-10-11 11:37:10'),
(880, 731783, '96, 552', '2025-10-11 11:37:10'),
(881, 731783, '96, 552', '2025-10-11 11:37:11'),
(882, 731783, '96, 552', '2025-10-11 11:37:11'),
(883, 731783, '96, 552', '2025-10-11 11:37:14'),
(884, 731783, '96, 552', '2025-10-11 11:37:14'),
(885, 731783, '96, 552', '2025-10-11 11:37:15'),
(886, 731783, '96, 552', '2025-10-11 11:37:15'),
(887, 731783, '54', '2025-10-11 11:37:51'),
(888, 731783, '54', '2025-10-11 11:37:52'),
(889, 731783, '54', '2025-10-11 11:38:04'),
(890, 731783, '6', '2025-10-11 11:38:13'),
(891, 731783, '26', '2025-10-11 11:38:14'),
(892, 731783, '6', '2025-10-11 11:38:15'),
(893, 731783, '6', '2025-10-11 11:38:15'),
(894, 731783, '278', '2025-10-11 11:38:25'),
(895, 731783, '278', '2025-10-11 11:38:25'),
(896, 731783, '278', '2025-10-11 11:38:33'),
(897, 731783, '278', '2025-10-11 11:38:38'),
(898, 731783, '278', '2025-10-11 11:38:41'),
(899, 731783, '21', '2025-10-11 11:38:43'),
(900, 731783, '21', '2025-10-11 11:38:45'),
(901, 731783, '21', '2025-10-11 11:38:46'),
(902, 731783, '21', '2025-10-11 11:38:46'),
(903, 731783, '21', '2025-10-11 11:38:57'),
(904, 731783, '21', '2025-10-11 11:38:57'),
(905, 731783, '21', '2025-10-11 11:39:03'),
(906, 731783, '21', '2025-10-11 11:39:05'),
(907, 731783, '21', '2025-10-11 11:39:05'),
(908, 731783, '21', '2025-10-11 11:39:22'),
(909, 731783, '21', '2025-10-11 11:39:24'),
(910, 731783, '21', '2025-10-11 11:39:25'),
(911, 731783, '21', '2025-10-11 11:39:34'),
(912, 731783, '21', '2025-10-11 11:39:35'),
(913, 731783, '21', '2025-10-11 11:39:40'),
(914, 731783, '21', '2025-10-11 11:39:41'),
(915, 731783, '21', '2025-10-11 11:39:48'),
(916, 731783, '21', '2025-10-11 11:40:03'),
(917, 731783, '21', '2025-10-11 11:40:16'),
(918, 731783, '21', '2025-10-11 11:40:17'),
(919, 731783, '19', '2025-10-11 11:40:33'),
(920, 731783, '21', '2025-10-11 11:40:34'),
(921, 731783, '19', '2025-10-11 11:40:41'),
(922, 731783, '21', '2025-10-11 11:40:42'),
(923, 731783, '88', '2025-10-11 11:40:55'),
(924, 731783, '88', '2025-10-11 11:41:16'),
(925, 731783, '88', '2025-10-11 11:41:50'),
(926, 731783, '62', '2025-10-11 11:41:51'),
(927, 731783, '179', '2025-10-11 11:41:53'),
(928, 731783, '179', '2025-10-11 11:41:53'),
(929, 731783, '179', '2025-10-11 11:41:56'),
(930, 731783, '179', '2025-10-11 11:42:09'),
(931, 731783, 'No OCR', '2025-10-11 12:02:59'),
(932, 731783, 'No OCR', '2025-10-11 12:03:01'),
(933, 731783, 'No OCR', '2025-10-11 12:03:03'),
(934, 731783, 'No OCR', '2025-10-11 12:03:07'),
(935, 731783, 'No OCR', '2025-10-11 12:03:20'),
(936, 731783, '27', '2025-10-11 12:03:22'),
(937, 731783, '27', '2025-10-11 12:03:32'),
(938, 731783, '27', '2025-10-11 12:03:45'),
(939, 731783, '27', '2025-10-11 12:03:48'),
(940, 731783, '27', '2025-10-11 12:03:50'),
(941, 731783, '27', '2025-10-11 12:03:50'),
(942, 731783, '540', '2025-10-11 12:03:56'),
(943, 731783, '540', '2025-10-11 12:04:02'),
(944, 731783, '540', '2025-10-11 12:04:31'),
(945, 731783, '370', '2025-10-11 12:04:40'),
(946, 731783, '370', '2025-10-11 12:05:01'),
(947, 731783, '370', '2025-10-11 12:05:08'),
(948, 731783, '370', '2025-10-11 12:05:08'),
(949, 731783, '370', '2025-10-11 12:05:16'),
(950, 731783, '370', '2025-10-11 12:05:30'),
(951, 731783, '368', '2025-10-11 12:05:32'),
(952, 731783, '368', '2025-10-11 12:05:33'),
(953, 731783, '121', '2025-10-11 12:05:34'),
(954, 731783, '121', '2025-10-11 12:05:34'),
(955, 731783, '121', '2025-10-11 12:05:46'),
(956, 731783, '121', '2025-10-11 12:06:03'),
(957, 731783, '121', '2025-10-11 12:06:11'),
(958, 731783, '121', '2025-10-11 12:06:21'),
(959, 731783, '121', '2025-10-11 12:06:21'),
(960, 731783, '0, 009', '2025-10-11 12:06:25'),
(961, 731783, '0, 009', '2025-10-11 12:06:26'),
(962, 731783, '0, 009', '2025-10-11 12:06:29'),
(963, 731783, '0, 009', '2025-10-11 12:06:39'),
(964, 731783, '0, 009', '2025-10-11 12:06:40'),
(965, 731783, '0, 009', '2025-10-11 12:06:43'),
(966, 731783, '0, 009', '2025-10-11 12:06:44'),
(967, 731783, '0, 009', '2025-10-11 12:06:46'),
(968, 731783, '701', '2025-10-11 12:07:00'),
(969, 731783, '0, 009', '2025-10-11 12:07:02'),
(970, 731783, '1, 9', '2025-10-11 12:07:13'),
(971, 731783, '1, 9', '2025-10-11 12:07:15'),
(972, 731783, '1, 9', '2025-10-11 12:07:16'),
(973, 731783, '198', '2025-10-11 12:07:17'),
(974, 731783, '909', '2025-10-11 12:07:20'),
(975, 731783, '909', '2025-10-11 12:07:35'),
(976, 731783, '901', '2025-10-11 12:07:45'),
(977, 731783, '901', '2025-10-11 12:07:58'),
(978, 731783, '288', '2025-10-11 12:08:03'),
(979, 731783, '288', '2025-10-11 12:08:23'),
(980, 731783, '288', '2025-10-11 12:08:43'),
(981, 731783, '288', '2025-10-11 12:08:47'),
(982, 731783, '288', '2025-10-11 12:08:52'),
(983, 731783, '288', '2025-10-11 12:08:55'),
(984, 731783, '288', '2025-10-11 12:08:59'),
(985, 731783, '288', '2025-10-11 12:08:59'),
(986, 731783, '288', '2025-10-11 12:09:08'),
(987, 731783, '288', '2025-10-11 12:09:15'),
(988, 731783, '288', '2025-10-11 12:09:18'),
(989, 731783, '288', '2025-10-11 12:09:36'),
(990, 731783, '288', '2025-10-11 12:09:53'),
(991, 731783, '288', '2025-10-11 12:10:00'),
(992, 731783, '288', '2025-10-11 12:10:27'),
(993, 731783, '288', '2025-10-11 12:10:35'),
(994, 731783, '288', '2025-10-11 12:10:37'),
(995, 285083, 'No OCR', '2025-10-11 12:11:23'),
(996, 285083, 'No OCR', '2025-10-11 12:11:27'),
(997, 285083, 'No OCR', '2025-10-11 12:11:33'),
(998, 285083, 'No OCR', '2025-10-11 12:11:35'),
(999, 285083, 'No OCR', '2025-10-11 12:11:38'),
(1000, 285083, 'No OCR', '2025-10-11 12:11:41'),
(1001, 285083, 'No OCR', '2025-10-11 12:11:42'),
(1002, 285083, 'No OCR', '2025-10-11 12:11:47'),
(1003, 285083, 'No OCR', '2025-10-11 12:11:50'),
(1004, 285083, 'No OCR', '2025-10-11 12:11:56'),
(1005, 285083, 'No OCR', '2025-10-11 12:12:23'),
(1006, 285083, 'No OCR', '2025-10-11 12:12:27'),
(1007, 285083, 'No OCR', '2025-10-11 12:12:30'),
(1008, 285083, 'No OCR', '2025-10-11 12:12:38'),
(1009, 285083, 'No OCR', '2025-10-11 12:12:47'),
(1010, 285083, 'No OCR', '2025-10-11 12:12:58'),
(1011, 285083, 'No OCR', '2025-10-11 12:12:59'),
(1012, 657776, 'No OCR', '2025-10-14 07:36:08'),
(1013, 657776, '355', '2025-10-14 07:55:03'),
(1014, 657776, '355', '2025-10-14 07:55:06'),
(1015, 657776, '200', '2025-10-14 07:55:28');

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

--
-- Index pour la table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `checkpoint_assignments`
--
ALTER TABLE `checkpoint_assignments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `checkpoint_id` (`checkpoint_id`,`volunteer_user_id`),
  ADD KEY `fk_checkpoint_assignments_user` (`volunteer_user_id`);

--
-- Index pour la table `clubs`
--
ALTER TABLE `clubs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `clubs_ibfk_1` (`federation_id`),
  ADD KEY `clubs_ibfk_2` (`created_by`);

--
-- Index pour la table `club_memberships`
--
ALTER TABLE `club_memberships`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`,`club_id`),
  ADD KEY `club_memberships_ibfk_2` (`club_id`);

--
-- Index pour la table `entity_images`
--
ALTER TABLE `entity_images`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_entity` (`entity_type`,`entity_id`);

--
-- Index pour la table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`),
  ADD KEY `events_ibfk_1` (`organiser_id`),
  ADD KEY `events_ibfk_2` (`club_id`);

--
-- Index pour la table `event_volunteers`
--
ALTER TABLE `event_volunteers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`,`event_id`),
  ADD KEY `event_volunteers_ibfk_2` (`event_id`);

--
-- Index pour la table `federations`
--
ALTER TABLE `federations`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `guest_profiles`
--
ALTER TABLE `guest_profiles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `guest_user_id` (`guest_user_id`),
  ADD KEY `guest_profiles_ibfk_1` (`managed_by_id`);

--
-- Index pour la table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Index pour la table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_ibfk_1` (`user_id`);

--
-- Index pour la table `price`
--
ALTER TABLE `price`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `promo_codes`
--
ALTER TABLE `promo_codes`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_code` (`code`) COMMENT 'Ensure promo codes are unique',
  ADD KEY `idx_code_active` (`code`,`is_active`) COMMENT 'Fast lookup for validation',
  ADD KEY `idx_created_by` (`created_by`),
  ADD KEY `idx_promo_codes_validation` (`code`,`is_active`,`valid_from`,`valid_until`);

--
-- Index pour la table `rankings`
--
ALTER TABLE `rankings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rankings_ibfk_1` (`stage_id`),
  ADD KEY `rankings_ibfk_2` (`registration_id`);

--
-- Index pour la table `ranking_records`
--
ALTER TABLE `ranking_records`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_ranking_records_ranking` (`ranking_id`),
  ADD KEY `fk_ranking_records_user` (`recorded_by_user_id`);

--
-- Index pour la table `registrations`
--
ALTER TABLE `registrations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `registrations_ibfk_1` (`user_id`),
  ADD KEY `registrations_ibfk_2` (`stage_id`),
  ADD KEY `idx_promo_code_id` (`promo_code_id`) COMMENT 'Promo code usage lookup';

--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Index pour la table `stages`
--
ALTER TABLE `stages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `stages_ibfk_1` (`event_id`),
  ADD KEY `stages_ibfk_2` (`category_id`),
  ADD KEY `idx_stages_pricing` (`price`,`currency`);

--
-- Index pour la table `stage_categories`
--
ALTER TABLE `stage_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `label` (`label`,`group_name`);

--
-- Index pour la table `stage_category_assignments`
--
ALTER TABLE `stage_category_assignments`
  ADD PRIMARY KEY (`stage_id`,`category_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Index pour la table `stage_checkpoints`
--
ALTER TABLE `stage_checkpoints`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_stage_checkpoints_stage` (`stage_id`);

--
-- Index pour la table `user_favorite_categories`
--
ALTER TABLE `user_favorite_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`,`category_id`),
  ADD KEY `user_favorite_categories_ibfk_2` (`category_id`);

--
-- Index pour la table `user_informations`
--
ALTER TABLE `user_informations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_id` (`user_id`);

--
-- Index pour la table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_ibfk_2` (`role_id`),
  ADD KEY `user_roles_ibfk_3` (`stage_id`);

--
-- Index pour la table `video_events`
--
ALTER TABLE `video_events`
  ADD PRIMARY KEY (`id`);

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

--
-- AUTO_INCREMENT pour la table `category`
--
ALTER TABLE `category`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `club_memberships`
--
ALTER TABLE `club_memberships`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `guest_profiles`
--
ALTER TABLE `guest_profiles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `price`
--
ALTER TABLE `price`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT pour la table `user_favorite_categories`
--
ALTER TABLE `user_favorite_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `user_informations`
--
ALTER TABLE `user_informations`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1058;

--
-- AUTO_INCREMENT pour la table `video_events`
--
ALTER TABLE `video_events`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1016;

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

--
-- Contraintes pour la table `checkpoint_assignments`
--
ALTER TABLE `checkpoint_assignments`
  ADD CONSTRAINT `fk_checkpoint_assignments_checkpoint` FOREIGN KEY (`checkpoint_id`) REFERENCES `stage_checkpoints` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_checkpoint_assignments_user` FOREIGN KEY (`volunteer_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `clubs`
--
ALTER TABLE `clubs`
  ADD CONSTRAINT `clubs_ibfk_1` FOREIGN KEY (`federation_id`) REFERENCES `federations` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `clubs_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `club_memberships`
--
ALTER TABLE `club_memberships`
  ADD CONSTRAINT `club_memberships_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `club_memberships_ibfk_2` FOREIGN KEY (`club_id`) REFERENCES `clubs` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `events`
--
ALTER TABLE `events`
  ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`organiser_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `events_ibfk_2` FOREIGN KEY (`club_id`) REFERENCES `clubs` (`id`) ON DELETE SET NULL;

--
-- Contraintes pour la table `event_volunteers`
--
ALTER TABLE `event_volunteers`
  ADD CONSTRAINT `event_volunteers_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `event_volunteers_ibfk_2` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `guest_profiles`
--
ALTER TABLE `guest_profiles`
  ADD CONSTRAINT `guest_profiles_ibfk_1` FOREIGN KEY (`managed_by_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guest_profiles_ibfk_2` FOREIGN KEY (`guest_user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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

--
-- Contraintes pour la table `rankings`
--
ALTER TABLE `rankings`
  ADD CONSTRAINT `rankings_ibfk_1` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `rankings_ibfk_2` FOREIGN KEY (`registration_id`) REFERENCES `registrations` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ranking_records`
--
ALTER TABLE `ranking_records`
  ADD CONSTRAINT `fk_ranking_records_ranking` FOREIGN KEY (`ranking_id`) REFERENCES `rankings` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ranking_records_user` FOREIGN KEY (`recorded_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Contraintes pour la table `registrations`
--
ALTER TABLE `registrations`
  ADD CONSTRAINT `fk_registrations_promo` FOREIGN KEY (`promo_code_id`) REFERENCES `promo_codes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `registrations_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `registrations_ibfk_2` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `stages`
--
ALTER TABLE `stages`
  ADD CONSTRAINT `stages_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stages_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE SET NULL;

--
-- Contraintes pour la table `stage_category_assignments`
--
ALTER TABLE `stage_category_assignments`
  ADD CONSTRAINT `stage_category_assignments_ibfk_1` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `stage_category_assignments_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `stage_categories` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `stage_checkpoints`
--
ALTER TABLE `stage_checkpoints`
  ADD CONSTRAINT `fk_stage_checkpoints_stage` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `user_favorite_categories`
--
ALTER TABLE `user_favorite_categories`
  ADD CONSTRAINT `user_favorite_categories_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_favorite_categories_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE;

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

--
-- Contraintes pour la table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_ibfk_3` FOREIGN KEY (`stage_id`) REFERENCES `stages` (`id`) ON DELETE SET NULL;
COMMIT;

