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

START TRANSACTION;



--
-- Database: `bectelec_fluterupdate`
--

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

--
-- 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;

--
-- Dumping data for table `account`
--

INSERT INTO `account` (`id`, `unique_id`, `email`, `acc_name`, `acc_no`, `bank_name`, `bank_code`, `reference`, `date`) VALUES
(111, 'BF19VI08UL', 'gamalielchigekwu@gmail.com', 'Gamaliel Bectelecom ', '1848590102', 'Paga', '100001', '', 'Mon 21-Jul-2025 03:40 pm'),
(119, 'BF19VI08UL', 'gamalielchigekwu@gmail.com', 'Gamaliel Bectelecom ', '6667801581', 'PalmPay', '100004', '', 'Tue 09-Dec-2025 01:02 pm'),
(120, 'MGRTJHHC1N', 'abdullahidiagbonabdullahi@gmail.com', 'Abdullahi Bectelecom ', '6662185257', 'PalmPay', '100004', '', 'Fri 12-Dec-2025 07:50 am');

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

--
-- Table structure for table `api_network_mapping`
--

CREATE TABLE `api_network_mapping` (
  `id` int(11) NOT NULL,
  `api_service` varchar(50) NOT NULL,
  `network_name` varchar(20) NOT NULL,
  `api_network_id` varchar(50) NOT 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_unicode_ci;

--
-- Dumping data for table `api_network_mapping`
--

INSERT INTO `api_network_mapping` (`id`, `api_service`, `network_name`, `api_network_id`, `created_at`, `updated_at`) VALUES
(1, 'DATA_MTN_2', 'mtn', '1', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(2, 'DATA_GLO_1', 'glo', '2', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(3, 'DATA_AIRTEL_3', 'airtel', '3', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(4, 'DATA_9MOBILE_2', '9mobile', '6', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(5, 'DATA_MTN_1', 'mtn', '1', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(6, 'DATA_GLO_2', 'glo', '2', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(7, 'DATA_AIRTEL_2', 'airtel', '4', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(8, 'DATA_9MOBILE_1', '9mobile', '3', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(9, 'DATA_MTN_3', 'mtn', '1', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(10, 'DATA_GLO_3', 'glo', '2', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(11, 'DATA_AIRTEL_1', 'airtel', '3', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(12, 'DATA_9MOBILE_3', '9mobile', '4', '2025-12-12 12:45:25', '2025-12-12 12:45:25'),
(13, 'AIRTIME_ONE', 'mtn', '1', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(14, 'AIRTIME_ONE', 'glo', '2', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(15, 'AIRTIME_ONE', 'airtel', '3', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(16, 'AIRTIME_ONE', '9mobile', '6', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(17, 'AIRTIME_TWO', 'mtn', '1', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(18, 'AIRTIME_TWO', 'glo', '2', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(19, 'AIRTIME_TWO', 'airtel', '4', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(20, 'AIRTIME_TWO', '9mobile', '3', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(21, 'AIRTIME_THREE', 'mtn', '01', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(22, 'AIRTIME_THREE', 'glo', '02', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(23, 'AIRTIME_THREE', 'airtel', '03', '2025-12-12 16:16:51', '2025-12-12 16:16:51'),
(24, 'AIRTIME_THREE', '9mobile', '04', '2025-12-12 16:16:51', '2025-12-12 16:16:51');

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

--
-- Table structure for table `api_transaction_logs`
--

CREATE TABLE `api_transaction_logs` (
  `id` int(11) NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `user_id` varchar(255) NOT NULL,
  `api_name` varchar(255) NOT NULL,
  `api_url` text DEFAULT NULL,
  `request_data` text DEFAULT NULL,
  `response_data` text DEFAULT NULL,
  `http_code` int(11) DEFAULT NULL,
  `status` enum('success','failed','pending') DEFAULT 'pending',
  `error_message` text DEFAULT NULL,
  `retry_count` int(11) DEFAULT 0,
  `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_unicode_ci;

--
-- Dumping data for table `api_transaction_logs`
--

INSERT INTO `api_transaction_logs` (`id`, `transaction_id`, `user_id`, `api_name`, `api_url`, `request_data`, `response_data`, `http_code`, `status`, `error_message`, `retry_count`, `created_at`, `updated_at`) VALUES
(11, 'Ref||4852889697||791847630', 'BF19VI08UL', 'Gladtidings', 'https://www.gladtidingsdata.com/api/data/', '{\"network\":\"2\",\"mobile_number\":\"09151062120\",\"plan\":\"333\",\"Ported_number\":true}', '{\"id\":159866660,\"ident\":\"Data487c69a90-5e5\",\"network\":2,\"balance_before\":\"2023.75\",\"payment_medium\":\"MAIN WALLET\",\"balance_after\":\"1944.75\",\"mobile_number\":\"09151062120\",\"plan_type\":\"CORPORATE GIFTING\",\"duration\":\"14 days(corporate gifting)\",\"plan\":333,\"client_ip\":\"173.224.122.64\",\"Status\":\"successful\",\"api_response\":\"Dear Customer, You have successfully gifted 09151062120 with 200.0MB of Data. Thank you. Sponsor Balance: 103888.88GB.\",\"plan_network\":\"GLO\",\"plan_name\":\"200MB\",\"plan_amount\":\"79.0\",\"create_date\":\"2025-12-12T14:04:28.962896\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-12 13:04:31', '2025-12-12 13:04:31'),
(12, 'Ref||4786996855||1577170921', 'BF19VI08UL', 'Gladtidings', 'https://www.gladtidingsdata.com/api/data/', '{\"network\":\"2\",\"mobile_number\":\"09151062120\",\"plan\":\"333\",\"Ported_number\":true}', '{\"id\":159867529,\"ident\":\"Data4772c5824-7aa\",\"network\":2,\"balance_before\":\"1944.75\",\"payment_medium\":\"MAIN WALLET\",\"balance_after\":\"1865.75\",\"mobile_number\":\"09151062120\",\"plan_type\":\"CORPORATE GIFTING\",\"duration\":\"14 days(corporate gifting)\",\"plan\":333,\"client_ip\":\"173.224.122.64\",\"Status\":\"successful\",\"api_response\":\"Dear Customer, You have successfully gifted 09151062120 with 200.0MB of Data. Thank you. Sponsor Balance: 103390.56GB.\",\"plan_network\":\"GLO\",\"plan_name\":\"200MB\",\"plan_amount\":\"79.0\",\"create_date\":\"2025-12-12T14:23:08.792346\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-12 13:23:12', '2025-12-12 13:23:12'),
(16, 'Ref||6490834895||816276493', 'BF19VI08UL', 'Gladtidings', 'https://www.gladtidingsdata.com/api/topup/', '{\"network\":\"1\",\"amount\":100,\"mobile_number\":\"08100323012\",\"Ported_number\":true,\"airtime_type\":\"VTU\"}', '{\"id\":4700907,\"airtime_type\":\"VTU\",\"ident\":\"Airtime1b80b6f7e\",\"network\":1,\"paid_amount\":\"97.0\",\"mobile_number\":\"08100323012\",\"amount\":\"100\",\"plan_amount\":\"100\",\"client_ip\":\"173.224.122.64\",\"plan_network\":\"MTN\",\"balance_before\":\"1865.75\",\"api_response\":\"Your top up N100 to 08100323012 is processing.\",\"balance_after\":\"1768.75\",\"Status\":\"pending\",\"create_date\":\"2025-12-12T17:23:02.668345\",\"Ported_number\":true}', 201, 'failed', '', 0, '2025-12-12 16:23:03', '2025-12-12 16:23:03'),
(17, 'Ref||6490834895||816276493', 'BF19VI08UL', 'Gongozconcept', 'https://www.gongozconcept.com/api/topup/', '{\"network\":\"1\",\"amount\":100,\"mobile_number\":\"08100323012\",\"Ported_number\":true,\"airtime_type\":\"VTU\"}', '{\"id\":895762,\"ident\":\"Airtime945a2cddb\",\"airtime_type\":\"VTU\",\"api_response\":\"\",\"network\":1,\"paid_amount\":\"97.0\",\"mobile_number\":\"08100323012\",\"amount\":\"100\",\"plan_amount\":\"100\",\"plan_network\":\"MTN\",\"balance_before\":\"945.5\",\"balance_after\":\"848.5\",\"Status\":\"successful\",\"create_date\":\"2025-12-12T17:23:03.736607+01:00\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-12 16:23:03', '2025-12-12 16:23:03'),
(18, 'Ref||2897775031||1128431136', 'BF19VI08UL', 'Gladtidings', 'https://www.gladtidingsdata.com/api/topup/', '{\"network\":\"1\",\"amount\":100,\"mobile_number\":\"08100323012\",\"Ported_number\":true,\"airtime_type\":\"VTU\"}', '{\"id\":4701079,\"airtime_type\":\"VTU\",\"ident\":\"Airtime103658ae55\",\"network\":1,\"paid_amount\":\"97.0\",\"mobile_number\":\"08100323012\",\"amount\":\"100\",\"plan_amount\":\"100\",\"client_ip\":\"173.224.122.64\",\"plan_network\":\"MTN\",\"balance_before\":\"1768.75\",\"api_response\":\"You have topped up N100.00 to 2348100323012. Your balance is now N180,689.05. ref: 2025121218375230808000175\",\"balance_after\":\"1671.75\",\"Status\":\"successful\",\"create_date\":\"2025-12-12T18:38:00.150873\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-12 17:38:00', '2025-12-12 17:38:00'),
(19, 'Ref||7682359948||117496646', 'BF19VI08UL', 'Gladtidings', 'https://www.gladtidingsdata.com/api/data/', '{\"network\":\"2\",\"mobile_number\":\"09151062120\",\"plan\":\"333\",\"Ported_number\":true}', '{\"id\":159884368,\"ident\":\"Data23f0b969c-a91\",\"network\":2,\"balance_before\":\"1671.75\",\"payment_medium\":\"MAIN WALLET\",\"balance_after\":\"1592.75\",\"mobile_number\":\"09151062120\",\"plan_type\":\"CORPORATE GIFTING\",\"duration\":\"14 days(corporate gifting)\",\"plan\":333,\"client_ip\":\"173.224.122.64\",\"Status\":\"successful\",\"api_response\":\"Dear Customer, You have successfully gifted 09151062120 with 200.0MB of Data. Thank you. Sponsor Balance: 94313.75GB.\",\"plan_network\":\"GLO\",\"plan_name\":\"200MB\",\"plan_amount\":\"79.0\",\"create_date\":\"2025-12-12T18:54:45.881051\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-12 17:54:48', '2025-12-12 17:54:48'),
(20, 'Ref||8590879873||1397725483', 'HJML1G14XG', 'Gladtidings', 'https://www.gladtidingsdata.com/api/topup/', '{\"network\":\"2\",\"amount\":100,\"mobile_number\":\"08059420256\",\"Ported_number\":true,\"airtime_type\":\"VTU\"}', '{\"id\":4706795,\"airtime_type\":\"VTU\",\"ident\":\"Airtime9abcbeceb\",\"network\":2,\"paid_amount\":\"93.5\",\"mobile_number\":\"08059420256\",\"amount\":\"100\",\"plan_amount\":\"100\",\"client_ip\":\"173.224.122.64\",\"plan_network\":\"GLO\",\"balance_before\":\"1592.75\",\"api_response\":\"Transaction Submitted 08059420256 will be recharged shortly\",\"balance_after\":\"1499.25\",\"Status\":\"successful\",\"create_date\":\"2025-12-15T12:27:18.564270\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-15 11:27:18', '2025-12-15 11:27:18'),
(21, 'Ref||8591869608||1703731567', 'HJML1G14XG', 'Gladtidings', 'https://www.gladtidingsdata.com/api/data/', '{\"network\":\"2\",\"mobile_number\":\"08059420256\",\"plan\":\"331\",\"Ported_number\":true}', '{\"id\":160064000,\"ident\":\"DataSHAre9ad2cae74-5fb2\",\"network\":2,\"balance_before\":\"1499.25\",\"payment_medium\":\"MAIN WALLET\",\"balance_after\":\"1301.75\",\"mobile_number\":\"08059420256\",\"plan_type\":\"CORPORATE GIFTING\",\"duration\":\"30 days(corporate gifting)\",\"plan\":331,\"client_ip\":\"173.224.122.64\",\"Status\":\"successful\",\"api_response\":\"Dear Customer, You have successfully gifted 08059420256 with 500.0MB of Data. Thank you. Sponsor Balance: 355597.01GB.\",\"plan_network\":\"GLO\",\"plan_name\":\"500MB\",\"plan_amount\":\"197.5\",\"create_date\":\"2025-12-15T12:29:14.190616\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-15 11:29:19', '2025-12-15 11:29:19'),
(22, 'Ref||5882961438||304335064', 'HJML1G14XG', 'Gladtidings', 'https://www.gladtidingsdata.com/api/data/', '{\"network\":\"2\",\"mobile_number\":\"08059420256\",\"plan\":\"331\",\"Ported_number\":true}', '{\"id\":160064075,\"ident\":\"DataSHAre8682e0e91-457d\",\"network\":2,\"balance_before\":\"1301.75\",\"payment_medium\":\"MAIN WALLET\",\"balance_after\":\"1104.25\",\"mobile_number\":\"08059420256\",\"plan_type\":\"CORPORATE GIFTING\",\"duration\":\"30 days(corporate gifting)\",\"plan\":331,\"client_ip\":\"173.224.122.64\",\"Status\":\"successful\",\"api_response\":\"Dear Customer, You have successfully gifted 08059420256 with 500.0MB of Data. Thank you. Sponsor Balance: 355530.48GB.\",\"plan_network\":\"GLO\",\"plan_name\":\"500MB\",\"plan_amount\":\"197.5\",\"create_date\":\"2025-12-15T12:30:51.212482\",\"Ported_number\":true}', 201, 'success', '', 0, '2025-12-15 11:30:55', '2025-12-15 11:30:55');

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

--
-- Table structure for table `bank_availability`
--

CREATE TABLE `bank_availability` (
  `id` int(11) NOT NULL,
  `bank_code` varchar(20) NOT NULL,
  `bank_name` varchar(100) NOT NULL,
  `provider` varchar(100) NOT NULL,
  `status` enum('On','Off') NOT NULL DEFAULT 'On',
  `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 `bank_availability`
--

INSERT INTO `bank_availability` (`id`, `bank_code`, `bank_name`, `provider`, `status`, `created_at`, `updated_at`) VALUES
(14, '090001', '9psb', 'ncwallet', 'Off', '2025-07-21 13:49:37', '2025-08-21 22:10:39'),
(15, '090002', '9psb', 'payvessel', 'Off', '2025-07-21 13:49:37', '2025-08-21 22:10:41'),
(16, '090003', 'Bell Mfb', 'pluzzpay', 'Off', '2025-07-21 13:49:37', '2025-07-21 14:00:42'),
(17, '090004', 'Bell Mfb', 'whogopay', 'Off', '2025-07-21 13:49:37', '2025-07-21 14:00:35'),
(18, '090005', 'Bell Mfb', 'ncwallet', 'Off', '2025-07-21 13:49:37', '2025-07-21 14:00:22'),
(19, '100001', 'Paga', 'pluzzpay', 'On', '2025-07-21 13:49:37', '2025-07-21 13:49:37'),
(20, '100002', 'Paga', 'strowallet', 'Off', '2025-07-21 13:49:37', '2025-12-09 11:42:59'),
(21, '100003', 'Paga', 'ncwallet', 'Off', '2025-07-21 13:49:37', '2025-07-21 13:59:43'),
(22, '100004', 'Palmpay', 'pluzzpay', 'On', '2025-07-21 13:49:37', '2025-12-09 11:43:18'),
(23, '100005', 'Nomba', 'strowallet', 'Off', '2025-07-21 13:49:37', '2025-07-21 13:59:33'),
(24, '100006', 'Nomba', 'whogopay', 'Off', '2025-07-21 13:49:37', '2025-07-21 13:59:28'),
(25, '100007', 'palmpay', 'pluzzpay', 'Off', '2025-07-21 13:49:37', '2025-07-21 13:59:21'),
(26, '100008', 'palmpay', 'ncwallet', 'Off', '2025-07-21 13:49:37', '2025-07-21 13:59:13');

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

--
-- Table structure for table `banned_numbers`
--

CREATE TABLE `banned_numbers` (
  `id` int(11) NOT NULL,
  `number` varchar(15) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `banned_numbers`
--

INSERT INTO `banned_numbers` (`id`, `number`, `created_at`) VALUES
(1, '1234567890', '2024-12-20 02:38:19'),
(2, '0987654321', '2024-12-20 02:38:19'),
(3, '07036323358', '2024-12-20 02:50:08');

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

--
-- Table structure for table `cashback_settings`
--

CREATE TABLE `cashback_settings` (
  `id` int(11) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `network` varchar(50) DEFAULT NULL,
  `min_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `cashback_type` enum('percentage','fixed') NOT NULL DEFAULT 'percentage',
  `cashback_value` decimal(10,2) NOT NULL,
  `status` enum('active','inactive') DEFAULT 'active',
  `valid_from` date DEFAULT NULL,
  `valid_to` date DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cashback_settings`
--

INSERT INTO `cashback_settings` (`id`, `service_type`, `network`, `min_amount`, `cashback_type`, `cashback_value`, `status`, `valid_from`, `valid_to`, `created_at`) VALUES
(1, 'Airtime', 'MTN', 100.00, 'percentage', 2.00, 'active', NULL, NULL, '2025-08-26 01:54:53'),
(2, 'Airtime', 'GLO', 100.00, 'percentage', 1.50, 'active', NULL, NULL, '2025-08-26 01:54:53'),
(3, 'Airtime', 'AIRTEL', 100.00, 'percentage', 1.80, 'active', NULL, NULL, '2025-08-26 01:54:53'),
(4, 'Airtime', '9MOBILE', 100.00, 'percentage', 1.20, 'active', NULL, NULL, '2025-08-26 01:54:53'),
(5, 'Airtime', NULL, 500.00, 'fixed', 10.00, 'active', NULL, NULL, '2025-08-26 01:54:53');

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

--
-- Table structure for table `charges`
--

CREATE TABLE `charges` (
  `id` int(11) NOT NULL,
  `service` varchar(255) NOT NULL,
  `subscriber` decimal(10,2) NOT NULL,
  `agent` decimal(10,2) NOT NULL,
  `status` enum('On','Off') DEFAULT 'On',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `charges`
--

INSERT INTO `charges` (`id`, `service`, `subscriber`, `agent`, `status`, `created_at`) VALUES
(1, 'Internet Broadband', 5000.00, 4500.00, 'On', '2025-08-21 09:54:04'),
(2, 'Cable TV', 2500.00, 2200.00, 'On', '2025-08-21 09:54:04'),
(3, 'Mobile Data', 1500.00, 1300.00, 'On', '2025-08-21 09:54:04'),
(4, 'Landline', 800.00, 700.00, 'Off', '2025-08-21 09:54:04'),
(5, 'Cloud Storage', 2000.00, 1800.00, 'On', '2025-08-21 09:54:04'),
(6, 'Gaming Subscription', 3000.00, 2700.00, 'Off', '2025-08-21 09:54:04'),
(7, 'VoIP Services', 1200.00, 1000.00, 'On', '2025-08-21 09:54:04'),
(8, 'Home Security', 4000.00, 3600.00, 'On', '2025-08-21 09:54:04');

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

--
-- Table structure for table `data_services`
--

CREATE TABLE `data_services` (
  `id` int(11) NOT NULL,
  `plan_id_one` varchar(255) DEFAULT NULL COMMENT 'ID from API 1',
  `plan_id_two` varchar(255) DEFAULT NULL COMMENT 'ID from API 2',
  `plan_id_three` varchar(255) DEFAULT NULL COMMENT 'ID from API 3',
  `api_id` varchar(255) NOT NULL COMMENT 'ID for other APIs to connect - auto-generated',
  `plan` varchar(255) NOT NULL COMMENT 'e.g., 500MB, 1GB',
  `type` varchar(255) NOT NULL COMMENT 'e.g., sme, corporate, gifting',
  `network` enum('mtn','airtel','glo','9mobile') NOT NULL,
  `amount` decimal(10,2) NOT NULL COMMENT 'Price for users to buy',
  `cost_price` decimal(10,2) NOT NULL COMMENT 'Amount I bought it',
  `vendor_price` decimal(10,2) NOT NULL COMMENT 'Amount vendor account will be charged',
  `validity` varchar(255) NOT NULL COMMENT 'e.g., 1 week, 2 weeks, 1 month',
  `status` enum('active','inactive') DEFAULT 'active',
  `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_unicode_ci;

--
-- Dumping data for table `data_services`
--

INSERT INTO `data_services` (`id`, `plan_id_one`, `plan_id_two`, `plan_id_three`, `api_id`, `plan`, `type`, `network`, `amount`, `cost_price`, `vendor_price`, `validity`, `status`, `created_at`, `updated_at`) VALUES
(622, NULL, '426', '611', '15gb_gifting_1day_96390', '1.5 GB', 'GIFTING', 'airtel', 540.00, 500.00, 500.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(623, NULL, '473', '432', '18gb_gifting_30days_27435', '18 GB', 'GIFTING', 'airtel', 6060.00, 6000.00, 6020.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(624, NULL, '513', '612', '1gb_gifting_3days_94879', '1 GB', 'GIFTING', 'airtel', 340.00, 300.00, 300.00, '3 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(625, NULL, '427', '617', '2gb_gifting_2days_32048', '2 GB', 'GIFTING', 'airtel', 640.00, 600.00, 600.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(626, NULL, '437', '476', '150mb_sme_1day_36336', '150 MB', 'SME', 'airtel', 100.00, 70.00, 70.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(627, NULL, '518', '436', '160gb_gifting_30days_92645', '160 GB', 'GIFTING', 'airtel', 30070.00, 30000.00, 30030.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(628, NULL, '475', '434', '35gb_gifting_30days_23345', '35 GB', 'GIFTING', 'airtel', 10060.00, 10000.00, 10020.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(629, NULL, '560', '478', '600mb_sme_2days_66007', '600 MB', 'SME', 'airtel', 260.00, 220.00, 220.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(630, NULL, '474', '431', '25gb_gifting_30days_50187', '25 GB', 'GIFTING', 'airtel', 8060.00, 8000.00, 8020.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(631, NULL, '472', '430', '13gb_gifting_30days_43478', '13 GB', 'GIFTING', 'airtel', 5050.00, 5000.00, 5010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(632, NULL, '462', '429', '15gb_gifting_7days_30542', '1.5 GB', 'GIFTING', 'airtel', 1040.00, 1000.00, 1000.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(633, NULL, '467', '427', '2gb_gifting_30days_67937', '2 GB', 'GIFTING', 'airtel', 1550.00, 1500.00, 1510.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(634, NULL, '462', '560', '1gb_gifting_7days_89231', '1 GB', 'GIFTING', 'airtel', 1040.00, 1000.00, 1000.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(635, NULL, '429', '556', '32gb_gifting_2days_51580', '3.2 GB', 'GIFTING', 'airtel', 1040.00, 1000.00, 1000.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(636, NULL, '512', '555', '300mb_gifting_1day_98415', '300 MB', 'GIFTING', 'airtel', 340.00, 300.00, 300.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(637, NULL, '519', '545', '210gb_gifting_30days_44056', '210 GB', 'GIFTING', 'airtel', 40070.00, 40000.00, 40030.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(638, NULL, '476', '558', '500mb_gifting_7days_29894', '500 MB', 'GIFTING', 'airtel', 540.00, 500.00, 500.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(639, NULL, '463', '561', '35gb_gifting_7days_92248', '3.5 GB', 'GIFTING', 'airtel', 1550.00, 1500.00, 1510.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(640, NULL, '465', '562', '10gb_gifting_7days_70805', '10 GB', 'GIFTING', 'airtel', 3050.00, 3000.00, 3010.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(641, NULL, '466', '563', '18gb_gifting_7days_77072', '18 GB', 'GIFTING', 'airtel', 5050.00, 5000.00, 5010.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(642, NULL, '468', '527', '3gb_gifting_30days_42344', '3 GB', 'GIFTING', 'airtel', 2050.00, 2000.00, 2010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(643, NULL, '508', '526', '75mb_gifting_1day_76982', '75 MB', 'GIFTING', 'airtel', 105.00, 75.00, 75.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(644, NULL, '517', '568', '100gb_gifting_30days_17718', '100 GB', 'GIFTING', 'airtel', 20060.00, 20000.00, 20020.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(645, NULL, '444', '483', '10gb_sme_30days_76128', '10 GB', 'SME', 'airtel', 3150.00, 3100.00, 3110.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(646, NULL, '429', '481', '3gb_gifting_2days_15569', '3 GB', 'GIFTING', 'airtel', 1040.00, 1000.00, 1000.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(647, NULL, '505', '209', '60gb_gifting_30days_24247', '60 GB', 'GIFTING', 'airtel', 15060.00, 15000.00, 15020.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(648, NULL, '521', '255', '350gb_gifting_30days_15994', '350 GB', 'GIFTING', 'airtel', 60070.00, 60000.00, 60030.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(649, NULL, '464', '241', '6gb_gifting_7days_19882', '6 GB', 'GIFTING', 'airtel', 2550.00, 2500.00, 2510.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(650, NULL, '513', '673', '1_gifting_3days_31873', '1', 'GIFTING', 'airtel', 340.00, 300.00, 300.00, '3 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(651, NULL, '478', '627', '4gb_gifting_30days_58400', '4 GB', 'GIFTING', 'airtel', 2550.00, 2500.00, 2510.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(652, NULL, '505', '677', '60mb_gifting_30days_19702', '60 MB', 'GIFTING', 'airtel', 48420.00, 48350.00, 48380.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(653, NULL, '471', '150', '10gb_gifting_30days_13644', '10 GB', 'GIFTING', 'airtel', 4050.00, 4000.00, 4010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(654, NULL, '470', '149', '8gb_gifting_30days_21861', '8 GB', 'GIFTING', 'airtel', 3050.00, 3000.00, 3010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(655, NULL, '427', '145', '15gb_gifting_2days_25074', '1.5 GB', 'GIFTING', 'airtel', 640.00, 600.00, 600.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(656, NULL, '557', '639', '15gb_sme_1day_83539', '1.5 GB', 'SME', 'airtel', 590.00, 550.00, 550.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(657, '632', '541', NULL, '1gb_corporate_3days_68106', '1 GB', 'CORPORATE', 'glo', 310.00, 270.00, 270.00, '3 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(658, '633', '542', NULL, '3gb_corporate_3days_34314', '3 GB', 'CORPORATE', 'glo', 850.00, 810.00, 810.00, '3 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(659, '634', '543', NULL, '5gb_corporate_3days_53024', '5 GB', 'CORPORATE', 'glo', 1399.00, 1349.00, 1359.00, '3 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(660, '635', '538', NULL, '1gb_corporate_7days_84930', '1 GB', 'CORPORATE', 'glo', 355.00, 315.00, 315.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(661, '636', '539', NULL, '3gb_corporate_7days_36563', '3 GB', 'CORPORATE', 'glo', 980.00, 940.00, 940.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(662, '637', '540', NULL, '5gb_corporate_7days_38872', '5 GB', 'CORPORATE', 'glo', 1620.00, 1570.00, 1580.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(663, '335', '325', NULL, '10gb_corporate_30days_78885', '10 GB', 'CORPORATE', 'glo', 4050.00, 4000.00, 4010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(664, '329', '324', NULL, '5gb_corporate_30days_70760', '5 GB', 'CORPORATE', 'glo', 2050.00, 2000.00, 2010.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(665, '331', '327', NULL, '500mb_corporate_30days_46350', '500 MB', 'CORPORATE', 'glo', 230.00, 200.00, 200.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(666, '332', '322', NULL, '2gb_corporate_30days_65539', '2 GB', 'CORPORATE', 'glo', 840.00, 800.00, 800.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(667, '333', '337', NULL, '200mb_corporate_14days_81863', '200 MB', 'CORPORATE', 'glo', 110.00, 80.00, 80.00, '14 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(668, '334', '321', NULL, '1gb_corporate_30days_46213', '1 GB', 'CORPORATE', 'glo', 440.00, 400.00, 400.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(669, '336', '323', NULL, '3gb_corporate_30days_64605', '3 GB', 'CORPORATE', 'glo', 1250.00, 1200.00, 1210.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(670, '423', '321', NULL, '1tb_corporate_30days_46810', '1 TB', 'CORPORATE', 'glo', 221070.00, 221000.00, 221030.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(671, '12', '252', NULL, '1gb_gifting_14days_79609', '1 GB', 'GIFTING', 'glo', 520.00, 480.00, 480.00, '14 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(672, '784', '323', NULL, '3_corporate_30days_87817', '3', 'CORPORATE', 'glo', 1250.00, 1200.00, 1210.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(673, '783', '321', NULL, '1_corporate_30days_42822', '1', 'CORPORATE', 'glo', 440.00, 400.00, 400.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(674, '491', '394', NULL, '750mb_sme_1day_27568', '750 MB', 'SME', 'glo', 226.00, 196.00, 196.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(675, '492', '395', NULL, '15gb_sme_1day_40156', '1.5 GB', 'SME', 'glo', 330.00, 290.00, 290.00, '1 day', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(676, '493', '396', NULL, '25gb_sme_2days_91845', '2.5 GB', 'SME', 'glo', 518.00, 478.00, 478.00, '2 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(677, '494', '397', NULL, '10gb_sme_7days_14078', '10 GB', 'SME', 'glo', 1952.00, 1902.00, 1912.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(678, '481', '725', NULL, '35gb_special_30days_69044', '3.5 GB', 'SPECIAL', 'mtn', 2500.00, 2450.00, 2460.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(679, '553', '697', NULL, '15gb_special_7days_79839', '1.5 GB', 'SPECIAL', 'mtn', 1020.00, 980.00, 980.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(680, '481', '704', NULL, '27gb_special_30days_85624', '2.7 GB', 'SPECIAL', 'mtn', 2010.00, 1960.00, 1970.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(681, '553', '709', NULL, '1gb_special_7days_35509', '1 GB', 'SPECIAL', 'mtn', 824.00, 784.00, 784.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(682, '485', '711', NULL, '2gb_special_30days_30131', '2 GB', 'SPECIAL', 'mtn', 1520.00, 1470.00, 1480.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(683, '489', '722', NULL, '500mb_special_7days_41483', '500 MB', 'SPECIAL', 'mtn', 530.00, 490.00, 490.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(684, '562', '486', NULL, '1gb_sme_7days_51127', '1 GB', 'SME', 'mtn', 790.00, 750.00, 750.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(685, '340', '419', NULL, '3gb_sme_30days_14126', '3 GB', 'SME', 'mtn', 2690.00, 2640.00, 2650.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(686, '341', '468', NULL, '5gb_sme_30days_17115', '5 GB', 'SME', 'mtn', 4450.00, 4400.00, 4410.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(687, '554', '399', NULL, '12gb_gifting_7days_84871', '1.2 GB', 'GIFTING', 'mtn', 763.75, 723.75, 723.75, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(688, '523', '487', NULL, '35gb_gifting_30days_53171', '3.5 GB', 'GIFTING', 'mtn', 2457.50, 2407.50, 2417.50, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(689, '339', '506', NULL, '2gb_sme_30days_10744', '2 GB', 'SME', 'mtn', 1810.00, 1760.00, 1770.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(690, '523', '518', NULL, '27gb_gifting_30days_82549', '2.7 GB', 'GIFTING', 'mtn', 1980.00, 1930.00, 1940.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(691, '422', '528', NULL, '500mb_sme_7days_92593', '500 MB', 'SME', 'mtn', 540.00, 500.00, 500.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(692, '554', '166', NULL, '15gb_gifting_7days_43522', '1.5 GB', 'GIFTING', 'mtn', 1003.00, 963.00, 963.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(693, '506', '221', NULL, '2gb_gifting_30days_59658', '2 GB', 'GIFTING', 'mtn', 1505.00, 1455.00, 1465.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(694, '554', '233', NULL, '1gb_gifting_7days_49075', '1 GB', 'GIFTING', 'mtn', 812.00, 772.00, 772.00, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(695, '338', '353', NULL, '1gb_sme_30days_46089', '1 GB', 'SME', 'mtn', 920.00, 880.00, 880.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(696, '342', '357', NULL, '10gb_sme_30days_12772', '10 GB', 'SME', 'mtn', 8860.00, 8800.00, 8820.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(697, '389', '602', NULL, '12gb_gifting_30days_95533', '1.2 GB', 'GIFTING', 'mtn', 610.00, 570.00, 570.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(698, '460', '648', NULL, '1gb_special_30days_77607', '1 GB', 'SPECIAL', 'mtn', 780.00, 740.00, 740.00, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(699, '544', '585', NULL, '500mb_gifting_7days_43918', '500 MB', 'GIFTING', 'mtn', 522.50, 482.50, 482.50, '7 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51'),
(700, '506', '589', NULL, '18gb_gifting_30days_95786', '1.8 GB', 'GIFTING', 'mtn', 1497.50, 1447.50, 1457.50, '30 days', 'active', '2025-12-18 14:40:51', '2025-12-18 14:40:51');

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

--
-- 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', '2', '90', 'On'),
(2, 'DATA', '0', '2', 'On'),
(3, 'CABLE_TV', '0', '2', 'On'),
(4, 'ELECTRICITY', '0.1', '3', 'On'),
(5, 'EXAM_PIN', '0', '2', 'On'),
(6, 'BETTING', '0', '2', 'On'),
(7, 'AIRTIME_PIN', '0', '2', 'On');

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

--
-- Table structure for table `lynx_coupon`
--

CREATE TABLE `lynx_coupon` (
  `id` int(11) NOT NULL,
  `code` varchar(50) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `description` text DEFAULT NULL,
  `claim_limit` int(11) NOT NULL DEFAULT 0 COMMENT '0 = unlimited claims',
  `claimed_count` int(11) NOT NULL DEFAULT 0,
  `expiry_date` datetime NOT NULL,
  `status` enum('active','inactive','expired') DEFAULT 'active',
  `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_unicode_ci;

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

--
-- Table structure for table `lynx_coupon_claims`
--

CREATE TABLE `lynx_coupon_claims` (
  `id` int(11) NOT NULL,
  `user_id` varchar(100) NOT NULL COMMENT 'Matches regtable unique_id',
  `coupon_id` int(11) NOT NULL,
  `claimed_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `claim_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- 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
(7, 'Notifications ', 'Welcome to bectelecom.com.ng, your ever reliable bill payment platform. Do contact us on 08144401198 for any enquiry ', '', 'normal', '', 'On');

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

--
-- Table structure for table `payment_gateways`
--

CREATE TABLE `payment_gateways` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `charge_percentage` decimal(5,2) NOT NULL DEFAULT 0.00,
  `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_unicode_ci;

--
-- Dumping data for table `payment_gateways`
--

INSERT INTO `payment_gateways` (`id`, `name`, `charge_percentage`, `created_at`, `updated_at`) VALUES
(1, 'Ncwallet', 0.02, '2024-12-28 23:40:34', '2024-12-28 23:57:54'),
(2, 'Whogopay', 0.00, '2024-12-28 23:40:34', '2024-12-28 23:40:34'),
(3, 'Strowallet', 0.00, '2024-12-28 23:40:34', '2024-12-28 23:40:34'),
(4, 'Payvessel', 0.00, '2024-12-28 23:40:34', '2024-12-28 23:40:34'),
(5, 'Paylony', 0.00, '2024-12-28 23:40:34', '2024-12-28 23:40:34');

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

--
-- Table structure for table `provider_discounts`
--

CREATE TABLE `provider_discounts` (
  `id` int(11) NOT NULL,
  `provider` varchar(50) NOT NULL,
  `service_type` varchar(50) NOT NULL,
  `discount` decimal(5,2) NOT NULL DEFAULT 0.00,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `provider_discounts`
--

INSERT INTO `provider_discounts` (`id`, `provider`, `service_type`, `discount`, `created_at`) VALUES
(1, 'MTN', 'Airtime', 3.50, '2025-11-03 12:32:36'),
(2, 'AIRTEL', 'Airtime', 3.25, '2025-11-03 12:32:36'),
(3, 'GLO', 'Airtime', 4.00, '2025-11-03 12:32:36'),
(4, '9MOBILE', 'Airtime', 4.50, '2025-11-03 12:32:36'),
(5, 'MTN', 'Data', 5.00, '2025-11-03 12:32:36'),
(6, 'AIRTEL', 'Data', 4.75, '2025-11-03 12:32:36'),
(7, 'GLO', 'Data', 6.00, '2025-11-03 12:32:36'),
(8, '9MOBILE', 'Data', 6.50, '2025-11-03 12:32:36'),
(9, 'IKEDC', 'Electricity', 2.00, '2025-11-03 12:32:36'),
(10, 'EKEDC', 'Electricity', 2.25, '2025-11-03 12:32:36'),
(11, 'IBEDC', 'Electricity', 1.75, '2025-11-03 12:32:36'),
(12, 'KEDCO', 'Electricity', 2.50, '2025-11-03 12:32:36'),
(13, 'PHED', 'Electricity', 1.50, '2025-11-03 12:32:36'),
(14, 'BEDC', 'Electricity', 2.00, '2025-11-03 12:32:36'),
(15, 'AEDC', 'Electricity', 1.80, '2025-11-03 12:32:36'),
(16, 'JED', 'Electricity', 2.20, '2025-11-03 12:32:36'),
(17, 'KAEDCO', 'Electricity', 2.10, '2025-11-03 12:32:36'),
(18, 'EEDC', 'Electricity', 1.90, '2025-11-03 12:32:36'),
(19, 'YEDC', 'Electricity', 2.30, '2025-11-03 12:32:36'),
(20, 'DSTV', 'Cable', 7.00, '2025-11-03 12:32:36'),
(21, 'GOTV', 'Cable', 8.50, '2025-11-03 12:32:36'),
(22, 'STARTIMES', 'Cable', 9.00, '2025-11-03 12:32:36'),
(23, 'WAEC', 'Education', 4.00, '2025-11-03 12:32:36'),
(24, 'NECO', 'Education', 4.25, '2025-11-03 12:32:36'),
(25, 'JAMB', 'Education', 3.75, '2025-11-03 12:32:36'),
(26, 'MTN', 'Airtime_Promo', 5.50, '2025-11-03 12:32:36'),
(27, 'AIRTEL', 'Airtime_Promo', 5.25, '2025-11-03 12:32:36'),
(28, 'GLO', 'Data_Promo', 8.00, '2025-11-03 12:32:36'),
(29, '9MOBILE', 'Data_Promo', 9.00, '2025-11-03 12:32:36');

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

--
-- 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,
  `api_amount` varchar(20) NOT NULL,
  `buying_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`, `api_amount`, `buying_amount`, `validity`, `status`) VALUES
(1, '552', 'SME', '500MB', 'MTN', '390', '', '', '7 Days', 'On'),
(2, '526', 'SME', '1GB', 'MTN', '630', '', '', '30 days', 'On'),
(3, '527', 'SME', '2GB', 'MTN', '1260', '', '', '30 Days', 'On'),
(4, '528', 'SME', '3GB', 'MTN', '1890', '', '', '30 Days', 'On'),
(5, '529', 'SME', '5GB', 'MTN', '3150', '', '3000', '30 Days', 'On'),
(7, '405', 'GIFTING', '2GB', 'MTN', '1475', '', '', '30days', 'On'),
(8, '402', 'GIFTING', '5GB', 'MTN', '1485', '', '', '30 Days', 'Off'),
(9, '408', 'GIFTING', '10GB', 'MTN', '4465', '', '', '30 days', 'On'),
(16, '225', 'CORPORATE', '500MB', 'MTN', '150', '', '', '30 Days', 'Off'),
(17, '213', 'CORPORATE', '1GB', 'MTN', '460', '', '', '30 Days', 'Off'),
(18, '215', 'CORPORATE', '2GB', 'MTN', '584', '', '', '30 Days', 'Off'),
(19, '216', 'CORPORATE', '3GB', 'MTN', '880', '', '', '30 Days', 'Off'),
(20, '217', 'CORPORATE', '5GB', 'MTN', '1460', '', '', '30 Days', 'Off'),
(21, '257', 'CORPORATE', '10GB', 'MTN', '2920', '', '', '30 Days', 'Off'),
(32, '331', 'CORPORATE', '500MB', 'GLO', '210', '', '', '30 Days', 'On'),
(33, '334', 'CORPORATE', '1GB', 'GLO', '420', '', '', '30 Days', 'On'),
(34, '332', 'CORPORATE', '2GB', 'GLO', '840', '', '', '30 Days', 'On'),
(35, '336', 'CORPORATE', '3GB', 'GLO', '1260', '', '', '30 Days', 'On'),
(36, '329', 'CORPORATE', '5GB', 'GLO', '2100', '', '', '30 Days', 'On'),
(37, '335', 'CORPORATE', '10GB', 'GLO', '4420', '', '', '30 Days', 'On'),
(65, '228', 'CORPORATE', '500MB', 'AIRTEL', '500', '', '', '30 Days', 'On'),
(66, '229', 'CORPORATE', '1GB', 'AIRTEL', '990', '', '', '30 Days', 'On'),
(67, '230', 'CORPORATE', '2GB', 'AIRTEL', '1980', '', '', '30 Days', 'On'),
(69, '231', 'CORPORATE', '5GB', 'AIRTEL', '4950', '', '', '30 Days', 'On'),
(70, '232', 'CORPORATE', '10GB', 'AIRTEL', '11600', '', '', '30 Days', 'On'),
(71, '308', 'CORPORATE', '300MB', 'AIRTEL', '310', '', '', '7 Days', 'On'),
(102, '478', 'SME', '1GB', 'AIRTEL', '255', '', '', '2 Days', 'Off'),
(103, '479', 'SME', '2GB', 'AIRTEL', '400', '', '', '2 Days', 'Off'),
(104, '480', 'SME', '3GB', 'AIRTEL', '625', '', '', '7 Days', 'Off'),
(105, '481', 'SME', '4GB', 'AIRTEL', '1100', '', '', '30 Days', 'Off'),
(106, '483', 'SME', '10GB', 'AIRTEL', '3155', '', '', '30 Days', 'On'),
(107, '523', 'SME', '12GB', 'AIRTEL', '3670', '', '', '30 Days', 'On'),
(109, '428', 'GIFTING', '13GB', 'AIRTEL', '5030', '', '', '30days', 'On'),
(110, '427', 'GIFTING', '10GB', 'AIRTEL', '4020', '', '', '30days', 'On'),
(111, '148', 'GIFTING', '4.5GB', 'AIRTEL', '1990', '', '', '30 Days', 'Off'),
(112, '426', 'GIFTING', '8GB', 'AIRTEL', '3020', '', '', '30 Days', 'On'),
(113, '425', 'GIFTING', '4GB', 'AIRTEL', '2490', '', '', '30 Days', 'On'),
(114, '358', 'SME 2', '500MB', 'MTN', '145', '', '', '30 Days', 'Off'),
(115, '353', 'SME 2', '1GB', 'MTN', '287', '', '', '30 Days', 'Off'),
(116, '354', 'SME 2', '2GB', 'MTN', '574', '', '', '30 Days', 'Off'),
(117, '355', 'SME 2', '3GB', 'MTN', '861', '', '', '30 Days', 'Off'),
(118, '356', 'SME 2', '5GB', 'MTN', '1435', '', '', '30 Days', 'Off'),
(119, '357', 'SME 2', '10GB', 'MTN', '2870', '', '', '30 Days', 'Off'),
(123, '169', 'CORPORATE 2', '2GB', 'MTN', '490', '', '', '30 Days', 'Off'),
(124, '170', 'CORPORATE 2', '3GB', 'MTN', '740', '', '', '30 Days', 'Off'),
(125, '171', 'CORPORATE 2', '5GB', 'MTN', '1220', '', '', '30 Days', 'Off'),
(126, '12', 'GIFTING', '800MB', 'GLO', '480', '', '', '14 days', 'Off'),
(127, '13', 'GIFTING', '3.9GB (1.9gb day + 2gb nite =3.9gb)', 'GLO', '945', '', '', '30days', 'Off'),
(128, '14', 'GIFTING', '9.2GB (5.2gb day + 4gb nite =9.2gb', 'GLO', '1900', '', '', '30days', 'Off'),
(129, '15', 'GIFTING', '10.8GB (6.8gb day + 4gb nite =10.8gb)', 'GLO', '2360', '', '', '30days', 'Off'),
(130, '65', 'GIFTING', '20GB (20gb day + 4gb nite =24g)', 'GLO', '4720', '', '', '30 Days', 'Off'),
(131, '182', 'SME', '500MB', '9MOBILE', '85', '', '', '30 Days', 'On'),
(132, '298', 'SME', '1GB', '9MOBILE', '145', '', '', '30 Days', 'On'),
(134, '299', 'SME', '2GB', '9MOBILE', '340', '', '', '30 Days', 'On'),
(135, '303', 'SME', '3GB', '9MOBILE', '510', '', '', '30 Days', 'On'),
(136, '304', 'SME', '5GB', '9MOBILE', '850', '', '', '30 Days', 'On'),
(137, '305', 'SME', '10GB', '9MOBILE', '1700', '', '', '30 Days', 'On'),
(138, '1', 'WAEC', '', 'EXAM_PIN', '3550', '', '', ' ', 'On'),
(139, '2', 'NECO', '', 'EXAM_PIN', '1500', '', '', ' ', 'On'),
(140, '3', 'NABTEB', '', 'EXAM_PIN', '900', '', '', 'infofluterpay@gmail.com', 'Off'),
(141, '13367', 'DATASHARE', '1gb', 'Mtn', '1200', '', '', '1day', 'On'),
(142, '1000', 'DATASHARE ', '599', 'MTN ', '1000', '', '', '3 weeks', 'On'),
(143, '274', 'CORPORATE', '15GB', 'AIRTEL ', '15900', '', '', '30 Days ', 'Off'),
(144, '324', 'CORPORATE', '20GB', 'AIRTEL ', '19800', '', '', '30 Days ', 'On'),
(145, '309', 'CORPORATE', '100MB', 'AIRTEL ', '105', '', '', '7 Days ', 'On'),
(146, '294', 'SME', '10GB', 'MTN', '7200', '50', '7000', '30days', 'Off'),
(147, '313', 'CORPORATE', '500MB', '9MOBILE', '95', '', '', '30days', 'On'),
(148, '298', 'CORPORATE', '1GB', '9MOBILE', '180', '', '', '30days', 'Off'),
(149, '246', 'CORPORATE', '2GB', '9MOBILE', '320', '', '', '30days', 'On'),
(150, '277', 'CORPORATE', '3GB', '9MOBILE', '480', '', '', '30days', 'On'),
(151, '321', 'CORPORATE', '5GB', '9MOBILE', '800', '', '', '30days', 'On'),
(152, '432', 'CORPORATE', '10GB', '9MOBILE', '3200', '', '', '30days', 'On'),
(153, '449', 'GIFTING', '500MB', 'AIRTEL', '500', '', '', '7days', 'On'),
(154, '411', 'GIFTING', '1.8GB (1,500 airtime + 1.8g)', 'MTN', '1465', '', '', '30days', 'On'),
(157, '322', 'CORPORATE GIFTING ', '200MB', 'GLO', '100', '', '', '30days', 'On'),
(158, '34', 'GOtv Smallie - Monthly', 'GOtv Smallie - Monthly = 1900', 'GOtv', '1900', '1900', '1900', '30 Days', 'On'),
(159, '16', 'GOtv Jinja', 'GOtv Jinja = 3900', 'GOtv', '3900', '3900', '3900', '30 Days', 'On'),
(160, '35', 'GOtv Smallie - Quarterly', 'GOtv Smallie - Quarterly =5100', 'GOtv', '5100', '5100', '5100', '30 Days', 'On'),
(161, '17', 'GOtv Jolli', 'GOtv Jolli = 5800', 'GOtv', '5800', '5800', '5800', '30 Days', 'On'),
(162, '2', 'GOtv Max', 'GOtv Max = 8500', 'GOtv', '8500', '8500', '8500', '30 Days', 'On'),
(163, '48', 'GOtv Supa', 'GOtv Supa = 11400', 'GOtv', '11400', '11400', '11400', '30 Days', 'On'),
(164, '36', 'GOtv Smallie - Yearly', 'GOtv Smallie - Yearly = 15000', 'GOtv', '15000', '15000', '15000', '30 Days', 'On'),
(165, '20', 'DStv Padi', 'DStv Padi', 'DStv', '4400', '4400', '4400', '30 Days', 'On'),
(166, '6', 'DStv Yanga', 'DStv Yanga', 'DStv', '6000', '6000', '6000', '30 Days', 'On'),
(167, '19', 'DStv Confam', 'DStv Confam', 'DStv', '11000', '11000', '11000', '30 Days', 'On'),
(168, '47', 'DStv Confam + ExtraView N17000', 'DStv Confam + ExtraView N17000', 'DStv', '17000', '17000', '17000', '30 Days', 'On'),
(169, '7', 'DStv Compact', 'DStv Compact', 'DStv', '19000', '19000', '19000', '30 Days', 'On'),
(170, '29', 'DStv Compact + Extra View', 'DStv Compact + Extra View', 'DStv', '25000', '25000', '25000', '30 Days', 'On'),
(171, '8', 'DStv Compact Plus', 'DStv Compact Plus', 'DStv', '30000', '30000', '30000', '30 Days', 'On'),
(172, '31', 'DStv Compact Plus + Extra View', 'DStv Compact Plus + Extra View', 'DStv', '30000', '30000', '30000', '30 Days', 'On'),
(173, '30', 'DStv Premium + Extra View', 'DStv Premium + Extra View', 'DStv', '42000', '42000', '42000', '30 Days', 'On'),
(174, '9', 'DStv Premium', 'DStv Premium', 'DStv', '44500', '44500', '44500', '30 Days', 'On'),
(175, '37', 'Nova - 700 Naira - 1 Week (antenna)', 'Nova - 700 Naira - 1 Week (antenna)', 'Startime', '700', '700', '700', '1 Week', 'On'),
(176, '49', 'Nova - 700 Naira - 1 Week (Dish)', 'Nova - 700 Naira - 1 Week (Dish)', 'Startime', '700', '700', '700', '1 Week', 'On'),
(177, '38', 'Basic - 1400 Naira - 1 Week', 'Basic - 1400 Naira - 1 Week', 'Startime', '1400', '1400', '1400', '1 Week', 'On'),
(178, '39', 'Smart -1700 Naira - 1 Week', 'Smart -1700 Naira - 1 Week', 'Startime', '1700', '1700', '1700', '1 Week', 'On'),
(179, '40', 'Classic - 2000 Naira - 1 Week', 'Classic - 2000 Naira - 1 Week', 'Startime', '2000', '2000', '2000', '1 Week', 'On'),
(180, '14', 'Nova - 2100 Naira - 1 Month', 'Nova - 2100 Naira - 1 Month', 'Startime', '2100', '2100', '2100', '1 Month', 'On'),
(181, '41', 'Super - 3300 Naira - 1 Week', 'Super - 3300 Naira - 1 Week', 'Startime', '3300', '3300', '3300', '1 Week', 'On'),
(182, '12', 'Basic - 4000 Naira - 1 Month', 'Basic - 4000 Naira - 1 Month', 'Startime', '4000', '4000', '4000', '1 Month', 'On'),
(183, '13', 'Smart - 5100 Naira - 1 Month', 'Smart - 5100 Naira - 1 Month', 'Startime', '5100', '5100', '5100', '1 Month', 'On'),
(184, '11', 'Classic - 6000 Naira - 1 Month', 'Classic - 6000 Naira - 1 Month', 'Startime', '6000', '6000', '6000', '1 Month', 'On'),
(185, '15', 'Super - 9800 Naira - 1 Month', 'Super - 9800 Naira - 1 Month', 'Startime', '9800', '9800', '9800', '1 Month', '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_id_2` 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_id_2`, `provider`, `ab`, `status`) VALUES
(1, 'AIRTIME', '1', '', 'MTN', 'MTN', 'On'),
(2, 'AIRTIME', '4', '', 'AIRTEL ', 'AIRTEL ', 'On'),
(3, 'AIRTIME', '2', '', 'GLO ', 'GLO ', 'On'),
(4, 'AIRTIME', '3', '', '9MOBILE', '9MOBILE', 'On'),
(5, 'DATA', '1', '', 'MTN', 'MTN', 'On'),
(6, 'DATA', '2', '', 'GLO', 'GLO', 'On'),
(7, 'DATA', '6', '', '9MOBILE', '9MOBILE', 'On'),
(8, 'DATA', '3', '', 'AIRTEL', 'AIRTEL', 'On'),
(9, 'ELECTRICITY', '3', '', 'Abuja Electricity', 'AEDC', 'On'),
(10, 'ELECTRICITY', '10', '', 'Benin Electricity', 'BENIN', 'On'),
(11, 'ELECTRICITY', '2', '', 'Eko Electricity', 'EKEDC', 'On'),
(12, 'ELECTRICITY', '5', '', 'Enugu Electricity', 'ENUGU', 'On'),
(13, 'ELECTRICITY', '7', '', 'Ibadan Electricity', 'IBEDC', 'On'),
(14, 'ELECTRICITY', '1', '', 'Ikeja Electricity', 'IE', 'On'),
(15, 'ELECTRICITY', '9', '', 'Jos Electricity', 'JED', 'On'),
(16, 'ELECTRICITY', '8', '', 'Kaduna Electricity', 'KEDC', 'On'),
(17, 'ELECTRICITY', '4', '', 'Kano Electricity', 'KEDCO', 'On'),
(18, 'ELECTRICITY', '6', '', 'Port Harcourt Electricity', 'PHEDC', 'On'),
(19, 'ELECTRICITY', '11', '', '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');

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

--
-- 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,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `transaction` (`id`, `unique_id`, `reference`, `type`, `phone`, `network`, `status`, `old_bal`, `new_bal`, `amount`, `no`, `description`, `date`) VALUES
(255, 'GQHKH5NW3B', 'MB||55842386147906177568||1163835095', 'Airtime', '08146234809', 'MTN', 'success', '299', '199', '100', '', 'Airtime purchase of 100 for 08146234809 at discount of 0%(100)', 'Thu 29-Aug-2024 04:42 pm'),
(256, 'GQHKH5NW3B', 'MB||93986677895275485988||1369882143', 'Airtime', '07086378084', 'AIRTEL', 'success', '199', '99', '100', '', 'Airtime purchase of 100 for 07086378084 at discount of 0%(100)', 'Thu 29-Aug-2024 04:42 pm'),
(257, 'GQHKH5NW3B', 'MB||4580243289||580750367', 'Data', '07086378084', 'AIRTEL', 'success', '299', '159', '140', '', 'Data purchase Of AIRTEL CORPORATE 500MB   30 Days for 07086378084 for amount of NGN 140', 'Thu, 29-Aug-2024 04:54 pm'),
(260, 'Z7Y6AHV4P5', 'MB||84635218217396877586||1117647728', 'Airtime', '08119191045', 'GLO', 'success', '210', '160', '50', '', 'Airtime purchase of 50 for 08119191045 at discount of 0%(50)', 'Fri 30-Aug-2024 07:21 pm'),
(265, 'Z7Y6AHV4P5', 'MB||1867097572||273779423', 'Data', '07086378084', 'AIRTEL', 'success', '360', '220', '140', '', 'Data purchase Of AIRTEL CORPORATE 500MB   30 Days for 07086378084 for amount of NGN 140', 'Fri, 30-Aug-2024 08:29 pm'),
(266, 'Z7Y6AHV4P5', 'MB||9782668593||409576158', 'Data', '08119191045', 'GLO', 'success', '220', '145', '75', '', 'Data purchase Of GLO CORPORATE 200MB   14 Days for 08119191045 for amount of NGN 75', 'Fri, 30-Aug-2024 08:36 pm'),
(293, 'HJML1G14XG', 'MB||4595496159||947080194', 'Data', '08138803770', 'MTN', 'success', '2400', '1605', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Thu, 05-Sep-2024 01:15 pm'),
(296, 'HJML1G14XG', 'MB||3628949539||1715772460', 'Data', '08030886994', 'MTN', 'success', '6605', '3955', '2650', '', 'Data purchase Of MTN SME 10GB   30 Days for 08030886994 for amount of NGN 2,650', 'Thu, 05-Sep-2024 10:12 pm'),
(305, 'HJML1G14XG', 'MB||5583734926||315332154', 'Data', '09063125343', 'MTN', 'success', '3955', '3690', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 09063125343 for amount of NGN 265', 'Sun, 08-Sep-2024 08:24 pm'),
(307, 'HJML1G14XG', 'MB||6312846757||148006371', 'Data', '08134897512', 'MTN', 'success', '3690', '3425', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08134897512 for amount of NGN 265', 'Mon, 09-Sep-2024 11:45 am'),
(309, 'HJML1G14XG', 'MB||5974294665||569071432', 'Data', '08138803770', 'MTN', 'success', '3425', '2630', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 09-Sep-2024 06:05 pm'),
(313, 'HJML1G14XG', 'MB||9974883856||1650391140', 'Data', '07038878002', 'MTN', 'success', '2630', '2365', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Tue, 10-Sep-2024 10:50 pm'),
(315, 'HJML1G14XG', 'MB||8985217562||1320887141', 'Data', '08068929293', 'MTN', 'success', '2365', '1040', '1325', '', 'Data purchase Of MTN SME 5GB   30 Days for 08068929293 for amount of NGN 1,325', 'Wed, 11-Sep-2024 10:00 am'),
(321, 'HJML1G14XG', 'MB||8753958621||1041073956', 'Data', '07050837116', 'GLO', 'success', '1040', '774', '266', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 07050837116 for amount of NGN 266', 'Sat, 14-Sep-2024 02:14 pm'),
(324, 'HJML1G14XG', 'MB||2935626583||996601599', 'Data', '09063125343', 'MTN', 'success', '774', '509', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 09063125343 for amount of NGN 265', 'Sat, 14-Sep-2024 04:33 pm'),
(325, 'HJML1G14XG', 'MB||6174905842||1157610267', 'Data', '07038878002', 'MTN', 'success', '509', '244', '265', '', 'Data purchase Of MTN CORPORATE 1GB   30 Days for 07038878002 for amount of NGN 265', 'Sun, 15-Sep-2024 10:41 am'),
(341, 'HJML1G14XG', 'MB||6538179603||131450946', 'Data', '08134897512', 'MTN', 'success', '4259', '3994', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08134897512 for amount of NGN 265', 'Wed, 18-Sep-2024 02:59 pm'),
(346, 'HJML1G14XG', 'MB||1832663989||400088900', 'Data', '08138803770', 'MTN', 'success', '3994', '3199', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Fri, 20-Sep-2024 07:46 am'),
(348, '19AG2LJ4ZG', 'MB||78047617555218649983||1327070604', 'Airtime', '08146234809', 'MTN', 'success', '310', '260', '50', '', 'Airtime purchase of 50 for 08146234809 at discount of 0%(50)', 'Fri 20-Sep-2024 03:13 pm'),
(349, '19AG2LJ4ZG', 'MB||3495895015||637007841', 'Data', '08146234809', 'MTN', 'success', '260', '121', '139', '', 'Data purchase Of MTN SME 500MB   30 Days for 08146234809 for amount of NGN 139', 'Fri, 20-Sep-2024 03:20 pm'),
(350, '19AG2LJ4ZG', 'MB||7846883359||1467688380', 'Data', '08119191045', 'GLO', 'success', '221', '71', '150', '', 'Data purchase Of GLO CORPORATE 500MB   30DAYS for 08119191045 for amount of NGN 150', 'Sat, 21-Sep-2024 02:29 am'),
(356, 'HJML1G14XG', 'MB||8608899134||50003426', 'Data', '07040273723', 'MTN', 'success', '3199', '2930', '269', '', 'Data purchase Of MTN SME 1GB   30 Days for 07040273723 for amount of NGN 269', 'Sat, 21-Sep-2024 09:53 pm'),
(359, 'HJML1G14XG', 'MB||8291355893||348254607', 'Data', '08138803770', 'MTN', 'success', '2930', '2135', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 23-Sep-2024 08:44 am'),
(360, 'HJML1G14XG', 'MB||7655833482||1217789519', 'Data', '07038878002', 'MTN', 'success', '2135', '1870', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Mon, 23-Sep-2024 08:52 am'),
(365, 'HJML1G14XG', 'MB||1084145768||697094126', 'Data', '08060382669', 'MTN', 'success', '1870', '1075', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08060382669 for amount of NGN 795', 'Tue, 24-Sep-2024 07:44 am'),
(381, 'HJML1G14XG', 'MB||8015822948||1458370175', 'Data', '08061368075', 'MTN', 'success', '1075', '280', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08061368075 for amount of NGN 795', 'Thu, 26-Sep-2024 09:59 pm'),
(382, 'HJML1G14XG', 'MB||4598756317||261638704', 'Data', '07038878002', 'MTN', 'success', '280', '15', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Fri, 27-Sep-2024 07:45 am'),
(383, 'HJML1G14XG', 'MB||3572986885||1710740516', 'Data', '08030556404', 'MTN', 'success', '5015', '4750', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08030556404 for amount of NGN 265', 'Fri, 27-Sep-2024 07:56 am'),
(386, '19AG2LJ4ZG', 'MB||88950857351227678499||792421937', 'Airtime', '07086378084', 'AIRTEL', 'success', '1071', '971', '98', '', 'Airtime purchase of 100 for 07086378084 at discount of 2%(98)', 'Fri 27-Sep-2024 12:43 pm'),
(391, 'HJML1G14XG', 'MB||6695627387||232270576', 'Data', '09063125343', 'MTN', 'success', '4750', '4485', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 09063125343 for amount of NGN 265', 'Fri, 27-Sep-2024 06:47 pm'),
(396, '19AG2LJ4ZG', 'MB||9308829957||570002568', 'Data', '08146234809', 'MTN', 'success', '973', '840', '133', '', 'Data purchase Of MTN SME 500MB   30 Days for 08146234809 for amount of NGN 133', 'Sat, 28-Sep-2024 03:17 pm'),
(410, '19AG2LJ4ZG', 'MB||64968017822345559698||990850920', 'Airtime', '08146234809', 'MTN', 'success', '1840', '1740', '98', '', 'Airtime purchase of 100 for 08146234809 at discount of 2%(98)', 'Tue 01-Oct-2024 03:08 pm'),
(411, '19AG2LJ4ZG', 'MB||2318765928||111296091', 'Data', '08146234809', 'MTN', 'success', '1742', '1609', '133', '', 'Data purchase Of MTN SME 500MB   30 Days for 08146234809 for amount of NGN 133', 'Tue, 01-Oct-2024 07:19 pm'),
(420, 'HJML1G14XG', 'MB||9681892486||814589186', 'Data', '07038878002', 'MTN', 'success', '1570', '1437', '133', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 133', 'Wed, 02-Oct-2024 08:23 pm'),
(427, 'HJML1G14XG', 'MB||5494888378||539779490', 'Data', '07050837116', 'GLO', 'success', '907', '642', '265', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 07050837116 for amount of NGN 265', 'Sat, 05-Oct-2024 12:37 pm'),
(428, 'HJML1G14XG', 'MB||62858480942177699138||1081097960', 'Airtime', '08133081816', 'MTN', 'success', '642', '542', '98', '', 'Airtime purchase of 100 for 08133081816 at discount of 2%(98)', 'Sat 05-Oct-2024 01:31 pm'),
(430, 'HJML1G14XG', 'MB||3935542878||1622507107', 'Data', '07046032799', 'MTN', 'success', '544', '14', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07046032799 for amount of NGN 530', 'Sat, 05-Oct-2024 09:17 pm'),
(435, 'HJML1G14XG', 'MB||3564897208||1024138563', 'Data', '07038878002', 'MTN', 'success', '5014', '4749', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Mon, 07-Oct-2024 11:36 am'),
(439, 'HJML1G14XG', 'MB||9478955488||1062678159', 'Data', '08138803770', 'MTN', 'success', '4749', '4219', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08138803770 for amount of NGN 530', 'Mon, 07-Oct-2024 01:10 pm'),
(442, 'HJML1G14XG', 'MB||7131855542||1121309507', 'Data', '08134897512', 'MTN', 'success', '4219', '3954', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08134897512 for amount of NGN 265', 'Tue, 08-Oct-2024 09:09 am'),
(457, 'HJML1G14XG', 'MB||5918869731||1341322450', 'Data', '08168294236', 'MTN', 'success', '3424', '3159', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08168294236 for amount of NGN 265', 'Sat, 12-Oct-2024 03:51 pm'),
(461, 'HJML1G14XG', 'MB||8938971467||740621903', 'Data', '07038878002', 'MTN', 'success', '3159', '2894', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Sun, 13-Oct-2024 09:01 pm'),
(462, 'HJML1G14XG', 'MB||3477741988||1268317084', 'Data', '08138803770', 'MTN', 'success', '2894', '2099', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 14-Oct-2024 08:46 am'),
(465, 'B415JVMH06', 'MB||36689983848288591017||1050532875', 'Bulk Sms', 'TEST RUN ', 'oyesoro11', 'success', '10', '5', '5', '09045275459', 'Bulk sms sent successfully to 1 phone numbers', 'Mon 14-Oct-2024 03:40 pm'),
(466, 'HJML1G14XG', 'MB||6973892450||1375215734', 'Data', '07038878002', 'MTN', 'success', '2099', '1834', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Tue, 15-Oct-2024 07:57 am'),
(474, 'HJML1G14XG', 'MB||9485125596||1216860', 'Electricity', '', 'Ibadan Electricity (IBEDC)', 'success', '1834', '349', '1485', 'Token : 40113417415486359635', 'Ibadan Electricity (IBEDC) purchase of 1,500 for Ogunyomi Kafayat .(23100400524) at discount of 01%(1485)', 'Fri 18-Oct-2024 10:53 am'),
(476, 'HJML1G14XG', 'MB||6812565178||1646986405', 'Data', '07038878002', 'MTN', 'success', '5349', '5084', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Sat, 19-Oct-2024 08:39 pm'),
(483, 'HJML1G14XG', 'MB||9365906988||247112793', 'Data', '08138803770', 'MTN', 'success', '5084', '4289', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 21-Oct-2024 08:38 am'),
(495, 'HJML1G14XG', 'MB||9417843275||1196214441', 'Data', '07038878002', 'MTN', 'success', '4289', '4024', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 07038878002 for amount of NGN 265', 'Fri, 25-Oct-2024 06:29 am'),
(499, 'HJML1G14XG', 'MB||63288857725116879934||251549553', 'Airtime', '08030886994', 'MTN', 'success', '5049', '2049', '2940', '', 'Airtime purchase of 3,000 for 08030886994 at discount of 2%(2940)', 'Wed 30-Oct-2024 02:21 pm'),
(500, 'HJML1G14XG', 'MB||94219508279535398714||435596211', 'Airtime', '08056511516', 'GLO', 'success', '2109', '109', '1960', '', 'Airtime purchase of 2,000 for 08056511516 at discount of 2%(1960)', 'Wed 30-Oct-2024 02:24 pm'),
(501, 'JGM345O0SB', 'MB||2467898581||959474238', 'Data', '08100323012', 'MTN', 'success', '310', '170', '140', '', 'Data purchase Of MTN SME 500MB   30 Days for 08100323012 for amount of NGN 140', 'Wed, 30-Oct-2024 11:04 pm'),
(507, 'HJML1G14XG', 'MB||3066729888||1197329585', 'Data', '08134897512', 'MTN', 'success', '5149', '4884', '265', '', 'Data purchase Of MTN SME 1GB   30 Days for 08134897512 for amount of NGN 265', 'Thu, 31-Oct-2024 03:18 pm'),
(508, 'JGM345O0SB', 'MB||8822799176||1484211627', 'Data', '08100323012', 'MTN', 'success', '1070', '920', '150', '', 'Data purchase Of MTN SME 500MB   30 Days for 08100323012 for amount of NGN 150', 'Thu, 31-Oct-2024 09:58 pm'),
(509, 'JGM345O0SB', 'MB||6380274953||80613493', 'Data', '07081794205', 'AIRTEL', 'success', '920', '665', '255', '', 'Data purchase Of AIRTEL SME 1GB   3 Days for 07081794205 for amount of NGN 255', 'Thu, 31-Oct-2024 10:03 pm'),
(511, 'BF19VI08UL', 'MB||0788167568||1392613083', 'Data', '08100323012', 'MTN', 'success', '910', '770', '140', '', 'Data purchase Of MTN SME 500MB   30 Days for 08100323012 for amount of NGN 140', 'Sun, 03-Nov-2024 03:27 am'),
(529, 'HJML1G14XG', 'MB||88576453770899229619||437605837', 'Airtime', '08059420256', 'GLO', 'success', '6044', '5944', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Thu 07-Nov-2024 11:31 am'),
(530, 'HJML1G14XG', 'MB||91962368852817883876||1583602152', 'Airtime', '08059420256', 'GLO', 'success', '5946', '5746', '196', '', 'Airtime purchase of 200 for 08059420256 at discount of 2%(196)', 'Thu 07-Nov-2024 03:32 pm'),
(536, 'BF19VI08UL', 'MB||21976139528795588078||1327411476', 'Airtime', '08100323012', 'MTN', 'success', '770', '670', '98', '', 'Airtime purchase of 100 for 08100323012 at discount of 2%(98)', 'Sat 09-Nov-2024 03:02 am'),
(538, 'HJML1G14XG', 'MB||3088497683||691007793', 'Data', '08138803770', 'MTN', 'success', '5750', '4955', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Sat, 09-Nov-2024 07:44 am'),
(543, 'HJML1G14XG', 'MB||04794758613625316898||657247058', 'Airtime', '08059460256', 'GLO', 'success', '4955', '4755', '196', '', 'Airtime purchase of 200 for 08059460256 at discount of 2%(196)', 'Mon 11-Nov-2024 06:26 am'),
(544, 'HJML1G14XG', 'MB||27928830765199813869||1267336066', 'Airtime', '08059420256', 'GLO', 'success', '4759', '4559', '196', '', 'Airtime purchase of 200 for 08059420256 at discount of 2%(196)', 'Mon 11-Nov-2024 06:29 am'),
(547, 'HJML1G14XG', 'MB||7827588536||1009559710', 'Data', '07048255545', 'MTN', 'success', '4563', '4033', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Mon, 11-Nov-2024 09:59 am'),
(550, 'VBBJLNKL1X', 'MB||6895398816||1132558573', 'Wallet Topup', '07056818064', 'Strowallet', 'success', '10', '110', '100', '', 'Wallet Funding of NGN 100 at charge 0f 1% Narration: No Narration', 'Mon 11-Nov-2024 02:45 pm'),
(551, 'VBBJLNKL1X', 'MB||9548978123||1337515575', 'Data', '09018382920', 'AIRTEL', 'success', '110', '10', '100', '', 'Data purchase Of AIRTEL CORPORATE 300MB   7 Days for 09018382920 for amount of NGN 100', 'Mon, 11-Nov-2024 02:46 pm'),
(552, 'HJML1G14XG', 'MB||18393501854879456898||1570945616', 'Airtime', '07026107838', 'MTN', 'success', '4033', '3533', '490', '', 'Airtime purchase of 500 for 07026107838 at discount of 2%(490)', 'Mon 11-Nov-2024 02:49 pm'),
(553, 'HJML1G14XG', 'MB||71355957924688368708||564169510', 'Airtime', '08106348789', 'MTN', 'success', '3543', '3343', '196', '', 'Airtime purchase of 200 for 08106348789 at discount of 2%(196)', 'Mon 11-Nov-2024 03:01 pm'),
(554, 'BF19VI08UL', 'MB||89382599485784377285||1675358296', 'Airtime', '08100323012', 'MTN', 'success', '672', '572', '98', '', 'Airtime purchase of 100 for 08100323012 at discount of 2%(98)', 'Mon 11-Nov-2024 03:31 pm'),
(555, 'BF19VI08UL', 'MB||90875658452684378971||219165449', 'Airtime', '08100323012', 'MTN', 'success', '574', '524', '49', '', 'Airtime purchase of 50 for 08100323012 at discount of 2%(49)', 'Mon 11-Nov-2024 03:39 pm'),
(557, 'HJML1G14XG', 'MB||5677864894||1534167604', 'Data', '08030556404', 'MTN', 'success', '3347', '3082', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Mon, 11-Nov-2024 03:54 pm'),
(567, 'BF19VI08UL', 'MB||54852178837179089653||993207593', 'Airtime', '08100323012', 'MTN', 'success', '525', '425', '98', '', 'Airtime purchase of 100 for 08100323012 at discount of 2%(98)', 'Tue 12-Nov-2024 07:49 pm'),
(569, 'HJML1G14XG', 'MB||93516764887803885946||733965281', 'Airtime', '08059420256', 'GLO', 'success', '2396', '2196', '196', '', 'Airtime purchase of 200 for 08059420256 at discount of 2%(196)', 'Wed 13-Nov-2024 09:41 am'),
(570, 'HJML1G14XG', 'MB||8678462989||717878634', 'Data', '08138803770', 'MTN', 'success', '2200', '1405', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Wed, 13-Nov-2024 02:52 pm'),
(575, 'HJML1G14XG', 'MB||88551969954688074128||1652812015', 'Airtime', '08059420256', 'GLO', 'success', '1405', '905', '490', '', 'Airtime purchase of 500 for 08059420256 at discount of 2%(490)', 'Fri 15-Nov-2024 11:47 am'),
(584, 'HJML1G14XG', 'MB||71953854276867548893||1231746305', 'Airtime', '08059420256', 'GLO', 'success', '915', '415', '490', '', 'Airtime purchase of 500 for 08059420256 at discount of 2%(490)', 'Sat 16-Nov-2024 08:04 am'),
(588, 'HJML1G14XG', 'MB||58991402219486988765||172555191', 'Airtime', '07036370447', 'MTN', 'success', '5425', '4425', '980', '', 'Airtime purchase of 1,000 for 07036370447 at discount of 2%(980)', 'Sun 17-Nov-2024 02:21 pm'),
(589, 'HJML1G14XG', 'MB||8836359908||1639618425', 'Data', '08138803770', 'MTN', 'success', '4445', '3650', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Sun, 17-Nov-2024 02:24 pm'),
(590, 'HJML1G14XG', 'MB||7856319028||1193510332', 'Data', '07048255545', 'MTN', 'success', '3650', '3120', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sun, 17-Nov-2024 08:27 pm'),
(593, 'HJML1G14XG', 'MB||86114756579883288959||706955426', 'Airtime', '07036370447', 'MTN', 'success', '3120', '1620', '1470', '', 'Airtime purchase of 1,500 for 07036370447 at discount of 2%(1470)', 'Tue 19-Nov-2024 10:04 am'),
(594, 'HJML1G14XG', 'MB||6432098577||79914569', 'Data', '07038878002', 'MTN', 'success', '1650', '1120', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07038878002 for amount of NGN 530', 'Tue, 19-Nov-2024 12:24 pm'),
(598, 'HJML1G14XG', 'MB||8846579735||1186441767', 'Data', '07040273723', 'MTN', 'success', '6120', '5855', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07040273723 for amount of NGN 265', 'Tue, 19-Nov-2024 03:58 pm'),
(606, 'HJML1G14XG', 'MB||5359746789||102529671', 'Data', '08138803770', 'MTN', 'success', '5855', '5060', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Thu, 21-Nov-2024 09:09 am'),
(632, 'HJML1G14XG', 'MB||9183865267||475818346', 'Data', '07048255545', 'MTN', 'success', '5060', '4530', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sun, 24-Nov-2024 06:14 pm'),
(637, 'HJML1G14XG', 'MB||37466292971137859886||144965064', 'Airtime', '08059420256', 'GLO', 'success', '3470', '3370', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Tue 26-Nov-2024 12:24 pm'),
(649, 'HJML1G14XG', 'MB||7899916823||990459814', 'Data', '07048255545', 'MTN', 'success', '3372', '2842', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Fri, 29-Nov-2024 04:57 pm'),
(656, 'BF19VI08UL', 'Ref||9893925164||953347796', 'Data', '08100323012', 'MTN', 'success', '1661', '1526', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 08100323012 for amount of NGN 135', 'Sun, 01-Dec-2024 02:02 pm'),
(657, 'BF19VI08UL', 'Ref||28423963886158759909||1298709580', 'Airtime', '08100323012', 'MTN', 'success', '1526', '1476', '49', '', 'Airtime purchase of 50 for 08100323012 at discount of 2%(49)', 'Sun 01-Dec-2024 02:19 pm'),
(663, 'HJML1G14XG', 'Ref||43877657558608143218||120426042', 'Airtime', '08059420256', 'GLO', 'success', '609', '509', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Mon 02-Dec-2024 09:30 am'),
(665, 'HJML1G14XG', 'Ref||7665178828||1273683640', 'Data', '07048255545', 'MTN', 'success', '5511', '4981', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Mon, 02-Dec-2024 11:14 am'),
(666, 'HJML1G14XG', 'Ref||8697154871||875323388', 'Data', '08138803770', 'MTN', 'success', '4981', '4186', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 02-Dec-2024 11:28 am'),
(672, 'HJML1G14XG', 'Ref||20587851345663848727||1697909720', 'Airtime', '08168294236', 'MTN', 'success', '4186', '4086', '98', '', 'Airtime purchase of 100 for 08168294236 at discount of 2%(98)', 'Mon 02-Dec-2024 03:43 pm'),
(680, 'HJML1G14XG', 'Ref||7689457579||85340291', 'Data', '08030886994', 'MTN', 'success', '4088', '1438', '2650', '', 'Data purchase Of MTN SME 10GB  2650 30days for 08030886994 for amount of NGN 2,650', 'Wed, 04-Dec-2024 03:57 pm'),
(684, 'HJML1G14XG', 'Ref||7813406892||1003489356', 'Data', '07038878002', 'MTN', 'success', '1438', '1173', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Wed, 04-Dec-2024 07:14 pm'),
(689, 'HJML1G14XG', 'Ref||65987439151586988288||990870081', 'Airtime', '08059420256', 'GLO', 'success', '1173', '1073', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Thu 05-Dec-2024 10:19 am'),
(691, 'HJML1G14XG', 'Ref||67859294718759284695||573268548', 'Airtime', '07036370447', 'MTN', 'success', '1075', '75', '980', '', 'Airtime purchase of 1,000 for 07036370447 at discount of 2%(980)', 'Thu 05-Dec-2024 06:26 pm'),
(697, 'HJML1G14XG', 'Ref||9681958458||1091299864', 'Data', '07040273723', 'MTN', 'success', '5095', '4830', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07040273723 for amount of NGN 265', 'Fri, 06-Dec-2024 10:35 pm'),
(700, 'HJML1G14XG', 'Ref||8839837205||1230020234', 'Data', '08138803770', 'MTN', 'success', '4830', '4035', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Sat, 07-Dec-2024 10:16 am'),
(701, 'HJML1G14XG', 'Ref||89139039574648158628||1637508999', 'Airtime', '08111651890', 'GLO', 'success', '4035', '3835', '196', '', 'Airtime purchase of 200 for 08111651890 at discount of 2%(196)', 'Sat 07-Dec-2024 11:36 am'),
(709, 'HJML1G14XG', 'Ref||8928876616||109221029', 'Data', '07048255545', 'MTN', 'success', '3839', '3309', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sat, 07-Dec-2024 06:26 pm'),
(719, 'HJML1G14XG', 'Ref||1195274668||783770685', 'Data', '07038878002', 'MTN', 'success', '3309', '3044', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Mon, 09-Dec-2024 02:48 pm'),
(721, 'HJML1G14XG', 'Ref||87395896888641614570||265661268', 'Airtime', '08059420256', 'GLO', 'success', '3044', '2944', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Tue 10-Dec-2024 09:42 pm'),
(726, 'HJML1G14XG', 'Ref||8509388998||642489423', 'Data', '08138803770', 'MTN', 'success', '2946', '2151', '795', '', 'Data purchase Of MTN SME 2 3GB   30 Days for 08138803770 for amount of NGN 795', 'Wed, 11-Dec-2024 10:40 am'),
(727, 'HJML1G14XG', 'Ref||3798488866||782491437', 'Data', '07048255545', 'MTN', 'success', '2151', '1621', '530', '', 'Data purchase Of MTN SME 2 2GB   30 Days for 07048255545 for amount of NGN 530', 'Wed, 11-Dec-2024 10:42 am'),
(737, 'HJML1G14XG', 'Ref||7918578818||1044001417', 'Data', '07038878002', 'MTN', 'success', '1621', '1356', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Thu, 12-Dec-2024 08:10 pm'),
(738, 'HJML1G14XG', 'Ref||18789955831098473687||852294992', 'Airtime', '08059420256', 'GLO', 'success', '1356', '1256', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Fri 13-Dec-2024 10:10 am'),
(743, 'HJML1G14XG', 'Ref||5517884269||355521733', 'Data', '07040273723', 'MTN', 'success', '1258', '728', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07040273723 for amount of NGN 530', 'Sat, 14-Dec-2024 11:10 pm'),
(744, 'HJML1G14XG', 'Ref||3538289584||21104418', 'Data', '08138803770', 'MTN', 'success', '728', '198', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08138803770 for amount of NGN 530', 'Sat, 14-Dec-2024 11:15 pm'),
(752, 'HJML1G14XG', 'Ref||0853467588||150710924', 'Data', '07038878002', 'MTN', 'success', '198', '63', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 135', 'Sun, 15-Dec-2024 10:50 pm'),
(754, 'HJML1G14XG', 'Ref||3288991459||587828667', 'Data', '07038878002', 'MTN', 'success', '5063', '4928', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 135', 'Mon, 16-Dec-2024 11:14 am'),
(757, 'HJML1G14XG', 'Ref||56499234823896857957||957007055', 'Airtime', '07036370447', 'MTN', 'success', '4928', '3928', '980', '', 'Airtime purchase of 1,000 for 07036370447 at discount of 2%(980)', 'Tue 17-Dec-2024 09:06 am'),
(759, 'HJML1G14XG', 'Ref||6014581683||1152669906', 'Data', '08138803770', 'MTN', 'success', '3948', '3153', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Tue, 17-Dec-2024 09:47 pm'),
(768, 'HJML1G14XG', 'Ref||2238761978||869900570', 'Data', '07038878002', 'MTN', 'success', '168', '33', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 135', 'Thu, 19-Dec-2024 10:51 am'),
(771, 'HJML1G14XG', 'Ref||7661898968||580528020', 'Data', '07038878002', 'MTN', 'success', '5033', '4898', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 135', 'Thu, 19-Dec-2024 04:33 pm'),
(775, 'HJML1G14XG', 'Ref||4923828995||1451859442', 'Data', '08138803770', 'MTN', 'success', '4898', '4103', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Thu, 19-Dec-2024 05:33 pm'),
(783, 'HJML1G14XG', 'Ref||5882039789||584074037', 'Data', '07048255545', 'MTN', 'success', '1453', '923', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Fri, 20-Dec-2024 10:47 am'),
(784, 'HJML1G14XG', 'Ref||85071844857139232856||950141500', 'Airtime', '08056511516', 'GLO', 'success', '5923', '4923', '980', '', 'Airtime purchase of 1,000 for 08056511516 at discount of 2%(980)', 'Fri 20-Dec-2024 11:21 am'),
(790, 'HJML1G14XG', 'Ref||5248259978||756689927', 'Data', '07038878002', 'MTN', 'success', '4943', '4808', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 07038878002 for amount of NGN 135', 'Fri, 20-Dec-2024 06:23 pm'),
(792, 'HJML1G14XG', 'Ref||6065298874||657546062', 'Data', '07040273723', 'MTN', 'success', '4808', '4278', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07040273723 for amount of NGN 530', 'Sun, 22-Dec-2024 10:12 am'),
(795, 'HJML1G14XG', 'Ref||47953896865910228713||236971287', 'Airtime', '08059420256', 'GLO', 'success', '4278', '4178', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Sun 22-Dec-2024 07:52 pm'),
(801, 'HJML1G14XG', 'Ref||9293485578||665438602', 'Data', '08138803770', 'MTN', 'success', '4180', '3385', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Wed, 25-Dec-2024 10:06 am'),
(802, 'HJML1G14XG', 'Ref||8784928116||1571901226', 'Data', '07048255545', 'MTN', 'success', '3385', '2855', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Wed, 25-Dec-2024 12:23 pm'),
(807, 'HJML1G14XG', 'Ref||31889789518683852406||833785618', 'Airtime', '08059420256', 'GLO', 'success', '2855', '2755', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2%(98)', 'Thu 26-Dec-2024 10:06 am'),
(810, 'HJML1G14XG', 'Ref||1057817926||139788784', 'Data', '07038878002', 'MTN', 'success', '2757', '2492', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Thu, 26-Dec-2024 01:19 pm'),
(819, 'HJML1G14XG', 'Ref||9367896849||1279199973', 'Data', '08131537870', 'MTN', 'success', '2492', '2227', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08131537870 for amount of NGN 265', 'Sat, 28-Dec-2024 08:00 pm'),
(821, 'HJML1G14XG', 'Ref||8837255208||533078913', 'Data', '07048255545', 'MTN', 'success', '2227', '1697', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sun, 29-Dec-2024 01:38 pm'),
(822, 'HJML1G14XG', 'Ref||9986380258||1341186798', 'Data', '08030556404', 'MTN', 'success', '1697', '1432', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Tue, 31-Dec-2024 07:54 am'),
(828, 'HJML1G14XG', 'Ref||7692166428||456345224', 'Data', '08138803770', 'MTN', 'success', '1432', '637', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Tue, 31-Dec-2024 04:09 pm'),
(832, 'BF19VI08UL', 'Ref||04783789967645188255||452400905', 'Airtime', '08100323012', 'MTN', 'success', '147', '97', '50', '', 'Airtime purchase of 50 for 08100323012 at discount of 0(50)', 'Wed 01-Jan-2025 03:04 am'),
(833, 'HJML1G14XG', 'Ref||67889726533719604281||1537254886', 'Airtime', '08059420256', 'GLO', 'success', '2987', '2887', '100', '', 'Airtime purchase of 100 for 08059420256 at discount of 0(100)', 'Wed 01-Jan-2025 12:22 pm'),
(834, 'BF19VI08UL', 'Ref||5836948197||475868254', 'Data', '08100323012', 'MTN', 'success', '970', '835', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 08100323012 for amount of NGN 135', 'Wed, 01-Jan-2025 11:18 pm'),
(841, 'HJML1G14XG', 'Ref||4889387851||874876055', 'Data', '07038878002', 'MTN', 'success', '2887', '2622', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Thu, 02-Jan-2025 08:24 pm'),
(842, 'HJML1G14XG', 'Ref||6893834789||1693799529', 'Data', '07048255545', 'MTN', 'success', '2622', '2092', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Thu, 02-Jan-2025 08:25 pm'),
(845, 'HJML1G14XG', 'Ref||9289318884||1545461716', 'Data', '08138803770', 'MTN', 'success', '2092', '1297', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Fri, 03-Jan-2025 01:02 pm'),
(862, 'BF19VI08UL', 'Ref||8795528269||1046153271', 'Transfer', '9151062120', 'Lady Folakemi ', 'success', '201784', '182574', '19210', '', 'Bank transfer of NGN 19210 to Lady Folakemi (9151062120) at charge of NGN 10', 'Tue, 07-Jan-2025 02:35 am'),
(864, 'BF19VI08UL', 'Ref||8058542673||1377340273', 'Transfer', '9151062120', 'Lady Folakemi ', 'success', '182574', '163364', '19210', '', 'Bank transfer of NGN 19210 to Lady Folakemi (9151062120) at charge of NGN 10', 'Tue, 07-Jan-2025 02:36 am'),
(865, 'BF19VI08UL', 'Ref||48731468355078668798||1215654698', 'Airtime', '07034398627', 'MTN', 'success', '3364', '3314', '50', '', 'Airtime purchase of 50 for 07034398627 at discount of 0(50)', 'Tue 07-Jan-2025 04:15 am'),
(866, 'BF19VI08UL', 'Ref||95587868712861589347||836100980', 'Airtime', '07034398627', 'MTN', 'success', '3314', '3264', '50', '', 'Airtime purchase of 50 for 07034398627 at discount of 0(50)', 'Tue 07-Jan-2025 04:17 am'),
(867, 'BF19VI08UL', 'Ref||87489236519702799861||477714825', 'Airtime', '07034398627', 'MTN', 'success', '3264', '3214', '49', '', 'Airtime purchase of 50 for 07034398627 at discount of 2(49)', 'Tue 07-Jan-2025 04:26 am'),
(868, 'BF19VI08UL', 'Ref||93624688625959818773||162502274', 'Airtime', '07034398627', 'MTN', 'success', '3215', '3165', '49', '', 'Airtime purchase of 50 for 07034398627 at discount of 2(49)', 'Tue 07-Jan-2025 04:57 am'),
(871, 'HJML1G14XG', 'Ref||5698853744||1321693165', 'Data', '08138803770', 'MTN', 'success', '2025', '1230', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Tue, 07-Jan-2025 10:34 am'),
(872, 'HJML1G14XG', 'Ref||8818175426||1037605215', 'Data', '07048255545', 'MTN', 'success', '1230', '700', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Tue, 07-Jan-2025 08:49 pm'),
(875, 'HJML1G14XG', 'Ref||8962908195||1299982347', 'Data', '08030556404', 'MTN', 'success', '700', '435', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Thu, 09-Jan-2025 01:51 pm'),
(883, 'HJML1G14XG', 'Ref||5948256388||1514114112', 'Data', '07038878002', 'MTN', 'success', '5435', '5170', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Sat, 11-Jan-2025 05:52 pm'),
(885, 'HJML1G14XG', 'Ref||9398806559||1029912293', 'Data', '07048255545', 'MTN', 'success', '5170', '4640', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sat, 11-Jan-2025 08:45 pm'),
(887, 'HJML1G14XG', 'Ref||9417558283||1720527885', 'Data', '08030556404', 'MTN', 'success', '4640', '4375', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Sun, 12-Jan-2025 07:33 pm'),
(888, 'HJML1G14XG', 'Ref||7519088196||1673114382', 'Data', '08073413608', 'GLO', 'success', '4375', '4105', '270', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 270', 'Sun, 12-Jan-2025 07:35 pm'),
(889, 'HJML1G14XG', 'Ref||4789675905||1158669675', 'Data', '09024565372', 'AIRTEL', 'success', '4105', '3545', '560', '', 'Data purchase Of AIRTEL CORPORATE 2GB   30 Days for 09024565372 for amount of NGN 560', 'Sun, 12-Jan-2025 07:36 pm'),
(890, 'HJML1G14XG', 'Ref||8175778589||1505329425', 'Data', '08068587749', 'MTN', 'success', '3545', '3280', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08068587749 for amount of NGN 265', 'Sun, 12-Jan-2025 07:38 pm'),
(891, 'HJML1G14XG', 'Ref||8818536074||1131649425', 'Data', '07040273723', 'MTN', 'success', '3280', '3015', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07040273723 for amount of NGN 265', 'Sun, 12-Jan-2025 07:39 pm'),
(892, 'HJML1G14XG', 'Ref||2814861907||1611826201', 'Data', '09037166234', 'MTN', 'success', '3015', '2750', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 09037166234 for amount of NGN 265', 'Sun, 12-Jan-2025 09:15 pm'),
(894, 'HJML1G14XG', 'Ref||60731893298298856588||1407104166', 'Airtime', '08059420256', 'GLO', 'success', '2750', '2650', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Sun 12-Jan-2025 09:35 pm'),
(896, 'HJML1G14XG', 'Ref||0731388659||745782584', 'Data', '08138803770', 'MTN', 'success', '2652', '1857', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 13-Jan-2025 09:55 am'),
(921, 'HJML1G14XG', 'Ref||4816398998||1094706715', 'Data', '07048255545', 'MTN', 'success', '1857', '1327', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Wed, 15-Jan-2025 11:48 am'),
(923, 'HJML1G14XG', 'Ref||8249569168||1727921538', 'Data', '07038878002', 'MTN', 'success', '1327', '1062', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Wed, 15-Jan-2025 07:47 pm'),
(924, 'HJML1G14XG', 'Ref||9683586894||1010613436', 'Data', '08138803770', 'MTN', 'success', '1062', '267', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Thu, 16-Jan-2025 09:02 am'),
(932, 'HJML1G14XG', 'Ref||9814076188||476884035', 'Data', '09063125343', 'MTN', 'success', '5267', '5002', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 09063125343 for amount of NGN 265', 'Fri, 17-Jan-2025 09:04 pm'),
(938, 'HJML1G14XG', 'Ref||9382288757||1300652598', 'Data', '07038878002', 'MTN', 'success', '5002', '4737', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Mon, 20-Jan-2025 08:14 am'),
(939, 'HJML1G14XG', 'Ref||8194594926||294934112', 'Data', '08138803770', 'MTN', 'success', '4737', '3942', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 20-Jan-2025 09:51 am'),
(940, 'HJML1G14XG', 'Ref||7916649945||574421710', 'Data', '07048255545', 'MTN', 'success', '3942', '3412', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Mon, 20-Jan-2025 06:12 pm'),
(942, 'HJML1G14XG', 'Ref||9584265488||570569741', 'Data', '09063125343', 'MTN', 'success', '3412', '3147', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 09063125343 for amount of NGN 265', 'Tue, 21-Jan-2025 09:06 pm'),
(943, 'HJML1G14XG', 'Ref||8291492596||1002129517', 'Data', '08030556404', 'MTN', 'success', '3147', '2882', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Tue, 21-Jan-2025 10:34 pm'),
(944, 'HJML1G14XG', 'Ref||8016249539||491791309', 'Data', '07038878002', 'MTN', 'success', '2882', '2617', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Wed, 22-Jan-2025 09:39 am'),
(946, 'HJML1G14XG', 'Ref||9357609957||1427501782', 'Data', '07038878002', 'MTN', 'success', '4967', '4702', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Thu, 23-Jan-2025 10:45 pm'),
(947, 'HJML1G14XG', 'Ref||49186872237878955839||1672827082', 'Airtime', '08059420256', 'GLO', 'success', '4702', '4602', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Thu 23-Jan-2025 10:46 pm'),
(953, 'HJML1G14XG', 'Ref||2318659758||342987975', 'Data', '08138803770', 'MTN', 'success', '4604', '3809', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Fri, 24-Jan-2025 06:09 pm'),
(954, 'HJML1G14XG', 'Ref||9319487368||1256135290', 'Data', '07048255545', 'MTN', 'success', '3809', '3279', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Fri, 24-Jan-2025 06:10 pm'),
(959, 'HJML1G14XG', 'Ref||66785989314531052688||172821866', 'Airtime', '08059420256', 'GLO', 'success', '3279', '3179', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Sun 26-Jan-2025 10:18 am'),
(961, 'HJML1G14XG', 'Ref||98458509833948671252||1643365920', 'Airtime', '09130585738', 'MTN', 'success', '3181', '2681', '490', '', 'Airtime purchase of 500 for 09130585738 at discount of 2(490)', 'Sun 26-Jan-2025 06:52 pm'),
(962, 'HJML1G14XG', 'Ref||9818975156||1689780822', 'Data', '07038878002', 'MTN', 'success', '2691', '2426', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Sun, 26-Jan-2025 06:53 pm'),
(967, 'HJML1G14XG', 'Ref||2797488648||253341575', 'Data', '09024565372', 'AIRTEL', 'success', '2426', '1866', '560', '', 'Data purchase Of AIRTEL CORPORATE 2GB   30 Days for 09024565372 for amount of NGN 560', 'Sun, 26-Jan-2025 09:13 pm'),
(968, 'HJML1G14XG', 'Ref||7768129085||1667586353', 'Data', '08138803770', 'MTN', 'success', '1866', '1071', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Mon, 27-Jan-2025 10:05 am'),
(973, 'HJML1G14XG', 'Ref||9582849362||1456094598', 'Data', '08073413608', 'GLO', 'success', '1071', '801', '270', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 270', 'Mon, 27-Jan-2025 05:30 pm'),
(982, 'HJML1G14XG', 'Ref||8546091263||1027930532', 'Data', '07050837116', 'GLO', 'success', '4801', '3991', '810', '', 'Data purchase Of GLO CORPORATE 3GB   30 Days for 07050837116 for amount of NGN 810', 'Wed, 29-Jan-2025 09:26 am'),
(985, 'HJML1G14XG', 'Ref||2813558748||1366385746', 'Data', '07048255545', 'MTN', 'success', '3991', '3461', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Thu, 30-Jan-2025 11:10 am'),
(991, 'HJML1G14XG', 'Ref||9302991758||138873223', 'Data', '08138803770', 'MTN', 'success', '3461', '2666', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Fri, 31-Jan-2025 07:04 am'),
(992, 'HJML1G14XG', 'Ref||2898955325||100213374', 'Data', '07038878002', 'MTN', 'success', '2666', '2401', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Fri, 31-Jan-2025 10:31 am'),
(995, 'HJML1G14XG', 'Ref||1925349889||1381723530', 'Data', '08073413608', 'GLO', 'success', '2401', '2131', '270', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 270', 'Fri, 31-Jan-2025 11:21 pm'),
(996, 'HJML1G14XG', 'Ref||1295874986||193622834', 'Data', '08030556404', 'MTN', 'success', '2131', '1866', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Fri, 31-Jan-2025 11:22 pm'),
(997, 'HJML1G14XG', 'Ref||66138145772972888899||1593210961', 'Airtime', '08059420256', 'GLO', 'success', '1866', '1766', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Sat 01-Feb-2025 07:59 am'),
(998, 'HJML1G14XG', 'Ref||7866388615||1672427166', 'Data', '08165460371', 'MTN', 'success', '1768', '1503', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08165460371 for amount of NGN 265', 'Sat, 01-Feb-2025 10:03 am'),
(1009, 'HJML1G14XG', 'Ref||8462158268||1336735271', 'Data', '08062495733', 'MTN', 'success', '6503', '3853', '2650', '', 'Data purchase Of MTN SME 10GB  2650 30days for 08062495733 for amount of NGN 2,650', 'Sun, 02-Feb-2025 06:59 pm'),
(1011, 'HJML1G14XG', 'Ref||3608459981||800171752', 'Data', '07038878002', 'MTN', 'success', '3853', '3588', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Mon, 03-Feb-2025 08:21 am'),
(1017, 'HJML1G14XG', 'Ref||54986883774126795888||67380036', 'Airtime', '08059420256', 'GLO', 'success', '3588', '3488', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Tue 04-Feb-2025 03:29 pm'),
(1018, 'HJML1G14XG', 'Ref||9865727892||1716439506', 'Data', '08030886994', 'MTN', 'success', '3490', '840', '2650', '', 'Data purchase Of MTN SME 10GB  2650 30days for 08030886994 for amount of NGN 2,650', 'Tue, 04-Feb-2025 06:24 pm'),
(1019, 'HJML1G14XG', 'Ref||51034168688235989296||825904861', 'Airtime', '08056511516', 'GLO', 'success', '5840', '3840', '1960', '', 'Airtime purchase of 2,000 for 08056511516 at discount of 2(1960)', 'Tue 04-Feb-2025 06:28 pm'),
(1021, 'HJML1G14XG', 'Ref||1483728761||179545866', 'Data', '08138803770', 'MTN', 'success', '3880', '3085', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08138803770 for amount of NGN 795', 'Tue, 04-Feb-2025 09:10 pm'),
(1022, 'HJML1G14XG', 'Ref||9588109677||1492594309', 'Data', '08073413608', 'GLO', 'success', '3085', '2815', '270', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 270', 'Wed, 05-Feb-2025 05:13 pm'),
(1023, 'HJML1G14XG', 'Ref||9254816959||1726118109', 'Data', '07048255545', 'MTN', 'success', '2815', '2285', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Wed, 05-Feb-2025 06:44 pm'),
(1034, 'HJML1G14XG', 'Ref||1560377826||1077165477', 'Data', '09024565372', 'AIRTEL', 'success', '2285', '1725', '560', '', 'Data purchase Of AIRTEL CORPORATE 2GB   30 Days for 09024565372 for amount of NGN 560', 'Thu, 06-Feb-2025 11:14 pm'),
(1036, 'HJML1G14XG', 'Ref||3134968862||1155130459', 'Data', '07038878002', 'MTN', 'success', '1725', '1460', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Sat, 08-Feb-2025 05:48 pm'),
(1037, 'HJML1G14XG', 'Ref||4328659069||330242094', 'Data', '07040273723', 'MTN', 'success', '1460', '1195', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07040273723 for amount of NGN 265', 'Sat, 08-Feb-2025 09:38 pm'),
(1039, 'HJML1G14XG', 'Ref||4598069687||179463929', 'Data', '08138803770', 'MTN', 'success', '1195', '930', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08138803770 for amount of NGN 265', 'Mon, 10-Feb-2025 12:51 pm'),
(1040, 'HJML1G14XG', 'Ref||8797755980||934374302', 'Data', '08138803770', 'MTN', 'success', '930', '665', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08138803770 for amount of NGN 265', 'Mon, 10-Feb-2025 12:52 pm'),
(1041, 'BF19VI08UL', 'Ref||9366581765||42520176', 'Data', '08035681404', 'MTN', 'success', '2166', '2031', '135', '', 'Data purchase Of MTN SME 500MB   30 Days for 08035681404 for amount of NGN 135', 'Mon, 10-Feb-2025 09:22 pm'),
(1042, 'HJML1G14XG', 'Ref||7195346784||1035115347', 'Data', '07038878002', 'MTN', 'success', '665', '400', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Mon, 10-Feb-2025 09:37 pm'),
(1044, 'HJML1G14XG', 'Ref||8312686754||1046903931', 'Data', '09063125343', 'MTN', 'success', '400', '135', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 09063125343 for amount of NGN 265', 'Mon, 10-Feb-2025 09:51 pm'),
(1048, 'HJML1G14XG', 'Ref||9798991216||1120862416', 'Data', '08132797047', 'MTN', 'success', '4605', '4075', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08132797047 for amount of NGN 530', 'Thu, 13-Feb-2025 08:13 pm'),
(1049, 'HJML1G14XG', 'Ref||7135949795||1143911135', 'Data', '07047493937', 'MTN', 'success', '4075', '3280', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 07047493937 for amount of NGN 795', 'Thu, 13-Feb-2025 08:21 pm'),
(1053, 'HJML1G14XG', 'Ref||5156872782||926988285', 'Data', '08073413608', 'GLO', 'success', '1505', '1235', '270', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 270', 'Fri, 14-Feb-2025 04:56 pm'),
(1054, 'HJML1G14XG', 'Ref||8129781595||1461071978', 'Data', '08030556404', 'MTN', 'success', '1235', '970', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08030556404 for amount of NGN 265', 'Fri, 14-Feb-2025 04:57 pm'),
(1060, 'HJML1G14XG', 'Ref||9848789615||800197645', 'Data', '08068587749', 'MTN', 'success', '970', '440', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08068587749 for amount of NGN 530', 'Sat, 15-Feb-2025 10:51 pm'),
(1065, 'HJML1G14XG', 'Ref||8646984589||948533908', 'Data', '08138803770', 'MTN', 'success', '5440', '4910', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08138803770 for amount of NGN 530', 'Sun, 16-Feb-2025 02:32 pm'),
(1066, 'HJML1G14XG', 'Ref||8861139594||1114310923', 'Data', '07048255545', 'MTN', 'success', '4910', '4380', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Mon, 17-Feb-2025 01:34 pm'),
(1067, 'BF19VI08UL', 'Ref||6649578388||1574497162', 'Data', '08035681404', 'MTN', 'success', '2531', '2266', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 08035681404 for amount of NGN 265', 'Mon, 17-Feb-2025 04:52 pm'),
(1068, 'BF19VI08UL', 'MB||9967465273||1348079906', 'Wallet Topup', '07034398627', 'Strowallet', 'success', '2266', '2527', '261', '3.975', 'Wallet Funding of NGN 261 at charge of 1.5% Narration: Transfer from GAMALIEL CHIBUIKE CHIGEKWU', 'Mon 17-Feb-2025 04:56 pm'),
(1069, 'HJML1G14XG', 'Ref||9755118528||830028770', 'Data', '07038878002', 'MTN', 'success', '4380', '4115', '265', '', 'Data purchase Of MTN SME 1GB   30 days for 07038878002 for amount of NGN 265', 'Tue, 18-Feb-2025 08:13 am'),
(1070, 'HJML1G14XG', 'Ref||48612796826988089795||417990128', 'Airtime', '08059420256', 'GLO', 'success', '4115', '4015', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Tue 18-Feb-2025 08:14 am'),
(1072, 'HJML1G14XG', 'Ref||9467948853||1106803127', 'Data', '08138803770', 'MTN', 'success', '4017', '3487', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 08138803770 for amount of NGN 530', 'Wed, 19-Feb-2025 02:33 pm'),
(1073, 'HJML1G14XG', 'Ref||6994787597||1478018472', 'Data', '07048255545', 'MTN', 'success', '3487', '2957', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Wed, 19-Feb-2025 05:05 pm'),
(1075, 'HJML1G14XG', 'Ref||7195930978||465445395', 'Data', '09137686536', 'MTN', 'success', '2957', '2162', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 09137686536 for amount of NGN 795', 'Thu, 20-Feb-2025 05:52 pm'),
(1077, 'HJML1G14XG', 'Ref||9884553754||134580573', 'Data', '08132797047', 'MTN', 'success', '2162', '1367', '795', '', 'Data purchase Of MTN SME 3GB   30 Days for 08132797047 for amount of NGN 795', 'Thu, 20-Feb-2025 09:30 pm'),
(1078, 'HJML1G14XG', 'Ref||98899035885163869775||1065172348', 'Airtime', '08132797047', 'MTN', 'success', '1367', '367', '980', '', 'Airtime purchase of 1,000 for 08132797047 at discount of 2(980)', 'Thu 20-Feb-2025 09:36 pm'),
(1085, 'HJML1G14XG', 'Ref||07283681428591589987||1694195779', 'Airtime', '08131537870', 'MTN', 'success', '5142', '5042', '98', '', 'Airtime purchase of 100 for 08131537870 at discount of 2(98)', 'Sat 22-Feb-2025 11:22 am'),
(1089, 'HJML1G14XG', 'Ref||8295860984||1424820934', 'Data', '07051311441', 'GLO', 'success', '4249', '3974', '275', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 07051311441 for amount of NGN 275', 'Sun, 23-Feb-2025 02:33 pm'),
(1093, 'HJML1G14XG', 'Ref||8125966580||915636998', 'Data', '07048255545', 'MTN', 'success', '3974', '3444', '530', '', 'Data purchase Of MTN SME 2GB   30 Days for 07048255545 for amount of NGN 530', 'Sun, 23-Feb-2025 06:55 pm'),
(1100, 'HJML1G14XG', 'Ref||8558619962||64640684', 'Data', '07083143856', 'AIRTEL', 'success', '3444', '2234', '1210', '', 'Data purchase Of AIRTEL CORPORATE 2GB  1210 30 Days for 07083143856 for amount of NGN 1,210', 'Tue, 25-Feb-2025 07:37 pm'),
(1101, 'HJML1G14XG', 'Ref||5718187963||22467954', 'Data', '07040273723', 'MTN', 'success', '2234', '930', '1304', '', 'Data purchase Of MTN SME 2GB  1304 30 Days for 07040273723 for amount of NGN 1,304', 'Tue, 25-Feb-2025 08:31 pm'),
(1102, 'HJML1G14XG', 'Ref||9778789928||634433122', 'Data', '08073413608', 'GLO', 'success', '930', '300', '630', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 630', 'Wed, 26-Feb-2025 09:11 am'),
(1108, 'HJML1G14XG', 'Ref||99881708865284369458||440147027', 'Airtime', '07038878002', 'MTN', 'success', '4985', '4885', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Thu 27-Feb-2025 01:49 pm');
INSERT INTO `transaction` (`id`, `unique_id`, `reference`, `type`, `phone`, `network`, `status`, `old_bal`, `new_bal`, `amount`, `no`, `description`, `date`) VALUES
(1109, 'HJML1G14XG', 'Ref||9690837226||237655901', 'Data', '08138803770', 'MTN', 'success', '4887', '3583', '1304', '', 'Data purchase Of MTN SME 2GB  1304 30 Days for 08138803770 for amount of NGN 1,304', 'Thu, 27-Feb-2025 10:29 pm'),
(1111, 'HJML1G14XG', 'Ref||6575197136||1432110357', 'Data', '07048255545', 'MTN', 'success', '3583', '2931', '652', '', 'Data purchase Of MTN SME 1GB   30 days for 07048255545 for amount of NGN 652', 'Fri, 28-Feb-2025 02:04 pm'),
(1126, 'HJML1G14XG', 'Ref||1858936132||713809894', 'Data', '08138803770', 'MTN', 'success', '4956', '3652', '1304', '', 'Data purchase Of MTN SME 2GB  1304 30 Days for 08138803770 for amount of NGN 1,304', 'Tue, 04-Mar-2025 06:49 am'),
(1127, 'HJML1G14XG', 'Ref||43978868219286786505||725424437', 'Airtime', '07036370447', 'MTN', 'success', '3652', '2652', '980', '', 'Airtime purchase of 1,000 for 07036370447 at discount of 2(980)', 'Tue 04-Mar-2025 06:34 pm'),
(1128, 'HJML1G14XG', 'Ref||6818027698||1151736569', 'Data', '08132797047', 'MTN', 'success', '2672', '2020', '652', '', 'Data purchase Of MTN SME 1GB   30 days for 08132797047 for amount of NGN 652', 'Tue, 04-Mar-2025 09:45 pm'),
(1129, 'HJML1G14XG', 'Ref||29658992855778944811||236208591', 'Airtime', '08132797047', 'MTN', 'success', '2020', '1720', '294', '', 'Airtime purchase of 300 for 08132797047 at discount of 2(294)', 'Tue 04-Mar-2025 09:47 pm'),
(1134, 'HJML1G14XG', 'Ref||78756549081293368648||1067331539', 'Airtime', '07038878002', 'MTN', 'success', '1726', '1626', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Thu 06-Mar-2025 08:47 am'),
(1136, 'HJML1G14XG', 'Ref||1838329877||640267621', 'Data', '08073413608', 'GLO', 'success', '1628', '798', '830', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 830', 'Thu, 06-Mar-2025 12:10 pm'),
(1139, 'HJML1G14XG', 'Ref||1527985699||847401892', 'Data', '08138803770', 'MTN', 'success', '5798', '4494', '1304', '', 'Data purchase Of MTN SME 2GB  1304 30 Days for 08138803770 for amount of NGN 1,304', 'Fri, 07-Mar-2025 09:32 am'),
(1140, 'HJML1G14XG', 'Ref||5558391286||148099969', 'Data', '08059420256', 'GLO', 'success', '4494', '4064', '430', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 430', 'Fri, 07-Mar-2025 11:21 am'),
(1150, 'HJML1G14XG', 'Ref||6832938881||1450570972', 'Data', '08059420256', 'GLO', 'success', '4064', '3634', '430', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 430', 'Sat, 08-Mar-2025 06:43 pm'),
(1155, 'HJML1G14XG', 'Ref||56177999828981823476||1534744370', 'Airtime', '09029366960', 'AIRTEL', 'success', '3634', '3134', '490', '', 'Airtime purchase of 500 for 09029366960 at discount of 2(490)', 'Mon 10-Mar-2025 02:50 pm'),
(1158, 'HJML1G14XG', 'Ref||7886577689||1257241026', 'Data', '07083143856', 'AIRTEL', 'success', '3144', '1944', '1200', '', 'Data purchase Of AIRTEL CORPORATE 2GB  1200 30 Days for 07083143856 for amount of NGN 1,200', 'Mon, 10-Mar-2025 07:49 pm'),
(1160, 'BF19VI08UL', 'MB||7986498158||1467322372', 'Wallet Topup', '07034398627', 'Strowallet', 'success', '2527', '3019', '492', '7.5', 'Wallet Funding of NGN 492 at charge of 1.5% Narration: JAHVEE', 'Tue 11-Mar-2025 03:11 am'),
(1162, 'HJML1G14XG', 'Ref||0688748317||1572932310', 'Data', '08073413608', 'GLO', 'success', '1944', '1084', '860', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 860', 'Tue, 11-Mar-2025 07:25 pm'),
(1164, 'HJML1G14XG', 'Ref||6538987616||814085213', 'Data', '08138803770', 'MTN', 'success', '6084', '4768', '1316', '', 'Data purchase Of MTN SME 2GB  1316 30 Days for 08138803770 for amount of NGN 1,316', 'Wed, 12-Mar-2025 09:06 am'),
(1167, 'HJML1G14XG', 'Ref||48512068521785669398||166665825', 'Airtime', '07036370447', 'MTN', 'success', '4768', '3268', '1470', '', 'Airtime purchase of 1,500 for 07036370447 at discount of 2(1470)', 'Wed 12-Mar-2025 07:11 pm'),
(1171, 'HJML1G14XG', 'Ref||8087655838||1431760574', 'Data', '09024565372', 'AIRTEL', 'success', '3298', '2698', '600', '', 'Data purchase Of AIRTEL CORPORATE 1GB   30 Days for 09024565372 for amount of NGN 600', 'Thu, 13-Mar-2025 05:18 pm'),
(1176, 'BF19VI08UL', 'Ref||65298667978905171838||468439125', 'Airtime Pin', 'AIRTEL', '*311*PIN#||20741255052682953085', 'success', '3019', '2919', '100', '5006717880497257', 'Airtime pin purchase of AIRTEL 1 quantity at amount of 100 for Becky', 'Thu 13-Mar-2025 07:48 pm'),
(1177, 'BF19VI08UL', 'FLP||68893897459159816573||1488068074', 'Airtime Pin', 'MTN', '*311*PIN#||00000032382112941', 'success', '2919', '2819', '100', '69818473054169647', 'Airtime pin purchase of MTN 1 quantity at amount of 100 for Remiel', 'Thu 13-Mar-2025 07:58 pm'),
(1186, 'HJML1G14XG', 'Ref||8527688191||374350654', 'Data', '08059420256', 'GLO', 'success', '2698', '2478', '220', '', 'Data purchase Of GLO CORPORATE 500MB   30 Days for 08059420256 for amount of NGN 220', 'Mon, 17-Mar-2025 05:34 pm'),
(1188, 'HJML1G14XG', 'Ref||48168977499651570823||503124269', 'Airtime', '08132797047', 'MTN', 'success', '5288', '5188', '98', '', 'Airtime purchase of 100 for 08132797047 at discount of 2(98)', 'Wed 19-Mar-2025 11:14 am'),
(1193, 'HJML1G14XG', 'Ref||8873152891||725698377', 'Data', '08073413608', 'GLO', 'success', '4590', '3710', '880', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 880', 'Thu, 20-Mar-2025 12:43 pm'),
(1208, 'HJML1G14XG', 'Ref||5923686847||821587145', 'Data', '08059420256', 'GLO', 'success', '1910', '1470', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Tue, 25-Mar-2025 01:57 pm'),
(1210, 'HJML1G14XG', 'Ref||62189185744396369875||52743008', 'Airtime', '07038878002', 'MTN', 'success', '1470', '1370', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Wed 26-Mar-2025 02:15 pm'),
(1216, 'HJML1G14XG', 'Ref||98766019568885483929||653060401', 'Airtime', '08132797047', 'MTN', 'success', '1372', '872', '490', '', 'Airtime purchase of 500 for 08132797047 at discount of 2(490)', 'Sat 29-Mar-2025 07:45 am'),
(1219, 'HJML1G14XG', 'Ref||78138598431798694662||1172867700', 'Airtime', '07038878002', 'MTN', 'success', '4682', '4582', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Sat 29-Mar-2025 05:19 pm'),
(1221, 'HJML1G14XG', 'Ref||6816251459||372511468', 'Data', '08073413608', 'GLO', 'success', '4584', '3704', '880', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 880', 'Sat, 29-Mar-2025 11:12 pm'),
(1222, 'HJML1G14XG', 'Ref||85584122769956468787||1659715043', 'Airtime', '07036370447', 'MTN', 'success', '3704', '3204', '490', '', 'Airtime purchase of 500 for 07036370447 at discount of 2(490)', 'Sun 30-Mar-2025 05:52 pm'),
(1223, 'HJML1G14XG', 'Ref||56567389438987110978||1452402389', 'Airtime', '09130585738', 'MTN', 'success', '3214', '2214', '980', '', 'Airtime purchase of 1,000 for 09130585738 at discount of 2(980)', 'Sun 30-Mar-2025 05:54 pm'),
(1227, 'HJML1G14XG', 'Ref||49935386678295705897||1531762743', 'Airtime', '08059420256', 'GLO', 'success', '2234', '2134', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Mon 31-Mar-2025 10:17 am'),
(1229, 'HJML1G14XG', 'Ref||3296326955||1410299530', 'Data', '08059420256', 'GLO', 'success', '1536', '1096', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Mon, 31-Mar-2025 01:01 pm'),
(1230, 'HJML1G14XG', 'Ref||74823803991685928765||1368847090', 'Airtime', '08132797047', 'MTN', 'success', '1096', '596', '490', '', 'Airtime purchase of 500 for 08132797047 at discount of 2(490)', 'Mon 31-Mar-2025 08:48 pm'),
(1231, 'HJML1G14XG', 'Ref||51908547958948628728||528571265', 'Airtime', '08057010145', 'GLO', 'success', '4406', '3406', '980', '', 'Airtime purchase of 1,000 for 08057010145 at discount of 2(980)', 'Tue 01-Apr-2025 09:04 pm'),
(1236, 'HJML1G14XG', 'Ref||7982821176||1009220624', 'Data', '08073413608', 'GLO', 'success', '2226', '1786', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 440', 'Fri, 04-Apr-2025 06:11 pm'),
(1238, 'HJML1G14XG', 'Ref||8063975859||940032871', 'Data', '08059420256', 'GLO', 'success', '1786', '1346', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Sat, 05-Apr-2025 09:33 pm'),
(1242, 'HJML1G14XG', 'Ref||6955745809||20228503', 'Data', '08073413608', 'GLO', 'success', '4276', '3836', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 440', 'Tue, 08-Apr-2025 01:33 pm'),
(1243, 'HJML1G14XG', 'Ref||9857881274||1625244136', 'Data', '08059420256', 'GLO', 'success', '3836', '3396', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Fri, 11-Apr-2025 10:02 am'),
(1250, 'HJML1G14XG', 'Ref||65063825599784177682||1141722855', 'Airtime', '07038878002', 'MTN', 'success', '3396', '3296', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Sun 13-Apr-2025 04:56 pm'),
(1251, 'HJML1G14XG', 'Ref||4537959883||513496433', 'Data', '08073413608', 'GLO', 'success', '2598', '2158', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 440', 'Mon, 14-Apr-2025 07:49 pm'),
(1257, 'HJML1G14XG', 'Ref||8485992771||834502519', 'Data', '08059420256', 'GLO', 'success', '2158', '1718', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Thu, 17-Apr-2025 10:16 am'),
(1258, 'HJML1G14XG', 'Ref||18479182074385695586||373599680', 'Airtime', '07038878002', 'MTN', 'success', '1718', '1618', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Thu 17-Apr-2025 01:52 pm'),
(1259, 'HJML1G14XG', 'Ref||9428652483||311266783', 'Data', '08073413608', 'GLO', 'success', '1620', '1180', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 440', 'Thu, 17-Apr-2025 02:16 pm'),
(1261, 'HJML1G14XG', 'Ref||8589818466||1141421331', 'Data', '08073413608', 'GLO', 'success', '1180', '740', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08073413608 for amount of NGN 440', 'Fri, 18-Apr-2025 06:14 pm'),
(1262, 'HJML1G14XG', 'Ref||88787692619802453657||913459562', 'Airtime', '08131537870', 'MTN', 'success', '4840', '4740', '98', '', 'Airtime purchase of 100 for 08131537870 at discount of 2(98)', 'Sat 19-Apr-2025 04:12 pm'),
(1263, 'HJML1G14XG', 'Ref||68168939747540619852||183600524', 'Airtime', '08077768505', 'GLO', 'success', '4742', '4642', '98', '', 'Airtime purchase of 100 for 08077768505 at discount of 2(98)', 'Sat 19-Apr-2025 06:14 pm'),
(1264, 'HJML1G14XG', 'Ref||27915376136289888955||834933084', 'Airtime', '07040273723', 'MTN', 'success', '4644', '4544', '98', '', 'Airtime purchase of 100 for 07040273723 at discount of 2(98)', 'Sat 19-Apr-2025 06:15 pm'),
(1269, 'HJML1G14XG', 'Ref||8986768231||685224898', 'Data', '08059420256', 'GLO', 'success', '3146', '2706', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Thu, 24-Apr-2025 08:38 am'),
(1273, 'HJML1G14XG', 'Ref||16988636450895529317||1702942503', 'Airtime', '07038878002', 'MTN', 'success', '1826', '1726', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Sat 26-Apr-2025 12:28 pm'),
(1279, 'HJML1G14XG', 'Ref||8693117480||430352495', 'Data', '07059861010', 'GLO', 'success', '1728', '1288', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 07059861010 for amount of NGN 440', 'Mon, 28-Apr-2025 08:14 pm'),
(1283, 'HJML1G14XG', 'Ref||4659709893||426850414', 'Data', '08073413608', 'GLO', 'success', '1288', '408', '880', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 880', 'Wed, 30-Apr-2025 08:22 am'),
(1284, 'HJML1G14XG', 'Ref||5071691288||1395674770', 'Data', '08059420256', 'GLO', 'success', '5408', '4968', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Wed, 30-Apr-2025 09:06 am'),
(1288, 'HJML1G14XG', 'Ref||3921542878||666599893', 'Data', '07059861010', 'GLO', 'success', '4978', '4098', '880', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 07059861010 for amount of NGN 880', 'Sat, 03-May-2025 09:03 am'),
(1291, 'HJML1G14XG', 'Ref||7165749306||503333583', 'Data', '08073413608', 'GLO', 'success', '4098', '3218', '880', '', 'Data purchase Of GLO CORPORATE 2GB   30 Days for 08073413608 for amount of NGN 880', 'Sat, 03-May-2025 06:52 pm'),
(1297, 'HJML1G14XG', 'Ref||7853958416||158208081', 'Data', '08059420256', 'GLO', 'success', '3218', '2778', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Sun, 04-May-2025 09:22 pm'),
(1298, 'HJML1G14XG', 'Ref||1128755748||1380086111', 'Data', '08059420256', 'GLO', 'success', '2778', '2338', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Mon, 05-May-2025 10:42 pm'),
(1299, 'HJML1G14XG', 'Ref||9269236475||1443377869', 'Data', '07059861010', 'GLO', 'success', '1898', '1458', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 07059861010 for amount of NGN 440', 'Wed, 07-May-2025 12:37 pm'),
(1300, 'HJML1G14XG', 'Ref||4145569389||1282874777', 'Data', '08059420256', 'GLO', 'success', '1458', '1238', '220', '', 'Data purchase Of GLO CORPORATE 500MB   30 Days for 08059420256 for amount of NGN 220', 'Thu, 08-May-2025 10:09 am'),
(1311, 'HJML1G14XG', 'Ref||49876584602182799833||1703320214', 'Airtime', '08059420256', 'GLO', 'success', '1238', '1038', '196', '', 'Airtime purchase of 200 for 08059420256 at discount of 2(196)', 'Mon 12-May-2025 09:58 am'),
(1312, 'HJML1G14XG', 'Ref||98969895877326588264||1707244732', 'Airtime', '07038878002', 'MTN', 'success', '1042', '842', '196', '', 'Airtime purchase of 200 for 07038878002 at discount of 2(196)', 'Mon 12-May-2025 09:59 am'),
(1313, 'HJML1G14XG', 'Ref||91838689778656495821||1235973919', 'Airtime', '08059420256', 'GLO', 'success', '846', '46', '784', '', 'Airtime purchase of 800 for 08059420256 at discount of 2(784)', 'Tue 13-May-2025 02:17 pm'),
(1314, 'HJML1G14XG', 'Ref||68235582608348698897||1095251509', 'Airtime', '07038878002', 'MTN', 'success', '62', '2', '58', '', 'Airtime purchase of 60 for 07038878002 at discount of 2(58)', 'Tue 13-May-2025 02:19 pm'),
(1317, 'HJML1G14XG', 'Ref||02425786857898611958||1067154829', 'Airtime', '07036370447', 'MTN', 'success', '5004', '4504', '490', '', 'Airtime purchase of 500 for 07036370447 at discount of 2(490)', 'Thu 29-May-2025 11:17 am'),
(1318, 'HJML1G14XG', 'Ref||6959287436||720557802', 'Data', '08059420256', 'GLO', 'success', '4514', '4074', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Thu, 29-May-2025 10:17 pm'),
(1319, 'HJML1G14XG', 'Ref||1868818364||484937822', 'Data', '08168294236', 'MTN', 'success', '4074', '3254', '820', '', 'Data purchase Of MTN SME 1GB   30 days for 08168294236 for amount of NGN 820', 'Wed, 04-Jun-2025 09:19 am'),
(1320, 'HJML1G14XG', 'Ref||57529841678538289989||915550617', 'Airtime', '08168294236', 'MTN', 'success', '3254', '2754', '490', '', 'Airtime purchase of 500 for 08168294236 at discount of 2(490)', 'Wed 04-Jun-2025 09:32 am'),
(1321, 'HJML1G14XG', 'Ref||03877898653892975142||45884435', 'Airtime', '07036370447', 'MTN', 'success', '2764', '1264', '1470', '', 'Airtime purchase of 1,500 for 07036370447 at discount of 2(1470)', 'Wed 04-Jun-2025 09:39 am'),
(1322, 'HJML1G14XG', 'Ref||3661259818||1192604188', 'Data', '08059420256', 'GLO', 'success', '1294', '854', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Mon, 09-Jun-2025 09:19 pm'),
(1323, 'HJML1G14XG', 'Ref||90217583888834529679||1659747069', 'Airtime', '07038878002', 'MTN', 'success', '854', '754', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Fri 13-Jun-2025 05:19 pm'),
(1324, 'HJML1G14XG', 'Ref||89095552677646398198||18390480', 'Airtime', '07038878002', 'MTN', 'success', '756', '656', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Thu 19-Jun-2025 05:20 pm'),
(1325, 'HJML1G14XG', 'Ref||8673885127||979166133', 'Data', '08059420256', 'GLO', 'success', '658', '218', '440', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 440', 'Fri, 27-Jun-2025 11:26 am'),
(1326, 'HJML1G14XG', 'Ref||19163524025848596797||1576648492', 'Airtime', '08059420256', 'GLO', 'success', '218', '118', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Wed 02-Jul-2025 11:24 am'),
(1327, 'HJML1G14XG', 'Ref||52838986088762341958||1684783552', 'Airtime', '07038878002', 'MTN', 'success', '4700', '4500', '196', '', 'Airtime purchase of 200 for 07038878002 at discount of 2(196)', 'Mon 07-Jul-2025 11:58 am'),
(1328, 'HJML1G14XG', 'Ref||5179898283||233022488', 'Data', '08059420256', 'GLO', 'success', '4504', '4084', '420', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 420', 'Thu, 10-Jul-2025 09:04 am'),
(1329, 'HJML1G14XG', 'Ref||3250779748||394229670', 'Data', '08059420256', 'GLO', 'success', '4084', '3664', '420', '', 'Data purchase Of GLO CORPORATE 1GB   30 Days for 08059420256 for amount of NGN 420', 'Wed, 16-Jul-2025 09:45 pm'),
(1330, 'HJML1G14XG', 'Ref||77383894185965849068||1706366668', 'Airtime', '08059420256', 'GLO', 'success', '3664', '3564', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Sat 19-Jul-2025 06:15 am'),
(1342, 'HJML1G14XG', 'Ref||2098583196||535641964', 'Data', '08059420256', 'GLO', 'success', '3146', '2726', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Fri 01-Aug-2025 08:29 pm'),
(1350, 'HJML1G14XG', 'Ref||1786867824||304674802', 'Data', '08059420256', 'GLO', 'success', '2726', '2306', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Sat 09-Aug-2025 10:00 am'),
(1351, 'HJML1G14XG', 'Ref||2596767385||1561568556', 'Data', '07059861010', 'GLO', 'success', '2306', '1466', '840', '', 'Data purchase of 840 for 07059861010 at discount of 0% (840)', 'Sat 09-Aug-2025 02:07 pm'),
(1355, 'BF19VI08UL', 'Ref||78886925978906643512||1427891836', 'Airtime', '08100323012', 'MTN', 'success', '2729.03', '2629.03', '98', '', 'Airtime purchase of 100 for 08100323012 at discount of 2(98)', 'Thu 14-Aug-2025 01:52 pm'),
(1356, 'HJML1G14XG', 'Ref||5617194438||174342852', 'Data', '08059420256', 'GLO', 'success', '1466', '1046', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Thu 14-Aug-2025 08:50 pm'),
(1360, 'HJML1G14XG', 'Ref||88591604325469587671||320988311', 'Airtime', '07038878002', 'MTN', 'success', '1046', '946', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Sat 16-Aug-2025 08:24 pm'),
(1362, 'HJML1G14XG', 'Ref||7072154397||177275189', 'Data', '08059420256', 'GLO', 'success', '948', '528', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 18-Aug-2025 10:35 am'),
(1365, 'HJML1G14XG', 'Ref||90839787855435189624||792527431', 'Airtime', '07038878002', 'MTN', 'success', '528', '428', '98', '', 'Airtime purchase of 100 for 07038878002 at discount of 2(98)', 'Wed 20-Aug-2025 07:11 am'),
(1367, 'HJML1G14XG', 'Ref||94764368915985219688||1626229088', 'Airtime', '08059420256', 'GLO', 'success', '430', '330', '98', '', 'Airtime purchase of 100 for 08059420256 at discount of 2(98)', 'Thu 21-Aug-2025 07:04 am'),
(1371, 'BF19VI08UL', 'Ref||94719736468858285896||650478128', 'Airtime', '08100323012', 'MTN', 'success', '2631.03', '2533.03', '98', '', 'Airtime purchase of ?100 for 08100323012 at discount of 2% (?98)', 'Sun 24-Aug-2025 08:13 pm'),
(1372, 'HJML1G14XG', 'Ref||3385676924||499385923', 'Data', '08059420256', 'GLO', 'success', '332', '122', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Mon 25-Aug-2025 05:10 pm'),
(1373, 'HJML1G14XG', 'Ref||59789466928078588746||1229859204', 'Airtime', '08059420256', 'GLO', 'success', '5122', '5024', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Wed 27-Aug-2025 12:16 pm'),
(1374, 'HJML1G14XG', 'Ref||8528637948||593140218', 'Data', '08059420256', 'GLO', 'success', '5024', '4814', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Wed 27-Aug-2025 12:17 pm'),
(1378, '0HU6OC54V2', 'Ref||83989468781695925273||195264715', 'Airtime', '09025855796', 'AIRTEL', 'success', '10010', '9716', '294', '', 'Airtime purchase of ?300 for 09025855796 at discount of 2% (?294)', 'Sun 31-Aug-2025 05:19 pm'),
(1379, 'HJML1G14XG', 'Ref||4623356158||1074379097', 'Data', '08059420256', 'GLO', 'success', '4814', '4394', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Sun 31-Aug-2025 06:55 pm'),
(1380, '0HU6OC54V2', 'Ref||7091789652||1702957553', 'Data', '09151062120', 'GLO', 'failed', '9716', '9716', '210', '', 'Failed data purchase of 210 for 09151062120 on GLO', 'Thu 04-Sep-2025 12:15 pm'),
(1381, '0HU6OC54V2', 'Ref||9717548082||1023182189', 'Data', '09151062120', 'GLO', 'success', '9716', '9296', '420', '', 'Data purchase of 420 for 09151062120 at discount of 0% (420)', 'Thu 04-Sep-2025 08:21 pm'),
(1382, 'HJML1G14XG', 'Ref||7409598237||386966338', 'Data', '08059420256', 'GLO', 'success', '4394', '3974', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Sat 06-Sep-2025 07:12 am'),
(1383, 'HJML1G14XG', 'Ref||97649582762390479818||1254863984', 'Airtime', '07019024848', 'AIRTEL', 'success', '3974', '3876', '98', '', 'Airtime purchase of ?100 for 07019024848 at discount of 2% (?98)', 'Sat 06-Sep-2025 03:17 pm'),
(1384, '0HU6OC54V2', 'Ref||16814057596889732293||840276216', 'Airtime', '08144401198', 'MTN', 'success', '9296', '9100', '196', '', 'Airtime purchase of ?200 for 08144401198 at discount of 2% (?196)', 'Sat 06-Sep-2025 08:48 pm'),
(1385, '0HU6OC54V2', 'Ref||73188165994496287359||243329985', 'Airtime', '08144401198', 'MTN', 'failed', '9100', '9100', '98', '', 'Airtime purchase of ?100 for 08144401198 failed. Refunded ?98', 'Sun 07-Sep-2025 08:11 am'),
(1386, '0HU6OC54V2', 'Ref||88707355316995188228||126121232', 'Airtime', '08144401198', 'MTN', 'failed', '9100', '9100', '98', '', 'Airtime purchase of ?100 for 08144401198 failed. Refunded ?98', 'Sun 07-Sep-2025 08:24 am'),
(1387, '0HU6OC54V2', 'Ref||64584935839605878992||958114406', 'Airtime', '08144401198', 'MTN', 'success', '9100', '9002', '98', '', 'Airtime purchase of ?100 for 08144401198 at discount of 2% (?98)', 'Sun 07-Sep-2025 08:45 am'),
(1388, '0HU6OC54V2', 'Ref||7781639798||931752226', 'Data', '08055295099', 'GLO', 'success', '9002', '8582', '420', '', 'Data purchase of 420 for 08055295099 at discount of 0% (420)', 'Sun 07-Sep-2025 07:45 pm'),
(1389, 'HJML1G14XG', 'Ref||84536559870736827819||791568281', 'Airtime', '08059420256', 'GLO', 'success', '3876', '3778', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Tue 09-Sep-2025 02:58 pm'),
(1390, 'HJML1G14XG', 'Ref||8607299578||1030203847', 'Data', '08059420256', 'GLO', 'success', '3778', '3358', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Wed 10-Sep-2025 08:56 am'),
(1391, 'HJML1G14XG', 'Ref||98975805946562964878||1091966119', 'Airtime', '09130585738', 'MTN', 'success', '3358', '2378', '980', '', 'Airtime purchase of ?1,000 for 09130585738 at discount of 2% (?980)', 'Fri 12-Sep-2025 11:02 am'),
(1392, 'HJML1G14XG', 'Ref||87786853397845820985||722449615', 'Airtime', '08059420256', 'GLO', 'success', '2378', '2280', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Sat 13-Sep-2025 10:27 am'),
(1393, 'HJML1G14XG', 'Ref||48581723199827675588||1594092549', 'Airtime', '07036370447', 'MTN', 'failed', '2280', '2280', '490', '', 'Airtime purchase of ?500 for 07036370447 failed. Refunded ?490', 'Sun 14-Sep-2025 10:57 am'),
(1394, 'HJML1G14XG', 'Ref||85999386192517848877||623298681', 'Airtime', '07036370447', 'MTN', 'failed', '2280', '2280', '490', '', 'Airtime purchase of ?500 for 07036370447 failed. Refunded ?490', 'Sun 14-Sep-2025 10:59 am'),
(1395, 'HJML1G14XG', 'Ref||5969828632||236310286', 'Data', '08059420256', 'GLO', 'success', '2280', '1860', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 15-Sep-2025 07:49 am'),
(1396, 'HJML1G14XG', 'Ref||80549789718166429755||889052095', 'Airtime', '07038878002', 'MTN', 'success', '1860', '1762', '98', '', 'Airtime purchase of ?100 for 07038878002 at discount of 2% (?98)', 'Tue 16-Sep-2025 09:59 am'),
(1397, 'HJML1G14XG', 'Ref||2386469487||1340431096', 'Data', '08149980190', 'MTN', 'failed', '1762', '1762', '390', '', 'Failed data purchase of 390 for 08149980190 on MTN', 'Tue 16-Sep-2025 12:38 pm'),
(1398, 'HJML1G14XG', 'Ref||5567919647||684046295', 'Data', '08149980190', 'MTN', 'failed', '1762', '1762', '390', '', 'Failed data purchase of 390 for 08149980190 on MTN', 'Tue 16-Sep-2025 12:38 pm'),
(1399, 'HJML1G14XG', 'Ref||7632642115||1240355807', 'Data', '08149980190', 'MTN', 'failed', '1762', '1762', '390', '', 'Failed data purchase of 390 for 08149980190 on MTN', 'Tue 16-Sep-2025 12:47 pm'),
(1400, 'HJML1G14XG', 'Ref||8321958684||140170300', 'Data', '08149980190', 'MTN', 'failed', '1762', '1762', '390', '', 'Failed data purchase of 390 for 08149980190 on MTN', 'Tue 16-Sep-2025 12:48 pm'),
(1401, 'HJML1G14XG', 'Ref||5978907216||351058906', 'Data', '09067969009', 'AIRTEL', 'failed', '1762', '1762', '500', '', 'Failed data purchase of 500 for 09067969009 on AIRTEL', 'Tue 16-Sep-2025 12:51 pm'),
(1402, 'HJML1G14XG', 'Ref||3978755189||588117709', 'Data', '09067969009', 'AIRTEL', 'failed', '1762', '1762', '500', '', 'Failed data purchase of 500 for 09067969009 on AIRTEL', 'Tue 16-Sep-2025 12:52 pm'),
(1403, 'HJML1G14XG', 'Ref||42196284735978916688||1282093887', 'Airtime', '09067969009', 'AIRTEL', 'failed', '1762', '1762', '490', '', 'Airtime purchase of ?500 for 09067969009 failed. Refunded ?490', 'Tue 16-Sep-2025 12:53 pm'),
(1404, 'HJML1G14XG', 'Ref||74562137993658888098||1446363698', 'Airtime', '08059420256', 'GLO', 'success', '1762', '1566', '196', '', 'Airtime purchase of ?200 for 08059420256 at discount of 2% (?196)', 'Wed 17-Sep-2025 10:04 am'),
(1405, 'HJML1G14XG', 'Ref||5685128898||677373135', 'Data', '08059420256', 'GLO', 'success', '1566', '1146', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Fri 19-Sep-2025 06:33 am'),
(1406, 'HJML1G14XG', 'Ref||17799988318657852034||911508775', 'Airtime', '08059420256', 'GLO', 'success', '1146', '1048', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Fri 19-Sep-2025 02:02 pm'),
(1407, 'HJML1G14XG', 'Ref||1887795985||1307281418', 'Data', '08059420256', 'GLO', 'success', '1048', '628', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Sun 21-Sep-2025 05:10 pm'),
(1408, 'HJML1G14XG', 'Ref||6814988597||640351281', 'Data', '08059420256', 'GLO', 'failed', '628', '628', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Thu 25-Sep-2025 10:44 am'),
(1409, 'HJML1G14XG', 'Ref||6839685428||991218332', 'Data', '08059420256', 'GLO', 'failed', '628', '628', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Thu 25-Sep-2025 10:44 am'),
(1410, 'HJML1G14XG', 'Ref||8754628565||1090634612', 'Data', '08059420256', 'GLO', 'failed', '628', '628', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Thu 25-Sep-2025 10:44 am'),
(1411, 'HJML1G14XG', 'Ref||9868412874||1514195047', 'Data', '08059420256', 'GLO', 'failed', '628', '628', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Thu 25-Sep-2025 11:07 am'),
(1412, 'HJML1G14XG', 'Ref||91682958148968453759||1596666053', 'Airtime', '08059420256', 'GLO', 'success', '5208', '5110', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Sun 28-Sep-2025 05:49 pm'),
(1413, 'HJML1G14XG', 'Ref||5963877688||553636632', 'Data', '08059420256', 'GLO', 'success', '5110', '4690', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 29-Sep-2025 09:04 pm'),
(1414, 'HJML1G14XG', 'Ref||07119268454668539899||549373122', 'Airtime', '08059420256', 'GLO', 'success', '4690', '4592', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Thu 02-Oct-2025 03:49 pm'),
(1415, 'HJML1G14XG', 'Ref||1488290489||1484856333', 'Data', '08059420256', 'GLO', 'success', '4592', '4172', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 06-Oct-2025 12:06 am'),
(1416, 'HJML1G14XG', 'Ref||91771483904269698858||1708358811', 'Airtime', '08059420256', 'GLO', 'success', '4172', '4074', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Tue 07-Oct-2025 05:49 am'),
(1417, 'HJML1G14XG', 'Ref||6029776978||539590654', 'Data', '08059420256', 'GLO', 'success', '4074', '3654', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Wed 08-Oct-2025 03:24 pm'),
(1418, 'HJML1G14XG', 'Ref||5958487817||1574930999', 'Data', '08059420256', 'GLO', 'success', '3654', '3234', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 13-Oct-2025 02:17 pm'),
(1419, 'HJML1G14XG', 'Ref||13871745596386896809||313416529', 'Airtime', '08059420256', 'GLO', 'success', '3234', '3136', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Mon 13-Oct-2025 05:39 pm'),
(1420, 'HJML1G14XG', 'Ref||9828578305||39096394', 'Data', '08059420256', 'GLO', 'failed', '3136', '3136', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Sat 18-Oct-2025 07:42 am'),
(1421, 'HJML1G14XG', 'Ref||8866851940||1586673786', 'Data', '08059420256', 'GLO', 'failed', '3136', '3136', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Sat 18-Oct-2025 07:43 am'),
(1422, 'HJML1G14XG', 'Ref||9835669788||233229598', 'Data', '08059420256', 'GLO', 'failed', '3136', '3136', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Sat 18-Oct-2025 07:44 am'),
(1423, 'HJML1G14XG', 'Ref||78858057598249661398||622184530', 'Airtime', '08059420256', 'GLO', 'success', '3136', '3038', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Sat 18-Oct-2025 11:42 am'),
(1424, 'HJML1G14XG', 'Ref||12957852948683879075||1451632903', 'Airtime', '08059420256', 'GLO', 'success', '2618', '2520', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Tue 21-Oct-2025 12:39 pm'),
(1425, 'HJML1G14XG', 'Ref||89182473886430965975||302843462', 'Airtime', '09053079973', 'GLO', 'success', '2520', '2324', '196', '', 'Airtime purchase of ?200 for 09053079973 at discount of 2% (?196)', 'Thu 23-Oct-2025 09:23 am'),
(1426, 'HJML1G14XG', 'Ref||4018856642||214985171', 'Data', '08059420256', 'GLO', 'success', '2324', '1904', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Thu 23-Oct-2025 07:44 pm'),
(1427, 'HJML1G14XG', 'Ref||68898353917948556782||1720805550', 'Airtime', '09130585738', 'MTN', 'failed', '1904', '1904', '686', '', 'Airtime purchase of ?700 for 09130585738 failed. Refunded ?686', 'Sun 26-Oct-2025 06:47 pm'),
(1428, 'HJML1G14XG', 'Ref||48198937856565929886||1426835515', 'Airtime', '09130585738', 'MTN', 'failed', '1904', '1904', '686', '', 'Airtime purchase of ?700 for 09130585738 failed. Refunded ?686', 'Sun 26-Oct-2025 06:48 pm'),
(1429, 'HJML1G14XG', 'Ref||25847763788495926819||474136727', 'Airtime', '09130585738', 'MTN', 'failed', '1904', '1904', '490', '', 'Airtime purchase of ?500 for 09130585738 failed. Refunded ?490', 'Sun 26-Oct-2025 06:50 pm'),
(1430, 'HJML1G14XG', 'Ref||86890132796654273971||136395210', 'Airtime', '09130585738', 'MTN', 'failed', '1904', '1904', '294', '', 'Airtime purchase of ?300 for 09130585738 failed. Refunded ?294', 'Sun 26-Oct-2025 06:51 pm'),
(1431, 'HJML1G14XG', 'Ref||14892798988755360956||1408922468', 'Airtime', '09130585738', 'MTN', 'failed', '1904', '1904', '490', '', 'Airtime purchase of ?500 for 09130585738 failed. Refunded ?490', 'Sun 26-Oct-2025 06:56 pm'),
(1432, 'HJML1G14XG', 'Ref||6539868732||1745180229', 'Data', '08059420256', 'GLO', 'success', '1904', '1694', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Sun 26-Oct-2025 06:58 pm'),
(1433, 'HJML1G14XG', 'Ref||3918125874||321502381', 'Data', '08059420256', 'GLO', 'success', '1694', '1484', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Wed 29-Oct-2025 08:49 am'),
(1434, 'HJML1G14XG', 'Ref||88531893465487956287||1342303811', 'Airtime', '08059420256', 'GLO', 'success', '1484', '1386', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Thu 30-Oct-2025 06:21 am'),
(1435, 'HJML1G14XG', 'Ref||2882649863||966268346', 'Data', '08059420256', 'GLO', 'success', '1386', '966', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Fri 31-Oct-2025 08:36 am'),
(1436, 'HJML1G14XG', 'Ref||89108619756453397675||1389735347', 'Airtime', '09130585738', 'MTN', 'success', '966', '378', '588', '', 'Airtime purchase of ?600 for 09130585738 at discount of 2% (?588)', 'Fri 31-Oct-2025 06:44 pm'),
(1437, 'HJML1G14XG', 'Ref||7586441377||97008172', 'Data', '08059420256', 'GLO', 'success', '378', '168', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Wed 05-Nov-2025 03:55 pm'),
(1438, 'HJML1G14XG', 'Ref||89186678307146949282||1061583752', 'Airtime', '08059939108', 'GLO', 'success', '5168', '4972', '196', '', 'Airtime purchase of ?200 for 08059939108 at discount of 2% (?196)', 'Thu 06-Nov-2025 03:46 pm'),
(1439, 'HJML1G14XG', 'Ref||9542369986||290979626', 'Data', '08059420256', 'GLO', 'success', '4972', '4762', '210', '', 'Data purchase of 210 for 08059420256 at discount of 0% (210)', 'Fri 07-Nov-2025 12:13 pm'),
(1440, 'HJML1G14XG', 'Ref||65583891378886982495||201067288', 'Airtime', '09130585738', 'MTN', 'failed', '4762', '4762', '980', '', 'Airtime purchase of ?1,000 for 09130585738 failed. Refunded ?980', 'Fri 07-Nov-2025 06:17 pm'),
(1441, 'HJML1G14XG', 'Ref||88397419532629158748||1231117436', 'Airtime', '08059420256', 'GLO', 'success', '4762', '4664', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Sun 09-Nov-2025 02:48 pm'),
(1442, 'HJML1G14XG', 'Ref||9893861887||1266994755', 'Data', '08059420256', 'GLO', 'failed', '4664', '4664', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Mon 10-Nov-2025 02:29 pm'),
(1443, 'HJML1G14XG', 'Ref||7756486887||452720016', 'Data', '08059420256', 'GLO', 'failed', '4664', '4664', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Mon 10-Nov-2025 02:32 pm'),
(1444, 'HJML1G14XG', 'Ref||0728734987||994321449', 'Data', '08059420256', 'GLO', 'failed', '4664', '4664', '420', '', 'Failed data purchase of 420 for 08059420256 on GLO', 'Mon 10-Nov-2025 02:34 pm'),
(1445, 'HJML1G14XG', 'Ref||6088543871||507432810', 'Data', '08059420256', 'GLO', 'success', '4664', '4244', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 10-Nov-2025 03:40 pm'),
(1446, 'HJML1G14XG', 'Ref||14735658879828024166||1555029042', 'Airtime', '08059420256', 'GLO', 'success', '3824', '3726', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Fri 14-Nov-2025 04:24 pm'),
(1447, 'HJML1G14XG', 'Ref||1098796889||493307685', 'Data', '08059420256', 'GLO', 'success', '3726', '3306', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Mon 17-Nov-2025 04:50 pm'),
(1448, 'HJML1G14XG', 'Ref||92061375748879623569||1752778602', 'Airtime', '08059420256', 'GLO', 'success', '3306', '3208', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Thu 20-Nov-2025 01:55 pm'),
(1449, 'HJML1G14XG', 'Ref||3843188720||720048439', 'Data', '08059420256', 'GLO', 'success', '3208', '2788', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Fri 21-Nov-2025 07:41 pm'),
(1450, 'HJML1G14XG', 'Ref||8293183966||378193082', 'Data', '07038878002', 'MTN', 'success', '2368', '1978', '390', '', 'Data purchase of 390 for 07038878002 at discount of 0% (390)', 'Sat 29-Nov-2025 05:26 pm'),
(1451, 'HJML1G14XG', 'Ref||7644995828||1650782771', 'Data', '08059420256', 'GLO', 'success', '1978', '1558', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Fri 05-Dec-2025 10:41 pm'),
(1452, 'HJML1G14XG', 'Ref||59872419786934697530||163813413', 'Airtime', '08059420256', 'GLO', 'success', '1558', '1460', '98', '', 'Airtime purchase of ?100 for 08059420256 at discount of 2% (?98)', 'Sun 07-Dec-2025 07:56 pm'),
(1453, 'BF19VI08UL', '', 'Wallet Topup', '', 'PalmPay', 'success', '0.00', '0.00', '98.80', 'PALM||7899977568||964667696', 'Wallet Funding of NGN 100.00 via  (PalmPay) (Fee: NGN 1.20, Settled: NGN 98.80)', 'Tue 09-Dec-2025 01:44 pm'),
(1454, 'BF19VI08UL', 'MPVAT-P_20251209134742227_924034987_K2WMS_qgpfx', 'Wallet Topup', '', 'Paga', 'success', '0.00', '0.00', '98.80', 'PAGA||8344978887||1540112205', 'Wallet Funding of NGN 100.00 via BANK_TRANSFER (Paga) (Fee: NGN 1.20, Settled: NGN 98.80)', 'Tue 09-Dec-2025 01:47 pm'),
(1455, 'HJML1G14XG', 'Ref||55842386147906177568||1163835095', 'Data', '07038878002', 'GLO', 'success', '1460', '1040', '420', '', 'Data purchase of 420 for 08059420256 at discount of 0% (420)', 'Thu 10-Dec-2025 10:00 pm'),
(1456, 'BF19VI08UL', 'Ref||8685275196||4206963', 'Data', '09151062120', 'GLO', 'failed', '7430.63', '7430.63', '63', '', 'Failed data purchase of 63.60 for 09151062120 on GLO', 'Thu 11-Dec-2025 07:48 pm'),
(1457, 'BF19VI08UL', 'Ref||8864552173||614757715', 'Data', '09151062120', 'GLO', 'failed', '7493.63', '7493.63', '57', '', 'Failed data purchase of 57.50 for 09151062120 on GLO', 'Fri 12-Dec-2025 12:09 pm'),
(1458, 'BF19VI08UL', 'Ref||5990719844||170552512', 'Data', '09151062120', 'GLO', 'failed', '7550.63', '7550.63', '100', '', 'Failed data purchase of 100.00 for 09151062120 on GLO', 'Fri 12-Dec-2025 12:38 pm'),
(1459, 'BF19VI08UL', 'Ref||8691882838||191134540', 'Data', '09151062120', 'GLO', 'failed', '7650.63', '7650.63', '100', '', 'Failed data purchase of 100.00 for 09151062120 on GLO', 'Fri 12-Dec-2025 01:48 pm'),
(1460, 'BF19VI08UL', 'Ref||4852889697||791847630', 'Data', '09151062120', 'GLO', 'success', '7750.63', '7650.63', '100', '', 'Data purchase of 100.00 for 09151062120 via Gladtidings', 'Fri 12-Dec-2025 02:04 pm'),
(1461, 'BF19VI08UL', 'Ref||4786996855||1577170921', 'Data', '09151062120', 'GLO', 'success', '7650.63', '7550.63', '100', '', '200 MB data purchase for 09151062120 was successful', 'Fri 12-Dec-2025 02:23 pm'),
(1462, 'BF19VI08UL', 'Ref||8307968251||505575003', 'Airtime', '08100323012', 'MTN', 'failed', '7550.63', '7550.63', '98', '', 'Failed airtime purchase of ?100.00 for 08100323012', 'Fri 12-Dec-2025 05:20 pm'),
(1463, 'BF19VI08UL', 'Ref||6490834895||816276493', 'Airtime', '08100323012', 'MTN', 'success', '7648.63', '7550.63', '98', '', 'Airtime purchase of ?100.00 for 08100323012 was successful', 'Fri 12-Dec-2025 05:23 pm'),
(1464, 'BF19VI08UL', 'Ref||2897775031||1128431136', 'Airtime', '08100323012', 'MTN', 'success', '7550.63', '7451.63', '99', '', 'Airtime purchase of ?100.00 for 08100323012 was successful', 'Fri 12-Dec-2025 06:38 pm'),
(1465, 'BF19VI08UL', 'Ref||7682359948||117496646', 'Data', '09151062120', 'GLO', 'success', '7451.63', '7351.63', '100', '', '200 MB data purchase for 09151062120 was successful', 'Fri 12-Dec-2025 06:54 pm'),
(1466, 'HJML1G14XG', 'Ref||8590879873||1397725483', 'Airtime', '08059420256', 'GLO ', 'success', '1040', '941', '99', '', 'Airtime purchase of ?100.00 for 08059420256 was successful', 'Mon 15-Dec-2025 12:27 pm'),
(1467, 'HJML1G14XG', 'Ref||8591869608||1703731567', 'Data', '08059420256', 'GLO', 'success', '941', '691', '250', '', '500 MB data purchase for 08059420256 was successful', 'Mon 15-Dec-2025 12:29 pm'),
(1468, 'HJML1G14XG', 'Ref||5882961438||304335064', 'Data', '08059420256', 'GLO', 'success', '691', '441', '250', '', '500 MB data purchase for 08059420256 was successful', 'Mon 15-Dec-2025 12:30 pm'),
(1469, 'BF19VI08UL', 'MPVAT-P_20251215155643692_928911583_QDRP9_d6l6g', 'Wallet Topup', '', 'Paga', 'success', '0.00', '0.00', '98.80', 'PAGA||8829064965||1014190872', 'Wallet Funding of NGN 100.00 via BANK_TRANSFER (Paga) (Fee: NGN 1.20, Settled: NGN 98.80)', 'Mon 15-Dec-2025 03:56 pm');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `api_network_mapping`
--
ALTER TABLE `api_network_mapping`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_api_network` (`api_service`,`network_name`);

--
-- Indexes for table `api_transaction_logs`
--
ALTER TABLE `api_transaction_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_transaction_id` (`transaction_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `bank_availability`
--
ALTER TABLE `bank_availability`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `bank_provider` (`bank_code`,`provider`);

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

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

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

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

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

--
-- Indexes for table `lynx_coupon`
--
ALTER TABLE `lynx_coupon`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `code` (`code`),
  ADD KEY `idx_code` (`code`),
  ADD KEY `idx_status` (`status`),
  ADD KEY `idx_expiry` (`expiry_date`);

--
-- Indexes for table `lynx_coupon_claims`
--
ALTER TABLE `lynx_coupon_claims`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `unique_user_coupon` (`user_id`,`coupon_id`),
  ADD KEY `idx_user_id` (`user_id`),
  ADD KEY `idx_coupon_id` (`coupon_id`),
  ADD KEY `idx_claim_date` (`claim_date`);

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

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

--
-- Indexes for table `provider_discounts`
--
ALTER TABLE `provider_discounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `provider_service` (`provider`,`service_type`);

--
-- 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`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- 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=186;

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `lynx_coupon_claims`
--
ALTER TABLE `lynx_coupon_claims`
  ADD CONSTRAINT `lynx_coupon_claims_ibfk_1` FOREIGN KEY (`coupon_id`) REFERENCES `lynx_coupon` (`id`) ON DELETE CASCADE;
COMMIT;

