-- phpMyAdmin SQL Dump
-- version 5.2.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Oct 04, 2026 at 03:11 PM
-- Server version: 8.4.11
-- PHP Version: 8.4.25

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: `fgfmaqvx_site`
--

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

--
-- Table structure for table `activitylog`
--

CREATE TABLE `activitylog` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `che` int NOT NULL DEFAULT '0',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `airtimeprices`
--

CREATE TABLE `airtimeprices` (
  `id` int NOT NULL,
  `network` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `discount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `airtimeprices`
--

INSERT INTO `airtimeprices` (`id`, `network`, `discount`, `date`) VALUES
(100, 'mtn', '0.0', '02-12-2023 10:10:00'),
(200, 'glo', '0.0', '02-12-2023 10:10:00'),
(300, 'airtel', '0.0', '02-12-2023 10:10:00'),
(400, '9mobile', '0.0', '02-12-2023 10:10:00');

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

--
-- Table structure for table `bankaccounts`
--

CREATE TABLE `bankaccounts` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `bankname` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `acctnum` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `acctname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `bankcode` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bankaccounts`
--

INSERT INTO `bankaccounts` (`id`, `username`, `bankname`, `acctnum`, `acctname`, `bankcode`, `date`) VALUES
(1, 'Legendnikky', 'Audio James', '9031875235', 'Nicholas Ayomide Daramola', '--', '17-09-2025 12:37:48'),
(2, 'Spunky', 'Opay', '9081575060', 'Uduakabasi Ikpe', '--', '19-09-2025 11:48:01'),
(3, 'Deborah', 'Opay', '7030917677', 'Oluebube Deborah uzoma', '--', '19-09-2025 12:56:09'),
(4, 'Nikkyy', 'Yesterday', '9031875236', 'Nicholas Ayomide Daramola', '--', '26-09-2025 05:53:49'),
(5, 'Teacher', 'Yes', '0869585767', 'Yes krje', '--', '01-10-2025 14:02:40'),
(6, 'Gainmart', 'Audio James', '9031875236', 'Nicholas Ayomide Daramola', '--', '29-10-2025 23:18:40'),
(7, 'officialjayjay', 'Kuda', '2024288484', 'Joel James', '--', '31-10-2025 13:46:26'),
(8, 'Sadeeqdigital', 'Opay', '9121982107', 'ABUBAKAR SADEEQ ABDULLAHI', '--', '01-11-2025 00:38:32'),
(9, 'COACHKHAMIS', 'Opay', '8036557588', 'HAJARA MUSTAPHA MOHAMMED', '--', '01-11-2025 07:02:26'),
(10, 'Hussainiruwaya', 'Opay', '9066328561', 'Hussaini Adamu', '--', '01-11-2025 15:55:35'),
(11, 'Gada', 'Monie point', '0701810757', 'FAISAL YUSIF GARBA', '--', '01-11-2025 16:56:25'),
(12, 'kamalne', 'Opaybank', '8124314767', 'Kamalmmusa', '--', '01-11-2025 17:41:13'),
(13, 'Darull', 'Zakariyya', '8027020023', 'Ibrahim', '--', '01-11-2025 20:34:27'),
(14, 'Nazifimuhammad', 'Opay', '9159802435', 'Nazifi Muhammad', '--', '01-11-2025 20:54:35'),
(15, 'Materials', 'Opay', '7015995169', 'ADAMU MOHAMMED', '--', '01-11-2025 21:06:53'),
(16, 'Abdullahishehu', 'Fidelity Bank', '6850203195', 'Shehu Abdullahi', '--', '01-11-2025 21:08:25'),
(17, 'SBU', 'Opay', '9019879744', 'Nurasiraja', '--', '01-11-2025 22:17:14'),
(18, 'Elharuna', 'PalmPay', '7085514777', 'Lawan Haruna Muhammad', '--', '01-11-2025 22:46:30'),
(19, 'mohammed', 'Mohammed iiiyasu', '7012676596', 'Opay', '--', '02-11-2025 04:06:27'),
(20, 'RealBabanintu', 'OPAY PAYMENT SERVICE', '7064225667', 'SUNUSI SUNUSI UMAR', '--', '02-11-2025 06:05:31'),
(21, 'Opehabposi', 'Opay', '8074504122', 'Habeeb Opemiposi Ogunsola', '--', '02-11-2025 07:14:03'),
(22, 'nazeerboy', 'OPAY', '8066067291', 'Naziru shehu', '--', '02-11-2025 07:14:55'),
(23, 'Fatima', 'Opay', '8166803313', 'Fatima alhaji mustapha', '--', '02-11-2025 07:57:39'),
(24, 'Abbakaraminu', 'Abubakar Aminu', '7013930995', 'Opay', '--', '02-11-2025 09:08:25'),
(25, 'Yunus', 'Yunus Sulaiman Ibrah', '8032981945', 'Opay', '--', '02-11-2025 09:42:21'),
(26, 'Jumaresco', 'Opay', '8038817389', 'yahaya jumare', '--', '02-11-2025 09:58:58'),
(27, 'Ayubasmall', 'Ayuba abdullahi', '7011147424', 'Opay bank', '--', '02-11-2025 10:00:18'),
(28, 'Zksh', 'Moniepoint', '8128264668', 'Zakiya shehu', '--', '02-11-2025 10:14:45'),
(29, 'Ameenukano', 'OPAY', '8028073915', 'Aminu usman', '--', '02-11-2025 10:16:14'),
(30, 'abdulrahaman', 'opay', '8063927092', 'Abulrahaman muhammad', '--', '02-11-2025 10:17:07'),
(31, 'Realabanego', 'Opay bank payment', '9128343928', 'Joshua Hassan', '--', '02-11-2025 10:24:24'),
(32, 'Yusuf', 'Opay', '8119513719', 'Yusuf yau', '--', '02-11-2025 10:29:33'),
(33, 'habubakar', 'Opay', '9138210383', 'Saratu yusif', '--', '02-11-2025 10:32:11'),
(34, 'Nenebo', 'Opay', '9040544728', 'Abdussalam Jibril', '--', '02-11-2025 10:34:20'),
(35, 'DALLATU', 'OPAY', '9077296048', 'YUSUF HALIDU', '--', '02-11-2025 10:34:50'),
(36, 'Abusalmanu', 'Opay', '9115456208', 'Umar Faruq Sulaiman', '--', '02-11-2025 10:57:45'),
(37, 'Abubakargoni', 'Opay', '9074803918', 'Abubakar goni Ibrahim', '--', '02-11-2025 11:03:15'),
(38, 'Khaleeboy', 'Smartcash', '9075127502', 'Isah aliyu', '--', '02-11-2025 11:05:58'),
(39, 'Abbadanbatta', 'OPAY', '8037877451', 'ABBA BARAU DANBATTA', '--', '02-11-2025 11:19:31'),
(40, 'DanBangees', 'Opay', '8085254889', 'Isah Isah Ishaq', '--', '02-11-2025 12:02:19'),
(41, 'danbalashinkafi', 'Opay', '8087815766', 'Lauwali Wadatau', '--', '02-11-2025 12:25:21'),
(42, 'Kamilujaja', 'Moniepoint', '7032909040', 'Kamilu saidu', '--', '02-11-2025 12:28:13'),
(43, 'Coachdeejarth', 'Hadiza ummi Haruna', '8068488747', 'Opay', '--', '02-11-2025 13:32:57'),
(44, 'YAlhassan', 'OPAY PAYMENT SERVICE', '8089544098', 'ALHASSAN YUSUF', '--', '02-11-2025 13:33:22'),
(45, 'JAMEEL', 'Moniepoint', '7058271160', 'Jamilu lawal', '--', '02-11-2025 14:05:39'),
(46, 'Coachk', 'OPay', '9066730502', 'Kahdija Abdulsalam', '--', '02-11-2025 14:14:24'),
(47, 'Ababakr', 'OPAY', '9069923071', 'Abubakar Muhammad Aminu', '--', '02-11-2025 14:44:55'),
(48, 'Indirawa', 'Opay.ng', '9160828351', 'Abba hassan', '--', '02-11-2025 15:48:12'),
(49, 'Diamond', 'Opay', '8062530148', 'Abubakarsadiq salisu', '--', '02-11-2025 15:52:23'),
(50, 'Kabirabubakar', 'Opay', '9079297160', 'Kabir Abubakar', '--', '02-11-2025 16:37:22'),
(51, 'Coachabbaprince', 'Opay', '7073898755', 'Sani Ayuba', '--', '02-11-2025 16:45:12'),
(52, 'IbebahhArmalik', 'Opay', '7064802304', 'Abdulmalik musa', '--', '02-11-2025 17:31:57'),
(53, 'Adamu', 'Adamu magaji', '9029837477', 'Opay', '--', '02-11-2025 18:29:27'),
(54, 'BELLONCY', 'Moniepoint', '7032263428', 'Nazifi murtala', '--', '02-11-2025 19:02:36'),
(55, 'Isa', 'Opay', '8081175372', 'Isa blama', '--', '02-11-2025 19:56:34'),
(56, 'Realyahaya', 'Monie point MFB', '9020604794', 'Yahaya Waziri Garba', '--', '02-11-2025 19:57:51'),
(57, 'Jafarbigboy', 'Opay', '9075436343', 'Jafar musa', '--', '02-11-2025 20:02:43'),
(58, 'Rabilou', 'Opay', '8138592687', 'RABILU ADAMU MUHAMMADU', '--', '02-11-2025 20:19:35'),
(59, 'MaiAnguwa', 'OPAY PAYMENT SERVICE', '9151656840', 'SHAMSU SHEHU', '--', '02-11-2025 20:55:20'),
(60, 'Manakogsm', 'Zenith  Bank', '2389850500', 'Adamu Abdullahi', '--', '02-11-2025 21:01:46'),
(61, 'RealAbumukas', 'Opay', '7032648586', 'Abubakar Muhammed Kawu', '--', '02-11-2025 21:20:41'),
(62, 'Abdulmajididris', 'OPAY', 'RABI UMAR', '8132031329', '--', '02-11-2025 21:23:28'),
(63, 'Khady', 'Opay', '8039126308', 'KHADIJA  UMAR', '--', '02-11-2025 21:39:54'),
(64, 'abbastalba', 'Opay', '9138971504', 'Aishatu Mohammed', '--', '02-11-2025 22:30:20'),
(65, 'Ahmadfx', 'Opay', '7040420603', 'Ahmad tijjani Dahiru', '--', '02-11-2025 23:51:52'),
(66, 'Mutawakil', 'Palmpay 8037280570', '8037280570', 'Sani muhammad', '--', '02-11-2025 23:54:55'),
(67, 'Realmuktar', 'Opay Bank', '9028071200', 'Baana muktar Ibrahim', '--', '03-11-2025 08:50:33'),
(68, 'MuhammadShehu', 'OPAY', '7082379489', 'Muhammad Shehu Suleiman', '--', '03-11-2025 09:45:57'),
(69, 'Frechiee', 'Opay', '8165598694', 'FAISAL AUWAL BALA', '--', '03-11-2025 12:34:36'),
(70, 'Anisa', 'Opay', '8138590097', 'Saratu muhammad buhari', '--', '03-11-2025 16:35:57'),
(71, 'Ismailamuhammad', 'Opay', '8024322525', 'Mohammed Alhaji Duada', '--', '03-11-2025 17:13:25'),
(72, 'Vicky', 'Monipoint', '7026779627', 'Victor Emmanuel edet', '--', '03-11-2025 17:32:29'),
(73, 'Femi', 'Palmpay', '9071771635', 'Victoria Solomon Simon', '--', '03-11-2025 17:40:36'),
(74, 'Bawasa', 'ABUBAKAR SADIQ SHEHU', '9133990597', 'OPay', '--', '03-11-2025 18:08:24'),
(75, 'Kabirkankana', 'KABIRU HARUNA', '9066714713', 'Opay', '--', '03-11-2025 18:59:30'),
(76, 'Hamza', 'Opay', '9013090620', 'Muhmud Abdullahi', '--', '03-11-2025 21:56:43'),
(77, 'Taurancy', 'Opay', '8032420340', 'Ahmad Dalhatu Taura', '--', '03-11-2025 23:07:38'),
(78, 'Ssauki', 'Opay', '8160168397', 'Shehu Tijjani Abubakar', '--', '03-11-2025 23:29:28'),
(79, 'Anasbinimalik', 'opay', '7035971997', 'ANAS BINIMALIK SHAIBU', '--', '04-11-2025 00:59:26'),
(80, 'Harunab', 'Palmpay', '7065555175', 'Jafar umar', '--', '04-11-2025 06:02:25'),
(81, 'Umayma', 'Opay', '8067322295', 'Umaima aliyu', '--', '04-11-2025 06:29:54'),
(82, 'Babu', 'Opay', '9021938893', 'Ibrahim Zakariya Muhammad', '--', '04-11-2025 06:44:06'),
(83, 'Yakubuyacksoon', 'Opay', '7068723727', 'Yakubu Muhammad', '--', '04-11-2025 07:54:39'),
(84, 'Gisse', 'PalmPay', '7049739800', 'Jamilu dankama badamasi', '--', '04-11-2025 09:35:57'),
(85, 'Boss', 'Opay', '7045509992', 'ishak kabiru', '--', '04-11-2025 12:12:03'),
(86, 'Saiduumar', 'Opay', '8102871221', 'SAIDU SAID UMAR', '--', '04-11-2025 14:36:59'),
(87, 'Shamsudeen', 'Opay', '9093492537', 'Shamsudeen adamu', '--', '04-11-2025 19:54:23'),
(88, 'Musanura', 'Opay', '9166390584', 'Musa Nura Abdulkadir', '--', '04-11-2025 20:55:16'),
(89, 'Babaumar', 'Opay', 'Umar Yusif', '7012905155', '--', '04-11-2025 21:27:56'),
(90, 'Munkailu', 'Opay', '9012591727', 'munkailu ibrahim', '--', '04-11-2025 22:57:46'),
(91, 'Yakubu', 'Opay', '9130587819', 'Yakubu hamisu', '--', '04-11-2025 23:46:31'),
(92, 'ABKMUHAMMAD', 'FIRST BANK OF NIGERI', 'MUHAMMAD A', '3225719447', '--', '05-11-2025 07:52:28'),
(93, 'Maroicardi', 'Opay', '7049679708', 'Mustapha bukar', '--', '05-11-2025 11:42:44'),
(94, 'Muhammadsaleh', 'Palmpay', '9075127502', 'Wasila ismail', '--', '05-11-2025 19:03:47'),
(95, 'Adamcy', 'Opay', '9065041392', 'Adamu Umar musa', '--', '05-11-2025 21:24:43'),
(96, 'sadeeq', 'Opay', '7031121315', 'Abubakar', '--', '06-11-2025 10:37:34'),
(97, 'mustaphadange', 'Opay', '8164790849', 'Zayyanu Abubakar', '--', '06-11-2025 17:53:25'),
(98, 'shazali', 'zenith bank', '4291768643', 'shazali umar', '--', '06-11-2025 21:43:32'),
(99, 'Sirumar', 'Opay', '8064514729', 'Umar saunsi shagari', '--', '07-11-2025 10:50:23'),
(100, 'Bulama', 'Opay', '8026534065', 'Aliyu Bla', '--', '09-11-2025 00:00:27'),
(101, 'Danmadara', 'Opay', '815 982 74', 'Abdullahi Abdullahi nasiru', '--', '09-11-2025 12:31:20'),
(102, 'Legendbaby', 'Opay', '7015791423', 'Abdulsalam adamu', '--', '09-11-2025 20:32:28'),
(103, 'GRO_45211', 'Access bank', '0869585767', 'Nicholas Ayomide Daramola', '--', '19-09-2026 15:07:56'),
(104, 'GRO_55421', 'Opay', '9031875236', 'Nicholas Ayomide Daramola', '--', '23-09-2026 00:49:06'),
(105, 'GRO_41704', 'Destiny onyedika ugw', '4324459924', 'Zenith bank', '--', '30-09-2026 19:05:02'),
(106, 'GRO_34188', 'Paga', '1084716478', 'Joshua chukwuebuka', '--', '01-10-2026 06:56:51'),
(107, 'GRO_45556', 'Eneh precious ifunan', '9071638390', 'Opay', '--', '01-10-2026 10:00:04'),
(108, 'GRO_87678', 'Opay', '0816118511', 'Chiamaka Colette Ogu', '--', '01-10-2026 11:01:05'),
(109, 'GRO_91189', 'Opay', '9032909283', 'OLABISI NNENNA SAMUEL', '--', '01-10-2026 11:44:45'),
(110, 'GRO_25658', 'Opay', '7077770557', 'omidiora ezekiel abioye', '--', '01-10-2026 12:18:30'),
(111, 'GRO_49216', 'Opay', '8154231838', 'Tetan Daniel', '--', '01-10-2026 12:22:36'),
(112, 'GRO_56480', 'Access bank', '0057572850', 'Shuaibu Hussaini ishaq', '--', '01-10-2026 14:57:25'),
(113, 'GRO_51473', 'Florence benjamin', '2155321052', 'UBA', '--', '01-10-2026 15:48:00'),
(114, 'GRO_76505', 'Gift ikenga', '2089846430', 'UBA', '--', '01-10-2026 17:35:27'),
(115, 'GRO_93240', 'Opay', '8132448923', 'Miracle ugochukwu ukeka', '--', '02-10-2026 08:06:59'),
(116, 'GRO_37322', 'Access', '1903439324', 'Nnaji Naomi Chinecherem', '--', '02-10-2026 08:14:29'),
(117, 'GRO_71831', 'Palmpay', '7066793026', 'Eze Chinomnso', '--', '02-10-2026 10:09:54'),
(118, 'GRO_60046', 'First', '2018210275', 'Sylvester Nweze', '--', '02-10-2026 13:53:20'),
(119, 'GRO_11554', 'First bank', '3072852227', 'Ikenga Juliet nnenna', '--', '02-10-2026 14:30:02'),
(120, 'GRO_72559', 'Opay', '9071949834', 'Obey Solomon uzodima', '--', '02-10-2026 15:40:01'),
(121, 'GRO_93186', 'Opay', '9029785320', 'Oghogho osayemwren', '--', '02-10-2026 21:01:44'),
(122, 'GRO_36178', 'First bank', '3134777545', 'Faith', '--', '03-10-2026 08:30:47'),
(123, 'GRO_50847', 'First bank', '3072852227', 'Ikenga Juliet nnenna', '--', '03-10-2026 08:39:11'),
(124, 'GRO_62825', 'First bank', '3134777545', 'Faith', '--', '03-10-2026 08:47:50'),
(125, 'GRO_36000', 'First bank', '3134777545', 'Faith', '--', '03-10-2026 08:51:44'),
(126, 'GRO_16561', 'Keystone Bank', '6037301305', 'John Paul', '--', '03-10-2026 13:35:37'),
(127, 'GRO_65128', 'Palmpay', '7068681602', 'Salome Jumbo', '--', '03-10-2026 17:02:42'),
(128, 'GRO_67471', 'UBA', '2089846430', 'Gift ikenga', '--', '03-10-2026 17:03:43'),
(129, 'GRO_38164', 'UBA', '2089846430', 'Gift ikenga', '--', '03-10-2026 17:07:07'),
(130, 'GRO_24401', 'Fidelity bank', '6671257791', 'Vivian Ada Olah', '--', '04-10-2026 08:55:03'),
(131, 'GRO_79033', 'ACCESS  BANK', '0053877448', 'EZEALA QUEEN C', '--', '04-10-2026 19:34:17');

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

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` int NOT NULL,
  `bank` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `cableprices`
--

CREATE TABLE `cableprices` (
  `id` int NOT NULL,
  `cable` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `plan` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `serviceid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `claimed_tasks`
--

CREATE TABLE `claimed_tasks` (
  `id` int NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `task_id` int NOT NULL,
  `claimed_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `claimed_tasks`
--

INSERT INTO `claimed_tasks` (`id`, `username`, `task_id`, `claimed_at`) VALUES
(1, 'Legendnikky', 7, '2025-09-24 23:34:58'),
(2, 'Legendnikky', 6, '2025-09-24 23:35:12'),
(3, 'Legendnikky', 5, '2025-09-24 23:35:14'),
(4, 'Legendnikky', 8, '2025-09-24 23:53:11');

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

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int NOT NULL,
  `vendor` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `coupon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `vendor`, `coupon`, `status`, `type`, `date`) VALUES
(1, 'Marvis', 'TESTCODE', 'active', 'plan_a', ''),
(2, 'Marvis', 'TESTCODE1', 'used', 'plan_a', ''),
(3, 'selfVendor', 'LITE5M0SILFGUQ2Q', 'used', 'plan_a', '11-09-2024 13:12:23'),
(4, 'selfVendor', 'SMARTYBTU6UP74EF7', 'used', 'plan_b', '11-09-2024 13:15:07'),
(5, 'selfVendor', 'LITE1M1P8HBIY7KX', 'used', 'plan_a', '17-09-2025 10:42:15'),
(6, 'selfVendor', 'IGNITE-PAIDNM7YRW52PGUK', 'active', 'plan_b', '17-09-2025 14:41:39'),
(7, 'selfVendor', 'IGNITE-PAIDEFIOUE92C7IX', 'used', 'plan_b', '17-09-2025 17:41:51'),
(8, 'selfVendor', 'IGNITE-PAIDUIWIHJUK592J', 'used', 'plan_b', '17-09-2025 17:41:51'),
(9, 'selfVendor', 'IGNITE-PAID4INAQMLQ6YWV', 'active', 'plan_b', '17-09-2025 17:41:51'),
(10, 'selfVendor', 'IGNITE-PAIDM3BMRZ2UXBN8', 'used', 'plan_b', '17-09-2025 17:41:51'),
(11, 'selfVendor', 'IGNITE-PAID5GAY8ZGO8VQN', 'used', 'plan_b', '17-09-2025 17:41:51'),
(12, 'selfVendor', 'IGNITE-PAIDCNFS3I139B9S', 'active', 'plan_b', '19-09-2025 07:42:55'),
(13, 'Samtux', 'IGNITE-PAIDNJQ60XV0MWK1', 'active', 'plan_b', '19-09-2025 07:46:20'),
(14, 'Samtux', 'IGNITE-PAIDPXMX3HYRRI4H', 'active', 'plan_b', '19-09-2025 07:46:20'),
(15, 'Samtux', 'IGNITE-PAID9Z60X5TUJLU4', 'active', 'plan_b', '19-09-2025 07:46:20'),
(16, 'Samtux', 'IGNITE-PAID8VCUDRT505VU', 'active', 'plan_b', '19-09-2025 07:46:20'),
(17, 'Samtux', 'IGNITE-PAID0H0TDF27NH2Q', 'used', 'plan_b', '19-09-2025 07:46:20'),
(18, 'selfVendor', 'IGNITE-PAIDFLROFTBKV0CU', 'used', 'plan_b', '23-09-2025 23:48:23');

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

--
-- Table structure for table `dailyearn`
--

CREATE TABLE `dailyearn` (
  `id` int NOT NULL,
  `username` varchar(20) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dailylogin`
--

CREATE TABLE `dailylogin` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dailylogin`
--

INSERT INTO `dailylogin` (`id`, `username`, `amount`, `date`) VALUES
(1, 'Samtux', '50', '19-09-2025 08:00:09'),
(2, 'Samtux', '50', '23-09-2025 09:06:16'),
(3, 'Promise', '50', '24-09-2025 07:20:54'),
(4, 'Legendnikky', '50', '25-09-2025 00:07:56'),
(5, 'Legendnikky', '50', '26-09-2025 05:36:13'),
(6, 'Legendnikky', '50', '27-09-2025 09:15:24'),
(7, 'Legendnikky', '50', '30-09-2025 14:26:39');

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

--
-- Table structure for table `dailytasks`
--

CREATE TABLE `dailytasks` (
  `id` int NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `status` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `reference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `dailyvideo`
--

CREATE TABLE `dailyvideo` (
  `id` int NOT NULL,
  `title` varchar(30) NOT NULL,
  `description` varchar(30) NOT NULL,
  `url` varchar(300) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `reference` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `dataprices`
--

CREATE TABLE `dataprices` (
  `id` int NOT NULL,
  `network` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `serviceid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `dataplan` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `datatype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `dataprices`
--

INSERT INTO `dataprices` (`id`, `network`, `serviceid`, `amount`, `dataplan`, `datatype`, `date`) VALUES
(157, 'mtn', '110', '6000', '500MB', 'sme', '11-08-2022 13:49:20'),
(158, 'mtnn', '111', '1500', '1GB', 'sme', '11-08-2022 13:49:20'),
(159, 'mtnn', '112', '3000', '2GB', 'sme', '11-08-2022 13:49:20'),
(160, 'mtnn', '114', '10000', '5GB', 'sme', '11-08-2022 13:49:20'),
(161, 'mtnn', '115', '20000', '10GB', 'sme', '11-08-2022 13:49:20'),
(162, 'mtnn', '120', '1000', '500MB', 'cg', '11-08-2022 13:49:20'),
(163, 'mtnn', '121', '1500', '1GB', 'cg', '11-08-2022 13:49:20'),
(164, 'mtnn', '122', '3000', '2GB', 'cg', '11-08-2022 13:49:20'),
(165, 'mtnn', '124', '10000', '5GB', 'cg', '11-08-2022 13:49:20'),
(166, 'mtnn', '125', '20000', '10GB', 'cg', '11-08-2022 13:49:20'),
(167, 'glo', '210', '2000', '1.35GB', 'direct', '11-08-2022 13:56:45'),
(168, 'glo', '211', '4000', '2.90GB', 'direct', '11-08-2022 13:56:45'),
(169, 'glo', '212', '9000', '4.10GB', 'direct', '11-08-2022 13:56:45'),
(170, 'glo', '213', '16000', '5.80GB', 'direct', '11-08-2022 13:56:45'),
(171, 'glo', '215', '21000', '10GB', 'direct', '11-08-2022 13:56:45'),
(172, 'airtel', '310', '6000', '500MB', 'cg', '11-08-2022 13:57:57'),
(173, 'airtell', '311', '1500', '1GB', 'cg', '11-08-2022 13:57:57'),
(174, 'airtell', '312', '3000', '2GB', 'cg', '11-08-2022 13:57:57'),
(175, 'airtell', '314', '10000', '5GB', 'cg', '11-08-2022 13:57:57'),
(176, 'airtell', '315', '20000', '10GB', 'cg', '11-08-2022 13:57:57'),
(177, '9mobile', '410', '6000', '500MB', 'direct', '11-08-2022 13:59:04'),
(178, '9mobilee', '411', '2000', '1.5GB', 'direct', '11-08-2022 13:59:04'),
(179, '9mobilee', '412', '3500', '2GB', 'direct', '11-08-2022 13:59:04'),
(180, '9mobilee', '413', '8500', '3GB', 'direct', '11-08-2022 13:59:04'),
(181, '9mobilee', '415', '22000', '11GB', 'direct', '11-08-2022 13:59:04');

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

--
-- Table structure for table `earningstructure`
--

CREATE TABLE `earningstructure` (
  `id` int NOT NULL,
  `dailylogin` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `refbonus` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `welbonus` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `minrefwth` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `indref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `thirdindref` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `minactwth` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `mindatawth` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `spamt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `taskamt` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `earningstructure`
--

INSERT INTO `earningstructure` (`id`, `dailylogin`, `refbonus`, `welbonus`, `minrefwth`, `indref`, `thirdindref`, `minactwth`, `mindatawth`, `spamt`, `taskamt`, `type`, `date`) VALUES
(7, '0', '0', '300', '1', '0', '0', '1', '0', '50', '40', 'plan_a', '20-05-2024 17:45:46'),
(8, '50', '200', '300', '1', '0', '0', '1', '0', '50', '40', 'plan_b', '19-09-2025 08:02:52');

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

--
-- Table structure for table `electricity`
--

CREATE TABLE `electricity` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apireference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `serviceid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `productname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amountpaid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `apiamount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `meternum` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `metertype` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `customername` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `token` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tokenvalue` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tokenamount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `units` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tarrif` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `receiptnum` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `discount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `uniqueelement` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `flow_admins`
--

CREATE TABLE `flow_admins` (
  `id` int NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_admins`
--

INSERT INTO `flow_admins` (`id`, `username`, `email`, `password`, `created_at`) VALUES
(1, 'admin', 'admin@example.com', '$2y$10$8oIsfwxg9RHqjGbVwR.04eOaL4k5XxL8gBY7iH/zwv.eDSXuPXtDy', '2025-09-27 08:41:49');

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

--
-- Table structure for table `flow_balance`
--

CREATE TABLE `flow_balance` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `current_balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_deposit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_withdrawal` decimal(10,2) NOT NULL DEFAULT '0.00',
  `last_updated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_balance`
--

INSERT INTO `flow_balance` (`id`, `user_id`, `current_balance`, `total_deposit`, `total_withdrawal`, `last_updated`) VALUES
(1, 1, 1000.00, 0.00, 1000.00, '2025-10-01 11:37:51');

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

--
-- Table structure for table `flow_bonus_logs`
--

CREATE TABLE `flow_bonus_logs` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` enum('won','lost') NOT NULL,
  `chosen_card` tinyint(1) NOT NULL,
  `winning_card` tinyint(1) NOT NULL,
  `play_date` date NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `flow_bonus_logs`
--

INSERT INTO `flow_bonus_logs` (`id`, `user_id`, `amount`, `status`, `chosen_card`, `winning_card`, `play_date`, `created_at`) VALUES
(1, 3335, 0.00, 'lost', 2, 3, '2026-09-19', '2026-09-19 13:56:34'),
(2, 3340, 500.00, 'won', 2, 2, '2026-09-19', '2026-09-19 17:48:58'),
(3, 3339, 0.00, 'lost', 1, 3, '2026-09-19', '2026-09-19 17:49:01'),
(4, 3341, 500.00, 'won', 2, 2, '2026-09-20', '2026-09-20 15:20:02'),
(5, 3341, 500.00, 'won', 1, 1, '2026-09-21', '2026-09-21 15:52:41'),
(6, 3355, 0.00, 'lost', 2, 3, '2026-09-29', '2026-09-29 15:08:54'),
(7, 3369, 0.00, 'lost', 3, 1, '2026-10-01', '2026-10-01 09:34:51'),
(8, 3371, 0.00, 'lost', 1, 3, '2026-10-01', '2026-10-01 10:22:18'),
(9, 3375, 0.00, 'lost', 1, 2, '2026-10-01', '2026-10-01 11:19:25'),
(10, 3395, 0.00, 'lost', 1, 3, '2026-10-02', '2026-10-02 07:26:47'),
(11, 3403, 0.00, 'lost', 1, 2, '2026-10-02', '2026-10-02 20:02:15'),
(12, 3404, 0.00, 'lost', 1, 2, '2026-10-03', '2026-10-03 06:21:45'),
(13, 3400, 20.00, 'won', 3, 3, '2026-10-03', '2026-10-03 06:25:33'),
(14, 3409, 0.00, 'lost', 1, 2, '2026-10-04', '2026-10-04 07:57:05'),
(15, 3412, 0.00, 'lost', 2, 1, '2026-10-04', '2026-10-04 18:45:05');

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

--
-- Table structure for table `flow_deposits`
--

CREATE TABLE `flow_deposits` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` enum('pending','approved','rejected') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'pending',
  `proof_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `admin_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `approved_at` timestamp NULL DEFAULT NULL,
  `approved_by` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_deposits`
--

INSERT INTO `flow_deposits` (`id`, `user_id`, `transaction_id`, `amount`, `payment_method`, `status`, `proof_image`, `admin_notes`, `created_at`, `updated_at`, `approved_at`, `approved_by`) VALUES
(1, 3338, 'TXN17898295366054', 100000.00, 'Bank Transfer', 'approved', '04be7432ea5765b808e54dd0eaba0dfd.jpeg', NULL, '2026-09-19 14:52:16', '2026-09-19 14:52:32', NULL, NULL),
(2, 3340, 'TXN17898395544828', 50000.00, 'Bank Transfer', 'approved', '55c26488935c02e7b26715fa124a346f.jpg', NULL, '2026-09-19 17:39:14', '2026-09-19 17:39:34', NULL, NULL),
(3, 3341, 'TXN17900042821318', 1000.00, 'Bank Transfer', 'approved', 'd5f5a8653f32f883d9a080132abc89ee.jpg', NULL, '2026-09-21 15:24:42', '2026-09-21 15:25:29', NULL, NULL),
(4, 3344, 'TXN17900065586581', 3500.00, 'Bank Transfer', 'approved', 'e7e826136a704ce95d6ec00affaa957c.png', NULL, '2026-09-21 16:02:38', '2026-09-21 16:05:23', NULL, NULL),
(5, 3341, 'TXN17900335836412', 15000.00, 'Bank Transfer', 'approved', '3e1306e6c27fccf6db1f68e44b17b7fc.jpg', NULL, '2026-09-21 23:33:03', '2026-09-21 23:33:45', NULL, NULL),
(6, 3345, 'TXN17900342936962', 15000.00, 'Bank Transfer', 'approved', '87e8f9ca7b589c2e2f79c5c3535d4740.jpeg', NULL, '2026-09-21 23:44:53', '2026-09-21 23:47:52', NULL, NULL),
(7, 3350, 'TXN17900438082077', 15000.00, 'Bank Transfer', '', '2305944b3b51f0188999bf06771c2a72.jpeg', 'Not valid', '2026-09-22 02:23:28', '2026-09-22 02:26:27', NULL, NULL),
(8, 3353, 'TXN17901207531066', 500000.00, 'Bank Transfer', 'approved', '8f518b93e0817447d1a9147f6634c0dc.jpeg', NULL, '2026-09-22 23:45:53', '2026-09-22 23:46:09', NULL, NULL),
(9, 3362, 'TXN17908366052866', 20000.00, 'Bank Transfer', 'approved', '8fbb3b066cacb29fde7c5dc3048bfe65.jpg', NULL, '2026-10-01 06:36:45', '2026-10-01 06:39:48', NULL, NULL),
(10, 3366, 'TXN17908413894381', 10000.00, 'Bank Transfer', 'approved', 'a2347ac7a27f2622c403e4121df4fe23.png', NULL, '2026-10-01 07:56:29', '2026-10-01 07:57:45', NULL, NULL),
(11, 3370, 'TXN17908560132846', 20000.00, 'Bank Transfer', 'approved', 'a5ae020032b69cde11361362bd0efe67.png', NULL, '2026-10-01 12:00:13', '2026-10-01 12:01:40', NULL, NULL),
(12, 3380, 'TXN17908656485711', 20000.00, 'Bank Transfer', 'approved', '78cc0addea547936750c6b1d32ef303c.jpeg', NULL, '2026-10-01 14:40:48', '2026-10-01 14:45:47', NULL, NULL),
(13, 3357, 'TXN17908721877498', 20000.00, 'Bank Transfer', 'approved', '663669a189ba796f7038f87d73966a72.jpg', NULL, '2026-10-01 16:29:47', '2026-10-01 16:30:07', NULL, NULL),
(14, 3382, 'TXN17908724279788', 20000.00, 'Bank Transfer', 'approved', '64347812b7c5647a8f39db878aefcb59.jpg', NULL, '2026-10-01 16:33:47', '2026-10-01 16:34:04', NULL, NULL),
(15, 3383, 'TXN17908727604401', 20000.00, 'Bank Transfer', 'approved', 'd9010e6dfaf99f3cc420d0a9d89d9b4b.jpg', NULL, '2026-10-01 16:39:20', '2026-10-01 16:39:34', NULL, NULL),
(16, 3384, 'TXN17908903318222', 10000.00, 'Bank Transfer', 'approved', '96455ac1adbb9304b931b6bc9ee72f38.png', NULL, '2026-10-01 21:32:11', '2026-10-02 02:46:39', NULL, NULL),
(17, 3384, 'TXN17908903636177', 10000.00, 'Bank Transfer', 'pending', '0bf1e7d6737e0f3bf92f108263b0ec68.png', NULL, '2026-10-01 21:32:43', '2026-10-01 21:32:43', NULL, NULL),
(18, 3384, 'TXN17908904081660', 10000.00, 'Bank Transfer', 'pending', '33a884f640f04169a4b01ab937417c78.png', NULL, '2026-10-01 21:33:28', '2026-10-01 21:33:28', NULL, NULL),
(19, 3384, 'TXN17908930474928', 10000.00, 'Bank Transfer', 'pending', '8efb9dee4eac28e8b4bc18b218f60e9d.png', NULL, '2026-10-01 22:17:27', '2026-10-01 22:17:27', NULL, NULL),
(20, 3387, 'TXN17909213445685', 20000.00, 'Bank Transfer', 'approved', 'aea78354e5fc6453148c1ca371fb895f.jpg', NULL, '2026-10-02 06:09:04', '2026-10-02 06:09:29', NULL, NULL),
(21, 3389, 'TXN17909217233872', 20000.00, 'Bank Transfer', 'approved', '98b01fe96c5706cc6b1fba9393b05bed.jpg', NULL, '2026-10-02 06:15:23', '2026-10-02 06:15:43', NULL, NULL),
(22, 3390, 'TXN17909232093803', 50000.00, 'Bank Transfer', 'approved', '8f638fcc84f82f4c3f347adc83137a45.jpg', NULL, '2026-10-02 06:40:09', '2026-10-02 06:40:32', NULL, NULL),
(23, 3392, 'TXN17909240213615', 50000.00, 'Bank Transfer', 'approved', '4ee2718be9c6abae9067523f9d432a5b.jpg', NULL, '2026-10-02 06:53:41', '2026-10-02 06:54:02', NULL, NULL),
(24, 3393, 'TXN17909243893628', 50000.00, 'Bank Transfer', 'approved', '7bf58311e133778316d0e4ffe8b33fff.jpg', NULL, '2026-10-02 06:59:49', '2026-10-02 07:00:08', NULL, NULL),
(25, 3391, 'TXN17909359126138', 20000.00, 'Bank Transfer', 'approved', '2629bc059c7d67a18a91e92abba52e37.jpg', NULL, '2026-10-02 10:11:52', '2026-10-02 10:12:14', NULL, NULL),
(26, 3400, 'TXN17909454183002', 10000.00, 'Bank Transfer', 'approved', '700c8d56db8acb5a716132951bdd3e63.jpg', NULL, '2026-10-02 12:50:18', '2026-10-02 14:17:45', NULL, NULL),
(27, 3363, 'TXN17909515933898', 10000.00, 'Bank Transfer', 'approved', '3069fcb514a2251307fd1f286d1b3c4a.png', NULL, '2026-10-02 14:33:13', '2026-10-02 14:57:27', NULL, NULL),
(28, 3399, 'TXN17909523672981', 20000.00, 'Bank Transfer', 'approved', 'c418fff98fb9749765c6c77f1edc7922.jpg', NULL, '2026-10-02 14:46:07', '2026-10-02 14:56:56', NULL, NULL),
(29, 3401, 'TXN17909567866400', 20000.00, 'Bank Transfer', 'approved', 'ae00b9fc7fa00ceca240da3c939a2519.png', NULL, '2026-10-02 15:59:46', '2026-10-02 16:06:55', NULL, NULL),
(30, 3391, 'TXN17910243684393', 1000000.00, 'Bank Transfer', 'approved', 'bb52eb1d22d9caf8e80aa023a6b5d977.jpg', NULL, '2026-10-03 10:46:08', '2026-10-03 10:50:33', NULL, NULL),
(31, 3405, 'TXN17910409557209', 20000.00, 'Bank Transfer', 'approved', '366b45603b796645116b83fad4d09360.jpg', NULL, '2026-10-03 15:22:35', '2026-10-03 15:23:03', NULL, NULL),
(32, 3406, 'TXN17910412121381', 50000.00, 'Bank Transfer', 'approved', '597fd3d4bce8079d090720ea08f0c68a.jpg', NULL, '2026-10-03 15:26:52', '2026-10-03 15:27:14', NULL, NULL),
(33, 3407, 'TXN17910416327654', 50000.00, 'Bank Transfer', '', 'ac6318033f0a70d577881118a12aadf9.jpg', 'Fake', '2026-10-03 15:33:52', '2026-10-03 15:34:26', NULL, NULL),
(34, 3407, 'TXN17910416966870', 20000.00, 'Bank Transfer', 'approved', '234a05fbdceccbd739d1f7d7dc73a05d.jpg', NULL, '2026-10-03 15:34:56', '2026-10-03 15:35:12', NULL, NULL),
(35, 3408, 'TXN17910976117091', 10000.00, 'Bank Transfer', 'approved', 'eabbbfe4e3bd0cff3973f9798e87194e.jpg', NULL, '2026-10-04 07:06:51', '2026-10-04 07:07:04', NULL, NULL),
(36, 3410, 'TXN17911381765824', 20000.00, 'Bank Transfer', 'approved', '0b76a69cd65b31895024921a3666eb16.jpg', NULL, '2026-10-04 18:22:56', '2026-10-04 18:23:52', NULL, NULL);

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

--
-- Table structure for table `flow_deposit_settings`
--

CREATE TABLE `flow_deposit_settings` (
  `id` int NOT NULL,
  `payment_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `min_amount` decimal(10,2) NOT NULL DEFAULT '1000.00',
  `max_amount` decimal(10,2) NOT NULL DEFAULT '1000000.00',
  `instructions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `bank_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `account_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_deposit_settings`
--

INSERT INTO `flow_deposit_settings` (`id`, `payment_method`, `is_active`, `min_amount`, `max_amount`, `instructions`, `bank_name`, `account_name`, `account_number`, `account_details`) VALUES
(1, 'Bank Transfer', 1, 10000.00, 2000000.00, 'Transfer to the account below and upload proof of payment', 'Palmpay', 'Rita uche', '8922996890', 'Bank: Example Bank\\nAccount Name: Example Account\\nAccount Number: 1234567890'),
(2, 'Bitcoin', 1, 1000.00, 1000000.00, 'Send Bitcoin to the wallet address below and upload proof of payment', NULL, NULL, NULL, 'Wallet Address: 1A1zP1eP5QGefi2DMPTfTL5SLmv7DivfNa'),
(3, 'Ethereum', 1, 1000.00, 1000000.00, 'Send Ethereum to the wallet address below and upload proof of payment', NULL, NULL, NULL, 'Wallet Address: 0x742d35Cc6634C0532925a3b844Bc9e7595f8568d');

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

--
-- Table structure for table `flow_packages`
--

CREATE TABLE `flow_packages` (
  `id` int NOT NULL,
  `category_id` int DEFAULT '1',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount` decimal(10,2) NOT NULL,
  `income_mode` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'daily',
  `daily_income` decimal(10,2) NOT NULL,
  `min_withdrawal` decimal(10,2) NOT NULL,
  `duration` int NOT NULL,
  `total_income` decimal(10,2) NOT NULL DEFAULT '0.00',
  `referral_bonus` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_packages`
--

INSERT INTO `flow_packages` (`id`, `category_id`, `name`, `image`, `amount`, `income_mode`, `daily_income`, `min_withdrawal`, `duration`, `total_income`, `referral_bonus`, `created_at`) VALUES
(12, 2, 'Starlink Horizon', NULL, 1000000.00, 'daily', 41000.00, 4000.00, 31, 1271000.00, 50000.00, '2025-10-31 16:58:33'),
(13, 2, 'Starlink Turbo', NULL, 500000.00, 'daily', 20000.00, 4000.00, 31, 620000.00, 25000.00, '2025-10-31 17:00:44'),
(14, 2, 'Starlink Boost', NULL, 200000.00, 'daily', 9500.00, 4000.00, 31, 294500.00, 16000.00, '2025-10-31 17:02:46'),
(15, 2, 'Starlink Core', NULL, 100000.00, 'daily', 5500.00, 4000.00, 31, 170500.00, 12000.00, '2025-10-31 17:03:28'),
(16, 2, 'Starlink Beacon', 'pkg_6aae88f89c721.png', 50000.00, 'daily', 3500.00, 10000.00, 31, 108500.00, 10000.00, '2026-09-19 12:56:29'),
(20, 2, 'Starlink Lite', NULL, 20000.00, 'daily', 2000.00, 0.00, 31, 62000.00, 4000.00, '2026-09-21 15:18:08'),
(21, 2, 'Starlink Base', NULL, 10000.00, 'daily', 1200.00, 0.00, 31, 37200.00, 2000.00, '2026-09-21 15:19:02'),
(22, 2, 'Starlink Premium', NULL, 2000000.00, 'daily', 80000.00, 0.00, 31, 2480000.00, 100000.00, '2026-09-30 17:01:30');

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

--
-- Table structure for table `flow_package_categories`
--

CREATE TABLE `flow_package_categories` (
  `id` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `status` tinyint(1) DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `flow_package_categories`
--

INSERT INTO `flow_package_categories` (`id`, `name`, `status`) VALUES
(1, 'Starlinks', 0),
(2, 'Starlink Packages', 1);

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

--
-- Table structure for table `flow_popup_settings`
--

CREATE TABLE `flow_popup_settings` (
  `id` int NOT NULL,
  `status` int DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT 'Announcement',
  `message` text,
  `btn_text` varchar(100) DEFAULT 'Click Here',
  `btn_link` varchar(255) DEFAULT '#'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `flow_popup_settings`
--

INSERT INTO `flow_popup_settings` (`id`, `status`, `image`, `title`, `message`, `btn_text`, `btn_link`) VALUES
(1, 1, '', 'WELCOME TO THE STARLINKS OFFICIAL WEBSITE 🎉', 'You have made a bold step being a partner at \"Starlinks\". We are In a long term partnership with a grocery store, which has decided to help people invest their funds in personal groceries and get returns 🎉.', 'Join us now', '#');

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

--
-- Table structure for table `flow_promo_claims`
--

CREATE TABLE `flow_promo_claims` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `milestone` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `flow_promo_claims`
--

INSERT INTO `flow_promo_claims` (`id`, `user_id`, `milestone`, `amount`, `created_at`) VALUES
(1, 3335, 1, 1000.00, '2026-09-19 15:03:13'),
(2, 3339, 1, 1000.00, '2026-09-19 17:40:34'),
(3, 3362, 1, 1000.00, '2026-10-01 10:32:36'),
(4, 3359, 1, 1000.00, '2026-10-02 18:11:07');

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

--
-- Table structure for table `flow_referrals`
--

CREATE TABLE `flow_referrals` (
  `id` int NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `referral` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `flow_referral_bonuses`
--

CREATE TABLE `flow_referral_bonuses` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `referred_user_id` int NOT NULL,
  `package_id` int NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','paid') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `paid_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `flow_settings`
--

CREATE TABLE `flow_settings` (
  `id` int NOT NULL,
  `setting_key` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `setting_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_settings`
--

INSERT INTO `flow_settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`) VALUES
(1, 'withdrawal_enabled', '0', '2025-09-27 08:27:22', '2026-10-03 20:00:36'),
(2, 'min_withdrawal', '1200', '2025-09-27 08:27:22', '2026-09-21 15:55:29'),
(5, 'max_withdrawal', '10000000', '2025-10-03 08:54:54', '2026-09-21 15:55:29'),
(6, 'bonus_enabled', '1', '2026-09-19 13:56:28', '2026-09-19 13:56:28'),
(7, 'bonus_amount', '20', '2026-09-19 13:56:28', '2026-09-21 15:57:14');

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

--
-- Table structure for table `flow_tasks`
--

CREATE TABLE `flow_tasks` (
  `id` int NOT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_tasks`
--

INSERT INTO `flow_tasks` (`id`, `name`, `link`, `amount`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Join the Group ', 'https://nikkymedia.com.ng', 1000.00, 'Yes', 'active', '2025-10-01 11:42:06', '2025-10-01 11:42:06'),
(2, 'Join the Group ', 'https://nikkymedia.com.ng', 1000.00, 'Yes', 'active', '2025-10-01 11:53:50', '2025-10-01 11:53:50'),
(3, 'Me ', 'https://nikkymedia.com.ng', 100000.00, 'Done ', 'active', '2025-10-01 11:54:14', '2025-10-01 11:54:14'),
(4, 'Done', 'https://nikkymedia.com.ng', 500000.00, 'Do it now ', 'active', '2025-10-01 11:57:06', '2025-10-01 11:57:06'),
(5, 'Testing it ', 'https://nikkymedia.com.ng', 98000.00, 'Welcome Done ', 'active', '2025-10-01 12:08:01', '2025-10-01 12:08:01');

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

--
-- Table structure for table `flow_transactions`
--

CREATE TABLE `flow_transactions` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_transactions`
--

INSERT INTO `flow_transactions` (`id`, `user_id`, `transaction_id`, `amount`, `type`, `description`, `created_at`) VALUES
(1, 3335, 'WD17898258093169', 5000.00, 'withdrawal', 'Withdrawal approved', '2026-09-19 09:50:09'),
(2, 3335, 'WD17898278965503', 10000.00, 'withdrawal', 'Withdrawal approved', '2026-09-19 10:24:56'),
(3, 3338, 'DEP17898295528384', 100000.00, 'deposit', 'Deposit approved - Txn: TXN17898295366054', '2026-09-19 10:52:32'),
(4, 3338, 'PKG1789829824548', 7000.00, 'package_purchase', 'Purchased Package: GainPack', '2026-09-19 10:57:04'),
(5, 3338, 'PKG1789829832525', 7000.00, 'package_purchase', 'Purchased Package: GainPack', '2026-09-19 10:57:12'),
(6, 3338, 'PKG1789829984379', 7000.00, 'package_purchase', 'Purchased Package: GainPack', '2026-09-19 10:59:44'),
(7, 3338, 'PKG1789830006483', 3.00, 'package_purchase', 'Purchased Package: Grocery Sprint 1', '2026-09-19 11:00:06'),
(8, 3338, 'PKG1789830016197', 3.00, 'package_purchase', 'Purchased Package: Grocery Sprint 1', '2026-09-19 11:00:16'),
(9, 3338, 'PKG1789830166242', 40000.00, 'package_purchase', 'Purchased Package: GainPro', '2026-09-19 11:02:46'),
(10, 3335, 'REF1789830166205', 10000.00, 'referral_commission', 'Level 1 Commission (25%) from GRO_37555', '2026-09-19 11:02:46'),
(11, 3335, 'PRM1789830193712', 1000.00, 'bonus', 'Promoter Bonus Claim -1 Active Refs', '2026-09-19 11:03:13'),
(12, 3340, 'DEP17898395741771', 50000.00, 'deposit', 'Deposit approved - Txn: TXN17898395544828', '2026-09-19 13:39:34'),
(13, 3340, 'PKG1789839608118', 40000.00, 'package_purchase', 'Purchased Package: GainPro', '2026-09-19 13:40:08'),
(14, 3339, 'REF1789839608181', 10000.00, 'referral_commission', 'Level 1 Commission (25%) from GRO_37086', '2026-09-19 13:40:08'),
(15, 3339, 'PRM1789839634145', 1000.00, 'bonus', 'Promoter Bonus Claim -1 Active Refs', '2026-09-19 13:40:34'),
(16, 3340, 'BNS1789840138337', 500.00, 'bonus', 'Daily Bonus Reward', '2026-09-19 13:48:58'),
(17, 3341, 'BNS1789917602612', 500.00, 'bonus', 'Daily Bonus Reward', '2026-09-20 11:20:02'),
(18, 3341, 'DEP17900043295548', 1000.00, 'deposit', 'Deposit approved - Txn: TXN17900042821318', '2026-09-21 11:25:29'),
(19, 3341, 'BNS1790005961655', 500.00, 'bonus', 'Daily Bonus Reward', '2026-09-21 11:52:41'),
(20, 3344, 'DEP17900067237065', 3500.00, 'deposit', 'Deposit approved - Txn: TXN17900065586581', '2026-09-21 12:05:23'),
(21, 3341, 'DEP17900336258915', 15000.00, 'deposit', 'Deposit approved - Txn: TXN17900335836412', '2026-09-21 19:33:45'),
(22, 3345, 'DEP17900344725304', 15000.00, 'deposit', 'Deposit approved - Txn: TXN17900342936962', '2026-09-21 19:47:52'),
(23, 3353, 'DEP17901207695103', 500000.00, 'deposit', 'Deposit approved - Txn: TXN17901207531066', '2026-09-22 23:46:09'),
(24, 3355, 'PKG1790694736733', 100000.00, 'package_purchase', 'Purchased Package: Gain elite', '2026-09-29 11:12:16'),
(25, 3355, 'PKG1790753003215', 250000.00, 'package_purchase', 'Purchased Package: New One', '2026-09-30 03:23:23'),
(26, 3355, 'ROI_ADJ_1790753307330', 30000.00, 'roi', 'Periodic Return (1 cycles) on New One', '2026-09-30 03:28:27'),
(27, 3355, 'ROI_ADJ_1790753636159', 30000.00, 'roi', 'Periodic Return (1 cycles) on New One', '2026-09-30 03:33:56'),
(28, 3355, 'ROI_ADJ_1790754048303', 30000.00, 'roi', 'Periodic Return (1 cycles) on New One', '2026-09-30 03:40:48'),
(29, 3360, 'PKG1790754128460', 250000.00, 'package_purchase', 'Purchased Package: New One', '2026-09-30 03:42:08'),
(30, 3355, 'REF1790754128255', 15000.00, 'referral_commission', 'Direct Commission from GRO_25262 buying New One', '2026-09-30 03:42:08'),
(31, 3355, 'ROI_ADJ_1790754203455', 30000.00, 'roi', 'Periodic Return (1 cycles) on New One', '2026-09-30 03:43:23'),
(32, 3355, 'ROI_ADJ_1790783174993', 12500.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-09-30 11:46:14'),
(33, 3362, 'DEP17908367881506', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908366052866', '2026-10-01 02:39:48'),
(34, 3362, 'PKG1790836844409', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 02:40:44'),
(35, 3358, 'REF1790836844765', 4000.00, 'referral_commission', 'Direct Commission from GRO_34188 buying Starlink Lite', '2026-10-01 02:40:44'),
(36, 3366, 'DEP17908414654872', 10000.00, 'deposit', 'Deposit approved - Txn: TXN17908413894381', '2026-10-01 03:57:45'),
(37, 3366, 'PKG1790841677981', 10000.00, 'package_purchase', 'Purchased Package: Starlink Base', '2026-10-01 04:01:17'),
(38, 3362, 'REF1790841677794', 2000.00, 'referral_commission', 'Direct Commission from GRO_45556 buying Starlink Base', '2026-10-01 04:01:17'),
(39, 3362, 'PRM1790850756876', 1000.00, 'bonus', 'Promoter Bonus Claim -1 Active Refs', '2026-10-01 06:32:36'),
(40, 3370, 'DEP17908561009316', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908560132846', '2026-10-01 08:01:40'),
(41, 3370, 'PKG1790856288792', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 08:04:48'),
(42, 3358, 'REF1790856288891', 4000.00, 'referral_commission', 'Direct Commission from GRO_87678 buying Starlink Lite', '2026-10-01 08:04:48'),
(43, 3380, 'DEP17908659471650', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908656485711', '2026-10-01 10:45:47'),
(44, 3380, 'PKG1790865976819', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 10:46:16'),
(45, 3361, 'REF1790865976610', 4000.00, 'referral_commission', 'Direct Commission from GRO_51473 buying Starlink Lite', '2026-10-01 10:46:16'),
(46, 3357, 'DEP17908722079138', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908721877498', '2026-10-01 12:30:07'),
(47, 3357, 'PKG1790872230124', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 12:30:30'),
(48, 3382, 'DEP17908724442790', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908724279788', '2026-10-01 12:34:04'),
(49, 3382, 'PKG1790872462929', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 12:34:22'),
(50, 3380, 'REF1790872462353', 4000.00, 'referral_commission', 'Direct Commission from GRO_76505 buying Starlink Lite', '2026-10-01 12:34:22'),
(51, 3383, 'DEP17908727744006', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17908727604401', '2026-10-01 12:39:34'),
(52, 3383, 'PKG1790872800260', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-01 12:40:00'),
(53, 3382, 'REF1790872800723', 4000.00, 'referral_commission', 'Direct Commission from GRO_67471 buying Starlink Lite', '2026-10-01 12:40:00'),
(54, 3384, 'DEP17909091991470', 10000.00, 'deposit', 'Deposit approved - Txn: TXN17908903318222', '2026-10-01 22:46:39'),
(55, 3384, 'PKG1790914895384', 10000.00, 'package_purchase', 'Purchased Package: Starlink Base', '2026-10-02 00:21:35'),
(56, 3387, 'DEP17909213693451', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17909213445685', '2026-10-02 02:09:29'),
(57, 3387, 'PKG1790921403691', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-02 02:10:03'),
(58, 3361, 'REF1790921403980', 4000.00, 'referral_commission', 'Direct Commission from GRO_11554 buying Starlink Lite', '2026-10-02 02:10:03'),
(59, 3389, 'DEP17909217433786', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17909217233872', '2026-10-02 02:15:43'),
(60, 3389, 'PKG1790921780574', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-02 02:16:20'),
(61, 3387, 'REF1790921780721', 4000.00, 'referral_commission', 'Direct Commission from GRO_50847 buying Starlink Lite', '2026-10-02 02:16:20'),
(62, 3390, 'DEP17909232322067', 50000.00, 'deposit', 'Deposit approved - Txn: TXN17909232093803', '2026-10-02 02:40:32'),
(63, 3362, 'ROI_ADJ_1790923250810', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-02 02:40:50'),
(64, 3390, 'PKG1790923255294', 50000.00, 'package_purchase', 'Purchased Package: Starlink Beacon', '2026-10-02 02:40:55'),
(65, 3387, 'REF1790923255346', 10000.00, 'referral_commission', 'Direct Commission from GRO_36178 buying Starlink Beacon', '2026-10-02 02:40:55'),
(66, 3392, 'DEP17909240428867', 50000.00, 'deposit', 'Deposit approved - Txn: TXN17909240213615', '2026-10-02 02:54:02'),
(67, 3392, 'PKG1790924059805', 50000.00, 'package_purchase', 'Purchased Package: Starlink Beacon', '2026-10-02 02:54:19'),
(68, 3390, 'REF1790924059418', 10000.00, 'referral_commission', 'Direct Commission from GRO_62825 buying Starlink Beacon', '2026-10-02 02:54:19'),
(69, 3393, 'DEP17909244081161', 50000.00, 'deposit', 'Deposit approved - Txn: TXN17909243893628', '2026-10-02 03:00:08'),
(70, 3393, 'PKG1790924428422', 50000.00, 'package_purchase', 'Purchased Package: Starlink Beacon', '2026-10-02 03:00:28'),
(71, 3390, 'REF1790924428117', 10000.00, 'referral_commission', 'Direct Commission from GRO_36000 buying Starlink Beacon', '2026-10-02 03:00:28'),
(72, 3380, 'WD17909265441857', 4300.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 03:35:44'),
(73, 3362, 'WD17909265853695', 5100.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 03:36:25'),
(74, 3361, 'WD17909270829113', 8300.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 03:44:42'),
(75, 3366, 'ROI_ADJ_1790928781974', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-02 04:13:01'),
(76, 3391, 'DEP17909359342286', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17909359126138', '2026-10-02 06:12:14'),
(77, 3391, 'PKG1790935957258', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-02 06:12:37'),
(78, 3382, 'REF1790935957842', 4000.00, 'referral_commission', 'Direct Commission from GRO_76712 buying Starlink Lite', '2026-10-02 06:12:37'),
(79, 3370, 'ROI_ADJ_1790942767688', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-02 08:06:07'),
(80, 3370, 'WD17909467752351', 2000.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 09:12:55'),
(81, 3366, 'WD17909469216330', 1300.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 09:15:21'),
(82, 3400, 'DEP17909506656738', 10000.00, 'deposit', 'Deposit approved - Txn: TXN17909454183002', '2026-10-02 10:17:45'),
(83, 3382, 'WD17909508055090', 8300.00, 'withdrawal', 'Withdrawal approved', '2026-10-02 10:20:05'),
(84, 3399, 'DEP17909530163803', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17909523672981', '2026-10-02 10:56:56'),
(85, 3363, 'DEP17909530477299', 10000.00, 'deposit', 'Deposit approved - Txn: TXN17909515933898', '2026-10-02 10:57:27'),
(86, 3363, 'PKG1790953279276', 10000.00, 'package_purchase', 'Purchased Package: Starlink Base', '2026-10-02 11:01:19'),
(87, 3361, 'REF1790953279196', 2000.00, 'referral_commission', 'Direct Commission from GRO_72559 buying Starlink Base', '2026-10-02 11:01:19'),
(88, 3401, 'DEP17909572155129', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17909567866400', '2026-10-02 12:06:55'),
(89, 3401, 'PKG1790959215986', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-02 12:40:15'),
(90, 3391, 'REF1790959215612', 4000.00, 'referral_commission', 'Direct Commission from GRO_28656 buying Starlink Lite', '2026-10-02 12:40:15'),
(91, 3359, 'PRM1790964667823', 1000.00, 'bonus', 'Promoter Bonus Claim -1 Active Refs', '2026-10-02 14:11:07'),
(92, 3400, 'PKG1790971423929', 10000.00, 'package_purchase', 'Purchased Package: Starlink Base', '2026-10-02 16:03:43'),
(93, 3359, 'REF1790971423369', 2000.00, 'referral_commission', 'Direct Commission from GRO_60046 buying Starlink Base', '2026-10-02 16:03:43'),
(94, 3380, 'ROI_ADJ_1790972054927', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-02 16:14:14'),
(95, 3400, 'BNS1791008733444', 20.00, 'bonus', 'Daily Bonus Reward', '2026-10-03 02:25:33'),
(96, 3387, 'ROI_ADJ_1791012298157', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 03:24:58'),
(97, 3390, 'ROI_ADJ_1791012488783', 3500.00, 'roi', 'Periodic Return (1 cycles) on Starlink Beacon', '2026-10-03 03:28:08'),
(98, 3387, 'WD17910129682416', 16300.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 03:36:08'),
(99, 3390, 'WD17910129826003', 23800.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 03:36:22'),
(100, 3389, 'ROI_ADJ_1791013078722', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 03:37:58'),
(101, 3389, 'WD17910133637083', 2300.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 03:42:43'),
(102, 3392, 'ROI_ADJ_1791013626370', 3500.00, 'roi', 'Periodic Return (1 cycles) on Starlink Beacon', '2026-10-03 03:47:06'),
(103, 3393, 'ROI_ADJ_1791013771552', 3500.00, 'roi', 'Periodic Return (1 cycles) on Starlink Beacon', '2026-10-03 03:49:31'),
(104, 3392, 'WD17910139443847', 3800.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 03:52:24'),
(105, 3393, 'WD17910151012629', 3800.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 04:11:41'),
(106, 3380, 'WD17910152754802', 2000.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 04:14:35'),
(107, 3366, 'ROI_ADJ_1791016011433', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-03 04:26:51'),
(108, 3362, 'ROI_ADJ_1791016457417', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 04:34:17'),
(109, 3366, 'WD17910171367740', 1200.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 04:45:36'),
(110, 3391, 'ROI_ADJ_1791022716817', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 06:18:36'),
(111, 3384, 'ROI_ADJ_1791023589657', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-03 06:33:09'),
(112, 3391, 'DEP17910246338361', 1000000.00, 'deposit', 'Deposit approved - Txn: TXN17910243684393', '2026-10-03 06:50:33'),
(113, 3391, 'PKG1791024682457', 1000000.00, 'package_purchase', 'Purchased Package: Starlink Horizon', '2026-10-03 06:51:22'),
(114, 3382, 'REF1791024682489', 50000.00, 'referral_commission', 'Direct Commission from GRO_76712 buying Starlink Horizon', '2026-10-03 06:51:22'),
(115, 3370, 'ROI_ADJ_1791029770195', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 08:16:10'),
(116, 3370, 'WD17910394153030', 2000.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 10:56:55'),
(117, 3399, 'WD17910395995336', 2000.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 10:59:59'),
(118, 3382, 'ROI_ADJ_1791040713620', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 11:18:33'),
(119, 3405, 'DEP17910409838535', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17910409557209', '2026-10-03 11:23:03'),
(120, 3405, 'PKG1791041000957', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-03 11:23:20'),
(121, 3387, 'REF1791041000530', 4000.00, 'referral_commission', 'Direct Commission from GRO_92493 buying Starlink Lite', '2026-10-03 11:23:20'),
(122, 3380, 'ROI_ADJ_1791041106965', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 11:25:06'),
(123, 3406, 'DEP17910412345947', 50000.00, 'deposit', 'Deposit approved - Txn: TXN17910412121381', '2026-10-03 11:27:14'),
(124, 3406, 'PKG1791041254446', 50000.00, 'package_purchase', 'Purchased Package: Starlink Beacon', '2026-10-03 11:27:34'),
(125, 3405, 'REF1791041254943', 10000.00, 'referral_commission', 'Direct Commission from GRO_75184 buying Starlink Beacon', '2026-10-03 11:27:34'),
(126, 3407, 'DEP17910417123491', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17910416966870', '2026-10-03 11:35:12'),
(127, 3407, 'PKG1791041770264', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-03 11:36:10'),
(128, 3387, 'REF1791041770881', 4000.00, 'referral_commission', 'Direct Commission from GRO_30923 buying Starlink Lite', '2026-10-03 11:36:10'),
(129, 3383, 'ROI_ADJ_1791043101171', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 11:58:21'),
(130, 3380, 'WD17910441345054', 2000.00, 'withdrawal', 'Withdrawal approved', '2026-10-03 12:15:34'),
(131, 3401, 'ROI_ADJ_1791055136456', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-03 15:18:56'),
(132, 3400, 'ROI_ADJ_1791067389207', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-03 18:43:09'),
(133, 3384, 'ROI_ADJ_1791094274149', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-04 02:11:14'),
(134, 3408, 'DEP17910976243553', 10000.00, 'deposit', 'Deposit approved - Txn: TXN17910976117091', '2026-10-04 03:07:04'),
(135, 3408, 'PKG1791097641824', 10000.00, 'package_purchase', 'Purchased Package: Starlink Base', '2026-10-04 03:07:21'),
(136, 3361, 'REF1791097641721', 2000.00, 'referral_commission', 'Direct Commission from GRO_24401 buying Starlink Base', '2026-10-04 03:07:21'),
(137, 3363, 'ROI_ADJ_1791100084616', 1200.00, 'roi', 'Periodic Return (1 cycles) on Starlink Base', '2026-10-04 03:48:04'),
(138, 3391, 'ROI_ADJ_1791114351191', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-04 07:45:51'),
(139, 3391, 'ROI_ADJ_1791114351705', 41000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Horizon', '2026-10-04 07:45:51'),
(140, 3370, 'ROI_ADJ_1791117975959', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-04 08:46:15'),
(141, 3407, 'ROI_ADJ_1791128706206', 2000.00, 'roi', 'Periodic Return (1 cycles) on Starlink Lite', '2026-10-04 11:45:06'),
(142, 3410, 'DEP17911382327628', 20000.00, 'deposit', 'Deposit approved - Txn: TXN17911381765824', '2026-10-04 14:23:52'),
(143, 3410, 'PKG1791138436436', 20000.00, 'package_purchase', 'Purchased Package: Starlink Lite', '2026-10-04 14:27:16'),
(144, 3405, 'REF1791138436569', 4000.00, 'referral_commission', 'Direct Commission from GRO_79033 buying Starlink Lite', '2026-10-04 14:27:16');

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

--
-- Table structure for table `flow_users`
--

CREATE TABLE `flow_users` (
  `id` int NOT NULL,
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `funds` decimal(10,2) NOT NULL DEFAULT '0.00',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `flow_user_packages`
--

CREATE TABLE `flow_user_packages` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `package_id` int NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `total_earned` decimal(10,2) DEFAULT '0.00',
  `accumulated_income` decimal(10,2) DEFAULT '0.00',
  `is_sold` tinyint(1) DEFAULT '0',
  `status` enum('active','completed') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'active',
  `last_claim_date` datetime DEFAULT NULL,
  `last_credit_date` datetime DEFAULT NULL,
  `amount_invested` decimal(10,2) NOT NULL DEFAULT '0.00',
  `daily_income` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_income` decimal(10,2) NOT NULL DEFAULT '0.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_user_packages`
--

INSERT INTO `flow_user_packages` (`id`, `user_id`, `package_id`, `start_date`, `end_date`, `total_earned`, `accumulated_income`, `is_sold`, `status`, `last_claim_date`, `last_credit_date`, `amount_invested`, `daily_income`, `total_income`) VALUES
(17, 3011, 15, '2025-11-01', '2025-11-06', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-06 09:49:20', 0.00, 0.00, 0.00),
(18, 3009, 15, '2025-11-01', '2025-11-06', 4500.00, 4500.00, 1, '', NULL, '2025-11-05 21:58:03', 0.00, 0.00, 0.00),
(19, 3015, 15, '2025-11-01', '2025-11-06', 4500.00, 4500.00, 1, '', NULL, '2025-11-05 21:58:03', 0.00, 0.00, 0.00),
(21, 3041, 13, '2025-11-02', '2025-11-07', 0.00, 22800.00, 0, 'completed', NULL, '2025-11-07 06:13:38', 0.00, 0.00, 0.00),
(22, 3056, 15, '2025-11-02', '2025-11-07', 5400.00, 5400.00, 1, '', NULL, '2025-11-07 07:28:20', 0.00, 0.00, 0.00),
(23, 3014, 15, '2025-11-02', '2025-11-07', 5400.00, 5400.00, 1, '', NULL, '2025-11-07 08:27:16', 0.00, 0.00, 0.00),
(24, 3065, 13, '2025-11-02', '2025-11-07', 0.00, 22800.00, 0, 'completed', NULL, '2025-11-07 09:09:21', 0.00, 0.00, 0.00),
(25, 3063, 15, '2025-11-02', '2025-11-07', 5400.00, 5400.00, 1, '', NULL, '2025-11-07 11:12:32', 0.00, 0.00, 0.00),
(26, 3118, 13, '2025-11-02', '2025-11-07', 22800.00, 22800.00, 1, '', NULL, '2025-11-07 13:43:55', 0.00, 0.00, 0.00),
(27, 3062, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-06 18:22:24', 0.00, 0.00, 0.00),
(28, 3066, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-06 18:37:52', 0.00, 0.00, 0.00),
(29, 3137, 13, '2025-11-02', '2025-11-07', 19000.00, 19000.00, 1, '', NULL, '2025-11-06 18:37:52', 0.00, 0.00, 0.00),
(30, 3155, 15, '2025-11-02', '2025-11-07', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-07 18:42:59', 0.00, 0.00, 0.00),
(31, 3128, 12, '2025-11-02', '2025-11-09', 47999.00, 47999.00, 1, '', NULL, '2025-11-08 19:13:28', 0.00, 0.00, 0.00),
(32, 3089, 15, '2025-11-02', '2025-11-07', 5400.00, 5400.00, 1, '', NULL, '2025-11-07 19:25:25', 0.00, 0.00, 0.00),
(33, 3082, 13, '2025-11-02', '2025-11-07', 19000.00, 19000.00, 1, '', NULL, '2025-11-06 19:17:46', 0.00, 0.00, 0.00),
(34, 3092, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-06 20:37:04', 0.00, 0.00, 0.00),
(35, 3166, 14, '2025-11-02', '2025-11-07', 0.00, 10800.00, 0, 'completed', NULL, '2025-11-07 20:38:04', 0.00, 0.00, 0.00),
(36, 3090, 13, '2025-11-02', '2025-11-07', 22800.00, 22800.00, 1, '', NULL, '2025-11-07 20:50:52', 0.00, 0.00, 0.00),
(37, 2986, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-06 21:44:51', 0.00, 0.00, 0.00),
(38, 3164, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-06 22:13:48', 0.00, 0.00, 0.00),
(39, 3178, 15, '2025-11-02', '2025-11-07', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 00:33:38', 0.00, 0.00, 0.00),
(40, 3168, 14, '2025-11-03', '2025-11-08', 9000.00, 9000.00, 1, '', NULL, '2025-11-07 08:12:40', 0.00, 0.00, 0.00),
(41, 3064, 13, '2025-11-03', '2025-11-08', 19000.00, 19000.00, 1, '', NULL, '2025-11-07 08:27:16', 0.00, 0.00, 0.00),
(42, 3182, 15, '2025-11-03', '2025-11-08', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-08 08:30:38', 0.00, 0.00, 0.00),
(43, 3007, 15, '2025-11-03', '2025-11-08', 5400.00, 5400.00, 1, '', NULL, '2025-11-08 12:58:45', 0.00, 0.00, 0.00),
(44, 3187, 15, '2025-11-03', '2025-11-08', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 12:35:10', 0.00, 0.00, 0.00),
(45, 3009, 14, '2025-11-03', '2025-11-08', 9000.00, 9000.00, 1, '', NULL, '2025-11-07 15:05:48', 0.00, 0.00, 0.00),
(46, 3196, 15, '2025-11-03', '2025-11-08', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 16:17:07', 0.00, 0.00, 0.00),
(47, 3094, 15, '2025-11-03', '2025-11-08', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 16:40:33', 0.00, 0.00, 0.00),
(48, 3167, 13, '2025-11-03', '2025-11-08', 22800.00, 22800.00, 1, '', NULL, '2025-11-08 18:44:35', 0.00, 0.00, 0.00),
(49, 3208, 15, '2025-11-03', '2025-11-08', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-08 21:03:28', 0.00, 0.00, 0.00),
(50, 3199, 15, '2025-11-03', '2025-11-08', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 21:02:54', 0.00, 0.00, 0.00),
(51, 3125, 15, '2025-11-03', '2025-11-08', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-08 21:03:28', 0.00, 0.00, 0.00),
(52, 3211, 15, '2025-11-03', '2025-11-08', 4500.00, 4500.00, 1, '', NULL, '2025-11-07 22:37:15', 0.00, 0.00, 0.00),
(53, 2986, 14, '2025-11-03', '2025-11-08', 9000.00, 9000.00, 1, '', NULL, '2025-11-07 22:37:15', 0.00, 0.00, 0.00),
(54, 3181, 15, '2025-11-04', '2025-11-09', 4500.00, 4500.00, 1, '', NULL, '2025-11-08 08:27:37', 0.00, 0.00, 0.00),
(55, 3075, 15, '2025-11-04', '2025-11-09', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-09 11:23:26', 0.00, 0.00, 0.00),
(56, 3282, 15, '2025-11-04', '2025-11-09', 5400.00, 5400.00, 1, '', NULL, '2025-11-09 17:51:09', 0.00, 0.00, 0.00),
(57, 3067, 15, '2025-11-04', '2025-11-09', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-09 21:03:07', 0.00, 0.00, 0.00),
(58, 3078, 15, '2025-11-04', '2025-11-09', 4500.00, 4500.00, 1, '', NULL, '2025-11-08 21:03:28', 0.00, 0.00, 0.00),
(59, 3297, 15, '2025-11-05', '2025-11-10', 4500.00, 4500.00, 1, '', NULL, '2025-11-09 18:49:12', 0.00, 0.00, 0.00),
(60, 3062, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 05:11:24', 0.00, 0.00, 0.00),
(61, 3062, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 05:11:24', 0.00, 0.00, 0.00),
(62, 3066, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 07:03:43', 0.00, 0.00, 0.00),
(63, 2986, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 08:20:59', 0.00, 0.00, 0.00),
(64, 3164, 15, '2025-11-07', '2025-11-12', 0.00, 5400.00, 0, 'completed', NULL, '2025-11-12 10:24:53', 0.00, 0.00, 0.00),
(65, 3014, 15, '2025-11-07', '2025-11-12', 5400.00, 5400.00, 1, '', NULL, '2025-11-12 10:24:53', 0.00, 0.00, 0.00),
(66, 2986, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 10:19:23', 0.00, 0.00, 0.00),
(67, 3137, 13, '2025-11-07', '2025-11-12', 19000.00, 19000.00, 1, '', NULL, '2025-11-11 21:51:01', 0.00, 0.00, 0.00),
(68, 3015, 15, '2025-11-07', '2025-11-12', 4500.00, 4500.00, 1, '', NULL, '2025-11-11 21:51:01', 0.00, 0.00, 0.00),
(69, 3168, 14, '2025-11-08', '2025-11-13', 10800.00, 10800.00, 1, '', NULL, '2025-11-13 06:16:17', 0.00, 0.00, 0.00),
(70, 3063, 15, '2025-11-08', '2025-11-13', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-12 07:19:27', 0.00, 0.00, 0.00),
(71, 2986, 15, '2025-11-08', '2025-11-13', 4500.00, 4500.00, 1, '', NULL, '2025-11-12 07:19:27', 0.00, 0.00, 0.00),
(72, 3211, 15, '2025-11-08', '2025-11-13', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-12 07:19:27', 0.00, 0.00, 0.00),
(73, 3279, 15, '2025-11-08', '2025-11-13', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-12 08:10:36', 0.00, 0.00, 0.00),
(74, 3187, 15, '2025-11-08', '2025-11-13', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-12 10:24:53', 0.00, 0.00, 0.00),
(75, 3196, 15, '2025-11-08', '2025-11-13', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-12 14:25:09', 0.00, 0.00, 0.00),
(76, 3090, 13, '2025-11-08', '2025-11-13', 19000.00, 19000.00, 1, '', NULL, '2025-11-12 15:45:45', 0.00, 0.00, 0.00),
(77, 2986, 15, '2025-11-08', '2025-11-13', 4500.00, 4500.00, 1, '', NULL, '2025-11-12 18:28:20', 0.00, 0.00, 0.00),
(78, 2986, 15, '2025-11-08', '2025-11-13', 4500.00, 4500.00, 1, '', NULL, '2025-11-12 18:28:20', 0.00, 0.00, 0.00),
(79, 3056, 15, '2025-11-09', '2025-11-14', 0.00, 4500.00, 0, 'completed', NULL, '2025-11-13 06:16:17', 0.00, 0.00, 0.00),
(80, 3187, 15, '2025-11-09', '2025-11-14', 0.00, 3600.00, 0, 'completed', NULL, '2025-11-12 08:40:41', 0.00, 0.00, 0.00),
(81, 3007, 15, '2025-11-09', '2025-11-14', 0.00, 3600.00, 0, 'completed', NULL, '2025-11-12 10:24:53', 0.00, 0.00, 0.00),
(82, 3092, 15, '2025-11-10', '2025-11-15', 0.00, 3600.00, 0, 'completed', NULL, '2025-11-13 04:33:02', 0.00, 0.00, 0.00),
(83, 3078, 15, '2025-11-11', '2025-11-16', 0.00, 2700.00, 0, 'completed', NULL, '2025-11-13 04:33:02', 0.00, 0.00, 0.00),
(84, 3118, 13, '2025-11-11', '2025-11-16', 0.00, 7600.00, 0, 'completed', NULL, '2025-11-12 10:24:53', 0.00, 0.00, 0.00),
(85, 3297, 15, '2025-11-11', '2025-11-16', 0.00, 1800.00, 0, 'completed', NULL, '2025-11-13 04:33:02', 0.00, 0.00, 0.00),
(86, 3062, 15, '2025-11-12', '2025-11-17', 0.00, 1800.00, 0, 'completed', NULL, '2025-11-13 04:33:02', 0.00, 0.00, 0.00),
(87, 3066, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 06:43:19', 0.00, 0.00, 0.00),
(88, 2986, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 06:45:06', 0.00, 0.00, 0.00),
(89, 3066, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 06:45:08', 0.00, 0.00, 0.00),
(90, 2986, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 06:45:14', 0.00, 0.00, 0.00),
(91, 2986, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 06:45:23', 0.00, 0.00, 0.00),
(92, 3167, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 16:09:18', 0.00, 0.00, 0.00),
(93, 3137, 13, '2025-11-12', '2025-11-17', 0.00, 3800.00, 0, 'completed', NULL, '2025-11-12 16:17:32', 0.00, 0.00, 0.00),
(94, 3014, 15, '2025-11-12', '2025-11-17', 0.00, 900.00, 0, 'completed', NULL, '2025-11-12 16:42:40', 0.00, 0.00, 0.00),
(95, 2986, 13, '2025-11-13', '2025-11-18', 0.00, 3800.00, 0, 'completed', NULL, '2025-11-13 04:59:03', 0.00, 0.00, 0.00),
(96, 3335, 16, '2026-09-19', '2026-10-19', 0.00, 0.00, 0, 'active', NULL, NULL, 0.00, 0.00, 0.00),
(97, 3335, 16, '2026-09-19', '2026-10-19', 0.00, 0.00, 0, 'active', NULL, NULL, 0.00, 0.00, 0.00),
(98, 3338, 12, '2026-09-19', '2026-09-26', 0.00, 0.00, 0, 'active', '2026-09-19 15:02:46', NULL, 40000.00, 6857.00, 47999.00),
(99, 3340, 12, '2026-09-19', '2026-09-26', 0.00, 0.00, 0, 'active', '2026-09-19 17:40:08', NULL, 40000.00, 6857.00, 47999.00),
(100, 3355, 20, '2026-09-29', '2026-10-19', 0.00, 12500.00, 0, 'active', '2026-09-30 15:12:16', NULL, 100000.00, 12500.00, 270000.00),
(101, 3355, 21, '2026-09-30', '2026-10-20', 0.00, 120000.00, 0, 'active', '2026-09-30 07:43:23', NULL, 250000.00, 30000.00, 600000.00),
(102, 3360, 21, '2026-09-30', '2026-10-20', 0.00, 0.00, 0, 'active', '2026-09-30 07:42:08', NULL, 250000.00, 30000.00, 600000.00),
(103, 3362, 20, '2026-10-01', '2026-11-01', 0.00, 4000.00, 0, 'active', '2026-10-03 06:40:44', NULL, 20000.00, 2000.00, 62000.00),
(104, 3366, 21, '2026-10-01', '2026-11-01', 0.00, 2400.00, 0, 'active', '2026-10-03 08:01:17', NULL, 10000.00, 1200.00, 37200.00),
(105, 3370, 20, '2026-10-01', '2026-11-01', 0.00, 6000.00, 0, 'active', '2026-10-04 12:04:48', NULL, 20000.00, 2000.00, 62000.00),
(106, 3380, 20, '2026-10-01', '2026-11-01', 0.00, 4000.00, 0, 'active', '2026-10-03 14:46:16', NULL, 20000.00, 2000.00, 62000.00),
(107, 3357, 20, '2026-10-01', '2026-11-01', 0.00, 0.00, 0, 'active', '2026-10-01 16:30:30', NULL, 20000.00, 2000.00, 62000.00),
(108, 3382, 20, '2026-10-01', '2026-11-01', 0.00, 2000.00, 0, 'active', '2026-10-02 16:34:22', NULL, 20000.00, 2000.00, 62000.00),
(109, 3383, 20, '2026-10-01', '2026-11-01', 0.00, 2000.00, 0, 'active', '2026-10-02 16:40:00', NULL, 20000.00, 2000.00, 62000.00),
(110, 3384, 21, '2026-10-02', '2026-11-02', 0.00, 2400.00, 0, 'active', '2026-10-04 04:21:35', NULL, 10000.00, 1200.00, 37200.00),
(111, 3387, 20, '2026-10-02', '2026-11-02', 0.00, 2000.00, 0, 'active', '2026-10-03 06:10:03', NULL, 20000.00, 2000.00, 62000.00),
(112, 3389, 20, '2026-10-02', '2026-11-02', 0.00, 2000.00, 0, 'active', '2026-10-03 06:16:20', NULL, 20000.00, 2000.00, 62000.00),
(113, 3390, 16, '2026-10-02', '2026-11-02', 0.00, 3500.00, 0, 'active', '2026-10-03 06:40:55', NULL, 50000.00, 3500.00, 108500.00),
(114, 3392, 16, '2026-10-02', '2026-11-02', 0.00, 3500.00, 0, 'active', '2026-10-03 06:54:19', NULL, 50000.00, 3500.00, 108500.00),
(115, 3393, 16, '2026-10-02', '2026-11-02', 0.00, 3500.00, 0, 'active', '2026-10-03 07:00:28', NULL, 50000.00, 3500.00, 108500.00),
(116, 3391, 20, '2026-10-02', '2026-11-02', 0.00, 4000.00, 0, 'active', '2026-10-04 10:12:37', NULL, 20000.00, 2000.00, 62000.00),
(117, 3363, 21, '2026-10-02', '2026-11-02', 0.00, 1200.00, 0, 'active', '2026-10-03 15:01:19', NULL, 10000.00, 1200.00, 37200.00),
(118, 3401, 20, '2026-10-02', '2026-11-02', 0.00, 2000.00, 0, 'active', '2026-10-03 16:40:15', NULL, 20000.00, 2000.00, 62000.00),
(119, 3400, 21, '2026-10-02', '2026-11-02', 0.00, 1200.00, 0, 'active', '2026-10-03 20:03:43', NULL, 10000.00, 1200.00, 37200.00),
(120, 3391, 12, '2026-10-03', '2026-11-03', 0.00, 41000.00, 0, 'active', '2026-10-04 10:51:22', NULL, 1000000.00, 41000.00, 1271000.00),
(121, 3405, 20, '2026-10-03', '2026-11-03', 0.00, 0.00, 0, 'active', '2026-10-03 15:23:20', NULL, 20000.00, 2000.00, 62000.00),
(122, 3406, 16, '2026-10-03', '2026-11-03', 0.00, 0.00, 0, 'active', '2026-10-03 15:27:34', NULL, 50000.00, 3500.00, 108500.00),
(123, 3407, 20, '2026-10-03', '2026-11-03', 0.00, 2000.00, 0, 'active', '2026-10-04 15:36:10', NULL, 20000.00, 2000.00, 62000.00),
(124, 3408, 21, '2026-10-04', '2026-11-04', 0.00, 0.00, 0, 'active', '2026-10-04 07:07:21', NULL, 10000.00, 1200.00, 37200.00),
(125, 3410, 20, '2026-10-04', '2026-11-04', 0.00, 0.00, 0, 'active', '2026-10-04 18:27:16', NULL, 20000.00, 2000.00, 62000.00);

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

--
-- Table structure for table `flow_user_tasks`
--

CREATE TABLE `flow_user_tasks` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `task_id` int NOT NULL,
  `status` enum('pending','completed') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending',
  `reward_amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `completed_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_user_tasks`
--

INSERT INTO `flow_user_tasks` (`id`, `user_id`, `task_id`, `status`, `reward_amount`, `created_at`, `completed_at`) VALUES
(7, 2981, 5, 'completed', 98000.00, '2025-10-01 12:57:58', '2025-10-01 12:57:58'),
(8, 2981, 4, 'completed', 500000.00, '2025-10-01 12:58:01', '2025-10-01 12:58:01'),
(9, 2981, 3, 'completed', 100000.00, '2025-10-01 12:58:03', '2025-10-01 12:58:03'),
(10, 2981, 2, 'completed', 1000.00, '2025-10-01 12:58:06', '2025-10-01 12:58:06'),
(11, 2981, 1, 'completed', 1000.00, '2025-10-01 12:58:08', '2025-10-01 12:58:08');

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

--
-- Table structure for table `flow_withdrawal_requests`
--

CREATE TABLE `flow_withdrawal_requests` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `transaction_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `status` enum('pending','approved','declined') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending',
  `admin_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `approved_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `flow_withdrawal_requests`
--

INSERT INTO `flow_withdrawal_requests` (`id`, `user_id`, `transaction_id`, `amount`, `method`, `details`, `status`, `admin_notes`, `approved_by`, `created_at`, `updated_at`) VALUES
(1, 3335, 'WD17898278742570', 10000.00, 'Bank Transfer', 'Bank: Access bank\nAcct Name: Nicholas Ayomide Daramola \nAcct No: 0869585767', 'approved', NULL, 1, '2026-09-19 14:24:34', '2026-09-19 14:24:56'),
(2, 3380, 'WD17909258391396', 4300.00, 'Bank Transfer', 'Bank: Florence benjamin\nAcct Name: UBA\nAcct No: 2155321052', 'approved', NULL, 1, '2026-10-02 07:23:59', '2026-10-02 07:35:44'),
(3, 3362, 'WD17909261613693', 5100.00, 'Bank Transfer', 'Bank: Paga\nAcct Name: Joshua chukwuebuka\nAcct No: 1084716478', 'approved', NULL, 1, '2026-10-02 07:29:21', '2026-10-02 07:36:25'),
(4, 3361, 'WD17909263175526', 8300.00, 'Bank Transfer', 'Bank: Access \nAcct Name: Nnaji Naomi Chinecherem \nAcct No: 1903439324', 'approved', NULL, 1, '2026-10-02 07:31:57', '2026-10-02 07:44:42'),
(5, 3366, 'WD17909288443597', 1300.00, 'Bank Transfer', 'Bank: Eneh precious ifunanya \nAcct Name: Opay\nAcct No: 9071638390', 'approved', NULL, 1, '2026-10-02 08:14:04', '2026-10-02 13:15:21'),
(6, 3370, 'WD17909428192863', 2000.00, 'Bank Transfer', 'Bank: Opay \nAcct Name: Chiamaka Colette Ogu \nAcct No: 8161185113', 'approved', NULL, 1, '2026-10-02 12:06:59', '2026-10-02 13:12:55'),
(7, 3382, 'WD17909463079411', 8300.00, 'Bank Transfer', 'Bank: Gift ikenga\nAcct Name: UBA\nAcct No: 2089846430', 'declined', 'Insufficient funds', 1, '2026-10-02 13:05:07', '2026-10-02 14:20:49'),
(8, 3382, 'WD17909463224219', 8300.00, 'Bank Transfer', 'Bank: Gift ikenga\nAcct Name: UBA\nAcct No: 2089846430', 'approved', NULL, 1, '2026-10-02 13:05:22', '2026-10-02 14:20:05'),
(9, 3387, 'WD17910123264625', 16300.00, 'Bank Transfer', 'Bank: First bank\nAcct Name: Ikenga Juliet nnenna\nAcct No: 3072852227', 'approved', NULL, 1, '2026-10-03 07:25:26', '2026-10-03 07:36:08'),
(10, 3390, 'WD17910126848864', 23800.00, 'Bank Transfer', 'Bank: First bank\nAcct Name: Faith\nAcct No: 3134777545', 'approved', NULL, 1, '2026-10-03 07:31:24', '2026-10-03 07:36:22'),
(11, 3389, 'WD17910131718187', 2300.00, 'Bank Transfer', 'Bank: First bank\nAcct Name: Ikenga Juliet nnenna\nAcct No: 3072852227', 'approved', NULL, 1, '2026-10-03 07:39:31', '2026-10-03 07:42:43'),
(12, 3392, 'WD17910136895262', 3800.00, 'Bank Transfer', 'Bank: First bank\nAcct Name: Faith\nAcct No: 3134777545', 'approved', NULL, 1, '2026-10-03 07:48:09', '2026-10-03 07:52:24'),
(13, 3393, 'WD17910139707095', 3800.00, 'Bank Transfer', 'Bank: First bank\nAcct Name: Faith\nAcct No: 3134777545', 'approved', NULL, 1, '2026-10-03 07:52:50', '2026-10-03 08:11:41'),
(14, 3380, 'WD17910149582129', 2000.00, 'Bank Transfer', 'Bank: Florence benjamin\nAcct Name: UBA\nAcct No: 2155321052', 'approved', NULL, 1, '2026-10-03 08:09:18', '2026-10-03 08:14:35'),
(15, 3366, 'WD17910160898777', 1200.00, 'Bank Transfer', 'Bank: Eneh precious ifunanya \nAcct Name: Opay\nAcct No: 9071638390', 'approved', NULL, 1, '2026-10-03 08:28:09', '2026-10-03 08:45:36'),
(16, 3370, 'WD17910297967361', 2000.00, 'Bank Transfer', 'Bank: Opay \nAcct Name: Chiamaka Colette Ogu \nAcct No: 8161185113', 'approved', NULL, 1, '2026-10-03 12:16:36', '2026-10-03 14:56:55'),
(17, 3399, 'WD17910310723215', 2000.00, 'Bank Transfer', 'Bank: Keystone Bank \nAcct Name: John Paul \nAcct No: 6037301305', 'approved', NULL, 1, '2026-10-03 12:37:52', '2026-10-03 14:59:59'),
(18, 3382, 'WD17910407976339', 52000.00, 'Bank Transfer', 'Bank: Gift ikenga\nAcct Name: UBA\nAcct No: 2089846430', 'declined', 'Fake', 1, '2026-10-03 15:19:57', '2026-10-03 15:43:36'),
(19, 3380, 'WD17910411507138', 2000.00, 'Bank Transfer', 'Bank: Florence benjamin\nAcct Name: UBA\nAcct No: 2155321052', 'approved', NULL, 1, '2026-10-03 15:25:50', '2026-10-03 16:15:34'),
(20, 3384, 'WD17910434612988', 1500.00, 'Bank Transfer', 'Bank: Palmpay \nAcct Name: Salome Jumbo\nAcct No: 7068681602', 'pending', NULL, NULL, '2026-10-03 16:04:21', '2026-10-03 16:04:21');

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

--
-- Table structure for table `indirectreferrals`
--

CREATE TABLE `indirectreferrals` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `thridreferral` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `indirectusername` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `referral` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `indirectreferrals`
--

INSERT INTO `indirectreferrals` (`id`, `username`, `thridreferral`, `indirectusername`, `referral`, `date`) VALUES
(1, 'Sadeeqdigital', 'Mrnonchalant', 'COACHSADEEQ', 'COACHSADEEQ', '31-10-2025 23:20:32'),
(2, 'COACHKHAMIS', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 06:56:56'),
(3, 'Abulbaiti', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 07:07:47'),
(4, 'Annabbacy', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 08:46:41'),
(5, 'Garba', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 08:53:11'),
(6, 'Muhamm', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 08:57:12'),
(7, 'Usman', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 08:57:22'),
(8, 'Maroicardi', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 09:49:29'),
(9, 'Ahmadfx', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 09:56:07'),
(10, 'Khaleeboy', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 09:56:08'),
(11, 'DanBangees', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 10:23:18'),
(12, 'Muhammad', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 10:38:59'),
(13, 'Jeff', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 11:18:03'),
(14, 'kamalne', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 13:04:48'),
(15, 'Hussainiruwaya', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 15:46:25'),
(16, 'Gada', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 16:51:17'),
(17, 'Jamilu', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 17:11:48'),
(18, 'Zhaboth', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 17:25:49'),
(19, 'Jajene', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 17:34:36'),
(20, 'MANDESAMINU', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 19:04:54'),
(21, 'MUsman', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 19:06:56'),
(22, 'Kiddyy', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 20:18:59'),
(23, 'Sodis', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 20:19:29'),
(24, 'Onomdo', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 20:20:16'),
(25, 'Opehabposi', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 20:26:41'),
(26, 'Darull', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 20:29:27'),
(27, 'Isyagarba', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 20:41:53'),
(28, 'Materials', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 21:04:10'),
(29, 'Curlysmokey', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 21:21:44'),
(30, 'Bbcxcfg', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 21:23:20'),
(31, 'Stormvy', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 21:33:21'),
(32, 'Abba', 'Mrnonchalant', 'emmanuel', 'emmanuel', '01-11-2025 21:57:44'),
(33, 'junaidualhassan', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '01-11-2025 22:04:52'),
(34, 'GarbaTv', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 22:08:14'),
(35, 'RealBabanintu', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '01-11-2025 22:22:37'),
(36, 'Yaya', 'Mrnonchalant', 'VisionTv', 'VisionTv', '01-11-2025 23:01:34'),
(37, 'Danmakama', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '01-11-2025 23:13:41'),
(38, 'mohammed', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '02-11-2025 03:57:41'),
(39, 'Abubakar', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '02-11-2025 06:25:37'),
(40, 'abbastalba', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 07:04:02'),
(41, 'ALYAUMA', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 07:04:17'),
(42, 'Suleman', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 07:04:30'),
(43, 'Talba', 'Sadeeqdigital', 'abbastalba', 'abbastalba', '02-11-2025 07:09:30'),
(44, 'nazeerboy', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 07:12:47'),
(45, 'Bimubarak', 'RealBabanintu', 'nazeerboy', 'nazeerboy', '02-11-2025 07:28:25'),
(46, 'Binsaif', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 07:39:50'),
(47, 'Fatima', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 07:40:21'),
(48, 'Dansaif', 'RealBabanintu', 'Binsaif', 'Binsaif', '02-11-2025 07:44:36'),
(49, 'Binaminu', 'RealBabanintu', 'Binsaif', 'Binsaif', '02-11-2025 07:47:54'),
(50, 'Realabanego', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 08:25:57'),
(51, 'Sheikhasheik', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 08:32:32'),
(52, 'Ameenukano', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 08:33:52'),
(53, 'Coachk', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 08:41:08'),
(54, 'Abbakaraminu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 08:59:43'),
(55, 'Upcoming', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:12:06'),
(56, 'Librarianabdul', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:26:36'),
(57, 'Jumaresco', 'Mrnonchalant', 'emmanuel', 'emmanuel', '02-11-2025 09:27:13'),
(58, 'YoungMd', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:28:44'),
(59, 'Bashir', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:30:27'),
(60, 'Sihsj', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:31:11'),
(61, 'Yunus', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:40:13'),
(62, 'abdulrahaman', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:43:26'),
(63, 'Magama', 'officialjayjay', 'Hussainiruwaya', 'Hussainiruwaya', '02-11-2025 09:48:29'),
(64, 'Idrisbabba', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:51:18'),
(65, 'Yusuf', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:52:38'),
(66, 'Idrismusa', 'RealBabanintu', 'Idrisbabba', 'Idrisbabba', '02-11-2025 09:56:01'),
(67, 'Ayubasmall', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:58:17'),
(68, 'Abubakargoni', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 09:59:22'),
(69, 'ABULHAKIM', 'RealBabanintu', 'abdulrahaman', 'abdulrahaman', '02-11-2025 10:05:06'),
(70, 'Aleeyumuazu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:07:06'),
(71, 'Ababakr', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:09:14'),
(72, 'Ummuanas', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:11:48'),
(73, 'habubakar', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:26:36'),
(74, 'Nenebo', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:26:57'),
(75, 'Fauxiyya', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:31:21'),
(76, 'Realsani', 'RealBabanintu', 'Realabanego', 'Realabanego', '02-11-2025 10:32:51'),
(77, 'DALLATU', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:32:54'),
(78, 'Bawasa', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:33:55'),
(79, 'Birma', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 10:41:47'),
(80, 'Yusufa', 'RealBabanintu', 'habubakar', 'habubakar', '02-11-2025 11:15:10'),
(81, 'khalifakubau', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 11:27:20'),
(82, 'Yuzaseef', 'RealBabanintu', 'DALLATU', 'DALLATU', '02-11-2025 11:28:18'),
(83, 'hansel', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 11:30:40'),
(84, 'Realhabiba', 'RealBabanintu', 'Realabanego', 'Realabanego', '02-11-2025 11:39:48'),
(85, 'danbalashinkafi', 'RealBabanintu', 'Suleman', 'Suleman', '02-11-2025 12:09:04'),
(86, 'Munkaila', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 12:14:00'),
(87, 'Kamilujaja', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 12:26:11'),
(88, 'Inyamuri', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 12:43:48'),
(89, 'YAlhassan', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 13:08:48'),
(90, 'mustaphadange', 'RealBabanintu', 'Coachk', 'Coachk', '02-11-2025 13:11:33'),
(91, 'realmrbeey', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 13:16:42'),
(92, 'Ashami', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 13:17:19'),
(93, 'Masuduyakubu', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 13:26:21'),
(94, 'Coachdeejarth', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 13:30:00'),
(95, 'tajiddin', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 13:53:18'),
(96, 'JAMEEL', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 14:03:08'),
(97, 'Kabirkankana', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 14:51:02'),
(98, 'Junior', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 15:04:54'),
(99, 'Lol', 'Mrnonchalant', 'emmanuel', 'emmanuel', '02-11-2025 15:22:10'),
(100, 'Sulieman', 'Mrnonchalant', 'officialjayjay', 'officialjayjay', '02-11-2025 15:23:16'),
(101, 'Khady', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 15:23:16'),
(102, 'Rabilou', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 15:42:36'),
(103, 'Indirawa', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 15:45:04'),
(104, 'Diamond', 'officialjayjay', 'mohammed', 'mohammed', '02-11-2025 15:49:19'),
(105, 'Yusufgo', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 15:58:12'),
(106, 'Ali', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 16:02:19'),
(107, 'couchumar', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '02-11-2025 16:05:38'),
(108, 'Coachabbaprince', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 16:13:44'),
(109, 'Kabirabubakar', 'Mrnonchalant', 'VisionTv', 'VisionTv', '02-11-2025 16:34:59'),
(110, 'Kabiru', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 16:50:03'),
(111, 'Tijjaniusman', 'RealBabanintu', 'Kabiru', 'Kabiru', '02-11-2025 16:58:08'),
(112, 'IbebahhArmalik', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 17:12:58'),
(113, 'Mb', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 17:44:38'),
(114, 'Boss', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 18:06:41'),
(115, 'Hussain', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 18:10:03'),
(116, 'BELLONCY', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 18:54:17'),
(117, 'Nanakhadija', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:09:54'),
(118, 'ABDULLAHI', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:45:14'),
(119, 'Ogamusa', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:45:20'),
(120, 'Isa', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:46:15'),
(121, 'Realyahaya', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:54:43'),
(122, 'Babangida', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 19:59:36'),
(123, 'habubukar', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 20:13:21'),
(124, 'Player', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 20:42:04'),
(125, 'Manakogsm', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 20:45:01'),
(126, 'MaiAnguwa', 'RealBabanintu', 'Coachk', 'Coachk', '02-11-2025 20:45:58'),
(127, 'RealAbumukas', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 20:52:01'),
(128, 'Abdulmajididris', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 21:21:32'),
(129, 'Balkisudanladi', 'RealBabanintu', 'Manakogsm', 'Manakogsm', '02-11-2025 21:31:42'),
(130, 'Abdullah', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 21:36:13'),
(131, 'rabaja', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 21:55:23'),
(132, 'mahmudadamu', 'Sadeeqdigital', 'abbastalba', 'abbastalba', '02-11-2025 22:27:33'),
(133, 'Dangombe', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '02-11-2025 22:46:53'),
(134, 'Tj', 'Sadeeqdigital', 'abbastalba', 'abbastalba', '02-11-2025 22:54:42'),
(135, 'Kabirukbr', 'RealBabanintu', 'Kabirkankana', 'Kabirkankana', '02-11-2025 23:28:29'),
(136, 'kabirfantah', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 07:41:03'),
(137, 'Femi', 'Mrnonchalant', 'VisionTv', 'VisionTv', '03-11-2025 07:47:55'),
(138, 'Realmuktar', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 08:49:11'),
(139, 'Beelybaby', 'RealBabanintu', 'Coachk', 'Coachk', '03-11-2025 09:00:20'),
(140, 'MuhammadShehu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 09:43:40'),
(141, 'Sirumar', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '03-11-2025 11:39:30'),
(142, 'Chijindu', 'Mrnonchalant', 'VisionTv', 'VisionTv', '03-11-2025 12:14:17'),
(143, 'Lucky', 'Mrnonchalant', 'emmanuel', 'emmanuel', '03-11-2025 12:21:28'),
(144, 'PillarS', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '03-11-2025 12:28:04'),
(145, 'Frechiee', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 12:31:04'),
(146, 'Blessedmedia', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '03-11-2025 13:11:41'),
(147, 'Anis', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 13:51:35'),
(148, 'Abdulm', 'RealBabanintu', 'Coachk', 'Coachk', '03-11-2025 13:55:37'),
(149, 'Anisa', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 13:55:50'),
(150, 'Ismailamuhammad', 'Mrnonchalant', 'emmanuel', 'emmanuel', '03-11-2025 15:49:08'),
(151, 'Muhammadsaleh', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '03-11-2025 16:23:43'),
(152, 'Alhaji', 'emmanuel', 'Ismailamuhammad', 'Ismailamuhammad', '03-11-2025 17:20:32'),
(153, 'Musa', 'emmanuel', 'Ismailamuhammad', 'Ismailamuhammad', '03-11-2025 17:24:17'),
(154, 'Alkhairine', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 17:27:42'),
(155, 'Vicky', 'VisionTv', 'Femi', 'Femi', '03-11-2025 17:31:14'),
(156, 'effiongsamuel', 'Femi', 'Vicky', 'Vicky', '03-11-2025 18:09:14'),
(157, 'Gospel', 'Femi', 'Vicky', 'Vicky', '03-11-2025 18:11:40'),
(158, 'Collins', 'Femi', 'Vicky', 'Vicky', '03-11-2025 18:38:48'),
(159, 'Masuduyakub', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '03-11-2025 20:05:39'),
(160, 'habibagidado', 'RealBabanintu', 'Manakogsm', 'Manakogsm', '03-11-2025 20:46:23'),
(161, 'Musanura', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '03-11-2025 20:54:27'),
(162, 'Saniabbas', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '03-11-2025 21:11:52'),
(163, 'Abbababa', 'Mrnonchalant', 'VisionTv', 'VisionTv', '03-11-2025 21:19:33'),
(164, 'Hamza', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '03-11-2025 21:45:36'),
(165, 'hadifailah', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '03-11-2025 21:51:20'),
(166, 'Rooboy', 'Mrnonchalant', 'emmanuel', 'emmanuel', '03-11-2025 21:56:29'),
(167, 'Musaali', 'MuhammadShehu', 'Hamza', 'Hamza', '03-11-2025 21:59:21'),
(168, 'Yakubu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 22:02:19'),
(169, 'Emmaster', 'emmanuel', 'Rooboy', 'Rooboy', '03-11-2025 22:07:54'),
(170, 'Eyibio', 'emmanuel', 'Rooboy', 'Rooboy', '03-11-2025 22:08:38'),
(171, 'AYOGOD', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 22:11:11'),
(172, 'Nseobot', 'emmanuel', 'Rooboy', 'Rooboy', '03-11-2025 22:11:33'),
(173, 'Abubacarabdu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 22:16:15'),
(174, 'abbaak', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 22:30:57'),
(175, 'Badamasiibrahim', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 22:32:32'),
(176, 'Nasiru', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '03-11-2025 22:40:21'),
(177, 'Taurancy', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '03-11-2025 22:58:15'),
(178, 'Ssauki', 'Mrnonchalant', 'VisionTv', 'VisionTv', '03-11-2025 23:18:01'),
(179, 'Pitoo', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '03-11-2025 23:30:45'),
(180, 'Anasbinimalik', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '03-11-2025 23:46:44'),
(181, 'Luckyhappy', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 00:11:40'),
(182, 'Abdulmalik', 'Mrnonchalant', 'VisionTv', 'VisionTv', '04-11-2025 00:43:41'),
(183, 'Harunab', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 05:59:03'),
(184, 'Wahleed', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 06:03:04'),
(185, 'sadeeq', 'Mrnonchalant', 'VisionTv', 'VisionTv', '04-11-2025 06:04:20'),
(186, 'Umarbello', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 06:15:10'),
(187, 'Umayma', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 06:25:17'),
(188, 'Babu', 'MuhammadShehu', 'Wahleed', 'Wahleed', '04-11-2025 06:33:01'),
(189, 'Gusi', 'Wahleed', 'Babu', 'Babu', '04-11-2025 06:46:38'),
(190, 'Babuu', 'Wahleed', 'Babu', 'Babu', '04-11-2025 06:51:42'),
(191, 'Mama', 'Wahleed', 'Babu', 'Babu', '04-11-2025 06:53:21'),
(192, 'Mimi', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:12:38'),
(193, 'Bukar', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:16:17'),
(194, 'Wess', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:20:25'),
(195, 'Yaaya', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:25:16'),
(196, 'Yaaaya', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:27:50'),
(197, 'Maama', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:31:38'),
(198, 'Kakolo', 'Wahleed', 'Babu', 'Babu', '04-11-2025 07:35:07'),
(199, 'Zainab', 'RealBabanintu', 'Boss', 'Boss', '04-11-2025 07:36:42'),
(200, 'Isiya', 'RealBabanintu', 'Boss', 'Boss', '04-11-2025 07:43:17'),
(201, 'Yakubuyacksoon', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 07:43:41'),
(202, 'Marte', 'MuhammadShehu', 'Wahleed', 'Wahleed', '04-11-2025 07:48:21'),
(203, 'Yackss', 'Mrnonchalant', 'VisionTv', 'VisionTv', '04-11-2025 07:58:34'),
(204, 'Mia', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '04-11-2025 08:11:42'),
(205, 'Miagirlie', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '04-11-2025 08:15:00'),
(206, 'Shehu', 'MuhammadShehu', 'Wahleed', 'Wahleed', '04-11-2025 08:15:24'),
(207, 'Ousmane', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 08:35:35'),
(208, 'DANALIKIRU', 'Mrnonchalant', 'VisionTv', 'VisionTv', '04-11-2025 08:57:46'),
(209, 'Muhamud', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 09:03:10'),
(210, 'Saiduumar', 'VisionTv', 'DANALIKIRU', 'DANALIKIRU', '04-11-2025 09:04:33'),
(211, 'Kaigama', 'Wahleed', 'Babu', 'Babu', '04-11-2025 09:05:12'),
(212, 'Gisse', 'Mrnonchalant', 'emmanuel', 'emmanuel', '04-11-2025 09:32:56'),
(213, 'Saiduumaru', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:25:47'),
(214, 'Saiduumaruh', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:26:55'),
(215, 'Saiduumay', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:28:12'),
(216, 'Saiduumarui', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:29:23'),
(217, 'Saiduum', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:30:47'),
(218, 'Saiduu', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:31:38'),
(219, 'Saiduumaruf', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:32:40'),
(220, 'Saiduumaruhg', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:33:22'),
(221, 'Saiduumarhjj', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:34:20'),
(222, 'Saiduumarjsj', 'DANALIKIRU', 'Saiduumar', 'Saiduumar', '04-11-2025 14:35:01'),
(223, 'Donbless', 'Mrnonchalant', 'VisionTv', 'VisionTv', '04-11-2025 14:47:52'),
(224, 'Fatimasister', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 14:53:42'),
(225, 'ILERIOLUWA', 'Mrnonchalant', 'emmanuel', 'emmanuel', '04-11-2025 16:10:26'),
(226, 'Solo', 'Femi', 'Vicky', 'Vicky', '04-11-2025 16:36:49'),
(227, 'Shamsudeen', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 16:58:01'),
(228, 'Lukumanumar', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 17:28:28'),
(229, 'Mubaraktchd', 'RealBabanintu', 'MuhammadShehu', 'MuhammadShehu', '04-11-2025 18:40:06'),
(230, 'Aliyu', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 20:54:55'),
(231, 'Usma', 'RealBabanintu', 'Aliyu', 'Aliyu', '04-11-2025 21:19:16'),
(232, 'Dodogidanbaduwa', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '04-11-2025 23:13:42'),
(233, 'Hussiniadamu', 'officialjayjay', 'Hussainiruwaya', 'Hussainiruwaya', '04-11-2025 23:43:30'),
(234, 'JazzmanFX', 'Mrnonchalant', 'emmanuel', 'emmanuel', '05-11-2025 00:54:13'),
(235, 'Suraja', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '05-11-2025 02:01:12'),
(236, 'ABKMUHAMMAD', 'MuhammadShehu', 'Wahleed', 'Wahleed', '05-11-2025 07:15:34'),
(237, 'Leesi', 'Mrnonchalant', 'VisionTv', 'VisionTv', '05-11-2025 07:17:50'),
(238, 'Ahmae', 'Wahleed', 'ABKMUHAMMAD', 'ABKMUHAMMAD', '05-11-2025 08:06:54'),
(239, 'aparanties', 'Mrnonchalant', 'VisionTv', 'VisionTv', '05-11-2025 10:21:43'),
(240, 'Msblegend', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '05-11-2025 10:51:30'),
(241, 'Btlaahmad', 'Realabanego', 'Realsani', 'Realsani', '05-11-2025 12:50:22'),
(242, 'Gobe', 'Mrnonchalant', 'VisionTv', 'VisionTv', '05-11-2025 15:02:59'),
(243, 'Adamcy', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '05-11-2025 18:21:37'),
(244, 'Eddy', 'VisionTv', 'Femi', 'Femi', '05-11-2025 20:47:27'),
(245, 'Sanda', 'RealBabanintu', 'Adamcy', 'Adamcy', '05-11-2025 21:29:11'),
(246, 'Smart', 'Mrnonchalant', 'emmanuel', 'emmanuel', '05-11-2025 21:54:09'),
(247, 'Leonas', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '05-11-2025 21:57:30'),
(248, 'Izubest', 'Mrnonchalant', 'emmanuel', 'emmanuel', '05-11-2025 22:55:54'),
(249, 'Gee', 'Sadeeqdigital', 'abbastalba', 'abbastalba', '06-11-2025 05:25:59'),
(250, 'AbuPilot', 'Mrnonchalant', 'VisionTv', 'VisionTv', '07-11-2025 05:52:06'),
(251, 'Nasirum', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 07:46:11'),
(252, 'Realsaleh', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 10:11:28'),
(253, 'Realvictorp', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 10:22:48'),
(254, 'hamesu', 'RealBabanintu', 'Yakubu', 'Yakubu', '07-11-2025 11:23:09'),
(255, 'Realhabu', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 12:09:32'),
(256, 'Realzainab', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 12:11:18'),
(257, 'Realomega', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 12:12:54'),
(258, 'Realarazanasu', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 12:14:24'),
(259, 'Realharuna', 'RealBabanintu', 'Realabanego', 'Realabanego', '07-11-2025 12:16:11'),
(260, 'Sani', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '07-11-2025 16:17:45'),
(261, 'Maybe', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '07-11-2025 17:43:15'),
(262, 'GENTLE', 'RealBabanintu', 'Bawasa', 'Bawasa', '08-11-2025 07:29:30'),
(263, 'Taheer', 'officialjayjay', 'Ahmadfx', 'Ahmadfx', '08-11-2025 11:59:51'),
(264, 'Momi', 'Realsani', 'Btlaahmad', 'Btlaahmad', '09-11-2025 07:38:33'),
(265, 'Mubarak', 'RealBabanintu', 'Kabirkankana', 'Kabirkankana', '09-11-2025 09:25:47'),
(266, 'Disciplineky', 'Mrnonchalant', 'VisionTv', 'VisionTv', '09-11-2025 09:33:58'),
(267, 'Hhddhdh', 'VisionTv', 'Yaya', 'Yaya', '09-11-2025 11:25:55'),
(268, 'Legendbaby', 'Sadeeqdigital', 'RealBabanintu', 'RealBabanintu', '09-11-2025 20:29:14'),
(269, 'Calculus', 'Mrnonchalant', 'Viviemedia', 'Viviemedia', '11-11-2025 19:15:49'),
(270, 'Haruna', 'COACHSADEEQ', 'Sadeeqdigital', 'Sadeeqdigital', '11-11-2025 23:36:25'),
(271, 'GRO_72559', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-09-30 20:44:07'),
(272, 'GRO_44715', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-01 06:40:55'),
(273, 'GRO_45556', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 08:37:02'),
(274, 'GRO_13541', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 09:34:23'),
(275, 'GRO_80076', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-01 09:45:30'),
(276, 'GRO_56480', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 10:32:25'),
(277, 'GRO_76125', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 11:21:02'),
(278, 'GRO_91189', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 11:36:31'),
(279, 'GRO_43260', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 11:49:16'),
(280, 'GRO_19219', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 12:09:40'),
(281, 'GRO_89841', 'GRO_34188', 'GRO_19219', 'GRO_19219', '2026-10-01 12:20:17'),
(282, 'GRO_49216', 'GRO_34188', 'GRO_19219', 'GRO_19219', '2026-10-01 12:20:26'),
(283, 'GRO_71058', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 12:24:17'),
(284, 'GRO_27171', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-01 13:26:08'),
(285, 'GRO_51473', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-01 15:26:57'),
(286, 'GRO_76505', 'GRO_37322', 'GRO_51473', 'GRO_51473', '2026-10-01 17:22:16'),
(287, 'GRO_67471', 'GRO_51473', 'GRO_76505', 'GRO_76505', '2026-10-01 17:38:32'),
(288, 'GRO_40418', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-01 22:10:38'),
(289, 'GRO_70696', 'GRO_37322', 'GRO_80076', 'GRO_80076', '2026-10-02 00:57:07'),
(290, 'GRO_11554', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-02 07:07:53'),
(291, 'GRO_72431', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-02 07:12:42'),
(292, 'GRO_50847', 'GRO_37322', 'GRO_11554', 'GRO_11554', '2026-10-02 07:14:47'),
(293, 'GRO_36178', 'GRO_37322', 'GRO_11554', 'GRO_11554', '2026-10-02 07:29:53'),
(294, 'GRO_76712', 'GRO_51473', 'GRO_76505', 'GRO_76505', '2026-10-02 07:36:53'),
(295, 'GRO_62825', 'GRO_11554', 'GRO_36178', 'GRO_36178', '2026-10-02 07:52:17'),
(296, 'GRO_36000', 'GRO_11554', 'GRO_36178', 'GRO_36178', '2026-10-02 07:58:47'),
(297, 'GRO_93240', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-02 08:04:49'),
(298, 'GRO_13296', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-02 09:34:23'),
(299, 'GRO_24489', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-02 09:45:00'),
(300, 'GRO_71831', 'GRO_37322', 'GRO_27171', 'GRO_27171', '2026-10-02 09:59:59'),
(301, 'GRO_16561', 'GRO_76505', 'GRO_76712', 'GRO_76712', '2026-10-02 12:47:21'),
(302, 'GRO_60046', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-02 13:28:46'),
(303, 'GRO_28656', 'GRO_76505', 'GRO_76712', 'GRO_76712', '2026-10-02 16:51:54'),
(304, 'GRO_84568', 'GRO_41704', 'GRO_34188', 'GRO_34188', '2026-10-02 20:40:25'),
(305, 'GRO_93186', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-02 20:58:37'),
(306, 'GRO_92493', 'GRO_37322', 'GRO_11554', 'GRO_11554', '2026-10-03 16:21:21'),
(307, 'GRO_75184', 'GRO_11554', 'GRO_92493', 'GRO_92493', '2026-10-03 16:25:53'),
(308, 'GRO_30923', 'GRO_37322', 'GRO_11554', 'GRO_11554', '2026-10-03 16:32:51'),
(309, 'GRO_24401', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-04 08:05:06'),
(310, 'GRO_42105', 'GRO_41704', 'GRO_33019', 'GRO_33019', '2026-10-04 08:53:25'),
(311, 'GRO_79033', 'GRO_11554', 'GRO_92493', 'GRO_92493', '2026-10-04 19:07:07'),
(312, 'GRO_30316', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-04 19:25:22'),
(313, 'GRO_40758', 'GRO_41704', 'GRO_37322', 'GRO_37322', '2026-10-04 19:31:10');

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `id` int NOT NULL,
  `username` varchar(30) NOT NULL,
  `fullname` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `acctnum` varchar(30) NOT NULL,
  `bank` varchar(30) NOT NULL,
  `acctname` varchar(30) NOT NULL,
  `jobstatus` varchar(30) NOT NULL,
  `job` varchar(30) NOT NULL,
  `bvn` varchar(30) NOT NULL,
  `nin` varchar(30) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `address` varchar(300) NOT NULL,
  `purpose` varchar(300) NOT NULL,
  `reference` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'pending',
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int NOT NULL,
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `message` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `newbanks`
--

CREATE TABLE `newbanks` (
  `id` int NOT NULL,
  `bank` varchar(40) DEFAULT NULL,
  `code` varchar(14) DEFAULT NULL,
  `country` varchar(12) DEFAULT NULL,
  `tag` varchar(25) DEFAULT NULL,
  `currency` varchar(8) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `newcsv`
--

CREATE TABLE `newcsv` (
  `acctnum` varchar(300) NOT NULL,
  `bank` varchar(300) NOT NULL,
  `amount` varchar(300) NOT NULL,
  `narration` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `newtwo`
--

CREATE TABLE `newtwo` (
  `acctnum` varchar(30) NOT NULL,
  `bank` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `narration` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `otp`
--

CREATE TABLE `otp` (
  `id` int NOT NULL,
  `email` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `otp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int NOT NULL,
  `username` varchar(20) NOT NULL,
  `title` varchar(500) NOT NULL,
  `price` varchar(30) NOT NULL,
  `oldprice` varchar(30) NOT NULL DEFAULT '0',
  `sellername` varchar(200) NOT NULL,
  `location` varchar(200) NOT NULL,
  `contact` varchar(500) NOT NULL,
  `image1` varchar(20) NOT NULL,
  `image2` varchar(20) NOT NULL,
  `image3` varchar(20) NOT NULL,
  `image4` varchar(20) NOT NULL,
  `description` longtext NOT NULL,
  `showhome` int NOT NULL,
  `showdash` int NOT NULL,
  `reference` varchar(20) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'pending',
  `stockstatus` varchar(30) NOT NULL DEFAULT 'New',
  `identifier` varchar(3000) NOT NULL,
  `category` varchar(50) NOT NULL,
  `contactlink` varchar(500) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `profilelinks`
--

CREATE TABLE `profilelinks` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `profilephotos`
--

CREATE TABLE `profilephotos` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

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

CREATE TABLE `referrals` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `referral` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `earnings` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `reference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `referrals`
--

INSERT INTO `referrals` (`id`, `username`, `referral`, `type`, `earnings`, `reference`, `date`) VALUES
(1, 'Mimi', 'Samtux', '--', '--', '--', '19-09-2025 07:58:02'),
(2, 'Rama', 'Samtux', '--', '--', '--', '19-09-2025 08:03:23'),
(3, 'Spunky', 'Samtux', '--', '--', '--', '19-09-2025 11:47:06'),
(4, 'Deborah', 'Samtux', '--', '--', '--', '19-09-2025 12:54:33'),
(5, 'Eniolau', 'Samtux', '--', '--', '--', '19-09-2025 19:12:43'),
(6, 'Promise', 'Samtux', '--', '--', '--', '24-09-2025 07:20:32'),
(7, 'Testing', 'Nikkyy', '--', '--', '--', '03-10-2025 10:59:00'),
(8, 'emmanuel', 'Mrnonchalant', '--', '--', '--', '31-10-2025 08:55:50'),
(9, 'VisionTv', 'Mrnonchalant', '--', '--', '--', '31-10-2025 13:32:19'),
(10, 'officialjayjay', 'Mrnonchalant', '--', '--', '--', '31-10-2025 13:44:03'),
(11, 'Prosper', 'Mrnonchalant', '--', '--', '--', '31-10-2025 14:09:10'),
(12, 'Jerry', 'Mrnonchalant', '--', '--', '--', '31-10-2025 14:11:29'),
(13, 'Viviemedia', 'Mrnonchalant', '--', '--', '--', '31-10-2025 20:19:20'),
(14, 'COACHSADEEQ', 'Mrnonchalant', '--', '--', '--', '31-10-2025 22:48:34'),
(15, 'Sadeeqdigital', 'COACHSADEEQ', '--', '--', '--', '31-10-2025 23:20:32'),
(16, 'COACHKHAMIS', 'officialjayjay', '--', '--', '--', '01-11-2025 06:56:56'),
(17, 'Abulbaiti', 'officialjayjay', '--', '--', '--', '01-11-2025 07:07:47'),
(18, 'Annabbacy', 'officialjayjay', '--', '--', '--', '01-11-2025 08:46:41'),
(19, 'Garba', 'officialjayjay', '--', '--', '--', '01-11-2025 08:53:11'),
(20, 'Muhamm', 'officialjayjay', '--', '--', '--', '01-11-2025 08:57:12'),
(21, 'Usman', 'officialjayjay', '--', '--', '--', '01-11-2025 08:57:22'),
(22, 'Maroicardi', 'officialjayjay', '--', '--', '--', '01-11-2025 09:49:29'),
(23, 'Ahmadfx', 'officialjayjay', '--', '--', '--', '01-11-2025 09:56:07'),
(24, 'Khaleeboy', 'officialjayjay', '--', '--', '--', '01-11-2025 09:56:08'),
(25, 'DanBangees', 'officialjayjay', '--', '--', '--', '01-11-2025 10:23:18'),
(26, 'Muhammad', 'officialjayjay', '--', '--', '--', '01-11-2025 10:38:59'),
(27, 'Jeff', 'officialjayjay', '--', '--', '--', '01-11-2025 11:18:03'),
(28, 'kamalne', 'officialjayjay', '--', '--', '--', '01-11-2025 13:04:48'),
(29, 'Hussainiruwaya', 'officialjayjay', '--', '--', '--', '01-11-2025 15:46:25'),
(30, 'Gada', 'officialjayjay', '--', '--', '--', '01-11-2025 16:51:17'),
(31, 'Jamilu', 'VisionTv', '--', '--', '--', '01-11-2025 17:11:48'),
(32, 'Zhaboth', 'VisionTv', '--', '--', '--', '01-11-2025 17:25:49'),
(33, 'Jajene', 'VisionTv', '--', '--', '--', '01-11-2025 17:34:36'),
(34, 'MANDESAMINU', 'VisionTv', '--', '--', '--', '01-11-2025 19:04:54'),
(35, 'MUsman', 'officialjayjay', '--', '--', '--', '01-11-2025 19:06:56'),
(36, 'Kiddyy', 'emmanuel', '--', '--', '--', '01-11-2025 20:18:59'),
(37, 'Sodis', 'emmanuel', '--', '--', '--', '01-11-2025 20:19:29'),
(38, 'Onomdo', 'emmanuel', '--', '--', '--', '01-11-2025 20:20:16'),
(39, 'Opehabposi', 'emmanuel', '--', '--', '--', '01-11-2025 20:26:41'),
(40, 'Darull', 'VisionTv', '--', '--', '--', '01-11-2025 20:29:27'),
(41, 'Isyagarba', 'VisionTv', '--', '--', '--', '01-11-2025 20:41:53'),
(42, 'Materials', 'emmanuel', '--', '--', '--', '01-11-2025 21:04:10'),
(43, 'Curlysmokey', 'emmanuel', '--', '--', '--', '01-11-2025 21:21:44'),
(44, 'Bbcxcfg', 'emmanuel', '--', '--', '--', '01-11-2025 21:23:20'),
(45, 'Stormvy', 'emmanuel', '--', '--', '--', '01-11-2025 21:33:21'),
(46, 'Abba', 'emmanuel', '--', '--', '--', '01-11-2025 21:57:44'),
(47, 'junaidualhassan', 'Sadeeqdigital', '--', '--', '--', '01-11-2025 22:04:52'),
(48, 'GarbaTv', 'VisionTv', '--', '--', '--', '01-11-2025 22:08:14'),
(49, 'RealBabanintu', 'Sadeeqdigital', '--', '--', '--', '01-11-2025 22:22:37'),
(50, 'Yaya', 'VisionTv', '--', '--', '--', '01-11-2025 23:01:34'),
(51, 'Danmakama', 'officialjayjay', '--', '--', '--', '01-11-2025 23:13:41'),
(52, 'mohammed', 'officialjayjay', '--', '--', '--', '02-11-2025 03:57:41'),
(53, 'Abubakar', 'officialjayjay', '--', '--', '--', '02-11-2025 06:25:37'),
(54, 'abbastalba', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 07:04:02'),
(55, 'ALYAUMA', 'RealBabanintu', '--', '--', '--', '02-11-2025 07:04:17'),
(56, 'Suleman', 'RealBabanintu', '--', '--', '--', '02-11-2025 07:04:30'),
(57, 'Talba', 'abbastalba', '--', '--', '--', '02-11-2025 07:09:30'),
(58, 'nazeerboy', 'RealBabanintu', '--', '--', '--', '02-11-2025 07:12:47'),
(59, 'Bimubarak', 'nazeerboy', '--', '--', '--', '02-11-2025 07:28:25'),
(60, 'Binsaif', 'RealBabanintu', '--', '--', '--', '02-11-2025 07:39:50'),
(61, 'Fatima', 'RealBabanintu', '--', '--', '--', '02-11-2025 07:40:21'),
(62, 'Dansaif', 'Binsaif', '--', '--', '--', '02-11-2025 07:44:36'),
(63, 'Binaminu', 'Binsaif', '--', '--', '--', '02-11-2025 07:47:54'),
(64, 'Meenal', 'Abarshi', '--', '--', '--', '02-11-2025 08:15:44'),
(65, 'Hurera', 'Abarshi', '--', '--', '--', '02-11-2025 08:16:44'),
(66, 'Realabanego', 'RealBabanintu', '--', '--', '--', '02-11-2025 08:25:57'),
(67, 'Sheikhasheik', 'RealBabanintu', '--', '--', '--', '02-11-2025 08:32:32'),
(68, 'Ameenukano', 'RealBabanintu', '--', '--', '--', '02-11-2025 08:33:52'),
(69, 'Coachk', 'RealBabanintu', '--', '--', '--', '02-11-2025 08:41:08'),
(70, 'Abbakaraminu', 'RealBabanintu', '--', '--', '--', '02-11-2025 08:59:43'),
(71, 'Upcoming', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:12:06'),
(72, 'Librarianabdul', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:26:36'),
(73, 'Jumaresco', 'emmanuel', '--', '--', '--', '02-11-2025 09:27:13'),
(74, 'YoungMd', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:28:44'),
(75, 'Bashir', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:30:27'),
(76, 'Sihsj', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:31:11'),
(77, 'Yunus', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:40:13'),
(78, 'abdulrahaman', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:43:26'),
(79, 'Magama', 'Hussainiruwaya', '--', '--', '--', '02-11-2025 09:48:29'),
(80, 'Idrisbabba', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:51:18'),
(81, 'Yusuf', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:52:38'),
(82, 'Idrismusa', 'Idrisbabba', '--', '--', '--', '02-11-2025 09:56:01'),
(83, 'Ayubasmall', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:58:17'),
(84, 'Abubakargoni', 'RealBabanintu', '--', '--', '--', '02-11-2025 09:59:22'),
(85, 'ABULHAKIM', 'abdulrahaman', '--', '--', '--', '02-11-2025 10:05:06'),
(86, 'Aleeyumuazu', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:07:06'),
(87, 'Ababakr', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:09:14'),
(88, 'Ummuanas', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:11:48'),
(89, 'Ahmad', 'Zksh', '--', '--', '--', '02-11-2025 10:16:49'),
(90, 'habubakar', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:26:36'),
(91, 'Nenebo', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:26:57'),
(92, 'Fauxiyya', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:31:21'),
(93, 'Realsani', 'Realabanego', '--', '--', '--', '02-11-2025 10:32:51'),
(94, 'DALLATU', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:32:54'),
(95, 'Bawasa', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:33:55'),
(96, 'Birma', 'RealBabanintu', '--', '--', '--', '02-11-2025 10:41:47'),
(97, 'Abusalman', 'Abusalmanu', '--', '--', '--', '02-11-2025 10:51:35'),
(98, 'Yusufu', 'Inusah', '--', '--', '--', '02-11-2025 10:53:47'),
(99, 'Abusalanu', 'Abusalmanu', '--', '--', '--', '02-11-2025 10:54:19'),
(100, 'Abusalanunn', 'Abusalmanu', '--', '--', '--', '02-11-2025 10:55:17'),
(101, 'Abusalmanuu', 'Abusalmanu', '--', '--', '--', '02-11-2025 10:59:50'),
(102, 'Hahha', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:00:44'),
(103, 'Hahharrrr', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:01:36'),
(104, 'Moooosa', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:02:11'),
(105, 'Nhkkkkk', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:07:01'),
(106, 'Abusalmanll', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:07:32'),
(107, 'Abusalmanuff', 'Abusalmanu', '--', '--', '--', '02-11-2025 11:08:03'),
(108, 'Yusufa', 'habubakar', '--', '--', '--', '02-11-2025 11:15:10'),
(109, 'khalifakubau', 'RealBabanintu', '--', '--', '--', '02-11-2025 11:27:20'),
(110, 'Yuzaseef', 'DALLATU', '--', '--', '--', '02-11-2025 11:28:18'),
(111, 'hansel', 'RealBabanintu', '--', '--', '--', '02-11-2025 11:30:40'),
(112, 'Realhabiba', 'Realabanego', '--', '--', '--', '02-11-2025 11:39:48'),
(113, 'danbalashinkafi', 'Suleman', '--', '--', '--', '02-11-2025 12:09:04'),
(114, 'Munkaila', 'RealBabanintu', '--', '--', '--', '02-11-2025 12:14:00'),
(115, 'Kamilujaja', 'RealBabanintu', '--', '--', '--', '02-11-2025 12:26:11'),
(116, 'Inyamuri', 'RealBabanintu', '--', '--', '--', '02-11-2025 12:43:48'),
(117, 'YAlhassan', 'RealBabanintu', '--', '--', '--', '02-11-2025 13:08:48'),
(118, 'mustaphadange', 'Coachk', '--', '--', '--', '02-11-2025 13:11:33'),
(119, 'realmrbeey', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 13:16:42'),
(120, 'Ashami', 'RealBabanintu', '--', '--', '--', '02-11-2025 13:17:19'),
(121, 'Masuduyakubu', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 13:26:21'),
(122, 'Coachdeejarth', 'RealBabanintu', '--', '--', '--', '02-11-2025 13:30:00'),
(123, 'Umar', 'ahmadeumar', '--', '--', '--', '02-11-2025 13:45:36'),
(124, 'tajiddin', 'RealBabanintu', '--', '--', '--', '02-11-2025 13:53:18'),
(125, 'JAMEEL', 'RealBabanintu', '--', '--', '--', '02-11-2025 14:03:08'),
(126, 'Kabirkankana', 'RealBabanintu', '--', '--', '--', '02-11-2025 14:51:02'),
(127, 'Junior', 'RealBabanintu', '--', '--', '--', '02-11-2025 15:04:54'),
(128, 'Lol', 'emmanuel', '--', '--', '--', '02-11-2025 15:22:10'),
(129, 'Sulieman', 'officialjayjay', '--', '--', '--', '02-11-2025 15:23:16'),
(130, 'Khady', 'RealBabanintu', '--', '--', '--', '02-11-2025 15:23:16'),
(131, 'Rabilou', 'RealBabanintu', '--', '--', '--', '02-11-2025 15:42:36'),
(132, 'Indirawa', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 15:45:04'),
(133, 'Diamond', 'mohammed', '--', '--', '--', '02-11-2025 15:49:19'),
(134, 'Yusufgo', 'RealBabanintu', '--', '--', '--', '02-11-2025 15:58:12'),
(135, 'Ali', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 16:02:19'),
(136, 'couchumar', 'Sadeeqdigital', '--', '--', '--', '02-11-2025 16:05:38'),
(137, 'Coachabbaprince', 'RealBabanintu', '--', '--', '--', '02-11-2025 16:13:44'),
(138, 'Kabirabubakar', 'VisionTv', '--', '--', '--', '02-11-2025 16:34:59'),
(139, 'Kabiru', 'RealBabanintu', '--', '--', '--', '02-11-2025 16:50:03'),
(140, 'Tijjaniusman', 'Kabiru', '--', '--', '--', '02-11-2025 16:58:08'),
(141, 'IbebahhArmalik', 'RealBabanintu', '--', '--', '--', '02-11-2025 17:12:58'),
(142, 'Mb', 'RealBabanintu', '--', '--', '--', '02-11-2025 17:44:38'),
(143, 'Boss', 'RealBabanintu', '--', '--', '--', '02-11-2025 18:06:41'),
(144, 'Hussain', 'RealBabanintu', '--', '--', '--', '02-11-2025 18:10:03'),
(145, 'BELLONCY', 'RealBabanintu', '--', '--', '--', '02-11-2025 18:54:17'),
(146, 'Nanakhadija', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:09:54'),
(147, 'ABDULLAHI', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:45:14'),
(148, 'Ogamusa', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:45:20'),
(149, 'Isa', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:46:15'),
(150, 'Realyahaya', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:54:43'),
(151, 'Babangida', 'RealBabanintu', '--', '--', '--', '02-11-2025 19:59:36'),
(152, 'habubukar', 'RealBabanintu', '--', '--', '--', '02-11-2025 20:13:21'),
(153, 'Player', 'RealBabanintu', '--', '--', '--', '02-11-2025 20:42:04'),
(154, 'Manakogsm', 'RealBabanintu', '--', '--', '--', '02-11-2025 20:45:01'),
(155, 'MaiAnguwa', 'Coachk', '--', '--', '--', '02-11-2025 20:45:58'),
(156, 'RealAbumukas', 'RealBabanintu', '--', '--', '--', '02-11-2025 20:52:01'),
(157, 'Abdulmajididris', 'RealBabanintu', '--', '--', '--', '02-11-2025 21:21:32'),
(158, 'Balkisudanladi', 'Manakogsm', '--', '--', '--', '02-11-2025 21:31:42'),
(159, 'Abdullah', 'RealBabanintu', '--', '--', '--', '02-11-2025 21:36:13'),
(160, 'rabaja', 'RealBabanintu', '--', '--', '--', '02-11-2025 21:55:23'),
(161, 'mahmudadamu', 'abbastalba', '--', '--', '--', '02-11-2025 22:27:33'),
(162, 'Dangombe', 'RealBabanintu', '--', '--', '--', '02-11-2025 22:46:53'),
(163, 'Tj', 'abbastalba', '--', '--', '--', '02-11-2025 22:54:42'),
(164, 'Kabirukbr', 'Kabirkankana', '--', '--', '--', '02-11-2025 23:28:29'),
(165, 'kabirfantah', 'RealBabanintu', '--', '--', '--', '03-11-2025 07:41:03'),
(166, 'Femi', 'VisionTv', '--', '--', '--', '03-11-2025 07:47:55'),
(167, 'Realmuktar', 'RealBabanintu', '--', '--', '--', '03-11-2025 08:49:11'),
(168, 'Eboy', 'Mrnonchalant', '--', '--', '--', '03-11-2025 08:55:09'),
(169, 'ramzy', 'Mrnonchalant', '--', '--', '--', '03-11-2025 08:59:39'),
(170, 'Beelybaby', 'Coachk', '--', '--', '--', '03-11-2025 09:00:20'),
(171, 'MuhammadShehu', 'RealBabanintu', '--', '--', '--', '03-11-2025 09:43:40'),
(172, 'Sirumar', 'Sadeeqdigital', '--', '--', '--', '03-11-2025 11:39:30'),
(173, 'Chijindu', 'VisionTv', '--', '--', '--', '03-11-2025 12:14:17'),
(174, 'Lucky', 'emmanuel', '--', '--', '--', '03-11-2025 12:21:28'),
(175, 'PillarS', 'Viviemedia', '--', '--', '--', '03-11-2025 12:28:04'),
(176, 'Frechiee', 'RealBabanintu', '--', '--', '--', '03-11-2025 12:31:04'),
(177, 'Blessedmedia', 'Viviemedia', '--', '--', '--', '03-11-2025 13:11:41'),
(178, 'Anis', 'RealBabanintu', '--', '--', '--', '03-11-2025 13:51:35'),
(179, 'Abdulm', 'Coachk', '--', '--', '--', '03-11-2025 13:55:37'),
(180, 'Anisa', 'RealBabanintu', '--', '--', '--', '03-11-2025 13:55:50'),
(181, 'Ismailamuhammad', 'emmanuel', '--', '--', '--', '03-11-2025 15:49:08'),
(182, 'Muhammadsaleh', 'Sadeeqdigital', '--', '--', '--', '03-11-2025 16:23:43'),
(183, 'Alhaji', 'Ismailamuhammad', '--', '--', '--', '03-11-2025 17:20:32'),
(184, 'Musa', 'Ismailamuhammad', '--', '--', '--', '03-11-2025 17:24:17'),
(185, 'Alkhairine', 'RealBabanintu', '--', '--', '--', '03-11-2025 17:27:42'),
(186, 'Vicky', 'Femi', '--', '--', '--', '03-11-2025 17:31:14'),
(187, 'effiongsamuel', 'Vicky', '--', '--', '--', '03-11-2025 18:09:14'),
(188, 'Gospel', 'Vicky', '--', '--', '--', '03-11-2025 18:11:40'),
(189, 'Collins', 'Vicky', '--', '--', '--', '03-11-2025 18:38:48'),
(190, 'Masuduyakub', 'Sadeeqdigital', '--', '--', '--', '03-11-2025 20:05:39'),
(191, 'habibagidado', 'Manakogsm', '--', '--', '--', '03-11-2025 20:46:23'),
(192, 'Musanura', 'Sadeeqdigital', '--', '--', '--', '03-11-2025 20:54:27'),
(193, 'Saniabbas', 'MuhammadShehu', '--', '--', '--', '03-11-2025 21:11:52'),
(194, 'Abbababa', 'VisionTv', '--', '--', '--', '03-11-2025 21:19:33'),
(195, 'Hamza', 'MuhammadShehu', '--', '--', '--', '03-11-2025 21:45:36'),
(196, 'hadifailah', 'MuhammadShehu', '--', '--', '--', '03-11-2025 21:51:20'),
(197, 'Rooboy', 'emmanuel', '--', '--', '--', '03-11-2025 21:56:29'),
(198, 'Musaali', 'Hamza', '--', '--', '--', '03-11-2025 21:59:21'),
(199, 'Yakubu', 'RealBabanintu', '--', '--', '--', '03-11-2025 22:02:19'),
(200, 'Emmaster', 'Rooboy', '--', '--', '--', '03-11-2025 22:07:54'),
(201, 'Eyibio', 'Rooboy', '--', '--', '--', '03-11-2025 22:08:38'),
(202, 'AYOGOD', 'RealBabanintu', '--', '--', '--', '03-11-2025 22:11:11'),
(203, 'Nseobot', 'Rooboy', '--', '--', '--', '03-11-2025 22:11:33'),
(204, 'Abubacarabdu', 'RealBabanintu', '--', '--', '--', '03-11-2025 22:16:15'),
(205, 'abbaak', 'RealBabanintu', '--', '--', '--', '03-11-2025 22:30:57'),
(206, 'Badamasiibrahim', 'RealBabanintu', '--', '--', '--', '03-11-2025 22:32:32'),
(207, 'Nasiru', 'Sadeeqdigital', '--', '--', '--', '03-11-2025 22:40:21'),
(208, 'Taurancy', 'MuhammadShehu', '--', '--', '--', '03-11-2025 22:58:15'),
(209, 'Ssauki', 'VisionTv', '--', '--', '--', '03-11-2025 23:18:01'),
(210, 'Pitoo', 'Viviemedia', '--', '--', '--', '03-11-2025 23:30:45'),
(211, 'Anasbinimalik', 'RealBabanintu', '--', '--', '--', '03-11-2025 23:46:44'),
(212, 'Luckyhappy', 'MuhammadShehu', '--', '--', '--', '04-11-2025 00:11:40'),
(213, 'Abdulmalik', 'VisionTv', '--', '--', '--', '04-11-2025 00:43:41'),
(214, 'Harunab', 'RealBabanintu', '--', '--', '--', '04-11-2025 05:59:03'),
(215, 'Wahleed', 'MuhammadShehu', '--', '--', '--', '04-11-2025 06:03:04'),
(216, 'sadeeq', 'VisionTv', '--', '--', '--', '04-11-2025 06:04:20'),
(217, 'Umarbello', 'MuhammadShehu', '--', '--', '--', '04-11-2025 06:15:10'),
(218, 'Umayma', 'RealBabanintu', '--', '--', '--', '04-11-2025 06:25:17'),
(219, 'Babu', 'Wahleed', '--', '--', '--', '04-11-2025 06:33:01'),
(220, 'Gusi', 'Babu', '--', '--', '--', '04-11-2025 06:46:38'),
(221, 'Babuu', 'Babu', '--', '--', '--', '04-11-2025 06:51:42'),
(222, 'Mama', 'Babu', '--', '--', '--', '04-11-2025 06:53:21'),
(223, 'Mimi', 'Babu', '--', '--', '--', '04-11-2025 07:12:38'),
(224, 'Bukar', 'Babu', '--', '--', '--', '04-11-2025 07:16:17'),
(225, 'Wess', 'Babu', '--', '--', '--', '04-11-2025 07:20:25'),
(226, 'Yaaya', 'Babu', '--', '--', '--', '04-11-2025 07:25:16'),
(227, 'Yaaaya', 'Babu', '--', '--', '--', '04-11-2025 07:27:50'),
(228, 'Maama', 'Babu', '--', '--', '--', '04-11-2025 07:31:38'),
(229, 'Kakolo', 'Babu', '--', '--', '--', '04-11-2025 07:35:07'),
(230, 'Zainab', 'Boss', '--', '--', '--', '04-11-2025 07:36:42'),
(231, 'Isiya', 'Boss', '--', '--', '--', '04-11-2025 07:43:17'),
(232, 'Yakubuyacksoon', 'RealBabanintu', '--', '--', '--', '04-11-2025 07:43:41'),
(233, 'Marte', 'Wahleed', '--', '--', '--', '04-11-2025 07:48:21'),
(234, 'Yackss', 'VisionTv', '--', '--', '--', '04-11-2025 07:58:34'),
(235, 'Mia', 'Viviemedia', '--', '--', '--', '04-11-2025 08:11:42'),
(236, 'Miagirlie', 'Viviemedia', '--', '--', '--', '04-11-2025 08:15:00'),
(237, 'Shehu', 'Wahleed', '--', '--', '--', '04-11-2025 08:15:24'),
(238, 'Ousmane', 'MuhammadShehu', '--', '--', '--', '04-11-2025 08:35:35'),
(239, 'DANALIKIRU', 'VisionTv', '--', '--', '--', '04-11-2025 08:57:46'),
(240, 'Muhamud', 'RealBabanintu', '--', '--', '--', '04-11-2025 09:03:10'),
(241, 'Saiduumar', 'DANALIKIRU', '--', '--', '--', '04-11-2025 09:04:33'),
(242, 'Kaigama', 'Babu', '--', '--', '--', '04-11-2025 09:05:12'),
(243, 'Gisse', 'emmanuel', '--', '--', '--', '04-11-2025 09:32:56'),
(244, 'Saiduumaru', 'Saiduumar', '--', '--', '--', '04-11-2025 14:25:47'),
(245, 'Saiduumaruh', 'Saiduumar', '--', '--', '--', '04-11-2025 14:26:55'),
(246, 'Saiduumay', 'Saiduumar', '--', '--', '--', '04-11-2025 14:28:12'),
(247, 'Saiduumarui', 'Saiduumar', '--', '--', '--', '04-11-2025 14:29:23'),
(248, 'Saiduum', 'Saiduumar', '--', '--', '--', '04-11-2025 14:30:47'),
(249, 'Saiduu', 'Saiduumar', '--', '--', '--', '04-11-2025 14:31:38'),
(250, 'Saiduumaruf', 'Saiduumar', '--', '--', '--', '04-11-2025 14:32:40'),
(251, 'Saiduumaruhg', 'Saiduumar', '--', '--', '--', '04-11-2025 14:33:22'),
(252, 'Saiduumarhjj', 'Saiduumar', '--', '--', '--', '04-11-2025 14:34:20'),
(253, 'Saiduumarjsj', 'Saiduumar', '--', '--', '--', '04-11-2025 14:35:01'),
(254, 'Donbless', 'VisionTv', '--', '--', '--', '04-11-2025 14:47:52'),
(255, 'Fatimasister', 'MuhammadShehu', '--', '--', '--', '04-11-2025 14:53:42'),
(256, 'ILERIOLUWA', 'emmanuel', '--', '--', '--', '04-11-2025 16:10:26'),
(257, 'Solo', 'Vicky', '--', '--', '--', '04-11-2025 16:36:49'),
(258, 'Shamsudeen', 'RealBabanintu', '--', '--', '--', '04-11-2025 16:58:01'),
(259, 'Lukumanumar', 'RealBabanintu', '--', '--', '--', '04-11-2025 17:28:28'),
(260, 'Mubaraktchd', 'MuhammadShehu', '--', '--', '--', '04-11-2025 18:40:06'),
(261, 'Aliyu', 'RealBabanintu', '--', '--', '--', '04-11-2025 20:54:55'),
(262, 'Usma', 'Aliyu', '--', '--', '--', '04-11-2025 21:19:16'),
(263, 'Dodogidanbaduwa', 'RealBabanintu', '--', '--', '--', '04-11-2025 23:13:42'),
(264, 'Hussiniadamu', 'Hussainiruwaya', '--', '--', '--', '04-11-2025 23:43:30'),
(265, 'JazzmanFX', 'emmanuel', '--', '--', '--', '05-11-2025 00:54:13'),
(266, 'Suraja', 'RealBabanintu', '--', '--', '--', '05-11-2025 02:01:12'),
(267, 'ABKMUHAMMAD', 'Wahleed', '--', '--', '--', '05-11-2025 07:15:34'),
(268, 'Leesi', 'VisionTv', '--', '--', '--', '05-11-2025 07:17:50'),
(269, 'Ahmae', 'ABKMUHAMMAD', '--', '--', '--', '05-11-2025 08:06:54'),
(270, 'aparanties', 'VisionTv', '--', '--', '--', '05-11-2025 10:21:43'),
(271, 'Msblegend', 'Sadeeqdigital', '--', '--', '--', '05-11-2025 10:51:30'),
(272, 'Btlaahmad', 'Realsani', '--', '--', '--', '05-11-2025 12:50:22'),
(273, 'Gobe', 'VisionTv', '--', '--', '--', '05-11-2025 15:02:59'),
(274, 'Adamcy', 'RealBabanintu', '--', '--', '--', '05-11-2025 18:21:37'),
(275, 'Eddy', 'Femi', '--', '--', '--', '05-11-2025 20:47:27'),
(276, 'Sanda', 'Adamcy', '--', '--', '--', '05-11-2025 21:29:11'),
(277, 'Smart', 'emmanuel', '--', '--', '--', '05-11-2025 21:54:09'),
(278, 'Leonas', 'RealBabanintu', '--', '--', '--', '05-11-2025 21:57:30'),
(279, 'Izubest', 'emmanuel', '--', '--', '--', '05-11-2025 22:55:54'),
(280, 'Gee', 'abbastalba', '--', '--', '--', '06-11-2025 05:25:59'),
(281, 'AbuPilot', 'VisionTv', '--', '--', '--', '07-11-2025 05:52:06'),
(282, 'Nasirum', 'Realabanego', '--', '--', '--', '07-11-2025 07:46:11'),
(283, 'Realsaleh', 'Realabanego', '--', '--', '--', '07-11-2025 10:11:28'),
(284, 'Realvictorp', 'Realabanego', '--', '--', '--', '07-11-2025 10:22:48'),
(285, 'hamesu', 'Yakubu', '--', '--', '--', '07-11-2025 11:23:09'),
(286, 'Realhabu', 'Realabanego', '--', '--', '--', '07-11-2025 12:09:32'),
(287, 'Realzainab', 'Realabanego', '--', '--', '--', '07-11-2025 12:11:18'),
(288, 'Realomega', 'Realabanego', '--', '--', '--', '07-11-2025 12:12:54'),
(289, 'Realarazanasu', 'Realabanego', '--', '--', '--', '07-11-2025 12:14:24'),
(290, 'Realharuna', 'Realabanego', '--', '--', '--', '07-11-2025 12:16:11'),
(291, 'Sani', 'Sadeeqdigital', '--', '--', '--', '07-11-2025 16:17:45'),
(292, 'Maybe', 'RealBabanintu', '--', '--', '--', '07-11-2025 17:43:15'),
(293, 'GENTLE', 'Bawasa', '--', '--', '--', '08-11-2025 07:29:30'),
(294, 'Taheer', 'Ahmadfx', '--', '--', '--', '08-11-2025 11:59:51'),
(295, 'Momi', 'Btlaahmad', '--', '--', '--', '09-11-2025 07:38:33'),
(296, 'Mubarak', 'Kabirkankana', '--', '--', '--', '09-11-2025 09:25:47'),
(297, 'Disciplineky', 'VisionTv', '--', '--', '--', '09-11-2025 09:33:58'),
(298, 'Hhddhdh', 'Yaya', '--', '--', '--', '09-11-2025 11:25:55'),
(299, 'Legendbaby', 'RealBabanintu', '--', '--', '--', '09-11-2025 20:29:14'),
(300, 'Muftahu', 'SBU', '--', '--', '--', '11-11-2025 07:33:28'),
(301, 'Calculus', 'Viviemedia', '--', '--', '--', '11-11-2025 19:15:49'),
(302, 'Haruna', 'Sadeeqdigital', '--', '--', '--', '11-11-2025 23:36:25'),
(303, 'GRO_96624', 'GRO_45211', '--', '--', '--', '2026-09-19 15:47:34'),
(304, 'GRO_37555', 'GRO_45211', '--', '--', '--', '2026-09-19 15:51:18'),
(305, 'GRO_37086', 'GRO_65972', '--', '--', '--', '2026-09-19 18:36:32'),
(306, 'GRO_73451', 'GRO_54979', '--', '--', '--', '2026-09-22 01:27:58'),
(307, 'GRO_33019', 'GRO_41704', '--', '--', '--', '2026-09-30 06:16:45'),
(308, 'GRO_25262', 'GRO_35982', '--', '--', '--', '2026-09-30 08:37:48'),
(309, 'GRO_37322', 'GRO_41704', '--', '--', '--', '2026-09-30 19:03:10'),
(310, 'GRO_34188', 'GRO_41704', '--', '--', '--', '2026-09-30 19:13:03'),
(311, 'GRO_72559', 'GRO_37322', '--', '--', '--', '2026-09-30 20:44:07'),
(312, 'GRO_44715', 'GRO_37322', '--', '--', '--', '2026-10-01 06:40:55'),
(313, 'GRO_45556', 'GRO_34188', '--', '--', '--', '2026-10-01 08:37:02'),
(314, 'GRO_13541', 'GRO_34188', '--', '--', '--', '2026-10-01 09:34:23'),
(315, 'GRO_80076', 'GRO_37322', '--', '--', '--', '2026-10-01 09:45:30'),
(316, 'GRO_56480', 'GRO_34188', '--', '--', '--', '2026-10-01 10:32:25'),
(317, 'GRO_87678', 'GRO_41704', '--', '--', '--', '2026-10-01 10:53:40'),
(318, 'GRO_76125', 'GRO_34188', '--', '--', '--', '2026-10-01 11:21:02'),
(319, 'GRO_91189', 'GRO_34188', '--', '--', '--', '2026-10-01 11:36:31'),
(320, 'GRO_43260', 'GRO_34188', '--', '--', '--', '2026-10-01 11:49:16'),
(321, 'GRO_19219', 'GRO_34188', '--', '--', '--', '2026-10-01 12:09:40'),
(322, 'GRO_89841', 'GRO_19219', '--', '--', '--', '2026-10-01 12:20:17'),
(323, 'GRO_49216', 'GRO_19219', '--', '--', '--', '2026-10-01 12:20:26'),
(324, 'GRO_71058', 'GRO_34188', '--', '--', '--', '2026-10-01 12:24:17'),
(325, 'GRO_27171', 'GRO_37322', '--', '--', '--', '2026-10-01 13:26:08'),
(326, 'GRO_51473', 'GRO_37322', '--', '--', '--', '2026-10-01 15:26:57'),
(327, 'GRO_76505', 'GRO_51473', '--', '--', '--', '2026-10-01 17:22:16'),
(328, 'GRO_67471', 'GRO_76505', '--', '--', '--', '2026-10-01 17:38:32'),
(329, 'GRO_40418', 'GRO_34188', '--', '--', '--', '2026-10-01 22:10:38'),
(330, 'GRO_70696', 'GRO_80076', '--', '--', '--', '2026-10-02 00:57:07'),
(331, 'GRO_11554', 'GRO_37322', '--', '--', '--', '2026-10-02 07:07:53'),
(332, 'GRO_72431', 'GRO_33019', '--', '--', '--', '2026-10-02 07:12:42'),
(333, 'GRO_50847', 'GRO_11554', '--', '--', '--', '2026-10-02 07:14:47'),
(334, 'GRO_36178', 'GRO_11554', '--', '--', '--', '2026-10-02 07:29:53'),
(335, 'GRO_76712', 'GRO_76505', '--', '--', '--', '2026-10-02 07:36:53'),
(336, 'GRO_62825', 'GRO_36178', '--', '--', '--', '2026-10-02 07:52:17'),
(337, 'GRO_36000', 'GRO_36178', '--', '--', '--', '2026-10-02 07:58:47'),
(338, 'GRO_93240', 'GRO_33019', '--', '--', '--', '2026-10-02 08:04:49'),
(339, 'GRO_13296', 'GRO_33019', '--', '--', '--', '2026-10-02 09:34:23'),
(340, 'GRO_24489', 'GRO_34188', '--', '--', '--', '2026-10-02 09:45:00'),
(341, 'GRO_71831', 'GRO_27171', '--', '--', '--', '2026-10-02 09:59:59'),
(342, 'GRO_16561', 'GRO_76712', '--', '--', '--', '2026-10-02 12:47:21'),
(343, 'GRO_60046', 'GRO_33019', '--', '--', '--', '2026-10-02 13:28:46'),
(344, 'GRO_28656', 'GRO_76712', '--', '--', '--', '2026-10-02 16:51:54'),
(345, 'GRO_84568', 'GRO_34188', '--', '--', '--', '2026-10-02 20:40:25'),
(346, 'GRO_93186', 'GRO_33019', '--', '--', '--', '2026-10-02 20:58:37'),
(347, 'GRO_92493', 'GRO_11554', '--', '--', '--', '2026-10-03 16:21:21'),
(348, 'GRO_75184', 'GRO_92493', '--', '--', '--', '2026-10-03 16:25:53'),
(349, 'GRO_30923', 'GRO_11554', '--', '--', '--', '2026-10-03 16:32:51'),
(350, 'GRO_24401', 'GRO_37322', '--', '--', '--', '2026-10-04 08:05:06'),
(351, 'GRO_42105', 'GRO_33019', '--', '--', '--', '2026-10-04 08:53:25'),
(352, 'GRO_79033', 'GRO_92493', '--', '--', '--', '2026-10-04 19:07:07'),
(353, 'GRO_30316', 'GRO_37322', '--', '--', '--', '2026-10-04 19:25:22'),
(354, 'GRO_40758', 'GRO_37322', '--', '--', '--', '2026-10-04 19:31:10');

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

--
-- Table structure for table `sitedetails`
--

CREATE TABLE `sitedetails` (
  `id` int NOT NULL,
  `sitename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `sitedesc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `apikey` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `refwithdraw` tinyint(1) NOT NULL,
  `datawithdraw` tinyint(1) NOT NULL,
  `activitywithdraw` tinyint(1) NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sitedetails`
--

INSERT INTO `sitedetails` (`id`, `sitename`, `sitedesc`, `apikey`, `refwithdraw`, `datawithdraw`, `activitywithdraw`, `date`) VALUES
(4, 'Gainmart', 'Gainmart', 'TW_pzeoglrjdijv3ort8ocsthdcj7f47z1', 0, 0, 1, '31-10-2025');

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

--
-- Table structure for table `spins`
--

CREATE TABLE `spins` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `multiplier` int NOT NULL,
  `amount_won` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `sponsoredpost`
--

CREATE TABLE `sponsoredpost` (
  `id` int NOT NULL,
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `image` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `url` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `sponsoredpost`
--

INSERT INTO `sponsoredpost` (`id`, `title`, `image`, `description`, `url`, `type`, `date`) VALUES
(1, 'Do', 'v2qdakdq2t.jpeg', 'Test', 'https://nicholasdaramola.carrd.co', 'yes', '17-09-2025 13:37:51'),
(2, 'Post', '6j536la1q8.jpg', '🔥 Ignite is the platform you need to overcome financial struggles! 💰\r\nWith simple tasks, promotions, and exciting opportunities, Ignite gives you the chance to earn daily while building financial freedom. 🚀 No stress, no limits—just consistency and dedication. Take charge of your income today and let Ignite be your key to financial breakthrough. ✨\r\n\r\nIgnite.cash.top', 'Ignite.cash.top', 'yes', '19-09-2025 07:32:22');

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

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `id` int NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `social_platform` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `duration_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `duration_value` int DEFAULT NULL,
  `expiration_date` datetime DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`id`, `title`, `description`, `image`, `link`, `amount`, `social_platform`, `duration_type`, `duration_value`, `expiration_date`, `status`, `date_created`) VALUES
(5, 'Test', 'Yes ', 'assets/images/tasks/1758755372_Screenshot_20250924-235813.jpg', 'https://nikkymedia.com.ng/', 1000.00, 'facebook', '0', 6, '2025-09-25 06:09:32', 1, '2025-09-24 23:09:32'),
(6, 'Yes ', 'Yes ', 'assets/images/tasks/1758755952_Screenshot_20250924-213044.jpg', 'https://nikkymedia.com.ng/', 30000.00, 'instagram', '0', 5, '2025-09-29 23:19:12', 1, '2025-09-24 23:19:12'),
(7, '10000', 'Bjaab', 'assets/images/tasks/1758756648_Screenshot_20250925-002923.jpg', 'https://nikkymedia.com.ng/', 30000.00, 'facebook', '0', 6, '2025-09-25 05:30:48', 1, '2025-09-24 23:30:48'),
(8, 'Yes ', 'Yes ', 'assets/images/tasks/1758757205_Screenshot_20250924-235813.jpg', 'https://nikkymedia.com.ng/', 30000.00, 'facebook', '0', 3, '2025-09-25 02:40:05', 1, '2025-09-24 23:40:05');

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

--
-- Table structure for table `topup`
--

CREATE TABLE `topup` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `network` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `reference` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amountpaid` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `plan` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'null',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `serviceid` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ownreference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amountcharged` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `message` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int NOT NULL,
  `fullname` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'set up',
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'set up',
  `funds` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `referralfunds` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `welcomefunds` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `totalrefearnings` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `indrefunds` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `thirdindrefunds` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `commission` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0',
  `image` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'default.png',
  `coupon` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `country` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'nigeria',
  `currency` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'NGN',
  `role` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'user',
  `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `plantype` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `flow_balance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `sec_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `profile_pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gbank` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gbank_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gbank_acct_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `fullname`, `username`, `email`, `phone`, `funds`, `referralfunds`, `welcomefunds`, `totalrefearnings`, `indrefunds`, `thirdindrefunds`, `commission`, `image`, `coupon`, `password`, `country`, `currency`, `role`, `status`, `plantype`, `date`, `time`, `flow_balance`, `sec_password`, `profile_pic`, `gbank`, `gbank_name`, `gbank_acct_num`) VALUES
(3355, 'User', 'GRO_35982', '09031875236@grocery.com', '09031875236', '797500', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$UhJ0bn1Xgl4xzjhSwtTNi.sJ/oDYfEeazu9ePLYhyXTlw25tIHUkO', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-29 15:39:19', '1795876759', 0.00, '$2y$10$U4knitioF3qNxrzSxbpKe.Ed4.oxoG3Ymlz.oVe.vBY5OHbWMrO/O', NULL, NULL, NULL, NULL),
(3356, 'User', 'GRO_68320', '07000000000@grocery.com', '07000000000', '100', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$MzjVUqaHxN3n3daHrQ551.5b1Nw1h5O4xnoi/KsIkXLqBs.pt.C0q', 'nigeria', 'NGN', 'admin', 'active', 'plan_a', '2026-09-29 15:41:04', '1795876864', 0.00, '$2y$10$lCTJnCXs8lfCvn66Ea8hdeYixwAnOvqNBVl5E74V/NpM5OQ5DKOjm', NULL, NULL, NULL, NULL),
(3357, 'User', 'GRO_38164', '07019601968@grocery.com', '07019601968', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$o/FQ.7T6fiXfZEZI9HC/3uVqzxda65gasCOjWphn1RTY22Fxe0M6i', 'nigeria', 'NGN', 'admin', 'active', 'plan_a', '2026-09-29 17:48:19', '1795884499', 0.00, '$2y$10$01zOjWL1JPD54DErJDupGeDyMcLShx26wAY0DB/wVNHXDDFVKD0im', NULL, 'UBA', 'Gift ikenga', '2089846430'),
(3358, 'User', 'GRO_41704', '09019601969@grocery.com', '09019601969', '8300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$BbR1C8avBEdAPEpJOvPpquzQDwvUe7vlt5PkAINeI2Dwrc/zYYaai', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 06:07:09', '1795928829', 0.00, '$2y$10$qNzlKVfqYJtuzexkBhDL5.Iq72nCXbBKMbc1nmKbdxnnYVvPvIzOe', NULL, 'Destiny onyedika ugwu', 'Zenith bank', '4324459924'),
(3359, 'User', 'GRO_33019', '09019069499@grocery.com', '09019069499', '3300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$0cU2f2l0MosFAnaPXdtxpOUxrL37HDE66CBALzlTwnJ.AwiZTKq/2', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 06:16:45', '1795929405', 0.00, '$2y$10$pfJOvrwm1LUxgGtzlhpZkOyP6cl4PJsGk0JW87Z9pQctxEaqsBOfG', NULL, NULL, NULL, NULL),
(3360, 'User', 'GRO_25262', '09070803468@grocery.com', '09070803468', '50000', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$UonqBgqZHxVSwhF5wLjzXOMmYadOeBwST4Zph6juNkIW1h10uUd/i', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 08:37:48', '1795937868', 0.00, '$2y$10$2ncBATz3Tabb1p1s7WltZ.hyd9mOs2kMF5FNZZy0jfEiMRJbQ63aG', NULL, NULL, NULL, NULL),
(3361, 'User', 'GRO_37322', '09035123315@grocery.com', '09035123315', '4000', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$jKClWLUmkjs6iLtQXQaqleky3aOAbFgfbwAXkLDEfoRAhAsU.6z8S', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 19:03:10', '1795975390', 0.00, '$2y$10$e/8HkG4MB.Joimn4FIAvXOHfZVYk3mpx8MJbwJqambzkYVJVYjavS', NULL, 'Access ', 'Nnaji Naomi Chinecherem ', '1903439324'),
(3362, 'Get rich with me', 'GRO_34188', '09067183999@grocery.com', '09067183999', '2200', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$fO21UCF9qCM8gDSTcckk6uwc6QkbiBbFfc8wuzE0oC6NNXhYB3XTm', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 19:13:03', '1795975983', 0.00, '$2y$10$eYQwrQtZQpPIUVlsjft/xOLbGaKfS9fGZrUULwlokyQWshimexXP.', NULL, 'Paga', 'Joshua chukwuebuka', '1084716478'),
(3363, 'User', 'GRO_72559', '09071949834@grocery.com', '09071949834', '1500', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$aQloMauTzFFC1RBnIxIW3ujoc/LUqbepMJ/o1JibzCemiEwH70IMu', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-09-30 20:44:07', '1795981447', 0.00, '$2y$10$FuTpotXxxj4E/ckrXapZ0OzKF4HMHcvjffyvjQXs6lOrDBT2zrbde', NULL, 'Opay', 'Obey Solomon uzodima ', '9071949834'),
(3364, 'User', 'GRO_44715', '09154407850@grocery.com', '09154407850', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$mD9nyRlKU5b7ypP1BlQs1OEskvH2EY6Sz9YDdnD2L5lZSV8DFCKzS', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 06:40:55', '1796017255', 0.00, '$2y$10$9QyoxH.AgExG.GXLma41xOEOU2bfsA56g9kim9lUJFkx2GIVDStEG', NULL, NULL, NULL, NULL),
(3365, 'User', 'GRO_40810', '09042808643@grocery.com', '09042808643', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$Cy4tCH15hk4Qc3SSZPeHfOS3A4SQhFU5DZdJTCXbe3O5hKEUe86ym', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 07:56:38', '1796021798', 0.00, '$2y$10$lG0S6OW5ZMPddTUm1V.dcOcHDV9JUincKd0.ocITmWQPaOq2TOg1u', NULL, NULL, NULL, NULL),
(3366, 'User', 'GRO_45556', '09071638390@grocery.com', '09071638390', '200', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$h7tPUo4OdDb.GtiUku20BOZzbZBgq5sz0OWmtLDwkN2/EVhUwqq3u', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 08:37:02', '1796024222', 0.00, '$2y$10$SVA1ZgYvVMSKsxh8YLdroO52Y1M8X7eUMY1agARc.3kxT0yvGlUZC', NULL, 'Eneh precious ifunanya ', 'Opay', '9071638390'),
(3367, 'User', 'GRO_13541', '07043488949@grocery.com', '07043488949', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$nHuCRX8S9lxnvctlnUdnl.zZSzkFFhYhgZCf9HV/6FwlcrHpNtu1a', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 09:34:23', '1796027663', 0.00, '$2y$10$r1dzqrCPVbGAcP36thJyg.6hMab3lDV4Sv8pnmi/cQZlaKi0cAFzy', NULL, NULL, NULL, NULL),
(3368, 'User', 'GRO_80076', '7025137789@grocery.com', '7025137789', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$UPJ7cFrioaReZzxTIJHVfeiyZytGhnTxO8MGtBfelA6HyDYDby3oa', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 09:45:30', '1796028330', 0.00, '$2y$10$8JkmPrgI00dp3hm0Eqg/bOE00zLJ0M3ntY912RH69rJPW7AtWQbJm', NULL, NULL, NULL, NULL),
(3369, 'Shuaibu hussaini', 'GRO_56480', '08084290211@grocery.com', '08084290211', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$ERVf2rzSF7rM5AaNTlau/..5bXt5qS1S0Utvay37rcTQSZ2uor8h.', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 10:32:25', '1796031145', 0.00, '$2y$10$meJBMTsBCPTPqD7WkWyd..bgu6/MhJYbRMzkZjIr2zeG1p3En5Mca', NULL, 'Access bank', 'Shuaibu Hussaini ishaq', '0057572850'),
(3370, 'User', 'GRO_87678', '08161185113@grocery.com', '08161185113', '2300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$gc2JYEhCYvlg6LLdzSgB7ednu8TQskBgUHFo6AOJLDEVRo55lNvsS', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 10:53:40', '1796032420', 0.00, '$2y$10$XAlnB.Owwglg9K2SV2UeYe5Y007o/77khPzl3Qnb2o86q4klPRN5S', NULL, 'Opay ', 'Chiamaka Colette Ogu ', '08161185113'),
(3371, 'User', 'GRO_76125', '08053646835@grocery.com', '08053646835', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$mUcGX3MEDUqvumulcRnWqemx1U62Mu/YyPjF6AXmr1ryyLeQ7dtRu', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 11:21:02', '1796034062', 0.00, '$2y$10$rNSGQE9CkRXQk1ZU35SxFuRWofHQtYqCla4IYJeUDm8yvcqmooUkq', NULL, NULL, NULL, NULL),
(3372, 'User', 'GRO_91189', '9032909283@grocery.com', '9032909283', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$QOqhvsYqklVEhu9xReMFm.nI0DTaYX2ERGyoD0CF8Hcsc62cxgb2C', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 11:36:31', '1796034991', 0.00, '$2y$10$6Vn1Wn69HNBFwqWtGpO.lO3PyAj7QSntEHeSPLbPpVK6DT/D/SLs6', NULL, 'Opay', 'OLABISI NNENNA SAMUEL', '9032909283'),
(3373, 'User', 'GRO_43260', '07042741451@grocery.com', '07042741451', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$8vZtiuK2EuYoUcfHz04fB.zMavwSSWL6x10TnyHEAhR8CvJItjz3S', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 11:49:16', '1796035756', 0.00, '$2y$10$nYbjSmiBemqIsHbzPvVLHeIXDgpHM.ZbxSsxCG5iheHJU7voWNg5i', NULL, NULL, NULL, NULL),
(3374, 'User', 'GRO_19219', '08036197579@grocery.com', '08036197579', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$v67Eu2tndaFF2gnoEea0/uXz/YkaWgl55It3ey3//CqRWE7xCE6kC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 12:09:40', '1796036980', 0.00, '$2y$10$GrI7DeLyaqGQNd3.0IWqyeUk9eZVhqaiaWrCcdG1MyZaclV0Y4HOa', NULL, NULL, NULL, NULL),
(3375, 'User', 'GRO_25658', '07077770557@grocery.com', '07077770557', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$FJ/kdSSPnkWE0F9CHizgJO.fauI5TZoesI5/bD2VdzUPQXYklNSJ2', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 12:16:57', '1796037417', 0.00, '$2y$10$M8l6bfB7lEXiTP8lIqs0L.it2TmPgKofm3esnjb2yz11gNFZemL5i', NULL, 'Opay ', 'omidiora ezekiel abioye ', '7077770557 '),
(3376, 'User', 'GRO_89841', '09150358128@grocery.com', '09150358128', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$1vzGJpqS6GRMnEjLuRHXDeSA87wlZZ61L2CmCLPf0VNN3xMGvXkrm', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 12:20:17', '1796037617', 0.00, '$2y$10$NWFC0oiKztAWU5ITuyIjx.Gf4RXfkBQRfMGggiVJHWmF/XCRos6aW', NULL, NULL, NULL, NULL),
(3377, 'User', 'GRO_49216', '09152105472@grocery.com', '09152105472', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$jKjGpTGyVfXAR1Sez9G3ZuS/bDyJytci515YBaxYHxPKXREAWKcUO', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 12:20:26', '1796037626', 0.00, '$2y$10$x52A5.oQy6c2T402/KA2jub8azWXgZu/lEl58ja0/PQIL/Zm8TNkq', NULL, 'Opay', 'Tetan Daniel ', '8154231838'),
(3378, 'User', 'GRO_71058', '+2348120912758@grocery.com', '+2348120912758', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$s09hj8mYrGlVLMmjzsG.f.vkV7Z8SckVovsqPj2.KtQrPQmBVecVC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 12:24:17', '1796037857', 0.00, '$2y$10$PQTJf.UAc4halhD727dmHur.N5DTM1gNGJ0uwwtWFUIplBU/aumMW', NULL, NULL, NULL, NULL),
(3379, 'User', 'GRO_27171', '09016150898@grocery.com', '09016150898', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$A2ieFLim4u7zbwKHmbjRsuLtLXzTUm9HIdls65dlmmxUs3BNplmMC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 13:26:08', '1796041568', 0.00, '$2y$10$Avs4dUVf6TaV95wAhA6KLOOAwnmIkVqEdgSRscnLQrBtBQGvXLchW', NULL, NULL, NULL, NULL),
(3380, 'User', 'GRO_51473', '08036341203@grocery.com', '08036341203', '0', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$0Csg0iMboTd8eg7T6XVeIORl.B3Y12T9tCstt8imrDIyzz7.cK3wW', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 15:26:57', '1796048817', 0.00, '$2y$10$gisu0nhfvpTv2RGOYsevc.16c8Wy8YJs6QbFhpAyWYbJxruJfs05m', NULL, 'Florence benjamin', 'UBA', '2155321052'),
(3381, 'User', 'GRO_69309', '07039269491@grocery.com', '07039269491', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$rrAMW6gl.9dqOEilNcIR.e7Gt4ftKAZ9CvVcOZZXgM0MpOntuCsty', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 16:55:36', '1796054136', 0.00, '$2y$10$7n.pIW2Lz/bQy/vuZu2dOeDU2WFvX/NvKfvgrD20/4ebG/GVUiSh6', NULL, NULL, NULL, NULL),
(3382, 'User', 'GRO_76505', '08060559296@grocery.com', '08060559296', '2000', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$Vwgj8AVna4IPQnLr.3PQtOfcqZWtaIU3JlhpnpEVwLUXa3OLgvMmC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 17:22:16', '1796055736', 0.00, '$2y$10$/sb8cQIa9pCO.IBu5Kf5GuOwz2Si8aYIFOEVtOjvGWHb2/.rfQBRi', NULL, 'Gift ikenga', 'UBA', '2089846430'),
(3383, 'User', 'GRO_67471', '09016092120@grocery.com', '09016092120', '100', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$hKkWZuFw3BriJG9aPVxSyeupd1SPVUzm9W3Fzlf3tiynSt0H9Cgcu', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 17:38:32', '1796056712', 0.00, '$2y$10$vhqNm4Dlq92nXOlWzFl0B.cHsZCn7pufIEgPnGcIqM.W4AIdJtv4q', NULL, 'UBA', 'Gift ikenga', '2089846430'),
(3384, 'User', 'GRO_65128', '07068681602@grocery.com', '07068681602', '2700', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$A9E7wvoV.U9G6mEl8IeotuaSIWexozkRPkTLLog3Ja/5wYNAmuVPK', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 17:44:22', '1796057062', 0.00, '$2y$10$.Pq3PGU44GaQfDimnG3rFOScxtioJBjrRQkPFBPEcZcuv9CO4Ul9u', NULL, 'Palmpay ', 'Salome Jumbo', '7068681602'),
(3385, 'User', 'GRO_40418', '09039697395@grocery.com', '09039697395', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$BOv8y9Dv7jD9FgAhL1LjH.ihAVoPVPs9HZAvr59PzPqEW2iBOxU22', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-01 22:10:38', '1796073038', 0.00, '$2y$10$NdqZ.ZTkwZ3XAIqwr9vbT.25o1ryFAiNpZnF/5a4c46PxhrHT5nka', NULL, NULL, NULL, NULL),
(3386, 'User', 'GRO_70696', '07087107606@grocery.com', '07087107606', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$/K2mZJJ2./3maQo2Va0qJOw7ci1WOJ6hTAM3NfbNJNOOUT1t/fH6m', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 00:57:07', '1796083027', 0.00, '$2y$10$0SVXAdU0TtLEli6tDq0e3.qlsFKzhB6aYYqAY9xTO2VVo6xX4fNl2', NULL, NULL, NULL, NULL),
(3387, 'User', 'GRO_11554', '08123057285@grocery.com', '08123057285', '8000', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$sWNMQBQt.prfo1fMoaVIIOXDEBBHf9C/5scBY6W9anZtuvywekHY2', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:07:53', '1796105273', 0.00, '$2y$10$V.LHSxH5z3uZ1/qryp7vaOEM4Fehv/vsqZGH5pLB9NqQo4N6Fe1zG', NULL, 'First bank', 'Ikenga Juliet nnenna', '3072852227'),
(3388, 'User', 'GRO_72431', '+2348136776645@grocery.com', '+2348136776645', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$aUbFYtLGuAGZireGBnMiWOau2vGsn2Ga.ES0sWs6hHOkC7dUGnYsC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:12:42', '1796105562', 0.00, '$2y$10$w11VeRtbOBorpXgFlyzqS.kDOB7Hh.Ezggc0jQLvQ9cTz/hHeiR26', NULL, NULL, NULL, NULL),
(3389, 'User', 'GRO_50847', '08032107121@grocery.com', '08032107121', '0', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$sbULdsNyOnBGvprydrhq3.AF7tUhrvCyDjKAXoxEJcIEnh3QQbFp6', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:14:47', '1796105687', 0.00, '$2y$10$5i6IaB8HC7sSgQe8E0XSqefeBm63hx0CtLEgX7ANdMgF295Cs37vy', NULL, 'First bank', 'Ikenga Juliet nnenna', '3072852227'),
(3390, 'User', 'GRO_36178', '08032107122@grocery.com', '08032107122', '0', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$qkFJ3CQ9nPQ6me1yhLNWRO.J8T5WZFnDBzTOpBCBvvsi2Shw5EnYi', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:29:53', '1796106593', 0.00, '$2y$10$InSR0b2SckdkTBPI7DmIpeciAIfzg7UKqB7L6SV.OWwEj9NrHfUnu', NULL, 'First bank', 'Faith', '3134777545'),
(3391, 'User', 'GRO_76712', '07062499865@grocery.com', '07062499865', '49300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$9Qxh8pQqL.5.V6YTI60kxubRhgX21qT3D9Sct.gxIJT4G0BHbZWjm', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:36:53', '1796107013', 0.00, '$2y$10$JWykV9QgnUvQBZJYtfUAo.EoSEqIML2/kc8DvsC9zTIHKBRfwrc4G', NULL, NULL, NULL, NULL),
(3392, 'User', 'GRO_62825', '07039171769@grocery.com', '07039171769', '0', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$Li9O6P3U.SJqH9HIxTPkAOmhm6jhoiSPaQp6fRXdlUfXj/ieUTpB.', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:52:17', '1796107937', 0.00, '$2y$10$Ll98gwzishZ1kc4nes31AuQwSqCzqAGYSA.vK6mdfEDfJlu4/0Keu', NULL, 'First bank', 'Faith', '3134777545'),
(3393, 'User', 'GRO_36000', '08032107123@grocery.com', '08032107123', '0', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$I5PI/qaCivJnVfMhzh7kzeuPXSo72A88sKM.O4N5FOcafHXVgd.SK', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 07:58:47', '1796108327', 0.00, '$2y$10$MKlZV7R2xVJ3DrPyD21wlODf4q/7dyktdfmhOjFh7mEet9xQqAyZm', NULL, 'First bank', 'Faith', '3134777545'),
(3394, 'User', 'GRO_93240', '08132448923@grocery.com', '08132448923', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$egUghZm4gRuwbTKBUbjMzuBqr89q9E4E/foChTUyVtsEKXsWclbbC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 08:04:49', '1796108689', 0.00, '$2y$10$VJ.AkZPhgakgNrbF4x9rh.RAt8kYAmYPkpOFP/XPnF763xzjDZA4e', NULL, 'Opay ', 'Miracle ugochukwu ukeka ', '8132448923'),
(3395, 'User', 'GRO_36984', '08135732297@grocery.com', '08135732297', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$XgkBjK/o0eZQcvzASs3F7.5zvKmyK7Zx8MerA0Vr/T06xh4rYZK/e', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 08:24:57', '1796109897', 0.00, '$2y$10$ELQ8eGH5JL57BXb9t0arf.6aBRHRj10m8hgAXaR4oinl7xOwTDjQS', NULL, NULL, NULL, NULL),
(3396, 'User', 'GRO_13296', '08026499841@grocery.com', '08026499841', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$WbVMfHL8hETQaoFv9..GQe5qzVBcigUs7fys2lWW4iMupwEbhmvoW', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 09:34:23', '1796114063', 0.00, '$2y$10$lv6qrcHLK/jRT2TXccOl8exGEhISrNqdcXGwlSmlUVg9HDgcfwmUm', NULL, NULL, NULL, NULL),
(3397, 'User', 'GRO_24489', '+2349034491154@grocery.com', '+2349034491154', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$VcsGooU3qH89aVEzHepcdu/Jkjvlr.D0kKRBUOqFQpY9qWTZHubfe', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 09:45:00', '1796114700', 0.00, '$2y$10$HmQHreW8jcYFznGkTzr6JuUn8HNjcfKorAtSmDN0pCg.BDbW3.fKS', NULL, NULL, NULL, NULL),
(3398, 'Eze Chinomnso', 'GRO_71831', '07066793026@grocery.com', '07066793026', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$PxKXAst.XSOcKsU7AE52/umUDngZ.4RE2cFsdXEaRdmZO6s4IMEt.', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 09:59:59', '1796115599', 0.00, '$2y$10$EtjWQH30r8.MLa9rG611B.0bTi0zdNG252r0ni2DdzN9s7OdaEzIW', NULL, 'Palmpay ', 'Eze Chinomnso ', '7066793026'),
(3399, 'User', 'GRO_16561', '08165412835@grocery.com', '08165412835', '18300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$KqAqTAoycuBnZ6MiDTlFfukhLIQdZHrr0si/9I8yqizWEdBz63gwK', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 12:47:21', '1796125641', 0.00, '$2y$10$rsu53ry.u0py.Ifrf2JTXuP67HiGatNsg/ny8eATGCAI6j/Hasfwa', NULL, 'Keystone Bank ', 'John Paul ', '6037301305'),
(3400, 'User', 'GRO_60046', '07026756474@grocery.com', '07026756474', '1520', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$6xTMEGVE3oTR1kxYA6YZR.mnPk8W3kmQqqVwIOoyvSCkt/H5XGedu', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 13:28:46', '1796128126', 0.00, '$2y$10$D5qKlY4Qn3nHMq8jUJLOserWbuuirbGpXs46rttAz7UcY.4RsfVm2', NULL, 'First', 'Sylvester Nweze', '2018210275'),
(3401, 'User', 'GRO_28656', '08068559276@grocery.com', '08068559276', '2300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$3LOXT34bEj.4GaWN6yayLOt5oyO9bEbo8LHosl9c2.rDUbSYIqQ6.', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 16:51:54', '1796140314', 0.00, '$2y$10$LIYwBxhze32J9y7.wDGE8OcReIvlDH7ENnDQcrAZ4vhPU27AvW4/6', NULL, NULL, NULL, NULL),
(3402, 'User', 'GRO_84568', '07063438607@grocery.com', '07063438607', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$hMe4czWIsHSSVeoRcosZyO32mZT4ooKLVLvDqO5/RxhH8OTtk66pm', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 20:40:25', '1796154025', 0.00, '$2y$10$qPYHpmfQ1DEJ6ptXRKb6OO1TMJ.YgmtRuJryA.y3tSk8WDla8Zyem', NULL, NULL, NULL, NULL),
(3403, 'User', 'GRO_93186', '09029785320@grocery.com', '09029785320', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$GdC8/bNgx8mNhGukRw1f..FJA0FsjrQ0GE9d/NYFepkGPlhITydzW', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-02 20:58:37', '1796155117', 0.00, '$2y$10$IqFah5dfdhM2OV0n4eRn7eJ1BMaGBXs/aKFFCRBuC7IT7ZjFx5d1q', NULL, 'Opay ', 'Oghogho osayemwren ', '9029785320'),
(3404, 'User', 'GRO_42111', '08034520832@grocery.com', '08034520832', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$bbmosMUD1o9PCinY0eeyX.98tjUJHlgR6GU1PLfb0.5rFrKq5Zzwy', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-03 07:21:14', '1796192474', 0.00, '$2y$10$TWsMzZ/jsEZ0o.tT24tSo.5DsJm77PYy0ouXcCc1iC7DDp5Cubs4e', NULL, NULL, NULL, NULL),
(3405, 'User', 'GRO_92493', '07037871925@grocery.com', '07037871925', '14300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$yuiebXJ2Za1Knkcyg7O17eIPJr5E5rNyN5Dn6l5c1hAcmchK3A1Eq', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-03 16:21:21', '1796224881', 0.00, '$2y$10$gCHzb.IssqMb3e5X0Wcn/eLesi6Y8pgVy7GRB/yPeMOHM4MGWeiHe', NULL, NULL, NULL, NULL),
(3406, 'User', 'GRO_75184', '08023329963@grocery.com', '08023329963', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$IA6k3rzzOmf1EBsPL0gN9OuuzrGKYy3W7Em7o7.q3IWnaxQbrt46W', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-03 16:25:53', '1796225153', 0.00, '$2y$10$/6ekDXkeOkaYmjbYFxSA4e.ds4KBvmlelvMdul9ctpUNxe/q9o7ea', NULL, NULL, NULL, NULL),
(3407, 'User', 'GRO_30923', '08035769347@grocery.com', '08035769347', '2300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$pcJKdAsBnHMIyrZYdtzNnOOnNNQcp/NQaJb8GcjHoGUa7oqeY6xuS', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-03 16:32:51', '1796225571', 0.00, '$2y$10$DgHJGubxMVrtPaN5S1P01uUv5Kt4Z.ru2PtlyoUt0DDIZnDcOB1ZK', NULL, NULL, NULL, NULL),
(3408, 'User', 'GRO_24401', '07075115155@grocery.com', '07075115155', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$GrN2jY4zA0DGvTWrwiDX9.UOimF5fy.fXUtrNd6l5EFwlLWBgpCU6', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-04 08:05:06', '1796281506', 0.00, '$2y$10$iOkiaNh8ynoYUG4xiPKZiOIJy5dkrFo51JRQDoWYDuYlJdLAyJDoG', NULL, 'Fidelity bank ', 'Vivian Ada Olah ', '6671257791'),
(3409, 'User', 'GRO_42105', '+2347044922365@grocery.com', '+2347044922365', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$jEQzXj3CWUXdYru78omVXO5FfKvL/QjVA.uA66SgnoR9.vdULtGbC', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-04 08:53:25', '1796284405', 0.00, '$2y$10$VUf4SkmQI/e9VtmY3RG7oONjfhCb05CWEgmDcYy5g7PTpUNpCT0au', NULL, NULL, NULL, NULL),
(3410, 'User', 'GRO_79033', '08037539430@grocery.com', '08037539430', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$HxMJElvPQTcxUTo8yHw9juORXvbNsh9wHYrXg/UM38VSQA5EsrNRu', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-04 19:07:07', '1796321227', 0.00, '$2y$10$LU1346uSaszFGT8lMdq3jeDrSKw50z5MnRzglBsUydONld5hqiIOG', NULL, 'ACCESS  BANK ', 'EZEALA QUEEN C ', '0053877448'),
(3411, 'User', 'GRO_30316', '09037966874@grocery.com', '09037966874', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$P614W5Jqd5aQFPt8FBTNqeTBPcHH0D8sJvB3uwB3tzFKCpmIDiv.C', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-04 19:25:22', '1796322322', 0.00, '$2y$10$abL681k5bHEFWdx6fwL59e/KEU.1WQyLUBMv/z6/3FS/JGB9PvOWy', NULL, NULL, NULL, NULL),
(3412, 'User', 'GRO_40758', '07049256538@grocery.com', '07049256538', '300', '0', '0', '0', '0', '0', '0', 'default.png', 'FREE_SIGNUP', '$2y$10$78TkuimHgN.acZ1Hhi42GOrwIUnwepZP5lOjEEl7D24yAMj3amJJi', 'nigeria', 'NGN', 'user', 'active', 'plan_a', '2026-10-04 19:31:10', '1796322670', 0.00, '$2y$10$ymkcrECcHaSXG8//E46c3evLkdY4jBm3eZSNJ5p1X0DasJDxl10hG', NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `userspin`
--

CREATE TABLE `userspin` (
  `id` int NOT NULL,
  `username` varchar(30) NOT NULL,
  `won` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `usersponsored`
--

CREATE TABLE `usersponsored` (
  `id` int NOT NULL,
  `username` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `usersponsored`
--

INSERT INTO `usersponsored` (`id`, `username`, `title`, `date`) VALUES
(1, 'Legendnikky', 'Do', '17-09-2025 13:38:20'),
(2, 'Samtux', 'Post', '19-09-2025 07:33:19'),
(3, 'Samtuxx', 'Post', '19-09-2025 07:34:51');

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

--
-- Table structure for table `usertasks`
--

CREATE TABLE `usertasks` (
  `id` int NOT NULL,
  `username` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `amount` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `status` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'completed',
  `reference` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `uservideo`
--

CREATE TABLE `uservideo` (
  `id` int NOT NULL,
  `username` varchar(30) NOT NULL,
  `reference` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `user_tasks`
--

CREATE TABLE `user_tasks` (
  `id` int NOT NULL,
  `task_id` int NOT NULL,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `completion_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `ven`
--

CREATE TABLE `ven` (
  `id` int NOT NULL,
  `username` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `description` varchar(300) NOT NULL,
  `status` varchar(30) NOT NULL,
  `network` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` int NOT NULL,
  `name` varchar(500) NOT NULL,
  `image` varchar(500) NOT NULL,
  `url` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `video`
--

CREATE TABLE `video` (
  `id` int NOT NULL,
  `title` varchar(300) NOT NULL,
  `videoid` varchar(100) NOT NULL,
  `url` varchar(1000) NOT NULL,
  `reference` varchar(20) NOT NULL,
  `amount` varchar(20) NOT NULL,
  `description` varchar(1000) NOT NULL,
  `date` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `withdrawals` (
  `id` int NOT NULL,
  `username` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `amount` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `description` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'pending',
  `network` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `reference` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `withdrawtype` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `package` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '--',
  `date` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `withdrawals` (`id`, `username`, `type`, `amount`, `description`, `status`, `network`, `reference`, `withdrawtype`, `package`, `date`) VALUES
(1, 'Legendnikky', 'activity', '1', 'Nicholas Ayomide Daramola', 'success', '--', '41iwiq2ws8', 'manual', '--', '17-09-2025 12:37:57'),
(2, 'Legendnikky', 'activity', '1', 'Nicholas Ayomide Daramola', 'success', '--', 'grmgzsxryi', 'manual', '--', '19-09-2025 01:11:01');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `airtimeprices`
--
ALTER TABLE `airtimeprices`
  ADD UNIQUE KEY `id` (`id`,`network`,`discount`,`date`);

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

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

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

--
-- Indexes for table `claimed_tasks`
--
ALTER TABLE `claimed_tasks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_task` (`username`,`task_id`);

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

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

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

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

--
-- Indexes for table `dailyvideo`
--
ALTER TABLE `dailyvideo`
  ADD PRIMARY KEY (`id`,`reference`);

--
-- Indexes for table `dataprices`
--
ALTER TABLE `dataprices`
  ADD UNIQUE KEY `id` (`id`,`network`,`serviceid`,`amount`,`dataplan`,`datatype`,`date`);

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

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

--
-- Indexes for table `flow_admins`
--
ALTER TABLE `flow_admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

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

--
-- Indexes for table `flow_bonus_logs`
--
ALTER TABLE `flow_bonus_logs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_daily_play` (`user_id`,`play_date`);

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

--
-- Indexes for table `flow_deposit_settings`
--
ALTER TABLE `flow_deposit_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payment_method` (`payment_method`);

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

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

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

--
-- Indexes for table `flow_promo_claims`
--
ALTER TABLE `flow_promo_claims`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_claim` (`user_id`,`milestone`);

--
-- Indexes for table `flow_referrals`
--
ALTER TABLE `flow_referrals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `username` (`username`),
  ADD KEY `referral` (`referral`);

--
-- Indexes for table `flow_referral_bonuses`
--
ALTER TABLE `flow_referral_bonuses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `referred_user_id` (`referred_user_id`),
  ADD KEY `package_id` (`package_id`);

--
-- Indexes for table `flow_settings`
--
ALTER TABLE `flow_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `setting_key` (`setting_key`);

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

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

--
-- Indexes for table `flow_users`
--
ALTER TABLE `flow_users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`),
  ADD UNIQUE KEY `email` (`email`);

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

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

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

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

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

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

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

--
-- Indexes for table `newtwo`
--
ALTER TABLE `newtwo`
  ADD UNIQUE KEY `acctnum` (`acctnum`,`bank`,`amount`,`narration`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `userspin`
--
ALTER TABLE `userspin`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `id` (`id`,`username`,`won`,`date`);

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

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

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

--
-- Indexes for table `user_tasks`
--
ALTER TABLE `user_tasks`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_task_unique` (`task_id`,`username`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activitylog`
--
ALTER TABLE `activitylog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bankaccounts`
--
ALTER TABLE `bankaccounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=132;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cableprices`
--
ALTER TABLE `cableprices`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `claimed_tasks`
--
ALTER TABLE `claimed_tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `dailyearn`
--
ALTER TABLE `dailyearn`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dailylogin`
--
ALTER TABLE `dailylogin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `dailytasks`
--
ALTER TABLE `dailytasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `dailyvideo`
--
ALTER TABLE `dailyvideo`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `earningstructure`
--
ALTER TABLE `earningstructure`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `electricity`
--
ALTER TABLE `electricity`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flow_admins`
--
ALTER TABLE `flow_admins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `flow_balance`
--
ALTER TABLE `flow_balance`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `flow_bonus_logs`
--
ALTER TABLE `flow_bonus_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `flow_deposits`
--
ALTER TABLE `flow_deposits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `flow_deposit_settings`
--
ALTER TABLE `flow_deposit_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `flow_packages`
--
ALTER TABLE `flow_packages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `flow_package_categories`
--
ALTER TABLE `flow_package_categories`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `flow_popup_settings`
--
ALTER TABLE `flow_popup_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `flow_promo_claims`
--
ALTER TABLE `flow_promo_claims`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `flow_referrals`
--
ALTER TABLE `flow_referrals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flow_referral_bonuses`
--
ALTER TABLE `flow_referral_bonuses`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flow_settings`
--
ALTER TABLE `flow_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `flow_tasks`
--
ALTER TABLE `flow_tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `flow_transactions`
--
ALTER TABLE `flow_transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;

--
-- AUTO_INCREMENT for table `flow_users`
--
ALTER TABLE `flow_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `flow_user_packages`
--
ALTER TABLE `flow_user_packages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `flow_user_tasks`
--
ALTER TABLE `flow_user_tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `flow_withdrawal_requests`
--
ALTER TABLE `flow_withdrawal_requests`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `indirectreferrals`
--
ALTER TABLE `indirectreferrals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=314;

--
-- AUTO_INCREMENT for table `loan`
--
ALTER TABLE `loan`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `newbanks`
--
ALTER TABLE `newbanks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `otp`
--
ALTER TABLE `otp`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profilelinks`
--
ALTER TABLE `profilelinks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profilephotos`
--
ALTER TABLE `profilephotos`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referrals`
--
ALTER TABLE `referrals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=355;

--
-- AUTO_INCREMENT for table `sitedetails`
--
ALTER TABLE `sitedetails`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `spins`
--
ALTER TABLE `spins`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sponsoredpost`
--
ALTER TABLE `sponsoredpost`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `topup`
--
ALTER TABLE `topup`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3413;

--
-- AUTO_INCREMENT for table `userspin`
--
ALTER TABLE `userspin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `usersponsored`
--
ALTER TABLE `usersponsored`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `usertasks`
--
ALTER TABLE `usertasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `uservideo`
--
ALTER TABLE `uservideo`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_tasks`
--
ALTER TABLE `user_tasks`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ven`
--
ALTER TABLE `ven`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `vendors`
--
ALTER TABLE `vendors`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `video`
--
ALTER TABLE `video`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `flow_referrals`
--
ALTER TABLE `flow_referrals`
  ADD CONSTRAINT `flow_referrals_ibfk_1` FOREIGN KEY (`username`) REFERENCES `flow_users` (`username`),
  ADD CONSTRAINT `flow_referrals_ibfk_2` FOREIGN KEY (`referral`) REFERENCES `flow_users` (`username`);

--
-- Constraints for table `flow_user_packages`
--
ALTER TABLE `flow_user_packages`
  ADD CONSTRAINT `flow_user_packages_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `flow_user_packages_ibfk_2` FOREIGN KEY (`package_id`) REFERENCES `flow_packages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `flow_user_tasks`
--
ALTER TABLE `flow_user_tasks`
  ADD CONSTRAINT `flow_user_tasks_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `flow_user_tasks_ibfk_2` FOREIGN KEY (`task_id`) REFERENCES `flow_tasks` (`id`) ON DELETE 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 */;
