Gecko [ signalhgwellness.com ]

Name	Size	Permission
.analytic	[ DIR ]	drwxrwxrwx
.cache	[ DIR ]	drwxrwxrwx
.cagefs	[ DIR ]	drwxrwxrwx
.caldav	[ DIR ]	drwx------
.cl.selector	[ DIR ]	drwxrwxrwx
.cpanel	[ DIR ]	drwx------
.htpasswds	[ DIR ]	drwxr-x---
.koality	[ DIR ]	drwxrwxrwx
.nc_plugin	[ DIR ]	drwxrwxrwx
.npm	[ DIR ]	drwxrwxrwx
.pkexec	[ DIR ]	drwxr-xr-x
.pm2	[ DIR ]	drwxrwxrwx
.razor	[ DIR ]	drwxrwxrwx
.softaculous	[ DIR ]	drwx--x--x
.spamassassin	[ DIR ]	drwxrwxrwx
.ssh	[ DIR ]	drwxrwxrwx
.subaccounts	[ DIR ]	drwxrwxrwx
.system-php	[ DIR ]	drwxrwxrwx
.trash	[ DIR ]	drwxrwxrwx
.well-known	[ DIR ]	drwxrwxrwx
.wp-cli	[ DIR ]	drwxrwxrwx
.wp-toolkit	[ DIR ]	drwxrwxrwx
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
_hc_backups	[ DIR ]	drwxr-xr-x
_scc_backups	[ DIR ]	drwxr-xr-x
access-logs	[ DIR ]	drwxr-x---
backups-2026-09-24	[ DIR ]	drwxr-xr-x
bdeworldwide.com	[ DIR ]	drwxr-x---
bin	[ DIR ]	drwxrwxrwx
bodybycs.com	[ DIR ]	drwxr-x---
cpanel3-skel	[ DIR ]	drwxrwxrwx
etc	[ DIR ]	drwxrwxrwx
findoutologist.info	[ DIR ]	drwxr-xr-x
hahnmarch.com	[ DIR ]	drwxrwxrwx
hahnmarch.org	[ DIR ]	drwxr-x---
healthcarestartup.io	[ DIR ]	drwxr-xr-x
homecareus.io	[ DIR ]	drwxr-x---
incident-2026-09-22	[ DIR ]	drwxr-xr-x
logs	[ DIR ]	drwxrwxrwx
mail	[ DIR ]	drwxrwxrwx
migration	[ DIR ]	drwxrwxrwx
newbk	[ DIR ]	drwxrwxrwx
panel	[ DIR ]	drwxrwxrwx
perl5	[ DIR ]	drwxrwxrwx
php	[ DIR ]	drwxrwxrwx
public_ftp	[ DIR ]	drwxrwxrwx
public_html	[ DIR ]	dr-xr-xr-x
quarantine-2026-09-24	[ DIR ]	drwxr-xr-x
quarantine-2026-09-25	[ DIR ]	drwxr-xr-x
signalcareercompass.io	[ DIR ]	drwxr-x---
signalhg4v2i.com	[ DIR ]	dr-xr-xr-x
signalhgai.org	[ DIR ]	drwxr-x---
signalhgclinton.com	[ DIR ]	drwxr-xr-x
signalhgdallas.com	[ DIR ]	drwxr-xr-x
signalhgdanecounty.com	[ DIR ]	drwxr-x---
signalhgfranchise.com	[ DIR ]	dr-xr-xr-x
signalhggeorgia.com	[ DIR ]	drwxr-xr-x
signalhgharrisonburg.com	[ DIR ]	drwxr-xr-x
signalhghawaii.com	[ DIR ]	drwxr-x---
signalhghr.com	[ DIR ]	drwxr-xr-x
signalhgnaples.com	[ DIR ]	dr-xr-xr-x
signalhgoakland.com	[ DIR ]	drwxr-x---
signalhgpenningtoncounty.com	[ DIR ]	drwxr-xr-x
signalhgraleigh.com	[ DIR ]	drwxr-xr-x
signalhgsandiego.com	[ DIR ]	dr-xr-xr-x
signalhgsd.com	[ DIR ]	drwxr-xr-x
signalhgsouthernwisconsin.com	[ DIR ]	drwxr-xr-x
signalhgsouthtexas.com	[ DIR ]	drwxr-xr-x
signalhgstlouis.com	[ DIR ]	dr-xr-xr-x
signalhgstore.com	[ DIR ]	drwxr-xr-x
signalhgtech.com	[ DIR ]	drwxrwxrwx
signalhguniversity.com	[ DIR ]	drwxr-xr-x
signalhguniversity.com.locked-...	[ DIR ]	drwxr-xr-x
signalhgvermont.com	[ DIR ]	drwxr-xr-x
signalhgwellness.com	[ DIR ]	dr-xr-xr-x
signalhgwestraleigh.com	[ DIR ]	drwxr-xr-x
signalhgwrightcounty.com	[ DIR ]	dr-xr-xr-x
signaltechcms.com	[ DIR ]	drwxr-x---
signaltechdabs.com	[ DIR ]	drwxr-x---
signaltechdas.com	[ DIR ]	dr-xr-xr-x
signaltechdcp.com	[ DIR ]	dr-xr-xr-x
signaltechdemo1.com	[ DIR ]	drwxr-x---
signaltechdemo10.com	[ DIR ]	drwxr-x---
signaltechdemo11.com	[ DIR ]	drwxr-x---
signaltechdemo12.com	[ DIR ]	drwxr-x---
signaltechdemo13.com	[ DIR ]	drwxr-x---
signaltechdemo14.com	[ DIR ]	drwxr-x---
signaltechdemo15.com	[ DIR ]	drwxr-x---
signaltechdemo16.com	[ DIR ]	drwxr-x---
signaltechdemo17.com	[ DIR ]	drwxr-xr-x
signaltechdemo18.com	[ DIR ]	drwxr-x---
signaltechdemo19.com	[ DIR ]	drwxr-xr-x
signaltechdemo2.com	[ DIR ]	drwxr-x---
signaltechdemo20.com	[ DIR ]	drwxr-x---
signaltechdemo21.com	[ DIR ]	drwxr-xr-x
signaltechdemo22.com	[ DIR ]	drwxr-x---
signaltechdemo3.com	[ DIR ]	drwxr-x---
signaltechdemo4.com	[ DIR ]	drwxr-x---
signaltechdemo5.com	[ DIR ]	drwxr-x---
signaltechdemo6.com	[ DIR ]	drwxr-x---
signaltechdemo7.com	[ DIR ]	drwxr-xr-x
signaltechdemo8.com	[ DIR ]	drwxr-x---
signaltechdemo9.com	[ DIR ]	drwxr-x---
signaltechdpms.com	[ DIR ]	dr-xr-xr-x
signaltechgdas.com	[ DIR ]	drwxr-x---
signaltechhcmsa.com	[ DIR ]	dr-xr-xr-x
signaltechhms.com	[ DIR ]	drwxr-x---
signaltechhms2.com	[ DIR ]	drwxr-x---
signaltechhs.com	[ DIR ]	dr-xr-xr-x
signaltechmsda.com	[ DIR ]	dr-xr-xr-x
signaltechpos.com	[ DIR ]	dr-xr-xr-x
signaltechpos.com.placeholder	[ DIR ]	drwxr-xr-x
signaltechs.io	[ DIR ]	drwxr-x---
signaltechs.io-backup-20260702...	[ DIR ]	drwxr-x---
signaltechs.tech	[ DIR ]	drwxrwxrwx
signaltechschedule.com	[ DIR ]	dr-xr-xr-x
signaltechschedule.com.placeho...	[ DIR ]	drwxr-xr-x
signaltechvethouse.com	[ DIR ]	drwxr-x---
signaltravel.net	[ DIR ]	drwxr-x---
softaculous_backups	[ DIR ]	drwx--x--x
ssl	[ DIR ]	drwxrwxrwx
talkingwithheroes.com	[ DIR ]	drwxr-xr-x
tmp	[ DIR ]	drwxrwxrwx
vets2industry.team	[ DIR ]	drwxr-x---
webnew	[ DIR ]	drwxrwxrwx
wordpress	[ DIR ]	drwxrwxrwx
wordpress-backups	[ DIR ]	drwxr-x---
.bash_history	143 B	-rw-------
.bash_logout	18 B	-rw-r--r--
.bash_profile	141 B	-rw-r--r--
.bashrc	376 B	-rw-r--r--
.ftpquota	21 B	-rw-------
.gemrc	139 B	-rw-r--r--
.htaccess	928 B	-rw-r--r--
.imunify_patch_id	106 B	-rw-rw----
.last.inodes	6.83 KB	-rw-r--r--
.lastlogin	593 B	-rw-------
.mad-root	0 B	-rw-r--r--
.myimunify_id	102 B	-rw-rw----
.pearrc	668 B	-rw-r--r--
.spamassassinboxenable	0 B	-rw-r--r--
.spamassassinenable	0 B	-rw-r--r--
.wget-hsts	215 B	-rw-r--r--
.wp-toolkit-identifier	684 B	-rw-------
20260923_044634.csv	15.33 MB	-rw-r--r--
app_direct.zip	4.13 MB	-rw-r--r--
app_launch.zip	305.09 MB	-rw-r--r--
doge.gif	0 B	-rw-r--r--
error_log	447 B	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
signaltechs-env-backup	1.52 KB	-rw-------
signgwph_university_backup_202...	81.21 KB	-rw-r--r--

Code Editor : signgwph_university_backup_2026-09-24_084148.sql

/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.27-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: signgwph_university
-- ------------------------------------------------------
-- Server version	10.6.27-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `announcements`
--

DROP TABLE IF EXISTS `announcements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `announcements` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `audience_type` varchar(255) NOT NULL DEFAULT 'all',
  `audience_id` bigint(20) unsigned DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `announcements_created_by_foreign` (`created_by`),
  CONSTRAINT `announcements_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `announcements`
--

LOCK TABLES `announcements` WRITE;
/*!40000 ALTER TABLE `announcements` DISABLE KEYS */;
INSERT INTO `announcements` VALUES (1,'Orientation week starts Sunday','All first-year students should attend department briefings at 10:00 AM.','all',NULL,'2026-07-11 00:57:36',NULL,NULL,'2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `announcements` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `assessment_components`
--

DROP TABLE IF EXISTS `assessment_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `assessment_components` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `class_section_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `max_score` smallint(5) unsigned NOT NULL DEFAULT 100,
  `weight` tinyint(3) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assessment_components_class_section_id_foreign` (`class_section_id`),
  CONSTRAINT `assessment_components_class_section_id_foreign` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assessment_components`
--

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

--
-- Table structure for table `assignments`
--

DROP TABLE IF EXISTS `assignments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `assignments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `class_section_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignments_class_section_id_foreign` (`class_section_id`),
  KEY `assignments_created_by_foreign` (`created_by`),
  CONSTRAINT `assignments_class_section_id_foreign` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `assignments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `assignments`
--

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

--
-- Table structure for table `attendances`
--

DROP TABLE IF EXISTS `attendances`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `enrollment_id` bigint(20) unsigned NOT NULL,
  `session_date` date NOT NULL,
  `status` varchar(255) NOT NULL,
  `marked_by` bigint(20) unsigned DEFAULT NULL,
  `marked_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attendances_enrollment_id_session_date_unique` (`enrollment_id`,`session_date`),
  KEY `attendances_marked_by_foreign` (`marked_by`),
  CONSTRAINT `attendances_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attendances_marked_by_foreign` FOREIGN KEY (`marked_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attendances`
--

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

--
-- Table structure for table `audit_logs`
--

DROP TABLE IF EXISTS `audit_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `audit_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `auditable_type` varchar(255) NOT NULL,
  `auditable_id` bigint(20) unsigned NOT NULL,
  `action` varchar(255) NOT NULL,
  `old_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`old_values`)),
  `new_values` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`new_values`)),
  `actor_id` bigint(20) unsigned DEFAULT NULL,
  `ip` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audit_logs_actor_id_foreign` (`actor_id`),
  KEY `audit_logs_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`),
  CONSTRAINT `audit_logs_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `audit_logs`
--

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

--
-- Table structure for table `book_issues`
--

DROP TABLE IF EXISTS `book_issues`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `book_issues` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `book_id` bigint(20) unsigned NOT NULL,
  `student_id` bigint(20) unsigned NOT NULL,
  `issued_at` date NOT NULL,
  `due_date` date NOT NULL,
  `returned_at` date DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'issued',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `book_issues_book_id_foreign` (`book_id`),
  KEY `book_issues_student_id_foreign` (`student_id`),
  KEY `book_issues_status_index` (`status`),
  CONSTRAINT `book_issues_book_id_foreign` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`) ON DELETE CASCADE,
  CONSTRAINT `book_issues_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `book_issues`
--

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

--
-- Table structure for table `books`
--

DROP TABLE IF EXISTS `books`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `books` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `author` varchar(255) DEFAULT NULL,
  `isbn` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `total_copies` smallint(5) unsigned NOT NULL DEFAULT 1,
  `available_copies` smallint(5) unsigned NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `books_isbn_unique` (`isbn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `books`
--

LOCK TABLES `books` WRITE;
/*!40000 ALTER TABLE `books` DISABLE KEYS */;
/*!40000 ALTER TABLE `books` 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 = utf8mb4 */;
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 `class_sections`
--

DROP TABLE IF EXISTS `class_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `class_sections` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `subject_id` bigint(20) unsigned NOT NULL,
  `teacher_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `room_id` bigint(20) unsigned NOT NULL,
  `section_code` varchar(255) NOT NULL,
  `schedule` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`schedule`)),
  `capacity` smallint(5) unsigned NOT NULL,
  `enrolled_count` smallint(5) unsigned NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'open',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_sections_subject_id_term_id_section_code_unique` (`subject_id`,`term_id`,`section_code`),
  KEY `class_sections_teacher_id_foreign` (`teacher_id`),
  KEY `class_sections_term_id_foreign` (`term_id`),
  KEY `class_sections_room_id_foreign` (`room_id`),
  KEY `class_sections_status_index` (`status`),
  CONSTRAINT `class_sections_room_id_foreign` FOREIGN KEY (`room_id`) REFERENCES `rooms` (`id`),
  CONSTRAINT `class_sections_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`),
  CONSTRAINT `class_sections_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`),
  CONSTRAINT `class_sections_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `class_sections`
--

LOCK TABLES `class_sections` WRITE;
/*!40000 ALTER TABLE `class_sections` DISABLE KEYS */;
INSERT INTO `class_sections` VALUES (1,1,1,1,1,'A','[{\"day\":\"SUN\",\"start\":\"09:00\",\"end\":\"10:30\"}]',50,0,'open','2026-07-11 00:57:36','2026-07-11 00:57:36'),(2,2,1,1,1,'A','[{\"day\":\"TUE\",\"start\":\"09:00\",\"end\":\"10:30\"}]',50,0,'open','2026-07-11 00:57:36','2026-07-11 00:57:36'),(3,3,1,1,1,'A','[{\"day\":\"TUE\",\"start\":\"09:00\",\"end\":\"10:30\"}]',50,0,'open','2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `class_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `course_orders`
--

DROP TABLE IF EXISTS `course_orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `course_orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `program_id` bigint(20) unsigned NOT NULL,
  `order_no` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'BDT',
  `payment_method` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `course_orders_order_no_unique` (`order_no`),
  KEY `course_orders_program_id_foreign` (`program_id`),
  KEY `course_orders_status_index` (`status`),
  CONSTRAINT `course_orders_program_id_foreign` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `course_orders`
--

LOCK TABLES `course_orders` WRITE;
/*!40000 ALTER TABLE `course_orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `course_orders` 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 = utf8mb4 */;
CREATE TABLE `departments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `head_teacher_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `departments_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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 (1,'Computer Science','CSE',NULL,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'Business Administration','BUS',NULL,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,'Administration','ADM',NULL,'2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `departments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `enrollments`
--

DROP TABLE IF EXISTS `enrollments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `enrollments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `class_section_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'enrolled',
  `final_score` decimal(5,2) DEFAULT NULL,
  `letter_grade` varchar(3) DEFAULT NULL,
  `grade_points` decimal(3,2) DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `enrolled_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `enrollments_student_id_class_section_id_unique` (`student_id`,`class_section_id`),
  KEY `enrollments_class_section_id_foreign` (`class_section_id`),
  KEY `enrollments_term_id_foreign` (`term_id`),
  KEY `enrollments_status_index` (`status`),
  CONSTRAINT `enrollments_class_section_id_foreign` FOREIGN KEY (`class_section_id`) REFERENCES `class_sections` (`id`) ON DELETE CASCADE,
  CONSTRAINT `enrollments_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  CONSTRAINT `enrollments_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `enrollments`
--

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

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

DROP TABLE IF EXISTS `events`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `events` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `starts_at` datetime NOT NULL,
  `ends_at` datetime DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `events_created_by_foreign` (`created_by`),
  CONSTRAINT `events_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

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

--
-- Table structure for table `faqs`
--

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `faqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) NOT NULL,
  `answer` text NOT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `faqs`
--

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

--
-- Table structure for table `fee_structures`
--

DROP TABLE IF EXISTS `fee_structures`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fee_structures` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `program_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `fee_type` varchar(255) NOT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `is_per_credit` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fee_structures_program_id_foreign` (`program_id`),
  KEY `fee_structures_term_id_foreign` (`term_id`),
  CONSTRAINT `fee_structures_program_id_foreign` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_structures_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fee_structures`
--

LOCK TABLES `fee_structures` WRITE;
/*!40000 ALTER TABLE `fee_structures` DISABLE KEYS */;
INSERT INTO `fee_structures` VALUES (1,1,1,'tuition',600000,1,'2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `fee_structures` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fee_waivers`
--

DROP TABLE IF EXISTS `fee_waivers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `fee_waivers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned DEFAULT NULL,
  `fee_type` varchar(255) DEFAULT NULL,
  `discount_type` varchar(255) NOT NULL DEFAULT 'percent',
  `amount` int(10) unsigned NOT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fee_waivers_student_id_foreign` (`student_id`),
  KEY `fee_waivers_term_id_foreign` (`term_id`),
  KEY `fee_waivers_created_by_foreign` (`created_by`),
  CONSTRAINT `fee_waivers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `fee_waivers_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fee_waivers_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fee_waivers`
--

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

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

DROP TABLE IF EXISTS `galleries`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `galleries` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) DEFAULT NULL,
  `album` varchar(255) DEFAULT NULL,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `galleries`
--

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

--
-- Table structure for table `grades`
--

DROP TABLE IF EXISTS `grades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `grades` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `enrollment_id` bigint(20) unsigned NOT NULL,
  `assessment_component_id` bigint(20) unsigned NOT NULL,
  `score` decimal(5,2) NOT NULL,
  `entered_by` bigint(20) unsigned DEFAULT NULL,
  `entered_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `grades_enrollment_id_assessment_component_id_unique` (`enrollment_id`,`assessment_component_id`),
  KEY `grades_assessment_component_id_foreign` (`assessment_component_id`),
  KEY `grades_entered_by_foreign` (`entered_by`),
  CONSTRAINT `grades_assessment_component_id_foreign` FOREIGN KEY (`assessment_component_id`) REFERENCES `assessment_components` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grades_entered_by_foreign` FOREIGN KEY (`entered_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `grades`
--

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

--
-- Table structure for table `grading_scales`
--

DROP TABLE IF EXISTS `grading_scales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `grading_scales` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `min_score` decimal(5,2) NOT NULL,
  `max_score` decimal(5,2) NOT NULL,
  `letter_grade` varchar(3) NOT NULL,
  `grade_points` decimal(3,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `grading_scales`
--

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

--
-- Table structure for table `home_features`
--

DROP TABLE IF EXISTS `home_features`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `home_features` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `theme` varchar(255) NOT NULL DEFAULT 'teal',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home_features`
--

LOCK TABLES `home_features` WRITE;
/*!40000 ALTER TABLE `home_features` DISABLE KEYS */;
INSERT INTO `home_features` VALUES (1,'Education Services','Admission, students, classes, grades, attendance, and transcripts in one place.','teal',1,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'International Hubs','Public web, events, gallery, news, applicant tracking, and program discovery.','coral',2,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,'Bachelor\'s and Master\'s','Course catalog, teacher assignment, fee collection, and academic reporting.','teal',3,1,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `home_features` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `home_modules`
--

DROP TABLE IF EXISTS `home_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `home_modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `eyebrow` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `button_text` varchar(255) NOT NULL,
  `button_link` varchar(255) NOT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `home_modules`
--

LOCK TABLES `home_modules` WRITE;
/*!40000 ALTER TABLE `home_modules` DISABLE KEYS */;
INSERT INTO `home_modules` VALUES (1,'Admissions','Online Admission','Application, documents, registrar review, acceptance, and student number generation.','Open Admission ->','/admission',NULL,'https://images.unsplash.com/photo-1523580846011-d3a5bc25702b?auto=format&fit=crop&w=900&q=80',1,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'Academics','Academic Dashboard','Classes, subjects, routines, examinations, attendance, study materials, and grades.','View Courses ->','/course',NULL,'https://images.unsplash.com/photo-1522202176988-66273c2fd55f?auto=format&fit=crop&w=900&q=80',2,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,'Finance','Finance and Reports','Invoices, bKash, Stripe, PayPal, salary, income, expense, and reconciliation.','Student Billing ->','/student/login',NULL,'https://images.unsplash.com/photo-1554224155-6726b3ff858f?auto=format&fit=crop&w=900&q=80',3,1,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `home_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `home_page_contents`
--

DROP TABLE IF EXISTS `home_page_contents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `home_page_contents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `about_kicker` varchar(255) NOT NULL DEFAULT 'About Our University',
  `about_heading` varchar(255) NOT NULL DEFAULT 'A Few Words About the University',
  `about_body` text NOT NULL,
  `mission_title` varchar(255) NOT NULL DEFAULT 'Our Mission',
  `mission_body` text NOT NULL,
  `vision_title` varchar(255) NOT NULL DEFAULT 'Our Vision',
  `vision_body` text NOT NULL,
  `about_image_one_path` varchar(255) DEFAULT NULL,
  `about_image_one_url` varchar(255) DEFAULT NULL,
  `about_image_two_path` varchar(255) DEFAULT NULL,
  `about_image_two_url` varchar(255) DEFAULT NULL,
  `about_image_three_path` varchar(255) DEFAULT NULL,
  `about_image_three_url` varchar(255) DEFAULT NULL,
  `modules_kicker` varchar(255) NOT NULL DEFAULT 'What does it offer for academic management?',
  `modules_heading` varchar(255) NOT NULL DEFAULT 'Complete University ERP Modules',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `home_page_contents`
--

LOCK TABLES `home_page_contents` WRITE;
/*!40000 ALTER TABLE `home_page_contents` DISABLE KEYS */;
INSERT INTO `home_page_contents` VALUES (1,'About Our University','A Few Words About the University','Our university platform brings the public website, admission, academics, students, teachers, finance, gallery, events, news, and reports into one clean digital experience. Students can apply and log in easily while staff manage the full university operation from the admin side.','Our Mission','Deliver simple digital services for admission, learning, billing, attendance, examinations, and communication.','Our Vision','Build a modern university management system where every department works with accurate, connected information.',NULL,'https://images.unsplash.com/photo-1498243691581-b145c3f54a5a?auto=format&fit=crop&w=700&q=80',NULL,'https://images.unsplash.com/photo-1503676260728-1c00da094a0b?auto=format&fit=crop&w=650&q=80',NULL,'https://images.unsplash.com/photo-1562774053-701939374585?auto=format&fit=crop&w=650&q=80','What does it offer for academic management?','Complete University ERP Modules','2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `home_page_contents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hostel_assignments`
--

DROP TABLE IF EXISTS `hostel_assignments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hostel_assignments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `hostel_room_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `assigned_at` date NOT NULL,
  `vacant_at` date DEFAULT NULL,
  `status` enum('active','completed','cancelled') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hostel_assignments_student_id_term_id_unique` (`student_id`,`term_id`),
  KEY `hostel_assignments_hostel_room_id_foreign` (`hostel_room_id`),
  KEY `hostel_assignments_term_id_foreign` (`term_id`),
  KEY `hostel_assignments_status_index` (`status`),
  CONSTRAINT `hostel_assignments_hostel_room_id_foreign` FOREIGN KEY (`hostel_room_id`) REFERENCES `hostel_rooms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hostel_assignments_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`),
  CONSTRAINT `hostel_assignments_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hostel_assignments`
--

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

--
-- Table structure for table `hostel_rooms`
--

DROP TABLE IF EXISTS `hostel_rooms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hostel_rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `hostel_id` bigint(20) unsigned NOT NULL,
  `room_no` varchar(255) NOT NULL,
  `floor` tinyint(3) unsigned NOT NULL,
  `type` enum('single','double','dorm') NOT NULL,
  `capacity` smallint(5) unsigned NOT NULL,
  `occupied_count` smallint(5) unsigned NOT NULL DEFAULT 0,
  `monthly_rent_minor` bigint(20) unsigned NOT NULL,
  `gender` enum('male','female','any') NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hostel_rooms_hostel_id_room_no_unique` (`hostel_id`,`room_no`),
  KEY `hostel_rooms_gender_is_active_index` (`gender`,`is_active`),
  CONSTRAINT `hostel_rooms_hostel_id_foreign` FOREIGN KEY (`hostel_id`) REFERENCES `hostels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hostel_rooms`
--

LOCK TABLES `hostel_rooms` WRITE;
/*!40000 ALTER TABLE `hostel_rooms` DISABLE KEYS */;
INSERT INTO `hostel_rooms` VALUES (1,1,'B-101',1,'single',1,0,600000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(2,1,'B-102',1,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(3,1,'B-103',1,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(4,1,'B-104',1,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(5,1,'B-105',1,'dorm',4,0,250000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(6,1,'B-201',2,'single',1,0,600000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(7,1,'B-202',2,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(8,1,'B-203',2,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(9,1,'B-204',2,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(10,1,'B-205',2,'dorm',4,0,250000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(11,1,'B-301',3,'single',1,0,600000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(12,1,'B-302',3,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(13,1,'B-303',3,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(14,1,'B-304',3,'double',2,0,400000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(15,1,'B-305',3,'dorm',4,0,250000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(16,2,'G-101',1,'single',1,0,650000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(17,2,'G-102',1,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(18,2,'G-103',1,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(19,2,'G-104',1,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(20,2,'G-105',1,'dorm',4,0,280000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(21,2,'G-201',2,'single',1,0,650000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(22,2,'G-202',2,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(23,2,'G-203',2,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(24,2,'G-204',2,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(25,2,'G-205',2,'dorm',4,0,280000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(26,2,'G-301',3,'single',1,0,650000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(27,2,'G-302',3,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(28,2,'G-303',3,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(29,2,'G-304',3,'double',2,0,450000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(30,2,'G-305',3,'dorm',4,0,280000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(31,3,'I-101',1,'single',1,0,800000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(32,3,'I-102',1,'single',1,0,800000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(33,3,'I-103',1,'double',2,0,550000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(34,3,'I-104',1,'double',2,0,550000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(35,3,'I-105',1,'dorm',6,0,350000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(36,3,'I-201',2,'single',1,0,800000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(37,3,'I-202',2,'single',1,0,800000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(38,3,'I-203',2,'double',2,0,550000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(39,3,'I-204',2,'double',2,0,550000,'male',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(40,3,'I-205',2,'dorm',6,0,350000,'female',1,'2026-07-11 00:57:36','2026-07-11 00:57:36',NULL);
/*!40000 ALTER TABLE `hostel_rooms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hostels`
--

DROP TABLE IF EXISTS `hostels`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `hostels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `type` enum('boys','girls','coed') NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `description` text 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 `hostels_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hostels`
--

LOCK TABLES `hostels` WRITE;
/*!40000 ALTER TABLE `hostels` DISABLE KEYS */;
INSERT INTO `hostels` VALUES (1,'Sher-e-Bangla Hall (Boys)','boys','East Campus, Block B','Male student residence hall.','2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(2,'Pritilata Hall (Girls)','girls','West Campus, Block C','Female student residence hall.','2026-07-11 00:57:36','2026-07-11 00:57:36',NULL),(3,'International House (Co-Ed)','coed','Central Campus, Block F','International and post-graduate student residence.','2026-07-11 00:57:36','2026-07-11 00:57:36',NULL);
/*!40000 ALTER TABLE `hostels` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `invoice_installments`
--

DROP TABLE IF EXISTS `invoice_installments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_installments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `sequence` tinyint(3) unsigned NOT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `due_date` date NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_installments_invoice_id_foreign` (`invoice_id`),
  CONSTRAINT `invoice_installments_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_installments`
--

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

--
-- Table structure for table `invoice_items`
--

DROP TABLE IF EXISTS `invoice_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoice_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `enrollment_id` bigint(20) unsigned DEFAULT NULL,
  `fee_structure_id` bigint(20) unsigned DEFAULT NULL,
  `description` varchar(255) NOT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `invoice_items_invoice_id_foreign` (`invoice_id`),
  KEY `invoice_items_enrollment_id_foreign` (`enrollment_id`),
  KEY `invoice_items_fee_structure_id_foreign` (`fee_structure_id`),
  CONSTRAINT `invoice_items_enrollment_id_foreign` FOREIGN KEY (`enrollment_id`) REFERENCES `enrollments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `invoice_items_fee_structure_id_foreign` FOREIGN KEY (`fee_structure_id`) REFERENCES `fee_structures` (`id`) ON DELETE SET NULL,
  CONSTRAINT `invoice_items_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoice_items`
--

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

--
-- Table structure for table `invoices`
--

DROP TABLE IF EXISTS `invoices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `invoices` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `term_id` bigint(20) unsigned NOT NULL,
  `invoice_number` varchar(255) NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'BDT',
  `subtotal_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `amount_paid_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `due_date` date DEFAULT NULL,
  `issued_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `invoices_invoice_number_unique` (`invoice_number`),
  KEY `invoices_student_id_foreign` (`student_id`),
  KEY `invoices_term_id_foreign` (`term_id`),
  KEY `invoices_status_index` (`status`),
  CONSTRAINT `invoices_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE,
  CONSTRAINT `invoices_term_id_foreign` FOREIGN KEY (`term_id`) REFERENCES `terms` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `invoices`
--

LOCK TABLES `invoices` WRITE;
/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
INSERT INTO `invoices` VALUES (1,1,1,'INV-FALL26-0001','BDT',5000000,0,'issued','2026-08-15','2026-07-11 00:57:36','2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;

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

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

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

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

--
-- Table structure for table `media_items`
--

DROP TABLE IF EXISTS `media_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `media_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `mediable_type` varchar(255) NOT NULL,
  `mediable_id` bigint(20) unsigned NOT NULL,
  `path` varchar(255) NOT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_items_mediable_type_mediable_id_index` (`mediable_type`,`mediable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `media_items`
--

LOCK TABLES `media_items` WRITE;
/*!40000 ALTER TABLE `media_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `media_items` 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 = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT 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 `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'2026_07_10_000000_create_laravel_base_tables',1),(2,'2026_07_10_000001_create_ums_core_schema',1),(3,'2026_07_10_000002_create_permission_tables',1),(4,'2026_07_10_000003_add_profile_fields_to_students',1),(5,'2026_07_10_000004_create_student_transfers_table',1),(6,'2026_07_10_000005_create_hostel_tables',1),(7,'2026_07_10_000006_create_student_documents_table',1),(8,'2026_07_10_000007_create_academic_ops_tables',1),(9,'2026_07_10_000008_create_grading_and_payroll_tables',1),(10,'2026_07_10_000009_create_events_library_storefront_tables',1),(11,'2026_07_10_000010_create_site_cms_tables',1),(12,'2026_07_10_000011_create_media_items_table',1),(13,'2026_07_10_000012_add_default_currency_to_site_settings',1),(14,'2026_07_10_000013_create_home_features_table',1),(15,'2026_07_10_000014_create_home_page_content_and_modules_tables',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_permissions`
--

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

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES (2,'App\\Models\\User',3),(3,'App\\Models\\User',1),(6,'App\\Models\\User',2);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `news_posts`
--

DROP TABLE IF EXISTS `news_posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `news_posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `body` text DEFAULT NULL,
  `image_path` varchar(255) DEFAULT NULL,
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `news_posts_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `news_posts`
--

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

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

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

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

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

--
-- Table structure for table `payments`
--

DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` bigint(20) unsigned NOT NULL,
  `gateway` varchar(255) NOT NULL,
  `gateway_txn_id` varchar(255) DEFAULT NULL,
  `idempotency_key` varchar(255) NOT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `currency` varchar(3) NOT NULL DEFAULT 'BDT',
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `raw_payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`raw_payload`)),
  `paid_at` timestamp NULL DEFAULT NULL,
  `refunded_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payments_idempotency_key_unique` (`idempotency_key`),
  UNIQUE KEY `payments_gateway_txn_id_unique` (`gateway_txn_id`),
  KEY `payments_invoice_id_foreign` (`invoice_id`),
  KEY `payments_status_index` (`status`),
  CONSTRAINT `payments_invoice_id_foreign` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payments`
--

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

--
-- Table structure for table `payrolls`
--

DROP TABLE IF EXISTS `payrolls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `payrolls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payee_type` varchar(255) NOT NULL,
  `payee_id` bigint(20) unsigned NOT NULL,
  `period` date NOT NULL,
  `amount_minor` bigint(20) unsigned NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `paid_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payrolls_payee_type_payee_id_period_unique` (`payee_type`,`payee_id`,`period`),
  KEY `payrolls_created_by_foreign` (`created_by`),
  KEY `payrolls_status_index` (`status`),
  CONSTRAINT `payrolls_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `payrolls`
--

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'student.view.own','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'student.view.any','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,'student.create','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(4,'enrollment.create.own','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(5,'enrollment.create.any','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(6,'attendance.mark','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(7,'grade.enter','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(8,'grade.publish','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(9,'invoice.view.own','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(10,'invoice.generate','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(11,'payment.refund','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(12,'class.create','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(13,'user.manage','web','2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `programs`
--

DROP TABLE IF EXISTS `programs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `programs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `department_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `total_credits` smallint(5) unsigned NOT NULL DEFAULT 120,
  `duration_terms` smallint(5) unsigned NOT NULL DEFAULT 8,
  `max_credits_per_term` smallint(5) unsigned NOT NULL DEFAULT 21,
  `currency` varchar(3) NOT NULL DEFAULT 'BDT',
  `list_price_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `is_publicly_listed` tinyint(1) NOT NULL DEFAULT 0,
  `summary` varchar(255) DEFAULT NULL,
  `image_url` varchar(255) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `programs_code_unique` (`code`),
  KEY `programs_department_id_foreign` (`department_id`),
  CONSTRAINT `programs_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `programs`
--

LOCK TABLES `programs` WRITE;
/*!40000 ALTER TABLE `programs` DISABLE KEYS */;
INSERT INTO `programs` VALUES (1,1,'BSc Computer Science','BSC-CSE',132,8,21,'BDT',0,0,NULL,NULL,1,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `programs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_has_permissions`
--

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES (1,2),(1,6),(2,3),(2,6),(3,6),(4,2),(4,6),(5,6),(6,3),(6,6),(7,3),(7,6),(8,3),(8,6),(9,2),(9,6),(10,6),(11,6),(12,6),(13,6);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `roles`
--

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'applicant','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'student','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,'teacher','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(4,'registrar','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(5,'finance','web','2026-07-11 00:57:35','2026-07-11 00:57:35'),(6,'admin','web','2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rooms`
--

DROP TABLE IF EXISTS `rooms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `rooms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `building` varchar(255) NOT NULL,
  `number` varchar(255) NOT NULL,
  `capacity` smallint(5) unsigned NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'classroom',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rooms_building_number_unique` (`building`,`number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rooms`
--

LOCK TABLES `rooms` WRITE;
/*!40000 ALTER TABLE `rooms` DISABLE KEYS */;
INSERT INTO `rooms` VALUES (1,'A','301',50,'classroom','2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `rooms` 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 = utf8mb4 */;
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 */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `site_settings`
--

DROP TABLE IF EXISTS `site_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `site_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_name` varchar(255) NOT NULL DEFAULT 'HiTech University',
  `default_currency` varchar(3) NOT NULL DEFAULT 'BDT',
  `tagline` varchar(255) DEFAULT NULL,
  `logo_path` varchar(255) DEFAULT NULL,
  `favicon_path` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `facebook_url` varchar(255) DEFAULT NULL,
  `twitter_url` varchar(255) DEFAULT NULL,
  `linkedin_url` varchar(255) DEFAULT NULL,
  `paypal_client_id` varchar(255) DEFAULT NULL,
  `paypal_client_secret` varchar(255) DEFAULT NULL,
  `paypal_mode` varchar(255) NOT NULL DEFAULT 'sandbox',
  `stripe_publishable_key` varchar(255) DEFAULT NULL,
  `stripe_secret_key` varchar(255) DEFAULT NULL,
  `stripe_mode` varchar(255) NOT NULL DEFAULT 'test',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `site_settings`
--

LOCK TABLES `site_settings` WRITE;
/*!40000 ALTER TABLE `site_settings` DISABLE KEYS */;
INSERT INTO `site_settings` VALUES (1,'Signaltechs University','USD','University','branding/zTEoxTPCPFY2j2jMylpruYrX8PKGcKVRvP0z2Qh6.png','branding/FazbodfHJxdSktiFHLSKaHLUmkRBIl4kNcEZqyhC.png','+1 (702) 663-9222','info@signaltechs.io','101 Convention Center Dr. Suite 900 Las Vegas, Nevada 89109',NULL,NULL,NULL,NULL,NULL,'sandbox',NULL,NULL,'test','2026-07-11 00:57:44','2026-07-11 01:13:18');
/*!40000 ALTER TABLE `site_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slider_images`
--

DROP TABLE IF EXISTS `slider_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `slider_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `image_path` varchar(255) NOT NULL,
  `headline` varchar(255) DEFAULT NULL,
  `subheading` varchar(255) DEFAULT NULL,
  `button_text` varchar(255) DEFAULT NULL,
  `button_link` varchar(255) DEFAULT NULL,
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0,
  `is_published` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_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 `slider_images`
--

LOCK TABLES `slider_images` WRITE;
/*!40000 ALTER TABLE `slider_images` DISABLE KEYS */;
INSERT INTO `slider_images` VALUES (1,'slider-images/o7incFDrhjLhoQjwFuPAs0y8KfFIwAi93XjKgbTF.jpg',NULL,NULL,NULL,NULL,0,1,'2026-07-11 23:48:58','2026-07-11 23:48:58');
/*!40000 ALTER TABLE `slider_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `department_id` bigint(20) unsigned DEFAULT NULL,
  `employee_number` varchar(255) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `monthly_salary_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `staff_user_id_unique` (`user_id`),
  UNIQUE KEY `staff_employee_number_unique` (`employee_number`),
  KEY `staff_department_id_foreign` (`department_id`),
  CONSTRAINT `staff_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE SET NULL,
  CONSTRAINT `staff_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1,2,2,'S-260001','Registrar','active',0,'2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student_documents`
--

DROP TABLE IF EXISTS `student_documents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `student_documents` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `type` varchar(255) NOT NULL,
  `original_name` varchar(255) NOT NULL,
  `file_path` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_documents_student_id_foreign` (`student_id`),
  CONSTRAINT `student_documents_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_documents`
--

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

--
-- Table structure for table `student_transfers`
--

DROP TABLE IF EXISTS `student_transfers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `student_transfers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) unsigned NOT NULL,
  `direction` varchar(255) NOT NULL,
  `transfer_ref` varchar(255) NOT NULL,
  `university_name` varchar(255) NOT NULL,
  `transfer_date` date NOT NULL,
  `note` text DEFAULT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_transfers_transfer_ref_unique` (`transfer_ref`),
  KEY `student_transfers_student_id_foreign` (`student_id`),
  KEY `student_transfers_created_by_foreign` (`created_by`),
  KEY `student_transfers_direction_index` (`direction`),
  CONSTRAINT `student_transfers_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  CONSTRAINT `student_transfers_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_transfers`
--

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

--
-- Table structure for table `students`
--

DROP TABLE IF EXISTS `students`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `students` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `first_name` varchar(255) DEFAULT NULL,
  `last_name` varchar(255) DEFAULT NULL,
  `program_id` bigint(20) unsigned NOT NULL,
  `student_number` varchar(255) NOT NULL,
  `admission_date` date DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'applicant',
  `gender` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `emergency_phone` varchar(255) DEFAULT NULL,
  `father_name` varchar(255) DEFAULT NULL,
  `father_occupation` varchar(255) DEFAULT NULL,
  `mother_name` varchar(255) DEFAULT NULL,
  `mother_occupation` varchar(255) DEFAULT NULL,
  `religion` varchar(255) DEFAULT NULL,
  `marital_status` varchar(255) DEFAULT NULL,
  `blood_group` varchar(255) DEFAULT NULL,
  `present_address` varchar(255) DEFAULT NULL,
  `permanent_address` varchar(255) DEFAULT NULL,
  `previous_school` varchar(255) DEFAULT NULL,
  `previous_qualification` varchar(255) DEFAULT NULL,
  `photo_path` varchar(255) DEFAULT NULL,
  `cgpa` decimal(3,2) NOT NULL DEFAULT 0.00,
  `total_credits_earned` smallint(5) unsigned NOT NULL DEFAULT 0,
  `national_id` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `students_user_id_unique` (`user_id`),
  UNIQUE KEY `students_student_number_unique` (`student_number`),
  UNIQUE KEY `students_national_id_unique` (`national_id`),
  KEY `students_program_id_foreign` (`program_id`),
  KEY `students_status_index` (`status`),
  CONSTRAINT `students_program_id_foreign` FOREIGN KEY (`program_id`) REFERENCES `programs` (`id`),
  CONSTRAINT `students_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `students`
--

LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
INSERT INTO `students` VALUES (1,3,NULL,NULL,1,'UMS-260041','2026-07-10','enrolled',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.00,0,'NID-260041','2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subject_prerequisites`
--

DROP TABLE IF EXISTS `subject_prerequisites`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_prerequisites` (
  `subject_id` bigint(20) unsigned NOT NULL,
  `prerequisite_subject_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`subject_id`,`prerequisite_subject_id`),
  KEY `subject_prerequisites_prerequisite_subject_id_foreign` (`prerequisite_subject_id`),
  CONSTRAINT `subject_prerequisites_prerequisite_subject_id_foreign` FOREIGN KEY (`prerequisite_subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subject_prerequisites_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject_prerequisites`
--

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

--
-- Table structure for table `subject_teacher`
--

DROP TABLE IF EXISTS `subject_teacher`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `subject_teacher` (
  `subject_id` bigint(20) unsigned NOT NULL,
  `teacher_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`subject_id`,`teacher_id`),
  KEY `subject_teacher_teacher_id_foreign` (`teacher_id`),
  CONSTRAINT `subject_teacher_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subject_teacher_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subject_teacher`
--

LOCK TABLES `subject_teacher` WRITE;
/*!40000 ALTER TABLE `subject_teacher` DISABLE KEYS */;
INSERT INTO `subject_teacher` VALUES (1,1),(2,1),(3,1);
/*!40000 ALTER TABLE `subject_teacher` 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 = utf8mb4 */;
CREATE TABLE `subjects` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `department_id` bigint(20) unsigned NOT NULL,
  `code` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `credits` tinyint(3) unsigned NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `subjects_code_unique` (`code`),
  KEY `subjects_department_id_foreign` (`department_id`),
  CONSTRAINT `subjects_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subjects`
--

LOCK TABLES `subjects` WRITE;
/*!40000 ALTER TABLE `subjects` DISABLE KEYS */;
INSERT INTO `subjects` VALUES (1,1,'CSE-101','Programming Fundamentals',3,NULL,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,1,'MAT-120','Calculus I',3,NULL,1,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(3,2,'ENG-210','Academic Writing',2,NULL,1,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `subjects` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `teachers`
--

DROP TABLE IF EXISTS `teachers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `teachers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `department_id` bigint(20) unsigned NOT NULL,
  `employee_number` varchar(255) NOT NULL,
  `hire_date` date DEFAULT NULL,
  `employment_type` varchar(255) NOT NULL DEFAULT 'full_time',
  `max_hours_per_term` smallint(5) unsigned NOT NULL DEFAULT 18,
  `monthly_salary_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `teachers_user_id_unique` (`user_id`),
  UNIQUE KEY `teachers_employee_number_unique` (`employee_number`),
  KEY `teachers_department_id_foreign` (`department_id`),
  CONSTRAINT `teachers_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `teachers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `teachers`
--

LOCK TABLES `teachers` WRITE;
/*!40000 ALTER TABLE `teachers` DISABLE KEYS */;
INSERT INTO `teachers` VALUES (1,1,1,'T-260001','2024-01-01','full_time',18,0,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `teachers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `terms`
--

DROP TABLE IF EXISTS `terms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `terms` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `reg_open` datetime NOT NULL,
  `reg_close` datetime NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'planning',
  `is_active` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `terms_name_unique` (`name`),
  KEY `terms_status_index` (`status`),
  KEY `terms_is_active_index` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `terms`
--

LOCK TABLES `terms` WRITE;
/*!40000 ALTER TABLE `terms` DISABLE KEYS */;
INSERT INTO `terms` VALUES (1,'Fall 2026','2026-09-01','2026-12-20','2026-07-15 00:00:00','2026-08-22 23:59:59','registration',1,'2026-07-11 00:57:35','2026-07-11 00:57:35');
/*!40000 ALTER TABLE `terms` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `transport_routes`
--

DROP TABLE IF EXISTS `transport_routes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `transport_routes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `stops` text DEFAULT NULL,
  `fare_minor` bigint(20) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `transport_routes_name_unique` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transport_routes`
--

LOCK TABLES `transport_routes` WRITE;
/*!40000 ALTER TABLE `transport_routes` DISABLE KEYS */;
/*!40000 ALTER TABLE `transport_routes` 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 = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  KEY `users_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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,'Dr. Farhana Chowdhury','teacher@ums.test',NULL,'$2y$12$YJbnmUCb9VjefcmI4bWuDeKiU1uGKTHrgBUdtjFV/Cr9yvYJq/aTu','+8801000000001','active',NULL,'2026-07-11 00:57:35','2026-07-11 00:57:35'),(2,'Admin User','admin@mail.com',NULL,'$2y$12$C14kulCnbtI9zeevK7Zonu/s2iyNwGjAUe.aQoBKpaJSa/5VOPfgK','+8801000000002','active',NULL,'2026-07-11 00:57:36','2026-07-11 00:57:36'),(3,'Samir Ahmed','student@ums.test',NULL,'$2y$12$SMBQBT2U7LzOr3zv8tl5ZOLpRK2SiY.KuYa4KuT5MceDiPz87oYN6','+8801000000003','active',NULL,'2026-07-11 00:57:36','2026-07-11 00:57:36');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vehicles`
--

DROP TABLE IF EXISTS `vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `vehicles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `transport_route_id` bigint(20) unsigned DEFAULT NULL,
  `registration_no` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'bus',
  `capacity` smallint(5) unsigned NOT NULL DEFAULT 0,
  `driver_name` varchar(255) DEFAULT NULL,
  `driver_phone` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicles_registration_no_unique` (`registration_no`),
  KEY `vehicles_transport_route_id_foreign` (`transport_route_id`),
  CONSTRAINT `vehicles_transport_route_id_foreign` FOREIGN KEY (`transport_route_id`) REFERENCES `transport_routes` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicles`
--

LOCK TABLES `vehicles` WRITE;
/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2026-09-24  8:41:48

${this.title}

Code Editor : signgwph_university_backup_2026-09-24_084148.sql