-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1
-- Généré le : jeu. 30 oct. 2025 à 00:34
-- Version du serveur : 10.4.32-MariaDB
-- Version de PHP : 8.2.12

START TRANSACTION;



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

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

--
-- Structure de la table `alerts`
--

CREATE TABLE `alerts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ruche_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `measured_at` datetime NOT NULL,
  `value` decimal(8,2) NOT NULL,
  `level` enum('low','high') NOT NULL,
  `ack_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `alerts` (`id`, `ruche_id`, `type`, `measured_at`, `value`, `level`, `ack_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'temperature', '2025-10-05 04:07:52', -5.50, 'low', '2025-10-04 21:30:20', '2025-10-04 21:30:20', '2025-10-04 21:30:20'),
(2, 1, 'temperature', '2025-10-05 04:07:52', -5.50, 'low', '2025-10-04 21:30:42', '2025-10-04 21:30:42', '2025-10-04 21:30:42');

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

--
-- Structure de la table `alert_settings`
--

CREATE TABLE `alert_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ruche_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(255) NOT NULL,
  `threshold_min` decimal(8,2) DEFAULT NULL,
  `threshold_max` decimal(8,2) DEFAULT NULL,
  `hysteresis` decimal(5,2) NOT NULL DEFAULT 0.50,
  `enabled` tinyint(1) NOT NULL DEFAULT 1,
  `temp_min` double DEFAULT NULL,
  `temp_max` double DEFAULT NULL,
  `humidity_min` double DEFAULT NULL,
  `humidity_max` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `alert_settings` (`id`, `ruche_id`, `type`, `threshold_min`, `threshold_max`, `hysteresis`, `enabled`, `temp_min`, `temp_max`, `humidity_min`, `humidity_max`, `created_at`, `updated_at`) VALUES
(1, 1, '', NULL, NULL, 0.50, 1, 18, 35, 30, 80, '2025-10-01 08:26:52', '2025-10-01 08:26:52'),
(3, 1, 'humidity', 30.00, 85.00, 2.00, 1, NULL, NULL, NULL, NULL, '2025-10-04 21:30:16', '2025-10-04 21:30:16'),
(4, 1, 'temperature', 0.00, 100.00, 1.00, 1, NULL, NULL, NULL, NULL, '2025-10-04 21:30:16', '2025-10-04 23:19:49'),
(5, 1, 'weight', NULL, NULL, 0.50, 1, NULL, NULL, NULL, NULL, '2025-10-04 21:30:16', '2025-10-04 21:30:16');

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

--
-- Structure de la table `apiculteurs`
--

CREATE TABLE `apiculteurs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nom` varchar(150) NOT NULL,
  `prenom` varchar(150) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `apiculteurs` (`id`, `user_id`, `nom`, `prenom`, `email`, `telephone`, `created_at`, `updated_at`) VALUES
(1, 1, 'Dupont', 'Alice', 'api@example.com', '0000', '2025-09-30 21:23:01', '2025-09-30 21:23:01'),
(2, NULL, 'Demo', 'Apiculteur', 'demo@ruche.local', '0000', '2025-10-04 20:19:00', '2025-10-04 20:19:00');

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

--
-- Structure de la table `capteurs`
--

CREATE TABLE `capteurs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ruche_id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL,
  `unite` varchar(20) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `capteurs` (`id`, `ruche_id`, `type`, `unite`, `reference`, `created_at`, `updated_at`) VALUES
(1, 1, 'temperature', '°C', NULL, '2025-10-01 08:26:52', '2025-10-01 08:26:52'),
(2, 1, 'humidity', '%', NULL, '2025-10-01 08:26:52', '2025-10-01 08:26:52'),
(3, 1, 'weight', 'kg', NULL, '2025-10-01 08:26:52', '2025-10-01 08:26:52'),
(5, 1, 'battery', NULL, 'Batterie (V)', '2025-10-05 00:50:47', '2025-10-05 00:50:47');

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

--
-- Structure de la table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `jobs`
--

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

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

--
-- Structure de la table `job_batches`
--

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

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

--
-- Structure de la table `mesures`
--

CREATE TABLE `mesures` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `capteur_id` bigint(20) UNSIGNED NOT NULL,
  `value_numeric` decimal(10,3) DEFAULT NULL,
  `value_raw` varchar(255) DEFAULT NULL,
  `valeur` decimal(8,3) NOT NULL,
  `measured_at` datetime NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `mesures` (`id`, `capteur_id`, `value_numeric`, `value_raw`, `valeur`, `measured_at`, `created_at`, `updated_at`) VALUES
(1, 1, 25.400, NULL, 25.400, '2025-09-30 19:59:47', '2025-09-30 08:59:47', '2025-10-05 07:54:26'),
(2, 2, 54.000, NULL, 54.000, '2025-09-30 19:59:47', '2025-09-30 08:59:47', '2025-10-05 07:54:26'),
(3, 3, 21.590, NULL, 21.590, '2025-09-30 19:59:47', '2025-09-30 08:59:47', '2025-10-05 07:54:26'),
(4, 1, 25.400, NULL, 25.400, '2025-09-30 20:29:47', '2025-09-30 09:29:47', '2025-10-05 07:54:26'),
(5, 2, 53.000, NULL, 53.000, '2025-09-30 20:29:47', '2025-09-30 09:29:47', '2025-10-05 07:54:26'),
(6, 3, 21.850, NULL, 21.850, '2025-09-30 20:29:47', '2025-09-30 09:29:47', '2025-10-05 07:54:26'),
(7, 1, 24.200, NULL, 24.200, '2025-09-30 20:59:47', '2025-09-30 09:59:47', '2025-10-05 07:54:26'),
(8, 2, 52.000, NULL, 52.000, '2025-09-30 20:59:47', '2025-09-30 09:59:47', '2025-10-05 07:54:26'),
(9, 3, 22.330, NULL, 22.330, '2025-09-30 20:59:47', '2025-09-30 09:59:47', '2025-10-05 07:54:26'),
(10, 1, 25.600, NULL, 25.600, '2025-09-30 21:29:47', '2025-09-30 10:29:47', '2025-10-05 07:54:26'),
(11, 2, 58.000, NULL, 58.000, '2025-09-30 21:29:47', '2025-09-30 10:29:47', '2025-10-05 07:54:26'),
(12, 3, 22.020, NULL, 22.020, '2025-09-30 21:29:47', '2025-09-30 10:29:47', '2025-10-05 07:54:26'),
(13, 1, 24.400, NULL, 24.400, '2025-09-30 21:59:47', '2025-09-30 10:59:47', '2025-10-05 07:54:26'),
(14, 2, 53.000, NULL, 53.000, '2025-09-30 21:59:47', '2025-09-30 10:59:47', '2025-10-05 07:54:26'),
(15, 3, 21.500, NULL, 21.500, '2025-09-30 21:59:47', '2025-09-30 10:59:47', '2025-10-05 07:54:26'),
(16, 1, 24.900, NULL, 24.900, '2025-09-30 22:29:47', '2025-09-30 11:29:47', '2025-10-05 07:54:26'),
(17, 2, 54.000, NULL, 54.000, '2025-09-30 22:29:47', '2025-09-30 11:29:47', '2025-10-05 07:54:26'),
(18, 3, 22.490, NULL, 22.490, '2025-09-30 22:29:47', '2025-09-30 11:29:47', '2025-10-05 07:54:26'),
(19, 1, 25.900, NULL, 25.900, '2025-09-30 22:59:47', '2025-09-30 11:59:47', '2025-10-05 07:54:26'),
(20, 2, 57.000, NULL, 57.000, '2025-09-30 22:59:47', '2025-09-30 11:59:47', '2025-10-05 07:54:26'),
(21, 3, 21.910, NULL, 21.910, '2025-09-30 22:59:47', '2025-09-30 11:59:47', '2025-10-05 07:54:26'),
(22, 1, 24.500, NULL, 24.500, '2025-09-30 23:29:47', '2025-09-30 12:29:47', '2025-10-05 07:54:26'),
(23, 2, 55.000, NULL, 55.000, '2025-09-30 23:29:47', '2025-09-30 12:29:47', '2025-10-05 07:54:26'),
(24, 3, 22.360, NULL, 22.360, '2025-09-30 23:29:47', '2025-09-30 12:29:47', '2025-10-05 07:54:26'),
(25, 1, 26.000, NULL, 26.000, '2025-09-30 23:59:47', '2025-09-30 12:59:47', '2025-10-05 07:54:26'),
(26, 2, 53.000, NULL, 53.000, '2025-09-30 23:59:47', '2025-09-30 12:59:47', '2025-10-05 07:54:26'),
(27, 3, 21.910, NULL, 21.910, '2025-09-30 23:59:47', '2025-09-30 12:59:47', '2025-10-05 07:54:26'),
(28, 1, 23.400, NULL, 23.400, '2025-10-01 00:29:47', '2025-09-30 13:29:47', '2025-10-05 07:54:26'),
(29, 2, 55.000, NULL, 55.000, '2025-10-01 00:29:47', '2025-09-30 13:29:47', '2025-10-05 07:54:26'),
(30, 3, 21.590, NULL, 21.590, '2025-10-01 00:29:47', '2025-09-30 13:29:47', '2025-10-05 07:54:26'),
(31, 1, 23.400, NULL, 23.400, '2025-10-01 00:59:47', '2025-09-30 13:59:47', '2025-10-05 07:54:26'),
(32, 2, 52.000, NULL, 52.000, '2025-10-01 00:59:47', '2025-09-30 13:59:47', '2025-10-05 07:54:26'),
(33, 3, 21.850, NULL, 21.850, '2025-10-01 00:59:47', '2025-09-30 13:59:47', '2025-10-05 07:54:26'),
(34, 1, 25.800, NULL, 25.800, '2025-10-01 01:29:47', '2025-09-30 14:29:47', '2025-10-05 07:54:26'),
(35, 2, 54.000, NULL, 54.000, '2025-10-01 01:29:47', '2025-09-30 14:29:47', '2025-10-05 07:54:26'),
(36, 3, 21.950, NULL, 21.950, '2025-10-01 01:29:47', '2025-09-30 14:29:47', '2025-10-05 07:54:26'),
(37, 1, 23.800, NULL, 23.800, '2025-10-01 01:59:47', '2025-09-30 14:59:47', '2025-10-05 07:54:26'),
(38, 2, 58.000, NULL, 58.000, '2025-10-01 01:59:47', '2025-09-30 14:59:47', '2025-10-05 07:54:26'),
(39, 3, 22.000, NULL, 22.000, '2025-10-01 01:59:47', '2025-09-30 14:59:47', '2025-10-05 07:54:26'),
(40, 1, 23.900, NULL, 23.900, '2025-10-01 02:29:47', '2025-09-30 15:29:47', '2025-10-05 07:54:26'),
(41, 2, 58.000, NULL, 58.000, '2025-10-01 02:29:47', '2025-09-30 15:29:47', '2025-10-05 07:54:26'),
(42, 3, 22.140, NULL, 22.140, '2025-10-01 02:29:47', '2025-09-30 15:29:47', '2025-10-05 07:54:26'),
(43, 1, 23.400, NULL, 23.400, '2025-10-01 02:59:47', '2025-09-30 15:59:47', '2025-10-05 07:54:26'),
(44, 2, 56.000, NULL, 56.000, '2025-10-01 02:59:47', '2025-09-30 15:59:47', '2025-10-05 07:54:26'),
(45, 3, 22.330, NULL, 22.330, '2025-10-01 02:59:47', '2025-09-30 15:59:47', '2025-10-05 07:54:26'),
(46, 1, 23.500, NULL, 23.500, '2025-10-01 03:29:47', '2025-09-30 16:29:47', '2025-10-05 07:54:26'),
(47, 2, 52.000, NULL, 52.000, '2025-10-01 03:29:47', '2025-09-30 16:29:47', '2025-10-05 07:54:26'),
(48, 3, 22.230, NULL, 22.230, '2025-10-01 03:29:47', '2025-09-30 16:29:47', '2025-10-05 07:54:26'),
(49, 1, 24.900, NULL, 24.900, '2025-10-01 03:59:47', '2025-09-30 16:59:47', '2025-10-05 07:54:26'),
(50, 2, 53.000, NULL, 53.000, '2025-10-01 03:59:47', '2025-09-30 16:59:47', '2025-10-05 07:54:26'),
(51, 3, 22.170, NULL, 22.170, '2025-10-01 03:59:47', '2025-09-30 16:59:47', '2025-10-05 07:54:26'),
(52, 1, 24.300, NULL, 24.300, '2025-10-01 04:29:47', '2025-09-30 17:29:47', '2025-10-05 07:54:26'),
(53, 2, 57.000, NULL, 57.000, '2025-10-01 04:29:47', '2025-09-30 17:29:47', '2025-10-05 07:54:26'),
(54, 3, 22.230, NULL, 22.230, '2025-10-01 04:29:47', '2025-09-30 17:29:47', '2025-10-05 07:54:26'),
(55, 1, 23.200, NULL, 23.200, '2025-10-01 04:59:47', '2025-09-30 17:59:47', '2025-10-05 07:54:26'),
(56, 2, 52.000, NULL, 52.000, '2025-10-01 04:59:47', '2025-09-30 17:59:47', '2025-10-05 07:54:26'),
(57, 3, 21.710, NULL, 21.710, '2025-10-01 04:59:47', '2025-09-30 17:59:47', '2025-10-05 07:54:26'),
(58, 1, 25.400, NULL, 25.400, '2025-10-01 05:29:47', '2025-09-30 18:29:47', '2025-10-05 07:54:26'),
(59, 2, 52.000, NULL, 52.000, '2025-10-01 05:29:47', '2025-09-30 18:29:47', '2025-10-05 07:54:26'),
(60, 3, 21.530, NULL, 21.530, '2025-10-01 05:29:47', '2025-09-30 18:29:47', '2025-10-05 07:54:26'),
(61, 1, 25.700, NULL, 25.700, '2025-10-01 05:59:47', '2025-09-30 18:59:47', '2025-10-05 07:54:26'),
(62, 2, 54.000, NULL, 54.000, '2025-10-01 05:59:47', '2025-09-30 18:59:47', '2025-10-05 07:54:26'),
(63, 3, 21.790, NULL, 21.790, '2025-10-01 05:59:47', '2025-09-30 18:59:47', '2025-10-05 07:54:26'),
(64, 1, 25.900, NULL, 25.900, '2025-10-01 06:29:47', '2025-09-30 19:29:47', '2025-10-05 07:54:26'),
(65, 2, 55.000, NULL, 55.000, '2025-10-01 06:29:47', '2025-09-30 19:29:47', '2025-10-05 07:54:26'),
(66, 3, 21.990, NULL, 21.990, '2025-10-01 06:29:47', '2025-09-30 19:29:47', '2025-10-05 07:54:26'),
(67, 1, 25.900, NULL, 25.900, '2025-10-01 06:59:47', '2025-09-30 19:59:47', '2025-10-05 07:54:26'),
(68, 2, 56.000, NULL, 56.000, '2025-10-01 06:59:47', '2025-09-30 19:59:47', '2025-10-05 07:54:26'),
(69, 3, 22.310, NULL, 22.310, '2025-10-01 06:59:47', '2025-09-30 19:59:47', '2025-10-05 07:54:26'),
(70, 1, 24.200, NULL, 24.200, '2025-10-01 07:29:47', '2025-09-30 20:29:47', '2025-10-05 07:54:26'),
(71, 2, 54.000, NULL, 54.000, '2025-10-01 07:29:47', '2025-09-30 20:29:47', '2025-10-05 07:54:26'),
(72, 3, 21.660, NULL, 21.660, '2025-10-01 07:29:47', '2025-09-30 20:29:47', '2025-10-05 07:54:26'),
(73, 1, 23.500, NULL, 23.500, '2025-10-01 07:59:47', '2025-09-30 20:59:47', '2025-10-05 07:54:26'),
(74, 2, 56.000, NULL, 56.000, '2025-10-01 07:59:47', '2025-09-30 20:59:47', '2025-10-05 07:54:26'),
(75, 3, 22.120, NULL, 22.120, '2025-10-01 07:59:47', '2025-09-30 20:59:47', '2025-10-05 07:54:26'),
(76, 1, 24.800, NULL, 24.800, '2025-10-01 08:29:47', '2025-09-30 21:29:47', '2025-10-05 07:54:26'),
(77, 2, 53.000, NULL, 53.000, '2025-10-01 08:29:47', '2025-09-30 21:29:47', '2025-10-05 07:54:26'),
(78, 3, 22.050, NULL, 22.050, '2025-10-01 08:29:47', '2025-09-30 21:29:47', '2025-10-05 07:54:26'),
(79, 1, 23.500, NULL, 23.500, '2025-10-01 08:59:47', '2025-09-30 21:59:47', '2025-10-05 07:54:26'),
(80, 2, 55.000, NULL, 55.000, '2025-10-01 08:59:47', '2025-09-30 21:59:47', '2025-10-05 07:54:26'),
(81, 3, 22.030, NULL, 22.030, '2025-10-01 08:59:47', '2025-09-30 21:59:47', '2025-10-05 07:54:26'),
(82, 1, 24.800, NULL, 24.800, '2025-10-01 09:29:47', '2025-09-30 22:29:47', '2025-10-05 07:54:26'),
(83, 2, 54.000, NULL, 54.000, '2025-10-01 09:29:47', '2025-09-30 22:29:47', '2025-10-05 07:54:26'),
(84, 3, 22.470, NULL, 22.470, '2025-10-01 09:29:47', '2025-09-30 22:29:47', '2025-10-05 07:54:26'),
(85, 1, 24.300, NULL, 24.300, '2025-10-01 09:59:47', '2025-09-30 22:59:47', '2025-10-05 07:54:26'),
(86, 2, 57.000, NULL, 57.000, '2025-10-01 09:59:47', '2025-09-30 22:59:47', '2025-10-05 07:54:26'),
(87, 3, 22.260, NULL, 22.260, '2025-10-01 09:59:47', '2025-09-30 22:59:47', '2025-10-05 07:54:26'),
(88, 1, 24.300, NULL, 24.300, '2025-10-01 10:29:47', '2025-09-30 23:29:47', '2025-10-05 07:54:26'),
(89, 2, 56.000, NULL, 56.000, '2025-10-01 10:29:47', '2025-09-30 23:29:47', '2025-10-05 07:54:26'),
(90, 3, 21.580, NULL, 21.580, '2025-10-01 10:29:47', '2025-09-30 23:29:47', '2025-10-05 07:54:26'),
(91, 1, 23.200, NULL, 23.200, '2025-10-01 10:59:47', '2025-09-30 23:59:47', '2025-10-05 07:54:26'),
(92, 2, 57.000, NULL, 57.000, '2025-10-01 10:59:47', '2025-09-30 23:59:47', '2025-10-05 07:54:26'),
(93, 3, 22.440, NULL, 22.440, '2025-10-01 10:59:47', '2025-09-30 23:59:47', '2025-10-05 07:54:26'),
(94, 1, 23.400, NULL, 23.400, '2025-10-01 11:29:47', '2025-10-01 00:29:47', '2025-10-05 07:54:26'),
(95, 2, 55.000, NULL, 55.000, '2025-10-01 11:29:47', '2025-10-01 00:29:47', '2025-10-05 07:54:26'),
(96, 3, 21.540, NULL, 21.540, '2025-10-01 11:29:47', '2025-10-01 00:29:47', '2025-10-05 07:54:26'),
(97, 1, 23.200, NULL, 23.200, '2025-10-01 11:59:47', '2025-10-01 00:59:47', '2025-10-05 07:54:26'),
(98, 2, 53.000, NULL, 53.000, '2025-10-01 11:59:47', '2025-10-01 00:59:47', '2025-10-05 07:54:26'),
(99, 3, 21.540, NULL, 21.540, '2025-10-01 11:59:47', '2025-10-01 00:59:47', '2025-10-05 07:54:26'),
(100, 1, 24.900, NULL, 24.900, '2025-10-01 12:29:47', '2025-10-01 01:29:47', '2025-10-05 07:54:26'),
(101, 2, 56.000, NULL, 56.000, '2025-10-01 12:29:47', '2025-10-01 01:29:47', '2025-10-05 07:54:26'),
(102, 3, 21.770, NULL, 21.770, '2025-10-01 12:29:47', '2025-10-01 01:29:47', '2025-10-05 07:54:26'),
(103, 1, 23.800, NULL, 23.800, '2025-10-01 12:59:47', '2025-10-01 01:59:47', '2025-10-05 07:54:26'),
(104, 2, 56.000, NULL, 56.000, '2025-10-01 12:59:47', '2025-10-01 01:59:47', '2025-10-05 07:54:26'),
(105, 3, 21.890, NULL, 21.890, '2025-10-01 12:59:47', '2025-10-01 01:59:47', '2025-10-05 07:54:26'),
(106, 1, 23.300, NULL, 23.300, '2025-10-01 13:29:47', '2025-10-01 02:29:47', '2025-10-05 07:54:26'),
(107, 2, 58.000, NULL, 58.000, '2025-10-01 13:29:47', '2025-10-01 02:29:47', '2025-10-05 07:54:26'),
(108, 3, 22.210, NULL, 22.210, '2025-10-01 13:29:47', '2025-10-01 02:29:47', '2025-10-05 07:54:26'),
(109, 1, 23.600, NULL, 23.600, '2025-10-01 13:59:47', '2025-10-01 02:59:47', '2025-10-05 07:54:26'),
(110, 2, 53.000, NULL, 53.000, '2025-10-01 13:59:47', '2025-10-01 02:59:47', '2025-10-05 07:54:26'),
(111, 3, 21.990, NULL, 21.990, '2025-10-01 13:59:47', '2025-10-01 02:59:47', '2025-10-05 07:54:26'),
(112, 1, 23.400, NULL, 23.400, '2025-10-01 14:29:47', '2025-10-01 03:29:47', '2025-10-05 07:54:26'),
(113, 2, 52.000, NULL, 52.000, '2025-10-01 14:29:47', '2025-10-01 03:29:47', '2025-10-05 07:54:26'),
(114, 3, 22.200, NULL, 22.200, '2025-10-01 14:29:47', '2025-10-01 03:29:47', '2025-10-05 07:54:26'),
(115, 1, 23.400, NULL, 23.400, '2025-10-01 14:59:47', '2025-10-01 03:59:47', '2025-10-05 07:54:26'),
(116, 2, 55.000, NULL, 55.000, '2025-10-01 14:59:47', '2025-10-01 03:59:47', '2025-10-05 07:54:26'),
(117, 3, 21.680, NULL, 21.680, '2025-10-01 14:59:47', '2025-10-01 03:59:47', '2025-10-05 07:54:26'),
(118, 1, 23.700, NULL, 23.700, '2025-10-01 15:29:47', '2025-10-01 04:29:47', '2025-10-05 07:54:26'),
(119, 2, 53.000, NULL, 53.000, '2025-10-01 15:29:47', '2025-10-01 04:29:47', '2025-10-05 07:54:26'),
(120, 3, 22.430, NULL, 22.430, '2025-10-01 15:29:47', '2025-10-01 04:29:47', '2025-10-05 07:54:26'),
(121, 1, 25.200, NULL, 25.200, '2025-10-01 15:59:47', '2025-10-01 04:59:47', '2025-10-05 07:54:26'),
(122, 2, 55.000, NULL, 55.000, '2025-10-01 15:59:47', '2025-10-01 04:59:47', '2025-10-05 07:54:26'),
(123, 3, 21.570, NULL, 21.570, '2025-10-01 15:59:47', '2025-10-01 04:59:47', '2025-10-05 07:54:26'),
(124, 1, 23.100, NULL, 23.100, '2025-10-01 16:29:47', '2025-10-01 05:29:47', '2025-10-05 07:54:26'),
(125, 2, 57.000, NULL, 57.000, '2025-10-01 16:29:47', '2025-10-01 05:29:47', '2025-10-05 07:54:26'),
(126, 3, 22.120, NULL, 22.120, '2025-10-01 16:29:47', '2025-10-01 05:29:47', '2025-10-05 07:54:26'),
(127, 1, 25.600, NULL, 25.600, '2025-10-01 16:59:47', '2025-10-01 05:59:47', '2025-10-05 07:54:26'),
(128, 2, 58.000, NULL, 58.000, '2025-10-01 16:59:47', '2025-10-01 05:59:47', '2025-10-05 07:54:26'),
(129, 3, 21.810, NULL, 21.810, '2025-10-01 16:59:47', '2025-10-01 05:59:47', '2025-10-05 07:54:26'),
(130, 1, 24.700, NULL, 24.700, '2025-10-01 17:29:47', '2025-10-01 06:29:47', '2025-10-05 07:54:26'),
(131, 2, 55.000, NULL, 55.000, '2025-10-01 17:29:47', '2025-10-01 06:29:47', '2025-10-05 07:54:26'),
(132, 3, 21.850, NULL, 21.850, '2025-10-01 17:29:47', '2025-10-01 06:29:47', '2025-10-05 07:54:26'),
(133, 1, 25.200, NULL, 25.200, '2025-10-01 17:59:47', '2025-10-01 06:59:47', '2025-10-05 07:54:26'),
(134, 2, 53.000, NULL, 53.000, '2025-10-01 17:59:47', '2025-10-01 06:59:47', '2025-10-05 07:54:26'),
(135, 3, 21.620, NULL, 21.620, '2025-10-01 17:59:47', '2025-10-01 06:59:47', '2025-10-05 07:54:26'),
(136, 1, 25.600, NULL, 25.600, '2025-10-01 18:29:47', '2025-10-01 07:29:47', '2025-10-05 07:54:26'),
(137, 2, 53.000, NULL, 53.000, '2025-10-01 18:29:47', '2025-10-01 07:29:47', '2025-10-05 07:54:26'),
(138, 3, 22.170, NULL, 22.170, '2025-10-01 18:29:47', '2025-10-01 07:29:47', '2025-10-05 07:54:26'),
(139, 1, 25.800, NULL, 25.800, '2025-10-01 18:59:47', '2025-10-01 07:59:47', '2025-10-05 07:54:26'),
(140, 2, 57.000, NULL, 57.000, '2025-10-01 18:59:47', '2025-10-01 07:59:47', '2025-10-05 07:54:26'),
(141, 3, 21.580, NULL, 21.580, '2025-10-01 18:59:47', '2025-10-01 07:59:47', '2025-10-05 07:54:26'),
(142, 1, 23.700, NULL, 23.700, '2025-10-01 19:29:47', '2025-10-01 08:29:47', '2025-10-05 07:54:26'),
(143, 2, 52.000, NULL, 52.000, '2025-10-01 19:29:47', '2025-10-01 08:29:47', '2025-10-05 07:54:26'),
(144, 3, 22.480, NULL, 22.480, '2025-10-01 19:29:47', '2025-10-01 08:29:47', '2025-10-05 07:54:26'),
(145, 1, 23.700, NULL, 23.700, '2025-10-03 17:06:32', NULL, '2025-10-05 07:54:26'),
(146, 2, 52.000, NULL, 52.000, '2025-10-03 17:06:32', NULL, '2025-10-05 07:54:26'),
(147, 1, 23.700, NULL, 23.700, '2025-10-03 17:07:00', NULL, '2025-10-05 07:54:26'),
(148, 2, 52.000, NULL, 52.000, '2025-10-03 17:07:00', NULL, '2025-10-05 07:54:26'),
(149, 1, 28.500, NULL, 28.500, '2025-10-04 06:12:33', '2025-10-04 14:06:52', '2025-10-05 07:54:26'),
(150, 2, 68.000, NULL, 68.000, '2025-10-04 06:12:33', '2025-10-04 14:06:52', '2025-10-05 07:54:26'),
(152, 1, 28.500, NULL, 28.500, '2025-10-04 06:12:34', '2025-10-04 14:18:17', '2025-10-05 07:54:26'),
(153, 2, 68.000, NULL, 68.000, '2025-10-04 06:12:34', '2025-10-04 14:18:17', '2025-10-05 07:54:26'),
(154, 1, 28.500, NULL, 28.500, '2025-10-05 14:25:01', '2025-10-04 14:34:44', '2025-10-05 07:54:26'),
(155, 2, 68.000, NULL, 68.000, '2025-10-05 14:25:01', '2025-10-04 14:34:44', '2025-10-05 07:54:26'),
(156, 1, 28.500, NULL, 28.500, '2025-10-05 23:00:00', '2025-10-04 14:44:04', '2025-10-05 07:54:26'),
(157, 2, 68.000, NULL, 68.000, '2025-10-05 23:00:00', '2025-10-04 14:44:04', '2025-10-05 07:54:26'),
(158, 1, 22.300, NULL, 22.300, '2025-10-05 04:06:52', '2025-10-04 17:07:02', '2025-10-05 07:54:26'),
(159, 2, 55.000, NULL, 55.000, '2025-10-05 04:06:52', '2025-10-04 17:07:02', '2025-10-05 07:54:26'),
(160, 1, -5.500, NULL, -5.500, '2025-10-05 04:07:52', '2025-10-04 17:07:52', '2025-10-05 07:54:26'),
(161, 2, 70.000, NULL, 70.000, '2025-10-05 04:07:52', '2025-10-04 17:07:52', '2025-10-05 07:54:26'),
(162, 1, 35.000, NULL, 35.000, '2025-10-05 04:08:48', '2025-10-04 17:08:48', '2025-10-05 07:54:26'),
(163, 1, 22.300, NULL, 22.300, '2025-10-05 04:09:54', '2025-10-04 17:09:54', '2025-10-05 07:54:26'),
(164, 2, 55.000, NULL, 55.000, '2025-10-05 04:09:54', '2025-10-04 17:09:54', '2025-10-05 07:54:26'),
(165, 1, 22.300, NULL, 22.300, '2025-10-05 04:10:37', '2025-10-04 17:10:37', '2025-10-05 07:54:26'),
(166, 2, 55.000, NULL, 55.000, '2025-10-05 04:10:37', '2025-10-04 17:10:37', '2025-10-05 07:54:26'),
(167, 1, 28.500, NULL, 28.500, '2025-10-05 05:05:00', '2025-10-04 18:05:00', '2025-10-05 07:54:26'),
(168, 2, 68.000, NULL, 68.000, '2025-10-05 05:05:00', '2025-10-04 18:05:00', '2025-10-05 07:54:26'),
(169, 1, 27.800, NULL, 0.000, '2025-10-04 19:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(170, 2, 73.400, NULL, 0.000, '2025-10-04 19:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(171, 1, 27.750, NULL, 0.000, '2025-10-04 19:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(172, 2, 71.970, NULL, 0.000, '2025-10-04 19:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(173, 1, 28.690, NULL, 0.000, '2025-10-04 20:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(174, 2, 72.680, NULL, 0.000, '2025-10-04 20:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(175, 1, 27.920, NULL, 0.000, '2025-10-04 20:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(176, 2, 73.030, NULL, 0.000, '2025-10-04 20:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(177, 1, 29.930, NULL, 0.000, '2025-10-04 20:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(178, 2, 71.720, NULL, 0.000, '2025-10-04 20:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(179, 1, 28.210, NULL, 0.000, '2025-10-04 20:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(180, 2, 72.070, NULL, 0.000, '2025-10-04 20:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(181, 1, 28.960, NULL, 0.000, '2025-10-04 21:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(182, 2, 72.360, NULL, 0.000, '2025-10-04 21:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(183, 1, 28.480, NULL, 0.000, '2025-10-04 21:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(184, 2, 71.420, NULL, 0.000, '2025-10-04 21:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(185, 1, 30.460, NULL, 0.000, '2025-10-04 21:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(186, 2, 71.440, NULL, 0.000, '2025-10-04 21:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(187, 1, 28.700, NULL, 0.000, '2025-10-04 21:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(188, 2, 71.140, NULL, 0.000, '2025-10-04 21:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(189, 1, 28.690, NULL, 0.000, '2025-10-04 22:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(190, 2, 71.030, NULL, 0.000, '2025-10-04 22:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(191, 1, 29.650, NULL, 0.000, '2025-10-04 22:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(192, 2, 70.200, NULL, 0.000, '2025-10-04 22:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(193, 1, 29.760, NULL, 0.000, '2025-10-04 22:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(194, 2, 68.570, NULL, 0.000, '2025-10-04 22:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(195, 1, 29.640, NULL, 0.000, '2025-10-04 22:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(196, 2, 69.450, NULL, 0.000, '2025-10-04 22:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(197, 1, 28.680, NULL, 0.000, '2025-10-04 23:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(198, 2, 69.450, NULL, 0.000, '2025-10-04 23:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(199, 1, 28.900, NULL, 0.000, '2025-10-04 23:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(200, 2, 67.780, NULL, 0.000, '2025-10-04 23:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(201, 1, 28.890, NULL, 0.000, '2025-10-04 23:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(202, 2, 68.130, NULL, 0.000, '2025-10-04 23:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(203, 1, 29.160, NULL, 0.000, '2025-10-04 23:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(204, 2, 67.930, NULL, 0.000, '2025-10-04 23:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(205, 1, 29.210, NULL, 0.000, '2025-10-05 00:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(206, 2, 67.570, NULL, 0.000, '2025-10-05 00:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(207, 1, 27.660, NULL, 0.000, '2025-10-05 00:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(208, 2, 67.470, NULL, 0.000, '2025-10-05 00:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(209, 1, 27.710, NULL, 0.000, '2025-10-05 00:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(210, 2, 66.820, NULL, 0.000, '2025-10-05 00:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(211, 1, 28.170, NULL, 0.000, '2025-10-05 00:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(212, 2, 67.630, NULL, 0.000, '2025-10-05 00:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(213, 1, 26.250, NULL, 0.000, '2025-10-05 01:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(214, 2, 67.000, NULL, 0.000, '2025-10-05 01:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(215, 1, 26.840, NULL, 0.000, '2025-10-05 01:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(216, 2, 67.130, NULL, 0.000, '2025-10-05 01:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(217, 1, 27.060, NULL, 0.000, '2025-10-05 01:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(218, 2, 67.120, NULL, 0.000, '2025-10-05 01:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(219, 1, 27.520, NULL, 0.000, '2025-10-05 01:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(220, 2, 68.070, NULL, 0.000, '2025-10-05 01:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(221, 1, 26.510, NULL, 0.000, '2025-10-05 02:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(222, 2, 67.380, NULL, 0.000, '2025-10-05 02:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(223, 1, 25.730, NULL, 0.000, '2025-10-05 02:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(224, 2, 67.140, NULL, 0.000, '2025-10-05 02:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(225, 1, 26.900, NULL, 0.000, '2025-10-05 02:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(226, 2, 68.240, NULL, 0.000, '2025-10-05 02:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(227, 1, 27.110, NULL, 0.000, '2025-10-05 02:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(228, 2, 67.780, NULL, 0.000, '2025-10-05 02:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(229, 1, 26.060, NULL, 0.000, '2025-10-05 03:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(230, 2, 68.460, NULL, 0.000, '2025-10-05 03:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(231, 1, 26.350, NULL, 0.000, '2025-10-05 03:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(232, 2, 69.460, NULL, 0.000, '2025-10-05 03:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(233, 1, 26.980, NULL, 0.000, '2025-10-05 03:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(234, 2, 68.780, NULL, 0.000, '2025-10-05 03:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(235, 1, 26.140, NULL, 0.000, '2025-10-05 03:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(236, 2, 70.810, NULL, 0.000, '2025-10-05 03:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(237, 1, 26.530, NULL, 0.000, '2025-10-05 04:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(238, 2, 69.830, NULL, 0.000, '2025-10-05 04:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(239, 1, 26.550, NULL, 0.000, '2025-10-05 04:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(240, 2, 71.550, NULL, 0.000, '2025-10-05 04:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(241, 1, 26.580, NULL, 0.000, '2025-10-05 04:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(242, 2, 71.150, NULL, 0.000, '2025-10-05 04:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(243, 1, 27.630, NULL, 0.000, '2025-10-05 04:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(244, 2, 72.530, NULL, 0.000, '2025-10-05 04:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(245, 1, 28.480, NULL, 0.000, '2025-10-05 05:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(246, 2, 72.470, NULL, 0.000, '2025-10-05 05:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(247, 1, 27.820, NULL, 0.000, '2025-10-05 05:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(248, 2, 72.070, NULL, 0.000, '2025-10-05 05:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(249, 1, 29.260, NULL, 0.000, '2025-10-05 05:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(250, 2, 73.130, NULL, 0.000, '2025-10-05 05:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(251, 1, 28.980, NULL, 0.000, '2025-10-05 05:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(252, 2, 71.930, NULL, 0.000, '2025-10-05 05:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(253, 1, 29.090, NULL, 0.000, '2025-10-05 06:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(254, 2, 72.680, NULL, 0.000, '2025-10-05 06:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(255, 1, 28.960, NULL, 0.000, '2025-10-05 06:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(256, 2, 72.470, NULL, 0.000, '2025-10-05 06:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(257, 1, 29.700, NULL, 0.000, '2025-10-05 06:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(258, 2, 74.000, NULL, 0.000, '2025-10-05 06:32:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(259, 1, 28.410, NULL, 0.000, '2025-10-05 06:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(260, 2, 73.170, NULL, 0.000, '2025-10-05 06:47:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(261, 1, 30.470, NULL, 0.000, '2025-10-05 07:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(262, 2, 72.780, NULL, 0.000, '2025-10-05 07:02:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(263, 1, 29.600, NULL, 0.000, '2025-10-05 07:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(264, 2, 73.230, NULL, 0.000, '2025-10-05 07:17:23', '2025-10-04 20:32:23', '2025-10-04 20:32:23'),
(265, 1, 28.300, NULL, 28.300, '2025-10-04 19:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(266, 2, 72.500, NULL, 73.000, '2025-10-04 19:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(267, 1, 29.150, NULL, 29.200, '2025-10-04 19:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(268, 2, 73.870, NULL, 74.000, '2025-10-04 19:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(269, 1, 28.890, NULL, 28.900, '2025-10-04 20:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(270, 2, 71.980, NULL, 72.000, '2025-10-04 20:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(271, 1, 29.720, NULL, 29.700, '2025-10-04 20:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(272, 2, 72.030, NULL, 72.000, '2025-10-04 20:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(273, 1, 29.230, NULL, 29.200, '2025-10-04 20:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(274, 2, 73.520, NULL, 74.000, '2025-10-04 20:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(275, 1, 28.910, NULL, 28.900, '2025-10-04 20:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(276, 2, 72.270, NULL, 72.000, '2025-10-04 20:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(277, 1, 29.460, NULL, 29.500, '2025-10-04 21:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(278, 2, 72.160, NULL, 72.000, '2025-10-04 21:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(279, 1, 28.580, NULL, 28.600, '2025-10-04 21:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(280, 2, 71.520, NULL, 72.000, '2025-10-04 21:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(281, 1, 28.560, NULL, 28.600, '2025-10-04 21:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(282, 2, 71.540, NULL, 72.000, '2025-10-04 21:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(283, 1, 29.500, NULL, 29.500, '2025-10-04 21:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(284, 2, 71.340, NULL, 71.000, '2025-10-04 21:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(285, 1, 29.890, NULL, 29.900, '2025-10-04 22:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(286, 2, 71.230, NULL, 71.000, '2025-10-04 22:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(287, 1, 28.550, NULL, 28.600, '2025-10-04 22:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(288, 2, 71.000, NULL, 71.000, '2025-10-04 22:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(289, 1, 29.560, NULL, 29.600, '2025-10-04 22:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(290, 2, 70.270, NULL, 70.000, '2025-10-04 22:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(291, 1, 28.740, NULL, 28.700, '2025-10-04 22:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(292, 2, 69.650, NULL, 70.000, '2025-10-04 22:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(293, 1, 28.080, NULL, 28.100, '2025-10-04 23:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(294, 2, 68.850, NULL, 69.000, '2025-10-04 23:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(295, 1, 28.900, NULL, 28.900, '2025-10-04 23:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(296, 2, 68.780, NULL, 69.000, '2025-10-04 23:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(297, 1, 29.190, NULL, 29.200, '2025-10-04 23:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(298, 2, 68.430, NULL, 68.000, '2025-10-04 23:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(299, 1, 29.160, NULL, 29.200, '2025-10-04 23:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(300, 2, 67.630, NULL, 68.000, '2025-10-04 23:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(301, 1, 28.010, NULL, 28.000, '2025-10-05 00:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(302, 2, 66.870, NULL, 67.000, '2025-10-05 00:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(303, 1, 27.460, NULL, 27.500, '2025-10-05 00:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(304, 2, 67.970, NULL, 68.000, '2025-10-05 00:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(305, 1, 27.610, NULL, 27.600, '2025-10-05 00:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(306, 2, 67.020, NULL, 67.000, '2025-10-05 00:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(307, 1, 28.470, NULL, 28.500, '2025-10-05 00:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(308, 2, 66.830, NULL, 67.000, '2025-10-05 00:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(309, 1, 26.750, NULL, 26.800, '2025-10-05 01:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(310, 2, 67.600, NULL, 68.000, '2025-10-05 01:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(311, 1, 28.040, NULL, 28.000, '2025-10-05 01:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(312, 2, 66.930, NULL, 67.000, '2025-10-05 01:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(313, 1, 26.060, NULL, 26.100, '2025-10-05 01:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(314, 2, 66.620, NULL, 67.000, '2025-10-05 01:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(315, 1, 27.320, NULL, 27.300, '2025-10-05 01:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(316, 2, 67.370, NULL, 67.000, '2025-10-05 01:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(317, 1, 26.610, NULL, 26.600, '2025-10-05 02:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(318, 2, 66.880, NULL, 67.000, '2025-10-05 02:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(319, 1, 26.730, NULL, 26.700, '2025-10-05 02:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(320, 2, 66.940, NULL, 67.000, '2025-10-05 02:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(321, 1, 27.100, NULL, 27.100, '2025-10-05 02:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(322, 2, 68.540, NULL, 69.000, '2025-10-05 02:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(323, 1, 26.110, NULL, 26.100, '2025-10-05 02:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(324, 2, 67.680, NULL, 68.000, '2025-10-05 02:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(325, 1, 25.760, NULL, 25.800, '2025-10-05 03:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(326, 2, 68.260, NULL, 68.000, '2025-10-05 03:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(327, 1, 26.950, NULL, 27.000, '2025-10-05 03:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(328, 2, 68.160, NULL, 68.000, '2025-10-05 03:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(329, 1, 27.380, NULL, 27.400, '2025-10-05 03:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(330, 2, 69.780, NULL, 70.000, '2025-10-05 03:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(331, 1, 27.640, NULL, 27.600, '2025-10-05 03:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(332, 2, 69.710, NULL, 70.000, '2025-10-05 03:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(333, 1, 27.430, NULL, 27.400, '2025-10-05 04:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(334, 2, 69.830, NULL, 70.000, '2025-10-05 04:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(335, 1, 26.850, NULL, 26.900, '2025-10-05 04:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(336, 2, 71.250, NULL, 71.000, '2025-10-05 04:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(337, 1, 26.780, NULL, 26.800, '2025-10-05 04:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(338, 2, 70.350, NULL, 70.000, '2025-10-05 04:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(339, 1, 27.330, NULL, 27.300, '2025-10-05 04:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(340, 2, 71.430, NULL, 71.000, '2025-10-05 04:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(341, 1, 28.280, NULL, 28.300, '2025-10-05 05:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(342, 2, 72.570, NULL, 73.000, '2025-10-05 05:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(343, 1, 27.920, NULL, 27.900, '2025-10-05 05:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(344, 2, 72.470, NULL, 72.000, '2025-10-05 05:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(345, 1, 28.660, NULL, 28.700, '2025-10-05 05:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(346, 2, 72.530, NULL, 73.000, '2025-10-05 05:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(347, 1, 29.380, NULL, 29.400, '2025-10-05 05:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(348, 2, 72.530, NULL, 73.000, '2025-10-05 05:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(349, 1, 29.290, NULL, 29.300, '2025-10-05 06:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(350, 2, 72.180, NULL, 72.000, '2025-10-05 06:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(351, 1, 28.560, NULL, 28.600, '2025-10-05 06:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(352, 2, 73.870, NULL, 74.000, '2025-10-05 06:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(353, 1, 29.200, NULL, 29.200, '2025-10-05 06:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(354, 2, 72.700, NULL, 73.000, '2025-10-05 06:37:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(355, 1, 28.710, NULL, 28.700, '2025-10-05 06:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(356, 2, 73.670, NULL, 74.000, '2025-10-05 06:52:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(357, 1, 30.170, NULL, 30.200, '2025-10-05 07:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(358, 2, 73.280, NULL, 73.000, '2025-10-05 07:07:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(359, 1, 29.300, NULL, 29.300, '2025-10-05 07:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(360, 2, 72.630, NULL, 73.000, '2025-10-05 07:22:18', '2025-10-04 20:37:18', '2025-10-04 20:37:18'),
(361, 1, 28.500, NULL, 28.500, '2025-10-04 19:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(362, 2, 74.000, NULL, 74.000, '2025-10-04 19:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(363, 1, 28.350, NULL, 28.400, '2025-10-04 19:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(364, 2, 73.870, NULL, 74.000, '2025-10-04 19:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(365, 1, 27.590, NULL, 27.600, '2025-10-04 20:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(366, 2, 72.180, NULL, 72.000, '2025-10-04 20:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(367, 1, 29.520, NULL, 29.500, '2025-10-04 20:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(368, 2, 72.230, NULL, 72.000, '2025-10-04 20:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(369, 1, 28.030, NULL, 28.000, '2025-10-04 20:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(370, 2, 72.320, NULL, 72.000, '2025-10-04 20:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(371, 1, 28.410, NULL, 28.400, '2025-10-04 20:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(372, 2, 72.970, NULL, 73.000, '2025-10-04 20:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(373, 1, 29.760, NULL, 29.800, '2025-10-04 21:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(374, 2, 71.460, NULL, 71.000, '2025-10-04 21:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(375, 1, 29.180, NULL, 29.200, '2025-10-04 21:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(376, 2, 72.620, NULL, 73.000, '2025-10-04 21:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(377, 1, 28.760, NULL, 28.800, '2025-10-04 21:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(378, 2, 71.540, NULL, 72.000, '2025-10-04 21:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(379, 1, 29.500, NULL, 29.500, '2025-10-04 21:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(380, 2, 71.240, NULL, 71.000, '2025-10-04 21:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(381, 1, 29.190, NULL, 29.200, '2025-10-04 22:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(382, 2, 70.330, NULL, 70.000, '2025-10-04 22:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(383, 1, 28.950, NULL, 29.000, '2025-10-04 22:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(384, 2, 70.200, NULL, 70.000, '2025-10-04 22:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(385, 1, 28.360, NULL, 28.400, '2025-10-04 22:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(386, 2, 70.170, NULL, 70.000, '2025-10-04 22:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(387, 1, 29.740, NULL, 29.700, '2025-10-04 22:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(388, 2, 68.750, NULL, 69.000, '2025-10-04 22:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(389, 1, 28.680, NULL, 28.700, '2025-10-04 23:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(390, 2, 69.050, NULL, 69.000, '2025-10-04 23:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(391, 1, 28.300, NULL, 28.300, '2025-10-04 23:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(392, 2, 68.580, NULL, 69.000, '2025-10-04 23:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(393, 1, 28.490, NULL, 28.500, '2025-10-04 23:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(394, 2, 68.330, NULL, 68.000, '2025-10-04 23:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(395, 1, 28.360, NULL, 28.400, '2025-10-04 23:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(396, 2, 66.830, NULL, 67.000, '2025-10-04 23:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(397, 1, 27.310, NULL, 27.300, '2025-10-05 00:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(398, 2, 66.870, NULL, 67.000, '2025-10-05 00:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(399, 1, 27.460, NULL, 27.500, '2025-10-05 00:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(400, 2, 67.270, NULL, 67.000, '2025-10-05 00:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(401, 1, 27.010, NULL, 27.000, '2025-10-05 00:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(402, 2, 66.220, NULL, 66.000, '2025-10-05 00:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(403, 1, 28.470, NULL, 28.500, '2025-10-05 00:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(404, 2, 66.030, NULL, 66.000, '2025-10-05 00:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(405, 1, 26.250, NULL, 26.300, '2025-10-05 01:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(406, 2, 66.500, NULL, 67.000, '2025-10-05 01:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(407, 1, 27.040, NULL, 27.000, '2025-10-05 01:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(408, 2, 66.330, NULL, 66.000, '2025-10-05 01:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(409, 1, 27.760, NULL, 27.800, '2025-10-05 01:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(410, 2, 67.720, NULL, 68.000, '2025-10-05 01:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(411, 1, 26.520, NULL, 26.500, '2025-10-05 01:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(412, 2, 66.770, NULL, 67.000, '2025-10-05 01:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(413, 1, 27.410, NULL, 27.400, '2025-10-05 02:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(414, 2, 68.080, NULL, 68.000, '2025-10-05 02:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(415, 1, 25.530, NULL, 25.500, '2025-10-05 02:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(416, 2, 68.140, NULL, 68.000, '2025-10-05 02:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(417, 1, 26.600, NULL, 26.600, '2025-10-05 02:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(418, 2, 67.140, NULL, 67.000, '2025-10-05 02:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(419, 1, 26.010, NULL, 26.000, '2025-10-05 02:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(420, 2, 69.280, NULL, 69.000, '2025-10-05 02:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(421, 1, 26.360, NULL, 26.400, '2025-10-05 03:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(422, 2, 69.260, NULL, 69.000, '2025-10-05 03:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(423, 1, 25.750, NULL, 25.800, '2025-10-05 03:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(424, 2, 69.560, NULL, 70.000, '2025-10-05 03:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(425, 1, 26.680, NULL, 26.700, '2025-10-05 03:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(426, 2, 69.180, NULL, 69.000, '2025-10-05 03:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(427, 1, 27.640, NULL, 27.600, '2025-10-05 03:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(428, 2, 69.310, NULL, 69.000, '2025-10-05 03:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(429, 1, 27.430, NULL, 27.400, '2025-10-05 04:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(430, 2, 69.630, NULL, 70.000, '2025-10-05 04:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(431, 1, 28.350, NULL, 28.400, '2025-10-05 04:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(432, 2, 69.950, NULL, 70.000, '2025-10-05 04:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(433, 1, 27.480, NULL, 27.500, '2025-10-05 04:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(434, 2, 70.950, NULL, 71.000, '2025-10-05 04:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(435, 1, 28.530, NULL, 28.500, '2025-10-05 04:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(436, 2, 70.930, NULL, 71.000, '2025-10-05 04:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(437, 1, 27.480, NULL, 27.500, '2025-10-05 05:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(438, 2, 71.570, NULL, 72.000, '2025-10-05 05:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(439, 1, 28.520, NULL, 28.500, '2025-10-05 05:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(440, 2, 71.670, NULL, 72.000, '2025-10-05 05:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(441, 1, 27.660, NULL, 27.700, '2025-10-05 05:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(442, 2, 72.130, NULL, 72.000, '2025-10-05 05:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(443, 1, 28.980, NULL, 29.000, '2025-10-05 05:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(444, 2, 72.030, NULL, 72.000, '2025-10-05 05:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(445, 1, 29.090, NULL, 29.100, '2025-10-05 06:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(446, 2, 71.880, NULL, 72.000, '2025-10-05 06:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(447, 1, 29.760, NULL, 29.800, '2025-10-05 06:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(448, 2, 72.570, NULL, 73.000, '2025-10-05 06:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(449, 1, 30.300, NULL, 30.300, '2025-10-05 06:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(450, 2, 73.800, NULL, 74.000, '2025-10-05 06:44:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(451, 1, 29.410, NULL, 29.400, '2025-10-05 06:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(452, 2, 73.370, NULL, 73.000, '2025-10-05 06:59:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(453, 1, 29.170, NULL, 29.200, '2025-10-05 07:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(454, 2, 72.180, NULL, 72.000, '2025-10-05 07:14:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(455, 1, 30.200, NULL, 30.200, '2025-10-05 07:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(456, 2, 73.130, NULL, 73.000, '2025-10-05 07:29:54', '2025-10-04 20:44:54', '2025-10-04 20:44:54'),
(457, 1, 28.400, NULL, 28.400, '2025-10-04 22:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(458, 2, 72.400, NULL, 72.000, '2025-10-04 22:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(459, 1, 28.150, NULL, 28.200, '2025-10-04 22:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(460, 2, 72.470, NULL, 72.000, '2025-10-04 22:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(461, 1, 28.290, NULL, 28.300, '2025-10-04 23:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(462, 2, 72.680, NULL, 73.000, '2025-10-04 23:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(463, 1, 28.220, NULL, 28.200, '2025-10-04 23:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(464, 2, 72.830, NULL, 73.000, '2025-10-04 23:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(465, 1, 28.530, NULL, 28.500, '2025-10-04 23:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(466, 2, 73.220, NULL, 73.000, '2025-10-04 23:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(467, 1, 29.110, NULL, 29.100, '2025-10-04 23:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(468, 2, 72.370, NULL, 72.000, '2025-10-04 23:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(469, 1, 28.260, NULL, 28.300, '2025-10-05 00:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(470, 2, 71.060, NULL, 71.000, '2025-10-05 00:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(471, 1, 29.180, NULL, 29.200, '2025-10-05 00:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(472, 2, 71.620, NULL, 72.000, '2025-10-05 00:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(473, 1, 29.760, NULL, 29.800, '2025-10-05 00:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(474, 2, 70.540, NULL, 71.000, '2025-10-05 00:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(475, 1, 30.500, NULL, 30.500, '2025-10-05 00:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(476, 2, 71.640, NULL, 72.000, '2025-10-05 00:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(477, 1, 28.990, NULL, 29.000, '2025-10-05 01:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(478, 2, 69.630, NULL, 70.000, '2025-10-05 01:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(479, 1, 30.250, NULL, 30.300, '2025-10-05 01:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(480, 2, 69.800, NULL, 70.000, '2025-10-05 01:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(481, 1, 29.560, NULL, 29.600, '2025-10-05 01:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(482, 2, 70.170, NULL, 70.000, '2025-10-05 01:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(483, 1, 28.940, NULL, 28.900, '2025-10-05 01:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(484, 2, 68.250, NULL, 68.000, '2025-10-05 01:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(485, 1, 28.980, NULL, 29.000, '2025-10-05 02:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(486, 2, 67.750, NULL, 68.000, '2025-10-05 02:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(487, 1, 29.200, NULL, 29.200, '2025-10-05 02:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(488, 2, 67.880, NULL, 68.000, '2025-10-05 02:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(489, 1, 28.290, NULL, 28.300, '2025-10-05 02:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(490, 2, 68.630, NULL, 69.000, '2025-10-05 02:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(491, 1, 27.760, NULL, 27.800, '2025-10-05 02:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(492, 2, 68.330, NULL, 68.000, '2025-10-05 02:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(493, 1, 27.710, NULL, 27.700, '2025-10-05 03:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(494, 2, 67.070, NULL, 67.000, '2025-10-05 03:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(495, 1, 27.060, NULL, 27.100, '2025-10-05 03:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(496, 2, 68.270, NULL, 68.000, '2025-10-05 03:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(497, 1, 28.210, NULL, 28.200, '2025-10-05 03:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(498, 2, 67.120, NULL, 67.000, '2025-10-05 03:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(499, 1, 27.470, NULL, 27.500, '2025-10-05 03:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(500, 2, 67.230, NULL, 67.000, '2025-10-05 03:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(501, 1, 27.750, NULL, 27.800, '2025-10-05 04:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(502, 2, 67.600, NULL, 68.000, '2025-10-05 04:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(503, 1, 26.040, NULL, 26.000, '2025-10-05 04:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(504, 2, 67.930, NULL, 68.000, '2025-10-05 04:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(505, 1, 25.860, NULL, 25.900, '2025-10-05 04:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(506, 2, 68.120, NULL, 68.000, '2025-10-05 04:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(507, 1, 25.920, NULL, 25.900, '2025-10-05 04:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48');
INSERT INTO `mesures` (`id`, `capteur_id`, `value_numeric`, `value_raw`, `valeur`, `measured_at`, `created_at`, `updated_at`) VALUES
(508, 2, 66.470, NULL, 66.000, '2025-10-05 04:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(509, 1, 26.910, NULL, 26.900, '2025-10-05 05:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(510, 2, 66.880, NULL, 67.000, '2025-10-05 05:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(511, 1, 26.230, NULL, 26.200, '2025-10-05 05:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(512, 2, 68.240, NULL, 68.000, '2025-10-05 05:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(513, 1, 25.500, NULL, 25.500, '2025-10-05 05:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(514, 2, 68.740, NULL, 69.000, '2025-10-05 05:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(515, 1, 27.210, NULL, 27.200, '2025-10-05 05:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(516, 2, 69.280, NULL, 69.000, '2025-10-05 05:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(517, 1, 27.260, NULL, 27.300, '2025-10-05 06:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(518, 2, 67.760, NULL, 68.000, '2025-10-05 06:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(519, 1, 25.850, NULL, 25.900, '2025-10-05 06:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(520, 2, 69.160, NULL, 69.000, '2025-10-05 06:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(521, 1, 27.280, NULL, 27.300, '2025-10-05 06:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(522, 2, 69.080, NULL, 69.000, '2025-10-05 06:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(523, 1, 26.040, NULL, 26.000, '2025-10-05 06:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(524, 2, 70.610, NULL, 71.000, '2025-10-05 06:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(525, 1, 27.030, NULL, 27.000, '2025-10-05 07:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(526, 2, 70.430, NULL, 70.000, '2025-10-05 07:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(527, 1, 26.450, NULL, 26.500, '2025-10-05 07:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(528, 2, 70.650, NULL, 71.000, '2025-10-05 07:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(529, 1, 26.680, NULL, 26.700, '2025-10-05 07:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(530, 2, 71.150, NULL, 71.000, '2025-10-05 07:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(531, 1, 28.130, NULL, 28.100, '2025-10-05 07:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(532, 2, 71.030, NULL, 71.000, '2025-10-05 07:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(533, 1, 28.780, NULL, 28.800, '2025-10-05 08:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(534, 2, 72.770, NULL, 73.000, '2025-10-05 08:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(535, 1, 29.320, NULL, 29.300, '2025-10-05 08:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(536, 2, 72.570, NULL, 73.000, '2025-10-05 08:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(537, 1, 28.060, NULL, 28.100, '2025-10-05 08:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(538, 2, 73.130, NULL, 73.000, '2025-10-05 08:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(539, 1, 27.980, NULL, 28.000, '2025-10-05 08:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(540, 2, 72.430, NULL, 72.000, '2025-10-05 08:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(541, 1, 28.390, NULL, 28.400, '2025-10-05 09:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(542, 2, 73.580, NULL, 74.000, '2025-10-05 09:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(543, 1, 29.360, NULL, 29.400, '2025-10-05 09:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(544, 2, 72.270, NULL, 72.000, '2025-10-05 09:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(545, 1, 28.600, NULL, 28.600, '2025-10-05 09:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(546, 2, 73.200, NULL, 73.000, '2025-10-05 09:30:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(547, 1, 30.110, NULL, 30.100, '2025-10-05 09:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(548, 2, 72.470, NULL, 72.000, '2025-10-05 09:45:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(549, 1, 29.570, NULL, 29.600, '2025-10-05 10:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(550, 2, 73.680, NULL, 74.000, '2025-10-05 10:00:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(551, 1, 30.000, NULL, 30.000, '2025-10-05 10:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(552, 2, 72.630, NULL, 73.000, '2025-10-05 10:15:48', '2025-10-04 23:30:48', '2025-10-04 23:30:48'),
(553, 1, 27.800, NULL, 27.800, '2025-10-04 22:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(554, 2, 72.400, NULL, 72.000, '2025-10-04 22:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(555, 1, 28.450, NULL, 28.500, '2025-10-04 22:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(556, 2, 72.970, NULL, 73.000, '2025-10-04 22:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(557, 1, 27.890, NULL, 27.900, '2025-10-04 23:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(558, 2, 71.980, NULL, 72.000, '2025-10-04 23:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(559, 1, 29.220, NULL, 29.200, '2025-10-04 23:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(560, 2, 73.530, NULL, 74.000, '2025-10-04 23:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(561, 1, 29.330, NULL, 29.300, '2025-10-04 23:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(562, 2, 73.320, NULL, 73.000, '2025-10-04 23:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(563, 1, 28.610, NULL, 28.600, '2025-10-04 23:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(564, 2, 72.970, NULL, 73.000, '2025-10-04 23:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(565, 1, 29.760, NULL, 29.800, '2025-10-05 00:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(566, 2, 71.160, NULL, 71.000, '2025-10-05 00:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(567, 1, 28.380, NULL, 28.400, '2025-10-05 00:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(568, 2, 72.620, NULL, 73.000, '2025-10-05 00:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(569, 1, 28.760, NULL, 28.800, '2025-10-05 00:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(570, 2, 71.440, NULL, 71.000, '2025-10-05 00:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(571, 1, 29.500, NULL, 29.500, '2025-10-05 00:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(572, 2, 71.740, NULL, 72.000, '2025-10-05 00:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(573, 1, 29.090, NULL, 29.100, '2025-10-05 01:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(574, 2, 70.230, NULL, 70.000, '2025-10-05 01:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(575, 1, 29.650, NULL, 29.700, '2025-10-05 01:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(576, 2, 69.100, NULL, 69.000, '2025-10-05 01:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(577, 1, 30.060, NULL, 30.100, '2025-10-05 01:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(578, 2, 69.170, NULL, 69.000, '2025-10-05 01:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(579, 1, 28.740, NULL, 28.700, '2025-10-05 01:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(580, 2, 68.250, NULL, 68.000, '2025-10-05 01:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(581, 1, 29.180, NULL, 29.200, '2025-10-05 02:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(582, 2, 69.750, NULL, 70.000, '2025-10-05 02:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(583, 1, 29.000, NULL, 29.000, '2025-10-05 02:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(584, 2, 68.380, NULL, 68.000, '2025-10-05 02:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(585, 1, 29.290, NULL, 29.300, '2025-10-05 02:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(586, 2, 68.230, NULL, 68.000, '2025-10-05 02:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(587, 1, 28.560, NULL, 28.600, '2025-10-05 02:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(588, 2, 66.830, NULL, 67.000, '2025-10-05 02:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(589, 1, 28.310, NULL, 28.300, '2025-10-05 03:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(590, 2, 67.270, NULL, 67.000, '2025-10-05 03:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(591, 1, 27.860, NULL, 27.900, '2025-10-05 03:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(592, 2, 67.670, NULL, 68.000, '2025-10-05 03:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(593, 1, 26.910, NULL, 26.900, '2025-10-05 03:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(594, 2, 66.620, NULL, 67.000, '2025-10-05 03:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(595, 1, 27.470, NULL, 27.500, '2025-10-05 03:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(596, 2, 67.430, NULL, 67.000, '2025-10-05 03:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(597, 1, 27.950, NULL, 28.000, '2025-10-05 04:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(598, 2, 66.700, NULL, 67.000, '2025-10-05 04:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(599, 1, 26.840, NULL, 26.800, '2025-10-05 04:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(600, 2, 66.430, NULL, 66.000, '2025-10-05 04:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(601, 1, 26.460, NULL, 26.500, '2025-10-05 04:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(602, 2, 66.420, NULL, 66.000, '2025-10-05 04:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(603, 1, 26.120, NULL, 26.100, '2025-10-05 04:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(604, 2, 67.470, NULL, 67.000, '2025-10-05 04:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(605, 1, 27.110, NULL, 27.100, '2025-10-05 05:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(606, 2, 66.680, NULL, 67.000, '2025-10-05 05:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(607, 1, 26.130, NULL, 26.100, '2025-10-05 05:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(608, 2, 68.040, NULL, 68.000, '2025-10-05 05:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(609, 1, 27.000, NULL, 27.000, '2025-10-05 05:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(610, 2, 67.140, NULL, 67.000, '2025-10-05 05:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(611, 1, 26.710, NULL, 26.700, '2025-10-05 05:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(612, 2, 68.680, NULL, 69.000, '2025-10-05 05:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(613, 1, 26.260, NULL, 26.300, '2025-10-05 06:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(614, 2, 68.460, NULL, 68.000, '2025-10-05 06:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(615, 1, 25.950, NULL, 26.000, '2025-10-05 06:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(616, 2, 69.860, NULL, 70.000, '2025-10-05 06:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(617, 1, 27.380, NULL, 27.400, '2025-10-05 06:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(618, 2, 70.580, NULL, 71.000, '2025-10-05 06:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(619, 1, 26.040, NULL, 26.000, '2025-10-05 06:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(620, 2, 71.010, NULL, 71.000, '2025-10-05 06:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(621, 1, 27.930, NULL, 27.900, '2025-10-05 07:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(622, 2, 71.230, NULL, 71.000, '2025-10-05 07:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(623, 1, 27.850, NULL, 27.900, '2025-10-05 07:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(624, 2, 71.350, NULL, 71.000, '2025-10-05 07:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(625, 1, 26.880, NULL, 26.900, '2025-10-05 07:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(626, 2, 71.850, NULL, 72.000, '2025-10-05 07:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(627, 1, 27.430, NULL, 27.400, '2025-10-05 07:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(628, 2, 70.830, NULL, 71.000, '2025-10-05 07:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(629, 1, 27.780, NULL, 27.800, '2025-10-05 08:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(630, 2, 72.470, NULL, 72.000, '2025-10-05 08:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(631, 1, 29.220, NULL, 29.200, '2025-10-05 08:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(632, 2, 73.170, NULL, 73.000, '2025-10-05 08:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(633, 1, 28.460, NULL, 28.500, '2025-10-05 08:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(634, 2, 72.630, NULL, 73.000, '2025-10-05 08:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(635, 1, 29.480, NULL, 29.500, '2025-10-05 08:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(636, 2, 73.730, NULL, 74.000, '2025-10-05 08:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(637, 1, 29.990, NULL, 30.000, '2025-10-05 09:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(638, 2, 72.180, NULL, 72.000, '2025-10-05 09:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(639, 1, 30.060, NULL, 30.100, '2025-10-05 09:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(640, 2, 73.170, NULL, 73.000, '2025-10-05 09:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(641, 1, 29.100, NULL, 29.100, '2025-10-05 09:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(642, 2, 72.700, NULL, 73.000, '2025-10-05 09:30:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(643, 1, 30.210, NULL, 30.200, '2025-10-05 09:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(644, 2, 73.670, NULL, 74.000, '2025-10-05 09:45:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(645, 1, 28.870, NULL, 28.900, '2025-10-05 10:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(646, 2, 73.280, NULL, 73.000, '2025-10-05 10:00:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(647, 1, 28.700, NULL, 28.700, '2025-10-05 10:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(648, 2, 73.030, NULL, 73.000, '2025-10-05 10:15:56', '2025-10-04 23:30:56', '2025-10-04 23:30:56'),
(649, 3, 1.003, NULL, 1.000, '2025-10-04 11:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(650, 5, 4.099, NULL, 4.099, '2025-10-04 11:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(651, 3, 1.003, NULL, 1.000, '2025-10-04 12:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(652, 5, 4.100, NULL, 4.100, '2025-10-04 12:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(653, 3, 1.008, NULL, 1.010, '2025-10-04 12:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(654, 5, 4.101, NULL, 4.101, '2025-10-04 12:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(655, 3, 1.012, NULL, 1.010, '2025-10-04 12:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(656, 5, 4.099, NULL, 4.099, '2025-10-04 12:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(657, 3, 1.013, NULL, 1.010, '2025-10-04 12:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(658, 5, 4.098, NULL, 4.098, '2025-10-04 12:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(659, 3, 1.016, NULL, 1.020, '2025-10-04 12:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(660, 5, 4.097, NULL, 4.097, '2025-10-04 12:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(661, 3, 1.021, NULL, 1.020, '2025-10-04 12:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(662, 5, 4.097, NULL, 4.097, '2025-10-04 12:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(663, 3, 1.020, NULL, 1.020, '2025-10-04 13:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(664, 5, 4.098, NULL, 4.098, '2025-10-04 13:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(665, 3, 1.021, NULL, 1.020, '2025-10-04 13:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(666, 5, 4.096, NULL, 4.096, '2025-10-04 13:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(667, 3, 1.026, NULL, 1.030, '2025-10-04 13:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(668, 5, 4.095, NULL, 4.095, '2025-10-04 13:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(669, 3, 1.024, NULL, 1.020, '2025-10-04 13:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(670, 5, 4.093, NULL, 4.093, '2025-10-04 13:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(671, 3, 1.027, NULL, 1.030, '2025-10-04 13:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(672, 5, 4.093, NULL, 4.093, '2025-10-04 13:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(673, 3, 1.028, NULL, 1.030, '2025-10-04 13:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(674, 5, 4.092, NULL, 4.092, '2025-10-04 13:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(675, 3, 1.025, NULL, 1.030, '2025-10-04 14:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(676, 5, 4.093, NULL, 4.093, '2025-10-04 14:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(677, 3, 1.028, NULL, 1.030, '2025-10-04 14:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(678, 5, 4.094, NULL, 4.094, '2025-10-04 14:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(679, 3, 1.028, NULL, 1.030, '2025-10-04 14:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(680, 5, 4.095, NULL, 4.095, '2025-10-04 14:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(681, 3, 1.033, NULL, 1.030, '2025-10-04 14:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(682, 5, 4.094, NULL, 4.094, '2025-10-04 14:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(683, 3, 1.034, NULL, 1.030, '2025-10-04 14:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(684, 5, 4.092, NULL, 4.092, '2025-10-04 14:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(685, 3, 1.038, NULL, 1.040, '2025-10-04 14:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(686, 5, 4.092, NULL, 4.092, '2025-10-04 14:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(687, 3, 1.039, NULL, 1.040, '2025-10-04 15:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(688, 5, 4.090, NULL, 4.090, '2025-10-04 15:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(689, 3, 1.041, NULL, 1.040, '2025-10-04 15:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(690, 5, 4.091, NULL, 4.091, '2025-10-04 15:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(691, 3, 1.038, NULL, 1.040, '2025-10-04 15:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(692, 5, 4.090, NULL, 4.090, '2025-10-04 15:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(693, 3, 1.036, NULL, 1.040, '2025-10-04 15:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(694, 5, 4.090, NULL, 4.090, '2025-10-04 15:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(695, 3, 1.033, NULL, 1.030, '2025-10-04 15:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(696, 5, 4.089, NULL, 4.089, '2025-10-04 15:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(697, 3, 1.030, NULL, 1.030, '2025-10-04 15:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(698, 5, 4.090, NULL, 4.090, '2025-10-04 15:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(699, 3, 1.030, NULL, 1.030, '2025-10-04 16:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(700, 5, 4.088, NULL, 4.088, '2025-10-04 16:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(701, 3, 1.026, NULL, 1.030, '2025-10-04 16:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(702, 5, 4.087, NULL, 4.087, '2025-10-04 16:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(703, 3, 1.027, NULL, 1.030, '2025-10-04 16:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(704, 5, 4.086, NULL, 4.086, '2025-10-04 16:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(705, 3, 1.027, NULL, 1.030, '2025-10-04 16:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(706, 5, 4.084, NULL, 4.084, '2025-10-04 16:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(707, 3, 1.032, NULL, 1.030, '2025-10-04 16:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(708, 5, 4.085, NULL, 4.085, '2025-10-04 16:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(709, 3, 1.030, NULL, 1.030, '2025-10-04 16:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(710, 5, 4.085, NULL, 4.085, '2025-10-04 16:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(711, 3, 1.028, NULL, 1.030, '2025-10-04 17:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(712, 5, 4.083, NULL, 4.083, '2025-10-04 17:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(713, 3, 1.033, NULL, 1.030, '2025-10-04 17:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(714, 5, 4.084, NULL, 4.084, '2025-10-04 17:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(715, 3, 1.037, NULL, 1.040, '2025-10-04 17:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(716, 5, 4.082, NULL, 4.082, '2025-10-04 17:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(717, 3, 1.035, NULL, 1.040, '2025-10-04 17:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(718, 5, 4.083, NULL, 4.083, '2025-10-04 17:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(719, 3, 1.039, NULL, 1.040, '2025-10-04 17:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(720, 5, 4.084, NULL, 4.084, '2025-10-04 17:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(721, 3, 1.044, NULL, 1.040, '2025-10-04 17:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(722, 5, 4.082, NULL, 4.082, '2025-10-04 17:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(723, 3, 1.048, NULL, 1.050, '2025-10-04 18:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(724, 5, 4.083, NULL, 4.083, '2025-10-04 18:00:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(725, 3, 1.049, NULL, 1.050, '2025-10-04 18:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(726, 5, 4.083, NULL, 4.083, '2025-10-04 18:10:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(727, 3, 1.053, NULL, 1.050, '2025-10-04 18:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(728, 5, 4.081, NULL, 4.081, '2025-10-04 18:20:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(729, 3, 1.056, NULL, 1.060, '2025-10-04 18:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(730, 5, 4.079, NULL, 4.079, '2025-10-04 18:30:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(731, 3, 1.056, NULL, 1.060, '2025-10-04 18:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(732, 5, 4.080, NULL, 4.080, '2025-10-04 18:40:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(733, 3, 1.058, NULL, 1.060, '2025-10-04 18:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(734, 5, 4.078, NULL, 4.078, '2025-10-04 18:50:00', '2025-10-05 00:50:47', '2025-10-05 00:50:47'),
(735, 3, 1.062, NULL, 1.060, '2025-10-04 19:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(736, 5, 4.077, NULL, 4.077, '2025-10-04 19:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(737, 3, 1.058, NULL, 1.060, '2025-10-04 19:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(738, 5, 4.078, NULL, 4.078, '2025-10-04 19:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(739, 3, 1.057, NULL, 1.060, '2025-10-04 19:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(740, 5, 4.079, NULL, 4.079, '2025-10-04 19:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(741, 3, 1.056, NULL, 1.060, '2025-10-04 19:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(742, 5, 4.078, NULL, 4.078, '2025-10-04 19:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(743, 3, 1.055, NULL, 1.060, '2025-10-04 19:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(744, 5, 4.079, NULL, 4.079, '2025-10-04 19:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(745, 3, 1.057, NULL, 1.060, '2025-10-04 19:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(746, 5, 4.079, NULL, 4.079, '2025-10-04 19:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(747, 3, 1.055, NULL, 1.060, '2025-10-04 20:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(748, 5, 4.077, NULL, 4.077, '2025-10-04 20:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(749, 3, 1.056, NULL, 1.060, '2025-10-04 20:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(750, 5, 4.077, NULL, 4.077, '2025-10-04 20:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(751, 3, 1.052, NULL, 1.050, '2025-10-04 20:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(752, 5, 4.076, NULL, 4.076, '2025-10-04 20:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(753, 3, 1.051, NULL, 1.050, '2025-10-04 20:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(754, 5, 4.075, NULL, 4.075, '2025-10-04 20:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(755, 3, 1.051, NULL, 1.050, '2025-10-04 20:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(756, 5, 4.073, NULL, 4.073, '2025-10-04 20:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(757, 3, 1.052, NULL, 1.050, '2025-10-04 20:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(758, 5, 4.074, NULL, 4.074, '2025-10-04 20:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(759, 3, 1.055, NULL, 1.060, '2025-10-04 21:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(760, 5, 4.073, NULL, 4.073, '2025-10-04 21:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(761, 3, 1.053, NULL, 1.050, '2025-10-04 21:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(762, 5, 4.072, NULL, 4.072, '2025-10-04 21:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(763, 3, 1.049, NULL, 1.050, '2025-10-04 21:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(764, 5, 4.071, NULL, 4.071, '2025-10-04 21:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(765, 3, 1.054, NULL, 1.050, '2025-10-04 21:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(766, 5, 4.070, NULL, 4.070, '2025-10-04 21:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(767, 3, 1.054, NULL, 1.050, '2025-10-04 21:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(768, 5, 4.070, NULL, 4.070, '2025-10-04 21:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(769, 3, 1.050, NULL, 1.050, '2025-10-04 21:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(770, 5, 4.071, NULL, 4.071, '2025-10-04 21:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(771, 3, 1.050, NULL, 1.050, '2025-10-04 22:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(772, 5, 4.072, NULL, 4.072, '2025-10-04 22:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(773, 3, 1.055, NULL, 1.060, '2025-10-04 22:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(774, 5, 4.071, NULL, 4.071, '2025-10-04 22:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(775, 3, 1.058, NULL, 1.060, '2025-10-04 22:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(776, 5, 4.071, NULL, 4.071, '2025-10-04 22:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(777, 3, 1.053, NULL, 1.050, '2025-10-04 22:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(778, 5, 4.070, NULL, 4.070, '2025-10-04 22:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(779, 3, 1.058, NULL, 1.060, '2025-10-04 22:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(780, 5, 4.069, NULL, 4.069, '2025-10-04 22:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(781, 3, 1.059, NULL, 1.060, '2025-10-04 22:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(782, 5, 4.068, NULL, 4.068, '2025-10-04 22:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(783, 3, 1.054, NULL, 1.050, '2025-10-04 23:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(784, 5, 4.067, NULL, 4.067, '2025-10-04 23:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(785, 3, 1.050, NULL, 1.050, '2025-10-04 23:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(786, 5, 4.068, NULL, 4.068, '2025-10-04 23:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(787, 3, 1.049, NULL, 1.050, '2025-10-04 23:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(788, 5, 4.066, NULL, 4.066, '2025-10-04 23:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(789, 3, 1.049, NULL, 1.050, '2025-10-04 23:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(790, 5, 4.065, NULL, 4.065, '2025-10-04 23:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(791, 3, 1.047, NULL, 1.050, '2025-10-04 23:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(792, 5, 4.065, NULL, 4.065, '2025-10-04 23:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(793, 3, 1.050, NULL, 1.050, '2025-10-04 23:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(794, 5, 4.066, NULL, 4.066, '2025-10-04 23:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(795, 3, 1.049, NULL, 1.050, '2025-10-05 00:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(796, 5, 4.066, NULL, 4.066, '2025-10-05 00:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(797, 3, 1.048, NULL, 1.050, '2025-10-05 00:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(798, 5, 4.064, NULL, 4.064, '2025-10-05 00:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(799, 3, 1.051, NULL, 1.050, '2025-10-05 00:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(800, 5, 4.065, NULL, 4.065, '2025-10-05 00:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(801, 3, 1.055, NULL, 1.060, '2025-10-05 00:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(802, 5, 4.065, NULL, 4.065, '2025-10-05 00:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(803, 3, 1.051, NULL, 1.050, '2025-10-05 00:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(804, 5, 4.066, NULL, 4.066, '2025-10-05 00:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(805, 3, 1.056, NULL, 1.060, '2025-10-05 00:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(806, 5, 4.065, NULL, 4.065, '2025-10-05 00:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(807, 3, 1.059, NULL, 1.060, '2025-10-05 01:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(808, 5, 4.063, NULL, 4.063, '2025-10-05 01:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(809, 3, 1.054, NULL, 1.050, '2025-10-05 01:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(810, 5, 4.062, NULL, 4.062, '2025-10-05 01:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(811, 3, 1.056, NULL, 1.060, '2025-10-05 01:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(812, 5, 4.062, NULL, 4.062, '2025-10-05 01:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(813, 3, 1.054, NULL, 1.050, '2025-10-05 01:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(814, 5, 4.063, NULL, 4.063, '2025-10-05 01:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(815, 3, 1.059, NULL, 1.060, '2025-10-05 01:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(816, 5, 4.064, NULL, 4.064, '2025-10-05 01:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(817, 3, 1.062, NULL, 1.060, '2025-10-05 01:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(818, 5, 4.065, NULL, 4.065, '2025-10-05 01:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(819, 3, 1.067, NULL, 1.070, '2025-10-05 02:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(820, 5, 4.063, NULL, 4.063, '2025-10-05 02:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(821, 3, 1.065, NULL, 1.070, '2025-10-05 02:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(822, 5, 4.064, NULL, 4.064, '2025-10-05 02:10:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(823, 3, 1.065, NULL, 1.070, '2025-10-05 02:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(824, 5, 4.065, NULL, 4.065, '2025-10-05 02:20:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(825, 3, 1.062, NULL, 1.060, '2025-10-05 02:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(826, 5, 4.066, NULL, 4.066, '2025-10-05 02:30:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(827, 3, 1.067, NULL, 1.070, '2025-10-05 02:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(828, 5, 4.065, NULL, 4.065, '2025-10-05 02:40:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(829, 3, 1.064, NULL, 1.060, '2025-10-05 02:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(830, 5, 4.064, NULL, 4.064, '2025-10-05 02:50:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(831, 3, 1.064, NULL, 1.060, '2025-10-05 03:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(832, 5, 4.062, NULL, 4.062, '2025-10-05 03:00:00', '2025-10-05 00:50:48', '2025-10-05 00:50:48'),
(833, 3, 1.069, NULL, 1.070, '2025-10-05 03:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(834, 5, 4.062, NULL, 4.062, '2025-10-05 03:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(835, 3, 1.069, NULL, 1.070, '2025-10-05 03:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(836, 5, 4.060, NULL, 4.060, '2025-10-05 03:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(837, 3, 1.071, NULL, 1.070, '2025-10-05 03:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(838, 5, 4.060, NULL, 4.060, '2025-10-05 03:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(839, 3, 1.073, NULL, 1.070, '2025-10-05 03:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(840, 5, 4.059, NULL, 4.059, '2025-10-05 03:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(841, 3, 1.072, NULL, 1.070, '2025-10-05 03:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(842, 5, 4.060, NULL, 4.060, '2025-10-05 03:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(843, 3, 1.070, NULL, 1.070, '2025-10-05 04:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(844, 5, 4.060, NULL, 4.060, '2025-10-05 04:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(845, 3, 1.072, NULL, 1.070, '2025-10-05 04:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(846, 5, 4.060, NULL, 4.060, '2025-10-05 04:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(847, 3, 1.073, NULL, 1.070, '2025-10-05 04:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(848, 5, 4.058, NULL, 4.058, '2025-10-05 04:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(849, 3, 1.073, NULL, 1.070, '2025-10-05 04:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(850, 5, 4.057, NULL, 4.057, '2025-10-05 04:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(851, 3, 1.073, NULL, 1.070, '2025-10-05 04:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(852, 5, 4.055, NULL, 4.055, '2025-10-05 04:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(853, 3, 1.075, NULL, 1.080, '2025-10-05 04:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(854, 5, 4.054, NULL, 4.054, '2025-10-05 04:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(855, 3, 1.073, NULL, 1.070, '2025-10-05 05:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(856, 5, 4.054, NULL, 4.054, '2025-10-05 05:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(857, 3, 1.070, NULL, 1.070, '2025-10-05 05:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(858, 5, 4.052, NULL, 4.052, '2025-10-05 05:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(859, 3, 1.070, NULL, 1.070, '2025-10-05 05:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(860, 5, 4.051, NULL, 4.051, '2025-10-05 05:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(861, 3, 1.070, NULL, 1.070, '2025-10-05 05:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(862, 5, 4.051, NULL, 4.051, '2025-10-05 05:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(863, 3, 1.075, NULL, 1.080, '2025-10-05 05:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(864, 5, 4.050, NULL, 4.050, '2025-10-05 05:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(865, 3, 1.077, NULL, 1.080, '2025-10-05 05:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(866, 5, 4.050, NULL, 4.050, '2025-10-05 05:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(867, 3, 1.079, NULL, 1.080, '2025-10-05 06:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(868, 5, 4.050, NULL, 4.050, '2025-10-05 06:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(869, 3, 1.084, NULL, 1.080, '2025-10-05 06:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(870, 5, 4.051, NULL, 4.051, '2025-10-05 06:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(871, 3, 1.087, NULL, 1.090, '2025-10-05 06:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(872, 5, 4.049, NULL, 4.049, '2025-10-05 06:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(873, 3, 1.083, NULL, 1.080, '2025-10-05 06:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(874, 5, 4.049, NULL, 4.049, '2025-10-05 06:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(875, 3, 1.080, NULL, 1.080, '2025-10-05 06:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(876, 5, 4.047, NULL, 4.047, '2025-10-05 06:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(877, 3, 1.081, NULL, 1.080, '2025-10-05 06:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(878, 5, 4.047, NULL, 4.047, '2025-10-05 06:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(879, 3, 1.081, NULL, 1.080, '2025-10-05 07:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(880, 5, 4.046, NULL, 4.046, '2025-10-05 07:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(881, 3, 1.084, NULL, 1.080, '2025-10-05 07:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(882, 5, 4.045, NULL, 4.045, '2025-10-05 07:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(883, 3, 1.085, NULL, 1.090, '2025-10-05 07:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(884, 5, 4.043, NULL, 4.043, '2025-10-05 07:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(885, 3, 1.083, NULL, 1.080, '2025-10-05 07:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(886, 5, 4.042, NULL, 4.042, '2025-10-05 07:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(887, 3, 1.083, NULL, 1.080, '2025-10-05 07:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(888, 5, 4.043, NULL, 4.043, '2025-10-05 07:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(889, 3, 1.081, NULL, 1.080, '2025-10-05 07:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(890, 5, 4.043, NULL, 4.043, '2025-10-05 07:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(891, 3, 1.079, NULL, 1.080, '2025-10-05 08:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(892, 5, 4.041, NULL, 4.041, '2025-10-05 08:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(893, 3, 1.083, NULL, 1.080, '2025-10-05 08:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(894, 5, 4.041, NULL, 4.041, '2025-10-05 08:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(895, 3, 1.081, NULL, 1.080, '2025-10-05 08:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(896, 5, 4.041, NULL, 4.041, '2025-10-05 08:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(897, 3, 1.079, NULL, 1.080, '2025-10-05 08:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(898, 5, 4.041, NULL, 4.041, '2025-10-05 08:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(899, 3, 1.074, NULL, 1.070, '2025-10-05 08:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(900, 5, 4.039, NULL, 4.039, '2025-10-05 08:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(901, 3, 1.072, NULL, 1.070, '2025-10-05 08:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(902, 5, 4.037, NULL, 4.037, '2025-10-05 08:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(903, 3, 1.069, NULL, 1.070, '2025-10-05 09:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(904, 5, 4.035, NULL, 4.035, '2025-10-05 09:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(905, 3, 1.072, NULL, 1.070, '2025-10-05 09:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(906, 5, 4.035, NULL, 4.035, '2025-10-05 09:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(907, 3, 1.075, NULL, 1.080, '2025-10-05 09:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(908, 5, 4.035, NULL, 4.035, '2025-10-05 09:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(909, 3, 1.077, NULL, 1.080, '2025-10-05 09:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(910, 5, 4.035, NULL, 4.035, '2025-10-05 09:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(911, 3, 1.081, NULL, 1.080, '2025-10-05 09:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(912, 5, 4.034, NULL, 4.034, '2025-10-05 09:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(913, 3, 1.080, NULL, 1.080, '2025-10-05 09:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(914, 5, 4.035, NULL, 4.035, '2025-10-05 09:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(915, 3, 1.083, NULL, 1.080, '2025-10-05 10:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(916, 5, 4.033, NULL, 4.033, '2025-10-05 10:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(917, 3, 1.083, NULL, 1.080, '2025-10-05 10:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(918, 5, 4.032, NULL, 4.032, '2025-10-05 10:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(919, 3, 1.080, NULL, 1.080, '2025-10-05 10:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(920, 5, 4.033, NULL, 4.033, '2025-10-05 10:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(921, 3, 1.085, NULL, 1.090, '2025-10-05 10:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(922, 5, 4.031, NULL, 4.031, '2025-10-05 10:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(923, 3, 1.086, NULL, 1.090, '2025-10-05 10:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(924, 5, 4.029, NULL, 4.029, '2025-10-05 10:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(925, 3, 1.084, NULL, 1.080, '2025-10-05 10:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(926, 5, 4.029, NULL, 4.029, '2025-10-05 10:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(927, 3, 1.088, NULL, 1.090, '2025-10-05 11:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(928, 5, 4.029, NULL, 4.029, '2025-10-05 11:00:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(929, 3, 1.091, NULL, 1.090, '2025-10-05 11:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(930, 5, 4.030, NULL, 4.030, '2025-10-05 11:10:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(931, 3, 1.095, NULL, 1.100, '2025-10-05 11:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(932, 5, 4.028, NULL, 4.028, '2025-10-05 11:20:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(933, 3, 1.093, NULL, 1.090, '2025-10-05 11:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(934, 5, 4.027, NULL, 4.027, '2025-10-05 11:30:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(935, 3, 1.090, NULL, 1.090, '2025-10-05 11:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(936, 5, 4.028, NULL, 4.028, '2025-10-05 11:40:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(937, 3, 1.089, NULL, 1.090, '2025-10-05 11:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(938, 5, 4.027, NULL, 4.027, '2025-10-05 11:50:00', '2025-10-05 00:50:49', '2025-10-05 00:50:49'),
(939, 1, NULL, NULL, 28.500, '2025-10-08 00:03:17', '2025-10-07 13:14:25', '2025-10-07 13:14:25'),
(940, 2, NULL, NULL, 68.000, '2025-10-08 00:03:17', '2025-10-07 13:14:25', '2025-10-07 13:14:25');

--
-- Déclencheurs `mesures`
--
DELIMITER $$
CREATE TRIGGER `mesures_round_bi` BEFORE INSERT ON `mesures` FOR EACH ROW BEGIN
  DECLARE t VARCHAR(50);
  SELECT type INTO t FROM capteurs WHERE id = NEW.capteur_id;
  SET NEW.valeur = CASE
    WHEN t = 'temperature' THEN ROUND(NEW.valeur, 1)
    WHEN t = 'humidity'    THEN ROUND(NEW.valeur, 0)
    WHEN t = 'weight'      THEN ROUND(NEW.valeur, 2)
    ELSE NEW.valeur
  END;
END
$$
DELIMITER ;
DELIMITER $$
CREATE TRIGGER `mesures_round_bu` BEFORE UPDATE ON `mesures` FOR EACH ROW BEGIN
  DECLARE t VARCHAR(50);
  SELECT type INTO t FROM capteurs WHERE id = NEW.capteur_id;
  SET NEW.valeur = CASE
    WHEN t = 'temperature' THEN ROUND(NEW.valeur, 1)
    WHEN t = 'humidity'    THEN ROUND(NEW.valeur, 0)
    WHEN t = 'weight'      THEN ROUND(NEW.valeur, 2)
    ELSE NEW.valeur
  END;
END
$$
DELIMITER ;

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

--
-- Structure de la table `migrations`
--

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_09_21_100000_create_apiculteurs_table', 1),
(5, '2025_09_21_100100_create_ruchers_table', 1),
(6, '2025_09_21_100200_create_ruches_table', 1),
(7, '2025_09_21_100300_create_capteurs_table', 1),
(8, '2025_09_21_100400_create_mesures_table', 1),
(9, '2025_09_21_100500_create_alert_settings_table', 1),
(10, '2025_09_21_110000_add_user_id_to_apiculteurs_table', 1),
(11, '2025_09_21_110100_add_prenom_to_apiculteurs_table', 1),
(12, '2025_09_21_110200_add_etat_commentaire_to_ruches_table', 1),
(13, '2025_09_21_121500_add_unique_index_on_mesures_capteur_measured_at', 1),
(14, '2025_10_05_062018_create_permission_tables', 2),
(15, '2025_10_05_070217_create_v_last_mesure_by_capteur_view', 3),
(16, '2025_10_05_070245_update_users_add_role_and_apiculteur_id', 3),
(17, '2025_10_05_072027_update_mesures_add_value_numeric_column', 4),
(18, '2025_10_05_072236_add_value_numeric_to_mesures_table', 5),
(19, '2025_10_05_073153_add_value_raw_to_mesures_table', 6),
(20, '2025_10_05_000000_create_alerts_tables', 7),
(21, '2025_10_05_000001_fix_alert_settings_unique', 8);

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

--
-- Structure de la table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `ruchers`
--

CREATE TABLE `ruchers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `apiculteur_id` bigint(20) UNSIGNED DEFAULT NULL,
  `nom` varchar(150) NOT NULL,
  `localisation` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ruchers` (`id`, `apiculteur_id`, `nom`, `localisation`, `description`, `created_at`, `updated_at`) VALUES
(1, 1, 'Rucher Nord', 'GPS: -22.27, 166.44', 'Jeu de test', '2025-09-30 21:23:01', '2025-09-30 21:23:01'),
(2, NULL, 'Rucher Demo', 'Nouméa', NULL, '2025-10-04 20:19:00', '2025-10-04 20:19:00');

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

--
-- Structure de la table `ruches`
--

CREATE TABLE `ruches` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `rucher_id` bigint(20) UNSIGNED NOT NULL,
  `reference` varchar(255) NOT NULL,
  `etat` varchar(30) NOT NULL DEFAULT 'active',
  `commentaire` text DEFAULT NULL,
  `modele` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `ruches` (`id`, `rucher_id`, `reference`, `etat`, `commentaire`, `modele`, `created_at`, `updated_at`) VALUES
(1, 1, 'ruche-001', 'active', 'Demo TTN', NULL, '2025-09-30 21:23:01', '2025-09-30 21:23:01');

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

--
-- Doublure de structure pour la vue `v_last_mesure_by_capteur`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `v_last_mesure_by_capteur` (
`id` bigint(20) unsigned
,`capteur_id` bigint(20) unsigned
,`valeur` decimal(8,3)
,`measured_at` datetime
,`created_at` timestamp
,`updated_at` timestamp
);

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

--
-- Doublure de structure pour la vue `v_mesures_arrondies`
-- (Voir ci-dessous la vue réelle)
--
CREATE TABLE `v_mesures_arrondies` (
`id` bigint(20) unsigned
,`capteur_id` bigint(20) unsigned
,`measured_at` datetime
,`valeur` decimal(9,3)
);

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

--
-- Structure de la vue `v_last_mesure_by_capteur`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`127.0.0.1` SQL SECURITY DEFINER VIEW `v_last_mesure_by_capteur`  AS SELECT `m1`.`id` AS `id`, `m1`.`capteur_id` AS `capteur_id`, `m1`.`valeur` AS `valeur`, `m1`.`measured_at` AS `measured_at`, `m1`.`created_at` AS `created_at`, `m1`.`updated_at` AS `updated_at` FROM (`mesures` `m1` join (select `mesures`.`capteur_id` AS `capteur_id`,max(`mesures`.`measured_at`) AS `max_measured_at` from `mesures` group by `mesures`.`capteur_id`) `last` on(`last`.`capteur_id` = `m1`.`capteur_id` and `last`.`max_measured_at` = `m1`.`measured_at`)) ;

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

--
-- Structure de la vue `v_mesures_arrondies`
--

CREATE ALGORITHM=MERGE DEFINER=`root`@`localhost` SQL SECURITY INVOKER VIEW `v_mesures_arrondies`  AS SELECT `m`.`id` AS `id`, `m`.`capteur_id` AS `capteur_id`, `m`.`measured_at` AS `measured_at`, CASE `c`.`type` WHEN 'temperature' THEN round(`m`.`valeur`,1) WHEN 'humidity' THEN round(`m`.`valeur`,0) WHEN 'weight' THEN round(`m`.`valeur`,2) ELSE `m`.`valeur` END AS `valeur` FROM (`mesures` `m` join `capteurs` `c` on(`c`.`id` = `m`.`capteur_id`)) ;

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

--
-- Index pour la table `alerts`
--
ALTER TABLE `alerts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `alerts_ruche_id_foreign` (`ruche_id`);

--
-- Index pour la table `alert_settings`
--
ALTER TABLE `alert_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `alert_settings_ruche_type_unique` (`ruche_id`,`type`),
  ADD KEY `alert_settings_ruche_id_index` (`ruche_id`);

--
-- Index pour la table `apiculteurs`
--
ALTER TABLE `apiculteurs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `apiculteurs_email_unique` (`email`),
  ADD KEY `apiculteurs_user_id_foreign` (`user_id`);

--
-- Index pour la table `capteurs`
--
ALTER TABLE `capteurs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `capteurs_ruche_id_type_unique` (`ruche_id`,`type`);

--
-- Index pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Index pour la table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

--
-- Index pour la table `mesures`
--
ALTER TABLE `mesures`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mesures_capteur_measured_unique` (`capteur_id`,`measured_at`);

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

--
-- Index pour la table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Index pour la table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

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

--
-- Index pour la table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Index pour la table `ruchers`
--
ALTER TABLE `ruchers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ruchers_apiculteur_id_foreign` (`apiculteur_id`);

--
-- Index pour la table `ruches`
--
ALTER TABLE `ruches`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ruches_reference_unique` (`reference`),
  ADD KEY `ruches_rucher_id_index` (`rucher_id`);

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

--
-- AUTO_INCREMENT pour la table `alerts`
--
ALTER TABLE `alerts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `alert_settings`
--
ALTER TABLE `alert_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `apiculteurs`
--
ALTER TABLE `apiculteurs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `capteurs`
--
ALTER TABLE `capteurs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT pour la table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `mesures`
--
ALTER TABLE `mesures`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=941;

--
-- AUTO_INCREMENT pour la table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT pour la table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `ruchers`
--
ALTER TABLE `ruchers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT pour la table `ruches`
--
ALTER TABLE `ruches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- Contraintes pour la table `alerts`
--
ALTER TABLE `alerts`
  ADD CONSTRAINT `alerts_ruche_id_foreign` FOREIGN KEY (`ruche_id`) REFERENCES `ruches` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `alert_settings`
--
ALTER TABLE `alert_settings`
  ADD CONSTRAINT `alert_settings_ruche_id_foreign` FOREIGN KEY (`ruche_id`) REFERENCES `ruches` (`id`) ON DELETE CASCADE;

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

--
-- Contraintes pour la table `capteurs`
--
ALTER TABLE `capteurs`
  ADD CONSTRAINT `capteurs_ruche_id_foreign` FOREIGN KEY (`ruche_id`) REFERENCES `ruches` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `mesures`
--
ALTER TABLE `mesures`
  ADD CONSTRAINT `mesures_capteur_id_foreign` FOREIGN KEY (`capteur_id`) REFERENCES `capteurs` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ruchers`
--
ALTER TABLE `ruchers`
  ADD CONSTRAINT `ruchers_apiculteur_id_foreign` FOREIGN KEY (`apiculteur_id`) REFERENCES `apiculteurs` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ruches`
--
ALTER TABLE `ruches`
  ADD CONSTRAINT `ruches_rucher_id_foreign` FOREIGN KEY (`rucher_id`) REFERENCES `ruchers` (`id`) ON DELETE CASCADE;
COMMIT;

