/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: robisear_citamclaycity -- ------------------------------------------------------ -- 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=2 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'); /*!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 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 */; /*!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,'TSC Teachers','ok','2021-08-31 06:29:18am','active','1','','1','08:00','17:00'),(2,'PTA Teachers','','2020-03-23 03:32:23pm','active','1','','1',NULL,NULL),(3,'Non-Teaching Staff','','2021-08-31 06:31:54am','active','1','','1','08:00','17:00'),(4,'form','','2021-06-12 10:36:33am','active','1','','1',NULL,NULL),(5,'form 2','','2021-08-31 06:36:52am','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=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `complain` -- LOCK TABLES `complain` WRITE; /*!40000 ALTER TABLE `complain` DISABLE KEYS */; INSERT INTO `complain` VALUES (1,'TESTIMONY','Great','2022-11-25 13:58:29','New','1','','1','No','3',0,'',NULL,'','8035863771669373909'); /*!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 AUTO_INCREMENT=8 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 */; INSERT INTO `complaindata` VALUES (1,'well','2021-11-12 07:16:39','5','1','newstock','1'),(2,'sdd','2021-11-30 07:30:16','30','1','newstock','1'),(3,'wdd','2021-11-30 07:33:19','30','1','newstock','1'),(4,'wdd','2021-11-30 07:33:37','30','1','newstock','1'),(5,'nnn','2021-11-30 07:34:31','30','1','newstock','1'),(6,'ll','2021-11-30 07:35:01','30','1','newstock','1'),(7,'eee','2021-11-30 07:37:27','30','1','newstock','1'); /*!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 AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grouping` -- LOCK TABLES `grouping` WRITE; /*!40000 ALTER TABLE `grouping` DISABLE KEYS */; INSERT INTO `grouping` VALUES (1,'1','1','2021-06-23','','1','','2','1'),(2,'2','1','2021-06-23','','1','','1','1'),(3,'3','1','2021-06-23','','1','','2','1'),(4,'4','1','2021-06-23','','1','','1','1'),(5,'5','1','2021-06-23','','1','','1','1'),(6,'1','1','2021-11-11 05:54:53am','','1','','4','1'); /*!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=3 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-07-23 19:54:47','','','41.212.20.58','loggedin',1),(2,'admin','1','2022-07-23 20:02:22','','','41.212.20.58','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 AUTO_INCREMENT=6 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 */; INSERT INTO `meeting` VALUES (3,'JKUAT TEST','2019-08-17','2019-08-17','F9B02I','new','ready','2019-08-17 04:58:58am','1','','1'),(4,'KU TEST','2019-08-16','2019-08-22','GC315G','new','OK','2019-08-17 04:59:21am','1','','1'),(5,'ICT MEETING','2019-08-19','2019-08-30','610K03','ongoing','To discus ict probles','2019-08-19 07:21:51pm','1','','1'); /*!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 AUTO_INCREMENT=6 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 */; INSERT INTO `mpesa` VALUES (1,NULL,NULL,NULL,NULL,NULL,'2017-06-16 10:14:10','null',''),(2,NULL,NULL,NULL,NULL,NULL,'2017-06-16 10:14:17','null',''),(3,NULL,NULL,NULL,NULL,NULL,'2017-06-16 10:26:39','null',''),(4,NULL,NULL,NULL,NULL,NULL,'2017-06-23 18:36:46','null',''),(5,NULL,NULL,NULL,NULL,'-validate','2017-06-23 18:44:08','null',''); /*!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','254715863336','','','','','','1','',NULL,'member','1','','','','66666','','1','2021-11-11 05:54:53am','','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=9 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,'COMPLAIN',0,'2021-11-12 07:51:26','active','1','','1','','0','','Percentage',NULL,'red','briefcase'),(2,'SUGGESTIONS',90,'2022-07-23 19:55:48','active','1','','1','','0','','Percentage',NULL,'blue','briefcase'),(3,'TESTIMONY',89,'2022-07-23 19:56:50','active','1','','1','','0','','Percentage',NULL,'blue','cubes'),(4,'RECOMMENDATION',0,'2021-11-12 07:53:00','active','1','','1','','0','','Percentage',NULL,'aqua','film'),(5,'FREE GIFTS',0,'2022-07-23 20:03:29','active','1','','1','','0','','Percentage',NULL,'green','square'),(6,'EXPRIENCE AND EXPECTATIONS',0,'2022-07-23 20:03:04','active','1','','1','','0','','Percentage',NULL,'cyan','dedent'),(7,'PRAYER REQUEST',0,'2022-07-23 19:58:38','active','1','','1','','0','','Percentage',NULL,'purple','triangle'),(8,'TITHES AND OFFERING',0,'2022-07-23 19:57:54','active','1','','1','','0','','Percentage',NULL,'pink','gamepad'); /*!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 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 */; /*!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=2 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','',''); /*!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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sms` -- LOCK TABLES `sms` WRITE; /*!40000 ALTER TABLE `sms` DISABLE KEYS */; /*!40000 ALTER TABLE `sms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smsconfig` -- DROP TABLE IF EXISTS `smsconfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `smsconfig` ( `id` int(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=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `smsconfig` -- LOCK TABLES `smsconfig` WRITE; /*!40000 ALTER TABLE `smsconfig` DISABLE KEYS */; INSERT INTO `smsconfig` VALUES (1,'76','0763a9ef91068d1723cf54a8b95bf1c5fc003cbb3a84ebe2f24d5ae9bb8f4318','Robisearch','','SCHOOL NAME','0718667391','','info@robisearch.com','ROBISEARCHLTD-SMS','<a href=\"http://www.robisearch.com/\">www.robisearch.com</a> <br> Email :info@robisearch.com<br> Phone: 0780655987<br> Phone: 0716413386<br> 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.','50176399','','','','','','From BONDENI PRIMARY SCHOOL','<a href=\"http://www.robisearch.com/\">www.robisearc','','1.1-20,000 Ksh= 1Ksh per SMS.<BR> 2.21,000-50,000 Ksh= 0.8 Ksh per SMS.<BR> 3.51,000-100,000 Ksh= 0.7 Ksh per SMS.<BR> 4.101,000Ksh and Above.= 0.6 Ksh per SMS.<BR>','1 ','','','2021-11-19 03:27:55pm','2019-03-28','2020-12-31','SfdGnAokMmpyDgcI3aYPGHDx/SNCNjcm04/80RVpUBGhXk6o3cdmaVDPNMM6N4hrTtvc3Xb5dgBai1FtPYjS7A==','','iDUPyaRgautIXDcjfXEiZiat76e6n0wmbUXFflZYx44rQHc2I614a2Zj8R5MKv1pXh3CXuuYGewFt/n0LqaJWw==',2,0,'D:\\\\xampp\\\\htdocs\\\\ATT2000.mdb','yes','Advanta','ROBISEARCH','Robisearch@2018','Robisearch','Left','254718667391','no',1,'Hi you have a new post on'); /*!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=761 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,'2022-07-23 19:48:07pm','Home/index','41.212.20.58',''),(2,'2022-07-23 19:48:51pm','Home/index','41.212.20.58',''),(3,'2022-07-23 19:48:59pm','About Us','41.212.20.58',''),(4,'2022-07-23 19:52:29pm','About Us','41.212.20.58',''),(5,'2022-07-23 19:53:32pm','Home/index','3.84.47.219',''),(6,'2022-07-23 19:54:09pm','About Us','41.212.20.58',''),(7,'2022-07-23 19:54:42pm','Home/index','41.212.20.58',''),(8,'2022-07-23 20:00:59pm','About Us','41.212.20.58',''),(9,'2022-07-23 20:02:15pm','Home/index','41.212.20.58',''),(10,'2022-07-23 20:02:15pm','Home/index','41.212.20.58',''),(11,'2022-07-23 20:03:36pm','Home/index','41.212.20.58',''),(12,'2022-07-23 20:03:40pm','About Us','41.212.20.58',''),(13,'2022-07-23 20:13:33pm','Home/index','34.244.219.187',''),(14,'2022-07-23 21:00:49pm','Home/index','69.25.58.56',''),(15,'2022-07-24 03:41:12am','Home/index','205.169.39.57',''),(16,'2022-07-24 11:48:57am','Home/index','51.255.62.3',''),(17,'2022-07-24 11:48:57am','Home/index','51.255.62.11',''),(18,'2022-07-24 13:56:05pm','Home/index','51.254.49.103',''),(19,'2022-07-25 21:02:07pm','Home/index','18.206.55.48',''),(20,'2022-07-25 21:02:08pm','Home/index','18.206.55.48',''),(21,'2022-07-25 21:02:08pm','Home/index','18.206.55.48',''),(22,'2022-07-25 21:03:01pm','Home/index','54.227.32.154',''),(23,'2022-07-26 03:49:08am','Home/index','51.255.62.5',''),(24,'2022-07-26 05:31:42am','Home/index','51.254.49.107',''),(25,'2022-07-27 03:02:26am','Home/index','18.206.55.48',''),(26,'2022-07-27 03:02:27am','Home/index','18.206.55.48',''),(27,'2022-07-27 03:02:27am','Home/index','18.206.55.48',''),(28,'2022-07-27 03:03:16am','Home/index','54.227.32.154',''),(29,'2022-07-31 01:11:04am','Home/index','18.206.55.48',''),(30,'2022-07-31 01:11:05am','Home/index','18.206.55.48',''),(31,'2022-07-31 01:11:05am','Home/index','18.206.55.48',''),(32,'2022-07-31 01:11:45am','Home/index','54.227.32.154',''),(33,'2022-08-03 21:24:33pm','Home/index','161.35.191.225',''),(34,'2022-08-06 06:25:15am','Home/index','151.106.120.184',''),(35,'2022-08-10 23:43:39pm','Home/index','164.90.136.62',''),(36,'2022-08-14 02:19:10am','Home/index','18.209.17.225',''),(37,'2022-08-14 02:19:10am','Home/index','34.228.156.129',''),(38,'2022-08-14 02:19:10am','Home/index','23.22.46.217',''),(39,'2022-08-14 02:19:33am','Home/index','100.26.187.100',''),(40,'2022-08-16 02:30:54am','Home/index','44.202.160.63',''),(41,'2022-08-16 02:30:54am','Home/index','44.202.10.54',''),(42,'2022-08-16 02:30:55am','Home/index','35.173.213.100',''),(43,'2022-08-16 02:31:03am','Home/index','107.23.155.233',''),(44,'2022-08-19 03:18:56am','Home/index','184.72.78.116',''),(45,'2022-08-19 03:18:57am','Home/index','34.238.247.219',''),(46,'2022-08-19 03:18:57am','Home/index','54.89.6.153',''),(47,'2022-08-19 03:19:22am','Home/index','3.82.198.10',''),(48,'2022-08-20 00:32:32am','Home/index','3.86.247.136',''),(49,'2022-08-20 00:32:32am','Home/index','44.201.181.212',''),(50,'2022-08-20 00:32:33am','Home/index','44.201.181.212',''),(51,'2022-08-20 03:08:02am','Home/index','54.167.156.205',''),(52,'2022-08-24 18:48:25pm','Home/index','163.172.148.199',''),(53,'2022-09-10 10:15:06am','Home/index','68.183.48.64',''),(54,'2022-09-10 10:20:19am','Home/index','167.71.183.129',''),(55,'2022-09-23 12:05:44pm','Home/index','51.255.62.0',''),(56,'2022-09-23 12:05:45pm','Home/index','51.255.62.6',''),(57,'2022-09-23 14:56:48pm','Home/index','51.254.49.98',''),(58,'2022-10-08 07:57:33am','Home/index','104.248.10.0',''),(59,'2022-10-08 08:22:07am','Home/index','167.71.89.206',''),(60,'2022-10-12 13:06:07pm','Home/index','51.158.127.119',''),(61,'2022-11-08 02:51:16am','Home/index','143.198.17.188',''),(62,'2022-11-08 05:12:57am','Home/index','165.227.120.203',''),(63,'2022-11-22 05:51:16am','Home/index','13.49.74.148',''),(64,'2022-11-23 15:38:15pm','Home/index','51.255.62.11',''),(65,'2022-11-23 15:38:15pm','Home/index','51.255.62.1',''),(66,'2022-11-23 17:37:33pm','Home/index','51.254.49.98',''),(67,'2022-11-25 13:21:34pm','Home/index','197.232.141.209',''),(68,'2022-11-25 13:22:28pm','Home/index','154.152.2.106',''),(69,'2022-11-25 13:22:32pm','About Us','154.152.2.106',''),(70,'2022-11-25 13:24:30pm','Home/index','197.232.152.237',''),(71,'2022-11-25 13:31:18pm','Home/index','197.232.141.209',''),(72,'2022-11-25 14:20:30pm','Home/index','154.152.2.106',''),(73,'2022-11-25 14:20:33pm','About Us','154.152.2.106',''),(74,'2022-12-13 16:17:44pm','About Us','197.232.152.237',''),(75,'2022-12-13 16:18:00pm','Home/index','197.232.152.237',''),(76,'2022-12-15 06:54:45am','Home/index','143.198.4.165',''),(77,'2022-12-22 23:14:01pm','Home/index','35.217.34.194',''),(78,'2023-01-04 23:58:13pm','Home/index','54.229.46.113',''),(79,'2023-01-06 11:35:37am','Home/index','51.158.108.61',''),(80,'2023-01-09 02:09:52am','Home/index','138.197.31.137',''),(81,'2023-01-12 08:15:27am','Home/index','3.250.235.189',''),(82,'2023-01-13 16:53:31pm','Home/index','5.75.198.159',''),(83,'2023-01-23 09:30:23am','Home/index','47.242.105.176',''),(84,'2023-01-23 15:42:08pm','Home/index','51.255.62.8',''),(85,'2023-01-23 15:42:10pm','Home/index','51.255.62.1',''),(86,'2023-01-23 17:11:41pm','Home/index','51.254.49.104',''),(87,'2023-02-02 21:10:16pm','Home/index','54.78.62.41',''),(88,'2023-02-07 18:53:21pm','Home/index','3.253.118.41',''),(89,'2023-02-07 19:34:35pm','Home/index','3.253.108.203',''),(90,'2023-02-12 21:17:25pm','Home/index','205.169.39.19',''),(91,'2023-03-01 22:33:15pm','Home/index','157.90.225.244',''),(92,'2023-03-03 11:41:30am','Home/index','3.249.17.122',''),(93,'2023-03-04 00:58:57am','Home/index','3.253.130.136',''),(94,'2023-03-07 19:05:46pm','Home/index','54.194.142.122',''),(95,'2023-03-07 21:10:25pm','Home/index','3.253.90.130',''),(96,'2023-03-24 21:30:41pm','Home/index','65.154.226.168',''),(97,'2023-03-24 21:31:14pm','Home/index','95.217.186.250',''),(98,'2023-03-24 21:31:20pm','Home/index','95.217.186.250',''),(99,'2023-03-24 21:34:23pm','Home/index','205.169.39.241',''),(100,'2023-03-24 21:34:41pm','Home/index','205.169.39.241',''),(101,'2023-03-25 04:39:26am','Home/index','47.242.105.176',''),(102,'2023-04-01 08:13:39am','Home/index','34.242.77.147',''),(103,'2023-04-03 07:12:49am','Home/index','51.255.62.0',''),(104,'2023-04-03 07:12:51am','Home/index','51.255.62.12',''),(105,'2023-04-03 10:01:46am','Home/index','51.254.49.102',''),(106,'2023-04-08 05:16:04am','Home/index','52.17.199.213',''),(107,'2023-04-08 06:40:09am','Home/index','3.249.161.196',''),(108,'2023-04-14 22:23:03pm','Home/index','65.155.30.101',''),(109,'2023-04-15 06:05:01am','Home/index','3.96.59.102',''),(110,'2023-04-19 14:37:14pm','Home/index','35.213.251.244',''),(111,'2023-04-22 20:12:43pm','Home/index','46.137.132.58',''),(112,'2023-05-11 09:50:12am','Home/index','54.154.86.233',''),(113,'2023-05-11 10:10:09am','Home/index','34.240.92.237',''),(114,'2023-05-11 11:58:15am','Home/index','18.118.84.133',''),(115,'2023-05-14 17:21:33pm','Home/index','167.248.133.189',''),(116,'2023-05-20 21:56:39pm','Home/index','18.219.49.109',''),(117,'2023-05-25 15:01:59pm','Home/index','47.242.105.176',''),(118,'2023-05-26 18:12:58pm','Home/index','3.88.12.67',''),(119,'2023-06-06 03:28:23am','Home/index','54.74.71.71',''),(120,'2023-06-06 03:59:45am','Home/index','52.212.209.210',''),(121,'2023-06-16 22:53:36pm','Home/index','105.27.239.198',''),(122,'2023-06-21 14:00:02pm','Home/index','3.70.172.128',''),(123,'2023-06-27 23:12:37pm','Home/index','34.243.11.219',''),(124,'2023-07-03 08:38:53am','Home/index','167.172.238.166',''),(125,'2023-07-03 08:38:54am','Home/index','167.172.238.166',''),(126,'2023-07-03 14:22:33pm','Home/index','34.254.250.73',''),(127,'2023-07-03 22:27:34pm','Home/index','3.249.161.166',''),(128,'2023-07-08 11:22:26am','Home/index','18.184.211.225',''),(129,'2023-07-09 22:15:46pm','Home/index','51.158.127.119',''),(130,'2023-07-12 02:03:20am','Home/index','34.254.159.115',''),(131,'2023-07-12 03:23:11am','Home/index','46.137.61.58',''),(132,'2023-07-12 10:36:12am','Home/index','3.253.193.150',''),(133,'2023-07-12 23:06:08pm','Home/index','3.125.33.249',''),(134,'2023-07-19 06:50:15am','Home/index','64.227.133.204',''),(135,'2023-07-19 06:50:15am','Home/index','64.227.133.204',''),(136,'2023-07-19 15:40:53pm','Home/index','209.141.49.169',''),(137,'2023-07-25 12:15:51pm','Home/index','134.209.157.65',''),(138,'2023-07-25 12:15:52pm','Home/index','134.209.157.65',''),(139,'2023-07-25 12:50:29pm','Home/index','165.227.195.234',''),(140,'2023-07-25 12:50:30pm','Home/index','165.227.195.234',''),(141,'2023-07-25 22:32:35pm','Home/index','138.199.21.237',''),(142,'2023-07-25 23:32:24pm','Home/index','47.242.105.176',''),(143,'2023-07-26 01:45:56am','Home/index','54.74.22.91',''),(144,'2023-07-26 11:28:53am','Home/index','47.242.105.176',''),(145,'2023-08-02 05:15:46am','Home/index','206.189.11.20',''),(146,'2023-08-02 05:15:47am','Home/index','206.189.11.20',''),(147,'2023-08-03 02:24:17am','Home/index','3.72.39.154',''),(148,'2023-08-05 17:40:48pm','Home/index','54.93.188.236',''),(149,'2023-08-06 21:43:18pm','Home/index','3.249.112.60',''),(150,'2023-08-06 22:13:00pm','Home/index','3.250.131.112',''),(151,'2023-08-09 01:35:08am','Home/index','18.192.212.11',''),(152,'2023-08-14 00:55:07am','Home/index','188.165.87.111',''),(153,'2023-08-14 00:55:37am','Home/index','188.165.87.98',''),(154,'2023-08-14 02:48:09am','Home/index','51.254.49.101',''),(155,'2023-08-16 10:59:54am','Home/index','104.248.35.122',''),(156,'2023-08-20 12:41:10pm','Home/index','54.229.237.36',''),(157,'2023-08-23 18:54:06pm','Home/index','18.202.242.7',''),(158,'2023-08-30 05:10:38am','Home/index','67.205.166.156',''),(159,'2023-09-02 22:51:29pm','Home/index','54.234.95.26',''),(160,'2023-09-05 00:01:12am','Home/index','3.252.212.237',''),(161,'2023-09-07 13:47:01pm','Home/index','3.253.133.223',''),(162,'2023-09-07 14:32:25pm','Home/index','54.170.91.22',''),(163,'2023-09-13 10:17:45am','Home/index','134.209.145.234',''),(164,'2023-09-21 12:41:10pm','Home/index','47.128.30.55',''),(165,'2023-09-22 17:44:09pm','About Us','47.128.54.68',''),(166,'2023-09-22 17:46:54pm','Home/index','47.128.46.42',''),(167,'2023-09-22 17:47:17pm','About Us','47.128.39.16',''),(168,'2023-09-22 17:48:28pm','Home/meeting','47.128.21.33',''),(169,'2023-09-22 20:15:24pm','Home/meeting','47.128.37.40',''),(170,'2023-09-22 20:59:00pm','About Us','47.128.57.208',''),(171,'2023-09-22 21:10:40pm','Home/index','47.128.24.212',''),(172,'2023-09-23 21:31:38pm','Home/index','206.217.205.48',''),(173,'2023-09-24 05:31:38am','Home/index','47.242.224.70',''),(174,'2023-09-24 19:18:06pm','Home/index','205.169.39.118',''),(175,'2023-09-24 19:18:40pm','Home/index','205.169.39.118',''),(176,'2023-09-25 09:31:00am','Home/index','143.198.30.68',''),(177,'2023-09-26 10:49:35am','Home/index','47.128.31.15',''),(178,'2023-09-26 15:18:51pm','Home/index','3.79.104.33',''),(179,'2023-09-27 10:43:47am','Home/index','188.166.2.160',''),(180,'2023-09-29 17:51:48pm','Home/index','47.128.28.154',''),(181,'2023-09-30 11:55:08am','Home/index','3.68.216.79',''),(182,'2023-10-01 05:31:06am','Home/index','47.128.41.166',''),(183,'2023-10-02 15:16:22pm','Home/index','146.190.122.193',''),(184,'2023-10-02 18:40:40pm','Home/index','165.22.206.16',''),(185,'2023-10-04 02:06:01am','Home/index','47.128.63.89',''),(186,'2023-10-05 14:55:06pm','Home/index','52.50.87.250',''),(187,'2023-10-05 17:11:31pm','Home/index','3.252.66.19',''),(188,'2023-10-05 20:56:56pm','Home/index','47.128.41.15',''),(189,'2023-10-10 09:16:11am','Home/index','68.183.194.70',''),(190,'2023-10-11 07:27:38am','Home/index','167.71.97.46',''),(191,'2023-10-13 09:12:06am','Home/index','164.92.232.83',''),(192,'2023-10-14 21:27:24pm','Home/index','65.154.226.170',''),(193,'2023-10-16 01:08:30am','Home/index','137.184.12.53',''),(194,'2023-10-17 16:36:47pm','Home/index','137.184.12.53',''),(195,'2023-10-17 16:42:55pm','Home/index','137.184.12.53',''),(196,'2023-10-17 16:42:55pm','Home/index','137.184.12.53',''),(197,'2023-10-17 16:42:55pm','Home/index','137.184.12.53',''),(198,'2023-10-24 08:01:24am','Home/index','134.209.197.223',''),(199,'2023-10-25 15:53:33pm','Home/index','146.190.157.69',''),(200,'2023-10-25 16:26:43pm','Home/index','46.101.97.93',''),(201,'2023-11-05 09:41:14am','Home/index','36.99.136.136',''),(202,'2023-11-07 12:18:12pm','Home/index','54.170.92.120',''),(203,'2023-11-07 12:27:49pm','Home/index','63.35.222.221',''),(204,'2023-11-07 16:07:57pm','Home/index','36.99.136.128',''),(205,'2023-11-07 21:47:33pm','Home/index','159.203.4.100',''),(206,'2023-11-08 16:09:50pm','Home/index','164.92.113.23',''),(207,'2023-11-10 16:18:37pm','Home/index','47.128.59.198',''),(208,'2023-11-12 19:21:05pm','Home/index','156.146.62.52',''),(209,'2023-11-14 11:48:21am','Home/index','34.243.216.96',''),(210,'2023-11-15 09:42:31am','Home/index','47.128.63.161',''),(211,'2023-11-18 07:53:39am','Home/index','47.128.18.219',''),(212,'2023-11-20 12:35:18pm','Home/index','3.120.191.247',''),(213,'2023-11-21 08:19:25am','Home/index','143.198.146.15',''),(214,'2023-11-22 22:10:19pm','Home/index','24.144.95.159',''),(215,'2023-11-23 21:32:11pm','Home/index','198.54.130.140',''),(216,'2023-11-23 22:33:48pm','Home/index','192.175.111.254',''),(217,'2023-11-23 22:33:49pm','Home/index','70.38.10.149',''),(218,'2023-11-23 22:33:52pm','Home/index','70.38.10.153',''),(219,'2023-11-23 22:33:53pm','Home/index','70.38.10.156',''),(220,'2023-11-24 00:32:59am','Home/index','133.242.174.119',''),(221,'2023-11-24 02:02:32am','Home/index','3.109.157.113',''),(222,'2023-11-24 04:33:31am','Home/index','34.97.121.71',''),(223,'2023-11-24 04:33:35am','Home/index','205.169.39.192',''),(224,'2023-11-24 04:33:41am','Home/index','205.169.39.192',''),(225,'2023-11-24 09:24:58am','Home/index','159.203.27.194',''),(226,'2023-11-24 10:15:08am','Home/index','3.109.157.113',''),(227,'2023-11-26 08:32:39am','Home/index','139.162.8.154',''),(228,'2023-12-06 00:25:37am','Home/index','165.22.118.71',''),(229,'2023-12-06 12:21:37pm','Home/index','46.101.131.9',''),(230,'2023-12-08 06:43:49am','Home/index','54.229.22.231',''),(231,'2023-12-08 08:48:19am','Home/index','54.170.111.249',''),(232,'2023-12-19 19:25:27pm','Home/index','159.203.17.160',''),(233,'2024-01-02 13:48:22pm','Home/index','134.122.53.61',''),(234,'2024-01-09 11:18:07am','Home/index','18.202.30.2',''),(235,'2024-01-09 15:50:09pm','Home/index','198.235.24.151',''),(236,'2024-01-12 21:29:50pm','Home/index','205.210.31.166',''),(237,'2024-01-14 17:05:24pm','Home/index','205.210.31.133',''),(238,'2024-01-16 02:18:43am','Home/index','205.210.31.95',''),(239,'2024-01-16 16:55:49pm','Home/index','142.93.227.89',''),(240,'2024-01-17 19:14:57pm','Home/index','134.122.105.59',''),(241,'2024-01-19 19:36:16pm','Home/index','198.235.24.192',''),(242,'2024-01-21 18:26:08pm','Home/index','205.210.31.10',''),(243,'2024-01-23 10:19:55am','Home/index','176.123.7.11',''),(244,'2024-01-23 21:31:21pm','Home/index','164.92.192.25',''),(245,'2024-01-23 21:31:21pm','Home/index','164.92.192.25',''),(246,'2024-01-23 21:31:21pm','Home/index','164.92.192.25',''),(247,'2024-01-23 21:31:31pm','Home/index','195.211.77.140',''),(248,'2024-01-23 21:31:43pm','Home/index','195.211.77.142',''),(249,'2024-01-23 21:32:26pm','Home/index','164.90.184.41',''),(250,'2024-01-23 21:32:39pm','Home/index','164.90.184.41',''),(251,'2024-01-23 21:33:24pm','Home/index','205.169.39.64',''),(252,'2024-01-23 21:33:40pm','Home/index','205.169.39.64',''),(253,'2024-01-23 21:44:00pm','Home/index','65.154.226.169',''),(254,'2024-01-23 22:30:02pm','Home/index','5.164.29.116',''),(255,'2024-01-24 00:21:43am','Home/index','5.164.29.116',''),(256,'2024-01-24 00:31:45am','Home/index','133.242.174.119',''),(257,'2024-01-24 05:31:38am','Home/index','47.242.224.70',''),(258,'2024-01-24 07:11:21am','Home/index','180.251.233.59',''),(259,'2024-01-24 07:28:49am','Home/index','180.251.233.59',''),(260,'2024-01-24 07:37:42am','Home/index','180.251.233.59',''),(261,'2024-01-24 15:09:57pm','Home/index','47.242.224.70',''),(262,'2024-01-25 01:14:28am','Home/index','188.165.87.101',''),(263,'2024-01-25 03:18:56am','Home/index','51.254.49.107',''),(264,'2024-01-25 03:20:56am','Home/index','37.187.215.247',''),(265,'2024-01-25 09:21:03am','Home/index','64.227.40.174',''),(266,'2024-01-30 13:27:52pm','Home/index','137.184.50.184',''),(267,'2024-01-31 08:00:05am','Home/index','157.245.134.122',''),(268,'2024-01-31 18:09:04pm','Home/index','18.201.8.149',''),(269,'2024-02-03 10:48:52am','Home/index','154.159.252.243',''),(270,'2024-02-03 10:49:36am','About Us','154.159.252.243',''),(271,'2024-02-03 14:16:24pm','Home/index','154.159.252.243',''),(272,'2024-02-04 08:31:48am','Home/index','41.212.59.63',''),(273,'2024-02-05 07:45:07am','Home/index','34.245.170.80',''),(274,'2024-02-05 08:43:59am','Home/index','3.255.138.97',''),(275,'2024-02-13 07:34:20am','Home/index','159.89.168.238',''),(276,'2024-02-14 07:04:52am','Home/index','137.184.228.209',''),(277,'2024-02-24 06:05:23am','Home/index','44.242.154.128',''),(278,'2024-02-27 19:00:14pm','Home/index','157.230.100.222',''),(279,'2024-02-28 07:03:54am','Home/index','167.172.102.17',''),(280,'2024-03-15 02:19:35am','Home/index','35.88.2.114',''),(281,'2024-03-24 23:20:14pm','Home/index','205.169.39.252',''),(282,'2024-03-24 23:20:23pm','Home/index','205.169.39.252',''),(283,'2024-03-24 23:20:26pm','Home/index','207.241.236.83',''),(284,'2024-03-24 23:21:17pm','Home/index','195.211.77.142',''),(285,'2024-03-24 23:21:24pm','Home/index','146.70.133.4',''),(286,'2024-03-25 11:24:26am','Home/index','34.72.176.129',''),(287,'2024-04-03 17:18:24pm','Home/index','3.255.203.219',''),(288,'2024-04-04 01:51:19am','Home/index','3.255.176.197',''),(289,'2024-04-06 11:22:44am','Home/index','205.210.31.85',''),(290,'2024-04-08 11:05:40am','Home/index','198.235.24.164',''),(291,'2024-04-10 12:17:02pm','Home/index','35.86.218.255',''),(292,'2024-04-14 12:23:32pm','Home/index','35.94.92.166',''),(293,'2024-04-14 23:04:45pm','Home/index','65.154.226.171',''),(294,'2024-04-18 19:57:06pm','Home/index','35.212.252.98',''),(295,'2024-04-19 13:04:09pm','Home/index','95.217.18.177',''),(296,'2024-04-20 11:50:05am','Home/index','198.235.24.152',''),(297,'2024-04-23 23:22:53pm','Home/index','205.210.31.46',''),(298,'2024-04-26 04:54:12am','Home/index','205.210.31.96',''),(299,'2024-04-26 13:21:04pm','About Us','197.232.142.176',''),(300,'2024-04-26 13:22:39pm','Home/index','197.232.142.176',''),(301,'2024-04-26 13:22:52pm','About Us','197.232.142.176',''),(302,'2024-04-28 14:43:33pm','Home/index','205.210.31.159',''),(303,'2024-04-30 11:15:09am','Home/index','198.235.24.79',''),(304,'2024-05-03 00:58:19am','Home/index','3.255.190.19',''),(305,'2024-05-06 08:40:17am','Home/index','34.244.30.61',''),(306,'2024-05-06 15:08:11pm','Home/index','3.255.131.12',''),(307,'2024-05-11 11:34:41am','Home/index','35.94.165.129',''),(308,'2024-05-24 23:20:34pm','Home/index','138.199.34.132',''),(309,'2024-05-24 23:22:06pm','Home/index','65.154.226.171',''),(310,'2024-05-24 23:22:16pm','Home/index','205.169.39.229',''),(311,'2024-05-24 23:28:11pm','Home/index','207.241.236.84',''),(312,'2024-05-24 23:28:25pm','Home/index','207.241.236.84',''),(313,'2024-05-25 13:08:42pm','Home/index','103.102.228.27',''),(314,'2024-05-25 22:24:51pm','Home/index','188.165.87.96',''),(315,'2024-05-26 00:14:08am','Home/index','37.187.215.244',''),(316,'2024-05-26 01:57:28am','Home/index','51.254.49.103',''),(317,'2024-05-28 07:23:43am','Home/index','45.120.177.136',''),(318,'2024-05-31 18:54:06pm','Home/index','65.154.226.166',''),(319,'2024-05-31 21:02:03pm','Home/index','3.253.84.151',''),(320,'2024-06-04 09:01:36am','Home/index','138.197.164.219',''),(321,'2024-06-04 21:52:32pm','Home/index','18.203.135.145',''),(322,'2024-06-04 22:50:55pm','Home/index','3.255.171.10',''),(323,'2024-06-05 07:30:33am','Home/index','144.126.238.200',''),(324,'2024-06-13 08:33:24am','Home/index','34.223.41.164',''),(325,'2024-06-18 12:44:06pm','Home/index','165.227.174.232',''),(326,'2024-06-21 21:19:08pm','Home/index','185.81.128.21',''),(327,'2024-06-23 13:16:53pm','Home/index','159.223.186.148',''),(328,'2024-06-25 13:58:18pm','Home/index','167.71.22.166',''),(329,'2024-06-26 03:55:06am','Home/index','44.202.212.175',''),(330,'2024-06-26 03:55:11am','Home/index','44.202.212.175',''),(331,'2024-06-27 13:37:31pm','Home/index','138.197.160.8',''),(332,'2024-07-01 18:59:09pm','Home/index','3.249.83.43',''),(333,'2024-07-02 14:24:27pm','Home/index','64.227.147.108',''),(334,'2024-07-03 11:49:18am','Home/index','164.90.233.44',''),(335,'2024-07-04 19:37:50pm','Home/index','3.250.229.101',''),(336,'2024-07-04 22:05:09pm','Home/index','54.170.113.249',''),(337,'2024-07-07 09:41:20am','Home/index','69.171.230.113',''),(338,'2024-07-11 06:04:26am','Home/index','45.196.45.128',''),(339,'2024-07-11 19:20:38pm','About Us','173.252.83.27',''),(340,'2024-07-13 11:31:25am','Home/meeting','173.252.87.10',''),(341,'2024-07-13 12:40:20pm','About Us','173.252.107.17',''),(342,'2024-07-16 00:33:45am','Home/index','35.94.78.99',''),(343,'2024-07-16 05:08:40am','Home/index','138.197.130.186',''),(344,'2024-07-17 11:53:48am','Home/index','142.93.159.23',''),(345,'2024-07-18 02:40:58am','Home/index','69.171.249.115',''),(346,'2024-07-18 08:21:29am','About Us','69.171.249.115',''),(347,'2024-07-19 12:03:25pm','Home/index','40.77.167.235',''),(348,'2024-07-24 23:21:21pm','Home/index','95.217.18.177',''),(349,'2024-07-24 23:21:33pm','Home/index','207.241.236.83',''),(350,'2024-07-24 23:21:41pm','Home/index','205.169.39.140',''),(351,'2024-07-24 23:21:52pm','Home/index','205.169.39.140',''),(352,'2024-07-24 23:22:36pm','Home/index','179.43.169.181',''),(353,'2024-07-25 02:21:26am','Home/index','133.242.174.119',''),(354,'2024-07-25 03:25:17am','Home/index','104.197.69.115',''),(355,'2024-07-25 05:12:47am','Home/index','205.169.39.37',''),(356,'2024-07-25 09:09:09am','Home/index','174.138.61.30',''),(357,'2024-07-25 18:46:40pm','Home/index','47.242.224.70',''),(358,'2024-07-25 18:59:22pm','Home/index','171.244.43.14',''),(359,'2024-07-27 10:31:26am','Home/index','143.198.10.205',''),(360,'2024-07-29 09:48:57am','Home/index','164.90.136.47',''),(361,'2024-07-30 07:58:04am','Home/index','68.183.100.202',''),(362,'2024-07-31 08:20:16am','Home/index','64.227.157.77',''),(363,'2024-08-01 00:26:35am','Home/index','35.208.27.10',''),(364,'2024-08-01 00:26:37am','Home/meeting','35.208.27.10',''),(365,'2024-08-01 00:26:37am','About Us','35.208.27.10',''),(366,'2024-08-08 19:15:04pm','Home/index','34.253.179.211',''),(367,'2024-08-08 23:30:27pm','Home/index','18.201.227.34',''),(368,'2024-08-13 04:48:06am','Home/index','165.227.236.59',''),(369,'2024-08-14 06:36:38am','Home/index','167.99.153.69',''),(370,'2024-08-14 23:05:25pm','Home/index','205.169.39.23',''),(371,'2024-08-21 03:41:49am','Home/index','44.234.24.144',''),(372,'2024-08-22 19:25:19pm','About Us','52.167.144.168',''),(373,'2024-08-25 19:20:50pm','Home/meeting','52.167.144.204',''),(374,'2024-08-27 16:15:21pm','Home/index','188.166.92.31',''),(375,'2024-08-28 14:09:35pm','Home/index','167.71.139.70',''),(376,'2024-08-30 12:20:39pm','Home/index','64.227.151.119',''),(377,'2024-09-05 23:15:50pm','Home/index','52.210.211.196',''),(378,'2024-09-06 00:02:05am','Home/index','34.254.153.238',''),(379,'2024-09-10 07:50:18am','Home/index','157.230.225.104',''),(380,'2024-09-11 16:58:15pm','Home/index','167.71.59.42',''),(381,'2024-09-12 03:16:51am','Home/index','35.94.242.22',''),(382,'2024-09-18 02:13:08am','Home/index','146.148.62.217',''),(383,'2024-09-19 03:58:21am','Home/index','34.134.237.127',''),(384,'2024-09-20 11:52:14am','About Us','40.77.167.33',''),(385,'2024-09-23 09:22:14am','Home/index','159.65.148.92',''),(386,'2024-09-23 23:20:04pm','Home/index','104.197.69.115',''),(387,'2024-09-23 23:20:52pm','Home/index','154.28.222.201',''),(388,'2024-09-23 23:20:58pm','Home/index','205.169.39.67',''),(389,'2024-09-23 23:21:58pm','Home/index','205.169.39.67',''),(390,'2024-09-23 23:24:08pm','Home/index','88.99.26.177',''),(391,'2024-09-23 23:42:49pm','Home/index','146.70.166.251',''),(392,'2024-09-24 07:35:12am','Home/index','66.249.69.164',''),(393,'2024-09-24 07:35:28am','Home/index','66.249.69.163',''),(394,'2024-09-24 07:35:31am','Home/index','66.249.69.164',''),(395,'2024-09-24 08:30:16am','Home/index','159.89.45.162',''),(396,'2024-09-24 13:08:16pm','Home/index','205.169.39.6',''),(397,'2024-09-24 18:18:18pm','Home/index','154.28.222.7',''),(398,'2024-09-24 18:20:21pm','Home/index','154.28.222.71',''),(399,'2024-09-25 10:50:37am','Home/index','198.211.100.86',''),(400,'2024-09-25 11:10:56am','Home/index','154.28.222.7',''),(401,'2024-09-25 13:40:53pm','Home/index','104.236.103.154',''),(402,'2024-09-25 22:36:15pm','Home/index','104.152.52.72',''),(403,'2024-09-26 09:06:14am','Home/index','154.28.222.199',''),(404,'2024-09-27 09:09:40am','Home/index','18.230.222.252',''),(405,'2024-09-27 11:24:38am','Home/index','139.59.19.130',''),(406,'2024-09-28 13:12:50pm','Home/index','15.229.244.205',''),(407,'2024-09-29 01:56:38am','Home/index','205.169.39.19',''),(408,'2024-09-29 09:33:57am','Home/index','209.38.253.207',''),(409,'2024-09-29 21:12:36pm','Home/index','154.28.222.233',''),(410,'2024-10-01 06:07:26am','Home/index','154.28.222.9',''),(411,'2024-10-02 12:07:25pm','Home/index','154.28.222.56',''),(412,'2024-10-03 19:13:51pm','Home/index','18.231.132.95',''),(413,'2024-10-05 03:15:39am','Home/index','154.28.222.9',''),(414,'2024-10-05 18:39:07pm','Home/index','35.171.144.152',''),(415,'2024-10-05 18:39:08pm','Home/index','35.171.144.152',''),(416,'2024-10-06 01:56:32am','Home/index','198.235.24.171',''),(417,'2024-10-06 07:44:31am','Home/index','205.210.31.143',''),(418,'2024-10-06 17:13:22pm','Home/index','205.210.31.177',''),(419,'2024-10-07 05:13:03am','Home/index','154.28.222.167',''),(420,'2024-10-07 06:18:43am','Home/index','54.229.190.141',''),(421,'2024-10-07 09:30:29am','Home/index','3.249.83.237',''),(422,'2024-10-07 18:22:59pm','Home/index','3.255.76.240',''),(423,'2024-10-08 00:41:01am','Home/index','34.223.67.110',''),(424,'2024-10-08 16:07:02pm','Home/index','159.223.123.221',''),(425,'2024-10-09 00:21:14am','Home/index','15.228.38.135',''),(426,'2024-10-09 15:37:26pm','Home/index','157.245.47.94',''),(427,'2024-10-10 16:56:46pm','Home/index','104.248.204.195',''),(428,'2024-10-10 19:35:09pm','Home/index','154.28.222.150',''),(429,'2024-10-12 18:31:55pm','Home/index','154.28.222.152',''),(430,'2024-10-13 03:39:03am','Home/index','205.210.31.20',''),(431,'2024-10-13 14:30:06pm','Home/index','198.235.24.141',''),(432,'2024-10-13 16:09:56pm','Home/index','34.66.252.129',''),(433,'2024-10-14 12:07:12pm','Home/index','205.210.31.185',''),(434,'2024-10-14 23:39:17pm','Home/index','205.210.31.186',''),(435,'2024-10-15 00:49:29am','Home/index','38.45.66.147',''),(436,'2024-10-15 00:58:52am','Home/index','205.169.39.15',''),(437,'2024-10-17 10:27:31am','Home/index','35.211.10.21',''),(438,'2024-10-17 10:27:36am','Home/meeting','35.211.10.21',''),(439,'2024-10-17 10:27:37am','About Us','35.211.10.21',''),(440,'2024-10-18 18:03:00pm','Home/index','135.148.100.196',''),(441,'2024-10-22 04:48:02am','Home/index','138.197.150.14',''),(442,'2024-10-23 04:17:36am','Home/index','165.227.199.44',''),(443,'2024-10-28 08:57:06am','Home/index','195.211.77.142',''),(444,'2024-10-28 08:57:27am','Home/index','195.211.77.142',''),(445,'2024-11-01 10:16:25am','Home/index','115.231.78.2',''),(446,'2024-11-01 10:16:53am','Home/index','115.231.78.2',''),(447,'2024-11-04 10:41:19am','Home/index','205.210.31.33',''),(448,'2024-11-05 04:09:53am','Home/index','174.138.71.232',''),(449,'2024-11-06 10:33:08am','Home/index','24.199.104.208',''),(450,'2024-11-06 12:12:58pm','Home/index','34.254.19.40',''),(451,'2024-11-06 15:46:53pm','Home/index','34.245.64.127',''),(452,'2024-11-10 10:42:13am','Home/index','206.189.228.23',''),(453,'2024-11-12 09:50:05am','Home/index','209.38.255.173',''),(454,'2024-11-13 02:40:54am','Home/index','34.222.208.207',''),(455,'2024-11-16 22:44:15pm','Home/index','104.197.29.126',''),(456,'2024-11-17 16:28:04pm','Home/index','135.148.100.196',''),(457,'2024-11-19 06:35:36am','Home/index','144.126.237.201',''),(458,'2024-11-20 08:37:50am','Home/index','178.128.145.137',''),(459,'2024-11-23 23:19:05pm','Home/index','207.241.225.134',''),(460,'2024-11-23 23:19:05pm','Home/index','207.241.235.230',''),(461,'2024-11-23 23:19:32pm','Home/index','195.211.77.140',''),(462,'2024-11-23 23:19:42pm','Home/index','195.211.77.142',''),(463,'2024-11-23 23:20:08pm','Home/index','146.70.132.231',''),(464,'2024-11-23 23:21:16pm','Home/index','34.123.170.104',''),(465,'2024-11-23 23:21:18pm','Home/index','205.169.39.22',''),(466,'2024-11-23 23:21:26pm','Home/index','205.169.39.108',''),(467,'2024-11-23 23:21:36pm','Home/index','205.169.39.108',''),(468,'2024-11-23 23:21:51pm','Home/index','34.123.170.104',''),(469,'2024-11-24 02:35:01am','Home/index','133.242.174.119',''),(470,'2024-11-24 09:32:04am','Home/index','68.183.202.162',''),(471,'2024-11-24 11:30:38am','Home/index','171.244.43.14',''),(472,'2024-11-25 12:24:33pm','Home/index','104.152.52.63',''),(473,'2024-11-26 07:06:00am','Home/index','66.249.66.16',''),(474,'2024-11-26 09:50:50am','Home/index','198.199.67.185',''),(475,'2024-11-26 11:34:34am','Home/index','158.220.114.201',''),(476,'2024-11-26 11:34:52am','Home/index','158.220.114.201',''),(477,'2024-11-26 11:34:52am','Home/index','158.220.114.201',''),(478,'2024-11-26 11:34:52am','Home/index','158.220.114.201',''),(479,'2024-11-26 11:34:54am','Home/index','158.220.114.201',''),(480,'2024-11-26 11:34:58am','Home/index','158.220.114.201',''),(481,'2024-11-29 04:13:27am','Home/index','66.249.75.128',''),(482,'2024-12-01 12:55:17pm','Home/index','66.249.66.16',''),(483,'2024-12-01 14:30:22pm','Home/index','205.210.31.137',''),(484,'2024-12-02 23:02:58pm','Home/index','104.152.52.63',''),(485,'2024-12-03 00:23:46am','Home/index','45.139.104.148',''),(486,'2024-12-03 00:23:49am','Home/index','45.139.104.148',''),(487,'2024-12-03 00:23:51am','Home/index','45.139.104.148',''),(488,'2024-12-03 04:23:59am','Home/index','54.213.151.233',''),(489,'2024-12-03 05:12:26am','Home/index','206.189.50.153',''),(490,'2024-12-03 18:30:18pm','Home/index','66.249.66.16',''),(491,'2024-12-04 08:13:40am','Home/index','52.167.144.146',''),(492,'2024-12-04 09:54:46am','Home/index','152.42.128.135',''),(493,'2024-12-05 02:46:17am','Home/index','146.190.136.16',''),(494,'2024-12-06 11:46:37am','Home/index','34.245.74.229',''),(495,'2024-12-06 14:55:59pm','Home/index','54.194.178.95',''),(496,'2024-12-06 19:45:27pm','Home/index','66.249.64.44',''),(497,'2024-12-06 22:16:58pm','Home/index','66.249.64.226',''),(498,'2024-12-08 02:48:19am','Home/index','198.235.24.136',''),(499,'2024-12-09 21:42:22pm','Home/index','104.152.52.62',''),(500,'2024-12-10 19:20:01pm','Home/index','66.249.66.69',''),(501,'2024-12-11 02:01:24am','Home/index','66.249.66.15',''),(502,'2024-12-11 17:12:34pm','Home/index','158.220.114.201',''),(503,'2024-12-11 19:01:32pm','Home/meeting','57.141.0.2',''),(504,'2024-12-12 00:57:25am','Home/index','44.244.149.60',''),(505,'2024-12-13 15:15:25pm','Home/index','66.249.66.71',''),(506,'2024-12-13 18:45:25pm','Home/index','66.249.66.16',''),(507,'2024-12-13 21:11:47pm','About Us','57.141.0.30',''),(508,'2024-12-14 19:28:15pm','Home/index','57.141.0.23',''),(509,'2024-12-14 19:52:21pm','Home/index','57.141.0.12',''),(510,'2024-12-16 09:59:20am','Home/index','164.90.198.211',''),(511,'2024-12-16 23:42:42pm','Home/index','104.152.52.59',''),(512,'2024-12-17 10:02:57am','Home/index','174.138.0.161',''),(513,'2024-12-17 15:02:35pm','Home/index','51.81.46.212',''),(514,'2024-12-18 02:34:16am','Home/index','45.202.24.220',''),(515,'2024-12-18 09:33:20am','Home/index','157.245.214.38',''),(516,'2024-12-18 11:03:02am','Home/index','68.183.100.32',''),(517,'2024-12-19 21:53:39pm','Home/index','18.136.207.80',''),(518,'2024-12-21 11:52:24am','Home/index','66.249.66.70',''),(519,'2024-12-23 22:27:46pm','Home/index','104.152.52.69',''),(520,'2024-12-30 10:57:50am','Home/index','138.197.169.184',''),(521,'2024-12-31 02:11:37am','Home/index','104.152.52.61',''),(522,'2024-12-31 16:17:57pm','Home/index','159.65.193.149',''),(523,'2024-12-31 23:29:40pm','Home/index','173.252.107.10',''),(524,'2025-01-01 06:35:13am','Home/index','104.248.192.81',''),(525,'2025-01-01 09:11:03am','Home/index','185.247.137.17',''),(526,'2025-01-01 09:43:05am','Home/index','165.22.178.137',''),(527,'2025-01-01 18:09:22pm','Home/index','185.247.137.137',''),(528,'2025-01-05 16:12:27pm','Home/index','205.210.31.10',''),(529,'2025-01-05 21:46:32pm','Home/index','154.216.20.3',''),(530,'2025-01-06 06:03:06am','Home/index','198.235.24.144',''),(531,'2025-01-06 21:56:14pm','Home/index','18.201.22.144',''),(532,'2025-01-07 00:27:53am','Home/index','34.243.75.134',''),(533,'2025-01-07 01:57:21am','Home/index','104.152.52.57',''),(534,'2025-01-09 14:10:59pm','Home/index','162.142.125.192',''),(535,'2025-01-10 04:04:27am','Home/index','206.168.34.95',''),(536,'2025-01-10 04:35:53am','Home/index','206.168.34.78',''),(537,'2025-01-12 11:52:31am','Home/index','199.45.154.152',''),(538,'2025-01-12 13:55:13pm','Home/index','198.235.24.3',''),(539,'2025-01-13 10:20:58am','Home/index','157.230.49.99',''),(540,'2025-01-13 15:08:19pm','Home/index','66.249.72.172',''),(541,'2025-01-14 05:46:42am','Home/index','178.128.235.1',''),(542,'2025-01-15 01:30:01am','Home/index','35.94.209.213',''),(543,'2025-01-15 03:47:32am','Home/index','134.209.149.254',''),(544,'2025-01-15 10:29:39am','Home/index','197.232.142.176',''),(545,'2025-01-15 10:54:17am','Home/index','167.71.224.65',''),(546,'2025-01-16 12:38:47pm','Home/index','135.148.100.196',''),(547,'2025-01-18 09:44:05am','Home/index','47.89.193.239',''),(548,'2025-01-19 01:06:02am','Home/index','205.210.31.171',''),(549,'2025-01-19 01:36:25am','Home/index','66.249.66.70',''),(550,'2025-01-19 19:52:01pm','Home/index','198.235.24.43',''),(551,'2025-01-20 00:36:17am','Home/index','205.210.31.46',''),(552,'2025-01-20 05:13:50am','Home/index','205.210.31.15',''),(553,'2025-01-23 17:36:06pm','Home/index','66.249.66.69',''),(554,'2025-01-23 19:56:09pm','About Us','66.249.66.69',''),(555,'2025-01-23 19:56:14pm','Home/meeting','66.249.66.69',''),(556,'2025-01-23 19:56:15pm','About Us','66.249.66.69',''),(557,'2025-01-24 05:51:33am','Home/index','133.242.174.119',''),(558,'2025-01-24 12:06:27pm','Home/index','133.242.174.119',''),(559,'2025-01-24 20:31:11pm','Home/index','217.182.186.41',''),(560,'2025-01-24 20:34:15pm','Home/index','188.165.87.105',''),(561,'2025-01-24 23:23:30pm','Home/index','185.254.75.46',''),(562,'2025-01-25 04:59:27am','Home/index','206.168.34.39',''),(563,'2025-01-25 06:24:32am','Home/index','162.142.125.201',''),(564,'2025-01-25 10:54:04am','Home/index','138.197.140.151',''),(565,'2025-01-25 16:58:12pm','Home/index','104.152.52.65',''),(566,'2025-01-26 10:49:02am','Home/index','205.210.31.46',''),(567,'2025-01-26 12:07:24pm','Home/index','66.249.73.17',''),(568,'2025-01-26 12:37:57pm','About Us','66.249.73.17',''),(569,'2025-01-26 12:37:59pm','Home/meeting','66.249.73.17',''),(570,'2025-01-26 12:38:00pm','About Us','66.249.73.17',''),(571,'2025-01-26 16:46:30pm','Home/index','205.210.31.186',''),(572,'2025-01-27 10:47:39am','Home/index','64.23.179.32',''),(573,'2025-01-27 22:32:50pm','Home/index','157.245.201.195',''),(574,'2025-01-28 12:00:15pm','Home/index','134.209.187.120',''),(575,'2025-01-29 09:18:19am','Home/index','143.198.17.56',''),(576,'2025-01-29 09:54:22am','Home/index','159.203.57.13',''),(577,'2025-01-30 05:58:24am','Home/index','52.91.0.199',''),(578,'2025-02-02 02:00:12am','Home/index','104.152.52.70',''),(579,'2025-02-02 13:02:43pm','Home/index','205.210.31.151',''),(580,'2025-02-03 07:46:03am','Home/index','198.235.24.26',''),(581,'2025-02-03 19:34:32pm','Home/index','52.211.205.70',''),(582,'2025-02-04 00:37:10am','Home/index','3.249.231.93',''),(583,'2025-02-04 01:30:27am','Home/index','18.200.247.146',''),(584,'2025-02-04 11:38:50am','Home/index','67.205.167.210',''),(585,'2025-02-05 00:57:09am','Home/index','87.236.176.155',''),(586,'2025-02-05 01:04:28am','Home/index','185.247.137.232',''),(587,'2025-02-06 10:42:47am','Home/index','199.45.155.68',''),(588,'2025-02-07 12:57:20pm','Home/index','54.84.151.124',''),(589,'2025-02-08 05:18:20am','Home/index','198.235.24.6',''),(590,'2025-02-09 03:51:40am','Home/index','104.152.52.71',''),(591,'2025-02-09 09:50:03am','Home/index','205.210.31.40',''),(592,'2025-02-09 14:43:29pm','Home/index','205.210.31.57',''),(593,'2025-02-11 03:01:24am','Home/index','167.94.138.197',''),(594,'2025-02-11 03:49:46am','Home/index','167.94.145.107',''),(595,'2025-02-11 17:20:21pm','Home/index','206.189.15.163',''),(596,'2025-02-11 22:58:52pm','Home/index','35.94.247.124',''),(597,'2025-02-12 10:14:20am','Home/index','24.144.93.51',''),(598,'2025-02-13 10:45:36am','Home/index','35.171.144.152',''),(599,'2025-02-13 10:45:37am','Home/index','35.171.144.152',''),(600,'2025-02-14 12:39:44pm','Home/index','207.241.237.21',''),(601,'2025-02-15 08:51:30am','Home/index','51.81.46.212',''),(602,'2025-02-15 19:25:10pm','Home/index','207.241.225.114',''),(603,'2025-02-17 03:21:52am','Home/index','47.82.11.205',''),(604,'2025-02-17 05:21:49am','Home/meeting','47.82.9.105',''),(605,'2025-02-17 05:21:49am','About Us','47.82.11.194',''),(606,'2025-02-17 05:21:49am','Home/index','47.82.11.3',''),(607,'2025-02-17 05:21:49am','About Us','47.82.11.186',''),(608,'2025-02-17 14:14:29pm','Home/index','199.45.154.114',''),(609,'2025-02-18 10:19:05am','Home/index','34.147.28.155',''),(610,'2025-02-19 12:18:57pm','Home/index','124.236.100.56',''),(611,'2025-02-19 15:43:20pm','Home/index','124.236.100.56',''),(612,'2025-02-19 19:06:23pm','About Us','57.141.0.19',''),(613,'2025-02-21 08:31:39am','Home/index','60.191.60.99',''),(614,'2025-02-21 11:11:06am','Home/index','60.191.60.99',''),(615,'2025-02-25 22:40:57pm','Home/index','104.131.184.39',''),(616,'2025-02-26 16:00:46pm','Home/index','139.59.18.78',''),(617,'2025-02-28 16:01:12pm','About Us','57.141.0.2',''),(618,'2025-03-01 00:47:53am','Home/index','3.253.193.122',''),(619,'2025-03-01 09:31:38am','Home/index','206.168.34.71',''),(620,'2025-03-02 06:52:35am','Home/index','206.168.34.124',''),(621,'2025-03-04 05:18:28am','Home/index','192.175.111.232',''),(622,'2025-03-04 05:18:30am','Home/index','192.175.111.252',''),(623,'2025-03-04 05:18:34am','Home/index','64.15.129.122',''),(624,'2025-03-04 05:18:35am','Home/index','192.175.111.253',''),(625,'2025-03-05 20:52:26pm','Home/index','47.79.123.148',''),(626,'2025-03-06 09:10:36am','Home/index','47.82.11.94',''),(627,'2025-03-06 12:53:38pm','Home/index','54.154.212.220',''),(628,'2025-03-06 13:54:52pm','Home/index','54.74.47.239',''),(629,'2025-03-07 17:57:33pm','Home/index','47.82.11.135',''),(630,'2025-03-08 03:23:00am','Home/index','87.236.176.138',''),(631,'2025-03-08 06:36:23am','Home/index','87.236.176.51',''),(632,'2025-03-09 09:42:01am','Home/index','47.79.5.88',''),(633,'2025-03-09 09:42:30am','Home/index','47.82.10.219',''),(634,'2025-03-09 17:23:12pm','About Us','57.141.0.16',''),(635,'2025-03-09 20:58:43pm','Home/index','47.79.118.217',''),(636,'2025-03-10 10:45:37am','Home/index','47.82.11.39',''),(637,'2025-03-11 11:25:31am','Home/index','192.241.135.17',''),(638,'2025-03-12 00:26:08am','Home/index','47.82.9.45',''),(639,'2025-03-12 15:40:28pm','Home/index','134.122.43.50',''),(640,'2025-03-12 20:29:37pm','Home/index','47.82.9.8',''),(641,'2025-03-13 23:31:59pm','Home/index','44.244.149.40',''),(642,'2025-03-15 03:23:54am','Home/index','198.235.24.27',''),(643,'2025-03-16 12:55:06pm','Home/index','51.81.46.212',''),(644,'2025-03-16 13:47:44pm','Home/index','198.235.24.12',''),(645,'2025-03-16 16:03:57pm','About Us','57.141.0.22',''),(646,'2025-03-18 00:40:20am','Home/index','47.82.11.46',''),(647,'2025-03-20 10:26:13am','Home/index','34.90.235.227',''),(648,'2025-03-20 16:27:01pm','About Us','57.141.0.27',''),(649,'2025-03-23 02:16:08am','Home/index','198.235.24.135',''),(650,'2025-03-23 17:49:51pm','Home/index','205.210.31.21',''),(651,'2025-03-25 05:42:33am','Home/index','161.35.91.114',''),(652,'2025-03-25 23:20:13pm','Home/index','34.123.170.104',''),(653,'2025-03-25 23:20:22pm','Home/index','205.169.39.66',''),(654,'2025-03-25 23:20:22pm','Home/index','205.169.39.53',''),(655,'2025-03-25 23:21:03pm','Home/index','205.169.39.66',''),(656,'2025-03-26 04:17:17am','Home/index','195.211.77.140',''),(657,'2025-03-26 04:17:30am','Home/index','195.211.77.142',''),(658,'2025-03-26 05:16:09am','Home/index','104.248.17.211',''),(659,'2025-03-26 09:15:13am','Home/index','134.122.39.57',''),(660,'2025-03-26 16:55:53pm','Home/index','45.148.10.174',''),(661,'2025-03-26 17:41:37pm','Home/index','83.222.191.34',''),(662,'2025-03-26 18:56:55pm','Home/index','3.235.198.205',''),(663,'2025-03-27 07:55:26am','Home/index','103.214.20.60',''),(664,'2025-03-27 17:05:16pm','Home/index','104.152.52.70',''),(665,'2025-03-28 12:08:31pm','Home/index','45.148.10.174',''),(666,'2025-03-31 17:38:29pm','Home/index','98.80.216.32',''),(667,'2025-04-02 14:17:32pm','Home/index','98.80.216.32',''),(668,'2025-04-03 10:56:58am','Home/index','142.93.155.114',''),(669,'2025-04-05 08:22:36am','Home/index','205.210.31.134',''),(670,'2025-04-05 14:39:59pm','Home/index','159.89.190.97',''),(671,'2025-04-05 15:09:37pm','About Us','57.141.0.23',''),(672,'2025-04-06 22:23:20pm','Home/index','198.235.24.162',''),(673,'2025-04-07 09:08:23am','Home/index','198.235.24.151',''),(674,'2025-04-07 11:23:38am','Home/index','3.88.181.15',''),(675,'2025-04-07 11:23:40am','Home/index','3.88.181.15',''),(676,'2025-04-07 17:44:52pm','Home/index','34.247.174.160',''),(677,'2025-04-07 20:43:53pm','Home/index','18.201.62.174',''),(678,'2025-04-08 00:34:24am','Home/index','34.222.196.10',''),(679,'2025-04-08 09:37:04am','Home/index','24.199.117.197',''),(680,'2025-04-08 22:58:14pm','Home/index','3.92.127.193',''),(681,'2025-04-09 04:15:17am','Home/index','146.190.20.52',''),(682,'2025-04-12 10:08:11am','Home/index','66.249.64.42',''),(683,'2025-04-12 10:10:18am','Home/index','66.249.64.44',''),(684,'2025-04-12 11:45:31am','Home/index','66.249.64.44',''),(685,'2025-04-12 13:25:43pm','Home/index','66.249.64.43',''),(686,'2025-04-12 20:31:58pm','Home/meeting','66.249.64.43',''),(687,'2025-04-13 08:59:18am','About Us','66.249.64.42',''),(688,'2025-04-13 11:31:21am','Home/meeting','66.249.64.42',''),(689,'2025-04-13 14:54:00pm','About Us','66.249.66.71',''),(690,'2025-04-14 08:21:06am','Home/index','162.142.125.198',''),(691,'2025-04-14 18:02:28pm','Home/index','205.210.31.151',''),(692,'2025-04-14 18:18:23pm','Home/index','198.235.24.159',''),(693,'2025-04-14 21:56:18pm','Home/index','87.236.176.245',''),(694,'2025-04-15 01:51:49am','Home/index','87.236.176.73',''),(695,'2025-04-15 15:09:39pm','Home/index','51.81.46.212',''),(696,'2025-04-16 00:09:19am','Home/index','205.169.39.4',''),(697,'2025-04-22 05:58:42am','Home/index','46.101.137.59',''),(698,'2025-04-23 00:12:15am','About Us','57.141.0.25',''),(699,'2025-04-23 08:44:26am','Home/index','34.141.147.241',''),(700,'2025-04-23 10:20:02am','Home/index','104.236.226.76',''),(701,'2025-04-28 02:41:03am','Home/index','198.235.24.10',''),(702,'2025-05-02 18:05:36pm','Home/index','44.200.60.207',''),(703,'2025-05-03 13:45:43pm','Home/index','52.210.189.73',''),(704,'2025-05-03 23:01:20pm','Home/index','15.237.213.3',''),(705,'2025-05-04 06:04:47am','Home/index','115.231.78.6',''),(706,'2025-05-04 09:37:39am','Home/index','205.210.31.29',''),(707,'2025-05-04 13:01:52pm','Home/index','198.235.24.176',''),(708,'2025-05-05 06:24:43am','Home/index','13.38.46.147',''),(709,'2025-05-05 08:28:16am','Home/index','205.210.31.130',''),(710,'2025-05-06 06:32:52am','Home/index','161.35.196.38',''),(711,'2025-05-07 16:41:03pm','Home/index','64.227.73.191',''),(712,'2025-05-10 19:27:12pm','Home/index','176.98.186.47',''),(713,'2025-05-10 19:37:13pm','Home/index','205.210.31.6',''),(714,'2025-05-11 06:29:53am','Home/index','34.245.76.228',''),(715,'2025-05-11 09:14:55am','Home/index','54.194.211.111',''),(716,'2025-05-12 21:33:40pm','Home/index','35.94.160.1',''),(717,'2025-05-15 15:23:22pm','Home/index','51.81.46.212',''),(718,'2025-05-17 17:18:53pm','Home/index','87.236.176.249',''),(719,'2025-05-18 02:45:22am','Home/index','196.251.81.203',''),(720,'2025-05-18 07:02:57am','Home/index','185.247.137.233',''),(721,'2025-05-20 07:30:42am','Home/index','138.197.151.64',''),(722,'2025-05-21 04:16:41am','Home/index','134.122.61.7',''),(723,'2025-05-25 23:20:01pm','Home/index','195.211.77.140',''),(724,'2025-05-25 23:20:24pm','Home/index','195.211.77.142',''),(725,'2025-05-25 23:32:49pm','Home/index','146.70.185.32',''),(726,'2025-05-26 17:57:44pm','Home/index','91.231.89.36',''),(727,'2025-05-26 17:58:25pm','Home/index','91.196.152.54',''),(728,'2025-05-26 23:51:58pm','Home/index','170.62.100.137',''),(729,'2025-05-27 15:57:51pm','Home/index','104.152.52.154',''),(730,'2025-05-29 00:14:46am','Home/index','128.192.12.103',''),(731,'2025-05-29 01:03:29am','Home/index','195.211.77.140',''),(732,'2025-05-29 01:03:42am','Home/index','195.211.77.142',''),(733,'2025-05-30 16:46:17pm','Home/index','159.89.31.156',''),(734,'2025-05-30 18:24:39pm','Home/index','86.104.252.57',''),(735,'2025-05-30 20:51:15pm','Home/index','159.89.5.227',''),(736,'2025-05-31 04:00:51am','Home/index','46.101.117.8',''),(737,'2025-05-31 04:00:51am','Home/index','46.101.117.8',''),(738,'2025-05-31 04:00:52am','Home/index','46.101.117.8',''),(739,'2025-05-31 04:00:53am','Home/index','46.101.117.8',''),(740,'2025-05-31 04:00:53am','Home/index','46.101.117.8',''),(741,'2025-05-31 19:16:07pm','Home/index','34.170.184.88',''),(742,'2025-06-01 14:16:46pm','Home/index','63.33.203.174',''),(743,'2025-06-01 18:30:45pm','Home/index','198.235.24.146',''),(744,'2025-06-03 14:09:14pm','Home/index','143.110.240.184',''),(745,'2025-06-03 21:23:27pm','Home/index','104.152.52.142',''),(746,'2025-06-04 10:20:51am','Home/index','165.232.182.233',''),(747,'2025-06-07 00:57:36am','Home/index','198.235.24.138',''),(748,'2025-06-07 13:58:51pm','Home/index','3.249.164.117',''),(749,'2025-06-07 14:47:12pm','Home/index','54.229.168.252',''),(750,'2025-06-09 06:14:21am','Home/index','205.210.31.184',''),(751,'2025-06-11 04:19:38am','Home/index','35.95.52.21',''),(752,'2025-06-11 14:19:12pm','Home/index','18.116.47.251',''),(753,'2025-06-15 23:07:35pm','Home/index','205.169.39.55',''),(754,'2025-06-17 19:28:58pm','Home/index','178.62.9.223',''),(755,'2025-06-18 13:26:03pm','Home/index','47.82.62.45',''),(756,'2025-06-18 13:26:04pm','Home/index','47.82.62.45',''),(757,'2025-06-18 13:26:05pm','Home/index','47.82.62.45',''),(758,'2025-06-18 20:25:42pm','Home/index','64.227.190.46',''),(759,'2025-06-19 06:20:21am','Home/index','34.91.125.183',''),(760,'2025-06-24 05:52:26am','Home/index','121.29.178.38',''); /*!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','','','','2016-12-24','12345678','','','','201807311533002481201606151466003799Handheld-Point-of-Sale.jpg','','','','','2020-04-09','482','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:08:57