--
-- Host: localhost    Database: laravel
-- ------------------------------------------------------


--
-- Table structure for table `boissons`
--

CREATE TABLE `boissons` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_stock` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `boissons_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `boissons`
--

INSERT INTO `boissons` VALUES (1,'🥤 Coca cola',1,'2026-03-01 18:02:11','2026-03-02 16:24:01'),(2,'🍊 Jus d\'orange',1,'2026-03-01 18:02:22','2026-03-02 16:25:21'),(3,'💧 Eau',1,'2026-03-01 18:02:35','2026-03-02 16:24:34'),(4,'☕️ Café',1,'2026-03-01 18:02:42','2026-03-02 16:23:19'),(5,'🌱 Tisane',1,'2026-03-01 18:03:40','2026-03-02 16:26:10'),(6,'🫖 Thé',1,'2026-03-01 18:03:45','2026-03-02 16:25:41'),(7,'🍋‍🟩 Fanta citron',1,'2026-03-01 18:05:03','2026-03-02 16:25:28'),(8,'🍊 Briquette de jus d\'orange',1,'2026-04-04 19:19:36','2026-04-04 19:19:36');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `job_batches`
--

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

--
-- Dumping data for table `job_batches`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_09_23_092744_create_seances_table',1),(5,'2025_09_23_094849_update_seances_add_seance_at',1),(6,'2025_09_24_205706_add_profile_fields_to_users_table',2),(7,'2025_09_25_115340_add_role_to_users_table',3),(8,'2025_09_25_120208_create_site_users_table',3),(9,'2025_09_25_120452_clean_users_table_for_filament',3),(10,'2025_09_25_160053_add_approval_fields_to_site_users_table',3),(11,'2026_02_28_100000_create_snacks_table',4),(12,'2026_02_28_100001_create_prestations_table',4),(13,'2026_02_28_100002_create_seance_packs_table',4),(14,'2026_02_28_100003_create_pack_snack_table',4),(15,'2026_02_28_100004_create_pack_prestation_table',4),(16,'2026_02_28_120000_add_price_to_seance_packs_table',4),(17,'2026_02_28_140000_add_unique_name_to_snacks_and_prestations',4),(18,'2026_02_28_170000_decouple_packs_from_seances',5),(19,'2026_02_28_180000_add_lieu_to_seances_table',5),(20,'2026_03_01_130000_create_reservations_tables',6),(21,'2026_03_01_140000_create_boissons_tables',7),(22,'2026_03_01_150000_add_special_requests_to_reservations_table',7),(23,'2026_03_01_160000_add_selection_rules_to_seance_packs_table',8),(24,'2026_03_06_120000_add_en_stock_to_snacks_and_boissons_tables',9);

--
-- Table structure for table `pack_boisson`
--

CREATE TABLE `pack_boisson` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seance_pack_id` bigint unsigned NOT NULL,
  `boisson_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pack_boisson_seance_pack_id_boisson_id_unique` (`seance_pack_id`,`boisson_id`),
  KEY `pack_boisson_boisson_id_foreign` (`boisson_id`),
  CONSTRAINT `pack_boisson_boisson_id_foreign` FOREIGN KEY (`boisson_id`) REFERENCES `boissons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pack_boisson_seance_pack_id_foreign` FOREIGN KEY (`seance_pack_id`) REFERENCES `seance_packs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pack_boisson`
--

INSERT INTO `pack_boisson` VALUES (4,6,3,NULL,NULL),(5,6,1,NULL,NULL),(6,6,2,NULL,NULL),(7,6,7,NULL,NULL),(8,3,3,NULL,NULL),(9,7,3,NULL,NULL),(10,7,7,NULL,NULL),(15,14,3,NULL,NULL),(16,14,7,NULL,NULL),(17,14,1,NULL,NULL),(18,8,3,NULL,NULL),(19,8,2,NULL,NULL),(24,10,3,NULL,NULL),(25,10,7,NULL,NULL),(26,10,2,NULL,NULL),(27,11,3,NULL,NULL),(28,11,7,NULL,NULL),(29,11,1,NULL,NULL),(30,11,2,NULL,NULL),(31,13,4,NULL,NULL),(32,13,1,NULL,NULL),(33,13,3,NULL,NULL),(34,13,7,NULL,NULL),(35,13,2,NULL,NULL),(36,13,6,NULL,NULL),(37,13,5,NULL,NULL),(38,12,3,NULL,NULL),(41,20,4,NULL,NULL),(42,20,1,NULL,NULL),(43,20,3,NULL,NULL),(44,20,7,NULL,NULL),(45,20,2,NULL,NULL),(46,20,6,NULL,NULL),(47,20,5,NULL,NULL);

--
-- Table structure for table `pack_prestation`
--

CREATE TABLE `pack_prestation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seance_pack_id` bigint unsigned NOT NULL,
  `prestation_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pack_prestation_seance_pack_id_prestation_id_unique` (`seance_pack_id`,`prestation_id`),
  KEY `pack_prestation_prestation_id_foreign` (`prestation_id`),
  CONSTRAINT `pack_prestation_prestation_id_foreign` FOREIGN KEY (`prestation_id`) REFERENCES `prestations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pack_prestation_seance_pack_id_foreign` FOREIGN KEY (`seance_pack_id`) REFERENCES `seance_packs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pack_prestation`
--

INSERT INTO `pack_prestation` VALUES (5,6,2,NULL,NULL),(6,6,3,NULL,NULL),(7,6,4,NULL,NULL),(8,7,2,NULL,NULL),(9,7,3,NULL,NULL),(10,7,4,NULL,NULL),(11,8,5,NULL,NULL),(14,10,4,NULL,NULL),(15,10,2,NULL,NULL),(16,11,2,NULL,NULL),(17,11,3,NULL,NULL),(18,11,5,NULL,NULL),(19,12,5,NULL,NULL),(20,13,2,NULL,NULL),(21,13,3,NULL,NULL),(22,13,4,NULL,NULL),(23,13,5,NULL,NULL),(24,14,2,NULL,NULL),(25,14,3,NULL,NULL),(28,13,6,NULL,NULL),(29,6,6,NULL,NULL),(32,11,6,NULL,NULL),(34,20,2,NULL,NULL),(35,20,3,NULL,NULL),(36,20,4,NULL,NULL),(37,20,6,NULL,NULL),(38,20,5,NULL,NULL);

--
-- Table structure for table `pack_seance`
--

CREATE TABLE `pack_seance` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seance_pack_id` bigint unsigned NOT NULL,
  `seance_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pack_seance_seance_pack_id_seance_id_unique` (`seance_pack_id`,`seance_id`),
  KEY `pack_seance_seance_id_foreign` (`seance_id`),
  CONSTRAINT `pack_seance_seance_id_foreign` FOREIGN KEY (`seance_id`) REFERENCES `seances` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pack_seance_seance_pack_id_foreign` FOREIGN KEY (`seance_pack_id`) REFERENCES `seance_packs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pack_seance`
--

INSERT INTO `pack_seance` VALUES (7,10,9,'2026-03-01 13:35:43','2026-03-01 13:35:43'),(8,11,9,'2026-03-01 13:35:43','2026-03-01 13:35:43'),(9,3,9,'2026-03-01 13:35:44','2026-03-01 13:35:44'),(10,14,9,'2026-03-01 13:48:27','2026-03-01 13:48:27'),(11,7,10,'2026-03-01 13:50:10','2026-03-01 13:50:10'),(12,13,10,'2026-03-01 13:50:11','2026-03-01 13:50:11'),(13,12,10,'2026-03-01 13:50:11','2026-03-01 13:50:11'),(15,6,10,'2026-03-01 13:50:11','2026-03-01 13:50:11'),(16,3,10,'2026-03-01 13:50:12','2026-03-01 13:50:12'),(17,3,11,'2026-03-01 13:52:29','2026-03-01 13:52:29'),(18,12,11,'2026-03-01 13:52:29','2026-03-01 13:52:29'),(20,6,11,'2026-03-01 13:52:29','2026-03-01 13:52:29'),(21,3,12,'2026-03-01 13:54:10','2026-03-01 13:54:10'),(22,7,12,'2026-03-01 13:54:10','2026-03-01 13:54:10'),(23,13,12,'2026-03-01 13:54:10','2026-03-01 13:54:10'),(24,12,12,'2026-03-01 13:54:10','2026-03-01 13:54:10'),(26,6,12,'2026-03-01 13:54:12','2026-03-01 13:54:12'),(29,3,13,'2026-03-01 13:57:10','2026-03-01 13:57:10'),(30,12,13,'2026-03-01 13:57:11','2026-03-01 13:57:11'),(38,3,15,'2026-03-01 15:18:32','2026-03-01 15:18:32'),(40,17,9,'2026-03-01 15:20:23','2026-03-01 15:20:23'),(41,17,10,'2026-03-01 15:20:32','2026-03-01 15:20:32'),(42,17,11,'2026-03-01 15:20:46','2026-03-01 15:20:46'),(43,17,12,'2026-03-01 15:20:58','2026-03-01 15:20:58'),(44,17,13,'2026-03-01 15:21:13','2026-03-01 15:21:13'),(45,17,15,'2026-03-01 15:21:28','2026-03-01 15:21:28'),(67,6,19,'2026-03-01 16:05:23','2026-03-01 16:05:23'),(68,17,19,'2026-03-01 16:05:23','2026-03-01 16:05:23'),(69,3,19,'2026-03-01 16:05:23','2026-03-01 16:05:23'),(71,7,19,'2026-03-01 16:05:24','2026-03-01 16:05:24'),(72,13,19,'2026-03-01 16:05:24','2026-03-01 16:05:24'),(73,12,19,'2026-03-01 16:05:24','2026-03-01 16:05:24'),(74,6,9,'2026-03-02 15:31:33','2026-03-02 15:31:33'),(75,20,9,'2026-03-02 15:31:34','2026-03-02 15:31:34'),(76,13,9,'2026-03-02 15:31:34','2026-03-02 15:31:34'),(77,20,10,'2026-03-02 15:31:54','2026-03-02 15:31:54'),(78,13,11,'2026-03-02 15:32:25','2026-03-02 15:32:25'),(79,20,11,'2026-03-02 15:32:25','2026-03-02 15:32:25'),(80,20,12,'2026-03-02 15:32:36','2026-03-02 15:32:36'),(81,6,13,'2026-03-02 15:32:52','2026-03-02 15:32:52'),(82,20,13,'2026-03-02 15:32:53','2026-03-02 15:32:53'),(83,13,13,'2026-03-02 15:32:53','2026-03-02 15:32:53'),(84,12,15,'2026-03-02 15:33:09','2026-03-02 15:33:09'),(89,3,20,'2026-03-02 17:17:54','2026-03-02 17:17:54'),(90,12,20,'2026-03-02 17:17:54','2026-03-02 17:17:54'),(91,17,20,'2026-03-02 17:17:55','2026-03-02 17:17:55'),(92,7,20,'2026-03-02 17:17:55','2026-03-02 17:17:55'),(93,3,21,'2026-03-03 19:13:02','2026-03-03 19:13:02'),(94,17,21,'2026-03-03 19:13:03','2026-03-03 19:13:03'),(95,6,21,'2026-03-03 19:13:03','2026-03-03 19:13:03'),(96,7,21,'2026-03-03 19:13:03','2026-03-03 19:13:03'),(97,13,21,'2026-03-03 19:13:03','2026-03-03 19:13:03'),(98,12,21,'2026-03-03 19:13:03','2026-03-03 19:13:03'),(99,21,10,'2026-03-07 18:03:05','2026-03-07 18:03:05'),(100,8,10,'2026-03-07 18:03:05','2026-03-07 18:03:05'),(101,10,13,'2026-03-13 17:44:19','2026-03-13 17:44:19'),(102,11,13,'2026-03-13 17:44:19','2026-03-13 17:44:19'),(103,10,22,'2026-03-20 17:52:41','2026-03-20 17:52:41'),(104,11,22,'2026-03-20 17:52:41','2026-03-20 17:52:41'),(105,13,22,'2026-03-20 17:52:42','2026-03-20 17:52:42'),(106,12,22,'2026-03-20 17:52:42','2026-03-20 17:52:42'),(107,6,22,'2026-03-20 17:52:42','2026-03-20 17:52:42'),(108,17,22,'2026-03-20 17:52:43','2026-03-20 17:52:43'),(109,3,22,'2026-03-20 17:52:43','2026-03-20 17:52:43'),(110,7,22,'2026-03-20 17:52:43','2026-03-20 17:52:43'),(111,20,22,'2026-03-20 17:52:43','2026-03-20 17:52:43'),(112,6,23,'2026-03-21 14:06:33','2026-03-21 14:06:33'),(113,17,23,'2026-03-21 14:06:33','2026-03-21 14:06:33'),(114,3,23,'2026-03-21 14:06:34','2026-03-21 14:06:34'),(115,7,23,'2026-03-21 14:06:34','2026-03-21 14:06:34'),(116,8,23,'2026-03-21 14:06:35','2026-03-21 14:06:35'),(117,21,23,'2026-03-21 14:06:35','2026-03-21 14:06:35'),(118,13,23,'2026-03-21 14:06:36','2026-03-21 14:06:36'),(119,12,23,'2026-03-21 14:06:36','2026-03-21 14:06:36'),(120,20,23,'2026-03-21 14:06:36','2026-03-21 14:06:36'),(121,6,24,'2026-03-27 16:42:16','2026-03-27 16:42:16'),(122,17,24,'2026-03-27 16:42:16','2026-03-27 16:42:16'),(123,3,24,'2026-03-27 16:42:17','2026-03-27 16:42:17'),(124,7,24,'2026-03-27 16:42:17','2026-03-27 16:42:17'),(125,14,24,'2026-03-27 16:42:17','2026-03-27 16:42:17'),(126,22,24,'2026-03-27 16:42:17','2026-03-27 16:42:17'),(127,10,24,'2026-03-27 16:42:18','2026-03-27 16:42:18'),(128,11,24,'2026-03-27 16:42:18','2026-03-27 16:42:18'),(129,13,24,'2026-03-27 16:42:18','2026-03-27 16:42:18'),(130,12,24,'2026-03-27 16:42:19','2026-03-27 16:42:19'),(131,20,24,'2026-03-27 16:42:19','2026-03-27 16:42:19'),(143,6,26,'2026-03-28 18:36:47','2026-03-28 18:36:47'),(144,17,26,'2026-03-28 18:36:47','2026-03-28 18:36:47'),(145,3,26,'2026-03-28 18:36:47','2026-03-28 18:36:47'),(146,7,26,'2026-03-28 18:36:48','2026-03-28 18:36:48'),(147,14,26,'2026-03-28 18:36:48','2026-03-28 18:36:48'),(148,22,26,'2026-03-28 18:36:48','2026-03-28 18:36:48'),(149,8,26,'2026-03-28 18:36:49','2026-03-28 18:36:49'),(150,21,26,'2026-03-28 18:36:49','2026-03-28 18:36:49'),(151,13,26,'2026-03-28 18:36:49','2026-03-28 18:36:49'),(152,12,26,'2026-03-28 18:36:49','2026-03-28 18:36:49'),(153,20,26,'2026-03-28 18:36:50','2026-03-28 18:36:50'),(154,6,27,'2026-04-04 19:17:31','2026-04-04 19:17:31'),(155,17,27,'2026-04-04 19:17:32','2026-04-04 19:17:32'),(156,3,27,'2026-04-04 19:17:32','2026-04-04 19:17:32'),(157,7,27,'2026-04-04 19:17:32','2026-04-04 19:17:32'),(158,14,27,'2026-04-04 19:17:32','2026-04-04 19:17:32'),(159,22,27,'2026-04-04 19:17:32','2026-04-04 19:17:32'),(160,10,27,'2026-04-04 19:17:33','2026-04-04 19:17:33'),(161,11,27,'2026-04-04 19:17:33','2026-04-04 19:17:33'),(162,13,27,'2026-04-04 19:17:34','2026-04-04 19:17:34'),(163,12,27,'2026-04-04 19:17:34','2026-04-04 19:17:34'),(164,20,27,'2026-04-04 19:17:35','2026-04-04 19:17:35');

--
-- Table structure for table `pack_snack`
--

CREATE TABLE `pack_snack` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `seance_pack_id` bigint unsigned NOT NULL,
  `snack_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pack_snack_seance_pack_id_snack_id_unique` (`seance_pack_id`,`snack_id`),
  KEY `pack_snack_snack_id_foreign` (`snack_id`),
  CONSTRAINT `pack_snack_seance_pack_id_foreign` FOREIGN KEY (`seance_pack_id`) REFERENCES `seance_packs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `pack_snack_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pack_snack`
--

INSERT INTO `pack_snack` VALUES (15,6,8,NULL,NULL),(17,6,10,NULL,NULL),(21,6,15,NULL,NULL),(22,6,12,NULL,NULL),(23,6,14,NULL,NULL),(24,6,13,NULL,NULL),(25,6,16,NULL,NULL),(26,7,16,NULL,NULL),(29,7,8,NULL,NULL),(30,8,15,NULL,NULL),(31,8,12,NULL,NULL),(33,8,13,NULL,NULL),(46,10,16,NULL,NULL),(47,10,8,NULL,NULL),(51,11,8,NULL,NULL),(55,11,16,NULL,NULL),(56,11,10,NULL,NULL),(58,12,18,NULL,NULL),(59,12,17,NULL,NULL),(61,13,18,NULL,NULL),(62,13,8,NULL,NULL),(64,13,10,NULL,NULL),(68,13,17,NULL,NULL),(69,13,15,NULL,NULL),(70,13,12,NULL,NULL),(71,13,14,NULL,NULL),(72,13,13,NULL,NULL),(73,13,16,NULL,NULL),(77,14,12,NULL,NULL),(78,14,14,NULL,NULL),(79,14,16,NULL,NULL),(86,3,10,NULL,NULL),(87,13,20,NULL,NULL),(88,13,19,NULL,NULL),(89,10,19,NULL,NULL),(90,11,19,NULL,NULL),(105,10,23,NULL,NULL),(106,13,23,NULL,NULL),(111,7,20,NULL,NULL),(112,8,16,NULL,NULL),(116,20,18,NULL,NULL),(117,20,8,NULL,NULL),(119,20,10,NULL,NULL),(120,20,20,NULL,NULL),(121,20,21,NULL,NULL),(122,20,17,NULL,NULL),(123,20,15,NULL,NULL),(124,20,12,NULL,NULL),(125,20,14,NULL,NULL),(126,20,13,NULL,NULL),(127,20,23,NULL,NULL),(128,20,19,NULL,NULL),(129,20,16,NULL,NULL);

--
-- Table structure for table `prestations`
--

CREATE TABLE `prestations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `prestations_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prestations`
--

INSERT INTO `prestations` VALUES (2,'💋 Bisous','2026-03-01 12:57:08','2026-03-02 16:26:31'),(3,'🤗 Calins','2026-03-01 13:02:42','2026-03-02 16:26:45'),(4,'💆🏻 Massage','2026-03-01 13:15:27','2026-03-02 16:27:09'),(5,'🚨 Service rapide','2026-03-01 13:22:29','2026-03-02 16:29:02'),(6,' 🪣 Salle de cinéma rangé et nettoyée','2026-03-01 15:54:47','2026-03-02 16:27:39');

--
-- Table structure for table `reservation_boisson`
--

CREATE TABLE `reservation_boisson` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint unsigned NOT NULL,
  `boisson_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reservation_boisson_reservation_id_boisson_id_unique` (`reservation_id`,`boisson_id`),
  KEY `reservation_boisson_boisson_id_foreign` (`boisson_id`),
  CONSTRAINT `reservation_boisson_boisson_id_foreign` FOREIGN KEY (`boisson_id`) REFERENCES `boissons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reservation_boisson_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservation_boisson`
--

INSERT INTO `reservation_boisson` VALUES (27,4,5),(13,15,2),(12,15,3),(22,16,2),(17,18,2),(16,18,3),(18,19,3),(19,19,5),(20,19,7),(21,20,3),(23,21,3),(24,21,7),(25,22,3),(26,23,2),(28,24,2),(29,25,3),(31,26,2),(30,26,3),(32,27,3),(33,28,3),(34,29,5),(35,29,7),(36,30,3),(37,31,5),(38,31,7),(39,32,2),(41,33,2),(40,33,3),(42,34,5),(43,34,7),(44,35,1),(45,35,3),(46,36,2),(47,37,5),(48,37,7),(49,38,3),(50,39,1),(51,39,3);

--
-- Table structure for table `reservation_prestation`
--

CREATE TABLE `reservation_prestation` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint unsigned NOT NULL,
  `prestation_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reservation_prestation_reservation_id_prestation_id_unique` (`reservation_id`,`prestation_id`),
  KEY `reservation_prestation_prestation_id_foreign` (`prestation_id`),
  CONSTRAINT `reservation_prestation_prestation_id_foreign` FOREIGN KEY (`prestation_id`) REFERENCES `prestations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reservation_prestation_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservation_prestation`
--

INSERT INTO `reservation_prestation` VALUES (5,3,2),(6,3,3),(36,4,2),(8,4,5),(27,15,3),(21,15,6),(31,16,2),(32,16,3),(33,16,4),(24,18,2),(25,18,3),(26,18,4),(29,19,2),(28,19,6),(30,20,3),(34,21,3),(35,22,4),(37,25,2),(38,26,3),(39,27,3),(40,28,2),(41,29,2),(42,30,3),(44,31,2),(45,31,3),(46,31,5),(43,31,6),(47,32,4),(48,33,4),(49,34,3),(50,35,2),(51,35,3),(52,35,4),(54,36,2),(55,36,3),(58,36,4),(56,36,5),(53,36,6),(59,37,2),(60,37,3),(61,37,4),(62,38,3),(63,39,2),(64,39,3),(65,39,4);

--
-- Table structure for table `reservation_snack`
--

CREATE TABLE `reservation_snack` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `reservation_id` bigint unsigned NOT NULL,
  `snack_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reservation_snack_reservation_id_snack_id_unique` (`reservation_id`,`snack_id`),
  KEY `reservation_snack_snack_id_foreign` (`snack_id`),
  CONSTRAINT `reservation_snack_reservation_id_foreign` FOREIGN KEY (`reservation_id`) REFERENCES `reservations` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reservation_snack_snack_id_foreign` FOREIGN KEY (`snack_id`) REFERENCES `snacks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservation_snack`
--

INSERT INTO `reservation_snack` VALUES (7,3,16),(46,4,20),(47,4,23),(29,15,8),(31,15,24),(41,16,8),(42,16,12),(36,18,24),(48,18,28),(40,19,16),(39,19,17),(38,19,21),(43,21,13),(45,22,16),(44,22,27),(49,24,28),(50,25,16),(52,26,18),(54,27,16),(53,27,17),(55,28,10),(56,28,16),(57,29,8),(58,29,27),(60,30,16),(59,30,26),(61,31,8),(63,31,17),(62,31,27),(64,31,28),(66,32,28),(65,32,30),(68,33,28),(67,33,31),(70,34,28),(69,34,29),(73,35,16),(71,35,17),(72,35,26),(74,36,8),(75,36,32),(76,37,8),(77,37,27),(78,37,32),(80,38,16),(79,38,32),(83,39,16),(82,39,19),(81,39,29);

--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_user_id` bigint unsigned NOT NULL,
  `seance_id` bigint unsigned NOT NULL,
  `seance_pack_id` bigint unsigned DEFAULT NULL,
  `special_requests` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reservations_site_user_id_seance_id_unique` (`site_user_id`,`seance_id`),
  KEY `reservations_seance_id_foreign` (`seance_id`),
  KEY `reservations_seance_pack_id_foreign` (`seance_pack_id`),
  CONSTRAINT `reservations_seance_id_foreign` FOREIGN KEY (`seance_id`) REFERENCES `seances` (`id`) ON DELETE CASCADE,
  CONSTRAINT `reservations_seance_pack_id_foreign` FOREIGN KEY (`seance_pack_id`) REFERENCES `seance_packs` (`id`) ON DELETE SET NULL,
  CONSTRAINT `reservations_site_user_id_foreign` FOREIGN KEY (`site_user_id`) REFERENCES `site_users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `reservations`
--

INSERT INTO `reservations` VALUES (3,3,9,14,NULL,'2026-03-01 16:54:58','2026-03-01 16:54:58'),(4,1,13,6,NULL,'2026-03-01 17:02:30','2026-03-13 18:19:07'),(15,2,9,14,NULL,'2026-03-03 19:06:43','2026-03-06 15:27:15'),(16,2,10,7,NULL,'2026-03-03 19:08:44','2026-03-07 17:55:54'),(18,2,12,7,NULL,'2026-03-04 15:05:48','2026-03-04 15:05:48'),(19,1,9,10,NULL,'2026-03-06 16:08:40','2026-03-06 16:08:40'),(20,5,9,14,NULL,'2026-03-06 18:59:30','2026-03-06 18:59:30'),(21,1,10,8,NULL,'2026-03-07 19:12:03','2026-03-07 19:12:03'),(22,3,10,8,NULL,'2026-03-07 19:12:41','2026-03-07 19:12:41'),(23,2,13,3,NULL,'2026-03-13 17:54:09','2026-03-13 17:54:09'),(24,2,22,3,NULL,'2026-03-20 19:33:17','2026-03-20 19:33:17'),(25,3,22,12,NULL,'2026-03-20 19:58:06','2026-03-20 19:58:06'),(26,2,23,8,NULL,'2026-03-21 15:15:45','2026-03-21 15:16:26'),(27,3,23,12,NULL,'2026-03-21 17:57:26','2026-03-21 17:57:26'),(28,3,11,12,NULL,'2026-03-21 17:58:08','2026-03-21 17:58:08'),(29,1,23,8,NULL,'2026-03-21 18:17:11','2026-03-21 18:17:11'),(30,3,24,12,NULL,'2026-03-27 16:43:54','2026-03-27 16:43:54'),(31,1,24,11,NULL,'2026-03-27 16:47:44','2026-03-27 16:47:44'),(32,2,24,12,NULL,'2026-03-27 18:30:37','2026-03-27 18:30:37'),(33,2,26,8,NULL,'2026-03-28 18:42:31','2026-03-28 18:42:31'),(34,1,26,8,NULL,'2026-03-28 18:44:11','2026-03-28 18:44:11'),(35,3,26,7,NULL,'2026-03-28 18:44:29','2026-03-28 18:44:29'),(36,2,27,22,'Je voudrai à manger des pizzas 🍕( pizza quatre fromages ) stp','2026-04-04 19:22:23','2026-04-04 19:22:23'),(37,1,27,7,NULL,'2026-04-04 19:44:10','2026-04-04 19:44:10'),(38,3,27,12,NULL,'2026-04-04 19:45:17','2026-04-04 19:45:17'),(39,3,19,7,NULL,'2026-04-04 19:46:10','2026-04-04 19:46:10');

--
-- Table structure for table `seance_packs`
--

CREATE TABLE `seance_packs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `snack_limit` smallint unsigned NOT NULL DEFAULT '0',
  `boisson_limit` smallint unsigned NOT NULL DEFAULT '0',
  `prestation_limit` smallint unsigned NOT NULL DEFAULT '0',
  `allow_special_request` tinyint(1) NOT NULL DEFAULT '0',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seance_packs`
--

INSERT INTO `seance_packs` VALUES (3,'Basique',1.00,1,1,0,0,0,'2026-03-01 12:56:27','2026-03-01 12:56:27'),(6,' Pack VIP +',9.00,4,2,2,0,0,'2026-03-01 13:15:30','2026-03-02 12:39:00'),(7,'Pack amour',4.00,3,2,3,0,0,'2026-03-01 13:24:18','2026-03-01 13:24:18'),(8,'Pack Koh lanta',3.00,2,2,1,0,0,'2026-03-01 13:26:31','2026-03-03 19:07:48'),(10,'Pack pékin express',2.00,4,3,2,0,0,'2026-03-01 13:34:04','2026-03-01 13:34:04'),(11,'Pack pékin express +',5.00,5,4,4,0,0,'2026-03-01 13:34:57','2026-03-01 13:34:57'),(12,'Saveur chocolat',1.00,2,1,1,0,0,'2026-03-01 13:40:54','2026-03-01 13:40:54'),(13,'Pack ultra VIP',18.00,30,10,5,1,0,'2026-03-01 13:43:03','2026-03-02 12:43:41'),(14,'Pack gratuit',0.00,3,3,2,0,0,'2026-03-01 13:46:49','2026-03-01 17:57:47'),(17,'Aucun pack',0.00,0,0,0,0,0,'2026-03-01 15:19:56','2026-03-01 15:19:56'),(20,'VIP ++',12.00,6,2,3,0,0,'2026-03-01 19:39:14','2026-03-02 12:39:46'),(21,'Pack Koh lanta +',11.00,4,2,1,1,0,'2026-03-02 12:45:24','2026-03-02 12:45:24'),(22,'Pack immersive ',4.00,2,1,6,1,0,'2026-03-21 14:08:52','2026-03-21 14:08:52');

--
-- Table structure for table `seances`
--

CREATE TABLE `seances` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `poster_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seance_at` datetime NOT NULL,
  `lieu` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Salon',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `seances`
--

INSERT INTO `seances` VALUES (9,'Pékin express la route des dragons ',NULL,'posters/01KJMP5WJNES1TW05H2C4NF02B.jpeg','2026-03-06 19:15:00','Chambre des parents','2026-03-01 13:32:40','2026-03-06 15:28:12'),(10,'Koh-Lanta épisode 1','Quatorze à dix-huit candidats doivent survivre sur une île inhabitée pendant 40 jours (20 jours dans les éditions spéciales). C’est à eux de trouver de la nourriture afin d’accompagner la maigre ration de riz qui leur est fournie en début d’aventure. Ils doivent construire un abri afin de se protéger des conditions extérieures (intempéries, insectes…) et entretenir le feu qu’ils sont parvenus à faire ou qu’ils ont remporté lors de la première épreuve de confort.','posters/01KK4M0ZQ4F5NMB43BRF7VRRJW.jpg','2026-03-07 19:20:00','Chambre des parents','2026-03-01 13:50:10','2026-03-07 18:04:20'),(11,'Bambi','Après que sa vie a été bouleversée, Bambi part explorer les merveilles et les défis des bois avec ses meilleurs amis, Panpan et Fleur, afin de satisfaire sa destinée en tant que prince de la forêt.','posters/01KJMQ8ZXN1T56HBT83DZ15K44.jpg','2026-03-22 17:00:00','Salon','2026-03-01 13:52:28','2026-03-20 17:50:01'),(12,'Dumbo','Venez voir Dumbo ! Ce bébé adoré par sa mère, Mme Jumbo, charme tous les regards… jusqu\'à ce qu\'on s’aperçoive qu\'il a d\'immenses oreilles tombantes. Avec le soutien de son meilleur ami, Timothée, Dumbo apprend bientôt que ses oreilles spectaculaires le rendent unique, lui permettant de devenir une vedette et le seul éléphant volant au monde.','posters/01KJMQB1X0S2KY57KX8NG4W4X2.jpg','2026-03-14 21:00:00','Chambre des parents','2026-03-01 13:54:09','2026-03-14 20:02:59'),(13,'Pékin express la route des dragons épisode 2','De manière similaire à l’émission américaine The Amazing Race, une émission de télé-réalité et de jeu belge/néerlandaise-flamande suit une série de couples alors qu’ils font de l’auto-stop vers ou depuis Pékin lors des trois premières saisons, puis en Amérique du Sud dans les saisons suivantes.','posters/01KKM1A12XH8K2QMR7PWKBV274.jpg','2026-03-13 19:10:00','Chambre des parents','2026-03-01 13:57:09','2026-03-13 17:45:16'),(15,'Men in Black: International','Les Men In Black ont toujours protégé la Terre de la vermine de l’univers. Dans cette nouvelle aventure, ils s’attaquent à la menace la plus importante qu’ils aient rencontrée à ce jour : une taupe au sein de leur organisation.','posters/01KJW6W8HTSMZ9M2BVABQFKX5T.jpg','2026-03-27 16:30:00','Salon','2026-03-01 15:18:32','2026-03-20 17:51:22'),(19,'Tarzan',NULL,'posters/01KJMYS05SRRMBVVTRWZ9ZGH82.jpg','2026-04-05 19:00:00','Chambre des parents','2026-03-01 16:05:22','2026-03-01 16:05:22'),(20,'Ma Famille d\'abord','Michael Kyle est un mari aimant et un père de famille comblé. Mais il n\'est pas toujours facile d\'élever trois enfants. Entre un fils passionné de musique rap aux paroles plutôt agressives, une fille adolescente qui lui cause bien des soucis et la benjamine qui veut toujours avoir le dernier mot, on ne s\'ennuie pas avec la famille Kyle.','posters/01KJQNDX0CW6GTSDAZYZCVM49E.jpg','2026-03-25 12:30:00','Chambre des parents','2026-03-02 17:17:53','2026-03-20 17:51:03'),(21,'Men in Black III','En 15 ans de carrière chez les Men In Black, l’agent J a vu beaucoup de phénomènes inexplicables… Mais rien, pas même le plus étrange des aliens, ne le laisse aussi perplexe que son partenaire, le sarcastique K. Lorsque la vie de K et le destin de la Terre sont menacés, l’agent J décide de remonter le temps pour remettre les choses en ordre. Il va alors découvrir qu’il existe certains secrets de l’univers que K ne lui a jamais révélés. Il est cette fois obligé de faire équipe avec l’agent K, plus jeune, pour sauver la vie de son partenaire, l’agence, et l’avenir même de l’humanité…','posters/01KJW6YNN84VGR6FC7DHC39XBC.jpg','2026-03-11 14:15:00','Salon','2026-03-03 19:13:02','2026-03-04 11:40:34'),(22,'Pékin Express (Espagne)',NULL,'posters/01KM62JFXRXN5XEZ6N564DGDJ5.jpg','2026-03-20 20:00:00','Chambre des parents','2026-03-20 17:52:41','2026-03-20 17:52:41'),(23,'Koh-Lanta','Quatorze à dix-huit candidats doivent survivre sur une île inhabitée pendant 40 jours (20 jours dans les éditions spéciales). C’est à eux de trouver de la nourriture afin d’accompagner la maigre ration de riz qui leur est fournie en début d’aventure. Ils doivent construire un abri afin de se protéger des conditions extérieures (intempéries, insectes…) et entretenir le feu qu’ils sont parvenus à faire ou qu’ils ont remporté lors de la première épreuve de confort.','posters/01KM881CDWXY19V9JYRDEBH23Q.jpg','2026-03-21 20:00:00','Chambre des parents','2026-03-21 14:06:32','2026-03-21 14:06:32'),(24,'Pékin Express (Espagne)',NULL,'posters/01KMQZ9VSJPSDF8F8JJFMMVZK4.jpg','2026-03-27 19:00:00','Chambre des parents','2026-03-27 16:42:15','2026-03-27 16:42:15'),(26,'Koh-Lanta','Quatorze à dix-huit candidats doivent survivre sur une île inhabitée pendant 40 jours (20 jours dans les éditions spéciales). C’est à eux de trouver de la nourriture afin d’accompagner la maigre ration de riz qui leur est fournie en début d’aventure. Ils doivent construire un abri afin de se protéger des conditions extérieures (intempéries, insectes…) et entretenir le feu qu’ils sont parvenus à faire ou qu’ils ont remporté lors de la première épreuve de confort.','posters/01KMTR9A39BCAT4AQFZ3M92568.jpg','2026-03-28 19:30:00','Chambre des parents','2026-03-28 18:36:46','2026-03-28 18:36:46'),(27,'Pékin Express ',NULL,'posters/01KNCQYPSRDWQF5TK3CHA6WA5T.jpg','2026-04-04 20:00:00','Chambre des parents','2026-04-04 19:17:30','2026-04-04 19:42:33');

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--


--
-- Table structure for table `snacks`
--

CREATE TABLE `snacks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `en_stock` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `snacks_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `snacks`
--

INSERT INTO `snacks` VALUES (8,'🥥 Bounty mini',1,'2026-03-01 13:00:15','2026-04-04 19:17:49'),(10,'🥔 Chips nature',1,'2026-03-01 13:11:43','2026-03-02 15:43:39'),(12,'👻 Monster munch créme et oignon ',1,'2026-03-01 13:12:46','2026-03-20 19:32:09'),(13,'👻 Monster munch paprika ',0,'2026-03-01 13:13:33','2026-03-20 17:56:59'),(14,'👻 Monster munch nature',1,'2026-03-01 13:13:50','2026-04-03 18:04:24'),(15,' 👻 Monster munch cheddar',1,'2026-03-01 13:14:11','2026-03-20 17:56:53'),(16,'🍫 Snickers',1,'2026-03-01 13:15:12','2026-03-02 15:47:44'),(17,'🍪 Kinder chocobon',0,'2026-03-01 13:39:37','2026-04-03 18:08:35'),(18,'🍫 Barres Kinder ',1,'2026-03-01 13:39:59','2026-03-21 15:17:28'),(19,'🍿 POP CORN sucré',1,'2026-03-01 13:58:38','2026-03-02 15:47:04'),(20,'🥔 Chipster ',1,'2026-03-01 14:38:39','2026-03-02 15:45:05'),(21,'🥑 Guacamole + chips',1,'2026-03-01 15:32:20','2026-03-02 15:45:16'),(23,'🍿 POP CORN salé',1,'2026-03-01 17:31:25','2026-03-02 15:48:01'),(24,'🍫 Tablette de chocolat ',0,'2026-03-02 15:40:40','2026-04-03 18:04:41'),(26,'🍦 Liégeois au chocolat',1,'2026-03-04 11:37:29','2026-03-04 11:37:29'),(27,'🧀 Chips saveur chèvre chaud et herbes  ',1,'2026-03-07 17:50:39','2026-03-20 19:32:15'),(28,'🍖 Plateau de charcuterie et morceau de fromage',1,'2026-03-07 17:51:49','2026-04-04 19:17:56'),(29,'🥔 Chips BBQ',1,'2026-03-20 19:32:34','2026-03-20 19:32:50'),(30,'🧈 Petits beurre au chocolat ',0,'2026-03-27 18:26:00','2026-03-28 18:37:09'),(31,'🥨 Bretzel',1,'2026-03-27 18:27:32','2026-03-27 18:27:32'),(32,'🍓 Fraises à la chantilly ',1,'2026-04-04 19:18:30','2026-04-04 19:18:30');


