/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: robisear_robihotel -- ------------------------------------------------------ -- 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 `admintable` -- DROP TABLE IF EXISTS `admintable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `admintable` ( `id` int(40) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(20) DEFAULT NULL, `surname` varchar(50) NOT NULL, `firstname` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `campus` varchar(30) NOT NULL, `college` varchar(30) NOT NULL, `department` varchar(30) NOT NULL, `type` varchar(50) NOT NULL, `token` text NOT NULL, `email` varchar(50) NOT NULL, `createdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL, `idno` varchar(40) NOT NULL, `updatedat` varchar(40) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `admintable` -- LOCK TABLES `admintable` WRITE; /*!40000 ALTER TABLE `admintable` DISABLE KEYS */; INSERT INTO `admintable` VALUES (33,'admin','admin123','admin','Kumo1','07223131221','','','','','','admin@gmail.com','','active','12345678','2016-11-07 04:42:16','3'); /*!40000 ALTER TABLE `admintable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `advert` -- DROP TABLE IF EXISTS `advert`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `advert` ( `id` int(50) NOT NULL AUTO_INCREMENT, `createdate` varchar(50) NOT NULL, `title` text NOT NULL, `description` text NOT NULL, `link` text NOT NULL, `status` int(12) NOT NULL, `image` 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 `advert` -- LOCK TABLES `advert` WRITE; /*!40000 ALTER TABLE `advert` DISABLE KEYS */; /*!40000 ALTER TABLE `advert` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `agent` -- DROP TABLE IF EXISTS `agent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `agent` ( `id` int(40) NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `phone` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `description` text NOT NULL, `idno` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `gender` varchar(10) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `county` varchar(40) NOT NULL, `accountno` varchar(100) NOT NULL, `accountname` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idno` (`idno`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agent` -- LOCK TABLES `agent` WRITE; /*!40000 ALTER TABLE `agent` DISABLE KEYS */; INSERT INTO `agent` VALUES (1,'manager','manager','manager','manager','','','manager','1 ','','2018-01-12 13:51:35','','1','50 ','','','3','1'),(2,'felista','waruguru','NAIROBI','254710597573','abc@gmail.com','','123456','1 ','Female','2018-08-29 11:45:32','','1','50 ','22222','KCB','3','1'),(4,'jane','wanjiru','','','','','','1 ','','2018-09-07 13:54:04','','5','50 ','','','3','1'),(5,'jane','wanjiru','nyeri','0763573565','jane@gmail.com','','523535635','1 ','','2018-09-07 13:57:32','','5','50 ','','','3','1'),(6,'faith','yuni','NAKURU','0754676456','faith@gmail.com','','56324987','1 ','Female','2018-09-07 13:59:58','','5','50 ','','','3','1'),(7,'marty','renin','naivasha','0707914918','','','78462866','1 ','','2018-09-07 14:01:44','','5','50 ','','','3','1'),(8,'obite','turewa','nyeri','0716466754','','','76587609','1 ','','2018-09-07 14:41:02','','5','50 ','','','3','1'),(9,'opiyo','njuguna','meru','25472668089545','','','897867655','1 ','','2018-09-07 14:42:26','','5','50 ','','','3','1'),(10,'patty','yesra','','','','','987409','1 ','','2018-09-07 14:42:56','','5','50 ','','','3','1'),(11,'uliya','truju','','','','','776443978','1 ','','2018-09-07 14:43:19','','5','50 ','','','3','1'),(12,'kurama','ujio','','','','','0923728','1 ','','2018-09-07 14:43:48','','5','50 ','','','3','1'),(13,'judy','chepo','','','','','87309334','1 ','','2018-09-07 14:44:22','','5','50 ','','','3','1'),(14,'ladysha','sharon','','','','','9367920765','1 ','','2018-09-07 14:44:47','','5','50 ','','','3','1'),(15,'henry','Mwaura','Kisumu','0707699136','',' ','78634509','1 ','','2018-11-02 17:01:10','2018-11-02 17:01:10','27','50 ','','','3','1'),(16,'faizal','ahmed','','','','','76934628','1 ','','2018-09-07 14:51:46','','5','50 ','','','3','1'),(17,'ian','hatua','','','','','6432423423','1 ','','2018-09-07 14:52:14','','5','50 ','','','3','1'),(18,'kim','kimani','','','','','654637856','1 ','','2018-09-07 14:52:34','','5','50 ','','','3','1'),(19,'gania','turisha','','','','','6742676587','1 ','','2018-09-07 14:53:38','','5','50 ','','','3','1'),(20,'turi','fay','','','','','56045695','1 ','','2018-09-07 14:54:02','','5','50 ','','','3','1'),(21,'mary','kamau','JUJA','254716343510','robisearch@gmail.com','juja ma','5677','1 ','Female','2018-09-08 11:44:07','','1','50 ','46578','equity','3','1'),(22,'wakik','vak','thika','25416353210','wikw@gmail.com','','56789','1 ','Male','2018-09-08 11:46:09','','1','50 ','','','3','1'),(23,'doss','quick','utawala','25474576890','quick@gmail.com','','3546789','1 ','Male','2018-09-08 11:47:27','','1','50 ','','','3','1'),(24,'ALPHA','MUGENDI','JUJA','078456826','abc2@gmail.com','','5379816729','1 ','Male','2018-09-09 19:22:15','','1','50 ','6365828949896','BARCLAYS','3','1'),(25,'ALICE','KEMUNTO','JUJA','0753467826','avdh@gmail.com','','34567289','1 ','Female','2018-09-09 19:25:36','','1','50 ','648892794779','BARCLAYS','3','1'),(26,'ANDREW','WAFULA','JUJA','0789456782','ghnvu@gmail.com','','452683764','1 ','Male','2018-09-09 19:26:35','','1','50 ','36347287643762','BARCLAYS','3','1'),(27,'ANNABEL','NAIBINI','JUJA','075465262','ann@gmail.com','','452776483','1 ','Female','2018-09-09 19:27:39','','1','50 ','62876746723','BARCLAYS','3','1'),(28,'AUSTIN','MUTHOKA','JUJA','078935647','ndjsjs@gmail.com','','4582867438','1 ','Male','2018-09-09 19:28:44','','1','50 ','56324882648642','BARCLAYS','3','1'),(29,'doss','vak','utawala','+2543434546','doss@gmail.com','','432564','1 ','Male','2018-09-10 11:33:33','','1','50 ','5346','equity','3','1'),(30,'mary','kamau','thika','254716343510','marykamau55@gmail.com','','5467','1 ','Female','2018-09-10 12:13:03','','1','50 ','46578','kcb','3','1'),(31,'Andrew','Musyoki','machakos','0725236481','hier@gmail.com','','78952214','1 ','Male','2018-09-10 15:24:11','','9','16 ','','','3','1'),(32,'march','march','thika','254756545454','m@yahoo.com','','22222','1 ','Male','2018-09-11 13:34:35','','1','34 ','9999999','march','3','1'),(33,'EVANS','MUNYWOKI','Nairobi','254714513818','mr.munywokievans@gmail.com','','32295069','1 ','Male','2018-10-23 15:33:06','','1','50 ','123456','munywoki','3','1'),(34,'GRACE','kiangi','JUJA','O703364993','kiangigrace@gmail.com','ACCOUNT CREATED','0987654321','1 ','Female','2018-12-21 12:41:05','','1','47 ','0367543221','MANAGER','3','1'); /*!40000 ALTER TABLE `agent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `alldocuments` -- DROP TABLE IF EXISTS `alldocuments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `alldocuments` ( `id` int(50) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `img_id` varchar(50) NOT NULL, `userid` text NOT NULL, `date` varchar(50) DEFAULT NULL, `documentname` text DEFAULT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 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 */; INSERT INTO `alldocuments` VALUES (1,'2017-01-231485193168.png','4610641485193122','1',NULL,NULL,''); /*!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(40) 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, `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 `announcement` -- LOCK TABLES `announcement` WRITE; /*!40000 ALTER TABLE `announcement` DISABLE KEYS */; /*!40000 ALTER TABLE `announcement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bookroom` -- DROP TABLE IF EXISTS `bookroom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `bookroom` ( `id` int(40) NOT NULL AUTO_INCREMENT, `houseno` varchar(60) NOT NULL, `plotno` varchar(50) NOT NULL, `idno` varchar(50) NOT NULL, `tenantid` varchar(40) NOT NULL, `entrydate` varchar(50) NOT NULL, `description` text NOT NULL, `checkoutdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `createdat` varchar(50) NOT NULL, `updatedat` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, `amount` varchar(30) NOT NULL, `paymentstatus` varchar(30) NOT NULL, `paymentmode` varchar(30) NOT NULL, `paymentcode` varchar(30) NOT NULL, `totalamount` varchar(30) NOT NULL, `discount` varchar(30) NOT NULL, `transactioncode` varchar(30) NOT NULL, `roomtype` varchar(40) NOT NULL, `number` varchar(10) NOT NULL, `total` varchar(30) NOT NULL, `balance` varchar(30) NOT NULL, `mpesa` varchar(30) NOT NULL, `card` varchar(30) NOT NULL, `bookroom` varchar(20) NOT NULL, `credit` varchar(30) NOT NULL, `voucher` varchar(10) NOT NULL, `cheque` varchar(30) NOT NULL, `points` varchar(30) NOT NULL, `people` varchar(10) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transactioncode` (`transactioncode`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bookroom` -- LOCK TABLES `bookroom` WRITE; /*!40000 ALTER TABLE `bookroom` DISABLE KEYS */; INSERT INTO `bookroom` VALUES (1,'01','1','','9 ','','','2018-03-19 20:30:06','inactive','1','2018-03-19 20:28:37','','3','2500','Paid','','','','0','RC-43423334','2500','1','2500','0','0','0','','0','0','','',''),(3,'11','1','','10 ','','','2018-03-19 20:41:00','inactive','1','2018-03-19 20:39:35','','3','3000','Paid','','','','0','RC-25340220','3000','1','3000','0','0','0','','0','0','','',''),(4,'11','1','','9 ','','','2018-03-19 20:46:47','inactive','1','2018-03-19 20:45:08','','3','3000','Paid','','','','0','RC-02224435','3000','1','3000','0','0','0','','0','0','','',''),(5,'11','1','','9 ','','','2018-03-19 20:47:35','inactive','1','2018-03-19 20:46:48','','3','3000','Paid','','','','0','RC-04002647','3000','1','3000','0','0','0','','0','0','','',''),(7,'01','1','','8 ','','','2018-03-23 11:11:27','inactive','1','2018-03-19 21:31:35','','3','2000','Paid','','','','0','RC-42483340','2000','1','2000','0','0','0','','0','0','','',''),(8,'02','1','','8 ','','','2018-03-19 21:42:22','inactive','1','2018-03-19 21:40:50','','3','2000','Paid','','','','0','RC-22332233','2000','1','2000','0','0','0','','0','0','','',''),(9,'15','1','','8 ','','','2018-03-19 21:47:18','inactive','1','2018-03-19 21:46:42','','3','2000','Paid','','','','0','RC-65333242','2000','1','2000','0','0','0','','0','0','','',''),(10,'15','1','','9 ','','','2018-03-19 21:48:22','inactive','1','2018-03-18 21:47:18','','3','2000','Paid','','','','0','RC-92237545','2000','1','2000','0','0','0','','0','0','','',''),(12,'15','1','','2 ','','','2018-03-19 21:51:15','inactive','1','2018-03-19 21:49:57','','3','2500','Paid','','','','0','RC-26600206','2500','1','2500','0','0','0','','0','0','','',''),(20,'10','1','','7 ','','','2018-03-21 06:03:23','inactive','1','2018-03-20 22:32:47','','3','3000','Paid','','','','0','RC-03225253','3000','1','3000','0','0','0','','0','0','','',''),(21,'10','1','','7 ','','','2018-03-21 06:38:22','inactive','1','2018-03-21 06:03:23','','3','500','Paid','','','','0','RC-00220803','2500','1','2500','0','500','500','','500','500','','',''),(22,'10','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-21 06:38:22','','3','500','Paid','','','','0','RC-20233403','3000','1','3000','-500','500','500','','500','500','500','500',''),(23,'07','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-21 18:05:15','','3','500','Not Cleared','','2342342','','0','RC-20322322','3000','1','3000','','500','0','','500','500','500','500',''),(25,'15','1','','8 ','','','2018-03-23 11:34:16','inactive','1','2018-03-29 11:29:37','','3','2000','Cleared','','','','0','RC-23757522','2000','1','2000','0','0','0','','0','0','0','0','1'),(26,'15','1','','9 ','','','2018-03-23 12:58:11','inactive','1','2018-03-30 11:34:16','','3','2000','Cleared','','','','0','RC-20000432','2000','1','2000','0','0','0','','0','0','0','0','1'),(28,'15','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 12:58:11','','3','4000','Cleared','','','','0','RC-33393023','4000','2','4000','0','0','0','','0','0','0','0','1'),(29,'3','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:06:57','','3','4000','Cleared','','','','1000','RC-42423232','5000','2','4000','0','0','0','','0','0','0','0','1'),(30,'1','1','','5 ','','bbsabb','2018-03-24 18:32:42','inactive','1','2018-03-23 13:08:45','','3','8000','Cleared','','','','1000','RC-82452423','9000','3','8000','','0','0','','0','0','0','0','1'),(31,'2','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:24:12','','3','3000','Cleared','','','','1000','RC-22232320','4000','2','3000','0','0','0','','0','0','0','0','1'),(32,'5','1','','7 ','','','2018-03-23 13:38:59','inactive','1','2018-03-23 13:38:21','','3','5000','Cleared','','','','0','RC-23932302','5000','1','5000','0','0','0','','0','0','0','0','1'),(33,'5','1','','10 ','','','2018-03-23 13:40:35','inactive','1','2018-03-23 13:39:51','','3','9500','Cleared','','','','500','RC-33323433','5000','1','4500','-5000','0','0','','0','0','0','0','1'),(34,'5','1','','5 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:40:35','','3','9500','Cleared','','','','500','RC-37032230','10000','2','9500','0','0','0','','0','0','0','0','1'),(35,'06','1','','8 ','','Approved By ROBERT','2018-03-25 09:01:25','inactive','1','2018-03-23 13:42:34','','3','0','Cleared','','','','500','RC-52572830','3000','1','2500','0','2500','0','','0','0','0','0','1'),(36,'11','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 15:30:12','','3','2500','Cleared','','','','0','RC-32526823','2500','1','2500','0','0','0','','0','0','0','0','1'),(37,'16','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:19:35','','3','4000','Cleared','','','','0','RC-32644233','4000','1','4000','0','0','0','','0','0','0','0','1'),(38,'77','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:19:59','','3','0','Cleared','','','','0','RC-40833452','3000','1','3000','0','3000','0','','0','0','0','0','1'),(39,'87','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:20:22','','3','2500','Cleared','','','','0','RC-30005303','2500','1','2500','0','0','0','','0','0','0','0','1'),(40,'88','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:20:44','','3','0','Cleared','','','','0','RC-00224222','2500','1','2500','0','0','0','','0','2500','0','0','1'),(41,'23','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:21:19','','3','8000','Cleared','','','','0','RC-38222633','8000','1','8000','','0','0','','0','0','0','0','1'),(42,'66','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:22:31','','3','2000','Cleared','','','','1000','RC-02443233','3000','1','2000','0','0','0','','0','0','0','0','1'),(45,'76','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:40:04','','3','6000','Cleared','','','','0','RC-35423282','6000','2','6000','0','0','0','','0','0','0','0','1'),(46,'12','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:43:55','','3','2500','Cleared','','','','0','11521881052','2500','1','2500','0','0','0','','0','0','0','0','1'),(47,'36','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:47:49','','3','30000','Cleared','','','','0','5103020','3000','1','3000','-27000','0','0','','0','0','0','0','1'),(48,'17','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:48:55','','3','2000','Cleared','','','','0','522222','2000','1','2000','0','0','0','','0','0','0','0','1'),(49,'22','1','','6 ','','','2018-03-24 11:51:32','inactive','1','2018-03-24 11:49:39','','3','2500','Cleared','','','','0','05250','2500','1','2500','0','0','0','','0','0','0','0','1'),(50,'22','1','','6 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:51:32','','3','2500','Cleared','','','','0','23220','2500','1','2500','0','0','0','','0','0','0','0','1'),(51,'18','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:53:10','','3','2000','Cleared','','','','0','291222','2000','1','2000','0','0','0','','0','0','0','0','1'),(52,'1','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 18:32:42','','3','2500','Cleared','','','','0','11521905581','2500','1','2500','0','0','0','','0','0','0','0','1'),(53,'1','1','','9 ','','','2018-09-06 15:34:31','inactive','1','2018-03-25 09:07:09','','3','2500','Cleared','','','','0','11521958038','2500','1','2500','0','0','0','','0','0','0','0','1'),(54,'3','1','','11 ','','bb','2018-03-26 18:40:24','inactive','1','2018-03-26 18:39:14','','3','3000','Cleared','','','','0','11522078811','3000','1','3000','0','0','0','','0','0','0','0','1'),(55,'3','1','','11 ','','','2018-03-27 10:23:10','inactive','1','2018-03-28 18:40:24','','3','6000','Cleared','','','','0','11522078903','6000','2','6000','0','0','0','','0','0','0','0','1'),(56,'3','1','','11 ','','','2018-03-26 18:42:57','inactive','1','2018-03-26 18:41:44','','3','3000','Cleared','','','','0','11522078961','3000','1','3000','0','0','0','','0','0','0','0','1'),(57,'2','1','','11 ','','','2018-09-06 15:34:31','inactive','1','2018-03-27 09:24:36','','3','2000','Cleared','','','','0','11522131886','2000','1','2000','0','0','0','','0','0','0','0','1'),(58,'3','1','','5 ','','','2018-09-06 15:34:31','inactive','1','2018-03-27 09:50:25','','3','20001','Cleared','','','','5001','11522133446','2500','1','20002','','0','0','','0','0','0','0','1'),(59,'5','1','','7 ','','','2018-03-29 10:00:00','reserved','1','2018-03-28 10:25:29','','3','50000','Cleared','','','','0','11522135554','5000','1','5000','-45000','0','0','','0','0','0','0','1'),(60,'07','1','','9 ','','','2018-03-27 10:29:03','inactive','1','2018-03-27 10:26:56','','3','2500','Cleared','','','','0','11522135679','2500','1','2500','0','0','0','','0','0','0','0','1'),(61,'07','1','','8 ','','','2018-03-27 10:37:43','inactive','1','2018-03-27 10:33:11','','3','2500','Cleared','','','','0','11522136007','2500','1','2500','0','0','0','','0','0','0','0','1'),(62,'07','1','','6 ','','','2018-09-06 15:34:31','inactive','1','2018-03-27 10:37:49','','3','6000','Approved','','','','0','11522136285','6000','1','6000','','0','0','','0','0','0','0','1'),(63,'06','1','','13 ','','','2018-09-06 15:34:31','inactive','1','2018-05-05 18:37:06','','3','2500','Cleared','','','','0','11525534671','2000','1','2000','-500','0','0','','0','0','0','0','1'),(64,'01','5','','15 ','','','2018-09-06 15:34:31','inactive','1','2018-05-22 16:26:34','','3','15000','Cleared','','09','','0','11526995640','15000','1','15000','0','0','0','','0','0','0','0','1'),(65,'11','1','','14 ','','','2018-09-06 15:34:31','inactive','1','2018-05-22 16:28:44','','3','3000','Cleared','','','','0','11526995755','3000','1','3000','0','0','0','','0','0','0','0','1'),(66,'18','1','','14 ','','','2018-09-06 15:34:31','inactive','1','2018-06-30 23:28:21','','3','2000','Cleared','','','','0','11530390532','2000','1','2000','0','0','0','','0','0','0','0','1'),(67,'1','7','','18 ','','','2018-09-06 15:34:31','inactive','1','2018-08-29 12:55:13','','3','200','Cleared','','22222','','0','11535536569','1200','1','1200','','1000','0','','0','0','0','0','1'),(68,'32','1','','19 ','','bb','2018-09-06 15:34:31','inactive','1','2018-08-29 13:09:52','','3','8000','Cleared','','','','0','11535537485','8000','2','8000','','0','0','','0','0','0','0','1'),(69,'10','7','','21 ','','','2018-08-30 09:18:22','inactive','1','2018-08-30 09:08:48','','3','4500','Cleared','','','','0','11535609435','5000','1','5000','','500','0','','0','0','0','0','1'),(70,'01','5','','42 ','','','2018-09-07 15:59:28','inactive','10','2018-09-07 15:50:27','','3','1500','Cleared','','76','','0','101536324718','1500','1','1500','0','0','0','','0','0','0','0','1'),(71,'01','5','','42 ','','','2018-09-07 16:00:57','inactive','10','2018-09-07 15:59:58','','3','15000','Cleared','','23','','0','101536325233','15000','1','15000','0','0','0','','0','0','0','0','1'),(72,'01','5','','42 ','','','2018-09-08 11:57:59','inactive','1','2018-09-07 17:40:13','','3','15000','Cleared','','76','','0','101536331273','15000','1','15000','0','0','0','','0','0','0','0','1'),(73,'06','1','','43 ','','','2018-09-08 11:57:59','inactive','1','2018-09-07 17:43:01','','3','0','Cleared','','987','','0','101536331416','2500','1','2500','0','2500','0','','0','0','0','0','1'),(74,'07','1','','44 ','','','2018-09-08 11:57:59','inactive','1','2018-09-07 17:45:07','','3','2000','Cleared','','435','','0','101536331551','2000','1','2000','0','0','0','','0','0','0','0','1'),(75,'01','32','','53 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 05:47:59','','3','2500','Cleared','','4873','','0','11536547730','2500','1','2500','0','0','0','','0','0','0','0','1'),(76,'2','32','','52 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 05:53:00','','3','8000','Cleared','','7843','','0','11536548041','8000','1','8000','0','0','0','','0','0','0','0','1'),(77,'06','32','','51 ','','','2018-09-10 06:21:01','inactive','1','2018-09-10 05:54:28','','3','3000','Cleared','','873','','0','11536548102','3000','1','3000','0','0','0','','0','0','0','0','1'),(78,'1','36','','51 ','','','2018-09-10 06:20:38','inactive','1','2018-09-10 05:55:34','','3','5000','Cleared','','','','0','11536548153','5000','1','5000','0','0','0','','0','0','0','0','1'),(79,'1','34','','50 ','','','2018-09-10 06:21:24','inactive','1','2018-09-10 05:56:17','','3','3500','Cleared','','73','','0','11536548202','3500','1','3500','0','0','0','','0','0','0','0','1'),(80,'1','33','','47 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 06:00:39','','3','3000','Cleared','','794','','0','11536548469','3000','1','3000','0','0','0','','0','0','0','0','1'),(81,'4','36','','47 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 06:02:01','','3','4000','Cleared','','673','','0','11536548564','4000','1','4000','0','0','0','','0','0','0','0','1'),(82,'34','1','','48 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 06:10:00','','3','3500','Cleared','','5678','','0','11536549051','3500','1','3500','0','0','0','','0','0','0','0','1'),(83,'3','34','','49 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 06:18:06','','3','8000','Cleared','','','','0','11536549506','8000','1','8000','0','0','0','','0','0','0','0','1'),(84,'1','35','','51 ','','','2018-09-10 18:00:55','inactive','1','2018-09-10 07:42:23','','3','5000','Cleared','','782387','','0','11536554575','5000','1','5000','0','0','0','','0','0','0','0','1'),(85,'2','35','','45 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 07:44:06','','3','5000','Cleared','','783','','0','11536554665','5000','1','5000','0','0','0','','0','0','0','0','1'),(86,'3','35','','53 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 07:46:39','','3','5000','Cleared','','7788','','0','11536554821','5000','1','5000','0','0','0','','0','0','0','0','1'),(87,'4','35','','48 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 07:47:20','','3','8000','Cleared','','6789','','0','11536554863','8000','1','8000','0','0','0','','0','0','0','0','1'),(88,'5','35','','46 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 07:48:48','','3','10000','Cleared','','','','0','11536554948','10000','1','10000','0','0','0','','0','0','0','0','1'),(89,'06','1','','58 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 17:53:22','','3','3000','Cleared','','','','0','91536591251','3000','1','3000','0','0','0','','0','0','0','0','1'),(90,'1','37','','30 ','','','2018-09-11 13:51:44','inactive','1','2018-09-10 18:03:37','','3','4000','Cleared','','46','','0','11536591873','4000','1','4000','0','0','0','','0','0','0','0','1'),(91,'17','1','','65 ','','','2018-12-21 12:02:36','inactive','1','2018-09-26 15:17:30','','3','5000','Cleared','','','','0','261537964292','5000','2','5000','0','0','0','','0','0','0','0','1'),(92,'1','9','','66 ','','','2018-10-03 15:50:24','inactive','1','2018-09-26 15:43:58','','3','30000','Cleared','','','','0','261537965895','30000','3','30000','0','0','0','','0','0','0','0','1'),(93,'06','1','','67 ','','','2018-12-21 12:02:36','inactive','1','2018-09-26 16:16:16','','3','0','Cleared','','','','0','261537967809','2500','1','2500','0','2500','0','','0','0','0','0','1'),(94,'01','40','','68 ','','','2018-10-03 15:51:09','inactive','1','2018-09-26 16:17:54','','3','1000','Cleared','','','','0','261537967892','1000','1','1000','0','0','0','','0','0','0','0','1'),(95,'01','40','','69 ','','','2018-12-21 12:02:36','inactive','1','2018-10-22 05:07:07','','3','5000','Not Cleared','','','','0','91540174138','5000','5','5000','','0','0','','0','0','0','0','10'),(96,'1','40','','66 ','','','2018-12-21 12:02:36','inactive','1','2018-10-23 12:51:36','','3','1000','Cleared','','','','0','261540288343','1000','1','1000','0','0','0','','0','0','0','0','1'),(97,'06','1','','70 ','','','2019-02-18 08:57:43','inactive','30','2019-02-15 10:02:32','','3','3000','Cleared','','cash','','0','321550214281','2500','1','2500','-500','0','0','','0','0','0','0','1'),(98,'1','36','','77 ','','','2019-04-20 11:33:00','inactive','1','2019-03-01 10:28:04','','3','10000','Cleared','','','','0','11551425353','10000','2','10000','0','0','0','','0','0','0','0','1'),(99,'06','1','','70 ','','','2019-04-20 11:37:04','inactive','1','2019-04-20 11:33:16','','3','2000','Cleared','','','','0','11555749239','2000','1','2000','0','0','0','','0','0','0','0','1'); /*!40000 ALTER TABLE `bookroom` 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(40) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` text NOT NULL, `createdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT '1', `userid` varchar(50) NOT NULL, `updatedate` varchar(50) NOT NULL, `companyid` varchar(100) 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 `category` -- LOCK TABLES `category` WRITE; /*!40000 ALTER TABLE `category` DISABLE KEYS */; INSERT INTO `category` VALUES (1,'Employees','Employees','2017-02-14 04:31:05pm','1','1','','3'),(2,'Landlords','Landlords','2017-02-14 04:31:47pm','1','1','','3'),(3,'Friends','Friends','2017-02-14 04:32:02pm','1','1','','3'),(4,'Marketers','Marketers','2017-02-14 04:32:19pm','1','1','','3'),(5,'Customers','Customers','2017-02-14 04:32:41pm','1','1','','3'),(6,'landlords','','2018-09-04 12:08:23pm','1','3','','3'),(7,'suppliers','','2018-09-07 02:55:48pm','1','5','','3'),(8,'voters','','2018-09-07 02:56:18pm','1','5','','3'),(9,'agents','','2018-09-07 02:56:29pm','1','5','','3'),(10,'children','','2018-09-07 02:56:40pm','1','5','','3'),(11,'adults','','2018-09-07 02:56:51pm','1','5','','3'),(12,'sciences','','2018-09-07 02:57:11pm','1','5','','3'),(13,'teens','','2018-09-07 02:57:49pm','1','5','','3'),(14,'attendants','','2018-09-07 02:58:23pm','1','5','','3'),(15,'youth','','2018-09-07 02:59:08pm','1','5','','3'),(16,'elders','','2018-09-07 02:59:21pm','1','5','','3'),(17,'tenants','','2018-09-10 12:14:42pm','1','1','','3'),(18,'cleaners','','2018-09-10 12:15:08pm','1','1','','3'),(19,'agents','','2018-09-10 12:15:27pm','1','1','','3'),(20,'frequent cutomers','','2018-09-10 12:16:15pm','1','1','','3'),(21,'neighbours','','2018-09-10 05:24:55pm','1','9','','3'),(22,'groundsmen','','2018-09-10 05:25:11pm','1','9','','3'),(23,'watchmen','','2018-09-10 05:25:26pm','1','9','','3'),(24,'friends','','2018-09-10 05:25:48pm','1','9','','3'),(25,'clients','','2018-09-10 05:26:29pm','1','9','','3'),(26,'year','','2018-09-11 01:19:47pm','1','1','','3'),(27,'CLEANERS','','2018-12-21 12:43:10pm','1','1','','3'),(28,'staz','','2019-02-14 07:47:11pm','1','1','','3'),(29,'STAFF','','2019-02-14 07:47:23pm','1','30','','3'),(30,'customer','','2019-02-14 07:47:32pm','1','1','','3'); /*!40000 ALTER TABLE `category` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `charges` -- DROP TABLE IF EXISTS `charges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `charges` ( `id` int(100) NOT NULL AUTO_INCREMENT, `type` varchar(40) NOT NULL, `description` text NOT NULL, `status` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `charges` -- LOCK TABLES `charges` WRITE; /*!40000 ALTER TABLE `charges` DISABLE KEYS */; INSERT INTO `charges` VALUES (1,'RENT','','','2018-05-22 16:05:50','','',''),(2,'POLINE','','','2018-08-29 12:26:14','','',''),(3,'RENT','','','2018-09-04 12:30:07','','',''),(4,'BANK','1200000','','2018-09-07 11:02:07','','',''),(5,'AIRTEL','1399','','2018-09-07 11:02:32','','',''),(6,'SAFICOM','4000','','2018-09-07 11:02:54','','',''),(7,'ELECTRICITY','','','2018-09-07 11:36:06','','',''),(8,'INTERNET','','','2018-09-07 11:37:05','','',''),(9,'BREAKFAST','','','2018-09-07 11:38:42','','',''),(10,'LUNCH','','','2018-09-07 11:38:55','','',''),(11,'DINNER','','','2018-09-07 11:39:12','','',''),(12,'BED','','','2018-09-07 11:39:55','','',''),(13,'CCTV INSTALATION','','','2018-09-07 11:40:19','','',''),(14,'SHOPPING','','','2018-09-07 11:40:36','','',''),(15,'DELIVERY','','','2018-09-07 11:40:49','','',''),(16,'COMPUTER','','','2018-09-07 11:41:14','','',''),(17,'SWIMMING POOL','mantainance','','2018-09-10 06:24:20','','',''),(18,'WIFI','','','2018-09-10 16:42:23','','',''),(19,'ELECTRICITY','','','2018-09-10 16:50:46','','',''),(20,'SMS','','','2018-09-10 16:51:12','','',''),(21,'CLEANING','','','2018-09-10 17:29:09','','',''),(22,'INTERNET','','','2018-09-10 17:29:23','','',''),(23,'TOILETRIES','','','2018-09-10 17:45:46','','',''),(24,'WIFI','','','2018-09-10 17:46:04','','',''),(25,'SWIMMING POOL','','','2018-09-10 17:46:19','','',''),(26,'BANK','','','2018-11-02 16:39:13','','',''),(27,'BANK','1500','','2018-12-21 15:20:22','','',''); /*!40000 ALTER TABLE `charges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comments` -- DROP TABLE IF EXISTS `comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `comments` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` int(50) NOT NULL, `postid` varchar(100) NOT 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', `img_id` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comments` -- LOCK TABLES `comments` WRITE; /*!40000 ALTER TABLE `comments` DISABLE KEYS */; /*!40000 ALTER TABLE `comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coparentinvoice` -- DROP TABLE IF EXISTS `coparentinvoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `coparentinvoice` ( `id` int(40) NOT NULL AUTO_INCREMENT, `plotno` varchar(60) NOT NULL, `houseno` varchar(40) NOT NULL, `tenantid` varchar(100) NOT NULL, `amount` varchar(100) NOT NULL, `month` varchar(100) NOT NULL, `year` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `paymentstatus` varchar(40) NOT NULL, `paymentcode` varchar(100) NOT NULL, `transactioncode` varchar(100) NOT NULL, `rate` varchar(40) NOT NULL, `balance` varchar(40) NOT NULL, `duedate` varchar(40) NOT NULL, `type` varchar(30) NOT NULL DEFAULT 'coparent', `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 `coparentinvoice` -- LOCK TABLES `coparentinvoice` WRITE; /*!40000 ALTER TABLE `coparentinvoice` DISABLE KEYS */; /*!40000 ALTER TABLE `coparentinvoice` 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(20) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` varchar(255) DEFAULT NULL, `province` 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=51 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 county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'2','Kwale county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'3','Kilifi county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'4','Tana River county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'5','Lamu county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'6','Taita -Taveta county','Coast','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'7','Garissa county','North Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'8','Wajir county','North Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'9','Mandera county','North Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'10','Marsabit county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'11','Isiolo county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'12','Meru county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'13','Tharaka-Nithi county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'14','Embu county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'15','Kitui county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'16','Machakos county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'17','Makueni county','Eastern','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'18','Nyandarua county','Central','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'19','Nyeri county','Central','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'20','Kirinyaga county','Central','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'21','Murang\'a county','Central','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'22','Kiambu county','Central','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'23','Turkana county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'24','Westpokot county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'25','Samburu county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'26','Trans Nzoia county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'27','Uasin Gishu county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'28','Elgeyo-Marakwet county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'29','Nandi county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'30','Baringo county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'31','Laikipia county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'32','Nakuru county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'33','Narok county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'34','Kajiado county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'35','Kericho county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'36','Bomet county','Rift Valley','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,'37','Kakamega county','Western','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,'38','Vihiga county','Western','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,'39','Bungoma county','Western','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,'40','Busia county','Western','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,'41','Siaya county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,'42','kisumu county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,'43','Homabay county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'44','Migori county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'45','Kisii county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,'46','Nyamira county','Nyanza','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,'47','Nairobi city county','Nairobi','','0000-00-00 00:00:00','0000-00-00 00:00:00'),(50,'N/A','N/A','N/A','N/A','0000-00-00 00:00:00','0000-00-00 00:00:00'); /*!40000 ALTER TABLE `county` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenditure` -- DROP TABLE IF EXISTS `expenditure`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `expenditure` ( `id` int(40) NOT NULL AUTO_INCREMENT, `plotno` varchar(60) NOT NULL, `houseno` varchar(40) NOT NULL, `amount` varchar(100) NOT NULL, `type` varchar(100) NOT NULL, `description` text NOT NULL, `month` varchar(100) NOT NULL, `year` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `paymentstatus` varchar(40) NOT NULL, `paymentmode` varchar(40) NOT NULL, `transactioncode` varchar(100) NOT NULL, `approvedby` varchar(60) 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 `expenditure` -- LOCK TABLES `expenditure` WRITE; /*!40000 ALTER TABLE `expenditure` DISABLE KEYS */; /*!40000 ALTER TABLE `expenditure` 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, `plotno` varchar(50) NOT NULL, `houseno` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=49 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,'plot','1','-200','bulb','2018-03-24','robert','active','2018-03-24','123','12345','254718667391','shadrack','','463201521868129','1 ','na','3'),(2,'plot','7','-40000','N/A','2018-09-07','robert','active','2018-09-07','34','','','jane','','5155361536307390','10 ','10','3'),(3,'plot','7','-300','n/a','2018-09-07','jane','active','2018-09-07','6','','','robert','','6185421536308960','12 ','12','3'),(4,'Other','7','-120','fare','2018-09-07','jane','active','2018-09-07','3','','','robert','','4846721536309083','','','3'),(5,'Expense','7','-500','mouse','2018-09-07','jane','active','2018-09-07','4','','','robert','','2320001536309294','','','3'),(6,'Loan','7','-2000000','loan','2018-09-07','jane','active','2018-09-07','67','','','robert','','2616941536309388','','','3'),(7,'plot','7','-30000','n/a','2018-09-07','jane','active','2018-09-07','56','','','robert','','1383941536309495','8 ','8','3'),(8,'plot','7','-200000','n/a','2018-09-07','jane','active','2018-09-07','87','','','robert','','7086831536309636','11 ','11','3'),(9,'plot','7','-390000','n/a','2018-09-07','jane','active','2018-09-07','56','','','robert','','5244441536309697','12 ','12','3'),(10,'plot','5','-12000','rent','2018-09-07','stacey','active','2018-09-07','sta123','23432343','07009009','robert','','8451691536309718','21 ','1','3'),(11,'plot','5','-15000','rent ','2018-09-07','joy','active','2018-09-07','sta123','1234321','0712344321','robert','','7404101536310022','20 ','12','3'),(12,'Income','5','-17000','n/a','2018-09-07','stacey','active','2018-09-07','sta124','43231165','07234753454','dan','','7133581536311036','','','3'),(13,'Other','5','-10000','n/a','2018-09-07','ryan','active','2018-09-07','sta125','54398324','0712376445','sam','','3431501536311100','','','3'),(14,'Expense','5','-20000','N/A\r\n','2018-09-07','eve','active','2018-09-07','sta126','12760365','0732654912','susan','','2579541536311176','','','3'),(15,'Expense','5','-23000','n/a\r\n','2018-09-07','ellen','active','2018-09-07','sta127','45987541','0789473629','george','','9060871536311301','','','3'),(16,'Advance','5','-13000','n/a','2018-09-07','dylan','active','2018-09-07','sta128','438560','0733693481','telvin','','5667371536311457','','','3'),(17,'Loan','5','-14000','n/a\r\n','2018-09-07','ivan','active','2018-09-07','sta121','','','faith','','1543381536311579','','','3'),(18,'Advance','5','-16000','n/a\r\n','2018-09-07','john','active','2018-09-07','sta122','','','betty','','1354321536311720','','','3'),(19,'Collection','5','-9000','n/a','2018-09-07','eve','active','2018-09-07','sta129','','','ryan','','9842711536311891','','','3'),(20,'plot','5','-7000','n/a\r\n','2018-09-07','telvin','active','2018-09-07','sta111','','','ryan','','2268941536311951','8 ','2','3'),(21,'plot','5','-6700','n/a\r\n','2018-09-07','joy','active','2018-09-07','sta112','','','george','','3634601536312053','10 ','11','3'),(22,'plot','5','-4500','n/a','2018-09-07','faith','active','2018-09-07','sta113','','','hellen','','3792821536312173','11 ','5','3'),(23,'plot','5','-12000','n/a','2018-09-07','dan','active','2018-09-07','sat114','','','james','','2417741536312248','7 ','2','3'),(24,'Expense','9','-300','new brooms bought','2018-09-07','brooms','active','2018-09-07','2589','56734598','0203503002','sam','','9342881536314221','','','3'),(25,'Expense','1','-8000','rw','2018-09-08','maryann','active','2018-09-08','56789','5670','254716353410','maryann w','','6952021536397480','','','3'),(26,'Loan','1','-2547','eqwre','2018-09-08','maryann','active','2018-09-08','2345','25346','254716353410','wa','','5969611536397567','','','3'),(27,'Other','1','-135','efwa','2018-09-08','robert','active','2018-09-08','4325','25456','marryann w','marryann w','','5064031536397615','','','3'),(28,'plot','1','-240000','buying plot','2018-09-10','mloto','active','2018-09-10','6236t2801','76347692','079783iuw','admin','','1211811536549904','32 ','10','3'),(29,'plot','1','-37880','repairing sink','2018-09-10','viona','active','2018-09-10','276817921','72484729','073682427','admin','','4251211536549983','33 ','23','3'),(30,'plot','1','-4500','n/a','2018-09-10','asma','active','2018-09-10','45327829942','82678329','0876893789','abdi','','3271041536550033','34 ','7','3'),(31,'plot','1','-450','n/a','2018-09-10','husna','active','2018-09-10','723868329','69279843','08687237','abdi','','2878891536550104','35 ','6','3'),(32,'plot','1','-450','n/a','2018-09-10','lolo','active','2018-09-10','7642783282','32786871','nora','admin','','7578351536550165','36 ','4','3'),(33,'plot','1','-10000','water','2018-09-10','maryann','active','2018-09-10','56789','76t8','254716353410','marryann w','','1290661536559862','30 ','97','3'),(34,'plot','1','-13500','eletricity','2018-09-10','rosy','active','2018-09-10','66788','5678','254716368788','marryann','','9035041536560028','4 ','5','3'),(35,'plot','1','-9000','computer','2018-09-10','rosy','active','2018-09-10','8809','68789','254710998898','wa','','3965431536560121','38 ','12','3'),(36,'plot','1','-9000','computer','2018-09-10','rosy','active','2018-09-10','8809','68789','254710998898','wa','','3965431536560121','38 ','12','3'),(37,'Expense','9','-500','paid for tockens','2018-09-10','electricity','active','2018-09-10','5698','30518309','0718117773','admin','','3262341536590794','','','3'),(38,'Expense','9','-500','water for the whole month','2018-09-10','water','active','2018-09-10','45897','30518309','0718117773','admin','','8000701536590884','','','3'),(39,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(40,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(41,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(42,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(43,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(44,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(45,'Expense','9','-100','paid for cleaning the compound','2018-09-10','clearners','active','2018-09-10','45698','30518309','0718117773','admin','','9304041536590947','','','3'),(46,'plot','29','-4500','dss4r3etgc','2018-11-06','caleb','active','2018-11-06','45','325464786','436e76423','roberty','','4263631541494768','12 ','12345','3'),(47,'plot','1','-20000','PLOT','2018-12-21','GRACE','active','2018-12-21','6789077655555','567890-','077654321`','morgan','','7517141545384472','1 ','30','3'),(48,'Income','1','-1000','JHGFDSWQAWERGHJKL','2018-12-21','GRACE','active','2018-12-21','2345678','32993989','07896543232','morgan','','3218031545384879','','','3'); /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `generalbookroom` -- DROP TABLE IF EXISTS `generalbookroom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `generalbookroom` ( `id` int(40) NOT NULL AUTO_INCREMENT, `houseno` varchar(60) NOT NULL, `plotno` varchar(50) NOT NULL, `idno` varchar(50) NOT NULL, `tenantid` varchar(40) NOT NULL, `entrydate` varchar(50) NOT NULL, `description` text NOT NULL, `checkoutdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `createdat` varchar(50) NOT NULL, `updatedat` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, `amount` varchar(30) NOT NULL, `paymentstatus` varchar(30) NOT NULL, `paymentmode` varchar(30) NOT NULL, `paymentcode` varchar(30) NOT NULL, `totalamount` varchar(30) NOT NULL, `discount` varchar(30) NOT NULL, `transactioncode` varchar(30) NOT NULL, `roomtype` varchar(40) NOT NULL, `number` varchar(10) NOT NULL, `total` varchar(30) NOT NULL, `balance` varchar(30) NOT NULL, `mpesa` varchar(30) NOT NULL, `card` varchar(30) NOT NULL, `bookroom` varchar(20) NOT NULL, `credit` varchar(30) NOT NULL, `voucher` varchar(10) NOT NULL, `cheque` varchar(30) NOT NULL, `points` varchar(30) NOT NULL, `people` varchar(10) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `transactioncode` (`transactioncode`) ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `generalbookroom` -- LOCK TABLES `generalbookroom` WRITE; /*!40000 ALTER TABLE `generalbookroom` DISABLE KEYS */; INSERT INTO `generalbookroom` VALUES (1,'01','1','','9 ','','','2018-03-19 20:30:06','inactive','1','2018-03-19 20:28:37','','3','2500','Paid','','','','0','RC-43423334','2500','1','2500','0','0','0','','0','0','','',''),(3,'11','1','','10 ','','','2018-03-19 20:41:00','inactive','1','2018-03-19 20:39:35','','3','3000','Paid','','','','0','RC-25340220','3000','1','3000','0','0','0','','0','0','','',''),(4,'11','1','','9 ','','','2018-03-19 20:46:47','inactive','1','2018-03-19 20:45:08','','3','3000','Paid','','','','0','RC-02224435','3000','1','3000','0','0','0','','0','0','','',''),(5,'11','1','','9 ','','','2018-03-19 20:47:35','inactive','1','2018-03-19 20:46:48','','3','3000','Paid','','','','0','RC-04002647','3000','1','3000','0','0','0','','0','0','','',''),(7,'01','1','','8 ','','','2018-03-23 11:11:27','inactive','1','2018-03-19 21:31:35','','3','2000','Paid','','','','0','RC-42483340','2000','1','2000','0','0','0','','0','0','','',''),(8,'02','1','','8 ','','','2018-03-19 21:42:22','inactive','1','2018-03-19 21:40:50','','3','2000','Paid','','','','0','RC-22332233','2000','1','2000','0','0','0','','0','0','','',''),(9,'15','1','','8 ','','','2018-03-19 21:47:18','inactive','1','2018-03-19 21:46:42','','3','2000','Paid','','','','0','RC-65333242','2000','1','2000','0','0','0','','0','0','','',''),(10,'15','1','','9 ','','','2018-03-19 21:48:22','inactive','1','2018-03-18 21:47:18','','3','2000','Paid','','','','0','RC-92237545','2000','1','2000','0','0','0','','0','0','','',''),(12,'15','1','','2 ','','','2018-03-19 21:51:15','inactive','1','2018-03-19 21:49:57','','3','2500','Paid','','','','0','RC-26600206','2500','1','2500','0','0','0','','0','0','','',''),(20,'10','1','','7 ','','','2018-03-21 06:03:23','inactive','1','2018-03-20 22:32:47','','3','3000','Paid','','','','0','RC-03225253','3000','1','3000','0','0','0','','0','0','','',''),(21,'10','1','','7 ','','','2018-03-21 06:38:22','inactive','1','2018-03-21 06:03:23','','3','500','Paid','','','','0','RC-00220803','2500','1','2500','0','500','500','','500','500','','',''),(22,'10','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-21 06:38:22','','3','500','Paid','','','','0','RC-20233403','3000','1','3000','-500','500','500','','500','500','500','500',''),(23,'07','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-21 18:05:15','','3','500','Not Cleared','','2342342','','0','RC-20322322','3000','1','3000','','500','0','','500','500','500','500',''),(25,'15','1','','8 ','','','2018-03-23 11:34:16','inactive','1','2018-03-29 11:29:37','','3','2000','Cleared','','','','0','RC-23757522','2000','1','2000','0','0','0','','0','0','0','0','1'),(26,'15','1','','9 ','','','2018-03-23 12:58:11','inactive','1','2018-03-30 11:34:16','','3','2000','Cleared','','','','0','RC-20000432','2000','1','2000','0','0','0','','0','0','0','0','1'),(28,'15','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 12:58:11','','3','4000','Cleared','','','','0','RC-33393023','4000','2','4000','0','0','0','','0','0','0','0','1'),(29,'3','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:06:57','','3','4000','Cleared','','','','1000','RC-42423232','5000','2','4000','0','0','0','','0','0','0','0','1'),(30,'1','1','','5 ','','bbsabb','2018-03-24 18:32:42','inactive','1','2018-03-23 13:08:45','','3','8000','Cleared','','','','1000','RC-82452423','9000','3','8000','','0','0','','0','0','0','0','1'),(31,'2','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:24:12','','3','3000','Cleared','','','','1000','RC-22232320','4000','2','3000','0','0','0','','0','0','0','0','1'),(32,'5','1','','7 ','','','2018-03-23 13:38:59','inactive','1','2018-03-23 13:38:21','','3','5000','Cleared','','','','0','RC-23932302','5000','1','5000','0','0','0','','0','0','0','0','1'),(33,'5','1','','10 ','','','2018-03-23 13:40:35','inactive','1','2018-03-23 13:39:51','','3','9500','Cleared','','','','500','RC-33323433','5000','1','4500','-5000','0','0','','0','0','0','0','1'),(34,'5','1','','5 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 13:40:35','','3','9500','Cleared','','','','500','RC-37032230','10000','2','9500','0','0','0','','0','0','0','0','1'),(35,'06','1','','8 ','','Approved By ROBERT','2018-03-25 09:01:25','inactive','1','2018-03-23 13:42:34','','3','0','Cleared','','','','500','RC-52572830','3000','1','2500','0','2500','0','','0','0','0','0','1'),(36,'11','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-23 15:30:12','','3','2500','Cleared','','','','0','RC-32526823','2500','1','2500','0','0','0','','0','0','0','0','1'),(37,'16','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:19:35','','3','4000','Cleared','','','','0','RC-32644233','4000','1','4000','0','0','0','','0','0','0','0','1'),(38,'77','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:19:59','','3','0','Cleared','','','','0','RC-40833452','3000','1','3000','0','3000','0','','0','0','0','0','1'),(39,'87','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:20:22','','3','2500','Cleared','','','','0','RC-30005303','2500','1','2500','0','0','0','','0','0','0','0','1'),(40,'88','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:20:44','','3','0','Cleared','','','','0','RC-00224222','2500','1','2500','0','0','0','','0','2500','0','0','1'),(41,'23','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:21:19','','3','8000','Cleared','','','','0','RC-38222633','8000','1','8000','','0','0','','0','0','0','0','1'),(42,'66','1','','10 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:22:31','','3','2000','Cleared','','','','1000','RC-02443233','3000','1','2000','0','0','0','','0','0','0','0','1'),(45,'76','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 07:40:04','','3','6000','Cleared','','','','0','RC-35423282','6000','2','6000','0','0','0','','0','0','0','0','1'),(46,'12','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:43:55','','3','2500','Cleared','','','','0','11521881052','2500','1','2500','0','0','0','','0','0','0','0','1'),(47,'36','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:47:49','','3','30000','Cleared','','','','0','5103020','3000','1','3000','-27000','0','0','','0','0','0','0','1'),(48,'17','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:48:55','','3','2000','Cleared','','','','0','522222','2000','1','2000','0','0','0','','0','0','0','0','1'),(49,'22','1','','6 ','','','2018-03-24 11:51:32','inactive','1','2018-03-24 11:49:39','','3','2500','Cleared','','','','0','05250','2500','1','2500','0','0','0','','0','0','0','0','1'),(50,'22','1','','6 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:51:32','','3','2500','Cleared','','','','0','23220','2500','1','2500','0','0','0','','0','0','0','0','1'),(51,'18','1','','7 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 11:53:10','','3','2000','Cleared','','','','0','291222','2000','1','2000','0','0','0','','0','0','0','0','1'),(52,'1','1','','8 ','','','2018-03-25 09:01:25','inactive','1','2018-03-24 18:32:42','','3','2500','Cleared','','','','0','11521905581','2500','1','2500','0','0','0','','0','0','0','0','1'),(53,'1','1','','9 ','','','2018-03-26 10:00:00','active','1','2018-03-25 09:07:09','','3','2500','Cleared','','','','0','11521958038','2500','1','2500','0','0','0','','0','0','0','0','1'),(54,'3','1','','11 ','','bb','2018-03-26 18:40:24','inactive','1','2018-03-26 18:39:14','','3','3000','Cleared','','','','0','11522078811','3000','1','3000','0','0','0','','0','0','0','0','1'),(55,'3','1','','11 ','','','2018-03-27 10:23:10','inactive','1','2018-03-28 18:40:24','','3','6000','Cleared','','','','0','11522078903','6000','2','6000','0','0','0','','0','0','0','0','1'),(56,'3','1','','11 ','','','2018-03-26 18:42:57','inactive','1','2018-03-26 18:41:44','','3','3000','Cleared','','','','0','11522078961','3000','1','3000','0','0','0','','0','0','0','0','1'),(57,'2','1','','11 ','','','2018-03-28 10:00:00','active','1','2018-03-27 09:24:36','','3','2000','Cleared','','','','0','11522131886','2000','1','2000','0','0','0','','0','0','0','0','1'),(58,'3','1','','5 ','','','2018-03-28 10:00:00','active','1','2018-03-27 09:50:25','','3','20001','Cleared','','','','5001','11522133446','2500','1','20002','','0','0','','0','0','0','0','1'),(59,'5','1','','7 ','','','2018-03-29 10:00:00','reserved','1','2018-03-28 10:25:29','','3','50000','Cleared','','','','0','11522135554','5000','1','5000','-45000','0','0','','0','0','0','0','1'),(60,'07','1','','9 ','','','2018-03-27 10:29:03','inactive','1','2018-03-27 10:26:56','','3','2500','Cleared','','','','0','11522135679','2500','1','2500','0','0','0','','0','0','0','0','1'),(61,'07','1','','8 ','','','2018-03-27 10:37:43','inactive','1','2018-03-27 10:33:11','','3','2500','Cleared','','','','0','11522136007','2500','1','2500','0','0','0','','0','0','0','0','1'),(62,'07','1','','6 ','','','2018-03-28 10:00:00','active','1','2018-03-27 10:37:49','','3','6000','Approved','','','','0','11522136285','6000','1','6000','','0','0','','0','0','0','0','1'); /*!40000 ALTER TABLE `generalbookroom` 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(40) 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(100) 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 `grouping` -- LOCK TABLES `grouping` WRITE; /*!40000 ALTER TABLE `grouping` DISABLE KEYS */; INSERT INTO `grouping` VALUES (1,'12','1','2018-09-11 01:20:51pm','','1','','26','3'),(2,'12','1','2019-02-14 07:49:56pm','','0','2019-02-14 07:50:29pm','15','3'),(3,'12','1','2019-02-14 07:50:51pm','','1','','28','3'); /*!40000 ALTER TABLE `grouping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `house` -- DROP TABLE IF EXISTS `house`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `house` ( `id` int(100) NOT NULL AUTO_INCREMENT, `houseno` varchar(100) NOT NULL, `type` varchar(40) NOT NULL, `description` text NOT NULL, `plotno` varchar(100) NOT NULL, `cost` varchar(100) NOT NULL, `status` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `floor` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `house` -- LOCK TABLES `house` WRITE; /*!40000 ALTER TABLE `house` DISABLE KEYS */; INSERT INTO `house` VALUES (1,'1','Single','','1','','vacant','2018-07-01 19:38:51','2018-09-06 15:34:31','1','GF','3'),(2,'2','Single','','1','','vacant','2018-03-23 13:05:23','2018-09-06 15:34:31','1','GF','3'),(3,'3','Single','','1','','vacant','2018-03-23 13:05:39','2018-09-06 15:34:31','1','GF','3'),(5,'5','Twin','','1','','reserved','2018-03-23 13:05:49','2018-03-25 09:01:25','1','GF','3'),(6,'06','Single','vacated','1','','vacant','2019-05-22 15:25:43','2019-05-22 15:25:43','1','GF','3'),(7,'07','Single','','1','','vacant','2018-03-27 10:33:00','2018-09-08 11:57:59','1','GF','3'),(10,'11','Single','','1','','vacant','2018-07-01 19:50:13','2018-09-06 15:34:31','1','GF','3'),(11,'12','Single','','1','','occupied','2018-09-06 12:19:11','2018-09-06 12:19:11','1','GF','3'),(13,'15','Single','','1','','vacant','2018-03-13 14:05:55','2018-03-25 09:01:25','1','1STF','3'),(14,'16','Single','','1','','vacant','2018-03-13 14:22:56','2018-03-25 09:01:25','1','1STF','3'),(15,'17','Single','','1','','vacant','2018-03-13 14:23:22','2018-12-21 12:02:36','1','1STF','3'),(16,'18','Single','','1','','vacant','2018-03-13 14:24:52','2018-09-06 15:34:31','1','1STF','3'),(17,'19','Single','','1','','vacant','2018-03-13 14:25:19','','1','1STF','3'),(18,'20','Single','','1','','vacant','2018-03-13 14:25:35','','1','1STF','3'),(19,'21','Single','','1','','vacant','2018-03-13 14:25:44','2018-03-14 14:52:00','5','1STF','3'),(20,'22','Single','','1','','vacant','2018-03-13 14:28:16','2018-03-25 09:01:25','1','1STF','3'),(21,'23','Single','','1','','vacant','2018-03-13 14:42:16','2018-03-25 09:01:25','1','1STF','3'),(22,'24','Double','','1','','vacant','2018-03-13 14:42:30','','1','1STF','3'),(23,'25','Single','','1','','occupied','2018-03-13 14:43:40','','1','1STF','3'),(24,'26','Single','','1','','vacant','2018-03-13 14:43:57','2018-03-14 14:52:00','5','1STF','3'),(25,'27','Twin','','1','','vacant','2018-03-13 14:44:10','','1','1STF','3'),(26,'28','Single','','1','','vacant','2018-03-13 14:44:25','','1','1STF','3'),(27,'29','Single','','1','','vacant','2018-03-13 14:44:43','','1','1STF','3'),(28,'30','Single','','1','','vacant','2018-03-13 14:44:50','','1','1STF','3'),(29,'32','Double','','1','','vacant','2018-03-13 14:45:36','2018-09-06 15:34:31','1','1STF','3'),(30,'33','Double','','1','','vacant','2018-03-13 14:45:51','','1','1STF','3'),(31,'34','Double','','1','','vacant','2018-03-13 14:46:14','2018-09-11 13:51:44','1','1STF','3'),(32,'35','Single','','1','','vacant','2018-03-13 14:46:33','','1','2NDF','3'),(33,'36','Single','','1','','vacant','2018-03-13 14:47:07','2018-03-25 09:01:25','1','2NDF','3'),(34,'37','Twin','','1','','vacant','2018-03-13 14:47:58','2018-03-14 10:25:20','6','2NDF','3'),(35,'38','Single','','1','','vacant','2018-03-13 14:48:13','','1','2NDF','3'),(36,'39','Single','','1','','vacant','2018-03-13 14:48:29','','1','2NDF','3'),(37,'40','Single','','1','','vacant','2018-03-13 14:49:26','','1','2NDF','3'),(38,'41','Single','','1','','vacant','2018-03-13 14:49:36','','1','2NDF','3'),(39,'42','Single','','1','','vacant','2018-03-13 14:49:48','','1','2NDF','3'),(40,'43','Single','','1','','vacant','2018-03-13 14:50:00','','1','2NDF','3'),(41,'44','Single','','1','','vacant','2018-03-13 14:50:18','','1','2NDF','3'),(42,'45','Double','','1','','occupied','2018-03-13 14:50:29','','1','2NDF','3'),(43,'46','Single','','1','','vacant','2018-03-13 14:52:21','','1','2NDF','3'),(44,'47','Single','','1','','vacant','2018-03-13 14:52:33','','1','2NDF','3'),(45,'48','Twin','','1','','vacant','2018-03-13 14:52:47','','1','2NDF','3'),(46,'49','Single','','1','','vacant','2018-03-13 14:53:10','','1','2NDF','3'),(47,'50','Single','','1','','vacant','2018-03-13 14:53:22','2018-03-14 18:40:25','5','2NDF','3'),(48,'51','Single','','1','','vacant','2018-03-13 14:53:40','2018-03-19 15:37:22','9','2NDF','3'),(49,'52','Single','','1','','vacant','2018-03-13 14:53:54','','1','2NDF','3'),(50,'53','Single','','1','','vacant','2018-03-13 14:54:08','','1','2NDF','3'),(51,'54','Double','','1','','vacant','2018-03-13 14:54:41','','1','2NDF','3'),(52,'55','Single','','1','','vacant','2018-03-13 14:55:41','','1','2NDF','3'),(53,'56','Single','','1','','vacant','2018-03-13 14:56:01','','1','3RDF','3'),(54,'57','Single','','1','','vacant','2018-03-13 14:56:16','','1','3RDF','3'),(55,'58','Double','','1','','vacant','2018-03-13 14:57:40','','1','3RDF','3'),(56,'59','Single','','1','','vacant','2018-03-13 14:57:55','','1','3RDF','3'),(57,'60','Single','','1','','vacant','2018-03-13 14:58:16','','1','3RDF','3'),(58,'61','Single','','1','','vacant','2018-03-13 14:58:51','','1','3RDF','3'),(59,'62','Single','','1','','vacant','2018-03-13 14:59:16','','1','3RDF','3'),(60,'63','Single','','1','','vacant','2018-03-13 14:59:29','','1','3RDF','3'),(61,'64','Single','','1','','vacant','2018-03-13 14:59:46','','1','3RDF','3'),(62,'65','Single','','1','','vacant','2018-03-13 15:00:25','','1','GF','3'),(63,'66','Single','','1','','vacant','2018-03-13 15:00:41','2018-03-25 09:01:25','1','3RDF','3'),(64,'67','Single','','1','','vacant','2018-03-13 15:00:53','','1','3RDF','3'),(65,'68','Single','','1','','vacant','2018-03-13 15:01:17','','1','3RDF','3'),(66,'69','Twin','','1','','vacant','2018-03-13 15:01:35','','1','3RDF','3'),(67,'70','Single','','1','','occupied','2018-03-13 15:01:57','','1','3RDF','3'),(68,'71','Single','','1','','vacant','2018-03-13 15:02:21','','1','3RDF','3'),(69,'72','Single','','1','','vacant','2018-03-13 15:19:03','','1','3RDF','3'),(70,'73','Single','','1','','vacant','2018-03-13 15:19:52','','1','3RDF','3'),(71,'74','Single','','1','','vacant','2018-03-13 15:20:09','','1','3RDF','3'),(72,'75','Single','','1','','vacant','2018-03-13 15:20:26','','1','3RDF','3'),(73,'76','Single','','1','','vacant','2018-03-13 15:20:48','2018-03-25 09:01:25','1','3RDF','3'),(74,'77','Single','','1','','vacant','2018-03-13 15:21:14','2018-03-25 09:01:25','1','4TH','3'),(75,'78','Single','','1','','vacant','2018-03-13 15:21:40','','1','4TH','3'),(76,'79','Single','','1','','vacant','2018-03-13 15:22:05','','1','4TH','3'),(77,'80','Single','','1','','vacant','2018-03-13 15:22:26','','1','4TH','3'),(78,'81','Single','','1','','vacant','2018-03-13 15:22:43','','1','4TH','3'),(79,'82','Single','','1','','vacant','2018-03-13 15:25:30','','1','4TH','3'),(80,'83','Single','','1','','vacant','2018-03-13 15:26:04','','1','4THF','3'),(81,'84','Single','','1','','vacant','2018-03-13 15:26:44','','1','4THF','3'),(82,'85','Single','','1','','vacant','2018-03-13 15:27:40','','1','4THF','3'),(83,'86','Single','','1','','vacant','2018-03-13 15:27:59','','1','4THF','3'),(84,'87','Single','','1','','vacant','2018-03-13 15:28:48','2018-03-25 09:01:25','1','4THF','3'),(85,'88','Single','','1','','vacant','2018-03-13 15:29:06','2018-03-25 09:01:25','1','4THF','3'),(86,'89','Double','','1','','vacant','2018-03-13 15:29:28','','1','4THF','3'),(87,'90','Single','','1','','vacant','2018-03-13 15:29:50','','1','4THF','3'),(88,'91','Single','','1','','vacant','2018-03-13 15:30:03','','1','4THF','3'),(89,'G1','Double','','3','','vacant','2018-04-06 15:10:34','','1','GF','3'),(90,'G2','Twin','','3','','vacant','2018-04-06 15:10:55','','1','GF','3'),(91,'2','Single','','4','','vacant','2018-05-22 14:49:33','','1','GF','3'),(92,'o7','Bedsiter','','6','','vacant','2018-05-22 16:14:15','','1','GF','3'),(93,'12','Bedsiter','','9','','reserved','2018-09-08 12:21:49','2018-09-08 12:21:49','1','3RDF','3'),(94,'1','Single','','7','','vacant','2018-09-06 11:46:17','2018-09-06 15:34:31','1','GF','3'),(95,'2','Single','','7','','vacant','2018-08-29 12:07:27','','1','GF','3'),(96,'3','Bedsiter','','7','','vacant','2018-08-29 12:08:43','','1','GF','3'),(97,'4','Bedsiter','','7','','vacant','2018-08-29 12:09:38','','1','1STF','3'),(98,'5','Bedsiter','','7','','vacant','2018-08-29 12:10:27','','1','1STF','3'),(99,'6','Single','','7','','vacant','2018-08-29 12:10:56','','1','2NDF','3'),(100,'7','Double','','7','','vacant','2018-08-29 12:11:43','','1','2NDF','3'),(101,'8','One bedroom','','7','','vacant','2018-08-29 12:13:11','','1','3RDF','3'),(102,'9','One bedroom','','7','','vacant','2018-08-29 12:14:05','','1','3RDF','3'),(103,'10','Two bedroom','','7','','occupied','2018-09-06 12:00:14','2018-09-06 12:00:14','1','4THF','3'),(104,'1','Bedsiter','','8','','vacant','2018-09-06 12:29:37','2018-09-06 12:29:37','1','GF','3'),(105,'18','Double','','18','','reserved','2018-09-07 10:39:06','','7','1STF','3'),(106,'10','Twin','','10','','vacant','2018-09-07 10:44:17','','7','2NDF','3'),(107,'14','Bedsiter','','10','','reserved','2018-09-07 10:46:02','','7','GF 1SFT 2NDF','3'),(108,'dayin','Bedsiter','','1','','vacant','2018-09-07 17:50:16','','5','GF','3'),(109,'10','Single','','41','','reserved','2018-11-02 16:41:57','2018-11-02 16:41:57','9','1StF','3'),(110,'2','Double','','32','','vacant','2018-09-09 19:53:15','2018-09-11 13:51:44','1','GF','3'),(111,'3','Single','','32','','vacant','2018-09-09 19:53:38','','1','GF','3'),(112,'4','Bedsiter','','32','','vacant','2018-09-09 19:54:13','','1','GF','3'),(113,'5','Twin','','32','','vacant','2018-09-09 19:54:24','','1','GF','3'),(114,'07','Double','','30','','vacant','2018-12-21 12:08:07','2018-12-21 12:08:07','1','GF','3'),(115,'7','Double','','32','','vacant','2018-09-09 19:55:40','','1','GF','3'),(116,'8','Double','','32','','vacant','2018-09-09 19:55:52','','1','GF','3'),(117,'9','Three bedroom','','32','','vacant','2018-09-09 19:56:04','','1','GF','3'),(118,'10','Twin','','32','','occupied','2018-09-10 18:46:04','2018-09-10 18:46:04','5','GF','3'),(119,'11','One bedroom','','32','','vacant','2018-09-09 19:56:25','','1','GF','3'),(120,'1','Single','','33','','vacant','2018-09-09 19:58:41','2018-09-11 13:51:44','1','GF','3'),(121,'2','Bedsiter','','33','','vacant','2018-09-09 19:58:49','','1','GF','3'),(122,'3','Double','','33','','vacant','2018-09-09 19:59:04','','1','GF','3'),(123,'4','Twin','','33','','vacant','2018-09-09 20:00:49','','1','GF','3'),(124,'5','One bedroom','','33','','vacant','2018-09-09 20:00:59','','1','GF','3'),(125,'6','Single','','33','','vacant','2018-09-09 20:01:07','','1','GF','3'),(126,'7','Bedsiter','','33','','vacant','2018-09-09 20:01:42','','1','GF','3'),(127,'8','Double','','33','','vacant','2018-09-09 20:01:55','','1','GF','3'),(128,'9','Twin','','33','','vacant','2018-09-09 20:02:40','','1','GF','3'),(129,'10','Double','','33','','vacant','2018-09-09 20:02:53','','1','GF','3'),(131,'2','Bedsiter','','34','','vacant','2018-09-09 20:04:54','','1','GF','3'),(132,'3','Double','','34','','vacant','2018-09-09 20:05:03','2018-09-11 13:51:44','1','GF','3'),(133,'4','Double','','34','','vacant','2018-09-09 20:05:14','','1','GF','3'),(134,'5','Twin','','34','','vacant','2018-09-09 20:08:28','','1','GF','3'),(135,'1','Single','','35','','vacant','2018-09-09 20:12:40','2018-09-10 18:00:55','1','GF','3'),(136,'2','Bedsiter','','35','','vacant','2018-09-09 20:12:51','2018-09-11 13:51:44','1','GF','3'),(137,'3','Double','','35','','vacant','2018-09-09 20:12:59','2018-09-11 13:51:44','1','GF','3'),(138,'4','Twin','','35','','vacant','2018-09-09 20:13:08','2018-09-11 13:51:44','1','GF','3'),(139,'5','One bedroom','','35','','vacant','2018-09-09 20:13:17','2018-09-11 13:51:44','1','GF','3'),(140,'1','Bedsiter','','36','','vacant','2019-04-20 11:28:23','2019-04-20 11:33:00','1','GF','3'),(141,'2','Single','','36','','vacant','2018-09-09 20:13:54','','1','GF','3'),(142,'3','Bedsiter','','36','','vacant','2018-09-09 20:14:01','','1','GF','3'),(143,'4','Twin','','36','','vacant','2018-09-09 20:14:09','2018-09-11 13:51:44','1','GF','3'),(144,'5','Twin','','36','','vacant','2018-09-09 20:14:17','','1','GF','3'),(145,'1','Three bedroom','','9','','vacant','2018-09-26 15:42:25','2018-10-03 15:50:24','1','1stf','3'),(146,'11','Bedsiter','','40','','vacant','2018-09-10 15:47:56','','9','GF','3'),(147,'1','Bedsiter','','40','','vacant','2018-10-23 12:54:18','2018-12-21 12:02:36','1','GF','3'),(148,'2','Bedsiter','','40','','vacant','2018-09-10 15:48:38','','9','GF','3'),(149,'3','Bedsiter','','40','','vacant','2018-09-10 15:48:52','','9','GF','3'),(150,'4','Bedsiter','','40','','vacant','2018-09-10 15:49:13','','9','GF','3'),(151,'5','Bedsiter','','40','','vacant','2018-09-10 15:49:27','','9','GF','3'),(152,'6','One bedroom','','40','','vacant','2018-09-10 15:50:05','','9','1STF','3'),(153,'7','One bedroom','','40','','vacant','2018-09-10 15:50:35','','9','1STF','3'),(154,'8','One bedroom','','40','','vacant','2018-09-10 15:50:56','','9','1STF','3'),(155,'9','One bedroom','','40','','vacant','2018-09-10 15:51:15','','9','1STF','3'),(156,'1','Double','','37','','vacant','2018-09-10 16:29:51','2018-09-11 13:51:44','1','GF','3'),(157,'6','One bedroom','','37','','vacant','2018-09-10 16:32:39','','1','2ND','3'),(158,'77','Bedsiter','','37','','reserved','2018-09-10 16:33:42','','1','2ND','3'),(159,'1234','Bedsiter','CLEAN HOUSE WITH CLEANERS','32','','vacant','2018-11-06 09:17:25','','1','GF','3'),(160,'12345','Three bedroom','CLEAN HOUSE WITH ALL THE REQUIREMENTS','32','','vacant','2018-11-06 09:20:25','','1','GF','3'),(161,'232','Bedsiter','sdfdgdd','1','','vacant','2018-11-06 10:07:19','','1','GF','3'),(162,'232','Double','','30','','reserved','2018-11-06 11:32:20','','29','GF','3'),(163,'6788888','Bedsiter','GHGFGD','32','','vacant','2018-11-07 12:46:46','','29','GF','3'),(164,'38','Three bedroom','','30','','vacant','2018-12-21 12:08:59','','1','3RDF','3'); /*!40000 ALTER TABLE `house` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `house1` -- DROP TABLE IF EXISTS `house1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `house1` ( `id` int(100) NOT NULL AUTO_INCREMENT, `houseno` varchar(100) NOT NULL, `type` varchar(40) NOT NULL, `description` text NOT NULL, `plotno` varchar(100) NOT NULL, `cost` varchar(100) NOT NULL, `status` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `floor` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `house1` -- LOCK TABLES `house1` WRITE; /*!40000 ALTER TABLE `house1` DISABLE KEYS */; INSERT INTO `house1` VALUES (2,'A2','Single','','1','','vacant','2018-01-15 14:13:41','2018-03-17 20:59:42','1','GF','3'),(3,'A1','Single','','1','','vacant','2018-01-15 14:27:25','2018-03-16 06:47:43','1','GF','3'),(4,'A4','Single','','1','','occupied','2018-01-15 13:41:38','2018-03-14 05:48:16','1','GF','3'),(5,'A5','One bedroom','','1','','vacant','2018-01-13 02:52:22','2018-03-14 07:21:51','1','GF','3'),(6,'2','Bedsiter','','1','','active','2018-01-13 02:52:33','2018-03-19 13:53:17','1','GF','3'),(7,'A6','Bedsiter','','1','','occupied','2018-02-15 03:43:49','2018-03-14 05:48:46','1','GF','3'),(8,'A7','Bedsiter','','1','','occupied','2018-02-15 03:43:59','2018-03-14 05:48:57','1','GF','3'),(9,'A8','Single','','1','','occupied','2018-02-15 03:44:35','2018-03-14 05:39:16','1','GF','3'); /*!40000 ALTER TABLE `house1` 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` ( `name` text NOT NULL, `imageid` varchar(50) NOT NULL, `user` text NOT NULL, `id` int(40) NOT NULL AUTO_INCREMENT, `companyid` varchar(100) NOT NULL, `userid` 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 `images` -- LOCK TABLES `images` WRITE; /*!40000 ALTER TABLE `images` DISABLE KEYS */; /*!40000 ALTER TABLE `images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoice` -- DROP TABLE IF EXISTS `invoice`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `invoice` ( `id` int(40) NOT NULL AUTO_INCREMENT, `plotno` varchar(60) NOT NULL, `houseno` varchar(40) NOT NULL, `tenantid` varchar(100) NOT NULL, `amount` varchar(100) NOT NULL, `type` varchar(100) NOT NULL, `description` varchar(100) NOT NULL, `month` varchar(100) NOT NULL, `year` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `duedate` varchar(40) NOT NULL, `paymentstatus` varchar(40) NOT NULL, `paymentmode` varchar(40) NOT NULL, `paymentcode` varchar(100) NOT NULL, `transactioncode` varchar(100) NOT NULL, `approval` varchar(30) NOT NULL DEFAULT 'new', `approvedby` varchar(60) NOT NULL, `approvaldate` varchar(60) NOT NULL, `totalamount` varchar(40) NOT NULL, `paid` varchar(40) NOT NULL, `balance` varchar(40) NOT NULL DEFAULT '0', `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice` -- LOCK TABLES `invoice` WRITE; /*!40000 ALTER TABLE `invoice` DISABLE KEYS */; /*!40000 ALTER TABLE `invoice` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `landlord` -- DROP TABLE IF EXISTS `landlord`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `landlord` ( `id` int(40) NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `phone` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `description` text NOT NULL, `idno` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `gender` varchar(10) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `county` varchar(40) NOT NULL, `accountname` varchar(100) NOT NULL, `accountno` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `landlord` -- LOCK TABLES `landlord` WRITE; /*!40000 ALTER TABLE `landlord` DISABLE KEYS */; INSERT INTO `landlord` VALUES (1,'senate','senate','senate','senate','','','25689458','1 ','','2018-09-04 11:35:28','2018-09-04 11:35:28','1','50 ','','','3','1'),(2,'henry','mwaura','juja','0704127383','henerymwaura@gmail.com','','33358794','1 ','Female','2018-05-05 18:27:07','2018-05-05 18:27:07','1','50 ','beth kavula','3456987','3','1'),(3,'Harry','Mwaura','Juja','254718641189','hm.mail.254@gmail.com','','29905907','1 ','Male','2018-07-01 19:36:15','2018-07-01 19:36:15','1','22 ','','','3','1'),(4,'poline','kuria','Nairobi','254725851278','kuriapoline@gmail.com','','123456','1 ','Female','2018-08-29 11:42:35','','1','50 ','KCB','4444444','3','1'),(5,'stacey','njeri','','254703600611','stacey@gmail.com','','36646376','1 ','Female','2018-09-04 12:03:58','','1','50 ','KCB','67894312','3','1'),(6,'jack','kamau','nakuru','254718067296','','','3565','1 ','Female','2019-02-11 14:39:00','2019-02-11 14:39:00','31','50 ','','','3','1'),(7,'myk','deni','Nairobi','25478907534','','','1246795','1 ','','2019-02-11 14:39:35','2019-02-11 14:39:35','31','50 ','','','3','1'),(9,'lillian','njuguna','Machakos','','','','21864346','1 ','','2019-02-11 14:40:50','2019-02-11 14:40:50','31','16 ','','','3','1'),(10,'calvin','ojiambi','nairobi','0745476532','','','65347865','1 ','','2018-09-07 12:48:51','','5','50 ','','','3','1'),(11,'reign','garan','nakuru','073467323','','','65397534','1 ','','2018-09-07 12:49:25','','5','50 ','','','3','1'),(12,'john','uino','nyeri','074989929','john@gmail.com','','76463766','1 ','','2018-09-07 12:53:41','','5','50 ','','','3','1'),(13,'george','rara','naivasha','0700055434','rara@gmail.com','','45375634','1 ','','2018-09-07 12:55:32','','5','50 ','','','3','1'),(14,'james','tetui','utawala','0734734745','james@gmail.com','','3467845','1 ','','2018-09-07 12:57:31','','5','50 ','','','3','1'),(15,'mary','wanjiru','wangige','0724756546','maryw@gmail.com','','568936436','1 ','','2018-09-07 14:33:43','','5','50 ','','','3','1'),(16,'reomo','tuna','nairobi','0716466789','reomo@gmail.com','','7765654','1 ','','2018-09-07 14:38:37','','5','50 ','','','3','1'),(17,'mary','kamau','JUJA','254716343510','rosemarykamau55@gmail.com','juja landlord','5677','1 ','Female','2018-09-08 11:39:41','','1','50 ','equity','233334','3','1'),(18,'wakik','vak','thika','254716343590','wikw@gmail.com','thika landlord','4567','1 ','','2018-09-08 11:41:30','','1','50 ','equity','3456','3','1'),(19,'doss','quick','Jericho','254767890','doss@gmail.com','Jericho','4589','1 ','Female','2019-01-25 15:18:15','2019-01-25 15:18:15','30','47 ','kcb','657o65789','3','1'),(20,'LUCAS','MWANGI','JUJA','0789654234','lucasm@gmail.com','','270896452','1 ','Male','2018-09-09 19:08:01','','1','50 ','BARCLAYS','27098657244','3','1'),(21,'LUCY','NJERI','JUJA','0789654237','lucy2@gmail.com','','249876345','1 ','Female','2018-09-09 19:09:38','','1','50 ','BARCLAYS','6251793557919','3','1'),(22,'LAMECK','MOINDI','JUJA','0786523471','lamechj@gmail.com','','2678497636','1 ','Male','2018-09-09 19:10:42','','1','50 ','BARCLAYS','3457289884','3','1'),(23,'LEAH','MAINA','JUJA','0783456273','leahf@gmail.com','','435902643','1 ','Female','2018-09-09 19:12:21','','1','50 ','BARCLAYS','27098657244','3','1'),(24,'LYNN','KOMEN','JUJA','0797345893','lynnkom@gmail.com','','647903526','1 ','Female','2018-09-09 19:13:26','','1','50 ','BARCLAYS','82790374683','3','1'),(25,'LUCIAS','LABOI','JUJA','078925638','lucias2@gmail.com','','5468793784','1 ','Male','2018-09-09 19:15:39','','1','50 ','BARCLAYS','73892946739','3','1'),(26,'MACHUKA','FAITH','JUJA','792176240','machukanyaboke@gmail.com','','35070556','244 ','Female','2018-09-09 19:19:33','','1','50 ','BARCLAYS','34572898848','3','1'),(27,'Anthony','Mutua','machakos','0203503002','miuy@gmaill.com','','25836998','1 ','Male','2018-09-10 15:18:32','','9','16 ','','','3','1'),(28,'february','february','thika','254726290520','F@yahoo.com','','11111111','1 ','Male','2018-09-11 13:32:55','2018-09-11 13:32:55','1','34 ','feb','00000000','3','1'),(29,'EVANS','MUNYWOKI','Nairobi','254714513818','mr.munywokievans@gmail.com','NEW','32295069','1 ','Male','2018-10-23 15:30:48','','1','50 ','munywoki','123456','3','1'); /*!40000 ALTER TABLE `landlord` 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','0','user/viedeals','side'),('Display Counter',6,'rss-square','displaycounter','0','display','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','1','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),('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','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 `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(40) 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=486 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'),(244,'KE','Kenya',''),(245,'CA','Canada',''),(246,'AF','Afghanistan',''),(247,'AL','Albania',''),(248,'DZ','Algeria',''),(249,'DS','American Samoa',''),(250,'AD','Andorra',''),(251,'AO','Angola',''),(252,'AI','Anguilla',''),(253,'AQ','Antarctica',''),(254,'AG','Antigua and/or Barbuda',''),(255,'AR','Argentina',''),(256,'AM','Armenia',''),(257,'AW','Aruba',''),(258,'AU','Australia',''),(259,'AT','Austria',''),(260,'AZ','Azerbaijan',''),(261,'BS','Bahamas',''),(262,'BH','Bahrain',''),(263,'BD','Bangladesh',''),(264,'BB','Barbados',''),(265,'BY','Belarus',''),(266,'BE','Belgium',''),(267,'BZ','Belize',''),(268,'BJ','Benin',''),(269,'BM','Bermuda',''),(270,'BT','Bhutan',''),(271,'BO','Bolivia',''),(272,'BA','Bosnia and Herzegovina',''),(273,'BW','Botswana',''),(274,'BV','Bouvet Island',''),(275,'BR','Brazil',''),(276,'IO','British lndian Ocean Territory',''),(277,'BN','Brunei Darussalam',''),(278,'BG','Bulgaria',''),(279,'BF','Burkina Faso',''),(280,'BI','Burundi',''),(281,'KH','Cambodia',''),(282,'CM','Cameroon',''),(283,'CV','Cape Verde',''),(284,'KY','Cayman Islands',''),(285,'CF','Central African Republic',''),(286,'TD','Chad',''),(287,'CL','Chile',''),(288,'CN','China',''),(289,'CX','Christmas Island',''),(290,'CC','Cocos (Keeling) Islands',''),(291,'CO','Colombia',''),(292,'KM','Comoros',''),(293,'CG','Congo',''),(294,'CK','Cook Islands',''),(295,'CR','Costa Rica',''),(296,'HR','Croatia (Hrvatska)',''),(297,'CU','Cuba',''),(298,'CY','Cyprus',''),(299,'CZ','Czech Republic',''),(300,'DK','Denmark',''),(301,'DJ','Djibouti',''),(302,'DM','Dominica',''),(303,'DO','Dominican Republic',''),(304,'TP','East Timor',''),(305,'EC','Ecuador',''),(306,'EG','Egypt',''),(307,'SV','El Salvador',''),(308,'GQ','Equatorial Guinea',''),(309,'ER','Eritrea',''),(310,'EE','Estonia',''),(311,'ET','Ethiopia',''),(312,'FK','Falkland Islands (Malvinas)',''),(313,'FO','Faroe Islands',''),(314,'FJ','Fiji',''),(315,'FI','Finland',''),(316,'FR','France',''),(317,'FX','France, Metropolitan',''),(318,'GF','French Guiana',''),(319,'PF','French Polynesia',''),(320,'TF','French Southern Territories',''),(321,'GA','Gabon',''),(322,'GM','Gambia',''),(323,'GE','Georgia',''),(324,'DE','Germany',''),(325,'GH','Ghana',''),(326,'GI','Gibraltar',''),(327,'GR','Greece',''),(328,'GL','Greenland',''),(329,'GD','Grenada',''),(330,'GP','Guadeloupe',''),(331,'GU','Guam',''),(332,'GT','Guatemala',''),(333,'GN','Guinea',''),(334,'GW','Guinea-Bissau',''),(335,'GY','Guyana',''),(336,'HT','Haiti',''),(337,'HM','Heard and Mc Donald Islands',''),(338,'HN','Honduras',''),(339,'HK','Hong Kong',''),(340,'HU','Hungary',''),(341,'IS','Iceland',''),(342,'IN','India',''),(343,'ID','Indonesia',''),(344,'IR','Iran (Islamic Republic of)',''),(345,'IQ','Iraq',''),(346,'IE','Ireland',''),(347,'IL','Israel',''),(348,'IT','Italy',''),(349,'CI','Ivory Coast',''),(350,'JM','Jamaica',''),(351,'JP','Japan',''),(352,'JO','Jordan',''),(353,'KZ','Kazakhstan',''),(354,'US','United States ',''),(355,'KI','Kiribati',''),(356,'KP','Korea, Democratic People\'s Republic of',''),(357,'KR','Korea, Republic of',''),(358,'XK','Kosovo',''),(359,'KW','Kuwait',''),(360,'KG','Kyrgyzstan',''),(361,'LA','Lao People\'s Democratic Republic',''),(362,'LV','Latvia',''),(363,'LB','Lebanon',''),(364,'LS','Lesotho',''),(365,'LR','Liberia',''),(366,'LY','Libyan Arab Jamahiriya',''),(367,'LI','Liechtenstein',''),(368,'LT','Lithuania',''),(369,'LU','Luxembourg',''),(370,'MO','Macau',''),(371,'MK','Macedonia',''),(372,'MG','Madagascar',''),(373,'MW','Malawi',''),(374,'MY','Malaysia',''),(375,'MV','Maldives',''),(376,'ML','Mali',''),(377,'MT','Malta',''),(378,'MH','Marshall Islands',''),(379,'MQ','Martinique',''),(380,'MR','Mauritania',''),(381,'MU','Mauritius',''),(382,'TY','Mayotte',''),(383,'MX','Mexico',''),(384,'FM','Micronesia, Federated States of',''),(385,'MD','Moldova, Republic of',''),(386,'MC','Monaco',''),(387,'MN','Mongolia',''),(388,'ME','Montenegro',''),(389,'MS','Montserrat',''),(390,'MA','Morocco',''),(391,'MZ','Mozambique',''),(392,'MM','Myanmar',''),(393,'NA','Namibia',''),(394,'NR','Nauru',''),(395,'NP','Nepal',''),(396,'NL','Netherlands',''),(397,'AN','Netherlands Antilles',''),(398,'NC','New Caledonia',''),(399,'NZ','New Zealand',''),(400,'NI','Nicaragua',''),(401,'NE','Niger',''),(402,'NG','Nigeria',''),(403,'NU','Niue',''),(404,'NF','Norfork Island',''),(405,'MP','Northern Mariana Islands',''),(406,'NO','Norway',''),(407,'OM','Oman',''),(408,'PK','Pakistan',''),(409,'PW','Palau',''),(410,'PA','Panama',''),(411,'PG','Papua New Guinea',''),(412,'PY','Paraguay',''),(413,'PE','Peru',''),(414,'PH','Philippines',''),(415,'PN','Pitcairn',''),(416,'PL','Poland',''),(417,'PT','Portugal',''),(418,'PR','Puerto Rico',''),(419,'QA','Qatar',''),(420,'RE','Reunion',''),(421,'RO','Romania',''),(422,'RU','Russian Federation',''),(423,'RW','Rwanda',''),(424,'KN','Saint Kitts and Nevis',''),(425,'LC','Saint Lucia',''),(426,'VC','Saint Vincent and the Grenadines',''),(427,'WS','Samoa',''),(428,'SM','San Marino',''),(429,'ST','Sao Tome and Principe',''),(430,'SA','Saudi Arabia',''),(431,'SN','Senegal',''),(432,'RS','Serbia',''),(433,'SC','Seychelles',''),(434,'SL','Sierra Leone',''),(435,'SG','Singapore',''),(436,'SK','Slovakia',''),(437,'SI','Slovenia',''),(438,'SB','Solomon Islands',''),(439,'SO','Somalia',''),(440,'ZA','South Africa',''),(441,'GS','South Georgia South Sandwich Islands',''),(442,'ES','Spain',''),(443,'LK','Sri Lanka',''),(444,'SH','St. Helena',''),(445,'PM','St. Pierre and Miquelon',''),(446,'SD','Sudan',''),(447,'SR','Suriname',''),(448,'SJ','Svalbarn and Jan Mayen Islands',''),(449,'SZ','Swaziland',''),(450,'SE','Sweden',''),(451,'CH','Switzerland',''),(452,'SY','Syrian Arab Republic',''),(453,'TW','Taiwan',''),(454,'TJ','Tajikistan',''),(455,'TZ','Tanzania, United Republic of',''),(456,'TH','Thailand',''),(457,'TG','Togo',''),(458,'TK','Tokelau',''),(459,'TO','Tonga',''),(460,'TT','Trinidad and Tobago',''),(461,'TN','Tunisia',''),(462,'TR','Turkey',''),(463,'TM','Turkmenistan',''),(464,'TC','Turks and Caicos Islands',''),(465,'TV','Tuvalu',''),(466,'UG','Uganda',''),(467,'UA','Ukraine',''),(468,'AE','United Arab Emirates',''),(469,'GB','United Kingdom',''),(470,'UM','United States minor outlying islands',''),(471,'UY','Uruguay',''),(472,'UZ','Uzbekistan',''),(473,'VU','Vanuatu',''),(474,'VA','Vatican City State',''),(475,'VE','Venezuela',''),(476,'VN','Vietnam',''),(477,'VG','Virigan Islands (British)',''),(478,'VI','Virgin Islands (U.S.)',''),(479,'WF','Wallis and Futuna Islands',''),(480,'EH','Western Sahara',''),(481,'YE','Yemen',''),(482,'YU','Yugoslavia',''),(483,'ZR','Zaire',''),(484,'ZM','Zambia',''),(485,'ZW','Zimbabwe',''); /*!40000 ALTER TABLE `nation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment` -- DROP TABLE IF EXISTS `payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `payment` ( `id` int(40) NOT NULL AUTO_INCREMENT, `tenantid` varchar(100) NOT NULL, `plotcode` varchar(100) NOT NULL, `houseno` varchar(100) NOT NULL, `type` varchar(100) NOT NULL, `amount` varchar(100) NOT NULL, `date` varchar(100) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `userid` 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 `payment` -- LOCK TABLES `payment` WRITE; /*!40000 ALTER TABLE `payment` DISABLE KEYS */; /*!40000 ALTER TABLE `payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymentmethod` -- DROP TABLE IF EXISTS `paymentmethod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `paymentmethod` ( `id` int(40) NOT NULL AUTO_INCREMENT, `method` varchar(100) NOT NULL, `description` text NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymentmethod` -- LOCK TABLES `paymentmethod` WRITE; /*!40000 ALTER TABLE `paymentmethod` DISABLE KEYS */; INSERT INTO `paymentmethod` VALUES (1,'Mobile Payament','Mobile Payament','2019-02-11 10:32:59','2019-02-11 10:32:59','3','3'),(2,'Bank Payment','Bank Payment','2016-04-21 06:46:56','2016-04-21 06:46:56','3','3'),(3,'Lipa Rent','Lipa Rent','2016-04-18 20:08:33','2016-04-18 20:08:33','3','3'),(4,'Cash','Cash','2019-02-14 19:37:40','2019-02-14 19:37:40','3','3'),(6,'Coparent','Coparent','2016-05-25 04:21:40','','3','3'),(7,'Lipa na MPESA','','2017-01-30 17:16:34','','3','3'),(8,'unaitas bank','bank payment','2017-12-12 08:22:04','2017-12-12 08:22:04','',''),(9,'unaitas','','2017-12-12 08:19:33','','',''),(10,'credit','credit','2018-09-10 06:22:48','2018-09-10 06:22:48','',''),(11,'credit','credit\r\n','2018-09-06 12:31:44','','',''),(12,'equity','','2018-09-07 10:58:43','','',''),(13,'family bank','','2018-09-07 10:58:58','','',''),(14,'chase bank','bank receipts','2018-09-07 10:59:58','','',''),(15,'barclays bank','bank payments','2018-09-07 11:00:37','','',''),(16,'euros','','2018-09-07 12:48:41','','',''),(17,'credit','half payment','2018-09-08 11:59:13','','',''),(18,'mshwari','mpesa','2018-09-08 12:00:15','','',''),(19,'cheque','bank cheque','2018-09-08 12:01:22','','',''),(20,'34','CASH','2018-09-10 06:21:55','','',''),(21,'CASH','cash payment','2018-09-10 06:22:27','','',''),(22,'credit','','2018-09-11 13:10:45','','',''),(23,'MPESA','','2018-10-23 15:48:10','','',''),(24,'Cash','','2018-11-02 15:17:39','','',''),(25,'Mpesa','','2018-11-02 15:18:33','','',''),(26,'CHEQUE','','2018-12-21 12:22:27','','',''),(27,'78899','','2018-12-21 15:19:27','','',''); /*!40000 ALTER TABLE `paymentmethod` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `paymentsection` -- DROP TABLE IF EXISTS `paymentsection`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `paymentsection` ( `id` int(40) NOT NULL AUTO_INCREMENT, `methodid` varchar(100) NOT NULL, `name` varchar(100) NOT NULL, `description` text NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `paymentsection` -- LOCK TABLES `paymentsection` WRITE; /*!40000 ALTER TABLE `paymentsection` DISABLE KEYS */; INSERT INTO `paymentsection` VALUES (8,'2','KCB Bank','KCB Bank','2016-04-20 10:39:59','','3','3'),(9,'2','Equity Bank','Equity Bank','2016-04-20 10:40:10','','3','3'),(10,'4','cash','CASH','2016-04-20 10:40:34','','3','3'),(11,'3','Lipa rent','','2016-04-20 10:40:48','','3','3'),(12,'1','Airtel Money','Airtel Money','2016-04-20 10:41:17','','3','3'),(13,'1','M-pesa','M-pesa','2016-04-20 10:41:32','','3','3'),(15,'6','Coparent','Coparent','2016-05-25 04:21:55','','3','3'),(16,'2','Unaitas','Unaitas','2017-12-16 06:51:45','','',''); /*!40000 ALTER TABLE `paymentsection` 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(40) 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, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=19 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,'susan wanjiru','','0723665863','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:01:33pm','',''),(2,'ben monini','','254725851233','','','male','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:03:19pm','',''),(3,'gania','','2547266808967','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:21:25pm','',''),(4,'diana wambui','','254725851277','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:22:40pm','',''),(5,'elvis munyangi','','0716466745','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:23:10pm','',''),(6,'marty komora','','9875644309','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:23:46pm','',''),(7,'terry onyango','','0705655434','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:24:16pm','',''),(8,'sam ben','','0775644332','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:37:29pm','',''),(9,'ednah kanji','','0733644309','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:38:00pm','',''),(10,'grace nyanjiru','','0700064434','','','','','','1','',NULL,'member','1','','','','','','5','2018-09-07 03:38:48pm','',''),(11,'name','','','group\r1','','','','','luck muhamend','',NULL,'member','active','','','','','','student\r2','','',''),(12,'mary','','254716343510','m@yahoo.com','07234567','female','juja','7','1 ','',NULL,'member','1','waka stores','','','45687980','','1','2018-09-11 01:18:16pm','',''),(13,'wakik','','254716353410','wikw@gmail.com','073445679','female','','','1','',NULL,'member','1','waka stores','','','','','1','2018-09-10 12:17:31pm','',''),(14,'doss','','25471635387','doss@gmail.com','','','','','1','',NULL,'member','1','quick','','','','','1','2018-09-10 12:19:22pm','',''),(15,'were','','254716353410','','25471984459','female','','','1','',NULL,'member','1','','','','','','1','2018-09-10 12:19:46pm','',''),(16,'JANUARY','','254789675432','m@yahoo.com','254765544332','female','','','1','',NULL,'member','1','','','','','','1','2018-09-11 01:16:04pm','',''),(17,'EVANS','','254714513818','','','male','','','1','',NULL,'member','1','','','','','','1','2018-10-23 04:18:14pm','',''),(18,'alex kim','','0706534643','kimalex980@gmail.com','','male','nrb','4654','1','',NULL,'member','1','robisearch','','','34448729','','29','2018-11-06 12:39:31pm','',''); /*!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),('config',1),('damagedproducts',1),('incomeexpenses',1),('incomingstock',1),('lowproducts',1),('lowstocklist',1),('loyalitycards',1),('members',1),('password',1),('peoplecategory',1),('productlist',1),('products',1),('productscategory',1),('profile',1),('purchases',1),('reports',1),('sales',1),('sendsms',1),('users',1),('viewreturnsales',1),('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=738 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',638),('sales','1','sale',639),('sales','1','select',640),('sales','1','Logout',641),('sales','1','discount',642),('sales','1','productdiscount',643),('sales','1','mpesa',644),('sales','1','updatepaymentmode',645),('sales','1','card',646),('sales','1','voucher',647),('sales','1','credit',648),('wholesale','1','sale',649),('wholesale','1','add',650),('wholesale','1','delete',651),('wholesale','1','update',652),('peoplecategory','1','add',653),('peoplecategory','1','update',654),('peoplecategory','1','delete',655),('branch','1','add',656),('branch','1','view',657),('branch','1','update',658),('branch','1','delete',659),('members','1','add',660),('members','1','update',661),('users','1','add',662),('users','1','update',663),('users','1','delete',664),('users','1','deleteallroles',665),('productscategory','1','add',666),('productscategory','1','update',667),('productscategory','1','delete',668),('productlist','1','bulk',669),('productlist','1','more',670),('productlist','1','transfer',671),('productlist','1','addstock',672),('productlist','1','delete',673),('productlist','1','view',674),('productlist','1','update',675),('productlist','1','add',676),('products','1','add',677),('products','1','update',678),('products','1','delete',679),('products','1','addstock',680),('products','1','more',681),('products','1','bulk',682),('products','1','deleteorder',683),('products','1','removestock',684),('products','1','dispatch',685),('products','1','price',686),('products','1','removeallstock',687),('incomingstock','1','add',688),('incomingstock','1','update',689),('incomingstock','1','delete',690),('lowstocklist','1','add',691),('lowstocklist','1','more',692),('lowstocklist','1','view',693),('lowproducts','1','add',694),('lowproducts','1','update',695),('accounting','1','View Accounting',696),('accounting','1','deletebank',697),('accounting','1','deleteglaccount',698),('damagedproducts','1','add',699),('damagedproducts','1','update',700),('damagedproducts','1','delete',701),('purchases','1','add',702),('purchases','1','update',703),('purchases','1','delete',704),('purchases','1','updatebuyingprice',705),('purchases','1','updatesellingprice',706),('purchases','1','updateclosedinvoice',707),('incomeexpenses','1','add',708),('incomeexpenses','1','update',709),('bankdeposits','1','add',710),('bankdeposits','1','update',711),('bankdeposits','1','delete',712),('loyalitycards','1','add',713),('loyalitycards','1','update',714),('cashiersales','1','all',715),('cashiersales','1','delete',716),('cashiersales','1','cashiersales',717),('reports','1','view',718),('reports','1','download',719),('reports','1','delete',720),('reports','1','update',721),('reports','1','viewall',722),('viewreturnsales','1','add',723),('viewreturnsales','1','update',724),('viewreturnsales','1','delete',725),('viewreturnsales','1','return',726),('viewreturnsales','1','clear',727),('viewreturnsales','1','moresales',728),('sendsms','1','add',729),('sendsms','1','update',730),('sendsms','1','delete',731),('password','1','change',732),('profile','1','update',733),('config','1','delete',734),('config','1','add',735),('config','1','update',736),('config','1','productcode',737); /*!40000 ALTER TABLE `permissionsactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plot` -- DROP TABLE IF EXISTS `plot`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `plot` ( `id` int(40) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `agentid` varchar(100) NOT NULL, `landlordid` varchar(100) NOT NULL, `totalhouse` varchar(100) NOT NULL, `country` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `description` text NOT NULL, `userid` varchar(100) NOT NULL, `accountname` varchar(100) NOT NULL, `accountno` varchar(100) NOT NULL, `commission` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plot` -- LOCK TABLES `plot` WRITE; /*!40000 ALTER TABLE `plot` DISABLE KEYS */; INSERT INTO `plot` VALUES (1,'','VIEWERS PARK HOTEL','NAIVASHA','1 ','1 ','86','1 ','2018-03-13 13:52:56','','','1','VIEWERS PARK LTD','','','3','1'),(2,'','Ghandi','Westwing','1 ','1 ','10','1 ','2018-03-29 13:27:26','','','1','','','','3','1'),(3,'','mercy lodging','JUJA','1 ','2 ','23','1 ','2018-04-06 15:09:30','','','1','Mercy Lodging','234567','5','3','1'),(4,'','juja professsional','juja','1 ','1 ','21','1 ','2018-05-22 14:49:12','','','1','','32424234','','3','1'),(5,'','arcade','abc','1 ','2 ','45','1 ','2018-05-22 16:11:16','','','1','robisearch','777333','5','3','1'),(6,'','menja vision','juja','1 ','2 ','60','1 ','2018-05-22 16:11:24','','','1','bsyer','1234567','5','3','1'),(7,'','kilimanjaro','Nairobi','2 ','4 ','10','1 ','2018-08-29 11:58:24','','','1','KCB','777888999','','3','1'),(8,'','androy','JUJA','2 ','5 ','15','1 ','2018-09-06 12:21:50','','','1','androy','24565476','23','3','1'),(9,'','maryann w','juja','1 ','1 ','67','1 ','2018-09-06 12:47:28','','','1','equity','233334','','3','1'),(10,'','kenya','Nairobi','2 ','5 ','40','1 ','2018-09-07 10:22:14','','','7','','','','3','1'),(11,'','longonot','kiambu','1 ','4 ','10','1 ','2018-09-07 10:22:50','','','7','','','','3','1'),(12,'','mount view','Nanyuki','2 ','3 ','30','1 ','2018-09-07 10:23:59','','','7','','','','3','1'),(13,'','lake view','kisumu','2 ','2 ','20','1 ','2018-09-07 10:24:43','','','7','','','','3','1'),(14,'','kivat','Nairobi','1 ','5 ','23','1 ','2018-09-07 10:25:42','','','7','','','','3','1'),(15,'','vile','nakuru','2 ','4 ','10','1 ','2018-09-07 10:26:29','','','7','','','','3','1'),(16,'','mountain','thika','2 ','3 ','5','1 ','2018-09-07 10:30:51','','','7','','','','3','1'),(17,'','kenyan','Nairobi','1 ','5 ','24','1 ','2018-09-07 10:34:34','','','7','','','','3','1'),(18,'','hill side','vegas','1 ','4 ','14','1 ','2018-09-07 10:35:49','','','7','','','','3','1'),(19,'','devk','mile','2 ','2 ','40','1 ','2018-09-07 10:37:11','','','7','','','','3','1'),(20,'','othaya','naivasha','1 ','5 ','15','1 ','2018-09-07 11:13:37','','','5','','','','3','1'),(21,'','annex','NAKURU','1 ','5 ','12','1 ','2018-09-07 11:26:00','','','5','','','','3','1'),(22,'','acacia','nairobi','2 ','1 ','09','1 ','2018-09-07 11:27:07','','','5','','','','3','1'),(23,'','androy','utawala','2 ','4 ','17','1 ','2018-09-07 11:27:44','','','5','','','','3','1'),(24,'','resty','naivasha','2 ','5 ','6','1 ','2018-09-07 11:28:13','','','5','','','','3','1'),(25,'','mouse','utawala','1 ','3 ','23','1 ','2018-09-07 11:29:42','','','5','','','','3','1'),(26,'','thitar','juja','1 ','2 ','17','1 ','2018-09-07 11:30:30','','','5','','','','3','1'),(27,'','oliopo','meru','2 ','5 ','19','1 ','2018-09-07 11:30:58','','','5','','','','3','1'),(28,'','ratemo','nyeri','1 ','1 ','33','1 ','2018-09-07 11:31:33','','','5','','','','3','1'),(29,'','tilisa','embakasi','2 ','5 ','20','1 ','2018-09-07 11:32:18','','','5','','','','3','1'),(30,'','maryann w','juja','20 ','15 ','98','1 ','2018-09-07 17:07:33','','','1','equity','46578','','3','1'),(31,'','favour','utawala','23 ','19 ','67','1 ','2018-09-08 12:24:06','','','1','equity','4657890','6%','3','1'),(32,'','RECULT PALACE','JUJA','28 ','26 ','10','1 ','2018-09-09 19:43:47','','','1','BARCLAYS','27098657244454','10','3','1'),(33,'','ADONAI HOSTELS','JUJA','27 ','25 ','10','1 ','2018-09-09 19:44:39','','','1','BARCLAYS','7389294673966','5','3','1'),(34,'','SUNVIEW APARTMENTS','JUJA','26 ','24 ','12','1 ','2018-09-09 19:45:27','','','1','BARCLAYS','3457289884877','5','3','1'),(35,'','BELLEVUE APARTMENTS','JUJA','24 ','22 ','10','1 ','2018-09-09 19:47:26','','','1','BARCLAYS','8279037468357','8','3','1'),(36,'','COOL PALACE','JUJA','26 ','20 ','10','1 ','2018-09-09 19:48:49','','','1','BARCLAYS','82790374683','10','3','1'),(37,'','st.luke','JUJA','21 ','19 ','34','1 ','2018-09-10 08:46:36','','','1','equity','3434','4%','3','1'),(38,'','uwezo','utawala','21 ','17 ','68','1 ','2018-09-10 08:53:10','','','1','kcb','3242','8%','3','1'),(39,'','ukwa','ruiru','21 ','17 ','9','1 ','2018-09-10 08:55:07','','','1','equity','555','','3','1'),(40,'','peter mulei','machakos','31 ','27 ','10','1 ','2018-09-10 15:47:00','','','9','','','','3','1'),(41,'','year','thika','32 ','28 ','50','1 ','2018-09-11 13:47:29','','cosy','1','year','00000000','2%','3','1'),(42,'','dennis','Nairobi','32 ','28 ','30','1 ','2018-11-02 15:09:03','','','9','','','','3','1'),(43,'','fravin','juja','28 ','29 ','12','1 ','2018-11-06 10:05:55','','nice place to be','1','plot 10','45677888','10','3','1'),(44,'','fravin','juja','28 ','29 ','12','1 ','2018-11-06 10:05:57','','nice place to be','1','plot 10','45677888','10','3','1'),(45,'','seasons','juja','30 ','29 ','34','1 ','2018-11-06 11:26:13','','sa\\zzzzzzzzzzfvfvfvfvfvfvfvfvfvddygjhndc ','29','kibri','333456','','3','1'),(46,'','fravin','juja','33 ','29 ','54','1 ','2018-11-06 12:43:37','','','29','dffgggg','456757','','3','1'),(47,'','fravin','juja','28 ','29 ','54','1 ','2018-11-06 12:43:50','','','29','dffgggg','456757','','3','1'),(48,'','39','NAIROBI','31 ','29 ','50','1 ','2018-12-21 12:15:36','','','1','PAYING','036788909098','0','3','1'),(49,'','mt kenya','JUJA','34 ','27 ','80','1 ','2018-12-21 15:19:01','','','1','mountkenya','0367543221','','3','1'),(50,'','Juja','Juja','33 ','29 ','10','1 ','2019-02-21 14:09:47','','GOOD','1','JM','2022','6','3','1'); /*!40000 ALTER TABLE `plot` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plot1` -- DROP TABLE IF EXISTS `plot1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `plot1` ( `id` int(40) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `agentid` varchar(100) NOT NULL, `landlordid` varchar(100) NOT NULL, `totalhouse` varchar(100) NOT NULL, `country` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `description` text NOT NULL, `userid` varchar(100) NOT NULL, `accountname` varchar(100) NOT NULL, `accountno` varchar(100) NOT NULL, `commission` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plot1` -- LOCK TABLES `plot1` WRITE; /*!40000 ALTER TABLE `plot1` DISABLE KEYS */; INSERT INTO `plot1` VALUES (1,'','Main House','juja','1 ','1 ','15','1 ','2018-01-12 13:52:28','','','1','Registration Fees','12342434','5%','3','1'); /*!40000 ALTER TABLE `plot1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `plotcharges` -- DROP TABLE IF EXISTS `plotcharges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `plotcharges` ( `id` int(100) NOT NULL AUTO_INCREMENT, `chargeid` varchar(40) NOT NULL, `description` text NOT NULL, `plotno` varchar(100) NOT NULL, `cost` varchar(100) NOT NULL, `status` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `plotcharges` -- LOCK TABLES `plotcharges` WRITE; /*!40000 ALTER TABLE `plotcharges` DISABLE KEYS */; /*!40000 ALTER TABLE `plotcharges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roomcharges` -- DROP TABLE IF EXISTS `roomcharges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roomcharges` ( `id` int(100) NOT NULL AUTO_INCREMENT, `roomid` varchar(40) NOT NULL, `plotno` varchar(100) NOT NULL, `cost` varchar(100) NOT NULL, `status` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `name` varchar(50) NOT NULL, `companyid` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=313 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roomcharges` -- LOCK TABLES `roomcharges` WRITE; /*!40000 ALTER TABLE `roomcharges` DISABLE KEYS */; INSERT INTO `roomcharges` VALUES (1,'1','1','2500','','2018-03-13 02:07:43pm','','1','BB','3'),(2,'5','1','4000','','2018-03-13 02:30:30pm','','1','BB','3'),(3,'5','1','5000','','2018-03-13 02:30:46pm','','1','BB','3'),(4,'5','1','6000','','2018-03-13 02:30:57pm','','1','BB','3'),(5,'1','1','2000','','2018-03-13 03:34:39pm','','1','BB','3'),(6,'1','1','3000','','2018-03-13 03:34:49pm','','1','BB','3'),(7,'2','1','2000','','2018-03-13 03:35:12pm','','1','BB','3'),(8,'2','1','2500','','2018-03-13 03:35:21pm','','1','BB','3'),(9,'2','1','3000','','2018-03-13 03:35:37pm','','1','BB','3'),(10,'3','1','3000','','2018-03-13 03:36:12pm','','1','BB','3'),(11,'3','1','2500','','2018-03-13 03:36:24pm','','1','BB','3'),(12,'3','1','2000','','2018-03-13 03:36:35pm','','1','BB','3'),(14,'4','1','2000','','2018-03-13 03:37:12pm','','1','BB','3'),(15,'4','1','2500','','2018-03-13 03:37:21pm','','1','BB','3'),(16,'4','1','3000','','2018-03-13 03:37:27pm','','1','BB','3'),(17,'6','1','2000','','2018-03-13 03:38:21pm','','1','BB','3'),(18,'6','1','2500','','2018-03-13 03:38:33pm','','1','BB','3'),(19,'6','1','3000','','2018-03-13 03:38:47pm','','1','BB','3'),(20,'7','1','2000','','2018-03-13 03:39:10pm','','1','BB','3'),(21,'7','1','2500','','2018-03-13 03:42:43pm','','1','BB','3'),(22,'7','1','3000','','2018-03-13 03:42:52pm','','1','BB','3'),(23,'8','1','3000','','2018-03-13 03:43:23pm','','1','BB','3'),(24,'8','1','2500','','2018-03-13 03:43:31pm','','1','BB','3'),(25,'8','1','2000','','2018-03-13 03:43:43pm','','1','BB','3'),(26,'9','1','3000','','2018-03-13 03:44:01pm','','1','BB','3'),(27,'9','1','2500','','2018-03-13 03:44:08pm','','1','BB','3'),(28,'9','1','3000','','2018-03-13 03:44:15pm','','1','BB','3'),(29,'10','1','3000','','2018-03-13 03:44:35pm','','1','BB','3'),(30,'10','1','2500','','2018-03-13 03:44:44pm','','1','BB','3'),(31,'10','1','3000','','2018-03-13 03:44:50pm','','1','BB','3'),(32,'13','1','2000','','2018-03-13 03:49:49pm','','1','BB','3'),(33,'13','1','2500','','2018-03-13 03:49:57pm','','1','BB','3'),(35,'13','1','3000','','2018-03-13 03:50:04pm','','1','BB','3'),(36,'14','1','4000','','2018-03-13 03:50:48pm','','1','BB','3'),(37,'14','1','5000','','2018-03-13 03:50:54pm','','1','BB','3'),(38,'14','1','6000','','2018-03-13 03:51:01pm','','1','BB','3'),(39,'15','1','2500','','2018-03-13 03:51:35pm','','1','BB','3'),(40,'15','1','2000','','2018-03-13 03:51:40pm','','1','BB','3'),(41,'15','1','3000','','2018-03-13 03:51:49pm','','1','BB','3'),(42,'16','1','2000','','2018-03-13 03:52:07pm','','1','BB','3'),(43,'16','1','2500','','2018-03-13 03:52:13pm','','1','BB','3'),(44,'16','1','3000','','2018-03-13 03:52:18pm','','1','BB','3'),(45,'17','1','3000','','2018-03-13 03:52:35pm','','1','BB','3'),(46,'17','1','3500','','2018-03-13 03:52:44pm','','1','BB','3'),(47,'17','1','4000','','2018-03-13 03:52:49pm','','1','BB','3'),(48,'18','1','3000','','2018-03-13 03:53:33pm','','1','BB','3'),(49,'18','1','2500','','2018-03-13 03:53:44pm','','1','BB','3'),(50,'18','1','2000','','2018-03-13 03:53:53pm','','1','BB','3'),(51,'19','1','4000','','2018-03-13 04:10:50pm','','1','BB','3'),(52,'19','1','3500','','2018-03-13 04:11:02pm','','1','BB','3'),(53,'19','1','3000','','2018-03-13 04:11:12pm','','1','BB','3'),(54,'20','1','3000','','2018-03-13 04:11:56pm','','1','BB','3'),(55,'20','1','2500','','2018-03-13 04:14:51pm','','1','BB','3'),(56,'20','1','2000','','2018-03-13 04:18:36pm','','1','BB','3'),(57,'21','1','3000','','2018-03-13 04:18:53pm','','1','BB','3'),(58,'21','1','2500','','2018-03-13 04:19:00pm','','1','BB','3'),(59,'21','1','2000','','2018-03-13 04:19:07pm','','1','BB','3'),(60,'22','1','4000','','2018-03-13 04:19:26pm','','1','BB','3'),(61,'22','1','3500','','2018-03-13 04:19:34pm','','1','BB','3'),(62,'22','1','3000','','2018-03-13 04:19:47pm','','1','BB','3'),(63,'23','1','3000','','2018-03-13 04:20:13pm','','1','BB','3'),(64,'23','1','2500','','2018-03-13 04:20:23pm','','1','BB','3'),(65,'23','1','2000','','2018-03-13 04:20:30pm','','1','BB','3'),(66,'24','1','3000','','2018-03-13 04:20:50pm','','1','BB','3'),(67,'24','1','2500','','2018-03-13 04:20:58pm','','1','BB','3'),(68,'24','1','2000','','2018-03-13 04:21:06pm','','1','BB','3'),(69,'25','1','6000','','2018-03-13 04:21:34pm','','1','BB','3'),(70,'25','1','5000','','2018-03-13 04:21:44pm','','1','BB','3'),(72,'25','1','4000','','2018-03-13 04:22:14pm','','1','BB','3'),(73,'26','1','3000','','2018-03-13 04:22:40pm','','1','BB','3'),(74,'26','1','2500','','2018-03-13 04:22:50pm','','1','BB','3'),(75,'26','1','2000','','2018-03-13 04:22:58pm','','1','BB','3'),(76,'27','1','3000','','2018-03-13 04:23:20pm','','1','BB','3'),(77,'27','1','2500','','2018-03-13 04:25:36pm','','1','BB','3'),(78,'27','1','2000','','2018-03-13 04:25:44pm','','1','BB','3'),(79,'29','1','4000','','2018-03-13 04:26:30pm','','1','BB','3'),(80,'29','1','3500','','2018-03-13 04:26:38pm','','1','BB','3'),(81,'29','1','3000','','2018-03-13 04:26:48pm','','1','BB','3'),(82,'30','1','4000','','2018-03-13 04:27:21pm','','1','BB','3'),(83,'30','1','3500','','2018-03-13 04:27:36pm','','1','BB','3'),(84,'30','1','3000','','2018-03-13 04:27:52pm','','1','BB','3'),(85,'31','1','4000','','2018-03-13 04:28:53pm','','1','BB','3'),(86,'31','1','3500','','2018-03-13 04:29:01pm','','1','BB','3'),(87,'31','1','3000','','2018-03-13 04:29:10pm','','1','BB','3'),(88,'32','1','3000','','2018-03-13 04:29:32pm','','1','BB','3'),(89,'32','1','2500','','2018-03-13 04:29:39pm','','1','BB','3'),(90,'32','1','2000','','2018-03-13 04:29:45pm','','1','BB','3'),(91,'33','1','3000','','2018-03-13 04:36:39pm','','1','BB','3'),(93,'33','1','2500','','2018-03-13 04:37:27pm','','1','BB','3'),(94,'33','1','2000','','2018-03-13 04:37:37pm','','1','BB','3'),(95,'34','1','6000','','2018-03-13 04:37:57pm','','1','BB','3'),(96,'34','1','5000','','2018-03-13 04:38:05pm','','1','BB','3'),(97,'34','1','4000','','2018-03-13 04:38:24pm','','1','BB','3'),(98,'35','1','3000','','2018-03-13 04:41:35pm','','1','BB','3'),(99,'35','1','2500','','2018-03-13 04:41:52pm','','1','BB','3'),(100,'35','1','2500','','2018-03-13 04:41:52pm','','1','BB','3'),(101,'36','1','3000','','2018-03-13 04:43:13pm','','1','BB','3'),(102,'36','1','2500','','2018-03-13 04:43:22pm','','1','BB','3'),(103,'36','1','2000','','2018-03-13 04:43:34pm','','1','BB','3'),(104,'37','1','3000','','2018-03-13 04:43:50pm','','1','BB','3'),(105,'37','1','2500','','2018-03-13 04:44:55pm','','1','BB','3'),(106,'37','1','2000','','2018-03-13 04:45:03pm','','1','BB','3'),(107,'38','1','3000','','2018-03-13 04:45:19pm','','1','BB','3'),(108,'38','1','2500','','2018-03-13 04:45:37pm','','1','BB','3'),(109,'38','1','2000','','2018-03-13 04:45:46pm','','1','BB','3'),(110,'39','1','3000','','2018-03-13 04:46:01pm','','1','BB','3'),(111,'39','1','2500','','2018-03-13 04:46:19pm','','1','BB','3'),(112,'39','1','2000','','2018-03-13 04:46:26pm','','1','BB','3'),(113,'40','1','3000','','2018-03-13 04:51:23pm','','1','BB','3'),(114,'40','1','2500','','2018-03-13 04:59:11pm','','1','BB','3'),(115,'40','1','2000','','2018-03-13 04:59:18pm','','1','BB','3'),(116,'41','1','3000','','2018-03-13 05:00:03pm','','1','BB','3'),(118,'41','1','2500','','2018-03-13 05:00:30pm','','1','BB','3'),(119,'41','1','2000','','2018-03-13 05:00:37pm','','1','BB','3'),(120,'42','1','4000','','2018-03-13 05:15:08pm','','1','BB','3'),(121,'42','1','3500','','2018-03-13 05:15:17pm','','1','BB','3'),(122,'42','1','3000','','2018-03-13 05:15:23pm','','1','BB','3'),(123,'43','1','3000','','2018-03-13 05:15:50pm','','1','BB','3'),(125,'43','1','2500','','2018-03-13 05:16:07pm','','1','BB','3'),(126,'43','1','2000','','2018-03-13 05:16:52pm','','1','BB','3'),(129,'44','1','3000','','2018-03-13 05:18:51pm','','1','BB','3'),(130,'44','1','2500','','2018-03-13 05:19:14pm','','1','BB','3'),(131,'44','1','2000','','2018-03-13 05:19:21pm','','1','BB','3'),(132,'45','1','6000','','2018-03-13 05:19:39pm','','1','BB','3'),(133,'45','1','5000','','2018-03-13 05:19:45pm','','1','BB','3'),(134,'45','1','4000','','2018-03-13 05:19:52pm','','1','BB','3'),(135,'46','1','3000','','2018-03-13 05:20:43pm','','1','BB','3'),(136,'46','1','2500','','2018-03-13 05:21:13pm','','1','BB','3'),(137,'46','1','2000','','2018-03-13 05:22:13pm','','1','BB','3'),(138,'47','1','3000','','2018-03-13 05:22:46pm','','1','BB','3'),(139,'47','1','2500','','2018-03-13 05:24:03pm','','1','BB','3'),(140,'47','1','2000','','2018-03-13 05:34:49pm','','1','BB','3'),(141,'48','1','3000','','2018-03-13 05:35:37pm','','1','BB','3'),(142,'48','1','2500','','2018-03-13 05:35:43pm','','1','BB','3'),(143,'48','1','2000','','2018-03-13 05:35:50pm','','1','BB','3'),(144,'49','1','3000','','2018-03-13 05:36:14pm','','1','BB','3'),(145,'49','1','2500','','2018-03-13 05:36:23pm','','1','BB','3'),(146,'49','1','2000','','2018-03-13 05:36:31pm','','1','BB','3'),(147,'50','1','3000','','2018-03-13 05:36:48pm','','1','BB','3'),(148,'50','1','2500','','2018-03-13 05:36:55pm','','1','BB','3'),(149,'50','1','2000','','2018-03-13 05:37:02pm','','1','BB','3'),(150,'51','1','4000','','2018-03-13 05:37:19pm','','1','BB','3'),(151,'51','1','3500','','2018-03-13 05:37:27pm','','1','BB','3'),(152,'51','1','3000','','2018-03-13 05:37:34pm','','1','BB','3'),(153,'52','1','2000','','2018-03-13 05:52:38pm','','1','BB','3'),(154,'52','1','2500','','2018-03-13 05:52:48pm','','1','BB','3'),(155,'52','1','3000','','2018-03-13 05:53:00pm','','1','BB','3'),(156,'53','1','2000','','2018-03-13 05:53:18pm','','1','BB','3'),(157,'53','1','2500','','2018-03-13 05:53:29pm','','1','BB','3'),(158,'53','1','3000','','2018-03-13 05:53:38pm','','1','BB','3'),(159,'54','1','2500','','2018-03-13 05:53:58pm','','1','BB','3'),(160,'54','1','2000','','2018-03-13 05:54:08pm','','1','BB','3'),(161,'54','1','3000','','2018-03-13 05:54:15pm','','1','BB','3'),(162,'55','1','3000','','2018-03-13 05:54:38pm','','1','BB','3'),(163,'55','1','3500','','2018-03-13 05:54:44pm','','1','BB','3'),(164,'55','1','4000','','2018-03-13 05:54:52pm','','1','BB','3'),(165,'56','1','2000','','2018-03-13 05:55:37pm','','1','BB','3'),(166,'56','1','2500','','2018-03-13 05:55:44pm','','1','BB','3'),(167,'56','1','3000','','2018-03-13 05:55:50pm','','1','BB','3'),(168,'57','1','2000','','2018-03-13 05:56:08pm','','1','BB','3'),(169,'57','1','2500','','2018-03-13 05:56:14pm','','1','BB','3'),(170,'57','1','3000','','2018-03-13 05:56:26pm','','1','BB','3'),(171,'58','1','2500','','2018-03-13 05:56:42pm','','1','BB','3'),(172,'58','1','2000','','2018-03-13 05:56:49pm','','1','BB','3'),(173,'58','1','3000','','2018-03-13 05:57:03pm','','1','BB','3'),(174,'59','1','2500','','2018-03-13 05:57:31pm','','1','BB','3'),(175,'59','1','2000','','2018-03-13 05:57:38pm','','1','BB','3'),(176,'59','1','3000','','2018-03-13 05:57:48pm','','1','BB','3'),(177,'60','1','2000','','2018-03-13 05:58:04pm','','1','BB','3'),(178,'60','1','2500','','2018-03-13 05:58:11pm','','1','BB','3'),(179,'60','1','3000','','2018-03-13 05:58:17pm','','1','BB','3'),(180,'61','1','2000','','2018-03-13 05:58:33pm','','1','BB','3'),(181,'61','1','2500','','2018-03-13 05:58:41pm','','1','BB','3'),(182,'61','1','3000','','2018-03-13 05:58:49pm','','1','BB','3'),(183,'62','1','2500','','2018-03-13 05:59:14pm','','1','BB','3'),(184,'62','1','2000','','2018-03-13 05:59:34pm','','1','BB','3'),(185,'62','1','3000','','2018-03-13 05:59:41pm','','1','BB','3'),(186,'63','1','2000','','2018-03-13 05:59:55pm','','1','BB','3'),(187,'63','1','2500','','2018-03-13 06:00:02pm','','1','BB','3'),(188,'63','1','3000','','2018-03-13 06:00:08pm','','1','BB','3'),(189,'64','1','2000','','2018-03-13 06:01:27pm','','1','BB','3'),(190,'64','1','2500','','2018-03-13 06:01:34pm','','1','BB','3'),(191,'64','1','3000','','2018-03-13 06:01:44pm','','1','BB','3'),(192,'65','1','2000','','2018-03-13 06:01:59pm','','1','BB','3'),(193,'65','1','2500','','2018-03-13 06:02:07pm','','1','BB','3'),(194,'65','1','3000','','2018-03-13 06:02:14pm','','1','BB','3'),(195,'66','1','4000','','2018-03-13 06:02:51pm','','1','BB','3'),(196,'66','1','5000','','2018-03-13 06:03:00pm','','1','BB','3'),(197,'66','1','6000','','2018-03-13 06:03:11pm','','1','BB','3'),(198,'67','1','2500','','2018-03-13 06:03:32pm','','1','BB','3'),(199,'67','1','2000','','2018-03-13 06:03:39pm','','1','BB','3'),(200,'67','1','3000','','2018-03-13 06:03:51pm','','1','BB','3'),(201,'68','1','2500','','2018-03-13 06:04:13pm','','1','BB','3'),(202,'68','1','2000','','2018-03-13 06:04:19pm','','1','BB','3'),(203,'68','1','3000','','2018-03-13 06:04:25pm','','1','BB','3'),(204,'69','1','2500','','2018-03-13 06:05:00pm','','1','BB','3'),(205,'69','1','2000','','2018-03-13 06:05:07pm','','1','BB','3'),(206,'69','1','3000','','2018-03-13 06:05:13pm','','1','BB','3'),(207,'70','1','2500','','2018-03-13 06:05:36pm','','1','BB','3'),(208,'70','1','2000','','2018-03-13 06:05:42pm','','1','BB','3'),(209,'70','1','3000','','2018-03-13 06:05:48pm','','1','BB','3'),(210,'71','1','2500','','2018-03-13 06:06:32pm','','1','BB','3'),(211,'71','1','2000','','2018-03-13 06:06:38pm','','1','BB','3'),(212,'71','1','3000','','2018-03-13 06:06:44pm','','1','BB','3'),(213,'72','1','2500','','2018-03-13 06:07:04pm','','1','BB','3'),(214,'72','1','2000','','2018-03-13 06:07:11pm','','1','BB','3'),(215,'72','1','3000','','2018-03-13 06:07:16pm','','1','BB','3'),(216,'73','1','2500','','2018-03-13 06:07:29pm','','1','BB','3'),(217,'73','1','2000','','2018-03-13 06:07:35pm','','1','BB','3'),(218,'73','1','3000','','2018-03-13 06:07:45pm','','1','BB','3'),(219,'74','1','2500','','2018-03-13 06:08:06pm','','1','BB','3'),(220,'74','1','2000','','2018-03-13 06:08:12pm','','1','BB','3'),(221,'74','1','3000','','2018-03-13 06:08:20pm','','1','BB','3'),(222,'75','1','2500','','2018-03-13 06:08:37pm','','1','BB','3'),(223,'75','1','2000','','2018-03-13 06:08:43pm','','1','BB','3'),(224,'75','1','3000','','2018-03-13 06:08:50pm','','1','BB','3'),(225,'76','1','3000','','2018-03-13 06:20:14pm','','1','BB','3'),(226,'76','1','2500','','2018-03-13 06:20:23pm','','1','BB','3'),(227,'76','1','2000','','2018-03-13 06:20:32pm','','1','BB','3'),(228,'77','1','3000','','2018-03-13 06:21:11pm','','1','BB','3'),(229,'77','1','2500','','2018-03-13 06:21:17pm','','1','BB','3'),(230,'77','1','2000','','2018-03-13 06:21:36pm','','1','BB','3'),(231,'78','1','3000','','2018-03-13 06:23:11pm','','1','BB','3'),(232,'78','1','2500','','2018-03-13 06:23:25pm','','1','BB','3'),(233,'78','1','2000','','2018-03-13 06:23:32pm','','1','BB','3'),(234,'79','1','3000','','2018-03-13 06:23:51pm','','1','BB','3'),(235,'79','1','2500','','2018-03-13 06:23:58pm','','1','BB','3'),(236,'79','1','2000','','2018-03-13 06:24:11pm','','1','BB','3'),(237,'80','1','3000','','2018-03-13 06:24:31pm','','1','BB','3'),(238,'80','1','2500','','2018-03-13 06:24:37pm','','1','BB','3'),(239,'80','1','2000','','2018-03-13 06:24:46pm','','1','BB','3'),(240,'81','1','3000','','2018-03-13 06:25:08pm','','1','BB','3'),(241,'81','1','2500','','2018-03-13 06:25:20pm','','1','BB','3'),(242,'81','1','2000','','2018-03-13 06:25:27pm','','1','BB','3'),(243,'82','1','3000','','2018-03-13 06:25:59pm','','1','BB','3'),(244,'82','1','2500','','2018-03-13 06:26:07pm','','1','BB','3'),(245,'82','1','2000','','2018-03-13 06:26:18pm','','1','BB','3'),(246,'83','1','3000','','2018-03-13 06:26:52pm','','1','BB','3'),(247,'83','1','2500','','2018-03-13 06:27:01pm','','1','BB','3'),(248,'83','1','2000','','2018-03-13 06:27:07pm','','1','B','3'),(249,'84','1','3000','','2018-03-13 06:27:37pm','','1','BB','3'),(250,'84','1','2500','','2018-03-13 06:27:48pm','','1','BB','3'),(251,'84','1','2000','','2018-03-13 06:27:56pm','','1','BB','3'),(254,'85','1','3000','','2018-03-13 06:29:13pm','','1','BB','3'),(255,'85','1','2500','','2018-03-13 06:29:21pm','','1','BB','3'),(256,'85','1','2000','','2018-03-13 06:29:28pm','','1','BB','3'),(257,'86','1','3000','','2018-03-13 06:30:32pm','','1','BB','3'),(258,'86','1','2500','','2018-03-13 06:30:47pm','','1','BB','3'),(259,'86','1','3500','','2018-03-13 06:31:01pm','','1','BB','3'),(260,'87','1','3000','','2018-03-13 06:31:30pm','','1','BB','3'),(261,'87','1','2500','','2018-03-13 06:31:38pm','','1','BB','3'),(262,'87','1','2000','','2018-03-13 06:31:45pm','','1','BB','3'),(263,'88','1','3000','','2018-03-13 06:32:04pm','','1','BB','3'),(264,'88','1','2500','','2018-03-13 06:32:12pm','','1','BB','3'),(265,'88','1','2000','','2018-03-13 06:32:21pm','','1','BB','3'),(266,'11','1','2500','','2018-03-14 10:22:27am','','6','BB','3'),(267,'11','1','2000','','2018-03-14 10:22:38am','','6','BB','3'),(268,'11','1','3000','','2018-03-14 10:22:46am','','6','BB','3'),(269,'6','1','2500','','2018-05-05 06:20:07pm','','1','bill','3'),(270,'93','5','20000','','2018-05-22 04:17:14pm','','1','BB','3'),(271,'92','6','700','','2018-05-22 04:17:33pm','','1','bed only','3'),(272,'93','5','15000','','2018-05-22 04:17:43pm','','1','bed only','3'),(273,'92','6','1500','','2018-05-22 04:18:02pm','','1','bed and breakfast','3'),(274,'93','5','1500','','2018-08-28 11:09:10am','2018-09-04 12:21:03pm','1','Watet','3'),(275,'94','7','1200','','2018-08-29 12:28:36pm','','1','BB','3'),(276,'94','7','1000','','2018-08-29 12:29:20pm','','1','B only','3'),(277,'103','7','5000','','2018-08-29 01:37:14pm','','1','B only','3'),(278,'103','7','10000','','2018-08-29 01:38:59pm','','1','BB','3'),(279,'11','1','15000','','2018-09-06 12:18:58pm','','1','sammy','3'),(280,'110','32','8000','','2018-09-09 07:53:02pm','','1','CASH','3'),(281,'140','36','5000','','2018-09-09 08:14:52pm','','1','CASH','3'),(282,'141','36','5000','','2018-09-09 08:15:14pm','','1','MPESA','3'),(283,'142','36','6000','','2018-09-09 08:15:37pm','','1','CASH','3'),(284,'143','36','4000','','2018-09-09 08:16:11pm','','1','CASH','3'),(285,'144','36','4300','','2018-09-09 08:16:34pm','','1','CASH','3'),(286,'130','34','3500','','2018-09-09 08:20:06pm','','1','CASH','3'),(287,'131','34','5000','','2018-09-09 08:20:23pm','','1','CASH','3'),(288,'132','34','8000','','2018-09-09 08:20:43pm','','1','CASH','3'),(289,'133','34','4000','','2018-09-09 08:21:09pm','','1','CASH','3'),(290,'134','34','2400','','2018-09-09 08:24:14pm','','1','CASH','3'),(291,'109','32','2500','','2018-09-10 05:47:49am','','1','BB2500','3'),(292,'114','32','3000','','2018-09-10 05:52:49am','','1','BB3000','3'),(293,'120','33','3000','','2018-09-10 06:00:30am','','1','CASH','3'),(294,'135','35','5000','','2018-09-10 07:42:14am','','1','CASH','3'),(295,'136','35','5000','','2018-09-10 07:43:53am','','1','cash','3'),(296,'137','35','5000','','2018-09-10 07:45:27am','','1','CASH','3'),(297,'138','35','8000','','2018-09-10 07:46:11am','','1','CASH','3'),(298,'139','35','10000','','2018-09-10 07:46:30am','','1','CASH','3'),(299,'156','37','4000','','2018-09-10 06:02:12pm','','1','CASH','3'),(300,'145','9','10000','','2018-09-26 03:42:46pm','','26','office work','3'),(301,'109','40','1000','','2018-09-26 04:12:08pm','','26','mirror','3'),(302,'109','40','1000','','2018-09-26 04:12:08pm','','26','mirror','3'),(303,'109','40','1000','','2018-09-26 04:12:08pm','','26','mirror','3'),(304,'147','40','1000','','2018-10-23 12:50:40pm','','26','breakfast','3'),(305,'109','40','3000','','2018-11-02 02:52:25pm','','9','1 person','3'),(306,'109','40','7000','','2018-11-02 02:55:20pm','2018-11-02 04:41:24pm','9','2 people','3'),(307,'114','32','30K','','2018-11-06 09:16:03am','','1','VBHZJH','3'),(308,'159','32','20K','','2018-11-06 09:22:58am','','1','WERE','3'),(309,'114','32','35','','2018-12-21 12:07:41pm','','1','VBHZJH','3'),(310,'91','4','20000','','2019-01-25 02:19:33pm','2019-01-25 02:19:56pm','30','James ','3'),(311,'106','10','20000','','2019-01-31 10:28:24am','','30','Jeymo','3'),(312,'6','1','4000','','2019-02-13 11:17:14am','','1','bb','3'); /*!40000 ALTER TABLE `roomcharges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roomcharges1` -- DROP TABLE IF EXISTS `roomcharges1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `roomcharges1` ( `id` int(100) NOT NULL AUTO_INCREMENT, `roomid` varchar(40) NOT NULL, `plotno` varchar(100) NOT NULL, `cost` varchar(100) NOT NULL, `status` varchar(40) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `name` varchar(50) NOT NULL, `companyid` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roomcharges1` -- LOCK TABLES `roomcharges1` WRITE; /*!40000 ALTER TABLE `roomcharges1` DISABLE KEYS */; INSERT INTO `roomcharges1` VALUES (1,'2','1','2000','','2018-01-13 10:40:33am','2018-01-13 11:16:33am','1','Bed Only','3'),(2,'4','1','200','','2018-01-13 10:47:16am','','1','NOZZLE 1','3'),(3,'2','1','2400','','2018-01-13 11:17:41am','','1','Bed BREAKFAST','3'),(4,'3','1','2000','','2018-01-13 02:20:56pm','','1','Bed BREAKFAST','3'),(5,'3','1','5000','','2018-01-13 02:23:21pm','','1','Bed Only','3'),(6,'6','1','2500','','2018-01-15 06:37:33am','2018-01-15 06:37:42am','1','Bed Only','3'),(7,'5','1','2000','','2018-02-15 03:51:43am','','1','BED ONLY','3'),(8,'7','1','2000','','2018-02-15 03:52:00am','','1','BED ONLY','3'),(9,'8','1','2000','','2018-02-15 03:52:19am','','1','BED BREAKFAST','3'),(10,'9','1','2000','','2018-02-15 03:55:40am','','1','BED ONLY','3'); /*!40000 ALTER TABLE `roomcharges1` 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, `companyid` varchar(100) NOT NULL, `userid` varchar(100) 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','',''),('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 AUTO_INCREMENT, `contact` varchar(60) NOT NULL, `postedtime` varchar(40) NOT NULL, `message` text NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `userid` varchar(50) NOT NULL, `companyid` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 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 */; INSERT INTO `sms` VALUES (1,'254718667391','2018-01-15 04:40:14am','ok','active','1','3'); /*!40000 ALTER TABLE `sms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smscategory` -- DROP TABLE IF EXISTS `smscategory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `smscategory` ( `id` int(40) NOT NULL AUTO_INCREMENT, `category` varchar(60) NOT NULL, `message` text NOT NULL, `createdat` varchar(60) NOT NULL, `updatedat` varchar(60) NOT NULL, `status` varchar(40) NOT NULL DEFAULT 'active', `companyid` varchar(100) NOT NULL, `userid` varchar(100) 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 `smscategory` -- LOCK TABLES `smscategory` WRITE; /*!40000 ALTER TABLE `smscategory` DISABLE KEYS */; INSERT INTO `smscategory` VALUES (1,'succusful','You have successfully paid your rent','','','active','3','3'),(2,'unsecussful','You have not successfully paid your rent','','','active','3','3'); /*!40000 ALTER TABLE `smscategory` 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, 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 (3,'robisearch','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318','ROBISEARCH','','favour hostels\r\n (Managed By Mapk Management Ltd) <BR>\r\n P.O BOX 1115-00100 KALIMONI <BR>\r\n Mobile: 0723940516.<br>\r\n Email: hotel.senate@gmail.com.\r\n </p>\r\n ','254716353410','JUJA','rosemarykamau55@gmail.com','ROBISEARCHPOS-201701','1680 BAR & GRILL<BR> \r\n254746297242 <BR> \r\n1680africa@protonmail.com<BR> \r\nrobisearch@gmail.com www.robisearch.com<BR> \r\nwww.shujaawangu.com KCB CAPITAL HILL <BR> \r\nACC NO, 1171211120 <BR> \r\nPAY BILL NO, 717475<BR> \r\n','mary kamau','r12345','','49318-00100 Nairobi','KSH','VAT','16','16','10','http://www.favourhostels.com/','<b>COMPANY POLICY</b>:<br>\r\nAny advance booking done and NO SHOW, the following will apply:<br>\r\n1. Cancellation with 12 days prior to check-in, No charge will apply.<br>\r\n2. Any Cancellation prior within 6 days to check-in, 50% of room rate will be charged.<br>\r\n3. Any Cancellation prior within 3 days to check-in, 75% of room rate will be charged.<br>\r\n4. Any Cancellation prior within 12 hours to check-in, 100% of room rate will be charged.<br>\r\n<b>NB: We require down payment for any booking/ reservation done.</b>\r\n','','CASH','1 ','','1','2019-04-20 11:40:55am','yes','yes','no','no','2019-01-30','<center>TILL NO:99899</center>','TERMS OF SERVICE<br>\r\n1. Grand total of Ksh.25, 000is payable once (One off payment).<br>\r\n2. The cost per SMS is KSH.1<br>\r\n3. The annual maintenance cost is Ksh.5000<br>\r\n4. Price for Integration with any other ROCKY existing system is negotiable.<br>\r\n5. We will offer you 1000 free SMS to help you kick off with the system.<br>\r\n','no','You were to renew your account by 5/1/2019 and you have not yet paid. Kindly send your money to our paybil no:717475 then system will continue working correctly','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318'); /*!40000 ALTER TABLE `smsconfig` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tenant` -- DROP TABLE IF EXISTS `tenant`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tenant` ( `id` int(40) NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL, `lastname` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `idno` varchar(100) NOT NULL, `description` text NOT NULL, `phone` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `country` varchar(100) NOT NULL, `gender` varchar(10) NOT NULL, `createdat` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `transactionid` varchar(100) NOT NULL, `county` varchar(40) NOT NULL, `img_id` varchar(100) NOT NULL, `companyid` varchar(100) NOT NULL, `status` varchar(10) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idno` (`idno`) ) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tenant` -- LOCK TABLES `tenant` WRITE; /*!40000 ALTER TABLE `tenant` DISABLE KEYS */; INSERT INTO `tenant` VALUES (1,'robert','Mbaru','juja','manager','','254711675345','tpjschool.og@gmail.com','1 ','Male','2018-01-13 02:36:39','','1','rand216trc1515807368','50 ','6728021515807368','3','1'),(2,'ouko','robert','Manyala','21312133','','254718667391','','1 ','Male','2018-01-13 02:54:00','','1','rand7896trc1515808365','50 ','3478701515808365','3','1'),(3,'sdfdsfs','jkjkb','jbj','bjbnjb','','bjbjb','','352 ','Male','2018-01-13 13:16:33','','1','rand4628trc1515845757','30 ','2191181515845757','3','1'),(4,'sdfdsfs','jkjkb','jbj','2342342','','bjbjb','','352 ','Male','2018-01-13 13:18:34','','1','rand2277trc1515845798','30 ','3612531515845798','3','1'),(5,'robert manyala','','','45345345','','254718667391','','1 ','Male','2018-01-15 15:44:08','','1','rand143trc1516027429','50 ','9491571516027429','3','1'),(6,'Kenya','','','30434232','','2547186637391','','1 ','Male','2018-01-25 18:10:44','','1','rand4927trc1516900217','50 ','9098851516900217','3','1'),(7,'Uganda','','','213121333','','2547183637391','','1 ','Male','2018-01-25 18:13:13','','1','rand4926trc1516900362','50 ','5574021516900362','3','1'),(8,'Sylvanus','','','23231','','254718667391','','1 ','Male','2018-01-25 18:19:04','','1','rand9659trc1516900723','50 ','505191516900723','3','1'),(9,'GRACE','','','12345678','','254718667391','','1 ','Female','2018-01-26 07:46:35','','1','rand7886trc1516949141','50 ','4977081516949141','3','1'),(10,'ISHIMWE','','','26476372','','254723991866','','1 ','Male','2018-03-13 15:43:00','','1','rand3006trc1520944958','50 ','8861101520944958','3','1'),(11,'ISHIMWE','','','324234325','','254723991866','','1 ','','2018-03-14 07:26:44','','1','rand6883trc1521001579','50 ','5854671521001579','3','1'),(12,'lizza nyambura','','JUJA','34579087','','07865422444','','1 ','Female','2018-04-06 15:14:01','','1','rand2923trc1523016775','50 ','5919721523016775','3','1'),(13,'henry','','','565656','','07180312314','mwendani.frank@gmail.com','1 ','Male','2018-05-05 18:35:16','','1','rand4427trc1525534447','22 ','3487001525534447','3','1'),(14,'mary','','','56789','','0987654','','1 ','Female','2018-05-22 16:21:20','','1','rand5295trc1526995198','50 ','2810971526995198','3','1'),(15,'james','','','34557766','','0712061962','','1 ','Male','2018-05-22 16:21:23','','1','rand8267trc1526995183','50 ','7223391526995183','3','1'),(16,'Mary','','','11111111','','0700000000','','1 ','Female','2018-06-30 23:27:20','','1','rand4692trc1530390388','40 ','9347901530390388','3','1'),(17,'Harry km','Km','','29905907','','254718641189','','1 ','Male','2018-07-01 19:52:30','2018-07-01 19:52:30','1','','22 ','','3','1'),(18,'JOHN ALLAN','kuria','Nairobi','2225888','','254725851278','','1 ','Male','2018-08-29 14:02:00','2018-08-29 14:02:00','1','','50 ','','3','1'),(19,'robert','','','12345687','','2547851278','','1 ','Female','2018-08-29 13:03:02','','1','rand6068trc1535536937','50 ','6662151535536937','3','1'),(20,'esther','','','','','','','1 ','','2018-08-30 09:07:21','','1','rand2506trc1535609219','50 ','2510101535609219','3','1'),(21,'esther wanjiru','','','777777','','254725851278','','1 ','Female','2018-08-30 09:08:48','','1','rand529trc1535609242','50 ','1061331535609242','3','1'),(22,'winny','','','7664389','','254725851278','winny@gmail.com','1 ','Female','2018-09-04 11:58:39','','1','rand6254trc1536051440','50 ','1797991536051440','3','1'),(23,'stacey','','','36646497','','0715663916','k@b','1 ','Female','2018-09-06 12:02:11','','1','rand500trc1536224495','50 ','5939991536224495','3','1'),(24,'stacey','','','56734598','','0715663916','matheka.sammy@students.jkuat.ac.ke','1 ','Male','2018-09-06 12:17:54','','1','rand2622trc1536225434','50 ','5076491536225434','3','1'),(25,'mary','','','5677','','254716343510','rosemarykama@gmail.com','1 ','Female','2018-09-06 12:24:58','','1','rand4939trc1536225831','50 ','5543781536225831','3','1'),(26,'stanley mutiso','','JUJA','65489874','','0718117773','k@b','1 ','Male','2018-09-06 12:46:00','','1','rand524trc1536227056','42 ','927261536227056','3','1'),(27,'Mercy','','','12534367','','0789123451','mercy@gmail.com','1 ','Female','2018-09-07 09:52:00','','1','rand9778trc1536303008','50 ','3759111536303008','3','1'),(28,'Jane','','','23456781','','','jane@gmail.com','1 ','Female','2018-09-07 09:53:10','','1','rand6976trc1536303121','50 ','813311536303121','3','1'),(29,'keltit','','','98765432','','','','1 ','Female','2018-09-07 09:54:25','','1','rand769trc1536303190','50 ','4474951536303190','3','1'),(30,'Rekit','','','78634521','','','','1 ','Male','2018-09-07 09:55:06','','1','rand5068trc1536303265','50 ','9423631536303265','3','1'),(31,'john','','','78645347','','','','1 ','Male','2018-09-07 10:07:38','','7','rand2605trc1536304026','50 ','2829971536304026','3','1'),(32,'kelvin','','','65789643','','','','1 ','Male','2018-09-07 10:08:13','','7','rand3081trc1536304058','50 ','5587901536304058','3','1'),(33,'yopu','','','3634905','','','','1 ','Male','2018-09-07 10:08:43','','7','rand1158trc1536304094','50 ','1162981536304094','3','1'),(34,'hannah','','','9834323','','','','1 ','Female','2018-09-07 10:09:20','','7','rand5974trc1536304124','50 ','2119701536304124','3','1'),(35,'linah','','','12365876','','','','1 ','Female','2018-09-07 10:14:36','','7','rand2691trc1536304161','50 ','415551536304161','3','1'),(36,'Bill','','','76883446','','','','1 ','Male','2018-09-07 10:15:44','','7','rand4438trc1536304477','50 ','1469621536304477','3','1'),(37,'melvin','','','965834','','','','1 ','Male','2018-09-07 10:16:23','','7','rand8979trc1536304545','50 ','2693121536304545','3','1'),(38,'Grace','','','4683545','','','','1 ','Male','2018-09-07 10:16:52','','7','rand3576trc1536304584','50 ','9723381536304584','3','1'),(39,'jane','','','35654576','','','','1 ','Female','2018-09-07 10:18:11','','7','rand6008trc1536304612','50 ','9338861536304612','3','1'),(40,'susan','','','2443635','','','','1 ','Female','2018-09-07 10:19:19','','7','rand1132trc1536304692','50 ','8784501536304692','3','1'),(41,'moses buru','','JUJA','85296374','','0711111111','mose@gmail.com','1 ','Male','2018-09-07 13:04:06','','9','rand2147trc1536314527','42 ','8421081536314527','3','1'),(42,'volly','','','5789775786','','254754336578','niamil@gmail.com','1 ','Male','2018-09-07 15:50:26','','10','rand9646trc1536324553','50 ','6856511536324553','3','1'),(43,'dorry','','','45368721','','792176240','machukanyaboke@gmail.com','244 ','Female','2018-09-07 17:43:00','','10','rand4547trc1536331342','50 ','9484871536331342','3','1'),(44,'Doris','','','576566688','','792176240','machukanyaboke@gmail.com','244 ','Female','2018-09-07 17:45:06','','10','rand4106trc1536331464','50 ','3751901536331464','3','1'),(45,'mary','','JUJA','567890','','254716343510','rosemarykamau55@gmail.com','1 ','Female','2018-09-08 11:55:25','','1','rand5021trc1536396883','50 ','9105991536396883','3','1'),(46,'wakik','','','456789','','2547163435009','wikw@gmail.com','1 ','Male','2018-09-08 11:56:20','','1','rand2491trc1536396925','50 ','9330291536396925','3','1'),(47,'doss','','','4567o8p9','','2547163899078','doss@gmail.com','1 ','Male','2018-09-08 11:57:05','','1','rand2632trc1536396981','50 ','6943341536396981','3','1'),(48,'VANE','','JUJA','45772837','','0783683928','abcg@gmail.com','1 ','Female','2018-09-09 20:26:43','','1','rand6181trc1536513900','50 ','4962321536513900','3','1'),(49,'EDNA','','','57248782','','07575328','abhc@gmail.com','1 ','Female','2018-09-09 20:27:21','','1','rand3489trc1536514003','50 ','2100751536514003','3','1'),(50,'STEVE','','','574287872','','07753248','abhs@gmail.com','1 ','Male','2018-09-09 20:28:44','','1','rand3498trc1536514041','50 ','5934211536514041','3','1'),(51,'HARRIET','','','35070793','','077943922','','1 ','Female','2018-09-09 21:06:05','','1','rand1151trc1536514124','50 ','6093091536514124','3','1'),(52,'OLIVIA','','','3472920','','079863492','hkfa@gmail.com','1 ','Female','2018-09-09 21:06:45','','1','rand7803trc1536516366','50 ','5699981536516366','3','1'),(53,'HARON','','','793383829','','076798429','nsdmn@gmail.com','1 ','Male','2018-09-09 21:07:33','','1','rand2293trc1536516405','50 ','6849951536516405','3','1'),(54,'stanley mutiso','','','85264799','','0789456122','jane@gmail.com','1 ','Male','2018-09-10 15:59:36','','9','rand8365trc1536584256','16 ','8994941536584255','3','1'),(55,'philip kamau','','','78456932','','0725698','','1 ','Male','2018-09-10 16:00:27','','9','rand2844trc1536584378','50 ','2966251536584378','3','1'),(56,'joshua kiama','','','55555555','','','','1 ','Male','2018-09-10 16:01:06','','9','rand3998trc1536584428','50 ','3179341536584428','3','1'),(57,'purity makena','','','69584712','','','','1 ','Female','2018-09-10 16:02:35','','9','rand8888trc1536584521','50 ','4832491536584521','3','1'),(58,'allan','njogu','machakos','55558888','','0703600611','','1 ','Male','2018-09-10 16:46:53','2018-09-10 16:46:53','9','','50 ','','3','1'),(59,'mary','','JUJA','4567','','254716343510','rosemarykamau55@gmail.com','1 ','Female','2018-09-10 16:30:54','','1','rand2606trc1536586208','50 ','3667751536586208','3','1'),(60,'wakik','','thika','3456','','2547188968998','wikw@gmail.com','1 ','Male','2018-09-10 16:38:47','','1','rand2877trc1536586682','50 ','3682351536586682','3','1'),(61,'maryann','','','465768','','25475768798','maryann@gmail.com','1 ','Female','2018-09-10 16:40:05','','1','rand1274trc1536586727','50 ','8881651536586727','3','1'),(62,'maryann','','','65789','','254716343510','marykamau55@gmail.com','1 ','Female','2018-09-10 16:40:33','','1','rand5069trc1536586807','50 ','7979971536586807','3','1'),(63,'judy','','','467907','','0775644307','fellyania@g','1 ','Female','2018-09-10 18:42:36','','5','rand8834trc1536594110','50 ','955411536594110','3','1'),(64,'MAry','njeri','embu','33454524','','254789675432','mary@yahoo.com','1 ','Male','2018-09-13 11:36:58','2018-09-13 11:36:58','1','','34 ','','3','1'),(65,'milly','','','54515345','','254712315445','evelyne.keji@gmail.com','1 ','Female','2018-09-26 15:15:37','','26','rand2307trc1537964096','50 ','4224031537964096','3','1'),(66,'bee','','','12','','','','1 ','Male','2018-09-26 15:40:38','','26','rand3968trc1537965625','50 ','6840571537965625','3','1'),(67,'misoi','','','11111','','25471231544','','1 ','Male','2018-09-26 16:09:12','','26','rand1070trc1537967280','50 ','239501537967280','3','1'),(68,'olpha','','','123534','','','','1 ','Female','2018-09-26 16:17:14','','26','rand220trc1537967810','50 ','3006541537967810','3','1'),(69,'mwania','','','337865','','254719691504','mwania@gmail.com','1 ','Female','2018-10-03 15:58:12','','1','rand1832trc1538571408','50 ','7582761538571408','3','1'),(70,'EVANS','','Nairobi','32295069','booking','254714513818','mr.munywokievans@gmail.com','1 ','Male','2018-10-23 15:16:04','','1','rand6341trc1540296866','47 ','6582921540296863','3','1'),(71,'Dennis','','Juja','33938869','','0707694083','dennismutai94@gmail.com','1 ','Male','2018-11-02 15:05:43','','9','rand7756trc1541160272','50 ','6985761541160271','3','1'),(72,'alex','','mutito','34448728','plenty of water','254701695634','ad@gmail.com','1 ','Male','2018-11-06 09:43:33','','1','rand3638trc1541486447','15 ','6528291541486447','3','1'),(73,'alex kim','','','2333543','fdhnsxfgv c','4353472','ae@gmail.com','1 ','Male','2018-11-06 14:26:35','','29','rand9114trc1541503490','50 ','672291541503490','3','1'),(74,'nancy','','main house','35779228','attended to','0740789315','','1 ','Female','2019-02-15 09:56:55','','33','rand7859trc1550213524','32 ','3293101550213524','3','1'),(75,'johnson','','near the gate','30567890','cleared','0788665533','','1 ','Male','2019-02-15 10:05:51','','33','rand133trc1550214040','30 ','9512121550214040','3','1'),(76,'jonte','','','203225','','0701935542','jgachie@hotmail.com','1 ','Male','2019-02-15 10:06:47','','32','rand7883trc1550214282','45 ','7998051550214282','3','1'),(77,'LISA','','THIKA','23454326','','254734567890','','1 ','Female','2019-03-01 10:27:19','','1','rand4495trc1551425085','50 ','2554791551425085','3','1'),(78,'BRIAN MAINA','','','33412409','','254714472738','','1 ','Male','2019-05-22 15:28:42','','1','rand4672trc1558528004','50 ','6471881558528004','3','1'); /*!40000 ALTER TABLE `tenant` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `uploadedimages` -- DROP TABLE IF EXISTS `uploadedimages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `uploadedimages` ( `id` int(100) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `img_id` varchar(100) NOT NULL, `user` text NOT NULL, `type` varchar(40) NOT NULL, `companyid` varchar(100) NOT NULL, `userid` 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 `uploadedimages` -- LOCK TABLES `uploadedimages` WRITE; /*!40000 ALTER TABLE `uploadedimages` DISABLE KEYS */; /*!40000 ALTER TABLE `uploadedimages` 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(100) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `idno` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user` -- LOCK TABLES `user` WRITE; /*!40000 ALTER TABLE `user` DISABLE KEYS */; INSERT INTO `user` VALUES (1,'Robisearch','Admin','','user@gmail.com','0780655987','','','2017-01-28','user','','','2322222','2018-09-051536125262.jpg','','','','','2018-05-14 15:11:20','389','3','','1','no','3','admin','1'),(2,'poline','kuria','','kuriapoline@gmail.com','254725851278','Female','','2018-08-29','00000','','','','2018-08-291535540669.png','','','','','','10','1','','1','yes','3','staff','1'),(5,'stacey','njeri','','staceynganga33@gmail.com','0703600611','Female','','2018-09-04','0724742771','','','','','','','','','','10','1','','1','yes','3','staff','1'),(7,'winnie','macharia','','alexieswinnywangui@gmail.com','0715663916','Female','','2018-09-07','0715663916','','','','','','','','','','10','1','','1','yes','3','staff','1'),(9,'lawrence','sammy','','matheka.sammy@students.jkuat.ac.ke','0718117773','Male','','2018-09-07','matsamcom','','','','2018-11-021541166466.jpg','','','','','','10','1','','1','yes','3','admin','1'),(11,'Rosemary','kamau','','rosemarykamau55@gmail.com','254716343510','Female','','2018-09-08','0700398099','','','','','','','','','','10','1','','1','yes','3','tenant','1'),(12,'quick','qick','','qiuck@gmail.com','25416353210','Female','','2018-09-08','user','','','','','','','','','','10','1','','1','yes','3','staff','1'),(13,'mary','kamau','','mary@gmail.com','25477890','Female','','2018-09-08','ree','','','','','','','','','','10','1','','1','yes','3','tenant','1'),(14,'FAITH','MACHUKA','','machukafaith@gmail.com','0789345623','Female','','2018-09-09','12345','','','','','','','','','','10','1','','1','yes','3','staff','1'),(15,'roy','madegwa','','mnb0@gmail.com','0716466746','Male','','2018-09-10','mnbv','','','','','','','','','','10','1','','1','yes','3','agent','1'),(16,'hill','dan','','mnb1@gmail.com','254756680899','Male','','2018-09-10','mnbv','','','','','','','','','','10','1','','1','yes','3','admin','1'),(17,'lillian','njuguna','','mnb2@gmail.com','0716466765','Female','','2018-09-10','mnbv','','','','','','','','','','10','1','','1','yes','3','agent','1'),(18,'mercy','kiruri','','mnb3@gmail.com','0778466789','Female','','2018-09-10','user','','','','','','','','','','10','1','','1','yes','3','agent','1'),(19,'sammy','hinga','','mnb4@gmail.com','0716785789','Male','','2018-09-10','mnbv','','','','','','','','','','10','1','','1','yes','3','admin','1'),(20,'alando','meruka','','mnb5@gmail.com','0709385434','Male','','2018-09-10','user','','','','','','','','','','10','1','','1','yes','3','tenant','1'),(21,'murira','joy','','mnb6@gmail.com','0717856789','Female','','2018-09-10','user','','','','','','','','','','10','1','','1','yes','3','agent','1'),(22,'april','april','','a@yahoo.com','24789898989','Male','','2018-09-11','april','','','','','','','','','','10','1','','1','yes','3','admin','1'),(23,'august','august','','g@yahoo.com','254777777777','Male','','2018-09-11','august','','','','','','','','','','10','1','','1','yes','3','tenant','1'),(24,'december','december','','d@yahoo.com','254766666666','Male','','2018-09-11','december','','','','','','','','','','10','1','','1','yes','3','agent','1'),(25,'january','january','','j@yahoo.com','254755555555','Male','','2018-09-11','january','','','','','','','','','','10','1','','1','yes','3','staff','1'),(26,'evalyne','keji','','evelyne.keji@gmail.com','254724772996','Female','','2018-09-26','12345','','','','','','','','','','10','1','','1','yes','3','staff','1'),(27,'DENNIS','MUTAI','','dennismutai94@gmail.com','0707694083','','','2018-11-02','nairobi123','','','32502302','2018-11-021541167105.jpg','','','','','2018-11-02 17:03:56','10','1','','1','yes','3','admin','1'),(28,'eric','kim','','sd@gmail.com','322532453','Male','','2018-11-06','kim','','','','','','','','','','10','1','','1','yes','3','admin','1'),(29,'alex','kim','','kimalex980@gmail.com','0706534643','Male','','2018-11-06','34448728','','','','','','','','','','10','1','','1','yes','3','admin','1'),(30,'KEVIN','KIPKOECH','','quinqevin@gmail.com','0725750727','Male','','2019-01-25','kypkoech9','','','','2019-01-251548415866.jpg','','','','','','10','1','','1','yes','3','admin','1'),(31,'virginia','Kiketi','','virginiakiketi9@gmail.com','+254718067296','Female','','2019-02-11','mukonyoh','','','','','','','','','','10','1','','1','yes','3','admin','1'),(32,'JOHNSON KARIUKI','MICHENI','','JOHNSONKARIUKI10@GMAIL.COM','0701934497','Male','','2019-02-14','japhet1957','','','','','','','','','','10','1','','1','yes','3','staff','1'),(33,'nancy wanjiru','nganga','','nancywanjiru@gmail.com','0740789315','Female','','2019-02-14','0740789315','','','','','','','','','','10','1','','1','yes','3','staff','1'),(34,'Josephat','Chengasia','','jchengasia2014@gmail.com','254703291007','Male','','2019-06-17','@jaicy92','','','','','','','','','','10','1','','1','yes','3','admin','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:16