...

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: robisear_robiposhotel
-- ------------------------------------------------------
-- 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 `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 AUTO_INCREMENT=3 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 */;
INSERT INTO `announcement` VALUES (1,'National Exam','Primary and Secondary','All rules must be athered to','6/11/2016','active','advert'),(2,'Opportunity','all','New jobs available','4/11/2016','active','announcement');
/*!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 `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,'Shop','','2018-03-06 19:44:07pm','active','1','','1');
/*!40000 ALTER TABLE `branch` 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=4 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,'Everyone','','2017-12-08 06:23:45am','active','1','','1'),(2,'Customers','','2018-03-26 13:00:41pm','active','1','','1'),(3,'staff','','2018-03-26 13:00:49pm','active','1','','1');
/*!40000 ALTER TABLE `category` 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,
  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 `collection`
--

LOCK TABLES `collection` WRITE;
/*!40000 ALTER TABLE `collection` DISABLE KEYS */;
INSERT INTO `collection` VALUES (1,'2018-03-22 18:54:49pm','','11521733921','1500','','400','1','1'),(2,'2018-03-22 18:55:05pm','','11521733921','400','','0','1','1');
/*!40000 ALTER TABLE `collection` 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 `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,
  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,
  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 `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,
  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 `expenses`
--

LOCK TABLES `expenses` WRITE;
/*!40000 ALTER TABLE `expenses` DISABLE KEYS */;
INSERT INTO `expenses` VALUES (1,'','1','2000','','2018-05-22 05:24:54am','robisear','active','2018-05-22 05:24:41','','26476372','254746297242','Robert','','1484581526955881','1','','7','1','EXP-11526955881'),(2,'','1','2000','','2018-05-24 05:20:19am','plumprop','active','2018-05-22 05:25:09','','26476372','254746297242','Robert','','','1','','4','1','EXP-11526955909'),(3,'','1','2000','all','2018-05-24 05:35:54am','robisear','active','2018-05-24 05:35:21','','26476372','254746297242','Robert','','9008531527129321','1','','8','1','EXP-11527129321'),(4,'','1','600','all','2018-05-24 05:37:50am','robisear','active','2018-05-24 05:37:23','','26476372','254746297242','Robert','','2949131527129443','1','','4','1','EXP-11527129443');
/*!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 `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` text NOT NULL,
  `accountstatus` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `number` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 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 (4,'1','1','6','PETTY CASH','','2018-03-23 04:42:18','','Active','0','2018-03-23 04:42:55am','123234241'),(5,'1','1','5','SALES ','','2018-03-23 04:44:06','','Active','4000','2018-03-23 04:44:42am','0008'),(6,'1','1','3','TRANSPORT','','2018-03-23 04:44:42','','Active','5000','2018-03-23 04:45:19am','003'),(7,'1','1','6','ROBISEARCH LTD','','2018-03-23 04:45:20','KCB BANK','Active','40000000','2018-03-23 04:46:20am','12323424'),(8,'1','1','6','MPESA-ROBISEARCH','','2018-03-31 13:38:42','','Active','90000','2018-03-31 13:40:10pm','717475'),(9,'1','1','5','ROBISEARCH LTD','7','2018-05-22 05:22:10','','Active','0','2018-05-22 05:22:26am','21312424');
/*!40000 ALTER TABLE `glaccounts` 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 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 */;
/*!40000 ALTER TABLE `grouping` 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 `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 AUTO_INCREMENT=2 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 */;
INSERT INTO `loyalitycards` VALUES (1,80000.00,3,0,'','','1','2018-03-26 14:28:14pm','','1','0000785');
/*!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(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 `maincategory`
--

LOCK TABLES `maincategory` WRITE;
/*!40000 ALTER TABLE `maincategory` DISABLE KEYS */;
INSERT INTO `maincategory` VALUES (1,'KITCHEN','KITCHEN','2018-05-30 12:02:09pm','active','1','','1'),(2,'BARISTAR','','2018-05-30 12:02:20pm','active','1','','1'),(3,'PREPARED FOODS','','2018-05-30 12:02:30pm','active','1','','1');
/*!40000 ALTER TABLE `maincategory` 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 ('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'),('Cashier Sales',26,'folder-open','cashiersales','1','user/mysales','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'),('Sales Display Report',24,'folder-open','displayreport','1','user/displayreport','side'),('Documents',14,'folder-open-o','documents','0','user/viewdocuments','side'),('Events',10,'line-chart','events','0','user/viewevents','side'),('Grouping Members',20,'paper-plane','grouping','0','user/viewgrouping','side'),('Income/Expenses',40,'window-close','incomeexpenses','1','user/viewexpenses','side'),('Incoming stock',60,'sort-amount-asc','incomingstock','1','user/viewincomingstock','side'),('Low Products',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'),('Stock List',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','0','user/viewsms','side'),('Tasks',12,'bullseye','task','0','user/viewtasks','side'),('Tasks Category',13,'birthday-cake','taskscategory','0','user/viewtaskcategory','side'),('Users',75,'rss-square','users','1','user/viewemployee','side'),('Return/RePrint Sales',16,'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','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','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),('addstock','productlist','Add stock',4),('addstock','products','addstock',4),('all','cashiersales','View all Cashier sales',4),('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),('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','cashiersales','Delete Sales',4),('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','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),('deleteglaccount','accounting','Delete GL Account',4),('deleteorder','products','Delete Order',5),('discount','sales','Print Discount',5),('dispatch','products','Dispatch Products',6),('download','reports','download',2),('editsellingprice','sales','Change Selling Price',7),('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),('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),('sale','sales','sale',4),('sale','wholesale','sale',0),('select','sales','Select Customers',5),('transfer','productlist','Transfer Products',3),('update','bankdeposits','update',2),('update','branch','Update Branch',3),('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),('updatepaymentmode','sales','Update Payment Mode',7),('updatesellingprice','purchases','update selling price',5),('view','branch','View Branch',2),('view','displayreport','Display Report',1),('view','lowstocklist','View',6),('view','productlist','View Products',5),('view','reports','view',1),('View Accounting','accounting','view',1),('viewall','reports','View all Branches',6),('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 `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` varchar(50) 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` varchar(30) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 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,'','1','10','2018-05-12 09:24:05am','','1','newstock','1','234324','multiple','1450','','1','','','','14'),(2,'','1','12','2018-05-12 09:24:14am','','1','newstock','1','234324','multiple','125','','1','','','','34'),(3,'','250ml','12','2018-05-14 09:31:04am','','1','newstock','1','','multiple','30','','1','','Main','branch','205'),(4,'','250ml','10','2018-05-14 09:31:41am','','1','newstock','1','','multiple','30','','1','','Main','branch','205'),(5,'','250ml','800','2018-05-14 09:32:01am','','1','newstock','1','','multiple','30','','1','','Main','branch','205'),(6,'','250ml','20','2018-05-31 16:02:52pm','','1','newstock','1','','1','30','','1','','Main','branch','205'),(7,'','250ml','55','2018-05-31 16:05:34pm','','1','newstock','1','','1','30','','1','','Main','branch','205'),(8,'penasol selection','','1000','2018-06-02 17:57 02pm','','1','newstock','1','','','','','1','','supplier','Branch','2031');
/*!40000 ALTER TABLE `newstock` 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 AUTO_INCREMENT=2 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 */;
INSERT INTO `outgoingstock` VALUES (1,'J.P. CHENET','store to kitchen','8','2018-05-12 09:16 46am','189','1','newstock','1','','','','','store','robet');
/*!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 08: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` varchar(50) 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,'ISHIMWE','','+254718667391','oukobert@gmail.com','','','Rongo','4040','1','',NULL,'supplier','1','Robisearch','','','','','1','2018-05-01 07:48:15am','','1',''),(2,'1680','','718667391','oukobert@gmail.com','385','','Rongo','4040','1','1680 BAR & GRILL 	\r\n254746297242	 		\r\n1680africa@protonmail.com 	\r\nrobisearch@gmail.com www.robisearch.com 	 \r\nwww.shujaawangu.com KCB CAPITAL HILL	 		\r\nACC NO, 1171211120		 	\r\nPAY BILL NO, 717475 	\r\n',NULL,'member','1','Robisearch','','','','','1','2018-05-12 09:09:13am','','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 ('accounting',1),('bankdeposits',1),('branch',1),('cashiersales',1),('cashiersales',2),('config',1),('damagedproducts',1),('displayreport',1),('incomeexpenses',1),('incomingstock',1),('lowproducts',1),('lowstocklist',1),('loyalitycards',1),('members',1),('password',1),('password',2),('peoplecategory',1),('productlist',1),('products',1),('productscategory',1),('profile',1),('purchases',1),('reports',1),('sales',1),('users',1),('viewreturnsales',1),('viewreturnsales',2),('wholesale',1);
/*!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` (
  `moduleid` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `actionid` varchar(100) NOT NULL,
  `id` int(50) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=568 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 ('sales','1','add',421),('sales','1','update',422),('sales','1','delete',423),('sales','1','sale',424),('sales','1','discount',425),('sales','1','Logout',426),('sales','1','reprint',427),('sales','1','select',428),('sales','1','printbill',429),('sales','1','order',430),('sales','1','productdiscount',431),('sales','1','mpesa',432),('sales','1','closebill',433),('sales','1','editsellingprice',434),('sales','1','updatepaymentmode',435),('sales','1','card',436),('sales','1','clearpayments',437),('sales','1','cheque',438),('sales','1','creditnote',439),('sales','1','points',440),('sales','1','voucher',441),('sales','1','credit',442),('wholesale','1','sale',443),('wholesale','1','add',444),('wholesale','1','delete',445),('wholesale','1','update',446),('peoplecategory','1','add',447),('peoplecategory','1','update',448),('peoplecategory','1','delete',449),('branch','1','add',450),('branch','1','view',451),('branch','1','update',452),('branch','1','delete',453),('members','1','add',454),('members','1','update',455),('users','1','add',456),('users','1','update',457),('users','1','delete',458),('users','1','deleteallroles',459),('productscategory','1','add',460),('productscategory','1','update',461),('productscategory','1','delete',462),('productlist','1','bulk',463),('productlist','1','more',464),('productlist','1','transfer',465),('productlist','1','addstock',466),('productlist','1','delete',467),('productlist','1','view',468),('productlist','1','update',469),('productlist','1','add',470),('products','1','add',471),('products','1','update',472),('products','1','delete',473),('products','1','addstock',474),('products','1','more',475),('products','1','bulk',476),('products','1','deleteorder',477),('products','1','removestock',478),('products','1','dispatch',479),('products','1','price',480),('products','1','removeallstock',481),('incomingstock','1','add',482),('incomingstock','1','update',483),('incomingstock','1','delete',484),('lowstocklist','1','add',485),('lowstocklist','1','more',486),('lowstocklist','1','view',487),('lowproducts','1','add',488),('lowproducts','1','update',489),('accounting','1','View Accounting',490),('accounting','1','deletebank',491),('accounting','1','deleteglaccount',492),('damagedproducts','1','add',493),('damagedproducts','1','update',494),('damagedproducts','1','delete',495),('purchases','1','add',496),('purchases','1','update',497),('purchases','1','delete',498),('purchases','1','updatebuyingprice',499),('purchases','1','updatesellingprice',500),('purchases','1','updateclosedinvoice',501),('incomeexpenses','1','add',502),('incomeexpenses','1','update',503),('bankdeposits','1','add',504),('bankdeposits','1','update',505),('bankdeposits','1','delete',506),('loyalitycards','1','add',507),('loyalitycards','1','update',508),('cashiersales','1','all',509),('cashiersales','1','delete',510),('cashiersales','1','cashiersales',511),('reports','1','view',512),('reports','1','download',513),('reports','1','delete',514),('reports','1','update',515),('reports','1','viewall',516),('displayreport','1','view',517),('viewreturnsales','1','add',518),('viewreturnsales','1','update',519),('viewreturnsales','1','delete',520),('viewreturnsales','1','return',521),('viewreturnsales','1','clear',522),('viewreturnsales','1','moresales',523),('password','1','change',524),('profile','1','update',525),('config','1','delete',526),('config','1','add',527),('config','1','update',528),('sales','2','add',548),('sales','2','update',549),('sales','2','sale',550),('sales','2','Logout',551),('sales','2','reprint',552),('sales','2','select',553),('sales','2','printbill',554),('sales','2','order',555),('sales','2','mpesa',556),('sales','2','closebill',557),('cashiersales','2','all',558),('cashiersales','2','delete',559),('cashiersales','2','cashiersales',560),('viewreturnsales','2','add',561),('viewreturnsales','2','update',562),('viewreturnsales','2','delete',563),('viewreturnsales','2','return',564),('viewreturnsales','2','clear',565),('viewreturnsales','2','moresales',566),('password','2','change',567);
/*!40000 ALTER TABLE `permissionsactions` 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` text NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `maincategory` varchar(30) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `updatedate` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 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,'BREAKFAST','BREAKFAST','active','1','1','1','',''),(2,'BREADSHOP','BREADSHOP','active','1','1','1','',''),(3,'JUICES','JUICES','active','2','1','1','',''),(4,'BAKESHOP','BAKESHOP','active','2','1','1','',''),(5,'HEALTHY JUICES','','active','2','1','1','',''),(6,'COLD DRINKS','','active','2','1','1','',''),(7,'SODA / WATER','','active','2','1','1','',''),(8,'MILK SHAKES','','active','2','1','1','',''),(9,'HOT DRINKS','','active','2','1','1','',''),(10,'SMOOTHIES','','active','2','1','1','',''),(11,'ICE CREAM','','active','2','1','1','',''),(12,'SALADS','','active','1','1','1','',''),(13,'SANDWICHES','','active','1','1','1','',''),(14,'BURGERS','','active','1','1','1','',''),(15,'MAINDISHES','','active','1','1','1','',''),(16,'SIDE DISHES','','active','1','1','1','',''),(17,'PIZZA','','active','1','1','1','',''),(18,'PASTAR','','active','1','1','1','',''),(19,'ADD','','active','1','1','1','',''),(20,'WRAPS','','active','1','1','1','',''),(21,'SIDES','','active','1','1','1','',''),(22,'SOUP','','active','1','1','1','',''),(23,'SIDES AND FRIES','','active','1','1','1','',''),(24,'APPETIZERS','','active','1','1','1','',''),(25,'COOKIES','','active','3','1','1','',''),(26,'SNACKS','','active','3','1','1','',''),(27,'PASTRY','','active','2','1','1','',''),(28,'PIE','','active','3','1','1','',''),(29,'BREADS','','active','3','1','1','',''),(30,'apple','','active','2','1','1','2018-07-09 15:29:10pm','');
/*!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` varchar(50) 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',
  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=272 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,'name','category','supplier','description',16,'buyingprice','sellingprice','h sale','h sale',NULL,NULL,'reorderevel',0,0,NULL,0,0,0,10000.00,'','1','1','branch','','','','active','','code','pcs'),(2,'FRUIT SALAD','1','1','',16,'170','320','320','320',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','1','pcs'),(3,'FRUIT SALAD YHN','1','1','',16,'225','450','450','450',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','2','pcs'),(4,'FRENCH TOAST','1','1','',16,'200','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','3','pcs'),(5,'PANCAKES','1','1','',16,'240','480','480','480',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','4','pcs'),(6,'WAFFLES','1','1','',16,'220','540','540','540',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','5','pcs'),(7,'POTATO BRAVAS','1','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','6','pcs'),(8,'CHILAQUILES','1','1','',16,'125','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','7','pcs'),(9,'MEXICAN BOWL','1','1','',16,'340','680','680','680',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','8','pcs'),(10,'BREAKFAST COMBO','1','1','',16,'300','750','750','750',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','9','pcs'),(11,'BURGER BUNS','2','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','10','pcs'),(12,'FOCCACIA BREAD','2','1','',16,'60','120','120','120',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','11','pcs'),(13,'PITA BREAD','2','1','',16,'75','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','12','pcs'),(14,'BAGUETTE','2','1','',16,'80','160','160','160',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','13','pcs'),(15,'BAGUETTE 12','2','1','',16,'50','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','14','pcs'),(16,'MINI BAGUETTE 6','2','1','',16,'30','60','60','60',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','15','pcs'),(17,'CIABATTA BREAD','2','1','',16,'75','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','16','pcs'),(18,'WHITE SOUR DOUGH','2','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','17','pcs'),(19,'PASSION JUICE','3','1','',16,'115','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','18','pcs'),(20,'MANGO JUICE','3','1','',16,'115','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','19','pcs'),(21,'PINEAPPLE JUICE','3','1','',16,'115','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','20','pcs'),(22,'MELONE JUICE','3','1','',16,'115','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','21','pcs'),(23,'ORANGE JUICE','3','1','',16,'115','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','22','pcs'),(24,'COCKTAIL JUICE','3','1','',16,'115','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','23','pcs'),(25,'ASSORTED SCONES','4','1','',16,'85','170','170','170',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','24','pcs'),(26,'PLAIN CROISANT','4','1','',16,'75','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','25','pcs'),(27,'CHOCOLATE CROISANT','4','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','26','pcs'),(28,'DANISH PASTRY','4','1','',16,'100','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','27','pcs'),(29,'hazelnut cake','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','28','pcs'),(30,'BLACK FOREST','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','29','pcs'),(31,'WHITE FORESTCAKE','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','30','pcs'),(32,'CHOCOLATE FUDGE CAKE','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','31','pcs'),(33,'CHOCOLATE TRUFFLE','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','32','pcs'),(34,'AFTER EIGHT','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','33','pcs'),(35,'ORANGE & ALMOND TEMPTATION','4','1','',16,'200','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','34','pcs'),(36,'DEATH BY CHOCOLATE','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','35','pcs'),(37,'TIRAMISU','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','36','pcs'),(38,'PINACOLADA','4','1','',16,'175','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','37','pcs'),(39,'CARROT CAKE','4','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','38','pcs'),(40,'MADEIRA','4','1','',16,'75','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','39','pcs'),(41,'MARBLE CAKE','4','1','',16,'75','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','40','pcs'),(42,'CHOCOLATE BROWNIE','4','1','',16,'100','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','41','pcs'),(43,'CHOCOLATE DONUTS','4','1','',16,'50','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','42','pcs'),(44,'BANANA MUFFIN','4','1','',16,'90','180','180','180',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','43','pcs'),(45,'CHOC CHIP MUFFIN','4','1','',16,'75','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','44','pcs'),(46,'MADELINE','4','1','',16,'90','180','180','180',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','45','pcs'),(47,'POWER UP','5','1','',16,'170','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','46','pcs'),(48,'DETOX','5','1','',16,'170','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','47','pcs'),(49,'BERRY SUPREME','5','1','',16,'170','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','48','pcs'),(50,'ICED COFFEE','6','1','',16,'120','240','240','240',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','49','pcs'),(51,'ICED TEA','6','1','',16,'120','240','240','240',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','50','pcs'),(52,'ICED LEMON & GINGER','6','1','',16,'120','240','240','240',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','51','pcs'),(53,'ICED HERBAL TEA','6','1','',16,'120','240','240','240',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','52','pcs'),(54,'ICED FRUIT TEA ','6','1','',16,'150','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','53','pcs'),(55,'ICED VANILLA LATTE','6','1','',16,'165','330','330','330',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','54','pcs'),(56,'ICED MOCHA','6','1','',16,'170','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','55','pcs'),(57,'REGULAR LEMONADE','6','1','',16,'105','210','210','210',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','56','pcs'),(58,'ORANGE LEMONADE','6','1','',16,'110','220','220','220',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','57','pcs'),(59,'BERRY BERRY LEMONADE','6','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','58','pcs'),(60,'FIZZY GINGER LEMONADE','6','1','',16,'0','230','230','230',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','59','pcs'),(61,'MINERAL WATER 500ML','7','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','61','pcs'),(62,'MINERAL WATER 1ltre','7','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','62','pcs'),(63,'MANGO','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','63','pcs'),(64,'CHOCOLATE CHIP','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','64','pcs'),(65,'BANANA','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','65','pcs'),(66,'VANILLA','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','66','pcs'),(67,'STRAWBERRY','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','67','pcs'),(68,'CHOCOLATE','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','68','pcs'),(69,'MOCHA','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','69','pcs'),(70,'DOUBLE ESPRESSO','8','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','70','pcs'),(71,'HOUSE COFFE(single)','8','1','',16,'0','160','160','160',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','71','pcs'),(72,'HOUSE COFFE(double)','9','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','72','pcs'),(73,'ESPRESSO(single)','9','1','',16,'0','160','160','160',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','73','pcs'),(74,'ESPRESSO(double)','9','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','74','pcs'),(75,'MACCHIATO(single)','8','1','',16,'0','180','180','180',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','75','pcs'),(76,'MACCHIATO(double)','9','1','',16,'0','210','210','210',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','76','pcs'),(77,'AMERICANO(single)','9','1','',16,'0','180','180','180',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','77','pcs'),(78,'AMERICANO(double)','9','1','',16,'0','220','220','220',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','78','pcs'),(79,'CAPPUCCINO(single)','9','1','',16,'0','210','210','210',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','79','pcs'),(80,'CAPPUCCINO(double)','9','1','',16,'0','270','270','270',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','80','pcs'),(81,'CAFFE LATTE(single)','9','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','81','pcs'),(82,'CAFFE LATTE(double)','9','1','',16,'0','290','290','290',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','82','pcs'),(83,'VANILLA LATTE(single)','9','1','',16,'0','270','270','270',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','83','pcs'),(84,'VANILLA LATTE(double)','9','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','84','pcs'),(85,'MOCHA(single)','9','1','',16,'0','270','270','270',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','85','pcs'),(86,'MOCHA(double)','9','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','86','pcs'),(87,'FLAVOURE SYRUP','9','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','87','pcs'),(88,'SHOT ESPRESSO','9','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','89','pcs'),(89,'HOT CHOCOLATE(single)','9','1','',16,'0','240','240','240',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','90','pcs'),(90,'HOT CHOCOLATE(double)','8','1','',16,'0','270','270','270',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','91','pcs'),(91,'REGULAR TEA(single)','9','1','',16,'0','170','170','170',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','92','pcs'),(92,'REGULAR TEA(double)','9','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','93','pcs'),(93,'MASALA TEA(single)','9','1','',16,'0','170','170','170',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','94','pcs'),(94,'MASALA TEA(double)','9','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','95','pcs'),(95,'HERBAL TEA(single)','9','1','',16,'0','220','220','220',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','96','pcs'),(96,'HERBAL TEA(double)','9','1','',16,'0','260','260','260',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','97','pcs'),(97,'HOT LEMON & GINGER','9','1','',16,'0','220','220','220',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','98','pcs'),(98,'BANANA-BLUEBERRY','10','1','',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','99','pcs'),(99,'STRAWBERRY','10','1','',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','100','pcs'),(100,'JUST FRUTTI','10','1','',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','101','pcs'),(101,'MANGO MADNESS','10','1','0',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','102','pcs'),(102,'PINEAPPLE GREEN','10','1','',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','103','pcs'),(103,'CARROT & ORANGE','10','1','',16,'0','320','320','320',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','104','pcs'),(104,'THE WINDMILL TROPICAL','10','1','',16,'0','340','340','340',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','105','pcs'),(105,'VANILLA','11','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','106','pcs'),(106,'STRAWBERRY','11','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','107','pcs'),(107,'CHOCOLATE ','11','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','108','pcs'),(108,'BANANA SPLIT','11','1','',16,'0','490','490','490',NULL,NULL,'0',0,0,NULL,0,0,0,9998.00,'','1','1','1','','','','active','','109','pcs'),(109,'GARDEN SALAD','12','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','110','pcs'),(110,'CAESAR SALAD','12','1','',16,'0','550','550','550',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','111','pcs'),(111,'THE WINDMILL','12','1','',16,'0','500','500','500',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','112','pcs'),(112,'PANZANELLA','12','1','',16,'0','550','550','550',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','113','pcs'),(113,'CHOPPPED KALE SALAD','12','1','',16,'0','580','580','580',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','114','pcs'),(114,'CAPRESE SALAD','12','1','',16,'0','610','610','610',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','115','pcs'),(115,'THE REUBEN','13','1','',16,'0','620','620','620',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','116','pcs'),(116,'GRILLED CHEESE & TOMATO','13','1','',16,'0','520','520','520',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','117','pcs'),(117,'SPICED TOFU & ROASTED VEG','13','1','',16,'0','550','550','550',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','118','pcs'),(118,'FALAFEL SWITCH','13','1','',16,'0','580','580','580',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','119','pcs'),(119,'AVOCADO VEGGIE','13','1','',16,'0','480','480','480',NULL,NULL,'0',0,0,NULL,0,0,0,9998.00,'','1','1','1','','','','active','','120','pcs'),(120,'MUSHROOM MELT','13','1','',16,'0','580','580','580',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','121','pcs'),(121,'GRILLED VEG BURGER','14','1','',16,'0','620','620','620',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','122','pcs'),(122,'CAJUN BEAN BURGER','14','1','',16,'0','630','630','630',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','123','pcs'),(123,'KARMA BURGER','14','1','',16,'0','630','630','630',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','124','pcs'),(124,'PANEER BURGER ','14','1','',16,'0','650','650','650',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','125','pcs'),(125,'VEGETABLE CURRY','15','1','',16,'0','750','750','750',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','126','pcs'),(126,'THAI BASIL STIR FRY','15','1','',16,'0','560','560','560',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','127','pcs'),(127,'VEG & CHEESE ','15','1','',16,'0','650','650','650',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','128','pcs'),(128,'AVOCADO & BEAN BURRITO','15','1','',16,'0','680','680','680',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','129','pcs'),(129,'STEAMED RICE','16','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','130','pcs'),(130,'SOUR CREAM','16','1','',16,'0','90','90','90',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','131','pcs'),(131,'SALSA','16','1','',16,'0','90','90','90',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','132','pcs'),(132,'JALAPENOS','16','1','',16,'0','120','120','120',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','133','pcs'),(133,'GUACAMOLE ','16','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','134','pcs'),(134,'CHEESE','16','1','',16,'0','130','130','130',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','135','pcs'),(135,'MEXICAN RICE','16','1','',16,'0','180','180','180',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','136','pcs'),(136,'REFRIED BEANS ','16','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','137','pcs'),(137,'MARGHERITA PIZZA','17','1','',16,'0','850','850','850',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','138','pcs'),(138,'PUNJAB EXPRESS','17','1','',16,'O','900','900','900',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','139','pcs'),(139,'BBQ TOFU','17','1','',16,'0','950','950','950',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','140','pcs'),(140,'FUNGHI','17','1','',16,'0','980','980','980',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','141','pcs'),(141,'FOUR SEASONS ','17','1','',16,'0','1050','1050','1050',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','142','pcs'),(142,'SPICY CHIC PEA','18','1','',16,'0','800','800','800',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','143','pcs'),(143,'FETTUCINE ALFREDO','18','1','',16,'0','750','750','750',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','144','pcs'),(144,'SPINACH & MASHROOM','18','1','',16,'0','900','900','900',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','145','pcs'),(145,'MAC N CHEESE','18','1','',16,'0','750','750','750',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','146','pcs'),(146,'EGGPLANT PARMIGIANO','18','1','',16,'0','750','750','750',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','147','pcs'),(147,'VEGGIE TOPPING','19','1','',16,'0','90','90','90',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','148','pcs'),(148,'CHHEESE','19','1','',16,'0','120','120','120',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','149','pcs'),(149,'THAI SPINCH','20','1','',16,'0','580','580','580',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','150','pcs'),(150,'SANTA FE FALAFEL','20','1','',16,'0','600','600','600',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','151','pcs'),(151,'CHILI PANEER','20','1','',16,'0','600','600','600',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','152','pcs'),(152,'CREAM OF MASHROOM ','22','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','153','pcs'),(153,'TOMATO & SPINACH','22','1','',16,'0','380','380','380',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','154','pcs'),(154,'CREAMED SPINACH','23','1','',16,'0','280','280','280',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','155','pcs'),(155,'SAUTEED VEGATABLES','23','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','156','pcs'),(156,'POUTINE FRIES','23','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','157','pcs'),(157,'PAUSINE GARLIC FRIES','23','1','',16,'0','280','280','280',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','158','pcs'),(158,'WINDMILL FRIES ','23','1','',16,'0','220','220','220',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','159','pcs'),(159,'SWEET POTATO','23','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','160','pcs'),(160,'MUSHROOM FRIES ','23','1','',16,'0','380','380','380',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','161','pcs'),(161,'MASALA FRIES','23','1','',16,'0','330','330','330',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','162','pcs'),(162,'CURRY FRIES ','23','1','',16,'0','330','330','330',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','163','pcs'),(163,'PATATA BRAVAS','24','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','164','pcs'),(164,'SAMOSA ','24','1','',16,'0','210','210','210',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','165','pcs'),(165,'THAI VEG SPRING BALLS','24','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','166','pcs'),(166,'NACHOS','24','1','',16,'0','320','320','320',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','167','pcs'),(167,'MOZZARELLA STICKS','24','1','',16,'0','320','320','320',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','168','pcs'),(168,'SPINACH & RICOTTA','24','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','169','pcs'),(169,'TEX-MEX POATO SKIN','24','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','170','pcs'),(170,'SEV BUBDI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','171','pcs'),(171,'COKE','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','172','pcs'),(172,'SPRITE','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','173','pcs'),(173,'FANTA','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','174','pcs'),(174,'SODA WATER','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','175','pcs'),(175,'GINGERALE','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','176','pcs'),(176,'DIET COKE','7','1','',16,'0','150','150','150',NULL,NULL,'10',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','177','pcs'),(177,'STONEY','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','178','pcs'),(178,'COKE ZERO','7','1','',16,'0','150','150','150',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','179','pcs'),(179,'TONIC','7','1','',16,'0','100','100','100',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','180','pcs'),(180,'MINERAL WATER(500ml)','7','1','',16,'0','100','100','100',NULL,NULL,'20',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','181','pcs'),(181,'MINERAL WATER 1ltre','7','1','',16,'0','200','200','200',NULL,NULL,'10',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','182','pcs'),(182,'PEANUTS CHIKKI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','183','pcs'),(183,'SESAME PEANUTS','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','184','pcs'),(184,'CHAKKRI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','185','pcs'),(185,'SEV','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','186','pcs'),(186,'DRY SAMOSA','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','187','pcs'),(187,'DAL SMUTH','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','188','pcs'),(188,'CHEVDA','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','189','pcs'),(189,'BUNDI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','190','pcs'),(190,'SEV BUNDI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','191','pcs'),(191,'BANANA CRISPS','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','192','pcs'),(192,'POTATO CRISPS','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','193','pcs'),(193,'CHILLY POTATO CRISPS','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','194','pcs'),(194,'SEV MAMRA','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','195','pcs'),(195,'SEV MAMRA CHILLY','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','196','pcs'),(196,'ROASTED SOYA BEANS','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','197','pcs'),(197,'ROASTED PEANUTS','26','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','198','pcs'),(198,'ROASTED GRAMS','26','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','199','pcs'),(199,'CHEESE STICKS','26','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','200','pcs'),(200,'CINNAMON STICKS','26','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','201','pcs'),(201,'SIMSIM DRY STICKS','26','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','202','pcs'),(202,'PLAIN DRY STICK','26','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','203','pcs'),(203,'SWEET CINABON PUFF','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','204','pcs'),(204,'CAKE RUSK','26','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','205','pcs'),(205,'TORTILA CHIPS','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','207','pcs'),(206,'METHI MASALA PUFF','25','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','206','pcs'),(207,'SESAME CHAKRI','26','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','208','pcs'),(208,'NAN KATAI','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','209','pcs'),(209,'DATES & NUTS','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','210','pcs'),(210,'BRAZZILLIAN NUTS','25','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','211','pcs'),(211,'CHOCOLATE FINGERS','25','1','',16,'0','500','500','500',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','212','pcs'),(212,'HOME MADE COOKIES','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','213','pcs'),(213,'PIN WHEEL','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','214','pcs'),(214,'CHOC OATS & NUTS','25','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','215','pcs'),(215,'OATS & COCONUT','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','216','pcs'),(216,'PALMIERS','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','217','pcs'),(217,'VIENES COOKIES','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','218','pcs'),(218,'GLUTEN FREE COOKIES','25','1','',16,'0','500','500','500',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','219','pcs'),(219,'DIABETIC OATS & COCONUT COOKIES','25','1','',16,'0','450','450','450',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','220','pcs'),(220,'DIABETIC VIENIES COOKIES','25','1','',16,'0','450','450','450',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','221','pcs'),(221,'CHOC-CHIP ','25','1','',16,'0','400','400','400',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','222','pcs'),(222,'CHERRY NUT ','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','223','pcs'),(223,'JAM & COCONUT ','25','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','224','pcs'),(224,'PANI PURI','27','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','225','pcs'),(225,'PLAIN PUFF PASTRY','27','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','226','pcs'),(226,'TACOS','27','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','227','pcs'),(227,'MASALA PUFF','27','1','',16,'0','350','350','350',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','228','pcs'),(228,'JEERA PUFF PASTRY','27','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','229','pcs'),(229,'CHEESE PIE','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','230','pcs'),(230,'VEG PIE','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','231','pcs'),(231,'MUSHROOM PIE','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','232','pcs'),(232,'PANNER PIE','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','233','pcs'),(233,'CHOCOLATE DOUGHNUT','28','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','234','pcs'),(234,'CHOCOLATE CROISSANTS','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','235','pcs'),(235,'PLAIN CROISSANTS','28','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','236','pcs'),(236,'CHEESE CROISSANTS','28','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','237','pcs'),(237,'CARROT CAKE','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','238','pcs'),(238,'SPINACH & RICOTA','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','239','pcs'),(239,'PIZZA POCKET','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','240','pcs'),(240,'CINABON BUNS','28','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','241','pcs'),(241,'PLAIN TOAST','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','242','pcs'),(242,'BROWN TOAST','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','243','pcs'),(243,'DRY FRUIT TOAST','29','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','244','pcs'),(244,'CARAWAY TOAST','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','245','pcs'),(245,'BROWN SHORT BAGUETTE','29','1','',16,'0','60','60','60',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','246','pcs'),(246,'RYE BREAD DARK','29','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','247','pcs'),(247,'LIGMI RYE','29','1','',16,'0','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','248','pcs'),(248,'LONG FRENCH BAGUETTE','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','249','pcs'),(249,'SUGARFREE BROWN','29','1','',16,'0','100','100','100',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','250','pcs'),(250,'BROWN GALLATE','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','251','pcs'),(251,'WHITE GALLATE','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','252','pcs'),(252,'WHITE BUNS','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','253','pcs'),(253,'BROWN BUNS','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','254','pcs'),(254,'BROWN SOUP BUNS','29','1','',16,'0','80','80','80',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','255','pcs'),(255,'WHITE SOUP BUNS','29','1','',16,'0','80','80','80',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','256','pcs'),(256,'WHOLE MEAL','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','257','pcs'),(257,'BROWN LONG ROLLS','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,9999.00,'','1','1','1','','','','active','','258','pcs'),(258,'WHITE LONG ROLLS','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','259','pcs'),(259,'BROWN FLAT BURGER','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','260','pcs'),(260,'WHITE FLAT BURGER','29','1','',16,'0','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','261','pcs'),(261,'QUEENS CAKE','4','1','',16,'O','150','150','150',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','262','pcs'),(262,'VOL VENT MINI','27','1','',16,'0','30','30','30',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','263','pcs'),(263,'VOL VENT LARGE','27','1','',16,'0','50','50','50',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','264','pcs'),(264,'FOCCAIA','29','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','265','pcs'),(265,'PITTA BREAD','29','1','',16,'0','200','200','200',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','266','pcs'),(266,'MOUSE','29','1','',16,'0','50','50','50',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','267','pcs'),(267,'BAJRA GARLIC','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','268','pcs'),(268,'MANGAHSHI','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','269','pcs'),(269,'JIRA KHAKRA','26','1','',16,'0','300','300','300',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','270','pcs'),(270,'mouse','28','1','',16,'100','250','250','250',NULL,NULL,'0',0,0,NULL,0,0,0,10000.00,'','1','1','1','','','','active','','1001','pcs'),(271,'tomato soap','22','1','',0,'30','40','','40',NULL,NULL,'0',0,0,'8084991531139447',0,0,0,59.00,'2018-07-09 15:32:01pm','1','1','1','','0','sp','active','','8765','NOU');
/*!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` varchar(50) 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',
  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=272 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,'name','category','supplier','code','description',16,'buyingprice','sellingprice','h sale','h sale',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(2,'FRUIT SALAD','1','1','1','',16,'170','320','320','320',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(3,'FRUIT SALAD YHN','1','1','2','',16,'225','450','450','450',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(4,'FRENCH TOAST','1','1','3','',16,'200','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(5,'PANCAKES','1','1','4','',16,'240','480','480','480',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(6,'WAFFLES','1','1','5','',16,'220','540','540','540',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(7,'POTATO BRAVAS','1','1','6','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(8,'CHILAQUILES','1','1','7','',16,'125','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(9,'MEXICAN BOWL','1','1','8','',16,'340','680','680','680',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(10,'BREAKFAST COMBO','1','1','9','',16,'300','750','750','750',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(11,'BURGER BUNS','2','1','10','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(12,'FOCCACIA BREAD','2','1','11','',16,'60','120','120','120',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(13,'PITA BREAD','2','1','12','',16,'75','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(14,'BAGUETTE','2','1','13','',16,'80','160','160','160',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(15,'BAGUETTE 12','2','1','14','',16,'50','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(16,'MINI BAGUETTE 6','2','1','15','',16,'30','60','60','60',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(17,'CIABATTA BREAD','2','1','16','',16,'75','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(18,'WHITE SOUR DOUGH','2','1','17','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(19,'PASSION JUICE','3','1','18','',16,'115','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(20,'MANGO JUICE','3','1','19','',16,'115','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(21,'PINEAPPLE JUICE','3','1','20','',16,'115','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(22,'MELONE JUICE','3','1','21','',16,'115','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(23,'ORANGE JUICE','3','1','22','',16,'115','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(24,'COCKTAIL JUICE','3','1','23','',16,'115','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(25,'ASSORTED SCONES','4','1','24','',16,'85','170','170','170',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(26,'PLAIN CROISANT','4','1','25','',16,'75','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(27,'CHOCOLATE CROISANT','4','1','26','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(28,'DANISH PASTRY','4','1','27','',16,'100','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(29,'hazelnut cake','4','1','28','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(30,'BLACK FOREST','4','1','29','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(31,'WHITE FORESTCAKE','4','1','30','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(32,'CHOCOLATE FUDGE CAKE','4','1','31','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(33,'CHOCOLATE TRUFFLE','4','1','32','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(34,'AFTER EIGHT','4','1','33','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(35,'ORANGE & ALMOND TEMPTATION','4','1','34','',16,'200','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(36,'DEATH BY CHOCOLATE','4','1','35','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(37,'TIRAMISU','4','1','36','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(38,'PINACOLADA','4','1','37','',16,'175','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(39,'CARROT CAKE','4','1','38','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(40,'MADEIRA','4','1','39','',16,'75','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(41,'MARBLE CAKE','4','1','40','',16,'75','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(42,'CHOCOLATE BROWNIE','4','1','41','',16,'100','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(43,'CHOCOLATE DONUTS','4','1','42','',16,'50','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(44,'BANANA MUFFIN','4','1','43','',16,'90','180','180','180',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(45,'CHOC CHIP MUFFIN','4','1','44','',16,'75','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(46,'MADELINE','4','1','45','',16,'90','180','180','180',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(47,'POWER UP','5','1','46','',16,'170','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(48,'DETOX','5','1','47','',16,'170','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(49,'BERRY SUPREME','5','1','48','',16,'170','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(50,'ICED COFFEE','6','1','49','',16,'120','240','240','240',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(51,'ICED TEA','6','1','50','',16,'120','240','240','240',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(52,'ICED LEMON & GINGER','6','1','51','',16,'120','240','240','240',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(53,'ICED HERBAL TEA','6','1','52','',16,'120','240','240','240',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(54,'ICED FRUIT TEA ','6','1','53','',16,'150','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(55,'ICED VANILLA LATTE','6','1','54','',16,'165','330','330','330',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(56,'ICED MOCHA','6','1','55','',16,'170','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(57,'REGULAR LEMONADE','6','1','56','',16,'105','210','210','210',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(58,'ORANGE LEMONADE','6','1','57','',16,'110','220','220','220',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(59,'BERRY BERRY LEMONADE','6','1','58','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(60,'FIZZY GINGER LEMONADE','6','1','59','',16,'0','230','230','230',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(61,'MINERAL WATER 500ML','7','1','61','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(62,'MINERAL WATER 1ltre','7','1','62','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(63,'MANGO','8','1','63','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(64,'CHOCOLATE CHIP','8','1','64','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(65,'BANANA','8','1','65','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(66,'VANILLA','8','1','66','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(67,'STRAWBERRY','8','1','67','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(68,'CHOCOLATE','8','1','68','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(69,'MOCHA','8','1','69','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(70,'DOUBLE ESPRESSO','8','1','70','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(71,'HOUSE COFFE(single)','8','1','71','',16,'0','160','160','160',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(72,'HOUSE COFFE(double)','9','1','72','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(73,'ESPRESSO(single)','9','1','73','',16,'0','160','160','160',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(74,'ESPRESSO(double)','9','1','74','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(75,'MACCHIATO(single)','8','1','75','',16,'0','180','180','180',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(76,'MACCHIATO(double)','9','1','76','',16,'0','210','210','210',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(77,'AMERICANO(single)','9','1','77','',16,'0','180','180','180',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(78,'AMERICANO(double)','9','1','78','',16,'0','220','220','220',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(79,'CAPPUCCINO(single)','9','1','79','',16,'0','210','210','210',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(80,'CAPPUCCINO(double)','9','1','80','',16,'0','270','270','270',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(81,'CAFFE LATTE(single)','9','1','81','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(82,'CAFFE LATTE(double)','9','1','82','',16,'0','290','290','290',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(83,'VANILLA LATTE(single)','9','1','83','',16,'0','270','270','270',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(84,'VANILLA LATTE(double)','9','1','84','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(85,'MOCHA(single)','9','1','85','',16,'0','270','270','270',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(86,'MOCHA(double)','9','1','86','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(87,'FLAVOURE SYRUP','9','1','87','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(88,'SHOT ESPRESSO','9','1','89','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(89,'HOT CHOCOLATE(single)','9','1','90','',16,'0','240','240','240',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(90,'HOT CHOCOLATE(double)','8','1','91','',16,'0','270','270','270',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(91,'REGULAR TEA(single)','9','1','92','',16,'0','170','170','170',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(92,'REGULAR TEA(double)','9','1','93','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(93,'MASALA TEA(single)','9','1','94','',16,'0','170','170','170',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(94,'MASALA TEA(double)','9','1','95','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(95,'HERBAL TEA(single)','9','1','96','',16,'0','220','220','220',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(96,'HERBAL TEA(double)','9','1','97','',16,'0','260','260','260',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(97,'HOT LEMON & GINGER','9','1','98','',16,'0','220','220','220',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(98,'BANANA-BLUEBERRY','10','1','99','',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(99,'STRAWBERRY','10','1','100','',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(100,'JUST FRUTTI','10','1','101','',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(101,'MANGO MADNESS','10','1','102','0',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(102,'PINEAPPLE GREEN','10','1','103','',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(103,'CARROT & ORANGE','10','1','104','',16,'0','320','320','320',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(104,'THE WINDMILL TROPICAL','10','1','105','',16,'0','340','340','340',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(105,'VANILLA','11','1','106','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(106,'STRAWBERRY','11','1','107','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(107,'CHOCOLATE ','11','1','108','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(108,'BANANA SPLIT','11','1','109','',16,'0','490','490','490',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(109,'GARDEN SALAD','12','1','110','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(110,'CAESAR SALAD','12','1','111','',16,'0','550','550','550',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(111,'THE WINDMILL','12','1','112','',16,'0','500','500','500',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(112,'PANZANELLA','12','1','113','',16,'0','550','550','550',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(113,'CHOPPPED KALE SALAD','12','1','114','',16,'0','580','580','580',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(114,'CAPRESE SALAD','12','1','115','',16,'0','610','610','610',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(115,'THE REUBEN','13','1','116','',16,'0','620','620','620',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(116,'GRILLED CHEESE & TOMATO','13','1','117','',16,'0','520','520','520',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(117,'SPICED TOFU & ROASTED VEG','13','1','118','',16,'0','550','550','550',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(118,'FALAFEL SWITCH','13','1','119','',16,'0','580','580','580',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(119,'AVOCADO VEGGIE','13','1','120','',16,'0','480','480','480',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(120,'MUSHROOM MELT','13','1','121','',16,'0','580','580','580',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(121,'GRILLED VEG BURGER','14','1','122','',16,'0','620','620','620',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(122,'CAJUN BEAN BURGER','14','1','123','',16,'0','630','630','630',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(123,'KARMA BURGER','14','1','124','',16,'0','630','630','630',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(124,'PANEER BURGER ','14','1','125','',16,'0','650','650','650',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(125,'VEGETABLE CURRY','15','1','126','',16,'0','750','750','750',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(126,'THAI BASIL STIR FRY','15','1','127','',16,'0','560','560','560',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(127,'VEG & CHEESE ','15','1','128','',16,'0','650','650','650',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(128,'AVOCADO & BEAN BURRITO','15','1','129','',16,'0','680','680','680',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(129,'STEAMED RICE','16','1','130','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(130,'SOUR CREAM','16','1','131','',16,'0','90','90','90',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(131,'SALSA','16','1','132','',16,'0','90','90','90',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(132,'JALAPENOS','16','1','133','',16,'0','120','120','120',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(133,'GUACAMOLE ','16','1','134','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(134,'CHEESE','16','1','135','',16,'0','130','130','130',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(135,'MEXICAN RICE','16','1','136','',16,'0','180','180','180',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(136,'REFRIED BEANS ','16','1','137','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(137,'MARGHERITA PIZZA','17','1','138','',16,'0','850','850','850',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(138,'PUNJAB EXPRESS','17','1','139','',16,'O','900','900','900',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(139,'BBQ TOFU','17','1','140','',16,'0','950','950','950',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(140,'FUNGHI','17','1','141','',16,'0','980','980','980',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(141,'FOUR SEASONS ','17','1','142','',16,'0','1050','1050','1050',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(142,'SPICY CHIC PEA','18','1','143','',16,'0','800','800','800',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(143,'FETTUCINE ALFREDO','18','1','144','',16,'0','750','750','750',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(144,'SPINACH & MASHROOM','18','1','145','',16,'0','900','900','900',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(145,'MAC N CHEESE','18','1','146','',16,'0','750','750','750',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(146,'EGGPLANT PARMIGIANO','18','1','147','',16,'0','750','750','750',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(147,'VEGGIE TOPPING','19','1','148','',16,'0','90','90','90',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(148,'CHHEESE','19','1','149','',16,'0','120','120','120',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(149,'THAI SPINCH','20','1','150','',16,'0','580','580','580',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(150,'SANTA FE FALAFEL','20','1','151','',16,'0','600','600','600',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(151,'CHILI PANEER','20','1','152','',16,'0','600','600','600',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(152,'CREAM OF MASHROOM ','22','1','153','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(153,'TOMATO & SPINACH','22','1','154','',16,'0','380','380','380',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(154,'CREAMED SPINACH','23','1','155','',16,'0','280','280','280',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(155,'SAUTEED VEGATABLES','23','1','156','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(156,'POUTINE FRIES','23','1','157','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(157,'PAUSINE GARLIC FRIES','23','1','158','',16,'0','280','280','280',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(158,'WINDMILL FRIES ','23','1','159','',16,'0','220','220','220',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(159,'SWEET POTATO','23','1','160','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(160,'MUSHROOM FRIES ','23','1','161','',16,'0','380','380','380',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(161,'MASALA FRIES','23','1','162','',16,'0','330','330','330',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(162,'CURRY FRIES ','23','1','163','',16,'0','330','330','330',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(163,'PATATA BRAVAS','24','1','164','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(164,'SAMOSA ','24','1','165','',16,'0','210','210','210',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(165,'THAI VEG SPRING BALLS','24','1','166','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(166,'NACHOS','24','1','167','',16,'0','320','320','320',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(167,'MOZZARELLA STICKS','24','1','168','',16,'0','320','320','320',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(168,'SPINACH & RICOTTA','24','1','169','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(169,'TEX-MEX POATO SKIN','24','1','170','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(170,'SEV BUBDI','26','1','171','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(171,'COKE','7','1','172','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(172,'SPRITE','7','1','173','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(173,'FANTA','7','1','174','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(174,'SODA WATER','7','1','175','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(175,'GINGERALE','7','1','176','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(176,'DIET COKE','7','1','177','',16,'0','150','150','150',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(177,'STONEY','7','1','178','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(178,'COKE ZERO','7','1','179','',16,'0','150','150','150',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(179,'TONIC','7','1','180','',16,'0','100','100','100',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(180,'MINERAL WATER(500ml)','7','1','181','',16,'0','100','100','100',NULL,NULL,20,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(181,'MINERAL WATER 1ltre','7','1','182','',16,'0','200','200','200',NULL,NULL,10,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(182,'PEANUTS CHIKKI','26','1','183','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(183,'SESAME PEANUTS','26','1','184','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(184,'CHAKKRI','26','1','185','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(185,'SEV','26','1','186','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(186,'DRY SAMOSA','26','1','187','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(187,'DAL SMUTH','26','1','188','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(188,'CHEVDA','26','1','189','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(189,'BUNDI','26','1','190','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(190,'SEV BUNDI','26','1','191','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(191,'BANANA CRISPS','26','1','192','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(192,'POTATO CRISPS','26','1','193','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(193,'CHILLY POTATO CRISPS','26','1','194','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(194,'SEV MAMRA','26','1','195','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(195,'SEV MAMRA CHILLY','26','1','196','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(196,'ROASTED SOYA BEANS','26','1','197','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(197,'ROASTED PEANUTS','26','1','198','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(198,'ROASTED GRAMS','26','1','199','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(199,'CHEESE STICKS','26','1','200','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(200,'CINNAMON STICKS','26','1','201','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(201,'SIMSIM DRY STICKS','26','1','202','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(202,'PLAIN DRY STICK','26','1','203','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(203,'SWEET CINABON PUFF','26','1','204','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(204,'CAKE RUSK','26','1','205','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(205,'TORTILA CHIPS','26','1','207','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(206,'METHI MASALA PUFF','25','1','206','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(207,'SESAME CHAKRI','26','1','208','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(208,'NAN KATAI','25','1','209','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(209,'DATES & NUTS','25','1','210','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(210,'BRAZZILLIAN NUTS','25','1','211','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(211,'CHOCOLATE FINGERS','25','1','212','',16,'0','500','500','500',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(212,'HOME MADE COOKIES','25','1','213','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(213,'PIN WHEEL','25','1','214','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(214,'CHOC OATS & NUTS','25','1','215','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(215,'OATS & COCONUT','25','1','216','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(216,'PALMIERS','25','1','217','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(217,'VIENES COOKIES','25','1','218','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(218,'GLUTEN FREE COOKIES','25','1','219','',16,'0','500','500','500',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(219,'DIABETIC OATS & COCONUT COOKIES','25','1','220','',16,'0','450','450','450',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(220,'DIABETIC VIENIES COOKIES','25','1','221','',16,'0','450','450','450',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(221,'CHOC-CHIP ','25','1','222','',16,'0','400','400','400',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(222,'CHERRY NUT ','25','1','223','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(223,'JAM & COCONUT ','25','1','224','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(224,'PANI PURI','27','1','225','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(225,'PLAIN PUFF PASTRY','27','1','226','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(226,'TACOS','27','1','227','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(227,'MASALA PUFF','27','1','228','',16,'0','350','350','350',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(228,'JEERA PUFF PASTRY','27','1','229','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(229,'CHEESE PIE','28','1','230','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(230,'VEG PIE','28','1','231','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(231,'MUSHROOM PIE','28','1','232','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(232,'PANNER PIE','28','1','233','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(233,'CHOCOLATE DOUGHNUT','28','1','234','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(234,'CHOCOLATE CROISSANTS','28','1','235','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(235,'PLAIN CROISSANTS','28','1','236','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(236,'CHEESE CROISSANTS','28','1','237','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(237,'CARROT CAKE','28','1','238','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(238,'SPINACH & RICOTA','28','1','239','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(239,'PIZZA POCKET','28','1','240','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(240,'CINABON BUNS','28','1','241','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(241,'PLAIN TOAST','29','1','242','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(242,'BROWN TOAST','29','1','243','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(243,'DRY FRUIT TOAST','29','1','244','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(244,'CARAWAY TOAST','29','1','245','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(245,'BROWN SHORT BAGUETTE','29','1','246','',16,'0','60','60','60',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(246,'RYE BREAD DARK','29','1','247','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(247,'LIGMI RYE','29','1','248','',16,'0','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(248,'LONG FRENCH BAGUETTE','29','1','249','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(249,'SUGARFREE BROWN','29','1','250','',16,'0','100','100','100',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(250,'BROWN GALLATE','29','1','251','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(251,'WHITE GALLATE','29','1','252','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(252,'WHITE BUNS','29','1','253','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(253,'BROWN BUNS','29','1','254','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(254,'BROWN SOUP BUNS','29','1','255','',16,'0','80','80','80',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(255,'WHITE SOUP BUNS','29','1','256','',16,'0','80','80','80',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(256,'WHOLE MEAL','29','1','257','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(257,'BROWN LONG ROLLS','29','1','258','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(258,'WHITE LONG ROLLS','29','1','259','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(259,'BROWN FLAT BURGER','29','1','260','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(260,'WHITE FLAT BURGER','29','1','261','',16,'0','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(261,'QUEENS CAKE','4','1','262','',16,'O','150','150','150',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(262,'VOL VENT MINI','27','1','263','',16,'0','30','30','30',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(263,'VOL VENT LARGE','27','1','264','',16,'0','50','50','50',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(264,'FOCCAIA','29','1','265','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(265,'PITTA BREAD','29','1','266','',16,'0','200','200','200',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(266,'MOUSE','29','1','267','',16,'0','50','50','50',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(267,'BAJRA GARLIC','26','1','268','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(268,'MANGAHSHI','26','1','269','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(269,'JIRA KHAKRA','26','1','270','',16,'0','300','300','300',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(270,'mouse','28','1','1001','',16,'100','250','250','250',NULL,NULL,0,0,0,NULL,0,0,0,0.00,'','1','1','','','','','active','pcs'),(271,'tomato soap','22','1','8765','',0,'30','40','','40',NULL,NULL,0,0,0,'8084991531139447',0,0,0,0.00,'2018-07-09 15:32:01pm','1','1','','','0','sp','active','NOU');
/*!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 'new',
  `amount` varchar(30) NOT NULL,
  `companyid` varchar(30) 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,'1','11526955120','2018-05-22 05:12:00','455','WATER','1','2018-05-22 05:12:33am','ROBERT','WATER','2018-05-22 05:12:00','WATER','JKUAT','NET','','new','1815','1');
/*!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 AUTO_INCREMENT=23 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 */;
INSERT INTO `purchaseorderlist` VALUES (1,'11526955120','34','1','125','','125','0','2018-05-22 05:12:55am','','','','125','PO','0','','','1','','1','2018-05-22 02:12:55','1','1','new','1','new'),(2,'11526955120','11','1','600','','600','0','2018-05-22 05:13:00am','','','','600','PO','0','','','1','','1','2018-05-22 02:13:00','1','1','new','1','new'),(3,'11526955120','30','1','215','','215','0','2018-05-22 05:13:05am','','','','215','PO','0','','','1','','1','2018-05-22 02:13:05','1','1','new','1','new'),(4,'11526955120','35','1','125','','125','0','2018-05-22 05:13:10am','','','','125','PO','0','','','1','','1','2018-05-22 02:13:10','1','1','new','1','new'),(5,'11526955286','37','1','800','','800','0','2018-05-22 05:15:22am','','','','613','QT','0','','','1','','1','2018-05-22 02:15:22','1','1','new','1','new'),(6,'11526955286','59','10','5200','','520','0','2018-05-22 05:15:30am','','','','350','QT','0','','','1','','1','2018-05-22 02:15:30','1','1','new','1','new'),(7,'11526955286','180','1','550','','550','0','2018-05-22 05:15:36am','','','','450','QT','0','','','1','','1','2018-05-22 02:15:36','1','1','new','1','new'),(8,'11526955286','190','1','800','','800','0','2018-05-22 05:15:43am','','','','650','QT','0','','','1','','1','2018-05-22 02:15:43','1','1','new','1','new'),(9,'11526955286','60','1','400','','400','0','2018-05-22 05:15:50am','','','','280','QT','0','','','1','','1','2018-05-22 02:15:50','1','1','new','1','new'),(10,'11526955120','12','1','750','','750','0','2018-05-24 05:14:14am','','','','750','PO','0','','','1','','1','2018-05-24 02:14:14','1','1','new','1','new'),(11,'11526955286','4','1','450','','450','0','2018-05-24 05:14:37am','','','','340','QT','0','','','1','','1','2018-05-24 02:14:37','1','1','new','1','new'),(12,'EXP-11526955909','4','1','450','','450','0','2018-05-24 05:18:25am','','','','340','EXP','0','','','1','','1','2018-05-24 02:18:25','1','1','new','1','new'),(13,'EXP-11526955909','12','1','900','','900','0','2018-05-24 05:18:52am','','','','750','EXP','0','','','1','','1','2018-05-24 02:18:52','1','1','new','1','new'),(14,'EXP-11526955881','code','1','0','','0','0','2018-05-24 05:32:51am','','','','bprice','EXP','0','','','1','','1','2018-05-24 02:32:51','','categoryid','new','1','new'),(15,'EXP-11526955881','14','10','16000','','1600','0','2018-05-24 05:33:13am','','','','1450','EXP','0','','','1','','1','2018-05-24 02:33:13','1','1','new','1','new'),(16,'EXP-11526955881','42','1','5','','5','0','2018-05-24 05:33:47am','','','','1','EXP','0','','','1','','1','2018-05-24 02:33:47','1','1','new','1','new'),(17,'EXP-11526955881','3','1','200','','200','0','2018-05-24 05:33:58am','','','','140','EXP','0','','','1','','1','2018-05-24 02:33:58','1','1','new','1','new'),(18,'EXP-11527129321','3','1','200','','200','0','2018-05-24 05:36:13am','','','','140','EXP','0','','','1','','1','2018-05-24 02:36:13','1','1','new','1','new'),(19,'EXP-11527129321','8','1','800','','800','0','2018-05-24 05:37:17am','','','','623','EXP','0','','','1','','1','2018-05-24 02:37:17','1','1','new','1','new'),(20,'EXP-11527129443','4','1','450','','450','0','2018-05-24 05:38:41am','','','','340','EXP','0','','','1','','1','2018-05-24 02:38:41','1','1','new','1','new'),(21,'EXP-11527129443','5','1','200','','200','0','2018-05-24 05:38:46am','','','','153','EXP','0','','','1','','1','2018-05-24 02:38:46','1','1','new','1','new'),(22,'EXP-11527129443','9','1','750','','750','0','2018-05-24 05:38:50am','','','','520','EXP','0','','','1','','1','2018-05-24 02:38:50','1','1','new','1','new');
/*!40000 ALTER TABLE `purchaseorderlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `purchases`
--

DROP TABLE IF EXISTS `purchases`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `purchases` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_number` varchar(100) NOT NULL,
  `fromdate` varchar(100) NOT NULL,
  `supplier` varchar(100) NOT NULL,
  `remarks` text NOT NULL,
  `paiddate` varchar(40) NOT NULL,
  `amount` varchar(40) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `entrydate` varchar(50) NOT NULL,
  `status` varchar(30) NOT NULL DEFAULT 'open',
  `updateddate` varchar(30) NOT NULL,
  `updatedid` varchar(30) 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 `purchases`
--

LOCK TABLES `purchases` WRITE;
/*!40000 ALTER TABLE `purchases` DISABLE KEYS */;
INSERT INTO `purchases` VALUES (1,'234324','2018-05-04 12:44:54','1','','2018-05-04 12:44:54','2000','1','1','2018-05-04 12:45:01pm','closed','2018-05-12 09:24:21am','1'),(2,'234324','2018-05-12 09:23:28','1','','2018-05-12 09:23:28','2000','1','1','2018-05-12 09:23:50am','closed','2018-05-12 09:24:21am','1');
/*!40000 ALTER TABLE `purchases` 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,
  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 `quotation`
--

LOCK TABLES `quotation` WRITE;
/*!40000 ALTER TABLE `quotation` DISABLE KEYS */;
INSERT INTO `quotation` VALUES (1,'manyala','11526955286','2018-05-22 05:14:46','','We are ready','1','2018-05-22 05:15:14am','ROBERT','','2018-05-22 05:14:46','','','20%','','new','8200','1');
/*!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 `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(11) NOT NULL AUTO_INCREMENT,
  `invoice` varchar(100) NOT NULL,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoice` (`invoice`)
) ENGINE=InnoDB AUTO_INCREMENT=37 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,'11525150155','','Invoice','','2018-05-01','','0','1','2018-05-01 07:49:32am','','1900','1900','1','retail',NULL,'1900','1','0','0','0','0','0','0','printed','','','1',''),(2,'11525917210','','Invoice','Cleared','2018-05-13','dfsdrtert54grf','0','1','2018-05-12 09:09:57am','2','1750','1750','1','retail',NULL,'1750','1','0','0','0','0','0','0','printed','','','1',''),(3,'11526105528','','Cash','','2018-05-12','','0','1','2018-05-12 09:21:21am','','1480','1480','1','retail',NULL,'1480','1','0','0','0','0','0','0','printed','','','1',''),(4,'11526106087','','Cash','','2018-05-12','','0','1','2018-05-12 09:21:36am','','930','930','1','retail',NULL,'930','1','0','0','0','0','0','0','printed','','','1',''),(5,'11526106099','','Cash','Cleared','2018-05-12','','0','1','2018-05-12 09:21:53am','','350','350','1','retail',NULL,'350','1','0','0','0','0','0','0','printed','','','1',''),(6,'11526954050','','Cash','','2018-05-22','','0','1','2018-05-22 04:54:21am','','240','240','1','retail',NULL,'240','1','0','0','0','0','0','0','printed','','','1',''),(7,'11526954075','','Cash','','2018-05-22','','0','1','2018-05-22 04:54:44am','','6080','6080','1','retail',NULL,'6080','1','0','0','0','0','0','0','printed','','','1',''),(8,'11526954092','','Cash','','2018-05-22','','0','1','2018-05-22 04:55:02am','','4750','4750','1','retail',NULL,'4750','1','0','0','0','0','0','0','printed','','','1',''),(9,'11526954116','','Invoice','','2018-05-22','ouko','0','1','2018-05-22 04:55:38am','directly','580','580','1','retail',NULL,'580','1','0','0','0','0','0','0','printed','','','1',''),(10,'11526954449','','Cash','','2018-05-22','','0','1','2018-05-22 05:00:52am','','1200','1200','1','retail',NULL,'1200','1','0','0','0','0','0','0','new','','','1',''),(11,'11527771693','','Cash','','2018-05-31','','0','1','2018-05-31 16:01:42pm','','300','300','1','retail',NULL,'300','1','0','0','0','0','0','0','printed','','','3',''),(12,'11527771774','','Cash','','2018-05-31','','0','1','2018-05-31 16:03:03pm','','300','300','1','retail',NULL,'300','1','0','0','0','0','0','0','printed','','','3',''),(13,'11527771937','','Cash','','2018-05-31','','0','1','2018-05-31 16:05:45pm','','180','180','1','retail',NULL,'180','1','0','0','0','0','0','0','printed','','','3',''),(14,'11527946593','','Cash','','2018-06-02','','0','1','2018-06-02 16:36:48pm','','2000','2000','1','retail',NULL,'2000','1','0','0','0','0','0','0','printed','','','1',''),(15,'11527946638','','Cash','','2018-06-02','','0','1','2018-06-02 16:38:25pm','','16500','16500','1','retail',NULL,'16500','1','0','0','0','0','0','0','printed','','','1',''),(16,'11527950967','','Cash','','2018-06-02','','0','1','2018-06-02 17:50:20pm','','110000','110000','1','retail',NULL,'110000','1','0','0','0','0','0','0','printed','','','1',''),(17,'11527951097','','Cash','','2018-06-02','','0','1','2018-06-02 17:51:54pm','','110000','110000','1','retail',NULL,'110000','1','0','0','0','0','0','0','printed','','','1',''),(18,'11527951167','','Cash','','2018-06-02','','0','1','2018-06-02 17:53:18pm','','220000','220000','1','retail',NULL,'220000','1','0','0','0','0','0','0','printed','','','1',''),(19,'11527951428','','Cash','','2018-06-02','','0','1','2018-06-02 17:57:41pm','','220000','220000','1','retail',NULL,'220000','1','0','0','0','0','0','0','printed','','','1',''),(20,'11527951888','','Cash','','2018-06-02','','0','1','2018-06-02 18:05:46pm','','220000','220000','1','retail',NULL,'220000','1','0','0','0','0','0','0','printed','','','1',''),(21,'11527951970','','Cash','','2018-06-02','','0','1','2018-06-02 18:07:09pm','','1000','1000','1','retail',NULL,'1000','1','0','0','0','0','0','0','printed','','','1',''),(22,'11527999266','','Cash','','2018-06-03','','0','1','2018-06-03 07:14:56am','','950','950','1','retail',NULL,'950','1','0','0','0','0','0','0','printed','','','2',''),(24,'21528113974','','Cash','','2018-06-04','','0','2','2018-06-04 15:06:29pm','','600','600','1','retail',NULL,'600','1','0','0','0','0','0','0','printed','','','2',''),(25,'11528709781','','Cash','','2018-06-11','','0','1','2018-06-11 12:40:41pm','','380','380','1','retail',NULL,'380','1','0','0','0','0','0','0','new','','','1',''),(26,'11528710078','','Cash','','2018-06-11','','0','1','2018-06-11 12:41:39pm','2','150','150','1','retail',NULL,'150','1','0','0','0','0','0','0','new','','','3',''),(27,'11528744615','','Cash','','2018-06-11','','0','1','2018-06-11 22:17:30pm','','470','470','1','retail',NULL,'470','1','0','0','0','0','0','0','new','','','2',''),(28,'11528744692','','Cash','','2018-06-11','','0','1','2018-06-11 22:18:23pm','','1110','1110','1','retail',NULL,'1110','1','0','0','0','0','0','0','new','','','2',''),(29,'11528744745','','Cash','','2018-06-11','','0','1','2018-06-11 22:19:26pm','cheifmessage','850','850','1','retail',NULL,'850','1','0','0','0','0','0','0','new','extra cheese','','1',''),(30,'11528801150','','Cash','','2018-06-12','','0','1','2018-06-12 14:00:04pm','mytable','100','100','1','retail',NULL,'100','1','0','0','0','0','0','0','printed','','67','3',''),(31,'11529041487','','Cash','','2018-06-18','','0','1','2018-06-18 09:53:05am','','1900','1900','1','retail',NULL,'1900','1','0','0','0','0','0','0','printed','','','1',''),(32,'11529304832','','Cash','','2018-06-18','','0','1','2018-06-18 09:54:29am','','680','680','1','retail',NULL,'680','1','0','0','0','0','0','0','printed','','','2',''),(33,'11530936244','','Cash','','2018-07-07','','0','1','2018-07-07 07:09:08am','','820','820','1','retail',NULL,'820','1','0','0','0','0','0','0','new','','','2',''),(34,'11530936564','','Cash','','2018-07-07','','0','1','2018-07-07 07:09:36am','cheifmessage','620','620','1','retail',NULL,'620','1','0','0','0','0','0','0','new','DONT PUT SALT','','1',''),(35,'11531139043','','Cash','','2018-07-09','','0','1','2018-07-09 15:24:51pm','','740','740','1','retail',NULL,'740','1','0','0','0','0','0','0','printed','','','2',''),(36,'11531139530','','Cash','','2018-07-09','','0','1','2018-07-09 15:33:13pm','','260','260','1','retail',NULL,'260','1','0','0','0','0','0','0','new','','','2','');
/*!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(30) 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,
  `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',
  `uom` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 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,'11526954050','197',1.00,'150','retail','150','0','2018-05-22 04:54:11am','','','','125','Cash','0','','','1','','1','2018-05-22 01:54:21','1','1','printed','1','new','pcs'),(2,'11526954050','194',1.00,'30','retail','30','0','2018-05-22 04:54:13am','','','','19','Cash','0','','','1','','1','2018-05-22 01:54:21','1','1','printed','1','new','pcs'),(3,'11526954050','195',1.00,'30','retail','30','0','2018-05-22 04:54:14am','','','','20','Cash','0','','','1','','1','2018-05-22 01:54:21','1','1','printed','1','new','pcs'),(4,'11526954050','194',1.00,'30','retail','30','0','2018-05-22 04:54:16am','','','','19','Cash','0','','','1','','1','2018-05-22 01:54:21','1','1','printed','1','new','pcs'),(5,'11526954075','194',1.00,'30','retail','30','0','2018-05-22 04:54:36am','','','','19','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(6,'11526954075','189',1.00,'1050','retail','1050','0','2018-05-22 04:54:36am','','','','900','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(7,'11526954075','191',1.00,'400','retail','400','0','2018-05-22 04:54:38am','','','','116','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(8,'11526954075','187',1.00,'1250','retail','1250','0','2018-05-22 04:54:39am','','','','1137','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(9,'11526954075','188',1.00,'1250','retail','1250','0','2018-05-22 04:54:41am','','','','1137','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(10,'11526954075','189',1.00,'1050','retail','1050','0','2018-05-22 04:54:41am','','','','900','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(11,'11526954075','189',1.00,'1050','retail','1050','0','2018-05-22 04:54:42am','','','','900','Cash','0','','','1','','1','2018-05-22 01:54:44','1','1','printed','1','new','pcs'),(12,'11526954092','77',1.00,'1250','retail','1250','0','2018-05-22 04:54:52am','','','','980','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(13,'11526954092','189',1.00,'1050','retail','1050','0','2018-05-22 04:54:53am','','','','900','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(14,'11526954092','183',1.00,'380','retail','380','0','2018-05-22 04:54:54am','','','','310','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(15,'11526954092','184',1.00,'120','retail','120','0','2018-05-22 04:54:55am','','','','90','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(16,'11526954092','107',1.00,'700','retail','700','0','2018-05-22 04:54:58am','','','','535','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(17,'11526954092','188',1.00,'1250','retail','1250','0','2018-05-22 04:54:58am','','','','1137','Cash','0','','','1','','1','2018-05-22 01:55:02','1','1','printed','1','new','pcs'),(18,'11526954116','196',1.00,'200','retail','200','0','2018-05-22 04:55:16am','','','','140','Invoice','0','','','1','','1','2018-05-22 01:55:38','1','1','printed','1','new','pcs'),(19,'11526954116','195',1.00,'30','retail','30','0','2018-05-22 04:55:16am','','','','20','Invoice','0','','','1','','1','2018-05-22 01:55:38','1','1','printed','1','new','pcs'),(20,'11526954116','201',1.00,'350','retail','350','0','2018-05-22 04:55:17am','','','','273','Invoice','0','','','1','','1','2018-05-22 01:55:38','1','1','printed','1','new','pcs'),(21,'11526954449','198',1.00,'400','retail','400','0','2018-05-22 05:00:49am','','','','280','Cash','0','','','1','','1','2018-05-22 02:00:52','1','1','printed','1','new','pcs'),(22,'11526954449','191',1.00,'400','retail','400','0','2018-05-22 05:00:51am','','','','116','Cash','0','','','1','','1','2018-05-22 02:00:52','1','1','printed','1','new','pcs'),(23,'11526954449','191',1.00,'400','retail','400','0','2018-05-22 05:00:51am','','','','116','Cash','0','','','1','','1','2018-05-22 02:00:52','1','1','printed','1','new','pcs'),(25,'11527771693','205',1.00,'300','retail','300','0','2018-05-31 16:01:37pm','','','','30','Cash','0','','','1','','1','2018-05-31 13:01:42','3','29','printed','1','new','pcs'),(26,'11527771774','205',1.00,'300','retail','300','0','2018-05-31 16:03:00pm','','','','30','Cash','41.38','','','1','','1','2018-05-31 13:03:03','3','29','printed','1','new','pcs'),(27,'11527771937','205',1.00,'180','retail','180','0','2018-05-31 16:05:42pm','','','','30','Cash','24.83','','','1','','1','2018-05-31 13:05:45','3','29','printed','1','new','pcs'),(28,'11527946593','2031',4.00,'2000','retail','500','0','2018-06-02 16:36:46pm','','','','350','Cash','0','','','1','','1','2018-06-02 13:36:48','1','1','printed','1','new','pcs'),(29,'11527946638','2031',33.00,'16500','retail','500','0','2018-06-02 16:37:29pm','','','','350','Cash','68.97','','','1','','1','2018-06-02 13:38:25','1','1','printed','1','new','pcs'),(30,'11527950967','2031',220.00,'110000','retail','500','0','2018-06-02 17:50:16pm','','','','350','Cash','15,172.41','','','1','','1','2018-06-02 14:50:21','1','1','printed','1','new','pcs'),(31,'11527951097','2031',220.00,'110000','retail','500','0','2018-06-02 17:51:48pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 14:51:54','1','1','printed','1','new','pcs'),(32,'11527951167','2031',220.00,'110000','retail','500','0','2018-06-02 17:52:58pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 14:53:18','1','1','printed','1','new','pcs'),(33,'11527951167','2031',220.00,'110000','retail','500','0','2018-06-02 17:53:15pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 14:53:18','1','1','printed','1','new','pcs'),(35,'11527951428','2031',220.00,'110000','retail','500','0','2018-06-02 17:57:18pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 14:57:41','1','1','printed','1','new','pcs'),(36,'11527951428','2031',220.00,'110000','retail','500','0','2018-06-02 17:57:38pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 14:57:41','1','1','printed','1','new','pcs'),(37,'11527951888','2031',220.00,'110000','wholesale','500','0','2018-06-02 18:05:00pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 15:05:46','1','1','printed','1','new','pcs'),(38,'11527951888','2031',220.00,'110000','wholesale','500','0','2018-06-02 18:05:10pm','','','','350','Cash','15172.41','','','1','','1','2018-06-02 15:05:46','1','1','printed','1','new','pcs'),(39,'11527951970','2031',1.00,'500','retail','500','0','2018-06-02 18:06:17pm','','','','350','Cash','68.97','','','1','','1','2018-06-02 15:07:10','1','1','printed','1','new','pcs'),(40,'11527951970','2031',1.00,'500','retail','500','0','2018-06-02 18:06:28pm','','','','350','Cash','68.97','','','1','','1','2018-06-02 15:07:10','1','1','printed','1','new','pcs'),(41,'11527999266','1',1.00,'320','retail','320','0','2018-06-03 07:14:27am','','','','170','Cash','44.14','','','1','','1','2018-06-03 04:14:56','1','1','printed','1','new','pcs'),(42,'11527999266','69',1.00,'400','retail','400','0','2018-06-03 07:14:32am','','','','0','Cash','55.17','','','1','','1','2018-06-03 04:14:56','2','8','printed','1','new','pcs'),(43,'11527999266','20',1.00,'230','retail','230','0','2018-06-03 07:14:48am','','','','115','Cash','31.72','','','1','','1','2018-06-03 04:14:56','2','3','printed','1','new','pcs'),(44,'11528104497','153',1.00,'400','retail','400','0','2018-06-04 12:28:19pm','','','','0','Cash','55.17','','','1','','1','2018-06-04 09:34:11','1','22','printed','1','printed','pcs'),(45,'11528104497','109',1.00,'490','retail','490','0','2018-06-04 12:29:00pm','','','','0','Cash','67.59','','','1','','1','2018-06-04 09:34:11','2','11','printed','1','printed','pcs'),(46,'11528104497','172',1.00,'100','retail','100','0','2018-06-04 12:31:49pm','','','','0','Cash','13.79','','','1','','1','2018-06-04 09:34:11','2','7','printed','1','printed','pcs'),(47,'21528113974','108',1.00,'300','retail','300','0','2018-06-04 15:06:16pm','','','','0','Cash','41.38','','','2','','1','2018-06-04 12:06:30','2','11','printed','1','new','pcs'),(48,'21528113974','107',1.00,'300','retail','300','0','2018-06-04 15:06:22pm','','','','0','Cash','41.38','','','2','','1','2018-06-04 12:06:30','2','11','printed','1','new','pcs'),(49,'11528709781','154',1.00,'380','retail','380','0','2018-06-11 12:36:23pm','','','','0','Cash','52.41','','','1','','1','2018-06-11 09:40:41','1','22','printed','1','new','pcs'),(50,'11528710078','258',1.00,'150','retail','150','0','2018-06-11 12:41:20pm','','','','0','Cash','20.69','','','1','','1','2018-06-11 09:41:39','3','29','printed','1','new','pcs'),(51,'11528744615','238',1.00,'200','retail','200','0','2018-06-11 22:16:57pm','','','','0','Cash','27.59','','','1','','1','2018-06-11 19:17:30','3','28','printed','1','new','pcs'),(52,'11528744615','80',1.00,'270','retail','270','0','2018-06-11 22:17:17pm','','','','0','Cash','37.24','','','1','','1','2018-06-11 19:17:30','2','9','printed','1','new','pcs'),(53,'11528744692','120',1.00,'480','retail','480','0','2018-06-11 22:18:13pm','','','','0','Cash','66.21','','','1','','1','2018-06-11 19:18:23','1','13','printed','1','new','pcs'),(54,'11528744692','120',1.00,'480','retail','480','0','2018-06-11 22:18:16pm','','','','0','Cash','66.21','','','1','','1','2018-06-11 19:18:23','1','13','printed','1','new','pcs'),(55,'11528744692','177',1.00,'150','retail','150','0','2018-06-11 22:18:16pm','','','','0','Cash','20.69','','','1','','1','2018-06-11 19:18:23','2','7','printed','1','new','pcs'),(56,'11528744745','138',1.00,'850','retail','850','0','2018-06-11 22:19:07pm','','','','0','Cash','117.24','','','1','','1','2018-06-11 19:19:26','1','17','printed','1','new','pcs'),(57,'11528801150','250',1.00,'100','retail','100','0','2018-06-12 13:59:13pm','','','','0','Cash','13.79','','','1','','1','2018-06-12 11:00:06','3','29','printed','1','new','pcs'),(58,'11529041487','78',1.00,'220','retail','220','0','2018-06-15 08:45:13am','','','','0','Cash','30.34','','','1','','1','2018-06-18 06:53:05','2','9','printed','1','printed','pcs'),(59,'11529041487','9',1.00,'750','retail','750','0','2018-06-15 14:28:32pm','','','','300','Cash','103.45','','','1','','1','2018-06-18 06:53:05','1','1','printed','1','new','pcs'),(60,'11529041487','4',1.00,'480','retail','480','0','2018-06-15 14:28:37pm','','','','240','Cash','66.21','','','1','','1','2018-06-18 06:53:05','1','1','printed','1','new','pcs'),(61,'11529041487','2',1.00,'450','retail','450','0','2018-06-15 14:28:39pm','','','','225','Cash','62.07','','','1','','1','2018-06-18 06:53:05','1','1','printed','1','new','pcs'),(62,'11529304832','102',1.00,'340','retail','340','0','2018-06-18 09:53:59am','','','','0','Cash','46.90','','','1','','1','2018-06-18 06:54:29','2','10','printed','1','new','pcs'),(63,'11529304832','100',1.00,'340','retail','340','0','2018-06-18 09:54:12am','','','','0','Cash','46.90','','','1','','1','2018-06-18 06:54:29','2','10','printed','1','new','pcs'),(64,'11530936244','54',1.00,'330','retail','330','0','2018-07-07 07:04:05am','','','','165','Cash','45.52','','','1','','1','2018-07-07 04:09:09','2','6','printed','1','new','pcs'),(65,'11530936244','49',1.00,'240','retail','240','0','2018-07-07 07:04:09am','','','','120','Cash','33.10','','','1','','1','2018-07-07 04:09:09','2','6','printed','1','new','pcs'),(66,'11530936244','58',1.00,'250','retail','250','0','2018-07-07 07:04:16am','','','','0','Cash','34.48','','','1','','1','2018-07-07 04:09:09','2','6','printed','1','new','pcs'),(67,'11530936564','122',1.00,'620','retail','620','0','2018-07-07 07:09:25am','','','','0','Cash','85.52','','','1','','1','2018-07-07 04:09:36','1','14','printed','1','new','pcs'),(68,'11531139043','170',1.00,'250','retail','250','0','2018-07-09 15:24:04pm','','','','0','Cash','34.48','','','1','','1','2018-07-09 12:24:51','1','24','printed','1','new','pcs'),(69,'11531139043','109',1.00,'490','retail','490','0','2018-07-09 15:24:31pm','','','','0','Cash','67.59','','','1','','1','2018-07-09 12:24:51','2','11','printed','1','new','pcs'),(70,'11531139530','8765',1.00,'40','retail','40','0','2018-07-09 15:32:16pm','','','','30','Cash','0','','','1','','1','2018-07-09 12:33:14','1','22','printed','1','new','NOU'),(71,'11531139530','96',1.00,'220','retail','220','0','2018-07-09 15:33:01pm','','','','0','Cash','30.34','','','1','','1','2018-07-09 12:33:14','2','9','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(100) NOT NULL,
  `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 `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(50) NOT NULL,
  `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` varchar(100) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 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>PORK PALACE, KITENGELA</h1>\r\n PO.BOX 436 NAIVASHA NAKURU ROAD\r\nTELEPHONE:0700000296,0725405027\r\n','254746297242','JUJA','1680africa@protonmail.com','ROBISEARCHPOS-201701','1680 BAR & GRILL 	\r\n254746297242	 		\r\n1680africa@protonmail.com 	\r\nrobisearch@gmail.com www.robisearch.com 	 \r\nwww.shujaawangu.com KCB CAPITAL HILL	 		\r\nACC NO, 1171211120		 	\r\nPAY BILL NO, 717475 	\r\n','JOHNKINGSLY','r12345','254729139138','49318-00100 Nairobi','KSH','VAT','16','16','10','http://www.gitobuimanyara.com1/','GOODS ONCE SOLD ARE NOT RETURNABLE ','2018-06-031527999856.png','CASH','1 ','','1','2018-06-02 18:36:54pm','yes','yes','no','no','2019-05-07','<center>TILL NO:998779</center>','TERMS OF SERVICE \r\n1. Grand total of Ksh.25, 000is payable once (One off payment). \r\n2. The cost per SMS is KSH.1 \r\n3. The annual maintenance cost is Ksh.5000 \r\n4. Price for Integration with any other ROCKY existing system is negotiable. \r\n5. We will offer you 1000 free SMS to help you kick off with the system. \r\n','no','You were to renew your account by16/3/2019 and you have not yet paid. Kindly send your money to our paybil no:717475 then system will continue working correctly','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318','50');
/*!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` varchar(20) NOT NULL,
  `credit` varchar(20) 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 AUTO_INCREMENT=29 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 */;
INSERT INTO `statement` VALUES (1,'8','','BANK-11522721635','2018-04-03 06:34:00am','','','','1','1','4','DONT PUT SALT','778','','2','','222'),(3,'7','','BANK-11522721635','2018-04-03 06:53:06am','','','','1','1','4','DONT PUT SALT','6000','','2','','223'),(4,'4','','BANK-11522721635','2018-04-03 07:03:42am','','','','1','1','5','DONT PUT SALT','9000','','2','','222'),(5,'7','','BANK-11522721635','2018-04-03 11:53:27am','','','','1','1','3','AN/','7000','','2','','23423'),(6,'8','','BANK-11522811087','2018-04-04 06:05:17am','','','','1','1','4','DONT PUT SALT','4222','','2','','222'),(7,'8','','BANK-11522811087','2018-04-04 06:05:29am','','','','1','1','4','DONT PUT SALT','0','','3','','222'),(8,'7','','EXP-11522812955','2018-04-04 07:11:40am','','','','1','1','4','DONT PUT SALT','4444','','2','','222'),(9,'7','','EXP-11522812955','2018-04-04 07:12:43am','','','','1','1','4','DONT PUT SALT','9077','','2','','223'),(10,'8','','EXP-11522812955','2018-04-04 07:20:24am','','','','1','1','1','all','3333','','3','','44'),(11,'8','','EXP-11522812955','2018-04-04 08:39:13am','','','','1','1','5','ALL','5000','','3','','DFS'),(12,'8','','EXP-11522812955','2018-04-04 08:56:16am','','','','1','1','3','n/a','8000','','2','','223'),(13,'8','','EXP-11522812955','2018-04-04 08:57:20am','','','','1','1','4','ALL','8000','','2','','222'),(17,'8','','EXP-11522812281','2018-04-05 07:14:25am','','','','1','1','4','all','400','','n/a','','222'),(18,'4','','EXP-11522812281','2018-04-05 07:17:23am','','','','1','1','3','na','344','','n/a','','33'),(20,'8','','EXP-11526955909','2018-05-24 05:17:38am','','','','1','1','2','322','500','','n/a','','2321'),(21,'4','','EXP-11526955909','2018-05-24 05:18:02am','','','','1','1','2','DONT PUT SALT','400','','n/a','','21'),(22,'4','','EXP-11526955909','2018-05-24 05:19:10am','','','','1','1','2','n/a','400','','n/a','','222'),(23,'7','','EXP-11526955881','2018-05-24 05:22:10am','','','','1','1','4','put soup','5004','','n/a','','222'),(24,'4','','EXP-11526955881','2018-05-24 05:32:39am','','','','1','1','3','all','1000','','n/a','','222'),(25,'7','','EXP-11527129321','2018-05-24 05:36:37am','','','','1','1','4','all','60','','n/a','','60'),(26,'4','','EXP-11527129321','2018-05-24 05:36:59am','','','','1','1','4','all','700','','n/a','','222'),(27,'4','','EXP-11527129443','2018-05-24 05:38:21am','','','','1','1','4','all','800','','n/a','','222'),(28,'4','','EXP-11527129443','2018-05-24 05:38:31am','','','','1','1','4','all','2004','','n/a','','44');
/*!40000 ALTER TABLE `statement` 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 `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,
  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,
  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,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB 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 */;
/*!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=14 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,'No Units','No Units','2018-03-29 06:40:47am','active','1','','1','NOU'),(2,'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'),(7,'Packets','Packets','2018-03-29 06:36:08am','active','1','','1','pcks'),(8,'Kilograms','Kilograms','2018-03-29 07:14:40am','active','1','','1','Kg'),(9,'Litre','Litre','2018-03-29 07:14:57am','active','1','','1','ltr'),(10,'piece','PCS','2018-03-30 12:34:29pm','active','1','','1','pcs'),(11,'sheet','','2018-03-30 12:35:21pm','active','1','','1','sht'),(12,'Bale','','2018-03-30 12:40:40pm','active','1','','1','BL'),(13,'Box','','2018-03-30 12:40:58pm','active','1','','1','bx');
/*!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=17 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 (1,'pcks','2018-03-29 09:35:55am','active','1','','1','205','1',10,'40'),(2,'pcks','2018-03-29 09:36:23am','active','1','','1','205','1',10,'40'),(3,'dz','2018-03-30 04:46:19am','active','1','','1','344','1',50,'40'),(4,'pcks','2018-03-30 05:16:42am','active','1','','1','344','1',20,'40'),(6,'pcks','2018-03-30 12:39:33pm','active','1','','1','99766','1',12,'360'),(9,'bx','2018-03-31 06:20:40am','active','1','','1','99766','1',24,'960'),(10,'BL','2018-03-31 06:21:20am','active','1','','1','99766','1',48,'1920'),(11,'pcks','2018-03-31 13:32:19pm','active','1','','1','7082','1',12,'300'),(12,'bx','2018-03-31 13:32:38pm','active','1','','1','7082','1',48,'600'),(13,'pcs','2018-04-03 11:42:56am','active','1','','1','20005','1',1,'20'),(14,'pcks','2018-04-03 11:43:14am','active','1','','1','20005','1',12,'120'),(15,'bx','2018-04-03 11:44:09am','active','1','','1','20005','1',48,'480'),(16,'BL','2018-04-03 11:44:30am','active','1','','1','20005','1',96,'960');
/*!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(20) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(100) 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,'Admin','Robisearch','','robisearch@gmail.com','0738032299','female','','2018-05-30','demo','','','22759726','2018-05-011525147104.png','','','','','2017-02-26','10','1','','1','','1','admin','1'),(2,'ann','njoki','','bmemba@gmail.com','254721781615','female','','2018-06-04','demo1','','','123456','','','','','','','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:39:35