Tul xxx Tul

Viewing: comidarapida.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 25-01-2026 a las 00:50:00
-- Versión del servidor: 10.4.32-MariaDB
-- Versión de PHP: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `comidarapida`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `admin`
--

CREATE TABLE `admin` (
  `id` int(100) NOT NULL,
  `name` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `role` enum('owner','manager','staff','viewer') NOT NULL DEFAULT 'staff',
  `permissions` text DEFAULT NULL,
  `webauthn_required` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `admin`
--

INSERT INTO `admin` (`id`, `name`, `password`, `role`, `permissions`, `webauthn_required`) VALUES
(5, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'owner', NULL, 0),
(19, 'Mesero', '5a280e11dcd2ad934af4dcb24b2fafc527aa550a', 'staff', '[\"dashboard\",\"dine_in_orders\",\"dine_in_history\",\"delivery_orders\",\"delivery_history\",\"inventory\",\"recipes\",\"products\",\"product_preparers\",\"preparers\",\"profit_reports\",\"profile\"]', 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `admin_webauthn_credentials`
--

CREATE TABLE `admin_webauthn_credentials` (
  `id` int(100) NOT NULL,
  `admin_id` int(100) NOT NULL,
  `credential_id` varbinary(512) NOT NULL,
  `public_key_cose` blob NOT NULL,
  `sign_count` int(11) NOT NULL DEFAULT 0,
  `transports` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `last_used_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `cart`
--

CREATE TABLE `cart` (
  `id` int(100) NOT NULL,
  `user_id` int(100) NOT NULL,
  `pid` int(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` int(10) NOT NULL,
  `quantity` int(10) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `categories`
--

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `categories`
--

INSERT INTO `categories` (`id`, `name`) VALUES
(56, 'Bandeja'),
(59, 'Bebidas'),
(50, 'Hamburguesas'),
(60, 'Maizitos'),
(53, 'Patacones'),
(51, 'Perros Calientes'),
(54, 'Picadas'),
(55, 'Pinchos'),
(58, 'Porción Adicional'),
(57, 'Salchipapas'),
(52, 'Sandwich');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `currencies`
--

CREATE TABLE `currencies` (
  `code` char(3) NOT NULL,
  `name` varchar(140) NOT NULL,
  `symbol` varchar(16) NOT NULL,
  `fraction_size` tinyint(3) UNSIGNED NOT NULL DEFAULT 2,
  `template` varchar(16) NOT NULL DEFAULT '$1',
  `rtl` tinyint(1) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `currencies`
--

INSERT INTO `currencies` (`code`, `name`, `symbol`, `fraction_size`, `template`, `rtl`, `is_active`) VALUES
('AED', 'dírham de los Emiratos Árabes Unidos', '.د.إ', 2, 'AED $1', 1, 1),
('AFN', 'afgani', '؋', 2, 'AFN $1', 1, 1),
('ALL', 'lek', 'Lek', 2, 'ALL $1', 0, 1),
('AMD', 'dram', 'դր.', 2, 'AMD $1', 0, 1),
('ANG', 'florín de las Antillas Neerlandesas', 'NAƒ', 2, 'ANG $1', 0, 1),
('AOA', 'kuanza', 'Kz', 2, 'AOA $1', 0, 1),
('ARS', 'peso argentino', '$', 2, 'ARS $1', 0, 1),
('AUD', 'dólar australiano', 'A$', 2, 'AUD $1', 0, 1),
('AWG', 'florín arubeño', 'Afl', 2, 'AWG $1', 0, 1),
('AZN', 'manat azerí', '₼', 2, 'AZN $1', 0, 1),
('BAM', 'marco convertible de Bosnia-Herzegovina', 'KM', 2, 'BAM $1', 0, 1),
('BBD', 'dólar barbadense', '$', 2, 'BBD $1', 0, 1),
('BDT', 'taka', '৳', 2, 'BDT $1', 0, 1),
('BGN', 'lev búlgaro', 'лв', 2, 'BGN $1', 0, 1),
('BHD', 'dinar bahreiní', '.د.ب', 3, 'BHD $1', 1, 1),
('BIF', 'franco burundés', 'FBu', 0, 'BIF $1', 0, 1),
('BMD', 'dólar de Bermudas', 'BD$', 2, 'BMD $1', 0, 1),
('BND', 'dólar bruneano', '$', 2, 'BND $1', 0, 1),
('BOB', 'boliviano', 'Bs.', 2, 'BOB $1', 0, 1),
('BOV', 'MVDOL boliviano', 'Bov', 2, 'BOV $1', 0, 1),
('BRL', 'real brasileño', 'R$', 2, 'BRL $1', 0, 1),
('BSD', 'dólar bahameño', '$', 2, 'BSD $1', 0, 1),
('BTC', 'BTC', '₿', 4, 'BTC $1', 0, 1),
('BTN', 'gultrum', 'Nu.', 2, 'BTN $1', 0, 1),
('BWP', 'pula', 'P', 2, 'BWP $1', 0, 1),
('BYN', 'rublo bielorruso', 'р.', 2, 'BYN $1', 0, 1),
('BYR', 'rublo bielorruso (2000–2016)', 'р.', 0, 'BYR $1', 0, 1),
('BZD', 'dólar beliceño', 'BZ$', 2, 'BZD $1', 0, 1),
('CAD', 'dólar canadiense', 'CA$', 2, 'CAD $1', 0, 1),
('CDF', 'franco congoleño', 'FC', 2, 'CDF $1', 0, 1),
('CHE', 'euro WIR', 'CHE', 2, 'CHE $1', 0, 1),
('CHF', 'franco suizo', 'fr.', 2, 'CHF $1', 0, 1),
('CHW', 'franco WIR', 'CHW', 2, 'CHW $1', 0, 1),
('CLF', 'unidad de fomento chilena', 'UF', 4, 'CLF $1', 0, 1),
('CLP', 'peso chileno', '$', 0, 'CLP $1', 0, 1),
('CNY', 'yuan', '元', 2, 'CNY $1', 0, 1),
('COP', 'peso colombiano', '$', 0, 'COP $1', 0, 1),
('COU', 'unidad de valor real colombiana', 'COU', 2, 'COU $1', 0, 1),
('CRC', 'colón costarricense', '₡', 2, 'CRC $1', 0, 1),
('CUC', 'peso cubano convertible', 'CUC', 2, 'CUC $1', 0, 1),
('CUP', 'peso cubano', '$MN', 2, 'CUP $1', 0, 1),
('CVE', 'escudo de Cabo Verde', 'esc', 2, 'CVE $1', 0, 1),
('CZK', 'corona checa', 'Kč', 2, 'CZK $1', 0, 1),
('DJF', 'franco yibutiano', 'Fdj', 0, 'DJF $1', 0, 1),
('DKK', 'corona danesa', 'kr', 2, 'DKK $1', 0, 1),
('DOP', 'peso dominicano', 'RD$', 2, 'DOP $1', 0, 1),
('DZD', 'dinar argelino', '.د.ج', 2, 'DZD $1', 1, 1),
('EEK', 'corona estonia', 'kr', 2, 'EEK $1', 0, 1),
('EGP', 'libra egipcia', '.ج.م', 2, 'EGP $1', 1, 1),
('ERN', 'nakfa', 'Nkf', 2, 'ERN $1', 0, 1),
('ETB', 'bir', 'Br', 2, 'ETB $1', 0, 1),
('ETH', 'ETH', 'Ξ', 4, 'ETH $1', 0, 1),
('EUR', 'euro', '€', 2, 'EUR $1', 0, 1),
('FJD', 'dólar fiyiano', 'FJ$', 2, 'FJD $1', 0, 1),
('FKP', 'libra malvinense', '£', 2, 'FKP $1', 0, 1),
('GBP', 'libra británica', '£', 2, 'GBP $1', 0, 1),
('GEL', 'lari', 'GEL', 2, 'GEL $1', 0, 1),
('GGP', 'Guernsey Pound', '£', 2, 'GGP $1', 0, 1),
('GHC', 'cedi ghanés (1979–2007)', '¢', 2, 'GHC $1', 0, 1),
('GHS', 'cedi', 'GH₵', 2, 'GHS $1', 0, 1),
('GIP', 'libra gibraltareña', '£', 2, 'GIP $1', 0, 1),
('GMD', 'dalasi', 'D', 2, 'GMD $1', 0, 1),
('GNF', 'franco guineano', 'GFr', 0, 'GNF $1', 0, 1),
('GTQ', 'quetzal guatemalteco', 'Q', 2, 'GTQ $1', 0, 1),
('GYD', 'dólar guyanés', 'GY$', 2, 'GYD $1', 0, 1),
('HKD', 'dólar hongkonés', 'HK$', 2, 'HKD $1', 0, 1),
('HNL', 'lempira hondureño', 'L', 2, 'HNL $1', 0, 1),
('HRK', 'kuna', 'kn', 2, 'HRK $1', 0, 1),
('HTG', 'gourde haitiano', 'G', 2, 'HTG $1', 0, 1),
('HUF', 'forinto húngaro', 'Ft', 0, 'HUF $1', 0, 1),
('IDR', 'rupia indonesia', 'Rp', 2, 'IDR $1', 0, 1),
('ILS', 'nuevo séquel israelí', '₪', 2, 'ILS $1', 0, 1),
('IMP', 'Manx Pound', '£', 2, 'IMP $1', 0, 1),
('INR', 'rupia india', '₹', 2, 'INR $1', 0, 1),
('IQD', 'dinar iraquí', '.د.ع', 3, 'IQD $1', 1, 1),
('IRR', 'rial iraní', '﷼', 0, 'IRR $1', 1, 1),
('ISK', 'corona islandesa', 'kr', 2, 'ISK $1', 0, 1),
('JEP', 'Jersey Pound', '£', 2, 'JEP $1', 0, 1),
('JMD', 'dólar jamaicano', 'J$', 2, 'JMD $1', 0, 1),
('JOD', 'dinar jordano', '.د.إ', 3, 'JOD $1', 1, 1),
('JPY', 'yen', '¥', 0, 'JPY $1', 0, 1),
('KES', 'chelín keniano', 'KSh', 2, 'KES $1', 0, 1),
('KGS', 'som', 'сом', 2, 'KGS $1', 0, 1),
('KHR', 'riel', '៛', 2, 'KHR $1', 0, 1),
('KMF', 'franco comorense', 'CF', 0, 'KMF $1', 0, 1),
('KPW', 'won norcoreano', '₩', 0, 'KPW $1', 0, 1),
('KRW', 'won surcoreano', '₩', 0, 'KRW $1', 0, 1),
('KWD', 'dinar kuwaití', '.د.ك', 3, 'KWD $1', 1, 1),
('KYD', 'dólar de las Islas Caimán', 'CI$', 2, 'KYD $1', 0, 1),
('KZT', 'tenge kazako', '₸', 2, 'KZT $1', 0, 1),
('LAK', 'kip', '₭', 2, 'LAK $1', 0, 1),
('LBP', 'libra libanesa', '.ل.ل', 2, 'LBP $1', 1, 1),
('LKR', 'rupia esrilanquesa', '₨', 2, 'LKR $1', 0, 1),
('LRD', 'dólar liberiano', 'L$', 2, 'LRD $1', 0, 1),
('LSL', 'loti lesothense', 'LSL', 2, 'LSL $1', 0, 1),
('LTC', 'LTC', 'Ł', 4, 'LTC $1', 0, 1),
('LTL', 'litas lituano', 'Lt', 2, 'LTL $1', 0, 1),
('LVL', 'lats letón', 'Ls', 2, 'LVL $1', 0, 1),
('LYD', 'dinar libio', '.د.ل', 3, 'LYD $1', 1, 1),
('MAD', 'dírham marroquí', '.د.م', 2, 'MAD $1', 1, 1),
('MDL', 'leu moldavo', 'lei', 2, 'MDL $1', 0, 1),
('MGA', 'ariari', 'Ar', 1, 'MGA $1', 0, 1),
('MKD', 'dinar macedonio', 'ден', 2, 'MKD $1', 0, 1),
('MMK', 'kiat', 'K', 2, 'MMK $1', 0, 1),
('MNT', 'tugrik', '₮', 2, 'MNT $1', 0, 1),
('MOP', 'pataca de Macao', 'MOP$', 2, 'MOP $1', 0, 1),
('MRO', 'uguiya', 'ouguiya', 2, 'MRO $1', 0, 1),
('MUR', 'rupia mauriciana', '₨', 2, 'MUR $1', 0, 1),
('MVR', 'rufiya', 'MVR', 2, 'MVR $1', 0, 1),
('MWK', 'kwacha malauí', 'MK', 2, 'MWK $1', 0, 1),
('MXN', 'peso mexicano', '$', 2, 'MXN $1', 0, 1),
('MXV', 'unidad de inversión (UDI) mexicana', 'UDI', 2, 'MXV $1', 0, 1),
('MYR', 'ringit', 'RM', 2, 'MYR $1', 0, 1),
('MZN', 'metical', 'MT', 2, 'MZN $1', 0, 1),
('NAD', 'dólar namibio', 'N$', 2, 'NAD $1', 0, 1),
('NGN', 'naira', '₦', 2, 'NGN $1', 0, 1),
('NIO', 'córdoba nicaragüense', 'C$', 2, 'NIO $1', 0, 1),
('NOK', 'corona noruega', 'kr', 2, 'NOK $1', 0, 1),
('NPR', 'rupia nepalí', '₨', 2, 'NPR $1', 0, 1),
('NZD', 'dólar neozelandés', 'NZ$', 2, 'NZD $1', 0, 1),
('OMR', 'rial omaní', '.ر.ع', 3, 'OMR $1', 1, 1),
('PAB', 'balboa panameño', 'B/.', 2, 'PAB $1', 0, 1),
('PEN', 'sol peruano', 'S/', 2, 'PEN $1', 0, 1),
('PGK', 'kina', 'K', 2, 'PGK $1', 0, 1),
('PHP', 'peso filipino', '₱', 2, 'PHP $1', 0, 1),
('PKR', 'rupia pakistaní', '₨', 2, 'PKR $1', 0, 1),
('PLN', 'esloti', 'zł', 2, 'PLN $1', 0, 1),
('PYG', 'guaraní paraguayo', 'Gs', 0, 'PYG $1', 0, 1),
('QAR', 'rial catarí', '.ر.ق', 2, 'QAR $1', 1, 1),
('RON', 'leu rumano', 'lei', 2, 'RON $1', 0, 1),
('RSD', 'dinar serbio', 'Дин.', 2, 'RSD $1', 0, 1),
('RUB', 'rublo ruso', '₽', 2, 'RUB $1', 0, 1),
('RUR', 'rublo ruso (1991–1998)', '₽', 2, 'RUR $1', 0, 1),
('RWF', 'franco ruandés', 'R₣', 0, 'RWF $1', 0, 1),
('SAR', 'rial saudí', '.ر.س', 2, 'SAR $1', 1, 1),
('SBD', 'dólar salomonense', 'SI$', 2, 'SBD $1', 0, 1),
('SCR', 'rupia seychellense', '₨', 2, 'SCR $1', 0, 1),
('SDG', 'libra sudanesa', 'SDG', 2, 'SDG $1', 0, 1),
('SEK', 'corona sueca', 'kr', 2, 'SEK $1', 0, 1),
('SGD', 'dólar singapurense', 'S$', 2, 'SGD $1', 0, 1),
('SHP', 'libra de Santa Elena', '£', 2, 'SHP $1', 0, 1),
('SLL', 'leona', 'Le', 2, 'SLL $1', 0, 1),
('SOS', 'chelín somalí', 'S', 2, 'SOS $1', 0, 1),
('SRD', 'dólar surinamés', '$', 2, 'SRD $1', 0, 1),
('SSP', 'libra sursudanesa', 'SS£', 2, 'SSP $1', 0, 1),
('STD', 'dobra', 'Db', 2, 'STD $1', 0, 1),
('SVC', 'colón salvadoreño', 'C', 2, 'SVC $1', 0, 1),
('SYP', 'libra siria', '.ل.س', 2, 'SYP $1', 1, 1),
('SZL', 'lilangeni', 'L', 2, 'SZL $1', 0, 1),
('THB', 'bat', '฿', 2, 'THB $1', 0, 1),
('TJS', 'somoni tayiko', 'SM', 2, 'TJS $1', 0, 1),
('TMT', 'manat turcomano', 'T', 2, 'TMT $1', 0, 1),
('TND', 'dinar tunecino', '.د.ت', 3, 'TND $1', 1, 1),
('TOP', 'paanga', 'T$', 2, 'TOP $1', 0, 1),
('TRL', 'lira turca (1922–2005)', '₤', 2, 'TRL $1', 0, 1),
('TRY', 'lira turca', '₺', 2, 'TRY $1', 0, 1),
('TTD', 'dólar de Trinidad y Tobago', 'TT$', 2, 'TTD $1', 0, 1),
('TWD', 'nuevo dólar taiwanés', 'NT$', 0, 'TWD $1', 0, 1),
('TZS', 'chelín tanzano', 'TSh', 0, 'TZS $1', 0, 1),
('UAH', 'grivna', '₴', 2, 'UAH $1', 0, 1),
('UGX', 'chelín ugandés', 'USh', 0, 'UGX $1', 0, 1),
('USD', 'dólar estadounidense', 'US$', 2, 'USD $1', 0, 1),
('USN', 'dólar estadounidense (día siguiente)', '$', 2, 'USN $1', 0, 1),
('UYI', 'peso uruguayo en unidades indexadas', '$U', 0, 'UYI $1', 0, 1),
('UYU', 'peso uruguayo', '$U', 0, 'UYU $1', 0, 1),
('UZS', 'sum', 'so’m', 2, 'UZS $1', 0, 1),
('VEF', 'bolívar venezolano', 'Bs', 2, 'VEF $1', 0, 1),
('VES', 'Bolivar', 'Bs', 2, 'VES $1', 0, 1),
('VND', 'dong', '₫', 0, 'VND $1', 0, 1),
('VUV', 'vatu', 'VT', 0, 'VUV $1', 0, 1),
('WST', 'tala', 'WS$', 2, 'WST $1', 0, 1),
('XAF', 'franco CFA BEAC', 'FCFA', 0, 'XAF $1', 0, 1),
('XCD', 'dólar del Caribe Oriental', 'EC$', 2, 'XCD $1', 0, 1),
('XDR', 'SDR (Special Drawing Right)', 'SDR', 0, 'XDR $1', 0, 1),
('XOF', 'franco CFA BCEAO', 'CFA', 0, 'XOF $1', 0, 1),
('XPF', 'franco CFP', '₣', 0, 'XPF $1', 0, 1),
('XSU', 'Sucre', 'XSU', 0, 'XSU $1', 0, 1),
('XUA', 'ADB Unit of Account', 'XUA', 0, 'XUA $1', 0, 1),
('YER', 'rial yemení', '.ر.ي', 2, 'YER $1', 1, 1),
('ZAR', 'rand', 'R', 2, 'ZAR $1', 0, 1),
('ZMW', 'kuacha zambiano', 'K', 2, 'ZMW $1', 0, 1),
('ZWD', 'dólar de Zimbabue', 'Z$', 2, 'ZWD $1', 0, 1),
('ZWL', 'dólar zimbabuense', 'Z$', 2, 'ZWL $1', 0, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `delivery_orders`
--

CREATE TABLE `delivery_orders` (
  `id` int(100) NOT NULL,
  `order_number` int(100) NOT NULL,
  `customer_name` varchar(100) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `payment_method` enum('efectivo','transferencia') NOT NULL,
  `notes` text DEFAULT NULL,
  `order_items` text NOT NULL,
  `total_amount` decimal(10,2) NOT NULL,
  `status` enum('pendiente','en_preparacion','en_camino','entregado','cancelado') NOT NULL DEFAULT 'pendiente',
  `inventory_deducted` tinyint(1) NOT NULL DEFAULT 0,
  `preparer_id` int(100) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `delivery_orders`
--

INSERT INTO `delivery_orders` (`id`, `order_number`, `customer_name`, `phone`, `address`, `payment_method`, `notes`, `order_items`, `total_amount`, `status`, `inventory_deducted`, `preparer_id`, `created_at`, `updated_at`) VALUES
(36, 1, 'Wilmer Rivas', '305982371', 'Cl. 17 #5-30', 'efectivo', '', '[{\"id\":210,\"nombre\":\"Hamburguesa Chuleta\",\"precio\":13000,\"coste\":13000,\"cantidad\":1},{\"id\":241,\"nombre\":\"Pinchos Carne\",\"precio\":15000,\"coste\":15000,\"cantidad\":1}]', 28000.00, 'entregado', 1, NULL, '2026-01-19 16:45:35', '2026-01-19 16:47:29'),
(37, 2, 'Nevin Paredes', '3119020391', 'Unicentro Segundo Piso, local 32', 'transferencia', '', '[{\"id\":208,\"nombre\":\"Hamburguesa Mixta\",\"precio\":16000,\"coste\":16000,\"cantidad\":1},{\"id\":223,\"nombre\":\"Chuzo Pan\",\"precio\":12000,\"coste\":12000,\"cantidad\":1}]', 28000.00, 'pendiente', 0, NULL, '2026-01-19 16:46:23', NULL),
(41, 3, 'Daniel Alexander Contreras Rojas', '3909182309', 'Cl. 17 #5-30', 'efectivo', '', '[{\"id\":243,\"nombre\":\"Bandeja Carne\",\"precio\":16000,\"coste\":16000,\"cantidad\":1}]', 16000.00, 'pendiente', 0, NULL, '2026-01-20 00:45:08', NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `delivery_order_items`
--

CREATE TABLE `delivery_order_items` (
  `id` int(100) NOT NULL,
  `order_id` int(100) NOT NULL,
  `product_id` int(100) NOT NULL,
  `product_name` varchar(100) NOT NULL,
  `quantity` int(10) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `delivery_order_items`
--

INSERT INTO `delivery_order_items` (`id`, `order_id`, `product_id`, `product_name`, `quantity`, `price`, `cost_price`, `subtotal`) VALUES
(115, 36, 210, 'Hamburguesa Chuleta', 1, 13000.00, 13000.00, 13000.00),
(116, 36, 241, 'Pinchos Carne', 1, 15000.00, 15000.00, 15000.00),
(117, 37, 208, 'Hamburguesa Mixta', 1, 16000.00, 16000.00, 16000.00),
(118, 37, 223, 'Chuzo Pan', 1, 12000.00, 12000.00, 12000.00),
(127, 41, 243, 'Bandeja Carne', 1, 16000.00, 16000.00, 16000.00);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `delivery_order_preparers`
--

CREATE TABLE `delivery_order_preparers` (
  `id` int(100) NOT NULL,
  `order_id` int(100) NOT NULL,
  `preparer_id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `delivery_zones`
--

CREATE TABLE `delivery_zones` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `delivery_zones`
--

INSERT INTO `delivery_zones` (`id`, `name`, `fee`, `is_active`, `created_at`, `updated_at`) VALUES
(15, 'Plaza Santander', 1000.00, 1, '2026-01-19 02:21:54', '2026-01-19 02:21:54');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `dine_in_orders`
--

CREATE TABLE `dine_in_orders` (
  `id` int(100) NOT NULL,
  `order_number` int(100) NOT NULL,
  `table_number` varchar(20) NOT NULL,
  `customer_name` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `payment_status` enum('pagada','no_pagada') NOT NULL DEFAULT 'no_pagada',
  `order_status` enum('en_preparacion','entregada','cancelada') NOT NULL DEFAULT 'en_preparacion',
  `preparer_id` int(100) DEFAULT NULL,
  `total_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `delivered_at` datetime DEFAULT NULL,
  `inventory_deducted` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `dine_in_orders`
--

INSERT INTO `dine_in_orders` (`id`, `order_number`, `table_number`, `customer_name`, `notes`, `payment_status`, `order_status`, `preparer_id`, `total_amount`, `created_at`, `updated_at`, `delivered_at`, `inventory_deducted`) VALUES
(28, 1, 'Mesa 6', 'Nevin Paredes', NULL, 'pagada', 'entregada', NULL, 19000.00, '2026-01-18 15:28:07', '2026-01-19 13:10:32', '2026-01-19 01:54:52', 1),
(30, 2, 'Mesa 2', 'Daniel Contreras', NULL, 'pagada', 'entregada', NULL, 18000.00, '2026-01-19 12:15:54', '2026-01-19 13:10:32', '2026-01-19 12:43:22', 1),
(31, 3, 'Mesa 3', 'Manuel Gero', NULL, 'no_pagada', 'cancelada', NULL, 24000.00, '2026-01-19 12:44:34', '2026-01-19 15:20:34', NULL, 0),
(32, 4, 'Mesa 12', 'Wilmer Rivas', NULL, 'pagada', 'en_preparacion', 4, 18000.00, '2026-01-19 14:36:07', '2026-01-19 14:36:19', NULL, 0),
(33, 5, 'Mesa 3', 'Daniel Contreras', NULL, 'pagada', 'en_preparacion', NULL, 16000.00, '2026-01-20 00:39:57', '2026-01-20 00:39:57', NULL, 0);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `dine_in_order_items`
--

CREATE TABLE `dine_in_order_items` (
  `id` int(100) NOT NULL,
  `order_id` int(100) NOT NULL,
  `product_id` int(100) DEFAULT NULL,
  `product_name` varchar(150) NOT NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` decimal(10,2) NOT NULL,
  `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `subtotal` decimal(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `dine_in_order_items`
--

INSERT INTO `dine_in_order_items` (`id`, `order_id`, `product_id`, `product_name`, `quantity`, `unit_price`, `cost_price`, `subtotal`) VALUES
(106, 28, 243, 'Bandeja Carne', 1, 16000.00, 16000.00, 16000.00),
(107, 28, 261, 'Bebida Personal', 1, 3000.00, 3000.00, 3000.00),
(112, 30, 246, 'Bandeja Chuleta', 1, 16000.00, 16000.00, 16000.00),
(113, 30, 260, 'Bebida de Bebé', 1, 2000.00, 2000.00, 2000.00),
(118, 32, NULL, 'Mega Sandwich ', 1, 18000.00, 18000.00, 18000.00),
(119, 31, 210, 'Hamburguesa Chuleta', 1, 13000.00, 13000.00, 13000.00),
(120, 31, 255, 'Huevo Frito', 1, 2000.00, 2000.00, 2000.00),
(121, 31, 264, 'Mega 3 L', 1, 9000.00, 9000.00, 9000.00),
(122, 33, 243, 'Bandeja Carne', 1, 16000.00, 16000.00, 16000.00);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `dine_in_order_preparers`
--

CREATE TABLE `dine_in_order_preparers` (
  `id` int(100) NOT NULL,
  `order_id` int(100) NOT NULL,
  `preparer_id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `dine_in_order_preparers`
--

INSERT INTO `dine_in_order_preparers` (`id`, `order_id`, `preparer_id`) VALUES
(30, 32, 4);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ingredients`
--

CREATE TABLE `ingredients` (
  `id` int(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `unit` varchar(20) NOT NULL DEFAULT 'u',
  `stock_min` decimal(12,3) NOT NULL DEFAULT 0.000,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `ingredients`
--

INSERT INTO `ingredients` (`id`, `name`, `description`, `unit`, `stock_min`, `is_active`) VALUES
(3, 'Queso mozzarella', NULL, 'Unidad', 5.000, 1),
(4, 'Aceites de Palma', 'Aceite para la cocina', 'Litro', 2.000, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `inventory_movements`
--

CREATE TABLE `inventory_movements` (
  `id` int(100) NOT NULL,
  `ingredient_id` int(100) NOT NULL,
  `movement_type` enum('in','out','adjust') NOT NULL,
  `quantity` decimal(12,3) NOT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `admin_id` int(100) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `inventory_movements`
--

INSERT INTO `inventory_movements` (`id`, `ingredient_id`, `movement_type`, `quantity`, `notes`, `admin_id`, `created_at`) VALUES
(1, 3, 'in', 10.000, 'Compra de queso', 5, '2026-01-18 23:06:06'),
(2, 3, 'out', 2.000, 'Comanda #28', 5, '2026-01-19 01:54:52'),
(4, 4, 'in', 30.000, 'Stock inicial', 5, '2026-01-20 00:01:43'),
(6, 4, 'in', 10.000, 'Compra al proveedor', 5, '2026-01-20 11:37:36');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `messages`
--

CREATE TABLE `messages` (
  `id` int(100) NOT NULL,
  `user_id` int(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `number` varchar(12) NOT NULL,
  `message` varchar(500) NOT NULL,
  `message_type` enum('contact','local_order','delivery_order') NOT NULL DEFAULT 'contact',
  `status` enum('pendiente','entregado') NOT NULL DEFAULT 'pendiente',
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `orders`
--

CREATE TABLE `orders` (
  `id` int(100) NOT NULL,
  `user_id` int(100) NOT NULL,
  `name` varchar(20) NOT NULL,
  `number` varchar(10) NOT NULL,
  `email` varchar(50) NOT NULL,
  `method` varchar(50) NOT NULL,
  `address` varchar(500) NOT NULL,
  `total_products` varchar(1000) NOT NULL,
  `total_price` int(100) NOT NULL,
  `placed_on` date NOT NULL DEFAULT current_timestamp(),
  `payment_status` varchar(20) NOT NULL DEFAULT 'pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `preparers`
--

CREATE TABLE `preparers` (
  `id` int(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `status` enum('activo','inactivo') NOT NULL DEFAULT 'activo',
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `preparers`
--

INSERT INTO `preparers` (`id`, `name`, `phone`, `status`, `created_at`, `updated_at`) VALUES
(4, 'Johan Peñuela', '3502398120', 'activo', '2026-01-19 12:48:02', '2026-01-19 12:48:02');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `products`
--

CREATE TABLE `products` (
  `id` int(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `sale_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `image` varchar(100) NOT NULL,
  `description` text DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `products`
--

INSERT INTO `products` (`id`, `name`, `price`, `sale_price`, `image`, `description`, `category`, `is_active`) VALUES
(206, 'Hamburguesa Sencilla', 12000.00, 12000.00, 'hamburguesa-sencilla-6952a002a80313.59041737.jpg', 'Carne, Pollo', 50, 1),
(207, 'Hamburguesa Doble Carne', 14000.00, 14000.00, '29cc8e-aaad1f9b690b4176a0cef213b971f787-mv2-696eb03560e325.94512718.jpg', 'Doble carne, vegetales y salsas', 50, 1),
(208, 'Hamburguesa Mixta', 16000.00, 16000.00, 'ufjleexyl9s8paapd-2400-x-696eb052d35513.06898020.webp', 'Carne, Pollo', 50, 1),
(209, 'Hamburguesa Doble Pollo', 16000.00, 16000.00, 'delicious-double-chicken-burger-melted-600nw-2668545411-696eb0a3eb80f6.96151881.webp', 'Doble pollo, vegetales y salsas', 50, 1),
(210, 'Hamburguesa Chuleta', 13000.00, 13000.00, 'hamburguesa-especial-696eb12fd5c464.55670816.jpg', 'Chuleta, vegetales y salsas', 50, 1),
(211, 'Hamburguesa Triple Carne', 16000.00, 16000.00, 'homemade-burger-triple-fried-chicken-600nw-2485964573-696eb172ee5196.36842202.webp', 'Triple carne, vegetales y salsas', 50, 1),
(212, 'Hamburguesa Ranchera', 16000.00, 16000.00, 'xqaamaxbuffttonukmammoyooa-696eb6d4a10e90.49910445.jpg', 'Carne, Maíz, Tocineta y Chorizo', 50, 1),
(213, 'Hamburguesa Super Especial', 17000.00, 17000.00, 'hamburguesa-super-especial-1536x1536-696eb70a88f7e3.39610922.webp', 'Dos Carnes y Pollo', 50, 1),
(214, 'Mega Hamburguesa', 22000.00, 22000.00, 'mega-burger-696eb72ca259e5.29631141.jpg', 'Dos Carnes, Pollo, Tocineta y Porción de Papas', 50, 1),
(215, 'Hamburguesa Todo Terreno', 25000.00, 25000.00, 'todoterreno-696eb76280b774.12130637.jpg', 'Dos Carnes, Dos Pollos, Tocineta y Porción de Papas', 50, 1),
(216, 'Perro Sencillo', 8000.00, 8000.00, 'rgg-9154-6952a34c0ff071.81918316.jpg', 'Salchicha Americana', 51, 1),
(217, 'Perro de Carne', 10000.00, 10000.00, 'istockphoto-155284812-612x612-696edcd936e340.57429656.jpg', 'Con carne, papitas y salsas', 51, 1),
(218, 'Perro de Pollo', 10000.00, 10000.00, 'dsc05188-48403023-20250724171149-696ede8970d282.73397248.webp', 'Con pollo, papitas y salsas', 51, 1),
(219, 'Perro de Tocineta', 12000.00, 12000.00, 'colosperrosdelmono-1675777013143-696ede35d089f3.18257610.jpg', 'Con tocineta, papitas y salsas', 51, 1),
(220, 'Perro Ranchero', 14000.00, 14000.00, 'perro-con-tocineta-300x300-696edecbd00740.06446309.jpg', 'Maíz, Tocineta y Chorizo', 51, 1),
(221, 'Perro Super Especial', 14000.00, 14000.00, 'venezuelan-hot-dogs-by-enrilemoine-1-680x1020-696edf5ab3bfd6.97084702.jpg', 'Carne y Pollo', 51, 1),
(222, 'Mega Perro', 20000.00, 20000.00, 'bora-696edf8fa97ac0.35555186.jpg', 'Carne, Pollo, Tocineta y Porción de Papas', 51, 1),
(223, 'Chuzo Pan', 12000.00, 12000.00, '6778825-orig-696ee01de92511.40149174.png', 'Carne o Pollo', 51, 1),
(224, 'Chuzo Pan Mixto', 15000.00, 15000.00, 'erbaltkwaaapmmx-696ee121899710.70904496.jpg', 'Carne y pollo en pan, con salsas', 51, 1),
(225, 'Sandwich Sencillo', 10000.00, 10000.00, 'sandwich-mixto-696f03640105f6.59731819.jpg', 'Pan, jamon y queso', 52, 1),
(226, 'Sandwich Mixto', 14000.00, 14000.00, 'receta-sandwich-de-pollo-a-la-mostaza-bimbo-6952a6aadc2ab4.99719032.jpg', 'Carne o pollo, jamon y queso', 52, 1),
(227, 'Sandwich Doble Pollo', 14000.00, 14000.00, '1000-f-299312640-j9d0ylsstdtrqzh69kjs6x9szatpgirq-696f06b92249d5.25012506.jpg', 'Doble pollo, jamon y queso', 52, 1),
(228, 'Sandwich Super Especial', 16000.00, 16000.00, 'sanduches10-1663679597478-696f074163abe7.24910159.jpg', 'Doble Pollo y Carne', 52, 1),
(230, 'Sandwich Todo Terreno', 20000.00, 20000.00, 'subway-6-inch-ham-submarine-sandwich-696f0a1e259ab5.37933793.jpg', 'Carne y pollo, jamon, queso y salsas', 52, 1),
(231, 'Patacón Carne', 15000.00, 15000.00, 'maxresdefault-6952a8b9c4b668.89141281.jpg', 'Patacón con carne, queso y salsas', 53, 1),
(232, 'Patacón Pollo', 15000.00, 15000.00, 'patacones-lauchire-a-696edb9ee8f4a8.35542891.webp', 'Patacón con pollo, queso y salsas', 53, 1),
(233, 'Patacón Mixto', 18000.00, 18000.00, '9hhuthzx2buzcoh5j-2400-x-696edc23cabc67.76674003.webp', 'Carne, Pollo', 53, 1),
(234, 'Mega Patacón', 20000.00, 20000.00, 'patacon-mixto-1-696edc5b5396d2.76554552.jpg', 'Patacón grande con carne y pollo', 53, 1),
(235, 'Patacón Ranchero', 18000.00, 18000.00, 'nthgkjslenbfmel3g-2400-x-696edc835bd779.95729988.webp', 'Patacón con maiz, tocineta y chorizo', 53, 1),
(236, 'Picada Personal', 25000.00, 25000.00, 'php0byea0-picada-solo-chorizo-696ee2076e5c11.67635894.jpg', '1 Persona', 54, 1),
(237, 'Picada Mediana', 40000.00, 40000.00, 'picada-1508-1-696ee2af874db5.75594294.jpg', '2 Personas', 54, 1),
(238, 'Picada Grande', 55000.00, 55000.00, 'picada-gourmet-mediana-02-scaled-696ee26716ca51.82837273.jpg', '3 Personas', 54, 1),
(239, 'Picada Familiar', 70000.00, 70000.00, 'picada-colombiana-2990-6952aa70b2ea56.95177396.jpg', '5 Personas', 54, 1),
(240, 'Pinchos Pollo', 15000.00, 15000.00, 'marzo23-v55-pinchosdepolloespeciados-02-696ee360950b08.44079020.jpg', 'Pincho de pollo, con salsas', 55, 1),
(241, 'Pinchos Carne', 15000.00, 15000.00, 'carne-en-palito-o-chuzos-6952ab46de42b0.86622401.jpg', 'Pincho de carne, con salsas', 55, 1),
(242, 'Pinchos Mixto', 17000.00, 17000.00, 'pincho-mixto-pechuga-696ee3be3ad0e9.66151420.jpg', 'Pincho mixto de carne y pollo', 55, 1),
(243, 'Bandeja Carne', 16000.00, 16000.00, 'carne-696eacc4e3fbc9.12738079.jpg', 'Carne a la plancha con acompañamiento', 56, 1),
(244, 'Bandeja Pollo', 16000.00, 16000.00, 'bandeja-con-pollo-granpollo-696ead2b83f998.73085397.jpg', 'Pollo a la plancha con acompañamiento', 56, 1),
(245, 'Bandeja Mixta', 20000.00, 20000.00, 'bandeja-paisa-1024x683-6952ad0e4d4413.08091309.jpg', 'Carne y pollo con acompañamiento', 56, 1),
(246, 'Bandeja Chuleta', 16000.00, 16000.00, 'bar-la-aguacatala-696ead86951a80.81429835.jpg', 'Chuleta con acompañamiento', 56, 1),
(247, 'Salchipapa', 15000.00, 15000.00, 'emplatado-final-de-las-salchipapas-6952af57a9ecf1.75209617.jpg', 'Salchicha con papas y salsas', 57, 1),
(248, 'Choripapa', 15000.00, 15000.00, 'd99f642338164b5c2ccc34be7487efca-choripapas-696ee5bea5f687.45233216.png', 'Chorizo con papas y salsas', 57, 1),
(249, 'Salchipollo', 18000.00, 18000.00, 'salchipollo-peruano-78181-orig-696ee70a714698.65216923.jpg', 'Salchicha, pollo y papas', 57, 1),
(251, 'Salchipollo Especial', 20000.00, 20000.00, 'phpajq30k-5764607862018671771-petroski-food-25-salchipollo-696ee875787569.23118653.jpg', 'Salchipollo con queso y salsas', 57, 1),
(252, 'Salchipollo Ranchero', 22000.00, 22000.00, 'salchipapa-rustica-hamburguesa-interna-696ee8adf1b377.99894955.jpg', 'Salchipollo con maiz, tocineta y chorizo', 57, 1),
(253, 'Porción de Papas', 6000.00, 6000.00, 'porcion-de-papas-6952b08c81f915.56477703.webp', 'Papas a la francesa', 58, 1),
(254, 'Porción de Tocineta', 2000.00, 2000.00, 'tocino-productos-oms-principales-causantes-6952b0c63fbff1.15223933.jpeg', 'Tocineta crocante', 58, 1),
(255, 'Huevo Frito', 2000.00, 2000.00, '52-6952b1893ea363.71817721.jpg', 'Huevo frito', 58, 1),
(256, 'Porción Huevo de Codorniz', 4000.00, 4000.00, 'como-cocer-huevos-de-codorniz-6952b2579a7f76.33708125.jpg', 'Huevos de codorniz', 58, 1),
(257, 'Porción de Carne', 3000.00, 3000.00, 'carne-frita-web-jpg-6952b45f5c8185.65753668.webp', 'Porción extra de carne', 58, 1),
(258, 'Porción de Pollo', 3000.00, 3000.00, 'cnne-609038-pollo-frito-muerte-salud-6952b4aaf05ff0.63736758.jpg', 'Porción extra de pollo', 58, 1),
(259, 'Papas Locas', 12000.00, 12000.00, '43451-6952b57168b018.20840206.jpg', 'Maíz, Queso y Tocineta', 58, 1),
(260, 'Malteadas', 2000.00, 2000.00, 'pngtree-chocolate-milkshake-png-image-13321772-696eaec448fc05.30708016.png', 'Malteada fría', 59, 1),
(261, 'Bebida Personal', 3000.00, 3000.00, 'coca-cola-330-01-6952b68dee2ad3.09922220.webp', 'Bebida personal', 59, 1),
(262, 'Gaseosa de 1 L', 5000.00, 5000.00, '000000000000144915-un-02-6952b7581ee0c4.62320165.webp', 'Gaseosa 1 litro', 59, 1),
(263, 'Bebida Plástica 1.5 L', 6000.00, 6000.00, '1562584-800-auto-6952b79cdf3f93.89368996.webp', 'Gaseosa 1.5 litros', 59, 1),
(264, 'Gaseosa Mega 3 L', 9000.00, 9000.00, 'megamanzana-600x432-6952b839033d04.77741559.jpg', 'Gaseosa 3 litros', 59, 1),
(265, 'Plástica 2.5 L', 8000.00, 8000.00, '60899312a6e66053643348-6952b8f7cedf36.62944587.webp', 'Gaseosa 2.5 litros', 59, 1),
(266, 'Hit 1 L', 4500.00, 4500.00, 'hit-6952b94279f9f3.76372532.png', 'Jugo Hit 1 litro', 59, 1),
(267, 'Hit Plástico', 6000.00, 6000.00, 'bebida-hit-x1lt-mora-tetra-6952b98d6499b8.01429879.jpg', 'Jugo Hit 1 litro plástico', 59, 1),
(268, 'Jugos Naturales', 7000.00, 7000.00, 'mg-1088-6952b9cae52ca5.12631238.jpg', 'Jugo natural en agua o leche', 59, 1),
(269, 'Maicito Carne', 13000.00, 13000.00, 'maicito-pollo-300x300-696eb8d110f771.42968813.jpg', 'Maicito con carne y queso', 60, 1),
(270, 'Maicito Pollo', 13000.00, 13000.00, 'maicito-lomito-y-pollo-696ebaca4c6b31.82802962.jpg', 'Maicito con pollo y queso', 60, 1),
(271, 'Maicito Mixto', 15000.00, 15000.00, 'interna-maicitos-divertidos-590x500-6952bbdae38de7.78007894.jpg', 'Maicito mixto de carne y pollo', 60, 1),
(272, 'Maicito Ranchero', 13000.00, 13000.00, 'maicito-especial-lleva-696ed781374597.28079456.jpg', 'Maicito con maiz, tocineta y chorizo', 60, 1),
(273, 'Mega Maicito', 20000.00, 20000.00, 'maicitos-gratinados-destacada-696ed8502f2311.77106110.png', 'Maicito grande para compartir', 60, 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `product_ingredients`
--

CREATE TABLE `product_ingredients` (
  `id` int(100) NOT NULL,
  `product_id` int(100) NOT NULL,
  `ingredient_id` int(100) NOT NULL,
  `quantity` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `product_ingredients`
--

INSERT INTO `product_ingredients` (`id`, `product_id`, `ingredient_id`, `quantity`) VALUES
(4, 243, 3, '2');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `product_preparers`
--

CREATE TABLE `product_preparers` (
  `id` int(100) NOT NULL,
  `product_id` int(100) NOT NULL,
  `preparer_id` int(100) NOT NULL,
  `is_primary` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `settings`
--

CREATE TABLE `settings` (
  `setting_key` varchar(64) NOT NULL,
  `setting_value` text DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `settings`
--

INSERT INTO `settings` (`setting_key`, `setting_value`, `updated_at`) VALUES
('business_address', 'Av. 6 , #17-77, Barrio La Cabrera, Cúcuta, Norte de Santander, Colombia.', '2026-01-22 15:06:19'),
('business_hours', 'Todos los días: 4:30 PM - 11:30 PM', '2026-01-22 15:06:19'),
('business_location_hint', 'Centro La Cabrera', '2026-01-22 15:06:19'),
('business_logo', 'uploaded_img/business_logo.png', '2026-01-22 15:06:19'),
('business_logo_version', '', '2026-01-22 15:06:19'),
('business_name', 'Sabores Express', '2026-01-22 15:06:07'),
('business_phone', '+573505849143', '2026-01-22 15:05:49'),
('currency_code', 'COP', '2026-01-19 18:04:20'),
('db_bootstrap_version', '3', '2026-01-23 23:41:04'),
('delivery_last_order_number', '3', '2026-01-20 00:45:08'),
('dine_in_last_order_number', '5', '2026-01-20 00:39:57'),
('google_maps_url', 'https://maps.app.goo.gl/FiWLRGpXxnTb3gzL6', '2026-01-22 15:06:19'),
('payment_banks', '[{\"id\":\"nequi\",\"name\":\"Pago Móvil\",\"logo\":\"uploaded_img/banks/nequi_1.png\",\"logos\":[\"uploaded_img/banks/nequi_1.png\",\"uploaded_img/banks/nequi_2.png\",\"uploaded_img/banks/nequi_3.png\"],\"account_number\":\"04121739014\",\"account_type\":\"Ahorros\",\"account_holder\":\"Wilmer\",\"document\":\"17664848\",\"notes\":\"como estas\",\"sort\":1,\"active\":1}]', '2026-01-24 18:11:13'),
('social_facebook_url', 'https://www.facebook.com/share/19FnyEJXy8/?mibextid=wwXIfr', '2026-01-24 17:09:43'),
('social_gmail_url', 'mailto:pareycoma@gmail.com', '2026-01-24 17:09:54'),
('social_instagram_url', 'https://www.instagram.com/pareycomarestaurante?igsh=MXc4YTIwaXB2aDY3cg%3D%3D&utm_source=qr', '2026-01-24 17:08:45');

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` int(100) NOT NULL,
  `name` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `number` varchar(10) NOT NULL,
  `password` varchar(50) NOT NULL,
  `address` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `admin_webauthn_credentials`
--
ALTER TABLE `admin_webauthn_credentials`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_admin_credential_id` (`credential_id`),
  ADD KEY `idx_admin_webauthn_admin` (`admin_id`);

--
-- Indices de la tabla `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `name` (`name`);

--
-- Indices de la tabla `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`code`),
  ADD KEY `idx_currencies_active` (`is_active`);

--
-- Indices de la tabla `delivery_orders`
--
ALTER TABLE `delivery_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_delivery_order_number` (`order_number`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_created_at` (`created_at`),
  ADD KEY `preparer_id` (`preparer_id`);

--
-- Indices de la tabla `delivery_order_items`
--
ALTER TABLE `delivery_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indices de la tabla `delivery_order_preparers`
--
ALTER TABLE `delivery_order_preparers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_delivery_order_preparer` (`order_id`,`preparer_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `preparer_id` (`preparer_id`);

--
-- Indices de la tabla `delivery_zones`
--
ALTER TABLE `delivery_zones`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_zone_name` (`name`);

--
-- Indices de la tabla `dine_in_orders`
--
ALTER TABLE `dine_in_orders`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_dine_in_order_number` (`order_number`),
  ADD KEY `idx_table_status` (`table_number`,`order_status`),
  ADD KEY `idx_comandas_created_at` (`created_at`),
  ADD KEY `idx_payment_status` (`payment_status`),
  ADD KEY `preparer_id` (`preparer_id`);

--
-- Indices de la tabla `dine_in_order_items`
--
ALTER TABLE `dine_in_order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `product_id` (`product_id`);

--
-- Indices de la tabla `dine_in_order_preparers`
--
ALTER TABLE `dine_in_order_preparers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_order_preparer` (`order_id`,`preparer_id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `preparer_id` (`preparer_id`);

--
-- Indices de la tabla `ingredients`
--
ALTER TABLE `ingredients`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `inventory_movements`
--
ALTER TABLE `inventory_movements`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_inventory_movements_ingredient` (`ingredient_id`),
  ADD KEY `idx_inventory_movements_admin` (`admin_id`),
  ADD KEY `idx_inventory_movements_created_at` (`created_at`);

--
-- Indices de la tabla `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `preparers`
--
ALTER TABLE `preparers`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_category` (`category`),
  ADD KEY `idx_products_is_active` (`is_active`);

--
-- Indices de la tabla `product_ingredients`
--
ALTER TABLE `product_ingredients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `ingredient_id` (`ingredient_id`);

--
-- Indices de la tabla `product_preparers`
--
ALTER TABLE `product_preparers`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uniq_product_preparer` (`product_id`,`preparer_id`),
  ADD KEY `product_id` (`product_id`),
  ADD KEY `preparer_id` (`preparer_id`);

--
-- Indices de la tabla `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`setting_key`);

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `admin`
--
ALTER TABLE `admin`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT de la tabla `admin_webauthn_credentials`
--
ALTER TABLE `admin_webauthn_credentials`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=61;

--
-- AUTO_INCREMENT de la tabla `delivery_orders`
--
ALTER TABLE `delivery_orders`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT de la tabla `delivery_order_items`
--
ALTER TABLE `delivery_order_items`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;

--
-- AUTO_INCREMENT de la tabla `delivery_order_preparers`
--
ALTER TABLE `delivery_order_preparers`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT de la tabla `delivery_zones`
--
ALTER TABLE `delivery_zones`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT de la tabla `dine_in_orders`
--
ALTER TABLE `dine_in_orders`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de la tabla `dine_in_order_items`
--
ALTER TABLE `dine_in_order_items`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123;

--
-- AUTO_INCREMENT de la tabla `dine_in_order_preparers`
--
ALTER TABLE `dine_in_order_preparers`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT de la tabla `ingredients`
--
ALTER TABLE `ingredients`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `inventory_movements`
--
ALTER TABLE `inventory_movements`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT de la tabla `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `preparers`
--
ALTER TABLE `preparers`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `products`
--
ALTER TABLE `products`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=274;

--
-- AUTO_INCREMENT de la tabla `product_ingredients`
--
ALTER TABLE `product_ingredients`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de la tabla `product_preparers`
--
ALTER TABLE `product_preparers`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `admin_webauthn_credentials`
--
ALTER TABLE `admin_webauthn_credentials`
  ADD CONSTRAINT `admin_webauthn_credentials_ibfk_1` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `delivery_orders`
--
ALTER TABLE `delivery_orders`
  ADD CONSTRAINT `delivery_orders_ibfk_1` FOREIGN KEY (`preparer_id`) REFERENCES `preparers` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `delivery_order_items`
--
ALTER TABLE `delivery_order_items`
  ADD CONSTRAINT `delivery_order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `delivery_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `delivery_order_preparers`
--
ALTER TABLE `delivery_order_preparers`
  ADD CONSTRAINT `delivery_order_preparers_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `delivery_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `delivery_order_preparers_ibfk_2` FOREIGN KEY (`preparer_id`) REFERENCES `preparers` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `dine_in_orders`
--
ALTER TABLE `dine_in_orders`
  ADD CONSTRAINT `dine_in_orders_ibfk_1` FOREIGN KEY (`preparer_id`) REFERENCES `preparers` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `dine_in_order_items`
--
ALTER TABLE `dine_in_order_items`
  ADD CONSTRAINT `dine_in_order_items_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `dine_in_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `dine_in_order_items_ibfk_2` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `dine_in_order_preparers`
--
ALTER TABLE `dine_in_order_preparers`
  ADD CONSTRAINT `dine_in_order_preparers_ibfk_1` FOREIGN KEY (`order_id`) REFERENCES `dine_in_orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `dine_in_order_preparers_ibfk_2` FOREIGN KEY (`preparer_id`) REFERENCES `preparers` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `inventory_movements`
--
ALTER TABLE `inventory_movements`
  ADD CONSTRAINT `inventory_movements_ibfk_1` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `inventory_movements_ibfk_2` FOREIGN KEY (`admin_id`) REFERENCES `admin` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `fk_category` FOREIGN KEY (`category`) REFERENCES `categories` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `product_ingredients`
--
ALTER TABLE `product_ingredients`
  ADD CONSTRAINT `product_ingredients_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_ingredients_ibfk_2` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `product_preparers`
--
ALTER TABLE `product_preparers`
  ADD CONSTRAINT `product_preparers_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `product_preparers_ibfk_2` FOREIGN KEY (`preparer_id`) REFERENCES `preparers` (`id`) ON DELETE CASCADE;
COMMIT;

/*!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 */;
User / IP	: 216.73.216.191
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64