-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jul 07, 2025 at 12:19 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `dhenunff_raznandanigroup` -- -- -------------------------------------------------------- -- -- Table structure for table `account_details` -- CREATE TABLE `account_details` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `account_holder_name` varchar(255) NOT NULL, `account_number` varchar(20) NOT NULL, `bank_name` varchar(255) NOT NULL, `branch_name` varchar(255) NOT NULL, `ifsc_code` varchar(20) NOT NULL, `account_type` varchar(50) NOT NULL, `pan_number` varchar(20) NOT NULL, `aadhar_number` varchar(12) NOT NULL, `transaction_password` varchar(100) NOT NULL, `bank_details_confirmation` tinyint(1) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `account_details` -- INSERT INTO `account_details` (`id`, `user_id`, `account_holder_name`, `account_number`, `bank_name`, `branch_name`, `ifsc_code`, `account_type`, `pan_number`, `aadhar_number`, `transaction_password`, `bank_details_confirmation`, `created_at`, `updated_at`) VALUES (1, 7, 'RAHUL KUMAR', '33627209189', 'STATE BANK OF INDIA', 'PUGMIL', 'SBI0014664', 'SAVING', 'DBIPK2310B', '412983454809', '$2y$12$utggYuIerTAE91Sa5QXWOuUCXtV0Nol6D2QNZobCoGsfqONiw72gq', 1, '2024-06-19 20:07:26', '2024-06-19 20:07:26'), (2, 14, 'Muskan singh', '1448703331', 'KOTAK MAHINDRA PVT LTD', 'RANCHI', 'KKBK0005635', 'Savings', 'ITRPS7282C', '905465896833', '$2y$12$5q65saA3vWPVjvCafx8Atuw.k514GuIzg/ZXZuyqVeYOB0whcAoUG', 1, '2024-06-22 01:33:51', '2025-01-09 13:43:49'), (3, 19, 'Minu verma', '6635000100020616', 'PUNJAB NATIONAL BANK', 'BADA BAZAR HAZARIBAG', 'PUNB0663500', 'savings', 'AYLPV5128M', '999623442876', '$2y$12$lFv0VtT8ytAgje4JWkLVw.sn9VuhY/C9.Vrdo3E050sCCCFOAsmH6', 1, '2024-06-30 20:43:47', '2025-01-09 13:44:03'), (4, 23, 'Pramod Kumar', '1944010051730', 'PUNJAB NATIONAL BANK', 'INDRAPURI CHOWK HAZARIBAG', 'PUNB0410700', 'Saving', 'HYGPK2664R', '975734618104', '$2y$12$vWjtxBWfQtm2O31jVlGqPuL9qnrKm9qxVx2Mbbvco3Hr0AXoepdKm', 1, '2024-07-01 19:50:51', '2025-01-09 13:45:01'), (5, 8, 'Pramod Kumar Mehta', '32042700369', 'STATE BANK OF INDIA', 'KANSAR MORE', 'SBIN0008379', 'Savings', 'BQRPM9889B', '906686235053', '$2y$12$24IwJnj.L5zZmPXWG4sET.jW9neO5/R19d80TROfI5s/tzSGVcPJG', 1, '2024-07-02 00:26:23', '2024-07-02 00:26:23'), (6, 24, 'Manoj Kumar Mehta', '486620110000338', 'BANK OF INDIA', 'PUGMIL', 'BKID0004866', 'Saving', 'DAVPM8642E', '383734436548', '$2y$12$M4JmX.My1eC4IOSogVuzHeDLXZzawYfo7seqJsI.S0I8QjAhW4HcO', 1, '2024-07-02 20:07:11', '2025-01-09 13:46:03'), (7, 25, 'NISHIKANT UPADHYAY', '00000000001', 'DENA BANK', 'HAZARIBAG', 'BKDN0911199', 'SAVINGS', 'AAPPU4444F', '200002041370', '$2y$12$gwUlGN62a23BkQfaoOT1Iux8q0XSLOvUUXstfPKGXO2PcQkqgDnXK', 1, '2024-07-03 03:03:00', '2025-01-09 13:45:56'), (8, 26, 'Dipak Jain', '20460110018149', 'UCO BANK', 'MALVIYA MARG, HAZARIBAG', 'UCBA0002046', 'Savings', 'AVOPJ2874Q', '964823638248', '$2y$12$4HsN4sxYnmEbyUqhVQgqE.Vx508DjW2XnXGwehIhJwf3hdbO3St6a', 1, '2024-07-05 23:39:07', '2025-01-09 13:46:14'), (9, 27, 'DILIP KUMAR SINGH', '483218210007484', 'BANK OF INDIA', 'PADMA', 'BKID0004832', 'Savings', 'DAXPS8841D', '921526142076', '$2y$12$p2gxmqzUjhQziZZeDwbVbOgA4GCcwDmx0oVg0l2ROxcWPz73.Ygba', 1, '2024-07-07 20:54:45', '2025-01-09 13:46:22'), (10, 9, 'CHAMPA KUMARI', '410502120001767', 'UNION BANK OF INDIA', 'PUGMIL', 'UBIN0541052', 'SAVING', 'LZQPK9541Q', '656341447536', '$2y$12$ZKmSqUEAkl9iJAd.aXvDYeydc68znOy18lNdH68d6vyua5Ts4.WaO', 1, '2024-12-10 21:39:21', '2025-01-09 13:46:39'), (11, 4, 'Raj kumar', '0292104000049762', 'IDBI BANK', 'HAZARIBAG', 'IBKL0000292', 'Savings', 'BNWPK7145L', '680788889900', '$2y$12$ZhsjGj/OSs5o9L9Bfc5v2ODPCDZs58VuNAgNhD4.0tX6fCykmBQgi', 1, '2024-12-17 21:19:17', '2024-12-17 21:19:17'); -- -------------------------------------------------------- -- -- Table structure for table `autopools` -- CREATE TABLE `autopools` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `level` int(11) DEFAULT 0, `no_of_members` int(11) NOT NULL DEFAULT 0, `bonus` decimal(10,2) NOT NULL DEFAULT 0.00, `gift` varchar(255) NOT NULL DEFAULT '0', `status` enum('Pending','Complete') NOT NULL DEFAULT 'Pending', `created_at` timestamp NOT 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 `autopools` -- INSERT INTO `autopools` (`id`, `user_id`, `level`, `no_of_members`, `bonus`, `gift`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (2, 1, 2, 9, 360.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (3, 1, 3, 27, 405.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (4, 2, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (5, 2, 2, 9, 360.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (6, 2, 3, 27, 405.00, 'No Gift', 'Complete', '2025-01-12 08:00:06', '2025-01-12 08:00:06'), (7, 3, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (8, 3, 2, 9, 360.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (9, 4, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (10, 4, 2, 9, 360.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (11, 5, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (12, 5, 2, 9, 360.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (13, 6, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (14, 7, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (15, 8, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:07', '2025-01-12 08:00:07'), (16, 9, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:08', '2025-01-12 08:00:08'), (17, 10, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:08', '2025-01-12 08:00:08'), (18, 11, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:08', '2025-01-12 08:00:08'), (19, 12, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:08', '2025-01-12 08:00:08'), (20, 13, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:08', '2025-01-12 08:00:08'), (21, 14, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:09', '2025-01-12 08:00:09'), (22, 15, 1, 3, 240.00, 'No Gift', 'Complete', '2025-01-12 08:00:09', '2025-01-12 08:00:09'); -- -------------------------------------------------------- -- -- Table structure for table `binary_trees` -- CREATE TABLE `binary_trees` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `parent_id` varchar(100) DEFAULT NULL, `position` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `binary_trees` -- INSERT INTO `binary_trees` (`id`, `user_id`, `parent_id`, `position`, `created_at`, `updated_at`) VALUES (1, 2, '1', 'Left', '2025-01-12 06:11:47', '2025-01-12 12:16:46'), (2, 3, '2', 'Left', '2025-01-12 06:11:47', '2025-01-12 06:11:47'), (3, 4, '2', 'Middle', '2025-01-12 06:11:47', '2025-01-12 06:11:47'), (4, 5, '2', 'Right', '2025-01-12 06:11:47', '2025-01-12 06:11:47'), (5, 6, '3', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (6, 7, '3', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (7, 8, '3', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (8, 9, '4', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (9, 10, '4', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (10, 11, '4', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (11, 12, '5', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (12, 13, '5', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (13, 14, '5', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (14, 15, '6', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (15, 16, '6', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (16, 17, '6', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (17, 18, '7', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (18, 19, '7', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (19, 20, '7', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (20, 21, '8', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (21, 22, '8', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (22, 23, '8', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (23, 24, '9', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (24, 25, '9', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (25, 26, '9', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (26, 27, '10', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (27, 28, '10', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (28, 29, '10', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (29, 30, '11', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (30, 31, '11', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (31, 32, '11', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (32, 33, '12', 'Left', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (33, 34, '12', 'Middle', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (34, 35, '12', 'Right', '2025-01-12 06:11:48', '2025-01-12 06:11:48'), (35, 36, '13', 'Left', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (36, 37, '13', 'Middle', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (37, 38, '13', 'Right', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (38, 39, '14', 'Left', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (39, 40, '14', 'Middle', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (40, 41, '14', 'Right', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (41, 42, '15', 'Left', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (42, 43, '15', 'Middle', '2025-01-12 06:11:49', '2025-01-12 06:11:49'), (43, 44, '15', 'Right', '2025-01-12 06:11:49', '2025-01-12 06:11:49'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('fusidacaqi415@gmail.com|102.36.151.7:timer', 'i:1736732736;', 1736732736), ('fusidacaqi415@gmail.com|102.36.151.7', 'i:2;', 1736732736), ('bhibhukri970@gmail.com|117.96.146.39:timer', 'i:1736747838;', 1736747838), ('bhibhukri970@gmail.com|117.96.146.39', 'i:2;', 1736747838), ('korinrolliny62@gmail.com|113.193.48.42:timer', 'i:1736852400;', 1736852400), ('korinrolliny62@gmail.com|113.193.48.42', 'i:2;', 1736852400); -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `commission_rate` decimal(5,2) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `name`, `commission_rate`, `created_at`, `updated_at`) VALUES (1, 'Insurance', 10.00, '2024-12-11 09:52:59', '2024-12-11 10:30:11'), (2, 'Electronics', 5.00, '2024-12-13 02:50:54', '2024-12-13 02:50:54'), (3, 'Furniture', 5.00, '2024-12-13 02:51:11', '2024-12-13 06:20:37'), (4, 'Food Supplement', 10.00, '2024-12-13 06:21:08', '2024-12-13 06:21:08'); -- -------------------------------------------------------- -- -- 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 `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) UNSIGNED NOT NULL, `reserved_at` int(10) UNSIGNED DEFAULT NULL, `available_at` int(10) UNSIGNED NOT NULL, `created_at` int(10) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job_batches` -- CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `sponsor_id` varchar(255) DEFAULT NULL, `profile_image` varchar(255) DEFAULT NULL, `full_name` varchar(255) NOT NULL, `position` enum('Left','Middle','Right') NOT NULL, `pan` varchar(20) DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `state` varchar(255) DEFAULT NULL, `district` varchar(255) DEFAULT NULL, `gender` enum('Male','Female','Other') DEFAULT NULL, `marital_status` enum('Married','Unmarried','Divorced','Widowed') DEFAULT NULL, `mobile_no` varchar(15) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `user_id`, `sponsor_id`, `profile_image`, `full_name`, `position`, `pan`, `date_of_birth`, `state`, `district`, `gender`, `marital_status`, `mobile_no`, `created_at`, `updated_at`) VALUES (1, 2, '1', NULL, 'SHANTI DEVI', 'Left', 'CIWPD9639N', '1990-02-05', 'Jharkhand', 'HAZARIBAGH', 'Female', 'Married', '9771141364', '2024-04-14 10:35:21', '2025-01-09 14:57:32'), (2, 3, '2', NULL, 'BIBHA KUMARI', 'Left', 'DLYPK8727C', '1990-03-13', 'Jharkhand', 'HAZARIBAGH', 'Female', 'Married', '7004934531', '2024-04-14 10:39:20', '2025-01-09 14:57:35'), (3, 4, '2', NULL, 'RAJ KUMAR', 'Middle', 'BNWPK7145L', '1985-10-12', 'Jharkhand', 'HAZARIBAGH', 'Male', 'Married', '8789658627', '2024-04-14 10:50:54', '2025-01-09 14:57:37'), (4, 5, '2', NULL, 'NISHA KUMARI', 'Right', 'IEAPK4064J', '1998-11-30', 'Jharkhand', 'HAZARIBAGH', 'Female', 'Married', '9304946804', '2024-04-14 10:56:46', '2025-01-09 14:57:39'), (5, 6, '4', NULL, 'PRAMOD RANA', 'Left', 'CRCPR0107G', '1993-08-16', 'Jharkhand', 'HAZARIBAGH', 'Male', 'Married', '8789945559', '2024-04-14 11:01:47', '2025-01-09 14:57:42'), (6, 7, '2', NULL, 'RAHUL KUMAR', 'Right', 'DBIPK2310B', '1988-05-05', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '7979039308', '2024-05-24 12:40:55', '2025-01-09 14:57:45'), (7, 8, '7', NULL, 'PRAMOD KUMAR', 'Left', 'BQRPM9889B', '1993-12-06', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '7903887876', '2024-05-24 12:53:32', '2025-01-09 14:57:50'), (8, 9, '7', NULL, 'CHAMPA KUMARI', 'Middle', 'LZQPK9541Q', '1991-05-02', 'JHARKHAND', 'HAZARIBAGH', 'Female', 'Married', '9534154812', '2024-05-29 08:49:51', '2025-01-09 14:57:54'), (9, 10, '6', NULL, 'Amit sharma', 'Left', 'EUOPS8684E', '1982-06-18', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '8210962210', '2024-06-16 12:57:06', '2025-01-09 14:57:57'), (10, 11, '6', NULL, 'Ajeet kumar rana', 'Middle', 'AONPR8327Q', '1986-01-10', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '7903447005', '2024-06-16 13:10:57', '2025-01-09 14:57:59'), (11, 12, '9', NULL, 'ROHIT MEHTA', 'Right', 'AZMPM6414F', '1985-01-01', 'JHARKHAND', 'KODERMA', 'Male', 'Unmarried', '7070328391', '2024-06-19 09:19:39', '2025-01-09 14:58:02'), (12, 13, '9', NULL, 'SHYAM SUNDAR RANA', 'Middle', 'EPKPR1908R', '1999-12-06', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '7033712743', '2024-06-19 12:36:35', '2025-01-09 14:58:04'), (13, 14, '3', NULL, 'MUSKAN SINGH', 'Right', 'ITRPS7282C', '1999-11-03', 'JHARKHAND', 'HAZARIBAGH', 'Female', 'Unmarried', '9619180771', '2024-06-21 14:27:27', '2025-01-09 14:58:08'), (14, 15, '3', NULL, 'PRAVEEN KUMAR', 'Middle', 'COPPK7120A', '1988-06-26', 'JHARKHAND', 'HAZARIBAG', 'Male', 'Married', '9570055061', '2024-06-22 09:40:06', '2025-01-09 14:58:10'), (15, 16, '3', NULL, 'MAMTA DEVI', 'Left', 'GDWPD1274A', '1989-01-01', 'JHARKHAND', 'HAZARIBAG', 'Female', 'Married', '9546121914', '2024-06-22 11:01:29', '2025-01-09 14:58:13'), (16, 17, '3', NULL, 'Kapil Kumar Mehta', 'Right', 'BRVPM3372E', '1991-03-05', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '9122888400', '2024-06-25 07:38:49', '2025-01-09 14:58:19'), (17, 18, '15', NULL, 'Nitesh Kumar', 'Left', 'GHQPK3570Q', '1994-08-10', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '7319686103', '2024-06-25 11:19:44', '2025-01-09 15:04:33'), (18, 19, '14', NULL, 'Minu Verma', 'Right', 'AYLPV5128M', '1980-06-20', 'Jharkhand', 'Hazaribagh', 'Female', 'Married', '8102691894', '2024-06-25 11:29:21', '2025-01-09 15:05:21'), (19, 20, '9', NULL, 'MD WASIM', 'Left', 'AECPW2747J', '1992-05-16', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '8210096449', '2024-06-25 13:34:10', '2025-01-09 15:05:47'), (20, 21, '12', NULL, 'VIKASH KUMAR MEHTA', 'Middle', 'EIIPM9239K', '1993-11-20', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '8804087512', '2024-06-25 13:39:37', '2025-01-09 15:06:13'), (21, 22, '3', NULL, 'Shankar prasad mehta', 'Middle', 'ATQPM2858P', '1987-09-05', 'JHARKJHAND', 'HAZARIBAG', 'Male', 'Married', '9431593415', '2024-06-30 15:02:54', '2025-01-09 14:58:34'), (22, 23, '3', NULL, 'Pramod Kumar', 'Middle', 'HYGPK2664R', '2001-01-01', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '9110058450', '2024-07-01 08:42:55', '2025-01-09 14:58:38'), (23, 24, '17', NULL, 'Manoj Kumar Mehta', 'Right', 'DAVPM8642E', '1992-03-22', 'Jharkhand', 'Hazaribag', 'Male', 'Married', '7273075626', '2024-07-02 09:03:33', '2025-01-09 15:08:16'), (24, 25, '3', NULL, 'NISHKANT UPADHYAY', 'Right', 'AAPPU4444F', '1978-03-07', 'JHARKJHAND', 'HAZARIBAG', 'Male', 'Married', '7645832420', '2024-07-02 15:52:36', '2025-01-09 14:58:43'), (25, 26, '3', NULL, 'DIPAK JAIN', 'Left', 'AVOPK2874Q', '1982-04-13', 'JHARKHAND', 'HAZARIBAG', 'Male', 'Married', '9123223405', '2024-07-05 12:34:06', '2025-01-09 14:59:13'), (26, 27, '25', NULL, 'DILIP KUMAR SINGH', 'Right', 'DAXPS8841D', '1989-06-03', 'JHARKJHAND', 'HAZARIBAG', 'Male', 'Married', '7909079971', '2024-07-07 09:51:16', '2025-01-09 15:00:32'), (27, 28, '8', NULL, 'SUNIL KUMAR', 'Right', 'EFPPK8079K', '1996-03-04', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Married', '7070141164', '2024-07-16 10:22:52', '2025-01-09 15:00:29'), (28, 29, '2', NULL, 'Umesh kumar', 'Middle', 'OSFPK0440H', '1980-01-01', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '8210667967', '2024-11-15 19:45:02', '2025-01-09 15:00:25'), (29, 30, '2', NULL, 'Naresh Rana', 'Right', 'AJXPR3277L', '1974-02-12', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '9798069038', '2024-11-19 17:12:29', '2025-01-09 15:00:23'), (30, 31, '2', NULL, 'Umesh Rana', 'Middle', 'BEZPR7820F', '1993-04-05', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '07070668884', '2024-11-20 17:51:20', '2025-01-09 15:00:19'), (31, 32, '21', NULL, 'Asha Devi', 'Left', 'CYHPD1323C', '1990-01-01', 'Jharkhand', 'Hazaribagh', 'Female', 'Married', '7479967013', '2024-11-26 16:22:32', '2025-01-09 15:00:15'), (32, 33, '9', NULL, 'VIVEK KUMAR', 'Middle', 'NZOPK3897N', '2005-12-08', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Unmarried', '9905224167', '2024-12-10 15:53:39', '2025-01-09 15:00:12'), (33, 34, '12', NULL, 'KAMLESH KUMAR MEHTA', 'Middle', 'AZZPM5749N', '1989-02-03', 'JHARKHAND', 'HAZARIPAGH', 'Male', 'Married', '6202245947', '2024-12-11 12:51:54', '2025-01-09 15:00:09'), (34, 35, '32', NULL, 'GUDDU KUMAR PASWAN', 'Middle', 'HAQPP2268N', '2004-01-01', 'JHARKHAND', 'HAZARIBAGH', 'Male', 'Unmarried', '822944042', '2024-12-11 15:24:11', '2025-01-09 15:00:03'), (35, 36, '4', NULL, 'Abha Devi', 'Right', 'CQLPD6887R', '1982-06-15', 'Jharkhand', 'Hazaribagh', 'Female', 'Married', '7765932310', '2024-12-12 18:38:14', '2025-01-09 14:59:59'), (36, 37, '4', NULL, 'Manju Devi', 'Left', 'DDLPD0281B', '1983-03-03', 'Jharkhand', 'Hazaribagh', 'Female', 'Married', '7352292438', '2024-12-12 19:38:04', '2025-01-09 14:59:57'), (37, 38, '15', NULL, 'KUNJAN KUMAR', 'Left', 'BIZPK2887D', '1990-01-12', 'Jharkhand', 'Hazaribagh', 'Male', 'Married', '9031002951', '2024-12-13 18:53:49', '2025-01-09 14:59:54'), (38, 39, '37', NULL, 'AWANTIKA KUMARI', 'Left', 'PLEPK0597N', '1989-11-23', 'JHARKHAND', 'HAZARIBAGH', 'Female', 'Married', '6206652679', '2024-12-16 14:53:17', '2025-01-09 14:59:50'), (39, 40, '15', NULL, 'PUNAM KUMARI', 'Middle', 'EYEPK8915A', '1986-01-21', 'Jharkhand', 'HAZARIBAGH', 'Female', 'Married', '6203920451', '2024-12-16 15:13:54', '2025-01-09 14:59:45'), (40, 41, '35', NULL, 'RADHA DEVI', 'Left', 'ASUPD8625Q', '1978-01-20', 'Jharkhand', 'HAZARIBAGH', 'Female', 'Married', '7004360295', '2024-12-16 16:56:01', '2025-01-09 14:59:42'), (41, 42, '36', NULL, 'RENU DEVI', 'Right', 'AXTPD5309H', '1980-05-08', 'JHARKJHAND', 'HAZARIBAG', 'Female', 'Married', '9155260122', '2024-12-16 17:21:22', '2025-01-09 14:59:38'), (42, 43, '35', NULL, 'Rinku Devi', 'Right', 'CYMPD1091A', '1983-01-01', 'Jharkhand', 'Hazaribagh', 'Female', 'Married', '9128342734', '2024-12-17 12:52:23', '2025-01-09 14:59:31'), (43, 44, '15', NULL, 'AJAY KUMAR', 'Right', 'DCDPK9690A', '1989-11-26', 'Jharkhand', 'HAZARIBAGH', 'Male', 'Married', '7004899029', '2024-12-17 18:55:17', '2025-01-09 14:59:24'); -- -------------------------------------------------------- -- -- 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; -- -------------------------------------------------------- -- -- Table structure for table `nominees` -- CREATE TABLE `nominees` ( `id` int(11) NOT NULL, `account_id` int(11) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `relationship` varchar(50) DEFAULT NULL, `dob` date DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `percentage` decimal(5,2) DEFAULT NULL, `type` varchar(50) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `password_reset_tokens` -- INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES ('harshita.lalawat99@gmail.com', '$2y$12$.tmPOqxQEQtY/xncv/y0Lev9eGEWM/numWxnnLISEm2sAHoGf0W8G', '2024-07-28 23:05:22'), ('shantidevi9029@gmail.com', '$2y$12$nFXjuaYBxcy0ziy3Pr3z0OTuyatIsVf7H01zEfXcowvX3MJEt49Wi', '2024-07-29 00:31:24'), ('nareshrana7475@gmail.com', '$2y$12$sVzCerWxdb3qVyziVsNGz.Ni3F5tkvQVoN0Chwma4OOcqKveF7EpS', '2024-11-26 20:59:39'), ('bibhukri970@gmail.com', '$2y$12$sSJQufmfwRFMS31hJDCkA.ePZ.Vz3HRLPrqvpkUXzSGUX22gmFbz2', '2024-12-13 05:28:07'), ('saketk52@gmail.com', '$2y$12$PRNaYcq.DmRZmTUMBu1P2eukZXklMmliP.D6p10MuutO4GcnCH90G', '2024-12-14 06:20:33'), ('harshita.lalawat99@gmail.com', '$2y$12$.tmPOqxQEQtY/xncv/y0Lev9eGEWM/numWxnnLISEm2sAHoGf0W8G', '2024-07-28 17:35:22'), ('shantidevi9029@gmail.com', '$2y$12$nFXjuaYBxcy0ziy3Pr3z0OTuyatIsVf7H01zEfXcowvX3MJEt49Wi', '2024-07-28 19:01:24'), ('nareshrana7475@gmail.com', '$2y$12$sVzCerWxdb3qVyziVsNGz.Ni3F5tkvQVoN0Chwma4OOcqKveF7EpS', '2024-11-26 15:29:39'), ('bibhukri970@gmail.com', '$2y$12$sSJQufmfwRFMS31hJDCkA.ePZ.Vz3HRLPrqvpkUXzSGUX22gmFbz2', '2024-12-12 23:58:07'), ('saketk52@gmail.com', '$2y$12$PRNaYcq.DmRZmTUMBu1P2eukZXklMmliP.D6p10MuutO4GcnCH90G', '2024-12-14 00:50:33'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `category_id` int(20) DEFAULT NULL, `product_name` varchar(255) NOT NULL, `product_amount` decimal(10,2) NOT NULL, `payment_mode` enum('Credit','Debit','UPI','Net Banking','Other') NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `user_id`, `category_id`, `product_name`, `product_amount`, `payment_mode`, `created_at`, `updated_at`) VALUES (1, 2, NULL, 'demo product', 750.00, 'UPI', '2024-05-05 16:15:32', '2024-05-05 16:15:32'), (2, 8, NULL, 'Home Kit', 1210.00, 'Credit', '2024-05-29 14:02:32', '2025-01-09 14:09:30'), (3, 7, NULL, 'Turmeric', 750.00, 'Credit', '2024-06-03 20:10:31', '2024-06-03 20:10:31'), (4, 16, NULL, 'ALOEVERA, TULSHI, S. AND PADS', 1518.00, 'UPI', '2024-06-22 16:36:13', '2025-01-09 13:51:12'), (5, 14, NULL, 'Shetop', 1599.00, 'UPI', '2024-06-23 14:59:43', '2025-01-09 13:51:46'), (6, 19, NULL, 'Paste, Soap 2, Pad, T Oil, H. wash', 1338.00, 'UPI', '2024-06-30 15:17:21', '2025-01-09 13:52:35'), (7, 17, NULL, 'Aloe vera - 1, Soap - 3', 1239.00, 'UPI', '2024-07-02 14:22:41', '2025-01-09 13:52:55'), (8, 24, NULL, 'Aloe vera - 1, Soap - 3', 1240.00, 'UPI', '2024-07-02 14:34:53', '2025-01-09 13:53:13'), (9, 26, NULL, 'Home Kit', 1200.00, 'UPI', '2024-07-05 18:45:00', '2025-01-09 13:53:42'), (10, 27, NULL, 'Aloe Vera, Tulsi Oil, Neem Soap', 1678.00, 'UPI', '2024-07-07 15:28:25', '2025-01-09 13:53:55'), (11, 7, NULL, 'home kit', 1200.00, 'UPI', '2024-12-11 12:25:37', '2024-12-11 12:25:37'), (12, 38, 4, 'VIGAR TOP', 1599.00, 'Credit', '2024-12-14 00:47:45', '2025-01-09 13:59:06'), (13, 3, 4, 'shetop', 1599.00, 'Other', '2024-12-14 02:55:24', '2024-12-14 02:55:24'), (14, 39, 1, 'star helth', 2500.00, 'Other', '2024-12-16 20:28:12', '2025-01-09 17:52:16'), (15, 40, 4, 'home kite', 1200.00, 'UPI', '2024-12-16 20:48:49', '2025-01-09 17:52:20'), (16, 36, 4, 'Home kit', 1200.00, 'Other', '2024-12-18 00:07:51', '2025-01-09 17:52:23'), (17, 37, 4, 'home kite', 1200.00, 'Other', '2024-12-18 00:28:07', '2025-01-09 17:52:26'); -- -------------------------------------------------------- -- -- Table structure for table `product_transactions` -- CREATE TABLE `product_transactions` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `product_id` int(11) DEFAULT NULL, `transactionID` varchar(255) DEFAULT NULL, `transaction_date` date DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `product_transactions` -- INSERT INTO `product_transactions` (`id`, `user_id`, `product_id`, `transactionID`, `transaction_date`, `created_at`, `updated_at`) VALUES (1, 2, 1, 'ZXCVB123', '2024-05-06', '2024-05-05 16:15:32', '2024-12-15 09:36:43'), (2, 8, 2, 'dder122323hddk', '2024-05-30', '2024-05-29 14:02:32', '2024-12-15 09:36:43'), (3, 7, 3, 'ASQWER6723S', '2024-06-04', '2024-06-03 20:10:31', '2024-12-15 09:36:43'), (4, 16, 4, 'T2460201523180118737963', '2024-07-20', '2024-06-22 16:36:13', '2024-12-15 09:36:43'), (5, 14, 5, 'T2406241230466335499799', '2024-06-24', '2024-06-23 14:59:43', '2024-12-15 09:36:43'), (6, 19, 6, 'T2406271205495003380808', '2024-06-27', '2024-06-30 15:17:21', '2024-12-15 09:36:43'), (7, 17, 7, 'T2407031153360551505104', '2024-07-03', '2024-07-02 14:22:41', '2024-12-15 09:36:43'), (8, 24, 8, '418520358899', '2024-07-03', '2024-07-02 14:34:53', '2024-12-15 09:36:43'), (9, 26, 9, '418832689503', '2024-07-06', '2024-07-05 18:45:00', '2024-12-15 09:36:43'), (10, 27, 10, '419010269149', '2024-07-08', '2024-07-07 15:28:25', '2024-12-15 09:36:43'), (11, 7, 11, '4196981065032', '2024-12-07', '2024-12-11 12:25:37', '2024-12-15 09:36:43'), (12, 38, 12, NULL, '2024-12-14', '2024-12-14 00:47:45', '2024-12-14 00:47:45'), (13, 3, 13, NULL, '2024-12-14', '2024-12-14 02:55:24', '2024-12-14 02:55:24'), (14, 39, 14, 'utr12345678', '2024-12-17', '2024-12-16 20:28:12', '2024-12-16 20:28:12'), (15, 40, 15, 'UTR577019078925', '2024-12-17', '2024-12-16 20:48:49', '2024-12-16 20:48:49'), (16, 36, 16, '000001', '2024-12-15', '2024-12-18 00:07:51', '2024-12-18 00:07:51'), (17, 37, 17, 'utr98765432', '2024-12-18', '2024-12-18 00:28:07', '2024-12-18 00:28:07'); -- -------------------------------------------------------- -- -- Table structure for table `rank_levels` -- CREATE TABLE `rank_levels` ( `id` int(11) NOT NULL, `level` int(11) NOT NULL, `no_of_members` int(11) NOT NULL, `bonus` decimal(10,2) NOT NULL, `gift` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `rank_levels` -- INSERT INTO `rank_levels` (`id`, `level`, `no_of_members`, `bonus`, `gift`, `created_at`, `updated_at`) VALUES (1, 1, 3, 240.00, NULL, '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (2, 2, 9, 360.00, NULL, '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (3, 3, 27, 405.00, NULL, '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (4, 4, 81, 1053.00, NULL, '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (5, 5, 243, 2673.00, '20000.00', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (6, 6, 729, 6561.00, '50000.00', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (7, 7, 2187, 17496.00, '100000.00', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (8, 8, 6561, 45927.00, '200000.00', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (9, 9, 19683, 118098.00, '1 Lac + Alto Car', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (10, 10, 59049, 295245.00, '1 Lac + Scorpio Car', '2024-07-26 13:35:18', '2024-07-26 13:35:18'), (11, 11, 177147, 708588.00, '1 Lac + 2 Bhk Flat', '2024-07-26 13:35:18', '2024-07-26 13:35:18'); -- -------------------------------------------------------- -- -- 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 ('Dj4qDjhuFW2hg4CspMHj1LdENP0af46ywvcN67dj', NULL, '130.255.166.51', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoia1lkejR2TlE0MDdTYzBFRFZKNHFEOXc0WVNMMmJUOW1OOGxXdXdvViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1734599740), ('KUGm4euUDSvoKD4Sn7CX4mM9iOKaXwnDxsVt7YEY', NULL, '130.255.166.142', 'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:109.0) Gecko/20100101 Firefox/115', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoidnV1M0hQempkbXdTdlg3TVlMNk1oZkRRZEdzR3JMaDg3akUxb0NHdiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tL2hvbWUiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1734599741), ('2czHvV1wTec1TwZnYiL6lOijLmVDpHG2AFSsXZA0', NULL, '49.36.189.175', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiVzJhSnlzemJBUVRZWU1WMXZZQjBzVkhndnpzMEVBd1I1bEwyOUpENiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbS9ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1734604743), ('dxeFbG1j1eUHd9PqLOVrBBKfUdf42477RYamUktz', 1, '152.59.68.109', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoia2xsMXo1ZHVyaFdSeTJiRW9XV0xYMXh6Q2xnVUVreWFPMUprNURvUyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTQ6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tL2FkbWluL2dlbmVhbG9neS9tYXRyaXhfdmlldyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjE7fQ==', 1734606450), ('gVM32gudDJFGoM8Li8wDe2SW7f0Pfqll0tzFsoHq', NULL, '49.36.189.175', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibmFlRnJTRVZnUVRXR0tjWkxkQ1RHcHdQdGVBS0V5SUU3TXF5TmRIOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbS9ob21lIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1734606822), ('EcyHccbiBFoKtaEUe9b5dIdMxiVsM5xaL4kTdObh', 24, '157.42.16.51', 'Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Mobile Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoid0M5cWlNdEVnUVNWOWZrVkJTV0lhRHRMZDhQNlRiZFdEVHpkSk1TeiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tL2Rhc2hib2FyZCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTA6ImxvZ2luX3dlYl81OWJhMzZhZGRjMmIyZjk0MDE1ODBmMDE0YzdmNThlYTRlMzA5ODlkIjtpOjI0O30=', 1734608049), ('5ScmNezxylIwbyi7F1JS2ior3xbtexScimbpJomc', NULL, '182.42.105.85', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiem1DdVRGaFQxR3d2N0xmM3gxS005bkE1N2dKd1kzclpZclNXVmJ4RSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1736840736), ('cQMkgBQSLYx3WvlEhwRfurd3hLexhiC1nLPXW0u1', NULL, '80.85.246.140', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiT1drNXluZTBDUEJkdFNnQWVzakRrMkZXZENBQTlsR085M2FyQnJLWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDM6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbS9mb3Jnb3QtcGFzc3dvcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1736852370), ('RCw4WyPvvIrCyG9WHJR0eIcXUmPvYCoro0ASF9aI', NULL, '195.78.54.157', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/95.0.4638.69 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoibUw2SDFmZ2FlbzUwSGZjWkNIbkRha3U2UHUzSTJzODVuNGZhbG53WCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1736854383), ('6xPqjOBrR3K2iypTAfAs7Dq1QuJpMFtwzdX3XY8y', NULL, '49.37.64.179', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiUmNPMGNMTU1kcXl4R1BqbzNoTlo1SnpOd3c4ZlVzNDM2U0t1cEFCOCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1736864013), ('MJryT3OCVPzQK7QEx25cNv73CLCdXhBGoJY9UQyb', NULL, '170.106.181.163', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiMUJnRUJ2dW5ya0hPcnRpNGhZb2ZKUTVuQlVLWU9JZTNoSlVESERLbyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzA6Imh0dHA6Ly93d3cucmF6bmFuZGFuaWdyb3VwLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1736866043), ('1wy3DYaLX7kZ9JOeul052qgSXQ8piAzVwzEVNiGt', NULL, '191.102.155.5', 'Apache-HttpClient/5.1.4 (Java/11.0.18)', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiQzRlMjh5dlhoaFN3cnV2TnJXSVJOSFVCekUwV2lIUmx2eHBBM1VxMCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1736867828), ('7tLJIS3jY7mVMskfgygHjF6OkboCiFqKEgpyFBSq', NULL, '143.137.166.189', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YToyOntzOjY6Il90b2tlbiI7czo0MDoiSVcxaVJoUTVWejJoUWRhUGtXTUYxY1E5SGhHU0I4SmpROHMzWWNpSyI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1736867829), ('cm6Vvdp0LFBSQ218aaugoxxBaeWARttXUvlBJn4U', NULL, '193.34.75.23', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/107.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiemZNMUo5azJJVWZDaWFkQWJHRW82ZHZ3SjJkSmE2c0dTODNqT1Y4YiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1736867829), ('NO8pPcb7LmNKrSHeJ9hOYuksV3vpPvwPHvr3qgNF', NULL, '161.0.28.151', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/108.0.0.0 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoickNoWUlvbnZUbVlvSTVuV2ZweGxSQ0loN3AyNTh4OU1qVG84bWFWVyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjY6Imh0dHA6Ly9yYXpuYW5kYW5pZ3JvdXAuY29tIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1736869337), ('4S0pskFFq8nzC9bbhdSQb7Yr20oJb0yMI1S6FhoK', NULL, '40.77.167.15', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm) Chrome/116.0.1938.76 Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiTlM4a0kyTjIzcllPODBqckF5bW5SZFByRXcxMnhLdDBvWkpOT2R0aSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHBzOi8vcmF6bmFuZGFuaWdyb3VwLmNvbSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1736869644), ('O1fSJRCyZmVfN3XDWjLti11Zzp6rbpmXmOd0KooO', NULL, '45.148.10.236', 'Mozilla/5.0 (Linux; Android 9; SM-G950F) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.111 Mobile Safari/537.36', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoienVFNzdDT2N6RTFDZzFGVEV1UGN0aHkwdUhOb3g0SGZnUWhkeFR3eCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHBzOi8vd3d3LnJhem5hbmRhbmlncm91cC5jb20iO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1736875828); -- -------------------------------------------------------- -- -- Table structure for table `sponsors` -- CREATE TABLE `sponsors` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `sponsor_id` varchar(255) DEFAULT NULL, `no_of_members` int(11) NOT NULL DEFAULT 0, `level` varchar(20) DEFAULT '0', `bonus` decimal(10,2) NOT NULL DEFAULT 0.00, `direct_bonus` decimal(10,2) NOT NULL DEFAULT 0.00, `team_bonus` decimal(10,2) NOT NULL DEFAULT 0.00, `gift` varchar(255) NOT NULL DEFAULT 'No Gift', `status` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sponsors` -- INSERT INTO `sponsors` (`id`, `user_id`, `sponsor_id`, `no_of_members`, `level`, `bonus`, `direct_bonus`, `team_bonus`, `gift`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'RN000001', 27, '3', 405.00, 75.00, 1.78, 'No Gift', 0, '2024-04-14 14:57:38', '2025-01-12 13:48:58'), (2, 2, 'RN000002', 27, '3', 405.00, 354.90, 17.78, 'No Gift', 0, '2024-04-14 21:35:21', '2025-01-12 13:48:58'), (3, 3, 'RN000003', 9, '2', 360.00, 555.60, 177.84, 'No Gift', 0, '2024-04-14 21:39:20', '2025-01-12 13:48:58'), (4, 4, 'RN000004', 9, '2', 360.00, 240.00, 179.40, 'No Gift', 0, '2024-04-14 21:50:54', '2025-01-12 13:48:59'), (5, 5, 'RN000005', 9, '2', 360.00, 0.00, 194.98, 'No Gift', 0, '2024-04-14 21:56:46', '2025-01-12 13:48:59'), (6, 6, 'RN000006', 3, '1', 240.00, 0.00, 350.76, 'No Gift', 0, '2024-04-14 22:01:47', '2025-01-12 13:48:59'), (7, 7, 'RN000007', 3, '1', 240.00, 121.00, 347.60, 'No Gift', 0, '2024-05-24 23:40:55', '2025-01-12 13:48:59'), (8, 8, 'RN000008', 3, '1', 240.00, 0.00, 316.02, 'No Gift', 0, '2024-05-24 23:53:32', '2025-01-12 13:48:59'), (9, 9, 'RN000009', 3, '1', 240.00, 0.00, 0.18, 'No Gift', 0, '2024-05-29 19:49:51', '2025-01-12 13:48:59'), (10, 10, 'RN000010', 3, '1', 240.00, 0.00, 1.78, 'No Gift', 0, '2024-06-16 23:57:06', '2025-01-12 13:48:59'), (11, 11, 'RN000011', 3, '1', 240.00, 0.00, 17.78, 'No Gift', 0, '2024-06-17 00:10:57', '2025-01-12 13:48:59'), (12, 12, 'RN000012', 3, '1', 240.00, 0.00, 177.80, 'No Gift', 0, '2024-06-19 20:19:39', '2025-01-12 13:48:59'), (13, 13, 'RN000013', 3, '1', 240.00, 0.00, 178.96, 'No Gift', 0, '2024-06-19 23:36:35', '2025-01-12 13:48:59'), (14, 14, 'RN000014', 3, '1', 240.00, 133.80, 190.52, 'No Gift', 0, '2024-06-22 01:27:27', '2025-01-12 13:48:59'), (15, 15, 'RN000015', 3, '1', 240.00, 279.90, 306.17, 'No Gift', 0, '2024-06-22 20:40:06', '2025-01-12 13:48:59'), (16, 16, 'RN000016', 3, '1', 240.00, 0.00, 304.75, 'No Gift', 0, '2024-06-22 22:01:29', '2025-01-12 13:48:59'), (17, 17, 'RN000017', 3, '1', 240.00, 124.00, 290.55, 'No Gift', 0, '2024-06-25 18:38:49', '2025-01-12 13:48:59'), (18, 18, 'RN000018', 0, '0', 0.00, 0.00, 148.52, '', 0, '2024-06-25 22:19:44', '2025-01-12 13:48:59'), (19, 19, 'RN000019', 0, '0', 0.00, 0.00, 147.18, '', 0, '2024-06-25 22:29:21', '2025-01-12 13:48:59'), (20, 20, 'RN000020', 0, '0', 0.00, 0.00, 133.82, '', 0, '2024-06-26 00:34:10', '2025-01-12 13:48:59'), (21, 21, 'RN000021', 0, '0', 0.00, 0.00, 0.26, '', 0, '2024-06-26 00:39:37', '2025-01-12 13:48:59'), (22, 22, 'RN000022', 0, '0', 0.00, 0.00, 2.70, '', 0, '2024-07-01 02:02:54', '2025-01-12 13:48:59'), (23, 23, 'RN000023', 0, '0', 0.00, 0.00, 27.10, '', 0, '2024-07-01 19:42:55', '2025-01-12 13:48:59'), (24, 24, 'RN000024', 0, '0', 0.00, 0.00, 271.03, '', 0, '2024-07-02 20:03:33', '2025-01-12 13:48:59'), (25, 25, 'RN000025', 3, '1', 240.00, 167.80, 270.27, 'No Gift', 0, '2024-07-03 02:52:36', '2025-01-12 13:48:59'), (26, 26, 'RN000026', 0, '0', 0.00, 0.00, 262.63, '', 0, '2024-07-05 23:34:06', '2025-01-12 13:48:59'), (27, 27, 'RN000027', 0, '0', 0.00, 0.00, 186.26, '', 0, '2024-07-07 20:51:16', '2025-01-12 13:48:59'), (28, 28, 'RN000028', 0, '0', 0.00, 0.00, 184.58, '', 0, '2024-07-16 21:22:52', '2025-01-12 13:48:59'), (29, 29, 'RN000029', 3, '1', 240.00, 0.00, 167.80, 'No Gift', 0, '2024-11-16 01:15:02', '2025-01-12 13:48:59'), (30, 30, 'RN000030', 0, '0', 0.00, 0.00, 0.00, 'No Gift', 0, '2024-11-19 22:42:29', '2025-01-12 08:18:58'), (31, 31, 'RN000031', 3, '1', 240.00, 0.00, 0.00, 'No Gift', 0, '2024-11-20 23:21:20', '2025-01-12 08:18:58'), (32, 32, 'RN000032', 0, '0', 0.00, 0.00, 0.04, 'No Gift', 0, '2024-11-26 21:52:32', '2025-01-12 13:49:00'), (33, 33, 'RN000033', 3, '1', 240.00, 0.00, 0.44, 'No Gift', 0, '2024-12-10 21:23:39', '2025-01-12 13:49:00'), (34, 34, 'RN000034', 0, '0', 0.00, 0.00, 4.44, 'No Gift', 0, '2024-12-11 18:21:54', '2025-01-12 13:49:00'), (35, 35, 'RN000035', 0, '0', 0.00, 0.00, 44.43, 'No Gift', 0, '2024-12-11 20:54:11', '2025-01-12 13:49:00'), (36, 36, 'RN000036', 0, '0', 0.00, 0.00, 444.30, 'No Gift', 0, '2024-12-13 00:08:14', '2025-01-12 13:49:00'), (37, 37, 'RN000037', 0, '0', 0.00, 250.00, 444.00, 'No Gift', 0, '2024-12-13 01:08:04', '2025-01-12 13:49:00'), (38, 38, 'RN000038', 0, '0', 0.00, 0.00, 440.97, 'No Gift', 0, '2024-12-14 00:23:49', '2025-01-12 13:49:00'), (39, 39, 'RN000039', 0, '0', 0.00, 0.00, 410.70, 'No Gift', 0, '2024-12-16 20:23:17', '2025-01-12 13:49:00'), (40, 40, 'RN000040', 0, '0', 0.00, 0.00, 407.00, 'No Gift', 0, '2024-12-16 20:43:54', '2025-01-12 13:49:00'), (41, 41, 'RN000041', 0, '0', 0.00, 0.00, 370.00, 'No Gift', 0, '2024-12-16 22:26:01', '2025-01-12 13:49:00'), (42, 42, 'RN000042', 0, '0', 0.00, 0.00, 0.00, 'No Gift', 0, '2024-12-16 22:51:22', '2025-01-12 08:18:58'), (43, 43, 'RN000043', 0, '0', 0.00, 0.00, 0.00, 'No Gift', 0, '2024-12-17 18:22:23', '2025-01-12 08:18:58'), (44, 44, 'RN000044', 0, '0', 0.00, 0.00, 0.00, 'No Gift', 0, '2024-12-18 00:25:17', '2025-01-12 08:18:58'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `user_type` enum('admin','user') NOT NULL DEFAULT 'user', `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `payment_status` enum('Pending','Paid') NOT NULL DEFAULT 'Pending', `sponsorship_status` tinyint(1) NOT NULL DEFAULT 0, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `user_type`, `email`, `email_verified_at`, `password`, `payment_status`, `sponsorship_status`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Admin', 'admin', 'admin@gmail.com', NULL, '$2y$12$9bSwLq3k5yK/FueEO5Zzfew/ChFv5nAdQYCMwf0ZPwSwlnmrsQVjq', 'Pending', 0, NULL, '2024-04-14 09:27:38', '2024-12-14 09:48:38'), (2, 'SHANTI DEVI', 'user', 'shantidevi9029@gmail.com', NULL, '$2y$12$MhtimRrtAWzRfnQ0R4CyYuKIpK3g9ARM/XpAANJmPGSkpOAQA8JFu', 'Paid', 1, NULL, '2024-04-14 21:35:21', '2024-12-13 22:47:12'), (3, 'BIBHA KUMARI', 'user', 'bibhukri970@gmail.com', NULL, '$2y$12$r58s.XC20fY.jPe1CYvpreUWOol8cJaiI8uFHJ/vXNs5/9IF1mpSO', 'Paid', 1, NULL, '2024-04-14 21:39:20', '2024-12-14 03:01:07'), (4, 'RAJ KUMAR', 'user', 'raazraj@gmail.com', NULL, '$2y$12$OeS/YGPNkJvdLA.9Y8cvYOv2LFKRwEIH772qL4H2HB8rwIOhFqvsW', 'Pending', 0, NULL, '2024-04-14 21:50:54', '2024-07-26 18:27:25'), (5, 'NISHA KUMARI', 'user', 'www.pramodrana16@gmail.com', NULL, '$2y$12$D72VrWn12jQ//ecQNrz0J..SO/.310fLSOZCbkZ2WtdF49162D2LC', 'Pending', 0, NULL, '2024-04-14 21:56:46', '2024-04-14 21:56:46'), (6, 'PRAMOD RANA', 'user', 'herohzbrana16@gmail.com', NULL, '$2y$12$pZ6hb2030dCeIUrF9Y6nYO.jfMcoMD.Gbbon.9YySl2ncExULtMJ2', 'Pending', 0, NULL, '2024-04-14 22:01:47', '2024-07-26 18:34:28'), (7, 'RAHUL KUMAR', 'user', 'rraj.tudu@gmail.com', NULL, '$2y$12$PcfgyRDdNKBV4/AdydlB0O0559BdLO9w6p2K8omUq.KW1y0FsMSLG', 'Paid', 1, NULL, '2024-05-24 23:40:55', '2024-12-14 01:17:08'), (8, 'PRAMOD KUMAR', 'user', '7903887876pr@gmail.com', NULL, '$2y$12$SRbEUh6zixzi.030G6ZYQ.Ot0Uaj8fG6do5D7EJe86gDEoDKzu6Wa', 'Paid', 1, NULL, '2024-05-24 23:53:32', '2024-05-29 19:33:39'), (9, 'CHAMPA KUMARI', 'user', 'muskanchamp0@gmail.com', NULL, '$2y$12$MlX6bOpQFdFCOYVS3z2amukbFGWbA.lRVy5xLQQOQ9io6kj.OZ.Ou', 'Pending', 0, NULL, '2024-05-29 19:49:51', '2024-05-29 19:49:51'), (10, 'Amit sharma', 'user', 'latamadhvi11@gmail.com', NULL, '$2y$12$SAdSddbEf6i3cyS2wURfw.yvKRvNWAQmSedw9DhAgA4FRkNg//FGO', 'Pending', 0, NULL, '2024-06-16 23:57:06', '2024-06-16 23:57:06'), (11, 'Ajeet kumar rana', 'user', 'ajeetrana1976hzb@gmail.com', NULL, '$2y$12$5eqM3T6wYCQ6BGA0O4EqsOqh8jhBjDRbgs0ezAz8hRVduDHDuF0iq', 'Pending', 0, NULL, '2024-06-17 00:10:57', '2024-06-17 00:10:57'), (12, 'ROHIT MEHTA', 'user', 'rohitmehtanidhilimited@gmail.com', NULL, '$2y$12$TynGucBvScj333B6MYUu5esYUmdfwDmKJ.OxcLjdcvN8jHm9Dsae6', 'Pending', 0, NULL, '2024-06-19 20:19:39', '2024-06-19 20:19:39'), (13, 'SHYAM SUNDAR RANA', 'user', 'shyamsunderranarana0@gmail.com', NULL, '$2y$12$ZUA.FbMsBLWcjwtGQ7OQqO64iPh79BE3U3PHaGud5c4fA5ecvmuOu', 'Pending', 0, NULL, '2024-06-19 23:36:35', '2024-06-19 23:36:35'), (14, 'MUSKAN SINGH', 'user', 'muskansingh6648@gmail.com', NULL, '$2y$12$HuoxZ5byD6fmPC27KXL8wO2WeNdNCMzJw0WW5gVIpn4LwOiZ.lbca', 'Paid', 1, NULL, '2024-06-22 01:27:27', '2024-12-13 22:36:19'), (15, 'PRAVEEN KUMAR', 'user', 'praveenkr9570@gmail.com', NULL, '$2y$12$1D155OzUMvH0urTWolWHa.b9nFuniotaEqZ.YSMWWcebHj/1NyOWK', 'Pending', 0, 'kaass9u4ggvkjU4RtY065nMjZZp2BfARsMN3bc6746voy9M7csHNJHKMyjNq', '2024-06-22 20:40:06', '2024-12-18 06:03:12'), (16, 'MAMTA DEVI', 'user', 'mamta.pradeep1989@gmail.com', NULL, '$2y$12$F2W6si60n1AqshXMkM88uuB1U4UoaL23EATOpP8CdR.UC5HnPL.i.', 'Paid', 1, NULL, '2024-06-22 22:01:29', '2024-12-16 20:58:05'), (17, 'Kapil Kumar Mehta', 'user', 'kapilmehtahzb@gmail.com', NULL, '$2y$12$hRVBM.J9nMk7pQPM/VBvaOqAioK8AaQdzjkn81jgDEdfBhgX009Ce', 'Paid', 1, NULL, '2024-06-25 18:38:49', '2024-12-16 21:01:05'), (18, 'Nitesh Kumar', 'user', 'niteshkumar81071@gmail.com', NULL, '$2y$12$ijCVsIfQjKtdfqkKmsXk8uRxxc7ECKM2RizpOL88bq8QzqUoDDVya', 'Pending', 0, NULL, '2024-06-25 22:19:44', '2024-06-25 22:19:44'), (19, 'Minu Verma', 'user', 'minuverma2880@gmail.com', NULL, '$2y$12$fw4GoY1es81gynrkIWTqh.p1TBhEEo7xNLEBaqB7zxIDKPzuJRrcK', 'Paid', 0, NULL, '2024-06-25 22:29:21', '2024-06-30 20:47:21'), (20, 'MD WASIM', 'user', 'mdwasimansari499@gmail.com', NULL, '$2y$12$L38NQOktC6cETXoVVyOKo.SJlDZBW8dlMHOkv4HcpthpvlgkQr6ey', 'Pending', 0, NULL, '2024-06-26 00:34:10', '2024-06-26 00:34:10'), (21, 'VIKASH KUMAR MEHTA', 'user', 'vikashmehta3333@gmail.com', NULL, '$2y$12$7P3ZMfFrvtGur4F0nu5hUuHiscmtYGWJQOiwh6sLDF6KEidZ0JcHC', 'Pending', 0, NULL, '2024-06-26 00:39:37', '2024-06-26 00:39:37'), (22, 'Shankar prasad mehta', 'user', 'shankarmehtak@gmail.com', NULL, '$2y$12$27A18r2xChe/DqVGcImL1ec.HXjJSicpgjbCOJSvjxx1HOqXIeWjy', 'Pending', 0, NULL, '2024-07-01 02:02:54', '2024-07-01 02:02:54'), (23, 'Pramod Kumar', 'user', 'pramodkumar808305@gmail.c9m', NULL, '$2y$12$HfmeatfeI4/N.W0hHl/lAOaMFiUGb6JA9VM59lb96l/dWbjhVGIdK', 'Pending', 0, NULL, '2024-07-01 19:42:55', '2024-07-01 19:42:55'), (24, 'Manoj Kumar Mehta', 'user', 'manojkumar19880711@gmail.com', NULL, '$2y$12$0TpFvLojTqCvuQcueHUCTOiWNPpR5JiF84PUhwM8ISQunN1KdtOKO', 'Paid', 0, NULL, '2024-07-02 20:03:33', '2024-07-02 20:04:53'), (25, 'NISHKANT UPADHYAY', 'user', 'nishikantupadhyay4@gmail.com', NULL, '$2y$12$mXYif3DSA/KHbxzi.p/wZe104HbBBuyTGzsHJg4g//y0jNNqjp32S', 'Pending', 0, NULL, '2024-07-03 02:52:36', '2024-07-03 02:52:36'), (26, 'DIPAK JAIN', 'user', 'dipakjain01982@gmail.com', NULL, '$2y$12$ywXzVYfEDmmjVhN2TwxLoOqqGtohoHKPang4p04GNAIlyJH8HXjWq', 'Paid', 0, NULL, '2024-07-05 23:34:06', '2024-07-06 00:15:00'), (27, 'DILIP KUMAR SINGH', 'user', 'dilip2singh3@gmail.com', NULL, '$2y$12$yFKNBcizGqq0kA/W2xmSLuPB2HkbpNZkVYu2Dnzx7eRviNaOf7cca', 'Paid', 0, NULL, '2024-07-07 20:51:16', '2024-07-07 20:58:25'), (28, 'SUNIL KUMAR', 'user', 'sunil211249@gmail.com', NULL, '$2y$12$oD0MEJCQ3Vcg1rNil28dHO1f1a40Fg3gMKSPw/qNJYfpsOzVRaEiu', 'Pending', 0, NULL, '2024-07-16 21:22:52', '2024-07-16 21:22:52'), (29, 'Umesh kumar', 'user', 'umeshhero05@gmail.com', NULL, '$2y$12$PoLKAO/nXWTe3VMdOybTLuMa/8nN5wOrFxNcxJGd55mWRC.Ybn1a.', 'Pending', 0, NULL, '2024-11-16 01:15:02', '2024-11-16 01:15:02'), (30, 'Naresh Rana', 'user', 'nareshrana7475@gmail.com', NULL, '$2y$12$GeenimQAC98fdPbyyRLOLumQz28D74zfdH/nYKqifn2yVmuSSx7BO', 'Pending', 0, NULL, '2024-11-19 22:42:29', '2024-11-19 22:42:29'), (31, 'Umesh Rana', 'user', 'umeshranahzb@gmail.com', NULL, '$2y$12$1tnfO4d2Ne/Wi1fszBQ3ZuF1GpvygeLCa6vF8w/B171nQcvoZaBMe', 'Pending', 0, NULL, '2024-11-20 23:21:20', '2024-11-20 23:21:20'), (32, 'Asha Devi', 'user', 'deviaasha.1190@gmail.com', NULL, '$2y$12$gDHLgP5eNrMiktRg.kpY5.2YV9aW7jQVaEa1uBxflMpWowYwEULTq', 'Pending', 0, NULL, '2024-11-26 21:52:32', '2024-11-26 21:52:32'), (33, 'VIVEK KUMAR', 'user', 'harsh9905224@gmail.com', NULL, '$2y$12$JAqV1IMH7H8ak7qbWeXXHO0XW6cifNxJuoRDTNGqCmiopVj4v9Ndi', 'Pending', 0, NULL, '2024-12-10 21:23:39', '2024-12-10 21:23:39'), (34, 'KAMLESH KUMAR MEHTA', 'user', 'kam.mehta99@gmail.com', NULL, '$2y$12$RnajYiSnwwZ60F.fu6hN0.6ohKCXqSa0RuH21yqDZrmRrvrPT1Wyi', 'Pending', 0, NULL, '2024-12-11 18:21:54', '2024-12-11 18:21:54'), (35, 'GUDDU KUMAR PASWAN', 'user', 'bahrwajguddu@gmail.com', NULL, '$2y$12$124WNcgt5mlGucHc05yn1evoGW.xIEs8LL2TWhJn95SzEavfDd8ii', 'Pending', 0, NULL, '2024-12-11 20:54:11', '2024-12-11 20:54:11'), (36, 'Abha Devi', 'user', 'abhadevi8253012@gmail.com', NULL, '$2y$12$KEJ0MSmgrLjf6DL7q6nSMuSFhIBaBR5MYCQphfZk7RdJqH.sonvfS', 'Paid', 1, NULL, '2024-12-13 00:08:14', '2024-12-18 00:09:27'), (37, 'Manju Devi', 'user', 'manjudevi735229@gmail.com', NULL, '$2y$12$7Wjb146tOdv4wrxv7vRYHuK08doBnbxXRL0niqR.XMWwE4nXR9z1m', 'Paid', 1, NULL, '2024-12-13 01:08:04', '2024-12-18 00:29:30'), (38, 'KUNJAN KUMAR', 'user', 'kunjankumar123@gmail.com', NULL, '$2y$12$CyUwj2zAUTBx4sW0VM3wpe7I4cTtQkLlnlQttR.Sgtqdmky1TYp8.', 'Paid', 1, NULL, '2024-12-14 00:23:49', '2024-12-14 00:53:56'), (39, 'AWANTIKA KUMARI', 'user', 'avantikakunjan123@gmail.com', NULL, '$2y$12$y1EU0thd.IYHRp7e9GVWHe56I/Ru.7jMYC0nnBCYbpdCNhJj4Csh.', 'Paid', 1, NULL, '2024-12-16 20:23:16', '2024-12-16 20:36:45'), (40, 'PUNAM KUMARI', 'user', 'punampraveen95@gmail.com', NULL, '$2y$12$bjHzmSr8wHUluccVupKTUuJByUNyTpkTxygwTOzwIU9UIoCyCCAt6', 'Paid', 1, NULL, '2024-12-16 20:43:54', '2024-12-16 20:50:08'), (41, 'RADHA DEVI', 'user', 'radhaajeet19@gmail.com', NULL, '$2y$12$9OckAqhlRWUHZaSC4jZ4Au9J8KYvQAAqQT7A0tTDFQ.2aV9KCVnAS', 'Pending', 0, NULL, '2024-12-16 22:26:01', '2024-12-16 22:26:01'), (42, 'RENU DEVI', 'user', 'renutiwari.hzb1@gmail.com', NULL, '$2y$12$H4RcQKW6vXebHJ4LvwKyCO3oPgGe9obnS0bcaQQ1wJFkbhT0IH9S.', 'Pending', 0, NULL, '2024-12-16 22:51:22', '2024-12-16 22:51:22'), (43, 'Rinku Devi', 'user', 'shaillyk41@gmail.com', NULL, '$2y$12$LKEtYl.cnN5qZnhEWTViHO9dyFlWp5d8iRfVHP0t01zACRSYPjlbm', 'Pending', 0, NULL, '2024-12-17 18:22:23', '2024-12-17 18:22:23'), (44, 'AJAY KUMAR', 'user', 'krajay26@gmail.com', NULL, '$2y$12$8kIi0Ele6hZFIYtH4IKL9O8mEH3pGrgQj8u247N2D7CrbjP9PKMKa', 'Pending', 0, NULL, '2024-12-18 00:25:17', '2024-12-18 00:25:17'); -- -- Indexes for dumped tables -- -- -- Indexes for table `account_details` -- ALTER TABLE `account_details` ADD PRIMARY KEY (`id`); -- -- Indexes for table `autopools` -- ALTER TABLE `autopools` ADD PRIMARY KEY (`id`); -- -- Indexes for table `binary_trees` -- ALTER TABLE `binary_trees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `product_transactions` -- ALTER TABLE `product_transactions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `rank_levels` -- ALTER TABLE `rank_levels` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sponsors` -- ALTER TABLE `sponsors` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `account_details` -- ALTER TABLE `account_details` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `autopools` -- ALTER TABLE `autopools` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `binary_trees` -- ALTER TABLE `binary_trees` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `product_transactions` -- ALTER TABLE `product_transactions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `rank_levels` -- ALTER TABLE `rank_levels` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `sponsors` -- ALTER TABLE `sponsors` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;