/*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