-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: 127.0.0.1 Database: missionsuite_db -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!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 `announcements` -- DROP TABLE IF EXISTS `announcements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `announcements` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `body` text NOT NULL, `audience` enum('public','staff','both') NOT NULL DEFAULT 'both', `is_published` tinyint(1) NOT NULL DEFAULT 1, `starts_at` date DEFAULT NULL, `ends_at` date DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_announcements_published` (`is_published`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `announcements` -- LOCK TABLES `announcements` WRITE; /*!40000 ALTER TABLE `announcements` DISABLE KEYS */; INSERT INTO `announcements` VALUES (1,'2026 Global Missions Conference Registration Now Open','Join us September 7 in Lagos for worship, training and fellowship with missionaries from across our network.','both',1,NULL,NULL,NULL,'2026-08-04 16:31:13','2026-08-08 16:31:13'),(2,'Scheduled Maintenance','The donor portal will be briefly unavailable Sunday night for scheduled maintenance.','staff',1,NULL,NULL,NULL,'2026-07-29 16:31:13','2026-08-08 16:31:13'),(3,'Q2 Field Reports Due','All mission field coordinators should submit Q2 field reports by the end of the month.','staff',0,NULL,NULL,NULL,'2026-08-06 16:31:13','2026-08-08 16:31:13'); /*!40000 ALTER TABLE `announcements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `audit_logs` -- DROP TABLE IF EXISTS `audit_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `audit_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `user_label` varchar(200) DEFAULT NULL, `action` varchar(50) NOT NULL, `module` varchar(50) NOT NULL, `record_id` bigint(20) unsigned DEFAULT NULL, `description` varchar(500) DEFAULT NULL, `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)), `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)), `ip_address` varchar(45) DEFAULT NULL, `user_agent` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_audit_logs_module` (`module`), KEY `idx_audit_logs_user` (`user_id`), KEY `idx_audit_logs_created` (`created_at`), CONSTRAINT `fk_audit_logs_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit_logs` -- LOCK TABLES `audit_logs` WRITE; /*!40000 ALTER TABLE `audit_logs` DISABLE KEYS */; INSERT INTO `audit_logs` VALUES (1,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:22:04'),(2,NULL,'Test Viewer (viewer)','LOGIN','auth',2,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:22:51'),(3,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:24:09'),(4,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:25:31'),(5,1,'Test Admin (super_administrator)','UPDATE','roles',11,'',NULL,'{\"permission_count\":1}','::1','curl/8.16.0','2026-08-08 10:25:32'),(6,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:34:25'),(7,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 10:57:44'),(8,1,'Test Admin (super_administrator)','STATUS_CHANGE','cms',2,'','{\"status\":\"published\"}','{\"status\":\"featured\"}','::1','curl/8.16.0','2026-08-08 10:58:28'),(9,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 11:13:36'),(10,1,'Test Admin (super_administrator)','create','cms',1,'Created slider \"Welcome to MissionSuite\"',NULL,'{\"title\":\"Welcome to MissionSuite\"}','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 11:17:21'),(11,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 11:17:31'),(12,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 14:55:17'),(13,1,'Test Admin (super_administrator)','create','missionaries',5,'Deployed missionary \"Grace Nwankwo\"',NULL,'{\"name\":\"Grace Nwankwo\"}','::1','curl/8.16.0','2026-08-08 14:55:39'),(14,1,'Test Admin (super_administrator)','delete','missionaries',5,'Archived missionary \"Grace Nwankwo\"','{\"id\":5,\"name\":\"Grace Nwankwo\",\"slug\":\"grace-nwankwo\",\"dispatch_code\":\"MS-NI-9721\",\"email\":\"grace@example.com\",\"phone\":\"+234000000\",\"role_title\":\"Medical Missionary\",\"mission_field_id\":1,\"photo_path\":null,\"bio\":\"Runs a weekly clinic serving families.\",\"status\":\"active\",\"deployment_date\":\"2022-05-01\",\"supervising_coordinator\":\"\",\"monthly_support_need\":null,\"support_percentage\":88,\"support_notes\":\"\",\"last_report_date\":null,\"is_published\":1,\"sort_order\":0,\"created_by\":1,\"updated_by\":null,\"created_at\":\"2026-08-08 14:55:39\",\"updated_at\":\"2026-08-08 14:55:39\",\"deleted_at\":null}',NULL,'::1','curl/8.16.0','2026-08-08 14:56:05'),(15,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 15:01:22'),(16,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 15:22:56'),(17,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 15:48:09'),(18,1,'Test Admin (super_administrator)','create','sermons',7,'Uploaded media \"Test Sermon Curl\"',NULL,'{\"title\":\"Test Sermon Curl\"}','::1','curl/8.16.0','2026-08-08 15:50:13'),(19,1,'Test Admin (super_administrator)','update','sermons',7,'Updated media \"Test Sermon Curl Edited\"','{\"id\":7,\"title\":\"Test Sermon Curl\",\"slug\":\"test-sermon-curl\",\"media_type\":\"audio\",\"category\":\"Sermon\",\"speaker\":\"QA Bot\",\"description\":\"\",\"file_path\":\"\\/uploads\\/sermons\\/6a77422582da38.13755137_1786200613.mp3\",\"duration\":\"\",\"publish_date\":\"2026-08-08\",\"plays_count\":1,\"is_published\":1,\"created_by\":1,\"updated_by\":null,\"created_at\":\"2026-08-08 15:50:13\",\"updated_at\":\"2026-08-08 15:50:45\"}','{\"title\":\"Test Sermon Curl Edited\",\"media_type\":\"audio\",\"category\":\"Podcast\",\"speaker\":\"\",\"description\":\"\",\"duration\":\"\",\"publish_date\":\"2026-08-08\",\"is_published\":1,\"slug\":\"test-sermon-curl-edited\"}','::1','curl/8.16.0','2026-08-08 15:50:56'),(20,1,'Test Admin (super_administrator)','delete','sermons',7,'Deleted media \"Test Sermon Curl Edited\"','{\"id\":7,\"title\":\"Test Sermon Curl Edited\",\"slug\":\"test-sermon-curl-edited\",\"media_type\":\"audio\",\"category\":\"Podcast\",\"speaker\":\"\",\"description\":\"\",\"file_path\":\"\\/uploads\\/sermons\\/6a77422582da38.13755137_1786200613.mp3\",\"duration\":\"\",\"publish_date\":\"2026-08-08\",\"plays_count\":1,\"is_published\":1,\"created_by\":1,\"updated_by\":1,\"created_at\":\"2026-08-08 15:50:13\",\"updated_at\":\"2026-08-08 15:50:56\"}',NULL,'::1','curl/8.16.0','2026-08-08 15:51:06'),(21,1,'Test Admin (super_administrator)','create','publications',6,'Created publication \"Test Pub Curl\"',NULL,'{\"title\":\"Test Pub Curl\"}','::1','curl/8.16.0','2026-08-08 15:51:20'),(22,1,'Test Admin (super_administrator)','delete','publications',6,'Deleted publication \"Test Pub Curl\"','{\"id\":6,\"title\":\"Test Pub Curl\",\"slug\":\"test-pub-curl\",\"category\":\"Article\",\"author\":\"QA Bot\",\"summary\":\"\",\"file_path\":\"\\/uploads\\/publications\\/6a774268bb9940.43848625_1786200680.pdf\",\"cover_path\":null,\"publish_date\":\"2026-08-08\",\"downloads_count\":1,\"status\":\"published\",\"notify_subscribers\":0,\"created_by\":1,\"updated_by\":null,\"created_at\":\"2026-08-08 15:51:20\",\"updated_at\":\"2026-08-08 15:51:31\"}',NULL,'::1','curl/8.16.0','2026-08-08 15:51:31'),(23,1,'Test Admin (super_administrator)','STATUS_CHANGE','prayer_requests',2,'','{\"status\":\"praying\"}','{\"status\":\"answered\"}','::1','curl/8.16.0','2026-08-08 15:52:05'),(24,1,'Test Admin (super_administrator)','STATUS_CHANGE','prayer_requests',4,'','{\"status\":\"praying\"}','{\"status\":\"archived\"}','::1','curl/8.16.0','2026-08-08 15:52:06'),(25,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:07:18'),(26,1,'Test Admin (super_administrator)','create','donations',0,'Logged manual donation MAN-0BE01407',NULL,'{\"reference\":\"MAN-0BE01407\"}','::1','curl/8.16.0','2026-08-08 16:07:54'),(27,1,'Test Admin (super_administrator)','STATUS_CHANGE','donations',8,'','{\"status\":\"completed\"}','{\"status\":\"refunded\"}','::1','curl/8.16.0','2026-08-08 16:08:06'),(28,1,'Test Admin (super_administrator)','STATUS_CHANGE','volunteers',8,'','{\"status\":\"pending\"}','{\"status\":\"active\"}','::1','curl/8.16.0','2026-08-08 16:08:56'),(29,1,'Test Admin (super_administrator)','STATUS_CHANGE','volunteers',8,'','{\"status\":\"active\"}','{\"status\":\"inactive\"}','::1','curl/8.16.0','2026-08-08 16:08:56'),(30,1,'Test Admin (super_administrator)','update','volunteers',8,'Updated volunteer record','{\"id\":8,\"name\":\"QA Applicant\",\"email\":\"qaapplicant@example.com\",\"phone\":\"\",\"home_church\":\"\",\"department\":\"Logistics\",\"primary_skill\":\"Testing\",\"additional_skills\":\"\",\"availability\":\"both\",\"project_id\":null,\"event_id\":null,\"status\":\"inactive\",\"created_by\":null,\"updated_by\":1,\"created_at\":\"2026-08-08 16:08:44\",\"updated_at\":\"2026-08-08 16:08:56\"}',NULL,'::1','curl/8.16.0','2026-08-08 16:09:08'),(31,1,'Test Admin (super_administrator)','delete','volunteers',8,'Rejected volunteer application for QA Applicant Edited','{\"id\":8,\"name\":\"QA Applicant Edited\",\"email\":\"qaapplicant@example.com\",\"phone\":\"\",\"home_church\":\"\",\"department\":\"Hospitality\",\"primary_skill\":\"\",\"additional_skills\":\"\",\"availability\":\"local\",\"project_id\":null,\"event_id\":null,\"status\":\"active\",\"created_by\":null,\"updated_by\":1,\"created_at\":\"2026-08-08 16:08:44\",\"updated_at\":\"2026-08-08 16:09:08\"}',NULL,'::1','curl/8.16.0','2026-08-08 16:09:08'),(32,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:31:54'),(33,1,'Test Admin (super_administrator)','create','announcements',4,'Created announcement',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:34:11'),(34,1,'Test Admin (super_administrator)','update','announcements',4,'Updated announcement','{\"id\":4,\"title\":\"QA Test Announcement\",\"body\":\"Testing announcement creation via curl.\",\"audience\":\"both\",\"is_published\":1,\"starts_at\":null,\"ends_at\":null,\"created_by\":1,\"created_at\":\"2026-08-08 16:34:11\",\"updated_at\":\"2026-08-08 16:34:11\"}',NULL,'::1','curl/8.16.0','2026-08-08 16:34:34'),(35,1,'Test Admin (super_administrator)','delete','announcements',4,'Deleted announcement \"QA Test Announcement Edited\"','{\"id\":4,\"title\":\"QA Test Announcement Edited\",\"body\":\"Updated body\",\"audience\":\"public\",\"is_published\":1,\"starts_at\":null,\"ends_at\":null,\"created_by\":1,\"created_at\":\"2026-08-08 16:34:11\",\"updated_at\":\"2026-08-08 16:34:34\"}',NULL,'::1','curl/8.16.0','2026-08-08 16:34:34'),(36,1,'Test Admin (super_administrator)','create','announcements',5,'Created announcement',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:35:36'),(37,1,'Test Admin (super_administrator)','update','announcements',5,'Updated announcement','{\"id\":5,\"title\":\"QA Unpublish Test\",\"body\":\"x\",\"audience\":\"both\",\"is_published\":1,\"starts_at\":null,\"ends_at\":null,\"created_by\":1,\"created_at\":\"2026-08-08 16:35:36\",\"updated_at\":\"2026-08-08 16:35:36\"}',NULL,'::1','curl/8.16.0','2026-08-08 16:35:36'),(38,1,'Test Admin (super_administrator)','SEND','email_campaigns',1,'Sent campaign \"August Field Dispatch\" to 0/1 recipients',NULL,'{\"sent_count\":0}','::1','curl/8.16.0','2026-08-08 16:36:20'),(39,1,'Test Admin (super_administrator)','SEND','email_campaigns',2,'Sent campaign \"Thank You for Your Partnership\" to 0/4 recipients',NULL,'{\"sent_count\":0}','::1','curl/8.16.0','2026-08-08 16:36:44'),(40,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:48:35'),(41,1,'Test Admin (super_administrator)','create','mission_fields',5,'Added mission field \"QA Dedicated Page Field\"',NULL,'{\"name\":\"QA Dedicated Page Field\"}','::1','curl/8.16.0','2026-08-08 16:49:30'),(42,1,'Test Admin (super_administrator)','update','mission_fields',5,'Updated mission field \"QA Dedicated Page Field Edited\"','{\"id\":5,\"name\":\"QA Dedicated Page Field\",\"slug\":\"qa-dedicated-page-field\",\"country\":\"Testland\",\"region\":\"\",\"icon\":\"fa-earth-africa\",\"latitude\":\"\",\"longitude\":\"\",\"coordinator_id\":null,\"description\":\"\",\"photo_path\":null,\"status\":\"new\",\"is_published\":0,\"sort_order\":0,\"created_by\":1,\"updated_by\":null,\"created_at\":\"2026-08-08 16:49:30\",\"updated_at\":\"2026-08-08 16:49:30\"}','{\"name\":\"QA Dedicated Page Field Edited\",\"country\":\"Testland\",\"region\":\"\",\"icon\":\"fa-earth-africa\",\"latitude\":\"\",\"longitude\":\"\",\"coordinator_id\":null,\"description\":\"\",\"status\":\"active\",\"is_published\":0,\"slug\":\"qa-dedicated-page-field-edited\"}','::1','curl/8.16.0','2026-08-08 16:49:46'),(43,1,'Test Admin (super_administrator)','create','events',4,'Created event \"QA Dedicated Event\"',NULL,'{\"title\":\"QA Dedicated Event\"}','::1','curl/8.16.0','2026-08-08 16:50:02'),(44,1,'Test Admin (super_administrator)','SAVE_GENERAL_SETTINGS','settings',NULL,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:57:44'),(45,1,'Test Admin (super_administrator)','SAVE_GENERAL_SETTINGS','settings',NULL,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 16:57:57'),(46,1,'Test Admin (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:17:13'),(47,1,'Test Admin (super_administrator)','LOGOUT','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:17:44'),(48,1,'Techage Inno (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:17:57'),(49,1,'Techage Inno (super_administrator)','SAVE_GENERAL_SETTINGS','settings',NULL,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:20:56'),(50,1,'Techage Inno (super_administrator)','LOGOUT','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:21:13'),(51,1,'Techage Inno (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:26:56'),(52,1,'Techage Inno (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 19:44:25'),(53,1,'Techage Inno (super_administrator)','LOGIN','auth',1,'',NULL,NULL,'::1','curl/8.16.0','2026-08-08 19:52:01'),(54,1,'Techage Inno (super_administrator)','create','volunteers',9,'Added volunteer record',NULL,NULL,'::1','curl/8.16.0','2026-08-08 20:04:43'),(57,1,'Techage Inno (super_administrator)','BULK_DELETE','audit_logs',0,'Deleted 2 activity log entries',NULL,'{\"count\":2}','::1','curl/8.16.0','2026-08-08 20:33:58'); /*!40000 ALTER TABLE `audit_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `branches` -- DROP TABLE IF EXISTS `branches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `branches` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `country` varchar(100) DEFAULT NULL, `city` varchar(100) DEFAULT NULL, `is_default` tinyint(1) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `branches` -- LOCK TABLES `branches` WRITE; /*!40000 ALTER TABLE `branches` DISABLE KEYS */; INSERT INTO `branches` VALUES (1,'Head Office',NULL,NULL,1,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(2,'Head Office',NULL,NULL,1,1,'2026-08-08 10:18:17','2026-08-08 10:18:17'); /*!40000 ALTER TABLE `branches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_messages` -- DROP TABLE IF EXISTS `contact_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `phone` varchar(30) DEFAULT NULL, `department` varchar(100) DEFAULT NULL, `subject` varchar(200) NOT NULL, `message` text NOT NULL, `status` enum('new','read','replied','archived') NOT NULL DEFAULT 'new', `replied_message` text DEFAULT NULL, `replied_by` bigint(20) unsigned DEFAULT NULL, `replied_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_contact_messages_status` (`status`), KEY `fk_contact_messages_replied_by` (`replied_by`), CONSTRAINT `fk_contact_messages_replied_by` FOREIGN KEY (`replied_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_messages` -- LOCK TABLES `contact_messages` WRITE; /*!40000 ALTER TABLE `contact_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_offices` -- DROP TABLE IF EXISTS `contact_offices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_offices` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `description` varchar(300) DEFAULT NULL, `icon` varchar(60) NOT NULL DEFAULT 'fa-building', `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_offices` -- LOCK TABLES `contact_offices` WRITE; /*!40000 ALTER TABLE `contact_offices` DISABLE KEYS */; INSERT INTO `contact_offices` VALUES (1,'Regional Office','Serving nearby mission fields.','fa-mountain-sun',1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(2,'Field Office','Coordinating regional operations.','fa-seedling',2,'2026-08-08 10:56:02','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `contact_offices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `donations` -- DROP TABLE IF EXISTS `donations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `donations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `donor_name` varchar(150) NOT NULL, `donor_email` varchar(150) NOT NULL, `is_anonymous` tinyint(1) NOT NULL DEFAULT 0, `amount` decimal(14,2) NOT NULL, `frequency` enum('one_time','monthly') NOT NULL DEFAULT 'one_time', `campaign` varchar(150) NOT NULL DEFAULT 'General Fund', `project_id` bigint(20) unsigned DEFAULT NULL, `gateway` enum('paystack','manual') NOT NULL DEFAULT 'paystack', `payment_method` varchar(30) DEFAULT NULL COMMENT 'card, bank_transfer, ussd, cash, cheque -- populated once known', `reference` varchar(100) NOT NULL, `status` enum('pending','completed','failed','refunded') NOT NULL DEFAULT 'pending', `notes` varchar(255) DEFAULT NULL, `received_at` date DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL COMMENT 'set when logged manually by an admin', `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_donations_reference` (`reference`), KEY `idx_donations_status` (`status`), KEY `idx_donations_email` (`donor_email`), KEY `fk_donations_project` (`project_id`), CONSTRAINT `fk_donations_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `donations` -- LOCK TABLES `donations` WRITE; /*!40000 ALTER TABLE `donations` DISABLE KEYS */; INSERT INTO `donations` VALUES (1,'Adaeze Nwosu','adaeze.nwosu@example.com',0,50000.00,'one_time','General Fund',NULL,'manual','Bank Transfer','MAN-88213001','completed',NULL,'2026-08-07',NULL,'2026-08-07 16:06:16','2026-08-08 16:06:16'),(2,'Tolu Bakare','tolu.bakare@example.com',0,25000.00,'monthly','Project',1,'manual','Bank Transfer','MAN-40217002','completed',NULL,'2026-08-07',NULL,'2026-08-07 16:06:16','2026-08-08 16:06:16'),(3,'Anonymous Donor','anonymous@example.com',1,150000.00,'one_time','Missionary Support',NULL,'manual','Cash','MAN-88190003','completed',NULL,'2026-08-06',NULL,'2026-08-06 16:06:16','2026-08-08 16:06:16'),(4,'Kunle Ogundele','kunle.ogundele@example.com',0,10000.00,'one_time','Project',2,'manual','Cash','MAN-11532004','pending',NULL,NULL,NULL,'2026-08-06 16:06:16','2026-08-08 16:06:16'),(5,'Chiamaka Hassan','chiamaka.hassan@example.com',0,85000.00,'one_time','General Fund',NULL,'manual','Bank Transfer','MAN-88104005','completed',NULL,'2026-08-05',NULL,'2026-08-05 16:06:16','2026-08-08 16:06:16'),(6,'Rebecca Williams','rebecca.williams@example.com',0,200000.00,'one_time','Missionary Support',NULL,'manual','Cheque','MAN-00931006','completed',NULL,'2026-08-03',NULL,'2026-08-03 16:06:16','2026-08-08 16:06:16'),(7,'David Eze','david.eze@example.com',0,15000.00,'one_time','General Fund',NULL,'manual','Bank Transfer','MAN-87990007','refunded',NULL,'2026-07-30',NULL,'2026-07-30 16:06:16','2026-08-08 16:06:16'); /*!40000 ALTER TABLE `donations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_campaigns` -- DROP TABLE IF EXISTS `email_campaigns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email_campaigns` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(200) NOT NULL, `body` text NOT NULL, `audience` enum('newsletter','donors','volunteers') NOT NULL DEFAULT 'newsletter', `status` enum('draft','sending','sent','failed') NOT NULL DEFAULT 'draft', `recipient_count` int(10) unsigned NOT NULL DEFAULT 0, `sent_count` int(10) unsigned NOT NULL DEFAULT 0, `sent_at` datetime DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_campaigns` -- LOCK TABLES `email_campaigns` WRITE; /*!40000 ALTER TABLE `email_campaigns` DISABLE KEYS */; INSERT INTO `email_campaigns` VALUES (1,'August Field Dispatch','Read about this month\'s new missionary deployments, project milestones and upcoming events in our latest field dispatch.','newsletter','draft',0,0,NULL,NULL,'2026-08-07 16:31:13','2026-08-08 16:36:56'),(2,'Thank You for Your Partnership','We are grateful for your continued generosity — here is a look at how your gifts are making a difference this quarter.','donors','draft',0,0,NULL,NULL,'2026-08-02 16:31:13','2026-08-08 16:36:56'); /*!40000 ALTER TABLE `email_campaigns` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `error_logs` -- DROP TABLE IF EXISTS `error_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `error_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `error_code` varchar(20) DEFAULT NULL, `exception_class` varchar(150) DEFAULT NULL, `message` text DEFAULT NULL, `file` varchar(500) DEFAULT NULL, `line` int(11) DEFAULT NULL, `url` varchar(500) DEFAULT NULL, `http_method` varchar(10) DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_label` varchar(200) DEFAULT NULL, `trace` longtext DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `error_logs` -- LOCK TABLES `error_logs` WRITE; /*!40000 ALTER TABLE `error_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `error_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_registrations` -- DROP TABLE IF EXISTS `event_registrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_registrations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event_id` bigint(20) unsigned NOT NULL, `registration_code` varchar(20) NOT NULL, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `phone` varchar(30) DEFAULT NULL, `attendees_count` int(10) unsigned NOT NULL DEFAULT 1, `status` enum('registered','checked_in','cancelled') NOT NULL DEFAULT 'registered', `checked_in_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_event_registrations_code` (`registration_code`), KEY `idx_event_registrations_event` (`event_id`), CONSTRAINT `fk_event_registrations_event` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_registrations` -- LOCK TABLES `event_registrations` WRITE; /*!40000 ALTER TABLE `event_registrations` DISABLE KEYS */; /*!40000 ALTER TABLE `event_registrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `events` -- DROP TABLE IF EXISTS `events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `events` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `slug` varchar(210) NOT NULL, `event_type` varchar(100) NOT NULL DEFAULT 'Conference', `description` text DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `location` varchar(200) DEFAULT NULL, `format` enum('in_person','online','hybrid') NOT NULL DEFAULT 'in_person', `start_at` datetime NOT NULL, `end_at` datetime DEFAULT NULL, `capacity` int(10) unsigned DEFAULT NULL, `fee` decimal(12,2) NOT NULL DEFAULT 0.00, `registration_deadline` date DEFAULT NULL, `qr_checkin_enabled` tinyint(1) NOT NULL DEFAULT 1, `schedule_notes` text DEFAULT NULL, `status` enum('upcoming','open','closed','cancelled') NOT NULL DEFAULT 'upcoming', `is_published` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_events_slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `events` -- LOCK TABLES `events` WRITE; /*!40000 ALTER TABLE `events` DISABLE KEYS */; INSERT INTO `events` VALUES (1,'Global Missions Conference','global-missions-conference','Conference','Our flagship annual gathering for missionaries, partners and volunteers to worship, learn and connect.',NULL,'Lagos, Nigeria','in_person','2026-09-07 15:21:23',NULL,800,0.00,NULL,1,NULL,'open',1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'),(2,'Short-Term Mission Trip','short-term-mission-trip','Mission Trip','A two-week hands-on outreach trip supporting church planting and community development work.',NULL,'Great Lakes Region','in_person','2026-10-02 15:21:23',NULL,30,50000.00,NULL,1,NULL,'open',1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'),(3,'Leadership Training Seminar','leadership-training-seminar','Leadership Training','Equipping local church leaders with practical tools for discipleship and ministry growth.',NULL,'Online / Hybrid','hybrid','2026-10-19 15:21:23',NULL,200,0.00,NULL,1,NULL,'upcoming',1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'); /*!40000 ALTER TABLE `events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faq_categories` -- DROP TABLE IF EXISTS `faq_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faq_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(120) NOT NULL, `icon` varchar(60) NOT NULL DEFAULT 'fa-circle-info', `sort_order` int(11) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `uq_faq_categories_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faq_categories` -- LOCK TABLES `faq_categories` WRITE; /*!40000 ALTER TABLE `faq_categories` DISABLE KEYS */; INSERT INTO `faq_categories` VALUES (1,'General','fa-circle-info',1),(2,'Donations & Giving','fa-hand-holding-dollar',2),(3,'Missionary Support','fa-user-group',3),(4,'Volunteering','fa-people-group',4); /*!40000 ALTER TABLE `faq_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faqs` -- DROP TABLE IF EXISTS `faqs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faqs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `question` varchar(300) NOT NULL, `answer` text NOT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_faqs_category` (`category_id`), CONSTRAINT `fk_faqs_category` FOREIGN KEY (`category_id`) REFERENCES `faq_categories` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faqs` -- LOCK TABLES `faqs` WRITE; /*!40000 ALTER TABLE `faqs` DISABLE KEYS */; INSERT INTO `faqs` VALUES (1,1,'What is MissionSuite?','MissionSuite is a ministry management platform that helps mission organizations coordinate missionaries, mission fields, outreach projects, events, prayer requests and donations from one console.',1,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(2,1,'Is this ministry affiliated with a specific denomination?','We are an interdenominational evangelical mission organization, partnering with local churches of many traditions in every field we serve.',1,2,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(3,2,'How much of my donation goes directly to the field?','98.2% of donations go directly to field programs. The remainder covers essential administrative and compliance costs.',1,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(4,2,'What payment methods do you accept?','We accept card payments, bank transfer and USSD via Paystack and Flutterwave, as well as manual bank transfer for larger or international gifts.',1,2,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(5,2,'Can I set up a recurring monthly gift?','Yes — choose \"Monthly\" on the Donate page before selecting your amount.',1,3,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(6,3,'How do I sponsor a specific missionary?','Visit a missionary\'s profile page and click \"Sponsor This Missionary.\"',1,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(7,4,'How do I apply to volunteer?','Visit the Volunteer page, choose a department, and submit your application. Our Volunteer Coordinator will follow up within a week.',1,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `faqs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mission_fields` -- DROP TABLE IF EXISTS `mission_fields`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mission_fields` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `slug` varchar(160) NOT NULL, `country` varchar(100) NOT NULL, `region` varchar(100) DEFAULT NULL, `icon` varchar(60) NOT NULL DEFAULT 'fa-earth-africa', `latitude` varchar(30) DEFAULT NULL, `longitude` varchar(30) DEFAULT NULL, `coordinator_id` bigint(20) unsigned DEFAULT NULL, `description` text DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `status` enum('new','active','closed') NOT NULL DEFAULT 'new', `is_published` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_mission_fields_slug` (`slug`), KEY `idx_mission_fields_coordinator` (`coordinator_id`), CONSTRAINT `fk_mission_fields_coordinator` FOREIGN KEY (`coordinator_id`) REFERENCES `missionaries` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mission_fields` -- LOCK TABLES `mission_fields` WRITE; /*!40000 ALTER TABLE `mission_fields` DISABLE KEYS */; INSERT INTO `mission_fields` VALUES (1,'Northern Corridor','northern-corridor','Nigeria','West Africa','fa-mountain-sun','11.9964','8.5167',1,'Church planting and Bible translation among Hausa- and Fulfulde-speaking communities across the northern corridor.',NULL,'active',1,1,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24'),(2,'Great Lakes Region','great-lakes-region','Uganda','East Africa','fa-water','1.3733','32.2903',4,'Medical outreach, orphan care and leadership training across border districts in the Great Lakes region.',NULL,'new',1,2,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24'),(3,'River Delta Outreach','river-delta-outreach','Cambodia','Southeast Asia','fa-seedling','11.5564','104.9282',3,'Rural discipleship and vocational training partnered with local congregations along the river delta.',NULL,'active',1,3,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24'),(4,'Rift Valley','rift-valley','Kenya','East Africa','fa-hill-rockslide','0.0236','37.9062',2,'Clean water access, mobile clinics and church planting among pastoralist communities.',NULL,'active',1,4,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24'); /*!40000 ALTER TABLE `mission_fields` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `missionaries` -- DROP TABLE IF EXISTS `missionaries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `missionaries` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `slug` varchar(160) NOT NULL, `dispatch_code` varchar(30) NOT NULL, `email` varchar(150) DEFAULT NULL, `phone` varchar(30) DEFAULT NULL, `role_title` varchar(100) NOT NULL DEFAULT 'Missionary', `mission_field_id` bigint(20) unsigned DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `bio` text DEFAULT NULL, `status` enum('pending','active','furlough','closed') NOT NULL DEFAULT 'pending', `deployment_date` date DEFAULT NULL, `supervising_coordinator` varchar(150) DEFAULT NULL, `monthly_support_need` decimal(12,2) DEFAULT NULL, `support_percentage` tinyint(3) unsigned NOT NULL DEFAULT 0, `support_notes` text DEFAULT NULL, `last_report_date` date DEFAULT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_missionaries_slug` (`slug`), UNIQUE KEY `uq_missionaries_dispatch_code` (`dispatch_code`), KEY `idx_missionaries_field` (`mission_field_id`), CONSTRAINT `fk_missionaries_field` FOREIGN KEY (`mission_field_id`) REFERENCES `mission_fields` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `missionaries` -- LOCK TABLES `missionaries` WRITE; /*!40000 ALTER TABLE `missionaries` DISABLE KEYS */; INSERT INTO `missionaries` VALUES (1,'Ruth Adebayo','ruth-adebayo','MS-NG-0142',NULL,NULL,'Church Planter',1,NULL,'Ruth leads a team of local pastors across fourteen congregations in Northern Nigeria, training church leaders and coordinating outreach to unreached communities.','active','2019-03-01',NULL,NULL,92,NULL,NULL,1,1,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24',NULL),(2,'James Tanko','james-tanko','MS-KE-0059',NULL,NULL,'Coordinator',4,NULL,'James oversees clean water and church planting initiatives among pastoralist communities in the Rift Valley, running a mobile clinic that reaches remote villages every month.','active','2015-06-15',NULL,NULL,100,NULL,NULL,1,2,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24',NULL),(3,'Chidinma Musa','chidinma-musa','MS-KH-0231',NULL,NULL,'Bible Translator',3,NULL,'Chidinma is leading a New Testament translation project for an unreached people group, partnering with local congregations on literacy and discipleship training.','active','2021-01-10',NULL,NULL,78,NULL,NULL,1,3,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24',NULL),(4,'Emeka Okafor','emeka-okafor','MS-UG-0088',NULL,NULL,'Medical Missionary',2,NULL,'Emeka coordinates mobile medical clinics reaching remote border villages, providing basic healthcare and health education alongside gospel ministry.','pending',NULL,NULL,NULL,35,NULL,NULL,1,4,NULL,NULL,'2026-08-08 14:50:24','2026-08-08 14:50:24',NULL); /*!40000 ALTER TABLE `missionaries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `modules` -- DROP TABLE IF EXISTS `modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(60) NOT NULL, `name` varchar(120) NOT NULL, `tier` enum('basic','professional','enterprise') NOT NULL DEFAULT 'basic', `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_modules_slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `modules` -- LOCK TABLES `modules` WRITE; /*!40000 ALTER TABLE `modules` DISABLE KEYS */; INSERT INTO `modules` VALUES (1,'cms','Content Management System','basic',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(2,'donations_basic','Online Donations','basic',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(3,'missionaries','Missionary Management','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(4,'mission_fields','Mission Field Management','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(5,'projects','Outreach & Project Management','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(6,'publications','Publications','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(7,'sermons','Sermons & Media Centre','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(8,'volunteers','Volunteer Management','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(9,'newsletter','Newsletter','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(10,'event_registration','Event Registration & QR Check-in','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(11,'reports','Reports & Analytics','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(12,'file_manager','File Manager','professional',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(13,'multi_branch','Multi-Branch / Multi-Country Operations','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(14,'rest_api','REST API','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(15,'white_label','White Label Deployment','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(16,'multi_language','Multi-Language Support','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(17,'live_streaming','Live Streaming','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(18,'advanced_analytics','Advanced Analytics','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(19,'crm_integration','CRM Integration','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(20,'whatsapp_integration','WhatsApp Integration','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(21,'sms_integration','SMS Integration','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(22,'ai_content_assistant','AI Content Assistant','enterprise',1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(23,'prayer','Prayer Centre','professional',1,'2026-08-08 15:44:47','2026-08-08 15:44:47'),(24,'communication','Communication Centre','professional',1,'2026-08-08 16:23:03','2026-08-08 16:23:03'); /*!40000 ALTER TABLE `modules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `newsletter_subscribers` -- DROP TABLE IF EXISTS `newsletter_subscribers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `newsletter_subscribers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(150) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `subscribed_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_newsletter_subscribers_email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `newsletter_subscribers` -- LOCK TABLES `newsletter_subscribers` WRITE; /*!40000 ALTER TABLE `newsletter_subscribers` DISABLE KEYS */; /*!40000 ALTER TABLE `newsletter_subscribers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `title` varchar(150) NOT NULL, `message` varchar(500) DEFAULT NULL, `type` varchar(30) NOT NULL DEFAULT 'info', `link` varchar(255) DEFAULT NULL, `is_read` tinyint(1) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_notifications_user` (`user_id`,`is_read`), CONSTRAINT `fk_notifications_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `page_views` -- DROP TABLE IF EXISTS `page_views`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `page_views` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) NOT NULL, `referrer_host` varchar(150) DEFAULT NULL, `session_id` varchar(64) NOT NULL, `viewed_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_page_views_path` (`path`), KEY `idx_page_views_session_date` (`session_id`,`viewed_at`), KEY `idx_page_views_date` (`viewed_at`) ) ENGINE=InnoDB AUTO_INCREMENT=486 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `page_views` -- LOCK TABLES `page_views` WRITE; /*!40000 ALTER TABLE `page_views` DISABLE KEYS */; INSERT INTO `page_views` VALUES (1,'/volunteer','google.com','seed-5-70','2026-03-10 17:50:00'),(2,'/projects',NULL,'seed-5-485','2026-03-02 07:32:00'),(3,'/prayer',NULL,'seed-5-205','2026-03-23 09:30:00'),(4,'/mission-fields',NULL,'seed-5-153','2026-03-24 11:54:00'),(5,'/publications','instagram.com','seed-5-138','2026-03-31 12:39:00'),(6,'/projects',NULL,'seed-5-42','2026-03-18 11:17:00'),(7,'/sermons','google.com','seed-5-168','2026-03-20 16:06:00'),(8,'/projects',NULL,'seed-5-314','2026-03-18 22:09:00'),(9,'/missionaries','bing.com','seed-5-478','2026-03-11 17:49:00'),(10,'/','google.com','seed-5-429','2026-03-22 07:39:00'),(11,'/sermons','facebook.com','seed-5-15','2026-03-18 17:03:00'),(12,'/events',NULL,'seed-5-243','2026-03-21 21:07:00'),(13,'/','instagram.com','seed-5-163','2026-03-25 15:26:00'),(14,'/',NULL,'seed-5-299','2026-03-23 07:52:00'),(15,'/mission-fields',NULL,'seed-5-197','2026-03-11 07:25:00'),(16,'/',NULL,'seed-5-297','2026-03-03 10:41:00'),(17,'/mission-fields','google.com','seed-5-458','2026-03-18 08:21:00'),(18,'/mission-fields','bing.com','seed-5-280','2026-03-14 07:18:00'),(19,'/sermons','bing.com','seed-5-138','2026-03-06 19:46:00'),(20,'/mission-fields',NULL,'seed-5-474','2026-03-27 11:45:00'),(21,'/publications','google.com','seed-5-338','2026-03-12 16:00:00'),(22,'/prayer',NULL,'seed-5-282','2026-03-28 12:56:00'),(23,'/donate',NULL,'seed-5-170','2026-03-07 18:32:00'),(24,'/volunteer','bing.com','seed-5-185','2026-03-31 11:54:00'),(25,'/','google.com','seed-5-452','2026-03-24 09:48:00'),(26,'/',NULL,'seed-5-375','2026-03-20 07:50:00'),(27,'/','othersite.com','seed-5-141','2026-03-06 14:25:00'),(28,'/','google.com','seed-5-231','2026-03-27 09:17:00'),(29,'/publications','google.com','seed-5-123','2026-03-10 22:52:00'),(30,'/missionaries','google.com','seed-5-64','2026-03-15 07:06:00'),(31,'/projects','othersite.com','seed-5-93','2026-03-21 20:55:00'),(32,'/events','facebook.com','seed-5-130','2026-03-25 22:47:00'),(33,'/events',NULL,'seed-5-143','2026-03-02 17:57:00'),(34,'/projects',NULL,'seed-5-251','2026-03-30 08:31:00'),(35,'/projects',NULL,'seed-5-272','2026-03-08 19:11:00'),(36,'/prayer','othersite.com','seed-5-464','2026-03-12 09:30:00'),(37,'/volunteer',NULL,'seed-5-126','2026-03-26 12:39:00'),(38,'/sermons',NULL,'seed-5-235','2026-03-05 15:36:00'),(39,'/events',NULL,'seed-5-263','2026-03-02 12:26:00'),(40,'/publications',NULL,'seed-5-31','2026-03-26 11:58:00'),(41,'/events',NULL,'seed-4-85','2026-04-22 17:15:00'),(42,'/prayer',NULL,'seed-4-170','2026-04-09 21:18:00'),(43,'/events','bing.com','seed-4-152','2026-04-28 19:45:00'),(44,'/sermons','instagram.com','seed-4-340','2026-04-27 14:02:00'),(45,'/mission-fields',NULL,'seed-4-483','2026-04-21 08:21:00'),(46,'/projects','othersite.com','seed-4-67','2026-04-09 15:33:00'),(47,'/donate','instagram.com','seed-4-370','2026-04-24 12:49:00'),(48,'/volunteer','facebook.com','seed-4-371','2026-04-26 20:20:00'),(49,'/publications','instagram.com','seed-4-53','2026-04-04 07:29:00'),(50,'/events','bing.com','seed-4-278','2026-04-17 16:06:00'),(51,'/missionaries',NULL,'seed-4-244','2026-04-03 07:06:00'),(52,'/donate',NULL,'seed-4-477','2026-04-22 09:18:00'),(53,'/events','instagram.com','seed-4-44','2026-04-25 13:27:00'),(54,'/projects',NULL,'seed-4-88','2026-04-03 07:13:00'),(55,'/publications','google.com','seed-4-474','2026-04-04 07:32:00'),(56,'/donate',NULL,'seed-4-157','2026-04-15 08:03:00'),(57,'/events','facebook.com','seed-4-330','2026-04-17 19:56:00'),(58,'/projects','bing.com','seed-4-354','2026-04-01 19:39:00'),(59,'/volunteer',NULL,'seed-4-226','2026-04-29 07:55:00'),(60,'/volunteer','instagram.com','seed-4-205','2026-04-22 11:07:00'),(61,'/',NULL,'seed-4-73','2026-04-10 21:43:00'),(62,'/projects','google.com','seed-4-265','2026-04-07 18:28:00'),(63,'/missionaries','facebook.com','seed-4-391','2026-04-18 14:56:00'),(64,'/volunteer',NULL,'seed-4-272','2026-04-22 22:01:00'),(65,'/missionaries','othersite.com','seed-4-64','2026-04-21 10:37:00'),(66,'/prayer',NULL,'seed-4-157','2026-04-29 08:50:00'),(67,'/donate','google.com','seed-4-90','2026-04-23 19:03:00'),(68,'/mission-fields',NULL,'seed-4-31','2026-04-18 22:17:00'),(69,'/publications',NULL,'seed-4-377','2026-04-04 11:00:00'),(70,'/volunteer','bing.com','seed-4-224','2026-04-12 07:06:00'),(71,'/mission-fields',NULL,'seed-4-163','2026-04-19 10:45:00'),(72,'/projects','instagram.com','seed-4-296','2026-04-05 13:55:00'),(73,'/publications','instagram.com','seed-4-364','2026-04-04 20:47:00'),(74,'/sermons',NULL,'seed-4-269','2026-04-15 08:41:00'),(75,'/volunteer','instagram.com','seed-4-335','2026-04-11 20:52:00'),(76,'/volunteer','othersite.com','seed-4-105','2026-04-07 11:03:00'),(77,'/',NULL,'seed-4-281','2026-04-28 19:00:00'),(78,'/volunteer',NULL,'seed-4-360','2026-04-15 21:06:00'),(79,'/projects',NULL,'seed-4-414','2026-04-27 15:45:00'),(80,'/events','bing.com','seed-4-310','2026-04-22 19:51:00'),(81,'/prayer','instagram.com','seed-4-291','2026-04-16 20:08:00'),(82,'/mission-fields',NULL,'seed-4-80','2026-04-10 22:59:00'),(83,'/sermons',NULL,'seed-4-454','2026-04-14 13:23:00'),(84,'/sermons',NULL,'seed-4-109','2026-04-14 13:09:00'),(85,'/',NULL,'seed-4-52','2026-04-21 20:10:00'),(86,'/publications','facebook.com','seed-4-345','2026-04-13 08:43:00'),(87,'/missionaries',NULL,'seed-4-423','2026-04-16 18:27:00'),(88,'/volunteer',NULL,'seed-4-236','2026-04-10 20:16:00'),(89,'/projects','bing.com','seed-4-444','2026-04-10 11:28:00'),(90,'/projects',NULL,'seed-4-325','2026-04-07 16:18:00'),(91,'/projects','facebook.com','seed-4-328','2026-04-06 12:25:00'),(92,'/events','google.com','seed-4-318','2026-04-03 11:09:00'),(93,'/donate','othersite.com','seed-4-490','2026-04-20 18:24:00'),(94,'/events','google.com','seed-4-304','2026-04-07 07:01:00'),(95,'/missionaries','othersite.com','seed-4-145','2026-04-13 20:57:00'),(96,'/donate','facebook.com','seed-3-61','2026-05-17 12:15:00'),(97,'/donate',NULL,'seed-3-342','2026-05-19 08:29:00'),(98,'/','othersite.com','seed-3-452','2026-05-03 20:20:00'),(99,'/missionaries',NULL,'seed-3-105','2026-05-10 21:44:00'),(100,'/sermons','facebook.com','seed-3-5','2026-05-09 21:47:00'),(101,'/donate','othersite.com','seed-3-315','2026-05-11 13:56:00'),(102,'/publications',NULL,'seed-3-377','2026-05-24 10:41:00'),(103,'/publications','bing.com','seed-3-407','2026-05-22 20:01:00'),(104,'/mission-fields','othersite.com','seed-3-477','2026-05-26 20:07:00'),(105,'/','google.com','seed-3-101','2026-05-09 20:09:00'),(106,'/sermons','instagram.com','seed-3-125','2026-05-22 16:40:00'),(107,'/','google.com','seed-3-222','2026-05-20 20:46:00'),(108,'/sermons','instagram.com','seed-3-459','2026-05-08 13:00:00'),(109,'/publications','othersite.com','seed-3-405','2026-05-25 19:05:00'),(110,'/sermons',NULL,'seed-3-181','2026-05-29 07:49:00'),(111,'/mission-fields',NULL,'seed-3-360','2026-05-22 16:26:00'),(112,'/events','google.com','seed-3-296','2026-05-18 08:10:00'),(113,'/projects','bing.com','seed-3-119','2026-05-20 22:38:00'),(114,'/volunteer','bing.com','seed-3-73','2026-05-11 13:53:00'),(115,'/mission-fields',NULL,'seed-3-121','2026-05-20 10:56:00'),(116,'/events',NULL,'seed-3-364','2026-05-25 17:10:00'),(117,'/prayer','instagram.com','seed-3-402','2026-05-01 13:27:00'),(118,'/events','facebook.com','seed-3-221','2026-05-22 14:45:00'),(119,'/projects','google.com','seed-3-484','2026-05-04 10:14:00'),(120,'/events',NULL,'seed-3-411','2026-05-10 12:08:00'),(121,'/projects','google.com','seed-3-488','2026-05-24 16:54:00'),(122,'/mission-fields','bing.com','seed-3-145','2026-05-11 14:13:00'),(123,'/events','google.com','seed-3-387','2026-05-27 12:21:00'),(124,'/events','google.com','seed-3-85','2026-05-10 20:53:00'),(125,'/volunteer','bing.com','seed-3-73','2026-05-08 13:21:00'),(126,'/sermons','google.com','seed-3-288','2026-05-26 10:39:00'),(127,'/prayer','facebook.com','seed-3-242','2026-05-19 15:09:00'),(128,'/',NULL,'seed-3-393','2026-05-16 13:36:00'),(129,'/mission-fields',NULL,'seed-3-96','2026-05-28 10:07:00'),(130,'/volunteer',NULL,'seed-3-263','2026-05-25 17:44:00'),(131,'/projects',NULL,'seed-3-405','2026-05-22 13:05:00'),(132,'/missionaries',NULL,'seed-3-90','2026-05-21 15:47:00'),(133,'/donate','google.com','seed-3-210','2026-05-08 14:51:00'),(134,'/publications','instagram.com','seed-3-341','2026-05-01 12:50:00'),(135,'/projects','instagram.com','seed-3-364','2026-05-27 17:30:00'),(136,'/volunteer','instagram.com','seed-3-71','2026-05-29 19:57:00'),(137,'/volunteer','google.com','seed-3-299','2026-05-30 07:20:00'),(138,'/prayer',NULL,'seed-3-61','2026-05-25 07:48:00'),(139,'/projects',NULL,'seed-3-328','2026-05-10 11:15:00'),(140,'/mission-fields',NULL,'seed-3-48','2026-05-22 10:37:00'),(141,'/projects','bing.com','seed-3-267','2026-05-21 17:36:00'),(142,'/sermons','google.com','seed-3-404','2026-05-26 11:50:00'),(143,'/sermons',NULL,'seed-3-55','2026-05-12 12:54:00'),(144,'/missionaries','bing.com','seed-3-59','2026-05-08 15:53:00'),(145,'/volunteer',NULL,'seed-3-368','2026-05-29 16:34:00'),(146,'/prayer','facebook.com','seed-3-417','2026-05-07 09:47:00'),(147,'/',NULL,'seed-3-239','2026-05-28 18:26:00'),(148,'/sermons',NULL,'seed-3-104','2026-05-13 07:51:00'),(149,'/prayer','facebook.com','seed-3-256','2026-05-02 10:29:00'),(150,'/projects',NULL,'seed-3-452','2026-05-27 07:36:00'),(151,'/publications','facebook.com','seed-3-274','2026-05-23 20:24:00'),(152,'/prayer',NULL,'seed-3-185','2026-05-01 16:35:00'),(153,'/mission-fields','bing.com','seed-3-214','2026-05-28 18:23:00'),(154,'/mission-fields','bing.com','seed-3-293','2026-05-04 11:38:00'),(155,'/volunteer','instagram.com','seed-3-58','2026-05-25 17:14:00'),(156,'/sermons',NULL,'seed-3-383','2026-05-08 13:03:00'),(157,'/sermons',NULL,'seed-3-233','2026-05-25 12:01:00'),(158,'/publications','bing.com','seed-3-451','2026-05-15 19:09:00'),(159,'/projects','google.com','seed-3-49','2026-05-31 18:58:00'),(160,'/mission-fields',NULL,'seed-3-98','2026-05-30 12:00:00'),(161,'/mission-fields','facebook.com','seed-3-239','2026-05-14 22:18:00'),(162,'/volunteer','othersite.com','seed-3-363','2026-05-19 19:31:00'),(163,'/publications',NULL,'seed-3-151','2026-05-29 21:44:00'),(164,'/projects',NULL,'seed-3-120','2026-05-06 10:04:00'),(165,'/mission-fields',NULL,'seed-3-493','2026-05-22 22:40:00'),(166,'/publications',NULL,'seed-2-195','2026-06-16 12:53:00'),(167,'/publications','othersite.com','seed-2-377','2026-06-21 17:19:00'),(168,'/prayer','othersite.com','seed-2-285','2026-06-15 18:42:00'),(169,'/projects',NULL,'seed-2-490','2026-06-20 21:16:00'),(170,'/mission-fields','instagram.com','seed-2-187','2026-06-06 18:30:00'),(171,'/publications','bing.com','seed-2-147','2026-06-05 11:06:00'),(172,'/projects','google.com','seed-2-303','2026-06-25 21:12:00'),(173,'/missionaries','othersite.com','seed-2-345','2026-06-26 11:20:00'),(174,'/donate','facebook.com','seed-2-18','2026-06-07 12:21:00'),(175,'/publications','instagram.com','seed-2-448','2026-06-14 11:13:00'),(176,'/mission-fields','othersite.com','seed-2-136','2026-06-22 19:41:00'),(177,'/prayer',NULL,'seed-2-472','2026-06-06 18:57:00'),(178,'/projects',NULL,'seed-2-131','2026-06-30 14:39:00'),(179,'/volunteer','google.com','seed-2-33','2026-06-15 20:53:00'),(180,'/prayer',NULL,'seed-2-168','2026-06-01 18:00:00'),(181,'/projects','othersite.com','seed-2-164','2026-06-25 17:01:00'),(182,'/prayer','google.com','seed-2-387','2026-06-05 11:36:00'),(183,'/projects','bing.com','seed-2-51','2026-06-25 17:10:00'),(184,'/sermons',NULL,'seed-2-331','2026-06-04 21:57:00'),(185,'/publications','facebook.com','seed-2-274','2026-06-14 19:48:00'),(186,'/volunteer',NULL,'seed-2-114','2026-06-10 11:16:00'),(187,'/sermons',NULL,'seed-2-249','2026-06-30 19:28:00'),(188,'/','instagram.com','seed-2-389','2026-06-27 15:20:00'),(189,'/volunteer','facebook.com','seed-2-8','2026-06-28 18:59:00'),(190,'/mission-fields',NULL,'seed-2-479','2026-06-18 19:20:00'),(191,'/sermons','bing.com','seed-2-377','2026-06-16 07:01:00'),(192,'/projects','google.com','seed-2-50','2026-06-10 14:50:00'),(193,'/events',NULL,'seed-2-265','2026-06-17 15:33:00'),(194,'/volunteer','facebook.com','seed-2-474','2026-06-10 11:14:00'),(195,'/projects',NULL,'seed-2-87','2026-06-09 15:01:00'),(196,'/missionaries','instagram.com','seed-2-207','2026-06-17 16:07:00'),(197,'/donate',NULL,'seed-2-122','2026-06-27 15:11:00'),(198,'/publications','google.com','seed-2-216','2026-06-06 16:31:00'),(199,'/prayer',NULL,'seed-2-490','2026-06-02 08:54:00'),(200,'/prayer',NULL,'seed-2-19','2026-06-30 16:24:00'),(201,'/sermons','instagram.com','seed-2-183','2026-06-02 11:41:00'),(202,'/volunteer','bing.com','seed-2-211','2026-06-16 11:39:00'),(203,'/','bing.com','seed-2-118','2026-06-18 08:26:00'),(204,'/donate','bing.com','seed-2-149','2026-06-01 14:09:00'),(205,'/prayer','othersite.com','seed-2-162','2026-06-26 07:45:00'),(206,'/sermons','google.com','seed-2-262','2026-06-18 19:30:00'),(207,'/mission-fields',NULL,'seed-2-220','2026-06-26 15:44:00'),(208,'/donate',NULL,'seed-2-348','2026-06-14 07:58:00'),(209,'/publications','facebook.com','seed-2-162','2026-06-23 14:09:00'),(210,'/publications','google.com','seed-2-24','2026-06-01 15:19:00'),(211,'/prayer','bing.com','seed-2-7','2026-06-20 14:16:00'),(212,'/projects',NULL,'seed-2-74','2026-06-05 09:28:00'),(213,'/mission-fields',NULL,'seed-2-15','2026-06-28 22:10:00'),(214,'/volunteer',NULL,'seed-2-479','2026-06-26 17:18:00'),(215,'/missionaries',NULL,'seed-2-78','2026-06-22 11:12:00'),(216,'/prayer','facebook.com','seed-2-417','2026-06-26 20:40:00'),(217,'/projects','othersite.com','seed-2-290','2026-06-02 12:57:00'),(218,'/volunteer','google.com','seed-2-132','2026-06-10 09:13:00'),(219,'/sermons',NULL,'seed-2-341','2026-06-19 12:01:00'),(220,'/projects','facebook.com','seed-2-317','2026-06-28 12:24:00'),(221,'/prayer','google.com','seed-2-270','2026-06-02 14:43:00'),(222,'/donate','instagram.com','seed-2-304','2026-06-13 15:00:00'),(223,'/sermons','instagram.com','seed-2-79','2026-06-14 18:03:00'),(224,'/donate',NULL,'seed-2-43','2026-06-28 21:13:00'),(225,'/donate',NULL,'seed-2-392','2026-06-16 09:49:00'),(226,'/publications','facebook.com','seed-2-496','2026-06-04 13:32:00'),(227,'/prayer',NULL,'seed-2-403','2026-06-13 22:02:00'),(228,'/volunteer','instagram.com','seed-2-432','2026-06-17 08:37:00'),(229,'/prayer','instagram.com','seed-2-474','2026-06-11 13:11:00'),(230,'/publications',NULL,'seed-2-251','2026-06-16 22:16:00'),(231,'/missionaries','google.com','seed-2-435','2026-06-11 11:38:00'),(232,'/','bing.com','seed-2-325','2026-06-08 07:42:00'),(233,'/','google.com','seed-2-323','2026-06-02 07:29:00'),(234,'/publications','bing.com','seed-2-145','2026-06-12 19:13:00'),(235,'/volunteer','google.com','seed-2-413','2026-06-24 17:06:00'),(236,'/publications',NULL,'seed-2-205','2026-06-04 15:06:00'),(237,'/volunteer',NULL,'seed-2-493','2026-06-01 13:10:00'),(238,'/donate','bing.com','seed-2-16','2026-06-10 09:56:00'),(239,'/prayer',NULL,'seed-2-21','2026-06-24 13:19:00'),(240,'/events','instagram.com','seed-2-479','2026-06-23 15:14:00'),(241,'/publications',NULL,'seed-2-341','2026-06-17 18:08:00'),(242,'/mission-fields',NULL,'seed-2-467','2026-06-15 17:27:00'),(243,'/volunteer',NULL,'seed-2-284','2026-06-09 13:28:00'),(244,'/',NULL,'seed-2-277','2026-06-16 08:05:00'),(245,'/prayer',NULL,'seed-2-382','2026-06-05 14:34:00'),(246,'/sermons',NULL,'seed-2-14','2026-06-11 22:03:00'),(247,'/projects',NULL,'seed-2-252','2026-06-09 09:30:00'),(248,'/events','google.com','seed-2-259','2026-06-20 22:12:00'),(249,'/','othersite.com','seed-2-408','2026-06-17 18:49:00'),(250,'/volunteer','bing.com','seed-2-372','2026-06-14 08:19:00'),(251,'/events','facebook.com','seed-1-66','2026-07-27 07:44:00'),(252,'/projects','othersite.com','seed-1-225','2026-07-14 16:36:00'),(253,'/projects','othersite.com','seed-1-491','2026-07-24 22:03:00'),(254,'/publications','facebook.com','seed-1-179','2026-07-05 08:25:00'),(255,'/missionaries','bing.com','seed-1-473','2026-07-26 07:41:00'),(256,'/events','facebook.com','seed-1-189','2026-07-02 18:57:00'),(257,'/projects',NULL,'seed-1-191','2026-07-06 07:38:00'),(258,'/volunteer',NULL,'seed-1-384','2026-07-01 12:59:00'),(259,'/',NULL,'seed-1-98','2026-07-16 08:07:00'),(260,'/',NULL,'seed-1-92','2026-07-27 13:14:00'),(261,'/events',NULL,'seed-1-463','2026-07-26 21:36:00'),(262,'/volunteer','facebook.com','seed-1-435','2026-07-01 21:19:00'),(263,'/',NULL,'seed-1-229','2026-07-24 22:53:00'),(264,'/','google.com','seed-1-45','2026-07-14 17:49:00'),(265,'/projects',NULL,'seed-1-3','2026-07-21 12:54:00'),(266,'/donate','bing.com','seed-1-470','2026-07-15 17:47:00'),(267,'/volunteer','google.com','seed-1-290','2026-07-17 07:42:00'),(268,'/mission-fields','othersite.com','seed-1-499','2026-07-21 20:34:00'),(269,'/mission-fields','google.com','seed-1-342','2026-07-19 20:53:00'),(270,'/events','google.com','seed-1-159','2026-07-27 19:07:00'),(271,'/prayer','othersite.com','seed-1-358','2026-07-25 13:34:00'),(272,'/volunteer','google.com','seed-1-443','2026-07-28 22:25:00'),(273,'/donate','instagram.com','seed-1-422','2026-07-08 18:57:00'),(274,'/mission-fields',NULL,'seed-1-257','2026-07-21 15:42:00'),(275,'/events','othersite.com','seed-1-201','2026-07-15 20:28:00'),(276,'/volunteer','bing.com','seed-1-254','2026-07-17 11:53:00'),(277,'/donate','bing.com','seed-1-280','2026-07-23 11:20:00'),(278,'/missionaries','google.com','seed-1-417','2026-07-08 07:10:00'),(279,'/events','google.com','seed-1-47','2026-07-09 10:47:00'),(280,'/','bing.com','seed-1-120','2026-07-19 21:59:00'),(281,'/publications','google.com','seed-1-260','2026-07-11 09:45:00'),(282,'/volunteer','bing.com','seed-1-83','2026-07-05 10:12:00'),(283,'/sermons','instagram.com','seed-1-326','2026-07-04 21:04:00'),(284,'/projects',NULL,'seed-1-333','2026-07-03 08:16:00'),(285,'/sermons','google.com','seed-1-194','2026-07-28 20:15:00'),(286,'/projects','google.com','seed-1-359','2026-07-01 20:24:00'),(287,'/mission-fields','google.com','seed-1-189','2026-07-05 20:48:00'),(288,'/publications','google.com','seed-1-94','2026-07-22 12:17:00'),(289,'/events','bing.com','seed-1-473','2026-07-17 14:10:00'),(290,'/donate','google.com','seed-1-494','2026-07-29 15:01:00'),(291,'/projects',NULL,'seed-1-395','2026-07-05 13:26:00'),(292,'/volunteer',NULL,'seed-1-188','2026-07-30 12:26:00'),(293,'/sermons',NULL,'seed-1-359','2026-07-29 11:00:00'),(294,'/mission-fields',NULL,'seed-1-265','2026-07-30 19:12:00'),(295,'/prayer',NULL,'seed-1-194','2026-07-07 08:45:00'),(296,'/mission-fields',NULL,'seed-1-436','2026-07-22 21:51:00'),(297,'/missionaries','instagram.com','seed-1-251','2026-07-02 14:22:00'),(298,'/events',NULL,'seed-1-485','2026-07-22 13:47:00'),(299,'/volunteer','bing.com','seed-1-412','2026-07-14 14:40:00'),(300,'/mission-fields',NULL,'seed-1-8','2026-07-09 22:41:00'),(301,'/events','othersite.com','seed-1-7','2026-07-02 12:46:00'),(302,'/events','bing.com','seed-1-425','2026-07-14 22:15:00'),(303,'/sermons','othersite.com','seed-1-61','2026-07-31 11:44:00'),(304,'/missionaries',NULL,'seed-1-311','2026-07-24 10:13:00'),(305,'/volunteer','bing.com','seed-1-191','2026-07-30 15:52:00'),(306,'/projects',NULL,'seed-1-481','2026-07-08 13:58:00'),(307,'/sermons','google.com','seed-1-396','2026-07-23 12:34:00'),(308,'/projects',NULL,'seed-1-265','2026-07-18 08:33:00'),(309,'/sermons',NULL,'seed-1-251','2026-07-03 20:20:00'),(310,'/mission-fields',NULL,'seed-1-251','2026-07-19 21:31:00'),(311,'/sermons','othersite.com','seed-1-454','2026-07-31 10:26:00'),(312,'/events','bing.com','seed-1-286','2026-07-21 15:07:00'),(313,'/mission-fields','google.com','seed-1-435','2026-07-07 15:48:00'),(314,'/','google.com','seed-1-76','2026-07-31 18:56:00'),(315,'/',NULL,'seed-1-79','2026-07-16 17:45:00'),(316,'/','bing.com','seed-1-71','2026-07-15 16:31:00'),(317,'/volunteer',NULL,'seed-1-330','2026-07-26 07:42:00'),(318,'/',NULL,'seed-1-193','2026-07-02 21:40:00'),(319,'/volunteer','google.com','seed-1-230','2026-07-16 15:52:00'),(320,'/projects','bing.com','seed-1-146','2026-07-31 16:50:00'),(321,'/donate','google.com','seed-1-355','2026-07-05 19:00:00'),(322,'/volunteer','google.com','seed-1-362','2026-07-30 10:22:00'),(323,'/donate','facebook.com','seed-1-212','2026-07-11 17:52:00'),(324,'/mission-fields',NULL,'seed-1-225','2026-07-13 12:43:00'),(325,'/',NULL,'seed-1-78','2026-07-07 22:57:00'),(326,'/projects',NULL,'seed-1-403','2026-07-31 14:35:00'),(327,'/volunteer',NULL,'seed-1-58','2026-07-16 17:42:00'),(328,'/sermons','othersite.com','seed-1-294','2026-07-29 13:18:00'),(329,'/publications','othersite.com','seed-1-429','2026-07-31 20:15:00'),(330,'/',NULL,'seed-1-485','2026-07-02 15:45:00'),(331,'/donate',NULL,'seed-1-266','2026-07-26 21:06:00'),(332,'/sermons','instagram.com','seed-1-23','2026-07-28 17:52:00'),(333,'/donate','facebook.com','seed-1-207','2026-07-08 17:00:00'),(334,'/mission-fields','othersite.com','seed-1-72','2026-07-08 12:34:00'),(335,'/publications','othersite.com','seed-1-215','2026-07-05 10:09:00'),(336,'/projects','google.com','seed-1-281','2026-07-20 22:54:00'),(337,'/sermons','othersite.com','seed-1-362','2026-07-07 08:40:00'),(338,'/missionaries',NULL,'seed-1-233','2026-07-25 08:40:00'),(339,'/events','othersite.com','seed-1-148','2026-07-12 18:30:00'),(340,'/sermons',NULL,'seed-1-229','2026-07-13 12:03:00'),(341,'/sermons','othersite.com','seed-1-26','2026-07-10 09:39:00'),(342,'/missionaries','instagram.com','seed-1-467','2026-07-15 18:55:00'),(343,'/prayer','facebook.com','seed-1-361','2026-07-16 15:50:00'),(344,'/missionaries','instagram.com','seed-1-284','2026-07-02 13:25:00'),(345,'/missionaries','facebook.com','seed-1-93','2026-07-27 22:05:00'),(346,'/volunteer',NULL,'seed-1-344','2026-07-24 07:31:00'),(347,'/publications','facebook.com','seed-1-329','2026-07-03 11:32:00'),(348,'/sermons','bing.com','seed-1-232','2026-07-17 09:47:00'),(349,'/sermons','instagram.com','seed-1-65','2026-07-17 22:33:00'),(350,'/prayer','instagram.com','seed-1-448','2026-07-08 10:48:00'),(351,'/',NULL,'seed-0-376','2026-08-08 17:22:00'),(352,'/sermons','google.com','seed-0-245','2026-08-08 11:34:00'),(353,'/projects','bing.com','seed-0-82','2026-08-08 11:34:00'),(354,'/','google.com','seed-0-475','2026-08-03 16:50:00'),(355,'/events','instagram.com','seed-0-362','2026-08-06 10:37:00'),(356,'/projects',NULL,'seed-0-462','2026-08-08 09:07:00'),(357,'/',NULL,'seed-0-498','2026-08-08 12:54:00'),(358,'/events',NULL,'seed-0-431','2026-08-02 17:31:00'),(359,'/events','othersite.com','seed-0-263','2026-08-07 21:05:00'),(360,'/events','google.com','seed-0-256','2026-08-04 15:21:00'),(361,'/mission-fields','google.com','seed-0-500','2026-08-06 14:33:00'),(362,'/missionaries','google.com','seed-0-249','2026-08-01 21:01:00'),(363,'/publications','instagram.com','seed-0-436','2026-08-03 12:21:00'),(364,'/donate','google.com','seed-0-169','2026-08-03 20:07:00'),(365,'/prayer',NULL,'seed-0-406','2026-08-06 08:49:00'),(366,'/events','instagram.com','seed-0-433','2026-08-05 14:01:00'),(367,'/publications',NULL,'seed-0-321','2026-08-01 08:01:00'),(368,'/','google.com','seed-0-398','2026-08-07 22:14:00'),(369,'/projects',NULL,'seed-0-11','2026-08-04 10:17:00'),(370,'/volunteer','bing.com','seed-0-196','2026-08-07 13:15:00'),(371,'/','instagram.com','seed-0-5','2026-08-07 07:11:00'),(372,'/prayer',NULL,'seed-0-437','2026-08-07 11:29:00'),(373,'/sermons',NULL,'seed-0-482','2026-08-04 08:59:00'),(374,'/mission-fields',NULL,'seed-0-469','2026-08-08 14:05:00'),(375,'/sermons','bing.com','seed-0-310','2026-08-07 18:38:00'),(376,'/donate','google.com','seed-0-335','2026-08-03 09:52:00'),(377,'/donate','google.com','seed-0-366','2026-08-08 09:27:00'),(378,'/donate','instagram.com','seed-0-79','2026-08-05 12:32:00'),(379,'/donate',NULL,'seed-0-122','2026-08-07 10:24:00'),(380,'/donate','instagram.com','seed-0-391','2026-08-02 21:09:00'),(381,'/publications',NULL,'seed-0-355','2026-08-05 11:38:00'),(382,'/missionaries','bing.com','seed-0-39','2026-08-01 15:16:00'),(383,'/mission-fields','bing.com','seed-0-485','2026-08-04 13:28:00'),(384,'/mission-fields',NULL,'seed-0-428','2026-08-06 18:03:00'),(385,'/prayer',NULL,'seed-0-84','2026-08-03 11:55:00'),(386,'/',NULL,'seed-0-12','2026-08-01 09:11:00'),(387,'/sermons','othersite.com','seed-0-262','2026-08-03 15:00:00'),(388,'/sermons',NULL,'seed-0-173','2026-08-01 22:15:00'),(389,'/projects','google.com','seed-0-350','2026-08-06 08:29:00'),(390,'/volunteer','othersite.com','seed-0-309','2026-08-03 15:41:00'),(391,'/donate',NULL,'seed-0-242','2026-08-01 13:43:00'),(392,'/sermons',NULL,'seed-0-12','2026-08-04 15:37:00'),(393,'/volunteer',NULL,'seed-0-344','2026-08-08 09:37:00'),(394,'/prayer',NULL,'seed-0-459','2026-08-01 10:56:00'),(395,'/prayer','othersite.com','seed-0-246','2026-08-04 08:37:00'),(396,'/volunteer','instagram.com','seed-0-5','2026-08-06 13:35:00'),(397,'/events','bing.com','seed-0-128','2026-08-08 14:41:00'),(398,'/events','othersite.com','seed-0-421','2026-08-08 22:36:00'),(399,'/publications',NULL,'seed-0-463','2026-08-02 12:11:00'),(400,'/missionaries',NULL,'seed-0-115','2026-08-03 17:08:00'),(401,'/projects','google.com','seed-0-491','2026-08-05 08:15:00'),(402,'/donate',NULL,'seed-0-485','2026-08-08 18:29:00'),(403,'/donate',NULL,'seed-0-51','2026-08-03 15:37:00'),(404,'/events','google.com','seed-0-339','2026-08-03 15:15:00'),(405,'/donate',NULL,'seed-0-445','2026-08-07 17:01:00'),(406,'/','othersite.com','seed-0-47','2026-08-02 14:17:00'),(407,'/prayer','othersite.com','seed-0-129','2026-08-04 20:22:00'),(408,'/missionaries','google.com','seed-0-120','2026-08-01 09:43:00'),(409,'/mission-fields','othersite.com','seed-0-8','2026-08-02 13:35:00'),(410,'/projects',NULL,'seed-0-208','2026-08-01 13:01:00'),(411,'/projects',NULL,'seed-0-82','2026-08-04 11:44:00'),(412,'/volunteer',NULL,'seed-0-41','2026-08-07 12:50:00'),(413,'/events','othersite.com','seed-0-188','2026-08-06 13:29:00'),(414,'/sermons','othersite.com','seed-0-382','2026-08-03 18:05:00'),(415,'/donate',NULL,'seed-0-306','2026-08-01 11:51:00'),(416,'/events',NULL,'seed-0-365','2026-08-05 10:28:00'),(417,'/volunteer','facebook.com','seed-0-109','2026-08-06 15:46:00'),(418,'/missionaries',NULL,'seed-0-371','2026-08-06 19:45:00'),(419,'/publications',NULL,'seed-0-256','2026-08-03 22:29:00'),(420,'/projects','google.com','seed-0-398','2026-08-06 22:13:00'),(421,'/publications','facebook.com','seed-0-286','2026-08-08 14:42:00'),(422,'/prayer','google.com','seed-0-394','2026-08-08 14:27:00'),(423,'/publications','bing.com','seed-0-356','2026-08-05 18:18:00'),(424,'/','instagram.com','seed-0-442','2026-08-06 14:28:00'),(425,'/publications',NULL,'seed-0-256','2026-08-01 07:16:00'),(426,'/donate','facebook.com','seed-0-412','2026-08-05 14:35:00'),(427,'/prayer','google.com','seed-0-313','2026-08-04 12:05:00'),(428,'/mission-fields','instagram.com','seed-0-14','2026-08-08 18:10:00'),(429,'/projects','facebook.com','seed-0-232','2026-08-02 12:13:00'),(430,'/mission-fields','google.com','seed-0-414','2026-08-03 21:06:00'),(431,'/','othersite.com','seed-0-49','2026-08-08 19:31:00'),(432,'/events','othersite.com','seed-0-396','2026-08-08 18:19:00'),(433,'/mission-fields',NULL,'seed-0-207','2026-08-03 09:18:00'),(434,'/donate','bing.com','seed-0-309','2026-08-02 20:22:00'),(435,'/sermons','instagram.com','seed-0-205','2026-08-07 09:08:00'),(436,'/events',NULL,'seed-0-361','2026-08-06 08:49:00'),(437,'/projects','instagram.com','seed-0-478','2026-08-01 09:14:00'),(438,'/projects',NULL,'seed-0-298','2026-08-02 19:16:00'),(439,'/missionaries',NULL,'seed-0-25','2026-08-07 07:25:00'),(440,'/prayer',NULL,'seed-0-332','2026-08-02 19:57:00'),(441,'/donate',NULL,'seed-0-181','2026-08-08 18:03:00'),(442,'/donate','othersite.com','seed-0-420','2026-08-02 20:09:00'),(443,'/','google.com','seed-0-189','2026-08-06 21:25:00'),(444,'/events','instagram.com','seed-0-43','2026-08-01 17:27:00'),(445,'/mission-fields','google.com','seed-0-154','2026-08-08 17:36:00'),(446,'/prayer','google.com','seed-0-370','2026-08-02 13:20:00'),(447,'/publications','google.com','seed-0-466','2026-08-03 10:54:00'),(448,'/projects','bing.com','seed-0-97','2026-08-01 09:34:00'),(449,'/','google.com','seed-0-359','2026-08-04 17:11:00'),(450,'/missionaries',NULL,'seed-0-260','2026-08-08 11:05:00'),(451,'/missionaries','bing.com','seed-0-468','2026-08-08 14:05:00'),(452,'/','google.com','seed-0-481','2026-08-06 21:56:00'),(453,'/volunteer','google.com','seed-0-79','2026-08-01 12:53:00'),(454,'/events','othersite.com','seed-0-236','2026-08-04 11:29:00'),(455,'/prayer','facebook.com','seed-0-295','2026-08-08 17:52:00'),(456,'/events','facebook.com','seed-0-190','2026-08-06 07:12:00'),(457,'/prayer','google.com','seed-0-291','2026-08-07 14:52:00'),(458,'/donate','google.com','seed-0-391','2026-08-02 16:41:00'),(459,'/projects',NULL,'seed-0-399','2026-08-04 15:51:00'),(460,'/mission-fields',NULL,'seed-0-397','2026-08-02 22:31:00'),(461,'/mission-fields',NULL,'seed-0-147','2026-08-06 16:05:00'),(462,'/','othersite.com','seed-0-443','2026-08-08 20:02:00'),(463,'/prayer','othersite.com','seed-0-252','2026-08-05 07:23:00'),(464,'/volunteer','instagram.com','seed-0-298','2026-08-03 13:16:00'),(465,'/mission-fields',NULL,'seed-0-183','2026-08-08 19:57:00'),(467,'/mission-fields',NULL,'858lft2nfog6q5hlg8b741cdto','2026-08-08 16:33:58'),(468,'/donate',NULL,'858lft2nfog6q5hlg8b741cdto','2026-08-08 16:33:59'),(469,'/',NULL,'ejov46d70o8q2uohlhm5b46ki9','2026-08-08 16:34:21'),(470,'/',NULL,'25m0e14bulk7vin0kt6ksdjgrj','2026-08-08 16:36:20'),(471,'/',NULL,'ua5ifobsgf58lqdif66rsqo494','2026-08-08 17:21:17'),(472,'/missionaries',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:30:53'),(473,'/about',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:31:01'),(474,'/contact',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:31:19'),(475,'/mission-fields',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:32:15'),(476,'/mission-fields/great-lakes-region',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:32:17'),(477,'/events',NULL,'o1kt5vp8c3vobv6t8hmkvu0re3','2026-08-08 17:32:31'),(478,'/',NULL,'ad6nsnpg99611t8ql64ecgpq1a','2026-08-08 17:32:54'),(479,'/events',NULL,'lipmi7gq66lcb40m057deg5o6a','2026-08-08 20:22:54'),(480,'/events/short-term-mission-trip',NULL,'lipmi7gq66lcb40m057deg5o6a','2026-08-08 20:22:57'),(481,'/about',NULL,'ogchooop2a50lobbkr59vo7dit','2026-08-08 20:25:12'),(482,'/events/short-term-mission-trip',NULL,'v3ft43g6848nirglj440unc2ni','2026-08-08 20:48:02'),(483,'/events/short-term-mission-trip/register',NULL,'pvdfibcrsv4espbn1ld7a06caa','2026-08-08 20:48:02'),(484,'/events/short-term-mission-trip',NULL,'st7t090lee9gushjtt1co873op','2026-08-08 20:48:21'),(485,'/events/short-term-mission-trip/register',NULL,'bdnvhqcn7v0493q6d0s4sl4rbm','2026-08-08 20:48:39'); /*!40000 ALTER TABLE `page_views` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages` -- DROP TABLE IF EXISTS `pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(120) NOT NULL, `title` varchar(200) NOT NULL, `content` longtext DEFAULT NULL, `meta_title` varchar(200) DEFAULT NULL, `meta_description` varchar(300) DEFAULT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 1, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_pages_slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pages` -- LOCK TABLES `pages` WRITE; /*!40000 ALTER TABLE `pages` DISABLE KEYS */; INSERT INTO `pages` VALUES (1,'about','About Us','
\n
\n
Our Mission
\n

Equip. Send. Serve alongside the local church.

\n

We exist to equip and send workers who make disciples among the unreached, and to serve the local church in every field we enter — from church planting and Bible translation to medical outreach and community development.

\n
\n
\n
Our Vision
\n

A gospel witness in every unreached community.

\n

We envision a day when no community is beyond the reach of the gospel — where local churches are planted, thriving, and reaching their own neighbors long after our missionaries have moved on.

\n
\n
\n
Our Journey
\n

Two Decades in the Field

\n
\n
2004
Founded

Began as a small church-planting effort with three missionary families.

\n
2011
First cross-border field opened

Expanded internationally, launching medical outreach programs.

\n
2017
Reached 10 mission fields

Grew to 10 active mission fields across three continents.

\n
2023
Digital giving platform launched

Introduced online donations and missionary sponsorship.

\n
2026
Growing every year

Today we coordinate every missionary, field and gift from MissionSuite.

\n
\n
What We Believe
\n

Statement of Faith

\n
\n
01
Scripture

We believe the Bible is the inspired, authoritative Word of God.

\n
02
The Gospel

Salvation is by grace through faith in Jesus Christ alone.

\n
03
The Church

We serve and strengthen the local church in every field we enter.

\n
04
The Great Commission

We are called to make disciples of all nations, starting with the unreached.

\n
','About Us',NULL,1,NULL,NULL,'2026-08-08 10:56:02','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(100) NOT NULL, `module` varchar(50) NOT NULL, `description` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_permissions_slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,'users.view','users','View users','2026-08-08 10:18:01'),(2,'users.create','users','Create users','2026-08-08 10:18:01'),(3,'users.edit','users','Edit users','2026-08-08 10:18:01'),(4,'users.delete','users','Delete users','2026-08-08 10:18:01'),(5,'roles.view','roles','View roles','2026-08-08 10:18:01'),(6,'roles.manage','roles','Create/edit/delete roles and assign permissions','2026-08-08 10:18:01'),(7,'settings.manage','settings','Manage ministry profile, branding, SMTP, gateways, modules','2026-08-08 10:18:01'),(8,'audit_logs.view','audit_logs','View activity and security logs','2026-08-08 10:18:01'),(9,'backup.manage','backup','Create, download, and restore database backups','2026-08-08 10:18:01'),(10,'reports.view','reports','View reports and analytics','2026-08-08 10:18:01'),(11,'missionaries.view','missionaries','View missionaries','2026-08-08 10:18:01'),(12,'missionaries.create','missionaries','Create missionaries','2026-08-08 10:18:01'),(13,'missionaries.edit','missionaries','Edit missionaries','2026-08-08 10:18:01'),(14,'missionaries.delete','missionaries','Delete missionaries','2026-08-08 10:18:01'),(15,'mission_fields.view','mission_fields','View mission fields','2026-08-08 10:18:01'),(16,'mission_fields.create','mission_fields','Create mission fields','2026-08-08 10:18:01'),(17,'mission_fields.edit','mission_fields','Edit mission fields','2026-08-08 10:18:01'),(18,'mission_fields.delete','mission_fields','Delete mission fields','2026-08-08 10:18:01'),(19,'projects.view','projects','View outreach projects','2026-08-08 10:18:01'),(20,'projects.create','projects','Create outreach projects','2026-08-08 10:18:01'),(21,'projects.edit','projects','Edit outreach projects','2026-08-08 10:18:01'),(22,'projects.delete','projects','Delete outreach projects','2026-08-08 10:18:01'),(23,'events.view','events','View events','2026-08-08 10:18:01'),(24,'events.create','events','Create events','2026-08-08 10:18:01'),(25,'events.edit','events','Edit events','2026-08-08 10:18:01'),(26,'events.delete','events','Delete events','2026-08-08 10:18:01'),(27,'prayer.view','prayer','View prayer requests','2026-08-08 10:18:01'),(28,'prayer.manage','prayer','Categorize, respond to, and archive prayer requests','2026-08-08 10:18:01'),(29,'sermons.view','sermons','View sermons/media','2026-08-08 10:18:01'),(30,'sermons.create','sermons','Upload sermons/media','2026-08-08 10:18:01'),(31,'sermons.edit','sermons','Edit sermons/media','2026-08-08 10:18:01'),(32,'sermons.delete','sermons','Delete sermons/media','2026-08-08 10:18:01'),(33,'publications.view','publications','View publications','2026-08-08 10:18:01'),(34,'publications.create','publications','Create publications','2026-08-08 10:18:01'),(35,'publications.edit','publications','Edit publications','2026-08-08 10:18:01'),(36,'publications.delete','publications','Delete publications','2026-08-08 10:18:01'),(37,'donations.view','donations','View donations','2026-08-08 10:18:01'),(38,'donations.manage','donations','Manage campaigns, sponsorships, and donation records','2026-08-08 10:18:01'),(39,'volunteers.view','volunteers','View volunteers','2026-08-08 10:18:01'),(40,'volunteers.manage','volunteers','Approve/assign volunteers','2026-08-08 10:18:01'),(41,'cms.view','cms','View CMS content (pages, sliders, testimonials, FAQs, contact messages)','2026-08-08 10:18:01'),(42,'cms.manage','cms','Create/edit/delete CMS content','2026-08-08 10:18:01'),(43,'communication.view','communication','View announcements and email campaigns','2026-08-08 16:23:03'),(44,'communication.manage','communication','Create/send announcements and email campaigns','2026-08-08 16:23:03'),(45,'audit_logs.manage','audit_logs','Delete activity log entries','2026-08-08 20:31:31'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prayer_requests` -- DROP TABLE IF EXISTS `prayer_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prayer_requests` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `email` varchar(150) DEFAULT NULL, `category` varchar(60) NOT NULL DEFAULT 'Family', `message` text NOT NULL, `status` enum('open','praying','answered','archived') NOT NULL DEFAULT 'open', `is_private` tinyint(1) NOT NULL DEFAULT 0, `is_urgent` tinyint(1) NOT NULL DEFAULT 0, `prayer_count` int(10) unsigned NOT NULL DEFAULT 0, `assigned_to` bigint(20) unsigned DEFAULT NULL, `response_note` text DEFAULT NULL, `answered_at` datetime DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_prayer_status` (`status`), KEY `idx_prayer_category` (`category`), KEY `fk_prayer_assigned_to` (`assigned_to`), CONSTRAINT `fk_prayer_assigned_to` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `prayer_requests` -- LOCK TABLES `prayer_requests` WRITE; /*!40000 ALTER TABLE `prayer_requests` DISABLE KEYS */; INSERT INTO `prayer_requests` VALUES (1,'Amaka Obi','amaka.obi@example.com','Field Safety','Please pray for missionary James Tanko\'s team travelling through a conflict-affected region this week.','open',0,1,35,NULL,NULL,NULL,'2026-08-07 15:47:14','2026-08-08 15:52:41'),(2,'Peter Kariuki','peter.kariuki@example.com','Health & Healing','Requesting prayer for my mother\'s upcoming surgery and full recovery.','praying',0,0,52,NULL,NULL,NULL,'2026-08-06 15:47:14','2026-08-08 15:52:41'),(3,'Anonymous','anonymous@example.com','Family','Private request regarding a family situation -- details withheld per submitter preference.','open',1,0,19,NULL,NULL,NULL,'2026-08-05 15:47:14','2026-08-08 15:47:14'),(4,'Ngozi Musa','ngozi.musa@example.com','Salvation','My neighbor has started attending Bible study -- pray for her heart to be open.','praying',0,0,41,NULL,NULL,NULL,'2026-08-03 15:47:14','2026-08-08 15:52:41'),(5,'Tolu Bakare','tolu.bakare@example.com','Finances','Praying for provision as our church plant works toward its building fund goal.','answered',0,0,63,NULL,'Building fund reached 100% -- praise God for His provision!','2026-08-04 15:47:14','2026-07-29 15:47:14','2026-08-08 15:47:14'),(6,'David Eze','david.eze@example.com','Health & Healing','Thank God -- my daughter\'s test results came back clear! Praise report attached.','answered',0,0,88,NULL,'Confirmed with submitter -- test results clear.','2026-07-30 15:47:14','2026-07-27 15:47:14','2026-08-08 15:47:14'),(7,'Faridah Suleiman','faridah.suleiman@example.com','Field Safety','Praying for safe travel for the medical outreach team heading to Rift Valley.','archived',0,0,47,NULL,'Team returned safely.',NULL,'2026-07-19 15:47:14','2026-08-08 15:47:14'); /*!40000 ALTER TABLE `prayer_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `project_milestones` -- DROP TABLE IF EXISTS `project_milestones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `project_milestones` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `project_id` bigint(20) unsigned NOT NULL, `title` varchar(255) NOT NULL, `is_complete` tinyint(1) NOT NULL DEFAULT 0, `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_project_milestones_project` (`project_id`), CONSTRAINT `fk_project_milestones_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `project_milestones` -- LOCK TABLES `project_milestones` WRITE; /*!40000 ALTER TABLE `project_milestones` DISABLE KEYS */; INSERT INTO `project_milestones` VALUES (1,1,'Site survey and community consultation',1,1,'2026-08-08 15:21:23'),(2,1,'Fundraising campaign launched',1,2,'2026-08-08 15:21:23'),(3,1,'Foundation and structure complete',0,3,'2026-08-08 15:21:23'),(4,1,'Dedication service',0,4,'2026-08-08 15:21:23'); /*!40000 ALTER TABLE `project_milestones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `projects` -- DROP TABLE IF EXISTS `projects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `projects` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `slug` varchar(210) NOT NULL, `category` varchar(100) NOT NULL DEFAULT 'Community Development', `mission_field_id` bigint(20) unsigned DEFAULT NULL, `project_lead` varchar(150) DEFAULT NULL, `description` text DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `budget_total` decimal(14,2) NOT NULL DEFAULT 0.00, `amount_raised` decimal(14,2) NOT NULL DEFAULT 0.00, `start_date` date DEFAULT NULL, `target_completion_date` date DEFAULT NULL, `status` enum('planning','active','completed') NOT NULL DEFAULT 'planning', `is_urgent` tinyint(1) NOT NULL DEFAULT 0, `is_published` tinyint(1) NOT NULL DEFAULT 1, `sort_order` int(11) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_projects_slug` (`slug`), KEY `idx_projects_field` (`mission_field_id`), CONSTRAINT `fk_projects_field` FOREIGN KEY (`mission_field_id`) REFERENCES `mission_fields` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `projects` -- LOCK TABLES `projects` WRITE; /*!40000 ALTER TABLE `projects` DISABLE KEYS */; INSERT INTO `projects` VALUES (1,'Riverside Fellowship Shelter','riverside-fellowship-shelter','Church Planting',1,'Ruth Adebayo','Building a permanent worship shelter for a growing congregation of over 140 believers who currently meet under a temporary canopy.',NULL,4000000.00,2720000.00,'2025-11-01',NULL,'active',0,1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'),(2,'Frontier Clinic Supplies','frontier-clinic-supplies','Medical Outreach',2,'Emeka Okafor','Quarterly medicine and equipment restock for the border clinic serving remote villages with little other access to healthcare.',NULL,2000000.00,820000.00,'2026-01-15',NULL,'active',1,1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'),(3,'Highlands Scripture Drive','highlands-scripture-drive','Bible Distribution',3,'Chidinma Musa','Printing and distributing Scripture in the local language to forty villages across the region.',NULL,1800000.00,1530000.00,'2025-08-01',NULL,'active',0,1,0,NULL,NULL,'2026-08-08 15:21:23','2026-08-08 15:21:23'); /*!40000 ALTER TABLE `projects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `publications` -- DROP TABLE IF EXISTS `publications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `publications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `slug` varchar(220) NOT NULL, `category` varchar(60) NOT NULL DEFAULT 'Newsletter', `author` varchar(150) DEFAULT NULL, `summary` text DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `cover_path` varchar(255) DEFAULT NULL, `publish_date` date DEFAULT NULL, `downloads_count` int(10) unsigned NOT NULL DEFAULT 0, `status` enum('draft','published','archived') NOT NULL DEFAULT 'draft', `notify_subscribers` tinyint(1) NOT NULL DEFAULT 0, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_publications_slug` (`slug`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `publications` -- LOCK TABLES `publications` WRITE; /*!40000 ALTER TABLE `publications` DISABLE KEYS */; INSERT INTO `publications` VALUES (1,'August Field Dispatch','august-field-dispatch','Newsletter','Executive Office','This month\'s dispatch: new missionary deployments, project milestones and upcoming events.',NULL,NULL,'2026-08-02',0,'published',0,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(2,'2025 Annual Impact Report','2025-annual-impact-report','Annual Report','Executive Office','A full accounting of missionaries supported, funds raised and communities reached in 2025.',NULL,NULL,'2026-06-24',0,'published',0,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(3,'Discipleship in Displacement','discipleship-in-displacement','Article','Ruth Adebayo','Reflections on making disciples among displaced communities in conflict-affected regions.',NULL,NULL,'2026-07-24',0,'published',0,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(4,'40 Days of Prayer for the Unreached','40-days-of-prayer-for-the-unreached','Devotional Book','Prayer Coordinator','A devotional guide walking through forty days of focused prayer for unreached people groups.',NULL,NULL,NULL,0,'draft',0,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(5,'Q2 Uganda Field Update','q2-uganda-field-update','Field Update','Emeka Okafor','A field update covering clinic operations and church-planting progress in the Great Lakes Region.',NULL,NULL,'2026-07-25',0,'published',0,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'); /*!40000 ALTER TABLE `publications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` bigint(20) unsigned NOT NULL, `permission_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_role_permissions` (`role_id`,`permission_id`), KEY `fk_role_permissions_permission` (`permission_id`), CONSTRAINT `fk_role_permissions_permission` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_role_permissions_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES (40,2,1),(37,2,2),(39,2,3),(38,2,4),(31,2,5),(30,2,6),(36,2,7),(1,2,8),(2,2,9),(29,2,10),(18,2,11),(15,2,12),(17,2,13),(16,2,14),(14,2,15),(11,2,16),(13,2,17),(12,2,18),(24,2,19),(21,2,20),(23,2,21),(22,2,22),(10,2,23),(7,2,24),(9,2,25),(8,2,26),(20,2,27),(19,2,28),(35,2,29),(32,2,30),(34,2,31),(33,2,32),(28,2,33),(25,2,34),(27,2,35),(26,2,36),(6,2,37),(5,2,38),(42,2,39),(41,2,40),(4,2,41),(3,2,42),(176,2,45),(71,3,29),(70,3,31),(69,3,33),(66,3,34),(68,3,35),(67,3,36),(65,3,41),(64,3,42),(172,3,43),(171,3,44),(86,4,11),(83,4,12),(85,4,13),(84,4,14),(82,4,15),(79,4,16),(81,4,17),(80,4,18),(90,4,19),(87,4,20),(89,4,21),(88,4,22),(96,5,10),(95,5,37),(94,5,38),(105,6,29),(102,6,30),(104,6,31),(103,6,32),(101,6,33),(98,6,34),(100,6,35),(99,6,36),(97,6,41),(113,7,27),(112,7,28),(116,8,39),(115,8,40),(121,9,23),(118,9,24),(120,9,25),(119,9,26),(132,10,29),(130,10,30),(131,10,31),(129,10,33),(127,10,34),(128,10,35),(126,10,41),(125,10,42),(174,10,43),(168,11,1),(166,11,5),(156,11,8),(165,11,10),(161,11,11),(160,11,15),(163,11,19),(159,11,23),(162,11,27),(167,11,29),(164,11,33),(158,11,37),(169,11,39),(157,11,41),(175,11,43); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `display_name` varchar(100) NOT NULL, `description` varchar(255) DEFAULT NULL, `is_system` tinyint(1) NOT NULL DEFAULT 0 COMMENT 'Seeded role -- cannot be deleted. super_administrator specifically also cannot have its permissions edited (it bypasses the permission table entirely in code).', `is_enabled` tinyint(1) NOT NULL DEFAULT 1 COMMENT 'Disabled roles are hidden from the user-creation role picker but existing holders keep the role.', `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_roles_name` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'super_administrator','Super Administrator','Full unrestricted access to every module and setting. Bypasses permission checks in code.',1,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(2,'administrator','Administrator','Full operational access to every module, managed through explicit permissions.',1,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(3,'content_manager','Content Manager','Manages the public website: pages, sliders, testimonials, FAQs, publications.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(4,'mission_coordinator','Mission Coordinator','Manages missionaries, mission fields, and outreach projects.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(5,'finance_officer','Finance Officer','Manages donations and financial reporting.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(6,'media_manager','Media Manager','Manages sermons, media centre, and publications.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(7,'prayer_coordinator','Prayer Coordinator','Manages prayer requests and praise reports.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(8,'volunteer_coordinator','Volunteer Coordinator','Manages volunteer registrations and assignments.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(9,'event_manager','Event Manager','Manages events, registration, and check-in.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(10,'editor','Editor','Read/write access to content modules without delete or system settings.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'),(11,'viewer','Viewer','Read-only access across all modules.',0,1,'2026-08-08 10:18:01','2026-08-08 10:18:01'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_logs` -- DROP TABLE IF EXISTS `security_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `security_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `identifier` varchar(150) NOT NULL, `status` enum('success','failed','locked') NOT NULL, `reason` varchar(255) DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` varchar(255) DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`), KEY `idx_security_logs_user` (`user_id`), KEY `idx_security_logs_created` (`created_at`), CONSTRAINT `fk_security_logs_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `security_logs` -- LOCK TABLES `security_logs` WRITE; /*!40000 ALTER TABLE `security_logs` DISABLE KEYS */; INSERT INTO `security_logs` VALUES (1,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:22:04'),(2,NULL,'viewer@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:22:51'),(3,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:24:09'),(4,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:25:31'),(5,NULL,'admin@demo.com','failed','Unknown email','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 10:32:00'),(6,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:34:25'),(7,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 10:57:44'),(8,1,'admin@missionsuite.test','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 11:13:36'),(9,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 11:17:31'),(10,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 14:55:17'),(11,1,'admin@missionsuite.test','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 15:01:22'),(12,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 15:22:56'),(13,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 15:48:09'),(14,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 16:07:18'),(15,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 16:31:54'),(16,1,'admin@missionsuite.test','success','','::1','curl/8.16.0','2026-08-08 16:48:35'),(17,1,'admin@missionsuite.test','failed','Bad password, attempt 1','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:04:50'),(18,NULL,'techageinno@gmail.com','failed','Unknown email','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:16:03'),(19,NULL,'techageinno@gmail.com','failed','Unknown email','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:16:26'),(20,1,'techageinno@gmail.com','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:17:13'),(21,1,'techageinno@gmail.com','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:17:57'),(22,1,'techageinno@gmail.com','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 17:26:56'),(23,1,'techageinno@gmail.com','success','','::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/151.0.0.0 Safari/537.36','2026-08-08 19:44:25'),(24,1,'techageinno@gmail.com','success','','::1','curl/8.16.0','2026-08-08 19:52:01'); /*!40000 ALTER TABLE `security_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sermons` -- DROP TABLE IF EXISTS `sermons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sermons` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `slug` varchar(220) NOT NULL, `media_type` enum('video','audio','pdf') NOT NULL DEFAULT 'audio', `category` varchar(60) NOT NULL DEFAULT 'Sermon', `speaker` varchar(150) DEFAULT NULL, `description` text DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `duration` varchar(20) DEFAULT NULL, `publish_date` date DEFAULT NULL, `plays_count` int(10) unsigned NOT NULL DEFAULT 0, `is_published` tinyint(1) NOT NULL DEFAULT 1, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_sermons_slug` (`slug`), KEY `idx_sermons_type` (`media_type`), KEY `idx_sermons_category` (`category`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sermons` -- LOCK TABLES `sermons` WRITE; /*!40000 ALTER TABLE `sermons` DISABLE KEYS */; INSERT INTO `sermons` VALUES (1,'Sent, Not Comfortable','sent-not-comfortable','audio','Sermon','Pastor J. Danladi','A call to embrace the discomfort of the mission field as part of genuine discipleship.',NULL,'34:00','2026-07-28',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(2,'Field Report — Q2 Uganda','field-report-q2-uganda','video','Field Report','Missionary Emeka Okafor','A video update from the Great Lakes Region clinic and church-planting work this quarter.',NULL,'12:15','2026-07-25',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(3,'Prayer for the Unreached','prayer-for-the-unreached','audio','Devotional','Prayer Coordinator','A short devotional on interceding for people groups who have never heard the Gospel.',NULL,'08:40','2026-07-22',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(4,'Cross-Cultural Discipleship','cross-cultural-discipleship','video','Bible Study','Ruth Adebayo','Teaching on making disciples across language and cultural barriers.',NULL,'41:20','2026-07-19',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(5,'Voices From the Field — Ep. 12','voices-from-the-field-ep-12','audio','Podcast','MissionSuite Podcast','Our monthly podcast featuring conversations with missionaries serving around the world.',NULL,'28:05','2026-07-15',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'),(6,'2025 Annual Field Report','2025-annual-field-report','pdf','Field Report','Executive Office','A downloadable summary of ministry activity and impact across all mission fields in 2025.',NULL,NULL,'2026-07-09',0,1,NULL,NULL,'2026-08-08 15:47:14','2026-08-08 15:47:14'); /*!40000 ALTER TABLE `sermons` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `key` varchar(100) NOT NULL, `value` text DEFAULT NULL, `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), UNIQUE KEY `uq_settings_key` (`key`) ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'ministry_name','Calvary Light Mission Inc','2026-08-08 17:20:56'),(2,'ministry_email','hello@sanctumchurch.com','2026-08-08 17:20:56'),(3,'ministry_phone','07033315307','2026-08-08 17:20:56'),(4,'ministry_address','Jl. Harmoni Iman No. 12, Jakarta, Indonesia','2026-08-08 17:20:56'),(5,'ministry_logo','','2026-08-08 10:18:01'),(6,'edition','professional','2026-08-08 10:18:01'),(7,'currency_symbol','$','2026-08-08 10:18:01'),(8,'theme_primary','#0F2438','2026-08-08 10:18:01'),(9,'theme_accent','#C97A2B','2026-08-08 10:18:01'),(10,'maintenance_mode','0','2026-08-08 10:18:01'),(12,'contact_email','hello@missionsuite.org','2026-08-08 10:56:02'),(13,'contact_phone','+234 (0) 000 0000','2026-08-08 10:56:02'),(14,'contact_whatsapp','+234 (0) 000 0001','2026-08-08 10:56:02'),(15,'contact_hours','Mon–Fri, 9am–5pm','2026-08-08 10:56:02'),(16,'contact_address','12 Dispatch Way, Victoria Island, Lagos, Nigeria','2026-08-08 10:56:02'),(17,'contact_departments','General Inquiry, Donations & Giving, Missionary Support, Volunteering, Mission Trips, Media & Press','2026-08-08 10:56:02'),(18,'map_address','12 Dispatch Way, Victoria Island, Lagos, Nigeria','2026-08-08 10:56:02'),(19,'map_lat','6.4281','2026-08-08 10:56:02'),(20,'map_lng','3.4219','2026-08-08 10:56:02'),(21,'map_zoom','14','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sliders` -- DROP TABLE IF EXISTS `sliders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sliders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(200) NOT NULL, `subtitle` varchar(300) DEFAULT NULL, `image_path` varchar(255) DEFAULT NULL, `link_url` varchar(255) DEFAULT NULL, `link_text` varchar(100) DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sliders` -- LOCK TABLES `sliders` WRITE; /*!40000 ALTER TABLE `sliders` DISABLE KEYS */; INSERT INTO `sliders` VALUES (1,'Welcome to MissionSuite','Thank you','/uploads/sliders/6a7702310854d4.68001477_1786184241.png','/donate','Give Now',0,1,'2026-08-08 11:17:21','2026-08-08 11:17:21'); /*!40000 ALTER TABLE `sliders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `team_members` -- DROP TABLE IF EXISTS `team_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `team_members` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `role_title` varchar(200) NOT NULL, `bio` varchar(500) DEFAULT NULL, `photo_path` varchar(255) DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `team_members` -- LOCK TABLES `team_members` WRITE; /*!40000 ALTER TABLE `team_members` DISABLE KEYS */; INSERT INTO `team_members` VALUES (1,'Pastor Emmanuel Ade','Executive Director','Leading the ministry\'s global strategy since 2011.',NULL,1,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(2,'Chinwe Obi','Director of Finance','Oversees stewardship of every gift and grant.',NULL,2,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(3,'James Tanko','Field Operations Director','Coordinates missionaries across every mission field.',NULL,3,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(4,'Faith Bello','Director of Prayer Ministry','Leads the global intercessory prayer network.',NULL,4,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `team_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `testimonials` -- DROP TABLE IF EXISTS `testimonials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `testimonials` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `type` enum('donor','missionary','partner_church','volunteer') NOT NULL DEFAULT 'donor', `role_title` varchar(200) DEFAULT NULL, `quote` text NOT NULL, `status` enum('pending','published','featured','rejected') NOT NULL DEFAULT 'pending', `email` varchar(150) DEFAULT NULL, `sort_order` int(11) NOT NULL DEFAULT 0, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `testimonials` -- LOCK TABLES `testimonials` WRITE; /*!40000 ALTER TABLE `testimonials` DISABLE KEYS */; INSERT INTO `testimonials` VALUES (1,'Faith Bello','missionary','Field Coordinator','Through MissionSuite\'s coordination, our clinic was able to treat hundreds of families this quarter alone — and every donor could see exactly where their gift went.','featured',NULL,1,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(2,'Adaeze Nwosu','donor','Monthly Partner since 2022','Seeing exactly where my monthly gift goes — down to the project — is what keeps me giving consistently.','published',NULL,2,'2026-08-08 10:56:02','2026-08-08 10:59:58'),(3,'Grace Family Church','partner_church','Partner Church','Our congregation can track the missionaries we sponsor in real time. It has transformed our missions giving culture.','published',NULL,3,'2026-08-08 10:56:02','2026-08-08 10:56:02'),(4,'Samuel Mensah','volunteer','Short-Term Trip Volunteer','Registering for a mission trip and tracking my support raising was seamless from start to finish.','published',NULL,4,'2026-08-08 10:56:02','2026-08-08 10:56:02'); /*!40000 ALTER TABLE `testimonials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `role_id` bigint(20) unsigned NOT NULL, `branch_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `phone` varchar(30) DEFAULT NULL, `password_hash` varchar(255) NOT NULL, `photo_path` varchar(255) DEFAULT NULL, `status` enum('active','inactive','suspended') NOT NULL DEFAULT 'active', `failed_login_attempts` int(10) unsigned NOT NULL DEFAULT 0, `locked_until` datetime DEFAULT NULL, `last_login_at` datetime DEFAULT NULL, `two_factor_enabled` tinyint(1) NOT NULL DEFAULT 0, `two_factor_secret` varchar(100) DEFAULT NULL, `password_reset_token` varchar(100) DEFAULT NULL, `password_reset_expires` datetime DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uq_users_email` (`email`), KEY `idx_users_role` (`role_id`), KEY `idx_users_branch` (`branch_id`), KEY `idx_users_status` (`status`), CONSTRAINT `fk_users_branch` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL, CONSTRAINT `fk_users_role` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,1,1,'Techage Inno','techageinno@gmail.com',NULL,'$2y$12$KWz4oh3V3/3luG1vciBGUOMOynTJxKQ.uODztTyF7.Bm0U/fTCuQu',NULL,'active',0,NULL,'2026-08-08 19:52:01',0,NULL,NULL,NULL,NULL,NULL,'2026-08-08 10:18:17','2026-08-08 19:52:01',NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `volunteers` -- DROP TABLE IF EXISTS `volunteers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `volunteers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `phone` varchar(30) DEFAULT NULL, `home_church` varchar(150) DEFAULT NULL, `department` varchar(60) NOT NULL DEFAULT 'Church Planting', `primary_skill` varchar(150) DEFAULT NULL, `additional_skills` text DEFAULT NULL, `availability` enum('trips','local','both') NOT NULL DEFAULT 'both', `project_id` bigint(20) unsigned DEFAULT NULL, `event_id` bigint(20) unsigned DEFAULT NULL, `status` enum('pending','active','inactive') NOT NULL DEFAULT 'pending', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp(), `updated_at` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`), KEY `idx_volunteers_status` (`status`), KEY `idx_volunteers_dept` (`department`), KEY `fk_volunteers_project` (`project_id`), KEY `fk_volunteers_event` (`event_id`), CONSTRAINT `fk_volunteers_event` FOREIGN KEY (`event_id`) REFERENCES `events` (`id`) ON DELETE SET NULL, CONSTRAINT `fk_volunteers_project` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `volunteers` -- LOCK TABLES `volunteers` WRITE; /*!40000 ALTER TABLE `volunteers` DISABLE KEYS */; INSERT INTO `volunteers` VALUES (1,'Samuel Mensah','samuel.mensah@example.com','+2348020000001','Grace Family Church, Lagos','Church Planting','Preaching','Discipleship','both',NULL,NULL,'pending',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(2,'Grace Nwankwo','grace.nwankwo@example.com','+2348020000002','Redeemed Faith Chapel','Medical Outreach','Nursing','First Aid','trips',2,NULL,'active',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(3,'Ifeoma Bassey','ifeoma.bassey@example.com','+2348020000003','Living Word Assembly','Media & Tech','Video Editing','Photography','both',NULL,1,'active',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(4,'Tunde Okafor','tunde.okafor@example.com','+2348020000004','Christ Covenant Church','Logistics','Driving','Procurement','trips',NULL,2,'active',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(5,'Rebecca Ajayi','rebecca.ajayi@example.com','+2348020000005','Mount Zion Fellowship','Hospitality','Event Planning',NULL,'local',NULL,NULL,'pending',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(6,'Paul Kariuki','paul.kariuki@example.com','+2348020000006','New Life Chapel','Church Planting','Worship','Youth Ministry','both',3,NULL,'active',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'),(7,'Hannah Danladi','hannah.danladi@example.com','+2348020000007','Emmanuel Baptist Church','Medical Outreach','Pharmacy',NULL,'local',NULL,NULL,'inactive',NULL,NULL,'2026-08-08 16:06:16','2026-08-08 16:06:16'); /*!40000 ALTER TABLE `volunteers` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'missionsuite_db' -- /*!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 2026-08-08 20:51:14