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

START TRANSACTION;



--
-- Database: `urpbxmaq_urpbxmaq`
--

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

--
-- Table structure for table `airtime`
--

CREATE TABLE `airtime` (
  `aId` int NOT NULL,
  `aNetwork` varchar(10) NOT NULL,
  `aBuyDiscount` float NOT NULL DEFAULT '96',
  `aUserDiscount` float NOT NULL,
  `aAgentDiscount` float NOT NULL,
  `aVendorDiscount` float NOT NULL,
  `aType` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `airtime`
--

INSERT INTO `airtime` (`aId`, `aNetwork`, `aBuyDiscount`, `aUserDiscount`, `aAgentDiscount`, `aVendorDiscount`, `aType`) VALUES
(1, '1', 96.5, 99, 99, 99, 'VTU'),
(2, '2', 93, 99, 99, 99, 'VTU'),
(3, '3', 99, 99, 99, 99, 'VTU'),
(4, '4', 97, 99, 99, 98, 'VTU'),
(5, '1', 98, 99, 99, 99, 'Share And Sell'),
(6, '2', 98, 98, 98, 98, 'Share And Sell'),
(7, '3', 98, 99, 99, 99, 'Share And Sell'),
(8, '4', 98, 99, 99, 99, 'Share And Sell');

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

--
-- Table structure for table `airtimepin`
--

CREATE TABLE `airtimepin` (
  `id` int NOT NULL,
  `aNetwork` int NOT NULL,
  `planSize` varchar(255) NOT NULL,
  `aBuyPrice` decimal(10,2) NOT NULL,
  `aUserPrice` decimal(10,2) NOT NULL,
  `aAgentPrice` decimal(10,2) NOT NULL,
  `aVendorPrice` decimal(10,2) NOT NULL,
  `loadpin` varchar(255) DEFAULT NULL,
  `checkbalance` varchar(255) DEFAULT NULL,
  `planid` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `airtimepin`
--

INSERT INTO `airtimepin` (`id`, `aNetwork`, `planSize`, `aBuyPrice`, `aUserPrice`, `aAgentPrice`, `aVendorPrice`, `loadpin`, `checkbalance`, `planid`) VALUES
(4, 1, '100', 98.00, 98.00, 98.00, 98.00, '555', '444', 1),
(5, 1, '200', 198.00, 197.00, 196.00, 195.00, '444', '444', 2),
(6, 1, '1000', 100.00, 99.00, 99.00, 96.50, '*555#', '*555#', 1);

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

--
-- Table structure for table `airtimepinprice`
--

CREATE TABLE `airtimepinprice` (
  `aId` int NOT NULL,
  `aNetwork` varchar(10) NOT NULL,
  `aUserDiscount` float NOT NULL,
  `aAgentDiscount` float NOT NULL,
  `aVendorDiscount` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `airtimepinprice`
--

INSERT INTO `airtimepinprice` (`aId`, `aNetwork`, `aUserDiscount`, `aAgentDiscount`, `aVendorDiscount`) VALUES
(1, '1', 99, 98, 97),
(2, '2', 99, 98, 97),
(3, '3', 99, 98, 97),
(4, '4', 99, 98, 97);

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

--
-- Table structure for table `airtimepinstock`
--

CREATE TABLE `airtimepinstock` (
  `id` int NOT NULL,
  `aNetwork` int DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `tokens` varchar(55) DEFAULT NULL,
  `serial` varchar(55) DEFAULT NULL,
  `status` enum('Unused','Bought') DEFAULT 'Unused',
  `soldto` varchar(55) DEFAULT NULL,
  `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `airtimepinstock`
--

INSERT INTO `airtimepinstock` (`id`, `aNetwork`, `amount`, `tokens`, `serial`, `status`, `soldto`, `date`) VALUES
(1, 1, 100.00, '1234567890123456', 'ABC123', 'Unused', NULL, '2024-08-26 21:48:50'),
(2, 2, 200.00, '9876543210987654', 'XYZ789', 'Unused', NULL, '2024-08-26 21:48:50');

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

--
-- Table structure for table `alphatopupprice`
--

CREATE TABLE `alphatopupprice` (
  `alphaId` int NOT NULL,
  `buyingPrice` int NOT NULL,
  `sellingPrice` int NOT NULL,
  `agent` int NOT NULL,
  `vendor` int NOT NULL,
  `dPosted` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `apiconfigs`
--

CREATE TABLE `apiconfigs` (
  `aId` int NOT NULL,
  `name` varchar(30) NOT NULL,
  `value` varchar(100) DEFAULT NULL,
  `updateOn` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apiconfigs`
--

INSERT INTO `apiconfigs` (`aId`, `name`, `value`, `updateOn`) VALUES
(1, 'monifyCharges', '1.7', '2024-05-23 20:32:28'),
(2, 'monifyApi', 'MK_PROD_8S7NGTPQ57', '2024-05-23 20:32:28'),
(3, 'monifySecrete', '54JKMQ780P3Q2ZW5KAGUYPS15SNQQBJR', '2024-05-23 20:32:28'),
(4, 'monifyContract', '160739899716', '2024-05-23 20:32:28'),
(5, 'monifyWeStatus', 'Off', '2024-05-23 20:32:28'),
(6, 'monifyMoStatus', 'Off', '2024-05-23 20:32:28'),
(7, 'monifyFeStatus', 'Off', '2024-05-23 20:32:28'),
(8, 'monifySaStatus', 'Off', '2024-05-23 20:32:28'),
(9, 'monifyStatus', 'Off', '2024-05-23 20:32:28'),
(10, 'paystackCharges', '0', '2024-05-23 20:32:28'),
(11, 'paystackApi', 'a', '2024-05-23 20:32:28'),
(12, 'paystackStatus', 'Off', '2024-05-23 20:32:28'),
(13, 'mtnVtuKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(14, 'mtnVtuProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(15, 'mtnSharesellKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(16, 'mtnSharesellProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(17, 'airtelVtuKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(18, 'airtelVtuProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(19, 'airtelSharesellKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(20, 'airtelSharesellProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(21, 'gloVtuKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(22, 'gloVtuProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(23, 'gloSharesellKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(24, 'gloSharesellProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(25, '9mobileVtuKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(26, '9mobileVtuProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(27, '9mobileSharesellKey', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(28, '9mobileSharesellProvider', 'https://alrahuzdata.com.ng/api/topup/', '2024-05-23 20:32:28'),
(29, 'mtnSmeApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(30, 'mtnSmeProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(31, 'mtnGiftingApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(32, 'mtnGiftingProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(33, 'mtnCorporateApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(34, 'mtnCorporateProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(35, 'airtelSmeApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(36, 'airtelSmeProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(37, 'airtelGiftingApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(38, 'airtelGiftingProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(39, 'airtelCorporateApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(40, 'airtelCorporateProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(41, 'gloSmeApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(42, 'gloSmeProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(43, 'gloGiftingApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(44, 'gloGiftingProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(45, 'gloCorporateApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(46, 'gloCorporateProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(47, '9mobileSmeApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(48, '9mobileSmeProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(49, '9mobileGiftingApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(50, '9mobileGiftingProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(51, '9mobileCorporateApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(52, '9mobileCorporateProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(53, 'cableVerificationApi', 'QlVLQVJNRDpOM1', '2024-05-23 20:32:28'),
(54, 'cableVerificationProvider', 'https://legitdataway.com/api/cable/cable-validation?iuc=12345555&cable=1', '2024-05-23 20:32:28'),
(55, 'cableApi', 'QlVLQVJNRDpOM1REQV', '2024-05-23 20:32:28'),
(56, 'cableProvider', 'https://legitdataway.com/api/cable', '2024-05-23 20:32:28'),
(57, 'meterVerificationApi', '0685e8828b2b661a02795c', '2024-05-23 20:32:28'),
(58, 'meterVerificationProvider', 'https://alrahuzdata.com.ng/api/billpayment/id', '2024-05-23 20:32:28'),
(59, 'meterApi', '0685e8828b2b661a027', '2024-05-23 20:32:28'),
(60, 'meterProvider', 'https://alrahuzdata.com.ng/api/billpayment/', '2024-05-23 20:32:28'),
(61, 'examApi', 'c3VudXNpa2lydTpA=', '2024-05-23 20:32:28'),
(62, 'examProvider', 'https://legitdataway.com/api/exam/', '2024-05-23 20:32:28'),
(63, 'rechargePinApi', 'hhhhh', '2024-05-23 20:32:28'),
(64, 'rechargePinProvider', 'https://legitdataway.com/api/recharge_card/', '2024-05-23 20:32:28'),
(65, 'walletOneApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(66, 'walletOneProvider', 'https://alrahuzdata.com.ng/api/user/', '2024-05-23 20:32:28'),
(67, 'walletOneProviderName', 'ALRAHUZDATA', '2024-05-23 20:32:28'),
(68, 'walletTwoApi', 'd2', '2024-05-23 20:32:28'),
(69, 'walletTwoProvider', 'https://alrahuzdata.com.ng/api/user/', '2024-05-23 20:32:28'),
(70, 'walletTwoProviderName', 'smnk', '2024-05-23 20:32:28'),
(71, 'walletThreeApi', 'c3', '2024-05-23 20:32:28'),
(72, 'walletThreeProvider', 'https://alrahuzdata.com.ng/api/user/', '2024-05-23 20:32:28'),
(73, 'walletThreeProviderName', 'Legit Data Way', '2024-05-23 20:32:28'),
(74, 'dataPinApi', 'QlVLQVJNRDpOM1RE', '2024-05-23 20:32:28'),
(75, 'dataPinProvider', 'https://legitdataway.com/api/data_card', '2024-05-23 20:32:28'),
(76, 'alphaApi', 'mmnnn ', '2024-05-23 20:32:28'),
(77, 'alphaProvider', 'hhhhh', '2024-05-23 20:32:28'),
(78, 'payvesselStatus', 'Off', '2024-05-23 20:32:28'),
(79, 'payvesselSecret', 'PVSECRET-TYVI343EIWU4WQQU', '2024-05-23 20:32:28'),
(80, 'payvesselApiKey', 'PVKEY-4MRZG', '2024-05-23 20:32:28'),
(81, 'payvesselBusinessId', 'A002C10A5333', '2024-05-23 20:32:28'),
(82, 'payvesselCharges', '50', '2024-05-23 20:32:28'),
(83, 'payvesselChargesType', 'flat', '2024-05-23 20:32:28'),
(139, 'CACcharge1', '20000', '2024-05-23 15:21:09'),
(140, 'CACcharge2', '40000', '2024-05-23 15:21:09'),
(141, 'CACstatus', 'On', '2024-05-23 15:21:09'),
(142, 'mtnAwoofApi', '8f5d8f3a7642c9a2665e24c774f8ebc592a1165c', '2024-05-23 20:32:28'),
(143, 'mtnAwoofProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(144, 'airtelAwoofApi', '8f5d8f3a7642c9a2665e24c774f8ebc592a1165c', '2024-05-23 20:32:28'),
(145, 'airtelAwoofProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(146, 'gloAwoofApi', '8f5d8f3a7642c9a2665e24c774f8ebc592a1165c====', '2024-05-23 20:32:28'),
(147, 'gloAwoofProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(148, '9mobileAwoofApi', '8f5d8f3a7642c9a2665e24c774f8ebc592a1165c', '2024-05-23 20:32:28'),
(149, '9mobileAwoofProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(150, 'airtime2cashmtnno', '1.7', '2024-05-23 20:32:28'),
(151, 'airtime2cashmtnrate', 'MK_PROD_51FXUJTESM', '2024-05-23 20:32:28'),
(152, 'airtime2cashairtelno', '6N4VLMVRUXW0HQSGL69S1RJLXPVKXENT', '2024-05-23 20:32:28'),
(153, 'airtime2cashairtelrate', '758567466849', '2024-05-23 20:32:28'),
(154, 'airtime2cashglono', 'On', '2024-05-23 20:32:28'),
(155, 'airtime2cashglorate', 'On', '2024-05-23 20:32:28'),
(156, 'airtime2cash9mobileno', 'On', '2024-05-23 20:32:28'),
(157, 'airtime2cash9mobilerate', 'On', '2024-05-23 20:32:28'),
(158, 'asfiyApi', 'Aspfiy-00af2f9f98b9da0b35f67755a5f2db9b', '2024-05-23 20:32:28'),
(159, 'asfiyWebhook', 'https://www.icebills.com.ng/webhook/aspfiy/index.php', '2024-05-23 20:32:28'),
(160, 'asfiyChargesType', 'flat', '2024-05-23 20:32:28'),
(161, 'asfiyCharges', '2', '2024-05-23 20:32:28'),
(162, 'asfiyStatus', 'On', '2024-05-23 20:32:28'),
(163, 'mtnSme2Api', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(164, 'mtnSme2Provider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(165, 'mtnCorporate2Api', 'https://legitdataway.com/api/topup/', '2024-05-23 20:32:28'),
(166, 'mtnCorporate2Provider', '0258be70cbd3021335c367a98660c7cf23c76c8d', '2024-05-23 20:32:28'),
(167, 'mtnbononzaProvider', 'https://www.gongozconcept.com/api/topup/', '2024-05-23 20:32:28'),
(168, 'mtnbononzaApi', '0a81c56877c45b217063de75ef2290aa4f43b979', '2024-05-23 20:32:28'),
(169, 'mtncouponProvider', 'https://alrahuzdata.com.ng/api/data/', '2024-05-23 20:32:28'),
(170, 'mtncouponApi', '79e25eff336b1e5510b12180fcd28920721a8f35', '2024-05-23 20:32:28'),
(171, 'airtime2cashstatus', 'On', '2024-05-23 20:32:28'),
(172, 'rechargePinMethod', 'EXTERNAL', '2024-05-23 20:32:28'),
(173, 'monifyCardStatus', 'On', '2024-05-23 20:32:28'),
(191, 'billstackCharges', '1.7', '2024-05-23 20:32:28'),
(192, 'billstackSecret', 'Bill_Stack-SEC-KEY-55b7a535e8ff043acb40bdb65237e67d', '2024-05-23 20:32:28'),
(193, 'billstackStatus', 'Off', '2024-05-23 20:32:28');

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

--
-- Table structure for table `apilinks`
--

CREATE TABLE `apilinks` (
  `aId` int NOT NULL,
  `name` varchar(30) NOT NULL,
  `value` varchar(100) DEFAULT NULL,
  `type` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `apilinks`
--

INSERT INTO `apilinks` (`aId`, `name`, `value`, `type`) VALUES
(4, 'Legitdataway', 'https://legitdataway.com/api/cable/cable-validation?iuc=12345555&cable=1', 'CableVer'),
(5, 'Legitdataway', 'https://legitdataway.com/api/cable', 'Cable'),
(6, 'Legitdataway', 'https://legitdataway.com/api/bill/bill-validation?meter_number=12345555&disco=1&meter_type=postpaid', 'ElectricityVer'),
(7, 'Legitdataway', 'https://legitdataway.com/api/bill/', 'Electricity'),
(8, 'Legitdataway', 'https://legitdataway.com/api/exam/', 'Exam'),
(74, 'Legitdataway', 'https://legitdataway.com/api/data_card', 'Data Pin'),
(86, 'Alrahuzdata', 'https://alrahuzdata.com.ng/api/user/', 'Wallet'),
(87, 'Alrahuzdata', 'https://alrahuzdata.com.ng/api/topup/', 'Airtime'),
(88, 'Alrahuzdata', 'https://alrahuzdata.com.ng/api/data/', 'Data'),
(133, 'ALRAHUZ ', 'https://alrahuzdata.com.ng/api/billpayment/', 'Electricity'),
(134, 'ALRAHUZ ', 'https://alrahuzdata.com.ng/api/billpayment/id', 'ElectricityVer'),
(152, 'Husmodataapi', 'https://husmodataapi.com/api/user/', 'Wallet'),
(153, 'Husmodataapi', 'https://husmodataapi.com/api/topup/', 'Airtime'),
(154, 'Husmodataapi', 'https://husmodataapi.com/api/data/', 'Data');

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

--
-- Table structure for table `beneficiary`
--

CREATE TABLE `beneficiary` (
  `id` int NOT NULL,
  `sId` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `beneficiary`
--

INSERT INTO `beneficiary` (`id`, `sId`, `name`, `phone`) VALUES
(1, '1', 'Sunusi habib Kasim', '07026417709');

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

--
-- Table structure for table `blacklist`
--

CREATE TABLE `blacklist` (
  `id` int NOT NULL,
  `bPhone` varchar(50) NOT NULL,
  `date_added` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `blacklist`
--

INSERT INTO `blacklist` (`id`, `bPhone`, `date_added`) VALUES
(2, '08122222222', NULL),
(4, '08068112413', NULL),
(5, '08147302304', NULL),
(6, '07039899498', NULL),
(7, '09031302879', NULL),
(8, '09068549724', NULL),
(9, '08142700775', NULL),
(10, '09033070595', NULL),
(11, '08111116335', NULL),
(12, '07061983004', NULL),
(13, '08162704634', NULL),
(14, '08145599861', NULL),
(16, '09136374844', NULL),
(17, '09029163515', NULL),
(18, '07047358763', NULL),
(19, '08167959649', NULL),
(20, '08030608854', NULL),
(21, '09134755186', NULL),
(22, '08146439413', NULL),
(23, '09031399710', NULL),
(24, '09036391453', NULL),
(25, '07084143743', NULL),
(30, '08069476474', NULL),
(31, '07077862204', NULL);

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

--
-- Table structure for table `cableid`
--

CREATE TABLE `cableid` (
  `cId` int NOT NULL,
  `cableid` varchar(10) DEFAULT NULL,
  `provider` varchar(10) NOT NULL,
  `providerStatus` varchar(10) NOT NULL DEFAULT 'On'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cableid`
--

INSERT INTO `cableid` (`cId`, `cableid`, `provider`, `providerStatus`) VALUES
(1, '1', 'GOTV', 'On'),
(2, '2', 'DSTV', 'On'),
(3, '3', 'STARTIMES', 'On');

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

--
-- Table structure for table `cableplans`
--

CREATE TABLE `cableplans` (
  `cpId` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `userprice` varchar(255) NOT NULL,
  `agentprice` varchar(255) NOT NULL,
  `vendorprice` varchar(255) NOT NULL,
  `planid` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `cableprovider` tinyint NOT NULL,
  `day` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cableplans`
--

INSERT INTO `cableplans` (`cpId`, `name`, `price`, `userprice`, `agentprice`, `vendorprice`, `planid`, `type`, `cableprovider`, `day`) VALUES
(19, 'DStv Compact', '12375', '12400', '12400', '12400', '1', NULL, 2, '30'),
(20, 'DSTV -YANGA', '4158', '4200', '4200', '4200', '2', NULL, 2, '30'),
(21, 'DStv Premium-Asia', '24500', '25000', '25000', '25000', '9', NULL, 2, '30'),
(22, 'DStv Confam + ExtraView', '7115', '7200', '7200', '7200', '10', NULL, 2, '30'),
(23, 'Dstv Confam', '7326', '7400', '7400', '7400', '34', NULL, 2, '30'),
(24, 'DStv Compact', '12375', '12400', '12400', '12400', '35', NULL, 2, '30'),
(25, '36', '29205', '29500', '29500', '29500', '36', NULL, 2, '30'),
(26, 'DStv Asia', '7100', '7200', '7200', '7200', '37', NULL, 2, '30'),
(27, '	DStv Compact Plus', '19602', '19700', '19700', '19700', '38', NULL, 2, '30'),
(28, 'DStv Padi + ExtraView', '5050', '5100', '5100', '5100', '43', NULL, 2, '30'),
(29, 'GOtv Max', '5643', '5700', '5700', '5700', '59', NULL, 1, '30'),
(30, 'GOtv Jolli', '3911', '4050', '4050', '4050', '60', NULL, 1, '30'),
(31, 'GOtv jinja', '2673', '2700', '2700', '2700', '61', NULL, 1, '30'),
(32, 'Gotv Smallie_monthly', '1287', '1310', '1310', '1310', '62', NULL, 1, '30'),
(33, 'GOtv Supa - monthly', '6400', '6500', '6500', '6500', '65', NULL, 1, '30'),
(34, 'Nova - 1 Month', '1500', '1550', '1550', '1550', '66', NULL, 3, '30'),
(35, 'Basic (Antenna) - 1 Month', '2600', '2600', '2700', '2700', '67', NULL, 3, '30'),
(36, 'Smart (Dish) -1 Month', '3500', '3600', '3600', '3600', '68', NULL, 3, '30'),
(37, 'Classic (Antenna) - 1 Month', '3800', '3900', '3900', '3900', '69', NULL, 3, '30'),
(38, 'Super (Dish) - 1 Month', '6500', '6600', '6600', '6600', '70', NULL, 3, '30'),
(39, 'Nova - 1 Week', '500', '550', '550', '550', '71', NULL, 3, '7'),
(40, 'Basic (Antenna) - 1 Week', '900', '950', '950', '950', '72', NULL, 3, '7'),
(41, 'Smart (Dish) - 1 Week', '1100', '1150', '1150', '1150', '73', NULL, 3, '7'),
(42, 'Classic (Antenna) - 1 Week', '1500', '1600', '1600', '1600', '74', NULL, 3, '7'),
(43, 'Super (Dish) - 1 Week', '2200', '2250', '2250', '2250', '75', NULL, 3, '7'),
(44, 'Padi', '100', '100', '100', '100', '100', NULL, 1, '30'),
(45, 'Hhh', '11', '11', '11', '11', '22', NULL, 1, '30');

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

--
-- Table structure for table `CAC`
--

CREATE TABLE `CAC` (
  `id` int NOT NULL,
  `certType` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `comp_name` varchar(255) NOT NULL,
  `alt_comp_name` varchar(255) DEFAULT NULL,
  `share_cap` decimal(15,2) NOT NULL,
  `comp_addr` varchar(255) NOT NULL,
  `res_addr` varchar(255) NOT NULL,
  `bus_nature` varchar(255) NOT NULL,
  `dir_id_card` varchar(255) DEFAULT NULL,
  `passport_photo` varchar(255) DEFAULT NULL,
  `phone_num` varchar(15) NOT NULL,
  `status` varchar(50) DEFAULT NULL,
  `sId` int DEFAULT NULL,
  `submit_date` date DEFAULT NULL,
  `note` varchar(255) NOT NULL DEFAULT 'Your CAC certificate will be ready in 3 to 14 days. The process will be sent to your email.'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `msgId` int NOT NULL,
  `sId` int NOT NULL,
  `name` varchar(100) NOT NULL,
  `contact` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `dPosted` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`msgId`, `sId`, `name`, `contact`, `subject`, `message`, `dPosted`) VALUES
(1, 0, 'Topupmate', 'ibyusuf31@gmail.com', 'Testing', 'Test', '2022-06-21 17:06:56'),
(2, 0, 'Ibrahim Ahmed', 'ibyusuf31@gmail.com', 'Test From Landing Page', 'Test From Landing Page', '2022-06-23 13:08:11'),
(3, 0, 'Aliyu Abubakar ', 'aliyuabubakar1990@gmail.com', 'Business ', 'Business leaders ', '2023-10-25 11:03:46');

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

--
-- Table structure for table `datapins`
--

CREATE TABLE `datapins` (
  `dpId` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `userprice` varchar(255) NOT NULL,
  `agentprice` varchar(255) NOT NULL,
  `vendorprice` varchar(255) NOT NULL,
  `planid` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `datanetwork` tinyint NOT NULL,
  `day` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `datapins`
--

INSERT INTO `datapins` (`dpId`, `name`, `price`, `userprice`, `agentprice`, `vendorprice`, `planid`, `type`, `datanetwork`, `day`) VALUES
(1, '1.5GB', '300', '305', '305', '305', '1', 'Gifting', 1, '30'),
(2, '500 MB', '120', '130', '130', '130', '2', 'SME', 1, '30'),
(3, '1GB', '230', '235', '235', '235', '3', 'SME', 1, '30'),
(4, '2GB', '450', '460', '460', '460', '4', 'SME', 1, '30'),
(5, '3GB', '675', '680', '680', '680', '5', 'SME', 1, '30'),
(6, '5GB', '1125', '1130', '1130', '1130', '6', 'SME', 1, '30'),
(7, '10GB', '2250', '2300', '2300', '2300', '7', 'SME', 1, '30');

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

--
-- Table structure for table `dataplans`
--

CREATE TABLE `dataplans` (
  `pId` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `userprice` varchar(255) NOT NULL,
  `agentprice` varchar(255) NOT NULL,
  `vendorprice` varchar(255) NOT NULL,
  `planid` varchar(255) NOT NULL,
  `type` varchar(255) DEFAULT NULL,
  `datanetwork` tinyint NOT NULL,
  `day` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dataplans`
--

INSERT INTO `dataplans` (`pId`, `name`, `price`, `userprice`, `agentprice`, `vendorprice`, `planid`, `type`, `datanetwork`, `day`) VALUES
(57, '500MB', '129.0', '130.0', '130.0', '129.0', '219', 'SME', 1, '30'),
(58, '1GB', '254.0', '259.0', '257.0', '258.0', '7', 'SME', 1, '30'),
(70, '5GB', '1470.0', '1410.0', '1470.0', '1490.0', '11', 'SME', 1, '30'),
(71, '2GB', '508.0', '525.0', '521.0', '522.0', '8', 'SME', 1, '30'),
(72, '3GB', '900.0', '900.0', '900.0', '900.0', '44', 'SME', 1, '30'),
(75, '500 MB', '130', '131', '131', '131', '232', 'Corporate', 1, '30'),
(76, '1GB', '261.0', '264.0', '261.0', '261.0', '213', 'Corporate', 1, '30'),
(77, '2GB', '522.0', '525.0', '524', '523', '214', 'Corporate', 1, '30'),
(78, '5GB', '1305.0', '1305.0', '1305.0', '1305.0', '216', 'Corporate', 1, '30'),
(85, '10GB', '2610.0', '2610.0', '2610.0', '2610.0', '217', 'Corporate', 1, '30'),
(86, '20GB', '5220.0', '5220.0', '5220.0', '5220.0', '218', 'Corporate', 1, '30'),
(87, '10GB', '2540.0', '2540.0', '2540.0', '2540.0', '226', 'SME', 1, '30'),
(89, '500 MB', '138.0', '138.0', '138.0', '138.0', '222', 'Corporate', 4, '30'),
(90, '1GB', '271.0', '273.0', '272.0', '272.0', '223', 'Corporate', 4, '30'),
(91, '2GB', '544.0', '548.0', '547.0', '546.0', '224', 'Corporate', 4, '30'),
(92, '5GB', '1305.0', '1305.0', '1305.0', '1305.0', '225', 'Corporate', 4, '30'),
(95, '10GB', '2620.0', '2620.0', '2620.0', '2620.0', '280', 'Corporate', 4, '30'),
(98, '1GB', '129.0', '129.0', '129.0', '129.0', '296', 'Corporate', 3, '30'),
(99, '2GB', '258.0', '258.0', '258.0', '258.0', '297', 'Corporate', 3, '30'),
(100, '1.5GB', '195.0', '195.0', '195.0', '195.0', '298', 'Corporate', 3, '30'),
(101, '3GB', '387.0', '387.0', '387.0', '387.0', '299', 'Corporate', 3, '30'),
(102, '10GB', '1290.0', '1290.0', '1290.0', '1290.0', '301', 'Corporate', 3, '30'),
(103, '5GB', '645.0', '645.0', '645.0', '645.0', '300', 'Corporate', 3, '30'),
(105, '500 MB', '134', '138', '137', '136', '290', 'Corporate', 2, '30'),
(107, '1GB', '267', '270', '269', '268', '285', 'Corporate', 2, '30'),
(108, '2GB', '450', '540', '540', '535', '286', 'Corporate', 2, '30'),
(109, '3GB', '801', '900', '900', '850', '287', 'Corporate', 2, '30'),
(110, '5GB', '1335', '1365', '1360', '1350', '288', 'Corporate', 2, '30'),
(111, '10GB', '2670', '2700', '2690', '2680', '289', 'Corporate', 2, '30'),
(112, '500MB', '70.0', '70.0', '70.0', '70.0', '302', 'Corporate', 3, '30'),
(113, '1GB', '220.0', '220.0', '220.0', '220.0', '248', 'SME', 3, '30'),
(114, '2GB', '440.0', '440.0', '440.0', '440.0', '250', 'SME', 3, '30'),
(115, '3GB', '660.0', '660.0', '660.0', '660.0', '251', 'SME', 3, '30'),
(116, '10GB', '2200.0', '2200.0', '2200.0', '2200.0', '292', 'SME', 3, '30'),
(117, '50MB', '35.0', '35.0', '35.0', '35.0', '254', 'Corporate', 1, '30'),
(118, '100MB', '50', '50', '50', '50', '220', 'Corporate', 4, '30'),
(119, '300MB', '100', '100', '100', '100', '221', 'Corporate', 4, '30'),
(120, '20GB', '4600.0', '4600.0', '4600.0', '4600.0', '244', 'SME2', 4, '30'),
(121, '40GB', '8800.0', '8800.0', '8800.0', '8800.0', '245', 'SME2', 4, '30'),
(122, '75GB', '13375.0', '13375.0', '13375.0', '13375.0', '246', 'SME2', 4, '30'),
(123, '120GB', '19000.0', '19000.0', '19000.0', '19000.0', '247', 'SME2', 4, '30'),
(124, '1.5GB', '900.0', '900.0', '900.0', '900.0', '145', 'SME2', 4, '30'),
(125, '2GB', '1100.0', '1100.0', '1100.0', '1100.0', '146', 'SME2', 4, '30'),
(126, '3GB', '1350.0', '1350.0', '1350.0', '1350.0', '147', 'SME2', 4, '30'),
(127, '4.5GB', '1800.0', '1800.0', '1800.0', '1800.0', '148', 'SME2', 4, '30'),
(128, '750MB', '435.0', '435.0', '435.0', '435.0', '149', 'SME2', 4, '30'),
(129, '10GB', '2800.0', '2800.0', '2800.0', '2800.0', '150', 'SME2', 4, '30'),
(130, '11GB', '3700.0', '3700.0', '3700.0', '3700.0', '163', 'SME2', 4, '30'),
(131, '6GB', '2250.0', '2250.0', '2250.0', '2250.0', '192', 'SME2', 4, '30'),
(132, '20GB', '5440.0', '5440.0', '5440.0', '5440.0', '295', 'Corporate', 4, '30'),
(133, '15GB', '4080.0', '4080.0', '4080.0', '4080.0', '294', 'Corporate', 4, '30'),
(134, '150MB', '65.0', '65.0', '65.0', '65.0', '255', 'Corporate', 1, '30'),
(135, '250MB', '85.0', '85.0', '85.0', '85.0', '256', 'Corporate', 1, '30'),
(136, '15GB', '3915.0', '3915.0', '3915.0', '3915.0', '243', 'Corporate', 1, '30'),
(137, '12GB', '3132.0', '3132.0', '3132.0', '3132.0', '257', 'Corporate', 1, '30'),
(138, '40GB', '10440.0', '10440.0', '10440.0', '10440.0', '259', 'Corporate', 1, '30'),
(139, '75GB', '19575.0', '19575.0', '19575.0', '19575.0', '260', 'Corporate', 1, '30'),
(140, '100GB', '26100.0', '26100.0', '26100.0', '26100.0', '261', 'Corporate', 1, '30'),
(141, '500MB', '129.0', '129.0', '129.0', '129.0', '306', 'SME2', 1, '30'),
(142, '50MB', '30.0', '30.0', '30.0', '30.0', '307', 'SME2', 1, '30'),
(143, '1GB', '255.0', '260.0', '257.0', '257.0', '319', 'SME2', 1, '30'),
(144, '2GB', '510.0', '510.0', '510.0', '510.0', '318', 'SME2', 1, '30'),
(145, '7GB', '1785.0', '1785.0', '1785.0', '1785.0', '308', 'SME2', 1, '30'),
(146, '6GB', '1530.0', '1530.0', '1530.0', '1530.0', '309', 'SME2', 1, '30'),
(147, '2.5GB', '639.0', '639.0', '639.0', '639.0', '310', 'SME2', 1, '30'),
(148, '25MB', '24.0', '24.0', '24.0', '24.0', '311', 'SME', 1, '30'),
(149, '20MB', '20.0', '20.0', '20.0', '20.0', '312', 'SME2', 1, '30'),
(150, '100MB', '65.0', '65.0', '65.0', '65.0', '313', 'SME2', 1, '30'),
(151, '1.5GB', '384.0', '384.0', '384.0', '384.0', '314', 'SME2', 1, '30'),
(152, '10GB', '2550.0', '2550.0', '2550.0', '2550.0', '315', 'SME2', 1, '30'),
(153, '5GB', '1275.0', '1275.0', '1275.0', '1275.0', '316', 'SME2', 1, '30'),
(154, '3GB', '765.0', '765.0', '765.0', '765.0', '317', 'SME2', 1, '30'),
(155, '4GB', '1020.0', '1020.0', '1020.0', '1020.0', '230', 'SME2', 1, '30'),
(156, '(Share) 1GB', '250', '255', '254', '253', '327', 'Gifting', 1, '30'),
(157, '(Share) 2GB', '500', '520', '518', '515', '328', 'Gifting', 1, '30'),
(158, '(Share) 3GB', '750', '755', '754', '753', '329', 'Gifting', 1, '30'),
(159, '(Share) 5GB', '1250', '1300', '1075', '1270', '330', 'Gifting', 1, '30'),
(160, '(AWOOF) 1GB', '225', '230', '229', '228', '335', 'Gifting', 4, '2'),
(161, '(AWOOF) 300MB', '125', '128', '127', '126', '336', 'Gifting', 4, '2'),
(162, '(AWOOF) 2GB', '325', '330', '329', '328', '337', 'Gifting', 4, '2'),
(163, '(AWOOF) 3GB', '530', '535', '534', '533', '338', 'Gifting', 4, '7'),
(164, '(AWOOF) 4GB', '1030', '1090', '1080', '1070', '339', 'Gifting', 4, '30'),
(165, '(AWOOF) 10GB', '2050', '2200', '2170', '2180', '340', 'Gifting', 4, '30'),
(166, '(AWOOF) 15GB', '3100', '3300', '3250', '3200', '341', 'Gifting', 4, '30'),
(167, '(Coupond) 1GB', '225', '230', '227', '226', '344', 'Gifting', 1, '1'),
(168, '(Coupond) 3.5GB', '600', '600', '600', '600', '343', 'Gifting', 1, '2'),
(169, '(Coupond) 4.5GB', '112000000.0', '112000000.0', '112000000.0', '112000000.0', '334', 'Gifting', 1, '30'),
(170, '(Coupond) 15GB', '2300', '2250', '2200', '2159', '333', 'Gifting', 1, '2075');

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

--
-- Table structure for table `datatokens`
--

CREATE TABLE `datatokens` (
  `tId` int NOT NULL,
  `sId` int NOT NULL,
  `tRef` varchar(255) NOT NULL,
  `business` varchar(30) NOT NULL,
  `network` varchar(30) NOT NULL,
  `datasize` varchar(30) NOT NULL,
  `quantity` int NOT NULL,
  `serial` text NOT NULL,
  `tokens` text NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `electricityid`
--

CREATE TABLE `electricityid` (
  `eId` int NOT NULL,
  `electricityid` varchar(50) DEFAULT NULL,
  `provider` varchar(50) NOT NULL,
  `abbreviation` varchar(5) NOT NULL,
  `providerStatus` varchar(10) NOT NULL DEFAULT 'On'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `electricityid`
--

INSERT INTO `electricityid` (`eId`, `electricityid`, `provider`, `abbreviation`, `providerStatus`) VALUES
(1, '1', 'Ikeja Electric', 'IE', 'On'),
(2, '2', 'Eko Electric', 'EKEDC', 'On'),
(3, '3', 'Kano Electric', 'KEDCO', 'On'),
(4, '4', 'Port Harcourt Electric', 'PHEDC', 'On'),
(5, '5', 'Jos Electric', 'JED', 'On'),
(6, '6', 'Ibadan Electric', 'IBEDC', 'On'),
(7, '7', 'Kaduna Electric', 'KEDC', 'On'),
(8, '8', 'Abuja Electric', 'AEDC', 'On'),
(9, '9', 'Enugu Electric', 'ENUGU', 'On'),
(10, '10', 'Benin Electric', 'BENIN', 'On'),
(11, '11', 'Yola Electric', 'YOLA', 'On');

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

--
-- Table structure for table `examid`
--

CREATE TABLE `examid` (
  `eId` int NOT NULL,
  `examid` varchar(10) DEFAULT NULL,
  `provider` varchar(50) NOT NULL,
  `price` int NOT NULL DEFAULT '0',
  `buying_price` int NOT NULL DEFAULT '0',
  `providerStatus` varchar(10) NOT NULL DEFAULT 'On'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `examid`
--

INSERT INTO `examid` (`eId`, `examid`, `provider`, `price`, `buying_price`, `providerStatus`) VALUES
(1, '1', 'WAEC', 3400, 3400, 'On'),
(2, '2', 'NECO', 1200, 1150, 'On'),
(3, '3', 'NABTEB', 800, 900, 'Off');

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

--
-- Table structure for table `issues`
--

CREATE TABLE `issues` (
  `id` int NOT NULL,
  `sId` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `query` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `userEmail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user_read` tinyint(1) DEFAULT '0',
  `admin_read` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `manualfunds`
--

CREATE TABLE `manualfunds` (
  `tId` int NOT NULL,
  `sId` varchar(255) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `account` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  `dPosted` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manualfunds`
--

INSERT INTO `manualfunds` (`tId`, `sId`, `amount`, `account`, `method`, `status`, `dPosted`) VALUES
(1, '387', 200.00, 'Sunusi Habib Kiru 7026417709', 'Opay', 0, '2024-08-24 02:10:05');

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

--
-- Table structure for table `monnify_accounts`
--

CREATE TABLE `monnify_accounts` (
  `id` int NOT NULL,
  `accountReference` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `networkid`
--

CREATE TABLE `networkid` (
  `nId` int NOT NULL,
  `networkid` varchar(10) NOT NULL,
  `smeId` varchar(10) NOT NULL,
  `sme2Id` varchar(10) NOT NULL,
  `couponId` varchar(10) NOT NULL,
  `giftingId` varchar(10) NOT NULL,
  `corporateId` varchar(10) NOT NULL,
  `corporate2Id` varchar(10) NOT NULL,
  `vtuId` varchar(10) NOT NULL,
  `sharesellId` varchar(10) NOT NULL,
  `network` varchar(20) NOT NULL,
  `networkStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `vtuStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `sharesellStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `airtimepinStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `smeStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `sme2Status` varchar(10) NOT NULL,
  `couponStatus` varchar(10) NOT NULL,
  `giftingStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `corporateStatus` varchar(10) NOT NULL DEFAULT 'Off',
  `corporate2Status` varchar(10) NOT NULL,
  `datapinStatus` varchar(10) NOT NULL DEFAULT 'Off'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `networkid`
--

INSERT INTO `networkid` (`nId`, `networkid`, `smeId`, `sme2Id`, `couponId`, `giftingId`, `corporateId`, `corporate2Id`, `vtuId`, `sharesellId`, `network`, `networkStatus`, `vtuStatus`, `sharesellStatus`, `airtimepinStatus`, `smeStatus`, `sme2Status`, `couponStatus`, `giftingStatus`, `corporateStatus`, `corporate2Status`, `datapinStatus`) VALUES
(1, '1', '1', '1', '1', '1', '1', '1', '1', '1', 'MTN', 'On', 'On', 'On', 'On', 'On', 'On', 'Off', 'On', 'On', 'Off', 'Off'),
(2, '2', '2', '2', '2', '2', '2', '2', '2', '2', 'GLO', 'On', 'On', 'Off', 'On', 'Off', 'Off', 'Off', 'Off', 'On', 'Off', 'Off'),
(3, '3', '3', '3', '3', '3', '3', '3', '3', '3', '9MOBILE', 'On', 'On', 'On', 'On', 'Off', 'Off', 'Off', 'Off', 'On', 'Off', 'Off'),
(4, '4', '4', '4', '4', '4', '4', '4', '4', '4', 'AIRTEL', 'On', 'On', 'Off', 'On', 'Off', 'Off', 'Off', 'On', 'On', 'Off', 'Off');

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

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `msgId` int NOT NULL,
  `msgfor` tinyint NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `dPosted` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rechargetokens`
--

CREATE TABLE `rechargetokens` (
  `tId` int NOT NULL,
  `sId` int NOT NULL,
  `tRef` varchar(255) NOT NULL,
  `business` varchar(30) NOT NULL,
  `network` varchar(30) NOT NULL,
  `datasize` text NOT NULL,
  `quantity` int NOT NULL,
  `serial` text NOT NULL,
  `tokens` text NOT NULL,
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `Id` int NOT NULL,
  `issue_id` int DEFAULT NULL,
  `replyby` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reply` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reply_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `reports`
--

CREATE TABLE `reports` (
  `id` int NOT NULL,
  `user` int NOT NULL,
  `transid` varchar(255) NOT NULL,
  `placeholder` varchar(255) NOT NULL,
  `idNumber` varchar(100) NOT NULL,
  `response` text NOT NULL,
  `slip` varchar(255) DEFAULT NULL,
  `pdf` varchar(255) DEFAULT NULL,
  `date_created` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sitesettings`
--

CREATE TABLE `sitesettings` (
  `sId` int NOT NULL,
  `sitename` varchar(20) DEFAULT NULL,
  `siteurl` varchar(100) DEFAULT NULL,
  `agentupgrade` varchar(20) DEFAULT NULL,
  `vendorupgrade` varchar(20) DEFAULT NULL,
  `apidocumentation` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `whatsapp` varchar(20) DEFAULT NULL,
  `whatsappgroup` varchar(100) DEFAULT NULL,
  `facebook` varchar(200) DEFAULT NULL,
  `twitter` varchar(200) DEFAULT NULL,
  `instagram` varchar(200) DEFAULT NULL,
  `telegram` varchar(100) DEFAULT NULL,
  `referalupgradebonus` float NOT NULL DEFAULT '100',
  `referalairtimebonus` float NOT NULL DEFAULT '1',
  `referaldatabonus` float NOT NULL DEFAULT '1',
  `referalwalletbonus` float NOT NULL DEFAULT '1',
  `referalcablebonus` float NOT NULL DEFAULT '1',
  `referalexambonus` float NOT NULL DEFAULT '1',
  `referalmeterbonus` float NOT NULL DEFAULT '1',
  `wallettowalletcharges` float NOT NULL DEFAULT '50',
  `sitecolor` varchar(10) NOT NULL DEFAULT '#0000e6',
  `logindesign` varchar(10) NOT NULL DEFAULT '5',
  `homedesign` varchar(10) NOT NULL DEFAULT '5',
  `notificationStatus` varchar(5) NOT NULL DEFAULT 'Off',
  `accountname` varchar(50) DEFAULT NULL,
  `accountno` varchar(15) DEFAULT NULL,
  `bankname` varchar(20) DEFAULT NULL,
  `electricitycharges` varchar(5) DEFAULT NULL,
  `airtimemin` varchar(10) NOT NULL DEFAULT '50',
  `airtimemax` varchar(10) NOT NULL DEFAULT '500',
  `airtimedaily` varchar(255) NOT NULL DEFAULT '5000',
  `smilediscount` varchar(3) DEFAULT NULL,
  `kycOption` varchar(5) NOT NULL DEFAULT 'nin',
  `kycBvnCharges` varchar(5) NOT NULL DEFAULT '5',
  `kycNinCharges` varchar(5) NOT NULL DEFAULT '30',
  `kycShouldVerify` varchar(5) NOT NULL DEFAULT 'no',
  `kycShouldEnable` varchar(5) NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sitesettings`
--

INSERT INTO `sitesettings` (`sId`, `sitename`, `siteurl`, `agentupgrade`, `vendorupgrade`, `apidocumentation`, `phone`, `email`, `whatsapp`, `whatsappgroup`, `facebook`, `twitter`, `instagram`, `telegram`, `referalupgradebonus`, `referalairtimebonus`, `referaldatabonus`, `referalwalletbonus`, `referalcablebonus`, `referalexambonus`, `referalmeterbonus`, `wallettowalletcharges`, `sitecolor`, `logindesign`, `homedesign`, `notificationStatus`, `accountname`, `accountno`, `bankname`, `electricitycharges`, `airtimemin`, `airtimemax`, `airtimedaily`, `smilediscount`, `kycOption`, `kycBvnCharges`, `kycNinCharges`, `kycShouldVerify`, `kycShouldEnable`) VALUES
(1, 'ICEBILLS', 'https://icebills.com.ng', '500', '1000', '/mobile/home/apidocumentation', '07026417709', 'vtutelecom.com.ng@gmail.com', '07026417709', 'https://chat.whatsapp.com/DL4VEvRKF2t4D5vhltRaS1', 'https://www.facebook.com/profile.php?id=61556849872550', 'https://twitter.com/Sunusikir', 'instagram.com/sunusikiru', '@sunusi_kiru', 200, 1, 1, 1, 1, 1, 1, 1000000, '#ff0000', '1', '6', 'On', 'Aminu kassim muhammad ', '9161636816', 'Paycom(opay)', '50', '50', '3000', '4000', '1', 'nin', '5', '30', 'yes', 'no');

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

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `sId` int NOT NULL,
  `sApiKey` varchar(200) NOT NULL,
  `sFname` varchar(50) NOT NULL,
  `sLname` varchar(50) NOT NULL,
  `sEmail` varchar(50) DEFAULT NULL,
  `sPhone` varchar(20) NOT NULL,
  `sPass` varchar(150) NOT NULL,
  `sState` varchar(50) NOT NULL,
  `sPin` int NOT NULL DEFAULT '1234',
  `sPinStatus` tinyint DEFAULT '0',
  `sType` tinyint NOT NULL DEFAULT '1',
  `sWallet` float NOT NULL DEFAULT '0',
  `sRefWallet` float NOT NULL DEFAULT '0',
  `sBankNo` varchar(20) DEFAULT NULL,
  `sRolexBank` varchar(20) DEFAULT NULL,
  `sSterlingBank` varchar(20) DEFAULT NULL,
  `sFidelityBank` varchar(20) DEFAULT NULL,
  `sBankName` varchar(30) DEFAULT NULL,
  `sAsfiyBank` varchar(255) DEFAULT NULL,
  `s9PSBBank` varchar(255) DEFAULT NULL,
  `sRegStatus` tinyint NOT NULL DEFAULT '3',
  `sVerCode` smallint NOT NULL DEFAULT '0',
  `sRegDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sLastActivity` datetime DEFAULT NULL,
  `sReferal` varchar(15) DEFAULT NULL,
  `sBvn` varchar(40) DEFAULT NULL,
  `sNin` varchar(40) DEFAULT NULL,
  `sDob` varchar(40) DEFAULT NULL,
  `sKycStatus` varchar(15) DEFAULT NULL,
  `accountReference` varchar(50) DEFAULT NULL,
  `sPayvesselBank` varchar(30) DEFAULT NULL,
  `sAccountLimit` varchar(255) DEFAULT '5000',
  `sPagaBank` varchar(30) DEFAULT NULL,
  `pVerify` varchar(255) DEFAULT NULL,
  `sPalmpayBank` varchar(250) DEFAULT NULL,
  `sPaga` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`sId`, `sApiKey`, `sFname`, `sLname`, `sEmail`, `sPhone`, `sPass`, `sState`, `sPin`, `sPinStatus`, `sType`, `sWallet`, `sRefWallet`, `sBankNo`, `sRolexBank`, `sSterlingBank`, `sFidelityBank`, `sBankName`, `sAsfiyBank`, `s9PSBBank`, `sRegStatus`, `sVerCode`, `sRegDate`, `sLastActivity`, `sReferal`, `sBvn`, `sNin`, `sDob`, `sKycStatus`, `accountReference`, `sPayvesselBank`, `sAccountLimit`, `sPagaBank`, `pVerify`, `sPalmpayBank`, `sPaga`) VALUES
(1, '6B4x9it1CAAA3z16BFDsCd5CCeACCCB572xo893CbAnlfdCIA43gkrpwmyxE1730710594', 'Sunusi habib', 'Kasim', 'sunusihabibkasim6@gmail.com', '07026417709', 'b3892034d7', 'Kano', 3636, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 7664, '2024-11-04 09:56:34', '2024-11-05 17:02:33', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, NULL, NULL),
(2, 'Ah3GC42xocpr6y8C3IcxJCbeBxBnq81BCtCAxEB1dl3AgAbAkAvA5CwC96Hs1730720859', 'VICTOR', 'NEBO', 'michaelvicky260@gmail.com', '08137548087', '4209cb3cfd', 'Sokoto', 1212, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 7317, '2024-11-04 12:47:39', '2024-11-05 14:54:56', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, NULL, NULL),
(3, 'BA1I936Cxp5AmBB7CF0yAEsnA9CzCq3d6H2C822xaGwbhAAB4B4C13ACCr8J1730821726', 'Mansur', 'Bashir', 'mansurb691@gmail.com', '08137609212', '007ef8cae6', 'Kaduna', 9764, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2244, '2024-11-05 16:48:46', '2024-11-05 16:49:42', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, NULL, NULL),
(4, 'a24I9tpAAb4B9d67oChFbE3B38qyAAmCAvxC605dBe7l1f328AgCkAHCcB521731881883', 'Aminu', 'Kassim', 'kassimmuhammadaminu@gmail.com', '09012345678', '2ea75c5cc5', 'Kano', 12345, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 7527, '2024-11-17 22:18:03', '2024-11-18 17:04:40', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, '6600568210', NULL),
(5, '8B3BAzACA1AexBJp2nahd9qEc7Hv4CCos1kCABD55i6brA4Gtx0xAclCCCg31733069621', 'Aminu', 'Kassim ', 'akassim692@gmail.com', '09161636816', '7bee4e877e', 'Kano', 2003, 0, 1, 0, 0, NULL, NULL, NULL, NULL, NULL, '1250835509', NULL, 0, 4646, '2024-12-01 19:13:41', '2024-12-03 20:21:08', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, NULL, '6619925420'),
(6, 'cxCeH3Bd254Am3aBCkAChCsocA8tC9w1nF9bpB136C628IAD4l7ArAvG2di01733069732', 'Caleb', 'Musa', 'calebmusa339@gmail.com', '09047015532', 'b1d81ae1a3', 'Adamawa', 1122, 0, 1, 74, 0, NULL, NULL, NULL, NULL, NULL, '1611508855', NULL, 0, 7233, '2024-12-01 19:15:32', '2024-12-03 20:33:11', '', NULL, NULL, NULL, NULL, NULL, NULL, '5000', NULL, NULL, NULL, '6650456571');

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

--
-- Table structure for table `sysusers`
--

CREATE TABLE `sysusers` (
  `sysId` int NOT NULL,
  `sysName` varchar(50) NOT NULL,
  `sysRole` tinyint NOT NULL,
  `sysUsername` varchar(20) NOT NULL,
  `sysToken` varchar(30) NOT NULL,
  `sysStatus` tinyint NOT NULL DEFAULT '0',
  `sysPinToken` varchar(30) NOT NULL DEFAULT '03d258c7ef',
  `sysPinStatus` tinyint NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sysusers`
--

INSERT INTO `sysusers` (`sysId`, `sysName`, `sysRole`, `sysUsername`, `sysToken`, `sysStatus`, `sysPinToken`, `sysPinStatus`) VALUES
(2, 'Sunusi Habib kasim ', 1, 'admin', '@admin', 0, '05723f16df', 0);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `tId` int NOT NULL,
  `sId` int NOT NULL,
  `transref` varchar(255) NOT NULL,
  `servicename` varchar(100) NOT NULL,
  `servicedesc` varchar(255) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `status` tinyint NOT NULL,
  `oldbal` varchar(100) NOT NULL,
  `newbal` varchar(100) NOT NULL,
  `profit` float NOT NULL DEFAULT '0',
  `date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `api_response` text,
  `api_response_log` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`tId`, `sId`, `transref`, `servicename`, `servicedesc`, `amount`, `status`, `oldbal`, `newbal`, `profit`, `date`, `api_response`, `api_response_log`) VALUES
(1, 6, 'PAGA_MI1863887280838782976', 'Wallet Topup', 'Wallet funding of N100 via Paga bank transfer with a service charges of N2. You wallet have been credited with N98', '98', 0, '0', '98', 0, '2024-12-03 11:05:41', NULL, NULL),
(2, 6, '47911733220364', 'Airtime', 'MTN Airtime purchase of N50 for phone number 07049733603', '49.5', 1, '98', '98', 0, '2024-12-03 11:06:38', NULL, '{\"detail\":\"Invalid token.\"}'),
(3, 6, '64541733244053', 'Airtime', 'MTN Airtime purchase of N50 for phone number 07049733603', '49.5', 1, '98', '98', 0, '2024-12-03 17:41:19', NULL, '{\"detail\":\"Invalid token.\"}'),
(4, 6, '82301733253902', 'Data', 'Dear Customer, You have gifted 25MB Data to 2347049733603, please dial *460*260# to check your balance. Thank you. Your new balance (GB) is ', '24', 0, '98', '74', 0, '2024-12-03 20:29:26', NULL, '{\"id\":184151269,\"ident\":\"Data99346461999209117872\",\"api_response\":\"Dear Customer, You have gifted 25MB Data to 2347049733603, please dial *460*260# to check your balance. Thank you. Your new balance (GB) is \",\"customer_ref\":\"\",\"network\":1,\"balance_before\":\"99.0\",\"balance_after\":\"75.0\",\"mobile_number\":\"07049733603\",\"plan\":311,\"Status\":\"successful\",\"plan_network\":\"MTN\",\"plan_name\":\"25.0MB\",\"plan_amount\":\"24.0\",\"create_date\":\"2024-12-03T20:29:26.483407\",\"Ported_number\":true}'),
(5, 6, '65991733254209', 'Airtime', 'MTN Airtime purchase of N50 for phone number 07049733603', '49.5', 1, '74', '74', 0, '2024-12-03 20:30:37', NULL, '{\"error\":[\"minimum airtime topup is N100\"]}');

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

--
-- Table structure for table `userlogin`
--

CREATE TABLE `userlogin` (
  `id` int NOT NULL,
  `user` int NOT NULL,
  `token` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `userlogin`
--

INSERT INTO `userlogin` (`id`, `user`, `token`) VALUES
(1, 1, '1730710594CmtnADFpxv201'),
(2, 1, '1730712303HvlxGqontp763'),
(3, 1, '1730716754wExInpskGA988'),
(4, 1, '1730719265nIryGJqltp106'),
(5, 2, '1730720859BvHIkpClqy406'),
(6, 1, '1730813603mkJwvIxonz401'),
(7, 2, '1730814828EsprJoGDxB517'),
(8, 3, '1730821726AmxJDCtFIr976'),
(9, 1, '1730822446kmqvFylAoz320'),
(10, 4, '1731881911wAlrqynDoC931'),
(11, 4, '1731908085yBEGCJmkvF941'),
(12, 4, '1731911712HoItCyElFx604'),
(13, 4, '1731913443IwkxlFzvBC569'),
(14, 4, '1731916144GJlDxtnzwk347'),
(15, 4, '1731916392pmknzrAvwC924'),
(16, 4, '1731916559oyJDtszBmx498'),
(17, 4, '1731917762GmnqxryHIJ854'),
(18, 4, '1731940874EnDlkJGozI451'),
(19, 4, '1731945464EAxFoCrIBq186'),
(20, 5, '1733069621plIBGHqDAJ291'),
(21, 6, '1733069732mpxEBwCIAl416'),
(22, 5, '1733076954tnlqHrDxwG264'),
(23, 5, '1733077951zklGnvHrmJ741'),
(24, 6, '1733080301nJIoktHACD253'),
(25, 6, '1733093007nFlxwyAzmJ904'),
(26, 6, '1733101797mywrtBoAvG491'),
(27, 6, '1733101798vkmpBHrlsw222'),
(28, 5, '1733121142CEowGsxyDq334'),
(29, 5, '1733143114nHsmtFJIEk499'),
(30, 5, '1733143124JlzrwsxAFE841'),
(31, 5, '1733143135zIDJxkAtvF653'),
(32, 5, '1733148534xJFtpkEyCm845'),
(33, 6, '1733159546Frqtszvkop300'),
(34, 6, '1733167630npoClBJEIx893'),
(35, 6, '1733167989lvmArCzDxs990'),
(36, 5, '1733169373AmCxrvqJGz433'),
(37, 5, '1733169397kIrCynvEtF261'),
(38, 5, '1733169413wClosGIkzn700'),
(39, 6, '1733169482vmAIoCsGBn531'),
(40, 5, '1733213976mCoDtIxlrA388'),
(41, 6, '1733220079CmBoIwzxlG252'),
(42, 6, '1733244032pHGElFqkDy571'),
(43, 5, '1733253619BrwJDmlkGo403'),
(44, 6, '1733253850BDHzmFxylo698');

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

--
-- Table structure for table `uservisits`
--

CREATE TABLE `uservisits` (
  `id` int NOT NULL,
  `user` int NOT NULL,
  `state` varchar(10) NOT NULL,
  `visitTime` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uservisits`
--

INSERT INTO `uservisits` (`id`, `user`, `state`, `visitTime`) VALUES
(1, 1, 'Kano', '1730710603'),
(2, 1, 'Kano', '1730712306'),
(3, 2, 'Sokoto', '1730720868'),
(4, 3, 'Kaduna', '1730821735'),
(5, 4, 'Kano', '1731913445'),
(6, 4, 'Kano', '1731916394'),
(7, 4, 'Kano', '1731916561'),
(8, 4, 'Kano', '1731940877'),
(9, 5, 'Kano', '1733069627'),
(10, 6, 'Adamawa', '1733069735'),
(11, 5, 'Kano', '1733077953'),
(12, 6, 'Adamawa', '1733167643');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `airtime`
--
ALTER TABLE `airtime`
  ADD PRIMARY KEY (`aId`);

--
-- Indexes for table `airtimepin`
--
ALTER TABLE `airtimepin`
  ADD PRIMARY KEY (`id`),
  ADD KEY `aNetwork` (`aNetwork`);

--
-- Indexes for table `airtimepinprice`
--
ALTER TABLE `airtimepinprice`
  ADD PRIMARY KEY (`aId`);

--
-- Indexes for table `airtimepinstock`
--
ALTER TABLE `airtimepinstock`
  ADD PRIMARY KEY (`id`),
  ADD KEY `aNetwork` (`aNetwork`);

--
-- Indexes for table `alphatopupprice`
--
ALTER TABLE `alphatopupprice`
  ADD PRIMARY KEY (`alphaId`);

--
-- Indexes for table `apiconfigs`
--
ALTER TABLE `apiconfigs`
  ADD PRIMARY KEY (`aId`);

--
-- Indexes for table `apilinks`
--
ALTER TABLE `apilinks`
  ADD PRIMARY KEY (`aId`);

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

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

--
-- Indexes for table `cableid`
--
ALTER TABLE `cableid`
  ADD PRIMARY KEY (`cId`);

--
-- Indexes for table `cableplans`
--
ALTER TABLE `cableplans`
  ADD PRIMARY KEY (`cpId`);

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

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`msgId`);

--
-- Indexes for table `datapins`
--
ALTER TABLE `datapins`
  ADD PRIMARY KEY (`dpId`);

--
-- Indexes for table `dataplans`
--
ALTER TABLE `dataplans`
  ADD PRIMARY KEY (`pId`);

--
-- Indexes for table `datatokens`
--
ALTER TABLE `datatokens`
  ADD PRIMARY KEY (`tId`);

--
-- Indexes for table `electricityid`
--
ALTER TABLE `electricityid`
  ADD PRIMARY KEY (`eId`);

--
-- Indexes for table `examid`
--
ALTER TABLE `examid`
  ADD PRIMARY KEY (`eId`);

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

--
-- Indexes for table `manualfunds`
--
ALTER TABLE `manualfunds`
  ADD PRIMARY KEY (`tId`),
  ADD KEY `fk_sId` (`sId`);

--
-- Indexes for table `monnify_accounts`
--
ALTER TABLE `monnify_accounts`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `accountReference` (`accountReference`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `networkid`
--
ALTER TABLE `networkid`
  ADD PRIMARY KEY (`nId`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`msgId`);

--
-- Indexes for table `rechargetokens`
--
ALTER TABLE `rechargetokens`
  ADD PRIMARY KEY (`tId`);

--
-- Indexes for table `replies`
--
ALTER TABLE `replies`
  ADD PRIMARY KEY (`Id`),
  ADD KEY `fk_issue_id` (`issue_id`);

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

--
-- Indexes for table `sitesettings`
--
ALTER TABLE `sitesettings`
  ADD PRIMARY KEY (`sId`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`sId`),
  ADD UNIQUE KEY `sApiKey` (`sApiKey`),
  ADD UNIQUE KEY `sPhone` (`sPhone`),
  ADD UNIQUE KEY `sEmail` (`sEmail`);

--
-- Indexes for table `sysusers`
--
ALTER TABLE `sysusers`
  ADD PRIMARY KEY (`sysId`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`tId`),
  ADD UNIQUE KEY `transref` (`transref`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `airtime`
--
ALTER TABLE `airtime`
  MODIFY `aId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `airtimepin`
--
ALTER TABLE `airtimepin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `airtimepinprice`
--
ALTER TABLE `airtimepinprice`
  MODIFY `aId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `airtimepinstock`
--
ALTER TABLE `airtimepinstock`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `alphatopupprice`
--
ALTER TABLE `alphatopupprice`
  MODIFY `alphaId` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `apiconfigs`
--
ALTER TABLE `apiconfigs`
  MODIFY `aId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=194;

--
-- AUTO_INCREMENT for table `apilinks`
--
ALTER TABLE `apilinks`
  MODIFY `aId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=155;

--
-- AUTO_INCREMENT for table `beneficiary`
--
ALTER TABLE `beneficiary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `blacklist`
--
ALTER TABLE `blacklist`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `cableid`
--
ALTER TABLE `cableid`
  MODIFY `cId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `cableplans`
--
ALTER TABLE `cableplans`
  MODIFY `cpId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=46;

--
-- AUTO_INCREMENT for table `CAC`
--
ALTER TABLE `CAC`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `msgId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `datapins`
--
ALTER TABLE `datapins`
  MODIFY `dpId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `dataplans`
--
ALTER TABLE `dataplans`
  MODIFY `pId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=171;

--
-- AUTO_INCREMENT for table `datatokens`
--
ALTER TABLE `datatokens`
  MODIFY `tId` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `electricityid`
--
ALTER TABLE `electricityid`
  MODIFY `eId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `examid`
--
ALTER TABLE `examid`
  MODIFY `eId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `issues`
--
ALTER TABLE `issues`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=177;

--
-- AUTO_INCREMENT for table `manualfunds`
--
ALTER TABLE `manualfunds`
  MODIFY `tId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `monnify_accounts`
--
ALTER TABLE `monnify_accounts`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `networkid`
--
ALTER TABLE `networkid`
  MODIFY `nId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `msgId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `rechargetokens`
--
ALTER TABLE `rechargetokens`
  MODIFY `tId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `replies`
--
ALTER TABLE `replies`
  MODIFY `Id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `reports`
--
ALTER TABLE `reports`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sitesettings`
--
ALTER TABLE `sitesettings`
  MODIFY `sId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `sId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `sysusers`
--
ALTER TABLE `sysusers`
  MODIFY `sysId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `tId` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `userlogin`
--
ALTER TABLE `userlogin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;

--
-- AUTO_INCREMENT for table `uservisits`
--
ALTER TABLE `uservisits`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
COMMIT;

