-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 18, 2025 at 03:40 PM
-- Server version: 10.6.23-MariaDB-cll-lve
-- PHP Version: 8.4.14

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 `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
(543, NULL, '426', '611', '15gb_gifting_1day_48967', '1.5 GB', 'GIFTING', 'airtel', 625.00, 500.00, 475.00, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(544, NULL, '473', '432', '18gb_gifting_30days_73109', '18 GB', 'GIFTING', 'airtel', 7500.00, 6000.00, 5700.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(545, NULL, '513', '612', '1gb_gifting_3days_24953', '1 GB', 'GIFTING', 'airtel', 375.00, 300.00, 285.00, '3 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(546, NULL, '427', '617', '2gb_gifting_2days_80458', '2 GB', 'GIFTING', 'airtel', 750.00, 600.00, 570.00, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(547, NULL, '437', '476', '150mb_sme_1day_31960', '150 MB', 'SME', 'airtel', 87.50, 70.00, 66.50, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(548, NULL, '518', '436', '160gb_gifting_30days_27842', '160 GB', 'GIFTING', 'airtel', 37500.00, 30000.00, 28500.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(549, NULL, '475', '434', '35gb_gifting_30days_26566', '35 GB', 'GIFTING', 'airtel', 12500.00, 10000.00, 9500.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(550, NULL, '560', '478', '600mb_sme_2days_33705', '600 MB', 'SME', 'airtel', 275.00, 220.00, 209.00, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(551, NULL, '474', '431', '25gb_gifting_30days_63383', '25 GB', 'GIFTING', 'airtel', 10000.00, 8000.00, 7600.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(552, NULL, '472', '430', '13gb_gifting_30days_87730', '13 GB', 'GIFTING', 'airtel', 6250.00, 5000.00, 4750.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(553, NULL, '462', '429', '15gb_gifting_7days_57396', '1.5 GB', 'GIFTING', 'airtel', 1250.00, 1000.00, 950.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(554, NULL, '467', '427', '2gb_gifting_30days_60162', '2 GB', 'GIFTING', 'airtel', 1875.00, 1500.00, 1425.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(555, NULL, '462', '560', '1gb_gifting_7days_57143', '1 GB', 'GIFTING', 'airtel', 1250.00, 1000.00, 950.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(556, NULL, '429', '556', '32gb_gifting_2days_91986', '3.2 GB', 'GIFTING', 'airtel', 1250.00, 1000.00, 950.00, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(557, NULL, '512', '555', '300mb_gifting_1day_39396', '300 MB', 'GIFTING', 'airtel', 375.00, 300.00, 285.00, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(558, NULL, '519', '545', '210gb_gifting_30days_58285', '210 GB', 'GIFTING', 'airtel', 50000.00, 40000.00, 38000.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(559, NULL, '476', '558', '500mb_gifting_7days_54495', '500 MB', 'GIFTING', 'airtel', 625.00, 500.00, 475.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(560, NULL, '463', '561', '35gb_gifting_7days_51583', '3.5 GB', 'GIFTING', 'airtel', 1875.00, 1500.00, 1425.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(561, NULL, '465', '562', '10gb_gifting_7days_41205', '10 GB', 'GIFTING', 'airtel', 3750.00, 3000.00, 2850.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(562, NULL, '466', '563', '18gb_gifting_7days_41521', '18 GB', 'GIFTING', 'airtel', 6250.00, 5000.00, 4750.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(563, NULL, '468', '527', '3gb_gifting_30days_91699', '3 GB', 'GIFTING', 'airtel', 2500.00, 2000.00, 1900.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(564, NULL, '508', '526', '75mb_gifting_1day_52148', '75 MB', 'GIFTING', 'airtel', 93.75, 75.00, 71.25, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(565, NULL, '517', '568', '100gb_gifting_30days_54911', '100 GB', 'GIFTING', 'airtel', 25000.00, 20000.00, 19000.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(566, NULL, '444', '483', '10gb_sme_30days_21376', '10 GB', 'SME', 'airtel', 3875.00, 3100.00, 2945.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(567, NULL, '429', '481', '3gb_gifting_2days_43136', '3 GB', 'GIFTING', 'airtel', 1250.00, 1000.00, 950.00, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(568, NULL, '505', '209', '60gb_gifting_30days_41529', '60 GB', 'GIFTING', 'airtel', 18750.00, 15000.00, 14250.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(569, NULL, '521', '255', '350gb_gifting_30days_14958', '350 GB', 'GIFTING', 'airtel', 75000.00, 60000.00, 57000.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(570, NULL, '464', '241', '6gb_gifting_7days_32483', '6 GB', 'GIFTING', 'airtel', 3125.00, 2500.00, 2375.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(571, NULL, '513', '673', '1_gifting_3days_60091', '1', 'GIFTING', 'airtel', 375.00, 300.00, 285.00, '3 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(572, NULL, '478', '627', '4gb_gifting_30days_19141', '4 GB', 'GIFTING', 'airtel', 3125.00, 2500.00, 2375.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(573, NULL, '505', '677', '60mb_gifting_30days_65347', '60 MB', 'GIFTING', 'airtel', 60437.50, 48350.00, 45932.50, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(574, NULL, '471', '150', '10gb_gifting_30days_47222', '10 GB', 'GIFTING', 'airtel', 5000.00, 4000.00, 3800.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(575, NULL, '470', '149', '8gb_gifting_30days_47049', '8 GB', 'GIFTING', 'airtel', 3750.00, 3000.00, 2850.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(576, NULL, '427', '145', '15gb_gifting_2days_84753', '1.5 GB', 'GIFTING', 'airtel', 750.00, 600.00, 570.00, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(577, NULL, '557', '639', '15gb_sme_1day_84933', '1.5 GB', 'SME', 'airtel', 687.50, 550.00, 522.50, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(578, '632', '541', NULL, '1gb_corporate_3days_96162', '1 GB', 'CORPORATE', 'glo', 337.50, 270.00, 256.50, '3 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(579, '633', '542', NULL, '3gb_corporate_3days_22804', '3 GB', 'CORPORATE', 'glo', 1012.50, 810.00, 769.50, '3 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(580, '634', '543', NULL, '5gb_corporate_3days_82266', '5 GB', 'CORPORATE', 'glo', 1686.25, 1349.00, 1281.55, '3 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(581, '635', '538', NULL, '1gb_corporate_7days_75266', '1 GB', 'CORPORATE', 'glo', 393.75, 315.00, 299.25, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(582, '636', '539', NULL, '3gb_corporate_7days_98961', '3 GB', 'CORPORATE', 'glo', 1175.00, 940.00, 893.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(583, '637', '540', NULL, '5gb_corporate_7days_77209', '5 GB', 'CORPORATE', 'glo', 1962.50, 1570.00, 1491.50, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(584, '335', '325', NULL, '10gb_corporate_30days_27417', '10 GB', 'CORPORATE', 'glo', 5000.00, 4000.00, 3800.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(585, '329', '324', NULL, '5gb_corporate_30days_78929', '5 GB', 'CORPORATE', 'glo', 2500.00, 2000.00, 1900.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(586, '331', '327', NULL, '500mb_corporate_30days_88296', '500 MB', 'CORPORATE', 'glo', 250.00, 200.00, 190.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(587, '332', '322', NULL, '2gb_corporate_30days_16956', '2 GB', 'CORPORATE', 'glo', 1000.00, 800.00, 760.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(588, '333', '337', NULL, '200mb_corporate_14days_46113', '200 MB', 'CORPORATE', 'glo', 100.00, 80.00, 76.00, '14 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(589, '334', '321', NULL, '1gb_corporate_30days_15954', '1 GB', 'CORPORATE', 'glo', 420.00, 400.00, 380.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-15 15:28:28'),
(590, '336', '323', NULL, '3gb_corporate_30days_98964', '3 GB', 'CORPORATE', 'glo', 1500.00, 1200.00, 1140.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(591, '423', '321', NULL, '1tb_corporate_30days_81149', '1 TB', 'CORPORATE', 'glo', 276250.00, 221000.00, 209950.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(592, '12', '252', NULL, '1gb_gifting_14days_84616', '1 GB', 'GIFTING', 'glo', 600.00, 480.00, 456.00, '14 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(593, '784', '323', NULL, '3_corporate_30days_44385', '3', 'CORPORATE', 'glo', 1500.00, 1200.00, 1140.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(594, '783', '321', NULL, '1_corporate_30days_39348', '1', 'CORPORATE', 'glo', 500.00, 400.00, 380.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(595, '491', '394', NULL, '750mb_sme_1day_57720', '750 MB', 'SME', 'glo', 245.00, 196.00, 186.20, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(596, '492', '395', NULL, '15gb_sme_1day_99341', '1.5 GB', 'SME', 'glo', 362.50, 290.00, 275.50, '1 day', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(597, '493', '396', NULL, '25gb_sme_2days_97441', '2.5 GB', 'SME', 'glo', 597.50, 478.00, 454.10, '2 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(598, '494', '397', NULL, '10gb_sme_7days_71039', '10 GB', 'SME', 'glo', 2377.50, 1902.00, 1806.90, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(599, '481', '725', NULL, '35gb_special_30days_10105', '3.5 GB', 'SPECIAL', 'mtn', 3062.50, 2450.00, 2327.50, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(600, '553', '697', NULL, '15gb_special_7days_75858', '1.5 GB', 'SPECIAL', 'mtn', 1225.00, 980.00, 931.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(601, '481', '704', NULL, '27gb_special_30days_96086', '2.7 GB', 'SPECIAL', 'mtn', 2450.00, 1960.00, 1862.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(602, '553', '709', NULL, '1gb_special_7days_61579', '1 GB', 'SPECIAL', 'mtn', 980.00, 784.00, 744.80, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(603, '485', '711', NULL, '2gb_special_30days_74069', '2 GB', 'SPECIAL', 'mtn', 1837.50, 1470.00, 1396.50, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(604, '489', '722', NULL, '500mb_special_7days_78437', '500 MB', 'SPECIAL', 'mtn', 612.50, 490.00, 465.50, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(605, '562', '486', NULL, '1gb_sme_7days_94842', '1 GB', 'SME', 'mtn', 520.50, 750.00, 712.50, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-15 15:23:25'),
(606, '340', '419', NULL, '3gb_sme_30days_90459', '3 GB', 'SME', 'mtn', 3300.00, 2640.00, 2508.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(607, '341', '468', NULL, '5gb_sme_30days_30325', '5 GB', 'SME', 'mtn', 5500.00, 4400.00, 4180.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(608, '554', '399', NULL, '12gb_gifting_7days_51723', '1.2 GB', 'GIFTING', 'mtn', 904.69, 723.75, 687.56, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(609, '523', '487', NULL, '35gb_gifting_30days_31704', '3.5 GB', 'GIFTING', 'mtn', 3009.38, 2407.50, 2287.13, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(610, '339', '506', NULL, '2gb_sme_30days_20788', '2 GB', 'SME', 'mtn', 2200.00, 1760.00, 1672.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(611, '523', '518', NULL, '27gb_gifting_30days_82465', '2.7 GB', 'GIFTING', 'mtn', 2412.50, 1930.00, 1833.50, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(612, '422', '528', NULL, '500mb_sme_7days_41196', '500 MB', 'SME', 'mtn', 625.00, 500.00, 475.00, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(613, '554', '166', NULL, '15gb_gifting_7days_46932', '1.5 GB', 'GIFTING', 'mtn', 1203.75, 963.00, 914.85, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(614, '506', '221', NULL, '2gb_gifting_30days_49442', '2 GB', 'GIFTING', 'mtn', 1818.75, 1455.00, 1382.25, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(615, '554', '233', NULL, '1gb_gifting_7days_29351', '1 GB', 'GIFTING', 'mtn', 965.00, 772.00, 733.40, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(616, '338', '353', NULL, '1gb_sme_30days_24602', '1 GB', 'SME', 'mtn', 590.00, 880.00, 836.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-15 15:23:05'),
(617, '342', '357', NULL, '10gb_sme_30days_44665', '10 GB', 'SME', 'mtn', 11000.00, 8800.00, 8360.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(618, '389', '602', NULL, '12gb_gifting_30days_19570', '1.2 GB', 'GIFTING', 'mtn', 712.50, 570.00, 541.50, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(619, '460', '648', NULL, '1gb_special_30days_60050', '1 GB', 'SPECIAL', 'mtn', 925.00, 740.00, 703.00, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(620, '544', '585', NULL, '500mb_gifting_7days_53441', '500 MB', 'GIFTING', 'mtn', 603.13, 482.50, 458.38, '7 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33'),
(621, '506', '589', NULL, '18gb_gifting_30days_77014', '1.8 GB', 'GIFTING', 'mtn', 1809.38, 1447.50, 1375.13, '30 days', 'active', '2025-12-12 11:35:33', '2025-12-12 11:35:33');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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