Tul xxx Tul

Viewing: vacia.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 12-05-2026 a las 07:34:52
-- 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: `comidarapidafran`
--

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

--
-- Estructura de tabla para la tabla `accounts_payable`
--

CREATE TABLE `accounts_payable` (
  `id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `invoice_number` varchar(100) DEFAULT NULL COMMENT 'N├║mero de factura del proveedor',
  `description` text DEFAULT NULL COMMENT 'Descripci├│n de la deuda',
  `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Monto total de la deuda',
  `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Monto ya pagado',
  `pending_amount` decimal(12,2) GENERATED ALWAYS AS (`total_amount` - `paid_amount`) STORED,
  `status` enum('pending','partial','paid','cancelled') NOT NULL DEFAULT 'pending',
  `due_date` date DEFAULT NULL COMMENT 'Fecha de vencimiento del pago',
  `issue_date` date DEFAULT NULL COMMENT 'Fecha de emisi├│n de la factura',
  `payment_type` enum('contado','credito') NOT NULL DEFAULT 'credito',
  `created_by` int(11) DEFAULT NULL COMMENT 'ID del admin que registr├│',
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `accounts_receivable`
--

CREATE TABLE `accounts_receivable` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `order_id` int(11) DEFAULT NULL COMMENT 'Relaci├│n con dine_in_orders si aplica',
  `invoice_number` varchar(100) DEFAULT NULL COMMENT 'N├║mero de factura o documento',
  `description` text DEFAULT NULL COMMENT 'Descripci├│n de la deuda',
  `total_amount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Monto total de la deuda',
  `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00 COMMENT 'Monto ya pagado',
  `pending_amount` decimal(12,2) GENERATED ALWAYS AS (`total_amount` - `paid_amount`) STORED,
  `status` enum('pending','partial','paid','cancelled') NOT NULL DEFAULT 'pending',
  `due_date` date DEFAULT NULL COMMENT 'Fecha de vencimiento del pago',
  `payment_type` enum('contado','credito') NOT NULL DEFAULT 'credito',
  `created_by` int(11) DEFAULT NULL COMMENT 'ID del admin que registr├│',
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

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

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

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

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

--
-- Estructura de tabla para la tabla `ap_payments`
--

CREATE TABLE `ap_payments` (
  `id` int(11) NOT NULL,
  `account_payable_id` int(11) NOT NULL,
  `payment_amount` decimal(12,2) NOT NULL COMMENT 'Monto del pago',
  `payment_method` enum('efectivo','tarjeta','transferencia','cheque','otro') NOT NULL DEFAULT 'transferencia',
  `payment_date` datetime NOT NULL DEFAULT current_timestamp(),
  `paid_by` int(11) DEFAULT NULL COMMENT 'Admin que realiz├│ el pago',
  `reference_number` varchar(100) DEFAULT NULL COMMENT 'N├║mero de referencia del pago',
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Disparadores `ap_payments`
--
DELIMITER $$
CREATE TRIGGER `after_ap_payment_insert` AFTER INSERT ON `ap_payments` FOR EACH ROW BEGIN
DECLARE total_paid DECIMAL(12,2);
DECLARE total_debt DECIMAL(12,2);
SELECT COALESCE(SUM(payment_amount), 0)
INTO total_paid
FROM ap_payments
WHERE account_payable_id = NEW.account_payable_id;
SELECT total_amount
INTO total_debt
FROM accounts_payable
WHERE id = NEW.account_payable_id;
IF total_paid >= total_debt THEN
UPDATE accounts_payable
SET paid_amount = total_paid,
status = 'paid'
WHERE id = NEW.account_payable_id;
ELSEIF total_paid > 0 THEN
UPDATE accounts_payable
SET paid_amount = total_paid,
status = 'partial'
WHERE id = NEW.account_payable_id;
END IF;
END
$$
DELIMITER ;

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

--
-- Estructura de tabla para la tabla `ar_payments`
--

CREATE TABLE `ar_payments` (
  `id` int(11) NOT NULL,
  `account_receivable_id` int(11) NOT NULL,
  `payment_amount` decimal(12,2) NOT NULL COMMENT 'Monto del pago',
  `payment_method` enum('efectivo','tarjeta','transferencia','cheque','otro') NOT NULL DEFAULT 'efectivo',
  `payment_date` datetime NOT NULL DEFAULT current_timestamp(),
  `received_by` int(11) DEFAULT NULL COMMENT 'Admin que recibi├│ el pago',
  `reference_number` varchar(100) DEFAULT NULL COMMENT 'N├║mero de referencia del pago',
  `notes` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Disparadores `ar_payments`
--
DELIMITER $$
CREATE TRIGGER `after_ar_payment_insert` AFTER INSERT ON `ar_payments` FOR EACH ROW BEGIN
DECLARE total_paid DECIMAL(12,2);
DECLARE total_debt DECIMAL(12,2);
SELECT COALESCE(SUM(payment_amount), 0)
INTO total_paid
FROM ar_payments
WHERE account_receivable_id = NEW.account_receivable_id;
SELECT total_amount
INTO total_debt
FROM accounts_receivable
WHERE id = NEW.account_receivable_id;
IF total_paid >= total_debt THEN
UPDATE accounts_receivable
SET paid_amount = total_paid,
status = 'paid'
WHERE id = NEW.account_receivable_id;
ELSEIF total_paid > 0 THEN
UPDATE accounts_receivable
SET paid_amount = total_paid,
status = 'partial'
WHERE id = NEW.account_receivable_id;
END IF;
END
$$
DELIMITER ;

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

--
-- 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 `cash_registers`
--

CREATE TABLE `cash_registers` (
  `id` int(11) NOT NULL,
  `status` enum('open','closed') NOT NULL DEFAULT 'open',
  `opened_at` datetime NOT NULL DEFAULT current_timestamp(),
  `closed_at` datetime DEFAULT NULL,
  `opened_by` int(11) NOT NULL,
  `closed_by` int(11) DEFAULT NULL,
  `initial_balance` decimal(10,2) NOT NULL DEFAULT 0.00,
  `final_balance` decimal(10,2) DEFAULT NULL,
  `expected_balance` decimal(10,2) DEFAULT NULL,
  `expected_cash` decimal(15,2) DEFAULT 0.00,
  `expected_transfer` decimal(15,2) DEFAULT 0.00,
  `difference` decimal(10,2) DEFAULT NULL,
  `notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `cash_transactions`
--

CREATE TABLE `cash_transactions` (
  `id` int(11) NOT NULL,
  `register_id` int(11) NOT NULL,
  `type` enum('income','expense') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` enum('efectivo','transferencia','tarjeta') NOT NULL DEFAULT 'efectivo',
  `description` varchar(255) NOT NULL,
  `reference_type` enum('dine_in','delivery','manual','ar_payment') NOT NULL DEFAULT 'manual',
  `reference_id` int(11) DEFAULT NULL,
  `admin_id` int(11) NOT NULL,
  `expense_category_id` int(11) DEFAULT NULL,
  `expense_subcategory_id` int(11) 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 `catalog_types`
--

CREATE TABLE `catalog_types` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(50) DEFAULT 'fa-layer-group',
  `color` varchar(20) DEFAULT '#333',
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) 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,
  `catalog_type_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- 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 `customers`
--

CREATE TABLE `customers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `document_type` enum('cc','nit','pasaporte','otro') DEFAULT 'cc',
  `document_number` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `notes` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `delivery_orders` (
  `id` int(100) NOT NULL,
  `order_number` int(100) NOT NULL,
  `source` varchar(20) NOT NULL DEFAULT 'pos',
  `customer_name` varchar(100) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_document` varchar(50) DEFAULT NULL,
  `phone` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `delivery_zone_id` int(11) DEFAULT NULL,
  `delivery_zone_name` varchar(120) DEFAULT NULL,
  `delivery_fee` decimal(10,2) NOT NULL DEFAULT 0.00,
  `latitude` decimal(10,7) DEFAULT NULL,
  `longitude` decimal(10,7) DEFAULT 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(),
  `apply_iva` tinyint(1) NOT NULL DEFAULT 1,
  `apply_tip` tinyint(1) NOT NULL DEFAULT 1,
  `invoice_requested` tinyint(1) NOT NULL DEFAULT 0,
  `invoice_email` varchar(150) DEFAULT NULL
) 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,
  `customer_id` int(11) DEFAULT NULL,
  `customer_ruc` varchar(50) DEFAULT NULL,
  `customer_doc_type` enum('cc','nit','pasaporte','otro') DEFAULT 'cc',
  `customer_document` varchar(50) 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,
  `iva_amount` decimal(12,2) DEFAULT 0.00,
  `tip_amount` decimal(12,2) DEFAULT 0.00,
  `final_total` decimal(12,2) 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,
  `room_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

--
-- 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 `expense_categories`
--

CREATE TABLE `expense_categories` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `expense_subcategories`
--

CREATE TABLE `expense_subcategories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `ingredients` (
  `id` int(100) NOT NULL,
  `code` varchar(50) DEFAULT NULL,
  `name` varchar(100) NOT NULL,
  `type` enum('insumo','producto_fisico','receta','combo') DEFAULT 'insumo',
  `cost` decimal(10,2) DEFAULT 0.00,
  `sale_price` decimal(10,2) DEFAULT 0.00,
  `category_id` int(11) DEFAULT NULL,
  `location_id` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `product_id` int(11) 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,
  `document_number` varchar(100) DEFAULT NULL,
  `product_code` varchar(100) DEFAULT NULL,
  `product_name` varchar(255) DEFAULT NULL,
  `provider_id` int(11) DEFAULT NULL,
  `payment_type` enum('contado','credito') DEFAULT 'contado',
  `movement_type` enum('in','out','adjust') NOT NULL,
  `quantity` decimal(12,3) NOT NULL,
  `unit_cost` decimal(10,2) DEFAULT 0.00,
  `subtotal` decimal(10,2) DEFAULT 0.00,
  `iva_amount` decimal(10,2) DEFAULT 0.00,
  `total_amount` decimal(10,2) DEFAULT 0.00,
  `notes` varchar(500) NOT 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 `order_item_cancellations`
--

CREATE TABLE `order_item_cancellations` (
  `id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `reason` varchar(50) NOT NULL,
  `reason_detail` text DEFAULT NULL,
  `cancelled_by` int(11) DEFAULT NULL,
  `cancelled_at` datetime NOT NULL DEFAULT current_timestamp()
) 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 `printers`
--

CREATE TABLE `printers` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `system_name` varchar(255) DEFAULT NULL,
  `ticket_width` int(11) NOT NULL DEFAULT 58,
  `copies` int(11) NOT NULL DEFAULT 1,
  `auto_print` tinyint(1) NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `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 `printer_jobs`
--

CREATE TABLE `printer_jobs` (
  `id` int(11) NOT NULL,
  `printer_id` int(11) DEFAULT NULL,
  `source_type` enum('dine_in','delivery') NOT NULL,
  `order_id` int(11) NOT NULL,
  `order_number` int(11) DEFAULT NULL,
  `status` enum('pending','printed','error','skipped') NOT NULL DEFAULT 'pending',
  `payload` mediumtext DEFAULT NULL,
  `error_message` text DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `printed_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `print_zones`
--

CREATE TABLE `print_zones` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `icon` varchar(50) DEFAULT 'fa-print',
  `color` varchar(20) DEFAULT '#64748b',
  `is_active` tinyint(1) DEFAULT 1
) 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,
  `print_zone` varchar(50) DEFAULT 'cocina',
  `printer_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- 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,
  `unit_cost` decimal(10,2) NOT NULL DEFAULT 0.00
) 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 `providers`
--

CREATE TABLE `providers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `rooms`
--

CREATE TABLE `rooms` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `map_image` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

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

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

--
-- Estructura de tabla para la tabla `suppliers`
--

CREATE TABLE `suppliers` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `nit` varchar(50) DEFAULT NULL COMMENT 'NIT o n├║mero de identificaci├│n tributaria',
  `payment_terms` varchar(255) DEFAULT NULL COMMENT 'Condiciones de pago (ej: 30 d├¡as, 60 d├¡as)',
  `notes` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Estructura de tabla para la tabla `tables`
--

CREATE TABLE `tables` (
  `id` int(11) NOT NULL,
  `room_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `pos_x` float DEFAULT 0,
  `pos_y` float DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- 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 `accounts_payable`
--
ALTER TABLE `accounts_payable`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ap_supplier` (`supplier_id`),
  ADD KEY `idx_ap_status` (`status`),
  ADD KEY `idx_ap_due_date` (`due_date`),
  ADD KEY `fk_ap_created_by` (`created_by`);

--
-- Indices de la tabla `accounts_receivable`
--
ALTER TABLE `accounts_receivable`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ar_customer` (`customer_id`),
  ADD KEY `idx_ar_status` (`status`),
  ADD KEY `idx_ar_due_date` (`due_date`),
  ADD KEY `idx_ar_order` (`order_id`),
  ADD KEY `fk_ar_created_by` (`created_by`);

--
-- 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 `ap_payments`
--
ALTER TABLE `ap_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ap_payments_account` (`account_payable_id`),
  ADD KEY `idx_ap_payments_date` (`payment_date`),
  ADD KEY `fk_ap_payments_paid_by` (`paid_by`);

--
-- Indices de la tabla `ar_payments`
--
ALTER TABLE `ar_payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ar_payments_account` (`account_receivable_id`),
  ADD KEY `idx_ar_payments_date` (`payment_date`),
  ADD KEY `fk_ar_payments_received_by` (`received_by`);

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

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

--
-- Indices de la tabla `cash_transactions`
--
ALTER TABLE `cash_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `register_id` (`register_id`);

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

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

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

--
-- Indices de la tabla `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_customers_name` (`name`),
  ADD KEY `idx_customers_document` (`document_number`),
  ADD KEY `idx_customers_phone` (`phone`),
  ADD KEY `idx_customers_email` (`email`);

--
-- 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`),
  ADD KEY `idx_delivery_customer_id` (`customer_id`),
  ADD KEY `idx_delivery_orders_source_status` (`source`,`status`);

--
-- 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`),
  ADD KEY `idx_customer_id` (`customer_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 `expense_categories`
--
ALTER TABLE `expense_categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_expense_cat_name` (`name`);

--
-- Indices de la tabla `expense_subcategories`
--
ALTER TABLE `expense_subcategories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `uq_expense_subcat_name` (`category_id`,`name`),
  ADD KEY `idx_expense_subcat_category` (`category_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`),
  ADD KEY `idx_inventory_movements_provider` (`provider_id`),
  ADD KEY `idx_inventory_movements_document` (`document_number`);

--
-- 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 `order_item_cancellations`
--
ALTER TABLE `order_item_cancellations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_id` (`order_id`),
  ADD KEY `cancelled_at` (`cancelled_at`);

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

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

--
-- Indices de la tabla `printer_jobs`
--
ALTER TABLE `printer_jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_printer_jobs_printer` (`printer_id`),
  ADD KEY `idx_printer_jobs_order` (`source_type`,`order_id`);

--
-- Indices de la tabla `print_zones`
--
ALTER TABLE `print_zones`
  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`),
  ADD KEY `idx_products_printer_id` (`printer_id`);

--
-- 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 `providers`
--
ALTER TABLE `providers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_providers_name` (`name`);

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

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

--
-- Indices de la tabla `suppliers`
--
ALTER TABLE `suppliers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_suppliers_name` (`name`),
  ADD KEY `idx_suppliers_nit` (`nit`),
  ADD KEY `idx_suppliers_phone` (`phone`);

--
-- Indices de la tabla `tables`
--
ALTER TABLE `tables`
  ADD PRIMARY KEY (`id`),
  ADD KEY `room_id` (`room_id`);

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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 de la tabla `dine_in_order_preparers`
--
ALTER TABLE `dine_in_order_preparers`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `accounts_payable`
--
ALTER TABLE `accounts_payable`
  ADD CONSTRAINT `fk_ap_created_by` FOREIGN KEY (`created_by`) REFERENCES `admin` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_ap_supplier` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`);

--
-- Filtros para la tabla `accounts_receivable`
--
ALTER TABLE `accounts_receivable`
  ADD CONSTRAINT `fk_ar_created_by` FOREIGN KEY (`created_by`) REFERENCES `admin` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_ar_customer` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`);

--
-- 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 `ap_payments`
--
ALTER TABLE `ap_payments`
  ADD CONSTRAINT `fk_ap_payments_account` FOREIGN KEY (`account_payable_id`) REFERENCES `accounts_payable` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ap_payments_paid_by` FOREIGN KEY (`paid_by`) REFERENCES `admin` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `ar_payments`
--
ALTER TABLE `ar_payments`
  ADD CONSTRAINT `fk_ar_payments_account` FOREIGN KEY (`account_receivable_id`) REFERENCES `accounts_receivable` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_ar_payments_received_by` FOREIGN KEY (`received_by`) REFERENCES `admin` (`id`) ON DELETE SET NULL;

--
-- Filtros para la tabla `cash_transactions`
--
ALTER TABLE `cash_transactions`
  ADD CONSTRAINT `cash_transactions_ibfk_1` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `fk_category_catalog_type` FOREIGN KEY (`catalog_type_id`) REFERENCES `catalog_types` (`id`) ON DELETE SET NULL;

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

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

--
-- Filtros para la tabla `tables`
--
ALTER TABLE `tables`
  ADD CONSTRAINT `tables_ibfk_1` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`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.21
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