-- Table structure for table `pusher_settings`
CREATE TABLE `pusher_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `beamer_status` tinyint(1) NOT NULL DEFAULT 0,
  `instance_id` varchar(191) DEFAULT NULL,
  `beam_secret` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `pusher_broadcast` tinyint(1) NOT NULL DEFAULT 0,
  `pusher_app_id` varchar(191) DEFAULT NULL,
  `pusher_key` varchar(191) DEFAULT NULL,
  `pusher_secret` varchar(191) DEFAULT NULL,
  `pusher_cluster` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `pusher_settings`
INSERT INTO `pusher_settings` VALUES
('1', '1', 'd40201a7-4c2b-485d-b83e-b6df413123b9', '14A81FF2A4C0B8BAB9765B9499E25E4A635B35203593A1BF9E2FF0D177D88FC7', '2025-09-17 11:06:40', '2025-09-20 20:02:42', '1', '1700836', '74e36e339f0d30ae3742', 'e210d079d07f180d0b75', 'mt1'),
('2', '0', NULL, NULL, '2025-09-17 11:06:44', '2025-09-17 11:06:44', '0', NULL, NULL, NULL, NULL);


-- Table structure for table `razorpay_payments`
CREATE TABLE `razorpay_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,
  `razorpay_order_id` varchar(191) DEFAULT NULL,
  `razorpay_payment_id` varchar(191) DEFAULT NULL,
  `razorpay_signature` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `razorpay_payments_order_id_foreign` (`order_id`),
  CONSTRAINT `razorpay_payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `razorpay_payments`
INSERT INTO `razorpay_payments` VALUES
('1', '3', '2025-10-07 15:27:21', '4.20', 'completed', NULL, 'order_RQdEjK4mFoyb5X', 'pay_RQdFvyYfrbz90B', 'ab3a863408775751c5e84d3f76868ec971c2549f2446b5fa3621311bc12169bf', '2025-10-07 20:55:57', '2025-10-07 20:57:21'),
('2', '4', '2025-10-08 09:01:47', '1207.50', 'completed', NULL, 'order_RQvDdMEnjpcAar', 'pay_RQvDmpMUMiPPoz', '22ab9b169944f12675b46dcd8b13f54436eae52074b0aa7be217795fffa97a7c', '2025-10-08 14:31:24', '2025-10-08 14:31:47'),
('3', '5', '2025-10-08 10:35:27', '126.00', 'completed', NULL, 'order_RQwoDoAZZBXGHS', 'pay_RQwocGZ0pLkBZU', '81827097b034d78a88c62054e893f7ee7cd9b731a79ac938a0e8034f69ef5377', '2025-10-08 16:04:44', '2025-10-08 16:05:27'),
('4', '11', '2025-10-16 12:02:53', '262.50', 'completed', NULL, 'order_RU8ZgFDUHtuxgL', 'pay_RU8a2YLhBIHi68', 'cbf12e299953cedfa42184d82d7587e43669f299dc3a85fe1fa5b5e5004be924', '2025-10-16 17:32:18', '2025-10-16 17:32:53'),
('5', '11', NULL, '262.50', 'pending', NULL, 'order_RU8aGu6rma9yue', NULL, NULL, '2025-10-16 17:32:52', '2025-10-16 17:32:53'),
('6', '12', '2025-10-16 12:33:24', '126.00', 'completed', NULL, 'order_RU95r290ofCDqi', 'pay_RU96EhIkc3IVzX', '2c1b8e51ce2307805c05ca0306ada70654e157c82b5f0f4353e9f136b12aa4cb', '2025-10-16 18:02:45', '2025-10-16 18:03:24'),
('7', '12', NULL, '126.00', 'pending', NULL, 'order_RU96VhDVxnZRlv', NULL, NULL, '2025-10-16 18:03:23', '2025-10-16 18:03:24'),
('8', '13', '2025-10-16 12:41:48', '126.00', 'completed', NULL, 'order_RU9EtwR38RMeJT', 'pay_RU9F8RuNHirFo6', '9ae8d47dcfd4115cce91ca8c66e8444c22f30f2cbdbdd9f95eea60c6251f0ec6', '2025-10-16 18:11:20', '2025-10-16 18:11:48'),
('9', '13', NULL, '126.00', 'pending', NULL, 'order_RU9FOKnMNtqAwT', NULL, NULL, '2025-10-16 18:11:48', '2025-10-16 18:11:48'),
('10', '14', '2025-10-16 12:48:50', '262.50', 'completed', NULL, 'order_RU9MH7rS6fHal7', 'pay_RU9MU5ib1JkTnn', '2e87246a9b182883aa6cbe4fbbc499494f34c47314a8d61d3c746c5e855056f1', '2025-10-16 18:18:19', '2025-10-16 18:18:50'),
('11', '16', '2025-10-16 13:21:02', '136.50', 'completed', NULL, 'order_RU9uT8B8gLO9QH', 'pay_RU9ub1bUSMzfs0', '80b2172794e73668d3fbe22a4e9aa44c88a164ad5294d8f29bbc6a443a98973e', '2025-10-16 18:50:39', '2025-10-16 18:51:02'),
('12', '17', '2025-10-16 13:30:10', '136.50', 'completed', NULL, 'order_RUA44x2L6DrVj6', 'pay_RUA4EIVkrFaSbP', '192d53a4214085f62db6940a14e7c88bbe4896c23b08e2acf705343c35a29e4d', '2025-10-16 18:59:47', '2025-10-16 19:00:10'),
('13', '17', NULL, '136.50', 'pending', NULL, 'order_RUA4TduMY0NapO', NULL, NULL, '2025-10-16 19:00:09', '2025-10-16 19:00:10'),
('14', '18', '2025-10-16 13:55:16', '126.00', 'completed', NULL, 'order_RUAUe10RDgdiX0', 'pay_RUAUlBSDMxqJTC', 'f163d9a021eb30c66282784f261c6239ee5c9e0e14b1037e5a7671380f11ea11', '2025-10-16 19:24:55', '2025-10-16 19:25:16'),
('15', '19', '2025-10-16 13:57:19', '136.50', 'completed', NULL, 'order_RUAWnRnZAitO5K', 'pay_RUAWulQPNCTG7i', '85af424b781f99b156a6649c9ab98b7f643be140baef6bd5f62fc44c9e827b44', '2025-10-16 19:26:58', '2025-10-16 19:27:19'),
('16', '20', '2025-10-16 14:01:17', '136.50', 'completed', NULL, 'order_RUAaoXIyWj6Pnj', 'pay_RUAb7Ybhnyp6VA', '2034863bb1307002ae4393bd6976c9daac62a8efb17fbee0d810c42a82667c3b', '2025-10-16 19:30:46', '2025-10-16 19:31:17'),
('17', '21', '2025-10-16 14:21:16', '136.50', 'completed', NULL, 'order_RUAw5XJg7FTmuA', 'pay_RUAwENCbQlEREv', '0668c433240c3d45d321893b3fa414bd2028b060e4224add33301eee6ecccdc8', '2025-10-16 19:50:54', '2025-10-16 19:51:16'),
('18', '22', '2025-10-16 15:40:44', '262.50', 'completed', NULL, 'order_RUCGOxOyxUxNvZ', 'pay_RUCI08zHu05Cru', 'e15c4b58cc62691d740e9b50011766ec3882250e99a66cf6b78c52ba1146d7c6', '2025-10-16 21:08:48', '2025-10-16 21:10:44'),
('19', '23', '2025-10-16 15:52:12', '126.00', 'completed', NULL, 'order_RUCU8C4Z2ZqojV', 'pay_RUCUH901mTpl0v', '335ea0a08988e95a9c2370397c987848411a3f437931af063e8f39d448d107f1', '2025-10-16 21:21:49', '2025-10-16 21:22:12'),
('20', '24', '2025-10-16 16:32:18', '136.50', 'completed', NULL, 'order_RUDATpmB7WN6xY', 'pay_RUDAdHGRhRPEMR', 'abf62034aa8c9bfa456835fc9a9b3bb031e0eb53dcc479c3b5361ee6a0c8fb5b', '2025-10-16 22:01:54', '2025-10-16 22:02:18'),
('21', '25', '2025-10-16 16:38:15', '136.50', 'completed', NULL, 'order_RUDGjP4LohHskh', 'pay_RUDGrlYPDDK0Fy', '664ecbacf5a0960ec6bc40b049b391792044eb42ec01007564e9b4e629ab9c30', '2025-10-16 22:07:50', '2025-10-16 22:08:15'),
('22', '26', '2025-10-16 17:03:09', '136.50', 'completed', NULL, 'order_RUDh6ggkDpG8ct', 'pay_RUDhEd02oZPOQz', 'b0f7210312fb43b664a7497f5af0bf158e9ab622b478b579ebe208ef7eb87688', '2025-10-16 22:32:48', '2025-10-16 22:33:09'),
('23', '28', '2025-10-16 17:41:36', '472.50', 'completed', NULL, 'order_RUELgaBQ9IIvqw', 'pay_RUELrldqCYy71f', 'bded028be187bc97db9e15840b0a6aa05901457a378c09ca502b95fe42bc067e', '2025-10-16 23:11:12', '2025-10-16 23:11:36'),
('24', '29', '2025-10-17 23:31:40', '682.50', 'completed', NULL, 'order_RUiqZ1lWvsuTay', 'pay_RUiqllBt3UkVp2', '8f6c28ff48c1ec6f7f85e18ef1f2bfff14393f19db26564f8e05683c7120ad99', '2025-10-18 05:01:15', '2025-10-18 05:01:40'),
('25', '33', '2025-10-17 23:45:18', '220.50', 'completed', NULL, 'order_RUj53Izsqgh4ZR', 'pay_RUj5ABMuzDkVft', 'df49725b5e976019c5d1aa8dd1611fe4542f4007133ee230053391bae6c6804f', '2025-10-18 05:14:58', '2025-10-18 05:15:18'),
('26', '45', '2025-10-18 18:28:48', '136.50', 'completed', NULL, 'order_RV2DoDSYF7JI2k', 'pay_RV2DxCEAXulsv5', '16e15a6f0da7f172b51ae0f14c0a4e6188f6a5c65b13e2e5c92cb96a038bb674', '2025-10-18 23:58:26', '2025-10-18 23:58:48'),
('27', '46', '2025-10-24 02:25:28', '420.00', 'completed', NULL, 'order_RX90nIKa4rcCPW', 'pay_RX913zygg3h1tF', '7f896bab839f80ee7607adcad12c701126901eda0f16ca5afaf699fb478c1cb2', '2025-10-24 07:54:58', '2025-10-24 07:55:28'),
('28', '47', '2025-10-24 02:33:07', '420.00', 'completed', NULL, 'order_RX94MQTaiKEBkp', 'pay_RX94TbbHbMhN5f', '06f166e964c8329bd5bef8de3fdf79dcabd5ef6fc2dcab7260a55c9d35614268', '2025-10-24 07:58:21', '2025-10-24 08:03:07'),
('29', '48', '2025-10-24 02:32:05', '420.00', 'completed', NULL, 'order_RX97sM6vUJm3oD', 'pay_RX97xYO5XaJJUZ', 'cb9e634ad62850629b5e617c186c4a03fc91a8c9608b77ff4d54d64f660daba4', '2025-10-24 08:01:41', '2025-10-24 08:02:05'),
('30', '49', NULL, '420.00', 'pending', NULL, 'order_RX9ArA9HPXxlgb', NULL, NULL, '2025-10-24 08:04:30', '2025-10-24 08:04:31'),
('31', '51', '2025-10-24 08:05:24', '420.00', 'completed', NULL, 'order_RXEnwXmCxf6uU3', 'pay_RXEo8vcj53JFek', '2c397cf545e4fc63b470686efdbc7d963a3a355940ccab076ff3099d57eb9391', '2025-10-24 13:34:58', '2025-10-24 13:35:24'),
('32', '52', '2025-10-24 14:55:53', '31.50', 'completed', NULL, 'order_RXLne0sIyctfut', 'pay_RXLnlRuXkRmfab', 'c04424aaa6aa0ba41e7bbef081c2996b98b04502596df2c8828ab836ebbae81b', '2025-10-24 20:25:32', '2025-10-24 20:25:53'),
('33', '58', '2025-10-25 06:26:39', '136.50', 'completed', NULL, 'order_RXbeY7hiWwAJJK', 'pay_RXbevsxRjFumh3', '58ba2ef3dd000beb4e17e54d3cfc948dd2a6130d8cb5260354307ad5de76d4fb', '2025-10-25 11:56:01', '2025-10-25 11:56:39'),
('34', '59', '2025-10-25 06:30:15', '126.00', 'completed', NULL, 'order_RXbiZPU3u2i48x', 'pay_RXbihPYglMshJc', '247a7855ef5bea1fec0ceff653d4c9e6d43426bb98c08a55b3c84c88337b8679', '2025-10-25 11:59:50', '2025-10-25 12:00:15'),
('35', '59', NULL, '126.00', 'pending', NULL, 'order_RXbizDuTKBWXAv', NULL, NULL, '2025-10-25 12:00:14', '2025-10-25 12:00:15'),
('36', '60', '2025-10-25 07:09:25', '451.50', 'completed', NULL, 'order_RXcNpG4FzZt3w6', 'pay_RXcO2QUK3Vaicu', '6607741d668bac6aba2680935e6135a3698208e912998271a8bc238108a5cbd0', '2025-10-25 12:38:53', '2025-10-25 12:39:25'),
('37', '61', '2025-10-25 13:05:35', '215.25', 'completed', NULL, 'order_RXiSF3FS6svoJe', 'pay_RXiSNL3KI554tj', '189f87e1b6e1aebbb406c67dbfe548ea1230c9f4c1fd2ff2f2c321d195ddbe17', '2025-10-25 18:35:13', '2025-10-25 18:35:35'),
('38', '62', NULL, '420.00', 'pending', NULL, 'order_RXiTnagcOa85kR', NULL, NULL, '2025-10-25 18:36:43', '2025-10-25 18:36:44'),
('39', '65', '2025-10-27 08:34:14', '420.00', 'completed', NULL, 'order_RYQtheU6Vzhk9c', 'pay_RYQtycnNPA3QC8', '33e3162f4b2721afd96da96a9227107bce34a94ce9fa7fcc8fb5bba9f07120d4', '2025-10-27 14:03:44', '2025-10-27 14:04:14'),
('40', '66', '2025-10-27 09:44:37', '136.50', 'completed', NULL, 'order_RYS65xUEvFXZLz', 'pay_RYS6Im4PwH5Ms3', '0ef28361bf1a834964f56177ebc934169c01e14ff727d13017f9db3b491abda4', '2025-10-27 15:14:10', '2025-10-27 15:14:37'),
('41', '67', '2025-10-31 14:52:43', '262.50', 'completed', NULL, 'order_Ra7U11LtBWtAri', 'pay_Ra7UGYjSkQuBI1', 'fe3d0be68e2104cd916509b14998ef0ece0b6c983108875ac17eb6bbafdeae4a', '2025-10-31 20:22:15', '2025-10-31 20:22:43'),
('42', '68', '2025-11-06 14:26:59', '136.50', 'completed', NULL, 'order_RcUFOOLzjdiIXx', 'pay_RcUFltzY11hRkG', '94df31a53e0205e41dd6d973ceb9220e7f97c83be03aab7e01e15f867033c5c8', '2025-11-06 19:56:21', '2025-11-06 19:56:59'),
('43', '69', '2025-11-08 08:15:20', '126.00', 'completed', NULL, 'order_RdAzGZUHLcfCc3', 'pay_RdAzRsFf5QdQv9', '60c37a8c08a283b5160dc2b7d178a9880dc64f986ca5954c018d82c531e266f2', '2025-11-08 13:44:55', '2025-11-08 13:45:20'),
('44', '70', '2025-11-25 09:28:04', '126.00', 'completed', NULL, 'order_RjvIzl9fO5dvt4', 'pay_RjvJLBitbRBmUL', '627890cb01b3713cea8f489519eaf99e51476dc4faf3af49f4e34a4ddd11bd61', '2025-11-25 14:57:31', '2025-11-25 14:58:04'),
('45', '93', NULL, '787.50', 'pending', NULL, 'order_RnxlvS37oFmHDj', NULL, NULL, '2025-12-05 19:58:17', '2025-12-05 19:58:19'),
('46', '93', NULL, '787.50', 'pending', NULL, 'order_Rnxm7HMQ59VcLS', NULL, NULL, '2025-12-05 19:58:29', '2025-12-05 19:58:30'),
('47', '93', NULL, '787.50', 'pending', NULL, 'order_Rnxm8PI1cmIxrB', NULL, NULL, '2025-12-05 19:58:30', '2025-12-05 19:58:31'),
('48', '95', NULL, '420.00', 'pending', NULL, 'order_Rnxt33EzidYxYb', NULL, NULL, '2025-12-05 20:05:03', '2025-12-05 20:05:04'),
('49', '118', '2026-01-02 08:39:19', '787.50', 'completed', NULL, 'order_RywluBSto0tKjq', 'pay_RywmKzQlDjA6L7', 'd557e1c9ad61cfdb05879746ea12368d875186e8a5e7197843aa08840b08b018', '2026-01-02 08:38:36', '2026-01-02 08:39:19'),
('50', '118', NULL, '787.50', 'pending', NULL, 'order_Rywmcl7FeNgdfH', NULL, NULL, '2026-01-02 08:39:17', '2026-01-02 08:39:18'),
('51', '118', NULL, '787.50', 'pending', NULL, 'order_RywmdeSUWFsqx6', NULL, NULL, '2026-01-02 08:39:18', '2026-01-02 08:39:19'),
('52', '119', '2026-01-02 09:12:50', '393.75', 'completed', NULL, 'order_RyxLVmH7T6lfwU', 'pay_RyxLhmdHROgIig', '3189be287592bf06df04273052a74c183a1f3b4ebddda8e7cd7ad469bd68043f', '2026-01-02 09:12:18', '2026-01-02 09:12:50'),
('53', '120', '2026-01-02 09:14:54', '393.75', 'completed', NULL, 'order_RyxNb6ZinMqclk', 'pay_RyxNlQS5Nf28wu', '861994231c39713fb11c0747ce3be07dcb5f9346f8e84a99af3bbc252bc1f22c', '2026-01-02 09:14:18', '2026-01-02 09:14:54');


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

-- Dumping data for table `receipt_settings`
INSERT INTO `receipt_settings` VALUES
('1', '1', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-09-17 11:06:43', '2025-09-17 11:06:43'),
('2', '2', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('3', '3', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '1', '1', '0', '0', '2025-09-20 18:26:44', '2025-09-20 18:31:44'),
('4', '4', '1', '1', '0', '1', NULL, '0', '1', '1', '1', '1', '1', '0', '1', '2025-10-07 20:30:09', '2025-10-18 23:08:44'),
('26', '26', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('27', '27', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-11-08 16:02:26', '2025-11-08 16:02:26'),
('28', '28', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-11-12 19:45:50', '2025-11-12 19:45:50'),
('29', '29', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-11-13 21:11:43', '2025-11-13 21:11:43'),
('30', '30', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('31', '31', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-12-29 00:56:09', '2025-12-29 00:56:09'),
('32', '32', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('33', '33', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '0', '1', '0', '0', '2026-01-22 10:24:08', '2026-01-22 10:24:08'),
('34', '34', '0', '0', '0', '0', NULL, '0', '0', '0', '0', '1', '1', '0', '0', '2026-01-26 10:14:23', '2026-03-22 01:06:35');


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

-- Dumping data for table `recipes`
INSERT INTO `recipes` VALUES
('3', '503', '1', NULL, '1', '1.000', '41', '2025-10-18 23:12:32', '2025-10-18 23:12:32'),
('4', '503', '1', NULL, '2', '5.000', '45', '2025-10-18 23:12:32', '2025-10-18 23:12:32'),
('5', '503', '2', NULL, '1', '2.000', '41', '2025-10-18 23:13:01', '2025-10-18 23:13:01'),
('6', '503', '2', NULL, '2', '7.000', '45', '2025-10-18 23:13:01', '2025-10-18 23:13:01'),
('7', '503', '3', NULL, '2', '15.000', '45', '2025-10-18 23:13:27', '2025-10-18 23:13:27'),
('8', '503', '3', NULL, '1', '3.000', '41', '2025-10-18 23:13:27', '2025-10-18 23:13:27');


-- Table structure for table `refund_reasons`
CREATE TABLE `refund_reasons` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `reason` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `refund_reasons_branch_id_foreign` (`branch_id`),
  CONSTRAINT `refund_reasons_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- Table structure for table `refunds`
CREATE TABLE `refunds` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `payment_id` bigint(20) unsigned NOT NULL,
  `order_id` bigint(20) unsigned NOT NULL,
  `delivery_app_id` bigint(20) unsigned DEFAULT NULL,
  `refund_reason_id` bigint(20) unsigned DEFAULT NULL,
  `refund_type` enum('full','partial','waste') NOT NULL DEFAULT 'full',
  `partial_refund_type` enum('half','fixed','custom') DEFAULT NULL,
  `amount` decimal(16,2) NOT NULL,
  `commission_adjustment` decimal(16,2) DEFAULT NULL,
  `status` enum('pending','processed','failed','cancelled') NOT NULL DEFAULT 'pending',
  `notes` text DEFAULT NULL,
  `processed_by` bigint(20) unsigned DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `refunds_branch_id_foreign` (`branch_id`),
  KEY `refunds_payment_id_foreign` (`payment_id`),
  KEY `refunds_order_id_foreign` (`order_id`),
  KEY `refunds_delivery_app_id_foreign` (`delivery_app_id`),
  KEY `refunds_refund_reason_id_foreign` (`refund_reason_id`),
  KEY `refunds_processed_by_foreign` (`processed_by`),
  CONSTRAINT `refunds_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `refunds_delivery_app_id_foreign` FOREIGN KEY (`delivery_app_id`) REFERENCES `delivery_platforms` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `refunds_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `refunds_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `refunds_processed_by_foreign` FOREIGN KEY (`processed_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `refunds_refund_reason_id_foreign` FOREIGN KEY (`refund_reason_id`) REFERENCES `refund_reasons` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


-- 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=799 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 11:06:44', '2025-09-17 11:06:44'),
('2', '1', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('3', '1', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('4', '1', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('5', '1', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('6', '1', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('7', '1', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('8', '1', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('9', '1', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('10', '1', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('11', '1', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('12', '1', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('13', '1', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('14', '1', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('15', '1', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('16', '1', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('17', '1', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('18', '1', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('19', '1', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('20', '1', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('21', '1', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('22', '2', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('23', '2', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('24', '2', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('25', '2', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('26', '2', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('27', '2', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('28', '2', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('29', '2', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('30', '2', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('31', '2', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('32', '2', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('33', '2', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('34', '2', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('35', '2', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('36', '2', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('37', '2', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('38', '2', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('39', '2', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('40', '2', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('41', '2', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('42', '2', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('43', '1', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('44', '1', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('45', '1', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('46', '1', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('47', '1', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('48', '1', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('49', '1', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('50', '1', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('51', '1', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('52', '1', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('53', '1', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('54', '1', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('55', '1', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('56', '1', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('57', '1', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('58', '1', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('59', '1', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('60', '1', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('61', '1', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('62', '1', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('63', '1', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 11:06:44', '2025-09-17 11:06:44'),
('64', '3', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('65', '3', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('66', '3', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('67', '3', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('68', '3', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('69', '3', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('70', '3', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('71', '3', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('72', '3', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('73', '3', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('74', '3', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('75', '3', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('76', '3', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('77', '3', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('78', '3', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('79', '3', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('80', '3', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('81', '3', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('82', '3', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('83', '3', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('84', '3', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-17 15:32:45', '2025-09-17 15:32:45'),
('85', '4', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('86', '4', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('87', '4', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('88', '4', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('89', '4', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('90', '4', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('91', '4', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('92', '4', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('93', '4', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('94', '4', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('95', '4', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('96', '4', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('97', '4', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('98', '4', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('99', '4', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('100', '4', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('101', '4', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('102', '4', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('103', '4', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('104', '4', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('105', '4', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-09-20 18:26:44', '2025-09-20 18:26:44'),
('106', '5', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('107', '5', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('108', '5', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('109', '5', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('110', '5', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('111', '5', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('112', '5', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('113', '5', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('114', '5', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('115', '5', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('116', '5', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('117', '5', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('118', '5', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('119', '5', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('120', '5', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('121', '5', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('122', '5', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('123', '5', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('124', '5', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('125', '5', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('126', '5', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-10-07 20:30:09', '2025-10-07 20:30:09'),
('568', '27', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('569', '27', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('570', '27', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('571', '27', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('572', '27', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('573', '27', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('574', '27', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('575', '27', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('576', '27', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('577', '27', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('578', '27', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('579', '27', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('580', '27', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('581', '27', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('582', '27', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('583', '27', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('584', '27', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('585', '27', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('586', '27', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('587', '27', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('588', '27', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-07 22:53:03', '2025-11-07 22:53:03'),
('589', '28', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('590', '28', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('591', '28', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('592', '28', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('593', '28', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('594', '28', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('595', '28', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('596', '28', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('597', '28', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('598', '28', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('599', '28', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('600', '28', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('601', '28', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('602', '28', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('603', '28', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('604', '28', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('605', '28', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('606', '28', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('607', '28', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('608', '28', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('609', '28', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-08 16:02:27', '2025-11-08 16:02:27'),
('610', '29', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('611', '29', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('612', '29', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('613', '29', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('614', '29', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('615', '29', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('616', '29', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('617', '29', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('618', '29', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('619', '29', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('620', '29', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('621', '29', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('622', '29', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('623', '29', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('624', '29', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('625', '29', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('626', '29', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('627', '29', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('628', '29', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('629', '29', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('630', '29', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-12 19:45:51', '2025-11-12 19:45:51'),
('631', '30', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('632', '30', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('633', '30', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('634', '30', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('635', '30', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('636', '30', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('637', '30', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('638', '30', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('639', '30', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('640', '30', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('641', '30', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('642', '30', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('643', '30', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('644', '30', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('645', '30', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('646', '30', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('647', '30', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('648', '30', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('649', '30', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('650', '30', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('651', '30', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-13 21:11:44', '2025-11-13 21:11:44'),
('652', '31', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('653', '31', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('654', '31', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('655', '31', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('656', '31', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('657', '31', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('658', '31', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('659', '31', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('660', '31', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('661', '31', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('662', '31', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('663', '31', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('664', '31', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('665', '31', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('666', '31', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('667', '31', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('668', '31', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('669', '31', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('670', '31', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('671', '31', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('672', '31', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-11-15 13:16:25', '2025-11-15 13:16:25'),
('673', '32', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('674', '32', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('675', '32', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('676', '32', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('677', '32', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('678', '32', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('679', '32', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('680', '32', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('681', '32', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('682', '32', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('683', '32', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('684', '32', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('685', '32', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('686', '32', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('687', '32', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('688', '32', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('689', '32', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('690', '32', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('691', '32', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('692', '32', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('693', '32', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-29 00:56:10', '2025-12-29 00:56:10'),
('694', '33', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('695', '33', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('696', '33', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('697', '33', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('698', '33', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('699', '33', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('700', '33', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('701', '33', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('702', '33', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('703', '33', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('704', '33', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('705', '33', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('706', '33', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('707', '33', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('708', '33', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('709', '33', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('710', '33', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('711', '33', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('712', '33', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('713', '33', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('714', '33', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2025-12-31 00:13:23', '2025-12-31 00:13:23'),
('715', '34', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('716', '34', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('717', '34', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('718', '34', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('719', '34', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('720', '34', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('721', '34', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('722', '34', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('723', '34', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('724', '34', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('725', '34', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('726', '34', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('727', '34', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('728', '34', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('729', '34', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('730', '34', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('731', '34', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('732', '34', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('733', '34', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('734', '34', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('735', '34', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-22 10:24:09', '2026-01-22 10:24:09'),
('736', '35', 'Monday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('737', '35', 'Monday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('738', '35', 'Monday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('739', '35', 'Tuesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('740', '35', 'Tuesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('741', '35', 'Tuesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('742', '35', 'Wednesday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('743', '35', 'Wednesday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('744', '35', 'Wednesday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('745', '35', 'Thursday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('746', '35', 'Thursday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('747', '35', 'Thursday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('748', '35', 'Friday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('749', '35', 'Friday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('750', '35', 'Friday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('751', '35', 'Saturday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('752', '35', 'Saturday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('753', '35', 'Saturday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('754', '35', 'Sunday', '08:00:00', '11:00:00', '30', 'Breakfast', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('755', '35', 'Sunday', '12:00:00', '17:00:00', '60', 'Lunch', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23'),
('756', '35', 'Sunday', '18:00:00', '22:00:00', '60', 'Dinner', '1', '2026-01-26 10:14:23', '2026-01-26 10:14:23');


-- 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=7 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 23:59:22', '2025-10-18 23:59:22', NULL),
('2', '5', NULL, '1', '2025-10-19 08:00:00', '1', NULL, 'Confirmed', 'Breakfast', '2025-10-19 00:27:06', '2025-10-19 00:27:06', NULL),
('3', '5', '8', '1', '2025-10-24 20:00:00', '4', 'Candle Light Dinner', 'Checked_In', 'Dinner', '2025-10-24 20:30:11', '2025-10-24 20:30:44', NULL),
('4', '5', NULL, '2', '2026-02-02 08:00:00', '1', 'qsqw', 'Confirmed', 'Breakfast', '2026-01-31 11:13:11', '2026-01-31 11:13:11', NULL);


-- Table structure for table `restapi_global_settings`
CREATE TABLE `restapi_global_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,
  `firebase_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `firebase_server_key` text DEFAULT NULL,
  `firebase_project_id` varchar(191) DEFAULT NULL,
  `firebase_service_account_json` varchar(191) DEFAULT NULL,
  `firebase_priority` varchar(10) NOT NULL DEFAULT 'high',
  `firebase_sound` varchar(50) NOT NULL DEFAULT 'default',
  `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 `restapi_global_settings`
INSERT INTO `restapi_global_settings` VALUES
('1', '65100125-205d-420e-b03c-0faa1e6f02b9', '2026-04-16 08:37:13', NULL, NULL, '1', '0', NULL, NULL, NULL, 'high', 'default', '2026-01-22 06:57:33', '2026-01-22 06:57:34');


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

-- Dumping data for table `restaurant_charges`
INSERT INTO `restaurant_charges` VALUES
('3', '34', 'Service Charge', 'percent', '10.00', '[\"dine_in\",\"delivery\",\"pickup\",\"room_service\"]', '1', '2026-03-22 01:06:58', '2026-03-22 01:06:58');


-- Table structure for table `restaurant_payments`
CREATE TABLE `restaurant_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `amount` decimal(16,2) NOT NULL,
  `status` enum('pending','paid','failed') NOT NULL DEFAULT 'pending',
  `payment_source` enum('official_site','app_sumo') NOT NULL DEFAULT 'official_site',
  `razorpay_order_id` varchar(191) DEFAULT NULL,
  `razorpay_payment_id` varchar(191) DEFAULT NULL,
  `razorpay_signature` varchar(191) DEFAULT NULL,
  `transaction_id` varchar(191) DEFAULT NULL,
  `reference_id` varchar(191) DEFAULT NULL,
  `payment_date_time` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `stripe_payment_intent` varchar(191) DEFAULT NULL,
  `stripe_session_id` text DEFAULT NULL,
  `package_id` bigint(20) unsigned DEFAULT NULL,
  `package_type` varchar(191) DEFAULT NULL,
  `currency_id` varchar(191) DEFAULT NULL,
  `flutterwave_transaction_id` varchar(191) DEFAULT NULL,
  `flutterwave_payment_ref` varchar(191) DEFAULT NULL,
  `paypal_payment_id` varchar(191) DEFAULT NULL,
  `mollie_payment_id` varchar(191) DEFAULT NULL,
  `mollie_customer_id` varchar(191) DEFAULT NULL,
  `mollie_subscription_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurant_payments_restaurant_id_foreign` (`restaurant_id`),
  KEY `restaurant_payments_package_id_foreign` (`package_id`),
  CONSTRAINT `restaurant_payments_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `restaurant_payments_restaurant_id_foreign` FOREIGN KEY (`restaurant_id`) REFERENCES `restaurants` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `restaurant_payments`
INSERT INTO `restaurant_payments` VALUES
('1', '26', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-07 23:00:56', '2025-11-07 23:00:56', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('2', '26', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-07 23:01:19', '2025-11-07 23:01:19', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('3', '26', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-08 13:10:02', '2025-11-08 13:10:02', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('4', '26', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-08 13:10:04', '2025-11-08 13:10:04', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('5', '27', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-11-08 16:03:13', '2025-11-08 16:03:13', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('6', '28', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:41:22', '2025-12-02 16:41:22', NULL, NULL, '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('7', '28', '49.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:41:45', '2025-12-02 16:41:45', NULL, NULL, '6', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('8', '28', '1990.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:42:26', '2025-12-02 16:42:26', NULL, NULL, '10', 'annual', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('9', '30', '99.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:52:04', '2025-12-02 16:52:04', NULL, NULL, '8', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('10', '30', '1990.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:52:37', '2025-12-02 16:52:37', NULL, NULL, '10', 'annual', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('11', '30', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 16:58:34', '2025-12-02 16:58:34', NULL, NULL, '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('12', '2', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 17:01:50', '2025-12-02 17:01:50', NULL, NULL, '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('13', '2', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 17:02:31', '2025-12-02 17:02:31', NULL, NULL, '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('14', '30', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 17:08:21', '2025-12-02 17:08:21', NULL, NULL, '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('15', '30', '1990.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 17:11:41', '2025-12-02 17:11:43', NULL, 'cs_live_a1josShXBAS2EeXWJbJgyU8EraTX1ggHCWdS7DfZ1sfbhWHBAl1igKOz36', '10', 'annual', '5', NULL, NULL, NULL, NULL, NULL, NULL),
('16', '30', '199.00', 'pending', 'official_site', NULL, NULL, NULL, NULL, NULL, NULL, '2025-12-02 17:18:42', '2025-12-02 17:18:43', NULL, 'cs_live_a1LVInwmOgKBO0dxS0CSrwwrUZnP1DyIL2Tbm4ttqd7jdXSagcELvkCrTc', '10', 'monthly', '5', NULL, NULL, NULL, NULL, NULL, NULL);


-- 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=4 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 18:31:44', '2025-09-20 18:31:44'),
('2', '34', '1234', 'GST', '2026-03-22 01:06:35', '2026-03-22 01:06:35'),
('3', '34', '5678', 'HST', '2026-03-22 01:06:35', '2026-03-22 01:06:35');


-- Table structure for table `restaurants`
CREATE TABLE `restaurants` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sub_domain` varchar(191) DEFAULT NULL,
  `name` varchar(191) NOT NULL,
  `hash` varchar(191) DEFAULT NULL,
  `address` varchar(191) DEFAULT NULL,
  `phone_number` varchar(191) DEFAULT NULL,
  `phone_code` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `timezone` varchar(191) NOT NULL,
  `time_format` varchar(191) NOT NULL DEFAULT 'h:i A',
  `date_format` varchar(191) NOT NULL DEFAULT 'd/m/Y',
  `theme_hex` varchar(191) NOT NULL,
  `theme_rgb` varchar(191) NOT NULL,
  `logo` varchar(191) DEFAULT NULL,
  `country_id` bigint(20) unsigned NOT NULL,
  `hide_new_orders` tinyint(1) NOT NULL DEFAULT 0,
  `hide_new_reservations` tinyint(1) NOT NULL DEFAULT 0,
  `hide_new_waiter_request` tinyint(1) NOT NULL DEFAULT 0,
  `currency_id` bigint(20) unsigned DEFAULT NULL,
  `license_type` enum('free','paid') NOT NULL DEFAULT 'free',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `ai_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `ai_daily_request_limit` int(11) NOT NULL DEFAULT 50,
  `ai_allowed_roles` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`ai_allowed_roles`)),
  `ai_monthly_tokens_used` int(11) NOT NULL DEFAULT 0,
  `ai_monthly_reset_at` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `customer_login_required` tinyint(1) NOT NULL DEFAULT 0,
  `about_us` longtext DEFAULT NULL,
  `allow_customer_delivery_orders` tinyint(1) NOT NULL DEFAULT 1,
  `allow_customer_pickup_orders` tinyint(1) NOT NULL DEFAULT 1,
  `pickup_days_range` int(11) DEFAULT 7,
  `allow_customer_orders` tinyint(1) NOT NULL DEFAULT 1,
  `allow_dine_in_orders` tinyint(1) NOT NULL DEFAULT 1,
  `show_veg` tinyint(1) NOT NULL DEFAULT 1,
  `show_halal` tinyint(1) NOT NULL DEFAULT 0,
  `package_id` bigint(20) unsigned DEFAULT NULL,
  `package_type` varchar(191) DEFAULT NULL,
  `status` enum('active','inactive','license_expired') NOT NULL DEFAULT 'active',
  `license_expire_on` datetime DEFAULT NULL,
  `count_sms` int(11) NOT NULL DEFAULT 0,
  `total_sms` int(11) NOT NULL DEFAULT -1,
  `trial_ends_at` datetime DEFAULT NULL,
  `license_updated_at` datetime DEFAULT NULL,
  `subscription_updated_at` datetime DEFAULT NULL,
  `stripe_id` varchar(191) DEFAULT NULL,
  `pm_type` varchar(191) DEFAULT NULL,
  `pm_last_four` varchar(4) DEFAULT NULL,
  `is_waiter_request_enabled` tinyint(1) NOT NULL DEFAULT 1,
  `default_table_reservation_status` varchar(191) NOT NULL DEFAULT 'Confirmed',
  `disable_slot_minutes` int(11) NOT NULL DEFAULT 30,
  `approval_status` enum('Pending','Approved','Rejected') NOT NULL DEFAULT 'Approved',
  `rejection_reason` text DEFAULT NULL,
  `facebook_link` varchar(255) DEFAULT NULL,
  `instagram_link` varchar(255) DEFAULT NULL,
  `twitter_link` varchar(255) DEFAULT NULL,
  `yelp_link` varchar(255) DEFAULT NULL,
  `wifi_name` varchar(191) DEFAULT NULL,
  `wifi_password` varchar(191) DEFAULT NULL,
  `show_wifi_icon` tinyint(1) NOT NULL DEFAULT 0,
  `table_required` tinyint(1) NOT NULL DEFAULT 0,
  `show_logo_text` tinyint(1) NOT NULL DEFAULT 1,
  `meta_keyword` text DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `upload_fav_icon_android_chrome_192` varchar(191) DEFAULT NULL,
  `upload_fav_icon_android_chrome_512` varchar(191) DEFAULT NULL,
  `upload_fav_icon_apple_touch_icon` varchar(191) DEFAULT NULL,
  `upload_favicon_16` varchar(191) DEFAULT NULL,
  `upload_favicon_32` varchar(191) DEFAULT NULL,
  `favicon` varchar(191) DEFAULT NULL,
  `is_waiter_request_enabled_on_desktop` tinyint(1) NOT NULL DEFAULT 1,
  `is_waiter_request_enabled_on_mobile` tinyint(1) NOT NULL DEFAULT 1,
  `is_waiter_request_enabled_open_by_qr` tinyint(1) NOT NULL DEFAULT 0,
  `webmanifest` varchar(191) DEFAULT NULL,
  `enable_tip_shop` tinyint(1) NOT NULL DEFAULT 1,
  `enable_tip_pos` tinyint(1) NOT NULL DEFAULT 1,
  `is_pwa_install_alert_show` tinyint(1) NOT NULL DEFAULT 0,
  `auto_confirm_orders` tinyint(1) NOT NULL DEFAULT 0,
  `auto_confirm_orders_before_payment` tinyint(1) NOT NULL DEFAULT 0,
  `auto_confirm_orders_after_payment` tinyint(1) NOT NULL DEFAULT 0,
  `restrict_qr_order_by_location` tinyint(1) NOT NULL DEFAULT 0,
  `qr_order_radius_meters` int(10) unsigned DEFAULT NULL,
  `show_order_type_options` tinyint(1) NOT NULL DEFAULT 1,
  `disable_order_type_popup` tinyint(1) NOT NULL DEFAULT 0,
  `default_order_type_id` bigint(20) unsigned DEFAULT NULL,
  `hide_menu_item_image_on_pos` tinyint(1) NOT NULL DEFAULT 0,
  `hide_menu_item_image_on_customer_site` tinyint(1) NOT NULL DEFAULT 0,
  `tax_mode` enum('order','item') NOT NULL DEFAULT 'order',
  `tax_inclusive` tinyint(1) NOT NULL DEFAULT 0,
  `customer_site_language` varchar(191) DEFAULT NULL,
  `enable_admin_reservation` tinyint(1) NOT NULL DEFAULT 1,
  `enable_customer_reservation` tinyint(1) NOT NULL DEFAULT 1,
  `minimum_party_size` int(11) NOT NULL DEFAULT 1,
  `table_lock_timeout_minutes` int(11) NOT NULL DEFAULT 10,
  `mollie_customer_id` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `restaurant_settings_country_id_foreign` (`country_id`),
  KEY `restaurant_settings_currency_id_foreign` (`currency_id`),
  KEY `restaurants_package_id_foreign` (`package_id`),
  KEY `restaurants_default_order_type_id_foreign` (`default_order_type_id`),
  CONSTRAINT `restaurant_settings_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE,
  CONSTRAINT `restaurant_settings_currency_id_foreign` FOREIGN KEY (`currency_id`) REFERENCES `currencies` (`id`) ON DELETE CASCADE,
  CONSTRAINT `restaurants_default_order_type_id_foreign` FOREIGN KEY (`default_order_type_id`) REFERENCES `order_types` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `restaurants_package_id_foreign` FOREIGN KEY (`package_id`) REFERENCES `packages` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `restaurants`
INSERT INTO `restaurants` VALUES
('1', 'demo.ewiidine.ca', 'Demo Restaurant', 'demo-restaurant', '56355 Matilde Hollow Apt. 268\nEast Novella, ID 87158', '+12158702241', NULL, 'demo.restaurant@example.com', 'America/New_York', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '1', 'free', '1', '0', '50', NULL, '0', NULL, '2025-09-17 11:06:43', '2025-10-17 05:30:03', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '1', '1', 'monthly', 'license_expired', '2025-11-17 00:00:00', '0', '-1', '2025-10-17 05:36:43', '2025-09-17 05:36:43', '2025-09-17 05:36:43', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.twitter.com/', NULL, NULL, NULL, '0', '1', '1', NULL, NULL, 'android-chrome-192x192.png', 'android-chrome-512x512.png', 'apple-touch-icon.png', 'favicon-16x16.png', 'favicon-32x32.png', 'favicon.ico', '1', '1', '1', NULL, '1', '1', '1', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('2', 'shaan-e-punjab.ewiidine.ca', 'Shaan-E-Punjab', 'shaan-e-punjab', 'Kosi Road', '8077708564', '91', 'agarwalanmol301@gmail.com', 'America/Toronto', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '9', 'free', '1', '0', '50', NULL, '0', '2026-04-01', '2025-09-17 15:32:45', '2026-03-20 22:28:32', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '10', 'monthly', 'active', '2026-04-20 00:00:00', '0', '-1', NULL, '2025-09-17 10:02:45', '2025-09-17 10:02:45', 'cus_TWvfsDs8vVXcfa', NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('3', 'louisiana.ewiidine.ca', 'Louisiana Restaurant', 'louisiana-restaurant', '1250 Boul René Lévesque O Bur 2200 Montreal,Québec H3B 4W8Canada\n', '5148158188', '1', 'mario.nicolas1210@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '14', 'free', '1', '0', '50', NULL, '0', NULL, '2025-09-20 18:26:44', '2025-10-20 05:30:03', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2025-11-20 00:00:00', '0', '-1', '2025-10-20 12:56:44', '2025-09-20 12:56:44', '2025-09-20 12:56:44', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('4', 'iim-lucknow.ewiidine.ca', 'IIML MESS', 'iiml-mess', 'IIM L MESS', '8840974810', '91', 'madh321@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#059669', '5, 150, 105', 'fe8a6d219504148863cf356c9b23c71a.jpeg', '103', '0', '0', '0', '16', 'free', '1', '0', '50', NULL, '0', '2026-03-01', '2025-10-07 20:30:09', '2026-02-02 00:00:04', '1', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '1', '1', 'monthly', 'license_expired', '2026-03-02 00:00:04', '0', '-1', NULL, '2025-10-07 15:00:09', '2025-10-07 15:00:09', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, 'IMSG', '12345678', '1', '1', '1', NULL, NULL, 'android-chrome-192x192.png', 'android-chrome-512x512.png', 'apple-touch-icon.png', 'favicon-16x16.png', 'favicon-32x32.png', 'favicon.ico', '1', '1', '1', NULL, '1', '1', '1', '1', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('26', 'sweet.ewiidine.ca', 'sindi sweet', 'sindi-sweet', 'sector 7', '7018146782', '91', 'singhdrivingchd@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '103', '0', '0', '0', '126', 'free', '1', '0', '50', NULL, '0', NULL, '2025-11-07 22:53:03', '2025-12-08 05:30:04', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-01-08 00:00:04', '0', '-1', '2025-12-07 17:23:03', '2025-11-08 07:45:45', '2025-11-08 07:45:45', 'cus_TNeoYpoQw3ldbQ', NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('27', 'anmoldhaba.ewiidine.ca', 'Anmol Da Dhaba', 'anmol-da-dhaba', 'ssss', '7017844175', '91', 'agarwalanmol01@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '103', '0', '0', '0', '134', 'free', '1', '0', '50', NULL, '0', NULL, '2025-11-08 16:02:26', '2025-12-28 10:03:29', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-01-09 00:00:04', '0', '-1', '2025-12-08 10:32:26', '2025-11-08 10:35:55', '2025-11-08 10:35:55', 'cus_TNvIKTw26JwFxU', NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, 'sdds', '11123221', '1', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('28', 'sagar121.ewiidine.ca', 'Sagar Da Dhaba', 'sagar-da-dhaba', 'ssss', '9917382214', '91', 'dfq121@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '139', 'free', '1', '0', '50', NULL, '0', NULL, '2025-11-12 19:45:50', '2025-12-12 05:30:04', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-01-12 00:00:00', '0', '-1', '2025-12-12 14:15:50', '2025-11-12 14:15:50', '2025-11-12 14:15:50', 'cus_TWvLKpyp20iEwE', NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('29', 'gopal.ewiidine.ca', 'Gopal Sweets', 'gopal-sweets', 'as', '5656565665', '91', 'golpalsweet@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '103', '0', '0', '0', '144', 'free', '1', '0', '50', NULL, '0', NULL, '2025-11-13 21:11:43', '2025-12-14 05:30:04', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-01-14 00:00:04', '0', '-1', '2025-12-13 15:41:43', '2025-11-13 15:43:17', '2025-11-13 15:43:17', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('30', 'testing.ewiidine.ca', 'Testing E Dhaba', 'testing-e-dhaba', 'tttttt', '1233333232', '91', 'testing@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '149', 'free', '1', '1', '50', '[\"owner\",\"admin\"]', '0', NULL, '2025-11-15 13:16:25', '2026-01-27 00:00:04', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-02-27 00:00:04', '0', '-1', NULL, '2025-11-15 07:50:28', '2025-11-15 07:50:28', 'cus_TWvVLALedwBh6G', NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('31', 'capricedesiles.ewiidine.ca', 'Caprice des iles', 'caprice-des-iles', '8905 Boul Perras', '5148158188', '1', 'legroupedmn@gmail.com', 'America/Toronto', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '154', 'free', '1', '0', '50', NULL, '0', NULL, '2025-12-29 00:56:09', '2025-12-29 01:19:36', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '10', 'annual', 'active', '2026-12-28 00:00:00', '0', '-1', NULL, '2025-12-28 19:26:09', '2025-12-28 19:26:09', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, 'Wifi', 'wixvuh-8fuPho-buxson', '1', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('32', 'capricesdesiles2.ewiidine.ca', 'Caprice des iles 2', 'caprice-des-iles-2', '1210 Ch Victoria', '5148158188', '1', 'nicolas_mario@hotmail.com', 'America/Toronto', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '159', 'free', '1', '0', '50', NULL, '0', '2026-03-01', '2025-12-31 00:13:23', '2026-01-30 00:00:04', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '1', 'monthly', 'license_expired', '2026-03-02 00:00:00', '0', '-1', '2026-01-30 00:13:23', '2025-12-31 00:13:23', '2025-12-31 00:13:23', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('33', 'mcjohnburgers.ewiidine.ca', 'McJohn Burgers', 'mcjohn-burgers', '83, Bleu Market, Montreal, Quebec', '88282821233', '91', 'sitw2021@gmail.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#4F46E5', '79, 70, 229', NULL, '40', '0', '0', '0', '164', 'free', '1', '0', '50', NULL, '0', NULL, '2026-01-22 10:24:08', '2026-01-22 10:24:08', '0', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '2', 'trial', 'active', '2026-02-21 10:24:08', '0', '-1', '2026-02-21 10:24:08', '2026-01-22 10:24:08', '2026-01-22 10:24:08', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL),
('34', 'mcjohnsonburgers.ewiidine.ca', 'McJohnson Burgers', 'mcjohnson-burgers', '84, Belu Market, Montreal, Quebec', '8028222121', '1671', 'mcjohnson@example.com', 'Asia/Kolkata', 'h:i A', 'd/m/Y', '#5a1c00', '90, 28, 0', '89ed5edd729ab9c9f6973a96a757439b.png', '40', '0', '0', '0', '169', 'free', '1', '0', '50', NULL, '0', '2026-02-01', '2026-01-26 10:14:23', '2026-03-22 00:48:20', '1', '<p class=\"text-lg text-gray-600 mb-6\">\n          Welcome to our restaurant, where great food and good vibes come together! We\'re a local, family-owned spot that loves bringing people together over delicious meals and unforgettable moments. Whether you\'re here for a quick bite, a family dinner, or a celebration, we\'re all about making your time with us special.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          Our menu is packed with dishes made from fresh, quality ingredients because we believe food should taste as\n          good as it makes you feel. From our signature dishes to seasonal specials, there\'s always something to excite\n          your taste buds.\n        </p>\n        <p class=\"text-lg text-gray-600 mb-6\">\n          But we\'re not just about the food—we\'re about community. We love seeing familiar faces and welcoming new ones.\n          Our team is a fun, friendly bunch dedicated to serving you with a smile and making sure every visit feels like\n          coming home.\n        </p>\n        <p class=\"text-lg text-gray-600\">\n          So, come on in, grab a seat, and let us take care of the rest. We can\'t wait to share our love of food with\n          you!\n        </p>\n        <p class=\"text-lg text-gray-800 font-semibold mt-6\">See you soon! 🍽️✨</p>', '1', '1', '7', '1', '1', '1', '0', '10', 'annual', 'active', '2027-01-27 00:00:00', '0', '-1', NULL, '2026-01-26 10:14:23', '2026-01-26 10:14:23', NULL, NULL, NULL, '1', 'Confirmed', '30', 'Approved', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '1', NULL, NULL, 'android-chrome-192x192.png', 'android-chrome-512x512.png', 'apple-touch-icon.png', 'favicon-16x16.png', 'favicon-32x32.png', 'favicon.ico', '1', '1', '0', NULL, '1', '1', '0', '0', '0', '0', '0', NULL, '1', '0', NULL, '0', '0', 'order', '0', 'en', '1', '1', '1', '10', NULL);


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

INSERT INTO `role_has_permissions` VALUES
('38', '50'),
('38', '51'),
('38', '54'),
('38', '55'),
('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'),
('39', '38'),
('39', '39'),
('39', '42'),
('39', '43'),
('39', '46'),
('39', '47'),
('39', '50'),
('39', '51'),
('39', '54'),
('39', '55'),
('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'),
('40', '38'),
('40', '39'),
('40', '42'),
('40', '43'),
('40', '46'),
('40', '47'),
('40', '50'),
('40', '51'),
('40', '54'),
('40', '55'),
('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'),
('41', '38'),
('41', '39'),
('41', '42'),
('41', '43'),
('41', '46'),
('41', '47'),
('41', '50'),
('41', '51'),
('41', '54'),
('41', '55'),
('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'),
('42', '38'),
('42', '39'),
('42', '42'),
('42', '43'),
('42', '46'),
('42', '47'),
('42', '50'),
('42', '51'),
('42', '54'),
('42', '55'),
('42', '58'),
('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'),
('43', '38'),
('43', '39'),
('43', '42'),
('43', '43'),
('43', '46'),
('43', '47'),
('43', '50'),
('43', '51'),
('43', '54'),
('43', '55'),
('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'),
('44', '38'),
('44', '39'),
('44', '42'),
('44', '43'),
('44', '46'),
('44', '47'),
('44', '50'),
('44', '51'),
('44', '54'),
('44', '55'),
('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'),
('45', '38'),
('45', '39'),
('45', '42'),
('45', '43'),
('45', '46'),
('45', '47'),
('45', '50'),
('45', '51'),
('45', '54'),
('45', '55'),
('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'),
('46', '38'),
('46', '39'),
('46', '42'),
('46', '43'),
('46', '46'),
('46', '47'),
('46', '50'),
('46', '51'),
('46', '54'),
('46', '55'),
('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'),
('47', '38'),
('47', '39'),
('47', '42'),
('47', '43'),
('47', '46'),
('47', '47'),
('47', '50'),
('47', '51'),
('47', '54'),
('47', '55'),
('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'),
('48', '38'),
('48', '39'),
('48', '42'),
('48', '43'),
('48', '46'),
('48', '47'),
('48', '50'),
('48', '51'),
('48', '54'),
('48', '55'),
('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'),
('49', '38'),
('49', '39'),
('49', '42'),
('49', '43'),
('49', '46'),
('49', '47'),
('49', '50'),
('49', '51'),
('49', '54'),
('49', '55'),
('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'),
('50', '38'),
('50', '39'),
('50', '42'),
('50', '43'),
('50', '46'),
('50', '47'),
('50', '50'),
('50', '51'),
('50', '54'),
('50', '55'),
('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'),
('51', '38'),
('51', '39'),
('51', '42'),
('51', '43'),
('51', '46'),
('51', '47'),
('51', '50'),
('51', '51'),
('51', '54'),
('51', '55'),
('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'),
('52', '38'),
('52', '39'),
('52', '42'),
('52', '43'),
('52', '46'),
('52', '47'),
('52', '50'),
('52', '51'),
('52', '54'),
('52', '55'),
('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'),
('53', '38'),
('53', '39'),
('53', '42'),
('53', '43'),
('53', '46'),
('53', '47'),
('53', '50'),
('53', '51'),
('53', '54'),
('53', '55'),
('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'),
('54', '38'),
('54', '39'),
('54', '42'),
('54', '43'),
('54', '46'),
('54', '47'),
('54', '50'),
('54', '51'),
('54', '54'),
('54', '55'),
('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'),
('55', '38'),
('55', '39'),
('55', '42'),
('55', '43'),
('55', '46'),
('55', '47'),
('55', '50'),
('55', '51'),
('55', '54'),
('55', '55'),
('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'),
('56', '38'),
('56', '39'),
('56', '42'),
('56', '43'),
('56', '46'),
('56', '47'),
('56', '50'),
('56', '51'),
('56', '54'),
('56', '55'),
('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'),
('57', '38'),
('57', '39'),
('57', '42'),
('57', '43'),
('57', '46'),
('57', '47'),
('57', '50'),
('57', '51'),
('57', '54'),
('57', '55'),
('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'),
('58', '38'),
('58', '39'),
('58', '42'),
('58', '43'),
('58', '46'),
('58', '47'),
('58', '50'),
('58', '51'),
('58', '54'),
('58', '55'),
('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'),
('59', '38'),
('59', '39'),
('59', '42'),
('59', '43'),
('59', '46'),
('59', '47'),
('59', '50'),
('59', '51'),
('59', '54'),
('59', '55'),
('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'),
('60', '38'),
('60', '39'),
('60', '42'),
('60', '43'),
('60', '46'),
('60', '47'),
('60', '50'),
('60', '51'),
('60', '54'),
('60', '55'),
('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'),
('61', '38'),
('61', '39'),
('61', '42'),
('61', '43'),
('61', '46'),
('61', '47'),
('61', '50'),
('61', '51'),
('61', '54'),
('61', '55'),
('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'),
('62', '38'),
('62', '39'),
('62', '42'),
('62', '43'),
('62', '46'),
('62', '47'),
('62', '50'),
('62', '51'),
('62', '54'),
('62', '55'),
('63', '2'),
('63', '3'),
('63', '6'),
('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'),
('63', '38'),
('63', '39'),
('63', '42'),
('63', '43'),
('63', '46'),
('63', '47'),
('63', '50'),
('63', '51'),
('63', '54'),
('63', '55'),
('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'),
('64', '38'),
('64', '39'),
('64', '42'),
('64', '43'),
('64', '46'),
('64', '47'),
('64', '50'),
('64', '51'),
('64', '54'),
('64', '55'),
('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'),
('65', '38'),
('65', '39'),
('65', '42'),
('65', '43'),
('65', '46'),
('65', '47'),
('65', '50'),
('65', '51'),
('65', '54'),
('65', '55'),
('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'),
('66', '38'),
('66', '39'),
('66', '42'),
('66', '43'),
('66', '46'),
('66', '47'),
('66', '50'),
('66', '51'),
('66', '54'),
('66', '55'),
('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'),
('67', '38'),
('67', '39'),
('67', '42'),
('67', '43'),
('67', '46'),
('67', '47'),
('67', '50'),
('67', '51'),
('67', '54'),
('67', '55'),
('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'),
('68', '38'),
('68', '39'),
('68', '42'),
('68', '43'),
('68', '46'),
('68', '47'),
('68', '50'),
('68', '51'),
('68', '54'),
('68', '55'),
('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'),
('69', '38'),
('69', '39'),
('69', '42'),
('69', '43'),
('69', '46'),
('69', '47'),
('69', '50'),
('69', '51'),
('69', '54'),
('69', '55'),
('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'),
('70', '38'),
('70', '39'),
('70', '42'),
('70', '43'),
('70', '46'),
('70', '47'),
('70', '50'),
('70', '51'),
('70', '54'),
('70', '55'),
('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'),
('71', '38'),
('71', '39'),
('71', '42'),
('71', '43'),
('71', '46'),
('71', '47'),
('71', '50'),
('71', '51'),
('71', '54'),
('71', '55'),
('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'),
('72', '38'),
('72', '39'),
('72', '42'),
('72', '43'),
('72', '46'),
('72', '47'),
('72', '50'),
('72', '51'),
('72', '54'),
('72', '55'),
('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'),
('73', '38'),
('73', '39'),
('73', '42'),
('73', '43'),
('73', '46'),
('73', '47'),
('73', '50'),
('73', '51'),
('73', '54'),
('73', '55'),
('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'),
('74', '38'),
('74', '39'),
('74', '42'),
('74', '43'),
('74', '46'),
('74', '47'),
('74', '50'),
('74', '51'),
('74', '54'),
('74', '55'),
('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'),
('75', '38'),
('75', '39'),
('75', '42'),
('75', '43'),
('75', '46'),
('75', '47'),
('75', '50'),
('75', '51'),
('75', '54'),
('75', '55'),
('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'),
('76', '38'),
('76', '39'),
('76', '42'),
('76', '43'),
('76', '46'),
('76', '47'),
('76', '50'),
('76', '51'),
('76', '54'),
('76', '55'),
('77', '2'),
('77', '3'),
('77', '6'),
('77', '7'),
('77', '10'),
('77', '11'),
('77', '14');

INSERT INTO `role_has_permissions` VALUES
('77', '15'),
('77', '22'),
('77', '23'),
('77', '26'),
('77', '27'),
('77', '30'),
('77', '31'),
('77', '34'),
('77', '35'),
('77', '38'),
('77', '39'),
('77', '42'),
('77', '43'),
('77', '46'),
('77', '47'),
('77', '50'),
('77', '51'),
('77', '54'),
('77', '55'),
('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'),
('78', '38'),
('78', '39'),
('78', '42'),
('78', '43'),
('78', '46'),
('78', '47'),
('78', '50'),
('78', '51'),
('78', '54'),
('78', '55'),
('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'),
('79', '38'),
('79', '39'),
('79', '42'),
('79', '43'),
('79', '46'),
('79', '47'),
('79', '50'),
('79', '51'),
('79', '54'),
('79', '55'),
('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'),
('80', '38'),
('80', '39'),
('80', '42'),
('80', '43'),
('80', '46'),
('80', '47'),
('80', '50'),
('80', '51'),
('80', '54'),
('80', '55'),
('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'),
('81', '38'),
('81', '39'),
('81', '42'),
('81', '43'),
('81', '46'),
('81', '47'),
('81', '50'),
('81', '51'),
('81', '54'),
('81', '55'),
('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'),
('82', '38'),
('82', '39'),
('82', '42'),
('82', '43'),
('82', '46'),
('82', '47'),
('82', '50'),
('82', '51'),
('82', '54'),
('82', '55'),
('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'),
('83', '38'),
('83', '39'),
('83', '42'),
('83', '43'),
('83', '46'),
('83', '47'),
('83', '50'),
('83', '51'),
('83', '54'),
('83', '55'),
('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'),
('84', '38'),
('84', '39'),
('84', '42'),
('84', '43'),
('84', '46'),
('84', '47'),
('84', '50'),
('84', '51'),
('84', '54'),
('84', '55'),
('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'),
('85', '38'),
('85', '39'),
('85', '42'),
('85', '43'),
('85', '46'),
('85', '47'),
('85', '50'),
('85', '51'),
('85', '54'),
('85', '55'),
('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'),
('86', '38'),
('86', '39'),
('86', '42'),
('86', '43'),
('86', '46'),
('86', '47'),
('86', '50'),
('86', '51'),
('86', '54'),
('86', '55'),
('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'),
('87', '38'),
('87', '39'),
('87', '42'),
('87', '43'),
('87', '46'),
('87', '47'),
('87', '50'),
('87', '51'),
('87', '54'),
('87', '55'),
('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'),
('88', '38'),
('88', '39'),
('88', '42'),
('88', '43'),
('88', '46'),
('88', '47'),
('88', '50'),
('88', '51'),
('88', '54'),
('88', '55'),
('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'),
('89', '38'),
('89', '39'),
('89', '42'),
('89', '43'),
('89', '46'),
('89', '47'),
('89', '50'),
('89', '51'),
('89', '54'),
('89', '55'),
('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'),
('90', '38'),
('90', '39'),
('90', '42'),
('90', '43'),
('90', '46'),
('90', '47'),
('90', '50'),
('90', '51'),
('90', '54'),
('90', '55'),
('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'),
('91', '38'),
('91', '39'),
('91', '42'),
('91', '43'),
('91', '46'),
('91', '47'),
('91', '50'),
('91', '51'),
('91', '54'),
('91', '55'),
('91', '58'),
('92', '2'),
('92', '3'),
('92', '6'),
('92', '7'),
('92', '10'),
('92', '11'),
('92', '14'),
('92', '15'),
('92', '22'),
('92', '23'),
('92', '26'),
('92', '27'),
('92', '30'),
('92', '31'),
('92', '34'),
('92', '35'),
('92', '38'),
('92', '39'),
('92', '42'),
('92', '43'),
('92', '46'),
('92', '47'),
('92', '50'),
('92', '51'),
('92', '54'),
('92', '55'),
('93', '2'),
('93', '6'),
('93', '10'),
('93', '14'),
('93', '22'),
('93', '26'),
('93', '30'),
('93', '34'),
('93', '38'),
('93', '42'),
('93', '46'),
('93', '50'),
('93', '51'),
('93', '54'),
('93', '55'),
('94', '2'),
('94', '6'),
('94', '10'),
('94', '14'),
('94', '22'),
('94', '26'),
('94', '30'),
('94', '34'),
('94', '38'),
('94', '42'),
('94', '46'),
('94', '50'),
('94', '51'),
('94', '54'),
('94', '55'),
('95', '2'),
('95', '6'),
('95', '10'),
('95', '14'),
('95', '22'),
('95', '26'),
('95', '30'),
('95', '34'),
('95', '38'),
('95', '42'),
('95', '46'),
('95', '50'),
('95', '51'),
('95', '54'),
('95', '55'),
('96', '2'),
('96', '6'),
('96', '10'),
('96', '14'),
('96', '22'),
('96', '26'),
('96', '30'),
('96', '34'),
('96', '38'),
('96', '42'),
('96', '46'),
('96', '50'),
('96', '51'),
('96', '54'),
('96', '55'),
('97', '2'),
('97', '6'),
('97', '10'),
('97', '14'),
('97', '22'),
('97', '26'),
('97', '30'),
('97', '34'),
('97', '38'),
('97', '42'),
('97', '46'),
('97', '50'),
('97', '51'),
('97', '54'),
('97', '55'),
('98', '2'),
('98', '6'),
('98', '10'),
('98', '14'),
('98', '22'),
('98', '26'),
('98', '30'),
('98', '34'),
('98', '38'),
('98', '42'),
('98', '46'),
('98', '50'),
('98', '54'),
('99', '2'),
('99', '6'),
('99', '10'),
('99', '14'),
('99', '22'),
('99', '26'),
('99', '30'),
('99', '34'),
('99', '38'),
('99', '42'),
('99', '46'),
('99', '50'),
('99', '54'),
('100', '2'),
('100', '6'),
('100', '10'),
('100', '14'),
('100', '22'),
('100', '26'),
('100', '30'),
('100', '34'),
('100', '38'),
('100', '42'),
('100', '46'),
('100', '50'),
('100', '54'),
('101', '2'),
('101', '6'),
('101', '10'),
('101', '14'),
('101', '22'),
('101', '26'),
('101', '30'),
('101', '34'),
('101', '38'),
('101', '42'),
('101', '46'),
('101', '50'),
('101', '54'),
('102', '2'),
('102', '6'),
('102', '10'),
('102', '14'),
('102', '22'),
('102', '26'),
('102', '30'),
('102', '34'),
('102', '38'),
('102', '42'),
('102', '46'),
('102', '50'),
('102', '54'),
('103', '2'),
('103', '6'),
('103', '10'),
('103', '14'),
('103', '22'),
('103', '26'),
('103', '30'),
('103', '34'),
('103', '38'),
('103', '42'),
('103', '46'),
('103', '50'),
('103', '54'),
('104', '1'),
('105', '1'),
('106', '1'),
('107', '1'),
('108', '1'),
('109', '1'),
('110', '1'),
('111', '1'),
('112', '1'),
('113', '1'),
('114', '1'),
('115', '1'),
('116', '1'),
('117', '1'),
('118', '1'),
('119', '1'),
('120', '1'),
('121', '2'),
('121', '3'),
('121', '6'),
('121', '7'),
('121', '10'),
('121', '11'),
('121', '14'),
('121', '15'),
('121', '22'),
('121', '23'),
('121', '26'),
('121', '27'),
('121', '30'),
('121', '31'),
('121', '34'),
('121', '35'),
('121', '38'),
('121', '39'),
('121', '42'),
('121', '43'),
('121', '46'),
('121', '47'),
('121', '50'),
('121', '51'),
('121', '54'),
('121', '55'),
('122', '2'),
('122', '3'),
('122', '6'),
('122', '7'),
('122', '10'),
('122', '11'),
('122', '14'),
('122', '15'),
('122', '22'),
('122', '23'),
('122', '26'),
('122', '27'),
('122', '30'),
('122', '31'),
('122', '34'),
('122', '35'),
('122', '38'),
('122', '39'),
('122', '42'),
('122', '43'),
('122', '46'),
('122', '47'),
('122', '50'),
('122', '51'),
('122', '54'),
('122', '55'),
('123', '2'),
('123', '3'),
('123', '6'),
('123', '7'),
('123', '10'),
('123', '11'),
('123', '14'),
('123', '15'),
('123', '22'),
('123', '23'),
('123', '26'),
('123', '27'),
('123', '30'),
('123', '31'),
('123', '34'),
('123', '35'),
('123', '38'),
('123', '39'),
('123', '42'),
('123', '43'),
('123', '46'),
('123', '47'),
('123', '50'),
('123', '51'),
('123', '54'),
('123', '55'),
('124', '2'),
('124', '3'),
('124', '6'),
('124', '7'),
('124', '10'),
('124', '11'),
('124', '14'),
('124', '15'),
('124', '22'),
('124', '23'),
('124', '26'),
('124', '27'),
('124', '30'),
('124', '31'),
('124', '34'),
('124', '35'),
('124', '38'),
('124', '39'),
('124', '42'),
('124', '43'),
('124', '46'),
('124', '47'),
('124', '50'),
('124', '51'),
('124', '54'),
('124', '55'),
('125', '2'),
('125', '3'),
('125', '6'),
('125', '7'),
('125', '10'),
('125', '11'),
('125', '14'),
('125', '15'),
('125', '22'),
('125', '23'),
('125', '26'),
('125', '27'),
('125', '30'),
('125', '31'),
('125', '34'),
('125', '35'),
('125', '38'),
('125', '39'),
('125', '42'),
('125', '43'),
('125', '46'),
('125', '47'),
('125', '50'),
('125', '51'),
('125', '54'),
('125', '55'),
('126', '2'),
('126', '3'),
('126', '6'),
('126', '7'),
('126', '10'),
('126', '11'),
('126', '14'),
('126', '15'),
('126', '22'),
('126', '23'),
('126', '26'),
('126', '27'),
('126', '30'),
('126', '31'),
('126', '34'),
('126', '35'),
('126', '38'),
('126', '39'),
('126', '42'),
('126', '43'),
('126', '46'),
('126', '47'),
('126', '50'),
('126', '51'),
('126', '54'),
('126', '55'),
('127', '2'),
('127', '3'),
('127', '6'),
('127', '7'),
('127', '10'),
('127', '11'),
('127', '14'),
('127', '15'),
('127', '22'),
('127', '23'),
('127', '26'),
('127', '27'),
('127', '30'),
('127', '31'),
('127', '34'),
('127', '35'),
('127', '38'),
('127', '39'),
('127', '42'),
('127', '43'),
('127', '46'),
('127', '47'),
('127', '50'),
('127', '51'),
('127', '54'),
('127', '55'),
('128', '2'),
('128', '3'),
('128', '6'),
('128', '7'),
('128', '10'),
('128', '11'),
('128', '14'),
('128', '15'),
('128', '22'),
('128', '23'),
('128', '26'),
('128', '27'),
('128', '30'),
('128', '31'),
('128', '34'),
('128', '35'),
('128', '38'),
('128', '39'),
('128', '42'),
('128', '43'),
('128', '46'),
('128', '47'),
('128', '50'),
('128', '51'),
('128', '54'),
('128', '55'),
('129', '2'),
('129', '3'),
('129', '6'),
('129', '7'),
('129', '10'),
('129', '11'),
('129', '14'),
('129', '15'),
('129', '22'),
('129', '23'),
('129', '26'),
('129', '27'),
('129', '30'),
('129', '31'),
('129', '34'),
('129', '35'),
('129', '38'),
('129', '39'),
('129', '42'),
('129', '43'),
('129', '46'),
('129', '47'),
('129', '50'),
('129', '51'),
('129', '54'),
('129', '55'),
('130', '2'),
('130', '3'),
('130', '6'),
('130', '7'),
('130', '10'),
('130', '11'),
('130', '14'),
('130', '15'),
('130', '22'),
('130', '23'),
('130', '26'),
('130', '27'),
('130', '30'),
('130', '31'),
('130', '34'),
('130', '35'),
('130', '38'),
('130', '39'),
('130', '42'),
('130', '43'),
('130', '46'),
('130', '47'),
('130', '50'),
('130', '51'),
('130', '54'),
('130', '55'),
('131', '2'),
('131', '3'),
('131', '6'),
('131', '7'),
('131', '10'),
('131', '11'),
('131', '14'),
('131', '15'),
('131', '22'),
('131', '23'),
('131', '26'),
('131', '27'),
('131', '30'),
('131', '31'),
('131', '34'),
('131', '35'),
('131', '38'),
('131', '39'),
('131', '42'),
('131', '43'),
('131', '46'),
('131', '47'),
('131', '50'),
('131', '51'),
('131', '54'),
('131', '55'),
('132', '2'),
('132', '3'),
('132', '6'),
('132', '7'),
('132', '10'),
('132', '11'),
('132', '14'),
('132', '15'),
('132', '22'),
('132', '23'),
('132', '26'),
('132', '27'),
('132', '30'),
('132', '31'),
('132', '34'),
('132', '35'),
('132', '38'),
('132', '39'),
('132', '42'),
('132', '43'),
('132', '46'),
('132', '47'),
('132', '50'),
('132', '51'),
('132', '54'),
('132', '55'),
('133', '2'),
('133', '3'),
('133', '6'),
('133', '7'),
('133', '10'),
('133', '11'),
('133', '14'),
('133', '15'),
('133', '22'),
('133', '23'),
('133', '26'),
('133', '27'),
('133', '30'),
('133', '31'),
('133', '34'),
('133', '35'),
('133', '38'),
('133', '39'),
('133', '42'),
('133', '43'),
('133', '46'),
('133', '47'),
('133', '50'),
('133', '51'),
('133', '54'),
('133', '55'),
('134', '2'),
('134', '3'),
('134', '6'),
('134', '7'),
('134', '10'),
('134', '11'),
('134', '14'),
('134', '15'),
('134', '22'),
('134', '23'),
('134', '26'),
('134', '27'),
('134', '30'),
('134', '31'),
('134', '34'),
('134', '35'),
('134', '38'),
('134', '39'),
('134', '42'),
('134', '43'),
('134', '46'),
('134', '47'),
('134', '50'),
('134', '51'),
('134', '54'),
('134', '55'),
('135', '2'),
('135', '3'),
('135', '6'),
('135', '7'),
('135', '10'),
('135', '11'),
('135', '14'),
('135', '15'),
('135', '22'),
('135', '23'),
('135', '26'),
('135', '27'),
('135', '30'),
('135', '31'),
('135', '34'),
('135', '35'),
('135', '38'),
('135', '39'),
('135', '42'),
('135', '43'),
('135', '46'),
('135', '47'),
('135', '50'),
('135', '51'),
('135', '54'),
('135', '55'),
('136', '2'),
('136', '3'),
('136', '6'),
('136', '7'),
('136', '10'),
('136', '11'),
('136', '14'),
('136', '15'),
('136', '22'),
('136', '23'),
('136', '26'),
('136', '27'),
('136', '30'),
('136', '31'),
('136', '34'),
('136', '35'),
('136', '38'),
('136', '39'),
('136', '42'),
('136', '43'),
('136', '46'),
('136', '47'),
('136', '50'),
('136', '51'),
('136', '54'),
('136', '55'),
('137', '2'),
('137', '3'),
('137', '6'),
('137', '7');

INSERT INTO `role_has_permissions` VALUES
('137', '10'),
('137', '11'),
('137', '14'),
('137', '15'),
('137', '22'),
('137', '23'),
('137', '26'),
('137', '27'),
('137', '30'),
('137', '31'),
('137', '34'),
('137', '35'),
('137', '38'),
('137', '39'),
('137', '42'),
('137', '43'),
('137', '46'),
('137', '47'),
('137', '50'),
('137', '51'),
('137', '54'),
('137', '55'),
('138', '2'),
('138', '3'),
('138', '6'),
('138', '7'),
('138', '10'),
('138', '11'),
('138', '14'),
('138', '15'),
('138', '22'),
('138', '23'),
('138', '26'),
('138', '27'),
('138', '30'),
('138', '31'),
('138', '34'),
('138', '35'),
('138', '38'),
('138', '39'),
('138', '42'),
('138', '43'),
('138', '46'),
('138', '47'),
('138', '50'),
('138', '51'),
('138', '54'),
('138', '55'),
('139', '2'),
('139', '3'),
('139', '6'),
('139', '7'),
('139', '10'),
('139', '11'),
('139', '14'),
('139', '15'),
('139', '22'),
('139', '23'),
('139', '26'),
('139', '27'),
('139', '30'),
('139', '31'),
('139', '34'),
('139', '35'),
('139', '38'),
('139', '39'),
('139', '42'),
('139', '43'),
('139', '46'),
('139', '47'),
('139', '50'),
('139', '51'),
('139', '54'),
('139', '55'),
('140', '2'),
('140', '3'),
('140', '6'),
('140', '7'),
('140', '10'),
('140', '11'),
('140', '14'),
('140', '15'),
('140', '22'),
('140', '23'),
('140', '26'),
('140', '27'),
('140', '30'),
('140', '31'),
('140', '34'),
('140', '35'),
('140', '38'),
('140', '39'),
('140', '42'),
('140', '43'),
('140', '46'),
('140', '47'),
('140', '50'),
('140', '51'),
('140', '54'),
('140', '55'),
('141', '2'),
('141', '3'),
('141', '6'),
('141', '7'),
('141', '10'),
('141', '11'),
('141', '14'),
('141', '15'),
('141', '22'),
('141', '23'),
('141', '26'),
('141', '27'),
('141', '30'),
('141', '31'),
('141', '34'),
('141', '35'),
('141', '38'),
('141', '39'),
('141', '42'),
('141', '43'),
('141', '46'),
('141', '47'),
('141', '50'),
('141', '51'),
('141', '54'),
('141', '55'),
('142', '2'),
('142', '3'),
('142', '6'),
('142', '7'),
('142', '10'),
('142', '11'),
('142', '14'),
('142', '15'),
('142', '22'),
('142', '23'),
('142', '26'),
('142', '27'),
('142', '30'),
('142', '31'),
('142', '34'),
('142', '35'),
('142', '38'),
('142', '39'),
('142', '42'),
('142', '43'),
('142', '46'),
('142', '47'),
('142', '50'),
('142', '51'),
('142', '54'),
('142', '55'),
('143', '2'),
('143', '3'),
('143', '6'),
('143', '7'),
('143', '10'),
('143', '11'),
('143', '14'),
('143', '15'),
('143', '22'),
('143', '23'),
('143', '26'),
('143', '27'),
('143', '30'),
('143', '31'),
('143', '34'),
('143', '35'),
('143', '38'),
('143', '39'),
('143', '42'),
('143', '43'),
('143', '46'),
('143', '47'),
('143', '50'),
('143', '51'),
('143', '54'),
('143', '55'),
('144', '2'),
('144', '3'),
('144', '6'),
('144', '7'),
('144', '10'),
('144', '11'),
('144', '14'),
('144', '15'),
('144', '22'),
('144', '23'),
('144', '26'),
('144', '27'),
('144', '30'),
('144', '31'),
('144', '34'),
('144', '35'),
('144', '38'),
('144', '39'),
('144', '42'),
('144', '43'),
('144', '46'),
('144', '47'),
('144', '50'),
('144', '51'),
('144', '54'),
('144', '55'),
('145', '2'),
('145', '3'),
('145', '6'),
('145', '7'),
('145', '10'),
('145', '11'),
('145', '14'),
('145', '15'),
('145', '22'),
('145', '23'),
('145', '26'),
('145', '27'),
('145', '30'),
('145', '31'),
('145', '34'),
('145', '35'),
('145', '38'),
('145', '39'),
('145', '42'),
('145', '43'),
('145', '46'),
('145', '47'),
('145', '50'),
('145', '51'),
('145', '54'),
('145', '55'),
('146', '2'),
('146', '3'),
('146', '6'),
('146', '7'),
('146', '10'),
('146', '11'),
('146', '14'),
('146', '15'),
('146', '22'),
('146', '23'),
('146', '26'),
('146', '27'),
('146', '30'),
('146', '31'),
('146', '34'),
('146', '35'),
('146', '38'),
('146', '39'),
('146', '42'),
('146', '43'),
('146', '46'),
('146', '47'),
('146', '50'),
('146', '51'),
('146', '54'),
('146', '55'),
('147', '2'),
('147', '3'),
('147', '6'),
('147', '7'),
('147', '10'),
('147', '11'),
('147', '14'),
('147', '15'),
('147', '22'),
('147', '23'),
('147', '26'),
('147', '27'),
('147', '30'),
('147', '31'),
('147', '34'),
('147', '35'),
('147', '38'),
('147', '39'),
('147', '42'),
('147', '43'),
('147', '46'),
('147', '47'),
('147', '50'),
('147', '51'),
('147', '54'),
('147', '55'),
('148', '2'),
('148', '3'),
('148', '6'),
('148', '7'),
('148', '10'),
('148', '11'),
('148', '14'),
('148', '15'),
('148', '22'),
('148', '23'),
('148', '26'),
('148', '27'),
('148', '30'),
('148', '31'),
('148', '34'),
('148', '35'),
('148', '38'),
('148', '39'),
('148', '42'),
('148', '43'),
('148', '46'),
('148', '47'),
('148', '50'),
('148', '51'),
('148', '54'),
('148', '55'),
('149', '2'),
('149', '3'),
('149', '6'),
('149', '7'),
('149', '10'),
('149', '11'),
('149', '14'),
('149', '15'),
('149', '22'),
('149', '23'),
('149', '26'),
('149', '27'),
('149', '30'),
('149', '31'),
('149', '34'),
('149', '35'),
('149', '38'),
('149', '39'),
('149', '42'),
('149', '43'),
('149', '46'),
('149', '47'),
('149', '50'),
('149', '51'),
('149', '54'),
('149', '55'),
('150', '2'),
('150', '3'),
('150', '6'),
('150', '7'),
('150', '10'),
('150', '11'),
('150', '14'),
('150', '15'),
('150', '22'),
('150', '23'),
('150', '26'),
('150', '27'),
('150', '30'),
('150', '31'),
('150', '34'),
('150', '35'),
('150', '38'),
('150', '39'),
('150', '42'),
('150', '43'),
('150', '46'),
('150', '47'),
('150', '50'),
('150', '51'),
('150', '54'),
('150', '55'),
('151', '2'),
('151', '3'),
('151', '6'),
('151', '7'),
('151', '10'),
('151', '11'),
('151', '14'),
('151', '15'),
('151', '22'),
('151', '23'),
('151', '26'),
('151', '27'),
('151', '30'),
('151', '31'),
('151', '34'),
('151', '35'),
('151', '38'),
('151', '39'),
('151', '42'),
('151', '43'),
('151', '46'),
('151', '47'),
('151', '50'),
('151', '51'),
('151', '54'),
('151', '55'),
('152', '2'),
('152', '3'),
('152', '6'),
('152', '7'),
('152', '10'),
('152', '11'),
('152', '14'),
('152', '15'),
('152', '22'),
('152', '23'),
('152', '26'),
('152', '27'),
('152', '30'),
('152', '31'),
('152', '34'),
('152', '35'),
('152', '38'),
('152', '39'),
('152', '42'),
('152', '43'),
('152', '46'),
('152', '47'),
('152', '50'),
('152', '51'),
('152', '54'),
('152', '55'),
('153', '2'),
('153', '3'),
('153', '6'),
('153', '7'),
('153', '10'),
('153', '11'),
('153', '14'),
('153', '15'),
('153', '22'),
('153', '23'),
('153', '26'),
('153', '27'),
('153', '30'),
('153', '31'),
('153', '34'),
('153', '35'),
('153', '38'),
('153', '39'),
('153', '42'),
('153', '43'),
('153', '46'),
('153', '47'),
('153', '50'),
('153', '51'),
('153', '54'),
('153', '55'),
('154', '2'),
('154', '3'),
('154', '6'),
('154', '7'),
('154', '10'),
('154', '11'),
('154', '14'),
('154', '15'),
('154', '22'),
('154', '23'),
('154', '26'),
('154', '27'),
('154', '30'),
('154', '31'),
('154', '34'),
('154', '35'),
('154', '38'),
('154', '39'),
('154', '42'),
('154', '43'),
('154', '46'),
('154', '47'),
('154', '50'),
('154', '51'),
('154', '54'),
('154', '55'),
('155', '2'),
('155', '3'),
('155', '6'),
('155', '7'),
('155', '10'),
('155', '11'),
('155', '14'),
('155', '15'),
('155', '22'),
('155', '23'),
('155', '26'),
('155', '27'),
('155', '30'),
('155', '31'),
('155', '34'),
('155', '35'),
('155', '38'),
('155', '39'),
('155', '42'),
('155', '43'),
('155', '46'),
('155', '47'),
('155', '50'),
('155', '51'),
('155', '54'),
('155', '55'),
('156', '2'),
('156', '3'),
('156', '6'),
('156', '7'),
('156', '10'),
('156', '11'),
('156', '14'),
('156', '15'),
('156', '22'),
('156', '23'),
('156', '26'),
('156', '27'),
('156', '30'),
('156', '31'),
('156', '34'),
('156', '35'),
('156', '38'),
('156', '39'),
('156', '42'),
('156', '43'),
('156', '46'),
('156', '47'),
('156', '50'),
('156', '51'),
('156', '54'),
('156', '55'),
('157', '2'),
('157', '3'),
('157', '6'),
('157', '7'),
('157', '10'),
('157', '11'),
('157', '14'),
('157', '15'),
('157', '22'),
('157', '23'),
('157', '26'),
('157', '27'),
('157', '30'),
('157', '31'),
('157', '34'),
('157', '35'),
('157', '38'),
('157', '39'),
('157', '42'),
('157', '43'),
('157', '46'),
('157', '47'),
('157', '50'),
('157', '51'),
('157', '54'),
('157', '55'),
('158', '2'),
('158', '3'),
('158', '6'),
('158', '7'),
('158', '10'),
('158', '11'),
('158', '14'),
('158', '15'),
('158', '22'),
('158', '23'),
('158', '26'),
('158', '27'),
('158', '30'),
('158', '31'),
('158', '34'),
('158', '35'),
('158', '38'),
('158', '39'),
('158', '42'),
('158', '43'),
('158', '46'),
('158', '47'),
('158', '50'),
('158', '51'),
('158', '54'),
('158', '55'),
('159', '2'),
('159', '3'),
('159', '6'),
('159', '7'),
('159', '10'),
('159', '11'),
('159', '14'),
('159', '15'),
('159', '22'),
('159', '23'),
('159', '26'),
('159', '27'),
('159', '30'),
('159', '31'),
('159', '34'),
('159', '35'),
('159', '38'),
('159', '39'),
('159', '42'),
('159', '43'),
('159', '46'),
('159', '47'),
('159', '50'),
('159', '51'),
('159', '54'),
('159', '55'),
('160', '2'),
('160', '3'),
('160', '6'),
('160', '7'),
('160', '10'),
('160', '11'),
('160', '14'),
('160', '15'),
('160', '22'),
('160', '23'),
('160', '26'),
('160', '27'),
('160', '30'),
('160', '31'),
('160', '34'),
('160', '35'),
('160', '38'),
('160', '39'),
('160', '42'),
('160', '43'),
('160', '46'),
('160', '47'),
('160', '50'),
('160', '51'),
('160', '54'),
('160', '55'),
('161', '2'),
('161', '3'),
('161', '6'),
('161', '7'),
('161', '10'),
('161', '11'),
('161', '14'),
('161', '15'),
('161', '22'),
('161', '23'),
('161', '26'),
('161', '27'),
('161', '30'),
('161', '31'),
('161', '34'),
('161', '35'),
('161', '38'),
('161', '39'),
('161', '42'),
('161', '43'),
('161', '46'),
('161', '47'),
('161', '50'),
('161', '51'),
('161', '54'),
('161', '55'),
('162', '2'),
('162', '3'),
('162', '6'),
('162', '7'),
('162', '10'),
('162', '11'),
('162', '14'),
('162', '15'),
('162', '22'),
('162', '23'),
('162', '26'),
('162', '27'),
('162', '30'),
('162', '31'),
('162', '34'),
('162', '35'),
('162', '38'),
('162', '39'),
('162', '42'),
('162', '43'),
('162', '46'),
('162', '47'),
('162', '50'),
('162', '51'),
('162', '54'),
('162', '55'),
('163', '2'),
('163', '3'),
('163', '6'),
('163', '7'),
('163', '10'),
('163', '11'),
('163', '14'),
('163', '15'),
('163', '22'),
('163', '23'),
('163', '26'),
('163', '27'),
('163', '30'),
('163', '31'),
('163', '34'),
('163', '35'),
('163', '38'),
('163', '39'),
('163', '42'),
('163', '43'),
('163', '46'),
('163', '47'),
('163', '50'),
('163', '51'),
('163', '54'),
('163', '55');


-- 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=67 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 11:06:43', '2025-09-17 11:06:43', NULL),
('2', 'Admin_1', 'Admin', 'web', '2025-09-17 11:06:44', '2025-09-17 11:06:44', '1'),
('3', 'Branch Head_1', 'Branch Head', 'web', '2025-09-17 11:06:44', '2025-09-17 11:06:44', '1'),
('4', 'Waiter_1', 'Waiter', 'web', '2025-09-17 11:06:44', '2025-09-17 11:06:44', '1'),
('5', 'Chef_1', 'Chef', 'web', '2025-09-17 11:06:44', '2025-09-17 11:06:44', '1'),
('6', 'Admin_2', 'Admin', 'web', '2025-09-17 15:32:45', '2025-09-17 15:32:45', '2'),
('7', 'Branch Head_2', 'Branch Head', 'web', '2025-09-17 15:32:45', '2025-09-17 15:32:45', '2'),
('8', 'Waiter_2', 'Waiter', 'web', '2025-09-17 15:32:45', '2025-09-17 15:32:45', '2'),
('9', 'Chef_2', 'Chef', 'web', '2025-09-17 15:32:45', '2025-09-17 15:32:45', '2'),
('10', 'Admin_3', 'Admin', 'web', '2025-09-20 18:26:45', '2025-09-20 18:26:45', '3'),
('11', 'Branch Head_3', 'Branch Head', 'web', '2025-09-20 18:26:45', '2025-09-20 18:26:45', '3'),
('12', 'Waiter_3', 'Waiter', 'web', '2025-09-20 18:26:45', '2025-09-20 18:26:45', '3'),
('13', 'Chef_3', 'Chef', 'web', '2025-09-20 18:26:45', '2025-09-20 18:26:45', '3'),
('14', 'Admin_4', 'Admin', 'web', '2025-10-07 20:30:09', '2025-10-07 20:30:09', '4'),
('15', 'Branch Head_4', 'Branch Head', 'web', '2025-10-07 20:30:09', '2025-10-07 20:30:09', '4'),
('16', 'Waiter_4', 'Waiter', 'web', '2025-10-07 20:30:09', '2025-10-07 20:30:09', '4'),
('17', 'Chef_4', 'Chef', 'web', '2025-10-07 20:30:09', '2025-10-07 20:30:09', '4'),
('22', 'Admin_26', 'Admin', 'web', '2025-11-07 22:53:04', '2025-11-07 22:53:04', '26'),
('23', 'Branch Head_26', 'Branch Head', 'web', '2025-11-07 22:53:04', '2025-11-07 22:53:04', '26'),
('24', 'Waiter_26', 'Waiter', 'web', '2025-11-07 22:53:04', '2025-11-07 22:53:04', '26'),
('25', 'Chef_26', 'Chef', 'web', '2025-11-07 22:53:04', '2025-11-07 22:53:04', '26'),
('26', 'Admin_27', 'Admin', 'web', '2025-11-08 16:02:27', '2025-11-08 16:02:27', '27'),
('27', 'Branch Head_27', 'Branch Head', 'web', '2025-11-08 16:02:27', '2025-11-08 16:02:27', '27'),
('28', 'Waiter_27', 'Waiter', 'web', '2025-11-08 16:02:27', '2025-11-08 16:02:27', '27'),
('29', 'Chef_27', 'Chef', 'web', '2025-11-08 16:02:27', '2025-11-08 16:02:27', '27'),
('30', 'Admin_28', 'Admin', 'web', '2025-11-12 19:45:51', '2025-11-12 19:45:51', '28'),
('31', 'Branch Head_28', 'Branch Head', 'web', '2025-11-12 19:45:51', '2025-11-12 19:45:51', '28'),
('32', 'Waiter_28', 'Waiter', 'web', '2025-11-12 19:45:51', '2025-11-12 19:45:51', '28'),
('33', 'Chef_28', 'Chef', 'web', '2025-11-12 19:45:51', '2025-11-12 19:45:51', '28'),
('34', 'Admin_29', 'Admin', 'web', '2025-11-13 21:11:44', '2025-11-13 21:11:44', '29'),
('35', 'Branch Head_29', 'Branch Head', 'web', '2025-11-13 21:11:44', '2025-11-13 21:11:44', '29'),
('36', 'Waiter_29', 'Waiter', 'web', '2025-11-13 21:11:44', '2025-11-13 21:11:44', '29'),
('37', 'Chef_29', 'Chef', 'web', '2025-11-13 21:11:44', '2025-11-13 21:11:44', '29'),
('38', 'Admin_30', 'Admin', 'web', '2025-11-15 13:16:25', '2025-11-15 13:16:25', '30'),
('39', 'Branch Head_30', 'Branch Head', 'web', '2025-11-15 13:16:25', '2025-11-15 13:16:25', '30'),
('40', 'Waiter_30', 'Waiter', 'web', '2025-11-15 13:16:25', '2025-11-15 13:16:25', '30'),
('41', 'Chef_30', 'Chef', 'web', '2025-11-15 13:16:25', '2025-11-15 13:16:25', '30'),
('42', 'Admin_31', 'Admin', 'web', '2025-12-29 00:56:10', '2025-12-29 00:56:10', '31'),
('43', 'Branch Head_31', 'Branch Head', 'web', '2025-12-29 00:56:10', '2025-12-29 00:56:10', '31'),
('44', 'Waiter_31', 'Waiter', 'web', '2025-12-29 00:56:10', '2025-12-29 00:56:10', '31'),
('45', 'Chef_31', 'Chef', 'web', '2025-12-29 00:56:10', '2025-12-29 00:56:10', '31'),
('46', 'Admin_32', 'Admin', 'web', '2025-12-31 00:13:24', '2025-12-31 00:13:24', '32'),
('47', 'Branch Head_32', 'Branch Head', 'web', '2025-12-31 00:13:24', '2025-12-31 00:13:24', '32'),
('48', 'Waiter_32', 'Waiter', 'web', '2025-12-31 00:13:24', '2025-12-31 00:13:24', '32'),
('49', 'Chef_32', 'Chef', 'web', '2025-12-31 00:13:24', '2025-12-31 00:13:24', '32'),
('50', 'Admin_33', 'Admin', 'web', '2026-01-22 10:24:09', '2026-01-22 10:24:09', '33'),
('51', 'Branch Head_33', 'Branch Head', 'web', '2026-01-22 10:24:09', '2026-01-22 10:24:09', '33'),
('52', 'Waiter_33', 'Waiter', 'web', '2026-01-22 10:24:09', '2026-01-22 10:24:09', '33'),
('53', 'Chef_33', 'Chef', 'web', '2026-01-22 10:24:09', '2026-01-22 10:24:09', '33'),
('54', 'Admin_34', 'Admin', 'web', '2026-01-26 10:14:24', '2026-01-26 10:14:24', '34'),
('55', 'Branch Head_34', 'Branch Head', 'web', '2026-01-26 10:14:24', '2026-01-26 10:14:24', '34'),
('56', 'Waiter_34', 'Waiter', 'web', '2026-01-26 10:14:24', '2026-01-26 10:14:24', '34'),
('57', 'Chef_34', 'Chef', 'web', '2026-01-26 10:14:24', '2026-01-26 10:14:24', '34'),
('58', 'Receptionist_34', 'Receptionist', 'web', '2026-01-27 12:32:44', '2026-01-27 12:32:44', '34');


-- 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
('6DIdZqbrU8wyq2ePYsbgYsc5Gy8qJTUjieTENSF0', '1', '171.61.17.149', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.2 Safari/605.1.15', '[encoded data, 18584 characters]', '1774196707'),
('cmKfyAxvWftKqiH6c4Lhypzrp3sdChChPPy3CsRH', '1', '171.61.17.149', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.2 Safari/605.1.15', '[encoded data, 151064 characters]', '1774195603'),
('eeJit3L7zqAPKIyuUWH2629nN9RQMW2zCFssqUbx', NULL, '74.208.165.42', 'curl/8.8.0', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiR002am5xZ3c0SDluakJJaWF6RmdEV2pGdk9qY0NycHR2ZHBhMTlUUyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1774194489'),
('EimYmZFbMHgEWubXbfIIdw8iYXqEj3EN1P7IZs5w', NULL, '171.61.17.149', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_1) AppleWebKit/601.2.4 (KHTML, like Gecko) Version/9.0.1 Safari/601.2.4 facebookexternalhit/1.1 Facebot Twitterbot/1.0', 'YTo3OntzOjY6Il90b2tlbiI7czo0MDoiNzV1TkttRDNpV3d6TTlCdVh1bVNvUnN6SjJEaFJuM0VpUzkxeXRxRiI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyODoiaHR0cHM6Ly94em9kby5pbmZvL2Rhc2hib2FyZCI7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI0OiJodHRwczovL3h6b2RvLmluZm8vbG9naW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjIwOiJjaGVja19taWdyYXRlX3N0YXR1cyI7czo0OiJHb29kIjtzOjE1OiJjdXN0b21lcl9pc19ydGwiO2k6MDtzOjQ6InVzZXIiO047fQ==', '1774188237'),
('tqs7UOUeRqSb0KE1b7CsygKhJRDb02unBclls6Hj', NULL, '74.208.165.42', 'curl/8.8.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkpiSThpTmdJbUtacXVxZnlGZXlqREQzUFFqYW4zcmdROXBselRBOCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1774194926');


