-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Versión del servidor:         8.4.3 - MySQL Community Server - GPL
-- SO del servidor:              Win64
-- HeidiSQL Versión:             12.8.0.6908
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;


-- Volcando estructura de base de datos para restaurante_db
CREATE DATABASE IF NOT EXISTS `restaurante_db` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `restaurante_db`;

-- Volcando estructura para tabla restaurante_db.areas
CREATE TABLE IF NOT EXISTS `areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.areas: ~2 rows (aproximadamente)
INSERT INTO `areas` (`id`, `name`, `created_at`, `updated_at`) VALUES
	(1, 'Salón Principal', '2025-12-25 21:31:47', '2025-12-25 21:31:47'),
	(2, 'Terraza', '2025-12-25 21:31:47', '2025-12-25 21:31:47');

-- Volcando estructura para tabla restaurante_db.cache
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.cache: ~0 rows (aproximadamente)
INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
	('laravel-cache-user_permissions_10_waiter', 'a:2:{i:0;s:10:"pos.access";i:1;s:19:"reservations.access";}', 1787160777),
	('laravel-cache-user_permissions_7_admin', 'a:14:{i:0;s:16:"dashboard.access";i:1;s:14:"reports.access";i:2;s:10:"pos.access";i:3;s:19:"reservations.access";i:4;s:12:"sales.access";i:5;s:14:"kitchen.access";i:6;s:14:"clients.access";i:7;s:17:"categories.access";i:8;s:15:"products.access";i:9;s:21:"inventory_logs.access";i:10;s:13:"tables.access";i:11;s:12:"users.access";i:12;s:15:"settings.access";i:13;s:15:"expenses.access";}', 1787160761),
	('laravel-cache-user_permissions_8_gerente', 'a:14:{i:0;s:16:"dashboard.access";i:1;s:14:"reports.access";i:2;s:10:"pos.access";i:3;s:19:"reservations.access";i:4;s:12:"sales.access";i:5;s:14:"kitchen.access";i:6;s:14:"clients.access";i:7;s:17:"categories.access";i:8;s:15:"products.access";i:9;s:21:"inventory_logs.access";i:10;s:13:"tables.access";i:11;s:12:"users.access";i:12;s:15:"settings.access";i:13;s:15:"expenses.access";}', 1787162306),
	('laravel-cache-user_permissions_9_cashier', 'a:5:{i:0;s:16:"dashboard.access";i:1;s:10:"pos.access";i:2;s:19:"reservations.access";i:3;s:12:"sales.access";i:4;s:15:"expenses.access";}', 1787160786);

-- Volcando estructura para tabla restaurante_db.cache_locks
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.cache_locks: ~0 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.categories
CREATE TABLE IF NOT EXISTS `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.categories: ~4 rows (aproximadamente)
INSERT INTO `categories` (`id`, `name`, `description`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 'Bebidas', NULL, NULL, 1, '2025-12-25 21:31:47', '2025-12-28 09:58:07'),
	(2, 'Hamburguesas', NULL, NULL, 1, '2025-12-25 21:31:47', '2025-12-28 09:58:07'),
	(3, 'Postres', NULL, NULL, 1, '2025-12-25 21:31:47', '2025-12-28 09:58:07'),
	(4, 'Helados', NULL, NULL, 1, '2025-12-29 19:12:49', '2026-08-19 16:30:34'),
	(5, 'Cervezas', NULL, NULL, 1, '2026-08-19 17:00:56', '2026-08-19 17:00:56'),
	(6, 'Alquiler mesa de billar', NULL, NULL, 1, '2026-08-19 17:01:46', '2026-08-19 17:01:46'),
	(7, 'Piqueos', NULL, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(8, 'Combos', NULL, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44');

-- Volcando estructura para tabla restaurante_db.clients
CREATE TABLE IF NOT EXISTS `clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DNI',
  `document_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) 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 `clients_document_number_unique` (`document_number`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.clients: ~2 rows (aproximadamente)
INSERT INTO `clients` (`id`, `name`, `document_type`, `document_number`, `email`, `phone`, `address`, `created_at`, `updated_at`) VALUES
	(1, 'CLIENTE 1', 'DNI', '20202020', 'cliente1@correo.com', '30303031', 'direccion 1', '2025-12-28 09:23:27', '2025-12-28 09:23:49'),
	(2, 'CARLOS SOTELO', 'DNI', '34343434', 'carlos@correo.com', '89898989', 'LIMA', '2025-12-29 19:11:46', '2025-12-29 19:11:46');

-- Volcando estructura para tabla restaurante_db.expenses
CREATE TABLE IF NOT EXISTS `expenses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `expenses_user_id_foreign` (`user_id`),
  CONSTRAINT `expenses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.expenses: ~3 rows (aproximadamente)
INSERT INTO `expenses` (`id`, `description`, `amount`, `user_id`, `created_at`, `updated_at`) VALUES
	(1, 'Compra de Limones', 10.00, 1, '2025-12-28 01:18:10', '2025-12-28 01:18:10'),
	(2, 'Bolsa de Hielo', 5.00, 1, '2025-12-28 09:43:00', '2025-12-28 09:43:00'),
	(3, 'Bolsa de Hielo', 10.00, 1, '2025-12-29 19:22:08', '2025-12-29 19:22:08');

-- Volcando estructura para tabla restaurante_db.failed_jobs
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.failed_jobs: ~0 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.inventory_logs
CREATE TABLE IF NOT EXISTS `inventory_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL,
  `old_stock` int DEFAULT NULL,
  `new_stock` int DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `inventory_logs_product_id_foreign` (`product_id`),
  KEY `inventory_logs_user_id_foreign` (`user_id`),
  CONSTRAINT `inventory_logs_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `inventory_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.inventory_logs: ~49 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.jobs
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.jobs: ~0 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.job_batches
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.job_batches: ~0 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.migrations
CREATE TABLE IF NOT EXISTS `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=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.migrations: ~25 rows (aproximadamente)
INSERT INTO `migrations` (`id`, `migration`, `batch`) 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_12_25_151213_create_categories_table', 1),
	(5, '2025_12_25_151226_create_products_table', 1),
	(6, '2025_12_25_151405_create_areas_table', 1),
	(7, '2025_12_25_151405_create_tables_table', 1),
	(8, '2025_12_25_152440_create_sessions_table', 1),
	(9, '2025_12_25_154209_create_orders_table', 1),
	(10, '2025_12_25_154210_create_order_details_table', 1),
	(11, '2025_12_25_182109_create_settings_table', 2),
	(12, '2025_12_25_190357_add_payments_to_orders_table', 3),
	(13, '2025_12_25_194039_add_note_to_order_details_table', 4),
	(14, '2025_12_27_201525_create_expenses_table', 5),
	(15, '2025_12_27_202113_add_client_data_to_orders', 6),
	(16, '2025_12_27_203616_add_discount_and_tip_to_orders', 7),
	(17, '2025_12_28_024400_add_role_to_users', 8),
	(18, '2025_12_28_032924_create_inventory_logs_table', 8),
	(19, '2025_12_28_041453_create_clients_table', 9),
	(20, '2025_12_28_043046_add_client_id_to_orders_table', 10),
	(21, '2025_12_29_140318_add_position_to_tables_table', 11),
	(22, '2025_12_29_142451_add_coords_to_tables', 12),
	(23, '2025_12_29_161924_create_reservations_table', 13),
	(24, '2025_12_29_180402_create_product_ingredients_table', 14),
	(25, '2025_12_29_182322_add_is_saleable_to_products_table', 15),
	(26, '2026_08_19_000001_create_permissions_tables', 16),
	(27, '2026_08_19_000002_update_role_column_type', 17),
	(28, '2026_08_19_000003_add_description_to_categories', 18);

-- Volcando estructura para tabla restaurante_db.orders
CREATE TABLE IF NOT EXISTS `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `table_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `status` enum('pending','completed','cancelled') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `document_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Ticket',
  `client_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Público General',
  `client_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tip` decimal(10,2) NOT NULL DEFAULT '0.00',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'cash',
  `received_amount` decimal(10,2) DEFAULT NULL,
  `change_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `client_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_table_id_foreign` (`table_id`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_client_id_foreign` (`client_id`),
  CONSTRAINT `orders_client_id_foreign` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`),
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.orders: ~1 rows (aproximadamente)
INSERT INTO `orders` (`id`, `table_id`, `user_id`, `status`, `document_type`, `client_name`, `client_document`, `total`, `discount`, `tip`, `payment_method`, `received_amount`, `change_amount`, `notes`, `created_at`, `updated_at`, `client_id`) VALUES
	(1, 1, 9, 'cancelled', 'Ticket', 'Público General', NULL, 0.00, 0.00, 0.00, 'cash', NULL, 0.00, NULL, '2026-08-19 16:33:23', '2026-08-19 16:49:42', NULL),
	(2, 1, 10, 'cancelled', 'Ticket', 'Público General', NULL, 0.00, 0.00, 0.00, 'cash', NULL, 0.00, NULL, '2026-08-19 16:52:30', '2026-08-19 16:55:17', NULL),
	(3, 1, 9, 'cancelled', 'Ticket', 'Público General', NULL, 0.00, 0.00, 0.00, 'cash', NULL, 0.00, NULL, '2026-08-19 16:55:48', '2026-08-19 16:58:40', NULL),
	(4, 1, 1, 'cancelled', 'Ticket', 'Público General', NULL, 0.00, 0.00, 0.00, 'cash', NULL, 0.00, NULL, '2026-08-19 17:10:45', '2026-08-19 17:12:34', NULL);

-- Volcando estructura para tabla restaurante_db.order_details
CREATE TABLE IF NOT EXISTS `order_details` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `product_id` bigint unsigned NOT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `price` decimal(10,2) NOT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','cooking','served') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_details_order_id_foreign` (`order_id`),
  KEY `order_details_product_id_foreign` (`product_id`),
  CONSTRAINT `order_details_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_details_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.order_details: ~47 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.permissions: ~16 rows (aproximadamente)
INSERT INTO `permissions` (`id`, `name`, `slug`, `module`, `description`, `created_at`, `updated_at`) VALUES
	(1, 'Acceder a Dashboard', 'dashboard.access', 'dashboard', 'Permite acceder al módulo de Dashboard', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(2, 'Acceder a Reportes Gerenciales', 'reports.access', 'reports', 'Permite acceder al módulo de Reportes Gerenciales', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(3, 'Acceder a Punto de Venta (POS)', 'pos.access', 'pos', 'Permite acceder al módulo de Punto de Venta (POS)', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(4, 'Acceder a Reservas y Agenda', 'reservations.access', 'reservations', 'Permite acceder al módulo de Reservas y Agenda', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(5, 'Acceder a Caja / Historial de Ventas', 'sales.access', 'sales', 'Permite acceder al módulo de Caja / Historial de Ventas', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(6, 'Acceder a Monitor Cocina (KDS)', 'kitchen.access', 'kitchen', 'Permite acceder al módulo de Monitor Cocina (KDS)', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(7, 'Acceder a Clientes (CRM)', 'clients.access', 'clients', 'Permite acceder al módulo de Clientes (CRM)', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(8, 'Acceder a Categorías', 'categories.access', 'categories', 'Permite acceder al módulo de Categorías', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(9, 'Acceder a Inventario / Productos', 'products.access', 'products', 'Permite acceder al módulo de Inventario / Productos', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(10, 'Acceder a Kardex / Movimientos', 'inventory_logs.access', 'inventory_logs', 'Permite acceder al módulo de Kardex / Movimientos', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(11, 'Acceder a Mesas / Salón', 'tables.access', 'tables', 'Permite acceder al módulo de Mesas / Salón', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(12, 'Acceder a Usuarios / Personal', 'users.access', 'users', 'Permite acceder al módulo de Usuarios / Personal', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(13, 'Acceder a Roles y Permisos', 'roles_permissions.access', 'roles_permissions', 'Permite acceder al módulo de Roles y Permisos', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(14, 'Acceder a Configuración', 'settings.access', 'settings', 'Permite acceder al módulo de Configuración', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(15, 'Acceder a Mantenimiento del Sistema', 'system.access', 'system', 'Permite acceder al módulo de Mantenimiento del Sistema', '2026-08-19 19:33:05', '2026-08-19 19:33:05'),
	(16, 'Acceder a Gastos', 'expenses.access', 'expenses', 'Permite acceder al módulo de Gastos', '2026-08-19 19:33:05', '2026-08-19 19:33:05');

-- Volcando estructura para tabla restaurante_db.products
CREATE TABLE IF NOT EXISTS `products` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,2) NOT NULL,
  `cost` decimal(10,2) DEFAULT NULL,
  `stock` int DEFAULT NULL,
  `is_saleable` tinyint(1) NOT NULL DEFAULT '1',
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.products: ~93 rows (aproximadamente)
INSERT INTO `products` (`id`, `category_id`, `name`, `code`, `price`, `cost`, `stock`, `is_saleable`, `image`, `is_active`, `created_at`, `updated_at`) VALUES
	(1, 2, 'Hamburguesa Clásica', NULL, 12.50, NULL, 0, 1, 'products/bPD8jEU4aDeR5E09QCgJ4p6pdWF7HcI4HUdHudMd.png', 1, '2025-12-25 21:31:47', '2025-12-29 19:19:03'),
	(2, 2, 'Hamburguesa Doble Queso', NULL, 15.00, NULL, 0, 1, 'products/ui23JdxItgBLUex4NrB5Yomm9L3zLRNcloCt9pgD.png', 1, '2025-12-25 21:31:47', '2026-08-19 16:14:28'),
	(3, 1, 'Coca Cola 500ml', NULL, 3.50, NULL, 0, 1, 'products/4IcdWFRUgmFyw9Iu4QQ22PHlY3o5FUqrTga47UAv.png', 1, '2025-12-25 21:31:47', '2026-08-18 17:56:24'),
	(4, 1, 'Limonada Frozen', NULL, 5.00, NULL, 0, 1, 'products/X4li3YMa9TBMX7Zjob8cf4yX7rkebA04oZgSOAOL.png', 1, '2025-12-25 21:31:47', '2026-08-19 16:14:28'),
	(5, 3, 'Cheesecake Fresa', NULL, 8.00, NULL, 0, 1, 'products/gya3EvTiCjEHppXA2YnFILGBY9tfyIezPZ8SC6l2.png', 1, '2025-12-25 21:31:47', '2026-08-19 16:14:28'),
	(6, 2, 'Carne', NULL, 3.50, NULL, 0, 0, 'products/6Rfl4iXg7YgRpbmG3qEPwLiDFgj6SE4cwQcX4NkM.png', 1, '2025-12-29 18:11:15', '2026-08-19 16:31:15'),
	(7, 4, 'Donofrio Frio Rico x 93ML', NULL, 3.00, NULL, 0, 1, 'products/5TBf02o1WLCw5eCDegDpzatmeyC0w1grZZwXJ1Wo.png', 1, '2025-12-29 19:14:18', '2026-08-19 16:14:28'),
	(8, 4, 'Donofrio Sublime Paleta Bolsa 80ml', NULL, 4.00, NULL, 0, 1, 'products/y8Pfh5On0SczB5xmEBqwD7T5bc7O8c9HA3QF7guA.png', 1, '2025-12-29 19:16:08', '2026-08-19 16:14:28'),
	(9, 1, 'Inca Kola 500ML', NULL, 3.00, NULL, 0, 1, 'products/MeHweoXnNPWWLH83DYHLINTFxNaz77ng9gynP8qU.png', 1, '2025-12-29 19:18:27', '2026-08-18 17:56:24'),
	(10, 1, 'Cusqueña', NULL, 8.00, NULL, 0, 1, 'products/3PzcejK2APPbvc1gIqlsZLUq7Rmsaj4rGDTBnTWf.png', 1, '2026-08-19 13:20:18', '2026-08-19 13:34:46'),
	(11, 1, 'Pepsi 500ml', 'BEB-002', 3.00, 1.80, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(12, 1, 'Sprite 500ml', 'BEB-003', 3.00, 1.80, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(13, 1, 'Fanta 500ml', 'BEB-004', 3.00, 1.80, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(14, 1, 'Inca Kola 1.5L', 'BEB-005', 8.00, 5.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(15, 1, 'Coca Cola 1.5L', 'BEB-006', 8.00, 5.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(16, 1, 'Inca Kola 3L', 'BEB-007', 12.00, 8.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(17, 1, 'Coca Cola 3L', 'BEB-008', 12.00, 8.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(18, 1, 'Agua San Luis 625ml', 'BEB-009', 2.00, 1.20, 40, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(19, 1, 'Agua Cielo 625ml', 'BEB-010', 2.00, 1.20, 40, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(20, 1, 'Agua con Gas 625ml', 'BEB-011', 2.50, 1.50, 25, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(21, 1, 'Gatorade 500ml', 'BEB-012', 4.50, 3.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(22, 1, 'Volt 300ml', 'BEB-013', 4.00, 2.50, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(23, 1, 'Red Bull 250ml', 'BEB-014', 8.00, 5.50, 12, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(24, 1, 'Limonada Natural', 'BEB-015', 5.00, 2.50, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(25, 1, 'Maracuyá Frozen', 'BEB-017', 6.00, 3.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(26, 1, 'Jugo de Naranja', 'BEB-018', 6.00, 3.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(27, 1, 'Jugo de Papaya', 'BEB-019', 6.00, 3.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(42, 2, 'Hamburguesa Royal', 'HAM-003', 16.00, 9.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(43, 2, 'Hamburguesa Bacon', 'HAM-004', 17.00, 10.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(44, 2, 'Hamburguesa BBQ', 'HAM-005', 16.00, 9.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(45, 2, 'Hamburguesa Parrillera', 'HAM-006', 18.00, 11.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(46, 2, 'Hamburguesa Especial', 'HAM-007', 20.00, 12.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(47, 2, 'Hamburguesa Clásica + Papas', 'HAM-008', 16.00, 9.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(48, 2, 'Hamburguesa Doble + Papas', 'HAM-009', 20.00, 12.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(49, 3, 'Torta de Chocolate', 'POS-002', 8.00, 4.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(50, 3, 'Torta de Vainilla', 'POS-003', 7.00, 3.50, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(51, 3, 'Brownie', 'POS-004', 6.00, 3.00, 15, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(52, 3, 'Brownie con Helado', 'POS-005', 10.00, 5.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(53, 3, 'Tres Leches', 'POS-006', 8.00, 4.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(54, 3, 'Flan', 'POS-007', 6.00, 3.00, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(55, 3, 'Cheesecake Maracuyá', 'POS-008', 9.00, 4.50, 10, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(56, 5, 'Pilsen Callao 305ml', 'CER-001', 7.00, 4.50, 48, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(57, 5, 'Pilsen Callao 630ml', 'CER-002', 10.00, 6.50, 36, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(58, 5, 'Cristal 305ml', 'CER-003', 6.00, 4.00, 48, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(59, 5, 'Cristal 630ml', 'CER-004', 9.00, 5.50, 36, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(60, 5, 'Cusqueña Dorada 330ml', 'CER-005', 9.00, 5.50, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(61, 5, 'Cusqueña Negra 330ml', 'CER-006', 9.00, 5.50, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(62, 5, 'Cusqueña Trigo 330ml', 'CER-007', 9.00, 5.50, 30, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(63, 5, 'Corona 355ml', 'CER-008', 11.00, 7.00, 24, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(64, 5, 'Heineken 330ml', 'CER-009', 11.00, 7.00, 24, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(65, 5, 'Pilsen Callao 1L', 'CER-010', 14.00, 9.00, 20, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(71, 6, 'Alquiler mesa de billar - 30 minutos', 'BILL-030', 10.00, NULL, NULL, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(72, 6, 'Alquiler mesa de billar - 1 hora', 'BILL-060', 18.00, NULL, NULL, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(73, 6, 'Alquiler mesa de billar - 2 horas', 'BILL-120', 35.00, NULL, NULL, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(74, 6, 'Alquiler mesa de billar - 3 horas', 'BILL-180', 50.00, NULL, NULL, 1, NULL, 1, '2026-08-19 17:10:15', '2026-08-19 17:10:15'),
	(78, 1, 'Agua San Luis 1L', NULL, 3.50, 1.80, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(79, 1, 'Guaraná 500ml', NULL, 3.00, 1.80, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(80, 1, 'Kola Real 500ml', NULL, 2.50, 1.50, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(81, 1, 'Chicha Morada 500ml', NULL, 4.00, 2.20, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(82, 1, 'Limonada 500ml', NULL, 4.00, 2.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(83, 1, 'Té Helado', NULL, 4.00, 2.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(85, 5, 'Cusqueña Roja 330ml', NULL, 7.00, 4.80, 24, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(86, 5, 'Arequipeña 330ml', NULL, 6.00, 4.00, 24, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(88, 7, 'Salchipapa Clásica', NULL, 12.00, 6.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(89, 7, 'Salchipapa Especial', NULL, 16.00, 8.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(90, 7, 'Salchipollo', NULL, 15.00, 8.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(91, 7, 'Alitas BBQ', NULL, 18.00, 9.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(92, 7, 'Alitas Acevichadas', NULL, 20.00, 10.00, 15, 1, 'products/MEnoIEGAVpLP0jeDY8xPrbUciSYj5YbF2FcjInBK.jpg', 1, '2026-08-19 17:13:44', '2026-08-19 17:18:46'),
	(93, 7, 'Alitas Picantes', NULL, 18.00, 9.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(94, 7, 'Tequeños de Queso', NULL, 12.00, 6.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(95, 7, 'Tequeños con Jamón y Queso', NULL, 15.00, 7.50, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(96, 7, 'Papas Fritas', NULL, 8.00, 3.50, 25, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(97, 7, 'Papas Cheddar', NULL, 13.00, 6.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(98, 7, 'Papas con Tocino', NULL, 15.00, 7.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(99, 7, 'Chicharrón de Pollo', NULL, 18.00, 9.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(100, 7, 'Chicharrón de Cerdo', NULL, 20.00, 10.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(101, 7, 'Nuggets de Pollo', NULL, 12.00, 6.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(102, 7, 'Hot Dog Especial', NULL, 10.00, 5.00, 20, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(103, 7, 'Brochetas de Pollo', NULL, 16.00, 8.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(104, 7, 'Nachos con Queso', NULL, 12.00, 5.50, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(105, 7, 'Mix de Piqueo', NULL, 25.00, 13.00, 10, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(119, 2, 'Hamburguesa Hawaiana', NULL, 17.00, 8.50, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(120, 2, 'Hamburguesa Criolla', NULL, 17.00, 8.50, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(121, 2, 'Hamburguesa Especial de la Casa', NULL, 20.00, 10.00, 15, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(122, 3, 'Pie de Limón', NULL, 8.00, 4.00, 10, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(123, 1, 'Monster Energy 473ml', NULL, 10.00, 7.00, 24, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(124, 1, '360 Energy Drink', NULL, 5.00, 3.00, 24, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(126, 8, 'Combo 2 Cervezas + Piqueo', 'COMBO-01', 20.00, 11.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(127, 8, 'Combo 4 Cervezas + Piqueo', 'COMBO-02', 38.00, 21.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(128, 8, 'Combo Salchipapa + Gaseosa', 'COMBO-03', 15.00, 7.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(129, 8, 'Combo Hamburguesa + Papas + Gaseosa', 'COMBO-04', 20.00, 10.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(130, 8, 'Combo Alitas + Papas + Gaseosa', 'COMBO-05', 25.00, 13.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44'),
	(131, 8, 'Combo Billar 1 Hora + 2 Cervezas', 'COMBO-06', 28.00, 8.00, NULL, 1, NULL, 1, '2026-08-19 17:13:44', '2026-08-19 17:13:44');

-- Volcando estructura para tabla restaurante_db.product_ingredients
CREATE TABLE IF NOT EXISTS `product_ingredients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint unsigned NOT NULL,
  `ingredient_id` bigint unsigned NOT NULL,
  `quantity` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_ingredients_product_id_foreign` (`product_id`),
  KEY `product_ingredients_ingredient_id_foreign` (`ingredient_id`),
  CONSTRAINT `product_ingredients_ingredient_id_foreign` FOREIGN KEY (`ingredient_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_ingredients_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.product_ingredients: ~1 rows (aproximadamente)
INSERT INTO `product_ingredients` (`id`, `product_id`, `ingredient_id`, `quantity`, `created_at`, `updated_at`) VALUES
	(1, 1, 6, 1.00, '2025-12-29 18:11:39', '2025-12-29 18:11:39');

-- Volcando estructura para tabla restaurante_db.reservations
CREATE TABLE IF NOT EXISTS `reservations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reservation_time` datetime NOT NULL,
  `people` int NOT NULL,
  `table_id` bigint unsigned DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','confirmed','cancelled') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reservations_table_id_foreign` (`table_id`),
  CONSTRAINT `reservations_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.reservations: ~3 rows (aproximadamente)

-- Volcando estructura para tabla restaurante_db.role_permissions
CREATE TABLE IF NOT EXISTS `role_permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_permissions_role_permission_id_unique` (`role`,`permission_id`),
  KEY `role_permissions_permission_id_foreign` (`permission_id`),
  CONSTRAINT `role_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.role_permissions: ~31 rows (aproximadamente)
INSERT INTO `role_permissions` (`id`, `role`, `permission_id`, `created_at`, `updated_at`) VALUES
	(24, 'cashier', 1, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(25, 'cashier', 3, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(26, 'cashier', 4, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(27, 'cashier', 5, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(28, 'cashier', 16, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(29, 'waiter', 3, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(30, 'waiter', 4, '2026-08-19 19:33:57', '2026-08-19 19:33:57'),
	(166, 'gerente', 1, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(167, 'gerente', 2, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(168, 'gerente', 3, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(169, 'gerente', 4, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(170, 'gerente', 5, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(171, 'gerente', 6, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(172, 'gerente', 7, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(173, 'gerente', 8, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(174, 'gerente', 9, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(175, 'gerente', 10, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(176, 'gerente', 11, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(177, 'gerente', 12, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(178, 'gerente', 14, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(179, 'gerente', 16, '2026-08-19 15:14:08', '2026-08-19 15:14:08'),
	(191, 'admin', 1, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(192, 'admin', 2, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(193, 'admin', 3, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(194, 'admin', 4, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(195, 'admin', 5, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(196, 'admin', 6, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(197, 'admin', 7, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(198, 'admin', 8, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(199, 'admin', 9, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(200, 'admin', 10, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(201, 'admin', 11, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(202, 'admin', 12, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(203, 'admin', 14, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(204, 'admin', 16, '2026-08-19 15:24:37', '2026-08-19 15:24:37'),
	(205, 'kitchen', 6, '2026-08-19 16:24:32', '2026-08-19 16:24:32');

-- Volcando estructura para tabla restaurante_db.sessions
CREATE TABLE IF NOT EXISTS `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;

-- Volcando datos para la tabla restaurante_db.sessions: ~3 rows (aproximadamente)
INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
	('dzYsy254Kycu23Xs4IpRh9CgEEh9PzlavQ8nn2tg', 11, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiSnFZYzV6VnBVMmJuSnRxdldiSU91UmVHTVo2cjNKMjFMY0pPVjVCUCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly9yZXN0YXVyYW50ZS50ZXN0IjtzOjU6InJvdXRlIjtzOjk6ImRhc2hib2FyZCI7fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjExO30=', 1787158464),
	('l5dRyXFK73WH6bKS6T4j5LAZO9ci2B5i7vGMLUwJ', 11, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36 Edg/151.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVkM0Nm1NWTNabEpFcG9yWlVwVmFPbkU1QlFzZlZCQlEwUDVDU3JONCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyOToiaHR0cDovL3Jlc3RhdXJhbnRlLnRlc3QvdXNlcnMiO31zOjk6Il9wcmV2aW91cyI7YToyOntzOjM6InVybCI7czoyMzoiaHR0cDovL3Jlc3RhdXJhbnRlLnRlc3QiO3M6NToicm91dGUiO3M6OToiZGFzaGJvYXJkIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTE7fQ==', 1787156793),
	('ysPluU4Vqs8cFx9HcjI5sc8XP2CGmn0t9EfEVTSN', 8, '::1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiU2VRN3NHZVdRa1I3SEtnMEJEeFRhdlVZcFZENkZUQ2dCVWVQT3poTSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHA6Ly9sb2NhbGhvc3QvcmVzdGF1cmFudGUvcHVibGljL3BvcyI7czo1OiJyb3V0ZSI7czo5OiJwb3MuaW5kZXgiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo4O30=', 1787159982),
	('zqu1joFHfFJ4K9G2Qlq1CdelzEszzXNqRF3tohxu', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZW45MkF6SjNrTEZUM3BTdzBJR3JjUTM3THdxZktteGhhSXdXY1F5NyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly9yZXN0YXVyYW50ZS50ZXN0L2xvZ2luIjtzOjU6InJvdXRlIjtzOjU6ImxvZ2luIjt9fQ==', 1787160172);

-- Volcando estructura para tabla restaurante_db.settings
CREATE TABLE IF NOT EXISTS `settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.settings: ~7 rows (aproximadamente)
INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
	(1, 'company_name', 'El Gran Tibu', '2025-12-25 23:24:03', '2026-08-18 18:04:06'),
	(2, 'company_address', 'Calle Maquia Victor Haya de la Torre', '2025-12-25 23:24:03', '2026-08-18 18:04:06'),
	(3, 'company_phone', '(01) 555-9992', '2025-12-25 23:24:03', '2025-12-29 20:38:08'),
	(4, 'ticket_footer', '¡Gracias por su preferencia! Vuelva pronto.', '2025-12-25 23:24:03', '2025-12-25 23:24:03'),
	(5, 'currency_symbol', 'S/', '2025-12-25 23:24:03', '2025-12-25 23:32:57'),
	(6, 'company_logo', 'settings/cO4O6M5eUpL90DRidjCu660jw7uuPfcbFQWO4D6J.png', '2025-12-25 23:32:57', '2026-08-19 14:12:27'),
	(7, 'timezone', 'America/Lima', '2025-12-29 22:20:51', '2025-12-29 22:20:51');

-- Volcando estructura para tabla restaurante_db.tables
CREATE TABLE IF NOT EXISTS `tables` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `area_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `seats` int NOT NULL DEFAULT '4',
  `status` enum('available','occupied','reserved') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `x_pos` int NOT NULL DEFAULT '0',
  `y_pos` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tables_area_id_foreign` (`area_id`),
  CONSTRAINT `tables_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.tables: ~15 rows (aproximadamente)
INSERT INTO `tables` (`id`, `area_id`, `name`, `seats`, `status`, `x_pos`, `y_pos`, `created_at`, `updated_at`) VALUES
	(1, 1, 'Mesa 1', 4, 'available', 208, 30, '2025-12-25 21:31:47', '2026-08-19 16:19:00'),
	(2, 1, 'Mesa 2', 4, 'available', 361, 31, '2025-12-25 21:31:47', '2026-08-19 16:19:00'),
	(3, 1, 'Mesa 3', 4, 'available', 520, 31, '2025-12-25 21:31:47', '2026-08-19 16:19:00'),
	(4, 1, 'Mesa 4', 4, 'available', 671, 29, '2025-12-25 21:31:47', '2026-08-19 16:19:00'),
	(5, 1, 'Mesa 5', 4, 'available', 209, 181, '2025-12-25 21:31:47', '2026-08-19 16:19:00'),
	(6, 2, 'T-1', 2, 'available', 29, 11, '2025-12-25 21:31:47', '2025-12-29 19:21:30'),
	(7, 2, 'T-2', 2, 'available', 207, 10, '2025-12-25 21:31:47', '2025-12-29 19:21:30'),
	(8, 2, 'T-3', 2, 'available', 371, 17, '2025-12-25 21:31:47', '2025-12-29 19:21:30'),
	(9, 1, 'Mesa 6', 4, 'available', 362, 178, '2025-12-28 01:24:36', '2026-08-19 16:19:00'),
	(12, 2, 'MESA ESPECIAL 1', 4, 'available', 724, 183, '2025-12-28 07:24:53', '2025-12-29 19:21:30'),
	(13, 1, 'Mesa 7', 4, 'available', 521, 178, '2025-12-28 07:38:28', '2026-08-19 16:19:00'),
	(14, 1, 'MESA ESPECIAL', 4, 'available', 1381, 29, '2025-12-29 20:59:50', '2025-12-29 20:59:56'),
	(15, 1, 'Mesa Aniversario', 4, 'available', 1111, 32, '2025-12-29 21:29:16', '2026-08-19 16:59:41');

-- Volcando estructura para tabla restaurante_db.users
CREATE TABLE IF NOT EXISTS `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,
  `role` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiter',
  `is_system_admin` tinyint(1) NOT NULL DEFAULT '0',
  `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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volcando datos para la tabla restaurante_db.users: ~6 rows (aproximadamente)
INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `is_system_admin`, `remember_token`, `created_at`, `updated_at`) VALUES
	(1, 'Alexander Reyes Mozombite', 'superadmin@admin.com', NULL, '$2y$12$DaPOxP76s3pogDvKd5mVD.2o2MDfbO4unRzrIiihYp2CrxY3WoGb2', 'superadmin', 1, NULL, '2025-12-25 21:31:47', '2026-08-19 16:29:39'),
	(7, 'Administrador del Negocio', 'adminnegocio@admin.com', NULL, '$2y$12$Nn6UF1Cl.8Fa0ncUHkg6te9E08nZGrIGoK6c3uS2SgpNJa3lBWyV2', 'admin', 0, NULL, '2026-08-19 19:33:56', '2026-08-19 16:27:48'),
	(8, 'Elson Aguirre', 'gerente@restaurante.com', NULL, '$2y$12$NnnBB9EzUkf4jP23rsdcPugVO5uFwE8pa7OVbZ0R6WYBrOrh/wWcO', 'gerente', 0, NULL, '2026-08-19 19:33:57', '2026-08-19 16:27:19'),
	(9, 'Cajero Demo', 'cajero@elgrantibu.com', NULL, '$2y$12$uiDZC.088iZWM4t6NKlgM.PROUoxZr44E0PhzNpciSchFIbHV.UNC', 'cashier', 0, NULL, '2026-08-19 19:33:57', '2026-08-19 16:28:25'),
	(10, 'Mozo Demo', 'mozo@elgrantibu.com', NULL, '$2y$12$qxXRzlFQoTYF5KJxCwk60ePxxsUsh2D4FUA33dxUTELZty4Z1PcVi', 'waiter', 0, NULL, '2026-08-19 19:33:57', '2026-08-19 16:28:51'),
	(11, 'Cocina Demo', 'cocina@elgrantibu.com', NULL, '$2y$12$CUQrdBhcQP2kELDilHU13uIZarZwxPdopTQghXG/LOA.ILlkMZ8zi', 'kitchen', 0, NULL, '2026-08-19 19:33:57', '2026-08-19 16:29:13');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
