-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('food','drinks') NOT NULL,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `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 `categories`
--

INSERT INTO `categories` (`id`, `name`, `type`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 'Salads & Soups', 'food', 2, '2026-05-26 09:48:55', '2026-06-20 09:08:18'),
(2, 'Main Course', 'food', 2, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(3, 'Chinese Delight', 'food', 3, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(4, 'Light Meals', 'food', 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(5, 'Chicken Fiesta', 'food', 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(6, 'Goat & Glory', 'food', 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(7, 'Mixed Grill Platters', 'food', 7, '2026-05-26 09:48:56', '2026-06-21 15:21:37'),
(8, 'Fisherman\'s Table', 'food', 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(9, 'Desserts Corner', 'food', 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(10, 'Wraps & Rolex', 'food', 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(11, 'Burgers & Sandwiches', 'food', 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(12, 'African Traditional Flavours', 'food', 12, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(13, 'From Charcoal Grill', 'food', 13, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(14, 'Italian Corner', 'food', 14, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(15, 'Breakfast', 'food', 1, '2026-05-26 09:48:56', '2026-06-20 09:07:48'),
(16, 'Tea Sanctuary', 'drinks', 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(17, 'Juices & Smoothies', 'drinks', 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(18, 'The Art of the Bean', 'drinks', 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(19, 'Milkshakes & Ice Cream', 'drinks', 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(20, 'Sodas & Water', 'drinks', 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(21, 'Beers', 'drinks', 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(22, 'Cocktails', 'drinks', 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(23, 'Mocktails', 'drinks', 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(24, 'Shooters', 'drinks', 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(25, 'Wine List', 'drinks', 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(26, 'Spirits Collection', 'drinks', 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(27, 'Pasta', 'food', 15, '2026-06-20 09:57:51', '2026-06-20 09:57:51'),
(28, 'Kids Corner', 'food', 10, '2026-06-20 11:37:44', '2026-06-20 11:37:44'),
(29, 'GINS', 'drinks', 5, '2026-07-07 09:23:51', '2026-07-07 09:23:51'),
(30, 'Vodkas', 'drinks', 7, '2026-07-07 10:23:46', '2026-07-07 10:23:46'),
(31, 'RUM', 'drinks', 8, '2026-07-07 11:13:47', '2026-07-07 11:13:47'),
(32, 'TEQUILAS', 'drinks', 9, '2026-07-07 11:49:15', '2026-07-07 11:49:15'),
(33, 'Scotch whisky', 'drinks', 6, '2026-07-09 14:15:25', '2026-07-09 14:15:25'),
(34, 'Blended Whiskey', 'drinks', 6, '2026-07-09 14:34:31', '2026-07-09 14:34:31'),
(35, 'Single Malt Whiskey', 'drinks', 8, '2026-07-09 15:38:09', '2026-07-09 15:38:09');

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

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

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  `uuid` char(36) DEFAULT NULL,
  `collection_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `file_name` varchar(255) NOT NULL,
  `mime_type` varchar(255) DEFAULT NULL,
  `disk` varchar(255) NOT NULL,
  `conversions_disk` varchar(255) DEFAULT NULL,
  `size` bigint(20) UNSIGNED NOT NULL,
  `manipulations` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`manipulations`)),
  `custom_properties` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`custom_properties`)),
  `generated_conversions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`generated_conversions`)),
  `responsive_images` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`responsive_images`)),
  `order_column` int(10) UNSIGNED 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 `media`
--

INSERT INTO `media` (`id`, `model_type`, `model_id`, `uuid`, `collection_name`, `name`, `file_name`, `mime_type`, `disk`, `conversions_disk`, `size`, `manipulations`, `custom_properties`, `generated_conversions`, `responsive_images`, `order_column`, `created_at`, `updated_at`) VALUES
(2, 'App\\Models\\MenuItem', 1, '491722f4-64a7-41bb-b593-265924cbc0d5', 'image', 'shutterstock_2611252377', 'shutterstock_2611252377.jpg', 'image/jpeg', 'public', 'public', 357896, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:44:45', '2026-05-29 12:44:45'),
(3, 'App\\Models\\MenuItem', 3, 'fc259d92-00e1-4e35-8178-d1a0e9f6b16a', 'image', 'shutterstock_2766932273', 'shutterstock_2766932273.jpg', 'image/jpeg', 'public', 'public', 337251, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:47:06', '2026-05-29 12:47:06'),
(4, 'App\\Models\\MenuItem', 4, '39fda54f-c5a1-44ea-972a-7456e0bcf8a9', 'image', 'shutterstock_2112100550', 'shutterstock_2112100550.jpg', 'image/jpeg', 'public', 'public', 457678, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:49:12', '2026-05-29 12:49:12'),
(5, 'App\\Models\\MenuItem', 2, 'c655c7a3-8da9-4696-87a8-882df31b0afb', 'image', 'shutterstock_2636745839', 'shutterstock_2636745839.jpg', 'image/jpeg', 'public', 'public', 619950, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:52:00', '2026-05-29 12:52:00'),
(6, 'App\\Models\\MenuItem', 5, '80a08da3-71c7-4e59-963b-3244d0e75fd6', 'image', 'shutterstock_2705408945', 'shutterstock_2705408945.jpg', 'image/jpeg', 'public', 'public', 336320, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:54:00', '2026-05-29 12:54:00'),
(7, 'App\\Models\\MenuItem', 6, 'fc837f19-5fca-4a24-abff-5da6532ea1ce', 'image', 'shutterstock_2569293349', 'shutterstock_2569293349.jpg', 'image/jpeg', 'public', 'public', 433958, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:55:50', '2026-05-29 12:55:50'),
(8, 'App\\Models\\MenuItem', 7, 'ad2e67ff-be5e-43d2-a147-0c9fdc3f7247', 'image', 'shutterstock_2606240929', 'shutterstock_2606240929.jpg', 'image/jpeg', 'public', 'public', 837382, '[]', '[]', '[]', '[]', 1, '2026-05-29 12:59:41', '2026-05-29 12:59:41'),
(9, 'App\\Models\\MenuItem', 8, '188fdc22-18cb-4ae7-b724-f19a11eb48f9', 'image', 'shutterstock_2699349599', 'shutterstock_2699349599.jpg', 'image/jpeg', 'public', 'public', 521221, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:01:33', '2026-05-29 13:01:33'),
(11, 'App\\Models\\MenuItem', 10, '2a441bc0-6022-4fed-915e-6a4814fdba14', 'image', 'shutterstock_2286161911', 'shutterstock_2286161911.jpg', 'image/jpeg', 'public', 'public', 230753, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:07:36', '2026-05-29 13:07:36'),
(12, 'App\\Models\\MenuItem', 11, '05384c10-a6b7-4d2b-bd7b-b2da4a8d1432', 'image', 'shutterstock_2669283083', 'shutterstock_2669283083.jpg', 'image/jpeg', 'public', 'public', 576731, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:09:19', '2026-05-29 13:09:19'),
(13, 'App\\Models\\MenuItem', 12, 'ee0d20fe-f098-4fd1-904f-816144ea6a02', 'image', 'shutterstock_2661163785', 'shutterstock_2661163785.jpg', 'image/jpeg', 'public', 'public', 631455, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:11:36', '2026-05-29 13:11:36'),
(14, 'App\\Models\\MenuItem', 13, '091db4ca-d5d3-46ce-bcea-80567fc82954', 'image', 'shutterstock_2386084271', 'shutterstock_2386084271.jpg', 'image/jpeg', 'public', 'public', 397279, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:15:42', '2026-05-29 13:15:42'),
(15, 'App\\Models\\MenuItem', 14, 'c22453f6-e17c-4a2f-ac9f-b0322a3928a5', 'image', 'shutterstock_2457709645', 'shutterstock_2457709645.jpg', 'image/jpeg', 'public', 'public', 504716, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:18:25', '2026-05-29 13:18:25'),
(17, 'App\\Models\\MenuItem', 15, '139407e9-4359-41a7-b81c-1396e6c9b54d', 'image', 'istockphoto-982391002-612x612', 'istockphoto-982391002-612x612.jpg', 'image/jpeg', 'public', 'public', 62698, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:20:05', '2026-05-29 13:20:05'),
(18, 'App\\Models\\MenuItem', 16, '176e3163-7fe8-4963-99c1-41e8096fb279', 'image', 'Beef-and-Vegetable-Stir-Fry-15', 'Beef-and-Vegetable-Stir-Fry-15.jpg', 'image/jpeg', 'public', 'public', 254227, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:21:56', '2026-05-29 13:21:56'),
(19, 'App\\Models\\MenuItem', 17, 'd8a4f76c-c4cc-4e5b-8a69-9561b52244d0', 'image', 'shutterstock_2708077621', 'shutterstock_2708077621.jpg', 'image/jpeg', 'public', 'public', 482657, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:23:37', '2026-05-29 13:23:37'),
(20, 'App\\Models\\MenuItem', 18, 'ae2c6f61-1434-48a6-b06a-ad23acddefd1', 'image', 'shutterstock_2570116553', 'shutterstock_2570116553.jpg', 'image/jpeg', 'public', 'public', 489446, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:28:22', '2026-05-29 13:28:22'),
(21, 'App\\Models\\MenuItem', 19, '41b0e520-4ad8-4a7c-bb05-ef9224e02863', 'image', 'shutterstock_2522652199', 'shutterstock_2522652199.jpg', 'image/jpeg', 'public', 'public', 610506, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:31:04', '2026-05-29 13:31:04'),
(22, 'App\\Models\\MenuItem', 20, 'a5ce761a-83a5-48b7-9d50-f97bb957daa9', 'image', 'shutterstock_1439704541', 'shutterstock_1439704541.jpg', 'image/jpeg', 'public', 'public', 873428, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:33:21', '2026-05-29 13:33:21'),
(23, 'App\\Models\\MenuItem', 40, '326f6183-6d4f-4166-8b31-35ec0fc1443c', 'image', 'best-baked-chicken-breasts-9sm-6', 'best-baked-chicken-breasts-9sm-6.jpg', 'image/jpeg', 'public', 'public', 167813, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:35:32', '2026-05-29 13:35:32'),
(24, 'App\\Models\\MenuItem', 39, '2f08ff1f-c184-4751-bbe4-77cf02339f57', 'image', 'shutterstock_2611916011', 'shutterstock_2611916011.jpg', 'image/jpeg', 'public', 'public', 533339, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:54:18', '2026-05-29 13:54:18'),
(25, 'App\\Models\\MenuItem', 21, 'e0e75a09-b23b-4272-a600-583ddc53b935', 'image', 'shutterstock_2048163794', 'shutterstock_2048163794.jpg', 'image/jpeg', 'public', 'public', 595934, '[]', '[]', '[]', '[]', 1, '2026-05-29 13:57:09', '2026-05-29 13:57:09'),
(26, 'App\\Models\\MenuItem', 22, 'e763b2c6-cd0f-4699-a638-b3183f7faa20', 'image', 'shutterstock_2398192417', 'shutterstock_2398192417.jpg', 'image/jpeg', 'public', 'public', 526034, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:00:11', '2026-05-29 14:00:11'),
(27, 'App\\Models\\MenuItem', 23, '256a92ea-8ff4-49b8-badf-8b005f90a08b', 'image', 'chicken-breast', 'chicken-breast.jpg', 'image/jpeg', 'public', 'public', 147913, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:05:00', '2026-05-29 14:05:00'),
(28, 'App\\Models\\MenuItem', 24, '42b62ec1-81c4-45fe-8e93-cc7157a22090', 'image', 'shutterstock_2676229177', 'shutterstock_2676229177.jpg', 'image/jpeg', 'public', 'public', 563614, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:12:37', '2026-05-29 14:12:37'),
(29, 'App\\Models\\MenuItem', 25, '70bf31e1-3b13-478c-892d-92512ff02466', 'image', 'shutterstock_2673013741', 'shutterstock_2673013741.jpg', 'image/jpeg', 'public', 'public', 572423, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:14:39', '2026-05-29 14:14:39'),
(30, 'App\\Models\\MenuItem', 26, 'fd64c61b-65b3-4495-9725-e16ba6124de4', 'image', 'shutterstock_2694011689', 'shutterstock_2694011689.jpg', 'image/jpeg', 'public', 'public', 577962, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:17:21', '2026-05-29 14:17:21'),
(31, 'App\\Models\\MenuItem', 27, 'cf79e026-b8c0-4c54-8a6d-c59472b9dd4e', 'image', 'Asian-Lollipop-Chicken-500x500', 'Asian-Lollipop-Chicken-500x500.jpg', 'image/jpeg', 'public', 'public', 28347, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:18:08', '2026-05-29 14:18:08'),
(32, 'App\\Models\\MenuItem', 28, '17c2fd30-1e49-438e-9d6f-537581a7441c', 'image', 'shutterstock_2477893209', 'shutterstock_2477893209.jpg', 'image/jpeg', 'public', 'public', 467797, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:19:46', '2026-05-29 14:19:46'),
(33, 'App\\Models\\MenuItem', 29, '247d74fb-e621-4ccc-9152-682fd2f4154d', 'image', 'shutterstock_2701738503', 'shutterstock_2701738503.jpg', 'image/jpeg', 'public', 'public', 270712, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:22:37', '2026-05-29 14:22:37'),
(34, 'App\\Models\\MenuItem', 30, '86120feb-4f11-4907-a870-592b974f2415', 'image', 'shutterstock_2555626935', 'shutterstock_2555626935.jpg', 'image/jpeg', 'public', 'public', 644821, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:25:54', '2026-05-29 14:25:54'),
(35, 'App\\Models\\MenuItem', 31, 'f425dc31-8ea2-4cc7-b49f-4a910db14d14', 'image', 'shutterstock_2292744765', 'shutterstock_2292744765.jpg', 'image/jpeg', 'public', 'public', 388845, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:28:47', '2026-05-29 14:28:47'),
(36, 'App\\Models\\MenuItem', 32, '34212c5f-8645-4931-86a8-9004eda8e08e', 'image', 'shutterstock_2493019483', 'shutterstock_2493019483.jpg', 'image/jpeg', 'public', 'public', 544489, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:31:53', '2026-05-29 14:31:53'),
(37, 'App\\Models\\MenuItem', 33, 'd47a020c-cfb0-4d54-b0fa-b0b3b8d3b982', 'image', 'shutterstock_2666981781', 'shutterstock_2666981781.jpg', 'image/jpeg', 'public', 'public', 544195, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:34:25', '2026-05-29 14:34:25'),
(38, 'App\\Models\\MenuItem', 34, '75f8dfb1-9169-43ea-a723-554107120308', 'image', 'shutterstock_2577972055', 'shutterstock_2577972055.jpg', 'image/jpeg', 'public', 'public', 337604, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:36:29', '2026-05-29 14:36:29'),
(39, 'App\\Models\\MenuItem', 35, '02997974-bda4-4b1a-90e0-2743ac4280d4', 'image', 'shutterstock_2409743923', 'shutterstock_2409743923.jpg', 'image/jpeg', 'public', 'public', 742488, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:37:49', '2026-05-29 14:37:49'),
(40, 'App\\Models\\MenuItem', 36, '33feadb3-957b-4cea-b76a-701540a3c28d', 'image', 'shutterstock_2756613157', 'shutterstock_2756613157.jpg', 'image/jpeg', 'public', 'public', 321810, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:41:04', '2026-05-29 14:41:04'),
(41, 'App\\Models\\MenuItem', 37, '5c17449b-698b-43e0-82bf-f0ed4185335a', 'image', 'shutterstock_2499324057', 'shutterstock_2499324057.jpg', 'image/jpeg', 'public', 'public', 295651, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:44:47', '2026-05-29 14:44:47'),
(42, 'App\\Models\\MenuItem', 38, 'dad3c6d9-3182-4c38-973c-435363ed0f26', 'image', 'shutterstock_2633849599', 'shutterstock_2633849599.jpg', 'image/jpeg', 'public', 'public', 431164, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:47:37', '2026-05-29 14:47:37'),
(43, 'App\\Models\\MenuItem', 41, '8b0a7d88-c70f-4496-b1da-b16792263aef', 'image', 'shutterstock_2225425543', 'shutterstock_2225425543.jpg', 'image/jpeg', 'public', 'public', 568639, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:52:04', '2026-05-29 14:52:04'),
(44, 'App\\Models\\MenuItem', 42, '3376c454-9252-4a46-9e1e-1ede5ac870b2', 'image', 'shutterstock_2511330279', 'shutterstock_2511330279.jpg', 'image/jpeg', 'public', 'public', 715416, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:53:32', '2026-05-29 14:53:32'),
(45, 'App\\Models\\MenuItem', 43, '0057edf7-2e11-459b-991e-9c769f93bf0f', 'image', 'shutterstock_2439353327', 'shutterstock_2439353327.jpg', 'image/jpeg', 'public', 'public', 553689, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:55:33', '2026-05-29 14:55:33'),
(46, 'App\\Models\\MenuItem', 44, '45b03258-f271-4499-bccd-6f82066d2a28', 'image', 'shutterstock_2249266055', 'shutterstock_2249266055.jpg', 'image/jpeg', 'public', 'public', 382031, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:56:46', '2026-05-29 14:56:46'),
(47, 'App\\Models\\MenuItem', 45, '796cb38d-121d-446f-9ab3-bbbf7981d2aa', 'image', 'Fried_Goat_Meat', 'Fried_Goat_Meat.jpg', 'image/jpeg', 'public', 'public', 1461039, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:58:26', '2026-05-29 14:58:26'),
(48, 'App\\Models\\MenuItem', 46, 'a31eeb38-0275-432a-9363-f802c75fbdea', 'image', '360_F_647099829_UdsoTTwgGpffV0UioY1PT7pI6ELsQViq', '360_F_647099829_UdsoTTwgGpffV0UioY1PT7pI6ELsQViq.jpg', 'image/jpeg', 'public', 'public', 72013, '[]', '[]', '[]', '[]', 1, '2026-05-29 14:59:03', '2026-05-29 14:59:03'),
(49, 'App\\Models\\MenuItem', 47, '5788f2e1-33f9-403d-a586-b6e9f48311e6', 'image', 'shutterstock_2735517387', 'shutterstock_2735517387.jpg', 'image/jpeg', 'public', 'public', 258436, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:02:45', '2026-05-29 15:02:45'),
(50, 'App\\Models\\MenuItem', 48, 'ecbe7b77-510c-43ed-aa17-e5c4ce8b43ee', 'image', 'shutterstock_2673413313', 'shutterstock_2673413313.jpg', 'image/jpeg', 'public', 'public', 505632, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:04:46', '2026-05-29 15:04:46'),
(51, 'App\\Models\\MenuItem', 49, '5072ef5f-0427-497f-8081-fdd99168d16d', 'image', 'shutterstock_2430106215', 'shutterstock_2430106215.jpg', 'image/jpeg', 'public', 'public', 270649, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:08:57', '2026-05-29 15:08:57'),
(52, 'App\\Models\\MenuItem', 50, '3426401e-3180-4be7-98fb-d3b266d100c0', 'image', 'shutterstock_2578651077', 'shutterstock_2578651077.jpg', 'image/jpeg', 'public', 'public', 478269, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:17:25', '2026-05-29 15:17:25'),
(53, 'App\\Models\\MenuItem', 51, 'e50f9475-6fa0-4b96-8426-cfad07e3f2d1', 'image', 'shutterstock_2023917776', 'shutterstock_2023917776.jpg', 'image/jpeg', 'public', 'public', 854050, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:20:57', '2026-05-29 15:20:57'),
(54, 'App\\Models\\MenuItem', 52, 'd5c2b007-e472-4ba0-900f-920e2411de5a', 'image', 'shutterstock_1271252542', 'shutterstock_1271252542.jpg', 'image/jpeg', 'public', 'public', 1079312, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:25:27', '2026-05-29 15:25:27'),
(55, 'App\\Models\\MenuItem', 53, '606cd75e-a3e6-4767-8dd3-e930c589d327', 'image', 'shutterstock_2606225045', 'shutterstock_2606225045.jpg', 'image/jpeg', 'public', 'public', 432217, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:28:30', '2026-05-29 15:28:30'),
(56, 'App\\Models\\MenuItem', 9, 'dd99c986-97fb-4281-9b19-5232e6eaeebf', 'image', 'delicious-medium-rare-beef-steak-with-herbs-free-photo', 'delicious-medium-rare-beef-steak-with-herbs-free-photo.jpg', 'image/jpeg', 'public', 'public', 110862, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:30:08', '2026-05-29 15:30:08'),
(57, 'App\\Models\\MenuItem', 54, '98ffcd79-058b-47dd-85ec-089e94858dfa', 'image', 'shutterstock_2573115629', 'shutterstock_2573115629.jpg', 'image/jpeg', 'public', 'public', 453853, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:36:17', '2026-05-29 15:36:17'),
(58, 'App\\Models\\MenuItem', 55, 'c555f7fc-cc46-411a-a808-ee13ac6b195d', 'image', 'shutterstock_2633035791', 'shutterstock_2633035791.jpg', 'image/jpeg', 'public', 'public', 478643, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:39:07', '2026-05-29 15:39:07'),
(59, 'App\\Models\\MenuItem', 56, '4a82964a-5439-4dcc-9694-1ac80ed8476e', 'image', 'shutterstock_2644807285', 'shutterstock_2644807285.jpg', 'image/jpeg', 'public', 'public', 461764, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:45:22', '2026-05-29 15:45:22'),
(60, 'App\\Models\\MenuItem', 58, '80b1838c-a17e-4290-89c4-92e5018c5a3e', 'image', 'shutterstock_2674066371', 'shutterstock_2674066371.jpg', 'image/jpeg', 'public', 'public', 450272, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:48:57', '2026-05-29 15:48:57'),
(61, 'App\\Models\\MenuItem', 59, '6df4b9b8-eb58-46ab-8f20-351eb1acb1b3', 'image', 'shutterstock_2627110695', 'shutterstock_2627110695.jpg', 'image/jpeg', 'public', 'public', 418918, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:51:21', '2026-05-29 15:51:21'),
(62, 'App\\Models\\MenuItem', 60, 'f09d8a66-4894-473f-8c14-cae1421cc9da', 'image', 'shutterstock_2577292231', 'shutterstock_2577292231.jpg', 'image/jpeg', 'public', 'public', 647459, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:53:19', '2026-05-29 15:53:19'),
(63, 'App\\Models\\MenuItem', 61, 'db8f3eeb-fbe9-458b-9f88-6d1aa278a12a', 'image', 'shutterstock_2525441307', 'shutterstock_2525441307.jpg', 'image/jpeg', 'public', 'public', 484779, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:56:21', '2026-05-29 15:56:21'),
(64, 'App\\Models\\MenuItem', 62, '96e67010-3050-4f35-b5d8-db553d9d36b4', 'image', 'shutterstock_2573783537', 'shutterstock_2573783537.jpg', 'image/jpeg', 'public', 'public', 444083, '[]', '[]', '[]', '[]', 1, '2026-05-29 15:57:55', '2026-05-29 15:57:55'),
(69, 'App\\Models\\MenuItem', 67, 'dbe20dc7-5629-4d58-9f30-0bf84c81804f', 'image', 'istockphoto-1161112893-612x612', 'istockphoto-1161112893-612x612.jpg', 'image/jpeg', 'public', 'public', 63387, '[]', '[]', '[]', '[]', 1, '2026-05-29 16:55:16', '2026-05-29 16:55:16'),
(70, 'App\\Models\\MenuItem', 68, 'dc968e30-b9ee-4a95-b73e-4a648c0c579b', 'image', 'shutterstock_1063868258', 'shutterstock_1063868258.jpg', 'image/jpeg', 'public', 'public', 672919, '[]', '[]', '[]', '[]', 1, '2026-05-29 16:57:31', '2026-05-29 16:57:31'),
(71, 'App\\Models\\MenuItem', 69, '88e10c13-acb2-44c9-9c9d-ea1cfcfb9003', 'image', 'shutterstock_2736665197', 'shutterstock_2736665197.jpg', 'image/jpeg', 'public', 'public', 319465, '[]', '[]', '[]', '[]', 1, '2026-05-29 16:59:38', '2026-05-29 16:59:38'),
(72, 'App\\Models\\MenuItem', 70, 'ddf1ad27-da6b-4da2-a286-c74004b85991', 'image', 'shutterstock_2697580373', 'shutterstock_2697580373.jpg', 'image/jpeg', 'public', 'public', 447586, '[]', '[]', '[]', '[]', 1, '2026-05-29 17:06:55', '2026-05-29 17:06:55'),
(73, 'App\\Models\\MenuItem', 71, 'eed26c8f-a19f-4a1a-a727-0e573972ed70', 'image', 'shutterstock_2441221483', 'shutterstock_2441221483.jpg', 'image/jpeg', 'public', 'public', 510382, '[]', '[]', '[]', '[]', 1, '2026-05-29 17:10:33', '2026-05-29 17:10:33'),
(75, 'App\\Models\\MenuItem', 258, '29a83580-6999-4626-96c3-d09c88180971', 'image', 'lemon', 'lemon.jpeg', 'image/jpeg', 'public', 'public', 201274, '[]', '[]', '[]', '[]', 1, '2026-07-07 12:16:47', '2026-07-07 12:16:47'),
(76, 'App\\Models\\MenuItem', 314, 'ecb2d6ce-1e6e-438b-9046-84e561f98c99', 'image', 'IMG-20260707-WA0046', 'IMG-20260707-WA0046.jpg', 'image/jpeg', 'public', 'public', 139658, '[]', '[]', '[]', '[]', 1, '2026-07-07 13:27:44', '2026-07-07 13:27:44');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `price` decimal(12,2) NOT NULL,
  `is_available` tinyint(1) NOT NULL DEFAULT 1,
  `sort_order` int(11) NOT NULL DEFAULT 0,
  `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 `menu_items`
--

INSERT INTO `menu_items` (`id`, `category_id`, `name`, `description`, `price`, `is_available`, `sort_order`, `created_at`, `updated_at`) VALUES
(1, 1, 'Machow Soup', NULL, 15000.00, 1, 1, '2026-05-26 09:48:55', '2026-05-29 12:44:45'),
(2, 1, 'Chicken Caesar Salad', 'Chicken flakes, lettuce, croutons, carrots and red pepper, parmesan cheese, served with Caesar dressing.', 40000.00, 1, 2, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(3, 1, 'Fresh Green Salad', 'Tomato, onion, cucumber, lettuce, olives, carrots served with lemon and bread rolls.', 26000.00, 1, 3, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(4, 1, 'Cream of Mushroom Soup', NULL, 15000.00, 1, 4, '2026-05-26 09:48:55', '2026-05-29 12:49:12'),
(5, 1, 'Clear Chicken Soup', NULL, 15000.00, 1, 5, '2026-05-26 09:48:55', '2026-05-29 12:54:00'),
(6, 1, 'Sweet Corn Chicken Soup', NULL, 15000.00, 1, 6, '2026-05-26 09:48:55', '2026-05-29 12:55:50'),
(7, 2, 'Crispy Onion Steak', 'Grilled steak served with richly onion and pepper sauce.', 50000.00, 1, 1, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(8, 2, 'Mushroom Steak', 'Well marinated steak with mustard, pepper, garlic and mushroom sauce.', 50000.00, 1, 2, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(9, 2, 'Organic Fillet Steak', NULL, 50000.00, 1, 3, '2026-05-26 09:48:55', '2026-05-29 13:03:52'),
(10, 2, 'Prime Rib Eye', NULL, 50000.00, 1, 4, '2026-05-26 09:48:55', '2026-05-29 13:07:36'),
(11, 2, 'Classic Sabinyo T-Bone Steak', NULL, 50000.00, 1, 5, '2026-05-26 09:48:55', '2026-05-29 13:09:19'),
(12, 2, 'Beef Stir Fry', 'Perfectly fried beef stripes with assorted vegetables, soya sauce, oyster and a dash of Worcestershire sauce.', 45000.00, 1, 6, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(13, 2, 'Liver', 'Thin slices of beef liver prepared to perfection served with either rice or chips only.', 45000.00, 1, 7, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(14, 3, 'Chicken Satay', NULL, 50000.00, 1, 1, '2026-05-26 09:48:55', '2026-05-29 13:18:25'),
(15, 3, 'Lamb Ribs', NULL, 50000.00, 1, 2, '2026-05-26 09:48:55', '2026-05-29 13:20:04'),
(16, 3, 'Dry Chili Pork', NULL, 45000.00, 1, 3, '2026-05-26 09:48:55', '2026-05-29 13:21:56'),
(17, 3, 'Dry Chili Chicken', NULL, 45000.00, 1, 4, '2026-05-26 09:48:55', '2026-05-29 13:23:37'),
(18, 3, 'Norwegian Salmon Fish', NULL, 70000.00, 1, 5, '2026-05-26 09:48:55', '2026-05-29 13:28:22'),
(19, 3, 'Golden Fried Prawns', 'Prawns deep battered fried until golden.', 70000.00, 1, 6, '2026-05-26 09:48:55', '2026-05-26 09:48:55'),
(20, 3, 'Salt and Pepper Prawn', 'Prawns fried and tossed in garlic, black pepper powder and some scallions.', 70000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(21, 3, 'Chilli Prawns', 'Prawns toasted with dry chilies and soy sauce.', 80000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(22, 3, 'Butter Garlic Prawn', 'Shallow fried prawn cooked in butter creamy sauce with brown burnt garlic.', 80000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(23, 3, 'Sizzling Chicken', 'Dices of chicken prepared in a rich oyster sauce.', 50000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(24, 3, 'Fish Gouba', 'Dices of fish fillet cooked in dry red chilies.', 50000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(25, 3, 'Sizzling / Stir Fried Vegetables', NULL, 40000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-29 14:14:39'),
(26, 4, 'Chicken Wings', 'Chicken wings coated with butter and deep fried, toasted in barbecue sauce, served with chips.', 35000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(27, 4, 'Chicken Lollipops', 'Coated chicken drum sticks with ginger and garlic paste, deep fried, served with chips.', 40000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(28, 4, 'Fish Fingers', 'Marinated fish fingers with bread crumb, deep fried, served with chips.', 35000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(29, 4, 'Vegetable Spring Rolls', 'Oriented rolls stuffed with toasted vegetables.', 10000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(30, 4, 'Vegetable Samosa / Beef', NULL, 15000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-29 14:25:54'),
(31, 4, 'Plain Chips', NULL, 15000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-29 14:28:47'),
(32, 4, 'Vegetable Fried Rice', NULL, 25000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-29 14:31:53'),
(33, 4, 'Chicken Egg Fried Rice', NULL, 35000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-29 14:34:25'),
(34, 4, 'Egg Fried Rice', NULL, 30000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-29 14:36:29'),
(35, 4, 'Masala Chips', NULL, 30000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-29 14:37:49'),
(36, 4, 'Pork Sausage', NULL, 10000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-29 14:41:04'),
(37, 4, 'Beef / Chicken Sausage', NULL, 10000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-29 14:44:14'),
(38, 4, 'Chapatti', NULL, 5000.00, 1, 13, '2026-05-26 09:48:56', '2026-05-29 14:47:37'),
(39, 5, 'Chicken Stir Fry', 'Perfectly fried chicken stripes with assorted vegetables, soya sauce, oyster and a dash of Worcestershire sauce.', 45000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(40, 5, 'Grilled Chicken Breast', 'Perfectly grilled chicken served with seasonal vegetables and cream paprika sauce.', 45000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(41, 5, 'Lemon Herb Basted Chicken / Peri Peri', NULL, 65000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-29 14:52:04'),
(42, 5, 'Chicken and Chips', NULL, 40000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-29 14:53:32'),
(43, 5, 'Half Grilled Chicken', 'Marinated and slow-roasted half chicken, bursting with flavor and served with your choice of side.', 60000.00, 1, 5, '2026-05-26 09:48:56', '2026-06-20 09:45:20'),
(44, 5, 'Whole Chicken and Chips', NULL, 100000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-29 14:56:46'),
(45, 6, 'Pan Fried Goat Meat', 'Served with chips or potato wedges.', 50000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(46, 2, 'Grilled Pork Ribs', 'Toasted spare ribs with vegetables done to your wish.', 50000.00, 1, 8, '2026-05-26 09:48:56', '2026-06-21 15:19:03'),
(47, 2, 'Honey Glazed Pork Chops', 'Juicy pork chops served with honey mustard sauce.', 50000.00, 1, 9, '2026-05-26 09:48:56', '2026-06-21 15:19:31'),
(48, 2, 'Pan Fried Pork', 'Tenderized meat done to your choice with salad and barbecue sauce.', 50000.00, 1, 10, '2026-05-26 09:48:56', '2026-06-21 15:19:58'),
(49, 8, 'Goujon of Tilapia Fillet', 'Grilled fish fillet coated with bread crumbs on a bed of vegetables, served with tartar sauce.', 40000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(50, 8, 'Grilled Fish Fillet', 'Perfectly pan seared and served with fries and tartar sauce.', 45000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(51, 8, 'Entebbe Mexican Whole Tilapia', 'Whole tilapia fish well marinated and oven baked, served with potato wedges and sauce aside.', 70000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(52, 8, 'Boiled Whole Tilapia', 'Naturally boiled Victoria tilapia served with boiled Irish or coconut rice.', 70000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(53, 8, 'Whole Fried Fish Stew', 'Whole Victoria tilapia cut into two, prepared in a rich thick tomato sauce, served with accompaniment of your choice.', 70000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(54, 8, 'Whole Tilapia Medium', NULL, 50000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-29 15:36:17'),
(55, 9, 'Dessert Fruit Platter', 'Assorted tropical seasonal fruits.', 0.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(56, 9, 'Fruit Salad', 'Assorted fresh fruit cubes.', 0.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(57, 10, 'Chicken Rolex / Beef', 'Chicken/beef strips with a 1000 island dressing.', 25000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(58, 10, 'Chicken/Beef Wrap with Fries', NULL, 30000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-29 15:48:57'),
(59, 10, 'Peruvian Lomo Saltado Chicken/Beef', NULL, 35000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-29 15:51:21'),
(60, 11, 'Chicken Burger', 'Chicken breast with lettuce, onions, tomatoes and mayonnaise served with chips.', 48000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(61, 11, 'Beef Burger', 'Grilled beef patty, lettuce, cucumber, onion, tomatoes and cheese served with chips.', 48000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(62, 11, 'Vegetable Burger', 'Assorted vegetable lettuce, cucumber with cheese or not served with chips.', 30000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(67, 12, 'Goat Stew', 'Served with accompaniment of your choice.', 50000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(68, 12, 'Beef Stew', 'Served with accompaniment of your choice.', 50000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(69, 12, 'Chicken Stew', 'Served with accompaniment of your choice.', 45000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(70, 12, 'Pan Fried Ox Liver', 'Served with accompaniment of your choice.', 45000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(71, 13, 'Goat Choma', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 55000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(72, 13, 'Pork Choma', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 55000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(73, 13, 'Chicken Choma', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 50000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(74, 13, 'Fish Choma', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 50000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(75, 13, 'Chicken Box', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 60000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(76, 13, 'Goat Box', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 60000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(77, 13, 'Pork Box', 'Accompanied with kachumbari salads, potato wedges, boiled matooke and rolled ugali.', 60000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(78, 14, 'Chicken Tikka Pizza', '', 50000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(79, 14, 'Classic Margherita Pizza', 'Pomodoro sauce, mozzarella & basil leaves', 40000.00, 1, 2, '2026-05-26 09:48:56', '2026-06-20 10:20:16'),
(80, 14, 'Meat Cravers Pizza', '', 50000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(81, 14, 'Smoked Beef Pizza', '', 45000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(82, 14, 'Chicken Pesto Pizza', 'Pesto chicken, pesto sauce, mozzarella, oregano, onions, pomodoro sauce', 40000.00, 1, 5, '2026-05-26 09:48:56', '2026-06-20 10:22:15'),
(87, 27, 'Prawn Pasta', NULL, 55000.00, 1, 1, '2026-05-26 09:48:56', '2026-06-20 09:58:36'),
(88, 27, 'Creamy Mushroom & Chicken Pasta', NULL, 55000.00, 1, 2, '2026-05-26 09:48:56', '2026-06-20 09:59:21'),
(89, 15, 'English Breakfast', 'Irish potatoes, eggs of choice, two meats, sausages of choice, tosted bread, fruits and juice', 50000.00, 1, 1, '2026-05-26 09:48:56', '2026-07-09 15:59:06'),
(90, 15, 'Sabinyo Breakfast', 'Eggs, Sausage, one meat, irish potatoes and tosted bread', 40000.00, 1, 2, '2026-05-26 09:48:56', '2026-07-09 16:00:30'),
(92, 15, 'Mist Hotel Burritos', 'Our signature breakfast burritos with curried chicken strips, peppers, onions, omelette, pair of sausage, sweet and spicy potatoes with garden salad', 40000.00, 1, 4, '2026-05-26 09:48:56', '2026-06-20 09:26:01'),
(93, 16, 'Black Tea', '', 7000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(94, 16, 'Plain Milk', '', 8000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(95, 16, 'African Tea', '', 10000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(96, 16, 'Chai Latte & Masala Tea', '', 10000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(97, 16, 'English Tea', '', 10000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(98, 16, 'Hot Chocolate', '', 10000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(99, 16, 'Herbal Teas', 'Green tea, cinnamon tea, peppermint tea, hibiscus tea, chamomile tea, earl grey, rooibos tea.', 10000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(100, 16, 'Dawa Tea', '', 15000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(101, 17, 'Fresh Passion Fruit Juice', '', 12000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(102, 17, 'Fresh Watermelon Juice', '', 12000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(103, 17, 'Fresh Pineapple Juice', '', 12000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(104, 17, 'Tropical Oats Meal Smoothie', 'Oats, banana, coconut milk, lemon, mangoes, pineapple & yogurt.', 20000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(105, 17, 'Berry-Almond Smoothie', 'Banana, strawberries, almond milk, yogurt and a sweetener.', 20000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(106, 17, 'Peanut Butter Smoothie', 'Peanut butter, vanilla yogurt, bananas, soymilk.', 20000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(107, 17, 'Green Smoothie Bowl', 'Spinach, soymilk, banana, avocado, sweetener.', 20000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(108, 17, 'The Mist Frozen Smoothie', 'Oranges, mangoes, pineapples, strawberries, ginger, yogurt.', 20000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(109, 17, 'Mboona Juice', 'Fresh mangoes, mint, oranges & lime.', 15000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(110, 17, 'Vitamin C Juice', 'Carrots, oranges, ginger and a sweetener.', 15000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(111, 17, 'Green Juice', 'Spinach, celery, green apples and a sweetener.', 15000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(112, 17, 'The Tropical Mix', 'Passion fruit, pineapples, mango, carrot & beetroot.', 18000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(113, 18, 'Espresso (Single)', '', 7000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(114, 18, 'Espresso (Double)', '', 8000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(115, 18, 'Café Americano', '', 8000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(116, 18, 'Cappuccino', '', 10000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(117, 18, 'Café Latte', '', 10000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(118, 18, 'Café Mocha', '', 10000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(119, 18, 'African Coffee', '', 10000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(120, 18, 'English Coffee', '', 10000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(121, 18, 'The Affogatto', '', 10000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(122, 18, 'Black Coffee', '', 9000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(123, 18, 'Iced Coffee', '', 10000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(124, 19, 'Banana Milkshake', 'Banana, milk and ice cream.', 15000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(125, 19, 'Vanilla Milkshake', 'Vanilla ice cream, milk, and vanilla extracts.', 15000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(126, 19, 'Chocolate Milkshake', 'Chocolate ice cream, milk, chocolate shavings.', 15000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(127, 19, 'Strawberry Milkshake', 'Strawberry ice cream, milk and fresh strawberries.', 15000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(128, 19, 'Mist Mix Shake', 'A blend of 2 flavors of your choice with a cookie.', 18000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(129, 20, 'All Sodas', '', 3000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(130, 20, 'Mineral Water', '', 3000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(131, 20, 'Red Bull', '', 10000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(132, 20, 'Monster Energy', '', 12000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(133, 21, 'Local Beers', '', 8000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(134, 21, 'Fresh Draft Beer', '', 8000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(135, 21, 'Savanna', '', 10000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(136, 21, 'Corona Beer', '', 10000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(137, 21, 'Heineken', '', 10000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(138, 21, 'Heineken Can', '', 15000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(139, 22, 'Moment of Silence', 'Whiskey, orange liqueur, brandy and a drop of cranberry juice.', 30000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(140, 22, 'Midnight Serenade', 'Jameson, Kahlua, espresso, Guinness on crushed ice.', 30000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(141, 22, 'Whiskey Delight', 'Whiskey, muddled cherries, lemon, honey sprinkled with cinnamon.', 25000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(142, 22, 'Boulevardier', 'Whiskey, sweet vermouth, Campari and a dash of bitters.', 25000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(143, 22, 'The Black Ark', 'Whiskey, sweet vermouth, espresso, top up with Coca-Cola.', 25000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(144, 22, 'The Lovely Mist Island', 'Gin, vodka, rum, tequila, triple sec, lime juice and a top up of coke.', 35000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(145, 22, 'Fruity Frozen Negroni', 'Gin, Campari & sweet vermouth.', 25000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(146, 22, 'Aperol Gin-Lemon Twist', 'Gin, Aperol, cranberry juice, lemon juice.', 25000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(147, 22, 'Sins Whisper', 'Gin, vodka, blue curacao, pineapple juice, lemon, orange juice.', 25000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(148, 22, 'Champagne Margarita', 'Tequila, triple sec, lemon, top up with champagne.', 30000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(149, 22, 'Passion Star Martini', 'Passionfruit vodka, lime, simple syrup and a sparkling wine.', 25000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(150, 22, 'The Weekend at Mist (Sangria)', 'Red wine, gin, seasonal fresh fruit cuts, fresh juice, triple sec and lemonade.', 35000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(151, 22, 'Hidden Oasis @ Mist', 'Raspberry, gin, vodka, pineapple juice and sparkling wine.', 30000.00, 1, 13, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(152, 22, 'Entebbe Bliss', 'Vodka, orange liqueur, Kahlua, Baileys, whipped cream and chocolate syrup.', 30000.00, 1, 14, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(153, 22, 'Espresso Martini', 'Espresso, vodka, coffee liqueur, simple syrup.', 25000.00, 1, 15, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(154, 22, 'White Russian', 'Vodka, Kahlua and cream.', 25000.00, 1, 16, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(155, 22, 'Hibiscus Vodka Sour', 'Infused hibiscus leaves, lemonade, vodka, cinnamon, egg white (optional).', 25000.00, 1, 17, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(156, 22, 'Adios MFK', 'Gin, vodka, rum, tequila, blue curacao, lime.', 35000.00, 1, 18, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(157, 22, 'Mudslide', 'Kahlua creamy liqueur, vodka and chocolate syrup.', 30000.00, 1, 19, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(158, 22, 'Creamy Colada', 'Pineapple juice, rum, creamy liqueur.', 25000.00, 1, 20, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(159, 22, 'Brynn Curshe', 'Amarula, strawberry, red wine, whipping cream.', 30000.00, 1, 21, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(160, 22, 'Hard Knock', 'Brandy, coffee liqueur, tequila, chocolate and cream.', 30000.00, 1, 22, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(161, 22, 'Tipsy Affogatto', 'Whiskey, creamy liqueur, coffee liqueur and vanilla ice cream.', 30000.00, 1, 23, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(162, 23, 'The Fruity Avalanche', 'Passion, orange, grenadine syrup and vanilla ice cream.', 20000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(163, 23, 'The Summer Berry', 'Pineapple juice, strawberry, lemon and soda water.', 20000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(164, 23, 'The Limelight Mix', 'Coconut milk, orange juice, lime, pineapple and a pinch of cinnamon.', 20000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(165, 23, 'Stormy Ocean', 'Strawberries, coconut milk, mint, lime and orange juice.', 20000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(166, 24, 'Apocalypse Now', 'Tequila, Irish cream, dry vermouth.', 20000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(167, 24, 'B-52', 'Kahlua, Baileys, orange liqueur.', 20000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(168, 24, 'Jager Bomb', 'Jägermeister and Red Bull.', 20000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(169, 24, 'Touch Down', 'Jägermeister, peach schnapps, cranberry juice.', 20000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(170, 24, '14 Avenue', 'Grenadine, blue curacao and vodka.', 20000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(171, 25, 'Nederburg Shiraz', 'Red dry wine. By glass.', 25000.00, 1, 1, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(172, 25, 'Nederburg Merlot', 'Red dry wine. By glass.', 25000.00, 1, 2, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(173, 25, 'Nederburg Pinotage', 'Red dry wine. By glass.', 25000.00, 1, 3, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(174, 25, 'Nederburg Cabernet Sauvignon', 'Red dry wine. By glass.', 25000.00, 1, 4, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(175, 25, 'KWV Shiraz', 'Red dry wine. By glass.', 25000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(176, 25, 'KWV Merlot', 'Red dry wine. By glass.', 25000.00, 1, 6, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(177, 25, 'KWV Pinotage', 'Red dry wine. By glass.', 25000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(178, 25, 'KWV Cabernet Sauvignon', 'Red dry wine. By glass.', 25000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(179, 25, 'Suu Kissed Red', 'Red sweet wine. By glass.', 25000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(180, 25, 'Sweet Lips Red', 'Red sweet wine. By glass.', 25000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(181, 25, 'Robertson Red', 'Red sweet wine. By glass.', 25000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(182, 25, 'Nederburg Chenin Blanc', 'White dry wine. By glass.', 25000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(183, 25, 'Nederburg Sauvignon Blanc', 'White dry wine. By glass.', 25000.00, 1, 13, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(184, 25, 'Nederburg Chardonnay', 'White dry wine. By glass.', 25000.00, 1, 14, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(185, 25, 'KWV Chenin Blanc', 'White dry wine. By glass.', 25000.00, 1, 15, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(186, 25, 'KWV Sauvignon Blanc', 'White dry wine. By glass.', 25000.00, 1, 16, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(187, 25, 'KWV Chardonnay', 'White dry wine. By glass.', 25000.00, 1, 17, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(188, 25, 'Suu Kissed White', 'White sweet wine. By glass.', 25000.00, 1, 18, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(189, 25, 'Robertson White', 'White sweet wine. By glass.', 25000.00, 1, 19, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(190, 25, 'Fragolino Rosso', 'Sparkling wine. By bottle.', 120000.00, 1, 20, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(191, 25, 'Fragolino White', 'Sparkling wine. By bottle.', 120000.00, 1, 21, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(192, 25, 'Fragolino Rose', 'Sparkling wine. By bottle.', 120000.00, 1, 22, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(193, 25, 'JP Chenet White', 'Sparkling wine. By bottle.', 120000.00, 1, 23, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(194, 25, 'JP Chenet Pink', 'Sparkling wine. By bottle.', 120000.00, 1, 24, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(195, 25, 'Moët Chandon', 'Champagne. By bottle.', 472000.00, 1, 25, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(196, 25, 'Moët Nectar', 'Champagne. By bottle.', 512000.00, 1, 26, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(197, 25, 'Moët Rosé', 'Champagne. By bottle.', 512000.00, 1, 27, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(198, 25, 'Veuve Clicquot', 'Champagne. By bottle.', 550000.00, 1, 28, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(199, 25, 'Zonnin Prosecco', 'Sparkling wine. By bottle.', 200000.00, 1, 29, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(200, 25, 'Belaire Rosé', 'Sparkling wine. By bottle.', 258000.00, 1, 30, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(205, 26, 'Jameson Irish Whiskey', 'By tot.', 10000.00, 1, 5, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(207, 26, 'Hennessey VS', 'Cognac. By tot.', 14000.00, 1, 7, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(208, 26, 'Smirnoff Vodka', 'By tot.', 4000.00, 1, 8, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(209, 26, 'Gordons Gin', 'By tot.', 5000.00, 1, 9, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(210, 26, 'Captain Morgan Gold Rum', 'By tot.', 5000.00, 1, 10, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(211, 26, 'Olmeca Gold Tequila', 'By tot.', 8000.00, 1, 11, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(212, 26, 'Jose Cuervo Gold Tequila', 'By tot.', 10000.00, 1, 12, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(213, 26, 'Kahlua', 'Coffee liqueur. By tot.', 8000.00, 1, 13, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(214, 26, 'Baileys', 'Irish cream liqueur. By tot.', 8000.00, 1, 14, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(215, 26, 'Campari', 'Aperitif. By tot.', 8000.00, 1, 15, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(216, 26, 'Amarula', 'South African liqueur. By tot.', 8000.00, 1, 16, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(217, 26, 'Jägermeister', 'Herbal liqueur. By tot.', 8000.00, 1, 17, '2026-05-26 09:48:56', '2026-05-26 09:48:56'),
(218, 15, 'Farmers Breakfast', 'Spanish omelette is served with our curried creamy spinach, avocado slice, house gourmet bread, bread, and fresh homemade jam.', 35000.00, 1, 5, '2026-06-20 09:18:43', '2026-06-20 09:18:43'),
(219, 15, 'Ranchers Breakfast', 'Two fried eggs, two beef sausages, beans, beef bacon, grilled tomatoes & fresh avocado.', 35000.00, 1, 6, '2026-06-20 09:23:00', '2026-06-20 09:23:00'),
(220, 15, 'Mist Chicken Nuggets Wrap', 'Homemade tortilla, lettuce, tomatoes, red onion, and chicken nuggets are served with chopped salad, egg of your choice, and baked beans.', 35000.00, 1, 7, '2026-06-20 09:29:17', '2026-06-20 09:29:17'),
(221, 15, 'The Mist Combo Breakfast', 'Potato wedges, Beef, Chicken strips, two eggs ( of your choice), Avocado, chopped salad and one beef sausage, salad, baked beans and sliced bread.', 40000.00, 1, 8, '2026-06-20 09:32:00', '2026-06-20 09:32:00'),
(222, 5, 'Thai Coconute Chicken', 'chicken tender cooked in creamy coconut sauce with tomato, garlic, and spices, served with your choice of accompaniment.', 45000.00, 1, 7, '2026-06-20 09:38:35', '2026-06-20 09:38:35'),
(223, 5, 'Tuscan Chicken', 'chicken breast fillet cooked with spinach, tomato, and garlic in a rich parmesan and cream. Served with rice or accompaniment of your choice', 45000.00, 1, 8, '2026-06-20 09:40:03', '2026-06-20 09:40:03'),
(224, 5, 'BBQ Roasted Chicken', 'roasted chicken fried in bbq sauce, served steamed vegetables and your choice of accompaniment.', 50000.00, 1, 8, '2026-06-20 09:42:59', '2026-06-20 09:42:59'),
(225, 5, 'Sweet & Spicy Chicken', 'Boneless chicken thighs cooked in sweet chilli sauce served with rice and steamed vegetables', 45000.00, 1, 10, '2026-06-20 09:47:00', '2026-06-20 09:47:00'),
(226, 5, 'Red Chicken Curry', 'chicken tender cooked in aromatic curry spices , rich, cooking cream for a smooth, flavorful finish.', 45000.00, 1, 10, '2026-06-20 09:47:01', '2026-06-20 09:50:47'),
(227, 27, 'Carbonara Chicken Pasta', 'Rich creamy sauce with chicken tenders, onions, garlic & parmesan cheese', 55000.00, 1, 3, '2026-06-20 10:01:56', '2026-06-20 10:01:56'),
(228, 27, 'Penne Alfredo Pasta', 'Penne pasta tossed in cream of mushroom sauce, onions, garlic, chicken & parmesan cheese', 45000.00, 1, 4, '2026-06-20 10:03:11', '2026-06-20 10:03:11'),
(229, 27, 'Penne Arabiatta Pasta', 'Pomodoro sauce, egg plant, onions, parsley, bell peppers & parmesan cheese', 45000.00, 1, 5, '2026-06-20 10:04:35', '2026-06-20 10:04:35'),
(230, 27, 'Carbonara Beef Bacon', 'Rich creamy sauce with beef bacon, onions, garlic & parmesan cheese', 50000.00, 1, 6, '2026-06-20 10:06:01', '2026-06-20 10:06:01'),
(231, 27, 'Bolognaise Spaghetti', 'Spaghetti in beef ragout sauce tossed with parmesan cheese', 35000.00, 1, 7, '2026-06-20 10:08:20', '2026-06-20 10:08:20'),
(232, 14, 'Chicken Fajita Pizza', 'Marinated chicken tenders, pomodoro sauce, mixed peppers, cumin, onions, garlic, coriander, mozzarella cheese', 40000.00, 1, 6, '2026-06-20 10:16:52', '2026-06-20 10:16:52'),
(233, 14, 'Veggie Pizza', 'Mushroom, fresh tomatoes, pomodoro mozzarella, kalamata olives, brocolli, basil leaves', 35000.00, 1, 7, '2026-06-20 10:18:35', '2026-06-20 10:18:35'),
(234, 14, 'The Mist Special Pizza', 'Pamodoro sauce, mozzarella & beef bacon, grilled chicken, green chilli, green olives & rocket leaves', 45000.00, 1, 8, '2026-06-20 10:23:50', '2026-06-20 10:23:50'),
(235, 11, 'Chicken Pesto Sandwich', 'grilled chicken breast fillet, mozzarella, tomatoes with pesto sauce', 40000.00, 1, 4, '2026-06-20 10:37:22', '2026-06-20 10:37:22'),
(236, 11, 'BBQ Chicken Sandwich', 'Grilled BBQ chicken, lettuce, tomatoes & crunchy onions', 40000.00, 1, 5, '2026-06-20 10:38:32', '2026-06-20 10:38:32'),
(237, 11, 'The Mist Club Sandwich', 'Chicken tenders, beef bacon, gauda cheese, tomatoes, lettuce, avocado, boiled egg, mayonnaise', 45000.00, 1, 6, '2026-06-20 10:40:09', '2026-06-20 10:40:09'),
(238, 1, 'Ranch Salads', 'Freshly selected mixed lettuce, cherry tomatoes, green apples, red radish, chicken tenders, spring onions, boiled egg, English cucumber, red onions, julienne carrots dressed with ranch dressing & topped with avocado', 40000.00, 1, 7, '2026-06-20 10:46:59', '2026-06-20 10:46:59'),
(239, 1, 'Crispy Chicken Salads', 'crunchy chicken breast, mixed fresh lettuce, beetroots, carrots, red peppers, avocado, honey mustard dressing with garlic-toasted bread', 40000.00, 1, 8, '2026-06-20 10:48:12', '2026-06-20 10:48:12'),
(240, 28, 'Chicken Cheese Sandwich', 'chicken, mayonnaise, and melted cheese layered between slices of toasted bread', 30000.00, 1, 1, '2026-06-20 11:39:05', '2026-06-20 11:39:05'),
(241, 28, 'Tomato Cheese Sandwich', 'combination of fresh tomatoes and mayonnaise', 30000.00, 1, 2, '2026-06-20 11:39:53', '2026-06-20 11:39:53'),
(242, 28, 'Chicken Burger', 'Grilled Chicken Breast Fillet, tomatoes, lettuce and mayonnaise served with chips.', 30000.00, 1, 3, '2026-06-20 11:40:57', '2026-06-20 11:40:57'),
(243, 28, 'Beef Burger', 'Grilled Beef Patty, tomatoes, lettuce and mayonnaise served with chips.', 30000.00, 1, 4, '2026-06-20 11:41:42', '2026-06-20 11:41:42'),
(244, 28, 'Fish Finger', 'Fish Finger', 32000.00, 1, 5, '2026-06-20 11:42:33', '2026-06-20 11:42:33'),
(245, 28, 'Chicken Strips', 'Chicken Strips served with fries.', 32000.00, 1, 6, '2026-06-20 11:43:31', '2026-06-20 11:43:31'),
(246, 28, 'Chips and Sausage', 'Chips with medium-fried sausages', 28000.00, 1, 7, '2026-06-20 11:44:45', '2026-06-20 11:44:45'),
(247, 15, 'Mist Rolex', 'Two eggs omelet, onion, tomato, chili, green pepper, cabbage, fresh coriander with a choice of plain or carrot chapati served with kachumbari.', 30000.00, 1, 8, '2026-06-21 15:15:46', '2026-06-21 15:15:46'),
(248, 7, 'Platter for 2', 'A mixed grill of prime Beef skewers, pork skewers, chicken Gizzards and drumsticks, goat short ribs, masterfully prepared and served with Fries.', 120000.00, 1, 1, '2026-06-21 15:24:38', '2026-06-21 15:24:38'),
(249, 7, 'Platter for 4', 'A mixed grill of prime Beef skewers, pork skewers, chicken Gizzards and drumsticks, goat short ribs, masterfully, Beef Samosas, Vegetable Samosas served with fries', 220000.00, 1, 2, '2026-06-21 15:27:53', '2026-06-21 15:27:53'),
(250, 7, 'Platter for 6', 'A mixed grill of prime Beef skewers, pork skewers, chicken Gizzards and drumsticks, goat short ribs, masterfully, Beef Samosas, Chicken Samosas, Mixed Vegetables and Served with fries', 320000.00, 1, 3, '2026-06-21 15:32:20', '2026-06-21 15:32:20'),
(251, 9, 'Banana Split', 'Delicious medley of assorted ice cream drizzled with chocolate sauce and sandwich between two fine ripe bananas', 30000.00, 1, 3, '2026-06-21 15:58:39', '2026-06-21 15:58:39'),
(252, 7, 'Platter for 1', 'A mixed grill of prime Beef skewer, pork skewer, chicken Gizzards and drumsticks, goat short rib, Vegetable Samosas, masterfully prepared and served with Fries.', 65000.00, 1, 4, '2026-06-21 16:05:13', '2026-06-21 16:05:13'),
(253, 22, 'Sex on the Beach Cocktail', 'A combination of  vodka, peach schnapps, orange juice, and cranberry juice', 35000.00, 1, 24, '2026-07-07 09:19:37', '2026-07-07 09:19:37'),
(254, 29, 'Ug Premium by TOT', NULL, 4000.00, 1, 1, '2026-07-07 09:25:46', '2026-07-07 09:25:46'),
(255, 29, 'Ug Premium by Bottle', NULL, 60000.00, 1, 2, '2026-07-07 09:26:40', '2026-07-07 09:26:40'),
(256, 29, 'Ug Coconut by TOT', NULL, 4000.00, 1, 3, '2026-07-07 09:27:51', '2026-07-07 09:27:51'),
(257, 29, 'Ug Lemon & Ginger By TOT', NULL, 5000.00, 1, 4, '2026-07-07 09:28:58', '2026-07-07 09:28:58'),
(258, 29, 'Ug Lemon & Ginger By Bottle', NULL, 80000.00, 1, 5, '2026-07-07 09:34:24', '2026-07-07 09:34:24'),
(259, 29, 'Gordons Gin 750ml by TOT', NULL, 5000.00, 1, 6, '2026-07-07 09:39:39', '2026-07-07 09:39:39'),
(260, 29, 'Gordons Gin 750ml by Bottle', NULL, 100000.00, 1, 7, '2026-07-07 09:40:29', '2026-07-07 09:40:29'),
(261, 29, 'Gordons Pink By TOT', NULL, 5000.00, 1, 0, '2026-07-07 09:41:32', '2026-07-07 09:41:32'),
(262, 29, 'Gordons Pink By Bottle', NULL, 92000.00, 1, 8, '2026-07-07 09:42:23', '2026-07-07 09:42:23'),
(263, 29, 'Gilbeys 750ml by TOT', NULL, 5000.00, 1, 9, '2026-07-07 09:44:27', '2026-07-07 09:44:27'),
(264, 29, 'Gilbeys Gin 750ml By Bottle', NULL, 100000.00, 1, 10, '2026-07-07 09:45:49', '2026-07-07 09:45:49'),
(265, 29, 'Bombay Sapphire by TOT', NULL, 10000.00, 1, 10, '2026-07-07 09:49:58', '2026-07-07 09:49:58'),
(266, 29, 'Bombay Sapphire by Bottle', NULL, 300000.00, 1, 11, '2026-07-07 09:52:12', '2026-07-07 09:52:12'),
(267, 29, 'Tanqueray Ten By TOT', NULL, 10000.00, 1, 12, '2026-07-07 09:57:13', '2026-07-07 09:57:13'),
(268, 29, 'Tanqueray Ten By Bottle', NULL, 380000.00, 1, 13, '2026-07-07 09:58:54', '2026-07-07 09:58:54'),
(269, 29, 'Tanqueray Sevilla by TOT', NULL, 7000.00, 1, 14, '2026-07-07 10:00:53', '2026-07-07 10:00:53'),
(270, 29, 'Tanqueray Sevilla by Bottle', NULL, 180000.00, 1, 15, '2026-07-07 10:02:14', '2026-07-07 10:02:14'),
(271, 29, 'Hendricks by TOT', NULL, 10000.00, 1, 16, '2026-07-07 10:21:35', '2026-07-07 10:21:35'),
(272, 30, 'Siminoff Vodka 750ml by TOT', NULL, 4000.00, 1, 1, '2026-07-07 10:25:44', '2026-07-07 10:25:44'),
(273, 30, 'Siminoff Vodka 750ml by Bottle', NULL, 70000.00, 1, 2, '2026-07-07 10:27:54', '2026-07-07 10:27:54'),
(274, 30, 'Ketel One by TOT', NULL, 8000.00, 1, 2, '2026-07-07 10:42:34', '2026-07-07 10:42:34'),
(275, 30, 'Trojka Vodka by Bottle', NULL, 180000.00, 1, 3, '2026-07-07 10:46:08', '2026-07-07 10:46:08'),
(276, 30, 'Ciroc Snap Frost by TOT', NULL, 9000.00, 1, 4, '2026-07-07 10:48:44', '2026-07-07 10:48:44'),
(277, 30, 'Ciroc Snap Frost by Bottle', NULL, 280000.00, 1, 5, '2026-07-07 10:50:20', '2026-07-07 10:50:20'),
(278, 30, 'Ciroc Red Berry by TOT', NULL, 9000.00, 1, 6, '2026-07-07 10:51:54', '2026-07-07 10:51:54'),
(279, 30, 'Ciroc Red Berry by Bottle', NULL, 260000.00, 1, 7, '2026-07-07 10:54:14', '2026-07-07 10:54:14'),
(280, 30, 'Ciroc Pineapple', NULL, 9000.00, 1, 8, '2026-07-07 10:55:55', '2026-07-07 10:55:55'),
(281, 30, 'Ciroc Pineapple by TOT', NULL, 9000.00, 1, 9, '2026-07-07 10:56:54', '2026-07-07 10:56:54'),
(282, 30, 'Ciroc Pineapple by Bottle', NULL, 250000.00, 1, 9, '2026-07-07 10:57:45', '2026-07-07 10:57:45'),
(283, 30, 'Ciroc Apple by TOT', NULL, 9000.00, 1, 11, '2026-07-07 10:58:31', '2026-07-07 10:58:31'),
(284, 30, 'Ciroc Apple by Bottle', NULL, 270000.00, 1, 12, '2026-07-07 11:12:18', '2026-07-07 11:12:18'),
(285, 31, 'Captain Morgan gold by TOT', NULL, 5000.00, 1, 1, '2026-07-07 11:16:58', '2026-07-07 11:16:58'),
(286, 31, 'Captain Morgan gold by Bottle', NULL, 70000.00, 1, 3, '2026-07-07 11:20:08', '2026-07-07 11:20:08'),
(287, 31, 'Captain Morgan G. Spiced by TOT', NULL, 7000.00, 1, 4, '2026-07-07 11:21:17', '2026-07-07 11:21:17'),
(288, 31, 'Captain Morgan G. Spiced by Bottle', NULL, 112000.00, 1, 4, '2026-07-07 11:22:29', '2026-07-07 11:22:29'),
(289, 31, 'Captain Morgan dark by TOT', NULL, 7000.00, 1, 5, '2026-07-07 11:23:37', '2026-07-07 11:23:37'),
(290, 31, 'Captain Morgan dark by Bottle', NULL, 112000.00, 1, 6, '2026-07-07 11:24:49', '2026-07-07 11:24:49'),
(291, 31, 'Bacardi White by TOT', NULL, 7000.00, 1, 7, '2026-07-07 11:26:11', '2026-07-07 11:26:11'),
(292, 31, 'Bacardi White by Bottle', NULL, 150000.00, 1, 8, '2026-07-07 11:27:00', '2026-07-07 11:27:00'),
(293, 31, 'Bacardi dark by TOT', NULL, 7000.00, 1, 9, '2026-07-07 11:32:14', '2026-07-07 11:32:14'),
(294, 31, 'Bacardi dark by Bottle', NULL, 150000.00, 1, 10, '2026-07-07 11:33:04', '2026-07-07 11:33:04'),
(295, 31, 'Malibu by TOT', NULL, 6000.00, 1, 11, '2026-07-07 11:33:41', '2026-07-07 11:33:41'),
(296, 31, 'Malibu by Bottle', NULL, 150000.00, 1, 12, '2026-07-07 11:34:36', '2026-07-07 11:34:36'),
(297, 32, 'Olmeca gold by TOT', NULL, 8000.00, 1, 1, '2026-07-07 11:52:02', '2026-07-07 11:52:02'),
(298, 32, 'Olmeca gold by Bottle', NULL, 221000.00, 1, 2, '2026-07-07 11:53:13', '2026-07-07 11:53:13'),
(299, 32, 'Olmeca Silver by TOT', NULL, 8000.00, 1, 3, '2026-07-07 11:54:14', '2026-07-07 11:54:14'),
(300, 32, 'Olmeca Silver by Bottle', NULL, 221000.00, 1, 3, '2026-07-07 11:55:02', '2026-07-07 11:55:02'),
(301, 32, 'Olmeca Dark Chocolate by TOT', NULL, 8000.00, 1, 4, '2026-07-07 12:07:17', '2026-07-07 12:07:17'),
(302, 32, 'Olmeca Dark Chocolate by Bottle', NULL, 165000.00, 1, 5, '2026-07-07 12:09:05', '2026-07-07 12:09:05'),
(303, 32, 'Jose Cuervo Silver by TOT', NULL, 10000.00, 1, 7, '2026-07-07 12:25:06', '2026-07-07 12:25:06'),
(304, 32, 'Jose Cuervo Silver by Bottle', NULL, 240000.00, 1, 8, '2026-07-07 12:26:00', '2026-07-07 12:26:00'),
(305, 32, 'Jose Cuervo gold by TOT', NULL, 10000.00, 1, 9, '2026-07-07 12:26:57', '2026-07-07 12:26:57'),
(306, 32, 'Jose Cuervo gold by Bottle', NULL, 240000.00, 1, 10, '2026-07-07 12:27:56', '2026-07-07 12:27:56'),
(307, 32, 'Sierra Gold by TOT', NULL, 10000.00, 1, 11, '2026-07-07 12:29:05', '2026-07-07 12:29:05'),
(308, 32, 'Sierra Gold by Bottle', NULL, 280000.00, 1, 12, '2026-07-07 12:29:49', '2026-07-07 12:29:49'),
(309, 32, 'Sierra Silver by TOT', NULL, 10000.00, 1, 13, '2026-07-07 12:31:04', '2026-07-07 12:31:04'),
(310, 32, 'Sierra Silver by Bottle', NULL, 280000.00, 1, 14, '2026-07-07 12:31:54', '2026-07-07 12:31:54'),
(311, 32, 'Don Julio Anejo 750ml', NULL, 370000.00, 1, 15, '2026-07-07 12:33:04', '2026-07-07 12:33:04'),
(312, 32, 'Don Julio Blanco 750ml', NULL, 350000.00, 1, 16, '2026-07-07 12:36:16', '2026-07-07 12:36:16'),
(313, 32, 'Don Julio Reposado 750ml', NULL, 370000.00, 1, 17, '2026-07-07 12:39:18', '2026-07-07 12:39:18'),
(314, 32, 'Don Julio 1942', NULL, 1200000.00, 1, 18, '2026-07-07 12:42:48', '2026-07-08 11:52:22'),
(315, 33, 'Glen Fiddich Gran Reserve 21yrs', NULL, 1520000.00, 1, 1, '2026-07-09 14:17:39', '2026-07-09 14:17:39'),
(316, 33, 'Glenkinchie 12yrs 1ltr By TOT', NULL, 12000.00, 1, 2, '2026-07-09 14:20:17', '2026-07-09 14:20:17'),
(317, 33, 'Glenkinchie 12yrs 1ltr By Bottle', NULL, 420000.00, 1, 3, '2026-07-09 14:23:52', '2026-07-09 14:23:52'),
(318, 33, 'Glenkinchie 12yrs 750ml By TOT', NULL, 368000.00, 1, 4, '2026-07-09 14:25:40', '2026-07-09 14:25:40'),
(319, 33, 'Lagavulin 16yrs', NULL, 960000.00, 1, 5, '2026-07-09 14:27:13', '2026-07-09 14:27:13'),
(320, 33, 'Glen Fiddich 18yrs', NULL, 768000.00, 1, 6, '2026-07-09 14:28:34', '2026-07-09 14:28:34'),
(321, 33, 'Rampur', NULL, 550000.00, 1, 7, '2026-07-09 14:29:27', '2026-07-09 14:29:27'),
(322, 33, 'Glen Morangie 14yrs', NULL, 416000.00, 1, 8, '2026-07-09 14:30:51', '2026-07-09 14:30:51'),
(323, 33, 'Glen Morangie 18yrs', NULL, 778000.00, 1, 9, '2026-07-09 14:31:47', '2026-07-09 14:31:47'),
(324, 33, 'Glen Morangie 19yrs', NULL, 885000.00, 1, 10, '2026-07-09 14:32:31', '2026-07-09 14:32:31'),
(325, 34, 'Jonnie Walker green label 15yrs', NULL, 450000.00, 1, 1, '2026-07-09 14:36:21', '2026-07-09 14:36:21'),
(326, 34, 'Black & White by Bottle', NULL, 100000.00, 1, 2, '2026-07-09 14:39:26', '2026-07-09 14:39:26'),
(327, 34, 'Black & White by TOT', NULL, 7000.00, 1, 3, '2026-07-09 14:41:14', '2026-07-09 14:41:14'),
(328, 34, 'Johnnie Walker red label by Bottle', NULL, 130000.00, 1, 4, '2026-07-09 14:43:11', '2026-07-09 14:43:11'),
(329, 34, 'Jonnie Walker red label By TOT', NULL, 6000.00, 1, 5, '2026-07-09 14:44:22', '2026-07-09 14:44:22'),
(330, 34, 'Johnnie Walker black label by Bottle', NULL, 276000.00, 1, 6, '2026-07-09 14:45:31', '2026-07-09 14:45:31'),
(331, 34, 'Johnnie Walker black label by TOT', NULL, 8000.00, 1, 7, '2026-07-09 14:46:34', '2026-07-09 14:46:34'),
(332, 34, 'Johnnie Walker double black by Bottle', NULL, 319000.00, 1, 8, '2026-07-09 14:47:48', '2026-07-09 14:47:48'),
(333, 34, 'Johnnie Walker double black by TOT', NULL, 14000.00, 1, 9, '2026-07-09 14:48:57', '2026-07-09 14:48:57'),
(334, 34, 'Johnnie Walker gold label by Bottle', NULL, 384000.00, 1, 10, '2026-07-09 14:50:14', '2026-07-09 14:50:14'),
(335, 34, 'Johnnie Walker gold label by TOT', NULL, 15000.00, 1, 12, '2026-07-09 14:51:48', '2026-07-09 14:51:48'),
(336, 34, 'Johnnie Walker 18yrs', NULL, 695000.00, 1, 13, '2026-07-09 14:53:11', '2026-07-09 14:53:11'),
(337, 34, 'Chivas Regal 12yrs by Bottle', NULL, 350000.00, 1, 13, '2026-07-09 15:06:12', '2026-07-09 15:06:12'),
(338, 34, 'Chivas Regal 12yrs by TOT', NULL, 12000.00, 1, 14, '2026-07-09 15:07:07', '2026-07-09 15:07:07'),
(339, 34, 'Chivas regal 18yrs 750ml by Bottle', NULL, 550000.00, 1, 14, '2026-07-09 15:10:57', '2026-07-09 15:10:57'),
(340, 34, 'Chivas regal 18yrs 750ml by TOT', NULL, 15000.00, 1, 15, '2026-07-09 15:11:54', '2026-07-09 15:11:54'),
(341, 34, 'Chivas regal 18yrs 1ltr by TOT', NULL, 15000.00, 1, 16, '2026-07-09 15:12:45', '2026-07-09 15:12:45'),
(342, 34, 'Chivas regal 18yrs 1ltr by Bottle', NULL, 666000.00, 1, 17, '2026-07-09 15:13:35', '2026-07-09 15:13:35'),
(343, 34, 'Monkey Shoulder', NULL, 312000.00, 1, 17, '2026-07-09 15:24:34', '2026-07-09 15:24:34'),
(344, 34, 'Johnnie Walker blue label', NULL, 1520000.00, 1, 18, '2026-07-09 15:25:38', '2026-07-09 15:25:38'),
(345, 34, 'Jack Daniels by Bottle', NULL, 220000.00, 1, 19, '2026-07-09 15:26:50', '2026-07-09 15:26:50'),
(346, 34, 'Jack Daniels by TOT', NULL, 10000.00, 1, 20, '2026-07-09 15:27:38', '2026-07-09 15:27:38'),
(347, 34, 'J&B Rare By TOT', NULL, 7000.00, 1, 21, '2026-07-09 15:28:31', '2026-07-09 15:28:31'),
(348, 34, 'J&B Rare By Bottle', NULL, 114000.00, 1, 22, '2026-07-09 15:29:24', '2026-07-09 15:29:24'),
(349, 35, 'Talisker 10yrs by bottle', NULL, 350000.00, 1, 1, '2026-07-09 15:39:46', '2026-07-09 15:39:46'),
(350, 35, 'Singleton 12yrs', NULL, 265000.00, 1, 2, '2026-07-09 15:41:26', '2026-07-09 15:41:26'),
(351, 35, 'Singleton 15yrs', NULL, 450000.00, 1, 3, '2026-07-09 15:42:13', '2026-07-09 15:42:13'),
(352, 35, 'Singleton 18yrs', NULL, 600000.00, 1, 4, '2026-07-09 15:43:03', '2026-07-09 15:43:03'),
(353, 35, 'Cacallan 18yrs', NULL, 2032000.00, 1, 5, '2026-07-09 15:43:59', '2026-07-09 15:43:59'),
(354, 35, 'Macallan double cask 12yrs', NULL, 528000.00, 1, 6, '2026-07-09 15:44:51', '2026-07-09 15:44:51'),
(355, 35, 'Macallan triple cask 12yrs', NULL, 530000.00, 1, 7, '2026-07-09 15:45:33', '2026-07-09 15:45:33'),
(356, 35, 'Macallan 15yrs', NULL, 1024000.00, 1, 8, '2026-07-09 15:46:39', '2026-07-09 15:46:39'),
(357, 35, 'Bunnahabhain 18yrs', NULL, 625000.00, 1, 9, '2026-07-09 15:48:56', '2026-07-09 15:48:56'),
(358, 35, 'Glen Fiddich Vat 01', NULL, 445000.00, 1, 10, '2026-07-09 15:51:05', '2026-07-09 15:51:05'),
(359, 35, 'Glen Fiddich 12yrs', NULL, 460000.00, 1, 11, '2026-07-09 15:52:50', '2026-07-09 15:52:50'),
(360, 35, 'Glen Fiddich 15yrs', NULL, 720000.00, 1, 12, '2026-07-09 15:53:28', '2026-07-09 15:53:28');

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

--
-- 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, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_05_21_140536_create_media_table', 1),
(5, '2026_05_21_141314_create_categories_table', 1),
(6, '2026_05_21_141326_create_menu_items_table', 1),
(7, '2026_07_07_141327_update_price_column_in_menu_items_table', 2);

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

--
-- 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
('BwLEbnP189HlV3MiBIiOsEkmbdnrU4Z2hLZ1LbxE', NULL, '74.7.243.217', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.4; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiemtjaDRFNEo3MkhZSm1pQnF5TjBMSHdvSVg1b2tBWnBpRGNQOVRSZSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vbWVudS50aGVtaXN0aG90ZWwuY29tL21lbnUvZm9vZCI7czo1OiJyb3V0ZSI7czo5OiJtZW51LmZvb2QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1785407634),
('CoW9rHzWtXi4mxTaVFVHb7aIwEn572tcBzYnxoFk', NULL, '146.70.194.220', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid0h5VmFiUWhtWFhOZDRtcnZJU0FyRnhsNmhpRlVuTmlBRG41Wnd4ZCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzg6Imh0dHA6Ly9tZW51LnRoZW1pc3Rob3RlbC5jb20vbWVudS9mb29kIjtzOjU6InJvdXRlIjtzOjk6Im1lbnUuZm9vZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1785374589),
('EmR9lHOQ2CveMs1OIX4RsMBFbOLbBBhdU12vgp4X', NULL, '147.182.227.215', 'Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMG9CUm9nSDY5WHdrQ3kxTE41RUs1cU10Vms5djNGWmFDR2d3VUlRRiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly93d3cubWVudS50aGVtaXN0aG90ZWwuY29tL21lbnUvZm9vZCI7czo1OiJyb3V0ZSI7czo5OiJtZW51LmZvb2QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1785397302),
('TeyOduVRBDLWFvqblxLll94xElr9Ji2LjHGvGkgI', NULL, '147.182.227.215', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYjVkMFgzbHpRWEIwRHl1TGgyZ0g5UGJyQm4zbVJDSDR4SlFZN3VCSyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vd3d3Lm1lbnUudGhlbWlzdGhvdGVsLmNvbS9tZW51L2Zvb2QiO3M6NToicm91dGUiO3M6OToibWVudS5mb29kIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1785397308),
('X0HXrrC24jWHuEgOnv8JL0Ku0To3TmX3xN6pRYL4', NULL, '188.39.109.162', 'uk-nhs-data/0.0 (internal fraud-research)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUkhDdldrWDlUR3FhTmhtWTdRbFB3alZFUWsyanFIRGpmc2FxcHk3YSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzk6Imh0dHBzOi8vbWVudS50aGVtaXN0aG90ZWwuY29tL21lbnUvZm9vZCI7czo1OiJyb3V0ZSI7czo5OiJtZW51LmZvb2QiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1785369152),
('zSClyKIBG4ghhJ8WTivsmpWjg10GaJOr5doDaBNH', NULL, '188.39.109.162', 'uk-nhs-data/0.0 (internal fraud-research)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVHVhamI3V0RTaDBPOXcxSVQ0cnV3UWdZWXBRU01pTUN3akE5dm9qRiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vd3d3Lm1lbnUudGhlbWlzdGhvdGVsLmNvbS9tZW51L2Zvb2QiO3M6NToicm91dGUiO3M6OToibWVudS5mb29kIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1785369193);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`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 `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 `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `media_uuid_unique` (`uuid`),
  ADD KEY `media_model_type_model_id_index` (`model_type`,`model_id`),
  ADD KEY `media_order_column_index` (`order_column`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_category_id_foreign` (`category_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`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`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=361;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;
COMMIT;

