-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Jul 26, 2026 at 06:56 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


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

--
-- Database: `tnsmborg_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` bigint(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `facebook` varchar(255) DEFAULT NULL,
  `twitter` varchar(255) DEFAULT NULL,
  `instagram` varchar(255) DEFAULT NULL,
  `youtube` varchar(255) DEFAULT NULL,
  `map_embed` text DEFAULT NULL,
  `working_hours` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `address`, `phone`, `email`, `facebook`, `twitter`, `instagram`, `youtube`, `map_embed`, `working_hours`, `created_at`, `updated_at`) VALUES
(1, 'Department of Mathematics, University of Benin, Benin City, Edo State, Nigeria', '+234 803 704 2587', 'info@tnsmb.org', 'https://facebook.com/tnsmb', 'https://twitter.com/tnsmb', 'https://instagram.com/tnsmb', 'https://youtube.com/tnsmb', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3964.9516197277603!2d5.613384774991918!3d6.400235793590405!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x10472ce842f1f16d%3A0xb7ac53248ab6c6a!2sDepartment%20of%20Mathematics!5e0!3m2!1sen!2sng!4v1785010015605!5m2!1sen!2sng\" width=\"600\" height=\"450\" style=\"border:0;\" allowfullscreen=\"\" loading=\"lazy\" referrerpolicy=\"strict-origin-when-cross-origin\"></iframe>', 'Monday - Friday: 9:00 AM - 5:00 PM WAT', '2026-07-25 08:24:11', '2026-07-25 19:07:27');

-- --------------------------------------------------------

--
-- Table structure for table `council_members`
--

CREATE TABLE `council_members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `biography` text DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `type` enum('council','trustee') NOT NULL DEFAULT 'council',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `council_members`
--

INSERT INTO `council_members` (`id`, `name`, `position`, `biography`, `photo`, `email`, `phone`, `institution`, `order`, `is_active`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Prof. Godwin Mbah', 'President', 'Professor of Mathematics at the University of Nigeria, Nsukka. Specializes in mathematical biology and computational modeling.', 'council/xxbiqpPwqBpz0lhzDVOVHCecnOn3HuZ9kb6e67dd.png', 'godwin.mbah@unn.edu.ng', '+234-XXX-XXX-XXXX', 'University of Nigeria, Nsukka', 1, 1, 'council', '2026-07-25 08:24:11', '2026-07-26 09:31:46'),
(9, 'Prof. Sirajo Abdulrahman', 'Vice President', 'Professor of Mathematics at Federal University, Birnin Kebbi - FUBK', 'council/lm702TYoMzS3kUQYhxf1jTcMYWLuu3genCv0h4Kk.png', 'sirajo@tnsmb.org', '+234-XXX-XXX-XXXX', 'Federal University, Birnin Kebbi - FUBK', 2, 1, 'council', '2026-07-25 20:23:32', '2026-07-26 09:31:59'),
(10, 'Dr. Tertsegha Tivde', 'Secretary', 'Senior Lecturer, Mathematics Department, Joseph Sarwuan Tarka University, Makurdi - FUAM.', 'council/pFRwTIV1chPXaWa5PRa8YdprXky6uGTAUcKptJSQ.png', 'tivde@tnsmb.org', '+234 xxx xxxx xxx', 'Joseph Sarwuan Tarka University, Makurdi - FUAM', 3, 1, 'council', '2026-07-25 20:25:45', '2026-07-26 09:32:13'),
(11, 'Prof. Daniel Okuonghae', 'Editor-in-Chief', NULL, 'council/1BPYfFMKG2k4LEJSY15D1up0Tm3P6jGnldNcQYtX.png', 'okunghae@tnsmb.org', '+234 XXX XXXX xxx', 'University of Benin', 4, 1, 'council', '2026-07-25 20:27:22', '2026-07-26 09:35:57'),
(12, 'Mr. R. Adewoye', 'Assistant Secretary', NULL, NULL, 'adewoye@tnsmb.org', '+234 XXX XXXX XXX', 'RGP, Owo', 5, 1, 'council', '2026-07-25 20:29:10', '2026-07-25 20:29:10'),
(13, 'Dr. D. Bako', 'Treasurer', NULL, NULL, 'bako@tnsmb.org', '+234 XXX XXXX XXX', 'Federal University of Technology, Minna - FUT Minna', 6, 1, 'council', '2026-07-25 20:30:24', '2026-07-25 20:30:24'),
(14, 'Dr. T. T. Ashezua', 'Business Manager', NULL, 'council/nTtplea9Oj0LeQwJxjPvmLvkoRBSu6GOLl4Nr3mf.png', 'ashezua@tnsmb.org', '+234 XXX XXXX XXX', 'Joseph Sarwuan Tarka University, Makurdi - FUAM', 7, 1, 'council', '2026-07-25 20:31:40', '2026-07-26 09:36:17'),
(15, 'Prof. B. Bolaji', 'Ex-Officio I', NULL, 'council/ziTwkFw3xYn2U4O2QssKGisQ27mQsmhKyxq5xYSX.png', 'bolaji@tnsmb.org', '+234 XXX XXXX XXX', 'University of Nigeria, Nsukka', 8, 1, 'council', '2026-07-25 20:33:30', '2026-07-26 09:36:38'),
(16, 'Dr. D. Agbebaku', 'Ex-Officio II', NULL, 'council/cx2XsL4mwPfVb0I8lSagyKYiYs3PETMOo7hWnYqM.png', 'agbebaku@tnsmb.org', NULL, 'University of Nigeria, Nsukka', 9, 1, 'council', '2026-07-25 20:35:57', '2026-07-26 09:36:54');

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `banner_image` varchar(255) DEFAULT NULL,
  `venue` varchar(255) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `registration_fee` varchar(255) DEFAULT NULL,
  `theme` varchar(255) DEFAULT NULL,
  `subthemes` text DEFAULT NULL,
  `flier_url` varchar(255) DEFAULT NULL,
  `is_hybrid` tinyint(1) NOT NULL DEFAULT 0,
  `contact_emails` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`contact_emails`)),
  `abstract_deadline` date DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `description`, `banner_image`, `venue`, `start_date`, `end_date`, `registration_fee`, `theme`, `subthemes`, `flier_url`, `is_hybrid`, `contact_emails`, `abstract_deadline`, `is_active`, `created_at`, `updated_at`) VALUES
(1, '8th ANNUAL INTERNATIONAL WORKSHOP & CONFERENCE ON MATHEMATICAL MODELLING, SIMULATIONS, MATHEMATICAL ANALYSIS AND OPERATOR THEORY', 'The Nigerian Society of Mathematical Biology in conjunction with The UNIVERSITY OF BENIN, BENIN CITY DEPARTMENT OF MATHEMATICS Invites the general public to the 8th ANNUAL INTERNATIONAL WORKSHOP & CONFERENCE ON MATHEMATICAL MODELLING, SIMULATIONS, MATHEMATICAL ANALYSIS AND OPERATOR THEORY.\r\n\r\nA HYBRID (Virtual and Physical participation) Workshop and Conference\r\n\r\nEasy to use materials on R and its application on some of the subthemes will be given to Workshop Participants.\r\n\r\nSummary of Events\r\n---------------------\r\nSunday August 10, 2025 Arrival of Workshop Participants\r\n\r\nMon, 11th – Wed, 13th August, 2025  -  Workshop Days\r\n\r\nWednesday August 13, 2025  -   Arrival of Conference Participants\r\n\r\nThursday August 14, 2025   -   Opening Ceremony,\r\n\r\nPlenary and Parallel Sessions   -   Friday August 15, 2025\r\nPlenary, Parallel Sessions and AGM   -   Time: 10:00 am Daily\r\nSaturday August 16, 2024   -   Departure', 'events/banners/3H0HQEJM2vVEEadJu3oWleI1dSgrrci8Iqeo9KiW.png', 'University of Benin, Benin City', '2025-08-11', '2025-08-13', 'Download the conference flier below for more information on registration fees', 'Mathematics in the Age of Complexity and for the Future: Bridging Theory, Data, Dynamics and Real-World Impact', 'AI and Machine Learning\r\nDynamical Systems\r\nClimate, Environmental and Sustainability Modelling\r\nOperator Theory and Applications\r\nData Science', '../storage/fliers/NSMB%20CONFERENCE%202025.pdf', 1, NULL, NULL, 1, '2026-07-25 08:24:11', '2026-07-26 09:15:33'),
(2, '6th Annual International Workshop and Conference on Mathematical Modelling, Simulations, Mathematical Analysis and Operator Theory', 'The 6th Annual International Workshop and Conference on Mathematical Modelling, Simulations, Mathematical Analysis and Operator Theory.\r\nTheme: Mathematics, Security and the Health of the Nation: The Link.\r\nSubthemes: Relevant Topics in all Areas of Mathematics (Pure and Applied), Physical and Life Sciences, Statistics, Computer Sciences, Social Science and Engineering.\r\n\r\nStart Date: Sunday, August 13, 2023\r\nEnd Date: Saturday, August 19, 2023\r\n\r\nVenue: Main Auditorium, Faculty of Physical Sciences and Department of Mathematics, J.O.C. Ezeilo Building (Abuja Building).\r\n\r\nSubthemes: Relevant Topics in all Areas of Mathematics (Pure and Applied), Physical and Life Sciences, Statistics, Computer Sciences, Social Science and Engineering.\r\n\r\nStart Date: Sunday, August 13, 2023\r\nEnd Date: Saturday, August 19, 2023', NULL, 'Main Auditorium, Faculty of Physical Sciences and Department of Mathematics, J.O.C. Ezeilo Building (Abuja Building)', '2023-08-13', '2023-08-19', 'Registration is closed for this event', 'Mathematics, Security and the Health of the Nation: The Link', 'Relevant Topics in all Areas of Mathematics (Pure and Applied)\r\nPhysical and Life Sciences\r\nStatistics\r\nComputer Sciences\r\nSocial Science and Engineering', NULL, 1, NULL, NULL, 1, '2026-07-25 08:24:11', '2026-07-26 08:54:24'),
(3, 'NSMB Conference 2021 - 5th International Workshop and Conference on Mathematical Modelling, Simulation, Mathematical Analysis and Operator Theory', 'The 5th International Workshop and Conference on Mathematical Modelling, Simulation, Mathematical Analysis and Operator Theory comes up on October 10 - 13, 2021.\r\n\r\nTheme: Distortion of Ecological Systems by Human Actions: The Mathematical Modelling Intervention Strategies.\r\n\r\nVenue: Department of Mathematics, University of Nigeria, Nsukka.\r\n\r\nRegistration Fees:\r\nWorkshop Registration Fee: N25,000.00k\r\nConference Registration Fee (Including Membership Fees): N5,000.00\r\n\r\nAll Workshop Participants are automatically Registered for the conference. There will be chance for virtual attendance.\r\nPlease submit your Abstracts to godwin.mbah@unn.edu.ng  or dennis.agbebaku@unn.edu.ng\r\nDeadline for Abstracts Submission is Friday 1st October, 2021.', 'events/banners/Z7CRioPbhq0yndOb1FHkqO3LndVq8k9jiuWj4nYK.png', 'Department of Mathematics, University of Nigeria, Nsukka', '2021-10-10', '2021-10-13', 'Registration is closed for this event.', 'Distortion of Ecological Systems by Human Actions: The Mathematical Modelling Intervention Strategies', 'Ecological Systems\r\nMathematical Modelling\r\nIntervention Strategies', NULL, 1, '[\"godwin.mbah@unn.edu.ng\",\"dennis.agbebaku@unn.edu.ng\"]', '2021-10-01', 1, '2026-07-25 08:24:11', '2026-07-26 08:57:34');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` varchar(255) NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `category` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galleries`
--

INSERT INTO `galleries` (`id`, `title`, `description`, `image`, `category`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'NSMB Conference 2023 Group Photo', 'Participants at the 6th Annual International Workshop and Conference', 'gallery/conf2023.jpg', 'Conferences', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(2, 'Workshop Session', 'Interactive workshop session during the annual conference', 'gallery/workshop.jpg', 'Workshops', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(3, 'Award Ceremony', 'Award presentation to outstanding researchers', 'gallery/awards.jpg', 'Awards', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(4, 'Panel Discussion', 'Panel discussion on the future of mathematical biology in Nigeria', 'gallery/panel.jpg', 'Conferences', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(5, 'Student Poster Session', 'Students presenting their research posters', 'gallery/poster.jpg', 'Students', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(6, 'Networking Reception', 'Participants networking during the conference reception', 'gallery/networking.jpg', 'Social Events', 1, '2026-07-25 08:24:11', '2026-07-25 08:24:11');

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` smallint(5) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_01_01_000001_create_events_table', 1),
(5, '2024_01_01_000002_create_news_table', 1),
(6, '2024_01_01_000003_create_slides_table', 1),
(7, '2024_01_01_000004_create_galleries_table', 1),
(8, '2024_01_01_000005_create_council_members_table', 1),
(9, '2024_01_01_000006_create_contacts_table', 1),
(10, '2024_01_01_000007_create_website_settings_table', 1);

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` text NOT NULL,
  `featured_image` varchar(255) DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `content`, `featured_image`, `is_published`, `published_at`, `created_at`, `updated_at`) VALUES
(1, 'NSMB Announces 8th Annual International Workshop & Conference', 'The Nigerian Society of Mathematical Biology is pleased to announce its 8th Annual International Workshop & Conference on Mathematical Modelling, Simulations, Mathematical Analysis and Operator Theory. The event will be held at the University of Benin, Benin City from November 15-20, 2024.\r\n\r\nThis year\'s theme is \"Mathematics in the Age of Complexity and for the Future: Bridging Theory, Data, Dynamics and Real-World Impact\".\r\n\r\nKey subthemes include:\r\n- AI and Machine Learning\r\n- Dynamical Systems\r\n- Climate, Environmental and Sustainability Modelling\r\n- Operator Theory and Applications\r\n- Data Science\r\n\r\nThe conference will be a hybrid event with both virtual and physical participation options available.', NULL, 1, '2026-07-20 08:24:11', '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(2, 'Call for Abstracts - NSMB Annual Conference 2024', 'The Nigerian Society of Mathematical Biology invites submissions of abstracts for its upcoming annual conference. Researchers and practitioners in mathematical biology and related fields are encouraged to submit their work.\r\n\r\nAbstracts should be no more than 300 words and should clearly state the objectives, methods, results, and conclusions of the research.\r\n\r\nImportant Dates:\r\n- Abstract Submission Deadline: October 15, 2024\r\n- Notification of Acceptance: October 30, 2024\r\n- Conference Dates: November 15-20, 2024\r\n\r\nSubmit your abstracts through the conference management system.', NULL, 1, '2026-07-15 08:24:11', '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(3, 'NSMB Partners with University of Benin for 2024 Conference', 'The Nigerian Society of Mathematical Biology has partnered with the University of Benin, Benin City to host the 8th Annual International Workshop & Conference on Mathematical Modelling, Simulations, Mathematical Analysis and Operator Theory.\r\n\r\nThis partnership aims to strengthen the collaboration between the society and academic institutions in advancing mathematical biology research in Nigeria.\r\n\r\nThe conference will feature keynote speakers, workshops, and networking opportunities for participants from across the globe.', NULL, 1, '2026-07-10 08:24:11', '2026-07-25 08:24:11', '2026-07-25 08:24:11');

-- --------------------------------------------------------

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `publications`
--

CREATE TABLE `publications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `type` enum('page','url') NOT NULL DEFAULT 'page',
  `content` longtext DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `open_in_new_tab` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `publications`
--

INSERT INTO `publications` (`id`, `title`, `slug`, `type`, `content`, `url`, `order`, `is_active`, `open_in_new_tab`, `created_at`, `updated_at`) VALUES
(1, 'Annual Reports', 'annual-report', 'page', '<h2>NSMB Annual Report 2024</h2><p>This is the annual report for the Nigerian Society of Mathematical Biology.</p><ul><li>Membership growth</li><li>Conference highlights</li><li>Research publications</li><li>Community outreach</li></ul>', NULL, 1, 1, 0, '2026-07-26 11:13:53', '2026-07-26 10:59:26'),
(2, 'Int. Journal of Math. Analysis and Modelling', 'mathematical-biology-journal', 'url', NULL, 'https://tnsmb.org/journal/', 2, 1, 1, '2026-07-26 11:13:53', '2026-07-26 10:58:59'),
(3, 'Conference Proceedings', 'conference-proceedings', 'page', '<h2>Conference Proceedings 2023</h2><p>Proceedings from the 6th Annual International Workshop and Conference on Mathematical Modelling, Simulations, Mathematical Analysis and Operator Theory.</p><p><strong>Theme:</strong> Mathematics, Security and the Health of the Nation: The Link</p>', NULL, 3, 1, 0, '2026-07-26 11:13:53', '2026-07-26 11:00:03'),
(5, 'NSMB Newsletter', 'nsmb-newsletter', 'url', NULL, 'https://tnsmb.org/newsletter', 5, 1, 1, '2026-07-26 11:13:53', '2026-07-26 11:13:53');

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `slides`
--

CREATE TABLE `slides` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `order` int(11) NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slides`
--

INSERT INTO `slides` (`id`, `title`, `description`, `image`, `link`, `order`, `is_active`, `created_at`, `updated_at`) VALUES
(1, 'Welcome to Nigerian Society of Mathematical Biology', 'Advancing Mathematical Biology Research and Education in Nigeria', 'slides/DjpqfEqe2hRHjuN9t1bHKfa1NTGEvkt85cCtJ8Pd.png', NULL, 1, 1, '2026-07-25 08:24:11', '2026-07-26 09:39:42'),
(2, '8th Annual International Conference', 'Join us at the University of Benin, Benin City for our flagship event', 'slides/Mhu79sI96LOXTexad0b4hjbAuD5IRfRfalggYuMv.png', NULL, 2, 1, '2026-07-25 08:24:11', '2026-07-25 18:41:29'),
(3, 'Mathematical Biology for Sustainable Development', 'Using mathematical models to solve real-world problems', 'slides/vVzkWLa43nxrg2vyL2TsxafVHh6uXWj168HzSkOA.jpg', NULL, 3, 1, '2026-07-25 08:24:11', '2026-07-25 18:43:42'),
(4, 'NSMB Conference 2021', 'The 5th International Workshop and Conference on Mathematical Modelling, Simulation, Mathematical Analysis and Operator Theory comes up on October 10 - 13, 2021.\r\nTheme: Distortion of Ecological Systems by Human Actions: The Mathematical Modelling Intervention Strategies.\r\nVenue: Department of Mathematics, University of Nigeria, Nsukka.\r\nRegistration Fees:\r\nWorkshop Registration Fee: N25,000.00k\r\nConference Registration Fee (Including Membership Fees): N5,000.00\r\nAll Workshop Participants are automatically Registered for the conference. There will be chance for virtual attendance.\r\nPlease submit your Abstracts to godwin.mbah@unn.edu.ng  or dennis.agbebaku@unn.edu.ng', 'slides/xX7MzvxZui7WoHJQQxRElH6lvV2ogav7xauYHqzZ.png', NULL, 4, 1, '2026-07-26 09:41:42', '2026-07-26 09:41:42');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Admin User', 'admin@tnsmb.org', NULL, '$2y$12$JZJtUCcR8bBM2vKuUFUQiuORV4lCGwixet8DML6TqQxnr8yL2FJF.', NULL, '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(2, 'Test User', 'test@example.com', NULL, '$2y$12$JZJtUCcR8bBM2vKuUFUQiuORV4lCGwixet8DML6TqQxnr8yL2FJF.', NULL, '2026-07-25 08:24:11', '2026-07-25 08:24:11');

-- --------------------------------------------------------

--
-- Table structure for table `website_settings`
--

CREATE TABLE `website_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) NOT NULL,
  `value` text DEFAULT NULL,
  `type` enum('text','color','image','json') NOT NULL DEFAULT 'text',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `website_settings`
--

INSERT INTO `website_settings` (`id`, `key`, `value`, `type`, `created_at`, `updated_at`) VALUES
(1, 'primary_color', '#003366', 'text', '2026-07-25 08:24:11', '2026-07-25 19:15:04'),
(2, 'secondary_color', '#ff9933', 'text', '2026-07-25 08:24:11', '2026-07-25 19:15:04'),
(3, 'logo', 'logo/znCpB9jujTUDmD7XWDInJUpmFgE9nj2jeAf7YUiF.png', 'image', '2026-07-25 08:24:11', '2026-07-25 19:15:04'),
(4, 'site_title', 'Nigerian Society of Mathematical Biology', 'text', '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(5, 'site_description', 'Advancing Mathematical Biology Research and Education in Nigeria', 'text', '2026-07-25 08:24:11', '2026-07-25 08:24:11'),
(6, 'footer_text', '© 2026 Nigerian Society of Mathematical Biology. All rights reserved.', 'text', '2026-07-25 08:24:11', '2026-07-25 19:42:56');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_expiration_index` (`expiration`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`),
  ADD KEY `cache_locks_expiration_index` (`expiration`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `council_members`
--
ALTER TABLE `council_members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`),
  ADD KEY `failed_jobs_connection_queue_failed_at_index` (`connection`,`queue`,`failed_at`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indexes for table `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `publications`
--
ALTER TABLE `publications`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `publications_slug_unique` (`slug`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indexes for table `slides`
--
ALTER TABLE `slides`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `website_settings`
--
ALTER TABLE `website_settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `website_settings_key_unique` (`key`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `council_members`
--
ALTER TABLE `council_members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `publications`
--
ALTER TABLE `publications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `slides`
--
ALTER TABLE `slides`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `website_settings`
--
ALTER TABLE `website_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
COMMIT;

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