-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: 127.0.0.1 Database: krishna_cms -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `audit` -- DROP TABLE IF EXISTS `audit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `audit` ( `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`old_values`)), `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`new_values`)), `event` varchar(250) NOT NULL, `auditable_id` int(11) NOT NULL, `auditable_type` varchar(250) NOT NULL, `user_id` int(11) NOT NULL, `user_type` varchar(250) NOT NULL, `tags` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `user_agent` text DEFAULT NULL, `url` text DEFAULT NULL, `ip_address` varchar(250) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `audit` -- LOCK TABLES `audit` WRITE; /*!40000 ALTER TABLE `audit` DISABLE KEYS */; /*!40000 ALTER TABLE `audit` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `backups` -- DROP TABLE IF EXISTS `backups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `backups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `file_name` varchar(255) NOT NULL, `file_path` text NOT NULL, `backup_date` date NOT NULL, `created_by` varchar(50) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `backups` -- LOCK TABLES `backups` WRITE; /*!40000 ALTER TABLE `backups` DISABLE KEYS */; INSERT INTO `backups` VALUES (2,'backup_2026-01-24_11-04-41.sql','backups/database/backup_2026-01-24_11-04-41.sql','2026-01-24','1','2026-01-24 05:34:43'),(3,'backup_2026-01-24_11-07-11.sql','backups/database/backup_2026-01-24_11-07-11.sql','2026-01-24','1','2026-01-24 05:37:13'),(4,'backup_2026-01-24_11-21-35.sql','backups/database/backup_2026-01-24_11-21-35.sql','2026-01-24','1','2026-01-24 05:51:38'); /*!40000 ALTER TABLE `backups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) 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 `course_outcomes` -- DROP TABLE IF EXISTS `course_outcomes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `course_outcomes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `content` longtext NOT NULL, `subject` bigint(20) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `course_outcomes_subject_index` (`subject`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `course_outcomes` -- LOCK TABLES `course_outcomes` WRITE; /*!40000 ALTER TABLE `course_outcomes` DISABLE KEYS */; /*!40000 ALTER TABLE `course_outcomes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) NOT NULL, `email` varchar(191) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_achievements` -- DROP TABLE IF EXISTS `department_achievements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_achievements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `file_name` varchar(255) NOT NULL, `course` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_achievements` -- LOCK TABLES `department_achievements` WRITE; /*!40000 ALTER TABLE `department_achievements` DISABLE KEYS */; INSERT INTO `department_achievements` VALUES (1,'Best Academic Department Award','award_01.jpg',1,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(2,'Excellence in Research','award_02.jpg',2,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(3,'Top Placement Record','award_03.jpg',3,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(4,'Innovation in Teaching','award_04.jpg',4,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(5,'Outstanding Faculty Achievement','award_05.jpg',5,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(6,'Best Student Project','award_06.jpg',6,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(7,'Industry Collaboration Award','award_07.jpg',7,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(8,'National Conference Recognition','award_08.jpg',8,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(9,'International Journal Publication','award_09.jpg',9,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(10,'Community Service Excellence','award_10.jpg',10,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(11,'Green Campus Initiative Award','award_11.jpg',11,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(12,'Entrepreneurship Development Award','award_12.jpg',12,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(13,'Digital Transformation Achievement','award_13.jpg',13,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(14,'Best Laboratory Setup','award_14.jpg',14,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(15,'Sports Excellence Achievement','award_15.jpg',15,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(16,'Cultural Activities Recognition','award_16.jpg',16,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(17,'Alumni Engagement Excellence','award_17.jpg',17,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(18,'Research Grant Achievement','award_18.jpg',18,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(19,'Student Innovation Challenge Winner','award_19.jpg',19,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL),(20,'Academic Excellence Recognition','award_20.jpg',20,'2026-01-21 13:01:40','2026-01-21 13:01:40',NULL); /*!40000 ALTER TABLE `department_achievements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_activities` -- DROP TABLE IF EXISTS `department_activities`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `subject` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_activities` -- LOCK TABLES `department_activities` WRITE; /*!40000 ALTER TABLE `department_activities` DISABLE KEYS */; INSERT INTO `department_activities` VALUES (21,'Orientation Program',1,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(22,'Guest Lecture Series',2,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(23,'Chemistry Lab Workshop',3,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(24,'Biology Field Trip',4,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(25,'Coding Bootcamp',5,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(26,'IT Systems Training',6,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(27,'English Debate Competition',7,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(28,'History Exhibition',8,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(29,'Geography Mapping Activity',9,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(30,'Economics Case Study',10,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(31,'Political Science Seminar',11,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(32,'Sociology Research Project',12,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(33,'Psychology Workshop',13,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(34,'Philosophy Debate',14,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(35,'Business Plan Presentation',15,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(36,'Accounting Simulation',16,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(37,'Finance Quiz',17,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(38,'Marketing Campaign Exercise',18,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(39,'Management Skills Workshop',19,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL),(40,'Law Moot Court',20,'2026-01-21 13:18:39','2026-01-21 13:18:39',NULL); /*!40000 ALTER TABLE `department_activities` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_admissions` -- DROP TABLE IF EXISTS `department_admissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_admissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text NOT NULL, `subject` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_admissions` -- LOCK TABLES `department_admissions` WRITE; /*!40000 ALTER TABLE `department_admissions` DISABLE KEYS */; INSERT INTO `department_admissions` VALUES (1,'Undergraduate Admission',1,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(2,'Diploma Admission',2,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(3,'Undergraduate Admission',3,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(4,'Evening Program',4,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(5,'Undergraduate Admission',5,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(6,'Postgraduate Admission',6,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(7,'Postgraduate Admission',7,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(8,'Doctoral Admission',8,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(9,'Undergraduate Admission',9,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(10,'Evening Program',10,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(11,'Postgraduate Admission',11,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(12,'Doctoral Admission',12,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(13,'Diploma Admission',13,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(14,'Postgraduate Admission',14,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(15,'Undergraduate Admission',15,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(16,'Evening Program',16,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(17,'Doctoral Admission',17,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(18,'Postgraduate Admission',18,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(19,'Diploma Admission',19,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL),(20,'Undergraduate Admission',20,'2026-01-21 13:28:06','2026-01-21 13:28:06',NULL); /*!40000 ALTER TABLE `department_admissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_bos` -- DROP TABLE IF EXISTS `department_bos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_bos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `bos` varchar(255) NOT NULL, `subject` varchar(255) 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_bos` -- LOCK TABLES `department_bos` WRITE; /*!40000 ALTER TABLE `department_bos` DISABLE KEYS */; INSERT INTO `department_bos` VALUES (1,'BOS Chairman','1',NULL,NULL,NULL),(2,'BOS Member','2',NULL,NULL,NULL),(3,'BOS Member','3',NULL,NULL,NULL),(4,'BOS Member','4',NULL,NULL,NULL),(5,'BOS Member','5',NULL,NULL,NULL); /*!40000 ALTER TABLE `department_bos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_education` -- DROP TABLE IF EXISTS `department_education`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_education` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text NOT NULL, `subject` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_education` -- LOCK TABLES `department_education` WRITE; /*!40000 ALTER TABLE `department_education` DISABLE KEYS */; INSERT INTO `department_education` VALUES (1,'Undergraduate Program',1,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(2,'Diploma Program',2,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(3,'Undergraduate Program',3,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(4,'Evening Program',4,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(5,'Undergraduate Program',5,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(6,'Postgraduate Program',6,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(7,'Postgraduate Program',7,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(8,'Doctoral Program',8,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(9,'Undergraduate Program',9,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(10,'Evening Program',10,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(11,'Postgraduate Program',11,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(12,'Doctoral Program',12,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(13,'Diploma Program',13,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(14,'Postgraduate Program',14,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(15,'Undergraduate Program',15,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(16,'Evening Program',16,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(17,'Doctoral Program',17,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(18,'Postgraduate Program',18,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(19,'Diploma Program',19,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL),(20,'Undergraduate Program',20,'2026-01-21 13:36:02','2026-01-21 13:36:02',NULL); /*!40000 ALTER TABLE `department_education` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_employment` -- DROP TABLE IF EXISTS `department_employment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_employment` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text NOT NULL, `subject` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_employment` -- LOCK TABLES `department_employment` WRITE; /*!40000 ALTER TABLE `department_employment` DISABLE KEYS */; INSERT INTO `department_employment` VALUES (1,'Career Counseling',1,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(2,'Internship Placement',2,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(3,'Job Fair Participation',3,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(4,'Alumni Employment Support',4,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(5,'Skill Development Workshop',5,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(6,'Industry Networking',6,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(7,'Resume Building Session',7,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(8,'Interview Preparation',8,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(9,'Placement Guidance',9,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(10,'Career Mentorship',10,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(11,'Internship Placement',11,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(12,'Job Fair Participation',12,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(13,'Skill Development Workshop',13,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(14,'Industry Networking',14,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(15,'Resume Building Session',15,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(16,'Interview Preparation',16,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(17,'Career Mentorship',17,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(18,'Internship Placement',18,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(19,'Job Fair Participation',19,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL),(20,'Skill Development Workshop',20,'2026-01-21 13:41:22','2026-01-21 13:41:22',NULL); /*!40000 ALTER TABLE `department_employment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_internal` -- DROP TABLE IF EXISTS `department_internal`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_internal` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL 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 `department_internal` -- LOCK TABLES `department_internal` WRITE; /*!40000 ALTER TABLE `department_internal` DISABLE KEYS */; /*!40000 ALTER TABLE `department_internal` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_meeting` -- DROP TABLE IF EXISTS `department_meeting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_meeting` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL 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 `department_meeting` -- LOCK TABLES `department_meeting` WRITE; /*!40000 ALTER TABLE `department_meeting` DISABLE KEYS */; /*!40000 ALTER TABLE `department_meeting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_papers` -- DROP TABLE IF EXISTS `department_papers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_papers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `download` varchar(255) DEFAULT NULL, `subject` int(11) DEFAULT NULL, `course_type` varchar(255) DEFAULT NULL, `course_year` varchar(100) DEFAULT NULL, `semister` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_papers` -- LOCK TABLES `department_papers` WRITE; /*!40000 ALTER TABLE `department_papers` DISABLE KEYS */; INSERT INTO `department_papers` VALUES (1,'Calculus I Notes','papers/calculus1.pdf',1,'UG','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(2,'Physics Mechanics','papers/physics_mech.pdf',2,'UG','II','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(3,'Organic Chemistry Basics','papers/organic_chem.pdf',3,'UG','I','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(4,'Biology Lab Manual','papers/bio_lab.pdf',4,'Diploma','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(5,'Introduction to Programming','papers/intro_cs.pdf',5,'UG','II','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(6,'Networking Fundamentals','papers/network_it.pdf',6,'PG','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(7,'English Literature I','papers/english_lit1.pdf',7,'UG','I','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(8,'World History Notes','papers/history_notes.pdf',8,'Diploma','II','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(9,'Geography Map Skills','papers/geo_map.pdf',9,'UG','III','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(10,'Microeconomics','papers/microecon.pdf',10,'UG','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(11,'Political Theory','papers/pol_theory.pdf',11,'PG','II','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(12,'Sociology Research Methods','papers/soc_research.pdf',12,'PG','I','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(13,'Psychology Case Studies','papers/psy_case.pdf',13,'Doctoral','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(14,'Philosophy Ethics','papers/philosophy_ethics.pdf',14,'PG','II','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(15,'Business Management','papers/business_mgmt.pdf',15,'UG','III','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(16,'Financial Accounting','papers/fin_account.pdf',16,'PG','II','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(17,'Corporate Finance','papers/corp_fin.pdf',17,'Diploma','I','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(18,'Marketing Strategies','papers/marketing_strat.pdf',18,'PG','I','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(19,'Project Management','papers/project_mgmt.pdf',19,'Doctoral','II','II','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL),(20,'Law Case Studies','papers/law_cases.pdf',20,'PG','III','I','2026-01-22 05:58:02','2026-01-22 05:58:02',NULL); /*!40000 ALTER TABLE `department_papers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_practices` -- DROP TABLE IF EXISTS `department_practices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_practices` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_practices` -- LOCK TABLES `department_practices` WRITE; /*!40000 ALTER TABLE `department_practices` DISABLE KEYS */; INSERT INTO `department_practices` VALUES (1,'Laboratory Best Practices',3,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(2,'Field Work Safety Practices',4,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(3,'Industry Coding Standards',5,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(4,'Data Security and Privacy',6,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(5,'Research Ethics and Compliance',13,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(6,'Financial Reporting Standards',16,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(7,'Marketing Ethics and Branding',18,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(8,'Project Management Practices',19,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL),(9,'Legal Documentation Procedures',20,'2026-01-21 13:48:10','2026-01-21 13:48:10',NULL); /*!40000 ALTER TABLE `department_practices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_profile` -- DROP TABLE IF EXISTS `department_profile`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_profile` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_profile` -- LOCK TABLES `department_profile` WRITE; /*!40000 ALTER TABLE `department_profile` DISABLE KEYS */; INSERT INTO `department_profile` VALUES (1,'Department of Mathematics focuses on analytical and problem-solving skills',1,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(2,'Department of Physics emphasizes experimental and theoretical studies',2,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(3,'Department of Chemistry specializes in organic and inorganic research',3,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(4,'Department of Biology promotes life science research and field studies',4,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(5,'Department of Computer Science trains students in modern computing technologies',5,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(6,'Department of Information Technology focuses on systems and networking',6,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(7,'Department of English develops communication and literary skills',7,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(8,'Department of History preserves and analyzes historical knowledge',8,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(9,'Department of Geography specializes in spatial and environmental studies',9,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL),(10,'Department of Economics builds economic and analytical expertise',10,'2026-01-24 12:06:47','2026-01-24 12:06:47',NULL); /*!40000 ALTER TABLE `department_profile` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_programmes` -- DROP TABLE IF EXISTS `department_programmes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_programmes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `medium` varchar(100) DEFAULT NULL, `course_type` varchar(10) DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_programmes` -- LOCK TABLES `department_programmes` WRITE; /*!40000 ALTER TABLE `department_programmes` DISABLE KEYS */; INSERT INTO `department_programmes` VALUES (1,'BSc Mathematics','English','UG',1,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(2,'BSc Physics','English','UG',2,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(3,'BSc Chemistry','English','UG',3,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(4,'BSc Biology','Hindi','UG',4,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(5,'BSc Computer Science','English','UG',5,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(6,'BSc IT','English','UG',6,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(7,'BA English Literature','English','UG',7,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(8,'BA History','Hindi','UG',8,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(9,'BA Geography','Bilingual','UG',9,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(10,'BSc Economics','English','UG',10,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(11,'MA Political Science','English','PG',11,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(12,'MA Sociology','English','PG',12,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(13,'MA Psychology','English','PG',13,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(14,'MA Philosophy','Hindi','PG',14,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(15,'MBA Business Studies','English','PG',15,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(16,'MCom Accounting','English','PG',16,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(17,'MFA Finance','English','PG',17,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(18,'MBA Marketing','Bilingual','PG',18,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(19,'MBA Management','English','PG',19,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL),(20,'LLB Law','English','UG',20,'2026-01-22 06:56:28','2026-01-22 06:56:28',NULL); /*!40000 ALTER TABLE `department_programmes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_publications` -- DROP TABLE IF EXISTS `department_publications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_publications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_publications` -- LOCK TABLES `department_publications` WRITE; /*!40000 ALTER TABLE `department_publications` DISABLE KEYS */; INSERT INTO `department_publications` VALUES (1,'Research Paper on Calculus',1,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(2,'Physics Journal Publication',2,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(3,'Chemistry Conference Paper',3,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(4,'Biology Research Study',4,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(5,'Computer Science Case Study',5,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(6,'IT Systems Publication',6,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(7,'English Literature Paper',7,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(8,'History Research Paper',8,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(9,'Geography Field Study',9,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(10,'Economics Journal Article',10,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(11,'Political Science Research',11,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(12,'Sociology Survey Report',12,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(13,'Psychology Experimental Paper',13,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(14,'Philosophy Research Article',14,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(15,'Business Studies Case Study',15,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(16,'Accounting Research Paper',16,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(17,'Finance Journal Publication',17,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(18,'Marketing Research Study',18,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(19,'Management Case Study',19,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL),(20,'Law Research Article',20,'2026-01-21 13:53:30','2026-01-21 13:53:30',NULL); /*!40000 ALTER TABLE `department_publications` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_result` -- DROP TABLE IF EXISTS `department_result`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_result` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_result` -- LOCK TABLES `department_result` WRITE; /*!40000 ALTER TABLE `department_result` DISABLE KEYS */; INSERT INTO `department_result` VALUES (1,'Mathematics',1,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(2,'Physics',2,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(3,'Chemistry',3,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(4,'Biology',4,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(5,'Computer Science',5,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(6,'Information Technology',6,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(7,'English',7,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(8,'History',8,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(9,'Geography',9,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(10,'Economics',10,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(11,'Political Science',11,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(12,'Sociology',12,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(13,'Psychology',13,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(14,'Philosophy',14,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(15,'Business Studies',15,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(16,'Accounting',16,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(17,'Finance',17,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(18,'Marketing',18,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(19,'Management',19,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL),(20,'Law',20,'2026-01-21 13:57:06','2026-01-21 13:57:06',NULL); /*!40000 ALTER TABLE `department_result` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_seminors` -- DROP TABLE IF EXISTS `department_seminors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_seminors` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_seminors` -- LOCK TABLES `department_seminors` WRITE; /*!40000 ALTER TABLE `department_seminors` DISABLE KEYS */; INSERT INTO `department_seminors` VALUES (1,'Calculus Seminar','Seminar on advanced calculus concepts',1,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(2,'Physics Mechanics Seminar','Seminar covering classical mechanics topics',2,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(3,'Organic Chemistry Seminar','Seminar on organic reactions and lab techniques',3,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(4,'Biology Research Seminar','Seminar on recent findings in biology',4,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(5,'Programming Seminar','Seminar on software development and coding practices',5,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(6,'Networking Seminar','Seminar on IT infrastructure and networking',6,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(7,'English Literature Seminar','Seminar on literary analysis and critique',7,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(8,'History Seminar','Seminar on world history and historical methods',8,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(9,'Geography Seminar','Seminar on mapping, GIS, and geography research',9,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(10,'Economics Seminar','Seminar on micro and macroeconomic principles',10,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(11,'Political Science Seminar','Seminar on political theory and governance',11,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(12,'Sociology Seminar','Seminar on social research and society studies',12,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(13,'Psychology Seminar','Seminar on human behavior and mental health',13,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(14,'Philosophy Seminar','Seminar on ethics, logic, and philosophical thought',14,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(15,'Business Studies Seminar','Seminar on management and business strategies',15,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(16,'Accounting Seminar','Seminar on accounting standards and practices',16,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(17,'Finance Seminar','Seminar on corporate finance and investment strategies',17,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(18,'Marketing Seminar','Seminar on marketing techniques and market research',18,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(19,'Management Seminar','Seminar on leadership and management skills',19,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL),(20,'Law Seminar','Seminar on legal studies and case law analysis',20,'2026-01-22 04:47:10','2026-01-22 04:47:10',NULL); /*!40000 ALTER TABLE `department_seminors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_strength` -- DROP TABLE IF EXISTS `department_strength`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_strength` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_strength` -- LOCK TABLES `department_strength` WRITE; /*!40000 ALTER TABLE `department_strength` DISABLE KEYS */; INSERT INTO `department_strength` VALUES (1,'Strong analytical skills',1,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(2,'Well-equipped laboratories',2,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(3,'Advanced chemical labs',3,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(4,'Practical field exposure',4,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(5,'Modern programming curriculum',5,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(6,'Strong networking focus',6,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(7,'Effective communication skills',7,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(8,'Historical research strength',8,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(9,'GIS and mapping expertise',9,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(10,'Economic analysis skills',10,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(11,'Governance and policy knowledge',11,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(12,'Sociological research skills',12,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(13,'Applied psychology focus',13,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(14,'Ethical and logical thinking',14,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(15,'Business leadership skills',15,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(16,'Accounting standards expertise',16,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(17,'Financial market knowledge',17,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(18,'Strategic marketing skills',18,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(19,'Management and leadership skills',19,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL),(20,'Legal reasoning skills',20,'2026-01-22 05:03:39','2026-01-22 05:03:39',NULL); /*!40000 ALTER TABLE `department_strength` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_syllabus` -- DROP TABLE IF EXISTS `department_syllabus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_syllabus` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `download` varchar(255) DEFAULT NULL, `subject` int(11) DEFAULT NULL, `course_type` varchar(255) DEFAULT NULL, `course_year` varchar(100) DEFAULT NULL, `semister` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_syllabus` -- LOCK TABLES `department_syllabus` WRITE; /*!40000 ALTER TABLE `department_syllabus` DISABLE KEYS */; INSERT INTO `department_syllabus` VALUES (1,'Mathematics Syllabus','math_syllabus.pdf',1,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(2,'Physics Syllabus','physics_syllabus.pdf',2,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(3,'Chemistry Syllabus','chemistry_syllabus.pdf',3,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(4,'Biology Syllabus','biology_syllabus.pdf',4,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(5,'Computer Science Syllabus','cs_syllabus.pdf',5,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(6,'Information Technology Syllabus','it_syllabus.pdf',6,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(7,'English Syllabus','english_syllabus.pdf',7,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(8,'History Syllabus','history_syllabus.pdf',8,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(9,'Geography Syllabus','geography_syllabus.pdf',9,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(10,'Economics Syllabus','economics_syllabus.pdf',10,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(11,'Political Science Syllabus','political_syllabus.pdf',11,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(12,'Sociology Syllabus','sociology_syllabus.pdf',12,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(13,'Psychology Syllabus','psychology_syllabus.pdf',13,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(14,'Philosophy Syllabus','philosophy_syllabus.pdf',14,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(15,'Business Studies Syllabus','business_syllabus.pdf',15,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(16,'Accounting Syllabus','accounting_syllabus.pdf',16,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(17,'Finance Syllabus','finance_syllabus.pdf',17,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(18,'Marketing Syllabus','marketing_syllabus.pdf',18,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(19,'Management Syllabus','management_syllabus.pdf',19,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL),(20,'Law Syllabus','law_syllabus.pdf',20,'UG','I','I','2026-01-22 07:20:35','2026-01-22 07:20:35',NULL); /*!40000 ALTER TABLE `department_syllabus` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_timetable` -- DROP TABLE IF EXISTS `department_timetable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_timetable` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `download` varchar(255) DEFAULT NULL, `subject` int(11) DEFAULT NULL, `course_type` varchar(255) DEFAULT NULL, `course_year` varchar(255) DEFAULT NULL, `semister` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_timetable` -- LOCK TABLES `department_timetable` WRITE; /*!40000 ALTER TABLE `department_timetable` DISABLE KEYS */; INSERT INTO `department_timetable` VALUES (1,'Mathematics Timetable','math_tt.pdf',1,'UG','I','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(2,'Physics Timetable','physics_tt.pdf',2,'UG','I','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(3,'Chemistry Timetable','chemistry_tt.pdf',3,'UG','II','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(4,'Biology Timetable','biology_tt.pdf',4,'UG','II','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(5,'Computer Science Timetable','cs_tt.pdf',5,'UG','III','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(6,'IT Timetable','it_tt.pdf',6,'UG','III','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(7,'English Timetable','english_tt.pdf',7,'UG','I','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(8,'History Timetable','history_tt.pdf',8,'UG','II','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(9,'Geography Timetable','geography_tt.pdf',9,'UG','III','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(10,'Economics Timetable','economics_tt.pdf',10,'UG','III','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(11,'Political Science Timetable','political_tt.pdf',11,'PG','I','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(12,'Sociology Timetable','sociology_tt.pdf',12,'PG','I','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(13,'Psychology Timetable','psychology_tt.pdf',13,'PG','II','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(14,'Philosophy Timetable','philosophy_tt.pdf',14,'PG','II','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(15,'Business Studies Timetable','business_tt.pdf',15,'PG','I','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(16,'Accounting Timetable','accounting_tt.pdf',16,'PG','II','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(17,'Finance Timetable','finance_tt.pdf',17,'PG','I','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(18,'Marketing Timetable','marketing_tt.pdf',18,'PG','II','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(19,'Management Timetable','management_tt.pdf',19,'PG','II','II','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL),(20,'Law Timetable','law_tt.pdf',20,'PG','I','I','2026-01-22 07:30:26','2026-01-22 07:30:26',NULL); /*!40000 ALTER TABLE `department_timetable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_vision` -- DROP TABLE IF EXISTS `department_vision`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_vision` ( `id` int(11) NOT NULL AUTO_INCREMENT, `profile` text DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_vision` -- LOCK TABLES `department_vision` WRITE; /*!40000 ALTER TABLE `department_vision` DISABLE KEYS */; INSERT INTO `department_vision` VALUES (1,'To develop strong analytical and logical thinking skills','1','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(2,'To promote scientific inquiry and innovation','2','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(3,'To advance knowledge in chemical sciences and research','3','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(4,'To foster understanding of life sciences and biodiversity','4','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(5,'To create skilled professionals in computing and technology','5','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(6,'To excel in information systems and digital solutions','6','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(7,'To enhance communication and literary excellence','7','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(8,'To preserve and interpret historical knowledge','8','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(9,'To develop spatial analysis and environmental awareness','9','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(10,'To build economic insight for societal development','10','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(11,'To nurture responsible political awareness and leadership','11','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(12,'To understand social structures and human behavior','12','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(13,'To promote mental health awareness and research','13','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(14,'To encourage ethical thinking and philosophical inquiry','14','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(15,'To develop future business leaders and entrepreneurs','15','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(16,'To achieve excellence in accounting and auditing practices','16','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(17,'To build expertise in financial markets and management','17','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(18,'To foster creativity and strategic marketing skills','18','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(19,'To develop effective leadership and management abilities','19','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL),(20,'To promote justice, ethics, and legal awareness','20','2026-01-22 05:16:14','2026-01-22 05:16:14',NULL); /*!40000 ALTER TABLE `department_vision` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `department_workshops` -- DROP TABLE IF EXISTS `department_workshops`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `department_workshops` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `subject` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `department_workshops` -- LOCK TABLES `department_workshops` WRITE; /*!40000 ALTER TABLE `department_workshops` DISABLE KEYS */; INSERT INTO `department_workshops` VALUES (1,'Mathematics Workshop','Hands-on training in problem solving and logical reasoning',1,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(2,'Physics Workshop','Practical experiments and applications of physical laws',2,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(3,'Chemistry Workshop','Laboratory techniques and chemical analysis methods',3,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(4,'Biology Workshop','Field studies and modern biological research methods',4,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(5,'Computer Science Workshop','Programming practices and software development skills',5,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(6,'IT Workshop','Networking, cybersecurity, and system administration basics',6,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(7,'English Workshop','Communication skills and creative writing development',7,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(8,'History Workshop','Historical research methods and document analysis',8,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(9,'Geography Workshop','GIS tools and spatial data interpretation',9,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(10,'Economics Workshop','Economic modeling and real-world case analysis',10,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(11,'Political Science Workshop','Public policy analysis and governance studies',11,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(12,'Sociology Workshop','Social research techniques and data interpretation',12,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(13,'Psychology Workshop','Behavioral studies and psychological assessment tools',13,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(14,'Philosophy Workshop','Critical thinking and ethical reasoning practices',14,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(15,'Business Studies Workshop','Business strategy and entrepreneurial skills',15,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(16,'Accounting Workshop','Financial reporting and auditing practices',16,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(17,'Finance Workshop','Investment analysis and financial planning techniques',17,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(18,'Marketing Workshop','Branding, digital marketing, and consumer behavior',18,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(19,'Management Workshop','Leadership skills and organizational management',19,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL),(20,'Law Workshop','Legal procedures and case study discussions',20,'2026-01-22 05:33:47','2026-01-22 05:33:47',NULL); /*!40000 ALTER TABLE `department_workshops` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departments` -- DROP TABLE IF EXISTS `departments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `departments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(225) NOT NULL, `content` longtext NOT NULL, `background` varchar(50) NOT NULL, `sort_order` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departments` -- LOCK TABLES `departments` WRITE; /*!40000 ALTER TABLE `departments` DISABLE KEYS */; INSERT INTO `departments` VALUES (20,'Compliance','Ensures regulatory and policy compliance','bg-compliance',20,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(19,'Strategy','Handles business planning and organizational strategy','bg-strategy',19,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(18,'Internal Audit','Conducts internal audits and risk assessment','bg-audit',18,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(17,'Facilities','Manages building and facility maintenance','bg-facilities',17,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(2,'Finance','Manages company finances, budgeting, and accounting','bg-finance',2,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(1,'Human Resources','Handles recruitment, employee relations, and HR policies','bg-hr',1,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(3,'Information Technology','Maintains systems, software, and network infrastructure','bg-it',3,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(5,'Sales','Handles sales operations and customer acquisition','bg-sales',5,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(4,'Marketing','Responsible for promotions, branding, and campaigns','bg-marketing',4,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(7,'Administration','Oversees administrative and office operations','bg-admin',7,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(9,'Research and Development','Focuses on innovation and product development','bg-rnd',9,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(6,'Customer Support','Manages customer queries and service support','bg-support',6,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(8,'Operations','Manages daily operational activities','bg-operations',8,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(10,'Quality Assurance','Ensures product and service quality standards','bg-qa',10,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(11,'Procurement','Handles purchasing and vendor management','bg-procurement',11,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(12,'Logistics','Manages supply chain and delivery operations','bg-logistics',12,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(13,'Legal','Handles legal compliance and contracts','bg-legal',13,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(14,'Training','Provides employee training and skill development','bg-training',14,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(15,'Security','Ensures physical and digital security','bg-security',15,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL),(16,'Public Relations','Manages media relations and public image','bg-pr',16,'2026-01-21 10:39:45','2026-01-21 10:39:45',NULL); /*!40000 ALTER TABLE `departments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `faculty` -- DROP TABLE IF EXISTS `faculty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faculty` ( `id` int(11) NOT NULL AUTO_INCREMENT, `photo` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `staff_id` varchar(100) DEFAULT NULL, `mobile` varchar(50) DEFAULT NULL, `designation` varchar(255) DEFAULT NULL, `qualification` varchar(255) DEFAULT NULL, `experience` varchar(255) DEFAULT NULL, `biodata` varchar(255) DEFAULT NULL, `subject` int(11) DEFAULT NULL, `staff_type` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `faculty` -- LOCK TABLES `faculty` WRITE; /*!40000 ALTER TABLE `faculty` DISABLE KEYS */; INSERT INTO `faculty` VALUES (1,'fac1.jpg','Dr. Arun Kumar','STF001','9876543210','Professor','PhD Mathematics','15','Expert in applied mathematics',1,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(2,'fac2.jpg','Dr. Meena Devi','STF002','9876543211','Associate Professor','PhD Physics','12','Researcher in quantum physics',2,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(3,'fac3.jpg','Dr. Ravi Shankar','STF003','9876543212','Professor','PhD Chemistry','18','Specialist in organic chemistry',3,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(4,'fac4.jpg','Dr. Lakshmi Narayan','STF004','9876543213','Assistant Professor','PhD Biology','10','Focus on molecular biology',4,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(5,'fac5.jpg','Mr. Suresh Babu','STF005','9876543214','Assistant Professor','MTech Computer Science','8','Software development trainer',5,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(6,'fac6.jpg','Ms. Priya Nair','STF006','9876543215','Assistant Professor','MTech IT','7','Networking and security expert',6,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(7,'fac7.jpg','Mrs. Anitha Rao','STF007','9876543216','Associate Professor','MA English','14','Literature and linguistics specialist',7,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(8,'fac8.jpg','Dr. Vinod Kumar','STF008','9876543217','Professor','PhD History','20','Historian and researcher',8,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(9,'fac9.jpg','Mr. Ramesh Iyer','STF009','9876543218','Assistant Professor','MSc Geography','9','GIS and mapping expert',9,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(10,'fac10.jpg','Dr. Kavitha Menon','STF010','9876543219','Associate Professor','PhD Economics','13','Macroeconomic analyst',10,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(11,'fac11.jpg','Dr. Balaji Rao','STF011','9876543220','Professor','PhD Political Science','17','Public policy specialist',11,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(12,'fac12.jpg','Dr. Sunitha Paul','STF012','9876543221','Associate Professor','PhD Sociology','11','Social research expert',12,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(13,'fac13.jpg','Ms. Neha Sharma','STF013','9876543222','Assistant Professor','MSc Psychology','6','Behavioral studies expert',13,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(14,'fac14.jpg','Dr. Thomas George','STF014','9876543223','Professor','PhD Philosophy','19','Ethics and logic specialist',14,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(15,'fac15.jpg','Mr. Karthik R','STF015','9876543224','Assistant Professor','MBA','8','Business strategy trainer',15,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(16,'fac16.jpg','Ms. Deepa Srinivasan','STF016','9876543225','Associate Professor','MCom Accounting','12','Accounting and auditing expert',16,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(17,'fac17.jpg','Mr. Sanjay Malhotra','STF017','9876543226','Assistant Professor','MBA Finance','9','Investment and finance advisor',17,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(18,'fac18.jpg','Ms. Ritu Verma','STF018','9876543227','Assistant Professor','MBA Marketing','7','Digital marketing specialist',18,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(19,'fac19.jpg','Dr. Nikhil Joshi','STF019','9876543228','Associate Professor','PhD Management','14','Leadership and HR expert',19,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL),(20,'fac20.jpg','Dr. Abdul Rahman','STF020','9876543229','Professor','PhD Law','21','Constitutional law expert',20,'teaching-staff','2026-01-22 12:44:12','2026-01-22 12:44:12',NULL); /*!40000 ALTER TABLE `faculty` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gallery` -- DROP TABLE IF EXISTS `gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gallery_type` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `pid` bigint(20) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL 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 `gallery` -- LOCK TABLES `gallery` WRITE; /*!40000 ALTER TABLE `gallery` DISABLE KEYS */; /*!40000 ALTER TABLE `gallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `infrastructure` -- DROP TABLE IF EXISTS `infrastructure`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `infrastructure` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `priority` int(10) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `infrastructure` -- LOCK TABLES `infrastructure` WRITE; /*!40000 ALTER TABLE `infrastructure` DISABLE KEYS */; INSERT INTO `infrastructure` VALUES (1,'Library','Well-equipped library with books, journals, and digital resources','library',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(2,'Computer Lab','Modern computer lab with high-speed internet and latest software','computer-lab',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(3,'Science Laboratory','Advanced laboratories for physics, chemistry, and biology','science-laboratory',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(4,'Smart Classrooms','Digitally enabled classrooms with smart boards','smart-classrooms',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(5,'Auditorium','Spacious auditorium for seminars and cultural events','auditorium',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(6,'Conference Hall','Well-furnished hall for meetings and academic discussions','conference-hall',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(7,'Research Center','Dedicated research facilities for faculty and students','research-center',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(8,'Sports Complex','Indoor and outdoor sports facilities for students','sports-complex',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(9,'Gymnasium','Fully equipped gym for fitness and wellness','gymnasium',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(10,'Cafeteria','Hygienic cafeteria providing nutritious food','cafeteria',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(11,'Hostel','Comfortable hostel accommodation for students','hostel',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(12,'Medical Center','On-campus medical facility with first aid services','medical-center',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(13,'Seminar Hall','Seminar halls with audio-visual facilities','seminar-hall',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(14,'Language Lab','Language lab for communication skill development','language-lab',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(15,'Placement Cell','Career guidance and placement training center','placement-cell',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(16,'Transport Facility','College transport covering major routes','transport-facility',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(17,'Wi-Fi Campus','Fully Wi-Fi enabled campus','wifi-campus',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(18,'Innovation Hub','Startup and innovation incubation center','innovation-hub',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(19,'Examination Cell','Dedicated office for exam management','examination-cell',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL),(20,'Administrative Block','Central administrative and management offices','administrative-block',1,'2026-01-22 13:05:26','2026-01-22 13:05:26',NULL); /*!40000 ALTER TABLE `infrastructure` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inpress` -- DROP TABLE IF EXISTS `inpress`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `inpress` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inpress` -- LOCK TABLES `inpress` WRITE; /*!40000 ALTER TABLE `inpress` DISABLE KEYS */; INSERT INTO `inpress` VALUES (1,'Impressive Campus View','impress_1.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(2,'State-of-the-Art Infrastructure','impress_2.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(3,'Modern Classrooms','impress_3.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(4,'Advanced Computer Labs','impress_4.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(5,'Well-Equipped Library','impress_5.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(6,'Research and Innovation Center','impress_6.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(7,'Student Activity Zone','impress_7.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(8,'Cultural Events Celebration','impress_8.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(9,'Sports Excellence Facilities','impress_9.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(10,'National Level Seminars','impress_10.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(11,'Industry Interaction Programs','impress_11.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(12,'Placement Training Sessions','impress_12.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(13,'Digital Learning Environment','impress_13.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(14,'Green Eco-Friendly Campus','impress_14.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(15,'Auditorium and Events Hall','impress_15.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(16,'Student Research Projects','impress_16.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(17,'International Collaborations','impress_17.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(18,'Skill Development Workshops','impress_18.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(19,'Innovation and Startup Hub','impress_19.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL),(20,'Academic Excellence Awards','impress_20.jpg','2026-01-22 13:16:50','2026-01-22 13:16:50',NULL); /*!40000 ALTER TABLE `inpress` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `menu` -- DROP TABLE IF EXISTS `menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `menu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `menu_title` text NOT NULL, `icon` varchar(255) DEFAULT NULL, `menu_type` text NOT NULL COMMENT 'Logical page group like about, academics, research, feedback', `route` varchar(255) DEFAULT NULL, `target_type` enum('page','route','external') NOT NULL DEFAULT 'page', `open_in_new_tab` tinyint(1) DEFAULT 0, `priority` int(11) NOT NULL, `location` enum('header','top') NOT NULL DEFAULT 'header' COMMENT 'Menu placement: header or top navbar', `has_dropdown` tinyint(1) NOT NULL DEFAULT 0 COMMENT '1 = menu has dropdown, 0 = direct link', `oprtnl_flag` char(1) NOT NULL DEFAULT 'A', `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=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `menu` -- LOCK TABLES `menu` WRITE; /*!40000 ALTER TABLE `menu` DISABLE KEYS */; INSERT INTO `menu` VALUES (3,'Home',NULL,'home','welcome','route',0,1,'header',0,'A','2026-01-06 02:08:31','2026-01-10 06:16:50',NULL),(4,'About Us',NULL,'about',NULL,'page',0,2,'header',1,'A','2026-01-06 02:15:56','2026-01-06 02:15:56',NULL),(5,'Administration',NULL,'administration',NULL,'page',0,3,'header',1,'A','2026-01-06 02:39:47','2026-01-06 02:40:08',NULL),(6,'Academics',NULL,'academics',NULL,'page',0,4,'header',1,'A','2026-01-06 03:14:54','2026-01-06 03:14:54',NULL),(7,'Departments',NULL,'departments',NULL,'page',0,6,'header',1,'A','2026-01-06 03:16:49','2026-01-09 08:15:25',NULL),(8,'Reports',NULL,'reports',NULL,'page',0,6,'header',1,'A','2026-01-06 03:18:14','2026-01-10 07:07:54','2026-01-10 07:07:54'),(9,'Research',NULL,'research',NULL,'page',0,2,'top',1,'A','2026-01-06 03:18:57','2026-01-09 07:31:57',NULL),(10,'Infrastructure',NULL,'infrastructure',NULL,'page',0,1,'top',1,'A','2026-01-06 03:25:18','2026-01-09 07:31:39',NULL),(11,'Student Support',NULL,'student-support',NULL,'page',0,9,'header',1,'A','2026-01-06 03:26:16','2026-01-06 03:26:16',NULL),(12,'IQAC',NULL,'iqac',NULL,'page',0,10,'header',1,'A','2026-01-06 03:27:40','2026-01-06 03:27:40',NULL),(13,'Best Practices',NULL,'best-practices',NULL,'page',0,4,'top',1,'A','2026-01-06 03:53:50','2026-01-09 07:33:10',NULL),(14,'Examination Cell',NULL,'examinations',NULL,'page',0,8,'header',1,'A','2026-01-06 03:54:23','2026-01-09 08:13:57',NULL),(15,'RTI',NULL,'rti',NULL,'page',0,6,'top',0,'A','2026-01-06 03:55:25','2026-01-09 07:34:18',NULL),(16,'Gallery',NULL,'gallery',NULL,'page',0,13,'header',1,'A','2026-01-06 03:56:01','2026-01-09 08:19:50',NULL),(18,'Contact Us',NULL,'contact-us',NULL,'page',0,5,'top',0,'A','2026-01-06 03:59:43','2026-01-09 07:44:21','2026-01-09 07:44:21'),(19,'Test',NULL,'test',NULL,'page',0,11,'header',1,'A','2026-01-06 04:02:11','2026-01-06 04:08:22','2026-01-06 04:08:22'),(20,'Test',NULL,'test',NULL,'page',0,12,'header',1,'A','2026-01-06 07:57:45','2026-01-06 08:13:11','2026-01-06 08:13:11'),(21,'Top Menu Test',NULL,'top-menu-test','test','page',0,6,'top',0,'A','2026-01-06 22:27:40','2026-01-07 01:01:05','2026-01-07 01:01:05'),(22,'Test',NULL,'test','test','page',0,5,'top',0,'A','2026-01-07 01:30:17','2026-01-07 03:57:36','2026-01-07 03:57:36'),(23,'Key Indicators',NULL,'key-indicators',NULL,'page',0,3,'top',1,'A','2026-01-09 07:32:53','2026-01-09 07:32:53',NULL),(24,'E-content',NULL,'e-content',NULL,'page',0,5,'top',0,'A','2026-01-09 07:33:56','2026-01-09 07:33:56',NULL),(25,'Results',NULL,'result','/dr-pages/result/examinations','page',0,7,'top',0,'A','2026-01-09 07:37:33','2026-01-10 01:14:32',NULL),(26,'Screen Reader',NULL,'screen-reader','screen-reader','route',1,8,'top',0,'A','2026-01-09 07:38:07','2026-01-10 06:15:35',NULL),(27,'E-Content-1',NULL,'e-content-1',NULL,'page',0,9,'top',0,'A','2026-01-09 07:39:31','2026-01-09 07:39:31',NULL),(28,'Online Exam',NULL,'online-exam',NULL,'external',0,10,'top',1,'A','2026-01-09 07:40:01','2026-01-10 06:03:23',NULL),(29,'Exam Application',NULL,'exam-application','https://script.google.com/macros/s/AKfycbybnYYIiHMK0IJbdgWef1bRhmP7ac3vcNU1WCBi3tLKHXAU30ywmN_LE3Ch_CxMEqTj/exec','external',1,11,'top',0,'A','2026-01-09 07:42:08','2026-01-10 06:05:40',NULL),(30,'Outcomes',NULL,'outcomes',NULL,'page',0,5,'header',1,'A','2026-01-09 08:15:06','2026-01-09 08:15:06',NULL),(31,'LRC',NULL,'lrc',NULL,'page',0,7,'header',1,'A','2026-01-09 08:15:47','2026-01-09 08:15:47',NULL),(32,'NAAC',NULL,'naac',NULL,'page',0,11,'header',1,'A','2026-01-09 08:17:07','2026-01-09 08:17:07',NULL),(33,'Alumni',NULL,'alumni',NULL,'page',0,12,'header',1,'A','2026-01-09 08:19:18','2026-01-09 08:19:18',NULL); /*!40000 ALTER TABLE `menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migration` -- DROP TABLE IF EXISTS `migration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migration` ( `id` int(10) NOT NULL AUTO_INCREMENT, `table_name` varchar(255) DEFAULT NULL, `procedure_name` varchar(255) DEFAULT NULL, `source_db` varchar(64) NOT NULL, `target_db` varchar(64) NOT NULL, `status` enum('open','initiated','error') DEFAULT 'open', `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migration` -- LOCK TABLES `migration` WRITE; /*!40000 ALTER TABLE `migration` DISABLE KEYS */; INSERT INTO `migration` VALUES (1,'departments','migrate_departments','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 07:28:36'),(2,'subjects','migrate_subjects','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 06:34:09'),(3,'department_achievements','migrate_department_achievements','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 07:31:40'),(4,'department_activities','migrate_department_activities','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 07:48:39'),(5,'department_admissions','migrate_department_admissions','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 07:58:06'),(6,'department_education','migrate_department_education','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 08:06:02'),(7,'department_employment','migrate_department_employment','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 08:11:22'),(8,'department_practices','migrate_department_practices','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 08:18:10'),(9,'department_publications','migrate_department_publications','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 08:23:30'),(10,'department_result','migrate_department_result','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 08:27:06'),(11,'department_seminors','migrate_department_seminors','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 23:17:10'),(12,'department_strength','migrate_department_strength','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 23:33:39'),(13,'department_vision','migrate_department_vision','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-21 23:46:14'),(14,'department_workshops','migrate_department_workshops','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 00:03:47'),(15,'department_papers','migrate_department_papers','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 00:28:02'),(16,'department_programmes','migrate_department_programmes','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 01:26:28'),(17,'department_syllabus','migrate_department_syllabus','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 01:50:35'),(18,'department_timetable','migrate_department_timetable','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 02:00:26'),(19,'faculty','migrate_faculty','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 07:14:12'),(20,'infrastructure','migrate_infrastructure','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 07:35:26'),(21,'inpress','migrate_inpress','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 07:46:50'),(22,'news','migrate_news','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 07:54:49'),(23,'slides','migrate_slides','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 08:34:25'),(24,'videos','migrate_videos','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 08:52:29'),(25,'support_services','migrate_support_services','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-22 09:00:58'),(26,'ss_achievements','migrate_ss_achievements','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 01:25:03'),(27,'ss_documents ','migrate_ss_documents ','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 01:26:18'),(28,'settings','migrate_settings','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 02:13:51'),(29,'photo_gallery','migrate_photo_gallery','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 02:22:13'),(30,'pages','migrate_pages','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 04:30:40'),(31,'department_bos','migrate_department_bos','laravelcms','krishna_cms','initiated','2026-01-21 10:25:25','2026-01-24 06:32:55'),(32,'department_profile','migrate_department_profile','laravelcms','krishna_cms','initiated','2026-01-21 10:25:25','2026-01-24 06:36:47'),(33,'course_outcomes','migrate_course_outcomes','laravelcms','krishna_cms','open','2026-01-21 10:25:25','2026-01-24 06:36:47'); /*!40000 ALTER TABLE `migration` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(191) DEFAULT NULL, `batch` int(11) DEFAULT NULL, `deleted_at` timestamp NULL 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 `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `file` varchar(255) DEFAULT NULL, `news_type` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (1,'Course Set 1: Admission Open for 2024','news_1.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(2,'Course Set 2: Semester Exam Schedule Released','news_2.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(3,'Course Set 3: New Academic Calendar Announced','news_3.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(4,'Course Set 4: Workshop on Skill Development','news_4.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(5,'Course Set 5: National Level Seminar Conducted','news_5.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(6,'Course Set 6: Placement Training Program','news_6.pdf','news','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(7,'Course Set 7: Cultural Fest 2024 Highlights','news_7.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(8,'Course Set 8: Sports Meet Registration Open','news_8.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(9,'Course Set 9: Research Grant Opportunities','news_9.pdf','news','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(10,'Course Set 10: Guest Lecture by Industry Expert','news_10.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(11,'Course Set 11: Internal Assessment Schedule','news_11.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(12,'Course Set 12: College Ranked in Top Institutions','news_12.pdf','news','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(13,'Course Set 13: Student Exchange Program','news_13.pdf','news','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(14,'Course Set 14: Faculty Development Program','news_14.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(15,'Course Set 15: Online Certification Courses','news_15.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(16,'Course Set 16: Annual Day Celebration','news_16.pdf','event','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(17,'Course Set 17: Alumni Meet Announcement','news_17.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(18,'Course Set 18: Innovation and Startup Cell','news_18.pdf','news','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(19,'Course Set 19: Scholarship Applications Open','news_19.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL),(20,'Course Set 20: End Semester Results Published','news_20.pdf','announcement','2026-01-22 13:24:49','2026-01-22 13:24:49',NULL); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `page` -- DROP TABLE IF EXISTS `page`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `page` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `file` varchar(255) DEFAULT NULL, `page_type` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `update_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL 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 `page` -- LOCK TABLES `page` WRITE; /*!40000 ALTER TABLE `page` DISABLE KEYS */; /*!40000 ALTER TABLE `page` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pages` -- DROP TABLE IF EXISTS `pages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(225) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, `menu_group` varchar(100) DEFAULT NULL COMMENT 'Logical group under a menu (College Staff, Statutory Bodies, etc.)', `priority` int(10) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=274 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pages` -- LOCK TABLES `pages` WRITE; /*!40000 ALTER TABLE `pages` DISABLE KEYS */; INSERT INTO `pages` VALUES (3,'RTI','rti','rti','','2026-01-02 07:01:29','2026-01-02 07:01:29',NULL,NULL,NULL),(4,'Contact Us','contact-us','contact-us','','2026-01-02 08:11:23','2026-01-02 08:11:23',NULL,NULL,NULL),(95,'Student Survey','student-survey','student-survey','

\r\n Student Survey

','2026-01-05 22:44:02','2026-01-05 22:44:02',NULL,NULL,NULL),(96,'Student Feedback','student-feedback','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(97,'Teacher Feedback','teacher-feedback','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(98,'Alumni Feedback','alumni-feedback','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(99,'Employer Feedback','employer-feedback','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(100,'Parent Feedback','parent-feedback','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(101,'Feedback Analysis','feedback-analysis','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(102,'Action Taken Report','action-taken-report','feedback',NULL,'2026-01-06 04:58:33','2026-01-06 04:58:33',NULL,NULL,NULL),(103,'NIRF','nirf','nirf','

\r\n NIRF

','2026-01-05 23:41:45','2026-01-05 23:41:45',NULL,NULL,NULL),(104,'Lecturer Wise Time Table','lecturer-wise-time-table','time-table',NULL,'2026-01-06 05:14:30','2026-01-06 05:14:30',NULL,NULL,NULL),(105,'Program Wise Time Table','program-wise-time-table','time-table',NULL,'2026-01-06 05:14:30','2026-01-06 05:14:30',NULL,NULL,NULL),(106,'Institution\'s Master Time Table','institutions-master-time-table','time-table',NULL,'2026-01-06 05:14:30','2026-01-06 05:14:30',NULL,NULL,NULL),(107,'UGC-RUSA','ugc-rusa','ugc-rusa','

\r\n UGC-RUSA

','2026-01-05 23:51:06','2026-01-05 23:51:06',NULL,NULL,NULL),(108,'AISHE','aishe','aishe','

\r\n AISHE

','2026-01-05 23:56:52','2026-01-05 23:56:52',NULL,NULL,NULL),(109,'Sports','sports','sports','

\r\n Sports

','2026-01-05 23:57:33','2026-01-05 23:57:33',NULL,NULL,NULL),(110,'Student Corner','student-corner','student-corner','

\r\n Good

','2026-01-05 23:59:50','2026-01-05 23:59:50',NULL,NULL,NULL),(111,'Test-1','test-1','test','

\r\n Good

','2026-01-06 04:02:31','2026-01-06 04:08:05','2026-01-06 04:08:05',NULL,NULL),(112,'Test-2','test-2','test','

\r\n Tried

','2026-01-06 04:07:40','2026-01-06 04:08:12','2026-01-06 04:08:12',NULL,NULL),(113,'Test56','test56','top-menu-test','

\r\n Good

','2026-01-06 22:31:48','2026-01-07 00:48:24','2026-01-07 00:48:24','',NULL),(114,'Field Trips / Study Tours','field-trips-study-tours','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,1),(115,'Student Study / Field Projects','student-study-field-projects','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,2),(116,'Research Committee','research-committee','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,3),(117,'Code of Ethics for Research','code-of-ethics-for-research','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,4),(118,'Research Projects','research-projects','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,5),(119,'Research Guides','research-guides','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,6),(120,'Research Scholars','research-scholars','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,7),(121,'Publications','publications','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,8),(122,'Innovation and Incubation Centre Activities','innovation-and-incubation-centre-activities','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,9),(123,'Start-ups','start-ups','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,10),(124,'Conferences Organized','conferences-organized','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,11),(125,'MOUs / Linkages','mous-linkages','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,12),(126,'Consultancy','consultancy','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,13),(127,'Collaboration','collaboration','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,14),(128,'Research Policy','research-policy','research',NULL,'2026-01-10 06:00:10','2026-01-10 06:00:10',NULL,NULL,15),(129,'Seed Money Policy','seed-money-policy','research',NULL,'2026-01-10 00:32:04','2026-01-10 00:32:04',NULL,NULL,16),(130,'Teaching Learning Modalities','teaching-learning-modalities','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,1),(131,'Professional Development of Staff','professional-development-of-staff','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,2),(132,'Learning Outcomes','learning-outcomes','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,3),(133,'SSS','sss','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,4),(134,'Student Progression','student-progression','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,5),(135,'Student Participation and Activities','student-participation-and-activities','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,6),(136,'Institutional Values & Social Responsibilities','institutional-values-and-social-responsibilities','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,7),(137,'Best Practices','best-practices','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,8),(138,'Institutional Distinctiveness','institutional-distinctiveness','key-indicators',NULL,'2026-01-10 06:09:20','2026-01-10 06:09:20',NULL,NULL,9),(139,'Waste Management','waste-management','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,1),(140,'Rain Water Harvesting','rain-water-harvesting','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,2),(141,'Green Practices','green-practices','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,3),(142,'Differently-abled Friendliness','differently-abled-friendliness','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,4),(143,'Code Conduct Handbook','code-conduct-handbook','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,5),(144,'Best Practices of the Institution in NAAC Format','best-practices-of-the-institution-in-naac-format','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,6),(145,'National Symbols','national-symbols','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,7),(146,'Gender Sensitivity','gender-sensitivity','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,8),(147,'Fundamental Rights & Fundamental Duties','fundamental-rights-and-fundamental-duties','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,9),(148,'Professional Code of Govt of AP & UGC','professional-code-of-govt-of-ap-and-ugc','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,10),(149,'Other Practices','other-practices','best-practices',NULL,'2026-01-10 06:11:47','2026-01-10 06:11:47',NULL,NULL,11),(150,'E-content','e-content','e-content',NULL,'2026-01-10 01:10:24','2026-01-10 01:10:24',NULL,'',1),(151,'E-content-1','e-content-1','e-content-1',NULL,'2026-01-10 01:11:11','2026-01-10 01:11:11',NULL,'',1),(152,'Brief History','brief-history','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,1),(153,'Vision, Mission','vision-mission','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,2),(154,'Succession List','succession-list','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,3),(155,'Principal’s Desk','principals-desk','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,4),(156,'Best Teacher Awards','best-teacher-awards','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,5),(157,'Quality Policy','quality-policy','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,6),(158,'Code of Conduct','code-of-conduct','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,7),(159,'NAAC Certificate','naac-certificate','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,8),(160,'ISO Certificate','iso-certificate','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,9),(161,'UGC 2(f) & 12(b)','ugc-2f-12b','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,10),(162,'AISHE Certificate','aishe-certificate','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,11),(163,'University Affiliation Certificate','university-affiliation-certificate','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,12),(164,'CPE & Autonomy Certificates','cpe-autonomy-certificates','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,13),(165,'Institutional Development Plan (IDP)','institutional-development-plan-idp','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,14),(166,'Location and Campus Layout','location-and-campus-layout','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,15),(167,'Compliance Certificate','compliance-certificate','about',NULL,'2026-01-10 11:51:07','2026-01-10 11:51:07',NULL,NULL,16),(168,'Organization','organization','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,1),(169,'Office','office','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,2),(170,'Teaching Staff','teaching-staff','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,3),(171,'Non-Teaching Staff','non-teaching-staff','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,4),(172,'Statutory Bodies','statutory-bodies','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,5),(173,'Cadre Strength Details','cadre-strength-details','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,6),(174,'Governing Body','governing-body','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,7),(175,'Academic Council','academic-council','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,8),(176,'Finance','finance','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,9),(177,'Staff Council','staff-council','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,10),(178,'CPDC','cpdc','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,11),(179,'Committees','committees','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,12),(180,'Strategic Plan','strategic-plan','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,13),(181,'Standard Operating Procedure','standard-operating-procedure','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,14),(182,'News Letter','news-letter','administration',NULL,'2026-01-10 11:55:50','2026-01-10 11:55:50',NULL,NULL,15),(183,'UG Programmes','ug-programmes','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,'Programmes Offered',1),(184,'PG Programmes','pg-programmes','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,'Programmes Offered',2),(185,'Admissions','admissions','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,3),(186,'Academic Council','academic-council','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,4),(187,'Academic Audit Reports','academic-audit-reports','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,5),(188,'LMS','lms','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,6),(189,'Curriculum','curriculum','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,7),(190,'MOUs','mous','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,8),(191,'Academic Calendar','academic-calendar','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,9),(192,'Time Tables','time-tables','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,10),(193,'Value Added Certificate Courses','value-added-certificate-courses','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,11),(194,'Academic Audit','academic-audit','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,12),(195,'Academic Audit A.Y 2020-21','academic-audit-ay-2020-21','academics',NULL,'2026-01-10 12:03:41','2026-01-10 12:03:41',NULL,NULL,13),(196,'COs','cos','outcomes',NULL,'2026-01-10 12:09:41','2026-01-10 12:09:41',NULL,NULL,1),(197,'POs','pos','outcomes',NULL,'2026-01-10 12:09:41','2026-01-10 12:09:41',NULL,NULL,2),(198,'PSOs','psos','outcomes',NULL,'2026-01-10 12:09:41','2026-01-10 12:09:41',NULL,NULL,3),(199,'Attainment of COs','attainment-of-cos','outcomes',NULL,'2026-01-10 12:09:41','2026-01-10 12:09:41',NULL,NULL,4),(200,'Department Profile','department-profile','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,1),(201,'Staff','staff','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,2),(202,'SOUL Web OPAC','soul-web-opac','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,3),(203,'Resources','resources','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,4),(204,'Offline','offline','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,5),(205,'Online','online','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,6),(206,'e-Resources','e-resources','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,7),(207,'Events','events','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,8),(208,'LRC Press Clippings','lrc-press-clippings','lrc',NULL,'2026-01-12 04:35:11','2026-01-12 04:35:11',NULL,NULL,9),(209,'About Examination Cell','about-examination-cell','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,1),(210,'Notifications','notifications','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,2),(211,'Grievances Addressed','grievances-addressed','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,3),(212,'Previous Question Papers','previous-question-papers','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,4),(213,'Results','results','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,5),(214,'Functions of Examination Cell','functions-of-examination-cell','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,6),(215,'Circulars','circulars','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,7),(216,'Examination Timetables','examination-timetables','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,8),(217,'Examination Rules','examination-rules','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,9),(218,'CBCS System','cbcs-system','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,10),(219,'Evaluation System','evaluation-system','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,11),(220,'Credits & Grading','credits-and-grading','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,12),(221,'Student Portal','student-portal','examinations',NULL,'2026-01-12 04:44:58','2026-01-12 04:44:58',NULL,NULL,13),(222,'IQAC Structure','iqac-structure','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,1),(223,'Resolution','resolution','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,2),(224,'Criterion Wise Data','criterion-wise-data','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,3),(225,'About IQAC','about-iqac','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,4),(226,'Message','message','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,5),(227,'Vision & Mission','vision-and-mission','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,6),(228,'Functions of IQAC','functions-of-iqac','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,7),(229,'Composition','composition','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,8),(230,'Minutes','minutes','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,9),(231,'Action Taken Reports','action-taken-reports','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,10),(232,'AQAR','aqar','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,11),(233,'Feedback','feedback','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,12),(234,'Annual Reports','annual-reports','iqac',NULL,'2026-01-12 04:52:48','2026-01-12 04:52:48',NULL,NULL,13),(247,'NAAC','naac','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,NULL,1),(248,'SSR','ssr','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',2),(249,'Criterion-I','criterion-i','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',3),(250,'Criterion-II','criterion-ii','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',4),(251,'Criterion-III','criterion-iii','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',5),(252,'Criterion-IV','criterion-iv','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',6),(253,'Criterion-V','criterion-v','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',7),(254,'Criterion-VI','criterion-vi','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',8),(255,'Criterion-VII','criterion-vii','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',9),(256,'Extended Profile','extended-profile','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,'SSR & AQAR',10),(257,'Additional Info','additional-info','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,NULL,11),(258,'Previous NAAC Peer Team Report','previous-naac-peer-team-report','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,NULL,12),(259,'Others','others','naac',NULL,'2026-01-12 04:58:24','2026-01-12 04:58:24',NULL,NULL,13),(260,'Overview','overview','alumni',NULL,'2026-01-11 23:55:31','2026-01-11 23:55:31',NULL,'',1),(261,'Activities','activities','alumni',NULL,'2026-01-11 23:57:26','2026-01-11 23:57:26',NULL,'',3),(262,'Renowned Alumni','renowned-alumni','alumni',NULL,'2026-01-11 23:58:59','2026-01-11 23:58:59',NULL,'',4),(263,'Contribution','contribution','alumni',NULL,'2026-01-11 23:59:21','2026-01-11 23:59:21',NULL,'',5),(264,'Alumni Association Meeting Reports','alumni-association-meeting-reports','alumni',NULL,'2026-01-11 23:59:48','2026-01-11 23:59:48',NULL,'',6),(265,'Alumni Association Activities Reports','alumni-association-activities-reports','alumni',NULL,'2026-01-12 00:00:35','2026-01-12 00:00:35',NULL,'',7),(266,'About JKC','about-jkc','jkc',NULL,'2026-01-12 00:17:22','2026-01-12 00:17:22',NULL,'',1),(267,'Training Schedule','training-schedule','jkc',NULL,'2026-01-12 00:17:39','2026-01-12 00:17:39',NULL,'',2),(268,'JKC Curriculum','jkc-curriculum','jkc',NULL,'2026-01-12 00:17:57','2026-01-12 00:17:57',NULL,'',3),(269,'Circulers','circulers','jkc',NULL,'2026-01-12 00:23:36','2026-01-12 00:23:36',NULL,'',4),(270,'Campus Drive','campus-drive','jkc',NULL,'2026-01-12 00:23:55','2026-01-12 00:23:55',NULL,'',5),(271,'Placements','placements','jkc',NULL,'2026-01-12 00:24:09','2026-01-12 00:24:09',NULL,'',6),(272,'Reports','reports','jkc',NULL,'2026-01-12 00:24:30','2026-01-12 00:24:30',NULL,'',7); /*!40000 ALTER TABLE `pages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(191) DEFAULT NULL, `token` varchar(191) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `photo_gallery` -- DROP TABLE IF EXISTS `photo_gallery`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `photo_gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `photo_gallery` -- LOCK TABLES `photo_gallery` WRITE; /*!40000 ALTER TABLE `photo_gallery` DISABLE KEYS */; INSERT INTO `photo_gallery` VALUES (1,'Course Set 1 - Campus Overview','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(2,'Course Set 2 - Laboratory Sessions','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(3,'Course Set 3 - Library Collection','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(4,'Course Set 4 - Classroom Activities','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(5,'Course Set 5 - Sports Events','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(6,'Course Set 6 - Cultural Festival','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(7,'Course Set 7 - Workshop Highlights','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(8,'Course Set 8 - Guest Lectures','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(9,'Course Set 9 - Seminar Sessions','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(10,'Course Set 10 - Student Projects','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(11,'Course Set 11 - Alumni Meet','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(12,'Course Set 12 - Research Presentations','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(13,'Course Set 13 - Tech Fest','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(14,'Course Set 14 - Art Exhibition','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(15,'Course Set 15 - Field Trips','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(16,'Course Set 16 - Career Fair','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(17,'Course Set 17 - Faculty Meet','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(18,'Course Set 18 - Annual Function','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(19,'Course Set 19 - Conference Highlights','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL),(20,'Course Set 20 - Awards Ceremony','2026-01-24 07:52:13','2026-01-24 07:52:13',NULL); /*!40000 ALTER TABLE `photo_gallery` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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, 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 ('0ohY91wIU5C10ql15MvSxd0fixmnf59FuBScvXQA',NULL,'192.168.10.46','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiSmhMTjJmc0lrVm1UcVVWRHdvMFlCVFpNdnpvZHdOTTRxOW5aYmg0RSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzM6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAvZ2FsbGVyeSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1768290853),('3SN5258mjJAXBTvIenLNlnFSIRErsyqLPAzZ4nhS',NULL,'10.29.142.66','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYWFDUDJZNUNHSlppaERLM3ZaR05KVjRUZzZsQ0RnNzNrSDhxMGJYTCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzA6Imh0dHA6Ly8xMC4yOS4xNDIuOTk6ODAwMC9kci1wYWdlcy9yYWluLXdhdGVyLWhhcnZlc3RpbmcvYmVzdC1wcmFjdGljZXMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768291775),('e3dMkqPD9UYOSRJvqyJ1XjxSvgewfhwsuXb3HBjn',NULL,'192.168.10.34','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiYkpMVWhkSk5yakdCNWxhd0FhS2lDSkFyUnhNdGZySkFXck5BQ1VvNSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768293296),('g4kFn1RQcF0jr3LBre9TfecMs6kATYI7BxO6G1MZ',NULL,'192.168.10.37','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoia1UxMXdidnFvc1RwbXBNWEh0SzRoVndIdnJJTWtERmpVSU53bk1uWCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768293161),('H8zrf2O1eo70udSSGfNNu9Hh7LLkw64ND43t23kh',NULL,'192.168.10.42','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/29.0 Chrome/136.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoicmNvRkQwam9YMTJPaVVtQTQycDJLenNwSUVEZmdQdUlwckxSRG51ViI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAvZHItcGFnZXMvYWRkaXRpb25hbC1pbmZvL25hYWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768295224),('ILT4YL8qT7XSOYJmU8p2yzWZkK8cwpwAuCKhiSZ1',NULL,'192.168.10.34','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibGtYbk85dVJ1QTdueDJoSmFGbVZhc0pZQzRudUdGdzBCcUx1M005WSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTU6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAvZHItcGFnZXMvYWRkaXRpb25hbC1pbmZvL25hYWMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768293786),('JLJKTx2Y6I7OVX921VdlBJhFjPr6SdkgdoiO5DPa',NULL,'10.29.142.203','Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) SamsungBrowser/29.0 Chrome/136.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoibmh1SUpBamM4SThiN2RzbkJxclZ4R2x2RXp4RmtDODhVeUxsM2lTMiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjQ6Imh0dHA6Ly8xMC4yOS4xNDIuOTk6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1768292218),('NKFEnjpMvkTBYsXB7PsvcD3VdGGpvqZRfLjWehbu',NULL,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36 Edg/144.0.0.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiTld2UnJMaHpUQ29qTlp0dDE2em9iaERKV3NtT1FYc2RMN3Vva1B5MCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NzE6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9pbmZyYXN0cnVjdHVyZS1saXN0L21haW50ZW5hbmNlLW9mLWluZnJhc3RydWN0dXJlIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==',1768825806),('Nsv5thJjXhNx30v3xgZhavsZwaY5OBloLVaNmOdN',1,'127.0.0.1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiUmhyZjRIb2Z1SU93c1Z2NUhWcGVta2JyalhMdnZzcnZVb3U4dlN3biI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9kZXB0dmlzaW9uIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1768284782),('OT6wqsulr4hLcnK2gcZABLjlzCNYtY4OyDKUgaqL',NULL,'192.168.10.37','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36 Edg/143.0.0.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoibUxIMWVrZnlLWVVaMWJSWU9Mc2lhbThQUUpkdWo3dlRKSGl2amFzRiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjU6Imh0dHA6Ly8xOTIuMTY4LjEwLjM3OjgwMDAiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1768290154); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `fax` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `logo` varchar(255) DEFAULT NULL, `address` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'Content Management System','9586586958','748596','krishan@gmail.com','images/1767788837_logo.png','ABCD...','2026-01-01 05:07:31','2026-01-07 06:57:17',NULL); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `slides` -- DROP TABLE IF EXISTS `slides`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `slides` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` varchar(255) DEFAULT NULL, `sort_order` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `slides` -- LOCK TABLES `slides` WRITE; /*!40000 ALTER TABLE `slides` DISABLE KEYS */; INSERT INTO `slides` VALUES (3,'slides/1767244850_generated-image (6).png',1,'2025-12-31 23:50:50','2026-01-01 01:12:15',NULL),(4,'slides/1767672120_generated-image (7).png',2,'2026-01-05 22:32:01','2026-01-05 22:32:01',NULL),(5,'slide_1.jpg',1,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(6,'slide_2.jpg',2,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(7,'slide_3.jpg',3,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(8,'slide_4.jpg',4,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(9,'slide_5.jpg',5,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(10,'slide_6.jpg',6,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(11,'slide_7.jpg',7,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(12,'slide_8.jpg',8,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(13,'slide_9.jpg',9,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(14,'slide_10.jpg',10,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(15,'slide_11.jpg',11,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(16,'slide_12.jpg',12,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(17,'slide_13.jpg',13,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(18,'slide_14.jpg',14,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(19,'slide_15.jpg',15,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(20,'slide_16.jpg',16,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(21,'slide_17.jpg',17,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(22,'slide_18.jpg',18,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(23,'slide_19.jpg',19,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL),(24,'slide_20.jpg',20,'2026-01-22 14:04:25','2026-01-22 14:04:25',NULL); /*!40000 ALTER TABLE `slides` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ss_achievements` -- DROP TABLE IF EXISTS `ss_achievements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ss_achievements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `content` varchar(255) DEFAULT NULL, `services` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ss_achievements` -- LOCK TABLES `ss_achievements` WRITE; /*!40000 ALTER TABLE `ss_achievements` DISABLE KEYS */; INSERT INTO `ss_achievements` VALUES (33,'Outstanding Service Award','Recognized for excellence in providing outstanding services',1,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(34,'Customer Satisfaction Excellence','Achieved highest customer satisfaction ratings',2,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(35,'Innovation in Services','Implemented innovative solutions to enhance service delivery',3,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(36,'Teamwork Recognition','Awarded for exceptional teamwork in service projects',4,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(37,'Service Leadership Award','Demonstrated leadership in managing service operations',5,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(38,'Operational Excellence','Achieved operational targets with high efficiency',6,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(39,'Community Engagement Award','Engaged actively with community through service programs',7,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(40,'Process Improvement Recognition','Improved processes to deliver better services',8,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(41,'Technology Integration Award','Integrated technology effectively in service delivery',9,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(42,'Training Excellence','Provided excellent training programs for staff development',10,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(43,'Quality Service Award','Maintained high-quality standards in all service areas',11,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(44,'Innovative Project Recognition','Successfully completed innovative service projects',12,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(45,'Sustainability Award','Implemented sustainable practices in service operations',13,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(46,'Customer Care Recognition','Exceptional attention to customer needs and feedback',14,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(47,'Efficiency Improvement Award','Enhanced efficiency in service processes',15,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(48,'Excellence in Management','Managed service teams with outstanding results',16,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(49,'Service Expansion Achievement','Successfully expanded service offerings',17,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(50,'Problem Solving Award','Solved critical service-related challenges effectively',18,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(51,'Collaboration Excellence','Exemplary collaboration with other departments',19,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL),(52,'Service Innovation Leadership','Led innovative initiatives in service delivery',20,'2026-01-24 06:55:03','2026-01-24 06:55:03',NULL); /*!40000 ALTER TABLE `ss_achievements` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ss_documents` -- DROP TABLE IF EXISTS `ss_documents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ss_documents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(225) DEFAULT NULL, `download` varchar(225) DEFAULT NULL, `services` int(11) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ss_documents` -- LOCK TABLES `ss_documents` WRITE; /*!40000 ALTER TABLE `ss_documents` DISABLE KEYS */; INSERT INTO `ss_documents` VALUES (32,'Service Guidelines','service_guidelines_1.pdf',1,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(33,'Operational Manual','operational_manual_2.pdf',2,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(34,'Customer Feedback Report','customer_feedback_3.pdf',3,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(35,'Innovation Report','innovation_report_4.pdf',4,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(36,'Teamwork Best Practices','teamwork_best_5.pdf',5,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(37,'Service Leadership Notes','leadership_notes_6.pdf',6,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(38,'Community Engagement Plan','community_plan_7.pdf',7,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(39,'Process Improvement Guide','process_improvement_8.pdf',8,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(40,'Technology Integration Docs','tech_integration_9.pdf',9,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(41,'Training Manual','training_manual_10.pdf',10,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(42,'Quality Assurance Guidelines','quality_guidelines_11.pdf',11,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(43,'Project Innovation Report','project_innovation_12.pdf',12,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(44,'Sustainability Practices','sustainability_13.pdf',13,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(45,'Customer Care Handbook','customer_care_14.pdf',14,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(46,'Efficiency Improvement Docs','efficiency_15.pdf',15,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(47,'Management Excellence Report','management_excellence_16.pdf',16,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(48,'Service Expansion Plan','expansion_plan_17.pdf',17,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(49,'Problem Solving Guidelines','problem_solving_18.pdf',18,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(50,'Collaboration Reports','collaboration_19.pdf',19,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL),(51,'Innovation Leadership Docs','innovation_leadership_20.pdf',20,'2026-01-24 06:56:18','2026-01-24 06:56:18',NULL); /*!40000 ALTER TABLE `ss_documents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `static_content` -- DROP TABLE IF EXISTS `static_content`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `static_content` ( `id` int(10) NOT NULL AUTO_INCREMENT, `type` varchar(150) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `route` varchar(255) DEFAULT NULL, `priority` varchar(10) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `static_content` -- LOCK TABLES `static_content` WRITE; /*!40000 ALTER TABLE `static_content` DISABLE KEYS */; INSERT INTO `static_content` VALUES (1,'commissioner','Founder','images/1767792487_director.jpg','
\r\n Dr.V.S.Krishna
\r\n Vasireddy Sri Krishna shortly V.S.Krishna (8 October 1902 – 16 February 1961), was Vice Chancellor of Andhra University in Visakhapatnam, India
\r\n
\r\n In 1949, he was elected as Vice chancellor by the university senate. He held this position for 11 years till 1961
',NULL,'1','2026-01-07 07:58:07','2026-01-09 08:25:27',NULL),(2,'principal','Principal','images/1767793163_principal.jpg','

\r\n Dr.I.VIJAYA BABU  MA, M.Phil.,Ph.D.
\r\n With two decades of rich academic experience Dr. I. Vijaya Babu has been leading the Dr. V. S. Krishna Govt. Degree College (A)in its endeavour to excel in its educational advancement. He is the man who brought the institution the distinction of an academic hub with a fragrance of modern technology and traditional culture. 

',NULL,'1','2026-01-07 08:09:23','2026-01-09 08:26:02',NULL),(4,'quick-links','Home',NULL,NULL,'/','1','2026-01-07 22:17:20','2026-01-07 23:52:05',NULL),(5,'quick-links','About Us',NULL,NULL,'/dr-pages/history/about','2','2026-01-07 22:36:37','2026-01-07 23:52:14',NULL),(6,'quick-links','Administration',NULL,NULL,'/dr-pages/teaching-staff/administration','3','2026-01-07 22:39:01','2026-01-07 23:52:24',NULL),(7,'quick-links','Academics',NULL,NULL,'/dr-pages/academic-council/academics','4','2026-01-07 22:40:58','2026-01-07 23:52:36',NULL),(8,'quick-links','Report',NULL,NULL,'/dr-pages/reports-of-various-institutional-and-departmental-activities/reports','6','2026-01-07 22:44:37','2026-01-07 23:52:48',NULL),(9,'quick-links','Infrastructure',NULL,NULL,'/infrastructure-list/class-room','5','2026-01-07 22:46:29','2026-01-07 23:53:00',NULL),(10,'about','About',NULL,'

\r\n Welcome to Dr. V. S. Govt. Degree and PG College Govt. Degree College

\r\n

\r\n Dr. V. S. Govt. Degree and PG College Government Degree College, (then non-Autonomous) established in 1968, was inaugurated by his excellency Sri. Khandubhai K. Desai, Governor of Andhra Pradesh on 12th December 1968. The College was shifted in 1969 from the University Campus to Visakha valley school area which is 3 KMs away from the present premises. Owing to keen interest showed by District Collectors Sri C. Arjuna Rao IAS, and Sri K. V. Rao, IAS who helped in acquiring land, the college was shifted totally to its permanent premises in Maddilapalem in 1980-81.
\r\n
\r\n The college identified as Nodal Centre in the year 2005. The Research and Development Cell was established in the year 2010. The college was conferred autonomous status in the year 2011 and recognized as NRC in the year 2022. The college is offering both Under Graduate and Post Graduate Courses. Dr. V. S. Govt. Degree and PG College Government Degree College (A) is providing quality education for the urban and rural background students at an affordable cost. The college has strong technical team with expertise in Digital Teaching, Learning and Research.

',NULL,'1','2026-01-09 08:28:29','2026-01-09 08:28:29',NULL),(11,'course-link','Courses Offered Link','images/1768017840_generated-image (6).png',NULL,NULL,'1','2026-01-09 22:34:00','2026-01-09 22:34:00',NULL),(12,'screen_reader','Screen Reader','images/1768028805_Sample-pdf.pdf',NULL,NULL,'1','2026-01-10 01:36:45','2026-01-10 01:36:45',NULL); /*!40000 ALTER TABLE `static_content` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `status_lists` -- DROP TABLE IF EXISTS `status_lists`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `status_lists` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(191) DEFAULT 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=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `status_lists` -- LOCK TABLES `status_lists` WRITE; /*!40000 ALTER TABLE `status_lists` DISABLE KEYS */; INSERT INTO `status_lists` VALUES (1,'Active',NULL,NULL,NULL); /*!40000 ALTER TABLE `status_lists` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjects` -- DROP TABLE IF EXISTS `subjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subjects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subject` varchar(255) DEFAULT NULL, `banner` varchar(255) DEFAULT NULL, `department` bigint(20) DEFAULT NULL, `created_at` datetime DEFAULT current_timestamp(), `updated_at` datetime DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subjects` -- LOCK TABLES `subjects` WRITE; /*!40000 ALTER TABLE `subjects` DISABLE KEYS */; INSERT INTO `subjects` VALUES (1,'Mathematics','math_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(2,'Physics','physics_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(3,'Chemistry','chemistry_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(4,'Biology','biology_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(5,'Computer Science','cs_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(6,'Information Technology','it_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(7,'English','english_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(8,'History','history_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(9,'Geography','geography_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(10,'Economics','economics_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(11,'Political Science','political_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(12,'Sociology','sociology_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(13,'Psychology','psychology_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(14,'Philosophy','philosophy_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(15,'Business Studies','business_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(16,'Accounting','accounting_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(17,'Finance','finance_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(18,'Marketing','marketing_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(19,'Management','management_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL),(20,'Law','law_banner.jpg',NULL,'2026-01-21 17:34:09','2026-01-21 17:34:09',NULL); /*!40000 ALTER TABLE `subjects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `submenu` -- DROP TABLE IF EXISTS `submenu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `submenu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `menu_id` int(10) unsigned NOT NULL, `submenu_title` varchar(255) NOT NULL, `slug` varchar(255) DEFAULT NULL, `route` varchar(255) NOT NULL, `target_type` enum('page','route','external') NOT NULL DEFAULT 'page', `open_in_new_tab` tinyint(1) DEFAULT 0, `parent_id` int(10) unsigned DEFAULT NULL, `priority` int(11) NOT NULL, `oprtnl_flag` char(1) NOT NULL DEFAULT 'A', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `menu_id` (`menu_id`), CONSTRAINT `submenu_ibfk_1` FOREIGN KEY (`menu_id`) REFERENCES `menu` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `submenu` -- LOCK TABLES `submenu` WRITE; /*!40000 ALTER TABLE `submenu` DISABLE KEYS */; INSERT INTO `submenu` VALUES (3,28,'Faculty Zone','faculty-zone','https://www.w3schools.com/','external',1,NULL,1,'A','2026-01-09 08:03:39','2026-01-12 23:11:54',NULL),(4,28,'Student Zone','student-zone','https://www.w3schools.com/','external',1,NULL,2,'A','2026-01-09 08:04:02','2026-01-12 23:12:03',NULL),(5,16,'Image Gallery','image-gallery','gallery','route',0,NULL,1,'A','2026-01-09 08:20:44','2026-01-10 07:11:06',NULL),(6,16,'Press Clippings','press-clippings','press','route',0,NULL,2,'A','2026-01-09 08:21:24','2026-01-10 07:11:32',NULL),(7,16,'Video Gallery','video-gallery','video','route',0,NULL,3,'A','2026-01-09 08:22:42','2026-01-10 07:11:23',NULL),(8,33,'Overview','overview','/dr-pages/overview/alumni','route',0,NULL,1,'A','2026-01-11 23:38:02','2026-01-11 23:52:22',NULL),(9,33,'Registration','registration','https://www.w3schools.com/','external',1,NULL,2,'A','2026-01-11 23:56:42','2026-01-12 23:12:18',NULL),(10,33,'Activities','activities','/dr-pages/activities/alumni','page',0,NULL,3,'A','2026-01-12 00:01:57','2026-01-12 00:01:57',NULL),(11,33,'Renowned Alumni','renowned-alumni','/dr-pages/renowned-alumni/alumni','page',0,NULL,4,'A','2026-01-12 00:02:48','2026-01-12 00:02:48',NULL),(12,33,'Contribution','contribution','/dr-pages/contribution/alumni','page',0,NULL,4,'A','2026-01-12 00:03:24','2026-01-12 00:03:24',NULL),(13,33,'Alumni Association Meeting Reports','alumni-association-meeting-reports','/dr-pages/alumni-association-meeting-reports/alumni','page',0,NULL,6,'A','2026-01-12 00:04:16','2026-01-12 00:04:16',NULL),(14,33,'Alumni Association Activities Reports','alumni-association-activities-reports','/dr-pages/alumni-association-activities-reports/alumni','page',0,NULL,7,'A','2026-01-12 00:05:20','2026-01-12 00:05:20',NULL); /*!40000 ALTER TABLE `submenu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `support_services` -- DROP TABLE IF EXISTS `support_services`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `support_services` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `slug` varchar(255) DEFAULT NULL, `content` text DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `support_services` -- LOCK TABLES `support_services` WRITE; /*!40000 ALTER TABLE `support_services` DISABLE KEYS */; INSERT INTO `support_services` VALUES (1,'IT Support','it-support','Provides technical support for hardware and software issues.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(2,'Library Services','library-services','Offers access to books, journals, and digital resources.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(3,'Career Counseling','career-counseling','Helps students with career guidance and placement support.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(4,'Medical Services','medical-services','Provides health check-ups and medical assistance.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(5,'Hostel Facilities','hostel-facilities','Manages accommodation and hostel-related services.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(6,'Transportation','transportation','Provides transportation facilities for students and staff.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(7,'Student Counseling','student-counseling','Offers psychological support and counseling sessions.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(8,'Sports & Fitness','sports-fitness','Manages sports events, gym, and fitness activities.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(9,'Financial Aid','financial-aid','Provides scholarships, grants, and financial assistance.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(10,'Alumni Services','alumni-services','Coordinates alumni engagement and events.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(11,'Research Support','research-support','Provides assistance for academic and research projects.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(12,'IT Training','it-training','Offers workshops and training sessions on IT skills.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(13,'Community Engagement','community-engagement','Organizes social outreach and community programs.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(14,'Cultural Activities','cultural-activities','Arranges cultural programs and events.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(15,'Entrepreneurship Support','entrepreneurship-support','Guides students in startup and business development.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(16,'Laboratory Services','laboratory-services','Provides lab access and resources for experiments.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(17,'Academic Mentoring','academic-mentoring','Offers guidance and mentorship for academic growth.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(18,'Workshop Facilitation','workshop-facilitation','Organizes various educational workshops.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(19,'IT Infrastructure','it-infrastructure','Maintains network and computing resources.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL),(20,'Exam Support','exam-support','Provides assistance related to exams and assessments.','2026-01-22 14:30:58','2026-01-22 14:30:58',NULL); /*!40000 ALTER TABLE `support_services` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) DEFAULT NULL, `email` varchar(191) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `role` enum('SA','A','U') DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `email` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Super Admin','superadmin@gmail.com','$2y$12$9xVAnQ8fMirVNvIPzqIkNeyw5SJUHsVEvMjWGN.AR1VZZ6r.k/CIO','SA',NULL,NULL,NULL),(2,'Admin','admin@gmail.com','$2y$12$9xVAnQ8fMirVNvIPzqIkNeyw5SJUHsVEvMjWGN.AR1VZZ6r.k/CIO','A',NULL,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `videos` -- DROP TABLE IF EXISTS `videos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `videos` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(225) DEFAULT NULL, `video` varchar(225) DEFAULT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp(), `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `videos` -- LOCK TABLES `videos` WRITE; /*!40000 ALTER TABLE `videos` DISABLE KEYS */; INSERT INTO `videos` VALUES (1,'Campus Introduction Video','campus_intro.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(2,'Chairman Message','chairman_message.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(3,'Principal Address','principal_address.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(4,'Department Overview','department_overview.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(5,'Academic Facilities Tour','academic_facilities.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(6,'Library Walkthrough','library_tour.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(7,'Laboratory Demonstration','lab_demo.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(8,'Student Life on Campus','student_life.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(9,'Annual Day Highlights','annual_day.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(10,'Sports Meet Highlights','sports_meet.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(11,'Cultural Fest Celebration','cultural_fest.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(12,'Placement Training Program','placement_training.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(13,'Industry Interaction Session','industry_interaction.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(14,'Research Activities','research_activities.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(15,'Alumni Success Stories','alumni_success.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(16,'Workshop and Seminar','workshop_seminar.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(17,'Convocation Ceremony','convocation.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(18,'Innovation and Startup Cell','startup_cell.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(19,'Social Responsibility Activities','social_responsibility.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL),(20,'Virtual Campus Tour','virtual_campus_tour.mp4','2026-01-22 14:22:29','2026-01-22 14:22:29',NULL); /*!40000 ALTER TABLE `videos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `voucher_names` -- DROP TABLE IF EXISTS `voucher_names`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `voucher_names` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) DEFAULT NULL, `short_code` varchar(191) DEFAULT NULL, `period` int(11) DEFAULT NULL, `generate_voucher_qty` int(11) DEFAULT NULL, `total_voucher_qty` int(11) DEFAULT NULL, `expired_date` date DEFAULT NULL, `active` tinyint(1) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL 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 `voucher_names` -- LOCK TABLES `voucher_names` WRITE; /*!40000 ALTER TABLE `voucher_names` DISABLE KEYS */; /*!40000 ALTER TABLE `voucher_names` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vouchers` -- DROP TABLE IF EXISTS `vouchers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vouchers` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) unsigned DEFAULT NULL, `voucher_name_id` bigint(20) unsigned DEFAULT NULL, `code` varchar(191) DEFAULT NULL, `expired_date` date DEFAULT NULL, `status_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `customer_id` (`customer_id`), KEY `voucher_name_id` (`voucher_name_id`), KEY `status_id` (`status_id`), CONSTRAINT `vouchers_ibfk_1` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`), CONSTRAINT `vouchers_ibfk_2` FOREIGN KEY (`voucher_name_id`) REFERENCES `voucher_names` (`id`), CONSTRAINT `vouchers_ibfk_3` FOREIGN KEY (`status_id`) REFERENCES `status_lists` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vouchers` -- LOCK TABLES `vouchers` WRITE; /*!40000 ALTER TABLE `vouchers` DISABLE KEYS */; /*!40000 ALTER TABLE `vouchers` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'krishna_cms' -- -- -- Dumping routines for database 'krishna_cms' -- /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_course_outcomes` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_course_outcomes`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.course_outcomes ( title, content, subject ) SELECT da.title, da.content, s.id AS subject FROM ', p_source_db, '.course_outcomes da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_departments` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_departments`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.departments ( id, name, content, background, sort_order, created_at, updated_at, deleted_at ) SELECT id, name, content, background, sort_order, created_at, updated_at, NULL FROM ', p_source_db, '.departments' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_achievements` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_achievements`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_achievements ( title, file_name, course ) SELECT da.title, da.file_name, s.id AS course FROM ', p_source_db, '.department_achievements da JOIN ', p_source_db, '.subjects os ON os.id = da.course JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_activities` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_activities`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_activities ( title, subject ) SELECT da.title, s.id AS subject FROM ', p_source_db, '.department_activities da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_admissions` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_admissions`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_admissions ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_admissions da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_bos` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_bos`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_bos ( bos, subject ) SELECT da.bos, s.id AS subject FROM ', p_source_db, '.department_bos da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_education` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_education`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_education ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_education da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_employment` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_employment`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_employment ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_employment da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_papers` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_papers`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_papers ( title, download, subject, course_type, course_year, semister ) SELECT da.title, da.download, s.id AS subject, da.course_type, da.course_year, da.semister FROM ', p_source_db, '.department_papers da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_practices` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_practices`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_practices ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_practices da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_profile` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_profile`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_profile ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_profile da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_programmes` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_programmes`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_programmes ( name, medium, course_type, subject ) SELECT da.name, da.medium, da.course_type, s.id AS subject FROM ', p_source_db, '.department_programmes da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_publications` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_publications`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_publications ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_publications da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_result` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_result`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_result ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_result da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_seminors` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_seminors`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_seminors ( title, content, subject ) SELECT da.title, da.content, s.id AS subject FROM ', p_source_db, '.department_seminors da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_strength` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_strength`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_strength ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_strength da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_syllabus` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_syllabus`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_syllabus ( title, download, subject, course_type, course_year, semister ) SELECT da.title, da.download, s.id AS subject, ''UG'', ''I'', ''I'' FROM ', p_source_db, '.department_syllabus da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_timetable` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_timetable`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_timetable ( title, download, subject, course_type, course_year, semister ) SELECT da.title, da.download, s.id AS subject, da.course_type, da.course_year, da.semister FROM ', p_source_db, '.department_timetable da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_vision` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_vision`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_vision ( profile, subject ) SELECT da.profile, s.id AS subject FROM ', p_source_db, '.department_vision da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_department_workshops` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_department_workshops`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.department_workshops ( title, content, subject ) SELECT da.title, da.content, s.id AS subject FROM ', p_source_db, '.department_workshops da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_faculty` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_faculty`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.faculty ( photo, name, staff_id, mobile, designation, qualification, experience, biodata, subject, staff_type ) SELECT da.photo, da.name, da.staff_id, da.mobile, da.designation, da.qualification, da.experience, da.biodata, s.id AS subject, da.staff_type FROM ', p_source_db, '.faculty da JOIN ', p_source_db, '.subjects os ON os.id = da.subject JOIN ', p_target_db, '.subjects s ON s.subject = os.subject' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_infrastructure` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_infrastructure`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.infrastructure ( title, content, slug, priority ) SELECT da.title, da.content, da.slug, 1 AS priority FROM ', p_source_db, '.infrastructure da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_inpress` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_inpress`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.inpress ( title, image ) SELECT da.title, da.image FROM ', p_source_db, '.inpress da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_news` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_news`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.news ( title, file, news_type ) SELECT da.title, da.file, da.news_type FROM ', p_source_db, '.news da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_pages` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_pages`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.pages ( title, slug, type, content, menu_group, priority, created_at, updated_at ) SELECT da.title, da.slug, NULL, da.content, NULL, 1, NOW(), NOW() FROM ', p_source_db, '.pages da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_photo_gallery` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_photo_gallery`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.photo_gallery ( title ) SELECT da.title FROM ', p_source_db, '.photo_gallery da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_settings` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_settings`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.settings ( name, phone, fax, email, logo, address ) SELECT da.name, da.phone, da.fax, da.email, da.logo, da.address FROM ', p_source_db, '.settings da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_slides` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_slides`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.slides ( image, sort_order ) SELECT da.image, da.sort_order FROM ', p_source_db, '.slides da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_ss_achievements` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_ss_achievements`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.ss_achievements ( title, content, services ) SELECT da.title, da.content, ss.id AS services FROM ', p_source_db, '.ss_achievements da JOIN ', p_source_db, '.support_services os ON os.id = da.services JOIN ', p_target_db, '.support_services ss ON ss.slug = os.slug' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_ss_documents` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_ss_documents`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.ss_documents ( title, download, services ) SELECT da.title, da.download, ss.id AS services FROM ', p_source_db, '.ss_documents da JOIN ', p_source_db, '.support_services os ON os.id = da.services JOIN ', p_target_db, '.support_services ss ON ss.slug = os.slug' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_subjects` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_subjects`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.subjects ( subject, banner, department, deleted_at ) SELECT subject, banner, NULL AS department, NULL AS deleted_at FROM ', p_source_db, '.subjects' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_support_services` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_support_services`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.support_services ( name, slug, content ) SELECT da.name, da.slug, da.content FROM ', p_source_db, '.support_services da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = 'NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION' */ ; /*!50003 DROP PROCEDURE IF EXISTS `migrate_videos` */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8mb4 */ ; /*!50003 SET character_set_results = utf8mb4 */ ; /*!50003 SET collation_connection = utf8mb4_unicode_ci */ ; DELIMITER ;; CREATE DEFINER=`root`@`localhost` PROCEDURE `migrate_videos`( IN p_source_db VARCHAR(64), IN p_target_db VARCHAR(64) ) BEGIN DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN ROLLBACK; RESIGNAL; END; START TRANSACTION; SET @sql = CONCAT( 'INSERT INTO ', p_target_db, '.videos ( title, video ) SELECT da.title, da.video FROM ', p_source_db, '.videos da' ); PREPARE stmt FROM @sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; COMMIT; END ;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-01-24 18:11:17