-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jun 24, 2025 at 04:45 PM -- Server version: 10.11.13-MariaDB -- PHP Version: 8.3.22 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: `zgvdquyg_Newman001` -- -- -------------------------------------------------------- -- -- Table structure for table `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `balance` double(20,2) NOT NULL DEFAULT 0.00, `name` varchar(255) NOT NULL, `photo` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `salary_date` varchar(255) DEFAULT NULL, `type` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, `remember_token` varchar(100) 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 `admins` -- INSERT INTO `admins` (`id`, `balance`, `name`, `photo`, `email`, `email_verified_at`, `password`, `salary_date`, `type`, `phone`, `address`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 0.00, 'Md Admin', '/public/admin/assets/images/profile/1706650015HOx.png', 'admin@gmail.com', '2023-11-29 18:37:08', '$2y$10$M1LCj4sFCkq7eL6W49zX9u9EsgCRHpUFnDzH/3nsaltA6txcpF4bK', '2024-02-12', 'admin', '01600000000', 'sd', '75duujUbgiNiByBGyojcW0fEmiVbCmf8ZvRk2jnxhLheNkA6RwlLi0L5vYyb', '2023-11-28 11:11:57', '2025-06-23 12:41:56'), (3, 0.00, 'Md Admino', '/public/admin/assets/images/profile/1706650015HOx.png', 'admino@gmail.com', '2023-11-29 18:37:08', '$2y$10$W8i0gka.856tuQzNrIqRaO4TCXigF46D0STJuMzpMy26gQeFH4AC2', '2024-02-12', 'admin', '01600000000', 'sd', 'sPQxfzKmj1KeHxavVkBVyT1zMxwVPVJlryA4CUYG8VOZMAEiFMGaz6beSMBw', '2023-11-28 11:11:57', '2024-02-12 16:09:24'); -- -------------------------------------------------------- -- -- Table structure for table `admin_ledgers` -- CREATE TABLE `admin_ledgers` ( `id` bigint(20) UNSIGNED NOT NULL, `admin_id` bigint(20) UNSIGNED NOT NULL, `reason` varchar(255) NOT NULL, `perticulation` varchar(255) DEFAULT NULL, `amount` double NOT NULL DEFAULT 0, `debit` double NOT NULL DEFAULT 0, `credit` double NOT NULL DEFAULT 0, `status` enum('pending','approved','rejected','default') NOT NULL DEFAULT 'default', `date` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `admin_ledgers` -- INSERT INTO `admin_ledgers` (`id`, `admin_id`, `reason`, `perticulation`, `amount`, `debit`, `credit`, `status`, `date`, `created_at`, `updated_at`) VALUES (1, 1, 'payment_charge', 'Payment approval charge', 200, 0, 0, 'approved', '02-06-2025 21:41', '2025-06-03 02:41:50', '2025-06-03 02:41:50'), (2, 1, 'payment_charge', 'Payment approval charge', 80, 0, 0, 'approved', '02-06-2025 21:47', '2025-06-03 02:47:18', '2025-06-03 02:47:18'), (3, 1, 'payment_charge', 'Payment approval charge', 350, 0, 0, 'approved', '02-06-2025 21:57', '2025-06-03 02:57:30', '2025-06-03 02:57:30'), (4, 1, 'payment_charge', 'Payment approval charge', 1850, 0, 0, 'approved', '02-06-2025 22:39', '2025-06-03 03:39:14', '2025-06-03 03:39:14'), (5, 1, 'payment_charge', 'Payment approval charge', 280, 0, 0, 'approved', '02-06-2025 23:20', '2025-06-03 04:20:29', '2025-06-03 04:20:29'), (6, 1, 'payment_charge', 'Payment approval charge', 1850, 0, 0, 'approved', '03-06-2025 00:03', '2025-06-03 05:03:10', '2025-06-03 05:03:10'), (7, 1, 'payment_charge', 'Payment approval charge', 80, 0, 0, 'approved', '03-06-2025 06:25', '2025-06-03 11:25:30', '2025-06-03 11:25:30'), (8, 1, 'payment_charge', 'Payment approval charge', 350, 0, 0, 'approved', '03-06-2025 13:18', '2025-06-03 18:18:30', '2025-06-03 18:18:30'), (9, 1, 'payment_charge', 'Payment approval charge', 80, 0, 0, 'approved', '03-06-2025 13:55', '2025-06-03 18:55:31', '2025-06-03 18:55:31'), (10, 1, 'payment_charge', 'Payment approval charge', 120, 0, 0, 'approved', '03-06-2025 13:56', '2025-06-03 18:56:42', '2025-06-03 18:56:42'), (11, 1, 'payment_charge', 'Payment approval charge', 80, 0, 0, 'approved', '03-06-2025 13:57', '2025-06-03 18:57:00', '2025-06-03 18:57:00'), (12, 1, 'payment_charge', 'Payment approval charge', 50, 0, 0, 'approved', '03-06-2025 19:26', '2025-06-04 00:26:58', '2025-06-04 00:26:58'), (13, 1, 'payment_charge', 'Payment approval charge', 150, 0, 0, 'approved', '04-06-2025 00:22', '2025-06-04 05:22:41', '2025-06-04 05:22:41'), (14, 1, 'payment_charge', 'Payment approval charge', 120, 0, 0, 'approved', '04-06-2025 00:22', '2025-06-04 05:22:51', '2025-06-04 05:22:51'), (15, 1, 'payment_charge', 'Payment approval charge', 2000, 0, 0, 'approved', '22-06-2025 11:47', '2025-06-22 11:47:22', '2025-06-22 11:47:22'), (16, 1, 'payment_charge', 'Payment approval charge', 2000, 0, 0, 'approved', '22-06-2025 11:50', '2025-06-22 11:50:16', '2025-06-22 11:50:16'), (17, 1, 'payment_charge', 'Payment approval charge', 10000, 0, 0, 'approved', '23-06-2025 02:46', '2025-06-23 02:46:54', '2025-06-23 02:46:54'), (18, 1, 'payment_charge', 'Payment approval charge', 10000, 0, 0, 'approved', '23-06-2025 02:56', '2025-06-23 02:56:48', '2025-06-23 02:56:48'), (19, 1, 'payment_charge', 'Payment approval charge', 10000, 0, 0, 'approved', '23-06-2025 03:37', '2025-06-23 03:37:09', '2025-06-23 03:37:09'), (20, 1, 'payment_charge', 'Payment approval charge', 5000, 0, 0, 'approved', '23-06-2025 03:50', '2025-06-23 03:50:50', '2025-06-23 03:50:50'), (21, 1, 'payment_charge', 'Payment approval charge', 5000, 0, 0, 'approved', '23-06-2025 03:58', '2025-06-23 03:58:33', '2025-06-23 03:58:33'), (22, 1, 'payment_charge', 'Payment approval charge', 2000, 0, 0, 'approved', '23-06-2025 12:41', '2025-06-23 12:41:56', '2025-06-23 12:41:56'); -- -------------------------------------------------------- -- -- Table structure for table `bank` -- CREATE TABLE `bank` ( `id` int(11) NOT NULL, `full_name` text DEFAULT NULL, `phone_number` text DEFAULT NULL, `bank_account` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `bank_code` varchar(255) DEFAULT NULL, `ifsc` text DEFAULT NULL, `user_id` int(11) NOT NULL, `is_default` tinyint(1) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `bank` -- INSERT INTO `bank` (`id`, `full_name`, `phone_number`, `bank_account`, `bank_name`, `bank_code`, `ifsc`, `user_id`, `is_default`, `created_at`, `updated_at`) VALUES (1, 'HELLO USER', NULL, '00000000000', 'Sterling Bank PLC', '232', NULL, 1, 1, '2024-10-11 20:33:08', '2024-10-11 20:33:16'), (2, 'Ephraim Chima', NULL, '8144186852', 'Moniepoint Microfinance Bank', '090405', NULL, 2, 1, '2024-10-12 08:37:39', '2024-10-12 08:37:39'), (3, 'Chima Ephraim', NULL, '8144186852', 'Moniepoint Microfinance Bank', '090405', NULL, 3, 1, '2024-10-17 15:10:22', '2024-10-17 15:10:22'), (4, 'Michael Gbolahun Abiodun', NULL, '8126469927', 'Opay (Paycom)', '100004', NULL, 6, 1, '2024-10-19 10:37:33', '2024-10-19 10:37:33'), (5, 'KHAMIS ILIYASU', NULL, '8093469841', 'PALMPAY', '100033', NULL, 7, 1, '2024-10-19 11:37:26', '2024-10-19 11:37:26'), (6, 'Sunday morning', NULL, '8999069234', 'PALMPAY', '100033', NULL, 16, 1, '2024-10-19 11:42:33', '2024-10-19 11:50:11'), (7, 'Victor Ude Nduka', NULL, '8148733239', 'PALMPAY', '100033', NULL, 8, 0, '2024-10-19 11:43:39', '2024-10-19 11:43:39'), (8, 'Okoronkwor Justice Nnannaya', NULL, '8126130418', 'PALMPAY', '100033', NULL, 17, 1, '2024-10-19 11:44:33', '2024-10-19 11:44:33'), (9, 'Sophia nwoye', NULL, '9031957764', 'Opay (Paycom)', '100004', NULL, 23, 1, '2024-10-19 11:47:03', '2024-10-19 11:47:15'), (10, 'Kenechukwu celestine', NULL, '9063740063', 'Opay (Paycom)', '100004', NULL, 27, 0, '2024-10-19 11:49:14', '2024-10-19 11:49:14'), (11, 'Zamzam aweys muqtar', NULL, '37090767', 'Citi Bank', '023', NULL, 28, 0, '2024-10-19 11:52:25', '2024-10-19 11:52:34'), (12, 'OYOMA OKIJENU', NULL, '8135604502', 'Opay (Paycom)', '100004', NULL, 41, 0, '2024-10-19 11:52:36', '2024-10-19 11:52:44'), (13, 'Oluwagbemi Samuel Olusegun', NULL, '9017786011', 'Opay (Paycom)', '100004', NULL, 47, 1, '2024-10-19 11:52:55', '2024-10-19 11:53:05'), (14, '8167847577', NULL, '1000', 'PALMPAY', '100033', NULL, 45, 0, '2024-10-19 11:53:02', '2024-10-19 11:53:40'), (15, 'Alhaji bawa', NULL, '7073596475', 'Opay (Paycom)', '100004', NULL, 44, 0, '2024-10-19 11:53:10', '2024-10-19 11:53:17'), (16, 'Emmanuel Damilola Paul', NULL, '9017721894', 'Opay (Paycom)', '100004', NULL, 36, 0, '2024-10-19 11:53:43', '2024-10-19 11:53:43'), (17, 'Abbas Muhammad Saidu', NULL, '9132852754', 'Opay (Paycom)', '100004', NULL, 30, 1, '2024-10-19 11:54:07', '2024-10-19 11:54:07'), (18, 'Muhammad sulaiman umar', NULL, '9021309458', 'Opay (Paycom)', '100004', NULL, 49, 0, '2024-10-19 11:54:09', '2024-10-19 11:54:09'), (19, 'Hannah OGUEKHAN ISICHIE', NULL, '8067314033', 'Opay (Paycom)', '100004', NULL, 55, 1, '2024-10-19 11:54:17', '2024-10-19 11:54:17'), (20, 'Mary nnenna', NULL, '8079145355', 'Opay (Paycom)', '100004', NULL, 48, 1, '2024-10-19 11:54:46', '2024-10-19 11:54:46'), (21, 'Odo blessing ebere', NULL, '9077473317', 'Opay (Paycom)', '100004', NULL, 50, 0, '2024-10-19 11:55:16', '2024-10-19 11:55:16'), (22, 'Funmilayo Afolabi', NULL, '7046181610', 'Opay (Paycom)', '100004', NULL, 57, 1, '2024-10-19 11:56:00', '2024-10-19 11:56:00'), (23, 'Isife justus Odinaka', NULL, '8059992297', 'Opay (Paycom)', '100004', NULL, 42, 0, '2024-10-19 11:56:30', '2024-10-19 11:56:30'), (24, 'Oguno Ebube Bartholomew', NULL, '1025921944', 'First City Monument Bank', '214', NULL, 59, 0, '2024-10-19 11:57:01', '2024-10-19 11:59:12'), (25, 'Ndubueze Gift', NULL, '8130691386', 'Opay (Paycom)', '100004', NULL, 63, 0, '2024-10-19 11:58:08', '2024-10-19 11:58:08'), (26, 'Abubakar Ahmad Tijani', NULL, '0888697344', 'Guaranty Trust Bank', '058', NULL, 69, 0, '2024-10-19 12:01:49', '2024-10-19 12:01:49'), (27, 'Mohammed Bilal Suleiman', NULL, '9151221469', 'Opay (Paycom)', '100004', NULL, 64, 1, '2024-10-19 12:02:40', '2024-10-19 12:02:40'), (28, 'Isah Usman Rogun.', NULL, '8037849627', 'Opay (Paycom)', '100004', NULL, 76, 1, '2024-10-19 12:03:09', '2024-10-19 12:03:09'), (29, 'Muhammad Awwal Saeed', NULL, '8053997952', 'Opay (Paycom)', '100004', NULL, 74, 0, '2024-10-19 12:03:31', '2024-10-19 12:03:31'), (30, 'Olabiye Florence Funmilayo', NULL, '7083281164', 'Opay (Paycom)', '100004', NULL, 58, 0, '2024-10-19 12:03:32', '2024-10-19 12:03:32'), (31, 'Chima Joshua ogonna', NULL, '2337169032', 'United Bank for Africa', '033', NULL, 11, 1, '2024-10-19 12:04:04', '2024-10-19 12:04:04'), (32, 'Ameh praise', NULL, '8076090423', 'PALMPAY', '100033', NULL, 79, 0, '2024-10-19 12:05:27', '2024-10-19 12:05:27'), (33, 'TOSIN IDOWU', NULL, '9032596306', 'Opay (Paycom)', '100004', NULL, 82, 1, '2024-10-19 12:06:59', '2024-10-19 12:06:59'), (34, 'Muhammad jafar aminu', NULL, '8107965186', 'Opay (Paycom)', '100004', NULL, 12, 0, '2024-10-19 12:08:15', '2024-10-19 12:08:15'), (35, 'Mahmud Abdurrashid', NULL, '9033616988', 'PALMPAY', '100033', NULL, 87, 1, '2024-10-19 12:10:07', '2024-10-19 12:10:07'), (36, 'ogba ifeoma lucy', NULL, '8085388231', 'PALMPAY', '100033', NULL, 24, 1, '2024-10-19 12:14:16', '2024-10-19 12:14:16'), (37, 'Yushau Badaru Hashim', NULL, '9068415907', 'Opay (Paycom)', '100004', NULL, 83, 0, '2024-10-19 12:14:24', '2024-10-19 12:14:24'), (38, 'JEROME KWAGHGA KAUTER', NULL, '9045876828', 'Opay (Paycom)', '100004', NULL, 95, 1, '2024-10-19 12:14:45', '2024-10-19 12:14:50'), (39, 'NKEMDIRIM FELIX', NULL, '0029630490', 'Access Bank', '044', NULL, 91, 1, '2024-10-19 12:17:45', '2024-10-19 12:17:45'), (40, 'Chikamso Onuigbo Jude', NULL, '8153280019', 'PALMPAY', '100033', NULL, 107, 1, '2024-10-19 12:19:31', '2024-10-19 12:19:31'), (41, 'Abdussalam Bayaro', NULL, '7017119203', 'Opay (Paycom)', '100004', NULL, 105, 1, '2024-10-19 12:20:48', '2024-10-19 12:20:48'), (42, 'Ibiam oji Agha', NULL, '8101440009', 'Opay (Paycom)', '100004', NULL, 13, 1, '2024-10-19 12:21:16', '2024-10-19 12:27:19'), (43, 'HUSSEN KEHINDE AJIBOYE', NULL, '9060146628', 'Opay (Paycom)', '100004', NULL, 53, 0, '2024-10-19 12:27:17', '2024-10-19 12:27:17'), (44, 'Thankgod Ali', NULL, '9024678211', 'Opay (Paycom)', '100004', NULL, 114, 0, '2024-10-19 12:30:14', '2024-10-19 12:30:14'), (45, 'YUSUF Ahmed', NULL, '3202110757', 'First Bank PLC', '011', NULL, 111, 1, '2024-10-19 12:31:41', '2024-10-19 12:31:41'), (46, 'Ifunanya paece AGU', NULL, '9163672513', 'Opay (Paycom)', '100004', NULL, 73, 1, '2024-10-19 12:37:30', '2024-10-19 12:37:30'), (47, 'Owolabi Solomon Alaba', NULL, '8138994774', 'Opay (Paycom)', '100004', NULL, 123, 1, '2024-10-19 12:42:49', '2024-10-19 12:42:49'), (48, 'Gaddafi abdulhayatu', NULL, '9013615840', 'Opay (Paycom)', '100004', NULL, 125, 1, '2024-10-19 12:43:21', '2024-10-19 12:43:21'), (49, 'Hafsat yahaya mahaifitya', NULL, '9114820622', 'Opay (Paycom)', '100004', NULL, 126, 1, '2024-10-19 12:44:25', '2024-10-19 12:44:33'), (50, 'Chichetam Michael ogunka', NULL, '8038635957', 'PALMPAY', '100033', NULL, 128, 1, '2024-10-19 12:45:38', '2024-10-19 12:45:38'), (51, 'Collins chiwetalu Odo', NULL, '7041564309', 'PALMPAY', '100033', NULL, 130, 1, '2024-10-19 12:45:56', '2024-10-19 12:45:56'), (52, 'Odih Miriam chimereucheya', NULL, '8141966968', 'PALMPAY', '100033', NULL, 33, 1, '2024-10-19 12:47:16', '2024-10-19 12:47:16'), (53, 'AKinola feranmi rasak', NULL, '7061733678', 'Moniepoint Microfinance Bank', '090405', NULL, 119, 1, '2024-10-19 12:49:03', '2024-10-19 12:49:03'), (54, 'James Joseph', NULL, '8103290405', 'Moniepoint Microfinance Bank', '090405', NULL, 138, 0, '2024-10-19 12:50:13', '2024-10-19 12:50:13'), (55, 'James Joseph', NULL, '8103290405', 'Moniepoint Microfinance Bank', '090405', NULL, 138, 0, '2024-10-19 12:50:07', '2024-10-19 12:50:07'), (56, 'SYLVANUS ONYEMA ALIGWEKWE', NULL, '7049889245', 'PALMPAY', '100033', NULL, 141, 1, '2024-10-19 12:50:52', '2024-10-19 12:50:52'), (57, 'Muhydeen Shittu Kewulere', NULL, '9058608674', 'Opay (Paycom)', '100004', NULL, 26, 1, '2024-10-19 12:51:06', '2024-10-19 12:51:06'), (58, 'David Moses', NULL, '2470193680', 'Zenith bank PLC', '057', NULL, 139, 0, '2024-10-19 12:51:07', '2024-10-19 12:51:07'), (59, 'Kogolo-oseji Mark chukwudi', NULL, '1886090167', 'Access Bank', '044', NULL, 132, 1, '2024-10-19 12:51:31', '2024-10-19 12:51:31'), (60, 'Samod Olamide Obadun', NULL, '9076608871', 'Opay (Paycom)', '100004', NULL, 143, 1, '2024-10-19 12:52:22', '2024-10-19 12:52:22'), (61, 'Sajo oluwatoyin bosede', NULL, '3031744594', 'First Bank PLC', '011', NULL, 145, 1, '2024-10-19 12:53:02', '2024-10-19 12:53:02'), (62, 'Adebayo Basirat Abeke', NULL, '8115069171', 'Opay (Paycom)', '100004', NULL, 142, 0, '2024-10-19 12:54:10', '2024-10-19 12:54:15'), (63, 'Bello Auwal Garba', NULL, '9028463124', 'Opay (Paycom)', '100004', NULL, 149, 1, '2024-10-19 12:54:49', '2024-10-19 12:54:49'), (64, 'Peter Emmanuel abdul', NULL, '7035337966', 'Opay (Paycom)', '100004', NULL, 152, 0, '2024-10-19 12:57:07', '2024-10-19 12:57:07'), (65, 'Henry Edward', NULL, '1894253073', 'Access Bank', '044', NULL, 156, 1, '2024-10-19 13:00:03', '2024-10-19 13:00:03'), (66, 'Virgilio Jayson', NULL, '09519965958', 'Opay (Paycom)', '100004', NULL, 147, 0, '2024-10-19 13:00:19', '2024-10-19 13:00:19'), (67, 'Yusuf Ibrahim', NULL, '7073239827', 'PALMPAY', '100033', NULL, 158, 0, '2024-10-19 13:03:44', '2024-10-19 13:03:44'), (68, 'Charles Agha', NULL, '5631428183', 'Moniepoint Microfinance Bank', '090405', NULL, 162, 1, '2024-10-19 13:06:28', '2024-10-19 13:06:28'), (69, 'Gift uko Tom', NULL, '7040419534', 'PALMPAY', '100033', NULL, 163, 0, '2024-10-19 13:14:16', '2024-10-19 13:14:28'), (70, 'Lawal KEBIRU', NULL, '9151233325', 'Opay (Paycom)', '100004', NULL, 165, 1, '2024-10-19 13:14:22', '2024-10-19 13:14:22'), (71, 'Nwogbo kelvin ifechukwu', NULL, '8157320401', 'PALMPAY', '100033', NULL, 151, 1, '2024-10-19 13:18:08', '2024-10-19 13:18:47'), (72, 'Aleke precious somtochukwu', NULL, '9065143977', 'Opay (Paycom)', '100004', NULL, 169, 1, '2024-10-19 13:21:23', '2024-10-19 13:21:23'), (73, 'Aliyu Muhammad', NULL, '9115452085', 'PALMPAY', '100033', NULL, 122, 1, '2024-10-19 13:23:34', '2024-10-19 13:23:34'), (74, 'C-E GLOBAL TELECOMS', NULL, '8160849498', 'Moniepoint Microfinance Bank', '090405', NULL, 9, 1, '2024-10-19 13:27:48', '2024-10-19 13:27:54'), (75, 'Ilufoye Oluwatobi David', NULL, '8039314511', 'Opay (Paycom)', '100004', NULL, 157, 0, '2024-10-19 13:29:13', '2024-10-19 13:52:23'), (76, 'Ngozi livinue', NULL, '9125570763', 'Opay (Paycom)', '100004', NULL, 173, 1, '2024-10-19 13:32:00', '2024-10-19 13:32:10'), (77, 'OKECHUKWU IFEDIORAMMA OBINEGBO, Moniepoint MFB', NULL, '8163871110', 'Moniepoint Microfinance Bank', '090405', NULL, 172, 0, '2024-10-19 13:33:14', '2024-10-19 13:33:14'), (78, 'MUHAMMED ZAINAB', NULL, '7039925454', 'Opay (Paycom)', '100004', NULL, 180, 1, '2024-10-19 13:45:21', '2024-10-19 13:45:38'), (79, 'Igbokwe chineze', NULL, '7019728548', 'Opay (Paycom)', '100004', NULL, 183, 0, '2024-10-19 13:49:34', '2024-10-19 13:49:34'), (80, 'IFEOLUWA OLAOLUWA MBASHIRU', NULL, '8118346020', 'Opay (Paycom)', '100004', NULL, 181, 1, '2024-10-19 13:56:24', '2024-10-19 13:56:24'), (81, 'Gladys Jimmy', NULL, '6670927244', 'Fidelity Bank', '070', NULL, 188, 0, '2024-10-19 13:57:33', '2024-10-19 13:57:33'), (82, 'Philip Solomon', NULL, '9156064608', 'Opay (Paycom)', '100004', NULL, 190, 1, '2024-10-19 13:58:56', '2024-10-19 13:58:56'), (83, 'Atanda Taiwo adebusoye', NULL, '7038546144', 'PALMPAY', '100033', NULL, 184, 0, '2024-10-19 14:01:31', '2024-10-19 14:01:31'), (84, 'Osarehreh Paul Agbonlahor', NULL, '907 376 0906', 'PALMPAY', '100033', NULL, 197, 1, '2024-10-19 14:08:19', '2024-10-19 14:08:19'), (85, 'Azubuike Rooseveli Ozioma', NULL, '8081416940', 'Opay (Paycom)', '100004', NULL, 198, 1, '2024-10-19 14:10:51', '2024-10-19 14:10:56'), (86, 'Ramon adeleke jimoh', NULL, '9120893919', 'PALMPAY', '100033', NULL, 103, 1, '2024-10-19 14:14:08', '2024-10-19 14:14:14'), (87, 'Oladele funmilayo mary', NULL, '9139650002', 'Opay (Paycom)', '100004', NULL, 205, 1, '2024-10-19 14:16:15', '2024-10-19 14:16:15'), (88, 'Jamiu Muhammed opeyemi', NULL, '9068874704', 'Opay (Paycom)', '100004', NULL, 202, 1, '2024-10-19 14:16:39', '2024-10-19 14:17:30'), (89, 'Uwadiale endurance', NULL, '2110975115', 'United Bank for Africa', '033', NULL, 99, 0, '2024-10-19 14:16:48', '2024-10-19 14:16:48'), (90, 'Victor chukwuemelie', NULL, '2177905447', 'United Bank for Africa', '033', NULL, 213, 0, '2024-10-19 14:19:50', '2024-10-19 14:19:50'), (91, 'Chinaza joy Okonkwo', NULL, '9035287671', 'Opay (Paycom)', '100004', NULL, 206, 1, '2024-10-19 14:20:15', '2024-10-19 14:20:24'), (92, 'Omolade Hezekiah Aladenusi', NULL, '9159001306', 'Opay (Paycom)', '100004', NULL, 214, 0, '2024-10-19 14:23:15', '2024-10-19 14:23:15'), (93, 'John Anvah isa', NULL, '7062340094', 'Opay (Paycom)', '100004', NULL, 217, 0, '2024-10-19 14:24:49', '2024-10-19 14:24:49'), (94, 'ISAAC SAMUEL EZEKIEL', NULL, '7064922912', 'PALMPAY', '100033', NULL, 218, 1, '2024-10-19 14:27:18', '2024-10-19 14:27:18'), (95, 'Afeez ajani basiru', NULL, '9030965512', 'Opay (Paycom)', '100004', NULL, 187, 1, '2024-10-19 14:27:30', '2024-10-19 14:27:30'), (96, 'opara thaddeus ucheoma', NULL, '8092580011', 'Opay (Paycom)', '100004', NULL, 210, 0, '2024-10-19 14:27:34', '2024-10-19 14:27:34'), (97, 'Chigozie chukwuma', NULL, '2064980298', 'Kuda', '090267', NULL, 220, 0, '2024-10-19 14:29:38', '2024-10-19 14:29:38'), (98, 'MUKTHAR BUDE', NULL, '9123714999', 'Opay (Paycom)', '100004', NULL, 221, 0, '2024-10-19 14:31:03', '2024-10-19 14:31:03'), (99, 'Murja haruna', NULL, '9018215011', 'PALMPAY', '100033', NULL, 228, 0, '2024-10-19 14:35:25', '2024-10-19 14:35:25'), (100, 'Elvis Kenechukwu', NULL, '7072185707', 'Opay (Paycom)', '100004', NULL, 223, 0, '2024-10-19 14:37:31', '2024-10-19 14:37:31'), (101, 'Deborah Dupe Aigbologa', NULL, '7038608651', 'Opay (Paycom)', '100004', NULL, 227, 1, '2024-10-19 14:39:39', '2024-10-19 14:39:39'), (102, 'Marvelous', NULL, '8162799120', 'Opay (Paycom)', '100004', NULL, 222, 0, '2024-10-19 14:41:08', '2024-10-19 14:41:08'), (103, 'Rahmatu kolos', NULL, '0778476085', 'Access Bank', '044', NULL, 229, 0, '2024-10-19 14:42:35', '2024-10-19 14:42:35'), (104, 'IYANUOLUWA ENOCH ALUKO', NULL, '8107038937', 'PALMPAY', '100033', NULL, 231, 1, '2024-10-19 14:42:52', '2024-10-19 14:42:52'), (105, 'Stella Adenola', NULL, '8075821248', 'Opay (Paycom)', '100004', NULL, 238, 1, '2024-10-19 14:47:41', '2024-10-19 14:47:41'), (106, 'Njoku ugochi', NULL, '8057202303', 'PALMPAY', '100033', NULL, 164, 1, '2024-10-19 14:49:20', '2024-10-19 14:49:20'), (107, 'ISAAC SAMUEL EZEKIEL', NULL, '7064922912', 'PALMPAY', '100033', NULL, 239, 1, '2024-10-19 14:52:59', '2024-10-19 14:52:59'), (108, 'Wizzy young', NULL, '8121712590', 'PALMPAY', '100033', NULL, 249, 1, '2024-10-19 14:57:27', '2024-10-19 14:57:32'), (109, 'Shola sefie Adeleke', NULL, '7049189589', 'Opay (Paycom)', '100004', NULL, 251, 1, '2024-10-19 15:00:24', '2024-10-19 15:00:24'), (110, 'Mudasir Akanni Abdulsalam', NULL, '8148627678', 'Opay (Paycom)', '100004', NULL, 248, 0, '2024-10-19 15:01:08', '2024-10-19 15:01:08'), (111, 'Taiwo Jesufunmilayo Omolola', NULL, '2226795074', 'United Bank for Africa', '033', NULL, 253, 0, '2024-10-19 15:03:26', '2024-10-19 15:03:26'), (112, 'Joy Goodluck Athenecious', NULL, '7045846559', 'Opay (Paycom)', '100004', NULL, 258, 1, '2024-10-19 15:13:00', '2024-10-19 15:13:00'), (113, 'Eleazar Success', NULL, '7016564501', 'Opay (Paycom)', '100004', NULL, 29, 0, '2024-10-19 15:17:28', '2024-10-19 15:17:28'), (114, 'Agbaje habeeb akorede', NULL, '1864226687', 'Access Bank', '044', NULL, 262, 1, '2024-10-19 15:18:14', '2024-10-19 15:18:14'), (115, 'Joy Uchenna umezuluike', NULL, '9046218413', 'PALMPAY', '100033', NULL, 207, 1, '2024-10-19 15:20:58', '2024-10-19 15:20:58'), (116, 'Akanni ayo nurein', NULL, '7043250101', 'PALMPAY', '100033', NULL, 264, 1, '2024-10-19 15:21:33', '2024-10-19 15:21:33'), (117, 'Ochume Paul', NULL, '9025050446', 'Opay (Paycom)', '100004', NULL, 272, 1, '2024-10-19 15:37:59', '2024-10-19 15:37:59'), (118, 'Matdozee Mathew', NULL, '7088442063', 'Opay (Paycom)', '100004', NULL, 266, 0, '2024-10-19 15:38:50', '2024-10-19 15:38:50'), (119, 'Muhammad sunusi', NULL, '8107294186', 'Moniepoint Microfinance Bank', '090405', NULL, 274, 1, '2024-10-19 15:46:06', '2024-10-20 13:51:25'), (120, 'Alamu goodness oluwaseyi', NULL, '8135297024', 'PALMPAY', '100033', NULL, 280, 1, '2024-10-19 15:48:41', '2024-10-19 22:46:19'), (121, 'Ibrahim kabiru', NULL, '7069599307', 'PALMPAY', '100033', NULL, 281, 0, '2024-10-19 15:53:42', '2024-10-19 15:53:42'), (122, 'RHOKEED OLAKUNLE OLAKUNLE AMIDU', NULL, '9150796610', 'PALMPAY', '100033', NULL, 286, 1, '2024-10-19 16:16:29', '2024-10-19 16:16:29'), (123, 'Gafar hiqmot olaitan', NULL, '8061613905', 'PALMPAY', '100033', NULL, 285, 1, '2024-10-19 16:16:51', '2024-10-19 16:16:59'), (124, 'Emmanuel Olamilekan Akinyemi', NULL, '8063683696', 'Moniepoint Microfinance Bank', '090405', NULL, 289, 1, '2024-10-19 16:17:46', '2024-10-19 16:17:46'), (125, 'Joyce Chioma Ezekiel', NULL, '7064855767', 'PALMPAY', '100033', NULL, 290, 1, '2024-10-19 16:20:40', '2024-10-19 16:20:40'), (126, 'OMOLARA ANIFAT DARAMOLA', NULL, '9166095083', 'PALMPAY', '100033', NULL, 291, 1, '2024-10-19 16:23:51', '2024-10-19 16:23:51'), (127, 'Omoniyi sodiq kayode', NULL, '9069033707', 'Opay (Paycom)', '100004', NULL, 288, 1, '2024-10-19 16:25:18', '2024-10-19 16:25:18'), (128, 'Nnabuchi chigozie wisdom', NULL, '8054193830', 'Opay (Paycom)', '100004', NULL, 292, 1, '2024-10-19 16:27:18', '2024-10-19 16:27:18'), (129, 'Aso Precious Ndukwe', NULL, '3200010918', 'First Bank PLC', '011', NULL, 297, 1, '2024-10-19 16:36:58', '2024-10-19 16:36:58'), (130, 'Chinedu', NULL, '7047650285', 'PALMPAY', '100033', NULL, 301, 0, '2024-10-19 16:37:36', '2024-10-19 16:37:36'), (131, 'Ama sosiachiike Joseph', NULL, '8131013542', 'Opay (Paycom)', '100004', NULL, 304, 1, '2024-10-19 16:39:30', '2024-10-19 16:39:35'), (132, 'Helen Mary braimoh', NULL, '7038440774', 'Opay (Paycom)', '100004', NULL, 302, 1, '2024-10-19 16:39:33', '2024-10-19 16:39:33'), (133, 'Blessing Ekanem', NULL, '0023511175', 'Access Bank', '044', NULL, 303, 1, '2024-10-19 16:48:23', '2024-10-19 16:48:23'), (134, 'Abdulsalam Muhammad', NULL, '2228308586', 'United Bank for Africa', '033', NULL, 310, 0, '2024-10-19 17:03:39', '2024-10-19 17:03:39'), (135, 'AMAECHI MOSES AMOS', NULL, '6100322158', 'Opay (Paycom)', '100004', NULL, 312, 1, '2024-10-19 17:08:38', '2024-10-19 17:08:38'), (136, 'Sani saadu', NULL, '5776293091', 'Moniepoint Microfinance Bank', '090405', NULL, 313, 0, '2024-10-19 17:10:21', '2024-10-19 17:10:21'), (137, 'Aishatu yakubu', NULL, '3090409092', 'Access Bank', '044', NULL, 315, 1, '2024-10-19 17:13:27', '2024-10-19 17:13:27'), (138, 'Ganiyu Momodu', NULL, '9028942060', 'Opay (Paycom)', '100004', NULL, 317, 1, '2024-10-19 17:13:51', '2024-10-19 17:13:56'), (139, 'Obaje Christiana', NULL, '9134035398', 'Opay (Paycom)', '100004', NULL, 321, 0, '2024-10-19 17:17:48', '2024-10-19 17:17:48'), (140, 'Deborah Nwaonyeukwu', NULL, '7043312383', 'Opay (Paycom)', '100004', NULL, 330, 0, '2024-10-19 17:21:07', '2024-10-19 17:35:15'), (141, 'Ruth Bassey Godwin', NULL, '907447104', 'PALMPAY', '100033', NULL, 327, 1, '2024-10-19 17:21:33', '2024-10-19 17:21:33'), (142, 'Folorunso Goodness Nifemi', NULL, '1055987473', 'Polaris bank', '076', NULL, 331, 1, '2024-10-19 17:21:58', '2024-10-19 17:21:58'), (143, 'iyanuoluwa daniel idowu', NULL, '1895674451', 'Access Bank', '044', NULL, 325, 1, '2024-10-19 17:22:21', '2024-10-19 17:22:21'), (144, 'ABDULRASHEED LANRE AYANNIYI', NULL, '5754550952', 'Moniepoint Microfinance Bank', '090405', NULL, 329, 0, '2024-10-19 17:25:16', '2024-10-19 17:25:16'), (145, 'Uduak otobong john', NULL, '8168591247', 'Opay (Paycom)', '100004', NULL, 337, 1, '2024-10-19 17:27:50', '2024-10-19 17:27:50'), (146, 'Bosede ibidunmoye christianah', NULL, '7066514215', 'Opay (Paycom)', '100004', NULL, 336, 0, '2024-10-19 17:28:04', '2024-10-19 17:31:27'), (147, 'Rofiyat idowu abike', NULL, '9054167913', 'PALMPAY', '100033', NULL, 338, 1, '2024-10-19 17:31:43', '2024-10-19 17:31:49'), (148, 'Godspower ikechukwu Enumah', NULL, '7019859346', 'PALMPAY', '100033', NULL, 341, 1, '2024-10-19 17:36:18', '2024-10-19 17:36:18'), (149, 'TAWAKALITU ADEOLA ZAKARIYAH', NULL, '8035150603', 'Opay (Paycom)', '100004', NULL, 342, 1, '2024-10-19 17:47:45', '2024-10-19 17:47:45'), (150, 'WISDOM EDOH SHAIBU', NULL, '8064510764', 'Opay (Paycom)', '100004', NULL, 65, 0, '2024-10-19 17:57:59', '2024-10-19 17:57:59'), (151, 'Glory Joshua', NULL, '9032101793', 'Opay (Paycom)', '100004', NULL, 263, 1, '2024-10-19 18:05:12', '2024-10-19 18:05:20'), (152, 'Aaron Reuben danladi', NULL, '8126307698', 'Opay (Paycom)', '100004', NULL, 339, 0, '2024-10-19 18:05:48', '2024-10-19 18:05:48'), (153, 'Mary moses', NULL, '8134114844', 'PALMPAY', '100033', NULL, 349, 0, '2024-10-19 18:06:19', '2024-10-19 18:06:19'), (154, 'AYOADE PEACE ADENIRAN', NULL, '9127067266', 'PALMPAY', '100033', NULL, 350, 1, '2024-10-19 18:06:40', '2024-10-19 18:06:40'), (155, 'Godspower ikechukwu Enumah', NULL, '9033286328', 'Opay (Paycom)', '100004', NULL, 352, 1, '2024-10-19 18:11:56', '2024-10-19 18:11:56'), (156, 'Zuwaira Abdullahi', NULL, '9164353148', 'PALMPAY', '100033', NULL, 354, 0, '2024-10-19 18:17:21', '2024-10-19 18:17:56'), (157, 'Oluwayemisi Maria shonde', NULL, '7040958067', 'Opay (Paycom)', '100004', NULL, 356, 1, '2024-10-19 18:19:02', '2024-10-19 18:19:08'), (158, 'AMINAT KABIRU', NULL, '9039386821', 'Opay (Paycom)', '100004', NULL, 360, 1, '2024-10-19 18:27:42', '2024-10-19 18:27:51'), (159, 'Ikpe Samuel Onahi', NULL, '8130879464', 'Opay (Paycom)', '100004', NULL, 361, 1, '2024-10-19 18:33:10', '2024-10-19 18:33:10'), (160, 'Yakubu Yusuf', NULL, '8023976201', 'Opay (Paycom)', '100004', NULL, 364, 1, '2024-10-19 18:42:18', '2024-10-19 18:42:36'), (161, 'Ibrahim abdullahi', NULL, '7026263322', 'Opay (Paycom)', '100004', NULL, 366, 1, '2024-10-19 18:43:43', '2024-10-19 18:43:43'), (162, 'YAHAYA ZAID', NULL, '0725847459', 'Guaranty Trust Bank', '058', NULL, 367, 1, '2024-10-19 18:44:50', '2024-10-19 18:44:50'), (163, 'EChezonachi', NULL, '8060217158', 'Opay (Paycom)', '100004', NULL, 363, 1, '2024-10-19 18:47:04', '2024-10-19 18:47:20'), (164, 'Muhammad Hassan Umar', NULL, '8024490288', 'Opay (Paycom)', '100004', NULL, 371, 0, '2024-10-19 18:59:27', '2024-10-19 18:59:37'), (165, 'hudu shehu', NULL, '8083509381', 'Opay (Paycom)', '100004', NULL, 370, 1, '2024-10-19 19:00:29', '2024-10-19 19:00:29'), (166, 'Rose Okorie Assem', NULL, '8169387748', 'Opay (Paycom)', '100004', NULL, 372, 0, '2024-10-19 19:09:41', '2024-10-19 19:09:41'), (167, 'Suleiman mujaid Akanji', NULL, '8060353408', 'PALMPAY', '100033', NULL, 376, 1, '2024-10-19 19:14:01', '2024-10-19 19:14:01'), (168, 'Tawakalitu akanni', NULL, '8168737611', 'Opay (Paycom)', '100004', NULL, 377, 1, '2024-10-19 19:14:33', '2024-10-19 19:14:33'), (169, 'Tolani opeyemi oladapo', NULL, '9048937235', 'Opay (Paycom)', '100004', NULL, 375, 1, '2024-10-19 19:18:47', '2024-10-19 19:18:47'), (170, 'Mahmuda Umar', NULL, '9032656224', 'Opay (Paycom)', '100004', NULL, 378, 1, '2024-10-19 19:23:58', '2024-10-19 19:23:58'), (171, 'Ismail Abubakar', NULL, '6114815095', 'Opay (Paycom)', '100004', NULL, 379, 0, '2024-10-19 19:26:09', '2024-10-19 19:27:36'), (172, 'Agnes Adekemi', NULL, '9036177936', 'PALMPAY', '100033', NULL, 374, 1, '2024-10-19 19:33:36', '2024-10-19 19:33:36'), (173, 'Saminu Usaini sabiu', NULL, '7049635748', 'Opay (Paycom)', '100004', NULL, 384, 1, '2024-10-19 19:40:44', '2024-10-19 19:41:23'), (174, 'Mizbahu Tukur', NULL, '9046657548', 'PALMPAY', '100033', NULL, 385, 1, '2024-10-19 19:48:41', '2024-10-19 19:55:31'), (175, 'Smith Ololade', NULL, '8061796498', 'Opay (Paycom)', '100004', NULL, 393, 1, '2024-10-19 20:20:42', '2024-10-19 20:21:05'), (176, 'Comfort easter Fred', NULL, '8025630306', 'Opay (Paycom)', '100004', NULL, 396, 0, '2024-10-19 20:24:06', '2024-10-19 20:24:06'), (177, 'Hamza Abdulkhaleek Adavize', NULL, '9129535375', 'Opay (Paycom)', '100004', NULL, 397, 0, '2024-10-19 20:24:11', '2024-10-19 20:24:11'), (178, 'Patience OKON UKPONG', NULL, '0022657818', 'Stanbic IBTC Bank', '221', NULL, 241, 0, '2024-10-19 20:28:39', '2024-10-19 20:28:39'), (179, 'Umejiuba Amaka', NULL, '7060539617', 'Opay (Paycom)', '100004', NULL, 405, 0, '2024-10-19 20:43:37', '2024-10-19 20:43:37'), (180, '1000', NULL, '8132663747', 'PALMPAY', '100033', NULL, 404, 1, '2024-10-19 20:45:22', '2024-10-19 20:45:22'), (181, 'Kazeem Nofisat', NULL, '7080722792', 'Opay (Paycom)', '100004', NULL, 390, 0, '2024-10-19 20:48:45', '2024-10-20 01:12:41'), (182, 'Ziyaulhaq salisu', NULL, '2271169613', 'Zenith bank PLC', '057', NULL, 409, 1, '2024-10-19 20:51:40', '2024-10-19 20:51:40'), (183, 'Moses Akpan', NULL, '7039767215', 'Opay (Paycom)', '100004', NULL, 414, 0, '2024-10-19 21:11:37', '2024-10-19 21:11:37'), (184, 'Okonkwo Mary jane chinelo', NULL, '9011370603', 'Opay (Paycom)', '100004', NULL, 380, 1, '2024-10-19 21:11:47', '2024-10-19 21:11:47'), (185, 'Elizabeth Azeta', NULL, '8902220824', 'PALMPAY', '100033', NULL, 411, 0, '2024-10-19 21:15:16', '2024-10-19 21:15:16'), (186, 'Peter Ozoemena Okeke', NULL, '9041103269', 'PALMPAY', '100033', NULL, 416, 1, '2024-10-19 21:23:01', '2024-10-19 21:23:01'), (187, 'Okatahi hamza', NULL, '9123417190', 'PALMPAY', '100033', NULL, 419, 0, '2024-10-19 21:24:24', '2024-10-19 21:24:24'), (188, 'Odewale olamilekan wahab', NULL, '9043116700', 'Opay (Paycom)', '100004', NULL, 422, 0, '2024-10-19 21:24:52', '2024-10-19 21:24:52'), (189, 'Ogunsolu Gbolowaga Victoria', NULL, '8160856511', 'Opay (Paycom)', '100004', NULL, 418, 1, '2024-10-19 21:26:18', '2024-10-19 21:26:18'), (190, 'Favour chiamaka oruche', NULL, '8101747443', 'PALMPAY', '100033', NULL, 423, 0, '2024-10-19 21:26:59', '2024-10-19 21:26:59'), (191, 'Monica sunday', NULL, '9167425619', 'PALMPAY', '100033', NULL, 424, 1, '2024-10-19 21:28:05', '2024-10-19 21:28:13'), (192, 'Osain promise holy', NULL, '7075757464', 'Opay (Paycom)', '100004', NULL, 428, 1, '2024-10-19 21:38:00', '2024-10-19 21:38:00'), (193, 'Daniel Chibuike John', NULL, '7085569134', 'Opay (Paycom)', '100004', NULL, 432, 0, '2024-10-19 21:46:40', '2024-10-19 21:46:40'), (194, 'Rabiatu Yahaya', NULL, '7083533672', 'Moniepoint Microfinance Bank', '090405', NULL, 427, 0, '2024-10-19 21:51:29', '2024-10-19 21:51:29'), (195, 'FAVOUR IGWE KALU', NULL, '09072590333', 'PALMPAY', '100033', NULL, 435, 1, '2024-10-19 21:52:18', '2024-10-19 21:52:18'), (196, 'Ademola Adedeji Adepoju', NULL, '9123428028', 'Opay (Paycom)', '100004', NULL, 425, 1, '2024-10-19 21:56:54', '2024-10-19 21:57:11'), (197, 'ABIODUN ODUBIYI ADETOMOBI', NULL, '9048758619', 'Opay (Paycom)', '100004', NULL, 437, 0, '2024-10-19 21:58:50', '2024-10-19 21:58:50'), (198, 'Lawal isiaka olayide', NULL, '9167961784', 'Opay (Paycom)', '100004', NULL, 442, 1, '2024-10-19 22:04:12', '2024-10-19 22:04:12'), (199, 'Maureen adaobi Udemmadu', NULL, '8926054444', 'PALMPAY', '100033', NULL, 444, 1, '2024-10-19 22:22:44', '2024-10-19 22:22:44'), (200, 'Fabian Gbargbar', NULL, '7067367011', 'Opay (Paycom)', '100004', NULL, 450, 0, '2024-10-19 22:32:51', '2024-10-19 22:32:51'), (201, 'ALIYU SHUAIBU', NULL, '9033121649', 'Opay (Paycom)', '100004', NULL, 383, 1, '2024-10-19 22:40:00', '2024-10-19 22:40:13'), (202, 'Saturday Iboi', NULL, '9023062413', 'PALMPAY', '100033', NULL, 199, 0, '2024-10-19 22:44:01', '2024-10-19 22:44:01'), (203, 'Rabiatu Yahaya', NULL, '1428643879', 'Access Bank', '044', NULL, 455, 0, '2024-10-19 22:53:16', '2024-10-19 22:53:16'), (204, 'BARKA HUSSAINI', NULL, '7015226797', 'Opay (Paycom)', '100004', NULL, 447, 1, '2024-10-19 22:56:13', '2024-10-19 22:56:51'), (205, 'Emmanuel Enyinnaya Oruonye', NULL, '8144780429', 'Moniepoint Microfinance Bank', '090405', NULL, 460, 1, '2024-10-19 23:18:38', '2024-10-19 23:18:38'), (206, 'Godfrey Bitrus Buba', NULL, '8162317434', 'PALMPAY', '100033', NULL, 461, 1, '2024-10-19 23:24:29', '2024-10-19 23:24:29'), (207, 'Adujah Ebenezer', NULL, '8109288282', 'Opay (Paycom)', '100004', NULL, 256, 1, '2024-10-19 23:27:38', '2024-10-19 23:27:45'), (208, 'Aliyu Ibrahim', NULL, '7067457033', 'Opay (Paycom)', '100004', NULL, 464, 1, '2024-10-19 23:33:02', '2024-10-19 23:33:05'), (209, 'Oladimeji dorcas oluwakemi', NULL, '7083888532', 'PALMPAY', '100033', NULL, 467, 0, '2024-10-19 23:41:37', '2024-10-19 23:41:37'), (210, 'Peace Jonathan', NULL, '8062820152', 'Opay (Paycom)', '100004', NULL, 466, 1, '2024-10-19 23:42:54', '2024-10-19 23:42:54'), (211, 'WANDOO HANNAH ANENGA', NULL, '8122368024', 'PALMPAY', '100033', NULL, 127, 1, '2024-10-19 23:44:33', '2024-10-19 23:44:33'), (212, 'Ijeoma Esther chukwujekwu', NULL, '7077027125', 'Opay (Paycom)', '100004', NULL, 391, 0, '2024-10-19 23:49:19', '2024-10-19 23:49:19'), (213, 'Janet Omobolanle Dairo', NULL, '7080589668', 'Opay (Paycom)', '100004', NULL, 189, 0, '2024-10-19 23:53:08', '2024-10-19 23:53:08'), (214, 'Fahat Bello Abdullahi', NULL, '8186742887', 'PALMPAY', '100033', NULL, 470, 0, '2024-10-19 23:57:22', '2024-10-19 23:57:22'), (215, 'Adamu Alhaji Bawa', NULL, '9169941642', 'Moniepoint Microfinance Bank', '090405', NULL, 471, 0, '2024-10-19 23:59:49', '2024-10-19 23:59:49'), (216, 'Usman Nasiru', NULL, '7041690061', 'Moniepoint Microfinance Bank', '090405', NULL, 478, 0, '2024-10-20 00:51:28', '2024-10-20 00:51:28'), (217, 'ARINZE EGWU OKPANI', NULL, '6670702720', 'Fidelity Bank', '070', NULL, 479, 1, '2024-10-20 01:03:32', '2024-10-20 01:04:26'), (218, 'LEECHI SAMADINA AHAMEFULA', NULL, '2314129802', 'United Bank for Africa', '033', NULL, 481, 0, '2024-10-20 01:13:55', '2024-10-20 01:13:55'), (219, 'Nuraddin surajo', NULL, '8139093208', 'Opay (Paycom)', '100004', NULL, 483, 1, '2024-10-20 01:15:13', '2024-10-20 01:15:13'), (220, 'Mubarak Umar', NULL, '8032152482', 'Opay (Paycom)', '100004', NULL, 484, 0, '2024-10-20 01:30:28', '2024-10-20 01:30:28'), (221, 'Mikailu siraja', NULL, '8061713711', 'PALMPAY', '100033', NULL, 486, 0, '2024-10-20 02:41:18', '2024-10-20 02:41:18'), (222, 'Francis chukwuebuka ogbonna', NULL, '7047358889', 'Opay (Paycom)', '100004', NULL, 488, 1, '2024-10-20 05:32:04', '2024-10-20 05:32:04'), (223, 'Abdulsalam FATIU ABAYOMI', NULL, '9029276965', 'Opay (Paycom)', '100004', NULL, 490, 1, '2024-10-20 05:57:39', '2024-10-20 05:57:47'), (224, 'Smartcash', NULL, '7080256110', 'Access Bank', '044', NULL, 492, 0, '2024-10-20 06:06:29', '2024-10-20 12:03:44'), (225, 'Atafiagboi Samuel Morrison', NULL, '9063658083', 'Opay (Paycom)', '100004', NULL, 468, 0, '2024-10-20 06:15:58', '2024-10-20 06:16:05'), (226, 'Gift iroegbu', NULL, '7086593231', 'PALMPAY', '100033', NULL, 493, 0, '2024-10-20 06:18:20', '2024-10-20 06:18:20'), (227, 'Nelson Samuel', NULL, '8115110441', 'PALMPAY', '100033', NULL, 498, 1, '2024-10-20 06:41:12', '2024-10-20 06:41:12'), (228, 'Otori oyiza umilihier', NULL, '8139147020', 'PALMPAY', '100033', NULL, 496, 1, '2024-10-20 06:41:47', '2024-10-20 06:41:47'), (229, 'Emmanuel jatau danlami', NULL, '9121741782', 'Opay (Paycom)', '100004', NULL, 500, 1, '2024-10-20 06:59:54', '2024-10-20 06:59:54'), (230, 'OJO GODWIN', NULL, '7026101200', 'PALMPAY', '100033', NULL, 504, 1, '2024-10-20 07:12:10', '2024-10-20 07:12:10'), (231, 'Ezeobi precious mmesoma', NULL, '9112663755', 'Opay (Paycom)', '100004', NULL, 510, 1, '2024-10-20 07:40:19', '2024-10-20 07:40:19'), (232, 'Makolo Isaac ojodomo', NULL, '2053445746', 'Kuda', '090267', NULL, 499, 0, '2024-10-20 07:42:22', '2024-10-20 07:42:22'), (233, 'Beatrice mosomi', NULL, '8137834564', 'PALMPAY', '100033', NULL, 513, 1, '2024-10-20 08:12:09', '2024-10-20 08:12:09'), (234, 'Jenny Sylvanus Warrie', NULL, '7038500448', 'Opay (Paycom)', '100004', NULL, 512, 1, '2024-10-20 08:15:03', '2024-10-20 08:15:03'), (235, 'Samuel Adefalujo', NULL, '8084243365', 'Opay (Paycom)', '100004', NULL, 515, 0, '2024-10-20 08:24:48', '2024-10-20 08:24:48'), (236, 'Favour igwebuike oko', NULL, '9167065982', 'Opay (Paycom)', '100004', NULL, 309, 1, '2024-10-20 08:32:34', '2024-10-20 08:32:34'), (237, 'Uduak Asuquo Imo', NULL, '7044917013', 'Opay (Paycom)', '100004', NULL, 519, 1, '2024-10-20 08:52:35', '2024-10-20 08:52:35'), (238, 'ABDURRRAHMAN MUHAMMAD SANI', NULL, '7034189672', 'Opay (Paycom)', '100004', NULL, 457, 1, '2024-10-20 08:55:31', '2024-10-20 08:56:11'), (239, 'Uba', NULL, '2292895377', 'United Bank for Africa', '033', NULL, 520, 0, '2024-10-20 09:00:42', '2024-10-20 09:00:42'), (240, 'Gift Elisha', NULL, '2285880012', 'Zenith bank PLC', '057', NULL, 526, 1, '2024-10-20 09:16:50', '2024-10-20 09:16:50'), (241, 'Friday emmanuel', NULL, '8023937793', 'Opay (Paycom)', '100004', NULL, 525, 0, '2024-10-20 09:18:26', '2024-10-20 09:18:26'), (242, 'Igonor Princess', NULL, '8069788116', 'PALMPAY', '100033', NULL, 527, 1, '2024-10-20 09:21:41', '2024-10-20 09:21:41'), (243, 'Daniel ita', NULL, '9058451624', 'Opay (Paycom)', '100004', NULL, 358, 0, '2024-10-20 09:38:52', '2024-10-20 09:38:52'), (244, 'Mohammed Abdulkadir', NULL, '9024996438', 'Opay (Paycom)', '100004', NULL, 530, 0, '2024-10-20 09:39:25', '2024-10-20 09:39:25'), (245, 'titilayo morenikeji', NULL, '9031727187', 'PALMPAY', '100033', NULL, 277, 0, '2024-10-20 09:46:23', '2024-10-20 09:46:23'), (246, 'UMAR FARUQ ENIOLA OLAWALE', NULL, '2053350280', 'Zenith bank PLC', '057', NULL, 532, 0, '2024-10-20 09:49:57', '2024-10-20 09:49:57'), (247, 'Ehiwogwu mercy ebere', NULL, '8146250956', 'Opay (Paycom)', '100004', NULL, 537, 0, '2024-10-20 10:36:18', '2024-10-20 10:36:18'), (248, 'Shakirat Arike Nurudeen', NULL, '9121766791', 'Opay (Paycom)', '100004', NULL, 539, 1, '2024-10-20 10:48:50', '2024-10-20 10:49:26'), (249, 'Samuel Philip Danboyi', NULL, '8145189715', 'PALMPAY', '100033', NULL, 543, 0, '2024-10-20 11:02:18', '2024-10-20 11:02:18'), (250, 'Samson Solomon', NULL, '8075157450', 'Opay (Paycom)', '100004', NULL, 550, 1, '2024-10-20 11:18:57', '2024-10-20 11:18:57'), (251, 'Peter Rindap Anthony', NULL, '8078907136', 'Opay (Paycom)', '100004', NULL, 547, 1, '2024-10-20 11:19:06', '2024-10-20 11:19:06'), (252, 'Muhammed usman pulor', NULL, '8084837903', 'PALMPAY', '100033', NULL, 553, 0, '2024-10-20 11:27:09', '2024-10-20 11:27:09'), (253, 'Odoh Ejike Michael', NULL, '8105692652', 'PALMPAY', '100033', NULL, 552, 0, '2024-10-20 11:48:42', '2024-10-20 11:48:42'), (254, 'Ibrahim chiko Alhassan', NULL, '9129800736', 'PALMPAY', '100033', NULL, 557, 1, '2024-10-20 11:50:20', '2024-10-20 11:50:20'), (255, 'MOHAMMED GAYAM ABUBAKAR', NULL, '0731375590', 'Access Bank', '044', NULL, 554, 1, '2024-10-20 11:52:02', '2024-10-20 11:52:02'), (256, 'Ayomide olorunshomo junior', NULL, '9060259031', 'Opay (Paycom)', '100004', NULL, 562, 0, '2024-10-20 12:06:46', '2024-10-20 12:06:46'), (257, 'Oluwatoyin Hannah fadoju', NULL, '8144201675', 'Opay (Paycom)', '100004', NULL, 568, 0, '2024-10-20 12:29:29', '2024-10-20 12:29:29'), (258, 'Priscilla global business', NULL, '7034544022', 'Opay (Paycom)', '100004', NULL, 574, 0, '2024-10-20 12:56:18', '2024-10-20 12:56:18'), (259, 'Muhammad Amir umar', NULL, '7036619155', 'Moniepoint Microfinance Bank', '090405', NULL, 576, 1, '2024-10-20 12:57:36', '2024-10-20 12:57:36'), (260, 'Bello Barnabas', NULL, '7013075941', 'PALMPAY', '100033', NULL, 578, 1, '2024-10-20 13:02:51', '2024-10-20 13:02:51'), (261, 'Isiaka kehinde musibau', NULL, '3072161642', 'First Bank PLC', '011', NULL, 582, 0, '2024-10-20 13:42:01', '2024-10-20 13:42:01'), (262, 'zainab bolanle abdulazeez', NULL, '7065880106', 'Opay (Paycom)', '100004', NULL, 587, 0, '2024-10-20 13:42:14', '2024-10-20 13:42:14'), (263, 'OSARENREN EVELYN', NULL, '9024415931', 'Opay (Paycom)', '100004', NULL, 575, 0, '2024-10-20 13:43:06', '2024-10-20 13:43:06'), (264, 'Ugwu Angelina onyemebirionwu', NULL, '8033423582', 'Opay (Paycom)', '100004', NULL, 589, 1, '2024-10-20 13:46:28', '2024-10-20 13:46:35'), (265, 'Sunday chinaelo', NULL, '1606688416', 'Access Bank', '044', NULL, 590, 0, '2024-10-20 13:56:00', '2024-10-20 13:56:00'), (266, 'Martins Clarine Ipirinye', NULL, '2341190619', 'United Bank for Africa', '033', NULL, 600, 1, '2024-10-20 14:09:40', '2024-10-20 14:09:40'), (267, 'Abdullahi Saleh', NULL, '9032126071', 'PALMPAY', '100033', NULL, 584, 1, '2024-10-20 14:11:15', '2024-10-20 14:11:15'), (268, 'USMAN AHMAD', NULL, '8109487829', 'PALMPAY', '100033', NULL, 601, 1, '2024-10-20 14:12:35', '2024-10-20 14:12:45'), (269, 'Caleb Esla David', NULL, '9066696304', 'Opay (Paycom)', '100004', NULL, 604, 1, '2024-10-20 14:27:09', '2024-10-20 14:27:15'), (270, 'FARAYOLA YETUNDE OLUBUNMI', NULL, '8179352897', 'PALMPAY', '100033', NULL, 323, 1, '2024-10-20 14:38:07', '2024-10-20 14:38:07'), (271, 'Tijani Omeiza Nurudeen', NULL, '7089022852', 'PALMPAY', '100033', NULL, 608, 1, '2024-10-20 14:38:08', '2024-10-20 14:38:08'), (272, 'Muhammad Ali mustapha', NULL, '8132764325', 'Opay (Paycom)', '100004', NULL, 406, 1, '2024-10-20 14:40:11', '2024-10-20 14:40:18'), (273, 'Zainab bibi', NULL, '03489189738', 'Jaiz Bank', '301', NULL, 609, 1, '2024-10-20 14:46:40', '2024-10-20 14:46:51'), (274, 'Wisdom Benjamin Okon', NULL, '8139977172', 'Opay (Paycom)', '100004', NULL, 618, 0, '2024-10-20 15:03:55', '2024-10-20 15:03:55'), (275, 'Felicia Adeyemi', NULL, '9029474495', 'Opay (Paycom)', '100004', NULL, 588, 0, '2024-10-20 15:26:12', '2024-10-20 15:26:12'), (276, 'Taiwo adebusoye', NULL, '7038546144', 'PALMPAY', '100033', NULL, 563, 0, '2024-10-20 15:39:31', '2024-10-20 15:39:31'), (277, 'Ahmed risikat', NULL, '1203630015', 'First City Monument Bank', '214', NULL, 625, 0, '2024-10-20 15:39:38', '2024-10-20 15:39:38'), (278, 'Ilufoye Oluwatobi David', NULL, '8039314511', 'Opay (Paycom)', '100004', NULL, 627, 0, '2024-10-20 15:44:28', '2024-10-20 15:44:28'), (279, 'Uchenna destiny chukwurah', NULL, '7073811931', 'PALMPAY', '100033', NULL, 630, 1, '2024-10-20 15:58:17', '2024-10-20 15:58:17'), (280, 'FATIMA LAWAL PELUMI', NULL, '7083007067', 'PALMPAY', '100033', NULL, 634, 1, '2024-10-20 16:26:55', '2024-10-20 16:26:55'), (281, 'Esther Esenowo peters', NULL, '7040184198', 'Opay (Paycom)', '100004', NULL, 626, 1, '2024-10-20 16:58:50', '2024-10-20 16:58:50'), (282, 'Gabriel Gideon Adukwu', NULL, '2052538502', 'Kuda', '090267', NULL, 642, 1, '2024-10-20 17:13:09', '2024-10-20 17:13:09'), (283, 'Obule Rachael Arouriwo', NULL, '0803883147', 'Access Bank', '044', NULL, 646, 0, '2024-10-20 17:31:52', '2024-10-20 17:31:52'), (284, 'Promise Chinonso Okeke', NULL, '9031412214', 'Moniepoint Microfinance Bank', '090405', NULL, 365, 1, '2024-10-20 17:41:22', '2024-10-20 17:41:22'), (285, 'Joshua Umoh', NULL, '8063346037', 'Opay (Paycom)', '100004', NULL, 647, 1, '2024-10-20 17:56:12', '2024-10-20 17:56:12'), (286, 'PEACE OLUWATIMILEHIN FAYOMADE', NULL, '7035309043', 'Opay (Paycom)', '100004', NULL, 648, 0, '2024-10-20 18:01:00', '2024-10-20 18:01:00'), (287, 'Mostafa mohmaud Abdul elmanam', NULL, '01062341716', 'Access Bank', '044', NULL, 649, 0, '2024-10-20 18:05:24', '2024-10-20 18:05:54'), (288, 'Prisca ujunwa ndihibe', NULL, '8034396659', 'PALMPAY', '100033', NULL, 657, 0, '2024-10-20 18:33:41', '2024-10-20 18:33:41'), (289, 'Abdulrasheed uthaman', NULL, '8155941824', 'Opay (Paycom)', '100004', NULL, 654, 0, '2024-10-20 18:34:53', '2024-10-20 18:34:53'), (290, 'Chidiebere Stanley akuebuo', NULL, '7026089800', 'PALMPAY', '100033', NULL, 463, 0, '2024-10-20 19:24:37', '2024-10-20 19:24:37'), (291, 'Eee', NULL, 'Ss', 'Guaranty Trust Bank', '058', NULL, 308, 0, '2025-02-26 16:57:17', '2025-02-26 16:57:17'); -- -------------------------------------------------------- -- -- Table structure for table `bank_lists` -- CREATE TABLE `bank_lists` ( `id` bigint(20) UNSIGNED NOT NULL, `country` varchar(255) DEFAULT NULL, `bank_code` varchar(255) NOT NULL, `gtr_bank_code` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bank_lists` -- INSERT INTO `bank_lists` (`id`, `country`, `bank_code`, `gtr_bank_code`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 'NG', '044', 'NG0009', 'FNB', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (2, 'NG', '023', 'NG0057', 'Capitec', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (3, 'NG', '050', 'NG0073', 'Tymebank', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (4, 'NG', '011', 'NG0101', 'Standard Bank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (5, 'NG', '214', 'NG0102', 'ABSA', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (6, 'NG', '070', 'NG0095', 'Nedbank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (7, 'NG', '058', 'NG0126', 'Discovery Bank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (8, 'NG', '076', 'NG0220', 'Access Bank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (9, 'NG', '221', 'NG0243', 'Stanbic IBTC Bank', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (10, 'NG', '068', 'NG0245', 'African Bank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (11, 'NG', '232', 'NG0248', 'Bidvest Bank ', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'), (12, 'NG', '033', 'NG0268', 'Sasfin Bank', 1, '2024-08-20 07:35:27', '2024-08-20 07:35:27'); -- -------------------------------------------------------- -- -- Table structure for table `bonuses` -- CREATE TABLE `bonuses` ( `id` bigint(20) UNSIGNED NOT NULL, `bonus_name` varchar(255) NOT NULL, `counter` int(11) DEFAULT 0 COMMENT 'user get service count', `set_service_counter` int(11) NOT NULL, `code` varchar(255) NOT NULL, `winner` int(11) DEFAULT 0, `amount` double NOT NULL DEFAULT 0, `status` enum('active','inactive') NOT NULL DEFAULT 'inactive', `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 `bonus_ledgers` -- CREATE TABLE `bonus_ledgers` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `bonus_id` int(11) DEFAULT NULL, `amount` double(20,2) NOT NULL DEFAULT 0.00, `bonus_code` varchar(255) NOT NULL, `date` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `bonus_ledgers` -- INSERT INTO `bonus_ledgers` (`id`, `user_id`, `bonus_id`, `amount`, `bonus_code`, `date`, `created_at`, `updated_at`) VALUES (306, 309, NULL, 0.00, '---', '2025-06-23 12:27:26', '2025-06-23 12:27:26', '2025-06-23 12:27:26'), (307, 310, NULL, 0.00, '---', '2025-06-24 13:04:26', '2025-06-24 13:04:26', '2025-06-24 13:04:26'), (308, 311, NULL, 0.00, '---', '2025-06-24 13:47:55', '2025-06-24 13:47:55', '2025-06-24 13:47:55'), (309, 312, NULL, 0.00, '---', '2025-06-24 14:10:43', '2025-06-24 14:10:43', '2025-06-24 14:10:43'), (310, 313, NULL, 0.00, '---', '2025-06-24 14:52:26', '2025-06-24 14:52:26', '2025-06-24 14:52:26'), (311, 314, NULL, 0.00, '---', '2025-06-24 14:53:55', '2025-06-24 14:53:55', '2025-06-24 14:53:55'), (312, 315, NULL, 0.00, '---', '2025-06-24 18:00:18', '2025-06-24 18:00:18', '2025-06-24 18:00:18'), (313, 316, NULL, 0.00, '---', '2025-06-24 18:18:57', '2025-06-24 18:18:57', '2025-06-24 18:18:57'), (314, 317, NULL, 0.00, '---', '2025-06-24 18:37:01', '2025-06-24 18:37:01', '2025-06-24 18:37:01'); -- -------------------------------------------------------- -- -- Table structure for table `checkins` -- CREATE TABLE `checkins` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `date` varchar(255) NOT NULL, `amount` double(20,2) NOT NULL DEFAULT 0.00, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `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 `commissions` -- CREATE TABLE `commissions` ( `id` int(11) NOT NULL, `user_id` int(11) DEFAULT NULL, `task_id` int(11) DEFAULT NULL, `amount` double(20,2) NOT NULL DEFAULT 0.00, `date` varchar(255) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `token` varchar(255) DEFAULT NULL, `created_at` varchar(255) DEFAULT NULL, `updated_at` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `deposits` -- CREATE TABLE `deposits` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `method_name` varchar(255) NOT NULL, `order_id` varchar(255) NOT NULL, `transaction_id` varchar(255) NOT NULL, `photo` varchar(255) DEFAULT NULL, `number` varchar(255) DEFAULT NULL COMMENT 'User Number', `amount` varchar(255) NOT NULL COMMENT 'User Deposit Amount', `charge_amount` double(20,2) NOT NULL DEFAULT 0.00, `final_amount` double(20,2) NOT NULL DEFAULT 0.00, `date` varchar(255) NOT NULL, `feedback` text DEFAULT NULL, `status` enum('pending','rejected','approved') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `deposits` -- INSERT INTO `deposits` (`id`, `user_id`, `method_name`, `order_id`, `transaction_id`, `photo`, `number`, `amount`, `charge_amount`, `final_amount`, `date`, `feedback`, `status`, `created_at`, `updated_at`) VALUES (75, 309, 'Fidelity bank', '39925', 'Mbtech', '/public/upload/payment/1750675238ooF.jpg', NULL, '2000', 0.00, 2000.00, '23-06-2025 12:40:38', NULL, 'approved', '2025-06-23 12:40:38', '2025-06-23 12:41:56'); -- -------------------------------------------------------- -- -- 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 `funds` -- CREATE TABLE `funds` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `title` longtext NOT NULL, `photo` varchar(255) DEFAULT NULL, `commission` double(20,2) NOT NULL DEFAULT 0.00 COMMENT 'percent', `validity` bigint(20) NOT NULL, `minimum_invest` double(20,2) NOT NULL DEFAULT 0.00 COMMENT 'amount', `status` enum('upcoming','active') NOT NULL DEFAULT 'active', `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 `funds` -- INSERT INTO `funds` (`id`, `name`, `title`, `photo`, `commission`, `validity`, `minimum_invest`, `status`, `created_at`, `updated_at`) VALUES (1, 'Fund 1', 'Fund oneFund oneFund oneFund one', '/public/upload/fund/1710495112q8e.png', 150.00, 7, 100.00, 'active', '2023-06-06 15:38:44', '2024-03-19 03:12:32'), (18, 'Fund 2', 'Event', '/public/upload/fund/1711258092qpM.png', 250.00, 3, 200.00, 'active', '2024-03-24 11:28:12', '2024-04-03 21:22:20'), (19, 'Fund 3', 'Event', '/public/upload/fund/1711258184gKK.png', 300.00, 3, 250.00, 'active', '2024-03-24 11:29:44', '2024-04-03 21:22:32'), (20, 'Fund 4', 'Event', '/public/upload/fund/1711258244LBI.png', 350.00, 3, 300.00, 'active', '2024-03-24 11:30:44', '2024-04-03 21:22:44'), (21, 'Fund 5', '23000', '/public/upload/fund/1711258697KGD.png', 450.00, 3, 400.00, 'active', '2024-03-24 11:31:49', '2024-04-03 21:22:54'); -- -------------------------------------------------------- -- -- Table structure for table `fund_invests` -- CREATE TABLE `fund_invests` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `fund_id` bigint(20) UNSIGNED NOT NULL, `validity_expired` varchar(255) NOT NULL, `price` double(20,2) NOT NULL DEFAULT 0.00, `return_amount` double(20,2) NOT NULL DEFAULT 0.00, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `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 `fund_invests` -- INSERT INTO `fund_invests` (`id`, `user_id`, `fund_id`, `validity_expired`, `price`, `return_amount`, `status`, `created_at`, `updated_at`) VALUES (1, 841, 1, '2024-03-29 20:00:11', 3000.00, 4800.00, 'inactive', '2024-03-22 20:00:11', '2025-02-17 17:10:59'), (2, 1, 1, '2024-04-10 22:30:18', 100.00, 150.00, 'inactive', '2024-04-03 21:30:18', '2025-02-17 17:11:05'), (3, 1, 18, '2024-04-06 22:30:21', 200.00, 250.00, 'inactive', '2024-04-03 21:30:21', '2025-02-17 17:11:05'), (4, 8, 1, '2025-02-27 16:27:01', 100.00, 150.00, 'inactive', '2025-02-20 16:27:01', '2025-03-02 02:43:00'), (5, 8, 18, '2025-02-23 16:27:06', 200.00, 250.00, 'inactive', '2025-02-20 16:27:06', '2025-03-02 02:43:00'); -- -------------------------------------------------------- -- -- Table structure for table `packages` -- CREATE TABLE `packages` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `price` double NOT NULL, `validity` varchar(255) NOT NULL COMMENT 'count days', `commission_with_avg_amount` double NOT NULL DEFAULT 0 COMMENT 'user get average amount after validity', `status` enum('active','inactive') NOT NULL DEFAULT 'active', `is_default` enum('1','0') NOT NULL DEFAULT '0', `desc` longtext DEFAULT NULL, `category` enum('fixed','welfare','activity') NOT NULL DEFAULT 'fixed', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `max_purchase_limit` int(11) NOT NULL DEFAULT 1, `is_sold_out` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = Sold Out, 0 = Available', `is_resale` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = Resale Package, 0 = Normal' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `packages` -- INSERT INTO `packages` (`id`, `name`, `title`, `photo`, `price`, `validity`, `commission_with_avg_amount`, `status`, `is_default`, `desc`, `category`, `created_at`, `updated_at`, `max_purchase_limit`, `is_sold_out`, `is_resale`) VALUES (36, 'Crude Oil 1', 'Week', '/public/upload/package/174878063601r.jpeg', 80, '39', 1365, 'active', '0', 'SkyNest Technologies', 'fixed', '2025-03-02 03:46:48', '2025-06-03 13:30:15', 5, 1, 0), (37, 'Crude Oil 2', 'Week', '/public/upload/package/1748786700pmh.jpeg', 350, '39', 3705, 'active', '0', 'GreenWave Solutions', 'fixed', '2025-03-02 03:48:18', '2025-06-02 15:24:40', 5, 1, 0), (38, 'Crude Oil 3', 'Fund', '/public/upload/package/1748786796B0J.jpeg', 900, '39', 7800, 'active', '0', 'Quantum Nexus', 'fixed', '2025-03-02 03:49:25', '2025-06-02 15:25:27', 5, 0, 0), (39, 'Crude Oil 4', 'Week', '/public/upload/package/1748786866bvI.jpeg', 1850, '40', 10000, 'active', '0', 'AeroVista Dynamics', 'fixed', '2025-03-02 03:50:23', '2025-06-02 15:29:04', 5, 0, 0), (40, 'Crude Oil 5', 'Week', '/public/upload/package/1748786952YLt.jpeg', 3500, '40', 22000, 'active', '0', 'BlueOcean Ventures', 'fixed', '2025-03-02 13:12:26', '2025-06-02 15:29:39', 5, 0, 0), (41, 'Crude Oil 6', 'Week', '/public/upload/package/1748787019Cs9.jpeg', 9000, '50', 45000, 'active', '0', 'SolarEdge Power', 'fixed', '2025-03-02 13:13:50', '2025-06-01 21:10:19', 5, 0, 0), (42, 'Crude Oil 7', 'Month', '/public/upload/package/17487870744Vs.jpeg', 15000, '50', 75000, 'active', '0', 'Okay', 'fixed', '2025-05-22 08:33:05', '2025-06-01 21:11:14', 5, 0, 0), (43, 'Crude Oil 8', 'Month', '/public/upload/package/1748787137gyy.jpeg', 45000, '50', 225000, 'active', '0', 'Me', 'fixed', '2025-05-22 08:35:26', '2025-06-01 21:12:17', 5, 0, 0), (44, 'Welfare Product 1', 'Month', '/public/upload/package/17487873671mZ.jpeg', 150, '3', 450, 'active', '0', 'Me', 'welfare', '2025-05-22 08:40:58', '2025-06-03 16:02:46', 3, 0, 0), (45, 'Welfare Product 2', 'Month', '/public/upload/package/1748787518JSQ.jpeg', 500, '5', 1800, 'active', '0', 'Me', 'welfare', '2025-05-22 08:44:26', '2025-06-03 16:03:15', 3, 0, 0), (46, 'Welfare Product 3', 'Yewr', '/public/upload/package/1748787678KAG.jpeg', 1200, '5', 4200, 'active', '0', 'Me', 'welfare', '2025-05-22 08:54:09', '2025-06-03 16:03:39', 3, 0, 0), (47, 'Welfare Product 4', 'Yearly', '/public/upload/package/1748787797b3e.jpeg', 2500, '5', 6500, 'active', '0', 'Me', 'welfare', '2025-05-22 08:55:36', '2025-06-03 16:04:21', 3, 0, 0), (48, 'Welfare Product 5', 'Yewr', '/public/upload/package/1748787985U50.jpeg', 6000, '8', 16000, 'active', '0', 'Me', 'welfare', '2025-05-22 08:57:35', '2025-06-03 16:49:11', 3, 0, 0), (49, 'Welfare Product 6', 'Yewr', '/public/upload/package/17487880514K3.jpeg', 12500, '8', 48000, 'active', '0', 'Me', 'welfare', '2025-05-22 08:58:48', '2025-06-03 16:50:02', 3, 0, 0), (50, 'Welfare Product 7', 'Yesr', '/public/upload/package/1748788114fj4.jpeg', 20000, '28', 140000, 'active', '0', 'Me', 'welfare', '2025-05-22 09:00:19', '2025-06-01 21:28:34', 3, 0, 0), (51, 'Welfare Product 8', 'Me', '/public/upload/package/1748788409UOX.jpeg', 50000, '28', 350000, 'active', '0', 'Okay', 'welfare', '2025-06-01 21:33:29', '2025-06-01 21:33:29', 3, 0, 0), (52, 'Premium Product 1', 'Me', '/public/upload/package/1748788514y5X.jpeg', 200, '10', 900, 'active', '0', 'Me', 'activity', '2025-06-01 21:35:14', '2025-06-01 21:35:14', 10, 0, 0), (53, 'Premium Product 2', 'Me', '/public/upload/package/17487886655lP.jpeg', 650, '10', 2470, 'active', '0', 'Me', 'activity', '2025-06-01 21:37:45', '2025-06-01 21:37:45', 10, 0, 0), (54, 'Premium Product 3', 'Me', '/public/upload/package/1748788717FYq.jpeg', 1500, '10', 5700, 'active', '0', 'Me', 'activity', '2025-06-01 21:38:37', '2025-06-01 21:38:37', 10, 0, 0), (55, 'Premium Product 4', 'Me', '/public/upload/package/1748788837Qs3.jpeg', 4000, '10', 15200, 'active', '0', 'Me', 'activity', '2025-06-01 21:40:38', '2025-06-01 21:40:38', 10, 0, 0), (56, 'Premium Product 5', 'Me', '/public/upload/package/1748789094qD1.jpeg', 8000, '10', 30400, 'active', '0', 'Me', 'activity', '2025-06-01 21:44:04', '2025-06-01 21:45:25', 2, 0, 0), (57, 'Premium Product 6', 'Me', '/public/upload/package/1748789377luo.jpeg', 35000, '10', 133000, 'active', '0', 'Me', 'activity', '2025-06-01 21:49:37', '2025-06-01 21:49:37', 2, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `password_resets` -- CREATE TABLE `password_resets` ( `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; -- -------------------------------------------------------- -- -- Table structure for table `payment_methods` -- CREATE TABLE `payment_methods` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(32) NOT NULL, `tag` varchar(255) DEFAULT NULL, `photo` varchar(255) NOT NULL, `address` text DEFAULT NULL, `auto` tinyint(1) NOT NULL DEFAULT 0, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -- Dumping data for table `payment_methods` -- INSERT INTO `payment_methods` (`id`, `name`, `tag`, `photo`, `address`, `auto`, `status`, `created_at`, `updated_at`) VALUES (6, 'Fidelity bank', NULL, '/public/upload/setting/1750576369uzf.png', '5521691880', 0, 'active', '2025-06-22 09:12:49', '2025-06-22 09:12:49'), (7, 'Bank transfer', NULL, '/public/upload/setting/1750767627mf5.png', '8939044543', 0, 'active', '2025-06-22 09:14:33', '2025-06-24 14:20:27'); -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `tokenable_type` varchar(255) NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `last_used_at` timestamp NULL 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_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchases` -- CREATE TABLE `purchases` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `package_id` bigint(20) UNSIGNED NOT NULL, `amount` double NOT NULL DEFAULT 0, `daily_income` double(20,2) NOT NULL DEFAULT 0.00, `hourly` decimal(20,4) NOT NULL DEFAULT 0.0000, `date` varchar(255) NOT NULL, `note` text DEFAULT NULL, `status` enum('active','inactive','pending') NOT NULL DEFAULT 'pending', `validity` varchar(255) DEFAULT NULL, `category` enum('fixed','welfare','activity') NOT NULL DEFAULT 'fixed', `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 `purchases` -- INSERT INTO `purchases` (`id`, `user_id`, `package_id`, `amount`, `daily_income`, `hourly`, `date`, `note`, `status`, `validity`, `category`, `created_at`, `updated_at`) VALUES (127, 309, 37, 350, 95.00, 3.9583, '2025-06-24 13:50:47', NULL, 'active', '2025-08-01 13:50:47', 'fixed', '2025-06-23 13:50:47', '2025-06-23 13:50:47'), (128, 309, 38, 900, 200.00, 8.3333, '2025-06-24 13:54:31', NULL, 'active', '2025-08-01 13:54:31', 'fixed', '2025-06-23 13:54:31', '2025-06-23 13:54:31'), (129, 309, 37, 350, 95.00, 3.9583, '2025-06-25 09:25:23', NULL, 'active', '2025-08-02 09:25:23', 'fixed', '2025-06-24 09:25:23', '2025-06-24 09:25:23'), (130, 309, 36, 80, 35.00, 1.4583, '2025-06-25 12:35:20', NULL, 'active', '2025-08-02 12:35:20', 'fixed', '2025-06-24 12:35:20', '2025-06-24 12:35:20'), (131, 309, 42, 15000, 1500.00, 62.5000, '2025-06-25 14:28:34', NULL, 'active', '2025-08-13 14:28:34', 'fixed', '2025-06-24 14:28:34', '2025-06-24 14:28:34'), (132, 309, 41, 9000, 900.00, 37.5000, '2025-06-25 14:39:10', NULL, 'active', '2025-08-13 14:39:10', 'fixed', '2025-06-24 14:39:10', '2025-06-24 14:39:10'), (133, 309, 43, 45000, 4500.00, 187.5000, '2025-06-25 14:39:37', NULL, 'active', '2025-08-13 14:39:37', 'fixed', '2025-06-24 14:39:37', '2025-06-24 14:39:37'), (134, 316, 38, 900, 200.00, 8.3333, '2025-06-25 18:26:27', NULL, 'active', '2025-08-02 18:26:27', 'fixed', '2025-06-24 18:26:27', '2025-06-24 18:26:27'); -- -------------------------------------------------------- -- -- Table structure for table `rebates` -- CREATE TABLE `rebates` ( `id` bigint(20) UNSIGNED NOT NULL, `team_commission1` double NOT NULL, `team_commission2` double NOT NULL, `team_commission3` double NOT NULL, `interest_commission1` double NOT NULL, `interest_commission2` double NOT NULL, `interest_commission3` double 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 `rebates` -- INSERT INTO `rebates` (`id`, `team_commission1`, `team_commission2`, `team_commission3`, `interest_commission1`, `interest_commission2`, `interest_commission3`, `created_at`, `updated_at`) VALUES (1, 30, 5, 1, 0, 0, 0, NULL, '2025-06-03 02:59:41'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `logo` varchar(255) DEFAULT NULL, `withdraw_charge` int(11) NOT NULL DEFAULT 0 COMMENT 'percent', `auto_deposit` tinyint(1) NOT NULL DEFAULT 0, `auto_transfer` tinyint(1) NOT NULL DEFAULT 0, `auto_transfer_default` varchar(255) DEFAULT NULL, `open_deposit` tinyint(1) NOT NULL DEFAULT 0, `open_transfer` tinyint(1) NOT NULL DEFAULT 0, `minimum_withdraw` double(20,2) NOT NULL DEFAULT 0.00, `minimum_recharge` double(20,2) NOT NULL DEFAULT 0.00, `maximum_recharge` double(20,2) NOT NULL DEFAULT 0.00, `maximum_withdraw` double(20,2) NOT NULL DEFAULT 0.00, `w_time_status` enum('active','inactive') NOT NULL DEFAULT 'active', `checkin` double(20,2) NOT NULL DEFAULT 0.00, `registration_bonus` double(20,2) NOT NULL DEFAULT 0.00, `total_member_register_reword` int(11) NOT NULL DEFAULT 0, `total_member_register_reword_amount` double(20,2) NOT NULL DEFAULT 0.00, `channel` varchar(255) DEFAULT NULL, `telegram` varchar(255) DEFAULT NULL, `gtr_mchtId` text DEFAULT NULL, `gtr_appId` text DEFAULT NULL, `gtr_secret_key` 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 `settings` -- INSERT INTO `settings` (`id`, `logo`, `withdraw_charge`, `auto_deposit`, `auto_transfer`, `auto_transfer_default`, `open_deposit`, `open_transfer`, `minimum_withdraw`, `minimum_recharge`, `maximum_recharge`, `maximum_withdraw`, `w_time_status`, `checkin`, `registration_bonus`, `total_member_register_reword`, `total_member_register_reword_amount`, `channel`, `telegram`, `gtr_mchtId`, `gtr_appId`, `gtr_secret_key`, `created_at`, `updated_at`) VALUES (1, '/public/upload/logo/1740860726wTQ.png', 20, 0, 0, 'gtr', 1, 1, 100.00, 100.00, 20000.00, 10000.00, 'active', 8.00, 30.00, 0, 0.00, 'https://t.me/+AxzjFD0FlchiNzI0', 'https://t.me/+AxzjFD0FlchiNzI0', 'Nnnnn', 'Nbbn', 'Hggy', '2022-01-18 11:03:22', '2025-06-02 21:01:54'); -- -------------------------------------------------------- -- -- Table structure for table `spin_chances` -- CREATE TABLE `spin_chances` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `chances` int(11) NOT NULL DEFAULT 0, `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 `spin_chances` -- INSERT INTO `spin_chances` (`id`, `user_id`, `chances`, `created_at`, `updated_at`) VALUES (7, 309, 11, '2025-06-23 13:12:48', '2025-06-24 14:39:37'), (8, 316, 1, '2025-06-24 18:26:27', '2025-06-24 18:26:27'); -- -------------------------------------------------------- -- -- Table structure for table `tasks` -- CREATE TABLE `tasks` ( `id` bigint(20) UNSIGNED NOT NULL, `invest` double NOT NULL DEFAULT 0, `bonus` double NOT NULL DEFAULT 0, `team_size` bigint(20) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tasks` -- INSERT INTO `tasks` (`id`, `invest`, `bonus`, `team_size`, `created_at`, `updated_at`) VALUES (9, 100, 20, 1, '2024-05-04 06:56:19', '2025-06-01 21:52:00'), (10, 5000, 50, 2, '2024-05-04 06:57:05', '2025-06-23 02:43:54'), (11, 20000, 150, 20, '2024-05-04 06:57:58', '2025-06-03 05:21:28'), (12, 35000, 1000, 100, '2024-10-14 19:42:33', '2025-06-03 05:21:40'), (13, 50000, 2500, 200, '2025-05-22 18:43:41', '2025-05-22 19:36:27'); -- -------------------------------------------------------- -- -- Table structure for table `task_requests` -- CREATE TABLE `task_requests` ( `id` bigint(20) UNSIGNED NOT NULL, `task_id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `team_invest` double NOT NULL DEFAULT 0, `team_size` bigint(20) NOT NULL DEFAULT 0, `bonus` double(20,2) NOT NULL DEFAULT 0.00, `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `task_requests` -- INSERT INTO `task_requests` (`id`, `task_id`, `user_id`, `team_invest`, `team_size`, `bonus`, `status`, `created_at`, `updated_at`) VALUES (13, 9, 129, 100, 1, 0.00, 'approved', '2025-06-23 03:08:29', '2025-06-23 04:04:43'), (14, 10, 129, 5000, 2, 0.00, 'pending', '2025-06-23 04:40:29', '2025-06-23 04:40:29'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `referred_by` bigint(20) UNSIGNED DEFAULT NULL, `ref_by` varchar(255) DEFAULT NULL, `ref_id` varchar(255) NOT NULL, `name` varchar(255) DEFAULT NULL, `investor` int(11) NOT NULL DEFAULT 0, `vip_level` int(11) NOT NULL DEFAULT 0, `realname` varchar(255) DEFAULT NULL, `phone_code` varchar(20) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `ip` varchar(255) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `type` varchar(255) DEFAULT NULL, `balance` double(20,2) NOT NULL DEFAULT 0.00, `income` double(20,2) NOT NULL DEFAULT 0.00, `receive_able_amount` double(20,2) NOT NULL DEFAULT 0.00, `checkin` double(20,2) NOT NULL DEFAULT 0.00, `photo` varchar(255) DEFAULT NULL, `gateway_method` varchar(50) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `gateway_address` text DEFAULT NULL, `gateway_number` varchar(50) DEFAULT NULL, `trx_password` varchar(255) DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `code` varchar(50) DEFAULT NULL, `status` enum('active','inactive') NOT NULL DEFAULT 'active', `ban_unban` enum('ban','unban') NOT NULL DEFAULT 'unban', `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 `users` -- INSERT INTO `users` (`id`, `referred_by`, `ref_by`, `ref_id`, `name`, `investor`, `vip_level`, `realname`, `phone_code`, `phone`, `ip`, `username`, `email`, `email_verified_at`, `password`, `type`, `balance`, `income`, `receive_able_amount`, `checkin`, `photo`, `gateway_method`, `bank_name`, `gateway_address`, `gateway_number`, `trx_password`, `remember_token`, `code`, `status`, `ban_unban`, `created_at`, `updated_at`) VALUES (309, NULL, '5026601', '53024130', NULL, 1, 4, 'Mbtech', '+27', '9015501668', '105.119.23.119', 'uname9015501668', '1750674446503@gmail.com', NULL, '$2y$10$TyF5Ucs6swMTpJ0YCGY5gO0aitA4dFfxZJA5wJRMEFIgLwGIRwURq', NULL, 199435.00, 0.00, 0.00, 0.00, NULL, '023', 'Capitec', '000000000000', NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-23 12:27:26', '2025-06-24 14:39:37'), (310, NULL, '8220361', '93103362', NULL, 0, 0, NULL, NULL, '682518090', NULL, 'uname682518090', '1750763066298@gmail.com', NULL, '$2y$10$/lUvyadIyLFcs6TIlPkT2.yoqYIm2QJJ9RFhvXPs38nCCO/P5b34e', NULL, 30.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 13:04:26', '2025-06-24 13:04:26'), (311, NULL, '35059307', '30279349', NULL, 0, 0, NULL, NULL, '1122334455', NULL, 'uname1122334455', '1750765675936@gmail.com', NULL, '$2y$10$SpzV3CUiOV3k2UL4tV89E.iHtl6JqCXiJgLrMXZanrU/SVnUAATNa', NULL, 30.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 13:47:55', '2025-06-24 13:47:55'), (312, NULL, '93103362', '80414479', NULL, 0, 0, NULL, NULL, '608684451', NULL, 'uname608684451', '1750767043657@gmail.com', NULL, '$2y$10$jFrkOJrTujHaL/Xb0Y5v2eKQhDNuXAtMzUqdRWrw4bCHcNly.VBoq', NULL, 30.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 14:10:43', '2025-06-24 14:10:43'), (313, NULL, '23523859', '82943535', NULL, 0, 0, NULL, NULL, '9123456777', NULL, 'uname9123456777', '1750769546274@gmail.com', NULL, '$2y$10$SKoi3Yl3lukuc4fUdjKjD.An1Bf8n4LbtfB6q/wPA0nHjXgW7ZH/a', NULL, 30.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 14:52:26', '2025-06-24 14:52:26'), (314, NULL, '66136268', '97823861', NULL, 0, 0, NULL, NULL, '12345678910', NULL, 'uname12345678910', '1750769635359@gmail.com', NULL, '$2y$10$oY70WIF0p2dckfCvexsVQOi1D9pCuQHQzMZLjE6IkjrUwZS3bISZa', NULL, 30.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 14:53:55', '2025-06-24 14:53:55'), (315, NULL, '43338864', '88823476', NULL, 0, 0, NULL, NULL, '9123456788', NULL, 'uname9123456788', '1750780818118@gmail.com', NULL, '$2y$10$kBgaPNqfFSrNxpcUxFbvl.LvXLd7Y.0mIZhHxvAZSi47IfOF5aVl2', NULL, 75.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 18:00:18', '2025-06-24 18:00:18'), (316, NULL, '72700042', '30194574', NULL, 1, 1, NULL, NULL, '9015501666', NULL, 'uname9015501666', '1750781936147@gmail.com', NULL, '$2y$10$axuJ4okEV3iPlyghUqyGzOTurHDM8DecxSXMSpe8Jb2I5xzIyw13m', NULL, 6999105.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 18:18:57', '2025-06-24 18:26:27'), (317, NULL, '39760251', '70448988', NULL, 0, 0, NULL, NULL, '902325443', NULL, 'uname902325443', '1750783021931@gmail.com', NULL, '$2y$10$Ns8YrfYwdYRxjzo2aNsJZ.XWjtbqWfvHus8etdbAX7bsaUamVOLTe', NULL, 75.00, 0.00, 0.00, 0.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'active', 'unban', '2025-06-24 18:37:01', '2025-06-24 18:37:01'); -- -------------------------------------------------------- -- -- Table structure for table `user_ledgers` -- CREATE TABLE `user_ledgers` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` bigint(20) UNSIGNED NOT NULL, `get_balance_from_user_id` bigint(20) DEFAULT NULL, `reason` varchar(255) NOT NULL, `perticulation` varchar(255) DEFAULT NULL, `amount` double NOT NULL DEFAULT 0, `debit` double NOT NULL DEFAULT 0, `credit` double NOT NULL DEFAULT 0, `status` enum('pending','approved','rejected','default') NOT NULL DEFAULT 'default', `date` varchar(255) DEFAULT NULL, `step` varchar(20) 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 `user_ledgers` -- INSERT INTO `user_ledgers` (`id`, `user_id`, `get_balance_from_user_id`, `reason`, `perticulation`, `amount`, `debit`, `credit`, `status`, `date`, `step`, `created_at`, `updated_at`) VALUES (457, 309, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '23-06-2025 12:27', NULL, '2025-06-23 12:27:26', '2025-06-23 12:27:26'), (458, 309, NULL, 'payment_approved', 'Payment Received approved', 2000, 2000, 0, 'approved', '23-06-2025 12:41', NULL, '2025-06-23 12:41:56', '2025-06-23 12:41:56'), (459, 310, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '24-06-2025 13:04', NULL, '2025-06-24 13:04:26', '2025-06-24 13:04:26'), (460, 311, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '24-06-2025 13:47', NULL, '2025-06-24 13:47:55', '2025-06-24 13:47:55'), (461, 312, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '24-06-2025 14:10', NULL, '2025-06-24 14:10:43', '2025-06-24 14:10:43'), (462, 313, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '24-06-2025 14:52', NULL, '2025-06-24 14:52:26', '2025-06-24 14:52:26'), (463, 314, NULL, 'registration_bonus', 'Registration Bonus', 30, 0, 30, 'approved', '24-06-2025 14:53', NULL, '2025-06-24 14:53:55', '2025-06-24 14:53:55'), (464, 315, NULL, 'registration_bonus', 'Registration Bonus', 75, 0, 75, 'approved', '24-06-2025 18:00', NULL, '2025-06-24 18:00:18', '2025-06-24 18:00:18'), (465, 316, NULL, 'registration_bonus', 'Registration Bonus', 75, 0, 75, 'approved', '24-06-2025 18:18', NULL, '2025-06-24 18:18:57', '2025-06-24 18:18:57'), (466, 317, NULL, 'registration_bonus', 'Registration Bonus', 75, 0, 75, 'approved', '24-06-2025 18:37', NULL, '2025-06-24 18:37:01', '2025-06-24 18:37:01'); -- -------------------------------------------------------- -- -- Table structure for table `vip_sliders` -- CREATE TABLE `vip_sliders` ( `id` bigint(20) UNSIGNED NOT NULL, `photo` varchar(255) NOT NULL, `status` enum('active','inactive') DEFAULT 'active', `page_type` enum('home_page','vip_page') NOT NULL DEFAULT 'home_page', `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 `vip_sliders` -- INSERT INTO `vip_sliders` (`id`, `photo`, `status`, `page_type`, `created_at`, `updated_at`) VALUES (16, '/public/upload/slider/1712171820b7x.jpeg', 'active', 'home_page', '2024-04-04 00:16:17', '2024-04-04 00:17:00'), (17, '/public/upload/slider/17121719540Fy.jpeg', 'active', 'home_page', '2024-04-04 00:19:14', '2024-04-04 00:19:14'); -- -------------------------------------------------------- -- -- Table structure for table `withdrawals` -- CREATE TABLE `withdrawals` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `method_name` varchar(255) DEFAULT NULL, `oid` varchar(255) DEFAULT NULL, `number` varchar(255) DEFAULT NULL, `amount` decimal(20,2) NOT NULL DEFAULT 0.00, `currency` varchar(40) NOT NULL, `rate` decimal(20,2) NOT NULL DEFAULT 0.00, `charge` decimal(20,2) NOT NULL DEFAULT 0.00, `trx` varchar(40) DEFAULT NULL, `final_amount` decimal(20,2) NOT NULL DEFAULT 0.00, `after_charge` decimal(20,2) NOT NULL DEFAULT 0.00, `withdraw_information` text DEFAULT NULL, `account_info` text DEFAULT NULL, `date` varchar(50) DEFAULT NULL, `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'pending' COMMENT '1=>success, 2=>pending, 3=>cancel, ', `admin_feedback` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `withdrawal_proofs` -- CREATE TABLE `withdrawal_proofs` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` int(10) UNSIGNED NOT NULL, `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `like` bigint(20) NOT NULL DEFAULT 0, `status` enum('pending','approved','rejected') NOT NULL DEFAULT 'approved' COMMENT '1=>success, 2=>pending, 3=>cancel', `reward_amount` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_uca1400_ai_ci; -- -- Dumping data for table `withdrawal_proofs` -- INSERT INTO `withdrawal_proofs` (`id`, `user_id`, `comment`, `description`, `photo`, `like`, `status`, `reward_amount`, `created_at`, `updated_at`) VALUES (19, 309, 'Today withdraw successfully from me script deveper', NULL, '/public/upload/comment/1750750372cNw.jpg', 0, 'approved', 15, '2025-06-24 09:32:52', '2025-06-24 09:34:05'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indexes for table `admin_ledgers` -- ALTER TABLE `admin_ledgers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bank` -- ALTER TABLE `bank` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bank_lists` -- ALTER TABLE `bank_lists` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bonuses` -- ALTER TABLE `bonuses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `bonus_ledgers` -- ALTER TABLE `bonus_ledgers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `checkins` -- ALTER TABLE `checkins` ADD PRIMARY KEY (`id`), ADD KEY `checkins_user_id_foreign` (`user_id`); -- -- Indexes for table `commissions` -- ALTER TABLE `commissions` ADD PRIMARY KEY (`id`); -- -- Indexes for table `deposits` -- ALTER TABLE `deposits` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `funds` -- ALTER TABLE `funds` ADD PRIMARY KEY (`id`); -- -- Indexes for table `fund_invests` -- ALTER TABLE `fund_invests` ADD PRIMARY KEY (`id`), ADD KEY `fund_invests_user_id_foreign` (`user_id`), ADD KEY `fund_invests_fund_id_foreign` (`fund_id`); -- -- Indexes for table `packages` -- ALTER TABLE `packages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `password_resets` -- ALTER TABLE `password_resets` ADD PRIMARY KEY (`email`); -- -- Indexes for table `payment_methods` -- ALTER TABLE `payment_methods` ADD PRIMARY KEY (`id`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `purchases` -- ALTER TABLE `purchases` ADD PRIMARY KEY (`id`), ADD KEY `purchases_user_id_foreign` (`user_id`), ADD KEY `purchases_package_id_foreign` (`package_id`); -- -- Indexes for table `rebates` -- ALTER TABLE `rebates` ADD PRIMARY KEY (`id`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- Indexes for table `spin_chances` -- ALTER TABLE `spin_chances` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`); -- -- Indexes for table `tasks` -- ALTER TABLE `tasks` ADD PRIMARY KEY (`id`); -- -- Indexes for table `task_requests` -- ALTER TABLE `task_requests` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD KEY `referred_by_idx` (`referred_by`); -- -- Indexes for table `user_ledgers` -- ALTER TABLE `user_ledgers` ADD PRIMARY KEY (`id`); -- -- Indexes for table `vip_sliders` -- ALTER TABLE `vip_sliders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdrawals` -- ALTER TABLE `withdrawals` ADD PRIMARY KEY (`id`); -- -- Indexes for table `withdrawal_proofs` -- ALTER TABLE `withdrawal_proofs` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `admin_ledgers` -- ALTER TABLE `admin_ledgers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `bank` -- ALTER TABLE `bank` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=292; -- -- AUTO_INCREMENT for table `bank_lists` -- ALTER TABLE `bank_lists` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1027; -- -- AUTO_INCREMENT for table `bonuses` -- ALTER TABLE `bonuses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `bonus_ledgers` -- ALTER TABLE `bonus_ledgers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=315; -- -- AUTO_INCREMENT for table `checkins` -- ALTER TABLE `checkins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `commissions` -- ALTER TABLE `commissions` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `deposits` -- ALTER TABLE `deposits` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `funds` -- ALTER TABLE `funds` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT for table `fund_invests` -- ALTER TABLE `fund_invests` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `payment_methods` -- ALTER TABLE `payment_methods` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchases` -- ALTER TABLE `purchases` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135; -- -- AUTO_INCREMENT for table `rebates` -- ALTER TABLE `rebates` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `spin_chances` -- ALTER TABLE `spin_chances` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `tasks` -- ALTER TABLE `tasks` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `task_requests` -- ALTER TABLE `task_requests` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=318; -- -- AUTO_INCREMENT for table `user_ledgers` -- ALTER TABLE `user_ledgers` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=467; -- -- AUTO_INCREMENT for table `vip_sliders` -- ALTER TABLE `vip_sliders` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `withdrawals` -- ALTER TABLE `withdrawals` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26; -- -- AUTO_INCREMENT for table `withdrawal_proofs` -- ALTER TABLE `withdrawal_proofs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20; -- -- Constraints for dumped tables -- -- -- Constraints for table `spin_chances` -- ALTER TABLE `spin_chances` ADD CONSTRAINT `spin_chances_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE; -- -- Constraints for table `users` -- ALTER TABLE `users` ADD CONSTRAINT `fk_users_referred_by` FOREIGN KEY (`referred_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE CASCADE; 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 */;