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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

LOCK TABLES `beverage_scans` WRITE;
/*!40000 ALTER TABLE `beverage_scans` DISABLE KEYS */;
INSERT INTO `beverage_scans` VALUES
('cmmlazwhf0001wk9k7yu2kol2','cmmlaegb60000to9kja25ug4c','scan_1773189082414_hhaa47.jpg','17731890765141318720079391877974.jpg','image/jpeg',68444,'\0C\0	\Z!\Z\"$\"$\0C\0  \"\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0f\0\r	\r\0!1AQa\"q#2$3BR%5CSbcr&46DFesETdftUVguG\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0,\0\0\0\0\0!1AQ\"2aq#3BCR\0\0\0?\0-B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !|A\0.ɤ\0-avqwE㭀zTQI}z?Vܺ/\0G_\0&PHҏ]`Hg8\0߿t~]\0\09q^G[<y2q_g#]\0_Ӫ9 nm=nS\Z>E\0o|gy6p\Z\0/Y\r%Aa˺s|O#BըZaM w\0_&T\">2&q8*#g~vm9[ 8\0u!Y sAhQEGY\0<OW|3\\\rHؒ<&|Ŏ2PQPA\0/U?/\\\nG\0|\0c[h\\Qypwj>[EOf5g>or?ٮ+i\'nf;t29oG\\8Vv쮨;9(\rNQ\'W=H\r(Ŷnǔ???\04~s+18JT\"-prsg\nz\"-ܟE/?j9w ([7wΓK}jVw%DHfqj8wV$bRTqL?Ris|:+<=\Z߳\0ar-93DBv\"|*+Ju_,)e:|3TSp\'u7fWUa̟.<UIu/KJ##KqxB\0kjNi1+L儧|Ϛ8W\'s?T/ZvsK>X3Z74{϶`/f<\'|-.t$u$tFUQZև9\0p;ʔ\\e(	z\"~c_hO_o̬Yx:+wmESwywo\rgH@`[ɂFQ|mZՏCpߛ\0{Q\'&]-5U\0p#	G_矠>FFr^YΟJgbFӥGܥѝRwX#?Ar\rSKw\ZiDճ7n莈~AP;ZƗ7Α	ys\Zo˚\"ALa|/-;>@	cWDj&`0{ܗRV[ۍ=?g0p3dTN>VsA\'~矠!2т7ڕi1uV:G~:9׵|u:\\_Q}z\rr#7looNqpߪ9r\ZRJF\'7o]WdZ_=\05GT+fe8^(i^uib.5]=ܽW5&hU|K\0\0~?]\0矠J>*(;\0\0~qU!h9&抣q\ZfLUxGߪ7\0c9薇N:\'i>o˦ mDL\0p\0;gX96i,0UHg4\0fA@EE}x:7wn>/9&&{3wꏰǅ//zQci;ӭL6O\"B{Zc@ub&˶rRaji\n%[Q-c z0w,x%0\0=1ǖ)?٧~w\\@SSC\ZOO^#mĿ3}sKmգi~%!⏃n%3?T!t\0Ŀ_?w}CDQ\0N*r;g\0oTOˀx??*s]⩟bkBVAZ6EܤpwoA?KKɩJG\0|`!_Zfb^T5ɞ\\y\0R-\0?\0f)zBr^2\0o5^-?٧-M~}`D%i8=*ݒ/`y\0\0={|H\\LL$菩?Mv:GN߿٧+o.P\0̧;գ2y!|^<g+#\"z\'@+\0OԿ]\0A/\0=0=A6H=#~~GuA{/~{	]Nv8>;矠`\0~`cpeD{>l̯v +p\\{xq0gcܽQU1f1&$nwL3?XU\Z74	\'w$FəT\"HHJ3N +l8K+<6Uf!v=-%Pa){$LeH$s8Tes|&:/5p21)MGrD&fw%0*\0sx\"/QvO+dNοLY JUvXÇUn[=^c$wqcVI{++]E[@	\n\rn7G}# zAENͺ.sLa\'8D`+(JF<RNR$%A}] ;M; ;f6HID?jM(RӀ`|S>v3Pi;wr0b;b.Y#~	8ڇܾ{CKHFޅ=++fMjLcxIluqB]B:zcc⹮\\#̟P{3r\\{Ci?aiX֩xn1F<֎cZ4nQ#ɋ\\#0hN:v|]h`\rM%<z.)lTL8~(<>WR\'\r[=G*vJ@礼sB$A\'齃I5GGq9]2@R1j\r\0tN¥^Z6E%$\\ߙcnO]LZi}QQot[\"@OpVN.t5kiivrnj9l ܭCXq\".N ;l\'?rFc8ӷ\ZV1Mӂ|2|P\0~>}WV(:FsS{y\\.>ȍ^j6V.xfu(=)6V㳷a}#oúM<V^\'eZs@\nL][$gJ1]*7.qtZF*Tǳu$fZSӖӇu\ne!LrVU{\n(ɳ;@\Z鵯\ruTݲ[M5ݚ\0tť2&}k\rwjSg:cB&g@O-cµ&v+Mrծgfzʬ]ZBFv	ԓ)s\08@@RA#l=^o5hL\0zC,fUWBIQ@=\"tcZA.h߭gb©^oz	EBfpD%z-#])0s<:\"IOD&dA#Yh	$TbUpD&H$]Tmw\\f[má=YkGH`r+M$Vr^Fй#ݚ*.x|@\'в΅Di5(CY=j93l8=\r@gīFt*M4ylla<.D=nL\0QS\\)#Ȍ0ˡ2LFIdl2j{D=L\n聛c w!4t\"~;.\0\0:+idb;8GOJB3)Z3}H\'8SlX&`12\0M](-$@1ܼUD;^*rfNW<e=:w0L!3@{Ir٨ \0cho4#ZJe@\Z g֔I6Ǌ71)\\A2z!b	)GU.I!2Dҥtr1QPBC|ʛȘNx7rU,9L		z&˧3rU8c.DBlHVWc<1*L[;{HYQ­Y\'&V{hF$+a[DtVv\nCnoCJyAR\nG;cw\' X+\"FS@	b#\0K`zl<R\0\0%h\0쀜\0RJ#ځA@a8n{V:DeYq[3?}i\rG4	Ln#$mHT.M2\\TzEFԪ*ѭ$cF\rCzmj<Vm\'\";KJ\nܕ á]oFܱ-iйַ_]iQ[n[Um0c˙dr3w\\InfJ;`vuWs`^*Y)͞ЭYXYPʃHDd|;Jp?yi7+*5-*W Їp;T|m1UUX{1&k[\nyZW1á]&CzE@b3IL]Yuhl]d65oJp%]]F\'N$0BH(}v.ze2*Dȗ?>YJ$r~\'c,k<\05cAjqm\nMnIQRjڛ/Ǌ979$OAj]O?,dRiV=.\08sC[9@5ףBf2b{&e$ǡe|Co;~QN޽9\rSےFtt/.f>ʝV 3RLJ\Zq_(ύOo.q)D\0ߴejѥqsI=H .nkKH3.QlO46L!Xn)G䵬[\Z~k.pv4i;Lc|gykLeѼ.sVǟuebl55M.Ե}F｝fcV2IK4]>{{jDfP\n\nӭoc\nWii]Oo3\nMXt)T@Tttx5)Oiym}\Z\re?@VF,#,Y:^e^ʯ45(IR}LnֻE\rH*K8ֽ·oRKJ0*1-Tct%˺vʡ.-}.OUH:0\r:0=F{H)sZ|JxEJ*o/%aSjߖ)>Ҥչ}aUzh,xXlj:ӿ[Ѵgʈ->Җ:q_6O%*8;޼ո^[i0jƺ\0h`h}@vi)EO\rn\"<ˋkV8Sis6cFƗ%y.=*\\P7tI.Q蚵Lگ?/iuS`ִ%2C{(pY&i%ކ\'Jq#5d5eͥ܉H,$[&F4ِ#el+A>*LW9\\sfhS0\rI2fj88O`C`9N=U+#l3FwRҌ`ʴ=ǦI\"z`tnfP&! 9;B\0eXYr{̞9ge%#!DZIͺ,Ԧ#^\'׸įy\'|UuI0!{#Ȁ\"&w*C6rHCrX˃^Aú%D%Ha$g#pgdR&Uad80Cq-qANpz(ڦ\'ǢeOteJl\Z$;JG$8uT@pfm;4oBNL$SVY8V֒],z0GyRqi*΀YkVvm$re=~B\r®]={	(\00#R9 Hߢwi /KMtRZYQ	R\0RQIv	F/SHIxI?ij~P*_\0E3=r-6ZR`{h՞J#$	Ԭ.	3|\\y[:dĚ\r<pǙQisY+;c_1pָ|\0s1ֈĨ%l\Z\'\0[jId1vo6T]rl^0\0|+o6+PqV򺛆8t\Zw!\\&zT|}U;CZ\\hGHpvoR\0t\\uejvZ	Vt47N\0.VKypۓEYqZ就:Ҽu.#m;I5KKL.KCm\0Y[w]\n	rf7׮>/.{\nmgޖcPV߇X|R:ei:mh5A~)[Q&FTto\0is\rZΆ40Qk:FxԺ/\05m/f0,ܕxG[*j7v(|sOkhMߋ}\n\Z4m$Ui]Rh,ppzȴ۫~O(&\'ԼY@\n_*v9YjGK}F\ZW&yIJ\0d*jzZ\"JqmF&6\0GGW-FzWz5:aϥ`pP8iSDuQҜG!nw<n?b\r:j\\]?_/{.zǡ]Y_\\j@v,TGttַhh,=<mYOR߇oߚը\\B[ճLָSy^BܺO\r#֜1cX6=IFF!Y62	r+ko`s44+8u\\g+5g3iY]$i03-\n[K;aewy\Z\'B<Iq=ΒQm֧:%Nڛ#`L--.nnnOsr`V6z>jA۴Q`qbi\Zzu8s4^-ӝLwxo+rp*E3%Gu\Z\Z ~+\Z\\Ը^qqXsrr#!QYoi`ʑp}N)aL\0M#]׀ZdiQmUe1.hخqn>O{,f_\"pc˃c=@ޅ5(\0r&oF滜GҟY}cws-?|t#jΏ`YXfVR5v^YzṕW֛I\\7;w)\0=m9 ܤ#eTiv<\'3	3=ڥrK$키cqcqFe=9Kfa%3,N(x%L	i)_0	J1>@($p!+NOQ)$	\0`R2d޵vU_86=0׶>W`㠅?F8\'kIJ4APH\r\'bNi=	bs\'4F{4XJR{\nnQz(XcT%n0gM%L(IBCllOjO-B`s>.蟁nggWj,km«[Z&CiVV*S0}\n˕\"NUYZ!zÑK#n2BVs>G;z`ngdpH%N\0uMmR	zdeNDczP^+\0؟IaW?FItZ\0Ԫ&\"\0KBk25%^g7 tPpuvnnYsKzcVݻM<q锺~mSU*The=ʰc	\'ܼ8<N,u~CW/Zon4f\r\nFGĮGTKɏR$6\0\n֭֫_ci@2Fjz5\Zw(vvu)Ө\0j;<@U7RaE]٩1IIӭ:\0<*8zmb^=Je\r3b5O¥?.١Q-72I/4oSnzqV-LX_)n%{\0z@\0\Z{8K`RJS>\\On8|nf?\\]ĖǜffzLnGhi5{g7l!B N	iKmSKu\Z<B~-.\\\0Apn\n	iSMmF;\0=dg%eE֍is}8ӣoVms4zPj:\ZVZt{V8ՠ?\"~-(a`\'8RRD4Ӫcl*^Te7Ehk?;)?gXc?/ZdZn۽ah?bN\Z%Htsu4϶L\0VpeeP/܀SE8ѵ(\nu9KJVctڐ\rV\nipa9#\'\rf)<.el<Oq,Pq;0{9|~*Mh೵lrhsXk|O1X{c/n;@3ör6=B&;|HlT\\NA1*Zͣ+Ң0Bᵸ/Y%햵ܣt},v.H\rvyi}Cej`;t⚕*QΊU|[e?ZuC*=*}NIB_TІ|6]ƾO\\2(Nz!;Ѩv^mLRI{x#Y[s@ 5DҺ$i:%F{nG(P 3$7T{L!&aFÏHm4htF	lKp\n#g#N nnMQ*F\n1 \'Nr́ؕm;x	ZWg\00*`I@FdQ1\r2	褦\0Ǣim|:Qeߡ	uAv$y[#\0~@=RN9#T4\0 0$6OwQDߑ0c\0Ę$}f	\n`21ϡJ];oIViI\n\'mЦgީ\rKty&c{5ᆒ]3C0ov]J\n2ثkLoGkm՝IUֳYPnq{=v°lztN9T.GHy`&WRb dSa68H3;Ut*@(@\rűD\'Ljc*La8Rp?tLثcbTZN2Mx,/5]2ҙ}[\\j|mUtZ&}hJZz}#P$OygRhΘcag/O_fmT&i\ZoS(qw&@өZ}@0)X?]MU|涠aබ֗Fʃ/n[n\0lGqX	GFXRN-By:sUu\ZvsrO4>N7m.M*nT`WOl>-Sx,h7⬑wcݿ[)ztX\'{$Y#e&dꚦU\Z+@+5э6vByXр ;\0Ӳc.\n$	u=\Z}^zB$p:AJt6H\'yD%g~);U8G%㿢|k09Z@es~#x<Mc]|:9\\ȳ~;w\0UH}%f7ֹaxew0j.w.EV]w\")ǳ+l:]޹ZIt􀨯Hi~Siy,S-.C>rj0J4iS遳X=::=fesU-~UU[_j.0N<g^*FhK(VA>ѝ+0;W٭zLn@@+EѕB1A+EuDmk\'ԏ48i}ɠF:\'JC;\0\'iH2@VAǕ:z/?S |Ud;<<#Qܰ0\ZtD9s`zf9G{N=	KTlʐPmŕj s{v\Z5Y[UUͪ-\ny$/W^Wti}ANkr+ԵȰ]Jܢ}\0.tYCCNA`2&\n\Zz{۝IeJƠciɉWJJ)L_q7G]З~T.ET}V<PWw\\;q˄*G|liDf#+L7h^l%Iˉx:}.gnY]c\Z&sϏFcX1#KiUœi\r&q^[ʏN\'U2$mcJ{AJ;Y3US1LT\\|%1#1Mo)1v=(MODF7]4b\rH@FR~(!r#\0%g*Pi\r&f0Lv%8gu=ļ\0;&6Ḧ́gč$Qɒ=R%\0+L^J w\Z+dB\'00Bcd76RL8#ynd}<@\r\'ކ݅%I;)*:m1$ }*H\Z2w>LʕFwTs*a	!:12}yӄIWd8nLsMzb3_2v&\0S;0lXV֠ʫh\r¶yoEq\n҆GVZ+*X[+\\U}īQ RQ\09\n_Ў{%Z{ꬿ$Nl\0e8ꡰ\')}H%@:Ba\00ce qqXq6TX=ޏ؍<8oc&ʼqRz1hcX3RQA\"	E&6ԗKµe\0\r3+myIh5\\KNt<e䃱o\\RVH{\nRGLӬ4aVwNVs\\[^dP#żE\nTRM~K@^A]\"#fZUyTe6L՚:z;U\Z=6]ZSHׇ\'0Sd\Zp֭qqn:\rPs^[Wjgser1+iΗ\"2?mx=b&cE1\\![R\ZVIiWm>ӘrFIÏ~@Z+jB\r3*(pRԭn^Sr2)IM?3Z-ᔭ麣D`Utm^#V1}VW<4y?m[ǟK=+/I·ףO.+mv[=osi844Itfj5\Zl0vz߃&rʎQpmJ\0Nu\'549A  lJ2e\\_)SǶ4dz|xxww5_\\kG+fǁX>kRsU{ +>aIYbwI.AM}[v>☟ִFZ_a_rYVV`_Py\ZsURYźvt YK&\r|5Zs4z\nN.ihuu{ubHF\'Un^y =+-n2AZ,r?p>$9=30XS\0\Zw#6RG\"2gdy8JqI\01GPK&˟%p0j;o1뷔jC^Z@Zn[@Si)U\ZJ0pN3/-\0$Oi.Tdm\nfp\\]待Հ\'9lc5Y\0YoAi\0\nzM4rUb2F=L)ẌQmHdj-|aɭۡJm+$ikrhV9j7V[Ni#\0z0Tbv[e\Zg͔d z\"%⯶TQH\\gZ&JpܘqQPgs	 +@3l@ʺ*|L:c/%PDrL\0ܯ5L-w^<X<=N$\r8:# V{6@N<钣2=잞*7c ӌd0OF9)!P }4_T()#~(#xL<9S]H\' &#s[D$\0ctr</$?]?Dq9=Os\Z-w>WeUw^r4[Yi@*L4lǡzxR+=n-w0%{\Z;)Dn.g+OHSB66)&Jse	\0Ѻte8x1Z@T$-\0YOؙ`~\nN,S=E};({ܪ/uhm2AK\\\0VK\'Ԥcˁ5]~ٚϣ\\>)TCdaJKH^xt戟:=uqĮMžfLpyu^<9d\'W3t\0^K )+졧eRXޥS[fei6Q2qUocjүz{xr{TJlZKԵw\0C:T\\iu.\0F!VF?\"?wl\0M@:ҵ@zm*pbCV{i^J|_|>+\Z>$e)Ԩ1\n߇o\0ynd2>~Сِٛ:-_+\"eBi˟dU9JR|vWU|/.=ƙY@CWOZJ	hR|VQCIߪ\0\0-wӮ?Ҷ}r]-ѵѯU{:\'	]OvMӷf]IyVhoSֶéqHWW+UkJ$lX	6n-oqI)Tik!*Ӆ4ᴏ5*W/dm\r&1Ug-ZBK^vN휀}\0ۓk`c	m>zMsp:+H	犭SZW7~&;VyEVi6`6mHZYfRmj\\?$;\nM={4\0hzGFɍ]Vh%aZ/ќ~^Kwxrh-5[#pʯUϟiZZ<-\r[:Gxe7<Ikji	])#\Zl\0V@@%~#-.[zGwciim:җ@[DONSg:(RuGU{m\'8{@Qh+݄zW6[47\\?]NǊUci1g/d7@\0?\rUm\0\\pxc\r*nǵuOhǊkl++.m>Sjn?;<4ΒGֆHH}z`̝K\\[_갍\n!~JKR=CɿDpMkl\0/xmO)OcpIC%m㰵ruƿ}4ȴPqy_zv@WޘtTkDm \0U]:/hJv/KSxmX=Ay껋+kt)r(ј(Eu\n5\'ح[Fw:0yZ}AZZZQezA \0Fqĺ}1^T#ؽ:.oۗі9{<IMle\ZֺvS6]d/#xSysXjYwncumO2hvHա:գզ\rW֢\"F|U^fD z\0RvK<))\rmJqeJ\'bR9)Bpxmfǀ1ܤf(O4Oh+d)v)|&!8% J`!(N\0-0s vMJ (\0N;R0y[WFi^g\02\0\0OEgu3Ƃ؀p`%\':2DO~J6;@9Qz&<ҠJÓM\n[\'HE9>i\nDD#\Z-RRr%Me^єUy.xHӑ!/0H@kxWq\0t}p\'s.a]3D$5WNjlp\'2w*!ylYQeV\nʄu^b-bUu |2ƖЦ=j\Z3T%tf8e\0$i,R@zVDd.7KI6Ra(	r\n#Q0i9!/\n^4(;AK8c\0	n_.^oqk\\4;C	ϲ}*jsSgqݼBKJP0wps,)=Cʏ)+ÃxnВ@hvONookV̲-gj- \0{8dY5EtEj]Vv5Ů,3t*m:ea54(j2cj>!,wt!^,3;K\"cغeGe32D<;\\xYZңyst/-/4@*5::pV<{FϫS`ǋ\Zii41+[z#\0}RWl&7+(*/B79O\0oޘ ħ&c+DCOy!a^9輺\nIpᚉ?u6\rO	?|_x&|K腃_?x꾣kPM+\\Z+Pw,5mrZV]:2VC+sZ_k\\kVV{L\\YuMI֥H#cTÊ*U~汣@ݗ<t䅞nu=/XҬA紂I\nVh^vUו(\\}Jg60\roJ՛ϭZ^:;	U5\\3:dGܪvq\'O`G\0r|\ZGF6Xs4=;On3FX@Y({>)wW pAKa#|bTp2\0m@;ޮS0t\'4ꥹu*\nUӤ==ɭwf>G	薴tkFRhI$l.|l+#\n|SpｸyCT3e4@zKBߴ<])%&uc|H:|W\'Aյ[7~@}lSm^Aꬦ0bJ:QKm3IcZ*@m[vt㺈}eq[uFKXL/P(\n(*t\0M\'KeGPʖuX-8t6]ҦdWjT+yitډ|S%SJ7Wst/%8had`ټOw7XRA?[srs=^qY=NdnO6\nC٧wmTi!*>\rSJ)U\nH*VDF%ILukDR7Q#H+xr<88OA{@p\"$8nVCznPFdBX\'+R*4Ȑ=R0\nI*I)sF]G@eB`sInS)@\0gMq\r\0:AO{\Z!:Or	&6DLNh58N\0H~2DDdN+DtFH\rV!\\\0x\'ce2ؓG6bQIƝ`>>U{96\0xaZ/`c08 ÿkTn&.i9dgt9[z3Ӛ1-V2B-[;Uح(/G	ǔwY_GalI awCz8YP$(QQS\rR9Xg,g}rP  bhRv\n: Pr\0!\0FBc8Пޜ8~}Q*^~W譸-ss|杩\n*zHʋ{9iL e=.QIk@\n@\0z1IsRe]<Ý>K<H^[=]/M6=ΆJ?R;kp:Q]ҫߧ3wj5;ip\\ñqmHMKM,ZC\r̙\'Z`<ָ;ZKC26CK.VxE~ڙ-s[^c\\ \0uG.aAj633}괴m{ָZgF;x7Tp-X56,,mVp9i!Zq\nKH:/. F<½-9^M`Wgp˩|~\\\0*-`!ltzE]֬s9ܥ\'+ʿF|	DjɷG]@	vCp@U굿	[VדxNKO޹M_>\0l\0u.\';%M:N\0GQm[Ѡy͹ujўI24za:Xh!IZXRiry&\\I+6J/8\Z{\\Z|U\'@G+=1H.GcĶ\\Wu̡Wo3;`uAsjzM:+:8x{;jM_\Z=T\0l1$-.VڥI`x!1Z@D[*Gfg	=8o7Wr|D?KDϹW&%mޯ0.KcޗG5+S?4iʐ(	ĩ6ς/qs{ӡCϐA-hvWFL*k*\0Z:-{v5\Z!le%lʗƟaogVgZAkҵm*OGQڋ.{2AkCZN`R(l%B\0uKB[<O䟂\ZO+dQzR? #D\"|<JI]e g0`t%AJK:[	đ2ɴ-eZ꛴m^8mr)n¼=ʓMql7uulO(\\NǹFT<e>y[&\0Ye<	mJ$WއjcTH\'{)&xcsLn$I]b́@0br0=(BP7$G|T(V\0Jޱܣ\0I)햶1?dʳ6OcAzNydV$bDc|pHswTfH2<aD#֘\"8NcA@*C&&\0SBdS;UH^jfF#\'\n>P=!Td(;7A&Åb[]7CA޹\nf+hC=V\n32W;eYiYxKɔP XZ0U\0S,h4Zz)|V8e\rۄP\0%8\Z$G`\'HTQ#	ɣڝ3q-R\0i\\_윫O\\oOQC⑽Bi<wRCgiQw^YeFqʙ^4ĶZFRT7l\Z;[ʾ(gnk\\Ѡgl\\?u$.?vr坾#<twHhfچw;Utnjm0%h.XwL%č{x_.9KP~Rkig0Wyka\Z%;z-^_Ps^ķ$\0d]֍z^::xXDF/OjsV:݈hQ}NnVAoAP 8Azm:-hk@\nPH	h/4ۏez߭Q֪aeUU2[Gp?uFֵ~!i:SZխkBޏd\\dz\\4n+k9X L,z{,b-gopN\"?/Hbq?\']5\05+ˠ\nc>\ZOVѭǝQ.2CZqӭ>O%:Ϭ>zwKMKKVgFaq`~UoNNQZ7 黬B,os-Dx,ԺSh<JݓF{ՀJ:&\nhSĸAP{u]5qƞ\Z	=GV|2Sli;\0hPi\0D,\rvΛu\'Vͦ\0ڛBї=F\0\0)2{٭Uhh(s\"d-\'ұVquVΩU/~qZmެɖzkj_/{[nk$\r2V4F|c+S2އ!r4	$E(&w JY4yY>t<g$-횞,k!\\O@p<S=sXjeԴhnO`;׎x{NG4\\o\"M</H_VSSf-^Oڈ۟[d3MlWv\0>KtWV0eFR2OϷ)+5C&yQ#\'D)\\aS\Z2D\Zchݏlwd!l%\0%[)XrL葠U\"A	lM+@>>p3=x*=ttMop~m|F^G>q̯U6ȟXxd@nH	>L5C S&fs)%F#ވ6D}%xV*MO$IqN;U,9QCոi<dS1VZE-EBs-{/\\F`Vr/H#ܕ$\rEkAӴ C8\\ׅpZF.+Iy~o\Z8Vրث,`4z%բH\n@Vg@	ֽG.CC{wDmՅae úaCDU7ErKRДOU4pNh\r7J\n2$pe\0]PYS\ZDGzA:-Z9Ά0t?JcI\Zl[i,:pc5R1/q.5a^9<Z?u-VwQԤwqn-SIq&\0MJ\Z:}>7-(*\0)֧N^KIiU)vv$;KG[h7rM[&}	1:2y#rw잨\0 -~)4B۳kC\\˖pgRiizíVɕy%QLGz\Z/\'QTy~2{])V\0qUIS|{\0^?!J}rPƎw,<7Ak+a}5Z+H~QZޙNx\Z}WSXCُ`PW`7ӡooM(RJp1ix\\5mr{*.3\\ԸuC.lS~\0L?f-iSj=Խ&tJ0TX\\?R_tYck]v.BU<s,27|+Z{TRf=O\nC4+SK-AʯoiB{7RaRsX=lNHV٠o5V	6??<<YvUU\rCYH֙Yysh\ZjF<ƒ<h6vx{D+(omoH[&W,}wM@y*EiplďZ4ںQ\\6w7dӹ\']i-ST,n(UQ2eT&vc=#\rzP\"Ay-z +(4MOoU*5lH=*M_]ssRuj˺a\r!1w%ݾnef;MC0\n\0;rS݄ MBZ=%5(3V=.\n-yo\0+p)Iٸ+^YC)IiexZҥG/bókZNR.WiL4^Jtؽoac+7¶7vԱQ9xVN=%car22NЮmTqn #\Z39RlhYЭRQARӀ\0̩!L&B|1@Ol艓;tLdJsvN;ɜPp|Ub00R9FA(w	RV@\0ZvNM  Zs1fGI<t|?HN\n1>=o׹yj\'.Ff]Jd:=D	wڳlhGcH#c舒3%#wIetʲz{D\0(\0ݳz-㝣s(dQyv.@0\\)u]\r:)cnT8fr!NANgdGQ_0IJCD>pM`<{֥\rw\n=f)72\nf	1+Kgw5V3:+k34\rpay;lU<<YOm9T}rсwBITIJRH|hK\0l\'\r԰zP7/]A &<ހ\nt@N\0K	!8\"`qd#=k:s\ZՑP+Y@e<H;e%/2ݧm\";^޿.Acֵqw=sj;*:ZMhu[ӻJ4*UZ0w+.Y+=\\ڠ5\r3iuФ\"O0].\0+.֍@;2g$^1 >]ȕ3hZZ]W\\zUַHNN5_iRq5t4	%Ң[A*g$;?\Z!\0nνz\0\0mC2i\n\0.:a5{p8	$#E;rpYU빭 uTpLT?|h:vO>a\r8\\e2慝n*\ntsA1|58!sA40TfzJ!JH\rП*ȁ\0Wsm5ϼ.v~-\\x<oV=eZiY\\_ee\0R_qgzOҵ?8ˀMpZ:Ud:1WMM|GXnLL34W=\0TxGh3B&?{J2#1q`lAe\\V-Kprť].T@N-v4FikSiQ閭]\"(J7xmg={6:jt{ܕT]ey?A[ߵyqg9CÔXb\Z3A\0HxDd>2g\\qO9ZEj\0q.#i9<xE2sRM<[dA<soגUu;ai^zCQ}֪qz:Rv\nVj:R[o\nT$GZ=N*?M8Q;\\>=]pl:V)qF=0.GRi+=]qN$߱d/xD:mNޕt56ӐNӻOr$kH2°-`%p `wj<O&c\nL\ndu*DpvY@vwR 9Q>ӄ4I-I%SŤB֎pFeH6L{cmI=:z\'-1a-4+$c|vb@]Qь ٜda?eJ1% \"\'ԃ)b J#Ԓ|;H_zn۠u&)bɉO\0CqsH GUdA3yJ{ ?bT2I+gH㧩/rt\nI8ɛtumHО=&z߁@F#\rR4Yg+lj7Z=.]ҵmjO2\0K--닷Ik׹4ZT/Q굒࠹\ZC!X>MQMxI\"genws2yWD3_\']3Bp,l\n톟Jr4WLj\ZGZZʪHVֱyG}֊ߢ\nƌ`qYɐmrх]qM,d)ʂ0WR|)GzFOM)\0v9lp(N\n(*rD1o?<Y;༖)AZߍ^[ԍ\"_ 4j6T\nĀ͙+>l7Vj=u3G΀O=)4n+ԸDmU-A.!`q\\ruO,`җ}#?>ѝZӿk4}\Z\'d*b%quNGZߵ[i;+G<4I}rsHZe:R(hZr\ZD3	W뽣Tt5ʧѵ嶎ϵ{Y\Z	k/1qsK,#(⺃\rХRx/=.ub\05\\!pCVUzsZ9M7@rU/AeR֫j$Oo꟤t\'k5*t.Mkv8⫛oz]nYٴ4	IA.\ra\'ܹi<]sKb0#!\\Kj{#1TY^mLc_/CH\"U1W\nd\'{#5u\n>\08smt6uSTbdnF.t\0\Z.u^+g=m[pڽ(hLsHsOd	+y]%op˳J_Zk)ҍHD0YvC\ZԔ񝫈4Mf/ĥE~[*a\\:ݧy.qUҷM97tQkw\\\nl2)0I+9MQeVh/ԵqISa#Pp](vm\0H|Jv!b1,KOk]JA{KV%jz2u-KΖLGx>ZWFrz^!S<5InPA\'	?+aU(# )\0UN>>=\ZJ\Zc~SjU^/٫E8k{L텢Z0!_5{Ѱ\n^FT+>qUdܨV+9%zpHOFl\n mHU$yii}1v-bi7c}\rMCPȁlє\rB(:dM(Io*͒.c71r9W\"$.Mr~^`eFʝR޽4Ϛ^\Z@={\n.i>ϏfEPV݀{:Jxel+?o1BU\\GXDvFUNeEqlIhqʍ[p	wM#ҤkD£EhRDJ$&d:;p0؅hR7t;lF#F$Rsq(%Zm#D!(I;rOTovS)6Mވ>\"a(XCGzSq4ﲁzBH\0t`%QA9N{8HpB\"Y:\"r we%Xjq/]=csN:^\'r\'bj7WV׬ҡo/i5\\N7FS#an+$T&G|!07!yZ|dE\ZO~=<,$4]?C>c	^gGof,miU]X\0Yā2ܢԑʂʳ6^yU2X/\r^x\'$*l*\Z\nlWJvWȠ@?Ru@)F(Y耎#A\"dلD qMtJ;\0mgo;༶߁>+R/BAvR)	IFq \ZeKKESɝt-Nkj]\\OkP.zOE6{n@nW޳OBcܹrF:\\J0<yN4MᕿbEqPiNPB*$ZecF`X<m;hd-sqoECaٛvZ$$u%MK\0#ce(\'q%7ζ*7dٓQqZ4nw6y^=KI8Y>tp2ty9	Vsu4y8Ҹlot+\\4z|1TSկ;!tz\ZۘU+R{ǎfVQf_{ŷJgj紴U|=yCdh4.ɮm\n-z^oW4ԤHz^\n&ּzӣL\nG]0K4x\n\\4ѧզb\\%$]myW`XK[<Uv-{ɒ\0-pV^=ݛXȌnvhDO5ͭ#!\Z	:\0֯p\'̏~%zP?Ei?\ZWLdf\r\'qV֭ %y|6\ZO\\@h3nSN`Y[4xRh\":V~z\0]+mJPZ0׸~YizXa rM46ǉP50tOg9ip^;gг\rS3V*i3T@[p%=J H;%O6~Wp\0y\0r俍{я,7N!6v]\"=sk1>SKAtgʌN_=)|m>ŭZ!2z\0tԂl$M>ߔgI+~yr>RHp?>N\0ۓr~?xe`/eo6ڬA/=&@\\m*$.hY\Z<Mk2\"Yl4-o@m$lKHe#g;@BJ̺)vMVD\0%8zdGU>JK@d%\0HC`bBX+:0b$ڐ ʶCbd\'qpM$@GL\"8A\nv@32RLO=>pD6|@-PUr46^Z󠙟><\"d\0JlH27K=rf	Q9=,T#bTu2B,F@$3$VdP;׮ռZ&ra7ۼ\0eTY`5K䱃ej5IVw.y2y{\ZA&vY_J+VzF̼t^J\0wVH0]7Ciq蹇#WMj[#[e\0[Zڪ,pޭbDay[=g@`*N>`8rWHF#{hn\n2ʎBACe8uҞf8!	Q&!&QK%plH%+wKХJQc,#iwUu\not5UXz]+c\0?WT%Uօr]2Z}A^*8[ض+$\0EkY;gBЉ8▢-Nɖ-Tá!o4g\'\\-Z܀d4\'Dy55hu&#5e|`_\n3L	֤/,4ʖ\\k05`d\",v\0Y(!^RuiVʽK3N4o9z\n\'0۳Sj>ʅ\ZmkY1Qdu؁cWKw6Vկh9܆}1+j#tוڤ<-kT}C3O$k;Ȕo.Ե9u@q+ßPwĤ<5m#\Zx\0χsWUy;gy7Э4׵I{ލP;+ZtУN!4\0=\0-vEum5+\Zwշe1^y0L=˭p:F\0j٬S92RDG#9@Ju~<cFo?j횖,k\\:qBcgaS+A[GK584ωZemRDuBEVԢ]&pzw䭤4ԘLR3k@N):dK4]rtZyHs:~L@ZYK7E(9>5\Zp|\0K8CV|Bu l5~9\nL.:\0\"VT-foTs9]7+<k6g=Z/hњ~qE?.RyX2nerϊ}*pǦr\r=-$JwA\"$:$0)8@e<?2hD]ʙ#9?bL[\ZܿR3X64OV A0=I	p,k xi\"R6]}0uZTƙHlKY~XY\'تz-r0*¹8\\^M駑\n@|鎉>rʍ,pR3(VKdHxQ21q;9Q(&Z{L7	GF#	\Z%Z́L%`\0klH@JdBwMw\'63|CHOP0 @*|,y\"# %pѰɐI&O|lO\0tR>\rwFc	VOH41TLyZy;Wۍ]T`nqcJeEEaLcfN9pدv\0-8!x[[j7#8,|~<\'SF@m@UVZĢg{ඵ\0:[kVV/G8C\"#xA{hĮrrLTeCG\r\nla(\"\\#bJ\"PЖM\n\r\094BVT0&ܬVdea!bgb^+a/?粞0WL^kkzѧ]HFsȘ%rkUzCn?\0>P\Z	4aJRq3PH>+_3TȌ*gNw69EF	H	tHƱzYi>hs\0fMY\rvtܾ[{rjr38<О$}a;^Ц>zg-wA:,]<b=js@`kWmqw!7ν-si\\]yD\0c%ur{٧4<BpwSӪ(#<hX*ZOg\0\r+q\0X\n\0,Oqppy.#gu\Z>o>ݦ܆\\6̨;&Awq}|jZaͽnw	*\ZFn)2d=\nH<ک#O?\n\Z\\CK\"\0,3Hr+DT\nWLmf6hIVew>0[LY3xZ,Up£ldw*FEIgWlqN ^cճo\np;xSDzyBޑHŻtڏZ\0V~ph2X@F8c5\Z:d`:\ZNx*ރhM\"AA^.] *[PZ3L	i}{4)r垊Sf\0K+/}RdXjj-p\0aL]UH$wD	c܎h1$3B((Q@Ѓ~f>VOd#|}ʹU\\/5`@JMO]%cq)5\rfKzB[.˧0Fh,}&:,\'!\'B෱PcC@![ͣ\'dO`ad_<DeJ̈́Z݌L oOBkr=xs\'h		 `\'EP&})˔W6JB\\\nKa\0Q\0YFJ\0dm	ܫ>%<\"d<^n!%AVw|*v荓OdBf:8͚_DI\0p\0H;_o4=L a+wzd:&`ʚ\Z3/U2WL%BMddP[?!?c|2%`\n=\\]l/`8x+\re\0UKsUn+pXW1ᆒx]GAh\riz\Z<U_AשG}.-6YVZ+;p1%zx8^C0w2\n\n\na<(I3N&ɠrVhwt\"eMê<\0dA>8?&[P^91؉\rR//Cy-)YV^W<?br:x/]W2lcn8f.ŷ.k*62HL(n׮N\0%GqT82$Q\Z_[D޴Y@oYQuz`$-\ri6tJfݗ<¦@*:%uxezE\r=&Zp\00Ե8km&@]k\"]Yao\\78i!:8vӔZ/Lis=5bM{8GCci`Ã)$|^K;BW^^V\0w+Z5ݧkMO)WXy=\\y֤iʉ\0VHwnѕp\\Q4cD|ظN>ݣ+.I\0y8c[_o]ݛAclW-sf	NOeZ\\^ؼ 8HNYӞV\'\0-8j˯i\0}?q\\?Z2;,O(c)#\nƌv?,#u](؟E-Csq\\WM=ֵ_LaTF4ViW-ѩYm}cm<T!#L	Yi^+@-QxCO,ҫ9IӟAV$-E&MRy%YQqY\\jHWtD//	޵_VӮ,lKk\0םۍdwLliS\"g-8*OVTm=|c((k\ZNyb	z3|>%J:;5Q>hOeqZ\ZT9i7.mr`}nX~1P\0DJ$(8zVDB}H\0e!r@Az)$_1xb-n`}g+_ƈ#=K)ѡ\'isF/Ѫ	T\'!3Pa6\r[\\-@,uylNVഝ6B෱hU6@@kmOsOFG?cvYY!))R\"sq#&䨣2Y6~\0viwo4-zQރW}l	O	bJQB]F\0 ><b&(q:&\0Gt\0\nȊGČ@I 8kPTp#&p!:GLh1ib>U5[A>+(vI 	e=P+DUZ;ת=9^zcL	F&nZ<ɕFvL#}j}{(V^jjv̒:/#)	td	.D\Z$WS,b)%;N˪hTDeju+;Q/:쵴諬+:qǊRy(/m\'u*[7MJz9_\"K0DGN2&\0@hQ\"J7I)BFR%BKc?[kTȍ>6?6C\ne7%ďb/Es_ƊGQOVZ]ž/8~\0gC	8uVq5WTiie}VcG~6UYT\",m3ʖͺ֯ѹmZ[<*sotB  4C\\LԬųbS+{-hDcڲ\"NU#LRfiFƛ㛕F	RDjʃÖesu?osIDT\\pyt* Y>1} |uQ&V[NM4.HNW\Z^jiȹlxyt)[M*5{Vpre\rwjuhR@\rIԬ8=Sw\Z)3-2SFY\n3eV9=k@k\ZUk\n컭֠d\'8<[u4zECrUwu.5kcFޥ6Ѡ*4h2]a+_͖Z)g0f<7Ky,ӪEu	(\n:)pKp*gVunhL&;ɯ	:cOx⫗J0q<? dk)5脘lz_仅\'\rWra]Qϖ<UM7bi`n:\0xΟcb+ɗMˤx.}6mRەôEg@jGԵN5koZ{إኜeYm_Ĝ%kWM<څ0n)L\riBZetz8\0<uA겭kdV%Ԯ:n~ڕrKv5Gnuc{кK\rF.FtRrTGnA脧n\0h	牵_jX`H?\'AhڗڱeF?om整,4;]p;s\0D#eLMD@ޗzi	b=D	PA)JDs\0,΍wr^M\'bA\0X\'ECN\"?I͟H}@&^	Z\0m&C, k&#3o!c\0FHXˢ:ʢȈmjc֪l\0\0OrW,6Iz}J68z\0rcr{]LNiLU=pќ$2sMJp33#tlb솼\0Ӈ3|\'uPLBl\0I7bhI7N6+d=n`ђD/hh[=Jڤx<F>;K88IBɛ&5IP?\'=g8ǠjX1܀NDe9ѓR3tVDeZ{r@ʆt!H9\Z}35D{-\"e1\0,1	ޥ{\rU$p^.2)8:.gJ\Z->ZmyG࿵bUE]hih܅Nij6Vve_hщVtؓĵ+{h\rWyh	߽z\\Q#@aL7\r-SWB9#ց=	Fd*jp`Qr^#)@\"Q()Ƥ|c*\0=ÍcU\rLb_/oܖ1{I {(;\03\\^%t^6lI0~+@E޺6bZ%C	#мk[ֱs@ђZm/(v8N/\Zj\\ֹ}FQo3శ@,EoFW\ZmCA?\n/(\'\"|޺PʔHh\\<с*Q\"KODGÒ.u!\0:͎l/tw6T7Ltٟ)XoeN֐\r\0O IV8MqHB~m,?n?\Zغ׵G\\?$s,·8m:>+8@yũZ+,\06\'p62[]>*o7qd{o:z,M}kAM\"ݹ\\;UӨv+1L]O_QwYI5Zl3p*6Th=,zޖz+Y\0|w#\nD&sc)]Heq}ohR,9G]N\\XER_i,9ʴl0K:P@:s_&ooywU[5R)նNO0#+}WV+4Y#zGXN=KPK0BJ. hw-\\A[q=u~.?̀_]g\\vô\'\n32_$o8MO%kd@S;}&&f$RNNB\0u	uKhQ\0; nl<1C\nޟE>򬼹HѷWy8GMg+qχzf=!֦ ())\'d<c⟲VX-xc+\Zy<Jfڱ\"pB`N|J\'18jf)\"zk@\'VM\Z&9:J1OaL.ʾ	\0)\Z;۹Z4ʹâx#y\n19HЌGKq\'\"Q9\'ԃЋca${<R	\'u!MPcRDǹ)g\0BC\r:ح:dm.8ʂy3׵Iy<zɶ)dفl jD\rw^G#EiGrR08##	\0\nfA*F2fz)9a*lJaTߎlo\nMrRQ\\\0N˧yinrm%emѠNR]7JC:,)\rBR 4GEfnL0ǥV+KQej͡cOG@\ndI^fhbZ8`E	\r!)cGS\r7nXyNI9R,hJxGT`p\n=	$%ʄtwFR As\Z1\\O@8,7?X4*@>*2|i=\\&	4z%fo..u6*S\'\"stVSkua|ev卻u-sOg2NM׬)VciI8Nw8X[W:\\\ZE\\ #Fb\ZSd\\֎cu/?o\092{~2c	$M|*N1i=2>m5&bkt5ZWNn#Qs;J?pY\"g8rΫxywhBHA%c4&ŔQeq9$A\\V]-2RоNj%דW=ݓze7|8\'Gb&hD>ʴO]W蔇QQ\0w_BuFq/9OD69TM.,4{wx{\ZH8f\'e)f\"r0TL>*FpTgWq!\\@Z=/VJEE8j09	8yK9[}9+*},h|\'^ZGi1ǳf0%FwOUo.Fˏy;\0:}.:a%\0OFJIl<UM-UO7|jkkuM8*eD}\'s\0AHM~\0cVˬ\r[)~\naKOȸvJ̎1LM\rT\0R}X1լ:C5ۑ>.5]K5\ZFz5㲳0FTz&KL4MS^G?b:gfq\\>}kQ)5A9ŮKv]p>]N{.8\0{V.T*K	IUqnAԜsH\0Ɲ`\'ZfB\n㚝>ftuB{e)J&*.a46:3FYJHAJ;BNc߱$uܼxcM{]ine7\Z>t3>}u\ru,dRM1RуLԲktz`첃,4\raW~\"O6L-gE8ʶ I\rrK6GynvǊ͗AӼw\'ODÁ#+tHӍ)Du޸NzR6\0J73smc7CFqt!t:0۸ \r>(\068Nn1)C@ԭn`DVc\'q:uX6IZYmiܻ0g3ϋ*Z<[@0agޡuxp\rlImEZ!NPWsBϦ]mUb<mGImv1Nh%t#i<ԦJǠStE67rTnCԮ;g;и\nî\\G̮U1tZyǽ^h;grqFDXenZ7Wrݥ\0ykj3D\rwu&GoN#AGm*@͕bh[FWWz.h& z)CLu>:9zi)tRU2lV`L)ӄ	N(P (\0%,\rR	GT)(2u\0bF~\n6<d*D7}%}H.xkP^JfdG_\"n*W&,΍xp>TT0鶵>-YEdw<s7Q}\"Jp7YѪۻzuZG o毦_ꚛ+^еI+*szh6ͣR``$6M4]G_S04\rj4Oں6J68\'<GL}\'UVqjk;sR׀tt`x=l\ncQMWh8u׵C\Z}^ɩx+C|sWX>WyBߝ7蕗_Sk`oiZjm/k]ѰDNFYTA̼ߒj>^`aoNg!(ֱg[/.;W\'Ҍ[\0XA)\\E\'M\0]#C,P.8kw25*(ylV\0ʷ\ZH؜Å09yo^\ZΏp\"?a?fmGIjuOI)Lh.\07>nh{[oj쌹=pSs67;BL{Ś3guT5јɏ]xJFiuQVr91Or9Fd RHGRD4BԱx<ִ]`^1OS!cxׇ*jm-ÔA5jP7yy};jóVL.ŀpg!pq5RU2:&	u#^q:<FqbQA%R`wu	LBI`g<[[]p};\Ztp2?s^Gk3ho#*8c Kim@$*\r,/mk[HHe/[Nqu87O]:9CxJ\rԭҴq0NH}rX_I2pޜ:-晏jpCt>G6ɝ\Zmy2cL?->)yY`Z9l\nG3|VM~#uyE1⭨$UV\"9Uܹx;(`{Yjb)LeF߂L0pOd#HЬcODzp72A0g n:F[	]C\\Fa#\Zd@DRb=\n[\00:H\'3{ǥ89Vt|S-x,ڋi\\Z`lN\0XIhіҴKB\\C\'ܯJkU^5ŲFҬVdA?if+K^W]&LJw/^RoTTԮ+vRFtG9tat؆=S+}3FF4>86̦֐֏@Wc@UVP#\nƛ>\npVZ\'0D)&@^b90Rgl	ErZvG/#+Mɭn6^Mʢ[,KHGrS()8[L)LLdzid)#\n*xSL3_GD`B\0(N))C_G%MRd)D.8\0OoM\'VqN;Z\'~?UȴJ(t+uêZi	ǉ^^3{:\ZTsJ,K-Oy\0L\'Z\0濙#q=\nkNnğvE\rnݴۑ|#|%Rxz\0z	YK%闎:vP^ߖCQۡpmVz,B*SpA4Jh}iL}kRfYJܵ>h.Dk;\\q%DpPFQ~|!]umouOvvWOB[\\|ۆٸ|8\\ͣI*4xpm_,yE  r6XW0`UZ>zjZ6:>c[TM@^ ?FrwVZޮ\09y5~ꥍKzZA\"\"#(%|@?};&\0-i{^vw7TӯpCE&;cv֮iޞڛwBCQ3G:QaV»!й;{M*Τ\ry/᪍RO^\0%6\r?zwWTbbTn\ZsƓA4aK;}{fbU*\'y9舴CU*\n)y?|cJʦֻu7\\\n}*Ƌ-)vt98=JZ@6W\r4yy$+Yڽa]H!Hh:&eG05Fޅx5K\0U\0ml?+ڴÙah\'pӲ4bH%.SfR\'IOЮGW\'?W#n\'h\\Z1VY\Za|3?@G- 	艟ف#%)!EKѮP79Bzr*S&Ϛg``?,U\'OQW\\Iv5:\Z{oXC =;P\0\0!q9{&S^Isv\Z.FH4Z&v荌!4ʩsyzqgíG?OM/\\hXҭ\0AcTڎqt\\AOfLӪi|{\ni4zBӇ^k8겔^<(/l\\+jPB:lm7VnC<NAJe0\\#Q@aIH޾\0lJ{\0\"^{rIN6ZG*qtF*6+L\0(N3cen\nNm$;l#\"SA&9 x)Ŝc6NL=LH|PbFHꫵ\0b\\qz7>F՘Vh*	U;KW&ATHohGprҗ&գk4\r;\\ztT`Z-Zv8DYA/oy6BpBM֥MێMMy[l.U-ZWnc+Qwy|(PsFI7Ut߷rS	[aFyY#gP82EAS5\'rulBݠ>{\ZA\nѲ\'RLcz)$H6KLx#}tu`[D͏`*fBifE>m)VlQAJ0ss\"oTB*>)\";.z$(\nHR&@cMN/\rMڽ|sce(4qyj\0b\0n/\'-1<\0I`Yg9z߀}`3ڹom]Gô#{\0&6sVuނO5K\'W?ANt=͋s8|=11UsJ4ԥQ}\'s012eMwauKOXJu@G;cC\rƕphY<3Q>CL2ߧ(ZK_oQ<m2xШxF\Z9\ZC*Rf$r3\0*~[Mijm+NOYrq[[{dy\rе\ZQ,8ᖂ=?:]\nUZֽnjyfVgwe\0 }o+PqmO:U`~Q$]kCw6lgzSF.=4wT&h/	AʒvVny	hr\Zwg\ZFSqu&n&z!+<j\"ոaER]3_UEEmOYo1R9*Ä=P??\nWMJ눪k4u[jGcB״e\nq(鲖߇eMEOQ*S.A6$\Z9\\hk[P\0Y#D	ɀR)ƅ_Թw5WO2>cp0\"Zt+FZ䎅w8Z=ʃ7$~Lt$ d]uhzxeotBxo4f˽:s `v6[7~~{\\P82\'a4,n\Z\rKnFUlh U8_Xj*H}ZBFD7XyPsJGk$8$ǂ`ʬh%Zrاg!*ыqau{9Byx?Chm#oBqs$ڒC{	J>ۢYYܲƭмHO8V	9i.],\nڑ6U6s\"\'z5GO92[Ͳ*fz(R4GZ-$7N6OgUgfrn!I\0;>i -=	蔑JH3nA(vPC]6`!5>Rq>*6vB00nv1t\'?=rԚ\rnB[<}\nl-i dZF=+?Qp\0Gn!s[myOm=Jv6sˈ?Ժߕ+n{*U,v}k]*z[;Ǝ$[kz[J7=\0.φ*Z\'	ÂZpqmHS	ɝV Ҧ2]I(0Qw\\9I4ΌYzFmM&?\0)F	/hZq%xdDsTOHiO=UsHn<tɂӸTqKKW\rr	[sp_}+N.hA4h9+①Z#&Hu+BcF0jcoLօ3SBkE(ksN*8$AN\'	6;#ba7ܗdь J7Rtgh*QCC;5r\0OƇR{P_6s\0ǉheƧq	scO-!3\nUu}vJ6uYzmyH-pvx&u/ӸeC<z6sm:ZزZ)V4~OBU(+[#rn6oivGjt6CY,G>;ktf^>9rE4x>uy%h<ſֲmv&^:T\rw/5]6WMIԠ#qO(kU/}]Y6}pK֏y+#V牭\\<^oOgQjrSآP壑ǷzZmZ<\'\0[+!][:޽ZX#ǡGhIENoqM)!Y:1xVCl&\0FTGњO?\'AcA:\'uя\'BH}(*X<OB{\ZUKV)<\029^mYkkK\r\Zҽֻ+cVvk\ZQdx+hdW!<G\0iu-}k%\01򎉠z7\05s#pGT@\0V{}X1IZiS9x%\\EĀ9UʒgItRʣ^a-A^3JJՔ}MٖLଅ7hzCnGH/uFVqЦ\0|=fIѪ;͸;:Zכjm:j6PӬZ$%I+<\"K\'	ɟܿxEU,\rGяiWƪ)ݶ9c#I*>Ux惮4;JV8\\܅7I)vډUs8\rVE+j7[\Zd=av1dڕn;;JB/h\"yW\\vƍLT\0j[9ND	\\ˀG\Z;:=CIFça\'9]8*ïyDwL;B]y{tGjl[G,nzA>ծoL|0K,58\'P$kvRgԒF\n-@~}ASV&;3vwZ~$1QgY{l?[y*AgY\0ǂ\nҀ06[Dg&dx[)8,~K\nFFNܬZ0H8`o\"7J<V%Uč8z[Ske\Z Jw@=;@\'	&v\"ر	\'8AY0TD&v#جVϝ<NDɷk\nf:C|>U$T	\\ ]iY3b@VofTP帯Z7]\\.#v-sdrz.8R&{GuJUxG4m	}V5|:h4*}bLf{+\rGH^6#^̯\'UtD/}K	Tȵ\Ztͣ Xj2w:{+U՞Rx<m>i!bb/q>;84:ddYLl=X]7Fti,(<ǝt*VFp3g\Zjb@*V*:\0ڑǄT\nx3cE+6QR7*C%oBQ0XމKSAJ	\0@0$\"R6GDܧc(iѺY }	Ғ  qZOL4Xvf?^19Q#u2 9jړ)ګ<|\nS%0S(XVMƏj\Z;V(沛QǩFX)i6\r\0U*}@:Ny2#{U\Z4\07D[Sk@<\0`貾R.LQMypU_jy)_0wAzCGReXvs]v;P\'\0xEk:v*NqExI;*Aܘit?I,\Z\r}\ZmME\n0ZVAP>e\ZtΗBaҠLnL!_rA&DaXJb~aJK8	5!.KOW>5RRb̴^:\r0	RK#5E:>WiSE՞mzT;F<>N\'(ZfqtkѥDӯE%	]J*Qp?`\'h#|hv9;t܁	e	Gr\r&\'fQ\0Yu-3ձ8Edg\0V1FK,V(L60]\0/upq6AQs0{@6\0[+uDN)ل[UDҤ$fZSu/5ۺô!u)	DZu37ǶM\\tP>PlX;[K[7>_qRK)qnBj30acVNwmN\'9wV<g[հu~͡ri({:0wYeI+FN/0|UU\\8a\\>kROvL%x$\"Ug|tZ2|<FJ\'=½[\rQUr	&P⫎,) Ual\0*\0i6-*Ek^eoǫo;a^c\'nw˫;\',tݵ@\Zga\rQufe`	jz}_NeCS.ܴ}x=j/dHr:n]w˓Sҵ\ZMD4|7ˎov!.Rꍱ-OkO[pcܑč\Zݻ2);T/!KeA1Z&qY`6mxϵiAb 7*҄\nғ|InL\'8R	Q7*V5C$PF{f1Z;!BpLo\\ _\'· SA\0D	ZF[h\\NF\n$GOB\0J ; A\09Jr1RD{%hdC_b]HRcTs\n/kaE&&ncyRm2\\0⹓l$.vO_PSY:z\"Fʞm<CcuI_\'GJݚd.%tW`ӵ\n7p\\Tp*6}+ʦqzgȷs\0.doQe&fAxr5ׂ}>ڕZml]RL}ԟocp7`-x9۽x4up\\Ze*t\Zj\\Fr,.p<^xmZaP]D7D@ȩYܿWЕἅx%p`ڏV]j}7\n:c䀹y̌pj$&o7ew51+r[0)Y\02V(ܘ1#aY6C$gxLlFBsU	Jh3bpa,\nt	ɽR(pe&:n}@TJw\Z~ZIG|sv{źš\0a\\s62\"OZI3ވA8ZٚB=㢳g@t¬9y,i	s>Ģzb?]Rۑփ1׶s<VΑcM}ݡn(PҫX⑫Ax{j6鱂/66$6]4x|_8\0]WڽiK_+SK|:ݎYP\"\\tQ,`߸4i(#S{1x \0AB<KTs@Ԩ1\0r텢[ݗ.\\MUI\n*rXj1nܯ.j/7?YQx6s=oj&ޟ(?r/mnkm*mܽ%Mnj:yA\0Z|!jj@S>#\\y/L)3YҪw֤|-X6hܼjLtezaQPsR扙ұ##oOVn4/E=dRO]ֹ~=zZ\r`WiLk4t1y:wW6.bJcGĬցTӛ^jo*V`@kgTtx%\\0S<{VOԭۊ\ZV9 ګ5m4\nz]R2M_!{qדEΐdBuVj)va9&\'\rtF@SD`ytJtx:owB<hGU|\0D,:cѸO)W\"U7	\0W@LNI|!\'\'3\\ك\0rl싻?3Ǿtpt4Qic3e{[mFµ1RV};`Rjt9Ķo)TN[Z9zN}ˀI\0}˩ȑ8s5~7!C$0\0\rQ<TqJz QwG\ZAh)VTsM#ƹj݉L{ړG,\\^d܎KgP~ޞgyJǏGDi່ib\"\\\\>;vܳx=Gr<Lof\\P+t\"%ՎʞHU&`´\\F\0S\04o	v*	JA#\n!wR7u1L4HٙQGT=J۱Q㧯4S8@t8:e(Q#܁AOz]BGސc=Pw e(XH=@O,Fn\0R[$xB9		S\0׎f\"%4M`$Q.f6{JAčWSwl%P$(@}PyQjAAjpxj45ЩSl[P-p+oOq?[ʜSlp_@p4KGy}Keww/#ŷKSJ=MRg纫\r6UwU5ZA[rk}J\Z~vV0mT5mxd^>(cIayOJf1^KVe\rQ$^gNB5K&Fzv.զKDd-/\"ZAvuo9.jS?\nJmGV\\K\Z*Hy,oL6]va>It&)^\'QA0Nl֧@V!ۢ$N@$%?BJ&e(2OD	q@ g !)d\r⤃\'Z=Bc-l?Nn{KZ	 L*eT;f)\ZF!douz5=^|Z<BІWeͱ6hZ1f}KX3XwLju{L;mVWYd⍱:v[-<67P\'2\n׭RK}iVY^`AuTu0e RԬpz8B7Et{aNڍ隍84@NRyFΎOǷY=X:s;[-\\ZO-]D]=΋Zz5>P&,:wx]hSr)$C%b3#<P]1^{\'Ե64:0%([,G/q=O5\00ڱT{oɺcxM\'GI]t$6_FQܒ[0%VgHЯLr={J.l	}q^c)qn~!v(i6ɣe&z	&\0H:\nă{e)l738bqnR9X7bm\rN֛\Z!KOb[Cs@MXqs/&1#pCS@cQ_NFkXTu*ה\Z[LV|9t\".,m\r[}mJW_P5.0Q-xF]\nrw\n/ϴ9ր4VXw6\n6zgQԧiBLِHGU<5G]\Zn`ߓCe-wc_#nqJPAl̦/&Z	A8A>\0$+B;ީuOu:5E#QDIg켙֩cF̸{yZ\02c\r)R|}W\r\"<;I7:@DrZLozz2;=_	qNZԧNjʀԦKg\"vX\r{Z0I\nݚE.LdlO~Y<GeIXO,^w4|dO\\Bl\\s[OԻ6NT0EJ-4^\\N$tV	WHʜdl.3*GAb&!ZR$z#u[h!cv\\4IO7Qp6UbSEhH0\07\nTCtNsR-pXN&\'d\n[*zR6HO\\zaШ;)N	\0(d BaOiL\0DR4n퓷NazE\\\"2;H(2#(qDer%vI@Qp;_X,\r!0&r<B6\0&HQ$d2}F}luZ7`mYx#o.0&ӶrAN7O9W)\ZAx{@r>WZ㝇ֽ,|5#=6<IWiV{v\r. AugկT\ngFT^9xnA\'X.ˇq!ZRTbhڇ;0+%hS1`⸠ڠ\01,͊],ԃ]͕ͻ-6*+:@yYς{:ދPC*:2v\0VWFʶz[<z)R7Yc)6O\nY]AllښD}h)4۪]\0J`pN	v(S@DFRaH1j\0ܢ(\nn4?;7(4쪟mYVbXǷcO*KHeSP4:s&T/&ժt&saa\'[i\Zak>|xZq<JzL3Ikq[TSj{	Ǝwsm~\rҏx^\nֵh*A]vAQֶ*QcyjO/iSmpx״wcֽϫk\r^>t\rWT}A;\\xRƨE,O },(\ZN֝\nLc\Zֈ\0-I+6k_6׷3U\'R;{R,t57xTX꧋?hIlTqvtǚh.NAgֳ#ɤYƗW\0Ok2qP.ͥG$V]j8xMN^d>Kipj{BPޢ\\Yg{VjY_Y2ܴ*קu!	J&QhNGDz\'\rdyx~$|W\'cIx9s/\0g]#JS,34(\\/R`9꟨hzE,R^ַnN\0Zcuqq\rFzF\\Yn)Q3Ʈ.8^Tn-k\\;\Z0Mlkq=wzUwtN@K=	)TGQ%2ЭeZ3P	\Z1y67w-ה~hp\0:\\v\0B8VJ/{x%s\r1}xV~3iW?Kbupk ʺVD3>ڂq>]ziJ,&9{YyL-rPxcaJç׽WPV^1״_HR޵&\rHХ:ه1۾hP<}KGcwl)9܇3;x.`B>D\0M3	HA*Sם\Z{ᔁ4ZyRpZrM![Q\ZmMI\Zkg_@ȶ}e:q?\\^x\\|[fnB?\0ī\"?Nԭ$\\uVt䌘UqY&<{,sh&dHܢ;Ԡb}н|DqH2d+)\n$\0tR`r}Yध])r\'dT9F,6):G R4DQϵ)ެ5I;%A+[R:aD ʕN6ɉCyIɶ0aSД7^Ff6ʝd)r	\r1ykIrar\\Dx&s u;!\n\ZѮBͦmB޼kYnねmFX\'WOqg/i\\g2i5U\ZLr{*U~kUkٛe3C3餁VTg+	Fqؤա\r26zAsGh7Yj*6Wpo1¨טtȎqwv26YjNR 7TޛXy6Tӏ*}<fs3Oh)D9)큔ΰʲ!7l\'\rp=NKܚ7@#aU\0x	BlᲷ`8x#4\0V	IRR5xMo)\nx ʋIoH?Lk)&{\Zwjd	O+7QeRԷ!F +W:4>!ZѬL|JZxOio=^i]Kƙixf?..~P8Ozce=VH6:p!d=!kSYco?z!S2J1ߨUt2KO7m\0;FNB(\ZӨT$\0us/H.Nxݷ&I+mF}AJjU`6ꋩI\noʴo-F1=\'=[!&<U`ytzm8Tlcj:DǓpM~ۋ4yW2Z\\i}p\'Ls8Z\"\Z=mJC	/u٥|5K=_ը~J.^ޥF,kHZd(C8^uoRo-DSdigjNj|c^ЉOAiS2YQ t4^(na,$izL믶Zx+q?0W|W-k΂NjQe}H_閆Ws>ϙEwlV8MiO\\NZQpGKSF0VFE)IeEY|õ}g[Tq^n<\\<-z${VVR7zF:E}3*3gikz\r\'ٺhz-SV]ݥ6Sw{<QS59~{Mf7U^(	Y$4\Z\rn>qsZfZu겳BiQt\0kZ!wBԾm5A\\r5JZ;D\ZowXeѤ&r߉V /e\r괊ymMj龥GrvwTqj?6Q?7Z=\"ƭZ5i\"#fD;R!ŅQp|:zͬOk:2*_QˊMyIǦ\0V2ۢɮÔu=>7-PrSpi㳴\0>8ct}e#.&Bi*3IiJ\01t*dOC\\\0>Q[׸.HDepoz\0wTXA[4Nw#Q윉\\EzbL<OP8W#`Un$\07WhmyLr7Uփ\0x+\Zp؅$m	ʌxlS\neCmNM`$x\'dQ$xzTdB`E)DςY|)\rA>ԇoTUGzCt46H`fSHpFS	P=)IcH\0	%<Cxgw5!\r)A9ӪIdsnc\'os4дA/<`)] Jje:̘vUIVC7xY꧚\'UwncUltOaelbzfP\n8*h]eU<ƶX-Eke\r;VT*>H#iV̧M5wBHomr\'Tu [^=du\Zug0$eYEhϐH	NdSH\0kּwVbF4z)1XO%Fr&O֍OTv bL)Z;r#\n!<r8(ɝTM2:))58(XNXr&ȍlPSɜĄ?P	M	BCDQ*@QAMi%(;Ʀu\"s)Nm20>ӭDsYsh׆vGPsik$wo[\rQv:<q\0JR-I^&Q0\\Y}J5ƲJ->3uT;`fy4him\\w)۽.wsr	]n\\hO%Kpz3UZ-\r\0Ȩ`A01Էs\nI\"}x&Ð/{.q˧WĦ+w6]DX;q;y\\5M;Sa67k#ԲTzVC6S{\n`Ug\0\rsjMh_s.4rA8Dx锚+UJOi>)}PԞusP\r>e\ZMh\'\\ؠ\ZUoZ*̞*_a=*@oX9:ێQpfY,o.sNϱ%R.Ю\Z$#+%nsV^~s[V6/k\rw\'U2y0Dߪɧay}kڛt)m)iV9{;x*[nu*xkcG\'.=sNY-0ҸRq;ԃWua?MXkEvQԜ6,tBwFj쁐ʇ.v0$:jԤGJ,dU?54]wѽ`1<DU;v4\r21߱C,x՚3R&+۪U)>hoØ HJ|U_kEٮO_[TXdlrMu7Jbʂ nǏf2aIꏵ4RGY\nQ;nS@ktuY\'\"eӀ\n{>Lk~ɼwO\0*03p㋾RFUxt~+>%[K1=p!	ZY:w5ߠj+/Kwp릎֠\0#`-a9:J$r\\3+7Zk\\эWR 1עFbTbL{($\\h;ʞ7r|05?18YҺ\r+2\0cpzQyf!\Z@?9ޓ+@#\'7E\'`z%pSq	&bHت$A+QXLl?%Ak1׾~B\ZbU\'Q(IM\0(*CRsi3i{*	33\'Ec\0TdbS	͙p\0hg\n@$3K\' \0FI9@27Cbd0J(Y>!M$eUG620F;ׂq^g	&}T(V]&=+xk4C3L\0.~SP1;Fo!}z\Zw3\0E.hU./i\nYQt8:FW-̞\'VzqQ\\h=)ɥVwEɓTZY\'?ԧd{-DvY\05*w/-=\0i1䴼ӀIz0*\Zm\0z莠N\'GҦN\n: g+\n9X\n@c0m,G<2d	]h{vR	[Ni퓚zT*FJRH)1CD00JoT4\"	aM8a;zk|RRA1:=џeԪzakdI=%X\"?SbM}8lIH]%/!a߭,.@p\0J=.m2cjA*=\"7Tu\'|QZk`[m5nu6E74CVjӦ[5v\rZ7t7x\ZOGa{$8w\\ڞc-@Ϲ{t.\Z:\0T-:_qw:48s\0@Y)#oN<KY.]b?/(6[8-#Ⳓf_r%8l1J/tZmť6ă$5lѴ\rB_MYpޙ{M̫l2#\n٧FJ	VeܳSar~º:tRc+4h{	ciR215[*e\nfֺ=+r{j\r>#ט\";J\'tr\\W6Tj)H:\'\0fJdz	EUi\r?D2Dn$fr5;WJ\r%Zb2>N5Kun_ZΠ\\w->Ŷ0eU\\7CgOlp]IzΛH\0	[]zu1n=)4wSj<:[xKC}Dѭ(ph̎~Os\\N-~vkӭMF@#	BH;{Ցfg\r?zVsAӯGߎa[X%U	yz/쎋Ñsr3U0wFZ7\nصLq!$\0T޹ZIwG~T&NQ)\n\'9k=;D%hi1wWGfbƧL;ra?WH\0;[GF.䭞G2/u\n+ =ɚ;>=E?Wpz)>P&!QX0_iӯU`d$j$\'}\\&;)&7^K[*P@QYRl\0+%dI8HQ887 +hLح\\}OY!bs	[B#(9±pǽ4(\0	v@\"6Lx`H뿂{qԔƁ˂	*[>~o;_H;9|XDLBߋ\\kHr{\"Ǽt^-7O4^Nyy ezyّ*4M@CQ\0)ٴ̫jp	*c7Z+%V,Uv͆ɳLum~JJh5cf1Y-ig\nd\0W4ΔLv^7Reo=L9vW܀AkٔJ3%{(lʯv7VbwlH0gAOxS7Z%Fr¥aҡl 2c%HeD=#udVA>)8V)s0L<J9)\'KT;\01⚖D%\'P`ҏLY)Х2(qd~)0wɞ?\\euqٟ~?&HpYsf˔Y1%\ZՇEloZѧs^+lIA]H`\ZEG(Fq4Oԫi8\0u7E-Ņi\nV:icSei(.(۱\\NmG18aq^܍*!.zdحom.UBj>xVW\r W@\0-8[=pe$N-\\\\%BJ5@@J\Z厕qJnm*E`lJ[\'vyln^ZӺڴj	kPC=ҥrQ\Z\rc *N6+r\0㏭C.]Lmdq<Gb\"v7\Zur#-BV0Tn]\\Qh4x8A#=Z |;5z\"V*N=ƀ0s:rnJlSI-\\ɣCvϝM{Ii3\0TU_w5^T>q&ȝeѵѠmO\'4m;VVW4$≜w/_.068<R`#>`pouE).	rF7M3\"FΌ8.c|;{Sم[f#kAʠw.R}xz.V?\rivg:_xWB_f8℀(1%\\I=sJH9BdJb}8c*7WLI=`?6ڻ|lK<+g?\ZU$\nuv>r=G(tɛZ\"zGg+UoL1ܣ]FV*y3-:F;kOZnDKMVy]e7XҘ\0.K6HDtHatJpe\03gb\0@T=HGI1G5ZN|D-b:D)lLo(it6\0)Iĩ})&0}(~GIH&1tB\000b䑁\"ǃn$A9EMʗ^\'x`c+ODfvyV\nMkg\ZpY؀OYPi`E33ܩ;%;gI;l9yO[è\r`J_D&7yuJaU0缟zf6Zb4;$\ni8!g]MB\0Y>KZ&0$bzXOT3=7e{hT؈VʒI/MLau3Lt*D*+ZmUBcܴ}E553˅;\\ʕ\rRAT-0~	=\n7h	D̨s)zԦA#I\0=* qSbǊsN2\0{vR#,n(iD$o8) spJA)d!BnZLbGIgڝjo)bGM\'\ZoY,9li\r*U]uV*]ޤj6ť`ƐDezqR0All;ꋀ.*\\lԵe\'Si?XtZƥR}J}3Wsr5qE:H*-\\~yXANT#DV9ZGyu>fzxZ⹶VSs]-zU\"=kZG4Qs*6|8@3t.3`CVGl&c>-+qA3u[V׍(sQiqZ4eB}u*V-Fѹa\0r\0e#5+/^]Vu5\nƍ:rm>\nYV4ZP;Zd+[HTk\'y*>7\'~VZE8ӯZ]NΝjj#V׌C\n:-\Zi\Z)w\\\0+.NǊev׸\0U\\t{M9$>h^}_A5R]}dʏ^GeA:}z-޼T;^<IRlrP9a\rkn5gM]#h\0@דf7߃><::5hz͖h90.q\nˌz]\n-ZX𾛩܍[R۾{+zn>kaL8LodBէs<%M;ZsBTiGXMX\0&ؚukJ꺅Bvʷ)璵mٷ,wAl>S(kg_Z<z8Rs	>3G~W\Z_跜E\ry=YMY\"_*w֚c\rf0Ho8G6=LVnQչ mZTk?j9z\n5s*5\'gTrUv|;x](!!a&0r$ \0jt\0P]waTu1\028!?i?q\'͡TKh2\\Ӈ⯕ˉ$[TC\Z`^~v7´Z`߲H?y=jS$.t˂@N\0d0\'lg\\	̝堒Ϝ!K@9\nL\"`A^n/`%{e$$)\'%\'@˧fh#&\"fvR\'iQS\0Z5Fn4H3uE?jA$BPvD+@;\0x)a|p.0K3!KH̞1]HeP li D!C\'6w\'>+DQ4LF`39-撙P\\Itf.\rΚi\0d·SwU64{d=WKN=iI1a8;(+w5+o(k==E{A\0.++[f[[m[6\\JhmGWx	ʨX^Megҳw^# )@q;z[|mC2.֦ꡮhfҮޅqfYZ\0p>\nδD٢q^L*vFkeGB0jVdPc*QfT-)1*Ҟ0qR8<lmx#8j6)zn!(K\"\04o88lzB8s)A>(R &7DS qȅ೺}˘Gqdgjj^m\nӸOV&XQT$/M[eY%axXy}grx*jK\ZǥbX2UQQI9H`;Uͣ[7^[]fG-VQn5L5VΨ˪:i_йV&%|xVeV-r9\'FUrejNeF5=Vd5eFj7:ՅfiԢf	lt@o}B*}~ٕwk\Z\0YsiT\0*df1\\\0W󋴫\r@i-i\0&ޣ>q s<\':F֝:rLN䞥e\Z&ɜHx\\mܳkCmRv*\0>ڥN|Ii>P+I.ъwLxcq;\rj\nuZ|곍?๭ˌjx4k:]{C֥/=Wv|Ak\Zwn[֓aYN2H9\">%DЯr;7G\rl<%[z柢2n8>c$4e6\0<!\\W\rn\ro6E6wzϏ^F٬txڣ:kuqZ{Mz`զՅPO,.G`FY[tr]WT)7+9Fu\Zf,v=4;()Kn7C1\nEרY5+ު$JșϢ7A>X/&-J:׮6x\0GնjsQt@i/}:-e\nT`khйs&K:15v_xҙQҽ`XPө\0))+X&|Zj}6\'8\ni?\r\'x+y;m\'0Gt.SH+fຎ}Wn*壚q-{ztK_הYN[=>nQ.7a6X$+M(i*7:?VX>UÄ!rw-\")6/LAv&ӕ\"{	3(}#0!$PwPv\nCP0qnkPy\0Z8.<jﶌm<tA4l)\0$|盛3+ճ	80(Ёy\'2>$up$.{DGtD>HEl\0\0䞫ւ%`7D-K1WWČ9\'֤\"r0<S˿Umn73ܤ&4\"Jh߯1NO*䥋F&e)H\0z\Zb=iБzPDLdc1(>\nF@*!<J݈l{@ۿt3ENA>=ghP}RH$ntJf&LǊ}G=*Mw$	*\\l&ю%MZ!\'fӒ2+*Ơ.Vu)gs.N4H6A;7K^[M;ayVĥ./yw2\'܈DM.Ɖqܙ.x\n\04};̭rHY}c+\0sl-f<2;HY!YQ4wxL+n\Zrv\Z[5\n	s$Gk,?7ZתK,i\Z;WT0G|^\\I|ro$	qtnq]Bmzl{Hp#_,2a;V7\Z]4rfmʤ*ʛ\r.s#۳T3	S1$ Cx+@r$\0z@qIvSld=GrQQ2\Z2L IzuKB\0zp]	; x3zSny\"/~ݴST|P(xN?AŭOm6oŬ {_锫՟JT4cܬ\\T\"\n\'a^2\'|VSfZю(Sv]V1Wtu~جç[,*K\r7\Z˛j\Ziν18Ohn0mf4\0WwuѬA.Ove5g7pY:*RwBwH.ibqXGi.\"צĸJ-GT}qy賖7Z5]y=hl^eIs`0<ʃ}:ǰs;7$	)Ө*11M(ѩY7u&YWp|E=>hu:tZgL:_\\/~Bd|WhːOqL\'ڥΛV6uM8k$.@ͥIp \0[;}?D3cjqW:QjE2b05!	\0{\ZL,H6{Z^6E:n\'?TI YWY\ZX\\W\"uZ\r%nxX\ZNYU`sǖcNk|7Ãmof>p>|PQԬiw?xv]\0*TtoJ5;V\\i,$\"wɪt[4ýIÿҼwRҝznH`͝/O)EldIJ0ZٌCtnVޅGݤp~G\0X_+4`uЫ<,@\0W\'66GmT*pI8T1)·x}Y}mrȌ+@B		>&{gpT\0;I(/ޕIT/>ClkaNCw5 yrlOU<5L5yo>Hm\'oJ\'-*kU!crce%er=2zc^;\0LWjI\nNFL*]ڂ@^@HB7+	#hR@\'!($IƜB|#U.GHQF=R2\0[BH7Jp	v[-d؄9(([nU+J`&Ǜ%MQ7`8à2`Tб&`Js740=i	AB(	:u>dcxei[81\05`=<[\\Lz|]\0h 3I5Gbv$VB\"ꛃ@\r)Q9^~`&@}V:LfϜ\'в\\{β+:{HsE^Ӱ]\rＺY9́K9%migҩ֪G9$}w	\0sbDl$&`/e$8t_Wis\0-;*KB\'uu&8\'%L0La(s\\9䏎A#]EWo޺)8t\0s}Mq}\'i\'[:DJ+wruAlݪ-izOr?jN0\'+p;\r#;a84%l4(x8D;<GrHv908ޔ@$PM	gДzQ9	IB_AK׹MF##;A#B:sct9+\Z:a)^1Y(VooCs{WI_8Q<_Kػ%+FU?حޔΟ\0sk\\	01\'5U:YlH\\8Z/\ruӪװ8AIKGcQl:[Q\ru*F*3.\nChP.VrhJ}K<U)l\"}n1ߕ=3q.ZGmkń$Vwg	\r{\'Uik\\ֵV-`*)6sA-+fND[m\n܎`+n4\\ꏍUlDy9I\0i_jnW(0@?l[W<7FAY£]:FܖwgRh$++K=*c==t6X9	sNgҤ=ǤNc,|8濫з>PO 87!Ews{Z=sg\Z5GBmp}z5J\Z(cQ-)ЯI)c*Su7n2I*̦#=rR+QkqdG#+X5();Mmq&^:kT3&-N?at\Z/nzͦN	8*])z0`;9>\\q|T-aGf}>kt0䍏J\\*m\Z Rp;`\0ncڨ&jz]ٸ5Ggq\rW`]8fco(;\"|NIG0GI\'Kh|\ni)Pp\rY?^^bkJ9Q.9g3ͯqF\0|2S97HoFtv4{ם^Cqd{/.oSS\n]LL%H|أm#!zHd+;U:.<0aRRc{\\4+$H^Ka^ƑvlchA˷)pF6@g&a@  HgE#D-b)\'{	NZ]ܘ\0!FVfm|6x\0ǊpnEtKw<t0IJw\Z4hGsO7sg<9K]Bop0&p\0U#IXc8==	Қ)R$de^ В9\0_EԿ;\"\0d0@e|UdޗNhe75?_GJݫþc}/Գ<u;hiO>|:LS\0a}?S\0ALR Ozl>Qz(6݆MCQ/$Lm}V\0G/̼:&䙟G&W+Gǚr06;\'\0b\0sa7\0a~\00:RF:-lQSaXh\0o~1?z\'\ZgSmy9?Yg%m[U^kWʎz~gc\0SKl`ʳWzL/&#t\0\0)QK_玟1G\0(E8J31iuÃ`SZ\rby[@u\\|O\0QrOSF8C<_)[}~gkD93R%\0柦<G驦.\':aԀt?M(a柦Z9]Nkˠ9\054kcfry4\0=ki[]\0f55$9#\0PɕM\0\0+iC9ջm\0?Q665#QJ_џ۟ͿM/wxp2#疎f溝j$8m޺޳ssGCyy~C7ȋAga˦Vٯ\\uWUjVeZO\0C\0*u*Ե*um!oTq<p jEuHSUOJ5Z]郍rRN.I]jڣuYQp8F۱Qo͟{USG_hlxkcS6c\\Em\ZϢUMH\0ԭOl,|QE$<:CKaz/]\\_<aZܲm:mI$vtG+D5/k\ZDLtX*$j0@\09w;=\ZeQJ;U|S+So@\0	8,l^JjSd\Zښ3N7SZ}ױls|9\'n5JWX?XMX4pz奍ݍB;YatUE&2~@.<~iiZ柦f~Ws>C.V\0O^\rκ{>;b7yݠU|	.XclcBpt:Kn\\\Zg/,)ZO$hL|1\0,ak#miy`3wh۝Rʵ*wP %mXjeѭV*dW`ԼiTTqʮo6Ӻ}1XPk4\0L&NI>Fo\035=2N< 8J5iyO6{ H3owh7~_kTo/3;.lrI>k64ճ-]TR	t/U\nŕA봭Jw7n[g+mۦb{YkWq@6Hvqi(kTiB	ki4 :0ˮ:rG7H\0V<Vxxŧ4q0ܥqkQK]*q0<l \0)_髨^H>oAkHy7NKv~2O*=xR~m1>BZe+Z\\OSo\06|$5ś]qMJÝG{]]Ykuké;ӍivO\0X$OG:O!\0)XgٕRlҨ\":BRR?\0z(yŅ6-Tr.QOs|<\0}Q\0m.#?VX߂=y9p$C]CAHۗɓj7].<A6dյK#3DɢVh_\'>HH{5\0=B݇Mnԟ9#+@<A\0	1qH\Z6qYܚmg8zSup[戕د<WPwwSc=gėDU@RFύ.\r\n_;Q1oC\'f\0?\0z,\0T#uz>D1t\0R#ē\0ASL^NO&%+H<qĿ\0h3#?1W\\qW\');Ԣ9]Hy3cx<c#Ekcrу=$PKӇ2?\0ȿMiOW%8Ht\0֓0giG8\0(?35w}Uvr3 \0s]@y$?I\034gaӪPY]@&$\0xci0@hO61{!Ǌ鿭`ӿZgGCx!#hԜ L.;\04DgjԼyٝ1B8B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B !B\0B ?','FAILED',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PENDING',NULL,NULL,NULL,'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36',NULL,'2026-03-11 00:31:22.419','2026-03-11 00:31:25.074');
/*!40000 ALTER TABLE `beverage_scans` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

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

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

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

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

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

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

DROP TABLE IF EXISTS `not_found_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `not_found_logs` (
  `id` varchar(191) NOT NULL,
  `path` varchar(191) NOT NULL,
  `referrer` varchar(191) DEFAULT NULL,
  `userId` varchar(191) DEFAULT NULL,
  `userAgent` text DEFAULT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT current_timestamp(3),
  PRIMARY KEY (`id`),
  KEY `not_found_logs_createdAt_idx` (`createdAt`),
  KEY `not_found_logs_path_idx` (`path`),
  KEY `not_found_logs_userId_fkey` (`userId`),
  CONSTRAINT `not_found_logs_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

LOCK TABLES `wines` WRITE;
/*!40000 ALTER TABLE `wines` DISABLE KEYS */;
/*!40000 ALTER TABLE `wines` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2026-03-11 13:24:43
