(4169995,60,'2026-04-24',5,NULL,NULL,NULL,NULL,55.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-24 09:01:51','2026-05-20 14:01:46'),
(4169996,60,'2026-04-24',10,NULL,NULL,NULL,NULL,55.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-24 09:01:51','2026-05-20 14:01:46'),
(4260633,6,'2026-04-27',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:12','2026-05-20 14:15:12'),
(4260634,6,'2026-04-27',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:12','2026-05-20 14:15:12'),
(4260635,6,'2026-04-27',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:12','2026-05-20 14:15:12'),
(4260897,8,'2026-04-27',1,NULL,NULL,NULL,NULL,90.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:15','2026-05-20 14:15:16'),
(4260898,8,'2026-04-27',5,NULL,NULL,NULL,NULL,90.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:15','2026-05-20 14:15:16'),
(4260899,8,'2026-04-27',10,NULL,NULL,NULL,NULL,90.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:15','2026-05-20 14:15:16'),
(4261071,9,'2026-04-27',1,0,NULL,0,NULL,110.8,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:17','2026-05-20 14:15:18'),
(4261072,9,'2026-04-27',5,0,NULL,0,NULL,110.8,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:17','2026-05-20 14:15:18'),
(4261073,9,'2026-04-27',10,0,NULL,0,NULL,110.8,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:17','2026-05-20 14:15:18'),
(4261230,10,'2026-04-27',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:19','2026-05-20 14:15:19'),
(4261231,10,'2026-04-27',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:19','2026-05-20 14:15:19'),
(4261232,10,'2026-04-27',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:19','2026-05-20 14:15:19'),
(4261620,14,'2026-04-27',1,0,NULL,0,NULL,171.6,35.2,0,NULL,0,NULL,1,'positif','2026-04-27 09:00:28','2026-05-20 14:15:28'),
(4261621,14,'2026-04-27',5,0,NULL,0,NULL,171.6,35.2,0,NULL,0,NULL,1,'positif','2026-04-27 09:00:28','2026-05-20 14:15:28'),
(4261622,14,'2026-04-27',10,0,NULL,0,NULL,171.6,35.2,0,NULL,0,NULL,1,'positif','2026-04-27 09:00:28','2026-05-20 14:15:28'),
(4261800,15,'2026-04-27',1,NULL,NULL,NULL,NULL,484.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:30','2026-05-20 14:15:30'),
(4261801,15,'2026-04-27',5,NULL,NULL,NULL,NULL,484.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:30','2026-05-20 14:15:30'),
(4261802,15,'2026-04-27',10,NULL,NULL,NULL,NULL,484.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:30','2026-05-20 14:15:30'),
(4261968,16,'2026-04-27',1,NULL,NULL,NULL,NULL,79,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:33','2026-05-20 14:15:31'),
(4261969,16,'2026-04-27',5,NULL,NULL,NULL,NULL,79,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:33','2026-05-20 14:15:31'),
(4261970,16,'2026-04-27',10,NULL,NULL,NULL,NULL,79,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:33','2026-05-20 14:15:31'),
(4262199,17,'2026-04-27',1,NULL,NULL,NULL,NULL,55.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:35','2026-05-20 14:15:33'),
(4262200,17,'2026-04-27',5,NULL,NULL,NULL,NULL,55.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:35','2026-05-20 14:15:33'),
(4262201,17,'2026-04-27',10,NULL,NULL,NULL,NULL,55.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:35','2026-05-20 14:15:33'),
(4262784,20,'2026-04-27',1,NULL,NULL,NULL,NULL,150.1,30.8,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:41','2026-05-20 14:15:39'),
(4262785,20,'2026-04-27',5,NULL,NULL,NULL,NULL,150.1,30.8,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:41','2026-05-20 14:15:39'),
(4262786,20,'2026-04-27',10,NULL,NULL,NULL,NULL,150.1,30.8,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:41','2026-05-20 14:15:39'),
(4262961,21,'2026-04-27',1,0,NULL,0,NULL,102.2,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:42','2026-05-20 14:15:41'),
(4262962,21,'2026-04-27',5,0,NULL,0,NULL,102.2,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:42','2026-05-20 14:15:41'),
(4262963,21,'2026-04-27',10,0,NULL,0,NULL,102.2,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:42','2026-05-20 14:15:41'),
(4263333,27,'2026-04-27',1,0,NULL,0,NULL,124.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:51','2026-05-20 14:15:49'),
(4263334,27,'2026-04-27',5,0,NULL,0,NULL,124.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:51','2026-05-20 14:15:49'),
(4263335,27,'2026-04-27',10,0,NULL,0,NULL,124.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:00:51','2026-05-20 14:15:49'),
(4263519,28,'2026-04-27',1,NULL,NULL,NULL,NULL,456.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:53','2026-05-20 14:15:51'),
(4263520,28,'2026-04-27',5,NULL,NULL,NULL,NULL,456.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:53','2026-05-20 14:15:51'),
(4263521,28,'2026-04-27',10,NULL,NULL,NULL,NULL,456.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:53','2026-05-20 14:15:51'),
(4263666,29,'2026-04-27',1,NULL,NULL,NULL,NULL,117.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:55','2026-05-20 14:15:53'),
(4263667,29,'2026-04-27',5,NULL,NULL,NULL,NULL,117.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:55','2026-05-20 14:15:53'),
(4263668,29,'2026-04-27',10,NULL,NULL,NULL,NULL,117.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-27 09:00:55','2026-05-20 14:15:53'),
(4263858,30,'2026-04-27',1,NULL,NULL,NULL,NULL,429.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:57','2026-05-20 14:15:54'),
(4263859,30,'2026-04-27',5,NULL,NULL,NULL,NULL,429.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:57','2026-05-20 14:15:54'),
(4263860,30,'2026-04-27',10,NULL,NULL,NULL,NULL,429.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:00:57','2026-05-20 14:15:54'),
(4264650,36,'2026-04-27',1,0,NULL,0,NULL,417.8,NULL,0,NULL,0,NULL,1,'positif','2026-04-27 09:01:07','2026-05-20 14:16:04'),
(4264651,36,'2026-04-27',5,0,NULL,0,NULL,417.8,NULL,0,NULL,0,NULL,1,'positif','2026-04-27 09:01:07','2026-05-20 14:16:04'),
(4264652,36,'2026-04-27',10,0,NULL,0,NULL,417.8,NULL,0,NULL,0,NULL,1,'positif','2026-04-27 09:01:07','2026-05-20 14:16:04'),
(4264848,37,'2026-04-27',1,NULL,NULL,NULL,NULL,785.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:09','2026-05-20 14:16:06'),
(4264849,37,'2026-04-27',5,NULL,NULL,NULL,NULL,785.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:09','2026-05-20 14:16:06'),
(4264850,37,'2026-04-27',10,NULL,NULL,NULL,NULL,785.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:09','2026-05-20 14:16:06'),
(4265046,38,'2026-04-27',1,NULL,NULL,NULL,NULL,869.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:11','2026-05-20 14:16:08'),
(4265047,38,'2026-04-27',5,NULL,NULL,NULL,NULL,869.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:11','2026-05-20 14:16:08'),
(4265048,38,'2026-04-27',10,NULL,NULL,NULL,NULL,869.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-27 09:01:11','2026-05-20 14:16:08'),
(4267713,60,'2026-04-27',1,0,NULL,0,NULL,73.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:01:51','2026-05-20 14:01:46'),
(4267714,60,'2026-04-27',5,0,NULL,0,NULL,73.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:01:51','2026-05-20 14:01:46'),
(4267715,60,'2026-04-27',10,0,NULL,0,NULL,73.6,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 09:01:51','2026-05-20 14:01:46'),
(4276120,61,'2026-04-27',1,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 10:01:49','2026-05-20 14:01:48'),
(4276121,61,'2026-04-27',5,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 10:01:49','2026-05-20 14:01:48'),
(4276122,61,'2026-04-27',10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-27 10:01:49','2026-05-20 14:01:48'),
(4292744,1,'2026-04-28',1,214,NULL,0,NULL,110.3,NULL,0,NULL,0,NULL,0,'négatif','2026-04-28 09:00:03','2026-05-20 14:15:03'),
(4292745,1,'2026-04-28',5,214,NULL,0,NULL,110.3,NULL,0,NULL,0,NULL,0,'négatif','2026-04-28 09:00:03','2026-05-20 14:15:03'),
(4292746,1,'2026-04-28',10,214,NULL,0,NULL,110.3,NULL,0,NULL,0,NULL,0,'négatif','2026-04-28 09:00:03','2026-05-20 14:15:03'),
(4293620,8,'2026-04-28',1,NULL,NULL,NULL,NULL,107.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:16','2026-05-20 14:15:16'),
(4293621,8,'2026-04-28',5,NULL,NULL,NULL,NULL,107.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:16','2026-05-20 14:15:16'),
(4293622,8,'2026-04-28',10,NULL,NULL,NULL,NULL,107.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:16','2026-05-20 14:15:16'),
(4293797,9,'2026-04-28',1,NULL,NULL,NULL,NULL,118.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:18','2026-05-20 14:15:18'),
(4293798,9,'2026-04-28',5,NULL,NULL,NULL,NULL,118.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:18','2026-05-20 14:15:18'),
(4293799,9,'2026-04-28',10,NULL,NULL,NULL,NULL,118.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:18','2026-05-20 14:15:18'),
(4293959,10,'2026-04-28',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:20','2026-05-20 14:15:19'),
(4293960,10,'2026-04-28',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:20','2026-05-20 14:15:19'),
(4293961,10,'2026-04-28',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:00:20','2026-05-20 14:15:19'),
(4295345,19,'2026-04-28',1,NULL,NULL,NULL,NULL,561.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-28 09:00:38','2026-05-20 14:15:37'),
(4295346,19,'2026-04-28',5,NULL,NULL,NULL,NULL,561.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-28 09:00:38','2026-05-20 14:15:37'),
(4295347,19,'2026-04-28',10,NULL,NULL,NULL,NULL,561.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-28 09:00:38','2026-05-20 14:15:37'),
(4297946,41,'2026-04-28',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:16','2026-05-20 14:16:13'),
(4297947,41,'2026-04-28',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:16','2026-05-20 14:16:13'),
(4297948,41,'2026-04-28',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:16','2026-05-20 14:16:13'),
(4298171,43,'2026-04-28',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:19','2026-05-20 14:16:17'),
(4298172,43,'2026-04-28',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:19','2026-05-20 14:16:17'),
(4298173,43,'2026-04-28',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:19','2026-05-20 14:16:17'),
(4298501,45,'2026-04-28',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:23','2026-05-20 14:16:20'),
(4298502,45,'2026-04-28',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:23','2026-05-20 14:16:20'),
(4298503,45,'2026-04-28',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:23','2026-05-20 14:16:20'),
(4298708,49,'2026-04-28',1,NULL,NULL,NULL,NULL,72.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:29','2026-05-20 14:01:25'),
(4298709,49,'2026-04-28',5,NULL,NULL,NULL,NULL,72.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:29','2026-05-20 14:01:25'),
(4298710,49,'2026-04-28',10,NULL,NULL,NULL,NULL,72.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:29','2026-05-20 14:01:25'),
(4299512,56,'2026-04-28',1,NULL,NULL,NULL,NULL,77.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:41','2026-05-20 14:01:37'),
(4299513,56,'2026-04-28',5,NULL,NULL,NULL,NULL,77.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:41','2026-05-20 14:01:37'),
(4299514,56,'2026-04-28',10,NULL,NULL,NULL,NULL,77.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-28 09:01:41','2026-05-20 14:01:37'),
(4299659,57,'2026-04-28',1,0,NULL,0,NULL,192.8,39.5,0,NULL,0,NULL,1,'positif','2026-04-28 09:01:43','2026-05-20 14:01:39'),
(4299660,57,'2026-04-28',5,0,NULL,0,NULL,192.8,39.5,0,NULL,0,NULL,1,'positif','2026-04-28 09:01:43','2026-05-20 14:01:39'),
(4299661,57,'2026-04-28',10,0,NULL,0,NULL,192.8,39.5,0,NULL,0,NULL,1,'positif','2026-04-28 09:01:43','2026-05-20 14:01:39'),
(4326754,11,'2026-04-29',1,0,NULL,0,NULL,65.7,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:00:21','2026-05-20 14:15:21'),
(4326755,11,'2026-04-29',5,0,NULL,0,NULL,65.7,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:00:21','2026-05-20 14:15:21'),
(4326756,11,'2026-04-29',10,0,NULL,0,NULL,65.7,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:00:21','2026-05-20 14:15:21'),
(4327744,18,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:36','2026-05-20 14:15:35'),
(4327745,18,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:36','2026-05-20 14:15:35'),
(4327746,18,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:36','2026-05-20 14:15:35'),
(4328464,23,'2026-04-29',1,NULL,NULL,NULL,NULL,123.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:44','2026-05-20 14:15:44'),
(4328465,23,'2026-04-29',5,NULL,NULL,NULL,NULL,123.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:44','2026-05-20 14:15:44'),
(4328466,23,'2026-04-29',10,NULL,NULL,NULL,NULL,123.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:00:44','2026-05-20 14:15:44'),
(4329322,32,'2026-04-29',1,NULL,NULL,NULL,NULL,521.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-29 09:00:58','2026-05-20 14:15:57'),
(4329323,32,'2026-04-29',5,NULL,NULL,NULL,NULL,521.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-29 09:00:58','2026-05-20 14:15:57'),
(4329324,32,'2026-04-29',10,NULL,NULL,NULL,NULL,521.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-29 09:00:58','2026-05-20 14:15:57'),
(4329499,33,'2026-04-29',1,0,NULL,2.2,NULL,395.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:00','2026-05-20 14:15:59'),
(4329500,33,'2026-04-29',5,0,NULL,2.2,NULL,395.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:00','2026-05-20 14:15:59'),
(4329501,33,'2026-04-29',10,0,NULL,2.2,NULL,395.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:00','2026-05-20 14:15:59'),
(4329763,35,'2026-04-29',1,0,NULL,0,NULL,417.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:03','2026-05-20 14:16:03'),
(4329764,35,'2026-04-29',5,0,NULL,0,NULL,417.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:03','2026-05-20 14:16:03'),
(4329765,35,'2026-04-29',10,0,NULL,0,NULL,417.9,NULL,0,NULL,0,NULL,1,'positif','2026-04-29 09:01:03','2026-05-20 14:16:03'),
(4330948,44,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:20','2026-05-20 14:16:19'),
(4330949,44,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:20','2026-05-20 14:16:19'),
(4330950,44,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:20','2026-05-20 14:16:19'),
(4331497,51,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:31','2026-05-20 14:01:29'),
(4331498,51,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:31','2026-05-20 14:01:29'),
(4331499,51,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:31','2026-05-20 14:01:29'),
(4331638,52,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:33','2026-05-20 14:01:30'),
(4331639,52,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:33','2026-05-20 14:01:30'),
(4331640,52,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:33','2026-05-20 14:01:30'),
(4331761,53,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:35','2026-05-20 14:01:32'),
(4331762,53,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:35','2026-05-20 14:01:32'),
(4331763,53,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:35','2026-05-20 14:01:32'),
(4331866,54,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:37','2026-05-20 14:01:34'),
(4331867,54,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:37','2026-05-20 14:01:34'),
(4331868,54,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:37','2026-05-20 14:01:34'),
(4331983,55,'2026-04-29',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:39','2026-05-20 14:01:36'),
(4331984,55,'2026-04-29',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:39','2026-05-20 14:01:36'),
(4331985,55,'2026-04-29',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-29 09:01:39','2026-05-20 14:01:36'),
(4333317,63,'2026-04-29',1,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:01:56','2026-05-20 14:01:52'),
(4333318,63,'2026-04-29',5,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:01:56','2026-05-20 14:01:52'),
(4333319,63,'2026-04-29',10,0,NULL,0,NULL,0,NULL,0,NULL,0,NULL,0,'négatif','2026-04-29 09:01:56','2026-05-20 14:01:52'),
(4357860,1,'2026-04-30',1,747,279,0,NULL,99.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:03','2026-05-20 14:15:03'),
(4357861,1,'2026-04-30',5,747,279,0,NULL,99.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:03','2026-05-20 14:15:03'),
(4357862,1,'2026-04-30',10,747,279,0,NULL,99.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:03','2026-05-20 14:15:03'),
(4358466,6,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:13','2026-05-20 14:15:12'),
(4358467,6,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:13','2026-05-20 14:15:12'),
(4358468,6,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:13','2026-05-20 14:15:12'),
(4358727,8,'2026-04-30',1,NULL,NULL,NULL,NULL,183.5,37.6,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:17','2026-05-20 14:15:16'),
(4358728,8,'2026-04-30',5,NULL,NULL,NULL,NULL,183.5,37.6,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:17','2026-05-20 14:15:16'),
(4358729,8,'2026-04-30',10,NULL,NULL,NULL,NULL,183.5,37.6,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:17','2026-05-20 14:15:16'),
(4358904,9,'2026-04-30',1,NULL,NULL,NULL,NULL,123.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:19','2026-05-20 14:15:18'),
(4358905,9,'2026-04-30',5,NULL,NULL,NULL,NULL,123.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:19','2026-05-20 14:15:18'),
(4358906,9,'2026-04-30',10,NULL,NULL,NULL,NULL,123.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:19','2026-05-20 14:15:18'),
(4359066,10,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:21','2026-05-20 14:15:19'),
(4359067,10,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:21','2026-05-20 14:15:19'),
(4359068,10,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:21','2026-05-20 14:15:19'),
(4359264,11,'2026-04-30',1,NULL,NULL,NULL,NULL,109.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:23','2026-05-20 14:15:21'),
(4359265,11,'2026-04-30',5,NULL,NULL,NULL,NULL,109.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:23','2026-05-20 14:15:21'),
(4359266,11,'2026-04-30',10,NULL,NULL,NULL,NULL,109.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:23','2026-05-20 14:15:21'),
(4359804,16,'2026-04-30',1,0,NULL,NULL,NULL,149.4,30.6,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:33','2026-05-20 14:15:31'),
(4359805,16,'2026-04-30',5,0,NULL,NULL,NULL,149.4,30.6,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:33','2026-05-20 14:15:31'),
(4359806,16,'2026-04-30',10,0,NULL,NULL,NULL,149.4,30.6,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:33','2026-05-20 14:15:31'),
(4360035,17,'2026-04-30',1,NULL,NULL,NULL,NULL,160.2,32.8,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:36','2026-05-20 14:15:33'),
(4360036,17,'2026-04-30',5,NULL,NULL,NULL,NULL,160.2,32.8,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:36','2026-05-20 14:15:33'),
(4360037,17,'2026-04-30',10,NULL,NULL,NULL,NULL,160.2,32.8,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:36','2026-05-20 14:15:33'),
(4360620,20,'2026-04-30',1,NULL,NULL,NULL,NULL,180,36.9,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:42','2026-05-20 14:15:39'),
(4360621,20,'2026-04-30',5,NULL,NULL,NULL,NULL,180,36.9,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:42','2026-05-20 14:15:39'),
(4360622,20,'2026-04-30',10,NULL,NULL,NULL,NULL,180,36.9,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:42','2026-05-20 14:15:39'),
(4360797,21,'2026-04-30',1,NULL,NULL,NULL,NULL,84.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:44','2026-05-20 14:15:41'),
(4360798,21,'2026-04-30',5,NULL,NULL,NULL,NULL,84.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:44','2026-05-20 14:15:41'),
(4360799,21,'2026-04-30',10,NULL,NULL,NULL,NULL,84.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:00:44','2026-05-20 14:15:41'),
(4360986,23,'2026-04-30',1,NULL,NULL,NULL,NULL,210.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:46','2026-05-20 14:15:44'),
(4360987,23,'2026-04-30',5,NULL,NULL,NULL,NULL,210.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:46','2026-05-20 14:15:44'),
(4360988,23,'2026-04-30',10,NULL,NULL,NULL,NULL,210.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:00:46','2026-05-20 14:15:44'),
(4363266,42,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:18','2026-05-20 14:16:15'),
(4363267,42,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:18','2026-05-20 14:16:15'),
(4363268,42,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:18','2026-05-20 14:16:15'),
(4363305,43,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:20','2026-05-20 14:16:17'),
(4363306,43,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:20','2026-05-20 14:16:17'),
(4363307,43,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:20','2026-05-20 14:16:17'),
(4363791,48,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:28','2026-05-20 14:16:24'),
(4363792,48,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:28','2026-05-20 14:16:24'),
(4363793,48,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:28','2026-05-20 14:16:24'),
(4363842,49,'2026-04-30',1,NULL,NULL,NULL,NULL,93.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:30','2026-05-20 14:01:25'),
(4363843,49,'2026-04-30',5,NULL,NULL,NULL,NULL,93.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:30','2026-05-20 14:01:25'),
(4363844,49,'2026-04-30',10,NULL,NULL,NULL,NULL,93.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:30','2026-05-20 14:01:25'),
(4364646,56,'2026-04-30',1,NULL,NULL,NULL,NULL,132.7,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:42','2026-05-20 14:01:37'),
(4364647,56,'2026-04-30',5,NULL,NULL,NULL,NULL,132.7,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:42','2026-05-20 14:01:37'),
(4364648,56,'2026-04-30',10,NULL,NULL,NULL,NULL,132.7,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:42','2026-05-20 14:01:37'),
(4364952,58,'2026-04-30',1,359,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:46','2026-05-20 14:01:41'),
(4364953,58,'2026-04-30',5,359,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:46','2026-05-20 14:01:41'),
(4364954,58,'2026-04-30',10,359,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:46','2026-05-20 14:01:41'),
(4365144,59,'2026-04-30',1,675,252,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:48','2026-05-20 14:01:45'),
(4365145,59,'2026-04-30',5,675,252,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:48','2026-05-20 14:01:45'),
(4365146,59,'2026-04-30',10,675,252,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:48','2026-05-20 14:01:45'),
(4365546,60,'2026-04-30',1,0,NULL,NULL,NULL,173,35.5,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:01:52','2026-05-20 14:01:46'),
(4365547,60,'2026-04-30',5,0,NULL,NULL,NULL,173,35.5,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:01:52','2026-05-20 14:01:46'),
(4365548,60,'2026-04-30',10,0,NULL,NULL,NULL,173,35.5,NULL,NULL,NULL,NULL,1,'positif','2026-04-30 09:01:52','2026-05-20 14:01:46'),
(4365773,61,'2026-04-30',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:53','2026-05-20 14:01:48'),
(4365774,61,'2026-04-30',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:53','2026-05-20 14:01:48'),
(4365775,61,'2026-04-30',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-04-30 09:01:53','2026-05-20 14:01:48'),
(4490732,6,'2026-05-04',1,NULL,NULL,NULL,NULL,102.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:00:13','2026-05-20 14:15:12'),
(4490733,6,'2026-05-04',5,NULL,NULL,NULL,NULL,102.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:00:13','2026-05-20 14:15:12'),
(4490734,6,'2026-05-04',10,NULL,NULL,NULL,NULL,102.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:00:13','2026-05-20 14:15:12'),
(4490996,8,'2026-05-04',1,NULL,NULL,NULL,NULL,273.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:17','2026-05-20 14:15:16'),
(4490997,8,'2026-05-04',5,NULL,NULL,NULL,NULL,273.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:17','2026-05-20 14:15:16'),
(4490998,8,'2026-05-04',10,NULL,NULL,NULL,NULL,273.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:17','2026-05-20 14:15:16'),
(4491176,9,'2026-05-04',1,NULL,NULL,NULL,NULL,324.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:19','2026-05-20 14:15:18'),
(4491177,9,'2026-05-04',5,NULL,NULL,NULL,NULL,324.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:19','2026-05-20 14:15:18'),
(4491178,9,'2026-05-04',10,NULL,NULL,NULL,NULL,324.9,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:19','2026-05-20 14:15:18'),
(4491341,10,'2026-05-04',1,0,NULL,0,NULL,106.6,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:00:22','2026-05-20 14:15:19'),
(4491342,10,'2026-05-04',5,0,NULL,0,NULL,106.6,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:00:22','2026-05-20 14:15:19'),
(4491343,10,'2026-05-04',10,0,NULL,0,NULL,106.6,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:00:22','2026-05-20 14:15:19'),
(4492076,16,'2026-05-04',1,NULL,NULL,NULL,NULL,1265.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:35','2026-05-20 14:15:31'),
(4492077,16,'2026-05-04',5,NULL,NULL,NULL,NULL,1265.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:35','2026-05-20 14:15:31'),
(4492078,16,'2026-05-04',10,NULL,NULL,NULL,NULL,1265.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:35','2026-05-20 14:15:31'),
(4492307,17,'2026-05-04',1,NULL,NULL,NULL,NULL,899.7,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:38','2026-05-20 14:15:33'),
(4492308,17,'2026-05-04',5,NULL,NULL,NULL,NULL,899.7,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:38','2026-05-20 14:15:33'),
(4492309,17,'2026-05-04',10,NULL,NULL,NULL,NULL,899.7,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:38','2026-05-20 14:15:33'),
(4492532,18,'2026-05-04',1,NULL,NULL,NULL,NULL,478.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:40','2026-05-20 14:15:35'),
(4492533,18,'2026-05-04',5,NULL,NULL,NULL,NULL,478.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:40','2026-05-20 14:15:35'),
(4492534,18,'2026-05-04',10,NULL,NULL,NULL,NULL,478.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:40','2026-05-20 14:15:35'),
(4492892,20,'2026-05-04',1,NULL,NULL,NULL,NULL,1400.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:44','2026-05-20 14:15:39'),
(4492893,20,'2026-05-04',5,NULL,NULL,NULL,NULL,1400.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:44','2026-05-20 14:15:39'),
(4492894,20,'2026-05-04',10,NULL,NULL,NULL,NULL,1400.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:00:44','2026-05-20 14:15:39'),
(4493069,21,'2026-05-04',1,0,NULL,0,NULL,925.4,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:00:46','2026-05-20 14:15:41'),
(4493070,21,'2026-05-04',5,0,NULL,0,NULL,925.4,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:00:46','2026-05-20 14:15:41'),
(4493071,21,'2026-05-04',10,0,NULL,0,NULL,925.4,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:00:46','2026-05-20 14:15:41'),
(4495343,41,'2026-05-04',1,NULL,NULL,NULL,NULL,56.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:23','2026-05-20 14:16:13'),
(4495344,41,'2026-05-04',5,NULL,NULL,NULL,NULL,56.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:23','2026-05-20 14:16:13'),
(4495345,41,'2026-05-04',10,NULL,NULL,NULL,NULL,56.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:23','2026-05-20 14:16:13'),
(4495532,42,'2026-05-04',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:25','2026-05-20 14:16:15'),
(4495533,42,'2026-05-04',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:25','2026-05-20 14:16:15'),
(4495534,42,'2026-05-04',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:25','2026-05-20 14:16:15'),
(4495574,43,'2026-05-04',1,NULL,NULL,NULL,NULL,49.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:27','2026-05-20 14:16:17'),
(4495575,43,'2026-05-04',5,NULL,NULL,NULL,NULL,49.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:27','2026-05-20 14:16:17'),
(4495576,43,'2026-05-04',10,NULL,NULL,NULL,NULL,49.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:27','2026-05-20 14:16:17'),
(4495748,44,'2026-05-04',1,NULL,NULL,NULL,NULL,70.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:29','2026-05-20 14:16:19'),
(4495749,44,'2026-05-04',5,NULL,NULL,NULL,NULL,70.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:29','2026-05-20 14:16:19'),
(4495750,44,'2026-05-04',10,NULL,NULL,NULL,NULL,70.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:29','2026-05-20 14:16:19'),
(4495910,45,'2026-05-04',1,NULL,NULL,NULL,NULL,89.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:31','2026-05-20 14:16:20'),
(4495911,45,'2026-05-04',5,NULL,NULL,NULL,NULL,89.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:31','2026-05-20 14:16:20'),
(4495912,45,'2026-05-04',10,NULL,NULL,NULL,NULL,89.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:31','2026-05-20 14:16:20'),
(4496069,48,'2026-05-04',1,NULL,NULL,NULL,NULL,44.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:35','2026-05-20 14:16:24'),
(4496070,48,'2026-05-04',5,NULL,NULL,NULL,NULL,44.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:35','2026-05-20 14:16:24'),
(4496071,48,'2026-05-04',10,NULL,NULL,NULL,NULL,44.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:01:35','2026-05-20 14:16:24'),
(4496123,49,'2026-05-04',1,0,NULL,0,NULL,182.7,37.5,0,NULL,0,NULL,1,'positif','2026-05-04 10:01:37','2026-05-20 14:01:25'),
(4496124,49,'2026-05-04',5,0,NULL,0,NULL,182.7,37.5,0,NULL,0,NULL,1,'positif','2026-05-04 10:01:37','2026-05-20 14:01:25'),
(4496125,49,'2026-05-04',10,0,NULL,0,NULL,182.7,37.5,0,NULL,0,NULL,1,'positif','2026-05-04 10:01:37','2026-05-20 14:01:25'),
(4496930,56,'2026-05-04',1,NULL,NULL,NULL,NULL,637.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:01:51','2026-05-20 14:01:37'),
(4496931,56,'2026-05-04',5,NULL,NULL,NULL,NULL,637.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:01:51','2026-05-20 14:01:37'),
(4496932,56,'2026-05-04',10,NULL,NULL,NULL,NULL,637.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-04 10:01:51','2026-05-20 14:01:37'),
(4497833,60,'2026-05-04',1,157,NULL,0,NULL,534.7,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:02:02','2026-05-20 14:01:46'),
(4497834,60,'2026-05-04',5,157,NULL,0,NULL,534.7,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:02:02','2026-05-20 14:01:46'),
(4497835,60,'2026-05-04',10,157,NULL,0,NULL,534.7,NULL,0,NULL,0,NULL,1,'positif','2026-05-04 10:02:02','2026-05-20 14:01:46'),
(4498060,61,'2026-05-04',1,0,NULL,0,NULL,64.599,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:02:04','2026-05-20 14:01:48'),
(4498061,61,'2026-05-04',5,0,NULL,0,NULL,64.599,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:02:04','2026-05-20 14:01:48'),
(4498062,61,'2026-05-04',10,0,NULL,0,NULL,64.599,NULL,0,NULL,0,NULL,0,'négatif','2026-05-04 10:02:04','2026-05-20 14:01:48'),
(4498159,63,'2026-05-04',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:02:08','2026-05-20 14:01:52'),
(4498160,63,'2026-05-04',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:02:08','2026-05-20 14:01:52'),
(4498161,63,'2026-05-04',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 10:02:08','2026-05-20 14:01:52'),
(4499908,13,'2026-05-04',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:29','2026-05-20 14:15:26'),
(4499909,13,'2026-05-04',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:29','2026-05-20 14:15:26'),
(4499910,13,'2026-05-04',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:29','2026-05-20 14:15:26'),
(4501624,24,'2026-05-04',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:53','2026-05-20 14:15:45'),
(4501625,24,'2026-05-04',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:53','2026-05-20 14:15:45'),
(4501626,24,'2026-05-04',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-04 19:00:53','2026-05-20 14:15:45'),
(4516148,11,'2026-05-05',1,NULL,NULL,NULL,NULL,120.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:00:24','2026-05-20 14:15:21'),
(4516149,11,'2026-05-05',5,NULL,NULL,NULL,NULL,120.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:00:24','2026-05-20 14:15:21'),
(4516150,11,'2026-05-05',10,NULL,NULL,NULL,NULL,120.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:00:24','2026-05-20 14:15:21'),
(4517849,23,'2026-05-05',1,NULL,NULL,NULL,NULL,203.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:00:51','2026-05-20 14:15:44'),
(4517850,23,'2026-05-05',5,NULL,NULL,NULL,NULL,203.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:00:51','2026-05-20 14:15:44'),
(4517851,23,'2026-05-05',10,NULL,NULL,NULL,NULL,203.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:00:51','2026-05-20 14:15:44'),
(4518041,27,'2026-05-05',1,0,NULL,0,NULL,593.3,NULL,0,NULL,0,NULL,1,'positif','2026-05-05 09:00:58','2026-05-20 14:15:49'),
(4518042,27,'2026-05-05',5,0,NULL,0,NULL,593.3,NULL,0,NULL,0,NULL,1,'positif','2026-05-05 09:00:58','2026-05-20 14:15:49'),
(4518043,27,'2026-05-05',10,0,NULL,0,NULL,593.3,NULL,0,NULL,0,NULL,1,'positif','2026-05-05 09:00:58','2026-05-20 14:15:49'),
(4518365,29,'2026-05-05',1,NULL,NULL,NULL,NULL,536.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:02','2026-05-20 14:15:53'),
(4518366,29,'2026-05-05',5,NULL,NULL,NULL,NULL,536.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:02','2026-05-20 14:15:53'),
(4518367,29,'2026-05-05',10,NULL,NULL,NULL,NULL,536.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:02','2026-05-20 14:15:53'),
(4521653,57,'2026-05-05',1,NULL,NULL,NULL,NULL,249.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:57','2026-05-20 14:01:39'),
(4521654,57,'2026-05-05',5,NULL,NULL,NULL,NULL,249.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:57','2026-05-20 14:01:39'),
(4521655,57,'2026-05-05',10,NULL,NULL,NULL,NULL,249.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-05 09:01:57','2026-05-20 14:01:39'),
(4521815,58,'2026-05-05',1,159,NULL,0,NULL,58.5,NULL,0,NULL,0,NULL,0,'négatif','2026-05-05 09:02:00','2026-05-20 14:01:41'),
(4521816,58,'2026-05-05',5,196,NULL,0,NULL,58.5,NULL,0,NULL,0,NULL,0,'négatif','2026-05-05 09:02:00','2026-05-20 14:01:41'),
(4521817,58,'2026-05-05',10,182,NULL,0,NULL,58.5,NULL,0,NULL,0,NULL,0,'négatif','2026-05-05 09:02:00','2026-05-20 14:01:41'),
(4522010,59,'2026-05-05',1,302,NULL,NULL,NULL,75.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:02:02','2026-05-20 14:01:45'),
(4522011,59,'2026-05-05',5,366,NULL,NULL,NULL,75.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:02:02','2026-05-20 14:01:45'),
(4522012,59,'2026-05-05',10,359,NULL,NULL,NULL,75.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-05 09:02:02','2026-05-20 14:01:45'),
(4547413,1,'2026-05-06',1,331,NULL,0,NULL,1182.9,NULL,0,NULL,0,NULL,1,'positif','2026-05-06 09:00:03','2026-05-20 14:15:03'),
(4547414,1,'2026-05-06',5,331,NULL,0,NULL,1182.9,NULL,0,NULL,0,NULL,1,'positif','2026-05-06 09:00:03','2026-05-20 14:15:03'),
(4547415,1,'2026-05-06',10,331,NULL,0,NULL,1182.9,NULL,0,NULL,0,NULL,1,'positif','2026-05-06 09:00:03','2026-05-20 14:15:03'),
(4548013,6,'2026-05-06',1,NULL,NULL,NULL,NULL,230.8,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:14','2026-05-20 14:15:12'),
(4548014,6,'2026-05-06',5,NULL,NULL,NULL,NULL,230.8,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:14','2026-05-20 14:15:12'),
(4548015,6,'2026-05-06',10,NULL,NULL,NULL,NULL,230.8,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:14','2026-05-20 14:15:12'),
(4548211,7,'2026-05-06',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:16','2026-05-20 14:15:14'),
(4548212,7,'2026-05-06',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:16','2026-05-20 14:15:14'),
(4548213,7,'2026-05-06',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:16','2026-05-20 14:15:14'),
(4548619,10,'2026-05-06',1,NULL,NULL,NULL,NULL,144.2,29.6,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:22','2026-05-20 14:15:19'),
(4548620,10,'2026-05-06',5,NULL,NULL,NULL,NULL,144.2,29.6,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:22','2026-05-20 14:15:19'),
(4548621,10,'2026-05-06',10,NULL,NULL,NULL,NULL,144.2,29.6,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:00:22','2026-05-20 14:15:19'),
(4550896,28,'2026-05-06',1,NULL,NULL,NULL,NULL,1369.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:59','2026-05-20 14:15:51'),
(4550897,28,'2026-05-06',5,NULL,NULL,NULL,NULL,1369.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:59','2026-05-20 14:15:51'),
(4550898,28,'2026-05-06',10,NULL,NULL,NULL,NULL,1369.4,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:00:59','2026-05-20 14:15:51'),
(4551229,30,'2026-05-06',1,NULL,NULL,NULL,NULL,1482.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:04','2026-05-20 14:15:54'),
(4551230,30,'2026-05-06',5,NULL,NULL,NULL,NULL,1482.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:04','2026-05-20 14:15:54'),
(4551231,30,'2026-05-06',10,NULL,NULL,NULL,NULL,1482.3,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:04','2026-05-20 14:15:54'),
(4553566,51,'2026-05-06',1,0,NULL,0,NULL,895.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:44','2026-05-20 14:01:29'),
(4553567,51,'2026-05-06',5,0,NULL,0,NULL,895.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:44','2026-05-20 14:01:29'),
(4553568,51,'2026-05-06',10,0,NULL,0,NULL,895.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:44','2026-05-20 14:01:29'),
(4553710,52,'2026-05-06',1,NULL,NULL,NULL,NULL,298.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:46','2026-05-20 14:01:30'),
(4553711,52,'2026-05-06',5,NULL,NULL,NULL,NULL,298.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:46','2026-05-20 14:01:30'),
(4553712,52,'2026-05-06',10,NULL,NULL,NULL,NULL,298.6,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:46','2026-05-20 14:01:30'),
(4553836,53,'2026-05-06',1,161,NULL,0,NULL,177.4,36.4,0,NULL,0,NULL,1,'positif','2026-05-06 09:01:48','2026-05-20 14:01:32'),
(4553837,53,'2026-05-06',5,161,NULL,0,NULL,177.4,36.4,0,NULL,0,NULL,1,'positif','2026-05-06 09:01:48','2026-05-20 14:01:32'),
(4553838,53,'2026-05-06',10,161,NULL,0,NULL,177.4,36.4,0,NULL,0,NULL,1,'positif','2026-05-06 09:01:48','2026-05-20 14:01:32'),
(4553944,54,'2026-05-06',1,NULL,NULL,NULL,NULL,149.7,30.7,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:01:50','2026-05-20 14:01:34'),
(4553945,54,'2026-05-06',5,NULL,NULL,NULL,NULL,149.7,30.7,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:01:50','2026-05-20 14:01:34'),
(4553946,54,'2026-05-06',10,NULL,NULL,NULL,NULL,149.7,30.7,NULL,NULL,NULL,NULL,0,'négatif','2026-05-06 09:01:50','2026-05-20 14:01:34'),
(4554064,55,'2026-05-06',1,NULL,NULL,NULL,NULL,441.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:52','2026-05-20 14:01:36'),
(4554065,55,'2026-05-06',5,NULL,NULL,NULL,NULL,441.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:52','2026-05-20 14:01:36'),
(4554066,55,'2026-05-06',10,NULL,NULL,NULL,NULL,441.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-06 09:01:52','2026-05-20 14:01:36'),
(4585293,41,'2026-05-07',1,NULL,NULL,0,NULL,118.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:16','2026-05-20 14:16:13'),
(4585294,41,'2026-05-07',5,NULL,NULL,0,NULL,118.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:16','2026-05-20 14:16:13'),
(4585295,41,'2026-05-07',10,NULL,NULL,0,NULL,118.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:16','2026-05-20 14:16:13'),
(4585482,42,'2026-05-07',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:18','2026-05-20 14:16:15'),
(4585483,42,'2026-05-07',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:18','2026-05-20 14:16:15'),
(4585484,42,'2026-05-07',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:18','2026-05-20 14:16:15'),
(4585527,43,'2026-05-07',1,NULL,NULL,NULL,NULL,90.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:20','2026-05-20 14:16:17'),
(4585528,43,'2026-05-07',5,NULL,NULL,NULL,NULL,90.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:20','2026-05-20 14:16:17'),
(4585529,43,'2026-05-07',10,NULL,NULL,NULL,NULL,90.9,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:20','2026-05-20 14:16:17'),
(4585701,44,'2026-05-07',1,NULL,NULL,NULL,NULL,102.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:22','2026-05-20 14:16:19'),
(4585702,44,'2026-05-07',5,NULL,NULL,NULL,NULL,102.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:22','2026-05-20 14:16:19'),
(4585703,44,'2026-05-07',10,NULL,NULL,NULL,NULL,102.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:22','2026-05-20 14:16:19'),
(4585863,45,'2026-05-07',1,NULL,NULL,NULL,NULL,326.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-07 09:01:24','2026-05-20 14:16:20'),
(4585864,45,'2026-05-07',5,NULL,NULL,NULL,NULL,326.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-07 09:01:24','2026-05-20 14:16:20'),
(4585865,45,'2026-05-07',10,NULL,NULL,NULL,NULL,326.1,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-07 09:01:24','2026-05-20 14:16:20'),
(4586022,48,'2026-05-07',1,NULL,NULL,NULL,NULL,93.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:28','2026-05-20 14:16:24'),
(4586023,48,'2026-05-07',5,NULL,NULL,NULL,NULL,93.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:28','2026-05-20 14:16:24'),
(4586024,48,'2026-05-07',10,NULL,NULL,NULL,NULL,93.5,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:28','2026-05-20 14:16:24'),
(4588010,61,'2026-05-07',1,NULL,NULL,NULL,NULL,108.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:53','2026-05-20 14:01:48'),
(4588011,61,'2026-05-07',5,NULL,NULL,NULL,NULL,108.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:53','2026-05-20 14:01:48'),
(4588012,61,'2026-05-07',10,NULL,NULL,NULL,NULL,108.6,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:53','2026-05-20 14:01:48'),
(4588112,63,'2026-05-07',1,NULL,NULL,NULL,NULL,66.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:56','2026-05-20 14:01:52'),
(4588113,63,'2026-05-07',5,NULL,NULL,NULL,NULL,66.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:56','2026-05-20 14:01:52'),
(4588114,63,'2026-05-07',10,NULL,NULL,NULL,NULL,66.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-07 09:01:56','2026-05-20 14:01:52'),
(4613516,7,'2026-05-08',1,NULL,NULL,NULL,NULL,68.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:16','2026-05-20 14:15:14'),
(4613517,7,'2026-05-08',5,NULL,NULL,NULL,NULL,68.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:16','2026-05-20 14:15:14'),
(4613518,7,'2026-05-08',10,NULL,NULL,NULL,NULL,68.3,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:16','2026-05-20 14:15:14'),
(4613927,10,'2026-05-08',1,NULL,NULL,NULL,NULL,234.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:00:21','2026-05-20 14:15:19'),
(4613928,10,'2026-05-08',5,NULL,NULL,NULL,NULL,234.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:00:21','2026-05-20 14:15:19'),
(4613929,10,'2026-05-08',10,NULL,NULL,NULL,NULL,234.2,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:00:21','2026-05-20 14:15:19'),
(4614296,13,'2026-05-08',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:28','2026-05-20 14:15:26'),
(4614297,13,'2026-05-08',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:28','2026-05-20 14:15:26'),
(4614298,13,'2026-05-08',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:28','2026-05-20 14:15:26'),
(4615991,24,'2026-05-08',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:49','2026-05-20 14:15:45'),
(4615992,24,'2026-05-08',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:49','2026-05-20 14:15:45'),
(4615993,24,'2026-05-08',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:00:49','2026-05-20 14:15:45'),
(4617860,40,'2026-05-08',1,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:16','2026-05-20 14:16:11'),
(4617861,40,'2026-05-08',5,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:16','2026-05-20 14:16:11'),
(4617862,40,'2026-05-08',10,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:16','2026-05-20 14:16:11'),
(4617893,41,'2026-05-08',1,NULL,NULL,NULL,NULL,152.1,31.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:17','2026-05-20 14:16:13'),
(4617894,41,'2026-05-08',5,NULL,NULL,NULL,NULL,152.1,31.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:17','2026-05-20 14:16:13'),
(4617895,41,'2026-05-08',10,NULL,NULL,NULL,NULL,152.1,31.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:17','2026-05-20 14:16:13'),
(4618085,42,'2026-05-08',1,NULL,NULL,NULL,NULL,48.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:19','2026-05-20 14:16:15'),
(4618086,42,'2026-05-08',5,NULL,NULL,NULL,NULL,48.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:19','2026-05-20 14:16:15'),
(4618087,42,'2026-05-08',10,NULL,NULL,NULL,NULL,48.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:19','2026-05-20 14:16:15'),
(4618133,43,'2026-05-08',1,NULL,NULL,NULL,NULL,132.6,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:21','2026-05-20 14:16:17'),
(4618134,43,'2026-05-08',5,NULL,NULL,NULL,NULL,132.6,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:21','2026-05-20 14:16:17'),
(4618135,43,'2026-05-08',10,NULL,NULL,NULL,NULL,132.6,27.2,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:21','2026-05-20 14:16:17'),
(4618310,44,'2026-05-08',1,NULL,NULL,NULL,NULL,88.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:23','2026-05-20 14:16:19'),
(4618311,44,'2026-05-08',5,NULL,NULL,NULL,NULL,88.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:23','2026-05-20 14:16:19'),
(4618312,44,'2026-05-08',10,NULL,NULL,NULL,NULL,88.7,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:23','2026-05-20 14:16:19'),
(4618475,45,'2026-05-08',1,NULL,NULL,NULL,NULL,504.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:25','2026-05-20 14:16:20'),
(4618476,45,'2026-05-08',5,NULL,NULL,NULL,NULL,504.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:25','2026-05-20 14:16:20'),
(4618477,45,'2026-05-08',10,NULL,NULL,NULL,NULL,504.5,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:25','2026-05-20 14:16:20'),
(4618637,48,'2026-05-08',1,NULL,NULL,NULL,NULL,80.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:29','2026-05-20 14:16:24'),
(4618638,48,'2026-05-08',5,NULL,NULL,NULL,NULL,80.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:29','2026-05-20 14:16:24'),
(4618639,48,'2026-05-08',10,NULL,NULL,NULL,NULL,80.4,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:29','2026-05-20 14:16:24'),
(4619810,58,'2026-05-08',1,161,NULL,0,NULL,52.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:46','2026-05-20 14:01:41'),
(4619811,58,'2026-05-08',5,161,NULL,0,NULL,52.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:46','2026-05-20 14:01:41'),
(4619812,58,'2026-05-08',10,161,NULL,0,NULL,52.8,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:46','2026-05-20 14:01:41'),
(4620005,59,'2026-05-08',1,282,NULL,0,NULL,58.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:48','2026-05-20 14:01:45'),
(4620006,59,'2026-05-08',5,282,NULL,0,NULL,58.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:48','2026-05-20 14:01:45'),
(4620007,59,'2026-05-08',10,282,NULL,0,NULL,58.2,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:48','2026-05-20 14:01:45'),
(4620637,61,'2026-05-08',1,NULL,NULL,NULL,NULL,176.6,36.2,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:54','2026-05-20 14:01:48'),
(4620638,61,'2026-05-08',5,NULL,NULL,NULL,NULL,176.6,36.2,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:54','2026-05-20 14:01:48'),
(4620639,61,'2026-05-08',10,NULL,NULL,NULL,NULL,176.6,36.2,NULL,NULL,NULL,NULL,1,'positif','2026-05-08 09:01:54','2026-05-20 14:01:48'),
(4620715,62,'2026-05-08',1,NULL,NULL,NULL,NULL,58.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:55','2026-05-20 14:01:50'),
(4620716,62,'2026-05-08',5,NULL,NULL,NULL,NULL,58.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:55','2026-05-20 14:01:50'),
(4620717,62,'2026-05-08',10,NULL,NULL,NULL,NULL,58.1,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-08 09:01:55','2026-05-20 14:01:50'),
(4711286,6,'2026-05-11',1,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:00:12','2026-05-20 14:15:12'),
(4711287,6,'2026-05-11',5,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:00:12','2026-05-20 14:15:12'),
(4711288,6,'2026-05-11',10,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:00:12','2026-05-20 14:15:12'),
(4711487,7,'2026-05-11',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:14','2026-05-20 14:15:14'),
(4711488,7,'2026-05-11',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:14','2026-05-20 14:15:14'),
(4711489,7,'2026-05-11',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:14','2026-05-20 14:15:14'),
(4711562,8,'2026-05-11',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:17','2026-05-20 14:15:16'),
(4711563,8,'2026-05-11',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:17','2026-05-20 14:15:16'),
(4711564,8,'2026-05-11',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:17','2026-05-20 14:15:16'),
(4711904,10,'2026-05-11',1,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:20','2026-05-20 14:15:19'),
(4711905,10,'2026-05-11',5,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:20','2026-05-20 14:15:19'),
(4711906,10,'2026-05-11',10,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:00:20','2026-05-20 14:15:19'),
(4715810,40,'2026-05-11',1,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:13','2026-05-20 14:16:11'),
(4715811,40,'2026-05-11',5,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:13','2026-05-20 14:16:11'),
(4715812,40,'2026-05-11',10,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:13','2026-05-20 14:16:11'),
(4715846,41,'2026-05-11',1,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:15','2026-05-20 14:16:13'),
(4715847,41,'2026-05-11',5,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:15','2026-05-20 14:16:13'),
(4715848,41,'2026-05-11',10,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:15','2026-05-20 14:16:13'),
(4716041,42,'2026-05-11',1,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:17','2026-05-20 14:16:15'),
(4716042,42,'2026-05-11',5,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:17','2026-05-20 14:16:15'),
(4716043,42,'2026-05-11',10,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:17','2026-05-20 14:16:15'),
(4716092,43,'2026-05-11',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:19','2026-05-20 14:16:17'),
(4716093,43,'2026-05-11',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:19','2026-05-20 14:16:17'),
(4716094,43,'2026-05-11',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:19','2026-05-20 14:16:17'),
(4716272,44,'2026-05-11',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:21','2026-05-20 14:16:19'),
(4716273,44,'2026-05-11',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:21','2026-05-20 14:16:19'),
(4716274,44,'2026-05-11',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:21','2026-05-20 14:16:19'),
(4716602,48,'2026-05-11',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:26','2026-05-20 14:16:24'),
(4716603,48,'2026-05-11',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:26','2026-05-20 14:16:24'),
(4716604,48,'2026-05-11',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:26','2026-05-20 14:16:24'),
(4716665,49,'2026-05-11',1,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:28','2026-05-20 14:01:25'),
(4716666,49,'2026-05-11',5,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:28','2026-05-20 14:01:25'),
(4716667,49,'2026-05-11',10,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:28','2026-05-20 14:01:25'),
(4717772,58,'2026-05-11',1,0,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:44','2026-05-20 14:01:41'),
(4717773,58,'2026-05-11',5,0,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:44','2026-05-20 14:01:41'),
(4717774,58,'2026-05-11',10,0,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-11 09:01:44','2026-05-20 14:01:41'),
(4717970,59,'2026-05-11',1,167,NULL,0,NULL,120,NULL,0,NULL,0,NULL,0,'négatif','2026-05-11 09:01:46','2026-05-20 14:01:45'),
(4717971,59,'2026-05-11',5,167,NULL,0,NULL,120,NULL,0,NULL,0,NULL,0,'négatif','2026-05-11 09:01:46','2026-05-20 14:01:45'),
(4717972,59,'2026-05-11',10,167,NULL,0,NULL,120,NULL,0,NULL,0,NULL,0,'négatif','2026-05-11 09:01:46','2026-05-20 14:01:45'),
(4718605,61,'2026-05-11',1,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:52','2026-05-20 14:01:48'),
(4718606,61,'2026-05-11',5,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:52','2026-05-20 14:01:48'),
(4718607,61,'2026-05-11',10,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:52','2026-05-20 14:01:48'),
(4718686,62,'2026-05-11',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:53','2026-05-20 14:01:50'),
(4718687,62,'2026-05-11',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:53','2026-05-20 14:01:50'),
(4718688,62,'2026-05-11',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-11 09:01:53','2026-05-20 14:01:50'),
(4718719,63,'2026-05-11',1,0,NULL,0,NULL,160,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:55','2026-05-20 14:01:52'),
(4718720,63,'2026-05-11',5,0,NULL,0,NULL,160,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:55','2026-05-20 14:01:52'),
(4718721,63,'2026-05-11',10,0,NULL,0,NULL,160,NULL,0,NULL,0,NULL,1,'positif','2026-05-11 09:01:55','2026-05-20 14:01:52'),
(4744903,11,'2026-05-12',1,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:21','2026-05-20 14:15:21'),
(4744904,11,'2026-05-12',5,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:21','2026-05-20 14:15:21'),
(4744905,11,'2026-05-12',10,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:21','2026-05-20 14:15:21'),
(4745875,18,'2026-05-12',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:35','2026-05-20 14:15:35'),
(4745876,18,'2026-05-12',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:35','2026-05-20 14:15:35'),
(4745877,18,'2026-05-12',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:35','2026-05-20 14:15:35'),
(4746571,23,'2026-05-12',1,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:44','2026-05-20 14:15:44'),
(4746572,23,'2026-05-12',5,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:44','2026-05-20 14:15:44'),
(4746573,23,'2026-05-12',10,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:00:44','2026-05-20 14:15:44'),
(4749583,50,'2026-05-12',1,0,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:29','2026-05-20 14:01:27'),
(4749584,50,'2026-05-12',5,0,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:29','2026-05-20 14:01:27'),
(4749585,50,'2026-05-12',10,0,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:29','2026-05-20 14:01:27'),
(4749748,52,'2026-05-12',1,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:33','2026-05-20 14:01:30'),
(4749749,52,'2026-05-12',5,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:33','2026-05-20 14:01:30'),
(4749750,52,'2026-05-12',10,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:33','2026-05-20 14:01:30'),
(4749874,53,'2026-05-12',1,0,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:34','2026-05-20 14:01:32'),
(4749875,53,'2026-05-12',5,0,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:34','2026-05-20 14:01:32'),
(4749876,53,'2026-05-12',10,0,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 09:01:34','2026-05-20 14:01:32'),
(4749982,54,'2026-05-12',1,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-12 09:01:36','2026-05-20 14:01:34'),
(4749983,54,'2026-05-12',5,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-12 09:01:36','2026-05-20 14:01:34'),
(4749984,54,'2026-05-12',10,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-12 09:01:36','2026-05-20 14:01:34'),
(4764869,40,'2026-05-12',1,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 12:01:13','2026-05-20 14:16:11'),
(4764870,40,'2026-05-12',5,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 12:01:13','2026-05-20 14:16:11'),
(4764871,40,'2026-05-12',10,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-12 12:01:13','2026-05-20 14:16:11'),
(5173971,58,'2026-05-13',1,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:43','2026-05-20 14:01:41'),
(5173972,58,'2026-05-13',5,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:43','2026-05-20 14:01:41'),
(5173973,58,'2026-05-13',10,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:43','2026-05-20 14:01:41'),
(5174169,59,'2026-05-13',1,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:45','2026-05-20 14:01:45'),
(5174170,59,'2026-05-13',5,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:45','2026-05-20 14:01:45'),
(5174171,59,'2026-05-13',10,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 09:31:45','2026-05-20 14:01:45'),
(5274170,13,'2026-05-13',1,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:26','2026-05-20 14:15:26'),
(5274171,13,'2026-05-13',5,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:26','2026-05-20 14:15:26'),
(5274172,13,'2026-05-13',10,NULL,NULL,NULL,NULL,40,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:26','2026-05-20 14:15:26'),
(5275838,24,'2026-05-13',1,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:46','2026-05-20 14:15:45'),
(5275839,24,'2026-05-13',5,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:46','2026-05-20 14:15:45'),
(5275840,24,'2026-05-13',10,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-13 12:45:46','2026-05-20 14:15:45'),
(5623741,14,'2026-05-14',1,0,NULL,0,NULL,1000,NULL,0,NULL,0,NULL,1,'positif','2026-05-14 08:30:32','2026-05-20 14:15:28'),
(5623742,14,'2026-05-14',5,0,NULL,0,NULL,1000,NULL,0,NULL,0,NULL,1,'positif','2026-05-14 08:30:32','2026-05-20 14:15:28'),
(5623743,14,'2026-05-14',10,0,NULL,0,NULL,1000,NULL,0,NULL,0,NULL,1,'positif','2026-05-14 08:30:32','2026-05-20 14:15:28'),
(5623912,15,'2026-05-14',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-14 08:30:34','2026-05-20 14:15:30'),
(5623913,15,'2026-05-14',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-14 08:30:34','2026-05-20 14:15:30'),
(5623914,15,'2026-05-14',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-14 08:30:34','2026-05-20 14:15:30'),
(6156260,58,'2026-05-15',1,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:45','2026-05-20 14:01:41'),
(6156261,58,'2026-05-15',5,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:45','2026-05-20 14:01:41'),
(6156262,58,'2026-05-15',10,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:45','2026-05-20 14:01:41'),
(6156461,59,'2026-05-15',1,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:47','2026-05-20 14:01:45'),
(6156462,59,'2026-05-15',5,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:47','2026-05-20 14:01:45'),
(6156463,59,'2026-05-15',10,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 09:46:47','2026-05-20 14:01:45'),
(6280420,13,'2026-05-15',1,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:25','2026-05-20 14:15:26'),
(6280421,13,'2026-05-15',5,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:25','2026-05-20 14:15:26'),
(6280422,13,'2026-05-15',10,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:25','2026-05-20 14:15:26'),
(6282079,24,'2026-05-15',1,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:45','2026-05-20 14:15:45'),
(6282080,24,'2026-05-15',5,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:45','2026-05-20 14:15:45'),
(6282081,24,'2026-05-15',10,NULL,NULL,NULL,NULL,75,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-15 13:45:45','2026-05-20 14:15:45'),
(7567657,40,'2026-05-18',1,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:14','2026-05-20 14:16:11'),
(7567658,40,'2026-05-18',5,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:14','2026-05-20 14:16:11'),
(7567659,40,'2026-05-18',10,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:14','2026-05-20 14:16:11'),
(7567891,42,'2026-05-18',1,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:18','2026-05-20 14:16:15'),
(7567892,42,'2026-05-18',5,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:18','2026-05-20 14:16:15'),
(7567893,42,'2026-05-18',10,NULL,NULL,NULL,NULL,600,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:18','2026-05-20 14:16:15'),
(7567945,43,'2026-05-18',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:20','2026-05-20 14:16:17'),
(7567946,43,'2026-05-18',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:20','2026-05-20 14:16:17'),
(7567947,43,'2026-05-18',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:20','2026-05-20 14:16:17'),
(7568125,44,'2026-05-18',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:22','2026-05-20 14:16:19'),
(7568126,44,'2026-05-18',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:22','2026-05-20 14:16:19'),
(7568127,44,'2026-05-18',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:22','2026-05-20 14:16:19'),
(7569607,58,'2026-05-18',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:46','2026-05-20 14:01:41'),
(7569608,58,'2026-05-18',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:46','2026-05-20 14:01:41'),
(7569609,58,'2026-05-18',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:46','2026-05-20 14:01:41'),
(7569811,59,'2026-05-18',1,0,NULL,0,NULL,NULL,NULL,0,NULL,0.06,NULL,0,'négatif','2026-05-18 08:31:48','2026-05-20 14:01:45'),
(7569812,59,'2026-05-18',5,0,NULL,0,NULL,NULL,NULL,0,NULL,0.06,NULL,0,'négatif','2026-05-18 08:31:48','2026-05-20 14:01:45'),
(7569813,59,'2026-05-18',10,0,NULL,0,NULL,NULL,NULL,0,NULL,0.06,NULL,0,'négatif','2026-05-18 08:31:48','2026-05-20 14:01:45'),
(7570443,61,'2026-05-18',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:54','2026-05-20 14:01:48'),
(7570444,61,'2026-05-18',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:54','2026-05-20 14:01:48'),
(7570445,61,'2026-05-18',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:54','2026-05-20 14:01:48'),
(7570527,62,'2026-05-18',1,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:56','2026-05-20 14:01:50'),
(7570528,62,'2026-05-18',5,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:56','2026-05-20 14:01:50'),
(7570529,62,'2026-05-18',10,NULL,NULL,NULL,NULL,300,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 08:31:56','2026-05-20 14:01:50'),
(7570563,63,'2026-05-18',1,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-18 08:31:58','2026-05-20 14:01:52'),
(7570564,63,'2026-05-18',5,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-18 08:31:58','2026-05-20 14:01:52'),
(7570565,63,'2026-05-18',10,0,NULL,0,NULL,600,NULL,0,NULL,0,NULL,1,'positif','2026-05-18 08:31:58','2026-05-20 14:01:52'),
(7718016,13,'2026-05-18',1,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 13:15:25','2026-05-20 14:15:26'),
(7718017,13,'2026-05-18',5,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 13:15:25','2026-05-20 14:15:26'),
(7718018,13,'2026-05-18',10,NULL,NULL,NULL,NULL,160,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-18 13:15:25','2026-05-20 14:15:26'),
(7719669,24,'2026-05-18',1,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-18 13:15:45','2026-05-20 14:15:45'),
(7719670,24,'2026-05-18',5,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-18 13:15:45','2026-05-20 14:15:45'),
(7719671,24,'2026-05-18',10,NULL,NULL,NULL,NULL,120,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-18 13:15:45','2026-05-20 14:15:45'),
(8050309,17,'2026-05-19',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:30:33','2026-05-20 14:15:33'),
(8050310,17,'2026-05-19',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:30:33','2026-05-20 14:15:33'),
(8050311,17,'2026-05-19',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:30:33','2026-05-20 14:15:33'),
(8054188,51,'2026-05-19',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:30','2026-05-20 14:01:29'),
(8054189,51,'2026-05-19',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:30','2026-05-20 14:01:29'),
(8054190,51,'2026-05-19',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:30','2026-05-20 14:01:29'),
(8054446,53,'2026-05-19',1,0,NULL,0,NULL,300,NULL,0,NULL,0,NULL,1,'positif','2026-05-19 08:31:33','2026-05-20 14:01:32'),
(8054447,53,'2026-05-19',5,0,NULL,0,NULL,300,NULL,0,NULL,0,NULL,1,'positif','2026-05-19 08:31:33','2026-05-20 14:01:32'),
(8054448,53,'2026-05-19',10,0,NULL,0,NULL,300,NULL,0,NULL,0,NULL,1,'positif','2026-05-19 08:31:33','2026-05-20 14:01:32'),
(8054671,55,'2026-05-19',1,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:37','2026-05-20 14:01:36'),
(8054672,55,'2026-05-19',5,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:37','2026-05-20 14:01:36'),
(8054673,55,'2026-05-19',10,NULL,NULL,NULL,NULL,1000,NULL,NULL,NULL,NULL,NULL,1,'positif','2026-05-19 08:31:37','2026-05-20 14:01:36'),
(8562852,6,'2026-05-20',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:12','2026-05-20 14:15:12'),
(8562853,6,'2026-05-20',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:12','2026-05-20 14:15:12'),
(8562854,6,'2026-05-20',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:12','2026-05-20 14:15:12'),
(8563050,7,'2026-05-20',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:14','2026-05-20 14:15:14'),
(8563051,7,'2026-05-20',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:14','2026-05-20 14:15:14'),
(8563052,7,'2026-05-20',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:14','2026-05-20 14:15:14'),
(8566119,32,'2026-05-20',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:58','2026-05-20 14:15:57'),
(8566120,32,'2026-05-20',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:58','2026-05-20 14:15:57'),
(8566121,32,'2026-05-20',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:30:58','2026-05-20 14:15:57'),
(8566536,35,'2026-05-20',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:31:03','2026-05-20 14:16:03'),
(8566537,35,'2026-05-20',5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:31:03','2026-05-20 14:16:03'),
(8566538,35,'2026-05-20',10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'négatif','2026-05-20 09:31:03','2026-05-20 14:16:03');
/*!40000 ALTER TABLE `analyses_releves` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `analyses_sites`
--

DROP TABLE IF EXISTS `analyses_sites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `analyses_sites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) NOT NULL,
  `nom_poligono` varchar(100) DEFAULT NULL,
  `code_site` varchar(20) DEFAULT NULL,
  `ordre` int(11) NOT NULL,
  `id_zone` int(10) unsigned NOT NULL,
  `plan_psp` varchar(20) DEFAULT NULL,
  `plan_lipophile` varchar(20) DEFAULT NULL,
  `plan_asp` varchar(20) DEFAULT NULL,
  `etat_administratif` tinyint(1) NOT NULL DEFAULT 0,
  `date_changement_etat` date DEFAULT NULL,
  `plan` varchar(10) DEFAULT NULL,
  `toxines` varchar(255) DEFAULT NULL,
  `svg_id` varchar(20) DEFAULT NULL,
  `id_site` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_sites_ordre` (`ordre`),
  KEY `idx_sites_zone` (`id_zone`),
  CONSTRAINT `fk_sites_zone` FOREIGN KEY (`id_zone`) REFERENCES `analyses_zones` (`id_zone`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `analyses_sites`
--

LOCK TABLES `analyses_sites` WRITE;
/*!40000 ALTER TABLE `analyses_sites` DISABLE KEYS */;
INSERT INTO `analyses_sites` VALUES
(1,'Baiona A','Baiona A','BAIONA-A',29,17,NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','site-1',1),
(2,'Ribeira B','Ribeira B','RIBEIR-B',3,1,NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','site-2',56),
(3,'Ribeira C','Ribeira C','RIBEIR-C',5,1,NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','site-3',57),
(4,'A Pobra H','A Pobra H','PUEBLA-H',7,2,NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','site-4',49),
(5,'A Pobra G','A Pobra G','PUEBLA-G',11,2,NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','site-5',48),
(6,'A Pobra A','A Pobra A','PUEBLA-A',8,2,NULL,NULL,NULL,1,'2026-05-12','C1','Lipofílicas','site-6',42),
(8,'A Pobra C','A Pobra C','PUEBLA-C',15,3,NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','site-8',44),
(9,'A Pobra D','A Pobra D','PUEBLA-D',18,4,NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','site-9',45),
(10,'A Pobra E','A Pobra E','PUEBLA-E',22,4,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-10',46),
(11,'Vilagarcia A','Vilagarcía A','VILLAG-A',34,5,NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','site-11',63),
(12,'Vilagarcia B','Vilagarcía B1','VILLAG-B',31,6,NULL,NULL,NULL,1,'2026-05-08','C1','Lipofílicas','site-12',64),
(13,'Cambados A1','Cambados A1','CAMBA-A1',21,6,NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','site-13',6),
(16,'Cambados C Nord','Cambados C (Norte)','CAMBA-CN',14,8,NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','site-16',8),
(17,'Cambados C Sud','Cambados C (Sur)','CAMBA-CS',16,8,NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','site-17',9),
(18,'Cambados B','Cambados B','CAMBAD-B',19,8,NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','site-18',10),
(19,'Cambados E','Cambados A2,E','CAMBAD-E',20,8,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-15',12),
(20,'Cambados D','Cambados D','CAMBAD-D',24,9,NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','site-20',11),
(21,'Grove A','Grove A','GROVE-A',25,9,NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','site-21',23),
(22,'Grove C1','Grove C1','GROVE-C1',10,10,NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','site-22',27),
(23,'Grove C2','Grove C2','GROVE-C2',9,10,NULL,NULL,NULL,1,'2026-04-24','C1','Lipofílicas','site-23',28),
(24,'Grove C3','Grove C3','GROVE-C3',17,10,NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','site-24',29),
(25,'Grove C4','Grove C4','GROVE-C4',13,10,NULL,NULL,NULL,1,'2026-04-24','C1','Lipofílicas','site-25',30),
(26,'Grove B','Grove B (F) (Ostra)','GROVE-B',27,11,NULL,NULL,NULL,1,'2016-04-06','CC','Cautelar','site-26',25),
(27,'Cangas A','Cangas A','CANGAS-A',32,25,NULL,NULL,NULL,1,'2026-04-23','C1','Lipofílicas','site-27',14),
(28,'Cangas B','Cangas B','CANGAS-B',28,25,NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','site-28',15),
(29,'Cangas F','Cangas F','CANGAS-F',30,12,NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','site-29',19),
(30,'Cangas G','Cangas G','CANGAS-G',33,12,NULL,NULL,NULL,1,'2026-04-25','C1','Lipofílicas','site-30',20),
(31,'Cangas H','Cangas H','CANGAS-H',35,12,NULL,NULL,NULL,1,'2026-04-27','C1','Lipofílicas','site-31',21),
(32,'Cangas C','Cangas C','CANGAS-C',42,13,NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','site-32',16),
(33,'Cangas D','Cangas D','CANGAS-D',43,13,NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','site-33',17),
(34,'Cangas E','Cangas E','CANGAS-E',44,14,NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','site-34',18),
(35,'Redondela A','Redondela A','REDOND-A',46,14,NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','site-35',51),
(36,'Redondela B','Redondela B','REDOND-B',49,15,NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','site-36',52),
(37,'Redondela C','Redondela C','REDOND-C',50,15,NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','site-37',53),
(38,'Vigo A','Vigo A','VIGO-A',45,16,NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','site-38',60),
(39,'Redondela D','Redondela D','REDOND-D',48,16,NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','site-39',54),
(40,'Redondela E','Redondela E','REDOND-E',47,16,NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','site-40',55),
(41,'Muros C','Muros C','MUROS-C',1,22,NULL,NULL,NULL,1,'2026-03-10','CC','Cautelar','site-41',34),
(42,'Muros B','Muros B','MUROS-B',2,19,NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','site-42',33),
(43,'Muros A','Muros A','MUROS-A',4,20,NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','site-43',32),
(44,'Moia A','Moia A','NOIA-A',6,21,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-44',35),
(45,'Sada 1','Sada 1','SADA-A',51,23,NULL,NULL,NULL,1,'2026-05-18','C1','Lipofílicas','site-45',58),
(46,'Sada 2','Sada 2','SADA-B',52,23,NULL,NULL,NULL,1,'2026-05-18','CC','Cautelar','site-46',59),
(47,'Sada 2','Sada 2','SADA-B',53,24,NULL,NULL,NULL,1,'2026-05-18','CC','Cautelar','site-47',59),
(48,'Bueu B','Bueu B','BUEU-B',36,26,NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','site-48',4),
(49,'Bueu A1','Bueu A1','BUEU-A1',38,26,NULL,NULL,NULL,1,'2026-04-13','C1','Lipofílicas','site-49',2),
(50,'Bueu A2','Bueu A2','BUEU-A2',37,26,NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','site-50',3),
(51,'Portonovo A','Portonovo A','PORTON-A',41,27,NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','site-51',36),
(52,'Portonovo B','Portonovo B','PORTON-B',40,27,NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','site-52',37),
(53,'Portonovo C','Portonovo C','PORTON-C',39,27,NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','site-53',38),
(54,'Cambados E2','Cambados E2','CAMBAD-E',20,6,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-15',12),
(55,'Camariñas A','Camariñas A','CAMARI-A',5,999,NULL,NULL,NULL,1,'2026-03-10','C1','Lipofílicas',NULL,5),
(56,'Cambados A2','Cambados A2','CAMBA-A2',7,6,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-14',7),
(57,'Cambados D (Ostra)','Cambados D (Ostra)','CAMBA-DO',13,8,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-20',13),
(58,'Corme B','Corme B','CORME-B',22,999,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,22),
(59,'Grove A (Ostra)','Grove A (Ostra)','GROVE-AO',24,999,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-21',24),
(60,'Grove B (F) (Ostra)','Grove B (F) (Ostra)','GROVE-BO',26,11,NULL,NULL,NULL,1,'2016-04-06','CC','Cautelar','site-26',26),
(61,'Grove Reparqueo','Grove Reparqueo','GROVE-R',31,999,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,31),
(62,'Portonovo D','Portonovo D','PORTON-D',39,999,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,39),
(63,'A Pobra E.1','A Pobra E.1','PUEB-E1',40,4,NULL,NULL,NULL,1,'2026-05-12','C1','Lipofílicas','site-10',40),
(64,'A Pobra E.2','A Pobra E.2','PUEB-E2',41,4,NULL,NULL,NULL,1,'2026-05-09','C1','Lipofílicas','site-10',41),
(65,'A Pobra B','A Pobra B','PUEBLA-B',43,3,NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','site-7',43),
(66,'A Pobra F','A Pobra F','PUEBLA-F',47,999,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,47),
(67,'Redondela A (Ostra)','Redondela A (Ostra)','REDON-AO',50,14,NULL,NULL,NULL,0,NULL,NULL,NULL,'site-35',50),
(68,'Vilagarcía B1','Vilagarcía B1','VILLA-B1',61,6,NULL,NULL,NULL,1,'2026-05-08','C1','Lipofílicas','site-12',61),
(69,'Vilagarcía B2','Vilagarcía B2','VILLA-B2',62,6,NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','site-12',62);
/*!40000 ALTER TABLE `analyses_sites` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `analyses_sites_historique`
--

DROP TABLE IF EXISTS `analyses_sites_historique`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `analyses_sites_historique` (
  `id_historique` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_site` int(10) unsigned NOT NULL,
  `date_document` date NOT NULL,
  `heure_document` time DEFAULT NULL,
  `plan_psp` varchar(20) DEFAULT NULL,
  `plan_lipophile` varchar(20) DEFAULT NULL,
  `plan_asp` varchar(20) DEFAULT NULL,
  `etat_administratif` tinyint(1) NOT NULL,
  `date_changement_etat` date NOT NULL,
  `plan` varchar(10) DEFAULT NULL,
  `toxines` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id_historique`),
  KEY `idx_hist_site` (`id_site`),
  KEY `idx_hist_date_doc` (`date_document`),
  CONSTRAINT `fk_hist_site` FOREIGN KEY (`id_site`) REFERENCES `analyses_sites` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=182 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `analyses_sites_historique`
--

LOCK TABLES `analyses_sites_historique` WRITE;
/*!40000 ALTER TABLE `analyses_sites_historique` DISABLE KEYS */;
INSERT INTO `analyses_sites_historique` VALUES
(2,45,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(3,42,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(4,43,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-28','C1','Lipofílicas','2025-12-02 15:29:25'),
(5,41,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-25','C1','Lipofílicas','2025-12-02 15:29:25'),
(6,2,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-29','C1','Lipofílicas','2025-12-02 15:29:25'),
(7,3,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-30','C1','Lipofílicas','2025-12-02 15:29:25'),
(8,4,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-29','C1','Lipofílicas','2025-12-02 15:29:25'),
(9,5,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-10','C1','Lipofílicas','2025-12-02 15:29:25'),
(10,6,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-17','C1','Lipofílicas','2025-12-02 15:29:25'),
(11,65,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-10','C1','Lipofílicas','2025-12-02 15:29:25'),
(12,8,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-13','C1','Lipofílicas','2025-12-02 15:29:25'),
(13,9,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-11','C1','Lipofílicas','2025-12-02 15:29:25'),
(14,64,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-11','C3','Lipofílicas','2025-12-02 15:29:25'),
(15,12,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-14','C3','Lipofílicas','2025-12-02 15:29:25'),
(16,68,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-14','C3','Lipofílicas','2025-12-02 15:29:25'),
(17,69,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-17','C3','Lipofílicas','2025-12-02 15:29:25'),
(18,13,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-10','C1','Lipofílicas','2025-12-02 15:29:25'),
(19,18,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-03','C1','Lipofílicas','2025-12-02 15:29:25'),
(20,16,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-27','C1','Lipofílicas','2025-12-02 15:29:25'),
(21,17,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-28','C1','Lipofílicas','2025-12-02 15:29:25'),
(22,20,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-07','C3','Lipofílicas','2025-12-02 15:29:25'),
(23,21,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-04','C1','Lipofílicas','2025-12-02 15:29:25'),
(24,26,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2016-04-06','CC','Cautelar','2025-12-02 15:29:25'),
(25,60,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2016-04-06','CC','Cautelar','2025-12-02 15:29:25'),
(26,22,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-30','C1','Lipofílicas','2025-12-02 15:29:25'),
(27,23,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-27','C1','Lipofílicas','2025-12-02 15:29:25'),
(28,24,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-28','C1','Lipofílicas','2025-12-02 15:29:25'),
(29,25,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-25','C1','Lipofílicas','2025-12-02 15:29:25'),
(30,27,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-08-21','C1','Lipofílicas','2025-12-02 15:29:25'),
(31,28,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-08-21','C1','Lipofílicas','2025-12-02 15:29:25'),
(32,48,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-08-22','C1','Lipofílicas','2025-12-02 15:29:25'),
(33,50,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-08-22','C1','Lipofílicas','2025-12-02 15:29:25'),
(34,49,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-08-01','C1','Lipofílicas','2025-12-02 15:29:25'),
(35,51,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(36,52,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(37,53,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(38,29,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(39,30,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-24','C1','Lipofílicas','2025-12-02 15:29:25'),
(40,31,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-25','C1','Lipofílicas','2025-12-02 15:29:25'),
(41,32,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-28','C1','Lipofílicas','2025-12-02 15:29:25'),
(42,33,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-01','C1','Lipofílicas','2025-12-02 15:29:25'),
(43,34,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-07','C1','Lipofílicas','2025-12-02 15:29:25'),
(44,35,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-07','C1','Lipofílicas','2025-12-02 15:29:25'),
(45,40,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-07','C3','Lipofílicas','2025-12-02 15:29:25'),
(46,38,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-11-01','C1','Lipofílicas','2025-12-02 15:29:25'),
(47,1,'2025-12-02','09:28:00',NULL,NULL,NULL,1,'2025-10-25','C1','Lipofílicas','2025-12-02 15:29:25'),
(48,46,'2025-12-02','15:45:00',NULL,NULL,NULL,0,'2025-05-24','B3',NULL,'2025-12-02 16:16:03'),
(49,47,'2025-12-02','15:45:00',NULL,NULL,NULL,0,'2025-05-24','B3',NULL,'2025-12-02 16:16:03'),
(50,55,'2025-12-02','15:45:00',NULL,NULL,NULL,0,'2025-11-25','B1',NULL,'2025-12-02 16:16:03'),
(51,63,'2026-05-12','14:15:00',NULL,NULL,NULL,0,'2025-11-29','B3',NULL,'2025-12-02 16:16:03'),
(52,11,'2026-05-11','14:24:00',NULL,NULL,NULL,0,'2025-11-29','B2',NULL,'2025-12-02 16:16:03'),
(53,36,'2026-05-06','14:28:00',NULL,NULL,NULL,0,'2025-11-28','B2',NULL,'2025-12-02 16:16:03'),
(54,37,'2026-05-06','14:28:00',NULL,NULL,NULL,0,'2025-11-28','B2',NULL,'2025-12-02 16:16:03'),
(55,39,'2026-05-06','21:16:00',NULL,NULL,NULL,0,'2025-11-28','B2',NULL,'2025-12-02 16:16:03'),
(56,12,'2026-05-08','15:31:00',NULL,NULL,NULL,0,'2025-12-02','B3',NULL,'2025-12-02 19:01:44'),
(57,68,'2026-05-08','15:31:00',NULL,NULL,NULL,0,'2025-12-02','B3',NULL,'2025-12-02 19:01:44'),
(58,69,'2026-05-11','14:24:00',NULL,NULL,NULL,0,'2025-12-02','B2',NULL,'2025-12-02 19:01:44'),
(59,45,'2025-12-04','09:55:00',NULL,NULL,NULL,0,'2025-12-04','D',NULL,'2025-12-04 10:01:47'),
(60,6,'2026-05-11','20:15:00',NULL,NULL,NULL,0,'2025-12-04','B2',NULL,'2025-12-04 10:01:47'),
(61,8,'2026-05-11','14:24:00',NULL,NULL,NULL,0,'2025-12-04','B3',NULL,'2025-12-04 10:01:47'),
(62,13,'2025-12-06','09:26:00',NULL,NULL,NULL,0,'2025-12-06','D',NULL,'2025-12-06 10:01:46'),
(63,40,'2026-05-06','14:28:00',NULL,NULL,NULL,0,'2025-12-06','B2',NULL,'2025-12-06 10:01:46'),
(64,9,'2025-12-13','09:58:00',NULL,NULL,NULL,0,'2025-12-13','D',NULL,'2025-12-13 10:01:47'),
(65,43,'2025-12-16','09:51:00',NULL,NULL,NULL,0,'2025-12-16','D',NULL,'2025-12-16 10:01:49'),
(66,64,'2026-05-08','20:16:00',NULL,NULL,NULL,0,'2025-12-16','B3',NULL,'2025-12-16 10:01:49'),
(67,20,'2025-12-16','09:51:00',NULL,NULL,NULL,0,'2025-12-16','D',NULL,'2025-12-16 10:01:49'),
(68,34,'2025-12-16','09:51:00',NULL,NULL,NULL,0,'2025-12-16','D',NULL,'2025-12-16 10:01:49'),
(69,35,'2026-05-06','14:28:00',NULL,NULL,NULL,0,'2025-12-16','B2',NULL,'2025-12-16 10:01:49'),
(70,4,'2025-12-18','09:32:00',NULL,NULL,NULL,0,'2025-12-18','D',NULL,'2025-12-18 10:01:45'),
(71,5,'2026-05-11','14:24:00',NULL,NULL,NULL,0,'2025-12-18','B3',NULL,'2025-12-18 10:01:45'),
(72,65,'2026-05-09','09:27:00',NULL,NULL,NULL,0,'2025-12-18','B3',NULL,'2025-12-18 10:01:45'),
(73,4,'0001-01-01','00:00:00',NULL,NULL,NULL,1,'2025-12-19','C1','Cautelar','2025-12-20 09:01:44'),
(74,41,'2025-12-20','09:26:00',NULL,NULL,NULL,0,'2025-12-20','D',NULL,'2025-12-20 10:01:44'),
(75,32,'2025-12-23','09:08:00',NULL,NULL,NULL,0,'2025-12-23','D',NULL,'2025-12-23 10:01:50'),
(76,33,'2025-12-23','09:08:00',NULL,NULL,NULL,0,'2025-12-23','D',NULL,'2025-12-23 10:01:50'),
(77,2,'2025-12-27','09:01:00',NULL,NULL,NULL,0,'2025-12-27','B1',NULL,'2025-12-27 09:01:48'),
(78,3,'2025-12-27','09:01:00',NULL,NULL,NULL,0,'2025-12-27','B1',NULL,'2025-12-27 09:01:48'),
(79,4,'2025-12-27','09:01:00',NULL,NULL,NULL,0,'2025-12-27','D',NULL,'2025-12-27 09:01:48'),
(80,18,'2025-12-27','09:01:00',NULL,NULL,NULL,0,'2025-12-27','D',NULL,'2025-12-27 09:01:48'),
(81,38,'2025-12-27','09:01:00',NULL,NULL,NULL,0,'2025-12-27','D',NULL,'2025-12-27 09:01:48'),
(82,13,'2025-12-30','15:08:00',NULL,NULL,NULL,1,'2025-12-29','C3','Lipofílicas','2025-12-30 19:01:47'),
(83,17,'2025-12-30','15:08:00',NULL,NULL,NULL,0,'2025-12-30','D',NULL,'2025-12-30 19:01:47'),
(84,9,'2026-01-02','08:14:00',NULL,NULL,NULL,1,'2026-01-02','C1','Cautelar','2026-01-02 09:01:48'),
(85,32,'2026-01-02','08:14:00',NULL,NULL,NULL,1,'2026-01-02','C1','Cautelar','2026-01-02 09:01:48'),
(86,33,'2026-01-02','08:14:00',NULL,NULL,NULL,1,'2026-01-02','C1','Cautelar','2026-01-02 09:01:48'),
(87,17,'2026-01-02','20:42:00',NULL,NULL,NULL,1,'2026-01-02','C1','Cautelar','2026-01-03 09:01:49'),
(88,42,'2026-01-03','10:41:00',NULL,NULL,NULL,0,'2026-01-03','B1',NULL,'2026-01-03 19:01:48'),
(89,3,'2026-01-03','10:41:00',NULL,NULL,NULL,1,'2026-01-03','C1','Cautelar','2026-01-03 19:01:48'),
(90,9,'2026-05-07','13:49:00',NULL,NULL,NULL,0,'2026-01-03','B3',NULL,'2026-01-03 19:01:48'),
(91,18,'2026-01-03','10:41:00',NULL,NULL,NULL,1,'2026-01-03','C1','Cautelar','2026-01-03 19:01:48'),
(92,20,'2026-01-03','10:41:00',NULL,NULL,NULL,1,'2026-01-03','C1','Cautelar','2026-01-03 19:01:48'),
(93,38,'2026-01-03','10:41:00',NULL,NULL,NULL,1,'2026-01-03','C1','Cautelar','2026-01-03 19:01:48'),
(94,16,'2026-01-05','20:32:00',NULL,NULL,NULL,0,'2026-01-05','B3',NULL,'2026-01-06 09:02:31'),
(95,21,'2026-01-05','20:32:00',NULL,NULL,NULL,0,'2026-01-05','B3',NULL,'2026-01-06 09:02:31'),
(96,3,'2026-01-07','09:24:00',NULL,NULL,NULL,0,'2026-01-06','B2',NULL,'2026-01-07 10:01:45'),
(97,18,'2026-05-06','21:16:00',NULL,NULL,NULL,0,'2026-01-06','B3',NULL,'2026-01-07 10:01:45'),
(98,16,'2026-01-07','09:24:00',NULL,NULL,NULL,0,'2026-01-06','D',NULL,'2026-01-07 10:01:45'),
(99,20,'2026-01-07','09:24:00',NULL,NULL,NULL,0,'2026-01-06','B1',NULL,'2026-01-07 10:01:45'),
(100,21,'2026-01-07','09:24:00',NULL,NULL,NULL,0,'2026-01-06','D',NULL,'2026-01-07 10:01:45'),
(101,38,'2026-01-08','09:50:00',NULL,NULL,NULL,0,'2026-01-08','D',NULL,'2026-01-08 10:01:47'),
(102,33,'2026-01-13','08:49:00',NULL,NULL,NULL,0,'2026-01-13','D',NULL,'2026-01-13 09:01:47'),
(103,13,'2026-05-06','14:28:00',NULL,NULL,NULL,0,'2026-01-14','B3',NULL,'2026-01-14 09:01:48'),
(104,17,'2026-01-14','08:45:00',NULL,NULL,NULL,0,'2026-01-14','D',NULL,'2026-01-14 09:01:48'),
(105,22,'2026-01-15','08:17:00',NULL,NULL,NULL,0,'2026-01-15','D',NULL,'2026-01-15 09:01:50'),
(106,24,'2026-01-19','08:34:00',NULL,NULL,NULL,0,'2026-01-17','D',NULL,'2026-01-19 09:01:45'),
(107,32,'2026-01-19','08:34:00',NULL,NULL,NULL,0,'2026-01-17','D',NULL,'2026-01-19 09:01:45'),
(108,51,'2026-01-22','09:03:00',NULL,NULL,NULL,0,'2026-01-22','D',NULL,'2026-01-22 10:01:46'),
(109,25,'2026-01-27','09:31:00',NULL,NULL,NULL,0,'2026-01-27','D',NULL,'2026-01-27 10:01:45'),
(110,53,'2026-01-29','09:02:00',NULL,NULL,NULL,0,'2026-01-29','D',NULL,'2026-01-29 19:01:46'),
(111,52,'2026-01-30','08:51:00',NULL,NULL,NULL,0,'2026-01-30','D',NULL,'2026-01-30 09:01:48'),
(112,27,'2026-01-31','08:43:00',NULL,NULL,NULL,0,'2026-01-31','D',NULL,'2026-01-31 09:01:48'),
(113,28,'2026-01-31','08:43:00',NULL,NULL,NULL,0,'2026-01-31','D',NULL,'2026-01-31 09:01:48'),
(114,23,'2026-02-03','09:29:00',NULL,NULL,NULL,0,'2026-02-03','D',NULL,'2026-02-03 10:01:47'),
(115,50,'2026-02-03','09:29:00',NULL,NULL,NULL,0,'2026-02-03','D',NULL,'2026-02-03 10:01:47'),
(116,49,'2026-02-03','09:29:00',NULL,NULL,NULL,0,'2026-02-03','D',NULL,'2026-02-03 10:01:47'),
(117,48,'2026-02-05','08:21:00',NULL,NULL,NULL,0,'2026-02-05','B1',NULL,'2026-02-05 09:01:53'),
(118,29,'2026-02-07','08:27:00',NULL,NULL,NULL,0,'2026-02-07','D',NULL,'2026-02-07 09:01:50'),
(119,31,'2026-02-07','08:27:00',NULL,NULL,NULL,0,'2026-02-07','D',NULL,'2026-02-07 09:01:50'),
(120,30,'2026-02-13','10:26:00',NULL,NULL,NULL,0,'2026-02-13','B1',NULL,'2026-02-13 19:01:53'),
(121,1,'2026-02-18','09:52:00',NULL,NULL,NULL,0,'2026-02-18','B1',NULL,'2026-02-18 10:01:50'),
(122,26,'2026-02-18','15:18:00',NULL,NULL,NULL,0,'2026-02-17','A',NULL,'2026-02-18 19:01:50'),
(123,60,'2026-02-18','15:18:00',NULL,NULL,NULL,0,'2026-02-17','A',NULL,'2026-02-18 19:01:50'),
(124,55,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-03-10','C1','Lipofílicas','2026-03-11 10:02:14'),
(125,41,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-03-10','CC','Cautelar','2026-03-11 10:02:14'),
(126,45,'2026-05-05','20:40:00',NULL,NULL,NULL,1,'2026-04-14','C3','PSP','2026-04-21 14:49:41'),
(127,46,'2026-05-06','21:16:00',NULL,NULL,NULL,1,'2026-04-14','C3','PSP','2026-04-21 14:49:41'),
(128,47,'2026-05-06','21:16:00',NULL,NULL,NULL,1,'2026-04-14','C3','PSP','2026-04-21 14:49:41'),
(129,42,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','2026-04-21 14:49:41'),
(130,43,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','2026-04-21 14:49:41'),
(131,28,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','2026-04-21 14:49:41'),
(132,48,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','2026-04-21 14:49:41'),
(133,50,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-14','C1','Lipofílicas','2026-04-21 14:49:41'),
(134,49,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-13','C1','Lipofílicas','2026-04-21 14:49:41'),
(135,51,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','2026-04-21 14:49:41'),
(136,52,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','2026-04-21 14:49:41'),
(137,53,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','2026-04-21 14:49:41'),
(138,29,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-20','C1','Lipofílicas','2026-04-21 14:49:41'),
(139,27,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-23','C1','Lipofílicas','2026-04-23 10:01:59'),
(140,23,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-24','C1','Lipofílicas','2026-04-25 09:01:56'),
(141,25,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-24','C1','Lipofílicas','2026-04-25 09:01:56'),
(142,30,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-25','C1','Lipofílicas','2026-04-25 10:01:52'),
(143,31,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-27','C1','Lipofílicas','2026-04-27 09:01:57'),
(144,22,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','2026-04-28 10:01:54'),
(145,24,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','2026-04-28 10:01:54'),
(146,3,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-28','C1','Lipofílicas','2026-04-29 09:01:58'),
(147,21,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','2026-04-30 10:01:11'),
(148,2,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','2026-05-04 09:02:08'),
(149,4,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','2026-05-04 09:02:08'),
(150,16,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','2026-05-04 09:02:08'),
(151,17,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','2026-05-04 09:02:08'),
(152,20,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','2026-05-04 09:02:08'),
(153,32,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','2026-05-04 09:02:08'),
(154,33,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','2026-05-04 09:02:08'),
(155,38,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-04-30','C1','Lipofílicas','2026-05-04 09:02:09'),
(156,1,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-01','C1','Lipofílicas','2026-05-04 09:02:09'),
(157,34,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-04','C1','Lipofílicas','2026-05-05 09:02:15'),
(158,45,'2026-05-16','08:33:00',NULL,NULL,NULL,0,'2026-05-06','B3',NULL,'2026-05-06 10:02:11'),
(159,13,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','2026-05-07 09:01:58'),
(160,35,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','2026-05-07 09:01:59'),
(161,36,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','2026-05-07 09:01:59'),
(162,37,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','2026-05-07 09:01:59'),
(163,40,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-06','C1','Lipofílicas','2026-05-07 09:01:59'),
(164,46,'2026-05-18','19:14:00',NULL,NULL,NULL,0,'2026-05-07','B3',NULL,'2026-05-07 10:02:01'),
(165,47,'2026-05-18','19:14:00',NULL,NULL,NULL,0,'2026-05-07','B3',NULL,'2026-05-07 10:02:01'),
(166,18,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','2026-05-07 10:02:01'),
(167,39,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','2026-05-07 10:02:01'),
(168,9,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-07','C1','Lipofílicas','2026-05-08 09:01:59'),
(169,12,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-08','C1','Lipofílicas','2026-05-09 09:01:58'),
(170,68,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-08','C1','Lipofílicas','2026-05-09 09:01:58'),
(171,64,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-09','C1','Lipofílicas','2026-05-09 10:01:55'),
(172,65,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','2026-05-11 09:01:57'),
(173,5,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','2026-05-12 09:01:55'),
(174,8,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','2026-05-12 09:01:55'),
(175,11,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','2026-05-12 09:01:55'),
(176,69,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-11','C1','Lipofílicas','2026-05-12 09:01:55'),
(177,6,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-12','C1','Lipofílicas','2026-05-12 12:01:56'),
(178,63,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-12','C1','Lipofílicas','2026-05-12 21:01:55'),
(179,45,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-18','C1','Lipofílicas','2026-05-18 07:46:54'),
(180,46,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-18','CC','Cautelar','2026-05-18 19:31:57'),
(181,47,'2026-05-20','09:18:00',NULL,NULL,NULL,1,'2026-05-18','CC','Cautelar','2026-05-18 19:31:57');
/*!40000 ALTER TABLE `analyses_sites_historique` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `analyses_zones`
--

DROP TABLE IF EXISTS `analyses_zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `analyses_zones` (
  `id_zone` int(10) unsigned NOT NULL,
  `id_lieu` int(11) DEFAULT NULL,
  `nom` varchar(100) NOT NULL,
  `ordre` int(11) NOT NULL,
  `svg_id` varchar(20) DEFAULT NULL,
  `numero_zone` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_zone`),
  UNIQUE KEY `uq_zones_nom` (`nom`),
  KEY `idx_zones_ordre` (`ordre`),
  KEY `idx_analyses_zones_id_lieu` (`id_lieu`),
  CONSTRAINT `fk_analyses_zones_lieux` FOREIGN KEY (`id_lieu`) REFERENCES `lieux` (`id_lieu`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `analyses_zones`
--

LOCK TABLES `analyses_zones` WRITE;
/*!40000 ALTER TABLE `analyses_zones` DISABLE KEYS */;
INSERT INTO `analyses_zones` VALUES
(1,1,'L1Z1',3,'zone-1',1),
(2,1,'L1Z2',6,'zone-10',2),
(3,1,'L1Z3',7,'zone-14',3),
(4,1,'L1Z4',11,'zone-14',4),
(5,1,'L1Z5',18,'zone-15',5),
(6,1,'L1Z5-2',17,'zone-3',5),
(7,1,'L1Z6',10,'zone-17',6),
(8,1,'L1Z7',9,'zone-12',7),
(9,1,'L1Z8',13,'zone-18',8),
(10,1,'L1Z9',8,'zone-13',9),
(11,1,'L1Z10',12,'zone-2',10),
(12,2,'L2Z1',16,'zone-4',1),
(13,2,'L2Z2',21,'zone-5',2),
(14,2,'L2Z3',22,'zone-6',3),
(15,2,'L2Z4',24,'zone-7',4),
(16,2,'L2Z5',23,'zone-8',5),
(17,4,'L3Z1',14,'zone-9',1),
(19,5,'L4Z1',2,'zone-20',1),
(20,5,'L4Z2',4,'zone-21',2),
(21,5,'L4Z3',5,'zone-22',3),
(22,5,'L4Z4',1,'zone-19',4),
(23,6,'L5Z1',25,'zone-23',1),
(24,6,'L5Z2',26,'zone-24',2),
(25,3,'L6Z1',15,'zone-16',1),
(26,3,'L6Z2',19,'zone-25',2),
(27,3,'L6Z3',20,'zone-26',3),
(999,NULL,'Hors carte',999,NULL,NULL);
/*!40000 ALTER TABLE `analyses_zones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lieux`
--

DROP TABLE IF EXISTS `lieux`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lieux` (
  `id_lieu` int(11) NOT NULL AUTO_INCREMENT,
  `code_lieu` varchar(20) NOT NULL,
  `nom_lieu` varchar(100) NOT NULL,
  `ordre_lieu` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_lieu`),
  UNIQUE KEY `uq_lieux_code` (`code_lieu`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lieux`
--

LOCK TABLES `lieux` WRITE;
/*!40000 ALTER TABLE `lieux` DISABLE KEYS */;
INSERT INTO `lieux` VALUES
(1,'AROUSA','Ría de Arousa',4),
(2,'VIGO','Ría de Vigo',2),
(3,'PONTEVEDRA','Ría de Pontevedra',3),
(4,'BAIONA','Baiona',1),
(5,'MUROS','Ría de Muros e Noia',5),
(6,'BETANZOS','Ría de Betanzos',6);
/*!40000 ALTER TABLE `lieux` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sites2`
--

DROP TABLE IF EXISTS `sites2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sites2` (
  `id_site` int(11) NOT NULL AUTO_INCREMENT,
  `code_site` varchar(20) NOT NULL,
  `nom_site` varchar(100) NOT NULL,
  `id_zone` int(11) DEFAULT NULL,
  `ordre_site` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_site`),
  UNIQUE KEY `uq_sites_code` (`code_site`),
  KEY `idx_sites_zone` (`id_zone`),
  CONSTRAINT `fk_sites_zones` FOREIGN KEY (`id_zone`) REFERENCES `zones` (`id_zone`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sites2`
--

LOCK TABLES `sites2` WRITE;
/*!40000 ALTER TABLE `sites2` DISABLE KEYS */;
INSERT INTO `sites2` VALUES
(1,'BAIONA-A','Baiona A',NULL,1),
(2,'BUEU-A1','Bueu A1',NULL,2),
(3,'BUEU-A2','Bueu A2',NULL,3),
(4,'BUEU-B','Bueu B',NULL,4),
(5,'CAMARI-A','Camariñas A',NULL,5),
(6,'CAMBA-A1','Cambados A1',NULL,6),
(7,'CAMBA-A2','Cambados A2',NULL,7),
(8,'CAMBA-CN','Cambados C (Norte)',NULL,8),
(9,'CAMBA-CS','Cambados C (Sur)',NULL,9),
(10,'CAMBAD-B','Cambados B',NULL,10),
(11,'CAMBAD-D','Cambados D',NULL,11),
(12,'CAMBAD-E','Cambados E',NULL,12),
(13,'CAMBA-DO','Cambados D (Ostra)',NULL,13),
(14,'CANGAS-A','Cangas A',NULL,14),
(15,'CANGAS-B','Cangas B',NULL,15),
(16,'CANGAS-C','Cangas C',NULL,16),
(17,'CANGAS-D','Cangas D',NULL,17),
(18,'CANGAS-E','Cangas E',NULL,18),
(19,'CANGAS-F','Cangas F',NULL,19),
(20,'CANGAS-G','Cangas G',NULL,20),
(21,'CANGAS-H','Cangas H',NULL,21),
(22,'CORME-B','Corme B',NULL,22),
(23,'GROVE-A','Grove A',NULL,23),
(24,'GROVE-AO','Grove A (Ostra)',NULL,24),
(25,'GROVE-B','Grove B (F)',NULL,25),
(26,'GROVE-BO','Grove B (F) (Ostra)',NULL,26),
(27,'GROVE-C1','Grove C1',NULL,27),
(28,'GROVE-C2','Grove C2',NULL,28),
(29,'GROVE-C3','Grove C3',NULL,29),
(30,'GROVE-C4','Grove C4',NULL,30),
(31,'GROVE-R','Grove Reparqueo',NULL,31),
(32,'MUROS-A','Muros A',NULL,32),
(33,'MUROS-B','Muros B',NULL,33),
(34,'MUROS-C','Muros C',NULL,34),
(35,'NOIA-A','Noia A',NULL,35),
(36,'PORTON-A','Portonovo A',NULL,36),
(37,'PORTON-B','Portonovo B',NULL,37),
(38,'PORTON-C','Portonovo C',NULL,38),
(39,'PORTON-D','Portonovo D',NULL,39),
(40,'PUEB-E1','A Pobra E.1',NULL,40),
(41,'PUEB-E2','A Pobra E.2',NULL,41),
(42,'PUEBLA-A','A Pobra A',NULL,42),
(43,'PUEBLA-B','A Pobra B',NULL,43),
(44,'PUEBLA-C','A Pobra C',NULL,44),
(45,'PUEBLA-D','A Pobra D',NULL,45),
(46,'PUEBLA-E','A Pobra E',NULL,46),
(47,'PUEBLA-F','A Pobra F',NULL,47),
(48,'PUEBLA-G','A Pobra G',NULL,48),
(49,'PUEBLA-H','A Pobra H',NULL,49),
(50,'REDON-AO','Redondela A (Ostra)',NULL,50),
(51,'REDOND-A','Redondela A',NULL,51),
(52,'REDOND-B','Redondela B',NULL,52),
(53,'REDOND-C','Redondela C',NULL,53),
(54,'REDOND-D','Redondela D',NULL,54),
(55,'REDOND-E','Redondela E',NULL,55),
(56,'RIBEIR-B','Ribeira B',NULL,56),
(57,'RIBEIR-C','Ribeira C',NULL,57),
(58,'SADA-A','Sada 1',NULL,58),
(59,'SADA-B','Sada 2',NULL,59),
(60,'VIGO-A','Vigo A',NULL,60),
(61,'VILLA-B1','Vilagarcía B1',NULL,61),
(62,'VILLA-B2','Vilagarcía B2',NULL,62),
(63,'VILLAG-A','Vilagarcía A',NULL,63),
(64,'VILLAG-B','Vilagarcía B',NULL,64);
/*!40000 ALTER TABLE `sites2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `toxines_seuils`
--

DROP TABLE IF EXISTS `toxines_seuils`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `toxines_seuils` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `toxine` varchar(10) NOT NULL,
  `niveau` int(11) NOT NULL,
  `min_val` double DEFAULT NULL,
  `max_val` double DEFAULT NULL,
  `unite` varchar(20) NOT NULL,
  `couleur` varchar(20) NOT NULL,
  `est_positif` tinyint(1) NOT NULL DEFAULT 0,
  `valeur_defaut` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_toxine_niveau` (`toxine`,`niveau`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `toxines_seuils`
--

LOCK TABLES `toxines_seuils` WRITE;
/*!40000 ALTER TABLE `toxines_seuils` DISABLE KEYS */;
INSERT INTO `toxines_seuils` VALUES
(1,'PSP',0,0,0,'µg/kg','vert_clair',0,1),
(2,'PSP',1,0,200,'µg/kg','vert_fonce',0,1),
(3,'PSP',2,200,475,'µg/kg','jaune',0,1),
(4,'PSP',3,475,800,'µg/kg','orange',0,1),
(5,'PSP',4,800,NULL,'µg/kg','rouge',1,1),
(6,'ASP',0,0,0,'mg/kg','vert_clair',0,1),
(7,'ASP',1,0,2,'mg/kg','vert_fonce',0,1),
(8,'ASP',2,2,10,'mg/kg','jaune',0,1),
(9,'ASP',3,10,20,'mg/kg','orange',0,1),
(10,'ASP',4,20,NULL,'mg/kg','rouge',1,1),
(11,'AO',0,0,0,'µg/kg','vert_clair',0,1),
(12,'AO',1,0,80,'µg/kg','vert_fonce',0,1),
(13,'AO',2,80,120,'µg/kg','jaune',0,1),
(14,'AO',3,120,160,'µg/kg','orange',0,1),
(15,'AO',4,160,NULL,'µg/kg','rouge',1,1),
(16,'AZA',0,0,0,'µg/kg','vert_clair',0,1),
(17,'AZA',1,0,80,'µg/kg','vert_fonce',0,1),
(18,'AZA',2,80,120,'µg/kg','jaune',0,1),
(19,'AZA',3,120,160,'µg/kg','orange',0,1),
(20,'AZA',4,160,NULL,'µg/kg','rouge',1,1),
(21,'YTX',0,0,0,'mg/kg','vert_clair',0,1),
(22,'YTX',1,0,1,'mg/kg','vert_fonce',0,1),
(23,'YTX',2,1,2,'mg/kg','jaune',0,1),
(24,'YTX',3,2,3.75,'mg/kg','orange',0,1),
(25,'YTX',4,3.75,NULL,'mg/kg','rouge',1,1);
/*!40000 ALTER TABLE `toxines_seuils` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zones`
--

DROP TABLE IF EXISTS `zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zones` (
  `id_zone` int(11) NOT NULL AUTO_INCREMENT,
  `id_lieu` int(11) NOT NULL,
  `code_zone` varchar(20) NOT NULL,
  `nom_zone` varchar(100) NOT NULL,
  `ordre_zone` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id_zone`),
  UNIQUE KEY `uq_zones_code` (`code_zone`),
  KEY `idx_zones_lieu` (`id_lieu`),
  CONSTRAINT `fk_zones_lieux` FOREIGN KEY (`id_lieu`) REFERENCES `lieux` (`id_lieu`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zones`
--

LOCK TABLES `zones` WRITE;
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'analyses'
--

--
-- Dumping routines for database 'analyses'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-05-20 14:16:25
