-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Sep 08, 2021 at 10:02 AM
-- 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,
  `printed` int(5) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=45 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`, `printed`) VALUES
(1, 'PGP6RIEXOK Confirmed.on 09/8/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, 1),
(2, 'PGP0RINEQM Confirmed.on 09/8/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, 1),
(3, 'PGP9RIR8VN Confirmed.on 09/8/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', '0', 2, '2021-07-25 13:52:22', NULL, NULL, NULL, NULL, NULL, 1),
(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, 0),
(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, 0),
(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, 0),
(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, 0),
(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, 0),
(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, 0),
(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, 0),
(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, 1),
(12, 'PGP5RLGNXF Confirmed.on 09/8/21 at 2:47 PMKsh1.00 received from 254746826448 sang festus. New Account balance is Ksh6,490.51. Transaction cost, Ksh0.00.', '254746826448', '2021-07-22 14:47:40', 'PGP5RLGNXF', '1.00', 'sang', 'festus', '', 2, '2021-07-22 14:47:40', NULL, NULL, NULL, NULL, NULL, 1),
(13, 'PI25DTB8XB Confirmed.on 2/9/21 at 1:09 PMKsh1,200.00 received from 254728000702 BOSTON SIRIBA JOMO. New Account balance is Ksh1,194.00. Transaction cost, Ksh6.00.', '254728000702', '2021-09-02 13:09:16', 'PI25DTB8XB', '1200.00', 'BOSTON', 'SIRIBA', '', 2, '2021-09-02 13:09:16', NULL, NULL, NULL, NULL, NULL, 0),
(14, 'PI25DUI531 Confirmed.on 2/9/21 at 1:31 PMKsh820.00 received from 254725225293 CAESAR ABUGA. New Account balance is Ksh2,009.90. Transaction cost, Ksh4.10.', '254725225293', '2021-09-02 13:31:38', 'PI25DUI531', '820.00', 'CAESAR', 'ABUGA', '', 2, '2021-09-02 13:31:38', NULL, NULL, NULL, NULL, NULL, 0),
(15, 'PI29E687PJ Confirmed.on 2/9/21 at 5:04 PMKsh5,380.00 received from 254743240911 zachariah omayio tinega. New Account balance is Ksh8,945.05. Transaction cost, Ksh26.90.', '254743240911', '2021-09-02 17:04:36', 'PI29E687PJ', '5380.00', 'zachariah', 'omayio', '', 2, '2021-09-02 17:04:36', NULL, NULL, NULL, NULL, NULL, 0),
(16, 'PI24ECDVCM Confirmed.on 2/9/21 at 6:31 PMKsh1,200.00 received from 254746029848 Wycliffe Ondieki Ogwaya. New Account balance is Ksh10,139.05. Transaction cost, Ksh6.00.', '254746029848', '2021-09-02 18:31:42', 'PI24ECDVCM', '1200.00', 'Wycliffe', 'Ondieki', '', 2, '2021-09-02 18:31:42', NULL, NULL, NULL, NULL, NULL, 0),
(17, 'PI22EFMC2C Confirmed.on 2/9/21 at 7:09 PMKsh800.00 received from 254790557701 KEVIN OCHIENG ODONGO. New Account balance is Ksh10,935.05. Transaction cost, Ksh4.00.', '254790557701', '2021-09-02 19:09:05', 'PI22EFMC2C', '800.00', 'KEVIN', 'OCHIENG', '', 2, '2021-09-02 19:09:05', NULL, NULL, NULL, NULL, NULL, 0),
(18, 'PI20EG95GA Confirmed.on 2/9/21 at 7:16 PMKsh400.00 received from 254728251438 JUSTUS NYAKWARA TOEL. New Account balance is Ksh11,333.05. Transaction cost, Ksh2.00.', '254728251438', '2021-09-02 19:16:05', 'PI20EG95GA', '400.00', 'JUSTUS', 'NYAKWARA', '', 2, '2021-09-02 19:16:05', NULL, NULL, NULL, NULL, NULL, 0),
(19, 'PI28EJ48A8 Confirmed.on 2/9/21 at 7:49 PMKsh1,170.00 received from 254722623766 ZACHARIAH RIOBA. New Account balance is Ksh12,497.20. Transaction cost, Ksh5.85.', '254722623766', '2021-09-02 19:49:12', 'PI28EJ48A8', '1170.00', 'ZACHARIAH', 'RIOBA', '', 2, '2021-09-02 19:49:12', NULL, NULL, NULL, NULL, NULL, 0),
(20, 'PI25EJ4BRP Confirmed.on 2/9/21 at 7:49 PMKsh180.00 received from 254724255857 GEOFFREY OTIENO OPIYO. New Account balance is Ksh12,677.20. Transaction cost, Ksh0.00.', '254724255857', '2021-09-02 19:49:17', 'PI25EJ4BRP', '180.00', 'GEOFFREY', 'OTIENO', '', 2, '2021-09-02 19:49:17', NULL, NULL, NULL, NULL, NULL, 0),
(21, 'PI26EKQ0O2 Confirmed.on 2/9/21 at 8:10 PMKsh540.00 received from 254721542659 JOSEPH OGARO. New Account balance is Ksh13,214.50. Transaction cost, Ksh2.70.', '254721542659', '2021-09-02 20:10:33', 'PI26EKQ0O2', '540.00', 'JOSEPH', 'OGARO', '', 2, '2021-09-02 20:10:33', NULL, NULL, NULL, NULL, NULL, 0),
(22, 'PI22EL2E60 Confirmed.on 2/9/21 at 8:15 PMKsh660.00 received from 254722858281 RAPHAEL OGENDO. New Account balance is Ksh13,871.20. Transaction cost, Ksh3.30.', '254722858281', '2021-09-02 20:15:22', 'PI22EL2E60', '660.00', 'RAPHAEL', 'OGENDO', '', 2, '2021-09-02 20:15:22', NULL, NULL, NULL, NULL, NULL, 0),
(23, 'PI24EM1CXW Confirmed.on 2/9/21 at 8:29 PMKsh540.00 received from 254706817760 Elijah   Okemwa. New Account balance is Ksh14,408.50. Transaction cost, Ksh2.70.', '254706817760', '2021-09-02 20:29:42', 'PI24EM1CXW', '540.00', 'Elijah', '', '', 2, '2021-09-02 20:29:42', NULL, NULL, NULL, NULL, NULL, 0),
(24, 'PI22EMDEHM Confirmed.on 2/9/21 at 8:34 PMKsh70.00 received from 254722440907 CHARLES JOSEPH OMBONGI OBUTU. New Account balance is Ksh14,478.50. Transacti*missing text*', '254722440907', '2021-09-02 20:34:56', 'PI22EMDEHM', '70.00', 'CHARLES', 'JOSEPH', '', 2, '2021-09-02 20:34:56', NULL, NULL, NULL, NULL, NULL, 0),
(25, 'PI57IDWGYT Confirmed.on 5/9/21 at 1:38 PMKsh600.00 received from 254720109045 DANIEL MUCHIRI NDIGIRIGI. New Account balance is Ksh797.00. Transaction cost, Ksh3.00.', '254720109045', '2021-09-05 13:38:10', 'PI57IDWGYT', '600.00', 'DANIEL', 'MUCHIRI', '', 2, '2021-09-05 13:38:10', NULL, NULL, NULL, NULL, NULL, 0),
(26, 'PI55IL497L Confirmed.on 5/9/21 at 3:54 PMKsh770.00 received from 254724643207 OMENGE MOGOI EVERLYNE. New Account balance is Ksh8,937.10. Transaction cost, Ksh3.85.', '254724643207', '2021-09-05 15:54:37', 'PI55IL497L', '770.00', 'OMENGE', 'MOGOI', '', 2, '2021-09-05 15:54:37', NULL, NULL, NULL, NULL, NULL, 0),
(27, 'PI57IAAJJ1 Confirmed.on 5/9/21 at 12:21 PMKsh200.00 received from 254759895379 Harriet Definah Bwahyi. New Account balance is Ksh200.00. Transaction cost, Ksh0.00.', '254759895379', '2021-09-05 12:22:00', 'PI57IAAJJ1', '200.00', 'Harriet', 'Definah', '', 2, '2021-09-05 12:22:00', NULL, NULL, NULL, NULL, NULL, 0),
(28, 'PI59IHLE8B Confirmed.on 5/9/21 at 2:49 PMKsh210.00 received from 254724370356 ROSELYN OGENDO. New Account balance is Ksh1,205.95. Transaction cost, Ksh1.05.', '254724370356', '2021-09-05 14:49:25', 'PI59IHLE8B', '210.00', 'ROSELYN', 'OGENDO', '', 2, '2021-09-05 14:49:25', NULL, NULL, NULL, NULL, NULL, 0),
(29, 'PI56IX9VQO Confirmed.on 5/9/21 at 7:05 PMKsh200.00 received from 254705082369 DELIAN MORAA MAIKARA. New Account balance is Ksh14,848.40. Transaction cost, Ksh0.00.', '254705082369', '2021-09-05 19:05:57', 'PI56IX9VQO', '200.00', 'DELIAN', 'MORAA', '', 2, '2021-09-05 19:05:57', NULL, NULL, NULL, NULL, NULL, 0),
(30, 'PI57IFUS8D Confirmed.on 5/9/21 at 2:16 PMKsh200.00 received from 254797851332 PETER AYIEKO OGENDO. New Account balance is Ksh997.00. Transaction cost, Ksh0.00.', '254797851332', '2021-09-05 14:16:24', 'PI57IFUS8D', '200.00', 'PETER', 'AYIEKO', '', 2, '2021-09-05 14:16:24', NULL, NULL, NULL, NULL, NULL, 1),
(31, 'PI59J7WZ3X Confirmed.on 5/9/21 at 10:12 PMKsh4,450.00 received from 254717393488 ALEX OMWOBO. New Account balance is Ksh4,427.75. Transaction cost, Ksh22.25.', '254717393488', '2021-09-05 22:12:06', 'PI59J7WZ3X', '4450.00', 'ALEX', 'OMWOBO', '', 2, '2021-09-05 22:12:06', NULL, NULL, NULL, NULL, NULL, 1),
(32, 'PI53IM23N5 Confirmed.on 5/9/21 at 4:11 PMKsh470.00 received from 254757492754 BENARD RIZIKI ROGONCHO. New Account balance is Ksh10,499.25. Transaction cost, Ksh2.35.', '254757492754', '2021-09-05 16:11:50', 'PI53IM23N5', '470.00', 'BENARD', 'RIZIKI', '', 2, '2021-09-05 16:11:50', NULL, NULL, NULL, NULL, NULL, 1),
(33, 'PI53IIKL5L Confirmed.on 5/9/21 at 3:07 PMKsh2,450.00 received from 254722827059 GEOFFREY GECHERA. New Account balance is Ksh4,041.70. Transaction cost, Ksh12.25.', '254722827059', '2021-09-05 15:07:39', 'PI53IIKL5L', '2450.00', 'GEOFFREY', 'GECHERA', '', 2, '2021-09-05 15:07:39', NULL, NULL, NULL, NULL, NULL, 1),
(34, 'PI55IHWIEL Confirmed.on 5/9/21 at 2:55 PMKsh400.00 received from 254707344339 EVERLYNE NEKESA BWAHYI. New Account balance is Ksh1,603.95. Transaction cost, Ksh2.00.', '254707344339', '2021-09-05 14:55:12', 'PI55IHWIEL', '400.00', 'EVERLYNE', 'NEKESA', '', 2, '2021-09-05 14:55:12', NULL, NULL, NULL, NULL, NULL, 1),
(35, 'PI54ILHKN0 Confirmed.on 5/9/21 at 4:01 PMKsh1,100.00 received from 254726819736 EDWARD MUKONASI. New Account balance is Ksh10,031.60. Transaction cost, Ksh5.50.', '254726819736', '2021-09-05 16:01:21', 'PI54ILHKN0', '1100.00', 'EDWARD', 'MUKONASI', '', 2, '2021-09-05 16:01:21', NULL, NULL, NULL, NULL, NULL, 1),
(36, 'PI52INFFAQ Confirmed.on 5/9/21 at 4:36 PMKsh1,700.00 received from 254720109045 DANIEL MUCHIRI NDIGIRIGI. New Account balance is Ksh12,588.75. Transaction cost, Ksh8.50.', '254720109045', '2021-09-05 16:36:27', 'PI52INFFAQ', '1700.00', 'DANIEL', 'MUCHIRI', '', 2, '2021-09-05 16:36:27', NULL, NULL, NULL, NULL, NULL, 1),
(37, 'PI53IP9AWJ Confirmed.on 5/9/21 at 5:07 PMKsh1,400.00 received from 254729024419 ANGELA OIGARA. New Account balance is Ksh14,200.65. Transaction cost, Ksh7.00.', '254729024419', '2021-09-05 17:07:51', 'PI53IP9AWJ', '1400.00', 'ANGELA', 'OIGARA', '', 2, '2021-09-05 17:07:51', NULL, NULL, NULL, NULL, NULL, 1),
(38, 'PI58IOPG0A Confirmed.on 5/9/21 at 4:58 PMKsh220.00 received from 254717270662 CATHERINE MUGERA. New Account balance is Ksh12,807.65. Transaction cost, Ksh1.10.', '254717270662', '2021-09-05 16:58:33', 'PI58IOPG0A', '220.00', 'CATHERINE', 'MUGERA', '', 2, '2021-09-05 16:58:33', NULL, NULL, NULL, NULL, NULL, 1),
(39, 'PI53IJMTJV Confirmed.on 5/9/21 at 3:27 PMKsh4,150.00 received from 254746304996 charles   wachira. New Account balance is Ksh8,170.95. Transaction cost, Ksh20.75.', '254746304996', '2021-09-05 15:27:25', 'PI53IJMTJV', '4150.00', 'charles', '', '', 2, '2021-09-05 15:27:25', NULL, NULL, NULL, NULL, NULL, 1),
(40, 'PI53IXQ24Z Confirmed.on 5/9/21 at 7:11 PMKsh900.00 received from 254725973722 DENNIS OMAMBIA. New Account balance is Ksh15,743.90. Transaction cost, Ksh4.50.', '254725973722', '2021-09-05 19:11:32', 'PI53IXQ24Z', '900.00', 'DENNIS', 'OMAMBIA', '', 2, '2021-09-05 19:11:32', NULL, NULL, NULL, NULL, NULL, 1),
(41, 'Dear customer, you do not have an active data bundle. Please dial *544# to buy a data bundle for you to browse the internet', 'data', '2021-09-07 08:33:34', 'Dear', '0.00', 'bundle.', 'Please', '', 2, '2021-09-07 08:33:34', NULL, NULL, NULL, NULL, NULL, 0),
(42, 'PI85MMX0CL Confirmed.on 8/9/21 at 10:45 AMKsh2.00 received from 254718667391 OUKO MANYALA. New Account balance is Ksh5.00. Transaction cost, Ksh0.00.', '254718667391', '2021-09-08 10:45:52', 'PI85MMX0CL', '2.00', 'OUKO', 'MANYALA', '', 2, '2021-09-08 10:45:52', NULL, NULL, NULL, NULL, NULL, 0),
(43, 'PI83MN4T55 Confirmed.on 8/9/21 at 10:49 AMKsh5.00 received from 254718667391 OUKO MANYALA. New Account balance is Ksh10.00. Transaction cost, Ksh0.00.', '254718667391', '2021-09-08 10:49:51', 'PI83MN4T55', '5.00', 'OUKO', 'MANYALA', '', 2, '2021-09-08 10:49:51', NULL, NULL, NULL, NULL, NULL, 0),
(44, 'PI81MN7SBF Confirmed.on 8/9/21 at 10:51 AMKsh2.00 received from 254714750311 Daniel Ondieki Mokaya. New Account balance is Ksh12.00. Transaction cost, Ksh0.00.', '254714750311', '2021-09-08 10:51:21', 'PI81MN7SBF', '2.00', 'Daniel', 'Ondieki', '', 2, '2021-09-08 10:51:21', NULL, NULL, NULL, NULL, NULL, 0);

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