-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Feb 14, 2026 at 12:10 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 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 */; -- -- Database: `laravel-sas` -- -- -------------------------------------------------------- -- -- Table structure for table `api_keys` -- CREATE TABLE `api_keys` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `key` varchar(255) NOT NULL, `secret` varchar(255) NOT NULL, `last_used_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `audit_logs` -- CREATE TABLE `audit_logs` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `authorized_by_id` bigint(20) UNSIGNED DEFAULT NULL, `action` varchar(255) NOT NULL, `description` text DEFAULT NULL, `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)), `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)), `ip_address` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('laravel-cache-soliman@gmail.com|127.0.0.1', 'i:1;', 1771067249), ('laravel-cache-soliman@gmail.com|127.0.0.1:timer', 'i:1771067249;', 1771067249), ('laravel-cache-tenant_1_reports_dashboard_7_days', 'a:8:{s:6:\"labels\";O:29:\"Illuminate\\Support\\Collection\":2:{s:8:\"\0*\0items\";a:7:{i:0;s:6:\"Feb 08\";i:1;s:6:\"Feb 09\";i:2;s:6:\"Feb 10\";i:3;s:6:\"Feb 11\";i:4;s:6:\"Feb 12\";i:5;s:6:\"Feb 13\";i:6;s:6:\"Feb 14\";}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}s:5:\"sales\";O:29:\"Illuminate\\Support\\Collection\":2:{s:8:\"\0*\0items\";a:7:{i:0;s:7:\"1644.50\";i:1;s:7:\"1535.25\";i:2;s:7:\"3622.50\";i:3;s:7:\"2461.00\";i:4;s:7:\"2633.50\";i:5;s:7:\"2524.25\";i:6;s:7:\"1311.00\";}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}s:6:\"profit\";O:29:\"Illuminate\\Support\\Collection\":2:{s:8:\"\0*\0items\";a:7:{i:0;d:1254;i:1;d:1184.55;i:2;d:2762.5;i:3;d:1844;i:4;d:2072.8;i:5;d:1956.85;i:6;d:1029.8;}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}s:13:\"payment_split\";a:3:{s:6:\"online\";d:5071.5;s:4:\"card\";d:4830;s:4:\"cash\";d:5830.5;}s:12:\"source_split\";a:3:{s:8:\"takeaway\";d:5318.75;s:8:\"delivery\";d:5635;s:7:\"dine_in\";d:4778.25;}s:10:\"rush_hours\";a:24:{i:0;i:0;i:1;i:0;i:2;i:0;i:3;i:0;i:4;i:0;i:5;i:0;i:6;i:0;i:7;i:0;i:8;i:0;i:9;i:0;i:10;i:0;i:11;i:0;i:12;i:7;i:13;i:3;i:14;i:5;i:15;i:5;i:16;i:7;i:17;i:6;i:18;i:24;i:19;i:18;i:20;i:18;i:21;i:20;i:22;i:21;i:23;i:0;}s:13:\"period_totals\";a:3:{s:7:\"revenue\";d:15732;s:6:\"profit\";d:12104.5;s:6:\"orders\";i:134;}s:9:\"top_items\";O:29:\"Illuminate\\Support\\Collection\":2:{s:8:\"\0*\0items\";a:4:{i:0;O:8:\"stdClass\":4:{s:4:\"name\";s:20:\"Double Cheese Burger\";s:9:\"total_qty\";s:3:\"199\";s:13:\"total_revenue\";s:7:\"6965.00\";s:12:\"total_profit\";s:10:\"4577.00000\";}i:1;O:8:\"stdClass\":4:{s:4:\"name\";s:14:\"Classic Burger\";s:9:\"total_qty\";s:3:\"166\";s:13:\"total_revenue\";s:7:\"4150.00\";s:12:\"total_profit\";s:10:\"3071.00000\";}i:2;O:8:\"stdClass\":4:{s:4:\"name\";s:5:\"Fries\";s:9:\"total_qty\";s:3:\"160\";s:13:\"total_revenue\";s:7:\"1600.00\";s:12:\"total_profit\";s:10:\"1536.00000\";}i:3;O:8:\"stdClass\":4:{s:4:\"name\";s:4:\"Cola\";s:9:\"total_qty\";s:3:\"193\";s:13:\"total_revenue\";s:6:\"965.00\";s:12:\"total_profit\";s:9:\"868.50000\";}}s:28:\"\0*\0escapeWhenCastingToString\";b:0;}}', 1771067805); -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `slug` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `printer_id` bigint(20) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `tenant_id`, `name`, `slug`, `created_at`, `updated_at`, `printer_id`) VALUES (1, 1, 'Burgers', NULL, '2026-02-14 09:05:35', '2026-02-14 09:05:35', NULL), (2, 1, 'Drinks', NULL, '2026-02-14 09:05:35', '2026-02-14 09:05:35', NULL), (3, 1, 'Sides', NULL, '2026-02-14 09:05:35', '2026-02-14 09:05:35', NULL); -- -------------------------------------------------------- -- -- Table structure for table `customers` -- CREATE TABLE `customers` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `preferences` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`preferences`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `customer_stats` -- CREATE TABLE `customer_stats` ( `id` bigint(20) UNSIGNED NOT NULL, `customer_id` bigint(20) UNSIGNED NOT NULL, `total_spent` decimal(12,2) NOT NULL DEFAULT 0.00, `total_orders` int(11) NOT NULL DEFAULT 0, `favorite_product_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `daily_sales_summary` -- CREATE TABLE `daily_sales_summary` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `date` date NOT NULL, `gross_sales` decimal(12,2) NOT NULL DEFAULT 0.00, `net_sales` decimal(12,2) NOT NULL DEFAULT 0.00, `total_discounts` decimal(12,2) NOT NULL DEFAULT 0.00, `total_tax` decimal(12,2) NOT NULL DEFAULT 0.00, `total_cost` decimal(12,2) NOT NULL DEFAULT 0.00, `order_count` int(11) NOT NULL DEFAULT 0, `payment_methods` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`payment_methods`)), `source_distribution` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`source_distribution`)), `rush_hour_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`rush_hour_data`)), `category_sales` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`category_sales`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `daily_sales_summary` -- INSERT INTO `daily_sales_summary` (`id`, `tenant_id`, `date`, `gross_sales`, `net_sales`, `total_discounts`, `total_tax`, `total_cost`, `order_count`, `payment_methods`, `source_distribution`, `rush_hour_data`, `category_sales`, `created_at`, `updated_at`) VALUES (1, 1, '2026-02-08', 1430.00, 1644.50, 0.00, 214.50, 390.50, 12, '{\"online\":465.75,\"card\":373.75,\"cash\":805}', '{\"takeaway\":736,\"delivery\":402.5,\"dine_in\":506}', '[0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,1,0,0,2,0,2,4,2,0]', NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37'), (2, 1, '2026-02-09', 1335.00, 1535.25, 0.00, 200.25, 350.70, 13, '{\"card\":276,\"online\":925.75,\"cash\":333.5}', '{\"delivery\":948.75,\"dine_in\":23,\"takeaway\":563.5}', '[0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,3,2,1,2,0]', NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38'), (3, 1, '2026-02-10', 3150.00, 3622.50, 0.00, 472.50, 860.00, 29, '{\"online\":1863,\"cash\":500.25,\"card\":1259.25}', '{\"takeaway\":1104,\"delivery\":1690.5,\"dine_in\":828}', '[0,0,0,0,0,0,0,0,0,0,0,0,4,0,0,2,1,1,4,4,4,4,5,0]', NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38'), (4, 1, '2026-02-11', 2140.00, 2461.00, 0.00, 321.00, 617.00, 17, '{\"cash\":1322.5,\"online\":281.75,\"card\":856.75}', '{\"delivery\":1012,\"takeaway\":862.5,\"dine_in\":586.5}', '[0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,2,0,4,1,4,3,1,0]', NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39'), (5, 1, '2026-02-12', 2290.00, 2633.50, 0.00, 343.50, 560.70, 26, '{\"cash\":1414.5,\"card\":1012,\"online\":207}', '{\"delivery\":782,\"takeaway\":1230.5,\"dine_in\":621}', '[0,0,0,0,0,0,0,0,0,0,0,0,0,3,2,0,1,2,3,4,2,4,5,0]', NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39'), (6, 1, '2026-02-13', 2195.00, 2524.25, 0.00, 329.25, 567.40, 23, '{\"online\":810.75,\"card\":874,\"cash\":839.5}', '{\"takeaway\":615.25,\"delivery\":655.5,\"dine_in\":1253.5}', '[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,2,9,2,2,3,2,0]', NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40'), (7, 1, '2026-02-14', 1140.00, 1311.00, 0.00, 171.00, 281.20, 14, '{\"online\":517.5,\"cash\":615.25,\"card\":178.25}', '{\"dine_in\":960.25,\"delivery\":143.75,\"takeaway\":207}', '[0,0,0,0,0,0,0,0,0,0,0,0,1,0,1,0,0,0,1,4,2,1,4,0]', NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40'); -- -------------------------------------------------------- -- -- Table structure for table `drivers` -- CREATE TABLE `drivers` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `vehicle_info` varchar(255) DEFAULT NULL, `status` enum('available','busy','away') NOT NULL DEFAULT 'available', `current_lat` decimal(10,8) DEFAULT NULL, `current_lng` decimal(11,8) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `driver_settlements` -- CREATE TABLE `driver_settlements` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `driver_id` bigint(20) UNSIGNED NOT NULL, `cashier_id` bigint(20) UNSIGNED DEFAULT NULL, `amount` decimal(12,2) NOT NULL, `status` enum('pending','settled') NOT NULL DEFAULT 'pending', `settled_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext NOT NULL, `failed_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `ingredients` -- CREATE TABLE `ingredients` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `unit` varchar(255) NOT NULL, `cost_price` decimal(10,2) NOT NULL DEFAULT 0.00, `stock_quantity` decimal(15,3) NOT NULL DEFAULT 0.000, `reorder_level` decimal(15,3) NOT NULL DEFAULT 0.000, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `ingredients` -- INSERT INTO `ingredients` (`id`, `tenant_id`, `name`, `unit`, `cost_price`, `stock_quantity`, `reorder_level`, `created_at`, `updated_at`) VALUES (1, 1, 'Beef Patty', 'piece', 5.00, 1000.000, 10.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (2, 1, 'Bun', 'piece', 1.00, 1000.000, 10.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (3, 1, 'Cheese', 'slice', 0.50, 1000.000, 10.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (4, 1, 'Potato', 'kg', 2.00, 1000.000, 10.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (5, 1, 'Soda Syrup', 'liter', 10.00, 1000.000, 10.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `locations` -- CREATE TABLE `locations` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `type` enum('branch','central_kitchen','warehouse') NOT NULL, `address` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0000_01_01_000000_create_tenants_table', 1), (2, '0001_01_01_000000_create_users_table', 1), (3, '0001_01_01_000001_create_cache_table', 1), (4, '0001_01_01_000002_create_jobs_table', 1), (5, '2026_02_14_085430_create_categories_table', 1), (6, '2026_02_14_085430_create_products_table', 1), (7, '2026_02_14_085431_create_tables_table', 1), (8, '2026_02_14_090022_create_orders_table', 1), (9, '2026_02_14_090023_create_order_items_table', 1), (10, '2026_02_14_091456_create_ingredients_table', 1), (11, '2026_02_14_091456_create_recipes_table', 1), (12, '2026_02_14_091457_create_suppliers_table', 1), (13, '2026_02_14_091458_create_purchase_orders_table', 1), (14, '2026_02_14_091459_create_purchase_order_items_table', 1), (15, '2026_02_14_092205_add_qr_token_to_tables', 1), (16, '2026_02_14_092206_add_loyalty_points_to_users', 1), (17, '2026_02_14_092206_create_promo_codes_table', 1), (18, '2026_02_14_092853_create_printers_table', 1), (19, '2026_02_14_092854_add_printer_id_to_categories_table', 1), (20, '2026_02_14_093549_add_pin_code_to_users_table', 1), (21, '2026_02_14_093549_create_audit_logs_table', 1), (22, '2026_02_14_093550_add_void_fields_to_orders_table', 1), (23, '2026_02_14_093920_create_api_market_tables', 1), (24, '2026_02_14_093921_create_central_kitchen_tables', 1), (25, '2026_02_14_093921_create_promotions_and_crm_tables', 1), (26, '2026_02_14_094509_add_delivery_fields_to_orders_table', 1), (27, '2026_02_14_094509_create_drivers_table', 1), (28, '2026_02_14_094510_create_driver_settlements_table', 1), (29, '2026_02_14_095038_create_daily_sales_summary_table', 1), (30, '2026_02_14_095252_create_physical_counts_table', 1), (31, '2026_02_14_095535_add_advanced_fields_to_daily_sales_summary_table', 1), (32, '2026_02_14_110406_add_payment_method_to_orders_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `table_id` bigint(20) UNSIGNED DEFAULT NULL, `type` varchar(255) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `payment_method` varchar(255) DEFAULT NULL, `subtotal` decimal(10,2) NOT NULL, `tax` decimal(10,2) NOT NULL, `total` decimal(10,2) NOT NULL, `discount` decimal(10,2) NOT NULL DEFAULT 0.00, `notes` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `void_reason` varchar(255) DEFAULT NULL, `driver_id` bigint(20) UNSIGNED DEFAULT NULL, `delivery_status` enum('pending','shipped','delivered') DEFAULT NULL, `picked_up_at` timestamp NULL DEFAULT NULL, `delivered_at` timestamp NULL DEFAULT NULL, `expected_delivered_at` timestamp NULL DEFAULT NULL, `delivery_lat` decimal(10,8) DEFAULT NULL, `delivery_lng` decimal(11,8) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `tenant_id`, `table_id`, `type`, `status`, `payment_method`, `subtotal`, `tax`, `total`, `discount`, `notes`, `created_at`, `updated_at`, `void_reason`, `driver_id`, `delivery_status`, `picked_up_at`, `delivered_at`, `expected_delivered_at`, `delivery_lat`, `delivery_lng`) VALUES (1, 1, NULL, 'takeaway', 'delivered', 'online', 100.00, 15.00, 115.00, 0.00, NULL, '2026-02-08 10:20:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 10:44:36', NULL, NULL, NULL), (2, 1, NULL, 'delivery', 'delivered', 'card', 100.00, 15.00, 115.00, 0.00, NULL, '2026-02-08 19:47:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 20:23:36', NULL, NULL, NULL), (3, 1, NULL, 'takeaway', 'delivered', 'cash', 265.00, 39.75, 304.75, 0.00, NULL, '2026-02-08 18:19:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 18:31:36', NULL, NULL, NULL), (4, 1, NULL, 'takeaway', 'delivered', 'online', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-08 18:10:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 18:50:36', NULL, NULL, NULL), (5, 1, NULL, 'dine_in', 'delivered', 'cash', 200.00, 30.00, 230.00, 0.00, NULL, '2026-02-08 20:19:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 20:52:36', NULL, NULL, NULL), (6, 1, NULL, 'dine_in', 'delivered', 'cash', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-08 19:31:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 20:09:36', NULL, NULL, NULL), (7, 1, NULL, 'dine_in', 'delivered', 'online', 100.00, 15.00, 115.00, 0.00, NULL, '2026-02-08 19:46:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 19:59:36', NULL, NULL, NULL), (8, 1, NULL, 'takeaway', 'delivered', 'card', 155.00, 23.25, 178.25, 0.00, NULL, '2026-02-08 16:02:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 16:23:36', NULL, NULL, NULL), (9, 1, NULL, 'takeaway', 'delivered', 'card', 70.00, 10.50, 80.50, 0.00, NULL, '2026-02-08 20:57:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 21:14:36', NULL, NULL, NULL), (10, 1, NULL, 'dine_in', 'delivered', 'online', 110.00, 16.50, 126.50, 0.00, NULL, '2026-02-08 13:42:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 14:14:36', NULL, NULL, NULL), (11, 1, NULL, 'delivery', 'delivered', 'online', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-08 19:54:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 20:21:36', NULL, NULL, NULL), (12, 1, NULL, 'delivery', 'delivered', 'cash', 205.00, 30.75, 235.75, 0.00, NULL, '2026-02-08 16:00:36', '2026-02-14 09:05:36', NULL, NULL, NULL, NULL, '2026-02-08 16:11:36', NULL, NULL, NULL), (13, 1, NULL, 'delivery', 'delivered', 'card', 190.00, 28.50, 218.50, 0.00, NULL, '2026-02-09 20:21:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 20:54:36', NULL, NULL, NULL), (14, 1, NULL, 'dine_in', 'delivered', 'online', 20.00, 3.00, 23.00, 0.00, NULL, '2026-02-09 14:17:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 14:55:36', NULL, NULL, NULL), (15, 1, NULL, 'takeaway', 'delivered', 'cash', 115.00, 17.25, 132.25, 0.00, NULL, '2026-02-09 12:07:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 12:18:36', NULL, NULL, NULL), (16, 1, NULL, 'takeaway', 'delivered', 'online', 60.00, 9.00, 69.00, 0.00, NULL, '2026-02-09 16:21:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 16:55:36', NULL, NULL, NULL), (17, 1, NULL, 'takeaway', 'delivered', 'cash', 5.00, 0.75, 5.75, 0.00, NULL, '2026-02-09 18:41:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 18:58:36', NULL, NULL, NULL), (18, 1, NULL, 'delivery', 'delivered', 'cash', 55.00, 8.25, 63.25, 0.00, NULL, '2026-02-09 17:52:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 18:05:36', NULL, NULL, NULL), (19, 1, NULL, 'delivery', 'delivered', 'online', 130.00, 19.50, 149.50, 0.00, NULL, '2026-02-09 17:22:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 17:46:36', NULL, NULL, NULL), (20, 1, NULL, 'delivery', 'delivered', 'online', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-09 13:38:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 13:50:36', NULL, NULL, NULL), (21, 1, NULL, 'delivery', 'delivered', 'online', 140.00, 21.00, 161.00, 0.00, NULL, '2026-02-09 20:35:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 21:03:36', NULL, NULL, NULL), (22, 1, NULL, 'delivery', 'delivered', 'online', 205.00, 30.75, 235.75, 0.00, NULL, '2026-02-09 17:27:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 17:48:36', NULL, NULL, NULL), (23, 1, NULL, 'takeaway', 'delivered', 'online', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-09 15:26:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 15:58:36', NULL, NULL, NULL), (24, 1, NULL, 'takeaway', 'delivered', 'cash', 115.00, 17.25, 132.25, 0.00, NULL, '2026-02-09 19:42:36', '2026-02-14 09:05:37', NULL, NULL, NULL, NULL, '2026-02-09 19:57:36', NULL, NULL, NULL), (25, 1, NULL, 'takeaway', 'delivered', 'card', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-09 18:13:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-09 18:47:36', NULL, NULL, NULL), (26, 1, NULL, 'takeaway', 'delivered', 'online', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-10 15:39:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 16:18:36', NULL, NULL, NULL), (27, 1, NULL, 'delivery', 'delivered', 'cash', 170.00, 25.50, 195.50, 0.00, NULL, '2026-02-10 18:01:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 18:38:36', NULL, NULL, NULL), (28, 1, NULL, 'takeaway', 'delivered', 'online', 35.00, 5.25, 40.25, 0.00, NULL, '2026-02-10 17:49:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 18:14:36', NULL, NULL, NULL), (29, 1, NULL, 'delivery', 'delivered', 'cash', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-10 17:51:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 18:02:36', NULL, NULL, NULL), (30, 1, NULL, 'delivery', 'delivered', 'online', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-10 10:57:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 11:34:36', NULL, NULL, NULL), (31, 1, NULL, 'dine_in', 'delivered', 'card', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-10 10:50:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 11:06:36', NULL, NULL, NULL), (32, 1, NULL, 'delivery', 'delivered', 'online', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-10 17:14:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 17:45:36', NULL, NULL, NULL), (33, 1, NULL, 'takeaway', 'delivered', 'card', 170.00, 25.50, 195.50, 0.00, NULL, '2026-02-10 17:05:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 17:24:36', NULL, NULL, NULL), (34, 1, NULL, 'delivery', 'delivered', 'card', 190.00, 28.50, 218.50, 0.00, NULL, '2026-02-10 16:13:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 16:52:36', NULL, NULL, NULL), (35, 1, NULL, 'takeaway', 'delivered', 'online', 60.00, 9.00, 69.00, 0.00, NULL, '2026-02-10 18:36:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 18:55:36', NULL, NULL, NULL), (36, 1, NULL, 'dine_in', 'delivered', 'card', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-10 14:26:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 14:40:36', NULL, NULL, NULL), (37, 1, NULL, 'takeaway', 'delivered', 'online', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-10 16:55:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 17:17:36', NULL, NULL, NULL), (38, 1, NULL, 'delivery', 'delivered', 'cash', 95.00, 14.25, 109.25, 0.00, NULL, '2026-02-10 13:26:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 14:02:36', NULL, NULL, NULL), (39, 1, NULL, 'dine_in', 'delivered', 'cash', 55.00, 8.25, 63.25, 0.00, NULL, '2026-02-10 20:39:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 21:08:36', NULL, NULL, NULL), (40, 1, NULL, 'dine_in', 'delivered', 'cash', 55.00, 8.25, 63.25, 0.00, NULL, '2026-02-10 18:50:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 19:21:36', NULL, NULL, NULL), (41, 1, NULL, 'takeaway', 'delivered', 'online', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-10 20:34:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 21:08:36', NULL, NULL, NULL), (42, 1, NULL, 'delivery', 'delivered', 'online', 305.00, 45.75, 350.75, 0.00, NULL, '2026-02-10 10:51:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 11:28:36', NULL, NULL, NULL), (43, 1, NULL, 'takeaway', 'delivered', 'online', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-10 19:51:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 20:03:36', NULL, NULL, NULL), (44, 1, NULL, 'delivery', 'delivered', 'online', 115.00, 17.25, 132.25, 0.00, NULL, '2026-02-10 16:11:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 16:50:36', NULL, NULL, NULL), (45, 1, NULL, 'delivery', 'delivered', 'online', 140.00, 21.00, 161.00, 0.00, NULL, '2026-02-10 20:08:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 20:27:36', NULL, NULL, NULL), (46, 1, NULL, 'dine_in', 'delivered', 'online', 335.00, 50.25, 385.25, 0.00, NULL, '2026-02-10 20:30:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 21:04:36', NULL, NULL, NULL), (47, 1, NULL, 'delivery', 'delivered', 'online', 120.00, 18.00, 138.00, 0.00, NULL, '2026-02-10 18:33:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 19:13:36', NULL, NULL, NULL), (48, 1, NULL, 'dine_in', 'delivered', 'online', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-10 19:44:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 19:59:36', NULL, NULL, NULL), (49, 1, NULL, 'delivery', 'delivered', 'card', 130.00, 19.50, 149.50, 0.00, NULL, '2026-02-10 19:10:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 19:45:36', NULL, NULL, NULL), (50, 1, NULL, 'dine_in', 'delivered', 'card', 80.00, 12.00, 92.00, 0.00, NULL, '2026-02-10 10:42:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 11:09:36', NULL, NULL, NULL), (51, 1, NULL, 'dine_in', 'delivered', 'cash', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-10 16:21:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 16:42:36', NULL, NULL, NULL), (52, 1, NULL, 'takeaway', 'delivered', 'card', 185.00, 27.75, 212.75, 0.00, NULL, '2026-02-10 19:42:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 19:57:36', NULL, NULL, NULL), (53, 1, NULL, 'takeaway', 'delivered', 'card', 160.00, 24.00, 184.00, 0.00, NULL, '2026-02-10 13:16:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 13:44:36', NULL, NULL, NULL), (54, 1, NULL, 'takeaway', 'delivered', 'card', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-10 20:16:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-10 20:45:36', NULL, NULL, NULL), (55, 1, NULL, 'delivery', 'delivered', 'cash', 140.00, 21.00, 161.00, 0.00, NULL, '2026-02-11 19:35:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 19:58:36', NULL, NULL, NULL), (56, 1, NULL, 'takeaway', 'delivered', 'cash', 180.00, 27.00, 207.00, 0.00, NULL, '2026-02-11 18:44:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 18:56:36', NULL, NULL, NULL), (57, 1, NULL, 'delivery', 'delivered', 'cash', 190.00, 28.50, 218.50, 0.00, NULL, '2026-02-11 16:41:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 17:08:36', NULL, NULL, NULL), (58, 1, NULL, 'dine_in', 'delivered', 'online', 80.00, 12.00, 92.00, 0.00, NULL, '2026-02-11 16:00:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 16:26:36', NULL, NULL, NULL), (59, 1, NULL, 'dine_in', 'delivered', 'cash', 215.00, 32.25, 247.25, 0.00, NULL, '2026-02-11 14:59:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 15:09:36', NULL, NULL, NULL), (60, 1, NULL, 'takeaway', 'delivered', 'card', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-11 17:55:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 18:33:36', NULL, NULL, NULL), (61, 1, NULL, 'takeaway', 'delivered', 'cash', 205.00, 30.75, 235.75, 0.00, NULL, '2026-02-11 16:51:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 17:22:36', NULL, NULL, NULL), (62, 1, NULL, 'dine_in', 'delivered', 'online', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-11 10:18:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 10:28:36', NULL, NULL, NULL), (63, 1, NULL, 'dine_in', 'delivered', 'card', 110.00, 16.50, 126.50, 0.00, NULL, '2026-02-11 14:11:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 14:31:36', NULL, NULL, NULL), (64, 1, NULL, 'takeaway', 'delivered', 'cash', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-11 12:17:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 12:35:36', NULL, NULL, NULL), (65, 1, NULL, 'delivery', 'delivered', 'card', 95.00, 14.25, 109.25, 0.00, NULL, '2026-02-11 19:37:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 20:06:36', NULL, NULL, NULL), (66, 1, NULL, 'delivery', 'delivered', 'card', 70.00, 10.50, 80.50, 0.00, NULL, '2026-02-11 18:03:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 18:32:36', NULL, NULL, NULL), (67, 1, NULL, 'delivery', 'delivered', 'online', 60.00, 9.00, 69.00, 0.00, NULL, '2026-02-11 20:20:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 20:37:36', NULL, NULL, NULL), (68, 1, NULL, 'delivery', 'delivered', 'card', 95.00, 14.25, 109.25, 0.00, NULL, '2026-02-11 18:36:36', '2026-02-14 09:05:38', NULL, NULL, NULL, NULL, '2026-02-11 18:52:36', NULL, NULL, NULL), (69, 1, NULL, 'delivery', 'delivered', 'card', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-11 19:02:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-11 19:15:36', NULL, NULL, NULL), (70, 1, NULL, 'delivery', 'delivered', 'card', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-11 18:06:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-11 18:40:36', NULL, NULL, NULL), (71, 1, NULL, 'takeaway', 'delivered', 'cash', 170.00, 25.50, 195.50, 0.00, NULL, '2026-02-11 16:39:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-11 17:18:36', NULL, NULL, NULL), (72, 1, NULL, 'delivery', 'delivered', 'cash', 135.00, 20.25, 155.25, 0.00, NULL, '2026-02-12 20:55:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 21:15:36', NULL, NULL, NULL), (73, 1, NULL, 'takeaway', 'delivered', 'card', 35.00, 5.25, 40.25, 0.00, NULL, '2026-02-12 12:24:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 12:49:36', NULL, NULL, NULL), (74, 1, NULL, 'delivery', 'delivered', 'online', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-12 20:51:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 21:05:36', NULL, NULL, NULL), (75, 1, NULL, 'takeaway', 'delivered', 'card', 200.00, 30.00, 230.00, 0.00, NULL, '2026-02-12 18:45:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 19:15:36', NULL, NULL, NULL), (76, 1, NULL, 'dine_in', 'delivered', 'online', 120.00, 18.00, 138.00, 0.00, NULL, '2026-02-12 16:28:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 17:00:36', NULL, NULL, NULL), (77, 1, NULL, 'takeaway', 'delivered', 'card', 75.00, 11.25, 86.25, 0.00, NULL, '2026-02-12 19:11:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 19:43:36', NULL, NULL, NULL), (78, 1, NULL, 'takeaway', 'delivered', 'cash', 120.00, 18.00, 138.00, 0.00, NULL, '2026-02-12 15:55:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 16:14:36', NULL, NULL, NULL), (79, 1, NULL, 'takeaway', 'delivered', 'cash', 20.00, 3.00, 23.00, 0.00, NULL, '2026-02-12 14:13:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 14:28:36', NULL, NULL, NULL), (80, 1, NULL, 'delivery', 'delivered', 'card', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-12 11:09:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 11:29:36', NULL, NULL, NULL), (81, 1, NULL, 'delivery', 'delivered', 'cash', 220.00, 33.00, 253.00, 0.00, NULL, '2026-02-12 18:18:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 18:53:36', NULL, NULL, NULL), (82, 1, NULL, 'takeaway', 'delivered', 'cash', 165.00, 24.75, 189.75, 0.00, NULL, '2026-02-12 17:23:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 17:56:36', NULL, NULL, NULL), (83, 1, NULL, 'delivery', 'delivered', 'cash', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-12 20:25:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 20:47:36', NULL, NULL, NULL), (84, 1, NULL, 'delivery', 'delivered', 'card', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-12 19:46:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 20:21:36', NULL, NULL, NULL), (85, 1, NULL, 'takeaway', 'delivered', 'cash', 40.00, 6.00, 46.00, 0.00, NULL, '2026-02-12 20:27:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 20:58:36', NULL, NULL, NULL), (86, 1, NULL, 'dine_in', 'delivered', 'cash', 265.00, 39.75, 304.75, 0.00, NULL, '2026-02-12 17:01:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 17:19:36', NULL, NULL, NULL), (87, 1, NULL, 'takeaway', 'delivered', 'card', 95.00, 14.25, 109.25, 0.00, NULL, '2026-02-12 15:41:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 15:54:36', NULL, NULL, NULL), (88, 1, NULL, 'takeaway', 'delivered', 'card', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-12 11:09:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 11:28:36', NULL, NULL, NULL), (89, 1, NULL, 'takeaway', 'delivered', 'card', 170.00, 25.50, 195.50, 0.00, NULL, '2026-02-12 19:06:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 19:31:36', NULL, NULL, NULL), (90, 1, NULL, 'delivery', 'delivered', 'card', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-12 19:15:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 19:34:36', NULL, NULL, NULL), (91, 1, NULL, 'dine_in', 'delivered', 'card', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-12 20:16:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 20:28:36', NULL, NULL, NULL), (92, 1, NULL, 'delivery', 'delivered', 'card', 125.00, 18.75, 143.75, 0.00, NULL, '2026-02-12 16:57:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 17:11:36', NULL, NULL, NULL), (93, 1, NULL, 'takeaway', 'delivered', 'online', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-12 17:21:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 18:00:36', NULL, NULL, NULL), (94, 1, NULL, 'dine_in', 'delivered', 'cash', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-12 12:40:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 12:58:36', NULL, NULL, NULL), (95, 1, NULL, 'takeaway', 'delivered', 'cash', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-12 17:11:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 17:44:36', NULL, NULL, NULL), (96, 1, NULL, 'takeaway', 'delivered', 'cash', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-12 16:11:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 16:46:36', NULL, NULL, NULL), (97, 1, NULL, 'takeaway', 'delivered', 'cash', 15.00, 2.25, 17.25, 0.00, NULL, '2026-02-12 11:58:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-12 12:09:36', NULL, NULL, NULL), (98, 1, NULL, 'takeaway', 'delivered', 'online', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-13 16:46:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 16:58:36', NULL, NULL, NULL), (99, 1, NULL, 'delivery', 'delivered', 'card', 140.00, 21.00, 161.00, 0.00, NULL, '2026-02-13 16:45:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 17:08:36', NULL, NULL, NULL), (100, 1, NULL, 'dine_in', 'delivered', 'online', 25.00, 3.75, 28.75, 0.00, NULL, '2026-02-13 18:08:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 18:39:36', NULL, NULL, NULL), (101, 1, NULL, 'delivery', 'delivered', 'online', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-13 16:39:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 16:51:36', NULL, NULL, NULL), (102, 1, NULL, 'takeaway', 'delivered', 'cash', 120.00, 18.00, 138.00, 0.00, NULL, '2026-02-13 20:39:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 20:51:36', NULL, NULL, NULL), (103, 1, NULL, 'delivery', 'delivered', 'card', 45.00, 6.75, 51.75, 0.00, NULL, '2026-02-13 19:16:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 19:34:36', NULL, NULL, NULL), (104, 1, NULL, 'takeaway', 'delivered', 'cash', 20.00, 3.00, 23.00, 0.00, NULL, '2026-02-13 16:31:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 17:07:36', NULL, NULL, NULL), (105, 1, NULL, 'dine_in', 'delivered', 'card', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-13 16:57:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 17:17:36', NULL, NULL, NULL), (106, 1, NULL, 'dine_in', 'delivered', 'card', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-13 16:24:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 16:36:36', NULL, NULL, NULL), (107, 1, NULL, 'takeaway', 'delivered', 'card', 140.00, 21.00, 161.00, 0.00, NULL, '2026-02-13 17:10:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 17:40:36', NULL, NULL, NULL), (108, 1, NULL, 'delivery', 'delivered', 'cash', 50.00, 7.50, 57.50, 0.00, NULL, '2026-02-13 15:50:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 16:29:36', NULL, NULL, NULL), (109, 1, NULL, 'takeaway', 'delivered', 'card', 20.00, 3.00, 23.00, 0.00, NULL, '2026-02-13 16:41:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 17:07:36', NULL, NULL, NULL), (110, 1, NULL, 'delivery', 'delivered', 'online', 85.00, 12.75, 97.75, 0.00, NULL, '2026-02-13 19:29:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 19:44:36', NULL, NULL, NULL), (111, 1, NULL, 'delivery', 'delivered', 'cash', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-13 16:29:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 16:58:36', NULL, NULL, NULL), (112, 1, NULL, 'dine_in', 'delivered', 'cash', 145.00, 21.75, 166.75, 0.00, NULL, '2026-02-13 13:35:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 14:12:36', NULL, NULL, NULL), (113, 1, NULL, 'delivery', 'delivered', 'card', 95.00, 14.25, 109.25, 0.00, NULL, '2026-02-13 17:48:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 18:05:36', NULL, NULL, NULL), (114, 1, NULL, 'dine_in', 'delivered', 'cash', 135.00, 20.25, 155.25, 0.00, NULL, '2026-02-13 14:20:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 14:56:36', NULL, NULL, NULL), (115, 1, NULL, 'dine_in', 'delivered', 'cash', 115.00, 17.25, 132.25, 0.00, NULL, '2026-02-13 19:07:36', '2026-02-14 09:05:39', NULL, NULL, NULL, NULL, '2026-02-13 19:33:36', NULL, NULL, NULL), (116, 1, NULL, 'dine_in', 'delivered', 'online', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-13 15:17:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-13 15:32:36', NULL, NULL, NULL), (117, 1, NULL, 'takeaway', 'delivered', 'online', 190.00, 28.50, 218.50, 0.00, NULL, '2026-02-13 18:13:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-13 18:48:36', NULL, NULL, NULL), (118, 1, NULL, 'dine_in', 'delivered', 'online', 215.00, 32.25, 247.25, 0.00, NULL, '2026-02-13 14:49:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-13 15:22:36', NULL, NULL, NULL), (119, 1, NULL, 'dine_in', 'delivered', 'online', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-13 16:47:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-13 17:08:36', NULL, NULL, NULL), (120, 1, NULL, 'dine_in', 'delivered', 'card', 130.00, 19.50, 149.50, 0.00, NULL, '2026-02-13 20:21:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-13 20:40:36', NULL, NULL, NULL), (121, 1, NULL, 'dine_in', 'delivered', 'online', 35.00, 5.25, 40.25, 0.00, NULL, '2026-02-14 10:48:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 11:09:36', NULL, NULL, NULL), (122, 1, NULL, 'dine_in', 'delivered', 'cash', 155.00, 23.25, 178.25, 0.00, NULL, '2026-02-14 17:53:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 18:19:36', NULL, NULL, NULL), (123, 1, NULL, 'delivery', 'delivered', 'card', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-14 16:20:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 16:36:36', NULL, NULL, NULL), (124, 1, NULL, 'dine_in', 'delivered', 'cash', 75.00, 11.25, 86.25, 0.00, NULL, '2026-02-14 20:03:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 20:23:36', NULL, NULL, NULL), (125, 1, NULL, 'dine_in', 'delivered', 'cash', 20.00, 3.00, 23.00, 0.00, NULL, '2026-02-14 20:33:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 20:53:36', NULL, NULL, NULL), (126, 1, NULL, 'takeaway', 'delivered', 'online', 65.00, 9.75, 74.75, 0.00, NULL, '2026-02-14 20:32:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 21:08:36', NULL, NULL, NULL), (127, 1, NULL, 'takeaway', 'delivered', 'online', 25.00, 3.75, 28.75, 0.00, NULL, '2026-02-14 17:56:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 18:29:36', NULL, NULL, NULL), (128, 1, NULL, 'dine_in', 'delivered', 'online', 250.00, 37.50, 287.50, 0.00, NULL, '2026-02-14 17:09:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 17:41:36', NULL, NULL, NULL), (129, 1, NULL, 'dine_in', 'delivered', 'cash', 225.00, 33.75, 258.75, 0.00, NULL, '2026-02-14 17:44:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 17:56:36', NULL, NULL, NULL), (130, 1, NULL, 'delivery', 'delivered', 'card', 105.00, 15.75, 120.75, 0.00, NULL, '2026-02-14 20:32:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 21:12:36', NULL, NULL, NULL), (131, 1, NULL, 'dine_in', 'delivered', 'online', 75.00, 11.25, 86.25, 0.00, NULL, '2026-02-14 12:14:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 12:45:36', NULL, NULL, NULL), (132, 1, NULL, 'takeaway', 'delivered', 'card', 30.00, 4.50, 34.50, 0.00, NULL, '2026-02-14 18:45:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 19:04:36', NULL, NULL, NULL), (133, 1, NULL, 'delivery', 'delivered', 'card', 10.00, 1.50, 11.50, 0.00, NULL, '2026-02-14 19:17:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 19:37:36', NULL, NULL, NULL), (134, 1, NULL, 'takeaway', 'delivered', 'cash', 60.00, 9.00, 69.00, 0.00, NULL, '2026-02-14 18:18:36', '2026-02-14 09:05:40', NULL, NULL, NULL, NULL, '2026-02-14 18:43:36', NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `order_items` -- CREATE TABLE `order_items` ( `id` bigint(20) UNSIGNED NOT NULL, `order_id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `quantity` int(11) NOT NULL, `price` decimal(10,2) NOT NULL, `options` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`options`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `is_voided` tinyint(1) NOT NULL DEFAULT 0, `void_reason` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `order_items` -- INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `quantity`, `price`, `options`, `created_at`, `updated_at`, `is_voided`, `void_reason`) VALUES (1, 1, 3, 3, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (2, 1, 2, 2, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (3, 2, 1, 3, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (4, 2, 1, 1, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (5, 3, 2, 3, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (6, 3, 3, 2, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (7, 3, 4, 1, 5.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (8, 3, 3, 3, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (9, 3, 2, 3, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (10, 4, 1, 2, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (11, 5, 1, 1, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (12, 5, 2, 3, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (13, 5, 2, 2, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (14, 6, 3, 3, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (15, 7, 2, 1, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (16, 7, 4, 1, 5.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (17, 7, 1, 1, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (18, 7, 4, 3, 5.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (19, 7, 3, 2, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (20, 8, 1, 2, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (21, 8, 2, 1, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (22, 8, 2, 2, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (23, 9, 1, 2, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (24, 9, 3, 2, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (25, 10, 1, 2, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (26, 10, 1, 1, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (27, 10, 2, 1, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (28, 11, 3, 2, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (29, 11, 1, 1, 25.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (30, 12, 2, 2, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (31, 12, 2, 3, 35.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (32, 12, 3, 1, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (33, 12, 3, 2, 10.00, NULL, '2026-02-14 09:05:36', '2026-02-14 09:05:36', 0, NULL), (34, 13, 4, 1, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (35, 13, 2, 2, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (36, 13, 2, 3, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (37, 13, 4, 2, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (38, 14, 3, 2, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (39, 15, 1, 3, 25.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (40, 15, 3, 3, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (41, 15, 3, 1, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (42, 16, 3, 3, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (43, 16, 3, 3, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (44, 17, 4, 1, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (45, 18, 2, 1, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (46, 18, 3, 2, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (47, 19, 2, 3, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (48, 19, 1, 1, 25.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (49, 20, 2, 3, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (50, 21, 4, 2, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (51, 21, 2, 3, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (52, 21, 1, 1, 25.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (53, 22, 1, 3, 25.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (54, 22, 1, 3, 25.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (55, 22, 2, 1, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (56, 22, 3, 2, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (57, 23, 2, 2, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (58, 23, 4, 1, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (59, 23, 2, 2, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (60, 24, 4, 2, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (61, 24, 4, 1, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (62, 24, 3, 3, 10.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (63, 24, 2, 2, 35.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (64, 25, 4, 2, 5.00, NULL, '2026-02-14 09:05:37', '2026-02-14 09:05:37', 0, NULL), (65, 25, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (66, 25, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (67, 26, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (68, 26, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (69, 27, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (70, 27, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (71, 27, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (72, 27, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (73, 28, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (74, 29, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (75, 30, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (76, 30, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (77, 31, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (78, 31, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (79, 31, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (80, 31, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (81, 32, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (82, 32, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (83, 33, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (84, 33, 3, 3, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (85, 33, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (86, 33, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (87, 33, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (88, 34, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (89, 34, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (90, 34, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (91, 35, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (92, 35, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (93, 35, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (94, 35, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (95, 36, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (96, 37, 3, 3, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (97, 38, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (98, 38, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (99, 38, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (100, 38, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (101, 39, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (102, 39, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (103, 39, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (104, 40, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (105, 40, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (106, 40, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (107, 41, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (108, 41, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (109, 41, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (110, 42, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (111, 42, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (112, 42, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (113, 42, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (114, 42, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (115, 43, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (116, 43, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (117, 43, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (118, 44, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (119, 44, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (120, 44, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (121, 44, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (122, 44, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (123, 45, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (124, 45, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (125, 45, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (126, 46, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (127, 46, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (128, 46, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (129, 46, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (130, 46, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (131, 47, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (132, 47, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (133, 47, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (134, 48, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (135, 49, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (136, 49, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (137, 49, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (138, 49, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (139, 49, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (140, 50, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (141, 50, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (142, 50, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (143, 51, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (144, 51, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (145, 52, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (146, 52, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (147, 52, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (148, 52, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (149, 53, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (150, 53, 3, 3, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (151, 53, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (152, 54, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (153, 54, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (154, 54, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (155, 55, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (156, 55, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (157, 56, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (158, 56, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (159, 56, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (160, 56, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (161, 57, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (162, 57, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (163, 57, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (164, 57, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (165, 58, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (166, 58, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (167, 58, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (168, 58, 3, 1, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (169, 59, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (170, 59, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (171, 59, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (172, 59, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (173, 59, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (174, 60, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (175, 60, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (176, 60, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (177, 60, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (178, 61, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (179, 61, 2, 3, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (180, 61, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (181, 61, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (182, 62, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (183, 62, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (184, 62, 4, 3, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (185, 63, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (186, 63, 2, 1, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (187, 64, 1, 2, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (188, 65, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (189, 65, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (190, 66, 2, 2, 35.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (191, 67, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (192, 67, 1, 1, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (193, 67, 4, 1, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (194, 67, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (195, 68, 3, 2, 10.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (196, 68, 1, 3, 25.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (197, 69, 4, 2, 5.00, NULL, '2026-02-14 09:05:38', '2026-02-14 09:05:38', 0, NULL), (198, 69, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (199, 70, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (200, 70, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (201, 71, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (202, 71, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (203, 71, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (204, 72, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (205, 72, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (206, 72, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (207, 72, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (208, 72, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (209, 73, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (210, 74, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (211, 75, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (212, 75, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (213, 75, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (214, 75, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (215, 75, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (216, 76, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (217, 76, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (218, 76, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (219, 76, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (220, 77, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (221, 77, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (222, 77, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (223, 78, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (224, 78, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (225, 78, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (226, 79, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (227, 80, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (228, 81, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (229, 81, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (230, 81, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (231, 81, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (232, 81, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (233, 82, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (234, 82, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (235, 82, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (236, 82, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (237, 82, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (238, 83, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (239, 83, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (240, 84, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (241, 84, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (242, 84, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (243, 85, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (244, 85, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (245, 85, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (246, 86, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (247, 86, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (248, 86, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (249, 86, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (250, 86, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (251, 87, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (252, 87, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (253, 87, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (254, 87, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (255, 88, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (256, 89, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (257, 89, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (258, 89, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (259, 89, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (260, 90, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (261, 91, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (262, 92, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (263, 92, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (264, 93, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (265, 94, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (266, 95, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (267, 96, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (268, 96, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (269, 97, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (270, 98, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (271, 98, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (272, 99, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (273, 99, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (274, 99, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (275, 99, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (276, 100, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (277, 101, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (278, 102, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (279, 102, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (280, 102, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (281, 103, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (282, 103, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (283, 104, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (284, 105, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (285, 105, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (286, 105, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (287, 105, 1, 1, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (288, 105, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (289, 106, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (290, 106, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (291, 107, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (292, 107, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (293, 107, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (294, 107, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (295, 107, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (296, 108, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (297, 109, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (298, 109, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (299, 110, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (300, 110, 1, 3, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (301, 111, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (302, 111, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (303, 111, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (304, 111, 2, 1, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (305, 111, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (306, 112, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (307, 112, 3, 2, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (308, 112, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (309, 112, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (310, 113, 2, 2, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (311, 113, 3, 1, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (312, 113, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (313, 113, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (314, 114, 2, 3, 35.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (315, 114, 4, 2, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (316, 114, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (317, 114, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (318, 115, 4, 1, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (319, 115, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (320, 115, 3, 3, 10.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (321, 115, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (322, 115, 1, 2, 25.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (323, 116, 4, 3, 5.00, NULL, '2026-02-14 09:05:39', '2026-02-14 09:05:39', 0, NULL), (324, 116, 4, 3, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (325, 117, 2, 2, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (326, 117, 3, 1, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (327, 117, 2, 1, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (328, 117, 1, 1, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (329, 117, 1, 2, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (330, 118, 1, 1, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (331, 118, 4, 2, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (332, 118, 1, 3, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (333, 118, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (334, 119, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (335, 120, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (336, 120, 3, 1, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (337, 120, 4, 3, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (338, 121, 4, 3, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (339, 121, 3, 2, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (340, 122, 2, 1, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (341, 122, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (342, 122, 4, 3, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (343, 123, 4, 2, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (344, 124, 1, 3, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (345, 125, 3, 2, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (346, 126, 4, 1, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (347, 126, 3, 2, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (348, 126, 4, 3, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (349, 126, 3, 2, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (350, 126, 4, 1, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (351, 127, 1, 1, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (352, 128, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (353, 128, 3, 3, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (354, 128, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (355, 128, 4, 2, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (356, 129, 2, 1, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (357, 129, 2, 2, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (358, 129, 4, 2, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (359, 129, 2, 3, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (360, 129, 4, 1, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (361, 130, 4, 1, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (362, 130, 3, 3, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (363, 130, 2, 2, 35.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (364, 131, 1, 3, 25.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (365, 132, 3, 3, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (366, 133, 3, 1, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (367, 134, 3, 1, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (368, 134, 4, 2, 5.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (369, 134, 3, 3, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL), (370, 134, 3, 1, 10.00, NULL, '2026-02-14 09:05:40', '2026-02-14 09:05:40', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `physical_counts` -- CREATE TABLE `physical_counts` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `ingredient_id` bigint(20) UNSIGNED NOT NULL, `theoretical_qty` decimal(10,2) NOT NULL, `physical_qty` decimal(10,2) NOT NULL, `variance` decimal(10,2) NOT NULL, `reason` varchar(255) DEFAULT NULL, `recorded_by_id` bigint(20) UNSIGNED NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `printers` -- CREATE TABLE `printers` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `connection_type` varchar(255) NOT NULL, `ip_address` varchar(255) DEFAULT NULL, `port` int(11) NOT NULL DEFAULT 9100, `type` enum('cashier','kitchen','bar','other') NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `category_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `description` text DEFAULT NULL, `price` decimal(10,2) NOT NULL, `image` varchar(255) DEFAULT NULL, `is_available` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `tenant_id`, `category_id`, `name`, `description`, `price`, `image`, `is_available`, `created_at`, `updated_at`) VALUES (1, 1, 1, 'Classic Burger', NULL, 25.00, NULL, 1, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (2, 1, 1, 'Double Cheese Burger', NULL, 35.00, NULL, 1, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (3, 1, 3, 'Fries', NULL, 10.00, NULL, 1, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (4, 1, 2, 'Cola', NULL, 5.00, NULL, 1, '2026-02-14 09:05:36', '2026-02-14 09:05:36'); -- -------------------------------------------------------- -- -- Table structure for table `promotions` -- CREATE TABLE `promotions` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `rules` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`rules`)), `starts_at` timestamp NULL DEFAULT NULL, `ends_at` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `promo_codes` -- CREATE TABLE `promo_codes` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `code` varchar(255) NOT NULL, `type` enum('fixed','percentage') NOT NULL, `value` decimal(10,2) NOT NULL, `starts_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_orders` -- CREATE TABLE `purchase_orders` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `supplier_id` bigint(20) UNSIGNED NOT NULL, `total_amount` decimal(15,2) NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'draft', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_order_items` -- CREATE TABLE `purchase_order_items` ( `id` bigint(20) UNSIGNED NOT NULL, `purchase_order_id` bigint(20) UNSIGNED NOT NULL, `ingredient_id` bigint(20) UNSIGNED NOT NULL, `quantity` decimal(15,3) NOT NULL, `cost_price` decimal(15,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `recipes` -- CREATE TABLE `recipes` ( `id` bigint(20) UNSIGNED NOT NULL, `product_id` bigint(20) UNSIGNED NOT NULL, `ingredient_id` bigint(20) UNSIGNED NOT NULL, `quantity` decimal(15,3) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `recipes` -- INSERT INTO `recipes` (`id`, `product_id`, `ingredient_id`, `quantity`, `created_at`, `updated_at`) VALUES (1, 1, 1, 1.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (2, 1, 2, 1.000, '2026-02-14 09:05:35', '2026-02-14 09:05:35'), (3, 1, 3, 1.000, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (4, 2, 1, 2.000, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (5, 2, 2, 1.000, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (6, 2, 3, 2.000, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (7, 3, 4, 0.200, '2026-02-14 09:05:36', '2026-02-14 09:05:36'), (8, 4, 5, 0.050, '2026-02-14 09:05:36', '2026-02-14 09:05:36'); -- -------------------------------------------------------- -- -- Table structure for table `sessions` -- CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('ney63zL6AYIOxLnJ8Jsz8W3JnAjRcSxgVs5wiNwS', 3, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiclB3WTc5N1g0TFBUemNYdDJNb2FiS3hlVEdJdGtQUGI1THhlUFRlQiI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjI6e3M6MzoidXJsIjtzOjMxOiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvZGFzaGJvYXJkIjtzOjU6InJvdXRlIjtzOjk6ImRhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjM7fQ==', 1771067363); -- -------------------------------------------------------- -- -- Table structure for table `suppliers` -- CREATE TABLE `suppliers` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `contact_info` text DEFAULT NULL, `balance` decimal(15,2) NOT NULL DEFAULT 0.00, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tables` -- CREATE TABLE `tables` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `qr_token` varchar(255) DEFAULT NULL, `capacity` int(11) NOT NULL DEFAULT 4, `status` varchar(255) NOT NULL DEFAULT 'clean', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tenants` -- CREATE TABLE `tenants` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `domain` varchar(255) DEFAULT NULL, `subdomain` varchar(255) DEFAULT NULL, `settings` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`settings`)), `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tenants` -- INSERT INTO `tenants` (`id`, `name`, `domain`, `subdomain`, `settings`, `created_at`, `updated_at`) VALUES (1, 'Demo Tenant', NULL, 'demo', NULL, '2026-02-14 09:05:35', '2026-02-14 09:05:35'); -- -------------------------------------------------------- -- -- Table structure for table `transfer_orders` -- CREATE TABLE `transfer_orders` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `from_location_id` bigint(20) UNSIGNED NOT NULL, `to_location_id` bigint(20) UNSIGNED NOT NULL, `status` enum('pending','shipped','received','cancelled') NOT NULL, `shipped_at` timestamp NULL DEFAULT NULL, `received_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `transfer_order_items` -- CREATE TABLE `transfer_order_items` ( `id` bigint(20) UNSIGNED NOT NULL, `transfer_order_id` bigint(20) UNSIGNED NOT NULL, `ingredient_id` bigint(20) UNSIGNED NOT NULL, `quantity` decimal(10,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `pin_code` varchar(255) DEFAULT NULL, `loyalty_points` int(11) NOT NULL DEFAULT 0, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `tenant_id`, `name`, `email`, `email_verified_at`, `password`, `pin_code`, `loyalty_points`, `remember_token`, `created_at`, `updated_at`) VALUES (3, 1, 'Soliman', 'soliman@example.com', NULL, '$2y$12$2jlGnUbzxT88LVFpfr0SMuOAdFGu5y82HQ4Z5/jHkInhVUWa9ga/a', NULL, 0, NULL, '2026-02-14 09:05:35', '2026-02-14 09:05:35'); -- -------------------------------------------------------- -- -- Table structure for table `webhook_subscriptions` -- CREATE TABLE `webhook_subscriptions` ( `id` bigint(20) UNSIGNED NOT NULL, `tenant_id` bigint(20) UNSIGNED NOT NULL, `event` varchar(255) NOT NULL, `url` varchar(255) NOT NULL, `secret` varchar(255) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `api_keys` -- ALTER TABLE `api_keys` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `api_keys_key_unique` (`key`), ADD KEY `api_keys_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `audit_logs` -- ALTER TABLE `audit_logs` ADD PRIMARY KEY (`id`), ADD KEY `audit_logs_tenant_id_foreign` (`tenant_id`), ADD KEY `audit_logs_user_id_foreign` (`user_id`), ADD KEY `audit_logs_authorized_by_id_foreign` (`authorized_by_id`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`), ADD KEY `cache_expiration_index` (`expiration`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`), ADD KEY `cache_locks_expiration_index` (`expiration`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`), ADD KEY `categories_tenant_id_foreign` (`tenant_id`), ADD KEY `categories_printer_id_foreign` (`printer_id`); -- -- Indexes for table `customers` -- ALTER TABLE `customers` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `customers_phone_unique` (`phone`), ADD KEY `customers_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `customer_stats` -- ALTER TABLE `customer_stats` ADD PRIMARY KEY (`id`), ADD KEY `customer_stats_customer_id_foreign` (`customer_id`), ADD KEY `customer_stats_favorite_product_id_foreign` (`favorite_product_id`); -- -- Indexes for table `daily_sales_summary` -- ALTER TABLE `daily_sales_summary` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `daily_sales_summary_tenant_id_date_unique` (`tenant_id`,`date`), ADD KEY `daily_sales_summary_date_index` (`date`); -- -- Indexes for table `drivers` -- ALTER TABLE `drivers` ADD PRIMARY KEY (`id`), ADD KEY `drivers_tenant_id_foreign` (`tenant_id`), ADD KEY `drivers_user_id_foreign` (`user_id`); -- -- Indexes for table `driver_settlements` -- ALTER TABLE `driver_settlements` ADD PRIMARY KEY (`id`), ADD KEY `driver_settlements_tenant_id_foreign` (`tenant_id`), ADD KEY `driver_settlements_driver_id_foreign` (`driver_id`), ADD KEY `driver_settlements_cashier_id_foreign` (`cashier_id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `ingredients` -- ALTER TABLE `ingredients` ADD PRIMARY KEY (`id`), ADD KEY `ingredients_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indexes for table `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indexes for table `locations` -- ALTER TABLE `locations` ADD PRIMARY KEY (`id`), ADD KEY `locations_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`), ADD KEY `orders_tenant_id_foreign` (`tenant_id`), ADD KEY `orders_table_id_foreign` (`table_id`), ADD KEY `orders_driver_id_foreign` (`driver_id`); -- -- Indexes for table `order_items` -- ALTER TABLE `order_items` ADD PRIMARY KEY (`id`), ADD KEY `order_items_order_id_foreign` (`order_id`), ADD KEY `order_items_product_id_foreign` (`product_id`); -- -- Indexes for table `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indexes for table `physical_counts` -- ALTER TABLE `physical_counts` ADD PRIMARY KEY (`id`), ADD KEY `physical_counts_tenant_id_foreign` (`tenant_id`), ADD KEY `physical_counts_ingredient_id_foreign` (`ingredient_id`), ADD KEY `physical_counts_recorded_by_id_foreign` (`recorded_by_id`); -- -- Indexes for table `printers` -- ALTER TABLE `printers` ADD PRIMARY KEY (`id`), ADD KEY `printers_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`), ADD KEY `products_tenant_id_foreign` (`tenant_id`), ADD KEY `products_category_id_foreign` (`category_id`); -- -- Indexes for table `promotions` -- ALTER TABLE `promotions` ADD PRIMARY KEY (`id`), ADD KEY `promotions_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `promo_codes` -- ALTER TABLE `promo_codes` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `promo_codes_code_unique` (`code`), ADD KEY `promo_codes_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `purchase_orders` -- ALTER TABLE `purchase_orders` ADD PRIMARY KEY (`id`), ADD KEY `purchase_orders_tenant_id_foreign` (`tenant_id`), ADD KEY `purchase_orders_supplier_id_foreign` (`supplier_id`); -- -- Indexes for table `purchase_order_items` -- ALTER TABLE `purchase_order_items` ADD PRIMARY KEY (`id`), ADD KEY `purchase_order_items_purchase_order_id_foreign` (`purchase_order_id`), ADD KEY `purchase_order_items_ingredient_id_foreign` (`ingredient_id`); -- -- Indexes for table `recipes` -- ALTER TABLE `recipes` ADD PRIMARY KEY (`id`), ADD KEY `recipes_product_id_foreign` (`product_id`), ADD KEY `recipes_ingredient_id_foreign` (`ingredient_id`); -- -- Indexes for table `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indexes for table `suppliers` -- ALTER TABLE `suppliers` ADD PRIMARY KEY (`id`), ADD KEY `suppliers_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `tables` -- ALTER TABLE `tables` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tables_qr_token_unique` (`qr_token`), ADD KEY `tables_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `tenants` -- ALTER TABLE `tenants` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `tenants_domain_unique` (`domain`), ADD UNIQUE KEY `tenants_subdomain_unique` (`subdomain`); -- -- Indexes for table `transfer_orders` -- ALTER TABLE `transfer_orders` ADD PRIMARY KEY (`id`), ADD KEY `transfer_orders_tenant_id_foreign` (`tenant_id`), ADD KEY `transfer_orders_from_location_id_foreign` (`from_location_id`), ADD KEY `transfer_orders_to_location_id_foreign` (`to_location_id`); -- -- Indexes for table `transfer_order_items` -- ALTER TABLE `transfer_order_items` ADD PRIMARY KEY (`id`), ADD KEY `transfer_order_items_transfer_order_id_foreign` (`transfer_order_id`), ADD KEY `transfer_order_items_ingredient_id_foreign` (`ingredient_id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_tenant_id_foreign` (`tenant_id`); -- -- Indexes for table `webhook_subscriptions` -- ALTER TABLE `webhook_subscriptions` ADD PRIMARY KEY (`id`), ADD KEY `webhook_subscriptions_tenant_id_foreign` (`tenant_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `api_keys` -- ALTER TABLE `api_keys` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `audit_logs` -- ALTER TABLE `audit_logs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `customers` -- ALTER TABLE `customers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `customer_stats` -- ALTER TABLE `customer_stats` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `daily_sales_summary` -- ALTER TABLE `daily_sales_summary` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `drivers` -- ALTER TABLE `drivers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `driver_settlements` -- ALTER TABLE `driver_settlements` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ingredients` -- ALTER TABLE `ingredients` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `locations` -- ALTER TABLE `locations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135; -- -- AUTO_INCREMENT for table `order_items` -- ALTER TABLE `order_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=371; -- -- AUTO_INCREMENT for table `physical_counts` -- ALTER TABLE `physical_counts` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `printers` -- ALTER TABLE `printers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `promotions` -- ALTER TABLE `promotions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `promo_codes` -- ALTER TABLE `promo_codes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_orders` -- ALTER TABLE `purchase_orders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_order_items` -- ALTER TABLE `purchase_order_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `recipes` -- ALTER TABLE `recipes` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `suppliers` -- ALTER TABLE `suppliers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tables` -- ALTER TABLE `tables` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tenants` -- ALTER TABLE `tenants` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `transfer_orders` -- ALTER TABLE `transfer_orders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transfer_order_items` -- ALTER TABLE `transfer_order_items` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `webhook_subscriptions` -- ALTER TABLE `webhook_subscriptions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- Constraints for dumped tables -- -- -- Constraints for table `api_keys` -- ALTER TABLE `api_keys` ADD CONSTRAINT `api_keys_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `audit_logs` -- ALTER TABLE `audit_logs` ADD CONSTRAINT `audit_logs_authorized_by_id_foreign` FOREIGN KEY (`authorized_by_id`) REFERENCES `users` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `audit_logs_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `categories` -- ALTER TABLE `categories` ADD CONSTRAINT `categories_printer_id_foreign` FOREIGN KEY (`printer_id`) REFERENCES `printers` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `categories_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `customers` -- ALTER TABLE `customers` ADD CONSTRAINT `customers_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `customer_stats` -- ALTER TABLE `customer_stats` ADD CONSTRAINT `customer_stats_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `customer_stats_favorite_product_id_foreign` FOREIGN KEY (`favorite_product_id`) REFERENCES `products` (`id`); -- -- Constraints for table `daily_sales_summary` -- ALTER TABLE `daily_sales_summary` ADD CONSTRAINT `daily_sales_summary_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `drivers` -- ALTER TABLE `drivers` ADD CONSTRAINT `drivers_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `drivers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `driver_settlements` -- ALTER TABLE `driver_settlements` ADD CONSTRAINT `driver_settlements_cashier_id_foreign` FOREIGN KEY (`cashier_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `driver_settlements_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `driver_settlements_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `ingredients` -- ALTER TABLE `ingredients` ADD CONSTRAINT `ingredients_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `locations` -- ALTER TABLE `locations` ADD CONSTRAINT `locations_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `orders` -- ALTER TABLE `orders` ADD CONSTRAINT `orders_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `orders_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`) ON DELETE SET NULL, ADD CONSTRAINT `orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `order_items` -- ALTER TABLE `order_items` ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `physical_counts` -- ALTER TABLE `physical_counts` ADD CONSTRAINT `physical_counts_ingredient_id_foreign` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`), ADD CONSTRAINT `physical_counts_recorded_by_id_foreign` FOREIGN KEY (`recorded_by_id`) REFERENCES `users` (`id`), ADD CONSTRAINT `physical_counts_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `printers` -- ALTER TABLE `printers` ADD CONSTRAINT `printers_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `products` -- ALTER TABLE `products` ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `products_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `promotions` -- ALTER TABLE `promotions` ADD CONSTRAINT `promotions_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `promo_codes` -- ALTER TABLE `promo_codes` ADD CONSTRAINT `promo_codes_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `purchase_orders` -- ALTER TABLE `purchase_orders` ADD CONSTRAINT `purchase_orders_supplier_id_foreign` FOREIGN KEY (`supplier_id`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `purchase_orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `purchase_order_items` -- ALTER TABLE `purchase_order_items` ADD CONSTRAINT `purchase_order_items_ingredient_id_foreign` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `purchase_order_items_purchase_order_id_foreign` FOREIGN KEY (`purchase_order_id`) REFERENCES `purchase_orders` (`id`) ON DELETE CASCADE; -- -- Constraints for table `recipes` -- ALTER TABLE `recipes` ADD CONSTRAINT `recipes_ingredient_id_foreign` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `recipes_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE; -- -- Constraints for table `suppliers` -- ALTER TABLE `suppliers` ADD CONSTRAINT `suppliers_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `tables` -- ALTER TABLE `tables` ADD CONSTRAINT `tables_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `transfer_orders` -- ALTER TABLE `transfer_orders` ADD CONSTRAINT `transfer_orders_from_location_id_foreign` FOREIGN KEY (`from_location_id`) REFERENCES `locations` (`id`), ADD CONSTRAINT `transfer_orders_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `transfer_orders_to_location_id_foreign` FOREIGN KEY (`to_location_id`) REFERENCES `locations` (`id`); -- -- Constraints for table `transfer_order_items` -- ALTER TABLE `transfer_order_items` ADD CONSTRAINT `transfer_order_items_ingredient_id_foreign` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`), ADD CONSTRAINT `transfer_order_items_transfer_order_id_foreign` FOREIGN KEY (`transfer_order_id`) REFERENCES `transfer_orders` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `users_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`id`) ON DELETE CASCADE; -- -- Constraints for table `webhook_subscriptions` -- ALTER TABLE `webhook_subscriptions` ADD CONSTRAINT `webhook_subscriptions_tenant_id_foreign` FOREIGN KEY (`tenant_id`) REFERENCES `tenants` (`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 */;