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

START TRANSACTION;



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

--
-- 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 `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 `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 `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 `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 `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 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 `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 `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`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 `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 `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 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 `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 `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 `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 `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;
COMMIT;

