-- 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=652 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'),
('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'),
('610', '29', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('611', '29', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('612', '29', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('613', '29', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('614', '29', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('615', '29', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('616', '29', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('617', '29', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('618', '29', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('619', '29', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('620', '29', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('621', '29', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('622', '29', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('623', '29', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('624', '29', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('625', '29', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('626', '29', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('627', '29', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('628', '29', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('629', '29', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('630', '29', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 14:15:51', '2025-11-12 14:15:51'),
('631', '30', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('632', '30', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('633', '30', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('634', '30', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('635', '30', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('636', '30', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('637', '30', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('638', '30', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('639', '30', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('640', '30', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('641', '30', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('642', '30', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('643', '30', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('644', '30', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('645', '30', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('646', '30', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('647', '30', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('648', '30', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('649', '30', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('650', '30', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44'),
('651', '30', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 15:41:44', '2025-11-13 15:41:44');


-- 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', '22'),
('1', '23'),
('1', '26'),
('1', '27'),
('1', '30'),
('1', '31'),
('1', '34'),
('1', '35'),
('2', '2'),
('2', '3'),
('2', '6'),
('2', '7'),
('2', '10'),
('2', '11'),
('2', '14'),
('2', '15'),
('2', '22'),
('2', '23'),
('2', '26'),
('2', '27'),
('2', '30'),
('2', '31'),
('2', '34'),
('2', '35'),
('3', '2'),
('3', '3'),
('3', '6'),
('3', '7'),
('3', '10'),
('3', '11'),
('3', '14'),
('3', '15'),
('3', '22'),
('3', '23'),
('3', '26'),
('3', '27'),
('3', '30'),
('3', '31'),
('3', '34'),
('3', '35'),
('4', '2'),
('4', '3'),
('4', '6'),
('4', '7'),
('4', '10'),
('4', '11'),
('4', '14'),
('4', '15'),
('4', '22'),
('4', '23'),
('4', '26'),
('4', '27'),
('4', '30'),
('4', '31'),
('4', '34'),
('4', '35'),
('5', '2'),
('5', '3'),
('5', '6'),
('5', '7'),
('5', '10'),
('5', '11'),
('5', '14'),
('5', '15'),
('5', '22'),
('5', '23'),
('5', '26'),
('5', '27'),
('5', '30'),
('5', '31'),
('5', '34'),
('5', '35'),
('6', '2'),
('6', '3'),
('6', '6'),
('6', '7'),
('6', '10'),
('6', '11'),
('6', '14'),
('6', '15'),
('6', '22'),
('6', '23'),
('6', '26'),
('6', '27'),
('6', '30'),
('6', '31'),
('6', '34'),
('6', '35'),
('7', '2'),
('7', '3'),
('7', '6'),
('7', '7'),
('7', '10'),
('7', '11'),
('7', '14'),
('7', '15'),
('7', '22'),
('7', '23'),
('7', '26'),
('7', '27'),
('7', '30'),
('7', '31'),
('7', '34'),
('7', '35'),
('8', '2'),
('8', '3'),
('8', '6'),
('8', '7'),
('8', '10'),
('8', '11'),
('8', '14'),
('8', '15'),
('8', '22'),
('8', '23'),
('8', '26'),
('8', '27'),
('8', '30'),
('8', '31'),
('8', '34'),
('8', '35'),
('9', '2'),
('9', '3'),
('9', '6'),
('9', '7'),
('9', '10'),
('9', '11'),
('9', '14'),
('9', '15'),
('9', '22'),
('9', '23'),
('9', '26'),
('9', '27'),
('9', '30'),
('9', '31'),
('9', '34'),
('9', '35'),
('10', '2'),
('10', '3'),
('10', '6'),
('10', '7'),
('10', '10'),
('10', '11'),
('10', '14'),
('10', '15'),
('10', '22'),
('10', '23'),
('10', '26'),
('10', '27'),
('10', '30'),
('10', '31'),
('10', '34'),
('10', '35'),
('11', '2'),
('11', '3'),
('11', '6'),
('11', '7'),
('11', '10'),
('11', '11'),
('11', '14'),
('11', '15'),
('11', '22'),
('11', '23'),
('11', '26'),
('11', '27'),
('11', '30'),
('11', '31'),
('11', '34'),
('11', '35'),
('12', '2'),
('12', '3'),
('12', '6'),
('12', '7'),
('12', '10'),
('12', '11'),
('12', '14'),
('12', '15'),
('12', '22'),
('12', '23'),
('12', '26'),
('12', '27'),
('12', '30'),
('12', '31'),
('12', '34'),
('12', '35'),
('13', '2'),
('13', '3'),
('13', '6'),
('13', '7'),
('13', '10'),
('13', '11'),
('13', '14'),
('13', '15'),
('13', '22'),
('13', '23'),
('13', '26'),
('13', '27'),
('13', '30'),
('13', '31'),
('13', '34'),
('13', '35'),
('14', '2'),
('14', '3'),
('14', '6'),
('14', '7'),
('14', '10'),
('14', '11'),
('14', '14'),
('14', '15'),
('14', '22'),
('14', '23'),
('14', '26'),
('14', '27'),
('14', '30'),
('14', '31'),
('14', '34'),
('14', '35'),
('15', '2'),
('15', '3'),
('15', '6'),
('15', '7'),
('15', '10'),
('15', '11'),
('15', '14'),
('15', '15'),
('15', '22'),
('15', '23'),
('15', '26'),
('15', '27'),
('15', '30'),
('15', '31'),
('15', '34'),
('15', '35'),
('16', '2'),
('16', '3'),
('16', '6'),
('16', '7'),
('16', '10'),
('16', '11'),
('16', '14'),
('16', '15'),
('16', '22'),
('16', '23'),
('16', '26'),
('16', '27'),
('16', '30'),
('16', '31'),
('16', '34'),
('16', '35'),
('17', '2'),
('17', '3'),
('17', '6'),
('17', '7'),
('17', '10'),
('17', '11'),
('17', '14'),
('17', '15'),
('17', '22'),
('17', '23'),
('17', '26'),
('17', '27'),
('17', '30'),
('17', '31'),
('17', '34'),
('17', '35'),
('18', '2'),
('18', '3'),
('18', '6'),
('18', '7'),
('18', '10'),
('18', '11'),
('18', '14'),
('18', '15'),
('18', '22'),
('18', '23'),
('18', '26'),
('18', '27'),
('18', '30'),
('18', '31'),
('18', '34'),
('18', '35'),
('19', '2'),
('19', '3'),
('19', '6'),
('19', '7'),
('19', '10'),
('19', '11'),
('19', '14'),
('19', '15'),
('19', '22'),
('19', '23'),
('19', '26'),
('19', '27'),
('19', '30'),
('19', '31'),
('19', '34'),
('19', '35'),
('20', '2'),
('20', '3'),
('20', '6'),
('20', '7'),
('20', '10'),
('20', '11'),
('20', '14'),
('20', '15'),
('20', '22'),
('20', '23'),
('20', '26'),
('20', '27'),
('20', '30'),
('20', '31'),
('20', '34'),
('20', '35'),
('21', '2'),
('21', '3'),
('21', '6'),
('21', '7'),
('21', '10'),
('21', '11'),
('21', '14'),
('21', '15'),
('21', '22'),
('21', '23'),
('21', '26'),
('21', '27'),
('21', '30'),
('21', '31'),
('21', '34'),
('21', '35'),
('22', '2'),
('22', '3'),
('22', '6'),
('22', '7'),
('22', '10'),
('22', '11'),
('22', '14'),
('22', '15'),
('22', '22'),
('22', '23'),
('22', '26'),
('22', '27'),
('22', '30'),
('22', '31'),
('22', '34'),
('22', '35'),
('23', '2'),
('23', '3'),
('23', '6'),
('23', '7'),
('23', '10'),
('23', '11'),
('23', '14'),
('23', '15'),
('23', '22'),
('23', '23'),
('23', '26'),
('23', '27'),
('23', '30'),
('23', '31'),
('23', '34'),
('23', '35'),
('24', '2'),
('24', '3'),
('24', '6'),
('24', '7'),
('24', '10'),
('24', '11'),
('24', '14'),
('24', '15'),
('24', '22'),
('24', '23'),
('24', '26'),
('24', '27'),
('24', '30'),
('24', '31'),
('24', '34'),
('24', '35'),
('25', '2'),
('25', '3'),
('25', '6'),
('25', '7'),
('25', '10'),
('25', '11'),
('25', '14'),
('25', '15'),
('25', '16'),
('25', '17'),
('25', '22'),
('25', '23'),
('25', '26'),
('25', '27'),
('25', '30'),
('25', '31'),
('25', '34'),
('25', '35'),
('26', '2'),
('26', '3'),
('26', '6'),
('26', '7'),
('26', '10'),
('26', '11'),
('26', '14'),
('26', '15'),
('26', '22'),
('26', '23'),
('26', '26'),
('26', '27'),
('26', '30'),
('26', '31'),
('26', '34'),
('26', '35'),
('27', '2'),
('27', '3'),
('27', '6'),
('27', '7'),
('27', '10'),
('27', '11'),
('27', '14'),
('27', '15'),
('27', '16'),
('27', '17'),
('27', '22'),
('27', '23'),
('27', '26'),
('27', '27'),
('27', '30'),
('27', '31'),
('27', '34'),
('27', '35'),
('28', '2'),
('28', '3'),
('28', '6'),
('28', '7'),
('28', '10'),
('28', '11'),
('28', '14'),
('28', '15'),
('28', '16'),
('28', '22'),
('28', '23'),
('28', '26'),
('28', '27'),
('28', '30'),
('28', '31'),
('28', '34'),
('28', '35'),
('29', '2'),
('29', '3'),
('29', '6'),
('29', '7'),
('29', '10'),
('29', '11'),
('29', '14'),
('29', '15'),
('29', '22'),
('29', '23'),
('29', '26'),
('29', '27'),
('29', '30'),
('29', '31'),
('29', '34'),
('29', '35'),
('30', '2'),
('30', '3'),
('30', '6'),
('30', '7'),
('30', '10'),
('30', '11'),
('30', '14'),
('30', '15'),
('30', '22'),
('30', '23'),
('30', '26'),
('30', '27'),
('30', '30'),
('30', '31'),
('30', '34'),
('30', '35'),
('31', '2'),
('31', '3'),
('31', '6'),
('31', '7'),
('31', '10'),
('31', '11'),
('31', '14'),
('31', '15'),
('31', '22'),
('31', '23'),
('31', '26'),
('31', '27'),
('31', '30'),
('31', '31'),
('31', '34'),
('31', '35'),
('32', '2'),
('32', '3'),
('32', '6'),
('32', '7'),
('32', '10'),
('32', '11'),
('32', '14'),
('32', '15'),
('32', '22'),
('32', '23'),
('32', '26'),
('32', '27'),
('32', '30'),
('32', '31'),
('32', '34'),
('32', '35'),
('33', '2'),
('33', '3'),
('33', '6'),
('33', '7'),
('33', '10'),
('33', '11'),
('33', '14'),
('33', '15'),
('33', '22'),
('33', '23'),
('33', '26'),
('33', '27'),
('33', '30'),
('33', '31'),
('33', '34'),
('33', '35'),
('34', '2'),
('34', '3'),
('34', '6'),
('34', '7'),
('34', '10'),
('34', '11'),
('34', '14'),
('34', '15'),
('34', '22'),
('34', '23'),
('34', '26'),
('34', '27'),
('34', '30'),
('34', '31'),
('34', '34'),
('34', '35'),
('35', '2'),
('35', '3'),
('35', '6'),
('35', '7'),
('35', '10'),
('35', '11'),
('35', '14'),
('35', '15'),
('35', '22'),
('35', '23'),
('35', '26'),
('35', '27'),
('35', '30'),
('35', '31'),
('35', '34'),
('35', '35'),
('36', '2'),
('36', '3'),
('36', '6'),
('36', '7'),
('36', '10'),
('36', '11'),
('36', '14'),
('36', '15'),
('36', '22'),
('36', '23'),
('36', '26'),
('36', '27'),
('36', '30'),
('36', '31'),
('36', '34'),
('36', '35'),
('37', '2'),
('37', '3'),
('37', '6'),
('37', '7'),
('37', '10'),
('37', '11'),
('37', '14'),
('37', '15'),
('37', '22'),
('37', '23'),
('37', '26'),
('37', '27'),
('37', '30'),
('37', '31'),
('37', '34'),
('37', '35'),
('38', '2'),
('38', '3'),
('38', '6'),
('38', '7'),
('38', '10'),
('38', '11'),
('38', '14'),
('38', '15'),
('38', '22'),
('38', '23'),
('38', '26'),
('38', '27'),
('38', '30'),
('38', '31'),
('38', '34'),
('38', '35'),
('39', '2'),
('39', '3'),
('39', '6'),
('39', '7'),
('39', '10'),
('39', '11'),
('39', '14'),
('39', '15'),
('39', '22'),
('39', '23'),
('39', '26'),
('39', '27'),
('39', '30'),
('39', '31'),
('39', '34'),
('39', '35'),
('40', '2'),
('40', '3'),
('40', '6'),
('40', '7'),
('40', '10'),
('40', '11'),
('40', '14'),
('40', '15'),
('40', '22'),
('40', '23'),
('40', '26'),
('40', '27'),
('40', '30'),
('40', '31'),
('40', '34'),
('40', '35'),
('41', '2'),
('41', '3'),
('41', '6'),
('41', '7'),
('41', '10'),
('41', '11'),
('41', '14'),
('41', '15'),
('41', '22'),
('41', '23'),
('41', '26'),
('41', '27'),
('41', '30'),
('41', '31'),
('41', '34'),
('41', '35'),
('42', '2'),
('42', '3'),
('42', '6'),
('42', '7'),
('42', '10'),
('42', '11'),
('42', '14'),
('42', '15'),
('42', '22'),
('42', '23'),
('42', '26'),
('42', '27'),
('42', '30'),
('42', '31'),
('42', '34'),
('42', '35'),
('43', '2'),
('43', '3'),
('43', '6'),
('43', '7'),
('43', '10'),
('43', '11'),
('43', '14'),
('43', '15'),
('43', '22'),
('43', '23'),
('43', '26'),
('43', '27'),
('43', '30'),
('43', '31'),
('43', '34'),
('43', '35'),
('44', '2'),
('44', '3'),
('44', '6'),
('44', '7'),
('44', '10'),
('44', '11'),
('44', '14'),
('44', '15'),
('44', '22'),
('44', '23'),
('44', '26'),
('44', '27'),
('44', '30'),
('44', '31'),
('44', '34'),
('44', '35'),
('45', '2'),
('45', '3'),
('45', '6'),
('45', '7'),
('45', '10'),
('45', '11'),
('45', '14'),
('45', '15'),
('45', '22'),
('45', '23'),
('45', '26'),
('45', '27'),
('45', '30'),
('45', '31'),
('45', '34'),
('45', '35'),
('46', '2'),
('46', '3'),
('46', '6'),
('46', '7'),
('46', '10'),
('46', '11'),
('46', '14'),
('46', '15'),
('46', '22'),
('46', '23'),
('46', '26'),
('46', '27'),
('46', '30'),
('46', '31'),
('46', '34'),
('46', '35'),
('47', '2'),
('47', '3'),
('47', '6'),
('47', '7'),
('47', '10'),
('47', '11'),
('47', '14'),
('47', '15'),
('47', '22'),
('47', '23'),
('47', '26'),
('47', '27'),
('47', '30'),
('47', '31'),
('47', '34'),
('47', '35'),
('48', '2'),
('48', '3'),
('48', '6'),
('48', '7'),
('48', '10'),
('48', '11'),
('48', '14'),
('48', '15'),
('48', '22'),
('48', '23'),
('48', '26'),
('48', '27'),
('48', '30'),
('48', '31'),
('48', '34'),
('48', '35'),
('49', '2'),
('49', '3'),
('49', '6'),
('49', '7'),
('49', '10'),
('49', '11'),
('49', '14'),
('49', '15'),
('49', '22'),
('49', '23'),
('49', '26'),
('49', '27'),
('49', '30'),
('49', '31'),
('49', '34'),
('49', '35'),
('50', '2'),
('50', '3'),
('50', '6'),
('50', '7'),
('50', '10'),
('50', '11'),
('50', '14'),
('50', '15'),
('50', '22'),
('50', '23'),
('50', '26'),
('50', '27'),
('50', '30'),
('50', '31'),
('50', '34'),
('50', '35'),
('51', '2'),
('51', '3'),
('51', '6'),
('51', '7'),
('51', '10'),
('51', '11'),
('51', '14'),
('51', '15'),
('51', '22'),
('51', '23'),
('51', '26'),
('51', '27'),
('51', '30'),
('51', '31'),
('51', '34'),
('51', '35'),
('52', '2'),
('52', '3'),
('52', '6'),
('52', '7'),
('52', '10'),
('52', '11'),
('52', '14'),
('52', '15'),
('52', '22'),
('52', '23'),
('52', '26'),
('52', '27'),
('52', '30'),
('52', '31'),
('52', '34'),
('52', '35'),
('53', '2'),
('53', '3'),
('53', '6'),
('53', '7'),
('53', '10'),
('53', '11'),
('53', '14'),
('53', '15'),
('53', '22'),
('53', '23'),
('53', '26'),
('53', '27'),
('53', '30'),
('53', '31'),
('53', '34'),
('53', '35'),
('54', '2'),
('54', '3'),
('54', '6'),
('54', '7'),
('54', '10'),
('54', '11'),
('54', '14'),
('54', '15'),
('54', '22'),
('54', '23'),
('54', '26'),
('54', '27'),
('54', '30'),
('54', '31'),
('54', '34'),
('54', '35'),
('55', '2'),
('55', '3'),
('55', '6'),
('55', '7'),
('55', '10'),
('55', '11'),
('55', '14'),
('55', '15'),
('55', '22'),
('55', '23'),
('55', '26'),
('55', '27'),
('55', '30'),
('55', '31'),
('55', '34'),
('55', '35'),
('56', '2'),
('56', '3'),
('56', '6'),
('56', '7'),
('56', '10'),
('56', '11'),
('56', '14'),
('56', '15'),
('56', '22'),
('56', '23'),
('56', '26'),
('56', '27'),
('56', '30'),
('56', '31'),
('56', '34'),
('56', '35'),
('57', '2'),
('57', '3'),
('57', '6'),
('57', '7'),
('57', '10'),
('57', '11'),
('57', '14'),
('57', '15'),
('57', '22'),
('57', '23'),
('57', '26'),
('57', '27'),
('57', '30'),
('57', '31'),
('57', '34'),
('57', '35'),
('58', '2'),
('58', '3'),
('58', '6'),
('58', '7'),
('58', '10'),
('58', '11'),
('58', '14'),
('58', '15'),
('58', '22'),
('58', '23'),
('58', '26'),
('58', '27'),
('58', '30'),
('58', '31'),
('58', '34'),
('58', '35'),
('59', '2'),
('59', '3'),
('59', '6'),
('59', '7'),
('59', '10'),
('59', '11'),
('59', '14'),
('59', '15'),
('59', '22'),
('59', '23'),
('59', '26'),
('59', '27'),
('59', '30'),
('59', '31'),
('59', '34'),
('59', '35'),
('60', '2'),
('60', '3'),
('60', '6'),
('60', '7'),
('60', '10'),
('60', '11'),
('60', '14'),
('60', '15'),
('60', '22'),
('60', '23'),
('60', '26'),
('60', '27'),
('60', '30'),
('60', '31'),
('60', '34'),
('60', '35'),
('61', '2'),
('61', '3'),
('61', '6'),
('61', '7'),
('61', '10'),
('61', '11'),
('61', '14'),
('61', '15'),
('61', '22'),
('61', '23'),
('61', '26'),
('61', '27'),
('61', '30'),
('61', '31'),
('61', '34'),
('61', '35'),
('62', '2'),
('62', '3'),
('62', '6'),
('62', '7'),
('62', '10'),
('62', '11'),
('62', '14'),
('62', '15'),
('62', '22'),
('62', '23'),
('62', '26'),
('62', '27'),
('62', '30'),
('62', '31'),
('62', '34'),
('62', '35'),
('63', '2'),
('63', '3'),
('63', '6');

INSERT INTO `role_has_permissions` VALUES
('63', '7'),
('63', '10'),
('63', '11'),
('63', '14'),
('63', '15'),
('63', '22'),
('63', '23'),
('63', '26'),
('63', '27'),
('63', '30'),
('63', '31'),
('63', '34'),
('63', '35'),
('64', '2'),
('64', '3'),
('64', '6'),
('64', '7'),
('64', '10'),
('64', '11'),
('64', '14'),
('64', '15'),
('64', '22'),
('64', '23'),
('64', '26'),
('64', '27'),
('64', '30'),
('64', '31'),
('64', '34'),
('64', '35'),
('65', '2'),
('65', '3'),
('65', '6'),
('65', '7'),
('65', '10'),
('65', '11'),
('65', '14'),
('65', '15'),
('65', '22'),
('65', '23'),
('65', '26'),
('65', '27'),
('65', '30'),
('65', '31'),
('65', '34'),
('65', '35'),
('66', '2'),
('66', '3'),
('66', '6'),
('66', '7'),
('66', '10'),
('66', '11'),
('66', '14'),
('66', '15'),
('66', '22'),
('66', '23'),
('66', '26'),
('66', '27'),
('66', '30'),
('66', '31'),
('66', '34'),
('66', '35'),
('67', '2'),
('67', '3'),
('67', '6'),
('67', '7'),
('67', '10'),
('67', '11'),
('67', '14'),
('67', '15'),
('67', '22'),
('67', '23'),
('67', '26'),
('67', '27'),
('67', '30'),
('67', '31'),
('67', '34'),
('67', '35'),
('68', '2'),
('68', '3'),
('68', '6'),
('68', '7'),
('68', '10'),
('68', '11'),
('68', '14'),
('68', '15'),
('68', '22'),
('68', '23'),
('68', '26'),
('68', '27'),
('68', '30'),
('68', '31'),
('68', '34'),
('68', '35'),
('69', '2'),
('69', '3'),
('69', '6'),
('69', '7'),
('69', '10'),
('69', '11'),
('69', '14'),
('69', '15'),
('69', '22'),
('69', '23'),
('69', '26'),
('69', '27'),
('69', '30'),
('69', '31'),
('69', '34'),
('69', '35'),
('70', '2'),
('70', '3'),
('70', '6'),
('70', '7'),
('70', '10'),
('70', '11'),
('70', '14'),
('70', '15'),
('70', '22'),
('70', '23'),
('70', '26'),
('70', '27'),
('70', '30'),
('70', '31'),
('70', '34'),
('70', '35'),
('71', '2'),
('71', '3'),
('71', '6'),
('71', '7'),
('71', '10'),
('71', '11'),
('71', '14'),
('71', '15'),
('71', '22'),
('71', '23'),
('71', '26'),
('71', '27'),
('71', '30'),
('71', '31'),
('71', '34'),
('71', '35'),
('72', '2'),
('72', '3'),
('72', '6'),
('72', '7'),
('72', '10'),
('72', '11'),
('72', '14'),
('72', '15'),
('72', '22'),
('72', '23'),
('72', '26'),
('72', '27'),
('72', '30'),
('72', '31'),
('72', '34'),
('72', '35'),
('73', '2'),
('73', '3'),
('73', '6'),
('73', '7'),
('73', '10'),
('73', '11'),
('73', '14'),
('73', '15'),
('73', '22'),
('73', '23'),
('73', '26'),
('73', '27'),
('73', '30'),
('73', '31'),
('73', '34'),
('73', '35'),
('74', '2'),
('74', '3'),
('74', '6'),
('74', '7'),
('74', '10'),
('74', '11'),
('74', '14'),
('74', '15'),
('74', '22'),
('74', '23'),
('74', '26'),
('74', '27'),
('74', '30'),
('74', '31'),
('74', '34'),
('74', '35'),
('75', '2'),
('75', '3'),
('75', '6'),
('75', '7'),
('75', '10'),
('75', '11'),
('75', '14'),
('75', '15'),
('75', '22'),
('75', '23'),
('75', '26'),
('75', '27'),
('75', '30'),
('75', '31'),
('75', '34'),
('75', '35'),
('76', '2'),
('76', '3'),
('76', '6'),
('76', '7'),
('76', '10'),
('76', '11'),
('76', '14'),
('76', '15'),
('76', '22'),
('76', '23'),
('76', '26'),
('76', '27'),
('76', '30'),
('76', '31'),
('76', '34'),
('76', '35'),
('77', '2'),
('77', '3'),
('77', '6'),
('77', '7'),
('77', '10'),
('77', '11'),
('77', '14'),
('77', '15'),
('77', '22'),
('77', '23'),
('77', '26'),
('77', '27'),
('77', '30'),
('77', '31'),
('77', '34'),
('77', '35'),
('78', '2'),
('78', '3'),
('78', '6'),
('78', '7'),
('78', '10'),
('78', '11'),
('78', '14'),
('78', '15'),
('78', '22'),
('78', '23'),
('78', '26'),
('78', '27'),
('78', '30'),
('78', '31'),
('78', '34'),
('78', '35'),
('79', '2'),
('79', '3'),
('79', '6'),
('79', '7'),
('79', '10'),
('79', '11'),
('79', '14'),
('79', '15'),
('79', '22'),
('79', '23'),
('79', '26'),
('79', '27'),
('79', '30'),
('79', '31'),
('79', '34'),
('79', '35'),
('80', '2'),
('80', '3'),
('80', '6'),
('80', '7'),
('80', '10'),
('80', '11'),
('80', '14'),
('80', '15'),
('80', '22'),
('80', '23'),
('80', '26'),
('80', '27'),
('80', '30'),
('80', '31'),
('80', '34'),
('80', '35'),
('81', '2'),
('81', '3'),
('81', '6'),
('81', '7'),
('81', '10'),
('81', '11'),
('81', '14'),
('81', '15'),
('81', '22'),
('81', '23'),
('81', '26'),
('81', '27'),
('81', '30'),
('81', '31'),
('81', '34'),
('81', '35'),
('82', '2'),
('82', '3'),
('82', '6'),
('82', '7'),
('82', '10'),
('82', '11'),
('82', '14'),
('82', '15'),
('82', '22'),
('82', '23'),
('82', '26'),
('82', '27'),
('82', '30'),
('82', '31'),
('82', '34'),
('82', '35'),
('83', '2'),
('83', '3'),
('83', '6'),
('83', '7'),
('83', '10'),
('83', '11'),
('83', '14'),
('83', '15'),
('83', '22'),
('83', '23'),
('83', '26'),
('83', '27'),
('83', '30'),
('83', '31'),
('83', '34'),
('83', '35'),
('84', '2'),
('84', '3'),
('84', '6'),
('84', '7'),
('84', '10'),
('84', '11'),
('84', '14'),
('84', '15'),
('84', '22'),
('84', '23'),
('84', '26'),
('84', '27'),
('84', '30'),
('84', '31'),
('84', '34'),
('84', '35'),
('85', '2'),
('85', '3'),
('85', '6'),
('85', '7'),
('85', '10'),
('85', '11'),
('85', '14'),
('85', '15'),
('85', '22'),
('85', '23'),
('85', '26'),
('85', '27'),
('85', '30'),
('85', '31'),
('85', '34'),
('85', '35'),
('86', '2'),
('86', '3'),
('86', '6'),
('86', '7'),
('86', '10'),
('86', '11'),
('86', '14'),
('86', '15'),
('86', '22'),
('86', '23'),
('86', '26'),
('86', '27'),
('86', '30'),
('86', '31'),
('86', '34'),
('86', '35'),
('87', '2'),
('87', '3'),
('87', '6'),
('87', '7'),
('87', '10'),
('87', '11'),
('87', '14'),
('87', '15'),
('87', '22'),
('87', '23'),
('87', '26'),
('87', '27'),
('87', '30'),
('87', '31'),
('87', '34'),
('87', '35'),
('88', '2'),
('88', '3'),
('88', '6'),
('88', '7'),
('88', '10'),
('88', '11'),
('88', '14'),
('88', '15'),
('88', '22'),
('88', '23'),
('88', '26'),
('88', '27'),
('88', '30'),
('88', '31'),
('88', '34'),
('88', '35'),
('89', '2'),
('89', '3'),
('89', '6'),
('89', '7'),
('89', '10'),
('89', '11'),
('89', '14'),
('89', '15'),
('89', '22'),
('89', '23'),
('89', '26'),
('89', '27'),
('89', '30'),
('89', '31'),
('89', '34'),
('89', '35'),
('90', '2'),
('90', '3'),
('90', '6'),
('90', '7'),
('90', '10'),
('90', '11'),
('90', '14'),
('90', '15'),
('90', '22'),
('90', '23'),
('90', '26'),
('90', '27'),
('90', '30'),
('90', '31'),
('90', '34'),
('90', '35'),
('91', '2'),
('91', '3'),
('91', '6'),
('91', '7'),
('91', '10'),
('91', '11'),
('91', '14'),
('91', '15'),
('91', '22'),
('91', '23'),
('91', '26'),
('91', '27'),
('91', '30'),
('91', '31'),
('91', '34'),
('91', '35');


-- 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=38 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'),
('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'),
('30', 'Admin_28', 'Admin', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('31', 'Branch Head_28', 'Branch Head', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('32', 'Waiter_28', 'Waiter', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('33', 'Chef_28', 'Chef', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('34', 'Admin_29', 'Admin', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('35', 'Branch Head_29', 'Branch Head', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('36', 'Waiter_29', 'Waiter', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('37', 'Chef_29', 'Chef', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29');


-- 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
('3ECPlKIn7lFbwANq25pt1nelLE55RQ0whBOlWoQJ', '7', '106.219.145.163', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.0.1 Safari/605.1.15', '[encoded data, 70508 characters]', '1763052525'),
('4buPYvVikWHigrey3B4NAWA31ae17xzslb08IAO2', NULL, '207.154.197.113', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkk0UkVvQUhiQVR5TkFkTDR0ZGI0QkFneUhScTZMN2pRWGxxUnc1ViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763084670'),
('6B8q6y0L83CdrCJPQglyV0tOJ13LBYAJBF7UyEML', '15', '152.59.84.64', '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, 109684 characters]', '1763056956'),
('78GS4afh6rOtMuW70pxs1i4gsY3i72OoSntQTVw4', NULL, '43.159.143.187', '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', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiR2pNdWltWUFncVVWMnMxdVlqdXlWOThpT1JybkdvQ0EzRjI3S3RRSSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763050094'),
('8YzFWRxF18RAadu98LEaAVs0KBfX9DUoZkBzccc7', NULL, '142.93.143.8', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOG5LeVI3WUJJWnIyc2xkT1F5RUtMNU91RTRMY05NYUpHa3d2QWo2QyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjQ6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYS8/cmVzdF9yb3V0ZT0lMkZ3cCUyRnYyJTJGdXNlcnMlMkYiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763084693'),
('9S1oKaeTx6ck3ZvgV5Za8PHhRiCrPEr71aJ5vQw0', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOERKMU1PaEVhTUJVUHY2cXhnR2ZIMjAyY1lXYk0zeFpUc1V5ODBtbyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056211'),
('ACTW5H3ixyUojPVIRejpR5tsQKBgVzmaTttSugdm', NULL, '142.93.143.8', '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', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWnpiSlU3VDEzZHllaEx3RlYydU9rRm0xVUxGNE9vWkVuWU9kR1VMYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763084671'),
('cNr0qlLXAqm5boOcEodjsyZI4UmK1Njl6414hJTB', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoieGxCVUNkNU0yRTBodGx5WlRiclFqV0dvb2U0TkhRd2F2djF5emJoOSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055894'),
('DWnrflSnkGBUwxVq8njGi4wH2ydvChZmVnwh4WMW', NULL, '207.154.197.113', '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', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYW1XZ05ZTlh5VjI4d3dsVDdERGFKZnA0MW1FNUU4OWNSOFFJeFMxWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763084671'),
('eAQ3ojEceZFvzeHqVbSvPDii2LetJWJGibOU9Ewt', NULL, '74.208.165.42', '', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiWERjdlkwZjJQNU9lbjM3bFdZQU1vV0xRWkVPSGZTSkZMejdZS0VmRSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763048610'),
('EOlHny2tKOLZL8gvjulZ8aasyKPvEwdVOfJBDkSq', NULL, '74.7.227.142', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.3; +https://openai.com/gptbot)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoib2dXS1E3VksyRk1IWXhsM0w1dTZka0JCd1J1bVdpSEdRN3dvakNuRSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763047870'),
('gYEr5KM3sk2Rn9W1ZfuBsAcP8YiH1j6dHuf5Frko', NULL, '203.192.221.136', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiOTBlYVIxcTB0emI4OEdJUEtLcnhEdGx4NU80NkNvSEJWczFOcGd2MyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwczovL3N3ZWV0LmV3aWlkaW5lLmNhL21hbmlmZXN0Lmpzb24/aGFzaD1zaW5kaS1zd2VldCZ1cmw9Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7fQ==', '1763048402'),
('hGzdBd8Ys60lpIFVGwmk3oLRRioeRrl0y5Q5JygS', NULL, '176.65.148.212', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.3', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYk13UjNlcGMwc3MxbXpaQnBmMnFVMDlORzExVDNzMkxaYWI3UEZZMCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763061624'),
('HIsSEYdnfzNSSPytXZA0SFKGUnFBZsmog6sPqDnB', NULL, '74.208.165.42', '', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoidjEyT2VlM2o3NGlDWkZNSWo2WWtzdG85ZWdCb3l2cDFQWUY4Y0REYSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763048610'),
('hpTAOcNklu79YleAqBvA4VhyHEK98hrEdjJ0jvUx', NULL, '117.33.163.216', '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', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiNEgxS0VFRVlHMHB5OWI1TDN6WmwwWEFmMUNPZ3BvakdFVVBsbFc4SSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763085367'),
('hu4ov5W498WdjOHvxTTXFeas58YyasUPuCukBoVm', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQkEzWW9jRXBnWVNYdGJLeVpxOUxDS0pIaEQwQ2dRZlFqUW5jUGF5aiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055844'),
('HzRzKMmDi3Kdvv5D0TKMSona8aYv2JjmjpOGPnp1', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiQnFhZGk0ZHRpYXNXM3dmcmZqcWJMOURRdkRVV3hWbUZiRTFPYlJMYyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763048609'),
('iGVXRQJYURA6Ggtl8qk7T8b3Y6eyWBWmgW9Q9uYX', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiM1dWbVg5WlEwdlJ3bm56RWc3clVOSkNuQTY2TGFuYnFoWDBwNEtEUSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055979'),
('JsUsrnevlly3PXQcUXOR4b3HGzViOTdknzCbUe7D', NULL, '49.51.243.156', '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', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSUpnRHNYd0xYblQxNmt5OVdYNVhOcHJQVVZUZ3E2M0tNM1p4eWdJSyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763057432'),
('jxnbauSZ1oOtsLfAjtebvZONAv3ScJ9yL507csMJ', NULL, '47.82.11.50', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36 Edg/135.0.0.0', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiV3pVTmw0V0ZOWG14R2JSRlFNekFTQnVnaGdYSm9vbjFjdzBlRlFqZyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM3OiJodHRwczovL2V3aWlkaW5lLmNhL3Jlc3RhdXJhbnQtc2lnbnVwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763069516'),
('k30DjbgbsAHovvAswcbz4MxiFez3Hnsr6GuX7Xl6', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoibjNUOGN2eG5VbHowbGZ2VmFLa3R3UzB5dDNXZW9sRkRJZmQwZ2NyWSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055998'),
('Kk19wO2QefZn6MzGwG4ErJbvxNW0eEQcvenDFqV4', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoia1lacmtPdTJxYkZEMkF0SVNjZ0ZlT0M1V2JLVmlUWkZJUzQ2U0g2cCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056237'),
('ky6y7VIeuFwjsajtRN8NEntX4URFbpRrQfaXTvlA', NULL, '152.59.84.125', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoibGxHTnVoN3VIVGptZUxCeFJZU2ZYMkZ0MDQ2STUwODRvRU81WjBOaCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjM2OiJodHRwczovL3Jlc3RhdXJhbnQuZXdpaWRpbmUuY2EvbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjE1OiJjdXN0b21lcl9pc19ydGwiO2I6MDt9', '1763048565'),
('lE2vjssaCaDenpjSA6wb9s8QSfHORx6QiN4tfkbR', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiVXpuVVNnTUdlZndLWnk0cDlVR2tzM3dzempTeEdLZ09rN2xnb0tCUyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056489'),
('lS6zwmD5sVojXRnfHgEk0413g7zuPYDbCqyfgqCS', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiZUc0MEg5SXdDd2VnVzVOTkUzcWpDYjJTSHpIM3lhU0ZaWWlZQUJ3SCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055267'),
('mbc8tGwRjX8x1qb8YsYSP5eAwyN8t2efZxeSnxWW', NULL, '74.208.165.42', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMlB4MWxKeGJUbW9xdG9kMTA4Y2JDdDRGZmx5RjNtSkF3Yk4xdmliYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056206'),
('mcUizCuGXm2aiPnCEAUdz9NtZbJf18VkWMT2E7sv', NULL, '199.45.154.125', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOHNIUUZvUGVhNmNJQ05vMjhqRWhXdnhydEp2dWxpMEpwaGQ0bWdWcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHBzOi8vbWFpbC5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763062956'),
('Nm0ERH5FJwusBwIjdmVC6nMO9VDqKI2v3Dqc9iMb', NULL, '207.154.197.113', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicW11cFExSVhQVXlzR0o4VHhpc3h6YzUwWDhlRnRIWVlDSmFHTnREWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjU6Imh0dHBzOi8vZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EvP3Jlc3Rfcm91dGU9JTJGd3AlMkZ2MiUyRnVzZXJzJTJGIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763084705'),
('nQNItTKeiVRx9dgI9r6WWyNLkO5MOxNDc9vczbjv', NULL, '152.59.84.125', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiOFFEcHVGNUgyTkI4OUhDM1RuTGV6U3FaU3BMeWVPMlg4cEFYYldIZiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHBzOi8vZXdpaWRpbmUuY2EvbWFuaWZlc3QuanNvbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NDoidXNlciI7Tjt9', '1763048505'),
('Nwwb7SOR27sAzy1afYVrM2MRqUrkqpqmHkciQj29', NULL, '138.68.82.23', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoidHFrelVqR1hEOW5UZ1Q0QjUzT1JNMzdWQWZ2TWEwYW1YclAxdUVPRCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763084671'),
('O0ytTcna0aybjbZOE5b6uYT31z29X7se9pjufpSz', NULL, '199.45.155.81', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV0Q4ZHIzMnRoT3JzT3FyVDNOa256UVFVdUxNelRDRzlmaVNYRDBMViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly9tYWlsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763062417'),
('OQ4WhHksC9punH8skiQnwiuu9LlyXUlbq8W9j6TQ', NULL, '152.59.84.125', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoieTBsM3AxdDBZMzFyaTdlb29wNDV3ZVpDOHE0WHRSVWNKWEhNU1pRRyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo0OiJ1c2VyIjtOO3M6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjYxOiJodHRwczovL3N3ZWV0LmV3aWlkaW5lLmNhL21hbmlmZXN0Lmpzb24/aGFzaD1zaW5kaS1zd2VldCZ1cmw9Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7fQ==', '1763048387'),
('PCaXI2xUZ89XF5twOcKjJnRn8wNP8Lp21V0wLdV8', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWmh5ZUdJU2h0UXRHUzNuc3hERGNHMEFSVmp5VWVxVEVOMG05SmhNNCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055356'),
('Q8Y3Ru6BBykQN4yClrzq9l2ZcON1aBnMfJXPrmZX', NULL, '170.106.192.208', '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', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiSjRKbFRRWTZPYmFWT25Ca3lBWEdlemtZcW9HaFk4N2pIanR0Uno2WSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763046716'),
('SBHoRW2vZdFR91YyCdM9WJRN8ViZb05VHk2pOG0R', '10', '152.59.84.64', '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, 17824 characters]', '1763054964'),
('sDbisfOCW7MpBPEst4mPzzNyjDFwiP6Jk4WKZpn5', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUmo2TUxyY05MUW8xaGhKZGgxdWFGYTczcGdpWGVBQkczTTc4eDlGTiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055914'),
('UVeOpvOC85axDj4lacpVbd9VVhNcBuXSHtI4Lu9f', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiYnNGVEMzcnJpUUhRNGJZUGFhbDRsUkNybFJjZ1I0R1puMUN3SEZTdCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056379'),
('ViIjN59TJuQxyl4p7q9ars1p8NOgCv1BWJ2k1Tmt', NULL, '170.106.35.137', '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', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZjdGdFlQd3VFb0VHUUxBZHF6d1VVdm5ZaVcxUVo4QkZOSEppYTlkMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA6Imh0dHA6Ly9tLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763059456'),
('vjMJu5Iz1HzGr6QdwTX7cqEyD6XQZpzi5btJyrkd', NULL, '74.208.165.42', '', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiQmJSQ2FkVDRMUEhUZmZ4Sno3dFY3UUl6OTFuRmprR3BBYTZKSUtjaCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763048610'),
('WHCYHc3h2dPeNXTYuzw4W7Jjy7C2r5Qw45J22b25', NULL, '106.219.145.163', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Mobile Safari/537.36', '[encoded data, 15428 characters]', '1763052287'),
('WnaHauhnxdjlu2UeuBhqrROZIQiVQXNFndW2rZSX', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiRXcwSGtMSUt2NjVyVGRtd3hPUHhFeEh4bWVuQlppa0pyTlZVVkFucCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056039'),
('WTlyKKFcaouiq5QlbKIoAMJu8lbRRpNq9KIE9RsN', NULL, '142.93.143.8', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRGI5YnhkWWpHRDBmeXJhcUd3S0ZqaGx1SmVMZnZGWmFZWDdJYTVrWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9ld2lpZGluZS5jYS5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1763084670'),
('xFNzAZH7MD7Tlm5lRPTRwnmJRn0PqLS6RETTgyv7', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR0NYUlFLcEhWVG5UalV2b3dSRERDdHJVVUFmR1pKSDNlOGdpNGg1ciI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056501'),
('YCuJxKefLimJ1UL31dE2nev5NHLkcfv6LC3KYeit', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWHNTd3RuckJaM01uYzdiOGtQTXR4YldRVjhhRUZYMm9KdW5jUjZhbiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763056215'),
('Z619bfDbDbuZD7faSV0kef7GBifhKTy2kRG4j3Tn', NULL, '49.51.178.45', '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', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoienVRQlA4TlV2ejZHVUtkd0ExYlZtNnl5c2pyN2Q3eGdhY1NXeE9iTiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1763056072'),
('ZKoUttT6OEHOaaukoFn0wF9440XrCnZqyR0Isic7', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR0FMeGFwUUhZOGkycmZIcjRtUnR4Q0VTYUlHdUoxTkd6STN3SFRvZCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055916'),
('ZwqOXrToioa2MkoM3QPUwJBestQdC197phW7ZsTh', NULL, '74.208.165.42', '', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiWHpqWU93VEROWnlOSXZHTEp4UE9HMU5veUJUZGJOak82YWtrdVVLSiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDE6Imh0dHBzOi8vZXdpaWRpbmUuY2EvYXBwL29mZmxpbmUtcGxhbi1saXN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1763055520');


-- 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=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sms_notification_settings`
INSERT INTO `sms_notification_settings` VALUES
('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),
('67', '28', 'reservation_confirmed', 'no', NULL, NULL),
('68', '28', 'order_bill_sent', 'no', NULL, NULL),
('69', '28', 'send_otp', 'no', NULL, NULL),
('70', '29', 'reservation_confirmed', 'no', NULL, NULL),
('71', '29', 'order_bill_sent', 'no', NULL, NULL),
('72', '29', '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=301 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'),
('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'),
('281', '29', 'Kilogram', 'kg', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('282', '29', 'Gram', 'g', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('283', '29', 'Liter', 'L', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('284', '29', 'Milliliter', 'ml', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('285', '29', 'Piece', 'pc', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('286', '29', 'Box', 'box', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('287', '29', 'Dozen', 'dz', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('288', '29', 'Bottle', 'btl', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('289', '29', 'Package', 'pkg', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('290', '29', 'Can', 'can', '2025-11-12 14:15:50', '2025-11-12 14:15:50'),
('291', '30', 'Kilogram', 'kg', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('292', '30', 'Gram', 'g', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('293', '30', 'Liter', 'L', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('294', '30', 'Milliliter', 'ml', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('295', '30', 'Piece', 'pc', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('296', '30', 'Box', 'box', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('297', '30', 'Dozen', 'dz', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('298', '30', 'Bottle', 'btl', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('299', '30', 'Package', 'pkg', '2025-11-13 15:41:43', '2025-11-13 15:41:43'),
('300', '30', 'Can', 'can', '2025-11-13 15:41:43', '2025-11-13 15:41:43');


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

