--
-- Host: localhost    Database: 674db
-- ------------------------------------------------------


--
-- Table structure for table `balance`
--

CREATE TABLE `balance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `balance`
--

INSERT INTO `balance` VALUES (1,156.85000003156),(2,756588);

--
-- Table structure for table `ci_admin_roles`
--

CREATE TABLE `ci_admin_roles` (
  `admin_role_id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_role_title` varchar(30) CHARACTER SET utf8 NOT NULL,
  `admin_role_status` int(11) NOT NULL,
  `admin_role_created_by` int(1) NOT NULL,
  `admin_role_created_on` datetime NOT NULL,
  `admin_role_modified_by` int(11) NOT NULL,
  `admin_role_modified_on` datetime NOT NULL,
  PRIMARY KEY (`admin_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ci_admin_roles`
--

INSERT INTO `ci_admin_roles` VALUES (1,'Super Admin',1,0,'2018-03-15 12:48:04',0,'2018-03-17 12:53:16'),(2,'Admin',1,0,'2018-03-15 12:53:19',0,'2019-01-26 08:27:34'),(5,'Sync role',1,0,'2021-04-04 11:38:22',0,'2021-04-04 10:55:46');

--
-- Table structure for table `missing_payment`
--

CREATE TABLE `missing_payment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fileid` bigint(20) NOT NULL,
  `TransactionType` varchar(40) NOT NULL,
  `TransID` varchar(40) NOT NULL,
  `TransTime` varchar(40) NOT NULL,
  `TransAmount` varchar(40) NOT NULL,
  `BusinessShortCode` varchar(40) NOT NULL,
  `BillRefNumber` varchar(40) NOT NULL,
  `InvoiceNumber` varchar(40) NOT NULL,
  `ThirdPartyTransID` varchar(40) NOT NULL,
  `MSISDN` varchar(20) NOT NULL,
  `FirstName` varchar(60) NOT NULL,
  `MiddleName` varchar(60) NOT NULL,
  `LastName` varchar(60) NOT NULL,
  `OrgAccountBalance` double NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `missing_payment`
--


--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `module_id` int(11) NOT NULL AUTO_INCREMENT,
  `module_name` varchar(255) NOT NULL,
  `controller_name` varchar(255) NOT NULL,
  `fa_icon` varchar(100) NOT NULL,
  `operation` text NOT NULL,
  `sort_order` tinyint(4) NOT NULL,
  PRIMARY KEY (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module`
--

INSERT INTO `module` VALUES (1,'Admin List','admin','','view|add|edit|delete|change_status|access',0),(2,'Role & Permissions','admin_roles','','view|add|edit|delete|change_status|access',0),(7,'Export','export','','access',0),(8,'General Settings','general_settings','','view|add|edit|access',0),(9,'Sales','sales','','view|add|failed|export_csv|export_failed_csv|access',0),(10,'Payments','payments','','view|sync|export_csv|access',0),(11,'Customers','customers','','view|export_csv|access',0),(12,'Reports','reports','','view|access',0),(13,'Dashboard Summary','summary','','access',0);

--
-- Table structure for table `module_access`
--

CREATE TABLE `module_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_role_id` int(11) NOT NULL,
  `module` varchar(255) NOT NULL,
  `operation` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `RoleId` (`admin_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module_access`
--

INSERT INTO `module_access` VALUES (1,1,'users','view'),(2,1,'users','add'),(3,1,'users','edit'),(5,1,'users','access'),(6,1,'users','change_status'),(7,1,'export','access'),(8,1,'general_settings','view'),(9,1,'general_settings','add'),(10,1,'general_settings','edit'),(11,1,'general_settings','access'),(12,2,'admin','view'),(13,2,'admin','add'),(14,2,'admin','edit'),(15,2,'admin','change_status'),(16,2,'admin_roles','view'),(18,2,'general_settings','view'),(19,2,'sales','view'),(20,2,'sales','failed'),(21,2,'payments','view'),(22,2,'payments','sync'),(23,2,'customers','view'),(24,2,'customers','export_csv'),(25,2,'sales','access'),(26,2,'general_settings','access'),(27,2,'admin_roles','access'),(28,2,'admin','access'),(30,2,'admin_roles','change_status'),(32,2,'customers','index'),(33,2,'sales','index'),(34,2,'payments','access'),(35,2,'customers','access'),(37,2,'payments','index'),(38,2,'admin_roles','add'),(39,5,'payments','access'),(41,5,'payments','access'),(44,2,'customers','view'),(45,2,'customers','export_csv'),(46,2,'customers','view'),(47,2,'customers','export_csv'),(48,2,'reports','view'),(49,2,'reports','access'),(50,2,'sales','view'),(53,2,'admin','delete'),(56,2,'reports','access'),(63,2,'summary','access'),(64,5,'sales','view'),(65,5,'sales','failed'),(66,5,'payments','view'),(67,5,'sales','access');

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `TransactionType` varchar(40) NOT NULL,
  `TransID` varchar(40) NOT NULL,
  `TransTime` varchar(40) NOT NULL,
  `TransAmount` varchar(40) NOT NULL,
  `BusinessShortCode` varchar(40) NOT NULL,
  `BillRefNumber` varchar(40) NOT NULL,
  `InvoiceNumber` varchar(40) NOT NULL,
  `ThirdPartyTransID` varchar(40) NOT NULL,
  `MSISDN` varchar(20) NOT NULL,
  `FirstName` varchar(60) NOT NULL,
  `MiddleName` varchar(60) NOT NULL,
  `LastName` varchar(60) NOT NULL,
  `OrgAccountBalance` double NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `transid_index` (`TransID`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` VALUES (1,'Pay Bill','QFJ11LS3AD','20220619220407','5.00','674674','0718000659','','1','2547 ***** 659','ALMODAD','','',642,'2022-06-19 19:04:09'),(2,'Pay Bill','QFJ61O0VVY','20220619233509','5.00','674674','0718000659','','1','2547 ***** 659','ALMODAD','','',647,'2022-06-19 20:35:10'),(3,'Pay Bill','QFM87G478Q','20220622213834','20.00','674674','0756128090','','1','2547 ***** 854','JESSICAH','','',667,'2022-06-22 18:38:36'),(4,'Pay Bill','QFN892S068','20220623192909','32.00','674674','0754858701','','1','2547 ***** 477','STEVEN','','',699,'2022-06-23 16:29:11'),(5,'Pay Bill','QFO49J9JAI','20220624061359','20.00','674674','0756127080','','1','2547 ***** 854','JESSICAH','','',719,'2022-06-24 03:14:01'),(6,'Pay Bill','QFO1A5ZQY1','20220624131158','20.00','674674','0756534576','','1','2547 ***** 424','MONICA','','',789,'2022-06-24 10:12:00'),(7,'Pay Bill','QFO1AXDT7T','20220624185006','20.00','674674','0732555073','','1','2547 ***** 345','Mary','','',849,'2022-06-24 15:50:07'),(8,'Pay Bill','QFO0AYX774','20220624190348','10.00','674674','0781550186','','1','2547 ***** 163','ngalaa','','',859,'2022-06-24 16:03:49'),(9,'Pay Bill','QFO1B8GI21','20220624203527','20.00','674674','0104835297','','1','2547 ***** 044','PROMENA','','',879,'2022-06-24 17:35:28'),(10,'Pay Bill','QFP1BTKE7Z','20220625101037','30.00','674674','0722269084','','1','2547 ***** 084','KIMUTAI','','',909,'2022-06-25 07:10:38'),(11,'Pay Bill','QFQ3DL6S41','20220626075548','40.00','674674','0755468146','','1','2547 ***** 855','RHODA','','',949,'2022-06-26 04:55:49'),(12,'Pay Bill','QFQ0DLIF2Q','20220626080347','20.00','674674','0739143948','','1','2547 ***** 549','BERETA','','',969,'2022-06-26 05:03:48'),(13,'Pay Bill','QFQ0DRZB86','20220626101450','50.00','674674','0737546409','','1','2547 ***** 849','Dennis','','',1019,'2022-06-26 07:14:51'),(14,'Pay Bill','QFQ1ELERQT','20220626175903','20.00','674674','0782881638','','1','2547 ***** 549','BERETA','','',1039,'2022-06-26 14:59:04'),(15,'Pay Bill','QFR1FBRMOR','20220627074814','20.00','674674','0784243169','','1','2547 ***** 197','CAROLINE','','',1059,'2022-06-27 04:48:15'),(16,'Pay Bill','QFR1FJZDCR','20220627101314','20.00','674674','0751112500','','1','2547 ***** 708','GEOFFREY','','',1079,'2022-06-27 07:13:16'),(17,'Pay Bill','QFR0FPQNNS','20220627114038','20.00','674674','0785097588','','1','2547 ***** 187','Miriamu','','',20,'2022-06-27 08:40:39'),(18,'Pay Bill','QFR3G59PAN','20220627152118','20.00','674674','0751112500','','1','2547 ***** 708','GEOFFREY','','',40,'2022-06-27 12:21:19'),(19,'Pay Bill','QFR4GIOSLM','20220627180806','20.00','674674','0713535048','','1','2547 ***** 048','josephine','','',60,'2022-06-27 15:08:08'),(20,'Pay Bill','QFR3GQX1IT','20220627192410','20.00','674674','0734563304','','1','2547 ***** 754','BENEDICT','','',80,'2022-06-27 16:24:12'),(21,'Pay Bill','QFR2H0ZNDY','20220627210957','30.00','674674','0781807895','','1','2547 ***** 422','SAMUEL','','',110,'2022-06-27 18:09:58'),(22,'Pay Bill','QFS7H8S67V','20220628063658','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',120,'2022-06-28 03:36:59'),(23,'Pay Bill','QFS2HAL9AU','20220628073501','10.00','674674','0783602792','','1','2547 ***** 244','HARRISON','','',130,'2022-06-28 04:35:02'),(24,'Pay Bill','QFS9HHKFSR','20220628094459','5.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',135,'2022-06-28 06:45:01'),(25,'Pay Bill','QFS1HR40XZ','20220628121217','5.00','674674','0756508395','','1','2547 ***** 607','Evans','','',140,'2022-06-28 09:12:18'),(26,'Pay Bill','QFS3HWSTO3','20220628133328','20.00','674674','0753650238','','1','2547 ***** 692','Edina','','',160,'2022-06-28 10:33:29'),(27,'Pay Bill','QFS7I5FMI9','20220628153601','200.00','674674','0751627886','','1','2547 ***** 105','MOSES','','',360,'2022-06-28 12:36:03'),(28,'Pay Bill','QFS3I9V04V','20220628163556','30.00','674674','0786677110','','1','2547 ***** 287','MAUREEN','','',390,'2022-06-28 13:35:57'),(29,'Pay Bill','QFS2ICP7SC','20220628171043','80.00','674674','0737338236','','1','2547 ***** 023','FRANCIS','','',470,'2022-06-28 14:10:45'),(30,'Pay Bill','QFS6IWMJOG','20220628202336','10.00','674674','0734563304','','1','2547 ***** 754','BENEDICT','','',480,'2022-06-28 17:23:38'),(31,'Pay Bill','QFS6J1LWUS','20220628212842','30.00','674674','0784540205','','1','2547 ***** 150','DAVID','','',510,'2022-06-28 18:28:43'),(32,'Pay Bill','QFS6J28ZHK','20220628213942','50.00','674674','0750626245','','1','2547 ***** 163','GILBERT','','',560,'2022-06-28 18:39:43'),(33,'Pay Bill','QFT1JA87F7','20220629072047','30.00','674674','0737649107','','1','2541 ***** 239','DENIS','','',590,'2022-06-29 04:20:49'),(34,'Pay Bill','QFT9JCMQWD','20220629081233','10.00','674674','0100723976','','1','2547 ***** 506','Sharon','','',600,'2022-06-29 05:12:34'),(35,'Pay Bill','QFT9K69NE7','20220629153059','20.00','674674','0751112500','','1','2547 ***** 708','GEOFFREY','','',620,'2022-06-29 12:31:00'),(36,'Pay Bill','QFT6KM4KEG','20220629183812','30.00','674674','0102721337','','1','2547 ***** 166','PHELIX','','',650,'2022-06-29 15:38:14'),(37,'Pay Bill','QFU9LCIBYN','20220630075114','50.00','674674','0734275675','','1','2547 ***** 831','PRUDENCE','','',700,'2022-06-30 04:51:16'),(38,'Pay Bill','QFU3LQ4XOF','20220630112642','20.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',720,'2022-06-30 08:26:44'),(39,'Pay Bill','QFU8M3BLUQ','20220630142734','31.00','674674','0731323131','','1','2547 ***** 540','Japheth','','',751,'2022-06-30 11:27:35'),(40,'Pay Bill','QFU2MLDCWC','20220630180722','50.00','674674','0782641014','','1','2547 ***** 703','JOAN','','',801,'2022-06-30 15:07:23'),(41,'Pay Bill','QFU3MPM7A7','20220630184737','20.00','674674','0105145630','','1','2547 ***** 260','haron','','',821,'2022-06-30 15:47:39'),(42,'Pay Bill','QFU9N65N4D','20220630212849','10.00','674674','0106256558','','1','2541 ***** 104','MILLICENT','','',831,'2022-06-30 18:28:50'),(43,'Pay Bill','QG11O5RVQD','20220701133129','20.00','674674','0751112500','','1','2547 ***** 708','GEOFFREY','','',851,'2022-07-01 10:31:30'),(44,'Pay Bill','QG16ODD7CC','20220701150749','20.00','674674','0nusrah','','1','2547 ***** 656','Nusra','','',871,'2022-07-01 12:07:51'),(45,'Pay Bill','QG15OKVMMB','20220701164054','50.00','674674','0784199632','','1','2547 ***** 254','PAUL','','',941,'2022-07-01 13:40:55'),(46,'Pay Bill','QG15P4XRLP','20220701195153','45.00','674674','0106467436','','1','2547 ***** 029','MARY','','',986,'2022-07-01 16:51:55'),(47,'Pay Bill','QG15P8N0TP','20220701202726','20.00','674674','0734563304','','1','2547 ***** 754','BENEDICT','','',1006,'2022-07-01 17:27:31'),(48,'Pay Bill','QG16PCPI9W','20220701211545','10.00','674674','0762068743','','1','2547 ***** 347','Agnes','','',1016,'2022-07-01 18:15:46'),(49,'Pay Bill','QG18PHJX04','20220701224736','50.00','674674','0100509717','','1','2547 ***** 287','James','','',1066,'2022-07-01 19:47:38'),(50,'Pay Bill','QG27PO7HMR','20220702074824','10.00','674674','0751445552','','1','2547 ***** 621','ELLY','','',1076,'2022-07-02 04:48:26'),(51,'Pay Bill','QG20PXGVRI','20220702101749','50.00','674674','0784199632','','1','2547 ***** 254','PAUL','','',1126,'2022-07-02 07:17:50'),(52,'Pay Bill','QG24PXZ3MG','20220702102455','10.00','674674','0751445552','','1','2547 ***** 621','ELLY','','',1136,'2022-07-02 07:24:56'),(53,'Pay Bill','QG26QGV5IU','20220702143549','50.00','674674','0750077152','','1','2547 ***** 577','BERNARD','','',1266,'2022-07-02 11:35:51'),(54,'Pay Bill','QG24R0TEG8','20220702183146','49.00','674674','0756729095','','1','2547 ***** 870','WYCLIFE','','',1315,'2022-07-02 15:31:47'),(55,'Pay Bill','QG23R5ODY5','20220702191449','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',1335,'2022-07-02 16:14:50'),(56,'Pay Bill','QG24RLIHQ0','20220702221253','50.00','674674','0735916451','','1','2547 ***** 155','GRACE','','',1385,'2022-07-02 19:12:55'),(57,'Pay Bill','QG28RN1ARA','20220702225132','20.00','674674','0756917766','','1','2547 ***** 452','DENIS','','',1405,'2022-07-02 19:51:33'),(58,'Pay Bill','QG36RX1NNE','20220703085650','50.00','674674','0732974259','','1','2547 ***** 128','bernard','','',1475,'2022-07-03 05:56:51'),(59,'Pay Bill','QG30RZRPTC','20220703094356','10.00','674674','0781959081','','1','2547 ***** 088','GIDEON','','',1485,'2022-07-03 06:43:57'),(60,'Pay Bill','QG38S231KE','20220703102256','60.00','674674','0739501166','','1','2547 ***** 457','Alukwe','','',1545,'2022-07-03 07:22:57'),(61,'Pay Bill','QG37SJNRJB','20220703150011','8.00','674674','0731674001','','1','2547 ***** 228','PAUL','','',1553,'2022-07-03 12:00:13'),(62,'Pay Bill','QG32SKQ41I','20220703151517','20.00','674674','0754944320','','1','2547 ***** 733','Esther','','',1573,'2022-07-03 12:15:19'),(63,'Pay Bill','QG36SPQJHG','20220703162524','10.00','674674','0785187058','','1','2547 ***** 703','JOAN','','',1583,'2022-07-03 13:25:25'),(64,'Pay Bill','QG34SV47I6','20220703173613','20.00','674674','0737949628','','1','2547 ***** 776','GEORGE','','',1603,'2022-07-03 14:36:14'),(65,'Pay Bill','QG32SW4RUQ','20220703174847','10.00','674674','0786549002','','1','2547 ***** 966','Nicholas','','',1613,'2022-07-03 14:48:49'),(66,'Pay Bill','QG31SX1UH7','20220703180006','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',1623,'2022-07-03 15:00:07'),(67,'Pay Bill','QG39T4OK4N','20220703192142','100.00','674674','0753536823','','1','2547 ***** 344','NEWTON','','',1723,'2022-07-03 16:21:43'),(68,'Pay Bill','QG30TGU8AM','20220703214819','10.00','674674','0750253935','','1','2547 ***** 090','LANGAT','','',1733,'2022-07-03 18:48:20'),(69,'Pay Bill','QG31TJF959','20220703225754','33.00','674674','0782005977','','1','2547 ***** 396','TABITHA','','',1766,'2022-07-03 19:57:55'),(70,'Pay Bill','QG43TVS7P3','20220704094137','5.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',1771,'2022-07-04 06:41:38'),(71,'Pay Bill','QG40U2EPBS','20220704111548','15.00','674674','0753701603','','1','2547 ***** 594','CHEPTOO','','',1786,'2022-07-04 08:15:50'),(72,'Pay Bill','QG42U7CGZ2','20220704122335','20.00','674674','0731058966','','1','2541 ***** 592','GEORGE','','',1806,'2022-07-04 09:23:36'),(73,'Pay Bill','QG40VA4HYE','20220704195010','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',1826,'2022-07-04 16:50:12'),(74,'Pay Bill','QG46VKXH0A','20220704215715','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',1846,'2022-07-04 18:57:16'),(75,'Pay Bill','QG44VNTYL6','20220704232157','20.00','674674','0078407209','','1','2547 ***** 877','Joel','','',1866,'2022-07-04 20:21:59'),(76,'Pay Bill','QG56VVVQY8','20220705083700','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',1876,'2022-07-05 05:37:01'),(77,'Pay Bill','QG54VW3SSM','20220705084039','10.00','674674','0785414315','','1','2547 ***** 956','jackline','','',1886,'2022-07-05 05:40:40'),(78,'Pay Bill','QG52W8EE22','20220705113946','20.00','674674','0102334191','','1','2547 ***** 854','Asenath','','',1906,'2022-07-05 08:39:49'),(79,'Pay Bill','QG57WALSQP','20220705121022','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',1926,'2022-07-05 09:10:24'),(80,'Pay Bill','QG57WFIK1L','20220705131551','10.00','674674','0734877555','','1','2547 ***** 219','Dorcus','','',1936,'2022-07-05 10:15:53'),(81,'Pay Bill','QG58WGHV2K','20220705132817','30.00','674674','0786476416','','1','2547 ***** 986','betty','','',1966,'2022-07-05 10:28:19'),(82,'Pay Bill','QG53WH8T7P','20220705133754','50.00','674674','0786476416','','1','2547 ***** 986','betty','','',2016,'2022-07-05 10:37:55'),(83,'Pay Bill','QG56WJU3J8','20220705141136','50.00','674674','0780038079','','1','2541 ***** 034','Noel','','',2066,'2022-07-05 11:11:37'),(84,'Pay Bill','QG54WNIT3O','20220705150047','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',2086,'2022-07-05 12:00:48'),(85,'Pay Bill','QG53WQPTE7','20220705154320','15.00','674674','0753701603','','1','2547 ***** 594','CHEPTOO','','',2101,'2022-07-05 12:43:22'),(86,'Pay Bill','QG50WV3ZW2','20220705163939','20.00','674674','0735262939','','1','2547 ***** 629','JULIUS','','',2121,'2022-07-05 13:39:40'),(87,'Pay Bill','QG50X5UIDQ','20220705183423','10.00','674674','0762445687','','1','2547 ***** 490','GLADYS','','',2131,'2022-07-05 15:34:24'),(88,'Pay Bill','QG68XTQT2Y','20220706003626','12.00','674674','0104701157','','1','2547 ***** 780','EPHRAIM','','',2158,'2022-07-05 21:36:28'),(89,'Pay Bill','QG60XW8Y8A','20220706064638','100.00','674674','0734746940','','1','2547 ***** 455','CHENANE','','',2258,'2022-07-06 03:46:40'),(90,'Pay Bill','QG62XX51L4','20220706071610','30.00','674674','0733845854','','1','2547 ***** 445','Brenda','','',2288,'2022-07-06 04:16:11'),(91,'Pay Bill','QG68XZ3UTS','20220706080045','40.00','674674','0786476416','','1','2547 ***** 986','betty','','',2328,'2022-07-06 05:00:46'),(92,'Pay Bill','QG67Y3CYYZ','20220706091142','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',2338,'2022-07-06 06:11:43'),(93,'Pay Bill','QG60YEK2A0','20220706114851','20.00','674674','0754944320','','1','2547 ***** 733','Esther','','',2358,'2022-07-06 08:48:53'),(94,'Pay Bill','QG64YRQ4HG','20220706144052','20.00','674674','0753153126','','1','2547 ***** 126','WAMAE','','',2378,'2022-07-06 11:40:53'),(95,'Pay Bill','QG62YYLN28','20220706161127','10.00','674674','0782942690','','1','2547 ***** 055','purity','','',2388,'2022-07-06 13:11:28'),(96,'Pay Bill','QG60Z18HQI','20220706164341','10.00','674674','0732872359','','1','2547 ***** 638','ALFONCE','','',2398,'2022-07-06 13:43:43'),(97,'Pay Bill','QG64ZAIBRS','20220706182309','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',2418,'2022-07-06 15:23:10'),(98,'Pay Bill','QG67ZI2X9P','20220706192947','20.00','674674','0756412791','','1','2547 ***** 530','Agnes','','',2438,'2022-07-06 16:29:49'),(99,'Pay Bill','QG65ZPXURF','20220706204242','20.00','674674','0780126621','','1','2547 ***** 199','JAPHETH','','',2458,'2022-07-06 17:42:43'),(100,'Pay Bill','QG68ZQ5X4U','20220706204511','30.00','674674','0104701157','','1','2547 ***** 780','EPHRAIM','','',2488,'2022-07-06 17:45:13'),(101,'Pay Bill','QG67ZV7U6D','20220706215143','20.00','674674','0733845854','','1','2547 ***** 445','Brenda','','',2508,'2022-07-06 18:51:44'),(102,'Pay Bill','QG73120ZN7','20220707064014','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',2528,'2022-07-07 03:40:15'),(103,'Pay Bill','QG7819TYBE','20220707092001','10.00','674674','0753701603','','1','2547 ***** 594','CHEPTOO','','',2538,'2022-07-07 06:20:02'),(104,'Pay Bill','QG721ESOKU','20220707103113','20.00','674674','0104468051','','1','2547 ***** 035','LILIAN','','',2558,'2022-07-07 07:31:14'),(105,'Pay Bill','QG711GRUQV','20220707105852','5.00','674674','0753701603','','1','2547 ***** 594','CHEPTOO','','',2563,'2022-07-07 07:58:53'),(106,'Pay Bill','QG711L9NGV','20220707120016','12.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',2625,'2022-07-07 09:00:17'),(107,'Pay Bill','QG771OFQR9','20220707124307','30.00','674674','0780126621','','1','2547 ***** 199','JAPHETH','','',2655,'2022-07-07 09:43:08'),(108,'Pay Bill','QG761SDERS','20220707133416','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',2675,'2022-07-07 10:34:17'),(109,'Pay Bill','QG791W7FX1','20220707142332','10.00','674674','0786717846','','1','2547 ***** 177','DORCUS','','',2685,'2022-07-07 11:23:34'),(110,'Pay Bill','QG7426BLWC','20220707163516','20.00','674674','0751554005','','1','2547 ***** 225','GLADYS','','',2705,'2022-07-07 13:35:17'),(111,'Pay Bill','QG732NVZBV','20220707192959','10.00','674674','0750492257','','1','2547 ***** 104','Jacline','','',2715,'2022-07-07 16:30:00'),(112,'Pay Bill','QG712P4GIB','20220707194009','20.00','674674','0786476416','','1','2547 ***** 986','betty','','',2735,'2022-07-07 16:40:11'),(113,'Pay Bill','QG702YGCD8','20220707211851','20.00','674674','0732568433','','1','2541 ***** 462','elias','','',2755,'2022-07-07 18:18:52'),(114,'Pay Bill','QG7332D10T','20220707223040','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',2775,'2022-07-07 19:30:42'),(115,'Pay Bill','QG7832GNKY','20220707223302','50.00','674674','0180185483','','1','2541 ***** 477','Denish','','',2825,'2022-07-07 19:33:03'),(116,'Pay Bill','QG833D7YKV','20220708090548','10.00','674674','0781340403','','1','2547 ***** 311','nancy','','',2865,'2022-07-08 06:05:49'),(117,'Pay Bill','QG823EZG8G','20220708093259','10.00','674674','0782670642','','1','2547 ***** 419','Anne','','',2875,'2022-07-08 06:33:00'),(118,'Pay Bill','QG883ICR4Y','20220708102141','55.00','674674','0756412008','','1','2547 ***** 937','Reginah','','',2930,'2022-07-08 07:21:43'),(119,'Pay Bill','QG883INPPY','20220708102547','20.00','674674','0733845854','','1','2547 ***** 445','Brenda','','',2950,'2022-07-08 07:25:48'),(120,'Pay Bill','QG823O06LS','20220708113908','100.00','674674','0723921676','','1','2547 ***** 676','OBADO','','',3050,'2022-07-08 08:39:10'),(121,'Pay Bill','QG873TIHFF','20220708125311','100.00','674674','0751921676','','1','2547 ***** 676','OBADO','','',3150,'2022-07-08 09:53:12'),(122,'Pay Bill','QG863UVW3C','20220708131115','50.00','674674','0778840893','','1','2547 ***** 703','JOAN','','',3200,'2022-07-08 10:11:17'),(123,'Pay Bill','QG833VOB2H','20220708132143','20.00','674674','0739137545','','1','2547 ***** 897','WILSON','','',3220,'2022-07-08 10:21:45'),(124,'Pay Bill','QG803X0CJI','20220708133827','20.00','674674','0786476416','','1','2547 ***** 986','betty','','',3240,'2022-07-08 10:38:28'),(125,'Pay Bill','QG843YR06Y','20220708140027','100.00','674674','0105157319','','1','2547 ***** 182','KEVIN','','',3340,'2022-07-08 11:00:28'),(126,'Pay Bill','QG8041Y7M2','20220708144109','10.00','674674','0106178625','','1','2547 ***** 208','ELIJAH','','',3350,'2022-07-08 11:41:11'),(127,'Pay Bill','QG88476XGC','20220708154814','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',3360,'2022-07-08 12:48:15'),(128,'Pay Bill','QG894AA7G7','20220708162626','28.00','674674','0786476416','','1','2547 ***** 986','betty','','',3388,'2022-07-08 13:26:27'),(129,'Pay Bill','QG834BBOLH','20220708163854','20.00','674674','0106467436','','1','2547 ***** 029','MARY','','',3408,'2022-07-08 13:38:56'),(130,'Pay Bill','QG874MSGHZ','20220708183722','20.00','674674','0104914945','','1','2547 ***** 860','brandon','','',3438,'2022-07-08 15:37:24'),(131,'Pay Bill','QG824WRJPK','20220708200530','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',3458,'2022-07-08 17:05:33'),(132,'Pay Bill','QG89510C79','20220708205013','20.00','674674','0762209113','','1','2547 ***** 249','PETER','','',3478,'2022-07-08 17:50:14'),(133,'Pay Bill','QG8551EOQP','20220708205451','50.00','674674','0762209113','','1','2547 ***** 249','PETER','','',3528,'2022-07-08 17:54:52'),(134,'Pay Bill','QG8451V12O','20220708210023','10.00','674674','0104897083','','1','2541 ***** 892','Robert','','',3538,'2022-07-08 18:00:24'),(135,'Pay Bill','QG8953XT09','20220708212816','20.00','674674','0786271418','','1','2541 ***** 462','elias','','',3558,'2022-07-08 18:28:18'),(136,'Pay Bill','QG8954L7F7','20220708213756','10.00','674674','0789770228','','1','2547 ***** 225','GLADYS','','',3568,'2022-07-08 18:37:57'),(137,'Pay Bill','QG945EBQNK','20220709073115','10.00','674674','0731674001','','1','2547 ***** 228','PAUL','','',3578,'2022-07-09 04:31:17'),(138,'Pay Bill','QG985EH4Z8','20220709073510','20.00','674674','0781234944','','1','2541 ***** 105','Kennedy','','',3598,'2022-07-09 04:35:11'),(139,'Pay Bill','QG985EO23U','20220709074001','20.00','674674','0786476416','','1','2547 ***** 986','betty','','',3618,'2022-07-09 04:40:03'),(140,'Pay Bill','QG915HO4JH','20220709084028','10.00','674674','0736540245','','1','2547 ***** 078','benedict','','',3628,'2022-07-09 05:40:29'),(141,'Pay Bill','QG905MRUEM','20220709100055','20.00','674674','0783870139','','1','2547 ***** 718','Brenda','','',3648,'2022-07-09 07:00:57'),(142,'Pay Bill','QG915U7E2X','20220709114449','15.00','674674','0753913042','','1','2547 ***** 813','ROY','','',3663,'2022-07-09 08:44:50'),(143,'Pay Bill','QG915UD4JP','20220709114654','20.00','674674','0786476416','','1','2547 ***** 986','betty','','',3683,'2022-07-09 08:46:56'),(144,'Pay Bill','QG9566QHIR','20220709143211','50.00','674674','0101651449','','1','2547 ***** 029','MARY','','',3733,'2022-07-09 11:32:12'),(145,'Pay Bill','QG9966VPER','20220709143358','50.00','674674','0103305597','','1','2547 ***** 633','KHAMISI','','',3783,'2022-07-09 11:33:59'),(146,'Pay Bill','QG906773FW','20220709143815','10.00','674674','0784071988','','1','2547 ***** 754','RAJAB','','',3793,'2022-07-09 11:38:16'),(147,'Pay Bill','QG976APC9F','20220709152433','10.00','674674','0781234944','','1','2541 ***** 105','Kennedy','','',3803,'2022-07-09 12:24:34'),(148,'Pay Bill','QG906FBTQ8','20220709162346','50.00','674674','0734923526','','1','2547 ***** 173','ken','','',3853,'2022-07-09 13:23:48'),(149,'Pay Bill','QG936I9YAB','20220709165934','10.00','674674','0782516449','','1','2547 ***** 347','DAVE','','',3863,'2022-07-09 13:59:36'),(150,'Pay Bill','QG936ILGWP','20220709170311','20.00','674674','0787640430','','1','2547 ***** 754','stelah','','',3883,'2022-07-09 14:03:13'),(151,'Pay Bill','QG936KW159','20220709172923','50.00','674674','0733845854','','1','2547 ***** 539','Lilian','','',3933,'2022-07-09 14:29:24'),(152,'Pay Bill','QG916PYQCX','20220709182244','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',3943,'2022-07-09 15:22:45'),(153,'Pay Bill','QG976R3SGR','20220709183400','10.00','674674','0751750346','','1','2547 ***** 981','joan','','',3953,'2022-07-09 15:34:01'),(154,'Pay Bill','QG9371M7H9','20220709200749','350.00','674674','0105302004','','1','2547 ***** 102','ESTHER','','',4303,'2022-07-09 17:07:50'),(155,'Pay Bill','QG9873K8ZU','20220709202707','50.00','674674','0737394580','','1','2547 ***** 840','Otieno','','',4353,'2022-07-09 17:27:09'),(156,'Pay Bill','QG9773T8D7','20220709202950','20.00','674674','0734946240','','1','2547 ***** 465','PATRICK','','',4373,'2022-07-09 17:29:51'),(157,'Pay Bill','QG9775ZM4J','20220709205435','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',4393,'2022-07-09 17:54:36'),(158,'Pay Bill','QGA97PDRHZ','20220710095821','5.00','674674','0737394580','','1','2547 ***** 840','Otieno','','',4403,'2022-07-10 06:58:22'),(159,'Pay Bill','QGA87TUSDQ','20220710111425','10.00','674674','0783870139','','1','2547 ***** 718','Brenda','','',4413,'2022-07-10 08:14:26'),(160,'Pay Bill','QGA77UQH39','20220710112918','20.00','674674','0753913042','','1','2547 ***** 813','ROY','','',4433,'2022-07-10 08:29:20'),(161,'Pay Bill','QGA383451R','20220710134535','5.00','674674','0104914945','','1','2547 ***** 860','brandon','','',4438,'2022-07-10 10:45:40'),(162,'Pay Bill','QGA983XWFX','20220710135739','26.00','674674','0737394580','','1','2547 ***** 840','Otieno','','',4464,'2022-07-10 10:57:40'),(163,'Pay Bill','QGA6844DCK','20220710140014','5.00','674674','0737394580','','1','2547 ***** 840','Otieno','','',4469,'2022-07-10 11:00:15'),(164,'Pay Bill','QGA08GZEL6','20220710165931','20.00','674674','0783254407','','1','2547 ***** 457','TIMOTHY','','',4489,'2022-07-10 13:59:33'),(165,'Pay Bill','QGA58M6D0B','20220710180406','20.00','674674','0762351702','','1','2547 ***** 169','IRUNGU','','',4529,'2022-07-10 15:04:07'),(166,'Pay Bill','QGA08QVT0G','20220710185616','20.00','674674','0750430537','','1','2547 ***** 980','SOPHIA','','',4549,'2022-07-10 15:56:18'),(167,'Pay Bill','QGA38V9NMZ','20220710193840','20.00','674674','0739137545','','1','2547 ***** 897','WILSON','','',4569,'2022-07-10 16:38:41'),(168,'Pay Bill','QGA68X0FU0','20220710195610','1.00','674674','0681070122','','1','2547 ***** 719','MARY','','',4570,'2022-07-10 16:56:11'),(169,'Pay Bill','QGA690NJIC','20220710203652','30.00','674674','0739137545','','1','2547 ***** 897','WILSON','','',4600,'2022-07-10 17:36:53'),(170,'Pay Bill','QGA292WTZA','20220710210709','20.00','674674','0755508088','','1','2541 ***** 440','NICHOLAS','','',4620,'2022-07-10 18:07:11'),(171,'Pay Bill','QGA094G7NQ','20220710213129','10.00','674674','0734877555','','1','2547 ***** 219','Dorcus','','',4630,'2022-07-10 18:31:30'),(172,'Pay Bill','QGA294P018','20220710213542','50.00','674674','0756412008','','1','2547 ***** 937','Reginah','','',4680,'2022-07-10 18:35:43'),(173,'Pay Bill','QGA996FZH7','20220710221043','25.00','674674','0733845854','','1','2547 ***** 445','Brenda','','',4705,'2022-07-10 19:10:44'),(174,'Pay Bill','QGB69DTUVO','20220711075232','30.00','674674','0731799631','','1','2547 ***** 396','Doreen','','',4735,'2022-07-11 04:52:33'),(175,'Pay Bill','QGB59G1UX1','20220711083817','70.00','674674','0783348100','','1','2547 ***** 351','VUNDI','','',4805,'2022-07-11 05:38:19'),(176,'Pay Bill','QGB29HBB9A','20220711090042','10.00','674674','0783870139','','1','2547 ***** 718','Brenda','','',10,'2022-07-11 06:00:43'),(177,'Pay Bill','QGB19HHXFP','20220711090406','50.00','674674','0733385037','','1','2547 ***** 480','Rebecca','','',60,'2022-07-11 06:04:08'),(178,'Pay Bill','QGB59IDUT1','20220711091843','25.00','674674','0733845854','','1','2547 ***** 445','Brenda','','',85,'2022-07-11 06:18:44'),(179,'Pay Bill','QGB49KRLJS','20220711095608','10.00','674674','0753315503','','1','2547 ***** 374','JULIA','','',95,'2022-07-11 06:56:10'),(180,'Pay Bill','QGB99LYHM1','20220711101402','5.00','674674','0753302299','','1','2547 ***** 405','LINET','','',100,'2022-07-11 07:14:04'),(181,'Pay Bill','QGB39M3ITR','20220711101607','15.00','674674','0753302299','','1','2547 ***** 405','LINET','','',115,'2022-07-11 07:16:08'),(182,'Pay Bill','QGB99OEXQD','20220711104940','10.00','674674','0734573200','','1','2547 ***** 325','MAGDALENA','','',125,'2022-07-11 07:49:42'),(183,'Pay Bill','QGB69S405A','20220711114157','50.00','674674','0739099946','','1','2541 ***** 665','beatrice','','',175,'2022-07-11 08:41:58'),(184,'Pay Bill','QGB79TYRJJ','20220711120732','15.00','674674','0756333036','','1','2547 ***** 169','Beatrice','','',190,'2022-07-11 09:07:33'),(185,'Pay Bill','QGB1AP4R5F','20220711183751','30.00','674674','0731323707','','1','2547 ***** 085','NOAH','','',220,'2022-07-11 15:37:53'),(186,'Pay Bill','QGB2AQJ25K','20220711185120','20.00','674674','0732560130','','1','2547 ***** 107','shem','','',240,'2022-07-11 15:51:21'),(187,'Pay Bill','QGB2B1FQZ4','20220711203136','20.00','674674','0751452931','','1','2547 ***** 374','Anita','','',260,'2022-07-11 17:31:38');

--
-- Table structure for table `payment_tmp`
--

CREATE TABLE `payment_tmp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `TransactionType` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TransID` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TransTime` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `TransAmount` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `BusinessShortCode` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `BillRefNumber` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `InvoiceNumber` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `ThirdPartyTransID` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `MSISDN` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `FirstName` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `MiddleName` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `LastName` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `OrgAccountBalance` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_tmp`
--


--
-- Table structure for table `request_tmp`
--

CREATE TABLE `request_tmp` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sender` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
  `amount` int(10) NOT NULL,
  `mpesa_number` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int(5) DEFAULT '1',
  `transaction_id` int(20) DEFAULT '0',
  `ref` varchar(20) COLLATE utf8_unicode_ci DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `request_tmp`
--


--
-- Table structure for table `resendq`
--

CREATE TABLE `resendq` (
  `id` bigint(15) NOT NULL AUTO_INCREMENT,
  `status` int(10) NOT NULL DEFAULT '1',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `resendq`
--

INSERT INTO `resendq` VALUES (1,0,'2022-06-19 19:29:27'),(2,0,'2022-06-19 20:48:25'),(3,0,'2022-06-19 20:48:28'),(4,0,'2022-06-19 20:48:43'),(5,0,'2022-06-19 22:29:26');

--
-- Table structure for table `transaction`
--

CREATE TABLE `transaction` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `payment_id` bigint(20) NOT NULL,
  `pretups_id` varchar(200) NOT NULL DEFAULT '',
  `amount` int(20) NOT NULL,
  `customer_message` varchar(255) NOT NULL DEFAULT '',
  `status` int(10) DEFAULT '0',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `channel` varchar(20) NOT NULL DEFAULT 'PAYBILL',
  `network` varchar(20) DEFAULT 'Airtel',
  PRIMARY KEY (`id`),
  KEY `idx_transid` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `transaction`
--

INSERT INTO `transaction` VALUES (1,1,'R220619.2204.220009',5,'R220619.2204.220009 confirmed. You have topped up 0718000659 with Ksh. 5. New balance is Ksh. 810265. ',200,'2022-06-19 19:04:09','PAYBILL','SAFCOM'),(2,2,'',5,'',0,'2022-06-19 20:35:10','PAYBILL','Airtel'),(3,3,'R220622.2138.220257',20,'Msg:210:Transaction number R220622.2138.220257 to recharge 20 KSH to 0756128090 is successful. Your new balance is 1110458.06 KSH',200,'2022-06-22 18:38:36','PAYBILL','Airtel'),(4,4,'R220623.1929.2100b5',32,'Msg:210:Transaction number R220623.1929.2100b5 to recharge 32 KSH to 0754858701 is successful. Your new balance is 1223951.06 KSH',200,'2022-06-23 16:29:11','PAYBILL','Airtel'),(5,5,'R220624.0614.210003',20,'Msg:210:Transaction number R220624.0614.210003 to recharge 20 KSH to 0756127080 is successful. Your new balance is 1066683.06 KSH',200,'2022-06-24 03:14:01','PAYBILL','Airtel'),(6,6,'R220624.1312.22001c',20,'Msg:210:Transaction number R220624.1312.22001c to recharge 20 KSH to 0756534576 is successful. Your new balance is 891083.06 KSH',200,'2022-06-24 10:12:00','PAYBILL','Airtel'),(7,7,'R220624.1850.210096',20,'Msg:210:Transaction number R220624.1850.210096 to recharge 20 KSH to 0732555073 is successful. Your new balance is 1259812.06 KSH',200,'2022-06-24 15:50:07','PAYBILL','Airtel'),(8,8,'R220624.1903.2102ba',10,'Msg:210:Transaction number R220624.1903.2102ba to recharge 10 KSH to 0781550186 is successful. Your new balance is 1253308.06 KSH',200,'2022-06-24 16:03:49','PAYBILL','Airtel'),(9,9,'R220624.2035.2201fa',20,'Msg:210:Transaction number R220624.2035.2201fa to recharge 20 KSH to 0104835297 is successful. Your new balance is 1180760.06 KSH',200,'2022-06-24 17:35:28','PAYBILL','Airtel'),(10,10,'R220625.1010.21001e',30,'R220625.1010.21001e confirmed. You have topped up 0722269084 with Ksh. 30. New balance is Ksh. 282950. ',200,'2022-06-25 07:10:38','PAYBILL','SAFCOM'),(11,11,'R220626.0755.220191',40,'Msg:210:Transaction number R220626.0755.220191 to recharge 40 KSH to 0755468146 is successful. Your new balance is 1600412.06 KSH',200,'2022-06-26 04:55:49','PAYBILL','Airtel'),(12,12,'R220626.0803.21019f',20,'Msg:210:Transaction number R220626.0803.21019f to recharge 20 KSH to 0739143948 is successful. Your new balance is 1597901.06 KSH',200,'2022-06-26 05:03:48','PAYBILL','Airtel'),(13,13,'R220626.1014.2201f5',50,'Msg:210:Transaction number R220626.1014.2201f5 to recharge 50 KSH to 0737546409 is successful. Your new balance is 1547690.06 KSH',200,'2022-06-26 07:14:51','PAYBILL','Airtel'),(14,14,'R220626.1759.21004e',20,'Msg:210:Transaction number R220626.1759.21004e to recharge 20 KSH to 0782881638 is successful. Your new balance is 1337889.06 KSH',200,'2022-06-26 14:59:04','PAYBILL','Airtel'),(15,15,'R220627.0748.220099',20,'Msg:210:Transaction number R220627.0748.220099 to recharge 20 KSH to 0784243169 is successful. Your new balance is 1112905.06 KSH',200,'2022-06-27 04:48:15','PAYBILL','Airtel'),(16,16,'R220627.1013.2100bd',20,'Msg:210:Transaction number R220627.1013.2100bd to recharge 20 KSH to 0751112500 is successful. Your new balance is 1574561.06 KSH',200,'2022-06-27 07:13:16','PAYBILL','Airtel'),(17,17,'R220627.1140.2201bf',20,'Msg:210:Transaction number R220627.1140.2201bf to recharge 20 KSH to 0785097588 is successful. Your new balance is 1531003.06 KSH',200,'2022-06-27 08:40:39','PAYBILL','Airtel'),(18,18,'R220627.1521.2200a9',20,'Msg:210:Transaction number R220627.1521.2200a9 to recharge 20 KSH to 0751112500 is successful. Your new balance is 1430731.06 KSH',200,'2022-06-27 12:21:19','PAYBILL','Airtel'),(19,19,'R220627.1808.21000e',20,'R220627.1808.21000e confirmed. You have topped up 0713535048 with Ksh. 20. New balance is Ksh. 756588. ',200,'2022-06-27 15:08:08','PAYBILL','SAFCOM'),(20,20,'R220627.1924.2100ec',20,'Msg:210:Transaction number R220627.1924.2100ec to recharge 20 KSH to 0734563304 is successful. Your new balance is 1304915.06 KSH',200,'2022-06-27 16:24:12','PAYBILL','Airtel'),(21,21,'R220627.2109.220374',30,'Msg:210:Transaction number R220627.2109.220374 to recharge 30 KSH to 0781807895 is successful. Your new balance is 1234000.06 KSH',200,'2022-06-27 18:09:58','PAYBILL','Airtel'),(22,22,'R220628.0637.21000b',10,'Msg:210:Transaction number R220628.0637.21000b to recharge 10 KSH to 0734573200 is successful. Your new balance is 1150636.06 KSH',200,'2022-06-28 03:36:59','PAYBILL','Airtel'),(23,23,'R220628.0735.210018',10,'Msg:210:Transaction number R220628.0735.210018 to recharge 10 KSH to 0783602792 is successful. Your new balance is 1138262.06 KSH',200,'2022-06-28 04:35:02','PAYBILL','Airtel'),(24,24,'R220628.0945.220029',5,'Msg:210:Transaction number R220628.0945.220029 to recharge 5 KSH to 0734573200 is successful. Your new balance is 1083820.06 KSH',200,'2022-06-28 06:45:01','PAYBILL','Airtel'),(25,25,'R220628.1212.220125',5,'Msg:210:Transaction number R220628.1212.220125 to recharge 5 KSH to 0756508395 is successful. Your new balance is 1544546.06 KSH',200,'2022-06-28 09:12:18','PAYBILL','Airtel'),(26,26,'R220628.1333.220146',20,'Msg:210:Transaction number R220628.1333.220146 to recharge 20 KSH to 0753650238 is successful. Your new balance is 1507456.06 KSH',200,'2022-06-28 10:33:29','PAYBILL','Airtel'),(27,27,'R220628.1536.22001b',200,'Msg:210:Transaction number R220628.1536.22001b to recharge 200 KSH to 0751627886 is successful. Your new balance is 1448784.06 KSH',200,'2022-06-28 12:36:03','PAYBILL','Airtel'),(28,28,'R220628.1636.220002',30,'Msg:210:Transaction number R220628.1636.220002 to recharge 30 KSH to 0786677110 is successful. Your new balance is 1419850.06 KSH',200,'2022-06-28 13:35:57','PAYBILL','Airtel'),(29,29,'R220628.1710.220244',80,'Msg:210:Transaction number R220628.1710.220244 to recharge 80 KSH to 0737338236 is successful. Your new balance is 1404233.06 KSH',200,'2022-06-28 14:10:45','PAYBILL','Airtel'),(30,30,'R220628.2023.210327',10,'Msg:210:Transaction number R220628.2023.210327 to recharge 10 KSH to 0734563304 is successful. Your new balance is 1287103.06 KSH',200,'2022-06-28 17:23:38','PAYBILL','Airtel'),(31,31,'R220628.2128.2102ad',30,'Msg:210:Transaction number R220628.2128.2102ad to recharge 30 KSH to 0784540205 is successful. Your new balance is 1240738.06 KSH',200,'2022-06-28 18:28:43','PAYBILL','Airtel'),(32,32,'R220628.2139.22022b',50,'Msg:210:Transaction number R220628.2139.22022b to recharge 50 KSH to 0750626245 is successful. Your new balance is 1232531.06 KSH',200,'2022-06-28 18:39:43','PAYBILL','Airtel'),(33,33,'R220629.0720.2101a8',30,'Msg:210:Transaction number R220629.0720.2101a8 to recharge 30 KSH to 0737649107 is successful. Your new balance is 1156915.06 KSH',200,'2022-06-29 04:20:49','PAYBILL','Airtel'),(34,34,'R220629.0812.210183',10,'Msg:210:Transaction number R220629.0812.210183 to recharge 10 KSH to 0100723976 is successful. Your new balance is 1137675.06 KSH',200,'2022-06-29 05:12:34','PAYBILL','Airtel'),(35,35,'R220629.1531.22000d',20,'Msg:210:Transaction number R220629.1531.22000d to recharge 20 KSH to 0751112500 is successful. Your new balance is 1462892.06 KSH',200,'2022-06-29 12:31:00','PAYBILL','Airtel'),(36,36,'R220629.1838.2200c1',30,'Msg:210:Transaction number R220629.1838.2200c1 to recharge 30 KSH to 0102721337 is successful. Your new balance is 1376635.06 KSH',200,'2022-06-29 15:38:14','PAYBILL','Airtel'),(37,37,'R220630.0751.2200b6',50,'Msg:210:Transaction number R220630.0751.2200b6 to recharge 50 KSH to 0734275675 is successful. Your new balance is 1167624.06 KSH',200,'2022-06-30 04:51:16','PAYBILL','Airtel'),(38,38,'R220630.1126.2101da',20,'Msg:210:Transaction number R220630.1126.2101da to recharge 20 KSH to 0734573200 is successful. Your new balance is 1596017.06 KSH',200,'2022-06-30 08:26:44','PAYBILL','Airtel'),(39,39,'R220630.1427.220184',31,'Msg:210:Transaction number R220630.1427.220184 to recharge 31 KSH to 0731323131 is successful. Your new balance is 1511691.06 KSH',200,'2022-06-30 11:27:35','PAYBILL','Airtel'),(40,40,'R220630.1807.220118',50,'Msg:210:Transaction number R220630.1807.220118 to recharge 50 KSH to 0782641014 is successful. Your new balance is 2366411.06 KSH',200,'2022-06-30 15:07:23','PAYBILL','Airtel'),(41,41,'R220630.1847.2101f8',20,'Msg:210:Transaction number R220630.1847.2101f8 to recharge 20 KSH to 0105145630 is successful. Your new balance is 2346152.06 KSH',200,'2022-06-30 15:47:39','PAYBILL','Airtel'),(42,42,'R220630.2128.210371',10,'Msg:210:Transaction number R220630.2128.210371 to recharge 10 KSH to 0106256558 is successful. Your new balance is 2231885.06 KSH',200,'2022-06-30 18:28:50','PAYBILL','Airtel'),(43,43,'R220701.1331.21017d',20,'Msg:210:Transaction number R220701.1331.21017d to recharge 20 KSH to 0751112500 is successful. Your new balance is 1956797.06 KSH',200,'2022-07-01 10:31:30','PAYBILL','Airtel'),(44,44,'',20,'Msg:7018:The mobile number 0nusrah  is incorrect. It should be consisting of 9 digits.',7018,'2022-07-01 12:07:51','PAYBILL','Airtel'),(45,45,'R220701.1640.22028b',50,'Msg:210:Transaction number R220701.1640.22028b to recharge 50 KSH to 0784199632 is successful. Your new balance is 1863185.06 KSH',200,'2022-07-01 13:40:55','PAYBILL','Airtel'),(46,46,'R220701.1951.2203e9',45,'Msg:210:Transaction number R220701.1951.2203e9 to recharge 45 KSH to 0106467436 is successful. Your new balance is 1748689.06 KSH',200,'2022-07-01 16:51:55','PAYBILL','Airtel'),(47,47,'R220701.2028.22002d',20,'Msg:210:Transaction number R220701.2028.22002d to recharge 20 KSH to 0734563304 is successful. Your new balance is 97203.54 KSH',200,'2022-07-01 17:27:31','PAYBILL','Airtel'),(48,48,'R220701.2115.21030a',10,'Msg:210:Transaction number R220701.2115.21030a to recharge 10 KSH to 0762068743 is successful. Your new balance is 1689108.06 KSH',200,'2022-07-01 18:15:46','PAYBILL','Airtel'),(49,49,'R220701.2247.210159',50,'Msg:210:Transaction number R220701.2247.210159 to recharge 50 KSH to 0100509717 is successful. Your new balance is 1635064.06 KSH',200,'2022-07-01 19:47:38','PAYBILL','Airtel'),(50,50,'R220702.0748.2200df',10,'Msg:210:Transaction number R220702.0748.2200df to recharge 10 KSH to 0751445552 is successful. Your new balance is 1580841.06 KSH',200,'2022-07-02 04:48:26','PAYBILL','Airtel'),(51,51,'R220702.1017.21022a',50,'Msg:210:Transaction number R220702.1017.21022a to recharge 50 KSH to 0784199632 is successful. Your new balance is 1512395.06 KSH',200,'2022-07-02 07:17:50','PAYBILL','Airtel'),(52,52,'R220702.1024.220315',10,'Msg:210:Transaction number R220702.1024.220315 to recharge 10 KSH to 0751445552 is successful. Your new balance is 1508919.06 KSH',200,'2022-07-02 07:24:56','PAYBILL','Airtel'),(53,53,'R220702.1435.210293',50,'Msg:210:Transaction number R220702.1435.210293 to recharge 50 KSH to 0750077152 is successful. Your new balance is 1394510.06 KSH',200,'2022-07-02 11:35:51','PAYBILL','Airtel'),(54,54,'',49,'',0,'2022-07-02 15:31:47','PAYBILL','Airtel'),(55,55,'R220702.1914.220344',20,'Msg:210:Transaction number R220702.1914.220344 to recharge 20 KSH to 0732560130 is successful. Your new balance is 1253980.06 KSH',200,'2022-07-02 16:14:50','PAYBILL','Airtel'),(56,56,'R220702.2212.22029a',50,'Msg:210:Transaction number R220702.2212.22029a to recharge 50 KSH to 0735916451 is successful. Your new balance is 1122643.06 KSH',200,'2022-07-02 19:12:55','PAYBILL','Airtel'),(57,57,'R220702.2251.220120',20,'Msg:210:Transaction number R220702.2251.220120 to recharge 20 KSH to 0756917766 is successful. Your new balance is 1105315.06 KSH',200,'2022-07-02 19:51:33','PAYBILL','Airtel'),(58,58,'R220703.0856.220215',50,'Msg:210:Transaction number R220703.0856.220215 to recharge 50 KSH to 0732974259 is successful. Your new balance is 1560824.06 KSH',200,'2022-07-03 05:56:51','PAYBILL','Airtel'),(59,59,'R220703.0943.22025a',10,'Msg:210:Transaction number R220703.0943.22025a to recharge 10 KSH to 0781959081 is successful. Your new balance is 1538002.06 KSH',200,'2022-07-03 06:43:57','PAYBILL','Airtel'),(60,60,'R220703.1022.22027a',60,'Msg:210:Transaction number R220703.1022.22027a to recharge 60 KSH to 0739501166 is successful. Your new balance is 1521264.06 KSH',200,'2022-07-03 07:22:57','PAYBILL','Airtel'),(61,61,'R220703.1500.21008b',8,'Msg:210:Transaction number R220703.1500.21008b to recharge 8 KSH to 0731674001 is successful. Your new balance is 1396524.06 KSH',200,'2022-07-03 12:00:13','PAYBILL','Airtel'),(62,62,'R220703.1515.220100',20,'Msg:210:Transaction number R220703.1515.220100 to recharge 20 KSH to 0754944320 is successful. Your new balance is 1389469.06 KSH',200,'2022-07-03 12:15:19','PAYBILL','Airtel'),(63,63,'R220703.1625.210163',10,'Msg:210:Transaction number R220703.1625.210163 to recharge 10 KSH to 0785187058 is successful. Your new balance is 1355941.06 KSH',200,'2022-07-03 13:25:25','PAYBILL','Airtel'),(64,64,'R220703.1736.2100a0',20,'Msg:210:Transaction number R220703.1736.2100a0 to recharge 20 KSH to 0737949628 is successful. Your new balance is 1319341.06 KSH',200,'2022-07-03 14:36:14','PAYBILL','Airtel'),(65,65,'R220703.1748.22024d',10,'Msg:210:Transaction number R220703.1748.22024d to recharge 10 KSH to 0786549002 is successful. Your new balance is 1313769.06 KSH',200,'2022-07-03 14:48:49','PAYBILL','Airtel'),(66,66,'R220703.1800.21006b',10,'Msg:210:Transaction number R220703.1800.21006b to recharge 10 KSH to 0734573200 is successful. Your new balance is 1308152.06 KSH',200,'2022-07-03 15:00:07','PAYBILL','Airtel'),(67,67,'R220703.1921.2102f6',100,'Msg:210:Transaction number R220703.1921.2102f6 to recharge 100 KSH to 0753536823 is successful. Your new balance is 1262865.06 KSH',200,'2022-07-03 16:21:43','PAYBILL','Airtel'),(68,68,'R220703.2148.210133',10,'Msg:210:Transaction number R220703.2148.210133 to recharge 10 KSH to 0750253935 is successful. Your new balance is 1162115.06 KSH',200,'2022-07-03 18:48:20','PAYBILL','Airtel'),(69,69,'R220703.2257.22015b',33,'Msg:210:Transaction number R220703.2257.22015b to recharge 33 KSH to 0782005977 is successful. Your new balance is 1132483.06 KSH',200,'2022-07-03 19:57:55','PAYBILL','Airtel'),(70,70,'R220704.0941.220182',5,'Msg:210:Transaction number R220704.0941.220182 to recharge 5 KSH to 0734573200 is successful. Your new balance is 1024536.06 KSH',200,'2022-07-04 06:41:38','PAYBILL','Airtel'),(71,71,'R220704.1115.210325',15,'Msg:210:Transaction number R220704.1115.210325 to recharge 15 KSH to 0753701603 is successful. Your new balance is 972265.06 KSH',200,'2022-07-04 08:15:50','PAYBILL','Airtel'),(72,72,'R220704.1223.220214',20,'Msg:210:Transaction number R220704.1223.220214 to recharge 20 KSH to 0731058966 is successful. Your new balance is 937119.06 KSH',200,'2022-07-04 09:23:36','PAYBILL','Airtel'),(73,73,'R220704.1950.210103',20,'Msg:210:Transaction number R220704.1950.210103 to recharge 20 KSH to 0732560130 is successful. Your new balance is 1238900.06 KSH',200,'2022-07-04 16:50:12','PAYBILL','Airtel'),(74,74,'R220704.2157.210103',20,'Msg:210:Transaction number R220704.2157.210103 to recharge 20 KSH to 0104914945 is successful. Your new balance is 1140633.06 KSH',200,'2022-07-04 18:57:16','PAYBILL','Airtel'),(75,75,'',20,'Msg:4354:This mobile number series is not defined in the system.',4354,'2022-07-04 20:21:59','PAYBILL','Airtel'),(76,76,'R220705.0837.220026',10,'Msg:210:Transaction number R220705.0837.220026 to recharge 10 KSH to 0734573200 is successful. Your new balance is 1045694.06 KSH',200,'2022-07-05 05:37:01','PAYBILL','Airtel'),(77,77,'R220705.0840.2101fc',10,'Msg:210:Transaction number R220705.0840.2101fc to recharge 10 KSH to 0785414315 is successful. Your new balance is 1043639.06 KSH',200,'2022-07-05 05:40:40','PAYBILL','Airtel'),(78,78,'R220705.1139.210271',20,'Msg:210:Transaction number R220705.1139.210271 to recharge 20 KSH to 0102334191 is successful. Your new balance is 939127.06 KSH',200,'2022-07-05 08:39:49','PAYBILL','Airtel'),(79,79,'R220705.1210.210144',20,'Msg:210:Transaction number R220705.1210.210144 to recharge 20 KSH to 0104914945 is successful. Your new balance is 921171.06 KSH',200,'2022-07-05 09:10:24','PAYBILL','Airtel'),(80,80,'R220705.1316.2100e6',10,'Msg:210:Transaction number R220705.1316.2100e6 to recharge 10 KSH to 0734877555 is successful. Your new balance is 53093.54 KSH',200,'2022-07-05 10:15:53','PAYBILL','Airtel'),(81,81,'',30,'',0,'2022-07-05 10:28:19','PAYBILL','Airtel'),(82,82,'R220705.1337.2102fe',50,'Msg:210:Transaction number R220705.1337.2102fe to recharge 50 KSH to 0786476416 is successful. Your new balance is 867974.06 KSH',200,'2022-07-05 10:37:55','PAYBILL','Airtel'),(83,83,'R220705.1411.2201c6',50,'Msg:210:Transaction number R220705.1411.2201c6 to recharge 50 KSH to 0780038079 is successful. Your new balance is 849667.06 KSH',200,'2022-07-05 11:11:37','PAYBILL','Airtel'),(84,84,'',20,'',0,'2022-07-05 12:00:48','PAYBILL','Airtel'),(85,85,'R220705.1543.22012b',15,'Msg:210:Transaction number R220705.1543.22012b to recharge 15 KSH to 0753701603 is successful. Your new balance is 1227286.06 KSH',200,'2022-07-05 12:43:22','PAYBILL','Airtel'),(86,86,'R220705.1639.2201e0',20,'Msg:210:Transaction number R220705.1639.2201e0 to recharge 20 KSH to 0735262939 is successful. Your new balance is 1198877.06 KSH',200,'2022-07-05 13:39:40','PAYBILL','Airtel'),(87,87,'R220705.1834.210112',10,'Msg:210:Transaction number R220705.1834.210112 to recharge 10 KSH to 0762445687 is successful. Your new balance is 1135759.06 KSH',200,'2022-07-05 15:34:24','PAYBILL','Airtel'),(88,88,'R220706.0036.220030',12,'Msg:210:Transaction number R220706.0036.220030 to recharge 12 KSH to 0104701157 is successful. Your new balance is 941467.06 KSH',200,'2022-07-05 21:36:28','PAYBILL','Airtel'),(89,89,'R220706.0646.2200b0',100,'Msg:210:Transaction number R220706.0646.2200b0 to recharge 100 KSH to 0734746940 is successful. Your new balance is 926600.06 KSH',200,'2022-07-06 03:46:40','PAYBILL','Airtel'),(90,90,'R220706.0716.21005e',30,'Msg:210:Transaction number R220706.0716.21005e to recharge 30 KSH to 0733845854 is successful. Your new balance is 919375.06 KSH',200,'2022-07-06 04:16:11','PAYBILL','Airtel'),(91,91,'R220706.0800.2201f2',40,'Msg:210:Transaction number R220706.0800.2201f2 to recharge 40 KSH to 0786476416 is successful. Your new balance is 905859.06 KSH',200,'2022-07-06 05:00:46','PAYBILL','Airtel'),(92,92,'R220706.0911.210208',10,'Msg:210:Transaction number R220706.0911.210208 to recharge 10 KSH to 0734573200 is successful. Your new balance is 869229.06 KSH',200,'2022-07-06 06:11:43','PAYBILL','Airtel'),(93,93,'R220706.1148.2202af',20,'Msg:210:Transaction number R220706.1148.2202af to recharge 20 KSH to 0754944320 is successful. Your new balance is 1419289.06 KSH',200,'2022-07-06 08:48:53','PAYBILL','Airtel'),(94,94,'R220706.1440.220293',20,'Msg:210:Transaction number R220706.1440.220293 to recharge 20 KSH to 0753153126 is successful. Your new balance is 1332094.06 KSH',200,'2022-07-06 11:40:53','PAYBILL','Airtel'),(95,95,'R220706.1611.210165',10,'Msg:210:Transaction number R220706.1611.210165 to recharge 10 KSH to 0782942690 is successful. Your new balance is 1286944.06 KSH',200,'2022-07-06 13:11:28','PAYBILL','Airtel'),(96,96,'R220706.1643.2201f2',10,'Msg:210:Transaction number R220706.1643.2201f2 to recharge 10 KSH to 0732872359 is successful. Your new balance is 1268999.06 KSH',200,'2022-07-06 13:43:43','PAYBILL','Airtel'),(97,97,'R220706.1823.21021c',20,'Msg:210:Transaction number R220706.1823.21021c to recharge 20 KSH to 0732560130 is successful. Your new balance is 187114.54 KSH',200,'2022-07-06 15:23:10','PAYBILL','Airtel'),(98,98,'R220706.1929.21039e',20,'Msg:210:Transaction number R220706.1929.21039e to recharge 20 KSH to 0756412791 is successful. Your new balance is 1180854.06 KSH',200,'2022-07-06 16:29:49','PAYBILL','Airtel'),(99,99,'R220706.2042.2102b7',20,'Msg:210:Transaction number R220706.2042.2102b7 to recharge 20 KSH to 0780126621 is successful. Your new balance is 1129162.06 KSH',200,'2022-07-06 17:42:43','PAYBILL','Airtel'),(100,100,'R220706.2045.220137',30,'Msg:210:Transaction number R220706.2045.220137 to recharge 30 KSH to 0104701157 is successful. Your new balance is 1126942.06 KSH',200,'2022-07-06 17:45:13','PAYBILL','Airtel'),(101,101,'R220706.2151.2202ed',20,'Msg:210:Transaction number R220706.2151.2202ed to recharge 20 KSH to 0733845854 is successful. Your new balance is 1079999.06 KSH',200,'2022-07-06 18:51:44','PAYBILL','Airtel'),(102,102,'R220707.0640.22003a',20,'Msg:210:Transaction number R220707.0640.22003a to recharge 20 KSH to 0104914945 is successful. Your new balance is 1011814.06 KSH',200,'2022-07-07 03:40:15','PAYBILL','Airtel'),(103,103,'R220707.0920.210055',10,'Msg:210:Transaction number R220707.0920.210055 to recharge 10 KSH to 0753701603 is successful. Your new balance is 943341.06 KSH',200,'2022-07-07 06:20:02','PAYBILL','Airtel'),(104,104,'R220707.1031.2100d8',20,'Msg:210:Transaction number R220707.1031.2100d8 to recharge 20 KSH to 0104468051 is successful. Your new balance is 904793.06 KSH',200,'2022-07-07 07:31:14','PAYBILL','Airtel'),(105,105,'R220707.1058.210304',5,'Msg:210:Transaction number R220707.1058.210304 to recharge 5 KSH to 0753701603 is successful. Your new balance is 891398.06 KSH',200,'2022-07-07 07:58:53','PAYBILL','Airtel'),(106,106,'R220707.1200.2100d7',12,'Msg:210:Transaction number R220707.1200.2100d7 to recharge 12 KSH to 0734573200 is successful. Your new balance is 858314.06 KSH',200,'2022-07-07 09:00:17','PAYBILL','Airtel'),(107,107,'R220707.1243.210076',30,'Msg:210:Transaction number R220707.1243.210076 to recharge 30 KSH to 0780126621 is successful. Your new balance is 1417426.06 KSH',200,'2022-07-07 09:43:08','PAYBILL','Airtel'),(108,108,'R220707.1334.220103',20,'Msg:210:Transaction number R220707.1334.220103 to recharge 20 KSH to 0104914945 is successful. Your new balance is 1387431.06 KSH',200,'2022-07-07 10:34:17','PAYBILL','Airtel'),(109,109,'R220707.1423.220183',10,'Msg:210:Transaction number R220707.1423.220183 to recharge 10 KSH to 0786717846 is successful. Your new balance is 1364521.06 KSH',200,'2022-07-07 11:23:34','PAYBILL','Airtel'),(110,110,'R220707.1635.2100e6',20,'Msg:210:Transaction number R220707.1635.2100e6 to recharge 20 KSH to 0751554005 is successful. Your new balance is 1303625.06 KSH',200,'2022-07-07 13:35:17','PAYBILL','Airtel'),(111,111,'R220707.1930.22004b',10,'Msg:210:Transaction number R220707.1930.22004b to recharge 10 KSH to 0750492257 is successful. Your new balance is 1210424.06 KSH',200,'2022-07-07 16:30:00','PAYBILL','Airtel'),(112,112,'R220707.1940.2200eb',20,'Msg:210:Transaction number R220707.1940.2200eb to recharge 20 KSH to 0786476416 is successful. Your new balance is 1202586.06 KSH',200,'2022-07-07 16:40:11','PAYBILL','Airtel'),(113,113,'R220707.2118.210368',20,'Msg:210:Transaction number R220707.2118.210368 to recharge 20 KSH to 0732568433 is successful. Your new balance is 1131257.06 KSH',200,'2022-07-07 18:18:52','PAYBILL','Airtel'),(114,114,'R220707.2230.2101cb',20,'Msg:210:Transaction number R220707.2230.2101cb to recharge 20 KSH to 0732560130 is successful. Your new balance is 1086381.06 KSH',200,'2022-07-07 19:30:42','PAYBILL','Airtel'),(115,115,'',50,'This mobile number series is not defined in the system.',4354,'2022-07-07 19:33:03','PAYBILL','SAFCOM'),(116,116,'R220708.0905.220270',10,'Msg:210:Transaction number R220708.0905.220270 to recharge 10 KSH to 0781340403 is successful. Your new balance is 984513.06 KSH',200,'2022-07-08 06:05:49','PAYBILL','Airtel'),(117,117,'R220708.0933.220010',10,'Msg:210:Transaction number R220708.0933.220010 to recharge 10 KSH to 0782670642 is successful. Your new balance is 967998.06 KSH',200,'2022-07-08 06:33:00','PAYBILL','Airtel'),(118,118,'R220708.1021.210288',55,'Msg:210:Transaction number R220708.1021.210288 to recharge 55 KSH to 0756412008 is successful. Your new balance is 939086.06 KSH',200,'2022-07-08 07:21:43','PAYBILL','Airtel'),(119,119,'R220708.1025.2202e0',20,'Msg:210:Transaction number R220708.1025.2202e0 to recharge 20 KSH to 0733845854 is successful. Your new balance is 937118.06 KSH',200,'2022-07-08 07:25:48','PAYBILL','Airtel'),(120,120,'',100,'',0,'2022-07-08 08:39:10','PAYBILL','Airtel'),(121,121,'R220708.1253.2100c7',100,'Msg:210:Transaction number R220708.1253.2100c7 to recharge 100 KSH to 0751921676 is successful. Your new balance is 1441174.06 KSH',200,'2022-07-08 09:53:12','PAYBILL','Airtel'),(122,122,'R220708.1311.210031',50,'Transaction ID R220708.1311.210031 to top up 50 kshs to 0778840893 is successful. Your new balance is 53672 kshs',200,'2022-07-08 10:11:17','PAYBILL','TELKOM'),(123,123,'R220708.1321.210203',20,'Msg:210:Transaction number R220708.1321.210203 to recharge 20 KSH to 0739137545 is successful. Your new balance is 1429506.06 KSH',200,'2022-07-08 10:21:45','PAYBILL','Airtel'),(124,124,'R220708.1338.22019c',20,'Msg:210:Transaction number R220708.1338.22019c to recharge 20 KSH to 0786476416 is successful. Your new balance is 1418487.06 KSH',200,'2022-07-08 10:38:28','PAYBILL','Airtel'),(125,125,'R220708.1400.21015f',100,'Msg:210:Transaction number R220708.1400.21015f to recharge 100 KSH to 0105157319 is successful. Your new balance is 1405455.06 KSH',200,'2022-07-08 11:00:28','PAYBILL','Airtel'),(126,126,'R220708.1441.210084',10,'Msg:210:Transaction number R220708.1441.210084 to recharge 10 KSH to 0106178625 is successful. Your new balance is 1382819.06 KSH',200,'2022-07-08 11:41:11','PAYBILL','Airtel'),(127,127,'R220708.1548.2100a3',10,'Msg:210:Transaction number R220708.1548.2100a3 to recharge 10 KSH to 0734573200 is successful. Your new balance is 1346423.06 KSH',200,'2022-07-08 12:48:15','PAYBILL','Airtel'),(128,128,'R220708.1626.22011e',28,'Msg:210:Transaction number R220708.1626.22011e to recharge 28 KSH to 0786476416 is successful. Your new balance is 1324906.06 KSH',200,'2022-07-08 13:26:27','PAYBILL','Airtel'),(129,129,'R220708.1638.2202e0',20,'Msg:210:Transaction number R220708.1638.2202e0 to recharge 20 KSH to 0106467436 is successful. Your new balance is 1319289.06 KSH',200,'2022-07-08 13:38:56','PAYBILL','Airtel'),(130,130,'R220708.1837.220104',20,'Msg:210:Transaction number R220708.1837.220104 to recharge 20 KSH to 0104914945 is successful. Your new balance is 1252242.06 KSH',200,'2022-07-08 15:37:24','PAYBILL','Airtel'),(131,131,'R220708.2005.210242',20,'Msg:210:Transaction number R220708.2005.210242 to recharge 20 KSH to 0732560130 is successful. Your new balance is 1190333.06 KSH',200,'2022-07-08 17:05:33','PAYBILL','Airtel'),(132,132,'R220708.2050.21012a',20,'Msg:210:Transaction number R220708.2050.21012a to recharge 20 KSH to 0762209113 is successful. Your new balance is 1154101.06 KSH',200,'2022-07-08 17:50:14','PAYBILL','Airtel'),(133,133,'R220708.2054.210416',50,'Msg:210:Transaction number R220708.2054.210416 to recharge 50 KSH to 0762209113 is successful. Your new balance is 1149804.06 KSH',200,'2022-07-08 17:54:52','PAYBILL','Airtel'),(134,134,'R220708.2100.2201d2',10,'Msg:210:Transaction number R220708.2100.2201d2 to recharge 10 KSH to 0104897083 is successful. Your new balance is 1145118.06 KSH',200,'2022-07-08 18:00:24','PAYBILL','Airtel'),(135,135,'R220708.2128.21011e',20,'Msg:210:Transaction number R220708.2128.21011e to recharge 20 KSH to 0786271418 is successful. Your new balance is 1125631.06 KSH',200,'2022-07-08 18:28:18','PAYBILL','Airtel'),(136,136,'R220708.2138.210001',10,'Msg:210:Transaction number R220708.2138.210001 to recharge 10 KSH to 0789770228 is successful. Your new balance is 1118636.06 KSH',200,'2022-07-08 18:37:57','PAYBILL','Airtel'),(137,137,'',10,'',0,'2022-07-09 04:31:17','PAYBILL','Airtel'),(138,138,'R220709.0735.21006c',20,'Msg:210:Transaction number R220709.0735.21006c to recharge 20 KSH to 0781234944 is successful. Your new balance is 1023379.06 KSH',200,'2022-07-09 04:35:11','PAYBILL','Airtel'),(139,139,'R220709.0740.220035',20,'Msg:210:Transaction number R220709.0740.220035 to recharge 20 KSH to 0786476416 is successful. Your new balance is 1022076.06 KSH',200,'2022-07-09 04:40:03','PAYBILL','Airtel'),(140,140,'R220709.0840.21015b',10,'Msg:210:Transaction number R220709.0840.21015b to recharge 10 KSH to 0736540245 is successful. Your new balance is 993150.06 KSH',200,'2022-07-09 05:40:29','PAYBILL','Airtel'),(141,141,'R220709.1000.2202c9',20,'Msg:210:Transaction number R220709.1000.2202c9 to recharge 20 KSH to 0783870139 is successful. Your new balance is 1587501.06 KSH',200,'2022-07-09 07:00:57','PAYBILL','Airtel'),(142,142,'R220709.1144.210267',15,'Msg:210:Transaction number R220709.1144.210267 to recharge 15 KSH to 0753913042 is successful. Your new balance is 1523491.06 KSH',200,'2022-07-09 08:44:50','PAYBILL','Airtel'),(143,143,'R220709.1146.2102e6',20,'Msg:210:Transaction number R220709.1146.2102e6 to recharge 20 KSH to 0786476416 is successful. Your new balance is 1521945.06 KSH',200,'2022-07-09 08:46:56','PAYBILL','Airtel'),(144,144,'R220709.1432.2200e8',50,'Msg:210:Transaction number R220709.1432.2200e8 to recharge 50 KSH to 0101651449 is successful. Your new balance is 1435897.06 KSH',200,'2022-07-09 11:32:12','PAYBILL','Airtel'),(145,145,'R220709.1434.21000a',50,'Msg:210:Transaction number R220709.1434.21000a to recharge 50 KSH to 0103305597 is successful. Your new balance is 1435062.06 KSH',200,'2022-07-09 11:33:59','PAYBILL','Airtel'),(146,146,'R220709.1438.2200de',10,'Msg:210:Transaction number R220709.1438.2200de to recharge 10 KSH to 0784071988 is successful. Your new balance is 1432902.06 KSH',200,'2022-07-09 11:38:16','PAYBILL','Airtel'),(147,147,'R220709.1524.220155',10,'Msg:210:Transaction number R220709.1524.220155 to recharge 10 KSH to 0781234944 is successful. Your new balance is 1407032.06 KSH',200,'2022-07-09 12:24:34','PAYBILL','Airtel'),(148,148,'R220709.1624.2200af',50,'Msg:210:Transaction number R220709.1624.2200af to recharge 50 KSH to 0734923526 is successful. Your new balance is 211162.54 KSH',200,'2022-07-09 13:23:48','PAYBILL','Airtel'),(149,149,'R220709.1659.2201e6',10,'Msg:210:Transaction number R220709.1659.2201e6 to recharge 10 KSH to 0782516449 is successful. Your new balance is 1360186.06 KSH',200,'2022-07-09 13:59:36','PAYBILL','Airtel'),(150,150,'R220709.1703.2100b7',20,'Msg:210:Transaction number R220709.1703.2100b7 to recharge 20 KSH to 0787640430 is successful. Your new balance is 1358287.06 KSH',200,'2022-07-09 14:03:13','PAYBILL','Airtel'),(151,151,'R220709.1729.21013c',50,'Msg:210:Transaction number R220709.1729.21013c to recharge 50 KSH to 0733845854 is successful. Your new balance is 1346473.06 KSH',200,'2022-07-09 14:29:24','PAYBILL','Airtel'),(152,152,'R220709.1822.2102d4',10,'Msg:210:Transaction number R220709.1822.2102d4 to recharge 10 KSH to 0734573200 is successful. Your new balance is 1316971.06 KSH',200,'2022-07-09 15:22:45','PAYBILL','Airtel'),(153,153,'R220709.1834.210025',10,'Msg:210:Transaction number R220709.1834.210025 to recharge 10 KSH to 0751750346 is successful. Your new balance is 1310898.06 KSH',200,'2022-07-09 15:34:01','PAYBILL','Airtel'),(154,154,'R220709.2007.2203d8',350,'Msg:210:Transaction number R220709.2007.2203d8 to recharge 350 KSH to 0105302004 is successful. Your new balance is 1244234.06 KSH',200,'2022-07-09 17:07:50','PAYBILL','Airtel'),(155,155,'R220709.2027.2100a4',50,'Msg:210:Transaction number R220709.2027.2100a4 to recharge 50 KSH to 0737394580 is successful. Your new balance is 1231244.06 KSH',200,'2022-07-09 17:27:09','PAYBILL','Airtel'),(156,156,'R220709.2029.220398',20,'Msg:210:Transaction number R220709.2029.220398 to recharge 20 KSH to 0734946240 is successful. Your new balance is 1228567.06 KSH',200,'2022-07-09 17:29:51','PAYBILL','Airtel'),(157,157,'R220709.2054.2202bc',20,'Msg:210:Transaction number R220709.2054.2202bc to recharge 20 KSH to 0732560130 is successful. Your new balance is 1204625.06 KSH',200,'2022-07-09 17:54:36','PAYBILL','Airtel'),(158,158,'R220710.0958.2200f8',5,'Msg:210:Transaction number R220710.0958.2200f8 to recharge 5 KSH to 0737394580 is successful. Your new balance is 1648930.06 KSH',200,'2022-07-10 06:58:22','PAYBILL','Airtel'),(159,159,'R220710.1114.21012a',10,'Msg:210:Transaction number R220710.1114.21012a to recharge 10 KSH to 0783870139 is successful. Your new balance is 1613179.06 KSH',200,'2022-07-10 08:14:26','PAYBILL','Airtel'),(160,160,'R220710.1129.2100c4',20,'Msg:210:Transaction number R220710.1129.2100c4 to recharge 20 KSH to 0753913042 is successful. Your new balance is 1606608.06 KSH',200,'2022-07-10 08:29:20','PAYBILL','Airtel'),(161,161,'R220710.1345.220191',5,'Msg:210:Transaction number R220710.1345.220191 to recharge 5 KSH to 0104914945 is successful. Your new balance is 1540947.06 KSH',200,'2022-07-10 10:45:40','PAYBILL','Airtel'),(162,162,'R220710.1357.2201a3',26,'Msg:210:Transaction number R220710.1357.2201a3 to recharge 26 KSH to 0737394580 is successful. Your new balance is 1535599.06 KSH',200,'2022-07-10 10:57:40','PAYBILL','Airtel'),(163,163,'R220710.1400.2100df',5,'Msg:210:Transaction number R220710.1400.2100df to recharge 5 KSH to 0737394580 is successful. Your new balance is 1534585.06 KSH',200,'2022-07-10 11:00:15','PAYBILL','Airtel'),(164,164,'R220710.1659.2101a3',20,'Msg:210:Transaction number R220710.1659.2101a3 to recharge 20 KSH to 0783254407 is successful. Your new balance is 1443351.06 KSH',200,'2022-07-10 13:59:33','PAYBILL','Airtel'),(165,165,'R220710.1804.210221',20,'Msg:210:Transaction number R220710.1804.210221 to recharge 20 KSH to 0762351702 is successful. Your new balance is 138430.54 KSH',200,'2022-07-10 15:04:07','PAYBILL','Airtel'),(166,166,'R220710.1856.22012f',20,'Msg:210:Transaction number R220710.1856.22012f to recharge 20 KSH to 0750430537 is successful. Your new balance is 1376470.06 KSH',200,'2022-07-10 15:56:18','PAYBILL','Airtel'),(167,167,'R220710.1938.220340',20,'Msg:210:Transaction number R220710.1938.220340 to recharge 20 KSH to 0739137545 is successful. Your new balance is 1345503.06 KSH',200,'2022-07-10 16:38:41','PAYBILL','Airtel'),(168,168,'',1,'Msg:4354:This mobile number series is not defined in the system.',4354,'2022-07-10 16:56:11','PAYBILL','Airtel'),(169,169,'R220710.2036.2203d6',30,'Msg:210:Transaction number R220710.2036.2203d6 to recharge 30 KSH to 0739137545 is successful. Your new balance is 1300909.06 KSH',200,'2022-07-10 17:36:53','PAYBILL','Airtel'),(170,170,'R220710.2107.2200eb',20,'Msg:210:Transaction number R220710.2107.2200eb to recharge 20 KSH to 0755508088 is successful. Your new balance is 1278231.06 KSH',200,'2022-07-10 18:07:11','PAYBILL','Airtel'),(171,171,'R220710.2131.2101ce',10,'Msg:210:Transaction number R220710.2131.2101ce to recharge 10 KSH to 0734877555 is successful. Your new balance is 1260105.06 KSH',200,'2022-07-10 18:31:30','PAYBILL','Airtel'),(172,172,'R220710.2135.2202c6',50,'Msg:210:Transaction number R220710.2135.2202c6 to recharge 50 KSH to 0756412008 is successful. Your new balance is 1257276.06 KSH',200,'2022-07-10 18:35:43','PAYBILL','Airtel'),(173,173,'R220710.2210.220267',25,'Msg:210:Transaction number R220710.2210.220267 to recharge 25 KSH to 0733845854 is successful. Your new balance is 1233002.06 KSH',200,'2022-07-10 19:10:44','PAYBILL','Airtel'),(174,174,'R220711.0752.21012f',30,'Msg:210:Transaction number R220711.0752.21012f to recharge 30 KSH to 0731799631 is successful. Your new balance is 1156662.06 KSH',200,'2022-07-11 04:52:33','PAYBILL','Airtel'),(175,175,'',70,'',0,'2022-07-11 05:38:19','PAYBILL','Airtel'),(176,176,'R220711.0900.21026a',10,'Msg:210:Transaction number R220711.0900.21026a to recharge 10 KSH to 0783870139 is successful. Your new balance is 1126704.06 KSH',200,'2022-07-11 06:00:43','PAYBILL','Airtel'),(177,177,'R220711.0904.21009c',50,'Msg:210:Transaction number R220711.0904.21009c to recharge 50 KSH to 0733385037 is successful. Your new balance is 1125324.06 KSH',200,'2022-07-11 06:04:08','PAYBILL','Airtel'),(178,178,'R220711.0918.21027e',25,'Msg:210:Transaction number R220711.0918.21027e to recharge 25 KSH to 0733845854 is successful. Your new balance is 1118621.06 KSH',200,'2022-07-11 06:18:44','PAYBILL','Airtel'),(179,179,'R220711.0956.220086',10,'Msg:210:Transaction number R220711.0956.220086 to recharge 10 KSH to 0753315503 is successful. Your new balance is 1703178.06 KSH',200,'2022-07-11 06:56:10','PAYBILL','Airtel'),(180,180,'R220711.1014.21005d',5,'Msg:210:Transaction number R220711.1014.21005d to recharge 5 KSH to 0753302299 is successful. Your new balance is 1692726.06 KSH',200,'2022-07-11 07:14:04','PAYBILL','Airtel'),(181,181,'R220711.1016.210094',15,'Msg:210:Transaction number R220711.1016.210094 to recharge 15 KSH to 0753302299 is successful. Your new balance is 1691576.06 KSH',200,'2022-07-11 07:16:08','PAYBILL','Airtel'),(182,182,'R220711.1049.2101c0',10,'Msg:210:Transaction number R220711.1049.2101c0 to recharge 10 KSH to 0734573200 is successful. Your new balance is 1673044.06 KSH',200,'2022-07-11 07:49:42','PAYBILL','Airtel'),(183,183,'R220711.1142.220001',50,'Msg:210:Transaction number R220711.1142.220001 to recharge 50 KSH to 0739099946 is successful. Your new balance is 1644798.06 KSH',200,'2022-07-11 08:41:58','PAYBILL','Airtel'),(184,184,'R220711.1207.2201a1',15,'Msg:210:Transaction number R220711.1207.2201a1 to recharge 15 KSH to 0756333036 is successful. Your new balance is 1632140.06 KSH',200,'2022-07-11 09:07:33','PAYBILL','Airtel'),(185,185,'R220711.1837.2202e1',30,'Msg:210:Transaction number R220711.1837.2202e1 to recharge 30 KSH to 0731323707 is successful. Your new balance is 1443957.06 KSH',200,'2022-07-11 15:37:53','PAYBILL','Airtel'),(186,186,'R220711.1851.22015e',20,'Msg:210:Transaction number R220711.1851.22015e to recharge 20 KSH to 0732560130 is successful. Your new balance is 1436066.06 KSH',200,'2022-07-11 15:51:21','PAYBILL','Airtel'),(187,187,'R220711.2031.2102c5',20,'Msg:210:Transaction number R220711.2031.2102c5 to recharge 20 KSH to 0751452931 is successful. Your new balance is 1365552.06 KSH',200,'2022-07-11 17:31:38','PAYBILL','Airtel');

--
-- Table structure for table `uploads`
--

CREATE TABLE `uploads` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `filepath` text,
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `uploads`
--



