-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 08, 2026 at 07:08 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: `iqskills` -- -- -------------------------------------------------------- -- -- Table structure for table `blogauthor` -- CREATE TABLE `blogauthor` ( `blogauthorid` bigint(20) UNSIGNED NOT NULL, `blogauthorname` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `bio` text DEFAULT NULL, `avatar` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `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 `blogauthor` -- INSERT INTO `blogauthor` (`blogauthorid`, `blogauthorname`, `email`, `designation`, `bio`, `avatar`, `status`, `created_at`, `updated_at`) VALUES (1, 'Dr. Cibi John Francis', 'cibi@iqskills.co.za', 'Academic Dean & Founder', 'Dean of IQ Skills Academy, specialist in neuro life coaching, human behavior transformation and educational leadership.', NULL, 'active', '2026-10-07 11:46:54', '2026-10-07 11:46:54'), (2, 'Prof. Alex Mercer', 'alex.mercer@iqskills.co.za', 'Head of AI & Employability', 'Technologist and AI literacy researcher specializing in future workforce readiness and cognitive computing.', NULL, 'active', '2026-10-07 11:46:54', '2026-10-07 11:46:54'), (3, 'Dr. Lauren Venter', 'lauren.venter@iqskills.co.za', 'Director of Holistic Wellness', 'IAOTH accredited psychologist and mindfulness mentor guiding the Green Code curriculum.', NULL, 'active', '2026-10-07 11:46:54', '2026-10-07 11:46:54'); -- -------------------------------------------------------- -- -- Table structure for table `blogcat` -- CREATE TABLE `blogcat` ( `blogcatid` bigint(20) UNSIGNED NOT NULL, `catname` varchar(255) NOT NULL, `catslug` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `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 `blogcat` -- INSERT INTO `blogcat` (`blogcatid`, `catname`, `catslug`, `description`, `status`, `created_at`, `updated_at`) VALUES (2, 'Purple Code — AI & Employability', 'purple-code-ai-employability', 'Artificial intelligence literacy, future skills, career development, and job readiness.', 'active', '2026-10-07 11:36:38', '2026-10-07 11:36:38'), (3, 'Blue Code — Leadership & Business', 'blue-code-leadership-business', 'Executive leadership, corporate strategy, management, and entrepreneurship.', 'active', '2026-10-07 11:36:38', '2026-10-07 11:36:38'), (4, 'Academy Announcements & Events', 'academy-announcements', 'Official news, IAOTH & SACE accreditation updates, and campus events.', 'active', '2026-10-07 11:36:38', '2026-10-07 11:36:38'), (13, 'Green Code — Holistic Wellness', 'green-code-wellness', 'Mindfulness, emotional intelligence, life coaching, and human transformation.', 'active', '2026-10-07 11:44:07', '2026-10-07 11:44:07'); -- -------------------------------------------------------- -- -- Table structure for table `blogcontent` -- CREATE TABLE `blogcontent` ( `blogid` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `catid` bigint(20) UNSIGNED DEFAULT NULL, `authorid` bigint(20) UNSIGNED DEFAULT NULL, `content` longtext DEFAULT NULL, `blogimage` varchar(255) DEFAULT NULL, `seourl` varchar(255) DEFAULT NULL, `metatitle` varchar(255) DEFAULT NULL, `metatile` varchar(255) DEFAULT NULL, `metadesp` text DEFAULT NULL, `keyword` text DEFAULT NULL, `featured_image` varchar(255) DEFAULT NULL, `is_featured` tinyint(1) NOT NULL DEFAULT 0, `publish_date` date DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'published', `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 `blogcontent` -- INSERT INTO `blogcontent` (`blogid`, `title`, `catid`, `authorid`, `content`, `blogimage`, `seourl`, `metatitle`, `metatile`, `metadesp`, `keyword`, `featured_image`, `is_featured`, `publish_date`, `status`, `created_at`, `updated_at`) VALUES (1, 'Neuroplasticity & Executive Performance: The New Frontier of Cognitive Leadership', 2, 1, '

In an era defined by rapid technological acceleration and hyper-complexity, organizational leadership demands unprecedented mental agility. Neuroplasticity—the brain’s extraordinary ability to reorganize itself by forming new neural pathways—is no longer a theoretical neuroscience concept; it has become an indispensable executive capability.

The Cognitive Shift in Leadership

Leaders who master emotional self-regulation and cognitive reframing experience a 40% higher resilience index in high-stakes negotiation settings.

Explore IQ Skills Academy’s accredited Green Code curriculum to empower your leadership transformation today.

', '/uploads/blog/blog_1791396125_V1ql21zV.jpeg', 'neuroplasticity-and-executive-performance-in-2026', 'Neuroplasticity & Executive Performance | IQ Skills Academy', 'Neuroplasticity & Executive Performance | IQ Skills Academy', 'Discover how neuroplasticity and cognitive reframing drive executive leadership and peak performance in 2026.', 'neuroplasticity, executive leadership, green code, cognitive performance, IQ skills academy', NULL, 0, NULL, 'published', '2026-10-07 12:03:26', '2026-10-07 12:32:05'), (24, 'xzxzxzXzxzxzxzx', 4, 1, '

xzxzxzXzxzx

', '/uploads/blog/blog_1791396096_IHnhttrj.jpeg', 'xzxzxzxzxzxzxzx', 'xcxzcxzcx', 'xcxzcxzcx', 'cxcxc', 'cxzcxzcxc', NULL, 0, NULL, 'published', '2026-10-07 12:31:36', '2026-10-07 12:31:36'); -- -------------------------------------------------------- -- -- Table structure for table `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cache` -- INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES ('iq_skills_academy_cache_app_setting_admin_prefix', 's:8:\"admin123\";', 2106786989); -- -------------------------------------------------------- -- -- Table structure for table `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text 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 `iqskills` -- CREATE TABLE `iqskills` ( `id` bigint(20) UNSIGNED NOT NULL, `first_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `area_of_interest` varchar(255) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `message` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'new', `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`data`)), `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 `iqskills` -- INSERT INTO `iqskills` (`id`, `first_name`, `last_name`, `name`, `email`, `phone`, `area_of_interest`, `subject`, `message`, `status`, `data`, `created_at`, `updated_at`) VALUES (7, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 11:42:36', '2026-10-07 11:42:36'), (8, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 11:42:36', '2026-10-07 11:42:36'), (9, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 11:42:36', '2026-10-07 11:42:36'), (10, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 11:44:19', '2026-10-07 11:44:19'), (11, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 11:44:19', '2026-10-07 11:44:19'), (12, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 11:44:19', '2026-10-07 11:44:19'), (13, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 11:48:51', '2026-10-07 11:48:51'), (14, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 11:48:51', '2026-10-07 11:48:51'), (15, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 11:48:51', '2026-10-07 11:48:51'), (16, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 11:51:40', '2026-10-07 11:51:40'), (17, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 11:51:40', '2026-10-07 11:51:40'), (18, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 11:51:40', '2026-10-07 11:51:40'), (19, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 11:53:55', '2026-10-07 11:53:55'), (20, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 11:53:55', '2026-10-07 11:53:55'), (21, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 11:53:55', '2026-10-07 11:53:55'), (22, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 12:06:58', '2026-10-07 12:06:58'), (23, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 12:06:58', '2026-10-07 12:06:58'), (24, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 12:06:58', '2026-10-07 12:06:58'), (25, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 12:29:11', '2026-10-07 12:29:11'), (26, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 12:29:11', '2026-10-07 12:29:11'), (27, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 12:29:11', '2026-10-07 12:29:11'), (28, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 12:30:24', '2026-10-07 12:30:24'), (29, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 12:30:24', '2026-10-07 12:30:24'), (30, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 12:30:24', '2026-10-07 12:30:24'), (31, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 20:57:13', '2026-10-07 20:57:13'), (32, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 20:57:13', '2026-10-07 20:57:13'), (33, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 20:57:13', '2026-10-07 20:57:13'), (34, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:05:55', '2026-10-07 21:05:55'), (35, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:05:55', '2026-10-07 21:05:55'), (36, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:05:55', '2026-10-07 21:05:55'), (37, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:08:33', '2026-10-07 21:08:33'), (38, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:08:33', '2026-10-07 21:08:33'), (39, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:08:33', '2026-10-07 21:08:33'), (41, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:09:57', '2026-10-07 21:09:57'), (42, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:09:57', '2026-10-07 21:09:57'), (43, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:19:24', '2026-10-07 21:19:24'), (44, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:19:24', '2026-10-07 21:19:24'), (45, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:19:24', '2026-10-07 21:19:24'), (46, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:20:03', '2026-10-07 21:20:03'), (47, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:20:03', '2026-10-07 21:20:03'), (48, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:20:03', '2026-10-07 21:20:03'), (49, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:33:41', '2026-10-07 21:33:41'), (50, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:33:41', '2026-10-07 21:33:41'), (51, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:33:41', '2026-10-07 21:33:41'), (52, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:39:46', '2026-10-07 21:39:46'), (53, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:39:46', '2026-10-07 21:39:46'), (54, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:39:46', '2026-10-07 21:39:46'), (55, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:40:48', '2026-10-07 21:40:48'), (56, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:40:48', '2026-10-07 21:40:48'), (57, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:40:48', '2026-10-07 21:40:48'), (58, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:46:35', '2026-10-07 21:46:35'), (59, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:46:35', '2026-10-07 21:46:35'), (60, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:46:35', '2026-10-07 21:46:35'), (61, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 21:48:07', '2026-10-07 21:48:07'), (62, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 21:48:07', '2026-10-07 21:48:07'), (63, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 21:48:07', '2026-10-07 21:48:07'), (64, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 22:03:21', '2026-10-07 22:03:21'), (65, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 22:03:21', '2026-10-07 22:03:21'), (66, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 22:03:21', '2026-10-07 22:03:21'), (67, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 22:04:11', '2026-10-07 22:04:11'), (68, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 22:04:11', '2026-10-07 22:04:11'), (69, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 22:04:11', '2026-10-07 22:04:11'), (70, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 23:49:55', '2026-10-07 23:49:55'), (71, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 23:49:55', '2026-10-07 23:49:55'), (72, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 23:49:55', '2026-10-07 23:49:55'), (73, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 23:57:49', '2026-10-07 23:57:49'), (74, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 23:57:49', '2026-10-07 23:57:49'), (75, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 23:57:49', '2026-10-07 23:57:49'), (76, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-07 23:58:14', '2026-10-07 23:58:14'), (77, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-07 23:58:14', '2026-10-07 23:58:14'), (78, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-07 23:58:14', '2026-10-07 23:58:14'), (79, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-08 00:02:34', '2026-10-08 00:02:34'), (80, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-08 00:02:34', '2026-10-08 00:02:34'), (81, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-08 00:02:35', '2026-10-08 00:02:35'), (82, 'John', 'Smith', 'John Smith', 'john.smith@example.com', '+27 11 123 4567', 'Green Code', 'Green Code', 'I would like to inquire about the holistic wellness diploma.', 'new', '[]', '2026-10-08 00:09:18', '2026-10-08 00:09:18'), (83, NULL, NULL, 'Sarah Connor', 'sarah@example.com', NULL, 'Purple Code', 'Purple Code', 'Inquiring about Purple Code AI Literacy.', 'new', '[]', '2026-10-08 00:09:18', '2026-10-08 00:09:18'), (84, 'Test', 'Lead', NULL, 'lead@example.com', NULL, NULL, NULL, 'Testing iqskills table storage display', 'new', NULL, '2026-10-08 00:09:18', '2026-10-08 00:09:18'); -- -------------------------------------------------------- -- -- Table structure for table `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) 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, '2026_10_07_155135_add_role_to_users_table', 1), (5, '2026_10_07_164750_create_iqskills_table', 1), (6, '2026_10_07_170502_create_blogcat_table', 2), (7, '2026_10_07_171558_create_blogauthor_table', 3), (8, '2026_10_07_173210_create_blogcontent_table', 4), (9, '2026_10_07_175209_add_blogimage_to_blogcontent_table', 5), (10, '2026_10_08_080000_create_settings_table', 6), (11, '2026_10_08_083000_add_is_featured_to_blogcontent_table', 7), (12, '2026_10_08_083500_add_publish_date_to_blogcontent_table', 8); -- -------------------------------------------------------- -- -- 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 `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; -- -- Dumping data for table `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('4RU5iaFZITKiTdnp82WbjwgQZFUheMM6VZM48q1I', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiY1Z4RDJrWGxpamVLdVhxR1RwZ3JTMDhId3lMc3V5VFdQSHA3ckFHRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDQ6Imh0dHA6Ly9sb2NhbGhvc3QvYmxvZy1kZXRhaWwveHp4enh6eHp4enh6eHp4IjtzOjU6InJvdXRlIjtOO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791437667), ('6vk6GJEkPKGIiH347qLziF3UqMFNH7IY5bLD9Wn0', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiNkloVzA1b2FpQllGRzJJSzJwV2ZDcTNST0RWaURGMEdIT2VWZlM1UCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly9sb2NhbGhvc3Qvbm90LXJlYWwtc2x1Zy0xMjM0NSI7czo1OiJyb3V0ZSI7czoxMToiYmxvZy5kZXRhaWwiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791438814), ('BdYayO6Mj8lNMMKzcbAE7H7UgEsG9nQBCD8qEtxf', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiRUdxMzZRQ1E3emNJY1o0c05wM0tGaVlTc3JIWFlmUEpxSTRNd3pRWCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9sb2NhbGhvc3QvYmxvZy94enh6eHp4enh6eHp4engiO3M6NToicm91dGUiO3M6MTE6ImJsb2cuZGV0YWlsIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1791437619), ('dH4C6VNBvEk66TkFOfIJLDgDr6uyCIvNVfQo6ujY', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoicDNDazV1bmM0OHRZRzJNQmZCNmZuT2dnTU90VGh2RVl3enRXVTBhbiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MjI6Imh0dHA6Ly9sb2NhbGhvc3QvYWJvdXQiO3M6NToicm91dGUiO3M6NToiYWJvdXQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791438826), ('e2zfp1kjm97U26InEk74fqcRzBz7LeF97EoD7h30', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiZmxWb2FHRzR1TDBXWGZuSXNobG1aOUg5SnRqejNGU0JKVFhXaXhqUCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9sb2NhbGhvc3QveHp4enh6eHp4enh6eHp4IjtzOjU6InJvdXRlIjtzOjExOiJibG9nLmRldGFpbCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791438735), ('IAco4vMPOnI0rSE85O0XkRUSunFQf6KlbZCdHbay', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiM3BpNXdaVUdObGpwOEdCbmpiVUNBdGRoQk1RYklCcldidHQ2RWNicCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly9sb2NhbGhvc3QvYmxvZy1kZXRhaWw/aWQ9eHp4enh6eHp4enh6eHp4IjtzOjU6InJvdXRlIjtOO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1791437634), ('kBycWbzHzzJQ3BPJRGge41NGcGSk61vb7piRdHQJ', NULL, '127.0.0.1', 'Symfony', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoieHFEQkhZdERaem9CVDdnWDZ6NFp1MG9iMFRFbk1yNEFJcVFINXVlRiI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly9sb2NhbGhvc3QvYmxvZy94enh6eHp4enh6eHp4engiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1791438780), ('vX9P2gg1WrEV90QUG7Rh5lGEa3rhmF6QZp6eAd7z', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/155.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiR3ZLcGhaWEZTWExNU2RTb1ZDdTh0b0F2dVJkQVBGbDAyYnRBV2tYaCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mzc6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC94enh6eHp4enh6eHp4engiO3M6NToicm91dGUiO3M6MTE6ImJsb2cuZGV0YWlsIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1791439317); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) NOT NULL, `value` 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 `settings` -- INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES (1, 'admin_prefix', 'admin', '2026-10-07 21:05:30', '2026-10-08 00:09:18'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `role` varchar(255) NOT NULL DEFAULT 'user', `status` varchar(255) NOT NULL DEFAULT 'active', `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`, `role`, `status`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'kumar.sunil502@gmail.com', 'kumar.sunil502@gmail.com', 'admin', 'active', '2026-10-07 11:23:08', '$2y$12$B1kYnNuEpIjcOpKOxryrDeUh9BR8vuz.5/5460yPwX7bpvHhRuIxa', NULL, '2026-10-07 11:23:08', '2026-10-07 21:00:58'), (2, 'IQ Skills Administrator', 'admin@iqskills.co.za', 'admin', 'active', NULL, '$2y$04$w6g5ZA.B3F7Rh6NaYd864ux3KenoiDt0Vx8dvfgEIRmUtyNYdc45y', NULL, '2026-10-07 21:05:45', '2026-10-08 00:09:18'); -- -- Indexes for dumped tables -- -- -- Indexes for table `blogauthor` -- ALTER TABLE `blogauthor` ADD PRIMARY KEY (`blogauthorid`); -- -- Indexes for table `blogcat` -- ALTER TABLE `blogcat` ADD PRIMARY KEY (`blogcatid`), ADD UNIQUE KEY `blogcat_catslug_unique` (`catslug`); -- -- Indexes for table `blogcontent` -- ALTER TABLE `blogcontent` ADD PRIMARY KEY (`blogid`), ADD UNIQUE KEY `blogcontent_seourl_unique` (`seourl`), ADD KEY `blogcontent_catid_index` (`catid`), ADD KEY `blogcontent_authorid_index` (`authorid`); -- -- Indexes for table `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indexes for table `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indexes for table `iqskills` -- ALTER TABLE `iqskills` 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 `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- 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 `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `settings_key_unique` (`key`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogauthor` -- ALTER TABLE `blogauthor` MODIFY `blogauthorid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=303; -- -- AUTO_INCREMENT for table `blogcat` -- ALTER TABLE `blogcat` MODIFY `blogcatid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=313; -- -- AUTO_INCREMENT for table `blogcontent` -- ALTER TABLE `blogcontent` MODIFY `blogid` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160; -- -- AUTO_INCREMENT for table `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `iqskills` -- ALTER TABLE `iqskills` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=85; -- -- 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=13; -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Constraints for dumped tables -- -- -- Constraints for table `blogcontent` -- ALTER TABLE `blogcontent` ADD CONSTRAINT `blogcontent_authorid_foreign` FOREIGN KEY (`authorid`) REFERENCES `blogauthor` (`blogauthorid`) ON DELETE SET NULL, ADD CONSTRAINT `blogcontent_catid_foreign` FOREIGN KEY (`catid`) REFERENCES `blogcat` (`blogcatid`) ON DELETE SET NULL; 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 */;