--
-- Host: localhost    Database: udenproc_prod
-- ------------------------------------------------------


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

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;

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

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);

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

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;

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


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

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;

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

INSERT INTO `aperitifs` VALUES
('cmmm0r17f0072jb1vz78xem1j','Arensbak Rosé Sparkling','Alkoholfri mousserende rosé fra Arensbak.',0,NULL,'cmmm0r17e000z0r6r8dd3s854','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,'Sparkling Wine','Serveres kølet',0,0,NULL);

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

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;

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

INSERT INTO `app_settings` VALUES
('cmmlbbjtz0000xl9kidh7x09h','site.passwordProtection.enabled','true','2026-03-11 00:40:25.893');

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

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;

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

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);

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

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;

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

INSERT INTO `beers` VALUES
('cmmm0r17e0029eiyt43lt8xpb','Carlsberg Nordic Pilsner 0.0%','Alkoholfri pilsner fra Carlsberg',0,NULL,'cmmm0r178000068gpefafw0jm','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002auushxtyiep0l','Tuborg 0,0%','Alkoholfri pilsner fra Tuborg',0,NULL,'cmmm0r1780001scfprdsgs80v','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002b91212ht6v3v7','Tuborg Classic 0,0%','Alkoholfri lager fra Tuborg',0,NULL,'cmmm0r1780001scfprdsgs80v','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002dbb22ghko10m6','Faxe Free','Alkoholfri lager fra Faxe',0,NULL,'cmmm0r17800033b3z6oclvgdr','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e002er2vjz52vl7h3','Faxe Premium 0.0%','Alkoholfri lager fra Faxe',0,NULL,'cmmm0r17800033b3z6oclvgdr','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Lager',0,0,NULL),
('cmmm0r17e002fwxh2et7g6422','Weird Weather','Alkoholfri Hazy IPA fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.3,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002hm0f0lqsb6euh','Easy Peasy','Alkoholfri pilsner fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.3,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e002ibmo85i0h42fs','Burst Free','Alkoholfri IPA fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.3,NULL,'IPA',0,0,NULL),
('cmmm0r17e002j6cs6tv91oy17','Limbo Dragonfruit','Alkoholfri sour med dragefrugt fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.3,NULL,'Frugt',0,0,NULL),
('cmmm0r17e002npssm1ke8otam','Wonder','Alkoholfri Wheat Ale fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002oqdw19nubavn1','Energibajer','Alkoholfri Wheat Ale fra Mikkeller',0,NULL,'cmmm0r1780004amayoycungky','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.3,NULL,'Hvede',0,0,NULL),
('cmmm0r17e002phkpcf6q9l3c5','Implosion IPA','Alkoholfri IPA fra To Øl',0,NULL,'cmmm0r17800055qt2v3y8ec5d','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'Ale',0,0,NULL),
('cmmm0r17e002z0w66vmhk24qj','Easy Street','Alkoholfri lager fra Alefarm Brewing',0,NULL,'cmmm0r1780008llvw5smcmsy6','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e0031spckf2i3ym7u','Paravue','Alkoholfri DDH IPA fra Alefarm Brewing',0,NULL,'cmmm0r1780008llvw5smcmsy6','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003c2qefqheyjz5b','Ethanol Alkoholfri','Alkoholfri lager fra Refsvindinge Bryggeri',0,NULL,'cmmm0r178000e9slzuub3ljv8','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'Lager',0,0,NULL),
('cmmm0r17e003g09rzb62s5ohb','Harboe Pilsner Alkoholfri','Alkoholfri pilsner fra Harboe',0,NULL,'cmmm0r178000it0jer3p42j30','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'Pilsner',0,0,NULL),
('cmmm0r17e003hcz64ls5z6slq','Punk AF','Alkoholfri IPA fra BrewDog',0,NULL,'cmmm0r178000jq86bhvj22xjc','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'IPA',0,0,NULL),
('cmmm0r17e003jgz6ipz57xq5n','Special Effects','Alkoholfri lager fra Brooklyn Brewery',0,NULL,'cmmm0r178000kpnz3tnpk2oxr','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.4,NULL,'Lager',0,0,NULL),
('cmmm0r17e003kdib94y98s6ok','Erdinger Alkoholfrei','Alkoholfri hvedeøl fra Erdinger',0,NULL,'cmmm0r178000lznediubfg2y7','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0.4,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003l5twlkr97b15q','Heineken 0.0%','Alkoholfri lager fra Heineken',0,NULL,'cmmm0r178000m0nmjohm640vw','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Ale',0,0,NULL),
('cmmm0r17e003o92ctuvu8o3yu','1664 Blanc Alkoholfri','Alkoholfri hvedeøl fra Kronenbourg',0,NULL,'cmmm0r178000o1q1fx974pydw','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003p6ya9v07zpdk3','Corona Cero','Alkoholfri lager fra Corona',0,NULL,'cmmm0r178000plshafmvksm03','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'Hvede',0,0,NULL),
('cmmm0r17e003siutqyzs4cone','Weihenstephaner Alkoholfrei','Alkoholfri hvedeøl fra Weihenstephaner',0,NULL,'cmmm0r178000s4bj4zu0l4h7b','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'IPA',0,0,NULL),
('cmmm0r17e003z7f2oc4gitp1x','Beck\'s Blue','Alkoholfri pilsner fra Beck\'s',0,NULL,'cmmm0r178000x4l2q1rhsxj7i','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Ale',0,0,NULL);

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

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;

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


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

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;

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


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

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;

--
-- Dumping data for table `beverage_scans`
--


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

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;

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

INSERT INTO `drinks` VALUES
('cmmm0r17g007vcy1hpwjmc2m7','Virgin Mojito','Forfriskende alkoholfri mojito med friske mynteblade, lime og danskvand.',0,NULL,NULL,'2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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);

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

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;

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


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

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;

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


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

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;

--
-- Dumping data for table `not_found_logs`
--


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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


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

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;

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

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');

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

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;

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


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

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;

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


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

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;

--
-- Dumping data for table `users`
--

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);

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

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;

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

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

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

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;

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

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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Riesling','Tyskland',0,0,NULL),
('cmmm0r17f005n4kmvgsoaf6ml','Canter Rosso','Alkoholfri rødvin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005pghsmle95ifnb','Canter Bianco','Alkoholfri hvidvin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,NULL,'Tyskland',0,0,NULL),
('cmmm0r17f005qkl3cn2rl6ou5','Canter Rosé','Alkoholfri rosévin fra Canter.',0,NULL,'cmmm0r17e001nebvzd5rgmxp2','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,NULL,'Spanien',0,0,NULL),
('cmmm0r17f0066sf5ib0eab8fd','Aldea White','Alkoholfri hvidvin fra Aldea.',0,NULL,'cmmm0r17e001u6ojv9wowuz5s','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0.5,NULL,'Chardonnay','Storbritannien',0,0,NULL),
('cmmm0r17f0069jot98jb1ulbc','Eisberg Chardonnay','Alkoholfri Chardonnay fra Eisberg.',0,NULL,'cmmm0r17e001y50b99od5g6cq','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Tempranillo','Canada',0,0,NULL),
('cmmm0r17f006sb4gf607h6rjo','Vinada Charming Chardonnay','Alkoholfri Chardonnay fra Vinada.',0,NULL,'cmmm0r17e0023c17qcg11ai9j','2026-03-11 14:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.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:32:30.000','2026-03-11 14:32:30.000',NULL,0,NULL,'Riesling',NULL,0,0,NULL);


