/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.11.15-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: udenproc_prod
-- ------------------------------------------------------
-- Server version	10.11.15-MariaDB-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `_prisma_migrations`
--

DROP TABLE IF EXISTS `_prisma_migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `_prisma_migrations` (
  `id` varchar(36) NOT NULL,
  `checksum` varchar(64) NOT NULL,
  `finished_at` datetime(3) DEFAULT NULL,
  `migration_name` varchar(255) NOT NULL,
  `logs` text DEFAULT NULL,
  `rolled_back_at` datetime(3) DEFAULT NULL,
  `started_at` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `applied_steps_count` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `_prisma_migrations`
--

LOCK TABLES `_prisma_migrations` WRITE;
/*!40000 ALTER TABLE `_prisma_migrations` DISABLE KEYS */;
INSERT INTO `_prisma_migrations` VALUES
('181b797c-b1bc-4605-9c94-b8e1334bf83d','7fca8353553bbb87d745cbe83b1c1f60ba51191f7ed567c8f77b2a2389574702','2026-03-09 23:08:00.799','20251108111225_add_rating_removal_system',NULL,NULL,'2026-03-09 23:08:00.632',1),
('1860ff66-9bc9-4535-b07a-1dd6f781e8cb','c3970b855bbcd921c8ef464496271f249cdf08907ab0ff2d82b452de258c87bf','2026-03-09 23:07:56.481','20250910172857_add_description_length_limit',NULL,NULL,'2026-03-09 23:07:56.308',1),
('1c4e880b-31de-4934-aea6-740c2fc96e47','5af53f99fa9fe1628aa99798698308e65a5840f96c74375c30467b9fdcf5761c','2026-03-09 23:08:01.985','20260303000000_add_barcode',NULL,NULL,'2026-03-09 23:08:01.785',1),
('2134923d-605a-47a0-acae-fba84f0fb1f6','27ac87b8a3eb04d104e165023e42b1548c0f2d69336eefcdda4fb62f966c5af5','2026-03-09 23:07:57.750','20250912114829_rename_mocktails_to_drinks',NULL,NULL,'2026-03-09 23:07:57.539',1),
('2c1d0619-85e8-4c14-8175-ff88363cdb8c','93c60291f07e0666609cf46aae1cbb115c0bf70211528d19070581ea59c930bb','2026-03-09 23:07:59.718','20251001212626_add_drink_category',NULL,NULL,'2026-03-09 23:07:59.549',1),
('3ed9ce33-05d6-45b9-87fb-077d99dee09c','79e08c4c2e6a955f435080a18b7d9dea2c38b6193ea4ac0cc42e2ccbc2aedc81','2026-03-09 23:07:58.533','20250914132231_add_crop_coordinates',NULL,NULL,'2026-03-09 23:07:58.333',1),
('49accfdf-29e7-402a-be55-b5fc112d1071','d3cd5042f97738960d802ad6b3a548dfa18152215118ba18f04493bc6944b0e4','2026-03-09 23:08:01.289','20260220000001_inspiration_image_uploads',NULL,NULL,'2026-03-09 23:08:01.098',1),
('4ba1e1de-47b3-48b9-9b9e-0d97ee0cf4a7','d3cd5042f97738960d802ad6b3a548dfa18152215118ba18f04493bc6944b0e4','2026-03-09 23:08:01.037','20260220000000_add_inspiration_tables',NULL,NULL,'2026-03-09 23:08:00.868',1),
('4c0916a7-02a8-456b-9ff4-7a17b82f8729','79c5616ebc352670db8da9e599f82fa218c98f4ceb9ec031c2ebea6a6891e080','2026-03-09 23:07:57.243','20250911191718_add_non_alcoholic_beverages',NULL,NULL,'2026-03-09 23:07:57.041',1),
('54e1a99b-cf9a-47a9-af8f-75b1c1daeb77','9274f11056bae3fe7497f880b8af73bc340cfccf043a33950fe152e7ee6d6822','2026-03-09 23:07:56.737','20250910221336_rename_product_to_beverage',NULL,NULL,'2026-03-09 23:07:56.545',1),
('5bd9e5c9-2b03-46fa-ba39-670d8e0f9bfe','e6955989082edf59baeefd2787a115855a141c42724fcc1bc873b51c8da8149d','2026-03-09 23:07:57.990','202509121401_make_drink_vendorid_nullable',NULL,NULL,'2026-03-09 23:07:57.804',1),
('5db2cf6d-0ec3-4157-b30a-de47f4fd46ab','5c1676d8f54ac3f7aff80167a85f7db81de83350084ef7f7b43982c26ee8caae','2026-03-09 23:08:02.230','20260303000001_add_is_primary_fix_image_indexes',NULL,NULL,'2026-03-09 23:08:02.037',1),
('6e38671e-f1e2-4947-8a73-9977d690aee8','707c6becc3a021e4e3d3924c3885573765f37488e2e0b15cd3c9607818518c99','2026-03-09 23:07:58.251','20250912150125_drop_unwanted_tables',NULL,NULL,'2026-03-09 23:07:58.054',1),
('71eab914-4fae-4ffb-aeb2-15b64aad773e','d2d8b3bcd8e245778b5e591ab2ef594309a92dfa7183b406c334e88fbd0205a0','2026-03-09 23:07:56.021','20250910101831_add_vendor_contact_info_is_active',NULL,NULL,'2026-03-09 23:07:55.858',1),
('734e8931-0d06-4d58-9a21-68a6cde264e1','a782f73c1262447f8d94b560ad260bdb74e798bfa8af30267cfaf00290312299','2026-03-09 23:07:56.228','20250910153329_add_deleted_at_to_product',NULL,NULL,'2026-03-09 23:07:56.077',1),
('76252143-02c8-42e6-9a10-bee9eb457ed7','8a7372363fe98ff810075985bd6465e20347ec9b3d3e324ddf37b5c87b4a9ab0','2026-03-09 23:07:55.168','20250909_add_audit_logs',NULL,NULL,'2026-03-09 23:07:54.989',1),
('7a7c958f-0f5a-49d3-adb8-c02f7f27a2b8','2152000cfbe3fc43bdfaf604c2f07de8de9bfab9a1d461b2a0778a737e901890','2026-03-09 23:07:55.584','20250909094013_add_user_profile_fields',NULL,NULL,'2026-03-09 23:07:55.471',1),
('805832d9-bb44-4359-a6ef-d5d885eeb739','29472bc745b1b2d775f76296c3c37e76651117e0bb8f563b198bba4127a389a2','2026-03-09 23:08:00.332','20251107191735_add_account_lockout_fields',NULL,NULL,'2026-03-09 23:08:00.153',1),
('8ade9403-2761-4852-9595-07ca71d780e3','a92b9344ba189ec25a2ae1307ed74b30a982af7752152cf2ac5a72e3ec921188','2026-03-09 23:07:54.876','20250908073106_init',NULL,NULL,'2026-03-09 23:07:54.582',1),
('9346e453-bc2a-44bc-99a2-ba50b6d9ffd6','1dfb12535460807f758256590d4ba73758e304e8dc9622c0b17856cf01110e48','2026-03-09 23:07:59.279','20250922134253_add_analytics_events',NULL,NULL,'2026-03-09 23:07:59.082',1),
('9c6ed6f4-820a-49fb-8bfc-0621afb5b48f','5603e791f187568e8e5f7d52cf0261671b41286938b3d86b95d9f0411e8a0f45','2026-03-09 23:07:57.483','20250911193110_add_all_beverage_models',NULL,NULL,'2026-03-09 23:07:57.306',1),
('afd0c113-4f39-49df-a550-592ec3929b5e','543317cd4bdc2bd3b6c3023173a6a602b4428f38bbae70deabe638b8f74212ec','2026-03-09 23:07:59.893','20251003_add_feedback_model',NULL,NULL,'2026-03-09 23:07:59.782',1),
('c5aad899-0ddf-4a15-a285-2b82b33a86f8','425d0057839a5ae2721c1277bddd56aac0207f7da7d0e6f7ce593543900a27ab','2026-03-09 23:08:00.579','20251108000000_sync_schema',NULL,NULL,'2026-03-09 23:08:00.401',1),
('caf36a77-0bc5-4abc-a933-d14423d9d4cb','673f33e6991a92e2436f00f9acbcb60405d6b159bea3e5dc6d7beca7d25ca9da','2026-03-09 23:07:59.028','20250915_rollback_crop_coordinates',NULL,NULL,'2026-03-09 23:07:58.849',1),
('cd5717cc-8463-4b64-bfa0-250577ad8deb','c27b9c97e2077cef0abc6211422a0054a6e16306515ce5a000848f7a1d274cfd','2026-03-09 23:07:55.415','20250909051107_add_professional_sommelier_status',NULL,NULL,'2026-03-09 23:07:55.220',1),
('dbe2b7c0-4561-480b-aa4f-08490f5e0577','2a86ffaeb4b6c4fa95e75d0f9924805f7d3d9cbfe1c3d6ce9216a927ab2bd564','2026-03-09 23:07:59.500','20250924_add_rating_verification',NULL,NULL,'2026-03-09 23:07:59.331',1),
('de7d0193-8f70-407e-8f48-35bcdd537e19','337c5756037a740bdec8a4098c2eecc7075ccdfc28101a6f0cdc7f7c85dafcf5','2026-03-09 23:07:58.782','20250915_add_image_storage',NULL,NULL,'2026-03-09 23:07:58.598',1),
('e715192e-fb89-4f6d-ad83-4e76dd681923','7798691d7c7ccd25dc59d7f31909cb6985ff8b63c126f0080005dad2239968ba','2026-03-09 23:08:01.720','20260227143333_sync_schema',NULL,NULL,'2026-03-09 23:08:01.351',1),
('e720cadb-daaf-43a9-bf10-2bd01434ceab','4c6b2887fd7ff50bbd0c5c47e12386801519dadbeb54a0341c834f7cf9c71cba','2026-03-09 23:08:00.107','20251004_add_feedback_followup',NULL,NULL,'2026-03-09 23:07:59.951',1),
('ed6657a9-4364-48c7-93bf-c88c96f3ad54','ce0b0da50e56c8acdf35f772f84f67026a19ebee2f3599da80fe43ca83227990','2026-03-09 23:07:56.977','20250911083704_add_alcohol_fields',NULL,NULL,'2026-03-09 23:07:56.807',1),
('f5df4229-e16f-4acc-9652-08fe9860a93e','d1771865c09ea98c490e8857df837d5c7e0156c83f537d9d65768339700decae','2026-03-09 23:07:55.803','20250909203247_audit_logs',NULL,NULL,'2026-03-09 23:07:55.641',1);
/*!40000 ALTER TABLE `_prisma_migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `analytics_events`
--

DROP TABLE IF EXISTS `analytics_events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `analytics_events` (
  `id` varchar(191) NOT NULL,
  `event` varchar(191) NOT NULL,
  `page` varchar(191) NOT NULL,
  `timestamp` datetime(3) NOT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)),
  `sessionId` varchar(191) NOT NULL,
  `userId` varchar(191) DEFAULT NULL,
  `userAgent` varchar(191) DEFAULT NULL,
  `ipAddress` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `analytics_events_event_idx` (`event`),
  KEY `analytics_events_userId_idx` (`userId`),
  KEY `analytics_events_sessionId_idx` (`sessionId`),
  KEY `analytics_events_timestamp_idx` (`timestamp`),
  KEY `analytics_events_page_idx` (`page`),
  CONSTRAINT `analytics_events_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `analytics_events`
--

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

--
-- Table structure for table `aperitifs`
--

DROP TABLE IF EXISTS `aperitifs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `aperitifs` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `imageUrl` varchar(191) DEFAULT NULL,
  `vendorId` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `alcoholPercentage` double DEFAULT NULL,
  `type` varchar(191) DEFAULT NULL,
  `servingSuggestion` varchar(191) DEFAULT NULL,
  `inFocus` tinyint(1) NOT NULL DEFAULT 0,
  `noAlcohol` tinyint(1) NOT NULL DEFAULT 0,
  `barcode` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `aperitifs_vendorId_idx` (`vendorId`),
  KEY `aperitifs_name_idx` (`name`),
  KEY `aperitifs_deleted_at_idx` (`deleted_at`),
  KEY `aperitifs_barcode_idx` (`barcode`),
  FULLTEXT KEY `aperitifs_name_description_idx` (`name`,`description`),
  CONSTRAINT `aperitifs_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `aperitifs`
--

LOCK TABLES `aperitifs` WRITE;
/*!40000 ALTER TABLE `aperitifs` DISABLE KEYS */;
INSERT INTO `aperitifs` VALUES
('cmmm0r17f0072jb1vz78xem1j','Arensbak RosÃƒÂ© Sparkling','Alkoholfri mousserende rosÃƒÂ© fra Arensbak.',0,NULL,'cmmm0r17e000z0r6r8dd3s854','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f007368qssi6ef56u','Arensbak Effervescent Sparkling','Alkoholfri mousserende vin fra Arensbak.',0,NULL,'cmmm0r17e000z0r6r8dd3s854','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0074jtxe40s417vx','Copenhagen Winery Sparkling White','Alkoholfri mousserende hvidvin fra Copenhagen Winery. Proxi wine.',0,NULL,'cmmm0r17e0011qsc3glhrgike','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.4,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0075i9rm80h3bzlo','ISH Sparkling White','Alkoholfri mousserende hvidvin fra ISH Spirits. Guldmedaljevindende.',0,NULL,'cmmm0r17e0012pvo5i7iskvdw','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0076ekzfti45m566','ISH Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra ISH Spirits.',0,NULL,'cmmm0r17e0012pvo5i7iskvdw','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0077osvxof40ycwx','ISH Espumante','Alkoholfri espumante fra ISH Spirits.',0,NULL,'cmmm0r17e0012pvo5i7iskvdw','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0078v6lpj6as3xo9','Copenhagen Sparkling Tea BlÃƒÂ¥ (Blue)','Alkoholfri mousserende te fra Copenhagen Sparkling Tea Company. ÃƒËœkologisk.',0,NULL,'cmmm0r17e0013drpcr2gucfyl','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Tea','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17f0079tjyb6611wavg','Copenhagen Sparkling Tea LyserÃƒÂ¸d (Pink)','Alkoholfri mousserende te fra Copenhagen Sparkling Tea Company. ÃƒËœkologisk.',0,NULL,'cmmm0r17e0013drpcr2gucfyl','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Tea','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007atakcgyoijljy','Copenhagen Sparkling Tea LysegrÃƒÂ¸n (Light Green)','Alkoholfri mousserende te fra Copenhagen Sparkling Tea Company. ÃƒËœkologisk.',0,NULL,'cmmm0r17e0013drpcr2gucfyl','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Tea','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007bpfn6i2yet58q','Oddbird Blanc de Blancs Sparkling','Alkoholfri mousserende Blanc de Blancs fra Oddbird. Languedoc-Roussillon.',0,NULL,'cmmm0r17e0014x87v46yli77b','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007czi9p8f0m1fu2','Oddbird Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra Oddbird. Languedoc-Roussillon.',0,NULL,'cmmm0r17e0014x87v46yli77b','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007doj42odbcy8o4','Pierre Zero Chardonnay Sparkling','Alkoholfri mousserende Chardonnay fra Domaines Pierre Chavin.',0,NULL,'cmmm0r17e00158d60bm6masiz','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007ernhqzcphsk4r','Pierre Zero Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra Domaines Pierre Chavin.',0,NULL,'cmmm0r17e00158d60bm6masiz','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007fouqnng257z75','French Bloom Le Blanc','Alkoholfri mousserende hvidvin fra French Bloom. ÃƒËœkologisk Chardonnay og Pinot Noir. Verdens bedste alkoholfri mousserende vin.',0,NULL,'cmmm0r17e0018qt919m9pychr','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007g0ihipgp09d6f','French Bloom Le RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra French Bloom. ÃƒËœkologisk.',0,NULL,'cmmm0r17e0018qt919m9pychr','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007hgtomn3ccspmt','French Bloom Extra Brut Blanc de Blancs','Alkoholfri Extra Brut mousserende vin fra French Bloom. ÃƒËœkologisk.',0,NULL,'cmmm0r17e0018qt919m9pychr','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007i70mubql5bu09','French Bloom La CuvÃƒÂ©e Vintage 2022','Alkoholfri vintage mousserende vin fra French Bloom. Ãƒâ€¦rgang 2022.',0,NULL,'cmmm0r17e0018qt919m9pychr','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007j5cj8sm1sa8fo','Raisin Alcohol Free RosÃƒÂ© Sparkling','Alkoholfri mousserende rosÃƒÂ©vin fra Raisin.',0,NULL,'cmmm0r17e001bqb9fqs6q290g','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007k1cupzitupwpf','Leitz Eins Zwei Zero Sparkling Riesling','Alkoholfri mousserende Riesling fra Weingut Leitz.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007lydq1sffv5idm','Leitz Eins Zwei Zero Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra Weingut Leitz.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007m7hd1q9wfbgzp','SOBR Sparkling Riesling','Alkoholfri mousserende Riesling fra Dr. Loosen.',0,NULL,'cmmm0r17e001o40ggmuyalpuy','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007n2c3f1o66yb0u','Teedawn Rheingau Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra Teedawn, Rheingau.',0,NULL,'cmmm0r17e001q1fse6h4v3fl7','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007o6sgbanqrms74','Murviedro Sparkling','Alkoholfri mousserende vin fra Murviedro.',0,NULL,'cmmm0r17e001vk597icd7xlpe','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007pu179yn6vjxup','Murviedro Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra Murviedro.',0,NULL,'cmmm0r17e001vk597icd7xlpe','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007qzejcgfig89p4','Bosio Sparkling Demi-Sec','Alkoholfri mousserende demi-sec fra Bosio.',0,NULL,'cmmm0r17e001wfdwf5loxxet2','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007rqfhhupatiyaa','Noughty Sparkling Chardonnay','Alkoholfri mousserende Chardonnay fra Thomson & Scott. B Corp certificeret, ÃƒÂ¸kologisk og vegansk.',0,NULL,'cmmm0r17e001xmwik1fo23yox','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007skfs446etv36g','Noughty RosÃƒÂ© Mousserende','Alkoholfri mousserende rosÃƒÂ©vin fra Thomson & Scott. B Corp certificeret, ÃƒÂ¸kologisk og vegansk.',0,NULL,'cmmm0r17e001xmwik1fo23yox','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007tama7xitirk2w','CERO Sparkling Chardonnay','Alkoholfri mousserende Chardonnay fra Golden State Vintners.',0,NULL,'cmmm0r17e00228n2kiso5r8lg','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL),
('cmmm0r17g007ua8fbhbwkrze7','Richard Juhlin Sparkling RosÃƒÂ©','Alkoholfri mousserende rosÃƒÂ©vin fra champagneeksperten Richard Juhlin.',0,NULL,'cmmm0r17e0027fhqeabrh27cx','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,'Sparkling Wine','Serveres kÃƒÂ¸let',0,0,NULL);
/*!40000 ALTER TABLE `aperitifs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `app_settings`
--

DROP TABLE IF EXISTS `app_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `app_settings` (
  `id` varchar(191) NOT NULL,
  `key` varchar(191) NOT NULL,
  `value` text NOT NULL,
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `app_settings_key_key` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `app_settings`
--

LOCK TABLES `app_settings` WRITE;
/*!40000 ALTER TABLE `app_settings` DISABLE KEYS */;
INSERT INTO `app_settings` VALUES
('cmmlbbjtz0000xl9kidh7x09h','site.passwordProtection.enabled','true','2026-03-11 00:40:25.893');
/*!40000 ALTER TABLE `app_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `audit_logs`
--

DROP TABLE IF EXISTS `audit_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `audit_logs` (
  `id` varchar(191) NOT NULL,
  `action` varchar(191) NOT NULL,
  `userId` varchar(191) NOT NULL,
  `entityType` varchar(191) NOT NULL,
  `entityId` varchar(191) NOT NULL,
  `oldValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`oldValue`)),
  `newValue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`newValue`)),
  `reason` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `vendorId` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_userId_fkey` (`userId`),
  KEY `audit_logs_vendorId_fkey` (`vendorId`),
  CONSTRAINT `audit_logs_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `audit_logs_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audit_logs`
--

LOCK TABLES `audit_logs` WRITE;
/*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */;
INSERT INTO `audit_logs` VALUES
('cmmlah4qo0001to9kt6eqvwa8','LOGIN_SUCCESS','cmmlaegb60000to9kja25ug4c','User','cmmlaegb60000to9kja25ug4c',NULL,'{\"email\":\"kristian@skriver.de\"}',NULL,'2026-03-11 00:16:46.655',NULL),
('cmmlai68y0002to9khytqt6o9','LOGIN_SUCCESS','cmmlaegb60000to9kja25ug4c','User','cmmlaegb60000to9kja25ug4c',NULL,'{\"email\":\"kristian@skriver.de\"}',NULL,'2026-03-11 00:17:35.265',NULL),
('cmmlazplv0000wk9ksrotwm4a','LOGIN_SUCCESS','cmmlaegb60000to9kja25ug4c','User','cmmlaegb60000to9kja25ug4c',NULL,'{\"email\":\"kristian@skriver.de\"}',NULL,'2026-03-11 00:31:13.506',NULL);
/*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `beers`
--

DROP TABLE IF EXISTS `beers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `beers` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `imageUrl` varchar(191) DEFAULT NULL,
  `vendorId` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `alcoholPercentage` double DEFAULT NULL,
  `ibu` double DEFAULT NULL,
  `style` varchar(191) DEFAULT NULL,
  `inFocus` tinyint(1) NOT NULL DEFAULT 0,
  `noAlcohol` tinyint(1) NOT NULL DEFAULT 0,
  `barcode` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `beers_vendorId_idx` (`vendorId`),
  KEY `beers_name_idx` (`name`),
  KEY `beers_deleted_at_idx` (`deleted_at`),
  KEY `beers_barcode_idx` (`barcode`),
  FULLTEXT KEY `beers_name_description_idx` (`name`,`description`),
  CONSTRAINT `beers_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `beers`
--

LOCK TABLES `beers` WRITE;
/*!40000 ALTER TABLE `beers` DISABLE KEYS */;
INSERT INTO `beers` VALUES
('cmmm0r17e0029eiyt43lt8xpb','Carlsberg Nordic Pilsner 0.0%','Alkoholfri pilsner fra Carlsberg',0,NULL,'cmmm0r178000068gpefafw0jm','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002auushxtyiep0l','Tuborg 0,0%','Alkoholfri pilsner fra Tuborg',0,NULL,'cmmm0r1780001scfprdsgs80v','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002b91212ht6v3v7','Tuborg Classic 0,0%','Alkoholfri lager fra Tuborg',0,NULL,'cmmm0r1780001scfprdsgs80v','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e002cyd3c3hs87gtw','Royal Pilsner 0,0%','Alkoholfri pilsner fra Royal Unibrew',0,NULL,'cmmm0r1780002yyo5zm4iynlk','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002dbb22ghko10m6','Faxe Free','Alkoholfri lager fra Faxe',0,NULL,'cmmm0r17800033b3z6oclvgdr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e002er2vjz52vl7h3','Faxe Premium 0.0%','Alkoholfri lager fra Faxe',0,NULL,'cmmm0r17800033b3z6oclvgdr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e002fwxh2et7g6422','Weird Weather','Alkoholfri Hazy IPA fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'IPA',0,0,NULL),
('cmmm0r17e002gjzzw6got2yo9','Drink\'in the Sun','Alkoholfri Wheat Ale fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002hm0f0lqsb6euh','Easy Peasy','Alkoholfri pilsner fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002ibmo85i0h42fs','Burst Free','Alkoholfri IPA fra Mikkeller',0,'beer_cmmm0r17e002ibmo85i0h42fs_17c9d0388166ff19.jpg','cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:22:55.158',NULL,0.3,NULL,'IPA',0,0,NULL),
('cmmm0r17e002j6cs6tv91oy17','Limbo Dragonfruit','Alkoholfri sour med dragefrugt fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002knughl5bzavkk','Limbo Riesling','Alkoholfri sour med riesling fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002l6tnc7dpggy4i','Limbo Mango','Alkoholfri sour med mango fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002m83p7huk4adip','Raspberry Rush','Alkoholfri sour med hindbÃƒÂ¦r fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002npssm1ke8otam','Wonder','Alkoholfri Wheat Ale fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002oqdw19nubavn1','Energibajer','Alkoholfri Wheat Ale fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002phkpcf6q9l3c5','Implosion IPA','Alkoholfri IPA fra To ÃƒËœl',0,NULL,'cmmm0r17800055qt2v3y8ec5d','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.3,NULL,'IPA',0,0,NULL),
('cmmm0r17e002qftcfvcf2cri2','Implosion Pink Sour','Alkoholfri Pink Sour fra To ÃƒËœl',0,NULL,'cmmm0r17800055qt2v3y8ec5d','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002r2x1f19wgl5x7','Under the Radar','Alkoholfri IPA fra To ÃƒËœl',0,NULL,'cmmm0r17800055qt2v3y8ec5d','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e002s9aq8hpjvukfs','Don\'t Worry Pale Ale','Alkoholfri Pale Ale fra Svaneke Bryghus',0,NULL,'cmmm0r1780006xe1sgax1reh4','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e002td60uqu7dx5tb','Don\'t Worry Classic','Alkoholfri Vienna Lager fra Svaneke Bryghus',0,NULL,'cmmm0r1780006xe1sgax1reh4','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e002ufym7cqa270eb','Don\'t Worry Brown Ale','Alkoholfri Brown Ale fra Svaneke Bryghus',0,NULL,'cmmm0r1780006xe1sgax1reh4','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e002vdbhy4idksxdl','Don\'t Worry Julebryg','Alkoholfri julebryg (Brown Ale) fra Svaneke Bryghus',0,NULL,'cmmm0r1780006xe1sgax1reh4','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e002w11ja7c78ymg1','Anarkist Hazy IPA','Alkoholfri Hazy IPA fra Anarkist',0,NULL,'cmmm0r1780007uod0gfx3wtxg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e002xctfi0s197cww','Anarkist American Easy Lager','Alkoholfri American Easy Lager fra Anarkist',0,NULL,'cmmm0r1780007uod0gfx3wtxg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e002y5me833phkbeg','Anarkist Mighty Mild','Alkoholfri Mild Ale fra Anarkist',0,NULL,'cmmm0r1780007uod0gfx3wtxg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e002z0w66vmhk24qj','Easy Street','Alkoholfri lager fra Alefarm Brewing',0,NULL,'cmmm0r1780008llvw5smcmsy6','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e00305v0mpv5u2cpq','On Dry Land','Alkoholfri IPA fra Alefarm Brewing',0,NULL,'cmmm0r1780008llvw5smcmsy6','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e0031spckf2i3ym7u','Paravue','Alkoholfri DDH IPA fra Alefarm Brewing',0,NULL,'cmmm0r1780008llvw5smcmsy6','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003216i6md2lorui','Low Key','Alkoholfri Pale Ale fra NÃƒÂ¸rrebro Bryghus',0,NULL,'cmmm0r17800091tbhxylzc2o2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e0033zqzsjmsrefw1','Alkoholfri Hoppy Lager','Alkoholfri Hoppy Lager fra NÃƒÂ¸rrebro Bryghus',0,NULL,'cmmm0r17800091tbhxylzc2o2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e0034yemzyxevffv0','CPH All Night','Alkoholfri Pale Ale fra Bryggeriet Skands',0,NULL,'cmmm0r178000a6387p2f9qdj1','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e003599ee9c0ajbzs','Willemoes Mosaic IPA','Alkoholfri Mosaic IPA fra Bryggeriet Vestfyen',0,NULL,'cmmm0r178000bkio244fc95r3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e0036bydeyadii5ip','Willemoes Hvede','Alkoholfri hvedeÃƒÂ¸l fra Bryggeriet Vestfyen',0,NULL,'cmmm0r178000bkio244fc95r3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e0037fwg6fqfaluj6','Willemoes Brown Ale','Alkoholfri Brown Ale fra Bryggeriet Vestfyen',0,NULL,'cmmm0r178000bkio244fc95r3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e0038joedq33sklcx','ÃƒËœko Fynsk Fri','ÃƒËœkologisk alkoholfri pilsner fra ÃƒËœrbÃƒÂ¦k Bryggeri',0,NULL,'cmmm0r178000cyhpwbm75xbbq','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e0039bojckvcqfkms','ÃƒËœko Brown Ale Fri','ÃƒËœkologisk alkoholfri Brown Ale fra ÃƒËœrbÃƒÂ¦k Bryggeri',0,NULL,'cmmm0r178000cyhpwbm75xbbq','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e003azc34gptxbqiq','ÃƒËœko IPA Fri','ÃƒËœkologisk alkoholfri IPA fra ÃƒËœrbÃƒÂ¦k Bryggeri',0,NULL,'cmmm0r178000cyhpwbm75xbbq','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003b8v4qjh8o9khv','Juicebox NEIPA','Alkoholfri NEIPA fra Ugly Duck Brewing',0,NULL,'cmmm0r178000dpujyowq07b9v','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003c2qefqheyjz5b','Ethanol Alkoholfri','Alkoholfri lager fra Refsvindinge Bryggeri',0,NULL,'cmmm0r178000e9slzuub3ljv8','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e003d9yghmdd017q3','Thy Classic Alkoholfri','Alkoholfri classic lager fra Thy Bryghus',0,NULL,'cmmm0r178000ffftg75wa2qfc','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e003ewgiyl12s3lrr','Hvid Alkoholfri','Alkoholfri hvedeÃƒÂ¸l fra Svendborgsund Bryghus',0,NULL,'cmmm0r178000gv5wkbgqudnoe','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003f7pc3ig7g7dwt','GLS Alkoholfri ÃƒËœl','Alkoholfri lager fra Fantom Bryg',0,NULL,'cmmm0r178000hdt0ghv0fuowt','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e003g09rzb62s5ohb','Harboe Pilsner Alkoholfri','Alkoholfri pilsner fra Harboe',0,NULL,'cmmm0r178000it0jer3p42j30','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e003hcz64ls5z6slq','Punk AF','Alkoholfri IPA fra BrewDog',0,NULL,'cmmm0r178000jq86bhvj22xjc','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003ioirevwddxosn','Hazy Jane AF','Alkoholfri Hazy IPA fra BrewDog',0,NULL,'cmmm0r178000jq86bhvj22xjc','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003jgz6ipz57xq5n','Special Effects','Alkoholfri lager fra Brooklyn Brewery',0,NULL,'cmmm0r178000kpnz3tnpk2oxr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.4,NULL,'Lager',0,0,NULL),
('cmmm0r17e003kdib94y98s6ok','Erdinger Alkoholfrei','Alkoholfri hvedeÃƒÂ¸l fra Erdinger',0,NULL,'cmmm0r178000lznediubfg2y7','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.4,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003l5twlkr97b15q','Heineken 0.0%','Alkoholfri lager fra Heineken',0,NULL,'cmmm0r178000m0nmjohm640vw','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e003mlu20gdbjwjbn','Leffe Blonde Alkoholfri','Alkoholfri belgisk blonde ale fra Leffe',0,NULL,'cmmm0r178000nvwq5jd9007x9','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Ale',0,0,NULL),
('cmmm0r17e003nnc2yimsr203m','Leffe Brune Alkoholfri','Alkoholfri belgisk brune ale fra Leffe',0,NULL,'cmmm0r178000nvwq5jd9007x9','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Ale',0,0,NULL),
('cmmm0r17e003o92ctuvu8o3yu','1664 Blanc Alkoholfri','Alkoholfri hvedeÃƒÂ¸l fra Kronenbourg',0,NULL,'cmmm0r178000o1q1fx974pydw','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003p6ya9v07zpdk3','Corona Cero','Alkoholfri lager fra Corona',0,NULL,'cmmm0r178000plshafmvksm03','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e003qha5u3v4zw33m','Clausthaler Lemon Radler','Alkoholfri radler med citron fra Clausthaler',0,NULL,'cmmm0r178000q1cx737se0lj0','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Frugt',0,0,NULL),
('cmmm0r17e003r3wxdim1sd3ln','Schneider Weisse Tap 3','Alkoholfri hvedeÃƒÂ¸l fra Schneider Weisse',0,NULL,'cmmm0r178000rr2djm0wcffps','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003siutqyzs4cone','Weihenstephaner Alkoholfrei','Alkoholfri hvedeÃƒÂ¸l fra Weihenstephaner',0,NULL,'cmmm0r178000s4bj4zu0l4h7b','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003tdtsbod9fbu1v','Riegele Hell Alkoholfri','Alkoholfri Hell lager fra Riegele',0,NULL,'cmmm0r178000twnft0c44o6n7','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e003ubkfrdp3y85dy','Riegele Weiss Alkoholfri','Alkoholfri hvedeÃƒÂ¸l fra Riegele',0,NULL,'cmmm0r178000twnft0c44o6n7','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003vt14e5k4ztaks','Jacob Weissbier Alkoholfrei','Alkoholfri hvedeÃƒÂ¸l fra Jacob',0,NULL,'cmmm0r178000uqa50vi4a3sij','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003whlcrw8z5lehq','Snorkelers Sea Salt IPA','Alkoholfri Sea Salt IPA fra Insel-Brauerei',0,NULL,'cmmm0r178000vb1cdk4y9mvv3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003xomui0wi7mc27','Surfers Summer Ale','Alkoholfri Summer Ale fra Insel-Brauerei',0,NULL,'cmmm0r178000vb1cdk4y9mvv3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e003yqchmtlswnr4f','A Ship Full of IPA','Alkoholfri IPA fra Brutal Brewing',0,NULL,'cmmm0r178000w115y1davgo0h','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'IPA',0,0,NULL),
('cmmm0r17e003z7f2oc4gitp1x','Beck\'s Blue','Alkoholfri pilsner fra Beck\'s',0,NULL,'cmmm0r178000x4l2q1rhsxj7i','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e0040dye2mte1j4su','Force Majeure Tripel','Alkoholfri belgisk tripel fra Force Majeure',0,NULL,'cmmm0r178000ychjrmzjb4il3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Ale',0,0,NULL);
/*!40000 ALTER TABLE `beers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `beverage_images`
--

DROP TABLE IF EXISTS `beverage_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `beverage_images` (
  `id` varchar(191) NOT NULL,
  `filename` varchar(191) NOT NULL,
  `originalName` varchar(191) NOT NULL,
  `mimeType` varchar(191) NOT NULL,
  `size` int(11) NOT NULL,
  `data` longblob NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `beerId` varchar(191) DEFAULT NULL,
  `wineId` varchar(191) DEFAULT NULL,
  `aperitifId` varchar(191) DEFAULT NULL,
  `drinkId` varchar(191) DEFAULT NULL,
  `retailerId` varchar(191) DEFAULT NULL,
  `vendorId` varchar(191) DEFAULT NULL,
  `isPrimary` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `beverage_images_filename_key` (`filename`),
  UNIQUE KEY `beverage_images_vendorId_key` (`vendorId`),
  UNIQUE KEY `beverage_images_retailerId_key` (`retailerId`),
  KEY `beverage_images_beerId_idx` (`beerId`),
  KEY `beverage_images_wineId_idx` (`wineId`),
  KEY `beverage_images_aperitifId_idx` (`aperitifId`),
  KEY `beverage_images_drinkId_idx` (`drinkId`),
  CONSTRAINT `beverage_images_aperitifId_fkey` FOREIGN KEY (`aperitifId`) REFERENCES `aperitifs` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `beverage_images_beerId_fkey` FOREIGN KEY (`beerId`) REFERENCES `beers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `beverage_images_drinkId_fkey` FOREIGN KEY (`drinkId`) REFERENCES `drinks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `beverage_images_retailerId_fkey` FOREIGN KEY (`retailerId`) REFERENCES `retailers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `beverage_images_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `beverage_images_wineId_fkey` FOREIGN KEY (`wineId`) REFERENCES `wines` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `beverage_images`
--

LOCK TABLES `beverage_images` WRITE;
/*!40000 ALTER TABLE `beverage_images` DISABLE KEYS */;
INSERT INTO `beverage_images` VALUES
('cmmm4p6u100001o9jc2hg81gv','beer_cmmm0r17e002ibmo85i0h42fs_17c9d0388166ff19.jpg','mikkeller-burst-free.webp','image/jpeg',47074,'\0C\0	\Z!\Z\"$\"$\0C\0  \"\0\0\0\0\0\0\0\0\0\0\0\0\0	\0Z\0	\n\0!1AQa\"2q#3BRr5bst$%47CSc&6T\'DEduUeV\0\0\0\0\0\0\0\0\0\0\0\0\0\02\0\0\0\0\0!12AQ\"aq3BR#Cb\0\0\0?\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0/=\":5)ѫy^NFb3{CEËuh5k2{ʞ*&4(>5\0䢧׫%p\0Oe>FW;1;.o	zW՜6mb}cxSkM\rlsOyJZ}1,l,nGPI[xKOc?S#\0([5CN\0{}6N*]r3we/q\0?ݏ\Z]>?\n\0¦;bIl3\'Ŝo.l?2$Wv1^\'>7QMgd.{C3N6{;.o:}o8ѽZ+I\Z9Jgu%$1ˊ6q\ZGu\0EU8]?GRY43WCZ#>y2<Q[~6ǳN;h|O*XkcqV1Iԫq.lUܒ\"㳫.\'ltUˊ8<>!\0wqqM~}M<&d#OCKxK-rJ=NeR-+Uͼy\nF4zzJ%)UjsM\'{\0<z	:KA%R5Srʉh^kʟ^syFkj9qE}/)?Yue_#uL{_d^^=/b|EzxXSTڥ	%ϡL}	Qkޯji\Zh,0Oz+ś4ѫ|Lrc=ҳ5\0+\0\\3,aYCE471ə^uoic\\pyO({%	Lc=Go?\0\0yǄ<׻so3[MΞclzYPI<CqE˯\\?TO8O$^OeHz	ZL&tSx)cWO~uXJ+KRCjO\0oo\092)9?Ư\"J=UO%1;.$w+>Kk*~lsrКx߮{\Zo\0s<Gn3uV#W74$\\3\"qջhɮnH\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0|\nw\\IB\\T:mf3}Twtv=]zPsS[\Z\0\'JdVkٹJm-ԥ,.YKN}?=;j8L=7ozQSeRޔUq)7[M뉉}<3OrI>ܵiuq\0V|ZRRR+diɬܢ[Q]KN-I.M=GJH\0/YkP{EhIyM8l\0޴Y6єtW-?kUӵQѥ8r|qֽx:16vZq꜖*c}1Еڣ,a|r~yjy^emfKpjJ*޷;G$^+SwuRΪzǻ|MuULWü	vUs%B7U{1}.[[%KQ\rIYS\\fƯI(\0К$>(WHq+WQ_EdީWd|+8wVu(9/uf}YQ96~\'wgFz:Sm\ZTKm?NysM[_GI\0\0\0aKBm5<6RF3J2yOĶ9rܥH\0&_63v\riԫcfmOzeN]*MEbNIP_EF_M\0~\Z֔~ZIunbjgO^y\\ʓKɛT\0Ke}DN%\0iVΝc*u[_<Ɲ	OYR#&,گkOFt3tu|¼=;ɩBIF$}frܾ\r9E\0oģ<1bqbYi%mMg\n~>9\0r5ggQk|\Zբ.</Q$-sM.WW.XuoV&P0~dt\'%U,fn++3Ҩ&vj˫ؼE?fO*>UMym55OS\09jO\ndޏ,\rm\'NQ|Y\'(+(K0.O3V:l#Iѓt[]o4o(YO\'GOSYYpRZVood#_mu[̜Ӗ;{M4zS?R䯯ӶP6\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0>\rRj{ʊzɼ>P3PBHU5:eVmtmԭZtZy\r|g>GͿ2i%վǘwA&|׏z]\\A6_/7ߋ=u9Lچ\\kW]\0/3=S:3M_rzY\0,x\"0\"fdIOʼG	$Ge{bܚ͸&4IohMjOf⭱/YM.ms$El:Y	=Je>c͘uOOrJ$Ϫ2}ۯf{ǳ>M96whܿUS~i>\'.z/(]G%=2It{GEe/$:|xdF9Q(u3ģd[\'I|En5/Mf9dvu䭪bI;67xXjFzj3>f\'{psVDtrge<gl]oFxBOqF۽	TOZfkJĮU\'r,\rԨTRҲSPEr4͘\Zj!\"\rnM2FGMK{ۖq׸0Iv|ƴW}\'CTz?7\0lM4iѣtkո?1xrp\0: \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0jk\Z]jw+kjRROK\0ϧ\"WU+XD/$Ϗ*rk<G&(e(\Z|Sԏ-u{t]*$_#\"\\ha+guMgK)]S=<q7]([Z5Mu3^KovQ)6X])wfo]?Ͷ>5r<-GGOelabνmլ 叨y$\'^J5]:&K\r|SRTQV	%;gոSZvi+nTogdWݜ>S]q3uBZ,K9[3gDFԺR~$ּ51Ϳogk3Fڮ7\rm>luyN.2[ErN/L|qd{z\r\r{jCEU)MF1MF\\VߟQ*X6NJqiGn\r׸U[VpڃNu^\'i4Um2ܩ7ii~Ve7K=īpm˥9CgL^u^8Vz#`7	$>rb+~e(MA-2ȷ0Y[G\'n\nPk8s45M>^4k(\'ٞ5)GHՆU6OeܦnQhk|?Buo\\[2YIuU;.-]}YF8뿁}iфN\nh>|gٔ]f[2j͎	.c ZPfs\\(ÙYaəї&A2AIH\0\n[[D$IhQYuEfs8X׳qXcN]	NJ1[lJj/ϟ>Vz\ZUů%~Cֽ!\ryZ٧F	S{oMgVwb&۪fOkҺn3%_adӋf~v[R\ZjNQk)3\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ϟmj|W\\1WPqW\0{#꾖8߂N&{[6tTkg\0k^\\]׹\\כVo^&Wdi]TM>~G2osQ*QF:4.zve2,5uW&E{\"En[[1Hk_קWSm$|oK_бkle:hLmQrd[}fK[Jq-zYԬ e[,m	#<yix\"Flsw	RAIˉM+!q$x~Υ:s+\0խSoyeg7N4B^*ښLuPn?iB._\'t[Sa漽p[8RӋhީ[5JHUf]Ϙu..*׆qRG=\'_^t}\Z}CQjuQ⽦n-|3Z9ԓ<JMɿnh7~NsVMB3,K~9M4z_FZ>:ҭ9R۲y6kf?T5i_D9N3r{ex^ %7uK_8u^$ԸZSӭdaNO||}\"ki%6vc}d<Kd¿(ɮ<L<G<?OMխ\"*m8^RԨWW5	SqϿ[yI۩\Z.tzIe}&\04kRG\0IF<?i\'\Zo|8xUJz)o<qY_k*T]:\nJ2$y:l?^9+kݝGPg̺~.JcϜcp?\rk<-\rn6VSc5$@ތ+\\5*ԔscB.p\'6z\'R\0{F檛^ZZ[^P^^G\n8VUn|$6tj.;ՇRpln,:W49/\0ўÈk=	R{J%<zfcƋ5+ܗsrS}M9igW}yJ{?gJRߍ\ZPȭGOsjI-FrK]K<m>Rn,xw^pz|O=	9E6w?9??YQhѥX[bRS9%8-FQQN從TSdnbQGMqVZ]WtiQ=X*9xͫҭsӸ9wRo5NF%$.KrNޕ(\Z΍:KZZKMأ|Y.,=<ysRR>F:FoqZ:QZx0C1$6U%J:n%Bf,Mvr^aAi\\?{~N&:g9Tvov9g?]<ՙuL_yY15n)ek=9MyOᵣ}\0/\n_K=/j/·_~#צjWgi}MխEV}WgW~mv\\iZ㡊:ދ\0s_J|z,V\Z~Q4\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Wu^[F9tRe?\ZJLzul\\]{E\n](E/L<eW8\'/٣exoHOoٻm^:~UI#FU~cRyغkTK\n%-i&k9eЩM\"&%,=!|Mvy%ĎϧQ8XFLsuʪՖqT|+¼]um~%]U-Im>C^%4ZZ.J.^ZQ*|8ͶB496JVD_)_ֱ^>Kڐ:r^qG\'^we\ZmԌԔ\Z>(tz^|*o/O2!Rn˭\\g4Jo\0ы-G~\"io)δgVJN0PO/9Ӯ:G=m>Ƃ*==k0XS]{?nОR(E\'a|R=JvxMRg)1Ym	\'Yֵm>֕rO-\r:+П=9c8zCWճJh8TJ)6bY8񏂊e\\)!:־uGPA\'\'8lH^=W>UiݯYZ5	Rݽ|nյIRN\\В{w(F\\]p%rƜfQbȄՇtRaPmsEYN]VMCIKjJB9Ml9>5}FSjuZ\\ө=߶G]TÖy:ɯLKMJwnB)J2\ZY=来U,\'m[E\0r֒ww.j\\\\՝Z<\'A>B-W^*Q]_؎~mK\no##}BMSj\ng88y]Ӳ(gYkȮwu*u*T7ԫ|{\"ݕv}dhZ[ҸkF8c8Ը[U8SK3ZiԔFQ{d\0fkW}+sZߺk9ռb%+yܔԨ_+fE\0Dtz/杠^Zƽ(QLsj\ZM΃B*<uw<Uqqj^\nE}n*=YFUAǋlԹ.khTRq:N_PPpMnܥgq^T*T;yTԡ)E[us]oJѯJ*,b298n2+QȥVOz17ƻYu&ŝG}6Wpw9sS1o\n9jT2ԩ%^^M:R[<RfhuROz7\0Gy+|[[PP\ns^\Z-|zxO\r9լF9.,csRR?Yq)g>awo3D\\Zw}rIZ}]*P~:Q|28׵Acbq_q81a\"85\"&S5+FTSvwk-ώ֋qO}jK+5ZJ+ÙT,c}+a?/\02lv981R1Z*}q=Q}z<q{\'v>\'jtZjҕo̗y|,{\ZW4ҋq^c%LWV͌kSL-P>gxzt+)jn(]\'KiL<muS\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Ů^kQmIͦ/?^ykWz$\05~lWamT|Gm._?=9ɝZok]g}\ZwRO[/vl\\v\Zu$:qZFerhmv,[5K/n\"!\'AȚDv$؋nRؒ}J;iK\0,IxDc䟪DCq?D$ OT\rIؚd4GtВgCffşMѸ{J(5jJ.O|k,.g,OC8J\Zt֢Ȓq|?VaWU\ZS6P5KRK:_U{-⤳6qto=ԕ\nuMsrzgy5ƶ-{7}/jwZhӓ.R_iYӾ.eQSTR}z6m,f}]X_yHfG%?;	\"#Ӂ8E2qk&KrKF	Re|Ԛuzc۶p\rZu-)fQ2_TbEw7,)c+oӥO>m-*$$\n6.ɝqrȊ(MvE%RwMZЕJ%8k]0;rr(ҩ^J4$UՓxUsU;=^~GMt|\0Y:tB}UZrh$Tpm˺/z:ղ\\ثTkd{6hQՋGNpb~*K_\\v8ܪrj8$\\I@ڌTjߑd.:v/yVJ[\nkvXL]j7|_Znyy)9:,v,Ri{8oz~w>χR|#Yvoc+8E.0鷜yf\ZV>UZ\nQV-mwf2D>\\G\r:[ŝdW?mQTӋYMwG$9qDѭn*i޷yd(}cVlH\0p\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0b!)ˤSlɫ\"񮪄\0e~;U+6[F}dpknEׯ5ĺLR̵WM\'4*ڸ}{ljUf%\rZRlׁD-I2s\r>|cb2d=^V۲j3|ҊOf_N)0ތvճbod7hE.6)F}钧6Zh-rˡbV\r(.ă%;TWWOi<%E.%mhRI79(GhϦ\0iOOQO˱ޕ<</ݧƔi{1HƔ͈%4%)iw>Sս(לM*Ӌx/seyẕ́)c7[}BŹ!>&z)6xc}V}+hԒXAIɽw)mQnI#6Uh:y^|3)qk.#\':NɟHBtys*WS[/&{3un)$5\'rq}lٌ\08/	סjytD6$iK)K2K3ZmAu~>G~S8Kϱ(ƚyCr8ԪEvn\"?NK|HԤr_GY\"䎍mHN:[:ua:9sKn4EM[xn(&4g5WRT.&JQOEMrboeR3D=M*o֤s\Z[4=Fz[CFm⥮M[EMf/Ԓ*5JSn{EhjT>Y^暃yk}ZzJ5=te8Ԏ[&ԥ/k^I\\yqFi[{OK\ZB7rO?ir:^]r\r\0긖G|RInϕzN*7mol<U?zEOǷZQvv$ԳRK5jcI,:@6+Zׄy׫n9擊ǻ{oܒK.Y\'%)g~}kRmdц)#\'MW,n[xW	h͎d||*/8;`Īf/eH]3Xo\Z)Swiůܟ!\0&˙[mjӭNK4R*$ޞ܏@Ǟ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\Zz5n\Zz5ey;y&6}8g:ג<N5w,;x9v>n;\Z^ݍͤԟN)L).b=ˑS!<	?k0~xT>7܄bFgPmGnnUNޓ/i$z?Gӭ\\(Ƭ=\0r5bE-N\nӇ4iiW8?i8Ė}o(pr)&un5!,o>iwLזBO-M>\'q&yQGܗU,+9Rrte\\q~	ӟRonW{эi~xJM%t:\Z-9д)\'l[oxŶ29SǆzoGTڧ{s%ʲ_* ٩4Mx#pqq]?[<9\0Ex\Z=98),B^-הgˌ|#1?,5Ys	mlg+*9^\0E/KRUe~l_<3(J4Bu\ZT9[Gο.]<	(]8.O͆[JQVT߁KbpH2?u4pY\\Yct54[O\'VW~\"^dCof1b<\Z-IQK>%{d.h5KxMeetɻMeMFIxhNIw=5)|Le	7njq\rYSҦK5k?I)83.VE3.5Iu4mӮ:|ީiwRN%%^s߳Fkol|{4\'\ZVk;cӼՔ(U(Q*isoqK\ryTIb[d<SF7Pr](~^,j5D7&iFuigDeZ/wϢQFq\ZqVR֌]o><?\0HI,I6}sufBV\'g4;X[R>~	*du9=a\Zٴ3^Sx߿cJ&XH܌MI͖J:YHRYV|\n،tkN[,EͿb2RQT.娨ͬJ2NZ{N&4[̷ێKb-?\0Yf/QSíϗ5sX<I#z>oWi\0F_T~\0,\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0l\0+g,\\,&?ƹo6wrs5dm4jTO6\"S\"u-O,\"$!BXXv)r{QG]zy@jʦ\ZiTJ-|{غ3Ĝg>E;lXj밸Vx#O[/:eӋ5	P^9)[/3k7N&qiUi=2^tҩ}I%ʿ.3P?yI|8uyRJ?Qj:oW$|>\Z1&}\n[ygiƥTӌ2iqr|.Ro	G)mG(^ƕ6.t;YZNTrd\'֗^(vT~>gYfg.w0zXhe=U	=ƛImGI~}#U{9z$[jɿR,ӧsqu.Liks&s&٪UB[B̗,M>\n<M:0FYQה}} <K볊fsi7ÒIs6\'^|5ywKRLԣHN)fk-\nV^ܝS+{>vI;;jЕ},\"n7g]E,<nr6ڱGZLx\ZEC\ZEde:8UHqOR77N^S$M%<D|zgJQpdZxgtSaocRM/#*tCuK;?t/edFn[	N+F\Z}=sXOKqpE\\Y70\r&^ҨZUΟZHAi{^)dN	nf\ntd瞏b(y>\rvۋh$<-}]FQ*i7yϹm6r.Z5cI{:{c?<̖qɺ{\'FJ=kf@G9}\'\nplRخrꟁ$%(w^*)}0vcW8[\0jF_D~\0,\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0VtĿOYj\0WOY3\0,tj>vgsWgF^&nlkTxM(T۔˯LIW>;%WN}:enǪws\\ZSW.UmY?y)Xc^؜bY^x1ʲb0ax\ZFD-ͺqyYݕRYitҊlSDٻXҾVkF29<\ZM2RN,q,tkx漳J+_ԡNƍȪӥMuftj}pgj|ׂayZ.P^idOXXдt<}YϭJ6eNQ*\\>\r,+f-#ctUݝiF^do3Yɴm=z{\'|I^j5g?b?k9Uw߿<boc{\Z-yC_-K%UO/(Y72ȓEJIG/%kCi-(*Ҩ}|z88#4ZB\r)&,۔m2y<J=Ⱦw{7ٜ*=WW1ܶŰa&[1j5c$	&NWBYŲVf0	nE1%ɮ/LBgi<\r>(J֥HSJ]<MB*ˋq=V(f:jr_z\']Ei\\_V9Mɥ,)W\Z0O\0jrqy-B_%r(=KHlGI,BXdv~G5m#GV-4eqyQoUu\ZvR**ڝ9{U<]->NyJ2^{SQὗsre8,+֯_iU__$h9\'b-J*gg	8$#&٭4v쿉ct		.l~a\Z?7	5(ǁ:f92`\'۹(im;%%)aOb2#Z\08(z-%Gѩ\'Q\0x\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0_Sms6\n5/0[Yr=r^{s>\0/dl?;9s[eJ(rK-[*熏zo5paF*5c(M?YzQJ|k[9Myҗ,hΌ_a(o%ܚ}RkJզoID!蓗B_#;Kqy\"+	J=3[Hk<,ԑStFb{E|įKď\rb+&m>-hlV6ꬭፖ)F]z\rv(Y|;CK\nfMs>Vw--JT)u=Nja$.t`}BVwbՁ\Zޛ!O\\VICiut;Hʝ̺nIVqmMn-%xm9}4Sv]VI/RiP}$s5Drts74Ec&N693G>2\\Io#f%3WQexMe˦J[,dkOQUTxO\"xSh*;΃2>Q4\r-j-ک̖M*ޜ\ZZԣ)5D8~J)Q蟁(ߧlpr6SSR[q7;\ZEnNxHG;^cOl[6(VMNKuȚْO:t*)sg&[cG*ĺ=KERnN9_qOv|O٩Ժi<סmS51&]NU\"Is\\֋,濤:}Aмh[Zi/fo<Oo׾\n6-3gt\'DU$D~^eТ6v5熩/:p3i(yGxEr.x{<\0g*momYUq5woyy(Wbʚl9YpT[<gbʜNma7U=q1lEZQ5kmmc,</uE5exQѭ(6\rNr|w$%Se=\0ͦwǈ/gݑMl\"!;R\0\0:?7DϢ\0x\0tm\Zїm/\0<a\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0M沯\Zr_aqUo\0~(ۈ\Z|IÖ4L&]9/q❵+~>ET^,ghP[IK)~ƥjG*I&z/==|OĲD%d	h{neY\'\r|c##m5*qu%yO49^b_yk8e3{Q|qQӪ5Mr_q;SmRwѯ^\'WQ+#q-KT&ݬH=ʦW?9)tH|͋[UK1{4j6$sճ_IiW4uΥ:q̧6xJQTYޓotjo:\Zj(S˥oĢIR9bIYRqyo9[)ϑ\n#6:ykŦu6e[F+O4Ǧ#ef\\wS˪U9DĄV2M\Z6bVt~$\\d(Eo+؇\\x,&Z\"}&&=\ZԽaakIT,~fޑE{8;uUV[<XfomSBJZ7-v4QȎN-).鬞w?P\'NQΜ[zyESFm~%gI-Vkׁb.Y躅zY4ӝ[d\rF&<om}s6+aX|>Ug˞Z0R}G>|R7!>lv?Mn*KEjMmF\\Y\')=&|zXGt\Z\n;G^&WGTM׋$ΒI/rF<[V*_]>gNX?Hrg\0rg*x(yڝTB>8?>sH!0\0~OOw56)\0JQEϣ,gN9}$&Wgiz,9i*McZohzmжR_NXR[$ˡUY&C\\ɵz,Cǩr[}@\0Zj\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ݭT[5#?`mR.<X=IFP\\q\Z(y-i$E\';\0mF%pݕ%d-u;qI]։e:Ujo\nrkiEZLáƫr:>1[8Dv}Gy\Zܽ~JRWr%\n	ӥJ.u%%,.\Z^o;ޒz̩KX64-Mէ5.\0?C7%F˞NIuu}wׅRw6oS{yG\'JVYGV֏Ġ^{+74!^Hԧ5/)qiG2pg;Y8EmGBRu*%M1dyGDӚg9ҨaŒ4csafix\ro:No;XVR˜$tciޔ)}wTzͨ\'YƦ<wkQ4n8KX>t$ψ<#_~r ڌS?o(OvWFo޵wtgN2*C8I~\rJTU|\rUkJ+R\r!F)sR(cE<\"yY97񌟒U4\"qðZ:Xig[op=RT*ь$Sٝ[d̫q/·RZjQxi8;+YF{DO?tK^V~|?O6qJ?qxPy38Pz[OKaXh}SE=M	Uj^\'\\aN>wJk_U:zWP\Z9Rz=)s8kiRnQ4p49OglRzU9Z4Z|i<urY}/)wZZ(U9yoQ_&Gdό[mRvV#;Z\ryG,(XCys\\Y48秾r5;ǮWDpN5jzf.U6n+Ϯ;Q%ӕ^n*Rt_s$tb6>{\ZhtmEeZs+	lGfMax1V.g?n#Zg]=3=L4-J/ړ*r[yE,sH*קF1XH2vm\0\0\0\0I##*B=YgF5{+ZWuСMfsHZm:)Ft^FkO_Fdl\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0$Fgޫfꭚ2UTI6}J#*ʋIx;m9]yjZpx{]6*Wtju	FNOw [a$LD\rԴsٓA.N6GU7F<g?23}фe&܊Ex[lM\Z&Ѯ%mWN_/\'**M:rM5~Ijs)\0Yl1T\'G=3!>;Ԗ^)ueG|\ZZn=W9GKomNПnkGCF?ę_J~f,\rGmV֎rpM(ض|))Ie긩WR;>.jvGm+=O1T_=ϢNsI$>.sN|k8F+gwdYG~J]_NSSf[Ӓ7Qs(,nJGnvjh-RuhΤ+EnѴzVsW^ҿ.^\ZZ$K?dzx\nMre-.~zK;X^>>g}6xޜ~\\kt\'Λ>t=\'KMҔ(Tkx\'Ěc\0	ɦH[OҖ8Eӣ׭Jhԧe(kxr5Fp;,dp,N?Mnur:G-.L:\"+[UԒ/Dy,B6Ӕ\"OOd+ꝶ靥iܻ\0dCoJUFJ	\'؂ֵoVSNG:r[}O32	B\Z=ONö9\'5.9pocoXRns)zgRոQODy,zCG\nPܷP\0\Zk7ܿ[GbDa\'BTo*QmmEmiu{%Ni8]0GL\rg/ygsvKQ|>\"ڱ(ʣ.HX1Έ$\r{{e4ʊ?yM-WN%jroUIFO$u2RMa̋o{>I5Qt:2NeO8]zÜ5Rmfw>\'Uz)ʝ-(g}NIJ}S}Sm̊UX~[8ȱ$}\0^h\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\05%?d\0U~QЩrV\':ľ8_zJn/={Hz\\\0;\Z:Kv9|wtk;Ks&C\'X\0\06q#mc,\0c6RpI&AcoY.cWj	>$&|[9GֽΗZ[OU*:]6ZLߡ|J)-QL=K)%7ߺ9uO+ѕ9GkSK+_mn=׃zi=YVӨwϑE\0\0V+k\"*,\'qZNi,I;*t}Iv*NMnʞɵs77g{J*UOI௉Vt;׸x^i<,&\\I^F?i9GmZ;.rR^컂/<{|uT:pxQe:Ig5gUPk6zIVSͯHVԭJm4v2P\\ɸy`_U\Z\"mĴ]fK/S$/z+uי+R,ΙeQԏrK*Vo%giSYu|9.G_\0OSscgRRޗ+ߕ#pjvCM{~CP{Nyh[>^S2yLgu\nl%Rw0:}8Z&0	K2[Y<_P8Sܧ5?G?KB_qO?GZ4)Н85%ͅ8kاN˭uZ^rVP4]W\n7\"yM*1FҌ[wv>\\fOvv%rMG[*ܧc{.kح=1SMLAj)StkBNRFej؏O3,c	`ck\0$7Q̷a: M/c[/--q\nNUEᨮȡS,T\"ZT#ƾ>\ZJ/$Z]é}sTFcN^mVnRs9,hѣFJŶKs|zc;Y=V:jZyu՜^rX=U-GFq8m37~҇TWUNQ^xLWa\'^\\?MkBnn*]<FtK8^O	j\rKO)NQT?\']XUt.(ԧQu%UTsz\\EE`*U~chp7kڜ%\\Ve7ecjƻa|?iYNa=fL<4wa\nkV\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0W\0UW\0U\ZJ%$tgv9\0WoOg\'z-\0e%a&[`2Dnթ<V:~?+&J{Iڡ8hx,٣S)x%Jjt\rT_K^F_F}jclk-e;nG=ߓ$C::;؇SK.S\"x1HE5~\"1%̔d%{BW	M)4o-\\RtG+GKݑ;V-?&24ftbS\",3ZLOác$$-eu\"̲eYb8קl;EYdܒj΅JiG]B.OH3J-oaԨQ8özjOA)sT}JWfv1ug.jFyWeQEtc)7ݗE,m7rإui[g\ZQ/u-tU7)>F-KfcG+b`ϓNޡ(Ê)Ɲ5aL촎Km2xdw}\n*ϛeЄLĞ^O##Ū֬/>^*-ǚ2O=^T.]螇[KӣDߛ{DҴz*E,{Y2]v}{UV%5{b7\Z$k&͝[Fҵjn\Z}+,t\"kNޔ#:1]e龤g5KfM[6؏y\n:<KFQ8VrI3m~??iyR^:k\0]JUӒ\\K>ƽ?FF3(!]T+gՀ\\\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0#?q2\0#?pY\\hlڲ%%^欿n?UĶ\\l߄w^I|Iӫjk#ut;UYh[M3\rowEUbJp}%Q.h(y3\"=7[itW>y_y\0SFJYKo;|w\n֭VB=>/ҔV4\"S(XZSV0y4K\ZZnkaG)eto.\ZkFZ88\"{GꙪpz>\\}pUMal]OGOe$F$\",DI6DZJQTˤVIl/LRٺSq936Ʒ5kTWWInc7gASR2LɗM^zwAxQbenH{GԲ/=q0`[O9*ÞIG-чٳNH\'GmMF1߻m:4)({:P]&2m99]1.MF,ks8$lmivolwN;/\rOP8i4Xk,3v=G֞Ќt>]1١G^Tq1mE$Qy\0p5\"bH~1$\\j#9(#),癶Y.(pn}zx0\rG-I%2\"$a_S(h3>$2\"HnzoMIAr*U8W=wQuUI@tgV#>6\0\0%:>KʾQȢUu\0\r\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0W\0UW\0UZ?m߹K.ROkˠGj\"M|{zbFfl{ٍn$.^gKOj\0v]	Gʽ,pEqOK,(WU\'̺?H˦.FjէN;>iv\ZEm,-B{Eo\'Vđ$κ\0s]NTQ\"l\'^͚/(S^Bu$Vđ2D&D21>VFD$N%ddHȱ}LWTj+<dc$[4{7<YFyIm->\'/24u2{r\0G{bpEobX9L1$]Ige~_N?/\\z緁dr\0]N·oǵHF.SRgNo`ԧ.O̳tMPueR<F.sIwx=5/SF1K-g5BN̝xТGsZolɿ⼜<oQ~le;nQS.iCiua)%hU:W-E)El\ZLA]L!YE_>Gs^&>	\'<5\\KxL$_ c#&6\Z2\0IobUeimt!Hٲ\'XgD&,_\0ր<\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0#WSVH_OXj#w^EEF}rp-j,3)-2.@ɀ\0\0YQK8D[,}>b;+~K\"y$\"!$ȘfQS1.dF}HH}I*j#==R֧cno$k`QRM2K>{gt[	9y`7ۈgYco;G]4ML\"̓X\'y-ő5h˾i&VOMF8rt*\\ޱz+2]_CW\nq6uZ]W=ۋ\Z4xAlKl#Jȱoc:~;x^%y$rg>rmUE5eo7jielݛU9=͗JqMu&TQ,ObFL	\"Eļc=HN\nD7kvҦS\Zӭڍ@2T2Y26Dldd\'2U[e:O\"Eҝ\'X\n_ɉ\0M\0@<\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0#WSVH_OXy\08^\0il^3qW}3gj,]C}Jqepd\'{eԊ\'l|eKSM`reotVĒ1IنEdSSݑBofBl,DU\"U,s3xlIrOedݞ\\Itf`++ODmm=-Y$܉\"Q.[h<]Y[M|UQgzN0]!\ZrFݥ*WoZ.Piygϋ45U4d^EZ_naVs#\rGbMYklITd^53ή	|M^M6^雽ޯڎUSe$VY4L/bhlFQ!:0`I&Wadלy^q_Yf9(h27+$g;2TL\0\00Ro[UWN<>t/޿><\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0#WSVH_OXy\08jlR\08jlz*uRˌ-xFLh2coRВ ̢k AfIl@0]YrD#O3$\Z\"ɲRA,\\y,DܙԮEKk}:oyc:/ \0Od_oãԱ?rťݖ-G|;}]>d(\')$zM*}^Iܧ\'vzcGG\n~heٿ[Odt9EFYE\nHdKdZ6.քu>in,H,#ױزRǯ6m\ZU䍥ȱyá8l\ZdN-\"q@$dL\0\0af5f{dlce?2=^rd6tH\0K;fN\0e|~][e:Wx}䍞_@ z3̀\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\05%?d\0U~g\0m\ZqWٱOE_}L0@\0#Эؒ\"\"g+h,\\k\rԥ\ZWubĤ[YBT$̚k	BPzf&Af\nrO!&W\"qD\\͊!NJ1V;kB*/iKk[l`ͺhHƽZK3{JKyQ\'<u[gzTxĪ^f}L\"l\\94RYgOJ=dr#9Gl}M-ٿS];prg.OlJ=HhH\"J=	E\'M͈nxCfL6cصUKnfdIQMijѩ(_#ey+zGVV2TiqQI^$Zk3)neΌe(e#R)5EK|j>K#\\ғRNOϱ׺{/dј	,xP}LwvKH-%5U?د+?ei/pY]޿6{}\02\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0U#WSV7j6)/g&\0o?lRE_\0\nKxK+\0@DF/rdf= RDlGs,_Eh탓?萿_Bxh؅Z3QɕDi?%MKj)ך&L**wK\Z\ZW5>\n\'9~KLMiԩJŚ`芦jOnE$k+,Y.ES.M`D͋ZnUN+wy֜iSPDjiʄ9}Gdu1iy=\"Ȣy+Y%4&82XbMBhV\'{Ķ+t,)lzDYtŉlS$KaV1RH>M<v&[_oҮ{TȋZ]jKs!W\ZmRr)$c+&rmN{,\"!9qFs\ZR\"f>_WX&c\"]FL	\n	g`@&+YMw+?z\'U!?_~\0(Fy\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0F\ZqWٱK?5m0V?oj$G1T\\I$d$DSAAu&IfcԶTzR[h.#Y\0xruB\0i~xX$Uat(:W}Mz\rjɱ]DF_QSJ[WĦsZfJ*OĆ\"TlVFUXJ7Z=EXXF5|z_dzh7hK=Ǯ;$Şm{eM|J㜖 	Hu2D>ňRKLt,P7-I,\"$$ȲISSK*IuQ?S.yFv#s\\ͮi>0=}5ƥ3Hug-[g&ѦdrEGѿfB:;\0+\'_$l?ўd\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0)$F<\0|>WٳM{&\0omCGGWHXRM{AK(M]LXFIdԺUIe9WKN\nlR^Eј.Q,ƱB{g*[ϑa>*{vegSů\'B32eTm8rNpO~TSsMYg8Kn+Je)To<:xKԑc[ZsQJ֓I{;oayJw^w5UxY^x:5lt\nzN9҄uG;MV:εƕ\n.R[{S}ophZm)I2X[Mq:w3nGzrYqk6dl+OwgQEUsf͍Ԭ<ɯX#^\"K	t$m:4٘܊J(qsܟ~X̒/-I#Os(4Wi<^#в2%ɼ(Lcebi&$D/mĄ7Daԙ\Zآ┶k]\rT8stzuJ|xdS{nU.*Ӌׂ[1YE FO}s0	f[lOtip<\0JB\Z3_\rsx\'W\0Fy\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0F\ZR}Wٵ՟ͪ]EWqr\\|FLd\0\0%B}CĶĢECt1.DXˢ>\\\'_F-w8{helUhOgswZէʛvuVmTgOO哲/kֶH59+KZJxĩK-W\0F#F25V%Ŭ)~U!!,x#IQqh<󵇕\\}Bi:4SJ)g:O-k(iÞ.67{9a}f%I$!6֊%c+S֎{+2u0`<R)J=@\'y0Xpmx	Gor]G	V$ +,XE%dz\"l]H.edjRb0(ĈDd0_i,W/F&^JII=\0:$M\\AWW\rCG\0V\0NzH[g \0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Er^LƧ{\06-[\0]ofoj-3$DD-\00I@u>4Ě#/]T|KMJW.OfQlZJK9[<ŚtiСUUtˋƳS|it(Һs]Z9IoZ|YZڋm*98(ҫJSQ|#c7zy%&uEe{nĢjOhV\\3*-5E1y^=Hr\\}nm^y͜?,+}K&TL8`>#(܂$X2^`%I]h[# %x)ܶ=L-EI2EAx(OeقQ>yg/PM+i5܅FUSJ״)KRm,[M)S%_y߃wzU!58&yzUgNJQMtܣՇ]r)u-oQxM>礍z~2O;#|\'3Lы^EHJslb˔!E\"A]Hщ>`TQV)Gt[k?\"ٔ?i\'_ϴ=\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0d\0Y\'[ٵ\rt5k\0:\0klڇcwj-Dg;.Fpcw0d0ef$.CLzEn	ǡtJб4KIp*_x:\Z8P.ig;Y$c(R}uc\\:ڽ~#ѵ+:;Mk;ZkƬ+,y쎽9ν8=<˟y+xɚSw^ITo;%?uZH,҅}lʸm	Mtt)ޚIgQ\0Y\"8Kl}\nmBHD2\"(22ci<{xf	Ed,]VGKlж,=\"̂$Wee8,Bo\'QgOXmтۣ|7=<Elz[FSj3hIe&Qe]O_c\'+J2@Z\\-hC/ҙ\"d霒^FV\0呗C$e\0}VkHFUakH~Bc>Ҁ@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0滨1e\0qu!Ѩ*8WSO,->.g	eGꦤG4f3[Fh	\0\"̳	e(#\"qEMu+dKW]3U%:pp&jK9H\'&\0I,c+-7Bo?kbxѪ$qmBWjU:߷sV\\xw5)=NMBoF>a8ϙiՋݷ)MAhjz\n.:{T^Og5	_\\TqNZE*F⛽Fn2SYHiU7&]`s[ղo::SM94l-,Sn~ܛi}_WV^\'336.~6Ku3FJRڅZua$3]R\0șDdYMDbܒ܊\'#\0dIt1(3]I\"dCj[Ye D=2Vc;h4H9۶9^NN\Z߫=H)EŭĻTq};?[#M|F^-H#($zMO埼Y=l3O;gOpGCqɘn/82ak_Fzq|ZCF6FFCN\\uI\0FP)rT*qvaiu;idlئe$YEM\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\00bOUGj.Yї$= qθ߶w댢tԞSS-qD8eW4j4Q->ҧʵq謽!qEo#^?R9:}+kvII=סTf4GgӬ._zDe\\HZ\ZS|mټc>/b_!|nS\'$S:!㟧-tgŔ&J\'Шl=bߔ~|0?	c1ẞGk!m۬g[蕯|I?o=YmZĝjSU!6eG-׵>^imz:}3Yk[>aG~4m.n#HQ{	֭*spub=ʞ\\Mf,f^VuEгg,	E%M(-:W(uq*K^{_hgYf-|ظ_SEm~%s}KE3;5ƥJr~DU\'&ZkoUJy[EgyBO9ϊ-.pܮXKcؠy]F7<|%ԶhߋoW\\48tl+58-5k5H^p|\'$I@wy,T:G[d[}VOt]I\"ĺuЅJo3Dm+jMee2Ge\\hץ״V<:Ss\'W%B<Hʜg)	ˑ\\E{Kimhm&po=-VChILe%~}).}6.su17qKIu\n9|_d~yZz.+6՛z_jʶS(_QR<u=7^/W^\0aRk^|-<I={1d\0꾙8~Ɗ6JaW*g);qp[(Uzk7⛗\'SYĖ\ZOq͸jԮ\0g9fpiQ,eLu\'RY9My;>yW)o\'4\0)2\0H]ZU\"uX5@g`\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?zA\0Z߶#x7=ou\0ol4˳}|\ZڬFۊ5dV9gttω>(\0ncFv$غ۶I4ؾM>Rt[-ɹCiankQ[d٣bgBYIt5(ϖI5l#ofRa\'}O:t%6u?fie/\')^g)N^TrO{~wMmuʤrL_xy~m//֗luD7F]C^k	UVskTOӉ>R[.eR^5d]ର3L3\r_msZnI\':Z#Z<%(_We{\Z5#R*P}ley+;e	jt5}}S;>[(xu	Kj75I-)]K\"d[>${\Zw~9\'ɳBiSQKfL{fWRQ e3&QZkМ&Ya?veۚytqF&DꖢqiqC>QNJ.2Iٜ˽\ZLʃS\0k0ߘ3,ZiY{8.>`{}CGqMνuB[Rvˌ|֥\ZZ28.\ra>uӌClrki*oRqN1r{7\'=bm\\cO\Zf{6aI]̼]ׁ`1.oїL+o\'\rgS8c\0f7;\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0{_κ>^{<b~<G*,VݚLۭcZ{7>f4DwY\'.2m}F5㝌5|L3$׻bQ]*-/ۣ5i6t߱K.:ul߱>bu\\w_cT-ZI+hߗU>mэex{X5׻=}\"TjQXVkGmQB	++\\/)P̼2q3)ɯKkS~>M̢ʓ^ޥ\'P꙯.8GOe#c_/ANi}ӈH|lVe8S:PfMHD|Yĭ^Da\0rKF	2PmМeG=ʈ\"t,iJNP޴q-mYRqѹFTZhϺzJ\';OXiЋuab9.ObZ%$X2䶴z8<eܒT6gJ/n&r,ZfLd3Vrjϕau5ViD\ZM59DB5M/~3XWzmu(_3H\'(=茡-ICw<;p2>MiM˶mZ+2\0gÛZ^fu[Jw4{Q>ujj6wG/j}!g=pJ2=YeuS{b[էuyGz^sŴx`,OlE5*l3bK#@յfm\'k;i8!][e,)Z[YӣaN+hb4RQ/(µ\n5~_OCQjM<oI1\0ŭD~x\\3w7:ugI/?oko;&49xǷjϝ@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0I3۪琺;&{uO7~q\0No5jHז5Œ$	D\Z.}O\rTHsܲ\"YtȗSi7ZީJ-oyv][8d}?G^{gX9|J=kOc]R#˼LednRzG-։ HĢ,{+u/u\nԄY(=y}]T%\Z3o3Vekz\"%;R_n\rV5JX}ۣ{WvGzKLcS⼖2r\r*8䢶a5mٗ\\_V<֥BUl_(&X<٪r%Y9X+N[3E̚L)2\"	tEBy!y2m9/):T߷&1ܾlʕLi/_	:	zS[G.u=2轍kڴv~|Mt/Rq{Efw-VF^Ee5C)v5o/.	Nyn(\nK=4d\"V[LSX5\ZOdT$Mt	E},Au0\0t21\Zun(/eVΧ/EvU|F>/U9i,9k~kWnNS\\yY2TS+F֊oF\ZiFKɍKSF;];ZiRm\'߄YӀKҧ\rѩ\n{x>UzOsẶ\r1_VUNFk_s	@4\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\'?yx5\0T\'umh[\\\Z[>frkUf4ʧ+,BeD:,`\'3IG9e2ՄK!\n\\,c^EG{ZX>×=WAu?Dф)4G\"C>KKjˉY6y[xGp-m2v-9(2#I\'ԙ\\`~LO)W\"hܮDKvU\"ؕLju!.e/Fnl*k-+mb$erqhen#ilZzdeX[`ORt0!ВwB?fPe6%qۯrFL5%t=\rWZf~<|jeEqӋ\'TGR/eeW=}J/J*KLE{Gqpn-arRhV\'їbz%9h>u9RzL.7CmXwZ4\Zʧ&חOZ>5[ZӦQ1.|j02T[Mr\'W}K#Q^Dt&/^m:0[J?uSi%r3)M䑂dL\'`3/	=HizTMB?ѥ-*Eٶy>6puN_Bfl9RҨ\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0`zFשo?\0ynz]\0)z#]=CG\'*,WۡUl[eUeRA2H\"̬f=C2YشV՚W5}h\0eV\rб>g7C*UnOƭ5}CZ=OMA㼺oAd,\'99?B*1QE]0u.%1fQ3\0k|ST[ezd4SSJ-r2,Es!$NkBҶaT|%6VEm\"j-ȕNj?I=:ZI]\0]E2\'Ax <\"IA\"Qa<Sd4ve|N*=ZGw71#OiKsDgY-0YebK ٙ\"j絗瞿k\ZPogc/|Qw\Z1iW~M[)~]\\JRS͕d7U\n/\'vxF\0W-\0VN!y[EUF*)NQ@J8^ԧz}7WHty>8)w=\'DNOԑpN2dy2dɖ{1.Fq8SJ^%KU~<W{:ie._R%VE^[> #l\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?z^\0)z#\\͹}/[n7OsQʷ96j}2m[y\ZLk-6gD7J\"=M#J,s7r]\0|To}c>9\Z;T*ݟ}K]N|c$+Eix;lz\"ĶdВD\"Leԛ!.Jf]XelLM[gsVQro?\"Q>[4ethШ{S|:ޫy<^^,(>-3\rǾK͞ yyEJqRDfI>Sh0bɧE\0j),ؑ=%ԿUj\'eL_*LzC,u3o	oMfk˔5WT\'F闲O>u2PO+0s%5N/9MZ[x06I<3i:fjwoR	YGڍMCui7-ۦ,hcnsK(/FL2FOp\n\np[%fɾV6*c.\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0^^/u{?K\0_oGz,lNUY]lfGܸ\rIoOy\ZL0G\'_FL[#1crtV02UH}ЎzhbtTO\Z-E5e6g^RgåULb.H.-m2YO$EDt&XB^$	\n)mMU2H^5l~5nl$dE[Jo,V+\"*Y؋$rxV%<fT7KJVuۥNlR?n1oe 0\Z\'Y#МD>dL$|ZoiN_zX7BQRZgV 	GRta,\Z%:0_\'>Xs#^sf&^ZXʼ!vW%ӍFr˛\0#FR_%9Ur4IXlpm\\w4R\0gƺ,xa#}%F;%e\0ao\'M&=ƻ)=3\0PJJ^h6g)ֽwiʤSq]9V~OvK=tq8X#=#+`0}2;3B}J쿞lw\0?DՕ\0=X\0_D}>\0d\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?fC#n=ɿUL\"r3VGjIlͺr87i?-2R\"XTe&b;K+,WvSlFX=AD8W[Ʃɾf}Ѭ<cކCׇ7#֥~Q(da,#1hvEm2YH ]B	\"dC+ya[0UW*]WEB*Fk:\Z2Z+u+زe+y+eYXIh\0zUGݗzeGL&UgL5#Ӗl\0KsKLLDAGT:ŃLid8w$4XWe,at2DIqQ2j_GlʝIVYgzRW<eVdmtx>?߹\0os%v\r(,vY+&ݝvG+r>t(.uy:dA{|><(P]]2	쏜u+)UQ#rIOt1 Ɇ\0o6ֱd+)\0:mz*{E\0 zC\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0M\0JD\0\0uOmoJGsq<Eg#c\"r3Zۣ50tf#dc-*`FV$OL%%(//)W\0kfo5U\\SV?B۴g֚TMq}Zy/(N??bP\'t,ke>2at2L+~a\\`RUPDMEMl&ɯU/)K>idU]VXFeP- #q|΍_<V#˫F]KĽlz,d12e.;4WBQ!Iu\0> YUfC)g2%Trb]W+n7ʡ$/o[L9أevτ5-֯&%WJ.6gfTZeįӪ1#vzOD\01Ork^&(ׇZ:1<\0{:E̚nVM%&|&.6?\Z	).\'D_e<d#?tT?idPW֒}YWgݗD}<\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0~*VxD}{Mǥ![eG\"xlzodNUj?#]5[\ZFfȓՑLrK0e\0;EY7,kԴsFn5)IM5j-rXN͚~J\ZkM9/	w:Pꏕzդhg)..\Z輽gQ\"f+XI\n)YQU>L)ֆ26j\Zˤ\n߂U^exbگ\\sM򌷱Z>4=tҍ\n-LF\\bЩG9-Z7Q4\\|0NQ8ȮKSBžl0XEd̠YekbܑN-`>oeWqǴ[3徚\\}>-b)Uk=I?tZ}l#.q\'#·B)bY\\.VYgഏ[2nzGbL/bxP%L\\梾O(/tʫ4F8tee36zN5#$ܒ(.%`k$XBoHB}\rj幵󹢿6gU=Tgڍ>-nȢ~D}Fy\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0O(]b=\0[}s(z_o/>\'D]eU3S-|zKT4(sI}لg3yi>ۢtesЪKhN_[oԟ~N֍\'U_Gx}o\Zs^./u3ֱb=IRu.Ҥ]Gx	\"0IF#2o\\5zϡuNSHCVgfCY,e>娪^+9-\r=\\(jWjTg^\Zxj+lrzG+\\Ҷ_b;+ZyIg+88M7#_*Kݒω\"%2d{I<2#0M2IB$.M>U,S\'N\n׎IFzOʣJk=g_E\0yĚۚĒkmQNyN_y-S;tvKKGY$ZRi-*5w?H\Z{XK/Qh	im`_&P\"k0$p\0mfC\0Rf?hC\rWOR:XllǕF[2g\0 w<\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?/qjx,J>GP{z]T^mCʻOhk]wlKYTײF\\7mMA|xlǞb~9R=٘	v6(+=imRKH%ЊYXTlmi[4vqxkuG&d\\_ɽE)/w]v<ߣ[P&u^kJ\Zsqd$MD$a!>ŏ+EN5\rᢉIKtX6i{2{u*}bSZ-e\"#R\Z9\\Tseaqեij_˒UwW#N+	2M%c;L,xle5et:2HVXBp،wؒ0D,Y$`8&At$N>\'+(0WUQ\'\nR~L	*=IO}ێ~:f:|\"y)Ege~x@n%t\\d3iE]\r.~*3AK)1:Lvg&myJqkSѶR\r?i7	lYc\\#G\"4Mc\"#L2e$̄\0}#V9hrX>m.c4ix_\"ot弄igPˢ#p\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0Wgg__/J=Oiʢ&wW\0JT{oESיlT2*~1,,,|y{gs鑺fcE.]l]E6ǙzȮH٥voIaԢyvKnƬ͸30k<[b.\0>\'ζ>ehkkiSQ#˗Ow89>WOr<\'!,yմYOۏjy/nFT%c7geFO;s]E5\0{zr|+>o%\\tߦ~	.G$j1w枓CQKZnKK[l>/kPOJjO+x&IQkiFX))tYgo,/r3yaυ­eÜcjT,hԫcق<KY9<ʔ\0\'\'M$¾kя\ZWo&;&0R̈́G21F	EHs6eQ4I#)w2	%MIHɂdЁdz0scׄ:|.T}?lm>k2\0dOҐ9{QM.qeoz/\"+,hMГmGrZ#vw-a^\neѮOF^,Zz~V458,sKh^g1-Щ8>hKQ=6Ի?FxWo2H7J]?Jݢ-G,ԂG4kKU֙yN;j>M3݋-Iv:]IǡI&K$C k=OzVPszѓI\0M3)OҔeΗѝtΧH+\0Ar~HyHp\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0#fzg廸QiKw_Ǌ#Rv2]zLuke[)^^_y%Mn\Zsfinׁ$\"­[0ϙ]o%~Tk.-dlM	9nz>J\'<57:^9My16So޷K)i6=РTqQM0l&z5)&\\aoQ&>\0y[c]RO\r5\0Ԟ^{&#\ras+/f:U&1r4OF6rn\Z8WߴÿϬ468Z:l\0K>sdf.MvX\0acUG\0<_{ϥ%Z$5#؞6<s=b+$2(#vb=̮Vllf/s]F/;\"ZHbD\\X25dQTYfqВ0Ϝzk]&ԛ[=*\\QgOV|MCsR2_[K%b2V9O#̷ܵ$r~.H}2%$:y#m*6yegck\Zw>v⻜>~nSm0jKfWqzgݸ38q~]/9+/Sӵ:>Os|tw7tFƪgu^D	8Ǜr*EjKB6:hAZh^}+Dr:_SGމ[v[ޏ8}?nNJP}/}ө-6ׯrV%|GԮ5>;{(WOny/\ne)N:ju,ʭ\r,XH\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ON\\GKbUUnWJ\\u}Zӈi~STjK)G=XvrjLדK9IMrԍLc)^\'Ev6iUrM8&Z}>ATW.^o\Z2W%7dXY:w\'t1=HK}^eXٲYȲ#,cB> lYf$=̶,F\Z$lţC%FaPO|.[آH3z8[KkS}$Ӈ&;hUFI&JZm7n,F\n+umi}N\\Ivkb@_eO~|NMۨ7DB/6/x\0iuv{w>IS֬A}δ}W?J=?䩎%0h7/sI6DD>M`s%܈x\02<adyࠒ$FiO=ٮ	E2lg|lSԱK&`Z|e_iPScHN5G~}Gk>Ce2ovTȊ}Y\0v-NX:&ԒIĮ[d2ˆ\0+(<xd;zǞ|{/mRW#l`,Sj)Ƕ6leO)d8eY\'ɶ[KsEL5ceO|2J1ߦ\neρ}i\'pb}NsXi}JmYE\0V\nnZ[\0g\'?.6oEI\0\\\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0<Ϥ~/1	۷UIxӇ5n֫hմ\\{KX_t@5t.7ޟ)J9t+bxk%]JuR8{MuJ8.NwzD7<S|z>	-ݫ\"2[G.vz|\"S}L&إmQ\ZG;naK17<2$zmӯ(K_JQOsA1ܶ0$؎JKsb\Zy[2J\ZEm:yKYF5\"<j}rM^4T.{%}>Yr_/)zf[b<<U-rX~G-U<a4QSPs5fyZ,<ͶF}J\\wQi),?&SVd,%r:\Z<7*ڤ\\,(UeѫNRQDj7Н岋NN\Z\0(Eev?8[sҸWI)|0}Zѩk}a\rN\r\0[k:}k=ͧWJUǁU9-6nz\\yKcoߩ]g><l:ϳGozEJ}XҍeI۩UӗIW|t}rxFYa=]tUY1x\"B=ѹ\Z\'Rh-ӯY֬6NRKEsM|U^\'ko%+|_U,5\Zp{RwW5Qup:64P>]OaJ4|>2K>u\Z[M5JԞ$ˡ\n\\-Ö*U?]V\Z=)ů#oW>qoks^\\T+u?Z\n_ԥ#\n\',n3y<jGߓ؜4.|<\'%RTm5>1<M\'FS~̮Rc&}f=hog\'Jm\\Ө,(54SvUdaɬ-џhPK\"]5e䊬EmU/Ioh%:eq|aR}8[Ot:>&?5.$t\Zs\'qs5ݏPq2r]_JUk\0T\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\n/oҹ\ZEJ3OL8NjUImQ|0⟓}i{cwVֵ)8ΝX8-uO%k@\":4潷E7t%Kɟj_Etr,P]U?#~^X|2w~%uex.ԥ:wNMF\\\r͈DXgA%{[w>S\ro3;v-Y*x;jcT؋bOQx{<>?Gs[</)|	g葚]Tj-d?$#</5Go\0վς/}.w!.s,,}?$~Hn<w\nus&\\oX\0DÇ[sɟS\r17Q$\'ǯZ\r=\"|ZT-I,y-&yρS_CWzhRJotw1OH:}WM}I}GЪN2xGI$_xUOvy\'߻GظZ7=eSI=\\i:nzFK:*S禿}KWB~>S{GO/k=*)<eRxgq9#]D\rTx\ZLJyѝчw%\npO{}ftcf(M܇\ZQX6)8&.Z4ҡ#fiɹ\ns$]N6\\ő\"f)RYR~f;S?R&cVV\\&¸ݮ\\B(6֛\0`k	aZF?TϼxZI\'(^Vw\0Wxs8NZ}uz^<_z:52cO<w}V&RY[x98_.5>YgPҊRj\0Ӹk0gimg=#\r+U\n1Ro-C\0!]<>!MoX&[<_[c7[#C8mfڜ}٣\Zė*Чɟ#3Jz۱Ts}:{I;BcT`ҶKJoOdA4+{%uWPiǫ4e\'8]2}VwS7_t\n>ʴDyGKoTXj9M\Zt-U,c>%-wUZvQGȹ`I?Gގ4n.%j8Y8ԪYYo>=^j2gcf,cZoWSi\Z}-?LikF<RbǶlF\n>\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\042XXjVm,JYn\0>6k)U_NZXOH<7K8j\'W^ݽFٮ.ui^9RFN Ůdd)Jɬ0gcQSm9)t&#IE,اuf^z<ROkFS:Tpܵ:mJ7nЩ$LfQҢ2f942١o&N.wd-RpՓV\nxFQWȄ?D#IҴ|J?~_%\r$ٓNV:c]~t[L:TI=ȮP[Mqkh$M|}Ls\ZZ]J:e*tn4)RQo^\Z1%i^o\nڞ_prзT!ߺ<K8n)-,zr&q&ڦߙGpn^N<)/(LˡOlS[,,OGsOcj\0>fEx\0v΋)A\Zw\\->ڥ˵6PR\Z]֌VWF9rotW(<ɖCHRK轓jkoȌBI,4`I6=(j}E/l,I?N?.)&eqS}\"23%N_hYӆ9aO~07%iiJ\\v y)6\07Ea\\|Iw WoD,6#,$cDq6IBYo\rMs[]ӯs|p0%\'4]2\05]\Z9^XENJD[oA\rS*kZ(R[Чg%ؓzB\'\Z[DX\\\'Zϼ\0d\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0ˊ$ﭪ+MIGjx)/{?4\Z=IƾV8\\k=\n{??XWϯW?MK%ɑ~Xtm͈A7e	7ѭ2/݃q߄˚6b~G!:Q]f\ZJ1\\SBMI$Zz.j>୩߮*Xz\ZH6vXJݯB\\Ĕ5ڻo)Gc\"#\03~{JO?FĢzRiBUucFvs,xTm3\rݵߖpשe*K<;~h\0\Zy]J[u,(h:?	F]N2O\rz<|ѝ\rI=SR/ȝW[-kN,%Άѣw\\A{K?i۹֧4mCͺM]yq\0<ӝkn8wg7/\0 oq\0q#&vp%EeS\'.t=9-\0H\ZK	kA~mΕ9k-\'_rJ<9<m&NͮQk<5zw&8q#m>M5ɅzYX^)=}uc1wJ^%2gW%nBTV9(=Ɠ<l&	x=D,QR|>㕜Jr-7%hƬIw0[3$H<Q$֛k\rR\01+OZDs)+ye	SO\'8i7WO\0qS,Tf{xߡ	SkK̲5gOM]^#d\nhYDgh9eyYU,HYpWZ/i4d͹}Ⱙ*oFg\'-GOM~&զVdq,mݟp\n)t䦑gf4x~ohUݿ{3o1\'\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0?','2026-03-11 14:22:51.096','2026-03-11 14:22:51.096','cmmm0r17e002ibmo85i0h42fs',NULL,NULL,NULL,NULL,NULL,1);
/*!40000 ALTER TABLE `beverage_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `beverage_retailers`
--

DROP TABLE IF EXISTS `beverage_retailers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `beverage_retailers` (
  `id` varchar(191) NOT NULL,
  `retailerId` varchar(191) NOT NULL,
  `beverageType` varchar(191) NOT NULL,
  `beverageId` varchar(191) NOT NULL,
  `productUrl` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `beverage_retailers_retailerId_beverageType_beverageId_key` (`retailerId`,`beverageType`,`beverageId`),
  KEY `beverage_retailers_retailerId_idx` (`retailerId`),
  KEY `beverage_retailers_beverageType_beverageId_idx` (`beverageType`,`beverageId`),
  CONSTRAINT `beverage_retailers_retailerId_fkey` FOREIGN KEY (`retailerId`) REFERENCES `retailers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `beverage_retailers`
--

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

--
-- Table structure for table `beverage_scans`
--

DROP TABLE IF EXISTS `beverage_scans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `beverage_scans` (
  `id` varchar(191) NOT NULL,
  `userId` varchar(191) DEFAULT NULL,
  `filename` varchar(191) NOT NULL,
  `originalFilename` varchar(191) NOT NULL,
  `mimeType` varchar(191) NOT NULL,
  `size` int(11) NOT NULL,
  `imageData` longblob NOT NULL,
  `status` enum('PENDING','PROCESSING','COMPLETED','FAILED','TIMEOUT') NOT NULL DEFAULT 'PENDING',
  `aiProvider` varchar(191) DEFAULT NULL,
  `aiConfidence` double DEFAULT NULL,
  `aiResponse` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`aiResponse`)),
  `matchedBeverageId` varchar(191) DEFAULT NULL,
  `matchedBeverageType` varchar(191) DEFAULT NULL,
  `userSelectedBeverageId` varchar(191) DEFAULT NULL,
  `userSelectedBeverageType` varchar(191) DEFAULT NULL,
  `wasCorrectMatch` tinyint(1) DEFAULT NULL,
  `reviewStatus` enum('PENDING','REVIEWED','APPROVED','REJECTED','FLAGGED') NOT NULL DEFAULT 'PENDING',
  `reviewedBy` varchar(191) DEFAULT NULL,
  `reviewedAt` datetime(3) DEFAULT NULL,
  `adminNotes` text DEFAULT NULL,
  `deviceInfo` varchar(191) DEFAULT NULL,
  `location` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `beverage_scans_filename_key` (`filename`),
  KEY `beverage_scans_userId_idx` (`userId`),
  KEY `beverage_scans_status_idx` (`status`),
  KEY `beverage_scans_reviewStatus_idx` (`reviewStatus`),
  KEY `beverage_scans_createdAt_idx` (`createdAt`),
  KEY `beverage_scans_reviewedBy_fkey` (`reviewedBy`),
  CONSTRAINT `beverage_scans_reviewedBy_fkey` FOREIGN KEY (`reviewedBy`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `beverage_scans_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) 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 `beverage_scans`
--

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

--
-- Table structure for table `drinks`
--

DROP TABLE IF EXISTS `drinks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `drinks` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `imageUrl` varchar(191) DEFAULT NULL,
  `vendorId` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `ingredients` varchar(1000) DEFAULT NULL,
  `garnish` varchar(191) DEFAULT NULL,
  `glassType` varchar(191) DEFAULT NULL,
  `preparationMethod` varchar(1000) DEFAULT NULL,
  `category` varchar(191) DEFAULT NULL,
  `inFocus` tinyint(1) NOT NULL DEFAULT 0,
  `noAlcohol` tinyint(1) NOT NULL DEFAULT 0,
  `tasteProfile` varchar(500) DEFAULT NULL,
  `barcode` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `drinks_vendorId_idx` (`vendorId`),
  KEY `drinks_name_idx` (`name`),
  KEY `drinks_deleted_at_idx` (`deleted_at`),
  KEY `drinks_barcode_idx` (`barcode`),
  FULLTEXT KEY `drinks_name_description_idx` (`name`,`description`),
  CONSTRAINT `drinks_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `drinks`
--

LOCK TABLES `drinks` WRITE;
/*!40000 ALTER TABLE `drinks` DISABLE KEYS */;
INSERT INTO `drinks` VALUES
('cmmm0r17g007vcy1hpwjmc2m7','Virgin Mojito','Forfriskende alkoholfri mojito med friske mynteblade, lime og danskvand.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Friske mynteblade (10-12 stk), Limejuice (2 spsk, friskpresset), Sukkersirup (1 spsk), Danskvand / sodavand (240 ml), Isterninger','LimebÃƒÂ¥d og myntekvist','Highball-glas','Mos lime og sukkersirup i glasset i ca. 1 minut. Klap mynteblade mellem hÃƒÂ¦nderne for at frigive aromerne, lÃƒÂ¦g dem i glasset og pres forsigtigt med en muddler. Fyld glasset med is og danskvand, omrÃƒÂ¸r og server.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g007wro216yhjtb1u','Shirley Temple','Klassisk alkoholfri cocktail med ginger ale og grenadine, pyntet med maraschinokirsebÃƒÂ¦r.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Ginger ale (120 ml), Grenadine-sirup (30 ml), Isterninger, CocktailbÃƒÂ¦r / maraschinokirsebÃƒÂ¦r (2-3 stk)','MaraschinokirsebÃƒÂ¦r','Collins-glas','LÃƒÂ¦g 2 maraschinokirsebÃƒÂ¦r i bunden af et hÃƒÂ¸jt glas. Fyld halvdelen med isterninger. HÃƒÂ¦ld grenadine over isen, og hÃƒÂ¦ld derefter langsomt kold ginger ale over. Pynt med et ekstra kirsebÃƒÂ¦r og server straks.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g007x583lthd3scaz','Virgin PiÃƒÂ±a Colada','Tropisk blended mocktail med frossen ananas, kokosmÃƒÂ¦lk og limejuice.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Frossen ananas (1 kop), KokosmÃƒÂ¦lk eller kokoscreme (120 ml), Ananasjuice (120 ml), Limejuice (et stÃƒÂ¦nk), Isterninger','AnanasbÃƒÂ¥d og maraschinokirsebÃƒÂ¦r','Hurricane-glas','Blend frossen ananas, kokosmÃƒÂ¦lk, ananasjuice og limejuice i en blender til en glat, cremet konsistens. HÃƒÂ¦ld i et kÃƒÂ¸let hurricane-glas og pynt med en ananasbÃƒÂ¥d og et kirsebÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g007yka9y5007wci5','Arnold Palmer','Klassisk blanding af usÃƒÂ¸det iste og lemonade Ã¢â‚¬â€ en forfriskende og enkel drik.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'UsÃƒÂ¸det iste (sort te, afkÃƒÂ¸let) (150 ml), Lemonade (150 ml), Isterninger','Citronskive og eventuelt frisk mynte','Collins-glas','Fyld et glas med isterninger. HÃƒÂ¦ld lige dele iste og lemonade over isen (eller 3 dele te til 1 del lemonade for den originale opskrift). OmrÃƒÂ¸r forsigtigt og pynt med en citronskive.','Iste-lemonade',0,0,NULL,NULL),
('cmmm0r17g007zybabz5yen1xs','Roy Rogers','Den maskuline modpart til Shirley Temple Ã¢â‚¬â€ cola med grenadine og kirsebÃƒÂ¦r.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Cola (240 ml), Grenadine-sirup (45 ml), Isterninger, MaraschinokirsebÃƒÂ¦r','MaraschinokirsebÃƒÂ¦r','Highball-glas','HÃƒÂ¦ld grenadine i et hÃƒÂ¸jt glas fyldt med isterninger. Top med cola og rÃƒÂ¸r forsigtigt. Pynt med et maraschinokirsebÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0080plrk09ulwjef','Virgin Mary','Alkoholfri Bloody Mary med tomatjuice, peberrod, Worcestershire-sauce og tabasco.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Tomatjuice (180 ml), Citronsaft (15 ml, friskpresset), Syltevand / pickles-lage (et stÃƒÂ¦nk), Peberrodscreme (1/2 tsk), Worcestershire-sauce (et par drÃƒÂ¥ber), Tabasco / stÃƒÂ¦rk sauce (efter smag), Sellerisalt, Sort peber, Isterninger','Selleristang, syltede grÃƒÂ¸ntsager, citronbÃƒÂ¥d og oliven','Highball-glas','Gnid en citronbÃƒÂ¥d langs kanten af glasset og dyp i sellerisalt. Bland tomatjuice, citronsaft, syltevand, peberrod, Worcestershire-sauce, tabasco, sellerisalt og peber i et shakerglas. Rul drinken forsigtigt mellem to glas for at blande. HÃƒÂ¦ld i glasset med is og pynt.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0081ppnqn2g849n4','Virgin Sunrise','Alkoholfri Tequila Sunrise med appelsinjuice og grenadine Ã¢â‚¬â€ smuk solopgangseffekt.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Appelsinjuice (180 ml, gerne friskpresset), Grenadine-sirup (30 ml), Danskvand (et stÃƒÂ¦nk, valgfrit), Isterninger','Appelsinskive og maraschinokirsebÃƒÂ¦r','Highball-glas','Fyld et hÃƒÂ¸jt glas med isterninger. HÃƒÂ¦ld appelsinjuice over isen. HÃƒÂ¦ld langsomt grenadine ned langs siden af glasset Ã¢â‚¬â€ den synker til bunden og skaber en smuk solopgangseffekt. RÃƒÂ¸r IKKE i drinken. Pynt med en appelsinskive og et kirsebÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0082lzzucc8yg80a','Virgin Strawberry Daiquiri','Frossen jordbÃƒÂ¦rmocktail med friske og frosne jordbÃƒÂ¦r, lime og sukkersirup.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Friske jordbÃƒÂ¦r (1 kop), Frosne jordbÃƒÂ¦r (1 kop), Limejuice (30 ml, friskpresset), Sukkersirup (30 ml), Citronsodavand (et stÃƒÂ¦nk, valgfrit)','Frisk jordbÃƒÂ¦r pÃƒÂ¥ glassets kant','Hurricane-glas eller margarita-glas','Blend friske jordbÃƒÂ¦r, sukkersirup og limejuice i en blender til en glat masse. TilsÃƒÂ¦t derefter de frosne jordbÃƒÂ¦r og blend igen til en jÃƒÂ¦vn, frossen konsistens. HÃƒÂ¦ld i glasset og pynt med et jordbÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0083au6tz4sqbhn7','Cinderella','Frugtig mocktail med appelsinjuice, ananasjuice, citronsaft og grenadine, toppet med ginger ale.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Appelsinjuice (60 ml), Ananasjuice (75 ml), Citronsaft (30 ml), Grenadine-sirup (et stÃƒÂ¦nk), Ginger ale (til at toppe), Isterninger','Appelsinskive og maraschinokirsebÃƒÂ¦r','Collins-glas','Fyld en cocktailshaker halvt med is. TilsÃƒÂ¦t ananasjuice, appelsinjuice, citronsaft og grenadine. Ryst kraftigt i 10 sekunder. Si over frisk is i et hÃƒÂ¸jt glas og top med ginger ale. Pynt med en appelsinskive og et kirsebÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0084b471j4zp8gjp','Safe Sex on the Beach','Alkoholfri version af den klassiske cocktail med tranebÃƒÂ¦r-, appelsin- og ferskenjuice.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'TranebÃƒÂ¦rjuice (60 ml), Appelsinjuice (60 ml), Ferskennektar (60 ml), Grenadine (et stÃƒÂ¦nk), Isterninger','Appelsinskive og maraschinokirsebÃƒÂ¦r','Highball-glas','HÃƒÂ¦ld tranebÃƒÂ¦rjuice, appelsinjuice og ferskennektar over is i et highball-glas. TilsÃƒÂ¦t et stÃƒÂ¦nk grenadine. RÃƒÂ¸r forsigtigt og pynt med en appelsinskive og et kirsebÃƒÂ¦r.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g00851olshex8f8sm','Italian Soda','Enkel og farverig sodavandsmocktail med smagssirup og danskvand, eventuelt med flÃƒÂ¸de.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Danskvand / sodavand (240 ml), Smags-sirup efter valg, f.eks. jordbÃƒÂ¦r (30 ml), FlÃƒÂ¸de (et stÃƒÂ¦nk, valgfrit), Isterninger','Frisk frugt efter valg (f.eks. jordbÃƒÂ¦r)','Collins-glas','Fyld et glas med isterninger. TilsÃƒÂ¦t smagssirup og top med danskvand. TilsÃƒÂ¦t eventuelt et stÃƒÂ¦nk flÃƒÂ¸de for en cremet version. OmrÃƒÂ¸r forsigtigt og pynt med frisk frugt. Server straks med sugerÃƒÂ¸r.','Soda',0,0,NULL,NULL),
('cmmm0r17g0086c60wwc6qaqyn','Virgin Moscow Mule','Alkoholfri Moscow Mule med ginger beer, lime og mynte Ã¢â‚¬â€ serveret i kobberkrus.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Ginger beer (120 ml), Limejuice (30 ml, friskpresset), Danskvand (120 ml), Friske mynteblade (5-6 stk), Isterninger','Myntekvist og limebÃƒÂ¥d','Kobberkrus (traditionelt) eller highball-glas','Fyld et kobberkrus med isterninger. Mos forsigtigt mynteblade i bunden med en muddler. Pres frisk limejuice over isen. HÃƒÂ¦ld ginger beer og danskvand i krus og rÃƒÂ¸r forsigtigt. Pynt med en myntekvist og en limebÃƒÂ¥d.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0087kygbiwn23wf6','Lavender Lemonade','Elegant lemonade med hjemmelavet lavendelsirup og danskvand.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Lavendelsirup (30 ml), Frisk citronsaft (30 ml), Danskvand (til at toppe), Isterninger','Frisk lavendelkvist og citronskive','Collins-glas eller vinglas','Lav lavendelsirup: kog 120 ml vand og 120 ml sukker med en hÃƒÂ¥ndfuld spiselige lavendelknopper i 5 minutter, lad det trÃƒÂ¦kke i 30 minutter, og si. HÃƒÂ¦ld lavendelsirup og citronsaft i et glas med is. Top med danskvand, rÃƒÂ¸r forsigtigt og pynt med lavendel og citron.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0088dj56ql4nf90z','Virgin Cosmopolitan','Alkoholfri cosmo med tranebÃƒÂ¦r-, appelsin- og limejuice Ã¢â‚¬â€ serveret i martiniglas.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'TranebÃƒÂ¦rjuice (90 ml), Appelsinjuice (30 ml, friskpresset), Limejuice (15 ml, friskpresset), Sukkersirup (15 ml, valgfrit), Danskvand eller citronsodavand (et stÃƒÂ¦nk)','AppelsinskrÃƒÂ¦ltwist eller limeskive, eventuelt friske tranebÃƒÂ¦r','Martini-glas eller coupe-glas','TilsÃƒÂ¦t tranebÃƒÂ¦rjuice, appelsinjuice, limejuice og sukkersirup i en cocktailshaker med is. Ryst kraftigt i 10 sekunder. Si i et kÃƒÂ¸let martini-glas. Top eventuelt med et stÃƒÂ¦nk danskvand. Pynt med et appelsinskrÃƒÂ¦ltwist.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g0089j7iapy2ns9lk','Mango Lassi','Cremede indisk yoghurtdrik med moden mango, kardemomme og pistacinÃƒÂ¸dder.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Moden mango (1 stk, eller 200 ml mangopurÃƒÂ©), Naturel yoghurt (150 ml, helst tykmÃƒÂ¦lk/grÃƒÂ¦sk yoghurt), MÃƒÂ¦lk (60 ml), Sukker (1-2 spsk, efter smag), Kardemommepulver (en knivspids), Isterninger (valgfrit)','Hakkede pistacinÃƒÂ¸dder og safranstrÃƒÂ¥de','HÃƒÂ¸jt glas','Blend mango, yoghurt, mÃƒÂ¦lk, sukker og kardemomme i en blender til en glat, cremet konsistens. Smag til og tilpas sÃƒÂ¸dme eller tykkelse. HÃƒÂ¦ld i et glas og pynt med hakkede pistacinÃƒÂ¸dder og eventuelt safrantrÃƒÂ¥de. Serveres koldt.','Smoothie',0,0,NULL,NULL),
('cmmm0r17g008anom7jprvbej3','Virgin Paloma','Forfriskende mexicansk-inspireret mocktail med grapefrugt, lime og agavesirup.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Grapefrugtsaft (40 ml, friskpresset), Limejuice (20 ml, friskpresset), Agavesirup (20 ml), Danskvand (80 ml), Isterninger, Salt (til glassets kant)','LimebÃƒÂ¥d og grapefrugtskive','Highball-glas','Fugt kanten af glasset med en limebÃƒÂ¥d og dyp den i salt. Kom limejuice, grapefrugtsaft og agavesirup i en shaker med is. Ryst i 30 sekunder. HÃƒÂ¦ld over is i glasset og top med danskvand. Pynt med lime og grapefrugt.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008b98gk5zbq5taj','Virgin Mimosa','Alkoholfri mimosa med friskpresset appelsinjuice og alkoholfri mousserende vin.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Friskpresset appelsinjuice (100 ml), Alkoholfri mousserende vin eller druemost med brus (100 ml)','Appelsinskive og frisk myntekvist','ChampagneflÃƒÂ¸jte','HÃƒÂ¦ld den alkoholfri mousserende vin langsomt i champagneflÃƒÂ¸jten til den er halvt fyldt. HÃƒÂ¦ld derefter appelsinjuice op til glasset er fuldt. RÃƒÂ¸r ikke Ã¢â‚¬â€ boblerne blander drikken naturligt. Pynt med en appelsinskive.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008c7ho5clsnzl5x','Alkoholfri Espresso Martini','Elegant kaffemocktail med espresso, vaniljesirup og kokoscreme Ã¢â‚¬â€ serveret i martiniglas.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Friskbrygget espresso, afkÃƒÂ¸let (60 ml), Vaniljesirup (30 ml), Kokoscreme (30 ml), En knivspids salt','3 kaffebÃƒÂ¸nner og et drys kakaopulver','Martiniglas (afkÃƒÂ¸let)','Bryg en espresso og lad den kÃƒÂ¸le lidt af. Kom espresso, vaniljesirup og kokoscreme i en cocktailshaker med is. Ryst kraftigt i 15-20 sekunder, indtil drikken er kold og skummende. Si op i et afkÃƒÂ¸let martiniglas. Pynt med kaffebÃƒÂ¸nner og kakaopulver.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008dsg7qq4o7b1ed','Virgin Margarita','Alkoholfri margarita med lime, appelsin og agavesirup Ã¢â‚¬â€ med saltkant.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Friskpresset limejuice (60 ml), Friskpresset appelsinjuice (30 ml), Agavesirup (15 ml), Danskvand, Isterninger, Groft salt (til glassets kant)','LimebÃƒÂ¥d og appelsinskive','Margarita-glas','Fugt kanten af glasset med en limebÃƒÂ¥d og dyp den i groft salt. Kom limejuice, appelsinjuice og agavesirup i en shaker med is. Ryst godt og hÃƒÂ¦ld over is i glasset. Top med et stÃƒÂ¦nk danskvand. Pynt med lime og appelsin.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008ezeil8soswpok','Blue Lagoon Mocktail','Farverig blÃƒÂ¥ mocktail med alkoholfri blue curacao, lemonade og citrus-sodavand.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Blue curacao sirup, alkoholfri (30 ml), Lemonade (120 ml), Citrus-sodavand, f.eks. Sprite (120 ml), Isterninger','Citronskive og cocktailkirsebÃƒÂ¦r','Hurricane-glas eller highball-glas','Fyld glasset med isterninger. HÃƒÂ¦ld blue curacao sirup i glasset. TilsÃƒÂ¦t lemonade og top med citrus-sodavand. RÃƒÂ¸r forsigtigt. Pynt med en citronskive og et cocktailkirsebÃƒÂ¦r, evt. med en cocktailparaply.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008f5ro5cabhl5gv','Vandmelonmocktail','Frisk og sÃƒÂ¸d mocktail med blendet vandmelon, mynte, lime og honning.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Frisk vandmelon, udstenet og i tern (200 g), Friske mynteblade (5-6 stk), Friskpresset limejuice (30 ml), Honning (15 ml), Danskvand, Isterninger','Vandmelonkile, limeskive og myntekvist','Highball-glas','Blend vandmelon, mynteblade, limejuice og honning til en glat juice. Si blandingen gennem en finmasket si. Mos et par mynteblade i bunden af glasset. Fyld glasset med is og hÃƒÂ¦ld vandmelonjuicen i. Top med danskvand og rÃƒÂ¸r forsigtigt. Pynt med vandmelon, lime og mynte.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008g01m95k564727','Agurk Cooler','Let og forfriskende mocktail med agurkejuice, myntesirup og citron.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Agurkejuice (60 ml, blendet og siet agurk), Myntesirup (30 ml, sukkerlage med mynte), Friskpresset citronjuice (20 ml), Danskvand, Isterninger','Agurkeskive, myntekvist og citronbÃƒÂ¥d','Highball-glas','Lav myntesirup ved at oplÃƒÂ¸se sukker i vand, tilsÃƒÂ¦t mynteblade og lad det trÃƒÂ¦kke i 15 min. Si og afkÃƒÂ¸l. Fyld glasset med is. HÃƒÂ¦ld agurkejuice, citronjuice og myntesirup i og rÃƒÂ¸r rundt. Top med danskvand. Pynt med agurk, mynte og citron.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008hxbhekkfiv6ce','Virgin Mint Julep','Alkoholfri mint julep med myntesirup, lemonade og knust is Ã¢â‚¬â€ serveret i kobberkrus.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'Myntesirup (30 ml, sukkerlage med frisk mynte), Lemonade (100 ml), Danskvand (100 ml), Knust is, Friske mynteblade','Stor buket frisk mynte og flormelis som drys','Julep-krus (kobberkrus) eller highball-glas','Lav myntesirup: Opvarm vand og sukker til sukkeret er oplÃƒÂ¸st, tilsÃƒÂ¦t friske mynteblade og lad dem trÃƒÂ¦kke i 30 min. Si og afkÃƒÂ¸l. Fyld glasset med knust is. HÃƒÂ¦ld myntesirup og lemonade over isen. Top med danskvand og rÃƒÂ¸r kort. Pynt med en stor buket mynte.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008ikc3w9m9aeg99','Virgin Sangria','Alkoholfri sangria med rÃƒÂ¸d druesaft, frugtsafter og frisk frugt Ã¢â‚¬â€ serveres fra kande.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'RÃƒÂ¸d druesaft (500 ml), Appelsinjuice (250 ml), Ãƒâ€ blejuice (250 ml), Friskpresset citronjuice (30 ml), Danskvand (250 ml), Frisk frugt i skiver: appelsin, citron, ÃƒÂ¦ble, jordbÃƒÂ¦r, Kanelstang (1 stk), Isterninger','Appelsinkiver, jordbÃƒÂ¦r og mynteblade','Vinglas (serveres fra kande)','Kom druesaft, appelsinjuice, ÃƒÂ¦blejuice og citronjuice i en stor kande. TilsÃƒÂ¦t frugtstykker og kanelstangen. SÃƒÂ¦t kanden i kÃƒÂ¸leskabet i mindst 2 timer, sÃƒÂ¥ frugten kan trÃƒÂ¦kke. Lige inden servering tilsÃƒÂ¦ttes danskvand. ServÃƒÂ©r over is i vinglas med frugt som pynt.','Mocktail',0,0,NULL,NULL),
('cmmm0r17g008jibq6j9yq8zbj','Passionsfrugts-Mocktail','Eksotisk mocktail med passionsfrugtpurÃƒÂ©, lime og agavesirup, toppet med danskvand.',0,NULL,NULL,'2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,'PassionsfrugtpurÃƒÂ© eller frisk passionsfrugt (50 ml), Limejuice (30 ml), Agavesirup (20 ml), Danskvand (100 ml), Isterninger','Halv passionsfrugt (med frÃƒÂ¸ene op) og myntekvist','Coupe-glas eller highball-glas','Kom passionsfrugtpurÃƒÂ©, limejuice og agavesirup i en cocktailshaker med is. Ryst kraftigt i 15 sekunder. Si op i glasset over frisk is. Top med danskvand og rÃƒÂ¸r forsigtigt. Pynt med en halv passionsfrugt og en myntekvist.','Mocktail',0,0,NULL,NULL);
/*!40000 ALTER TABLE `drinks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feedback`
--

DROP TABLE IF EXISTS `feedback`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `feedback` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) DEFAULT NULL,
  `email` varchar(191) NOT NULL,
  `feedback` text NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `allowFollowUp` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feedback`
--

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

--
-- Table structure for table `moderation_rules`
--

DROP TABLE IF EXISTS `moderation_rules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `moderation_rules` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` text DEFAULT NULL,
  `type` enum('PROFANITY_FILTER','RATE_LIMIT','SPAM_DETECTION','SENTIMENT_ANALYSIS','CUSTOM') NOT NULL,
  `config` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`config`)),
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `priority` int(11) NOT NULL DEFAULT 0,
  `createdBy` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `moderation_rules_type_idx` (`type`),
  KEY `moderation_rules_isActive_idx` (`isActive`),
  KEY `moderation_rules_priority_idx` (`priority`),
  KEY `moderation_rules_createdBy_fkey` (`createdBy`),
  CONSTRAINT `moderation_rules_createdBy_fkey` FOREIGN KEY (`createdBy`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moderation_rules`
--

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

--
-- Table structure for table `not_found_logs`
--

DROP TABLE IF EXISTS `not_found_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `not_found_logs` (
  `id` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `referrer` varchar(191) DEFAULT NULL,
  `userId` varchar(191) DEFAULT NULL,
  `userAgent` text DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `not_found_logs_createdAt_idx` (`createdAt`),
  KEY `not_found_logs_path_idx` (`path`),
  KEY `not_found_logs_userId_fkey` (`userId`),
  CONSTRAINT `not_found_logs_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) 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 `not_found_logs`
--

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

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `notifications` (
  `id` varchar(191) NOT NULL,
  `userId` varchar(191) NOT NULL,
  `type` enum('RATING_APPROVED','RATING_REJECTED','RATING_FLAGGED','RATING_REPORTED','NEW_PRODUCT','ACCOUNT_BANNED','ACCOUNT_BAN_REVOKED','ADMIN_MODERATION_ALERT','SYSTEM_ANNOUNCEMENT') NOT NULL,
  `title` varchar(191) NOT NULL,
  `message` varchar(500) NOT NULL,
  `link` varchar(191) DEFAULT NULL,
  `isRead` tinyint(1) NOT NULL DEFAULT 0,
  `readAt` datetime(3) DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `notifications_userId_isRead_idx` (`userId`,`isRead`),
  KEY `notifications_userId_createdAt_idx` (`userId`,`createdAt`),
  CONSTRAINT `notifications_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notifications`
--

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

--
-- Table structure for table `rating_audit_logs`
--

DROP TABLE IF EXISTS `rating_audit_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rating_audit_logs` (
  `id` varchar(191) NOT NULL,
  `ratingId` varchar(191) NOT NULL,
  `action` varchar(191) NOT NULL,
  `performedBy` varchar(191) NOT NULL,
  `reason` varchar(191) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `rating_audit_logs_ratingId_idx` (`ratingId`),
  KEY `rating_audit_logs_performedBy_idx` (`performedBy`),
  KEY `rating_audit_logs_createdAt_idx` (`createdAt`),
  CONSTRAINT `rating_audit_logs_performedBy_fkey` FOREIGN KEY (`performedBy`) REFERENCES `users` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `rating_audit_logs_ratingId_fkey` FOREIGN KEY (`ratingId`) REFERENCES `ratings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rating_audit_logs`
--

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

--
-- Table structure for table `ratings`
--

DROP TABLE IF EXISTS `ratings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `ratings` (
  `id` varchar(191) NOT NULL,
  `stars` int(11) NOT NULL,
  `comment` text DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `userId` varchar(191) NOT NULL,
  `entityId` varchar(191) NOT NULL,
  `entityType` varchar(191) NOT NULL,
  `isVerified` tinyint(1) NOT NULL DEFAULT 0,
  `status` enum('PENDING','APPROVED','REJECTED','FLAGGED','REPORTED','DELETED') NOT NULL DEFAULT 'PENDING',
  `updatedAt` datetime(3) NOT NULL,
  `flaggedAt` datetime(3) DEFAULT NULL,
  `flaggedBy` varchar(191) DEFAULT NULL,
  `deletedAt` datetime(3) DEFAULT NULL,
  `deletedBy` varchar(191) DEFAULT NULL,
  `deleteReason` varchar(191) DEFAULT NULL,
  `deleteNotes` varchar(1000) DEFAULT NULL,
  `restoredAt` datetime(3) DEFAULT NULL,
  `restoredBy` varchar(191) DEFAULT NULL,
  `restoreReason` varchar(191) DEFAULT NULL,
  `assignedTo` varchar(191) DEFAULT NULL,
  `flagPriority` enum('LOW','MEDIUM','HIGH','URGENT') DEFAULT NULL,
  `flagReason` enum('SUSPICIOUS_ACTIVITY','POLICY_VIOLATION','SENIOR_REVIEW','OTHER') DEFAULT NULL,
  `lockedAt` datetime(3) DEFAULT NULL,
  `lockedBy` varchar(191) DEFAULT NULL,
  `moderatedAt` datetime(3) DEFAULT NULL,
  `moderatedBy` varchar(191) DEFAULT NULL,
  `moderationNotes` text DEFAULT NULL,
  `rejectionReason` enum('SPAM','INAPPROPRIATE_LANGUAGE','OFF_TOPIC','DUPLICATE','OTHER') DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ratings_entityType_entityId_userId_key` (`entityType`,`entityId`,`userId`),
  KEY `idx_status` (`status`),
  KEY `ratings_createdAt_idx` (`createdAt`),
  KEY `idx_userId` (`userId`),
  KEY `ratings_status_idx` (`status`),
  KEY `ratings_deletedAt_idx` (`deletedAt`),
  KEY `ratings_deletedBy_idx` (`deletedBy`),
  KEY `ratings_userId_idx` (`userId`),
  KEY `ratings_flagPriority_idx` (`flagPriority`),
  KEY `ratings_lockedBy_idx` (`lockedBy`),
  KEY `ratings_moderatedBy_fkey` (`moderatedBy`),
  KEY `ratings_flaggedBy_fkey` (`flaggedBy`),
  KEY `ratings_assignedTo_fkey` (`assignedTo`),
  KEY `ratings_restoredBy_fkey` (`restoredBy`),
  CONSTRAINT `ratings_assignedTo_fkey` FOREIGN KEY (`assignedTo`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `ratings_deletedBy_fkey` FOREIGN KEY (`deletedBy`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ratings_flaggedBy_fkey` FOREIGN KEY (`flaggedBy`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `ratings_moderatedBy_fkey` FOREIGN KEY (`moderatedBy`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `ratings_restoredBy_fkey` FOREIGN KEY (`restoredBy`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ratings_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ratings`
--

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

--
-- Table structure for table `retailers`
--

DROP TABLE IF EXISTS `retailers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `retailers` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `logoUrl` varchar(191) DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `retailers_name_key` (`name`),
  KEY `retailers_name_idx` (`name`),
  KEY `retailers_city_idx` (`city`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `retailers`
--

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

--
-- Table structure for table `rule_actions`
--

DROP TABLE IF EXISTS `rule_actions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rule_actions` (
  `id` varchar(191) NOT NULL,
  `ruleId` varchar(191) NOT NULL,
  `ratingId` varchar(191) NOT NULL,
  `action` varchar(191) NOT NULL,
  `confidence` double DEFAULT NULL,
  `metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`metadata`)),
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `rule_actions_ruleId_idx` (`ruleId`),
  KEY `rule_actions_ratingId_idx` (`ratingId`),
  KEY `rule_actions_createdAt_idx` (`createdAt`),
  CONSTRAINT `rule_actions_ratingId_fkey` FOREIGN KEY (`ratingId`) REFERENCES `ratings` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `rule_actions_ruleId_fkey` FOREIGN KEY (`ruleId`) REFERENCES `moderation_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_actions`
--

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

--
-- Table structure for table `rule_metrics`
--

DROP TABLE IF EXISTS `rule_metrics`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rule_metrics` (
  `id` varchar(191) NOT NULL,
  `ruleId` varchar(191) NOT NULL,
  `date` datetime(3) NOT NULL,
  `activations` int(11) NOT NULL DEFAULT 0,
  `truePositives` int(11) NOT NULL DEFAULT 0,
  `falsePositives` int(11) NOT NULL DEFAULT 0,
  `accuracy` double DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `rule_metrics_ruleId_date_key` (`ruleId`,`date`),
  KEY `rule_metrics_ruleId_idx` (`ruleId`),
  KEY `rule_metrics_date_idx` (`date`),
  CONSTRAINT `rule_metrics_ruleId_fkey` FOREIGN KEY (`ruleId`) REFERENCES `moderation_rules` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rule_metrics`
--

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

--
-- Table structure for table `site_access_logs`
--

DROP TABLE IF EXISTS `site_access_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_access_logs` (
  `id` varchar(191) NOT NULL,
  `sitePasswordId` varchar(191) NOT NULL,
  `ipAddress` varchar(191) DEFAULT NULL,
  `userAgent` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `site_access_logs_sitePasswordId_idx` (`sitePasswordId`),
  KEY `site_access_logs_createdAt_idx` (`createdAt`),
  CONSTRAINT `site_access_logs_sitePasswordId_fkey` FOREIGN KEY (`sitePasswordId`) REFERENCES `site_passwords` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_access_logs`
--

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

--
-- Table structure for table `site_passwords`
--

DROP TABLE IF EXISTS `site_passwords`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_passwords` (
  `id` varchar(191) NOT NULL,
  `label` varchar(191) NOT NULL,
  `password` varchar(191) NOT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `loginCount` int(11) NOT NULL DEFAULT 0,
  `lastUsedAt` datetime(3) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `site_passwords`
--

LOCK TABLES `site_passwords` WRITE;
/*!40000 ALTER TABLE `site_passwords` DISABLE KEYS */;
INSERT INTO `site_passwords` VALUES
('cmmlbcclw00004s9k7a6o897l','Kristian','$2b$12$XYtUI4w9CAnqMHQn8vYZWOtaLUvzmaJ.J8540swfjLNUDnNsxhWBy',1,0,NULL,'2026-03-11 00:41:03.186','2026-03-11 00:41:03.186'),
('cmmlbcm1u00014s9k2e8e8unr','Susan','$2b$12$zDiw5uBcWS9irnCqQjt5qeJAUZAlcD0LC7rgU1vhsmv1LYBOSPVnC',1,0,NULL,'2026-03-11 00:41:15.425','2026-03-11 00:41:15.425');
/*!40000 ALTER TABLE `site_passwords` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_bans`
--

DROP TABLE IF EXISTS `user_bans`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_bans` (
  `id` varchar(191) NOT NULL,
  `userId` varchar(191) NOT NULL,
  `banType` enum('TEMPORARY','PERMANENT') NOT NULL,
  `banScope` enum('RATING_ONLY','FULL_PLATFORM') NOT NULL,
  `reason` varchar(191) NOT NULL,
  `notes` varchar(1000) DEFAULT NULL,
  `bannedBy` varchar(191) NOT NULL,
  `bannedAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `expiresAt` datetime(3) DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_bans_userId_idx` (`userId`),
  KEY `user_bans_isActive_idx` (`isActive`),
  KEY `user_bans_expiresAt_idx` (`expiresAt`),
  KEY `user_bans_bannedBy_fkey` (`bannedBy`),
  CONSTRAINT `user_bans_bannedBy_fkey` FOREIGN KEY (`bannedBy`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `user_bans_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_bans`
--

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

--
-- Table structure for table `user_whitelists`
--

DROP TABLE IF EXISTS `user_whitelists`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_whitelists` (
  `id` varchar(191) NOT NULL,
  `userId` varchar(191) NOT NULL,
  `reason` text NOT NULL,
  `expiresAt` datetime(3) DEFAULT NULL,
  `createdBy` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_whitelists_userId_idx` (`userId`),
  KEY `user_whitelists_expiresAt_idx` (`expiresAt`),
  KEY `user_whitelists_createdBy_idx` (`createdBy`),
  CONSTRAINT `user_whitelists_createdBy_fkey` FOREIGN KEY (`createdBy`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_whitelists_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_whitelists`
--

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `email` varchar(191) NOT NULL,
  `passwordHash` varchar(191) NOT NULL,
  `role` enum('ADMIN','USER','VENDOR') NOT NULL DEFAULT 'USER',
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `deletedAt` datetime(3) DEFAULT NULL,
  `emailVerificationExpires` datetime(3) DEFAULT NULL,
  `emailVerificationToken` varchar(191) DEFAULT NULL,
  `emailVerified` datetime(3) DEFAULT NULL,
  `isProfessionalSommelier` tinyint(1) NOT NULL DEFAULT 0,
  `sommelierPromotedAt` datetime(3) DEFAULT NULL,
  `sommelierPromotedById` varchar(191) DEFAULT NULL,
  `updatedAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `vendorId` varchar(191) DEFAULT NULL,
  `lastPasswordChange` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `newsletterSubscription` tinyint(1) NOT NULL DEFAULT 1,
  `profileUpdatedAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `failedLoginAttempts` int(11) NOT NULL DEFAULT 0,
  `lockedUntil` datetime(3) DEFAULT NULL,
  `lastFailedLoginAt` datetime(3) DEFAULT NULL,
  `accountRevivalToken` varchar(191) DEFAULT NULL,
  `accountRevivalTokenExpires` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_key` (`email`),
  UNIQUE KEY `users_emailVerificationToken_key` (`emailVerificationToken`),
  UNIQUE KEY `users_accountRevivalToken_key` (`accountRevivalToken`),
  KEY `users_vendorId_fkey` (`vendorId`),
  KEY `users_sommelierPromotedById_fkey` (`sommelierPromotedById`),
  CONSTRAINT `users_sommelierPromotedById_fkey` FOREIGN KEY (`sommelierPromotedById`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `users_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) 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 `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES
('cmmlaegb60000to9kja25ug4c','Kristian Skriver Gandrup','kristian@skriver.de','$2b$12$EMmbK8i/JjxDIO0RAUGa1O5ddlZT9rdYr0xB7yt/BFJa14.UDoEXC','ADMIN','2026-03-11 00:14:41.682',NULL,'2026-03-12 00:14:41.673','294f8e42-cb39-4adb-9626-4a1257e4819d','2026-03-11 00:15:05.355',0,NULL,NULL,'2026-03-11 00:31:13.493',NULL,'2026-03-11 00:14:41.682',1,'2026-03-11 00:14:41.682',0,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendors` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `logoUrl` varchar(191) DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `contactInfo` varchar(191) DEFAULT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendors_name_key` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendors`
--

LOCK TABLES `vendors` WRITE;
/*!40000 ALTER TABLE `vendors` DISABLE KEYS */;
INSERT INTO `vendors` VALUES
('cmmm0r178000068gpefafw0jm','Carlsberg',NULL,'https://www.carlsberggroup.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780001scfprdsgs80v','Tuborg',NULL,'https://www.tuborg.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780002yyo5zm4iynlk','Royal Unibrew',NULL,'https://www.royalunibrew.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17800033b3z6oclvgdr','Faxe',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780004amayoycungky','Mikkeller',NULL,'https://www.mikkeller.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17800055qt2v3y8ec5d','To ÃƒËœl',NULL,'https://toolbeer.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780006xe1sgax1reh4','Svaneke Bryghus',NULL,'https://www.svanekebryghus.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780007uod0gfx3wtxg','Anarkist',NULL,'https://www.bevco.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r1780008llvw5smcmsy6','Alefarm Brewing',NULL,'https://shop.alefarm.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17800091tbhxylzc2o2','NÃƒÂ¸rrebro Bryghus',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000a6387p2f9qdj1','Bryggeriet Skands',NULL,'http://bryggeriet-skands.dk/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000bkio244fc95r3','Bryggeriet Vestfyen',NULL,'https://www.vestfyen.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000cyhpwbm75xbbq','ÃƒËœrbÃƒÂ¦k Bryggeri',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000dpujyowq07b9v','Ugly Duck Brewing',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000e9slzuub3ljv8','Refsvindinge Bryggeri',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000ffftg75wa2qfc','Thy Bryghus',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000gv5wkbgqudnoe','Svendborgsund Bryghus',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000hdt0ghv0fuowt','Fantom Bryg',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000it0jer3p42j30','Harboe',NULL,'https://harboe.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000jq86bhvj22xjc','BrewDog',NULL,'https://www.brewdog.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000kpnz3tnpk2oxr','Brooklyn Brewery',NULL,'https://brooklynbrewery.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000lznediubfg2y7','Erdinger',NULL,'https://www.erdinger.de/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000m0nmjohm640vw','Heineken',NULL,'https://www.heineken.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000nvwq5jd9007x9','Leffe',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000o1q1fx974pydw','Kronenbourg',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000plshafmvksm03','Corona',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000q1cx737se0lj0','Clausthaler',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000rr2djm0wcffps','Schneider Weisse',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000s4bj4zu0l4h7b','Weihenstephaner',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000twnft0c44o6n7','Riegele',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000uqa50vi4a3sij','Jacob',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000vb1cdk4y9mvv3','Insel-Brauerei',NULL,'https://insel-brauerei.de/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000w115y1davgo0h','Brutal Brewing',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000x4l2q1rhsxj7i','Beck\'s',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r178000ychjrmzjb4il3','Force Majeure',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e000z0r6r8dd3s854','Arensbak',NULL,'https://www.arensbak.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e00109jpc0myllgye','MURI',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0011qsc3glhrgike','Copenhagen Winery',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0012pvo5i7iskvdw','ISH Spirits',NULL,'https://ishspirits.com/',NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0013drpcr2gucfyl','Copenhagen Sparkling Tea Company',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0014x87v46yli77b','Oddbird',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e00158d60bm6masiz','Domaines Pierre Chavin',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001680snkciaj2tf','Chavin',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e00176i15r4aupf2j','Divin Vigneron',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0018qt919m9pychr','French Bloom',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0019b72gt7vi8sls','Petit BÃƒÂ©ret',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001aesap6nv1ydx6','J. de Villebois',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001bqb9fqs6q290g','Raisin',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001capi6idmg4wo3','La Baume',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001djn980ohdqzzg','Carl Jung',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001e799bnr2j3uvy','Weingut Leitz',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001fvf7gwsfnhcfo','Kolonne Null',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001gwhb7bdnfivso','SomÃƒÂ©e',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001hxlkohipbeq84','Michel Schneider',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001iiv03wcxpnotr','Schloss Raggendorf',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001jvnotpw0oe1e0','Weingut Rieger',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001kh4sowihbzmpn','Weinkellerei Hechtsheim',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001lcuyep7e2jqy4','Deinhard',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001mkuz5z1r4fljt','Leonard Kreusch',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001nebvzd5rgmxp2','Canter',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001o40ggmuyalpuy','Villa Wolf',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001p2rh39splbgyj','Schwedhelm',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001q1fse6h4v3fl7','Teedawn',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001rjz6a5nhh00jd','Peter Mertes Weinkeller',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001syw179l4faibu','Torres',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001tdsyzzzkb2rbi','Lussory',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001u6ojv9wowuz5s','Aldea',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001vk597icd7xlpe','Murviedro',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001wfdwf5loxxet2','Bosio',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001xmwik1fo23yox','Thomson & Scott',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001y50b99od5g6cq','Eisberg',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e001z5h15de2ma08f','Alternativa',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0020juo837cdiq0q','Vita Libera',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0021f5vhcsp88g0n','Gross & Gross',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e00228n2kiso5r8lg','Golden State Vintners',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0023c17qcg11ai9j','Vinada',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0024xhayd5uvb25f','Wednesday\'s Domaine',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0025hmx2rrgf019q','DC',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e002619hplwl3neaw','Day Off',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e0027fhqeabrh27cx','Richard Juhlin',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1),
('cmmm0r17e00281dalalvdq4h5','LÃƒÂ¸gismose',NULL,NULL,NULL,'2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,1);
/*!40000 ALTER TABLE `vendors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wines`
--

DROP TABLE IF EXISTS `wines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `wines` (
  `id` varchar(191) NOT NULL,
  `name` varchar(191) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT 0,
  `imageUrl` varchar(191) DEFAULT NULL,
  `vendorId` varchar(191) NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  `updatedAt` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `alcoholPercentage` double DEFAULT NULL,
  `vintage` int(11) DEFAULT NULL,
  `grapeVariety` varchar(191) DEFAULT NULL,
  `region` varchar(191) DEFAULT NULL,
  `inFocus` tinyint(1) NOT NULL DEFAULT 0,
  `noAlcohol` tinyint(1) NOT NULL DEFAULT 0,
  `barcode` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `wines_vendorId_idx` (`vendorId`),
  KEY `wines_name_idx` (`name`),
  KEY `wines_deleted_at_idx` (`deleted_at`),
  KEY `wines_barcode_idx` (`barcode`),
  FULLTEXT KEY `wines_name_description_idx` (`name`,`description`),
  CONSTRAINT `wines_vendorId_fkey` FOREIGN KEY (`vendorId`) REFERENCES `vendors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wines`
--

LOCK TABLES `wines` WRITE;
/*!40000 ALTER TABLE `wines` DISABLE KEYS */;
INSERT INTO `wines` VALUES
('cmmm0r17f0041rifep2ylajqw','Arensbak Red','Alkoholfri rÃƒÂ¸dvin fra Arensbak. Naturlige tanniner og tÃƒÂ¸rhed fra udvalgte teer og egetrÃƒÂ¦slagring.',0,NULL,'cmmm0r17e000z0r6r8dd3s854','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Danmark',0,0,NULL),
('cmmm0r17f0042sokt1vhbg16i','Arensbak White','Alkoholfri hvidvin fra Arensbak. Naturlige tanniner og tÃƒÂ¸rhed fra udvalgte teer og egetrÃƒÂ¦slagring.',0,NULL,'cmmm0r17e000z0r6r8dd3s854','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Danmark',0,0,NULL),
('cmmm0r17f0043bch6kdb4059l','Muri x The Four Horsemen Still Red','Alkoholfri rÃƒÂ¸dvin fra MURI. Fermenteret, alkoholfri drik designet til vin-ÃƒÂ¸jeblikke.',0,NULL,'cmmm0r17e00109jpc0myllgye','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Danmark',0,0,NULL),
('cmmm0r17f004498cgn8ef7x5v','Muri Koji Rice Series 1 Still White','Alkoholfri hvidvin fra MURI. Vinder af bedste alkoholfri drik ved Feinschmecker Wine Awards.',0,NULL,'cmmm0r17e00109jpc0myllgye','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Danmark',0,0,NULL),
('cmmm0r17f0045k1ybkjwnch3o','Copenhagen Winery Chamomile (Kamilleblomst)','Alkoholfri botanisk vin fra Copenhagen Winery. Lavet af friske blomster og botaniske ingredienser.',0,NULL,'cmmm0r17e0011qsc3glhrgike','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Danmark',0,0,NULL),
('cmmm0r17f00461j1off74dv6w','ISH Fransk Chardonnay','Alkoholfri Chardonnay fra ISH Spirits. Lavet med naturlige botaniske stoffer og avancerede ekstraktionsteknikker.',0,NULL,'cmmm0r17e0012pvo5i7iskvdw','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chardonnay','Frankrig',0,0,NULL),
('cmmm0r17f0047yqfgwyam7ovg','ISH Fransk Merlot','Alkoholfri Merlot fra ISH Spirits. Guldmedaljevindende produkt.',0,NULL,'cmmm0r17e0012pvo5i7iskvdw','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Merlot','Frankrig',0,0,NULL),
('cmmm0r17f0048hhuxd6dv2rue','Oddbird GSM Liberated from Alcohol 2023','Alkoholfri rÃƒÂ¸dvin fra Oddbird. Vine lagret op til 12 mÃƒÂ¥neder fÃƒÂ¸r vakuumdestillation.',0,NULL,'cmmm0r17e0014x87v46yli77b','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Grenache-Syrah-MourvÃƒÂ¨dre','Languedoc-Roussillon',0,0,NULL),
('cmmm0r17f004919mkcvk2q89t','Oddbird Low Intervention No. 2','Alkoholfri hvidvin fra Oddbird. Liberated from Alcohol.',0,NULL,'cmmm0r17e0014x87v46yli77b','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Alsace',0,0,NULL),
('cmmm0r17f004axl3brz88bqhj','Pierre Zero Signature Grenache','Alkoholfri rÃƒÂ¸dvin fra Domaines Pierre Chavin. Afalkoholiseret med spinning cone column-teknologi.',0,NULL,'cmmm0r17e00158d60bm6masiz','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Grenache','Frankrig',0,0,NULL),
('cmmm0r17f004b0gufec9e2cuz','Pierre Zero Signature Chardonnay Organic','Alkoholfri ÃƒÂ¸kologisk Chardonnay fra Domaines Pierre Chavin.',0,NULL,'cmmm0r17e00158d60bm6masiz','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chardonnay','Frankrig',0,0,NULL),
('cmmm0r17f004cb25u84xiq2hm','Pierre Zero Chardonnay Bag-in-Box 3L','Alkoholfri Chardonnay fra Domaines Pierre Chavin. 3 liter bag-in-box.',0,NULL,'cmmm0r17e00158d60bm6masiz','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chardonnay','Frankrig',0,0,NULL),
('cmmm0r17f004dwkqy2yokdksk','Chavin Chardonnay ZÃƒÂ©ro','Alkoholfri Chardonnay fra Chavin.',0,NULL,'cmmm0r17e001680snkciaj2tf','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Chardonnay','Frankrig',0,0,NULL),
('cmmm0r17f004ea7peoat8imxa','Divin Vigneron Pinot Noir','Alkoholfri Pinot Noir fra Divin Vigneron. Loire-dalen.',0,NULL,'cmmm0r17e00176i15r4aupf2j','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Pinot Noir','Loire',0,0,NULL),
('cmmm0r17f004fq2u4oh4s2mqj','Divin Vigneron Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Divin Vigneron. Loire-dalen.',0,NULL,'cmmm0r17e00176i15r4aupf2j','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Sauvignon Blanc','Loire',0,0,NULL),
('cmmm0r17f004gwcczgkejsjev','Divin 0.0% Chenin Blanc','Alkoholfri Chenin Blanc fra Divin. Loire-dalen.',0,NULL,'cmmm0r17e00176i15r4aupf2j','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chenin Blanc','Loire',0,0,NULL),
('cmmm0r17f004h9tjczoaqgnkj','Divin 0.0% Pinot Noir','Alkoholfri Pinot Noir fra Divin. Loire-dalen.',0,NULL,'cmmm0r17e00176i15r4aupf2j','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pinot Noir','Loire',0,0,NULL),
('cmmm0r17f004i907nhzg83cbm','Divin 0.0% Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Divin. Loire-dalen.',0,NULL,'cmmm0r17e00176i15r4aupf2j','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Sauvignon Blanc','Loire',0,0,NULL),
('cmmm0r17f004jpopmqtgkgjl5','Petit BÃƒÂ©ret Le Nouveau Blanc','Alkoholfri hvidvin fra Petit BÃƒÂ©ret.',0,NULL,'cmmm0r17e0019b72gt7vi8sls','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004kcjvo2wcgrsjb','Petit BÃƒÂ©ret Le Nouveau Rouge','Alkoholfri rÃƒÂ¸dvin fra Petit BÃƒÂ©ret.',0,NULL,'cmmm0r17e0019b72gt7vi8sls','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004l5dp777vghe9p','Petit BÃƒÂ©ret Le Rouge Ardent','Alkoholfri rÃƒÂ¸dvin fra Petit BÃƒÂ©ret.',0,NULL,'cmmm0r17e0019b72gt7vi8sls','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004mwv7rcuwb5y2w','Le Petit BÃƒÂ©ret Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Petit BÃƒÂ©ret.',0,NULL,'cmmm0r17e0019b72gt7vi8sls','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Cabernet Sauvignon','Frankrig',0,0,NULL),
('cmmm0r17f004n0ct3rxrtah0h','Le Petit BÃƒÂ©ret Pinot Noir','Alkoholfri Pinot Noir fra Petit BÃƒÂ©ret.',0,NULL,'cmmm0r17e0019b72gt7vi8sls','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pinot Noir','Frankrig',0,0,NULL),
('cmmm0r17f004ozlub64eosm9a','J. de Villebois Alcohol Free Sauvignon Blanc 2021','Alkoholfri Sauvignon Blanc fra J. de Villebois.',0,NULL,'cmmm0r17e001aesap6nv1ydx6','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Sauvignon Blanc','Frankrig',0,0,NULL),
('cmmm0r17f004pt6c6upqk209c','Raisin Alcohol Free Pinot Noir','Alkoholfri Pinot Noir fra Raisin.',0,NULL,'cmmm0r17e001bqb9fqs6q290g','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Pinot Noir','Frankrig',0,0,NULL),
('cmmm0r17f004qoihnh1ww64zj','Raisin Alcohol Free Chenin Blanc','Alkoholfri Chenin Blanc fra Raisin.',0,NULL,'cmmm0r17e001bqb9fqs6q290g','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chenin Blanc','Frankrig',0,0,NULL),
('cmmm0r17f004rb5wi5kp06ee2','Raisin Alcohol Free RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Raisin.',0,NULL,'cmmm0r17e001bqb9fqs6q290g','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004sfdi1eu9e444e','La Baume Saint Paul Hvid Alkoholfri','Alkoholfri hvidvin fra La Baume.',0,NULL,'cmmm0r17e001capi6idmg4wo3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004tbn5xwbhwxi9n','La Baume Saint Paul RosÃƒÂ© Alkoholfri','Alkoholfri rosÃƒÂ©vin fra La Baume.',0,NULL,'cmmm0r17e001capi6idmg4wo3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004ughnyx0r5p6ko','La Baume Saint Paul RÃƒÂ¸d Alkoholfri','Alkoholfri rÃƒÂ¸dvin fra La Baume.',0,NULL,'cmmm0r17e001capi6idmg4wo3','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Frankrig',0,0,NULL),
('cmmm0r17f004vmbj48g0if028','Carl Jung Merlot','Alkoholfri Merlot fra Carl Jung. En af pionererne inden for afalkoholiseret vin.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Merlot','Tyskland',0,0,NULL),
('cmmm0r17f004w7dzcj9g4obgf','Carl Jung Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Cabernet Sauvignon','Tyskland',0,0,NULL),
('cmmm0r17f004xvjywlmp6jp2q','Carl Jung CuvÃƒÂ©e Rot','Alkoholfri rÃƒÂ¸d cuvÃƒÂ©e fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f004y9o9hbi7i1jdx','Carl Jung Chardonnay','Alkoholfri Chardonnay fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Chardonnay','Tyskland',0,0,NULL),
('cmmm0r17f004zgigsz774gxjx','Carl Jung Riesling','Alkoholfri Riesling fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f0050z69ku2pa0lat','Carl Jung CuvÃƒÂ©e Trocken','Alkoholfri hvid cuvÃƒÂ©e fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f0051lx8am8hehvj8','Carl Jung RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Carl Jung.',0,NULL,'cmmm0r17e001djn980ohdqzzg','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f0052z5wa4dlyznug','Leitz Eins Zwei Zero Riesling','Alkoholfri Riesling fra Weingut Leitz. Vakuumdestillation ved ~30Ã‚Â°C bevarer smagen.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Rheingau',0,0,NULL),
('cmmm0r17f0053hy2uif3p3zu5','Leitz Eins Zwei Zero RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Weingut Leitz.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Rheingau',0,0,NULL),
('cmmm0r17f0054vuc1c1qjwx4j','Leitz Eins Zwei Zero Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Weingut Leitz.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Cabernet Sauvignon','Rheingau',0,0,NULL),
('cmmm0r17f0055ehpurx2ujto2','Leitz Cabernet Red','Alkoholfri rÃƒÂ¸dvin fra Weingut Leitz.',0,NULL,'cmmm0r17e001e799bnr2j3uvy','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Cabernet Sauvignon','Rheingau',0,0,NULL),
('cmmm0r17f0056zrvy4lqu16kk','Kolonne Null Riesling','Alkoholfri Riesling fra Kolonne Null.',0,NULL,'cmmm0r17e001fvf7gwsfnhcfo','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f0057j9i6cvv1w0za','Kolonne Null CuvÃƒÂ©e Rouge NÃ‚Â°02','Alkoholfri rÃƒÂ¸d cuvÃƒÂ©e fra Kolonne Null.',0,NULL,'cmmm0r17e001fvf7gwsfnhcfo','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f0058q3ctfbfbhmgg','Kolonne Null Riesling GrÃƒÂ¼nlack XO','Alkoholfri premium Riesling fra Kolonne Null.',0,NULL,'cmmm0r17e001fvf7gwsfnhcfo','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f0059s5woqcjryk43','SomÃƒÂ©e Rivaner','Alkoholfri Rivaner fra SomÃƒÂ©e.',0,NULL,'cmmm0r17e001gwhb7bdnfivso','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Rivaner','Tyskland',0,0,NULL),
('cmmm0r17f005art9viyh44v20','SomÃƒÂ©e Riesling','Alkoholfri Riesling fra SomÃƒÂ©e.',0,NULL,'cmmm0r17e001gwhb7bdnfivso','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f005bg6zosdlhlqos','SomÃƒÂ©e Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra SomÃƒÂ©e.',0,NULL,'cmmm0r17e001gwhb7bdnfivso','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Sauvignon Blanc','Tyskland',0,0,NULL),
('cmmm0r17f005c3bpzctihafxd','SomÃƒÂ©e Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra SomÃƒÂ©e.',0,NULL,'cmmm0r17e001gwhb7bdnfivso','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Cabernet Sauvignon','Tyskland',0,0,NULL),
('cmmm0r17f005dgbnkvyvndjid','Michel Schneider Chardonnay','Alkoholfri Chardonnay fra Michel Schneider.',0,NULL,'cmmm0r17e001hxlkohipbeq84','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Chardonnay','Tyskland',0,0,NULL),
('cmmm0r17f005er1rcqhputyyy','Michel Schneider Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Michel Schneider.',0,NULL,'cmmm0r17e001hxlkohipbeq84','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Cabernet Sauvignon','Tyskland',0,0,NULL),
('cmmm0r17f005fw6p4a12jo0i2','Schloss Raggendorf Shiraz RosÃƒÂ©','Alkoholfri Shiraz rosÃƒÂ©vin fra Schloss Raggendorf.',0,NULL,'cmmm0r17e001iiv03wcxpnotr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Shiraz','Tyskland',0,0,NULL),
('cmmm0r17f005gsepa5s785dbd','Schloss Raggendorf Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Schloss Raggendorf.',0,NULL,'cmmm0r17e001iiv03wcxpnotr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Cabernet Sauvignon','Tyskland',0,0,NULL),
('cmmm0r17f005h0jtdmq80g8od','Schloss Raggendorf Chardonnay','Alkoholfri Chardonnay fra Schloss Raggendorf.',0,NULL,'cmmm0r17e001iiv03wcxpnotr','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,'Chardonnay','Tyskland',0,0,NULL),
('cmmm0r17f005i67bysd3t2hhi','Weingut Rieger Lust auf Traube ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk druevin fra Weingut Rieger, Baden.',0,NULL,'cmmm0r17e001jvnotpw0oe1e0','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Baden',0,0,NULL),
('cmmm0r17f005jyi4cefwia9d3','Weingut Rieger Traubensaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk druesaft fra Weingut Rieger, Baden.',0,NULL,'cmmm0r17e001jvnotpw0oe1e0','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Baden',0,0,NULL),
('cmmm0r17f005keht3gegfycrr','The Bench Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Weinkellerei Hechtsheim.',0,NULL,'cmmm0r17e001kh4sowihbzmpn','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Sauvignon Blanc','Tyskland',0,0,NULL),
('cmmm0r17f005l5xn1qj6ci1mq','Deinhard Green Label Riesling','Alkoholfri Riesling fra Deinhard.',0,NULL,'cmmm0r17e001lcuyep7e2jqy4','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f005m96iu55w0vnt0','Leonard Kreusch Alkoholfri Riesling','Alkoholfri Riesling fra Leonard Kreusch.',0,NULL,'cmmm0r17e001mkuz5z1r4fljt','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f005n4kmvgsoaf6ml','Canter Rosso','Alkoholfri rÃƒÂ¸dvin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005oqluryrpqrz7h','Canter Rosso Perfetto','Alkoholfri rÃƒÂ¸dvin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005pghsmle95ifnb','Canter Bianco','Alkoholfri hvidvin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005qkl3cn2rl6ou5','Canter RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005rvibx8z5xsb2a','SOBR Riesling Dr. Loosen','Alkoholfri Riesling fra Dr. Loosen.',0,NULL,'cmmm0r17e001o40ggmuyalpuy','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f005stcykufz868r8','Schwedhelm Traubensaft Traubensecco','Alkoholfri mousserende druesaft fra Schwedhelm, Pfalz.',0,NULL,'cmmm0r17e001p2rh39splbgyj','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0.5,NULL,NULL,'Pfalz',0,0,NULL),
('cmmm0r17f005tnbs11j05rv4q','Enjoy It Merlot','Alkoholfri Merlot fra Peter Mertes Weinkeller.',0,NULL,'cmmm0r17e001rjz6a5nhh00jd','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Merlot','Tyskland',0,0,NULL),
('cmmm0r17f005uxn7qnjgbeh9l','Enjoy It Chardonnay','Alkoholfri Chardonnay fra Peter Mertes Weinkeller.',0,NULL,'cmmm0r17e001rjz6a5nhh00jd','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Chardonnay','Tyskland',0,0,NULL),
('cmmm0r17f005vuypn6c4am7yd','Enjoy It RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Peter Mertes Weinkeller.',0,NULL,'cmmm0r17e001rjz6a5nhh00jd','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005wwje6d0g6db7d','Enjoy It Selection Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Peter Mertes Weinkeller.',0,NULL,'cmmm0r17e001rjz6a5nhh00jd','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Sauvignon Blanc','Tyskland',0,0,NULL),
('cmmm0r17f005xba8v9lea48q3','Enjoy It Selection Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Peter Mertes Weinkeller.',0,NULL,'cmmm0r17e001rjz6a5nhh00jd','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Cabernet Sauvignon','Tyskland',0,0,NULL),
('cmmm0r17f005y46mtx0tgxsi6','Torres Natureo Muscat','Alkoholfri Muscat fra Torres.',0,NULL,'cmmm0r17e001syw179l4faibu','2026-03-11 14:29:51.000','2026-03-11 14:29:51.000',NULL,0,NULL,'Muscat','Spanien',0,0,NULL),
('cmmm0r17f005zmp7mp97fcxvj','Torres Natureo GrenacheÃ¢â‚¬â€œSyrah','Alkoholfri rosÃƒÂ©vin fra Torres. Grenache og Syrah blanding.',0,NULL,'cmmm0r17e001syw179l4faibu','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Grenache-Syrah','Spanien',0,0,NULL),
('cmmm0r17f006009zpccb0jmu0','Torres Natureo Cabernet SauvignonÃ¢â‚¬â€œSyrah','Alkoholfri rÃƒÂ¸dvin fra Torres. Cabernet Sauvignon og Syrah blanding.',0,NULL,'cmmm0r17e001syw179l4faibu','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Cabernet Sauvignon-Syrah','Spanien',0,0,NULL),
('cmmm0r17f0061shdpmkz14ofd','Lussory Premium Red Tempranillo','Alkoholfri Tempranillo fra Lussory. Castilla-La Mancha.',0,NULL,'cmmm0r17e001tdsyzzzkb2rbi','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Tempranillo','Castilla-La Mancha',0,0,NULL),
('cmmm0r17f0062neqn0o779cm5','Lussory Premium Red Merlot','Alkoholfri Merlot fra Lussory. Castilla-La Mancha.',0,NULL,'cmmm0r17e001tdsyzzzkb2rbi','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Merlot','Castilla-La Mancha',0,0,NULL),
('cmmm0r17f0063m4veev9zcmyi','Lussory Premium White Airen','Alkoholfri Airen hvidvin fra Lussory. Castilla-La Mancha.',0,NULL,'cmmm0r17e001tdsyzzzkb2rbi','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Airen','Castilla-La Mancha',0,0,NULL),
('cmmm0r17f0064bane1zg4ravd','Lussory Premium White Chardonnay','Alkoholfri Chardonnay fra Lussory. Castilla-La Mancha.',0,NULL,'cmmm0r17e001tdsyzzzkb2rbi','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Chardonnay','Castilla-La Mancha',0,0,NULL),
('cmmm0r17f00655brarofitw34','Aldea Red','Alkoholfri rÃƒÂ¸dvin fra Aldea.',0,NULL,'cmmm0r17e001u6ojv9wowuz5s','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Spanien',0,0,NULL),
('cmmm0r17f0066sf5ib0eab8fd','Aldea White','Alkoholfri hvidvin fra Aldea.',0,NULL,'cmmm0r17e001u6ojv9wowuz5s','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Spanien',0,0,NULL),
('cmmm0r17f0067n5oe47v4ro5v','Noughty Syrah','Alkoholfri Syrah fra Thomson & Scott. B Corp certificeret, ÃƒÂ¸kologisk og vegansk.',0,NULL,'cmmm0r17e001xmwik1fo23yox','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,'Syrah','Storbritannien',0,0,NULL),
('cmmm0r17f00686fy5gded0fcy','Noughty Chardonnay','Alkoholfri Chardonnay fra Thomson & Scott. B Corp certificeret, ÃƒÂ¸kologisk og vegansk.',0,NULL,'cmmm0r17e001xmwik1fo23yox','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,'Chardonnay','Storbritannien',0,0,NULL),
('cmmm0r17f0069jot98jb1ulbc','Eisberg Chardonnay','Alkoholfri Chardonnay fra Eisberg.',0,NULL,'cmmm0r17e001y50b99od5g6cq','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Chardonnay','Storbritannien',0,0,NULL),
('cmmm0r17f006aacr5k1vbsom6','Eisberg Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Eisberg.',0,NULL,'cmmm0r17e001y50b99od5g6cq','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Sauvignon Blanc','Storbritannien',0,0,NULL),
('cmmm0r17f006b1makyk54mno5','Eisberg Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Eisberg.',0,NULL,'cmmm0r17e001y50b99od5g6cq','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Cabernet Sauvignon','Storbritannien',0,0,NULL),
('cmmm0r17f006ctfatfhvp8w5e','Eisberg RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Eisberg.',0,NULL,'cmmm0r17e001y50b99od5g6cq','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Storbritannien',0,0,NULL),
('cmmm0r17f006dtljyea9mceyr','Alternativa Rosso Dry','Alkoholfri tÃƒÂ¸r rÃƒÂ¸dvin fra Alternativa.',0,NULL,'cmmm0r17e001z5h15de2ma08f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Italien',0,0,NULL),
('cmmm0r17f006ei8ea7o4ekzzy','Alternativa Bianco Dry','Alkoholfri tÃƒÂ¸r hvidvin fra Alternativa.',0,NULL,'cmmm0r17e001z5h15de2ma08f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Italien',0,0,NULL),
('cmmm0r17f006fc635jc9m6yw7','Alternativa Rosato Dry','Alkoholfri tÃƒÂ¸r rosÃƒÂ©vin fra Alternativa.',0,NULL,'cmmm0r17e001z5h15de2ma08f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'Italien',0,0,NULL),
('cmmm0r17f006g0uzh926ztkkt','Vita Libera Primitivo','Alkoholfri Primitivo fra Vita Libera.',0,NULL,'cmmm0r17e0020juo837cdiq0q','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Primitivo','Italien',0,0,NULL),
('cmmm0r17f006h9qm585pd72iv','Vita Libera Pinot Grigio','Alkoholfri Pinot Grigio fra Vita Libera.',0,NULL,'cmmm0r17e0020juo837cdiq0q','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Pinot Grigio','Italien',0,0,NULL),
('cmmm0r17f006ieplv8x4cbksl','Flein Fizz RosÃƒÂ© Prickender Druesaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk mousserende rosÃƒÂ© druesaft fra Gross & Gross.',0,NULL,'cmmm0r17e0021f5vhcsp88g0n','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'ÃƒËœstrig',0,0,NULL),
('cmmm0r17f006jdti50cohryut','Flein Zweigelt RosÃƒÂ© Druesaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk Zweigelt rosÃƒÂ© druesaft fra Gross & Gross.',0,NULL,'cmmm0r17e0021f5vhcsp88g0n','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Zweigelt','ÃƒËœstrig',0,0,NULL),
('cmmm0r17f006kgy6u7ie4pzou','Flein Sauvignon Blanc Druesaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk Sauvignon Blanc druesaft fra Gross & Gross.',0,NULL,'cmmm0r17e0021f5vhcsp88g0n','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Sauvignon Blanc','ÃƒËœstrig',0,0,NULL),
('cmmm0r17f006lxjqv578867s5','Flein Gelber Muskateller Druesaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk Gelber Muskateller druesaft fra Gross & Gross.',0,NULL,'cmmm0r17e0021f5vhcsp88g0n','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Gelber Muskateller','ÃƒËœstrig',0,0,NULL),
('cmmm0r17f006mtdr0yx1d4by1','Flein Fizz Prickender Druesaft ÃƒËœKO','Alkoholfri ÃƒÂ¸kologisk mousserende druesaft fra Gross & Gross.',0,NULL,'cmmm0r17e0021f5vhcsp88g0n','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,'ÃƒËœstrig',0,0,NULL),
('cmmm0r17f006n7cz56gxiw8dr','CERO Chardonnay','Alkoholfri Chardonnay fra Golden State Vintners.',0,NULL,'cmmm0r17e00228n2kiso5r8lg','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,'Chardonnay','Californien',0,0,NULL),
('cmmm0r17f006oupuis2yy7wm3','CERO Zinfandel','Alkoholfri Zinfandel fra Golden State Vintners.',0,NULL,'cmmm0r17e00228n2kiso5r8lg','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,'Zinfandel','Californien',0,0,NULL),
('cmmm0r17f006ptaez9pci625z','CERO RosÃƒÂ©','Alkoholfri rosÃƒÂ©vin fra Golden State Vintners.',0,NULL,'cmmm0r17e00228n2kiso5r8lg','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,NULL,'Californien',0,0,NULL),
('cmmm0r17f006qmuptq9gl98nl','Vinada Tempting Tempranillo RosÃƒÂ©','Alkoholfri Tempranillo rosÃƒÂ©vin fra Vinada.',0,NULL,'cmmm0r17e0023c17qcg11ai9j','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Tempranillo','Canada',0,0,NULL),
('cmmm0r17f006rujm8fqaxrs4z','Vinada Timeless Tempranillo Red','Alkoholfri Tempranillo rÃƒÂ¸dvin fra Vinada.',0,NULL,'cmmm0r17e0023c17qcg11ai9j','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Tempranillo','Canada',0,0,NULL),
('cmmm0r17f006sb4gf607h6rjo','Vinada Charming Chardonnay','Alkoholfri Chardonnay fra Vinada.',0,NULL,'cmmm0r17e0023c17qcg11ai9j','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Chardonnay','Canada',0,0,NULL),
('cmmm0r17f006tr7jjmniisnvk','Wednesday\'s Domaine Elan','Alkoholfri hvidvin fra Wednesday\'s Domaine.',0,NULL,'cmmm0r17e0024xhayd5uvb25f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,NULL,0,0,NULL),
('cmmm0r17f006uralo7igio001','Wednesday\'s Domaine Sanguine','Alkoholfri rÃƒÂ¸dvin fra Wednesday\'s Domaine.',0,NULL,'cmmm0r17e0024xhayd5uvb25f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,NULL,0,0,NULL),
('cmmm0r17f006vh7u1044sfdsg','Wednesday\'s Domaine Vignette','Alkoholfri rosÃƒÂ©vin fra Wednesday\'s Domaine.',0,NULL,'cmmm0r17e0024xhayd5uvb25f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,NULL,0,0,NULL),
('cmmm0r17f006wcg5e9etsycfi','Wednesday\'s Domaine Piquant','Alkoholfri hvidvin fra Wednesday\'s Domaine.',0,NULL,'cmmm0r17e0024xhayd5uvb25f','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,NULL,0,0,NULL),
('cmmm0r17f006xc14mk3vatdb9','DC Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra DC.',0,NULL,'cmmm0r17e0025hmx2rrgf019q','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0.5,NULL,'Sauvignon Blanc',NULL,0,0,NULL),
('cmmm0r17f006yp1hgqc7vealk','Day Off Sauvignon Blanc','Alkoholfri Sauvignon Blanc fra Day Off.',0,NULL,'cmmm0r17e002619hplwl3neaw','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Sauvignon Blanc',NULL,0,0,NULL),
('cmmm0r17f006zp4jlwuqh19e4','Day Off Cabernet Sauvignon','Alkoholfri Cabernet Sauvignon fra Day Off.',0,NULL,'cmmm0r17e002619hplwl3neaw','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Cabernet Sauvignon',NULL,0,0,NULL),
('cmmm0r17f0070ie0kqov9xt7j','Richard Juhlin Blanc de Blancs Non-Alcoholic','Alkoholfri mousserende vin fra champagneeksperten Richard Juhlin.',0,NULL,'cmmm0r17e0027fhqeabrh27cx','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,NULL,NULL,0,0,NULL),
('cmmm0r17f00719cp6yson1fmx','LÃƒÂ¸gismose Alkoholfri Riesling','Alkoholfri Riesling fra LÃƒÂ¸gismose.',0,NULL,'cmmm0r17e00281dalalvdq4h5','2026-03-11 14:29:52.000','2026-03-11 14:29:52.000',NULL,0,NULL,'Riesling',NULL,0,0,NULL);
/*!40000 ALTER TABLE `wines` ENABLE KEYS */;
UNLOCK TABLES;
/*!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-03-12  9:55:37
