/home/rokasa/dbs
/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: robisear_church -- ------------------------------------------------------ -- 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 `baptism_tbl` -- DROP TABLE IF EXISTS `baptism_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `baptism_tbl` ( `baptism_id` int(11) NOT NULL AUTO_INCREMENT, `member` int(11) NOT NULL, `pastor` int(11) NOT NULL, `church` int(11) NOT NULL, `baptism_cert` varchar(100) NOT NULL, `date_of_baptism` date NOT NULL, `comment` text DEFAULT NULL, `recorded_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`baptism_id`) ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `baptism_tbl` -- LOCK TABLES `baptism_tbl` WRITE; /*!40000 ALTER TABLE `baptism_tbl` DISABLE KEYS */; INSERT INTO `baptism_tbl` VALUES (10,10,1,1,'','2019-07-16','','2019-07-16 15:41:48'),(11,6,2,2,'','2019-07-16','','2019-07-16 15:47:13'),(12,5,1,1,'','2019-07-16','','2019-07-16 23:17:35'),(13,12,2,2,'','2019-07-17','Testing','2019-07-17 14:48:59'),(14,13,2,2,'','2019-07-26','God\'s grace is sufficient','2019-07-31 10:15:05'),(15,19,6,6,'','2012-05-29','','2021-04-22 15:15:43'),(16,18,6,6,'','1983-02-01','','2021-04-22 15:15:55'),(17,17,6,6,'','1973-11-06','','2021-04-22 15:16:09'),(18,16,6,6,'','1974-10-02','','2021-04-22 15:16:34'),(19,15,6,6,'','2019-07-14','','2021-04-22 15:17:47'); /*!40000 ALTER TABLE `baptism_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `church_tbl` -- DROP TABLE IF EXISTS `church_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `church_tbl` ( `church_id` int(11) NOT NULL AUTO_INCREMENT, `created_by` int(11) NOT NULL, `church_name` varchar(100) NOT NULL, `member_prefix` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `logo` varchar(100) DEFAULT NULL, `motto` text DEFAULT NULL, `box` varchar(50) NOT NULL, `county` int(11) NOT NULL, `location` varchar(100) NOT NULL, `status` varchar(50) NOT NULL, `signup_date` date NOT NULL, `expiry` date NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`church_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `church_tbl` -- LOCK TABLES `church_tbl` WRITE; /*!40000 ALTER TABLE `church_tbl` DISABLE KEYS */; INSERT INTO `church_tbl` VALUES (1,1,'P.C.E.A Lurambi','PCEA','+254708843466','isaiah@gmail.com','ff507db031edec09bfc823bd205fe235.png','SERVING GOOD WITH OUR FAMILY','100',37,'Kefinco','Active','2019-05-01','2019-07-19','2019-05-01 09:50:07'),(2,2,'SPRINGS OF LIFE MINISTRIES CHURCH THIKA','ACK','+254709111111','info@springsoflife','e81cdbf709961d70a5c90eb2a3d7bdef.jpg','THE END IS NEAR','200',22,'Thika Town','Inactive','2019-05-01','2019-08-30','2019-05-01 17:38:08'),(3,3,'JUJA ACK','JACK','+254777777777','ACK@YAHOO.COM','4eeeddd871010cff4729a35af6fc37f2.png','PANDA MBEGU','300',47,'JUJA','Active','2019-07-15','2019-08-14','2019-07-15 19:08:58'),(4,4,'CATHOLIC KIRICHAGA','CAT','+254708843466','catho@yahoo.com','1ff79aae1c1f514c8c96936aa86f3585.png','CHURCH MOTTO','',20,'Kirinyaga','Active','2019-07-16','2019-08-15','2019-07-16 15:51:48'),(5,5,'LWANDA','DIT','0718667391','lwanda@gmail.com','e31ed19a56ed658346987bd821e61bd6.png','The best church to be','',42,'NAIROBI','Active','2021-04-22','2021-05-22','2021-04-22 09:23:48'),(6,6,'PCEA JUJA PARISH CHURCH','PCEAJUJA','07345256801','Info@jujaparishpresbytary.co.ke','de9f4232ae6ab650a4c4db1905943761.jpg','\".....Go ye into the nations and make disciples\' of me,Baptising them in the name of the Father ,The Son and The Holy spirit\"','',22,'JUJA','Active','2021-04-22','2021-05-22','2021-04-22 13:12:00'),(7,7,'PCEA BEREA CHURCH JUJA','Berea','0714933128','info@berea.org','1d7f135ec0d7d4f6bdb27daa43382fc8.png','','',22,'Juja','Active','2021-04-22','2021-05-22','2021-04-22 19:17:59'),(8,8,'P.C.E.A BEREA CHURCH GACHORORO JUJA','0000001','','',NULL,'','',22,'JUJA','Active','2021-07-24','2021-08-23','2021-07-24 11:24:50'),(9,10,'teresia','robi','','',NULL,'','',47,'kilimani','Active','2023-03-15','2023-04-14','2023-03-15 11:49:54'),(10,11,'me','mee','098765432','me@gmail.com',NULL,'meeee','',14,'meee','Active','2023-04-26','2023-05-26','2023-04-26 13:50:56'); /*!40000 ALTER TABLE `church_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `churchadmin_tbl` -- DROP TABLE IF EXISTS `churchadmin_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `churchadmin_tbl` ( `admin_id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) DEFAULT NULL, `admin_fname` varchar(50) NOT NULL, `admin_lname` varchar(50) NOT NULL, `admin_nationalid` varchar(50) NOT NULL, `admin_phone` varchar(50) NOT NULL, `admin_email` varchar(50) DEFAULT NULL, `admin_password` varchar(100) NOT NULL, `admin_status` varchar(15) NOT NULL, `admin_createddate` date NOT NULL, `admin_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`admin_id`) ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `churchadmin_tbl` -- LOCK TABLES `churchadmin_tbl` WRITE; /*!40000 ALTER TABLE `churchadmin_tbl` DISABLE KEYS */; INSERT INTO `churchadmin_tbl` VALUES (1,'Pst.ggff','Isaiah','Mutethia','66666666','+254708843466','isaiah@gmail.com','$2y$10$3JrEcg/dC7rOWq2z.LyYx.r64S4oybTQm.HyszmMBOpDu2Z8ZhXLm','Active','2019-05-01','2019-05-01 08:04:25'),(2,'Rev','Conard','Mayaka','77777777','+254702875292','mayakaconard@gmail.com','$2y$10$JeyyD9gCZsRfelL0gMI8JuhVZ24jzCnrY1WpJmo/xQcL7N3Bv.2d.','Active','2019-05-01','2019-05-01 09:00:03'),(3,NULL,'Denis','Karanja','99999999','+254711111111','','$2y$10$jAVVA./1dy3DizAWlbPzv.steV1jdcBIXeAnCE0SOCR3Ot1YwRZje','Active','2019-07-15','2019-07-15 15:26:19'),(4,'Rev.','Njuguna','Michael','44444444','+254708608486','','$2y$10$zzAeACyyY.SSrjnXbPMnMOymVNLqzpOuP4MJ.npXEeKamqdyqCgQW','Active','2019-07-16','2019-07-16 15:48:51'),(5,'Pst','robert','robert','12345678','0718667391','director@robisearch.com','$2y$10$4hlSetbp5aeJH9ZSrtvSv.O4/hqBskycYGy9Wg/vAiNfeznda7CMK','Active','2021-04-22','2021-04-22 09:22:08'),(6,NULL,'Shem','Murimi','364234','0798501338','murimishem@gmail.com','$2y$10$5SX7ZHxr2iO7Er/7X8Ktte3h3LuIcSx7gdmlhiTM/M2VB41bHzODy','Active','2021-04-22','2021-04-22 13:06:35'),(7,NULL,'Simon','Simon','28787248','0714933138','simonmugetha@gmail.com','$2y$10$qwK8enmDr7p0GV6iv4.H.uuReK9f9C.StVl1BqjOfBmtBgCSYez.W','Active','2021-04-22','2021-04-22 19:15:17'),(8,NULL,'TIMOTHY','TIMOTHY','28709951','0700677100','','$2y$10$ajL65PqXVpg/3Ct//tITFuaDuK/8dKkQ32kREOOnG0m7Bt/Gmrrs2','Active','2021-07-24','2021-07-24 11:23:17'),(9,NULL,'MANZALA','robert','87654321','0718667391','ROBERT@GMAIL.COM','$2y$10$NzZoDQMcFayi5qSufrx3tei9sGvGSJpxQ8t8otXUqyQqggkdtCQFy','Active','2022-01-16','2022-01-16 15:27:38'),(10,NULL,'antony','rama','26406146','254740587456','canonwere@gmail.com','$2y$10$YYT8MwgDZhubNW/izoJPyOf5WDUQUYFbxzcpJ/SFsl9yox18n6CUi','Active','2023-03-15','2023-03-15 11:48:30'),(11,NULL,'Nicholas','Kamau','543','254777882843','kamaunicholas02@gmail.com','$2y$10$oyo4/34HQ.JNXZX.G/xsUOflJi2hIuq1Og6Mj7ihkYMuF/koGigka','Active','2023-04-26','2023-04-26 13:49:31'),(12,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ','$2y$10$D.q9oDS18CFGpQqwpoY/bendi6j9v7PCzTPFQmz.3Q3qTsoHkg8RW','Active','2023-12-22','2023-12-22 12:50:06'),(13,NULL,'smGg)),,\",((\',','HHjd','Qjnm','lebd','TkjJ','$2y$10$XreTdD/MyYXtXhYIsfFhp.EjZGu1xKFrDcHSLwOkzMUUW/dPFDzwq','Active','2023-12-22','2023-12-22 12:50:09'),(14,NULL,'smGg\'GNzRIy<\'\">rrMSza','HHjd','Qjnm','lebd','TkjJ','$2y$10$caFwjqqFw4LFNo62BP0Zp.wn0DzC8Xrej88uYAaB7i/1bFw2mMKhu','Active','2023-12-22','2023-12-22 12:50:11'),(15,NULL,'smGg','HHjd,.\"(\'..,.)','Qjnm','lebd','TkjJ','$2y$10$JBHCk49wmPKv9zA8mPcGE.u1sa2RvSZR327wyLQun9siQMJxTvB3G','Active','2023-12-22','2023-12-22 12:50:13'),(16,NULL,'smGg','HHjd\'vqguId<\'\">pDDwAc','Qjnm','lebd','TkjJ','$2y$10$PjXDZc/R0GOmFIsy.OGLDegfD57FM0rX72NiBoS.eA8qxiebB2TBC','Active','2023-12-22','2023-12-22 12:50:15'),(17,NULL,'smGg','HHjd','Qjnm(\",,\',...(','lebd','TkjJ','$2y$10$skbGzKt6hBJC4XVIXZHbHe4OdTwrZnWZmsy35DCgCoU5Sjm1zaOv6','Active','2023-12-22','2023-12-22 12:50:17'),(18,NULL,'smGg','HHjd','Qjnm\'yVoDBM<\'\">KHMxOu','lebd','TkjJ','$2y$10$E29VtH7Gn1rgwk9v1qc8keNicpZJuFN1Z3xlB4fZtuDtRcgrb7Rkm','Active','2023-12-22','2023-12-22 12:50:19'),(19,NULL,'smGg','HHjd','Qjnm','lebd().))(\"(.\'','TkjJ','$2y$10$uKF8k1Ba/w8stz7PManaYuElBVjyzz4J.jA7ahAKTCBSa5AphONAm','Active','2023-12-22','2023-12-22 12:50:21'),(20,NULL,'smGg','HHjd','Qjnm','lebd\'BNAMgm<\'\">BNeUbk','TkjJ','$2y$10$Lr2ccnA4i.bCHsvDpGkXKO5w3himoeI6MOXdGGKGsPSH5BPlvlyZW','Active','2023-12-22','2023-12-22 12:50:23'),(21,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ),,\',(,)\".','$2y$10$WQii10E1ITNnnvaW5.SYvutYDHxgbfnrmSHQlNNt2oG92W9K8wJC.','Active','2023-12-22','2023-12-22 12:50:24'),(22,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ\'UAoezo<\'\">DmkYPN','$2y$10$AMbX0N3HM0NbNxSa/0.55egMitRj.7ZtSAnY1MJDUvK3RK4MZzII6','Active','2023-12-22','2023-12-22 12:50:26'),(23,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ','$2y$10$Niqr6QZeLXAbG/L/YkcOZu.KA12IAHboUQjjg.dc.K4ADkhYiCxn2','Active','2023-12-22','2023-12-22 12:50:27'),(24,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ','$2y$10$OEydyIv5gNibfoz.3EX4X.rC4N9gLU700rm.J68SMytfazSHuopVi','Active','2023-12-22','2023-12-22 12:50:28'),(25,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ','$2y$10$NitVgNZdzAa0VcIzQc8Nh.dgCInm6OXGfcfmpbQ6IMOmxHfkp/mhO','Active','2023-12-22','2023-12-22 12:50:29'),(26,NULL,'smGg','HHjd','Qjnm','lebd','TkjJ','$2y$10$FmYeBhHhZ16LylxB/NXxHO7d3LotWkU9ZpLjCjAL/LZMD6WgGirri','Active','2023-12-22','2023-12-22 12:50:30'),(27,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa','$2y$10$walv2/wgD9XiR2djEaxAUeYk9UorGx0EonxcBDw.PxVMKbC3uUh/m','Active','2023-12-24','2023-12-24 13:54:16'),(28,NULL,'MFEY())\'\"(.)..','PPFi','kWDP','RyYa','dMMa','$2y$10$spxZYBJsZcjUzX7BYalSUu2VFf4TiCfmmmUDN4wjbCBwFKiqg4D5C','Active','2023-12-24','2023-12-24 13:54:18'),(29,NULL,'MFEY\'Gkdmmb<\'\">AOtiCk','PPFi','kWDP','RyYa','dMMa','$2y$10$RCf3cSGJRdHbzultZj1GFuX5pYLxYBcTB.8d/UtaK6VrhucY/Knsa','Active','2023-12-24','2023-12-24 13:54:20'),(30,NULL,'MFEY','PPFi\"\'.).,..(,','kWDP','RyYa','dMMa','$2y$10$BECEUY0hZ73Y5/CNTHJyoOwb5DN1o/kUTdLe.RPODA.9zF.Lp5WiC','Active','2023-12-24','2023-12-24 13:54:22'),(31,NULL,'MFEY','PPFi\'iksknD<\'\">DHJoOc','kWDP','RyYa','dMMa','$2y$10$CNA4b05BikuS14eJShGWduVtin03XVcvoluKQ88VhJfSjN.h2Z.ku','Active','2023-12-24','2023-12-24 13:54:24'),(32,NULL,'MFEY','PPFi','kWDP\"),,).,,\',','RyYa','dMMa','$2y$10$cfOe6FWlRkNfSJvAlR5yB.cvr5Kn0XA2wtJJFN1GBL9nZRLrVU.Di','Active','2023-12-24','2023-12-24 13:54:26'),(33,NULL,'MFEY','PPFi','kWDP\'tPGNVf<\'\">JHgAfQ','RyYa','dMMa','$2y$10$67Ftj1ZMDeEnfYmEoaY2puBxhgnl.67E8tHyPCncGmD.oUNgaOqua','Active','2023-12-24','2023-12-24 13:54:28'),(34,NULL,'MFEY','PPFi','kWDP','RyYa())\".,.\'(,','dMMa','$2y$10$hr9OBDwVCwModuMe/3cwAu8O.WM8nNxbsIphYXnn9Y62O0EfSxWJG','Active','2023-12-24','2023-12-24 13:54:29'),(35,NULL,'MFEY','PPFi','kWDP','RyYa\'YSDJHS<\'\">ysbJGs','dMMa','$2y$10$glYH0EwlnHH2SXPAGbTr/u/vDA83wsC7t4PToSZ4eXRCSgklbqOKm','Active','2023-12-24','2023-12-24 13:54:31'),(36,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa)\'(.),.))\"','$2y$10$vgjpCpgjegEj6KUZfvxIWOE.kpU419R9tuIi8n.s0/L.E5FlWJJL6','Active','2023-12-24','2023-12-24 13:54:32'),(37,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa\'kGhBKm<\'\">XpDwju','$2y$10$CbEzUn3pBsk4IbUT2Xsjk.e7y.JD6z6I4vCVcylA1WuAyUAhhsag.','Active','2023-12-24','2023-12-24 13:54:34'),(38,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa','$2y$10$N7jryVuAXxE64eAswWnckOc7KQjtwM5Z8SojgOd4lnBkXNxW6tFea','Active','2023-12-24','2023-12-24 13:54:35'),(39,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa','$2y$10$6sRAnH2FJFrK4tCSSDbdVurvh8kPJyOpXf0FH4qfk94e80a7l/qUy','Active','2023-12-24','2023-12-24 13:54:36'),(40,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa','$2y$10$QeCCSGHxCSWerkUB/GlRaea7Izom8wT/g0uGxqmjaNgMwkMgIrFba','Active','2023-12-24','2023-12-24 13:54:37'),(41,NULL,'MFEY','PPFi','kWDP','RyYa','dMMa','$2y$10$.g/0Bw8lmxMgEJCGNoN.nOeDvDgYTb7mAJ3oTexCXNc1F4iqRDHfm','Active','2023-12-24','2023-12-24 13:54:38'); /*!40000 ALTER TABLE `churchadmin_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `county_tbl` -- DROP TABLE IF EXISTS `county_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `county_tbl` ( `county_id` int(11) NOT NULL AUTO_INCREMENT, `county_name` varchar(30) DEFAULT NULL, PRIMARY KEY (`county_id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `county_tbl` -- LOCK TABLES `county_tbl` WRITE; /*!40000 ALTER TABLE `county_tbl` DISABLE KEYS */; INSERT INTO `county_tbl` VALUES (1,'Mombasa'),(2,'Kwale'),(3,'Kilifi'),(4,'Tana River'),(5,'Lamu'),(6,'Taita-Taveta'),(7,'Garissa'),(8,'wajir'),(9,'Mandera'),(10,'Marsabit'),(11,'Isiolo'),(12,'Meru'),(13,'Tharaka-Nithi'),(14,'Embu'),(15,'Kitui'),(16,'Machakos'),(17,'Makueni'),(18,'Nyandarua'),(19,'Nyeri'),(20,'Kirinyaga'),(21,'Murang\'a'),(22,'Kiambu'),(23,'Turkana'),(24,'West Pokot'),(25,'Samburu'),(26,'Trans Nzoia'),(27,'Uasin Gishu'),(28,'Elgeyo-Marakwet'),(29,'Nandi'),(30,'Baringo'),(31,'Laikipia'),(32,'Nakuru'),(33,'Narok'),(34,'Kajiado'),(35,'Kericho'),(36,'Bomet'),(37,'Kakamega'),(38,'Vihiga'),(39,'Bungoma'),(40,'Busia'),(41,'Siaya'),(42,'Kisumu'),(43,'Homa Bay'),(44,'Migori'),(45,'Kisii'),(46,'Nyamira'),(47,'Nairobi City'); /*!40000 ALTER TABLE `county_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_heads_tbl` -- DROP TABLE IF EXISTS `department_heads_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `department_heads_tbl` ( `department_head_id` int(11) NOT NULL AUTO_INCREMENT, `dept_id` int(11) NOT NULL, `head_id` int(11) NOT NULL, `h_status` varchar(15) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `h_created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`department_head_id`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_heads_tbl` -- LOCK TABLES `department_heads_tbl` WRITE; /*!40000 ALTER TABLE `department_heads_tbl` DISABLE KEYS */; INSERT INTO `department_heads_tbl` VALUES (1,1,1,'Active','2019-05-01',NULL,1,1,'2019-05-01 10:31:04'),(2,3,12,'Active','2019-07-25',NULL,2,2,'2019-07-31 09:34:42'),(3,4,11,'Active','2019-07-25',NULL,2,2,'2019-07-31 09:37:35'),(4,6,15,'Active','2021-04-18',NULL,6,6,'2021-04-22 14:26:01'),(5,7,18,'Active','2012-12-30',NULL,6,6,'2021-04-22 14:26:19'),(6,8,19,'Active','2017-01-29',NULL,6,6,'2021-04-22 14:26:37'),(7,9,17,'Active','2018-10-02',NULL,6,6,'2021-04-22 14:27:06'),(8,9,16,'Active','2020-03-29',NULL,6,6,'2021-04-22 14:27:50'); /*!40000 ALTER TABLE `department_heads_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_tbl` -- DROP TABLE IF EXISTS `department_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `department_tbl` ( `department_id` int(11) NOT NULL AUTO_INCREMENT, `department_name` varchar(50) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `d_created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`department_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_tbl` -- LOCK TABLES `department_tbl` WRITE; /*!40000 ALTER TABLE `department_tbl` DISABLE KEYS */; INSERT INTO `department_tbl` VALUES (1,'Treasury',1,1,'2019-05-01 10:29:23'),(2,'Creative arts',1,1,'2019-07-31 08:54:31'),(3,'finance',2,2,'2019-07-31 09:33:35'),(4,'Planning and Development ',2,2,'2019-07-31 09:36:30'),(5,'children',1,1,'2019-08-01 10:01:53'),(6,'Sunday School',6,6,'2021-04-22 14:23:47'),(7,'Youth',6,6,'2021-04-22 14:23:58'),(8,'Praise and Worship',6,6,'2021-04-22 14:24:12'),(9,'Church Choir',6,6,'2021-04-22 14:24:20'),(10,'Elders',6,6,'2021-04-22 14:24:29'),(11,'Ict And Sound Systems',6,6,'2021-04-22 14:25:40'),(12,'YOUTH',7,7,'2021-04-22 19:27:51'),(13,'PCMF',8,8,'2021-07-24 11:27:37'),(14,'choir',8,8,'2022-01-16 15:43:05'); /*!40000 ALTER TABLE `department_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events_tbl` -- DROP TABLE IF EXISTS `events_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `events_tbl` ( `event_id` int(11) NOT NULL AUTO_INCREMENT, `event_name` varchar(50) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `description` text NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`event_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events_tbl` -- LOCK TABLES `events_tbl` WRITE; /*!40000 ALTER TABLE `events_tbl` DISABLE KEYS */; INSERT INTO `events_tbl` VALUES (1,'Annual General Meeting','2019-05-15','2019-05-17','We will be conducting our annual general meeting as on the scheduled dates. All are welcome.',1,1,'2019-05-01 22:27:22'),(2,'Test','2019-05-03','2019-05-10','testing',1,1,'2019-05-03 08:11:07'),(4,'Pre-Wedding','2019-08-01','2019-08-01','All members are invited to a pre-wedding ceremony of James ',2,2,'2019-07-31 09:52:55'),(5,'Parish Gathering','2021-04-26','2021-04-30','Regional Parish Gathering',6,6,'2021-04-22 15:55:48'),(6,'Annual Regional Youth Week Fundraising','2021-05-23','2021-05-30','Annual Regional Youth Week Fundraising ',6,6,'2021-04-23 10:14:15'),(7,'PCMF MEN GATHERING -KOINONIA EXPERIENCE 2021','2021-04-25','2021-05-23','PCMF MEN GATHERING -KOINONIA EXPERIENCE 2021',6,6,'2021-04-23 11:27:05'),(8,'Meeting','2022-07-06','2022-07-14','test',5,5,'2022-07-06 10:30:04'),(9,'test','2022-07-29','2022-07-26','test',5,5,'2022-07-06 10:30:58'); /*!40000 ALTER TABLE `events_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expense_tbl` -- DROP TABLE IF EXISTS `expense_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `expense_tbl` ( `expense_id` int(11) NOT NULL AUTO_INCREMENT, `amount` varchar(100) NOT NULL, `expense_head` int(11) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `description` text NOT NULL, `date` date NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`expense_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 `expense_tbl` -- LOCK TABLES `expense_tbl` WRITE; /*!40000 ALTER TABLE `expense_tbl` DISABLE KEYS */; INSERT INTO `expense_tbl` VALUES (1,'5500',1,1,1,'Electricity bill for the month of April.','2019-05-01','2019-05-01 22:17:49'),(2,'10000',3,2,2,'','2019-07-27','2019-07-31 10:24:21'); /*!40000 ALTER TABLE `expense_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expensehead_tbl` -- DROP TABLE IF EXISTS `expensehead_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `expensehead_tbl` ( `head_id` int(11) NOT NULL AUTO_INCREMENT, `head_name` varchar(100) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`head_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 `expensehead_tbl` -- LOCK TABLES `expensehead_tbl` WRITE; /*!40000 ALTER TABLE `expensehead_tbl` DISABLE KEYS */; INSERT INTO `expensehead_tbl` VALUES (1,'Electricity Bill',1,1,'2019-05-01 21:44:03'),(2,'Water Bill',1,1,'2019-05-01 21:44:30'),(3,'secretary',2,2,'2019-07-31 10:20:53'); /*!40000 ALTER TABLE `expensehead_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gender_tbl` -- DROP TABLE IF EXISTS `gender_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `gender_tbl` ( `gender_id` int(11) NOT NULL AUTO_INCREMENT, `gender_name` varchar(15) NOT NULL, `g_created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`gender_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 `gender_tbl` -- LOCK TABLES `gender_tbl` WRITE; /*!40000 ALTER TABLE `gender_tbl` DISABLE KEYS */; INSERT INTO `gender_tbl` VALUES (1,'Male','2019-04-22 15:50:38'),(2,'Female','2019-04-22 15:50:38'); /*!40000 ALTER TABLE `gender_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `income_tbl` -- DROP TABLE IF EXISTS `income_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `income_tbl` ( `income_id` int(11) NOT NULL AUTO_INCREMENT, `amount` varchar(100) NOT NULL, `income_head` int(11) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `date` date NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`income_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 `income_tbl` -- LOCK TABLES `income_tbl` WRITE; /*!40000 ALTER TABLE `income_tbl` DISABLE KEYS */; INSERT INTO `income_tbl` VALUES (1,'1050',1,1,1,'2019-05-01','2019-05-01 19:39:43'),(2,'1504',2,1,1,'2019-05-01','2019-05-01 19:40:13'),(3,'1050',2,1,1,'2019-07-07','2019-07-07 16:21:30'),(4,'7000',3,2,2,'2019-07-10','2019-07-31 10:19:43'),(5,'5000',4,8,8,'2022-01-16','2022-01-16 16:21:11'),(6,'3000',4,8,8,'2022-01-16','2022-01-16 16:21:23'); /*!40000 ALTER TABLE `income_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `incomehead_tbl` -- DROP TABLE IF EXISTS `incomehead_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `incomehead_tbl` ( `head_id` int(11) NOT NULL AUTO_INCREMENT, `head_name` varchar(100) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`head_id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `incomehead_tbl` -- LOCK TABLES `incomehead_tbl` WRITE; /*!40000 ALTER TABLE `incomehead_tbl` DISABLE KEYS */; INSERT INTO `incomehead_tbl` VALUES (1,'Selling Vegetables',1,1,'2019-05-01 12:55:46'),(2,'Selling eggs',1,1,'2019-05-01 12:56:00'),(3,'treasurer',2,2,'2019-07-31 10:19:08'),(4,'DONATION',8,8,'2022-01-16 16:20:52'),(5,'GIVING',8,8,'2022-01-16 16:20:57'); /*!40000 ALTER TABLE `incomehead_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `members_tbl` -- DROP TABLE IF EXISTS `members_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `members_tbl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `member_no` varchar(50) NOT NULL, `m_firstname` varchar(50) NOT NULL, `m_middlename` varchar(50) DEFAULT NULL, `m_lastname` varchar(50) NOT NULL, `m_phone` varchar(50) DEFAULT NULL, `m_email` varchar(50) DEFAULT NULL, `m_gender` int(11) NOT NULL, `m_placeofbirth` varchar(50) DEFAULT NULL, `m_residenceplace` varchar(50) DEFAULT NULL, `m_dob` date NOT NULL, `m_nationalid` int(11) DEFAULT NULL, `password` varchar(100) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `role` varchar(50) DEFAULT NULL, `status` varchar(50) NOT NULL, `m_joiningdate` date NOT NULL, `recorded_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `members_tbl` -- LOCK TABLES `members_tbl` WRITE; /*!40000 ALTER TABLE `members_tbl` DISABLE KEYS */; INSERT INTO `members_tbl` VALUES (1,'1','Raymond','','Omondi','+2547170008925','raymond@gmail.com',1,'43','Eldoret','1998-04-30',98798798,'$2y$10$jJ3Yh57a39xfo5XShGc7wOudSE1LTT7GsFzivpTBj6Dy0NAmhVHi.',1,1,'Member','Active','2019-05-01','2019-05-01 10:23:22'),(2,'2','Nehemiah','Cheburet','Limo','+254751607786','limo@gmail.com',1,'35','Muthaiga','2000-03-01',87654321,'$2y$10$1AuNkPUs9C0/duY.solQS.5ZRnjz2cGESwq0UtuCE3Nfy3uqrZaGy',1,1,'Member','Active','2019-05-01','2019-05-01 11:39:34'),(4,'3','Felista','Gikonyo','Nyambura','+254796883745','',2,'13','Witethie','1997-04-30',33809990,'$2y$10$fakiLdmBO.cMCBQ5ddvOyOjlk8vf0VgSdAlAMKqMinbRX0qulqfuy',1,1,'Member','Active','2019-05-02','2019-05-02 11:11:23'),(5,'4','Alphonce','','Obote','','',1,'10','Upper Hill','2011-03-09',0,'$2y$10$7GLfNHCZcKtykJN9ETnkh.7m66JAyiF2nf/gY863W8t8H4gPlQLxy',1,1,'Member','Active','2019-05-02','2019-05-02 23:21:16'),(7,'6','Byron','','Otieno','','',1,'13','Muthaiga','2019-05-03',0,'$2y$10$EYxIDjQYYloNjY.GRea0juRsEyjjhr5CMgwIv1gxKS01sqlMRKxNy',1,1,'Member','Active','2019-05-03','2019-05-03 14:03:52'),(8,'5','Denis','','Karanja','','',1,'13','Muthaiga','2019-05-03',0,'$2y$10$2f0K6wl9N4iUvqmdnIjeSO5SkjwuVa23KVFrLsrDyFfrFOTas/c4a',1,1,'Member','Active','2019-05-03','2019-05-03 14:04:59'),(9,'7','Marion','','Lorna','','',2,'6','Thika','2014-03-13',0,'$2y$10$ptEumHwgePQseA0402VtS.MW6B91hTFN9o3WnkYd.tre1F3/qu/p.',1,1,'Member','Active','2019-05-10','2019-05-10 01:54:06'),(10,'8','Byron','','Lorna','','',2,'11','Witethie','2019-04-30',0,'$2y$10$TwXxV26WVvvp62oL621Zu.3WSSSquRugGP/dxbNDNnd.gVDXg4bcS',1,1,'Member','Active','2019-05-10','2019-05-10 02:02:46'),(11,'1','Christina','','Wachia','+254751607786','',2,'1','Kisii','2019-07-01',90909090,'$2y$10$IEW7L7epER4Ppw1.hJ9GS.n4QWPtilM2sE2EDGaR.sUYkZwcMYi06',2,2,'Member','Active','2019-07-17','2019-07-17 14:45:14'),(12,'2','Obadiah','','Khatima','','',1,'11','Lurambi','2019-07-03',11111111,'$2y$10$gAFjEzrUOIEeUGDw3X/41elICa9xWlqQj.L7SxN1Z9xZtVSs4tls.',2,2,'Member','Active','2019-07-17','2019-07-17 14:46:00'),(13,'3','Ambrose','Mungai','Otieno','07123456789','ambrose@gmail.com',1,'22','Thika','2019-08-02',88888888,'$2y$10$RgsR31YF.JYwd8wq2Wu/g.W.StKbo6gjHW4cneTlVZdER5yNb3GIy',2,2,'Member','Active','2019-07-31','2019-07-31 09:13:04'),(14,'4','Ambrose','Mungai','Otieno','07123456789','ambrose@gmail.com',1,'22','Thika','2019-07-07',88888888,'$2y$10$9rEgACi5OgALU6P4bGAewuzw6z7Uew1RDshObOb.b3JOVBDhjQQju',2,2,'Member','Active','2019-08-24','2019-07-31 09:21:08'),(15,'1','Edith','Kabale','Aitiko','0721276427','EdithKabale@gmail.com',2,'22','Juja','1964-12-28',12345,'$2y$10$6ObFjbsOxPvG8fHGHrVIrOrpwTVYi0lLeFNTsPmVAkw6D8zGHrCLe',6,6,'Member','Active','1975-12-28','2021-04-22 13:53:21'),(16,'2','Mirinda','Ashunti','Vaseri','07342555356','AshuntiMirinda@gmail.com',1,'1','Juja','1989-06-13',98765,'$2y$10$NSOMWGQG0R0z9oQo5OQPeukU3DqoU1J8r8m0EFoupoBi8Kl6otlNm',6,6,'Member','Active','1988-05-09','2021-04-22 13:55:22'),(17,'3','nniko ','Katu','Mwajuma','073565676287','MwajumaKatu@gmail.com',2,'1','KENYATTA RD','1989-07-11',67890,'$2y$10$brtpP4FVNynOUV60aXzssuUOzxOGxjyhrS.EUMHiB.uzkinNBAozS',6,6,'Member','Active','2002-01-28','2021-04-22 13:56:55'),(18,'4','Michael','Charlo','Asiende','07532543263','AsiendeCharlo@gmail.com',1,'44','Mandera','1967-05-10',9876543,'$2y$10$u/Ke.n9poYB/AmvYqg0uVO9gyrcimZVEoaYkTLwfoX/Vg1jlGzw2G',6,6,'Member','Active','2002-04-29','2021-04-22 13:59:19'),(19,'5','Khateri','Meni','Nyingi\'ro','075467728264','Nyingi\'roMeni@gmail.com',2,'15','Dubai','1986-06-02',2345234,'$2y$10$.GK/ooRia9w2wHFEdhVYXeXC48M5AyuHsHgXQ70IFLmpWh.g0Z7Pa',6,6,'Member','Active','2002-09-01','2021-04-22 14:02:13'),(20,'1','ERUSTUS','GICHUHI','GICHUHI','07166767878','',1,'31','JUJA','2022-01-18',567768789,'$2y$10$axbQYryRpnAz.kHW3grm0ecsG8BIDC3Xe9z4eE.AOQ9nF/0N5nehK',8,8,'Member','Active','2021-12-28','2022-01-16 15:48:23'); /*!40000 ALTER TABLE `members_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ministry_heads_tbl` -- DROP TABLE IF EXISTS `ministry_heads_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ministry_heads_tbl` ( `ministry_head_id` int(11) NOT NULL AUTO_INCREMENT, `ministry_id` int(11) NOT NULL, `head_id` int(11) NOT NULL, `m_status` varchar(15) NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `m_dreated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`ministry_head_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ministry_heads_tbl` -- LOCK TABLES `ministry_heads_tbl` WRITE; /*!40000 ALTER TABLE `ministry_heads_tbl` DISABLE KEYS */; /*!40000 ALTER TABLE `ministry_heads_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ministry_tbl` -- DROP TABLE IF EXISTS `ministry_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ministry_tbl` ( `ministry_id` int(11) NOT NULL AUTO_INCREMENT, `ministry_name` varchar(50) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `m_created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`ministry_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ministry_tbl` -- LOCK TABLES `ministry_tbl` WRITE; /*!40000 ALTER TABLE `ministry_tbl` DISABLE KEYS */; INSERT INTO `ministry_tbl` VALUES (1,'Praise and Worship',1,1,'2019-05-01 10:37:36'),(2,'Media and IT',1,1,'2019-05-01 20:19:04'),(3,'Youth',2,2,'2019-07-31 09:38:09'),(4,'Pathfinders',2,2,'2019-07-31 09:38:30'),(5,'Pathfinders',2,2,'2019-07-31 09:38:51'),(6,'Church Choir',2,2,'2019-07-31 09:39:54'),(7,'Young Couples Ministry',6,6,'2021-04-22 14:31:29'),(8,'Childrens Ministry',6,6,'2021-04-22 14:40:45'),(9,'LoveHeart Ministry',6,6,'2021-04-22 14:41:25'),(10,'Christian Education Board',6,6,'2021-04-22 14:50:17'),(11,'FoodForHeart Ministry',6,6,'2021-04-22 14:53:37'),(12,'PCMF',8,8,'2022-01-16 16:22:26'); /*!40000 ALTER TABLE `ministry_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ministrymember_tbl` -- DROP TABLE IF EXISTS `ministrymember_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ministrymember_tbl` ( `ministrymember_id` int(11) NOT NULL AUTO_INCREMENT, `ministry_id` int(11) NOT NULL, `member_id` int(11) NOT NULL, `start_date` date NOT NULL, `end_date` date NOT NULL, `member_status` varchar(50) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`ministrymember_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 `ministrymember_tbl` -- LOCK TABLES `ministrymember_tbl` WRITE; /*!40000 ALTER TABLE `ministrymember_tbl` DISABLE KEYS */; INSERT INTO `ministrymember_tbl` VALUES (1,1,1,'2019-05-01','0000-00-00','Active',1,1,'2019-05-01 10:38:30'),(2,4,13,'2019-07-10','0000-00-00','Active',2,2,'2019-07-31 09:41:06'),(3,12,20,'2022-01-16','0000-00-00','Active',8,8,'2022-01-16 16:22:41'); /*!40000 ALTER TABLE `ministrymember_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `offering_tbl` -- DROP TABLE IF EXISTS `offering_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `offering_tbl` ( `offering_id` int(11) NOT NULL AUTO_INCREMENT, `member` int(11) NOT NULL, `category` int(11) NOT NULL, `amount` varchar(50) NOT NULL, `pay_mode` varchar(50) DEFAULT NULL, `description` text DEFAULT NULL, `payment_date` date NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created_date` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`offering_id`) ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `offering_tbl` -- LOCK TABLES `offering_tbl` WRITE; /*!40000 ALTER TABLE `offering_tbl` DISABLE KEYS */; INSERT INTO `offering_tbl` VALUES (1,1,1,'1550','CASH','Fungu la kumi','2019-05-01',1,1,'2019-05-01 10:43:47'),(2,1,2,'5500','MPESA','Support towards development of the church.','2019-04-30',1,1,'2019-05-01 11:08:28'),(3,2,1,'2500','MPESA','','2019-05-01',1,1,'2019-05-01 11:43:44'),(4,0,0,'15400',NULL,'Offered on labor day.','2019-05-01',1,1,'2019-05-01 15:07:34'),(5,0,0,'955',NULL,'Youth offering.','2019-05-07',1,1,'2019-05-01 15:10:30'),(6,2,2,'350','CASH','','2019-05-01',1,2,'2019-05-01 22:46:26'),(7,2,1,'10','MPESA','','2019-05-01',1,2,'2019-05-01 23:03:54'),(8,0,0,'450',NULL,'','2019-05-14',1,1,'2019-05-14 22:57:31'),(9,7,1,'100','CHEQUE','','2019-07-15',1,1,'2019-07-15 12:55:47'),(10,4,1,'1000','MPESA','','2019-07-16',1,4,'2019-07-16 00:42:37'),(11,11,3,'1000','MPESA','For development purpose','2019-07-11',2,2,'2019-07-31 09:44:21'),(12,0,0,'6000',NULL,'thanks giving','2019-07-12',2,2,'2019-07-31 09:46:48'),(13,10,4,'200','MPESA','','2018-12-01',1,1,'2019-07-31 09:58:16'),(14,16,8,'50000','CHEQUE','','2021-04-22',6,6,'2021-04-22 15:02:33'),(15,15,9,'2000','MPESA','','2021-03-28',6,6,'2021-04-22 15:04:18'),(16,17,6,'1200','CASH','','2021-04-20',6,6,'2021-04-22 15:07:31'),(17,19,5,'8000','CHEQUE','','2021-04-22',6,6,'2021-04-22 15:10:00'),(18,16,8,'19000','MPESA','','2021-02-01',6,6,'2021-04-22 15:13:20'),(19,0,0,'90000000',NULL,'','2021-03-28',6,6,'2021-04-22 15:14:48'),(20,20,11,'1000','CASH','PRAY FOR MY FAMILY','2022-01-16',8,8,'2022-01-16 15:49:20'),(21,20,12,'5000','CASH','','2022-01-16',8,8,'2022-01-16 15:50:29'),(22,20,14,'400','CASH','','2022-01-16',8,8,'2022-01-16 16:25:36'); /*!40000 ALTER TABLE `offering_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `offeringcategory_tbl` -- DROP TABLE IF EXISTS `offeringcategory_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `offeringcategory_tbl` ( `category_id` int(11) NOT NULL AUTO_INCREMENT, `category_name` varchar(50) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`category_id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `offeringcategory_tbl` -- LOCK TABLES `offeringcategory_tbl` WRITE; /*!40000 ALTER TABLE `offeringcategory_tbl` DISABLE KEYS */; INSERT INTO `offeringcategory_tbl` VALUES (1,'Fungu la Kumi(tithe)',1,1,'2019-05-01 10:39:49'),(2,'Church Project',1,1,'2019-05-01 10:42:20'),(3,'help',2,2,'2019-07-31 09:43:21'),(4,'first fruit',1,1,'2019-07-31 09:56:56'),(5,'JUJA TOWNSHIP DISTRICT',6,6,'2021-04-22 15:00:28'),(6,'SEWAGE DISTRICT',6,6,'2021-04-22 15:01:09'),(7,'HIGHPOINT DISTRICT',6,6,'2021-04-22 15:01:27'),(8,'KALIMONI DISTRICT',6,6,'2021-04-22 15:01:42'),(9,'KENYATTA ROAD DISTRICT',6,6,'2021-04-22 15:01:56'),(10,'offerings',8,8,'2022-01-16 15:45:56'),(11,'tithes',8,8,'2022-01-16 15:46:01'),(12,'developments',8,8,'2022-01-16 15:46:14'),(13,'MINISTRIES',8,8,'2022-01-16 16:24:50'),(14,'CBF MINISTRIES',8,8,'2022-01-16 16:25:21'); /*!40000 ALTER TABLE `offeringcategory_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_tbl` -- DROP TABLE IF EXISTS `project_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `project_tbl` ( `project_id` int(11) NOT NULL AUTO_INCREMENT, `project_name` varchar(100) NOT NULL, `project_description` text NOT NULL, `start_date` date NOT NULL, `end_date` date DEFAULT NULL, `status` varchar(50) NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `created` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`project_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 `project_tbl` -- LOCK TABLES `project_tbl` WRITE; /*!40000 ALTER TABLE `project_tbl` DISABLE KEYS */; INSERT INTO `project_tbl` VALUES (1,'Concrete Water Tank','The church is focusing on building a concrete tank for keeping clean drinking water.','2019-05-01','0000-00-00','Ongoing',1,1,'2019-05-01 23:18:56'),(2,'Church Renovation','church renovation will commence on thursday next week','2019-07-25','0000-00-00','Ongoing',2,2,'2019-07-31 10:00:42'),(3,'dell','dfgh','2019-07-01',NULL,'Completed',1,1,'2019-07-31 10:11:34'); /*!40000 ALTER TABLE `project_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sermons_tbl` -- DROP TABLE IF EXISTS `sermons_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `sermons_tbl` ( `sermon_id` int(11) NOT NULL AUTO_INCREMENT, `sermon_title` varchar(100) NOT NULL, `description` text NOT NULL, `added_date` date NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `recorded` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`sermon_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 `sermons_tbl` -- LOCK TABLES `sermons_tbl` WRITE; /*!40000 ALTER TABLE `sermons_tbl` DISABLE KEYS */; INSERT INTO `sermons_tbl` VALUES (1,'Sermon title2','Testing the work-ability.','2019-05-01',1,1,'2019-05-01 22:31:15'),(2,'Baptism','TEST','2020-08-01',1,1,'2019-07-31 09:36:13'),(3,'Repentance & Forgiveness','We are all sinners. we are therefore required to repent our sins so that we can be forgiven by our heavenly father.','2019-07-17',2,2,'2019-07-31 09:58:44'); /*!40000 ALTER TABLE `sermons_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `superadmin_tbl` -- DROP TABLE IF EXISTS `superadmin_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `superadmin_tbl` ( `super_id` int(11) NOT NULL AUTO_INCREMENT, `fname` varchar(50) NOT NULL, `lname` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `national_id` int(11) NOT NULL, `password` varchar(100) NOT NULL, `role` varchar(15) NOT NULL, `dated` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`super_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 `superadmin_tbl` -- LOCK TABLES `superadmin_tbl` WRITE; /*!40000 ALTER TABLE `superadmin_tbl` DISABLE KEYS */; INSERT INTO `superadmin_tbl` VALUES (1,'Journal','Reagan','+254798628226','journalreagan@gmail.com',32809990,'$2y$10$eI8OEH/2d0f635Syx3rWluZBzpUJIgcy3DfjEJynWK9KAyRfsUzqq','Super Admin','2019-05-01 10:01:34'); /*!40000 ALTER TABLE `superadmin_tbl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tbl_county` -- DROP TABLE IF EXISTS `tbl_county`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `tbl_county` ( `county_id` int(11) NOT NULL AUTO_INCREMENT, `county_name` varchar(30) DEFAULT NULL, PRIMARY KEY (`county_id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tbl_county` -- LOCK TABLES `tbl_county` WRITE; /*!40000 ALTER TABLE `tbl_county` DISABLE KEYS */; INSERT INTO `tbl_county` VALUES (1,'Mombasa'),(2,'Kwale'),(3,'Kilifi'),(4,'Tana River'),(5,'Lamu'),(6,'Taita-Taveta'),(7,'Garissa'),(8,'wajir'),(9,'Mandera'),(10,'Marsabit'),(11,'Isiolo'),(12,'Meru'),(13,'Tharaka-Nithi'),(14,'Embu'),(15,'Kitui'),(16,'Machakos'),(17,'Makueni'),(18,'Nyandarua'),(19,'Nyeri'),(20,'Kirinyaga'),(21,'Murang\'a'),(22,'Kiambu'),(23,'Turkana'),(24,'West Pokot'),(25,'Samburu'),(26,'Trans Nzoia'),(27,'Uasin Gishu'),(28,'Elgeyo-Marakwet'),(29,'Nandi'),(30,'Baringo'),(31,'Laikipia'),(32,'Nakuru'),(33,'Narok'),(34,'Kajiado'),(35,'Kericho'),(36,'Bomet'),(37,'Kakamega'),(38,'Vihiga'),(39,'Bungoma'),(40,'Busia'),(41,'Siaya'),(42,'Kisumu'),(43,'Homa Bay'),(44,'Migori'),(45,'Kisii'),(46,'Nyamira'),(47,'Nairobi City'); /*!40000 ALTER TABLE `tbl_county` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `visitors_tbl` -- DROP TABLE IF EXISTS `visitors_tbl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `visitors_tbl` ( `visitor_no` int(11) NOT NULL AUTO_INCREMENT, `v_firstname` varchar(50) NOT NULL, `v_middlename` varchar(50) DEFAULT NULL, `v_lastname` varchar(50) NOT NULL, `v_gender` int(11) NOT NULL, `v_phone` varchar(15) DEFAULT NULL, `v_email` varchar(50) DEFAULT NULL, `v_residenceplace` varchar(50) DEFAULT NULL, `about_us` text DEFAULT NULL, `v_visitingdate` date NOT NULL, `church` int(11) NOT NULL, `created_by` int(11) NOT NULL, `v_createddate` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`visitor_no`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `visitors_tbl` -- LOCK TABLES `visitors_tbl` WRITE; /*!40000 ALTER TABLE `visitors_tbl` DISABLE KEYS */; INSERT INTO `visitors_tbl` VALUES (2,'Bancy','Wandiri','Nyaga',2,'+254708608486','bancy@yahoo.com','Muthaiga','Was invited by a friend.','2019-05-12',1,1,'2019-05-14 05:34:38'),(3,'Lex','','Rigallitoh',1,'+254751607786','rigallitoh@gmail.com','Nairobi','Social media\r\n','2019-05-14',1,1,'2019-05-14 08:22:25'),(4,'maxine','Wangu','Gitonga',2,'254851145','maxine@yahoo.com','Kileleshwa','zdfghjkjhgf','2019-07-25',1,1,'2019-07-31 09:03:17'),(5,'kimani','mbuguah','james',1,'0786543265','james@gmail.com','juja','Through a friend','2019-07-17',2,2,'2019-07-31 09:32:09'),(6,'Monica','Mwiyan','Nagiro',2,'073424424','MwiyanMonica@gmail.com','Juja','From A Friend','2021-04-22',6,6,'2021-04-22 14:06:30'),(7,'Joshua ','Matthew','Dan',1,'07242766488','MatthewDanjoshua@gmail.com','Thika','SocIal Media','2009-06-01',6,6,'2021-04-22 14:11:54'),(8,'Isaac','Gideon','Musa',1,'07212132434','GideonMusa@gmail.com','Mugale','Neighbour','2002-12-29',6,6,'2021-04-22 14:13:20'),(9,'Ahmed','Muti','Dhateri',1,'071332234434','DhateriAhmed@gmail..com','Kimbo','Online Poster','2021-04-21',6,6,'2021-04-22 14:19:59'),(10,'Dannty','Magie','Ghadiri',1,'07211211113','GhdirMagie@gmail.com','Soko Mjinga','Friend','2021-04-21',6,6,'2021-04-22 14:23:19'),(11,'qwerty','','qwert',1,'0700000000','','seasons','friend','2022-06-26',3,3,'2022-06-26 12:06:51'); /*!40000 ALTER TABLE `visitors_tbl` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-06-30 18:08:56
.
Edit
..
Edit
information_schema.sql
Edit
mysql.sql
Edit
performance_schema.sql
Edit
robisear_017lounge.sql
Edit
robisear_15minutes.sql
Edit
robisear_1865pubcoltd.sql
Edit
robisear_64jos.sql
Edit
robisear_727barandrestaurant.sql
Edit
robisear_ELKTONS.sql
Edit
robisear_Kencityhealth.sql
Edit
robisear_a3autocare.sql
Edit
robisear_abbeyslacewig.sql
Edit
robisear_aberdare.sql
Edit
robisear_abic.sql
Edit
robisear_abnpharmaceuticals.sql
Edit
robisear_accommodation.sql
Edit
robisear_aceliquor.sql
Edit
robisear_adamssupermarket.sql
Edit
robisear_adcentcomputers.sql
Edit
robisear_adval.sql
Edit
robisear_africaexpress.sql
Edit
robisear_africanfabric.sql
Edit
robisear_afrisco.sql
Edit
robisear_afrovision.sql
Edit
robisear_agriassistltd.sql
Edit
robisear_ahel.sql
Edit
robisear_airworks.sql
Edit
robisear_ajanihouse.sql
Edit
robisear_akshar.sql
Edit
robisear_akshar2.sql
Edit
robisear_akshar3.sql
Edit
robisear_alaphamega.sql
Edit
robisear_alasfourcosmetics.sql
Edit
robisear_aldeon.sql
Edit
robisear_alibern.sql
Edit
robisear_alj.sql
Edit
robisear_aljpos.sql
Edit
robisear_allmeds.sql
Edit
robisear_alma.sql
Edit
robisear_amaniangani.sql
Edit
robisear_amat.sql
Edit
robisear_ambalu.sql
Edit
robisear_ambasagrill.sql
Edit
robisear_ambokililimited.sql
Edit
robisear_amsol.sql
Edit
robisear_amzkanzu.sql
Edit
robisear_anandamarga.sql
Edit
robisear_anchorlounge.sql
Edit
robisear_annexchefwest.sql
Edit
robisear_annexm2.sql
Edit
robisear_anujhardware.sql
Edit
robisear_apollostar.sql
Edit
robisear_approtechtech.sql
Edit
robisear_arkam.sql
Edit
robisear_aryelegant.sql
Edit
robisear_arziki.sql
Edit
robisear_asbedpharmaceuticalslimited.sql
Edit
robisear_asterhealth.sql
Edit
robisear_atlas.sql
Edit
robisear_automaxx.sql
Edit
robisear_automotivedoctor.sql
Edit
robisear_avichem.sql
Edit
robisear_baberian.sql
Edit
robisear_babygarden.sql
Edit
robisear_babygarden2.sql
Edit
robisear_babygarden3.sql
Edit
robisear_backazzlounge.sql
Edit
robisear_badi.sql
Edit
robisear_bantuliquor.sql
Edit
robisear_barakastores.sql
Edit
robisear_barbecuexpress.sql
Edit
robisear_barbecuexpress2.sql
Edit
robisear_bargalcollection.sql
Edit
robisear_basdeliveryservices.sql
Edit
robisear_basewines.sql
Edit
robisear_batasportsclub.sql
Edit
robisear_baylandcafe.sql
Edit
robisear_bbcfarm.sql
Edit
robisear_bboutique.sql
Edit
robisear_beautybyimani.sql
Edit
robisear_beautypoint.sql
Edit
robisear_beautypointcollege.sql
Edit
robisear_becap.sql
Edit
robisear_beco.sql
Edit
robisear_benan.sql
Edit
robisear_benan2.sql
Edit
robisear_benjakab.sql
Edit
robisear_bensare.sql
Edit
robisear_beshel.sql
Edit
robisear_bestbudget.sql
Edit
robisear_besterp.sql
Edit
robisear_betafoods.sql
Edit
robisear_beyahbix.sql
Edit
robisear_beyondsweetness.sql
Edit
robisear_bigbox.sql
Edit
robisear_bigtech.sql
Edit
robisear_bijou.sql
Edit
robisear_bijouhotel.sql
Edit
robisear_bikebrigades.sql
Edit
robisear_blackplatinum.sql
Edit
robisear_blixen.sql
Edit
robisear_bluechipaviation.sql
Edit
robisear_boba.sql
Edit
robisear_bodegajamhuri.sql
Edit
robisear_bodegasyokimau.sql
Edit
robisear_bodegathome.sql
Edit
robisear_bostonhousehold.sql
Edit
robisear_bostonhousehold2.sql
Edit
robisear_botanical.sql
Edit
robisear_boxlight.sql
Edit
robisear_bpackagng.sql
Edit
robisear_braeburnclub.sql
Edit
robisear_braeburnclub1.sql
Edit
robisear_brandgate.sql
Edit
robisear_brickmann.sql
Edit
robisear_bridgebarrel.sql
Edit
robisear_brighton.sql
Edit
robisear_brightonpms.sql
Edit
robisear_brimat.sql
Edit
robisear_brimatholdings.sql
Edit
robisear_brimatholdings1.sql
Edit
robisear_brimix.sql
Edit
robisear_brimix2.sql
Edit
robisear_brimix3.sql
Edit
robisear_brownbox.sql
Edit
robisear_bsikenya.sql
Edit
robisear_btl.sql
Edit
robisear_bulwark.sql
Edit
robisear_bumalogisticsk.sql
Edit
robisear_bumanestlimited.sql
Edit
robisear_buneei.sql
Edit
robisear_burgers.sql
Edit
robisear_burgosstreet.sql
Edit
robisear_buydirect.sql
Edit
robisear_bvblounge.sql
Edit
robisear_c7fashion.sql
Edit
robisear_caffebora.sql
Edit
robisear_cambridge.sql
Edit
robisear_camino.sql
Edit
robisear_campzodiakafrica.sql
Edit
robisear_canaan.sql
Edit
robisear_canvasartshopltd.sql
Edit
robisear_canvasshoes.sql
Edit
robisear_carlizpaints.sql
Edit
robisear_casadimoda.sql
Edit
robisear_ccb.sql
Edit
robisear_ceeboylounge.sql
Edit
robisear_cellpro.sql
Edit
robisear_cellpro1.sql
Edit
robisear_celticlounge.sql
Edit
robisear_centurion.sql
Edit
robisear_chanaanafeeds.sql
Edit
robisear_chanaanagrovet.sql
Edit
robisear_chanaanfeeds.sql
Edit
robisear_chazaqsteel.sql
Edit
robisear_chedusystems.sql
Edit
robisear_cheflink.sql
Edit
robisear_chegowagon.sql
Edit
robisear_chemaliquor.sql
Edit
robisear_cherotebistro.sql
Edit
robisear_chesmapauto.sql
Edit
robisear_chibekellimited.sql
Edit
robisear_chickencenter.sql
Edit
robisear_chipsfix.sql
Edit
robisear_chocolatecity.sql
Edit
robisear_chrisapartment.sql
Edit
robisear_chrivebeauty.sql
Edit
robisear_church.sql
Edit
robisear_citadel.sql
Edit
robisear_citamclaycity.sql
Edit
robisear_claritycounseling.sql
Edit
robisear_cliqour.sql
Edit
robisear_cliquor.sql
Edit
robisear_comfortride.sql
Edit
robisear_concepts.sql
Edit
robisear_conceptsmartdecor.sql
Edit
robisear_copticrestaurant.sql
Edit
robisear_copticrestaurantnigeria.sql
Edit
robisear_coseke.sql
Edit
robisear_countyhotels.sql
Edit
robisear_cpk.sql
Edit
robisear_craftnliquor.sql
Edit
robisear_crystalpearl.sql
Edit
robisear_crystalshea.sql
Edit
robisear_dadasiventures.sql
Edit
robisear_dadir.sql
Edit
robisear_dailycharges.sql
Edit
robisear_daisyflower.sql
Edit
robisear_dallad.sql
Edit
robisear_dallad2.sql
Edit
robisear_dallad3.sql
Edit
robisear_damaline.sql
Edit
robisear_danga.sql
Edit
robisear_danga1.sql
Edit
robisear_darirose.sql
Edit
robisear_davetis.sql
Edit
robisear_dawacom.sql
Edit
robisear_dawapay.sql
Edit
robisear_degrasi.sql
Edit
robisear_delaroza.sql
Edit
robisear_demerger.sql
Edit
robisear_dencity.sql
Edit
robisear_dencity1.sql
Edit
robisear_dencity2.sql
Edit
robisear_dencity3.sql
Edit
robisear_denfatechnologies.sql
Edit
robisear_denkar.sql
Edit
robisear_denohenterprises.sql
Edit
robisear_desleyholdings.sql
Edit
robisear_desmanjo.sql
Edit
robisear_destiny.sql
Edit
robisear_desun.sql
Edit
robisear_detoxhealthspa.sql
Edit
robisear_devach.sql
Edit
robisear_devach2.sql
Edit
robisear_devach3.sql
Edit
robisear_diasporadivas.sql
Edit
robisear_digicafess.sql
Edit
robisear_digitalsuggestionbox.sql
Edit
robisear_dimetrica.sql
Edit
robisear_distinctiongardens.sql
Edit
robisear_distinctiongardens1.sql
Edit
robisear_dlliquorstores.sql
Edit
robisear_dndkenya.sql
Edit
robisear_doladen.sql
Edit
robisear_dollarbakers.sql
Edit
robisear_doubleolounge.sql
Edit
robisear_downtowntavern.sql
Edit
robisear_drn.sql
Edit
robisear_duraroof.sql
Edit
robisear_duraxpaints.sql
Edit
robisear_duwanclassic.sql
Edit
robisear_easysmart.sql
Edit
robisear_ebakaltd.sql
Edit
robisear_ecovest.sql
Edit
robisear_education.sql
Edit
robisear_effectivehardware.sql
Edit
robisear_electratech.sql
Edit
robisear_electrika.sql
Edit
robisear_elightpaths.sql
Edit
robisear_elisapowersystems.sql
Edit
robisear_elishammah.sql
Edit
robisear_elishammah2.sql
Edit
robisear_elishammahgarissa.sql
Edit
robisear_elishammahmatu.sql
Edit
robisear_elishammahmotorbike.sql
Edit
robisear_elishammahtaita.sql
Edit
robisear_eluktomhealthcare.sql
Edit
robisear_empower.sql
Edit
robisear_enacoach.sql
Edit
robisear_enacoachltd.sql
Edit
robisear_enjoyessenceltd.sql
Edit
robisear_enterprise.sql
Edit
robisear_enziapartment.sql
Edit
robisear_epicraftstudios.sql
Edit
robisear_erpuganda.sql
Edit
robisear_essentials.sql
Edit
robisear_evana.sql
Edit
robisear_evehilaryson.sql
Edit
robisear_events.sql
Edit
robisear_everbeautycosmetic.sql
Edit
robisear_evertipstop.sql
Edit
robisear_exxochem.sql
Edit
robisear_fabricske.sql
Edit
robisear_fabys.sql
Edit
robisear_fairwayhotel.sql
Edit
robisear_faithbase.sql
Edit
robisear_fajviyafrica.sql
Edit
robisear_fallingmooninvestments.sql
Edit
robisear_famo.sql
Edit
robisear_farmerspice.sql
Edit
robisear_farmerssolution.sql
Edit
robisear_farmlineagencies.sql
Edit
robisear_feast.sql
Edit
robisear_feedandfodder.sql
Edit
robisear_felizplace.sql
Edit
robisear_fermar.sql
Edit
robisear_fifi.sql
Edit
robisear_fishlands.sql
Edit
robisear_fitpharma.sql
Edit
robisear_flamebites.sql
Edit
robisear_flitoz.sql
Edit
robisear_flitozwines.sql
Edit
robisear_foresightmotors.sql
Edit
robisear_formulatorsdepotltd.sql
Edit
robisear_fortyplace.sql
Edit
robisear_franciscanfamily.sql
Edit
robisear_freemark.sql
Edit
robisear_frepego.sql
Edit
robisear_fretap.sql
Edit
robisear_friendssupermarket.sql
Edit
robisear_friendssupermarket1.sql
Edit
robisear_friendssupermarketmaji.sql
Edit
robisear_gabrielrotich.sql
Edit
robisear_gambella.sql
Edit
robisear_gambella2.sql
Edit
robisear_gambella3.sql
Edit
robisear_gathee.sql
Edit
robisear_gecko.sql
Edit
robisear_gemini.sql
Edit
robisear_generations.sql
Edit
robisear_gesa.sql
Edit
robisear_gigstores.sql
Edit
robisear_gilgameshltd.sql
Edit
robisear_githungurifoods.sql
Edit
robisear_githungurinationaloil.sql
Edit
robisear_glasstechandinteriors.sql
Edit
robisear_glowskin.sql
Edit
robisear_goldenspill.sql
Edit
robisear_goldenstandardscafe.sql
Edit
robisear_goldenstandardscafe1.sql
Edit
robisear_goldrock.sql
Edit
robisear_goldrock1.sql
Edit
robisear_goodlife.sql
Edit
robisear_gosavannah.sql
Edit
robisear_goshen.sql
Edit
robisear_grandcrinumltd1.sql
Edit
robisear_grandcrinumltdwestlands.sql
Edit
robisear_grandpa.sql
Edit
robisear_greatplan.sql
Edit
robisear_greekliquor.sql
Edit
robisear_greensavannah.sql
Edit
robisear_hadaelectrical.sql
Edit
robisear_hadassah.sql
Edit
robisear_hagon.sql
Edit
robisear_hairmasters.sql
Edit
robisear_halfmanlounge.sql
Edit
robisear_harmony.sql
Edit
robisear_hawest.sql
Edit
robisear_hawest2.sql
Edit
robisear_hawest3.sql
Edit
robisear_healsandvibes.sql
Edit
robisear_heavenssquare.sql
Edit
robisear_heywoodenterprises.sql
Edit
robisear_heywoodenterprises1.sql
Edit
robisear_hideaway.sql
Edit
robisear_homeessentialschoko.sql
Edit
robisear_homegoods.sql
Edit
robisear_homeland.sql
Edit
robisear_hoodwines.sql
Edit
robisear_hopeuniforms.sql
Edit
robisear_hopewholesalers.sql
Edit
robisear_hotsandbarrel2.sql
Edit
robisear_huyasaminimart.sql
Edit
robisear_iandbent.sql
Edit
robisear_ibiza.sql
Edit
robisear_idealdishes.sql
Edit
robisear_idlhome.sql
Edit
robisear_infamous.sql
Edit
robisear_infill.sql
Edit
robisear_infinitylounge.sql
Edit
robisear_instantdelicacy.sql
Edit
robisear_instinctbar.sql
Edit
robisear_interglobal.sql
Edit
robisear_interlink.sql
Edit
robisear_internationalhc.sql
Edit
robisear_ishmar.sql
Edit
robisear_isoko.sql
Edit
robisear_italycor.sql
Edit
robisear_itecsystemsltd.sql
Edit
robisear_itushbusinesssolutions.sql
Edit
robisear_jacbee.sql
Edit
robisear_jadame.sql
Edit
robisear_jailo.sql
Edit
robisear_jaimari.sql
Edit
robisear_jalasfeedback.sql
Edit
robisear_jamagwartraders.sql
Edit
robisear_jambotech.sql
Edit
robisear_jamwa.sql
Edit
robisear_jamwa1.sql
Edit
robisear_javilla.sql
Edit
robisear_javilla2.sql
Edit
robisear_javilla3.sql
Edit
robisear_jaybright.sql
Edit
robisear_jbfries.sql
Edit
robisear_jbfriesnrb.sql
Edit
robisear_jebmic.sql
Edit
robisear_jengaleo.sql
Edit
robisear_jewelcomputers.sql
Edit
robisear_jijazetavern.sql
Edit
robisear_jimlandagency.sql
Edit
robisear_jimmon.sql
Edit
robisear_jobportal.sql
Edit
robisear_joek.sql
Edit
robisear_johfay.sql
Edit
robisear_johkim.sql
Edit
robisear_jolimillers.sql
Edit
robisear_josmatt.sql
Edit
robisear_joyevech.sql
Edit
robisear_jubileefarmers.sql
Edit
robisear_jue.sql
Edit
robisear_junkybins.sql
Edit
robisear_jymarks.sql
Edit
robisear_kabati.sql
Edit
robisear_kagango.sql
Edit
robisear_kahawaexpresso.sql
Edit
robisear_kairetu.sql
Edit
robisear_kalabash.sql
Edit
robisear_kamson.sql
Edit
robisear_kamuga2.sql
Edit
robisear_kamunga.sql
Edit
robisear_kaperikwekwe.sql
Edit
robisear_kapsam.sql
Edit
robisear_karangi.sql
Edit
robisear_karangi1.sql
Edit
robisear_kasavanna.sql
Edit
robisear_katado.sql
Edit
robisear_kathiani.sql
Edit
robisear_katikatilounge.sql
Edit
robisear_kayolefinest.sql
Edit
robisear_keekys.sql
Edit
robisear_kenanthogoto.sql
Edit
robisear_kentwood.sql
Edit
robisear_kenworks.sql
Edit
robisear_kenyatoner.sql
Edit
robisear_kerutender.sql
Edit
robisear_kevomotors.sql
Edit
robisear_kiamariverresort.sql
Edit
robisear_kicas.sql
Edit
robisear_kidamienterprises.sql
Edit
robisear_kiddyzojunior.sql
Edit
robisear_kijabesacco.sql
Edit
robisear_kijijimojito.sql
Edit
robisear_kikingihub.sql
Edit
robisear_kilantechnologies.sql
Edit
robisear_kilimanibreeze.sql
Edit
robisear_kinca57.sql
Edit
robisear_kingpin.sql
Edit
robisear_kiraimportexport.sql
Edit
robisear_kise.sql
Edit
robisear_kiufresh.sql
Edit
robisear_kjwines.sql
Edit
robisear_kjwinesbumala.sql
Edit
robisear_kliqourline.sql
Edit
robisear_kliqourline2.sql
Edit
robisear_kliqourline3.sql
Edit
robisear_kmamt.sql
Edit
robisear_kombiro.sql
Edit
robisear_komesha.sql
Edit
robisear_komesha2.sql
Edit
robisear_konamart.sql
Edit
robisear_kraftboba.sql
Edit
robisear_kttc.sql
Edit
robisear_kuivaliquorstores.sql
Edit
robisear_kyumbigarden.sql
Edit
robisear_laanpat.sql
Edit
robisear_laareshell.sql
Edit
robisear_lafattoria.sql
Edit
robisear_laibunimart.sql
Edit
robisear_laikipiaeco.sql
Edit
robisear_lakirashades.sql
Edit
robisear_lamatech.sql
Edit
robisear_lamatechkenyalimited.sql
Edit
robisear_lambada.sql
Edit
robisear_lambadas.sql
Edit
robisear_lanxafrica.sql
Edit
robisear_latenight.sql
Edit
robisear_latia.sql
Edit
robisear_laundryhub.sql
Edit
robisear_leave.sql
Edit
robisear_leboo.sql
Edit
robisear_legitimacyspares.sql
Edit
robisear_lerustique.sql
Edit
robisear_lesarra.sql
Edit
robisear_leviticus.sql
Edit
robisear_libanautospareslimited.sql
Edit
robisear_limah.sql
Edit
robisear_linaden.sql
Edit
robisear_linchubstore.sql
Edit
robisear_linknumedical.sql
Edit
robisear_linksgeliwa.sql
Edit
robisear_liquidmania.sql
Edit
robisear_liquorlibrary.sql
Edit
robisear_liquortap.sql
Edit
robisear_litudian.sql
Edit
robisear_liveinproperties.sql
Edit
robisear_livingwaterbcf.sql
Edit
robisear_longliqi.sql
Edit
robisear_longrich.sql
Edit
robisear_longrich1.sql
Edit
robisear_lotus.sql
Edit
robisear_louizesimbahotel.sql
Edit
robisear_louizesimbahotel1.sql
Edit
robisear_louizesimbalounge.sql
Edit
robisear_lti.sql
Edit
robisear_ltigroup.sql
Edit
robisear_lukeshotel.sql
Edit
robisear_lukimpharmaceuticals.sql
Edit
robisear_luminous.sql
Edit
robisear_lunjos.sql
Edit
robisear_luxebistro.sql
Edit
robisear_luxurysuites.sql
Edit
robisear_lydiacollection.sql
Edit
robisear_lyon.sql
Edit
robisear_mafads.sql
Edit
robisear_magman.sql
Edit
robisear_mailer.sql
Edit
robisear_mainerp.sql
Edit
robisear_mainerp1.sql
Edit
robisear_mainerpuganda.sql
Edit
robisear_makinze.sql
Edit
robisear_malibulounge.sql
Edit
robisear_malsonmotors.sql
Edit
robisear_maqaarow.sql
Edit
robisear_maqaarow2.sql
Edit
robisear_maqaarow3.sql
Edit
robisear_maraorganics.sql
Edit
robisear_margo.sql
Edit
robisear_marickholdings.sql
Edit
robisear_marksonic.sql
Edit
robisear_marsdiner.sql
Edit
robisear_marvel.sql
Edit
robisear_marvelfeeds.sql
Edit
robisear_masaicafe.sql
Edit
robisear_masid.sql
Edit
robisear_masterbakers.sql
Edit
robisear_matanaha.sql
Edit
robisear_mavunohub.sql
Edit
robisear_maxy.sql
Edit
robisear_maxy1.sql
Edit
robisear_mbotebeers.sql
Edit
robisear_melagrovet.sql
Edit
robisear_memphisresort.sql
Edit
robisear_metalogistics.sql
Edit
robisear_metropolsecurity.sql
Edit
robisear_mfangano.sql
Edit
robisear_mijimiji.sql
Edit
robisear_mijimiji2.sql
Edit
robisear_mijimiji3.sql
Edit
robisear_milans.sql
Edit
robisear_mingleslounge.sql
Edit
robisear_mirage.sql
Edit
robisear_miuguconclave.sql
Edit
robisear_mizpha.sql
Edit
robisear_mkulimahodariagrovet.sql
Edit
robisear_mkuru.sql
Edit
robisear_mliquor.sql
Edit
robisear_mobicare.sql
Edit
robisear_mochabistro.sql
Edit
robisear_modernfurniture.sql
Edit
robisear_moistureplus.sql
Edit
robisear_mollys.sql
Edit
robisear_mollys1.sql
Edit
robisear_mombasacomputers.sql
Edit
robisear_mommieschoice.sql
Edit
robisear_moodkitchens.sql
Edit
robisear_moonstargeneralagencies.sql
Edit
robisear_moselyminisupermarket.sql
Edit
robisear_msczoneltd.sql
Edit
robisear_mtaanichemist.sql
Edit
robisear_mugisof.sql
Edit
robisear_mugisoft.sql
Edit
robisear_muhsintailor.sql
Edit
robisear_mukielect.sql
Edit
robisear_mukscreation.sql
Edit
robisear_mumbuni.sql
Edit
robisear_mumsgarden.sql
Edit
robisear_muncheezbstr.sql
Edit
robisear_mursons.sql
Edit
robisear_mustafa.sql
Edit
robisear_muturis.sql
Edit
robisear_muyia.sql
Edit
robisear_mwaketa.sql
Edit
robisear_mybulksms.sql
Edit
robisear_mydallas.sql
Edit
robisear_myerp.sql
Edit
robisear_mypos.sql
Edit
robisear_nafuu.sql
Edit
robisear_nairobiclearing.sql
Edit
robisear_nanarestaurants.sql
Edit
robisear_napuuventures.robisearch.com.sql
Edit
robisear_napuuventures.sql
Edit
robisear_natives.sql
Edit
robisear_natives2.sql
Edit
robisear_natives3.sql
Edit
robisear_naturalchill.sql
Edit
robisear_naturalglam.sql
Edit
robisear_ndumia.sql
Edit
robisear_nebacholdings.sql
Edit
robisear_neighbourhoodnook.sql
Edit
robisear_nemwa.sql
Edit
robisear_neokenya.sql
Edit
robisear_netbyteapps.sql
Edit
robisear_new.sql
Edit
robisear_newlamuhaven.sql
Edit
robisear_newpickandpay.sql
Edit
robisear_newrobi.sql
Edit
robisear_nextlevelhardware.sql
Edit
robisear_ngatha.sql
Edit
robisear_nia.sql
Edit
robisear_nithibakers.sql
Edit
robisear_njd.sql
Edit
robisear_njorobeer.sql
Edit
robisear_njoshi.sql
Edit
robisear_nomadcycle.sql
Edit
robisear_noorelectronics.sql
Edit
robisear_nordicparts.sql
Edit
robisear_nordicparts2.sql
Edit
robisear_nordicparts3.sql
Edit
robisear_nordlys.sql
Edit
robisear_norkun.sql
Edit
robisear_nunos.sql
Edit
robisear_nuria.sql
Edit
robisear_nyamiraheights.sql
Edit
robisear_nyamiraheightsspa.sql
Edit
robisear_nysishotel.sql
Edit
robisear_nzimuh.sql
Edit
robisear_nzumbipms.sql
Edit
robisear_oasis.sql
Edit
robisear_oasispremiumfloor.sql
Edit
robisear_obicarautospares.sql
Edit
robisear_obsha.sql
Edit
robisear_obuntu.sql
Edit
robisear_olivehotels.sql
Edit
robisear_omeron.sql
Edit
robisear_onestop.sql
Edit
robisear_online1shop.sql
Edit
robisear_online2shop.sql
Edit
robisear_onlinecompanylimited.sql
Edit
robisear_onlinemobile.sql
Edit
robisear_onlinemobileeastleigh.sql
Edit
robisear_optispeed.sql
Edit
robisear_orangeriver.sql
Edit
robisear_orchards.sql
Edit
robisear_orchardscomm.sql
Edit
robisear_orchardscommltd.sql
Edit
robisear_organella.sql
Edit
robisear_osonayarns.sql
Edit
robisear_osupukoresort.sql
Edit
robisear_otadvocates.sql
Edit
robisear_ouad.sql
Edit
robisear_outsprings.sql
Edit
robisear_outsprings2.sql
Edit
robisear_paintdepo.sql
Edit
robisear_pamojagardens.sql
Edit
robisear_pareetalectrical.sql
Edit
robisear_pareetalectricals.sql
Edit
robisear_parisi.sql
Edit
robisear_parisi2.sql
Edit
robisear_parisi3.sql
Edit
robisear_paritahardware.sql
Edit
robisear_paritahardware2.sql
Edit
robisear_paritahardware3.sql
Edit
robisear_parkside.sql
Edit
robisear_parkside1.sql
Edit
robisear_parminihardware.sql
Edit
robisear_pastoralvet.sql
Edit
robisear_patanyumba.sql
Edit
robisear_patrica.sql
Edit
robisear_pauwil.sql
Edit
robisear_peacemeats.sql
Edit
robisear_pecyuniforms.sql
Edit
robisear_pelicanmetal.sql
Edit
robisear_pendo.sql
Edit
robisear_pendo1.sql
Edit
robisear_pensortium.sql
Edit
robisear_perfectpackaging.sql
Edit
robisear_petrooilkenyaltd.sql
Edit
robisear_pharmaallied.sql
Edit
robisear_phasedesign.sql
Edit
robisear_philbackers.sql
Edit
robisear_phoeniciahotel.sql
Edit
robisear_pilanobookshop.sql
Edit
robisear_pillcare.sql
Edit
robisear_piratesbeachmeatcenter.sql
Edit
robisear_piratesbeachpark.sql
Edit
robisear_pizarrarestaurant.sql
Edit
robisear_pjay.sql
Edit
robisear_placidoinvestment.sql
Edit
robisear_planet.sql
Edit
robisear_platinum.sql
Edit
robisear_platinum2.sql
Edit
robisear_pmcsupermarket.sql
Edit
robisear_poj.sql
Edit
robisear_polished.sql
Edit
robisear_politics.sql
Edit
robisear_popote.sql
Edit
robisear_porche.sql
Edit
robisear_porkysbarbecue.sql
Edit
robisear_pos.sql
Edit
robisear_poshplace.sql
Edit
robisear_powermart.sql
Edit
robisear_pramukh.sql
Edit
robisear_pramukhinvestment.sql
Edit
robisear_premier.sql
Edit
robisear_premierbeauty.sql
Edit
robisear_prestonhardware.sql
Edit
robisear_primevoy.sql
Edit
robisear_promze.sql
Edit
robisear_pronala.sql
Edit
robisear_propertwelveliquor.sql
Edit
robisear_protouch.sql
Edit
robisear_provenance.sql
Edit
robisear_pvtech.sql
Edit
robisear_qcc.sql
Edit
robisear_qiues.sql
Edit
robisear_quench.sql
Edit
robisear_quepasa.sql
Edit
robisear_quepasa1.sql
Edit
robisear_quillslounge.sql
Edit
robisear_quiver.sql
Edit
robisear_rafiki.sql
Edit
robisear_rafikitriple4.sql
Edit
robisear_raphymart.sql
Edit
robisear_rawhew.sql
Edit
robisear_rawhew1.sql
Edit
robisear_redbrickdairyandfood.sql
Edit
robisear_redc.sql
Edit
robisear_redemtar.sql
Edit
robisear_renbridge.sql
Edit
robisear_resellers.sql
Edit
robisear_restopark.sql
Edit
robisear_revaplaceresort.sql
Edit
robisear_riaraminimart.sql
Edit
robisear_ricamosupplies.sql
Edit
robisear_richblend.sql
Edit
robisear_richman.sql
Edit
robisear_richman2.sql
Edit
robisear_richman3.sql
Edit
robisear_rievshop.sql
Edit
robisear_rimatholdings1.sql
Edit
robisear_rira.sql
Edit
robisear_rivermart.sql
Edit
robisear_rivervale.sql
Edit
robisear_riziki.sql
Edit
robisear_robbiefarm.sql
Edit
robisear_robierp.sql
Edit
robisear_robihotel.sql
Edit
robisear_robimalimali.sql
Edit
robisear_robipms.sql
Edit
robisear_robiposhotel.sql
Edit
robisear_robisear_elishammah.sql
Edit
robisear_robisearch.sql
Edit
robisear_robisearchuganda.sql
Edit
robisear_rodi.sql
Edit
robisear_rohima.sql
Edit
robisear_rohima2.sql
Edit
robisear_rohosingo.sql
Edit
robisear_rokeen.sql
Edit
robisear_ronleb.sql
Edit
robisear_ronleb1.sql
Edit
robisear_ronlebtech.sql
Edit
robisear_rooftopbistro.sql
Edit
robisear_root.sql
Edit
robisear_rootscosmestics.sql
Edit
robisear_rootzcosmetics.sql
Edit
robisear_rootzcosmetics2.sql
Edit
robisear_rootzcosmetics3.sql
Edit
robisear_rophinefieldschools.sql
Edit
robisear_rosetex.sql
Edit
robisear_rositainvestment.sql
Edit
robisear_royal.sql
Edit
robisear_royalelectronics.sql
Edit
robisear_royalhardware.sql
Edit
robisear_royalmeals.sql
Edit
robisear_rubicon.sql
Edit
robisear_sabby.sql
Edit
robisear_sabizpizza.sql
Edit
robisear_sacco.sql
Edit
robisear_safetymax.sql
Edit
robisear_sahishapes.sql
Edit
robisear_sales.sql
Edit
robisear_samareeb.sql
Edit
robisear_samoo.sql
Edit
robisear_samtechgroup.sql
Edit
robisear_sanch.sql
Edit
robisear_sarmerk.sql
Edit
robisear_saroz.sql
Edit
robisear_saruk.sql
Edit
robisear_saruk1.sql
Edit
robisear_saruk2.sql
Edit
robisear_sasabone.sql
Edit
robisear_sausen.sql
Edit
robisear_savannah.sql
Edit
robisear_savour.sql
Edit
robisear_saxandviolins.sql
Edit
robisear_sayariagriscience.sql
Edit
robisear_sayaricrafts.sql
Edit
robisear_sbhotel.sql
Edit
robisear_scentskenyaltd.sql
Edit
robisear_schoolmall.sql
Edit
robisear_scodra.sql
Edit
robisear_seasonlogistics.sql
Edit
robisear_seasons.sql
Edit
robisear_selcafe.sql
Edit
robisear_selella.sql
Edit
robisear_serenityforthotel.sql
Edit
robisear_shack.sql
Edit
robisear_shafan.sql
Edit
robisear_shakaz.sql
Edit
robisear_shakesspeare.sql
Edit
robisear_sharjah.sql
Edit
robisear_sherattonbeachvillagio.sql
Edit
robisear_sherattonregency.sql
Edit
robisear_sherattonregencymombasa.sql
Edit
robisear_sherryliquorbar.sql
Edit
robisear_shopearl.sql
Edit
robisear_shopearl2.sql
Edit
robisear_shopwise.sql
Edit
robisear_shotsandbarrel.sql
Edit
robisear_shotsandbarrel1.sql
Edit
robisear_shotsandbarrel2.sql
Edit
robisear_shreeji.sql
Edit
robisear_shreejimerultd.sql
Edit
robisear_shujaa.sql
Edit
robisear_shujaawangu.sql
Edit
robisear_shukri.sql
Edit
robisear_sierracaves.sql
Edit
robisear_silver.sql
Edit
robisear_silverline.sql
Edit
robisear_silverviewhardware.sql
Edit
robisear_sipamaquaticsltd.sql
Edit
robisear_siwamu.sql
Edit
robisear_skysailmabati.sql
Edit
robisear_skyveltd.sql
Edit
robisear_snl.sql
Edit
robisear_snowdessertea.sql
Edit
robisear_sokima.sql
Edit
robisear_sokofreshpoint.sql
Edit
robisear_sokojumla.sql
Edit
robisear_somcityhealth.sql
Edit
robisear_spiceland.sql
Edit
robisear_spicelands.sql
Edit
robisear_spikessanford.sql
Edit
robisear_spotpartystop.sql
Edit
robisear_springs.sql
Edit
robisear_starfox.sql
Edit
robisear_starsngarters.sql
Edit
robisear_stedan.sql
Edit
robisear_sterling.sql
Edit
robisear_stfrancisofassisi.sql
Edit
robisear_stjohn.sql
Edit
robisear_stopajali.sql
Edit
robisear_straitsolar.sql
Edit
robisear_sts.sql
Edit
robisear_stylesandfinishesltd.sql
Edit
robisear_sugarspicebeauty.sql
Edit
robisear_suki.sql
Edit
robisear_sukimart.sql
Edit
robisear_sultanmabi.sql
Edit
robisear_summeroasis.sql
Edit
robisear_summeroasis1.sql
Edit
robisear_summersprings.sql
Edit
robisear_summersprings2.sql
Edit
robisear_sunati.sql
Edit
robisear_sunbreeze.sql
Edit
robisear_sunshine.sql
Edit
robisear_sunshinemobilespares.sql
Edit
robisear_sunuk.sql
Edit
robisear_superb.sql
Edit
robisear_superiorhardware.sql
Edit
robisear_supermarket.sql
Edit
robisear_superp.sql
Edit
robisear_supreme.sql
Edit
robisear_suraj.sql
Edit
robisear_sweeftfleet.sql
Edit
robisear_swisderm.sql
Edit
robisear_swissgrade.sql
Edit
robisear_syano.sql
Edit
robisear_syanotanau.sql
Edit
robisear_symphonylounge.sql
Edit
robisear_synergydealsltd.sql
Edit
robisear_tabarukfoods.sql
Edit
robisear_tamasha.sql
Edit
robisear_tanzaken.sql
Edit
robisear_tawas.sql
Edit
robisear_tayariluxury.sql
Edit
robisear_tazamatt.sql
Edit
robisear_techsquire.sql
Edit
robisear_techsquires.sql
Edit
robisear_techwizardcctvltd.sql
Edit
robisear_tekidi.sql
Edit
robisear_tembuzicultural.sql
Edit
robisear_temic.sql
Edit
robisear_tessara.sql
Edit
robisear_tessymso.sql
Edit
robisear_test.sql
Edit
robisear_test2.sql
Edit
robisear_texas.sql
Edit
robisear_tgm.sql
Edit
robisear_thalloventures.sql
Edit
robisear_thecilantrokitchens.sql
Edit
robisear_thediner.sql
Edit
robisear_theheadquartersportbar.sql
Edit
robisear_theheadquartersportbar2.sql
Edit
robisear_thehubfoodcourt.sql
Edit
robisear_theindulge.sql
Edit
robisear_thejunctionlounge.sql
Edit
robisear_thelab.sql
Edit
robisear_themorningperkcafe.sql
Edit
robisear_theoffice.sql
Edit
robisear_thirsty.sql
Edit
robisear_timboni.sql
Edit
robisear_timiza.sql
Edit
robisear_timizamachakos.sql
Edit
robisear_timushamba.sql
Edit
robisear_tir.sql
Edit
robisear_toasts.sql
Edit
robisear_tolaenergies.sql
Edit
robisear_toplevel.sql
Edit
robisear_toplinesurgicals.sql
Edit
robisear_topmark.sql
Edit
robisear_toshadawa.sql
Edit
robisear_toshenterprises.sql
Edit
robisear_transfordchemist.sql
Edit
robisear_travellamembers.sql
Edit
robisear_trax.sql
Edit
robisear_tripeakbrands.sql
Edit
robisear_triplec.sql
Edit
robisear_tripointpizzeria.sql
Edit
robisear_trivetachemist.sql
Edit
robisear_trivetandundoripos.sql
Edit
robisear_tronlink.sql
Edit
robisear_trueblueliqour.sql
Edit
robisear_truvalue.sql
Edit
robisear_truvalues.sql
Edit
robisear_tsukimino.sql
Edit
robisear_tucasa.sql
Edit
robisear_tucasa1.sql
Edit
robisear_tulimepamojaagrovet.sql
Edit
robisear_tundaville.sql
Edit
robisear_tunubeverage.sql
Edit
robisear_turpean.sql
Edit
robisear_tuutis.sql
Edit
robisear_twiga.sql
Edit
robisear_twinstepsltd.sql
Edit
robisear_typsy.sql
Edit
robisear_ujminimart.sql
Edit
robisear_ulalo.sql
Edit
robisear_uncurbedbeauty.sql
Edit
robisear_undertheswahilitree.sql
Edit
robisear_union.sql
Edit
robisear_upriseminisupa.sql
Edit
robisear_upsaleskeltd.sql
Edit
robisear_uptown.sql
Edit
robisear_uptown2.sql
Edit
robisear_uptownkibali.sql
Edit
robisear_urwani.sql
Edit
robisear_utange.sql
Edit
robisear_vaitamutheisupplies.sql
Edit
robisear_veewmart.sql
Edit
robisear_vezmartexpress.sql
Edit
robisear_viewersparkhotel.sql
Edit
robisear_viewjoint.sql
Edit
robisear_vnd.sql
Edit
robisear_walenisirestaurant.sql
Edit
robisear_walenisirestaurantmain.sql
Edit
robisear_wama.sql
Edit
robisear_wamotech.sql
Edit
robisear_wamweaholdings.sql
Edit
robisear_waqf.sql
Edit
robisear_wasafiarcade.sql
Edit
robisear_watergaspoint.sql
Edit
robisear_waterkiosk.sql
Edit
robisear_waterworld.sql
Edit
robisear_weaverbird.sql
Edit
robisear_westerncosmetics.sql
Edit
robisear_westlightlounge.sql
Edit
robisear_westlitelounge.sql
Edit
robisear_westmill.sql
Edit
robisear_weststands.sql
Edit
robisear_whitehouse.sql
Edit
robisear_whitekitchen.sql
Edit
robisear_wifimatt.sql
Edit
robisear_winter.sql
Edit
robisear_wiresmore.sql
Edit
robisear_wistantechnology.sql
Edit
robisear_wm.sql
Edit
robisear_woodlandgardens.sql
Edit
robisear_woodstock.sql
Edit
robisear_woodstock1.sql
Edit
robisear_wrappedfoods.sql
Edit
robisear_write.sql
Edit
robisear_xtranet.sql
Edit
robisear_ycs.sql
Edit
robisear_zakacapital.sql
Edit
robisear_zgt.sql
Edit
robisear_zishaan.sql
Edit
robisear_zmf.sql
Edit
robisear_zurikarttraders.sql
Edit
sys.sql
Edit