...

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.22-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: robisear_homeland
-- ------------------------------------------------------
-- 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(11) NOT NULL AUTO_INCREMENT,
  `pfno` varchar(20) NOT NULL,
  `password` text DEFAULT NULL,
  `surname` varchar(50) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `phone` varchar(50) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `campus` varchar(30) NOT NULL,
  `college` varchar(30) NOT NULL,
  `department` varchar(30) NOT NULL,
  `type` varchar(40) NOT NULL DEFAULT 'admin',
  `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,
  `totalsms` varchar(20) NOT NULL DEFAULT '5',
  `apiaccount_id` varchar(20) NOT NULL DEFAULT '1',
  `companyid` varchar(20) NOT NULL DEFAULT '1',
  `smstype` varchar(20) NOT NULL DEFAULT '1',
  `username` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 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 (1,'admin','admin123','manyala','robert','0718663435',1,'1','2','1','superadmin','admin','admin@gmail.com','','active','680886','2017-09-05 14:40:18','50','1','1','1','admin'),(2,'','homeland2022','Homeland','Homeland','0722563021',0,'','','','admin','','info@homelandlounge.com','','inactive','N/A','2022-11-11 15:58:11','5','1','1','1','Homeland');
/*!40000 ALTER TABLE `admintable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `alerts`
--

DROP TABLE IF EXISTS `alerts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `alerts` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `contact` text 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,
  `duedate` varchar(30) NOT NULL,
  `duetime` varchar(30) NOT NULL,
  `deliverystatus` varchar(10) NOT NULL DEFAULT 'new',
  `name` varchar(30) NOT NULL,
  `type` varchar(30) NOT NULL,
  `groupname` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `alerts`
--

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

--
-- Table structure for table `allmeetings`
--

DROP TABLE IF EXISTS `allmeetings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `allmeetings` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL DEFAULT 'new',
  `comments` text NOT NULL,
  `dateposted` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `code` varchar(10) NOT NULL,
  `ip` 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 `allmeetings`
--

LOCK TABLES `allmeetings` WRITE;
/*!40000 ALTER TABLE `allmeetings` DISABLE KEYS */;
INSERT INTO `allmeetings` VALUES (1,'Anonymous','new','ok','2021-07-28 02:40:26pm','','','','610K03','127.0.0.1');
/*!40000 ALTER TABLE `allmeetings` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `announcement` WRITE;
/*!40000 ALTER TABLE `announcement` DISABLE KEYS */;
INSERT INTO `announcement` VALUES (1,'National Exam','Primary and Secondary','All rules must be athered to','6/11/2016','active','advert'),(2,'Opportunity','all','New jobs available','4/11/2016','active','announcement');
/*!40000 ALTER TABLE `announcement` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `attendance`
--

DROP TABLE IF EXISTS `attendance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendance` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `idno` varchar(100) NOT NULL,
  `surname` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL,
  `timein` varchar(100) NOT NULL,
  `timeout` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `createddate` varchar(100) NOT NULL,
  `comment` text NOT NULL,
  `timediffrence` int(5) NOT NULL DEFAULT 0,
  `device` varchar(30) NOT NULL,
  `totaltime` varchar(50) DEFAULT NULL,
  `checkoutime` varchar(50) DEFAULT 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 `attendance`
--

LOCK TABLES `attendance` WRITE;
/*!40000 ALTER TABLE `attendance` DISABLE KEYS */;
INSERT INTO `attendance` VALUES (1,'66666','','2022-09-06 10:23:19','10:23:19am','','Check in','2022-09-06 10:23:30','66666',1,'',NULL,NULL);
/*!40000 ALTER TABLE `attendance` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `balance`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `balance` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `idno` varchar(100) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `createdate` varchar(100) NOT NULL,
  `userid` int(11) NOT NULL,
  `companyid` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

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

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

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'WAITERS','ok','2022-10-17 12:34:33pm','active','1','','1','08:00','17:00'),(2,'CASHIERS','','2022-10-17 12:34:51pm','active','1','','1','',''),(3,'All staffs','','2022-10-17 12:35:09pm','active','1','','1','08:00','17:00'),(4,'Management','','2022-10-17 12:35:19pm','active','1','','1','',''),(5,'Customers','','2022-10-17 12:35:33pm','inactive','1','','1','04:07','08:08');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

LOCK TABLES `complain` WRITE;
/*!40000 ALTER TABLE `complain` DISABLE KEYS */;
INSERT INTO `complain` VALUES (1,'COMPLAIN','test','2021-11-30 08:18:08','Sent','1','','1','Yes','1',0,'',NULL,'COMPLAIN','6617075381638256688'),(2,'COMPLAIN','dddddddddd','2021-11-30 08:18:21','Sent','1','','1','Yes','1',0,'',NULL,'COMPLAIN','9792416681638256701'),(3,'OTHERS','dd','2021-11-30 08:18:40','Sent','1','','1','Yes','7',0,'',NULL,'COMPLAIN','4123123391638256720'),(4,'INNOVATION','COMPLAIN','2021-11-30 08:19:10','Sent','1','','1','Yes','3',0,'',NULL,'COMPLAIN','8068651261638256750'),(5,'EMERGENCY','TEST','2021-12-02 09:06:38','Sent','1','','1','Yes','5',0,'',NULL,'OK','9354838421638432398'),(6,'REPORTING','ddd','2021-12-02 09:55:09','Sent','1','','1','Yes','6',0,'',NULL,'ddd','1197390891638435309'),(7,'OTHERS','ddd','2021-12-02 09:55:52','Sent','1','','1','Yes','7',0,'',NULL,'PAYE 20201dd','7657315481638435352'),(8,'OTHERS','dd','2021-12-02 09:56:49','Sent','1','','1','Yes','7',0,'',NULL,'PAYE 20201dd','2872027931638435409'),(9,'OTHERS','dd','2021-12-02 09:58:39','Sent','1','','1','Yes','7',0,'',NULL,'PAYE 20201dd','1224548821638435519'),(10,'COMPLAIN','Good service ','2022-10-17 12:44:59','New','1','','1','No','1',0,'',NULL,'',''),(11,'COMPLAINS','Poor customer service','2022-10-19 11:59:47','New','1','','1','No','1',0,'',NULL,'',''),(12,'COMPLAINS','fff','2022-10-19 19:49:32','New','1','','1','No','1',0,'',NULL,'',''),(13,'COMPLAINS','bvshghdafdh','2022-10-19 21:32:30','New','1','','1','Yes','1',0,'',NULL,'vzxcxvhxzc',''),(14,'EMERGENCY','sadjh','2022-10-21 17:22:59','New','1','','1','No','9',0,'',NULL,'',''),(15,'COMPLAINS','Excellent service','2022-10-24 16:07:20','New','1','','1','No','1',0,'',NULL,'',''),(16,'RECOMMENDATIONS','We appreciate your good services. ','2022-10-25 13:46:54','New','1','','1','No','4',0,'',NULL,'',''),(17,'COMPLAINS','The food is taking too long...','2022-10-25 14:17:23','New','1','','1','Yes','1',0,'',NULL,'0718667391 ROBERT',''),(18,'COMPLAINS','Raw meat','2022-10-25 14:18:02','New','1','','1','Yes','1',0,'',NULL,'Jackline ',''),(19,'SUGGESTIONS','Its free good for everyone to be part of this.. the more you give the more you receive ','2022-10-25 14:18:18','New','1','','1','No','2',0,'',NULL,'',''),(20,'TO CALL NEAREST WAITER','Hello','2022-11-04 15:14:59','New','1','','1','Yes','10',0,'',NULL,'Sharha',''),(21,'SUGGESTIONS','Keep up with the good services ','2022-11-11 15:53:07','Sent','1','','1','No','2',0,'',NULL,'','8747051681668171187'),(22,'SUGGESTIONS','Good service ','2022-11-11 16:00:49','Sent','1','','1','No','2',0,'',NULL,'','7158445041668171649'),(23,'SUGGESTIONS','Please include digital menu on this system','2022-11-11 18:39:31','Sent','1','','1','Yes','2',0,'',NULL,'zricome ','5243117381668181171'),(24,'SUGGESTIONS','Admin test','2022-11-11 18:40:49','Sent','1','','1','Yes','2',0,'',NULL,'Azricome ','7437376101668181249'),(25,'SUGGESTIONS','Please update your menus','2022-11-16 10:18:30','Sent','1','','1','Yes','2',0,'',NULL,'kevo','7682595241668583110'),(26,'SUGGESTIONS','Hi','2022-11-16 14:44:11','Sent','1','','1','No','2',0,'',NULL,'','6094260981668599051'),(27,'SUGGESTIONS','Test','2022-11-16 14:54:34','Sent','1','','1','No','2',0,'',NULL,'','4571830081668599674'),(28,'SUGGESTIONS','Good work','2022-11-16 14:59:42','Sent','1','','1','No','2',0,'',NULL,'','6850779491668599982'),(29,'SUGGESTIONS','Hi','2022-11-16 15:00:37','Sent','1','','1','No','2',0,'',NULL,'','7221211451668600037'),(30,'RECOMMENDATIONS','This is a test run','2022-11-16 15:02:10','Sent','1','','1','No','4',0,'',NULL,'','8177343811668600130'),(31,'RECOMMENDATIONS','This is a test run','2022-11-16 15:09:38','Sent','1','','1','No','4',0,'',NULL,'','8774970781668600578'),(32,'RECOMMENDATIONS','This is a test tun','2022-11-16 15:14:37','Sent','1','','1','No','4',0,'',NULL,'','3852145301668600877'),(33,'SUGGESTIONS','Hi','2022-11-16 15:15:04','Sent','1','','1','No','2',0,'',NULL,'','383813141668600904'),(34,'SUGGESTIONS','Test Suggestion','2022-11-16 15:34:34','Sent','1','','1','No','2',0,'',NULL,'','8414543651668602074'),(35,'SUGGESTIONS','Test','2022-11-16 16:52:34','Sent','1','','1','No','2',0,'',NULL,'','325318871668606754'),(36,'SUGGESTIONS','Test','2022-11-16 17:14:36','Sent','1','','1','No','2',0,'',NULL,'','6173893471668608076'),(37,'SUGGESTIONS','Test','2022-11-16 17:16:29','Sent','1','','1','No','2',0,'',NULL,'','7969987301668608189'),(38,'SUGGESTIONS','this is a good idea ','2022-11-16 17:36:05','Sent','1','','1','Yes','2',0,'',NULL,'AZRICOME ','5731435631668609365'),(39,'TO CALL WAITER','Lynn','2022-11-17 11:47:21','Sent','1','','1','Yes','10',0,'',NULL,'azricome ','9044401341668674841'),(40,'TO CALL WAITER','Call mr gerald','2022-11-17 11:47:48','Sent','1','','1','No','10',0,'',NULL,'','2705821451668674868'),(41,'COMPLAINS','Order not ready in 20 minutes','2022-11-17 11:51:17','Sent','1','','1','Yes','1',0,'',NULL,'Mr G','1027164231668675077');
/*!40000 ALTER TABLE `complain` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

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

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

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

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

--
-- Table structure for table `coursecodes`
--

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

--
-- Dumping data for table `coursecodes`
--

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

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `id` int(11) 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',
  `companyid` varchar(100) NOT NULL,
  `service` varchar(100) NOT NULL,
  `usertype` varchar(50) DEFAULT NULL,
  `smstype` int(10) NOT NULL DEFAULT 2,
  `refer` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (1,'Bondeni','Bondeni Primary','','robisearch@gmail.com','','','','2016-12-24','12345678','','','','201807311533002481201606151466003799Handheld-Point-of-Sale.jpg','','','','','2020-04-09','500','1','n/a','1','1','','admin',2,''),(2,'Willis Ochieng','ROBERT','','robiseoarch@gmail.com','254718667391','','','2019-07-02 06:16:33','uuuuuuuu','','','','','','','','','','10','1','','1','1','Yes',NULL,2,'online'),(3,'Willis Ochieng','Ouma6','','journalreagan@gmail.com','2547899275648','','','2019-07-02 06:21:34','zzzzzzzz','','','','','','','MOLLYS','','','10','1','','1','1','Yes',NULL,2,'tv');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device`
--

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

--
-- Dumping data for table `device`
--

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

--
-- Table structure for table `email`
--

DROP TABLE IF EXISTS `email`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email` (
  `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,
  `subject` 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 `email`
--

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

--
-- Table structure for table `email_accounts`
--

DROP TABLE IF EXISTS `email_accounts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `password` varchar(100) NOT NULL,
  `smtp_host` varchar(50) NOT NULL,
  `smtp_port` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `companyid` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `server` int(11) NOT NULL,
  `createdate` varchar(30) 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 `email_accounts`
--

LOCK TABLES `email_accounts` WRITE;
/*!40000 ALTER TABLE `email_accounts` DISABLE KEYS */;
INSERT INTO `email_accounts` VALUES (1,'marketing@mombasacontinental.com','Pass@123','mail.mombasacontinental.com',587,1,1,'ROBISEARCH LTD',0,''),(2,'support@robisearch.com','support!@##@!','ssl://mail.robisearch.com',587,1,1,'ROBISEARCH LTD/TASK MANAGER',3,'2020-10-06 12:25:53pm'),(3,'support@robisearch.com','support!@##@!','ssl://mail.robisearch.com',465,1,1,'support',3,'2020-10-07 05:06:08am');
/*!40000 ALTER TABLE `email_accounts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `email_configuration`
--

DROP TABLE IF EXISTS `email_configuration`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `email_configuration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(15) NOT NULL,
  `smtp_host` varchar(50) NOT NULL,
  `smtp_port` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `email_configuration`
--

LOCK TABLES `email_configuration` WRITE;
/*!40000 ALTER TABLE `email_configuration` DISABLE KEYS */;
INSERT INTO `email_configuration` VALUES (1,'Gmail','ssl://smtp.googlemail.com',465),(2,'Yahoo','ssl://smtp.mail.yahoo.com',465),(3,'Webmail','domain.com',587),(4,'Hotmail','smtp-mail.outlook.com',587);
/*!40000 ALTER TABLE `email_configuration` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `events` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `fromdate` varchar(50) NOT NULL,
  `todate` varchar(50) NOT NULL,
  `host` varchar(100) NOT NULL,
  `participants` text NOT NULL,
  `location` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL DEFAULT 'new',
  `comments` text NOT NULL,
  `repeated` varchar(50) NOT NULL,
  `dateposted` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `sms` varchar(20) 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 `events`
--

LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
INSERT INTO `events` VALUES (1,'MEETING','2019-05-20','2019-05-24','Mr.Robert','ANN,SAMUEL,JOSHUA,JEZEBEL,WKE','JUJA','new','ALL SHOULD ATTEND IN SPECIFIED TIME','','2019-05-18 02:59:10pm','1','','1','Yes');
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `expenses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `expenses` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `amount` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `dateposted` varchar(50) NOT NULL,
  `user` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `datespent` varchar(50) NOT NULL,
  `receiptno` varchar(100) NOT NULL,
  `idno` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `controller` varchar(100) NOT NULL,
  `imgid` varchar(100) NOT NULL,
  `img_id` text NOT NULL,
  `plotno` varchar(50) NOT NULL,
  `houseno` varchar(50) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

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

DROP TABLE IF EXISTS `fingers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fingers` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `regno` varchar(200) NOT NULL,
  `fingername` varchar(50) NOT NULL,
  `regdate` varchar(100) NOT NULL,
  `template` text NOT NULL,
  `type` varchar(10) 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 `fingers`
--

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

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

DROP TABLE IF EXISTS `grouping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `grouping` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `memberid` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `user` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `updatedat` varchar(50) NOT NULL,
  `categoryid` varchar(50) NOT NULL,
  `companyid` varchar(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 `grouping`
--

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

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

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

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

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

--
-- Table structure for table `likes`
--

DROP TABLE IF EXISTS `likes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `likes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` varchar(20) NOT NULL,
  `ip` varchar(50) NOT NULL,
  `dateposted` varchar(10) NOT NULL,
  `code` varchar(10) NOT NULL,
  `postid` int(20) NOT NULL,
  `type` varchar(10) NOT NULL DEFAULT 'liked',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `likes`
--

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

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

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

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

LOCK TABLES `loggs` WRITE;
/*!40000 ALTER TABLE `loggs` DISABLE KEYS */;
INSERT INTO `loggs` VALUES (1,'admin','1','2022-10-17 12:34:01','','','154.159.252.67','loggedin',1),(2,'admin','1','2022-10-17 12:41:55','','','105.161.146.20','loggedin',1),(3,'admin','1','2022-10-17 13:09:30','','','197.232.142.176','loggedin',1),(4,'admin','1','2022-10-17 13:17:48','','','197.232.142.176','loggedin',1),(5,'admin','1','2022-10-25 13:38:19','','','154.77.184.153','loggedin',1),(6,'admin','1','2022-10-25 14:15:01','','','154.77.184.153','loggedin',1),(7,'admin','1','2022-11-08 15:32:34','','','154.159.254.253','loggedin',1),(8,'admin','1','2022-11-11 17:17:27','','','197.232.142.176','loggedin',1),(9,'admin','1','2022-11-16 14:52:07','','','197.232.142.176','loggedin',1),(10,'admin','1','2022-11-16 14:59:51','','','197.232.142.176','loggedin',1),(11,'admin','1','2022-11-16 16:56:34','','','154.153.103.35','loggedin',1),(12,'admin','1','2022-11-16 17:13:32','','','154.153.103.35','loggedin',1),(13,'admin','1','2022-11-16 17:18:04','','','154.153.103.35','loggedin',1),(14,'admin','1','2023-01-30 14:06:32','','','154.78.131.85','loggedin',1);
/*!40000 ALTER TABLE `loggs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `mailing_tbl`
--

DROP TABLE IF EXISTS `mailing_tbl`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mailing_tbl` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(50) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(100) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mailing_tbl`
--

LOCK TABLES `mailing_tbl` WRITE;
/*!40000 ALTER TABLE `mailing_tbl` DISABLE KEYS */;
INSERT INTO `mailing_tbl` VALUES (1,'Reagan Otieno','journalreagan@gmail.com','Password'),(2,'Test Name','otienoreagan52@yahoo.com','Password'),(6,'Continental','marketing@mombasacontinental.com','Pass@123'),(7,'Sales','sales@robisearch.com','sales!@##@!');
/*!40000 ALTER TABLE `mailing_tbl` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `meeting`
--

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

--
-- Dumping data for table `meeting`
--

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

--
-- Table structure for table `mpesa`
--

DROP TABLE IF EXISTS `mpesa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `mpesa` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `amount` varchar(50) DEFAULT NULL,
  `number` varchar(50) DEFAULT NULL,
  `time` varchar(50) DEFAULT NULL,
  `accountname` varchar(50) DEFAULT NULL,
  `output` text DEFAULT NULL,
  `createdats` varchar(50) DEFAULT NULL,
  `xml` text NOT NULL,
  `json` 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 `mpesa`
--

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

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

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

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

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

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

DROP TABLE IF EXISTS `people`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `people` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) DEFAULT NULL,
  `phone` varchar(255) NOT NULL,
  `email` varchar(255) DEFAULT 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,
  `title` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `first_name` (`firstname`),
  KEY `last_name` (`lastname`),
  KEY `email` (`email`),
  KEY `phppos_people_ibfk_1` (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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,'GIDEON SINGALO','66666','254718667391','','','','','','1 ','',NULL,'member','1','','','','66666','','1','2022-09-06 10:21:57am','','1','Professor');
/*!40000 ALTER TABLE `people` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `phones`
--

DROP TABLE IF EXISTS `phones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `phones` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `phone` text NOT NULL,
  `createddate` varchar(30) NOT NULL,
  `addedby` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `phones`
--

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

--
-- Table structure for table `pocket`
--

DROP TABLE IF EXISTS `pocket`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `pocket` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `idno` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `date` varchar(100) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `balance` decimal(10,2) NOT NULL,
  `before` decimal(10,2) NOT NULL,
  `createdate` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `smsstatus` varchar(10) NOT NULL DEFAULT 'new',
  `device` varchar(30) NOT NULL,
  `userid` int(11) NOT NULL,
  `companyid` int(11) NOT NULL,
  `studentname` varchar(100) NOT NULL DEFAULT '',
  `Pay` varchar(20) NOT NULL DEFAULT '',
  `type` varchar(20) NOT NULL DEFAULT 'Deposite',
  `mode` varchar(20) NOT NULL DEFAULT 'Cash',
  `message` 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 `pocket`
--

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

--
-- Table structure for table `postrecharge`
--

DROP TABLE IF EXISTS `postrecharge`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `postrecharge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` decimal(10,2) NOT NULL,
  `userid` int(20) NOT NULL,
  `companyid` int(5) NOT NULL,
  `dateposted` varchar(30) NOT NULL,
  `paymentstatus` varchar(10) NOT NULL,
  `branch` int(10) NOT NULL,
  `type` varchar(30) NOT NULL,
  `description` text NOT NULL,
  `balance` double(10,2) NOT NULL,
  `rate` decimal(10,2) NOT NULL,
  `balancebefore` decimal(10,2) DEFAULT NULL,
  `units` decimal(10,2) NOT NULL,
  `code` varchar(50) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `business` text NOT NULL,
  `status` varchar(20) NOT NULL DEFAULT 'active',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `postrecharge`
--

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

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

DROP TABLE IF EXISTS `productcategory`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `productcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` int(11) NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  `maincategory` varchar(30) NOT NULL,
  `commission` varchar(20) NOT NULL DEFAULT '0',
  `shipping` varchar(20) NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'New',
  `imgid` varchar(50) DEFAULT NULL,
  `myheader` varchar(50) DEFAULT 'primary',
  `icon` varchar(50) NOT NULL DEFAULT 'home',
  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 `productcategory`
--

LOCK TABLES `productcategory` WRITE;
/*!40000 ALTER TABLE `productcategory` DISABLE KEYS */;
INSERT INTO `productcategory` VALUES (1,'COMPLAINS',20,'2022-10-17 13:21:32','active','1','','1','','0','','Percentage',NULL,'red','briefcase'),(2,'SUGGESTIONS',90,'2022-02-05 12:07:11','active','1','','1','','0','','Percentage',NULL,'blue','briefcase'),(4,'RECOMMENDATIONS',0,'2022-10-17 13:10:57','active','1','','1','','0','','Percentage',NULL,'aqua','film'),(9,'EMERGENCY',50,'2022-11-08 15:32:47','inactive','1','','1','','0','','',NULL,'red','home'),(10,'TO CALL WAITER',2,'2022-11-08 16:04:11','active','1','','1','','0','','',NULL,'primary','home');
/*!40000 ALTER TABLE `productcategory` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reasons`
--

DROP TABLE IF EXISTS `reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `reasons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `createdate` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'active',
  `userid` varchar(50) NOT NULL,
  `updatedate` varchar(50) NOT NULL,
  `companyid` varchar(100) NOT NULL,
  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 `reasons`
--

LOCK TABLES `reasons` WRITE;
/*!40000 ALTER TABLE `reasons` DISABLE KEYS */;
INSERT INTO `reasons` VALUES (1,'Outing','your son has left the school','2022-09-06 10:23:02am','Check in','1','','1');
/*!40000 ALTER TABLE `reasons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recharge`
--

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

--
-- Dumping data for table `recharge`
--

LOCK TABLES `recharge` WRITE;
/*!40000 ALTER TABLE `recharge` DISABLE KEYS */;
INSERT INTO `recharge` VALUES (1,2.00,1,1,'2020-10-06 06:59:56am','',0,'','ok',502.00,1.00,500.00,2.00,'123123w','',''),(2,500.00,1,1,'2022-11-11 05:18:13pm','',0,'','HOMELAND',946.00,1.00,446.00,500.00,'HOMELAND','','');
/*!40000 ALTER TABLE `recharge` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reply`
--

DROP TABLE IF EXISTS `reply`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `reply` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `status` varchar(40) NOT NULL DEFAULT 'new',
  `comments` text NOT NULL,
  `dateposted` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `updatedat` varchar(100) NOT NULL,
  `companyid` varchar(50) NOT NULL,
  `code` varchar(10) NOT NULL,
  `postid` varchar(50) NOT NULL,
  `ip` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reply`
--

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

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

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

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

LOCK TABLES `setting` WRITE;
/*!40000 ALTER TABLE `setting` DISABLE KEYS */;
INSERT INTO `setting` VALUES ('additional_payment_types','Cash, Credit, Mpesa,Bank'),('automatically_email_receipt','0'),('averaging_method','moving_average'),('barcode_price_include_tax','0'),('calculate_average_cost_price_from_receivings','0'),('change_sale_date_when_completing_suspended_sale','1'),('change_sale_date_when_suspending','0'),('company','Robisearch Limited'),('company_logo','1'),('currency_symbol','Ksh'),('customers_store_accounts','1'),('date_format','little_endian'),('default_payment_type','0'),('default_tax_1_name','Vat'),('default_tax_1_rate','16'),('default_tax_2_cumulative','0'),('default_tax_2_name','Sales Tax 2'),('default_tax_2_rate','0.15'),('default_tax_3_name',''),('default_tax_3_rate',''),('default_tax_4_name',''),('default_tax_4_rate',''),('default_tax_5_name',''),('default_tax_5_rate',''),('default_tax_rate','8'),('disable_confirmation_sale','0'),('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(30) 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(100) NOT NULL,
  `smscount` int(11) NOT NULL,
  `messageId` int(11) NOT NULL,
  `response` text NOT NULL,
  `cost` int(11) NOT NULL,
  `bulkId` varchar(100) NOT NULL,
  `qty` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 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,'','2021-11-30 10:41:14','Hi! a new COMPLAIN has been posted: test','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(2,'','2021-11-30 10:41:14','Hi! a new COMPLAIN has been posted: dddddddddd','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(3,'','2021-11-30 10:41:14','Hi! a new OTHERS has been posted: dd','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(4,'','2021-11-30 10:41:14','Hi! a new INNOVATION has been posted: COMPLAIN','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(5,'','2021-11-30 10:42:52','Hi you have a new post on COMPLAIN test','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(6,'','2021-11-30 10:42:52','Hi you have a new post on COMPLAIN dddddddddd','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(7,'','2021-11-30 10:42:52','Hi you have a new post on OTHERS dd','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(8,'','2021-11-30 10:42:52','Hi you have a new post on INNOVATION COMPLAIN','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(9,'254718667391','2021-11-30 10:43:39','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'33825822060234994135','Mass'),(10,'254718667391','2021-11-30 10:43:39','Hi you have a new post on COMPLAIN dddddddddd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825822060234994135','Mass'),(11,'254718667391','2021-11-30 10:43:39','Hi you have a new post on OTHERS dd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825822060234994135','Mass'),(12,'254718667391','2021-11-30 10:43:39','Hi you have a new post on INNOVATION COMPLAIN','PENDING','1','1',0,0,'Message sent to next instance',1,'33825822060234994135','Mass'),(13,'254718667391','2021-11-30 10:46:39','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'33825840129401630777','Mass'),(14,'254718667391','2021-11-30 10:46:39','Hi you have a new post on COMPLAIN dddddddddd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825840129401630777','Mass'),(15,'254718667391','2021-11-30 10:46:39','Hi you have a new post on OTHERS dd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825840129401630777','Mass'),(16,'254718667391','2021-11-30 10:46:39','Hi you have a new post on INNOVATION COMPLAIN','PENDING','1','1',0,0,'Message sent to next instance',1,'33825840129401630777','Mass'),(17,'254718667391','2021-11-30 10:48:21','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'33825850215703536878','Mass'),(18,'254718667391','2021-11-30 10:48:21','Hi you have a new post on COMPLAIN dddddddddd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825850215703536878','Mass'),(19,'254718667391','2021-11-30 10:48:21','Hi you have a new post on OTHERS dd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825850215703536878','Mass'),(20,'254718667391','2021-11-30 10:48:21','Hi you have a new post on INNOVATION COMPLAIN','PENDING','1','1',0,0,'Message sent to next instance',1,'33825850215703536878','Mass'),(21,'254718667391','2021-11-30 10:48:39','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'33825852061833825407','Mass'),(22,'254718667391','2021-11-30 10:48:39','Hi you have a new post on COMPLAIN dddddddddd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825852061833825407','Mass'),(23,'254718667391','2021-11-30 10:48:39','Hi you have a new post on OTHERS dd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825852061833825407','Mass'),(24,'254718667391','2021-11-30 10:50:57','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'33825865920103536405','Mass'),(25,'254718667391','2021-11-30 10:50:57','Hi you have a new post on COMPLAIN dddddddddd','PENDING','1','1',0,0,'Message sent to next instance',1,'33825865920103536405','Mass'),(26,'254718667391','2021-11-30 10:53:58','Hi you have a new post on COMPLAIN test','PENDING','1','1',0,0,'Message sent to next instance',1,'0','Single'),(27,'','2021-11-30 11:40:29','  on 01/01/1970 at . From BONDENI PRIMARY SCHOOL','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(28,'','2021-11-30 11:40:29','  on 01/01/1970 at . From BONDENI PRIMARY SCHOOL','REJECTED','1','1',0,0,'Missing destination.',0,'','Mass'),(29,'254718667391','2021-12-02 09:06:38am','','PENDING','1','1',0,0,'Message sent to next instance',1,'0','Single'),(30,'254718667391','2021-12-02 09:55:10am','','PENDING','1','1',0,0,'Message sent to next instance',1,'0','Single'),(31,'254718667391','2021-12-02 09:55:52am','','active','1','1',0,0,'',0,'',''),(32,'254718667391','2021-12-04 11:35:06','Hi you have a new post on OTHERS dd','active','1','1',0,0,'',0,'',''),(33,'254718667391','2021-12-04 11:35:06','Hi you have a new post on OTHERS dd','active','1','1',0,0,'',0,'',''),(34,'254718667391','2022-09-06 10:23:36','GIDEON SINGALO 66666 on 06/09/2022 at 10:23:19am. From BONDENI PRIMARY SCHOOL','active','1','1',0,0,'',0,'',''),(35,'254718667391','2022-11-11 03:53:07pm','Hi you have a new post on SUGGESTIONS Keep up with the good services','active','1','1',0,0,'',0,'',''),(36,'254718667391','2022-11-11 04:00:49pm','Hi you have a new post on SUGGESTIONS Good service','active','1','1',0,0,'',0,'',''),(37,'254718667391','2022-11-11 06:39:31pm','Hi you have a new post on SUGGESTIONS Please include digital menu on this system','active','1','1',0,0,'',0,'',''),(38,'254718667391','2022-11-11 06:40:49pm','Hi you have a new post on SUGGESTIONS Admin test','active','1','1',0,0,'',0,'',''),(39,'254718667391','2022-11-16 10:18:30am','Hi you have a new post on SUGGESTIONS Please update your menus','active','1','1',0,0,'',0,'',''),(40,'254718667391','2022-11-16 02:44:11pm','Hi you have a new post on SUGGESTIONS Hi','active','1','1',0,0,'',0,'',''),(41,'254795602114','2022-11-16 02:52:37pm','TEST','active','1','1',0,0,'',0,'',''),(42,'254795602114','2022-11-16 02:54:34pm','Hi you have a new post on SUGGESTIONS Test','active','1','1',0,0,'',0,'',''),(43,'254722563021','2022-11-16 02:59:42pm','Hi you have a new post on SUGGESTIONS Good work','active','1','1',0,0,'',0,'',''),(44,'254795602114','2022-11-16 03:00:25pm','TEST','active','1','1',0,0,'',0,'',''),(45,'254722563021','2022-11-16 03:00:37pm','Hi you have a new post on SUGGESTIONS Hi','active','1','1',0,0,'',0,'',''),(46,'254722563021','2022-11-16 03:02:10pm','Hi you have a new post on RECOMMENDATIONS This is a test run','active','1','1',0,0,'',0,'',''),(47,'254722563021','2022-11-16 03:09:38pm','Hi you have a new post on RECOMMENDATIONS This is a test run','active','1','1',0,0,'',0,'',''),(48,'254722563021','2022-11-16 03:14:37pm','Hi you have a new post on RECOMMENDATIONS This is a test tun','active','1','1',0,0,'',0,'',''),(49,'254722563021','2022-11-16 03:15:04pm','Hi you have a new post on SUGGESTIONS Hi','active','1','1',0,0,'',0,'',''),(50,'254722563021','2022-11-16 03:34:34pm','Hi you have a new post on SUGGESTIONS Test Suggestion','active','1','1',0,0,'',0,'',''),(51,'254795602114','2022-11-16 03:34:34pm','Hi you have a new post on SUGGESTIONS Test Suggestion','active','1','1',0,0,'',0,'',''),(52,'254722563021','2022-11-16 04:52:34pm','Hi you have a new post on SUGGESTIONS Test','active','1','1',0,0,'',0,'',''),(53,'254707699136','2022-11-16 05:13:54pm','Test','active','1','1',0,0,'',0,'',''),(54,'254700344309','2022-11-16 05:14:36pm','Hi you have a new post on SUGGESTIONS Test','active','1','1',0,0,'',0,'',''),(55,'254707699136','2022-11-16 05:16:29pm','Hi you have a new post on SUGGESTIONS Test','active','1','1',0,0,'',0,'',''),(56,'254700344309','2022-11-16 05:18:32pm','Test','active','1','1',0,0,'',0,'',''),(57,'254700344309','2022-11-16 05:36:05pm','Hi you have a new post on SUGGESTIONS this is a good idea','active','1','1',0,0,'',0,'',''),(58,'254700344309','2022-11-17 11:47:21am','Hi you have a new post on TO CALL WAITER Lynn','active','1','1',0,0,'',0,'',''),(59,'254700344309','2022-11-17 11:47:48am','Hi you have a new post on TO CALL WAITER Call mr gerald','active','1','1',0,0,'',0,'',''),(60,'254700344309','2022-11-17 11:51:17am','Hi you have a new post on COMPLAINS Order not ready in 20 minutes','active','1','1',0,0,'',0,'','');
/*!40000 ALTER TABLE `sms` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `smsconfig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `smsconfig` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `username` text NOT NULL,
  `apikey` text NOT NULL,
  `from` varchar(50) NOT NULL,
  `link` text NOT NULL,
  `businessname` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `code` varchar(18) NOT NULL,
  `description` text NOT NULL,
  `contactperson` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `group` int(50) NOT NULL DEFAULT 1,
  `contact2` varchar(50) NOT NULL,
  `address` text NOT NULL,
  `currencysymbol` varchar(50) NOT NULL,
  `tax1` varchar(50) NOT NULL,
  `tax1rate` varchar(50) NOT NULL,
  `tax2` varchar(50) NOT NULL,
  `tax2rate` varchar(50) NOT NULL,
  `website` varchar(50) NOT NULL,
  `returnpolicy` varchar(50) NOT NULL,
  `logo` varchar(50) NOT NULL,
  `paymenttypes` text NOT NULL,
  `country` varchar(50) NOT NULL,
  `totalsms` varchar(50) NOT NULL,
  `userid` varchar(50) NOT NULL,
  `updatedat` varchar(50) NOT NULL,
  `startdate` varchar(30) NOT NULL,
  `renewdate` varchar(30) NOT NULL,
  `businesskey` text NOT NULL,
  `deadlinedetails` text NOT NULL,
  `deadline` text NOT NULL,
  `api` int(11) NOT NULL DEFAULT 2,
  `stop` int(11) NOT NULL,
  `path` text NOT NULL,
  `dublicate` varchar(5) NOT NULL DEFAULT 'no',
  `smscompany` varchar(20) NOT NULL,
  `newuser` varchar(30) NOT NULL,
  `newpassword` text NOT NULL,
  `senderid` varchar(15) NOT NULL,
  `menutype` varchar(30) NOT NULL DEFAULT 'Left',
  `contacts` text NOT NULL,
  `automaticsms` varchar(20) DEFAULT 'yes',
  `sender` int(11) NOT NULL DEFAULT 1,
  `defualtmessage` text NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `smsconfig` WRITE;
/*!40000 ALTER TABLE `smsconfig` DISABLE KEYS */;
INSERT INTO `smsconfig` VALUES (1,'76','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318','SMSCHAPCHAP','','Homeland','0718667391','','info@robisearch.com','ROBISEARCHLTD-SMS','<a href=\"http://www.robisearch.com/\">www.robisearch.com</a> Email :info@robisearch.com Phone: 0780655987 Phone: 0716413386 Experiencing any problem? Send an email to <a href=\"mailto:support@robisearch.com\">support@robisearch.com</a> or follow us on <a href=\"https://www.facebook.com/Robiearch?fref=ts\">Facebook</a> or on <a href=\"https://twitter.com/robisearch\">Twitter.</a> . You can also view more on <a href=\"http://www.robisearch.com/\"> our website</a>','254718667391','e7bd1efe6cee0b56cf3b31d7fb5d01c7',1,'0790962631/0716413386/0718667391.','5017639','','','','','','From Homeland Restaurant','<a href=\"http://www.robisearch.com/\">www.robisearc','','1.1-20,000 Ksh= 1Ksh per SMS. 2.21,000-50,000 Ksh= 0.8 Ksh per SMS. 3.51,000-100,000 Ksh= 0.7 Ksh per SMS. 4.101,000Ksh and Above.= 0.6 Ksh per SMS. ','1 ','','','2022-11-16 05:20:03pm','2019-03-28','2020-12-31','jyqi5/0unuQiClNSZ/lDHNrJLUJj/jZmL5HqkixyqQzAOhzD/JDF34prlaGoque3yctBoiQaZHqQPdmCsXyK5Q==','','J5mWwCaByEhOI71BiSoD/poCPdPXmfhgVk+joQ07iNOGgu0ETIJ1gGaIZfEd1HSmCuQYUnskU0PRdYjYrXoFbQ==',2,0,'D:\\\\xampp\\\\htdocs\\\\ATT2000.mdb','yes','Advanta','ROBISEARCH','Robisearch@2018','Robisearch','Left','254700344309','yes',1,'Hi you have a new post on'),(2,'Homeland','12345','Robisearch ','','Homeland','254722563021','','info@homelandlounge.com','Homeland','','','12345',1,'','','','','','','','','','','','','','','','2022-11-11','','','','',2,0,'','no','','','','','Left','','yes',1,'');
/*!40000 ALTER TABLE `smsconfig` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `smstemplate`
--

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

--
-- Dumping data for table `smstemplate`
--

LOCK TABLES `smstemplate` WRITE;
/*!40000 ALTER TABLE `smstemplate` DISABLE KEYS */;
INSERT INTO `smstemplate` VALUES (1,'Closing Day','Your daughter has been released for December holiday today.','2019-04-29 09:47:52am','active','1','','1'),(2,'Opening Day','Your Daughter Has Just Arrived To School ','2019-02-23 10:17:16am','active','1','','1'),(3,'Closing Day','Your daughter has been released for December holiday today.','2018-10-24 05:51:21pm','active','1','','1'),(4,'MIDTERM','Parents/Guardians who came for Thanks Giving day will be allowed to leave with their daughters for half-term, others will leave on 17/02/19.','2019-02-16 02:32:21pm','active','1','','1'),(5,'Opening Day','Almost all the students turned up from April Holiday recess','2019-04-30 04:30:08pm','active','1','','1'),(6,'Board meeting','There will  be a board meeting for the directors.','2019-05-18 03:02:06pm','active','1','','1');
/*!40000 ALTER TABLE `smstemplate` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `traffic`
--

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

--
-- Dumping data for table `traffic`
--

LOCK TABLES `traffic` WRITE;
/*!40000 ALTER TABLE `traffic` DISABLE KEYS */;
INSERT INTO `traffic` VALUES (1,'2021-11-30 08:07:24am','Home/index','127.0.0.1',''),(2,'2021-11-30 08:17:29am','Home/index','127.0.0.1',''),(3,'2021-11-30 08:17:57am','Home/index','127.0.0.1',''),(4,'2021-11-30 08:17:59am','About Us','127.0.0.1',''),(5,'2021-11-30 08:40:17am','Home/meeting','127.0.0.1',''),(6,'2021-11-30 08:40:26am','Home/index','127.0.0.1',''),(7,'2021-12-02 09:06:12am','Home/index','127.0.0.1',''),(8,'2021-12-02 09:06:16am','About Us','127.0.0.1',''),(9,'2021-12-02 09:06:48am','About Us','127.0.0.1',''),(10,'2021-12-02 09:06:50am','About Us','127.0.0.1',''),(11,'2021-12-02 09:10:29am','About Us','127.0.0.1',''),(12,'2021-12-02 09:10:43am','About Us','127.0.0.1',''),(13,'2021-12-02 09:10:46am','About Us','127.0.0.1',''),(14,'2021-12-02 09:55:44am','About Us','127.0.0.1',''),(15,'2021-12-04 09:10:33am','Home/index','127.0.0.1',''),(16,'2021-12-04 09:10:34am','Home/index','127.0.0.1',''),(17,'2021-12-04 09:20:18am','Home/index','127.0.0.1',''),(18,'2021-12-04 09:22:00am','Home/index','127.0.0.1',''),(19,'2021-12-04 09:22:04am','Home/index','127.0.0.1',''),(20,'2021-12-04 09:22:06am','About Us','127.0.0.1',''),(21,'2021-12-04 09:22:09am','About Us','127.0.0.1',''),(22,'2021-12-04 09:22:15am','Home/index','127.0.0.1',''),(23,'2021-12-04 09:31:55am','Home/index','127.0.0.1',''),(24,'2021-12-06 14:02:24pm','Home/index','127.0.0.1',''),(25,'2021-12-08 03:26:48am','Home/index','127.0.0.1',''),(26,'2022-02-05 09:59:42am','Home/index','127.0.0.1',''),(27,'2022-02-05 09:59:48am','About Us','127.0.0.1',''),(28,'2022-02-05 10:00:07am','About Us','127.0.0.1',''),(29,'2022-02-05 10:06:47am','About Us','127.0.0.1',''),(30,'2022-02-05 10:06:50am','About Us','127.0.0.1',''),(31,'2022-02-05 10:06:52am','Home/index','127.0.0.1',''),(32,'2022-02-05 10:07:16am','About Us','127.0.0.1',''),(33,'2022-02-05 10:07:20am','About Us','127.0.0.1',''),(34,'2022-02-05 10:08:29am','About Us','127.0.0.1',''),(35,'2022-02-05 10:47:44am','Home/index','127.0.0.1',''),(36,'2022-02-05 11:18:58am','Home/index','127.0.0.1',''),(37,'2022-02-05 13:40:29pm','Home/index','127.0.0.1',''),(38,'2022-02-28 13:14:07pm','Home/index','127.0.0.1',''),(39,'2022-03-01 14:36:11pm','Home/index','127.0.0.1',''),(40,'2022-03-01 14:36:12pm','About Us','127.0.0.1',''),(41,'2022-03-01 15:36:33pm','About Us','127.0.0.1',''),(42,'2022-03-01 15:47:54pm','About Us','127.0.0.1',''),(43,'2022-03-02 06:43:58am','Home/index','127.0.0.1',''),(44,'2022-05-17 17:43:58pm','Home/index','127.0.0.1',''),(45,'2022-06-16 10:44:50am','Home/index','127.0.0.1',''),(46,'2022-06-29 07:57:30am','Home/index','127.0.0.1',''),(47,'2022-06-29 09:06:08am','Home/index','127.0.0.1',''),(48,'2022-08-15 18:58:03pm','Home/index','127.0.0.1',''),(49,'2022-08-18 11:16:20am','Home/index','127.0.0.1',''),(50,'2022-09-06 09:21:00am','Home/index','127.0.0.1',''),(51,'2022-09-06 09:21:34am','Home/index','127.0.0.1',''),(52,'2022-09-14 05:56:28am','Home/index','127.0.0.1',''),(53,'2022-09-14 05:57:00am','Home/index','127.0.0.1',''),(54,'2022-09-21 04:35:59am','Home/index','127.0.0.1',''),(55,'2022-10-13 14:54:33pm','Home/index','127.0.0.1',''),(56,'2022-10-13 14:55:38pm','Home/index','127.0.0.1',''),(57,'2022-10-13 14:55:40pm','Home/meeting','127.0.0.1',''),(58,'2022-10-13 14:55:42pm','About Us','127.0.0.1',''),(59,'2022-10-13 14:56:53pm','About Us','127.0.0.1',''),(60,'2022-10-13 14:56:57pm','Home/index','127.0.0.1',''),(61,'2022-10-13 15:01:56pm','Home/index','127.0.0.1',''),(62,'2022-10-17 12:33:22pm','About Us','154.159.252.67',''),(63,'2022-10-17 12:33:26pm','Home/index','154.159.252.67',''),(64,'2022-10-17 12:33:53pm','Home/index','154.159.252.67',''),(65,'2022-10-17 12:36:07pm','Home/index','105.161.146.20',''),(66,'2022-10-17 13:09:20pm','About Us','197.232.142.176',''),(67,'2022-10-17 13:09:24pm','Home/index','197.232.142.176',''),(68,'2022-10-17 13:17:40pm','Home/index','197.232.142.176',''),(69,'2022-10-17 15:20:23pm','Home/index','107.178.207.22',''),(70,'2022-10-17 15:26:49pm','Home/index','34.254.53.125',''),(71,'2022-10-17 15:26:49pm','Home/index','34.254.53.125',''),(72,'2022-10-17 15:26:50pm','Home/index','34.254.53.125',''),(73,'2022-10-17 16:46:09pm','Home/index','158.181.37.98',''),(74,'2022-10-17 18:47:12pm','Home/index','107.178.207.4',''),(75,'2022-10-17 21:04:08pm','About Us','105.231.94.56',''),(76,'2022-10-17 21:04:38pm','About Us','105.231.94.56',''),(77,'2022-10-18 01:25:32am','Home/index','20.7.4.223',''),(78,'2022-10-18 02:49:26am','Home/index','65.154.226.109',''),(79,'2022-10-18 23:09:43pm','Home/index','52.90.127.152',''),(80,'2022-10-18 23:09:43pm','Home/index','52.90.223.218',''),(81,'2022-10-18 23:09:44pm','Home/index','54.221.154.62',''),(82,'2022-10-19 17:51:41pm','About Us','105.53.253.184',''),(83,'2022-10-19 17:51:54pm','About Us','105.160.95.136',''),(84,'2022-10-19 17:52:38pm','About Us','105.160.95.136',''),(85,'2022-10-19 17:53:23pm','About Us','105.160.95.136',''),(86,'2022-10-19 18:14:21pm','About Us','105.53.253.184',''),(87,'2022-10-19 18:36:03pm','About Us','102.140.222.249',''),(88,'2022-10-19 19:42:39pm','Home/index','102.219.208.44',''),(89,'2022-10-19 21:31:35pm','About Us','102.219.208.44',''),(90,'2022-10-19 22:36:39pm','About Us','102.219.208.44',''),(91,'2022-10-19 22:37:22pm','About Us','102.219.208.44',''),(92,'2022-10-19 22:38:17pm','About Us','102.219.208.44',''),(93,'2022-10-19 22:38:20pm','About Us','102.219.208.44',''),(94,'2022-10-20 01:32:49am','About Us','102.219.208.44',''),(95,'2022-10-20 01:40:14am','About Us','102.219.208.44',''),(96,'2022-10-20 09:09:54am','Home/index','223.178.209.98',''),(97,'2022-10-20 13:32:16pm','About Us','102.219.208.44',''),(98,'2022-10-20 13:32:21pm','About Us','102.219.208.44',''),(99,'2022-10-20 13:32:31pm','About Us','102.219.208.44',''),(100,'2022-10-20 13:32:33pm','About Us','102.219.208.44',''),(101,'2022-10-20 13:32:42pm','About Us','102.219.208.44',''),(102,'2022-10-20 13:33:01pm','About Us','102.219.208.44',''),(103,'2022-10-20 13:33:07pm','About Us','102.219.208.44',''),(104,'2022-10-20 15:41:37pm','Home/index','44.210.89.206',''),(105,'2022-10-20 15:41:38pm','Home/index','3.86.194.49',''),(106,'2022-10-20 15:41:38pm','Home/index','44.211.207.49',''),(107,'2022-10-20 22:01:18pm','About Us','102.219.208.44',''),(108,'2022-10-20 23:02:43pm','About Us','102.219.208.44',''),(109,'2022-10-20 23:02:51pm','About Us','102.219.208.44',''),(110,'2022-10-20 23:20:18pm','About Us','102.219.208.44',''),(111,'2022-10-20 23:20:30pm','About Us','102.219.208.44',''),(112,'2022-10-20 23:21:46pm','About Us','102.219.208.44',''),(113,'2022-10-20 23:32:53pm','About Us','102.219.208.44',''),(114,'2022-10-20 23:37:16pm','About Us','102.219.208.44',''),(115,'2022-10-20 23:38:01pm','Home/index','102.219.208.44',''),(116,'2022-10-20 23:38:40pm','About Us','102.219.208.44',''),(117,'2022-10-21 00:30:42am','About Us','102.219.208.44',''),(118,'2022-10-21 08:48:38am','Home/index','35.212.72.131',''),(119,'2022-10-21 11:39:10am','About Us','102.219.208.44',''),(120,'2022-10-21 11:40:04am','About Us','102.219.208.44',''),(121,'2022-10-21 11:40:25am','About Us','102.219.208.44',''),(122,'2022-10-21 14:26:56pm','About Us','102.219.208.44',''),(123,'2022-10-21 14:31:38pm','About Us','102.219.208.44',''),(124,'2022-10-21 14:31:43pm','About Us','102.219.208.44',''),(125,'2022-10-21 14:31:49pm','About Us','102.219.208.44',''),(126,'2022-10-21 14:34:04pm','About Us','102.219.208.44',''),(127,'2022-10-21 14:34:14pm','About Us','102.219.208.44',''),(128,'2022-10-21 14:41:57pm','About Us','102.219.208.44',''),(129,'2022-10-21 15:28:17pm','About Us','102.219.208.44',''),(130,'2022-10-22 02:46:22am','Home/index','5.197.226.22',''),(131,'2022-10-22 07:12:07am','Home/index','3.83.51.52',''),(132,'2022-10-22 07:12:07am','Home/index','54.85.151.151',''),(133,'2022-10-22 07:12:08am','Home/index','52.91.235.30',''),(134,'2022-10-22 09:49:46am','Home/index','54.84.193.78',''),(135,'2022-10-22 09:49:46am','Home/index','44.211.205.68',''),(136,'2022-10-22 09:49:47am','Home/index','54.237.224.151',''),(137,'2022-10-22 21:46:14pm','About Us','102.219.208.44',''),(138,'2022-10-22 21:46:22pm','About Us','102.219.208.44',''),(139,'2022-10-22 22:47:45pm','About Us','102.219.208.44',''),(140,'2022-10-22 22:47:56pm','About Us','102.219.208.44',''),(141,'2022-10-22 23:47:44pm','About Us','102.219.208.44',''),(142,'2022-10-22 23:50:10pm','About Us','102.219.208.44',''),(143,'2022-10-23 00:57:57am','About Us','102.219.208.44',''),(144,'2022-10-23 01:10:36am','About Us','102.219.208.44',''),(145,'2022-10-23 17:43:32pm','About Us','105.160.59.248',''),(146,'2022-10-23 21:51:19pm','Home/index','197.237.26.100',''),(147,'2022-10-24 01:10:17am','About Us','102.219.208.44',''),(148,'2022-10-24 01:46:29am','About Us','102.219.208.44',''),(149,'2022-10-24 01:46:43am','About Us','102.219.208.44',''),(150,'2022-10-24 14:59:34pm','Home/index','23.23.23.137',''),(151,'2022-10-24 14:59:34pm','Home/index','34.203.14.6',''),(152,'2022-10-24 14:59:35pm','Home/index','54.234.134.186',''),(153,'2022-10-24 15:04:42pm','About Us','197.232.61.224',''),(154,'2022-10-24 16:18:11pm','About Us','102.219.208.44',''),(155,'2022-10-24 19:58:52pm','Home/index','102.215.76.234',''),(156,'2022-10-24 20:02:26pm','About Us','102.219.208.44',''),(157,'2022-10-24 20:05:36pm','About Us','102.215.76.234',''),(158,'2022-10-24 20:18:43pm','About Us','102.215.76.234',''),(159,'2022-10-24 20:20:06pm','Home/index','102.215.76.234',''),(160,'2022-10-24 20:21:18pm','About Us','102.215.76.234',''),(161,'2022-10-24 23:29:46pm','Home/index','102.219.208.44',''),(162,'2022-10-24 23:30:28pm','Home/meeting','102.219.208.44',''),(163,'2022-10-24 23:30:31pm','About Us','102.219.208.44',''),(164,'2022-10-24 23:30:35pm','Home/index','102.219.208.44',''),(165,'2022-10-25 00:42:07am','About Us','102.219.208.44',''),(166,'2022-10-25 01:17:29am','About Us','102.219.208.44',''),(167,'2022-10-25 13:37:30pm','Home/index','154.77.184.153',''),(168,'2022-10-25 13:37:42pm','About Us','154.77.184.153',''),(169,'2022-10-25 13:38:04pm','Home/index','154.77.184.153',''),(170,'2022-10-25 13:39:11pm','Home/index','154.77.184.153',''),(171,'2022-10-25 13:39:20pm','About Us','154.77.184.153',''),(172,'2022-10-25 13:39:36pm','About Us','154.159.237.163',''),(173,'2022-10-25 13:42:58pm','About Us','41.80.96.125',''),(174,'2022-10-25 13:45:28pm','About Us','102.219.208.174',''),(175,'2022-10-25 13:45:41pm','About Us','197.232.142.176',''),(176,'2022-10-25 13:55:07pm','About Us','41.139.139.237',''),(177,'2022-10-25 14:15:29pm','About Us','197.232.142.176',''),(178,'2022-10-25 14:16:07pm','About Us','154.77.184.153',''),(179,'2022-10-25 14:24:21pm','About Us','154.159.237.193',''),(180,'2022-10-25 14:28:58pm','About Us','41.139.139.237',''),(181,'2022-10-26 10:13:38am','About Us','197.232.142.176',''),(182,'2022-10-26 10:48:31am','About Us','102.222.146.34',''),(183,'2022-10-26 14:18:05pm','Home/index','3.80.157.137',''),(184,'2022-10-26 14:18:05pm','Home/index','54.166.19.146',''),(185,'2022-10-26 14:18:06pm','Home/index','44.203.191.10',''),(186,'2022-10-26 15:03:56pm','About Us','154.159.237.91',''),(187,'2022-10-26 15:04:01pm','About Us','154.159.237.91',''),(188,'2022-10-26 17:35:47pm','Home/index','54.211.21.4',''),(189,'2022-10-26 17:35:47pm','Home/index','3.85.221.47',''),(190,'2022-10-26 17:35:48pm','Home/index','3.91.199.211',''),(191,'2022-10-27 11:21:07am','Home/index','107.22.128.55',''),(192,'2022-10-27 11:21:07am','Home/index','3.86.202.170',''),(193,'2022-10-27 11:21:07am','Home/index','3.84.19.215',''),(194,'2022-10-28 15:32:28pm','Home/index','35.175.196.44',''),(195,'2022-10-28 15:32:29pm','Home/index','174.129.70.14',''),(196,'2022-10-28 15:32:29pm','Home/index','54.175.28.159',''),(197,'2022-10-30 14:58:27pm','Home/index','54.92.214.140',''),(198,'2022-10-30 14:58:28pm','Home/index','54.242.80.182',''),(199,'2022-10-30 14:58:28pm','Home/index','34.235.167.188',''),(200,'2022-10-31 18:20:34pm','Home/index','3.89.89.209',''),(201,'2022-10-31 18:20:34pm','Home/index','44.212.57.28',''),(202,'2022-10-31 18:20:35pm','Home/index','54.209.104.128',''),(203,'2022-11-02 21:18:46pm','Home/index','34.254.163.29',''),(204,'2022-11-04 15:12:25pm','Home/index','41.212.117.252',''),(205,'2022-11-04 16:16:50pm','Home/index','154.159.254.247',''),(206,'2022-11-04 16:16:53pm','Home/meeting','154.159.254.247',''),(207,'2022-11-04 21:23:03pm','Home/index','105.160.17.169',''),(208,'2022-11-08 01:56:56am','Home/index','143.198.15.78',''),(209,'2022-11-08 15:32:25pm','Home/index','154.159.254.253',''),(210,'2022-11-08 16:21:55pm','Home/index','148.113.143.65',''),(211,'2022-11-08 16:22:09pm','Home/index','205.169.39.63',''),(212,'2022-11-08 16:22:24pm','Home/index','39.110.218.101',''),(213,'2022-11-08 17:15:21pm','About Us','154.159.254.186',''),(214,'2022-11-08 17:16:59pm','About Us','41.223.57.190',''),(215,'2022-11-08 17:17:47pm','About Us','41.223.57.190',''),(216,'2022-11-08 17:17:50pm','About Us','102.223.35.107',''),(217,'2022-11-08 17:18:01pm','About Us','154.159.254.1',''),(218,'2022-11-08 17:29:40pm','About Us','197.232.142.176',''),(219,'2022-11-08 17:42:58pm','About Us','105.230.207.249',''),(220,'2022-11-08 17:43:50pm','About Us','154.159.237.6',''),(221,'2022-11-09 13:00:25pm','About Us','154.159.252.167',''),(222,'2022-11-09 15:30:26pm','About Us','154.159.252.167',''),(223,'2022-11-09 15:32:30pm','About Us','154.159.252.167',''),(224,'2022-11-09 18:56:19pm','About Us','105.230.2.124',''),(225,'2022-11-09 19:13:27pm','About Us','105.230.2.124',''),(226,'2022-11-10 13:04:07pm','Home/index','148.113.140.244',''),(227,'2022-11-10 17:18:45pm','Home/index','205.169.39.52',''),(228,'2022-11-11 04:54:45am','Home/index','34.194.68.222',''),(229,'2022-11-11 17:13:00pm','Home/index','197.232.142.176',''),(230,'2022-11-11 17:13:14pm','About Us','197.232.142.176',''),(231,'2022-11-11 17:14:15pm','About Us','197.232.142.176',''),(232,'2022-11-11 17:15:21pm','About Us','197.232.142.176',''),(233,'2022-11-11 17:17:11pm','Home/index','197.232.142.176',''),(234,'2022-11-12 05:55:15am','Home/index','3.95.172.230',''),(235,'2022-11-12 05:55:16am','Home/index','54.221.38.36',''),(236,'2022-11-12 05:55:16am','Home/index','54.242.185.138',''),(237,'2022-11-13 09:01:57am','Home/index','54.225.62.105',''),(238,'2022-11-13 09:01:57am','Home/index','54.196.135.231',''),(239,'2022-11-13 09:01:58am','Home/index','3.87.237.99',''),(240,'2022-11-16 10:18:48am','About Us','105.161.96.70',''),(241,'2022-11-16 14:51:48pm','Home/index','197.232.142.176',''),(242,'2022-11-16 14:59:46pm','Home/index','197.232.142.176',''),(243,'2022-11-16 15:02:22pm','About Us','197.232.251.44',''),(244,'2022-11-16 15:33:55pm','About Us','197.232.142.176',''),(245,'2022-11-16 16:52:39pm','About Us','154.153.103.35',''),(246,'2022-11-16 16:52:56pm','About Us','154.153.103.35',''),(247,'2022-11-16 16:53:15pm','About Us','154.153.103.35',''),(248,'2022-11-16 16:53:20pm','About Us','154.153.103.35',''),(249,'2022-11-16 16:53:34pm','About Us','154.153.103.35',''),(250,'2022-11-16 16:53:41pm','About Us','154.153.103.35',''),(251,'2022-11-16 16:53:50pm','About Us','154.153.103.35',''),(252,'2022-11-16 16:53:52pm','About Us','154.153.103.35',''),(253,'2022-11-16 16:54:04pm','About Us','154.153.103.35',''),(254,'2022-11-16 16:54:21pm','About Us','154.153.103.35',''),(255,'2022-11-16 16:54:59pm','About Us','154.153.103.35',''),(256,'2022-11-16 16:55:41pm','About Us','154.153.103.35',''),(257,'2022-11-16 16:56:11pm','Home/index','154.153.103.35',''),(258,'2022-11-16 17:10:42pm','About Us','154.153.103.35',''),(259,'2022-11-16 17:16:16pm','About Us','154.153.103.35',''),(260,'2022-11-17 16:44:53pm','Home/index','35.213.167.52',''),(261,'2022-11-21 07:24:57am','Home/index','54.196.138.32',''),(262,'2022-11-21 07:24:57am','Home/index','54.211.206.193',''),(263,'2022-11-21 07:24:58am','Home/index','54.211.206.193',''),(264,'2022-11-21 07:47:11am','Home/index','64.43.110.168',''),(265,'2022-11-22 05:49:08am','Home/index','13.49.74.148',''),(266,'2022-11-24 14:59:51pm','Home/index','59.4.148.231',''),(267,'2022-11-24 14:59:52pm','Home/index','23.20.96.75',''),(268,'2022-11-24 14:59:56pm','Home/index','153.229.183.127',''),(269,'2022-11-24 15:00:14pm','Home/index','3.80.33.20',''),(270,'2022-12-01 13:06:34pm','Home/index','205.169.39.63',''),(271,'2022-12-03 02:34:25am','Home/index','203.75.213.3',''),(272,'2022-12-07 06:24:30am','Home/index','34.245.224.162',''),(273,'2022-12-15 07:39:36am','Home/index','174.138.50.111',''),(274,'2023-01-03 19:27:12pm','Home/index','163.172.148.199',''),(275,'2023-01-04 19:12:48pm','Home/index','34.240.139.156',''),(276,'2023-01-09 02:44:53am','Home/index','104.131.2.156',''),(277,'2023-01-09 05:39:51am','Home/index','104.236.194.5',''),(278,'2023-01-10 12:30:42pm','Home/index','65.154.226.169',''),(279,'2023-01-10 12:31:18pm','Home/index','39.110.218.101',''),(280,'2023-01-10 14:30:11pm','Home/index','133.242.174.119',''),(281,'2023-01-10 14:30:19pm','Home/index','133.242.140.127',''),(282,'2023-01-11 01:23:36am','Home/index','47.242.105.176',''),(283,'2023-01-11 04:52:19am','Home/index','47.242.105.176',''),(284,'2023-01-12 08:36:35am','Home/index','34.248.218.61',''),(285,'2023-01-13 16:53:31pm','Home/index','5.75.198.159',''),(286,'2023-01-19 03:59:26am','Home/index','146.70.45.164',''),(287,'2023-01-19 03:59:27am','Home/index','146.70.45.164',''),(288,'2023-01-19 14:44:07pm','Home/index','35.219.139.221',''),(289,'2023-01-30 14:05:37pm','About Us','154.78.131.85',''),(290,'2023-01-30 14:05:45pm','About Us','154.78.131.85',''),(291,'2023-01-30 14:06:25pm','Home/index','154.78.131.85',''),(292,'2023-01-30 14:08:54pm','Home/meeting','154.78.131.85',''),(293,'2023-01-30 14:08:57pm','About Us','154.78.131.85',''),(294,'2023-01-30 14:10:49pm','About Us','154.78.131.85',''),(295,'2023-01-30 14:21:54pm','About Us','154.78.131.85',''),(296,'2023-01-31 12:08:46pm','Home/index','205.169.39.63',''),(297,'2023-02-07 16:56:01pm','Home/index','52.51.196.93',''),(298,'2023-02-07 18:15:33pm','Home/index','54.229.171.29',''),(299,'2023-02-26 10:55:37am','Home/index','167.248.133.185',''),(300,'2023-03-01 22:33:16pm','Home/index','157.90.225.244',''),(301,'2023-03-07 21:13:47pm','Home/index','3.249.45.165',''),(302,'2023-03-07 23:03:05pm','Home/index','34.255.182.169',''),(303,'2023-03-12 12:31:00pm','Home/index','39.110.218.101',''),(304,'2023-03-12 12:31:19pm','Home/index','65.154.226.171',''),(305,'2023-03-12 12:32:06pm','Home/index','179.43.169.181',''),(306,'2023-03-12 12:32:08pm','Home/index','179.43.169.181',''),(307,'2023-03-12 17:03:07pm','Home/index','205.169.39.251',''),(308,'2023-03-12 17:03:25pm','Home/index','205.169.39.251',''),(309,'2023-03-12 21:30:45pm','Home/index','207.241.236.61',''),(310,'2023-03-13 00:31:21am','Home/index','47.242.105.176',''),(311,'2023-03-13 11:45:47am','Home/index','167.235.228.214',''),(312,'2023-03-13 11:45:47am','Home/index','167.235.228.214',''),(313,'2023-03-16 21:02:10pm','Home/index','51.255.62.0',''),(314,'2023-03-16 21:02:12pm','Home/index','51.255.62.4',''),(315,'2023-03-17 03:24:41am','Home/index','51.254.49.105',''),(316,'2023-03-24 08:04:21am','Home/index','34.92.211.169',''),(317,'2023-04-02 12:48:57pm','Home/index','65.154.226.166',''),(318,'2023-04-04 18:51:49pm','Home/index','51.255.62.0',''),(319,'2023-04-04 18:51:50pm','Home/index','51.255.62.0',''),(320,'2023-04-04 22:13:17pm','Home/index','51.254.49.98',''),(321,'2023-04-08 06:25:53am','Home/index','3.252.253.60',''),(322,'2023-04-08 07:05:27am','Home/index','52.209.163.29',''),(323,'2023-04-15 22:02:20pm','Home/index','35.80.18.130',''),(324,'2023-04-19 21:23:32pm','Home/index','34.245.32.173',''),(325,'2023-05-03 23:29:07pm','Home/index','54.78.14.74',''),(326,'2023-05-11 02:19:27am','Home/index','3.145.29.86',''),(327,'2023-05-11 09:38:22am','Home/index','34.243.81.209',''),(328,'2023-05-11 10:28:21am','Home/index','34.245.78.161',''),(329,'2023-05-12 15:27:08pm','Home/index','65.109.170.9',''),(330,'2023-05-12 20:32:00pm','Home/index','47.242.105.176',''),(331,'2023-05-14 04:41:05am','Home/index','188.166.167.168',''),(332,'2023-05-14 04:41:05am','Home/index','188.166.167.168',''),(333,'2023-05-21 18:13:15pm','Home/index','65.2.54.222',''),(334,'2023-05-30 07:02:08am','Home/index','54.91.58.134',''),(335,'2023-05-30 07:02:08am','Home/index','54.91.58.134',''),(336,'2023-06-06 02:03:44am','Home/index','54.74.51.105',''),(337,'2023-06-06 06:07:17am','Home/index','3.249.131.219',''),(338,'2023-06-09 16:10:45pm','Home/index','51.255.62.6',''),(339,'2023-06-09 16:10:47pm','Home/index','51.255.62.13',''),(340,'2023-06-09 18:22:53pm','Home/index','51.254.49.98','');
/*!40000 ALTER TABLE `traffic` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(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',
  `companyid` varchar(100) NOT NULL,
  `service` varchar(100) NOT NULL,
  `usertype` varchar(50) DEFAULT NULL,
  `smstype` int(10) NOT NULL DEFAULT 2,
  `refer` text NOT NULL,
  `rate` decimal(1,0) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idno` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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,'Bondeni','Bondeni Primary','','robisearch@gmail.com','254700344309','','','2016-12-24','12345678','','','','201807311533002481201606151466003799Handheld-Point-of-Sale.jpg','','','','','2022-11-16','922','1','n/a','1','1','','admin',2,'',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:17:08