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

START TRANSACTION;



--
-- Database: `caxis_parivaar`
--

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

--
-- Table structure for table `additional_people`
--

CREATE TABLE `additional_people` (
  `id` bigint UNSIGNED NOT NULL,
  `BE_Id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci 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 `additional_people`
--

INSERT INTO `additional_people` (`id`, `BE_Id`, `name`, `email`, `mobile`, `created_at`, `updated_at`) VALUES
(1, 2, 'Jane Smith', 'jane@example.com', '9123456780', '2025-04-19 14:40:11', '2025-04-19 14:40:11'),
(2, 2, 'Mike Brown', 'mike@example.com', '9988776655', '2025-04-19 14:40:11', '2025-04-19 14:40:11'),
(3, 3, 'Jane Smith', 'jane@example.com', '9123456780', '2025-04-19 14:41:22', '2025-04-19 14:41:22'),
(4, 3, 'Mike Brown', 'mike@example.com', '9988776655', '2025-04-19 14:41:22', '2025-04-19 14:41:22'),
(5, 4, 'Jane Smith', 'jane@example.com', '9123456780', '2025-04-21 06:55:19', '2025-04-21 06:55:19'),
(6, 4, 'Mike Brown', 'mike@example.com', '9988776655', '2025-04-21 06:55:19', '2025-04-21 06:55:19'),
(7, 5, 'Bob Smith', 'bob@example.com', '9123456780', '2025-10-08 07:03:16', '2025-10-08 07:03:16'),
(8, 5, 'Charlie Brown', 'charlie@example.com', '9234567890', '2025-10-08 07:03:16', '2025-10-08 07:03:16');

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

--
-- Table structure for table `book_events`
--

CREATE TABLE `book_events` (
  `BE_Id` bigint UNSIGNED NOT NULL,
  `BE_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `BE_Email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `BE_Mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `E_Id` bigint UNSIGNED NOT NULL,
  `U_Id` bigint UNSIGNED NOT NULL,
  `BE_Code` varchar(255) COLLATE utf8mb4_unicode_ci 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 `book_events`
--

INSERT INTO `book_events` (`BE_Id`, `BE_Name`, `BE_Email`, `BE_Mobile`, `E_Id`, `U_Id`, `BE_Code`, `created_at`, `updated_at`) VALUES
(1, 'Mayur', 'mayur@gmail.com', '5457845698', 1, 3, 'F2498K', '2025-04-19 14:36:55', '2025-04-19 15:13:03'),
(2, 'rajesh', 'rajesh@gmail.com', '1248774584', 1, 3, 'AZHRVE', '2025-04-19 14:40:11', '2025-04-19 14:40:11'),
(3, 'rajesh', 'rajesh@gmail.com', '1248774584', 1, 3, 'VG56SD', '2025-04-19 14:41:22', '2025-04-19 14:41:22'),
(4, 'rajesh', 'rajesh@gmail.com', '1248774584', 7, 3, '43DB9I', '2025-04-21 06:55:19', '2025-04-21 06:55:19'),
(5, 'Alice Smith', 'alice@example.com', '9876543578', 17, 4, 'KVDR7K', '2025-10-08 07:03:16', '2025-10-08 07:05:33');

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

--
-- Table structure for table `cash_collections`
--

CREATE TABLE `cash_collections` (
  `Cash_ID` bigint UNSIGNED NOT NULL,
  `send_id` bigint UNSIGNED DEFAULT NULL,
  `receive_id` bigint UNSIGNED DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0: Pending, 1: Completed, 2: Failed',
  `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 `cash_collections`
--

INSERT INTO `cash_collections` (`Cash_ID`, `send_id`, `receive_id`, `amount`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 500.75, 1, '2025-05-26 08:53:01', '2025-05-26 08:53:01'),
(2, 10, 17, 1200.50, 1, '2025-10-08 08:50:28', '2025-10-08 08:51:26');

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

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

CREATE TABLE `categories` (
  `Cat_id` bigint UNSIGNED NOT NULL,
  `Cat_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Cat_Des` text COLLATE utf8mb4_unicode_ci,
  `U_ID` bigint UNSIGNED 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 `categories`
--

INSERT INTO `categories` (`Cat_id`, `Cat_Name`, `Cat_Des`, `U_ID`, `created_at`, `updated_at`) VALUES
(1, 'Whiskers', 'cdscdscdsc', 2, '2025-05-20 11:43:25', '2025-05-20 11:49:50'),
(3, 'fdsfdsfdsf', 'cdscdscdsc', 1, '2025-05-20 12:32:49', '2025-05-20 12:32:49'),
(4, 'fdsfdsfdsf', 'cdscdscdsc', 1, '2025-05-20 12:33:09', '2025-05-20 12:33:09'),
(5, 'Technology', 'All technology-related articles and posts', 8, '2025-10-08 08:47:02', '2025-10-08 08:47:02');

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

--
-- Table structure for table `celebration`
--

CREATE TABLE `celebration` (
  `N_Id` bigint UNSIGNED NOT NULL,
  `N_Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `N_Category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_MaleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_WomanName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Date` date DEFAULT NULL,
  `N_Age` int DEFAULT NULL,
  `N_Years` int DEFAULT NULL,
  `N_Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `N_Status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `U_Id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `celebration`
--

INSERT INTO `celebration` (`N_Id`, `N_Title`, `N_Category`, `N_MaleName`, `N_WomanName`, `N_Date`, `N_Age`, `N_Years`, `N_Mobile`, `N_Email`, `N_Address`, `N_Description`, `N_Image`, `N_Status`, `U_Id`, `created_at`, `updated_at`) VALUES
(2, 'Birthday Event', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '\"null\"', 'approved', 2, '2025-04-19 05:29:54', '2025-04-19 05:29:54'),
(3, 'Birthday Event', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '\"null\"', 'pending', 3, '2025-04-19 05:39:05', '2025-04-19 05:39:05'),
(4, 'Birthday Event', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '\"null\"', 'approved', 4, '2025-04-19 05:39:12', '2025-04-19 05:39:12'),
(5, 'Birthday Event', 'Birthday', 'Ram', 'priya', '2025-04-19', 25, 25, '1278459565', 'ram@gmail.com', '123,vivkarma colony,Ahemdabad', 'ram Birthday celebration', '\"null\"', 'approved', 3, '2025-04-19 05:39:22', '2025-04-19 05:39:39'),
(7, 'Birthday Event', 'Birthday', 'Ram', 'priya', '2025-04-19', 25, 25, '1278459565', 'ram@gmail.com', '123,vivkarma colony,Ahemdabad', 'ram Birthday celebration', '\"[\\\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1745043343_68033f8f5eee3.png\\\"]\"', 'rejected', 3, '2025-04-19 06:06:02', '2025-04-19 06:15:43'),
(8, 'Birthday', 'Birthday', 'Max', NULL, '2025-05-21', 23, NULL, NULL, NULL, 'Ahmedabad', 'Birthday', '[\"https:\\/\\/parivaar.app\\/public\\/celebration\\/1747838106_1000018137.jpg\"]', 'approved', 39, '2025-05-21 20:05:06', '2025-05-21 20:05:23'),
(9, 'Birthday Event', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '\"[\\\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1749446051_68466da3daffb.png\\\",\\\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1749446430_68466f1e53403.png\\\",\\\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1749447496_684673480da86.png\\\",\\\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1751446661_6864f48571625.png\\\"]\"', 'approved', 2, '2025-05-29 06:03:39', '2025-07-02 08:57:41'),
(10, 'Happy Anniversary Celebration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1759905250_book.jpg\",\"http:\\/\\/127.0.0.1:8000\\/celebration\\/1759905250_Sequence-Diagram.png\"]', 'pending', 3, '2025-10-08 06:34:10', '2025-10-08 06:34:10');

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

--
-- Table structure for table `com_packages`
--

CREATE TABLE `com_packages` (
  `Com_P_Id` bigint UNSIGNED NOT NULL,
  `U_Id` bigint UNSIGNED NOT NULL,
  `St_Date` date NOT NULL,
  `End_Date` date NOT NULL,
  `U_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PackageId` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PackageName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Package_Description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Package_Status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Package_MaxUsers` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `DT_Id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `D_Id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Dis_Merge` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `PVT_Id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Final_Price` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Total_Duration` varchar(255) COLLATE utf8mb4_unicode_ci 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 `com_packages`
--

INSERT INTO `com_packages` (`Com_P_Id`, `U_Id`, `St_Date`, `End_Date`, `U_Name`, `PackageId`, `PackageName`, `Package_Description`, `Package_Status`, `Package_MaxUsers`, `DT_Id`, `D_Id`, `Dis_Merge`, `PVT_Id`, `Final_Price`, `Total_Duration`, `created_at`, `updated_at`) VALUES
(1, 20, '2025-04-17', '2025-04-18', 'keshav', '6', 'Primum package 1', NULL, 'A', '100', '1', '6', '1', '1', '400.00', '1', '2025-04-17 12:37:42', '2025-04-17 12:37:42'),
(2, 20, '2025-04-17', '2025-05-17', 'keshav', '7', 'Primum package', NULL, 'A', '100', '2', '6', '1', '1', '400.00', '30', '2025-04-17 12:40:18', '2025-04-17 12:40:18'),
(3, 21, '2025-04-17', '2029-05-26', 'keshav', '1', 'Basic package', NULL, 'A', '100', '2', '6', '1', '1', '400.00', '1500', '2025-04-17 16:52:03', '2025-04-17 16:52:03'),
(4, 20, '2025-04-18', '2025-04-19', 'John Doe 1', '2', 'ABCDEF', NULL, 'A', '100', '1', '6', '1', '1', '0.00', '1', '2025-04-17 18:39:41', '2025-04-17 18:39:41'),
(5, 27, '2025-04-21', '2075-04-09', 'keshav', '1', 'Basic package 1', 'This package is a applay for all users 1', 'A', '50', '4', '0', '3', '1', '377.00', '18250', '2025-04-21 06:32:26', '2025-04-21 06:32:26'),
(6, 28, '2025-04-21', '2075-04-09', 'keshav', '1', 'Basic package 1', 'This package is a applay for all users 1', 'A', '50', '4', '0', '3', '1', '377.00', '18250', '2025-04-21 06:59:04', '2025-04-21 06:59:04'),
(7, 32, '2025-04-21', '2025-07-20', 'keshav', '7', 'Gold Package', 'This package is Gold Package', 'A', '600', '2', '[7,1]', '1', '1', '388.00', '90', '2025-04-21 07:49:36', '2025-04-21 07:49:36'),
(8, 33, '2025-04-21', '2025-07-20', 'keshav', '7', 'Gold Package', 'This package is Gold Package', 'A', '600', '2', '[7,1]', '1', '1', '388.00', '90', '2025-04-21 08:50:59', '2025-04-21 08:50:59'),
(9, 34, '2025-04-21', '2025-07-20', 'keshav', '12', 'Gold Package', 'This package is Gold Package', 'A', '600', '2', '[7,1]', '1', '1', '500.00', '90', '2025-04-21 08:57:30', '2025-04-21 08:57:30'),
(10, 35, '2025-04-21', '2025-07-20', 'keshav', '12', 'Gold Package', 'This package is Gold Package', 'A', '600', '2', '[7,1]', '1', '1', '500.00', '90', '2025-04-21 09:21:38', '2025-04-21 09:21:38'),
(11, 37, '2025-05-21', '2028-05-20', 'kalpen', '1', 'Basic Package', 'This package is Basic Package', 'A', '600', '3', '[]', '1', '1', '1400.00', '1095', '2025-05-21 19:44:41', '2025-05-21 19:44:41'),
(12, 38, '2025-05-21', '2028-05-20', 'Shyamal', '1', 'Basic Package', 'This package is Basic Package', 'A', '600', '3', '[]', '1', '1', '1400.00', '1095', '2025-05-21 19:54:45', '2025-05-21 19:54:45'),
(13, 40, '2025-06-07', '2025-09-05', 'Krunal', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 07:03:26', '2025-06-07 07:03:26'),
(14, 41, '2025-06-07', '2025-09-05', 'Krunal1', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 07:17:15', '2025-06-07 07:17:15'),
(15, 42, '2025-06-07', '2025-09-05', 'Krunal2', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 07:26:09', '2025-06-07 07:26:09'),
(16, 43, '2025-06-07', '2025-09-05', 'Rahul', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 07:49:18', '2025-06-07 07:49:18'),
(17, 44, '2025-06-07', '2025-09-05', 'Rahul1', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 07:51:12', '2025-06-07 07:51:12'),
(18, 45, '2025-06-07', '2025-09-05', 'Rahul12', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 08:44:02', '2025-06-07 08:44:02'),
(19, 46, '2025-06-07', '2025-09-05', 'Rahul11', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-06-07 08:46:03', '2025-06-07 08:46:03'),
(20, 12, '2025-10-08', '2025-12-08', 'Krunal Kapadiya', 'PKG1001', 'Standard Plan', 'This plan includes all standard features.', 'active', '100', 'DT45', 'D56', 'Yes', 'PVT12', '4999', '45', '2025-10-08 05:59:30', '2025-10-08 06:04:53'),
(21, 47, '2025-10-08', '2026-01-06', 'Alice Admin', '2', 'Primum Package', 'This package is Primum Package', 'A', '600', '2', '[]', '2', '3', '2800.00', '90', '2025-10-08 07:16:16', '2025-10-08 07:16:16');

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

--
-- Table structure for table `condolences`
--

CREATE TABLE `condolences` (
  `N_Id` bigint UNSIGNED NOT NULL,
  `N_Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `N_Category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_MaleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_WomanName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Date` date DEFAULT NULL,
  `N_Age` int DEFAULT NULL,
  `N_Years` int DEFAULT NULL,
  `N_Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `N_Status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `U_Id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `condolences`
--

INSERT INTO `condolences` (`N_Id`, `N_Title`, `N_Category`, `N_MaleName`, `N_WomanName`, `N_Date`, `N_Age`, `N_Years`, `N_Mobile`, `N_Email`, `N_Address`, `N_Description`, `N_Image`, `N_Status`, `U_Id`, `created_at`, `updated_at`) VALUES
(1, 'xyz', 'xyz', NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, '\"[\\\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1745044593_68034471cbd5e.png\\\"]\"', 'approved', 3, '2025-04-19 06:31:38', '2025-04-19 06:37:49'),
(3, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1745044988_fashion.png\"]', 'pending', 3, '2025-04-19 06:43:08', '2025-04-19 06:43:08'),
(4, 'abc', 'xyz', NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1745044991_fashion.png\"]', 'rejected', 2, '2025-04-19 06:43:11', '2025-04-19 06:44:30'),
(5, 'Sad', NULL, 'Sad', NULL, '2025-05-21', 98, NULL, NULL, NULL, 'Ahmedabad', 'Sad', '[\"https:\\/\\/parivaar.app\\/public\\/condolences\\/1747838173_1000017760.jpg\"]', 'approved', 39, '2025-05-21 20:06:13', '2025-05-21 20:06:20'),
(6, 'Krunal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1748499096_naure.jpg\"]', 'pending', 3, '2025-05-29 06:11:36', '2025-05-29 06:11:36'),
(7, 'Happy Anniversary Celebration', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1759905411_book.jpg\",\"http:\\/\\/127.0.0.1:8000\\/condolences\\/1759905411_Sequence-Diagram.png\"]', 'pending', 3, '2025-10-08 06:36:51', '2025-10-08 06:36:51');

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

--
-- Table structure for table `discount_masters`
--

CREATE TABLE `discount_masters` (
  `D_Id` bigint UNSIGNED NOT NULL,
  `D_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `St_Date` date NOT NULL,
  `En_Date` date NOT NULL,
  `DT_Id` bigint UNSIGNED NOT NULL,
  `DVT_Id` bigint UNSIGNED NOT NULL,
  `Dic_Value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quentity` int DEFAULT NULL,
  `Dis_Status` enum('A','I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A',
  `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 `discount_masters`
--

INSERT INTO `discount_masters` (`D_Id`, `D_Name`, `St_Date`, `En_Date`, `DT_Id`, `DVT_Id`, `Dic_Value`, `quentity`, `Dis_Status`, `created_at`, `updated_at`) VALUES
(1, 'Membership Discount', '2025-04-16', '2025-04-30', 1, 1, '100', NULL, 'A', '2025-04-22 11:35:14', '2025-04-22 11:36:53'),
(2, 'Clearance Sale', '2025-04-16', '2025-04-30', 1, 2, '20', NULL, 'A', '2025-04-22 11:38:24', '2025-04-22 11:38:24'),
(3, 'Referral Discount', '2025-04-16', '2025-04-30', 1, 2, '5', NULL, 'A', '2025-04-22 11:38:47', '2025-04-22 11:38:47'),
(4, 'Festival Discount', '2025-04-16', '2025-04-30', 1, 1, '200', NULL, 'A', '2025-04-22 11:39:15', '2025-04-22 11:39:15'),
(5, 'Spring Sale', '2025-10-06', '2025-10-31', 1, 2, '15%', 90, 'A', '2025-10-06 08:48:29', '2025-10-06 08:49:05');

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

--
-- Table structure for table `discount_types`
--

CREATE TABLE `discount_types` (
  `DT_Id` bigint UNSIGNED NOT NULL,
  `Type_Name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `discount_types`
--

INSERT INTO `discount_types` (`DT_Id`, `Type_Name`, `created_at`, `updated_at`) VALUES
(1, 'Quantity', '2025-04-15 02:04:46', '2025-04-18 05:00:08'),
(2, 'Amount', '2025-04-15 02:04:53', '2025-04-15 02:04:53'),
(4, 'Loyalty Discount', '2025-10-06 07:40:39', '2025-10-06 07:42:07');

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

--
-- Table structure for table `dis_val_types`
--

CREATE TABLE `dis_val_types` (
  `DVT_Id` bigint UNSIGNED NOT NULL,
  `VT_Name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `dis_val_types`
--

INSERT INTO `dis_val_types` (`DVT_Id`, `VT_Name`, `created_at`, `updated_at`) VALUES
(1, 'Flat Discount', '2025-04-14 11:35:24', '2025-04-15 03:20:28'),
(2, 'Percentage Discount', '2025-04-14 11:35:31', '2025-04-15 06:34:16'),
(7, 'Buy Two Get One', '2025-10-06 07:18:37', '2025-10-06 07:20:44');

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

--
-- Table structure for table `donates`
--

CREATE TABLE `donates` (
  `Do_id` bigint UNSIGNED NOT NULL,
  `D_amount` decimal(10,2) NOT NULL,
  `U_ID` bigint UNSIGNED NOT NULL,
  `D_id` bigint UNSIGNED NOT NULL,
  `Date` date 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 `donates`
--

INSERT INTO `donates` (`Do_id`, `D_amount`, `U_ID`, `D_id`, `Date`, `created_at`, `updated_at`) VALUES
(1, 23.00, 1, 1, '2025-05-20', '2025-05-20 12:34:36', '2025-05-20 12:34:36'),
(2, 50.00, 3, 10, '2025-05-26', '2025-05-26 11:32:59', '2025-05-26 11:32:59');

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

--
-- Table structure for table `donations`
--

CREATE TABLE `donations` (
  `D_id` bigint UNSIGNED NOT NULL,
  `D_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `D_des` text COLLATE utf8mb4_unicode_ci,
  `goal_amount` decimal(10,2) NOT NULL,
  `mini_amount` decimal(10,2) NOT NULL DEFAULT '5.00',
  `Start_date` date NOT NULL,
  `End_date` date NOT NULL,
  `Pop_up` enum('Y','N') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `U_ID` bigint UNSIGNED NOT NULL,
  `Cat_id` bigint 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 `donations`
--

INSERT INTO `donations` (`D_id`, `D_name`, `D_des`, `goal_amount`, `mini_amount`, `Start_date`, `End_date`, `Pop_up`, `status`, `U_ID`, `Cat_id`, `created_at`, `updated_at`) VALUES
(1, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'Y', 1, 1, NULL, '2025-05-20 12:09:32', '2025-05-20 12:14:42'),
(2, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 0, 1, NULL, '2025-05-20 12:09:41', '2025-05-28 07:00:21'),
(3, 'Clean Water Initiative', 'Providing clean drinking water to rural areas.', 50000.00, 10.00, '2025-06-01', '2025-12-31', 'N', 0, 1, NULL, '2025-05-20 12:09:42', '2025-05-20 12:09:42'),
(4, 'Clean Water Initiative', 'Providing clean drinking water to rural areas.', 50000.00, 10.00, '2025-06-01', '2025-12-31', 'N', 0, 1, NULL, '2025-05-20 12:09:53', '2025-05-20 12:09:53'),
(5, 'Clean Water Initiative', 'Providing clean drinking water to rural areas.', 50000.00, 1.00, '2025-06-01', '2025-12-31', 'N', 0, 1, NULL, '2025-05-20 12:31:56', '2025-05-20 12:31:56'),
(6, 'Clean Water Initiative', 'Providing clean drinking water to rural areas.', 50000.00, 1.00, '2025-06-01', '2025-12-31', 'N', 0, 1, NULL, '2025-05-20 12:33:16', '2025-05-20 12:33:16'),
(7, 'Clean Water Initiative', 'Providing clean drinking water to rural areas.', 50000.00, 1.00, '2025-06-01', '2025-12-31', 'N', 0, 1, 1, '2025-05-20 13:08:51', '2025-05-20 13:08:51'),
(8, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 0, 3, NULL, '2025-05-26 11:10:09', '2025-05-26 11:10:09'),
(9, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 0, 2, NULL, '2025-05-26 11:11:34', '2025-05-26 11:11:34'),
(10, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 0, 38, NULL, '2025-05-26 11:18:51', '2025-05-26 11:18:51'),
(11, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 1, 1, NULL, '2025-05-28 07:04:34', '2025-05-28 07:27:30'),
(12, 'KUNAL Initiative', 'NOT PENDING clean water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 1, 1, NULL, '2025-05-28 07:14:34', '2025-05-28 07:14:34'),
(13, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 1, 2, NULL, '2025-05-28 10:30:56', '2025-05-28 10:30:56'),
(14, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 1, 2, 1, '2025-05-28 10:37:00', '2025-05-28 10:37:00'),
(15, 'KUNAL Water Initiative', 'NOT PENDING clean drinking water to rural areas.', 1222.00, 20.00, '2025-06-01', '2025-12-31', 'N', 1, 2, 1, '2025-05-28 10:38:35', '2025-05-28 10:38:35'),
(16, 'Save the Forest', 'Fundraising to protect  forests', 45000.00, 100.00, '2025-10-10', '2025-12-31', 'N', 1, 10, 3, '2025-10-08 09:03:37', '2025-10-08 09:12:21');

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

--
-- Table structure for table `duration_types`
--

CREATE TABLE `duration_types` (
  `DT_Id` bigint UNSIGNED NOT NULL,
  `Dur_Type` varchar(255) COLLATE utf8mb4_unicode_ci 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 `duration_types`
--

INSERT INTO `duration_types` (`DT_Id`, `Dur_Type`, `created_at`, `updated_at`) VALUES
(1, 'Day', '2025-04-22 11:47:08', '2025-04-22 11:47:08'),
(2, 'Month', '2025-04-22 11:47:15', '2025-04-22 11:47:15'),
(3, 'Year', '2025-04-22 11:47:20', '2025-04-22 11:47:20'),
(4, 'Quarterly', '2025-10-06 07:15:16', '2025-10-06 07:16:29');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `E_Id` bigint UNSIGNED NOT NULL,
  `E_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `E_Creater_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `E_Creater_Mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `U_Id` bigint UNSIGNED DEFAULT NULL,
  `Mam_Id` bigint UNSIGNED DEFAULT NULL,
  `E_StartDate` date NOT NULL,
  `E_EndDate` date NOT NULL,
  `E_StartTime` time NOT NULL,
  `E_EndTime` time NOT NULL,
  `E_Place` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `E_Description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `E_State` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `E_City` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `E_Zipcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `E_Address` text COLLATE utf8mb4_unicode_ci,
  `E_Fees` bigint DEFAULT NULL,
  `E_Status` char(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'P' COMMENT 'P:Pending,A: Active, R: Reject,C:Cancalled,D:Done',
  `E_Capacity` int NOT NULL,
  `E_Booked_Count` int NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL 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 `events`
--

INSERT INTO `events` (`E_Id`, `E_Name`, `E_Creater_Name`, `E_Creater_Mobile`, `U_Id`, `Mam_Id`, `E_StartDate`, `E_EndDate`, `E_StartTime`, `E_EndTime`, `E_Place`, `E_Description`, `E_State`, `E_City`, `E_Zipcode`, `E_Address`, `E_Fees`, `E_Status`, `E_Capacity`, `E_Booked_Count`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Driving Licence Camp', 'Ram', '4545148276', 2, NULL, '2025-04-19', '2025-04-19', '05:30:00', '17:38:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'D', 10, 9, NULL, '2025-04-19 14:31:06', '2025-04-19 15:14:06'),
(2, 'Driving Licence Camp', 'Ram', '4545148276', 2, NULL, '2025-04-19', '2025-04-19', '05:30:00', '17:38:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'P', 10, 0, NULL, '2025-04-19 14:52:04', '2025-04-19 14:52:04'),
(3, 'Driving Licence Camp', 'Ram', '4545148276', 2, NULL, '2025-04-19', '2025-04-19', '05:30:00', '17:38:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'D', 10, 0, NULL, '2025-04-19 15:00:12', '2025-04-19 15:02:03'),
(4, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-19', '2025-04-19', '05:30:00', '17:38:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'P', 10, 0, NULL, '2025-04-19 15:00:24', '2025-04-19 15:00:24'),
(5, 'Driving Licence Camp', 'Ram', '4545148276', 2, NULL, '2025-04-19', '2025-04-19', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'D', 10, 0, NULL, '2025-04-19 15:01:14', '2025-04-19 15:06:26'),
(6, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-19', '2025-04-19', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'D', 10, 0, NULL, '2025-04-19 15:01:20', '2025-04-19 15:06:18'),
(7, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-21', '2025-04-25', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'D', 10, 3, NULL, '2025-04-21 06:54:50', '2025-05-21 19:08:33'),
(8, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-21', '2025-04-25', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'P', 10, 0, NULL, '2025-04-21 09:59:39', '2025-04-21 09:59:39'),
(9, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-21', '2025-04-25', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '10001', '123 Park Ave, New York, NY', 10, 'P', 10, 0, NULL, '2025-04-21 09:59:55', '2025-04-21 09:59:55'),
(10, 'Driving Licence Camp', 'Ram', '4545148276', 3, NULL, '2025-04-21', '2025-04-25', '05:30:00', '20:34:00', 'Central Park', 'A community-driven event to book the Licence.', 'New York', 'New York City', '100001', '123 Park Ave, New York, NY', 10, 'P', 10, 0, NULL, '2025-04-21 10:10:39', '2025-04-21 10:10:39'),
(11, 'First Events', 'Manoj Sharma', '4455577848', 3, NULL, '2025-04-22', '2025-04-25', '05:30:00', '20:34:00', 'Central Park', 'A community-First event to book.', 'New York', 'New York City', '100001', '123 Park Ave, New York, NY', 100, 'P', 10, 0, NULL, '2025-04-22 11:30:07', '2025-04-22 11:30:07'),
(12, 'Gathering', 'Arth', '1234567890', 18, NULL, '2025-05-22', '2025-05-23', '12:24:00', '21:32:00', 'Malk', 'Annual Gathering', 'Gujarat', 'Ahmedabad', '38528', 'Ahmedabad', 388, 'P', 40, 0, NULL, '2025-05-21 19:32:14', '2025-05-21 19:32:14'),
(13, 'Gathering', 'Arth', '1234567890', 18, NULL, '2025-05-22', '2025-05-23', '12:24:00', '21:32:00', 'Malk', 'Annual Gathering', 'Gujarat', 'Ahmedabad', '38528', 'Ahmedabad', 388, 'P', 40, 0, NULL, '2025-05-21 19:33:12', '2025-05-21 19:33:12'),
(14, 'community Gathering', 'Shyamal', '6356950981', 2, NULL, '2025-05-23', '2025-05-23', '10:00:00', '15:00:00', 'Ahmedabad', 'Gathering', 'Gujarat', 'Ahmedabad', '382330', '23, hanumanprui salangpur road, salangpur', 200, 'D', 10, 0, NULL, '2025-05-21 19:38:58', '2025-05-23 17:52:38'),
(15, 'Laravel Workshop', 'Krunal', '7013654789', 2, NULL, '2025-05-29', '2025-05-29', '14:00:00', '17:00:00', 'Ahmedabad', 'Gathering', 'Gujrat', 'Ahmedabad', NULL, 'Ahmedabad, Gujrat', NULL, 'D', 15, 0, NULL, '2025-05-29 06:34:29', '2025-07-17 05:50:42'),
(16, 'Laravel Workshop', 'Krunal', '7013654789', 2, NULL, '2025-05-29', '2025-05-29', '14:00:00', '17:00:00', 'Ahmedabad', 'Gathering', 'Gujrat', 'Ahmedabad', NULL, 'Ahmedabad, Gujrat', NULL, 'P', 15, 0, '2025-10-08 06:58:40', '2025-05-29 06:48:50', '2025-10-08 06:58:40'),
(17, 'Annual Tech Conference 2025', 'John Doe', '9876543210', 2, NULL, '2025-12-01', '2025-12-03', '09:00:00', '18:00:00', 'Tech Convention Center', 'A 3-day conference for technology enthusiasts.', 'Maharashtra', 'Mumbai', NULL, '123 Convention Street', NULL, 'P', 500, 3, NULL, '2025-10-08 06:56:52', '2025-10-08 07:03:16');

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

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

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

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

--
-- Table structure for table `gallary`
--

CREATE TABLE `gallary` (
  `CE_Id` bigint UNSIGNED NOT NULL,
  `CE_Name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CE_Date` date DEFAULT NULL,
  `CE_Place` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `CE_Description` text COLLATE utf8mb4_unicode_ci,
  `CE_Photo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `U_Id` bigint UNSIGNED 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 `gallary`
--

INSERT INTO `gallary` (`CE_Id`, `CE_Name`, `CE_Date`, `CE_Place`, `CE_Description`, `CE_Photo`, `U_Id`, `created_at`, `updated_at`) VALUES
(1, 'Cricket Tournament', '2025-05-22', 'Box Cricket', 'Cricket Tournament', '[\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747835785_cricket1.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747835785_cricket2.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747835785_cricket3.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747835785_cricket4.jpg\"]', 2, '2025-05-21 19:26:25', '2025-05-21 19:26:25'),
(2, 'PICNIC', '2025-05-18', 'Jaisalmer', 'Jaisalmer', '[\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837084_free-photo-of-bada-bagh-in-india - Copy.jpeg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837084_free-photo-of-cow-in-jaisalmir-in-india.jpeg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837084_free-photo-of-traditional-museum-in-india-in-sunlight.jpeg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837084_gallery5.jpg\"]', 2, '2025-05-21 19:48:04', '2025-05-21 19:48:04'),
(3, 'Cricket Tournament', '2025-05-12', 'Ahmedabad', 'Cricket Tournament', '[\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837862_cricket1.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837862_cricket2.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837862_cricket3.jpg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837862_cricket4.jpg\"]', 38, '2025-05-21 20:01:02', '2025-05-21 20:01:02'),
(4, 'Tour', '2025-05-16', 'Jaisalmer', '4 Days Tour', '[\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837971_free-photo-of-bada-bagh-in-india - Copy.jpeg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837971_free-photo-of-traditional-museum-in-india-in-sunlight.jpeg\",\"https:\\/\\/parivaar.app\\/public\\/gallary\\/photos\\/1747837971_gallery5.jpg\"]', 38, '2025-05-21 20:02:51', '2025-05-21 20:02:51'),
(5, 'Football Tournament', NULL, NULL, NULL, '[\"http:\\/\\/127.0.0.1:8000\\/gallary\\/photos\\/1748499555_naure.jpg\"]', 2, '2025-05-29 06:19:16', '2025-05-29 06:19:16');

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

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

CREATE TABLE `jobs` (
  `id` bigint UNSIGNED NOT NULL,
  `Company_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Job_Title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Job_Description` text COLLATE utf8mb4_unicode_ci,
  `website` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `U_Id` bigint UNSIGNED NOT NULL,
  `Status` enum('open','close') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `Location` text COLLATE utf8mb4_unicode_ci,
  `City` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `State` varchar(255) COLLATE utf8mb4_unicode_ci 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 `jobs`
--

INSERT INTO `jobs` (`id`, `Company_Name`, `Job_Title`, `Job_Description`, `website`, `U_Id`, `Status`, `Location`, `City`, `State`, `created_at`, `updated_at`) VALUES
(1, 'Aark Infosoft PVT 1', 'Laravel Devloper 1', 'Laravel devloper 5 years exprience', NULL, 2, 'open', 'C G Road Ahemdabad', 'Ahemdabad', NULL, '2025-04-17 17:29:35', '2025-04-17 18:01:54'),
(2, 'Aark Infosoft PVT', 'Laravel Devloper', 'Laravel devloper 5 years exprience', NULL, 2, 'open', NULL, NULL, NULL, '2025-04-17 17:39:28', '2025-04-17 17:39:28'),
(4, 'Aark Infosoft PVT', 'Laravel Devloper', 'Laravel devloper 5 years exprience', 'https://aark.co.in/', 2, 'open', 'C G Road Ahemdabad', 'Ahemdabad', 'Gujrat', '2025-04-17 17:41:09', '2025-04-17 17:41:09'),
(7, 'Aark Infosoft PVT 1', 'Laravel Devloper 1', 'Laravel devloper 5 years exprience', 'https://aark.co.in/', 3, 'open', 'C G Road Ahemdabad', 'Ahemdabad', 'Gujrat', '2025-04-19 04:00:40', '2025-04-19 04:00:40'),
(9, 'React', 'React Devloper', 'job', 'https://parivaar.app/public/api/users', 3, 'open', 'Ahmedabad', 'Ahmedabad', 'Gujarat', '2025-05-26 10:31:22', '2025-05-26 10:31:22'),
(11, 'React', 'React Devloper', 'job', 'https://parivaar.app/public/api/users', 3, 'open', 'Ahmedabad', 'Ahmedabad', 'Gujarat', '2025-05-26 10:35:32', '2025-05-26 10:35:32'),
(15, 'node', 'node Devloper', 'job', 'https://parivaar.app/public/api/users', 3, 'open', 'Ahmedabad', 'Ahmedabad', 'Gujarat', '2025-05-26 10:47:32', '2025-05-26 10:47:32'),
(17, 'node', 'node Devloper', 'job', 'https://parivaar.app/public/api/users', 3, 'open', 'Ahmedabad', 'Ahmedabad', 'Gujarat', '2025-05-26 10:48:43', '2025-05-26 10:48:43'),
(24, 'Tech Solutions Pvt Ltd', 'Frontend Developer', 'Looking for a skilled frontend developer with 3+ years experience.', 'https://techsolutions.com', 2, 'open', 'Office Comference Room', 'Ahmedabad', 'Gujarat', '2025-10-06 09:09:10', '2025-10-06 09:09:53');

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

--
-- Table structure for table `job_applications`
--

CREATE TABLE `job_applications` (
  `id` bigint UNSIGNED NOT NULL,
  `Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Mobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `U_Id` bigint UNSIGNED NOT NULL,
  `Job_Id` bigint UNSIGNED NOT NULL,
  `Resume` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` text COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','accepted','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `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 `job_applications`
--

INSERT INTO `job_applications` (`id`, `Name`, `Mobile`, `U_Id`, `Job_Id`, `Resume`, `Description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'jay', '15244578154', 3, 4, 'C:\\xampp\\tmp\\php7998.tmp', NULL, 'pending', '2025-04-18 06:19:18', '2025-04-18 06:19:18'),
(2, 'jay', '15244578154', 3, 4, 'C:\\xampp\\tmp\\php1F69.tmp', NULL, 'pending', '2025-04-18 06:21:06', '2025-04-18 06:21:06'),
(3, 'jay', '15244578154', 3, 4, 'http://127.0.0.1:8000/Resume/1744957411_packages.docx', NULL, 'pending', '2025-04-18 06:23:31', '2025-04-18 06:23:31'),
(4, 'jay', '15244578154', 3, 4, 'http://127.0.0.1:8000/Resume/1744957448_Connecto.pdf', NULL, 'pending', '2025-04-18 06:24:08', '2025-04-18 06:24:08'),
(7, 'Krunal Kapadiya', '9876543410', 3, 11, 'http://127.0.0.1:8000/Resume/1759904817_1744957448_Connecto.pdf', 'Applying for a software developer position', 'pending', '2025-10-08 06:26:57', '2025-10-08 06:28:58');

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

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

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

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

--
-- Table structure for table `marketplaces`
--

CREATE TABLE `marketplaces` (
  `M_Id` bigint UNSIGNED NOT NULL,
  `M_Category` enum('Electronics','Home Appliances','Furniture','Clothes','Footwear','Books','Vehicles','Real Estate','Toys','Sports','Fitness','Handicrafts','Others') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `M_Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `M_Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `M_Name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `M_Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `M_Address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `M_Image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `M_Price` decimal(10,2) NOT NULL,
  `M_Status` enum('Active','Inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `U_Id` bigint UNSIGNED NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `marketplaces`
--

INSERT INTO `marketplaces` (`M_Id`, `M_Category`, `M_Title`, `M_Description`, `M_Name`, `M_Mobile`, `M_Address`, `M_Image`, `M_Price`, `M_Status`, `U_Id`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Electronics', 'Smart TV', NULL, 'abc', '41521789630', '123 abc marketplace', '[\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076101_social2.png\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076101_fashion.png\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076101_social.png\"]', 20000.00, 'Inactive', 3, NULL, '2025-04-19 15:21:41', '2025-05-21 19:26:44'),
(2, 'Electronics', 'Smart TV', NULL, 'abc', '41521789630', '123 abc marketplace', '[\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076109_social2.png\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076109_fashion.png\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1745076109_social.png\"]', 20000.00, 'Inactive', 3, NULL, '2025-04-19 15:21:49', '2025-05-21 19:26:48'),
(3, 'Vehicles', 'Bmw', 'Bmw x5', 'vansh', '8532196470', 'Ahmedabad', '[\"https:\\/\\/parivaar.app\\/public\\/marketplace\\/1747835902_image_0.jpg\"]', 233333.00, 'Active', 18, NULL, '2025-05-21 19:28:22', '2025-05-21 19:28:22'),
(4, 'Vehicles', 'Bmw', 'Bmw x5', 'vansh', '8532196470', 'Ahmedabad', '[\"https:\\/\\/parivaar.app\\/public\\/marketplace\\/1747835903_image_0.jpg\"]', 233333.00, 'Inactive', 18, NULL, '2025-05-21 19:28:23', '2025-05-21 19:29:53'),
(5, 'Vehicles', 'Audi', 'Audi Q7', 'vansh', '8532196470', 'Ahmedabad', '[\"https:\\/\\/parivaar.app\\/public\\/marketplace\\/1747835980_image_0.jpg\"]', 699999.00, 'Active', 18, NULL, '2025-05-21 19:29:40', '2025-05-21 19:29:40'),
(6, 'Electronics', 'Smart TV', NULL, 'abc', '7045123654', '123 abc marketplace', '[\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1748497942_naure.jpg\"]', 50000.00, 'Active', 3, NULL, '2025-05-29 05:52:22', '2025-05-29 05:52:22'),
(7, 'Electronics', '3', NULL, 'John Doe', '9876543210', '123 Main Street, Ahmedabad', '[\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1759906169_book.jpg\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1759906169_Sequence-Diagram.png\"]', 90000.00, 'Active', 4, NULL, '2025-10-08 06:49:29', '2025-10-08 06:49:29'),
(8, 'Electronics', '3', NULL, 'Smith', '9876543285', '123 Main Street, Ahmedabad', '[\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1759906212_book.jpg\",\"http:\\/\\/127.0.0.1:8000\\/marketplace\\/1759906212_Sequence-Diagram.png\"]', 65000.00, 'Active', 4, NULL, '2025-10-08 06:50:12', '2025-10-08 06:53:05');

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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_04_11_094409_create_personal_access_tokens_table', 1),
(5, '2025_04_11_094629_create_role_masters_table', 2),
(8, '2025_04_11_095851_create_user_masters_table', 3),
(9, '2025_04_11_131145_create_logins_table', 4),
(15, '2025_04_14_160922_create_package_features_table', 5),
(16, '2025_04_14_162937_create_price_masters_table', 5),
(17, '2025_04_14_164706_create_duration_types_table', 6),
(19, '2025_04_14_165801_create_dis_val_types_table', 7),
(20, '2025_04_15_045059_create_schedule_demos_table', 8),
(21, '2025_04_15_060002_create_price_type_values_table', 9),
(25, '2025_04_15_072511_create_discount_types_table', 10),
(27, '2025_04_15_072720_create_discount_masters_table', 11),
(34, '2025_04_15_095431_create_package_masters_table', 12),
(36, '2025_04_16_131301_create_tags_table', 13),
(38, '2025_04_16_142343_add_package_id_to_user_masters', 14),
(39, '2025_04_16_172951_add_total_duration_to_package_masters', 15),
(40, '2025_04_16_193134_create_com_packages_table', 16),
(41, '2025_04_17_173459_add_pan_no_and_com_regi_no_to_user_masters_table', 16),
(43, '2025_04_17_182350_create_notices_table', 17),
(44, '2025_04_17_203050_create_gallary_table', 17),
(46, '2025_04_17_224058_create_jobs_table', 18),
(47, '2025_04_18_104742_create_job_applications_table', 19),
(48, '2025_04_18_121625_add_dis_status_to_discount_masters_table', 20),
(51, '2025_04_18_144743_drop_package_masters_table', 21),
(57, '2025_04_18_144841_create_package_masters_table', 22),
(61, '2025_04_19_095345_create_celebration_table', 23),
(62, '2025_04_19_111102_create_condolences_table', 24),
(63, '2025_04_19_150941_create_marketplaces_table', 25),
(64, '2025_04_19_161101_create_events_table', 25),
(67, '2025_04_19_182340_create_book_events_table', 26),
(68, '2025_04_19_200525_create_additional_people_table', 26),
(69, '2025_04_19_213544_create_otp_log_table', 27),
(70, '2025_05_20_162631_create_categories_table', 28),
(71, '2025_05_20_172659_create_donations_table', 29),
(73, '2025_05_20_174708_create_donates_table', 30),
(74, '2025_05_20_183231_add_cat_id_to_donations_table', 31),
(75, '2025_05_20_192137_create_package_discount_table', 32),
(76, '2025_05_26_141405_create_cash_collections_table', 33);

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

--
-- Table structure for table `notices`
--

CREATE TABLE `notices` (
  `N_Id` bigint UNSIGNED NOT NULL,
  `N_Title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `N_Category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_MaleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_WomanName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Date` date DEFAULT NULL,
  `N_Age` int DEFAULT NULL,
  `N_Years` int DEFAULT NULL,
  `N_Mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `N_Address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `N_Image` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `U_Id` bigint UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notices`
--

INSERT INTO `notices` (`N_Id`, `N_Title`, `N_Category`, `N_MaleName`, `N_WomanName`, `N_Date`, `N_Age`, `N_Years`, `N_Mobile`, `N_Email`, `N_Address`, `N_Description`, `N_Image`, `U_Id`, `created_at`, `updated_at`) VALUES
(1, 'Sample Notice', 'General', 'John Doe', 'Jane Doe', '2025-04-17', 30, 5, '1234567890', 'abc@gmail.com', 'john3@example.com', 'This is a sample notice description', NULL, 10, '2025-04-17 16:44:01', '2025-04-17 16:44:01'),
(2, 'Community Gathering', NULL, 'Alpesh Sureshbhai Parmar', NULL, '2003-05-22', NULL, NULL, '07894561234', 'shyamalodedraaipl@gmail.com', '23, hanumanprui salangpur road, salangpur', 'demo', NULL, 2, '2025-05-21 19:28:10', '2025-05-21 19:28:10'),
(3, 'Community Gathering', 'Event', 'Alpesh Sureshbhai Parmar', NULL, '2003-05-22', NULL, NULL, '07894561234', 'shyamalodedraaipl@gmail.com', '23, hanumanprui salangpur road, salangpur', 'Community Gathering', NULL, 38, '2025-05-21 19:58:54', '2025-05-21 19:58:54'),
(4, 'Announcement', 'Announcement', 'Shyamal', NULL, '2025-05-22', NULL, NULL, '8518518513', NULL, NULL, 'Anmnouncement', NULL, 38, '2025-05-21 19:59:54', '2025-05-21 19:59:54'),
(5, 'Wedding Announcement', 'Marriage', 'John Doe', 'Jane Smith', '2025-07-24', 30, 5, '9876543210', 'john@example.com', '123 Wedding Street, Celebration City', 'A beautiful union of love and companionship.', NULL, 10, '2025-07-24 12:51:05', '2025-07-24 12:51:05'),
(6, 'Community Meeting', 'Event', 'Smith Doe', 'Smith Doe', '2025-10-10', 35, 5, '9876543210', 'smith@example.com', '567 Main Street', 'Monthly community meeting to discuss local issues.', '[\"image1.jpg\",\"image2.jpg\"]', 2, '2025-10-06 09:05:50', '2025-10-06 09:06:57');

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

--
-- Table structure for table `package_discount`
--

CREATE TABLE `package_discount` (
  `id` bigint UNSIGNED NOT NULL,
  `PackageId` bigint UNSIGNED NOT NULL,
  `D_Id` bigint 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 `package_discount`
--

INSERT INTO `package_discount` (`id`, `PackageId`, `D_Id`, `created_at`, `updated_at`) VALUES
(1, 4, 1, NULL, NULL),
(2, 4, 2, NULL, NULL);

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

--
-- Table structure for table `package_features`
--

CREATE TABLE `package_features` (
  `Package_Fea_Id` bigint UNSIGNED NOT NULL,
  `Package_Fea_Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Package_Fea_Description` text COLLATE utf8mb4_unicode_ci,
  `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 `package_features`
--

INSERT INTO `package_features` (`Package_Fea_Id`, `Package_Fea_Name`, `Package_Fea_Description`, `created_at`, `updated_at`) VALUES
(1, 'Member Management', NULL, '2025-04-22 11:57:35', '2025-04-22 11:57:35'),
(2, 'Notice Management', NULL, '2025-04-22 11:57:43', '2025-04-22 11:57:43'),
(3, 'Events Management', NULL, '2025-04-22 11:57:49', '2025-04-22 11:57:49'),
(4, 'Celebration Management', NULL, '2025-04-22 11:58:04', '2025-04-22 11:58:04'),
(5, 'Condolences Management', NULL, '2025-04-22 11:58:18', '2025-04-22 11:58:18'),
(6, 'Gallary Management', NULL, '2025-04-22 11:58:30', '2025-04-22 11:58:30'),
(7, 'Job', NULL, '2025-04-22 11:58:46', '2025-04-22 11:58:46'),
(8, 'Market Management', NULL, '2025-04-22 11:59:00', '2025-04-22 11:59:00'),
(9, 'Matrimony', NULL, '2025-04-22 11:59:21', '2025-04-22 11:59:21'),
(10, 'Package Feature Delux', 'Description for feature Delux', '2025-10-06 06:52:03', '2025-10-06 06:53:18');

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

--
-- Table structure for table `package_feature_pivot`
--

CREATE TABLE `package_feature_pivot` (
  `id` bigint UNSIGNED NOT NULL,
  `PackageId` bigint UNSIGNED NOT NULL,
  `Package_Fea_Id` bigint UNSIGNED 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 `package_feature_pivot`
--

INSERT INTO `package_feature_pivot` (`id`, `PackageId`, `Package_Fea_Id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, NULL, NULL),
(2, 1, 2, NULL, NULL),
(3, 1, 6, NULL, NULL),
(4, 2, 1, NULL, NULL),
(5, 2, 2, NULL, NULL),
(6, 2, 6, NULL, NULL),
(7, 2, 3, NULL, NULL),
(8, 2, 4, NULL, NULL),
(9, 2, 5, NULL, NULL),
(10, 2, 7, NULL, NULL),
(12, 3, 1, NULL, NULL),
(13, 3, 2, NULL, NULL),
(14, 3, 6, NULL, NULL),
(15, 3, 3, NULL, NULL),
(16, 3, 4, NULL, NULL),
(17, 3, 5, NULL, NULL),
(18, 3, 7, NULL, NULL),
(19, 3, 8, NULL, NULL),
(20, 3, 9, NULL, NULL),
(21, 4, 1, NULL, NULL),
(22, 4, 3, NULL, NULL),
(23, 4, 4, NULL, NULL);

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

--
-- Table structure for table `package_masters`
--

CREATE TABLE `package_masters` (
  `PackageId` bigint UNSIGNED NOT NULL,
  `PackageName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `Description` longtext COLLATE utf8mb4_unicode_ci,
  `Status` enum('A','D') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'A',
  `MaxUsers` int NOT NULL DEFAULT '0',
  `Duration_Value` int NOT NULL,
  `DT_Id` bigint UNSIGNED NOT NULL,
  `Dis_Merge` int NOT NULL DEFAULT '1',
  `PVT_Id` bigint UNSIGNED NOT NULL,
  `Final_Price` decimal(10,2) NOT NULL,
  `Total_Duration` int 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 `package_masters`
--

INSERT INTO `package_masters` (`PackageId`, `PackageName`, `Description`, `Status`, `MaxUsers`, `Duration_Value`, `DT_Id`, `Dis_Merge`, `PVT_Id`, `Final_Price`, `Total_Duration`, `created_at`, `updated_at`) VALUES
(1, 'Basic Package', 'This package is Basic Package', 'A', 600, 3, 3, 1, 1, 1400.00, 1095, '2025-04-22 12:06:09', '2025-04-22 12:06:09'),
(2, 'Primum Package', 'This package is Primum Package', 'A', 600, 3, 2, 2, 3, 2800.00, 90, '2025-04-22 12:21:54', '2025-04-22 12:32:01'),
(3, 'Gold Package', 'This package is Gold Package', 'A', 800, 3, 2, 3, 3, 3325.00, 90, '2025-04-22 12:34:10', '2025-04-22 12:34:10'),
(4, 'Premium Plan', 'Access to all features with premium support', 'D', 60, 6, 2, 2, 3, 2800.00, 180, '2025-10-06 08:50:52', '2025-10-06 08:59:16');

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

--
-- Table structure for table `price_masters`
--

CREATE TABLE `price_masters` (
  `PT_Id` bigint UNSIGNED NOT NULL,
  `Pri_Type` varchar(255) COLLATE utf8mb4_unicode_ci 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 `price_masters`
--

INSERT INTO `price_masters` (`PT_Id`, `Pri_Type`, `created_at`, `updated_at`) VALUES
(1, 'Retail Price', '2025-04-22 11:43:19', '2025-04-22 11:43:19'),
(2, 'Registration Price', '2025-04-22 11:43:41', '2025-04-22 11:43:41'),
(3, 'Subscription', '2025-04-22 11:43:53', '2025-04-22 11:43:53'),
(4, 'Basic+addon', '2025-10-06 06:57:35', '2025-10-06 06:58:45');

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

--
-- Table structure for table `price_type_values`
--

CREATE TABLE `price_type_values` (
  `PVT_Id` bigint UNSIGNED NOT NULL,
  `PT_Id` bigint UNSIGNED NOT NULL,
  `Price_Value` varchar(255) COLLATE utf8mb4_unicode_ci 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 `price_type_values`
--

INSERT INTO `price_type_values` (`PVT_Id`, `PT_Id`, `Price_Value`, `created_at`, `updated_at`) VALUES
(1, 1, '1500', '2025-04-22 11:44:22', '2025-04-22 11:44:22'),
(2, 2, '2500', '2025-04-22 11:44:31', '2025-04-22 11:44:31'),
(3, 3, '3500', '2025-04-22 11:44:38', '2025-04-22 11:44:38'),
(4, 1, '1200', '2025-10-06 07:23:42', '2025-10-06 07:24:13');

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

--
-- Table structure for table `role_masters`
--

CREATE TABLE `role_masters` (
  `Role_Id` bigint UNSIGNED NOT NULL,
  `Role_Name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `role_masters`
--

INSERT INTO `role_masters` (`Role_Id`, `Role_Name`, `created_at`, `updated_at`) VALUES
(1, 'SuperAdmin', '2025-04-11 06:34:21', '2025-04-11 06:34:21'),
(2, 'Community Admin', '2025-04-11 06:34:36', '2025-04-18 05:43:15'),
(3, 'Member', '2025-04-11 06:34:48', '2025-04-18 05:43:37');

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

--
-- Table structure for table `schedule_demos`
--

CREATE TABLE `schedule_demos` (
  `sche_id` bigint UNSIGNED NOT NULL,
  `sche_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sche_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sche_phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sche_date` date NOT NULL,
  `sche_time_slots` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `additional_note` text COLLATE utf8mb4_unicode_ci,
  `sche_status` tinyint NOT NULL DEFAULT '0',
  `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 `schedule_demos`
--

INSERT INTO `schedule_demos` (`sche_id`, `sche_name`, `sche_email`, `sche_phone`, `sche_date`, `sche_time_slots`, `additional_note`, `sche_status`, `created_at`, `updated_at`) VALUES
(2, 'Karan', 'jaydipdabhiaipl@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-14 23:47:57', '2025-04-14 23:49:44'),
(3, 'Kali', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-14 23:56:15', '2025-04-14 23:56:32'),
(4, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-15 00:17:18', '2025-04-15 00:17:31'),
(5, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-15 00:18:36', '2025-04-15 00:18:42'),
(6, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-15 00:19:17', '2025-04-15 00:19:23'),
(7, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-16 18:04:15', '2025-04-16 19:08:02'),
(8, 'Karan1', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 2, '2025-04-16 18:04:31', '2025-04-16 18:05:44'),
(9, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '18:16 - 20:18', 'notes', 1, '2025-04-16 18:16:27', '2025-04-16 19:09:03'),
(10, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '19:16 - 23:21', 'notes', 1, '2025-04-16 18:16:59', '2025-04-17 14:55:35'),
(11, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-17', '10:00 - 11:00', 'notes', 1, '2025-04-16 18:49:20', '2025-04-16 19:08:22'),
(12, 'Karan1', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-16 18:57:46', '2025-04-16 18:58:03'),
(13, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', NULL, 1, '2025-04-16 18:58:56', '2025-04-17 14:58:13'),
(14, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-17', '10:00 - 11:00', NULL, 2, '2025-04-16 18:59:05', '2025-04-16 19:10:05'),
(15, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '19:16 - 23:21', NULL, 2, '2025-04-16 18:59:17', '2025-04-16 19:10:10'),
(16, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-17', '10:00 - 11:00', NULL, 1, '2025-04-16 19:01:29', '2025-04-16 19:10:13'),
(17, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-17', '10:00 - 11:00', NULL, 1, '2025-04-16 19:01:32', '2025-04-17 14:55:49'),
(18, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', NULL, 2, '2025-04-16 19:01:34', '2025-04-17 14:58:20'),
(19, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '19:16 - 23:21', NULL, 2, '2025-04-16 19:01:37', '2025-04-17 14:58:22'),
(20, 'Karan', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', NULL, 2, '2025-04-16 19:01:53', '2025-04-17 14:58:24'),
(21, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '19:16 - 23:21', NULL, 1, '2025-04-16 19:01:55', '2025-04-16 19:09:53'),
(22, 'shyaml', 'shyamal@gmail.com', '07894564654', '2025-04-15', '18:16 - 20:18', NULL, 1, '2025-04-16 19:01:57', '2025-04-16 19:09:36'),
(23, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-17', '10:00 - 11:00', NULL, 1, '2025-04-16 19:02:10', '2025-04-16 19:09:24'),
(24, 'Alpesh Sureshbhai Parmar', 'shyamalodedraaipl@gmail.com', '07894561234', '2025-04-18', '10:02 - 11:00', 'notes', 1, '2025-04-17 15:03:03', '2025-04-17 15:06:03'),
(25, 'alpeshhh', 'alpeshgohelaipl@gmail.com', '8401019172', '2025-04-07', '19:12 - 21:14', 'i have question ?', 1, '2025-04-17 15:09:42', '2025-04-17 15:09:58'),
(26, 'Karan1', 'kalitester1105@gmail.com', '1234567890', '2025-04-27', '12:00 AM - 02:00 AM', 'Looking forward to the demo session', 1, '2025-04-17 15:12:15', '2025-04-17 15:12:23'),
(27, 'ghij', 'alpeshgohelaipl@gmail.com', '8401019172', '2025-04-10', '15:15 - 21:15', 'dxsfggfdxbdfh', 1, '2025-04-17 15:15:48', '2025-04-17 15:16:00'),
(28, 'ghij', 'alpeshgohelaipl@gmail.com', '8401019172', '2025-04-18', '16:17 - 17:18', 'notes', 2, '2025-04-17 15:17:03', '2025-04-17 15:17:10'),
(29, 'mohmed', 'kalitester1105@gmail.com', '6356950988', '2025-04-18', '16:27 - 20:32', 'notes', 1, '2025-04-17 15:27:09', '2025-04-17 17:36:08');

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int 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
('0rpUwcdG9xmb7AV5yW3yJ6VxbUVbiag6I46l9tG3', NULL, '34.194.165.45', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; Amazonbot/0.1; +https://developer.amazon.com/support/amazonbot) Chrome/119.0.6045.214 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQTRDNDVVeXkwT21JZE5VVmNidDFqcVFMRDBVQ3VzUUk3OGlmSHJkYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762527964),
('0SrqGkLyForTV6LTeTd31LxR4hIjHNHupEksCSQg', NULL, '74.7.227.135', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2dtVllJWDdJZGJ4cFkxN1hva09PaWxxNDk2T3FxM2N4dDZRZGxabiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761813615),
('4MCShDeuLIMs0Lf8CjCqnjRsUUV9CfeuZQcV6odi', NULL, '196.196.169.161', 'Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:114.0) Gecko/20100101 Firefox/114.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidG9PcWF1RnZ2RldxMFhLQmM2WDRsSGgwSlp6dUJSdWZ4MlprTTU0ZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762772959),
('6PBPK9nQRljceavkXiUmXmrRejGMhNfEnQbRVGa5', NULL, '193.36.220.12', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 OPR/89.0.4447.51', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR1M5N0VnSXFwWkVJY2Z0ejN5OEdFdHh2WTZyV1QxQlRQWExwN0pUQyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764432248),
('6XjAx9iImFzrbiAaixV76LNeuHZthCx3SPChDp04', NULL, '217.113.194.123', 'Mozilla/5.0 (compatible; Barkrowler/0.9; +https://babbar.tech/crawler)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieFYxazN4bWlQVElONjluQUVkQUh2U2ZPckVpS21sck8xeDZhZ25UTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763626052),
('76sqlX23yVtGijJltinVoSAh0vt0u1pXlJZIa8YD', NULL, '89.251.0.136', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV2lHMlFUMEJmTUc5anpGb3RqcmRYdFpGVFk1eTNDbTBqMFhXMTB6aSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762456786),
('8kDXJA89d9lz7ZFGZkgrVbfFcGEGuNEBFya3nZMO', NULL, '170.106.165.76', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRE9ac0VzOHl6YUs5WFlwRXdmQWNnZW1WUXd5Y3IxZHRJOEt2cmN2ZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764394638),
('B12gIlTFXKTZyEYyPBA2fcv3dgWgXhZsAJFT2rIJ', NULL, '89.251.0.67', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaUw3Ym16SUNmVXc2QkdaQ2RFSlZRSVp6eWM2d3pUTktlZlQ2Sk9YWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761378591),
('b4Y9SwMJXZgdyZqv44UjZqqhs96px04WXJsNnCfI', NULL, '169.150.196.25', 'Mozilla/5.0 (X11; Linux x86_64; rv:105.0) Gecko/20100101 Firefox/105.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUpENFRYeFZSdE1uaVpYbml0M25sTjlLTmpKV3pTT25BdzdvN0pMcSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763415336),
('b9vakvq8qJ2MbgnIRyngW6ndWYGedUizAEYTPcrl', NULL, '104.234.32.121', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1264.71', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQlF4emlUaDhKU2huMml1eVB1ZklaZEVYUmd6NGJxT1poTk9uQ3BCTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761851095),
('Ba9IZfSCyMVeufGzbvUqAHdvTAJ7NuHLkP8z7If4', NULL, '85.208.96.208', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibnhvYUJCWHBMZU0zWXpSUkRHd21adVNDeGNCaGZqN2FueVNjUllDWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763790011),
('dpf5jKfnL1nX5ioNnZUSwLOcAzU6XQHCBx2lWaev', NULL, '199.45.154.131', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWTk2UzlMSnVPT0FsaXY1Y2tEWXZNMWJIWVp5MEVBdGwxekdMS3RTRCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vcGFyaXZhYXIuYXBwLmNheGlzLmNhL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762189427),
('Dq2I0HfHx9DfqQbeMQse7EQEYr1KY2rIHw4SX4fi', NULL, '154.205.154.21', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicDEwVFhnWlZ5WkVSazBsZzdDeHpHYlRUeHRpcERaVGZDWmhhM240SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761371798),
('Du3Jok9Ohe8P3KUkUGHqx6emNJCCsNYa9moV6CsL', NULL, '173.239.214.98', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWGVVT1NER3E0eVBoUm1PTlBBZlJzQTVJbHJxbjk3dVE3UjNoTjIyTiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761465722),
('dUn5xRycMme1jR9Cnmks1baFQNT3xeRUuNglRujr', NULL, '43.130.100.35', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYlpjcjYzZlZiM0U1WDRtMHg4RUZKWGhnOHduZFZ3c1BSNTc2ZENPbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761386152),
('dy3p1VnWUHAUWpF976bHiNJ3sSO9oiUMa2lLJ13a', NULL, '104.234.32.140', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMGsyWlJFNVo4clFDd2ZaRDNrUmVGVjRsamlISW9taVIwa3EyTmttZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761776567),
('E5oEGPK4HTYSyZ65uriWwYjgChMkAjyFXergTkjB', NULL, '167.94.146.59', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV1NSTlczVGd5N3Z3b21rZnBwb0NnU2FBaE1pS0dPejF2ckpBQ1VMZiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762801268),
('EAQBjrDI3lKVGvwoCdHUXvik9b3obnvUDEpt6Go7', NULL, '181.56.233.63', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlhLaUxXcUpwWEJJRUU1OTQxdkZQazdaTktqQlVYYjgwTjF2YjhHcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761372837),
('Eja9x67Thwf0u1XIiM2VFNrWqeNZOI4F9Z9HaqRu', NULL, '101.33.66.34', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMWg1ZWtzbXU0YUhDN3hHMHJpYWpWVU9SanFqQ1VZZ2ViN3pyTndjNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763783858),
('eLtVToaDX1fz8eXHoljwW6FmZF869E7BQ97q0Hds', NULL, '195.210.107.17', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSzM2OUoyMDVCR3lxeU15cTJwTU8yS1BPRm1LSEdUVTROQmxHTkRMNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763664011),
('Fc6psWh3SRRbIDphc5YXEQDLJEHbOCNh347eYDk6', NULL, '199.45.155.73', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZk1IbTNDWTV4MkJKejVsd1QyUHlhaTQydkIwQU5UZDQwRktVQjFwTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9tYWlsLnBhcml2YWFyLmFwcC9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1763232629),
('Ff2EOmjuHDEaZk0oTIuhMUDnQuxmBXtbXQsMbXHS', NULL, '209.50.227.112', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQWl6V0tyMDhZT3Y1TmNOemoyZ3lDZ2VmTWpySWV6OWFxd2lOMURobiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761371797),
('fn0EYuk3n7Z2B62pvH8jBSQJIL8ALIh6ESvMQabl', NULL, '47.79.196.84', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibnN5N2sybFdPQnlJOVdhdUllcmRDRlFIYXpZa3NlcWNkT1o3endpMyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762880979),
('fXVNnvAKMJwMlHoNTFRBREdBzWCxgTm4ydph5GOa', NULL, '74.7.227.73', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid2xqeVZOcFR6d0c2RXJMTEsxMVY4Y0lRcEpZSVVkRHlaZFVWeHFoaiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vcGFyaXZhYXIuYXBwLmNheGlzLmNhL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761969420),
('gCsXhY78FOZkmgAjBJkxHwQk1wBtNObdbfVYJNCB', NULL, '43.165.70.220', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSkxKa3hDN21oaG85TzZzbFFKM2ZVV0pPRnVZWTl6T25IUVFYM2xjZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761797696),
('gePcxVCxyUW5inbYYjFYHfDw1gkwr8Url8Jrttgy', NULL, '206.168.34.222', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY2M5Mnk4NlBpSXpLandNNmp4U25HT2twblRPNDM4WVhlbVNlemcyRSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vd3d3LnBhcml2YWFyLmFwcC5jYXhpcy5jYS9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1763393102),
('glDkkXvlLLHHCoUDjeHBNPeh0gYOd45E8FJDmU2d', NULL, '167.94.138.197', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUXlTWDdJQ0FOQWJla0FzMExGdEtBOHBZaUt3aENBUkJvdUdCRVM0ZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly9wYXJpdmFhci5hcHAuY2F4aXMuY2EvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762004646),
('gPvyNBOVSPcrZOSxvCsIxo42lJB8Szm05scLhswY', NULL, '182.253.128.3', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT2ZGMjE4MnFSNndpYkd0V1VMRFFiMkI2N0VMYWNrb2lSb3NXM2h2UiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vd3d3LnBhcml2YWFyLmFwcC5jYXhpcy5jYS9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1761764351),
('H7c7Aqn939GDKBgcfOGLSAbJ3KDGYLYKPjKUSEOw', NULL, '192.158.226.22', 'Mozilla/5.0 (Linux; arm_64; Android 14; TECNO LH7n) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/138.0.7204.105 YaBrowser/25.8.5.105.00 SA/3 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVG9VaDZTWE90QTVMcGJXRllKZEFhMWlVQjhZTVNBWGJUR2ZqQ1RpVSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761371797),
('hoSMnXlkOpwaFc2ld0ZQYqJsr7xPRc4Emf0gkI22', NULL, '65.215.117.189', 'Mozilla/5.0 (Windows NT 10.0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTXJ4UXdmR3dIRTNoOGg2cDFnMFloUnZ5aXVtZ2RtMTFMSFM4WXZqciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764158111),
('hZdph3VrztSWCKwY18flWGcFnmB14RDQqJwHc1Dd', NULL, '23.94.155.139', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 YaBrowser/22.7.0 Yowser/2.5 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2lTS21ueGxNZXE2Z2xqM3ZGdU85a1ZyMHVQNGhQaFJDVDk5RXNYNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761523945),
('ICSaa7Yt9G9Pb7ybt15uAFsXmltPJo02CzYmFB55', NULL, '64.64.116.13', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY3JVV3VaZHB6ZE9oRkY1eHRCNGtYTU5HeThhbEtKTVVmWjNzUzdSaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761553219),
('InOwk5Lfq80zrwKHLv9erVSRJ2tZmJ6mKrSmyX7k', NULL, '43.159.136.201', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNGZYcTlXc2NtTE5BVE1vVkY5aDlPd3ZXN3Q1YWdrUDluODR1cUJIOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762946996),
('JAXZeKUvyLUS2JanFrMszf7ppEVDlRIVOqXAwhPo', NULL, '23.81.231.179', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUE1ZcU1QUHVFRHZsblNLOGR6dGk5Qlg0Z2xHeUJGQ1JJR3FhVksyMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762206386),
('jwMWy05IE9mFbLfgRYiEsGOqMX9C85E4oOw5OuHL', NULL, '85.208.96.200', 'Mozilla/5.0 (compatible; SemrushBot/7~bl; +http://www.semrush.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRHB4VVhCd1JhNmJXa0dNaVJrekRKRGxDM3JJWGR6dkYyczAwZHozaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762033241),
('K3Uz0swZZrt6vSjJUQLEtoRa6KuhmNsGYS4PGZe8', NULL, '182.253.128.3', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTW9mdXVaZEF5SGhEOU11cHZ6YW5aYnBlOVdDTFBaa1pUR1VUcHZuayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vcGFyaXZhYXIuYXBwLmNheGlzLmNhL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761762024),
('khu4Tj9HnZEeY6yCQV6zAb6yuiu5Y89ecvCrDbma', NULL, '165.231.211.250', 'Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:114.0) Gecko/20100101 Firefox/114.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSmpHWHJQMll2VTBxMmVyYUo5eERUS1FNNkg1QVNNMDVOVzZ4Uk1FZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763268809),
('KOcFRdk6mPiz08E5slklnGDVdwS3ZESJWiVlt2J6', NULL, '43.157.150.69', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN21aRHRncFFzT3hjWDM5djZVWUFCTGlsUGliclhxOGhTeUdGWWY2dCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763359510),
('lrchOvDjJW8FjMxmkO3RPRrkfm1yDRa26VnqrIRV', NULL, '141.98.11.115', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 11_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTmpIVzBxanJldzBsaWdYRktjRTFvSDc2bURxd2x4eFd4U3VVTzZ5TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761527323),
('M1ar4N1Lz6FzolU84Eqcehs2SUrHWeq9CnAePQPX', NULL, '66.132.153.138', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRldLMnh5Rk1rZXdaV0VNTHl4bjhnV1FHREkwOHdKVlhxbUJkaWhLTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9tYWlsLnBhcml2YWFyLmFwcC9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1764195620),
('m5kNjhTg7tQHXqw4HZQTjp4oX8Dmq1Rrfa3ibGlv', NULL, '43.135.172.89', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiclY5SjAyWjFSTWM0SDlQejdWNzJXZzNRb3R0NXFsNUdxQ1JrVldmNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1764616196),
('mCCenv2kQk3dJ3eXemFlhaPNnBJK19jvPUkTZACv', NULL, '173.239.214.127', 'Mozilla/5.0 (X11; Linux x86_64; rv:105.0) Gecko/20100101 Firefox/105.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRGw5UTNzVE5NQUtVRGQwS2N1VzVrcDJxSFhDc2FXY2RMR2hKWlc3ayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761465709),
('Mg6j6dxxZnomN9pcqI68nM3RXvg2k5CNCZHxcYTc', NULL, '196.196.253.62', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVhENFU0WW9kWVNyM1NCb05Pa2VJbW9zaFQ0OGdYZnFMSkdodnRkdyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764664755),
('MrMnFMuYx1qSKxU8cg4MyTNLMsBxmkh4J5XL0y2K', NULL, '43.153.113.127', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2hHOW5sNHlSSW5jWDRCZmVTa3NzYm1hZzNsS0VmN3ZhOXQxSlFYQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763529645),
('MSygNYAhdkZYZpKnvi9PvsSDSHODpUCUwmGDuaF8', NULL, '212.30.33.175', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/106.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN2RyeURIMEZZT2hVVEd4MlBKdEkyekZ4YzlWUTNQMXhmc0daRW1sOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763131661),
('mW7CCgWowuadVRkLLGsBeVKO8EcDennc106RFSFU', NULL, '212.30.33.162', 'Mozilla/5.0 (X11; Linux x86_64; rv:105.0) Gecko/20100101 Firefox/105.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibHhiclBZRmlVZ3NUQUhlajlkbzdPa2poZkFacXQydmNLRVJUcWtYdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763131674),
('N7mZHUZWIGgxDFKARvEylfmjh8kjT5Vg9R0YxfpH', NULL, '27.115.124.113', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_0) AppleWebKit/535.11 (KHTML, like Gecko) Chrome/17.0.963.56 Safari/535.11', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVmxvN2ROYk04d3k1SGtPZEh6VFdXUDh4N25uMWZSWjRFM2lWQ09tbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763855342),
('O1aJBeEoeg2hIpMbAM29VHYP163ep3KN4EDxYN23', NULL, '162.142.125.212', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZTVGUmg4aFJYd0VQamNyR1IyWFBXRWFtRlhadUh6ZXBDaW4yWkZCUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vbWFpbC5wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764195901),
('O2U1PhXc8oigOvvnWd2D0STG6oUgOC7Li6qK7Su1', NULL, '74.7.227.23', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; GPTBot/1.2; +https://openai.com/gptbot)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOW9uOUp6SDRVR1pPZlNGeHM4Z3FtV0g1UjRibTJLbkVhU2R0Rk9sZyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vd3d3LnBhcml2YWFyLmFwcC5jYXhpcy5jYS9wdWJsaWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1761970111),
('ogzYXJujYiOi1sI4atpNh1oOpaBiCE7UL9XFlGTf', NULL, '144.76.32.236', 'Mozilla/5.0 (compatible; BLEXBot/1.0; +https://help.seranking.com/en/blex-crawler)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTmdONUdGSXUwWExhVVNSQkhhRlFDc2Y1ZVBieklVVGNBbHRvNW1qNiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763668617),
('pp8GHvDD4k02EFz4QCfiqGQI17MkMciyfOOz3JVD', NULL, '81.181.104.146', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibXRjc05VSDRLM0hwMFc0aTNpT1hzazNtZ1BnNlJQQ1pDV3o4TUxuRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763187426),
('pvYP1oYWnCm5J7EEl973bV6o6lo0jmvrvtcCkzCF', NULL, '129.226.93.214', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZE9NMnRDQkw5N05lQVJSaWZFS2hxSTQ4TzRpSFJnOXVadXBHRHRsSiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762262393),
('QcxZW3KbTsd8d9xe3B9vxu7sOjH8BCLI6annomcP', NULL, '88.216.103.130', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1264.71', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidm1PZzVKOHY5ZW9BeEI1bjNlWGpmMkp3amF5eFV4RjhoMXU3aGw1TSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763748612),
('QI1Guws3oDBMxAp1DhpPuQ6OUqcD1mlcy2q8MKiK', NULL, '23.94.155.143', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.4 Safari/605.1.15', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT1hqRWdDSlg4aFdnUGpkbGh5aTEyOWJYQVhWQUFsMEczcHBBSUlyZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761620045),
('qRJ3kBFucE8zBhmRrTS7tDzZpDs9lN9iYOdCxYZW', NULL, '107.174.148.110', 'Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:114.0) Gecko/20100101 Firefox/114.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidGRCaWhIcU0zMjFrMlBHbGFiQ1h3VjN5TFRUeFlNMjJJa3pCa3V3OSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762830622),
('qW1eoLv0HMAwcV2kQJpSO6QhClBreAhbYmmwQTPz', NULL, '43.157.22.57', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ3ppeUZQOWNSaVlYdjYySTdMNG1mSnJEdGxDSEg5NFlmVmRLQ2NTUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762704990),
('rKk2Tsug0bn2q5buQhYcYj6UocGsfhkWWeB3djOl', NULL, '167.94.146.48', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoienp4ak5TN1luNktuWm8wU3piQkZ6blBTODVaTUJ6T0s2dTdVT3F0ciI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1764612762),
('rLDvrafe6Ogk07pJqaJa7MwXFypf9WyzHjCksivD', NULL, '43.131.26.226', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiN0JncGx2TXRSVDlKT3FGN0licU1xZFJFTWJhV2pmMWxKWDlGWTZOaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763107505),
('ROC9pcmF1XDO2YZnnbnwDRa6hqnizW9a8rgb5xcT', NULL, '193.36.220.20', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 OPR/89.0.4447.51', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM3l5VG9VREtIckU0eEQ3b21jQnd6SkJMR3BiSG5jeTRSRFRVZ2xUUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1764432245),
('Sivzdxff6QhvNyF8wJABjuplu6r7AJnv9lxM8QqC', NULL, '185.220.101.49', 'Mozilla/5.0 (Linux; Android 8.0.0; AGS2-W09) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSVlCNzZYUW0zSXlhSk9GZHViRWRCSlRTNHpsTG8zanE4aFN0aWxjcCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761526622),
('u0PluKs7tPUMMw7hKnXDMCz680EbSqfqo86M91Cd', NULL, '167.94.138.180', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM1o0VWRCYVl2eGc5TFdqSXlYclRvMm9DTjJod3M0UFlyYkhPa3VtUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761939448),
('uH9tzCJjU6o7YfS4T5DN4QuCgRPlP69IGDoeTV6F', NULL, '43.153.15.51', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia1g1MjhyN1dLQlRaZkw2S0pyVFJ6OWNSSzA5NzBOVjdLeURnWTRhdCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1764215354),
('uienezXr1CKsibQTEBRP6U3sceXCyFA79TUkgfis', NULL, '65.108.2.171', 'Mozilla/5.0 (compatible; MJ12bot/v1.4.8; http://mj12bot.com/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmlCNEtkVUE0TkhBaVF6VUdlTTUwdEZQUWZ2RHBYY1l5R29iM2cyUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762727338),
('V36BBliMd51WEHHWruwgcvy2YUeMzQ42fb2uNG1n', NULL, '88.99.193.224', 'serpstatbot/2.1 (advanced backlink tracking bot; https://serpstatbot.com/; abuse@serpstatbot.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVkdjYWtKc0M2YjhYTENLN2pPWG55NzRPQXFVTG0yR2FmMERmN1JQYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1763156294),
('WDbcHFD50hWMKFbIpi2y8LGi7CgEceFH3CyWlfjb', NULL, '167.114.139.249', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaElUUkowSk90RXpnek13a1F1aUM3U3EyN3gya2picFo3VkhWUUkwaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762702987),
('WG7jHHkdCHxC457qge9BLULdkrZrZ2sgvbKSbmc5', NULL, '182.253.128.3', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUjVlT0NHS0JqdWNHc3padjNjV0dBVU5NalBSdnhIa2w0cDNCZFdPcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1761761909),
('wQMSjKCEDzkpjK1etmZS16d7KE14ZiLFsJFMoCbI', NULL, '167.94.146.62', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHBOQjJneXJueWZ1UFVTSVE0bmtsSEE3TWNRUXc2bEFhZVdCWGt5cSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vbWFpbC5wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762023384),
('WQOGdlm9sN35zZyveyysMGP2Syli89efzKC0OXnz', NULL, '104.167.25.152', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZDNuMHIzbXJ0S0NzZWI0UEpXU3JTR3I4dWJzWU4wOWszN1p2WTZRWiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763880949),
('WuySFgLtL6d4VtnGQaRwWDTv7xsuiQ45OyceUgnJ', NULL, '43.157.149.188', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibjFMb3VJVmVqbmlOYzhpejZYN2V2ZXV4VFQyVUhEejNQM2pFRjFhTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763995990),
('X7QTytJ4fABfBNaOVOKCwWGckjMcmofdynR6b6qG', NULL, '43.130.12.43', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQXNFWmw1N05LamtEVHVsS096RFc1ZUFVbGpqbGhEUGJ5RU1WQkFyMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762260087),
('XLQd5J8s0qWiNmZaPGwyDSxmtll8toxh3Nv98QQs', NULL, '188.213.202.117', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 YaBrowser/22.7.0 Yowser/2.5 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWnJ2dUh5MmNIemo4UGZ1YldRTjVXUXdlcXZ0TFhiRlpXVkNteFI5VyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1761494975),
('y1Ewq3ejqXrSA1n9aWoCAl8hrYtHA1eK89hUljgo', NULL, '151.240.45.88', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVVExZmNXamxDSWFQTTZCVEpDV2ZQUTlNVUFYdWNLd2RQZU15NlVyUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1762492201),
('y1tQc7wTHu0UbuLDkUrC4hK3zi1Yei9JsV5a2eJK', NULL, '43.166.1.243', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTW1OeGFsSnM3ZUM4cFZ0S2l6UlhiVGlCZ0UyUWo2UkI4aEtqNTRMTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucGFyaXZhYXIuYXBwL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762703759),
('yDwRHqjKlUwjTK1NKR3fj8olyNVb9blfzq3BAd71', NULL, '206.168.34.41', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidWpDR04wOXNmNWZ2WlpOSUUzT1VCbEl3cVozMEhBaWU4ME9hcHdhMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vbWFpbC5wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763233861),
('yzKU3crHpTAfcA8M5HOZjcUQzmYatqV4RtzMQ9yj', NULL, '167.94.146.63', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNG5GRHhHZWRFN3dVS0hqd2lpZjk0ZU1GZUJaOW9WN001M0pQMmxERiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vbWFpbC5wYXJpdmFhci5hcHAvcHVibGljIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1763430100),
('z8H7NV3wSUfBJuKQcCT9A5bILoeaWH69L4ZOUvov', NULL, '162.142.125.122', 'Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaVAzZkR3UFkxYmhxcUhqVVl5ZmREVVhYVU1zVXY0bG5SckFtV1cxbSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHBzOi8vcGFyaXZhYXIuYXBwLmNheGlzLmNhL3B1YmxpYyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1762002050);

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

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `Tag_Id` bigint UNSIGNED NOT NULL,
  `Tag_Name` varchar(255) COLLATE utf8mb4_unicode_ci 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 `tags`
--

INSERT INTO `tags` (`Tag_Id`, `Tag_Name`, `created_at`, `updated_at`) VALUES
(1, 'Student', '2025-04-16 07:51:11', '2025-04-16 07:51:11'),
(2, 'Job Seeker', '2025-04-16 07:51:25', '2025-04-16 07:51:25'),
(3, 'Entrepreneur', '2025-04-16 07:51:51', '2025-04-16 07:51:51'),
(4, 'Senior', '2025-04-16 07:52:06', '2025-04-16 07:52:06'),
(5, 'Married', '2025-04-16 07:52:14', '2025-04-16 07:52:14'),
(6, 'Unmarried', '2025-04-16 07:52:26', '2025-04-16 07:52:26'),
(7, 'Volunteer', '2025-04-16 07:52:36', '2025-04-16 07:52:36'),
(8, 'Donor', '2025-04-16 07:52:45', '2025-04-16 07:52:45'),
(9, 'Business', '2025-10-06 09:02:48', '2025-10-06 09:03:23');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `additional_people`
--
ALTER TABLE `additional_people`
  ADD PRIMARY KEY (`id`),
  ADD KEY `additional_people_be_id_foreign` (`BE_Id`);

--
-- Indexes for table `book_events`
--
ALTER TABLE `book_events`
  ADD PRIMARY KEY (`BE_Id`),
  ADD KEY `book_events_e_id_foreign` (`E_Id`),
  ADD KEY `book_events_u_id_foreign` (`U_Id`);

--
-- Indexes for table `cash_collections`
--
ALTER TABLE `cash_collections`
  ADD PRIMARY KEY (`Cash_ID`),
  ADD KEY `cash_collections_send_id_foreign` (`send_id`),
  ADD KEY `cash_collections_receive_id_foreign` (`receive_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`Cat_id`),
  ADD KEY `categories_u_id_foreign` (`U_ID`);

--
-- Indexes for table `celebration`
--
ALTER TABLE `celebration`
  ADD PRIMARY KEY (`N_Id`),
  ADD KEY `celebration_u_id_foreign` (`U_Id`);

--
-- Indexes for table `com_packages`
--
ALTER TABLE `com_packages`
  ADD PRIMARY KEY (`Com_P_Id`),
  ADD KEY `com_packages_u_id_foreign` (`U_Id`);

--
-- Indexes for table `condolences`
--
ALTER TABLE `condolences`
  ADD PRIMARY KEY (`N_Id`),
  ADD KEY `condolences_u_id_foreign` (`U_Id`);

--
-- Indexes for table `discount_masters`
--
ALTER TABLE `discount_masters`
  ADD PRIMARY KEY (`D_Id`),
  ADD KEY `discount_masters_dt_id_foreign` (`DT_Id`),
  ADD KEY `discount_masters_dvt_id_foreign` (`DVT_Id`);

--
-- Indexes for table `discount_types`
--
ALTER TABLE `discount_types`
  ADD PRIMARY KEY (`DT_Id`);

--
-- Indexes for table `dis_val_types`
--
ALTER TABLE `dis_val_types`
  ADD PRIMARY KEY (`DVT_Id`);

--
-- Indexes for table `donates`
--
ALTER TABLE `donates`
  ADD PRIMARY KEY (`Do_id`),
  ADD KEY `donates_u_id_foreign` (`U_ID`),
  ADD KEY `donates_d_id_foreign` (`D_id`);

--
-- Indexes for table `donations`
--
ALTER TABLE `donations`
  ADD PRIMARY KEY (`D_id`),
  ADD KEY `donations_u_id_foreign` (`U_ID`),
  ADD KEY `donations_cat_id_foreign` (`Cat_id`);

--
-- Indexes for table `duration_types`
--
ALTER TABLE `duration_types`
  ADD PRIMARY KEY (`DT_Id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`E_Id`),
  ADD KEY `events_u_id_foreign` (`U_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 `gallary`
--
ALTER TABLE `gallary`
  ADD PRIMARY KEY (`CE_Id`),
  ADD KEY `gallary_u_id_foreign` (`U_Id`);

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

--
-- Indexes for table `job_applications`
--
ALTER TABLE `job_applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `job_applications_u_id_foreign` (`U_Id`),
  ADD KEY `job_applications_job_id_foreign` (`Job_Id`);

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

--
-- Indexes for table `marketplaces`
--
ALTER TABLE `marketplaces`
  ADD PRIMARY KEY (`M_Id`),
  ADD KEY `marketplaces_u_id_foreign` (`U_Id`);

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

--
-- Indexes for table `notices`
--
ALTER TABLE `notices`
  ADD PRIMARY KEY (`N_Id`),
  ADD KEY `notices_u_id_foreign` (`U_Id`);

--
-- Indexes for table `package_discount`
--
ALTER TABLE `package_discount`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_discount_packageid_foreign` (`PackageId`),
  ADD KEY `package_discount_d_id_foreign` (`D_Id`);

--
-- Indexes for table `package_features`
--
ALTER TABLE `package_features`
  ADD PRIMARY KEY (`Package_Fea_Id`);

--
-- Indexes for table `package_feature_pivot`
--
ALTER TABLE `package_feature_pivot`
  ADD PRIMARY KEY (`id`),
  ADD KEY `package_feature_pivot_packageid_foreign` (`PackageId`),
  ADD KEY `package_feature_pivot_package_fea_id_foreign` (`Package_Fea_Id`);

--
-- Indexes for table `package_masters`
--
ALTER TABLE `package_masters`
  ADD PRIMARY KEY (`PackageId`),
  ADD KEY `package_masters_dt_id_foreign` (`DT_Id`),
  ADD KEY `package_masters_pvt_id_foreign` (`PVT_Id`);

--
-- Indexes for table `price_masters`
--
ALTER TABLE `price_masters`
  ADD PRIMARY KEY (`PT_Id`);

--
-- Indexes for table `price_type_values`
--
ALTER TABLE `price_type_values`
  ADD PRIMARY KEY (`PVT_Id`),
  ADD KEY `price_type_values_pt_id_foreign` (`PT_Id`);

--
-- Indexes for table `role_masters`
--
ALTER TABLE `role_masters`
  ADD PRIMARY KEY (`Role_Id`);

--
-- Indexes for table `schedule_demos`
--
ALTER TABLE `schedule_demos`
  ADD PRIMARY KEY (`sche_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 `tags`
--
ALTER TABLE `tags`
  ADD PRIMARY KEY (`Tag_Id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `additional_people`
--
ALTER TABLE `additional_people`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `book_events`
--
ALTER TABLE `book_events`
  MODIFY `BE_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `cash_collections`
--
ALTER TABLE `cash_collections`
  MODIFY `Cash_ID` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `Cat_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `celebration`
--
ALTER TABLE `celebration`
  MODIFY `N_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `com_packages`
--
ALTER TABLE `com_packages`
  MODIFY `Com_P_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `condolences`
--
ALTER TABLE `condolences`
  MODIFY `N_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `discount_masters`
--
ALTER TABLE `discount_masters`
  MODIFY `D_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `discount_types`
--
ALTER TABLE `discount_types`
  MODIFY `DT_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `dis_val_types`
--
ALTER TABLE `dis_val_types`
  MODIFY `DVT_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `donates`
--
ALTER TABLE `donates`
  MODIFY `Do_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `donations`
--
ALTER TABLE `donations`
  MODIFY `D_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `duration_types`
--
ALTER TABLE `duration_types`
  MODIFY `DT_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `E_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

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

--
-- AUTO_INCREMENT for table `gallary`
--
ALTER TABLE `gallary`
  MODIFY `CE_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `job_applications`
--
ALTER TABLE `job_applications`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `marketplaces`
--
ALTER TABLE `marketplaces`
  MODIFY `M_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=77;

--
-- AUTO_INCREMENT for table `notices`
--
ALTER TABLE `notices`
  MODIFY `N_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `package_discount`
--
ALTER TABLE `package_discount`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `package_features`
--
ALTER TABLE `package_features`
  MODIFY `Package_Fea_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `package_feature_pivot`
--
ALTER TABLE `package_feature_pivot`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `package_masters`
--
ALTER TABLE `package_masters`
  MODIFY `PackageId` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `price_masters`
--
ALTER TABLE `price_masters`
  MODIFY `PT_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `price_type_values`
--
ALTER TABLE `price_type_values`
  MODIFY `PVT_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `role_masters`
--
ALTER TABLE `role_masters`
  MODIFY `Role_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `schedule_demos`
--
ALTER TABLE `schedule_demos`
  MODIFY `sche_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `tags`
--
ALTER TABLE `tags`
  MODIFY `Tag_Id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `additional_people`
--
ALTER TABLE `additional_people`
  ADD CONSTRAINT `additional_people_be_id_foreign` FOREIGN KEY (`BE_Id`) REFERENCES `book_events` (`BE_Id`) ON DELETE CASCADE;

--
-- Constraints for table `book_events`
--
ALTER TABLE `book_events`
  ADD CONSTRAINT `book_events_e_id_foreign` FOREIGN KEY (`E_Id`) REFERENCES `events` (`E_Id`) ON DELETE CASCADE,
  ADD CONSTRAINT `book_events_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `cash_collections`
--
ALTER TABLE `cash_collections`
  ADD CONSTRAINT `cash_collections_receive_id_foreign` FOREIGN KEY (`receive_id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE,
  ADD CONSTRAINT `cash_collections_send_id_foreign` FOREIGN KEY (`send_id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `categories`
--
ALTER TABLE `categories`
  ADD CONSTRAINT `categories_u_id_foreign` FOREIGN KEY (`U_ID`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `celebration`
--
ALTER TABLE `celebration`
  ADD CONSTRAINT `celebration_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `com_packages`
--
ALTER TABLE `com_packages`
  ADD CONSTRAINT `com_packages_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `condolences`
--
ALTER TABLE `condolences`
  ADD CONSTRAINT `condolences_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `discount_masters`
--
ALTER TABLE `discount_masters`
  ADD CONSTRAINT `discount_masters_dt_id_foreign` FOREIGN KEY (`DT_Id`) REFERENCES `discount_types` (`DT_Id`) ON DELETE CASCADE,
  ADD CONSTRAINT `discount_masters_dvt_id_foreign` FOREIGN KEY (`DVT_Id`) REFERENCES `dis_val_types` (`DVT_Id`) ON DELETE CASCADE;

--
-- Constraints for table `donates`
--
ALTER TABLE `donates`
  ADD CONSTRAINT `donates_d_id_foreign` FOREIGN KEY (`D_id`) REFERENCES `donations` (`D_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `donates_u_id_foreign` FOREIGN KEY (`U_ID`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `donations`
--
ALTER TABLE `donations`
  ADD CONSTRAINT `donations_cat_id_foreign` FOREIGN KEY (`Cat_id`) REFERENCES `categories` (`Cat_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `donations_u_id_foreign` FOREIGN KEY (`U_ID`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `events`
--
ALTER TABLE `events`
  ADD CONSTRAINT `events_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `gallary`
--
ALTER TABLE `gallary`
  ADD CONSTRAINT `gallary_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `jobs`
--
ALTER TABLE `jobs`
  ADD CONSTRAINT `jobs_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `job_applications`
--
ALTER TABLE `job_applications`
  ADD CONSTRAINT `job_applications_job_id_foreign` FOREIGN KEY (`Job_Id`) REFERENCES `jobs` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `job_applications_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `marketplaces`
--
ALTER TABLE `marketplaces`
  ADD CONSTRAINT `marketplaces_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `notices`
--
ALTER TABLE `notices`
  ADD CONSTRAINT `notices_u_id_foreign` FOREIGN KEY (`U_Id`) REFERENCES `user_masters` (`U_Id`) ON DELETE CASCADE;

--
-- Constraints for table `package_discount`
--
ALTER TABLE `package_discount`
  ADD CONSTRAINT `package_discount_d_id_foreign` FOREIGN KEY (`D_Id`) REFERENCES `discount_masters` (`D_Id`) ON DELETE SET NULL,
  ADD CONSTRAINT `package_discount_packageid_foreign` FOREIGN KEY (`PackageId`) REFERENCES `package_masters` (`PackageId`) ON DELETE CASCADE;
COMMIT;

