-- -------------------------------------------------------------
-- TablePlus 7.1.0(710)
--
-- https://tableplus.com/
--
-- Database: restaurant
-- -------------------------------------------------------------




CREATE TABLE `branches` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `branches_slug_unique` (`slug`),
  KEY `branches_user_id_foreign` (`user_id`),
  CONSTRAINT `branches_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_branch_id_slug_unique` (`branch_id`,`slug`),
  KEY `categories_parent_id_foreign` (`parent_id`),
  CONSTRAINT `categories_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `categories_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `deal_slot_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `deal_slot_id` bigint unsigned NOT NULL,
  `item_id` bigint unsigned NOT NULL,
  `variant_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deal_slot_items_deal_slot_id_foreign` (`deal_slot_id`),
  KEY `deal_slot_items_item_id_foreign` (`item_id`),
  KEY `deal_slot_items_variant_id_foreign` (`variant_id`),
  CONSTRAINT `deal_slot_items_deal_slot_id_foreign` FOREIGN KEY (`deal_slot_id`) REFERENCES `deal_slots` (`id`) ON DELETE CASCADE,
  CONSTRAINT `deal_slot_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `deal_slot_items_variant_id_foreign` FOREIGN KEY (`variant_id`) REFERENCES `item_variants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `deal_slots` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `deal_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deal_slots_deal_id_foreign` (`deal_id`),
  CONSTRAINT `deal_slots_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `deals` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` decimal(10,2) NOT NULL,
  `available_days` json DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `deals_branch_id_foreign` (`branch_id`),
  CONSTRAINT `deals_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `item_variants` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `item_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `dine_in_price` decimal(10,2) NOT NULL,
  `delivery_price` decimal(10,2) NOT NULL,
  `takeaway_price` decimal(10,2) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item_variants_item_id_foreign` (`item_id`),
  CONSTRAINT `item_variants_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `category_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `price` decimal(10,2) NOT NULL,
  `dine_in_price` decimal(10,2) DEFAULT NULL,
  `delivery_price` decimal(10,2) DEFAULT NULL,
  `takeaway_price` decimal(10,2) DEFAULT NULL,
  `gst_percentage` decimal(5,2) NOT NULL DEFAULT '5.00',
  `tax_inclusive` tinyint(1) NOT NULL DEFAULT '0',
  `available_dine_in` tinyint(1) NOT NULL DEFAULT '1',
  `available_delivery` tinyint(1) NOT NULL DEFAULT '1',
  `available_takeaway` tinyint(1) NOT NULL DEFAULT '1',
  `image_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_veg` tinyint(1) NOT NULL DEFAULT '0',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `sort_order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `items_branch_id_foreign` (`branch_id`),
  KEY `items_category_id_foreign` (`category_id`),
  CONSTRAINT `items_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `job_batches` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` smallint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `kot_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `kot_id` bigint unsigned NOT NULL,
  `order_item_id` bigint unsigned NOT NULL,
  `item_id` bigint unsigned DEFAULT NULL,
  `quantity` int NOT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deal_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kot_items_kot_id_foreign` (`kot_id`),
  KEY `kot_items_order_item_id_foreign` (`order_item_id`),
  KEY `kot_items_deal_id_foreign` (`deal_id`),
  KEY `kot_items_item_id_foreign` (`item_id`),
  CONSTRAINT `kot_items_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE SET NULL,
  CONSTRAINT `kot_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE SET NULL,
  CONSTRAINT `kot_items_kot_id_foreign` FOREIGN KEY (`kot_id`) REFERENCES `kots` (`id`) ON DELETE CASCADE,
  CONSTRAINT `kot_items_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `kots` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `order_id` bigint unsigned NOT NULL,
  `waiter_id` bigint unsigned DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `kots_branch_id_foreign` (`branch_id`),
  KEY `kots_order_id_foreign` (`order_id`),
  KEY `kots_waiter_id_foreign` (`waiter_id`),
  CONSTRAINT `kots_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `kots_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `kots_waiter_id_foreign` FOREIGN KEY (`waiter_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `order_items` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint unsigned NOT NULL,
  `item_id` bigint unsigned DEFAULT NULL,
  `variant_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `quantity` int NOT NULL,
  `subtotal` decimal(10,2) NOT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deal_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_item_id_foreign` (`item_id`),
  KEY `order_items_variant_id_foreign` (`variant_id`),
  KEY `order_items_deal_id_foreign` (`deal_id`),
  CONSTRAINT `order_items_deal_id_foreign` FOREIGN KEY (`deal_id`) REFERENCES `deals` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_item_id_foreign` FOREIGN KEY (`item_id`) REFERENCES `items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_variant_id_foreign` FOREIGN KEY (`variant_id`) REFERENCES `item_variants` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `table_id` bigint unsigned DEFAULT NULL,
  `waiter_id` bigint unsigned DEFAULT NULL,
  `biller_id` bigint unsigned DEFAULT NULL,
  `order_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dine_in',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `subtotal` decimal(10,2) NOT NULL DEFAULT '0.00',
  `gst_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `discount_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `discount_value` decimal(10,2) DEFAULT NULL,
  `discount_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `grand_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `split_cash` decimal(10,2) DEFAULT NULL,
  `split_card` decimal(10,2) DEFAULT NULL,
  `split_upi` decimal(10,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_branch_id_foreign` (`branch_id`),
  KEY `orders_table_id_foreign` (`table_id`),
  KEY `orders_waiter_id_foreign` (`waiter_id`),
  KEY `orders_biller_id_foreign` (`biller_id`),
  CONSTRAINT `orders_biller_id_foreign` FOREIGN KEY (`biller_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `orders_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `restaurant_tables` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_waiter_id_foreign` FOREIGN KEY (`waiter_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `restaurant_tables` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `area_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `capacity` int NOT NULL DEFAULT '4',
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'available',
  `pos_x` int NOT NULL DEFAULT '0',
  `pos_y` int NOT NULL DEFAULT '0',
  `width` int NOT NULL DEFAULT '120',
  `height` int NOT NULL DEFAULT '120',
  `shape` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'square',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurant_tables_branch_id_foreign` (`branch_id`),
  KEY `restaurant_tables_area_id_foreign` (`area_id`),
  CONSTRAINT `restaurant_tables_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `table_areas` (`id`) ON DELETE SET NULL,
  CONSTRAINT `restaurant_tables_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `sessions` (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `table_areas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_areas_branch_id_foreign` (`branch_id`),
  CONSTRAINT `table_areas_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `branches` (`id`, `user_id`, `name`, `slug`, `address`, `phone`, `active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 2, 'Gurbax Nagar, Amritsar', 'gurbax-nagar-amritsar', '102 Gurbax Nagar, Chabhal Road, Amritsar', '1234567890', 1, '2026-04-27 06:14:09', '2026-04-27 06:14:09', NULL),
(2, 2, 'Lawrence Road, Amritsar', 'lawrence-road-amritsar', '25 Nehru Shopping Complex Lawrence Road, Amritsar', '9876543210', 1, '2026-04-27 06:29:33', '2026-04-27 06:29:33', NULL);

INSERT INTO `categories` (`id`, `branch_id`, `parent_id`, `name`, `slug`, `description`, `sort_order`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, NULL, 'Appetizers', 'appetizers', NULL, 1, 1, '2026-04-29 20:53:46', '2026-04-29 20:53:46', NULL),
(2, 1, NULL, 'Chowmein', 'chowmein', NULL, 0, 1, '2026-04-29 20:55:45', '2026-04-29 20:55:45', NULL),
(3, 1, NULL, 'Snacks', 'snacls', NULL, 0, 1, '2026-04-29 20:56:53', '2026-04-29 20:56:59', NULL),
(4, 1, NULL, 'Momos', 'momos', NULL, 0, 1, '2026-04-29 20:57:07', '2026-04-29 20:57:07', NULL),
(5, 1, NULL, 'Main Course', 'main-course', NULL, 0, 1, '2026-04-29 20:57:12', '2026-04-29 20:57:12', NULL),
(6, 1, NULL, 'Soups', 'soups', NULL, 0, 1, '2026-04-29 20:57:20', '2026-04-29 20:57:20', NULL),
(7, 1, NULL, 'Shakes', 'shakes', NULL, 0, 1, '2026-04-29 20:57:24', '2026-04-29 20:57:24', NULL),
(8, 1, NULL, 'Mocktails', 'mocktails', NULL, 0, 1, '2026-04-29 20:57:32', '2026-04-29 20:57:32', NULL),
(9, 1, NULL, 'Chaa Sha', 'chaa-sha', NULL, 0, 1, '2026-04-29 20:57:46', '2026-04-29 20:57:46', NULL),
(10, 1, NULL, 'Sandwich', 'sandwich', NULL, 0, 1, '2026-04-29 20:57:50', '2026-04-29 20:57:50', NULL),
(11, 1, NULL, 'Fries', 'fries', NULL, 0, 1, '2026-04-29 20:57:54', '2026-04-29 20:57:54', NULL),
(12, 1, NULL, 'Burger', 'burger', NULL, 0, 1, '2026-04-29 20:57:59', '2026-04-29 20:57:59', NULL),
(13, 1, NULL, 'Breads/Sides', 'breadssides', NULL, 0, 1, '2026-04-29 20:58:06', '2026-04-29 20:58:06', NULL),
(14, 1, NULL, 'Wraps', 'wraps', NULL, 0, 1, '2026-04-29 20:58:11', '2026-04-29 20:58:11', NULL),
(15, 1, NULL, 'Pizza', 'pizza', NULL, 0, 1, '2026-04-29 20:58:14', '2026-04-29 20:58:14', NULL),
(16, 1, NULL, 'Pasta', 'pasta', NULL, 0, 1, '2026-04-29 20:58:19', '2026-04-29 20:58:19', NULL);

INSERT INTO `deal_slot_items` (`id`, `deal_slot_id`, `item_id`, `variant_id`, `created_at`, `updated_at`) VALUES
(16, 7, 44, 19, '2026-05-28 12:32:18', '2026-05-28 12:32:18'),
(17, 8, 26, NULL, '2026-05-28 12:32:18', '2026-05-28 12:32:18'),
(18, 8, 27, NULL, '2026-05-28 12:32:18', '2026-05-28 12:32:18'),
(19, 8, 28, NULL, '2026-05-28 12:32:18', '2026-05-28 12:32:18'),
(20, 8, 29, NULL, '2026-05-28 12:32:18', '2026-05-28 12:32:18');

INSERT INTO `deal_slots` (`id`, `deal_id`, `name`, `quantity`, `created_at`, `updated_at`) VALUES
(7, 1, 'Pizza', 1, '2026-05-28 12:32:18', '2026-05-28 12:32:18'),
(8, 1, 'Shakes', 1, '2026-05-28 12:32:18', '2026-05-28 12:32:18');

INSERT INTO `deals` (`id`, `branch_id`, `name`, `description`, `price`, `available_days`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 'Friday Deals', NULL, 499.00, '[\"Monday\", \"Thursday\", \"Friday\", \"Saturday\", \"Sunday\"]', 1, '2026-05-08 12:52:31', '2026-05-28 12:32:18');

INSERT INTO `item_variants` (`id`, `item_id`, `name`, `dine_in_price`, `delivery_price`, `takeaway_price`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 7, 'Half Plate', 80.00, 80.00, 80.00, 1, '2026-04-29 21:12:58', '2026-04-29 21:12:58'),
(2, 7, 'Full Plate', 140.00, 140.00, 140.00, 1, '2026-04-29 21:12:58', '2026-04-29 21:12:58'),
(3, 8, 'Half Plate', 100.00, 100.00, 100.00, 1, '2026-04-29 21:13:36', '2026-04-29 21:13:36'),
(4, 8, 'Full Plate', 170.00, 170.00, 170.00, 1, '2026-04-29 21:13:36', '2026-04-29 21:13:36'),
(5, 9, 'Half Plate', 100.00, 100.00, 100.00, 1, '2026-04-29 21:13:48', '2026-04-29 21:13:48'),
(6, 9, 'Full Plate', 170.00, 170.00, 170.00, 1, '2026-04-29 21:13:48', '2026-04-29 21:13:48'),
(7, 10, 'Half Plate', 110.00, 110.00, 110.00, 1, '2026-04-29 21:14:10', '2026-04-29 21:14:10'),
(8, 10, 'Full Plate', 200.00, 200.00, 200.00, 1, '2026-04-29 21:14:10', '2026-04-29 21:14:10'),
(9, 11, 'Half Plate', 130.00, 130.00, 130.00, 1, '2026-04-29 21:14:25', '2026-04-29 21:14:25'),
(10, 11, 'Full Plate', 220.00, 220.00, 220.00, 1, '2026-04-29 21:14:25', '2026-04-29 21:14:25'),
(11, 22, 'dry', 160.00, 160.00, 160.00, 1, '2026-04-29 21:20:14', '2026-04-29 21:20:14'),
(12, 22, 'gravy', 160.00, 160.00, 160.00, 1, '2026-04-29 21:20:14', '2026-04-29 21:20:14'),
(13, 23, 'dry', 220.00, 220.00, 220.00, 1, '2026-04-29 21:21:17', '2026-04-29 21:21:17'),
(14, 23, 'gravy', 220.00, 220.00, 220.00, 1, '2026-04-29 21:21:17', '2026-04-29 21:21:17'),
(15, 33, 'medium', 40.00, 40.00, 40.00, 1, '2026-04-29 21:23:43', '2026-04-29 21:23:43'),
(16, 33, 'large', 60.00, 60.00, 60.00, 1, '2026-04-29 21:23:43', '2026-04-29 21:23:43'),
(17, 35, 'small', 40.00, 40.00, 40.00, 1, '2026-04-29 21:24:26', '2026-04-29 21:24:26'),
(18, 35, 'large', 60.00, 60.00, 60.00, 1, '2026-04-29 21:24:26', '2026-04-29 21:24:26'),
(19, 44, 'small', 140.00, 140.00, 140.00, 1, '2026-04-29 21:28:56', '2026-04-29 21:28:56'),
(20, 44, 'medium', 290.00, 290.00, 290.00, 1, '2026-04-29 21:28:56', '2026-04-29 21:28:56'),
(21, 44, 'large', 410.00, 410.00, 410.00, 1, '2026-04-29 21:28:56', '2026-04-29 21:28:56');

INSERT INTO `items` (`id`, `branch_id`, `category_id`, `name`, `slug`, `description`, `price`, `dine_in_price`, `delivery_price`, `takeaway_price`, `gst_percentage`, `tax_inclusive`, `available_dine_in`, `available_delivery`, `available_takeaway`, `image_path`, `is_veg`, `status`, `sort_order`, `is_active`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 1, 'Nuggets', 'nuggets', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:05:42', '2026-04-29 21:05:42', NULL),
(2, 1, 1, 'Loaded Nachos', 'loaded-nachos', NULL, 110.00, 110.00, 110.00, 110.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:05:54', '2026-04-29 21:05:54', NULL),
(3, 1, 1, 'Cigar Roll', 'cigar-roll', NULL, 140.00, 140.00, 140.00, 140.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:06:05', '2026-04-29 21:06:05', NULL),
(4, 1, 1, 'Mushroom Duplex', 'mushroom-duplex', NULL, 150.00, 150.00, 150.00, 150.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:06:38', '2026-04-29 21:06:38', NULL),
(5, 1, 1, 'Cheese Finger', 'cheese-finger', NULL, 160.00, 160.00, 160.00, 160.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:06:49', '2026-04-29 21:06:49', NULL),
(6, 1, 1, 'Cheese Corn Roll', 'cheese-corn-roll', NULL, 180.00, 180.00, 180.00, 180.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:07:03', '2026-04-29 21:07:03', NULL),
(7, 1, 2, 'Veg Chowmein', 'veg-chowmein', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:12:58', '2026-04-29 21:12:58', NULL),
(8, 1, 2, 'Garlic Chowmein', 'garlic-chowmein', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:13:36', '2026-04-29 21:13:36', NULL),
(9, 1, 2, 'Hakka Chowmein', 'hakka-chowmein', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:13:48', '2026-04-29 21:13:48', NULL),
(10, 1, 2, 'Cheese Chowmein', 'cheese-chowmein', NULL, 110.00, 110.00, 110.00, 110.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:14:10', '2026-04-29 21:14:10', NULL),
(11, 1, 2, 'Singapuri Chowmein', 'singapuri-chowmein', NULL, 130.00, 130.00, 130.00, 130.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:14:25', '2026-04-29 21:14:25', NULL),
(12, 1, 3, 'Spring Roll', 'spring-roll', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:17:08', '2026-04-29 21:17:08', NULL),
(13, 1, 3, 'veg Bullets', 'veg-bullets', NULL, 110.00, 110.00, 110.00, 110.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:17:26', '2026-04-29 21:17:26', NULL),
(14, 1, 3, 'garlic mushroom', 'garlic-mushroom', NULL, 120.00, 120.00, 120.00, 120.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:17:43', '2026-04-29 21:17:43', NULL),
(15, 1, 3, 'chilly mushroom', 'chilly-mushroom', NULL, 120.00, 120.00, 120.00, 120.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:17:53', '2026-04-29 21:17:53', NULL),
(16, 1, 3, 'Veg Chouspey', 'veg-chouspey', NULL, 140.00, 140.00, 140.00, 140.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:18:06', '2026-04-29 21:18:06', NULL),
(17, 1, 3, 'Cheese Choupsey', 'cheese-choupsey', NULL, 160.00, 160.00, 160.00, 160.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:18:17', '2026-04-29 21:18:17', NULL),
(18, 1, 3, 'veg Crispy', 'veg-crispy', NULL, 170.00, 170.00, 170.00, 170.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:18:24', '2026-04-29 21:18:24', NULL),
(19, 1, 4, 'Veg Fried Momos', 'veg-fried-momos', NULL, 90.00, 90.00, 90.00, 90.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:18:54', '2026-04-29 21:18:54', NULL),
(20, 1, 4, 'Pan Momos Veg', 'pan-momos-veg', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:19:06', '2026-04-29 21:19:06', NULL),
(21, 1, 4, 'Kurkure Momos', 'kurkure-momos', NULL, 150.00, 150.00, 150.00, 150.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:19:18', '2026-04-29 21:19:18', NULL),
(22, 1, 5, 'Manchurian', 'manchurian', NULL, 160.00, 160.00, 160.00, 160.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:20:14', '2026-04-29 21:20:14', NULL),
(23, 1, 5, 'cheese Chilly', 'cheese-chilly', NULL, 220.00, 220.00, 220.00, 220.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:21:17', '2026-04-29 21:21:17', NULL),
(24, 1, 6, 'Hot and Sour', 'hot-and-sour', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:21:35', '2026-04-29 21:21:35', NULL),
(25, 1, 6, 'Sweet Corn', 'sweet-corn', NULL, 90.00, 90.00, 90.00, 90.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:21:48', '2026-04-29 21:21:48', NULL),
(26, 1, 7, 'chocolate', 'chocolate', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:00', '2026-04-29 21:22:00', NULL),
(27, 1, 7, 'strawberry', 'strawberry', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:09', '2026-04-29 21:22:09', NULL),
(28, 1, 7, 'kitkat', 'kitkat', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:16', '2026-04-29 21:22:16', NULL),
(29, 1, 7, 'choco chip', 'choco-chip', NULL, 140.00, 140.00, 140.00, 140.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:25', '2026-04-29 21:22:25', NULL),
(30, 1, 8, 'virgin mojito', 'virgin-mojito', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:37', '2026-04-29 21:22:37', NULL),
(31, 1, 8, 'blue Logoon', 'blue-logoon', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:47', '2026-04-29 21:22:47', NULL),
(32, 1, 8, 'Fresh Lime Soda', 'fresh-lime-soda', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:22:57', '2026-04-29 21:22:57', NULL),
(33, 1, 9, 'tea', 'tea', NULL, 40.00, 40.00, 40.00, 40.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:23:43', '2026-04-29 21:23:43', NULL),
(34, 1, 9, 'Coffee', 'coffee', NULL, 60.00, 60.00, 60.00, 60.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:23:53', '2026-04-29 21:23:53', NULL),
(35, 1, 9, 'Bun Maska', 'bun-maska', NULL, 40.00, 40.00, 40.00, 40.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:24:26', '2026-04-29 21:24:26', NULL),
(36, 1, 10, 'grilled Sandwich', 'grilled-sandwich', NULL, 100.00, 100.00, 100.00, 100.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:24:44', '2026-04-29 21:24:44', NULL),
(37, 1, 10, 'Paneer Tandoori Sandwich', 'paneer-tandoori-sandwich', NULL, 140.00, 140.00, 140.00, 140.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:24:59', '2026-04-29 21:24:59', NULL),
(38, 1, 11, 'Plain Fries', 'plain-fries', NULL, 70.00, 70.00, 70.00, 70.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:25:16', '2026-04-29 21:25:16', NULL),
(39, 1, 11, 'masala Fries', 'masala-fries', NULL, 120.00, 120.00, 120.00, 120.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:25:26', '2026-04-29 21:25:26', NULL),
(40, 1, 12, 'Allu tikki burger', 'allu-tikki-burger', NULL, 60.00, 60.00, 60.00, 60.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:25:42', '2026-04-29 21:25:42', NULL),
(41, 1, 12, 'makhani Paneer Burger', 'makhani-paneer-burger', NULL, 120.00, 120.00, 120.00, 120.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:25:54', '2026-04-29 21:25:54', NULL),
(42, 1, 13, 'garlic plain Bread( 4 pcs)', 'garlic-plain-bread-4-pcs', NULL, 60.00, 60.00, 60.00, 60.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:26:33', '2026-04-29 21:26:33', NULL),
(43, 1, 13, 'Cheese Garlic Bread', 'cheese-garlic-bread', NULL, 80.00, 80.00, 80.00, 80.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:26:50', '2026-04-29 21:26:50', NULL),
(44, 1, 15, 'Paneer Makhani', 'paneer-makhani', NULL, 140.00, 140.00, 140.00, 140.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:28:56', '2026-04-29 21:28:56', NULL),
(45, 1, 16, 'Red Sauce Pasta', 'red-sauce-pasta', NULL, 150.00, 150.00, 150.00, 150.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:29:18', '2026-04-29 21:29:18', NULL),
(46, 1, 16, 'white Sauce pasta', 'white-sauce-pasta', NULL, 160.00, 160.00, 160.00, 160.00, 5.00, 1, 1, 1, 1, NULL, 1, 'available', 0, 1, '2026-04-29 21:29:31', '2026-04-29 21:29:31', NULL),
(47, 1, 14, 'Allu Tikki Wrap', 'allu-tikki-wrap', NULL, 130.00, 130.00, 130.00, 130.00, 5.00, 1, 1, 1, 1, 'items/ziyk1pbqRzXY5LgbfigSsCX9JIcp6wmt1Dj8W06f.jpg', 1, 'available', 0, 1, '2026-04-29 21:29:48', '2026-04-29 21:46:17', NULL),
(48, 1, 14, 'Paneer cheese Wrap', 'paneer-cheese-wrap', NULL, 170.00, 170.00, 170.00, 170.00, 5.00, 1, 1, 1, 1, 'items/BkEonqRbLZma1jlcWKenPeaQSjHOiv4BalgxeXo4.jpg', 1, 'available', 0, 1, '2026-04-29 21:30:01', '2026-05-29 10:42:18', NULL);

INSERT INTO `kot_items` (`id`, `kot_id`, `order_item_id`, `item_id`, `quantity`, `notes`, `status`, `created_at`, `updated_at`, `deal_id`) VALUES
(1, 1, 1, 44, 1, 'Paneer Makhani (small)', 'served', '2026-05-11 14:36:59', '2026-05-11 14:37:33', 1),
(2, 1, 1, 26, 1, 'chocolate', 'served', '2026-05-11 14:36:59', '2026-05-11 14:37:33', 1),
(3, 2, 2, 44, 1, 'Paneer Makhani (small) ', 'served', '2026-05-11 14:41:09', '2026-05-11 14:41:46', 1),
(4, 2, 2, 28, 1, 'kitkat ', 'served', '2026-05-11 14:41:09', '2026-05-11 14:41:46', 1),
(5, 3, 3, 5, 1, NULL, 'served', '2026-05-11 15:40:55', '2026-05-21 12:32:25', NULL),
(6, 4, 4, 44, 1, 'Paneer Makhani (small)', 'served', '2026-05-11 15:47:31', '2026-05-21 12:32:18', 1),
(7, 4, 4, 26, 1, 'chocolate', 'served', '2026-05-11 15:47:31', '2026-05-21 12:32:18', 1),
(8, 5, 5, 1, 1, NULL, 'served', '2026-05-20 16:57:20', '2026-05-21 12:32:14', NULL),
(11, 7, 14, 4, 1, NULL, 'served', '2026-05-20 17:03:02', '2026-05-21 12:32:09', NULL),
(12, 7, 15, 5, 1, NULL, 'served', '2026-05-20 17:03:02', '2026-05-21 12:32:09', NULL),
(13, 8, 16, 4, 1, NULL, 'served', '2026-05-20 17:03:27', '2026-05-21 12:32:03', NULL),
(14, 9, 17, 5, 1, NULL, 'served', '2026-05-20 17:46:52', '2026-05-21 12:31:59', NULL),
(15, 9, 18, 1, 1, NULL, 'served', '2026-05-20 17:46:52', '2026-05-21 12:31:59', NULL),
(16, 10, 26, 10, 1, NULL, 'served', '2026-05-21 12:20:18', '2026-05-21 12:26:18', NULL),
(17, 10, 27, 5, 1, NULL, 'served', '2026-05-21 12:20:18', '2026-05-21 12:26:18', NULL),
(18, 11, 28, 5, 1, NULL, 'served', '2026-05-21 12:28:26', '2026-05-21 12:31:53', NULL),
(19, 12, 29, 1, 1, NULL, 'served', '2026-05-21 12:31:33', '2026-05-21 12:31:48', NULL),
(20, 13, 30, 5, 2, NULL, 'served', '2026-05-21 13:09:01', '2026-05-21 13:10:59', NULL),
(21, 13, 31, 4, 1, NULL, 'served', '2026-05-21 13:09:01', '2026-05-21 13:10:59', NULL),
(22, 14, 32, 5, 1, NULL, 'served', '2026-05-21 13:13:37', '2026-05-21 13:15:49', NULL),
(23, 14, 33, 4, 1, NULL, 'served', '2026-05-21 13:13:37', '2026-05-21 13:15:49', NULL),
(24, 15, 32, 5, 1, NULL, 'served', '2026-05-21 13:15:24', '2026-05-21 13:15:43', NULL),
(25, 15, 34, 10, 1, NULL, 'served', '2026-05-21 13:15:24', '2026-05-21 13:15:43', NULL),
(26, 16, 35, 5, 3, NULL, 'served', '2026-05-21 13:15:58', '2026-05-21 13:17:34', NULL),
(27, 17, 36, 2, 1, NULL, 'served', '2026-05-21 13:16:55', '2026-05-21 13:17:36', NULL),
(28, 18, 37, 4, 1, NULL, 'served', '2026-05-21 13:17:50', '2026-05-21 13:18:55', NULL),
(29, 18, 38, 5, 1, NULL, 'served', '2026-05-21 13:17:50', '2026-05-21 13:18:55', NULL),
(30, 18, 39, 9, 1, NULL, 'served', '2026-05-21 13:17:50', '2026-05-21 13:18:55', NULL),
(31, 19, 40, 15, 1, NULL, 'served', '2026-05-21 13:18:01', '2026-05-21 13:18:57', NULL),
(32, 20, 40, 15, 2, NULL, 'served', '2026-05-21 13:18:18', '2026-05-21 13:18:59', NULL),
(33, 21, 41, 5, 1, NULL, 'served', '2026-05-21 13:19:41', '2026-05-21 13:21:51', NULL),
(36, 22, 41, 5, 2, NULL, 'served', '2026-05-21 13:22:06', '2026-05-21 13:22:26', NULL),
(37, 23, 44, 12, 2, NULL, 'served', '2026-05-21 13:27:16', '2026-05-21 13:28:29', NULL),
(38, 24, 45, 12, 2, NULL, 'served', '2026-05-21 13:28:44', '2026-05-21 13:34:31', NULL),
(39, 25, 45, 12, 1, NULL, 'served', '2026-05-21 13:33:25', '2026-05-21 13:34:28', NULL),
(40, 26, 44, 12, 2, NULL, 'served', '2026-05-21 13:34:11', '2026-05-21 13:34:27', NULL),
(41, 27, 46, 1, 3, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(42, 27, 47, 2, 2, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(43, 27, 48, 3, 1, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(44, 27, 49, 4, 1, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(45, 27, 50, 5, 1, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(46, 27, 51, 6, 1, NULL, 'served', '2026-05-21 15:48:34', '2026-05-21 16:54:20', NULL),
(49, 30, 54, 1, 1, NULL, 'served', '2026-05-21 16:56:09', '2026-05-21 17:10:10', NULL),
(52, 33, 57, 13, 2, NULL, 'served', '2026-05-21 17:11:59', '2026-05-21 17:12:20', NULL),
(54, 35, 59, 3, 1, NULL, 'served', '2026-05-21 17:14:28', '2026-05-21 17:15:06', NULL),
(55, 35, 60, 2, 1, NULL, 'served', '2026-05-21 17:14:28', '2026-05-21 17:15:06', NULL),
(56, 36, 61, 1, 1, NULL, 'served', '2026-05-21 17:14:43', '2026-05-21 17:15:02', NULL),
(57, 37, 62, 5, 1, NULL, 'served', '2026-05-21 17:17:09', '2026-05-21 17:22:11', NULL),
(58, 38, 63, 1, 1, NULL, 'served', '2026-05-21 17:17:44', '2026-05-21 17:22:13', NULL),
(60, 39, 65, 1, 1, NULL, 'served', '2026-05-21 17:21:57', '2026-05-21 17:22:15', NULL),
(61, 40, 66, 1, 1, NULL, 'served', '2026-05-21 17:23:44', '2026-05-21 17:26:30', NULL),
(62, 41, 67, 1, 1, NULL, 'served', '2026-05-21 17:26:19', '2026-05-21 17:26:28', NULL),
(63, 42, 68, 5, 1, NULL, 'served', '2026-05-21 17:31:58', '2026-05-21 17:32:08', NULL),
(64, 43, 69, 5, 1, NULL, 'served', '2026-05-21 17:32:43', '2026-05-21 17:32:52', NULL),
(65, 44, 70, 3, 1, NULL, 'served', '2026-05-21 17:40:14', '2026-05-21 17:40:25', NULL),
(66, 44, 71, 2, 1, NULL, 'served', '2026-05-21 17:40:14', '2026-05-21 17:40:25', NULL),
(67, 45, 72, 1, 1, NULL, 'served', '2026-05-21 17:41:10', '2026-05-21 17:41:24', NULL),
(70, 48, 80, 3, 1, NULL, 'served', '2026-05-21 17:52:03', '2026-05-21 17:52:13', NULL),
(74, 52, 83, 4, 1, NULL, 'served', '2026-05-21 17:54:41', '2026-05-21 17:55:06', NULL),
(75, 53, 84, 3, 1, NULL, 'served', '2026-05-21 17:54:45', '2026-05-21 17:55:03', NULL),
(76, 54, 85, 3, 1, NULL, 'served', '2026-05-21 17:54:49', '2026-05-21 17:55:01', NULL),
(78, 56, 87, 1, 1, NULL, 'served', '2026-05-21 17:58:16', '2026-05-22 10:19:03', NULL),
(79, 57, 88, 1, 1, NULL, 'served', '2026-05-22 10:19:18', '2026-05-22 10:25:47', NULL),
(80, 58, 88, 1, 1, NULL, 'served', '2026-05-22 10:19:45', '2026-05-22 10:26:26', NULL),
(81, 59, 88, 1, 1, NULL, 'served', '2026-05-22 10:20:02', '2026-05-22 10:26:23', NULL),
(82, 60, 89, 7, 1, NULL, 'served', '2026-05-22 10:25:34', '2026-05-22 10:26:20', NULL),
(83, 61, 90, 8, 1, NULL, 'served', '2026-05-22 10:26:44', '2026-05-22 10:41:44', NULL),
(86, 64, 93, 8, 1, NULL, 'served', '2026-05-22 10:32:08', '2026-05-22 10:41:42', NULL),
(87, 65, 94, 8, 1, NULL, 'served', '2026-05-22 10:41:53', '2026-05-22 10:42:59', NULL),
(88, 66, 94, 8, 1, NULL, 'served', '2026-05-22 10:42:05', '2026-05-22 10:42:57', NULL),
(89, 67, 95, 7, 1, NULL, 'served', '2026-05-22 10:42:22', '2026-05-22 10:42:55', NULL),
(90, 68, 96, 6, 1, NULL, 'served', '2026-05-22 10:42:30', '2026-05-22 10:42:53', NULL),
(91, 69, 97, 1, 1, NULL, 'served', '2026-05-22 10:42:39', '2026-05-22 10:42:51', NULL),
(92, 70, 94, 8, 1, NULL, 'served', '2026-05-22 10:44:02', '2026-05-22 10:51:16', NULL),
(93, 71, 98, 7, 1, NULL, 'served', '2026-05-22 10:51:04', '2026-05-22 10:51:14', NULL),
(94, 72, 99, 3, 1, NULL, 'served', '2026-05-22 10:55:29', '2026-05-22 11:01:25', NULL),
(95, 73, 100, 4, 1, NULL, 'served', '2026-05-22 11:02:00', '2026-05-22 11:09:13', NULL),
(96, 74, 101, 10, 1, NULL, 'served', '2026-05-22 11:02:13', '2026-05-22 11:09:09', NULL),
(97, 75, 102, 9, 1, NULL, 'served', '2026-05-22 11:02:25', '2026-05-22 11:09:00', NULL),
(98, 76, 103, 7, 1, NULL, 'served', '2026-05-22 11:02:43', '2026-05-22 11:09:05', NULL),
(99, 77, 104, 9, 1, NULL, 'served', '2026-05-22 11:03:29', '2026-05-22 11:08:56', NULL),
(100, 78, 105, 14, 1, NULL, 'served', '2026-05-22 11:03:42', '2026-05-22 11:08:53', NULL),
(101, 79, 106, 15, 1, NULL, 'served', '2026-05-22 11:04:22', '2026-05-22 11:08:50', NULL),
(102, 80, 107, 3, 1, NULL, 'served', '2026-05-22 11:20:39', '2026-05-22 11:20:48', NULL),
(103, 81, 108, 10, 1, NULL, 'served', '2026-05-22 13:29:28', '2026-05-22 13:31:47', NULL),
(104, 82, 111, 2, 1, NULL, 'served', '2026-05-22 13:32:09', '2026-05-22 13:32:25', NULL),
(105, 82, 112, 3, 1, NULL, 'served', '2026-05-22 13:32:09', '2026-05-22 13:32:25', NULL),
(106, 83, 110, 5, 1, NULL, 'served', '2026-05-22 13:32:47', '2026-05-22 13:33:00', NULL),
(107, 84, 114, 17, 1, NULL, 'served', '2026-05-22 13:43:19', '2026-05-22 13:43:37', NULL),
(108, 85, 113, 5, 2, NULL, 'served', '2026-05-22 14:09:26', '2026-05-22 14:09:37', NULL),
(109, 86, 116, 10, 1, NULL, 'served', '2026-05-22 14:11:29', '2026-05-22 14:12:16', NULL),
(110, 87, 117, 4, 1, NULL, 'served', '2026-05-22 14:37:17', '2026-05-25 12:35:31', NULL),
(111, 88, 118, 2, 1, ' ', 'served', '2026-05-25 12:21:32', '2026-05-25 12:35:28', NULL),
(112, 88, 119, 2, 1, ' ', 'served', '2026-05-25 12:21:32', '2026-05-25 12:35:28', NULL),
(113, 89, 120, 8, 1, NULL, 'served', '2026-05-25 16:09:29', '2026-06-01 10:38:18', NULL),
(114, 90, 121, 12, 1, '', 'served', '2026-05-27 13:08:04', '2026-06-01 10:38:22', NULL),
(115, 90, 122, 12, 1, '', 'served', '2026-05-27 13:08:04', '2026-06-01 10:38:22', NULL),
(116, 91, 123, 1, 1, ' ', 'served', '2026-05-27 13:54:44', '2026-06-01 10:38:24', NULL),
(117, 92, 124, 2, 1, '', 'served', '2026-05-27 14:27:42', '2026-06-01 10:38:26', NULL),
(118, 93, 125, 5, 1, 'test', 'served', '2026-05-27 15:30:35', '2026-06-01 10:38:29', NULL),
(119, 94, 126, 44, 1, 'Paneer Makhani (small)', 'served', '2026-05-28 12:35:24', '2026-06-01 10:38:31', 1),
(120, 94, 126, 27, 1, 'strawberry', 'served', '2026-05-28 12:35:24', '2026-06-01 10:38:31', 1),
(121, 95, 127, 2, 1, '', 'served', '2026-05-29 17:48:48', '2026-06-01 10:38:33', NULL),
(122, 96, 128, 44, 1, 'Paneer Makhani (small)', 'served', '2026-06-01 10:38:56', '2026-06-01 11:45:43', 1),
(123, 96, 128, 28, 1, 'kitkat', 'served', '2026-06-01 10:38:56', '2026-06-01 11:45:43', 1),
(124, 97, 129, 1, 1, '', 'served', '2026-06-01 10:57:02', '2026-06-01 11:45:41', NULL),
(125, 98, 130, 3, 1, '', 'served', '2026-06-01 10:57:45', '2026-06-01 11:45:39', NULL),
(126, 99, 131, 44, 1, 'Paneer Makhani (small)', 'served', '2026-06-01 11:31:19', '2026-06-01 11:45:36', 1),
(127, 99, 131, 26, 1, 'chocolate', 'served', '2026-06-01 11:31:19', '2026-06-01 11:45:36', 1),
(128, 100, 132, 1, 1, '', 'served', '2026-06-01 11:32:08', '2026-06-01 11:45:33', NULL),
(129, 101, 133, 1, 1, '', 'served', '2026-06-01 12:18:37', '2026-06-01 12:18:54', NULL),
(130, 102, 134, 2, 1, '', 'served', '2026-06-01 12:19:08', '2026-06-01 12:36:19', NULL),
(131, 103, 135, 5, 1, '', 'served', '2026-06-01 12:36:39', '2026-06-01 12:40:11', NULL),
(132, 104, 136, 1, 1, NULL, 'served', '2026-06-01 15:40:36', '2026-06-01 15:40:56', NULL),
(133, 104, 137, 2, 1, NULL, 'served', '2026-06-01 15:40:36', '2026-06-01 15:40:56', NULL),
(134, 105, 138, 2, 1, NULL, 'served', '2026-06-01 15:41:53', '2026-06-01 15:44:07', NULL),
(135, 105, 139, 3, 1, NULL, 'served', '2026-06-01 15:41:53', '2026-06-01 15:44:07', NULL),
(136, 106, 140, 10, 1, NULL, 'served', '2026-06-01 15:42:13', '2026-06-02 11:29:02', NULL),
(137, 107, 141, 13, 1, NULL, 'served', '2026-06-01 15:43:40', '2026-06-01 16:02:51', NULL);

INSERT INTO `kots` (`id`, `branch_id`, `order_id`, `waiter_id`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 3, 'completed', '2026-05-11 14:36:59', '2026-05-11 14:37:33'),
(2, 1, 2, 3, 'completed', '2026-05-11 14:41:09', '2026-05-11 14:41:46'),
(3, 1, 3, 3, 'completed', '2026-05-11 15:40:55', '2026-05-21 12:32:25'),
(4, 1, 4, NULL, 'completed', '2026-05-11 15:47:31', '2026-05-21 12:32:18'),
(5, 1, 16, 3, 'completed', '2026-05-20 16:57:20', '2026-05-21 12:32:14'),
(6, 1, 20, 3, 'completed', '2026-05-20 17:01:43', '2026-05-21 12:32:21'),
(7, 1, 21, NULL, 'completed', '2026-05-20 17:03:02', '2026-05-21 12:32:09'),
(8, 1, 20, 3, 'completed', '2026-05-20 17:03:27', '2026-05-21 12:32:03'),
(9, 1, 22, 3, 'completed', '2026-05-20 17:46:52', '2026-05-21 12:31:59'),
(10, 1, 28, NULL, 'completed', '2026-05-21 12:20:18', '2026-05-21 12:26:18'),
(11, 1, 29, 3, 'completed', '2026-05-21 12:28:26', '2026-05-21 12:31:53'),
(12, 1, 30, 3, 'completed', '2026-05-21 12:31:33', '2026-05-21 12:31:48'),
(13, 1, 31, NULL, 'completed', '2026-05-21 13:09:01', '2026-05-21 13:10:59'),
(14, 1, 32, 3, 'completed', '2026-05-21 13:13:37', '2026-05-21 13:15:49'),
(15, 1, 32, 3, 'completed', '2026-05-21 13:15:24', '2026-05-21 13:15:43'),
(16, 1, 33, NULL, 'completed', '2026-05-21 13:15:58', '2026-05-21 13:17:34'),
(17, 1, 33, NULL, 'completed', '2026-05-21 13:16:55', '2026-05-21 13:17:36'),
(18, 1, 34, 3, 'completed', '2026-05-21 13:17:50', '2026-05-21 13:18:55'),
(19, 1, 34, 3, 'completed', '2026-05-21 13:18:01', '2026-05-21 13:18:57'),
(20, 1, 34, 3, 'completed', '2026-05-21 13:18:18', '2026-05-21 13:18:59'),
(21, 1, 35, 3, 'completed', '2026-05-21 13:19:41', '2026-05-21 13:21:51'),
(22, 1, 35, 3, 'completed', '2026-05-21 13:22:06', '2026-05-21 13:22:26'),
(23, 1, 35, 3, 'completed', '2026-05-21 13:27:16', '2026-05-21 13:28:29'),
(24, 1, 36, 3, 'completed', '2026-05-21 13:28:44', '2026-05-21 13:34:31'),
(25, 1, 36, 3, 'completed', '2026-05-21 13:33:25', '2026-05-21 13:34:28'),
(26, 1, 35, 3, 'completed', '2026-05-21 13:34:11', '2026-05-21 13:34:27'),
(27, 1, 37, 3, 'completed', '2026-05-21 15:48:34', '2026-05-21 16:54:20'),
(28, 1, 38, 3, 'completed', '2026-05-21 16:53:53', '2026-05-21 16:54:23'),
(29, 1, 38, 3, 'completed', '2026-05-21 16:55:26', '2026-05-21 17:10:12'),
(30, 1, 38, 3, 'completed', '2026-05-21 16:56:09', '2026-05-21 17:10:10'),
(31, 1, 39, 3, 'completed', '2026-05-21 17:09:42', '2026-05-21 17:10:07'),
(32, 1, 39, 3, 'completed', '2026-05-21 17:10:24', '2026-05-21 17:12:15'),
(33, 1, 39, 3, 'completed', '2026-05-21 17:11:59', '2026-05-21 17:12:20'),
(34, 1, 40, 3, 'completed', '2026-05-21 17:14:12', '2026-05-21 17:15:07'),
(35, 1, 41, NULL, 'completed', '2026-05-21 17:14:28', '2026-05-21 17:15:06'),
(36, 1, 40, 3, 'completed', '2026-05-21 17:14:43', '2026-05-21 17:15:02'),
(37, 1, 42, 3, 'completed', '2026-05-21 17:17:09', '2026-05-21 17:22:11'),
(38, 1, 42, 3, 'completed', '2026-05-21 17:17:44', '2026-05-21 17:22:13'),
(39, 1, 43, 3, 'completed', '2026-05-21 17:21:57', '2026-05-21 17:22:15'),
(40, 1, 44, 3, 'completed', '2026-05-21 17:23:44', '2026-05-21 17:26:30'),
(41, 1, 45, 3, 'completed', '2026-05-21 17:26:19', '2026-05-21 17:26:28'),
(42, 1, 46, 3, 'completed', '2026-05-21 17:31:58', '2026-05-21 17:32:08'),
(43, 1, 47, 3, 'completed', '2026-05-21 17:32:43', '2026-05-21 17:32:52'),
(44, 1, 48, 3, 'completed', '2026-05-21 17:40:14', '2026-05-21 17:40:25'),
(45, 1, 49, 3, 'completed', '2026-05-21 17:41:10', '2026-05-21 17:41:24'),
(46, 1, 55, NULL, 'completed', '2026-05-21 17:51:00', '2026-05-21 17:52:18'),
(47, 1, 55, NULL, 'completed', '2026-05-21 17:51:47', '2026-05-21 17:52:15'),
(48, 1, 55, NULL, 'completed', '2026-05-21 17:52:03', '2026-05-21 17:52:13'),
(49, 1, 56, NULL, 'completed', '2026-05-21 17:52:34', '2026-05-21 17:55:12'),
(50, 1, 56, NULL, 'completed', '2026-05-21 17:53:09', '2026-05-21 17:55:10'),
(51, 1, 56, NULL, 'completed', '2026-05-21 17:53:18', '2026-05-21 17:55:08'),
(52, 1, 57, NULL, 'completed', '2026-05-21 17:54:41', '2026-05-21 17:55:06'),
(53, 1, 58, NULL, 'completed', '2026-05-21 17:54:45', '2026-05-21 17:55:03'),
(54, 1, 59, NULL, 'completed', '2026-05-21 17:54:49', '2026-05-21 17:55:01'),
(55, 1, 56, NULL, 'completed', '2026-05-21 17:56:58', '2026-05-22 10:19:05'),
(56, 1, 56, NULL, 'completed', '2026-05-21 17:58:16', '2026-05-22 10:19:03'),
(57, 1, 60, NULL, 'completed', '2026-05-22 10:19:18', '2026-05-22 10:25:47'),
(58, 1, 60, NULL, 'completed', '2026-05-22 10:19:45', '2026-05-22 10:26:26'),
(59, 1, 60, NULL, 'completed', '2026-05-22 10:20:02', '2026-05-22 10:26:23'),
(60, 1, 61, NULL, 'completed', '2026-05-22 10:25:34', '2026-05-22 10:26:20'),
(61, 1, 62, NULL, 'completed', '2026-05-22 10:26:44', '2026-05-22 10:41:44'),
(62, 1, 63, NULL, 'completed', '2026-05-22 10:27:23', '2026-05-22 10:41:40'),
(63, 1, 63, NULL, 'completed', '2026-05-22 10:27:32', '2026-05-22 10:41:38'),
(64, 1, 63, NULL, 'completed', '2026-05-22 10:32:08', '2026-05-22 10:41:42'),
(65, 1, 62, NULL, 'completed', '2026-05-22 10:41:53', '2026-05-22 10:42:59'),
(66, 1, 62, NULL, 'completed', '2026-05-22 10:42:05', '2026-05-22 10:42:57'),
(67, 1, 64, NULL, 'completed', '2026-05-22 10:42:22', '2026-05-22 10:42:55'),
(68, 1, 65, NULL, 'completed', '2026-05-22 10:42:30', '2026-05-22 10:42:53'),
(69, 1, 66, NULL, 'completed', '2026-05-22 10:42:39', '2026-05-22 10:42:51'),
(70, 1, 62, NULL, 'completed', '2026-05-22 10:44:02', '2026-05-22 10:51:16'),
(71, 1, 62, NULL, 'completed', '2026-05-22 10:51:04', '2026-05-22 10:51:14'),
(72, 1, 67, 3, 'completed', '2026-05-22 10:55:29', '2026-05-22 11:01:25'),
(73, 1, 68, 3, 'completed', '2026-05-22 11:02:00', '2026-05-22 11:09:13'),
(74, 1, 68, 3, 'completed', '2026-05-22 11:02:13', '2026-05-22 11:09:09'),
(75, 1, 69, NULL, 'completed', '2026-05-22 11:02:25', '2026-05-22 11:09:00'),
(76, 1, 69, NULL, 'completed', '2026-05-22 11:02:43', '2026-05-22 11:09:05'),
(77, 1, 69, NULL, 'completed', '2026-05-22 11:03:29', '2026-05-22 11:08:56'),
(78, 1, 70, NULL, 'completed', '2026-05-22 11:03:42', '2026-05-22 11:08:53'),
(79, 1, 69, NULL, 'completed', '2026-05-22 11:04:22', '2026-05-22 11:08:50'),
(80, 1, 71, 3, 'completed', '2026-05-22 11:20:39', '2026-05-22 11:20:48'),
(81, 1, 72, NULL, 'completed', '2026-05-22 13:29:28', '2026-05-22 13:31:47'),
(82, 1, 75, NULL, 'completed', '2026-05-22 13:32:09', '2026-05-22 13:32:25'),
(83, 1, 74, NULL, 'completed', '2026-05-22 13:32:47', '2026-05-22 13:33:00'),
(84, 1, 77, NULL, 'completed', '2026-05-22 13:43:19', '2026-05-22 13:43:37'),
(85, 1, 76, 3, 'completed', '2026-05-22 14:09:26', '2026-05-22 14:09:37'),
(86, 1, 76, 3, 'completed', '2026-05-22 14:11:29', '2026-05-22 14:12:16'),
(87, 1, 78, 3, 'completed', '2026-05-22 14:37:17', '2026-05-25 12:35:31'),
(88, 1, 79, 3, 'completed', '2026-05-25 12:21:32', '2026-05-25 12:35:28'),
(89, 1, 80, 3, 'completed', '2026-05-25 16:09:29', '2026-06-01 10:38:18'),
(90, 1, 81, 3, 'completed', '2026-05-27 13:08:04', '2026-06-01 10:38:22'),
(91, 1, 78, 3, 'completed', '2026-05-27 13:54:44', '2026-06-01 10:38:24'),
(92, 1, 80, 3, 'completed', '2026-05-27 14:27:42', '2026-06-01 10:38:26'),
(93, 1, 82, 3, 'completed', '2026-05-27 15:30:35', '2026-06-01 10:38:29'),
(94, 1, 83, 3, 'completed', '2026-05-28 12:35:24', '2026-06-01 10:38:31'),
(95, 1, 78, 3, 'completed', '2026-05-29 17:48:48', '2026-06-01 10:38:33'),
(96, 1, 80, 3, 'completed', '2026-06-01 10:38:56', '2026-06-01 11:45:43'),
(97, 1, 80, 3, 'completed', '2026-06-01 10:57:02', '2026-06-01 11:45:41'),
(98, 1, 80, 3, 'completed', '2026-06-01 10:57:45', '2026-06-01 11:45:39'),
(99, 1, 84, 3, 'completed', '2026-06-01 11:31:19', '2026-06-01 11:45:36'),
(100, 1, 84, 3, 'completed', '2026-06-01 11:32:08', '2026-06-01 11:45:33'),
(101, 1, 85, 3, 'completed', '2026-06-01 12:18:37', '2026-06-01 12:18:54'),
(102, 1, 85, 3, 'completed', '2026-06-01 12:19:08', '2026-06-01 12:36:19'),
(103, 1, 85, 3, 'completed', '2026-06-01 12:36:39', '2026-06-01 12:40:11'),
(104, 1, 86, 3, 'completed', '2026-06-01 15:40:36', '2026-06-01 15:40:56'),
(105, 1, 87, 3, 'completed', '2026-06-01 15:41:53', '2026-06-01 15:44:07'),
(106, 1, 88, 3, 'completed', '2026-06-01 15:42:13', '2026-06-02 11:29:02'),
(107, 1, 89, 3, 'completed', '2026-06-01 15:43:40', '2026-06-01 16:02:51');

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(4, '0001_01_01_000000_create_users_table', 1),
(5, '0001_01_01_000001_create_cache_table', 1),
(6, '0001_01_01_000002_create_jobs_table', 1),
(7, '2026_04_27_055841_create_branches_table', 2),
(8, '2026_04_27_062401_add_profile_and_2fa_to_users_table', 3),
(9, '2026_04_27_063408_add_active_branch_id_to_users_table', 3),
(10, '2026_04_27_064950_create_categories_table', 4),
(11, '2026_04_27_073158_create_table_areas_table', 5),
(12, '2026_04_27_073164_create_restaurant_tables_table', 5),
(13, '2026_04_27_084329_create_items_table', 6),
(14, '2026_04_27_085640_add_pricing_and_tax_to_items_table', 7),
(15, '2026_04_27_085641_create_item_variants_table', 7),
(16, '2026_04_27_095832_add_parent_id_to_users_table', 8),
(17, '2026_04_28_063708_create_orders_table', 9),
(18, '2026_04_28_063709_create_kots_table', 10),
(19, '2026_04_28_063711_create_order_items_table', 11),
(20, '2026_04_28_063712_create_kot_items_table', 12),
(21, '2026_04_28_124007_add_customer_details_to_orders_table', 13),
(22, '2026_04_30_103603_add_status_to_kot_items_table', 14),
(23, '2026_05_06_161836_add_notes_to_order_and_kot_items_table', 15),
(27, '2026_05_08_122810_create_deals_tables', 16),
(28, '2026_05_08_124424_add_variant_id_to_deal_slot_items_table', 16),
(29, '2026_05_08_125845_make_item_id_nullable_on_order_items_table', 17),
(30, '2026_05_11_144511_add_available_days_to_deals_table', 18),
(31, '2026_05_11_150440_add_visual_mapping_to_restaurant_tables_table', 19),
(32, '2026_05_19_161812_create_personal_access_tokens_table', 20);

INSERT INTO `order_items` (`id`, `order_id`, `item_id`, `variant_id`, `name`, `price`, `quantity`, `subtotal`, `notes`, `created_at`, `updated_at`, `deal_id`) VALUES
(1, 1, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + chocolate)', 499.00, 1, 499.00, NULL, '2026-05-11 14:36:59', '2026-05-11 14:36:59', 1),
(2, 2, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + kitkat)', 499.00, 1, 499.00, NULL, '2026-05-11 14:41:09', '2026-05-11 14:41:09', 1),
(3, 3, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-11 15:40:55', '2026-05-11 15:40:55', NULL),
(4, 4, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + chocolate)', 499.00, 1, 499.00, NULL, '2026-05-11 15:47:31', '2026-05-11 15:47:31', 1),
(5, 16, 1, NULL, 'Cheese Chowmein - Half Plate', 110.00, 1, 110.00, NULL, '2026-05-20 16:57:20', '2026-05-20 16:57:20', NULL),
(14, 21, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-20 17:03:02', '2026-05-20 17:03:02', NULL),
(15, 21, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-20 17:03:02', '2026-05-20 17:03:02', NULL),
(16, 20, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-20 17:03:27', '2026-05-20 17:03:27', NULL),
(17, 22, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-20 17:46:52', '2026-05-20 17:46:52', NULL),
(18, 22, 1, NULL, 'Singapuri Chowmein - Half Plate', 130.00, 1, 130.00, NULL, '2026-05-20 17:46:52', '2026-05-20 17:46:52', NULL),
(22, 26, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 12:02:21', '2026-05-21 12:02:21', NULL),
(23, 26, 8, 3, 'Garlic Chowmein', 100.00, 1, 100.00, NULL, '2026-05-21 12:02:21', '2026-05-21 12:02:21', NULL),
(24, 27, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 12:18:17', '2026-05-21 12:18:17', NULL),
(25, 27, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 12:18:17', '2026-05-21 12:18:17', NULL),
(26, 28, 10, 7, 'Cheese Chowmein', 110.00, 1, 110.00, NULL, '2026-05-21 12:19:52', '2026-05-21 12:19:52', NULL),
(27, 28, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 12:19:52', '2026-05-21 12:19:52', NULL),
(28, 29, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 12:28:01', '2026-05-21 12:28:01', NULL),
(29, 30, 1, NULL, 'Nuggets', 200.00, 1, 200.00, NULL, '2026-05-21 12:31:33', '2026-05-21 13:10:41', NULL),
(30, 31, 5, NULL, 'Cheese Finger', 160.00, 2, 320.00, NULL, '2026-05-21 13:09:01', '2026-05-21 13:09:01', NULL),
(31, 31, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 13:09:01', '2026-05-21 13:09:01', NULL),
(32, 32, 5, NULL, 'Cheese Finger', 160.00, 2, 320.00, NULL, '2026-05-21 13:13:37', '2026-05-21 13:15:24', NULL),
(33, 32, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 13:13:37', '2026-05-21 13:13:37', NULL),
(34, 32, 10, 7, 'Cheese Chowmein', 110.00, 1, 110.00, NULL, '2026-05-21 13:15:24', '2026-05-21 13:15:24', NULL),
(35, 33, 5, NULL, 'Cheese Finger', 160.00, 3, 480.00, NULL, '2026-05-21 13:15:58', '2026-05-21 13:15:58', NULL),
(36, 33, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-21 13:16:55', '2026-05-21 13:16:55', NULL),
(37, 34, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 13:17:50', '2026-05-21 13:17:50', NULL),
(38, 34, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 13:17:50', '2026-05-21 13:17:50', NULL),
(39, 34, 9, 5, 'Hakka Chowmein', 100.00, 1, 100.00, NULL, '2026-05-21 13:17:50', '2026-05-21 13:17:50', NULL),
(40, 34, 15, NULL, 'chilly mushroom', 120.00, 3, 360.00, NULL, '2026-05-21 13:18:01', '2026-05-21 13:18:18', NULL),
(41, 35, 5, NULL, 'Cheese Finger', 160.00, 2, 320.00, NULL, '2026-05-21 13:19:41', '2026-05-21 13:27:16', NULL),
(44, 35, 12, NULL, 'Spring Roll', 80.00, 4, 320.00, NULL, '2026-05-21 13:27:16', '2026-05-21 13:34:11', NULL),
(45, 36, 12, NULL, 'Spring Roll', 80.00, 3, 240.00, NULL, '2026-05-21 13:28:44', '2026-05-21 13:33:25', NULL),
(46, 37, 1, NULL, 'Nuggets', 100.00, 3, 300.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(47, 37, 2, NULL, 'Loaded Nachos', 110.00, 2, 220.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(48, 37, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(49, 37, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(50, 37, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(51, 37, 6, NULL, 'Cheese Corn Roll', 180.00, 1, 180.00, NULL, '2026-05-21 15:48:34', '2026-05-21 15:48:34', NULL),
(54, 38, 1, NULL, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-21 16:56:09', '2026-05-21 16:56:18', NULL),
(57, 39, 13, NULL, 'veg Bullets', 110.00, 2, 220.00, NULL, '2026-05-21 17:11:59', '2026-05-21 17:11:59', NULL),
(59, 41, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 17:14:28', '2026-05-21 17:14:28', NULL),
(60, 41, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-21 17:14:28', '2026-05-21 17:14:28', NULL),
(61, 40, 1, NULL, 'Garlic Chowmein - Half Plate', 100.00, 1, 100.00, NULL, '2026-05-21 17:14:43', '2026-05-21 17:14:43', NULL),
(62, 42, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 17:17:09', '2026-05-21 17:17:09', NULL),
(63, 42, 1, NULL, 'Cheese Chowmein - Full Plate', 200.00, 1, 200.00, NULL, '2026-05-21 17:17:44', '2026-05-21 17:17:44', NULL),
(65, 43, 1, NULL, 'Cheese Chowmein - Full Plate', 200.00, 1, 200.00, NULL, '2026-05-21 17:21:57', '2026-05-21 17:23:11', NULL),
(66, 44, 1, NULL, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-21 17:23:44', '2026-05-21 17:23:44', NULL),
(67, 45, 1, NULL, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-21 17:26:19', '2026-05-21 17:26:19', NULL),
(68, 46, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 17:31:58', '2026-05-21 17:31:58', NULL),
(69, 47, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-21 17:32:43', '2026-05-21 17:32:43', NULL),
(70, 48, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 17:40:14', '2026-05-21 17:40:14', NULL),
(71, 48, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-21 17:40:14', '2026-05-21 17:40:14', NULL),
(72, 49, 1, NULL, 'Hakka Chowmein - Half Plate', 100.00, 1, 100.00, NULL, '2026-05-21 17:41:10', '2026-05-21 17:41:10', NULL),
(80, 55, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 17:52:03', '2026-05-21 17:52:03', NULL),
(83, 57, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-21 17:54:41', '2026-05-21 17:54:41', NULL),
(84, 58, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 17:54:45', '2026-05-21 17:54:45', NULL),
(85, 59, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-21 17:54:49', '2026-05-21 17:54:49', NULL),
(87, 56, 1, NULL, 'Veg Chowmein - Half Plate', 80.00, 1, 80.00, NULL, '2026-05-21 17:58:16', '2026-05-21 17:58:16', NULL),
(88, 60, 1, NULL, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-22 10:19:18', '2026-05-22 10:21:22', NULL),
(89, 61, 7, 1, 'Veg Chowmein - Half Plate', 80.00, 1, 80.00, NULL, '2026-05-22 10:25:34', '2026-05-22 10:25:34', NULL),
(90, 62, 8, 4, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-22 10:26:44', '2026-05-22 10:26:44', NULL),
(93, 63, 8, 4, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-22 10:32:08', '2026-05-22 10:32:08', NULL),
(94, 62, 8, NULL, 'Garlic Chowmein', 100.00, 3, 300.00, NULL, '2026-05-22 10:41:53', '2026-05-22 10:44:02', NULL),
(95, 64, 7, 2, 'Veg Chowmein - Full Plate', 140.00, 1, 140.00, NULL, '2026-05-22 10:42:22', '2026-05-22 10:42:22', NULL),
(96, 65, 6, NULL, 'Cheese Corn Roll', 180.00, 1, 180.00, NULL, '2026-05-22 10:42:30', '2026-05-22 10:42:30', NULL),
(97, 66, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-05-22 10:42:39', '2026-05-22 10:42:39', NULL),
(98, 62, 7, 1, 'Veg Chowmein - Half Plate', 80.00, 1, 80.00, NULL, '2026-05-22 10:51:04', '2026-05-22 10:51:04', NULL),
(99, 67, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-22 10:55:29', '2026-05-22 10:55:29', NULL),
(100, 68, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-22 11:02:00', '2026-05-22 11:02:00', NULL),
(101, 68, 10, 8, 'Cheese Chowmein', 200.00, 1, 200.00, NULL, '2026-05-22 11:02:13', '2026-05-22 11:02:13', NULL),
(102, 69, 9, 5, 'Hakka Chowmein', 100.00, 1, 100.00, NULL, '2026-05-22 11:02:25', '2026-05-22 11:02:25', NULL),
(103, 69, 7, 1, 'Veg Chowmein', 80.00, 1, 80.00, NULL, '2026-05-22 11:02:43', '2026-05-22 11:02:43', NULL),
(104, 69, 9, 6, 'Hakka Chowmein', 170.00, 1, 170.00, NULL, '2026-05-22 11:03:29', '2026-05-22 11:04:22', NULL),
(105, 70, 14, NULL, 'garlic mushroom', 120.00, 1, 120.00, NULL, '2026-05-22 11:03:42', '2026-05-22 11:03:42', NULL),
(106, 69, 15, NULL, 'chilly mushroom', 120.00, 1, 120.00, NULL, '2026-05-22 11:04:22', '2026-05-22 11:04:22', NULL),
(107, 71, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-22 11:20:16', '2026-05-22 11:20:16', NULL),
(108, 72, 10, 7, 'Cheese Chowmein - Half Plate', 110.00, 1, 110.00, NULL, '2026-05-22 13:29:06', '2026-05-22 13:29:06', NULL),
(109, 73, 9, 6, 'Hakka Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-22 13:29:50', '2026-05-22 13:29:50', NULL),
(110, 74, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-05-22 13:30:09', '2026-05-22 13:30:09', NULL),
(111, 75, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-22 13:31:01', '2026-05-22 13:31:01', NULL),
(112, 75, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-05-22 13:31:01', '2026-05-22 13:31:01', NULL),
(113, 76, 5, NULL, 'Cheese Finger', 160.00, 2, 320.00, NULL, '2026-05-22 13:33:39', '2026-05-22 13:33:39', NULL),
(114, 77, 17, NULL, 'Cheese Choupsey', 160.00, 1, 160.00, NULL, '2026-05-22 13:37:52', '2026-05-22 13:37:52', NULL),
(115, 77, 8, 4, 'Garlic Chowmein - Full Plate', 170.00, 1, 170.00, NULL, '2026-05-22 13:43:58', '2026-05-22 13:43:58', NULL),
(116, 76, 10, 7, 'Cheese Chowmein - Half Plate', 110.00, 1, 110.00, NULL, '2026-05-22 14:11:29', '2026-05-22 14:11:29', NULL),
(117, 78, 4, NULL, 'Mushroom Duplex', 150.00, 1, 150.00, NULL, '2026-05-22 14:37:17', '2026-05-22 14:37:17', NULL),
(118, 79, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-05-25 12:21:32', '2026-05-25 12:21:32', NULL),
(119, 79, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-25 12:21:32', '2026-05-25 12:21:32', NULL),
(120, 80, 8, 3, 'Garlic Chowmein - Half Plate', 100.00, 1, 100.00, NULL, '2026-05-25 16:09:29', '2026-05-25 16:09:29', NULL),
(121, 81, 11, 9, 'Singapuri Chowmein (Half Plate)', 130.00, 1, 130.00, NULL, '2026-05-27 13:08:04', '2026-05-27 13:08:04', NULL),
(122, 81, 12, NULL, 'Spring Roll', 80.00, 1, 80.00, NULL, '2026-05-27 13:08:04', '2026-05-27 13:08:04', NULL),
(123, 78, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-05-27 13:54:44', '2026-05-27 13:54:44', NULL),
(124, 80, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-27 14:27:42', '2026-05-27 14:27:42', NULL),
(125, 82, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, 'test', '2026-05-27 15:30:35', '2026-05-27 15:30:35', NULL),
(126, 83, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + strawberry)', 499.00, 1, 499.00, NULL, '2026-05-28 12:35:24', '2026-05-28 12:35:24', 1),
(127, 78, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-05-29 17:48:48', '2026-05-29 17:48:48', NULL),
(128, 80, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + kitkat)', 499.00, 1, 499.00, NULL, '2026-06-01 10:38:56', '2026-06-01 10:38:56', 1),
(129, 80, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-06-01 10:57:02', '2026-06-01 10:57:02', NULL),
(130, 80, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-06-01 10:57:45', '2026-06-01 10:57:45', NULL),
(131, 84, NULL, NULL, 'Friday Deals (Paneer Makhani (small) + chocolate)', 499.00, 1, 499.00, NULL, '2026-06-01 11:31:19', '2026-06-01 11:31:19', 1),
(132, 84, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-06-01 11:32:08', '2026-06-01 11:32:08', NULL),
(133, 85, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-06-01 12:18:37', '2026-06-01 12:18:37', NULL),
(134, 85, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-06-01 12:19:08', '2026-06-01 12:19:08', NULL),
(135, 85, 5, NULL, 'Cheese Finger', 160.00, 1, 160.00, NULL, '2026-06-01 12:36:39', '2026-06-01 12:36:39', NULL),
(136, 86, 1, NULL, 'Nuggets', 100.00, 1, 100.00, NULL, '2026-06-01 15:40:36', '2026-06-01 15:40:36', NULL),
(137, 86, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-06-01 15:40:36', '2026-06-01 15:40:36', NULL),
(138, 87, 2, NULL, 'Loaded Nachos', 110.00, 1, 110.00, NULL, '2026-06-01 15:41:53', '2026-06-01 15:41:53', NULL),
(139, 87, 3, NULL, 'Cigar Roll', 140.00, 1, 140.00, NULL, '2026-06-01 15:41:53', '2026-06-01 15:41:53', NULL),
(140, 88, 10, 8, 'Cheese Chowmein', 200.00, 1, 200.00, NULL, '2026-06-01 15:42:13', '2026-06-01 15:42:13', NULL),
(141, 89, 13, NULL, 'veg Bullets', 110.00, 1, 110.00, NULL, '2026-06-01 15:43:40', '2026-06-01 15:43:40', NULL);

INSERT INTO `orders` (`id`, `branch_id`, `table_id`, `waiter_id`, `biller_id`, `order_type`, `status`, `subtotal`, `gst_amount`, `discount_type`, `discount_value`, `discount_amount`, `grand_total`, `payment_method`, `customer_name`, `customer_phone`, `delivery_address`, `split_cash`, `split_card`, `split_upi`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 3, 4, 'dine_in', 'settled', 499.00, 24.95, 'fixed', 0.00, 0.00, 523.95, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-11 14:36:59', '2026-05-11 14:37:54'),
(2, 1, 1, 3, 4, 'dine_in', 'settled', 499.00, 24.95, 'percentage', 10.00, 49.90, 474.05, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-11 14:41:09', '2026-05-11 14:42:12'),
(3, 1, 1, 3, 4, 'dine_in', 'settled', 160.00, 8.00, 'fixed', 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-11 15:40:55', '2026-05-12 10:26:41'),
(4, 1, 4, NULL, 4, 'dine_in', 'settled', 499.00, 24.95, 'fixed', 0.00, 0.00, 523.95, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-11 15:47:31', '2026-05-12 10:26:47'),
(16, 1, 3, 3, 4, 'dine_in', 'settled', 240.00, 12.00, NULL, 0.00, 0.00, 105.00, 'cash', 'jvh', NULL, NULL, NULL, NULL, NULL, '2026-05-20 16:57:20', '2026-05-20 17:19:19'),
(20, 1, 2, 3, 4, 'dine_in', 'settled', 150.00, 7.50, 'fixed', 0.00, 0.00, 157.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-20 17:01:28', '2026-05-21 12:19:18'),
(21, 1, 4, NULL, 4, 'dine_in', 'settled', 310.00, 15.50, 'fixed', 0.00, 0.00, 325.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-20 17:03:02', '2026-05-21 12:19:31'),
(22, 1, 2, 3, 4, 'dine_in', 'settled', 290.00, 14.50, NULL, 0.00, 0.00, 273.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-20 17:46:52', '2026-05-20 17:47:13'),
(26, 1, 7, NULL, 4, 'dine_in', 'settled', 260.00, 13.00, 'fixed', 0.00, 0.00, 273.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 12:02:21', '2026-05-21 12:19:23'),
(27, 1, 8, NULL, 4, 'dine_in', 'settled', 310.00, 15.50, 'fixed', 0.00, 0.00, 325.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 12:18:17', '2026-05-21 12:19:27'),
(28, 1, 1, NULL, 4, 'dine_in', 'settled', 270.00, 13.50, 'fixed', 0.00, 0.00, 283.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 12:19:52', '2026-05-21 12:27:24'),
(29, 1, 1, 3, 4, 'dine_in', 'settled', 160.00, 8.00, 'fixed', 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 12:28:01', '2026-05-21 13:16:46'),
(30, 1, 2, 3, 4, 'dine_in', 'settled', 200.00, 10.00, 'fixed', 0.00, 0.00, 378.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 12:31:33', '2026-05-21 13:13:18'),
(31, 1, 2, NULL, 4, 'dine_in', 'settled', 470.00, 23.50, 'fixed', 0.00, 0.00, 493.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 13:09:01', '2026-05-21 13:16:42'),
(32, 1, 2, 3, 4, 'dine_in', 'settled', 580.00, 29.00, 'fixed', 0.00, 0.00, 609.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 13:13:37', '2026-05-21 13:16:38'),
(33, 1, 3, NULL, 4, 'dine_in', 'settled', 590.00, 29.50, 'fixed', 0.00, 0.00, 735.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 13:15:58', '2026-05-21 13:17:11'),
(34, 1, 2, 3, 4, 'dine_in', 'settled', 770.00, 38.50, NULL, 0.00, 0.00, 808.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 13:17:50', '2026-05-21 13:33:38'),
(35, 1, 1, 3, 4, 'dine_in', 'settled', 640.00, 32.00, NULL, 0.00, 0.00, 346.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 13:19:41', '2026-05-21 13:35:23'),
(36, 1, 2, 3, 4, 'dine_in', 'settled', 240.00, 12.00, NULL, 0.00, 0.00, 252.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 13:28:44', '2026-05-21 13:34:01'),
(37, 1, 2, 3, 4, 'dine_in', 'settled', 1150.00, 57.50, NULL, 0.00, 0.00, 1207.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 15:48:34', '2026-05-21 15:51:57'),
(38, 1, 2, 3, 4, 'dine_in', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 178.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 16:53:53', '2026-05-21 17:12:51'),
(39, 1, 4, 3, 4, 'dine_in', 'settled', 220.00, 11.00, NULL, 0.00, 0.00, 231.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:09:42', '2026-05-21 17:12:45'),
(40, 1, 4, 3, 4, 'dine_in', 'settled', 100.00, 5.00, 'fixed', 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 17:14:12', '2026-05-21 17:15:56'),
(41, 1, 3, NULL, 4, 'dine_in', 'settled', 250.00, 12.50, 'fixed', 0.00, 0.00, 262.50, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 17:14:28', '2026-05-21 17:15:50'),
(42, 1, 2, 3, 4, 'dine_in', 'settled', 360.00, 18.00, NULL, 0.00, 0.00, 378.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:17:09', '2026-05-21 17:27:01'),
(43, 1, 4, 3, 4, 'dine_in', 'settled', 300.00, 15.00, NULL, 0.00, 0.00, 315.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:21:57', '2026-05-21 17:26:56'),
(44, 1, 5, 3, 4, 'dine_in', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 178.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:23:44', '2026-05-21 17:27:06'),
(45, 1, 8, 3, 4, 'dine_in', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 178.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:26:19', '2026-05-21 17:27:09'),
(46, 1, 1, 3, 4, 'dine_in', 'settled', 160.00, 8.00, NULL, 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:31:58', '2026-05-21 17:32:21'),
(47, 1, 2, 3, 4, 'dine_in', 'settled', 160.00, 8.00, NULL, 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:32:43', '2026-05-21 17:33:01'),
(48, 1, 1, 3, 4, 'dine_in', 'settled', 250.00, 12.50, NULL, 0.00, 0.00, 262.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:40:14', '2026-05-21 17:40:43'),
(49, 1, 3, 3, 4, 'dine_in', 'settled', 200.00, 10.00, NULL, 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:41:10', '2026-05-21 17:42:23'),
(55, 1, NULL, NULL, 4, 'takeaway', 'settled', 140.00, 7.00, NULL, 0.00, 0.00, 147.00, 'cash', 'test', NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:51:00', '2026-05-21 17:56:52'),
(56, 1, NULL, NULL, 4, 'takeaway', 'settled', 80.00, 4.00, NULL, 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:52:34', '2026-05-22 10:19:33'),
(57, 1, NULL, NULL, 4, 'takeaway', 'settled', 150.00, 7.50, NULL, 0.00, 0.00, 157.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:54:41', '2026-05-21 17:56:50'),
(58, 1, NULL, NULL, 4, 'takeaway', 'settled', 140.00, 7.00, 'fixed', 0.00, 0.00, 147.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-21 17:54:45', '2026-05-21 17:56:32'),
(59, 1, NULL, NULL, 4, 'takeaway', 'settled', 140.00, 7.00, NULL, 0.00, 0.00, 147.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-21 17:54:49', '2026-05-21 17:56:48'),
(60, 1, NULL, NULL, 4, 'takeaway', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:19:18', '2026-05-22 10:27:02'),
(61, 1, NULL, NULL, 4, 'takeaway', 'settled', 80.00, 4.00, NULL, 0.00, 0.00, 84.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:25:34', '2026-05-22 10:26:58'),
(62, 1, NULL, NULL, 4, 'takeaway', 'settled', 550.00, 27.50, NULL, 0.00, 0.00, 577.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:26:44', '2026-05-22 10:56:33'),
(63, 1, NULL, NULL, 4, 'takeaway', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:27:23', '2026-05-22 10:43:52'),
(64, 1, NULL, NULL, 4, 'takeaway', 'settled', 140.00, 7.00, NULL, 0.00, 0.00, 84.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:42:22', '2026-05-22 10:43:35'),
(65, 1, NULL, NULL, 4, 'takeaway', 'settled', 180.00, 9.00, NULL, 0.00, 0.00, 189.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:42:30', '2026-05-22 10:43:30'),
(66, 1, NULL, NULL, 4, 'takeaway', 'settled', 100.00, 5.00, NULL, 0.00, 0.00, 105.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 10:42:39', '2026-05-22 10:43:25'),
(67, 1, 1, 3, 4, 'dine_in', 'settled', 140.00, 7.00, 'fixed', 0.00, 0.00, 147.00, 'cash', NULL, NULL, NULL, 0.00, 0.00, 0.00, '2026-05-22 10:55:29', '2026-05-22 11:01:37'),
(68, 1, 1, 3, 4, 'dine_in', 'settled', 350.00, 17.50, NULL, 0.00, 0.00, 367.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 11:02:00', '2026-05-22 11:21:28'),
(69, 1, NULL, NULL, 4, 'takeaway', 'settled', 470.00, 23.50, NULL, 0.00, 0.00, 493.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 11:02:25', '2026-05-22 11:21:20'),
(70, 1, NULL, NULL, 4, 'takeaway', 'settled', 120.00, 6.00, NULL, 0.00, 0.00, 126.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 11:03:42', '2026-05-22 11:21:24'),
(71, 1, 2, 3, 4, 'dine_in', 'settled', 140.00, 7.00, NULL, 0.00, 0.00, 147.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 11:20:16', '2026-05-22 11:21:16'),
(72, 1, NULL, NULL, 4, 'takeaway', 'settled', 110.00, 5.50, NULL, 0.00, 0.00, 115.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:29:06', '2026-05-22 13:34:06'),
(73, 1, NULL, NULL, 4, 'takeaway', 'settled', 170.00, 8.50, NULL, 0.00, 0.00, 178.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:29:50', '2026-05-22 13:34:02'),
(74, 1, NULL, NULL, 4, 'takeaway', 'settled', 160.00, 8.00, NULL, 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:30:09', '2026-05-22 13:33:56'),
(75, 1, 1, NULL, 4, 'dine_in', 'settled', 250.00, 12.50, NULL, 0.00, 0.00, 262.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:31:01', '2026-05-22 13:34:11'),
(76, 1, 2, 3, 4, 'dine_in', 'settled', 430.00, 21.50, NULL, 0.00, 0.00, 451.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:33:39', '2026-05-22 14:13:18'),
(77, 1, NULL, NULL, 4, 'takeaway', 'settled', 330.00, 16.50, NULL, 0.00, 0.00, 346.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 13:37:52', '2026-05-22 14:13:21'),
(78, 1, 1, 3, 4, 'dine_in', 'settled', 210.00, 10.50, NULL, 0.00, 0.00, 220.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-22 14:37:17', '2026-06-01 11:30:35'),
(79, 1, 2, 3, 4, 'dine_in', 'settled', 210.00, 10.50, NULL, 0.00, 0.00, 220.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-25 12:21:32', '2026-06-01 10:56:34'),
(80, 1, 3, 3, 4, 'dine_in', 'settled', 140.00, 7.00, NULL, 0.00, 0.00, 147.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-25 16:09:29', '2026-06-01 11:30:35'),
(81, 1, 4, 3, 4, 'dine_in', 'settled', 210.00, 10.50, NULL, 0.00, 0.00, 220.50, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-27 13:08:04', '2026-06-01 11:30:35'),
(82, 1, 5, 3, 4, 'dine_in', 'settled', 160.00, 8.00, NULL, 0.00, 0.00, 168.00, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-27 15:30:35', '2026-06-01 11:30:35'),
(83, 1, 6, 3, 4, 'dine_in', 'settled', 499.00, 24.95, NULL, 0.00, 0.00, 523.95, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-05-28 12:35:24', '2026-06-01 11:30:35'),
(84, 1, 1, 3, 4, 'dine_in', 'settled', 599.00, 29.95, NULL, 0.00, 0.00, 628.95, 'cash', NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 11:31:19', '2026-06-01 11:33:20'),
(85, 1, 1, 3, NULL, 'dine_in', 'active', 370.00, 18.50, NULL, NULL, 0.00, 388.50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 12:18:37', '2026-06-01 12:36:39'),
(86, 1, 2, 3, 4, 'dine_in', 'active', 210.00, 10.50, NULL, NULL, 0.00, 220.50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 15:40:36', '2026-06-01 15:40:36'),
(87, 1, 3, 3, 4, 'dine_in', 'active', 250.00, 12.50, NULL, NULL, 0.00, 262.50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 15:41:53', '2026-06-01 15:41:53'),
(88, 1, 4, 3, 4, 'dine_in', 'active', 200.00, 10.00, NULL, NULL, 0.00, 210.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 15:42:13', '2026-06-01 15:42:13'),
(89, 1, 5, 3, 4, 'dine_in', 'active', 110.00, 5.50, NULL, NULL, 0.00, 115.50, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-06-01 15:43:40', '2026-06-01 15:43:40');

INSERT INTO `restaurant_tables` (`id`, `branch_id`, `area_id`, `name`, `capacity`, `status`, `pos_x`, `pos_y`, `width`, `height`, `shape`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 'B1', 4, 'occupied', 542, 411, 120, 120, 'square', 1, '2026-04-30 10:09:33', '2026-06-01 12:18:37'),
(2, 1, 1, 'B2', 6, 'occupied', 537, 250, 120, 120, 'square', 1, '2026-04-30 10:12:31', '2026-06-01 15:40:36'),
(3, 1, 1, 'B3', 8, 'occupied', 390, 250, 120, 120, 'square', 1, '2026-04-30 10:12:37', '2026-06-01 15:41:53'),
(4, 1, 1, 'B4', 4, 'occupied', 687, 249, 120, 120, 'square', 1, '2026-04-30 10:12:43', '2026-06-01 15:42:13'),
(5, 1, 2, 'H1', 4, 'occupied', 392, 412, 120, 120, 'square', 1, '2026-04-30 10:12:47', '2026-06-01 15:43:40'),
(6, 1, 2, 'H2', 8, 'available', 239, 251, 120, 120, 'square', 1, '2026-04-30 10:12:53', '2026-06-01 11:30:35'),
(7, 1, 2, 'H3', 10, 'available', 244, 412, 120, 120, 'square', 1, '2026-04-30 10:12:59', '2026-05-22 11:35:10'),
(8, 1, 2, 'H4', 10, 'available', 830, 248, 120, 120, 'square', 1, '2026-04-30 10:13:03', '2026-05-22 11:35:10');

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('Sqb3Z6SOQNyyp3PWR4nh7XPdyGhojWGvb9bMOkxZ', 4, '192.168.29.141', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJHdHBwZHZtWktCQjMwd2E3NHdxSjUyZURBN0pwTkhLM2xUc2p2VXk4IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cLzE5Mi4xNjguMjkuMTQxOjgwMDBcL2JpbGxlclwvYXBpXC9vcmRlcnNcL2FjdGl2ZSIsInJvdXRlIjoiYmlsbGVyLmFwaS5vcmRlcnMuYWN0aXZlIn0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfSwidXJsIjpbXSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjR9', 1780308821);

INSERT INTO `table_areas` (`id`, `branch_id`, `name`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 1, 'Basement', 1, '2026-04-30 10:08:37', '2026-04-30 10:08:37'),
(2, 1, 'Hall', 1, '2026-04-30 10:08:49', '2026-04-30 10:08:49');



