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

START TRANSACTION;



--
-- Database: `dev63ak_peekzytest`
--

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

--
-- Table structure for table `account_ledger`
--

CREATE TABLE `account_ledger` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT NULL,
  `invoice_no` varchar(255) DEFAULT NULL,
  `debit` int(11) NOT NULL,
  `credit` int(11) NOT NULL,
  `balance` int(11) NOT NULL,
  `remark` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `timestamp` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `account_ledger`
--

INSERT INTO `account_ledger` (`id`, `user_id`, `post_id`, `invoice_no`, `debit`, `credit`, `balance`, `remark`, `created_at`, `updated_at`, `timestamp`) VALUES
(1, 5, 11, 'INV-1', 0, 6300, 6300, 'Purchased Package: packages-11', NULL, NULL, '2026-01-14 05:59:30'),
(2, 5, 11, 'INV-2', 0, 6300, 12600, 'Purchased Package: packages-11', '2026-01-14 00:31:06', NULL, '2026-01-14 11:31:06'),
(3, 5, 12, 'INV-3', 0, 5000, 17600, 'Purchased Package: test package', '2026-01-14 00:33:05', NULL, '2026-01-14 11:33:05'),
(4, 5, 13, 'INV-4', 0, 855, 18455, 'Purchased Package: packages-11', '2026-01-14 00:34:06', NULL, '2026-01-14 11:34:06'),
(5, 5, 14, 'INV-5', 0, 9000, 27455, 'Purchased Package: packages-4', '2026-01-14 00:35:26', NULL, '2026-01-14 11:35:26'),
(6, 5, 11, 'INV-6', 0, 6300, 33755, 'Purchased Package: packages-11', '2026-01-14 06:31:10', NULL, '2026-01-14 17:31:10'),
(7, 5, 13, 'INV-7', 0, 855, 34610, 'Purchased Package: packages-11', '2026-01-14 06:33:04', NULL, '2026-01-14 17:33:04'),
(8, 5, 27, NULL, 11, 0, 34599, 'Featured Offer charge is 11/-', NULL, NULL, '2026-03-28 16:09:52'),
(9, 5, 11, 'INV-8', 0, 6300, 40899, 'Purchased Package: packages-11', '2026-05-08 00:42:12', NULL, '2026-05-08 11:42:12'),
(10, 5, 16, NULL, 12, 0, 40887, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-09 12:18:08'),
(11, 97, 12, 'INV-9', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 04:55:36', NULL, '2026-05-12 15:55:36'),
(12, 97, 17, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 10:38:42'),
(13, 98, 13, 'INV-10', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 05:19:25', NULL, '2026-05-12 16:19:25'),
(14, 98, 18, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 10:51:02'),
(15, 99, 12, 'INV-11', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 05:22:15', NULL, '2026-05-12 16:22:15'),
(16, 99, 19, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 10:53:18'),
(17, 100, 12, 'INV-12', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 05:24:50', NULL, '2026-05-12 16:24:50'),
(18, 100, 20, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 10:56:57'),
(19, 101, 12, 'INV-13', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 05:36:21', NULL, '2026-05-12 16:36:21'),
(20, 101, 21, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:07:39'),
(21, 102, 14, 'INV-14', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 05:59:06', NULL, '2026-05-12 16:59:06'),
(22, 102, 22, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:30:01'),
(23, 103, 11, 'INV-15', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 06:00:29', NULL, '2026-05-12 17:00:29'),
(24, 103, 23, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:31:17'),
(25, 104, 12, 'INV-16', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 06:05:06', NULL, '2026-05-12 17:05:06'),
(26, 104, 24, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:36:13'),
(27, 105, 12, 'INV-17', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 06:07:43', NULL, '2026-05-12 17:07:43'),
(28, 105, 25, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:38:23'),
(29, 106, 13, 'INV-18', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 06:11:15', NULL, '2026-05-12 17:11:15'),
(30, 106, 14, 'INV-19', 0, 9000, 9855, 'Purchased Package: packages-4', '2026-05-12 06:11:39', NULL, '2026-05-12 17:11:39'),
(31, 106, 26, NULL, 12, 0, 9843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:42:56'),
(32, 107, 12, 'INV-20', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 06:13:45', NULL, '2026-05-12 17:13:45'),
(33, 107, 27, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:44:59'),
(34, 108, 11, 'INV-21', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 06:16:21', NULL, '2026-05-12 17:16:21'),
(35, 108, 28, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:47:05'),
(36, 108, 29, NULL, 12, 0, 6276, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:47:56'),
(37, 109, 12, 'INV-22', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 06:19:34', NULL, '2026-05-12 17:19:34'),
(38, 109, 30, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:50:20'),
(39, 110, 13, 'INV-23', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 06:20:42', NULL, '2026-05-12 17:20:42'),
(40, 110, 31, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:51:26'),
(41, 111, 13, 'INV-24', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 06:21:51', NULL, '2026-05-12 17:21:51'),
(42, 111, 32, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:52:30'),
(43, 112, 13, 'INV-25', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 06:23:01', NULL, '2026-05-12 17:23:01'),
(44, 112, 33, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 11:53:40'),
(45, 113, 12, 'INV-26', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 06:29:16', NULL, '2026-05-12 17:29:16'),
(46, 113, 34, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:00:04'),
(47, 150, 11, 'INV-27', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 06:45:50', NULL, '2026-05-12 17:45:50'),
(48, 150, 35, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:17:00'),
(49, 149, 11, 'INV-28', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 06:47:52', NULL, '2026-05-12 17:47:52'),
(50, 149, 36, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:21:08'),
(51, 148, 11, 'INV-29', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 06:52:53', NULL, '2026-05-12 17:52:53'),
(52, 148, 37, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:25:52'),
(53, 147, 13, 'INV-30', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 06:56:50', NULL, '2026-05-12 17:56:50'),
(54, 147, 38, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:28:51'),
(55, 114, 12, 'INV-31', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:17:07', NULL, '2026-05-12 18:17:07'),
(56, 146, 14, 'INV-32', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:17:23', NULL, '2026-05-12 18:17:23'),
(57, 114, 39, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:48:03'),
(58, 115, 14, 'INV-33', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:18:29', NULL, '2026-05-12 18:18:29'),
(59, 146, 40, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:48:36'),
(60, 115, 41, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:49:21'),
(61, 145, 12, 'INV-34', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:19:34', NULL, '2026-05-12 18:19:34'),
(62, 116, 11, 'INV-35', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:19:46', NULL, '2026-05-12 18:19:46'),
(63, 116, 42, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:51:01'),
(64, 117, 12, 'INV-36', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:21:22', NULL, '2026-05-12 18:21:22'),
(65, 145, 43, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:51:26'),
(66, 117, 44, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:52:24'),
(67, 144, 12, 'INV-37', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:22:48', NULL, '2026-05-12 18:22:48'),
(68, 118, 11, 'INV-38', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:24:04', NULL, '2026-05-12 18:24:04'),
(69, 144, 45, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:54:11'),
(70, 118, 46, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 12:55:28'),
(71, 119, 12, 'INV-39', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:25:54', NULL, '2026-05-12 18:25:54'),
(72, 120, 13, 'INV-40', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:29:48', NULL, '2026-05-12 18:29:48'),
(73, 120, 11, 'INV-41', 0, 6300, 7155, 'Purchased Package: packages-11', '2026-05-12 07:30:09', NULL, '2026-05-12 18:30:09'),
(74, 120, 47, NULL, 12, 0, 7143, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:01:24'),
(75, 121, 14, 'INV-42', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:31:59', NULL, '2026-05-12 18:31:59'),
(76, 121, 48, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:03:54'),
(77, 143, 11, 'INV-43', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:35:39', NULL, '2026-05-12 18:35:39'),
(78, 119, 49, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:05:57'),
(79, 122, 11, 'INV-44', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:36:44', NULL, '2026-05-12 18:36:44'),
(80, 143, 50, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:06:55'),
(81, 142, 12, 'INV-45', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:37:32', NULL, '2026-05-12 18:37:32'),
(82, 122, 51, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:08:08'),
(83, 123, 13, 'INV-46', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:38:33', NULL, '2026-05-12 18:38:33'),
(84, 142, 52, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:08:43'),
(85, 123, 53, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:09:16'),
(86, 141, 13, 'INV-47', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:39:20', NULL, '2026-05-12 18:39:20'),
(87, 124, 11, 'INV-48', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:39:42', NULL, '2026-05-12 18:39:42'),
(88, 124, 54, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:10:54'),
(89, 141, 55, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:11:08'),
(90, 125, 13, 'INV-49', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:41:20', NULL, '2026-05-12 18:41:20'),
(91, 140, 13, 'INV-50', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:41:46', NULL, '2026-05-12 18:41:46'),
(92, 125, 56, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:12:04'),
(93, 126, 14, 'INV-51', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:42:52', NULL, '2026-05-12 18:42:52'),
(94, 5, 57, NULL, 12, 0, 40875, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:13:01'),
(95, 140, 58, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:14:00'),
(96, 126, 59, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:14:01'),
(97, 139, 12, 'INV-52', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:44:37', NULL, '2026-05-12 18:44:37'),
(98, 127, 12, 'INV-53', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:45:01', NULL, '2026-05-12 18:45:01'),
(99, 127, 60, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:15:47'),
(100, 128, 14, 'INV-54', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:46:24', NULL, '2026-05-12 18:46:24'),
(101, 139, 61, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:16:34'),
(102, 128, 62, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:17:16'),
(103, 138, 13, 'INV-55', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:47:17', NULL, '2026-05-12 18:47:17'),
(104, 129, 12, 'INV-56', 0, 5000, 5000, 'Purchased Package: test package', '2026-05-12 07:47:51', NULL, '2026-05-12 18:47:51'),
(105, 129, 63, NULL, 12, 0, 4988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:18:29'),
(106, 130, 11, 'INV-57', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:48:55', NULL, '2026-05-12 18:48:55'),
(107, 138, 64, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:19:03'),
(108, 137, 14, 'INV-58', 0, 9000, 9000, 'Purchased Package: packages-4', '2026-05-12 07:49:42', NULL, '2026-05-12 18:49:42'),
(109, 130, 65, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:20:06'),
(110, 131, 13, 'INV-59', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:50:33', NULL, '2026-05-12 18:50:33'),
(111, 137, 66, NULL, 12, 0, 8988, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:21:05'),
(112, 131, 67, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:21:09'),
(113, 132, 13, 'INV-60', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:51:27', NULL, '2026-05-12 18:51:27'),
(114, 132, 68, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:22:08'),
(115, 136, 13, 'INV-61', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:52:10', NULL, '2026-05-12 18:52:10'),
(116, 136, 69, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:23:29'),
(117, 135, 11, 'INV-62', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:54:04', NULL, '2026-05-12 18:54:04'),
(118, 135, 70, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:25:16'),
(119, 134, 11, 'INV-63', 0, 6300, 6300, 'Purchased Package: packages-11', '2026-05-12 07:55:58', NULL, '2026-05-12 18:55:58'),
(120, 134, 71, NULL, 12, 0, 6288, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:27:16'),
(121, 133, 13, 'INV-64', 0, 855, 855, 'Purchased Package: packages-11', '2026-05-12 07:57:47', NULL, '2026-05-12 18:57:47'),
(122, 5, 72, NULL, 12, 0, 40863, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:28:21'),
(123, 133, 73, NULL, 12, 0, 843, 'Offer upload charge is 12/-', NULL, NULL, '2026-05-12 13:30:05'),
(124, 97, 11, 'INV-65', 0, 6300, 11288, 'Purchased Package: packages-11', '2026-05-13 04:24:01', NULL, '2026-05-13 15:24:01');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `id` int(11) NOT NULL,
  `start_date` date NOT NULL,
  `expire_date` date NOT NULL,
  `location` varchar(265) NOT NULL,
  `pincode` int(11) NOT NULL,
  `banner_image` varchar(265) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `lat` varchar(265) DEFAULT NULL,
  `lng` varchar(265) DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` tinyint(4) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`id`, `start_date`, `expire_date`, `location`, `pincode`, `banner_image`, `vendor_id`, `lat`, `lng`, `timestamp`, `status`) VALUES
(39, '2025-11-24', '2028-12-31', 'mumbai', 88596, '1763807237_backaadhr.jpeg', 4, NULL, NULL, '2025-11-22 05:20:51', 1),
(41, '2025-11-24', '2028-12-31', 'mumbai', 8552895, '1763814322_frontaadhr.jpeg', 4, NULL, NULL, '2025-11-22 06:55:22', 1),
(42, '2025-12-07', '2028-12-31', 'pune', 821236, '1764009232_profile3.jpg', 4, NULL, NULL, '2025-11-24 13:06:36', 1),
(43, '2025-01-01', '2028-12-31', '444004 - Sunil Thavrani Hospital, Akola, Akola, Maharashtra', 444004, '1772132805_pexels-quang-nguyen-vinh-222549-2166711.jpg', 6, '20.678787', '77.014027', '2026-02-26 13:36:45', 1);

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

--
-- Table structure for table `banner_categories`
--

CREATE TABLE `banner_categories` (
  `id` int(11) NOT NULL,
  `banner_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `created` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified` timestamp NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(11) NOT NULL,
  `created_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banner_categories`
--

INSERT INTO `banner_categories` (`id`, `banner_id`, `category_id`, `sub_category_id`, `created`, `modified`, `modified_by`, `created_by`) VALUES
(65, 39, 9, 70, '2025-11-22 05:20:51', '2025-11-22 05:20:51', 2, 2),
(68, 41, 9, 71, '2025-11-22 06:55:22', '2025-11-22 06:55:22', 2, 2),
(73, 42, 9, 70, '2025-11-24 13:06:36', '2025-11-24 13:06:36', 2, 2),
(74, 43, 9, 69, '2026-02-26 13:36:45', '2026-02-26 13:36:45', 2, 2),
(75, 43, 9, 70, '2026-02-26 13:36:45', '2026-02-26 13:36:45', 2, 2),
(76, 43, 9, 71, '2026-02-26 13:36:45', '2026-02-26 13:36:45', 2, 2),
(77, 43, 9, 72, '2026-02-26 13:36:45', '2026-02-26 13:36:45', 2, 2);

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

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

CREATE TABLE `categories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `created_by` tinyint(4) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime DEFAULT current_timestamp(),
  `modified_by` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `category`, `slug`, `priority`, `created_by`, `created`, `modified`, `modified_by`, `is_active`) VALUES
(1, 'Seat and Eat', 'seat-and-eat', 5, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(2, 'Family Pastime', 'family-pastime', 6, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(3, 'Merchandise', 'merchandise', 7, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(4, 'Services', 'services', 8, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(5, 'Local Details', 'local-details', 10, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(6, 'Local Specialty Shops', 'local-specialty-shops', 9, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(7, 'Rentals', 'rentals', 3, 4, '2022-02-18 16:58:46', '2022-02-18 16:58:46', 0, 1),
(8, 'Wellness & personal care', 'wellness-personal-care', 4, 4, '2022-02-18 16:58:46', '2022-02-18 16:58:46', 0, 1),
(9, 'Amusements', 'amusements', 2, 4, '2022-02-18 16:58:46', '2022-02-18 16:58:46', 0, 1),
(10, 'Activities', 'activities', 1, 4, '2022-02-18 16:58:46', '2025-11-10 07:04:35', 2, 0),
(11, 'reret reet', 'reret-reet', 11, 2, '2025-11-10 06:18:24', '2025-11-10 07:07:01', 2, 0),
(12, 'abc', 'abc', 15, 2, '2025-11-18 15:51:35', '2025-11-18 15:51:35', 0, 1),
(13, 'abcd', 'abcd', 16, 2, '2025-11-22 16:43:27', '2025-11-22 16:43:27', 0, 1),
(14, 'pqrs', 'pqrs', 17, 2, '2025-11-22 16:43:27', '2025-11-22 16:43:27', 0, 1),
(15, 'test Category', 'test-category', 20, 2, '2025-11-22 16:54:09', '2025-11-22 16:54:09', 0, 1);

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

--
-- Table structure for table `chat_message`
--

CREATE TABLE `chat_message` (
  `id` int(11) NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `message` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `interest_categories`
--

CREATE TABLE `interest_categories` (
  `id` int(11) NOT NULL,
  `categories_id` int(11) DEFAULT NULL,
  `sub_categories_id` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `interest_categories`
--

INSERT INTO `interest_categories` (`id`, `categories_id`, `sub_categories_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 10, 76, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(2, 10, 78, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(3, 10, 87, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(4, 10, 82, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(5, 10, 83, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(6, 10, 86, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(7, 9, 70, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(8, 9, 72, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(9, 7, 55, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(10, 8, 65, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(11, 2, 18, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(12, 3, 27, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(13, 3, 29, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(14, 4, 38, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(15, 4, 40, 4, '2025-11-08 10:25:22', '2025-11-08 10:25:22'),
(74, 10, 76, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(75, 10, 77, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(76, 10, 78, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(77, 10, 79, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(78, 10, 80, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(79, 10, 81, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(80, 10, 82, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(81, 10, 83, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(82, 10, 84, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(83, 10, 85, 7, '2025-11-22 06:06:58', '2025-11-22 06:06:58'),
(103, 9, 69, 6, '2025-11-25 14:46:55', '2025-11-25 14:46:55'),
(104, 9, 71, 6, '2025-11-25 14:46:55', '2025-11-25 14:46:55'),
(105, 7, 55, 6, '2025-11-25 14:46:55', '2025-11-25 14:46:55'),
(106, 7, 56, 6, '2025-11-25 14:46:55', '2025-11-25 14:46:55'),
(107, 7, 57, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(108, 7, 58, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(109, 8, 62, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(110, 8, 63, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(111, 8, 64, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(112, 8, 65, 6, '2025-11-25 14:46:56', '2025-11-25 14:46:56'),
(113, 8, 66, 6, '2025-11-25 14:46:57', '2025-11-25 14:46:57'),
(114, 8, 67, 6, '2025-11-25 14:46:57', '2025-11-25 14:46:57'),
(115, 12, 86, 6, '2025-11-25 14:46:57', '2025-11-25 14:46:57'),
(116, 9, 69, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(117, 9, 70, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(118, 9, 71, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(119, 9, 72, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(120, 7, 55, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(121, 7, 56, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(122, 7, 57, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(123, 7, 58, 14, '2025-11-26 08:09:31', '2025-11-26 08:09:31'),
(145, 8, 62, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(146, 8, 63, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(147, 8, 64, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(148, 8, 65, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(149, 8, 66, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(150, 8, 67, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(151, 4, 38, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(152, 4, 39, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(153, 4, 40, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(154, 4, 41, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(155, 4, 42, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(156, 12, 86, 5, '2025-11-27 12:20:37', '2025-11-27 12:20:37'),
(157, 9, 69, 33, '2026-05-07 18:20:47', '2026-05-07 18:20:47'),
(158, 9, 69, 42, '2026-05-08 05:51:59', '2026-05-08 05:51:59'),
(159, 7, 58, 42, '2026-05-08 05:51:59', '2026-05-08 05:51:59'),
(168, 1, 1, 43, '2026-05-08 06:29:47', '2026-05-08 06:29:47'),
(169, 1, 2, 43, '2026-05-08 06:29:47', '2026-05-08 06:29:47'),
(170, 1, 3, 43, '2026-05-08 06:29:47', '2026-05-08 06:29:47'),
(171, 1, 4, 43, '2026-05-08 06:29:47', '2026-05-08 06:29:47'),
(178, 9, 69, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(179, 9, 70, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(180, 9, 71, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(181, 9, 72, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(182, 7, 55, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(183, 7, 57, 96, '2026-05-08 08:27:32', '2026-05-08 08:27:32'),
(184, 9, 69, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(185, 9, 70, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(186, 9, 71, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(187, 9, 72, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(188, 7, 55, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(189, 7, 56, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(190, 7, 57, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(191, 7, 58, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(192, 8, 62, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(193, 8, 63, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(194, 8, 64, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(195, 8, 65, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(196, 8, 66, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(197, 8, 67, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(198, 1, 1, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(199, 1, 2, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(200, 1, 3, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(201, 1, 4, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(202, 3, 29, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(203, 3, 30, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(204, 3, 31, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(205, 3, 32, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(206, 3, 33, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(207, 3, 34, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(208, 3, 35, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(209, 4, 38, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(210, 4, 39, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(211, 4, 40, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(212, 4, 41, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(213, 4, 42, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(214, 6, 52, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(215, 6, 53, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(216, 6, 54, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(217, 5, 45, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(218, 5, 46, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(219, 5, 47, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(220, 5, 48, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(221, 12, 86, 45, '2026-05-09 04:33:16', '2026-05-09 04:33:16'),
(222, 7, 55, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(223, 7, 56, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(224, 7, 57, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(225, 7, 58, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(226, 8, 62, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(227, 8, 63, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(228, 8, 64, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(229, 8, 65, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(230, 8, 66, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(231, 8, 67, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(232, 1, 1, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(233, 1, 2, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(234, 1, 3, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(235, 1, 4, 46, '2026-05-09 04:34:46', '2026-05-09 04:34:46'),
(253, 8, 62, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(254, 8, 63, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(255, 8, 64, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(256, 8, 65, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(257, 8, 66, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(258, 8, 67, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(259, 1, 1, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(260, 1, 2, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(261, 1, 3, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(262, 1, 4, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(263, 3, 29, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(264, 3, 30, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(265, 3, 31, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(266, 3, 32, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(267, 3, 33, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(268, 3, 34, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(269, 3, 35, 48, '2026-05-09 04:37:06', '2026-05-09 04:37:06'),
(288, 9, 69, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(289, 9, 70, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(290, 9, 71, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(291, 9, 72, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(292, 7, 55, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(293, 7, 56, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(294, 7, 57, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(295, 7, 58, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(296, 8, 62, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(297, 8, 63, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(298, 8, 64, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(299, 8, 65, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(300, 8, 66, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(301, 8, 67, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(302, 1, 1, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(303, 1, 2, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(304, 1, 3, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(305, 1, 4, 49, '2026-05-09 04:38:37', '2026-05-09 04:38:37'),
(306, 9, 69, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(307, 9, 70, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(308, 9, 71, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(309, 9, 72, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(310, 7, 55, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(311, 7, 56, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(312, 7, 57, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(313, 7, 58, 50, '2026-05-09 04:39:40', '2026-05-09 04:39:40'),
(314, 9, 71, 51, '2026-05-09 04:40:51', '2026-05-09 04:40:51'),
(315, 7, 57, 51, '2026-05-09 04:40:51', '2026-05-09 04:40:51'),
(316, 8, 66, 51, '2026-05-09 04:40:51', '2026-05-09 04:40:51'),
(317, 1, 3, 51, '2026-05-09 04:40:51', '2026-05-09 04:40:51'),
(318, 3, 35, 51, '2026-05-09 04:40:51', '2026-05-09 04:40:51'),
(326, 9, 69, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(327, 9, 70, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(328, 9, 71, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(329, 9, 72, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(330, 7, 55, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(331, 7, 56, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(332, 7, 57, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(333, 7, 58, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(334, 6, 52, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(335, 6, 53, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(336, 6, 54, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(337, 5, 45, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(338, 5, 46, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(339, 5, 47, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(340, 5, 48, 52, '2026-05-09 04:42:36', '2026-05-09 04:42:36'),
(341, 7, 55, 53, '2026-05-09 04:43:43', '2026-05-09 04:43:43'),
(342, 7, 57, 53, '2026-05-09 04:43:43', '2026-05-09 04:43:43'),
(343, 8, 63, 53, '2026-05-09 04:43:43', '2026-05-09 04:43:43'),
(344, 8, 65, 53, '2026-05-09 04:43:43', '2026-05-09 04:43:43'),
(345, 15, 87, 54, '2026-05-09 04:44:47', '2026-05-09 04:44:47'),
(346, 8, 62, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(347, 8, 63, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(348, 8, 64, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(349, 8, 65, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(350, 8, 66, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(351, 8, 67, 56, '2026-05-09 04:47:57', '2026-05-09 04:47:57'),
(352, 9, 69, 57, '2026-05-09 04:49:02', '2026-05-09 04:49:02'),
(353, 9, 71, 57, '2026-05-09 04:49:02', '2026-05-09 04:49:02'),
(354, 7, 55, 58, '2026-05-09 04:50:02', '2026-05-09 04:50:02'),
(355, 7, 57, 58, '2026-05-09 04:50:02', '2026-05-09 04:50:02'),
(356, 8, 62, 58, '2026-05-09 04:50:02', '2026-05-09 04:50:02'),
(357, 8, 64, 58, '2026-05-09 04:50:02', '2026-05-09 04:50:02'),
(358, 8, 66, 58, '2026-05-09 04:50:02', '2026-05-09 04:50:02'),
(359, 7, 55, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(360, 7, 56, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(361, 7, 57, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(362, 7, 58, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(363, 8, 62, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(364, 8, 63, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(365, 8, 64, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(366, 8, 65, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(367, 8, 66, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(368, 8, 67, 59, '2026-05-09 04:50:58', '2026-05-09 04:50:58'),
(369, 9, 69, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(370, 9, 70, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(371, 9, 71, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(372, 9, 72, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(373, 7, 55, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(374, 7, 56, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(375, 7, 57, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(376, 7, 58, 60, '2026-05-09 04:51:58', '2026-05-09 04:51:58'),
(377, 7, 55, 62, '2026-05-09 04:53:22', '2026-05-09 04:53:22'),
(378, 8, 62, 62, '2026-05-09 04:53:22', '2026-05-09 04:53:22'),
(379, 8, 64, 62, '2026-05-09 04:53:22', '2026-05-09 04:53:22'),
(380, 9, 69, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(381, 9, 71, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(382, 7, 55, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(383, 7, 57, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(384, 8, 62, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(385, 8, 64, 63, '2026-05-09 04:54:09', '2026-05-09 04:54:09'),
(386, 7, 55, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(387, 7, 56, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(388, 7, 57, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(389, 7, 58, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(390, 8, 62, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(391, 8, 63, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(392, 8, 64, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(393, 8, 65, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(394, 8, 66, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(395, 8, 67, 64, '2026-05-09 04:55:04', '2026-05-09 04:55:04'),
(404, 9, 69, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(405, 9, 70, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(406, 9, 71, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(407, 9, 72, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(408, 7, 55, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(409, 7, 56, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(410, 7, 57, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(411, 7, 58, 65, '2026-05-09 04:57:10', '2026-05-09 04:57:10'),
(412, 7, 55, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(413, 7, 56, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(414, 7, 57, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(415, 7, 58, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(416, 8, 62, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(417, 8, 63, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(418, 8, 64, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(419, 8, 65, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(420, 8, 66, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(421, 8, 67, 66, '2026-05-09 04:58:23', '2026-05-09 04:58:23'),
(422, 7, 55, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(423, 7, 56, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(424, 7, 57, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(425, 7, 58, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(426, 8, 62, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(427, 8, 63, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(428, 8, 64, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(429, 8, 65, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(430, 8, 66, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(431, 8, 67, 67, '2026-05-09 04:59:28', '2026-05-09 04:59:28'),
(440, 9, 69, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(441, 9, 70, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(442, 9, 71, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(443, 9, 72, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(444, 7, 55, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(445, 7, 56, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(446, 7, 57, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(447, 7, 58, 68, '2026-05-09 05:00:57', '2026-05-09 05:00:57'),
(448, 7, 55, 69, '2026-05-09 05:01:47', '2026-05-09 05:01:47'),
(449, 7, 56, 69, '2026-05-09 05:01:47', '2026-05-09 05:01:47'),
(450, 7, 57, 69, '2026-05-09 05:01:47', '2026-05-09 05:01:47'),
(451, 7, 58, 69, '2026-05-09 05:01:47', '2026-05-09 05:01:47'),
(452, 9, 69, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(453, 9, 70, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(454, 9, 71, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(455, 9, 72, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(456, 7, 55, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(457, 7, 56, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(458, 7, 57, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(459, 7, 58, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(460, 8, 62, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(461, 8, 63, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(462, 8, 64, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(463, 8, 65, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(464, 8, 66, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(465, 8, 67, 70, '2026-05-09 05:02:36', '2026-05-09 05:02:36'),
(466, 9, 69, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(467, 9, 70, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(468, 9, 71, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(469, 9, 72, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(470, 7, 55, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(471, 7, 56, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(472, 7, 57, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(473, 7, 58, 71, '2026-05-09 05:05:51', '2026-05-09 05:05:51'),
(474, 5, 45, 72, '2026-05-09 05:06:38', '2026-05-09 05:06:38'),
(475, 5, 46, 72, '2026-05-09 05:06:38', '2026-05-09 05:06:38'),
(476, 5, 47, 72, '2026-05-09 05:06:38', '2026-05-09 05:06:38'),
(477, 5, 48, 72, '2026-05-09 05:06:38', '2026-05-09 05:06:38'),
(478, 9, 69, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(479, 9, 70, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(480, 9, 71, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(481, 9, 72, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(482, 7, 55, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(483, 7, 56, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(484, 7, 57, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(485, 7, 58, 73, '2026-05-09 05:07:35', '2026-05-09 05:07:35'),
(486, 7, 55, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(487, 7, 56, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(488, 7, 57, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(489, 7, 58, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(490, 8, 62, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(491, 8, 63, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(492, 8, 64, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(493, 8, 65, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(494, 8, 66, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(495, 8, 67, 74, '2026-05-09 05:08:28', '2026-05-09 05:08:28'),
(496, 9, 69, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(497, 9, 70, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(498, 9, 71, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(499, 9, 72, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(500, 7, 55, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(501, 7, 56, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(502, 7, 57, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(503, 7, 58, 75, '2026-05-09 05:09:27', '2026-05-09 05:09:27'),
(504, 7, 55, 76, '2026-05-09 05:10:13', '2026-05-09 05:10:13'),
(505, 7, 56, 76, '2026-05-09 05:10:13', '2026-05-09 05:10:13'),
(506, 7, 57, 76, '2026-05-09 05:10:13', '2026-05-09 05:10:13'),
(507, 7, 58, 76, '2026-05-09 05:10:13', '2026-05-09 05:10:13'),
(508, 9, 69, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(509, 9, 70, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(510, 9, 71, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(511, 9, 72, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(512, 7, 55, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(513, 7, 56, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(514, 7, 57, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(515, 7, 58, 77, '2026-05-09 05:11:54', '2026-05-09 05:11:54'),
(516, 9, 69, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(517, 9, 70, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(518, 9, 71, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(519, 9, 72, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(520, 7, 55, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(521, 7, 56, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(522, 7, 57, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(523, 7, 58, 78, '2026-05-09 05:13:00', '2026-05-09 05:13:00'),
(524, 9, 69, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(525, 9, 70, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(526, 9, 71, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(527, 9, 72, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(528, 7, 55, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(529, 7, 56, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(530, 7, 57, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(531, 7, 58, 79, '2026-05-09 05:13:58', '2026-05-09 05:13:58'),
(532, 9, 69, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(533, 9, 70, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(534, 9, 71, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(535, 9, 72, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(536, 7, 55, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(537, 7, 56, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(538, 7, 57, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(539, 7, 58, 80, '2026-05-09 05:14:57', '2026-05-09 05:14:57'),
(540, 9, 69, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(541, 9, 70, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(542, 9, 71, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(543, 9, 72, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(544, 7, 55, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(545, 7, 56, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(546, 7, 57, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(547, 7, 58, 81, '2026-05-09 05:15:53', '2026-05-09 05:15:53'),
(548, 9, 69, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(549, 9, 70, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(550, 9, 71, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(551, 9, 72, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(552, 7, 55, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(553, 7, 56, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(554, 7, 57, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(555, 7, 58, 82, '2026-05-09 05:17:31', '2026-05-09 05:17:31'),
(572, 9, 69, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(573, 9, 70, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(574, 9, 71, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(575, 9, 72, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(576, 7, 55, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(577, 7, 56, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(578, 7, 57, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(579, 7, 58, 83, '2026-05-09 05:19:58', '2026-05-09 05:19:58'),
(580, 7, 55, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(581, 7, 56, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(582, 7, 57, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(583, 7, 58, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(584, 8, 62, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(585, 8, 63, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(586, 8, 64, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(587, 8, 65, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(588, 8, 66, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(589, 8, 67, 84, '2026-05-09 05:20:51', '2026-05-09 05:20:51'),
(590, 9, 69, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(591, 9, 70, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(592, 9, 71, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(593, 9, 72, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(594, 7, 55, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(595, 7, 56, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(596, 7, 57, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(597, 7, 58, 85, '2026-05-09 05:21:52', '2026-05-09 05:21:52'),
(598, 9, 69, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(599, 9, 70, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(600, 9, 71, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(601, 9, 72, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(602, 7, 55, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(603, 7, 56, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(604, 7, 57, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(605, 7, 58, 86, '2026-05-09 05:22:44', '2026-05-09 05:22:44'),
(606, 9, 69, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(607, 9, 70, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(608, 9, 71, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(609, 9, 72, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(610, 7, 55, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(611, 7, 56, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(612, 7, 57, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(613, 7, 58, 87, '2026-05-09 05:23:30', '2026-05-09 05:23:30'),
(614, 7, 55, 89, '2026-05-09 05:24:53', '2026-05-09 05:24:53'),
(615, 7, 56, 89, '2026-05-09 05:24:53', '2026-05-09 05:24:53'),
(616, 7, 57, 89, '2026-05-09 05:24:53', '2026-05-09 05:24:53'),
(617, 7, 58, 89, '2026-05-09 05:24:53', '2026-05-09 05:24:53'),
(618, 9, 69, 90, '2026-05-09 05:25:44', '2026-05-09 05:25:44'),
(619, 7, 55, 90, '2026-05-09 05:25:44', '2026-05-09 05:25:44'),
(620, 7, 57, 90, '2026-05-09 05:25:44', '2026-05-09 05:25:44'),
(621, 9, 69, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(622, 9, 70, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(623, 9, 71, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(624, 9, 72, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(625, 7, 55, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(626, 7, 56, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(627, 7, 57, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(628, 7, 58, 91, '2026-05-09 05:26:36', '2026-05-09 05:26:36'),
(629, 9, 69, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(630, 9, 70, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(631, 9, 71, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(632, 9, 72, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(633, 7, 55, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(634, 7, 56, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(635, 7, 57, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(636, 7, 58, 92, '2026-05-09 05:27:32', '2026-05-09 05:27:32'),
(637, 9, 69, 93, '2026-05-09 05:28:22', '2026-05-09 05:28:22'),
(638, 9, 70, 93, '2026-05-09 05:28:22', '2026-05-09 05:28:22'),
(639, 9, 71, 93, '2026-05-09 05:28:22', '2026-05-09 05:28:22'),
(640, 9, 72, 93, '2026-05-09 05:28:22', '2026-05-09 05:28:22'),
(641, 9, 69, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(642, 9, 70, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(643, 9, 71, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(644, 9, 72, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(645, 7, 55, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(646, 7, 56, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(647, 7, 57, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(648, 7, 58, 94, '2026-05-09 05:29:51', '2026-05-09 05:29:51'),
(649, 7, 55, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(650, 7, 56, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(651, 7, 57, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(652, 7, 58, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(653, 8, 62, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(654, 8, 63, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(655, 8, 64, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(656, 8, 65, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(657, 8, 66, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(658, 8, 67, 95, '2026-05-09 05:30:44', '2026-05-09 05:30:44'),
(659, 1, 1, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(660, 1, 2, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(661, 1, 3, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(662, 1, 4, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(663, 3, 29, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(664, 3, 30, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(665, 3, 31, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(666, 3, 32, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(667, 3, 33, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(668, 3, 34, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(669, 3, 35, 97, '2026-05-09 10:04:26', '2026-05-09 10:04:26'),
(670, 9, 69, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(671, 9, 70, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(672, 9, 71, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(673, 9, 72, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(674, 7, 55, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(675, 7, 56, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(676, 7, 57, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(677, 7, 58, 98, '2026-05-09 10:07:27', '2026-05-09 10:07:27'),
(678, 8, 62, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(679, 8, 63, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(680, 8, 64, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(681, 8, 65, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(682, 8, 66, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(683, 8, 67, 99, '2026-05-09 10:09:55', '2026-05-09 10:09:55'),
(684, 1, 1, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(685, 1, 2, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(686, 1, 3, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(687, 1, 4, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(688, 4, 38, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(689, 4, 39, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(690, 4, 40, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(691, 4, 41, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(692, 4, 42, 100, '2026-05-09 10:11:52', '2026-05-09 10:11:52'),
(693, 7, 55, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(694, 7, 56, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(695, 7, 57, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(696, 7, 58, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(697, 8, 62, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(698, 8, 63, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(699, 8, 64, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(700, 8, 65, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(701, 8, 66, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(702, 8, 67, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(703, 1, 1, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(704, 1, 2, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(705, 1, 3, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(706, 1, 4, 101, '2026-05-09 10:14:04', '2026-05-09 10:14:04'),
(707, 8, 62, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(708, 8, 63, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(709, 8, 64, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(710, 8, 65, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(711, 8, 66, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(712, 8, 67, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(713, 1, 1, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(714, 1, 2, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(715, 1, 3, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(716, 1, 4, 102, '2026-05-09 10:16:00', '2026-05-09 10:16:00'),
(717, 8, 62, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(718, 8, 63, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(719, 8, 64, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(720, 8, 65, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(721, 8, 66, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(722, 8, 67, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(723, 1, 1, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(724, 1, 2, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(725, 1, 3, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(726, 1, 4, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(727, 15, 87, 103, '2026-05-09 10:20:20', '2026-05-09 10:20:20'),
(728, 7, 55, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(729, 7, 56, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(730, 7, 57, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(731, 7, 58, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(732, 1, 1, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(733, 1, 2, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(734, 1, 3, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(735, 1, 4, 104, '2026-05-09 10:21:54', '2026-05-09 10:21:54'),
(736, 9, 69, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(737, 9, 70, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(738, 9, 71, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(739, 9, 72, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(740, 1, 1, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(741, 1, 2, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(742, 1, 3, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(743, 1, 4, 105, '2026-05-09 10:23:38', '2026-05-09 10:23:38'),
(744, 9, 69, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(745, 9, 70, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(746, 9, 71, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(747, 9, 72, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(748, 7, 55, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(749, 7, 56, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(750, 7, 57, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(751, 7, 58, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(752, 3, 29, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(753, 3, 30, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(754, 3, 31, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(755, 3, 32, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(756, 3, 33, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(757, 3, 34, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(758, 3, 35, 106, '2026-05-09 10:26:38', '2026-05-09 10:26:38'),
(759, 9, 69, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(760, 9, 70, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(761, 9, 71, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(762, 9, 72, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(763, 7, 55, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(764, 7, 56, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(765, 7, 57, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(766, 7, 58, 107, '2026-05-09 10:28:18', '2026-05-09 10:28:18'),
(767, 1, 1, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(768, 1, 2, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(769, 1, 3, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(770, 1, 4, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(771, 4, 38, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(772, 4, 39, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(773, 4, 40, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(774, 4, 41, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(775, 4, 42, 108, '2026-05-09 10:30:03', '2026-05-09 10:30:03'),
(776, 3, 29, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(777, 3, 30, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(778, 3, 31, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(779, 3, 32, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(780, 3, 33, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(781, 3, 34, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(782, 3, 35, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(783, 4, 38, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(784, 4, 39, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(785, 4, 40, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(786, 4, 41, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(787, 4, 42, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(788, 6, 52, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(789, 6, 53, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(790, 6, 54, 109, '2026-05-09 10:31:48', '2026-05-09 10:31:48'),
(791, 1, 1, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(792, 1, 2, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(793, 1, 3, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(794, 1, 4, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(795, 3, 29, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(796, 3, 30, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(797, 3, 31, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(798, 3, 32, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(799, 3, 33, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(800, 3, 34, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(801, 3, 35, 110, '2026-05-09 10:33:24', '2026-05-09 10:33:24'),
(802, 3, 29, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(803, 3, 30, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(804, 3, 31, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(805, 3, 32, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(806, 3, 33, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(807, 3, 34, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(808, 3, 35, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(809, 4, 38, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(810, 4, 39, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(811, 4, 40, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(812, 4, 41, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(813, 4, 42, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(814, 5, 45, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(815, 5, 46, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(816, 5, 47, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(817, 5, 48, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(818, 12, 86, 111, '2026-05-09 10:35:04', '2026-05-09 10:35:04'),
(819, 7, 55, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(820, 7, 56, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(821, 7, 57, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(822, 7, 58, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(823, 1, 1, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(824, 1, 2, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(825, 1, 3, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(826, 1, 4, 112, '2026-05-09 10:37:14', '2026-05-09 10:37:14'),
(827, 1, 1, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(828, 1, 2, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(829, 1, 3, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(830, 1, 4, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(831, 4, 38, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(832, 4, 39, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(833, 4, 40, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(834, 4, 41, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(835, 4, 42, 113, '2026-05-09 10:46:15', '2026-05-09 10:46:15'),
(836, 1, 1, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(837, 1, 2, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(838, 1, 3, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(839, 1, 4, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(840, 3, 29, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(841, 3, 30, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(842, 3, 31, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(843, 3, 32, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(844, 3, 33, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(845, 3, 34, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(846, 3, 35, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(847, 4, 38, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(848, 4, 39, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(849, 4, 40, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(850, 4, 41, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(851, 4, 42, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(852, 6, 52, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(853, 6, 53, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(854, 6, 54, 114, '2026-05-09 10:47:50', '2026-05-09 10:47:50'),
(855, 9, 69, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(856, 9, 70, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(857, 9, 71, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(858, 9, 72, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(859, 7, 55, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(860, 7, 56, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(861, 7, 57, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(862, 7, 58, 115, '2026-05-09 10:49:23', '2026-05-09 10:49:23'),
(863, 9, 69, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(864, 9, 70, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(865, 9, 71, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(866, 9, 72, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(867, 7, 55, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(868, 7, 56, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(869, 7, 57, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(870, 7, 58, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(871, 15, 87, 116, '2026-05-09 10:50:59', '2026-05-09 10:50:59'),
(872, 1, 1, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(873, 1, 2, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(874, 1, 3, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(875, 1, 4, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(876, 3, 29, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(877, 3, 30, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(878, 3, 31, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(879, 3, 32, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(880, 3, 33, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(881, 3, 34, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(882, 3, 35, 117, '2026-05-09 10:52:46', '2026-05-09 10:52:46'),
(883, 7, 55, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(884, 7, 56, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(885, 7, 57, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(886, 7, 58, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(887, 8, 62, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(888, 8, 63, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(889, 8, 64, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(890, 8, 65, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(891, 8, 66, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(892, 8, 67, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(893, 1, 1, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(894, 1, 2, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(895, 1, 3, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(896, 1, 4, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(897, 6, 52, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(898, 6, 53, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(899, 6, 54, 118, '2026-05-09 10:54:24', '2026-05-09 10:54:24'),
(900, 7, 55, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(901, 7, 56, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(902, 7, 57, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(903, 7, 58, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(904, 1, 1, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(905, 1, 2, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(906, 1, 3, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(907, 1, 4, 119, '2026-05-09 10:55:53', '2026-05-09 10:55:53'),
(908, 3, 29, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(909, 3, 30, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(910, 3, 31, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(911, 3, 32, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(912, 3, 33, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(913, 3, 34, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(914, 3, 35, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(915, 4, 38, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(916, 4, 39, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(917, 4, 40, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(918, 4, 41, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(919, 4, 42, 120, '2026-05-09 10:57:21', '2026-05-09 10:57:21'),
(920, 1, 3, 121, '2026-05-09 10:59:41', '2026-05-09 10:59:41'),
(921, 1, 4, 121, '2026-05-09 10:59:41', '2026-05-09 10:59:41'),
(922, 3, 33, 121, '2026-05-09 10:59:41', '2026-05-09 10:59:41'),
(923, 3, 34, 121, '2026-05-09 10:59:41', '2026-05-09 10:59:41'),
(924, 1, 1, 122, '2026-05-09 11:02:12', '2026-05-09 11:02:12'),
(925, 1, 2, 123, '2026-05-09 11:04:07', '2026-05-09 11:04:07'),
(926, 1, 2, 124, '2026-05-09 11:06:01', '2026-05-09 11:06:01'),
(928, 1, 2, 125, '2026-05-09 11:08:03', '2026-05-09 11:08:03'),
(929, 1, 4, 126, '2026-05-09 11:10:57', '2026-05-09 11:10:57'),
(931, 1, 4, 127, '2026-05-09 11:13:07', '2026-05-09 11:13:07'),
(932, 1, 2, 128, '2026-05-09 11:14:51', '2026-05-09 11:14:51'),
(933, 1, 3, 128, '2026-05-09 11:14:51', '2026-05-09 11:14:51'),
(934, 1, 2, 129, '2026-05-09 11:16:27', '2026-05-09 11:16:27'),
(935, 1, 2, 130, '2026-05-09 11:18:09', '2026-05-09 11:18:09'),
(936, 1, 2, 131, '2026-05-09 11:19:43', '2026-05-09 11:19:43'),
(937, 1, 2, 132, '2026-05-09 11:21:23', '2026-05-09 11:21:23'),
(938, 1, 2, 134, '2026-05-09 11:25:03', '2026-05-09 11:25:03'),
(939, 1, 2, 135, '2026-05-09 11:26:48', '2026-05-09 11:26:48'),
(940, 1, 1, 136, '2026-05-09 11:28:37', '2026-05-09 11:28:37'),
(941, 1, 3, 136, '2026-05-09 11:28:37', '2026-05-09 11:28:37'),
(942, 1, 2, 137, '2026-05-09 11:30:19', '2026-05-09 11:30:19'),
(943, 1, 2, 138, '2026-05-09 11:31:47', '2026-05-09 11:31:47'),
(944, 1, 1, 139, '2026-05-09 11:33:27', '2026-05-09 11:33:27'),
(945, 1, 1, 140, '2026-05-09 11:35:19', '2026-05-09 11:35:19'),
(946, 8, 63, 141, '2026-05-09 11:37:05', '2026-05-09 11:37:05'),
(947, 8, 65, 141, '2026-05-09 11:37:05', '2026-05-09 11:37:05'),
(948, 1, 2, 142, '2026-05-09 11:38:41', '2026-05-09 11:38:41'),
(949, 1, 4, 143, '2026-05-09 11:41:11', '2026-05-09 11:41:11'),
(950, 1, 2, 144, '2026-05-09 11:42:52', '2026-05-09 11:42:52'),
(951, 1, 2, 145, '2026-05-09 11:44:34', '2026-05-09 11:44:34'),
(952, 1, 3, 146, '2026-05-09 11:47:01', '2026-05-09 11:47:01'),
(953, 1, 1, 147, '2026-05-09 11:48:39', '2026-05-09 11:48:39'),
(954, 1, 2, 148, '2026-05-09 11:50:06', '2026-05-09 11:50:06'),
(955, 1, 3, 148, '2026-05-09 11:50:06', '2026-05-09 11:50:06'),
(956, 1, 2, 149, '2026-05-09 11:51:37', '2026-05-09 11:51:37'),
(957, 1, 3, 150, '2026-05-09 11:53:17', '2026-05-09 11:53:17'),
(958, 1, 1, 152, '2026-05-09 14:56:24', '2026-05-09 14:56:24'),
(959, 1, 2, 152, '2026-05-09 14:56:24', '2026-05-09 14:56:24'),
(960, 1, 3, 152, '2026-05-09 14:56:24', '2026-05-09 14:56:24'),
(961, 1, 4, 152, '2026-05-09 14:56:24', '2026-05-09 14:56:24'),
(962, 6, 52, 133, '2026-05-12 13:29:04', '2026-05-12 13:29:04'),
(963, 6, 53, 133, '2026-05-12 13:29:04', '2026-05-12 13:29:04'),
(964, 6, 54, 133, '2026-05-12 13:29:04', '2026-05-12 13:29:04');

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `journey_types`
--

CREATE TABLE `journey_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `modified_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `journey_types`
--

INSERT INTO `journey_types` (`id`, `name`, `status`, `created_by`, `modified_by`, `created_at`, `updated_at`) VALUES
(1, 'Friends', 'active', NULL, NULL, '2025-11-12 12:02:55', '2025-11-12 12:02:55'),
(2, 'Family', 'active', NULL, NULL, '2025-11-12 12:02:55', '2025-11-12 12:02:55'),
(3, 'Self', 'active', NULL, NULL, '2025-11-12 12:02:55', '2025-11-12 12:02:55'),
(4, 'Couple', 'active', NULL, NULL, '2025-11-12 12:02:55', '2025-11-12 12:02:55'),
(5, 'Other', 'active', NULL, NULL, '2025-11-12 12:02:55', '2025-11-12 12:02:55');

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `receiver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `message` text DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `status` enum('seen','delivered','sent','') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `user_id`, `receiver_id`, `message`, `attachment`, `status`, `created_at`, `updated_at`) VALUES
(1, 12, 7, 'hello chunmun', NULL, 'delivered', '2026-01-15 06:02:12', '2026-01-15 06:02:12'),
(2, 12, 7, 'hi', NULL, 'delivered', '2026-01-15 06:03:28', '2026-01-16 13:36:26'),
(3, 12, 7, NULL, 'attachments/1768476833_user.jpg', 'delivered', '2026-01-15 06:03:53', '2026-01-16 13:36:26'),
(4, 12, 7, NULL, 'attachments/1768476845_admin.png', 'delivered', '2026-01-15 06:04:05', '2026-01-16 13:36:26'),
(5, 12, 8, 'hii', NULL, 'sent', '2026-01-15 06:04:18', '2026-01-15 06:04:18'),
(6, 12, 7, 'hiii', NULL, 'delivered', '2026-01-16 12:34:29', '2026-01-16 13:36:26'),
(7, 12, 10, 'dd', NULL, 'sent', '2026-01-16 12:52:42', '2026-01-16 12:52:42'),
(8, 12, 10, NULL, 'attachments/1768587774_IMG-20251201-WA0002.jpg', 'sent', '2026-01-16 12:52:54', '2026-01-16 12:52:54'),
(9, 7, 13, 'hi', NULL, 'sent', '2026-01-16 13:36:31', '2026-01-16 13:36:31'),
(10, 7, 13, 'hiii', NULL, 'sent', '2026-01-16 13:36:37', '2026-01-16 13:36:37'),
(11, 5, 4, 'hii', NULL, 'sent', '2026-01-19 00:33:37', '2026-01-19 00:33:37'),
(12, 5, 3, 'hii', NULL, 'delivered', '2026-01-19 00:33:51', '2026-01-19 03:11:51'),
(13, 5, 7, 'hii', NULL, 'sent', '2026-01-19 00:34:08', '2026-01-19 00:34:08'),
(14, 5, 3, 'hii', NULL, 'delivered', '2026-01-19 00:34:22', '2026-01-19 03:11:51'),
(15, 5, 1, 'hiii', NULL, 'sent', '2026-01-19 02:24:03', '2026-01-19 02:24:03'),
(16, 5, 2, 'hii', NULL, 'sent', '2026-01-19 02:30:25', '2026-01-19 02:30:25'),
(17, 3, 5, 'hlw', NULL, 'delivered', '2026-01-19 03:11:58', '2026-01-19 03:11:59'),
(18, 5, 3, 'how are you?', NULL, 'delivered', '2026-01-19 03:12:11', '2026-01-19 03:12:11'),
(19, 5, 2, NULL, 'attachments/1768824751_user.jpg', 'sent', '2026-01-19 06:42:31', '2026-01-19 06:42:31'),
(20, 5, 2, 'hiii', NULL, 'sent', '2026-01-19 06:42:46', '2026-01-19 06:42:46'),
(21, 5, 2, 'hiiii', NULL, 'sent', '2026-01-19 06:42:48', '2026-01-19 06:42:48'),
(22, 5, 2, 'jiii', NULL, 'sent', '2026-01-19 06:42:49', '2026-01-19 06:42:49'),
(23, 5, 2, 'hiii', NULL, 'sent', '2026-01-19 06:42:51', '2026-01-19 06:42:51'),
(24, 3, 2, NULL, 'attachments/1768825334_INV-2.pdf', 'delivered', '2026-01-19 06:52:14', '2026-01-20 01:10:38'),
(25, 3, 2, NULL, 'attachments/1768825336_INV-2.pdf', 'delivered', '2026-01-19 06:52:16', '2026-01-20 01:10:38'),
(26, 5, 3, NULL, 'attachments/1768830228_admin.png', 'delivered', '2026-01-19 08:13:48', '2026-01-19 23:09:37'),
(27, 3, 6, 'hii', NULL, 'sent', '2026-01-20 00:13:13', '2026-01-20 00:13:13'),
(28, 2, 3, 'hii', NULL, 'delivered', '2026-01-20 01:11:12', '2026-01-20 01:11:38'),
(30, 2, 3, 'hi', NULL, 'delivered', '2026-05-08 00:11:18', '2026-05-08 00:12:36'),
(31, 2, 3, 'hello', NULL, 'delivered', '2026-05-08 00:11:23', '2026-05-08 00:12:36'),
(32, 3, 2, 'how are you', NULL, 'delivered', '2026-05-08 00:12:44', '2026-05-08 00:12:53'),
(33, 2, 3, 'i am fine', NULL, 'delivered', '2026-05-08 00:13:12', '2026-05-08 00:13:12'),
(34, 3, 2, 'great', NULL, 'delivered', '2026-05-08 00:13:23', '2026-05-08 00:13:23');

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2025_09_15_192003_add_two_factor_columns_to_users_table', 1),
(5, '2025_09_15_192016_create_personal_access_tokens_table', 1),
(6, '2025_09_15_192016_create_teams_table', 1),
(7, '2025_09_15_192017_create_team_user_table', 1),
(8, '2025_09_15_192018_create_team_invitations_table', 1),
(9, '2025_09_17_064323_create_permission_tables', 1),
(10, '2025_09_18_064324_create_roles_table', 2),
(11, '2025_09_20_072208_create_clients_table', 2),
(12, '2025_09_20_103241_create_projects_table', 2),
(13, '2025_09_20_111830_create_currencies_table', 2),
(14, '2025_09_20_111931_create_payable_modes_table', 2),
(15, '2025_09_20_111938_create_project_statuses_table', 2),
(16, '2025_09_22_113555_create_employees_table', 2),
(17, '2025_09_24_082931_create_employee_project_mapping_table', 2),
(27, '2025_09_30_091118_create_templates_table', 3),
(28, '2025_09_30_091119_create_contracts_table', 4),
(29, '2025_10_07_105427_create_blacklists_table', 4),
(30, '2025_10_09_052004_create_vessels_table', 4),
(31, '2025_10_09_052023_create_vessel_documents_table', 4),
(32, '2025_10_10_130324_create_contract_template_salaries_table', 4),
(36, '2025_10_14_115630_create_contract_extensions_table', 5),
(37, '2025_10_15_101026_create_payrolls_table', 5),
(41, '2025_10_17_052543_create_contract_histories_table', 6),
(42, '2025_10_23_065654_create_subsea_contracts_table', 6),
(43, '2025_11_03_102650_create_timesheets_table', 7);

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

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `post_name` enum('offer','requirement','journey','') NOT NULL,
  `sender_id` int(11) NOT NULL,
  `receiver_id` int(11) NOT NULL,
  `offer_id` int(11) DEFAULT NULL,
  `post_id` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `post_name`, `sender_id`, `receiver_id`, `offer_id`, `post_id`, `status`, `created_at`, `updated_at`, `updated_by`) VALUES
(1, 'offer', 6, 6, NULL, 12, 0, '2025-11-28 00:57:19', '2025-11-28 00:57:19', 6),
(3, 'journey', 6, 7, 2, 21, 1, '2025-11-28 01:03:07', NULL, NULL),
(4, 'journey', 6, 3, 3, 23, 1, '2025-11-28 01:03:07', NULL, NULL),
(5, 'journey', 6, 7, 4, 21, 1, '2025-11-28 01:27:09', NULL, NULL),
(6, 'journey', 6, 3, 5, 23, 1, '2025-11-28 01:27:09', NULL, NULL),
(7, 'journey', 6, 7, 6, 21, 1, '2025-11-28 01:27:42', NULL, NULL),
(8, 'journey', 6, 3, 7, 23, 1, '2025-11-28 01:27:42', NULL, NULL),
(9, 'journey', 6, 3, 8, 22, 1, '2025-11-28 01:27:42', NULL, NULL),
(10, 'requirement', 6, 5, 6, 8, 1, '2025-11-28 03:18:56', NULL, NULL),
(11, 'requirement', 6, 5, 7, 8, 1, '2025-11-28 03:28:26', NULL, NULL),
(12, 'requirement', 6, 3, 8, 7, 1, '2025-11-28 03:31:35', NULL, NULL),
(13, 'requirement', 6, 3, 9, 7, 2, '2025-11-28 03:33:21', '2026-05-04 11:59:53', 3),
(14, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:49:20', '2026-01-13 02:49:20', 5),
(15, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:50:04', '2026-01-13 02:50:04', 5),
(16, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:51:51', '2026-01-13 02:51:51', 5),
(17, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:53:20', '2026-01-13 02:53:20', 5),
(18, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:54:06', '2026-01-13 02:54:06', 5),
(19, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:54:15', '2026-01-13 02:54:15', 5),
(20, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 02:59:03', '2026-01-13 02:59:03', 5),
(21, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 03:06:19', '2026-01-13 03:06:19', 5),
(22, 'offer', 5, 5, NULL, 12, 0, '2026-01-13 03:12:26', '2026-01-13 03:12:26', 5),
(23, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 03:34:56', '2026-01-13 03:34:56', 5),
(24, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 03:35:47', '2026-01-13 03:35:47', 5),
(25, 'offer', 5, 5, NULL, 11, 0, '2026-01-13 04:47:42', '2026-01-13 04:47:42', 5),
(26, 'offer', 5, 5, NULL, 13, 0, '2026-01-13 05:00:00', '2026-01-13 05:00:00', 5),
(27, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 05:03:36', '2026-01-13 05:03:36', 5),
(28, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 05:09:22', '2026-01-13 05:09:22', 5),
(29, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 05:30:27', '2026-01-13 05:30:27', 5),
(30, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 05:51:11', '2026-01-13 05:51:11', 5),
(31, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 05:54:29', '2026-01-13 05:54:29', 5),
(32, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 06:01:41', '2026-01-13 06:01:41', 5),
(33, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 06:11:43', '2026-01-13 06:11:43', 5),
(34, 'offer', 5, 5, NULL, 14, 0, '2026-01-13 06:13:27', '2026-01-13 06:13:27', 5),
(36, 'offer', 5, 5, NULL, 11, 0, '2026-01-14 00:27:00', '2026-01-14 00:27:00', 5),
(37, 'offer', 5, 5, NULL, 11, 0, '2026-01-14 00:29:30', '2026-01-14 00:29:30', 5),
(38, 'offer', 5, 5, NULL, 11, 0, '2026-01-14 00:31:06', '2026-01-14 00:31:06', 5),
(39, 'offer', 5, 5, NULL, 12, 0, '2026-01-14 00:33:05', '2026-01-14 00:33:05', 5),
(40, 'offer', 5, 5, NULL, 13, 0, '2026-01-14 00:34:06', '2026-01-14 00:34:06', 5),
(41, 'offer', 5, 5, NULL, 14, 0, '2026-01-14 00:35:26', '2026-01-14 00:35:26', 5),
(42, 'offer', 5, 5, NULL, 11, 0, '2026-01-14 06:31:10', '2026-01-14 06:31:10', 5),
(43, 'offer', 5, 5, NULL, 13, 0, '2026-01-14 06:33:04', '2026-01-14 06:33:04', 5),
(44, 'offer', 5, 5, NULL, 11, 0, '2026-05-08 00:42:12', '2026-05-08 00:42:12', 5),
(45, 'offer', 97, 97, NULL, 12, 0, '2026-05-12 04:55:36', '2026-05-12 04:55:36', 97),
(46, 'offer', 98, 98, NULL, 13, 0, '2026-05-12 05:19:25', '2026-05-12 05:19:25', 98),
(47, 'offer', 99, 99, NULL, 12, 0, '2026-05-12 05:22:15', '2026-05-12 05:22:15', 99),
(48, 'offer', 100, 100, NULL, 12, 0, '2026-05-12 05:24:50', '2026-05-12 05:24:50', 100),
(49, 'offer', 101, 101, NULL, 12, 0, '2026-05-12 05:36:21', '2026-05-12 05:36:21', 101),
(50, 'offer', 102, 102, NULL, 14, 0, '2026-05-12 05:59:06', '2026-05-12 05:59:06', 102),
(51, 'offer', 103, 103, NULL, 11, 0, '2026-05-12 06:00:29', '2026-05-12 06:00:29', 103),
(52, 'offer', 104, 104, NULL, 12, 0, '2026-05-12 06:05:06', '2026-05-12 06:05:06', 104),
(53, 'offer', 105, 105, NULL, 12, 0, '2026-05-12 06:07:43', '2026-05-12 06:07:43', 105),
(54, 'offer', 106, 106, NULL, 13, 0, '2026-05-12 06:11:15', '2026-05-12 06:11:15', 106),
(55, 'offer', 106, 106, NULL, 14, 0, '2026-05-12 06:11:39', '2026-05-12 06:11:39', 106),
(56, 'offer', 107, 107, NULL, 12, 0, '2026-05-12 06:13:45', '2026-05-12 06:13:45', 107),
(57, 'offer', 108, 108, NULL, 11, 0, '2026-05-12 06:16:21', '2026-05-12 06:16:21', 108),
(58, 'offer', 109, 109, NULL, 12, 0, '2026-05-12 06:19:34', '2026-05-12 06:19:34', 109),
(59, 'offer', 110, 110, NULL, 13, 0, '2026-05-12 06:20:42', '2026-05-12 06:20:42', 110),
(60, 'offer', 111, 111, NULL, 13, 0, '2026-05-12 06:21:51', '2026-05-12 06:21:51', 111),
(61, 'offer', 112, 112, NULL, 13, 0, '2026-05-12 06:23:01', '2026-05-12 06:23:01', 112),
(62, 'offer', 113, 113, NULL, 12, 0, '2026-05-12 06:29:16', '2026-05-12 06:29:16', 113),
(63, 'offer', 150, 150, NULL, 11, 0, '2026-05-12 06:45:50', '2026-05-12 06:45:50', 150),
(64, 'offer', 149, 149, NULL, 11, 0, '2026-05-12 06:47:52', '2026-05-12 06:47:52', 149),
(65, 'offer', 148, 148, NULL, 11, 0, '2026-05-12 06:52:53', '2026-05-12 06:52:53', 148),
(66, 'offer', 147, 147, NULL, 13, 0, '2026-05-12 06:56:50', '2026-05-12 06:56:50', 147),
(67, 'offer', 114, 114, NULL, 12, 0, '2026-05-12 07:17:07', '2026-05-12 07:17:07', 114),
(68, 'offer', 146, 146, NULL, 14, 0, '2026-05-12 07:17:23', '2026-05-12 07:17:23', 146),
(69, 'offer', 115, 115, NULL, 14, 0, '2026-05-12 07:18:29', '2026-05-12 07:18:29', 115),
(70, 'offer', 145, 145, NULL, 12, 0, '2026-05-12 07:19:34', '2026-05-12 07:19:34', 145),
(71, 'offer', 116, 116, NULL, 11, 0, '2026-05-12 07:19:46', '2026-05-12 07:19:46', 116),
(72, 'offer', 117, 117, NULL, 12, 0, '2026-05-12 07:21:22', '2026-05-12 07:21:22', 117),
(73, 'offer', 144, 144, NULL, 12, 0, '2026-05-12 07:22:48', '2026-05-12 07:22:48', 144),
(74, 'offer', 118, 118, NULL, 11, 0, '2026-05-12 07:24:04', '2026-05-12 07:24:04', 118),
(75, 'offer', 119, 119, NULL, 12, 0, '2026-05-12 07:25:54', '2026-05-12 07:25:54', 119),
(76, 'offer', 120, 120, NULL, 13, 0, '2026-05-12 07:29:48', '2026-05-12 07:29:48', 120),
(77, 'offer', 120, 120, NULL, 11, 0, '2026-05-12 07:30:09', '2026-05-12 07:30:09', 120),
(78, 'offer', 121, 121, NULL, 14, 0, '2026-05-12 07:31:59', '2026-05-12 07:31:59', 121),
(79, 'offer', 143, 143, NULL, 11, 0, '2026-05-12 07:35:39', '2026-05-12 07:35:39', 143),
(80, 'offer', 122, 122, NULL, 11, 0, '2026-05-12 07:36:44', '2026-05-12 07:36:44', 122),
(81, 'offer', 142, 142, NULL, 12, 0, '2026-05-12 07:37:32', '2026-05-12 07:37:32', 142),
(82, 'offer', 123, 123, NULL, 13, 0, '2026-05-12 07:38:33', '2026-05-12 07:38:33', 123),
(83, 'offer', 141, 141, NULL, 13, 0, '2026-05-12 07:39:20', '2026-05-12 07:39:20', 141),
(84, 'offer', 124, 124, NULL, 11, 0, '2026-05-12 07:39:42', '2026-05-12 07:39:42', 124),
(85, 'offer', 125, 125, NULL, 13, 0, '2026-05-12 07:41:20', '2026-05-12 07:41:20', 125),
(86, 'offer', 140, 140, NULL, 13, 0, '2026-05-12 07:41:46', '2026-05-12 07:41:46', 140),
(87, 'offer', 126, 126, NULL, 14, 0, '2026-05-12 07:42:52', '2026-05-12 07:42:52', 126),
(88, 'offer', 139, 139, NULL, 12, 0, '2026-05-12 07:44:37', '2026-05-12 07:44:37', 139),
(89, 'offer', 127, 127, NULL, 12, 0, '2026-05-12 07:45:01', '2026-05-12 07:45:01', 127),
(90, 'offer', 128, 128, NULL, 14, 0, '2026-05-12 07:46:24', '2026-05-12 07:46:24', 128),
(91, 'offer', 138, 138, NULL, 13, 0, '2026-05-12 07:47:17', '2026-05-12 07:47:17', 138),
(92, 'offer', 129, 129, NULL, 12, 0, '2026-05-12 07:47:51', '2026-05-12 07:47:51', 129),
(93, 'offer', 130, 130, NULL, 11, 0, '2026-05-12 07:48:55', '2026-05-12 07:48:55', 130),
(94, 'offer', 137, 137, NULL, 14, 0, '2026-05-12 07:49:42', '2026-05-12 07:49:42', 137),
(95, 'offer', 131, 131, NULL, 13, 0, '2026-05-12 07:50:33', '2026-05-12 07:50:33', 131),
(96, 'offer', 132, 132, NULL, 13, 0, '2026-05-12 07:51:27', '2026-05-12 07:51:27', 132),
(97, 'offer', 136, 136, NULL, 13, 0, '2026-05-12 07:52:10', '2026-05-12 07:52:10', 136),
(98, 'offer', 135, 135, NULL, 11, 0, '2026-05-12 07:54:04', '2026-05-12 07:54:04', 135),
(99, 'offer', 134, 134, NULL, 11, 0, '2026-05-12 07:55:58', '2026-05-12 07:55:58', 134),
(100, 'offer', 133, 133, NULL, 13, 0, '2026-05-12 07:57:47', '2026-05-12 07:57:47', 133),
(101, 'offer', 97, 97, NULL, 11, 0, '2026-05-13 04:24:01', '2026-05-13 04:24:01', 97);

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

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` int(11) NOT NULL,
  `vendor_id` int(11) NOT NULL,
  `offer_in` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valid_from` date DEFAULT NULL,
  `valid_till` date DEFAULT NULL,
  `short_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(265) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(265) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `is_active` enum('Waiting for approval','Approved','Rejected','Deleted') DEFAULT 'Waiting for approval',
  `wishlist` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offers`
--

INSERT INTO `offers` (`id`, `vendor_id`, `offer_in`, `title`, `offer_value`, `location`, `pincode`, `valid_from`, `valid_till`, `short_description`, `default_image`, `slug`, `description`, `remark`, `lat`, `lng`, `created`, `modified`, `modified_by`, `created_by`, `is_active`, `wishlist`) VALUES
(1, 4, 'value', 'test offer1', '888', 'city2', '444', '2025-11-26', '2025-11-23', '8yyuyuyu', '1763805221_still-life-water-with-peacock-feather.jpg', '8yyuyuyu', 'long desciption', NULL, NULL, NULL, '2025-11-22 09:53:41', '2025-11-22 11:31:27', 2, 2, 'Waiting for approval', 1),
(2, 4, 'percent', 'ee', '885', 'city3', '96', '2025-11-29', '2025-11-28', 'ff', '1763805307_backaadhr.jpeg', 'ff', '<p>nhh</p>', NULL, NULL, NULL, '2025-11-22 09:55:07', '2025-11-22 09:55:07', 2, 2, 'Approved', 1),
(3, 6, 'value', 'new offer', '500', 'city2', '446644', '2025-11-30', '2025-11-29', 'short des', '1763814979_admin.png', 'short-des', '<p>long desc</p>', NULL, NULL, NULL, '2025-11-22 12:36:19', '2025-11-22 12:36:19', 6, 6, 'Approved', 1),
(4, 6, 'percent', 'world bigggest offer', '74', 'city1', '855995', '2025-11-21', '2025-11-26', 'hghgh', '1764010528_backaadhr.jpeg', 'hghgh', '<p>ghghgh</p>', NULL, NULL, NULL, '2025-11-24 18:55:28', '2025-11-24 18:55:28', 2, 2, 'Approved', 0),
(5, 4, 'value', 'Near Offer 1', '200', 'Bandra', '400050', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-1', '', NULL, '19.0600', '72.8300', '2025-11-25 13:52:21', '2025-11-25 13:52:21', 1, 1, 'Approved', 0),
(6, 4, 'percent', 'Near Offer 2', '50', 'Andheri', '400053', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-2', '', NULL, '19.1200', '72.8440', '2025-11-25 13:52:21', '2025-11-25 13:52:21', 1, 1, 'Approved', 0),
(7, 6, 'value', 'Near Offer 3', '100', 'Juhu', '400049', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-3', '', NULL, '19.1000', '72.8260', '2025-11-25 13:52:21', '2025-11-25 13:52:21', 1, 1, 'Approved', 1),
(8, 4, 'value', 'Near Offer 1', '200', 'Bandra', '400050', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-1', '', NULL, '19.0600', '72.8300', '2025-11-25 13:53:13', '2025-11-25 13:53:13', 1, 1, 'Approved', 1),
(9, 4, 'percent', 'Near Offer 2', '50', 'Andheri', '400053', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-2', '', NULL, '19.1200', '72.8440', '2025-11-25 13:53:13', '2025-11-25 13:53:13', 1, 1, 'Approved', 0),
(10, 6, 'value', 'Near Offer 3', '100', 'Juhu', '400049', '2025-11-20', '2025-11-30', 'near offer', '', 'near-offer-3', '', NULL, '19.1000', '72.8260', '2025-11-25 13:53:13', '2025-11-25 13:53:13', 1, 1, 'Approved', 1),
(11, 4, 'value', 'Far Offer Delhi', '300', 'Delhi', '110001', '2025-11-20', '2025-11-30', 'far offer', '', 'far-offer-delhi', '', NULL, '28.7041', '77.1025', '2025-11-25 13:53:37', '2025-11-25 13:53:37', 1, 1, 'Approved', 0),
(12, 6, 'percent', 'Far Offer Pune', '40', 'Pune', '411001', '2025-11-20', '2025-11-30', 'far offer', '', 'far-offer-pune', '', NULL, '18.5204', '73.8567', '2025-11-25 13:53:37', '2025-11-25 13:53:37', 1, 1, 'Approved', 1),
(13, 6, 'value', 'hight offer', '80', 'city2', '8520', '2025-11-22', '2025-11-30', 'ffdf', '1764083197_backaadhr.jpeg', 'ffdf', '<p>highest offer</p>', NULL, NULL, NULL, '2025-11-25 15:06:37', '2025-11-25 15:06:37', 2, 2, 'Approved', 0),
(14, 5, 'percent', 'Demo offers', '10', '400059 - Seven Hills Health Care Private Limited Hospital Blood Bank, Mumbai, Mumbai Suburban, Maharashtra', '400059', '2025-01-01', '2028-12-31', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an', '1772131219_pexels-quang-nguyen-vinh-222549-2166711.jpg', 'lorem-ipsum-is-simply-dummy-text-of-the-printing-and-typesetting-industry-lorem-ipsum-has-been-the-industrys-standard-dummy-text-ever-since-the-1500s-when-an', '<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.&nbsp;</p>', NULL, '19.118345', '72.878146', '2026-02-26 18:40:19', '2026-02-26 18:40:19', 2, 2, 'Approved', 0),
(15, 6, 'value', 'smandam offers', '100', '411014 - Apollo Clinic, Pune, Pune, Maharashtra', '411014', '2025-01-01', '2027-02-01', 'Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years o', '1772131574_pexels-cahilrom-2088282.jpg', 'contrary-to-popular-belief-lorem-ipsum-is-not-simply-random-text-it-has-roots-in-a-piece-of-classical-latin-literature-from-45-bc-making-it-over-2000-years-o', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem</p>', NULL, '18.529551', '73.834344', '2026-02-26 18:46:14', '2026-02-26 18:46:14', 2, 2, 'Approved', 0),
(16, 5, 'percent', 'Test offer', '10', '440010 - [\'Oriental Bank of Commerce\', \'OBC\'], Nagpur, Nagpur, Maharashtra', '440010', '2026-05-10', '2026-05-31', 'Test', '1778329088_4EE900F7-4746-4233-938E-4BFF85793F2B.jpeg', 'test', '<p>Te st</p>', NULL, '21.112042', '79.066651', '2026-05-09 12:18:08', '2026-05-09 12:18:08', 5, 5, 'Approved', 0),
(17, 97, 'percent', 'Summar Sale', '10', '400064 - [\'Palm Spring C Wing\', \'PS C WING\'], Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-06', '2026-05-22', NULL, NULL, '', NULL, NULL, NULL, NULL, '2026-05-12 10:38:42', '2026-05-12 10:38:42', 97, 97, 'Approved', 0),
(18, 98, 'value', 'Sumamr Sale 2', '1000', '400064 - 11 evershine nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-14', '2026-05-22', NULL, NULL, '', NULL, NULL, '19.192586', '72.833243', '2026-05-12 10:51:02', '2026-05-12 10:51:02', 98, 98, 'Rejected', 0),
(19, 99, 'percent', 'Summer sale3', '15', '400064 - 11 evershine nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-15', NULL, NULL, '', NULL, NULL, NULL, NULL, '2026-05-12 10:53:18', '2026-05-12 10:53:18', 99, 99, 'Rejected', 0),
(20, 100, 'percent', 'Winter Sale', '18', '400064 - 1 Malad Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-11', '2026-05-21', 'asdfsacsdsadsadsdafsafsfasdfsad', NULL, 'asdfsacsdsadsadsdafsafsfasdfsad', NULL, NULL, '19.186209', '72.833927', '2026-05-12 10:56:57', '2026-05-12 10:56:57', 100, 100, 'Approved', 0),
(21, 101, 'percent', 'Summer SAle 4', '20', '400064 - 11 evershine nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-03', '2026-05-21', NULL, NULL, '', NULL, NULL, '19.192586', '72.833243', '2026-05-12 11:07:39', '2026-05-12 11:07:39', 101, 101, 'Rejected', 0),
(22, 102, 'value', 'Autumn Sale', '250', '400064 - 123 UShma Nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-30', NULL, NULL, '', NULL, NULL, '19.191155', '72.833503', '2026-05-12 11:30:01', '2026-05-12 11:30:01', 102, 102, 'Rejected', 0),
(23, 103, 'percent', 'Sale', '25', '400064 - 31 a Goregaon Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-11', '2026-05-28', NULL, NULL, '', NULL, NULL, '19.191289', '72.832791', '2026-05-12 11:31:17', '2026-05-12 11:31:17', 103, 103, 'Approved', 0),
(24, 104, 'percent', 'Sales', '15', '400064 - 31 a Goregaon Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-11', '2026-07-24', NULL, NULL, '', NULL, NULL, '19.191289', '72.832791', '2026-05-12 11:36:13', '2026-05-12 11:36:13', 104, 104, 'Rejected', 0),
(25, 105, 'percent', 'asdads', '15', '400064 - 11107, Ganga Niwas Chincholi Bunder, Link Road Junction, Malad (W), Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-11', '2026-05-27', NULL, NULL, '', NULL, NULL, '19.180282', '72.836023', '2026-05-12 11:38:23', '2026-05-12 11:38:23', 105, 105, 'Rejected', 0),
(26, 106, 'percent', 'adafsdfdsf', '12', '400064 - 2nd Dominic Lane, Orlem Malad, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-10', '2026-05-29', 'adsdvfbgnghmhmjh,vsfscscfasffdsad', NULL, 'adsdvfbgnghmhmjhvsfscscfasffdsad', NULL, NULL, '19.196255', '72.839701', '2026-05-12 11:42:56', '2026-05-12 11:42:56', 106, 106, 'Rejected', 0),
(27, 107, 'value', 'awddcscsc', '5000', '400064 - 2nd Dominic Lane, Orlem Malad, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-22', '5000 off on Min purchase of 1 lacs', NULL, '5000-off-on-min-purchase-of-1-lacs', NULL, NULL, '19.196255', '72.839701', '2026-05-12 11:44:59', '2026-05-12 11:44:59', 107, 107, 'Approved', 0),
(28, 108, 'percent', 'zsczxcxzcxzc', '13', '400064 - 106 Palm spring Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-15', 'rhdfngfmghm,hj,jk,.gjgjfghdfgdgsdf', NULL, 'rhdfngfmghmhjjkgjgjfghdfgdgsdf', NULL, NULL, '19.185831', '72.834282', '2026-05-12 11:47:05', '2026-05-12 11:47:05', 108, 108, 'Approved', 0),
(29, 108, 'percent', 'ascfdscsvcdcv', '15', '400064 - 11 evershine nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-29', 'asfsdgvdfbdfnbmghmngn', NULL, 'asfsdgvdfbdfnbmghmngn', NULL, NULL, '19.192586', '72.833243', '2026-05-12 11:47:56', '2026-05-12 11:47:56', 108, 108, 'Approved', 0),
(30, 109, 'value', 'zszzxczczczc', '2000', '400064 - 11 evershine nagar, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-06', '2026-05-09', 'Sdfsdgsdgdsgdsfgdsf', NULL, 'sdfsdgsdgdsgdsfgdsf', NULL, NULL, '19.192586', '72.833243', '2026-05-12 11:50:20', '2026-05-12 11:50:20', 109, 109, 'Approved', 0),
(31, 110, 'percent', 'Sczsczxvczv', '50', '400064 - 345 Adarsha Dughdalaya Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-22', 'asfsafsasaf', NULL, 'asfsafsasaf', NULL, NULL, '19.196077', '72.843754', '2026-05-12 11:51:26', '2026-05-12 11:51:26', 110, 110, 'Approved', 0),
(32, 111, 'percent', 'sefgdsfzfczsc', '12', '400064 - 31 a Goregaon Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-13', '2026-05-21', 'asdfsdgdfhfgjhgmio87oiyutfhdfgs', NULL, 'asdfsdgdfhfgjhgmio87oiyutfhdfgs', NULL, NULL, '19.191289', '72.832791', '2026-05-12 11:52:30', '2026-05-12 11:52:30', 111, 111, 'Approved', 0),
(33, 112, 'percent', 'asdzczCz', '6', '400064 - 31 a Goregaon Link Road, Mumbai, Mumbai Suburban, Maharashtra', '400064', '2026-05-11', '2026-05-22', 'Sfdsvdxfbmjgfjgffhhdr', NULL, 'sfdsvdxfbmjgfjgffhhdr', NULL, NULL, '19.191289', '72.832791', '2026-05-12 11:53:40', '2026-05-12 11:53:40', 112, 112, 'Approved', 0),
(34, 113, 'percent', 'sfdsvdxvxzvxzc', '15', '400067 - [\'Bank of Baroda\', \'BoB\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-13', '2026-05-29', 'zczdvdsgbfdgfdgfdgfd', NULL, 'zczdvdsgbfdgfdgfdgfd', NULL, NULL, '19.210275', '72.836368', '2026-05-12 12:00:04', '2026-05-12 12:00:04', 113, 113, 'Approved', 0),
(35, 150, 'percent', 'Vacation Sale', '10', '700008 - 126 Raja Rammohan Roy Road, Ramkrishna Park, Kolkata, Kolkata, West Bengal', '700008', '2026-05-12', '2026-05-15', 'For all the students who have summer vacays', NULL, 'for-all-the-students-who-have-summer-vacays', NULL, NULL, '22.489076', '88.325163', '2026-05-12 12:17:00', '2026-05-12 12:17:00', 150, 150, 'Approved', 0),
(36, 149, 'percent', 'Summer Drinks', '15', '700008 - 196 Diamond Harbour Road, Kolkata, Kolkata, West Bengal', '700008', '2026-05-12', '2026-05-16', NULL, NULL, '', NULL, NULL, '22.47578', '88.30968', '2026-05-12 12:21:08', '2026-05-12 12:21:08', 149, 149, 'Approved', 0),
(37, 148, 'value', 'Summer Chinese Fest', '600', '700008 - 41 Chandi Charan Ghosh Rd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-01', '2026-05-10', NULL, NULL, '', NULL, NULL, '22.474375', '88.311764', '2026-05-12 12:25:52', '2026-05-12 12:25:52', 148, 148, 'Approved', 0),
(38, 147, 'value', 'Bar Hopping Fest', '800', '700008 - 41 Chandi Charan Ghosh Rd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-13', '2026-05-13', NULL, NULL, '', NULL, NULL, '22.474375', '88.311764', '2026-05-12 12:28:51', '2026-05-12 12:28:51', 147, 147, 'Approved', 0),
(39, 114, 'percent', 'ascxzcscsacsad', '27', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-13', '2026-05-29', 'asdsacsacsadcsadsadas', NULL, 'asdsacsacsadcsadsadas', NULL, NULL, '19.196054', '72.847128', '2026-05-12 12:48:03', '2026-05-12 12:48:03', 114, 114, 'Approved', 0),
(40, 146, 'value', 'Eat ur Veggies', '400', '700008 - Barisha Post Office, Kolkata, Kolkata, West Bengal', '700008', '2026-05-01', '2026-05-12', NULL, NULL, '', NULL, NULL, '22.482097', '88.310299', '2026-05-12 12:48:36', '2026-05-12 12:48:36', 146, 146, 'Approved', 0),
(41, 115, 'value', 'asdczcxcvxzvz', '2400', '400067 - [\'Astral ITES LLP\', \'Astral teschnologies\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-30', 'SCdsfgsdgdsgdsfgvds', NULL, 'scdsfgsdgdsgdsfgvds', NULL, NULL, '19.204096', '72.850474', '2026-05-12 12:49:21', '2026-05-12 12:49:21', 115, 115, 'Approved', 0),
(42, 116, 'percent', 'zxcvdsvbsdgdfsgsrg', '15', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-06-05', 'Sfsdhdfjfgjmghk,hjul7i56r57yertrwqrdas', NULL, 'sfsdhdfjfgjmghkhjul7i56r57yertrwqrdas', NULL, NULL, '19.196054', '72.847128', '2026-05-12 12:51:01', '2026-05-12 12:51:01', 116, 116, 'Approved', 0),
(43, 145, 'percent', 'Tasty Biryanis', '17', '700008 - Dighal Bari, Kolkata, Kolkata, West Bengal', '700008', '2026-05-09', '2026-05-16', NULL, NULL, '', NULL, NULL, '22.489076', '88.325163', '2026-05-12 12:51:26', '2026-05-12 12:51:26', 145, 145, 'Approved', 0),
(44, 117, 'value', 'zdvgdsbhdfgjngfjtyjrtyreyg', '2000', '400067 - [\'Rite Divine\', \'Krishna Kunj CHS\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-28', 'Sfsdggfnjhmbdsasfascd2435434657658', '1778590344_images (2).jpeg', 'sfsdggfnjhmbdsasfascd2435434657658', NULL, NULL, '19.205135', '72.844027', '2026-05-12 12:52:24', '2026-05-12 12:52:24', 117, 117, 'Approved', 0),
(45, 144, 'percent', 'Beggie offer (bar and veggie)', '20', '700008 - Doughlas ground, Kolkata, Kolkata, West Bengal', '700008', '2026-05-18', '2026-05-22', NULL, NULL, '', NULL, NULL, '22.485089', '88.31165', '2026-05-12 12:54:11', '2026-05-12 12:54:11', 144, 144, 'Approved', 0),
(46, 118, 'value', 'asfsgsdgdsf vca', '2000', '400067 - 101/102 Super Shopping Complex, A 101/102, Dr Dalvi Rd, Kandivali, Jethava Nagar, Kandivali West, Mumbai, Maharashtra 400067, Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-29', 'safagdsgdsgv', '1778590528_images.jpeg', 'safagdsgdsgv', '<p>asdfafsddsg,ajop vlvjh aov aopsajfasjclascnlnc aklnclkansc</p>', NULL, '19.21214', '72.838304', '2026-05-12 12:55:28', '2026-05-12 12:55:28', 118, 118, 'Approved', 0),
(47, 120, 'percent', 'Scfzczc', '11', '400067 - 101/102 Super Shopping Complex, A 101/102, Dr Dalvi Rd, Kandivali, Jethava Nagar, Kandivali West, Mumbai, Maharashtra 400067, Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-29', 'ZScsafcasfca', '1778590884_images (1).jpeg', 'zscsafcasfca', '<p>adafasf asfsaffe asfwefewfs sdgegeg</p>', NULL, '19.204096', '72.850474', '2026-05-12 13:01:24', '2026-05-12 13:01:24', 120, 120, 'Approved', 0),
(48, 121, 'percent', 'adczczczc', '12', '400067 - 101/102 Super Shopping Complex, A 101/102, Dr Dalvi Rd, Kandivali, Jethava Nagar, Kandivali West, Mumbai, Maharashtra 400067, Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-27', '2026-06-06', 'SDscs', '1778591034_images (1).jpeg', 'sdscs', '<p>scfafaefasd asfawefwef. sdgtyreyergdsfv</p>', NULL, '19.204096', '72.850474', '2026-05-12 13:03:54', '2026-05-12 13:03:54', 121, 121, 'Approved', 0),
(49, 119, 'percent', 'asdfsc', '17', '400067 - [\'Rite Divine\', \'Krishna Kunj CHS\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-26', '2026-06-06', 'cCZC asfafa asfawdad', '1778591157_images (2).jpeg', 'cczc-asfafa-asfawdad', '<p>adadd wrwqrwqr werfasa sghdhh erhtrhjj</p>', NULL, '19.205135', '72.844027', '2026-05-12 13:05:57', '2026-05-12 13:05:57', 119, 119, 'Approved', 0),
(50, 143, 'percent', 'Bawaal offer', '30', '700008 - Institute of Fire Service, Govt. of West Bengal, Kolkata, Kolkata, West Bengal', '700008', '2026-05-12', '2026-05-15', NULL, NULL, '', NULL, NULL, '22.474375', '88.311764', '2026-05-12 13:06:55', '2026-05-12 13:06:55', 143, 143, 'Approved', 0),
(51, 122, 'value', 'asdfafsc', '10000', '400067 - [\'Bank of Baroda\', \'BoB\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-29', 'scc', '1778591288_images (1).jpeg', 'scc', NULL, NULL, '19.210275', '72.836368', '2026-05-12 13:08:08', '2026-05-12 13:08:08', 122, 122, 'Approved', 0),
(52, 142, 'percent', 'Badmosh offer', '24', '700008 - Purba Barisha High School, Kolkata, Kolkata, West Bengal', '700008', '2026-05-13', '2026-05-15', NULL, NULL, '', NULL, NULL, '22.477427', '88.320391', '2026-05-12 13:08:43', '2026-05-12 13:08:43', 142, 142, 'Approved', 0),
(53, 123, 'value', 'asdfsafascas', '2500', '400067 - [\'Rite Divine\', \'Krishna Kunj CHS\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-01', '2026-06-06', NULL, NULL, '', NULL, NULL, '19.205135', '72.844027', '2026-05-12 13:09:15', '2026-05-12 13:09:15', 123, 123, 'Approved', 0),
(54, 124, 'percent', 'aeffxzcz', '15', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-05', '2026-05-29', NULL, '1778591454_images (2).jpeg', '', NULL, NULL, '19.196054', '72.847128', '2026-05-12 13:10:54', '2026-05-12 13:10:54', 124, 124, 'Approved', 0),
(55, 141, 'value', 'Chill Offer', '501', '700008 - Santoshi Maa Mandir, Kolkata, Kolkata, West Bengal', '700008', '2026-05-20', '2026-05-22', NULL, NULL, '', NULL, NULL, '22.476953', '88.320086', '2026-05-12 13:11:08', '2026-05-12 13:11:08', 141, 141, 'Approved', 0),
(56, 125, 'percent', 'zcccc', '17', '400067 - [\'Rite Divine\', \'Krishna Kunj CHS\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-13', '2026-05-30', NULL, NULL, '', NULL, NULL, '19.205135', '72.844027', '2026-05-12 13:12:04', '2026-05-12 13:12:04', 125, 125, 'Approved', 0),
(57, 5, 'value', 'Tempor non anim beat', '42', 'Non dolore cum enim', '33', '2026-04-03', '2026-05-07', 'Mollitia dolores ipsa nostrum quibusdam est alias officia quasi nemo magna pariatur', '1778591581_Screenshot 2026-05-12 163415.png', 'mollitia-dolores-ipsa-nostrum-quibusdam-est-alias-officia-quasi-nemo-magna-pariatur', '<p>Mollitia dolores ipsa nostrum quibusdam est alias officia quasi nemo magna pariatur</p>', NULL, NULL, NULL, '2026-05-12 13:13:01', '2026-05-12 13:13:01', 5, 5, 'Approved', 0),
(58, 140, 'value', 'Non-stop chinese', '606', '700008 - Purba Barisha High School, Kolkata, Kolkata, West Bengal', '700008', '2026-05-18', '2026-05-22', NULL, NULL, '', NULL, NULL, '22.477427', '88.320391', '2026-05-12 13:14:00', '2026-05-12 13:14:00', 140, 140, 'Approved', 0),
(59, 126, 'percent', 'SCascvzvczvx', '18', '400067 - 1-20 mohan nagar a wi Datta Mandir Road, Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-10', '2026-06-06', NULL, NULL, '', NULL, NULL, '19.206478', '72.836004', '2026-05-12 13:14:01', '2026-05-12 13:14:01', 126, 126, 'Approved', 0),
(60, 127, 'percent', 'zdvzdvczc', '25', '400067 - 1-20 mohan nagar a wi Datta Mandir Road, Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-06-06', NULL, NULL, '', NULL, NULL, '19.206478', '72.836004', '2026-05-12 13:15:47', '2026-05-12 13:15:47', 127, 127, 'Approved', 0),
(61, 139, 'percent', 'Kebabs on Fire', '25', '700008 - 41 Chandi Charan Ghosh Rd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-19', '2026-05-21', NULL, NULL, '', NULL, NULL, '22.474375', '88.311764', '2026-05-12 13:16:34', '2026-05-12 13:16:34', 139, 139, 'Approved', 0),
(62, 128, 'percent', 'Best Sale', '19', '400067 - [\'Bank of Baroda\', \'BoB\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-06-06', NULL, NULL, '', NULL, NULL, '19.210275', '72.836368', '2026-05-12 13:17:16', '2026-05-12 13:17:16', 128, 128, 'Approved', 0),
(63, 129, 'percent', 'zsfczc', '15', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-30', 'sadfafszcs', NULL, 'sadfafszcs', NULL, NULL, '19.196054', '72.847128', '2026-05-12 13:18:29', '2026-05-12 13:18:29', 129, 129, 'Approved', 0),
(64, 138, 'value', 'Seat and Eat', '1200', '700008 - 196 Diamond Harbour Road, Kolkata, Kolkata, West Bengal', '700008', '2026-05-14', '2026-05-16', 'Offer Valid on mornings 9am- 7pm', NULL, 'offer-valid-on-mornings-9am-7pm', NULL, NULL, '22.47578', '88.30968', '2026-05-12 13:19:03', '2026-05-12 13:19:03', 138, 138, 'Approved', 0),
(65, 130, 'percent', 'End of Season Sale', '25', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-20', '2026-06-03', NULL, NULL, '', NULL, NULL, '19.196054', '72.847128', '2026-05-12 13:20:06', '2026-05-12 13:20:06', 130, 130, 'Approved', 0),
(66, 137, 'percent', 'Mughlai Kings', '28', '700008 - Doughlas ground, Kolkata, Kolkata, West Bengal', '700008', '2026-05-13', '2026-05-17', NULL, NULL, '', NULL, NULL, '22.485089', '88.31165', '2026-05-12 13:21:05', '2026-05-12 13:21:05', 137, 137, 'Approved', 0),
(67, 131, 'percent', 'offer sales', '16', '400067 - [\'PVR Milap\', \'PVR\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-06-05', NULL, NULL, '', NULL, NULL, '19.196054', '72.847128', '2026-05-12 13:21:09', '2026-05-12 13:21:09', 131, 131, 'Approved', 0),
(68, 132, 'value', 'Sdczz', '4000', '400067 - [\'Bank of Baroda\', \'BoB\'], Mumbai, Mumbai Suburban, Maharashtra', '400067', '2026-05-11', '2026-05-29', 'asdsadas', NULL, 'asdsadas', NULL, NULL, '19.210275', '72.836368', '2026-05-12 13:22:08', '2026-05-12 13:22:08', 132, 132, 'Approved', 0),
(69, 136, 'value', 'Pubs and veg treats', '1000', '700008 - Dighal Bari, Kolkata, Kolkata, West Bengal', '700008', '2026-05-11', '2026-05-15', NULL, NULL, '', NULL, NULL, '22.489076', '88.325163', '2026-05-12 13:23:29', '2026-05-12 13:23:29', 136, 136, 'Approved', 0),
(70, 135, 'percent', 'Veg Treats', '30', '700008 - Apex Clinic Pvt Ltd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-09', '2026-05-15', NULL, NULL, '', NULL, NULL, '22.48891', '88.323593', '2026-05-12 13:25:16', '2026-05-12 13:25:16', 135, 135, 'Approved', 0),
(71, 134, 'value', 'Noodles & Kebabs', '900', '700008 - Apex Clinic Pvt Ltd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-13', '2026-05-16', 'Offer valid till 6pm on Saturday only', NULL, 'offer-valid-till-6pm-on-saturday-only', NULL, NULL, '22.48891', '88.323593', '2026-05-12 13:27:16', '2026-05-12 13:27:16', 134, 134, 'Approved', 0),
(72, 5, 'percent', 'Dolore optio non ea', '8', '453001 - Government hospital Betma, Betma, Indore, Madhya Pradesh', '453001', '2026-09-09', '2026-10-18', 'Soluta nulla consectetur voluptatem Fugiat rem labore consequat Adipisci sit excepturi corporis esse aperiam autem', '1778592501_Screenshot 2026-05-12 13.30.14AM.png', 'soluta-nulla-consectetur-voluptatem-fugiat-rem-labore-consequat-adipisci-sit-excepturi-corporis-esse-aperiam-autem', '<p>Soluta nulla consectetur voluptatem Fugiat rem labore consequat Adipisci sit excepturi corporis esse aperiam autem</p>', NULL, '22.688433', '75.612634', '2026-05-12 13:28:21', '2026-05-12 13:28:21', 5, 5, 'Approved', 0),
(73, 133, 'percent', 'Souvenirs & offers', '13', '700008 - 41 Chandi Charan Ghosh Rd, Kolkata, Kolkata, West Bengal', '700008', '2026-05-01', '2026-06-20', NULL, NULL, '', NULL, NULL, '22.474375', '88.311764', '2026-05-12 13:30:05', '2026-05-12 13:30:05', 133, 133, 'Approved', 0),
(74, 5, 'value', 'Delectus eos perfe', '39', '690101 - A O M M Lower Primary Schooladdr:block=Mavelikkara, Mavelikara, Alappuzha, Kerala', '690101', '1971-02-27', '2019-07-18', 'Delectus odit omnis totam sint alias', NULL, 'delectus-odit-omnis-totam-sint-alias', NULL, NULL, '9.255713', '76.540689', '2026-05-15 12:18:17', '2026-05-15 12:18:17', 5, 5, 'Waiting for approval', 0);

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

--
-- Table structure for table `offer_categories`
--

CREATE TABLE `offer_categories` (
  `id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `sub_category_id` int(11) NOT NULL,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offer_categories`
--

INSERT INTO `offer_categories` (`id`, `offer_id`, `category_id`, `sub_category_id`, `created`, `modified`, `modified_by`, `created_by`, `is_active`) VALUES
(13, 2, 7, 58, '2025-11-22 09:55:07', '2025-11-22 09:55:07', 2, 2, 1),
(15, 1, 4, 40, '2025-11-22 11:31:27', '2025-11-22 11:31:27', 2, 2, 1),
(16, 3, 9, 70, '2025-11-22 12:36:19', '2025-11-22 12:36:19', 6, 6, 1),
(17, 4, 7, 56, '2025-11-24 18:55:28', '2025-11-24 18:55:28', 2, 2, 1),
(18, 13, 7, 56, '2025-11-25 15:06:37', '2025-11-25 15:06:37', 2, 2, 1),
(19, 14, 4, 38, '2026-02-26 18:40:19', '2026-02-26 18:40:19', 2, 2, 1),
(20, 14, 4, 39, '2026-02-26 18:40:19', '2026-02-26 18:40:19', 2, 2, 1),
(21, 15, 9, 69, '2026-02-26 18:46:14', '2026-02-26 18:46:14', 2, 2, 1),
(22, 15, 9, 72, '2026-02-26 18:46:14', '2026-02-26 18:46:14', 2, 2, 1),
(23, 16, 4, 40, '2026-05-09 12:18:08', '2026-05-09 12:18:08', 5, 5, 1),
(24, 17, 3, 29, '2026-05-12 10:38:42', '2026-05-12 10:38:42', 97, 97, 1),
(25, 17, 3, 30, '2026-05-12 10:38:42', '2026-05-12 10:38:42', 97, 97, 1),
(26, 17, 3, 31, '2026-05-12 10:38:42', '2026-05-12 10:38:42', 97, 97, 1),
(27, 18, 7, 55, '2026-05-12 10:51:02', '2026-05-12 10:51:02', 98, 98, 1),
(28, 18, 7, 56, '2026-05-12 10:51:02', '2026-05-12 10:51:02', 98, 98, 1),
(29, 19, 8, 62, '2026-05-12 10:53:18', '2026-05-12 10:53:18', 99, 99, 1),
(30, 19, 8, 63, '2026-05-12 10:53:18', '2026-05-12 10:53:18', 99, 99, 1),
(31, 19, 8, 64, '2026-05-12 10:53:18', '2026-05-12 10:53:18', 99, 99, 1),
(32, 19, 8, 65, '2026-05-12 10:53:18', '2026-05-12 10:53:18', 99, 99, 1),
(33, 20, 1, 1, '2026-05-12 10:56:57', '2026-05-12 10:56:57', 100, 100, 1),
(34, 20, 1, 2, '2026-05-12 10:56:57', '2026-05-12 10:56:57', 100, 100, 1),
(35, 20, 1, 4, '2026-05-12 10:56:57', '2026-05-12 10:56:57', 100, 100, 1),
(36, 20, 1, 3, '2026-05-12 10:56:57', '2026-05-12 10:56:57', 100, 100, 1),
(37, 21, 1, 2, '2026-05-12 11:07:39', '2026-05-12 11:07:39', 101, 101, 1),
(38, 21, 1, 4, '2026-05-12 11:07:39', '2026-05-12 11:07:39', 101, 101, 1),
(39, 22, 1, 4, '2026-05-12 11:30:01', '2026-05-12 11:30:01', 102, 102, 1),
(40, 22, 1, 3, '2026-05-12 11:30:01', '2026-05-12 11:30:01', 102, 102, 1),
(41, 23, 1, 2, '2026-05-12 11:31:17', '2026-05-12 11:31:17', 103, 103, 1),
(42, 24, 1, 4, '2026-05-12 11:36:13', '2026-05-12 11:36:13', 104, 104, 1),
(43, 25, 1, 2, '2026-05-12 11:38:23', '2026-05-12 11:38:23', 105, 105, 1),
(44, 26, 3, 29, '2026-05-12 11:42:56', '2026-05-12 11:42:56', 106, 106, 1),
(45, 26, 3, 30, '2026-05-12 11:42:56', '2026-05-12 11:42:56', 106, 106, 1),
(46, 26, 3, 31, '2026-05-12 11:42:56', '2026-05-12 11:42:56', 106, 106, 1),
(47, 26, 3, 32, '2026-05-12 11:42:56', '2026-05-12 11:42:56', 106, 106, 1),
(48, 27, 7, 55, '2026-05-12 11:44:59', '2026-05-12 11:44:59', 107, 107, 1),
(49, 27, 7, 56, '2026-05-12 11:44:59', '2026-05-12 11:44:59', 107, 107, 1),
(50, 27, 7, 57, '2026-05-12 11:44:59', '2026-05-12 11:44:59', 107, 107, 1),
(51, 27, 7, 58, '2026-05-12 11:44:59', '2026-05-12 11:44:59', 107, 107, 1),
(52, 28, 1, 1, '2026-05-12 11:47:05', '2026-05-12 11:47:05', 108, 108, 1),
(53, 28, 1, 2, '2026-05-12 11:47:05', '2026-05-12 11:47:05', 108, 108, 1),
(54, 28, 1, 4, '2026-05-12 11:47:05', '2026-05-12 11:47:05', 108, 108, 1),
(55, 28, 1, 3, '2026-05-12 11:47:05', '2026-05-12 11:47:05', 108, 108, 1),
(56, 29, 4, 38, '2026-05-12 11:47:56', '2026-05-12 11:47:56', 108, 108, 1),
(57, 29, 4, 40, '2026-05-12 11:47:56', '2026-05-12 11:47:56', 108, 108, 1),
(58, 29, 4, 41, '2026-05-12 11:47:56', '2026-05-12 11:47:56', 108, 108, 1),
(59, 30, 6, 52, '2026-05-12 11:50:20', '2026-05-12 11:50:20', 109, 109, 1),
(60, 30, 6, 54, '2026-05-12 11:50:20', '2026-05-12 11:50:20', 109, 109, 1),
(61, 31, 1, 2, '2026-05-12 11:51:26', '2026-05-12 11:51:26', 110, 110, 1),
(62, 31, 1, 4, '2026-05-12 11:51:26', '2026-05-12 11:51:26', 110, 110, 1),
(63, 32, 5, 46, '2026-05-12 11:52:30', '2026-05-12 11:52:30', 111, 111, 1),
(64, 32, 5, 45, '2026-05-12 11:52:30', '2026-05-12 11:52:30', 111, 111, 1),
(65, 33, 1, 1, '2026-05-12 11:53:40', '2026-05-12 11:53:40', 112, 112, 1),
(66, 33, 1, 2, '2026-05-12 11:53:40', '2026-05-12 11:53:40', 112, 112, 1),
(67, 33, 1, 4, '2026-05-12 11:53:40', '2026-05-12 11:53:40', 112, 112, 1),
(68, 33, 1, 3, '2026-05-12 11:53:40', '2026-05-12 11:53:40', 112, 112, 1),
(69, 34, 1, 2, '2026-05-12 12:00:04', '2026-05-12 12:00:04', 113, 113, 1),
(70, 34, 1, 4, '2026-05-12 12:00:04', '2026-05-12 12:00:04', 113, 113, 1),
(71, 34, 1, 3, '2026-05-12 12:00:04', '2026-05-12 12:00:04', 113, 113, 1),
(72, 35, 1, 2, '2026-05-12 12:17:00', '2026-05-12 12:17:00', 150, 150, 1),
(73, 35, 1, 4, '2026-05-12 12:17:00', '2026-05-12 12:17:00', 150, 150, 1),
(74, 36, 1, 1, '2026-05-12 12:21:08', '2026-05-12 12:21:08', 149, 149, 1),
(75, 36, 1, 4, '2026-05-12 12:21:08', '2026-05-12 12:21:08', 149, 149, 1),
(76, 37, 1, 4, '2026-05-12 12:25:52', '2026-05-12 12:25:52', 148, 148, 1),
(77, 38, 1, 1, '2026-05-12 12:28:51', '2026-05-12 12:28:51', 147, 147, 1),
(78, 39, 4, 38, '2026-05-12 12:48:03', '2026-05-12 12:48:03', 114, 114, 1),
(79, 39, 4, 40, '2026-05-12 12:48:03', '2026-05-12 12:48:03', 114, 114, 1),
(80, 39, 4, 41, '2026-05-12 12:48:03', '2026-05-12 12:48:03', 114, 114, 1),
(81, 40, 1, 2, '2026-05-12 12:48:36', '2026-05-12 12:48:36', 146, 146, 1),
(82, 41, 9, 70, '2026-05-12 12:49:21', '2026-05-12 12:49:21', 115, 115, 1),
(83, 41, 9, 71, '2026-05-12 12:49:21', '2026-05-12 12:49:21', 115, 115, 1),
(84, 41, 9, 72, '2026-05-12 12:49:21', '2026-05-12 12:49:21', 115, 115, 1),
(85, 42, 15, 87, '2026-05-12 12:51:01', '2026-05-12 12:51:01', 116, 116, 1),
(86, 43, 1, 3, '2026-05-12 12:51:26', '2026-05-12 12:51:26', 145, 145, 1),
(87, 44, 1, 1, '2026-05-12 12:52:24', '2026-05-12 12:52:24', 117, 117, 1),
(88, 44, 1, 4, '2026-05-12 12:52:24', '2026-05-12 12:52:24', 117, 117, 1),
(89, 45, 1, 1, '2026-05-12 12:54:11', '2026-05-12 12:54:11', 144, 144, 1),
(90, 45, 1, 2, '2026-05-12 12:54:11', '2026-05-12 12:54:11', 144, 144, 1),
(91, 46, 6, 52, '2026-05-12 12:55:28', '2026-05-12 12:55:28', 118, 118, 1),
(92, 46, 6, 54, '2026-05-12 12:55:28', '2026-05-12 12:55:28', 118, 118, 1),
(93, 47, 3, 30, '2026-05-12 13:01:24', '2026-05-12 13:01:24', 120, 120, 1),
(94, 47, 3, 31, '2026-05-12 13:01:24', '2026-05-12 13:01:24', 120, 120, 1),
(95, 47, 3, 32, '2026-05-12 13:01:24', '2026-05-12 13:01:24', 120, 120, 1),
(96, 48, 1, 2, '2026-05-12 13:03:54', '2026-05-12 13:03:54', 121, 121, 1),
(97, 48, 1, 4, '2026-05-12 13:03:54', '2026-05-12 13:03:54', 121, 121, 1),
(98, 49, 1, 2, '2026-05-12 13:05:57', '2026-05-12 13:05:57', 119, 119, 1),
(99, 49, 1, 4, '2026-05-12 13:05:57', '2026-05-12 13:05:57', 119, 119, 1),
(100, 49, 1, 3, '2026-05-12 13:05:57', '2026-05-12 13:05:57', 119, 119, 1),
(101, 50, 1, 1, '2026-05-12 13:06:55', '2026-05-12 13:06:55', 143, 143, 1),
(102, 50, 1, 2, '2026-05-12 13:06:55', '2026-05-12 13:06:55', 143, 143, 1),
(103, 51, 1, 1, '2026-05-12 13:08:08', '2026-05-12 13:08:08', 122, 122, 1),
(104, 52, 1, 4, '2026-05-12 13:08:43', '2026-05-12 13:08:43', 142, 142, 1),
(105, 52, 1, 3, '2026-05-12 13:08:43', '2026-05-12 13:08:43', 142, 142, 1),
(106, 53, 1, 4, '2026-05-12 13:09:15', '2026-05-12 13:09:15', 123, 123, 1),
(107, 53, 1, 3, '2026-05-12 13:09:15', '2026-05-12 13:09:15', 123, 123, 1),
(108, 54, 1, 1, '2026-05-12 13:10:54', '2026-05-12 13:10:54', 124, 124, 1),
(109, 54, 1, 4, '2026-05-12 13:10:54', '2026-05-12 13:10:54', 124, 124, 1),
(110, 55, 8, 63, '2026-05-12 13:11:08', '2026-05-12 13:11:08', 141, 141, 1),
(111, 55, 8, 65, '2026-05-12 13:11:08', '2026-05-12 13:11:08', 141, 141, 1),
(112, 56, 1, 1, '2026-05-12 13:12:04', '2026-05-12 13:12:04', 125, 125, 1),
(113, 56, 1, 2, '2026-05-12 13:12:04', '2026-05-12 13:12:04', 125, 125, 1),
(114, 56, 1, 4, '2026-05-12 13:12:04', '2026-05-12 13:12:04', 125, 125, 1),
(115, 57, 12, 86, '2026-05-12 13:13:01', '2026-05-12 13:13:01', 5, 5, 1),
(116, 58, 1, 4, '2026-05-12 13:14:00', '2026-05-12 13:14:00', 140, 140, 1),
(117, 59, 1, 3, '2026-05-12 13:14:01', '2026-05-12 13:14:01', 126, 126, 1),
(118, 60, 1, 1, '2026-05-12 13:15:47', '2026-05-12 13:15:47', 127, 127, 1),
(119, 60, 1, 4, '2026-05-12 13:15:47', '2026-05-12 13:15:47', 127, 127, 1),
(120, 61, 1, 3, '2026-05-12 13:16:34', '2026-05-12 13:16:34', 139, 139, 1),
(121, 62, 1, 1, '2026-05-12 13:17:16', '2026-05-12 13:17:16', 128, 128, 1),
(122, 62, 1, 4, '2026-05-12 13:17:16', '2026-05-12 13:17:16', 128, 128, 1),
(123, 62, 1, 3, '2026-05-12 13:17:16', '2026-05-12 13:17:16', 128, 128, 1),
(124, 63, 1, 2, '2026-05-12 13:18:29', '2026-05-12 13:18:29', 129, 129, 1),
(125, 64, 1, 1, '2026-05-12 13:19:03', '2026-05-12 13:19:03', 138, 138, 1),
(126, 64, 1, 2, '2026-05-12 13:19:03', '2026-05-12 13:19:03', 138, 138, 1),
(127, 64, 1, 4, '2026-05-12 13:19:03', '2026-05-12 13:19:03', 138, 138, 1),
(128, 64, 1, 3, '2026-05-12 13:19:03', '2026-05-12 13:19:03', 138, 138, 1),
(129, 65, 1, 2, '2026-05-12 13:20:06', '2026-05-12 13:20:06', 130, 130, 1),
(130, 65, 1, 4, '2026-05-12 13:20:06', '2026-05-12 13:20:06', 130, 130, 1),
(131, 65, 1, 3, '2026-05-12 13:20:06', '2026-05-12 13:20:06', 130, 130, 1),
(132, 66, 1, 3, '2026-05-12 13:21:05', '2026-05-12 13:21:05', 137, 137, 1),
(133, 67, 1, 1, '2026-05-12 13:21:09', '2026-05-12 13:21:09', 131, 131, 1),
(134, 67, 1, 2, '2026-05-12 13:21:09', '2026-05-12 13:21:09', 131, 131, 1),
(135, 68, 1, 1, '2026-05-12 13:22:08', '2026-05-12 13:22:08', 132, 132, 1),
(136, 68, 1, 4, '2026-05-12 13:22:08', '2026-05-12 13:22:08', 132, 132, 1),
(137, 69, 1, 1, '2026-05-12 13:23:29', '2026-05-12 13:23:29', 136, 136, 1),
(138, 69, 1, 2, '2026-05-12 13:23:29', '2026-05-12 13:23:29', 136, 136, 1),
(139, 70, 1, 2, '2026-05-12 13:25:16', '2026-05-12 13:25:16', 135, 135, 1),
(140, 71, 1, 4, '2026-05-12 13:27:16', '2026-05-12 13:27:16', 134, 134, 1),
(141, 71, 1, 3, '2026-05-12 13:27:16', '2026-05-12 13:27:16', 134, 134, 1),
(142, 72, 8, 62, '2026-05-12 13:28:21', '2026-05-12 13:28:21', 5, 5, 1),
(143, 73, 6, 53, '2026-05-12 13:30:05', '2026-05-12 13:30:05', 133, 133, 1),
(144, 73, 6, 52, '2026-05-12 13:30:05', '2026-05-12 13:30:05', 133, 133, 1),
(145, 73, 6, 54, '2026-05-12 13:30:05', '2026-05-12 13:30:05', 133, 133, 1),
(146, 74, 4, 38, '2026-05-15 12:18:17', '2026-05-15 12:18:17', 5, 5, 1),
(147, 74, 4, 41, '2026-05-15 12:18:17', '2026-05-15 12:18:17', 5, 5, 1);

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

--
-- Table structure for table `offer_featured`
--

CREATE TABLE `offer_featured` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  `expire_date` varchar(50) NOT NULL,
  `start_date` datetime NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL,
  `wishlist` tinyint(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `offer_featured`
--

INSERT INTO `offer_featured` (`id`, `user_id`, `offer_id`, `expire_date`, `start_date`, `status`, `wishlist`, `timestamp`) VALUES
(25, 6, 3, '2025-11-16', '2026-01-25 00:00:00', 1, 0, '2025-11-25 13:39:53'),
(26, 6, 12, '2025-12-07', '2025-11-23 00:00:00', 1, 0, '2025-11-25 13:39:38'),
(27, 5, 14, '2026-03-25', '2026-03-01 00:00:00', 1, 0, '2026-03-28 10:39:52');

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

--
-- Table structure for table `offer_reviews`
--

CREATE TABLE `offer_reviews` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `offer_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `rating` int(11) NOT NULL,
  `review` text NOT NULL,
  `user_image` varchar(200) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 2,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offer_reviews`
--

INSERT INTO `offer_reviews` (`id`, `user_id`, `offer_id`, `name`, `email`, `rating`, `review`, `user_image`, `status`, `created_at`, `updated_at`, `timestamp`) VALUES
(1, 54, 36, 'Azad ', 'azad@gmail.com', 4, 'Nice Offer.... I will take ', 'coffee_2.png', 1, '2025-11-29 04:58:14', '2025-11-29 04:58:14', '2022-05-23 11:52:18'),
(2, 54, 35, 'Azad ', 'azad@gmail.com', 4, 'Nice Offer.... I will take ..........', 'slider1.jpg', 1, '2025-11-29 04:58:14', '2025-11-29 04:58:14', '2022-05-23 11:52:30'),
(3, 106, 48, 'Sunando Roy ', 'sroy2050@gmail.com', 3, 'excellent', '20171020_172929.jpg', 2, '2025-11-29 04:58:14', '2025-11-29 01:58:12', '2025-11-29 07:28:12'),
(4, 3, 13, 'Aniket', 'aniket@gmail.com', 4, 'dsds', NULL, 1, '2025-11-28 23:29:01', '2025-11-29 01:58:46', '2025-11-29 07:28:46'),
(5, 3, 13, 'Aniket', 'aniket@gmail.com', 4, 'sds', NULL, 2, '2025-11-28 23:31:00', '2025-11-28 23:31:00', '2025-11-29 05:01:00'),
(6, 3, 13, 'Aniket', 'aniket@gmail.com', 2, 'dsffdfzdsfsfs', NULL, 2, '2025-11-28 23:39:41', '2025-11-28 23:39:41', '2025-11-29 05:09:41'),
(7, 3, 13, 'Aniket', 'aniket@gmail.com', 5, 'fsfgs', NULL, 2, '2025-11-28 23:40:21', '2025-11-28 23:40:21', '2025-11-29 05:10:21');

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

--
-- Table structure for table `offer_wishlists`
--

CREATE TABLE `offer_wishlists` (
  `offer_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `created_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `offer_wishlists`
--

INSERT INTO `offer_wishlists` (`offer_id`, `user_id`, `created_at`) VALUES
(3, 5, '2025-11-25 13:47:51'),
(8, 5, '2025-11-25 13:50:20'),
(15, 6, '2025-11-24 11:27:44'),
(16, 6, '2025-11-24 11:27:11'),
(17, 6, '2025-11-24 11:29:10'),
(21, 6, '2025-11-24 11:27:39');

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `points` int(11) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created` datetime DEFAULT current_timestamp(),
  `modified` datetime DEFAULT current_timestamp(),
  `modified_by` int(11) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `package_name`, `amount`, `points`, `created_by`, `created`, `modified`, `modified_by`, `is_active`) VALUES
(11, 'packages-11', '77', 6300, 2, '2025-11-22 10:52:01', '2025-11-22 10:52:17', 2, 1),
(12, 'test package', '8000', 5000, 2, '2025-11-22 12:12:00', '2025-11-22 12:12:00', 2, 1),
(13, 'packages-11', '85225', 855, 2, '2025-11-22 12:26:03', '2025-11-22 12:26:03', 2, 1),
(14, 'packages-4', '850', 9000, 2, '2025-11-27 06:09:03', '2025-11-27 06:09:03', 2, 1);

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `requirements`
--

CREATE TABLE `requirements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `occasion` varchar(255) DEFAULT NULL,
  `event_date` date DEFAULT NULL,
  `requirement_expire_date` date DEFAULT NULL,
  `short_description` text DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `pincode` varchar(255) DEFAULT NULL,
  `files` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `modified_by` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('active','in-active') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lng` text DEFAULT NULL,
  `lat` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `requirements`
--

INSERT INTO `requirements` (`id`, `occasion`, `event_date`, `requirement_expire_date`, `short_description`, `description`, `customer_id`, `location`, `pincode`, `files`, `created_by`, `modified_by`, `status`, `created_at`, `updated_at`, `lng`, `lat`) VALUES
(5, 'Birthday', '2025-11-23', '2025-12-04', 'dsnh', '<p><strong>dsmd</strong></p>', 3, 'ddfd', '446644', 'requirements/cUAVn9zwqpyh09RQ7nJMZLegTiWuVlHIP6xWZWQj.jpg', 2, NULL, 'active', '2025-11-22 06:41:47', '2025-11-22 06:41:47', NULL, NULL),
(6, 'Wedding', '2025-11-26', '2025-11-30', 'dsndb', '<p><strong>jfdsbf</strong></p>', 7, 'mumbai', '100012', 'requirements/Aga9Q0aLUXIiwKxhzjhOCtKGxr3yxk5h5wL4AEhE.jpg', 2, NULL, 'active', '2025-11-22 06:50:12', '2025-11-22 06:50:12', NULL, NULL),
(7, 'Birthday', '2025-11-22', '2025-11-25', 'sh d', '<p>long d</p>', 3, 'Pune', '446644', 'requirements/UqInAUgJ9T745KU24iNGlJU5evnimti3qJI5kd3v.jpg', 2, NULL, 'active', '2025-11-22 06:52:05', '2025-11-22 06:52:05', NULL, NULL),
(8, 'Wedding', '2025-11-26', '2025-11-29', 'short desc', '<p>ggg</p>', 5, 'Pune', '446644', 'requirements/sojn9OvJkdkUqBmdx9YpQNQHfPcX1fjJ0W4jQaaR.jpg', 5, NULL, 'active', '2025-11-22 07:19:36', '2025-11-22 07:19:36', NULL, NULL),
(9, 'Festival', '2026-03-01', '2026-05-31', 'Quisquam officia pro', '<p>Quisquam officia pro</p>', 37, '444001 - Agrawal Hospital, Akola, Akola, Maharashtra', '444001', 'requirements/azEt459Ie5tIh2Hxb35u0uRuMxCz55gPzR6TLA8W.jpg', 37, NULL, 'active', '2026-05-08 01:15:15', '2026-05-08 01:15:15', '77.005627', '20.704926'),
(10, 'Birthday', '2026-05-09', '2026-05-09', '16 people attending', NULL, 43, '400064 - [\'Palm Spring C Wing\', \'PS C WING\'], Mumbai, Mumbai Suburban, Maharashtra', '400064', NULL, 43, NULL, 'active', '2026-05-08 01:22:58', '2026-05-08 01:22:58', '72.833927', '19.186209'),
(11, 'Wedding', '2005-11-25', '2014-08-19', 'Dolor quia accusamus', '<p>Dolor quia accusamus</p>', 36, '440006 - 22 The Servant Of nagpur Homeless Cooperative Housing Society Behind Veternary College Near Elizabeth School, Seminary Hills, Nagpur, Nagpur, Maharashtra', '440006', 'requirements/WEFsfOtOA8lPpdoSF2kFtJlppcYTnZamab1TG6KC.jpg', 36, NULL, 'active', '2026-05-08 03:25:41', '2026-05-08 03:25:41', '79.044962', '21.168605');

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

--
-- Table structure for table `requirement_categories`
--

CREATE TABLE `requirement_categories` (
  `id` bigint(20) NOT NULL,
  `requirement_id` bigint(20) NOT NULL,
  `category_id` bigint(20) NOT NULL,
  `subcategory_id` bigint(20) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `requirement_categories`
--

INSERT INTO `requirement_categories` (`id`, `requirement_id`, `category_id`, `subcategory_id`, `created_at`, `updated_at`) VALUES
(36, 5, 3, 31, '2025-11-22 06:41:47', '2025-11-22 06:41:47'),
(37, 5, 3, 32, '2025-11-22 06:41:47', '2025-11-22 06:41:47'),
(38, 6, 1, 1, '2025-11-22 06:50:12', '2025-11-22 06:50:12'),
(39, 6, 1, 2, '2025-11-22 06:50:12', '2025-11-22 06:50:12'),
(40, 6, 1, 3, '2025-11-22 06:50:12', '2025-11-22 06:50:12'),
(41, 7, 3, 31, '2025-11-22 06:52:05', '2025-11-22 06:52:05'),
(42, 8, 3, 31, '2025-11-22 07:19:36', '2025-11-22 07:19:36'),
(43, 8, 3, 32, '2025-11-22 07:19:36', '2025-11-22 07:19:36'),
(44, 9, 3, 29, '2026-05-08 01:15:15', '2026-05-08 01:15:15'),
(45, 9, 15, 87, '2026-05-08 01:15:15', '2026-05-08 01:15:15'),
(46, 10, 1, 1, '2026-05-08 01:22:58', '2026-05-08 01:22:58'),
(47, 10, 1, 2, '2026-05-08 01:22:58', '2026-05-08 01:22:58'),
(48, 10, 1, 4, '2026-05-08 01:22:58', '2026-05-08 01:22:58'),
(49, 11, 7, 56, '2026-05-08 03:25:41', '2026-05-08 03:25:41'),
(50, 11, 15, 87, '2026-05-08 03:25:41', '2026-05-08 03:25:41');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL DEFAULT 'sanctum',
  `status` enum('Active','In-active') NOT NULL DEFAULT 'Active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `updated_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `status`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(1, 'Super Admin', 'sanctum', 'Active', NULL, NULL, '2025-09-27 08:11:39', '2025-09-27 08:11:39'),
(2, 'Admin', 'sanctum', 'Active', NULL, NULL, '2025-09-27 08:11:49', '2025-09-27 08:11:49'),
(3, 'Merchant', 'sanctum', 'Active', NULL, NULL, '2025-09-27 08:11:57', '2025-09-27 08:11:57'),
(4, 'customer', 'sanctum', 'Active', NULL, NULL, '2025-09-27 08:12:06', '2025-09-27 08:12:06');

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

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `send_journey`
--

CREATE TABLE `send_journey` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `journey_id` int(11) DEFAULT NULL,
  `offer_link` varchar(100) NOT NULL,
  `offer_summary` mediumtext DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `send_journey`
--

INSERT INTO `send_journey` (`id`, `user_id`, `merchant_id`, `journey_id`, `offer_link`, `offer_summary`, `status`, `timestamp`) VALUES
(2, 7, 6, 21, '7', 'fdf', 1, '2025-11-28 06:33:07'),
(3, 3, 6, 23, '7', 'fdf', 1, '2025-11-28 06:33:07'),
(4, 7, 6, 21, '13', 'hgg', 1, '2025-11-28 06:57:09'),
(5, 3, 6, 23, '13', 'hgg', 1, '2025-11-28 06:57:09'),
(6, 7, 6, 21, '10', 'hgg', 1, '2025-11-28 06:57:42'),
(7, 3, 6, 23, '10', 'hgg', 1, '2025-11-28 06:57:42'),
(8, 3, 6, 22, '10', 'hgg', 1, '2025-11-28 06:57:42');

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

--
-- Table structure for table `send_offer`
--

CREATE TABLE `send_offer` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `offer_id` int(11) DEFAULT NULL,
  `customer_mobile` int(11) DEFAULT NULL,
  `customer_summary` mediumtext DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `send_offer`
--

INSERT INTO `send_offer` (`id`, `customer_id`, `offer_id`, `customer_mobile`, `customer_summary`, `status`, `created_at`, `updated_at`) VALUES
(9, 3, 3, 1234567890, 'hello', 1, '2025-11-22 07:57:12', '2025-11-22 07:57:12'),
(10, 7, 12, 1234567891, 'xyzsedd', 1, '2025-11-27 06:57:12', '2025-11-27 06:57:12');

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

--
-- Table structure for table `send_requirement`
--

CREATE TABLE `send_requirement` (
  `id` int(11) NOT NULL,
  `merchant_id` int(11) DEFAULT NULL,
  `requirement_id` int(11) DEFAULT NULL,
  `offer_price` int(11) DEFAULT NULL,
  `offer_summary` mediumtext DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `timestamp` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `send_requirement`
--

INSERT INTO `send_requirement` (`id`, `merchant_id`, `requirement_id`, `offer_price`, `offer_summary`, `status`, `timestamp`) VALUES
(1, 4, 8, 100, 'dsdf', 1, '2025-11-26 03:48:25'),
(2, 4, 8, 50, 'dsdf', 1, '2025-11-26 03:54:24'),
(3, 4, 8, 10, 'dhsghh', 1, '2025-11-26 03:55:51'),
(4, 4, 8, 10, 'dsds', 1, '2025-11-26 04:15:33'),
(5, 6, 8, 100, 'bcghg', 1, '2025-11-28 00:02:43'),
(6, 6, 8, 100, 'dmfjdk', 1, '2025-11-28 03:18:56'),
(7, 6, 8, 10, 'dd', 1, '2025-11-28 03:28:26'),
(8, 6, 7, 20, 'esee', 1, '2025-11-28 03:31:35'),
(9, 6, 7, 50, 'jhm', 1, '2025-11-28 03:33:21');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('gnoXRa0jRiu37yHeBvJzRSzuW2vwq6YeoaXVwuwa', NULL, '154.84.246.5', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiN1lRM3Njdzk5T0xHUHVvVEYzejY4eXBkdzl6d054UzFaSm1WUERjMCI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo2MjoiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9jdXN0b21lci9kYXNoYm9hcmQiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0OToiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778844750),
('H0DjSftOfv2hEfDzyH1T0HXxYDkFaGGFgx0WDisx', NULL, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiRllnRFZWU1NpSU9OT3pVb21qVnlQVVpxRnJ1TDhJNjQxRHRKTkZwdSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1778869117),
('jOFl18MSiOAfvCcf0i7CR62DecyBUTX1jHUGhZ8z', NULL, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOEs4cDduYk9qcDNzOFdvT3huaXRLZm13V0tyUDRVU1F1VjloeW55WSI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1OToiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9tZXJjaGFudC9vZmZlcnMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0OToiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778919636),
('M9ktVdwJ4IhQUDCtUAoSkES4qnof47M0f2OecPWS', 5, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiUE56SUJBVHVWcjIyNnpzOVBKNUFIcGFIeTdndXh0SzY0VnRKZzBDNSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHBzOi8vcGVla3p5Mi5kZXY2M2FrLnNlY3VyZWJyYW5kdGVjaC5jb20vbWVyY2hhbnQvb2ZmZXJzIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6NTtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMiRkZGNvbXJ1TmdvcUJoekZnbWJDMjh1UUw2a2ZjVkRpYXRwcXNBUGw0emlydVNBcWtTLjQ5LiI7fQ==', 1778847575),
('MD1uP22qf82YQkqll4Zq5bNSlVsYQGo5J3vCvUjh', NULL, '103.88.223.9', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiaUxxWU9VWFIyb2VoWFN5NVA2Mkg4eU1XQlVoY0t1VVFzclUzbXpsMyI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czo1OToiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9tZXJjaGFudC9vZmZlcnMiO31zOjk6Il9wcmV2aW91cyI7YToxOntzOjM6InVybCI7czo0OToiaHR0cHM6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbS9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778846965),
('NTjQ6EajskK1L3E9NdLz4nQA7fkF7VVWU4ha9QXj', 2, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiRlIxbm41eTlia1JHMXRydVN0MmZRZmpzaFdPb3VJdXIxcGVNWk9OUCI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMiRkZGNvbXJ1TmdvcUJoekZnbWJDMjh1UUw2a2ZjVkRpYXRwcXNBUGw0emlydVNBcWtTLjQ5LiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHBzOi8vcGVla3p5Mi5kZXY2M2FrLnNlY3VyZWJyYW5kdGVjaC5jb20vbWVyY2hhbnQvb2ZmZXJzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1778921576),
('SeA1aLMYYvRtNLYAQzk3xM8yZ0tSPk2lM8fQ1CHW', NULL, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoieGRuQm5NQVJ2QktycWZRVllYZVIzOHYwVlY4S2NaMVRnaW9WZjF0bCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1778911431),
('sJ1LJtOUf0BVbuMMU4xNVQoOhF4lqTwq1WIIOYqz', NULL, '198.235.24.104', 'Hello from Palo Alto Networks, find out more about our scans in https://docs-cortex.paloaltonetworks.com/r/1/Cortex-Xpanse/Scanning-activity', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiODBLZXFuakdQcE8xeDVyMGZKaGd2UHlLZHhGQVN2M1BpQ3A2U0RSViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDI6Imh0dHA6Ly9wZWVrenkyLmRldjYzYWsuc2VjdXJlYnJhbmR0ZWNoLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1778836607),
('t3MaGvou3aU0rEPKxrrpULd3hCNqUUAFf3E8P9dN', 2, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoib1NoYzIyUEg1TUdvZHVXd0FLdGZscFJMS1ppdzRBUUFIa1hTWkFYeSI7czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMiRkZGNvbXJ1TmdvcUJoekZnbWJDMjh1UUw2a2ZjVkRpYXRwcXNBUGw0emlydVNBcWtTLjQ5LiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1778911462),
('WVcNiALcucBQqkK5ghwbVzmt8mvRUHtawj2fv3Lw', NULL, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoidld4UTFnOTNiZnVNZEZsbEU1aVpTRElRejZNOTdjSU85NXpoaGdwZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NjE6Imh0dHBzOi8vcGVla3p5Mi5kZXY2M2FrLnNlY3VyZWJyYW5kdGVjaC5jb20vbWVyY2hhbnQvcmVnaXN0ZXIiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjE0OiJjYXB0Y2hhX2Fuc3dlciI7aToxMTt9', 1778840776),
('zeTwcTj60HItVSEPJfufFUxNBxWMCwMVVw5sImfC', 2, '160.30.60.251', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/148.0.0.0 Safari/537.36', 'YTo1OntzOjY6Il90b2tlbiI7czo0MDoiOTN3YVQyaUNkc0hPVFByRWR3SEJGbU9XWDJ2b29FSnhrTnZUVjhLTSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTk6Imh0dHBzOi8vcGVla3p5Mi5kZXY2M2FrLnNlY3VyZWJyYW5kdGVjaC5jb20vbWVyY2hhbnQvb2ZmZXJzIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MjtzOjIxOiJwYXNzd29yZF9oYXNoX3NhbmN0dW0iO3M6NjA6IiQyeSQxMiRkZGNvbXJ1TmdvcUJoekZnbWJDMjh1UUw2a2ZjVkRpYXRwcXNBUGw0emlydVNBcWtTLjQ5LiI7fQ==', 1778847555);

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

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL,
  `meta_kay` varchar(100) NOT NULL,
  `meta_value` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `meta_kay`, `meta_value`) VALUES
(1, 'banner_price', '10'),
(2, 'offer_price', '12'),
(3, 'featured_offer_price', '11'),
(4, 'journey_smsprice', '22'),
(5, 'journey_emailprice', '11'),
(6, 'journey_notiprice', '22'),
(7, 'requirement_smsprice', '1'),
(8, 'requirement_emailprice', '2'),
(9, 'requirement_notiprice', '22');

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

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `subcategory` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `priority` int(11) NOT NULL,
  `created_by` tinyint(4) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `modified` datetime NOT NULL DEFAULT current_timestamp(),
  `modified_by` tinyint(4) NOT NULL DEFAULT 0,
  `is_active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `subcategory`, `slug`, `priority`, `created_by`, `created`, `modified`, `modified_by`, `is_active`) VALUES
(1, 1, 'Bar, Pubs and Restaurant', 'bar-pubs-and-restaurant', 1, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(2, 1, 'Pure Veg restaurant', 'pure-veg-restaurant', 2, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(3, 1, 'Mughlai Restaurant', 'mughlai-restaurant', 4, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(4, 1, 'Chinese Restaurant', 'chinese-restaurant', 3, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(29, 3, 'Sports/fitness shops', 'sportsfitness-shops', 7, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(30, 3, 'Wine shops', 'wine-shops', 8, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(31, 3, 'Toy store', 'toy-store', 9, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(32, 3, 'Baby care shops', 'baby-care-shops', 10, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(33, 3, 'Gift Shops', 'gift-shops', 11, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(34, 3, 'Groceries', 'groceries', 12, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(35, 3, 'Others', 'others', 13, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(38, 4, 'Event Organisers', 'event-organisers', 1, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(39, 4, 'Tour guides', 'tour-guides', 2, 4, '2022-02-09 17:46:31', '2022-02-09 17:46:31', 0, 1),
(40, 4, 'Laundry', 'laundry', 3, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(41, 4, 'Vehicle Repair services', 'vehicle-repair-services', 4, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(42, 4, 'Electronic Repair Services', 'electronic-repair-services', 5, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(45, 5, 'Hotels', 'hotels', 2, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(46, 5, 'Malls and Shopping centers', 'malls-and-shopping-centers', 1, 4, '2022-02-18 21:40:17', '2022-02-18 21:40:17', 0, 1),
(47, 5, 'Hospitals/Nursing homes', 'hospitalsnursing-homes', 3, 4, '2022-02-18 21:40:17', '2022-02-18 21:40:17', 0, 1),
(48, 5, 'Religious places', 'religious-places', 4, 4, '2022-02-18 21:40:17', '2022-02-18 21:40:17', 0, 1),
(52, 6, 'Souvenir shops', 'souvenir-shops', 2, 0, '2022-01-07 13:35:20', '2022-01-07 13:35:20', 0, 1),
(53, 6, 'Local special shops – like chikki in lonavla, kaju in Goa', 'local-special-shops-like-chikki-in-lonavla-kaju-in-goa', 1, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(54, 6, 'Sweet and Munch Shops – farsan shops', 'sweet-and-munch-shops-farsan-shops', 3, 4, '2022-02-18 21:38:30', '2022-02-18 21:38:30', 0, 1),
(55, 7, 'Car/Jeep/Van Rental', 'carjeepvan-rental', 1, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(56, 7, 'Bike/Scooter Rental', 'bikescooter-rental', 2, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(57, 7, 'Boat Rentals', 'boat-rentals', 3, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(58, 7, 'Bus Rentals', 'bus-rentals', 4, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(62, 8, 'Spas', 'spas', 1, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(63, 8, 'Massage Parlours', 'massage-parlours', 2, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(64, 8, 'Yoga/Arogya centers', 'yogaarogya-centers', 3, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(65, 8, 'Beauty parlours/Salons', 'beauty-parlourssalons', 4, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(66, 8, 'Chemists / Medical shops', 'chemists-medical-shops', 5, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(67, 8, 'Flower Boutiques', 'flower-boutiques', 6, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(69, 9, 'Amusement Parks', 'amusement-parks', 1, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(70, 9, 'Circus/Fair', 'circusfair', 2, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(71, 9, 'Zoos/Sanctuaries', 'zoossanctuaries', 3, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(72, 9, 'Discos And Night Clubs', 'discos-and-night-clubs', 4, 4, '2022-02-18 21:19:49', '2022-02-18 21:19:49', 0, 1),
(76, 10, 'Water activities- Boating/Kayaking/parasailing/scubadiving/surfing', 'water-activities-boatingkayakingparasailingscubadivingsurfing', 1, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(77, 10, 'Land activities- Paragliding/skating/ go karting/Cycling/ Trekking', 'land-activities-paraglidingskating-go-kartingcycling-trekking', 2, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(78, 10, 'City tour / Sightseeing/Day tours', 'city-tour-sightseeingday-tours', 3, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(79, 10, 'Animal Rides - Horse/Camel/Elephant with or without carts', 'animal-rides-horsecamelelephant-with-or-without-carts', 4, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(80, 10, 'Sightseeing', 'sightseeing', 5, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 0),
(81, 10, 'Day Tours', 'day-tours', 6, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 0),
(82, 10, 'Kids joy rides (helicopter, merry go round, ferries wheel etc)', 'kids-joy-rides-helicopter-merry-go-round-ferries-wheel-etc', 7, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(83, 10, 'Sports activities- tennis, badminton, football etc', 'sports-activities-tennis-badminton-football-etc', 8, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(84, 10, 'Indoor games– table tennis, carrom, video games etc', 'indoor-games-table-tennis-carrom-video-games-etc', 9, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(85, 10, 'Others- like wax museums, mirror shows, puppet shows etc', 'others-like-wax-museums-mirror-shows-puppet-shows-etc', 11, 4, '2022-02-18 17:06:32', '2022-02-18 17:06:32', 0, 1),
(86, 12, 'xs', 'xs', 1, 2, '2025-11-18 15:52:00', '2025-11-18 15:52:00', 0, 1),
(87, 15, 'test subcategories', 'test-subcategories', 22, 2, '2025-11-22 16:55:37', '2025-11-22 16:55:37', 0, 1);

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

--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `personal_team` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` (`id`, `user_id`, `name`, `personal_team`, `created_at`, `updated_at`) VALUES
(1, 1, 'superadmin\'s Team', 1, '2025-11-08 04:05:09', '2025-11-08 04:05:09'),
(2, 2, 'admin\'s Team', 1, '2025-11-08 04:06:04', '2025-11-08 04:06:04'),
(3, 3, 'Aniket\'s Team', 1, '2025-11-08 04:07:16', '2025-11-08 04:07:16'),
(4, 4, 'Amruta\'s Team', 1, '2025-11-08 04:08:42', '2025-11-08 04:08:42'),
(5, 5, 'anisha\'s Team', 1, '2025-11-08 05:08:59', '2025-11-08 05:08:59'),
(6, 6, 'Ankita\'s Team', 1, '2025-11-08 05:17:14', '2025-11-08 05:17:14'),
(7, 7, 'nikesh\'s Team', 1, '2025-11-22 00:30:37', '2025-11-22 00:30:37'),
(8, 14, 'vishal\'s Team', 1, '2025-11-26 02:35:20', '2025-11-26 02:35:20'),
(9, 17, 'customer\'s Team', 1, '2026-02-26 11:17:42', '2026-02-26 11:17:42'),
(10, 23, 'merchant\'s Team', 1, '2026-05-06 05:07:49', '2026-05-06 05:07:49'),
(11, 24, 'Fatima\'s Team', 1, '2026-05-06 07:30:27', '2026-05-06 07:30:27'),
(12, 25, 'Buffy\'s Team', 1, '2026-05-06 07:46:01', '2026-05-06 07:46:01'),
(13, 26, 'Vance\'s Team', 1, '2026-05-06 07:55:24', '2026-05-06 07:55:24'),
(14, 27, 'Perry\'s Team', 1, '2026-05-06 07:55:49', '2026-05-06 07:55:49'),
(15, 28, 'customer\'s Team', 1, '2026-05-07 03:00:17', '2026-05-07 03:00:17'),
(16, 29, 'customer\'s Team', 1, '2026-05-07 03:01:06', '2026-05-07 03:01:06'),
(17, 30, 'Cullen\'s Team', 1, '2026-05-07 03:04:32', '2026-05-07 03:04:32'),
(18, 31, 'Adam\'s Team', 1, '2026-05-07 03:23:59', '2026-05-07 03:23:59'),
(19, 32, 'Inez\'s Team', 1, '2026-05-07 04:11:53', '2026-05-07 04:11:53'),
(20, 33, 'vishal\'s Team', 1, '2026-05-07 12:48:53', '2026-05-07 12:48:53'),
(21, 34, 'customer\'s Team', 1, '2026-05-07 12:51:37', '2026-05-07 12:51:37'),
(22, 35, 'Tyrone\'s Team', 1, '2026-05-08 00:00:05', '2026-05-08 00:00:05'),
(23, 36, 'Rafael\'s Team', 1, '2026-05-08 00:01:04', '2026-05-08 00:01:04'),
(24, 37, 'Wynter\'s Team', 1, '2026-05-08 00:01:22', '2026-05-08 00:01:22'),
(25, 38, 'Bryar\'s Team', 1, '2026-05-08 00:02:12', '2026-05-08 00:02:12'),
(26, 39, 'Quail\'s Team', 1, '2026-05-08 00:02:40', '2026-05-08 00:02:40'),
(27, 40, 'Gloria\'s Team', 1, '2026-05-08 00:03:02', '2026-05-08 00:03:02'),
(28, 41, 'Admin2\'s Team', 1, '2026-05-08 00:13:46', '2026-05-08 00:13:46'),
(29, 42, 'customer5\'s Team', 1, '2026-05-08 00:20:27', '2026-05-08 00:20:27'),
(30, 153, 'Devin\'s Team', 1, '2026-05-10 14:16:21', '2026-05-10 14:16:21'),
(31, 154, 'Noel\'s Team', 1, '2026-05-10 14:25:03', '2026-05-10 14:25:03'),
(32, 155, 'Janna\'s Team', 1, '2026-05-11 00:12:53', '2026-05-11 00:12:53'),
(33, 156, 'Basil\'s Team', 1, '2026-05-12 23:47:17', '2026-05-12 23:47:17'),
(34, 157, 'Mara\'s Team', 1, '2026-05-13 04:09:08', '2026-05-13 04:09:08'),
(35, 158, 'testtets\'s Team', 1, '2026-05-15 06:02:00', '2026-05-15 06:02:00');

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

--
-- Table structure for table `team_invitations`
--

CREATE TABLE `team_invitations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `team_id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `team_user`
--

CREATE TABLE `team_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `team_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `role` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `travellers`
--

CREATE TABLE `travellers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `from_date` date NOT NULL,
  `to_date` date NOT NULL,
  `travelling_from` varchar(255) DEFAULT NULL,
  `travelling_to` varchar(255) DEFAULT NULL,
  `journey_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `journey_name` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED DEFAULT NULL,
  `status` enum('active','in-active') DEFAULT 'active',
  `created_by` bigint(20) UNSIGNED DEFAULT NULL,
  `modified_by` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `travellers`
--

INSERT INTO `travellers` (`id`, `from_date`, `to_date`, `travelling_from`, `travelling_to`, `journey_type_id`, `journey_name`, `customer_id`, `status`, `created_by`, `modified_by`, `created_at`, `updated_at`) VALUES
(21, '2025-11-20', '2025-12-04', '800', '66', 2, 'bh', 7, 'active', 2, NULL, '2025-11-22 04:54:56', '2025-11-27 06:45:45'),
(22, '2025-11-23', '2026-01-01', 'Mumbai', 'Goa', 1, 'Gernal', 3, 'active', 2, NULL, '2025-11-22 07:47:55', '2025-11-27 06:46:12'),
(23, '2025-11-22', '2025-11-30', 'pune', 'Delhi', 2, 'xyz', 3, 'active', 2, NULL, '2025-11-27 06:49:13', '2025-11-27 06:49:13');

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

--
-- Table structure for table `traveller_categories`
--

CREATE TABLE `traveller_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `traveller_id` int(10) UNSIGNED DEFAULT NULL,
  `category_id` int(10) UNSIGNED DEFAULT NULL,
  `subcategory_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `traveller_categories`
--

INSERT INTO `traveller_categories` (`id`, `traveller_id`, `category_id`, `subcategory_id`, `created_at`, `updated_at`) VALUES
(6, 21, 1, 4, '2025-11-27 06:45:45', '2025-11-27 06:45:45'),
(9, 22, 1, 1, '2025-11-27 06:46:12', '2025-11-27 06:46:12'),
(10, 22, 1, 2, '2025-11-27 06:46:12', '2025-11-27 06:46:12'),
(11, 23, 1, 1, '2025-11-27 06:49:13', '2025-11-27 06:49:13'),
(12, 23, 1, 2, '2025-11-27 06:49:13', '2025-11-27 06:49:13');

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

--
-- Table structure for table `traveller_destinations`
--

CREATE TABLE `traveller_destinations` (
  `id` int(11) NOT NULL,
  `user_journey_id` int(11) NOT NULL,
  `to_destination` varchar(100) NOT NULL,
  `arrival_date` datetime NOT NULL,
  `departure_date` datetime NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `created` datetime DEFAULT current_timestamp(),
  `modified` datetime DEFAULT current_timestamp(),
  `modified_by` int(11) DEFAULT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `traveller_destinations`
--

INSERT INTO `traveller_destinations` (`id`, `user_journey_id`, `to_destination`, `arrival_date`, `departure_date`, `created_by`, `created`, `modified`, `modified_by`, `is_active`) VALUES
(14, 21, '500', '2025-11-22 00:00:00', '2025-11-28 00:00:00', 5, '2025-11-22 18:20:44', '2025-11-22 18:20:44', NULL, 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `account_ledger`
--
ALTER TABLE `account_ledger`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banner_categories`
--
ALTER TABLE `banner_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `interest_categories`
--
ALTER TABLE `interest_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `journey_types`
--
ALTER TABLE `journey_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `notification`
--
ALTER TABLE `notification`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offers`
--
ALTER TABLE `offers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_categories`
--
ALTER TABLE `offer_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_featured`
--
ALTER TABLE `offer_featured`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_reviews`
--
ALTER TABLE `offer_reviews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `offer_wishlists`
--
ALTER TABLE `offer_wishlists`
  ADD PRIMARY KEY (`offer_id`,`user_id`) USING BTREE;

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `requirements`
--
ALTER TABLE `requirements`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `requirement_categories`
--
ALTER TABLE `requirement_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`),
  ADD KEY `roles_created_by_foreign` (`created_by`),
  ADD KEY `roles_updated_by_foreign` (`updated_by`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `send_journey`
--
ALTER TABLE `send_journey`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `send_offer`
--
ALTER TABLE `send_offer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `send_requirement`
--
ALTER TABLE `send_requirement`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `teams`
--
ALTER TABLE `teams`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teams_user_id_index` (`user_id`);

--
-- Indexes for table `team_invitations`
--
ALTER TABLE `team_invitations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `team_invitations_team_id_email_unique` (`team_id`,`email`);

--
-- Indexes for table `team_user`
--
ALTER TABLE `team_user`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `team_user_team_id_user_id_unique` (`team_id`,`user_id`);

--
-- Indexes for table `travellers`
--
ALTER TABLE `travellers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_traveller_customer` (`customer_id`),
  ADD KEY `fk_traveller_created_by` (`created_by`),
  ADD KEY `fk_traveller_modified_by` (`modified_by`),
  ADD KEY `fk_traveller_journey_type` (`journey_type_id`);

--
-- Indexes for table `traveller_categories`
--
ALTER TABLE `traveller_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `traveller_destinations`
--
ALTER TABLE `traveller_destinations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account_ledger`
--
ALTER TABLE `account_ledger`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=125;

--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `banner_categories`
--
ALTER TABLE `banner_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

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

--
-- AUTO_INCREMENT for table `interest_categories`
--
ALTER TABLE `interest_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=965;

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

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

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

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

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `offers`
--
ALTER TABLE `offers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `offer_categories`
--
ALTER TABLE `offer_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=148;

--
-- AUTO_INCREMENT for table `offer_featured`
--
ALTER TABLE `offer_featured`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `offer_reviews`
--
ALTER TABLE `offer_reviews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

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

--
-- AUTO_INCREMENT for table `requirement_categories`
--
ALTER TABLE `requirement_categories`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

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

--
-- AUTO_INCREMENT for table `send_journey`
--
ALTER TABLE `send_journey`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `send_offer`
--
ALTER TABLE `send_offer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `send_requirement`
--
ALTER TABLE `send_requirement`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `setting`
--
ALTER TABLE `setting`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=88;

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

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

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

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

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

--
-- AUTO_INCREMENT for table `traveller_destinations`
--
ALTER TABLE `traveller_destinations`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `roles`
--
ALTER TABLE `roles`
  ADD CONSTRAINT `roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `roles_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `team_invitations`
--
ALTER TABLE `team_invitations`
  ADD CONSTRAINT `team_invitations_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `travellers`
--
ALTER TABLE `travellers`
  ADD CONSTRAINT `fk_traveller_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_traveller_customer` FOREIGN KEY (`customer_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `fk_traveller_journey_type` FOREIGN KEY (`journey_type_id`) REFERENCES `journey_types` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `fk_traveller_modified_by` FOREIGN KEY (`modified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;
COMMIT;

