Tul xxx Tul

Viewing: consaborgourmet.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 13-02-2026 a las 04:32:05
-- 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: `consaborgourmet`
--

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

--
-- 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),
(20, 'Nell', 'b4ed18c3283cd29412e60a3d0b92e896348457cb', 'owner', NULL, 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
(64, 'Asiática'),
(61, 'Española'),
(63, 'Francesa'),
(62, 'Italiana'),
(65, 'Latinoaméricana');

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

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

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

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

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

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

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

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

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

--
-- 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, NULL, 'Bandeja Carne', 1, 16000.00, 16000.00, 16000.00),
(107, 28, NULL, 'Bebida Personal', 1, 3000.00, 3000.00, 3000.00),
(112, 30, NULL, 'Bandeja Chuleta', 1, 16000.00, 16000.00, 16000.00),
(113, 30, NULL, 'Bebida de Bebé', 1, 2000.00, 2000.00, 2000.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;

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

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

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

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

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

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

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

--
-- 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
(274, 'Ensalada Española con lechuga crespa y pollo ahumado', 0.00, 180000.00, 'ensalada-de-pollo-698b21f9def176.90905590.webp', 'Tomate, pepino, aceituna, maíz dulce, queso, pollo, jamón, champiñones, crema de leche y lechuga\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(275, 'Tortilla Española', 0.00, 120000.00, 'tortilla-espan-ola-potato-omelet-698b22635902e1.51054439.jpg', 'Huevo, cebolla, papa, aceite de oliva, hiervas y pimentón. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(276, 'Tortilla Paisana', 0.00, 120000.00, 'tortilla-paisana-698b22c37e4d39.47264537.jpg', 'Huevo, papa, pimentón, espinaca, cebolla, chorizo, aceite de oliva y pimienta. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(277, 'Paella Española', 0.00, 300000.00, '28870096-1822768124465316-6637298469105960784-n-698b24f76dd2b4.06819400.jpg', 'Mariscos, pollo, arroz, cebolla, pimentón, ajo, perejil y vino. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(278, 'Carnes Españolas al Jerez', 0.00, 280000.00, 'lomo-al-jerez-3660-698b256c7d1c73.25922960.jpg', 'Medallón de lomo, salsa vino tinto, vino de jerez y aceite de oliva.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(279, 'Chuleta de Cerdo al Ajo y Orégano', 0.00, 250000.00, '1712703229-receta-cuadrada-698b27506b3931.89194343.webp', 'Chuleta de cerdo, papa, ajo, orégano fresco, vino y fondo de res.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(280, 'Pollo Marengo con Aceituna Champiñones', 0.00, 150000.00, 'pollo-a-la-marengo-receta-con-historia-y-sabor-frances-6313-698b2869855991.52288504.jpg', 'Pollo, aceituna, ajo, champiñones, tomate, aceite de oliva, vino blanco y perejil.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 61, 1),
(281, 'Ensalada Capresa', 0.00, 180000.00, 'caprese-1-698b2ab5995bd5.00368627.jpg', 'Tomate, queso mozzarella, salsa pesto y albahaca.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(282, 'Ensalada César', 0.00, 180000.00, 'ensalada-cesar-698b2b43bc2cf1.10716503.jpg', 'Lechuga romana, tocineta, huevo, queso parmesano, aceite de oliva, anchoas, croutones de pan y salsa inglesa. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(283, 'Ensalada de Champiñones', 0.00, 180000.00, 'zoom-cc7407b16766e6e4aeb1e411d5048e56-920-518-698b2c34b344d4.76451451.jpg', 'Champiñones, radiccio, escarola, naranja, vinagre bálsamico, aceite de oliva, miel y pimienta. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(284, 'Pie de Queso al Pesto con Pimentón', 0.00, 230000.00, 'pie-de-queso-698b2ce0f351f8.50802240.webp', 'Galleta salada, mantequilla, queso crema, queso ricotta, huevo, queso parmesano, pesto y pimentón. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(285, 'Pasticho o Lasaña', 0.00, 250000.00, 'pasticho-698b2d71a2de44.97156274.webp', 'Pasta, salsa boloñesa, salsa panna, queso (mozzarella, parmesano y amarillo) jamón y salsa pesto.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(286, 'Pollo Florentino', 0.00, 250000.00, 'pollo-a-la-florentina-698b34c2f40ff3.81288721.webp', 'Pollo, espinaca, queso (mozzarella y parmesano), huevo, pan rallado, nuez moscada, salsa panna, pimienta y brandy.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(287, 'Involtini de Pollo con Vegetales', 0.00, 280000.00, 'involtini-pollo-verduras-rellenos1-698b35db5c2288.60920852.jpg', 'Pechuga de pollo, pimentón rojo y verde, cebolla, zanahoria, tocineta, ajo, jamón y queso mozzarella.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 62, 1),
(288, 'Ensalada Kristoff', 0.00, 180000.00, '1-5392339a-ec6a-434e-92ba-e90af54182c7-698b3a94f14385.60593864.jpg', 'Queso parmesano, lechugas mixtas, durazno, fresa y almendras.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(289, 'Tartiflette al Tentación', 0.00, 120000.00, 'tartiflette-698b3b6201dae8.51679349.jpg', 'Papa, tocineta, queso tentación, cebolla, vino blanco y crema de leche. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(290, 'Ratatouille', 0.00, 120000.00, 'csm-1075-recipe-page-saffron-scented-ratatouille-mobile-d7ea9ff3fa-698b3c166f3c31.01910770.webp', 'Zanahoria, berenjena, calabacín, queso parmesano, pimentón, queso manchego, cebolla, tomillo y romero. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(291, 'Filet Migñon con Champiñones', 0.00, 350000.00, 'df-698b6658d7ef52.61540287.webp', 'Medallones de lomito, tocineta, champiñones, salsa de vino tinto, cebolla mantequilla y ajo.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(292, 'Centro de Carne Relleno', 0.00, 250000.00, 'bacon-wrapped-burger-log-900x570-srgb-698b679c30d870.26746171.webp', 'Centro de lomito, queso, espinacas, brandy y salsa de vino tinto. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(293, 'Chuleta de Pork en Papilote', 0.00, 220000.00, 'hq720-698e7116743b93.52987122.jpg', 'Chuleta de cerdo ahumada, jamón cocido, cebolla, chalote, champiñones, tomate, tomillo y pimienta blanca.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(294, 'Brochetas de Pollo con Mantequilla de Hierbas', 0.00, 80000.00, 'garlic-lemon-kabobs-698b6b13cf2591.55797383.webp', 'Pollo en macedonia, tocineta, champiñones, mantequilla de hierbas con pimentón en macedonia. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(295, 'Pollo al Vino', 0.00, 150000.00, 'pollo-al-vino-tinto-698b6de70f8ab4.05117827.jpg', 'Pechuga de pollo, jamón, queso amarrillo, huevo, pan rallado con una salsa de vino blanco. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 63, 1),
(296, 'Chop Suey de Vegetales', 0.00, 85000.00, 'chop-suey-698b6f9b9ce0d0.88338688.jpg', 'Verduras varias, huevos, cebolla, fideos, pimentón, coliflor, brócoli, salsa agridulce. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(297, 'Pattatas al Cilantro con Tocineta', 0.00, 65000.00, 'maxresdefault-698b71c5a699b6.02170263.jpg', 'Patatas, tocineta, hojas de cilantro picadas. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(298, 'Cerdo de Mein', 0.00, 250000.00, 'd7f820b742fc8c7b367ee07222763ddd-698b742555f609.40036050.jpg', 'Cerdo, ajo, cebolla, zanahoria, pimentón, champiñones, raíces chinas. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(299, 'Pollo con Cilantro y Especies', 0.00, 85000.00, 'fotopaso-4-11-1-principal-698b7765da5786.06842023.webp', 'Pollo, jenjibre, pepino, especies, hojas de cilantro picadas.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(300, 'Arroz Chino Especial', 0.00, 85000.00, '20240517220828-andy-20cooks-20-20chinese-20style-20fried-20rice-698b978a7cfe51.25465943.webp', 'Cerdo, ajo, cebolla, zanahoria, pimentón, champiñones, reíces chinas.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(301, 'Pollo Agridulce', 0.00, 85000.00, 'pollo-agriculde-698b97ec5384a1.85332957.jpg', 'Pollo, pimentón rojo, cebolla, salsa soya, vino y especies. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 64, 1),
(302, 'Picadillo de Papas con especies y Cilantro', 0.00, 150000.00, '1-91988862-ee1e-4309-91d6-3f2e925973fc-698b99535d6148.98641277.jpg', 'Papa, pimentón, cebolla, cilantro, perejil, oregano, aceite de maíz y pimienta negra.\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 65, 1),
(303, 'Asado Negro', 0.00, 350000.00, '1-4458594f-c325-4c70-9c6a-a212dfc7c0d2-698e758d003c90.73697258.jpg', 'Muchacho redondo, cebolla, zanahoria, pimentón, ajíes, cebollín, laurel, comino, salsa inglesa, panela, vino blanco con puro de papa\r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS).', 65, 1),
(304, 'Pollo en Vino Blanco', 0.00, 250000.00, '010420251743526718-698b9ef881cd92.77614086.jpeg', 'Pollo, vino blanco, cebolla, cognac, mantequilla, ají y limón. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 65, 1),
(305, 'Pastel de Carne en Salsa Gourmet', 0.00, 280000.00, 'meatloaf-01-698b9fd6a92ac6.66250279.jpg', 'Carne, chorizo de cerdo, aceitunas, tocineta, uvas, pasas, cebolla, migas de pan, huevo, harina acompañado de una salsa de tomate con hongos secos y vino blanco. \r\n\r\nBANDEJA GRANDE (PARA 12 - 15 PERSONAS)', 65, 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;

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

--
-- 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', '', '2026-02-12 20:30:19'),
('business_hours', 'Lunes a Viernes \r\n9:00 AM - 12:00 AM \r\nY  De\r\n3:00 PM - 6:00 PM', '2026-02-10 06:06:03'),
('business_location_hint', '', '2026-02-12 20:30:19'),
('business_logo', 'uploaded_img/business_logo.png', '2026-01-22 15:06:19'),
('business_logo_version', '1770823509', '2026-02-11 10:25:09'),
('business_name', 'Con Sabor a Gourmet', '2026-02-10 06:42:11'),
('business_phone', '+573181062494', '2026-02-10 06:40:54'),
('currency_code', 'COP', '2026-01-19 18:04:20'),
('db_bootstrap_version', '3', '2026-01-23 23:41:04'),
('delivery_last_order_number', '4', '2026-02-12 18:41:40'),
('dine_in_last_order_number', '5', '2026-01-20 00:39:57'),
('google_maps_url', '', '2026-02-12 20:30:19'),
('payment_banks', '[{\"id\":\"nequi\",\"name\":\"Bancolombia\",\"logo\":\"uploaded_img/banks/nequi_1.png\",\"logos\":[\"uploaded_img/banks/nequi_1.png\"],\"account_number\":\"82400031831\",\"account_type\":\"Ahorro\",\"account_holder\":\"\",\"document\":\"721697 Cédula de Extranjería\",\"active\":1},{\"id\":\"bank3251712109\",\"name\":\"Scotiabank\",\"logo\":\"uploaded_img/banks/bank3251712109_1.png\",\"logos\":[\"uploaded_img/banks/bank3251712109_1.png\"],\"account_number\":\"1442001692\",\"account_type\":\"Ahorro\",\"account_holder\":\"\",\"document\":\"721697 Cédula de Extranjería\",\"active\":1},{\"id\":\"bankb127974948\",\"name\":\"Falabella\",\"logo\":\"uploaded_img/banks/bankb127974948_1.png\",\"logos\":[\"uploaded_img/banks/bankb127974948_1.png\"],\"account_number\":\"116010285796\",\"account_type\":\"Ahorro\",\"account_holder\":\"\",\"document\":\"721697 Cédula de Extranjería\",\"active\":1}]', '2026-02-12 21:41:02'),
('social_facebook_url', '', '2026-02-10 21:32:52'),
('social_gmail_url', 'mailto:consaboragourmet@gmail.com', '2026-02-12 21:59:22'),
('social_instagram_url', 'https://www.instagram.com/consaboragourmet/?utm_source=ig_web_button_share_sheet', '2026-02-12 21:59:22');

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

--
-- 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=22;

--
-- 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=66;

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

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

--
-- 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=18;

--
-- 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=307;

--
-- 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.217
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