-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jul 25, 2021 at 01:47 PM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

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

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

--
-- Table structure for table `sms_in`
--

CREATE TABLE IF NOT EXISTS `sms_in` (
  `id` int(11) NOT NULL,
  `sms_text` varchar(1600) DEFAULT NULL,
  `sender_number` varchar(50) DEFAULT NULL,
  `sent_dt` datetime DEFAULT NULL,
  `code` varchar(15) NOT NULL,
  `amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `firstname` varchar(15) NOT NULL,
  `lastname` varchar(15) NOT NULL,
  `msisdn` varchar(20) NOT NULL,
  `used` int(5) NOT NULL DEFAULT '0',
  `exactime` datetime NOT NULL,
  `txn_time` varchar(50) DEFAULT NULL,
  `middlename` varchar(50) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `business_shortcode` varchar(50) DEFAULT NULL,
  `transactionType` varchar(30) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sms_in`
--

INSERT INTO `sms_in` (`id`, `sms_text`, `sender_number`, `sent_dt`, `code`, `amount`, `firstname`, `lastname`, `msisdn`, `used`, `exactime`, `txn_time`, `middlename`, `account_number`, `business_shortcode`, `transactionType`) VALUES
(1, 'PGP6RIEXOK Confirmed.on 25/7/21 at 1:45 PMKsh1.00 received from 254707699136 DENNIS KIPNGETICH MUTAI. New Account balance is Ksh3,239.81. Transaction cost, Ksh0.00.', '254707699136', '2021-07-25 13:45:10', 'PGP6RIEXOK', '1.00', 'DENNIS', 'KIPNGETICH', '', 2, '2021-07-25 13:45:10', NULL, NULL, NULL, NULL, NULL),
(2, 'PGP0RINEQM Confirmed.on 25/7/21 at 1:50 PMKsh1,700.00 received from 254743454210 NANCY MWAITSI AKWEYU. New Account balance is Ksh4,931.31. Transaction cost, Ksh8.50.', '254743454210', '2021-07-25 13:50:09', 'PGP0RINEQM', '1700.00', 'NANCY', 'MWAITSI', '', 2, '2021-07-25 13:50:09', NULL, NULL, NULL, NULL, NULL),
(3, 'PGP9RIR8VN Confirmed.on 25/7/21 at 1:52 PMKsh580.00 received from 254717760277 NANCY MWAITSI AKWEYU. New Account balance is Ksh5,508.41. Transaction cost, Ksh2.90.', '254717760277', '2021-07-25 13:52:22', 'PGP9RIR8VN', '580.00', 'NANCY', 'MWAITSI', '', 2, '2021-07-25 13:52:22', NULL, NULL, NULL, NULL, NULL),
(4, 'PGP9RJDYBZ Confirmed.on 25/7/21 at 2:05 PMKsh1.00 received from 254707699136 DENNIS KIPNGETICH MUTAI. New Account balance is Ksh5,509.41. Transaction cost, Ksh0.00.', '254707699136', '2021-07-25 14:05:29', 'PGP9RJDYBZ', '1.00', 'DENNIS', 'KIPNGETICH', '', 2, '2021-07-25 14:05:29', NULL, NULL, NULL, NULL, NULL),
(5, 'PGP8RJMFTG Confirmed.on 25/7/21 at 2:10 PMKsh780.00 received from 254721104645 SELLY CHEPNGENO KORGOREN. New Account balance is Ksh6,285.51. Transaction cost, Ksh3.90.', '254721104645', '2021-07-25 14:10:21', 'PGP8RJMFTG', '780.00', 'SELLY', 'CHEPNGENO', '', 2, '2021-07-25 14:10:21', NULL, NULL, NULL, NULL, NULL),
(6, 'PGP6RJMP76 Confirmed.on 25/7/21 at 2:10 PMKsh1.00 received from 254748913116 KIPRONOH GIDEON MABIIL. New Account balance is Ksh6,286.51. Transaction cost, Ksh0.00.', '254748913116', '2021-07-25 14:10:31', 'PGP6RJMP76', '1.00', 'KIPRONOH', 'GIDEON', '', 2, '2021-07-25 14:10:31', NULL, NULL, NULL, NULL, NULL),
(7, 'PGP5RJTDFH Confirmed.on 25/7/21 at 2:14 PMKsh1.00 received from 254707699136 DENNIS KIPNGETICH MUTAI. New Account balance is Ksh6,287.51. Transaction cost, Ksh0.00.', '254707699136', '2021-07-25 14:14:16', 'PGP5RJTDFH', '1.00', 'DENNIS', 'KIPNGETICH', '', 2, '2021-07-25 14:14:16', NULL, NULL, NULL, NULL, NULL),
(8, 'PGP6RJX8FE Confirmed.on 25/7/21 at 2:16 PMKsh80.00 received from 254792551698 GLADYS ACHIENG OGUTU. New Account balance is Ksh6,367.51. Transaction cost, Ksh0.00.', '254792551698', '2021-07-25 14:16:27', 'PGP6RJX8FE', '80.00', 'GLADYS', 'ACHIENG', '', 2, '2021-07-25 14:16:27', NULL, NULL, NULL, NULL, NULL),
(9, 'PGP8RK718U Confirmed.on 25/7/21 at 2:21 PMKsh1.00 received from 254746826448 sang festus. New Account balance is Ksh6,368.51. Transaction cost, Ksh0.00.', '254746826448', '2021-07-25 14:21:59', 'PGP8RK718U', '1.00', 'sang', 'festus', '', 2, '2021-07-25 14:21:59', NULL, NULL, NULL, NULL, NULL),
(10, 'PGP9RKL46L Confirmed.on 25/7/21 at 2:29 PMKsh120.00 received from 254715116785 MILCAH CHEPKEMOI. New Account balance is Ksh6,488.51. Transaction cost, Ksh0.00.', '254715116785', '2021-07-25 14:29:56', 'PGP9RKL46L', '120.00', 'MILCAH', 'CHEPKEMOI', '', 2, '2021-07-25 14:29:56', NULL, NULL, NULL, NULL, NULL),
(11, 'PGP8RL3JKS Confirmed.on 25/7/21 at 2:40 PMKsh1.00 received from 254746826448 sang festus. New Account balance is Ksh6,489.51. Transaction cost, Ksh0.00.', '254746826448', '2021-07-25 14:40:18', 'PGP8RL3JKS', '1.00', 'sang', 'festus', '', 2, '2021-07-25 14:40:18', NULL, NULL, NULL, NULL, NULL),
(12, 'PGP5RLGNXF Confirmed.on 25/7/21 at 2:47 PMKsh1.00 received from 254746826448 sang festus. New Account balance is Ksh6,490.51. Transaction cost, Ksh0.00.', 'MPESA', '2021-07-25 14:47:40', '', '0.00', '', '', '', 0, '0000-00-00 00:00:00', NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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