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

START TRANSACTION;



--
-- Database: `cidapayc_solution`
--

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

--
-- Table structure for table `api`
--

CREATE TABLE `api` (
  `id` int(11) NOT NULL,
  `service` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `contract_code` varchar(255) NOT NULL,
  `public_key` varchar(255) NOT NULL,
  `secret_key` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `api`
--

INSERT INTO `api` (`id`, `service`, `name`, `contract_code`, `public_key`, `secret_key`, `url`, `status`) VALUES
(20, 'AIRTIME_MTN', 'TGR', '', '', 'Bearer 2|bQAong9094UIrFqjKVbOv0IR0MwbPjUc8HV9AM6t48cbd9e0', 'https://business.topupandgetreward.com/api/mtn/airtime', 'On'),
(53, 'AIRTIME_AIRTEL', 'TGR', '', '', 'Bearer 2|bQAong9094UIrFqjKVbOv0IR0MwbPjUc8HV9AM6t48cbd9e0', 'https://business.topupandgetreward.com/api/airtel/airtime', 'On'),
(54, 'AIRTIME_9MOBILE', 'TGR', '', '', '2|bQAong9094UIrFqjKVbOv0IR0MwbPjUc8HV9AM6t48cbd9e0', 'https://business.topupandgetreward.com/api/airtel/airtime', 'On'),
(55, 'AIRTIME_GLO', 'TGR', '', '', 'Bearer 2|bQAong9094UIrFqjKVbOv0IR0MwbPjUc8HV9AM6t48cbd9e0', 'https://business.topupandgetreward.com/api/glo/airtime', 'On');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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

