-- Table structure for table `receipt_settings`
CREATE TABLE `receipt_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `show_customer_name` tinyint(1) NOT NULL DEFAULT 0,
  `show_customer_address` tinyint(1) NOT NULL DEFAULT 0,
  `show_table_number` tinyint(1) NOT NULL DEFAULT 0,
  `payment_qr_code` varchar(191) DEFAULT NULL,
  `show_payment_qr_code` tinyint(1) NOT NULL DEFAULT 0,
  `show_waiter` tinyint(1) NOT NULL DEFAULT 0,
  `show_total_guest` tinyint(1) NOT NULL DEFAULT 0,
  `show_restaurant_logo` tinyint(1) NOT NULL DEFAULT 0,
  `show_tax` tinyint(1) NOT NULL DEFAULT 0,
  `show_payment_details` tinyint(1) NOT NULL DEFAULT 1,
  `show_order_type` tinyint(1) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `receipt_settings_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `receipt_settings_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `receipt_settings`
INSERT INTO `receipt_settings` VALUES
('1', '1', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-09-17 05:36:43', '2025-09-17 05:36:43'),
('2', '2', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('3', '3', '0', '0', '0', NULL, '0', '0', '0', '0', '1', '1', '0', '2025-09-20 12:56:44', '2025-09-20 13:01:44'),
('4', '4', '1', '1', '1', NULL, '0', '1', '1', '1', '1', '1', '1', '2025-10-07 15:00:09', '2025-10-18 17:38:44'),
('6', '6', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:03:42', '2025-11-07 13:03:42'),
('7', '7', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:19:58', '2025-11-07 13:19:58'),
('8', '8', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:20:12', '2025-11-07 13:20:12'),
('9', '9', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:20:38', '2025-11-07 13:20:38'),
('10', '10', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:20:52', '2025-11-07 13:20:52'),
('11', '11', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:23:52', '2025-11-07 13:23:52'),
('12', '12', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:25:45', '2025-11-07 13:25:45'),
('13', '13', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:33:59', '2025-11-07 13:33:59'),
('14', '14', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:51:06', '2025-11-07 13:51:06'),
('15', '15', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:52:08', '2025-11-07 13:52:08'),
('16', '16', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 13:53:12', '2025-11-07 13:53:12'),
('17', '17', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:00:41', '2025-11-07 14:00:41'),
('18', '18', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:02:59', '2025-11-07 14:02:59'),
('19', '19', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:08:55', '2025-11-07 14:08:55'),
('20', '20', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:10:53', '2025-11-07 14:10:53'),
('21', '21', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:14:36', '2025-11-07 14:14:36'),
('22', '22', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('23', '23', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('24', '24', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('25', '25', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('26', '26', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('27', '27', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '2025-11-08 10:32:26', '2025-11-08 10:32:26');


-- Table structure for table `recipes`
CREATE TABLE `recipes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `menu_item_id` bigint(20) unsigned DEFAULT NULL,
  `menu_item_variation_id` bigint(20) unsigned DEFAULT NULL,
  `modifier_option_id` bigint(20) unsigned DEFAULT NULL,
  `inventory_item_id` bigint(20) unsigned NOT NULL,
  `quantity` decimal(16,2) NOT NULL DEFAULT 0.00,
  `unit_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `recipes_menu_item_id_foreign` (`menu_item_id`),
  KEY `recipes_inventory_item_id_foreign` (`inventory_item_id`),
  KEY `recipes_unit_id_foreign` (`unit_id`),
  KEY `recipes_menu_item_variation_id_foreign` (`menu_item_variation_id`),
  KEY `recipes_modifier_option_id_foreign` (`modifier_option_id`),
  CONSTRAINT `recipes_inventory_item_id_foreign` FOREIGN KEY (`inventory_item_id`) REFERENCES `inventory_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recipes_menu_item_id_foreign` FOREIGN KEY (`menu_item_id`) REFERENCES `menu_items` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recipes_menu_item_variation_id_foreign` FOREIGN KEY (`menu_item_variation_id`) REFERENCES `menu_item_variations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recipes_modifier_option_id_foreign` FOREIGN KEY (`modifier_option_id`) REFERENCES `modifier_options` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `recipes_unit_id_foreign` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `recipes`
INSERT INTO `recipes` VALUES
('3', '503', '1', NULL, '1', '1.00', '41', '2025-10-18 17:42:32', '2025-10-18 17:42:32'),
('4', '503', '1', NULL, '2', '5.00', '45', '2025-10-18 17:42:32', '2025-10-18 17:42:32'),
('5', '503', '2', NULL, '1', '2.00', '41', '2025-10-18 17:43:01', '2025-10-18 17:43:01'),
('6', '503', '2', NULL, '2', '7.00', '45', '2025-10-18 17:43:01', '2025-10-18 17:43:01'),
('7', '503', '3', NULL, '2', '15.00', '45', '2025-10-18 17:43:27', '2025-10-18 17:43:27'),
('8', '503', '3', NULL, '1', '3.00', '41', '2025-10-18 17:43:27', '2025-10-18 17:43:27');


-- Table structure for table `reservation_settings`
CREATE TABLE `reservation_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `day_of_week` enum('Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday') NOT NULL,
  `time_slot_start` time NOT NULL,
  `time_slot_end` time NOT NULL,
  `time_slot_difference` int(11) NOT NULL,
  `slot_type` enum('Breakfast','Lunch','Dinner') NOT NULL,
  `available` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reservation_settings_branch_id_foreign` (`branch_id`),
  CONSTRAINT `reservation_settings_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `reservation_settings`
INSERT INTO `reservation_settings` VALUES
('1', '1', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('2', '1', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('3', '1', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('4', '1', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('5', '1', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('6', '1', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('7', '1', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('8', '1', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('9', '1', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('10', '1', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('11', '1', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('12', '1', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('13', '1', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('14', '1', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('15', '1', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('16', '1', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('17', '1', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('18', '1', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('19', '1', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('20', '1', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('21', '1', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('22', '2', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('23', '2', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('24', '2', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('25', '2', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('26', '2', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('27', '2', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('28', '2', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('29', '2', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('30', '2', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('31', '2', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('32', '2', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('33', '2', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('34', '2', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('35', '2', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('36', '2', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('37', '2', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('38', '2', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('39', '2', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('40', '2', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('41', '2', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('42', '2', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('43', '1', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('44', '1', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('45', '1', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('46', '1', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('47', '1', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('48', '1', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('49', '1', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('50', '1', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('51', '1', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('52', '1', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('53', '1', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('54', '1', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('55', '1', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('56', '1', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('57', '1', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('58', '1', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('59', '1', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('60', '1', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('61', '1', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('62', '1', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('63', '1', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('64', '3', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('65', '3', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('66', '3', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('67', '3', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('68', '3', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('69', '3', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('70', '3', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('71', '3', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('72', '3', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('73', '3', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('74', '3', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('75', '3', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('76', '3', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('77', '3', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('78', '3', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('79', '3', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('80', '3', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('81', '3', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('82', '3', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('83', '3', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('84', '3', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('85', '4', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('86', '4', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('87', '4', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('88', '4', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('89', '4', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('90', '4', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('91', '4', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('92', '4', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('93', '4', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('94', '4', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('95', '4', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('96', '4', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('97', '4', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('98', '4', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('99', '4', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('100', '4', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('101', '4', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('102', '4', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('103', '4', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('104', '4', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('105', '4', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('106', '5', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('107', '5', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('108', '5', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('109', '5', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('110', '5', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('111', '5', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('112', '5', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('113', '5', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('114', '5', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('115', '5', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('116', '5', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('117', '5', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('118', '5', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('119', '5', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('120', '5', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('121', '5', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('122', '5', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('123', '5', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('124', '5', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('125', '5', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('126', '5', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('484', '23', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('485', '23', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('486', '23', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('487', '23', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('488', '23', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('489', '23', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('490', '23', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('491', '23', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('492', '23', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('493', '23', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('494', '23', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('495', '23', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('496', '23', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('497', '23', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('498', '23', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('499', '23', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('500', '23', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('501', '23', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('502', '23', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('503', '23', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('504', '23', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('505', '24', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('506', '24', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('507', '24', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('508', '24', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('509', '24', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('510', '24', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('511', '24', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('512', '24', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('513', '24', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('514', '24', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('515', '24', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('516', '24', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('517', '24', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('518', '24', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('519', '24', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('520', '24', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('521', '24', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('522', '24', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('523', '24', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('524', '24', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('525', '24', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('526', '25', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('527', '25', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('528', '25', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('529', '25', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('530', '25', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('531', '25', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('532', '25', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('533', '25', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('534', '25', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('535', '25', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('536', '25', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('537', '25', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('538', '25', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('539', '25', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('540', '25', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('541', '25', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('542', '25', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('543', '25', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('544', '25', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('545', '25', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('546', '25', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 14:25:42', '2025-11-07 14:25:42'),
('547', '26', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('548', '26', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('549', '26', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('550', '26', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('551', '26', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('552', '26', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('553', '26', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('554', '26', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('555', '26', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('556', '26', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('557', '26', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('558', '26', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('559', '26', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('560', '26', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('561', '26', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('562', '26', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('563', '26', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('564', '26', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('565', '26', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('566', '26', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('567', '26', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('568', '27', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('569', '27', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('570', '27', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('571', '27', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('572', '27', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('573', '27', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('574', '27', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('575', '27', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('576', '27', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('577', '27', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('578', '27', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('579', '27', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('580', '27', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('581', '27', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('582', '27', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('583', '27', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('584', '27', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('585', '27', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('586', '27', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('587', '27', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('588', '27', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('589', '28', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('590', '28', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('591', '28', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('592', '28', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('593', '28', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('594', '28', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('595', '28', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('596', '28', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('597', '28', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('598', '28', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('599', '28', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('600', '28', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('601', '28', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('602', '28', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('603', '28', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('604', '28', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('605', '28', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('606', '28', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('607', '28', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('608', '28', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27'),
('609', '28', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 10:32:27', '2025-11-08 10:32:27');


-- Table structure for table `reservations`
CREATE TABLE `reservations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `table_id` bigint(20) unsigned DEFAULT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `reservation_date_time` datetime NOT NULL,
  `party_size` int(11) NOT NULL,
  `special_requests` text DEFAULT NULL,
  `reservation_status` enum('Pending','Confirmed','Checked_In','Cancelled','No_Show') NOT NULL DEFAULT 'Confirmed',
  `reservation_slot_type` enum('Breakfast','Lunch','Dinner') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `slot_time_difference` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reservations_table_id_foreign` (`table_id`),
  KEY `reservations_customer_id_foreign` (`customer_id`),
  KEY `reservations_branch_id_foreign` (`branch_id`),
  CONSTRAINT `reservations_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reservations_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `reservations_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `reservations`
INSERT INTO `reservations` VALUES
('1', '5', NULL, '1', '2025-10-19 18:00:00', '4', NULL, 'Confirmed', 'Dinner', '2025-10-18 18:29:22', '2025-10-18 18:29:22', NULL),
('2', '5', NULL, '1', '2025-10-19 08:00:00', '1', NULL, 'Confirmed', 'Breakfast', '2025-10-18 18:57:06', '2025-10-18 18:57:06', NULL),
('3', '5', '8', '1', '2025-10-24 20:00:00', '4', 'Candle Light Dinner', 'Checked_In', 'Dinner', '2025-10-24 15:00:11', '2025-10-24 15:00:44', NULL);


-- Table structure for table `restaurant_charges`
CREATE TABLE `restaurant_charges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `charge_name` varchar(191) NOT NULL,
  `charge_type` enum('percent','fixed') NOT NULL DEFAULT 'fixed',
  `charge_value` decimal(16,2) DEFAULT NULL,
  `order_types` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Supported order types: DineIn, Delivery, PickUp' CHECK (json_valid(`order_types`)),
  `is_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurant_charges_restaurant_id_foreign` (`restaurant_id`),
  KEY `restaurant_charges_charge_name_index` (`charge_name`),
  CONSTRAINT `restaurant_charges_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `restaurant_taxes`
CREATE TABLE `restaurant_taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `tax_id` varchar(191) DEFAULT NULL,
  `tax_name` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurant_taxes_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `restaurant_taxes_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `restaurant_taxes`
INSERT INTO `restaurant_taxes` VALUES
('1', '3', '1234', 'HST', '2025-09-20 13:01:44', '2025-09-20 13:01:44');


-- Table structure for table `role_has_permissions`
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `role_has_permissions`
INSERT INTO `role_has_permissions` VALUES
('1', '2'),
('1', '3'),
('1', '6'),
('1', '7'),
('1', '10'),
('1', '11'),
('1', '14'),
('1', '15'),
('1', '18'),
('1', '19'),
('1', '22'),
('1', '23'),
('1', '26'),
('1', '27'),
('2', '2'),
('2', '3'),
('2', '6'),
('2', '7'),
('2', '10'),
('2', '11'),
('2', '14'),
('2', '15'),
('2', '18'),
('2', '19'),
('2', '22'),
('2', '23'),
('2', '26'),
('2', '27'),
('3', '2'),
('3', '3'),
('3', '6'),
('3', '7'),
('3', '10'),
('3', '11'),
('3', '14'),
('3', '15'),
('3', '18'),
('3', '19'),
('3', '22'),
('3', '23'),
('3', '26'),
('3', '27'),
('4', '2'),
('4', '3'),
('4', '6'),
('4', '7'),
('4', '10'),
('4', '11'),
('4', '14'),
('4', '15'),
('4', '18'),
('4', '19'),
('4', '22'),
('4', '23'),
('4', '26'),
('4', '27'),
('5', '2'),
('5', '3'),
('5', '6'),
('5', '7'),
('5', '10'),
('5', '11'),
('5', '14'),
('5', '15'),
('5', '18'),
('5', '19'),
('5', '22'),
('5', '23'),
('5', '26'),
('5', '27'),
('6', '2'),
('6', '3'),
('6', '6'),
('6', '7'),
('6', '10'),
('6', '11'),
('6', '14'),
('6', '15'),
('6', '18'),
('6', '19'),
('6', '22'),
('6', '23'),
('6', '26'),
('6', '27'),
('7', '2'),
('7', '3'),
('7', '6'),
('7', '7'),
('7', '10'),
('7', '11'),
('7', '14'),
('7', '15'),
('7', '18'),
('7', '19'),
('7', '22'),
('7', '23'),
('7', '26'),
('7', '27'),
('8', '2'),
('8', '3'),
('8', '6'),
('8', '7'),
('8', '10'),
('8', '11'),
('8', '14'),
('8', '15'),
('8', '18'),
('8', '19'),
('8', '22'),
('8', '23'),
('8', '26'),
('8', '27'),
('9', '2'),
('9', '3'),
('9', '6'),
('9', '7'),
('9', '10'),
('9', '11'),
('9', '14'),
('9', '15'),
('9', '18'),
('9', '19'),
('9', '22'),
('9', '23'),
('9', '26'),
('9', '27'),
('10', '2'),
('10', '3'),
('10', '6'),
('10', '7'),
('10', '10'),
('10', '11'),
('10', '14'),
('10', '15'),
('10', '18'),
('10', '19'),
('10', '22'),
('10', '23'),
('10', '26'),
('10', '27'),
('11', '2'),
('11', '3'),
('11', '6'),
('11', '7'),
('11', '10'),
('11', '11'),
('11', '14'),
('11', '15'),
('11', '18'),
('11', '19'),
('11', '22'),
('11', '23'),
('11', '26'),
('11', '27'),
('12', '2'),
('12', '3'),
('12', '6'),
('12', '7'),
('12', '10'),
('12', '11'),
('12', '14'),
('12', '15'),
('12', '18'),
('12', '19'),
('12', '22'),
('12', '23'),
('12', '26'),
('12', '27'),
('13', '2'),
('13', '3'),
('13', '6'),
('13', '7'),
('13', '10'),
('13', '11'),
('13', '14'),
('13', '15'),
('13', '18'),
('13', '19'),
('13', '22'),
('13', '23'),
('13', '26'),
('13', '27'),
('14', '2'),
('14', '3'),
('14', '6'),
('14', '7'),
('14', '10'),
('14', '11'),
('14', '14'),
('14', '15'),
('14', '18'),
('14', '19'),
('14', '22'),
('14', '23'),
('14', '26'),
('14', '27'),
('15', '2'),
('15', '3'),
('15', '6'),
('15', '7'),
('15', '10'),
('15', '11'),
('15', '14'),
('15', '15'),
('15', '18'),
('15', '19'),
('15', '22'),
('15', '23'),
('15', '26'),
('15', '27'),
('16', '2'),
('16', '3'),
('16', '6'),
('16', '7'),
('16', '10'),
('16', '11'),
('16', '14'),
('16', '15'),
('16', '18'),
('16', '19'),
('16', '22'),
('16', '23'),
('16', '26'),
('16', '27'),
('17', '2'),
('17', '3'),
('17', '6'),
('17', '7'),
('17', '10'),
('17', '11'),
('17', '14'),
('17', '15'),
('17', '18'),
('17', '19'),
('17', '22'),
('17', '23'),
('17', '26'),
('17', '27'),
('18', '2'),
('18', '3'),
('18', '6'),
('18', '7'),
('18', '10'),
('18', '11'),
('18', '14'),
('18', '15'),
('18', '18'),
('18', '19'),
('18', '22'),
('18', '23'),
('18', '26'),
('18', '27'),
('19', '2'),
('19', '3'),
('19', '6'),
('19', '7'),
('19', '10'),
('19', '11'),
('19', '14'),
('19', '15'),
('19', '18'),
('19', '19'),
('19', '22'),
('19', '23'),
('19', '26'),
('19', '27'),
('20', '2'),
('20', '3'),
('20', '6'),
('20', '7'),
('20', '10'),
('20', '11'),
('20', '14'),
('20', '15'),
('20', '18'),
('20', '19'),
('20', '22'),
('20', '23'),
('20', '26'),
('20', '27'),
('21', '2'),
('21', '3'),
('21', '6'),
('21', '7'),
('21', '10'),
('21', '11'),
('21', '14'),
('21', '15'),
('21', '18'),
('21', '19'),
('21', '22'),
('21', '23'),
('21', '26'),
('21', '27'),
('22', '2'),
('22', '3'),
('22', '6'),
('22', '7'),
('22', '10'),
('22', '11'),
('22', '14'),
('22', '15'),
('22', '18'),
('22', '19'),
('22', '22'),
('22', '23'),
('22', '26'),
('22', '27'),
('23', '2'),
('23', '3'),
('23', '6'),
('23', '7'),
('23', '10'),
('23', '11'),
('23', '14'),
('23', '15'),
('23', '18'),
('23', '19'),
('23', '22'),
('23', '23'),
('23', '26'),
('23', '27'),
('24', '2'),
('24', '3'),
('24', '6'),
('24', '7'),
('24', '10'),
('24', '11'),
('24', '14'),
('24', '15'),
('24', '18'),
('24', '19'),
('24', '22'),
('24', '23'),
('24', '26'),
('24', '27'),
('25', '2'),
('25', '3'),
('25', '6'),
('25', '7'),
('25', '10'),
('25', '11'),
('25', '14'),
('25', '15'),
('25', '16'),
('25', '17'),
('25', '18'),
('25', '19'),
('25', '22'),
('25', '23'),
('25', '26'),
('25', '27'),
('26', '2'),
('26', '3'),
('26', '6'),
('26', '7'),
('26', '10'),
('26', '11'),
('26', '14'),
('26', '15'),
('26', '18'),
('26', '19'),
('26', '22'),
('26', '23'),
('26', '26'),
('26', '27'),
('27', '2'),
('27', '3'),
('27', '6'),
('27', '7'),
('27', '10'),
('27', '11'),
('27', '14'),
('27', '15'),
('27', '16'),
('27', '17'),
('27', '18'),
('27', '19'),
('27', '22'),
('27', '23'),
('27', '26'),
('27', '27'),
('28', '2'),
('28', '3'),
('28', '6'),
('28', '7'),
('28', '10'),
('28', '11'),
('28', '14'),
('28', '15'),
('28', '16'),
('28', '18'),
('28', '19'),
('28', '22'),
('28', '23'),
('28', '26'),
('28', '27'),
('29', '2'),
('29', '3'),
('29', '6'),
('29', '7'),
('29', '10'),
('29', '11'),
('29', '14'),
('29', '15'),
('29', '18'),
('29', '19'),
('29', '22'),
('29', '23'),
('29', '26'),
('29', '27'),
('30', '2'),
('30', '3'),
('30', '6'),
('30', '7'),
('30', '10'),
('30', '11'),
('30', '14'),
('30', '15'),
('30', '18'),
('30', '19'),
('30', '22'),
('30', '23'),
('30', '26'),
('30', '27'),
('31', '2'),
('31', '3'),
('31', '6'),
('31', '7'),
('31', '10'),
('31', '11'),
('31', '14'),
('31', '15'),
('31', '18'),
('31', '19'),
('31', '22'),
('31', '23'),
('31', '26'),
('31', '27'),
('32', '2'),
('32', '3'),
('32', '6'),
('32', '7'),
('32', '10'),
('32', '11'),
('32', '14'),
('32', '15'),
('32', '18'),
('32', '19'),
('32', '22'),
('32', '23'),
('32', '26'),
('32', '27'),
('33', '2'),
('33', '3'),
('33', '6'),
('33', '7'),
('33', '10'),
('33', '11'),
('33', '14'),
('33', '15'),
('33', '18'),
('33', '19'),
('33', '22'),
('33', '23'),
('33', '26'),
('33', '27'),
('34', '2'),
('34', '3'),
('34', '6'),
('34', '7'),
('34', '10'),
('34', '11'),
('34', '14'),
('34', '15'),
('34', '18'),
('34', '19'),
('34', '22'),
('34', '23'),
('34', '26'),
('34', '27'),
('35', '2'),
('35', '3'),
('35', '6'),
('35', '7'),
('35', '10'),
('35', '11'),
('35', '14'),
('35', '15'),
('35', '18'),
('35', '19'),
('35', '22'),
('35', '23'),
('35', '26'),
('35', '27'),
('36', '2'),
('36', '3'),
('36', '6'),
('36', '7'),
('36', '10'),
('36', '11'),
('36', '14'),
('36', '15'),
('36', '18'),
('36', '19'),
('36', '22'),
('36', '23'),
('36', '26'),
('36', '27'),
('37', '2'),
('37', '3'),
('37', '6'),
('37', '7'),
('37', '10'),
('37', '11'),
('37', '14'),
('37', '15'),
('37', '18'),
('37', '19'),
('37', '22'),
('37', '23'),
('37', '26'),
('37', '27'),
('38', '2'),
('38', '3'),
('38', '6'),
('38', '7'),
('38', '10'),
('38', '11'),
('38', '14'),
('38', '15'),
('38', '18'),
('38', '19'),
('38', '22'),
('38', '23'),
('38', '26'),
('38', '27'),
('39', '2'),
('39', '3'),
('39', '6'),
('39', '7'),
('39', '10'),
('39', '11'),
('39', '14'),
('39', '15'),
('39', '18'),
('39', '19'),
('39', '22'),
('39', '23'),
('39', '26'),
('39', '27'),
('40', '2'),
('40', '3'),
('40', '6'),
('40', '7'),
('40', '10'),
('40', '11'),
('40', '14'),
('40', '15'),
('40', '18'),
('40', '19'),
('40', '22'),
('40', '23'),
('40', '26'),
('40', '27'),
('41', '2'),
('41', '3'),
('41', '6'),
('41', '7'),
('41', '10'),
('41', '11'),
('41', '14'),
('41', '15'),
('41', '18'),
('41', '19'),
('41', '22'),
('41', '23'),
('41', '26'),
('41', '27'),
('42', '2'),
('42', '3'),
('42', '6'),
('42', '7'),
('42', '10'),
('42', '11'),
('42', '14'),
('42', '15'),
('42', '18'),
('42', '19'),
('42', '22'),
('42', '23'),
('42', '26'),
('42', '27'),
('43', '2'),
('43', '3'),
('43', '6'),
('43', '7'),
('43', '10'),
('43', '11'),
('43', '14'),
('43', '15'),
('43', '18'),
('43', '19'),
('43', '22'),
('43', '23'),
('43', '26'),
('43', '27'),
('44', '2'),
('44', '3'),
('44', '6'),
('44', '7'),
('44', '10'),
('44', '11'),
('44', '14'),
('44', '15'),
('44', '18'),
('44', '19'),
('44', '22'),
('44', '23'),
('44', '26'),
('44', '27'),
('45', '2'),
('45', '3'),
('45', '6'),
('45', '7'),
('45', '10'),
('45', '11'),
('45', '14'),
('45', '15'),
('45', '18'),
('45', '19'),
('45', '22'),
('45', '23'),
('45', '26'),
('45', '27'),
('46', '2'),
('46', '3'),
('46', '6'),
('46', '7'),
('46', '10'),
('46', '11'),
('46', '14'),
('46', '15'),
('46', '18'),
('46', '19'),
('46', '22'),
('46', '23'),
('46', '26'),
('46', '27'),
('47', '2'),
('47', '3'),
('47', '6'),
('47', '7'),
('47', '10'),
('47', '11'),
('47', '14'),
('47', '15'),
('47', '18'),
('47', '19'),
('47', '22'),
('47', '23'),
('47', '26'),
('47', '27'),
('48', '2'),
('48', '3'),
('48', '6'),
('48', '7'),
('48', '10'),
('48', '11'),
('48', '14'),
('48', '15'),
('48', '18'),
('48', '19'),
('48', '22'),
('48', '23'),
('48', '26'),
('48', '27'),
('49', '2'),
('49', '3'),
('49', '6'),
('49', '7'),
('49', '10'),
('49', '11'),
('49', '14'),
('49', '15'),
('49', '18'),
('49', '19'),
('49', '22'),
('49', '23'),
('49', '26'),
('49', '27'),
('50', '2'),
('50', '3'),
('50', '6'),
('50', '7'),
('50', '10'),
('50', '11'),
('50', '14'),
('50', '15'),
('50', '18'),
('50', '19'),
('50', '22'),
('50', '23'),
('50', '26'),
('50', '27'),
('51', '2'),
('51', '3'),
('51', '6'),
('51', '7'),
('51', '10'),
('51', '11'),
('51', '14'),
('51', '15'),
('51', '18'),
('51', '19'),
('51', '22'),
('51', '23'),
('51', '26'),
('51', '27'),
('52', '2'),
('52', '3'),
('52', '6'),
('52', '7'),
('52', '10'),
('52', '11'),
('52', '14'),
('52', '15'),
('52', '18'),
('52', '19'),
('52', '22'),
('52', '23'),
('52', '26'),
('52', '27'),
('53', '2'),
('53', '3'),
('53', '6'),
('53', '7'),
('53', '10'),
('53', '11'),
('53', '14'),
('53', '15'),
('53', '18'),
('53', '19'),
('53', '22'),
('53', '23'),
('53', '26'),
('53', '27'),
('54', '2'),
('54', '3'),
('54', '6'),
('54', '7'),
('54', '10'),
('54', '11'),
('54', '14'),
('54', '15'),
('54', '18'),
('54', '19'),
('54', '22'),
('54', '23'),
('54', '26'),
('54', '27'),
('55', '2'),
('55', '3'),
('55', '6'),
('55', '7'),
('55', '10'),
('55', '11'),
('55', '14'),
('55', '15'),
('55', '18'),
('55', '19'),
('55', '22'),
('55', '23'),
('55', '26'),
('55', '27'),
('56', '2'),
('56', '3'),
('56', '6'),
('56', '7'),
('56', '10'),
('56', '11'),
('56', '14'),
('56', '15'),
('56', '18'),
('56', '19'),
('56', '22'),
('56', '23'),
('56', '26'),
('56', '27'),
('57', '2'),
('57', '3'),
('57', '6'),
('57', '7'),
('57', '10'),
('57', '11'),
('57', '14'),
('57', '15'),
('57', '18'),
('57', '19'),
('57', '22'),
('57', '23'),
('57', '26'),
('57', '27'),
('58', '2'),
('58', '3'),
('58', '6'),
('58', '7'),
('58', '10'),
('58', '11'),
('58', '14'),
('58', '15'),
('58', '18'),
('58', '19'),
('58', '22'),
('58', '23'),
('58', '26'),
('58', '27'),
('59', '2'),
('59', '3'),
('59', '6'),
('59', '7'),
('59', '10'),
('59', '11'),
('59', '14'),
('59', '15'),
('59', '18'),
('59', '19'),
('59', '22'),
('59', '23'),
('59', '26'),
('59', '27'),
('60', '2'),
('60', '3'),
('60', '6'),
('60', '7'),
('60', '10'),
('60', '11'),
('60', '14'),
('60', '15'),
('60', '18'),
('60', '19'),
('60', '22'),
('60', '23'),
('60', '26'),
('60', '27'),
('61', '2'),
('61', '3'),
('61', '6'),
('61', '7'),
('61', '10'),
('61', '11'),
('61', '14'),
('61', '15'),
('61', '18'),
('61', '19'),
('61', '22'),
('61', '23'),
('61', '26'),
('61', '27'),
('62', '2'),
('62', '3'),
('62', '6'),
('62', '7'),
('62', '10'),
('62', '11'),
('62', '14'),
('62', '15'),
('62', '18'),
('62', '19'),
('62', '22'),
('62', '23'),
('62', '26'),
('62', '27'),
('63', '2'),
('63', '3'),
('63', '6'),
('63', '7'),
('63', '10'),
('63', '11'),
('63', '14'),
('63', '15'),
('63', '18'),
('63', '19'),
('63', '22'),
('63', '23'),
('63', '26'),
('63', '27'),
('64', '2'),
('64', '3'),
('64', '6'),
('64', '7'),
('64', '10'),
('64', '11'),
('64', '14'),
('64', '15'),
('64', '18'),
('64', '19'),
('64', '22'),
('64', '23'),
('64', '26'),
('64', '27'),
('65', '2'),
('65', '3'),
('65', '6'),
('65', '7'),
('65', '10'),
('65', '11'),
('65', '14'),
('65', '15'),
('65', '18'),
('65', '19'),
('65', '22'),
('65', '23'),
('65', '26'),
('65', '27'),
('66', '2'),
('66', '3'),
('66', '6'),
('66', '7'),
('66', '10'),
('66', '11'),
('66', '14'),
('66', '15'),
('66', '18'),
('66', '19'),
('66', '22'),
('66', '23'),
('66', '26'),
('66', '27'),
('67', '2'),
('67', '3'),
('67', '6'),
('67', '7'),
('67', '10'),
('67', '11'),
('67', '14'),
('67', '15'),
('67', '18'),
('67', '19'),
('67', '22'),
('67', '23'),
('67', '26'),
('67', '27'),
('68', '2'),
('68', '3'),
('68', '6'),
('68', '7'),
('68', '10'),
('68', '11'),
('68', '14'),
('68', '15'),
('68', '18'),
('68', '19'),
('68', '22'),
('68', '23'),
('68', '26'),
('68', '27'),
('69', '2'),
('69', '3'),
('69', '6'),
('69', '7'),
('69', '10'),
('69', '11'),
('69', '14'),
('69', '15'),
('69', '18'),
('69', '19'),
('69', '22'),
('69', '23'),
('69', '26'),
('69', '27'),
('70', '2'),
('70', '3'),
('70', '6'),
('70', '7'),
('70', '10'),
('70', '11'),
('70', '14'),
('70', '15'),
('70', '18'),
('70', '19'),
('70', '22'),
('70', '23'),
('70', '26'),
('70', '27'),
('71', '2'),
('71', '3'),
('71', '6'),
('71', '7'),
('71', '10'),
('71', '11'),
('71', '14'),
('71', '15'),
('71', '18'),
('71', '19'),
('71', '22'),
('71', '23'),
('71', '26'),
('71', '27'),
('72', '2');

INSERT INTO `role_has_permissions` VALUES
('72', '3'),
('72', '6'),
('72', '7'),
('72', '10'),
('72', '11'),
('72', '14'),
('72', '15'),
('72', '18'),
('72', '19'),
('72', '22'),
('72', '23'),
('72', '26'),
('72', '27'),
('73', '2'),
('73', '3'),
('73', '6'),
('73', '7'),
('73', '10'),
('73', '11'),
('73', '14'),
('73', '15'),
('73', '18'),
('73', '19'),
('73', '22'),
('73', '23'),
('73', '26'),
('73', '27'),
('74', '2'),
('74', '3'),
('74', '6'),
('74', '7'),
('74', '10'),
('74', '11'),
('74', '14'),
('74', '15'),
('74', '18'),
('74', '19'),
('74', '22'),
('74', '23'),
('74', '26'),
('74', '27'),
('75', '2'),
('75', '3'),
('75', '6'),
('75', '7'),
('75', '10'),
('75', '11'),
('75', '14'),
('75', '15'),
('75', '18'),
('75', '19'),
('75', '22'),
('75', '23'),
('75', '26'),
('75', '27'),
('76', '2'),
('76', '3'),
('76', '6'),
('76', '7'),
('76', '10'),
('76', '11'),
('76', '14'),
('76', '15'),
('76', '18'),
('76', '19'),
('76', '22'),
('76', '23'),
('76', '26'),
('76', '27'),
('77', '2'),
('77', '3'),
('77', '6'),
('77', '7'),
('77', '10'),
('77', '11'),
('77', '14'),
('77', '15'),
('77', '18'),
('77', '19'),
('77', '22'),
('77', '23'),
('77', '26'),
('77', '27'),
('78', '2'),
('78', '3'),
('78', '6'),
('78', '7'),
('78', '10'),
('78', '11'),
('78', '14'),
('78', '15'),
('78', '18'),
('78', '19'),
('78', '22'),
('78', '23'),
('78', '26'),
('78', '27'),
('79', '2'),
('79', '3'),
('79', '6'),
('79', '7'),
('79', '10'),
('79', '11'),
('79', '14'),
('79', '15'),
('79', '18'),
('79', '19'),
('79', '22'),
('79', '23'),
('79', '26'),
('79', '27'),
('80', '2'),
('80', '3'),
('80', '6'),
('80', '7'),
('80', '10'),
('80', '11'),
('80', '14'),
('80', '15'),
('80', '18'),
('80', '19'),
('80', '22'),
('80', '23'),
('80', '26'),
('80', '27'),
('81', '2'),
('81', '3'),
('81', '6'),
('81', '7'),
('81', '10'),
('81', '11'),
('81', '14'),
('81', '15'),
('81', '18'),
('81', '19'),
('81', '22'),
('81', '23'),
('81', '26'),
('81', '27'),
('82', '2'),
('82', '3'),
('82', '6'),
('82', '7'),
('82', '10'),
('82', '11'),
('82', '14'),
('82', '15'),
('82', '18'),
('82', '19'),
('82', '22'),
('82', '23'),
('82', '26'),
('82', '27'),
('83', '2'),
('83', '3'),
('83', '6'),
('83', '7'),
('83', '10'),
('83', '11'),
('83', '14'),
('83', '15'),
('83', '18'),
('83', '19'),
('83', '22'),
('83', '23'),
('83', '26'),
('83', '27'),
('84', '2'),
('84', '3'),
('84', '6'),
('84', '7'),
('84', '10'),
('84', '11'),
('84', '14'),
('84', '15'),
('84', '18'),
('84', '19'),
('84', '22'),
('84', '23'),
('84', '26'),
('84', '27'),
('85', '2'),
('85', '3'),
('85', '6'),
('85', '7'),
('85', '10'),
('85', '11'),
('85', '14'),
('85', '15'),
('85', '18'),
('85', '19'),
('85', '22'),
('85', '23'),
('85', '26'),
('85', '27'),
('86', '2'),
('86', '3'),
('86', '6'),
('86', '7'),
('86', '10'),
('86', '11'),
('86', '14'),
('86', '15'),
('86', '18'),
('86', '19'),
('86', '22'),
('86', '23'),
('86', '26'),
('86', '27'),
('87', '2'),
('87', '3'),
('87', '6'),
('87', '7'),
('87', '10'),
('87', '11'),
('87', '14'),
('87', '15'),
('87', '18'),
('87', '19'),
('87', '22'),
('87', '23'),
('87', '26'),
('87', '27'),
('88', '2'),
('88', '3'),
('88', '6'),
('88', '7'),
('88', '10'),
('88', '11'),
('88', '14'),
('88', '15'),
('88', '18'),
('88', '19'),
('88', '22'),
('88', '23'),
('88', '26'),
('88', '27'),
('89', '2'),
('89', '3'),
('89', '6'),
('89', '7'),
('89', '10'),
('89', '11'),
('89', '14'),
('89', '15'),
('89', '18'),
('89', '19'),
('89', '22'),
('89', '23'),
('89', '26'),
('89', '27'),
('90', '2'),
('90', '3'),
('90', '6'),
('90', '7'),
('90', '10'),
('90', '11'),
('90', '14'),
('90', '15'),
('90', '18'),
('90', '19'),
('90', '22'),
('90', '23'),
('90', '26'),
('90', '27'),
('91', '2'),
('91', '3'),
('91', '6'),
('91', '7'),
('91', '10'),
('91', '11'),
('91', '14'),
('91', '15'),
('91', '18'),
('91', '19'),
('91', '22'),
('91', '23'),
('91', '26'),
('91', '27');


-- Table structure for table `roles`
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) NOT NULL,
  `display_name` varchar(191) DEFAULT NULL,
  `guard_name` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`),
  KEY `roles_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `roles_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `roles`
INSERT INTO `roles` VALUES
('1', 'Super Admin', 'Super Admin', 'web', '2025-09-17 05:36:43', '2025-09-17 05:36:43', NULL),
('2', 'Admin_1', 'Admin', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('3', 'Branch Head_1', 'Branch Head', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('4', 'Waiter_1', 'Waiter', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('5', 'Chef_1', 'Chef', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('6', 'Admin_2', 'Admin', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('7', 'Branch Head_2', 'Branch Head', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('8', 'Waiter_2', 'Waiter', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('9', 'Chef_2', 'Chef', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('10', 'Admin_3', 'Admin', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('11', 'Branch Head_3', 'Branch Head', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('12', 'Waiter_3', 'Waiter', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('13', 'Chef_3', 'Chef', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('14', 'Admin_4', 'Admin', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('15', 'Branch Head_4', 'Branch Head', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('16', 'Waiter_4', 'Waiter', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('17', 'Chef_4', 'Chef', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('18', 'Admin_6', 'Admin', 'web', '2025-11-07 13:03:43', '2025-11-07 13:03:43', '6'),
('19', 'Branch Head_6', 'Branch Head', 'web', '2025-11-07 13:03:43', '2025-11-07 13:03:43', '6'),
('20', 'Waiter_6', 'Waiter', 'web', '2025-11-07 13:03:43', '2025-11-07 13:03:43', '6'),
('21', 'Chef_6', 'Chef', 'web', '2025-11-07 13:03:43', '2025-11-07 13:03:43', '6'),
('22', 'Admin_26', 'Admin', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('23', 'Branch Head_26', 'Branch Head', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('24', 'Waiter_26', 'Waiter', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('25', 'Chef_26', 'Chef', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('26', 'Admin_27', 'Admin', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('27', 'Branch Head_27', 'Branch Head', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('28', 'Waiter_27', 'Waiter', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('29', 'Chef_27', 'Chef', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27');


-- Table structure for table `sessions`
CREATE TABLE `sessions` (
  `id` varchar(191) 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,
  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;

-- Dumping data for table `sessions`
INSERT INTO `sessions` VALUES
('0rSGj0Ng5xhNnWuB1QHJJPVPmhg92u500MuyvrIt', NULL, '164.90.228.79', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibnplQmV6bFZxVUUzbW5pQzRLWEhIaUoyVktyS0ljVlJlRFRjSTNUdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9hdXRvZGlzY292ZXIuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762626433'),
('1vkyx03p1FK4g1sXsFBGcHrPkQWxuFDarys6DgQs', NULL, '205.210.31.138', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoicG5Cb0RWUWJQQVNpazZEeUdQNjBXVDc5Tk90SkZqY0xlSDFkNzZudiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762630015'),
('6fJFSeUXItcu9rQ4Fh1zslJov1hAsjn4qVuMVlJi', NULL, '178.128.207.138', 'Go-http-client/1.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoib3ptSm01SDRMdGxWWjlSSG10NXllTmRxOUgzR0FtbzZHQnJoNHVWYiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhLz9yZXN0X3JvdXRlPSUyRndwJTJGdjIlMkZ1c2VycyUyRiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762621800'),
('85HTfmhCqSPGnhkJAPK3ifuvtYMfogUopE1kzGAY', NULL, '43.166.1.243', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVXVwZXhhYVFnVGRzZHpueVFBemx4Q0FqdkFzNXVrRUhhdVI4a3llVyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762614315'),
('8SJPJxNmiS38GW4Q4vMUyWjc6FgFQG6UCfJ97NMV', NULL, '43.157.38.131', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQmlSU1ByMUZRMGNDMDZ0T1pQWlVRTXhPcjVUdkF3bjdEbmpTSkowMCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762629634'),
('9DS7axaOHHKXvFpJbY8aeF2s1LQTCKjmd0KqNTCR', NULL, '146.190.63.248', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibTRNMHFnYzNSSkI2a1pMcUpWNUl5TEdMOGI5UFNvMHlBVXdvUUdQRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762622968'),
('9XagrjRqSOI8qLknIr8MqrQoURKKuu3YZMX90F0T', NULL, '146.190.63.248', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWRCd2N2UDFOTGRjZmFKcGNBaklFNmYyWjZ1QUdGZ1U1Zk9UOTByMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EvP3Jlc3Rfcm91dGU9JTJGd3AlMkZ2MiUyRnVzZXJzJTJGIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762622983'),
('A2se2dg5ISAKnPMQO2CbeHDbpJI7SYLcxyYhCkYj', NULL, '164.92.244.132', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUHZacWhzTFUzNWlQM3NuQlBlV2RzTWxFUkxmQm5kVEdVMVBzaUV3ViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHA6Ly9jcGNhbGVuZGFycy5ld2lpZGluZS5jYS8/cmVzdF9yb3V0ZT0lMkZ3cCUyRnYyJTJGdXNlcnMlMkYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762614945'),
('Ax2MhsomBYjXCnWvoCNeW7HFNRXORB2kge0f71Qe', NULL, '178.128.207.138', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNE10c1YyWmF6V0FjWFkzakJDeDU5b2IydTVjU0NMcDhYRUx0TjEyRyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762621753'),
('b2UI01KtEC7686LXDjGoxqLuqdjtz4boHF6b8FYn', NULL, '178.128.207.138', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSWJRNnZhVzdaM1B1b3FvcWhsZEZlZ3lnN0xUU2xBeXFSOU9UeUFBYiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762621714'),
('BWMO1gI9sKIQCsjHavBizKtyWPpGwSfP2Q71oPBb', NULL, '3.146.111.124', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZFZHemFTV1RvckxFZ3RnWm9BWUpvaGFNemhLRXJZNG1GbWY2RWFISyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762608224'),
('byqXiIhH5KUS4O7jbWZK52OwQHk7e6ZQKKLVJd98', NULL, '138.68.144.227', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM0I5SjBsekdoMHFxcWZ1ZHlZRzVqOUNva1Y3QTgzaXZXNHdDYks0QyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762618408'),
('cfHOFUaITlDyMqgvT1olXhjTAYKATgej4OdEKweU', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRW9NMGlnRjB3eVI1MzBYQXEwWWpQRW0xUGRrSzBlWFMxNklkdDM4YSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762610169'),
('e3fUHEhp8dtal0KXP42SmYOtnhz8VidrExGkX2ny', NULL, '206.189.19.19', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUREeXg2TFZPNWZ6NVhXMDhVU1pyUzdkYklob1hpMjZ5NkV4aFFiRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93ZWJkaXNrLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762626575'),
('glaEWJI0kZwsrC6aHJSmuTuv20sYeEBCiRIdqa7Q', NULL, '50.6.228.103', 'python-requests/2.32.5', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaTBUMjZjckY3aGpjY0w2VWlaTm1wN0Q1SlFLc3lrNUFiYjdIbGlKWCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762615949'),
('GzNTLosGUoUH1V6yw18wXDkHUCkFl13i0nC86ss3', NULL, '138.68.144.227', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOGJScTVkZFg0RTlXaUhnTDdycmlBM3RwUElkWXYzWEVWeVRucURMNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762618408'),
('HinYgz54gdkIrYCRYnsaDrKpAG5sMnf3UArrsWrh', NULL, '138.68.144.227', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNFRlcGdNbXdmRzFxUnl4cVdac1V4UWxPYThoUG9nZGFWckZJS3VCZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYS8/cmVzdF9yb3V0ZT0lMkZ3cCUyRnYyJTJGdXNlcnMlMkYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762618432'),
('hLUDNZMzeAI4pyZ291IQWdQrKDV9vjBKirUhlXbB', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib0JHeWlLVjV2MEtmOEV0Q1k1YWF1OWZrc0YxRjFOcndUdzY2WmhyNyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762610407'),
('izlB78iNgiS253jybgXGthSjtebw4GmPZxsuDRPO', NULL, '146.190.63.248', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNzlxTVEyRmh6TUxYa2N1SDl2TkM0ZjJoNDVKaWlIVXZ1NE9xdGFXRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762622967'),
('kEzJiwgAtJjfCY4stGR8RxXBLhtj7DdS3OVYtvIV', NULL, '165.22.211.245', 'Mozilla/5.0 (X11; Linux x86_64; rv:139.0) Gecko/20100101 Firefox/139.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNklrYU9KOTBDQVpnRWh2T2FnN1Zsak4wN2lQalo0cFV0VEZSWDE1MCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly9jcGNvbnRhY3RzLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762618285'),
('KgIREtAja1RTkFI9KXU6qaITtQdGwYpEaoQBVFJP', NULL, '43.133.253.253', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiZlREeTE0dWJ6dVJ5YldNVUpGUnZ4d09yN0VzM09iY2FtV3VXRWdEMCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtpOjA7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM3OiJodHRwczovL2V3aWlkaW5lLmNhL2ZvcmdvdC1yZXN0YXVyYW50Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762628959'),
('KjBCnIIC9JRqziHEYo1nFvwNuKzMPpgYkU7dRsYO', NULL, '206.189.19.19', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWUZpMTVmTGNJeW9oNkIwMzhxTml6Yk9pSDk2N2VteHZtMmQ0cDNIYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjA6Imh0dHA6Ly93ZWJkaXNrLmV3aWlkaW5lLmNhLz9yZXN0X3JvdXRlPSUyRndwJTJGdjIlMkZ1c2VycyUyRiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762626596'),
('KJpOIDjHVrnEoU6cE3DbZLumKnTnxjNq2zMXPadJ', NULL, '3.146.111.124', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMEQyTHUxVU96amVRS0s3cGFhMFZrQXR2Y3hSWU9uOVZYQTBPY2dxayI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762608226'),
('leE312NhkxzRACR7TBu9KxG34cKT5IWkYX3ezuuP', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNHF1RldaemdJNFlDU2ZGank3bVBnNVozcEdpY3FINGoxWTVjbGcxQSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762611337'),
('LrqjBufghXpRfPl0BpCMEcv7k2SvOFxyCf0XM1mo', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTjcySkFweUxuVVVwUU9TQktxRmh3ZFl1UnhaY1k1cnBnY3JsUnNKVyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762611399'),
('mKajz7YyjARJJq8fzR274OcXegiyOAnAlbPy7fTw', NULL, '157.245.36.108', 'Go-http-client/1.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVU1SbXliaUUxTkpNWmNJMWZoUzhGV1Z4SUtZNGNNb0NRUmtOekphSyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Njk6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhLmV3aWlkaW5lLmNhLz9yZXN0X3JvdXRlPSUyRndwJTJGdjIlMkZ1c2VycyUyRiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762615694'),
('nCEVhtBkzqmkhdEqoPvwlyEOD2bTW2Gtaw2G1BgK', NULL, '143.110.213.72', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid2hRZW5acGFGSm14eTh3T255dkFCNW1sM0loaXU0b0pSeGNROTVoVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjA6Imh0dHA6Ly93ZWJtYWlsLmV3aWlkaW5lLmNhLz9yZXN0X3JvdXRlPSUyRndwJTJGdjIlMkZ1c2VycyUyRiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762614929'),
('NRTwSNi6MY3nbomK6K68aYMyTx8uF4lZsCGzwqZU', NULL, '164.92.244.132', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTWZiNEJKMmFaMGdmRDA5Z3B4N1plcXdROThWcXhCOUtDZTRubVgyNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9jcGNhbGVuZGFycy5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762614916'),
('OfN3rLwUycmtM17NZQE62WbgqkbEWzPrbZQQmjAs', NULL, '43.166.134.47', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMTUyNE1qTW9qUGpTVEcxQmJUb0NhQ0N1akJpT25DeVBRWDhBRUx1RiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762631464'),
('On1R8NHRnZHaknlpCTxjBbDxOWaGexEqdpNPVJ9O', NULL, '43.155.140.157', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYjNCa2dZOFl5bU9LcVliQ2lkeExXMVR6TkJ4dkloZFphZnZydlNhMyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762631976'),
('p3CT5MtPrwe9xyEGumBFtGpXxwrsF9SrMyhtJrBU', NULL, '143.110.213.72', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid1h1Rm1zVUlEY29KUkJqZFNCVE5NU29FUWc5dGRQc2R3ZkdMWWJhbCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93ZWJtYWlsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762614916'),
('PsUxULXUTdW5XdsyzdqEroZxG260TFDi3Satkd1f', NULL, '143.110.213.72', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVmJLcHdHRlhtWHo0TmZBS2g3Q040ZXR5blRLSEJCblNmdVdPTzBMNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93ZWJtYWlsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762614916'),
('psXIL4C5WQ4MCOtUJP17HTzbs0xc9J0BKIYqHwYC', NULL, '157.245.36.108', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiU2ZuWEs2ZjBWb1F0QWFpbTRWU3NPRUZnc2laUkg0THlTMmFEYmd0dCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762615666'),
('PvvBl5Egg7I8FovrKbrq8BVMu8wuGvmaOYXp9uf7', NULL, '51.68.236.68', 'Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUXhybVNzOGVRS3k4UzN6a1h6QUI3M3ZPMW1WeGJ4WmwzM1Y5MXR1eCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762609452'),
('PY0tXN1HN2YpBlFippoJ7ftVnHE1iVsgxA0uYuLC', NULL, '3.140.182.19', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUUw5Y2NrSVFITHZsblplaUNqa2R1SHI5bHR0WnN2UWlscVg5MzlPZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHBzOi8vbWFpbC5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762615695'),
('Qc7nBGXlnHHYzgg2smlN2SnTvAWj3dls9XmLMMGY', NULL, '206.189.19.19', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHpHNmVKQWlLSE0xdWU0R1hXYnJzb0V6UFpCM1ZRcTlXcUFYdnZiRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93ZWJkaXNrLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762626574'),
('RC7pYZA0fLRNnQjEULAsUKNcFD1Eqz6PKlqLJXyT', NULL, '198.235.24.17', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTDRiSzZwU2Z3WmxBaGFqU1AyZEQ2TTlPQlVKcURDaVQ3NHhtM0VYdyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762609516'),
('rFq5m8SWm6QVwlJGGTSropyZRIXsLmdvkDPr7zCi', NULL, '121.29.51.28', 'Opera/9.26 (Windows NT 5.1; U; MEGAUPLOAD 2.0; en)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiM3VhU3JXbGl6Y3Rzb0xhblAyTXZBUTF4WVQwQmtiUTNTYTNoalcwWSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762645053'),
('rwUjhtA9pPj1DmJOAmpmuKwgAQdt8ZZzEjkQ2eCh', NULL, '3.252.131.154', 'Pandalytics/2.0 (https://domainsbot.com/pandalytics/)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoibjBXYzJHZldRRWVKU1ZQUGl1MVE3NWszdjEwbUxYUndKcDFhTjRVYiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762643919'),
('sEeq4mPVJAQlK8gS23uQclRRTCKDZozlagVKlYdu', NULL, '164.90.228.79', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWxDOEpYWURFWGhOZFpIVlFMTkYxRXlqempRWlM0N21hR2Q3eUtFViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9hdXRvZGlzY292ZXIuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762626418'),
('T76NDm6b0esrVOdCVi95sAZT2AcbN5czpaDonIgZ', NULL, '43.135.145.117', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiako5VjhEMkVvdTVxQnBqZ1lzb3FQMDVmYmxwT0JDWEt4clpGY3ZsRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHBzOi8vZXdpaWRpbmUuY2EvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762627546'),
('UQBUQabDEGxzYLA0Mv8siWbFQjSGfVH61kITHzop', NULL, '198.235.24.141', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmtRTHhHTkpGQXI4U1RFUkx6U1p0NjVPYmZ5STUwcnpQSm8zTk1rbiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9hdXRvZGlzY292ZXIuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762642407'),
('VnbzChNYNN1VGZvxbP1620JVqOgslc13XFkifpMj', NULL, '43.166.244.192', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQ1dRNlV2YUY5M1VmcmVMUjF6UFRQcmRLejZiVjRVeG5xSUxSOGtFWSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762625486'),
('wsWEcv0Gi4M5AS3tOsYNJxRa959fCv4G2Zcmi9Ag', NULL, '164.92.244.132', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRFNkYXFjc25CTDdFVEo4RW43T2FmYXV1YTRURnBFc2NtdmptRVFFOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9jcGNhbGVuZGFycy5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762614917'),
('WW3idgpiuChYhrrGHtbaflRhWwBnAE4yPHF6f6yx', NULL, '157.245.36.108', 'Mozilla/5.0 (Linux; Android 6.0; HTC One M9 Build/MRA191188) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.1255.98 Mobile Safari/537.3', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSng4UHZrNnNsSVFMSzFhYjhDT2I3Zm9lelZnYWtCQkJiekd2U1lDaSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762615667'),
('ww8d5FSknvYxiZjbvCYgkSySMFOaCUSblyDV5Lb1', NULL, '58.49.233.126', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiM2NqdWZHSGl4T1pJWThNdzZOMnlrODkyelZCOXBaSjVKNzlwV0ZBeSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762635809'),
('xy9tVeEhTOcXFckMwev5ISQB1WuWhgCnvjnXPRC9', NULL, '43.157.172.39', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiY3dYOHg5MXhOam9RZWJGWW1nVFdaWjJiRm9BRnkxMUxEb2NRVUowQiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vZXdpaWRpbmUuY2EvbWFuaWZlc3QuanNvbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762628317'),
('xZZijawaul30fBOwr5Em2beyfIz2zLO5OJtq8XWL', NULL, '43.135.145.117', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiY3BJOTRnYmo1enluVUVqM1Nzakh3YVdxQTRZZ2lBaE9xWU1zMU8wOSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtpOjA7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI2OiJodHRwczovL2V3aWlkaW5lLmNhL3NpZ25pbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1762627548'),
('Y4ouOgPqivfh2FRhLsdxUHfRHgLGQS8IrBFrWGAA', NULL, '49.51.36.179', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiZTJ3dFFpckZhR3VpclNwM3RnaEhxRzd0Y0ZaWFlsQ1pNMTNGZGlVcyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762630530'),
('Ym2cj3jNf1YwNHQBRW9Xd8KxPOtPjCdJuk48mS4x', NULL, '36.111.67.189', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVkwxMEhBVWxJVFIxNGRuNktrNWk2dnV6OXJZSFFpWndqMnBWSU5TcCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1762613897'),
('yvWjwDI0mbdhdZD1VLgcyPdvaXXZssrZJYSPNmQQ', NULL, '164.90.228.79', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQUlRaTVDdG1BVnJKTGpzVzZHOXhwNGZOZ2UzclJrTEdBdjNXZEdXUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHA6Ly9hdXRvZGlzY292ZXIuZXdpaWRpbmUuY2EvP3Jlc3Rfcm91dGU9JTJGd3AlMkZ2MiUyRnVzZXJzJTJGIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1762626469'),
('zBciY2PPo1Owh5KksAJmml5VQkn55wrnwpbl33NJ', '12', '152.59.83.216', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', '[encoded data, 219288 characters]', '1762619944');


-- Table structure for table `sms_notification_settings`
CREATE TABLE `sms_notification_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `type` varchar(191) NOT NULL,
  `send_sms` enum('yes','no') NOT NULL DEFAULT 'no',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sms_notification_settings_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `sms_notification_settings_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sms_notification_settings`
INSERT INTO `sms_notification_settings` VALUES
('1', '6', 'reservation_confirmed', 'no', NULL, NULL),
('2', '6', 'order_bill_sent', 'no', NULL, NULL),
('3', '6', 'send_otp', 'no', NULL, NULL),
('4', '7', 'reservation_confirmed', 'no', NULL, NULL),
('5', '7', 'order_bill_sent', 'no', NULL, NULL),
('6', '7', 'send_otp', 'no', NULL, NULL),
('7', '8', 'reservation_confirmed', 'no', NULL, NULL),
('8', '8', 'order_bill_sent', 'no', NULL, NULL),
('9', '8', 'send_otp', 'no', NULL, NULL),
('10', '9', 'reservation_confirmed', 'no', NULL, NULL),
('11', '9', 'order_bill_sent', 'no', NULL, NULL),
('12', '9', 'send_otp', 'no', NULL, NULL),
('13', '10', 'reservation_confirmed', 'no', NULL, NULL),
('14', '10', 'order_bill_sent', 'no', NULL, NULL),
('15', '10', 'send_otp', 'no', NULL, NULL),
('16', '11', 'reservation_confirmed', 'no', NULL, NULL),
('17', '11', 'order_bill_sent', 'no', NULL, NULL),
('18', '11', 'send_otp', 'no', NULL, NULL),
('19', '12', 'reservation_confirmed', 'no', NULL, NULL),
('20', '12', 'order_bill_sent', 'no', NULL, NULL),
('21', '12', 'send_otp', 'no', NULL, NULL),
('22', '13', 'reservation_confirmed', 'no', NULL, NULL),
('23', '13', 'order_bill_sent', 'no', NULL, NULL),
('24', '13', 'send_otp', 'no', NULL, NULL),
('25', '14', 'reservation_confirmed', 'no', NULL, NULL),
('26', '14', 'order_bill_sent', 'no', NULL, NULL),
('27', '14', 'send_otp', 'no', NULL, NULL),
('28', '15', 'reservation_confirmed', 'no', NULL, NULL),
('29', '15', 'order_bill_sent', 'no', NULL, NULL),
('30', '15', 'send_otp', 'no', NULL, NULL),
('31', '16', 'reservation_confirmed', 'no', NULL, NULL),
('32', '16', 'order_bill_sent', 'no', NULL, NULL),
('33', '16', 'send_otp', 'no', NULL, NULL),
('34', '17', 'reservation_confirmed', 'no', NULL, NULL),
('35', '17', 'order_bill_sent', 'no', NULL, NULL),
('36', '17', 'send_otp', 'no', NULL, NULL),
('37', '18', 'reservation_confirmed', 'no', NULL, NULL),
('38', '18', 'order_bill_sent', 'no', NULL, NULL),
('39', '18', 'send_otp', 'no', NULL, NULL),
('40', '19', 'reservation_confirmed', 'no', NULL, NULL),
('41', '19', 'order_bill_sent', 'no', NULL, NULL),
('42', '19', 'send_otp', 'no', NULL, NULL),
('43', '20', 'reservation_confirmed', 'no', NULL, NULL),
('44', '20', 'order_bill_sent', 'no', NULL, NULL),
('45', '20', 'send_otp', 'no', NULL, NULL),
('46', '21', 'reservation_confirmed', 'no', NULL, NULL),
('47', '21', 'order_bill_sent', 'no', NULL, NULL),
('48', '21', 'send_otp', 'no', NULL, NULL),
('49', '22', 'reservation_confirmed', 'no', NULL, NULL),
('50', '22', 'order_bill_sent', 'no', NULL, NULL),
('51', '22', 'send_otp', 'no', NULL, NULL),
('52', '23', 'reservation_confirmed', 'no', NULL, NULL),
('53', '23', 'order_bill_sent', 'no', NULL, NULL),
('54', '23', 'send_otp', 'no', NULL, NULL),
('55', '24', 'reservation_confirmed', 'no', NULL, NULL),
('56', '24', 'order_bill_sent', 'no', NULL, NULL),
('57', '24', 'send_otp', 'no', NULL, NULL),
('58', '25', 'reservation_confirmed', 'no', NULL, NULL),
('59', '25', 'order_bill_sent', 'no', NULL, NULL),
('60', '25', 'send_otp', 'no', NULL, NULL),
('61', '26', 'reservation_confirmed', 'no', NULL, NULL),
('62', '26', 'order_bill_sent', 'no', NULL, NULL),
('63', '26', 'send_otp', 'no', NULL, NULL),
('64', '27', 'reservation_confirmed', 'no', NULL, NULL),
('65', '27', 'order_bill_sent', 'no', NULL, NULL),
('66', '27', 'send_otp', 'no', NULL, NULL);


-- Table structure for table `sms_templates`
CREATE TABLE `sms_templates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(191) NOT NULL,
  `flow_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sms_templates_type_unique` (`type`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sms_templates`
INSERT INTO `sms_templates` VALUES
('1', 'reservation_confirmed', NULL, '2025-10-25 07:22:09', '2025-10-25 07:22:09'),
('2', 'order_bill_sent', NULL, '2025-10-25 07:22:09', '2025-10-25 07:22:09'),
('3', 'send_otp', NULL, '2025-10-25 07:22:09', '2025-10-25 07:22:09'),
('4', 'send_verify_otp', NULL, '2025-10-25 07:22:09', '2025-10-25 07:22:09');


-- Table structure for table `sms_usage_logs`
CREATE TABLE `sms_usage_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `date` datetime NOT NULL,
  `gateway` enum('vonage','msg91') NOT NULL,
  `type` enum('reservation_confirmed','order_bill_sent','send_otp') NOT NULL,
  `count` int(11) NOT NULL DEFAULT 1,
  `package_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sms_usage_unique` (`restaurant_id`,`branch_id`,`type`,`gateway`,`date`),
  KEY `sms_usage_logs_branch_id_foreign` (`branch_id`),
  KEY `sms_usage_logs_restaurant_id_date_index` (`restaurant_id`,`date`),
  KEY `sms_usage_logs_gateway_type_index` (`gateway`,`type`),
  KEY `sms_usage_logs_date_gateway_index` (`date`,`gateway`),
  KEY `sms_usage_logs_package_id_date_index` (`package_id`,`date`),
  CONSTRAINT `sms_usage_logs_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sms_usage_logs_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sms_usage_logs_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `split_order_items`
CREATE TABLE `split_order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `split_order_id` bigint(20) unsigned NOT NULL,
  `order_item_id` bigint(20) unsigned NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `split_order_items_split_order_id_foreign` (`split_order_id`),
  KEY `split_order_items_order_item_id_foreign` (`order_item_id`),
  CONSTRAINT `split_order_items_order_item_id_foreign` FOREIGN KEY (`order_item_id`) REFERENCES `order_items` (`id`) ON DELETE CASCADE,
  CONSTRAINT `split_order_items_split_order_id_foreign` FOREIGN KEY (`split_order_id`) REFERENCES `split_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `split_orders`
CREATE TABLE `split_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `status` enum('pending','paid') NOT NULL DEFAULT 'pending',
  `payment_method` enum('cash','upi','card','bank_transfer','due','stripe','razorpay') NOT NULL DEFAULT 'cash',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `split_orders_order_id_foreign` (`order_id`),
  CONSTRAINT `split_orders_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `stripe_payments`
CREATE TABLE `stripe_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `payment_date` datetime DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `payment_status` enum('pending','requested','declined','completed') NOT NULL DEFAULT 'pending',
  `payment_error_response` text DEFAULT NULL,
  `stripe_payment_intent` varchar(191) DEFAULT NULL,
  `stripe_session_id` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `stripe_payments_order_id_foreign` (`order_id`),
  CONSTRAINT `stripe_payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `sub_domain_module_settings`
CREATE TABLE `sub_domain_module_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `license_type` varchar(20) DEFAULT NULL,
  `purchase_code` varchar(191) DEFAULT NULL,
  `purchased_on` timestamp NULL DEFAULT NULL,
  `supported_until` timestamp NULL DEFAULT NULL,
  `banned_subdomain` longtext DEFAULT NULL,
  `notify_update` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sub_domain_module_settings`
INSERT INTO `sub_domain_module_settings` VALUES
('1', NULL, NULL, NULL, NULL, '[\"imap\",\"mail\",\"pop\",\"contact\",\"webmail\",\"git\",\"github\",\"api\",\"apis\",\"developer\",\"ticket\",\"tickets\",\"transfer\",\"smtp\",\"stripe\",\"support\",\"bank\",\"helpdesk\",\"pay\",\"paypal\",\"help\",\"payment\",\"payments\",\"invoices\",\"invoice\",\"billing\",\"accounts\",\"account\",\"secure\",\"securelogin\",\"auth\",\"register\",\"authenticate\",\"dev\",\"staging\",\"ftp\",\"svn\",\"mx\",\"ssh\",\"gitlab\",\"signup\",\"signin\",\"login\",\"test\",\"beta\",\"demo\",\"example\",\"localhost\",\"www\",\"www2\",\"ns1\",\"ns2\",\"cpanel\",\"controlpanel\",\"panel\",\"dashboard\",\"server\",\"host\",\"webmaster\",\"owner\",\"superadmin\",\"whm\",\"root\",\"administrator\",\"admin\"]', '1', '2025-09-17 05:48:36', '2025-10-15 14:25:07');


-- Table structure for table `suppliers`
CREATE TABLE `suppliers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `phone` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `suppliers_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `suppliers_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `suppliers`
INSERT INTO `suppliers` VALUES
('1', '4', 'Mario', '1828828282', 'mario@test.com', 'Test', '2025-10-18 00:03:15', '2025-10-18 00:03:15');


-- Table structure for table `taxes`
CREATE TABLE `taxes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned DEFAULT NULL,
  `tax_name` varchar(191) NOT NULL,
  `tax_percent` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `taxes_restaurant_id_foreign` (`restaurant_id`),
  CONSTRAINT `taxes_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `taxes`
INSERT INTO `taxes` VALUES
('1', '1', 'SGST', '2.5', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('2', '1', 'CGST', '2.5', '2025-09-17 05:36:44', '2025-09-17 05:36:44'),
('4', '3', 'GST', '9.975', '2025-09-20 13:02:32', '2025-09-20 13:02:32'),
('5', '3', 'HST', '5', '2025-09-20 13:03:45', '2025-09-20 13:03:45'),
('6', '4', 'CGST', '2.5', '2025-10-07 15:20:58', '2025-10-07 15:20:58'),
('7', '4', 'SGST', '2.5', '2025-10-07 15:21:08', '2025-10-07 15:21:08');


-- Table structure for table `units`
CREATE TABLE `units` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `name` varchar(191) NOT NULL,
  `symbol` varchar(191) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `units_branch_id_foreign` (`branch_id`),
  CONSTRAINT `units_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `units`
INSERT INTO `units` VALUES
('1', '1', 'Kilogram', 'kg', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('2', '1', 'Gram', 'g', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('3', '1', 'Liter', 'L', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('4', '1', 'Milliliter', 'ml', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('5', '1', 'Piece', 'pc', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('6', '1', 'Box', 'box', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('7', '1', 'Dozen', 'dz', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('8', '1', 'Bottle', 'btl', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('9', '1', 'Package', 'pkg', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('10', '1', 'Can', 'can', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('11', '2', 'Kilogram', 'kg', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('12', '2', 'Gram', 'g', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('13', '2', 'Liter', 'L', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('14', '2', 'Milliliter', 'ml', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('15', '2', 'Piece', 'pc', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('16', '2', 'Box', 'box', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('17', '2', 'Dozen', 'dz', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('18', '2', 'Bottle', 'btl', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('19', '2', 'Package', 'pkg', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('20', '2', 'Can', 'can', '2025-09-17 05:48:09', '2025-09-17 05:48:09'),
('21', '3', 'Kilogram', 'kg', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('22', '3', 'Gram', 'g', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('23', '3', 'Liter', 'L', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('24', '3', 'Milliliter', 'ml', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('25', '3', 'Piece', 'pc', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('26', '3', 'Box', 'box', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('27', '3', 'Dozen', 'dz', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('28', '3', 'Bottle', 'btl', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('29', '3', 'Package', 'pkg', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('30', '3', 'Can', 'can', '2025-09-17 10:02:45', '2025-09-17 10:02:45'),
('31', '4', 'Kilogram', 'kg', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('32', '4', 'Gram', 'g', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('33', '4', 'Liter', 'L', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('34', '4', 'Milliliter', 'ml', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('35', '4', 'Piece', 'pc', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('36', '4', 'Box', 'box', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('37', '4', 'Dozen', 'dz', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('38', '4', 'Bottle', 'btl', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('39', '4', 'Package', 'pkg', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('40', '4', 'Can', 'can', '2025-09-20 12:56:44', '2025-09-20 12:56:44'),
('41', '5', 'Kilogram', 'kg', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('42', '5', 'Gram', 'g', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('43', '5', 'Liter', 'L', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('44', '5', 'Milliliter', 'ml', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('45', '5', 'Piece', 'pc', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('46', '5', 'Box', 'box', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('47', '5', 'Dozen', 'dz', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('48', '5', 'Bottle', 'btl', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('49', '5', 'Package', 'pkg', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('50', '5', 'Can', 'can', '2025-10-07 15:00:09', '2025-10-07 15:00:09'),
('221', '23', 'Kilogram', 'kg', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('222', '23', 'Gram', 'g', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('223', '23', 'Liter', 'L', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('224', '23', 'Milliliter', 'ml', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('225', '23', 'Piece', 'pc', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('226', '23', 'Box', 'box', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('227', '23', 'Dozen', 'dz', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('228', '23', 'Bottle', 'btl', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('229', '23', 'Package', 'pkg', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('230', '23', 'Can', 'can', '2025-11-07 14:19:27', '2025-11-07 14:19:27'),
('231', '24', 'Kilogram', 'kg', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('232', '24', 'Gram', 'g', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('233', '24', 'Liter', 'L', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('234', '24', 'Milliliter', 'ml', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('235', '24', 'Piece', 'pc', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('236', '24', 'Box', 'box', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('237', '24', 'Dozen', 'dz', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('238', '24', 'Bottle', 'btl', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('239', '24', 'Package', 'pkg', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('240', '24', 'Can', 'can', '2025-11-07 14:23:35', '2025-11-07 14:23:35'),
('241', '25', 'Kilogram', 'kg', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('242', '25', 'Gram', 'g', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('243', '25', 'Liter', 'L', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('244', '25', 'Milliliter', 'ml', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('245', '25', 'Piece', 'pc', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('246', '25', 'Box', 'box', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('247', '25', 'Dozen', 'dz', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('248', '25', 'Bottle', 'btl', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('249', '25', 'Package', 'pkg', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('250', '25', 'Can', 'can', '2025-11-07 14:25:41', '2025-11-07 14:25:41'),
('251', '26', 'Kilogram', 'kg', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('252', '26', 'Gram', 'g', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('253', '26', 'Liter', 'L', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('254', '26', 'Milliliter', 'ml', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('255', '26', 'Piece', 'pc', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('256', '26', 'Box', 'box', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('257', '26', 'Dozen', 'dz', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('258', '26', 'Bottle', 'btl', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('259', '26', 'Package', 'pkg', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('260', '26', 'Can', 'can', '2025-11-07 17:01:07', '2025-11-07 17:01:07'),
('261', '27', 'Kilogram', 'kg', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('262', '27', 'Gram', 'g', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('263', '27', 'Liter', 'L', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('264', '27', 'Milliliter', 'ml', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('265', '27', 'Piece', 'pc', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('266', '27', 'Box', 'box', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('267', '27', 'Dozen', 'dz', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('268', '27', 'Bottle', 'btl', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('269', '27', 'Package', 'pkg', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('270', '27', 'Can', 'can', '2025-11-07 17:23:03', '2025-11-07 17:23:03'),
('271', '28', 'Kilogram', 'kg', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('272', '28', 'Gram', 'g', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('273', '28', 'Liter', 'L', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('274', '28', 'Milliliter', 'ml', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('275', '28', 'Piece', 'pc', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('276', '28', 'Box', 'box', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('277', '28', 'Dozen', 'dz', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('278', '28', 'Bottle', 'btl', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('279', '28', 'Package', 'pkg', '2025-11-08 10:32:26', '2025-11-08 10:32:26'),
('280', '28', 'Can', 'can', '2025-11-08 10:32:26', '2025-11-08 10:32:26');


-- Table structure for table `universal_bundle_settings`
CREATE TABLE `universal_bundle_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `purchase_code` varchar(191) DEFAULT NULL,
  `supported_until` timestamp NULL DEFAULT NULL,
  `purchased_on` timestamp NULL DEFAULT NULL,
  `license_type` varchar(20) DEFAULT NULL,
  `notify_update` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `universal_bundle_settings`
INSERT INTO `universal_bundle_settings` VALUES
('1', '65100125-205d-420e-b03c-0faa1e6f02b9', '2026-04-16 03:07:13', '2025-10-15 12:07:13', 'Regular License', '1', '2025-10-15 12:15:51', '2025-10-15 12:16:21');


-- Table structure for table `universal_module_installs`
CREATE TABLE `universal_module_installs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module_name` varchar(191) NOT NULL,
  `version` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `universal_module_installs`
INSERT INTO `universal_module_installs` VALUES
('1', 'CashRegister', '1.0.13\n', '2025-10-15 12:16:31', '2025-10-27 08:18:10'),
('2', 'Kiosk', '1.0.3\n', '2025-10-15 12:16:47', '2025-11-04 10:45:24'),
('3', 'LanguagePack', '1.0.64\n', '2025-10-15 12:17:11', '2025-10-30 12:30:44'),
('4', 'Sms', '1.0.0\n', '2025-10-25 07:22:10', '2025-10-25 07:22:10'),
('5', 'Backup', '1.0.0\r\n', '2025-10-25 07:22:10', '2025-10-25 07:22:10'),
('6', 'Inventory', '1.0.63\n', '2025-10-27 08:16:01', '2025-11-04 10:45:14');


-- Table structure for table `waiter_requests`
CREATE TABLE `waiter_requests` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `table_id` bigint(20) unsigned NOT NULL,
  `status` enum('pending','completed') NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `waiter_requests_branch_id_foreign` (`branch_id`),
  KEY `waiter_requests_table_id_foreign` (`table_id`),
  CONSTRAINT `waiter_requests_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiter_requests_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `waiter_requests`
INSERT INTO `waiter_requests` VALUES
('1', '5', '5', 'completed', '2025-10-10 10:45:37', '2025-10-25 07:27:14'),
('2', '5', '5', 'completed', '2025-10-25 07:25:46', '2025-10-25 07:27:14'),
('3', '5', '5', 'completed', '2025-10-25 07:26:11', '2025-10-25 07:27:14'),
('4', '5', '5', 'completed', '2025-10-25 07:26:38', '2025-10-25 07:27:14'),
('5', '5', '7', 'completed', '2025-10-25 07:27:26', '2025-10-25 07:28:40'),
('6', '5', '7', 'pending', '2025-10-27 09:08:51', '2025-10-27 09:08:51');


-- Table structure for table `whatsapp_notification_settings`
CREATE TABLE `whatsapp_notification_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `whatsapp_notification_settings`
INSERT INTO `whatsapp_notification_settings` VALUES
('1', 'order_bill_sent', '🧾 Your Order Bill  – Thank You for Dining with Us!\n\nHello __customer_name__ 👋,\n\nHere are the details of your order:\n\n📦 Order #: __order_number__\n🪑 Order Type: __order_type__\n\n🥤 Items Ordered:\n__items__\n\n💵 Total Amount: __total__\n\n⏰ Order Time: __order_time__\n\nWe hope you will enjoy your meal! 😋\nLooking forward to serving you again.\n— __restaurant_name__ 🍽️\n*Ewii Dine*', '1', '2025-05-21 08:31:46', '2025-10-27 09:20:33'),
('2', 'order_received', 'Hello Admin/Restaurant,\n\nA new order has been placed! 🛒\n\n📦 Order #: __order_number__\n🪑Order Type: __order_type__\n\n👤 Customer: __customer_name__\n\n🥤 Items:\n__items__\n💵Total: __total__\n\n⏰ Time: __order_time__\n🔗View Order: [__view_order_link__]\nPlease start preparing the order 👨‍🍳\n\nThank you!\n\n— __restaurant_name__ 🔥\n*Ewii Dine*', '1', NULL, '2025-10-27 09:20:33'),
('3', 'reservation_confirmed', '📅 Reservation Confirmed!\n\nHello __customer_name__ 👋,\nYour reservation at __restaurant_name__ has been successfully submitted ✅\n\n🧾 Reservation Details:\n👤 Name: __customer_name__\n📆 Date: __date__\n⏰ Time: __time__\n👥 Guests: __guests__\n🔗 View Reservation: [__view_reservation_link__]\n\nWe look forward to hosting you! 🍽️\n\n— __restaurant_name__ 🌟\n*Ewii Dine*', '1', NULL, '2025-10-27 09:20:33'),
('4', 'new_reservation', '📢 New Reservation Received!\n\nHello Restaurant Owner/Staff 👋,\nA new reservation has been made via Tandoor Tech 🧾\n\n📌 Reservation Details:\n👤 Customer Name: __customer_name__\n📆 Date: __date__\n⏰ Time: __time__\n👥 Guests: __guests__\n🔗 View Reservation: [__view_reservation_link__]\n\nPlease make arrangements accordingly 🪑\n\n— __restaurant_name__ 🔥\n*Ewii Dine*', '1', NULL, '2025-10-27 09:20:33'),
('5', 'staff_welcome', '👨‍🍳 Welcome to __restaurant_name__!\n\nHello __staff_name__ 👋,\nYour staff account is all set up and ready to go ✅\n\n🔐 Login Details:\n📧 Email: __login_email__\n🔑 Password: __password__\n🔗 Click to Login: [__login_link__]\n\nOr open: __login_url__\n\nWe\'re excited to have you on board! Let’s create amazing dining experiences together 🍽️🔥\n\n— Team __restaurant_name__ 🌟\n*Ewii Dine*', '1', NULL, '2025-10-27 09:20:33');


-- Table structure for table `xendit_payments`
CREATE TABLE `xendit_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `payment_date` datetime DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT NULL,
  `payment_status` enum('pending','requested','declined','completed') NOT NULL DEFAULT 'pending',
  `payment_error_response` text DEFAULT NULL,
  `xendit_payment_id` varchar(191) DEFAULT NULL,
  `xendit_invoice_id` varchar(191) DEFAULT NULL,
  `xendit_external_id` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `xendit_payments_order_id_foreign` (`order_id`),
  CONSTRAINT `xendit_payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

