File: /var/www/mealplan.rtfmfm.com/public/mealplan.sql
-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)
--
-- Host: localhost Database: mealPlan
-- ------------------------------------------------------
-- Server version 8.0.43-0ubuntu0.24.04.2
/*!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 */;
/*!50503 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 `cache`
--
DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
`key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` int NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cache`
--
LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
INSERT INTO `cache` VALUES ('meal-plan-calculator-cache-akrozia@akrozia.org|78.83.204.119','i:1;',1758737459),('meal-plan-calculator-cache-akrozia@akrozia.org|78.83.204.119:timer','i:1758737459;',1758737459);
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `cache_locks`
--
DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
`key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`owner` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`expiration` int NOT NULL,
PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `cache_locks`
--
LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `daily_menus`
--
DROP TABLE IF EXISTS `daily_menus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `daily_menus` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned NOT NULL,
`day_type_id` bigint unsigned NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`menu_date` date NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `daily_menus_user_id_foreign` (`user_id`),
KEY `daily_menus_day_type_id_foreign` (`day_type_id`),
CONSTRAINT `daily_menus_day_type_id_foreign` FOREIGN KEY (`day_type_id`) REFERENCES `day_types` (`id`) ON DELETE CASCADE,
CONSTRAINT `daily_menus_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `daily_menus`
--
LOCK TABLES `daily_menus` WRITE;
/*!40000 ALTER TABLE `daily_menus` DISABLE KEYS */;
INSERT INTO `daily_menus` VALUES (3,2,10,'Ден с бягане','2025-09-23','2025-09-22 16:02:11','2025-09-24 07:47:52'),(4,1,1,'Test Menu','2025-09-23','2025-09-23 06:07:14','2025-09-23 06:07:14'),(7,2,9,'Почивен ден','2025-09-24','2025-09-23 16:40:33','2025-09-24 08:31:22'),(8,2,12,'Преди състезание 1','2025-09-25','2025-09-23 17:57:10','2025-09-24 16:25:14');
/*!40000 ALTER TABLE `daily_menus` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `day_types`
--
DROP TABLE IF EXISTS `day_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `day_types` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`target_calories` int NOT NULL,
`target_carbs` decimal(8,2) NOT NULL,
`target_fat` decimal(8,2) NOT NULL,
`target_protein` decimal(8,2) NOT NULL,
`target_fiber` decimal(8,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `day_types_user_id_foreign` (`user_id`),
CONSTRAINT `day_types_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `day_types`
--
LOCK TABLES `day_types` WRITE;
/*!40000 ALTER TABLE `day_types` DISABLE KEYS */;
INSERT INTO `day_types` VALUES (1,1,'Maintenance',2200,250.00,80.00,150.00,25.00,'2025-09-22 13:47:48','2025-09-22 13:47:48'),(2,1,'Cutting',1800,150.00,60.00,140.00,20.00,'2025-09-22 13:47:48','2025-09-22 13:47:48'),(3,1,'Maintenance',2200,250.00,80.00,150.00,25.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(4,1,'Cutting',1800,150.00,60.00,140.00,20.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(5,1,'Maintenance',2200,250.00,80.00,150.00,25.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(6,1,'Cutting',1800,150.00,60.00,140.00,20.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(7,1,'Maintenance',2200,250.00,80.00,150.00,25.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(8,1,'Cutting',1800,150.00,60.00,140.00,20.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(9,2,'Почивен ден',2100,190.00,62.50,150.00,30.00,'2025-09-22 14:04:03','2025-09-22 14:04:03'),(10,2,'Ден с бягане',2250,290.00,62.50,150.00,25.00,'2025-09-22 14:08:57','2025-09-22 16:01:35'),(12,2,'Преди състезание',4600,750.00,80.00,220.00,50.00,'2025-09-24 16:05:03','2025-09-24 16:11:34');
/*!40000 ALTER TABLE `day_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `failed_jobs`
--
DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `failed_jobs`
--
LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `job_batches`
--
DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`total_jobs` int NOT NULL,
`pending_jobs` int NOT NULL,
`failed_jobs` int NOT NULL,
`failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`cancelled_at` int DEFAULT NULL,
`created_at` int NOT NULL,
`finished_at` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `job_batches`
--
LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jobs`
--
DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`attempts` tinyint unsigned NOT NULL,
`reserved_at` int unsigned DEFAULT NULL,
`available_at` int unsigned NOT NULL,
`created_at` int unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jobs`
--
LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `meal_types`
--
DROP TABLE IF EXISTS `meal_types`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `meal_types` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`day_type_id` bigint unsigned NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`calorie_percentage` decimal(5,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `meal_types_day_type_id_foreign` (`day_type_id`),
CONSTRAINT `meal_types_day_type_id_foreign` FOREIGN KEY (`day_type_id`) REFERENCES `day_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `meal_types`
--
LOCK TABLES `meal_types` WRITE;
/*!40000 ALTER TABLE `meal_types` DISABLE KEYS */;
INSERT INTO `meal_types` VALUES (1,3,'Breakfast',25.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(2,3,'Lunch',35.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(3,3,'Dinner',30.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(4,3,'Snack',10.00,'2025-09-22 13:48:21','2025-09-22 13:48:21'),(5,5,'Breakfast',25.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(6,5,'Lunch',35.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(7,5,'Dinner',30.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(8,5,'Snack',10.00,'2025-09-22 13:48:51','2025-09-22 13:48:51'),(9,7,'Breakfast',25.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(10,7,'Lunch',35.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(11,7,'Dinner',30.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(12,7,'Snack',10.00,'2025-09-22 13:49:33','2025-09-22 13:49:33'),(13,9,'Закуска',20.00,'2025-09-22 14:40:45','2025-09-22 14:40:45'),(14,9,'Снак 1',15.00,'2025-09-22 14:42:12','2025-09-22 14:42:12'),(15,9,'Обяд',30.00,'2025-09-22 14:42:34','2025-09-22 14:42:34'),(16,9,'Снак 2',15.00,'2025-09-22 14:44:24','2025-09-22 14:44:24'),(17,9,'Вечеря',20.00,'2025-09-22 14:44:47','2025-09-22 14:44:47'),(18,10,'Закуска',20.00,'2025-09-22 15:55:50','2025-09-22 16:00:21'),(19,10,'Снак 1',15.00,'2025-09-22 15:56:12','2025-09-22 15:56:12'),(20,10,'Обяд',30.00,'2025-09-22 15:56:28','2025-09-22 16:00:32'),(21,10,'Снак 2',15.00,'2025-09-22 15:56:42','2025-09-22 15:56:42'),(22,10,'Вечеря',20.00,'2025-09-22 15:57:34','2025-09-22 15:57:34'),(23,12,'Закуска',20.00,'2025-09-24 16:16:06','2025-09-24 16:16:06');
/*!40000 ALTER TABLE `meal_types` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `menu_items`
--
DROP TABLE IF EXISTS `menu_items`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menu_items` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`daily_menu_id` bigint unsigned NOT NULL,
`meal_type_id` bigint unsigned NOT NULL,
`user_product_id` bigint unsigned NOT NULL,
`quantity` decimal(8,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
`total_calories` decimal(8,2) NOT NULL DEFAULT '0.00',
`total_protein` decimal(8,2) NOT NULL DEFAULT '0.00',
`total_carbs` decimal(8,2) NOT NULL DEFAULT '0.00',
`total_fat` decimal(8,2) NOT NULL DEFAULT '0.00',
`total_fiber` decimal(8,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`),
KEY `menu_items_daily_menu_id_foreign` (`daily_menu_id`),
KEY `menu_items_meal_type_id_foreign` (`meal_type_id`),
KEY `menu_items_user_product_id_foreign` (`user_product_id`),
CONSTRAINT `menu_items_daily_menu_id_foreign` FOREIGN KEY (`daily_menu_id`) REFERENCES `daily_menus` (`id`) ON DELETE CASCADE,
CONSTRAINT `menu_items_meal_type_id_foreign` FOREIGN KEY (`meal_type_id`) REFERENCES `meal_types` (`id`) ON DELETE CASCADE,
CONSTRAINT `menu_items_user_product_id_foreign` FOREIGN KEY (`user_product_id`) REFERENCES `user_products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `menu_items`
--
LOCK TABLES `menu_items` WRITE;
/*!40000 ALTER TABLE `menu_items` DISABLE KEYS */;
INSERT INTO `menu_items` VALUES (1,4,1,2,100.00,'2025-09-23 06:07:57','2025-09-23 06:07:57',0.00,0.00,0.00,0.00,0.00),(2,3,18,70,40.00,'2025-09-23 09:05:02','2025-09-23 09:07:14',155.60,6.80,26.40,2.80,4.00),(3,3,18,144,200.00,'2025-09-23 09:47:10','2025-09-23 09:47:10',46.00,1.00,4.80,2.40,0.00),(4,3,18,145,10.00,'2025-09-23 09:47:21','2025-09-23 09:47:21',66.00,2.90,1.50,5.30,0.00),(5,3,18,146,20.00,'2025-09-23 09:47:31','2025-09-23 09:47:31',79.20,14.00,11.00,1.70,0.00),(6,3,18,100,130.00,'2025-09-23 09:47:39','2025-09-23 09:47:39',115.70,1.43,29.90,0.39,3.38),(7,3,19,99,200.00,'2025-09-23 09:48:01','2025-09-23 09:48:01',104.00,0.60,28.00,0.40,4.80),(8,3,19,120,20.00,'2025-09-23 09:48:10','2025-09-23 09:48:10',115.80,4.20,4.40,10.00,2.40),(9,3,20,147,100.00,'2025-09-23 09:49:24','2025-09-23 09:49:24',378.00,89.00,76.00,3.30,0.00),(10,3,20,34,200.00,'2025-09-23 09:49:34','2025-09-23 09:49:34',270.00,58.00,0.00,2.00,0.00),(11,3,20,83,200.00,'2025-09-23 09:49:42','2025-09-23 09:49:42',30.00,1.40,7.20,0.20,1.00),(14,3,21,148,50.00,'2025-09-23 09:51:48','2025-09-23 09:51:48',197.00,4.20,39.20,2.20,0.00),(15,3,22,30,150.00,'2025-09-23 09:52:26','2025-09-23 09:53:24',363.00,40.50,0.00,21.00,0.00),(16,3,22,79,100.00,'2025-09-23 09:52:34','2025-09-23 09:52:34',77.00,2.00,17.00,0.10,3.00),(17,3,21,135,50.00,'2025-09-23 10:45:00','2025-09-23 10:46:28',152.00,0.15,41.00,0.00,0.10),(21,7,15,30,150.00,'2025-09-23 16:41:21','2025-09-23 16:43:17',363.00,40.50,0.00,21.00,0.00),(22,7,15,79,300.00,'2025-09-23 16:41:41','2025-09-23 16:43:08',231.00,6.00,51.00,0.30,9.00),(23,7,14,99,165.00,'2025-09-23 16:49:41','2025-09-23 16:56:12',85.80,0.50,23.10,0.33,3.96),(24,7,14,120,20.00,'2025-09-23 16:49:50','2025-09-23 16:49:50',115.80,4.20,4.40,10.00,2.40),(26,7,13,144,200.00,'2025-09-23 16:50:46','2025-09-23 16:50:46',46.00,1.00,4.80,2.40,0.00),(28,7,13,146,20.00,'2025-09-23 16:51:10','2025-09-23 16:51:56',79.20,14.00,11.00,1.70,0.00),(29,7,13,100,150.00,'2025-09-23 16:51:23','2025-09-24 02:42:04',133.50,1.65,34.50,0.45,3.90),(31,7,16,135,20.00,'2025-09-23 16:52:26','2025-09-24 13:58:57',60.80,0.06,16.40,0.00,0.04),(33,7,17,28,300.00,'2025-09-23 16:58:19','2025-09-23 16:58:30',627.00,78.00,0.00,30.00,0.00),(34,7,17,83,200.00,'2025-09-23 16:58:53','2025-09-23 16:58:53',30.00,1.40,7.20,0.20,1.00),(39,8,18,100,130.00,'2025-09-23 17:57:10','2025-09-23 17:57:10',115.70,1.43,29.90,0.39,3.38),(41,8,19,120,20.00,'2025-09-23 17:57:10','2025-09-23 17:57:10',115.80,4.20,4.40,10.00,2.40),(50,7,16,148,20.00,'2025-09-24 12:10:29','2025-09-24 12:10:29',78.80,1.68,15.68,0.88,0.00),(51,8,18,5,90.00,'2025-09-24 15:49:46','2025-09-24 15:49:46',226.80,10.80,38.70,3.60,5.40),(52,8,18,144,200.00,'2025-09-24 15:53:08','2025-09-24 15:53:08',46.00,1.00,4.80,2.40,0.00),(53,8,18,146,25.00,'2025-09-24 15:53:31','2025-09-24 15:53:31',99.00,17.50,13.75,2.13,0.00),(54,8,19,101,300.00,'2025-09-24 15:55:17','2025-09-24 15:55:17',141.00,2.70,36.00,0.30,7.20),(56,8,20,28,200.00,'2025-09-24 15:56:44','2025-09-24 15:56:44',418.00,52.00,0.00,20.00,0.00),(57,8,21,5,90.00,'2025-09-24 15:58:44','2025-09-24 15:58:44',226.80,10.80,38.70,3.60,5.40),(58,8,21,145,40.00,'2025-09-24 15:59:04','2025-09-24 15:59:04',264.00,11.60,6.00,21.20,0.00),(59,8,22,149,400.00,'2025-09-24 16:00:25','2025-09-24 16:00:25',1436.00,52.00,284.00,8.00,12.00),(60,8,20,149,400.00,'2025-09-24 16:00:46','2025-09-24 16:00:46',1436.00,52.00,284.00,8.00,12.00),(61,8,22,82,200.00,'2025-09-24 16:02:04','2025-09-24 16:02:04',36.00,1.80,7.80,0.40,2.40);
/*!40000 ALTER TABLE `menu_items` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `migrations`
--
DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`batch` int NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `migrations`
--
LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_09_22_141917_create_day_types_table',1),(5,'2025_09_22_141944_create_meal_types_table',1),(6,'2025_09_22_142041_create_product_categories_table',1),(7,'2025_09_22_142101_create_products_table',1),(8,'2025_09_22_142131_create_daily_menus_table',1),(9,'2025_09_22_142149_create_menu_items_table',1),(10,'2025_09_22_175110_add_nutritional_totals_to_menu_items_table',2),(11,'2025_09_23_075738_create_user_product_categories_table',3),(12,'2025_09_23_075753_create_user_products_table',3),(13,'2025_09_23_085311_update_menu_items_to_use_user_products_table',4),(14,'2025_09_23_090302_drop_old_product_tables',5);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `password_reset_tokens`
--
DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `password_reset_tokens`
--
LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `sessions`
--
DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`user_id` bigint unsigned DEFAULT NULL,
`ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
`payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`last_activity` int NOT NULL,
PRIMARY KEY (`id`),
KEY `sessions_user_id_index` (`user_id`),
KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `sessions`
--
LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('66e3KjE7huqhG8vJlSTFP1OarqpMpI2yae8tGkut',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidjg5ZlhTSmFJWnhmbjNYaXdycFpDVUE2eGlZbUFSUVBKc01Idm93NyI7czo2OiJsb2NhbGUiO3M6MjoiYmciO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjEwNDoiaHR0cDovLzEyNy4wLjAuMTo4MDAxL2xvY2FsZS9iZz9pZD0zNzNkMzY2My04Zjk4LTRhMDctOTY4YS1jYjA4ODkxODA3YzkmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjE4NDk0MzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758621849),('8luP164g1KEtRDvOEfXeJ51brwD8vCFUVfxWyQJu',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZ1puZ2l4NDhoelZWdW5SUUd5QUxLRFJaQVRQUDhydG1rcVluNklmRyI7czo2OiJsb2NhbGUiO3M6MjoiYmciO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjEwNDoiaHR0cDovLzEyNy4wLjAuMTo4MDAxL2xvY2FsZS9iZz9pZD1hZmY5NTEyMS0xMDcwLTQ2MmItODkyZi0yM2ZhYjhmYzQ4NTYmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjEzMTQwMDAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758621314),('9aGncrMPJR46FZrgB2D6F0bB8C1SgWVmcVwVeL79',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMEc0YUZNc0pmMUZtNjY5a3oxTTBpZ1VSS2dYeHNZVk9ZQjJMaUF0eCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758618506),('a1M0VlxVbwC6dcC0GXHCl4KdRqDtb9m91KKnjWk3',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZ0pqNEhwOE40OE01VzR4b05CNzRMVTlhYTFlUzVGTVpqQ1gyZEgyciI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYXNoYm9hcmQ/aWQ9YWZmOTUxMjEtMTA3MC00NjJiLTg5MmYtMjNmYWI4ZmM0ODU2JnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjIxMzM0NTkxIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA0OiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvZGFzaGJvYXJkP2lkPWFmZjk1MTIxLTEwNzAtNDYyYi04OTJmLTIzZmFiOGZjNDg1NiZ2c2NvZGVCcm93c2VyUmVxSWQ9MTc1ODYyMTMzNDU5MSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621334),('aZzHhyrFmXNAdF4A9axyRrcNpi079d3MPhEPue1T',NULL,'127.0.0.1','curl/8.5.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZjMxNW96MFhRcjVOa0tCTnpQQTlHUVFXY2FrVElOT0hQSnZHOUdPTyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozODoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2RlZmF1bHQtcHJvZHVjdHMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozODoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2RlZmF1bHQtcHJvZHVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758618938),('bgtAGopm3cAHkTUNUGoeFHo8y4vLO1HWnCjyPYNp',NULL,'127.0.0.1','curl/8.5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoidDNpMzVhcm8zQUhmenBoaEdCOFZWTUJyQjZRU0ZmdmxBQ0VZTktTNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2NhbGUvc3RhdHVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758620770),('ckoXCVtnqI104SP6sDIdqyoNEXo8jc2gioLh9Z0D',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ3JyTmxtbGJpc3pOSU96YVVuZHJQRHltdmRRRDBaSVgyZXBjOXNLcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621318),('d8n00DcqFpp4WdbkvX2hysIeC6FMJ6VumdSkXcXy',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR1NPaGVrMUZiYXE4WVA5QWtQakRMREJVaU9KYjcyNmo0MjdQUG14SCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYWlseS1tZW51cz9pZD0zNzNkMzY2My04Zjk4LTRhMDctOTY4YS1jYjA4ODkxODA3YzkmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjE4NjExMTIiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoxMDY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYWlseS1tZW51cz9pZD0zNzNkMzY2My04Zjk4LTRhMDctOTY4YS1jYjA4ODkxODA3YzkmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjE4NjExMTIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758621861),('ebBZSNVxZj51Ut6cnlRCgxW1sr5kjecSx9sX8ppO',NULL,'127.0.0.1','curl/8.5.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWmdVSTd5YlRhUmhUdEExZDBlRjV0UU9MYTFRcGV0YWN6NDQzdDk2QyI7czo2OiJsb2NhbGUiO3M6MjoiYmciO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM1OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvbG9jYWxlL3N0YXR1cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758620119),('eMKoPjoF1xqxgqZwzQuvaOeyVtKYn8GFDd2tzsJx',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSXJsT1VTRHVHVEV3TzlpUDk4QWFvdnFPV3NHeHMzTjlWclY5WEhmZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6OTU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC8/aWQ9NDI1ZGQ4NjUtYzZiMS00NmQ3LWFmMzAtOWQ4NzA1MmQ5YzFjJnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjE4NDk4ODA5Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758618498),('eyVGUbtZzGVrxAxiL4B9tV3lXnkbqa9T7zZT68rO',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQ3V2MjlzS2huSXZueFJoTFBCQ1dlREQyRlhTTUlaVWRuSm5ZYzdGMSI7czo2OiJsb2NhbGUiO3M6MjoiYmciO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjEwNDoiaHR0cDovLzEyNy4wLjAuMTo4MDAxL2xvY2FsZS9iZz9pZD00OGUyNzlmNC0xODE1LTRkZDUtOGJkNC1kNjNmODA2ODU0ZTYmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjMwNzMxMzUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758623073),('FWnCPujUUDvC6npl7Q6No1VoZspe9aJma4J5sgis',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoia3VtOUc2Qk9SQUpOWnBWMlAwY1ZHUGk4NDhlWkZwcGZyVEJ1cE9jdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621849),('gnCSRRwTbrDw1ysEUlai4lblPTpfIqB3BWuMn2yZ',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoid0dFVkkwYjUxQjhKZkRRT0h5cGI1SUlJTERzU2VUWG5IcFpDdzNBayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758623081),('iCFf1YeIJo5hBbV8GlJfkGJEhI2sVaEuFfQsYXVk',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNkRsaEdpSGV1bG9jVWowcjBicXBMMGNNQ3A2YlhRUHJWOWw0c1hKMSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYWlseS1tZW51cz9pZD00OGUyNzlmNC0xODE1LTRkZDUtOGJkNC1kNjNmODA2ODU0ZTYmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjMwNzc2NzAiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czoxMDY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYWlseS1tZW51cz9pZD00OGUyNzlmNC0xODE1LTRkZDUtOGJkNC1kNjNmODA2ODU0ZTYmdnNjb2RlQnJvd3NlclJlcUlkPTE3NTg2MjMwNzc2NzAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1758623077),('IqpObKN7HkqV5gY7KETQ2CwtcD3fttsfi79wP1TX',NULL,'127.0.0.1','curl/8.5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMVN4TjRMUVVhUUJKMXlFN1JrdHpoT01SZ0xuc2FnMmx1SlhTR1hkWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2NhbGUvc3RhdHVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758620732),('JEoaVBucvkD4Y6bUslHtLaYmpDcXSBpUJRThZBsB',NULL,'127.0.0.1','curl/8.5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiRWc5TmFlZ1VOb1ZmNnhkbVhrUzRzSUwzMVl3NWF4Smp1ZzBiUU15WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2NhbGUvc3RhdHVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758620693),('JHOCsfwmLypSW3DPUeDrBXxUnPu0TRZJNw8tiXpR',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicWtzNkp4Q3FTRE41ODJ5bkRiRnFGUlFsUmljVjFnRHJNZEE5VkFBbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621334),('JHZ066jOzFVSy2rQuSZDu9JN9J8OkiEncRbTEBk9',NULL,'127.0.0.1','curl/8.5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiblB3NEgxbGEwcngyZWhVOFZ2OUJTdkhvQ3k0WTY2Zm03dmFrT0VGaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2NhbGUvc3RhdHVzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758620674),('KdtGHD3c8gRKnKkn41QeExY4F6Km4QrjnF2vASYl',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSGxINE8zUWQ2a3I2d0RnTjN1ZHZEZVNzSTZFR0w5ZXVNMXBNbEcwMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621371),('lc3T8aFdjNWPH15lJtopgTQ2LUwFOoD895GwL2XF',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibjljbWZTR05NYTQ5ZGRQeUFTM2RRVFAwUDZva1hnNDAyMTZvNmZHQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621857),('loa9mgtADWcpyUAOUvh0MAwXKMNWZeVPhUpYShwv',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiajNrd2F3Q3hmbmN4UW9QQ2NGVnF6ZXowM0lhOHJSeUZLZjVzdEpZYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621861),('MNSPx4PCUZGCE5acP9qJfrXdxTZXNo7czWAG0vOS',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiY0xqWG1VU0FFdWcxR21hV0pnUUxOQ3ZYQkV2WWpkQ3hHQU4ycGNxZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621853),('MUUjsqcBo4X9Rk9mQ0NumxZJlvRV2jJGsIIwKyuf',NULL,'127.0.0.1','curl/8.5.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiM2NudXkxU2t6SDdpWDhNaVZ6TlRCTlZNRlRyUTlIcGVMZ2NqcjNWbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758627702),('nIWIEVTZZsuomYivrjl4whuG8ItykHR6Aa0MirYO',2,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMTUxYXJKUzhIdzNTdTRheldUSTg5ZWNnMTZUanBYNXFTSGxxcEhaeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDY6Imh0dHA6Ly8wLjAuMC4wOjgwMDAvcHJvZHVjdC1jYXRlZ29yaWVzLzMwL2VkaXQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO3M6NjoibG9jYWxlIjtzOjI6ImJnIjt9',1758627227),('NJnwgktmzIukAtk4DE8uCZaLxBDwe2a4ktHU0jwN',NULL,'127.0.0.1','curl/8.5.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOGNjNjJiRzNBWHc3Q2lkc1d4Zm9tRUJTbkZUS1RUZUxramdaZ3F6ciI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czozMToiaHR0cDovLzEyNy4wLjAuMTo4MDAwL2Rhc2hib2FyZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjMxOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758618644),('nK8uSWMWkYzJksUp6WS0QbAAyd4GSGmHF954J2yJ',NULL,'127.0.0.1','curl/8.5.0','YTo1OntzOjY6Il90b2tlbiI7czo0MDoieWRjSXROaWthZ3dxdTYwNXM4WVhUWTZvTE1uVjZCTjhJandJRWU3byI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjI6e2k6MDtzOjEwOiJfb2xkX2lucHV0IjtpOjE7czo2OiJlcnJvcnMiO31zOjM6Im5ldyI7YTowOnt9fXM6MTA6Il9vbGRfaW5wdXQiO2E6Mjp7czo1OiJlbWFpbCI7czoxNzoicGF2ZWxAYWtybHppYS5vcmciO3M6NjoiX3Rva2VuIjtzOjQwOiJ5ZGNJdE5pa2Fnd3F1NjA1czhZWFRZNm9MTW5WNkJOOElqd0lFZTdvIjt9czo2OiJlcnJvcnMiO086MzE6IklsbHVtaW5hdGVcU3VwcG9ydFxWaWV3RXJyb3JCYWciOjE6e3M6NzoiACoAYmFncyI7YToxOntzOjc6ImRlZmF1bHQiO086Mjk6IklsbHVtaW5hdGVcU3VwcG9ydFxNZXNzYWdlQmFnIjoyOntzOjExOiIAKgBtZXNzYWdlcyI7YToxOntzOjU6ImVtYWlsIjthOjE6e2k6MDtzOjQzOiJUaGVzZSBjcmVkZW50aWFscyBkbyBub3QgbWF0Y2ggb3VyIHJlY29yZHMuIjt9fXM6OToiACoAZm9ybWF0IjtzOjg6IjptZXNzYWdlIjt9fX19',1758628462),('QLyssbpfyH4vur1kSrLtXP41qkZrWJ48wq2FwhX8',NULL,'127.0.0.1','curl/8.5.0','YTo1OntzOjY6Il90b2tlbiI7czo0MDoia1N4S1lLNm8yb1dxdVk1Sm4ybFhadG9mclpYREEyMDNHcTZBZnNiYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjI6e2k6MDtzOjEwOiJfb2xkX2lucHV0IjtpOjE7czo2OiJlcnJvcnMiO31zOjM6Im5ldyI7YTowOnt9fXM6MTA6Il9vbGRfaW5wdXQiO2E6MDp7fXM6NjoiZXJyb3JzIjtPOjMxOiJJbGx1bWluYXRlXFN1cHBvcnRcVmlld0Vycm9yQmFnIjoxOntzOjc6IgAqAGJhZ3MiO2E6MTp7czo3OiJkZWZhdWx0IjtPOjI5OiJJbGx1bWluYXRlXFN1cHBvcnRcTWVzc2FnZUJhZyI6Mjp7czoxMToiACoAbWVzc2FnZXMiO2E6Mjp7czo1OiJlbWFpbCI7YToxOntpOjA7czoyODoiVGhlIGVtYWlsIGZpZWxkIGlzIHJlcXVpcmVkLiI7fXM6ODoicGFzc3dvcmQiO2E6MTp7aTowO3M6MzE6IlRoZSBwYXNzd29yZCBmaWVsZCBpcyByZXF1aXJlZC4iO319czo5OiIAKgBmb3JtYXQiO3M6ODoiOm1lc3NhZ2UiO319fX0=',1758628102),('qztWubmIcqJUvWtRuzzlmv1qOlQSZLRrB107Nj04',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoidXVOU09uZWI0QjZhNmxlWnVSYkh4cjRHSENlclhWYms0bUIxSktUQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621314),('rGk1sAJA3S19TFq8tMYo15UloErEZZEgu1zOKFWf',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiU1hMaWxGQVZwZmo2UGd3czBYbDE2dVA0ZVd1NzdSVFNDV1RWS3A0SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758623073),('s2hJgi72nWtGLPoZMRwJLU5Ky6FH3kahsqfvoyzW',NULL,'127.0.0.1','curl/8.5.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSTc5UWF1TndoSWNuS0JEalhsNW1WdUZsMXhBYk1TQTk0ZG1OempZUCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo0MzoiaHR0cDovLzEyNy4wLjAuMTo4MDAwL3Byb2R1Y3QtY2F0ZWdvcmllcy8zMCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjQzOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvcHJvZHVjdC1jYXRlZ29yaWVzLzMwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758627571),('s5AnVMbTkumBQiDY5cxaiGCxxfab2QtjCoRJ23Om',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQW5ybXliNlhxUHNEWXFJUFJPQWZNM1B5Q1Q2WDQwT1ZhYVV0Z0tWQyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYXNoYm9hcmQ/aWQ9MzczZDM2NjMtOGY5OC00YTA3LTk2OGEtY2IwODg5MTgwN2M5JnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjIxODUzMDE0Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA0OiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvZGFzaGJvYXJkP2lkPTM3M2QzNjYzLThmOTgtNGEwNy05NjhhLWNiMDg4OTE4MDdjOSZ2c2NvZGVCcm93c2VyUmVxSWQ9MTc1ODYyMTg1MzAxNCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621853),('S5GHhHkgvFbT63Nr9YKK4houaI4OoypbmlbcB2HU',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSE5IbzZ5YndvZFZVaERWU1dabjlzTmdHVXlsMml2eDJlQkpaSEhQdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758623077),('SxYKrhR6afABVeQ4Knd94kolj226SjsjWZd0zRUL',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiellOajBJRGVqelNNemR0WVVDOTlMWUVFN1c3blRDQkhUaUdkaVRzcSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDg6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS91c2VyLXByb2R1Y3RzP2lkPTM3M2QzNjYzLThmOTgtNGEwNy05NjhhLWNiMDg4OTE4MDdjOSZ2c2NvZGVCcm93c2VyUmVxSWQ9MTc1ODYyMTg1NzEwMSI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjEwODoiaHR0cDovLzEyNy4wLjAuMTo4MDAxL3VzZXItcHJvZHVjdHM/aWQ9MzczZDM2NjMtOGY5OC00YTA3LTk2OGEtY2IwODg5MTgwN2M5JnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjIxODU3MTAxIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758621857),('v163tbLf6SLXCHHibrGSPqoLaX4dO4bZqXPinojk',2,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36','YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNFZVQkF4eVJYOHgzc3VGRGtKYkFTc2JiTXZBUDRwRDI1eVhweHFjQiI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjtzOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czozNToiaHR0cDovLzEyNy4wLjAuMTo4MDAxL3VzZXItcHJvZHVjdHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjY6ImxvY2FsZSI7czoyOiJiZyI7fQ==',1758620995),('V4KeDnJSKePovM6xkthJ6YtWgIYe8JIXVPjCn1vC',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YToyOntzOjY6Il90b2tlbiI7czo0MDoieFRWcE1XV2dUZ0IyVkJPemR2U0xxTkp3NUwyaVh3SjJFMDRxSzkwayI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1758621327),('wIcODv55lO5Ij2MmkeDX5AKSsG7G35aoKqTjIw9g',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVWRhWTBTSXE1SU5CV3RtT1VXdTdsaVdnZVowYmVocGhxSFV1Q2NyTyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYXNoYm9hcmQ/aWQ9YWZmOTUxMjEtMTA3MC00NjJiLTg5MmYtMjNmYWI4ZmM0ODU2JnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjIxMzE4NTA1Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA0OiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvZGFzaGJvYXJkP2lkPWFmZjk1MTIxLTEwNzAtNDYyYi04OTJmLTIzZmFiOGZjNDg1NiZ2c2NvZGVCcm93c2VyUmVxSWQ9MTc1ODYyMTMxODUwNSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758621318),('Y4Z99UdxAuFIcaCf6JFpYbDpdFYITWo1gGLIlASC',NULL,'127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Code/1.104.1 Chrome/138.0.7204.235 Electron/37.3.1 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidm82alh3aXNoTkdLZFdJaGZic2tZZ2dVWXM2bndnV0FBajI1U01MNiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoxMDQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMS9kYXktdHlwZXM/aWQ9NDhlMjc5ZjQtMTgxNS00ZGQ1LThiZDQtZDYzZjgwNjg1NGU2JnZzY29kZUJyb3dzZXJSZXFJZD0xNzU4NjIzMDgxNjA4Ijt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTA0OiJodHRwOi8vMTI3LjAuMC4xOjgwMDEvZGF5LXR5cGVzP2lkPTQ4ZTI3OWY0LTE4MTUtNGRkNS04YmQ0LWQ2M2Y4MDY4NTRlNiZ2c2NvZGVCcm93c2VyUmVxSWQ9MTc1ODYyMzA4MTYwOCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1758623081);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_product_categories`
--
DROP TABLE IF EXISTS `user_product_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_product_categories` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_product_categories_user_id_name_unique` (`user_id`,`name`),
CONSTRAINT `user_product_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_product_categories`
--
LOCK TABLES `user_product_categories` WRITE;
/*!40000 ALTER TABLE `user_product_categories` DISABLE KEYS */;
INSERT INTO `user_product_categories` VALUES (1,3,'Хляб и печива','2025-09-23 05:12:09','2025-09-23 05:12:09'),(2,3,'Млечни продукти','2025-09-23 05:12:09','2025-09-23 05:12:09'),(3,3,'Месо','2025-09-23 05:12:09','2025-09-23 05:12:09'),(4,3,'Колбаси','2025-09-23 05:12:09','2025-09-23 05:12:09'),(5,3,'Риба','2025-09-23 05:12:09','2025-09-23 05:12:09'),(6,3,'Яйца','2025-09-23 05:12:09','2025-09-23 05:12:09'),(7,3,'Зърнени','2025-09-23 05:12:09','2025-09-23 05:12:09'),(8,3,'Зеленчуци','2025-09-23 05:12:09','2025-09-23 05:12:09'),(9,3,'Плодове','2025-09-23 05:12:09','2025-09-23 05:12:09'),(10,3,'Ядки','2025-09-23 05:12:09','2025-09-23 05:12:09'),(11,3,'Подсладители','2025-09-23 05:12:09','2025-09-23 05:12:09'),(12,3,'Сладкиши','2025-09-23 05:12:09','2025-09-23 05:12:09'),(13,3,'Десерти','2025-09-23 05:12:09','2025-09-23 05:12:09'),(14,3,'Закуски','2025-09-23 05:12:09','2025-09-23 05:12:09'),(15,2,'Хляб и печива','2025-09-23 05:28:16','2025-09-23 05:28:16'),(16,1,'Месо','2025-09-23 05:35:52','2025-09-23 05:35:52'),(17,1,'Риба','2025-09-23 05:35:52','2025-09-23 05:35:52'),(18,1,'Млечни продукти','2025-09-23 05:35:52','2025-09-23 05:35:52'),(19,2,'Млечни продукти','2025-09-23 06:13:01','2025-09-23 06:13:01'),(20,2,'Месо','2025-09-23 06:13:01','2025-09-23 06:13:01'),(21,2,'Колбаси','2025-09-23 06:13:01','2025-09-23 06:13:01'),(22,2,'Риба','2025-09-23 06:13:01','2025-09-23 06:13:01'),(23,2,'Яйца','2025-09-23 06:13:01','2025-09-23 06:13:01'),(24,2,'Зърнени / Бобови','2025-09-23 06:13:01','2025-09-23 09:57:59'),(25,2,'Зеленчуци','2025-09-23 06:13:01','2025-09-23 06:13:01'),(26,2,'Плодове','2025-09-23 06:13:01','2025-09-23 06:13:01'),(27,2,'Ядки','2025-09-23 06:13:01','2025-09-23 06:13:01'),(28,2,'Подсладители','2025-09-23 06:13:01','2025-09-23 06:13:01'),(29,2,'Сладкиши','2025-09-23 06:13:01','2025-09-23 06:13:01'),(30,2,'Десерти','2025-09-23 06:13:01','2025-09-23 06:13:01'),(31,2,'Закуски','2025-09-23 06:13:01','2025-09-23 06:13:01'),(32,2,'Хранителни добавки','2025-09-23 09:46:29','2025-09-23 09:46:29'),(34,2,'Паста','2025-09-23 16:44:11','2025-09-23 16:44:11');
/*!40000 ALTER TABLE `user_product_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user_products`
--
DROP TABLE IF EXISTS `user_products`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_products` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`user_id` bigint unsigned NOT NULL,
`user_category_id` bigint unsigned NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`calories_per_100g` decimal(8,2) NOT NULL,
`fat_per_100g` decimal(8,2) NOT NULL,
`carbs_per_100g` decimal(8,2) NOT NULL,
`protein_per_100g` decimal(8,2) NOT NULL,
`fiber_per_100g` decimal(8,2) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_products_user_id_foreign` (`user_id`),
KEY `user_products_user_category_id_foreign` (`user_category_id`),
CONSTRAINT `user_products_user_category_id_foreign` FOREIGN KEY (`user_category_id`) REFERENCES `user_product_categories` (`id`) ON DELETE CASCADE,
CONSTRAINT `user_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user_products`
--
LOCK TABLES `user_products` WRITE;
/*!40000 ALTER TABLE `user_products` DISABLE KEYS */;
INSERT INTO `user_products` VALUES (1,2,15,'Хляб бял',266.00,3.30,50.60,8.90,2.30,'2025-09-23 05:28:16','2025-09-23 05:28:16'),(2,1,16,'Свинско месо',250.00,20.00,0.00,16.00,0.00,'2025-09-23 05:35:52','2025-09-23 05:35:52'),(3,1,16,'Говеждо месо',280.00,18.00,0.00,20.00,0.00,'2025-09-23 05:35:52','2025-09-23 05:35:52'),(4,1,17,'Сьомга',200.00,13.00,0.00,22.00,0.00,'2025-09-23 05:35:52','2025-09-23 05:35:52'),(5,2,15,'Хляб пълнозърнест',252.00,4.00,43.00,12.00,6.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(6,2,15,'Питка',275.00,1.00,56.00,9.00,2.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(7,2,15,'Багета',274.00,3.00,52.00,8.80,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(8,2,15,'Тостерен хляб',265.00,3.50,49.00,9.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(9,2,15,'Кроасан',406.00,21.00,45.00,8.20,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(10,2,15,'Баница',322.00,20.00,30.00,10.00,2.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(11,2,15,'Тортиля',218.00,3.00,45.00,6.00,5.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(12,2,15,'Пица Маргарита (основа)',266.00,10.00,33.00,12.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(13,2,15,'Пърленка',280.00,3.00,48.00,8.00,2.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(14,2,19,'Кисело мляко (3.6%)',61.00,3.60,3.80,3.20,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(15,2,19,'Кисело мляко обезмаслено',35.00,0.10,4.70,3.50,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(16,2,19,'Прясно мляко (3.6%)',64.00,3.60,4.80,3.30,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(17,2,19,'Прясно мляко обезмаслено',34.00,0.10,5.00,3.40,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(18,2,19,'Краве сирене',98.00,5.00,3.00,11.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(19,2,19,'Овче сирене',264.00,21.00,0.00,18.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(20,2,19,'Козе сирене',364.00,30.00,0.00,22.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(21,2,19,'Кашкавал',349.00,27.00,2.00,25.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(22,2,19,'Моцарела',280.00,17.00,3.00,28.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(23,2,19,'Крем сирене',342.00,34.00,4.00,6.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(24,2,19,'Сметана',292.00,30.00,3.00,2.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(25,2,19,'Масло',717.00,81.00,0.00,1.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(26,2,19,'Извара',98.00,5.00,3.00,11.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(27,2,20,'Пилешко филе',165.00,3.60,0.00,31.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(28,2,20,'Пилешко бутче',209.00,10.00,0.00,26.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(29,2,20,'Пилешки дроб',119.00,4.80,1.10,17.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(30,2,20,'Свинско месо',242.00,14.00,0.00,27.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(31,2,20,'Свински врат',291.00,20.00,0.00,29.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(32,2,20,'Телешко месо',250.00,15.00,0.00,26.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(33,2,20,'Агнешко месо',294.00,21.00,0.00,25.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(34,2,20,'Пуешко месо',135.00,1.00,0.00,29.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(35,2,20,'Патица',337.00,28.00,0.00,19.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(36,2,20,'Говежди дроб',135.00,3.60,3.90,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(37,2,21,'Суджук',515.00,45.00,2.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(38,2,21,'Салам',350.00,30.00,1.00,25.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(39,2,21,'Шунка',145.00,5.00,1.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(40,2,21,'Бекон',541.00,42.00,0.00,37.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(41,2,22,'Сьомга',208.00,13.00,0.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(42,2,22,'Риба тон',132.00,1.00,0.00,28.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(43,2,22,'Скумрия',205.00,13.00,0.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(44,2,22,'Пъстърва',148.00,6.00,0.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(45,2,22,'Сардини',208.00,11.00,0.00,25.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(46,2,22,'Херинга',158.00,11.00,0.00,18.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(47,2,22,'Скариди',99.00,1.00,0.00,24.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(48,2,22,'Калмари',92.00,1.40,3.10,16.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(49,2,22,'Миди',86.00,2.00,7.00,12.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(50,2,22,'Октопод',82.00,1.00,4.00,14.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(51,2,22,'Ципура',128.00,3.00,0.00,23.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(52,2,22,'Лаврак',121.00,2.70,0.00,20.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(53,2,23,'Яйце цяло',143.00,10.00,0.70,12.60,0.00,'2025-09-23 06:13:01','2025-09-23 09:10:55'),(54,2,23,'Белтък',52.00,0.20,0.70,11.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(55,2,23,'Жълтък',322.00,27.00,0.60,16.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(56,2,24,'Леща',116.00,0.40,20.00,9.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(57,2,24,'Боб',127.00,0.50,22.00,9.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(58,2,24,'Нахут',164.00,3.00,27.00,9.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(59,2,24,'Грах',81.00,0.40,14.00,5.40,5.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(60,2,24,'Соеви зърна',446.00,20.00,30.00,36.00,15.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(61,2,24,'Фасул червен',127.00,0.50,22.00,9.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(62,2,24,'Фасул бял',132.00,0.50,24.00,9.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(63,2,24,'Лима боб',139.00,0.50,25.00,9.00,7.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(64,2,24,'Ориз бял',130.00,0.30,28.00,2.70,0.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(65,2,24,'Ориз кафяв',111.00,0.90,23.00,2.60,1.80,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(66,2,24,'Ориз жасмин',130.00,0.30,28.00,2.40,0.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(67,2,24,'Ориз басмати',121.00,0.40,25.00,4.00,0.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(68,2,24,'Булгур',83.00,0.20,19.00,3.10,4.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(69,2,24,'Кускус',112.00,0.20,23.00,3.80,1.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(70,2,24,'Овесени ядки',389.00,7.00,66.00,17.00,10.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(71,2,24,'Ечемик',354.00,2.30,73.00,12.00,17.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(72,2,24,'Ръжено брашно',335.00,1.60,75.00,10.00,15.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(73,2,24,'Царевица',365.00,4.70,74.00,9.00,7.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(74,2,24,'Полента',70.00,0.00,16.00,2.00,1.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(75,2,24,'Грис',350.00,1.00,72.00,11.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(76,2,24,'Киноа',120.00,2.00,21.00,4.00,2.80,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(77,2,24,'Амарант',371.00,7.00,65.00,14.00,7.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(78,2,24,'Просо',378.00,4.00,73.00,11.00,3.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(79,2,25,'Картофи',77.00,0.10,17.00,2.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(80,2,25,'Сладки картофи',86.00,0.10,20.00,1.60,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(81,2,25,'Моркови',41.00,0.20,10.00,1.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(82,2,25,'Домат',18.00,0.20,3.90,0.90,1.20,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(83,2,25,'Краставица',15.00,0.10,3.60,0.70,0.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(84,2,25,'Броколи',34.00,0.40,7.00,2.80,2.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(85,2,25,'Зеле',25.00,0.10,6.00,1.30,2.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(86,2,25,'Лук',40.00,0.10,9.00,1.10,1.70,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(87,2,25,'Чесън',149.00,0.50,33.00,6.40,2.10,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(88,2,25,'Чушка',20.00,0.20,5.00,1.00,1.70,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(89,2,25,'Тиквички',17.00,0.30,3.10,1.20,1.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(90,2,25,'Патладжан',25.00,0.20,6.00,1.00,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(91,2,25,'Цвекло',43.00,0.20,10.00,1.60,2.80,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(92,2,25,'Спанак',23.00,0.40,3.60,2.90,2.20,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(93,2,25,'Маруля',15.00,0.20,2.90,1.40,1.30,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(94,2,25,'Гъби печурки',22.00,0.30,3.30,3.10,1.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(95,2,25,'Зелен фасул',31.00,0.10,7.00,2.00,3.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(96,2,25,'Кейл',49.00,0.90,9.00,4.30,3.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(97,2,25,'Аспержи',20.00,0.10,3.90,2.20,2.10,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(98,2,25,'Артишок',47.00,0.20,11.00,3.30,5.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(99,2,26,'Ябълка',52.00,0.20,14.00,0.30,2.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(100,2,26,'Банан',89.00,0.30,23.00,1.10,2.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(101,2,26,'Портокал',47.00,0.10,12.00,0.90,2.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(102,2,26,'Грозде',69.00,0.20,18.00,0.70,0.90,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(103,2,26,'Круша',57.00,0.10,15.00,0.40,3.10,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(104,2,26,'Диня',30.00,0.20,8.00,0.60,0.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(105,2,26,'Пъпеш',34.00,0.20,9.00,0.80,0.90,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(106,2,26,'Киви',61.00,0.50,15.00,1.10,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(107,2,26,'Манго',60.00,0.40,15.00,0.80,1.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(108,2,26,'Ананас',50.00,0.10,13.00,0.50,1.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(109,2,26,'Праскова',39.00,0.30,10.00,0.90,1.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(110,2,26,'Слива',46.00,0.30,11.00,0.70,1.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(111,2,26,'Череша',50.00,0.30,12.00,1.00,1.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(112,2,26,'Ягода',32.00,0.30,7.70,0.70,2.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(113,2,26,'Малина',52.00,0.70,12.00,1.20,6.50,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(114,2,26,'Боровинка',57.00,0.30,14.00,0.70,2.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(115,2,26,'Къпина',43.00,0.50,10.00,1.40,5.30,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(117,2,26,'Грейпфрут',42.00,0.10,11.00,0.80,1.10,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(118,2,26,'Лимон',29.00,0.30,9.00,1.10,2.80,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(119,2,26,'Маслини',115.00,11.00,6.00,0.80,3.20,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(120,2,27,'Бадеми',579.00,50.00,22.00,21.00,12.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(121,2,27,'Орехи',654.00,65.00,14.00,15.00,7.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(122,2,27,'Лешници',628.00,61.00,17.00,15.00,10.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(123,2,27,'Фъстъци',567.00,49.00,16.00,26.00,9.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(124,2,27,'Кашу',553.00,44.00,30.00,18.00,3.30,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(125,2,27,'Бразилски орехи',656.00,66.00,12.00,14.00,8.70,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(126,2,27,'Шамфъстък',562.00,45.00,28.00,20.00,10.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(127,2,27,'Кестени',213.00,2.20,45.00,2.00,8.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(128,2,27,'Кокосова ядка',354.00,33.00,15.00,3.30,9.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(129,2,27,'Слънчогледови семки',584.00,51.00,20.00,21.00,8.60,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(130,2,27,'Тиквени семки',446.00,19.00,54.00,19.00,18.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(131,2,27,'Ленено семе',534.00,42.00,29.00,18.00,27.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(132,2,27,'Чия',486.00,31.00,42.00,17.00,34.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(133,2,27,'Маково семе',525.00,41.00,29.00,18.00,20.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(134,2,27,'Сусам',573.00,50.00,23.00,18.00,12.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(135,2,28,'Мед',304.00,0.00,82.00,0.30,0.20,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(136,2,28,'Захар',387.00,0.00,100.00,0.00,0.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(137,2,29,'Шоколад черен',546.00,31.00,46.00,4.90,11.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(138,2,29,'Шоколад млечен',535.00,31.00,59.00,7.60,3.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(139,2,30,'Сладолед ванилия',207.00,11.00,24.00,3.50,0.70,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(140,2,30,'Бисквити',502.00,20.00,70.00,6.00,2.40,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(141,2,31,'Чипс',536.00,34.00,53.00,6.00,5.80,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(142,2,31,'Пуканки',387.00,4.30,78.00,12.00,14.00,'2025-09-23 06:13:01','2025-09-23 06:13:01'),(143,2,26,'Авокадо',160.00,15.00,9.00,2.00,7.00,'2025-09-23 06:13:57','2025-09-23 06:13:57'),(144,2,27,'Ядково мляко -Вемондо - Бадем',23.00,1.20,2.40,0.50,0.00,'2025-09-23 09:26:42','2025-09-23 09:26:42'),(145,2,31,'Фъстъчено масло',660.00,53.00,15.00,29.00,0.00,'2025-09-23 09:45:10','2025-09-23 09:45:10'),(146,2,32,'Грахов протеин Dragon Foods',396.00,8.50,55.00,70.00,0.00,'2025-09-23 09:46:19','2025-09-23 09:46:43'),(147,2,24,'Червен ориз Крина',378.00,3.30,76.00,89.00,0.00,'2025-09-23 09:49:12','2025-09-23 09:49:12'),(148,2,31,'Оризовки (1бр - 10г)',394.00,4.40,78.40,8.40,0.00,'2025-09-23 09:51:33','2025-09-23 09:51:33'),(149,2,34,'Спагети Барила',359.00,2.00,71.00,13.00,3.00,'2025-09-23 16:45:07','2025-09-23 16:45:07');
/*!40000 ALTER TABLE `user_products` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`email_verified_at` timestamp NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`weight` decimal(5,2) DEFAULT NULL,
`remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 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 (1,'Demo User','demo@example.com','2025-09-22 13:47:18','$2y$12$aqMmoQqMgz84LLi6Q5UV8e3qW9LA9V8UesBbR4kndosoQLhqqD68a',70.00,NULL,'2025-09-22 13:47:18','2025-09-22 13:47:18'),(2,'Павел','pavel@akrozia.org',NULL,'$2y$12$zqDAt1uwDeKrdMKWkhctrezmnEHm/qcnaOyUWaUNJUvmbaG9GCXKC',90.00,'tCgLU6vyxmlRey5liEdDMtuouZB3BQEaboBSPFpuN6dpOeJlRnMLHneeoQOe','2025-09-22 13:56:51','2025-09-22 13:57:33'),(3,'Test User','test@example.com',NULL,'$2y$12$VFxJkgXRRXfRqV/3vLoRVODU5ZZDoD1Sn3WtiJormTK1mN/K3FhV2',NULL,NULL,'2025-09-23 05:12:09','2025-09-23 05:12:09');
/*!40000 ALTER TABLE `users` 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 2025-09-24 20:52:28