...

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: robisear_onestop
-- ------------------------------------------------------
-- Server version	10.6.22-MariaDB-log

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `accounttype`
--

DROP TABLE IF EXISTS `accounttype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `accounttype` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `type` varchar(50) NOT NULL,
  `companyid` varchar(10) NOT NULL,
  `userid` varchar(10) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `accounttype`
--

LOCK TABLES `accounttype` WRITE;
/*!40000 ALTER TABLE `accounttype` DISABLE KEYS */;
INSERT INTO `accounttype` VALUES (1,'Asset','BS','1','1','Asset'),(2,'Liability','BS','1','1','Liability'),(3,'Equity','BS','1','1','Equity'),(4,'Income','PL','1','1','Income'),(5,'Expense','PL','1','1','Expense');
/*!40000 ALTER TABLE `accounttype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `activityloggs`
--

DROP TABLE IF EXISTS `activityloggs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `activityloggs` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `userid` varchar(30) NOT NULL,
  `timedone` varchar(50) NOT NULL,
  `actiondone` text NOT NULL,
  `ip` text NOT NULL,
  `companyid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `activityloggs`
--

LOCK TABLES `activityloggs` WRITE;
/*!40000 ALTER TABLE `activityloggs` DISABLE KEYS */;
/*!40000 ALTER TABLE `activityloggs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admintable`
--

DROP TABLE IF EXISTS `admintable`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `admintable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `password` varchar(20) DEFAULT NULL,
  `surname` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `campus` varchar(30) NOT NULL,
  `college` varchar(30) NOT NULL,
  `department` varchar(30) NOT NULL,
  `type` varchar(50) NOT NULL,
  `token` text NOT NULL,
  `email` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `idno` varchar(40) NOT NULL,
  `updatedat` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admintable`
--

LOCK TABLES `admintable` WRITE;
/*!40000 ALTER TABLE `admintable` DISABLE KEYS */;
INSERT INTO `admintable` VALUES (32,'admin','admin123','dd','ddd','222222222','','','','','','admqin@gmail.com','','active','2222222','2016-11-07 04:32:35');
/*!40000 ALTER TABLE `admintable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `advance`
--

DROP TABLE IF EXISTS `advance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `advance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenantid` varchar(50) NOT NULL,
  `todate` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `createdat` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `balance` varchar(50) NOT NULL,
  `closedate` varchar(30) NOT NULL,
  `startdate` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `advance`
--

LOCK TABLES `advance` WRITE;
/*!40000 ALTER TABLE `advance` DISABLE KEYS */;
/*!40000 ALTER TABLE `advance` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agent`
--

DROP TABLE IF EXISTS `agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `agent` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `idno` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `county` varchar(40) NOT NULL,
  `accountno` varchar(100) NOT NULL,
  `accountname` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`idno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent`
--

LOCK TABLES `agent` WRITE;
/*!40000 ALTER TABLE `agent` DISABLE KEYS */;
/*!40000 ALTER TABLE `agent` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alldocuments`
--

DROP TABLE IF EXISTS `alldocuments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `alldocuments` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `img_id` varchar(50) NOT NULL,
  `userid` text NOT NULL,
  `date` varchar(50) DEFAULT NULL,
  `documentname` text DEFAULT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alldocuments`
--

LOCK TABLES `alldocuments` WRITE;
/*!40000 ALTER TABLE `alldocuments` DISABLE KEYS */;
/*!40000 ALTER TABLE `alldocuments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `announcement`
--

DROP TABLE IF EXISTS `announcement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `announcement` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `target` varchar(50) NOT NULL,
  `message` text NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `announcement`
--

LOCK TABLES `announcement` WRITE;
/*!40000 ALTER TABLE `announcement` DISABLE KEYS */;
/*!40000 ALTER TABLE `announcement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banks`
--

DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `banks` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `expendituretype` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `paiddate` varchar(50) NOT NULL,
  `incharge` varchar(40) NOT NULL,
  `bankname` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banks`
--

LOCK TABLES `banks` WRITE;
/*!40000 ALTER TABLE `banks` DISABLE KEYS */;
/*!40000 ALTER TABLE `banks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `batchlist`
--

DROP TABLE IF EXISTS `batchlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `batchlist` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL,
  `userid` varchar(30) NOT NULL,
  `exactime` varchar(50) NOT NULL,
  `batchid` varchar(50) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  `companyid` int(11) NOT NULL,
  `branchid` int(11) NOT NULL,
  `batchno` int(11) NOT NULL,
  `description` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `batchlist`
--

LOCK TABLES `batchlist` WRITE;
/*!40000 ALTER TABLE `batchlist` DISABLE KEYS */;
INSERT INTO `batchlist` VALUES (1,'P.O','1','2019-01-03 16:30:59','11546522257','11546522185',1,1,1,'');
/*!40000 ALTER TABLE `batchlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `bookroom`
--

DROP TABLE IF EXISTS `bookroom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `bookroom` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `houseno` varchar(60) NOT NULL,
  `plotno` varchar(50) NOT NULL,
  `idno` varchar(50) NOT NULL,
  `tenantid` varchar(40) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `checkoutdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdat` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `paymentstatus` varchar(30) NOT NULL,
  `paymentmode` varchar(30) NOT NULL,
  `paymentcode` varchar(30) NOT NULL,
  `totalamount` varchar(30) NOT NULL,
  `discount` varchar(30) NOT NULL,
  `transactioncode` varchar(30) NOT NULL,
  `roomtype` varchar(40) NOT NULL,
  `number` varchar(10) NOT NULL,
  `total` varchar(30) NOT NULL,
  `balance` varchar(30) NOT NULL,
  `mpesa` varchar(30) NOT NULL,
  `card` varchar(30) NOT NULL,
  `bookroom` varchar(20) NOT NULL,
  `credit` varchar(30) NOT NULL,
  `voucher` varchar(10) NOT NULL,
  `cheque` varchar(30) NOT NULL,
  `points` varchar(30) NOT NULL,
  `people` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transactioncode` (`transactioncode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bookroom`
--

LOCK TABLES `bookroom` WRITE;
/*!40000 ALTER TABLE `bookroom` DISABLE KEYS */;
/*!40000 ALTER TABLE `bookroom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `branch`
--

DROP TABLE IF EXISTS `branch`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `branch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `branch`
--

LOCK TABLES `branch` WRITE;
/*!40000 ALTER TABLE `branch` DISABLE KEYS */;
INSERT INTO `branch` VALUES (1,'Counter','','2019-02-07 11:13:32','active','1','','1');
/*!40000 ALTER TABLE `branch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `callcenter`
--

DROP TABLE IF EXISTS `callcenter`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `callcenter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `category` varchar(30) NOT NULL,
  `messageid` varchar(30) NOT NULL,
  `updatedby` int(11) NOT NULL,
  `updateddate` varchar(30) NOT NULL,
  `callername` text NOT NULL,
  `receiver` text NOT NULL,
  `calldate` varchar(30) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `media` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `callcenter`
--

LOCK TABLES `callcenter` WRITE;
/*!40000 ALTER TABLE `callcenter` DISABLE KEYS */;
INSERT INTO `callcenter` VALUES (1,'CALL','ok','2018-11-19','solved','1','','1','Sales','',0,'','robert','tom','2018-11-19','MH41VVFDC9','tv');
/*!40000 ALTER TABLE `callcenter` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'VITI','VITI','2018-12-14 13:56:56','active','1','','1'),(2,'SUPPLIER','','2018-12-19 15:12:09','active','1','','1');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `charges`
--

DROP TABLE IF EXISTS `charges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `charges` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `type` varchar(40) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(40) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `charges`
--

LOCK TABLES `charges` WRITE;
/*!40000 ALTER TABLE `charges` DISABLE KEYS */;
INSERT INTO `charges` VALUES (1,'IRONING','','','2019-01-28 07:06:29','','','');
/*!40000 ALTER TABLE `charges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `collection`
--

DROP TABLE IF EXISTS `collection`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paiddate` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `invoice` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `remarks` varchar(100) NOT NULL,
  `balance` varchar(30) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `companyid` varchar(20) NOT NULL,
  `paymentmethodes` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `collection`
--

LOCK TABLES `collection` WRITE;
/*!40000 ALTER TABLE `collection` DISABLE KEYS */;
INSERT INTO `collection` VALUES (1,'2019-01-31 14:36:20','','11548934451','50','','0','1','1',1);
/*!40000 ALTER TABLE `collection` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `complain`
--

DROP TABLE IF EXISTS `complain`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `complain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `type` varchar(30) NOT NULL,
  `messageid` varchar(30) NOT NULL,
  `updatedby` int(11) NOT NULL,
  `updateddate` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `complain`
--

LOCK TABLES `complain` WRITE;
/*!40000 ALTER TABLE `complain` DISABLE KEYS */;
INSERT INTO `complain` VALUES (1,'4666','ok','2018-11-19','New','1','','1','Message','All',0,'');
/*!40000 ALTER TABLE `complain` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `complaindata`
--

DROP TABLE IF EXISTS `complaindata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `complaindata` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `date` varchar(50) NOT NULL,
  `taskid` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `complaindata`
--

LOCK TABLES `complaindata` WRITE;
/*!40000 ALTER TABLE `complaindata` DISABLE KEYS */;
/*!40000 ALTER TABLE `complaindata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `county`
--

DROP TABLE IF EXISTS `county`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `county` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `provincecode` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `county`
--

LOCK TABLES `county` WRITE;
/*!40000 ALTER TABLE `county` DISABLE KEYS */;
INSERT INTO `county` VALUES (1,'1','Mombasa','2','Mombasa','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'2','Kwale','2','Kwale','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'3','Kilifi','2','Kilifi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'4','Tana River','2','Tana River','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'5','Lamu','2','Lamu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'6','Taita-Taveta','2','Taita-Taveta','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'7','Garissa','5','Garissa','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'8','Wajir','5','Wajir','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'9','Mandera','5','Mandera','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'10','Marsabit','3','Marsabit','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'11','Isiolo','3','Isiolo','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'12','Meru','3','Meru','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'13','Tharaka-Nithi','3','Tharaka-Nithi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'14','Embu','3','Embu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'15','Kitui','3','Kitui','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'16','Machakos','3','Machakos','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'17','Makueni','3','Makueni','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'18','Nyandarua','1','Nyandarua','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'19','Nyeri','1','Nyeri','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'20','Kirinyaga','1','Kirinyaga','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'21','Murang\'a','1','Murang\'a','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'22','Kiambu','1','Kiambu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'23','Turkana','7','Turkana','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'24','West Pokot','7','West Pokot','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'25','Samburu','7','Samburu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'26','Trans-Nzoia','7','Trans-Nzoia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'27','Uasin Gishu','7','Uasin Gishu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'28','Elgeyo-Marakwet','7','Elgeyo-Marakwet','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'29','Nandi','7','Nandi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'30','Baringo','7','Baringo','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'31','Laikipia','7','Laikipia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'32','Nakuru','7','Nakuru','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'33','Narok','7','Narok','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'34','Kajiado','7','Kajiado','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'35','Kericho','7','Kericho','0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'36','Bomet','7','Bomet','0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,'37','Kakamega','8','Kakamega','0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,'38','Vihiga','8','Vihiga','0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,'39','Bungoma','8','Bungoma','0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,'40','Busia','8','Busia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,'41','Siaya','6','Siaya','0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,'42','Kisumu','6','Kisumu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,'43','Homa Bay','6','Homa Bay','0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'44','Migori','6','Migori','0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'45','Kisii','6','Kisii','0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,'46','Nyamira','6','Nyamira','0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,'47','Nairobi','4','Nairobi','0000-00-00 00:00:00','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `county` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `currency`
--

DROP TABLE IF EXISTS `currency`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `currency` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `currency`
--

LOCK TABLES `currency` WRITE;
/*!40000 ALTER TABLE `currency` DISABLE KEYS */;
INSERT INTO `currency` VALUES (1,'Ksh','','2018-03-06 19:44:07pm','active','1','','1'),(2,'URO','','','active','','','1'),(3,'USD','','','active','','','1');
/*!40000 ALTER TABLE `currency` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dailycharges`
--

DROP TABLE IF EXISTS `dailycharges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `dailycharges` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `chargeid` int(11) NOT NULL,
  `plotno` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  `houseno` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dailycharges`
--

LOCK TABLES `dailycharges` WRITE;
/*!40000 ALTER TABLE `dailycharges` DISABLE KEYS */;
/*!40000 ALTER TABLE `dailycharges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dailycollections`
--

DROP TABLE IF EXISTS `dailycollections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `dailycollections` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `idno` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdat` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `name` varchar(30) NOT NULL,
  `total` varchar(30) NOT NULL,
  `balance` varchar(30) NOT NULL,
  `mpesa` varchar(30) NOT NULL,
  `card` varchar(30) NOT NULL,
  `credit` varchar(30) NOT NULL,
  `voucher` varchar(10) NOT NULL,
  `cheque` varchar(30) NOT NULL,
  `points` varchar(30) NOT NULL,
  `controller` varchar(30) NOT NULL,
  `expense` varchar(30) NOT NULL,
  `cash` varchar(30) NOT NULL,
  `discount` varchar(30) NOT NULL,
  `entrydate` varchar(30) NOT NULL,
  `contact` varchar(30) NOT NULL,
  `transactioncode` varchar(30) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'active',
  `tax` decimal(10,2) NOT NULL,
  `sort` decimal(10,2) NOT NULL,
  `sortmoney` decimal(10,2) NOT NULL,
  `transactiondate` varchar(30) NOT NULL,
  `branchid` int(11) NOT NULL,
  `openingbalance` decimal(10,2) NOT NULL,
  `closingbalance` decimal(10,2) NOT NULL,
  `cashcollected` decimal(10,2) NOT NULL,
  `totalsales` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dailycollections`
--

LOCK TABLES `dailycollections` WRITE;
/*!40000 ALTER TABLE `dailycollections` DISABLE KEYS */;
INSERT INTO `dailycollections` VALUES (1,'','','1','2019-02-02 03:46:35pm','','1','','Robisearch','','',' 0','0','0','0','0','0','ROBERT','0','1040','','2019-02-02 15:45:54','','','active',143.44,0.00,0.00,'',1,0.00,0.00,0.00,1040.00);
/*!40000 ALTER TABLE `dailycollections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `damages`
--

DROP TABLE IF EXISTS `damages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `damages` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `expendituretype` varchar(50) NOT NULL,
  `user` varchar(50) NOT NULL,
  `qty` varchar(50) NOT NULL,
  `details` text NOT NULL,
  `datedamaged` varchar(50) NOT NULL,
  `incharge` varchar(40) NOT NULL,
  `product` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `original` decimal(10,2) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `damages`
--

LOCK TABLES `damages` WRITE;
/*!40000 ALTER TABLE `damages` DISABLE KEYS */;
/*!40000 ALTER TABLE `damages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deals`
--

DROP TABLE IF EXISTS `deals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `deals` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `owner` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `nextstep` text NOT NULL,
  `contactname` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `fromdate` varchar(100) NOT NULL,
  `todate` varchar(100) NOT NULL,
  `probability` varchar(100) NOT NULL,
  `expectedrevenue` varchar(100) NOT NULL,
  `stage` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'active',
  `comments` text NOT NULL,
  `userid` varchar(100) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `allsteps` text NOT NULL,
  `dealowner` varchar(30) NOT NULL,
  `branchid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deals`
--

LOCK TABLES `deals` WRITE;
/*!40000 ALTER TABLE `deals` DISABLE KEYS */;
/*!40000 ALTER TABLE `deals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `debitcredit`
--

DROP TABLE IF EXISTS `debitcredit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `debitcredit` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `crateddate` varchar(30) NOT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` decimal(10,2) NOT NULL,
  `balance` varchar(20) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `companyid` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `branch` varchar(30) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `refno` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `debitcredit`
--

LOCK TABLES `debitcredit` WRITE;
/*!40000 ALTER TABLE `debitcredit` DISABLE KEYS */;
INSERT INTO `debitcredit` VALUES (1,'2130','45566','2019-02-01 14:58:02',0.00,2000.00,'8000','1','1','Purchases','1','','',''),(2,'5500','45566','2019-02-01 14:58:02',2000.00,0.00,'8000','1','1','Purchases','1','','',''),(3,'4000','11549202086','2019-02-03 16:55:04',0.00,160.00,'295715','1','1','Supplier Bill','1','','',''),(4,'1100','11549202086','2019-02-03 16:55:04',160.00,0.00,'122065','1','1','Supplier Bill','1','','',''),(5,'4000','11549202164','2019-02-03 16:56:32',0.00,240.00,'295955','1','1','Supplier Bill','1','','',''),(6,'1100','11549202164','2019-02-03 16:56:32',240.00,0.00,'122305','1','1','Supplier Bill','1','','',''),(7,'4000','11549202164','2019-02-03 16:56:32',0.00,240.00,'296195','1','1','Supplier Bill','1','','',''),(8,'1100','11549202164','2019-02-03 16:56:32',240.00,0.00,'122545','1','1','Supplier Bill','1','','',''),(9,'4000','11549202429','2019-02-03 17:00:42',0.00,600.00,'296795','1','1','Supplier Bill','1','','',''),(10,'1100','11549202429','2019-02-03 17:00:42',600.00,0.00,'123145','1','1','Supplier Bill','1','','',''),(11,'4000','11549202429','2019-02-03 17:00:42',0.00,760.00,'297555','1','1','Supplier Bill','1','','',''),(12,'1100','11549202429','2019-02-03 17:00:42',760.00,0.00,'123905','1','1','Supplier Bill','1','','',''),(13,'4000','11549202723','2019-02-03 17:05:36',0.00,1060.00,'299515','1','1','Supplier Bill','1','','',''),(14,'1100','11549202723','2019-02-03 17:05:36',1060.00,0.00,'125865','1','1','Supplier Bill','1','','',''),(15,'4000','11549202863','2019-02-03 17:07:59',0.00,315.00,'300065','1','1','Supplier Bill','1','','',''),(16,'1100','11549202863','2019-02-03 17:07:59',315.00,0.00,'126415','1','1','Supplier Bill','1','','',''),(17,'4000','11549202863','2019-02-03 17:07:59',0.00,330.00,'300395','1','1','Supplier Bill','1','','',''),(18,'1100','11549202863','2019-02-03 17:07:59',330.00,0.00,'126745','1','1','Supplier Bill','1','','',''),(19,'4000','21550149339','2019-03-02 16:37:22',0.00,111.00,'317181','2','1','Supplier Bill','1','','',''),(20,'1100','21550149339','2019-03-02 16:37:22',111.00,0.00,'143531','2','1','Supplier Bill','1','','',''),(21,'4000','11549611429','2019-02-08 10:38:21',0.00,680.00,'317861','1','1','Supplier Bill','1','','',''),(22,'1100','11549611429','2019-02-08 10:38:21',680.00,0.00,'144211','1','1','Supplier Bill','1','','',''),(23,'4000','11553599920','2019-03-26 14:35:00',0.00,11000.00,'328861','1','1','Supplier Bill','1','','',''),(24,'1100','11553599920','2019-03-26 14:35:00',11000.00,0.00,'155211','1','1','Supplier Bill','1','','',''),(25,'4000','11553946542','2019-03-30 14:49:35',0.00,30.00,'328891','1','1','Supplier Bill','1','','',''),(26,'1100','11553946542','2019-03-30 14:49:35',30.00,0.00,'155241','1','1','Supplier Bill','1','','','');
/*!40000 ALTER TABLE `debitcredit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `district`
--

DROP TABLE IF EXISTS `district`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `district` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `countyid` varchar(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `provincecode` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=279 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `district`
--

LOCK TABLES `district` WRITE;
/*!40000 ALTER TABLE `district` DISABLE KEYS */;
INSERT INTO `district` VALUES (1,'1','1','Kilindini','Kilindini','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(2,'2','1','Mombasa','Mombasa','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(3,'3','2','Kinango','Kinango','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(4,'4','2','Lungalunga','Lungalunga','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(5,'5','2','Kwale','Kwale','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(6,'6','2','Msabweni','Msabweni','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(7,'7','3','Kaloleni','Kaloleni','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(8,'8','3','Kilifi','Kilifi','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(9,'9','3','Malindi','Malindi','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(10,'10','4','Tana Delta','Tana Delta','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(11,'11','4','Tana River','Tana River','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(12,'12','4','Tana South','Tana South','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(13,'13','5','Lamu East','Lamu East','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(14,'14','5','Lamu West','Lamu West','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(15,'15','6','Taita','Taita','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(16,'16','6','Taveta','Taveta','0000-00-00 00:00:00','0000-00-00 00:00:00',2),(17,'17','7','Fafi','Fafi','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(18,'18','7','Garissa','Garissa','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(19,'19','7','Ijara','Ijara','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(20,'20','7','Dadaab','Dadaab','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(21,'21','7','Hulugho','Hulugho','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(22,'22','7','Lagdera','Lagdera','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(23,'23','8','Wajir East','Wajir East','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(24,'24','8','Wajir North','Wajir North','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(25,'25','8','Waijir South','Waijir South','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(26,'26','8','Eldas','Eldas','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(27,'27','8','Tarbaj','Tarbaj','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(28,'28','8','Wajir West','Wajir West','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(29,'29','9','Mandera central','Mandera central','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(30,'30','9','Mandera East','Mandera East','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(31,'31','9','Mandera North','Mandera North','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(32,'32','9','Mandera West','Mandera West','0000-00-00 00:00:00','0000-00-00 00:00:00',5),(33,'33','10','Marsabit central','Marsabit central','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(34,'34','10','Marsabit North','Marsabit North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(35,'35','10','Marsabit south','Marsabit south','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(36,'36','10','Moyale','Moyale','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(37,'37','10','Sololo','Sololo','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(38,'38','10','Loiyangalani','Loiyangalani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(39,'39','10','North Horr','North Horr','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(40,'40','11','Garbatula','Garbatula','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(41,'41','11','Isiolo','Isiolo','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(42,'42','11','Merti','Merti','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(43,'43','12','Igembe North','Igembe North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(44,'44','12','Igembe South','Igembe South','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(45,'45','12','Imenti North','Imenti North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(46,'46','12','Imenti South','Imenti South','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(47,'47','12','Meru Central','Meru Central','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(48,'48','12','Tigania East','Tigania East','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(49,'49','12','Tigania West','Tigania West','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(50,'50','12','Buuri','Buuri','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(51,'51','13','Maara','Maara','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(52,'52','13','Meru South','Meru South','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(53,'53','13','Tharaka North','Tharaka North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(54,'54','13','Tharaka South','Tharaka South','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(55,'55','14','Mbeere North','Mbeere North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(56,'56','14','Mbeere South','Mbeere South','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(57,'57','14','Embu East','Embu East','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(58,'58','14','Embu North','Embu North','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(59,'59','14','Embu West','Embu West','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(60,'60','15','Mutitu','Mutitu','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(61,'61','15','Lower Yatta','Lower Yatta','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(62,'62','15','Kisasi','Kisasi','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(63,'63','15','Nzambani','Nzambani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(64,'64','15','Ikutha','Ikutha','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(65,'65','15','Katulani','Katulani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(66,'66','15','Matinyani','Matinyani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(67,'67','15','Tseikuru','Tseikuru','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(68,'68','15','Muumoni','Muumoni','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(69,'69','15','Migwani','Migwani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(70,'70','15','Mwingi East','Mwingi East','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(71,'71','15','Kyuso','Kyuso','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(72,'72','15','Mutomo','Mutomo','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(73,'73','15','Mwingi Central','Mwingi Central','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(74,'74','15','Kitui Central','Kitui Central','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(75,'75','15','Kitui West','Kitui West','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(76,'76','15','Kyuso','Kyuso','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(77,'77','16','Mwala','Mwala','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(78,'78','16','Yatta','Yatta','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(79,'79','16','Kangundo','Kangundo','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(80,'80','16','Kathiani','Kathiani','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(81,'81','16','Machakos','Machakos','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(82,'82','16','Masinga','Masinga','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(83,'83','16','Athi River','Athi River','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(84,'84','16','Matungulu','Matungulu','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(85,'85','17','Makueni','Makueni','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(86,'86','17','Mbooni East','Mbooni East','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(87,'87','17','Mbooni West','Mbooni West','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(88,'88','17','Mukaa ','Mukaa ','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(89,'89','17','Nzaui','Nzaui','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(90,'90','17','Makindu','Makindu','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(91,'91','17','Kathonzweni','Kathonzweni','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(92,'92','17','Kibwezi','Kibwezi','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(93,'93','17','Kilungu','Kilungu','0000-00-00 00:00:00','0000-00-00 00:00:00',3),(94,'94','18','Kipipiri','Kipipiri','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(95,'95','18','Kinangop','Kinangop','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(96,'96','18','Ol`kalou','Ol`kalou','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(97,'97','18','Ol`jorok ','Ol`jorok ','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(98,'98','18','Ndaragwa','Ndaragwa','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(99,'99','19','Nyeri central','Nyeri central','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(100,'100','19','Mathira West','Mathira West','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(101,'101','19','Nyeri South','Nyeri South','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(102,'102','19','Kieni West','Kieni West','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(103,'103','19','Kieni East','Kieni East','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(104,'104','19','Mathira East','Mathira East','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(105,'105','19','Tetu','Tetu','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(106,'106','19','Mukurweini','Mukurweini','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(107,'107','20','Kirinyaga Central','Kirinyaga Central','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(108,'108','20','Kirinyaga East','Kirinyaga East','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(109,'109','20','Mwea East','Mwea East','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(110,'110','20','Mwea West','Mwea West','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(111,'111','20','Kirinyaga west','Kirinyaga west','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(112,'112','21','Murang\'a  South','Murang\'a  South','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(113,'113','21','Gatanga','Gatanga','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(114,'114','21','Kandara','Kandara','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(115,'115','21','Kigumo','Kigumo','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(116,'116','21','Kiharu','Kiharu','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(117,'117','21','Mathioya','Mathioya','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(118,'118','21','Kangema','Kangema','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(119,'119','22','Ruiru','Ruiru','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(120,'120','22','Thika East','Thika East','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(121,'121','22','Thika West','Thika West','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(122,'122','22','Gatundu North','Gatundu North','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(123,'123','22','Githunguri','Githunguri','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(124,'124','22','Limuru','Limuru','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(125,'125','22','Kikuyu','Kikuyu','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(126,'126','22','Kiambu','Kiambu','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(127,'127','22','Gatundu South','Gatundu South','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(128,'128','22','Lari','Lari','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(129,'129','23','Loima','Loima','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(130,'130','23','Turkana Central','Turkana Central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(131,'131','23','Turkana East','Turkana East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(132,'132','23','Turkana North','Turkana North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(133,'133','23','Turkana South','Turkana South','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(134,'134','23','Turkana West','Turkana West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(135,'135','24','West pokot','West pokot','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(136,'136','24','North pokot','North pokot','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(137,'137','24','Pokot central','Pokot central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(138,'138','24','South Pokot','South Pokot','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(139,'139','25','Samburu West','Samburu West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(140,'140','25','Samburu East','Samburu East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(141,'141','25','Samburu North','Samburu North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(142,'142','26','Kwanza','Kwanza','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(143,'143','26','Trans-Nzoia East','Trans-Nzoia East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(144,'144','26','Trans-Nzoia West','Trans-Nzoia West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(145,'145','27','Turbo','Turbo','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(146,'146','27','Soy','Soy','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(147,'147','27','Moiben','Moiben','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(148,'148','27','Kessess','Kessess','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(149,'149','27','Kapseret','Kapseret','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(150,'150','27','Ainabkoi','Ainabkoi','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(151,'151','28','Keiyo South','Keiyo South','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(152,'152','28','Marakwet West','Marakwet West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(153,'153','28','Keiyo','Keiyo','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(154,'154','28','Marakwet East','Marakwet East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(155,'155','29','Emgwen Chesumei','Emgwen Chesumei','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(156,'156','29','Aldai','Aldai','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(157,'157','29','Mosop','Mosop','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(158,'158','29','Nandi hills','Nandi hills','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(159,'159','29','Tinderet','Tinderet','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(160,'160','30','Baringo central','Baringo central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(161,'161','30','Baringo North','Baringo North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(162,'162','30','East Pokot','East Pokot','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(163,'163','30','Koibatek','Koibatek','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(164,'164','30','Marigat','Marigat','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(165,'165','30','Mogotio','Mogotio','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(166,'166','31','Laikipia Central','Laikipia Central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(167,'167','31','Laikipia East','Laikipia East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(168,'168','31','Laikipia North','Laikipia North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(169,'169','31','Laikipia West','Laikipia West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(170,'170','31','Nyahururu','Nyahururu','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(171,'171','32','Kuresoi','Kuresoi','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(172,'172','32','Rongai','Rongai','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(173,'173','32','Subukia','Subukia','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(174,'174','32','Gilgil','Gilgil','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(175,'175','32','Molo','Molo','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(176,'176','32','Naivasha','Naivasha','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(177,'177','32','Nakuru','Nakuru','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(178,'178','32','Nakuru North','Nakuru North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(179,'179','32','Njoro','Njoro','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(180,'180','33','Narok North','Narok North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(181,'181','33','Narok South','Narok South','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(182,'182','33','Trans Mara','Trans Mara','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(183,'183','34','Kajiado North','Kajiado North','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(184,'184','34','Isinya','Isinya','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(185,'185','34','Mashuru','Mashuru','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(186,'186','34','Loitoktok','Loitoktok','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(187,'187','34','Kajiado central','Kajiado central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(188,'188','35','Bureti','Bureti','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(189,'189','35','Kipkelion West','Kipkelion West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(190,'190','35','Sigowet','Sigowet','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(191,'191','35','Kericho West','Kericho West','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(192,'192','35','Kericho East','Kericho East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(193,'193','35','Kipkelion East','Kipkelion East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(194,'194','36','Bomet Central','Bomet Central','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(195,'195','36',' Bomet East',' Bomet East','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(196,'196','36','Chepalungu','Chepalungu','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(197,'197','36','Sotik','Sotik','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(198,'198','36',' Konoin',' Konoin','0000-00-00 00:00:00','0000-00-00 00:00:00',7),(199,'199','37','Butere','Butere','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(200,'200','37','Kakamega central','Kakamega central','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(201,'201','37','Kakamega East','Kakamega East','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(202,'202','37','Khwisero','Khwisero','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(203,'203','37','Navakholo','Navakholo','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(204,'204','37','Matete','Matete','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(205,'205','37','Likuyani','Likuyani','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(206,'206','37','Matungu','Matungu','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(207,'207','37','Kakamega North','Kakamega North','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(208,'208','37','Kakamega South','Kakamega South','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(209,'209','37','Lugari','Lugari','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(210,'210','37','Mumias','Mumias','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(211,'211','38','Emuhaya','Emuhaya','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(212,'212','38','Hamisi','Hamisi','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(213,'213','38','Sabatia','Sabatia','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(214,'214','38','Luanda','Luanda','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(215,'215','38','Vihiga','Vihiga','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(216,'216','39','Mt.Elgon','Mt.Elgon','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(217,'217','39','Bungoma central','Bungoma central','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(218,'218','39','Webuye East','Webuye East','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(219,'219','39','Webuye west','Webuye west','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(220,'220','39','Bumula','Bumula','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(221,'221','39','Kimilili','Kimilili','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(222,'222','39','Bungoma North','Bungoma North','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(223,'223','39','Bungoma South','Bungoma South','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(224,'224','39','Bungoma West','Bungoma West','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(225,'225','40','Bunyala','Bunyala','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(226,'226','40','Nambale','Nambale','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(227,'227','40','Butula','Butula','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(228,'228','40','Busia','Busia','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(229,'229','40','Samia','Samia','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(230,'230','40','Teso North','Teso North','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(231,'231','40','Teso South','Teso South','0000-00-00 00:00:00','0000-00-00 00:00:00',8),(232,'232','41','Gem','Gem','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(233,'233','41','Ugenya','Ugenya','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(234,'234','41','Ugunja','Ugunja','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(235,'235','41','Bondo','Bondo','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(236,'236','41','Rarienda','Rarienda','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(237,'237','41','Siaya','Siaya','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(238,'238','42','Kisumu East','Kisumu East','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(239,'239','42','Kisumu West','Kisumu West','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(240,'240','42','Kisumu North','Kisumu North','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(241,'241','42','Muhoroni','Muhoroni','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(242,'242','42','Nyakach','Nyakach','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(243,'243','42','Nyando','Nyando','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(244,'244','43','Mbita','Mbita','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(245,'245','43','Ndhiwa','Ndhiwa','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(246,'246','43','Rachuonyo North','Rachuonyo North','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(247,'247','43','Rachuonyo South','Rachuonyo South','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(248,'248','43','Suba','Suba','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(249,'249','43','Homa Bay','Homa Bay','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(250,'250','44','Migori','Migori','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(251,'251','44','Nyatike','Nyatike','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(252,'252','44','Awendo','Awendo','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(253,'253','44','Rongo','Rongo','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(254,'254','44','Uriri','Uriri','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(255,'255','44','Kuria East','Kuria East','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(256,'256','44','Kuria West','Kuria West','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(257,'257','45','Nyamache','Nyamache','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(258,'258','45','South Gucha','South Gucha','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(259,'259','45','Masaba South','Masaba South','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(260,'260','45','Gucha','Gucha','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(261,'261','45','Sameta','Sameta','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(262,'262','45','Kisii central','Kisii central','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(263,'263','45','Kenyenya','Kenyenya','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(264,'264','45','Kisii South','Kisii South','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(265,'265','45','Marani','Marani','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(266,'266','46','Nyamira','Nyamira','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(267,'267','46','Nyamira North','Nyamira North','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(268,'268','46','Borabu','Borabu','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(269,'269','46','Manga','Manga','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(270,'270','46','North Masaba','North Masaba','0000-00-00 00:00:00','0000-00-00 00:00:00',6),(271,'271','47','Embakasi','Embakasi','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(272,'272','47','Dagoretti','Dagoretti','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(273,'273','47','Langata','Langata','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(274,'274','47','Westlands','Westlands','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(275,'275','47','Kamukunji','Kamukunji','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(276,'276','47','Kasarani','Kasarani','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(277,'277','47','Makandara','Makandara','0000-00-00 00:00:00','0000-00-00 00:00:00',4),(278,'278','47','Njiru','Njiru','0000-00-00 00:00:00','0000-00-00 00:00:00',4);
/*!40000 ALTER TABLE `district` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `documents`
--

DROP TABLE IF EXISTS `documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `documents` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `documentname` varchar(100) NOT NULL,
  `idno` varchar(50) NOT NULL,
  `category` varchar(100) NOT NULL,
  `name` text NOT NULL,
  `dateposted` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `entrydate` varchar(50) NOT NULL,
  `img_id` varchar(100) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `documents`
--

LOCK TABLES `documents` WRITE;
/*!40000 ALTER TABLE `documents` DISABLE KEYS */;
/*!40000 ALTER TABLE `documents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `events` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `fromdate` varchar(50) NOT NULL,
  `todate` varchar(50) NOT NULL,
  `host` varchar(100) NOT NULL,
  `participants` text NOT NULL,
  `location` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL DEFAULT 'new',
  `comments` text NOT NULL,
  `repeated` varchar(50) NOT NULL,
  `dateposted` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `expenses`
--

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expenses` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `user` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `datespent` varchar(50) NOT NULL,
  `receiptno` varchar(100) NOT NULL,
  `idno` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `imgid` varchar(100) NOT NULL,
  `img_id` text NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `accounttype` varchar(50) NOT NULL,
  `bankname` varchar(60) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  `paymentmethodes` varchar(30) NOT NULL,
  `duedate` varchar(30) NOT NULL,
  `terms` text NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `paid` decimal(10,2) NOT NULL,
  `updatedat` varchar(30) NOT NULL,
  `updatedby` int(11) NOT NULL,
  `branchid` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
/*!40000 ALTER TABLE `expenses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fingers`
--

DROP TABLE IF EXISTS `fingers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fingers` (
  `id` int(100) NOT NULL,
  `admno` varchar(200) NOT NULL,
  `fingername` varchar(50) NOT NULL,
  `regdate` varchar(100) NOT NULL,
  `template` text NOT NULL,
  `status` varchar(100) NOT NULL DEFAULT 'active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fingers`
--

LOCK TABLES `fingers` WRITE;
/*!40000 ALTER TABLE `fingers` DISABLE KEYS */;
/*!40000 ALTER TABLE `fingers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fiscalyear`
--

DROP TABLE IF EXISTS `fiscalyear`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fiscalyear` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'active',
  `startdate` datetime NOT NULL,
  `enddate` datetime NOT NULL,
  `companyid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `createdate` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fiscalyear`
--

LOCK TABLES `fiscalyear` WRITE;
/*!40000 ALTER TABLE `fiscalyear` DISABLE KEYS */;
INSERT INTO `fiscalyear` VALUES (1,'2019 Fiscal Year','active','2019-01-01 00:00:00','2019-12-31 23:59:00',1,1,'2019-01-10 16:34:14');
/*!40000 ALTER TABLE `fiscalyear` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `followups`
--

DROP TABLE IF EXISTS `followups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `followups` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `date` varchar(50) NOT NULL,
  `followupid` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `companyid` varchar(100) NOT NULL,
  `nextdate` varchar(30) NOT NULL,
  `feedback` text NOT NULL,
  `recommendation` text NOT NULL,
  `challanges` text NOT NULL,
  `level` varchar(50) NOT NULL,
  `branchid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `followups`
--

LOCK TABLES `followups` WRITE;
/*!40000 ALTER TABLE `followups` DISABLE KEYS */;
/*!40000 ALTER TABLE `followups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `glaccounts`
--

DROP TABLE IF EXISTS `glaccounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `glaccounts` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `accounttype` varchar(50) NOT NULL,
  `accountname` varchar(80) NOT NULL,
  `bankname` varchar(50) NOT NULL,
  `openingdate` varchar(50) NOT NULL,
  `description` int(11) NOT NULL,
  `accountstatus` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `number` text NOT NULL,
  `currency` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=149 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `glaccounts`
--

LOCK TABLES `glaccounts` WRITE;
/*!40000 ALTER TABLE `glaccounts` DISABLE KEYS */;
INSERT INTO `glaccounts` VALUES (30,'1','1','1','PETTY CASH','145','2018-07-20 13:23:56',1,'','-4255','2019-01-10 15:59:16','1000','1'),(31,'2','1','1','mpesa','','2018-07-20 13:24:37',1,'','0','2018-07-20 13:25:06pm','1010','KES'),(33,'1','1','1','Cash','','2018-07-20 13:25:48',1,'','0','2018-10-27 13:09:33','1030',''),(34,'1','1','6','Accounts receivable','','2018-07-20 13:26:42',1,'','155241','2018-10-20 19:08:17','1100',''),(35,'2','1','6','stock assets','','2018-07-20 13:29:27',1,'','0','2018-07-20 14:14:59pm','1110','KES'),(36,'2','1','6','checking account','','2018-07-20 14:14:59',1,'','0','2018-07-20 14:15:36pm','1120','KES'),(37,'2','1','6','tax assets','','2018-07-20 14:15:37',1,'','0','2018-07-20 14:17:00pm','1130','KES'),(38,'2','1','6','loans & advances','','2018-07-20 14:17:01',1,'','0','2018-07-20 14:18:41pm','1140','KES'),(39,'2','1','6','securities & deposits','','2018-07-20 14:18:42',1,'','0','2018-07-20 14:19:49pm','1150','KES'),(40,'2','1','6','allowance for doubtful accounts','','2018-07-20 14:19:50',1,'','0','2018-07-20 14:37:07pm','1160','KES'),(41,'2','1','6','prepaid expenses','','2018-07-20 14:37:09',1,'','0','2018-07-20 14:39:42pm','1170','KES'),(42,'2','1','6','allowance for bad debts','','2018-07-20 14:39:42',1,'','0','2018-07-20 14:40:52pm','1180','KES'),(43,'2','1','6','retainage','','2018-07-20 14:40:54',1,'','0','2018-07-20 14:42:01pm','1190','KES'),(44,'2','1','6','employee cash advances','','2018-07-20 14:42:02',1,'','0','2018-07-20 14:43:05pm','1200','KES'),(45,'2','1','7','land','','2018-07-20 14:43:05',1,'','0','2018-07-20 15:05:46pm','1500','KES'),(46,'2','1','7','vehicle','','2018-07-20 15:05:47',1,'','0','2018-07-20 15:06:35pm','1510','KES'),(47,'2','1','7','softwares','','2018-07-20 15:06:36',1,'','0','2018-07-20 15:07:37pm','1520','KES'),(48,'2','1','7','buildings','','2018-07-20 15:07:38',1,'','0','2018-07-20 15:09:20pm','1530','KES'),(49,'2','1','7','plants & machinery','','2018-07-20 15:09:21',1,'','0','2018-07-20 15:13:54pm','1540','KES'),(50,'2','1','7','office equipments','','2018-07-20 15:13:54',1,'','0','2018-07-20 15:18:16pm','1550','KES'),(51,'2','1','7','furnitures & fixtures','','2018-07-20 15:18:17',1,'','0','2018-07-20 15:20:12pm','1560','KES'),(52,'2','1','7','electronic equipments','','2018-07-20 15:20:15',1,'','0','2018-07-20 15:21:06pm','1570','KES'),(53,'2','1','7','depletable assets','','2018-07-20 15:21:07',1,'','0','2018-07-20 15:22:54pm','1580','KES'),(54,'2','1','7','leasehold improvements','','2018-07-20 15:22:55',1,'','0','2018-07-20 15:23:48pm','1590','KES'),(55,'2','1','7','accumulated depreciation','','2018-07-20 15:23:48',1,'','0','2018-07-20 15:32:37pm','1600','KES'),(56,'2','1','7','accumulated depletion','','2018-07-20 15:32:37',1,'','0','2018-07-20 15:43:54pm','1610','KES'),(57,'2','1','9','capital ','','2018-07-20 15:43:54',1,'','0','2018-07-20 16:02:41pm','1800','KES'),(58,'1','1','8','Inventory','','2018-07-20 16:02:41',1,'','0','2018-10-20 19:10:07','1850',''),(59,'2','1','8','stock of raw materials','','2018-07-20 16:04:29',1,'','0','2018-07-20 16:07:35pm','1860','KES'),(60,'2','1','8','stocks of work in progress','','2018-07-20 16:07:36',1,'','0','2018-07-20 16:09:03pm','1870','KES'),(61,'2','1','18','investment','','2018-07-20 16:10:02',0,'','0','2018-07-20 16:11:37pm','1900','KES'),(62,'2','1','20','temporary opening','','2018-07-20 16:11:39',0,'','0','2018-07-20 16:13:10pm','1950','KES'),(63,'2','1','14','loan payable','','2018-07-23 12:06:08',2,'','0','2018-07-23 12:33:49pm','2000','KES'),(64,'2','1','14','dividends payable','','2018-07-23 12:33:51',2,'','0','2018-07-23 12:35:15pm','2010','KES'),(65,'2','1','14','Income tax payable','','2018-07-23 12:35:15',2,'','0','2018-07-23 12:36:09pm','2020','KES'),(66,'2','1','14','accrued liabilities','','2018-07-23 12:36:09',2,'','0','2018-07-23 12:37:10pm','2030','KES'),(67,'2','1','14','payroll clearing','','2018-07-23 12:37:11',2,'','0','2018-07-23 12:37:57pm','2040','KES'),(68,'2','1','14','current tax liability','','2018-07-23 12:37:58',2,'','0','2018-07-23 12:38:54pm','2050','KES'),(69,'2','1','14','client trust accounts','','2018-07-23 12:38:55',2,'','0','2018-07-23 12:39:33pm','2060','KES'),(70,'2','1','14','insurance payable','','2018-07-23 12:39:33',2,'','0','2018-07-23 12:40:25pm','2070','KES'),(71,'2','1','14','rent payable','','2018-07-23 12:40:25',2,'','0','2018-07-23 12:40:57pm','2080','KES'),(72,'2','1','14','sales & services tax payable','','2018-07-23 12:40:58',2,'','0','2018-07-23 12:42:31pm','2090','KES'),(73,'2','1','14','prepaid expenses payable','','2018-07-23 12:42:32',2,'','0','2018-07-23 12:43:28pm','2100','KES'),(74,'2','1','14','line of credit','','2018-07-23 12:43:29',2,'','0','2018-07-23 12:44:38pm','2110','KES'),(75,'2','1','14','current portion of obligations under finance leases','','2018-07-23 12:44:39',2,'','0','2018-07-23 12:45:39pm','2120','KES'),(76,'2','1','15','long term debt','','2018-07-23 12:57:42',2,'','0','2018-07-23 12:58:56pm','2500','KES'),(78,'2','1','15','notes payable','','2018-07-23 13:00:31',2,'','0','2018-07-23 13:01:55pm','2510','KES'),(79,'2','1','15','liabilities related to assets held for sale','','2018-07-23 13:01:58',2,'','0','2018-07-23 13:02:45pm','2520','KES'),(80,'2','1','15','shareholder notes payable','','2018-07-23 13:02:46',2,'','0','2018-07-23 13:04:38pm','2530','KES'),(81,'2','1','15','accrued non-current liabilities','','2018-07-23 13:04:38',2,'','0','2018-07-23 13:15:06pm','2540','KES'),(82,'2','1','15','accrued holiday payable','','2018-07-23 13:15:07',2,'','0','2018-07-23 13:19:53pm','2550','KES'),(83,'2','1','26','ordinary shares','','2018-07-23 13:54:16',3,'','0','2018-07-23 13:55:37pm','3000','KES'),(84,'2','1','26','opening balance','','2018-07-23 13:55:37',3,'','0','2018-07-23 13:56:23pm','3010','KES'),(85,'2','1','26','partner contributions','','2018-07-23 13:56:29',3,'','0','2018-07-23 13:57:14pm','3020','KES'),(86,'2','1','26','share capital','','2018-07-23 13:57:15',3,'','0','2018-07-23 13:59:17pm','3030','KES'),(87,'2','1','26','capital stock','','2018-07-23 13:59:18',3,'','0','2018-07-23 14:00:06pm','3040','KES'),(88,'2','1','26','dividend disbursed','','2018-07-23 14:00:07',3,'','0','2018-07-23 14:01:50pm','3050','KES'),(89,'2','1','26','dividend disbursed','','2018-07-23 14:00:07',3,'','0','2018-07-23 14:05:14pm','3050','KES'),(90,'2','1','26','other comprehensive income','','2018-07-23 14:05:14',3,'','0','2018-07-23 14:06:04pm','3060','KES'),(91,'2','1','26','retained earnings','','2018-07-23 14:06:06',3,'','0','2018-07-23 14:06:41pm','3070','KES'),(92,'2','1','26','paid in capital','','2018-07-23 14:06:42',3,'','0','2018-07-23 14:08:06pm','3080','KES'),(93,'2','1','26','equity in earnings of subsidiaries','','2018-07-23 14:08:07',3,'','0','2018-07-23 14:09:00pm','3090','KES'),(94,'2','1','27','sales','','2018-07-23 14:09:01',4,'','328891','2018-07-23 14:09:37pm','4000','KES'),(95,'2','1','27','services','','2018-07-23 14:09:38',4,'','0','2018-07-23 14:10:07pm','4010','KES'),(96,'2','1','29','cost of goods sold','','2018-07-23 14:10:08',5,'','0','2018-07-23 14:26:19pm','5000','KES'),(97,'2','1','29','expenses included in valuation','','2018-07-23 14:26:28',5,'','0','2018-07-23 14:27:38pm','5010','KES'),(98,'2','1','29','stock adjustment','','2018-07-23 14:27:39',5,'','0','2018-07-23 14:28:38pm','5020','KES'),(99,'1','1','33','Purchases','','2018-07-23 14:28:40',5,'','8000','2018-10-27 12:41:59','5500',''),(100,'2','1','30','Transport','','2018-07-23 14:33:31',5,'','0','2018-07-23 14:33:50pm','5510','KES'),(101,'2','1','30','Rent','','2018-07-23 14:33:51',5,'','0','2018-07-23 14:34:22pm','5520','KES'),(102,'2','1','30','Electricity ','','2018-07-23 14:34:24',5,'','700','2018-07-23 14:34:49pm','5530','KES'),(103,'2','1','30','Advertisement','','2018-07-23 14:34:52',5,'','0','2018-07-23 14:35:40pm','5540','KES'),(104,'2','1','30','salary & wages','','2018-07-23 14:35:41',5,'','0','2018-07-23 14:36:41pm','5550','KES'),(105,'2','1','30','tips','','2018-07-23 14:36:42',5,'','0','2018-07-23 14:37:25pm','5560','KES'),(106,'2','1','30','lunch','','2018-07-23 14:37:26',5,'','0','2018-07-23 14:38:49pm','5570','KES'),(107,'2','1','30','Retreat','','2018-07-23 14:38:50',5,'','0','2018-07-23 14:39:29pm','5580','KES'),(108,'2','1','30','hardware','','2018-07-23 14:39:30',5,'','0','2018-07-23 14:41:23pm','5590','KES'),(109,'2','1','30','thermal rolls','','2018-07-23 14:41:24',5,'','0','2018-07-23 14:41:52pm','5600','KES'),(110,'2','1','30','water','','2018-07-23 14:41:52',5,'','0','2018-07-23 14:42:14pm','5610','KES'),(111,'2','1','30','Airtime','','2018-07-23 14:42:15',5,'','0','2018-07-23 14:43:31pm','5620','KES'),(112,'2','1','30','Ream','','2018-07-23 14:43:32',5,'','0','2018-07-23 14:45:51pm','5630','KES'),(113,'2','1','30','Advanta','','2018-07-23 14:45:52',5,'','0','2018-07-23 14:46:17pm','5640','KES'),(114,'2','1','30','Training','','2018-07-23 14:46:18',5,'','0','2018-07-23 14:47:45pm','5650','KES'),(115,'2','1','30','marketing expenses','','2018-07-23 14:47:47',5,'','0','2018-07-23 14:48:18pm','5660','KES'),(116,'2','1','30','sales expenses','','2018-07-23 14:48:21',5,'','0','2018-07-23 14:49:00pm','5670','KES'),(117,'2','1','30','Furniture & fixtures','','2018-07-23 14:49:01',5,'','0','2018-07-23 14:51:10pm','5680','KES'),(118,'2','1','30','Bid bond expenses','','2018-07-23 14:51:10',5,'','0','2018-07-23 14:54:25pm','5690','KES'),(119,'2','1','30','bank statement','','2018-07-23 14:54:26',5,'','0','2018-07-23 14:55:06pm','5700','KES'),(120,'2','1','30','tender expenses','','2018-07-23 14:55:12',5,'','0','2018-07-23 14:55:37pm','5710','KES'),(121,'2','1','30','cyber','','2018-07-23 14:55:39',5,'','0','2018-07-23 15:02:31pm','5720','KES'),(122,'2','1','30','printing & scanning','','2018-07-23 15:02:34',5,'','0','2018-07-23 15:03:40pm','5730','KES'),(123,'2','1','30','commission on sales','','2018-07-23 15:03:42',5,'','0','2018-07-23 15:04:44pm','5740','KES'),(124,'2','1','30','accomodation','','2018-07-23 15:04:46',5,'','0','2018-07-23 15:05:54pm','5750','KES'),(125,'2','1','30','Legal expenses','','2018-07-23 15:05:55',5,'','0','2018-07-23 15:06:58pm','5760','KES'),(126,'2','1','30','freight & forwarding charges','','2018-07-23 15:06:59',5,'','0','2018-07-23 15:07:42pm','5770','KES'),(127,'2','1','30','office maintenance','','2018-07-23 15:07:48',5,'','0','2018-07-23 15:08:19pm','5780','KES'),(128,'2','1','30','Depreciation','','2018-07-23 15:08:24',5,'','0','2018-07-23 15:08:47pm','5790','KES'),(129,'2','1','30','miscellaneous','','2018-07-23 15:09:39',5,'','2365','2018-07-23 15:10:10pm','5800','KES'),(130,'2','1','27','point of sale','','2018-07-23 15:10:10',4,'','0','2018-07-23 15:12:24pm','4020','KES'),(131,'2','1','27','bulk sms','','2018-07-23 15:12:25',4,'','0','2018-07-23 15:13:08pm','4030','KES'),(132,'2','1','27','property management','','2018-07-23 15:13:09',4,'','0','2018-07-23 15:13:38pm','4040','KES'),(133,'2','1','27','biometric system','','2018-07-23 15:13:41',4,'','0','2018-07-23 15:14:24pm','4050','KES'),(134,'2','1','27','school management','','2018-07-23 15:14:35',4,'','0','2018-07-23 15:15:12pm','4060','KES'),(135,'2','1','27','hospital management','','2018-07-23 15:15:15',4,'','0','2018-07-23 15:15:59pm','4070','KES'),(136,'2','1','27','website','','2018-07-23 15:16:03',4,'','0','2018-07-23 15:16:37pm','4080','KES'),(137,'2','1','27','pos upgrade','','2018-07-23 15:16:38',4,'','0','2018-07-23 15:17:17pm','4090','KES'),(139,'2','1','27','hardware','','2018-07-23 15:18:10',4,'','0','2018-07-23 15:18:55pm','4110','KES'),(140,'2','1','27','design','','2018-07-23 15:18:56',4,'','0','2018-07-23 15:19:38pm','4120','KES'),(141,'2','1','27','thermal rolls','','2018-07-23 15:19:38',4,'','0','2018-07-23 15:20:21pm','4130','KES'),(142,'2','1','27','bulk sms recharge','','2018-07-23 15:21:22',4,'','0','2018-07-23 15:21:46pm','4100','KES'),(143,'1','1','1','Airtel Money','147','2018-07-26 12:58:21',1,'','0','2018-10-20 15:13:20','1020',''),(144,'1','1','14','Account payable','','2018-08-02 10:41:16',2,'','8000','2019-01-14 22:59:51','2130',''),(145,'1','1','1','STANBIK bank','','2018-09-21 14:47:55',1,'','0','2018-10-17 09:30:49','1025',''),(146,'1','1','1','KCB account','','2018-10-04 10:01:06',1,'','173000','2018-10-04 10:01:53','1035','USD'),(147,'1','1','29','Food Expense','','2018-10-04 10:04:51',5,'','1240','2018-10-04 10:07:01','5005','KES'),(148,'1','1','1','EQUITY BANK','','2018-10-18 08:45:36',1,'','700','2018-10-18 08:47:41','1012','1');
/*!40000 ALTER TABLE `glaccounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `glgroups`
--

DROP TABLE IF EXISTS `glgroups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `glgroups` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `accounttype` varchar(50) NOT NULL,
  `accountname` varchar(80) NOT NULL,
  `groupname` varchar(50) NOT NULL,
  `openingdate` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `glgroups`
--

LOCK TABLES `glgroups` WRITE;
/*!40000 ALTER TABLE `glgroups` DISABLE KEYS */;
INSERT INTO `glgroups` VALUES (1,'2','1','1','Banks','',''),(6,'2','1','1','Current asset','',''),(7,'2','1','1','Fixed assets','',''),(8,'2','1','1','Inventory assets','',''),(9,'2','1','1','Capital asset','',''),(14,'2','1','2','Current liabilities','',''),(15,'2','1','2','Longterm liabilities','',''),(26,'2','1','3','Equity','',''),(27,'2','1','4','Direct income','',''),(28,'2','1','4','Indirect income','',''),(29,'2','1','5','Direct expenses','',''),(30,'2','1','5','Indirect expenses','',''),(31,'2','1','2','Share Capital','',''),(32,'2','1','2','Retained Earnings','',''),(33,'1','1','5','Cost of Sale','','');
/*!40000 ALTER TABLE `glgroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grouping`
--

DROP TABLE IF EXISTS `grouping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `grouping` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `memberid` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `user` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `updatedat` varchar(50) NOT NULL,
  `categoryid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grouping`
--

LOCK TABLES `grouping` WRITE;
/*!40000 ALTER TABLE `grouping` DISABLE KEYS */;
INSERT INTO `grouping` VALUES (1,'54','1','2018-08-02 06:17:14am','','1','','2','1');
/*!40000 ALTER TABLE `grouping` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `house`
--

DROP TABLE IF EXISTS `house`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `house` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `houseno` varchar(100) NOT NULL,
  `type` varchar(40) NOT NULL,
  `description` text NOT NULL,
  `plotno` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `floor` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `house`
--

LOCK TABLES `house` WRITE;
/*!40000 ALTER TABLE `house` DISABLE KEYS */;
/*!40000 ALTER TABLE `house` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images`
--

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `images` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `imageid` varchar(50) NOT NULL,
  `user` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images`
--

LOCK TABLES `images` WRITE;
/*!40000 ALTER TABLE `images` DISABLE KEYS */;
INSERT INTO `images` VALUES (1,'upload/430466_1459408027.12027543_10153697235844759_2342432607099399883_n.jpg','298',''),(2,'upload/120955_1459408674.1901129_10153697235929759_5008441071069083718_n.jpg','72','');
/*!40000 ALTER TABLE `images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice`
--

DROP TABLE IF EXISTS `invoice`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `plotno` varchar(60) NOT NULL,
  `houseno` varchar(40) NOT NULL,
  `tenantid` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `description` varchar(100) NOT NULL,
  `month` varchar(100) NOT NULL,
  `year` varchar(100) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `duedate` varchar(40) NOT NULL,
  `paymentstatus` varchar(40) NOT NULL,
  `paymentmode` varchar(40) NOT NULL,
  `paymentcode` varchar(100) NOT NULL,
  `transactioncode` varchar(100) NOT NULL,
  `approval` varchar(30) NOT NULL DEFAULT 'new',
  `approvedby` varchar(60) NOT NULL,
  `approvaldate` varchar(60) NOT NULL,
  `totalamount` varchar(40) NOT NULL,
  `paid` varchar(40) NOT NULL,
  `balance` varchar(40) NOT NULL DEFAULT '0',
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice`
--

LOCK TABLES `invoice` WRITE;
/*!40000 ALTER TABLE `invoice` DISABLE KEYS */;
/*!40000 ALTER TABLE `invoice` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `journal`
--

DROP TABLE IF EXISTS `journal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `journal` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `currency` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `journaldate` varchar(50) NOT NULL,
  `incharge` varchar(40) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `journal`
--

LOCK TABLES `journal` WRITE;
/*!40000 ALTER TABLE `journal` DISABLE KEYS */;
/*!40000 ALTER TABLE `journal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `landlord`
--

DROP TABLE IF EXISTS `landlord`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `landlord` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `idno` varchar(100) NOT NULL,
  `country` varchar(100) NOT NULL,
  `gender` varchar(10) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `county` varchar(40) NOT NULL,
  `accountname` varchar(100) NOT NULL,
  `accountno` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `landlord`
--

LOCK TABLES `landlord` WRITE;
/*!40000 ALTER TABLE `landlord` DISABLE KEYS */;
INSERT INTO `landlord` VALUES (1,'BRIAN','TITO','JUJA','254700832703','brianwarari@sphericsgeosystems.co.ke','','','1 ','','2018-09-11 05:46:53','2018-09-11 05:46:53','1','50 ','','','3','1'),(2,'OUKO','MANYALA','JUJA','254739430084','rmanyala@jkuat.ac.ke','','222222222','1 ','Female','2019-01-28 07:13:57','','1','47 ','Account payable','2222','1','1');
/*!40000 ALTER TABLE `landlord` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loggs`
--

DROP TABLE IF EXISTS `loggs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `loggs` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL,
  `userid` varchar(30) NOT NULL,
  `timein` varchar(50) NOT NULL,
  `timeout` varchar(50) NOT NULL,
  `browser` text NOT NULL,
  `ip` text NOT NULL,
  `action` varchar(30) DEFAULT 'loggedin',
  `companyid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loggs`
--

LOCK TABLES `loggs` WRITE;
/*!40000 ALTER TABLE `loggs` DISABLE KEYS */;
INSERT INTO `loggs` VALUES (1,'admin','1','2019-02-01 05:44:17','','','::1','loggedin',1),(2,'admin','1','2019-02-01 09:58:53','','','::1','loggedin',1),(3,'admin','1','2019-02-01 10:04:47','','','::1','loggedin',1),(4,'admin','1','2019-02-01 11:02:47','','','::1','loggedin',1),(5,'admin','1','2019-02-01 14:48:28','','','::1','loggedin',1),(6,'admin','1','2019-02-02 15:30:41','','','::1','loggedin',1),(7,'admin','1','2019-02-02 15:36:29','','','::1','loggedin',1),(8,'admin','1','2019-02-03 15:11:39','','','::1','loggedin',1),(9,'admin','1','2019-02-03 16:53:39','','','::1','loggedin',1),(10,'admin','1','2019-02-03 16:56:55','','','::1','loggedin',1),(11,'admin','1','2019-02-03 16:58:30','','','::1','loggedin',1),(12,'admin','1','2019-02-03 17:00:59','','','::1','loggedin',1),(13,'admin','1','2019-02-03 17:05:22','','','::1','loggedin',1),(14,'admin','1','2019-02-03 17:07:42','','','::1','loggedin',1),(15,'admin','1','2019-02-03 17:08:46','','','::1','loggedin',1),(16,'admin','1','2019-02-03 17:10:25','','','::1','loggedin',1),(17,'admin','1','2019-02-03 17:44:27','','','::1','loggedin',1),(18,'admin','1','2019-02-03 20:53:30','','','::1','loggedin',1),(19,'admin','1','2019-02-04 05:58:27','','','::1','loggedin',1),(20,'admin','1','2019-02-04 08:26:54','','','::1','loggedin',1),(21,'admin','1','2019-02-04 09:25:59','','','::1','loggedin',1),(22,'admin','1','2019-02-04 14:53:19','','','::1','loggedin',1),(23,'admin','1','2019-02-04 14:56:02','','','::1','loggedin',1),(24,'admin','1','2019-02-04 18:44:46','','','::1','loggedin',1),(25,'admin','1','2019-02-05 05:38:13','','','::1','loggedin',1),(26,'admin','1','2019-02-06 13:28:59','','','::1','loggedin',1),(27,'admin','1','2019-02-06 14:28:34','','','::1','loggedin',1),(28,'admin','1','2019-02-07 06:10:06','','','::1','loggedin',1),(29,'admin','1','2019-02-07 09:40:41','','','::1','loggedin',1),(30,'admin','1','2019-02-07 12:36:32','','','::1','loggedin',1),(31,'admin','1','2019-02-07 15:18:04','','','::1','loggedin',1),(32,'admin','1','2019-02-07 16:12:22','','','::1','loggedin',1),(33,'admin','1','2019-02-07 16:41:12','','','::1','loggedin',1),(34,'admin','1','2019-02-08 07:30:07','','','::1','loggedin',1),(35,'admin','1','2019-02-08 08:21:01','','','::1','loggedin',1),(36,'admin','1','2019-02-08 10:33:38','','','::1','loggedin',1),(37,'admin','1','2019-02-08 10:35:27','','','::1','loggedin',1),(38,'admin','1','2019-02-08 10:50:53','','','::1','loggedin',1),(39,'admin','1','2019-02-08 10:54:58','','','::1','loggedin',1),(40,'admin','1','2019-02-08 17:13:48','','','::1','loggedin',1),(41,'admin','1','2019-02-09 07:03:58','','','105.230.86.209','loggedin',1),(42,'admin','1','2019-02-09 07:22:38','','','105.230.86.209','loggedin',1),(43,'admin','1','2019-02-09 09:37:25','','','197.248.185.154','loggedin',1),(44,'admin','1','2019-02-09 09:58:37','','','197.248.185.154','loggedin',1),(45,'admin','1','2019-02-09 10:26:52','','','197.248.185.154','loggedin',1),(46,'admin','1','2019-02-09 10:27:44','','','197.248.185.154','loggedin',1),(47,'admin','1','2019-02-09 18:20:06','','','197.248.185.154','loggedin',1),(48,'admin','1','2019-02-09 18:20:08','','','197.248.185.154','loggedin',1),(49,'user','2','2019-02-09 18:22:21','','','197.248.185.154','loggedin',1),(50,'admin','1','2019-02-09 18:24:08','','','197.248.185.154','loggedin',1),(51,'user','2','2019-02-09 18:26:27','','','197.248.185.154','loggedin',1),(52,'user','2','2019-02-11 10:01:39','','','197.248.185.154','loggedin',1),(53,'user','2','2019-02-11 10:09:30','','','154.78.213.250','loggedin',1),(54,'user','2','2019-02-14 16:00:58','','','154.152.122.132','loggedin',1),(55,'user','2','2019-03-02 16:22:19','','','197.248.185.154','loggedin',1),(56,'user','2','2019-03-07 12:38:43','','','197.248.201.226','loggedin',1),(57,'admin','1','2019-03-14 10:23:27','','','154.70.62.228','loggedin',1),(58,'admin','1','2019-03-14 10:24:25','','','154.70.62.228','loggedin',1),(59,'admin','1','2019-03-14 10:30:07','','','154.70.62.228','loggedin',1),(60,'admin','1','2019-03-26 14:14:24','','','197.248.201.226','loggedin',1),(61,'admin','1','2019-03-30 14:44:09','','','197.248.201.226','loggedin',1),(62,'admin','1','2019-03-30 14:48:29','','','197.248.201.226','loggedin',1);
/*!40000 ALTER TABLE `loggs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loyalitycards`
--

DROP TABLE IF EXISTS `loyalitycards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `loyalitycards` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `value` decimal(23,2) NOT NULL,
  `customer_id` int(10) DEFAULT NULL,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `status` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(50) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `dateupdated` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `cardnumber` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `deleted` (`deleted`),
  KEY `phppos_giftcards_ibfk_1` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loyalitycards`
--

LOCK TABLES `loyalitycards` WRITE;
/*!40000 ALTER TABLE `loyalitycards` DISABLE KEYS */;
/*!40000 ALTER TABLE `loyalitycards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `maincategory`
--

DROP TABLE IF EXISTS `maincategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `maincategory` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `maincategory`
--

LOCK TABLES `maincategory` WRITE;
/*!40000 ALTER TABLE `maincategory` DISABLE KEYS */;
INSERT INTO `maincategory` VALUES (1,'HOTEL','','2019-01-05 09:23:04','active','1','','1'),(2,'OTHERS','','2019-01-02 13:53:48','active','1','','1');
/*!40000 ALTER TABLE `maincategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `message`
--

DROP TABLE IF EXISTS `message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `message`
--

LOCK TABLES `message` WRITE;
/*!40000 ALTER TABLE `message` DISABLE KEYS */;
INSERT INTO `message` VALUES (1,'2018 Fiscal Year','','2018-10-18 16:54:36','active','1','','1'),(3,'SOUP','SOUP','2018-07-17 08:49:34am','active','1','','1'),(4,'NO SOUP','','2018-07-17 10:04:46am','active','1','','1');
/*!40000 ALTER TABLE `message` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2016_07_02_112357_Product',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `modules`
--

DROP TABLE IF EXISTS `modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `modules` (
  `name` varchar(255) NOT NULL,
  `sort` int(10) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `id` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '1',
  `url` text NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'side',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name_lang_key` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modules`
--

LOCK TABLES `modules` WRITE;
/*!40000 ALTER TABLE `modules` DISABLE KEYS */;
INSERT INTO `modules` VALUES ('Accomodation',49,'money','accomodation','1','admin/viewpallmyplots','side'),('Accounting',50,'battery-quarter','accounting','1','user/accounting','side'),('Bank Deposits',35,'money','bankdeposits','1','user/viewbanks','side'),('Branch',81,'rss-square','branch','1','user/viewbranch','side'),('Call center',12,'rss-square','callcenter','1','user/callcenter','side'),('Cashier Sales',87,'folder-open','cashiersales','1','user/mysales','side'),('Complains',11,'paw','complain','1','user/complain','side'),('Configuration',5,'home','config','1','user/viewconfiguration','top'),('Damaged products',50,'paw','damagedproducts','1','user/viewdamages','side'),('Deals',11,'calendar-times-o','deals','1','user/viedeals','side'),('Display Counter',6,'rss-square','displaycounter','0','display','side'),('Display Sales Report',24,'folder-open','displayreport','1','user/displayreport','side'),('Documents',14,'folder-open-o','documents','1','user/viewdocuments','side'),('Events',10,'line-chart','events','1','user/viewevents','side'),('Grouping Members',20,'paper-plane','grouping','1','user/viewgrouping','side'),('Expenses/Income',40,'window-close','incomeexpenses','1','user/viewexpenses','side'),('Incoming stocklist/Store',60,'sort-amount-asc','incomingstock','1','user/viewincomingstock','side'),('Issued Store Items',59,'sort-amount-asc','incomingstore','1','user/viewallorder','side'),('Low Store',55,'battery-quarter','lowproducts','1','user/viewwarningproducts','side'),('Low stocklist',57,'battery-quarter','lowstocklist','1','user/viewlowstore','side'),('Loyality Cards',30,'credit-card','loyalitycards','1','user/viewloyality','side'),('People/Contacts',80,'rss-square','members','1','user/viewmember','side'),('Change password',9,'hourglass-start','password','1','user/passwordform','side'),(' Category of people',85,'address-book-o','peoplecategory','1','user/viewcategory','side'),('Print Receipt',1,'recycle','printreceipt','1','user/printreceipts','side'),('Stock List(Counter)',66,'snowflake-o','productlist','1','user/viewproductlist','side'),('Products(Main store)',65,'snowflake-o','products','1','user/viewproducts','side'),('Category of Products',70,'recycle','productscategory','1','user/viewproductcategory','side'),('Update profile',8,'blind','profile','1','user/profileform','side'),('Purchases',45,'automobile','purchases','1','user/viewpurchases','side'),('Manage Report',25,'folder-open','reports','1','user/startsales','side'),('sales',90,'cart-plus','sales','1','user/viewsales','side'),('Select User',1,'rss-square','selectuser','1','login','side'),('Send Sms',15,'paper-plane','sendsms','1','user/viewsms','side'),('Tasks',12,'bullseye','task','1','user/viewtasks','side'),('Tasks Category',13,'birthday-cake','taskscategory','1','user/viewtaskcategory','side'),('Users',75,'rss-square','users','1','user/viewemployee','side'),('Return/RePrint Sales',86,'paw','viewreturnsales','1','user/viewreturnsales','side'),('Whole sale',88,'cart-plus','wholesale','1','user/viewwholesales','side');
/*!40000 ALTER TABLE `modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `modulesactions`
--

DROP TABLE IF EXISTS `modulesactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `modulesactions` (
  `actionid` varchar(100) NOT NULL,
  `moduleid` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `sort` int(11) NOT NULL,
  PRIMARY KEY (`actionid`,`moduleid`),
  KEY `phppos_modules_actions_ibfk_1` (`moduleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `modulesactions`
--

LOCK TABLES `modulesactions` WRITE;
/*!40000 ALTER TABLE `modulesactions` DISABLE KEYS */;
INSERT INTO `modulesactions` VALUES ('add','bankdeposits','add',1),('add','branch','Add Baranch',1),('add','callcenter','Add Calls',1),('add','complain','Add complain',2),('add','config','add',1),('add','damagedproducts','add',1),('add','deals','add',1),('add','documents','add',1),('add','events','add',1),('add','grouping','add',1),('add','incomeexpenses','add',1),('add','incomingstock','add',1),('add','incomingstore','Add incoming',1),('add','lowproducts','add',1),('add','lowstocklist','add',6),('add','loyalitycards','add',1),('add','members','add',1),('add','peoplecategory','add',1),('add','productlist','Add Products',7),('add','products','add',1),('add','productscategory','add',1),('add','purchases','add',1),('add','sales','add',1),('add','sendsms','add',1),('add','task','add',1),('add','taskscategory','add',1),('add','users','add',1),('add','viewreturnsales','add',1),('add','wholesale','add',1),('adddailycollection','cashiersales','Add Daily Collection',7),('addstock','productlist','Add stock',4),('addstock','products','addstock',4),('all','cashiersales','View all Cashier sales',4),('allcompalin','complain','View Others Complain',11),('bulk','productlist','Upload bulk stock',1),('bulk','products','bulk',5),('card','sales','Card Sales',7),('cashiersales','cashiersales','View Sales',5),('change','password','change',1),('cheque','sales','Cheque/Bank sales',8),('clear','viewreturnsales','Clear Sales',5),('clearallsales','cashiersales','Clear all sales for others',10),('clearpayments','sales','Clear/Add payments',7),('closebill','sales',' Close Bill',6),('credit','sales','Credit sales',10),('creditnote','sales','Credit Note',8),('delete','bankdeposits','delete',3),('delete','branch','Delete Branch',5),('delete','callcenter','Delete calls',5),('delete','cashiersales','Delete Sales',4),('delete','complain','Delete Complain',11),('delete','config','delete',0),('delete','damagedproducts','delete',3),('delete','deals','delete',3),('delete','documents','delete',3),('delete','events','delete',3),('delete','grouping','delete',3),('delete','incomingstock','delete',3),('delete','incomingstore','Delete incoming',3),('delete','peoplecategory','delete',3),('delete','productlist','Delete Products',4),('delete','products','delete',3),('delete','productscategory','delete',3),('delete','purchases','delete',3),('delete','reports','Delete sales',3),('delete','sales','delete',3),('delete','sendsms','delete',3),('delete','task','delete',3),('delete','taskscategory','delete',3),('delete','users','delete',3),('delete','viewreturnsales','delete',3),('delete','wholesale','delete',2),('deleteallroles','users','Delete all Roles',5),('deletebank','accounting','Delete Bank Account',2),('deletedailycollections','cashiersales','Delete Daily Collections',9),('deleteglaccount','accounting','Delete GL Account',4),('deleteorder','products','Delete Order',5),('discount','sales','Print Discount',5),('dispatch','products','Dispatch Products',6),('displaycustomers','sales','Display customers using buttons',5),('dontprint','sales','Display Dont Print Button',15),('download','reports','download',2),('editmpesa','cashiersales','Enter Mpesa Amount Directly',3),('editmpesadate','cashiersales','Edit Mpesa Entry date',5),('editopenclosestock','productlist','Update Closing and Opening stock',10),('editsellingprice','sales','Change Selling Price',7),('editstocktaken','productlist','Change closed and stock taken',9),('entermpesacode','cashiersales','Enter Mpesa Code',3),('Logout','sales','Log out After printing',5),('more','lowstocklist','View more',6),('more','productlist','View Added stock',2),('more','products','more',4),('moresales','viewreturnsales','Add more Sales',5),('mpesa','sales','Sale in Mpesa',6),('mpesabalance','sales','View Mpesa Balance',5),('mpesapendingreport','cashiersales','View All Pending Mpesa Report',20),('mpesaverifiedreport','cashiersales','View All Verified Mpesa Report',21),('openclosestock','productlist','Open and Close stock',8),('order','sales','User Order Button',6),('points','sales','Loyality Point sales',9),('price','products','change price',7),('printbill','sales',' Print Bill',6),('productcode','config','Display Product code in receipt',5),('productdiscount','sales','Give discount Product',6),('removeallstock','products','View all outgoing stock',7),('removestock','products','Move consumable stock',6),('reprint','sales','Reprint Receipt',5),('return','viewreturnsales','Return Sales',4),('reversempesa','cashiersales','Reverse Mpesa',9),('sale','sales','sale',4),('sale','wholesale','sale',0),('select','sales','Select Customers',5),('stocktaking','productlist','Do stock Taking',8),('transfer','productlist','Transfer Products',3),('upadate','callcenter','Update',2),('update','bankdeposits','update',2),('update','branch','Update Branch',3),('update','complain','Update Complain',6),('update','config','update',2),('update','damagedproducts','update',2),('update','deals','update',2),('update','documents','update',2),('update','events','update',2),('update','grouping','update',2),('update','incomeexpenses','update',3),('update','incomingstock','update',2),('update','lowproducts','update',1),('update','loyalitycards','update',2),('update','members','update',2),('update','peoplecategory','update',2),('update','productlist','Update Product',6),('update','products','update',2),('update','productscategory','update',2),('update','profile','update',1),('update','purchases','update',2),('update','reports','update sales',4),('update','sales','update',2),('update','sendsms','update',2),('update','task','update',2),('update','taskscategory','update',2),('update','users','update',2),('update','viewreturnsales','update',2),('update','wholesale','update',4),('updatebuyingprice','purchases','update buying price',4),('updateclosedinvoice','purchases','update closed invoice',6),('updatedailycollections','cashiersales','Update Daily Collection',9),('updatepaymentmode','sales','Update Payment Mode',7),('updatesellingprice','purchases','update selling price',5),('view','branch','View Branch',2),('view','callcenter','View Calls',3),('view','complain','View Complain',5),('view','displayreport','Display Report',1),('view','incomingstock','View Incoming store products',2),('view','incomingstore','View Incoming store products',4),('view','lowstocklist','View',6),('view','productlist','View Products',5),('view','reports','view',1),('View Accounting','accounting','view',1),('viewall','deals','View other people\'s deals',5),('viewall','reports','View all Branches',6),('viewall','task','View other people\'s tasks',2),('viewbuyingprice','sales','view buying price',7),('viewdailycollections','cashiersales','View Daily Collection',8),('viewrooms','accomodation','View All Rooms',1),('voucher','sales','Gift Voucher sales',9);
/*!40000 ALTER TABLE `modulesactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `moneydocuments`
--

DROP TABLE IF EXISTS `moneydocuments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `moneydocuments` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `imageid` varchar(50) NOT NULL,
  `user` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `moneydocuments`
--

LOCK TABLES `moneydocuments` WRITE;
/*!40000 ALTER TABLE `moneydocuments` DISABLE KEYS */;
/*!40000 ALTER TABLE `moneydocuments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mpesasales`
--

DROP TABLE IF EXISTS `mpesasales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mpesasales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` decimal(10,2) NOT NULL,
  `userid` int(20) NOT NULL,
  `companyid` int(5) NOT NULL,
  `dateposted` varchar(30) NOT NULL,
  `paymentstatus` varchar(10) NOT NULL,
  `branch` int(10) NOT NULL,
  `type` varchar(30) NOT NULL,
  `code` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mpesasales`
--

LOCK TABLES `mpesasales` WRITE;
/*!40000 ALTER TABLE `mpesasales` DISABLE KEYS */;
INSERT INTO `mpesasales` VALUES (1,580.00,1,1,'2019-01-07 15:55:08','1',1,'1','MLM0OZXA2Q'),(2,1100.00,1,1,'2019-02-01 15:16:14','1',1,'1','MH44VQCZZK');
/*!40000 ALTER TABLE `mpesasales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nation`
--

DROP TABLE IF EXISTS `nation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `nation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(2) NOT NULL DEFAULT '',
  `name` varchar(100) NOT NULL DEFAULT '',
  `description` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nation`
--

LOCK TABLES `nation` WRITE;
/*!40000 ALTER TABLE `nation` DISABLE KEYS */;
INSERT INTO `nation` VALUES (1,'KE','Kenya',''),(2,'CA','Canada',''),(3,'AF','Afghanistan',''),(4,'AL','Albania',''),(5,'DZ','Algeria',''),(6,'DS','American Samoa',''),(7,'AD','Andorra',''),(8,'AO','Angola',''),(9,'AI','Anguilla',''),(10,'AQ','Antarctica',''),(11,'AG','Antigua and/or Barbuda',''),(12,'AR','Argentina',''),(13,'AM','Armenia',''),(14,'AW','Aruba',''),(15,'AU','Australia',''),(16,'AT','Austria',''),(17,'AZ','Azerbaijan',''),(18,'BS','Bahamas',''),(19,'BH','Bahrain',''),(20,'BD','Bangladesh',''),(21,'BB','Barbados',''),(22,'BY','Belarus',''),(23,'BE','Belgium',''),(24,'BZ','Belize',''),(25,'BJ','Benin',''),(26,'BM','Bermuda',''),(27,'BT','Bhutan',''),(28,'BO','Bolivia',''),(29,'BA','Bosnia and Herzegovina',''),(30,'BW','Botswana',''),(31,'BV','Bouvet Island',''),(32,'BR','Brazil',''),(33,'IO','British lndian Ocean Territory',''),(34,'BN','Brunei Darussalam',''),(35,'BG','Bulgaria',''),(36,'BF','Burkina Faso',''),(37,'BI','Burundi',''),(38,'KH','Cambodia',''),(39,'CM','Cameroon',''),(40,'CV','Cape Verde',''),(41,'KY','Cayman Islands',''),(42,'CF','Central African Republic',''),(43,'TD','Chad',''),(44,'CL','Chile',''),(45,'CN','China',''),(46,'CX','Christmas Island',''),(47,'CC','Cocos (Keeling) Islands',''),(48,'CO','Colombia',''),(49,'KM','Comoros',''),(50,'CG','Congo',''),(51,'CK','Cook Islands',''),(52,'CR','Costa Rica',''),(53,'HR','Croatia (Hrvatska)',''),(54,'CU','Cuba',''),(55,'CY','Cyprus',''),(56,'CZ','Czech Republic',''),(57,'DK','Denmark',''),(58,'DJ','Djibouti',''),(59,'DM','Dominica',''),(60,'DO','Dominican Republic',''),(61,'TP','East Timor',''),(62,'EC','Ecuador',''),(63,'EG','Egypt',''),(64,'SV','El Salvador',''),(65,'GQ','Equatorial Guinea',''),(66,'ER','Eritrea',''),(67,'EE','Estonia',''),(68,'ET','Ethiopia',''),(69,'FK','Falkland Islands (Malvinas)',''),(70,'FO','Faroe Islands',''),(71,'FJ','Fiji',''),(72,'FI','Finland',''),(73,'FR','France',''),(74,'FX','France, Metropolitan',''),(75,'GF','French Guiana',''),(76,'PF','French Polynesia',''),(77,'TF','French Southern Territories',''),(78,'GA','Gabon',''),(79,'GM','Gambia',''),(80,'GE','Georgia',''),(81,'DE','Germany',''),(82,'GH','Ghana',''),(83,'GI','Gibraltar',''),(84,'GR','Greece',''),(85,'GL','Greenland',''),(86,'GD','Grenada',''),(87,'GP','Guadeloupe',''),(88,'GU','Guam',''),(89,'GT','Guatemala',''),(90,'GN','Guinea',''),(91,'GW','Guinea-Bissau',''),(92,'GY','Guyana',''),(93,'HT','Haiti',''),(94,'HM','Heard and Mc Donald Islands',''),(95,'HN','Honduras',''),(96,'HK','Hong Kong',''),(97,'HU','Hungary',''),(98,'IS','Iceland',''),(99,'IN','India',''),(100,'ID','Indonesia',''),(101,'IR','Iran (Islamic Republic of)',''),(102,'IQ','Iraq',''),(103,'IE','Ireland',''),(104,'IL','Israel',''),(105,'IT','Italy',''),(106,'CI','Ivory Coast',''),(107,'JM','Jamaica',''),(108,'JP','Japan',''),(109,'JO','Jordan',''),(110,'KZ','Kazakhstan',''),(111,'US','United States ',''),(112,'KI','Kiribati',''),(113,'KP','Korea, Democratic People\'s Republic of',''),(114,'KR','Korea, Republic of',''),(115,'XK','Kosovo',''),(116,'KW','Kuwait',''),(117,'KG','Kyrgyzstan',''),(118,'LA','Lao People\'s Democratic Republic',''),(119,'LV','Latvia',''),(120,'LB','Lebanon',''),(121,'LS','Lesotho',''),(122,'LR','Liberia',''),(123,'LY','Libyan Arab Jamahiriya',''),(124,'LI','Liechtenstein',''),(125,'LT','Lithuania',''),(126,'LU','Luxembourg',''),(127,'MO','Macau',''),(128,'MK','Macedonia',''),(129,'MG','Madagascar',''),(130,'MW','Malawi',''),(131,'MY','Malaysia',''),(132,'MV','Maldives',''),(133,'ML','Mali',''),(134,'MT','Malta',''),(135,'MH','Marshall Islands',''),(136,'MQ','Martinique',''),(137,'MR','Mauritania',''),(138,'MU','Mauritius',''),(139,'TY','Mayotte',''),(140,'MX','Mexico',''),(141,'FM','Micronesia, Federated States of',''),(142,'MD','Moldova, Republic of',''),(143,'MC','Monaco',''),(144,'MN','Mongolia',''),(145,'ME','Montenegro',''),(146,'MS','Montserrat',''),(147,'MA','Morocco',''),(148,'MZ','Mozambique',''),(149,'MM','Myanmar',''),(150,'NA','Namibia',''),(151,'NR','Nauru',''),(152,'NP','Nepal',''),(153,'NL','Netherlands',''),(154,'AN','Netherlands Antilles',''),(155,'NC','New Caledonia',''),(156,'NZ','New Zealand',''),(157,'NI','Nicaragua',''),(158,'NE','Niger',''),(159,'NG','Nigeria',''),(160,'NU','Niue',''),(161,'NF','Norfork Island',''),(162,'MP','Northern Mariana Islands',''),(163,'NO','Norway',''),(164,'OM','Oman',''),(165,'PK','Pakistan',''),(166,'PW','Palau',''),(167,'PA','Panama',''),(168,'PG','Papua New Guinea',''),(169,'PY','Paraguay',''),(170,'PE','Peru',''),(171,'PH','Philippines',''),(172,'PN','Pitcairn',''),(173,'PL','Poland',''),(174,'PT','Portugal',''),(175,'PR','Puerto Rico',''),(176,'QA','Qatar',''),(177,'RE','Reunion',''),(178,'RO','Romania',''),(179,'RU','Russian Federation',''),(180,'RW','Rwanda',''),(181,'KN','Saint Kitts and Nevis',''),(182,'LC','Saint Lucia',''),(183,'VC','Saint Vincent and the Grenadines',''),(184,'WS','Samoa',''),(185,'SM','San Marino',''),(186,'ST','Sao Tome and Principe',''),(187,'SA','Saudi Arabia',''),(188,'SN','Senegal',''),(189,'RS','Serbia',''),(190,'SC','Seychelles',''),(191,'SL','Sierra Leone',''),(192,'SG','Singapore',''),(193,'SK','Slovakia',''),(194,'SI','Slovenia',''),(195,'SB','Solomon Islands',''),(196,'SO','Somalia',''),(197,'ZA','South Africa',''),(198,'GS','South Georgia South Sandwich Islands',''),(199,'ES','Spain',''),(200,'LK','Sri Lanka',''),(201,'SH','St. Helena',''),(202,'PM','St. Pierre and Miquelon',''),(203,'SD','Sudan',''),(204,'SR','Suriname',''),(205,'SJ','Svalbarn and Jan Mayen Islands',''),(206,'SZ','Swaziland',''),(207,'SE','Sweden',''),(208,'CH','Switzerland',''),(209,'SY','Syrian Arab Republic',''),(210,'TW','Taiwan',''),(211,'TJ','Tajikistan',''),(212,'TZ','Tanzania, United Republic of',''),(213,'TH','Thailand',''),(214,'TG','Togo',''),(215,'TK','Tokelau',''),(216,'TO','Tonga',''),(217,'TT','Trinidad and Tobago',''),(218,'TN','Tunisia',''),(219,'TR','Turkey',''),(220,'TM','Turkmenistan',''),(221,'TC','Turks and Caicos Islands',''),(222,'TV','Tuvalu',''),(223,'UG','Uganda',''),(224,'UA','Ukraine',''),(225,'AE','United Arab Emirates',''),(226,'GB','United Kingdom',''),(227,'UM','United States minor outlying islands',''),(228,'UY','Uruguay',''),(229,'UZ','Uzbekistan',''),(230,'VU','Vanuatu',''),(231,'VA','Vatican City State',''),(232,'VE','Venezuela',''),(233,'VN','Vietnam',''),(234,'VG','Virigan Islands (British)',''),(235,'VI','Virgin Islands (U.S.)',''),(236,'WF','Wallis and Futuna Islands',''),(237,'EH','Western Sahara',''),(238,'YE','Yemen',''),(239,'YU','Yugoslavia',''),(240,'ZR','Zaire',''),(241,'ZM','Zambia',''),(242,'ZW','Zimbabwe',''),(243,'','ugali','			\r\n');
/*!40000 ALTER TABLE `nation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `newstock`
--

DROP TABLE IF EXISTS `newstock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `newstock` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `date` varchar(50) NOT NULL,
  `item_id1` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `companyid` varchar(100) NOT NULL,
  `invoice_number` varchar(30) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `buyingprice` decimal(10,2) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT '1',
  `balance` varchar(30) NOT NULL,
  `stockfrom` varchar(50) NOT NULL,
  `stockto` varchar(30) NOT NULL,
  `item_id` varchar(30) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  `discount` varchar(10) NOT NULL,
  `tax` varchar(30) NOT NULL,
  `qty` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `newstock`
--

LOCK TABLES `newstock` WRITE;
/*!40000 ALTER TABLE `newstock` DISABLE KEYS */;
INSERT INTO `newstock` VALUES (1,'STAND PIPE 1/2 3FT','',20.00,'2019-02-01 14:53:49','','1','newstock','1','','',0.00,'','1','','supplier','Branch','1012','','','',0.00),(2,'','1',7.00,'2019-02-01 14:58:15','','1','newstock','1','45566','multiple',80.00,'','1','','','','136','','','',0.00),(3,'','1',1.00,'2019-02-01 14:58:20','','1','newstock','1','45566','multiple',590.00,'','1','','','','410','','','',0.00),(4,'','1',10.00,'2019-02-01 14:58:26','','1','newstock','1','45566','multiple',34.50,'','1','','','','407','','','',0.00),(5,'KENYA CANE 750ML','',5.00,'2019-02-07 06:59:38','','1','newstock','1','','',0.00,'','1','','internal','Branch','35','','','',0.00),(6,'KENYA CANE 375ML','',20.00,'2019-02-07 06:59:55','','1','newstock','1','','',0.00,'','1','','internal','Branch','36','','','',0.00);
/*!40000 ALTER TABLE `newstock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orderlist`
--

DROP TABLE IF EXISTS `orderlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `orderlist` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL,
  `userid` varchar(30) NOT NULL,
  `exactime` varchar(50) NOT NULL,
  `batchid` varchar(50) NOT NULL,
  `itemid` varchar(30) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  `qty` decimal(10,2) DEFAULT NULL,
  `companyid` int(11) NOT NULL,
  `branchid` int(11) NOT NULL,
  `code` varchar(30) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orderlist`
--

LOCK TABLES `orderlist` WRITE;
/*!40000 ALTER TABLE `orderlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `orderlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `outgoingstock`
--

DROP TABLE IF EXISTS `outgoingstock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `outgoingstock` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `total` varchar(50) NOT NULL,
  `date` varchar(50) NOT NULL,
  `item_id` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `companyid` varchar(100) NOT NULL,
  `invoice_number` varchar(30) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `buyingprice` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'shop',
  `comments` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `outgoingstock`
--

LOCK TABLES `outgoingstock` WRITE;
/*!40000 ALTER TABLE `outgoingstock` DISABLE KEYS */;
/*!40000 ALTER TABLE `outgoingstock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
INSERT INTO `password_resets` VALUES ('rmanyala@jkuat.ac.ke','55addf31b644939f3e4e858a70d3fe997eeef74149f54eca8e593f9c077becea','2016-07-02 02:47:19');
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paymentmethodes`
--

DROP TABLE IF EXISTS `paymentmethodes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `paymentmethodes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'active',
  `dateposted` varchar(30) NOT NULL,
  `userid` varchar(30) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  `type` text NOT NULL,
  `balance` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paymentmethodes`
--

LOCK TABLES `paymentmethodes` WRITE;
/*!40000 ALTER TABLE `paymentmethodes` DISABLE KEYS */;
INSERT INTO `paymentmethodes` VALUES (1,'MOBILE MONEY','','active','2018-03-24 04:57:04am','1','1','',''),(2,'MPESA','MPESA','active','2018-03-24 04:57:18am','1','1','1',''),(3,'CASH','','active','2018-03-24 04:59:50am','1','1','',''),(4,'BANK','BANK','active','2018-03-24 05:00:12am','1','1','',''),(5,'card','','active','2018-03-26 14:34:44pm','1','1','','');
/*!40000 ALTER TABLE `paymentmethodes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `paidto` varchar(100) NOT NULL,
  `paiby` varchar(100) NOT NULL,
  `paiddate` varchar(100) NOT NULL,
  `todate` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `approvedby` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `receiptno` varchar(100) NOT NULL DEFAULT 'no',
  `comments` text NOT NULL,
  `idno` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `payroll`
--

DROP TABLE IF EXISTS `payroll`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payroll` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `designation` varchar(255) NOT NULL,
  `allowance` varchar(255) NOT NULL,
  `paytype` varchar(255) NOT NULL,
  `nohours` varchar(255) NOT NULL,
  `salary` varchar(255) NOT NULL,
  `nodays` varchar(255) NOT NULL,
  `nodaysyearly` varchar(255) NOT NULL,
  `annualsalary` varchar(255) NOT NULL,
  `monthlysalary` varchar(50) NOT NULL,
  `dailysalary` varchar(100) DEFAULT NULL,
  `comments` text NOT NULL,
  `vat` varchar(50) NOT NULL DEFAULT 'active',
  `payee` varchar(50) NOT NULL,
  `nssf` varchar(100) NOT NULL,
  `nihf` text NOT NULL,
  `employeeid` varchar(100) NOT NULL,
  `advance` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `other` varchar(50) NOT NULL,
  `month` varchar(50) NOT NULL,
  `year` varchar(50) NOT NULL,
  `loan` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `first_name` (`type`),
  KEY `last_name` (`designation`),
  KEY `email` (`paytype`),
  KEY `phppos_people_ibfk_1` (`dailysalary`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payroll`
--

LOCK TABLES `payroll` WRITE;
/*!40000 ALTER TABLE `payroll` DISABLE KEYS */;
/*!40000 ALTER TABLE `payroll` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `people`
--

DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address_1` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `comments` text NOT NULL,
  `image_id` varchar(100) DEFAULT NULL,
  `category` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `company` varchar(50) NOT NULL,
  `account` varchar(100) NOT NULL,
  `website` text NOT NULL,
  `idno` varchar(100) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `first_name` (`firstname`),
  KEY `last_name` (`lastname`),
  KEY `email` (`email`),
  KEY `phppos_people_ibfk_1` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `people`
--

LOCK TABLES `people` WRITE;
/*!40000 ALTER TABLE `people` DISABLE KEYS */;
INSERT INTO `people` VALUES (1,'were','','123456','','','male','','','1','',NULL,'member','1','were','','','',0.00,'1','2019-02-01 10:07:48','','1',''),(2,'default','','default','','','male','','','1','',NULL,'supplier','1','default','','','',0.00,'1','2019-02-01 14:57:28','','1','');
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `moduleid` varchar(100) NOT NULL,
  `userid` int(10) NOT NULL,
  PRIMARY KEY (`moduleid`,`userid`),
  KEY `person_id` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES ('accomodation',1),('accomodation',2),('accounting',1),('accounting',2),('bankdeposits',1),('bankdeposits',2),('branch',1),('branch',2),('callcenter',1),('callcenter',2),('cashiersales',1),('cashiersales',2),('complain',1),('complain',2),('config',1),('damagedproducts',1),('damagedproducts',2),('deals',1),('deals',2),('displayreport',1),('displayreport',2),('documents',1),('documents',2),('events',1),('events',2),('grouping',1),('grouping',2),('incomeexpenses',1),('incomeexpenses',2),('incomingstock',1),('incomingstock',2),('incomingstore',1),('incomingstore',2),('lowproducts',1),('lowproducts',2),('lowstocklist',1),('lowstocklist',2),('loyalitycards',1),('loyalitycards',2),('members',1),('members',2),('password',1),('password',2),('password',20),('peoplecategory',1),('peoplecategory',2),('productlist',1),('productlist',2),('products',1),('products',2),('productscategory',1),('productscategory',2),('profile',1),('purchases',1),('purchases',2),('reports',1),('reports',2),('sales',1),('sales',2),('sales',20),('sendsms',1),('sendsms',2),('task',1),('task',2),('taskscategory',1),('taskscategory',2),('users',1),('users',2),('viewreturnsales',1),('viewreturnsales',2),('wholesale',1),('wholesale',2);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissionsactions`
--

DROP TABLE IF EXISTS `permissionsactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissionsactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `moduleid` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `actionid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3491 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissionsactions`
--

LOCK TABLES `permissionsactions` WRITE;
/*!40000 ALTER TABLE `permissionsactions` DISABLE KEYS */;
INSERT INTO `permissionsactions` VALUES (2311,'sales','20','add'),(2312,'sales','20','update'),(2313,'sales','20','delete'),(2314,'sales','20','sale'),(2315,'sales','20','mpesabalance'),(2316,'sales','20','displaycustomers'),(2317,'sales','20','discount'),(2318,'sales','20','Logout'),(2319,'sales','20','reprint'),(2320,'sales','20','select'),(2321,'sales','20','productdiscount'),(2322,'sales','20','order'),(2323,'sales','20','printbill'),(2324,'sales','20','mpesa'),(2325,'sales','20','closebill'),(2326,'sales','20','editsellingprice'),(2327,'sales','20','viewbuyingprice'),(2328,'sales','20','updatepaymentmode'),(2329,'sales','20','card'),(2330,'sales','20','clearpayments'),(2331,'sales','20','cheque'),(2332,'sales','20','creditnote'),(2333,'sales','20','points'),(2334,'sales','20','voucher'),(2335,'sales','20','credit'),(2336,'sales','20','dontprint'),(2337,'password','20','change'),(3169,'sales','1','add'),(3170,'sales','1','update'),(3171,'sales','1','delete'),(3172,'sales','1','sale'),(3173,'sales','1','mpesabalance'),(3174,'sales','1','displaycustomers'),(3175,'sales','1','discount'),(3176,'sales','1','Logout'),(3177,'sales','1','reprint'),(3178,'sales','1','select'),(3179,'sales','1','productdiscount'),(3180,'sales','1','order'),(3181,'sales','1','printbill'),(3182,'sales','1','mpesa'),(3183,'sales','1','closebill'),(3184,'sales','1','editsellingprice'),(3185,'sales','1','viewbuyingprice'),(3186,'sales','1','updatepaymentmode'),(3187,'sales','1','card'),(3188,'sales','1','clearpayments'),(3189,'sales','1','cheque'),(3190,'sales','1','creditnote'),(3191,'sales','1','points'),(3192,'sales','1','voucher'),(3193,'sales','1','credit'),(3194,'sales','1','dontprint'),(3195,'wholesale','1','sale'),(3196,'wholesale','1','add'),(3197,'wholesale','1','delete'),(3198,'wholesale','1','update'),(3199,'cashiersales','1','entermpesacode'),(3200,'cashiersales','1','editmpesa'),(3201,'cashiersales','1','all'),(3202,'cashiersales','1','delete'),(3203,'cashiersales','1','editmpesadate'),(3204,'cashiersales','1','cashiersales'),(3205,'cashiersales','1','adddailycollection'),(3206,'cashiersales','1','viewdailycollections'),(3207,'cashiersales','1','deletedailycollections'),(3208,'cashiersales','1','reversempesa'),(3209,'cashiersales','1','updatedailycollections'),(3210,'cashiersales','1','clearallsales'),(3211,'cashiersales','1','mpesapendingreport'),(3212,'cashiersales','1','mpesaverifiedreport'),(3213,'viewreturnsales','1','add'),(3214,'viewreturnsales','1','update'),(3215,'viewreturnsales','1','delete'),(3216,'viewreturnsales','1','return'),(3217,'viewreturnsales','1','clear'),(3218,'viewreturnsales','1','moresales'),(3219,'peoplecategory','1','add'),(3220,'peoplecategory','1','update'),(3221,'peoplecategory','1','delete'),(3222,'branch','1','add'),(3223,'branch','1','view'),(3224,'branch','1','update'),(3225,'branch','1','delete'),(3226,'members','1','add'),(3227,'members','1','update'),(3228,'users','1','add'),(3229,'users','1','update'),(3230,'users','1','delete'),(3231,'users','1','deleteallroles'),(3232,'productscategory','1','add'),(3233,'productscategory','1','update'),(3234,'productscategory','1','delete'),(3235,'productlist','1','bulk'),(3236,'productlist','1','more'),(3237,'productlist','1','transfer'),(3238,'productlist','1','addstock'),(3239,'productlist','1','delete'),(3240,'productlist','1','view'),(3241,'productlist','1','update'),(3242,'productlist','1','add'),(3243,'productlist','1','openclosestock'),(3244,'productlist','1','stocktaking'),(3245,'products','1','add'),(3246,'products','1','update'),(3247,'products','1','delete'),(3248,'products','1','addstock'),(3249,'products','1','more'),(3250,'products','1','bulk'),(3251,'products','1','deleteorder'),(3252,'products','1','removestock'),(3253,'products','1','dispatch'),(3254,'products','1','price'),(3255,'products','1','removeallstock'),(3256,'incomingstock','1','add'),(3257,'incomingstock','1','update'),(3258,'incomingstock','1','view'),(3259,'incomingstock','1','delete'),(3260,'incomingstore','1','add'),(3261,'incomingstore','1','delete'),(3262,'incomingstore','1','view'),(3263,'lowstocklist','1','add'),(3264,'lowstocklist','1','more'),(3265,'lowstocklist','1','view'),(3266,'lowproducts','1','add'),(3267,'lowproducts','1','update'),(3268,'accounting','1','View Accounting'),(3269,'accounting','1','deletebank'),(3270,'accounting','1','deleteglaccount'),(3271,'damagedproducts','1','add'),(3272,'damagedproducts','1','update'),(3273,'damagedproducts','1','delete'),(3274,'accomodation','1','viewrooms'),(3275,'purchases','1','add'),(3276,'purchases','1','update'),(3277,'purchases','1','delete'),(3278,'purchases','1','updatebuyingprice'),(3279,'purchases','1','updatesellingprice'),(3280,'purchases','1','updateclosedinvoice'),(3281,'incomeexpenses','1','add'),(3282,'incomeexpenses','1','update'),(3283,'bankdeposits','1','add'),(3284,'bankdeposits','1','update'),(3285,'bankdeposits','1','delete'),(3286,'loyalitycards','1','add'),(3287,'loyalitycards','1','update'),(3288,'reports','1','view'),(3289,'reports','1','download'),(3290,'reports','1','delete'),(3291,'reports','1','update'),(3292,'reports','1','viewall'),(3293,'displayreport','1','view'),(3294,'grouping','1','add'),(3295,'grouping','1','update'),(3296,'grouping','1','delete'),(3297,'sendsms','1','add'),(3298,'sendsms','1','update'),(3299,'sendsms','1','delete'),(3300,'documents','1','add'),(3301,'documents','1','update'),(3302,'documents','1','delete'),(3303,'taskscategory','1','add'),(3304,'taskscategory','1','update'),(3305,'taskscategory','1','delete'),(3306,'task','1','add'),(3307,'task','1','update'),(3308,'task','1','viewall'),(3309,'task','1','delete'),(3310,'callcenter','1','add'),(3311,'callcenter','1','upadate'),(3312,'callcenter','1','view'),(3313,'callcenter','1','delete'),(3314,'deals','1','add'),(3315,'deals','1','update'),(3316,'deals','1','delete'),(3317,'deals','1','viewall'),(3318,'complain','1','add'),(3319,'complain','1','view'),(3320,'complain','1','update'),(3321,'complain','1','allcompalin'),(3322,'complain','1','delete'),(3323,'events','1','add'),(3324,'events','1','update'),(3325,'events','1','delete'),(3326,'password','1','change'),(3327,'profile','1','update'),(3328,'config','1','delete'),(3329,'config','1','add'),(3330,'config','1','update'),(3331,'sales','2','add'),(3332,'sales','2','update'),(3333,'sales','2','delete'),(3334,'sales','2','sale'),(3335,'sales','2','mpesabalance'),(3336,'sales','2','displaycustomers'),(3337,'sales','2','discount'),(3338,'sales','2','Logout'),(3339,'sales','2','reprint'),(3340,'sales','2','select'),(3341,'sales','2','productdiscount'),(3342,'sales','2','order'),(3343,'sales','2','printbill'),(3344,'sales','2','mpesa'),(3345,'sales','2','closebill'),(3346,'sales','2','editsellingprice'),(3347,'sales','2','viewbuyingprice'),(3348,'sales','2','updatepaymentmode'),(3349,'sales','2','card'),(3350,'sales','2','clearpayments'),(3351,'sales','2','cheque'),(3352,'sales','2','creditnote'),(3353,'sales','2','points'),(3354,'sales','2','voucher'),(3355,'sales','2','credit'),(3356,'sales','2','dontprint'),(3357,'wholesale','2','sale'),(3358,'wholesale','2','add'),(3359,'wholesale','2','delete'),(3360,'wholesale','2','update'),(3361,'cashiersales','2','entermpesacode'),(3362,'cashiersales','2','editmpesa'),(3363,'cashiersales','2','all'),(3364,'cashiersales','2','delete'),(3365,'cashiersales','2','editmpesadate'),(3366,'cashiersales','2','cashiersales'),(3367,'cashiersales','2','adddailycollection'),(3368,'cashiersales','2','viewdailycollections'),(3369,'cashiersales','2','deletedailycollections'),(3370,'cashiersales','2','reversempesa'),(3371,'cashiersales','2','updatedailycollections'),(3372,'cashiersales','2','clearallsales'),(3373,'cashiersales','2','mpesapendingreport'),(3374,'cashiersales','2','mpesaverifiedreport'),(3375,'viewreturnsales','2','add'),(3376,'viewreturnsales','2','update'),(3377,'viewreturnsales','2','delete'),(3378,'viewreturnsales','2','return'),(3379,'viewreturnsales','2','clear'),(3380,'viewreturnsales','2','moresales'),(3381,'peoplecategory','2','add'),(3382,'peoplecategory','2','update'),(3383,'peoplecategory','2','delete'),(3384,'branch','2','add'),(3385,'branch','2','view'),(3386,'branch','2','update'),(3387,'branch','2','delete'),(3388,'members','2','add'),(3389,'members','2','update'),(3390,'users','2','add'),(3391,'users','2','update'),(3392,'users','2','delete'),(3393,'users','2','deleteallroles'),(3394,'productscategory','2','add'),(3395,'productscategory','2','update'),(3396,'productscategory','2','delete'),(3397,'productlist','2','bulk'),(3398,'productlist','2','more'),(3399,'productlist','2','transfer'),(3400,'productlist','2','addstock'),(3401,'productlist','2','delete'),(3402,'productlist','2','view'),(3403,'productlist','2','update'),(3404,'productlist','2','add'),(3405,'productlist','2','openclosestock'),(3406,'productlist','2','stocktaking'),(3407,'productlist','2','editstocktaken'),(3408,'productlist','2','editopenclosestock'),(3409,'products','2','add'),(3410,'products','2','update'),(3411,'products','2','delete'),(3412,'products','2','addstock'),(3413,'products','2','more'),(3414,'products','2','bulk'),(3415,'products','2','deleteorder'),(3416,'products','2','removestock'),(3417,'products','2','dispatch'),(3418,'products','2','price'),(3419,'products','2','removeallstock'),(3420,'incomingstock','2','add'),(3421,'incomingstock','2','update'),(3422,'incomingstock','2','view'),(3423,'incomingstock','2','delete'),(3424,'incomingstore','2','add'),(3425,'incomingstore','2','delete'),(3426,'incomingstore','2','view'),(3427,'lowstocklist','2','add'),(3428,'lowstocklist','2','more'),(3429,'lowstocklist','2','view'),(3430,'lowproducts','2','add'),(3431,'lowproducts','2','update'),(3432,'accounting','2','View Accounting'),(3433,'accounting','2','deletebank'),(3434,'accounting','2','deleteglaccount'),(3435,'damagedproducts','2','add'),(3436,'damagedproducts','2','update'),(3437,'damagedproducts','2','delete'),(3438,'accomodation','2','viewrooms'),(3439,'purchases','2','add'),(3440,'purchases','2','update'),(3441,'purchases','2','delete'),(3442,'purchases','2','updatebuyingprice'),(3443,'purchases','2','updatesellingprice'),(3444,'purchases','2','updateclosedinvoice'),(3445,'incomeexpenses','2','add'),(3446,'incomeexpenses','2','update'),(3447,'bankdeposits','2','add'),(3448,'bankdeposits','2','update'),(3449,'bankdeposits','2','delete'),(3450,'loyalitycards','2','add'),(3451,'loyalitycards','2','update'),(3452,'reports','2','view'),(3453,'reports','2','download'),(3454,'reports','2','delete'),(3455,'reports','2','update'),(3456,'reports','2','viewall'),(3457,'displayreport','2','view'),(3458,'grouping','2','add'),(3459,'grouping','2','update'),(3460,'grouping','2','delete'),(3461,'sendsms','2','add'),(3462,'sendsms','2','update'),(3463,'sendsms','2','delete'),(3464,'documents','2','add'),(3465,'documents','2','update'),(3466,'documents','2','delete'),(3467,'taskscategory','2','add'),(3468,'taskscategory','2','update'),(3469,'taskscategory','2','delete'),(3470,'task','2','add'),(3471,'task','2','update'),(3472,'task','2','viewall'),(3473,'task','2','delete'),(3474,'callcenter','2','add'),(3475,'callcenter','2','upadate'),(3476,'callcenter','2','view'),(3477,'callcenter','2','delete'),(3478,'deals','2','add'),(3479,'deals','2','update'),(3480,'deals','2','delete'),(3481,'deals','2','viewall'),(3482,'complain','2','add'),(3483,'complain','2','view'),(3484,'complain','2','update'),(3485,'complain','2','allcompalin'),(3486,'complain','2','delete'),(3487,'events','2','add'),(3488,'events','2','update'),(3489,'events','2','delete'),(3490,'password','2','change');
/*!40000 ALTER TABLE `permissionsactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plot`
--

DROP TABLE IF EXISTS `plot`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `plot` (
  `id` int(40) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `agentid` varchar(100) NOT NULL,
  `landlordid` varchar(100) NOT NULL,
  `totalhouse` varchar(100) NOT NULL,
  `country` varchar(40) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(100) NOT NULL,
  `accountname` varchar(100) NOT NULL,
  `accountno` varchar(100) NOT NULL,
  `commission` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `plot`
--

LOCK TABLES `plot` WRITE;
/*!40000 ALTER TABLE `plot` DISABLE KEYS */;
/*!40000 ALTER TABLE `plot` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productcategory`
--

DROP TABLE IF EXISTS `productcategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `productcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` int(11) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `maincategory` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productcategory`
--

LOCK TABLES `productcategory` WRITE;
/*!40000 ALTER TABLE `productcategory` DISABLE KEYS */;
INSERT INTO `productcategory` VALUES (1,'WINES',111,'2019-02-07 07:29:11','active','1','','1','2'),(2,'BEER',100,'2019-02-03 21:08:31','active','1','','1','1'),(3,'CANS',88,'2019-02-03 21:08:46','active','1','','1','1'),(4,'WHISKEY',0,'2019-02-07 07:29:19','active','1','','1','2'),(5,'SOFTDRINKS',0,'','active','1','','1','1'),(6,'ALL CIGARETTE',200,'2019-02-03 22:21:25','active','1','','1','1'),(7,'SPIRITS',90,'2019-02-03 22:20:12','active','1','','1','1'),(8,'TOTS',0,'','active','1','','1','1'),(9,'VODKA',0,'','active','1','','1','1'),(10,'GIN',0,'','active','1','','1','1'),(11,'BRANDY',0,'','active','1','','1','1'),(12,'RUM',0,'','active','1','','1','1'),(13,'SAMBUCA',0,'','active','1','','1','1'),(14,'MEDICINE',0,'','active','1','','1','1'),(15,'CONDOMS',0,'','active','1','','1','1'),(16,'MATCHBOX',0,'','active','1','','1','1'),(18,'CREAM',0,'','active','1','','1','1'),(19,'VEGETABLES',0,'','active','1','','1','2'),(20,'SIDE MEALS',0,'','active','1','','1','2'),(21,'SNACKS',0,'','active','1','','1','2'),(22,'SALADS',0,'','active','1','','1','2'),(23,'MEALS',0,'','active','1','','1','2'),(24,'MAIN MEALS',0,'','active','1','','1','2'),(25,'BEVERAGES',0,'','active','1','','1','2'),(26,'Accomodations',0,'','active','1','','1','3'),(27,'001',0,'2019-03-02 16:36:20','active','2','','1','1');
/*!40000 ALTER TABLE `productcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productlist`
--

DROP TABLE IF EXISTS `productlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `productlist` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category` varchar(50) NOT NULL,
  `supplier` varchar(50) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `tax_included` int(10) NOT NULL DEFAULT 16,
  `buyingprice` varchar(50) NOT NULL,
  `sellingprice` varchar(50) NOT NULL DEFAULT '0.00',
  `promoprice` varchar(50) DEFAULT NULL,
  `wholesaleprice` varchar(50) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `reorderevel` varchar(50) DEFAULT NULL,
  `allow_alt_description` tinyint(1) NOT NULL,
  `is_serialized` tinyint(1) NOT NULL,
  `imgid` varchar(255) DEFAULT NULL,
  `override_default_tax` int(1) NOT NULL DEFAULT 0,
  `is_service` int(1) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `qty` decimal(10,2) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `branch` varchar(50) NOT NULL,
  `expdate` date NOT NULL,
  `orderamount` text NOT NULL,
  `shortname` text NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'active',
  `store` text NOT NULL,
  `code` varchar(100) NOT NULL,
  `uom` varchar(20) NOT NULL DEFAULT 'pcs',
  `producttype` varchar(30) NOT NULL DEFAULT 'Inventory',
  PRIMARY KEY (`id`),
  KEY `phppos_items_ibfk_1` (`supplier`),
  KEY `name` (`name`),
  KEY `deleted` (`deleted`),
  KEY `phppos_items_ibfk_2` (`imgid`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productlist`
--

LOCK TABLES `productlist` WRITE;
/*!40000 ALTER TABLE `productlist` DISABLE KEYS */;
INSERT INTO `productlist` VALUES (1,'Item Name','Category','supplier','description',16,'Cost Price','Sale Price','Sale Price','Sale Price',NULL,NULL,'reorderevel',0,0,NULL,0,0,0,0.00,'','1','1','branch','0000-00-00','','','active','','Item Code','pcs','Inventory'),(2,'SODA 500ML','5','1','n/a',16,'37.92','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','11','pcs','Inventory'),(3,'SODA 300ML','5','1','n/a',16,'0','50','50','50',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','12','pcs','Inventory'),(4,'TUSKER LARGER','1','1','n/a',16,'0','180','180','180',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','13','pcs','Inventory'),(5,'TUSKER CIDER','1','1','n/a',16,'0','190','190','190',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','15','pcs','Inventory'),(6,'PILSNER LAGER','1','1','',16,'0','180','180','180',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','16','pcs','Inventory'),(7,'GUINESS KUBWA','1','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','17','pcs','Inventory'),(8,'ALLSOPPS','1','1','',16,'0','150','150','150',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','18','pcs','Inventory'),(9,'BALOZI','1','1','',16,'0','160','160','160',NULL,NULL,'5',0,0,NULL,0,0,0,997.00,'','1','1','1','0000-00-00','','','active','','19','pcs','Inventory'),(10,'TUSKER MALT','1','1','',16,'0','190','190','190',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','20','pcs','Inventory'),(11,'WHITECAP LARGER','1','1','',16,'0','190','190','190',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','21','pcs','Inventory'),(12,'WHITECAP CAN','1','1','',16,'0','250','250','250',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','22','pcs','Inventory'),(13,'GUINESS CAN','1','1','',16,'0','250','250','250',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','23','pcs','Inventory'),(14,'TUSKER CAN','1','1','',16,'0','250','250','250',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','24','pcs','Inventory'),(15,'ALVARO','4','1','',16,'0','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','25','pcs','Inventory'),(16,'SUMMIT LARGER','1','1','',16,'0','160','160','160',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','26','pcs','Inventory'),(17,'TUSKER LITE','1','1','',16,'0','190','190','190',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','27','pcs','Inventory'),(18,'SNAPP','1','1','',16,'0','190','190','190',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','28','pcs','Inventory'),(19,'GUARANA','1','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','29','pcs','Inventory'),(20,'SODA WATER','5','1','',16,'0','70','70','70',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','30','pcs','Inventory'),(21,'NOVIDA','5','1','',16,'0','60','60','60',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','31','pcs','Inventory'),(22,'MINERAL WATER 500ML','7','1','',16,'0','50','50','50',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','32','pcs','Inventory'),(23,'MINERAL WATER 1L','7','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,998.00,'','1','1','1','0000-00-00','','','active','','33','pcs','Inventory'),(24,'JUICE','4','1','',16,'0','250','250','250',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','34','pcs','Inventory'),(25,'KENYA CANE 750ML','6','1','',16,'0','700','700','700',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','35','pcs','Inventory'),(26,'KENYA CANE 375ML','6','1','',16,'0','450','450','450',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','36','pcs','Inventory'),(27,'KENYA CANE 250ML','6','1','',16,'0','130','130','130',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','37','pcs','Inventory'),(28,'CAPTAIN MORGAN','6','1','',16,'0','350','350','350',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','38','pcs','Inventory'),(29,'BURG','1','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','39','pcs','Inventory'),(30,'SMIRNOFF 750ML','6','1','',16,'0','1,400.00','1,400.00','1,400.00',NULL,NULL,'5',0,0,NULL,0,0,0,889.00,'','1','1','1','0000-00-00','','','active','','40','pcs','Inventory'),(31,'SMIRNOFF 375ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','41','pcs','Inventory'),(32,'SMIRNOFF 250ML','6','1','',16,'0','500','500','500',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','42','pcs','Inventory'),(33,'RICHOT 750ML','6','1','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','43','pcs','Inventory'),(34,'RICHOT 375ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','44','pcs','Inventory'),(35,'RICHOT 250ML','6','1','',16,'0','450','450','450',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','45','pcs','Inventory'),(36,'VICE ROY 750ML','6','1','',16,'0','1,400.00','1,400.00','1,400.00',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','46','pcs','Inventory'),(37,'VICE ROY 375ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','47','pcs','Inventory'),(38,'VICE ROY 250ML','6','1','',16,'0','450','450','450',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','48','pcs','Inventory'),(39,'RED BULL','4','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','49','pcs','Inventory'),(40,'KINGFISHER','8','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','50','pcs','Inventory'),(41,'GILBEYS 750ML','6','1','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','51','pcs','Inventory'),(42,'GILBEYS 375ML','6','1','',16,'0','600','600','600',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','52','pcs','Inventory'),(43,'GILBEYS 250ML','6','1','',16,'0','400','400','400',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','53','pcs','Inventory'),(44,'TRIPPLE ACE 250ML','6','1','',16,'0','90','90','90',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','54','pcs','Inventory'),(45,'KIBAO VODKA 750ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','55','pcs','Inventory'),(46,'KIBAO VODKA 250ML','6','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','56','pcs','Inventory'),(47,'PENASOL','8','1','',16,'0','700','700','700',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','57','pcs','Inventory'),(48,'CAPRICE','8','1','',16,'0','750','750','750',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','58','pcs','Inventory'),(49,'CHROME 750ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','59','pcs','Inventory'),(50,'CHROME 250ML','6','1','',16,'0','110','110','110',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','60','pcs','Inventory'),(51,'SNAPP CAN','1','1','',16,'0','250','250','250',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','61','pcs','Inventory'),(52,'BEST 250ML','6','1','',16,'0','450','450','450',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','62','pcs','Inventory'),(53,'FAXE','1','1','',16,'0','200','200','200',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','63','pcs','Inventory'),(54,'HUNTERS CHOICE 375ML','6','1','',16,'0','450','450','450',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','64','pcs','Inventory'),(55,'HUNTERS 250ML','6','1','',16,'0','130','130','130',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','65','pcs','Inventory'),(56,'CELLARCASK 750ML','6','1','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','66','pcs','Inventory'),(57,'V$A 250ML','6','1','',16,'0','260','260','260',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','67','pcs','Inventory'),(58,'BLACK N WHITE 375ML','6','1','',16,'0','600','600','600',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','68','pcs','Inventory'),(59,'KENYA KING 750ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','69','pcs','Inventory'),(60,'KENYA KING 250ML','6','1','',16,'0','90','90','90',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','70','pcs','Inventory'),(61,'KONYAGI 750ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','71','pcs','Inventory'),(62,'KONYAGI 250ML','6','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','72','pcs','Inventory'),(63,'BLUE ICE 250ML','6','1','',16,'0','75','75','75',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','73','pcs','Inventory'),(64,'MOONWALKER 250ML','6','1','',16,'0','75','75','75',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','74','pcs','Inventory'),(65,'LEGEND 750ML','6','1','',16,'0','650','650','650',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','75','pcs','Inventory'),(66,'LEGEND 250ML','6','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','76','pcs','Inventory'),(67,'ORIGIN 250ML','6','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','77','pcs','Inventory'),(68,'KANE 250ML','6','1','',16,'0','90','90','90',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','78','pcs','Inventory'),(69,'CLUB MAN 250ML','6','1','',16,'0','125','125','125',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','79','pcs','Inventory'),(70,'NAPPS 250ML','6','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','80','pcs','Inventory'),(71,'LIME JUICE','4','1','',16,'0','10','10','10',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','81','pcs','Inventory'),(72,'EMBASSY LIGHT','2','1','',16,'0','15','15','15',NULL,NULL,'5',0,0,NULL,0,0,0,999.00,'','1','1','1','0000-00-00','','','active','','82','pcs','Inventory'),(73,'DUNHILL','2','1','',16,'0','15','15','15',NULL,NULL,'5',0,0,NULL,0,0,0,999.00,'','1','1','1','0000-00-00','','','active','','83','pcs','Inventory'),(74,'SPORTSMAN','2','1','',16,'0','15','15','15',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','84','pcs','Inventory'),(75,'SM','2','1','',16,'0','15','15','15',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','85','pcs','Inventory'),(76,'MATCH BOX','2','1','',16,'0','5','5','5',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','86','pcs','Inventory'),(77,'TRUST','4','1','',16,'0','50','50','50',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','87','pcs','Inventory'),(78,'','0','1','',16,'0','0','0','0',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','89','pcs','Inventory'),(79,'SENATOR KEG DARK 500ML','3','1','',16,'0','60','60','60',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','91','pcs','Inventory'),(80,'SENATOR KEG DARK 300ML','0','1','',16,'0','40','40','40',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','92','pcs','Inventory'),(81,'HUNTER CHOICE 750ML','6','1','',16,'680','750','750','750',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','93','pcs','Inventory'),(82,'','6','1','',16,'0','0','0','0',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','94','pcs','Inventory'),(83,'SENATOR KEG 500ML','3','1','',16,'0','50','50','50',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','95','pcs','Inventory'),(84,'SENATOR KEG 300ML','3','1','',16,'0','30','30','30',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','96','pcs','Inventory'),(85,'SENATOR KEG 1000ML','3','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','97','pcs','Inventory'),(86,'SENATOR KEG 1500ML','3','1','',16,'0','150','150','150',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','98','pcs','Inventory'),(87,'SENATOR KEG DARK 1500ML','3','1','',16,'0','180','180','180',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','100','pcs','Inventory'),(88,'SENATOR KEG DARK 1000ML','3','1','',16,'0','120','120','120',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','101','pcs','Inventory'),(89,'SAFARI','2','1','',16,'0','10','10','10',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','102','pcs','Inventory'),(90,'KIBAO 375ML','6','1','',16,'0','400','400','400',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','103','pcs','Inventory'),(91,'FOOTBALL SODA 500ML','5','1','',16,'0','100','100','100',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','104','pcs','Inventory'),(92,'FOOTBALL SODA 300ML','5','1','',16,'0','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','105','pcs','Inventory'),(93,'FOOT BALL WATER 500ML','7','1','',16,'0','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','106','pcs','Inventory'),(94,'FOOTBALL NOVIDA','5','1','',16,'0','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','107','pcs','Inventory'),(95,'FOOTBALL SODA WATER','5','1','',16,'0','80','80','80',NULL,NULL,'5',0,0,NULL,0,0,0,1000.00,'','1','1','1','0000-00-00','','','active','','108','pcs','Inventory'),(96,'Fanta 500ml','25','2','',0,'15','30','','19',NULL,NULL,'12',0,0,'2469011553599717',0,0,0,-505.00,'2019-03-26 14:31:53','1','1','1','0000-00-00','500','fanta','active','f','122','hlf','Inventory');
/*!40000 ALTER TABLE `productlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `products` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category` varchar(50) NOT NULL,
  `supplier` varchar(50) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `tax_included` int(10) NOT NULL DEFAULT 16,
  `buyingprice` varchar(50) NOT NULL,
  `sellingprice` varchar(50) NOT NULL DEFAULT '0.00',
  `promoprice` varchar(50) DEFAULT NULL,
  `wholesaleprice` varchar(50) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `reorderevel` int(50) DEFAULT NULL,
  `allow_alt_description` tinyint(1) NOT NULL,
  `is_serialized` tinyint(1) NOT NULL,
  `imgid` varchar(255) DEFAULT NULL,
  `override_default_tax` int(1) NOT NULL DEFAULT 0,
  `is_service` int(1) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `qty` decimal(10,2) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `store` varchar(50) NOT NULL,
  `expdate` date NOT NULL,
  `orderamount` text NOT NULL,
  `shortname` varchar(50) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'active',
  `uom` varchar(20) NOT NULL DEFAULT 'pcs',
  `producttype` varchar(30) NOT NULL DEFAULT 'Inventory',
  `assetaccount` varchar(30) NOT NULL,
  `salesaccount` varchar(30) NOT NULL,
  `expenseaccount` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_number` (`code`),
  KEY `phppos_items_ibfk_1` (`supplier`),
  KEY `name` (`name`),
  KEY `deleted` (`deleted`),
  KEY `phppos_items_ibfk_2` (`imgid`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,'Item Name','Category','supplier','Item Code','description',16,'Cost Price','Sale Price','Sale Price','Sale Price',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(2,'SODA 500ML','5','1','11','n/a',16,'37.92','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(3,'SODA 300ML','5','1','12','n/a',16,'0','50','50','50',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(4,'TUSKER LARGER','1','1','13','n/a',16,'0','180','180','180',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(5,'TUSKER CIDER','1','1','15','n/a',16,'0','190','190','190',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(6,'PILSNER LAGER','1','1','16','',16,'0','180','180','180',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(7,'GUINESS KUBWA','1','1','17','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(8,'ALLSOPPS','1','1','18','',16,'0','150','150','150',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(9,'BALOZI','1','1','19','',16,'0','160','160','160',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(10,'TUSKER MALT','1','1','20','',16,'0','190','190','190',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(11,'WHITECAP LARGER','1','1','21','',16,'0','190','190','190',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(12,'WHITECAP CAN','1','1','22','',16,'0','250','250','250',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(13,'GUINESS CAN','1','1','23','',16,'0','250','250','250',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(14,'TUSKER CAN','1','1','24','',16,'0','250','250','250',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(15,'ALVARO','4','1','25','',16,'0','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(16,'SUMMIT LARGER','1','1','26','',16,'0','160','160','160',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(17,'TUSKER LITE','1','1','27','',16,'0','190','190','190',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(18,'SNAPP','1','1','28','',16,'0','190','190','190',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(19,'GUARANA','1','1','29','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(20,'SODA WATER','5','1','30','',16,'0','70','70','70',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(21,'NOVIDA','5','1','31','',16,'0','60','60','60',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(22,'MINERAL WATER 500ML','7','1','32','',16,'0','50','50','50',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(23,'MINERAL WATER 1L','7','1','33','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(24,'JUICE','4','1','34','',16,'0','250','250','250',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(25,'KENYA CANE 750ML','6','1','35','',16,'0','700','700','700',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(26,'KENYA CANE 375ML','6','1','36','',16,'0','450','450','450',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(27,'KENYA CANE 250ML','6','1','37','',16,'0','130','130','130',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(28,'CAPTAIN MORGAN','6','1','38','',16,'0','350','350','350',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(29,'BURG','1','1','39','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(30,'SMIRNOFF 750ML','6','1','40','',16,'0','1,400.00','1,400.00','1,400.00',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(31,'SMIRNOFF 375ML','6','1','41','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(32,'SMIRNOFF 250ML','6','1','42','',16,'0','500','500','500',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(33,'RICHOT 750ML','6','1','43','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(34,'RICHOT 375ML','6','1','44','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(35,'RICHOT 250ML','6','1','45','',16,'0','450','450','450',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(36,'VICE ROY 750ML','6','1','46','',16,'0','1,400.00','1,400.00','1,400.00',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(37,'VICE ROY 375ML','6','1','47','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(38,'VICE ROY 250ML','6','1','48','',16,'0','450','450','450',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(39,'RED BULL','4','1','49','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(40,'KINGFISHER','8','1','50','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(41,'GILBEYS 750ML','6','1','51','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(42,'GILBEYS 375ML','6','1','52','',16,'0','600','600','600',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(43,'GILBEYS 250ML','6','1','53','',16,'0','400','400','400',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(44,'TRIPPLE ACE 250ML','6','1','54','',16,'0','90','90','90',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(45,'KIBAO VODKA 750ML','6','1','55','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(46,'KIBAO VODKA 250ML','6','1','56','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(47,'PENASOL','8','1','57','',16,'0','700','700','700',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(48,'CAPRICE','8','1','58','',16,'0','750','750','750',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(49,'CHROME 750ML','6','1','59','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(50,'CHROME 250ML','6','1','60','',16,'0','110','110','110',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(51,'SNAPP CAN','1','1','61','',16,'0','250','250','250',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(52,'BEST 250ML','6','1','62','',16,'0','450','450','450',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(53,'FAXE','1','1','63','',16,'0','200','200','200',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(54,'HUNTERS CHOICE 375ML','6','1','64','',16,'0','450','450','450',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(55,'HUNTERS 250ML','6','1','65','',16,'0','130','130','130',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(56,'CELLARCASK 750ML','6','1','66','',16,'0','1,200.00','1,200.00','1,200.00',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(57,'V$A 250ML','6','1','67','',16,'0','260','260','260',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(58,'BLACK N WHITE 375ML','6','1','68','',16,'0','600','600','600',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(59,'KENYA KING 750ML','6','1','69','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(60,'KENYA KING 250ML','6','1','70','',16,'0','90','90','90',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(61,'KONYAGI 750ML','6','1','71','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(62,'KONYAGI 250ML','6','1','72','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(63,'BLUE ICE 250ML','6','1','73','',16,'0','75','75','75',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(64,'MOONWALKER 250ML','6','1','74','',16,'0','75','75','75',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(65,'LEGEND 750ML','6','1','75','',16,'0','650','650','650',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(66,'LEGEND 250ML','6','1','76','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(67,'ORIGIN 250ML','6','1','77','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(68,'KANE 250ML','6','1','78','',16,'0','90','90','90',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(69,'CLUB MAN 250ML','6','1','79','',16,'0','125','125','125',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(70,'NAPPS 250ML','6','1','80','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(71,'LIME JUICE','4','1','81','',16,'0','10','10','10',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(72,'EMBASSY LIGHT','2','1','82','',16,'0','15','15','15',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(73,'DUNHILL','2','1','83','',16,'0','15','15','15',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(74,'SPORTSMAN','2','1','84','',16,'0','15','15','15',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(75,'SM','2','1','85','',16,'0','15','15','15',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(76,'MATCH BOX','2','1','86','',16,'0','5','5','5',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(77,'TRUST','4','1','87','',16,'0','50','50','50',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(78,'','0','1','89','',16,'0','0','0','0',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(79,'SENATOR KEG DARK 500ML','3','1','91','',16,'0','60','60','60',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(80,'SENATOR KEG DARK 300ML','0','1','92','',16,'0','40','40','40',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(81,'HUNTER CHOICE 750ML','6','1','93','',16,'680','750','750','750',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(82,'','6','1','94','',16,'0','0','0','0',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(83,'SENATOR KEG 500ML','3','1','95','',16,'0','50','50','50',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(84,'SENATOR KEG 300ML','3','1','96','',16,'0','30','30','30',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(85,'SENATOR KEG 1000ML','3','1','97','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(86,'SENATOR KEG 1500ML','3','1','98','',16,'0','150','150','150',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(87,'SENATOR KEG DARK 1500ML','3','1','100','',16,'0','180','180','180',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(88,'SENATOR KEG DARK 1000ML','3','1','101','',16,'0','120','120','120',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(89,'SAFARI','2','1','102','',16,'0','10','10','10',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(90,'KIBAO 375ML','6','1','103','',16,'0','400','400','400',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(91,'FOOTBALL SODA 500ML','5','1','104','',16,'0','100','100','100',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(92,'FOOTBALL SODA 300ML','5','1','105','',16,'0','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(93,'FOOT BALL WATER 500ML','7','1','106','',16,'0','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(94,'FOOTBALL NOVIDA','5','1','107','',16,'0','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(95,'FOOTBALL SODA WATER','5','1','108','',16,'0','80','80','80',NULL,NULL,5,0,0,NULL,0,0,0,1000.00,'','1','1','','0000-00-00','','','active','pcs','Inventory','','',''),(96,'Fanta 500ml','25','2','122','',0,'15','30','','19',NULL,NULL,12,0,0,'2469011553599717',0,0,0,0.00,'2019-03-26 14:31:53','1','1','f','0000-00-00','500','fanta','active','hlf','Inventory','Asset','Sales','Asset');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `province`
--

DROP TABLE IF EXISTS `province`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `province` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `code` varchar(40) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `province`
--

LOCK TABLES `province` WRITE;
/*!40000 ALTER TABLE `province` DISABLE KEYS */;
INSERT INTO `province` VALUES (1,'1','Central','Central','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'2','Coast','Coast','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'3','Eastern','Eastern','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'4','Nairobi','Nairobi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'5','North Eastern','North Eastern','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'6','Nyanza','Nyanza','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'7','Rift valley','Rift valley','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'8','Western','Western','0000-00-00 00:00:00','0000-00-00 00:00:00');
/*!40000 ALTER TABLE `province` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchaseorder`
--

DROP TABLE IF EXISTS `purchaseorder`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchaseorder` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `supplier` varchar(30) NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `orderdate` varchar(30) NOT NULL,
  `ordernumber` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(30) NOT NULL,
  `createdate` varchar(30) NOT NULL,
  `orderedby` text NOT NULL,
  `shippingto` text NOT NULL,
  `canceldate` varchar(30) NOT NULL,
  `deliverymethod` varchar(30) NOT NULL,
  `fob` text NOT NULL,
  `terms` text NOT NULL,
  `deliverydate` varchar(30) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'p.o',
  `amount` decimal(10,2) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `fromdate` varchar(30) NOT NULL,
  `paiddate` varchar(30) NOT NULL,
  `updateddate` varchar(30) NOT NULL,
  `updatedid` varchar(30) NOT NULL,
  `pin` varchar(30) NOT NULL,
  `vattype` varchar(10) NOT NULL,
  `vat` varchar(20) NOT NULL,
  `taxable` decimal(10,2) NOT NULL,
  `vatrate` varchar(20) NOT NULL,
  `paid` varchar(20) NOT NULL,
  `transactionstatus` varchar(20) NOT NULL DEFAULT 'open',
  `remarks` text NOT NULL,
  `entrydate` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice` (`invoice`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchaseorder`
--

LOCK TABLES `purchaseorder` WRITE;
/*!40000 ALTER TABLE `purchaseorder` DISABLE KEYS */;
INSERT INTO `purchaseorder` VALUES (1,'2','45566','','','','1','2019-02-01 14:58:02','','','','','','','','purchases',2000.00,'1',0.00,'2019-02-01 14:57:41','2019-02-01 14:57:41','','','999','VATABLE','275.86',1724.14,'16','','open','','');
/*!40000 ALTER TABLE `purchaseorder` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchaseorderlist`
--

DROP TABLE IF EXISTS `purchaseorderlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchaseorderlist` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  `qty` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `salestype` varchar(100) NOT NULL,
  `sprice` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `user` varchar(50) NOT NULL,
  `bprice` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'cash',
  `tax` varchar(50) NOT NULL,
  `balance` varchar(50) NOT NULL,
  `customer` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `mode` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `maincategory` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `status` varchar(30) DEFAULT 'new',
  `branch` varchar(30) NOT NULL,
  `ordersales` varchar(20) NOT NULL DEFAULT 'new',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `purchaseorderlist`
--

LOCK TABLES `purchaseorderlist` WRITE;
/*!40000 ALTER TABLE `purchaseorderlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `purchaseorderlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quotation`
--

DROP TABLE IF EXISTS `quotation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotation` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `supplier` text NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `orderdate` varchar(30) NOT NULL,
  `ordernumber` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `userid` varchar(30) NOT NULL,
  `createdate` varchar(30) NOT NULL,
  `orderedby` text NOT NULL,
  `shippingto` text NOT NULL,
  `canceldate` varchar(30) NOT NULL,
  `deliverymethod` varchar(30) NOT NULL,
  `fob` text NOT NULL,
  `terms` text NOT NULL,
  `deliverydate` varchar(30) NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'new',
  `amount` varchar(30) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  `preparedby` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice` (`invoice`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quotation`
--

LOCK TABLES `quotation` WRITE;
/*!40000 ALTER TABLE `quotation` DISABLE KEYS */;
/*!40000 ALTER TABLE `quotation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `report`
--

DROP TABLE IF EXISTS `report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `report` (
  `id` int(50) NOT NULL,
  `country` varchar(60) NOT NULL,
  `type` varchar(50) NOT NULL,
  `county` varchar(50) NOT NULL,
  `school` varchar(50) NOT NULL,
  `category` varchar(30) NOT NULL,
  `contact` varchar(60) NOT NULL,
  `place` varchar(60) NOT NULL,
  `occurancedate` varchar(60) NOT NULL,
  `description` text NOT NULL,
  `postedtime` varchar(60) NOT NULL,
  `userid` varchar(60) NOT NULL,
  `img_id` varchar(60) NOT NULL,
  `updatedtime` varchar(40) NOT NULL,
  `status` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `report`
--

LOCK TABLES `report` WRITE;
/*!40000 ALTER TABLE `report` DISABLE KEYS */;
/*!40000 ALTER TABLE `report` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roomcharges`
--

DROP TABLE IF EXISTS `roomcharges`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roomcharges` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `roomid` varchar(40) NOT NULL,
  `plotno` varchar(100) NOT NULL,
  `cost` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL,
  `createdat` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  `companyid` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roomcharges`
--

LOCK TABLES `roomcharges` WRITE;
/*!40000 ALTER TABLE `roomcharges` DISABLE KEYS */;
/*!40000 ALTER TABLE `roomcharges` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales`
--

DROP TABLE IF EXISTS `sales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sales` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `cashier` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `due_date` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `balance` varchar(20) NOT NULL DEFAULT '0',
  `userid` varchar(50) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `customer` varchar(50) NOT NULL,
  `cash` varchar(50) NOT NULL,
  `total` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `salestype` varchar(50) NOT NULL,
  `maindiscount` varchar(20) DEFAULT NULL,
  `discountedtotal` varchar(20) NOT NULL,
  `branch` varchar(30) NOT NULL DEFAULT '1',
  `card` varchar(30) NOT NULL,
  `voucher` varchar(30) NOT NULL,
  `credit` varchar(30) NOT NULL,
  `points` varchar(30) NOT NULL,
  `mpesa` varchar(50) NOT NULL,
  `cheque` varchar(50) NOT NULL,
  `ordersales` varchar(20) DEFAULT 'printed',
  `description` text NOT NULL,
  `mytable` varchar(30) NOT NULL,
  `maincategory` varchar(30) NOT NULL,
  `creditnote` varchar(30) NOT NULL,
  `invoice` varchar(30) NOT NULL,
  `paymentstatus` varchar(10) NOT NULL DEFAULT 'No',
  `updatedby` varchar(10) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales`
--

LOCK TABLES `sales` WRITE;
/*!40000 ALTER TABLE `sales` DISABLE KEYS */;
INSERT INTO `sales` VALUES (1,'','Cash','','2019-03-14','','0','1','2019-02-08 10:38:21','','680','680','1','retail',NULL,'680','1','0','0','0','0','0','0','new',' ','','1','','11549611429','No','1','2019-03-14 10:32:27'),(2,'','Cash','','2019-03-02','','0','2','2019-03-02 16:37:22','','111','111','1','retail',NULL,'111','1','0','0','0','0','0','0','printed',' ','','1','','21550149339','No','',''),(3,'','Cash','','2019-03-26','','0','1','2019-03-26 14:35:00','','11000','11000','1','retail',NULL,'11000','1','0','0','0','0','0','0','printed',' ','','2','','11553599920','No','',''),(4,'','Cash','','2019-03-30','','0','1','2019-03-30 14:49:35','','30','30','1','retail',NULL,'30','1','0','0','0','0','0','0','new',' ','','1','','11553946542','No','','');
/*!40000 ALTER TABLE `sales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sales_order`
--

DROP TABLE IF EXISTS `sales_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sales_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(100) NOT NULL,
  `code` varchar(100) NOT NULL,
  `qty` decimal(10,2) NOT NULL,
  `amount` varchar(100) NOT NULL,
  `salestype` varchar(100) NOT NULL,
  `discount` varchar(100) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `user` varchar(50) NOT NULL,
  `bprice` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL DEFAULT 'cash',
  `tax` decimal(10,2) NOT NULL,
  `sprice` varchar(100) NOT NULL,
  `balance` varchar(50) NOT NULL,
  `customer` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `mode` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `maincategory` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `status` varchar(30) DEFAULT 'new',
  `branch` varchar(30) NOT NULL,
  `ordersales` varchar(20) NOT NULL DEFAULT 'new',
  `uom` varchar(30) NOT NULL,
  `sales` varchar(30) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `updatedby` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sales_order`
--

LOCK TABLES `sales_order` WRITE;
/*!40000 ALTER TABLE `sales_order` DISABLE KEYS */;
INSERT INTO `sales_order` VALUES (1,'11549611429','19',3.00,'480','retail','0','2019-02-08 10:37:14','','','','0','Invoice',22.07,'160','','','1','','1','2019-03-14 07:32:37','2','1','printed','1','printed','pcs','','',''),(4,'21550149339','40',111.00,'111','retail','0','2019-02-14 16:03:15','','','','0','Cash',15.31,'1','','','2','','1','2019-03-02 13:37:22','1','6','printed','1','new','pcs','','',''),(5,'11549611429','33',1.00,'100','retail','0','2019-03-14 10:32:04','','','','0','Cash',13.79,'100','','','1','','1','2019-03-14 07:32:37','1','7','printed','1','new','pcs','','',''),(6,'11549611429','33',1.00,'100','retail','0','2019-03-14 10:32:06','','','','0','Cash',13.79,'100','','','1','','1','2019-03-14 07:32:37','1','7','printed','1','new','pcs','','',''),(7,'11553599920','122',550.00,'11000','retail','10','2019-03-26 14:34:05','','','','15','Cash',0.00,'20','','','1','','1','2019-03-26 11:35:01','2','25','printed','1','new','hlf','','',''),(9,'11553946542','83',1.00,'15','retail','0','2019-03-30 14:49:03','','','','0','Cash',2.07,'15','','','1','','1','2019-03-30 11:49:36','1','2','printed','1','new','pcs','','',''),(10,'11553946542','82',1.00,'15','retail','0','2019-03-30 14:49:13','','','','0','Cash',2.07,'15','','','1','','1','2019-03-30 11:49:36','1','2','printed','1','new','pcs','','','');
/*!40000 ALTER TABLE `sales_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `salesreport`
--

DROP TABLE IF EXISTS `salesreport`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `salesreport` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `user` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `reportdate` varchar(50) NOT NULL,
  `recommendation` text NOT NULL,
  `controller` varchar(40) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `salesreport`
--

LOCK TABLES `salesreport` WRITE;
/*!40000 ALTER TABLE `salesreport` DISABLE KEYS */;
/*!40000 ALTER TABLE `salesreport` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `setting`
--

DROP TABLE IF EXISTS `setting`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `setting` (
  `name` varchar(255) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `setting`
--

LOCK TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
INSERT INTO `setting` VALUES ('additional_payment_types','Cash, Credit, Mpesa,Bank'),('automatically_email_receipt','0'),('averaging_method','moving_average'),('barcode_price_include_tax','0'),('calculate_average_cost_price_from_receivings','0'),('change_sale_date_when_completing_suspended_sale','1'),('change_sale_date_when_suspending','0'),('company','Robisearch Limited'),('company_logo','1'),('currency_symbol','Ksh'),('customers_store_accounts','1'),('date_format','little_endian'),('default_payment_type','0'),('default_tax_1_name','Vat'),('default_tax_1_rate','16'),('default_tax_2_cumulative','0'),('default_tax_2_name','Sales Tax 2'),('default_tax_2_rate','0.15'),('default_tax_3_name',''),('default_tax_3_rate',''),('default_tax_4_name',''),('default_tax_4_rate',''),('default_tax_5_name',''),('default_tax_5_rate',''),('default_tax_rate','8'),('disable_confirmation_sale','0'),('display1','yes'),('display2','no'),('hide_dashboard_statistics','0'),('hide_signature','0'),('hide_store_account_payments_in_reports','0'),('hide_suspended_sales_in_reports','1'),('language','english'),('number_of_items_per_page','20'),('prices_include_tax','1'),('print_after_sale','1'),('return_policy','All return policy and any other store terms and conditions.'),('round_cash_on_sales','0'),('sale_prefix','POS'),('show_receipt_after_suspending_sale','1'),('time_format','12_hour'),('track_cash','1'),('version','14.0'),('website','www.robisearch.com');
/*!40000 ALTER TABLE `setting` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sms`
--

DROP TABLE IF EXISTS `sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `contact` varchar(60) NOT NULL,
  `postedtime` varchar(40) NOT NULL,
  `message` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sms`
--

LOCK TABLES `sms` WRITE;
/*!40000 ALTER TABLE `sms` DISABLE KEYS */;
/*!40000 ALTER TABLE `sms` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sms_in`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `sms_in` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `sms_in` WRITE;
/*!40000 ALTER TABLE `sms_in` DISABLE KEYS */;
INSERT INTO `sms_in` VALUES (1,'MH41VN93SH Confirmed. on 4/8/18 at 5:46 PM Ksh10.00 received from OUKO MANYALA 254718667391.  Account Number 10 New Utility balance is Ksh199,535.00','received','2018-11-03 17:46:38','MH41VN93SH',10.00,'from','OUKO','10',2,'2018-11-03 17:46:38'),(2,'MH44VO8FZQ Confirmed. on 4/8/18 at 6:18 PM Ksh15.00 received from OUKO MANYALA 254718667391.  Account Number ROBERT New Utility balance is Ksh199,550.00','254718667391','2018-11-03 17:46:38','MH44VO8FZQ',15.00,'OUKO','MANYALA','ROBERT',2,'2018-11-03 17:46:38'),(3,'MH43VOO3YH Confirmed. on 4/8/18 at 6:31 PM Ksh10.00 received from MAUREEN KIRUI 254722225286.  Account Number quorum New Utility balance is Ksh199,560.00','254722225286','2018-11-03 17:46:38','MH43VOO3YH',10.00,'MAUREEN','KIRUI','quorum',2,'2018-11-03 17:46:38'),(4,'MH44VP7HR2 Confirmed. on 4/8/18 at 6:48 PM Ksh2,100.00 received from ALFRED AWENDO OPIYO 254721721933.  Account Number quorum New Utility balance is Ksh201,660.00','254721721933','2018-11-03 17:46:38','MH44VP7HR2',2100.00,'ALFRED','AWENDO','quorum',1,'2018-11-03 17:46:38'),(5,'MH42VQ5REY Confirmed. on 4/8/18 at 7:14 PM Ksh1,000.00 received from OGA OKAL 254718266882.  Account Number quorum New Utility balance is Ksh202,660.00','254718266882','2018-11-03 17:46:38','MH42VQ5REY',1000.00,'OGA','OKAL','quorum',2,'2018-11-03 17:46:38'),(6,'MH44VQCZZK Confirmed. on 4/8/18 at 7:19 PM Ksh1,100.00 received from PHOEBE AKOTH ODERO 254701273620.  Account Number QUORUM New Utility balance is Ksh203,760.00','254701273620','2018-11-03 17:46:38','MH44VQCZZK',1100.00,'PHOEBE','AKOTH','QUORUM',1,'2018-11-03 17:46:38'),(7,'MH45VR44UT Confirmed. on 4/8/18 at 7:40 PM Ksh1,000.00 received from KEVIN OCHIENG 254708053635.  Account Number quorum New Utility balance is Ksh204,760.00','254708053635','2018-11-03 17:46:38','MH45VR44UT',1000.00,'KEVIN','OCHIENG','quorum',2,'2018-11-03 17:46:38'),(8,'MH40VS7YRS Confirmed. on 4/8/18 at 8:12 PM Ksh500.00 received from MILTON OBOTE 254722778673.  Account Number QUORUM New Utility balance is Ksh205,260.00','254722778673','2018-11-03 17:46:38','MH40VS7YRS',500.00,'MILTON','OBOTE','QUORUM',2,'2018-11-03 17:46:38'),(9,'MH43VTGINV Confirmed. on 4/8/18 at 8:56 PM Ksh2,100.00 received from TONNY OCHIENG TAKAHASHI RAO 254723107065.  Account Number Quorum  New Utility balance is Ksh207,360.00','','2018-11-03 17:46:38','MH43VTGINV',2100.00,'TONNY','OCHIENG','Account',2,'2018-11-03 17:46:38'),(10,'MH41VTR621 Confirmed. on 4/8/18 at 9:08 PM Ksh1,600.00 received from DAVID OKELLO 254708469713.  Account Number AC New Utility balance is Ksh208,960.00','254708469713','2018-11-03 17:46:38','MH41VTR621',1600.00,'DAVID','OKELLO','AC',2,'2018-11-03 17:46:38'),(11,'MH46VUA03W Confirmed. on 4/8/18 at 9:33 PM Ksh1,400.00 received from EUNICE MUGENYA 254720987487.  Account Number quorum New Utility balance is Ksh210,360.00','254720987487','2018-11-03 17:46:38','MH46VUA03W',1400.00,'EUNICE','MUGENYA','quorum',2,'2018-11-03 17:46:38'),(12,'MH45VUKO9B Confirmed. on 4/8/18 at 9:49 PM Ksh2,100.00 received from BENARD BUYU 254724376236.  Account Number quorum New Utility balance is Ksh212,460.00','254724376236','2018-11-03 17:46:38','MH45VUKO9B',2100.00,'BENARD','BUYU','quorum',2,'2018-11-03 17:46:38'),(13,'MH45VUQNB9 Confirmed. on 4/8/18 at 9:59 PM Ksh1,150.00 received from ISAAC AMOS 254721439488.  Account Number Quorum New Utility balance is Ksh213,610.00','254721439488','2018-11-03 17:46:38','MH45VUQNB9',1150.00,'ISAAC','AMOS','Quorum',2,'2018-11-03 17:46:38'),(14,'MH48VUSXFG Confirmed. on 4/8/18 at 10:03 PM Ksh200.00 received from THOMAS OWITI 254721926331.  Account Number quorum  New Utility balance is Ksh213,810.00','254721926331','2018-11-03 17:46:38','MH48VUSXFG',200.00,'THOMAS','OWITI','quorum',1,'2018-11-03 17:46:38'),(15,'MH46VV5YZU Confirmed. on 4/8/18 at 10:32 PM Ksh400.00 received from JACKSON OPONDO OGWINDI 254707712947.  Account Number quorum New Utility balance is Ksh214,210.00','254707712947','2018-11-03 17:46:38','MH46VV5YZU',400.00,'JACKSON','OPONDO','quorum',1,'2018-11-03 17:46:38'),(16,'MH43VVASBH Confirmed. on 4/8/18 at 10:45 PM Ksh1,000.00 received from SILAS MWALO 254721966050.  Account Number Quoram New Utility balance is Ksh215,210.00','254721966050','2018-11-03 17:46:38','MH43VVASBH',1000.00,'SILAS','MWALO','Quoram',1,'2018-11-03 17:46:38'),(17,'MH45VVAXKF Confirmed. on 4/8/18 at 10:45 PM Ksh600.00 received from KENNETH OTIENO 254729623810.  Account Number quorum New Utility balance is Ksh215,810.00','254729623810','2018-11-03 17:46:38','MH45VVAXKF',600.00,'KENNETH','OTIENO','quorum',1,'2018-11-03 17:46:38'),(18,'MH40VVD3A2 Confirmed. on 4/8/18 at 10:52 PM Ksh1,200.00 received from SILA MULELA 254721932190.  Account Number QUORUM New Utility balance is Ksh217,010.00','254721932190','2018-11-03 17:46:38','MH40VVD3A2',1200.00,'SILA','MULELA','QUORUM',1,'2018-11-03 17:46:38'),(19,'MH42VVEBFK Confirmed. on 4/8/18 at 10:56 PM Ksh200.00 received from FELIX OPONDO 254713112310.  Account Number quorum New Utility balance is Ksh217,210.00','254713112310','2018-11-03 17:46:38','MH42VVEBFK',200.00,'FELIX','OPONDO','quorum',1,'2018-11-03 17:46:38'),(20,'MH41VVFDC9 Confirmed. on 4/8/18 at 11:00 PM Ksh1,100.00 received from BERNARD KARIUKI 254725253074.  Account Number quorum New Utility balance is Ksh218,310.00','received','2018-11-03 17:46:38','MH41VVFDC9',1100.00,'from','BERNARD','quorum',1,'2018-11-03 17:46:38'),(21,'MH47VVHH5B Confirmed. on 4/8/18 at 11:08 PM Ksh400.00 received from MERLICE OULO 254724833079.  Account Number Quorum New Utility balance is Ksh218,710.00','received','2018-11-03 17:46:38','MH47VVHH5B',400.00,'from','MERLICE','Quorum',1,'2018-11-03 17:46:38'),(22,'Call me','+254714513818','2018-11-28 17:00:41','',0.00,'','','',0,''),(23,'Name: ‎Opiyo‎\nTel: ‎0729298570‎\n','+254724742771','2018-11-26 11:34:49','',0.00,'','','',0,''),(24,'0715119579','','2018-11-28 13:26:18','0715119579',0.00,'','','',2,'2018-11-28 13:26:18'),(25,'KPLC Token\nMtr No. 14104215810\nToken: 3696 4777 5505 9607 3585\nDate:2018-12-3 16:26:24\nUnits kWh:44.21\nAmount Ksh 980\nToken Amount Ksh 698.47\nTax Ksh 130.03\nREP Ksh 34.92\nWARMA Ksh 0.98\nERC Ksh 1.32\nFuel Index Ksh 110.51\nForex Ksh -0.65\nInflation Adjustment Ksh 4.42','3585\nDate:2018-12-3','2018-12-03 16:30:25','KPLC',0.00,'16:26:24\nUnits','kWh:44','',2,'2018-12-03 16:30:25'),(26,'Hi,  I have been able to send trials to my airtel and safaricom but it\'s only going to safaricom.  Airtel is not receiving.','+254708184615','2018-12-02 11:30:08','',0.00,'','','',0,''),(27,'omondionunga5','','2018-11-22 13:00:58','omondionunga5',0.00,'','','',2,'2018-11-22 13:00:58'),(28,'dkkimiti@gmail.com','','2018-12-10 17:26:43','dkkimiti@gmail.',0.00,'','','',2,'2018-12-10 17:26:43'),(29,'Ile Nlkshow','','2018-11-29 14:16:51','Ile',0.00,'','','',2,'2018-11-29 14:16:51'),(30,'ndolohenry6@gmail.com','','2018-11-29 14:34:23','ndolohenry6@gma',0.00,'','','',2,'2018-11-29 14:34:23'),(31,'I sell kaspersky antivirus to corporates wholesalers retailers and end users.','and','2018-11-23 14:42:54','I',0.00,'end','users','',2,'2018-11-23 14:42:54'),(32,'Hi, this is Dome, we just talked, waiting for the link to the ERP','for','2018-11-26 11:50:19','Hi,',0.00,'the','link','',2,'2018-11-26 11:50:19'),(33,'mjoycentre@gmail.com','','2018-12-03 14:31:16','mjoycentre@gmai',0.00,'','','',2,'2018-12-03 14:31:16'),(34,'Ok','','2018-11-29 21:30:11','Ok',0.00,'','','',2,'2018-11-29 21:30:11'),(35,'www.keffaengineeringlimited.com','','2018-12-06 16:39:55','www.keffaengine',0.00,'','','',2,'2018-12-06 16:39:55'),(36,'Advantage plus @1999/- has been successfully purchased.','','2018-12-13 09:06:29','Advantage',0.00,'','','',2,'2018-12-13 09:06:29'),(37,'Welcome to M-Bid and win many items on offer this XMAS\n-\nTo bid and win Ksh 1,000,000\nSend 1 to 21550\n-\nHelp: 0703012012\n-\nTo stop reply STOP\nThis sms is free','offer','2018-12-13 09:22:53','Welcome',0.00,'this','XMAS\n-\nTo','',2,'2018-12-13 09:22:53'),(38,'Sijasahau ile plan am very occupied up Tuesday but will let u know','but','2018-11-29 21:25:56','Sijasahau',0.00,'will','let','',2,'2018-11-29 21:25:56'),(39,'When can u do a presentation?','','2018-12-06 16:43:57','When',0.00,'','','',2,'2018-12-06 16:43:57'),(40,'Yes juu nimetoa chenye hataki. materials inabaki 220K Then Labour 20K','Then','2018-12-13 14:49:26','Yes',0.00,'Labour','20K','',2,'2018-12-13 14:49:26'),(41,'Thankie sweetie','','2018-11-30 10:18:10','Thankie',0.00,'','','',2,'2018-11-30 10:18:10'),(42,'Ok.... I will send you a proposal tomorrow in the morning\n...','in','2018-11-29 18:25:16','Ok....',0.00,'the','morning\n','',2,'2018-11-29 18:25:16'),(43,'Morning faith,  polite request from club Lacoste management,  kindly don\'t take the cheque to the bank we will organize the cash by Monday according to o*missing text*','+254717387697','2018-11-30 10:00:26','',0.00,'','','',0,''),(44,'I\'ll call you right back.','+254724639889','2018-12-14 12:22:08','',0.00,'','','',0,''),(45,'You attempted to call me but I was not available. Please call me. Tuendelee kuchat na unlimited Whatsapp. Dial *544# to enjoy','not','2018-12-14 12:33:49','You',0.00,'available.','Please','',2,'2018-12-14 12:33:49'),(46,'Please call me thank you. Okoa from as low as Ksh 10 for your Airtime Emergencies. Simply dial *131#.','low','2018-12-14 12:57:02','Please',0.00,'as','Ksh','',2,'2018-12-14 12:57:02'),(47,'Call','','2018-12-14 13:10:49','Call',0.00,'','','',2,'2018-12-14 13:10:49'),(48,'info@advalltd.com\ninfoadval@gmail.com','','2018-12-14 13:42:34','info@advalltd.c',0.00,'','','',2,'2018-12-14 13:42:34'),(49,'Ok','','2018-12-14 14:14:08','Ok',0.00,'','','',2,'2018-12-14 14:14:08'),(50,'CHAPAA iko hapa. Nyakua 1,000,000,50K au 2K sasa hivi!SMS BOX number to WIN yako!\nBox 1\nBox 2\nBox 3\nBox 4\nBox 5\nBox 6\nHelp 0709918000\nOpt out? *456*9*5#','hivi!SMS','2018-12-14 18:42:02','CHAPAA',0.00,'BOX','number','',2,'2018-12-14 18:42:02'),(51,'Hi share the different options and the cost to pishorimart@yahoo.com','to','2018-12-15 11:49:12','Hi',0.00,'pishorimart@yah','','',2,'2018-12-15 11:49:12'),(52,'pishorimart@yahoo.com','','2018-12-15 14:09:24','pishorimart@yah',0.00,'','','',2,'2018-12-15 14:09:24'),(53,'Wlcome nni n wpi','','2018-12-13 21:33:36','Wlcome',0.00,'','','',2,'2018-12-13 21:33:36'),(54,'Hello who\'s plz','+254727416958','2018-12-13 22:03:11','',0.00,'','','',0,''),(55,'Was that for me','','2018-12-16 16:53:02','Was',0.00,'','','',2,'2018-12-16 16:53:02'),(56,'Hi robert','','2018-12-16 17:12:15','Hi',0.00,'','','',2,'2018-12-16 17:12:15'),(57,'Testing','','2018-12-16 17:16:15','Testing',0.00,'','','',2,'2018-12-16 17:16:15'),(58,'KPLC Token\nMtr No. 14104215810\nToken: 0917 9363 6008 9348 3394\nDate:2018-12-16 14:27:43\nUnits kWh:45.09\nAmount Ksh 1,000\nToken Amount Ksh 712.45\nTax Ksh 132.7\nREP Ksh 35.62\nWARMA Ksh 0.93\nERC Ksh 1.35\nFuel Index Ksh 112.72\nForex Ksh -0.27\nInflation Adjustment Ksh 4.5','3394\nDate:2018-12-16','2018-12-16 17:18:35','KPLC',0.00,'14:27:43\nUnits','kWh:45','',2,'2018-12-16 17:18:35'),(59,'TEST SMS OUTOMATION','','2018-12-16 17:21:09','TEST',0.00,'','','',2,'2018-12-16 17:21:09');
/*!40000 ALTER TABLE `sms_in` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `smsconfig`
--

DROP TABLE IF EXISTS `smsconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `smsconfig` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `apikey` text NOT NULL,
  `from` varchar(50) NOT NULL,
  `link` text NOT NULL,
  `businessname` text NOT NULL,
  `contact` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `contactperson` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `contact2` varchar(50) NOT NULL,
  `address` varchar(50) NOT NULL,
  `currencysymbol` varchar(100) NOT NULL,
  `tax1` varchar(100) NOT NULL,
  `tax1rate` varchar(100) NOT NULL,
  `tax2` varchar(100) NOT NULL,
  `tax2rate` varchar(100) NOT NULL,
  `website` varchar(100) NOT NULL,
  `returnpolicy` text NOT NULL,
  `logo` text NOT NULL,
  `paymenttypes` text NOT NULL,
  `country` varchar(50) NOT NULL,
  `totalsms` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `display1` varchar(5) NOT NULL,
  `display2` varchar(5) NOT NULL,
  `maindiscount` varchar(10) NOT NULL DEFAULT 'no',
  `receiptdescription` varchar(5) NOT NULL DEFAULT 'yes',
  `deadline` varchar(50) NOT NULL,
  `tillno` text NOT NULL,
  `invoicedetails` text NOT NULL,
  `barcode` varchar(3) NOT NULL DEFAULT 'no',
  `deadlinedetails` text NOT NULL,
  `businesskey` text NOT NULL,
  `display` varchar(30) NOT NULL,
  `fromdate` varchar(30) NOT NULL,
  `todate` varchar(30) NOT NULL,
  `starttime` varchar(30) NOT NULL,
  `duetime` varchar(30) NOT NULL,
  `view` text NOT NULL,
  `receipt` varchar(50) NOT NULL,
  `mode` varchar(30) NOT NULL,
  `feedback` text NOT NULL,
  `sendfeedback` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `smsconfig`
--

LOCK TABLES `smsconfig` WRITE;
/*!40000 ALTER TABLE `smsconfig` DISABLE KEYS */;
INSERT INTO `smsconfig` VALUES (1,'robisearch','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318','ROBISEARCH','','<H1 style=\"margin:0px;\">START  SCALE <br> QUORUM BAR KISUMU</H1>\r\n\r\nTELEPHONE:0707267105\r\n','0722225286','KONDELE','','ROBISEARCHPOS-201701','ROBISEARCH LIMITED<BR>	\r\n0718667391	<BR>		\r\nIinfo@robisearch.com<BR>	\r\nrobisearch@gmail.com www.robisearch.com<BR>	 \r\nwww.shujaawangu.com KCB CAPITAL HILL	<BR>		\r\nACC NO, 1171211120		<BR>	\r\nPAY BILL NO, 717475<BR>	\r\n','CHEBET','r54321','0722225286','','KSH','VAT','16','16','10','http://www.gitobuimanyara.com1/','<H3 style=\"margin:0px;\"> RHUMBA NOSTALGIE</H3>','2018-05-011525150259.jpg','CASH','1 ','','1','2019-03-14 10:26:19','yes','no','no','no','2019-06-30','<center>TILL NO:</center>','TERMS OF SERVICE<br>\r\n1. Grand total of Ksh.25, 000is payable once (One off payment).<br>\r\n2. The cost per SMS is KSH.1<br>\r\n3. The annual maintenance cost is Ksh.5000<br>\r\n4. Price for Integration with any other ROCKY existing system is negotiable.<br>\r\n5. We will offer you 1000 free SMS to help you kick off with the system.<br>\r\n','no','You were to renew your account by11/7/2019 and you have not yet paid. Kindly send your money to our paybil no:717475 then system will continue working correctly','QH/YYplYaxjvRdOEOg19oU8rB1GSBlx1orYwt5yXrEGtDdX9AdvZ2caCdbiSKUQHQeF0EtKX6Y1Qdn6+QZR3yA==','50','Current','Current','00:00','23:59','CompleteTouch','One Without Automatic Logout','After Bill','','no');
/*!40000 ALTER TABLE `smsconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `statement`
--

DROP TABLE IF EXISTS `statement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `statement` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `invoice` varchar(50) NOT NULL,
  `crateddate` varchar(30) NOT NULL,
  `debit` decimal(10,2) NOT NULL,
  `credit` decimal(10,2) NOT NULL,
  `balance` varchar(20) NOT NULL,
  `userid` varchar(20) NOT NULL,
  `companyid` varchar(20) NOT NULL,
  `paymentmethodes` varchar(10) NOT NULL,
  `description` text NOT NULL,
  `amount` varchar(30) NOT NULL,
  `branch` varchar(30) NOT NULL,
  `supplier` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `refno` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `statement`
--

LOCK TABLES `statement` WRITE;
/*!40000 ALTER TABLE `statement` DISABLE KEYS */;
/*!40000 ALTER TABLE `statement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stock`
--

DROP TABLE IF EXISTS `stock`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `stock` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `open` decimal(10,2) NOT NULL,
  `added` decimal(10,2) NOT NULL,
  `total` decimal(10,2) NOT NULL,
  `sold` decimal(10,2) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `totalamount` decimal(10,2) NOT NULL,
  `branchid` int(10) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'open',
  `userid` int(30) NOT NULL,
  `companyid` int(30) NOT NULL,
  `startdate` varchar(30) NOT NULL,
  `closedate` varchar(10) NOT NULL,
  `updatedby` int(10) NOT NULL,
  `postedtime` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stock`
--

LOCK TABLES `stock` WRITE;
/*!40000 ALTER TABLE `stock` DISABLE KEYS */;
/*!40000 ALTER TABLE `stock` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stocktaking`
--

DROP TABLE IF EXISTS `stocktaking`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `stocktaking` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `open` decimal(10,2) NOT NULL,
  `added` decimal(10,2) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `branchid` int(10) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'open',
  `userid` int(30) NOT NULL,
  `companyid` int(30) NOT NULL,
  `startdate` varchar(30) NOT NULL,
  `closedate` varchar(10) NOT NULL,
  `updatedby` int(10) NOT NULL,
  `postedtime` varchar(30) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'open',
  `maincategory` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stocktaking`
--

LOCK TABLES `stocktaking` WRITE;
/*!40000 ALTER TABLE `stocktaking` DISABLE KEYS */;
/*!40000 ALTER TABLE `stocktaking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store`
--

DROP TABLE IF EXISTS `store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `store` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `category` varchar(50) NOT NULL,
  `supplier` varchar(50) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `tax_included` int(1) NOT NULL DEFAULT 0,
  `buyingprice` varchar(50) NOT NULL,
  `sellingprice` varchar(50) NOT NULL DEFAULT '0.00',
  `promoprice` varchar(50) DEFAULT NULL,
  `wholesaleprice` varchar(50) NOT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `reorderevel` int(50) DEFAULT NULL,
  `allow_alt_description` tinyint(1) NOT NULL,
  `is_serialized` tinyint(1) NOT NULL,
  `imgid` varchar(255) DEFAULT NULL,
  `override_default_tax` int(1) NOT NULL DEFAULT 0,
  `is_service` int(1) NOT NULL DEFAULT 0,
  `deleted` int(1) NOT NULL DEFAULT 0,
  `qty` varchar(50) NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `store` varchar(50) NOT NULL,
  `expdate` varchar(50) NOT NULL,
  `orderamount` text NOT NULL,
  `shortname` varchar(50) NOT NULL,
  `status` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_number` (`code`),
  KEY `phppos_items_ibfk_1` (`supplier`),
  KEY `name` (`name`),
  KEY `deleted` (`deleted`),
  KEY `phppos_items_ibfk_2` (`imgid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store`
--

LOCK TABLES `store` WRITE;
/*!40000 ALTER TABLE `store` DISABLE KEYS */;
/*!40000 ALTER TABLE `store` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subcategory`
--

DROP TABLE IF EXISTS `subcategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `maincategory` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subcategory`
--

LOCK TABLES `subcategory` WRITE;
/*!40000 ALTER TABLE `subcategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `subcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suggestions`
--

DROP TABLE IF EXISTS `suggestions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `suggestions` (
  `id` int(50) NOT NULL,
  `country` varchar(60) NOT NULL,
  `type` varchar(50) NOT NULL,
  `county` varchar(50) NOT NULL,
  `school` varchar(50) NOT NULL,
  `category` varchar(30) NOT NULL,
  `contact` varchar(60) NOT NULL,
  `description` text NOT NULL,
  `postedtime` varchar(60) NOT NULL,
  `userid` varchar(60) NOT NULL,
  `img_id` varchar(60) NOT NULL,
  `updatedtime` varchar(40) NOT NULL,
  `status` varchar(40) NOT NULL,
  `theme` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suggestions`
--

LOCK TABLES `suggestions` WRITE;
/*!40000 ALTER TABLE `suggestions` DISABLE KEYS */;
/*!40000 ALTER TABLE `suggestions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `meta_keyword` text NOT NULL,
  `meta_description` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags`
--

LOCK TABLES `tags` WRITE;
/*!40000 ALTER TABLE `tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taskdata`
--

DROP TABLE IF EXISTS `taskdata`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `taskdata` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `date` varchar(50) NOT NULL,
  `taskid` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `companyid` varchar(100) NOT NULL,
  `challanges` text NOT NULL,
  `recommendation` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taskdata`
--

LOCK TABLES `taskdata` WRITE;
/*!40000 ALTER TABLE `taskdata` DISABLE KEYS */;
/*!40000 ALTER TABLE `taskdata` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tasks` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `taskowner` varchar(100) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `fromdate` varchar(100) NOT NULL,
  `todate` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `priority` varchar(100) NOT NULL,
  `notification` varchar(100) NOT NULL DEFAULT 'yes',
  `repeated` varchar(100) NOT NULL DEFAULT 'no',
  `comments` text NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `category` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `branchid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasks`
--

LOCK TABLES `tasks` WRITE;
/*!40000 ALTER TABLE `tasks` DISABLE KEYS */;
/*!40000 ALTER TABLE `tasks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tasktype`
--

DROP TABLE IF EXISTS `tasktype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `tasktype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` text NOT NULL,
  `name` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tasktype`
--

LOCK TABLES `tasktype` WRITE;
/*!40000 ALTER TABLE `tasktype` DISABLE KEYS */;
INSERT INTO `tasktype` VALUES (1,'','TECHNICAL','2018-10-18 17:40:27','active','1','','1');
/*!40000 ALTER TABLE `tasktype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `taskupdates`
--

DROP TABLE IF EXISTS `taskupdates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `taskupdates` (
  `id` int(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `date` varchar(50) NOT NULL,
  `nextstep` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'newstock',
  `type` text NOT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `taskupdates`
--

LOCK TABLES `taskupdates` WRITE;
/*!40000 ALTER TABLE `taskupdates` DISABLE KEYS */;
/*!40000 ALTER TABLE `taskupdates` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `types`
--

DROP TABLE IF EXISTS `types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `types` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `types`
--

LOCK TABLES `types` WRITE;
/*!40000 ALTER TABLE `types` DISABLE KEYS */;
/*!40000 ALTER TABLE `types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uom`
--

DROP TABLE IF EXISTS `uom`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `uom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `code` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uom`
--

LOCK TABLES `uom` WRITE;
/*!40000 ALTER TABLE `uom` DISABLE KEYS */;
INSERT INTO `uom` VALUES (1,'Piece','pc','2018-11-20 09:12:47','active','1','','1','hlf'),(2,'No Units','No Units','2018-03-29 06:40:47am','active','1','','1','NOU'),(3,'Dozen','Dozen','2018-03-29 06:42:29am','active','1','','1','dz'),(4,'Bar','Bar','2018-03-29 06:43:15am','active','1','','1','BR'),(5,'Packets','Packets','2018-03-29 06:36:08am','active','1','','1','pcks'),(6,'Kilograms','Kilograms','2018-03-29 07:14:40am','active','1','','1','Kg'),(7,'Litre','Litre','2018-03-29 07:14:57am','active','1','','1','ltr'),(8,'Half ','hlf','2018-03-30 12:34:29pm','active','1','','1','pcs'),(9,'sheet','','2018-03-30 12:35:21pm','active','1','','1','sht'),(10,'Bale','','2018-03-30 12:40:40pm','active','1','','1','BL'),(11,'Box','','2018-03-30 12:40:58pm','active','1','','1','bx'),(12,'full','','2018-08-04 11:35:29am','active','1','','1','full'),(13,'refill','','2018-08-04 11:36:06am','active','1','','1','ref'),(14,'1/4','','2018-11-20 09:14:48','active','1','','1','16');
/*!40000 ALTER TABLE `uom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `uomproducts`
--

DROP TABLE IF EXISTS `uomproducts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `uomproducts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uom` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `code` varchar(30) NOT NULL,
  `branch` varchar(30) NOT NULL,
  `qty` int(30) NOT NULL,
  `price` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `uomproducts`
--

LOCK TABLES `uomproducts` WRITE;
/*!40000 ALTER TABLE `uomproducts` DISABLE KEYS */;
INSERT INTO `uomproducts` VALUES (2,'16','2018-11-20 09:15:34','active','1','','1','300000','1',1,'175'),(3,'hlf','2018-11-20 09:15:46','active','1','','1','300000','1',2,'350'),(4,'Kg','2018-11-20 09:16:03','active','1','','1','300000','1',4,'700');
/*!40000 ALTER TABLE `uomproducts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(30) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `username` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `gender` varchar(50) NOT NULL,
  `county` varchar(50) NOT NULL,
  `createddate` varchar(50) NOT NULL,
  `password` varchar(30) NOT NULL,
  `province` varchar(50) NOT NULL,
  `dob` varchar(50) NOT NULL,
  `idno` varchar(50) NOT NULL,
  `photo` text NOT NULL,
  `box` varchar(50) NOT NULL,
  `code` varchar(50) NOT NULL,
  `town` varchar(50) NOT NULL,
  `country` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `totalsms` varchar(40) NOT NULL DEFAULT '10',
  `apiaccount_id` varchar(30) NOT NULL DEFAULT '1',
  `recoverpassword` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT '1',
  `service` varchar(100) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `usertype` varchar(100) NOT NULL DEFAULT 'user',
  `smstype` varchar(50) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Robisearch','Robisearch LTD','','robisearch@gmail.com','0780655987','female','','2019-02-04','12345678','','','','','','','','','2019-02-02','4','1','','1','yes','1','admin','1'),(2,'George','Kim','','gkimani668@gmail.com','0722511607','male','','2019-02-09','gkimani866','','','00000000','','','','','','','10','1','','1','no','1','user','1');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-06-30 18:32:12