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

START TRANSACTION;



--
-- Database: `phkfctvb_ras`
--

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

--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_code` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
  `id` int(11) NOT NULL,
  `browser` varchar(255) NOT NULL,
  `ip_adress` varchar(255) NOT NULL,
  `location` varchar(100) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `adminfund`
--

CREATE TABLE `adminfund` (
  `id` int(11) NOT NULL,
  `admin_id` varchar(255) NOT NULL,
  `identification` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `reason` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `adminfund`
--

INSERT INTO `adminfund` (`id`, `admin_id`, `identification`, `amount`, `reason`) VALUES
(154, 'ADMIN-27837373783', '96V8LPX3JF', '1000', 'Vvbbbb'),
(155, 'ADMIN-797590460', 'AVMGY462HD', '1000', 'Wallet Topup'),
(156, 'ADMIN-797590460', 'AVMGY462HD', '2000', 'Wallet Topup'),
(157, 'ADMIN-797590460', '96V8LPX3JF', '1000', 'Debit'),
(158, 'ADMIN-797590460', '05SZN8MM4U', '101', 'Wallet Topup'),
(159, 'ADMIN-1082689996', '4ET1X5H9PB', '950', 'Wallet topup '),
(160, 'ADMIN-797590460', 'AVMGY462HD', '500', 'Wallet Topup'),
(161, 'ADMIN-797590460', 'E1C7LVGA8K', '50', 'Bonus'),
(162, 'ADMIN-797590460', '99HBBM0HYI', '50', 'Bonus'),
(163, 'ADMIN-797590460', 'HEBJYG6HNH', '555', 'Refund'),
(164, 'ADMIN-797590460', 'AVMGY462HD', '16000', 'Wallet Topup'),
(165, 'ADMIN-797590460', '7U5N8OYJQL', '240', 'Bonus Topup'),
(166, 'ADMIN-1082689996', '4ET1X5H9PB', '900', 'Wallet Topup '),
(167, 'ADMIN-797590460', '5M40LMCGFX', '672', 'Wallet Topup'),
(168, 'ADMIN-797590460', 'RB9V4NVX5M', '200', 'Wallet Topup'),
(169, 'ADMIN-797590460', 'RB9V4NVX5M', '500', 'Wallet Topup'),
(170, 'ADMIN-1082689996', '4ET1X5H9PB', '895', 'Wallet topup '),
(171, 'ADMIN-797590460', '3LDN9LU075', '100', 'Refund'),
(172, 'ADMIN-1082689996', '4ET1X5H9PB', '950', 'Wallet topup '),
(173, 'ADMIN-797590460', '3LDN9LU075', '1990', 'Wallet Credit'),
(174, 'ADMIN-797590460', '05SZN8MM4U', '1990', 'Wallet Credit'),
(175, 'ADMIN-797590460', '5M40LMCGFX', '575', 'Wallet Topup '),
(176, 'ADMIN-797590460', 'RB9V4NVX5M', '550', 'Wallet Credit'),
(177, 'ADMIN-1082689996', '4ET1X5H9PB', '850', 'Wallet topup '),
(178, 'ADMIN-797590460', '5M40LMCGFX', '1975', 'Wallet Credit'),
(179, 'ADMIN-797590460', 'AVMGY462HD', '10000', 'Crediting Zeuspay CEO'),
(180, 'ADMIN-797590460', '5M40LMCGFX', '45000', 'DEBIT'),
(181, 'ADMIN-797590460', '5M40LMCGFX', '611', 'Debit'),
(182, 'ADMIN-797590460', '05SZN8MM4U', '2970', 'Wallet Topup'),
(183, 'ADMIN-797590460', 'AVMGY462HD', '850', 'Wallet Topup '),
(184, 'ADMIN-797590460', 'AVMGY462HD', '850', 'Wallet debit '),
(185, 'ADMIN-797590460', '30MDOQFG9H', '2057', 'Debit'),
(186, 'ADMIN-797590460', '3LDN9LU075', '885', 'Wallet Credit'),
(187, 'ADMIN-797590460', '9Y8B5VEJB6', '1970', 'Wallet Credit'),
(188, 'ADMIN-797590460', '5M40LMCGFX', '1475', 'Wallet Topup'),
(189, 'ADMIN-797590460', '3LDN9LU075', '875', 'Wallet Topup'),
(190, 'ADMIN-797590460', '5M40LMCGFX', '475', 'Wallet Topup'),
(191, 'ADMIN-797590460', '5M40LMCGFX', '457', 'Wallet Topup'),
(192, 'ADMIN-797590460', '5M40LMCGFX', '975', 'Wallet Topup '),
(193, 'ADMIN-797590460', '3LDN9LU075', '975', 'Wallet Topup '),
(194, 'ADMIN-797590460', 'AVMGY462HD', '850', 'Wallet Topup '),
(195, 'ADMIN-797590460', 'VY9AD6ZEKR', '290', 'Wallet Topup'),
(196, 'ADMIN-797590460', 'AVMGY462HD', '5000', 'Wallet Topup'),
(197, 'ADMIN-797590460', '4ET1X5H9PB', '1000', 'Credit'),
(198, 'ADMIN-797590460', 'VY9AD6ZEKR', '90', 'Credit'),
(199, 'ADMIN-797590460', 'AVMGY462HD', '285', 'Wallet Topup '),
(200, 'ADMIN-797590460', 'AVMGY462HD', '5000', 'Wallet Topup'),
(201, 'ADMIN-797590460', 'AVMGY462HD', '1000', 'Wallet Topup '),
(202, 'ADMIN-797590460', 'AVMGY462HD', '1000', 'Wallet Topup '),
(203, 'ADMIN-797590460', '4ET1X5H9PB', '1000', 'Wallet Topup '),
(204, 'ADMIN-797590460', '9WH02QSJL1', '2086', 'Wallet Topup'),
(205, 'ADMIN-797590460', 'JZJ94MAVHD', '10000', 'Admin Account funding'),
(206, 'ADMIN-797590460', 'AH5E0JVA8V', '82', 'Ultrasubdata Fund Transfer'),
(207, 'ADMIN-797590460', '85JLR49O4I', '400', 'Hshhshsh'),
(208, 'ADMIN-797590460', '0KH9SJIMAU', '1000', 'sfvew'),
(209, 'ADMIN-797590460', 'MGNJG5OD9U', '500', 'jjjjrefedf'),
(210, 'ADMIN-797590460', 'MGNJG5OD9U', '10000', 'uyiuhiu'),
(211, 'ADMIN-797590460', 'MGNJG5OD9U', '1000000', 'Duudduduxud'),
(212, 'ADMIN-797590460', '6GFVWHJXGM', '5000', 'Sjdjhjdjdjdjd'),
(213, 'ADMIN-797590460', '85JLR49O4I', '120000', 'no reason'),
(214, 'ADMIN-797590460', '85JLR49O4I', '3300', 'no reason'),
(215, 'ADMIN-797590460', 'MGNJG5OD9U', '971190', 'ghsdhhh'),
(216, 'ADMIN-797590460', 'MGNJG5OD9U', '1000000', 'ghctyhgctctvgh');

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

--
-- Table structure for table `airtime_requests`
--

CREATE TABLE `airtime_requests` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `network` varchar(50) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `receiving_amount` decimal(10,2) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `bank_name` varchar(100) DEFAULT NULL,
  `account_name` varchar(100) DEFAULT NULL,
  `account_number` varchar(20) DEFAULT NULL,
  `request_date` datetime DEFAULT NULL,
  `status` enum('pending','approved','rejected') DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `processed_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `available_types`
--

CREATE TABLE `available_types` (
  `id` int(11) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `service` varchar(255) NOT NULL,
  `type_name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `available_types`
--

INSERT INTO `available_types` (`id`, `service_id`, `service_name`, `service`, `type_name`, `status`) VALUES
(1, '1', 'DATA', 'MTN', 'SME', 'On'),
(2, '2', 'DATA', 'MTN', 'GIFTING', 'On'),
(3, '3', 'DATA', 'MTN', 'CORPORATE', 'On'),
(4, '4', 'DATA', 'MTN', 'SME 2', 'On'),
(5, '5', 'DATA', 'MTN', 'CORPORATE 2', 'On'),
(6, '1', 'DATA', 'GLO', 'GIFTING', 'On'),
(7, '2', 'DATA', 'GLO', 'CORPORATE', 'On'),
(8, '1', 'DATA', '9MOBILE', 'SME', 'On'),
(9, '1', 'DATA', 'AIRTEL', 'SME', 'On'),
(10, '2', 'DATA', 'AIRTEL', 'GIFTING', 'On'),
(11, '3', 'DATA', 'AIRTEL', 'CORPORATE', 'On');

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

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

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_code` varchar(20) NOT NULL,
  `status` enum('On','Off') DEFAULT 'On'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`id`, `bank_name`, `bank_code`, `status`) VALUES
(1, 'Providus Bank', '000023', 'Off'),
(2, '9 Payment Service Bank', '120001', 'Off'),
(3, 'Bell Mfb', '090529', 'Off'),
(4, 'Paga Bank', '100003', 'On'),
(5, 'Amucha MFB', '090286', 'Off'),
(7, 'Palmpay', '090286', 'Off'),
(8, 'Netbank', '090286', 'Off');

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

--
-- Table structure for table `banks_cache`
--

CREATE TABLE `banks_cache` (
  `id` int(11) NOT NULL,
  `bank_code` varchar(10) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `data` longtext NOT NULL,
  `last_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banks_cache`
--

INSERT INTO `banks_cache` (`id`, `bank_code`, `bank_name`, `data`, `last_updated`) VALUES
(1003, '050022', 'First Marina Trust Finance', '{\"bank\":{\"code\":\"050022\",\"name\":\"First Marina Trust Finance\"}}', '2026-01-15 22:09:15'),
(1004, '090832', '5TT MFB', '{\"bank\":{\"code\":\"090832\",\"name\":\"5TT MFB\"}}', '2026-01-15 22:09:15'),
(1005, '120001', '9 Payment Service Bank', '{\"bank\":{\"code\":\"120001\",\"name\":\"9 Payment Service Bank\"}}', '2026-01-15 22:09:15'),
(1006, '090629', '9Japay', '{\"bank\":{\"code\":\"090629\",\"name\":\"9Japay\"}}', '2026-01-15 22:09:15'),
(1007, '090270', 'AB Microfinance Bank', '{\"bank\":{\"code\":\"090270\",\"name\":\"AB Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1008, '070010', 'Abbey Mortgage Bank', '{\"bank\":{\"code\":\"070010\",\"name\":\"Abbey Mortgage Bank\"}}', '2026-01-15 22:09:15'),
(1009, '820', 'Abucoop MFB', '{\"bank\":{\"code\":\"820\",\"name\":\"Abucoop MFB\"}}', '2026-01-15 22:09:15'),
(1010, '044', 'Access Bank', '{\"bank\":{\"code\":\"044\",\"name\":\"Access Bank\"}}', '2026-01-15 22:09:15'),
(1011, '100052', 'Access Yellow', '{\"bank\":{\"code\":\"100052\",\"name\":\"Access Yellow\"}}', '2026-01-15 22:09:15'),
(1012, '090134', 'Accion Microfinance Bank', '{\"bank\":{\"code\":\"090134\",\"name\":\"Accion Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1013, '070030', 'Adamawa Mortgage Bank', '{\"bank\":{\"code\":\"070030\",\"name\":\"Adamawa Mortgage Bank\"}}', '2026-01-15 22:09:15'),
(1014, '090160', 'Addosser Microfinance Bank', '{\"bank\":{\"code\":\"090160\",\"name\":\"Addosser Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1015, '090614', 'Aella MFB', '{\"bank\":{\"code\":\"090614\",\"name\":\"Aella MFB\"}}', '2026-01-15 22:09:15'),
(1016, '090518', 'AFEMAI MFB', '{\"bank\":{\"code\":\"090518\",\"name\":\"AFEMAI MFB\"}}', '2026-01-15 22:09:15'),
(1017, '418', 'AG Mortgage Bank', '{\"bank\":{\"code\":\"418\",\"name\":\"AG Mortgage Bank\"}}', '2026-01-15 22:09:15'),
(1018, '120004', 'Airtel Smartcash PSB', '{\"bank\":{\"code\":\"120004\",\"name\":\"Airtel Smartcash PSB\"}}', '2026-01-15 22:09:15'),
(1019, '100029', 'Alternative Bank', '{\"bank\":{\"code\":\"100029\",\"name\":\"Alternative Bank\"}}', '2026-01-15 22:09:15'),
(1020, '050045', 'AMAANAH FINANCE', '{\"bank\":{\"code\":\"050045\",\"name\":\"AMAANAH FINANCE\"}}', '2026-01-15 22:09:15'),
(1021, '090180', 'AMJU Microfinance Bank', '{\"bank\":{\"code\":\"090180\",\"name\":\"AMJU Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1022, '090529', 'Ampersand Microfinance Bank', '{\"bank\":{\"code\":\"090529\",\"name\":\"Ampersand Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1023, '090816', 'ARM MFB', '{\"bank\":{\"code\":\"090816\",\"name\":\"ARM MFB\"}}', '2026-01-15 22:09:15'),
(1024, '090001', 'ASO Savings &#38; Loans', '{\"bank\":{\"code\":\"090001\",\"name\":\"ASO Savings &#38; Loans\"}}', '2026-01-15 22:09:15'),
(1025, '070033', 'ASPIRE MORTGAGE BANK', '{\"bank\":{\"code\":\"070033\",\"name\":\"ASPIRE MORTGAGE BANK\"}}', '2026-01-15 22:09:15'),
(1026, '090287', 'Asset Matrix Microfinance Bank', '{\"bank\":{\"code\":\"090287\",\"name\":\"Asset Matrix Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1027, '090264', 'Auchi Microfinance Bank', '{\"bank\":{\"code\":\"090264\",\"name\":\"Auchi Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1028, '090817', 'Auchi Poly MFB', '{\"bank\":{\"code\":\"090817\",\"name\":\"Auchi Poly MFB\"}}', '2026-01-15 22:09:15'),
(1029, '090478', 'Avuenegbe MFB', '{\"bank\":{\"code\":\"090478\",\"name\":\"Avuenegbe MFB\"}}', '2026-01-15 22:09:15'),
(1030, '090853', 'AVVIC MFB', '{\"bank\":{\"code\":\"090853\",\"name\":\"AVVIC MFB\"}}', '2026-01-15 22:09:15'),
(1031, '090862', 'BAIGE MFB', '{\"bank\":{\"code\":\"090862\",\"name\":\"BAIGE MFB\"}}', '2026-01-15 22:09:15'),
(1032, '110072', 'Bank 78', '{\"bank\":{\"code\":\"110072\",\"name\":\"Bank 78\"}}', '2026-01-15 22:09:15'),
(1033, '090367', 'Bank of Agriculture', '{\"bank\":{\"code\":\"090367\",\"name\":\"Bank of Agriculture\"}}', '2026-01-15 22:09:15'),
(1034, '090866', 'BANK78 MFB', '{\"bank\":{\"code\":\"090866\",\"name\":\"BANK78 MFB\"}}', '2026-01-15 22:09:15'),
(1035, '090136', 'Baobab Microfinance Bank', '{\"bank\":{\"code\":\"090136\",\"name\":\"Baobab Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1036, '090615', 'Bestar MFB', '{\"bank\":{\"code\":\"090615\",\"name\":\"Bestar MFB\"}}', '2026-01-15 22:09:15'),
(1037, '110074', 'Betastack Technologies', '{\"bank\":{\"code\":\"110074\",\"name\":\"Betastack Technologies\"}}', '2026-01-15 22:09:15'),
(1038, '090977', 'BLOC MFB', '{\"bank\":{\"code\":\"090977\",\"name\":\"BLOC MFB\"}}', '2026-01-15 22:09:15'),
(1039, '090743', 'BLOOMS MFB', '{\"bank\":{\"code\":\"090743\",\"name\":\"BLOOMS MFB\"}}', '2026-01-15 22:09:15'),
(1040, '090819', 'Boost MFB', '{\"bank\":{\"code\":\"090819\",\"name\":\"Boost MFB\"}}', '2026-01-15 22:09:15'),
(1041, '090395', 'BORGU MFB', '{\"bank\":{\"code\":\"090395\",\"name\":\"BORGU MFB\"}}', '2026-01-15 22:09:15'),
(1042, '50931', 'Bowen Microfinance Bank', '{\"bank\":{\"code\":\"50931\",\"name\":\"Bowen Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1043, '090804', 'Bowman MFB', '{\"bank\":{\"code\":\"090804\",\"name\":\"Bowman MFB\"}}', '2026-01-15 22:09:15'),
(1044, '050006', 'Branch International Financial Services', '{\"bank\":{\"code\":\"050006\",\"name\":\"Branch International Financial Services\"}}', '2026-01-15 22:09:15'),
(1045, '983', 'Bud Infrastructure', '{\"bank\":{\"code\":\"983\",\"name\":\"Bud Infrastructure\"}}', '2026-01-15 22:09:15'),
(1046, '090613', 'Build MicroFinance Bank', '{\"bank\":{\"code\":\"090613\",\"name\":\"Build MicroFinance Bank\"}}', '2026-01-15 22:09:15'),
(1047, '956', 'Capricon Digital', '{\"bank\":{\"code\":\"956\",\"name\":\"Capricon Digital\"}}', '2026-01-15 22:09:15'),
(1048, '100026', 'Carbon', '{\"bank\":{\"code\":\"100026\",\"name\":\"Carbon\"}}', '2026-01-15 22:09:15'),
(1049, '748', 'Cash Connect MFB', '{\"bank\":{\"code\":\"748\",\"name\":\"Cash Connect MFB\"}}', '2026-01-15 22:09:15'),
(1050, '090848', 'CASHA MFB', '{\"bank\":{\"code\":\"090848\",\"name\":\"CASHA MFB\"}}', '2026-01-15 22:09:15'),
(1051, '090360', 'CashConnect Microfinance Bank', '{\"bank\":{\"code\":\"090360\",\"name\":\"CashConnect Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1052, '090851', 'CEDRUS MFB', '{\"bank\":{\"code\":\"090851\",\"name\":\"CEDRUS MFB\"}}', '2026-01-15 22:09:15'),
(1053, '050043', 'CEVIANT FINANCE LIMIED', '{\"bank\":{\"code\":\"050043\",\"name\":\"CEVIANT FINANCE LIMIED\"}}', '2026-01-15 22:09:15'),
(1054, '090815', 'Charis MFB', '{\"bank\":{\"code\":\"090815\",\"name\":\"Charis MFB\"}}', '2026-01-15 22:09:15'),
(1055, '090490', 'Chukwunenye Microfinance Bank', '{\"bank\":{\"code\":\"090490\",\"name\":\"Chukwunenye Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1056, '023', 'Citibank Nigeria Limited', '{\"bank\":{\"code\":\"023\",\"name\":\"Citibank Nigeria Limited\"}}', '2026-01-15 22:09:15'),
(1057, '100032', 'Contec Global Infotech Limited', '{\"bank\":{\"code\":\"100032\",\"name\":\"Contec Global Infotech Limited\"}}', '2026-01-15 22:09:15'),
(1058, '090842', 'Cool Microfinance Bank Limited', '{\"bank\":{\"code\":\"090842\",\"name\":\"Cool Microfinance Bank Limited\"}}', '2026-01-15 22:09:15'),
(1059, '766', 'Core Step MFB', '{\"bank\":{\"code\":\"766\",\"name\":\"Core Step MFB\"}}', '2026-01-15 22:09:15'),
(1060, '090611', 'Creditville MFB', '{\"bank\":{\"code\":\"090611\",\"name\":\"Creditville MFB\"}}', '2026-01-15 22:09:15'),
(1061, '090560', 'Crust MFB', '{\"bank\":{\"code\":\"090560\",\"name\":\"Crust MFB\"}}', '2026-01-15 22:09:15'),
(1062, '090802', 'DABTIKIR MFB', '{\"bank\":{\"code\":\"090802\",\"name\":\"DABTIKIR MFB\"}}', '2026-01-15 22:09:15'),
(1063, '090391', 'Davodani Microfinance Bank', '{\"bank\":{\"code\":\"090391\",\"name\":\"Davodani Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1064, '090978', 'DEW MFB', '{\"bank\":{\"code\":\"090978\",\"name\":\"DEW MFB\"}}', '2026-01-15 22:09:15'),
(1065, '063', 'Diamond Bank', '{\"bank\":{\"code\":\"063\",\"name\":\"Diamond Bank\"}}', '2026-01-15 22:09:15'),
(1066, '090828', 'Dillon MFB', '{\"bank\":{\"code\":\"090828\",\"name\":\"Dillon MFB\"}}', '2026-01-15 22:09:15'),
(1067, '090404', 'Doje Microfinance Bank Limited', '{\"bank\":{\"code\":\"090404\",\"name\":\"Doje Microfinance Bank Limited\"}}', '2026-01-15 22:09:15'),
(1068, '090470', 'Dot MFB', '{\"bank\":{\"code\":\"090470\",\"name\":\"Dot MFB\"}}', '2026-01-15 22:09:15'),
(1069, '090821', 'DSC Microfinance Bank', '{\"bank\":{\"code\":\"090821\",\"name\":\"DSC Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1070, '999999', 'E-Settlement Ltd.', '{\"bank\":{\"code\":\"999999\",\"name\":\"E-Settlement Ltd.\"}}', '2026-01-15 22:09:15'),
(1071, '090707', 'Eastman MFB', '{\"bank\":{\"code\":\"090707\",\"name\":\"Eastman MFB\"}}', '2026-01-15 22:09:15'),
(1072, '050', 'Ecobank Nigeria', '{\"bank\":{\"code\":\"050\",\"name\":\"Ecobank Nigeria\"}}', '2026-01-15 22:09:15'),
(1073, '090097', 'Ekondo Microfinance Bank', '{\"bank\":{\"code\":\"090097\",\"name\":\"Ekondo Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1074, '090539', 'Enrich Microfinance Bank', '{\"bank\":{\"code\":\"090539\",\"name\":\"Enrich Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1075, '000019', 'Enterprise Bank', '{\"bank\":{\"code\":\"000019\",\"name\":\"Enterprise Bank\"}}', '2026-01-15 22:09:15'),
(1076, '090872', 'EQUATOR MFB', '{\"bank\":{\"code\":\"090872\",\"name\":\"EQUATOR MFB\"}}', '2026-01-15 22:09:15'),
(1077, '306', 'eTranzact', '{\"bank\":{\"code\":\"306\",\"name\":\"eTranzact\"}}', '2026-01-15 22:09:15'),
(1078, '050042', 'FACTORING AND SUPPLY CHAIN FINANCE LIMITED', '{\"bank\":{\"code\":\"050042\",\"name\":\"FACTORING AND SUPPLY CHAIN FINANCE LIMITED\"}}', '2026-01-15 22:09:15'),
(1079, '090551', 'Fairmoney Microfinance Bank', '{\"bank\":{\"code\":\"090551\",\"name\":\"Fairmoney Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1080, '070', 'Fidelity Bank', '{\"bank\":{\"code\":\"070\",\"name\":\"Fidelity Bank\"}}', '2026-01-15 22:09:15'),
(1081, '090111', 'Finatrust MFB', '{\"bank\":{\"code\":\"090111\",\"name\":\"Finatrust MFB\"}}', '2026-01-15 22:09:15'),
(1082, '011', 'First Bank of Nigeria', '{\"bank\":{\"code\":\"011\",\"name\":\"First Bank of Nigeria\"}}', '2026-01-15 22:09:15'),
(1083, '214', 'First City Monument Bank', '{\"bank\":{\"code\":\"214\",\"name\":\"First City Monument Bank\"}}', '2026-01-15 22:09:15'),
(1084, '090409', 'First City Monument Bank MFB', '{\"bank\":{\"code\":\"090409\",\"name\":\"First City Monument Bank MFB\"}}', '2026-01-15 22:09:15'),
(1085, '090868', 'FIRST LOWLAND MFB', '{\"bank\":{\"code\":\"090868\",\"name\":\"FIRST LOWLAND MFB\"}}', '2026-01-15 22:09:15'),
(1086, '309', 'First Monnie Wallet', '{\"bank\":{\"code\":\"309\",\"name\":\"First Monnie Wallet\"}}', '2026-01-15 22:09:15'),
(1087, '090856', 'FIT MFB', '{\"bank\":{\"code\":\"090856\",\"name\":\"FIT MFB\"}}', '2026-01-15 22:09:15'),
(1088, '090835', 'Flexi MFB', '{\"bank\":{\"code\":\"090835\",\"name\":\"Flexi MFB\"}}', '2026-01-15 22:09:15'),
(1089, '622', 'Flutterwave', '{\"bank\":{\"code\":\"622\",\"name\":\"Flutterwave\"}}', '2026-01-15 22:09:15'),
(1090, '400001', 'FSDH Merchant Bank', '{\"bank\":{\"code\":\"400001\",\"name\":\"FSDH Merchant Bank\"}}', '2026-01-15 22:09:15'),
(1091, '000027', 'Globus Bank', '{\"bank\":{\"code\":\"000027\",\"name\":\"Globus Bank\"}}', '2026-01-15 22:09:15'),
(1092, '090574', 'Goldman MFB', '{\"bank\":{\"code\":\"090574\",\"name\":\"Goldman MFB\"}}', '2026-01-15 22:09:15'),
(1093, '090495', 'Good News Microfinance Bank', '{\"bank\":{\"code\":\"090495\",\"name\":\"Good News Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1094, '090857', 'GRANULE MFB', '{\"bank\":{\"code\":\"090857\",\"name\":\"GRANULE MFB\"}}', '2026-01-15 22:09:15'),
(1095, '090599', 'Greenacres MFB', '{\"bank\":{\"code\":\"090599\",\"name\":\"Greenacres MFB\"}}', '2026-01-15 22:09:15'),
(1096, '090195', 'Grooming MFB', '{\"bank\":{\"code\":\"090195\",\"name\":\"Grooming MFB\"}}', '2026-01-15 22:09:15'),
(1097, '058', 'GTBank', '{\"bank\":{\"code\":\"058\",\"name\":\"GTBank\"}}', '2026-01-15 22:09:15'),
(1098, '110059', 'Habari Pay', '{\"bank\":{\"code\":\"110059\",\"name\":\"Habari Pay\"}}', '2026-01-15 22:09:15'),
(1099, '090147', 'Hackman Microfinance Bank', '{\"bank\":{\"code\":\"090147\",\"name\":\"Hackman Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1100, '090291', 'Hala Credit Microfinance Bank', '{\"bank\":{\"code\":\"090291\",\"name\":\"Hala Credit Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1101, '090980', 'HAMADA MFB', '{\"bank\":{\"code\":\"090980\",\"name\":\"HAMADA MFB\"}}', '2026-01-15 22:09:15'),
(1102, '090777', 'HAYAT TRUST MFB', '{\"bank\":{\"code\":\"090777\",\"name\":\"HAYAT TRUST MFB\"}}', '2026-01-15 22:09:15'),
(1103, '030', 'Heritage Bank', '{\"bank\":{\"code\":\"030\",\"name\":\"Heritage Bank\"}}', '2026-01-15 22:09:15'),
(1104, '120002', 'Hope Payment Service Bank', '{\"bank\":{\"code\":\"120002\",\"name\":\"Hope Payment Service Bank\"}}', '2026-01-15 22:09:15'),
(1105, '090118', 'Ibile Microfinance Bank', '{\"bank\":{\"code\":\"090118\",\"name\":\"Ibile Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1106, '090536', 'Ikoyi Osun MFB', '{\"bank\":{\"code\":\"090536\",\"name\":\"Ikoyi Osun MFB\"}}', '2026-01-15 22:09:15'),
(1107, '090834', 'ILUTITUN-OSORO MFB', '{\"bank\":{\"code\":\"090834\",\"name\":\"ILUTITUN-OSORO MFB\"}}', '2026-01-15 22:09:15'),
(1108, '090838', 'INEBA GOGO MFB', '{\"bank\":{\"code\":\"090838\",\"name\":\"INEBA GOGO MFB\"}}', '2026-01-15 22:09:15'),
(1109, '090849', 'ISI-UZO MFB', '{\"bank\":{\"code\":\"090849\",\"name\":\"ISI-UZO MFB\"}}', '2026-01-15 22:09:15'),
(1110, '301', 'Jaiz Bank', '{\"bank\":{\"code\":\"301\",\"name\":\"Jaiz Bank\"}}', '2026-01-15 22:09:15'),
(1111, '090003', 'Jubilee-Life Mortgage  Bank', '{\"bank\":{\"code\":\"090003\",\"name\":\"Jubilee-Life Mortgage  Bank\"}}', '2026-01-15 22:09:15'),
(1112, '090602', 'Kenechukwu Microfinance Bank', '{\"bank\":{\"code\":\"090602\",\"name\":\"Kenechukwu Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1113, '082', 'Key Stone Bank', '{\"bank\":{\"code\":\"082\",\"name\":\"Key Stone Bank\"}}', '2026-01-15 22:09:15'),
(1114, '090606', 'KKU MFB', '{\"bank\":{\"code\":\"090606\",\"name\":\"KKU MFB\"}}', '2026-01-15 22:09:15'),
(1115, '090865', 'KOBOWEB MFB', '{\"bank\":{\"code\":\"090865\",\"name\":\"KOBOWEB MFB\"}}', '2026-01-15 22:09:15'),
(1116, '090839', 'KOINS MFB', '{\"bank\":{\"code\":\"090839\",\"name\":\"KOINS MFB\"}}', '2026-01-15 22:09:15'),
(1117, '899', 'Kolomoni MFB', '{\"bank\":{\"code\":\"899\",\"name\":\"Kolomoni MFB\"}}', '2026-01-15 22:09:15'),
(1118, '100025', 'Konga Pay', '{\"bank\":{\"code\":\"100025\",\"name\":\"Konga Pay\"}}', '2026-01-15 22:09:15'),
(1119, '090380', 'Kredi Microfinance Bank', '{\"bank\":{\"code\":\"090380\",\"name\":\"Kredi Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1120, '090267', 'Kuda Microfinance Bank', '{\"bank\":{\"code\":\"090267\",\"name\":\"Kuda Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1121, '090177', 'Lapo Microfinance Bank', '{\"bank\":{\"code\":\"090177\",\"name\":\"Lapo Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1122, '397', 'LeadCity MFB', '{\"bank\":{\"code\":\"397\",\"name\":\"LeadCity MFB\"}}', '2026-01-15 22:09:15'),
(1123, '090420', 'Letshego Microfinance Bank', '{\"bank\":{\"code\":\"090420\",\"name\":\"Letshego Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1124, '070007', 'LIVINGTRUST MORTGAGE BANK', '{\"bank\":{\"code\":\"070007\",\"name\":\"LIVINGTRUST MORTGAGE BANK\"}}', '2026-01-15 22:09:15'),
(1125, '090620', 'LOMA BANK', '{\"bank\":{\"code\":\"090620\",\"name\":\"LOMA BANK\"}}', '2026-01-15 22:09:15'),
(1126, '000029', 'Lotus Bank', '{\"bank\":{\"code\":\"000029\",\"name\":\"Lotus Bank\"}}', '2026-01-15 22:09:15'),
(1127, '090825', 'MAHFUZ MFB', '{\"bank\":{\"code\":\"090825\",\"name\":\"MAHFUZ MFB\"}}', '2026-01-15 22:09:15'),
(1128, '090171', 'Mainstreet Microfinance Bank', '{\"bank\":{\"code\":\"090171\",\"name\":\"Mainstreet Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1129, '648', 'Malachy MFB', '{\"bank\":{\"code\":\"648\",\"name\":\"Malachy MFB\"}}', '2026-01-15 22:09:15'),
(1130, '090843', 'MAXITRUST MFB', '{\"bank\":{\"code\":\"090843\",\"name\":\"MAXITRUST MFB\"}}', '2026-01-15 22:09:15'),
(1131, '090854', 'MAYDEN MFB', '{\"bank\":{\"code\":\"090854\",\"name\":\"MAYDEN MFB\"}}', '2026-01-15 22:09:15'),
(1132, '090824', 'Mega MFB', '{\"bank\":{\"code\":\"090824\",\"name\":\"Mega MFB\"}}', '2026-01-15 22:09:15'),
(1133, '090867', 'MEMENTO MFB', '{\"bank\":{\"code\":\"090867\",\"name\":\"MEMENTO MFB\"}}', '2026-01-15 22:09:15'),
(1134, '090859', 'MIA MFB', '{\"bank\":{\"code\":\"090859\",\"name\":\"MIA MFB\"}}', '2026-01-15 22:09:15'),
(1135, '090455', 'Mkobo Microfinance Bank', '{\"bank\":{\"code\":\"090455\",\"name\":\"Mkobo Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1136, '100011', 'MKUDI', '{\"bank\":{\"code\":\"100011\",\"name\":\"MKUDI\"}}', '2026-01-15 22:09:15'),
(1137, '120003', 'Momo Payment Service Bank', '{\"bank\":{\"code\":\"120003\",\"name\":\"Momo Payment Service Bank\"}}', '2026-01-15 22:09:15'),
(1138, '090692', 'Moneytronics MFB', '{\"bank\":{\"code\":\"090692\",\"name\":\"Moneytronics MFB\"}}', '2026-01-15 22:09:15'),
(1139, '090405', 'Moniepoint Microfinance Bank', '{\"bank\":{\"code\":\"090405\",\"name\":\"Moniepoint Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1140, '090685', 'Moremonee Microfinance Bank Limited', '{\"bank\":{\"code\":\"090685\",\"name\":\"Moremonee Microfinance Bank Limited\"}}', '2026-01-15 22:09:15'),
(1141, '090979', 'MOVASCO-OP MFB', '{\"bank\":{\"code\":\"090979\",\"name\":\"MOVASCO-OP MFB\"}}', '2026-01-15 22:09:15'),
(1142, '950', 'Netapps Technology', '{\"bank\":{\"code\":\"950\",\"name\":\"Netapps Technology\"}}', '2026-01-15 22:09:15'),
(1143, '090194', 'Nirsal MFB', '{\"bank\":{\"code\":\"090194\",\"name\":\"Nirsal MFB\"}}', '2026-01-15 22:09:15'),
(1144, '090645', 'Nombank', '{\"bank\":{\"code\":\"090645\",\"name\":\"Nombank\"}}', '2026-01-15 22:09:15'),
(1145, '090822', 'Noun MFB', '{\"bank\":{\"code\":\"090822\",\"name\":\"Noun MFB\"}}', '2026-01-15 22:09:15'),
(1146, '090863', 'NOVEL MFB', '{\"bank\":{\"code\":\"090863\",\"name\":\"NOVEL MFB\"}}', '2026-01-15 22:09:15'),
(1147, '070001', 'NPF MicroFinance Bank', '{\"bank\":{\"code\":\"070001\",\"name\":\"NPF MicroFinance Bank\"}}', '2026-01-15 22:09:15'),
(1148, '090356', 'NSUKKA MFB', '{\"bank\":{\"code\":\"090356\",\"name\":\"NSUKKA MFB\"}}', '2026-01-15 22:09:15'),
(1149, '090345', 'OAU Microfinance Bank', '{\"bank\":{\"code\":\"090345\",\"name\":\"OAU Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1150, '090981', 'OBA MFB', '{\"bank\":{\"code\":\"090981\",\"name\":\"OBA MFB\"}}', '2026-01-15 22:09:15'),
(1151, '090852', 'OLOMU APERAN MFB', '{\"bank\":{\"code\":\"090852\",\"name\":\"OLOMU APERAN MFB\"}}', '2026-01-15 22:09:15'),
(1152, '090295', 'Omiye MFB', '{\"bank\":{\"code\":\"090295\",\"name\":\"Omiye MFB\"}}', '2026-01-15 22:09:15'),
(1153, '000036', 'Optimus Bank', '{\"bank\":{\"code\":\"000036\",\"name\":\"Optimus Bank\"}}', '2026-01-15 22:09:15'),
(1154, '327', 'Paga', '{\"bank\":{\"code\":\"327\",\"name\":\"Paga\"}}', '2026-01-15 22:09:15'),
(1155, '070008', 'Page Financials', '{\"bank\":{\"code\":\"070008\",\"name\":\"Page Financials\"}}', '2026-01-15 22:09:15'),
(1156, '100033', 'Palmpay', '{\"bank\":{\"code\":\"100033\",\"name\":\"Palmpay\"}}', '2026-01-15 22:09:15'),
(1157, '000030', 'Parallex MF Bank', '{\"bank\":{\"code\":\"000030\",\"name\":\"Parallex MF Bank\"}}', '2026-01-15 22:09:15'),
(1158, '100003', 'Parkway-ReadyCash', '{\"bank\":{\"code\":\"100003\",\"name\":\"Parkway-ReadyCash\"}}', '2026-01-15 22:09:15'),
(1159, '090680', 'PATHFINDER MFB', '{\"bank\":{\"code\":\"090680\",\"name\":\"PATHFINDER MFB\"}}', '2026-01-15 22:09:15'),
(1160, '329', 'PayAttitude Online', '{\"bank\":{\"code\":\"329\",\"name\":\"PayAttitude Online\"}}', '2026-01-15 22:09:15'),
(1161, '305', 'Paycom (Opay)', '{\"bank\":{\"code\":\"305\",\"name\":\"Paycom (Opay)\"}}', '2026-01-15 22:09:15'),
(1162, '090823', 'PAYREP MFB', '{\"bank\":{\"code\":\"090823\",\"name\":\"PAYREP MFB\"}}', '2026-01-15 22:09:15'),
(1163, '100039', 'Paystack Titan', '{\"bank\":{\"code\":\"100039\",\"name\":\"Paystack Titan\"}}', '2026-01-15 22:09:15'),
(1164, '090861', 'PENTECOST MFB', '{\"bank\":{\"code\":\"090861\",\"name\":\"PENTECOST MFB\"}}', '2026-01-15 22:09:15'),
(1165, '100042', 'Pocket App', '{\"bank\":{\"code\":\"100042\",\"name\":\"Pocket App\"}}', '2026-01-15 22:09:15'),
(1166, '050021', 'Poder finance', '{\"bank\":{\"code\":\"050021\",\"name\":\"Poder finance\"}}', '2026-01-15 22:09:15'),
(1167, '076', 'Polaris Bank', '{\"bank\":{\"code\":\"076\",\"name\":\"Polaris Bank\"}}', '2026-01-15 22:09:15'),
(1168, '000031', 'Premium Trust Bank', '{\"bank\":{\"code\":\"000031\",\"name\":\"Premium Trust Bank\"}}', '2026-01-15 22:09:15'),
(1169, '090499', 'Pristine Divitis Microfinance Bank', '{\"bank\":{\"code\":\"090499\",\"name\":\"Pristine Divitis Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1170, '090503', 'Projetcs Microfinance Bank', '{\"bank\":{\"code\":\"090503\",\"name\":\"Projetcs Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1171, '50739', 'Prospa Capital MFB', '{\"bank\":{\"code\":\"50739\",\"name\":\"Prospa Capital MFB\"}}', '2026-01-15 22:09:15'),
(1172, '101', 'Providus Bank', '{\"bank\":{\"code\":\"101\",\"name\":\"Providus Bank\"}}', '2026-01-15 22:09:15'),
(1173, '090496', 'Randalpha Microfinance Bank', '{\"bank\":{\"code\":\"090496\",\"name\":\"Randalpha Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1174, '090198', 'RenMoney Microfinance Bank', '{\"bank\":{\"code\":\"090198\",\"name\":\"RenMoney Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1175, '090713', 'RIMIN GADO MFB', '{\"bank\":{\"code\":\"090713\",\"name\":\"RIMIN GADO MFB\"}}', '2026-01-15 22:09:15'),
(1176, '090138', 'Royal Exchange Microfinance Bank', '{\"bank\":{\"code\":\"090138\",\"name\":\"Royal Exchange Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1177, '090175', 'Rubies MFB', '{\"bank\":{\"code\":\"090175\",\"name\":\"Rubies MFB\"}}', '2026-01-15 22:09:15'),
(1178, '090286', 'Safe Haven MFB', '{\"bank\":{\"code\":\"090286\",\"name\":\"Safe Haven MFB\"}}', '2026-01-15 22:09:15'),
(1179, '050024', 'Sciart Finance', '{\"bank\":{\"code\":\"050024\",\"name\":\"Sciart Finance\"}}', '2026-01-15 22:09:15'),
(1180, '090502', 'Shalom Microfinance Bank', '{\"bank\":{\"code\":\"090502\",\"name\":\"Shalom Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1181, '942', 'Smart Cash PSB', '{\"bank\":{\"code\":\"942\",\"name\":\"Smart Cash PSB\"}}', '2026-01-15 22:09:15'),
(1182, '090836', 'SOSA MFB', '{\"bank\":{\"code\":\"090836\",\"name\":\"SOSA MFB\"}}', '2026-01-15 22:09:15'),
(1183, '090641', 'Source MFB', '{\"bank\":{\"code\":\"090641\",\"name\":\"Source MFB\"}}', '2026-01-15 22:09:15'),
(1184, '090325', 'Sparkle', '{\"bank\":{\"code\":\"090325\",\"name\":\"Sparkle\"}}', '2026-01-15 22:09:15'),
(1185, '090436', 'Spectrum MFB', '{\"bank\":{\"code\":\"090436\",\"name\":\"Spectrum MFB\"}}', '2026-01-15 22:09:15'),
(1186, '090786', 'SPRINGVILLE MFB', '{\"bank\":{\"code\":\"090786\",\"name\":\"SPRINGVILLE MFB\"}}', '2026-01-15 22:09:15'),
(1187, '039', 'Stanbic IBTC Bank', '{\"bank\":{\"code\":\"039\",\"name\":\"Stanbic IBTC Bank\"}}', '2026-01-15 22:09:15'),
(1188, '068', 'Standard Chartered Bank Nigeria', '{\"bank\":{\"code\":\"068\",\"name\":\"Standard Chartered Bank Nigeria\"}}', '2026-01-15 22:09:15'),
(1189, '667', 'Stellas MFB', '{\"bank\":{\"code\":\"667\",\"name\":\"Stellas MFB\"}}', '2026-01-15 22:09:15'),
(1190, '232', 'Sterling Bank Plc', '{\"bank\":{\"code\":\"232\",\"name\":\"Sterling Bank Plc\"}}', '2026-01-15 22:09:15'),
(1191, '080003', 'Summit Bank', '{\"bank\":{\"code\":\"080003\",\"name\":\"Summit Bank\"}}', '2026-01-15 22:09:15'),
(1192, '100', 'SunTrust Bank Nigeria Limited', '{\"bank\":{\"code\":\"100\",\"name\":\"SunTrust Bank Nigeria Limited\"}}', '2026-01-15 22:09:15'),
(1193, '090827', 'SYCAMORE MFB', '{\"bank\":{\"code\":\"090827\",\"name\":\"SYCAMORE MFB\"}}', '2026-01-15 22:09:15'),
(1194, '000026', 'Taj Bank', '{\"bank\":{\"code\":\"000026\",\"name\":\"Taj Bank\"}}', '2026-01-15 22:09:15'),
(1195, '000042', 'Tatum Bank', '{\"bank\":{\"code\":\"000042\",\"name\":\"Tatum Bank\"}}', '2026-01-15 22:09:15'),
(1196, '090788', 'Tellerone MFB', '{\"bank\":{\"code\":\"090788\",\"name\":\"Tellerone MFB\"}}', '2026-01-15 22:09:15'),
(1197, '090716', 'TENN MFB', '{\"bank\":{\"code\":\"090716\",\"name\":\"TENN MFB\"}}', '2026-01-15 22:09:15'),
(1198, '000025', 'Titan Trust Bank', '{\"bank\":{\"code\":\"000025\",\"name\":\"Titan Trust Bank\"}}', '2026-01-15 22:09:15'),
(1199, '090801', 'Toprate Microfinance Bank', '{\"bank\":{\"code\":\"090801\",\"name\":\"Toprate Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1200, '672', 'Uda MFB', '{\"bank\":{\"code\":\"672\",\"name\":\"Uda MFB\"}}', '2026-01-15 22:09:15'),
(1201, '090820', 'Ukpor MFB', '{\"bank\":{\"code\":\"090820\",\"name\":\"Ukpor MFB\"}}', '2026-01-15 22:09:15'),
(1202, '090814', 'Umuoji MFB', '{\"bank\":{\"code\":\"090814\",\"name\":\"Umuoji MFB\"}}', '2026-01-15 22:09:15'),
(1203, '090193', 'Unical MFB', '{\"bank\":{\"code\":\"090193\",\"name\":\"Unical MFB\"}}', '2026-01-15 22:09:15'),
(1204, '090452', 'Unilag MFB', '{\"bank\":{\"code\":\"090452\",\"name\":\"Unilag MFB\"}}', '2026-01-15 22:09:15'),
(1205, '032', 'Union Bank of Nigeria', '{\"bank\":{\"code\":\"032\",\"name\":\"Union Bank of Nigeria\"}}', '2026-01-15 22:09:15'),
(1206, '033', 'United Bank for Africa', '{\"bank\":{\"code\":\"033\",\"name\":\"United Bank for Africa\"}}', '2026-01-15 22:09:15'),
(1207, '215', 'Unity Bank', '{\"bank\":{\"code\":\"215\",\"name\":\"Unity Bank\"}}', '2026-01-15 22:09:15'),
(1208, '090251', 'UNN Microfinance Bank', '{\"bank\":{\"code\":\"090251\",\"name\":\"UNN Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1209, '090619', 'URE MICROFINANCE BANK', '{\"bank\":{\"code\":\"090619\",\"name\":\"URE MICROFINANCE BANK\"}}', '2026-01-15 22:09:15'),
(1210, '050020', 'Vale Finance', '{\"bank\":{\"code\":\"050020\",\"name\":\"Vale Finance\"}}', '2026-01-15 22:09:15'),
(1211, '566', 'VFD Microfinance Bank Limited', '{\"bank\":{\"code\":\"566\",\"name\":\"VFD Microfinance Bank Limited\"}}', '2026-01-15 22:09:15'),
(1212, '090813', 'Victory MFB', '{\"bank\":{\"code\":\"090813\",\"name\":\"Victory MFB\"}}', '2026-01-15 22:09:15'),
(1213, '035', 'Wema Bank', '{\"bank\":{\"code\":\"035\",\"name\":\"Wema Bank\"}}', '2026-01-15 22:09:15'),
(1214, '050035', 'Whitecrust Finance', '{\"bank\":{\"code\":\"050035\",\"name\":\"Whitecrust Finance\"}}', '2026-01-15 22:09:15'),
(1215, '148', 'XPress MTS', '{\"bank\":{\"code\":\"148\",\"name\":\"XPress MTS\"}}', '2026-01-15 22:09:15'),
(1216, '738', 'XPress Payments', '{\"bank\":{\"code\":\"738\",\"name\":\"XPress Payments\"}}', '2026-01-15 22:09:15'),
(1217, '391', 'XPress Wallet', '{\"bank\":{\"code\":\"391\",\"name\":\"XPress Wallet\"}}', '2026-01-15 22:09:15'),
(1218, '964', 'Yello Digital Services', '{\"bank\":{\"code\":\"964\",\"name\":\"Yello Digital Services\"}}', '2026-01-15 22:09:15'),
(1219, '057', 'Zenith Bank', '{\"bank\":{\"code\":\"057\",\"name\":\"Zenith Bank\"}}', '2026-01-15 22:09:15'),
(1220, '090504', 'Zikora Microfinance Bank', '{\"bank\":{\"code\":\"090504\",\"name\":\"Zikora Microfinance Bank\"}}', '2026-01-15 22:09:15'),
(1221, '792', 'ZWallet', '{\"bank\":{\"code\":\"792\",\"name\":\"ZWallet\"}}', '2026-01-15 22:09:15'),
(1222, 'ALL_BANKS', 'Complete Banks List', '{\"status\":true,\"message\":\"Banks retrieved successfully\",\"data\":{\"banks\":[{\"code\":\"050022\",\"name\":\"First Marina Trust Finance\"},{\"code\":\"090832\",\"name\":\"5TT MFB\"},{\"code\":\"120001\",\"name\":\"9 Payment Service Bank\"},{\"code\":\"090629\",\"name\":\"9Japay\"},{\"code\":\"090270\",\"name\":\"AB Microfinance Bank\"},{\"code\":\"070010\",\"name\":\"Abbey Mortgage Bank\"},{\"code\":\"820\",\"name\":\"Abucoop MFB\"},{\"code\":\"044\",\"name\":\"Access Bank\"},{\"code\":\"100052\",\"name\":\"Access Yellow\"},{\"code\":\"090134\",\"name\":\"Accion Microfinance Bank\"},{\"code\":\"070030\",\"name\":\"Adamawa Mortgage Bank\"},{\"code\":\"090160\",\"name\":\"Addosser Microfinance Bank\"},{\"code\":\"090614\",\"name\":\"Aella MFB\"},{\"code\":\"090518\",\"name\":\"AFEMAI MFB\"},{\"code\":\"418\",\"name\":\"AG Mortgage Bank\"},{\"code\":\"120004\",\"name\":\"Airtel Smartcash PSB\"},{\"code\":\"100029\",\"name\":\"Alternative Bank\"},{\"code\":\"050045\",\"name\":\"AMAANAH FINANCE\"},{\"code\":\"090180\",\"name\":\"AMJU Microfinance Bank\"},{\"code\":\"090529\",\"name\":\"Ampersand Microfinance Bank\"},{\"code\":\"090816\",\"name\":\"ARM MFB\"},{\"code\":\"090001\",\"name\":\"ASO Savings &#38; Loans\"},{\"code\":\"070033\",\"name\":\"ASPIRE MORTGAGE BANK\"},{\"code\":\"090287\",\"name\":\"Asset Matrix Microfinance Bank\"},{\"code\":\"090264\",\"name\":\"Auchi Microfinance Bank\"},{\"code\":\"090817\",\"name\":\"Auchi Poly MFB\"},{\"code\":\"090478\",\"name\":\"Avuenegbe MFB\"},{\"code\":\"090853\",\"name\":\"AVVIC MFB\"},{\"code\":\"090862\",\"name\":\"BAIGE MFB\"},{\"code\":\"110072\",\"name\":\"Bank 78\"},{\"code\":\"090367\",\"name\":\"Bank of Agriculture\"},{\"code\":\"090866\",\"name\":\"BANK78 MFB\"},{\"code\":\"090136\",\"name\":\"Baobab Microfinance Bank\"},{\"code\":\"090615\",\"name\":\"Bestar MFB\"},{\"code\":\"110074\",\"name\":\"Betastack Technologies\"},{\"code\":\"090977\",\"name\":\"BLOC MFB\"},{\"code\":\"090743\",\"name\":\"BLOOMS MFB\"},{\"code\":\"090819\",\"name\":\"Boost MFB\"},{\"code\":\"090395\",\"name\":\"BORGU MFB\"},{\"code\":\"50931\",\"name\":\"Bowen Microfinance Bank\"},{\"code\":\"090804\",\"name\":\"Bowman MFB\"},{\"code\":\"050006\",\"name\":\"Branch International Financial Services\"},{\"code\":\"983\",\"name\":\"Bud Infrastructure\"},{\"code\":\"090613\",\"name\":\"Build MicroFinance Bank\"},{\"code\":\"956\",\"name\":\"Capricon Digital\"},{\"code\":\"100026\",\"name\":\"Carbon\"},{\"code\":\"748\",\"name\":\"Cash Connect MFB\"},{\"code\":\"090848\",\"name\":\"CASHA MFB\"},{\"code\":\"090360\",\"name\":\"CashConnect Microfinance Bank\"},{\"code\":\"090851\",\"name\":\"CEDRUS MFB\"},{\"code\":\"050043\",\"name\":\"CEVIANT FINANCE LIMIED\"},{\"code\":\"090815\",\"name\":\"Charis MFB\"},{\"code\":\"090490\",\"name\":\"Chukwunenye Microfinance Bank\"},{\"code\":\"023\",\"name\":\"Citibank Nigeria Limited\"},{\"code\":\"100032\",\"name\":\"Contec Global Infotech Limited\"},{\"code\":\"090842\",\"name\":\"Cool Microfinance Bank Limited\"},{\"code\":\"766\",\"name\":\"Core Step MFB\"},{\"code\":\"090611\",\"name\":\"Creditville MFB\"},{\"code\":\"090560\",\"name\":\"Crust MFB\"},{\"code\":\"090802\",\"name\":\"DABTIKIR MFB\"},{\"code\":\"090391\",\"name\":\"Davodani Microfinance Bank\"},{\"code\":\"090978\",\"name\":\"DEW MFB\"},{\"code\":\"063\",\"name\":\"Diamond Bank\"},{\"code\":\"090828\",\"name\":\"Dillon MFB\"},{\"code\":\"090404\",\"name\":\"Doje Microfinance Bank Limited\"},{\"code\":\"090470\",\"name\":\"Dot MFB\"},{\"code\":\"090821\",\"name\":\"DSC Microfinance Bank\"},{\"code\":\"999999\",\"name\":\"E-Settlement Ltd.\"},{\"code\":\"090707\",\"name\":\"Eastman MFB\"},{\"code\":\"050\",\"name\":\"Ecobank Nigeria\"},{\"code\":\"090097\",\"name\":\"Ekondo Microfinance Bank\"},{\"code\":\"090539\",\"name\":\"Enrich Microfinance Bank\"},{\"code\":\"000019\",\"name\":\"Enterprise Bank\"},{\"code\":\"090872\",\"name\":\"EQUATOR MFB\"},{\"code\":\"306\",\"name\":\"eTranzact\"},{\"code\":\"050042\",\"name\":\"FACTORING AND SUPPLY CHAIN FINANCE LIMITED\"},{\"code\":\"090551\",\"name\":\"Fairmoney Microfinance Bank\"},{\"code\":\"070\",\"name\":\"Fidelity Bank\"},{\"code\":\"090111\",\"name\":\"Finatrust MFB\"},{\"code\":\"011\",\"name\":\"First Bank of Nigeria\"},{\"code\":\"214\",\"name\":\"First City Monument Bank\"},{\"code\":\"090409\",\"name\":\"First City Monument Bank MFB\"},{\"code\":\"090868\",\"name\":\"FIRST LOWLAND MFB\"},{\"code\":\"309\",\"name\":\"First Monnie Wallet\"},{\"code\":\"090856\",\"name\":\"FIT MFB\"},{\"code\":\"090835\",\"name\":\"Flexi MFB\"},{\"code\":\"622\",\"name\":\"Flutterwave\"},{\"code\":\"400001\",\"name\":\"FSDH Merchant Bank\"},{\"code\":\"000027\",\"name\":\"Globus Bank\"},{\"code\":\"090574\",\"name\":\"Goldman MFB\"},{\"code\":\"090495\",\"name\":\"Good News Microfinance Bank\"},{\"code\":\"090857\",\"name\":\"GRANULE MFB\"},{\"code\":\"090599\",\"name\":\"Greenacres MFB\"},{\"code\":\"090195\",\"name\":\"Grooming MFB\"},{\"code\":\"058\",\"name\":\"GTBank\"},{\"code\":\"110059\",\"name\":\"Habari Pay\"},{\"code\":\"090147\",\"name\":\"Hackman Microfinance Bank\"},{\"code\":\"090291\",\"name\":\"Hala Credit Microfinance Bank\"},{\"code\":\"090980\",\"name\":\"HAMADA MFB\"},{\"code\":\"090777\",\"name\":\"HAYAT TRUST MFB\"},{\"code\":\"030\",\"name\":\"Heritage Bank\"},{\"code\":\"120002\",\"name\":\"Hope Payment Service Bank\"},{\"code\":\"090118\",\"name\":\"Ibile Microfinance Bank\"},{\"code\":\"090536\",\"name\":\"Ikoyi Osun MFB\"},{\"code\":\"090834\",\"name\":\"ILUTITUN-OSORO MFB\"},{\"code\":\"090838\",\"name\":\"INEBA GOGO MFB\"},{\"code\":\"090849\",\"name\":\"ISI-UZO MFB\"},{\"code\":\"301\",\"name\":\"Jaiz Bank\"},{\"code\":\"090003\",\"name\":\"Jubilee-Life Mortgage  Bank\"},{\"code\":\"090602\",\"name\":\"Kenechukwu Microfinance Bank\"},{\"code\":\"082\",\"name\":\"Key Stone Bank\"},{\"code\":\"090606\",\"name\":\"KKU MFB\"},{\"code\":\"090865\",\"name\":\"KOBOWEB MFB\"},{\"code\":\"090839\",\"name\":\"KOINS MFB\"},{\"code\":\"899\",\"name\":\"Kolomoni MFB\"},{\"code\":\"100025\",\"name\":\"Konga Pay\"},{\"code\":\"090380\",\"name\":\"Kredi Microfinance Bank\"},{\"code\":\"090267\",\"name\":\"Kuda Microfinance Bank\"},{\"code\":\"090177\",\"name\":\"Lapo Microfinance Bank\"},{\"code\":\"397\",\"name\":\"LeadCity MFB\"},{\"code\":\"090420\",\"name\":\"Letshego Microfinance Bank\"},{\"code\":\"070007\",\"name\":\"LIVINGTRUST MORTGAGE BANK\"},{\"code\":\"090620\",\"name\":\"LOMA BANK\"},{\"code\":\"000029\",\"name\":\"Lotus Bank\"},{\"code\":\"090825\",\"name\":\"MAHFUZ MFB\"},{\"code\":\"090171\",\"name\":\"Mainstreet Microfinance Bank\"},{\"code\":\"648\",\"name\":\"Malachy MFB\"},{\"code\":\"090843\",\"name\":\"MAXITRUST MFB\"},{\"code\":\"090854\",\"name\":\"MAYDEN MFB\"},{\"code\":\"090824\",\"name\":\"Mega MFB\"},{\"code\":\"090867\",\"name\":\"MEMENTO MFB\"},{\"code\":\"090859\",\"name\":\"MIA MFB\"},{\"code\":\"090455\",\"name\":\"Mkobo Microfinance Bank\"},{\"code\":\"100011\",\"name\":\"MKUDI\"},{\"code\":\"120003\",\"name\":\"Momo Payment Service Bank\"},{\"code\":\"090692\",\"name\":\"Moneytronics MFB\"},{\"code\":\"090405\",\"name\":\"Moniepoint Microfinance Bank\"},{\"code\":\"090685\",\"name\":\"Moremonee Microfinance Bank Limited\"},{\"code\":\"090979\",\"name\":\"MOVASCO-OP MFB\"},{\"code\":\"950\",\"name\":\"Netapps Technology\"},{\"code\":\"090194\",\"name\":\"Nirsal MFB\"},{\"code\":\"090645\",\"name\":\"Nombank\"},{\"code\":\"090822\",\"name\":\"Noun MFB\"},{\"code\":\"090863\",\"name\":\"NOVEL MFB\"},{\"code\":\"070001\",\"name\":\"NPF MicroFinance Bank\"},{\"code\":\"090356\",\"name\":\"NSUKKA MFB\"},{\"code\":\"090345\",\"name\":\"OAU Microfinance Bank\"},{\"code\":\"090981\",\"name\":\"OBA MFB\"},{\"code\":\"090852\",\"name\":\"OLOMU APERAN MFB\"},{\"code\":\"090295\",\"name\":\"Omiye MFB\"},{\"code\":\"000036\",\"name\":\"Optimus Bank\"},{\"code\":\"327\",\"name\":\"Paga\"},{\"code\":\"070008\",\"name\":\"Page Financials\"},{\"code\":\"100033\",\"name\":\"Palmpay\"},{\"code\":\"000030\",\"name\":\"Parallex MF Bank\"},{\"code\":\"100003\",\"name\":\"Parkway-ReadyCash\"},{\"code\":\"090680\",\"name\":\"PATHFINDER MFB\"},{\"code\":\"329\",\"name\":\"PayAttitude Online\"},{\"code\":\"305\",\"name\":\"Paycom (Opay)\"},{\"code\":\"090823\",\"name\":\"PAYREP MFB\"},{\"code\":\"100039\",\"name\":\"Paystack Titan\"},{\"code\":\"090861\",\"name\":\"PENTECOST MFB\"},{\"code\":\"100042\",\"name\":\"Pocket App\"},{\"code\":\"050021\",\"name\":\"Poder finance\"},{\"code\":\"076\",\"name\":\"Polaris Bank\"},{\"code\":\"000031\",\"name\":\"Premium Trust Bank\"},{\"code\":\"090499\",\"name\":\"Pristine Divitis Microfinance Bank\"},{\"code\":\"090503\",\"name\":\"Projetcs Microfinance Bank\"},{\"code\":\"50739\",\"name\":\"Prospa Capital MFB\"},{\"code\":\"101\",\"name\":\"Providus Bank\"},{\"code\":\"090496\",\"name\":\"Randalpha Microfinance Bank\"},{\"code\":\"090198\",\"name\":\"RenMoney Microfinance Bank\"},{\"code\":\"090713\",\"name\":\"RIMIN GADO MFB\"},{\"code\":\"090138\",\"name\":\"Royal Exchange Microfinance Bank\"},{\"code\":\"090175\",\"name\":\"Rubies MFB\"},{\"code\":\"090286\",\"name\":\"Safe Haven MFB\"},{\"code\":\"050024\",\"name\":\"Sciart Finance\"},{\"code\":\"090502\",\"name\":\"Shalom Microfinance Bank\"},{\"code\":\"942\",\"name\":\"Smart Cash PSB\"},{\"code\":\"090836\",\"name\":\"SOSA MFB\"},{\"code\":\"090641\",\"name\":\"Source MFB\"},{\"code\":\"090325\",\"name\":\"Sparkle\"},{\"code\":\"090436\",\"name\":\"Spectrum MFB\"},{\"code\":\"090786\",\"name\":\"SPRINGVILLE MFB\"},{\"code\":\"039\",\"name\":\"Stanbic IBTC Bank\"},{\"code\":\"068\",\"name\":\"Standard Chartered Bank Nigeria\"},{\"code\":\"667\",\"name\":\"Stellas MFB\"},{\"code\":\"232\",\"name\":\"Sterling Bank Plc\"},{\"code\":\"080003\",\"name\":\"Summit Bank\"},{\"code\":\"100\",\"name\":\"SunTrust Bank Nigeria Limited\"},{\"code\":\"090827\",\"name\":\"SYCAMORE MFB\"},{\"code\":\"000026\",\"name\":\"Taj Bank\"},{\"code\":\"000042\",\"name\":\"Tatum Bank\"},{\"code\":\"090788\",\"name\":\"Tellerone MFB\"},{\"code\":\"090716\",\"name\":\"TENN MFB\"},{\"code\":\"000025\",\"name\":\"Titan Trust Bank\"},{\"code\":\"090801\",\"name\":\"Toprate Microfinance Bank\"},{\"code\":\"672\",\"name\":\"Uda MFB\"},{\"code\":\"090820\",\"name\":\"Ukpor MFB\"},{\"code\":\"090814\",\"name\":\"Umuoji MFB\"},{\"code\":\"090193\",\"name\":\"Unical MFB\"},{\"code\":\"090452\",\"name\":\"Unilag MFB\"},{\"code\":\"032\",\"name\":\"Union Bank of Nigeria\"},{\"code\":\"033\",\"name\":\"United Bank for Africa\"},{\"code\":\"215\",\"name\":\"Unity Bank\"},{\"code\":\"090251\",\"name\":\"UNN Microfinance Bank\"},{\"code\":\"090619\",\"name\":\"URE MICROFINANCE BANK\"},{\"code\":\"050020\",\"name\":\"Vale Finance\"},{\"code\":\"566\",\"name\":\"VFD Microfinance Bank Limited\"},{\"code\":\"090813\",\"name\":\"Victory MFB\"},{\"code\":\"035\",\"name\":\"Wema Bank\"},{\"code\":\"050035\",\"name\":\"Whitecrust Finance\"},{\"code\":\"148\",\"name\":\"XPress MTS\"},{\"code\":\"738\",\"name\":\"XPress Payments\"},{\"code\":\"391\",\"name\":\"XPress Wallet\"},{\"code\":\"964\",\"name\":\"Yello Digital Services\"},{\"code\":\"057\",\"name\":\"Zenith Bank\"},{\"code\":\"090504\",\"name\":\"Zikora Microfinance Bank\"},{\"code\":\"792\",\"name\":\"ZWallet\"}]}}', '2026-01-15 22:09:15');

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

--
-- Table structure for table `bellmfb_accounts`
--

CREATE TABLE `bellmfb_accounts` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `acc_no` varchar(20) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `account_reference` varchar(255) NOT NULL,
  `bvn` varchar(20) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `beneficiaries`
--

CREATE TABLE `beneficiaries` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `account_name` varchar(255) NOT NULL,
  `account_number` varchar(10) NOT NULL,
  `bank_code` varchar(10) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `bvn_services`
--

CREATE TABLE `bvn_services` (
  `id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `requirements` text NOT NULL,
  `is_agent_only` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bvn_services`
--

INSERT INTO `bvn_services` (`id`, `service_name`, `description`, `price`, `requirements`, `is_agent_only`, `is_active`, `created_at`) VALUES
(1, 'Print BVN slip', 'Print your BVN information slip', 1000.00, '1. Valid ID\n2. BVN number', 0, 1, '2025-07-29 14:57:49'),
(2, 'BVN retrieval with date of birth', 'Retrieve your BVN using your date of birth', 3000.00, '1. Valid ID\n2. Date of birth', 0, 1, '2025-07-29 14:57:49'),
(3, 'BVN change of name', 'Official name change on your BVN record', 10000.00, '1. Current BVN slip\n2. Valid ID\n3. Sworn affidavit for name change', 1, 1, '2025-07-29 14:57:49'),
(4, 'BVN change of phone number', 'Update phone number associated with your BVN', 10000.00, '1. Current BVN slip\n2. Valid ID', 0, 1, '2025-07-29 14:57:49'),
(5, 'BVN rearrange/correction of name', 'Correct or rearrange names on your BVN', 10000.00, '1. Current BVN slip\n2. Valid ID\n3. Supporting documents', 1, 1, '2025-07-29 14:57:49'),
(6, 'BVN change of date of birth', 'Correct date of birth on BVN record', 10000.00, '1. Current BVN slip\n2. Valid ID\n3. Birth certificate', 0, 1, '2025-07-29 14:57:49');

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

--
-- Table structure for table `bvn_service_orders`
--

CREATE TABLE `bvn_service_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `order_date` timestamp NULL DEFAULT current_timestamp(),
  `status` enum('pending','processing','completed','rejected') DEFAULT 'pending',
  `transaction_ref` varchar(50) NOT NULL,
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `required_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`required_data`)),
  `admin_notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bvn_service_orders`
--

INSERT INTO `bvn_service_orders` (`id`, `user_id`, `service_id`, `order_date`, `status`, `transaction_ref`, `payment_status`, `required_data`, `admin_notes`) VALUES
(1, 0, 1, '2025-08-19 10:35:30', 'pending', 'BVN1755599730481', 'pending', '[\"6346556665644\",\"45452452435\"]', NULL),
(2, 9, 2, '2025-11-28 06:10:12', 'pending', 'BVN1764310212642', 'pending', '[\"nin - 81967348485\",\"11-12-1994\"]', NULL);

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

--
-- Table structure for table `cac_services`
--

CREATE TABLE `cac_services` (
  `id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `agent_price` decimal(10,2) NOT NULL,
  `requirements` text NOT NULL,
  `documents_required` text NOT NULL,
  `is_agent_only` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cac_services`
--

INSERT INTO `cac_services` (`id`, `service_name`, `description`, `price`, `agent_price`, `requirements`, `documents_required`, `is_agent_only`, `is_active`, `created_at`) VALUES
(1, 'Limited Liability Registration', 'Register a limited liability company with CAC', 28000.00, 25000.00, '1. Proposed company name\n2. Nature of business\n3. Registered address\n4. Details of directors/shareholders\n5. Memorandum & Articles of Association', '1. Means of Identification (National ID, Passport, or Driver\'s License)\n2. Passport photograph\n3. Utility bill (not older than 3 months)\n4. Tax Identification Number (TIN)\n5. Signature specimen', 0, 1, '2025-07-29 15:12:17'),
(2, 'Business Name Registration', 'Register a business name with CAC', 22000.00, 20000.00, '1. Proposed business name\n2. Nature of business\n3. Business address\n4. Details of proprietor/partners', '1. Means of Identification (National ID, Passport, or Driver\'s License)\n2. Passport photograph\n3. Utility bill (not older than 3 months)', 0, 1, '2025-07-29 15:12:17'),
(3, 'Incorporation of Public Limited Company', 'Register a PLC with CAC', 150000.00, 140000.00, '1. Proposed company name\n2. Nature of business\n3. Registered address\n4. Details of directors/shareholders\n5. Memorandum & Articles of Association\n6. Statement of share capital\n7. Declaration of compliance', '1. Means of Identification for all directors\n2. Passport photographs\n3. Utility bill (not older than 3 months)\n4. Tax Identification Number (TIN)\n5. Signature specimen\n6. Bank reference letter', 1, 1, '2025-07-29 15:12:17');

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

--
-- Table structure for table `cac_service_orders`
--

CREATE TABLE `cac_service_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `order_date` timestamp NULL DEFAULT current_timestamp(),
  `status` enum('pending','processing','completed','rejected') DEFAULT 'pending',
  `transaction_ref` varchar(50) NOT NULL,
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `required_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`required_data`)),
  `uploaded_documents` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`uploaded_documents`)),
  `admin_notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `conversion_rates`
--

CREATE TABLE `conversion_rates` (
  `id` int(11) NOT NULL,
  `network` varchar(50) NOT NULL,
  `rate` decimal(5,2) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `conversion_rates`
--

INSERT INTO `conversion_rates` (`id`, `network`, `rate`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'MTN', 80.00, 1, '2025-10-02 19:18:26', '2025-10-02 19:18:26'),
(2, 'Airtel', 80.00, 1, '2025-10-02 19:18:26', '2025-10-02 19:18:26'),
(3, 'Glo', 80.00, 1, '2025-10-02 19:18:26', '2025-10-02 19:18:26'),
(4, '9Mobile', 90.00, 1, '2025-10-02 19:18:26', '2025-10-02 19:58:36');

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

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

CREATE TABLE `coupons` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `expiry_date` datetime NOT NULL,
  `claim_limit` int(11) NOT NULL,
  `claimed_count` int(11) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `coupons` (`id`, `code`, `description`, `amount`, `expiry_date`, `claim_limit`, `claimed_count`, `is_active`, `created_at`) VALUES
(0, 'TEST10', 'WELCOME', 100.00, '2025-10-03 00:00:00', 5, 2, 1, '2025-10-02 19:06:22');

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

--
-- Table structure for table `coupon_claims`
--

CREATE TABLE `coupon_claims` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `claimed_amount` varchar(20) NOT NULL,
  `claimed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupon_claims`
--

INSERT INTO `coupon_claims` (`id`, `user_id`, `coupon_id`, `claimed_amount`, `claimed_at`) VALUES
(23, 'GH552V9JC4', 19, '', '2025-07-08 16:11:17'),
(24, '85JLR49O4I', 0, '100', '2025-10-02 19:35:21'),
(25, 'MGNJG5OD9U', 0, '100', '2025-10-02 19:36:11');

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

--
-- Table structure for table `discount`
--

CREATE TABLE `discount` (
  `id` int(11) NOT NULL,
  `service` varchar(255) NOT NULL,
  `subscriber_percentage` varchar(255) NOT NULL,
  `agent_percentage` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `discount`
--

INSERT INTO `discount` (`id`, `service`, `subscriber_percentage`, `agent_percentage`, `status`) VALUES
(1, 'AIRTIME', '0%', '2%', 'On'),
(2, 'DATA', '0%', '2%', 'On'),
(3, 'CABLE_TV', '0%', '2%', 'On'),
(4, 'ELECTRICITY', '0%', '2%', 'On'),
(5, 'EXAM_PIN', '0%', '2%', 'On');

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

--
-- Table structure for table `edu_orders`
--

CREATE TABLE `edu_orders` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `service_id` int(11) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `requirements` text DEFAULT NULL,
  `status` enum('pending','processing','completed','failed') NOT NULL DEFAULT 'pending',
  `admin_notes` text DEFAULT NULL,
  `admin_file` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `edu_orders`
--

INSERT INTO `edu_orders` (`id`, `user_id`, `service_id`, `reference`, `amount`, `requirements`, `status`, `admin_notes`, `admin_file`, `created_at`, `updated_at`) VALUES
(1, 'MGNJG5OD9U', 1, 'EDU-1757610134-7659', 3800.00, 'Xcc', 'pending', NULL, NULL, '2025-09-11 17:02:14', '2025-09-11 17:02:14'),
(2, 'MGNJG5OD9U', 1, 'EDU-1762540757-4800', 3800.00, '7929u3u3u', 'pending', NULL, NULL, '2025-11-07 18:39:17', '2025-11-07 18:39:17');

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

--
-- Table structure for table `edu_services`
--

CREATE TABLE `edu_services` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `description` text NOT NULL,
  `requirements` text NOT NULL,
  `logo` varchar(255) DEFAULT 'fa-graduation-cap',
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `edu_services`
--

INSERT INTO `edu_services` (`id`, `name`, `price`, `description`, `requirements`, `logo`, `is_active`, `created_at`) VALUES
(1, 'WAEC Scratch Card', 3800.00, 'Official WAEC scratch card for checking results', 'WAEC exam number and year', 'fa-certificate', 1, '2025-07-29 01:42:28'),
(2, 'NECO Scratch Card', 1500.00, 'Official NECO scratch card for checking results', 'NECO exam number and year', 'fa-certificate', 1, '2025-07-29 01:42:28'),
(3, 'NABTEB Scratch Card', 1300.00, 'Official NABTEB scratch card for checking results', 'NABTEB exam number and year', 'fa-certificate', 1, '2025-07-29 01:42:28'),
(4, 'NBAIS Scratch Card', 1800.00, 'Official NBAIS scratch card for checking results', 'NBAIS exam number and year', 'fa-certificate', 1, '2025-07-29 01:42:28'),
(5, 'WAEC Verification Pin', 4000.00, 'Official WAEC verification pin for institutions', 'Candidate details and WAEC exam information', 'fa-check-circle', 1, '2025-07-29 01:42:28'),
(6, 'NECO e-Verify Token', 6000.00, 'Online NECO verification token for institutions', 'Candidate details and NECO exam information', 'fa-check-circle', 1, '2025-07-29 01:42:28'),
(7, 'JAMB e-Pin (Direct Entry)', 6000.00, 'JAMB Direct Entry registration e-Pin', 'Candidate personal and academic details', 'fa-ticket-alt', 1, '2025-07-29 01:42:28'),
(8, 'JAMB O\'level Result Upload', 800.00, 'Upload O\'level results to JAMB portal', 'Scanned copy of O\'level results', 'fa-upload', 1, '2025-07-29 01:42:28'),
(9, 'JAMB Original Result Printing', 2500.00, 'Print original JAMB result slip', 'JAMB registration number', 'fa-print', 1, '2025-07-29 01:42:28'),
(10, 'JAMB Admission Letter Printing', 2000.00, 'Print JAMB admission letter', 'JAMB registration number and admission status', 'fa-file-alt', 1, '2025-07-29 01:42:28'),
(11, 'JAMB Reprinting', 800.00, 'Reprint JAMB result slip or admission letter', 'JAMB registration number', 'fa-redo', 1, '2025-07-29 01:42:28'),
(12, 'Check JAMB Admission Status', 800.00, 'Check and confirm JAMB admission status', 'JAMB registration number', 'fa-search', 1, '2025-07-29 01:42:28'),
(13, 'JAMB O\'level Result Screenshot', 800.00, 'Screenshot of O\'level results on JAMB portal', 'JAMB registration number', 'fa-camera', 1, '2025-07-29 01:42:28'),
(14, 'JAMB Profile Code Retrieval', 1000.00, 'Retrieve lost JAMB profile code', 'Registered email or phone number', 'fa-key', 1, '2025-07-29 01:42:28'),
(15, 'JAMB Registration Number Retrieval', 1000.00, 'Retrieve lost JAMB registration number', 'Profile code or registered details', 'fa-id-card', 1, '2025-07-29 01:42:28'),
(16, 'JAMB CAPS Link', 800.00, 'Access to JAMB CAPS for admission processing', 'JAMB registration number', 'fa-link', 1, '2025-07-29 01:42:28');

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

--
-- Table structure for table `lisense`
--

CREATE TABLE `lisense` (
  `id` int(11) NOT NULL,
  `lisense_id` varchar(255) NOT NULL,
  `domain` varchar(255) NOT NULL,
  `lisense_key` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `lisense`
--

INSERT INTO `lisense` (`id`, `lisense_id`, `domain`, `lisense_key`, `status`, `date`) VALUES
(1, '267368', 'localhost:3000', 'key_162629727_626372737', 'verified', 'Thur, 10-Mar-2024');

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

--
-- Table structure for table `locked_withdrawals`
--

CREATE TABLE `locked_withdrawals` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `withdrawal_amount` decimal(10,2) NOT NULL,
  `penalty_fee` decimal(10,2) NOT NULL,
  `net_amount` decimal(10,2) NOT NULL,
  `is_early_withdrawal` tinyint(1) DEFAULT 0,
  `withdrawal_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `locked_withdrawals`
--

INSERT INTO `locked_withdrawals` (`id`, `user_id`, `plan_id`, `withdrawal_amount`, `penalty_fee`, `net_amount`, `is_early_withdrawal`, `withdrawal_date`) VALUES
(1, '85JLR49O4I', 2, 500.00, 250.00, 250.00, 1, '2025-11-05 17:40:45');

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

--
-- Table structure for table `lock_plan`
--

CREATE TABLE `lock_plan` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `lock_type` varchar(255) NOT NULL,
  `lock_name` varchar(255) NOT NULL,
  `lock_description` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `status` varchar(100) NOT NULL,
  `date_start` varchar(100) NOT NULL,
  `date_end` varchar(100) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `msg` text NOT NULL,
  `sender` varchar(255) NOT NULL,
  `reciever` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `network_numbers`
--

CREATE TABLE `network_numbers` (
  `id` int(11) NOT NULL,
  `network` varchar(50) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `network_numbers`
--

INSERT INTO `network_numbers` (`id`, `network`, `phone_number`, `is_active`, `created_at`) VALUES
(1, 'MTN', '08012345678', 1, '2025-10-02 19:18:26'),
(2, 'Airtel', '08022345678', 1, '2025-10-02 19:18:26'),
(3, 'Glo', '08032345678', 1, '2025-10-02 19:18:26'),
(4, '9Mobile', '08042345676', 1, '2025-10-02 19:18:26');

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

--
-- Table structure for table `nin_services`
--

CREATE TABLE `nin_services` (
  `id` int(11) NOT NULL,
  `service_name` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `requirements` text NOT NULL,
  `is_agent_only` tinyint(1) DEFAULT 0,
  `is_active` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nin_services`
--

INSERT INTO `nin_services` (`id`, `service_name`, `description`, `price`, `requirements`, `is_agent_only`, `is_active`, `created_at`) VALUES
(1, 'Change of name', 'Official name change on your NIN record', 8500.00, '1. Current NIN slip\n2. Valid ID\n3. Sworn affidavit for name change', 1, 1, '2025-07-29 13:43:11'),
(2, 'Change of phone number', 'Update phone number associated with your NIN', 8500.00, '1. Current NIN slip\n2. Valid ID', 0, 1, '2025-07-29 13:43:11'),
(3, 'Change of address', 'Update residential address on your NIN record', 8600.00, '1. Current NIN slip\n2. Valid ID\n3. Utility bill as proof of address', 1, 1, '2025-07-29 13:43:11'),
(4, 'Premium NIN slip creation', 'Create a premium NIN slip', 1000.00, '1. Existing NIN number', 0, 1, '2025-07-29 13:43:11'),
(5, 'Premium NIN slip printing (PVC)', 'Print your NIN on PVC card', 5000.00, '1. Existing NIN number\n2. Confirmation of details', 0, 1, '2025-07-29 13:43:11'),
(6, 'Premium NIN slip delivery', 'Get your PVC NIN card delivered ', 7000.00, '1. Existing NIN number\r\n2. Valid delivery address (LAGOS STATE ONLY)\r\n3. Phone Number 1\r\n4. Phone Number 2 (Optional)', 0, 1, '2025-07-29 13:43:11'),
(7, 'Change of date of birth', 'Correct date of birth on NIN record (Adult)', 30000.00, '1. Current NIN slip\n2. Valid ID\n3. Birth certificate or sworn affidavit', 1, 1, '2025-07-29 13:43:11'),
(8, 'Change of date of birth (Minor)', 'Correct date of birth for children (6-10 years)', 60000.00, '1. Current NIN slip\n2. Birth certificate\n3. Parent/guardian ID', 1, 1, '2025-07-29 13:43:11');

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

--
-- Table structure for table `nin_service_orders`
--

CREATE TABLE `nin_service_orders` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
  `order_date` timestamp NULL DEFAULT current_timestamp(),
  `status` enum('pending','processing','completed','rejected') DEFAULT 'pending',
  `transaction_ref` varchar(50) NOT NULL,
  `payment_status` enum('pending','paid','failed') DEFAULT 'pending',
  `required_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`required_data`)),
  `admin_notes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nin_service_orders`
--

INSERT INTO `nin_service_orders` (`id`, `user_id`, `service_id`, `order_date`, `status`, `transaction_ref`, `payment_status`, `required_data`, `admin_notes`) VALUES
(1, 0, 8, '2025-08-07 20:40:57', 'pending', 'NIN1754599257309', 'pending', '[\"45534224523\",\"jgjf 434 34\",\"f34134134\"]', NULL),
(2, 0, 4, '2025-10-07 16:59:59', 'pending', 'NIN1759856399103', 'pending', '[\"92469468459\"]', NULL);

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

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int(11) NOT NULL,
  `header` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `no_type` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` (`id`, `header`, `message`, `image`, `no_type`, `date`, `status`) VALUES
(27, 'Welcome To Digiflex', 'In line with CBN regulations, virtual account numbers will not be generated unless KYC requirements are met. Please complete your KYC to enjoy our full services. \r\nKindly note that Digiflex will not call you or text you requesting for your NIN and BVN', '', 'normal', '', 'Off');

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

--
-- Table structure for table `paga_pluzz`
--

CREATE TABLE `paga_pluzz` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `account_reference` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `paga_pluzz`
--

INSERT INTO `paga_pluzz` (`id`, `unique_id`, `email`, `acc_name`, `acc_no`, `bank_name`, `account_reference`, `created_at`) VALUES
(14, 'MGNJG5OD9U', 'digiflexnigeria@gmail.com', 'Abraham Aotech', '0101223681', 'Paga', '07076362542A5BE1HJL95', '2025-09-24 14:06:53'),
(15, 'HNWL5MBA34', 'annaleona00@gmail.com', 'Mustapha Digiflex', '0345562188', 'Paga', '09035741544A5BE1HJL95', '2025-10-08 21:54:15'),
(16, 'F9J1BJ1PN4', 'sanusiabdulhamid2023@gmail.com', 'Abdulhamid Digiflex', '2407501058', 'Paga', '09024096641A5BE1HJL95', '2025-10-18 09:01:01'),
(17, '85JLR49O4I', 'Chigekwuchibuike@gmail.com', 'Gamaliel Digiflex', '3199957272', 'Paga', '07062669291A5BE1HJL95', '2025-10-24 13:41:33'),
(18, 'MSI5OEGT5H', 'IAMDONELI234@GMAIL.COM', 'Abraham Digiflex', '0954484428', 'Paga', '07076362544A5BE1HJL95', '2025-10-27 13:53:41'),
(19, 'MJIK3JZG4G', 'ahmedndawoba01@gmail.com', 'Abubakar Digiflex', '3088474833', 'Paga', '08068112413A5BE1HJL95', '2025-11-12 02:09:14'),
(20, '5YV68TALRG', 'rolandgoodness707@gmail.com', 'Nura Digiflex', '1309470123', 'Paga', '08032323232A5BE1HJL95', '2025-11-26 09:09:57'),
(21, 'AV4CSBOPZE', 'balaabu033@gmail.com', 'Gambari Digiflex', '2894230411', 'Paga', '08036936936A5BE1HJL95', '2025-11-26 09:34:51'),
(22, '8LRQ45HBJ9', 'sundayoladipupo272@gmail.com', 'sunday Digiflex', '3627667887', 'Paga', '08125192356A5BE1HJL95', '2026-01-15 22:27:36');

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

--
-- Table structure for table `pluzzpay_transfers`
--

CREATE TABLE `pluzzpay_transfers` (
  `id` int(11) NOT NULL,
  `client_reference` varchar(255) DEFAULT NULL,
  `pluzz_reference` varchar(255) DEFAULT NULL,
  `account_number` varchar(20) DEFAULT NULL,
  `account_name` varchar(255) DEFAULT NULL,
  `bank_code` varchar(50) DEFAULT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `narration` varchar(255) DEFAULT NULL,
  `status` varchar(50) DEFAULT 'pending',
  `meta` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `referral`
--

CREATE TABLE `referral` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `bonus` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `referral`
--

INSERT INTO `referral` (`id`, `unique_id`, `user_id`, `bonus`, `date`) VALUES
(2, 'VA3DY6TQBZ', 'FJJU6B8QIB', '50', 'Mon 07-Oct-2024 04:09:59 pm'),
(5, '6L4B6NHFET', 'AK36X5DGUC', '50', 'Wed 06-Nov-2024 01:48:56 am'),
(9, '6L4B6NHFET', 'CLVHAIU826', '50', 'Wed 06-Nov-2024 01:01:46 pm'),
(10, '92X0H9QDSG', 'N5AL3OJ4BL', '50', 'Thu 07-Nov-2024 12:45:14 am'),
(11, '3LDN9LU075', 'B4M8DGFG30', '50', 'Mon 11-Nov-2024 05:10:49 pm');

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

--
-- Table structure for table `savings_plans`
--

CREATE TABLE `savings_plans` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `plan_type` enum('regular','locked') NOT NULL,
  `plan_name` varchar(100) NOT NULL,
  `target_amount` decimal(10,2) NOT NULL,
  `current_amount` decimal(10,2) DEFAULT 0.00,
  `frequency` enum('daily','weekly','monthly') DEFAULT NULL,
  `auto_debit_amount` decimal(10,2) DEFAULT NULL,
  `lock_period` int(11) DEFAULT NULL,
  `interest_rate` decimal(5,2) DEFAULT 0.00,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `next_debit_date` datetime DEFAULT NULL,
  `status` enum('active','completed','cancelled') DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `savings_plans`
--

INSERT INTO `savings_plans` (`id`, `user_id`, `plan_type`, `plan_name`, `target_amount`, `current_amount`, `frequency`, `auto_debit_amount`, `lock_period`, `interest_rate`, `start_date`, `end_date`, `next_debit_date`, `status`, `created_at`) VALUES
(1, '85JLR49O4I', 'regular', 'testing', 200.00, 0.00, 'daily', 100.00, NULL, 0.00, '2025-11-05 17:38:28', NULL, '2025-11-06 17:38:28', 'active', '2025-11-05 17:38:28'),
(2, '85JLR49O4I', 'locked', 'teesting', 500.00, 0.00, NULL, NULL, 3, 0.00, '2025-11-05 17:39:08', '2026-02-05 17:39:08', NULL, 'completed', '2025-11-05 17:39:08');

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

--
-- Table structure for table `savings_transactions`
--

CREATE TABLE `savings_transactions` (
  `id` int(11) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `plan_id` int(11) NOT NULL,
  `transaction_type` enum('deposit','withdrawal','interest','penalty') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `description` text DEFAULT NULL,
  `penalty_fee` decimal(10,2) DEFAULT 0.00,
  `net_amount` decimal(10,2) NOT NULL,
  `transaction_date` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `savings_transactions`
--

INSERT INTO `savings_transactions` (`id`, `user_id`, `plan_id`, `transaction_type`, `amount`, `description`, `penalty_fee`, `net_amount`, `transaction_date`) VALUES
(1, '85JLR49O4I', 2, 'deposit', 500.00, 'Initial locked savings deposit', 0.00, 500.00, '2025-11-05 17:39:08'),
(2, '85JLR49O4I', 2, 'withdrawal', 500.00, 'Early withdrawal with 50% penalty', 250.00, 250.00, '2025-11-05 17:40:45');

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `id` int(11) NOT NULL,
  `service_type` varchar(255) NOT NULL,
  `service_name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`id`, `service_type`, `service_name`, `status`) VALUES
(1, 'Transactional', 'AIRTIME', 'On'),
(2, 'Transactional', 'DATA', 'On'),
(3, 'Transactional', 'AIRTIME_PIN', 'On'),
(4, 'Transactional', 'DATA_PIN', 'On'),
(5, 'Transactional', 'CABLE_TV', 'On'),
(6, 'Transactional', 'ELECTRICITY', 'On'),
(7, 'Transactional', 'EXAM_PIN', 'On'),
(8, 'Transactional', 'BETTING', 'On'),
(9, 'Transactional', 'FUND_LOCK', 'On'),
(10, 'Others', 'LOGIN', 'On'),
(11, 'Others', 'SIGNUP', 'On'),
(12, 'Others', 'GENERATE_ACCOUNT', 'On'),
(13, 'Others', 'TWO_FACTOR', 'On');

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

--
-- Table structure for table `service_details`
--

CREATE TABLE `service_details` (
  `id` int(11) NOT NULL,
  `service_id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `plan` varchar(255) NOT NULL,
  `service` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `validity` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service_details`
--

INSERT INTO `service_details` (`id`, `service_id`, `name`, `plan`, `service`, `amount`, `validity`, `status`) VALUES
(1, '528', 'SME', '500MB', 'MTN', '500', '7 Days', 'On'),
(2, '166', 'SME', '1.5GB', 'MTN', '1000', '7 Days', 'On'),
(3, '167', 'SME', '2GB', 'MTN', '1550', '30 Days', 'On'),
(4, '355', 'SME', '3GB', 'MTN', '2350', '30 Days', 'On'),
(5, '356', 'SME', '5GB', 'MTN', '3850', '30 Days', 'On'),
(6, '539', 'SME', '10GB', 'MTN', '5000', '30 Days', 'On'),
(7, '786', 'MTN AWOOF ', '200MB', 'MTN', '220', '1 Days', 'On'),
(8, '291', 'GIFTING', '1GB', 'MTN', '500', '1 Days', 'Off'),
(9, '221', 'GIFTING', '2GB', 'MTN', '1500', '30 Days', 'Off'),
(10, '233', 'GIFTING', '1GB', 'MTN', '900', '7 Days', 'Off'),
(11, '593', 'GIFTING', '7GB', 'MTN', '3500', '30 Days', 'Off'),
(16, '155', 'CORPORATE', '500MB', 'MTN', '145', '30 Days', 'On'),
(17, '156', 'CORPORATE', '1GB', 'MTN', '305', '30 Days', 'On'),
(18, '157', 'CORPORATE', '2GB', 'MTN', '610', '30 Days', 'On'),
(19, '158', 'CORPORATE', '3GB', 'MTN', '915', '30 Days', 'On'),
(20, '159', 'CORPORATE', '5GB', 'MTN', '1525', '30 Days', 'On'),
(21, '160', 'CORPORATE', '10GB', 'MTN', '3050', '30 Days', 'On'),
(33, '334', 'CORPORATE', '1GB', 'GLO', '345', '30 Days', 'On'),
(34, '332', 'CORPORATE', '2GB', 'GLO', '690', '30 Days', 'On'),
(35, '336', 'CORPORATE', '3GB', 'GLO', '1005', '30 Days', 'On'),
(36, '329', 'CORPORATE', '5GB', 'GLO', '1675', '30 Days', 'On'),
(37, '335', 'CORPORATE', '10GB', 'GLO', '3350', '30 Days', 'On'),
(65, '266', 'CORPORATE', '500MB', 'AIRTEL', '327', '30 Days', 'On'),
(66, '267', 'CORPORATE', '1GB', 'AIRTEL', '625', '30 Days', 'On'),
(67, '268', 'CORPORATE', '2GB', 'AIRTEL', '1250', '30 Days', 'On'),
(69, '269', 'CORPORATE', '5GB', 'AIRTEL', '3125', '30 Days', 'On'),
(70, '273', 'CORPORATE', '10GB', 'AIRTEL', '6250', '30 Days', 'On'),
(71, '265', 'CORPORATE', '300MB', 'AIRTEL', '200', '7 Days', 'Off'),
(74, '8', 'GOtv Smallie-monthly', '', 'GOtv', '1600', '30 Days', 'On'),
(75, '7', 'Jinja', '', 'GOtv', '3325', '30 Days', 'On'),
(76, '6', 'Jolli', '', 'GOtv', '4900', '30 Days', 'On'),
(77, '5', 'Max', '', 'GOtv', '7250', '30 Days', 'On'),
(78, '12', 'Supa-monthly', '', 'GOtv', '9650', '30 Days', 'On'),
(79, '9', 'Smallie-quarterly', '', 'GOtv', '4220', '90 Days', 'On'),
(80, '10', 'Smallie-yearly', '', 'GOtv', '12350', '365 Days', 'On'),
(81, '11', 'Supa-monthly', '', 'GOtv', '9650', '30 Days', 'On'),
(82, '46', 'Padi + ExtraView', '', 'DStv', '8650', '30 Days', 'On'),
(83, '45', 'Yanga + ExtraView', '', 'DStv', '10150', '30 Days', 'On'),
(84, '44', 'Confam + ExtraView', '', 'DStv', '14350', '30 Days', 'On'),
(85, '47', 'Compact + Asia', '', 'DStv', '28150', '30 Days', 'On'),
(86, '38', 'Compact', '', 'DStv', '15750', '30 Days', 'On'),
(87, '39', 'Premium', '', 'DStv', '37050', '30 Days', 'On'),
(88, '36', 'Yanga', '', 'DStv', '5150', '30 Days', 'On'),
(89, '14', 'Nova (Dish)', '', 'Startimes', '1750', '30 Days', 'On'),
(90, '15', 'Basic (Antenna)', '', 'Startimes', '3350', '30 Days', 'On'),
(91, '16', 'Smart (Dish)', '', 'Startimes', '4250', '30 Days', 'On'),
(92, '17', 'Classic (Antenna)', '', 'Startimes', '5050', '30 Days', 'On'),
(93, '18', 'Super (Dish)', '', 'Startimes', '8250', '30 Days', 'On'),
(94, '20', 'Basic (Antenna)', '', 'Startimes', '1150', '7 Days', 'On'),
(95, '19', 'Nova (Antenna)', '', 'Startimes', '525', '7 Days', 'On'),
(100, '12', 'Gotv Supa Plus-monthly', '  ', 'Gotv', '15750', '30DAYS', 'On'),
(102, '478', 'SME', 'You won&amp;#39;t receive the data', 'Please don&amp;#39;t buy Airtel SME if you are owning Airtel ', '', 'companyaotech@gmail.com', 'On'),
(103, '638', 'SME', '1GB', 'AIRTEL', '355', '1 Days', 'On'),
(104, '481', 'SME', '3GB', 'Don&amp;#39;t buy AIRTEL', '', ' If you are owning Airtel ', 'On'),
(105, '622', 'SME', '5GB', 'AIRTEL', '1500', '2 Days', 'On'),
(106, '611', 'SME', '2GB', 'AIRTEL', '550', '2 Days', 'On'),
(107, '481', 'SME', '3GB', 'AIRTEL', '990', '2 Days', 'On'),
(109, '495', 'GIFTING', '1GB', 'AIRTEL', '275', '7 Days', 'On'),
(110, '521', 'GIFTING', '2.5GB', 'AIRTEL', '630', '2 Days', 'On'),
(111, '500', 'GIFTING', '500MB', 'AIRTEL', '185', '14 Days', 'On'),
(112, '496', 'GIFTING', '5GB', 'AIRTEL', '1700', '14 Days', 'On'),
(113, '132', 'GIFTING', '120GB', 'AIRTEL', '18500', '30 Days', 'Off'),
(114, '358', 'SME 2', '500MB', 'MTN', '157', '30 Days', 'On'),
(115, '353', 'SME 2', '1GB', 'MTN', '299', '30 Days', 'On'),
(116, '354', 'SME 2', '2GB', 'MTN', '598', '30 Days', 'On'),
(117, '355', 'SME 2', '3GB', 'MTN', '897', '30 Days', 'On'),
(118, '356', 'SME 2', '5GB', 'MTN', '1495', '30 Days', 'On'),
(119, '357', 'SME 2', '10GB', 'MTN', '2990', '30 Days', 'On'),
(123, '488', 'corporate 2', '15GB', 'MTN', '2470', '7 Days', 'On'),
(124, '472', 'corporate 2', '3.5GB', 'MTN', '620', '2 Days', 'On'),
(125, '486', 'corporate 2', '1GB', 'MTN', '250', '1 Days', 'On'),
(127, '76', 'GIFTING', '1.9GB + 2GB', 'GLO', '950', '30 Days', 'Off'),
(128, '77', 'GIFTING', '3.5GB + 4GB', 'GLO', '1415', '30 Days', 'Off'),
(129, '78', 'GIFTING', '5.2GB + 4GB', 'GLO', '1900', '30 Days', 'Off'),
(130, '81', 'GIFTING', '14GB + 4GB', 'GLO', '3790', '30 Days', 'Off'),
(131, '499', 'SME', '250MB', '9MOBILE', '100', '14 Days', 'On'),
(132, '350', 'SME', '15GB', '9MOBILE', '3480', '30 Days', 'On'),
(134, '349', 'SME', '7GB', '9MOBILE', '1780', '30 Days', 'On'),
(135, '344', 'SME', '500MB', '9MOBILE', '150', '30 Days', 'On'),
(136, '346', 'SME', '3.5GB', '9MOBILE', '920', '30 Days', 'On'),
(138, '1', 'WAEC', '', 'EXAM_PIN', '3400', ' ', 'On'),
(139, '2', 'NECO', '', 'EXAM_PIN', '1135', ' ', 'On'),
(140, '3', 'NABTEB', '', 'EXAM_PIN', '900', '', 'On'),
(141, '321', 'CORPORATE', '500MB', 'GLO', '182', '30DAYS', 'On'),
(143, '75', 'GIFTING', '800MB + 1GB', 'GLO', '470', '30days', 'Off'),
(144, '161', 'SME2', '500MB', 'MTN', '135', '30days', 'On'),
(145, '37', 'Confam', '1', 'Dstv', '9350', '30days', 'On'),
(146, '19', 'Nova (Antenna)', 'O', 'Startimes', '525', '1 week', 'On'),
(147, '19', 'Nova (Antenna)', '', 'Startimes', '525', '1 week', 'On'),
(148, '19', 'Nova (Antenna)', ' ', 'Startimes', '525', '7 days', 'On'),
(149, '19', 'Nova', 'O', 'Startimes', '525', '1 week', 'On'),
(150, '19', 'Nova', '', 'Startimes', '525', '1 week', 'On'),
(151, '585', 'Ffg', ' ', 'Bbbb', '150', '30DAYS', 'On'),
(152, '255', 'NOVA', ' ', 'Startime', '1800', '30DAYS', 'On'),
(153, '19', 'Nova (Antenna)', 's', 'Startimes', '525', '1 week', 'On'),
(154, '130', 'Nova', 's', 'Startimes', '525', '1 week', 'On'),
(155, '19', 'Nova (Antenna)', ' ', 'Startimes', '525', '1 week', 'On'),
(156, '19', 'Nova', ' ', 'Startimes', '525', '1 week', 'On'),
(157, '493', 'SME', '2GB', 'Glo', '500', '2days', 'On'),
(158, '492', 'SME', '1.5GB', 'Glo', '340', '1 days', 'On'),
(159, '629', 'SME', '3.5gb', 'Glo', '1080', '7 days ', 'On'),
(160, '494', 'SME', '10GB', 'Glo', '2000', '7 days', 'On');

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

--
-- Table structure for table `service_id`
--

CREATE TABLE `service_id` (
  `id` int(11) NOT NULL,
  `service` varchar(255) NOT NULL,
  `provider_id` varchar(255) NOT NULL,
  `provider` varchar(255) NOT NULL,
  `ab` varchar(255) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `service_id`
--

INSERT INTO `service_id` (`id`, `service`, `provider_id`, `provider`, `ab`, `status`) VALUES
(1, 'AIRTIME', '1', 'MTN', 'MTN', 'On'),
(2, 'AIRTIME', '3', 'GLO', 'GLO', 'On'),
(3, 'AIRTIME', '4', '9MOBILE', '9MOBILE', 'On'),
(4, 'AIRTIME', '2', 'AIRTEL', 'AIRTEL', 'On'),
(5, 'DATA', '1', 'MTN', 'MTN', 'On'),
(6, 'DATA', '2', 'GLO', 'GLO', 'On'),
(7, 'DATA', '3', '9MOBILE', '9MOBILE', 'On'),
(8, 'DATA', '4', 'AIRTEL', 'AIRTEL', 'On'),
(9, 'ELECTRICITY', '11', 'Abuja Electricity', 'AEDC', 'On'),
(10, 'ELECTRICITY', '7', 'Benin Electricity', 'BENIN', 'On'),
(11, 'ELECTRICITY', '9', 'Eko Electricity', 'EKEDC', 'On'),
(12, 'ELECTRICITY', '3', 'Enegu Electricity', 'ENUGU', 'On'),
(13, 'ELECTRICITY', '1', 'Ibadan Electricity', 'IBEDC', 'On'),
(14, 'ELECTRICITY', '6', 'Ikeja Electricity', 'IE', 'On'),
(15, 'ELECTRICITY', '5', 'Jos Electricity', 'JED', 'On'),
(16, 'ELECTRICITY', '10', 'Kaduna Electricity', 'KEDC', 'On'),
(17, 'ELECTRICITY', '2', 'Kano Electricity', 'KEDCO', 'On'),
(18, 'ELECTRICITY', '8', 'Port Harcourt Electricity', 'PHEDC', 'On'),
(19, 'ELECTRICITY', '12', 'Yola Electricity', 'YOLA', 'On'),
(20, 'AIRTIME_PIN', '1', 'MTN', 'MTN', 'On'),
(21, 'AIRTIME_PIN', '3', 'GLO', 'GLO', 'On'),
(22, 'AIRTIME_PIN', '4', '9MOBILE', '9MOBILE', 'On'),
(23, 'AIRTIME_PIN', '2', 'AIRTEL', 'AIRTEL', 'On'),
(24, 'BETTING', '13', '1xbet', '1xbet', 'On'),
(25, 'BETTING', '12', 'Bangbet', 'Bangbet', 'On'),
(26, 'BETTING', '1', 'Bet9ja', 'Bet9ja', 'On'),
(27, 'BETTING', '4', 'Betking', 'Betking', 'On'),
(28, 'BETTING', '11', 'Betland', 'Betland', 'On'),
(29, 'BETTING', '6', 'Betlion', 'Betlion', 'On'),
(30, 'BETTING', '5', 'Betway', 'Betway', 'On'),
(31, 'BETTING', '7', 'Cloudbet', 'Cloudbet', 'On'),
(32, 'BETTING', '8', 'Livescorebet', 'Livescorebet', 'On'),
(33, 'BETTING', '9', 'Merrybet', 'Merrybet', 'On'),
(34, 'BETTING', '14', 'Naijabet', 'Naijabet', 'On'),
(35, 'BETTING', '3', 'Nairabet', 'Nairabet', 'On'),
(36, 'BETTING', '10', 'Supabet', 'Supabet', 'On'),
(37, 'BETTING', '2', 'Sportybet', 'Sportybet', 'On');

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

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `service_type` varchar(255) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `network` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `old_bal` varchar(255) NOT NULL,
  `new_bal` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `no` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `email_sent` enum('yes','no') NOT NULL DEFAULT 'no'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` (`id`, `unique_id`, `reference`, `type`, `service_type`, `service_id`, `phone`, `network`, `status`, `old_bal`, `new_bal`, `amount`, `no`, `description`, `date`, `email_sent`) VALUES
(2104, '85JLR49O4I', 'DEPONCAFR626YH02472', 'Wallet Topup', NULL, NULL, '07062669291', 'ncwallet', 'success', '410', '605.03', '195.03', '', 'Wallet Funding of NGN 195 at charge of 1.5%. Narration: DATA', 'Sun 13-Apr-2025 05:44 am', 'no'),
(2105, '85JLR49O4I', 'FLP||80139641562782849888||886879632', 'Airtime Pin', NULL, NULL, 'AIRTEL', '*311*PIN#||20741081413098480308', 'success', '605.03', '505.03', '100', '0998664690220934', 'Airtime pin purchase of AIRTEL 1 quantity at amount of 100 for Test', 'Sun 13-Apr-2025 05:48 am', 'no'),
(2106, 'MGNJG5OD9U', 'FLP||48175986865532793996||1389518076', 'Airtime', NULL, NULL, '07071125790', 'MTN', 'success', '510', '410', '100', '', 'Airtime purchase of 100 for 07071125790 at discount of 0%(100)', 'Tue 15-Apr-2025 12:46 pm', 'no'),
(2107, '85JLR49O4I', 'MB||4617299680||1629608091', 'Wallet Topup', NULL, NULL, '07062669291', 'fluterpay', 'success', '505.03', '605.03', '100', '', 'Wallet funding of 110 from Abraham Abasi-don(07071125790) Narraton: ', 'Tue, 15-Apr-2025 02:34 pm', 'no'),
(2108, 'MGNJG5OD9U', 'MB||4617299680||1629608091', 'Transfer', NULL, NULL, '7062669291', 'gamaliel Chigekwu', 'success', '410', '300', '110', '', 'Bank transfer of NGN 110 to gamaliel Chigekwu(7062669291) at charge of NGN 10', 'Tue, 15-Apr-2025 02:34 pm', 'no'),
(2109, 'MGNJG5OD9U', 'FLP||68198895574073188765||716671597', 'Airtime', NULL, NULL, '07076362542', 'MTN', 'success', '10300', '10200', '100', '', 'Airtime purchase of 100 for 07076362542 at discount of 0%(100)', 'Tue 15-Apr-2025 07:06 pm', 'no'),
(2114, '85JLR49O4I', 'MB||7634049659||1171465049', 'Wallet Topup', NULL, NULL, '07062669291', 'fluterpay', 'success', '605.03', '10605.03', '10000', '', 'Wallet funding of 10010 from Abraham Abasi-don(07071125790) Narraton: ', 'Mon, 21-Apr-2025 10:49 am', 'no'),
(2115, 'MGNJG5OD9U', 'MB||7634049659||1171465049', 'Transfer', NULL, NULL, '7062669291', 'gamaliel Chigekwu', 'success', '1010200', '1000190', '10010', '', 'Bank transfer of NGN 10010 to gamaliel Chigekwu(7062669291) at charge of NGN 10', 'Mon, 21-Apr-2025 10:49 am', 'no'),
(2119, '85JLR49O4I', 'SAVC1747265517680', 'savings_cancel', NULL, NULL, '', '', 'success', '1605.0300000000007', '1605.0300000000007', '0', '', 'Cancelled savings plan: Nice', '2025-05-15 02:31:57', 'no'),
(2123, '85JLR49O4I', 'EDU682E7135D61DC', 'education', NULL, NULL, '07062669291', 'education', 'pending', '5829489800', '5829483800', '6000', '', 'Jamb e-pin (direct entry) purchase (Order ID: EDU682E7135D61DC)', '2025-05-22 03:35:02', 'no'),
(2124, '85JLR49O4I', 'EDU682E71595EFD3', 'education', NULL, NULL, '07062669291', 'education', 'pending', '5829483800', '5829459800', '24000', '', 'Jamb e-pin (direct entry) purchase (Order ID: EDU682E71595EFD3)', '2025-05-22 03:35:37', 'no'),
(2125, '85JLR49O4I', 'EDU682E7161A5D26', 'education', NULL, NULL, '07062669291', 'education', 'pending', '5829459800', '5829435800', '24000', '', 'Jamb e-pin (direct entry) purchase (Order ID: EDU682E7161A5D26)', '2025-05-22 03:35:45', 'no'),
(2126, '85JLR49O4I', 'EDU682E7E830E320', 'education', NULL, NULL, '07062669291', 'education', 'pending', '5829435800', '5829423800', '12000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU682E7E830E320)', '2025-05-22 04:31:47', 'no'),
(2127, 'MGNJG5OD9U', 'EDU682F1FA88C7B9', 'manual_educational_services', NULL, NULL, '07071125790', 'education', 'pending', '995190', '989190', '6000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU682F1FA88C7B9)', '2025-05-22 15:59:20', 'no'),
(2128, '85JLR49O4I', 'EDU682F200FE25E1', 'manual_educational_services', NULL, NULL, '07062669291', 'education', 'pending', '5829423800', '5829417800', '6000', '', 'Jamb e-pin (direct entry) purchase (Order ID: EDU682F200FE25E1)', '2025-05-22 16:01:03', 'no'),
(2129, 'MGNJG5OD9U', 'EDU682F202A403E5', 'manual_educational_services', NULL, NULL, '07071125790', 'education', 'pending', '989190', '983190', '6000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU682F202A403E5)', '2025-05-22 16:01:30', 'no'),
(2130, 'MGNJG5OD9U', 'EDU682F204095AB6', 'education', NULL, NULL, '07071125790', 'education', 'pending', '983190', '977190', '6000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU682F204095AB6)', '2025-05-22 16:01:52', 'no'),
(2138, 'MGNJG5OD9U', 'EDU684935693A6ED', 'education', NULL, NULL, '07071125790', 'education', 'pending', '977190', '971190', '6000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU684935693A6ED)', '2025-06-11 10:51:05', 'no'),
(2139, 'MGNJG5OD9U', 'EDU6882C14141488', 'education', NULL, NULL, '07071125790', 'education', 'pending', '1000000', '994000', '6000', '', 'Jamb e-pin (without mock) purchase (Order ID: EDU6882C14141488)', '2025-07-25 02:26:57', 'no'),
(2141, 'MGNJG5OD9U', 'EDU-1757610134-7659', 'education', NULL, NULL, '07071125790', 'edu', 'completed', '994000', '990200', '3800', 'WAEC Scratch Card', 'Payment for WAEC Scratch Card', '2025-09-11 20:02:14', 'no'),
(2142, '85JLR49O4I', 'API-VACT_TRA-0A0F0-0f981b44-83f7-4f97-a3d4-74de16b5e3db', 'Wallet Topup', NULL, NULL, '', 'NOMBA', 'success', '67.00', '1,055.00', '988.00', 'NOMBA||1654579582||1544860509', 'Wallet Funding of NGN 1,000.00 (Settled: NGN 988.00, Fee: NGN 0.00) via ', 'Fri 19-Sep-2025 10:29 pm', 'no'),
(2143, 'MGNJG5OD9U', 'API-VACT_TRA-0A0F0-90cf5cab-5bda-4719-8938-8ef027df0efe', 'Wallet Topup', NULL, NULL, '', 'NOMBA', 'success', '990,200.00', '991,178.00', '978.00', 'NOMBA||8690284668||920109309', 'Wallet Funding of NGN 1,000.00 (Settled: NGN 978.00, Fee: NGN 0.00) via ', 'Sun 21-Sep-2025 12:55 pm', 'no'),
(2144, 'TXN_68f7a931e06c59.11989282', 'API_TRF_68f7a923e65ea_3ec24632', 'transfer', NULL, NULL, '', '', 'success', '655', '520', '100', '', 'Transfer to GAMALIEL CHIBUIKE CHIGEKWU (8100323012) - ', '2025-10-21 18:39:29', 'no'),
(2145, 'TXN_68fb77db40f639.71339599', 'API_TRF_68fb77d791473_fef8bd3f', 'transfer', NULL, NULL, '', '', 'success', '520', '420', '100', '', 'Transfer to GAMALIEL CHIBUIKE CHIGEKWU (8100323012) - ', '2025-10-24 15:58:03', 'no'),
(2146, 'TXN_68fb79cdc34141.67745594', 'API_TRF_68fb79c89d562_87e3b6d8', 'transfer', NULL, NULL, '', '', 'success', '945778', '945678', '100', '', 'Transfer to RICHARD INJI TANZE (7071125790) - ', '2025-10-24 16:06:21', 'no'),
(2147, 'DEBIT_68fb84605940a6.31137515', 'DEBIT_68fb84605940a6.31137515', 'transfer', NULL, NULL, '', '', 'pending', '220.00', '120.00', '100.00', '', 'Transfer debit - processing', '2025-10-24 16:51:28', 'no'),
(2148, 'REFUND_68fb8461a34999.30816405', 'REFUND_68fb8461a34999.30816405', 'transfer', NULL, NULL, '', '', 'refund', '120.00', '220.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-10-24 16:51:29', 'no'),
(2150, 'TXN_68fb84a0369a37.48516498', 'API_TRF_68fb84a16c33e_f2b066e5', 'transfer', NULL, NULL, '', '', 'success', '220.00', '120.00', '100.00', '', 'Transfer to CHIGEKWU   CHIBUIKE GAMALIEL (2027736759) - ', '2025-10-24 16:52:36', 'no'),
(2151, 'DEBIT_68fb89c3ea7502.07515556', 'DEBIT_68fb89c3ea7502.07515556', 'transfer', NULL, NULL, '', '', 'pending', '120.00', '20.00', '100.00', '', 'Transfer debit - processing', '2025-10-24 17:14:27', 'no'),
(2152, 'REFUND_68fb89c499ba67.30216586', 'REFUND_68fb89c499ba67.30216586', 'transfer', NULL, NULL, '', '', 'refund', '20.00', '120.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-10-24 17:14:28', 'no'),
(2154, 'TXN_68fb8acda05216.56554259', 'API_TRF_68fb8acea507d_756e2c97', 'transfer', NULL, NULL, '', '', 'success', '120.00', '20.00', '100.00', '', 'Transfer to Aotech datapluzz  - Gamaliel Digiflex (3199957272) - ', '2025-10-24 17:18:58', 'no'),
(2155, 'DEBIT_68fbc58321b6a5.89734726', 'DEBIT_68fbc58321b6a5.89734726', 'transfer', NULL, NULL, '', '', 'pending', '945678.00', '944678.00', '1000.00', '', 'Transfer debit - processing', '2025-10-24 21:29:23', 'no'),
(2156, 'REFUND_68fbc583997741.33482502', 'REFUND_68fbc583997741.33482502', 'transfer', NULL, NULL, '', '', 'refund', '944678.00', '945678.00', '1000.00', '', 'Transfer failed: HTTP 400', '2025-10-24 21:29:23', 'no'),
(2157, 'DEBIT_68fbc591c98cd2.26875709', 'DEBIT_68fbc591c98cd2.26875709', 'transfer', NULL, NULL, '', '', 'pending', '945678.00', '944778.00', '900.00', '', 'Transfer debit - processing', '2025-10-24 21:29:37', 'no'),
(2158, 'REFUND_68fbc59286a6a1.10350362', 'REFUND_68fbc59286a6a1.10350362', 'transfer', NULL, NULL, '', '', 'refund', '944778.00', '945678.00', '900.00', '', 'Transfer failed: HTTP 400', '2025-10-24 21:29:38', 'no'),
(2159, 'DEBIT_68fbc89440f956.40845482', 'DEBIT_68fbc89440f956.40845482', 'transfer', NULL, NULL, '', '', 'pending', '945678.00', '944678.00', '1000.00', '', 'Transfer debit - processing', '2025-10-24 21:42:28', 'no'),
(2160, 'REFUND_68fbc894a358b3.84131948', 'REFUND_68fbc894a358b3.84131948', 'transfer', NULL, NULL, '', '', 'refund', '944678.00', '945678.00', '1000.00', '', 'Transfer failed: HTTP 400', '2025-10-24 21:42:28', 'no'),
(2161, 'DEBIT_68fbc899849147.73262277', 'DEBIT_68fbc899849147.73262277', 'transfer', NULL, NULL, '', '', 'pending', '945678.00', '944678.00', '1000.00', '', 'Transfer debit - processing', '2025-10-24 21:42:33', 'no'),
(2162, 'REFUND_68fbc89a07e254.45191731', 'REFUND_68fbc89a07e254.45191731', 'transfer', NULL, NULL, '', '', 'refund', '944678.00', '945678.00', '1000.00', '', 'Transfer failed: HTTP 400', '2025-10-24 21:42:34', 'no'),
(2163, 'DEBIT_68fe9019113a44.72506934', 'DEBIT_68fe9019113a44.72506934', 'transfer', NULL, NULL, '', '', 'pending', '945678.00', '944678.00', '1000.00', '', 'Transfer debit - processing', '2025-10-27 00:18:17', 'no'),
(2164, 'REFUND_68fe901975e0c5.29279854', 'REFUND_68fe901975e0c5.29279854', 'transfer', NULL, NULL, '', '', 'refund', '944678.00', '945678.00', '1000.00', '', 'Transfer failed: HTTP 400', '2025-10-27 00:18:17', 'no'),
(2165, 'MGNJG5OD9U', 'EDU-1762540757-4800', 'education', NULL, NULL, '07071125790', 'edu', 'completed', '9456', '5656', '3800', 'WAEC Scratch Card', 'Payment for WAEC Scratch Card', '2025-11-07 21:39:17', 'no'),
(2167, 'TXN_6926c648a0daf4.26504452', 'API_TRF_17641488098804_7453_15e611bd', 'transfer', NULL, NULL, '', '', 'success', '100.00', '0.00', '100.00', '', 'Transfer to MUHAMMAD AUWAL (7071574520) - Vhg', '2025-11-26 12:20:15', 'no'),
(2168, 'DEBIT_6926c8f86a5ca1.84780465', 'DEBIT_6926c8f86a5ca1.84780465', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:31:36', 'no'),
(2169, 'REFUND_6926c8f8cad958.56038057', 'REFUND_6926c8f8cad958.56038057', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:31:36', 'no'),
(2170, 'DEBIT_6926c8fa21c943.62628209', 'DEBIT_6926c8fa21c943.62628209', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:31:38', 'no'),
(2171, 'REFUND_6926c9003ebf38.41505841', 'REFUND_6926c9003ebf38.41505841', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:31:44', 'no'),
(2172, 'DEBIT_6926c9065c0d02.26604710', 'DEBIT_6926c9065c0d02.26604710', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:31:50', 'no'),
(2173, 'REFUND_6926c906bb18c9.54497727', 'REFUND_6926c906bb18c9.54497727', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:31:50', 'no'),
(2174, 'DEBIT_6926c91b474316.61695296', 'DEBIT_6926c91b474316.61695296', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:32:11', 'no'),
(2175, 'REFUND_6926c91ba8b393.05479895', 'REFUND_6926c91ba8b393.05479895', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:32:11', 'no'),
(2176, 'DEBIT_6926c96b44a839.10766200', 'DEBIT_6926c96b44a839.10766200', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:33:31', 'no'),
(2177, 'REFUND_6926c96bc9c6f9.55435702', 'REFUND_6926c96bc9c6f9.55435702', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:33:31', 'no'),
(2178, 'DEBIT_6926c9a16d65a6.88776579', 'DEBIT_6926c9a16d65a6.88776579', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:34:25', 'no'),
(2179, 'REFUND_6926c9a1cd75a4.17840169', 'REFUND_6926c9a1cd75a4.17840169', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:34:25', 'no'),
(2180, 'DEBIT_6926c9cdbec0f2.08395562', 'DEBIT_6926c9cdbec0f2.08395562', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:35:09', 'no'),
(2181, 'REFUND_6926c9ce4749b0.91848835', 'REFUND_6926c9ce4749b0.91848835', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:35:10', 'no'),
(2182, 'DEBIT_6926c9fcb534b2.15530688', 'DEBIT_6926c9fcb534b2.15530688', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:35:56', 'no'),
(2183, 'REFUND_6926c9fd1e11b9.35106690', 'REFUND_6926c9fd1e11b9.35106690', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:35:57', 'no'),
(2184, 'DEBIT_6926ca1de1f793.58238316', 'DEBIT_6926ca1de1f793.58238316', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:36:29', 'no'),
(2185, 'REFUND_6926ca1e4afc05.76244426', 'REFUND_6926ca1e4afc05.76244426', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:36:30', 'no'),
(2186, 'DEBIT_6926ca49612e68.63633350', 'DEBIT_6926ca49612e68.63633350', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-26 12:37:13', 'no'),
(2187, 'REFUND_6926ca49eeab65.54684508', 'REFUND_6926ca49eeab65.54684508', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-26 12:37:13', 'no'),
(2188, 'DEBIT_6928179d1a6b92.65415656', 'DEBIT_6928179d1a6b92.65415656', 'transfer', NULL, NULL, '', '', 'pending', '5656.00', '5556.00', '100.00', '', 'Transfer debit - processing', '2025-11-27 12:19:25', 'no'),
(2189, 'REFUND_6928179f5c3846.04549243', 'REFUND_6928179f5c3846.04549243', 'transfer', NULL, NULL, '', '', 'refund', '5556.00', '5656.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-27 12:19:27', 'no'),
(2190, 'DEBIT_6929f55c9eba76.85110545', 'DEBIT_6929f55c9eba76.85110545', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-28 22:17:48', 'no'),
(2191, 'REFUND_6929f5602ccae1.19882255', 'REFUND_6929f5602ccae1.19882255', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-28 22:17:52', 'no'),
(2192, 'DEBIT_6929f56c0cfa45.92863093', 'DEBIT_6929f56c0cfa45.92863093', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-28 22:18:04', 'no'),
(2193, 'REFUND_6929f56c94e145.76360307', 'REFUND_6929f56c94e145.76360307', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-28 22:18:04', 'no'),
(2194, 'DEBIT_6929f578e8cc61.72541332', 'DEBIT_6929f578e8cc61.72541332', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-28 22:18:16', 'no'),
(2195, 'REFUND_6929f5795d13c0.26776962', 'REFUND_6929f5795d13c0.26776962', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-28 22:18:17', 'no'),
(2196, 'DEBIT_6929f5a55b5449.05398982', 'DEBIT_6929f5a55b5449.05398982', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2025-11-28 22:19:01', 'no'),
(2197, 'REFUND_6929f5a5da7175.42693806', 'REFUND_6929f5a5da7175.42693806', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2025-11-28 22:19:01', 'no'),
(2198, 'DEBIT_696965ebcd9ad2.75194043', 'DEBIT_696965ebcd9ad2.75194043', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2026-01-16 01:10:51', 'no'),
(2199, 'REFUND_696965ec4baf47.40674827', 'REFUND_696965ec4baf47.40674827', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 503', '2026-01-16 01:10:52', 'no'),
(2200, 'DEBIT_696965fded5e30.32923903', 'DEBIT_696965fded5e30.32923903', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2026-01-16 01:11:09', 'no'),
(2201, 'REFUND_696965fe58b1c0.06643168', 'REFUND_696965fe58b1c0.06643168', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 503', '2026-01-16 01:11:10', 'no'),
(2202, 'DEBIT_696a10df1dd3b5.09180964', 'DEBIT_696a10df1dd3b5.09180964', 'transfer', NULL, NULL, '', '', 'pending', '100.00', '0.00', '100.00', '', 'Transfer debit - processing', '2026-01-16 13:20:15', 'no'),
(2203, 'REFUND_696a10df81a3b1.95473383', 'REFUND_696a10df81a3b1.95473383', 'transfer', NULL, NULL, '', '', 'refund', '0.00', '100.00', '100.00', '', 'Transfer failed: HTTP 400', '2026-01-16 13:20:15', 'no');

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

--
-- Table structure for table `verification`
--

CREATE TABLE `verification` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `bvn` varchar(100) NOT NULL,
  `nin` varchar(100) NOT NULL,
  `passport` varchar(255) DEFAULT NULL,
  `utility` varchar(255) NOT NULL,
  `dob` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `verification`
--

INSERT INTO `verification` (`id`, `unique_id`, `email`, `phone`, `bvn`, `nin`, `passport`, `utility`, `dob`) VALUES
(221, '85JLR49O4I', 'Chigekwuchibuike@gmail.com', '', '22332233447', '', NULL, '', '1970-01-01'),
(237, 'MGNJG5OD9U', 'digiflexnigeria@gmail.com', '', '22790801632', '', NULL, '', '2006-05-08'),
(238, 'WUTZH4GGNA', '', '', '', '', NULL, '', NULL),
(239, 'KPM5GAJ1O1', '', '', '', '', NULL, '', NULL),
(240, '7AM0IK4VUG', '', '', '', '', NULL, '', NULL),
(241, 'M1A7361GN9', '', '', '', '', NULL, '', NULL),
(242, 'M0UB32T4QX', '', '', '', '', NULL, '', NULL),
(243, '79MXD6N9GH', 'epin9ja@gmail.com', '', '', '54045587219_verifying', NULL, '', NULL),
(244, 'ST9V151746', '', '', '', '', NULL, '', NULL),
(245, '2M5JP6G0B6', '', '', '', '', NULL, '', NULL),
(246, 'JRM25Z8FGT', '', '', '', '', NULL, '', NULL),
(247, '0J3AUMZID2', '', '', '', '', NULL, '', NULL),
(248, 'YOL1LG4THN', '', '', '', '', NULL, '', NULL),
(249, 'X7J6GYG958', '', '', '', '', NULL, '', NULL),
(250, 'JH659GWM1H', '', '', '', '', NULL, '', NULL),
(251, '7CALJG116G', '', '', '', '', NULL, '', NULL),
(252, 'UCS2G5DRQ8', '', '', '', '', NULL, '', NULL),
(255, '4MVIGBS7GC', '', '', '', '', NULL, '', NULL),
(256, '115LJYGI54', 'kevotips@gmail.com', '', '', '', NULL, '', NULL),
(257, 'V1MG23Y444', '', '', '', '', NULL, '', NULL),
(258, '4SGNTBFBJY', '', '', '', '', NULL, '', NULL),
(259, 'GOF5RML1E8', '', '', '', '', NULL, '', NULL),
(260, 'ZF8XJ5ELH1', '', '', '', '', NULL, '', NULL),
(261, 'NHJ5GC5N80', '', '', '', '', NULL, '', NULL),
(262, '5F476QJAXG', '', '', '', '', NULL, '', NULL),
(263, 'JZT9GA10NQ', '', '', '', '', NULL, '', NULL),
(264, 'G4NDUJB5XJ', '', '', '', '', NULL, '', NULL),
(265, 'ULYFEC8B75', '', '', '', '', NULL, '', NULL),
(266, 'OFU84LQZNG', '', '', '', '', NULL, '', NULL),
(267, 'J8CM4Y3B1M', '', '', '', '', NULL, '', NULL),
(268, 'GJZDKHF155', '', '', '', '', NULL, '', NULL),
(269, '9HJA45ZONB', '', '', '', '', NULL, '', NULL),
(270, 'BGLJL5SXTK', '', '', '', '', NULL, '', NULL),
(271, '8UQNBB4GYI', '', '', '', '', NULL, '', NULL),
(272, 'OBJV10Q6VH', '', '', '', '', NULL, '', NULL),
(274, 'T09J1WHB5Q', '', '', '', '', NULL, '', NULL),
(275, 'H285X11VEG', '', '', '', '', NULL, '', NULL),
(277, 'JA3ESKA24B', '', '', '', '', NULL, '', NULL),
(278, 'OJN98H4L39', '', '', '', '', NULL, '', NULL),
(279, 'DBJNT4YFMJ', '', '', '', '', NULL, '', NULL),
(280, 'WHNVV2JABB', '', '', '', '', NULL, '', NULL),
(281, 'YLE453PG2M', '', '', '', '', NULL, '', NULL),
(282, 'VHJ32A5NJB', '', '', '', '', NULL, '', NULL),
(283, '956Z0HBG8H', '', '', '', '', NULL, '', NULL),
(284, 'WVEC3TBLGM', '', '', '', '', NULL, '', NULL),
(285, 'P69YZ9NW8V', '', '', '', '', NULL, '', NULL),
(286, 'HK4HNH249Z', '', '', '', '', NULL, '', NULL),
(287, 'HNWL5MBA34', '', '', '', '', NULL, '', NULL),
(288, '5VM8915LH4', '', '', '', '', NULL, '', NULL),
(289, '9NW5JEGQ4L', '', '', '', '', NULL, '', NULL),
(290, '5YN4CUT6XQ', '', '', '', '', NULL, '', NULL),
(291, '1YMJVA474T', '', '', '', '', NULL, '', NULL),
(292, 'P85JZHL83Q', '', '', '', '', NULL, '', NULL),
(293, 'H6C6MDO0T1', '', '', '', '', NULL, '', NULL),
(294, 'DJW5TGE5JP', '', '', '', '', NULL, '', NULL),
(295, 'JBNB51I9GM', '', '', '', '', NULL, '', NULL),
(296, 'F9J1BJ1PN4', '', '', '', '', NULL, '', NULL),
(297, 'P6S1X5L4QV', '', '', '', '', NULL, '', NULL),
(298, 'V1EFB4XU0O', '', '', '', '', NULL, '', NULL),
(299, 'MSI5OEGT5H', '', '', '', '', NULL, '', NULL),
(300, 'QEVDMWA8VO', '', '', '', '', NULL, '', NULL),
(301, 'YP46X26ESG', '', '', '', '', NULL, '', NULL),
(302, 'MJIK3JZG4G', '', '', '', '', NULL, '', NULL),
(303, '5YV68TALRG', '', '', '', '', NULL, '', NULL),
(304, 'AV4CSBOPZE', '', '', '', '', NULL, '', NULL),
(305, '9JCY6VG58L', '', '', '', '', NULL, '', NULL),
(306, 'GENJ75HQ0I', '', '', '', '', NULL, '', NULL),
(307, 'I18W2HNCHO', '', '', '', '', NULL, '', NULL),
(308, '96VO5BG9R1', '', '', '', '', NULL, '', NULL),
(309, 'LEAM12U9RG', '', '', '', '', NULL, '', NULL),
(310, '8LRQ45HBJ9', '', '', '', '', NULL, '', NULL),
(311, '7L08Y3J9TA', '', '', '', '', NULL, '', NULL);

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

--
-- Table structure for table `virtual_account`
--

CREATE TABLE `virtual_account` (
  `id` int(11) NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `acc_email` varchar(255) NOT NULL,
  `acc_name` varchar(255) NOT NULL,
  `acc_no` varchar(255) NOT NULL,
  `bank_name` varchar(255) NOT NULL,
  `bank_code` varchar(255) NOT NULL,
  `reference` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `virtual_account`
--

INSERT INTO `virtual_account` (`id`, `unique_id`, `email`, `acc_email`, `acc_name`, `acc_no`, `bank_name`, `bank_code`, `reference`, `date`) VALUES
(0, '4UA7HFAH95', 'shonibareoluwaseun07@gmail.com', 'johndoe@example.com', 'John Doe', '8056736406', 'BANKLY MFB (Ampersand)', '084073', '', 'Mon 07-Oct-2024 05:51 pm'),
(0, '4UA7HFAH95', 'shonibareoluwaseun07@gmail.com', 'johndoe@example.com', 'John Doe', '8056736419', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 07:09 am'),
(0, '4UA7HFAH95', 'shonibareoluwaseun07@gmail.com', 'johndoe@example.com', 'John Doe', '8056736422', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 07:09 am'),
(0, '4UA7HFAH95', 'shonibareoluwaseun07@gmail.com', 'johndoe@example.com', 'John Doe', '8056736435', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 07:10 am'),
(0, 'H5EJMBAS1P', 'support@cidapay.com', 'shonibareoluwaseun07@gmail.com', 'Oluwaseun Shonibare', '8056736448', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 03:11 pm'),
(0, 'H5EJMBAS1P', 'support@cidapay.com', 'shonibareoluwaseun07@gmail.com', 'MB - Oluwaseun Shonibare', '8056736451', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 03:16 pm'),
(0, 'H5EJMBAS1P', 'support@cidapay.com', 'infofluterpay@gmail.com', 'MB - Ibrahim  Abdulrafiu ', '8056736464', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 03:22 pm'),
(0, 'H5EJMBAS1P', 'support@cidapay.com', 'savejee4@gmail.com', 'MB - jhaychob  xavier', '8056736477', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 03:42 pm'),
(0, 'H5EJMBAS1P', 'support@cidapay.com', 'chispenmulticoncept@gmail.com', 'MB - Spencer ifeanyi  Etieh', '8056736480', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 03:43 pm'),
(0, 'HD6CAPVN16', 'oyesoro11@gmail.com', 'shonibareoluwaseun07@gmail.com', 'MB - Oluwaseun Shonibare', '8056736493', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 09:25 pm'),
(0, 'HD6CAPVN16', 'oyesoro11@gmail.com', 'oyesoro11@gmail.com', 'MB - OYEWOLE OYESORO', '8056736503', 'BANKLY MFB (Ampersand)', '084073', '', 'Tue 08-Oct-2024 10:54 pm');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- Indexes for table `banks_cache`
--
ALTER TABLE `banks_cache`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bank_code` (`bank_code`),
  ADD KEY `idx_bank_code` (`bank_code`),
  ADD KEY `idx_last_updated` (`last_updated`);

--
-- Indexes for table `beneficiaries`
--
ALTER TABLE `beneficiaries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_beneficiary` (`user_id`,`account_number`,`bank_code`);

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

--
-- Indexes for table `bvn_service_orders`
--
ALTER TABLE `bvn_service_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_id` (`service_id`);

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

--
-- Indexes for table `cac_service_orders`
--
ALTER TABLE `cac_service_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_id` (`service_id`);

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

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

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

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

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

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

--
-- Indexes for table `locked_withdrawals`
--
ALTER TABLE `locked_withdrawals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_locked_withdrawals_user_id` (`user_id`),
  ADD KEY `idx_locked_withdrawals_plan_id` (`plan_id`);

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

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

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

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

--
-- Indexes for table `nin_service_orders`
--
ALTER TABLE `nin_service_orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `service_id` (`service_id`);

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

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

--
-- Indexes for table `pluzzpay_transfers`
--
ALTER TABLE `pluzzpay_transfers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `client_reference` (`client_reference`),
  ADD KEY `pluzz_reference` (`pluzz_reference`);

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

--
-- Indexes for table `savings_plans`
--
ALTER TABLE `savings_plans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_savings_plans_user_id` (`user_id`),
  ADD KEY `idx_savings_plans_status` (`status`),
  ADD KEY `idx_savings_plans_next_debit_date` (`next_debit_date`);

--
-- Indexes for table `savings_transactions`
--
ALTER TABLE `savings_transactions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_savings_tx_user_id` (`user_id`),
  ADD KEY `idx_savings_tx_plan_id` (`plan_id`),
  ADD KEY `idx_savings_tx_transaction_date` (`transaction_date`);

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

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

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

--
-- Indexes for table `transaction`
--
ALTER TABLE `transaction`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_user_date` (`unique_id`,`date`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `account`
--
ALTER TABLE `account`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=182;

--
-- AUTO_INCREMENT for table `activity`
--
ALTER TABLE `activity`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `adminfund`
--
ALTER TABLE `adminfund`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=217;

--
-- AUTO_INCREMENT for table `airtime_requests`
--
ALTER TABLE `airtime_requests`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `available_types`
--
ALTER TABLE `available_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `banks_cache`
--
ALTER TABLE `banks_cache`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1223;

--
-- AUTO_INCREMENT for table `beneficiaries`
--
ALTER TABLE `beneficiaries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `bvn_services`
--
ALTER TABLE `bvn_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `bvn_service_orders`
--
ALTER TABLE `bvn_service_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `cac_services`
--
ALTER TABLE `cac_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cac_service_orders`
--
ALTER TABLE `cac_service_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `conversion_rates`
--
ALTER TABLE `conversion_rates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `coupon_claims`
--
ALTER TABLE `coupon_claims`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `discount`
--
ALTER TABLE `discount`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `edu_orders`
--
ALTER TABLE `edu_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `edu_services`
--
ALTER TABLE `edu_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `lisense`
--
ALTER TABLE `lisense`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `locked_withdrawals`
--
ALTER TABLE `locked_withdrawals`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `lock_plan`
--
ALTER TABLE `lock_plan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `network_numbers`
--
ALTER TABLE `network_numbers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `nin_services`
--
ALTER TABLE `nin_services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `nin_service_orders`
--
ALTER TABLE `nin_service_orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `paga_pluzz`
--
ALTER TABLE `paga_pluzz`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT for table `pluzzpay_transfers`
--
ALTER TABLE `pluzzpay_transfers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `referral`
--
ALTER TABLE `referral`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `savings_plans`
--
ALTER TABLE `savings_plans`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `savings_transactions`
--
ALTER TABLE `savings_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `service_details`
--
ALTER TABLE `service_details`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;

--
-- AUTO_INCREMENT for table `service_id`
--
ALTER TABLE `service_id`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `transaction`
--
ALTER TABLE `transaction`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2204;

--
-- AUTO_INCREMENT for table `verification`
--
ALTER TABLE `verification`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=312;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bvn_service_orders`
--
ALTER TABLE `bvn_service_orders`
  ADD CONSTRAINT `bvn_service_orders_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `bvn_services` (`id`);

--
-- Constraints for table `cac_service_orders`
--
ALTER TABLE `cac_service_orders`
  ADD CONSTRAINT `cac_service_orders_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `cac_services` (`id`);

--
-- Constraints for table `locked_withdrawals`
--
ALTER TABLE `locked_withdrawals`
  ADD CONSTRAINT `fk_locked_withdrawals_plan_id` FOREIGN KEY (`plan_id`) REFERENCES `savings_plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `nin_service_orders`
--
ALTER TABLE `nin_service_orders`
  ADD CONSTRAINT `nin_service_orders_ibfk_1` FOREIGN KEY (`service_id`) REFERENCES `nin_services` (`id`);

--
-- Constraints for table `savings_transactions`
--
ALTER TABLE `savings_transactions`
  ADD CONSTRAINT `fk_savings_transactions_plan_id` FOREIGN KEY (`plan_id`) REFERENCES `savings_plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

