-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 13, 2026 at 05:55 PM
-- Server version: 10.6.23-MariaDB-cll-lve
-- PHP Version: 8.4.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `bectelec_fluterupdate`
--

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

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

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
