-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 25, 2025 at 10:33 PM
-- Server version: 10.6.23-MariaDB
-- PHP Version: 8.4.11

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

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

--
-- Table structure for table `paga_accounts`
--

CREATE TABLE `paga_accounts` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(50) NOT NULL,
  `email` varchar(100) NOT NULL,
  `account_name` varchar(100) NOT NULL,
  `account_number` varchar(20) NOT NULL,
  `account_reference` varchar(50) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_via_api` tinyint(1) NOT NULL DEFAULT 0,
  `api_key_used` varchar(255) DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paga_accounts`
--

INSERT INTO `paga_accounts` (`id`, `unique_id`, `email`, `account_name`, `account_number`, `account_reference`, `created_at`, `created_via_api`, `api_key_used`, `ip_address`) VALUES
(19, '28VLGNPSCM', 'testuser@example.com', 'Test Aotech company', '3046869037', '0801234567828VLGNPSCM', '2025-05-27 00:00:14', 1, 'cHMBPNDpTF21819u57HjjGhCK6RjqOnIZS0Hx53AGLiKoGbXVPzNLw4EKr6Q', '102.90.103.160'),
(21, '28VLGNPSCM', 'ahmedoluwatobiabdulrasaq@gmail.com', 'Lord Aotech company', '3593385295', '0802891002128VLGNPSCM', '2025-05-27 00:10:47', 1, 'cHMBPNDpTF21819u57HjjGhCK6RjqOnIZS0Hx53AGLiKoGbXVPzNLw4EKr6Q', '102.88.105.63'),
(22, 'DJZVH4YK6B', 'companyaotech@gmail.com', 'Abdulrasaq Datapluzz', '3005708016', '09137585194DJZVH4YK6B', '2025-06-04 15:08:38', 0, NULL, NULL),
(23, '58KGYVXR4V', 'chigekwuchibuike@gmail.com', 'Gamaliel Noblestar', '3092323864', '0703439862758KGYVXR4V', '2025-06-04 18:19:15', 1, '5fhphCPTq8X6kj3gPMOt6K6NLM1Wm97x6MOLejJzjGZq84YHBTsv2SQVRBiE', '148.72.153.209'),
(24, '58KGYVXR4V', 'admin@radnidev.com.ng', 'Lucifer Noblestar', '2063125397', '0810032301258KGYVXR4V', '2025-06-04 18:37:13', 1, '5fhphCPTq8X6kj3gPMOt6K6NLM1Wm97x6MOLejJzjGZq84YHBTsv2SQVRBiE', '148.72.153.209'),
(30, 'ONVL32AQ9S', 'luciferstar666@gmail.com', 'Lucifer Billspree', '3568894029', '07072684323ONVL32AQ9S', '2025-06-06 03:18:44', 1, 'QPWx486hphJfT5lMI6w7OuHAq9TFA1NeU5OaBS45ngy2GHKoVC9H9r7M3qjv', '192.250.229.115'),
(33, '58KGYVXR4V', 'testuser@example.com', 'Test Noblestar', '1664310739', '0801234567858KGYVXR4V', '2025-06-11 21:20:34', 1, '5fhphCPTq8X6kj3gPMOt6K6NLM1Wm97x6MOLejJzjGZq84YHBTsv2SQVRBiE', '102.90.98.195'),
(34, '865QV70EM1', 'Chigekwuchibuike@gmail.com', 'gamaliel naeemdatasub', '0914514912', '07062669291865QV70EM1', '2025-06-12 01:31:28', 1, 'nGPhW1hB95qbVdRME0ZMBTkw8aAAD4TC66HcF9P7Hlejo9U9KLf6qgH3ixSt', '148.72.152.29'),
(35, '865QV70EM1', 'gamalielchigekwu@gmail.com', 'Chigekwu naeemdatasub', '2021691504', '07034398627865QV70EM1', '2025-06-12 12:57:37', 1, 'nGPhW1hB95qbVdRME0ZMBTkw8aAAD4TC66HcF9P7Hlejo9U9KLf6qgH3ixSt', '148.72.152.29'),
(37, 'GZJD0V1LTU', 'ahmedoluwatobiabdulrasaq@gmail.com', 'Abdulrasaq Aotech', '1350868999', '09137585177GZJD0V1LTU', '2025-06-13 22:24:55', 0, NULL, NULL),
(41, '58KGYVXR4V', 'lordkiller@gmail.com', 'Lord Noblestar', '2444892717', '0801111111158KGYVXR4V', '2025-06-17 18:53:52', 1, '5fhphCPTq8X6kj3gPMOt6K6NLM1Wm97x6MOLejJzjGZq84YHBTsv2SQVRBiE', '148.72.153.209'),
(46, 'DJZVH4YK6B', 'ahmedoluwatobiabdulrasaq@gmail.com', 'Abdulrasaq Datapluzz', '0645379572', '09137585177DJZVH4YK6B', '2025-06-19 15:18:52', 1, 'CwxaA7GKrOVqGLuf49Pj8TmTc46JF4VK61O5M8k23H59sjKh6QilIMgWZLPh', '192.250.229.115'),
(47, 'DJZVH4YK6B', 'chigekwuchibuike@gmail.com', 'Chigekwu Datapluzz', '1821268758', '08100323012DJZVH4YK6B', '2025-06-19 15:19:47', 1, 'CwxaA7GKrOVqGLuf49Pj8TmTc46JF4VK61O5M8k23H59sjKh6QilIMgWZLPh', '192.250.229.115'),
(61, 'DJZVH4YK6B', 'oyesoro11@gmail.com', 'OYEWOLE Datapluzz', '0860917744', '09045275459DJZVH4YK6B', '2025-06-25 22:20:05', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(64, 'X0N5GWLMH6', 'gamalielchigekwu@gmail.com', 'gamaliel OlatunbossVtuWebsite', '0107512121', '07034398627X0N5GWLMH6', '2025-06-26 11:20:22', 1, 'PLZP-EF198E615050B3DD1ABB', '62.138.14.173'),
(69, 'X0N5GWLMH6', 'timiadexnyi1@gmail.com', 'Barry OlatunbossVtuWebsite', '1154055913', '07072684324X0N5GWLMH6', '2025-06-27 07:22:20', 1, 'PLZP-EF198E615050B3DD1ABB', '62.138.14.173'),
(70, 'X0N5GWLMH6', 'support@gmail.com', 'Lord OlatunbossVtuWebsite', '0146047288', '07034398622X0N5GWLMH6', '2025-06-27 07:31:33', 1, 'PLZP-EF198E615050B3DD1ABB', '62.138.14.173'),
(71, 'X0N5GWLMH6', 'ahmedoluwatobiabdulrasaq@gmail.com', 'Lord OlatunbossVtuWebsite', '0151335738', '08028111111X0N5GWLMH6', '2025-06-27 07:40:35', 1, 'PLZP-EF198E615050B3DD1ABB', '62.138.14.173'),
(76, 'DJZVH4YK6B', 'tomiwaadewole863@gmail.com', 'Tomiwa Datapluzz', '2843997624', '09019348744DJZVH4YK6B', '2025-06-28 17:00:45', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(77, 'DJZVH4YK6B', 'igedung2019@gmail.com', 'Gideon Datapluzz', '3560889368', '08130362691DJZVH4YK6B', '2025-06-28 17:01:18', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(78, 'DJZVH4YK6B', 'ahmedabdulmuiz5@gmail.com', 'Ahmed Datapluzz', '2214456718', '08104298758DJZVH4YK6B', '2025-06-28 17:05:33', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(79, 'DJZVH4YK6B', 'isrealfarinto080@gmail.com', 'Farinto Datapluzz', '1177104294', '07042301369DJZVH4YK6B', '2025-06-28 17:18:06', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(80, 'DJZVH4YK6B', 'akinkunminurudeen35@gmail.com', 'Nurudeen Datapluzz', '1886816637', '08141893475DJZVH4YK6B', '2025-06-28 18:17:11', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(81, 'DJZVH4YK6B', 'adekat95@gmail.com', 'Biodun Datapluzz', '1048928066', '07066718246DJZVH4YK6B', '2025-06-28 20:35:58', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(82, 'DJZVH4YK6B', 'ujecadaj517@gmail.com', 'Fawas Datapluzz', '2624930565', '08014141477DJZVH4YK6B', '2025-06-28 21:12:17', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(84, 'DJZVH4YK6B', 'awokunlebolaji2018@gmail.com', 'Bolaji Datapluzz', '0847101722', '09033898753DJZVH4YK6B', '2025-06-28 22:45:49', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(85, 'DJZVH4YK6B', 'mustaphaadebayo1010@gmail.com', 'Mustapha Datapluzz', '2168242102', '08069986451DJZVH4YK6B', '2025-06-28 22:54:32', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(86, 'DJZVH4YK6B', 'muhammedismaheal@gmail.com', 'Muhammed Datapluzz', '0874128952', '08133759254DJZVH4YK6B', '2025-06-29 03:38:48', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(87, 'DJZVH4YK6B', 'thompsonstanford097@gmail.com', 'Thompson Datapluzz', '1761397688', '09031257225DJZVH4YK6B', '2025-06-29 06:51:14', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(89, 'DJZVH4YK6B', 'adeyemiadeyemi7777@gmail.com', 'Adeyemi Datapluzz', '3019085747', '09064554015DJZVH4YK6B', '2025-06-29 09:16:14', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(90, 'DJZVH4YK6B', 'rasqq5@gmail.com', 'Kadri Datapluzz', '0936130361', '07035743581DJZVH4YK6B', '2025-06-29 09:54:43', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(91, 'DJZVH4YK6B', 'graceyetunde274@gmail.com', 'Wura Datapluzz', '1186893552', '09152950747DJZVH4YK6B', '2025-06-29 13:17:34', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(92, 'DJZVH4YK6B', 'dayokay622@gmail.com', 'Adedayo Datapluzz', '1073974928', '07030552842DJZVH4YK6B', '2025-06-29 14:29:20', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(96, 'DJZVH4YK6B', 'abraham08146569177@gmail.com', 'Akintayo Datapluzz', '3707838479', '09047291783DJZVH4YK6B', '2025-06-30 11:32:37', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(100, 'DJZVH4YK6B', 'sholedaniel247@gmail.com', 'Daniel Datapluzz', '1697423237', '09127592012DJZVH4YK6B', '2025-06-30 19:39:51', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(104, 'DJZVH4YK6B', 'emmy57604@gmail.com', 'Adekunle Datapluzz', '2684952510', '08122810961DJZVH4YK6B', '2025-07-01 10:23:59', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(105, 'DJZVH4YK6B', 'ajiboyeabdul833@gmail.com', 'Ajiboye Datapluzz', '1402993701', '07015711451DJZVH4YK6B', '2025-07-01 11:49:44', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(106, 'DJZVH4YK6B', 'ahmadmuhammad6577@gmail.com', 'Ahmed Datapluzz', '2084018753', '07040795673DJZVH4YK6B', '2025-07-01 15:48:29', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(108, 'WIOJTPUYH4', 'luciferstar666@gmail.com', 'Lucifer HoneyData', '3299484146', '07072684323WIOJTPUYH4', '2025-07-02 19:57:05', 1, 'PLZP-F4B92B8D31B2EC51022F', '148.72.152.29'),
(109, 'DJZVH4YK6B', 'afeezsulaiman26@gmail.com', 'Sulaiman Datapluzz', '1303938447', '07083629746DJZVH4YK6B', '2025-07-02 22:07:58', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(110, 'WIOJTPUYH4', 'Chigekwuchibuike@gmail.com', 'Lucifer HoneyData', '0983139942', '08012133243WIOJTPUYH4', '2025-07-04 02:18:51', 1, 'PLZP-F4B92B8D31B2EC51022F', '148.72.152.29'),
(113, 'WIOJTPUYH4', 'lordkiller@gmail.com', 'Lord HoneyData', '0863781492', '08011111111WIOJTPUYH4', '2025-07-04 10:58:41', 1, 'PLZP-F4B92B8D31B2EC51022F', '148.72.152.29'),
(116, 'WIOJTPUYH4', 'sanijazul@gmail.com', 'gamaliel HoneyData', '0377707120', '07062669291WIOJTPUYH4', '2025-07-04 20:51:19', 1, 'PLZP-F4B92B8D31B2EC51022F', '148.72.152.29'),
(124, '90HGNMGF3H', 'luciferstar666@gmail.com', 'Lucifer Noney Telecom ', '0253309165', '0707268432390HGNMGF3H', '2025-07-05 14:16:13', 1, 'PLZP-1121E4E1695D2689BCDA', '148.72.152.29'),
(130, 'DJZVH4YK6B', 'hindatup@gmail.com', 'Mide Datapluzz', '1424617441', '08138053919DJZVH4YK6B', '2025-07-05 21:17:37', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(180, '8BAOHPCKR6', 'scammers@gmail.com', 'Scam Glowsub ', '1217257081', '081070707078BAOHPCKR6', '2025-07-15 06:50:03', 1, 'g9jcJVDF1N5Ye4KH9VAXI7yQB4ZuvEbAGk1sLqHB6owG5MKfqh9CaGhH9trM', '192.250.229.115'),
(192, 'D6BH561MP9', 'mhizadetayo@gmail.com', 'Mhiz Bectelecom ', '3287952444', '09015475357D6BH561MP9', '2025-07-19 06:50:43', 1, 'PLZP-A1466122F0F330F00929', '173.224.122.64'),
(198, 'DJZVH4YK6B', 'tijaniahmad168@gmail.com', 'Ahmad Datapluzz', '2118585394', '08055746801DJZVH4YK6B', '2025-07-20 07:21:22', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(229, 'X0N5GWLMH6', 'test@gmail.com', 'Test OlatunbossVtuWebsite', '2911030260', '09024096641X0N5GWLMH6', '2025-07-26 20:56:39', 1, 'PLZP-EF198E615050B3DD1ABB', '62.138.14.173'),
(453, 'DJZVH4YK6B', 'Pablowizzy1905@email.com', 'Pablo Datapluzz', '0828016061', '07077128050DJZVH4YK6B', '2025-08-06 17:59:11', 1, 'PLZP-2F574C26CBCB6AE8704F', '192.250.229.115'),
(477, '2YAHOVW0N4', 'favoursomtochukwu81@gmail.com', 'Favour Jvedata', '0182022681', '081618120852YAHOVW0N4', '2025-08-07 13:33:47', 1, 'plzp_29379296732a0596a7505e07935a40f4', '192.250.229.115'),
(478, 'B5M27AXH9V', 'Favoursomtochukwu81@gmail.com', 'Favour Airup', '1459991990', '08161812085B5M27AXH9V', '2025-08-07 14:54:24', 1, 'PLZP-3A56BC6B43546397B873', '50.30.32.128');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `paga_accounts`
--
ALTER TABLE `paga_accounts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=810;
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 */;
