Tul xxx Tul

Viewing: consaboragourmet.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 17-03-2026 a las 23:08:17
-- 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: `consaboragourmet`
--

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

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

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

INSERT INTO `messages` (`id`, `user_id`, `name`, `email`, `number`, `message`, `message_type`, `status`, `created_at`) VALUES
(69, 0, 'Ab Y', '', '', 'Hey team consaboragourmet.com,\r\n\r\nHope your doing well!\r\n\r\nI just following your website and realized that despite having a good design; but it was not ranking high on any of the Search Engines (Google, Yahoo & Bing) for most of the keywords related to your business.\r\n\r\nWe can place your website on Google&#39;s 1st page.\r\n\r\n*  Top ranking on Google search!\r\n*  Improve website clicks and views!\r\n*  Increase Your Leads, clients & Revenue!\r\n\r\nInterested? Please provide your name, contact informatio', 'contact', 'pendiente', '2026-02-15 02:36:52'),
(70, 0, 'Cecila Lyell', '', '', 'Dear Sir/Madam\r\n\r\nAdd consaboragourmet.com in Google Search Index and have it show up  in google search results!\r\n\r\nRegister consaboragourmet.com at  https://searchregister.info', 'contact', 'pendiente', '2026-02-15 16:15:46'),
(71, 0, 'Emanuel Morrell', '', '', 'Hi\r\n\r\nList consaboragourmet.com in Google Search Index so it can be  be visible  in online search results!\r\n\r\nRegister consaboragourmet.com at  https://searchregister.net', 'contact', 'pendiente', '2026-02-16 16:24:35'),
(72, 0, 'Nikita Joshi', '', '', 'Hi http://consaboragourmet.com,\r\n\r\nCould you please tell me if you want to show your website on top in Google searches and to increase organic traffic on your website.\r\n\r\nWe are a digital marketing company that deals in SEO and we can bring your website to the first page of Google as we are helping more than 100+ websites to get them top in Google.\r\n\r\nPlease let me know if you would like to discuss this opportunity.\r\n\r\nIf you are interested, I can send you our past work, pricing and proposals.\r\n', 'contact', 'pendiente', '2026-02-17 11:18:12'),
(73, 0, 'Victorina Audet', '', '', 'Dear Sir/Madam\r\n\r\nSubmit consaboragourmet.com in Google Search Index to show up  in online search results!\r\n\r\nRegister consaboragourmet.com at  https://searchregister.org', 'contact', 'pendiente', '2026-02-17 18:07:29'),
(74, 0, 'Leeza Bindra', '', '', 'Hello http://consaboragourmet.com, \r\n\r\nI’d like to discuss website design and development for your business.\r\n\r\nWe create professional websites that help businesses attract more customers and build trust online.\r\n\r\nIf interested, I can share our website design packages and pricing details. \r\n\r\nWarm regards,\r\nLeeza', 'contact', 'pendiente', '2026-02-18 02:49:29'),
(75, 0, 'Delbert Ahmad', '', '', 'Hello,\r\n\r\nI hope you’re doing well.\r\n\r\nI came across your business online and thought you might be interested\r\nin improving your visibility and traffic on search engines.We\r\nspecialize in helping businesses strengthen their online presence\r\nthrough effective SEO strategies.\r\n\r\nOnce you share your target keywords and target market, I’ll send a\r\nfull proposal.\r\n\r\nWarm regards,\r\n\r\nAli', 'contact', 'pendiente', '2026-02-18 08:37:28'),
(76, 0, 'Kyree WebDesign', '', '', 'Hello,\r\n\r\nI took a quick look at your website and noticed several UI and UX issues that may be affecting how visitors interact with your site and convert into leads or customers.\r\n\r\nSome of the key issues include buttons that are not clearly visible or easy to click, small or hard-to-read fonts, and a layout and color scheme that can feel confusing to users. On mobile devices, the site does not always display properly, and some forms and menus are not easy to find or use.\r\n\r\nFrom a user experien', 'contact', 'pendiente', '2026-02-18 10:16:39'),
(77, 0, 'Kennith Bold', '', '', 'Hi,\r\n\r\nList consaboragourmet.com in S.E.O. DIRECTORY for a better ranking in the Search Results order.\r\n\r\nJoin at https://SEODIR.pro', 'contact', 'pendiente', '2026-02-18 20:01:48'),
(78, 0, 'Sharon Francois', '', '', 'Dear Sir/Madam\r\n\r\nFeature consaboragourmet.com in Google Search Index so it can be be displayed in web search results!\r\n\r\nRegister consaboragourmet.com at  https://searchregister.org', 'contact', 'pendiente', '2026-02-27 12:28:47'),
(79, 0, 'Web Agency', '', '', 'Hi,\r\n\r\nWe’d love to create a brand-new, professional website for consaboragourmet.com or your next project.\r\n\r\nFrom fresh builds to updates or redesigns, we’re here to help.\r\n\r\nVisit us at: 99website.pro', 'contact', 'pendiente', '2026-03-03 02:30:59'),
(80, 0, 'Senx SEO', '', '', 'Hi consaboragourmet.com\r\n\r\nI’m a Website Promotion & Advertising Consultant, leading a team of 30+ professionals who specialize in helping businesses grow online.\r\n\r\nWe focus on delivering measurable results through:\r\n\r\nSEO: Getting your website ranked higher on Google to attract more visitors and inquiries.\r\nSocial media: Creating engaging posts, reels, and ad campaigns across Facebook, Instagram, LinkedIn, and YouTube to build awareness and trust.\r\nPPC Advertising: Running targeted ad campaign', 'contact', 'pendiente', '2026-03-08 06:34:35'),
(81, 0, 'Renate Dresdner', '', '', 'Dear Sir/Madam\r\n\r\nAdd consaboragourmet.com in Google Search Index so it can be appear in web search results!\r\n\r\nRegister consaboragourmet.com at  https://searchregister.net', 'contact', 'pendiente', '2026-03-09 12:46:14'),
(82, 0, 'AndrewNuazy', '', '', 'What’s up? consaboragourmet.com \r\n \r\nDid you know that it is possible to send proposal in a legally-compliant way? \r\nWhen such requests are sent, no personal data is used and messages are securely routed to forms designed to receive them and any subsequent appeals. The significance of messages sent through Communication Forms ensures that they do not end up in spam folders. \r\nYou&#39;re invited to sample our service at no cost. \r\nWe are here to send up to 50,000 messages for you. \r\n \r\nThe cost o', 'contact', 'pendiente', '2026-03-13 15:52:01');

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

--
-- 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,
  `meal_type_label` varchar(60) NOT NULL DEFAULT 'Plato principal',
  `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`, `meal_type_label`, `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, 'Contorno', 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, 'Contorno', 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, 'Contorno', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Contorno', 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, 'Contorno', 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, 'Contorno', 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, 'Contorno', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Contorno', 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, 'Contorno', 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, 'Contorno', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Contorno', 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, 'Contorno', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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, 'Contorno', 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, 'Plato principal', 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, 'Plato principal', 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, 'Plato principal', 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=83;

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