/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: robisear_greensavannah -- ------------------------------------------------------ -- 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 AUTO_INCREMENT=2 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 */; INSERT INTO `alerts` VALUES (1,'254741115574','2023-11-27 02:31:28pm','get to the office on time','active','1','1','2023-11-27','14:45','new','MASAI','single','nogroup'); /*!40000 ALTER TABLE `alerts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `allmeetings` -- DROP TABLE IF EXISTS `allmeetings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `allmeetings` ( `id` int(50) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL, `status` varchar(40) NOT NULL DEFAULT 'new', `comments` text NOT NULL, `dateposted` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `companyid` varchar(50) NOT NULL, `code` varchar(10) NOT NULL, `ip` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `allmeetings` -- LOCK TABLES `allmeetings` WRITE; /*!40000 ALTER TABLE `allmeetings` DISABLE KEYS */; INSERT INTO `allmeetings` VALUES (1,'Anonymous','new','ok','2021-07-28 02:40:26pm','','','','610K03','127.0.0.1'); /*!40000 ALTER TABLE `allmeetings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `announcement` -- DROP TABLE IF EXISTS `announcement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `announcement` ( `id` int(50) NOT NULL AUTO_INCREMENT, `title` text NOT NULL, `target` varchar(50) NOT NULL, `message` text NOT NULL, `dateposted` varchar(50) NOT NULL, `status` varchar(50) NOT NULL, `type` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `announcement` -- LOCK TABLES `announcement` WRITE; /*!40000 ALTER TABLE `announcement` DISABLE KEYS */; INSERT INTO `announcement` VALUES (1,'National Exam','Primary and Secondary','All rules must be athered to','6/11/2016','active','advert'),(2,'Opportunity','all','New jobs available','4/11/2016','active','announcement'); /*!40000 ALTER TABLE `announcement` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `attendance` -- DROP TABLE IF EXISTS `attendance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `attendance` ( `id` int(100) NOT NULL AUTO_INCREMENT, `idno` varchar(100) NOT NULL, `surname` varchar(100) NOT NULL, `date` varchar(100) NOT NULL, `timein` varchar(100) NOT NULL, `timeout` varchar(100) NOT NULL, `type` varchar(100) NOT NULL, `createddate` varchar(100) NOT NULL, `comment` text NOT NULL, `timediffrence` int(5) NOT NULL DEFAULT 0, `device` varchar(30) NOT NULL, `totaltime` varchar(50) DEFAULT NULL, `checkoutime` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance` -- LOCK TABLES `attendance` WRITE; /*!40000 ALTER TABLE `attendance` DISABLE KEYS */; INSERT INTO `attendance` VALUES (1,'66666','','2022-09-06 10:23:19','10:23:19am','','Check in','2022-09-06 10:23:30','66666',1,'',NULL,NULL); /*!40000 ALTER TABLE `attendance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `balance` -- DROP TABLE IF EXISTS `balance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `balance` ( `id` int(100) NOT NULL AUTO_INCREMENT, `idno` varchar(100) NOT NULL, `balance` decimal(10,2) NOT NULL, `createdate` varchar(100) NOT NULL, `userid` int(11) NOT NULL, `companyid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `balance` -- LOCK TABLES `balance` WRITE; /*!40000 ALTER TABLE `balance` DISABLE KEYS */; /*!40000 ALTER TABLE `balance` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category` -- DROP TABLE IF EXISTS `category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` text NOT NULL, `createdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `userid` varchar(50) NOT NULL, `updatedate` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, `checkin` varchar(20) DEFAULT NULL, `checkout` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB 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 */; /*!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(20) 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=51 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 (23,'SUGGESTION','No','2023-11-28 11:58:10','New','1','','1','No','2',0,'','','','9436270141701161890'),(24,'RECOMMENDATIONS','Serve faster','2023-11-28 11:58:30','New','1','','1','No','3',0,'','','','1106878731701161910'),(25,'COMPLAIN','Serve me fast','2023-11-28 12:02:15','Sent','1','','1','No','1',0,'','','','5529646531701162135'),(26,'TO CALL NEAREST WAITER','Call the nearesrlt waiter','2023-11-28 12:04:45','Sent','1','','1','No','4',0,'','','','5079070361701162285'),(27,'COMPLAIN','I appreciate the chance to share my feedback. On Wednesday, November 29th, I ordered a number of sausages. Unfortunately, the sausages had a foul smell, which was quite alarming. They also had the ‘gone bad’ taste. Please improve on this aspect. Thanks','2023-11-29 15:38:37','Sent','1','','1','No','1',0,'','','','8447690251701261517'),(28,'SUGGESTION','Wonderful ????','2023-11-30 21:56:32','Sent','1','','1','No','2',0,'','','','791983581701370592'),(29,'SUGGESTION','By 6pm no green vegetables n it is the time when most people are having dinner. If ypur clientele is big make sure u budget n accommodate all of us','2023-12-05 19:05:26','Sent','1','','1','No','2',0,'','','','1539967511701792326'),(30,'RECOMMENDATIONS','Your services are 10/10...','2023-12-21 20:50:16','Sent','1','','1','Yes','3',0,'','0792918789','Isaac ','7777209441703181016'),(31,'SUGGESTION','Affordable food,great potioning keep up the good work','2024-01-07 14:14:49','Sent','1','','1','No','2',0,'','','','8561633361704626089'),(32,'TO CALL NEAREST WAITER','Service ','2024-01-07 16:18:56','Sent','1','','1','No','4',0,'','','','290278701704633536'),(33,'TO CALL NEAREST WAITER','Outside','2024-01-07 16:19:10','Sent','1','','1','No','4',0,'','','','8121932391704633550'),(34,'RECOMMENDATIONS','Naomba mrejeshe uji. N8mekuja mara kadhaa nikitamani kupata angalau kopo moja lakini wapi?','2024-01-07 18:15:44','Sent','1','','1','No','3',0,'','','','3638866981704640544'),(35,'RECOMMENDATIONS','Good service.','2024-01-11 14:08:43','Sent','1','','1','No','3',0,'','','','5676401981704971323'),(36,'RECOMMENDATIONS','Good service.','2024-01-11 14:09:32','Sent','1','','1','No','3',0,'','','','8762333821704971372'),(37,'TO CALL NEAREST WAITER','Sausage and samosa ','2024-01-11 18:24:46','Sent','1','','1','Yes','4',0,'','0717210902','Enock Mambo','2186966791704986686'),(38,'COMPLAIN','Poooooooooooresst pilau served today ','2024-01-23 20:37:21','Sent','1','','1','Yes','1',0,'','0718613836','Kiplagat ','9831244811706031441'),(39,'COMPLAIN','I am a regular customer of Green Savannah. I am complaining particularly about poor service at your cafeteria, including delay service at lunch and supper hours. Today I came twice asking for beef and after waiting for atmost 30mins the waiter shows up saying no beef. At supper the same thing happens, it is so sad.','2024-01-23 20:38:49','Sent','1','','1','Yes','1',0,'','0794333256','Gideon Koros','4914493971706031529'),(40,'TO CALL NEAREST WAITER','Kuja asap','2024-01-25 22:11:32','Sent','1','','1','No','4',0,'','','','7800985761706209892'),(41,'TO CALL NEAREST WAITER','Fish needed','2024-01-31 13:42:40','Sent','1','','1','No','4',0,'','','','3462317531706697760'),(42,'COMPLAIN','Cold Mokimo, warm it before serving. Beef mixed with either kidney/liver. ','2024-02-25 16:20:29','Sent','1','','1','Yes','1',0,'','+254702643600','Bethwel Sunwa ','3253461551708867229'),(43,'TO CALL NEAREST WAITER','La','2024-03-14 18:41:54','Sent','1','','1','No','4',0,'','','','2176185111710430914'),(44,'TO CALL NEAREST WAITER','00','2024-03-14 18:43:55','Sent','1','','1','Yes','4',0,'','+254718854193','Frank','7711884631710431035'),(45,'TO CALL NEAREST WAITER','Joy','2024-04-21 16:56:25','Sent','1','','1','Yes','4',0,'','','','4912217071713707785'),(46,'COMPLAIN','I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter. ','2024-05-24 20:06:08','Sent','1','','1','Yes','1',0,'','0721 380701 ','Pauline ','248812041716570368'),(47,'COMPLAIN','I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter. ','2024-05-24 20:06:24','Sent','1','','1','Yes','1',0,'','0721 380701 ','Pauline ','1387437441716570384'),(48,'TO CALL NEAREST WAITER','Need attendance at the balcony wing.','2024-06-13 11:12:38','Sent','1','','1','No','4',0,'','','','3192421061718266358'),(49,'SUGGESTION','Try to reduce the price of rice and beef ????.','2024-07-10 20:15:29','Sent','1','','1','No','2',0,'','','','6542666861720631729'),(50,'SUGGESTION','Cake is pathetic. Dry and tastes like chewing gum. Consider finding a proper pastry chef. ','2025-04-29 12:59:31','Sent','1','','1','No','2',0,'','','','4386552861745920771'); /*!40000 ALTER TABLE `complain` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `complaindata` -- DROP TABLE IF EXISTS `complaindata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `complaindata` ( `id` int(30) NOT NULL AUTO_INCREMENT, `description` text NOT NULL, `date` varchar(50) NOT NULL, `taskid` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'newstock', `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `complaindata` -- LOCK TABLES `complaindata` WRITE; /*!40000 ALTER TABLE `complaindata` DISABLE KEYS */; /*!40000 ALTER TABLE `complaindata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `county` -- DROP TABLE IF EXISTS `county`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `county` ( `id` int(40) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` varchar(255) DEFAULT NULL, `provincecode` varchar(50) NOT NULL, `description` text NOT NULL, `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `county` -- LOCK TABLES `county` WRITE; /*!40000 ALTER TABLE `county` DISABLE KEYS */; INSERT INTO `county` VALUES (1,'1','Mombasa','2','Mombasa','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'2','Kwale','2','Kwale','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'3','Kilifi','2','Kilifi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'4','Tana River','2','Tana River','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'5','Lamu','2','Lamu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'6','Taita-Taveta','2','Taita-Taveta','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'7','Garissa','5','Garissa','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'8','Wajir','5','Wajir','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'9','Mandera','5','Mandera','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'10','Marsabit','3','Marsabit','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'11','Isiolo','3','Isiolo','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'12','Meru','3','Meru','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'13','Tharaka-Nithi','3','Tharaka-Nithi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'14','Embu','3','Embu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'15','Kitui','3','Kitui','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'16','Machakos','3','Machakos','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'17','Makueni','3','Makueni','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'18','Nyandarua','1','Nyandarua','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'19','Nyeri','1','Nyeri','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'20','Kirinyaga','1','Kirinyaga','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'21','Murang\'a','1','Murang\'a','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'22','Kiambu','1','Kiambu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'23','Turkana','7','Turkana','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'24','West Pokot','7','West Pokot','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'25','Samburu','7','Samburu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'26','Trans-Nzoia','7','Trans-Nzoia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'27','Uasin Gishu','7','Uasin Gishu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'28','Elgeyo-Marakwet','7','Elgeyo-Marakwet','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'29','Nandi','7','Nandi','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'30','Baringo','7','Baringo','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'31','Laikipia','7','Laikipia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(32,'32','Nakuru','7','Nakuru','0000-00-00 00:00:00','0000-00-00 00:00:00'),(33,'33','Narok','7','Narok','0000-00-00 00:00:00','0000-00-00 00:00:00'),(34,'34','Kajiado','7','Kajiado','0000-00-00 00:00:00','0000-00-00 00:00:00'),(35,'35','Kericho','7','Kericho','0000-00-00 00:00:00','0000-00-00 00:00:00'),(36,'36','Bomet','7','Bomet','0000-00-00 00:00:00','0000-00-00 00:00:00'),(37,'37','Kakamega','8','Kakamega','0000-00-00 00:00:00','0000-00-00 00:00:00'),(38,'38','Vihiga','8','Vihiga','0000-00-00 00:00:00','0000-00-00 00:00:00'),(39,'39','Bungoma','8','Bungoma','0000-00-00 00:00:00','0000-00-00 00:00:00'),(40,'40','Busia','8','Busia','0000-00-00 00:00:00','0000-00-00 00:00:00'),(41,'41','Siaya','6','Siaya','0000-00-00 00:00:00','0000-00-00 00:00:00'),(42,'42','Kisumu','6','Kisumu','0000-00-00 00:00:00','0000-00-00 00:00:00'),(43,'43','Homa Bay','6','Homa Bay','0000-00-00 00:00:00','0000-00-00 00:00:00'),(44,'44','Migori','6','Migori','0000-00-00 00:00:00','0000-00-00 00:00:00'),(45,'45','Kisii','6','Kisii','0000-00-00 00:00:00','0000-00-00 00:00:00'),(46,'46','Nyamira','6','Nyamira','0000-00-00 00:00:00','0000-00-00 00:00:00'),(47,'47','Nairobi','4','Nairobi','0000-00-00 00:00:00','0000-00-00 00:00:00'); /*!40000 ALTER TABLE `county` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `coursecodes` -- DROP TABLE IF EXISTS `coursecodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `coursecodes` ( `id` int(30) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `name` text NOT NULL, `createddate` varchar(30) NOT NULL, `addedby` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `coursecodes` -- LOCK TABLES `coursecodes` WRITE; /*!40000 ALTER TABLE `coursecodes` DISABLE KEYS */; /*!40000 ALTER TABLE `coursecodes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer` -- DROP TABLE IF EXISTS `customer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `customer` ( `id` int(11) NOT NULL AUTO_INCREMENT, `firstname` varchar(100) NOT NULL, `surname` varchar(50) NOT NULL, `username` varchar(100) NOT NULL, `email` varchar(50) NOT NULL, `phone` varchar(100) NOT NULL, `gender` varchar(50) NOT NULL, `county` varchar(50) NOT NULL, `createddate` varchar(50) NOT NULL, `password` varchar(30) NOT NULL, `province` varchar(50) NOT NULL, `dob` varchar(50) NOT NULL, `idno` varchar(50) NOT NULL, `photo` text NOT NULL, `box` varchar(50) NOT NULL, `code` varchar(50) NOT NULL, `town` varchar(50) NOT NULL, `country` varchar(50) NOT NULL, `updatedate` varchar(50) NOT NULL, `totalsms` varchar(40) NOT NULL DEFAULT '10', `apiaccount_id` varchar(30) NOT NULL DEFAULT '1', `recoverpassword` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT '1', `companyid` varchar(100) NOT NULL, `service` varchar(100) NOT NULL, `usertype` varchar(50) DEFAULT NULL, `smstype` int(10) NOT NULL DEFAULT 2, `refer` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idno` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer` -- LOCK TABLES `customer` WRITE; /*!40000 ALTER TABLE `customer` DISABLE KEYS */; INSERT INTO `customer` VALUES (1,'Bondeni','Bondeni Primary','','robisearch@gmail.com','','','','2016-12-24','12345678','','','','201807311533002481201606151466003799Handheld-Point-of-Sale.jpg','','','','','2020-04-09','500','1','n/a','1','1','','admin',2,''),(2,'Willis Ochieng','ROBERT','','robiseoarch@gmail.com','254718667391','','','2019-07-02 06:16:33','uuuuuuuu','','','','','','','','','','10','1','','1','1','Yes',NULL,2,'online'),(3,'Willis Ochieng','Ouma6','','journalreagan@gmail.com','2547899275648','','','2019-07-02 06:21:34','zzzzzzzz','','','','','','','MOLLYS','','','10','1','','1','1','Yes',NULL,2,'tv'); /*!40000 ALTER TABLE `customer` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `device` -- DROP TABLE IF EXISTS `device`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `device` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL, `description` text NOT NULL, `createdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `userid` varchar(50) NOT NULL, `updatedate` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `device` -- LOCK TABLES `device` WRITE; /*!40000 ALTER TABLE `device` DISABLE KEYS */; /*!40000 ALTER TABLE `device` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email` -- DROP TABLE IF EXISTS `email`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `email` ( `id` int(100) NOT NULL AUTO_INCREMENT, `contact` varchar(60) NOT NULL, `postedtime` varchar(40) NOT NULL, `message` text NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `userid` varchar(50) NOT NULL, `companyid` varchar(50) NOT NULL, `subject` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email` -- LOCK TABLES `email` WRITE; /*!40000 ALTER TABLE `email` DISABLE KEYS */; /*!40000 ALTER TABLE `email` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_accounts` -- DROP TABLE IF EXISTS `email_accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `email_accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(50) NOT NULL, `password` varchar(100) NOT NULL, `smtp_host` varchar(50) NOT NULL, `smtp_port` int(11) NOT NULL, `userid` int(11) NOT NULL, `companyid` int(11) NOT NULL, `name` varchar(255) NOT NULL, `server` int(11) NOT NULL, `createdate` varchar(30) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_accounts` -- LOCK TABLES `email_accounts` WRITE; /*!40000 ALTER TABLE `email_accounts` DISABLE KEYS */; INSERT INTO `email_accounts` VALUES (1,'marketing@mombasacontinental.com','Pass@123','mail.mombasacontinental.com',587,1,1,'ROBISEARCH LTD',0,''),(2,'support@robisearch.com','support!@##@!','ssl://mail.robisearch.com',587,1,1,'ROBISEARCH LTD/TASK MANAGER',3,'2020-10-06 12:25:53pm'),(3,'support@robisearch.com','support!@##@!','ssl://mail.robisearch.com',465,1,1,'support',3,'2020-10-07 05:06:08am'); /*!40000 ALTER TABLE `email_accounts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_configuration` -- DROP TABLE IF EXISTS `email_configuration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `email_configuration` ( `id` int(11) NOT NULL AUTO_INCREMENT, `server` varchar(15) NOT NULL, `smtp_host` varchar(50) NOT NULL, `smtp_port` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_configuration` -- LOCK TABLES `email_configuration` WRITE; /*!40000 ALTER TABLE `email_configuration` DISABLE KEYS */; INSERT INTO `email_configuration` VALUES (1,'Gmail','ssl://smtp.googlemail.com',465),(2,'Yahoo','ssl://smtp.mail.yahoo.com',465),(3,'Webmail','domain.com',587),(4,'Hotmail','smtp-mail.outlook.com',587); /*!40000 ALTER TABLE `email_configuration` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `events` ( `id` int(50) NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `fromdate` varchar(50) NOT NULL, `todate` varchar(50) NOT NULL, `host` varchar(100) NOT NULL, `participants` text NOT NULL, `location` varchar(100) NOT NULL, `status` varchar(40) NOT NULL DEFAULT 'new', `comments` text NOT NULL, `repeated` varchar(50) NOT NULL, `dateposted` varchar(100) NOT NULL, `userid` varchar(100) NOT NULL, `updatedat` varchar(100) NOT NULL, `companyid` varchar(50) NOT NULL, `sms` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'MEETING','2019-05-20','2019-05-24','Mr.Robert','ANN,SAMUEL,JOSHUA,JEZEBEL,WKE','JUJA','new','ALL SHOULD ATTEND IN SPECIFIED TIME','','2019-05-18 02:59:10pm','1','','1','Yes'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `expenses` ( `id` int(50) NOT NULL AUTO_INCREMENT, `type` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `amount` varchar(50) NOT NULL, `description` text NOT NULL, `dateposted` varchar(50) NOT NULL, `user` varchar(100) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `datespent` varchar(50) NOT NULL, `receiptno` varchar(100) NOT NULL, `idno` varchar(100) NOT NULL, `contact` varchar(100) NOT NULL, `controller` varchar(100) NOT NULL, `imgid` varchar(100) NOT NULL, `img_id` text NOT NULL, `plotno` varchar(50) NOT NULL, `houseno` varchar(50) NOT NULL, `companyid` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fingers` -- DROP TABLE IF EXISTS `fingers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `fingers` ( `id` int(30) NOT NULL AUTO_INCREMENT, `regno` varchar(200) NOT NULL, `fingername` varchar(50) NOT NULL, `regdate` varchar(100) NOT NULL, `template` text NOT NULL, `type` varchar(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fingers` -- LOCK TABLES `fingers` WRITE; /*!40000 ALTER TABLE `fingers` DISABLE KEYS */; /*!40000 ALTER TABLE `fingers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `grouping` -- DROP TABLE IF EXISTS `grouping`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `grouping` ( `id` int(50) NOT NULL AUTO_INCREMENT, `memberid` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `createdate` varchar(50) NOT NULL, `user` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `updatedat` varchar(50) NOT NULL, `categoryid` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grouping` -- LOCK TABLES `grouping` WRITE; /*!40000 ALTER TABLE `grouping` DISABLE KEYS */; /*!40000 ALTER TABLE `grouping` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `images` -- DROP TABLE IF EXISTS `images`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `images` ( `id` int(50) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `imageid` varchar(50) NOT NULL, `user` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `images` -- LOCK TABLES `images` WRITE; /*!40000 ALTER TABLE `images` DISABLE KEYS */; INSERT INTO `images` VALUES (1,'upload/430466_1459408027.12027543_10153697235844759_2342432607099399883_n.jpg','298',''),(2,'upload/120955_1459408674.1901129_10153697235929759_5008441071069083718_n.jpg','72',''); /*!40000 ALTER TABLE `images` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `likes` -- DROP TABLE IF EXISTS `likes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `likes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` varchar(20) NOT NULL, `ip` varchar(50) NOT NULL, `dateposted` varchar(10) NOT NULL, `code` varchar(10) NOT NULL, `postid` int(20) NOT NULL, `type` varchar(10) NOT NULL DEFAULT 'liked', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `likes` -- LOCK TABLES `likes` WRITE; /*!40000 ALTER TABLE `likes` DISABLE KEYS */; /*!40000 ALTER TABLE `likes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `loggs` -- DROP TABLE IF EXISTS `loggs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `loggs` ( `id` int(30) NOT NULL AUTO_INCREMENT, `type` varchar(30) NOT NULL, `userid` varchar(30) NOT NULL, `timein` varchar(50) NOT NULL, `timeout` varchar(50) NOT NULL, `browser` text NOT NULL, `ip` text NOT NULL, `action` varchar(30) DEFAULT 'loggedin', `companyid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 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','2023-11-27 11:13:04','','','154.79.15.201','loggedin',1),(2,'admin','1','2023-11-27 11:13:21','','','154.79.15.201','loggedin',1),(3,'admin','1','2023-11-27 11:14:00','','','154.79.15.201','loggedin',1),(4,'admin','1','2023-11-27 11:27:05','','','154.79.15.201','loggedin',1),(5,'admin','1','2023-11-27 11:28:37','','','154.79.15.201','loggedin',1),(6,'admin','1','2023-11-27 11:35:33','','','154.79.15.201','loggedin',1),(7,'admin','1','2023-11-27 11:37:34','','','197.232.142.176','loggedin',1),(8,'admin','1','2023-11-27 11:40:50','','','197.232.142.176','loggedin',1),(9,'admin','1','2023-11-27 11:46:45','','','197.232.142.176','loggedin',1),(10,'admin','1','2023-11-27 12:07:01','','','41.72.208.186','loggedin',1),(11,'admin','1','2023-11-27 12:44:17','','','197.232.142.176','loggedin',1),(12,'admin','1','2023-11-27 14:23:32','','','197.232.142.176','loggedin',1),(13,'admin','1','2023-11-27 14:27:08','','','197.232.142.176','loggedin',1),(14,'admin','1','2023-11-28 07:51:39','','','197.232.142.176','loggedin',1),(15,'admin','1','2023-11-28 08:31:33','','','154.152.156.107','loggedin',1),(16,'admin','1','2023-11-28 08:35:45','','','154.152.156.107','loggedin',1),(17,'admin','1','2023-11-28 08:36:43','','','154.152.156.107','loggedin',1),(18,'admin','1','2023-11-28 08:47:56','','','154.152.156.107','loggedin',1),(19,'admin','1','2023-11-28 11:46:52','','','197.179.210.3','loggedin',1),(20,'admin','1','2023-11-28 11:49:15','','','197.179.210.3','loggedin',1),(21,'admin','1','2023-11-28 11:56:20','','','197.179.210.3','loggedin',1),(22,'admin','1','2023-11-28 12:01:31','','','102.0.4.108','loggedin',1),(23,'admin','1','2023-11-28 12:14:34','','','102.0.4.108','loggedin',1),(24,'admin','1','2023-11-28 16:04:56','','','102.0.4.108','loggedin',1),(25,'admin','1','2023-11-28 16:22:32','','','102.0.4.108','loggedin',1),(26,'admin','1','2023-11-29 15:44:10','','','102.0.4.108','loggedin',1),(27,'admin','1','2023-11-29 15:44:40','','','102.0.4.108','loggedin',1),(28,'admin','1','2023-11-29 15:45:11','','','102.0.4.108','loggedin',1),(29,'admin','1','2023-11-29 15:47:12','','','102.0.4.108','loggedin',1),(30,'admin','1','2023-11-29 15:47:25','','','102.0.4.108','loggedin',1),(31,'admin','1','2023-11-29 15:47:50','','','102.0.4.108','loggedin',1),(32,'admin','1','2023-11-29 15:49:06','','','102.0.4.108','loggedin',1),(33,'admin','1','2023-11-29 15:50:04','','','102.0.4.108','loggedin',1),(34,'admin','1','2023-11-29 15:50:57','','','102.0.4.108','loggedin',1),(35,'admin','1','2023-11-29 15:51:48','','','102.0.4.108','loggedin',1),(36,'admin','1','2023-11-29 19:01:31','','','105.161.226.199','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=3 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 (1,'test','2023-01-23','2023-01-23','TEST01','new','TEST MEETING','2023-01-23 12:23:04pm','1','','1'),(2,'ICT ','2023-03-10','2023-03-10','TEST02','new','TEST ICT Meeting','2023-03-10 11:04:42am','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 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mpesa` -- LOCK TABLES `mpesa` WRITE; /*!40000 ALTER TABLE `mpesa` DISABLE KEYS */; /*!40000 ALTER TABLE `mpesa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nation` -- DROP TABLE IF EXISTS `nation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `nation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(2) NOT NULL DEFAULT '', `name` varchar(100) NOT NULL DEFAULT '', `description` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `nation` -- LOCK TABLES `nation` WRITE; /*!40000 ALTER TABLE `nation` DISABLE KEYS */; INSERT INTO `nation` VALUES (1,'KE','Kenya',''),(2,'CA','Canada',''),(3,'AF','Afghanistan',''),(4,'AL','Albania',''),(5,'DZ','Algeria',''),(6,'DS','American Samoa',''),(7,'AD','Andorra',''),(8,'AO','Angola',''),(9,'AI','Anguilla',''),(10,'AQ','Antarctica',''),(11,'AG','Antigua and/or Barbuda',''),(12,'AR','Argentina',''),(13,'AM','Armenia',''),(14,'AW','Aruba',''),(15,'AU','Australia',''),(16,'AT','Austria',''),(17,'AZ','Azerbaijan',''),(18,'BS','Bahamas',''),(19,'BH','Bahrain',''),(20,'BD','Bangladesh',''),(21,'BB','Barbados',''),(22,'BY','Belarus',''),(23,'BE','Belgium',''),(24,'BZ','Belize',''),(25,'BJ','Benin',''),(26,'BM','Bermuda',''),(27,'BT','Bhutan',''),(28,'BO','Bolivia',''),(29,'BA','Bosnia and Herzegovina',''),(30,'BW','Botswana',''),(31,'BV','Bouvet Island',''),(32,'BR','Brazil',''),(33,'IO','British lndian Ocean Territory',''),(34,'BN','Brunei Darussalam',''),(35,'BG','Bulgaria',''),(36,'BF','Burkina Faso',''),(37,'BI','Burundi',''),(38,'KH','Cambodia',''),(39,'CM','Cameroon',''),(40,'CV','Cape Verde',''),(41,'KY','Cayman Islands',''),(42,'CF','Central African Republic',''),(43,'TD','Chad',''),(44,'CL','Chile',''),(45,'CN','China',''),(46,'CX','Christmas Island',''),(47,'CC','Cocos (Keeling) Islands',''),(48,'CO','Colombia',''),(49,'KM','Comoros',''),(50,'CG','Congo',''),(51,'CK','Cook Islands',''),(52,'CR','Costa Rica',''),(53,'HR','Croatia (Hrvatska)',''),(54,'CU','Cuba',''),(55,'CY','Cyprus',''),(56,'CZ','Czech Republic',''),(57,'DK','Denmark',''),(58,'DJ','Djibouti',''),(59,'DM','Dominica',''),(60,'DO','Dominican Republic',''),(61,'TP','East Timor',''),(62,'EC','Ecuador',''),(63,'EG','Egypt',''),(64,'SV','El Salvador',''),(65,'GQ','Equatorial Guinea',''),(66,'ER','Eritrea',''),(67,'EE','Estonia',''),(68,'ET','Ethiopia',''),(69,'FK','Falkland Islands (Malvinas)',''),(70,'FO','Faroe Islands',''),(71,'FJ','Fiji',''),(72,'FI','Finland',''),(73,'FR','France',''),(74,'FX','France, Metropolitan',''),(75,'GF','French Guiana',''),(76,'PF','French Polynesia',''),(77,'TF','French Southern Territories',''),(78,'GA','Gabon',''),(79,'GM','Gambia',''),(80,'GE','Georgia',''),(81,'DE','Germany',''),(82,'GH','Ghana',''),(83,'GI','Gibraltar',''),(84,'GR','Greece',''),(85,'GL','Greenland',''),(86,'GD','Grenada',''),(87,'GP','Guadeloupe',''),(88,'GU','Guam',''),(89,'GT','Guatemala',''),(90,'GN','Guinea',''),(91,'GW','Guinea-Bissau',''),(92,'GY','Guyana',''),(93,'HT','Haiti',''),(94,'HM','Heard and Mc Donald Islands',''),(95,'HN','Honduras',''),(96,'HK','Hong Kong',''),(97,'HU','Hungary',''),(98,'IS','Iceland',''),(99,'IN','India',''),(100,'ID','Indonesia',''),(101,'IR','Iran (Islamic Republic of)',''),(102,'IQ','Iraq',''),(103,'IE','Ireland',''),(104,'IL','Israel',''),(105,'IT','Italy',''),(106,'CI','Ivory Coast',''),(107,'JM','Jamaica',''),(108,'JP','Japan',''),(109,'JO','Jordan',''),(110,'KZ','Kazakhstan',''),(111,'US','United States ',''),(112,'KI','Kiribati',''),(113,'KP','Korea, Democratic People\'s Republic of',''),(114,'KR','Korea, Republic of',''),(115,'XK','Kosovo',''),(116,'KW','Kuwait',''),(117,'KG','Kyrgyzstan',''),(118,'LA','Lao People\'s Democratic Republic',''),(119,'LV','Latvia',''),(120,'LB','Lebanon',''),(121,'LS','Lesotho',''),(122,'LR','Liberia',''),(123,'LY','Libyan Arab Jamahiriya',''),(124,'LI','Liechtenstein',''),(125,'LT','Lithuania',''),(126,'LU','Luxembourg',''),(127,'MO','Macau',''),(128,'MK','Macedonia',''),(129,'MG','Madagascar',''),(130,'MW','Malawi',''),(131,'MY','Malaysia',''),(132,'MV','Maldives',''),(133,'ML','Mali',''),(134,'MT','Malta',''),(135,'MH','Marshall Islands',''),(136,'MQ','Martinique',''),(137,'MR','Mauritania',''),(138,'MU','Mauritius',''),(139,'TY','Mayotte',''),(140,'MX','Mexico',''),(141,'FM','Micronesia, Federated States of',''),(142,'MD','Moldova, Republic of',''),(143,'MC','Monaco',''),(144,'MN','Mongolia',''),(145,'ME','Montenegro',''),(146,'MS','Montserrat',''),(147,'MA','Morocco',''),(148,'MZ','Mozambique',''),(149,'MM','Myanmar',''),(150,'NA','Namibia',''),(151,'NR','Nauru',''),(152,'NP','Nepal',''),(153,'NL','Netherlands',''),(154,'AN','Netherlands Antilles',''),(155,'NC','New Caledonia',''),(156,'NZ','New Zealand',''),(157,'NI','Nicaragua',''),(158,'NE','Niger',''),(159,'NG','Nigeria',''),(160,'NU','Niue',''),(161,'NF','Norfork Island',''),(162,'MP','Northern Mariana Islands',''),(163,'NO','Norway',''),(164,'OM','Oman',''),(165,'PK','Pakistan',''),(166,'PW','Palau',''),(167,'PA','Panama',''),(168,'PG','Papua New Guinea',''),(169,'PY','Paraguay',''),(170,'PE','Peru',''),(171,'PH','Philippines',''),(172,'PN','Pitcairn',''),(173,'PL','Poland',''),(174,'PT','Portugal',''),(175,'PR','Puerto Rico',''),(176,'QA','Qatar',''),(177,'RE','Reunion',''),(178,'RO','Romania',''),(179,'RU','Russian Federation',''),(180,'RW','Rwanda',''),(181,'KN','Saint Kitts and Nevis',''),(182,'LC','Saint Lucia',''),(183,'VC','Saint Vincent and the Grenadines',''),(184,'WS','Samoa',''),(185,'SM','San Marino',''),(186,'ST','Sao Tome and Principe',''),(187,'SA','Saudi Arabia',''),(188,'SN','Senegal',''),(189,'RS','Serbia',''),(190,'SC','Seychelles',''),(191,'SL','Sierra Leone',''),(192,'SG','Singapore',''),(193,'SK','Slovakia',''),(194,'SI','Slovenia',''),(195,'SB','Solomon Islands',''),(196,'SO','Somalia',''),(197,'ZA','South Africa',''),(198,'GS','South Georgia South Sandwich Islands',''),(199,'ES','Spain',''),(200,'LK','Sri Lanka',''),(201,'SH','St. Helena',''),(202,'PM','St. Pierre and Miquelon',''),(203,'SD','Sudan',''),(204,'SR','Suriname',''),(205,'SJ','Svalbarn and Jan Mayen Islands',''),(206,'SZ','Swaziland',''),(207,'SE','Sweden',''),(208,'CH','Switzerland',''),(209,'SY','Syrian Arab Republic',''),(210,'TW','Taiwan',''),(211,'TJ','Tajikistan',''),(212,'TZ','Tanzania, United Republic of',''),(213,'TH','Thailand',''),(214,'TG','Togo',''),(215,'TK','Tokelau',''),(216,'TO','Tonga',''),(217,'TT','Trinidad and Tobago',''),(218,'TN','Tunisia',''),(219,'TR','Turkey',''),(220,'TM','Turkmenistan',''),(221,'TC','Turks and Caicos Islands',''),(222,'TV','Tuvalu',''),(223,'UG','Uganda',''),(224,'UA','Ukraine',''),(225,'AE','United Arab Emirates',''),(226,'GB','United Kingdom',''),(227,'UM','United States minor outlying islands',''),(228,'UY','Uruguay',''),(229,'UZ','Uzbekistan',''),(230,'VU','Vanuatu',''),(231,'VA','Vatican City State',''),(232,'VE','Venezuela',''),(233,'VN','Vietnam',''),(234,'VG','Virigan Islands (British)',''),(235,'VI','Virgin Islands (U.S.)',''),(236,'WF','Wallis and Futuna Islands',''),(237,'EH','Western Sahara',''),(238,'YE','Yemen',''),(239,'YU','Yugoslavia',''),(240,'ZR','Zaire',''),(241,'ZM','Zambia',''),(242,'ZW','Zimbabwe',''),(243,'','ugali',' \r\n'); /*!40000 ALTER TABLE `nation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `people` -- DROP TABLE IF EXISTS `people`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `people` ( `id` int(100) NOT NULL AUTO_INCREMENT, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) DEFAULT NULL, `phone` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `address_1` varchar(255) NOT NULL, `gender` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `zip` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `comments` text NOT NULL, `image_id` varchar(100) DEFAULT NULL, `category` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `company` varchar(50) NOT NULL, `account` varchar(100) NOT NULL, `website` text NOT NULL, `idno` varchar(100) NOT NULL, `balance` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `createdate` varchar(50) NOT NULL, `updatedat` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, `title` varchar(30) NOT NULL, PRIMARY KEY (`id`), KEY `first_name` (`firstname`), KEY `last_name` (`lastname`), KEY `email` (`email`), KEY `phppos_people_ibfk_1` (`image_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `people` -- LOCK TABLES `people` WRITE; /*!40000 ALTER TABLE `people` DISABLE KEYS */; INSERT INTO `people` VALUES (1,'GIDEON SINGALO','66666','254718667391','','','','','','1 ','',NULL,'member','1','','','','66666','','1','2022-09-06 10:21:57am','','1','Professor'); /*!40000 ALTER TABLE `people` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `phones` -- DROP TABLE IF EXISTS `phones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `phones` ( `id` int(30) NOT NULL AUTO_INCREMENT, `code` varchar(50) NOT NULL, `phone` text NOT NULL, `createddate` varchar(30) NOT NULL, `addedby` varchar(30) NOT NULL, `description` text DEFAULT NULL, `name` 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 `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=5 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',9,'2023-11-28 08:36:01','active','1','','1','','0','','Percentage',NULL,'red','briefcase'),(2,' SUGGESTION',90,'2023-11-27 11:22:23','active','1','','1','','0','','Percentage',NULL,'blue','briefcase'),(3,'RECOMMENDATIONS',0,'2023-11-27 11:23:58','active','1','','1','','0','','Percentage',NULL,'green','cubes'),(4,'TO CALL NEAREST WAITER',0,'2023-11-27 11:23:11','active','1','','1','','0','','Percentage',NULL,'aqua','film'); /*!40000 ALTER TABLE `productcategory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `reasons` -- DROP TABLE IF EXISTS `reasons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `reasons` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `description` text NOT NULL, `createdate` varchar(50) NOT NULL, `status` varchar(50) NOT NULL DEFAULT 'active', `userid` varchar(50) NOT NULL, `updatedate` varchar(50) NOT NULL, `companyid` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reasons` -- LOCK TABLES `reasons` WRITE; /*!40000 ALTER TABLE `reasons` DISABLE KEYS */; INSERT INTO `reasons` VALUES (1,'Outing','your son has left the school','2022-09-06 10:23:02am','Check in','1','','1'); /*!40000 ALTER TABLE `reasons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `recharge` -- DROP TABLE IF EXISTS `recharge`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `recharge` ( `id` int(11) NOT NULL AUTO_INCREMENT, `amount` decimal(10,2) NOT NULL, `userid` int(20) NOT NULL, `companyid` int(5) NOT NULL, `dateposted` varchar(30) NOT NULL, `paymentstatus` varchar(10) NOT NULL, `branch` int(10) NOT NULL, `type` varchar(30) NOT NULL, `description` text NOT NULL, `balance` double(10,2) NOT NULL, `rate` decimal(10,2) NOT NULL, `balancebefore` decimal(10,2) NOT NULL, `units` decimal(10,2) NOT NULL, `code` varchar(50) NOT NULL, `phone` varchar(30) NOT NULL, `business` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=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 AUTO_INCREMENT=81 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sms` -- LOCK TABLES `sms` WRITE; /*!40000 ALTER TABLE `sms` DISABLE KEYS */; INSERT INTO `sms` VALUES (1,'254740107241','2023-11-27 11:33:30am','From Hennesis hotel SUGGESTION hi','active','1','1',0,0,'',0,'',''),(2,'254740107241','2023-11-27 11:35:11am','From Hennesis hotel SUGGESTION HI','active','1','1',0,0,'',0,'',''),(3,'254740107241','2023-11-27 11:37:35am','From Hennesis hotel RECOMMENDATIONS ADD MORE MILK','active','1','1',0,0,'',0,'',''),(4,'254740107241','2023-11-27 11:39:38am','From Hennesis hotel COMPLAIN to much salt','active','1','1',0,0,'',0,'',''),(5,'254719870196','2023-11-27 11:39:38am','From Hennesis hotel COMPLAIN to much salt','active','1','1',0,0,'',0,'',''),(6,'254740107241','2023-11-27 12:23:34pm','From Hennesis hotel SUGGESTION lets have a lighting for boardroom','active','1','1',0,0,'',0,'',''),(7,'254719870196','2023-11-27 12:23:34pm','From Hennesis hotel SUGGESTION lets have a lighting for boardroom','active','1','1',0,0,'',0,'',''),(8,'254740107241','2023-11-27 12:24:42pm','From Hennesis hotel COMPLAIN waiters are delaying','active','1','1',0,0,'',0,'',''),(9,'254719870196','2023-11-27 12:24:42pm','From Hennesis hotel COMPLAIN waiters are delaying','active','1','1',0,0,'',0,'',''),(10,'254740107241','2023-11-27 12:25:40pm','From Hennesis hotel TO CALL NEAREST WAITER waiter','active','1','1',0,0,'',0,'',''),(11,'254719870196','2023-11-27 12:25:40pm','From Hennesis hotel TO CALL NEAREST WAITER waiter','active','1','1',0,0,'',0,'',''),(12,'254740107241','2023-11-27 12:41:58pm','From Hennesis hotel SUGGESTION more security on parking area','active','1','1',0,0,'',0,'',''),(13,'254719870196','2023-11-27 12:41:58pm','From Hennesis hotel SUGGESTION more security on parking area','active','1','1',0,0,'',0,'',''),(15,'254740107241','2023-11-28 08:24:37am','From Hennesis hotel SUGGESTION improve on service','active','1','1',0,0,'',0,'',''),(16,'254719870196','2023-11-28 08:24:37am','From Hennesis hotel SUGGESTION improve on service','active','1','1',0,0,'',0,'',''),(17,'254700028482','2023-11-28 08:24:37am','From Hennesis hotel SUGGESTION improve on service','active','1','1',0,0,'',0,'',''),(18,'254740107241','2023-11-28 08:26:54am','From Hennesis hotel COMPLAIN THE FISH IS NOT WELL COOKED AND UGALI SMALL','active','1','1',0,0,'',0,'',''),(19,'254719870196','2023-11-28 08:26:54am','From Hennesis hotel COMPLAIN THE FISH IS NOT WELL COOKED AND UGALI SMALL','active','1','1',0,0,'',0,'',''),(20,'254700028482','2023-11-28 08:26:54am','From Hennesis hotel COMPLAIN THE FISH IS NOT WELL COOKED AND UGALI SMALL','active','1','1',0,0,'',0,'',''),(21,'254719870196','2023-11-28 08:48:41am','From Savannah Hotel\r\n COMPLAIN RICE IS NOT WELL COOKED','active','1','1',0,0,'',0,'',''),(22,'254719870196','2023-11-28 10:12:34am','From Green Savannah Hotel\r\n RECOMMENDATIONS Nice place to be','active','1','1',0,0,'',0,'',''),(23,'254794851382','2023-11-28 11:54:21am','From Green Savannah Hotel\r\n COMPLAIN Took too long to serve','active','1','1',0,0,'',0,'',''),(24,'254718935051','2023-11-28 11:54:21am','From Green Savannah Hotel\r\n COMPLAIN Took too long to serve','active','1','1',0,0,'',0,'',''),(25,'254794851382','2023-11-28 12:02:15pm','From Green Savannah Hotel\r\n COMPLAIN Serve me fast','active','1','1',0,0,'',0,'',''),(26,'254718935051','2023-11-28 12:02:15pm','From Green Savannah Hotel\r\n COMPLAIN Serve me fast','active','1','1',0,0,'',0,'',''),(27,'254794851382','2023-11-28 12:04:45pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Call the nearesrlt waiter','active','1','1',0,0,'',0,'',''),(28,'254718935051','2023-11-28 12:04:45pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Call the nearesrlt waiter','active','1','1',0,0,'',0,'',''),(29,'254746807289','2023-11-28 12:04:45pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Call the nearesrlt waiter','active','1','1',0,0,'',0,'',''),(30,'254741115574','2023-11-28 12:08:59pm','test','active','1','1',0,0,'',0,'',''),(31,'254794851382','2023-11-29 03:38:37pm','From Green Savannah Hotel\r\n COMPLAIN I appreciate the chance to share my feedback. On Wednesday, November 29th, I ordered a number of sausages. Unfortunately, the sausages had a foul smell, which was quite alarming. They also had the ‘gone bad’ taste. Please improve on this aspect. Thanks','active','1','1',0,0,'',0,'',''),(32,'254718935051','2023-11-29 03:38:37pm','From Green Savannah Hotel\r\n COMPLAIN I appreciate the chance to share my feedback. On Wednesday, November 29th, I ordered a number of sausages. Unfortunately, the sausages had a foul smell, which was quite alarming. They also had the ‘gone bad’ taste. Please improve on this aspect. Thanks','active','1','1',0,0,'',0,'',''),(33,'254746807289','2023-11-29 03:38:37pm','From Green Savannah Hotel\r\n COMPLAIN I appreciate the chance to share my feedback. On Wednesday, November 29th, I ordered a number of sausages. Unfortunately, the sausages had a foul smell, which was quite alarming. They also had the ‘gone bad’ taste. Please improve on this aspect. Thanks','active','1','1',0,0,'',0,'',''),(34,'254741115574','2023-11-29 03:38:37pm','From Green Savannah Hotel\r\n COMPLAIN I appreciate the chance to share my feedback. On Wednesday, November 29th, I ordered a number of sausages. Unfortunately, the sausages had a foul smell, which was quite alarming. They also had the ‘gone bad’ taste. Please improve on this aspect. Thanks','active','1','1',0,0,'',0,'',''),(35,'254794851382','2023-11-30 09:56:32pm','From Green Savannah Hotel\r\n SUGGESTION Wonderful ????','active','1','1',0,0,'',0,'',''),(36,'254718935051','2023-11-30 09:56:32pm','From Green Savannah Hotel\r\n SUGGESTION Wonderful ????','active','1','1',0,0,'',0,'',''),(37,'254794851382','2023-12-05 07:05:26pm','From Green Savannah Hotel\r\n SUGGESTION By 6pm no green vegetables n it is the time when most people are having dinner. If ypur clientele is big make sure u budget n accommodate all of us','active','1','1',0,0,'',0,'',''),(38,'254718935051','2023-12-05 07:05:26pm','From Green Savannah Hotel\r\n SUGGESTION By 6pm no green vegetables n it is the time when most people are having dinner. If ypur clientele is big make sure u budget n accommodate all of us','active','1','1',0,0,'',0,'',''),(39,'254794851382','2023-12-21 08:50:16pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Your services are 10/10...','active','1','1',0,0,'',0,'',''),(40,'254718935051','2023-12-21 08:50:16pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Your services are 10/10...','active','1','1',0,0,'',0,'',''),(41,'254794851382','2024-01-07 02:14:49pm','From Green Savannah Hotel\r\n SUGGESTION Affordable food,great potioning keep up the good work','active','1','1',0,0,'',0,'',''),(42,'254718935051','2024-01-07 02:14:49pm','From Green Savannah Hotel\r\n SUGGESTION Affordable food,great potioning keep up the good work','active','1','1',0,0,'',0,'',''),(43,'254794851382','2024-01-07 04:18:56pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Service','active','1','1',0,0,'',0,'',''),(44,'254718935051','2024-01-07 04:18:56pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Service','active','1','1',0,0,'',0,'',''),(45,'254794851382','2024-01-07 04:19:10pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Outside','active','1','1',0,0,'',0,'',''),(46,'254718935051','2024-01-07 04:19:10pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Outside','active','1','1',0,0,'',0,'',''),(47,'254794851382','2024-01-07 06:15:44pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Naomba mrejeshe uji. N8mekuja mara kadhaa nikitamani kupata angalau kopo moja lakini wapi?','active','1','1',0,0,'',0,'',''),(48,'254718935051','2024-01-07 06:15:44pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Naomba mrejeshe uji. N8mekuja mara kadhaa nikitamani kupata angalau kopo moja lakini wapi?','active','1','1',0,0,'',0,'',''),(49,'254794851382','2024-01-11 02:08:43pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Good service.','active','1','1',0,0,'',0,'',''),(50,'254718935051','2024-01-11 02:08:43pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Good service.','active','1','1',0,0,'',0,'',''),(51,'254794851382','2024-01-11 02:09:32pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Good service.','active','1','1',0,0,'',0,'',''),(52,'254718935051','2024-01-11 02:09:32pm','From Green Savannah Hotel\r\n RECOMMENDATIONS Good service.','active','1','1',0,0,'',0,'',''),(53,'254794851382','2024-01-11 06:24:46pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Sausage and samosa','active','1','1',0,0,'',0,'',''),(54,'254718935051','2024-01-11 06:24:46pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Sausage and samosa','active','1','1',0,0,'',0,'',''),(55,'254794851382','2024-01-23 08:37:21pm','From Green Savannah Hotel\r\n COMPLAIN Poooooooooooresst pilau served today','active','1','1',0,0,'',0,'',''),(56,'254718935051','2024-01-23 08:37:21pm','From Green Savannah Hotel\r\n COMPLAIN Poooooooooooresst pilau served today','active','1','1',0,0,'',0,'',''),(57,'254794851382','2024-01-23 08:38:49pm','From Green Savannah Hotel\r\n COMPLAIN I am a regular customer of Green Savannah. I am complaining particularly about poor service at your cafeteria, including delay service at lunch and supper hours. Today I came twice asking for beef and after waiting for atmost 30mins the waiter shows up saying no beef. At supper the same thing happens, it is so sad.','active','1','1',0,0,'',0,'',''),(58,'254718935051','2024-01-23 08:38:49pm','From Green Savannah Hotel\r\n COMPLAIN I am a regular customer of Green Savannah. I am complaining particularly about poor service at your cafeteria, including delay service at lunch and supper hours. Today I came twice asking for beef and after waiting for atmost 30mins the waiter shows up saying no beef. At supper the same thing happens, it is so sad.','active','1','1',0,0,'',0,'',''),(59,'254794851382','2024-01-25 10:11:32pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Kuja asap','active','1','1',0,0,'',0,'',''),(60,'254718935051','2024-01-25 10:11:32pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Kuja asap','active','1','1',0,0,'',0,'',''),(61,'254794851382','2024-01-31 01:42:40pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Fish needed','active','1','1',0,0,'',0,'',''),(62,'254718935051','2024-01-31 01:42:40pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Fish needed','active','1','1',0,0,'',0,'',''),(63,'254794851382','2024-02-25 04:20:29pm','From Green Savannah Hotel\r\n COMPLAIN Cold Mokimo, warm it before serving. Beef mixed with either kidney/liver.','active','1','1',0,0,'',0,'',''),(64,'254718935051','2024-02-25 04:20:29pm','From Green Savannah Hotel\r\n COMPLAIN Cold Mokimo, warm it before serving. Beef mixed with either kidney/liver.','active','1','1',0,0,'',0,'',''),(65,'254794851382','2024-03-14 06:41:54pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER La','active','1','1',0,0,'',0,'',''),(66,'254718935051','2024-03-14 06:41:54pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER La','active','1','1',0,0,'',0,'',''),(67,'254794851382','2024-03-14 06:43:55pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER 00','active','1','1',0,0,'',0,'',''),(68,'254718935051','2024-03-14 06:43:55pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER 00','active','1','1',0,0,'',0,'',''),(69,'254794851382','2024-04-21 04:56:25pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Joy','active','1','1',0,0,'',0,'',''),(70,'254718935051','2024-04-21 04:56:25pm','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Joy','active','1','1',0,0,'',0,'',''),(71,'254794851382','2024-05-24 08:06:08pm','From Green Savannah Hotel\r\n COMPLAIN I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter.','active','1','1',0,0,'',0,'',''),(72,'254718935051','2024-05-24 08:06:08pm','From Green Savannah Hotel\r\n COMPLAIN I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter.','active','1','1',0,0,'',0,'',''),(73,'254794851382','2024-05-24 08:06:24pm','From Green Savannah Hotel\r\n COMPLAIN I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter.','active','1','1',0,0,'',0,'',''),(74,'254718935051','2024-05-24 08:06:24pm','From Green Savannah Hotel\r\n COMPLAIN I have witnessed harassment of a waitress by one of your kitchen staff. We ordered tea and mandazi, but the kitchen staff took long to warm the mandazi, when the waitress brought it, we had finished taking the tea. The mandazi had to be taken back to the kitchen where the kitchen staff told the waitress to pay for the mandazi while the mistake was his. He took long to warm the mandazi. That bullying/harassment is not right. To an extent that the waitress was crying!! Check into this matter.','active','1','1',0,0,'',0,'',''),(75,'254794851382','2024-06-13 11:12:38am','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Need attendance at the balcony wing.','active','1','1',0,0,'',0,'',''),(76,'254718935051','2024-06-13 11:12:38am','From Green Savannah Hotel\r\n TO CALL NEAREST WAITER Need attendance at the balcony wing.','active','1','1',0,0,'',0,'',''),(77,'254794851382','2024-07-10 08:15:29pm','From Green Savannah Hotel\r\n SUGGESTION Try to reduce the price of rice and beef ????.','active','1','1',0,0,'',0,'',''),(78,'254718935051','2024-07-10 08:15:29pm','From Green Savannah Hotel\r\n SUGGESTION Try to reduce the price of rice and beef ????.','active','1','1',0,0,'',0,'',''),(79,'254794851382','2025-04-29 12:59:31pm','From Green Savannah Hotel\r\n SUGGESTION Cake is pathetic. Dry and tastes like chewing gum. Consider finding a proper pastry chef.','active','1','1',0,0,'',0,'',''),(80,'254718935051','2025-04-29 12:59:31pm','From Green Savannah Hotel\r\n SUGGESTION Cake is pathetic. Dry and tastes like chewing gum. Consider finding a proper pastry chef.','active','1','1',0,0,'',0,'',''); /*!40000 ALTER TABLE `sms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `smsconfig` -- DROP TABLE IF EXISTS `smsconfig`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `smsconfig` ( `id` int(20) NOT NULL AUTO_INCREMENT, `username` text NOT NULL, `apikey` text NOT NULL, `from` varchar(50) NOT NULL, `link` text NOT NULL, `businessname` varchar(100) NOT NULL, `contact` varchar(100) NOT NULL, `location` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `code` varchar(18) NOT NULL, `description` text NOT NULL, `contactperson` varchar(100) NOT NULL, `password` varchar(50) NOT NULL, `group` int(50) NOT NULL DEFAULT 1, `contact2` varchar(50) NOT NULL, `address` text NOT NULL, `currencysymbol` varchar(50) NOT NULL, `tax1` varchar(50) NOT NULL, `tax1rate` varchar(50) NOT NULL, `tax2` varchar(50) NOT NULL, `tax2rate` varchar(50) NOT NULL, `website` varchar(50) NOT NULL, `returnpolicy` varchar(50) NOT NULL, `logo` varchar(50) NOT NULL, `paymenttypes` text NOT NULL, `country` varchar(50) NOT NULL, `totalsms` varchar(50) NOT NULL, `userid` varchar(50) NOT NULL, `updatedat` varchar(50) NOT NULL, `startdate` varchar(30) NOT NULL, `renewdate` varchar(30) NOT NULL, `businesskey` text NOT NULL, `deadlinedetails` text NOT NULL, `deadline` text NOT NULL, `api` int(11) NOT NULL DEFAULT 2, `stop` int(11) NOT NULL, `path` text NOT NULL, `dublicate` varchar(5) NOT NULL DEFAULT 'no', `smscompany` varchar(20) NOT NULL, `newuser` varchar(30) NOT NULL, `newpassword` text NOT NULL, `senderid` varchar(15) NOT NULL, `menutype` varchar(30) NOT NULL DEFAULT 'Left', `contacts` text NOT NULL, `automaticsms` varchar(20) DEFAULT 'yes', `sender` int(11) NOT NULL DEFAULT 1, `defualtmessage` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `code` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=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','SMSCHAPCHAP','','GREEN SAVANNAH','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.','5017639','','','','','','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 ','','1','2023-11-29 07:06:04pm','2019-03-28','2020-12-31','ZQRCtkGAZgh+pra1tV+B+nh51KKqImJCkxd3COh6EhLLL+YOcg3mEGQgKPAHpaj7iCEdpIa4N6pvUKFv7La9tQ==','','GEJDyW7zJF/a7pC+wu7SRiI12wciM2mALpyu5jbmhbRVoysqEPZrXkjYz+FL4cvgcn6gTNZ3IQlKT/mB9ohMGw==',2,0,'D:\\\\xampp\\\\htdocs\\\\ATT2000.mdb','yes','Advanta','ROBISEARCH','Robisearch@2018','SMSCHAPCHAP','Left','254794851382,254718935051','yes',1,'From Green Savannah Hotel\r\n'); /*!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=1106 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,'2023-11-27 11:08:34am','About Us','154.79.15.201',''),(2,'2023-11-27 11:11:28am','Home/index','154.79.15.201',''),(3,'2023-11-27 11:12:28am','About Us','154.79.15.201',''),(4,'2023-11-27 11:12:31am','Home/index','154.79.15.201',''),(5,'2023-11-27 11:12:56am','Home/index','154.79.15.201',''),(6,'2023-11-27 11:13:23am','Home/index','154.79.15.201',''),(7,'2023-11-27 11:13:52am','Home/index','154.79.15.201',''),(8,'2023-11-27 11:18:42am','About Us','154.79.15.201',''),(9,'2023-11-27 11:18:45am','About Us','154.79.15.201',''),(10,'2023-11-27 11:26:53am','Home/index','154.79.15.201',''),(11,'2023-11-27 11:28:18am','Home/index','154.79.15.201',''),(12,'2023-11-27 11:32:43am','Home/index','154.79.15.201',''),(13,'2023-11-27 11:32:59am','About Us','154.79.15.201',''),(14,'2023-11-27 11:32:59am','About Us','154.79.15.201',''),(15,'2023-11-27 11:33:05am','About Us','154.79.15.201',''),(16,'2023-11-27 11:34:50am','About Us','197.232.142.176',''),(17,'2023-11-27 11:34:56am','Home/index','154.79.15.201',''),(18,'2023-11-27 11:35:00am','About Us','154.79.15.201',''),(19,'2023-11-27 11:35:19am','Home/index','154.79.15.201',''),(20,'2023-11-27 11:35:38am','Home/index','197.232.142.176',''),(21,'2023-11-27 11:37:07am','Home/index','154.79.15.201',''),(22,'2023-11-27 11:37:15am','About Us','154.79.15.201',''),(23,'2023-11-27 11:37:15am','About Us','154.79.15.201',''),(24,'2023-11-27 11:37:51am','Home/index','154.79.15.201',''),(25,'2023-11-27 11:38:55am','Home/index','154.79.15.201',''),(26,'2023-11-27 11:39:06am','Home/index','154.79.15.201',''),(27,'2023-11-27 11:39:13am','Home/index','154.79.15.201',''),(28,'2023-11-27 11:39:17am','About Us','154.79.15.201',''),(29,'2023-11-27 11:39:53am','About Us','154.79.15.201',''),(30,'2023-11-27 11:40:20am','Home/index','197.232.142.176',''),(31,'2023-11-27 11:41:53am','About Us','154.79.15.201',''),(32,'2023-11-27 11:43:12am','Home/index','154.79.15.201',''),(33,'2023-11-27 11:43:17am','About Us','154.79.15.201',''),(34,'2023-11-27 11:43:48am','Home/index','154.79.15.201',''),(35,'2023-11-27 11:43:51am','About Us','154.79.15.201',''),(36,'2023-11-27 11:43:55am','About Us','154.79.15.201',''),(37,'2023-11-27 11:44:35am','Home/index','154.79.15.201',''),(38,'2023-11-27 11:44:58am','Home/index','197.232.142.176',''),(39,'2023-11-27 11:46:24am','Home/index','154.79.15.201',''),(40,'2023-11-27 11:46:44am','About Us','154.79.15.201',''),(41,'2023-11-27 11:47:22am','About Us','197.232.142.176',''),(42,'2023-11-27 11:47:23am','About Us','154.79.15.201',''),(43,'2023-11-27 11:47:29am','About Us','197.232.142.176',''),(44,'2023-11-27 11:47:33am','Home/index','154.79.15.201',''),(45,'2023-11-27 11:48:00am','About Us','197.232.142.176',''),(46,'2023-11-27 11:48:06am','About Us','197.232.142.176',''),(47,'2023-11-27 11:48:22am','About Us','197.232.142.176',''),(48,'2023-11-27 11:49:04am','About Us','197.232.142.176',''),(49,'2023-11-27 11:49:08am','About Us','154.79.15.201',''),(50,'2023-11-27 11:50:27am','Home/index','154.79.15.201',''),(51,'2023-11-27 11:51:43am','Home/index','154.79.15.201',''),(52,'2023-11-27 11:55:47am','Home/index','105.161.173.180',''),(53,'2023-11-27 12:01:13pm','About Us','105.161.173.180',''),(54,'2023-11-27 12:01:22pm','About Us','105.161.173.180',''),(55,'2023-11-27 12:01:29pm','Home/index','105.161.173.180',''),(56,'2023-11-27 12:04:25pm','Home/index','105.161.173.180',''),(57,'2023-11-27 12:05:23pm','Home/index','105.161.173.180',''),(58,'2023-11-27 12:07:27pm','Home/index','34.254.53.125',''),(59,'2023-11-27 12:07:27pm','Home/index','34.254.53.125',''),(60,'2023-11-27 12:07:29pm','Home/index','34.254.53.125',''),(61,'2023-11-27 12:08:18pm','Home/index','133.242.174.119',''),(62,'2023-11-27 12:13:58pm','Home/index','41.72.208.186',''),(63,'2023-11-27 12:14:03pm','About Us','41.72.208.186',''),(64,'2023-11-27 12:21:48pm','About Us','41.72.208.186',''),(65,'2023-11-27 12:21:48pm','About Us','41.72.208.186',''),(66,'2023-11-27 12:22:20pm','About Us','41.72.208.186',''),(67,'2023-11-27 12:31:06pm','About Us','41.72.208.186',''),(68,'2023-11-27 12:37:32pm','About Us','41.72.208.186',''),(69,'2023-11-27 12:37:40pm','Home/index','41.72.208.186',''),(70,'2023-11-27 12:37:40pm','Home/index','41.72.208.186',''),(71,'2023-11-27 12:41:07pm','Home/index','41.72.208.186',''),(72,'2023-11-27 12:43:23pm','About Us','41.72.208.186',''),(73,'2023-11-27 12:43:57pm','Home/index','197.232.142.176',''),(74,'2023-11-27 12:46:43pm','About Us','41.72.208.186',''),(75,'2023-11-27 12:46:54pm','About Us','41.72.208.186',''),(76,'2023-11-27 12:47:18pm','About Us','41.72.208.186',''),(77,'2023-11-27 12:49:45pm','About Us','41.72.208.186',''),(78,'2023-11-27 13:30:41pm','About Us','154.154.218.197',''),(79,'2023-11-27 14:22:51pm','Home/index','197.232.142.176',''),(80,'2023-11-27 14:25:45pm','Home/index','197.232.142.176',''),(81,'2023-11-27 14:25:53pm','About Us','197.232.142.176',''),(82,'2023-11-27 14:25:57pm','About Us','197.232.142.176',''),(83,'2023-11-27 14:26:04pm','About Us','197.232.142.176',''),(84,'2023-11-27 14:26:16pm','About Us','197.232.142.176',''),(85,'2023-11-27 14:26:47pm','Home/index','197.232.142.176',''),(86,'2023-11-27 16:35:12pm','Home/index','171.244.43.14',''),(87,'2023-11-27 17:07:50pm','Home/index','47.242.224.70',''),(88,'2023-11-28 07:48:48am','Home/index','197.232.142.176',''),(89,'2023-11-28 07:51:25am','Home/index','197.232.142.176',''),(90,'2023-11-28 08:18:58am','Home/index','105.161.8.115',''),(91,'2023-11-28 08:19:50am','About Us','105.161.8.115',''),(92,'2023-11-28 08:25:23am','Home/index','105.161.8.115',''),(93,'2023-11-28 08:25:44am','Home/index','105.161.8.115',''),(94,'2023-11-28 08:25:48am','About Us','105.161.8.115',''),(95,'2023-11-28 08:27:20am','About Us','105.161.8.115',''),(96,'2023-11-28 08:27:33am','Home/index','105.161.8.115',''),(97,'2023-11-28 08:29:07am','Home/index','105.161.8.115',''),(98,'2023-11-28 08:35:08am','Home/index','154.152.156.107',''),(99,'2023-11-28 08:36:18am','Home/index','154.152.156.107',''),(100,'2023-11-28 08:47:25am','Home/index','154.152.156.107',''),(101,'2023-11-28 08:47:40am','Home/index','154.152.156.107',''),(102,'2023-11-28 08:48:10am','Home/index','154.152.156.107',''),(103,'2023-11-28 08:49:58am','Home/index','154.152.156.107',''),(104,'2023-11-28 10:07:59am','Home/index','197.232.142.176',''),(105,'2023-11-28 10:08:05am','About Us','197.232.142.176',''),(106,'2023-11-28 10:09:05am','About Us','197.232.142.176',''),(107,'2023-11-28 10:11:39am','About Us','197.232.142.176',''),(108,'2023-11-28 10:11:39am','About Us','197.232.142.176',''),(109,'2023-11-28 10:25:25am','About Us','102.0.4.108',''),(110,'2023-11-28 11:31:00am','Home/index','196.216.93.116',''),(111,'2023-11-28 11:31:40am','Home/index','196.216.93.116',''),(112,'2023-11-28 11:33:00am','Home/index','196.216.93.116',''),(113,'2023-11-28 11:46:37am','Home/index','197.179.210.3',''),(114,'2023-11-28 11:48:55am','Home/index','197.179.210.3',''),(115,'2023-11-28 11:56:09am','Home/index','197.179.210.3',''),(116,'2023-11-28 12:01:19pm','Home/index','102.0.4.108',''),(117,'2023-11-28 12:10:00pm','Home/index','102.0.4.108',''),(118,'2023-11-28 12:12:21pm','Home/index','102.0.4.108',''),(119,'2023-11-28 12:13:30pm','Home/index','102.0.4.108',''),(120,'2023-11-28 12:16:18pm','Home/index','102.0.4.108',''),(121,'2023-11-28 12:23:34pm','Home/index','102.0.4.108',''),(122,'2023-11-28 14:16:30pm','Home/index','34.207.114.204',''),(123,'2023-11-28 14:16:33pm','Home/index','34.207.114.204',''),(124,'2023-11-28 14:17:01pm','Home/index','34.207.114.204',''),(125,'2023-11-28 14:17:05pm','Home/index','34.207.114.204',''),(126,'2023-11-28 16:04:49pm','Home/index','102.0.4.108',''),(127,'2023-11-28 16:05:42pm','Home/index','102.0.4.108',''),(128,'2023-11-28 16:05:47pm','Home/index','102.0.4.108',''),(129,'2023-11-28 16:20:53pm','Home/index','102.0.4.108',''),(130,'2023-11-28 16:20:59pm','Home/index','102.0.4.108',''),(131,'2023-11-28 16:21:01pm','Home/index','102.0.4.108',''),(132,'2023-11-28 16:22:08pm','Home/index','102.0.4.108',''),(133,'2023-11-29 08:19:21am','About Us','102.0.4.108',''),(134,'2023-11-29 08:19:32am','About Us','102.0.4.108',''),(135,'2023-11-29 08:23:50am','About Us','102.0.4.108',''),(136,'2023-11-29 08:25:53am','About Us','102.0.4.108',''),(137,'2023-11-29 12:32:33pm','Home/index','105.163.1.64',''),(138,'2023-11-29 15:43:58pm','Home/index','102.0.4.108',''),(139,'2023-11-29 15:44:34pm','Home/index','102.0.4.108',''),(140,'2023-11-29 15:47:07pm','Home/index','102.0.4.108',''),(141,'2023-11-29 15:47:16pm','Home/index','102.0.4.108',''),(142,'2023-11-29 15:47:19pm','Home/index','102.0.4.108',''),(143,'2023-11-29 15:47:45pm','Home/index','102.0.4.108',''),(144,'2023-11-29 15:49:00pm','Home/index','102.0.4.108',''),(145,'2023-11-29 15:51:41pm','Home/index','102.0.4.108',''),(146,'2023-11-29 19:00:01pm','About Us','105.161.226.199',''),(147,'2023-11-29 19:00:05pm','About Us','105.161.226.199',''),(148,'2023-11-29 19:00:21pm','About Us','105.161.226.199',''),(149,'2023-11-29 19:00:31pm','Home/index','105.161.226.199',''),(150,'2023-11-29 19:06:16pm','Home/index','105.161.226.199',''),(151,'2023-11-30 19:55:07pm','About Us','102.0.4.108',''),(152,'2023-11-30 21:56:41pm','About Us','41.81.209.63',''),(153,'2023-11-30 22:26:05pm','About Us','102.0.4.108',''),(154,'2023-12-03 07:53:05am','About Us','197.176.48.71',''),(155,'2023-12-04 08:37:35am','About Us','102.0.4.108',''),(156,'2023-12-04 09:07:39am','Home/index','41.215.125.2',''),(157,'2023-12-04 09:07:50am','Home/index','41.215.125.2',''),(158,'2023-12-04 09:07:53am','About Us','41.215.125.2',''),(159,'2023-12-04 09:07:55am','About Us','41.215.125.2',''),(160,'2023-12-04 09:08:01am','About Us','41.215.125.2',''),(161,'2023-12-04 09:08:49am','About Us','41.215.125.2',''),(162,'2023-12-04 09:18:09am','Home/index','41.90.5.152',''),(163,'2023-12-04 09:18:16am','About Us','41.90.5.152',''),(164,'2023-12-04 09:20:11am','About Us','41.90.5.152',''),(165,'2023-12-04 09:23:19am','About Us','41.90.5.152',''),(166,'2023-12-04 09:25:31am','About Us','41.90.5.152',''),(167,'2023-12-04 09:25:34am','About Us','41.90.5.152',''),(168,'2023-12-04 11:58:53am','About Us','105.161.108.133',''),(169,'2023-12-04 15:02:07pm','About Us','105.160.30.160',''),(170,'2023-12-05 01:57:42am','Home/index','18.202.30.96',''),(171,'2023-12-05 13:37:53pm','Home/index','41.81.210.87',''),(172,'2023-12-05 18:31:32pm','About Us','105.161.181.226',''),(173,'2023-12-06 13:52:08pm','About Us','41.81.206.141',''),(174,'2023-12-06 20:23:02pm','About Us','154.76.81.143',''),(175,'2023-12-06 20:24:55pm','About Us','154.76.81.143',''),(176,'2023-12-07 19:06:12pm','About Us','197.179.110.176',''),(177,'2023-12-07 19:06:25pm','About Us','197.179.110.176',''),(178,'2023-12-07 19:06:30pm','About Us','197.179.110.176',''),(179,'2023-12-08 07:17:43am','Home/index','18.203.249.40',''),(180,'2023-12-08 20:11:38pm','About Us','41.81.170.175',''),(181,'2023-12-10 08:17:49am','Home/index','102.0.4.108',''),(182,'2023-12-14 14:08:29pm','Home/index','105.163.0.125',''),(183,'2023-12-14 14:08:42pm','About Us','105.163.0.125',''),(184,'2023-12-14 14:10:37pm','Home/index','154.152.124.124',''),(185,'2023-12-15 16:59:32pm','Home/index','197.232.142.176',''),(186,'2023-12-15 16:59:38pm','About Us','197.232.142.176',''),(187,'2023-12-15 21:25:11pm','About Us','105.163.157.249',''),(188,'2023-12-23 13:23:46pm','About Us','154.159.217.220',''),(189,'2023-12-25 17:35:45pm','Home/index','41.81.62.69',''),(190,'2023-12-25 17:36:23pm','Home/index','41.81.62.69',''),(191,'2023-12-25 17:36:24pm','Home/index','41.81.62.69',''),(192,'2023-12-25 20:49:19pm','About Us','154.159.252.47',''),(193,'2023-12-25 20:49:33pm','About Us','154.159.252.47',''),(194,'2023-12-31 21:38:09pm','About Us','105.161.14.244',''),(195,'2024-01-03 03:48:37am','Home/index','199.45.155.17',''),(196,'2024-01-03 09:00:03am','Home/index','199.45.155.17',''),(197,'2024-01-03 15:11:26pm','About Us','102.215.77.202',''),(198,'2024-01-03 15:27:11pm','About Us','102.215.77.202',''),(199,'2024-01-06 14:30:35pm','Home/index','41.81.173.153',''),(200,'2024-01-06 21:48:44pm','Home/index','105.161.205.205',''),(201,'2024-01-06 21:49:32pm','Home/index','105.161.205.205',''),(202,'2024-01-08 03:37:04am','Home/index','154.79.196.16',''),(203,'2024-01-08 03:37:10am','About Us','154.79.196.16',''),(204,'2024-01-08 03:37:45am','About Us','154.79.196.16',''),(205,'2024-01-08 03:38:27am','About Us','154.79.196.16',''),(206,'2024-01-08 07:43:40am','Home/index','197.232.142.176',''),(207,'2024-01-08 07:43:43am','Home/index','197.232.142.176',''),(208,'2024-01-10 11:30:45am','Home/index','34.207.151.13',''),(209,'2024-01-15 12:26:34pm','Home/index','102.0.4.108',''),(210,'2024-01-16 15:54:21pm','About Us','41.90.4.197',''),(211,'2024-01-16 16:21:47pm','Home/index','102.0.4.108',''),(212,'2024-01-16 16:39:29pm','About Us','196.201.218.28',''),(213,'2024-01-16 16:39:33pm','About Us','196.201.218.28',''),(214,'2024-01-16 16:39:41pm','About Us','196.201.218.28',''),(215,'2024-01-16 17:31:28pm','Home/index','52.213.244.163',''),(216,'2024-01-17 18:24:46pm','About Us','197.182.50.72',''),(217,'2024-01-17 18:25:09pm','About Us','197.182.50.72',''),(218,'2024-01-18 09:16:48am','About Us','197.232.142.176',''),(219,'2024-01-21 18:41:43pm','About Us','105.161.15.24',''),(220,'2024-01-22 14:12:08pm','About Us','102.215.77.202',''),(221,'2024-01-23 16:46:24pm','About Us','105.48.133.176',''),(222,'2024-01-25 13:28:25pm','About Us','154.159.252.13',''),(223,'2024-01-26 16:00:58pm','About Us','41.90.217.75',''),(224,'2024-01-26 21:05:00pm','About Us','41.80.117.63',''),(225,'2024-01-27 09:25:27am','About Us','154.158.171.197',''),(226,'2024-01-27 09:30:09am','Home/index','65.154.226.171',''),(227,'2024-01-27 09:30:22am','Home/index','205.169.39.126',''),(228,'2024-01-27 09:30:35am','Home/index','205.169.39.126',''),(229,'2024-01-27 09:31:10am','Home/index','95.217.18.177',''),(230,'2024-01-27 09:31:11am','Home/index','185.156.46.149',''),(231,'2024-01-27 17:30:29pm','Home/index','47.242.224.70',''),(232,'2024-01-29 21:26:36pm','Home/index','159.65.29.225',''),(233,'2024-01-29 21:26:36pm','Home/index','159.65.29.225',''),(234,'2024-01-29 22:52:26pm','About Us','102.215.77.202',''),(235,'2024-01-30 12:55:52pm','About Us','196.100.182.164',''),(236,'2024-01-30 12:56:13pm','About Us','196.100.182.164',''),(237,'2024-01-31 18:22:10pm','Home/index','138.197.187.226',''),(238,'2024-01-31 18:22:10pm','Home/index','138.197.187.226',''),(239,'2024-01-31 23:14:01pm','Home/index','188.165.87.99',''),(240,'2024-01-31 23:19:26pm','Home/index','188.165.87.105',''),(241,'2024-02-01 00:59:18am','Home/index','46.51.139.3',''),(242,'2024-02-01 01:06:55am','Home/index','51.254.49.108',''),(243,'2024-02-02 10:35:20am','About Us','154.155.74.85',''),(244,'2024-02-05 06:26:14am','Home/index','18.201.14.155',''),(245,'2024-02-06 12:29:47pm','Home/index','209.95.56.51',''),(246,'2024-02-06 12:30:00pm','About Us','209.95.56.51',''),(247,'2024-02-06 20:45:07pm','Home/index','188.165.87.98',''),(248,'2024-02-06 20:53:48pm','Home/index','188.165.87.111',''),(249,'2024-02-06 21:59:24pm','Home/index','51.254.49.98',''),(250,'2024-02-09 13:06:40pm','Home/index','95.217.18.177',''),(251,'2024-02-10 09:26:55am','Home/index','146.190.18.171',''),(252,'2024-02-10 09:26:55am','Home/index','146.190.18.171',''),(253,'2024-02-14 20:46:24pm','Home/index','104.248.164.219',''),(254,'2024-02-14 20:46:25pm','Home/index','104.248.164.219',''),(255,'2024-02-24 06:27:18am','Home/index','146.190.55.26',''),(256,'2024-02-24 06:27:19am','Home/index','146.190.55.26',''),(257,'2024-02-26 02:07:45am','Home/index','44.234.24.254',''),(258,'2024-02-28 13:11:22pm','Home/index','138.68.154.144',''),(259,'2024-02-28 13:11:22pm','Home/index','138.68.154.144',''),(260,'2024-03-02 14:07:38pm','Home/index','105.161.83.7',''),(261,'2024-03-14 18:36:27pm','About Us','105.56.29.157',''),(262,'2024-03-14 18:40:46pm','About Us','105.56.29.157',''),(263,'2024-03-14 18:41:09pm','Home/index','105.56.29.157',''),(264,'2024-03-14 18:41:09pm','Home/index','105.56.29.157',''),(265,'2024-03-14 18:41:16pm','About Us','105.56.29.157',''),(266,'2024-03-17 00:24:37am','Home/index','44.234.25.43',''),(267,'2024-03-20 10:48:50am','About Us','105.160.112.151',''),(268,'2024-03-20 10:48:52am','About Us','66.249.93.166',''),(269,'2024-03-20 10:48:53am','About Us','66.102.9.166',''),(270,'2024-03-20 10:48:53am','About Us','66.102.9.165',''),(271,'2024-03-21 21:54:40pm','Home/index','64.15.129.110',''),(272,'2024-03-21 21:54:45pm','Home/index','192.175.111.233',''),(273,'2024-03-21 21:54:46pm','Home/index','192.175.111.248',''),(274,'2024-03-28 08:57:01am','Home/index','149.34.244.182',''),(275,'2024-03-28 08:57:07am','About Us','149.34.244.182',''),(276,'2024-03-28 11:19:38am','Home/index','195.211.77.142',''),(277,'2024-03-28 11:21:04am','Home/index','205.169.39.119',''),(278,'2024-03-28 11:21:13am','Home/index','205.169.39.119',''),(279,'2024-03-28 14:08:19pm','Home/index','198.54.134.144',''),(280,'2024-03-28 19:26:03pm','Home/index','47.242.224.70',''),(281,'2024-03-28 23:56:49pm','Home/index','195.211.77.142',''),(282,'2024-03-29 00:23:14am','Home/index','88.99.26.177',''),(283,'2024-03-29 16:43:01pm','Home/index','185.67.34.1',''),(284,'2024-03-29 20:56:39pm','Home/index','47.242.224.70',''),(285,'2024-03-30 11:09:26am','Home/index','185.67.34.1',''),(286,'2024-03-31 04:54:26am','Home/index','185.67.34.1',''),(287,'2024-03-31 14:39:48pm','About Us','197.232.61.220',''),(288,'2024-03-31 22:49:28pm','Home/index','185.67.34.1',''),(289,'2024-04-01 18:47:32pm','Home/index','188.165.87.108',''),(290,'2024-04-01 18:47:33pm','Home/index','188.165.87.99',''),(291,'2024-04-01 19:57:34pm','Home/index','51.254.49.111',''),(292,'2024-04-03 21:25:45pm','Home/index','34.254.153.143',''),(293,'2024-04-03 23:05:36pm','Home/index','34.255.4.36',''),(294,'2024-04-05 01:09:44am','Home/index','205.210.31.72',''),(295,'2024-04-05 17:57:47pm','Home/index','198.235.24.123',''),(296,'2024-04-07 19:21:22pm','Home/index','205.210.31.184',''),(297,'2024-04-07 20:31:48pm','Home/index','54.83.100.114',''),(298,'2024-04-08 03:05:06am','Home/index','205.210.31.155',''),(299,'2024-04-08 04:03:12am','Home/index','188.165.87.111',''),(300,'2024-04-08 04:09:23am','Home/index','188.165.87.108',''),(301,'2024-04-08 06:49:29am','Home/index','51.254.49.108',''),(302,'2024-04-10 04:53:56am','Home/index','35.81.165.139',''),(303,'2024-04-10 14:49:49pm','Home/index','198.235.24.132',''),(304,'2024-04-10 17:09:38pm','Home/index','198.235.24.196',''),(305,'2024-04-14 04:29:10am','Home/index','205.210.31.3',''),(306,'2024-04-15 04:02:59am','Home/index','35.87.162.154',''),(307,'2024-04-16 18:19:37pm','Home/index','205.210.31.90',''),(308,'2024-04-18 12:19:04pm','About Us','105.55.213.164',''),(309,'2024-04-18 23:08:11pm','Home/index','65.154.226.171',''),(310,'2024-04-22 14:18:24pm','Home/index','95.217.18.177',''),(311,'2024-04-30 12:46:49pm','Home/index','205.210.31.48',''),(312,'2024-05-02 22:38:22pm','Home/index','34.243.116.33',''),(313,'2024-05-06 07:02:22am','Home/index','63.35.189.43',''),(314,'2024-05-06 07:08:50am','Home/index','52.208.89.57',''),(315,'2024-05-06 12:58:02pm','Home/index','161.97.139.135',''),(316,'2024-05-07 09:02:48am','About Us','41.81.154.161',''),(317,'2024-05-10 18:35:27pm','Home/index','198.235.24.30',''),(318,'2024-05-11 23:21:37pm','Home/index','35.94.214.212',''),(319,'2024-05-13 19:49:28pm','Home/index','188.165.87.101',''),(320,'2024-05-13 19:58:24pm','Home/index','188.165.87.105',''),(321,'2024-05-13 21:41:10pm','Home/index','51.254.49.106',''),(322,'2024-05-15 16:09:38pm','Home/index','198.235.24.104',''),(323,'2024-05-20 04:47:09am','Home/index','198.235.24.20',''),(324,'2024-05-28 11:21:20am','Home/index','51.15.66.158',''),(325,'2024-05-28 11:21:36am','Home/index','34.72.176.129',''),(326,'2024-05-28 11:21:49am','Home/index','205.169.39.162',''),(327,'2024-05-28 11:22:10am','Home/index','205.169.39.162',''),(328,'2024-05-28 11:24:25am','Home/index','206.217.206.123',''),(329,'2024-05-28 11:46:00am','Home/index','207.241.236.84',''),(330,'2024-05-28 11:47:25am','Home/index','207.241.236.84',''),(331,'2024-05-28 19:19:42pm','Home/index','47.242.224.70',''),(332,'2024-05-29 13:27:55pm','Home/index','66.249.70.67',''),(333,'2024-05-29 13:27:57pm','Home/index','66.249.70.68',''),(334,'2024-05-29 16:00:52pm','Home/index','66.249.70.67',''),(335,'2024-05-29 23:54:10pm','About Us','66.249.70.67',''),(336,'2024-05-30 00:05:54am','About Us','66.249.70.67',''),(337,'2024-05-30 13:59:59pm','Home/index','66.249.70.66',''),(338,'2024-05-30 22:01:51pm','Home/index','104.131.187.58',''),(339,'2024-05-30 22:01:52pm','Home/index','104.131.187.58',''),(340,'2024-06-01 06:27:56am','Home/index','167.99.145.103',''),(341,'2024-06-01 06:27:58am','Home/index','167.99.145.103',''),(342,'2024-06-01 14:53:52pm','Home/meeting','66.249.70.68',''),(343,'2024-06-01 21:24:12pm','Home/index','139.59.181.125',''),(344,'2024-06-01 21:24:13pm','Home/index','139.59.181.125',''),(345,'2024-06-02 06:53:34am','Home/index','52.167.144.203',''),(346,'2024-06-03 07:56:18am','About Us','66.249.70.68',''),(347,'2024-06-04 19:10:27pm','Home/index','34.251.65.175',''),(348,'2024-06-05 01:11:49am','Home/index','18.201.70.143',''),(349,'2024-06-05 10:35:50am','Home/index','157.230.120.249',''),(350,'2024-06-05 10:35:51am','Home/index','157.230.120.249',''),(351,'2024-06-06 11:09:57am','About Us','66.249.70.67',''),(352,'2024-06-07 10:11:03am','About Us','66.249.70.66',''),(353,'2024-06-07 16:13:11pm','About Us','66.249.70.67',''),(354,'2024-06-10 07:22:26am','About Us','66.249.70.67',''),(355,'2024-06-10 23:41:14pm','About Us','66.249.70.68',''),(356,'2024-06-14 13:11:40pm','Home/index','35.94.217.65',''),(357,'2024-06-14 14:31:49pm','Home/index','41.81.8.236',''),(358,'2024-06-15 16:36:07pm','Home/index','138.197.65.251',''),(359,'2024-06-15 16:36:08pm','Home/index','138.197.65.251',''),(360,'2024-06-16 02:58:27am','About Us','66.249.72.133',''),(361,'2024-06-18 09:45:14am','About Us','66.249.70.66',''),(362,'2024-06-19 19:26:20pm','About Us','66.249.70.67',''),(363,'2024-06-22 08:43:45am','About Us','66.249.70.68',''),(364,'2024-06-23 23:55:34pm','Home/meeting','52.167.144.186',''),(365,'2024-06-24 02:57:41am','Home/index','146.190.76.186',''),(366,'2024-06-24 02:57:42am','Home/index','146.190.76.186',''),(367,'2024-06-24 05:26:13am','Home/index','66.249.70.68',''),(368,'2024-06-24 05:26:14am','Home/index','66.249.70.67',''),(369,'2024-06-24 14:42:00pm','Home/index','154.159.252.206',''),(370,'2024-06-26 00:44:26am','Home/index','104.248.139.155',''),(371,'2024-06-26 00:44:27am','Home/index','104.248.139.155',''),(372,'2024-06-26 04:59:04am','About Us','66.249.66.64',''),(373,'2024-06-27 01:54:40am','Home/index','3.84.194.178',''),(374,'2024-06-27 07:51:39am','Home/index','66.249.66.64',''),(375,'2024-06-28 09:40:51am','About Us','66.249.66.66',''),(376,'2024-06-28 10:26:52am','Home/index','135.148.100.196',''),(377,'2024-06-28 21:55:57pm','About Us','66.249.69.68',''),(378,'2024-06-29 09:10:27am','Home/index','35.90.38.106',''),(379,'2024-06-29 09:10:27am','Home/index','54.212.229.5',''),(380,'2024-06-29 09:10:31am','Home/index','34.219.183.91',''),(381,'2024-06-29 09:10:31am','Home/index','54.212.229.5',''),(382,'2024-06-29 09:52:58am','About Us','66.249.69.66',''),(383,'2024-06-29 16:08:53pm','Home/index','165.227.129.98',''),(384,'2024-06-29 16:08:54pm','Home/index','165.227.129.98',''),(385,'2024-06-30 19:25:22pm','About Us','66.249.66.66',''),(386,'2024-07-01 01:49:21am','About Us','66.249.66.66',''),(387,'2024-07-01 20:12:32pm','Home/index','136.158.33.1',''),(388,'2024-07-01 20:12:37pm','Home/index','35.90.38.106',''),(389,'2024-07-02 03:01:18am','About Us','66.249.66.64',''),(390,'2024-07-02 05:49:23am','About Us','66.249.66.65',''),(391,'2024-07-02 11:32:35am','About Us','102.6.198.37',''),(392,'2024-07-03 08:36:20am','Home/index','139.59.5.113',''),(393,'2024-07-03 08:36:21am','Home/index','139.59.5.113',''),(394,'2024-07-03 22:48:18pm','About Us','66.249.66.81',''),(395,'2024-07-04 19:55:36pm','Home/index','34.241.79.193',''),(396,'2024-07-04 20:06:26pm','Home/index','3.249.25.14',''),(397,'2024-07-05 19:01:07pm','Home/index','41.81.194.5',''),(398,'2024-07-05 22:36:13pm','Home/index','102.215.77.246',''),(399,'2024-07-05 22:36:24pm','Home/index','102.215.77.246',''),(400,'2024-07-07 10:04:25am','Home/index','66.220.149.28',''),(401,'2024-07-07 19:13:21pm','About Us','66.249.75.224',''),(402,'2024-07-08 02:32:25am','About Us','52.167.144.238',''),(403,'2024-07-08 06:17:41am','About Us','66.249.75.225',''),(404,'2024-07-09 15:18:52pm','About Us','66.249.75.224',''),(405,'2024-07-10 06:15:07am','About Us','66.249.75.225',''),(406,'2024-07-10 07:41:16am','About Us','66.249.75.224',''),(407,'2024-07-12 07:09:04am','About Us','66.249.72.134',''),(408,'2024-07-12 13:23:25pm','About Us','197.232.114.191',''),(409,'2024-07-13 04:54:05am','Home/index','68.183.156.226',''),(410,'2024-07-13 04:54:06am','Home/index','68.183.156.226',''),(411,'2024-07-13 12:37:35pm','About Us','57.141.0.18',''),(412,'2024-07-13 14:46:01pm','About Us','173.252.83.12',''),(413,'2024-07-13 18:32:15pm','About Us','66.249.72.133',''),(414,'2024-07-13 20:31:20pm','About Us','66.249.72.135',''),(415,'2024-07-15 15:07:36pm','Home/index','45.196.45.131',''),(416,'2024-07-15 22:15:03pm','About Us','66.249.72.135',''),(417,'2024-07-16 22:12:18pm','Home/index','44.233.155.148',''),(418,'2024-07-17 08:08:49am','About Us','66.249.72.133',''),(419,'2024-07-17 08:15:43am','Home/index','167.71.109.147',''),(420,'2024-07-17 08:15:44am','Home/index','167.71.109.147',''),(421,'2024-07-18 04:58:35am','About Us','69.171.230.20',''),(422,'2024-07-18 13:04:01pm','About Us','196.201.218.128',''),(423,'2024-07-18 13:04:33pm','About Us','41.81.76.28',''),(424,'2024-07-18 14:19:48pm','About Us','40.77.167.73',''),(425,'2024-07-21 17:08:13pm','Home/index','66.249.72.134',''),(426,'2024-07-21 17:08:13pm','Home/index','66.249.72.133',''),(427,'2024-07-23 18:54:16pm','Home/meeting','69.171.249.116',''),(428,'2024-07-26 02:53:05am','About Us','66.249.70.68',''),(429,'2024-07-27 05:07:20am','Home/index','188.166.174.44',''),(430,'2024-07-27 05:07:21am','Home/index','188.166.174.44',''),(431,'2024-07-28 11:20:07am','Home/index','95.217.18.177',''),(432,'2024-07-28 11:20:15am','Home/index','34.72.176.129',''),(433,'2024-07-28 11:20:18am','Home/index','205.169.39.45',''),(434,'2024-07-28 11:20:24am','Home/index','205.169.39.125',''),(435,'2024-07-28 11:20:36am','Home/index','205.169.39.125',''),(436,'2024-07-28 11:20:51am','Home/index','104.197.69.115',''),(437,'2024-07-28 11:23:37am','Home/index','173.205.85.50',''),(438,'2024-07-28 11:23:45am','Home/index','207.241.236.83',''),(439,'2024-07-28 11:23:51am','Home/index','207.241.236.83',''),(440,'2024-07-28 19:20:02pm','Home/index','47.242.224.70',''),(441,'2024-07-28 22:07:44pm','About Us','66.249.70.66',''),(442,'2024-07-29 13:03:36pm','Home/index','95.217.18.177',''),(443,'2024-07-29 17:51:02pm','About Us','66.249.70.66',''),(444,'2024-07-29 22:30:24pm','Home/index','165.227.229.211',''),(445,'2024-07-29 22:30:24pm','Home/index','165.227.229.211',''),(446,'2024-07-31 05:52:36am','Home/index','178.62.234.171',''),(447,'2024-07-31 05:52:37am','Home/index','178.62.234.171',''),(448,'2024-07-31 21:58:54pm','Home/index','143.198.44.35',''),(449,'2024-07-31 21:58:56pm','Home/index','143.198.44.35',''),(450,'2024-08-01 07:26:20am','Home/index','35.219.227.164',''),(451,'2024-08-01 07:26:28am','Home/meeting','35.219.227.164',''),(452,'2024-08-01 07:26:28am','Home/index','35.219.227.164',''),(453,'2024-08-01 07:26:28am','About Us','35.219.227.164',''),(454,'2024-08-03 03:28:21am','About Us','66.249.66.64',''),(455,'2024-08-05 21:18:10pm','Home/index','3.83.1.69',''),(456,'2024-08-05 21:18:16pm','Home/index','54.243.8.50',''),(457,'2024-08-06 06:33:16am','About Us','66.249.66.65',''),(458,'2024-08-08 16:39:21pm','Home/index','54.154.80.65',''),(459,'2024-08-08 19:16:32pm','Home/meeting','66.249.70.67',''),(460,'2024-08-08 23:48:52pm','Home/index','34.247.89.142',''),(461,'2024-08-09 10:10:47am','About Us','66.249.70.68',''),(462,'2024-08-09 14:47:01pm','About Us','66.249.70.67',''),(463,'2024-08-10 17:16:27pm','Home/index','64.23.162.197',''),(464,'2024-08-10 17:16:29pm','Home/index','64.23.162.197',''),(465,'2024-08-14 06:48:01am','Home/index','165.227.34.56',''),(466,'2024-08-14 06:48:02am','Home/index','165.227.34.56',''),(467,'2024-08-14 13:27:17pm','Home/index','40.77.167.254',''),(468,'2024-08-16 19:24:37pm','Home/index','145.220.91.19',''),(469,'2024-08-18 11:04:15am','Home/index','205.169.39.1',''),(470,'2024-08-21 16:28:19pm','About Us','66.249.70.68',''),(471,'2024-08-21 20:51:32pm','Home/index','35.84.188.197',''),(472,'2024-08-22 23:28:45pm','About Us','66.249.70.67',''),(473,'2024-08-24 10:33:40am','Home/index','159.203.26.164',''),(474,'2024-08-24 10:33:42am','Home/index','159.203.26.164',''),(475,'2024-08-25 11:09:44am','About Us','66.249.70.68',''),(476,'2024-08-26 16:19:14pm','Home/index','66.249.70.66',''),(477,'2024-08-26 16:19:15pm','Home/index','66.249.70.67',''),(478,'2024-08-27 23:23:14pm','About Us','66.249.70.67',''),(479,'2024-08-28 10:56:52am','Home/index','164.92.235.103',''),(480,'2024-08-28 10:56:53am','Home/index','164.92.235.103',''),(481,'2024-08-28 23:22:43pm','Home/index','194.238.17.59',''),(482,'2024-08-29 00:02:15am','About Us','66.249.70.68',''),(483,'2024-08-30 22:32:48pm','Home/index','68.183.158.20',''),(484,'2024-08-30 22:32:49pm','Home/index','68.183.158.20',''),(485,'2024-08-31 13:26:43pm','About Us','66.249.64.225',''),(486,'2024-09-01 17:34:15pm','About Us','66.249.66.66',''),(487,'2024-09-01 18:24:49pm','About Us','196.96.51.155',''),(488,'2024-09-01 21:45:00pm','Home/index','167.99.156.207',''),(489,'2024-09-01 21:45:05pm','Home/index','167.99.156.207',''),(490,'2024-09-02 23:42:40pm','About Us','66.249.64.224',''),(491,'2024-09-03 09:02:45am','About Us','66.249.70.67',''),(492,'2024-09-05 14:18:53pm','About Us','66.249.64.225',''),(493,'2024-09-05 21:15:44pm','About Us','66.249.64.226',''),(494,'2024-09-06 01:37:52am','Home/index','52.50.4.13',''),(495,'2024-09-06 02:28:34am','Home/index','3.249.110.123',''),(496,'2024-09-07 07:52:24am','About Us','52.167.144.22',''),(497,'2024-09-07 08:38:44am','Home/index','137.184.9.193',''),(498,'2024-09-07 08:38:45am','Home/index','137.184.9.193',''),(499,'2024-09-07 10:17:37am','About Us','66.249.64.225',''),(500,'2024-09-09 10:05:46am','About Us','66.249.64.224',''),(501,'2024-09-10 20:25:02pm','Home/index','107.181.244.204',''),(502,'2024-09-11 06:10:07am','Home/index','146.190.252.253',''),(503,'2024-09-11 06:10:09am','Home/index','146.190.252.253',''),(504,'2024-09-11 16:32:22pm','About Us','66.249.72.66',''),(505,'2024-09-12 21:02:05pm','Home/index','35.87.242.173',''),(506,'2024-09-13 10:05:26am','About Us','66.249.79.195',''),(507,'2024-09-15 12:56:22pm','About Us','66.249.64.224',''),(508,'2024-09-17 19:15:34pm','About Us','66.249.64.224',''),(509,'2024-09-18 13:41:19pm','Home/index','66.249.64.226',''),(510,'2024-09-18 13:41:19pm','Home/index','66.249.64.225',''),(511,'2024-09-19 07:39:09am','Home/index','34.71.234.159',''),(512,'2024-09-20 03:37:42am','About Us','66.249.66.64',''),(513,'2024-09-20 05:49:03am','About Us','66.249.66.64',''),(514,'2024-09-21 00:35:20am','About Us','66.249.64.226',''),(515,'2024-09-21 06:39:30am','Home/index','161.35.160.170',''),(516,'2024-09-21 06:39:31am','Home/index','161.35.160.170',''),(517,'2024-09-24 08:08:34am','About Us','66.249.72.135',''),(518,'2024-09-25 13:30:16pm','About Us','66.249.64.225',''),(519,'2024-09-25 14:15:56pm','Home/index','142.93.140.110',''),(520,'2024-09-25 14:15:57pm','Home/index','142.93.140.110',''),(521,'2024-09-25 17:32:32pm','About Us','66.249.64.226',''),(522,'2024-09-27 11:20:13am','Home/index','34.72.176.129',''),(523,'2024-09-27 11:20:52am','Home/index','169.150.196.31',''),(524,'2024-09-27 11:26:32am','Home/index','205.169.39.17',''),(525,'2024-09-27 12:00:47pm','Home/index','51.210.242.29',''),(526,'2024-09-27 21:44:53pm','Home/index','46.101.126.96',''),(527,'2024-09-27 21:44:55pm','Home/index','46.101.126.96',''),(528,'2024-09-28 07:25:53am','About Us','66.249.64.224',''),(529,'2024-09-29 21:14:14pm','Home/index','165.232.148.244',''),(530,'2024-09-29 21:14:15pm','Home/index','165.232.148.244',''),(531,'2024-09-30 03:21:38am','About Us','66.249.64.225',''),(532,'2024-10-01 02:08:21am','About Us','66.249.64.224',''),(533,'2024-10-01 21:57:31pm','Home/index','188.166.113.119',''),(534,'2024-10-01 21:57:32pm','Home/index','188.166.113.119',''),(535,'2024-10-01 22:12:45pm','Home/index','102.215.77.202',''),(536,'2024-10-02 01:43:01am','Home/index','104.152.52.58',''),(537,'2024-10-02 03:57:20am','About Us','66.249.64.225',''),(538,'2024-10-02 06:01:57am','Home/index','35.187.191.130',''),(539,'2024-10-02 06:01:57am','Home/index','34.22.213.78',''),(540,'2024-10-03 12:23:25pm','About Us','66.249.64.224',''),(541,'2024-10-04 06:48:19am','About Us','66.249.64.226',''),(542,'2024-10-04 23:29:14pm','About Us','66.249.64.225',''),(543,'2024-10-05 11:22:34am','Home/index','206.189.201.211',''),(544,'2024-10-05 11:22:35am','Home/index','206.189.201.211',''),(545,'2024-10-06 10:28:10am','Home/index','198.235.24.173',''),(546,'2024-10-06 12:32:20pm','Home/index','205.210.31.27',''),(547,'2024-10-06 23:54:39pm','About Us','66.249.64.224',''),(548,'2024-10-07 03:03:17am','Home/index','199.45.155.73',''),(549,'2024-10-07 05:29:45am','Home/index','198.235.24.174',''),(550,'2024-10-07 06:34:10am','Home/index','3.253.233.205',''),(551,'2024-10-07 13:59:44pm','Home/index','3.253.160.47',''),(552,'2024-10-07 17:28:04pm','Home/index','3.255.190.9',''),(553,'2024-10-08 17:48:57pm','Home/index','44.234.148.18',''),(554,'2024-10-09 13:23:11pm','Home/index','159.203.84.73',''),(555,'2024-10-09 13:23:12pm','Home/index','159.203.84.73',''),(556,'2024-10-10 18:07:22pm','Home/index','101.53.216.61',''),(557,'2024-10-13 02:57:46am','Home/index','205.210.31.59',''),(558,'2024-10-13 19:55:49pm','About Us','66.249.64.226',''),(559,'2024-10-14 11:38:24am','Home/index','198.235.24.30',''),(560,'2024-10-14 19:35:38pm','Home/index','34.67.43.79',''),(561,'2024-10-16 13:07:16pm','Home/index','31.104.63.52',''),(562,'2024-10-18 11:55:35am','Home/index','205.169.39.21',''),(563,'2024-10-18 16:27:53pm','Home/index','73.51.249.169',''),(564,'2024-10-19 14:51:12pm','Home/index','35.215.99.245',''),(565,'2024-10-19 14:51:15pm','About Us','35.215.99.245',''),(566,'2024-10-19 14:51:15pm','Home/meeting','35.215.99.245',''),(567,'2024-10-19 14:51:15pm','Home/index','35.215.99.245',''),(568,'2024-10-19 15:34:10pm','Home/index','146.190.51.6',''),(569,'2024-10-19 15:34:12pm','Home/index','146.190.51.6',''),(570,'2024-10-19 15:36:45pm','About Us','66.249.64.225',''),(571,'2024-10-20 12:05:45pm','About Us','66.249.64.225',''),(572,'2024-10-22 00:32:26am','About Us','66.249.70.34',''),(573,'2024-10-22 08:25:47am','Home/index','95.45.50.248',''),(574,'2024-10-23 08:34:30am','Home/index','165.22.14.246',''),(575,'2024-10-23 08:34:32am','Home/index','165.22.14.246',''),(576,'2024-10-23 22:39:47pm','Home/index','1.145.134.118',''),(577,'2024-10-26 04:21:39am','About Us','66.249.70.34',''),(578,'2024-10-26 14:22:43pm','Home/index','51.81.46.212',''),(579,'2024-10-29 19:24:24pm','Home/index','86.46.67.56',''),(580,'2024-11-02 03:44:54am','Home/index','34.245.77.92',''),(581,'2024-11-02 06:36:40am','Home/index','157.245.114.237',''),(582,'2024-11-02 06:36:42am','Home/index','157.245.114.237',''),(583,'2024-11-04 04:56:54am','About Us','66.249.70.36',''),(584,'2024-11-06 03:47:49am','Home/index','147.182.152.159',''),(585,'2024-11-06 03:47:50am','Home/index','147.182.152.159',''),(586,'2024-11-06 10:06:00am','Home/index','3.250.187.209',''),(587,'2024-11-06 14:27:15pm','Home/index','174.113.213.144',''),(588,'2024-11-06 15:32:18pm','Home/index','18.201.182.246',''),(589,'2024-11-09 03:05:49am','Home/index','115.231.78.8',''),(590,'2024-11-09 03:05:51am','Home/index','115.231.78.8',''),(591,'2024-11-09 03:06:39am','Home/index','115.231.78.8',''),(592,'2024-11-09 03:06:41am','Home/index','115.231.78.8',''),(593,'2024-11-09 15:01:44pm','About Us','66.249.70.34',''),(594,'2024-11-09 16:55:14pm','About Us','66.249.70.36',''),(595,'2024-11-12 02:33:16am','About Us','66.249.70.34',''),(596,'2024-11-12 03:20:14am','About Us','66.249.70.36',''),(597,'2024-11-12 10:35:11am','Home/index','125.238.31.93',''),(598,'2024-11-13 17:07:25pm','About Us','66.249.70.36',''),(599,'2024-11-13 20:31:26pm','Home/index','35.85.254.104',''),(600,'2024-11-14 15:15:30pm','Home/index','86.129.162.144',''),(601,'2024-11-16 07:10:56am','Home/index','146.190.53.204',''),(602,'2024-11-16 07:10:58am','Home/index','146.190.53.204',''),(603,'2024-11-17 03:28:23am','Home/index','35.225.171.240',''),(604,'2024-11-18 23:04:34pm','Home/index','174.138.7.37',''),(605,'2024-11-18 23:04:35pm','Home/index','174.138.7.37',''),(606,'2024-11-20 03:20:23am','Home/index','96.30.137.230',''),(607,'2024-11-20 06:56:16am','Home/index','68.183.95.76',''),(608,'2024-11-20 06:56:18am','Home/index','68.183.95.76',''),(609,'2024-11-23 00:20:53am','About Us','66.249.66.65',''),(610,'2024-11-25 10:49:45am','Home/index','51.81.46.212',''),(611,'2024-11-27 11:20:31am','Home/index','195.211.77.140',''),(612,'2024-11-27 11:21:04am','Home/index','195.211.77.142',''),(613,'2024-11-27 11:27:33am','Home/index','88.99.26.177',''),(614,'2024-11-27 14:07:48pm','Home/index','34.72.176.129',''),(615,'2024-11-28 00:10:38am','Home/index','171.244.43.14',''),(616,'2024-11-28 06:56:36am','Home/index','195.211.77.140',''),(617,'2024-11-28 06:56:57am','Home/index','195.211.77.142',''),(618,'2024-11-28 18:26:19pm','Home/index','52.167.144.198',''),(619,'2024-11-28 22:30:03pm','Home/index','64.227.136.66',''),(620,'2024-11-28 22:30:05pm','Home/index','64.227.136.66',''),(621,'2024-11-29 15:42:38pm','Home/index','196.201.218.54',''),(622,'2024-11-29 15:42:46pm','Home/index','66.249.81.131',''),(623,'2024-11-29 15:42:47pm','Home/index','74.125.210.35',''),(624,'2024-11-29 15:42:47pm','Home/index','74.125.210.34',''),(625,'2024-11-29 17:02:21pm','Home/index','84.254.98.24',''),(626,'2024-11-30 09:41:20am','Home/index','52.167.144.170',''),(627,'2024-11-30 16:38:11pm','Home/index','146.190.167.70',''),(628,'2024-11-30 16:38:13pm','Home/index','146.190.167.70',''),(629,'2024-11-30 23:01:02pm','Home/index','159.65.167.83',''),(630,'2024-11-30 23:01:04pm','Home/index','159.65.167.83',''),(631,'2024-12-02 22:29:36pm','Home/index','54.195.30.226',''),(632,'2024-12-03 13:49:37pm','Home/index','87.236.176.59',''),(633,'2024-12-04 05:31:53am','Home/index','165.227.37.38',''),(634,'2024-12-04 05:31:55am','Home/index','165.227.37.38',''),(635,'2024-12-05 01:32:57am','Home/index','64.23.254.93',''),(636,'2024-12-06 02:39:39am','Home/index','68.146.204.36',''),(637,'2024-12-06 09:30:43am','Home/index','54.216.160.182',''),(638,'2024-12-06 12:13:58pm','Home/index','34.245.25.29',''),(639,'2024-12-07 15:14:04pm','Home/index','91.84.87.137',''),(640,'2024-12-08 12:32:51pm','Home/index','205.210.31.129',''),(641,'2024-12-08 18:30:12pm','Home/index','198.235.24.16',''),(642,'2024-12-10 21:22:44pm','About Us','66.249.66.66',''),(643,'2024-12-12 20:33:36pm','Home/index','34.223.42.139',''),(644,'2024-12-12 20:43:56pm','About Us','66.249.66.64',''),(645,'2024-12-13 04:17:14am','Home/index','57.141.0.23',''),(646,'2024-12-14 03:12:59am','Home/index','66.249.66.162',''),(647,'2024-12-14 04:15:36am','Home/index','66.249.66.162',''),(648,'2024-12-14 04:15:37am','Home/index','66.249.66.164',''),(649,'2024-12-14 05:18:57am','Home/index','188.166.49.249',''),(650,'2024-12-14 05:18:58am','Home/index','188.166.49.249',''),(651,'2024-12-14 08:02:54am','Home/index','80.111.239.11',''),(652,'2024-12-14 18:36:04pm','Home/index','104.198.44.107',''),(653,'2024-12-15 14:51:43pm','About Us','66.249.66.66',''),(654,'2024-12-16 12:40:15pm','Home/index','66.249.66.163',''),(655,'2024-12-16 21:43:02pm','Home/index','173.252.83.10',''),(656,'2024-12-17 20:03:06pm','Home/index','121.74.111.88',''),(657,'2024-12-18 03:22:25am','Home/index','45.202.30.35',''),(658,'2024-12-18 20:15:50pm','Home/index','165.227.218.41',''),(659,'2024-12-18 20:15:52pm','Home/index','165.227.218.41',''),(660,'2024-12-19 03:46:09am','Home/index','66.249.66.166',''),(661,'2024-12-19 20:41:59pm','Home/index','80.1.58.9',''),(662,'2024-12-20 18:47:24pm','Home/index','167.94.145.97',''),(663,'2024-12-20 19:30:00pm','Home/index','199.45.155.76',''),(664,'2024-12-20 21:34:03pm','About Us','57.141.0.22',''),(665,'2024-12-20 23:20:29pm','Home/meeting','57.141.0.8',''),(666,'2024-12-21 12:04:00pm','Home/index','66.249.66.162',''),(667,'2024-12-21 13:43:59pm','Home/index','66.249.66.65',''),(668,'2024-12-21 13:57:24pm','About Us','66.249.66.65',''),(669,'2024-12-21 16:34:27pm','Home/index','5.161.194.250',''),(670,'2024-12-22 01:31:25am','Home/index','52.221.186.210',''),(671,'2024-12-22 07:41:05am','Home/index','66.220.149.20',''),(672,'2024-12-23 03:30:30am','Home/index','115.231.78.15',''),(673,'2024-12-23 03:30:32am','Home/index','115.231.78.15',''),(674,'2024-12-23 03:30:36am','Home/index','115.231.78.15',''),(675,'2024-12-23 03:30:37am','Home/index','115.231.78.15',''),(676,'2024-12-25 15:05:26pm','Home/index','51.81.46.212',''),(677,'2024-12-25 21:04:44pm','Home/index','176.61.96.170',''),(678,'2024-12-28 08:00:01am','Home/index','157.245.45.88',''),(679,'2024-12-28 08:00:05am','Home/index','157.245.45.88',''),(680,'2024-12-29 19:33:48pm','About Us','57.141.0.4',''),(681,'2024-12-30 08:50:06am','Home/index','167.94.145.107',''),(682,'2024-12-30 14:54:32pm','About Us','57.141.0.16',''),(683,'2024-12-30 15:06:54pm','Home/index','54.218.56.244',''),(684,'2025-01-01 09:32:54am','Home/index','165.22.228.102',''),(685,'2025-01-01 09:32:56am','Home/index','165.22.228.102',''),(686,'2025-01-03 04:20:12am','Home/index','35.91.138.213',''),(687,'2025-01-06 01:41:40am','Home/index','154.216.20.3',''),(688,'2025-01-06 02:14:46am','Home/index','87.236.176.113',''),(689,'2025-01-06 05:53:46am','Home/index','87.236.176.20',''),(690,'2025-01-06 17:42:38pm','Home/index','3.254.48.49',''),(691,'2025-01-06 19:49:23pm','Home/index','3.254.175.173',''),(692,'2025-01-08 06:39:31am','Home/index','37.228.243.73',''),(693,'2025-01-09 22:50:39pm','Home/index','207.154.242.237',''),(694,'2025-01-09 22:50:40pm','Home/index','207.154.242.237',''),(695,'2025-01-11 07:28:47am','Home/index','139.59.46.219',''),(696,'2025-01-11 07:28:50am','Home/index','139.59.46.219',''),(697,'2025-01-11 22:23:12pm','Home/index','139.59.166.206',''),(698,'2025-01-11 22:23:13pm','Home/index','139.59.166.206',''),(699,'2025-01-13 19:15:18pm','Home/index','66.249.72.135',''),(700,'2025-01-13 23:15:31pm','Home/index','216.113.25.58',''),(701,'2025-01-15 06:18:45am','Home/index','167.94.146.51',''),(702,'2025-01-15 06:56:52am','Home/index','167.172.110.199',''),(703,'2025-01-15 06:56:53am','Home/index','167.172.110.199',''),(704,'2025-01-15 18:57:31pm','Home/index','173.178.184.121',''),(705,'2025-01-15 20:08:29pm','Home/index','115.231.78.8',''),(706,'2025-01-15 20:08:31pm','Home/index','115.231.78.8',''),(707,'2025-01-15 20:08:40pm','Home/index','115.231.78.8',''),(708,'2025-01-15 20:08:42pm','Home/index','115.231.78.8',''),(709,'2025-01-15 20:35:11pm','Home/index','35.81.170.101',''),(710,'2025-01-19 03:39:35am','Home/index','124.236.100.56',''),(711,'2025-01-19 04:52:00am','Home/index','124.236.100.56',''),(712,'2025-01-19 16:54:17pm','About Us','66.249.66.64',''),(713,'2025-01-19 19:15:27pm','Home/index','66.249.66.64',''),(714,'2025-01-21 02:51:16am','Home/index','66.249.79.162',''),(715,'2025-01-21 05:47:21am','Home/index','121.4.105.222',''),(716,'2025-01-21 16:16:18pm','Home/meeting','167.99.169.32',''),(717,'2025-01-21 16:24:44pm','About Us','167.99.110.58',''),(718,'2025-01-21 16:50:54pm','Home/index','167.99.110.58',''),(719,'2025-01-21 16:58:13pm','About Us','167.99.173.107',''),(720,'2025-01-21 17:05:46pm','Home/index','138.68.42.234',''),(721,'2025-01-21 17:12:02pm','Home/index','167.99.166.245',''),(722,'2025-01-21 17:17:54pm','About Us','143.110.129.56',''),(723,'2025-01-21 19:10:33pm','Home/index','37.228.234.245',''),(724,'2025-01-23 07:57:16am','About Us','57.141.0.8',''),(725,'2025-01-23 18:37:12pm','Home/index','66.249.66.66',''),(726,'2025-01-23 18:56:58pm','Home/index','66.249.79.32',''),(727,'2025-01-23 21:02:11pm','About Us','57.141.0.24',''),(728,'2025-01-23 22:17:24pm','About Us','66.249.66.66',''),(729,'2025-01-23 23:19:28pm','About Us','66.249.66.66',''),(730,'2025-01-24 16:19:32pm','Home/index','51.81.46.212',''),(731,'2025-01-25 09:38:40am','About Us','57.141.0.9',''),(732,'2025-01-25 17:52:52pm','Home/index','139.59.29.226',''),(733,'2025-01-25 17:52:57pm','Home/index','139.59.29.226',''),(734,'2025-01-26 07:49:40am','Home/index','47.88.78.6',''),(735,'2025-01-26 12:09:29pm','Home/index','66.249.65.227',''),(736,'2025-01-26 15:29:25pm','About Us','66.249.65.227',''),(737,'2025-01-27 11:20:28am','Home/index','34.122.147.229',''),(738,'2025-01-27 11:20:37am','Home/index','205.169.39.54',''),(739,'2025-01-27 11:20:39am','Home/index','205.169.39.72',''),(740,'2025-01-27 11:20:57am','Home/index','205.169.39.72',''),(741,'2025-01-27 22:17:37pm','Home/index','45.55.71.169',''),(742,'2025-01-27 22:17:38pm','Home/index','45.55.71.169',''),(743,'2025-01-28 00:28:21am','Home/index','157.245.201.195',''),(744,'2025-01-28 02:42:43am','Home/index','198.44.140.145',''),(745,'2025-01-29 16:59:44pm','Home/index','104.152.52.59',''),(746,'2025-01-29 19:51:20pm','Home/index','64.227.167.43',''),(747,'2025-01-29 19:51:23pm','Home/index','64.227.167.43',''),(748,'2025-01-29 23:09:17pm','Home/index','143.198.100.250',''),(749,'2025-01-29 23:09:19pm','Home/index','143.198.100.250',''),(750,'2025-01-31 22:22:47pm','Home/index','46.101.34.75',''),(751,'2025-01-31 22:22:48pm','Home/index','46.101.34.75',''),(752,'2025-02-03 18:50:24pm','Home/index','54.77.69.122',''),(753,'2025-02-04 00:41:50am','Home/index','18.201.45.45',''),(754,'2025-02-04 03:59:51am','Home/index','3.254.117.143',''),(755,'2025-02-04 21:47:27pm','Home/index','45.55.92.193',''),(756,'2025-02-04 21:47:31pm','Home/index','45.55.92.193',''),(757,'2025-02-05 23:12:09pm','Home/index','104.152.52.60',''),(758,'2025-02-06 01:39:18am','Home/index','66.249.66.66',''),(759,'2025-02-07 00:36:40am','Home/index','45.55.67.220',''),(760,'2025-02-07 00:36:42am','Home/index','45.55.67.220',''),(761,'2025-02-08 05:33:49am','Home/index','64.23.175.192',''),(762,'2025-02-08 05:33:51am','Home/index','64.23.175.192',''),(763,'2025-02-09 03:45:48am','Home/index','54.84.151.124',''),(764,'2025-02-09 19:40:43pm','Home/index','45.87.212.125',''),(765,'2025-02-12 10:19:48am','Home/index','167.172.39.116',''),(766,'2025-02-12 10:19:49am','Home/index','167.172.39.116',''),(767,'2025-02-12 19:06:01pm','Home/index','18.246.16.45',''),(768,'2025-02-12 22:32:19pm','Home/index','104.152.52.55',''),(769,'2025-02-13 09:32:53am','Home/index','35.171.144.152',''),(770,'2025-02-13 21:44:01pm','Home/index','87.236.176.8',''),(771,'2025-02-14 06:07:42am','Home/index','87.236.176.185',''),(772,'2025-02-15 02:59:19am','Home/index','205.210.31.43',''),(773,'2025-02-15 18:09:05pm','Home/index','205.210.31.141',''),(774,'2025-02-16 03:03:37am','Home/index','35.181.58.59',''),(775,'2025-02-16 06:37:54am','Home/index','198.235.24.176',''),(776,'2025-02-16 18:09:01pm','About Us','57.141.0.20',''),(777,'2025-02-16 23:55:36pm','Home/index','198.235.24.58',''),(778,'2025-02-17 19:54:25pm','Home/index','207.241.235.133',''),(779,'2025-02-19 20:23:20pm','Home/index','104.152.52.58',''),(780,'2025-02-21 17:12:41pm','About Us','57.141.0.1',''),(781,'2025-02-22 04:02:48am','Home/index','159.223.231.97',''),(782,'2025-02-22 04:02:50am','Home/index','159.223.231.97',''),(783,'2025-02-22 04:43:23am','About Us','57.141.0.5',''),(784,'2025-02-24 03:51:21am','Home/index','198.235.24.144',''),(785,'2025-02-24 07:57:41am','Home/index','198.235.24.153',''),(786,'2025-02-24 11:39:22am','About Us','57.141.0.2',''),(787,'2025-02-26 08:10:26am','Home/index','147.182.155.241',''),(788,'2025-02-26 08:10:28am','Home/index','147.182.155.241',''),(789,'2025-02-26 22:30:30pm','Home/index','104.152.52.67',''),(790,'2025-02-28 11:03:05am','Home/index','206.168.34.192',''),(791,'2025-02-28 11:57:26am','Home/index','206.168.34.67',''),(792,'2025-03-01 07:48:16am','About Us','57.141.0.3',''),(793,'2025-03-02 18:27:26pm','About Us','57.141.0.3',''),(794,'2025-03-03 04:05:11am','About Us','57.141.0.20',''),(795,'2025-03-03 08:57:26am','Home/index','198.235.24.15',''),(796,'2025-03-04 09:59:38am','Home/index','150.40.242.182',''),(797,'2025-03-05 19:01:28pm','Home/index','47.82.11.208',''),(798,'2025-03-05 20:07:12pm','Home/index','104.152.52.70',''),(799,'2025-03-06 08:05:47am','Home/index','47.79.122.126',''),(800,'2025-03-06 09:26:33am','Home/index','54.171.100.41',''),(801,'2025-03-06 10:17:40am','Home/index','47.79.98.210',''),(802,'2025-03-06 11:25:07am','Home/index','34.253.195.49',''),(803,'2025-03-07 07:27:46am','Home/index','47.82.11.122',''),(804,'2025-03-07 10:36:12am','Home/index','47.79.98.210',''),(805,'2025-03-07 16:46:31pm','Home/index','47.82.11.61',''),(806,'2025-03-07 21:04:48pm','Home/index','47.79.3.239',''),(807,'2025-03-08 06:19:00am','Home/index','64.23.135.98',''),(808,'2025-03-08 06:19:03am','Home/index','64.23.135.98',''),(809,'2025-03-09 08:39:01am','Home/index','47.82.10.152',''),(810,'2025-03-09 08:39:03am','Home/index','47.82.10.88',''),(811,'2025-03-09 10:44:21am','Home/index','47.82.9.41',''),(812,'2025-03-09 18:59:35pm','Home/index','47.82.9.17',''),(813,'2025-03-09 22:34:51pm','Home/index','47.79.98.205',''),(814,'2025-03-09 22:40:06pm','Home/index','47.82.9.37',''),(815,'2025-03-10 01:09:05am','About Us','57.141.0.26',''),(816,'2025-03-10 02:26:54am','Home/index','47.82.11.192',''),(817,'2025-03-10 10:03:08am','Home/index','47.82.10.195',''),(818,'2025-03-10 12:00:58pm','Home/index','47.82.10.89',''),(819,'2025-03-11 13:16:37pm','Home/index','47.82.10.128',''),(820,'2025-03-11 16:48:53pm','About Us','57.141.0.17',''),(821,'2025-03-12 07:46:09am','Home/index','68.183.159.48',''),(822,'2025-03-12 07:46:11am','Home/index','68.183.159.48',''),(823,'2025-03-12 10:56:19am','Home/index','3.95.255.58',''),(824,'2025-03-12 10:56:20am','Home/index','3.238.102.238',''),(825,'2025-03-12 12:49:42pm','Home/index','47.79.123.158',''),(826,'2025-03-12 20:13:24pm','Home/index','104.152.52.68',''),(827,'2025-03-14 18:58:40pm','Home/index','34.223.52.134',''),(828,'2025-03-17 15:38:54pm','About Us','57.141.0.28',''),(829,'2025-03-18 00:49:16am','Home/index','47.82.10.119',''),(830,'2025-03-19 10:50:42am','Home/index','47.82.11.135',''),(831,'2025-03-19 22:54:26pm','Home/index','104.152.52.60',''),(832,'2025-03-20 06:23:17am','Home/index','162.142.125.123',''),(833,'2025-03-21 17:48:50pm','About Us','57.141.0.16',''),(834,'2025-03-22 00:19:15am','Home/index','35.175.245.221',''),(835,'2025-03-22 05:31:17am','Home/index','159.203.122.98',''),(836,'2025-03-22 05:31:19am','Home/index','159.203.122.98',''),(837,'2025-03-24 14:30:49pm','Home/index','51.81.46.212',''),(838,'2025-03-25 00:07:09am','Home/index','185.247.137.215',''),(839,'2025-03-25 00:52:56am','Home/index','185.247.137.151',''),(840,'2025-03-25 19:09:01pm','Home/index','90.206.38.72',''),(841,'2025-03-25 22:05:39pm','About Us','57.141.0.10',''),(842,'2025-03-26 09:50:18am','Home/index','206.81.15.241',''),(843,'2025-03-26 09:50:20am','Home/index','206.81.15.241',''),(844,'2025-03-27 00:19:33am','Home/index','104.152.52.63',''),(845,'2025-03-29 17:27:07pm','Home/index','207.241.225.134',''),(846,'2025-03-29 21:53:45pm','Home/index','195.211.77.140',''),(847,'2025-03-29 21:53:51pm','Home/index','195.211.77.142',''),(848,'2025-03-30 00:26:59am','Home/index','171.244.43.14',''),(849,'2025-03-30 01:11:14am','Home/index','207.241.225.134',''),(850,'2025-03-30 01:52:42am','Home/index','115.231.78.2',''),(851,'2025-03-30 01:52:50am','Home/index','115.231.78.2',''),(852,'2025-03-30 01:52:52am','Home/index','115.231.78.2',''),(853,'2025-03-30 02:27:08am','About Us','57.141.0.14',''),(854,'2025-03-30 03:25:29am','Home/index','171.244.43.14',''),(855,'2025-03-30 03:41:16am','Home/index','133.242.174.119',''),(856,'2025-03-30 03:59:15am','Home/index','195.211.77.140',''),(857,'2025-03-30 04:24:27am','Home/index','195.211.77.142',''),(858,'2025-03-30 15:03:11pm','Home/index','188.165.87.105',''),(859,'2025-03-30 15:06:00pm','Home/index','188.165.87.98',''),(860,'2025-03-30 20:36:42pm','Home/index','169.150.201.33',''),(861,'2025-03-30 21:49:21pm','Home/index','143.198.166.129',''),(862,'2025-03-30 21:49:23pm','Home/index','143.198.166.129',''),(863,'2025-04-01 22:54:05pm','Home/index','139.59.185.27',''),(864,'2025-04-01 22:54:06pm','Home/index','139.59.185.27',''),(865,'2025-04-02 04:40:41am','Home/index','124.236.100.56',''),(866,'2025-04-02 08:35:15am','Home/index','124.236.100.56',''),(867,'2025-04-03 00:29:32am','Home/index','104.152.52.58',''),(868,'2025-04-05 15:54:22pm','Home/index','157.245.69.53',''),(869,'2025-04-05 15:54:23pm','Home/index','157.245.69.53',''),(870,'2025-04-05 19:45:55pm','Home/index','3.255.246.144',''),(871,'2025-04-06 00:31:08am','Home/index','44.193.11.208',''),(872,'2025-04-06 00:31:10am','Home/index','3.238.147.168',''),(873,'2025-04-07 06:06:56am','Home/index','205.210.31.20',''),(874,'2025-04-07 15:13:16pm','Home/index','34.243.64.213',''),(875,'2025-04-07 20:08:23pm','Home/index','3.249.208.146',''),(876,'2025-04-07 22:41:28pm','Home/index','147.182.246.31',''),(877,'2025-04-07 22:41:30pm','Home/index','147.182.246.31',''),(878,'2025-04-08 03:18:26am','Home/index','145.220.91.19',''),(879,'2025-04-09 00:58:58am','Home/index','35.95.102.224',''),(880,'2025-04-09 07:20:06am','Home/index','165.227.129.176',''),(881,'2025-04-09 07:20:07am','Home/index','165.227.129.176',''),(882,'2025-04-09 23:20:50pm','Home/index','159.89.116.238',''),(883,'2025-04-09 23:20:52pm','Home/index','159.89.116.238',''),(884,'2025-04-10 00:31:45am','Home/index','104.152.52.55',''),(885,'2025-04-13 15:22:27pm','Home/index','198.235.24.44',''),(886,'2025-04-14 07:01:32am','Home/index','198.235.24.147',''),(887,'2025-04-15 20:54:16pm','About Us','57.141.0.4',''),(888,'2025-04-16 05:29:22am','Home/index','52.47.204.10',''),(889,'2025-04-16 22:59:53pm','Home/index','199.45.155.92',''),(890,'2025-04-17 14:30:39pm','Home/index','197.232.143.54',''),(891,'2025-04-17 14:30:48pm','About Us','197.232.143.54',''),(892,'2025-04-17 21:52:24pm','Home/index','123.207.198.35',''),(893,'2025-04-18 08:35:04am','About Us','197.232.62.227',''),(894,'2025-04-19 08:56:07am','About Us','197.232.62.225',''),(895,'2025-04-19 09:14:01am','Home/index','188.166.153.150',''),(896,'2025-04-19 09:14:02am','Home/index','188.166.153.150',''),(897,'2025-04-20 22:24:41pm','About Us','66.249.74.102',''),(898,'2025-04-21 13:49:59pm','Home/index','88.218.193.103',''),(899,'2025-04-23 01:11:29am','Home/index','34.32.161.52',''),(900,'2025-04-23 12:50:30pm','Home/index','152.42.131.46',''),(901,'2025-04-23 12:50:32pm','Home/index','152.42.131.46',''),(902,'2025-04-23 20:24:11pm','Home/index','135.148.100.196',''),(903,'2025-04-25 10:36:33am','Home/index','185.247.137.128',''),(904,'2025-04-26 00:05:38am','Home/index','87.236.176.196',''),(905,'2025-04-26 02:19:51am','Home/index','192.175.111.228',''),(906,'2025-04-26 02:19:52am','Home/index','64.15.129.125',''),(907,'2025-04-26 02:19:56am','Home/index','192.175.111.251',''),(908,'2025-04-26 02:19:57am','Home/index','64.15.129.108',''),(909,'2025-04-26 09:25:00am','Home/index','183.207.45.104',''),(910,'2025-04-26 09:25:17am','Home/index','183.207.45.104',''),(911,'2025-04-26 09:25:24am','About Us','183.207.45.104',''),(912,'2025-04-26 09:25:25am','About Us','183.207.45.104',''),(913,'2025-04-26 09:25:25am','Home/meeting','183.207.45.104',''),(914,'2025-04-26 09:25:26am','Home/index','183.207.45.104',''),(915,'2025-04-30 21:46:49pm','Home/index','78.135.238.245',''),(916,'2025-05-03 08:12:14am','Home/index','52.208.217.25',''),(917,'2025-05-03 09:44:28am','About Us','192.178.6.99',''),(918,'2025-05-03 14:18:08pm','Home/meeting','57.141.0.14',''),(919,'2025-05-03 18:21:03pm','Home/index','64.23.230.234',''),(920,'2025-05-03 18:21:07pm','Home/index','64.23.230.234',''),(921,'2025-05-03 21:39:26pm','Home/index','205.210.31.158',''),(922,'2025-05-04 06:47:53am','Home/index','198.235.24.11',''),(923,'2025-05-04 14:06:43pm','About Us','66.249.70.36',''),(924,'2025-05-06 18:03:38pm','Home/meeting','52.167.144.181',''),(925,'2025-05-06 19:09:37pm','Home/meeting','57.141.0.15',''),(926,'2025-05-06 20:08:11pm','Home/index','50.48.65.113',''),(927,'2025-05-07 12:48:17pm','Home/index','164.90.174.133',''),(928,'2025-05-07 12:48:18pm','Home/index','164.90.174.133',''),(929,'2025-05-08 19:22:26pm','Home/index','44.247.104.117',''),(930,'2025-05-10 03:38:34am','Home/index','199.45.155.97',''),(931,'2025-05-11 03:33:56am','Home/index','34.245.217.23',''),(932,'2025-05-11 06:46:57am','Home/index','34.254.155.228',''),(933,'2025-05-11 08:02:26am','Home/index','199.45.154.126',''),(934,'2025-05-12 02:04:49am','Home/index','176.98.186.51',''),(935,'2025-05-12 02:04:54am','Home/index','176.98.186.51',''),(936,'2025-05-12 07:46:04am','Home/index','44.203.232.234',''),(937,'2025-05-12 10:22:18am','About Us','66.249.70.36',''),(938,'2025-05-12 12:47:46pm','About Us','102.0.20.6',''),(939,'2025-05-12 12:48:08pm','About Us','102.0.20.6',''),(940,'2025-05-13 20:05:33pm','Home/index','44.234.46.5',''),(941,'2025-05-15 15:36:02pm','Home/index','47.82.61.147',''),(942,'2025-05-16 13:20:58pm','About Us','157.55.39.16',''),(943,'2025-05-16 14:11:18pm','About Us','66.249.70.34',''),(944,'2025-05-16 21:47:13pm','Home/index','47.79.6.193',''),(945,'2025-05-17 02:38:04am','Home/index','47.82.61.6',''),(946,'2025-05-17 08:42:09am','Home/index','47.82.60.22',''),(947,'2025-05-17 11:41:48am','Home/index','64.23.131.18',''),(948,'2025-05-17 11:41:50am','Home/index','64.23.131.18',''),(949,'2025-05-17 12:46:01pm','Home/index','47.82.60.126',''),(950,'2025-05-17 14:02:00pm','Home/index','47.82.61.203',''),(951,'2025-05-17 16:12:16pm','Home/index','47.82.60.117',''),(952,'2025-05-17 18:20:15pm','Home/index','47.82.60.207',''),(953,'2025-05-17 19:08:39pm','Home/index','47.79.122.126',''),(954,'2025-05-17 21:20:14pm','Home/index','47.82.60.18',''),(955,'2025-05-17 23:16:35pm','Home/index','47.82.61.20',''),(956,'2025-05-18 02:34:15am','Home/index','47.79.5.207',''),(957,'2025-05-18 04:27:39am','Home/index','47.82.60.55',''),(958,'2025-05-18 05:07:33am','Home/index','196.251.81.203',''),(959,'2025-05-18 07:50:41am','Home/index','47.82.60.25',''),(960,'2025-05-18 09:14:34am','Home/index','115.231.78.6',''),(961,'2025-05-18 13:17:29pm','Home/index','111.7.100.27',''),(962,'2025-05-18 13:17:30pm','Home/index','111.7.100.27',''),(963,'2025-05-18 13:26:41pm','Home/index','111.7.100.24',''),(964,'2025-05-18 13:26:42pm','Home/index','111.7.100.27',''),(965,'2025-05-18 15:02:31pm','Home/index','47.79.98.118',''),(966,'2025-05-18 19:28:26pm','Home/index','47.82.60.15',''),(967,'2025-05-18 21:35:54pm','Home/index','47.82.61.57',''),(968,'2025-05-18 23:01:33pm','Home/index','47.82.60.22',''),(969,'2025-05-19 10:58:10am','Home/index','47.82.61.169',''),(970,'2025-05-19 18:24:10pm','Home/index','8.219.221.124',''),(971,'2025-05-19 18:24:11pm','Home/index','8.219.247.221',''),(972,'2025-05-19 19:21:41pm','Home/index','47.236.242.243',''),(973,'2025-05-19 19:21:42pm','Home/index','8.219.254.90',''),(974,'2025-05-20 07:27:17am','Home/index','47.82.60.110',''),(975,'2025-05-20 09:33:34am','Home/index','47.82.61.251',''),(976,'2025-05-21 04:43:49am','Home/index','183.207.48.140',''),(977,'2025-05-21 04:44:06am','Home/index','183.207.48.140',''),(978,'2025-05-21 04:44:12am','About Us','183.207.48.140',''),(979,'2025-05-21 04:44:12am','About Us','183.207.48.140',''),(980,'2025-05-21 04:44:13am','Home/meeting','183.207.48.140',''),(981,'2025-05-21 04:44:13am','Home/index','183.207.48.140',''),(982,'2025-05-21 04:44:26am','Home/index','142.93.99.200',''),(983,'2025-05-21 04:44:28am','Home/index','142.93.99.200',''),(984,'2025-05-21 14:05:37pm','Home/index','47.82.60.102',''),(985,'2025-05-21 15:34:20pm','Home/index','47.82.61.90',''),(986,'2025-05-21 16:34:03pm','Home/index','47.82.61.120',''),(987,'2025-05-21 18:26:10pm','Home/index','47.82.60.218',''),(988,'2025-05-21 19:25:32pm','Home/index','47.82.60.93',''),(989,'2025-05-21 21:12:57pm','Home/index','47.82.60.76',''),(990,'2025-05-21 22:16:30pm','Home/index','47.82.60.178',''),(991,'2025-05-21 23:38:52pm','Home/index','47.79.5.207',''),(992,'2025-05-22 05:20:03am','Home/index','47.82.61.242',''),(993,'2025-05-22 07:03:04am','Home/index','47.82.61.248',''),(994,'2025-05-22 08:48:06am','Home/index','47.82.61.163',''),(995,'2025-05-22 10:46:24am','Home/index','47.82.61.75',''),(996,'2025-05-22 12:47:01pm','Home/index','47.82.60.11',''),(997,'2025-05-22 14:47:04pm','Home/index','47.82.61.109',''),(998,'2025-05-22 16:49:53pm','Home/index','47.79.6.241',''),(999,'2025-05-22 18:40:47pm','Home/index','47.82.60.144',''),(1000,'2025-05-22 21:02:38pm','Home/index','47.82.61.151',''),(1001,'2025-05-22 22:58:47pm','Home/index','47.82.61.185',''),(1002,'2025-05-23 02:56:34am','Home/index','47.79.98.204',''),(1003,'2025-05-23 05:30:04am','Home/index','47.82.60.98',''),(1004,'2025-05-23 06:35:12am','Home/index','47.79.98.204',''),(1005,'2025-05-23 07:44:21am','Home/index','47.82.60.22',''),(1006,'2025-05-23 09:10:09am','Home/index','47.82.61.244',''),(1007,'2025-05-23 11:33:44am','Home/index','47.82.60.88',''),(1008,'2025-05-23 12:41:23pm','Home/index','47.79.98.118',''),(1009,'2025-05-23 14:31:30pm','Home/index','47.82.60.17',''),(1010,'2025-05-23 17:09:04pm','Home/index','47.82.60.239',''),(1011,'2025-05-23 20:07:43pm','Home/index','47.82.60.190',''),(1012,'2025-05-23 20:40:34pm','Home/index','51.81.46.212',''),(1013,'2025-05-24 07:31:41am','Home/index','47.79.118.217',''),(1014,'2025-05-24 16:52:50pm','Home/index','47.79.2.34',''),(1015,'2025-05-24 19:35:19pm','Home/index','47.82.60.81',''),(1016,'2025-05-25 02:38:29am','Home/index','47.82.61.155',''),(1017,'2025-05-25 09:15:13am','Home/index','47.79.98.118',''),(1018,'2025-05-25 21:07:16pm','Home/index','47.82.61.23',''),(1019,'2025-05-25 23:58:41pm','Home/index','47.82.60.210',''),(1020,'2025-05-26 02:26:10am','Home/index','47.82.60.218',''),(1021,'2025-05-26 08:22:48am','Home/index','87.236.176.206',''),(1022,'2025-05-26 17:32:36pm','Home/index','87.236.176.119',''),(1023,'2025-05-26 23:26:20pm','Home/index','47.79.5.88',''),(1024,'2025-05-26 23:51:18pm','About Us','66.249.70.34',''),(1025,'2025-05-27 00:27:29am','Home/index','47.79.98.205',''),(1026,'2025-05-27 02:27:18am','Home/index','47.82.60.193',''),(1027,'2025-05-27 04:04:25am','Home/index','47.79.98.245',''),(1028,'2025-05-27 05:34:32am','Home/index','47.82.60.147',''),(1029,'2025-05-27 08:52:26am','Home/index','47.79.123.158',''),(1030,'2025-05-27 19:43:29pm','Home/index','47.82.60.131',''),(1031,'2025-05-27 20:03:29pm','Home/index','41.90.4.149',''),(1032,'2025-05-27 21:18:24pm','Home/index','47.82.60.226',''),(1033,'2025-05-28 00:33:33am','Home/index','47.82.60.197',''),(1034,'2025-05-29 11:20:30am','Home/index','34.122.147.229',''),(1035,'2025-05-29 11:20:32am','Home/index','205.169.39.190',''),(1036,'2025-05-29 11:20:40am','Home/index','205.169.39.190',''),(1037,'2025-05-29 11:21:19am','Home/index','34.118.36.77',''),(1038,'2025-05-29 11:21:58am','Home/index','205.169.39.45',''),(1039,'2025-05-29 11:26:52am','Home/index','195.211.77.140',''),(1040,'2025-05-29 11:26:57am','Home/index','195.211.77.142',''),(1041,'2025-05-29 11:34:59am','Home/index','146.70.185.32',''),(1042,'2025-05-29 13:37:37pm','Home/index','195.211.77.140',''),(1043,'2025-05-30 08:00:13am','Home/index','52.87.155.151',''),(1044,'2025-05-30 08:00:13am','Home/index','52.87.155.151',''),(1045,'2025-05-30 08:00:14am','Home/index','52.87.155.151',''),(1046,'2025-05-30 10:28:54am','Home/index','103.214.20.138',''),(1047,'2025-05-30 12:23:05pm','Home/index','128.199.159.193',''),(1048,'2025-05-30 16:02:13pm','Home/index','159.89.31.156',''),(1049,'2025-05-30 18:24:32pm','Home/index','86.104.252.57',''),(1050,'2025-05-30 23:13:59pm','Home/index','159.89.5.227',''),(1051,'2025-05-31 04:32:02am','Home/index','104.248.55.225',''),(1052,'2025-05-31 04:32:04am','Home/index','104.248.55.225',''),(1053,'2025-05-31 10:24:25am','Home/index','138.2.110.170',''),(1054,'2025-05-31 18:46:34pm','Home/index','91.231.89.39',''),(1055,'2025-05-31 18:49:43pm','Home/index','91.231.89.124',''),(1056,'2025-06-01 17:38:06pm','Home/index','3.249.16.23',''),(1057,'2025-06-02 10:19:51am','About Us','91.231.89.22',''),(1058,'2025-06-02 10:22:20am','Home/meeting','91.231.89.101',''),(1059,'2025-06-02 10:23:51am','About Us','91.231.89.97',''),(1060,'2025-06-02 10:26:16am','Home/index','91.231.89.23',''),(1061,'2025-06-03 06:29:18am','Home/index','107.174.224.18',''),(1062,'2025-06-04 02:25:12am','Home/index','47.82.60.183',''),(1063,'2025-06-04 06:09:59am','Home/index','47.79.2.34',''),(1064,'2025-06-04 09:13:52am','Home/index','47.82.60.15',''),(1065,'2025-06-04 11:53:08am','Home/index','47.79.123.171',''),(1066,'2025-06-04 13:49:38pm','Home/index','47.79.121.39',''),(1067,'2025-06-04 14:06:53pm','Home/index','138.197.187.192',''),(1068,'2025-06-04 14:06:55pm','Home/index','138.197.187.192',''),(1069,'2025-06-04 16:34:47pm','Home/index','47.82.60.103',''),(1070,'2025-06-04 18:36:46pm','Home/index','47.82.60.166',''),(1071,'2025-06-04 18:39:24pm','Home/index','94.159.108.209',''),(1072,'2025-06-04 22:17:06pm','Home/index','47.79.4.196',''),(1073,'2025-06-05 00:11:16am','Home/index','47.82.60.216',''),(1074,'2025-06-05 06:30:35am','Home/index','47.82.60.159',''),(1075,'2025-06-05 08:15:25am','Home/index','47.82.60.26',''),(1076,'2025-06-05 10:58:53am','Home/index','47.82.61.43',''),(1077,'2025-06-05 14:06:22pm','Home/index','47.79.5.88',''),(1078,'2025-06-07 06:36:15am','Home/index','205.210.31.170',''),(1079,'2025-06-07 13:32:03pm','Home/index','3.253.129.88',''),(1080,'2025-06-07 19:27:21pm','Home/index','54.229.91.147',''),(1081,'2025-06-09 19:32:52pm','Home/index','41.90.216.208',''),(1082,'2025-06-09 19:32:58pm','Home/index','66.249.93.135',''),(1083,'2025-06-09 19:33:01pm','Home/index','66.249.88.163',''),(1084,'2025-06-09 19:33:01pm','Home/index','74.125.210.34',''),(1085,'2025-06-11 13:27:13pm','Home/index','3.147.83.88',''),(1086,'2025-06-12 00:25:48am','Home/index','44.235.77.42',''),(1087,'2025-06-13 22:07:56pm','Home/index','34.16.183.135',''),(1088,'2025-06-14 06:20:27am','Home/index','167.71.1.207',''),(1089,'2025-06-14 06:20:29am','Home/index','167.71.1.207',''),(1090,'2025-06-15 07:57:31am','Home/index','35.180.100.190',''),(1091,'2025-06-15 23:53:05pm','Home/index','205.210.31.45',''),(1092,'2025-06-16 07:19:37am','Home/index','47.82.61.40',''),(1093,'2025-06-16 10:29:48am','Home/index','47.82.61.102',''),(1094,'2025-06-17 06:21:39am','Home/index','47.82.61.82',''),(1095,'2025-06-17 19:57:11pm','Home/index','47.82.62.28',''),(1096,'2025-06-18 14:02:12pm','Home/index','206.189.63.58',''),(1097,'2025-06-18 14:19:28pm','Home/index','47.82.62.41',''),(1098,'2025-06-18 22:34:54pm','Home/index','47.82.62.82',''),(1099,'2025-06-18 22:34:54pm','Home/index','47.82.62.82',''),(1100,'2025-06-18 22:34:54pm','Home/index','47.82.62.82',''),(1101,'2025-06-19 19:28:41pm','Home/index','40.77.167.25',''),(1102,'2025-06-19 21:03:43pm','Home/index','205.169.39.21',''),(1103,'2025-06-25 15:13:42pm','About Us','207.46.13.155',''),(1104,'2025-06-28 12:04:56pm','Home/index','167.99.130.147',''),(1105,'2025-06-28 12:04:57pm','Home/index','167.99.130.147',''); /*!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,'Green Savannah','Green Savannah','','greensavannah@gmail.com','','','','2016-12-24','12345678','','','','201807311533002481201606151466003799Handheld-Point-of-Sale.jpg','','','','','2023-11-28','342','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:16:22