-- MySQL dump 10.13  Distrib 8.0.40, for Win64 (x86_64)
--
-- Host: localhost    Database: larablog_db
-- ------------------------------------------------------
-- Server version	8.0.40

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 `albums`
--

DROP TABLE IF EXISTS `albums`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `albums` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `cover_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `albums_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `albums`
--

LOCK TABLES `albums` WRITE;
/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
INSERT INTO `albums` VALUES (1,'SCIT Day 2025','scit-day-2025','SCIT 2025','1746845896_Screenshot 2025-04-17 152334.png',1,'2025-05-09 18:58:16','2025-05-24 08:21:39','2025-05-24 08:21:39'),(2,'IT Day','it-day','IT day 2025','1747139288_Screenshot 2025-04-20 102053.png',1,'2025-05-13 04:28:08','2025-05-24 08:21:18','2025-05-24 08:21:18'),(3,'Basic Education Culmination 2024','basic-education-culmination-2024','Basic Education Culmination 2024','1748103792_29c4fd884f8b5fed471c7b30a3cb5f41.jpg',1,'2025-05-24 08:23:12','2025-05-24 08:23:12',NULL);
/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `carousel_images`
--

DROP TABLE IF EXISTS `carousel_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `carousel_images` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `image_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carousel_images`
--

LOCK TABLES `carousel_images` WRITE;
/*!40000 ALTER TABLE `carousel_images` DISABLE KEYS */;
INSERT INTO `carousel_images` VALUES (16,'d72a37e7-5efa-4781-947e-1070e23a2f24.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(17,'1c590a4d-ad75-4d8c-9b65-590711ac36e6.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(18,'0be2b8ab-6733-4268-b523-c87f9a502cdc.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(19,'62eb6316-649d-4e59-aa4e-5547d890e573.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(20,'e5baedf6-b0fa-4080-95d5-ecb77e990038.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(21,'25e5c82b-1a4d-4af5-b8c8-f6b8abc4824e.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL),(22,'3e667343-b584-41c3-99c4-31caaec2b214.jpg','2025-05-24 01:03:13','2025-05-24 01:03:13',NULL);
/*!40000 ALTER TABLE `carousel_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categories`
--

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent` int NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '1000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categories`
--

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Student Life','student-life',4,1000,'2025-05-08 23:35:31','2025-05-08 23:35:31'),(2,'Sports','sports',3,1000,'2025-05-08 23:37:31','2025-05-08 23:37:31'),(3,'Achievements','achievements',4,1000,'2025-05-08 23:40:36','2025-05-08 23:40:36'),(4,'Academics','academics',3,1000,'2025-05-08 23:41:12','2025-05-08 23:41:12'),(5,'Holiday Schedules','holiday-schedules',1,1000,'2025-05-08 23:41:44','2025-05-08 23:41:44'),(6,'Exams','exams',1,1000,'2025-05-08 23:41:58','2025-05-08 23:41:58'),(7,'Seminars','seminars',2,1000,'2025-05-08 23:42:12','2025-05-08 23:42:12'),(8,'Competitions','competitions',2,1000,'2025-05-08 23:42:21','2025-05-08 23:42:39');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facilities`
--

DROP TABLE IF EXISTS `facilities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `facilities` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `cover_photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `facilities_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facilities`
--

LOCK TABLES `facilities` WRITE;
/*!40000 ALTER TABLE `facilities` DISABLE KEYS */;
INSERT INTO `facilities` VALUES (1,'Computer Laboratory','computer-laboratory','Computer Laboratory 1','1746782830_aeb5704d131bca84df92311c9aff1efb.jpg',1,'2025-05-09 01:27:10','2025-05-09 01:27:10',NULL),(2,'Cashier','cashier',NULL,'1748104032_ddf5811fec53fa1f57322fcf391b1371.jpg',1,'2025-05-24 08:27:12','2025-05-24 08:57:34','2025-05-24 08:57:34'),(3,'School Clinic','school-clinic',NULL,'1748104057_939426dde3decd18ca4cf246a79ecf06.jpg',1,'2025-05-24 08:27:37','2025-05-24 08:57:32','2025-05-24 08:57:32'),(4,'School Gymnasium','school-gymnasium',NULL,'1748104076_b7160067578bcade94bcf625dd9c0d32.jpg',1,'2025-05-24 08:27:56','2025-05-24 08:57:30','2025-05-24 08:57:30'),(5,'School Canteen','school-canteen',NULL,'1748104095_42608fe82bab28b6bab88d17f577217b.jpg',1,'2025-05-24 08:28:15','2025-05-24 08:57:28','2025-05-24 08:57:28'),(6,'X-Ray Laboratory','x-ray-laboratory',NULL,'1748104125_f0bbd858a34ad2c192f048d61288d222.jpg',1,'2025-05-24 08:28:45','2025-05-24 08:57:26','2025-05-24 08:57:26'),(7,'Chemical Laboratory','chemical-laboratory',NULL,'1748104147_0d6c5209f719375a50908d2939d465cf.jpg',1,'2025-05-24 08:29:07','2025-05-24 08:57:24','2025-05-24 08:57:24'),(8,'Student Lounge','student-lounge',NULL,'1748104166_a5794d79c0a95924483b9cde20efd8a4.jpg',1,'2025-05-24 08:29:26','2025-05-24 08:57:22','2025-05-24 08:57:22'),(9,'School Registrar','school-registrar',NULL,'1748104181_8e6b0a916a41b841d76487cc5cd60cfd.jpg',1,'2025-05-24 08:29:41','2025-05-24 08:57:20','2025-05-24 08:57:20'),(10,'Fundamental Laboratory','fundamental-laboratory',NULL,'1748104212_07fde7e8eaf0248e5c85158135e6679c.jpg',1,'2025-05-24 08:30:12','2025-05-24 08:57:18','2025-05-24 08:57:18');
/*!40000 ALTER TABLE `facilities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facilities_photos`
--

DROP TABLE IF EXISTS `facilities_photos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `facilities_photos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `facility_id` bigint unsigned NOT NULL,
  `photo_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `facilities_photos_facility_id_foreign` (`facility_id`),
  CONSTRAINT `facilities_photos_facility_id_foreign` FOREIGN KEY (`facility_id`) REFERENCES `facilities` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facilities_photos`
--

LOCK TABLES `facilities_photos` WRITE;
/*!40000 ALTER TABLE `facilities_photos` DISABLE KEYS */;
INSERT INTO `facilities_photos` VALUES (1,1,'computer_laboratory_photos/681dca841aa2a.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(2,1,'computer_laboratory_photos/681dca841c73b.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(3,1,'computer_laboratory_photos/681dca841d3e7.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(4,1,'computer_laboratory_photos/681dca841e680.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(5,1,'computer_laboratory_photos/681dca841f6d2.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(6,1,'computer_laboratory_photos/681dca842079f.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(7,1,'computer_laboratory_photos/681dca84218af.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(8,1,'computer_laboratory_photos/681dca8422447.jpg','2025-05-09 01:27:32','2025-05-09 01:27:32',NULL),(9,10,'fundamental_laboratory_photos/6831f4d3b8072.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(10,10,'fundamental_laboratory_photos/6831f4d3b9e3f.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(11,10,'fundamental_laboratory_photos/6831f4d3bab67.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(12,10,'fundamental_laboratory_photos/6831f4d3bb9d4.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(13,10,'fundamental_laboratory_photos/6831f4d3bca1c.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(14,10,'fundamental_laboratory_photos/6831f4d3bd7d7.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(15,10,'fundamental_laboratory_photos/6831f4d3be5e9.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(16,10,'fundamental_laboratory_photos/6831f4d3bf2a9.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(17,10,'fundamental_laboratory_photos/6831f4d3bfd38.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(18,10,'fundamental_laboratory_photos/6831f4d3c0c53.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(19,10,'fundamental_laboratory_photos/6831f4d3c203b.jpg','2025-05-24 08:33:23','2025-05-24 08:57:18','2025-05-24 08:57:18'),(20,9,'school_registrar_photos/6831f4e9409b8.jpg','2025-05-24 08:33:45','2025-05-24 08:57:20','2025-05-24 08:57:20'),(21,9,'school_registrar_photos/6831f4e942fc4.jpg','2025-05-24 08:33:45','2025-05-24 08:57:20','2025-05-24 08:57:20'),(22,9,'school_registrar_photos/6831f4e9445ab.jpg','2025-05-24 08:33:45','2025-05-24 08:57:20','2025-05-24 08:57:20'),(23,8,'student_lounge_photos/6831f50a52fae.jpg','2025-05-24 08:34:18','2025-05-24 08:57:22','2025-05-24 08:57:22'),(24,8,'student_lounge_photos/6831f50a555a0.jpg','2025-05-24 08:34:18','2025-05-24 08:57:22','2025-05-24 08:57:22'),(25,8,'student_lounge_photos/6831f50a5630f.jpg','2025-05-24 08:34:18','2025-05-24 08:57:22','2025-05-24 08:57:22'),(26,7,'chemical_laboratory_photos/6831f519dc6f6.jpg','2025-05-24 08:34:33','2025-05-24 08:57:24','2025-05-24 08:57:24'),(27,7,'chemical_laboratory_photos/6831f519dea05.jpg','2025-05-24 08:34:33','2025-05-24 08:57:24','2025-05-24 08:57:24'),(28,7,'chemical_laboratory_photos/6831f519e0046.jpg','2025-05-24 08:34:33','2025-05-24 08:57:24','2025-05-24 08:57:24'),(29,7,'chemical_laboratory_photos/6831f519e15b9.jpg','2025-05-24 08:34:33','2025-05-24 08:57:24','2025-05-24 08:57:24'),(30,7,'chemical_laboratory_photos/6831f519e28bb.jpg','2025-05-24 08:34:33','2025-05-24 08:57:24','2025-05-24 08:57:24'),(31,6,'x-ray_laboratory_photos/6831f528d3037.jpg','2025-05-24 08:34:48','2025-05-24 08:57:26','2025-05-24 08:57:26'),(32,6,'x-ray_laboratory_photos/6831f528d7abd.jpg','2025-05-24 08:34:48','2025-05-24 08:57:26','2025-05-24 08:57:26'),(33,6,'x-ray_laboratory_photos/6831f528d8caf.jpg','2025-05-24 08:34:48','2025-05-24 08:57:26','2025-05-24 08:57:26'),(34,6,'x-ray_laboratory_photos/6831f528d9a9b.jpg','2025-05-24 08:34:48','2025-05-24 08:57:26','2025-05-24 08:57:26'),(35,5,'school_canteen_photos/6831f53e1d900.jpg','2025-05-24 08:35:10','2025-05-24 08:57:28','2025-05-24 08:57:28'),(36,5,'school_canteen_photos/6831f53e20eaf.jpg','2025-05-24 08:35:10','2025-05-24 08:57:28','2025-05-24 08:57:28'),(37,5,'school_canteen_photos/6831f53e22359.jpg','2025-05-24 08:35:10','2025-05-24 08:57:28','2025-05-24 08:57:28'),(38,5,'school_canteen_photos/6831f53e23a4b.jpg','2025-05-24 08:35:10','2025-05-24 08:57:28','2025-05-24 08:57:28'),(39,5,'school_canteen_photos/6831f53e24b2d.jpg','2025-05-24 08:35:10','2025-05-24 08:57:28','2025-05-24 08:57:28'),(40,4,'school_gymnasium_photos/6831f549cedf7.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(41,4,'school_gymnasium_photos/6831f549d04ee.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(42,4,'school_gymnasium_photos/6831f549d120a.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(43,4,'school_gymnasium_photos/6831f549d1d23.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(44,4,'school_gymnasium_photos/6831f549d29f1.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(45,4,'school_gymnasium_photos/6831f549d3665.jpg','2025-05-24 08:35:21','2025-05-24 08:57:30','2025-05-24 08:57:30'),(46,3,'school_clinic_photos/6831f555b8ec5.jpg','2025-05-24 08:35:33','2025-05-24 08:57:32','2025-05-24 08:57:32'),(47,3,'school_clinic_photos/6831f555ba518.jpg','2025-05-24 08:35:33','2025-05-24 08:57:32','2025-05-24 08:57:32'),(48,3,'school_clinic_photos/6831f555bb27a.jpg','2025-05-24 08:35:33','2025-05-24 08:57:32','2025-05-24 08:57:32'),(49,2,'cashier_photos/6831f5648f2f5.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34'),(50,2,'cashier_photos/6831f56490a37.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34'),(51,2,'cashier_photos/6831f56491684.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34'),(52,2,'cashier_photos/6831f564925b7.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34'),(53,2,'cashier_photos/6831f564938fa.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34'),(54,2,'cashier_photos/6831f56494513.jpg','2025-05-24 08:35:48','2025-05-24 08:57:34','2025-05-24 08:57:34');
/*!40000 ALTER TABLE `facilities_photos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `faculties`
--

DROP TABLE IF EXISTS `faculties`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `faculties` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `faculty_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `faculty_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profile_picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `faculties`
--

LOCK TABLES `faculties` WRITE;
/*!40000 ALTER TABLE `faculties` DISABLE KEYS */;
INSERT INTO `faculties` VALUES (2,'Nilou Jay Fernandez','Scit Coordinator','Bachelor of Science in Information Technology','1746866031_Screenshot 2025-04-15 124943.png','2025-05-09 18:54:27','2025-05-10 00:33:51'),(3,'Diane Nicole Guiritan','Full time faculty','Bachelor of Science in Information Technology','1747138543_Screenshot 2025-04-15 132828.png','2025-05-13 04:15:43','2025-05-13 04:15:43');
/*!40000 ALTER TABLE `faculties` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `failed_jobs`
--

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `general_settings`
--

DROP TABLE IF EXISTS `general_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `general_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `site_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `site_meta_description` text COLLATE utf8mb4_unicode_ci,
  `site_meta_keywords` text COLLATE utf8mb4_unicode_ci,
  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 `general_settings`
--

LOCK TABLES `general_settings` WRITE;
/*!40000 ALTER TABLE `general_settings` DISABLE KEYS */;
INSERT INTO `general_settings` VALUES (1,'Polytechnic College of Davao del Sur','digospcds@pcds.edu.ph',' (082)553 1662','logo_681b5b40042f7.png','favicon_681b5b414df6f.png',NULL,'2025-05-07 05:08:17','Polytechnic College of Davao del Sur offers top-notch tech-voc education with modern facilities, expert training, and real-world career readiness.','Polytechnic College of Davao del Sur, Davao del Sur polytechnic college, technical education Davao, vocational training Philippines, higher education Davao del Sur');
/*!40000 ALTER TABLE `general_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int NOT NULL,
  `pending_jobs` int NOT NULL,
  `failed_jobs` int NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci,
  `cancelled_at` int DEFAULT NULL,
  `created_at` int NOT NULL,
  `finished_at` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` 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,'2025_03_30_090420_create_user_social_links_table',1),(5,'2025_03_31_015958_create_general_settings_table',1),(6,'2025_04_01_024016_create_parent_categories_table',1),(7,'2025_04_01_024655_create_categories_table',1),(8,'2025_04_02_094136_create_posts_table',1),(9,'2025_04_13_035456_add_department_to_users_table',1),(10,'2025_04_13_065812_create_faculties_table',1),(11,'2025_04_25_013646_create_albums_table',2),(12,'2025_04_25_014920_create_photos_table',2),(13,'2025_05_01_115450_create_facilities_table',2),(14,'2025_05_01_115508_create_facilities_photos_table',2),(15,'2025_05_07_123110_create_offices_table',2),(16,'2025_05_07_125722_add_meta_fields_to_general_settings_table',3),(17,'2025_05_07_125931_add_meta_fields_to_general_settings_table',4),(18,'2025_05_07_130252_rename_meta_columns_in_general_settings_table',5),(19,'2025_05_07_131147_add_deleted_at_to_facilities_table',6),(20,'2025_05_07_131242_add_deleted_at_to_facilities_photos_table',6),(21,'2025_05_07_131408_add_deleted_at_to_facilities_photos_table',7),(22,'2025_05_08_115326_add_office_admin_email_to_office_departments_table',8),(23,'2025_05_15_083811_create_carousel_images_table',9),(24,'2025_05_15_120736_add_soft_deletes_to_carousel_images_table',10);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offices`
--

DROP TABLE IF EXISTS `offices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `offices` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offices`
--

LOCK TABLES `offices` WRITE;
/*!40000 ALTER TABLE `offices` DISABLE KEYS */;
INSERT INTO `offices` VALUES (1,'Associate Vice President for Academic Affairs','2025-05-07 05:21:29','2025-05-07 05:21:29'),(2,'Finance Department','2025-05-07 05:21:51','2025-05-07 05:21:51'),(3,'Human Resources Department','2025-05-07 05:22:03','2025-05-07 05:22:03'),(4,'Learning Resources and Information Center','2025-05-07 05:22:16','2025-05-07 05:22:16'),(5,'Office of Student Affairs','2025-05-07 05:22:29','2025-05-07 05:22:29'),(6,'Presidents Office','2025-05-07 05:23:02','2025-05-07 05:23:02'),(7,'Registrars Office','2025-05-07 05:23:16','2025-05-07 05:23:16'),(8,'Criminology Department','2025-05-07 05:23:27','2025-05-07 05:23:27'),(9,'Hospitality Management Department','2025-05-07 05:23:44','2025-05-07 05:23:44'),(10,'Information Technology Department','2025-05-07 05:23:55','2025-05-07 05:23:55'),(11,'Nursing Department','2025-05-07 05:24:07','2025-05-07 05:24:07'),(12,'Research and Development','2025-05-07 05:24:18','2025-05-07 05:24:18'),(13,'Radiologic Technology Department','2025-05-07 05:24:28','2025-05-07 05:24:28'),(14,'TESDA Department','2025-05-07 05:24:38','2025-05-07 05:24:38');
/*!40000 ALTER TABLE `offices` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `offices_departments`
--

DROP TABLE IF EXISTS `offices_departments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `offices_departments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `office_admin_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `office_admin_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_admin_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_admin_description` text COLLATE utf8mb4_unicode_ci,
  `office_department_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `offices_departments`
--

LOCK TABLES `offices_departments` WRITE;
/*!40000 ALTER TABLE `offices_departments` DISABLE KEYS */;
INSERT INTO `offices_departments` VALUES (1,'Shane Patrick Valdez','dladlkwa@gmail.com','1746774745_empty_pic.jpg','Finance Department Head',2,'2025-05-08 05:27:29','2025-05-08 23:24:40'),(2,'dwawa','wadawdw@gmail.com','1746711082_542a2013b50d656ed7dd634d3e582885.jpg','dawwadwdwa',12,'2025-05-08 05:31:22','2025-05-08 05:31:22'),(3,'dwadwadwa','dwawaddw@gmail.com','1746711110_542a2013b50d656ed7dd634d3e582885.jpg','dwdadwadwad',13,'2025-05-08 05:31:50','2025-05-08 05:31:50'),(4,'dwadwadaw','wdawad@mdawda','1746711404_542a2013b50d656ed7dd634d3e582885.jpg','dwadwadwadwda',9,'2025-05-08 05:36:44','2025-05-08 05:36:44'),(5,'Bernardo Tongcos','hr@pcds.edu.ph','1747138661_tongcos.png','Human Resources Head',3,'2025-05-13 04:17:41','2025-05-13 04:17:41');
/*!40000 ALTER TABLE `offices_departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parent_categories`
--

DROP TABLE IF EXISTS `parent_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `parent_categories` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ordering` int NOT NULL DEFAULT '1000',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parent_categories_slug_unique` (`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 `parent_categories`
--

LOCK TABLES `parent_categories` WRITE;
/*!40000 ALTER TABLE `parent_categories` DISABLE KEYS */;
INSERT INTO `parent_categories` VALUES (1,'Anouncements','anouncements',1000,'2025-05-08 23:33:53','2025-05-08 23:33:53'),(2,'Events','events',1000,'2025-05-08 23:34:04','2025-05-08 23:34:04'),(3,'News','news',1000,'2025-05-08 23:34:09','2025-05-08 23:34:09'),(4,'Article','article',1000,'2025-05-08 23:34:39','2025-05-09 00:49:07');
/*!40000 ALTER TABLE `parent_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `photos`
--

DROP TABLE IF EXISTS `photos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `photos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `album_id` bigint unsigned NOT NULL,
  `photo_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caption` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `photos_album_id_foreign` (`album_id`),
  CONSTRAINT `photos_album_id_foreign` FOREIGN KEY (`album_id`) REFERENCES `albums` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `photos`
--

LOCK TABLES `photos` WRITE;
/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
INSERT INTO `photos` VALUES (1,1,'scit_day_2025_photos/681ec16b1ebcd.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(2,1,'scit_day_2025_photos/681ec16b219e0.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(3,1,'scit_day_2025_photos/681ec16b22fca.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(4,1,'scit_day_2025_photos/681ec16b23f55.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(5,1,'scit_day_2025_photos/681ec16b24fa8.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(6,1,'scit_day_2025_photos/681ec16b2625f.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(7,1,'scit_day_2025_photos/681ec16b27375.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(8,1,'scit_day_2025_photos/681ec16b28345.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(9,1,'scit_day_2025_photos/681ec16b29442.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(10,1,'scit_day_2025_photos/681ec16b2a3fa.png',NULL,'2025-05-09 19:00:59','2025-05-24 08:21:39','2025-05-24 08:21:39'),(11,2,'it_day_photos/68233b0e3e49d.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(12,2,'it_day_photos/68233b0e4042f.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(13,2,'it_day_photos/68233b0e412f3.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(14,2,'it_day_photos/68233b0e422b4.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(15,2,'it_day_photos/68233b0e436a7.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(16,2,'it_day_photos/68233b0e44563.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(17,2,'it_day_photos/68233b0e45504.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(18,2,'it_day_photos/68233b0e46753.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(19,2,'it_day_photos/68233b0e478a0.png',NULL,'2025-05-13 04:29:02','2025-05-13 04:29:30','2025-05-13 04:29:30'),(20,2,'it_day_photos/68233b0e48776.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(21,2,'it_day_photos/68233b0e49583.png',NULL,'2025-05-13 04:29:02','2025-05-24 08:21:18','2025-05-24 08:21:18'),(22,3,'basic_education_culmination_2024_photos/6831f2849dfe0.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(23,3,'basic_education_culmination_2024_photos/6831f284a0960.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(24,3,'basic_education_culmination_2024_photos/6831f284a19c7.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(25,3,'basic_education_culmination_2024_photos/6831f284a2cae.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(26,3,'basic_education_culmination_2024_photos/6831f284a43a3.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(27,3,'basic_education_culmination_2024_photos/6831f284a576d.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(28,3,'basic_education_culmination_2024_photos/6831f284a6c0c.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(29,3,'basic_education_culmination_2024_photos/6831f284a7b0a.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(30,3,'basic_education_culmination_2024_photos/6831f284a8a13.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(31,3,'basic_education_culmination_2024_photos/6831f284a9706.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(32,3,'basic_education_culmination_2024_photos/6831f284aa5a3.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(33,3,'basic_education_culmination_2024_photos/6831f284ab415.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL),(34,3,'basic_education_culmination_2024_photos/6831f284ac116.jpg',NULL,'2025-05-24 08:23:32','2025-05-24 08:23:32',NULL);
/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `posts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `author_id` int NOT NULL,
  `category` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured_image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tags` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` text COLLATE utf8mb4_unicode_ci,
  `visibility` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
INSERT INTO `posts` VALUES (1,9,1,'Navigating the Nursing Maze: Reflections on PCDS\'s Midterm Examination','navigating-the-nursing-maze-reflections-on-pcds-s-midterm-examination','<p>As the dust settles from the intense week of examinations that took place from April 15th to April 19th, 2024, Bachelor of Science in Nursing (BSN) students at Polytechnic College of Davao del Sur (PCDS) reflect on their experiences and the significance of this crucial milestone in their academic journey.</p>\r\n\r\n<p>The midterm examination period marked the culmination of weeks of rigorous preparation. Students diligently reviewed course materials, engaged in group study sessions, and sought clarification from professors. These efforts were all in preparation for an assessment that tested not just memory, but the depth of their understanding of foundational nursing concepts and the application of theory to real-world clinical scenarios.</p>\r\n\r\n<p>Throughout the examination week, students were challenged with a diverse array of questions spanning anatomy and physiology, pharmacology, patient care, and healthcare ethics. The examinations were thoughtfully designed to assess not only factual knowledge but also critical thinking, clinical reasoning, and decision-making under pressure&mdash;skills essential in the field of nursing.</p>\r\n\r\n<p>Despite the palpable tension during this period, a strong sense of camaraderie emerged among students. They encouraged one another through early morning cram sessions and late-night reviews, showing remarkable dedication and resilience as they strived to excel academically.</p>\r\n\r\n<p>For many, the midterms served as a pivotal moment of self-reflection, providing an opportunity to evaluate personal strengths and areas needing improvement. It underscored the importance of continuous learning, self-discipline, and effective time management in navigating the demanding nursing curriculum.</p>\r\n\r\n<p>As the examination week concluded, students emerged with a renewed sense of purpose and determination. While the results are yet to be released, what stands clear is the unwavering commitment of BSN students at PCDS to uphold the highest standards of excellence in a noble profession rooted in healing, compassion, and service to others.</p>','1746780095_11d5a3c2b3b8d7e9f5b16a1375c5f311.jpg','Midterm Examination, BSN','PCDS Nursing, Midterm Examination, PCDS','As the examination week concluded, students emerged with a renewed sense of purpose and determination. While the results are yet to be released, what stands clear is the unwavering commitment of BSN students at PCDS to uphold the highest standards of excellence in a noble profession rooted in healing, compassion, and service to others.',1,'2024-05-02 16:33:15','2024-05-02 16:33:15'),(2,1,4,'3rd Recognition Day','3rd-recognition-day','<p>The Polytechnic College of Davao del Sur, Inc. recently celebrated its 3rd Recognition Day for the academic year 2023&ndash;2024 on May 6, 2024. The event was organized by the Basic Education Department under the supervision of Principal Rosa A. Zozobrado, MAED, MAECON, Ed. Proud parents and visitors graced the occasion, eagerly anticipating the moment their children&rsquo;s achievements would be acknowledged.</p>\r\n\r\n<p>As advisers from each grade level called the names of deserving students, the center stage came alive with applause and pride. During the program, Principal Zozobrado delivered a message of encouragement and insight, highlighting the essential role of continued parental support in each student&rsquo;s educational journey. She also announced that the distribution of report cards would take place on the same day, adding further meaning to the event by providing parents with a complete picture of their children&rsquo;s academic performance throughout the school year.</p>','1746781539_3c7a508be7b266cbdaec22852d761c98.jpg','3rd Recognition Day,Basic Education Department','PCDS, Recognition Day, 3rd','The Polytechnic College of Davao del Sur, Inc. recently celebrated its 3rd Recognition Day for the academic year 2023–2024 on May 6, 2024.',1,'2024-05-09 04:57:53','2024-05-09 04:57:53'),(3,1,4,'Ched 30th Anniversary','ched-30th-anniversary','<p>As we commemorate CHED&rsquo;s 30th Founding Anniversary and the 4th Higher Education Week, CHED RO XI is encouraging Higher Education Institutions (HEIs) to document their participation in the May 10, 2024 Kick-off Ceremony, along with related activities. These materials should ideally be shared on each institution&rsquo;s official website and social media pages. HEIs are also invited to join the celebration by posting an electronic banner and showcasing related activities on their official social media accounts from May 10 to 30, 2024.</p>\r\n\r\n<p>Additionally, HEI personnel are encouraged to use the CHED 30th Anniversary Facebook profile frame. Editable templates for the electronic banner and Facebook frame can be accessed via <a href=\"https://bit.ly/CHED-30thAnniv\" target=\"_new\">this link</a>. Participating institutions are requested to submit pictures and screenshots of their social media posts to chedro11@ched.gov.ph.</p>','1746781829_ad0bcd1fa3690425ce6d5da0411e28b3.jpg','Ched Anniversary','Ched Anniversary, PCDS Ched,','As we commemorate CHED’s 30th Founding Anniversary and the 4th Higher Education Week, CHED RO XI is encouraging Higher Education Institutions (HEIs) to document their participation in the May 10, 2024 Kick-off Ceremony, along with related activities.',1,'2024-05-09 01:23:38','2024-05-09 01:23:38'),(4,1,4,'Nursing\'s Mock Board Examination','nursing-s-mock-board-examination','<p>The Polytechnic College of Davao del Sur is currently holding a Mock Board Examination for its nursing students. Today, 101 graduating students will showcase their intellectual and clinical abilities as future medical frontliners, following in the footsteps of Florence Nightingale, the revered mother of modern nursing. As part of the school&#39;s enduring legacy to produce nurses who are both nationally and globally competitive, we are committed to ensuring that every graduating student is fully equipped to face the challenges of the profession while upholding the core values of competence, empathy, and resilience. Good luck and God bless, seniors!</p>','1746782279_16f3e3e99a7d912ed8c49a2b1ce87921.png','Mock Board Examination,BSN,Nursing','Mock Board, Nursing, PCDS Nursing, BSN','The Polytechnic College of Davao del Sur is currently holding a Mock Board Examination for its nursing students',1,'2024-05-19 01:56:10','2024-05-19 01:56:10'),(6,9,1,'A Nurse\'s Odyssey: Navigating the Pandemic\'s Challenges and Triumphs','a-nurse-s-odyssey-navigating-the-pandemic-s-challenges-and-triumphs','<p>Nothing the nurses&rsquo; exhausting shifts, inadequate personal protective equipment, lack of societal recognition, and struggles with mental health&mdash;these are just a few of the cries from our contemporary heroes. They greet patients daily with warm smiles and compassionate hearts, all while silencing their own trembling fears. Despite the nightmares carried from the frontlines, they continue to serve and care for both the present and future generations of the Filipino people and the world.</p>\r\n\r\n<p>Nurses and all health professionals have been on the front lines of the COVID-19 pandemic, which has led to over 82 million infections and more than 1.8 million deaths globally.</p>\r\n\r\n<p>They have risked their own lives to safeguard the lives of others. Yet, rising to the challenge of delivering care during such a crisis has been anything but easy.</p>\r\n\r\n<p>Filipino nurses, in particular, have struggled to continue providing patient care as many of their colleagues fall ill or leave the profession&mdash;one that was already critically understaffed before the pandemic. The situation is almost unbearable, yet many nurses choose to stay and persevere.</p>\r\n\r\n<p>Thus, even from a distance, we Filipinos must support our nurses by working together to help them lead and manage the path toward a new normal.</p>\r\n\r\n<p>As they strive to advance their profession, these nurses inspire countless others. They have shown that nursing, though demanding, is also deeply rewarding and deserving of the utmost respect. By continuing their mission despite the pandemic&rsquo;s hardships, they uphold the spirit of service and hope.</p>','1746783067_summer2020panaceacover_bannersize.jpg','Pandemic,BSN,Nursing','PCDS Nursing, Articles, Pandemic, Polytechnic','Nothing the nurses’ exhausting shifts, inadequate personal protective equipment, lack of societal recognition, and struggles with mental health—these are just a few of the cries from our contemporary heroes',1,'2024-04-24 14:53:38','2024-04-24 14:53:38'),(10,7,7,'Psychiatric Nursing','psychiatric-nursing','<p><strong>Psychiatric nursing</strong>, also known as <strong>mental health nursing</strong>, is a specialized and essential branch of the nursing profession dedicated to supporting individuals experiencing mental health conditions. As a cornerstone of the mental healthcare system, psychiatric nurses play a critical role in promoting recovery, dignity, and improved quality of life.</p>\r\n\r\n<p>These skilled professionals work across a range of settings&mdash;including hospitals, outpatient clinics, community mental health centers, and schools. Their responsibilities are extensive, encompassing:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Conducting comprehensive mental health assessments</p>\r\n	</li>\r\n	<li>\r\n	<p>Developing and implementing individualized care and treatment plans</p>\r\n	</li>\r\n	<li>\r\n	<p>Administering psychiatric medications</p>\r\n	</li>\r\n	<li>\r\n	<p>Providing counseling and psychotherapy</p>\r\n	</li>\r\n	<li>\r\n	<p>Educating patients and families about mental health and self-care</p>\r\n	</li>\r\n	<li>\r\n	<p>Advocating for the rights and needs of individuals with mental health challenges</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>Recently, <strong>BSN 3 Groups 7 and 10</strong> from the <strong>Polytechnic College of Davao del Sur</strong> completed an impressive <strong>10-day Related Learning Exposure</strong> at the <strong>Southern Philippines Medical Center Institute of Psychiatry and Behavioral Medicine</strong>. This hands-on experience allowed students to apply their theoretical knowledge in real-world psychiatric care settings, developing critical clinical and communication skills.</p>\r\n\r\n<p>? A heartfelt <strong>congratulations</strong> to the students for their professionalism, empathy, and dedication throughout the program. Your performance exemplified the core values of nursing&mdash;compassion, competence, and commitment.</p>\r\n\r\n<p>? Special recognition goes to our outstanding <strong>2nd Season Clinical Instructors</strong>, <strong>Ma&rsquo;am Glory Cayot Carrasco</strong> and <strong>Ma&rsquo;am Lyn Mar H. Bantay</strong>, for their unwavering support and expert guidance. Your mentorship has been instrumental in shaping the students&#39; understanding and appreciation of mental health care.</p>\r\n\r\n<p>We are proud of your achievements and look forward to seeing you carry this learning into your future nursing practice. ?</p>','1748101593_49788775dc296ba4a60fbd32f23c8934.jpg','Psychiatric ,Nursing,Mental','Psychiatric, Nursing','Psychiatric nursing, also known as mental health nursing, is a specialized and essential branch of the nursing profession dedicated to supporting individuals experiencing mental health conditions. As a cornerstone of the mental healthcare system, psychiatric nurses play a critical role in promoting recovery, dignity, and improved quality of life.',1,'2024-05-24 13:19:59','2024-05-24 13:19:59');
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
INSERT INTO `sessions` VALUES ('ofoBGP9NO0vROzCxkoUpC7tDuldmTv7CvrtFdOTi',1,'::1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiN1BXNVBoY2drTlpIaTdiSHIwMWtnS2dmU0d5VnlsTUlWcnk5M3g4OCI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJuZXciO2E6MDp7fXM6Mzoib2xkIjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9sb2NhbGhvc3QvYWRtaW4vZGFzaGJvYXJkIjt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1748105856);
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_social_links`
--

DROP TABLE IF EXISTS `user_social_links`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_social_links` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `facebook_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instagram_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_social_links_user_id_unique` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_social_links`
--

LOCK TABLES `user_social_links` WRITE;
/*!40000 ALTER TABLE `user_social_links` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_social_links` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'admin',
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `department` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_username_unique` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=15 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,'Administrator','admin@pcds.edu.ph','admin',NULL,'$2y$12$zMGhWMrPzI3eVMnCIxHDaO5bLOhXYEIQp0/1xxfGr7E2yl7c3R0Nq','IMG_682303680ed50.png',NULL,'superAdmin','active',NULL,'2025-05-07 04:45:44','2025-05-13 00:31:37',NULL),(2,'Christoper Villahermosa','bsit@pcds.edu.ph','bsithead',NULL,'$2y$12$u/87GO5lJ4L3ABhBmH3tjOpkDSM1IJDRIBUIVyAYGPiGNK/EOPHh2','IMG_682339080df5a.png','Office In - Charge','admin','active',NULL,'2025-05-07 04:47:18','2025-05-24 02:10:02','Bachelor of Science in Information Technology'),(3,'Marianne Rabino','bsrt@pcds.edu.ph','bsrthead',NULL,'$2y$12$LFJtdiD6Oxv6Adn2Osyzf.lA2lC2pWqIrW/kIAcvFpG1.7GKbAVYu',NULL,'Office In-Charge - BSRT','admin','active',NULL,'2025-05-07 04:47:53','2025-05-24 07:55:36','Bachelor of Science in Radiologic Technology'),(4,'Antonette M. Tabo-tabo','bshm@pcds.edu.ph','bshmhead',NULL,'$2y$12$wMXoCh8QB.qIYSCzRIqQmeHLyymtVhnkHNIGpA0xIbSNMZZ8rikSm',NULL,'Program Head - BSHM','admin','active',NULL,'2025-05-07 04:48:24','2025-05-24 07:53:17','Bachelor of Science in Hospitality Management'),(5,'BSC Head','bsc@pcds.edu.ph','bschead',NULL,'$2y$12$IVD3fXSGEXAF4dP/mNtUMe68o7/RIeL07FQ9nysO/2keSlU46XO1W',NULL,NULL,'admin','active',NULL,'2025-05-07 04:48:49','2025-05-07 04:48:49','Bachelor of Science in Criminology'),(7,'Morsid K. Tulao , RN, MAN, CHA, PhDM','bsn@pcds.edu.ph','bsnhead',NULL,'$2y$12$uLMB3MGgiYH5DKAwq4gRrOwRcoQEvPUKhwSTNoRTJdTMV4D3Wtlg.',NULL,'Program Head - BSN and Allied Programs','admin','active',NULL,'2025-05-07 04:49:42','2025-05-24 07:48:38','Bachelor of Science in Nursing'),(8,'Harold Cris D. Aleria, MM','dhrt@pcds.edu.ph','dhrthead',NULL,'$2y$12$QjxSfLkG0bwbzf8foBB5XO9v7aDIA6nLhk7MQoAPE.ifP.ENPqjau',NULL,'Program Head and Trainer - DHRT','admin','active',NULL,'2025-05-07 04:51:29','2025-05-24 07:56:51','Diploma in Hotel and Restaurant Technology'),(9,'Lady Jean Colata','ladyjean@gmail.com','ladyjeancolata',NULL,'$2y$12$wbMkZkBrpadcqsqebL4ROOVIExBbdK3V7WQiz9KshbYXBPuF9qzSa','IMG_681dbaa73a049.png',NULL,'author','active',NULL,'2025-05-07 04:52:23','2025-05-09 00:19:52','Diploma in Hotel and Restaurant Technology'),(11,'Macky Brigole','brigolemacky75@gmail.com','bsitmacky1',NULL,'$2y$12$0WswvBh1QyuYjYZzmG.S3OWu4ernDA4N4aCb3RY7Sirj/k3xtP7Aq',NULL,NULL,'author','pending',NULL,'2025-05-10 23:48:58','2025-05-10 23:48:58','Bachelor of Science in Information Technology'),(12,'Shane Patrick Valdez','shu@gmail.com','shupapi1',NULL,'$2y$12$vZ3zkP5AZmuhzJMi2XfZQeH2l.aYUSsq4dvsUs23WHidxh.z3amvG',NULL,NULL,'author','active',NULL,'2025-05-11 00:21:26','2025-05-11 00:21:26','Bachelor of Science in Information Technology'),(13,'Justine Baltazar','dawda@gmail.com','bscauthor',NULL,'$2y$12$0.Dli1pWZUUtVwFS5cChC.jvs3rr5/x9bg50svn4trPs9.Twq3mOK','1747118939_Screenshot 2024-03-02 183400.png',NULL,'author','active',NULL,'2025-05-11 05:06:18','2025-05-13 00:11:48','Bachelor of Science in Criminology'),(14,'Gerald Salva','gerald@gmail.com','bsitgerald1',NULL,'$2y$12$dKn/L6Aiz/LSxsFreR064OJyWnUuP/c0KJmVeDCF2pxp4kLWu01dO','IMG_68233a2c3f9c0.png',NULL,'author','active',NULL,'2025-05-13 04:23:04','2025-05-13 04:25:16','Bachelor of Science in Information Technology');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-05-25  1:01:26
