-- 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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('56', '2'),
('56', '3'),
('56', '6'),
('56', '7'),
('56', '10');

INSERT INTO `role_has_permissions` VALUES
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('77', '2'),
('77', '3'),
('77', '6'),
('77', '7'),
('77', '10'),
('77', '11'),
('77', '14'),
('77', '15'),
('77', '22'),
('77', '23'),
('77', '26'),
('77', '27'),
('77', '30'),
('77', '31'),
('77', '34'),
('77', '35'),
('77', '38'),
('77', '39'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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');


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

-- Dumping data for table `roles`
INSERT INTO `roles` VALUES
('1', 'Super Admin', 'Super Admin', 'web', '2025-09-17 05:36:43', '2025-09-17 05:36:43', NULL),
('2', 'Admin_1', 'Admin', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('3', 'Branch Head_1', 'Branch Head', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('4', 'Waiter_1', 'Waiter', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('5', 'Chef_1', 'Chef', 'web', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '1'),
('6', 'Admin_2', 'Admin', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('7', 'Branch Head_2', 'Branch Head', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('8', 'Waiter_2', 'Waiter', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('9', 'Chef_2', 'Chef', 'web', '2025-09-17 10:02:45', '2025-09-17 10:02:45', '2'),
('10', 'Admin_3', 'Admin', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('11', 'Branch Head_3', 'Branch Head', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('12', 'Waiter_3', 'Waiter', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('13', 'Chef_3', 'Chef', 'web', '2025-09-20 12:56:45', '2025-09-20 12:56:45', '3'),
('14', 'Admin_4', 'Admin', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('15', 'Branch Head_4', 'Branch Head', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('16', 'Waiter_4', 'Waiter', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('17', 'Chef_4', 'Chef', 'web', '2025-10-07 15:00:09', '2025-10-07 15:00:09', '4'),
('22', 'Admin_26', 'Admin', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('23', 'Branch Head_26', 'Branch Head', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('24', 'Waiter_26', 'Waiter', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('25', 'Chef_26', 'Chef', 'web', '2025-11-07 17:23:04', '2025-11-07 17:23:04', '26'),
('26', 'Admin_27', 'Admin', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('27', 'Branch Head_27', 'Branch Head', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('28', 'Waiter_27', 'Waiter', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('29', 'Chef_27', 'Chef', 'web', '2025-11-08 10:32:27', '2025-11-08 10:32:27', '27'),
('30', 'Admin_28', 'Admin', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('31', 'Branch Head_28', 'Branch Head', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('32', 'Waiter_28', 'Waiter', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('33', 'Chef_28', 'Chef', 'web', '2025-11-12 14:15:51', '2025-11-12 14:15:51', '28'),
('34', 'Admin_29', 'Admin', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('35', 'Branch Head_29', 'Branch Head', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('36', 'Waiter_29', 'Waiter', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('37', 'Chef_29', 'Chef', 'web', '2025-11-13 15:41:44', '2025-11-13 15:41:44', '29'),
('38', 'Admin_30', 'Admin', 'web', '2025-11-15 07:46:25', '2025-11-15 07:46:25', '30'),
('39', 'Branch Head_30', 'Branch Head', 'web', '2025-11-15 07:46:25', '2025-11-15 07:46:25', '30'),
('40', 'Waiter_30', 'Waiter', 'web', '2025-11-15 07:46:25', '2025-11-15 07:46:25', '30'),
('41', 'Chef_30', 'Chef', 'web', '2025-11-15 07:46:25', '2025-11-15 07:46:25', '30');


-- 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
('1m9PGxr0eMgvhSAbo0v07QItpE1h9s2zTXh0mBiF', NULL, '144.76.32.238', 'Mozilla/5.0 (compatible; SERankingBacklinksBot/1.0; +https://seranking.com/backlinks-crawler)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTElOb3VuWER4STc3MTZUN3hPTWtuYW4xaDU2cGE2QWN1U3ZtcGQ5cyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765651987'),
('1w7hvN15Sh9GhISIYXDY3sAIaGaRdK6hfSiZArDy', NULL, '159.89.174.87', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTEJ1V01XSTh6NkJycG5UOVhoSjIzNFRoYmxEY1RuYW1GY2pMUUxuWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765658176'),
('5QsGtmVIcmslbKgO7lEjhxXL8M5Xv7O5hClDLk9X', NULL, '100.30.248.17', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 Edg/130.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMWM2ckFid0xJZVNUcktOZlFSRmdDTjJiOHZIQ05INjBaSzluR092dSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly93d3cuYXV0b2Rpc2NvdmVyLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765635960'),
('5WOmpJGagDCtGvaWiU6hLO07GApAzm9DKJfBB4Iy', NULL, '51.161.65.193', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWXpQaXlTMDNPWnpzN2F3c0FWTkpUc1hnM1VEMVAxUmdHRmdWY1lySSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765648696'),
('7y8J8CxmAcuA8guBXExBIgAUsKfLToxmPtn6NLmA', NULL, '49.51.183.15', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoicVo0RDJRTFVXYWZQMUFPNm9odWxZb21zQzh1WnpXZGlMU2x0Q3BDRSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765663743'),
('7ZwgGhMcdydUxVCUYCwzkHR8URksmMi8J49jqtmt', NULL, '66.249.79.34', 'Mozilla/5.0 (Linux; Android 6.0.1; Nexus 5X Build/MMB29P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.7390.122 Mobile Safari/537.36 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiM1FYOGI3Q2xlNERwd2pvTHk0VDBlMkllTm1VQWxiMDFXSzlRUnhyTyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765635565'),
('8UQ9sriyKyj0ejMBbj1mw3jv5Lk5eyM0y2ahwL0r', NULL, '43.157.46.118', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaDlKNUV0QXN2cE9OTVQyMlFQVUtKWUVxcFpyam1jeG5tYzVXUm82ZiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765650479'),
('8VoDoYVxHjPYVgDUoHeET5ABBApZasoBwdXMPSnG', NULL, '64.226.65.160', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoib2ZONXVBY21jZWNyT3hVM1A0Qm80bjBZZkNmN0dGb1pvWGlXaU5CMiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765652930'),
('9svAh406qjQLh6kVKUIDrmIVeOqvZTuE15jH1FL3', NULL, '198.235.24.154', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicTNsbGlnTjBSODVWZ2RrMUxMVHVQcTVLZjdUN1NwUnI0MG5RTWxkciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly93ZWJkaXNrLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765666461'),
('aouSQWbtO02CCVrJIbbAxYYiydBZPCtKog1xk3uC', NULL, '100.30.248.17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMEtDY3ZrS2lDenJ0b1VRMFpwblc5NDVUbjFUbFVrcEFGb2R1SWt6UiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly93d3cubWFpbC5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765635961'),
('bswQeCJOIec6xCsR3cmk1D54ah3Rprspbne30DDN', NULL, '159.89.174.87', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUzRUQ3JCMHVHWTJmZFUwZkJzZlVzVHJvSGlTZXhzWHR5akE2T1VxbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765658176'),
('cmUvsGstPm0Lv3ENV0aOYcQjIOkT9U2DRkc8UkYH', NULL, '100.30.248.17', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoib3VUTlVvOGFsdWtwVExJc3YwYkJHb1pMOVBZT2VHM1k2cHVlMEx5ZCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly93d3cuY3Bjb250YWN0cy5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765635960'),
('ctKm7303dUOVv9R9EME9noAtoRQ3itO2jOPfjgPE', NULL, '54.39.89.166', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaktUQXEzMnZzWEtndlVPbDNkdUY3S2I0cHVseWkwRXhVbklBbjVnbyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vZXdpaWRpbmUuY2EvP0M9RCUzQk8lM0RBIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765638215'),
('Dm6AD0ENu1o2OPEUYtXV4rDQ7DcqDc76Qt7rqB0r', NULL, '144.76.32.238', 'Mozilla/5.0 (compatible; SERankingBacklinksBot/1.0; +https://seranking.com/backlinks-crawler)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoieHh3eThNcnRKbU9HaXBXVEs5RGxBQ3NLUXhsZWVaOVlVbUhnZmwwZSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765646031'),
('DxfQ5ek1Zam8E0LLwUy4gPC8WhjGj5Nu6Xyu34w9', NULL, '46.105.39.49', 'Mozilla/5.0 (compatible; MJ12bot/v2.0.4; http://mj12bot.com/)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiMG5oaXNiNnVlcnZFSzFjUW41UU14aENNbWx5Q3FTejdjT3E3Ump1dSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765638687'),
('f9z8z4SCW98XqStYKKWQvCC12yxCjcwyUtaRnS9F', NULL, '147.185.132.100', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUhlbjVrT2h0TWZ1alZIaHRIZjRIV2tCUXdsclBIYTd1SXdGWXdNNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly9tYWlsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765641449'),
('ipWSEkUItSCC4NerguUIXWfuBhtEeZ1v50mUDp8J', NULL, '198.235.24.113', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUzdXd3IySHN3Sjc2emlGVzdVWFVLVHhSY0w2RzNaNmQ1aDY1TldNYSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765639102'),
('KwNItUky1iDWR8s1k2kHez9kQTmuXYwo7mIxV54i', NULL, '100.30.248.17', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/132.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoidEYzWnJoaHRqbW1XUjU0NjZXUXhCdG9tRnBLcDdOWjg3VG41d3ZHNiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765635961'),
('lD2apqvYkv045gRnVbjX8DfmUwE81wZG8yOz1xO9', NULL, '100.30.248.17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:141.0) Gecko/20100101 Firefox/141.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoia1BiNWkzb3BxQ3RVbU9YNkxRN1hFbzhaYTl6UlpncXJDV2RaVmtUVCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765673312'),
('lrRBIo7WygAiUZQ6l0JX9uNyzU0Z8hOMs1wRKi7i', NULL, '49.7.227.204', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWFJEc3RBRzNHcEZVMk9sbzdsTWtCNzBXRkl2WmllQVdHbjJtaHJZcSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765638427'),
('MMIbEtvuMX6IZreMM2Izzc4wmv5sTPySEA66wCHQ', NULL, '43.153.76.247', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWEVzdzFzWGloOXBpUkN0RDl0MkJYdTlaNnR1SGxPNUVBOFg0cGJaMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjA6Imh0dHA6Ly9tLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765654797'),
('mP9v8TShV61t78OCPMWepTQwBIARs1rpbr9xRyOg', NULL, '64.226.65.160', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQXZHZWx3TExSQVZWR09uYkkxSm9UVjluQWF1b3BKcXV4YVlEOE5VOSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765652929'),
('npTwmAR28CVZTLTb9rol6afUEa3UvvaMkPGQ1mob', NULL, '43.152.72.247', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUTJ3YVlVU0w1NTFGZkt0aERNNkZZRUh3WWNPRk5CTGJFRUIzTklCOCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTg6Imh0dHA6Ly9ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765641449'),
('Oc6JA10ecdRGqlNCgsVDtROWULkKYaPEb616wazg', NULL, '100.30.248.17', 'Mozilla/5.0 (X11; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiVjFWQVprSFdodW45WnQ4bE5UVzdFWllicE1QazdXQ0VzVzludGdzbCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cud2VibWFpbC5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765635960'),
('PLUbVAomOdKGsokwQREqJLqLC7PN0DXwnP8aiUZ8', NULL, '182.44.10.67', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiYjNGMXRMRXJ5TVZQaTFPU2JybGdwNW0xMVFVcHdZQnY5YnFuNERjRCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765660927'),
('q8moP0O0avdk6HrgcFDbMbF7iqpc4D2tRWWer0Jz', NULL, '64.226.65.160', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiT0tKU2ZHdHRVcDdPUDlVdGF5Y2RXbTNkMW9uc2tKQUx2M0pkWTFtZCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTc6Imh0dHBzOi8vd3d3LmV3aWlkaW5lLmNhLz9yZXN0X3JvdXRlPSUyRndwJTJGdjIlMkZ1c2VycyUyRiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765652973'),
('rlJVW0LTBoQbjUNqzWXHcLtSsY054yUSrqDE0Xsg', NULL, '100.30.248.17', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiaDBOckwxMERnaGttRGpMTGU2VzJxbFpnQkdWNElsWVFvZUpEaEpoTSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cud2ViZGlzay5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765635961'),
('rpZFNxm2iNBvzrclP1MuMKHqgtctQbWwgKQn6PjL', NULL, '198.235.24.19', '', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSEtjWmlxWTJoZEwyemhZZDRDcm0wc1dNMTZVaDBkcW9kUGdGc01meCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly9jcGNhbGVuZGFycy5ld2lpZGluZS5jYSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', '1765652506'),
('Sb2qtBPvpYZjRmfzxGUgTa3bwbL6kWaxYHzo8F7z', NULL, '205.210.31.45', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoibWdQNEdDMzdsVmJ5WVR6dnJDNzdBc29rNWtzdVU1aXFaS2pUaU1oUyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765650231'),
('utyybDB7ECfRwBpwBMSWHWVC329GlPqmYyqeVCpM', NULL, '205.210.31.132', '', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoidzVhWks1ZklBSXNLV0JYaTBaSWNxejRuSFpSUm1rWHpOSTFKb3M0ZyI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MTk6Imh0dHBzOi8vZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765668679'),
('UVdyptd2Std2OsajsJDvpy6vrBsZYr6oCvZyvsM1', NULL, '100.30.248.17', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiWGZoeTBzb2NyUG04OW1SUEFDWXo4SXAyZnh5cWdDZ1dib1h2QVhlNCI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly93d3cuY3BhbmVsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765635961'),
('vo9cHDJOw0wkC5iTE8VLweqVq1fvIR15YSuP8l8L', NULL, '159.89.174.87', 'Mozilla/5.0 (l9scan/2.0.2343e2536313e2830323e24373; +https://leakix.net)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRkw1Q0Z6ZWhyc1JRclZ1ZWtzbHBDcXVwWmgxbUVwcElPMlBEQXRGcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHA6Ly9jcGFuZWwuZXdpaWRpbmUuY2EvP3Jlc3Rfcm91dGU9JTJGd3AlMkZ2MiUyRnVzZXJzJTJGIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765658223'),
('W0a7gHTxy6ji9tgLn19Lq1PkeULXqbEduFsWlXA0', NULL, '100.30.248.17', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36 Edg/130.0.0.0', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiTHZFUjhQQmtDVTBqNDV4UmpSWTdRWmZEaTVmMGV4d0xZZUJzaDJRbiI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly93d3cuY3BjYWxlbmRhcnMuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765635960'),
('YA7hHgEWzXKzT2Qtg3cUlFI4kIS7YEyg1vOOn5qO', '7', '106.219.150.122', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/26.1 Safari/605.1.15', '[encoded data, 164200 characters]', '1765640028'),
('yOtBPcAPHeXLKyAZXTu1jNdXRZlhQlsNSV1zktgH', NULL, '43.157.95.239', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiQ3N0bG1wbnJwdGludjNrQnlIQnJTbUhrREVRTUZERFBUMEdSMTZHUSI7czoyMDoiY2hlY2tfbWlncmF0ZV9zdGF0dXMiO3M6NDoiR29vZCI7czoxNToiY3VzdG9tZXJfaXNfcnRsIjtiOjA7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly93d3cuZXdpaWRpbmUuY2EiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', '1765673043'),
('ZYrbPHAPVkD6pPSrwSiUFqiiohVRSua6p7zbeTNw', NULL, '35.239.255.232', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUTlTVVd1dTMySHJnRHVvVDRJd3pIakxydmx2SlpjNnBOVzlaTnJqayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjM6Imh0dHA6Ly9tYWlsLmV3aWlkaW5lLmNhIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1765634077');


-- Table structure for table `sms_global_settings`
CREATE TABLE `sms_global_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `license_type` varchar(20) DEFAULT NULL,
  `purchase_code` varchar(191) DEFAULT NULL,
  `purchased_on` timestamp NULL DEFAULT NULL,
  `supported_until` timestamp NULL DEFAULT NULL,
  `notify_update` tinyint(1) NOT NULL DEFAULT 1,
  `vonage_api_key` varchar(191) DEFAULT NULL,
  `vonage_api_secret` varchar(191) DEFAULT NULL,
  `vonage_from_number` varchar(191) DEFAULT NULL,
  `msg91_auth_key` varchar(191) DEFAULT NULL,
  `msg91_from` varchar(191) DEFAULT NULL,
  `vonage_status` tinyint(1) NOT NULL DEFAULT 0,
  `msg91_status` tinyint(1) NOT NULL DEFAULT 0,
  `phone_verification_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `sms_global_settings`
INSERT INTO `sms_global_settings` VALUES
('1', NULL, '65100125-205d-420e-b03c-0faa1e6f02b9', NULL, '2026-04-16 03:07:13', '1', NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '2025-10-25 07:22:09', '2025-10-25 07:22:10');


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

-- Dumping data for table `sms_notification_settings`
INSERT INTO `sms_notification_settings` VALUES
('61', '26', 'reservation_confirmed', 'no', NULL, NULL),
('62', '26', 'order_bill_sent', 'no', NULL, NULL),
('63', '26', 'send_otp', 'no', NULL, NULL),
('64', '27', 'reservation_confirmed', 'no', NULL, NULL),
('65', '27', 'order_bill_sent', 'no', NULL, NULL),
('66', '27', 'send_otp', 'no', NULL, NULL),
('67', '28', 'reservation_confirmed', 'no', NULL, NULL),
('68', '28', 'order_bill_sent', 'no', NULL, NULL),
('69', '28', 'send_otp', 'no', NULL, NULL),
('70', '29', 'reservation_confirmed', 'no', NULL, NULL),
('71', '29', 'order_bill_sent', 'no', NULL, NULL),
('72', '29', 'send_otp', 'no', NULL, NULL),
('73', '30', 'reservation_confirmed', 'no', NULL, NULL),
('74', '30', 'order_bill_sent', 'no', NULL, NULL),
('75', '30', 'send_otp', 'no', NULL, NULL);


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

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


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


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


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


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


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

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


-- Table structure for table `superadmin_payment_gateways`
CREATE TABLE `superadmin_payment_gateways` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `razorpay_type` enum('test','live') NOT NULL DEFAULT 'test',
  `test_razorpay_key` text DEFAULT NULL,
  `test_razorpay_secret` text DEFAULT NULL,
  `razorpay_test_webhook_key` text DEFAULT NULL,
  `live_razorpay_key` text DEFAULT NULL,
  `live_razorpay_secret` text DEFAULT NULL,
  `razorpay_live_webhook_key` text DEFAULT NULL,
  `razorpay_status` tinyint(1) NOT NULL DEFAULT 0,
  `stripe_type` enum('test','live') NOT NULL DEFAULT 'test',
  `test_stripe_key` text DEFAULT NULL,
  `test_stripe_secret` text DEFAULT NULL,
  `stripe_test_webhook_key` text DEFAULT NULL,
  `live_stripe_key` text DEFAULT NULL,
  `live_stripe_secret` text DEFAULT NULL,
  `stripe_live_webhook_key` text DEFAULT NULL,
  `stripe_status` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `flutterwave_status` tinyint(1) NOT NULL DEFAULT 0,
  `flutterwave_type` enum('test','live') NOT NULL DEFAULT 'test',
  `test_flutterwave_key` text DEFAULT NULL,
  `test_flutterwave_secret` text DEFAULT NULL,
  `test_flutterwave_hash` text DEFAULT NULL,
  `flutterwave_test_webhook_key` text DEFAULT NULL,
  `live_flutterwave_key` text DEFAULT NULL,
  `live_flutterwave_secret` text DEFAULT NULL,
  `live_flutterwave_hash` text DEFAULT NULL,
  `flutterwave_live_webhook_key` text DEFAULT NULL,
  `live_paypal_client_id` varchar(191) DEFAULT NULL,
  `live_paypal_secret` varchar(191) DEFAULT NULL,
  `test_paypal_client_id` varchar(191) DEFAULT NULL,
  `test_paypal_secret` varchar(191) DEFAULT NULL,
  `paypal_status` tinyint(1) NOT NULL DEFAULT 0,
  `paypal_mode` enum('sandbox','live') NOT NULL DEFAULT 'sandbox',
  `live_payfast_merchant_id` varchar(191) DEFAULT NULL,
  `live_payfast_merchant_key` varchar(191) DEFAULT NULL,
  `live_payfast_passphrase` varchar(191) DEFAULT NULL,
  `test_payfast_merchant_id` varchar(191) DEFAULT NULL,
  `test_payfast_merchant_key` varchar(191) DEFAULT NULL,
  `test_payfast_passphrase` varchar(191) DEFAULT NULL,
  `payfast_mode` enum('sandbox','live') NOT NULL DEFAULT 'sandbox',
  `payfast_status` tinyint(1) NOT NULL DEFAULT 0,
  `live_paystack_key` varchar(191) DEFAULT NULL,
  `live_paystack_secret` varchar(191) DEFAULT NULL,
  `live_paystack_merchant_email` varchar(191) DEFAULT NULL,
  `test_paystack_key` varchar(191) DEFAULT NULL,
  `test_paystack_secret` varchar(191) DEFAULT NULL,
  `test_paystack_merchant_email` varchar(191) DEFAULT NULL,
  `paystack_payment_url` varchar(191) DEFAULT 'https://api.paystack.co',
  `paystack_status` tinyint(1) NOT NULL DEFAULT 0,
  `paystack_mode` enum('sandbox','live') NOT NULL DEFAULT 'sandbox',
  `xendit_status` tinyint(1) NOT NULL DEFAULT 0,
  `xendit_mode` enum('sandbox','live') NOT NULL DEFAULT 'sandbox',
  `test_xendit_public_key` varchar(191) DEFAULT NULL,
  `test_xendit_secret_key` varchar(191) DEFAULT NULL,
  `live_xendit_public_key` varchar(191) DEFAULT NULL,
  `live_xendit_secret_key` varchar(191) DEFAULT NULL,
  `test_xendit_webhook_token` varchar(191) DEFAULT NULL,
  `live_xendit_webhook_token` varchar(191) DEFAULT NULL,
  `paddle_status` tinyint(1) NOT NULL DEFAULT 0,
  `paddle_mode` enum('sandbox','live') NOT NULL DEFAULT 'sandbox',
  `test_paddle_vendor_id` varchar(191) DEFAULT NULL,
  `test_paddle_api_key` text DEFAULT NULL,
  `test_paddle_public_key` varchar(191) DEFAULT NULL,
  `test_paddle_client_token` text DEFAULT NULL,
  `live_paddle_vendor_id` varchar(191) DEFAULT NULL,
  `live_paddle_api_key` text DEFAULT NULL,
  `live_paddle_public_key` varchar(191) DEFAULT NULL,
  `live_paddle_client_token` text DEFAULT NULL,
  `paddle_webhook_secret` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `superadmin_payment_gateways`
INSERT INTO `superadmin_payment_gateways` VALUES
('1', 'test', 'rzp_test_RQdDra7yIuOJeq', 'B6NmZq351REJutdXNVVBBmaI', 'B6NmZq351REJutdXNVVBBmaI', NULL, NULL, NULL, '0', 'live', NULL, NULL, NULL, 'pk_live_51NPGeNILSMCMpdPIttt5OliSTx7PkaO7YNEjtPrQUQwYAu0qj3bibRPYoeeajzgzDPLhJjAFM528rr6HuO6r4hJO00qG1VilaK', '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', 'whsec_HqFoF3ek3uglplK22JZdJBAeUheRLTYf', '1', '2025-09-17 05:36:40', '2025-12-02 11:20:21', '0', 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, 'sandbox', '0', NULL, NULL, NULL, NULL, NULL, NULL, 'https://api.paystack.co', '0', 'sandbox', '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
('2', 'test', NULL, NULL, NULL, NULL, NULL, NULL, '0', 'test', NULL, NULL, NULL, NULL, NULL, NULL, '0', '2025-09-17 05:36:44', '2025-09-17 05:36:44', '0', 'test', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, 'sandbox', '0', NULL, NULL, NULL, NULL, NULL, NULL, 'https://api.paystack.co', '0', 'sandbox', '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, '0', 'sandbox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);


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

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


-- Table structure for table `support_access_logs`
CREATE TABLE `support_access_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `restaurant_id` bigint(20) unsigned NOT NULL,
  `performed_by_user_id` bigint(20) unsigned NOT NULL,
  `action_type` varchar(255) NOT NULL DEFAULT 'login_access',
  `ip_address` varchar(45) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `support_logs_restaurant_index` (`restaurant_id`),
  KEY `support_logs_user_index` (`performed_by_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `support_access_logs`
INSERT INTO `support_access_logs` VALUES
('1', '2', '10', 'login_access', '106.78.30.180', '2025-12-01 12:11:46', '2025-12-01 12:11:46'),
('2', '2', '10', 'login_access', '106.78.30.180', '2025-12-01 12:12:00', '2025-12-01 12:12:00'),
('3', '2', '19', 'login_access', '106.78.30.180', '2025-12-01 12:29:12', '2025-12-01 12:29:12'),
('4', '2', '19', 'login_access', '106.78.30.180', '2025-12-01 12:38:09', '2025-12-01 12:38:09'),
('5', '2', '19', 'login_access', '152.59.84.134', '2025-12-01 15:26:12', '2025-12-01 15:26:12'),
('6', '2', '19', 'login_access', '47.15.222.87', '2025-12-01 17:33:46', '2025-12-01 17:33:46'),
('7', '4', '20', 'login_access', '106.219.147.205', '2025-12-01 17:41:19', '2025-12-01 17:41:19'),
('8', '4', '20', 'login_access', '106.219.147.205', '2025-12-01 17:45:23', '2025-12-01 17:45:23'),
('9', '4', '19', 'login_access', '47.15.222.87', '2025-12-01 17:53:36', '2025-12-01 17:53:36'),
('10', '2', '19', 'login_access', '152.59.84.91', '2025-12-02 06:53:06', '2025-12-02 06:53:06'),
('11', '2', '19', 'login_access', '152.59.84.60', '2025-12-02 09:24:44', '2025-12-02 09:24:44'),
('12', '2', '19', 'login_access', '152.59.82.25', '2025-12-02 11:52:04', '2025-12-02 11:52:04'),
('13', '2', '19', 'login_access', '152.59.82.25', '2025-12-02 11:52:53', '2025-12-02 11:52:53'),
('14', '4', '20', 'login_access', '106.219.146.98', '2025-12-05 19:41:27', '2025-12-05 19:41:27');


-- Table structure for table `table_sessions`
CREATE TABLE `table_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned NOT NULL,
  `table_id` bigint(20) unsigned NOT NULL,
  `locked_by_user_id` bigint(20) unsigned DEFAULT NULL,
  `locked_at` datetime DEFAULT NULL,
  `last_activity_at` datetime DEFAULT NULL,
  `session_token` varchar(191) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `table_sessions_session_token_unique` (`session_token`),
  KEY `table_sessions_branch_id_foreign` (`branch_id`),
  KEY `table_sessions_locked_by_user_id_foreign` (`locked_by_user_id`),
  KEY `table_sessions_table_id_locked_by_user_id_index` (`table_id`,`locked_by_user_id`),
  KEY `table_sessions_last_activity_at_index` (`last_activity_at`),
  CONSTRAINT `table_sessions_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `table_sessions_locked_by_user_id_foreign` FOREIGN KEY (`locked_by_user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `table_sessions_table_id_foreign` FOREIGN KEY (`table_id`) REFERENCES `tables` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `table_sessions`
INSERT INTO `table_sessions` VALUES
('1', '5', '6', NULL, NULL, NULL, NULL, '2025-10-15 12:33:51', '2025-10-17 10:46:38'),
('2', '5', '5', NULL, NULL, NULL, NULL, '2025-10-17 10:46:49', '2025-12-10 10:06:46'),
('3', '5', '8', NULL, NULL, NULL, NULL, '2025-10-24 15:02:18', '2025-10-24 15:16:29'),
('4', '5', '7', NULL, NULL, NULL, NULL, '2025-10-24 15:11:55', '2025-10-24 15:12:11'),
('5', '5', '9', NULL, NULL, NULL, NULL, '2025-10-25 13:31:04', '2025-10-25 13:31:10'),
('6', '3', '1', NULL, NULL, NULL, NULL, '2025-12-02 06:58:46', '2025-12-02 08:15:53'),
('7', '31', '144', NULL, NULL, NULL, NULL, '2025-12-05 20:17:37', '2025-12-05 20:17:43'),
('8', '5', '34', NULL, NULL, NULL, NULL, '2025-12-10 09:55:50', '2025-12-10 10:06:46');


-- Table structure for table `tables`
CREATE TABLE `tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` bigint(20) unsigned DEFAULT NULL,
  `table_code` varchar(191) NOT NULL,
  `hash` varchar(191) NOT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `available_status` enum('available','reserved','running') NOT NULL DEFAULT 'available',
  `area_id` bigint(20) unsigned NOT NULL,
  `seating_capacity` tinyint(3) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tables_area_id_foreign` (`area_id`),
  KEY `tables_branch_id_foreign` (`branch_id`),
  CONSTRAINT `tables_area_id_foreign` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `tables_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table `tables`
INSERT INTO `tables` VALUES
('1', '3', 'T01', 'fcfbd6476d8e9ec95bb92e8498cbcdee', 'active', 'available', '1', '4', '2025-09-20 12:24:08', '2025-09-20 12:27:46'),
('2', '3', 'R01', 'be9d3861e8d1be145d574b5cb2b7e473', 'active', 'available', '2', '6', '2025-09-20 12:24:21', '2025-09-20 12:24:21'),
('3', '4', 'T01', '4b5072f687db888baa5f463dafb2fe97', 'active', 'available', '3', '4', '2025-09-20 12:58:07', '2025-09-20 12:58:07'),
('4', '4', 'G01', 'ff6390377199c9342938d37fdb1ee0d7', 'active', 'available', '4', '6', '2025-09-20 12:58:41', '2025-09-20 12:58:41'),
('5', '5', 'TO1', 'e07033b963e90a0d76f13aa1b72a1918', 'active', 'available', '6', '6', '2025-10-07 15:01:13', '2025-12-10 10:04:33'),
('6', '5', 'T02', '56353c6704324fda7014c3b83881af2d', 'active', 'running', '6', '3', '2025-10-07 15:39:05', '2025-10-15 12:34:09'),
('7', '5', 'R01', 'a6397c3e4dcacbc0d6f821f4786bf247', 'active', 'running', '7', '4', '2025-10-24 14:51:31', '2025-10-25 07:08:51'),
('8', '5', 'R02', '8b7bfb7948df49e4b7e2d689f9b2e6e7', 'active', 'available', '7', '6', '2025-10-24 14:51:45', '2025-10-31 14:51:08'),
('9', '5', 'F01', 'd4d6d65b2390bcd87ef2a52d58f4b149', 'active', 'available', '8', '4', '2025-10-25 13:02:44', '2025-10-25 13:31:10'),
('10', '5', 'F02', '2183e8faab7eca23a1dee84afb48ded5', 'active', 'available', '8', '8', '2025-10-25 13:03:55', '2025-10-25 13:03:55'),
('11', '5', 'TO3', '2ca62a7226cd97637ce8d287370237de', 'active', 'running', '6', '4', '2025-11-12 08:50:38', '2025-12-07 12:20:24'),
('12', '29', 'XYZ', '761fdf8f846ded49367f745115c23a44', 'active', 'available', '9', '5', '2025-11-12 14:20:16', '2025-11-12 14:20:16'),
('13', '27', '332', 'd44c5c8ffac09367faceb8c9741d9eb1', 'active', 'available', '10', '56', '2025-11-15 13:14:03', '2025-11-15 13:14:03'),
('14', '3', 'T-01', 'b4dd06b6d69314c27a211740cd689502', 'active', 'available', '1', '4', '2025-12-02 08:30:15', '2025-12-02 08:30:15'),
('15', '3', 'T-02', '4e093da89df7e96b78057f9b9236e633', 'active', 'available', '1', '4', '2025-12-02 08:30:15', '2025-12-02 08:30:15'),
('16', '3', 'T-03', '1fb591a7bae56a585c3db586e154d01d', 'active', 'available', '1', '4', '2025-12-02 08:30:15', '2025-12-02 08:30:15'),
('17', '3', 'T-04', '8ccb9f86d949303c7290ae134ecbe830', 'active', 'available', '1', '4', '2025-12-02 08:30:15', '2025-12-02 08:30:15'),
('18', '3', 'T-05', 'fab99bebc6e6023586846b0c6f4a20d6', 'active', 'available', '1', '4', '2025-12-02 08:30:15', '2025-12-02 08:30:15'),
('19', '3', 'T-06', 'fb06b8be16bd75c9e67c00eb38e424dc', 'active', 'available', '1', '4', '2025-12-02 08:30:16', '2025-12-02 08:30:16'),
('20', '3', 'T-07', '50664a894956806afce89d54b8aea4a5', 'active', 'available', '1', '4', '2025-12-02 08:30:16', '2025-12-02 08:30:16'),
('21', '3', 'T-08', 'fa0f710044c1da7d9d94e68fd6c93303', 'active', 'available', '1', '4', '2025-12-02 08:30:16', '2025-12-02 08:30:16'),
('22', '3', 'T-09', '59a9d789f585de2b693d6bec25aae59b', 'active', 'available', '1', '4', '2025-12-02 08:30:16', '2025-12-02 08:30:16'),
('23', '3', 'T-10', 'e7b5d114963a5011a4b7a11100563f77', 'active', 'available', '1', '4', '2025-12-02 08:30:16', '2025-12-02 08:30:16'),
('24', '3', 'T-11', 'dad03ace03fd2004397ec37b64a02e4d', 'active', 'available', '1', '4', '2025-12-02 08:30:17', '2025-12-02 08:30:17'),
('25', '3', 'T-12', '70a644f0f842d6602674e14906319d90', 'active', 'available', '1', '4', '2025-12-02 08:30:17', '2025-12-02 08:30:17'),
('26', '3', 'T-13', '84b963991a66f7619b264b3deb701ae9', 'active', 'available', '1', '4', '2025-12-02 08:30:17', '2025-12-02 08:30:17'),
('27', '3', '4', 'aa7833f99a6a9d6cb2dfe5d7b3b5fe35', 'active', 'available', '1', '4', '2025-12-02 08:38:23', '2025-12-02 08:38:23'),
('28', '3', '2', 'c1baf79e58cfbdd2ffb62edbebb9c592', 'active', 'available', '1', '4', '2025-12-02 08:38:24', '2025-12-02 08:38:24'),
('29', '3', '3', 'ec8414b664ab4a483b399d4a91718300', 'active', 'available', '1', '4', '2025-12-02 08:38:24', '2025-12-02 08:38:24'),
('30', '3', '5', '884dc8aaecf0392d754f111c2ec9d91f', 'active', 'available', '1', '4', '2025-12-02 08:38:24', '2025-12-02 08:38:24'),
('31', '3', '6', 'c5ddce8d4be07114900adbbf8c26b8ce', 'active', 'available', '1', '4', '2025-12-02 08:38:24', '2025-12-02 08:38:24'),
('32', '3', '7', 'a53d1332b930303072a641091045f3af', 'active', 'available', '1', '4', '2025-12-02 08:38:24', '2025-12-02 08:38:24'),
('33', '5', 'G01', '55ae8e9f733f06441bd46239309d1139', 'active', 'available', '6', '4', '2025-12-02 10:14:57', '2025-12-02 10:14:57'),
('34', '5', 'G02', 'a961715ad45528e91c900a9dec2aa3c9', 'active', 'available', '6', '6', '2025-12-02 10:14:57', '2025-12-02 10:14:57'),
('35', '5', 'G03', 'c351684efeb06a8df6ee41a980050f85', 'active', 'running', '6', '8', '2025-12-02 10:14:58', '2025-12-05 12:43:42'),
('36', '5', 'G04', '55a60b84175b36175da93da3fb4cfd0d', 'active', 'available', '6', '10', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('37', '5', 'G05', '091a4780c3d4913cc8700b5001ca8488', 'active', 'available', '6', '4', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('38', '5', 'G06', 'd6437a77b9b388ec1474fcb07c9e5471', 'active', 'available', '6', '6', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('39', '5', 'G07', '4ff8a31c8cb74a63a290d92bcae2061a', 'active', 'running', '6', '8', '2025-12-02 10:14:58', '2025-12-07 12:23:42'),
('40', '5', 'G08', '05b35544a33146c8956b8f249383df10', 'active', 'available', '6', '10', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('41', '5', 'G09', '66ceee6fd3cf18c57455d5343c2f29ee', 'active', 'available', '6', '4', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('42', '5', 'G10', '30084c1629c0e17c626808d0e586ed43', 'active', 'available', '6', '6', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('43', '5', 'G11', '4030a7a7778da049952a4799ce85addd', 'active', 'available', '6', '8', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('44', '5', 'G12', '5fa276194aa758a717e562c089816993', 'active', 'available', '6', '10', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('45', '5', 'G13', '5142b01c21bc9736ed74590234fe5a5e', 'active', 'available', '6', '4', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('46', '5', 'G14', '634bdbf116dbe3d6daf9bb6ec8362973', 'active', 'available', '6', '6', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('47', '5', 'G15', '7f7d8fedb11bed777e198f6a85301ce8', 'active', 'available', '6', '8', '2025-12-02 10:14:58', '2025-12-02 10:14:58'),
('48', '5', 'G16', 'c4e58569bc2aeee72438287a953eb707', 'active', 'available', '6', '10', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('49', '5', 'G17', '041750e8e9ec28fdc4bfbe61eceb11e1', 'active', 'available', '6', '4', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('50', '5', 'G18', '675b2799574bedbfde392dabe4dd3d87', 'active', 'available', '6', '6', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('51', '5', 'G19', '7938256bd252c3bb60765d20b6591f24', 'active', 'available', '6', '8', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('52', '5', 'G20', '3f8ef29666d5edfdbe44ebf6ce1d9535', 'active', 'available', '6', '10', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('53', '5', 'G21', 'ef86deab0f167a788767bea01af3e963', 'active', 'available', '6', '4', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('54', '5', 'G22', '2c6b5accfcff6abad0eca5d16a2c4654', 'active', 'available', '6', '6', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('55', '5', 'G23', '2d044cee3b61010129ae2befa5b23ca0', 'active', 'available', '6', '8', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('56', '5', 'G24', 'cddda4d6e10d6b5d99d83a108f9c8799', 'active', 'available', '6', '10', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('57', '5', 'G25', 'd3ea4bd5c2d254d036918f4eeac84810', 'active', 'available', '6', '4', '2025-12-02 10:14:59', '2025-12-02 10:14:59'),
('58', '5', 'G26', '9120d33618a794ffbc42f18269212222', 'active', 'available', '6', '6', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('59', '5', 'G27', '0ecb13782269278ca53b80033ee789b8', 'active', 'available', '6', '8', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('60', '5', 'G28', '0e27a52dea96d40b7589f6edbbf73b5c', 'active', 'available', '6', '10', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('61', '5', 'G29', '9a0ebe0669a9104f42332a561f691fe0', 'active', 'available', '6', '4', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('62', '5', 'G30', '62cb879a3501fffab6016c71eb4d3e8e', 'active', 'available', '6', '6', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('63', '5', 'G31', 'b08c3e8712394df1757e7c54af11ef60', 'active', 'available', '6', '8', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('64', '5', 'G32', '8cfa5c431493e93ef37178e074485888', 'active', 'available', '6', '10', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('65', '5', 'G33', '21c7628f7dffb7f89d3ab2d088cfd0ff', 'active', 'available', '6', '4', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('66', '5', 'G34', '027d8076dded7086c78660b25e81be14', 'active', 'available', '6', '6', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('67', '5', 'G35', '10b7d51f6de00015dc40c3f3ddd09c00', 'active', 'available', '6', '8', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('68', '5', 'G36', '27a67c75578acfdb0453fb4ea73d07ca', 'active', 'available', '6', '10', '2025-12-02 10:15:00', '2025-12-02 10:15:00'),
('69', '5', 'G37', '36ce59ed988ebea3183596893858a142', 'active', 'available', '6', '4', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('70', '5', 'G38', '775688f8ee49f69652d49b992902b962', 'active', 'available', '6', '6', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('71', '5', 'G39', '0225df5d153d8663952ca927f3d3cf72', 'active', 'available', '6', '8', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('72', '5', 'G40', '552a57e631b43b44266b106b08b5376c', 'active', 'available', '6', '10', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('73', '5', 'G41', '98166bc41bcf1c2545f56d10c4263e66', 'active', 'available', '6', '4', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('74', '5', 'G42', 'b0791f528cb6636bee3a0957d6c1257a', 'active', 'available', '6', '6', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('75', '5', 'G43', '38b8c2f832e0784cd1989fb119a2352e', 'active', 'available', '6', '8', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('76', '5', 'G44', '12486d7b8f9d9ec56ae2c8b03a1961e5', 'active', 'available', '6', '10', '2025-12-02 10:15:01', '2025-12-02 10:15:01'),
('77', '5', 'G45', '2001cabb4619bab8491cfe1a771aee0b', 'active', 'available', '6', '4', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('78', '5', 'G46', 'f59b431baa192a27bdec48a99a76a126', 'active', 'available', '6', '6', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('79', '5', 'G47', '504c949ddf672043f5539b565e13bec9', 'active', 'available', '6', '8', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('80', '5', 'G48', '2c2fe5db8fb7664fc5812f9c6bbae208', 'active', 'available', '6', '10', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('81', '5', 'G49', 'a8310f3a0b86eb3d846b6a09a007ac38', 'active', 'available', '6', '4', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('82', '5', 'G50', 'bb5df197d54cde50cf759cb2ddbf491e', 'active', 'available', '6', '6', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('83', '5', 'G51', '1a9682b4e4a4f71fcc93696593bc6fbb', 'active', 'available', '6', '8', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('84', '5', 'G52', '58ea979da91030c8407c772a4baf41d1', 'active', 'available', '6', '10', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('85', '5', 'G53', '125295530a2f6e13c7dc434d36b43dab', 'active', 'available', '6', '4', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('86', '5', 'G54', 'b48e2b96c91b332f9be8b8e3949a0718', 'active', 'available', '6', '6', '2025-12-02 10:15:02', '2025-12-02 10:15:02'),
('87', '5', 'G55', '9c2bcb113889375f119ea301e40c826f', 'active', 'available', '6', '8', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('88', '5', 'G56', 'b0b90f3643678e2997eab2718fdb75af', 'active', 'available', '6', '10', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('89', '5', 'G57', 'd4b4d9b742935c93812659ffe87f1fe9', 'active', 'available', '6', '4', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('90', '5', 'G58', 'be7ce759a48d39c17b3366e33b3a5fc6', 'active', 'available', '6', '6', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('91', '5', 'G59', '7ddc597dab2ff1399089bf8418298c87', 'active', 'available', '6', '8', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('92', '5', 'G60', '8dabf391b03e2e8226c1cca3b21f7c70', 'active', 'available', '6', '10', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('93', '5', 'G61', '7183b1a2626a48a219c2f8ff7a677329', 'active', 'available', '6', '4', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('94', '5', 'G62', '77f06a22fdbb39c87945a448547db70c', 'active', 'available', '6', '6', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('95', '5', 'G63', '597957d3a059a7bda623ed21b2690592', 'active', 'available', '6', '8', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('96', '5', 'G64', '1d5abbe5da8f26391add96f21b11c664', 'active', 'available', '6', '10', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('97', '5', 'G65', '4344b02dbb541192e145dccf9586e86d', 'active', 'available', '6', '4', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('98', '5', 'G66', '9b42494e47c2e272a8c1000c2124b9cf', 'active', 'available', '6', '6', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('99', '5', 'G67', '9587233870eb54611220ffe5f050c3ba', 'active', 'available', '6', '8', '2025-12-02 10:15:03', '2025-12-02 10:15:03'),
('100', '5', 'G68', '68bbb130b554240d5bd62a510ed05749', 'active', 'available', '6', '10', '2025-12-02 10:15:04', '2025-12-02 10:15:04'),
('101', '5', 'G69', '0ca93c9ee7be168999257fcfaa3312d6', 'active', 'available', '6', '4', '2025-12-02 10:15:04', '2025-12-02 10:15:04'),
('102', '5', 'G70', '015bdecaa42f47d2238142f63df7cbeb', 'active', 'available', '6', '6', '2025-12-02 10:15:04', '2025-12-02 10:15:04'),
('103', '31', 'MDH_01', '01138243b2b7b78d94de7b22e02ee8bf', 'active', 'available', '11', '4', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('104', '31', 'MDH_02', 'df194c307d1b4270f208ef863da4f2e2', 'active', 'available', '11', '4', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('105', '31', 'MDH_03', '5e3249eac84fcc9f59eee36142ea1d68', 'active', 'available', '11', '2', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('106', '31', 'MDH_04', '1d889ab1344bd88590a60aa7cfdf0255', 'active', 'available', '11', '4', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('107', '31', 'MDH_05', 'a96c023052e7783cc97b4abadf36f8d7', 'active', 'available', '11', '4', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('108', '31', 'MDH_06', '4d8983f4f990dfd08884b8076d534d9b', 'active', 'available', '11', '6', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('109', '31', 'MDH_07', '4923e5c37dce6de72935c2e3e45883b1', 'active', 'available', '11', '6', '2025-12-05 20:12:52', '2025-12-05 20:12:52'),
('110', '31', 'MDH_08', '85f02a8b03dd8cf6627b03f972e746b1', 'active', 'available', '11', '4', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('111', '31', 'MDH_09', '662a0e0553b9bf023e727c177118d93d', 'active', 'available', '11', '2', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('112', '31', 'MDH_10', '8ad90f066b0d003ac531a8b8c5fac919', 'active', 'available', '11', '6', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('113', '31', 'MDH_11', '0dd8c60ef3b0bac295e234c5cfb93bf3', 'active', 'available', '11', '4', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('114', '31', 'MDH_12', 'b09de8056e994d16287e7f5cf6a95054', 'active', 'available', '11', '2', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('115', '31', 'MDH_13', '364a55862c76b47fdd5cebffc182078c', 'active', 'available', '11', '2', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('116', '31', 'MDH_14', 'd74b33049140a0253f29615655b2fa89', 'active', 'available', '11', '6', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('117', '31', 'MDH_15', '48cf1d77b9dbd56bae75e465a648292f', 'active', 'available', '11', '2', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('118', '31', 'MDH_16', '99d74aff7710bdb5ac8f9efb7f3e3606', 'active', 'available', '11', '4', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('119', '31', 'MDH_17', 'c0d037b50d5f57f58d29af4d0b00f25e', 'active', 'available', '11', '4', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('120', '31', 'MDH_18', '7014c9ee32ff94d12023253fc5ab74bf', 'active', 'available', '11', '2', '2025-12-05 20:12:53', '2025-12-05 20:12:53'),
('121', '31', 'MDH_19', '6f4ccb891da986211bf5a4278f72dbd2', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('122', '31', 'MDH_20', 'b0645ec84fbc61fa86464212dc8be6ef', 'active', 'available', '11', '2', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('123', '31', 'MDH_21', '29aa89261db822fef1e0727c7688e7d0', 'active', 'available', '11', '2', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('124', '31', 'MDH_22', '9659ddd74509667fcb6f7d4000b9c9a3', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('125', '31', 'MDH_23', '6ef89aa9ac56ab041ff1e2b424abfd55', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('126', '31', 'MDH_24', 'e4bac2a88f3eed21443bcb609ce11662', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('127', '31', 'MDH_25', '01571b50b8d88a22d558cfc6e9b22a83', 'active', 'available', '11', '2', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('128', '31', 'MDH_26', 'de20620865d413db58dfb5d2c0272192', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('129', '31', 'MDH_27', 'fa8d2d90b77e00839dca6f6e12c007de', 'active', 'available', '11', '2', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('130', '31', 'MDH_28', 'b3814dbd38e1b032997b6e1bedb8db27', 'active', 'available', '11', '4', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('131', '31', 'MDH_29', '9ed20dcb395d4210c0760ad8fc196d23', 'active', 'available', '11', '6', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('132', '31', 'MDH_30', '33767d532f66e983243475b64546eb02', 'active', 'available', '11', '6', '2025-12-05 20:12:54', '2025-12-05 20:12:54'),
('133', '31', 'MDH_31', '4608db7f2ccbde9c26622dbc269fcecb', 'active', 'available', '11', '2', '2025-12-05 20:12:55', '2025-12-05 20:12:55'),
('134', '31', 'MDH_32', '9ea79664700b1228682327c54fad7ce0', 'active', 'available', '11', '6', '2025-12-05 20:12:55', '2025-12-05 20:12:55'),
('135', '31', 'OP_01', 'be2612f0988789c07754be71a64b4b0b', 'active', 'available', '12', '6', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('136', '31', 'OP_02', 'd378ec5708d31443d2041dcbf33a5521', 'active', 'available', '12', '4', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('137', '31', 'OP_03', '9b0711519231188fce40f1a76dd1d0f5', 'active', 'available', '12', '4', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('138', '31', 'OP_04', 'e0fc3995ec48e2e2d012f3eabfd01f42', 'active', 'available', '12', '2', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('139', '31', 'OP_05', 'a07cb746b71bc41ab72b26be69da1fe7', 'active', 'available', '12', '2', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('140', '31', 'OP_06', 'b745365f88dcf254b4edf2549db6f8c5', 'active', 'available', '12', '4', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('141', '31', 'OP_07', '21d27f824f452ea3a3786a0402f6201f', 'active', 'available', '12', '4', '2025-12-05 20:13:27', '2025-12-05 20:13:27'),
('142', '31', 'OP_08', 'f91435d7884d136e427ab375c485a652', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('143', '31', 'OP_09', '56bbbc70a944dc5654a679f03befc2b1', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('144', '31', 'OP_10', '7f74076de11a29b7db4d8bae105cca19', 'active', 'available', '12', '6', '2025-12-05 20:13:28', '2025-12-05 20:17:43'),
('145', '31', 'OP_11', 'ea014a817a9dcb9bc6017a5429184087', 'active', 'available', '12', '4', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('146', '31', 'OP_12', 'af3c740e8847a7ce6e879275cee934f1', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('147', '31', 'OP_13', 'c80f372966eb640a98c53b677b866578', 'active', 'available', '12', '6', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('148', '31', 'OP_14', '92c7978bca4ebc072d5ddb260e8ce756', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('149', '31', 'OP_15', 'fa5d64c8b651f8d88d5a06741ce92502', 'active', 'available', '12', '4', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('150', '31', 'OP_16', 'be6566ff63f569161a6cf3eb8389a503', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('151', '31', 'OP_17', 'de4d2809cb3c5863b788709497b20f00', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('152', '31', 'OP_18', 'f4a96d89957670ca5abbb647a71ecd50', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('153', '31', 'OP_19', '36356081957e6f37e499ab386df4a9c4', 'active', 'available', '12', '2', '2025-12-05 20:13:28', '2025-12-05 20:13:28'),
('154', '31', 'OP_20', '6cdaf2b4ad20df09774932393390959a', 'active', 'available', '12', '6', '2025-12-05 20:13:29', '2025-12-05 20:13:29'),
('155', '31', 'BAR_01', 'ee66b5a779c04323e17ec6ceb3c226ad', 'active', 'available', '13', '2', '2025-12-05 20:13:52', '2025-12-05 20:13:52'),
('156', '31', 'BAR_02', '0a064884ddac20989f524d5be22dbf3e', 'active', 'available', '13', '1', '2025-12-05 20:13:52', '2025-12-05 20:13:52'),
('157', '31', 'BAR_03', 'c6ccb5ed067abbe805863bb334c3aebc', 'active', 'available', '13', '1', '2025-12-05 20:13:52', '2025-12-05 20:13:52'),
('158', '31', 'BAR_04', 'f45ee9a6a7ee512265553dc594d3d632', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('159', '31', 'BAR_05', '2dc5f1d5af5424cd67903ef3ed503b85', 'active', 'available', '13', '2', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('160', '31', 'BAR_06', '8d6f3243a62e6578522b59617b03e1a6', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('161', '31', 'BAR_07', 'a422929cd339e9ff3957b130828b2a7c', 'active', 'available', '13', '2', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('162', '31', 'BAR_08', '28f6aff77b76ed4970c95ba215dac987', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('163', '31', 'BAR_09', '7605f63a473daf0e501b60517eecfe6b', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('164', '31', 'BAR_10', 'c32a3124362f7b996227a4821e9801ba', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('165', '31', 'BAR_11', '09cbc504a62359d7302a16cdcd90992b', 'active', 'available', '13', '2', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('166', '31', 'BAR_12', '3be5d617bebb44485093fd160e06ae2b', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('167', '31', 'BAR_13', '1294bdc94426e59464c306bc2c6dd8c2', 'active', 'available', '13', '1', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('168', '31', 'BAR_14', 'a07c9c5b494a57f68ef94baf18124aae', 'active', 'available', '13', '2', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('169', '31', 'BAR_15', 'b27663fbe72d846ef158b9db0e75e005', 'active', 'available', '13', '2', '2025-12-05 20:13:53', '2025-12-05 20:13:53'),
('170', '31', 'BAR_16', 'd15d4edb0438397d88f348d097ed646e', 'active', 'available', '13', '2', '2025-12-05 20:13:54', '2025-12-05 20:13:54'),
('171', '31', 'BAR_17', '6028ab8e3e634be1e5f97da284feb3d8', 'active', 'available', '13', '2', '2025-12-05 20:13:54', '2025-12-05 20:13:54'),
('172', '31', 'BAR_18', '24be507dc16465b2b7e4de30238b98b6', 'active', 'available', '13', '1', '2025-12-05 20:13:54', '2025-12-05 20:13:54'),
('173', '31', 'BAR_19', 'a92b543790839ddc23d555edc9d48fa5', 'active', 'available', '13', '1', '2025-12-05 20:13:54', '2025-12-05 20:13:54'),
('174', '31', 'BAR_20', '318696e99702c0a3632f791afb5644af', 'active', 'available', '13', '1', '2025-12-05 20:13:54', '2025-12-05 20:13:54'),
('175', '31', 'BS_01', '35c5fa17547b14a4c666ffe5d6449169', 'active', 'available', '14', '3', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('176', '31', 'BS_02', 'fd29c3cb2255ca96cf0fdb51c1696fb9', 'active', 'available', '14', '3', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('177', '31', 'BS_03', '9a74288fc52ea4a53a409d6ed6578ede', 'active', 'available', '14', '2', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('178', '31', 'BS_04', 'cba8e307a9522e2a4adb36814976fe26', 'active', 'available', '14', '2', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('179', '31', 'BS_05', '1b996b388783e7baddb72eeabb37d372', 'active', 'available', '14', '6', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('180', '31', 'BS_06', '91a8eacf93206dc6a319d0e2bec159fa', 'active', 'available', '14', '3', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('181', '31', 'BS_07', '8dd0bedc7833b7f9a3a20a8a7b6fb5d8', 'active', 'available', '14', '2', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('182', '31', 'BS_08', '2f83dbcf4105fc1ceabc3e5a26bc81b7', 'active', 'available', '14', '6', '2025-12-05 20:14:18', '2025-12-05 20:14:18'),
('183', '31', 'BS_09', '3421b72ab16642e910ba5ad09d77aaa9', 'active', 'available', '14', '4', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('184', '31', 'BS_10', '90a33f031aa9ad6228dfd725e2f8f52e', 'active', 'available', '14', '2', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('185', '31', 'BS_11', '09b83e2c4c3e404ad8dda2bcdd6333b8', 'active', 'available', '14', '4', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('186', '31', 'BS_12', 'd452d111f03c4162d17c8eef74f1a88b', 'active', 'available', '14', '6', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('187', '31', 'BS_13', 'cd6a1630ae803143c35913746edfcb36', 'active', 'available', '14', '6', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('188', '31', 'BS_14', '7e05f81336b679b3e2c0f48c82546b26', 'active', 'available', '14', '6', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('189', '31', 'BS_15', '68f39ff626abc83f8d11838e3fc9ca37', 'active', 'available', '14', '3', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('190', '31', 'BS_16', 'b1df614e7d70757fd3279defac9d4e24', 'active', 'available', '14', '3', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('191', '31', 'BS_17', '66ee6c765191cfe3dd33de9ccb4575ec', 'active', 'available', '14', '2', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('192', '31', 'BS_18', '3496ee0241152ba6a7a8dadc804ef5e4', 'active', 'available', '14', '2', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('193', '31', 'BS_19', '0e12053978114e3d54d913564b411939', 'active', 'available', '14', '3', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('194', '31', 'BS_20', 'b4f86cb89e0753b7fc54a897d97bc93f', 'active', 'available', '14', '4', '2025-12-05 20:14:19', '2025-12-05 20:14:19'),
('195', '31', 'BS_21', '97791d1dfc32e2d06fa16b79f16235ab', 'active', 'available', '14', '3', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('196', '31', 'BS_22', '36f7cbfa99ea3bcfb37859703f71aad7', 'active', 'available', '14', '4', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('197', '31', 'BS_23', '878b8db052b9fefc44ceb05937e1addb', 'active', 'available', '14', '6', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('198', '31', 'BS_24', '5c4bdadbe0876b49cff2edfa5c0dc35d', 'active', 'available', '14', '4', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('199', '31', 'BS_25', '0363e6cdee3ee1ef2a5bfb4662fe235b', 'active', 'available', '14', '4', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('200', '31', 'BS_26', '561bfd7c8bd31ce807e1e1309014fe9b', 'active', 'available', '14', '3', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('201', '31', 'BS_27', 'd46f66d3d159f8a2ace701cb0e8f63c6', 'active', 'available', '14', '6', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('202', '31', 'BS_28', '6900329b30497329325254f14188487b', 'active', 'available', '14', '4', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('203', '31', 'BS_29', '5b0848fa692e216761aeeb05e591c27b', 'active', 'available', '14', '2', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('204', '31', 'BS_30', 'de9ab4e0e917ad073e54550d8099d4ec', 'active', 'available', '14', '4', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('205', '31', 'BS_31', '65d0e71e641fde6449f74e5ca1cead13', 'active', 'available', '14', '6', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('206', '31', 'BS_32', '912e66ae4096b261edbfea659310067e', 'active', 'available', '14', '2', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('207', '31', 'BS_33', '7b85a59c95dc913f0f54947b9f8d094e', 'active', 'available', '14', '2', '2025-12-05 20:14:20', '2025-12-05 20:14:20'),
('208', '31', 'BS_34', 'f66b079619f0c630abbe24136d4f4253', 'active', 'available', '14', '3', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('209', '31', 'BS_35', 'b66ff9948d5195878d83e5f4f15c0625', 'active', 'available', '14', '2', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('210', '31', 'BS_36', 'c53de713de253845335a416937f7c20e', 'active', 'available', '14', '6', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('211', '31', 'BS_37', '7570eb164d31220aec425509e8aaccd2', 'active', 'available', '14', '4', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('212', '31', 'BS_38', '27658086dce9b6ea7bc1232f363c5d63', 'active', 'available', '14', '3', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('213', '31', 'BS_39', '43d03abc18fdd5cf1bfd70e2cbb1f2a6', 'active', 'available', '14', '2', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('214', '31', 'BS_40', '9da5cafd10950204abf8964d5e220726', 'active', 'available', '14', '6', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('215', '31', 'BS_41', 'ee0513a77927de1922c2dca7eb8f6d35', 'active', 'available', '14', '4', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('216', '31', 'BS_42', 'ecb7600439c6d95aa63c17ccc93342e3', 'active', 'available', '14', '2', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('217', '31', 'BS_43', '2f113ccb809f4444038772c2b2034242', 'active', 'available', '14', '4', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('218', '31', 'BS_44', '136a386e2d52b2b6578c80e707342383', 'active', 'available', '14', '6', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('219', '31', 'BS_45', '2900709596f85944abd441d42ef6927e', 'active', 'available', '14', '6', '2025-12-05 20:14:21', '2025-12-05 20:14:21'),
('220', '31', 'BS_46', 'ecebab48d97c31121646044a80155e99', 'active', 'available', '14', '2', '2025-12-05 20:14:22', '2025-12-05 20:14:22'),
('221', '31', 'BS_47', '98680555f059809b9a6078c1400fc25a', 'active', 'available', '14', '3', '2025-12-05 20:14:22', '2025-12-05 20:14:22'),
('222', '31', 'BS_48', '6a534d926d66ba0c64c2f97214f7705c', 'active', 'available', '14', '4', '2025-12-05 20:14:22', '2025-12-05 20:14:22'),
('223', '31', 'BS_49', '60473d98fea4a5cea13d8b9388936761', 'active', 'available', '14', '2', '2025-12-05 20:14:22', '2025-12-05 20:14:22'),
('224', '31', 'BS_50', 'b6eaed4de5eb6ed3e5b6ee07441a823d', 'active', 'available', '14', '4', '2025-12-05 20:14:22', '2025-12-05 20:14:22');


-- Table structure for table `taxes`
