-- Topupmate Technology Limited
-- Version 4.0
-- https://topupmate.com/welcome
--
-- Licensed VTU Script Software
-- All Right Reserved
-- support@topupmate.com
-- 07032529431

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `topupmate`
--

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

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

CREATE TABLE `airtime` (
  `aId` int(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `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;

-- ALTER TABLE airtime ADD `aBuyDiscount` float NOT NULL DEFAULT 96;
--
-- Dumping data for table `Topupmate Technology Limited`
--

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


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

CREATE TABLE `airtimepinprice` (
  `aId` int(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `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 `apiconfigs`
--
-- --------------------------------------------------------

CREATE TABLE `apiconfigs` (

  `aId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(30) NOT NULL,
  `value` varchar(100) NULL
);

INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyCharges","1.075");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifySecrete","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyContract","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyWeStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyMoStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyFeStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifySaStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("monifyStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("paystackCharges","1.5");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("paystackApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("paystackStatus","Off");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnVtuKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnVtuProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnSharesellKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnSharesellProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelVtuKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelVtuProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelSharesellKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelSharesellProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloVtuKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloVtuProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloSharesellKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloSharesellProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileVtuKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileVtuProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileSharesellKey","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileSharesellProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnSmeApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnSmeProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnGiftingApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnGiftingProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnCorporateApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("mtnCorporateProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelSmeApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelSmeProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelGiftingApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelGiftingProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelCorporateApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("airtelCorporateProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloSmeApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloSmeProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloGiftingApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloGiftingProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloCorporateApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("gloCorporateProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileSmeApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileSmeProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileGiftingApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileGiftingProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileCorporateApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("9mobileCorporateProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("cableVerificationApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("cableVerificationProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("cableApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("cableProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("meterVerificationApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("meterVerificationProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("meterApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("meterProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("examApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("examProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("rechargePinApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("rechargePinProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletOneApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletOneProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletOneProviderName","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletTwoApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletTwoProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletTwoProviderName","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletThreeApi","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletThreeProvider","");
INSERT INTO `apiconfigs` (`name`,`value`) VALUES ("walletThreeProviderName","");

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

CREATE TABLE `apilinks` (
  `aId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `name` varchar(30) NOT NULL,
  `value` varchar(100) NULL,
  `type` varchar(20) NULL
);

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/airtime/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/cabletv/verify/","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/cabletv/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/electricity/verify/","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/electricity/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Topupmate","https://topupmate.com/api/exam/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/cable/cable-validation","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/cable/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/bill/bill-validation","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/bill/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("N3T Data","https://n3tdata.com/api/exam/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/cable/cable-validation","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/cable/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/bill/bill-validation","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/bill/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Bilalsadasub","https://bilalsadasub.com/api/exam/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/validateiuc","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/cablesub/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/validatemeter","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/billpayment/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Aabaxztech","https://aabaxztech.com/api/epin/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/validateiuc","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/cablesub/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/validatemeter","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/billpayment/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Maskawasub","https://maskawasub.com/api/epin/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/validateiuc","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/cablesub/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/validatemeter","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/billpayment/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Husmodataapi","https://husmodataapi.com/api/epin/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/validateiuc","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/cablesub/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/validatemeter","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/billpayment/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Gongozconcept","https://gongozconcept.com/api/epin/","Exam");

INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/user/","Wallet");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/topup/","Airtime");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/data/","Data");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/ajax/validate_iuc","CableVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/cablesub/","Cable");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/validatemeter","ElectricityVer");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/billpayment/","Electricity");
INSERT INTO `apilinks` (`name`,`value`,`type`) VALUES ("Sabrdataapi","https://sabrdataapi.com/api/epin/","Exam");

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

CREATE TABLE `sitesettings` (
  `sId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sitename` varchar(20) NULL,
  `siteurl` varchar(100) NULL,
  `agentupgrade` varchar(20) NULL,
  `vendorupgrade` varchar(20) NULL,
  `apidocumentation` varchar(100) NULL,
  `phone` varchar(20) NULL,
  `email` varchar(50) NULL,
  `whatsapp` varchar(20) NULL ,
  `whatsappgroup` varchar(100) NULL,
  `facebook` varchar(10) NULL,
  `twitter` varchar(200)  NULL,
  `instagram` varchar(200) NULL,
  `telegram` varchar(100) 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)  NULL,
  `accountno` varchar(15) NULL,
  `bankname` varchar(20) NULL,
  `electricitycharges` varchar(5) NULL,
  `airtimemin` varchar(10) NOT NULL DEFAULT "50",
  `airtimemax` varchar(10) NOT NULL DEFAULT "500"
  
  
  
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `sitesettings` (`sId`, `sitename`,`siteurl`, `agentupgrade`, `vendorupgrade`, `apidocumentation`) VALUES
(1, 'Topupmate','https://topupmate.com', '1000', '2000', 'https://topupmate.com');

-- alter table sitesettings add `referalupgradebonus` int(10) NOT NULL DEFAULT 100;
-- alter table sitesettings add  `referalairtimebonus` int(10) NOT NULL DEFAULT 1;
-- alter table sitesettings add  `referaldatabonus` int(10) NOT NULL DEFAULT 5;
-- alter table sitesettings add  `referalwalletbonus` int(10) NOT NULL DEFAULT 5;
-- alter table sitesettings add  `referalcablebonus` int(10) NOT NULL DEFAULT 5;
-- alter table sitesettings add  `referalexambonus` int(10) NOT NULL DEFAULT 5;
-- alter table sitesettings add  `referalmeterbonus` int(10) NOT NULL DEFAULT 5;
-- alter table sitesettings add  `wallettowalletcharges` int(10) NOT NULL DEFAULT 50;
-- alter table sitesettings add `sitecolor` varchar(10) NOT NULL DEFAULT "#00c6fb";
-- alter table sitesettings add `notificationStatus` varchar(5) NOT NULL DEFAULT "Off";
-- alter table sitesettings add `logindesign` varchar(10) NOT NULL DEFAULT "5";
-- alter table sitesettings add `homedesign` varchar(10) NOT NULL DEFAULT "5";
-- alter table sitesettings add `accountname` varchar(50)  NULL;
-- alter table sitesettings add  `accountno` varchar(15) NULL;
-- alter table sitesettings add `bankname` varchar(20) NULL;
-- alter table sitesettings add `electricitycharges` varchar(5) NULL;
-- alter table sitesettings add `airtimemin` varchar(10) NOT NULL DEFAULT "50";
-- alter table sitesettings add `airtimemax` varchar(10) NOT NULL DEFAULT "500";


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

CREATE TABLE `contact` (
  `msgId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sId` int(100) 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');

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

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

CREATE TABLE `dataplans` (
  `pId` int(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `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(10) 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
(1, '500 MB', '115', '150', '120', '110', '1', 'SME', 1, '30'),
(2, '1GB', '225', '250', '230', '230', '2', 'SME', 1, '30'),
(3, '2GB', '450', '500', '480', '450', '3', 'SME', 1, '30'),
(4, '3GB', '675', '700', '685', '650', '4', 'SME', 1, '30'),
(5, '5GB', '1125', '1200', '1150', '1100', '5', 'SME', 1, '30'),
(6, '10GB', '2250', '2500', '2350', '2300', '6', 'SME', 1, '30');


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


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

--
-- Table structure for table `networkid`
--
 
CREATE TABLE `networkid` (
  `nId` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `networkid` varchar(10) NOT NULL,
  `smeId` varchar(10) NOT NULL,
  `giftingId` varchar(10) NOT NULL,
  `corporateId` 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",
  `giftingStatus` varchar(10) NOT NULL DEFAULT "Off",
  `corporateStatus` varchar(10) NOT NULL DEFAULT "Off"
);

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

INSERT INTO `networkid` (`nId`,`networkid`,`smeId`,`giftingId`,`corporateId`,`vtuId`,`sharesellId`, `network`) VALUES
(1, '1','1','1','1','1','1','MTN'),
(2, '2','2','2','2','2','2','GLO'),
(3, '3','3','3','3','3','3','9MOBILE'),
(4, '4','4','4','4','4','4','AIRTEL');


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

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

CREATE TABLE `notifications` (
  `msgId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `msgfor` tinyint(4) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(3) NOT NULL DEFAULT 0,
  `dPosted` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`msgId`, `msgfor`, `subject`, `message`, `status`, `dPosted`) VALUES
(1, 3, 'Welcome Message', 'Hi There! You are welcome, we are your one-stop platform for all for bills payment, airtime, data plans, and cable tv subscription. All our services are available to you at a discount rate. Our customer support team is available to you 24/7.', 0, '2022-06-21 17:05:02');

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

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

CREATE TABLE `subscribers` (
  `sId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sApiKey` varchar(200) NOT NULL UNIQUE KEY,
  `sFname` varchar(50) NOT NULL,
  `sLname` varchar(50) NOT NULL,
  `sEmail` varchar(50) DEFAULT NULL UNIQUE KEY,
  `sPhone` varchar(20) NOT NULL UNIQUE KEY,
  `sPass` varchar(150) NOT NULL,
  `sState` varchar(50) NOT NULL,
  `sPin` int(10) NOT NULL DEFAULT 1234,
  `sPinStatus` tinyint(3) NULL DEFAULT 0,
  `sType` tinyint(10) NOT NULL DEFAULT 1,
  `sWallet` float NOT NULL DEFAULT 0,
  `sRefWallet` float NOT NULL DEFAULT 0,
  `sBankNo` varchar(20) NULL,
  `sRolexBank` varchar(20) NULL,
  `sSterlingBank` varchar(20) NULL,
  `sFidelityBank` varchar(20) NULL,
  `sBankName` varchar(30) NULL,
  `sRegStatus` tinyint(5) NOT NULL DEFAULT 3,
  `sVerCode` smallint(20) NOT NULL DEFAULT 0,
  `sRegDate` datetime NOT NULL DEFAULT current_timestamp(),
  `sLastActivity` datetime DEFAULT NULL,
  `sReferal` varchar(15) NULL
   
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- alter table subscribers add `sRefWallet` int(100) NOT NULL DEFAULT 0;
-- alter table subscribers add  `sReferal` varchar(15) NULL;
-- ALTER TABLE `subscribers` ADD `sRolexBank` VARCHAR(30) NULL DEFAULT NULL AFTER `sBankNo`, ADD `sSterlingBank` VARCHAR(30) NULL DEFAULT NULL AFTER `sRolexBank`;
-- ALTER TABLE `subscribers` ADD `sFidelityBank` VARCHAR(30) NULL DEFAULT NULL AFTER `sSterlingBank`;
-- ALTER TABLE `subscribers` ADD `sPinStatus` tinyint(3) NULL DEFAULT 0 AFTER `sPin`;


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

INSERT INTO `subscribers` (`sId`, `sApiKey`, `sFname`, `sLname`, `sEmail`, `sPhone`, `sPass`, `sState`, `sPin`, `sType`, `sWallet`, `sBankNo`, `sBankName`, `sRegStatus`, `sVerCode`, `sRegDate`, `sLastActivity`) VALUES
(1, '122234', 'Guest', 'Guest', 'guest@gmail.com', '09011111111111', '1234', 'Abuja', 1234, 1, 0, '0', '0', 0, 0, '2022-06-21 03:25:32', '2022-05-03 00:00:00');

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

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

CREATE TABLE `sysusers` (
  `sysId` int(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sysName` varchar(50) NOT NULL,
  `sysRole` tinyint(2) NOT NULL,
  `sysUsername` varchar(20) NOT NULL,
  `sysToken` varchar(30) NOT NULL,
  `sysStatus` tinyint(2) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `sysusers` (`sysId`, `sysName`, `sysRole`, `sysUsername`, `sysToken`, `sysStatus`) VALUES
(1, 'Topupmate LTD', 1, 'admin', 'admin', 0);

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

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

CREATE TABLE `transactions` (
  `tId` int(200) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `sId` int(100) NOT NULL,
  `transref` varchar(255) NOT NULL UNIQUE KEY,
  `servicename` varchar(100) NOT NULL,
  `servicedesc` varchar(255) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `status` tinyint(5) 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()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ALTER TABLE transactions ADD `profit` float NOT NULL DEFAULT 0;

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

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

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


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

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


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

CREATE TABLE `examid` (
  `eId` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `examid` varchar(10),
  `provider` varchar(50) NOT NULL,
  `price` int(20) NOT NULL DEFAULT 0,
  `buying_price` int(20) NOT NULL DEFAULT 0,
  `providerStatus` varchar(10) NOT NULL DEFAULT "On"
);

-- ALTER TABLE examid ADD `buying_price` int(20) NOT NULL DEFAULT 0;

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

INSERT INTO `examid` (`eId`, `examid`, `provider`,`price`) VALUES 
(1, '1', 'WAEC' ,1800), (2, '2', 'NECO', 800), (3, '3', 'NABTEB',950);

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

CREATE TABLE `electricityid` (
  `eId` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `electricityid` varchar(50),
  `provider` varchar(50) NOT NULL,
  `abbreviation` varchar(5) NOT NULL,
  `providerStatus` varchar(10) NOT NULL DEFAULT "On"
);

-- ALTER TABLE electricityid ADD `abbreviation` varchar(5) NULL;

--
-- 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 `cableid`
--

CREATE TABLE `cableid` (
  `cId` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `cableid` varchar(10),
  `provider` varchar(10) NOT NULL,
  `providerStatus` varchar(10) NOT NULL DEFAULT "On"
);

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

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

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

CREATE TABLE `cableplans` (
  `cpId` int(100) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `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(10) 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
(1, 'Gotv Smallie', '900', '1000', '970', '950', '55', NULL, 1, '30'),
(2, 'Gotv Jinja', '1900', '2000', '1950', '1930', '61', NULL, 1, '30'),
(3, 'Gotv Jolli', '2800', '3000', '2900', '2900', '60', NULL, 1, '30'),
(4, 'Gotv Max', '4150', '4300', '4250', '4200', '59', NULL, 1, '30'),
(5, 'Gotv Supa', '5500', '5600', '5550', '5550', '58', NULL, 1, '30'),
(6, 'Dstv Padi', '2150', '2300', '2200', '2170', '1', NULL, 2, '30'),
(7, 'Dstv Yanga', '2950', '3100', '3000', '2970', '2', NULL, 2, '30'),
(8, 'Dstv Confam', '5300', '5400', '5370', '5350', '3', NULL, 2, '30'),
(9, 'Dstv Compact', '9000', '9100', '9070', '9050', '4', NULL, 2, '30'),
(10, 'Dstv Compact Plus', '14250', '14400', '14350', '14300', '7', NULL, 2, '30'),
(11, 'Dstv Premiun', '21000', '21100', '21050', '21030', '5', NULL, 2, '30'),
(12, 'Dstv Premiun Asia', '23500', '23600', '23550', '23530', '9', NULL, 2, '30'),
(13, 'Nova', '900', '1000', '950', '930', '66', NULL, 3, '30'),
(14, 'Basic (Antenna)', '1700', '1800', '1750', '1730', '67', NULL, 3, '30'),
(15, 'Smart (Dish)', '2600', '2700', '2750', '2730', '68', NULL, 3, '30'),
(16, 'Classic (Antenna)', '2750', '2850', '2800', '2780', '69', NULL, 3, '30'),
(17, 'Super (Dish)', '4900', '5000', '4950', '4930', '70', NULL, 3, '30');



/*!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 */;
