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

START TRANSACTION;



--
-- Database: `u995891310_ast_org`
--

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

--
-- Table structure for table `admin_notifications`
--

CREATE TABLE `admin_notifications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` varchar(100) NOT NULL COMMENT 'form_submission, payment_received, contact_message, withdrawal_request, kyc_submitted, new_user, application_approved, application_rejected',
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `icon` varchar(100) DEFAULT 'heroicon-o-bell',
  `color` varchar(20) DEFAULT 'info' COMMENT 'info, success, warning, danger',
  `url` varchar(500) DEFAULT NULL COMMENT 'URL to redirect on click',
  `notifiable_type` varchar(255) DEFAULT NULL COMMENT 'App\\Models\\User etc',
  `notifiable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'extra context data' CHECK (json_valid(`data`)),
  `is_read` tinyint(1) NOT NULL DEFAULT 0,
  `read_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 `admin_notifications`
--

INSERT INTO `admin_notifications` (`id`, `type`, `title`, `message`, `icon`, `color`, `url`, `notifiable_type`, `notifiable_id`, `data`, `is_read`, `read_at`, `created_at`, `updated_at`) VALUES
(1, 'new_user', 'New User Registered', 'Atharvaveda Construction Private Limited just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 4, '{\"email\":\"vermajitenderguita3r@gmail.com\"}', 0, NULL, '2026-02-26 01:10:24', '2026-02-26 01:10:24'),
(2, 'new_user', 'New User Registered', 'Atharvaveda Construction Private Limited just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 5, '{\"email\":\"vermajitenderg5uitar@gmail.com\"}', 0, NULL, '2026-02-26 01:13:48', '2026-02-26 01:13:48'),
(3, 'new_user', 'New User Registered', 'Atharvaveda Construction Private Limited just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 6, '{\"email\":\"vermadfggtar@gmail.com\"}', 0, NULL, '2026-02-26 01:14:39', '2026-02-26 01:14:39'),
(4, 'form_submission', 'New Form Submission', 'New application received from Atharvaveda Construction Private Limited', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 2, '{\"name\":\"Atharvaveda Construction Private Limited\",\"email\":\"vermadfggtar@gmail.com\"}', 0, NULL, '2026-02-26 01:14:39', '2026-02-26 01:14:39'),
(5, 'new_user', 'New User Registered', 'Atharvaveda Construction Private Limited just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 7, '{\"email\":\"ver4564derguitar@gmail.com\"}', 0, NULL, '2026-02-26 01:23:16', '2026-02-26 01:23:16'),
(6, 'form_submission', 'New Form Submission', 'New application received from Atharvaveda Construction Private Limited', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 3, '{\"name\":\"Atharvaveda Construction Private Limited\",\"email\":\"ver4564derguitar@gmail.com\"}', 0, NULL, '2026-02-26 01:23:16', '2026-02-26 01:23:16'),
(7, 'new_user', 'New User Registered', 'adsdasd just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 8, '{\"email\":\"asdasd@adsfsadas.com\"}', 0, NULL, '2026-02-26 06:44:38', '2026-02-26 06:44:38'),
(8, 'form_submission', 'New Form Submission', 'New application received from adsdasd', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 4, '{\"name\":\"adsdasd\",\"email\":\"asdasd@adsfsadas.com\"}', 0, NULL, '2026-02-26 06:44:38', '2026-02-26 06:44:38'),
(9, 'new_user', 'New User Registered', 'ATHARVAVEDA WORK just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 9, '{\"email\":\"atharvavedawork@gmail.com\"}', 0, NULL, '2026-02-26 08:58:41', '2026-02-26 08:58:41'),
(10, 'form_submission', 'New Form Submission', 'New application received from ATHARVAVEDA WORK', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 5, '{\"name\":\"ATHARVAVEDA WORK\",\"email\":\"atharvavedawork@gmail.com\"}', 0, NULL, '2026-02-26 08:58:41', '2026-02-26 08:58:41'),
(11, 'withdrawal_request', 'Withdrawal Request', '₹1000.00 withdrawal requested by admin', 'heroicon-o-arrow-up-tray', 'warning', '/admin/withdrawals', 'App\\Models\\Withdrawal', 1, '{\"amount\":\"1000.00\"}', 0, NULL, '2026-02-26 12:08:42', '2026-02-26 12:08:42'),
(12, 'new_user', 'New User Registered', 'Ram just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 30, '{\"email\":\"connect@atharvaveda.in\"}', 0, NULL, '2026-03-03 12:06:08', '2026-03-03 12:06:08'),
(13, 'form_submission', 'New Form Submission', 'New application received from Ram', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 29, '{\"name\":\"Ram\",\"email\":\"connect@atharvaveda.in\"}', 0, NULL, '2026-03-03 12:06:10', '2026-03-03 12:06:10'),
(14, 'contact_message', 'New Contact Message', 'Message from Jitender Verma: jlkjlkjlkjlkjas lkjaslkjslakj lkajs ;asl j;als ;lask ;alsk ;lask ;aslk ;lask ;al...', 'heroicon-o-envelope', 'info', '/admin/notifications/notification-center', NULL, NULL, '{\"name\":\"Jitender Verma\",\"email\":\"atharvavedavnts@gmail.com\",\"phone\":\"08351939692\",\"subject\":\"Sign-up confirmation\",\"message\":\"jlkjlkjlkjlkjas lkjaslkjslakj lkajs ;asl j;als ;lask ;alsk ;lask ;aslk ;lask ;alsk ;lask sa\"}', 0, NULL, '2026-03-03 12:12:58', '2026-03-03 12:12:58'),
(15, 'contact_message', 'New Contact Message', 'Message from asdasd: asssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss', 'heroicon-o-envelope', 'info', '/admin/notifications/notification-center', NULL, NULL, '{\"name\":\"asdasd\",\"email\":\"vermajitenderguitar@gmail.com\",\"phone\":\"asdas\",\"subject\":\"dasdasd\",\"message\":\"asssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss\"}', 0, NULL, '2026-03-03 13:10:19', '2026-03-03 13:10:19'),
(16, 'new_user', 'New User Registered', 'Travyam just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 31, '{\"email\":\"travyam@atharvaveda.org\"}', 0, NULL, '2026-03-03 22:25:35', '2026-03-03 22:25:35'),
(17, 'form_submission', 'New Form Submission', 'New application received from Travyam', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 30, '{\"name\":\"Travyam\",\"email\":\"travyam@atharvaveda.org\"}', 0, NULL, '2026-03-03 22:25:35', '2026-03-03 22:25:35'),
(18, 'new_user', 'New User Registered', 'atharvaveda vnts just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 32, '{\"email\":\"rannsenaw@gmail.com\"}', 0, NULL, '2026-03-03 23:27:56', '2026-03-03 23:27:56'),
(19, 'form_submission', 'New Form Submission', 'New application received from atharvaveda vnts', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 31, '{\"name\":\"atharvaveda vnts\",\"email\":\"rannsenaw@gmail.com\"}', 0, NULL, '2026-03-03 23:27:56', '2026-03-03 23:27:56'),
(20, 'withdrawal_request', 'Withdrawal Request', '₹600.00 withdrawal requested by Admin User', 'heroicon-o-arrow-up-tray', 'warning', '/admin/withdrawals', 'App\\Models\\Withdrawal', 2, '{\"amount\":\"600.00\"}', 0, NULL, '2026-03-04 04:26:00', '2026-03-04 04:26:00'),
(21, 'contact_message', 'New Contact Message', 'Message from Atharvaveda Construction Private Limited: aSSSSSSSSSSSSS  A sA S as A              as ds fsd fsd f dsf sd fsdfsdfsdf', 'heroicon-o-envelope', 'info', '/admin/notifications/notification-center', NULL, NULL, '{\"name\":\"Atharvaveda Construction Private Limited\",\"email\":\"vermajitenderguitar@gmail.com\",\"phone\":\"08351939692\",\"subject\":\"Sign-up confirmation\",\"message\":\"aSSSSSSSSSSSSS  A sA S as A              as ds fsd fsd f dsf sd fsdfsdfsdf\"}', 0, NULL, '2026-03-04 13:07:53', '2026-03-04 13:07:53'),
(22, 'new_user', 'New User Registered', 'Test User 6BZUS just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 33, '{\"email\":\"test.6bzus@example.com\"}', 0, NULL, '2026-03-04 13:14:38', '2026-03-04 13:14:38'),
(23, 'new_user', 'New User Registered', 'Palvi Thakur just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 34, '{\"email\":\"payalthakurpayalthakur07@gmail.com\"}', 0, NULL, '2026-03-06 06:26:59', '2026-03-06 06:26:59'),
(24, 'form_submission', 'New Form Submission', 'New application received from Palvi Thakur', 'heroicon-o-document-text', 'info', '/admin/career-applications', 'stdClass', 32, '{\"name\":\"Palvi Thakur\",\"email\":\"payalthakurpayalthakur07@gmail.com\"}', 0, NULL, '2026-03-06 06:26:59', '2026-03-06 06:26:59'),
(25, 'new_user', 'New User Registered', 'Sanjeev just registered on the platform', 'heroicon-o-user-plus', 'success', '/admin/users', 'App\\Models\\User', 35, '{\"email\":\"sanjeev@shunya.me\"}', 0, NULL, '2026-03-08 15:50:15', '2026-03-08 15:50:15'),
(26, 'contact_message', 'New Contact Message', 'Message from Jayrn Smith: Hi, it’s Jayrn.\r\n\r\nYou are about to master Magnetic Marketing—the system where c...', 'heroicon-o-envelope', 'info', '/admin/notifications/notification-center', NULL, NULL, '{\"name\":\"Jayrn Smith\",\"email\":\"jerald.shaw@outlook.com\",\"phone\":\"7149864586\",\"subject\":\"How to Stop Chasing Leads and Start Attracting Them\",\"message\":\"Hi, it\\u2019s Jayrn.\\r\\n\\r\\nYou are about to master Magnetic Marketing\\u2014the system where customers hunt you down, and you never have to \\u201cget slapped\\u201d by the exhaustion of cold prospecting again. \\r\\n\\r\\nThis methodology is built upon Dan Kennedy\\u2019s 34-year proven \\u201cMagnetic Marketing\\u201d system\\u2014a strategic machine that has generated over $65 million in sales across 200 different niches. \\r\\n\\r\\nThe final result is a business that operates in a \\u201ccompetitive vacuum,\\u201d insulating you from price-shopping and the sting of rejection. \\r\\n\\r\\nHowever, before you can add new strategies, you must perform an aggressive removal of the strategic waste and \\u201cexcess equipment\\u201d currently sabotaging your growth.\\r\\n\\r\\nLearn More: https:\\/\\/marketersmentor.com\\/attracting-buyers.php?refer=atharvaveda.in\\r\\n\\r\\nJayrn\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\nUnsubscribe: \\r\\nhttps:\\/\\/marketersmentor.com\\/unsubscribe.php?d=atharvaveda.in\"}', 0, NULL, '2026-03-09 12:40:55', '2026-03-09 12:40:55');

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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `razorpay_order_id` varchar(255) DEFAULT NULL,
  `razorpay_payment_id` varchar(255) DEFAULT NULL,
  `razorpay_signature` varchar(255) DEFAULT NULL,
  `type` enum('student','job') NOT NULL,
  `status` enum('pending','paid','approved','rejected') NOT NULL DEFAULT 'pending',
  `referral_code` varchar(255) DEFAULT NULL,
  `is_organic` tinyint(1) NOT NULL DEFAULT 0,
  `form_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`form_data`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `applications`
--

INSERT INTO `applications` (`id`, `application_id`, `user_id`, `amount`, `razorpay_order_id`, `razorpay_payment_id`, `razorpay_signature`, `type`, `status`, `referral_code`, `is_organic`, `form_data`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'AV-699B55D4C09A9', 3, NULL, NULL, NULL, NULL, 'job', 'approved', NULL, 1, NULL, '2026-02-22 13:45:32', '2026-02-24 22:55:24', NULL),
(2, 'AV-WZLYSN7D', 6, NULL, NULL, NULL, NULL, 'job', 'pending', '365436346', 0, '{\"full_name\":\"Atharvaveda Construction Private Limited\",\"email\":\"vermadfggtar@gmail.com\",\"phone\":\"+918351455492\",\"dob\":\"2026-02-20\",\"address\":\"Krishna Vihar Colony , near triveni public school\\r\\nVPO Taruwala\",\"language\":\"fdgdf\",\"qualification\":\"gdfg\",\"work_experience\":\"dfgdf\",\"skills\":\"gdf\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-02-26 01:14:39', '2026-02-26 01:14:39', NULL),
(3, 'AV-5LE9AARX', 7, NULL, NULL, NULL, NULL, 'job', 'pending', '456456456', 0, '{\"full_name\":\"Atharvaveda Construction Private Limited\",\"email\":\"ver4564derguitar@gmail.com\",\"phone\":\"+91835156492\",\"dob\":\"2026-02-25\",\"address\":\"Krishna Vihar Colony , near triveni public school\\r\\nVPO Taruwala\",\"language\":\"fgd\",\"qualification\":\"dfdf\",\"work_experience\":\"gdfg\",\"skills\":\"dfgdf\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-02-26 01:23:16', '2026-02-26 01:23:16', NULL),
(4, 'AV-IKSIQFNB', 8, NULL, NULL, NULL, NULL, 'job', 'pending', '3243244553', 0, '{\"full_name\":\"adsdasd\",\"email\":\"asdasd@adsfsadas.com\",\"phone\":\"324234234\",\"dob\":\"2026-02-20\",\"address\":\"dsfsdf\",\"language\":\"sdf\",\"qualification\":\"sdfsd\",\"work_experience\":\"sdffsdf\",\"skills\":\"dsfsdf\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-02-26 06:44:38', '2026-02-26 06:44:38', NULL),
(5, 'AV-K7AGRCRD', 9, NULL, NULL, NULL, NULL, 'job', 'pending', '9034639692', 0, '{\"full_name\":\"ATHARVAVEDA WORK\",\"email\":\"atharvavedawork@gmail.com\",\"phone\":\"+918351939692\",\"dob\":\"2026-02-26\",\"address\":\"Krishna Vihar\",\"language\":\"sdf\",\"qualification\":\"dsfsd\",\"work_experience\":\"dsf\",\"skills\":\"sdfdsf\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-02-26 08:58:41', '2026-02-26 08:58:41', NULL),
(6, 'AV-QOG9G7IU', 1, 340.00, NULL, NULL, NULL, 'job', 'approved', NULL, 1, '{\"full_name\":\"admin\",\"email\":\"admin@atharvaveda.org\",\"phone\":\"9941219144\",\"dob\":\"1998-02-26\",\"address\":\"Dummy Address, Block D, City 48\",\"language\":\"Sanskrit\",\"qualification\":\"B.Sc.\",\"work_experience\":\"11 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-21 12:03:28', '2026-02-26 12:03:28', NULL),
(7, 'AV-MI6N3AHF', 4, 340.00, NULL, NULL, NULL, 'student', 'pending', NULL, 1, '{\"full_name\":\"Atharvaveda Construction Private Limited\",\"email\":\"vermajitenderguita3r@gmail.com\",\"phone\":\"9821766003\",\"dob\":\"2003-02-26\",\"address\":\"Dummy Address, Block S, City 24\",\"language\":\"Sanskrit\",\"qualification\":\"B.Sc.\",\"work_experience\":\"1 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-28 12:03:28', '2026-02-26 12:03:28', NULL),
(8, 'AV-9JCZ67AA', 5, 340.00, NULL, NULL, NULL, 'student', 'approved', NULL, 1, '{\"full_name\":\"Atharvaveda Construction Private Limited\",\"email\":\"vermajitenderg5uitar@gmail.com\",\"phone\":\"9348102420\",\"dob\":\"1991-02-26\",\"address\":\"Dummy Address, Block G, City 34\",\"language\":\"English\",\"qualification\":\"M.A.\",\"work_experience\":\"11 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-20 12:03:28', '2026-02-26 12:03:28', NULL),
(9, 'AV-0JRXHNFP', 10, 340.00, NULL, NULL, NULL, 'job', 'approved', 'DBNQ9OKW', 0, '{\"full_name\":\"Rajesh Kumar Sharma\",\"email\":\"rajesh.sharma@test.dummy\",\"phone\":\"9558096533\",\"dob\":\"1988-02-26\",\"address\":\"Dummy Address, Block D, City 6\",\"language\":\"Sanskrit\",\"qualification\":\"M.B.A.\",\"work_experience\":\"6 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-17 12:03:28', '2026-02-26 12:03:28', NULL),
(10, 'AV-URGHB821', 11, 340.00, NULL, NULL, NULL, 'student', 'pending', 'DBNQ9OKW', 0, '{\"full_name\":\"Priya Devi Singh\",\"email\":\"priya.singh@test.dummy\",\"phone\":\"9849678325\",\"dob\":\"1981-02-26\",\"address\":\"Dummy Address, Block R, City 22\",\"language\":\"Marathi\",\"qualification\":\"M.B.A.\",\"work_experience\":\"6 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-20 12:03:28', '2026-02-26 12:03:28', NULL),
(11, 'AV-YKH6WZWU', 12, 340.00, NULL, NULL, NULL, 'student', 'approved', 'DBNQ9OKW', 0, '{\"full_name\":\"Amit Verma Patel\",\"email\":\"amit.verma@test.dummy\",\"phone\":\"9869549069\",\"dob\":\"1991-02-26\",\"address\":\"Dummy Address, Block Y, City 45\",\"language\":\"Marathi\",\"qualification\":\"B.Sc.\",\"work_experience\":\"9 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-16 12:03:28', '2026-02-26 12:03:28', NULL),
(12, 'AV-Z7WHB6IJ', 13, 340.00, NULL, NULL, NULL, 'job', 'approved', 'AMRSNQTX', 0, '{\"full_name\":\"Sunita Rani Gupta\",\"email\":\"sunita.rani@test.dummy\",\"phone\":\"9332546914\",\"dob\":\"1981-02-26\",\"address\":\"Dummy Address, Block G, City 15\",\"language\":\"Hindi\",\"qualification\":\"Ph.D\",\"work_experience\":\"0 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-19 12:03:28', '2026-02-26 12:03:28', NULL),
(13, 'AV-OKSQ4XPE', 14, 340.00, NULL, NULL, NULL, 'job', 'paid', 'AMRSNQTX', 0, '{\"full_name\":\"Mohan Lal Tiwari\",\"email\":\"mohan.tiwari@test.dummy\",\"phone\":\"9192774824\",\"dob\":\"2001-02-26\",\"address\":\"Dummy Address, Block P, City 22\",\"language\":\"Hindi\",\"qualification\":\"B.Tech\",\"work_experience\":\"7 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-26 12:03:28', '2026-02-26 12:03:28', NULL),
(14, 'AV-Q8QJ0UPH', 15, 340.00, NULL, NULL, NULL, 'student', 'paid', 'AMRSNQTX', 0, '{\"full_name\":\"Kavita Joshi Mishra\",\"email\":\"kavita.joshi@test.dummy\",\"phone\":\"9980626471\",\"dob\":\"1999-02-26\",\"address\":\"Dummy Address, Block L, City 18\",\"language\":\"Hindi\",\"qualification\":\"B.A.\",\"work_experience\":\"0 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-16 12:03:28', '2026-02-26 12:03:28', NULL),
(15, 'AV-AB6MIVMO', 16, 340.00, NULL, NULL, NULL, 'job', 'pending', 'RDAA7Y90', 0, '{\"full_name\":\"Deepak Mishra Pandey\",\"email\":\"deepak.mishra@test.dummy\",\"phone\":\"9766847313\",\"dob\":\"2000-02-26\",\"address\":\"Dummy Address, Block V, City 5\",\"language\":\"English\",\"qualification\":\"B.Sc.\",\"work_experience\":\"11 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-04 12:03:28', '2026-02-26 12:03:28', NULL),
(16, 'AV-EIXHJXHP', 17, 340.00, NULL, NULL, NULL, 'student', 'pending', 'RDAA7Y90', 0, '{\"full_name\":\"Anita Kumari Yadav\",\"email\":\"anita.kumari@test.dummy\",\"phone\":\"9703591652\",\"dob\":\"1988-02-26\",\"address\":\"Dummy Address, Block K, City 29\",\"language\":\"English\",\"qualification\":\"M.B.A.\",\"work_experience\":\"0 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-19 12:03:28', '2026-02-26 12:03:28', NULL),
(17, 'AV-YZT93YNR', 18, 340.00, NULL, NULL, NULL, 'student', 'approved', 'RDAA7Y90', 0, '{\"full_name\":\"Suresh Prasad Dubey\",\"email\":\"suresh.prasad@test.dummy\",\"phone\":\"9314474436\",\"dob\":\"2000-02-26\",\"address\":\"Dummy Address, Block M, City 25\",\"language\":\"English\",\"qualification\":\"B.Sc.\",\"work_experience\":\"2 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-03 12:03:28', '2026-02-26 12:03:28', NULL),
(18, 'AV-6MQW08SA', 19, 340.00, NULL, NULL, NULL, 'job', 'approved', 'JWHRJVP7', 0, '{\"full_name\":\"Neha Agarwal Sharma\",\"email\":\"neha.agarwal@test.dummy\",\"phone\":\"9499121181\",\"dob\":\"2002-02-26\",\"address\":\"Dummy Address, Block U, City 22\",\"language\":\"Hindi\",\"qualification\":\"B.Tech\",\"work_experience\":\"2 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-22 12:03:28', '2026-02-26 12:03:28', NULL),
(19, 'AV-1EKQ1ATD', 20, 340.00, NULL, NULL, NULL, 'student', 'paid', 'JWHRJVP7', 0, '{\"full_name\":\"Vikram Singh Yadav\",\"email\":\"vikram.yadav@test.dummy\",\"phone\":\"9499838004\",\"dob\":\"2001-02-26\",\"address\":\"Dummy Address, Block E, City 6\",\"language\":\"Hindi\",\"qualification\":\"Ph.D\",\"work_experience\":\"2 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-14 12:03:28', '2026-02-26 12:03:28', NULL),
(20, 'AV-LKWCBIYB', 21, 340.00, NULL, NULL, NULL, 'job', 'approved', 'BIZLWBLH', 0, '{\"full_name\":\"Ramesh Chandra Tiwari\",\"email\":\"ramesh.tiwari@test.dummy\",\"phone\":\"9767450147\",\"dob\":\"1989-02-26\",\"address\":\"Dummy Address, Block P, City 1\",\"language\":\"Sanskrit\",\"qualification\":\"M.B.A.\",\"work_experience\":\"4 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-13 12:03:28', '2026-02-26 12:03:28', NULL),
(21, 'AV-AL9QMISS', 22, 340.00, NULL, NULL, NULL, 'student', 'approved', 'BIZLWBLH', 0, '{\"full_name\":\"Geeta Devi Patel\",\"email\":\"geeta.patel@test.dummy\",\"phone\":\"9175238530\",\"dob\":\"1983-02-26\",\"address\":\"Dummy Address, Block A, City 8\",\"language\":\"Sanskrit\",\"qualification\":\"B.Sc.\",\"work_experience\":\"0 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-30 12:03:28', '2026-02-26 12:03:28', NULL),
(22, 'AV-KTK555NA', 23, 340.00, NULL, NULL, NULL, 'job', 'paid', '1JHQV98N', 0, '{\"full_name\":\"Arun Kumar Pandey\",\"email\":\"arun.pandey@test.dummy\",\"phone\":\"9606237101\",\"dob\":\"1987-02-26\",\"address\":\"Dummy Address, Block S, City 44\",\"language\":\"Hindi\",\"qualification\":\"Ph.D\",\"work_experience\":\"2 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-24 12:03:28', '2026-02-26 12:03:28', NULL),
(23, 'AV-OWMCOAXD', 24, 340.00, NULL, NULL, NULL, 'student', 'approved', '1JHQV98N', 0, '{\"full_name\":\"Pooja Sharma Gupta\",\"email\":\"pooja.sharma@test.dummy\",\"phone\":\"9998607331\",\"dob\":\"2003-02-26\",\"address\":\"Dummy Address, Block S, City 27\",\"language\":\"Hindi\",\"qualification\":\"B.Sc.\",\"work_experience\":\"10 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-21 12:03:28', '2026-02-26 12:03:28', NULL),
(24, 'AV-IM5ZRHY1', 25, 340.00, NULL, NULL, NULL, 'job', 'approved', '9ZUD0XKA', 0, '{\"full_name\":\"Sanjay Dubey Mishra\",\"email\":\"sanjay.dubey@test.dummy\",\"phone\":\"9488799953\",\"dob\":\"1998-02-26\",\"address\":\"Dummy Address, Block Y, City 43\",\"language\":\"Sanskrit\",\"qualification\":\"B.Sc.\",\"work_experience\":\"3 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-02-05 12:03:28', '2026-02-26 12:03:28', NULL),
(25, 'AV-5IL8BIRX', 26, 340.00, NULL, NULL, NULL, 'student', 'approved', '9ZUD0XKA', 0, '{\"full_name\":\"Meena Kumari Singh\",\"email\":\"meena.kumari@test.dummy\",\"phone\":\"9468434413\",\"dob\":\"1990-02-26\",\"address\":\"Dummy Address, Block Q, City 2\",\"language\":\"Marathi\",\"qualification\":\"M.B.A.\",\"work_experience\":\"7 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-31 12:03:28', '2026-02-26 12:03:28', NULL),
(26, 'AV-I39L1PZK', 27, 340.00, NULL, NULL, NULL, 'job', 'paid', 'FX2JUYVL', 0, '{\"full_name\":\"Rakesh Gupta Verma\",\"email\":\"rakesh.gupta@test.dummy\",\"phone\":\"9933622807\",\"dob\":\"1994-02-26\",\"address\":\"Dummy Address, Block W, City 3\",\"language\":\"Sanskrit\",\"qualification\":\"B.Tech\",\"work_experience\":\"5 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-15 12:03:28', '2026-02-26 12:03:28', NULL),
(27, 'AV-ESKZOL3Y', 28, 340.00, NULL, NULL, NULL, 'job', 'approved', 'FX2JUYVL', 0, '{\"full_name\":\"Shanti Devi Sharma\",\"email\":\"shanti.devi@test.dummy\",\"phone\":\"9652091013\",\"dob\":\"1995-02-26\",\"address\":\"Dummy Address, Block W, City 46\",\"language\":\"Hindi\",\"qualification\":\"M.A.\",\"work_experience\":\"3 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-21 12:03:28', '2026-02-26 12:03:28', NULL),
(28, 'AV-LPTMCB0M', 29, 340.00, NULL, NULL, NULL, 'student', 'pending', 'X6CSAQU0', 0, '{\"full_name\":\"Bharat Kumar Mishra\",\"email\":\"bharat.mishra@test.dummy\",\"phone\":\"9218889408\",\"dob\":\"1983-02-26\",\"address\":\"Dummy Address, Block Z, City 41\",\"language\":\"English\",\"qualification\":\"B.Tech\",\"work_experience\":\"10 years\",\"skills\":\"Communication, Management, Leadership\"}', '2026-01-17 12:03:28', '2026-02-26 12:03:28', NULL),
(29, 'AV-OW8BJZEG', 30, NULL, NULL, NULL, NULL, 'job', 'pending', NULL, 1, '{\"full_name\":\"Ram\",\"email\":\"connect@atharvaveda.in\",\"phone\":\"222222222\",\"dob\":\"2026-03-03\",\"address\":\"2222\",\"language\":\"2222\",\"qualification\":\"22\",\"work_experience\":\"22\",\"skills\":\"22\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-03-03 12:06:10', '2026-03-03 12:06:10', NULL),
(30, 'AV-OXNV5D7Y', 31, NULL, NULL, NULL, NULL, 'job', 'pending', NULL, 1, '{\"full_name\":\"Travyam\",\"email\":\"travyam@atharvaveda.org\",\"phone\":\"4324234\",\"dob\":\"2026-03-04\",\"address\":\"dasdasdas\",\"language\":\"asdd\",\"qualification\":\"asdas\",\"work_experience\":\"dsad\",\"skills\":\"asdasd\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-03-03 22:25:35', '2026-03-03 22:25:35', NULL),
(31, 'AV-AG1RVNJY', 32, NULL, NULL, NULL, NULL, 'job', 'pending', 'C0HFW8VY', 0, '{\"full_name\":\"atharvaveda vnts\",\"email\":\"rannsenaw@gmail.com\",\"phone\":\"8888888888\",\"dob\":\"2026-03-11\",\"address\":\"Krishna Vihar\",\"language\":\"Hindi, English, Bengali, Telugu, Marathi\",\"qualification\":\"below_matric\",\"work_experience\":\"2years\",\"skills\":\"Communication, Leadership, Computer Basics, MS Office\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-03-03 23:27:56', '2026-03-03 23:27:56', NULL),
(32, 'AV-L7GEGSXC', 34, NULL, NULL, NULL, NULL, 'job', 'paid', NULL, 1, '{\"full_name\":\"Palvi Thakur\",\"email\":\"payalthakurpayalthakur07@gmail.com\",\"phone\":\"8219700318\",\"dob\":\"2006-10-28\",\"address\":\"Nahan\",\"language\":\"Hindi\",\"qualification\":\"secondary\",\"work_experience\":\"fresher\",\"skills\":\"Other\",\"institution\":null,\"course\":null,\"year_of_study\":null,\"resume_path\":null}', '2026-03-06 06:26:59', '2026-03-06 06:58:30', NULL);

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

--
-- Table structure for table `audit_logs`
--

CREATE TABLE `audit_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `model_type` varchar(255) DEFAULT NULL,
  `model_id` bigint(20) UNSIGNED DEFAULT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `ip_address` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `career_applications`
--

CREATE TABLE `career_applications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(15) NOT NULL,
  `dob` date DEFAULT NULL,
  `address` text DEFAULT NULL,
  `type` enum('job','student') DEFAULT 'student',
  `position` varchar(255) DEFAULT NULL,
  `qualification` varchar(255) DEFAULT NULL,
  `experience` varchar(255) DEFAULT NULL,
  `skills` text DEFAULT NULL,
  `resume_pdf` varchar(255) DEFAULT NULL,
  `resume_path` varchar(255) DEFAULT NULL,
  `ref_code` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `payment_status` enum('pending','success','failed') DEFAULT 'pending',
  `razorpay_order_id` varchar(255) DEFAULT NULL,
  `razorpay_payment_id` varchar(255) DEFAULT NULL,
  `razorpay_signature` varchar(255) DEFAULT NULL,
  `paid_at` timestamp NULL DEFAULT NULL,
  `application_status` enum('submitted','reviewed','approved','rejected') DEFAULT 'submitted',
  `notes` text DEFAULT NULL,
  `rejected_reason` varchar(255) DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `rejected_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;

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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `district_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `application_id` bigint(20) UNSIGNED NOT NULL,
  `payment_id` bigint(20) UNSIGNED NOT NULL,
  `level` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','credited','held','cancelled') NOT NULL DEFAULT 'pending',
  `credited_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commissions`
--

INSERT INTO `commissions` (`id`, `user_id`, `application_id`, `payment_id`, `level`, `amount`, `status`, `credited_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 9, 3, 1, 500.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(2, 1, 11, 4, 1, 500.00, 'credited', '2026-02-22 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(3, 10, 12, 5, 1, 500.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(4, 1, 12, 5, 2, 200.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(5, 10, 13, 6, 1, 500.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(6, 1, 13, 6, 2, 200.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(7, 10, 14, 7, 1, 500.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(8, 1, 14, 7, 2, 200.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(9, 11, 17, 8, 1, 500.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(10, 1, 17, 8, 2, 200.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(11, 12, 18, 9, 1, 500.00, 'credited', '2026-02-26 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(12, 1, 18, 9, 2, 200.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(13, 12, 19, 10, 1, 500.00, 'credited', '2026-02-22 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(14, 1, 19, 10, 2, 200.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(15, 13, 20, 11, 1, 500.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(16, 10, 20, 11, 2, 200.00, 'credited', '2026-02-26 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(17, 1, 20, 11, 3, 150.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(18, 13, 21, 12, 1, 500.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(19, 10, 21, 12, 2, 200.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(20, 1, 21, 12, 3, 150.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(21, 14, 22, 13, 1, 500.00, 'credited', '2026-02-26 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(22, 10, 22, 13, 2, 200.00, 'credited', '2026-02-22 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(23, 1, 22, 13, 3, 150.00, 'credited', '2026-02-22 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(24, 14, 23, 14, 1, 500.00, 'credited', '2026-02-26 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(25, 10, 23, 14, 2, 200.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(26, 1, 23, 14, 3, 150.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(27, 16, 24, 15, 1, 500.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(28, 11, 24, 15, 2, 200.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(29, 1, 24, 15, 3, 150.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(30, 16, 25, 16, 1, 500.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(31, 11, 25, 16, 2, 200.00, 'credited', '2026-02-25 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(32, 1, 25, 16, 3, 150.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(33, 21, 26, 17, 1, 500.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(34, 13, 26, 17, 2, 200.00, 'credited', '2026-02-21 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(35, 10, 26, 17, 3, 150.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(36, 1, 26, 17, 4, 100.00, 'credited', '2026-02-26 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(37, 21, 27, 18, 1, 500.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(38, 13, 27, 18, 2, 200.00, 'credited', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(39, 10, 27, 18, 3, 150.00, 'credited', '2026-02-22 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(40, 1, 27, 18, 4, 100.00, 'credited', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL);

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

--
-- Table structure for table `commission_rules`
--

CREATE TABLE `commission_rules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `level` int(11) NOT NULL,
  `percentage` decimal(5,2) NOT NULL,
  `fixed_amount` decimal(10,2) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `version_id` bigint(20) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `commission_rules`
--

INSERT INTO `commission_rules` (`id`, `level`, `percentage`, `fixed_amount`, `is_active`, `version_id`, `created_at`, `updated_at`) VALUES
(1, 1, 0.00, 500.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(2, 2, 0.00, 200.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(3, 3, 0.00, 150.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(4, 4, 0.00, 100.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(5, 5, 0.00, 100.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(6, 6, 0.00, 80.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(7, 7, 0.00, 80.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(8, 8, 0.00, 80.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(9, 9, 0.00, 60.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(10, 10, 0.00, 60.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(11, 11, 0.00, 50.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42'),
(12, 12, 0.00, 40.00, 1, NULL, '2026-02-25 18:53:42', '2026-02-25 18:53:42');

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

--
-- Table structure for table `commission_rule_versions`
--

CREATE TABLE `commission_rule_versions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_current` tinyint(1) NOT NULL DEFAULT 0,
  `effective_from` 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;

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

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `state_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

--
-- Table structure for table `fraud_flags`
--

CREATE TABLE `fraud_flags` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` enum('multiple_accounts','suspicious_referral','ip_abuse','bank_duplicate','spike') NOT NULL,
  `description` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `status` enum('open','investigating','resolved','false_positive') NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ip_blacklist`
--

CREATE TABLE `ip_blacklist` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip_address` varchar(45) NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `blocked_by` bigint(20) UNSIGNED DEFAULT NULL,
  `expires_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;

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

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

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

--
-- Dumping data for table `jobs`
--

INSERT INTO `jobs` (`id`, `queue`, `payload`, `attempts`, `reserved_at`, `available_at`, `created_at`) VALUES
(1, 'default', '{\"uuid\":\"649401a4-085d-432b-b918-128c5d94f988\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:92:\\\"Atharvaveda Construction Private Limited just registered — <a href=\'\\/admin\\/users\'>View<\\/a>\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"a97fc96e-627d-4224-9e13-f972be1b4b09\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772088279, 1772088279),
(2, 'default', '{\"uuid\":\"b7198a85-29f5-44b3-ac19-70eeb0151fda\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:116:\\\"Application received from Atharvaveda Construction Private Limited — <a href=\'\\/admin\\/career-applications\'>View<\\/a>\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"90b63049-863d-4c74-92e7-94f0798dd1d5\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772088279, 1772088279),
(3, 'default', '{\"uuid\":\"47a44152-d63d-450e-aa63-b873479f67ea\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:56:\\\"Atharvaveda Construction Private Limited just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"31554a9b-245c-4eb8-af7a-c08ad646be9f\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772088796, 1772088796),
(4, 'default', '{\"uuid\":\"372e2fd5-f43c-4a6c-b4e3-ea293884a439\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:66:\\\"Application received from Atharvaveda Construction Private Limited\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"b7df932b-b51f-411b-bb72-22346bf55c4f\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772088796, 1772088796),
(5, 'default', '{\"uuid\":\"0b7cd91c-efac-47cd-88a2-9016d52349fa\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:23:\\\"adsdasd just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"8c242c52-c506-4433-b4c5-bcb5ba19031c\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772108078, 1772108078),
(6, 'default', '{\"uuid\":\"7c0a19be-cdd5-4465-b325-a5b9d1fba6c0\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:33:\\\"Application received from adsdasd\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"cd75090c-af19-4b3d-997d-502fc9da2071\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772108078, 1772108078),
(7, 'default', '{\"uuid\":\"65335285-6ea8-4c34-a40a-b7bdf314e7d0\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:32:\\\"ATHARVAVEDA WORK just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"f1a69b45-66a5-408a-8c09-b38ad10e58b6\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772116121, 1772116121),
(8, 'default', '{\"uuid\":\"e19116ee-13bb-4ab7-b421-3667ccf1feb1\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:42:\\\"Application received from ATHARVAVEDA WORK\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"94f555f8-8418-4d23-9905-c1f23fd30433\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772116121, 1772116121),
(9, 'default', '{\"uuid\":\"cdc75a5a-778c-4a0c-a7db-baf9d6573138\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:29:\\\"₹1000.00 requested by admin\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-arrow-up-tray\\\";s:9:\\\"iconColor\\\";s:7:\\\"warning\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:18:\\\"Withdrawal Request\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"eec9e584-40aa-4293-b44a-7dd17315e129\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772127524, 1772127524),
(10, 'default', '{\"uuid\":\"0090ddcc-7ba7-4b33-8b4e-a40e8a6e02ae\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:19:\\\"Ram just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"ac71e2c1-c5f4-4539-851f-5bb1bb5d19e3\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772559370, 1772559370),
(11, 'default', '{\"uuid\":\"4f64b7f8-789f-494c-ad30-75fc92ba0008\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:29:\\\"Application received from Ram\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"4d15c9cc-34a0-44d6-a49f-43e2fb8174bf\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772559370, 1772559370),
(12, 'default', '{\"uuid\":\"3302f0bd-4c9c-4887-b140-f1deb83aea2d\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:112:\\\"Message from Jitender Verma: jlkjlkjlkjlkjas lkjaslkjslakj lkajs ;asl j;als ;lask ;alsk ;lask ;aslk ;lask ;al...\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:19:\\\"heroicon-o-envelope\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Contact Message\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"9bcca29e-7504-4bd2-872b-25f6b00c946c\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772559778, 1772559778),
(13, 'default', '{\"uuid\":\"2f808714-0fbf-4c36-b574-dbbab7154c16\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:85:\\\"Message from asdasd: asssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:19:\\\"heroicon-o-envelope\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Contact Message\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"ec2dc8e1-a615-4398-bcbb-8c3671f1e7db\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772563219, 1772563219),
(14, 'default', '{\"uuid\":\"ae34885f-9da6-4e80-b3f7-3314c842ea79\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:23:\\\"Travyam just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"8c825c51-e51c-49cd-9b4a-34837af3a419\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772596535, 1772596535),
(15, 'default', '{\"uuid\":\"92a2f1af-72a1-41fa-8019-a8ed5ab46b46\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:33:\\\"Application received from Travyam\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"46576c3b-406f-4e77-9889-7727f1e1218c\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772596535, 1772596535),
(16, 'default', '{\"uuid\":\"d3b1f5fe-078e-4931-850f-2c45ea86e924\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:32:\\\"atharvaveda vnts just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"fbc01370-c368-4a05-b240-fbcba01f5576\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772600276, 1772600276),
(17, 'default', '{\"uuid\":\"84183727-edd5-4638-8af2-76aa1f35702b\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:42:\\\"Application received from atharvaveda vnts\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"4605ded8-6b2a-4064-9157-61e3ab505899\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772600276, 1772600276),
(18, 'default', '{\"uuid\":\"18a1541c-b97c-4564-93c6-845692a05ed2\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:33:\\\"₹600.00 requested by Admin User\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-arrow-up-tray\\\";s:9:\\\"iconColor\\\";s:7:\\\"warning\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:18:\\\"Withdrawal Request\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"3738a311-ab1c-4b5d-9252-b6ec0c032bec\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772618162, 1772618162),
(19, 'default', '{\"uuid\":\"2c67c6b3-fa8c-4f89-ab71-1398175917df\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:129:\\\"Message from Atharvaveda Construction Private Limited: aSSSSSSSSSSSSS  A sA S as A              as ds fsd fsd f dsf sd fsdfsdfsdf\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:19:\\\"heroicon-o-envelope\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Contact Message\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"30238af3-6d44-47a1-a196-cd79da62ae5f\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772649475, 1772649475),
(20, 'default', '{\"uuid\":\"e59dfbbb-6b58-4016-b44a-6d08b0713b19\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:31:\\\"Test User 6BZUS just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"bc63cfd7-e74a-4f6c-8f9d-86346401ae9e\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772649878, 1772649878),
(21, 'default', '{\"uuid\":\"0c3c9e66-125c-4610-9207-63d504703b79\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:28:\\\"Palvi Thakur just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"3f41ce22-e76f-40d2-80b9-229b6dac135f\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772778419, 1772778419),
(22, 'default', '{\"uuid\":\"f7a9521f-01d5-4e3c-a410-6cc9446843ee\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:38:\\\"Application received from Palvi Thakur\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:24:\\\"heroicon-o-document-text\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Form Submission\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"4db0de27-679e-4ea1-b901-1885803c7af2\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772778419, 1772778419),
(23, 'default', '{\"uuid\":\"e892635c-0ca6-4cc8-aa90-586e91a0d5cb\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:23:\\\"Sanjeev just registered\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:20:\\\"heroicon-o-user-plus\\\";s:9:\\\"iconColor\\\";s:7:\\\"success\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New User Registered\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"6cee1008-551d-43f0-a131-7a25f39d65f0\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1772985016, 1772985016),
(24, 'default', '{\"uuid\":\"70240155-4fa8-4ba0-a85a-1572a6d79519\",\"displayName\":\"Filament\\\\Notifications\\\\DatabaseNotification\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\",\"command\":\"O:48:\\\"Illuminate\\\\Notifications\\\\SendQueuedNotifications\\\":3:{s:11:\\\"notifiables\\\";O:45:\\\"Illuminate\\\\Contracts\\\\Database\\\\ModelIdentifier\\\":5:{s:5:\\\"class\\\";s:15:\\\"App\\\\Models\\\\User\\\";s:2:\\\"id\\\";a:1:{i:0;i:1;}s:9:\\\"relations\\\";a:0:{}s:10:\\\"connection\\\";s:5:\\\"mysql\\\";s:15:\\\"collectionClass\\\";N;}s:12:\\\"notification\\\";O:43:\\\"Filament\\\\Notifications\\\\DatabaseNotification\\\":2:{s:4:\\\"data\\\";a:11:{s:7:\\\"actions\\\";a:0:{}s:4:\\\"body\\\";s:113:\\\"Message from Jayrn Smith: Hi, it’s Jayrn.\\r\\n\\r\\nYou are about to master Magnetic Marketing—the system where c...\\\";s:5:\\\"color\\\";N;s:8:\\\"duration\\\";s:10:\\\"persistent\\\";s:4:\\\"icon\\\";s:19:\\\"heroicon-o-envelope\\\";s:9:\\\"iconColor\\\";s:4:\\\"info\\\";s:6:\\\"status\\\";N;s:5:\\\"title\\\";s:19:\\\"New Contact Message\\\";s:4:\\\"view\\\";N;s:8:\\\"viewData\\\";a:0:{}s:6:\\\"format\\\";s:8:\\\"filament\\\";}s:2:\\\"id\\\";s:36:\\\"1842ae9c-b569-4e5f-be58-129565f01834\\\";}s:8:\\\"channels\\\";a:1:{i:0;s:8:\\\"database\\\";}}\"}}', 0, NULL, 1773060055, 1773060055);

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

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

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

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

--
-- Table structure for table `kyc_details`
--

CREATE TABLE `kyc_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `pan_number` varchar(255) DEFAULT NULL,
  `aadhaar_number` varchar(255) DEFAULT NULL,
  `bank_account` varchar(255) DEFAULT NULL,
  `bank_ifsc` varchar(255) DEFAULT NULL,
  `bank_name` varchar(255) DEFAULT NULL,
  `upi_id` varchar(255) DEFAULT NULL,
  `status` enum('pending','verified','rejected') NOT NULL DEFAULT 'pending',
  `pan_doc` varchar(255) DEFAULT NULL,
  `aadhaar_doc` varchar(255) DEFAULT NULL,
  `verified_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2026_02_22_070000_create_applications_table', 1),
(5, '2026_02_22_082211_create_permission_tables', 1),
(6, '2026_02_22_085700_create_commission_rule_versions_table', 1),
(7, '2026_02_22_085751_create_referrals_table', 1),
(8, '2026_02_22_085752_create_referral_snapshots_table', 1),
(9, '2026_02_22_085753_create_payments_table', 1),
(10, '2026_02_22_085754_create_commissions_table', 1),
(11, '2026_02_22_085755_create_commission_rules_table', 1),
(12, '2026_02_22_085759_create_audit_logs_table', 1),
(13, '2026_02_22_085802_create_kyc_details_table', 1),
(14, '2026_02_22_090000_create_wallets_table', 1),
(15, '2026_02_22_090010_create_wallet_transactions_table', 1),
(16, '2026_02_22_090020_create_withdrawals_table', 1),
(17, '2026_02_22_185825_create_notifications_table', 2),
(18, '2026_02_22_191847_add_razorpay_fields_to_applications_table', 3),
(19, '2026_02_23_024346_add_referral_fields_to_users_table', 4),
(20, '2026_02_23_024510_create_referral_clicks_table', 4),
(21, '2026_02_23_024511_create_referral_tree_table', 4);

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

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

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

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

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

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

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1);

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` char(36) NOT NULL,
  `type` varchar(255) NOT NULL,
  `notifiable_type` varchar(255) NOT NULL,
  `notifiable_id` bigint(20) UNSIGNED NOT NULL,
  `data` text NOT NULL,
  `read_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 `notifications`
--

INSERT INTO `notifications` (`id`, `type`, `notifiable_type`, `notifiable_id`, `data`, `read_at`, `created_at`, `updated_at`) VALUES
('2148dee8-c2b2-4f64-aaf9-a4155c2bf4ed', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 1, '{\"notification_type\":\"withdrawal_update\",\"title\":\"Withdrawal Request Submitted\",\"message\":\"\\u20b91,000 withdrawal request has been submitted. Processing: 3\\u20135 business days.\",\"url\":\"\\/dashboard\\/withdraw\"}', '2026-02-26 12:09:02', '2026-02-26 12:08:44', '2026-02-26 12:09:02'),
('220bc7b5-52bf-42af-b04f-ae126d821b1a', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 30, '{\"notification_type\":\"form_submission\",\"title\":\"Application Received!\",\"message\":\"Your career application #AV-OW8BJZEG has been received. Please complete payment.\",\"url\":\"\\/dashboard\\/applications\"}', NULL, '2026-03-03 12:06:10', '2026-03-03 12:06:10'),
('5d165728-523e-403b-8a66-a4bd753360ec', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 1, '{\"notification_type\":\"withdrawal_update\",\"title\":\"Withdrawal Request Submitted\",\"message\":\"\\u20b9600 withdrawal request has been submitted. Processing: 3\\u20135 business days.\",\"url\":\"\\/dashboard\\/withdraw\"}', '2026-03-04 04:26:39', '2026-03-04 04:26:02', '2026-03-04 04:26:39'),
('76fc7380-dc92-46dc-a51b-1eea80c6d297', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 31, '{\"notification_type\":\"form_submission\",\"title\":\"Application Received!\",\"message\":\"Your career application #AV-OXNV5D7Y has been received. Please complete payment.\",\"url\":\"\\/dashboard\\/applications\"}', NULL, '2026-03-03 22:25:35', '2026-03-03 22:25:35'),
('90087221-1283-4f59-9872-4a5fbf8390ad', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 34, '{\"notification_type\":\"form_submission\",\"title\":\"Application Received!\",\"message\":\"Application #AV-L7GEGSXC received. Please complete payment.\",\"url\":\"\\/dashboard\\/applications\"}', NULL, '2026-03-06 06:26:59', '2026-03-06 06:26:59'),
('e812b11e-45fb-4b51-bf28-837b022643ab', 'App\\Notifications\\UserNotification', 'App\\Models\\User', 32, '{\"notification_type\":\"form_submission\",\"title\":\"Application Received!\",\"message\":\"Application #AV-AG1RVNJY received. Please complete payment.\",\"url\":\"\\/dashboard\\/applications\"}', NULL, '2026-03-03 23:27:56', '2026-03-03 23:27:56');

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

--
-- Table structure for table `notification_logs`
--

CREATE TABLE `notification_logs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `type` enum('email','sms','whatsapp','push','in_app') NOT NULL DEFAULT 'in_app',
  `title` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` enum('sent','failed','pending') NOT NULL DEFAULT 'pending',
  `sent_at` timestamp NULL DEFAULT NULL,
  `meta` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`meta`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `notification_templates`
--

CREATE TABLE `notification_templates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `type` enum('email','sms','whatsapp') NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text NOT NULL,
  `variables` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`variables`)),
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `commission_pool` decimal(10,2) NOT NULL,
  `platform_fee` decimal(10,2) NOT NULL,
  `gateway_txn_id` varchar(255) DEFAULT NULL,
  `gateway_name` varchar(255) DEFAULT NULL,
  `status` enum('pending','success','failed','refunded') NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `application_id`, `user_id`, `amount`, `commission_pool`, `platform_fee`, `gateway_txn_id`, `gateway_name`, `status`, `paid_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 6, 1, 340.00, 240.00, 100.00, 'TXN_TYXLYXMONYCK', 'razorpay', 'success', '2026-02-06 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(2, 8, 5, 340.00, 240.00, 100.00, 'TXN_ECNOV89UWYKN', 'razorpay', 'success', '2026-02-01 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(3, 9, 10, 340.00, 240.00, 100.00, 'TXN_R8FDFRXIYA22', 'razorpay', 'success', '2026-02-07 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(4, 11, 12, 340.00, 240.00, 100.00, 'TXN_SSEKKSKNPO16', 'razorpay', 'success', '2026-02-01 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(5, 12, 13, 340.00, 240.00, 100.00, 'TXN_YVGTLYDUNCA6', 'razorpay', 'success', '2026-02-11 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(6, 13, 14, 340.00, 240.00, 100.00, 'TXN_OKUNPDFKQABJ', 'razorpay', 'success', '2026-02-02 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(7, 14, 15, 340.00, 240.00, 100.00, 'TXN_GVENQ6SFEAKG', 'razorpay', 'success', '2026-02-23 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(8, 17, 18, 340.00, 240.00, 100.00, 'TXN_IY0RDGRG6FOD', 'razorpay', 'success', '2026-01-27 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(9, 18, 19, 340.00, 240.00, 100.00, 'TXN_YRIWE1CTGZMA', 'razorpay', 'success', '2026-02-02 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(10, 19, 20, 340.00, 240.00, 100.00, 'TXN_WZXNMUHHLIRZ', 'razorpay', 'success', '2026-01-31 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(11, 20, 21, 340.00, 240.00, 100.00, 'TXN_HIHG3QMZMXW2', 'razorpay', 'success', '2026-02-14 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(12, 21, 22, 340.00, 240.00, 100.00, 'TXN_OETB9FXQNY2N', 'razorpay', 'success', '2026-02-11 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(13, 22, 23, 340.00, 240.00, 100.00, 'TXN_YJ4NXJV6M0VK', 'razorpay', 'success', '2026-01-27 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(14, 23, 24, 340.00, 240.00, 100.00, 'TXN_OMPFDSA2YHYO', 'razorpay', 'success', '2026-02-24 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(15, 24, 25, 340.00, 240.00, 100.00, 'TXN_KFOOKOZZETGR', 'razorpay', 'success', '2026-02-19 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(16, 25, 26, 340.00, 240.00, 100.00, 'TXN_HJODFT1IGMSQ', 'razorpay', 'success', '2026-02-02 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(17, 26, 27, 340.00, 240.00, 100.00, 'TXN_PYXRMGSYNLGX', 'razorpay', 'success', '2026-02-10 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(18, 27, 28, 340.00, 240.00, 100.00, 'TXN_4LFLNEZBZCSC', 'razorpay', 'success', '2026-02-09 12:03:28', '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL);

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

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

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

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

--
-- Table structure for table `referrals`
--

CREATE TABLE `referrals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `referred_by` bigint(20) UNSIGNED DEFAULT NULL,
  `referral_code` varchar(20) NOT NULL,
  `referral_path` varchar(255) DEFAULT NULL,
  `depth` int(11) NOT NULL DEFAULT 0,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_snapshots`
--

CREATE TABLE `referral_snapshots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `application_id` bigint(20) UNSIGNED NOT NULL,
  `chain` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`chain`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `referral_tree`
--

CREATE TABLE `referral_tree` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `ancestor_id` bigint(20) UNSIGNED NOT NULL,
  `level` tinyint(3) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `descendant_id` bigint(20) UNSIGNED DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `referral_tree`
--

INSERT INTO `referral_tree` (`id`, `user_id`, `ancestor_id`, `level`, `created_at`, `updated_at`, `descendant_id`) VALUES
(1, 3, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(2, 6, 3, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(3, 6, 1, 2, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(4, 7, 3, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(5, 7, 1, 2, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(6, 8, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(7, 9, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(8, 10, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(9, 11, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(10, 12, 1, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(11, 13, 10, 1, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(12, 13, 1, 2, '2026-02-26 12:03:24', '2026-02-26 12:03:24', NULL),
(13, 14, 10, 1, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(14, 14, 1, 2, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(15, 15, 10, 1, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(16, 15, 1, 2, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(17, 16, 11, 1, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(18, 16, 1, 2, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(19, 17, 11, 1, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(20, 17, 1, 2, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(21, 18, 11, 1, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(22, 18, 1, 2, '2026-02-26 12:03:25', '2026-02-26 12:03:25', NULL),
(23, 19, 12, 1, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(24, 19, 1, 2, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(25, 20, 12, 1, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(26, 20, 1, 2, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(27, 21, 13, 1, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(28, 21, 10, 2, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(29, 21, 1, 3, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(30, 22, 13, 1, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(31, 22, 10, 2, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(32, 22, 1, 3, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(33, 23, 14, 1, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(34, 23, 10, 2, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(35, 23, 1, 3, '2026-02-26 12:03:26', '2026-02-26 12:03:26', NULL),
(36, 24, 14, 1, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(37, 24, 10, 2, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(38, 24, 1, 3, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(39, 25, 16, 1, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(40, 25, 11, 2, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(41, 25, 1, 3, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(42, 26, 16, 1, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(43, 26, 11, 2, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(44, 26, 1, 3, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(45, 27, 21, 1, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(46, 27, 13, 2, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(47, 27, 10, 3, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(48, 27, 1, 4, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(49, 28, 21, 1, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(50, 28, 13, 2, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(51, 28, 10, 3, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(52, 28, 1, 4, '2026-02-26 12:03:27', '2026-02-26 12:03:27', NULL),
(53, 29, 23, 1, '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(54, 29, 14, 2, '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(55, 29, 10, 3, '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL),
(56, 29, 1, 4, '2026-02-26 12:03:28', '2026-02-26 12:03:28', NULL);

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

--
-- Table structure for table `referral_trees`
--

CREATE TABLE `referral_trees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ancestor_id` bigint(20) UNSIGNED NOT NULL,
  `descendant_id` bigint(20) UNSIGNED NOT NULL,
  `level` tinyint(3) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

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

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'super_admin', 'web', '2026-02-22 04:55:09', '2026-02-22 04:55:09'),
(2, 'admin', 'web', '2026-02-22 04:55:09', '2026-02-22 04:55:09'),
(3, 'user', 'web', '2026-02-22 04:55:09', '2026-02-22 04:55:09'),
(4, 'staff', 'web', '2026-02-25 18:51:42', '2026-02-25 18:51:42');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('1RrG1tU1ISpK2tsmhHBOA7WE41Ham3vmFroeaeCS', NULL, '2a02:4780:11:c0de::e', 'Go-http-client/2.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNjlDckVkeWs3cm1GN1J2N2trcVo2Rkh3ekxQYk5BM3haRVk5YW42diI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773017829),
('7RwPH0arJpvIaRedgaaH5qHYuZwPPj2Cjytrc6To', NULL, '5.133.192.127', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRzJ6bTNWVTBZeG5sWEFTYks4NHNtQXdLakRBV25kOU55N2lxbXZhdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773071964),
('98l9Fo8wGTlhanqvTHUmUP1ZAEuBT5jtoJAWgZ6R', NULL, '54.92.168.219', 'Mozilla/5.0 (compatible; proximic; +https://www.comscore.com/Web-Crawler)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWHI4T0ZVQ0hhWHFGWGFzWm9hdGQxSVBGMDVkOWxzNHo2VndjVDVQMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773041384),
('a6GuPOaB9Cff30gVP3H3Bi5NqjhpGPTEXCx1mdph', NULL, '106.211.30.33', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNG5wZ3Q1V0hEM0dURnljbFZpWjlNN0Jid3FjbEFWeU94aEtqT09LOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773070772),
('AoG6QDa3KO5MhnHUzqRUVijK5W1vJhQ8RgaEiNjC', NULL, '216.73.216.191', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZzZZbjZmUGpMeHMzNkwzR1NTSVdYdllMNmZiYnRPdGlkaWFaWWVuUCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vZG9uYXRlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773055127),
('b1H8VN5A4nkWmvCvcAol02dTAoLHLeJph5Hq1Eb8', NULL, '122.173.25.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoid0lSTzRFcXc2MHNjdldlRjRmN0xDcHRCQWp5Z0pKR3FyQmFNb0t3ZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773049431),
('bsEUgESwMbS4fmTnyyFUEvMbhVUIgvUEjwAv0O9x', NULL, '66.249.66.12', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZnFTd0czN21kanR6c1VoZHRFcEhsQ1hSU0N6R0dCVHFZWGhOUU9mSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773056278),
('bvJpXcfvelQMi5c1XX681ovgPjR57rsEK5CExMFW', NULL, '2401:4900:1c6a:876f:4841:1994:392a:2be2', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiU0E2djNQbGo5eG42SFNFUWdOSnpNQTRYME1QUGdyYTE3ZGw2WWxKZSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773041495),
('BXAzy0yTZzkyKqSdvOcjD1Cz1DdDWbYyZT3o4FTm', NULL, '47.82.15.112', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZ2V2MDl4Wmh0OVR5dFBoMEZ2MFhWRDBLRERxRlV2RkdacDlQR2MzUSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY2FyZWVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773033240),
('dLWFguz0wzWbtVFjV87PMpzmwfIPk3Qhaoh4CLLc', NULL, '96.62.97.63', 'Mozilla/5.0 (X11; Linux i686) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Vivaldi/5.3.2679.68', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiV09QeENsZzFicEFXN1dMaFJmcVUydk9kZnZKTnY5aWsxZTZ2RnhCUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY29udGFjdCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1773060056),
('dXZrUITDGHSlSPAteLlMbN60tuJnlIhZB4iwddW0', NULL, '47.15.177.153', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYUJqbEVMTVduQk5zaXh6Skg0a0ZLZTg1a3dhQzVQYjJ6ejJVclJpOSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773064455),
('e5QXtoGwufaWcptGSGrU5Nds7q46ZotVZRcsVFsP', NULL, '2a03:2880:12ff:3::', 'facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiSTAxclVTdnZuREdaSGViOXMwY3k0V0ZPUFdHb3ByWjFSbHZXVElENSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY2FyZWVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773074378),
('eTn9Bm4fMRx4Aq2bxCqdQAHtAL8oaiyx4y7ajK9h', NULL, '44.250.139.223', 'Mozilla/5.0 (compatible; wpbot/1.4; +https://forms.gle/ajBaxygz9jSR8p8G9)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQTI1V2paWVBNeXh6bllySmpKRlZZY3dmR3dFWktCelNDS2JWQ3UyUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773072642),
('Fdh4CjkwR7K7Nl5LN4XmQk0a0Lu7CvA0Y8JLmKi8', NULL, '216.73.216.191', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWU1ueWM2S1dtR2FTb3RJWlM1WlQzNXMzSHJDd0JTT0J5MVNFVGxRMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773048619),
('fiZPDxwot9HzWNHBI6JUfcye14er4FVQeHVSoyan', NULL, '54.37.51.108', '{USER_AGENT}', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVFJxQWpLdW5KU2h2Ynk5UGxlUkxQM2NDYzNFd1E1SjdsOU1TdEludiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773072032),
('h4uR8lXZSPISDCiytkqsmFOmICrxqE3F0nY6imwz', NULL, '116.179.37.60', 'Mozilla/5.0 (compatible; Baiduspider-render/2.0; +http://www.baidu.com/search/spider.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaTVPWkdUYnNXNjNPWTFWem1aM3lta1BPZjBYMEV3Z0pLcU1WOG1LaSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773015703),
('hu5hhzLA8yNPkdjpHIrz2loQeApjth3gIeI4nP6F', NULL, '34.38.105.255', 'Mozilla/5.0 (compatible; CMS-Checker/1.0; +https://example.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ1lVaEVoSlVqZXdqdlJ0T2IzMHAyZHJtbWxhOU11V1pxTEJFUmQxZCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vd3d3LmF0aGFydmF2ZWRhLmluIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773055667),
('jr9cuuSeAUnuo63L5oAnuKaDs7eiMo4bTPPiuWPu', NULL, '2a03:2880:12ff:49::', 'facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibFZVUHo0R0l6WVgzQzBtd082ajE0UG90NnhkejFPam8zbkdSSEllYyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY2FyZWVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773074376),
('khX9CVVCATREG5l0KxzRSgbb9PSbEAogaw5KYc55', NULL, '2409:4090:8030:9804:c859:37f9:a43c:65bf', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNlJ0Y0hlZk1HbmNOTER1YWNMNGt2S1d3ZXA4dERBcGpyMHZ2b0dudyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHBzOi8vd3d3LmF0aGFydmF2ZWRhLmluIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773070579),
('Mx9DdnKzQ9syKBoAsHps6h9UW1qfj4NjDQnHr345', NULL, '2409:4090:e00e:c40b:8027:3aa7:4238:4088', 'Mozilla/5.0 (Android 16; Mobile; rv:148.0) Gecko/148.0 Firefox/148.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRGtmeDRKN1Z1R0Vybk54ZDZpejJvYTNCY1JPYUtrYU1icWZuanlLViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773026146),
('ncTvsBfwUWjnSDQ1FiLjcZlC6V09GF4wH9ef1UYk', NULL, '122.173.25.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZElvSjhKZklLaVRwMGtEUWZ3ZWhGc0FOUEdoTzlvQjBsa3N5M1lhNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773041112),
('Oq35H7zC1CGExnNhiWp2QR3RileQxoUPzmHhUd1Z', NULL, '66.249.66.163', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOVN6TlBmYXdqSTROR3U3aXJBZWlFdjc4VHdyQjlJdFZGZEtqNGt1cSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773053738),
('pRFtxN7DESNEbz1PSC3NynZMJFl6tLEDLXo0qyhp', NULL, '149.102.230.118', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWpkZHhCRTJCNXRZVlgxYk9xQTExaGIyano5cW5Qem5rQWtjalpycSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773071309),
('qby7QNFa0v3PNYbYHLzK7z7HyD2qBVAWnzwOYWSC', NULL, '34.226.204.186', 'Mozilla/5.0 (compatible; proximic; +https://www.comscore.com/Web-Crawler)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiek0yWmcxOWRDU0RiZENmR25yeGtPRnR1MlVqVVNneVZ1bjA1dkNUcyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773030538),
('qfRnwV3Fp5sdRvYdzbOixvg28xjoetY72XJ1ZndN', NULL, '66.249.66.6', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY1VodzNmZ3ZIRXFlSklpRk4wUExvUVdDanQxTkVoVndJUWFyTW9VYSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773051666),
('qHz8MUaTQbIYMPOGNteEejbpE8FSNIacXjHQGmom', NULL, '35.190.171.127', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/118.0.5993.90 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTjkwVjllVlR4UDRrSjJGMnF5QVhwdkhIQW5oM01yb3VQVjRESTd5MyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773010869),
('QviyVmNm1u7rb5K1Nht9X1zqkgzUZAHcrvnH9Waj', NULL, '2409:40d7:b1:3496:45f5:80b8:22f4:cecd', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiekJSSW9CeFUyVEhDWXdMWkswMlFKN0tXc0FWUnBTNFA1YXQ1UU1GSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773064450),
('RJGtRKs1T9kGk6Nwqtsixh4bHoy6Cqys1kwDd9gb', NULL, '2401:4900:1c6a:876f:d9d4:e088:a067:7b45', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNlZOOGtESkpyUUFCTFRaV2tYZ3oxeFIzTlhERVF0bDBERFFFc0RLNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773030515),
('s1VTTcoKCO7PbNNqS82FDCD5cn1VlbgqyU4Kzt0X', NULL, '122.173.25.188', 'WhatsApp/2.2606.102 W', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNVY3QmJhSlV0NnE0YmtYY0oyRERGT2NyekVQY0djTkFoYTBnZ0E0MSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773041121),
('STQHRr941dLdzfpNkWj8jmn4jAOIT2Ch7cb56SND', NULL, '220.181.108.176', 'Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiWWg5RzFtWHlmV2NDSkVvdFdNb2N6SktubVpzdXJzY1BUam9QdDh2SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTE6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vP3Nob3BkZXRhaWwlMkYzMDExODY4Nl9odG1sPSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1773044256),
('suMm0mvUfbswcNOu8TVjlI3Nu1FRE7ia3SInyhac', NULL, '212.34.153.180', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMVNDYVZieDJ6cHViaEZyVWhVYVkySG5KN1pNRkRBRTJRaGYxOXhJVCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773059587),
('sX3pgjFJYbh4kOMJpNuhbnXnUJummBQ8Wxu8AUUv', NULL, '116.179.32.215', 'Mozilla/5.0 (Linux;u;Android 4.2.2;zh-cn;) AppleWebKit/534.46 (KHTML,like Gecko) Version/5.1 Mobile Safari/10600.6.3 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRzhmWjJuemZ1YW9WZW5sSlpMRXJ4ckYxbXhSa09lSTlzR1owdGVWTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTE6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vP3Nob3BkZXRhaWwlMkYyNjk5MDExOV9odG1sPSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1773040341),
('T3VRBGOwZrVoYuhjawKogD5AruLQHlf07GMGWJkK', NULL, '54.174.58.248', 'Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) HeadlessChrome/146.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNDd5QnN4Q1lmZlpEUmlQMUw0RzI2Q3BvYmFpOGVjbjR5bGoza2dBYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773070282),
('U2EEv6LiYVc9riPAYbOL3m69DRrF4eHRmG8zyjJj', NULL, '149.102.230.118', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVGQ3REt4bThvRlo4Vm04c1F2SExtM3FOYUNRdFRuMm9USjIzNW56UiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773071305),
('uJKOHw9jCWZwKsWuWdiP9Z3uNcTd50Qol3zgPPCL', NULL, '51.161.65.37', 'Mozilla/5.0 (compatible; AhrefsBot/7.0; +http://ahrefs.com/robot/)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiYlNNbkFESVJJMFRueUFWd1lYbEVPaTdTTVRLUmIyZXF6Y29aM1ZSUiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773074240),
('uSA27CBHypEBsYmY7wfZg9CUH4ztn6eoUcc9Fe0Z', NULL, '54.174.58.253', 'Mozilla/5.0 (compatible; HubSpot Crawler; HubSpot Domain check; +https://www.hubspot.com)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiR0hIcFZ4V1R0YmZEemJzdmNjQmIxSUgyOE9ObmpnMWRSQ1lUUHRuTSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773070280),
('v3fUjq5WqLQqy7GzhRUlCRWDnNLb27Fu9EqUAu6q', NULL, '116.179.32.104', 'Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMFJ5TnFuOFJtM29yWExST3J6ZEJTVDFxQXg3bWpFSWNvUkdWallZWSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTE6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vP3Nob3BkZXRhaWwlMkYyOTM3NDAxOV9odG1sPSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1773032818),
('wcnv0kT18JWwGNOB8KliQQaqe6odoatEB0glo9Rx', NULL, '2a03:2880:12ff:70::', 'facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidEVZR0dvanRtcG1GU3oxajd5NkE3YmxpRzNjMEZWdUFibHlQd0hiQSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY2FyZWVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773074377),
('Xw0s2wSJXEBcgrNe6kHEeEm3sOHM3guQfYGhAepv', NULL, '2a03:2880:12ff:6::', 'facebookexternalhit/1.1 (+http://www.facebook.com/externalhit_uatext.php)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNWk2OXE3SVNMc0libEs5TExsNFFYRDFNSWM0RGhwU1hlc1ZQVkRvdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4vY2FyZWVyIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1773074377),
('y8r7Ek8sCsvNQ5l78Eteao6F2tfxX42A6jJuDeS7', NULL, '149.102.230.117', 'Go-http-client/1.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiODN0MmhTamNDcXJxSGNqMnhhQ0NQN3FTV1pjUjRwS1l6MnhhcG94SiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773071310),
('yat4ZWUd1TJYX6Tknu8iUbuk1S8S0nxWcfonpEjL', NULL, '122.173.25.188', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiaGtrWERKajdiWThFYU1zWVFNeGhFa0djdElBOVFYTldPbkNTbkRybSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773030364),
('ytSxx1wD50w5ui0aV5lwJOIzdsD4e5D1B85kWUnJ', NULL, '220.181.108.168', 'Mozilla/5.0 (compatible; Baiduspider/2.0; +http://www.baidu.com/search/spider.html)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieVc4SDRMVHU3aXV6VnJXTm1VSHh5YVVGTW9zelpiUk15c0V0SnNXYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjI6Imh0dHBzOi8vYXRoYXJ2YXZlZGEuaW4iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1773015700);

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

--
-- Table structure for table `states`
--

CREATE TABLE `states` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(10) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `support_tickets`
--

CREATE TABLE `support_tickets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ticket_number` varchar(20) NOT NULL,
  `category` varchar(50) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` enum('open','in_progress','resolved','closed') NOT NULL DEFAULT 'open',
  `priority` enum('low','medium','high','urgent') NOT NULL DEFAULT 'medium',
  `assigned_to` bigint(20) UNSIGNED DEFAULT NULL,
  `resolved_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;

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

--
-- Table structure for table `user_notification_settings`
--

CREATE TABLE `user_notification_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `email_application_updates` tinyint(1) DEFAULT 1,
  `email_payment_reminders` tinyint(1) DEFAULT 1,
  `email_weekly_digest` tinyint(1) DEFAULT 1,
  `email_promotional` tinyint(1) DEFAULT 0,
  `push_notifications` tinyint(1) DEFAULT 1,
  `sms_alerts` tinyint(1) DEFAULT 0,
  `theme` varchar(255) DEFAULT 'dark',
  `language` varchar(10) DEFAULT 'en',
  `timezone` varchar(64) DEFAULT 'Asia/Kolkata',
  `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 `user_notification_settings`
--

INSERT INTO `user_notification_settings` (`id`, `user_id`, `email_application_updates`, `email_payment_reminders`, `email_weekly_digest`, `email_promotional`, `push_notifications`, `sms_alerts`, `theme`, `language`, `timezone`, `created_at`, `updated_at`) VALUES
(1, 1, 0, 0, 0, 0, 0, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-26 13:27:33', '2026-02-26 13:27:48'),
(2, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:03', '2026-02-27 05:31:03'),
(3, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:11', '2026-02-27 05:31:11'),
(4, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:26', '2026-02-27 05:31:26'),
(5, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:29', '2026-02-27 05:31:29'),
(6, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:33', '2026-02-27 05:31:33'),
(7, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:34', '2026-02-27 05:31:34'),
(8, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:34', '2026-02-27 05:31:34'),
(9, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:35', '2026-02-27 05:31:35'),
(10, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:44', '2026-02-27 05:31:44'),
(11, 1, 1, 1, 1, 0, 1, 0, 'dark', 'en', 'Asia/Kolkata', '2026-02-27 05:31:57', '2026-02-27 05:31:57');

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

--
-- Table structure for table `user_settings`
--

CREATE TABLE `user_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `notif_app_updates` tinyint(1) DEFAULT 1,
  `notif_payment_reminders` tinyint(1) DEFAULT 1,
  `notif_commission_credit` tinyint(1) DEFAULT 1,
  `notif_withdrawal_update` tinyint(1) DEFAULT 1,
  `notif_weekly_digest` tinyint(1) DEFAULT 1,
  `notif_promo_emails` tinyint(1) DEFAULT 0,
  `notif_push` tinyint(1) DEFAULT 1,
  `notif_sms` tinyint(1) DEFAULT 0,
  `theme` varchar(20) DEFAULT 'light',
  `language` varchar(10) DEFAULT 'en',
  `profile_visibility` varchar(20) DEFAULT 'private',
  `data_collection` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_settings`
--

INSERT INTO `user_settings` (`id`, `user_id`, `notif_app_updates`, `notif_payment_reminders`, `notif_commission_credit`, `notif_withdrawal_update`, `notif_weekly_digest`, `notif_promo_emails`, `notif_push`, `notif_sms`, `theme`, `language`, `profile_visibility`, `data_collection`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 1, 1, 1, 0, 1, 0, 'light', 'en', 'private', 1, '2026-02-27 03:47:03', '2026-02-27 05:31:44');

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

--
-- Table structure for table `wallets`
--

CREATE TABLE `wallets` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `commission_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `withdrawable_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `hold_balance` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_earned` decimal(12,2) NOT NULL DEFAULT 0.00,
  `total_withdrawn` decimal(12,2) NOT NULL DEFAULT 0.00,
  `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 `wallets`
--

INSERT INTO `wallets` (`id`, `user_id`, `commission_balance`, `withdrawable_balance`, `hold_balance`, `total_earned`, `total_withdrawn`, `created_at`, `updated_at`) VALUES
(1, 3, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-22 22:17:12', '2026-02-22 22:17:12'),
(2, 1, 3300.00, 600.00, 3600.00, 3300.00, 0.00, '2026-02-25 13:38:47', '2026-03-04 04:26:00'),
(3, 8, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 06:44:38', '2026-02-26 06:44:38'),
(4, 9, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 08:58:41', '2026-02-26 08:58:41'),
(5, 4, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:24'),
(6, 5, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:24'),
(7, 6, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:24'),
(8, 7, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:24'),
(9, 10, 2600.00, 2600.00, 0.00, 2600.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:28'),
(10, 11, 900.00, 900.00, 0.00, 900.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:28'),
(11, 12, 1000.00, 1000.00, 0.00, 1000.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:28'),
(12, 13, 1400.00, 1400.00, 0.00, 1400.00, 0.00, '2026-02-26 12:03:24', '2026-02-26 12:03:28'),
(13, 14, 1000.00, 1000.00, 0.00, 1000.00, 0.00, '2026-02-26 12:03:25', '2026-02-26 12:03:28'),
(14, 15, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:25', '2026-02-26 12:03:25'),
(15, 16, 1000.00, 1000.00, 0.00, 1000.00, 0.00, '2026-02-26 12:03:25', '2026-02-26 12:03:28'),
(16, 17, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:25', '2026-02-26 12:03:25'),
(17, 18, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:25', '2026-02-26 12:03:25'),
(18, 19, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:26', '2026-02-26 12:03:26'),
(19, 20, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:26', '2026-02-26 12:03:26'),
(20, 21, 1000.00, 1000.00, 0.00, 1000.00, 0.00, '2026-02-26 12:03:26', '2026-02-26 12:03:28'),
(21, 22, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:26', '2026-02-26 12:03:26'),
(22, 23, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:26', '2026-02-26 12:03:26'),
(23, 24, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:27', '2026-02-26 12:03:27'),
(24, 25, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:27', '2026-02-26 12:03:27'),
(25, 26, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:27', '2026-02-26 12:03:27'),
(26, 27, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:27', '2026-02-26 12:03:27'),
(27, 28, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:27', '2026-02-26 12:03:27'),
(28, 29, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(29, 30, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-03 12:06:08', '2026-03-03 12:06:08'),
(30, 31, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-03 22:25:35', '2026-03-03 22:25:35'),
(31, 32, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-03 23:27:56', '2026-03-03 23:27:56'),
(32, 33, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-04 13:14:38', '2026-03-04 13:14:38'),
(33, 34, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-06 06:26:59', '2026-03-06 06:26:59'),
(34, 35, 0.00, 0.00, 0.00, 0.00, 0.00, '2026-03-08 15:50:15', '2026-03-08 15:50:15');

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

--
-- Table structure for table `wallet_transactions`
--

CREATE TABLE `wallet_transactions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('credit','debit','hold','release') NOT NULL,
  `source` enum('commission','withdrawal','refund','adjustment') NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `balance_after` decimal(12,2) NOT NULL,
  `reference_id` varchar(255) DEFAULT NULL,
  `note` text 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 `wallet_transactions`
--

INSERT INTO `wallet_transactions` (`id`, `wallet_id`, `user_id`, `type`, `source`, `amount`, `balance_after`, `reference_id`, `note`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-9-L1', 'Level 1 commission from application #9', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(2, 2, 1, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-11-L1', 'Level 1 commission from application #11', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(3, 9, 10, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-12-L1', 'Level 1 commission from application #12', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(4, 2, 1, 'credit', 'commission', 200.00, 1200.00, 'COMM-APP-12-L2', 'Level 2 commission from application #12', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(5, 9, 10, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-13-L1', 'Level 1 commission from application #13', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(6, 2, 1, 'credit', 'commission', 200.00, 1400.00, 'COMM-APP-13-L2', 'Level 2 commission from application #13', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(7, 9, 10, 'credit', 'commission', 500.00, 1500.00, 'COMM-APP-14-L1', 'Level 1 commission from application #14', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(8, 2, 1, 'credit', 'commission', 200.00, 1600.00, 'COMM-APP-14-L2', 'Level 2 commission from application #14', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(9, 10, 11, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-17-L1', 'Level 1 commission from application #17', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(10, 2, 1, 'credit', 'commission', 200.00, 1800.00, 'COMM-APP-17-L2', 'Level 2 commission from application #17', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(11, 11, 12, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-18-L1', 'Level 1 commission from application #18', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(12, 2, 1, 'credit', 'commission', 200.00, 2000.00, 'COMM-APP-18-L2', 'Level 2 commission from application #18', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(13, 11, 12, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-19-L1', 'Level 1 commission from application #19', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(14, 2, 1, 'credit', 'commission', 200.00, 2200.00, 'COMM-APP-19-L2', 'Level 2 commission from application #19', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(15, 12, 13, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-20-L1', 'Level 1 commission from application #20', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(16, 9, 10, 'credit', 'commission', 200.00, 1700.00, 'COMM-APP-20-L2', 'Level 2 commission from application #20', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(17, 2, 1, 'credit', 'commission', 150.00, 2350.00, 'COMM-APP-20-L3', 'Level 3 commission from application #20', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(18, 12, 13, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-21-L1', 'Level 1 commission from application #21', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(19, 9, 10, 'credit', 'commission', 200.00, 1900.00, 'COMM-APP-21-L2', 'Level 2 commission from application #21', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(20, 2, 1, 'credit', 'commission', 150.00, 2500.00, 'COMM-APP-21-L3', 'Level 3 commission from application #21', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(21, 13, 14, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-22-L1', 'Level 1 commission from application #22', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(22, 9, 10, 'credit', 'commission', 200.00, 2100.00, 'COMM-APP-22-L2', 'Level 2 commission from application #22', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(23, 2, 1, 'credit', 'commission', 150.00, 2650.00, 'COMM-APP-22-L3', 'Level 3 commission from application #22', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(24, 13, 14, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-23-L1', 'Level 1 commission from application #23', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(25, 9, 10, 'credit', 'commission', 200.00, 2300.00, 'COMM-APP-23-L2', 'Level 2 commission from application #23', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(26, 2, 1, 'credit', 'commission', 150.00, 2800.00, 'COMM-APP-23-L3', 'Level 3 commission from application #23', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(27, 15, 16, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-24-L1', 'Level 1 commission from application #24', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(28, 10, 11, 'credit', 'commission', 200.00, 700.00, 'COMM-APP-24-L2', 'Level 2 commission from application #24', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(29, 2, 1, 'credit', 'commission', 150.00, 2950.00, 'COMM-APP-24-L3', 'Level 3 commission from application #24', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(30, 15, 16, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-25-L1', 'Level 1 commission from application #25', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(31, 10, 11, 'credit', 'commission', 200.00, 900.00, 'COMM-APP-25-L2', 'Level 2 commission from application #25', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(32, 2, 1, 'credit', 'commission', 150.00, 3100.00, 'COMM-APP-25-L3', 'Level 3 commission from application #25', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(33, 20, 21, 'credit', 'commission', 500.00, 500.00, 'COMM-APP-26-L1', 'Level 1 commission from application #26', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(34, 12, 13, 'credit', 'commission', 200.00, 1200.00, 'COMM-APP-26-L2', 'Level 2 commission from application #26', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(35, 9, 10, 'credit', 'commission', 150.00, 2450.00, 'COMM-APP-26-L3', 'Level 3 commission from application #26', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(36, 2, 1, 'credit', 'commission', 100.00, 3200.00, 'COMM-APP-26-L4', 'Level 4 commission from application #26', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(37, 20, 21, 'credit', 'commission', 500.00, 1000.00, 'COMM-APP-27-L1', 'Level 1 commission from application #27', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(38, 12, 13, 'credit', 'commission', 200.00, 1400.00, 'COMM-APP-27-L2', 'Level 2 commission from application #27', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(39, 9, 10, 'credit', 'commission', 150.00, 2600.00, 'COMM-APP-27-L3', 'Level 3 commission from application #27', '2026-02-26 12:03:28', '2026-02-26 12:03:28'),
(40, 2, 1, 'credit', 'commission', 100.00, 3300.00, 'COMM-APP-27-L4', 'Level 4 commission from application #27', '2026-02-26 12:03:28', '2026-02-26 12:03:28');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `wallet_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(12,2) NOT NULL,
  `method` enum('bank','upi') NOT NULL,
  `payment_details` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`payment_details`)),
  `status` enum('pending','approved','processing','paid','rejected') NOT NULL DEFAULT 'pending',
  `admin_note` text DEFAULT NULL,
  `processed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `user_id`, `wallet_id`, `amount`, `method`, `payment_details`, `status`, `admin_note`, `processed_at`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 1, 2, 1000.00, 'upi', '\"{\\\"upi_id\\\":\\\"news.greenasia@gmail.com\\\"}\"', 'approved', 'credited UTR ', NULL, '2026-02-26 12:08:42', '2026-02-26 12:10:36', NULL),
(2, 1, 2, 600.00, 'upi', '\"{\\\"upi_id\\\":\\\"jhkjh@jhgjk\\\"}\"', 'pending', NULL, NULL, '2026-03-04 04:26:00', '2026-03-04 04:26:00', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin_notifications`
--
ALTER TABLE `admin_notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_type` (`type`),
  ADD KEY `idx_is_read` (`is_read`),
  ADD KEY `idx_created` (`created_at`);

--
-- Indexes for table `applications`
--
ALTER TABLE `applications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `applications_application_id_unique` (`application_id`),
  ADD KEY `applications_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `career_applications`
--
ALTER TABLE `career_applications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_ref_code` (`ref_code`),
  ADD KEY `idx_payment_status` (`payment_status`),
  ADD KEY `idx_application_status` (`application_status`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_district_id_foreign` (`district_id`);

--
-- Indexes for table `commissions`
--
ALTER TABLE `commissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commissions_user_id_foreign` (`user_id`),
  ADD KEY `commissions_application_id_foreign` (`application_id`),
  ADD KEY `commissions_payment_id_foreign` (`payment_id`);

--
-- Indexes for table `commission_rules`
--
ALTER TABLE `commission_rules`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commission_rules_version_id_foreign` (`version_id`);

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_state_id_foreign` (`state_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 `fraud_flags`
--
ALTER TABLE `fraud_flags`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fraud_flags_user_id_index` (`user_id`),
  ADD KEY `fraud_flags_type_index` (`type`);

--
-- Indexes for table `ip_blacklist`
--
ALTER TABLE `ip_blacklist`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `ip_blacklist_ip_address_unique` (`ip_address`);

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

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

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

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

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

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

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`);

--
-- Indexes for table `notification_logs`
--
ALTER TABLE `notification_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `notification_logs_user_id_index` (`user_id`),
  ADD KEY `notification_logs_type_index` (`type`);

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_application_id_foreign` (`application_id`),
  ADD KEY `payments_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `referrals`
--
ALTER TABLE `referrals`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referrals_referral_code_unique` (`referral_code`),
  ADD KEY `referrals_user_id_foreign` (`user_id`),
  ADD KEY `referrals_referred_by_foreign` (`referred_by`);

--
-- Indexes for table `referral_snapshots`
--
ALTER TABLE `referral_snapshots`
  ADD PRIMARY KEY (`id`),
  ADD KEY `referral_snapshots_application_id_foreign` (`application_id`);

--
-- Indexes for table `referral_tree`
--
ALTER TABLE `referral_tree`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_tree_user_id_ancestor_id_unique` (`user_id`,`ancestor_id`),
  ADD KEY `referral_tree_ancestor_id_foreign` (`ancestor_id`);

--
-- Indexes for table `referral_trees`
--
ALTER TABLE `referral_trees`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referral_trees_ancestor_descendant_unique` (`ancestor_id`,`descendant_id`),
  ADD KEY `referral_trees_ancestor_id_index` (`ancestor_id`),
  ADD KEY `referral_trees_descendant_id_index` (`descendant_id`),
  ADD KEY `referral_trees_level_index` (`level`);

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

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

--
-- Indexes for table `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 `states`
--
ALTER TABLE `states`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `support_tickets`
--
ALTER TABLE `support_tickets`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `support_tickets_ticket_number_unique` (`ticket_number`),
  ADD KEY `support_tickets_user_id_index` (`user_id`),
  ADD KEY `support_tickets_status_index` (`status`);

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

--
-- Indexes for table `user_settings`
--
ALTER TABLE `user_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_settings` (`user_id`);

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

--
-- Indexes for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `wallet_transactions_wallet_id_foreign` (`wallet_id`),
  ADD KEY `wallet_transactions_user_id_foreign` (`user_id`);

--
-- Indexes for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `withdrawals_user_id_foreign` (`user_id`),
  ADD KEY `withdrawals_wallet_id_foreign` (`wallet_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `applications`
--
ALTER TABLE `applications`
  ADD CONSTRAINT `applications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `audit_logs`
--
ALTER TABLE `audit_logs`
  ADD CONSTRAINT `audit_logs_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `commissions`
--
ALTER TABLE `commissions`
  ADD CONSTRAINT `commissions_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `commissions_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `commissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `commission_rules`
--
ALTER TABLE `commission_rules`
  ADD CONSTRAINT `commission_rules_version_id_foreign` FOREIGN KEY (`version_id`) REFERENCES `commission_rule_versions` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `kyc_details`
--
ALTER TABLE `kyc_details`
  ADD CONSTRAINT `kyc_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

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

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referrals`
--
ALTER TABLE `referrals`
  ADD CONSTRAINT `referrals_referred_by_foreign` FOREIGN KEY (`referred_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `referrals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referral_snapshots`
--
ALTER TABLE `referral_snapshots`
  ADD CONSTRAINT `referral_snapshots_application_id_foreign` FOREIGN KEY (`application_id`) REFERENCES `applications` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `referral_tree`
--
ALTER TABLE `referral_tree`
  ADD CONSTRAINT `referral_tree_ancestor_id_foreign` FOREIGN KEY (`ancestor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `referral_tree_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

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

--
-- Constraints for table `user_notification_settings`
--
ALTER TABLE `user_notification_settings`
  ADD CONSTRAINT `fk_user_notification_settings_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_settings`
--
ALTER TABLE `user_settings`
  ADD CONSTRAINT `fk_user_settings_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wallets`
--
ALTER TABLE `wallets`
  ADD CONSTRAINT `wallets_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `wallet_transactions`
--
ALTER TABLE `wallet_transactions`
  ADD CONSTRAINT `wallet_transactions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `wallet_transactions_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `withdrawals`
--
ALTER TABLE `withdrawals`
  ADD CONSTRAINT `withdrawals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `withdrawals_wallet_id_foreign` FOREIGN KEY (`wallet_id`) REFERENCES `wallets` (`id`) ON DELETE CASCADE;
COMMIT;

