-- MySQL dump 10.13 Distrib 5.5.62, for Win64 (AMD64) -- -- Host: 127.0.0.1 Database: stepup_admin_db -- ------------------------------------------------------ -- Server version 5.7.44 /*!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 utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `absence_reports` -- DROP TABLE IF EXISTS `absence_reports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `absence_reports` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `studentId` bigint(20) unsigned NOT NULL, `classScheduleId` bigint(20) unsigned NOT NULL, `reportedBy` bigint(20) unsigned NOT NULL, `absenceDate` date NOT NULL, `classTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `isLateNotice` tinyint(1) NOT NULL DEFAULT '0', `acknowledgedLateNotice` tinyint(1) NOT NULL DEFAULT '0', `makeupEligible` tinyint(1) NOT NULL DEFAULT '1', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'reported', `adminNotified` tinyint(1) NOT NULL DEFAULT '0', `tutorNotified` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `absence_reports_classscheduleid_foreign` (`classScheduleId`), KEY `absence_reports_studentid_absencedate_index` (`studentId`,`absenceDate`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `absence_reports` -- LOCK TABLES `absence_reports` WRITE; /*!40000 ALTER TABLE `absence_reports` DISABLE KEYS */; /*!40000 ALTER TABLE `absence_reports` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accounts` -- DROP TABLE IF EXISTS `accounts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accounts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('bank','cash','other') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bank', `account_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `institution` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opening_balance` decimal(12,2) NOT NULL DEFAULT '0.00', `current_balance` decimal(12,2) NOT NULL DEFAULT '0.00', `is_active` tinyint(1) NOT NULL DEFAULT '1', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `accounts_type_index` (`type`), KEY `accounts_is_active_index` (`is_active`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accounts` -- LOCK TABLES `accounts` WRITE; /*!40000 ALTER TABLE `accounts` DISABLE KEYS */; INSERT INTO `accounts` VALUES (1,'Main Account','bank',NULL,NULL,0.00,0.00,1,0,1,'2026-04-09 05:00:31','2026-04-09 09:00:24'); /*!40000 ALTER TABLE `accounts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity_logs` -- DROP TABLE IF EXISTS `activity_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `logType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'system', `entityType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `entityId` bigint(20) unsigned NOT NULL, `action` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `metadata` json DEFAULT NULL, `ipAddress` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `userAgent` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_logs_entitytype_entityid_index` (`entityType`,`entityId`), KEY `activity_logs_logtype_index` (`logType`), KEY `activity_logs_created_by_index` (`created_by`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_logs` -- LOCK TABLES `activity_logs` WRITE; /*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `address_tables` -- DROP TABLE IF EXISTS `address_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `address_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned DEFAULT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `unit_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `street` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `city_id` bigint(20) unsigned DEFAULT NULL, `province_id` bigint(20) unsigned DEFAULT NULL, `postal_code` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_id` bigint(20) unsigned DEFAULT NULL, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `address_tables_created_by_foreign` (`created_by`), CONSTRAINT `address_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `address_tables` -- LOCK TABLES `address_tables` WRITE; /*!40000 ALTER TABLE `address_tables` DISABLE KEYS */; INSERT INTO `address_tables` VALUES (1,1,NULL,NULL,'1632 Rockaway Street',NULL,6,2,'L1K 0C8',1,1,1,NULL,0,'2026-04-09 10:46:15','2026-04-09 10:46:15'),(2,1,NULL,NULL,'25 Anjac Crescent',NULL,8,2,'L6E 1X1',1,1,1,1,0,'2026-04-09 13:36:02','2026-04-12 00:26:16'),(3,2,NULL,NULL,'25 Anjac Crescent',NULL,9,2,'L6E 1X1',1,1,1,1,0,'2026-04-12 09:06:52','2026-04-12 10:21:34'),(4,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,0,'2026-04-13 09:40:55','2026-04-13 10:21:14'),(5,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,0,'2026-04-13 22:30:13','2026-04-13 22:30:13'),(6,3,NULL,NULL,'1632 Rockaway Street',NULL,6,2,'L1K 0L8',1,1,1,NULL,0,'2026-04-14 07:26:48','2026-04-14 07:26:48'),(7,3,NULL,NULL,'25 Anjac Crescent',NULL,9,2,'L6E 1X1',1,1,1,NULL,0,'2026-04-14 07:43:10','2026-04-14 07:43:10'),(8,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,0,'2026-04-14 07:51:10','2026-04-14 07:51:10'),(9,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,0,'2026-06-01 07:16:31','2026-06-01 21:39:26'); /*!40000 ALTER TABLE `address_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assign_classes` -- DROP TABLE IF EXISTS `assign_classes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assign_classes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `location_id` bigint(20) unsigned DEFAULT NULL, `class_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `class_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `number_of_student` int(11) DEFAULT NULL, `select_grade_subject_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `period_based_from_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `period_based_to_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `schedule_end_date` timestamp NULL DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assign_classes_created_by_foreign` (`created_by`), CONSTRAINT `assign_classes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_classes` -- LOCK TABLES `assign_classes` WRITE; /*!40000 ALTER TABLE `assign_classes` DISABLE KEYS */; INSERT INTO `assign_classes` VALUES (1,'Created Class',2,1,'Offline','Regular',2,'[11]',NULL,NULL,'17:00','18:00',NULL,NULL,0,1,NULL,'2026-04-13 21:38:25','2026-04-13 21:38:25'),(2,'Created Class',1,3,'Offline','Regular',3,'[5,11]',NULL,NULL,'18:00','19:00',NULL,NULL,0,1,NULL,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(3,'Created Class',3,1,'Offline','Regular',2,'[3]',NULL,NULL,'15:00','16:00',NULL,NULL,0,1,NULL,'2026-04-14 07:45:24','2026-04-14 07:45:24'); /*!40000 ALTER TABLE `assign_classes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assign_classes_histories` -- DROP TABLE IF EXISTS `assign_classes_histories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assign_classes_histories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `perant_calss_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `location_id` bigint(20) unsigned DEFAULT NULL, `student_id` bigint(20) unsigned DEFAULT NULL, `class_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `class_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `number_of_student` int(11) DEFAULT NULL, `select_grade_subject_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `selected_days` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `period_based_from_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `period_based_to_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `schedule_end_date` timestamp NULL DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assign_classes_histories_created_by_foreign` (`created_by`), CONSTRAINT `assign_classes_histories_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_classes_histories` -- LOCK TABLES `assign_classes_histories` WRITE; /*!40000 ALTER TABLE `assign_classes_histories` DISABLE KEYS */; INSERT INTO `assign_classes_histories` VALUES (1,1,'Created Class',2,1,NULL,'Offline','Regular',2,'[11]','[\"Sunday\",\"Monday\",\"Tuesday\"]',NULL,NULL,'17:00','18:00',NULL,NULL,0,1,NULL,'2026-04-13 21:38:25','2026-04-13 21:38:25'),(2,1,'Student Added',NULL,NULL,2,NULL,NULL,NULL,'[11]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(3,2,'Created Class',1,3,NULL,'Offline','Regular',3,'[5,11]','[\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"]',NULL,NULL,'18:00','19:00',NULL,NULL,0,1,NULL,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(4,2,'Student Added',NULL,NULL,2,NULL,NULL,NULL,'[11]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(5,3,'Created Class',3,1,NULL,'Offline','Regular',2,'[3]','[\"Sunday\",\"Monday\",\"Tuesday\",\"Wednesday\",\"Thursday\",\"Friday\",\"Saturday\"]',NULL,NULL,'15:00','16:00',NULL,NULL,0,1,NULL,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(6,3,'Student Added',NULL,NULL,3,NULL,NULL,NULL,'[3]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'); /*!40000 ALTER TABLE `assign_classes_histories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assign_classes_schedules` -- DROP TABLE IF EXISTS `assign_classes_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assign_classes_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `perentTableId` bigint(20) unsigned DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `staff_id` bigint(20) unsigned DEFAULT NULL, `class_id` bigint(20) unsigned DEFAULT NULL, `period_based_from_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `period_based_to_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `schedule_end_date` timestamp NULL DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assign_classes_schedules_created_by_foreign` (`created_by`), CONSTRAINT `assign_classes_schedules_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_classes_schedules` -- LOCK TABLES `assign_classes_schedules` WRITE; /*!40000 ALTER TABLE `assign_classes_schedules` DISABLE KEYS */; INSERT INTO `assign_classes_schedules` VALUES (1,NULL,NULL,'Sunday',2,1,NULL,NULL,'17:00','18:00',NULL,0,1,1,'2026-04-13 21:38:25','2026-04-13 21:38:25'),(2,NULL,NULL,'Monday',2,1,NULL,NULL,'17:00','18:00',NULL,0,1,1,'2026-04-13 21:38:25','2026-04-13 21:38:25'),(3,NULL,NULL,'Tuesday',2,1,NULL,NULL,'17:00','18:00',NULL,0,1,1,'2026-04-13 21:38:25','2026-04-13 21:38:25'),(4,NULL,NULL,'Sunday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(5,NULL,NULL,'Monday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(6,NULL,NULL,'Tuesday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(7,NULL,NULL,'Wednesday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(8,NULL,NULL,'Thursday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(9,NULL,NULL,'Friday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(10,NULL,NULL,'Saturday',1,2,NULL,NULL,'18:00','19:00',NULL,0,1,1,'2026-04-13 22:18:32','2026-04-13 22:18:32'),(11,NULL,NULL,'Sunday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(12,NULL,NULL,'Monday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(13,NULL,NULL,'Tuesday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(14,NULL,NULL,'Wednesday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(15,NULL,NULL,'Thursday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(16,NULL,NULL,'Friday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'),(17,NULL,NULL,'Saturday',3,3,NULL,NULL,'15:00','16:00',NULL,0,1,1,'2026-04-14 07:45:24','2026-04-14 07:45:24'); /*!40000 ALTER TABLE `assign_classes_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assign_student_classes` -- DROP TABLE IF EXISTS `assign_student_classes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assign_student_classes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `class_id` bigint(20) unsigned DEFAULT NULL, `student_id` bigint(20) unsigned DEFAULT NULL, `select_grade_subject_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `per_class_rate` decimal(10,2) DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assign_student_classes_created_by_foreign` (`created_by`), CONSTRAINT `assign_student_classes_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assign_student_classes` -- LOCK TABLES `assign_student_classes` WRITE; /*!40000 ALTER TABLE `assign_student_classes` DISABLE KEYS */; INSERT INTO `assign_student_classes` VALUES (1,'Added',1,2,'[11]',NULL,NULL,0,1,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(2,'Added',2,2,'[11]',NULL,NULL,0,1,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(3,'Added',3,3,'[3]',NULL,NULL,0,1,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'); /*!40000 ALTER TABLE `assign_student_classes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `assignment_submissions` -- DROP TABLE IF EXISTS `assignment_submissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `assignment_submissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `assignmentId` bigint(20) unsigned NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `submissionText` text COLLATE utf8mb4_unicode_ci, `attachmentPath` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `submittedAt` datetime NOT NULL, `marksObtained` decimal(8,2) DEFAULT NULL, `feedback` text COLLATE utf8mb4_unicode_ci, `gradedBy` bigint(20) unsigned DEFAULT NULL, `gradedAt` datetime DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'submitted', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `assignment_submissions_assignmentid_studentid_unique` (`assignmentId`,`studentId`), KEY `assignment_submissions_studentid_foreign` (`studentId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `assignment_submissions` -- LOCK TABLES `assignment_submissions` WRITE; /*!40000 ALTER TABLE `assignment_submissions` DISABLE KEYS */; /*!40000 ALTER TABLE `assignment_submissions` 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 = utf8 */; CREATE TABLE `assignments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `courseId` bigint(20) unsigned NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `dueDate` datetime DEFAULT NULL, `totalMarks` decimal(8,2) DEFAULT NULL, `assignmentType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'homework', `attachmentPath` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isPublished` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `assignments_courseid_index` (`courseId`) ) ENGINE=MyISAM 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 `attendance_records` -- DROP TABLE IF EXISTS `attendance_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attendance_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `classScheduleId` bigint(20) unsigned NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'present', `checkInTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `checkOutTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lateMinutes` int(11) NOT NULL DEFAULT '0', `earlyLeaveMinutes` int(11) NOT NULL DEFAULT '0', `notes` text COLLATE utf8mb4_unicode_ci, `parentNotified` tinyint(1) NOT NULL DEFAULT '0', `notifyParent` tinyint(1) NOT NULL DEFAULT '1', `notificationMethod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `markedBy` bigint(20) unsigned NOT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attendance_records_classscheduleid_studentid_unique` (`classScheduleId`,`studentId`), KEY `attendance_records_studentid_status_index` (`studentId`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendance_records` -- LOCK TABLES `attendance_records` WRITE; /*!40000 ALTER TABLE `attendance_records` DISABLE KEYS */; /*!40000 ALTER TABLE `attendance_records` 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(15) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci 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 `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(191) COLLATE utf8mb4_unicode_ci 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_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chat_messages` -- DROP TABLE IF EXISTS `chat_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `conversation_id` bigint(20) unsigned NOT NULL, `sender_id` bigint(20) unsigned NOT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `type` enum('text','file','system') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text', `file_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_to_id` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `chat_messages_conversation_id_created_at_index` (`conversation_id`,`created_at`), KEY `chat_messages_sender_id_index` (`sender_id`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat_messages` -- LOCK TABLES `chat_messages` WRITE; /*!40000 ALTER TABLE `chat_messages` DISABLE KEYS */; INSERT INTO `chat_messages` VALUES (1,1,1,'Hi','text',NULL,NULL,NULL,0,'2026-04-08 05:54:01','2026-04-08 05:54:01'),(2,1,2,'Hi','text',NULL,NULL,NULL,0,'2026-04-08 05:54:24','2026-04-08 05:54:24'),(3,1,1,'How many students in youur calls now','text',NULL,NULL,NULL,0,'2026-04-08 05:54:50','2026-04-08 05:54:50'),(4,2,4,'Hi','text',NULL,NULL,NULL,0,'2026-04-08 09:47:10','2026-04-08 09:47:10'),(5,2,4,'Hi teacher how my daughter perform today','text',NULL,NULL,NULL,0,'2026-04-08 09:48:31','2026-04-08 09:48:31'),(6,2,1,'Yes she is doing well','text',NULL,NULL,NULL,0,'2026-04-08 09:49:00','2026-04-08 09:49:00'),(7,1,4,'Hi','text',NULL,NULL,NULL,0,'2026-04-14 07:56:50','2026-04-14 07:56:50'); /*!40000 ALTER TABLE `chat_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `class_cancellations` -- DROP TABLE IF EXISTS `class_cancellations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `class_cancellations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `classScheduleId` bigint(20) unsigned NOT NULL, `cancellationType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `makeupDate` date DEFAULT NULL, `makeupStartTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `makeupEndTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `makeupLocationId` bigint(20) unsigned DEFAULT NULL, `makeupStaffId` bigint(20) unsigned DEFAULT NULL, `refundIssued` tinyint(1) NOT NULL DEFAULT '0', `refundAmount` decimal(10,2) NOT NULL DEFAULT '0.00', `cancelledBy` bigint(20) unsigned NOT NULL, `isNotified` tinyint(1) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `class_cancellations_classscheduleid_foreign` (`classScheduleId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `class_cancellations` -- LOCK TABLES `class_cancellations` WRITE; /*!40000 ALTER TABLE `class_cancellations` DISABLE KEYS */; /*!40000 ALTER TABLE `class_cancellations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `class_messages` -- DROP TABLE IF EXISTS `class_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `class_messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `class_schedule_id` bigint(20) unsigned NOT NULL, `student_id` bigint(20) unsigned DEFAULT NULL, `sender_id` bigint(20) unsigned NOT NULL, `sender_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `is_read` tinyint(1) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `class_messages` -- LOCK TABLES `class_messages` WRITE; /*!40000 ALTER TABLE `class_messages` DISABLE KEYS */; INSERT INTO `class_messages` VALUES (1,15,2,4,'parent','Can we reschedule this class?',0,0,'2026-04-14 05:14:51','2026-04-14 05:14:51'); /*!40000 ALTER TABLE `class_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `class_requests` -- DROP TABLE IF EXISTS `class_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `class_requests` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `class_schedule_id` bigint(20) unsigned NOT NULL, `student_id` bigint(20) unsigned NOT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `request_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `reason` text COLLATE utf8mb4_unicode_ci, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `handled_by` bigint(20) unsigned DEFAULT NULL, `handled_at` timestamp NULL DEFAULT NULL, `admin_notes` text COLLATE utf8mb4_unicode_ci, `requested_date` date DEFAULT NULL, `requested_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `class_requests` -- LOCK TABLES `class_requests` WRITE; /*!40000 ALTER TABLE `class_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `class_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `class_schedules` -- DROP TABLE IF EXISTS `class_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `class_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `classId` bigint(20) unsigned NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `staffId` bigint(20) unsigned NOT NULL, `subjectId` bigint(20) unsigned DEFAULT NULL, `gradeId` bigint(20) unsigned DEFAULT NULL, `locationId` bigint(20) unsigned DEFAULT NULL, `scheduledDate` date NOT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `scheduleType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'regular', `feePerClass` decimal(10,2) NOT NULL DEFAULT '0.00', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'scheduled', `live_status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `live_started_at` timestamp NULL DEFAULT NULL, `live_ended_at` timestamp NULL DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `class_notes` text COLLATE utf8mb4_unicode_ci, `originalScheduleId` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `invoiced` tinyint(1) NOT NULL DEFAULT '0', `invoice_id` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `class_schedules_classid_foreign` (`classId`), KEY `class_schedules_staffid_foreign` (`staffId`), KEY `class_schedules_scheduleddate_staffid_index` (`scheduledDate`,`staffId`), KEY `class_schedules_scheduleddate_studentid_index` (`scheduledDate`,`studentId`), KEY `class_schedules_status_index` (`status`), KEY `idx_cs_invoiced_status` (`invoiced`,`status`), KEY `idx_cs_student_date` (`studentId`,`scheduledDate`) ) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `class_schedules` -- LOCK TABLES `class_schedules` WRITE; /*!40000 ALTER TABLE `class_schedules` DISABLE KEYS */; INSERT INTO `class_schedules` VALUES (1,1,2,2,NULL,NULL,1,'2026-04-13','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(2,1,2,2,NULL,NULL,1,'2026-04-14','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(3,1,2,2,NULL,NULL,1,'2026-04-19','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(4,1,2,2,NULL,NULL,1,'2026-04-20','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(5,1,2,2,NULL,NULL,1,'2026-04-21','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(6,1,2,2,NULL,NULL,1,'2026-04-26','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(7,1,2,2,NULL,NULL,1,'2026-04-27','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(8,1,2,2,NULL,NULL,1,'2026-04-28','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(9,1,2,2,NULL,NULL,1,'2026-05-03','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(10,1,2,2,NULL,NULL,1,'2026-05-04','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(11,1,2,2,NULL,NULL,1,'2026-05-05','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(12,1,2,2,NULL,NULL,1,'2026-05-10','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(13,1,2,2,NULL,NULL,1,'2026-05-11','17:00','18:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 21:41:36','2026-04-13 21:41:36'),(14,2,2,1,NULL,NULL,3,'2026-04-13','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(15,2,2,1,NULL,NULL,3,'2026-04-14','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(16,2,2,1,NULL,NULL,3,'2026-04-15','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(17,2,2,1,NULL,NULL,3,'2026-04-16','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(18,2,2,1,NULL,NULL,3,'2026-04-17','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(19,2,2,1,NULL,NULL,3,'2026-04-18','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(20,2,2,1,NULL,NULL,3,'2026-04-19','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(21,2,2,1,NULL,NULL,3,'2026-04-20','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(22,2,2,1,NULL,NULL,3,'2026-04-21','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(23,2,2,1,NULL,NULL,3,'2026-04-22','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(24,2,2,1,NULL,NULL,3,'2026-04-23','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(25,2,2,1,NULL,NULL,3,'2026-04-24','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(26,2,2,1,NULL,NULL,3,'2026-04-25','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(27,2,2,1,NULL,NULL,3,'2026-04-26','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(28,2,2,1,NULL,NULL,3,'2026-04-27','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(29,2,2,1,NULL,NULL,3,'2026-04-28','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(30,2,2,1,NULL,NULL,3,'2026-04-29','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(31,2,2,1,NULL,NULL,3,'2026-04-30','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(32,2,2,1,NULL,NULL,3,'2026-05-01','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(33,2,2,1,NULL,NULL,3,'2026-05-02','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:26','2026-04-13 22:21:26'),(34,2,2,1,NULL,NULL,3,'2026-05-03','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(35,2,2,1,NULL,NULL,3,'2026-05-04','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(36,2,2,1,NULL,NULL,3,'2026-05-05','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(37,2,2,1,NULL,NULL,3,'2026-05-06','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(38,2,2,1,NULL,NULL,3,'2026-05-07','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(39,2,2,1,NULL,NULL,3,'2026-05-08','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(40,2,2,1,NULL,NULL,3,'2026-05-09','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(41,2,2,1,NULL,NULL,3,'2026-05-10','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(42,2,2,1,NULL,NULL,3,'2026-05-11','18:00','19:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-13 22:21:27','2026-04-13 22:21:27'),(43,3,3,3,NULL,NULL,1,'2026-04-14','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(44,3,3,3,NULL,NULL,1,'2026-04-15','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(45,3,3,3,NULL,NULL,1,'2026-04-16','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(46,3,3,3,NULL,NULL,1,'2026-04-17','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(47,3,3,3,NULL,NULL,1,'2026-04-18','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(48,3,3,3,NULL,NULL,1,'2026-04-19','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(49,3,3,3,NULL,NULL,1,'2026-04-20','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(50,3,3,3,NULL,NULL,1,'2026-04-21','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(51,3,3,3,NULL,NULL,1,'2026-04-22','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(52,3,3,3,NULL,NULL,1,'2026-04-23','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(53,3,3,3,NULL,NULL,1,'2026-04-24','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(54,3,3,3,NULL,NULL,1,'2026-04-25','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(55,3,3,3,NULL,NULL,1,'2026-04-26','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(56,3,3,3,NULL,NULL,1,'2026-04-27','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(57,3,3,3,NULL,NULL,1,'2026-04-28','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(58,3,3,3,NULL,NULL,1,'2026-04-29','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(59,3,3,3,NULL,NULL,1,'2026-04-30','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(60,3,3,3,NULL,NULL,1,'2026-05-01','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(61,3,3,3,NULL,NULL,1,'2026-05-02','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(62,3,3,3,NULL,NULL,1,'2026-05-03','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(63,3,3,3,NULL,NULL,1,'2026-05-04','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(64,3,3,3,NULL,NULL,1,'2026-05-05','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(65,3,3,3,NULL,NULL,1,'2026-05-06','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(66,3,3,3,NULL,NULL,1,'2026-05-07','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(67,3,3,3,NULL,NULL,1,'2026-05-08','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(68,3,3,3,NULL,NULL,1,'2026-05-09','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(69,3,3,3,NULL,NULL,1,'2026-05-10','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(70,3,3,3,NULL,NULL,1,'2026-05-11','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(71,3,3,3,NULL,NULL,1,'2026-05-12','15:00','16:00','regular',0.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-04-14 07:52:56','2026-04-14 07:52:56'),(72,2,4,1,3,2,NULL,'2026-06-01','06:00','08:00','regular',20.00,'scheduled',NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,0,0,NULL,'2026-06-01 08:12:27','2026-06-01 08:12:27'); /*!40000 ALTER TABLE `class_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `const_records` -- DROP TABLE IF EXISTS `const_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `const_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `const_records_created_by_foreign` (`created_by`), CONSTRAINT `const_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `const_records` -- LOCK TABLES `const_records` WRITE; /*!40000 ALTER TABLE `const_records` DISABLE KEYS */; INSERT INTO `const_records` VALUES (1,'attendance_status_check','0','If value=0 show all records, if 1 show only updated attendance',NULL,1,0,NULL,'2026-06-01 08:42:05'),(2,'calculate_radius',NULL,'Facial punch radius in meters. Example: 50 = employees must be within 50m of the company location to punch in/out.',NULL,1,0,'2025-08-28 11:27:10','2026-02-28 00:29:38'),(3,'company_latitude',NULL,'Company latitude (used for facial punch geofencing).',NULL,1,0,'2025-08-28 11:27:10','2026-02-28 00:29:38'),(4,'company_longitude',NULL,'Company longitude (used for facial punch geofencing).',NULL,1,0,'2025-08-28 11:27:10','2026-02-28 00:29:38'); /*!40000 ALTER TABLE `const_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversation_participants` -- DROP TABLE IF EXISTS `conversation_participants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversation_participants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `conversation_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `role` enum('admin','member') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'member', `last_read_at` timestamp NULL DEFAULT NULL, `is_muted` tinyint(1) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `conversation_participants_conversation_id_user_id_unique` (`conversation_id`,`user_id`), KEY `conversation_participants_user_id_isdelete_index` (`user_id`,`isDelete`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversation_participants` -- LOCK TABLES `conversation_participants` WRITE; /*!40000 ALTER TABLE `conversation_participants` DISABLE KEYS */; INSERT INTO `conversation_participants` VALUES (1,1,4,'admin','2026-04-14 07:58:49',0,0,'2026-04-14 07:56:42','2026-04-14 07:58:49'),(2,1,1,'member','2026-04-15 21:36:11',0,0,'2026-04-14 07:56:42','2026-04-15 21:36:11'),(3,2,1,'admin','2026-04-14 07:57:25',0,0,'2026-04-14 07:57:21','2026-04-14 07:57:25'),(4,2,6,'member',NULL,0,0,'2026-04-14 07:57:21','2026-04-14 07:57:21'),(5,3,4,'admin','2026-04-14 07:59:29',0,0,'2026-04-14 07:59:07','2026-04-14 07:59:29'),(6,3,6,'member',NULL,0,0,'2026-04-14 07:59:07','2026-04-14 07:59:07'); /*!40000 ALTER TABLE `conversation_participants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversations` -- DROP TABLE IF EXISTS `conversations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` enum('direct','group','context') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'direct', `student_id` bigint(20) unsigned DEFAULT NULL, `class_id` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `conversations_type_index` (`type`), KEY `conversations_student_id_index` (`student_id`), KEY `conversations_class_id_index` (`class_id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversations` -- LOCK TABLES `conversations` WRITE; /*!40000 ALTER TABLE `conversations` DISABLE KEYS */; INSERT INTO `conversations` VALUES (1,NULL,'direct',NULL,NULL,4,0,'2026-04-14 07:56:42','2026-04-14 07:56:42'),(2,NULL,'direct',NULL,NULL,1,0,'2026-04-14 07:57:21','2026-04-14 07:57:21'),(3,NULL,'direct',NULL,NULL,4,0,'2026-04-14 07:59:07','2026-04-14 07:59:07'); /*!40000 ALTER TABLE `conversations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `course_materials` -- DROP TABLE IF EXISTS `course_materials`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `course_materials` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `courseId` bigint(20) unsigned NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `materialType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `filePath` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `externalUrl` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orderNumber` int(11) NOT NULL DEFAULT '0', `isPublished` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `course_materials_courseid_index` (`courseId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `course_materials` -- LOCK TABLES `course_materials` WRITE; /*!40000 ALTER TABLE `course_materials` DISABLE KEYS */; /*!40000 ALTER TABLE `course_materials` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `courses` -- DROP TABLE IF EXISTS `courses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `courses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `courseName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `courseCode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `gradeId` bigint(20) unsigned DEFAULT NULL, `subjectId` bigint(20) unsigned DEFAULT NULL, `staffId` bigint(20) unsigned DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `thumbnail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `courses_coursecode_unique` (`courseCode`), KEY `courses_status_index` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `courses` -- LOCK TABLES `courses` WRITE; /*!40000 ALTER TABLE `courses` DISABLE KEYS */; /*!40000 ALTER TABLE `courses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dark_theme_colors` -- DROP TABLE IF EXISTS `dark_theme_colors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dark_theme_colors` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `borderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IconButtonBorderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cardBorderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `primary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secondary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `textPrimary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `textSecondary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `divider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `topBar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `topBarHeading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerHeader` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerHeadingText` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerMenuText` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `background` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secondBackground` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cardBackground` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `editButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `editIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `viewButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `viewIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `thirdBgColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orderListProp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `otherProp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `dark_theme_colors_created_by_foreign` (`created_by`), CONSTRAINT `dark_theme_colors_created_by_foreign` FOREIGN KEY (`created_by`) 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 `dark_theme_colors` -- LOCK TABLES `dark_theme_colors` WRITE; /*!40000 ALTER TABLE `dark_theme_colors` DISABLE KEYS */; INSERT INTO `dark_theme_colors` VALUES (1,'16px','16px','none','#9d939f','#8c9cb7','#cec7c7','#d1d1d1','#aab8c5','#6b6b6b','#22282e','#aab8c5','#22282e','#3e3946','#4d4b4e','#4d4b4e','#282828','#4d4b4e','#2f3944','#c5bccf','#ffffff','#858d74','#ffffff','#765b58',NULL,NULL,NULL,'#ffffff',NULL,NULL,0,1,NULL,'2026-01-26 07:24:22','2026-01-26 07:24:22'); /*!40000 ALTER TABLE `dark_theme_colors` 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` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `departmentName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `restaurantsId` int(11) DEFAULT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `departments_departmentname_unique` (`departmentName`), KEY `departments_created_by_foreign` (`created_by`), CONSTRAINT `departments_created_by_foreign` FOREIGN KEY (`created_by`) 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 `departments` -- LOCK TABLES `departments` WRITE; /*!40000 ALTER TABLE `departments` DISABLE KEYS */; INSERT INTO `departments` VALUES (1,'Tutor',NULL,NULL,1,NULL,0,'2026-04-12 00:34:24','2026-04-12 00:34:24'); /*!40000 ALTER TABLE `departments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_saves` -- DROP TABLE IF EXISTS `email_saves`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email_saves` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `multipleType` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `note` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `email_saves_created_by_foreign` (`created_by`), CONSTRAINT `email_saves_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `email_saves` -- LOCK TABLES `email_saves` WRITE; /*!40000 ALTER TABLE `email_saves` DISABLE KEYS */; /*!40000 ALTER TABLE `email_saves` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_send_records` -- DROP TABLE IF EXISTS `email_send_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email_send_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `staffId` int(11) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `toEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fromEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `isRequestRecord` tinyint(1) NOT NULL DEFAULT '0', `requestId` int(11) DEFAULT NULL, `student_id` bigint(20) unsigned DEFAULT NULL, `error_message` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `image_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `email_send_records_created_by_foreign` (`created_by`), CONSTRAINT `email_send_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `email_send_records` -- LOCK TABLES `email_send_records` WRITE; /*!40000 ALTER TABLE `email_send_records` DISABLE KEYS */; /*!40000 ALTER TABLE `email_send_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email_templates` -- DROP TABLE IF EXISTS `email_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email_templates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `template_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `attachments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `image_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `video_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `email_templates_created_by_foreign` (`created_by`), CONSTRAINT `email_templates_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email_templates` -- LOCK TABLES `email_templates` WRITE; /*!40000 ALTER TABLE `email_templates` DISABLE KEYS */; INSERT INTO `email_templates` VALUES (1,'Punch Notification','[type] Notification - [name]','

Hello Admin,

This is to inform you that the following staff member has just [type]

Please review this punch activity if needed.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-07-04 23:10:22','2025-07-24 23:01:14'),(2,'Admin Edit Notification','Admin Edit [type] Notification -[name]','

Hello Admin,

This is to inform you that the following staff member has just [type] by an administrator.

Please review this punch activity if needed.

Regards,

Durham Convention Center


',NULL,NULL,NULL,0,1,NULL,'2025-07-17 02:11:51','2025-07-17 02:11:51'),(3,'Local Edit Notification','Local Edit [type] Notification -[name]','

Hello Admin,

This is to inform you that the following staff member has just [type] by an administrator.

Please review this punch activity if needed.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-07-17 03:04:24','2025-07-24 23:00:43'),(4,'Admin Delete Punch Record Notification','Admin Delete Punch Record Notification -[name]','

This is to inform you that a punch record for the following staff member has been deleted by an administrator:

Please review this punch activity if needed.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-07-18 07:26:28','2025-07-18 07:27:34'),(5,'Schedule Reminder Notification','Schedule Reminder Notification','

[msg]

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-08-04 23:59:20','2025-08-05 12:15:44'),(6,'Out Of Location Punch Notification','Out of Location [type] Notification - [name]','

Hello Admin,

This is to inform you that the following staff member has performed an Out of Location [type].

Please review this out of location punch activity if needed.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-08-30 11:57:37','2025-08-30 06:31:39'),(7,'Shift Coverage Request','Shift Coverage Request','

Hello [name],

A shift coverage request has been submitted due to staff unavailability. Please check the system and confirm if you are able to accept this shift.

Schedule Details:

Your support is highly appreciated.

Regards,

Durham Convention CenterHello [name],

 Your schedule request has been successfully approved and your work schedule has now been created.

Schedule Details:

Your support is highly appreciated .If you have any questions, feel free to contact the admin.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-12-11 13:03:37','2025-12-11 13:03:37'),(9,'Schedule Request Cancelled','Your Schedule Request Has Been Cancelled','

Hello [name],

We would like to inform you that your schedule request has been cancelled by the admin.

Cancelled Schedule Details:

If this cancellation was unexpected or if you need clarification, please feel free to contact the admin.

Regards,

Durham Convention Center

',NULL,NULL,NULL,0,1,1,'2025-12-11 13:03:37','2025-12-11 13:03:37'); /*!40000 ALTER TABLE `email_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp_admin_edit_punch_records` -- DROP TABLE IF EXISTS `emp_admin_edit_punch_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emp_admin_edit_punch_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `perentTableId` int(11) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `actualTimestamp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isFacialPunch` tinyint(1) NOT NULL DEFAULT '0', `loaction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emp_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `emp_admin_edit_punch_records_created_by_foreign` (`created_by`), CONSTRAINT `emp_admin_edit_punch_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `emp_admin_edit_punch_records` -- LOCK TABLES `emp_admin_edit_punch_records` WRITE; /*!40000 ALTER TABLE `emp_admin_edit_punch_records` DISABLE KEYS */; /*!40000 ALTER TABLE `emp_admin_edit_punch_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp_schedule_records` -- DROP TABLE IF EXISTS `emp_schedule_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emp_schedule_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spansNextDay` tinyint(1) NOT NULL DEFAULT '0', `hourlySalary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `emp_schedule_records_created_by_foreign` (`created_by`), CONSTRAINT `emp_schedule_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `emp_schedule_records` -- LOCK TABLES `emp_schedule_records` WRITE; /*!40000 ALTER TABLE `emp_schedule_records` DISABLE KEYS */; /*!40000 ALTER TABLE `emp_schedule_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp_schedule_request_respondents` -- DROP TABLE IF EXISTS `emp_schedule_request_respondents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emp_schedule_request_respondents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `requestId` int(11) DEFAULT NULL, `userId` int(11) DEFAULT NULL, `empid` int(11) DEFAULT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `isAdminAcsecpeted` tinyint(1) NOT NULL DEFAULT '0', `re_schedule_id` int(11) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `emp_schedule_request_respondents_created_by_foreign` (`created_by`), CONSTRAINT `emp_schedule_request_respondents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `emp_schedule_request_respondents` -- LOCK TABLES `emp_schedule_request_respondents` WRITE; /*!40000 ALTER TABLE `emp_schedule_request_respondents` DISABLE KEYS */; /*!40000 ALTER TABLE `emp_schedule_request_respondents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emp_schedule_requests` -- DROP TABLE IF EXISTS `emp_schedule_requests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emp_schedule_requests` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `schedule_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spansNextDay` tinyint(1) NOT NULL DEFAULT '0', `respondents_total` int(11) DEFAULT NULL, `fromEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` longtext COLLATE utf8mb4_unicode_ci, `message` longtext COLLATE utf8mb4_unicode_ci, `reason` longtext COLLATE utf8mb4_unicode_ci, `smsReminder` tinyint(1) NOT NULL DEFAULT '1', `emailReminder` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `emp_schedule_requests_created_by_foreign` (`created_by`), CONSTRAINT `emp_schedule_requests_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `emp_schedule_requests` -- LOCK TABLES `emp_schedule_requests` WRITE; /*!40000 ALTER TABLE `emp_schedule_requests` DISABLE KEYS */; /*!40000 ALTER TABLE `emp_schedule_requests` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee_biometrics` -- DROP TABLE IF EXISTS `employee_biometrics`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee_biometrics` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `punch_in_required` tinyint(1) NOT NULL DEFAULT '0', `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `emp_image` longtext COLLATE utf8mb4_unicode_ci, `leftthumb_fingerprint` longtext COLLATE utf8mb4_unicode_ci, `rightthumb_fingerprint` longtext COLLATE utf8mb4_unicode_ci, `facial_data` longtext COLLATE utf8mb4_unicode_ci, `isFacialUpdate` tinyint(1) NOT NULL DEFAULT '0', `facialUpdatedBy` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `facialUpdatedAt` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_biometrics_created_by_foreign` (`created_by`), CONSTRAINT `employee_biometrics_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employee_biometrics` -- LOCK TABLES `employee_biometrics` WRITE; /*!40000 ALTER TABLE `employee_biometrics` DISABLE KEYS */; INSERT INTO `employee_biometrics` VALUES (1,1,0,'Afzal Mohamed',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,1,0,'2026-04-09 13:36:02','2026-04-12 00:26:16'),(2,2,0,'David Rattno',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,1,0,'2026-04-12 09:06:52','2026-04-12 10:21:34'),(3,3,0,'Rukshanth David',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,1,NULL,0,'2026-04-14 07:43:10','2026-04-14 07:43:10'); /*!40000 ALTER TABLE `employee_biometrics` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee_delay_records` -- DROP TABLE IF EXISTS `employee_delay_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee_delay_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `updatePunchTableId` int(11) DEFAULT NULL, `empid` int(11) DEFAULT NULL, `punch_action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `delayReason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_delay_records_created_by_foreign` (`created_by`), CONSTRAINT `employee_delay_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `employee_delay_records` -- LOCK TABLES `employee_delay_records` WRITE; /*!40000 ALTER TABLE `employee_delay_records` DISABLE KEYS */; /*!40000 ALTER TABLE `employee_delay_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee_punch_details` -- DROP TABLE IF EXISTS `employee_punch_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee_punch_details` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `emp_image` longtext COLLATE utf8mb4_unicode_ci, `punched_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punched_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_status` tinyint(1) NOT NULL DEFAULT '0', `created_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `updated_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isAdminEdit` tinyint(1) NOT NULL DEFAULT '0', `resonStatus` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `latitude` decimal(10,8) DEFAULT NULL, `longitute` decimal(10,8) DEFAULT NULL, `isFacialPunch` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_punch_details_created_by_foreign` (`created_by`), CONSTRAINT `employee_punch_details_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `employee_punch_details` -- LOCK TABLES `employee_punch_details` WRITE; /*!40000 ALTER TABLE `employee_punch_details` DISABLE KEYS */; /*!40000 ALTER TABLE `employee_punch_details` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee_punch_details_records` -- DROP TABLE IF EXISTS `employee_punch_details_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee_punch_details_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `punch_in_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_in_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_in_actual_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_actual_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isSchedule` tinyint(1) NOT NULL DEFAULT '0', `scheduleId` int(11) DEFAULT NULL, `reScheduleId` int(11) DEFAULT NULL, `isGeneratePayroll` tinyint(1) NOT NULL DEFAULT '0', `payrollId` int(11) DEFAULT NULL, `fristBreak` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `secoundBreak` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `fristbreakhour` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secoundbreakhour` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `actualbreakhour` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punchInActualTimestamp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punchOutActualTimestamp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punchInLoaction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punchOutLoaction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isFacialPunchIn` tinyint(1) NOT NULL DEFAULT '0', `isFacialPunchOut` tinyint(1) NOT NULL DEFAULT '0', `punch_in_emp_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_emp_img` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_punch_details_records_created_by_foreign` (`created_by`), CONSTRAINT `employee_punch_details_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `employee_punch_details_records` -- LOCK TABLES `employee_punch_details_records` WRITE; /*!40000 ALTER TABLE `employee_punch_details_records` DISABLE KEYS */; /*!40000 ALTER TABLE `employee_punch_details_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employee_schedules` -- DROP TABLE IF EXISTS `employee_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employee_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `perentTableId` int(11) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `spansNextDay` tinyint(1) NOT NULL DEFAULT '0', `schedule_end_date` timestamp NULL DEFAULT NULL, `hourlySalary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `employee_schedules_created_by_foreign` (`created_by`), CONSTRAINT `employee_schedules_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `employee_schedules` -- LOCK TABLES `employee_schedules` WRITE; /*!40000 ALTER TABLE `employee_schedules` DISABLE KEYS */; /*!40000 ALTER TABLE `employee_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `enum_tables` -- DROP TABLE IF EXISTS `enum_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `enum_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `enum_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `enum_value` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `enum_tables_created_by_foreign` (`created_by`), CONSTRAINT `enum_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `enum_tables` -- LOCK TABLES `enum_tables` WRITE; /*!40000 ALTER TABLE `enum_tables` DISABLE KEYS */; INSERT INTO `enum_tables` VALUES (1,'country','Canada',NULL,1,1,NULL,0,'2026-01-30 08:53:09','2026-01-30 08:53:09'),(2,'province','Ontario',NULL,1,1,NULL,0,'2026-01-30 09:03:43','2026-01-30 09:03:43'),(3,'province','Alberta',NULL,1,1,NULL,0,'2026-01-30 09:24:05','2026-01-30 09:24:05'),(4,'city','Toronto',NULL,1,1,NULL,0,'2026-01-30 09:25:35','2026-01-30 09:25:35'),(5,'city','Ottawa',NULL,1,1,NULL,0,'2026-01-30 09:25:47','2026-01-30 09:25:47'),(6,'city','Oshawa',NULL,1,1,NULL,0,'2026-01-30 09:26:14','2026-01-30 09:26:14'),(7,'country','Us',NULL,1,1,NULL,0,'2026-02-28 10:07:12','2026-02-28 10:07:12'),(8,'city','Greensborough',NULL,1,1,NULL,0,'2026-04-01 10:26:35','2026-04-01 10:26:35'),(9,'city','Markham',NULL,1,1,NULL,0,'2026-04-01 10:39:06','2026-04-01 10:39:06'); /*!40000 ALTER TABLE `enum_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expense_categories` -- DROP TABLE IF EXISTS `expense_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expense_categories` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `expense_categories_name_unique` (`name`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expense_categories` -- LOCK TABLES `expense_categories` WRITE; /*!40000 ALTER TABLE `expense_categories` DISABLE KEYS */; INSERT INTO `expense_categories` VALUES (1,'Rent',NULL,'#ef4444',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(2,'Utilities',NULL,'#f59e0b',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(3,'Supplies',NULL,'#3b82f6',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(4,'Salary',NULL,'#8b5cf6',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(5,'Marketing',NULL,'#ec4899',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(6,'Insurance',NULL,'#14b8a6',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(7,'Technology',NULL,'#6366f1',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(8,'Maintenance',NULL,'#f97316',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'),(9,'Other',NULL,'#9ca3af',1,0,1,'2026-04-09 04:15:14','2026-04-09 04:15:14'); /*!40000 ALTER TABLE `expense_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `expenses` -- DROP TABLE IF EXISTS `expenses`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expenses` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `amount` decimal(12,2) NOT NULL, `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `category_id` bigint(20) unsigned DEFAULT NULL, `account_id` bigint(20) unsigned DEFAULT NULL, `expense_date` date NOT NULL, `vendor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `receipt_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_recurring` tinyint(1) NOT NULL DEFAULT '0', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'completed', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `expenses_category_expense_date_index` (`category`,`expense_date`), KEY `expenses_account_id_index` (`account_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `expenses` -- LOCK TABLES `expenses` WRITE; /*!40000 ALTER TABLE `expenses` DISABLE KEYS */; /*!40000 ALTER TABLE `expenses` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `grades` -- DROP TABLE IF EXISTS `grades`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `grades` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `grade` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `order_number` bigint(20) unsigned DEFAULT NULL, `notes` longtext COLLATE utf8mb4_unicode_ci, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `grades_grade_unique` (`grade`), KEY `grades_created_by_foreign` (`created_by`), CONSTRAINT `grades_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 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 */; INSERT INTO `grades` VALUES (1,'Grade 1',1,NULL,1,1,NULL,0,'2026-04-09 10:31:57','2026-04-09 10:31:57'),(2,'Grade 2',2,NULL,1,1,NULL,0,'2026-04-09 10:32:04','2026-04-09 10:32:04'),(3,'Grade 3',3,NULL,1,1,NULL,0,'2026-04-09 10:32:12','2026-04-09 10:32:12'),(4,'Grade 4',4,NULL,1,1,NULL,0,'2026-04-09 10:37:35','2026-04-09 10:37:35'),(5,'Grade 5',5,NULL,1,1,NULL,0,'2026-04-09 10:38:34','2026-04-09 10:38:34'); /*!40000 ALTER TABLE `grades` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `history_payroll_records` -- DROP TABLE IF EXISTS `history_payroll_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history_payroll_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `recordDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `normal_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `break_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overtime_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `history_payroll_records_created_by_foreign` (`created_by`), CONSTRAINT `history_payroll_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `history_payroll_records` -- LOCK TABLES `history_payroll_records` WRITE; /*!40000 ALTER TABLE `history_payroll_records` DISABLE KEYS */; /*!40000 ALTER TABLE `history_payroll_records` 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 = utf8 */; CREATE TABLE `invoice_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `invoiceId` bigint(20) unsigned NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `quantity` int(11) NOT NULL DEFAULT '1', `unitPrice` decimal(10,2) NOT NULL, `totalPrice` decimal(10,2) NOT NULL, `itemType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `relatedClassId` bigint(20) unsigned DEFAULT NULL, `relatedCourseId` bigint(20) unsigned DEFAULT NULL, `period_start` date DEFAULT NULL, `period_end` date DEFAULT NULL, `month_label` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `invoice_items_invoiceid_foreign` (`invoiceId`), KEY `idx_ii_related_class` (`relatedClassId`) ) ENGINE=MyISAM AUTO_INCREMENT=3 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 */; INSERT INTO `invoice_items` VALUES (2,2,'Monthly Tuition - April 2026',1,200.00,200.00,'monthly_tuition',NULL,NULL,'2026-04-01','2026-04-30','April 2026',0,'2026-04-13 23:23:39','2026-04-13 23:23:39'); /*!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 = utf8 */; CREATE TABLE `invoices` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `invoiceNumber` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `parentId` bigint(20) unsigned DEFAULT NULL, `issueDate` date NOT NULL, `dueDate` date NOT NULL, `subtotal` decimal(10,2) NOT NULL DEFAULT '0.00', `taxRate` decimal(5,2) NOT NULL DEFAULT '0.00', `taxAmount` decimal(10,2) NOT NULL DEFAULT '0.00', `discountAmount` decimal(10,2) NOT NULL DEFAULT '0.00', `totalAmount` decimal(10,2) NOT NULL DEFAULT '0.00', `paid_amount` decimal(12,2) NOT NULL DEFAULT '0.00', `balance_due` decimal(12,2) NOT NULL DEFAULT '0.00', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'draft', `notes` text COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `invoices_invoicenumber_unique` (`invoiceNumber`), KEY `invoices_status_index` (`status`), KEY `invoices_studentid_index` (`studentId`), KEY `idx_inv_student_issue` (`studentId`,`issueDate`), KEY `idx_inv_status_due` (`status`,`dueDate`) ) ENGINE=MyISAM AUTO_INCREMENT=3 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 (2,'INV-202604-001',2,NULL,'2026-04-13','2026-04-18',200.00,0.00,0.00,0.00,200.00,0.00,200.00,'pending','Auto-generated monthly invoice for April 2026',NULL,NULL,0,'2026-04-13 23:23:39','2026-04-13 23:23:39'); /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci 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 `light_theme_colors` -- DROP TABLE IF EXISTS `light_theme_colors`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `light_theme_colors` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `borderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `IconButtonBorderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cardBorderRadius` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `primary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secondary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `textPrimary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `textSecondary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `heading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `divider` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `topBar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `topBarHeading` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerHeader` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawer` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerHeadingText` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `drawerMenuText` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `background` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secondBackground` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cardBackground` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `editButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `editIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `viewButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `viewIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addButtonColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `addIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `thirdBgColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleteIconColor` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `orderListProp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `otherProp` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `light_theme_colors_created_by_foreign` (`created_by`), CONSTRAINT `light_theme_colors_created_by_foreign` FOREIGN KEY (`created_by`) 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 `light_theme_colors` -- LOCK TABLES `light_theme_colors` WRITE; /*!40000 ALTER TABLE `light_theme_colors` DISABLE KEYS */; INSERT INTO `light_theme_colors` VALUES (1,'4px','4px','none','#2f64a5','#00891f','#939393','#8c8c8c','#8c8c8c','#ecf8f5','#f9f7f7','#9a9999','#f9f7f7','#2f64a5','#a8b9c8','#fff','#f9f9f9','#fbfbfb','#ffffff','#ffffff','#dadada','#ffffff','#dadada','#ffffff','#00891f','#ffffff','#fcfcfd','#dadada',NULL,NULL,0,1,1,'2026-01-26 07:24:22','2026-02-27 23:49:51'); /*!40000 ALTER TABLE `light_theme_colors` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `location_tables` -- DROP TABLE IF EXISTS `location_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `location_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `location_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `location_address` longtext COLLATE utf8mb4_unicode_ci, `location_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `location_tables_created_by_foreign` (`created_by`), CONSTRAINT `location_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `location_tables` -- LOCK TABLES `location_tables` WRITE; /*!40000 ALTER TABLE `location_tables` DISABLE KEYS */; INSERT INTO `location_tables` VALUES (1,'Scarbrough',NULL,NULL,'#039b45',1,1,NULL,0,'2026-04-09 13:37:36','2026-04-09 13:37:36'),(2,'Oshawa',NULL,NULL,'#ffbdbd',1,1,NULL,0,'2026-04-09 13:37:50','2026-04-09 13:37:50'),(3,'Ajax',NULL,NULL,'#8baff9',1,1,NULL,0,'2026-04-09 13:38:01','2026-04-09 13:38:01'); /*!40000 ALTER TABLE `location_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mastery_maintenance_schedules` -- DROP TABLE IF EXISTS `mastery_maintenance_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mastery_maintenance_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `workflowPhaseId` bigint(20) unsigned NOT NULL, `intervalType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `duration` int(11) NOT NULL DEFAULT '4', `durationUnit` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'weeks', `isEnabled` tinyint(1) NOT NULL DEFAULT '1', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `mastery_maintenance_schedules_workflowphaseid_foreign` (`workflowPhaseId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mastery_maintenance_schedules` -- LOCK TABLES `mastery_maintenance_schedules` WRITE; /*!40000 ALTER TABLE `mastery_maintenance_schedules` DISABLE KEYS */; /*!40000 ALTER TABLE `mastery_maintenance_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mastery_workflow_phases` -- DROP TABLE IF EXISTS `mastery_workflow_phases`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mastery_workflow_phases` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `workflowId` bigint(20) unsigned NOT NULL, `phaseName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `transitionsTo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `minPercentCorrect` decimal(5,2) NOT NULL DEFAULT '100.00', `acrossSessions` int(11) NOT NULL DEFAULT '1', `minTrialsPerSession` int(11) NOT NULL DEFAULT '1', `advancedSettings` json DEFAULT NULL, `orderNumber` int(11) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `mastery_workflow_phases_workflowid_index` (`workflowId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mastery_workflow_phases` -- LOCK TABLES `mastery_workflow_phases` WRITE; /*!40000 ALTER TABLE `mastery_workflow_phases` DISABLE KEYS */; /*!40000 ALTER TABLE `mastery_workflow_phases` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mastery_workflows` -- DROP TABLE IF EXISTS `mastery_workflows`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mastery_workflows` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `workflowName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `objective` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Increase Percent Correct', `isDefault` tinyint(1) NOT NULL DEFAULT '0', `scope` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'organization', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mastery_workflows` -- LOCK TABLES `mastery_workflows` WRITE; /*!40000 ALTER TABLE `mastery_workflows` DISABLE KEYS */; /*!40000 ALTER TABLE `mastery_workflows` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `message_reads` -- DROP TABLE IF EXISTS `message_reads`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `message_reads` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `message_id` bigint(20) unsigned NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `read_at` timestamp NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `message_reads_message_id_user_id_unique` (`message_id`,`user_id`), KEY `message_reads_user_id_foreign` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `message_reads` -- LOCK TABLES `message_reads` WRITE; /*!40000 ALTER TABLE `message_reads` DISABLE KEYS */; /*!40000 ALTER TABLE `message_reads` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `messages` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `senderId` bigint(20) unsigned NOT NULL, `receiverId` bigint(20) unsigned NOT NULL, `subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body` text COLLATE utf8mb4_unicode_ci NOT NULL, `parentMessageId` bigint(20) unsigned DEFAULT NULL, `isReadBySender` tinyint(1) NOT NULL DEFAULT '1', `isReadByReceiver` tinyint(1) NOT NULL DEFAULT '0', `senderDeletedAt` timestamp NULL DEFAULT NULL, `receiverDeletedAt` timestamp NULL DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `messages_receiverid_foreign` (`receiverId`), KEY `messages_parentmessageid_foreign` (`parentMessageId`), KEY `messages_senderid_receiverid_index` (`senderId`,`receiverId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `messages` -- LOCK TABLES `messages` WRITE; /*!40000 ALTER TABLE `messages` DISABLE KEYS */; /*!40000 ALTER TABLE `messages` 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) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2024_08_21_144252_create_personal_access_tokens_table',1),(5,'2024_08_27_225744_create_settings_table',1),(6,'2024_10_17_164534_create_dark_theme_colors_table copy',1),(7,'2024_10_17_164534_create_light_theme_colors_table',1),(8,'2024_10_26_064218_create_departments_table',1),(9,'2024_11_15_154608_create_restaurants_table',1),(10,'2024_12_07_125030_create_privileges_table',1),(11,'2025_02_05_120419_create_user_roles_table',1),(12,'2025_03_05_140832_create_restaurant_schedules_table',1),(13,'2025_04_10_053603_create_teams_table',1),(14,'2025_04_10_053604_create_employee_biometrics_table',1),(15,'2025_04_10_053605_create_employee_punch_details_table',1),(16,'2025_04_10_053606_create_employee_schedules_table',1),(17,'2025_04_10_053607_create_positions_table',1),(18,'2025_04_10_053608_create_employee_punch_details_records_table',1),(19,'2025_04_10_053609_create_employee_delay_records_table',1),(20,'2025_04_10_053610_create_record_payroll_dates_table',1),(21,'2025_04_10_053611_create_history_payroll_records_table',1),(22,'2025_04_10_053612_create_emp_schedule_records_table',1),(23,'2025_04_10_053613_create_save_history_payroll_records_table',1),(24,'2025_04_10_053614_create_save_emp_punch_details_records_table',1),(25,'2025_04_10_053615_create_save_final_history_payroll_data_table',1),(26,'2025_04_10_053616_add_payroll_id_to_save_final_history_payroll_data_table',1),(27,'2025_04_10_053617_add_payroll_id_to_save_history_payroll_records_table',1),(28,'2025_04_10_053618_add_start_date_and_end_date_to_record_payroll_dates_table',1),(29,'2025_04_10_053619_add_payroll_id_to_save_emp_punch_details_records_table',1),(30,'2025_04_10_053620_add_is_payroll_generate_to_record_payroll_dates_table',1),(31,'2025_04_10_053621_modify_columns_in_total_break_hours',1),(32,'2025_04_10_053622_add_actual_punch_in_and_out_save_id',1),(33,'2025_04_10_053623_modify_columns_in_atual_punch_time',1),(34,'2025_04_10_053624_modify_columns_payrole_generate_and_is_cofirm',1),(35,'2025_04_10_053625_modify__payroldate_add_id_discription',1),(36,'2025_04_10_053626_edit_payroll_by_at_save_final_history_payroll_data',1),(37,'2025_04_12_164545_add_meeting__prop copy',1),(38,'2025_04_12_164546_add_light_theme_prop',1),(39,'2025_04_12_164547_add_dark_theme_prop',1),(40,'2025_04_12_164549_add_users_brachs_user_tabl',1),(41,'2025_04_12_164562_add_prop_emp_schedul_spansNextDay',1),(42,'2025_04_12_164563_add_prop_emp_schedul_record_spansNextDay',1),(43,'2025_04_12_164564_create_email_templets',1),(44,'2025_04_12_164565_create_email_save',1),(45,'2025_04_12_164566_add_prop_email_save_templet_multiple_type',1),(46,'2025_04_12_164567_create_email_save_record_staff',1),(47,'2025_04_12_164570_add_prop_employee_schedule_prop_add',1),(48,'2025_04_12_164572_add_pro_pseeting_pro_add_logo_and_width_add_background_im',1),(49,'2025_04_12_164573_add_prop_brack_emp_punch_breack_hour_update',1),(50,'2025_04_12_164574_add_prop_user_name _with_staff',1),(51,'2025_04_12_164575_create_History_employee_punch_details_records_table_update',1),(52,'2025_04_12_164576_add_employee_punch_details_is_delete',1),(53,'2025_04_12_164577_add_pro_seeting_login_punch_prop',1),(54,'2025_04_12_164578_add_employee_punch_details_latitude_',1),(55,'2025_04_12_164579_add_Punch_location_employee_punch_details_records',1),(56,'2025_04_12_164580_add_Punch_location_emp_admin_edit_punch_records ',1),(57,'2025_04_12_164581_facial_update_data_emp_bio_table',1),(58,'2025_04_12_164582_add_staff_email_sms_reminder',1),(59,'2025_04_12_164583_create_enum_table',1),(60,'2025_04_12_164584_create_History_out_of_location_records_histories',1),(61,'2025_04_12_164585_add_emp_img_record ',1),(62,'2025_04_12_164586_add_emp_img_Emp_Punch_record',1),(63,'2025_04_12_164592_add_onther_prop_email_templates_attachment',1),(64,'2025_04_12_164597_create_rechedule_responents',1),(65,'2025_04_12_164599_create_sms_save_record_staff',1),(66,'2025_04_12_164601_create_rechedule_record',1),(67,'2025_04_12_164602_add_other_prop_request',1),(68,'2025_04_12_164603_add_schedule_created_id_add',1),(69,'2025_04_12_164604_create_tags_table',1),(70,'2025_04_12_164606_create_students_Perents_table',1),(71,'2025_04_12_164607_create_grades_table',1),(72,'2025_04_12_164611_create_relationship_table',1),(73,'2025_04_12_164618_create_enum_table',1),(74,'2025_04_12_164619_create_locations_tables',1),(75,'2025_04_12_164620_create_subjects_tables',1),(76,'2025_04_12_164621_create_subjects_and_grate_table',1),(77,'2025_04_12_164621_create_subjects_and_grate_table copy',1),(78,'2025_04_12_164623_create_address_table copy',1),(79,'2025_04_12_164624_create_students_table',1),(80,'2025_04_12_164626_add_prop_tutorial_staff',1),(81,'2025_04_12_164629_add_prop_grade_Order_number',1),(82,'2025_04_12_164630_create_staff_Class_create',1),(83,'2025_04_12_164631_create_staff_Class_Schedules_create',1),(84,'2025_04_12_164632_create_student_subjects_and_grate_table ',1),(85,'2025_04_12_164633_add_other_prop_student_id',1),(86,'2025_04_12_164634_add_other_prop_student_id_sms',1),(87,'2025_04_12_164635_add_other_prop_location_colors',1),(88,'2025_04_12_164637_create_student_Class_create copy',1),(89,'2025_04_12_164638_create_staff_Class_create_histories',1),(90,'2025_04_13_000001_create_activity_logs_table',2),(91,'2025_04_13_000002_create_permissions_table',2),(92,'2025_04_13_000003_create_role_permissions_table',2),(93,'2025_04_13_000004_create_staff_availability_table',2),(94,'2025_04_13_000005_create_student_notes_table',2),(95,'2025_04_13_000006_create_notifications_table',2),(96,'2025_04_13_000007_create_messages_table',2),(97,'2025_04_13_000008_create_class_schedules_table',2),(98,'2025_04_13_000009_create_class_cancellations_table',2),(99,'2025_04_13_000010_create_attendance_records_table',2),(100,'2025_04_13_000011_create_courses_table',2),(101,'2025_04_13_000012_create_course_materials_table',2),(102,'2025_04_13_000013_create_assignments_table',2),(103,'2025_04_13_000014_create_assignment_submissions_table',2),(104,'2025_04_13_000015_create_payment_methods_table',2),(105,'2025_04_13_000016_create_invoices_table',2),(106,'2025_04_13_000017_create_invoice_items_table',2),(107,'2025_04_13_000018_create_payments_table',2),(108,'2025_04_13_000019_seed_new_privileges',3),(109,'2025_04_14_000001_create_program_folders_table',4),(110,'2025_04_14_000002_create_prompt_level_templates_table',4),(111,'2025_04_14_000003_create_prompt_levels_table',4),(112,'2025_04_14_000004_create_mastery_workflows_table',4),(113,'2025_04_14_000005_create_mastery_workflow_phases_table',4),(114,'2025_04_14_000006_create_mastery_maintenance_schedules_table',4),(115,'2025_04_14_000007_create_programs_table',4),(116,'2025_04_14_000008_create_program_targets_table',4),(117,'2025_04_14_000009_create_session_data_records_table',4),(118,'2025_04_14_000010_seed_hi_rasmus_privileges',4),(119,'2025_04_14_000011_add_is_primary_to_relationship_tables',5),(120,'2025_04_14_000012_create_student_assessments_table',6),(121,'2025_04_14_000013_create_student_challenges_table',6),(122,'2025_04_14_000014_create_student_strengths_table',6),(123,'2025_04_14_000015_add_late_tracking_to_attendance_records',7),(124,'2025_04_14_000016_create_tutoring_planners_table',8),(125,'2025_04_14_000017_create_parent_portal_tables',9),(126,'2025_04_15_000001_add_user_type_and_parent_id_to_users_table',10),(127,'2025_04_15_000002_sync_privileges_to_permissions_table',10),(128,'2025_04_15_000003_migrate_role_privileges_to_role_permissions',10),(129,'2025_04_15_000004_seed_default_roles_and_permissions',10),(130,'2025_04_15_000005_fix_role_permissions_integrity',11),(131,'2025_04_15_000006_fix_permission_name_consistency',12),(132,'2025_04_15_000007_correct_role_permission_assignments',13),(133,'2025_04_15_000008_drop_deprecated_auth_columns',14),(134,'2025_04_15_000009_create_chat_tables',15),(135,'2025_04_15_000010_add_billing_fields_to_students_table',16),(136,'2025_04_15_000011_create_financial_ledger_tables',17),(137,'2025_04_15_000012_add_financial_safeguards',18),(138,'2026_04_09_000001_add_per_class_rate_to_assign_student_classes',19),(139,'2026_04_11_204056_change_location_id_to_text_in_teams_table',20),(140,'2026_04_13_200000_add_invoiced_to_class_schedules',21),(141,'2026_04_13_200001_add_invoice_performance_indexes',22),(142,'2026_04_13_210000_create_class_requests_and_messages',23); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `notifications` -- DROP TABLE IF EXISTS `notifications`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `userId` bigint(20) unsigned NOT NULL, `notificationType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `message` text COLLATE utf8mb4_unicode_ci NOT NULL, `data` json DEFAULT NULL, `isRead` tinyint(1) NOT NULL DEFAULT '0', `readAt` timestamp NULL DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `notifications_userid_isread_index` (`userId`,`isRead`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `notifications` -- LOCK TABLES `notifications` WRITE; /*!40000 ALTER TABLE `notifications` DISABLE KEYS */; /*!40000 ALTER TABLE `notifications` 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 = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_methods` -- DROP TABLE IF EXISTS `payment_methods`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payment_methods` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `userId` bigint(20) unsigned DEFAULT NULL, `parentId` bigint(20) unsigned DEFAULT NULL, `methodType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `cardLast4` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `cardBrand` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `holderName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `expiryMonth` int(11) DEFAULT NULL, `expiryYear` int(11) DEFAULT NULL, `isDefault` tinyint(1) NOT NULL DEFAULT '0', `stripePaymentMethodId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payment_methods_parentid_index` (`parentId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_methods` -- LOCK TABLES `payment_methods` WRITE; /*!40000 ALTER TABLE `payment_methods` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_methods` 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 = utf8 */; CREATE TABLE `payments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `invoiceId` bigint(20) unsigned DEFAULT NULL, `studentId` bigint(20) unsigned NOT NULL, `parentId` bigint(20) unsigned DEFAULT NULL, `paymentMethodId` bigint(20) unsigned DEFAULT NULL, `amount` decimal(10,2) NOT NULL, `paymentDate` date NOT NULL, `paymentType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'full', `transactionId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `stripePaymentIntentId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'completed', `notes` text COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payments_studentid_status_index` (`studentId`,`status`), KEY `payments_invoiceid_index` (`invoiceId`) ) ENGINE=MyISAM 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 `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `permissionName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `permissionGroup` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `permissions_permissionname_unique` (`permissionName`) ) ENGINE=MyISAM AUTO_INCREMENT=44 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,'Dashboard_View','Dashboard',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(2,'Setting_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(3,'User_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(4,'Company_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(5,'Department_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(6,'User_Role_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(7,'Privilege_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(8,'Branch_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(9,'Theme_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(10,'Tax_View','Finance',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(11,'Other_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(12,'PunchDetails_View','Reports',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(13,'Schedule_View','Classes & Scheduling',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(14,'Payroll_View','Finance',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(15,'Staff_View','Staff Management',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(16,'Schedule_Edit','Classes & Scheduling',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(17,'Generate_Payroll','Finance',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(18,'Position_View','Staff Management',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(19,'email_view','Communication',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(20,'Student_View','Student Management',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(21,'Classes_View','Classes & Scheduling',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(22,'ClassSchedule_View','Classes & Scheduling','Class Schedule View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(23,'Attendance_View','Classes & Scheduling','Attendance View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(24,'Course_View','Programs & Curriculum','Course View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(25,'Assignment_View','Programs & Curriculum','Assignment View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(26,'Payment_View','Finance','Payment View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(27,'Invoice_View','Finance','Invoice View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(28,'Message_View','Communication','Message View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(29,'Notification_View','Communication','Notification View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(30,'Permission_View','System Administration','Permission View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(31,'ActivityLog_View','Reports','Activity Log View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(32,'StaffAvailability_View','Staff Management','Staff Availability View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(33,'StudentNote_View','Student Management','Student Note View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(34,'Report_View','Reports','Report View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(35,'Program_View','Programs & Curriculum','Program View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(36,'Program_Library_View','Programs & Curriculum','Program Library View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(37,'Workflow_View','Programs & Curriculum','Mastery Workflow View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(38,'PromptTemplate_View','Programs & Curriculum','Prompt Template View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(39,'SessionData_View','Programs & Curriculum','Session Data View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(40,'Parent_Portal_View','Portal Access','Parent Portal View',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(41,'System_Admin','System Administration','Full system administration access — replaces hardcoded super admin checks',0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(42,'tag_View','System Administration','Tag View',0,'2026-04-07 22:14:11','2026-04-07 22:14:11'),(43,'Punch_Admin','Staff Management','Operate biometric punch terminal — desktop login for attendance management',0,'2026-04-07 22:20:56','2026-04-07 22:20:56'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personal_access_tokens` -- DROP TABLE IF EXISTS `personal_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personal_access_tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tokenable_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL DEFAULT NULL, `expires_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `personal_access_tokens_token_unique` (`token`), KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`) ) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personal_access_tokens` -- LOCK TABLES `personal_access_tokens` WRITE; /*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */; INSERT INTO `personal_access_tokens` VALUES (1,'App\\Models\\User',1,'auth_token','c8d3dfc3476a1eddda594f2605987666aa7af8d70ffa489526bfceb1f3a29f9a','[\"*\"]','2026-01-26 07:25:20',NULL,'2026-01-26 07:25:13','2026-01-26 07:25:20'),(2,'App\\Models\\User',1,'auth_token','86f24e24d02017cc18495be708948928e2178061febde0f586411ec9fc3b1a5a','[\"*\"]','2026-02-03 07:59:03',NULL,'2026-01-26 08:17:31','2026-02-03 07:59:03'),(3,'App\\Models\\User',1,'auth_token','c353db3645878a79ef79fd5030d673f4fab1a074158ed75c65a7620eca0640f9','[\"*\"]','2026-02-03 07:59:43',NULL,'2026-02-03 07:59:42','2026-02-03 07:59:43'),(4,'App\\Models\\User',1,'auth_token','7a56f9c88cc511aae5d551112550958d2d4a6048c5d86a62366622eb20cc6b6c','[\"*\"]','2026-02-03 08:00:20',NULL,'2026-02-03 08:00:19','2026-02-03 08:00:20'),(5,'App\\Models\\User',1,'auth_token','218f12e09964fba0bc6e939f79b757750d4ddae22e31aa248c328a81f1b190f2','[\"*\"]','2026-02-03 08:00:35',NULL,'2026-02-03 08:00:34','2026-02-03 08:00:35'),(6,'App\\Models\\User',1,'auth_token','8a4ec334ce05db48e8e4afa93063eed667b51bd95124a1ae778828146846a61d','[\"*\"]','2026-02-03 08:00:50',NULL,'2026-02-03 08:00:49','2026-02-03 08:00:50'),(7,'App\\Models\\User',1,'auth_token','2c05afe45d0ea140e3af5a069709ed70c5b9526accfe06e712849448c11c1fd3','[\"*\"]','2026-02-03 08:01:22',NULL,'2026-02-03 08:01:21','2026-02-03 08:01:22'),(8,'App\\Models\\User',1,'auth_token','140bdefddef5ba9d24cd2eeb428c1da7792c49941977afc5a7e293350cfe3562','[\"*\"]','2026-02-03 08:02:18',NULL,'2026-02-03 08:01:37','2026-02-03 08:02:18'),(10,'App\\Models\\User',1,'auth_token','349e2b33d53d239d1f5e7ad66c8f7fbbd1e529047c215687cebfa5e50eb7656a','[\"*\"]','2026-02-03 08:52:40',NULL,'2026-02-03 08:03:45','2026-02-03 08:52:40'),(11,'App\\Models\\User',1,'auth_token','84476449aeb707bc3cd000b80913d43d5aeb8517f1bcf4d1fd97ef5ec921e3eb','[\"*\"]','2026-02-03 08:51:47',NULL,'2026-02-03 08:49:43','2026-02-03 08:51:47'),(12,'App\\Models\\User',1,'auth_token','82e0d3ff8a5c77b7918bd18290eda146bbeb7d114f4db6d9cf11d22f8d195742','[\"*\"]','2026-02-03 08:52:18',NULL,'2026-02-03 08:52:17','2026-02-03 08:52:18'),(13,'App\\Models\\User',1,'auth_token','a2e4cf6270ce039b7a348059f3707be642b5364a376f52e3a24c24c7dcfd2154','[\"*\"]','2026-02-03 08:52:50',NULL,'2026-02-03 08:52:49','2026-02-03 08:52:50'),(14,'App\\Models\\User',1,'auth_token','27ece740607d144c520147823dbd96d551ab9aefc648fcd3aa8c60aca02d3944','[\"*\"]','2026-02-03 09:00:14',NULL,'2026-02-03 08:56:48','2026-02-03 09:00:14'),(15,'App\\Models\\User',1,'auth_token','670f96cd08f85d6f2e1466213be7cc7afa98a0d80a019a670424ae188417cbaf','[\"*\"]','2026-02-03 20:45:47',NULL,'2026-02-03 08:57:07','2026-02-03 20:45:47'),(16,'App\\Models\\User',1,'auth_token','cca5fee52ae858061bdd6f01d8d15fc31f2fc57aa76e9d9a65aff4a5b6d52588','[\"*\"]','2026-02-03 08:57:56',NULL,'2026-02-03 08:57:55','2026-02-03 08:57:56'),(17,'App\\Models\\User',1,'auth_token','7f63fc210107f997c712c6813faf7f94e758f0bd902c380b297a8c77c46b0fb1','[\"*\"]','2026-02-03 08:58:25',NULL,'2026-02-03 08:58:24','2026-02-03 08:58:25'),(18,'App\\Models\\User',1,'auth_token','fb4dfd499e58a037beedb061f510bb4899d9a8c27833a5094668cdd0ea95ee82','[\"*\"]','2026-02-03 09:08:26',NULL,'2026-02-03 09:08:25','2026-02-03 09:08:26'),(19,'App\\Models\\User',1,'auth_token','8b3fe6d22b8a799c37af10e4d069ae34b6a88202a8a666254ad607bbd02df195','[\"*\"]','2026-02-28 09:55:15',NULL,'2026-02-03 20:46:17','2026-02-28 09:55:15'),(20,'App\\Models\\User',1,'auth_token','898a09247e793f2837a00426b08df79e1a24cb904e4679ce1a35d8ae7e884ca2','[\"*\"]','2026-02-27 22:12:09',NULL,'2026-02-06 05:46:43','2026-02-27 22:12:09'),(21,'App\\Models\\User',1,'auth_token','2cbc6356dce39e700cab0442ddf162cd1b0ee89422f3230aaf5327e9968010d7','[\"*\"]','2026-02-13 21:15:52',NULL,'2026-02-13 20:02:31','2026-02-13 21:15:52'),(22,'App\\Models\\User',1,'auth_token','c44baf030651f57e0aa341163f4e6f1e53d6c454bc3bdb6c1bdff7434e61a020','[\"*\"]','2026-02-27 22:19:23',NULL,'2026-02-27 22:14:18','2026-02-27 22:19:23'),(23,'App\\Models\\User',1,'auth_token','44dd743571da0e53ca858d09ca70b37998b8c333a28d060cbdc3cd31fa2f5fc9','[\"*\"]','2026-02-27 22:20:34',NULL,'2026-02-27 22:20:14','2026-02-27 22:20:34'),(24,'App\\Models\\User',1,'auth_token','d8989a7deaa05e9aceae518ee2492c22c962ba65430b5396a9504d72cf435be1','[\"*\"]','2026-02-27 22:24:09',NULL,'2026-02-27 22:22:20','2026-02-27 22:24:09'),(25,'App\\Models\\User',1,'auth_token','a1f9f798c3984cde578573d47681261e63fb6ac6fc3919931476011804fd905f','[\"*\"]','2026-02-27 22:27:13',NULL,'2026-02-27 22:24:25','2026-02-27 22:27:13'),(26,'App\\Models\\User',1,'auth_token','fa64584bd734d610a54d355d024ff0462aa263f2c71ce16bee078dd2ff36b6f4','[\"*\"]','2026-02-27 22:27:55',NULL,'2026-02-27 22:27:37','2026-02-27 22:27:55'),(27,'App\\Models\\User',1,'auth_token','138ca15a845c3d9a17c4669a0d73eea51c5300b6941f086d16b7c03bd1384606','[\"*\"]','2026-02-27 22:30:19',NULL,'2026-02-27 22:28:16','2026-02-27 22:30:19'),(28,'App\\Models\\User',1,'auth_token','ba735abc6d49b932779130c238cfffb95de78aeeee7a706882f87ea80fb6034c','[\"*\"]','2026-02-27 22:35:21',NULL,'2026-02-27 22:35:06','2026-02-27 22:35:21'),(29,'App\\Models\\User',1,'auth_token','c8c200333e9735b9dd8aae7cd65fd7c8c9588f0ba599597814adc21c30db1fe8','[\"*\"]','2026-02-27 23:49:01',NULL,'2026-02-27 22:41:50','2026-02-27 23:49:01'),(30,'App\\Models\\User',1,'auth_token','ae3b17b568372fce977b40ee16e3ca52d5288afb2d0286930aca731a3cbc6d60','[\"*\"]','2026-02-27 23:47:40',NULL,'2026-02-27 23:44:22','2026-02-27 23:47:40'),(31,'App\\Models\\User',1,'auth_token','dde7e246952fc84781e2936bf4ff02a3e5f2496b6b6f5052dc88babaf9e752ce','[\"*\"]','2026-02-27 23:48:20',NULL,'2026-02-27 23:48:11','2026-02-27 23:48:20'),(32,'App\\Models\\User',1,'auth_token','3d84e6b1d1950d41703b537ef3743a7939f9501de62fd181f4ffc63615f40800','[\"*\"]','2026-03-12 07:18:03',NULL,'2026-02-27 23:48:33','2026-03-12 07:18:03'),(33,'App\\Models\\User',1,'auth_token','65a442e46b17912b64f1dc4189de2683cecef56403e774036fb09b05e1bb9743','[\"*\"]','2026-02-27 23:57:28',NULL,'2026-02-27 23:57:23','2026-02-27 23:57:28'),(34,'App\\Models\\User',1,'auth_token','1e249558408c14bb977be2f525821d9ad0b1d61a58d7e2d7f90adeb10ec378a3','[\"*\"]','2026-02-27 23:58:06',NULL,'2026-02-27 23:57:51','2026-02-27 23:58:06'),(35,'App\\Models\\User',1,'auth_token','fd19ec0336ff29416bf66788cfbc08ea76dd70a7960600fb9ab45aa4dace1ab7','[\"*\"]','2026-02-28 22:10:55',NULL,'2026-02-28 00:00:26','2026-02-28 22:10:55'),(36,'App\\Models\\User',1,'auth_token','ddd452f0a260746699ecba95d883e99ab99be3d7bc1d497eb3d512a9d0718b7f','[\"*\"]','2026-02-28 00:29:40',NULL,'2026-02-28 00:29:23','2026-02-28 00:29:40'),(37,'App\\Models\\User',1,'auth_token','04ec7e037fcc5c7bb856bf01c89f72edbc8a052958a03de9ad3a9fcd889b96ba','[\"*\"]','2026-02-28 09:59:48',NULL,'2026-02-28 09:59:42','2026-02-28 09:59:48'),(38,'App\\Models\\User',1,'auth_token','44a31238c987f90d214398c414d45a619b6816d014bbdb52f12af132dced7e4c','[\"*\"]','2026-02-28 22:12:15',NULL,'2026-02-28 22:12:13','2026-02-28 22:12:15'),(39,'App\\Models\\User',1,'auth_token','3187dad2f13b3c90548fa55a9b2f0f70653f7b5db9eb54919761e25193654281','[\"*\"]','2026-02-28 22:39:11',NULL,'2026-02-28 22:12:25','2026-02-28 22:39:11'),(40,'App\\Models\\User',1,'auth_token','8767431d0bbf337da3623c13b9aa3976cbd036e10094df1250434f8e54a87ca8','[\"*\"]','2026-03-03 22:12:12',NULL,'2026-03-01 06:00:14','2026-03-03 22:12:12'),(41,'App\\Models\\User',1,'auth_token','2d5fd7bc356c616aab358031165f8e16652e9811d8d810a904a868b5096bde71','[\"*\"]','2026-03-27 15:30:41',NULL,'2026-03-02 08:12:23','2026-03-27 15:30:41'),(42,'App\\Models\\User',1,'auth_token','4e937640d089e384a1cedb7edf694f172de8ef503540543486b52d0c2502331b','[\"*\"]','2026-03-09 21:25:17',NULL,'2026-03-05 01:51:36','2026-03-09 21:25:17'),(43,'App\\Models\\User',1,'auth_token','5e5790c06e98e8740de4f60ceb721e943bb8745dfbddc26be4e8b12e723e02b2','[\"*\"]','2026-03-22 10:11:23',NULL,'2026-03-09 21:26:38','2026-03-22 10:11:23'),(44,'App\\Models\\User',1,'auth_token','e0315dfe6eec7a7f17637826e5ef189bd7b834757a6b8163ccf671794236e4c7','[\"*\"]','2026-03-18 04:46:08',NULL,'2026-03-18 03:59:49','2026-03-18 04:46:08'),(45,'App\\Models\\User',1,'auth_token','344f73b74b7d1cfe628bf3662a88b35d3a3285dd8eb8148ef6e5726178952184','[\"*\"]','2026-03-24 20:41:16',NULL,'2026-03-24 20:38:55','2026-03-24 20:41:16'),(46,'App\\Models\\User',1,'auth_token','5f26882a7caf05b17413ed8c1d19d17340706b855eb87fec9e5a182b743048dd','[\"*\"]','2026-03-29 11:12:59',NULL,'2026-03-28 09:07:23','2026-03-29 11:12:59'),(47,'App\\Models\\User',1,'auth_token','7fc9f0be0e4c2e11efeaae39fd17bc4046beaceb46e7e3b748d566bb5e38c885','[\"*\"]','2026-03-29 00:06:42',NULL,'2026-03-28 09:51:26','2026-03-29 00:06:42'),(48,'App\\Models\\User',1,'auth_token','d4ad46d2fdfaf3924e255c6a7bb3a753ceac71634fa72f456136abd3f2a36c75','[\"*\"]','2026-04-01 11:42:38',NULL,'2026-03-29 08:30:11','2026-04-01 11:42:38'),(49,'App\\Models\\User',1,'auth_token','f5dce8c087f451eb43accd095c6f04ae328d66f94a9e0285f178418406ea9b2f','[\"*\"]','2026-04-02 02:12:16',NULL,'2026-04-02 01:32:52','2026-04-02 02:12:16'),(50,'App\\Models\\User',1,'auth_token','717d08050b78187e0c03530a62b39b37de6cd49a32afb9ee4d7e423b4cc5d26d','[\"*\"]','2026-04-06 11:43:08',NULL,'2026-04-06 05:27:38','2026-04-06 11:43:08'),(51,'App\\Models\\User',1,'auth_token','4393de1e6862a801fd73ac115a4c23bee3cc535be681bca6930565388bfa20e2','[\"*\"]','2026-04-14 01:10:02',NULL,'2026-04-07 05:04:03','2026-04-14 01:10:02'),(52,'App\\Models\\User',1,'auth_token','456a74a296f432253a51aac430dd4559faef2925afddc9285d933fadab759e45','[\"*\"]',NULL,NULL,'2026-04-08 05:08:11','2026-04-08 05:08:11'),(53,'App\\Models\\User',1,'auth_token','3c148bfb0077fa21c8125945fbe85958f48e4f34b4749bd523d5ee7e1fdb0da8','[\"*\"]',NULL,NULL,'2026-04-08 05:09:15','2026-04-08 05:09:15'),(54,'App\\Models\\User',1,'auth_token','439d82c136acd24332b3389a1dbddbf5a6847a1f7cb8c382bb2751bd34863a1a','[\"*\"]','2026-04-08 05:11:04',NULL,'2026-04-08 05:11:04','2026-04-08 05:11:04'),(55,'App\\Models\\User',1,'auth_token','14edd444e595cb35589f2fabefc3886a0309fc2f6dc9f55dc42b49be1c1e4b58','[\"*\"]','2026-04-08 05:11:15',NULL,'2026-04-08 05:11:15','2026-04-08 05:11:15'),(58,'App\\Models\\User',1,'test','64efc6bf26c438d54e99b1815d5378cb772975cb5e1941916a11697e9bdc2c7f','[\"*\"]','2026-04-09 14:05:25',NULL,'2026-04-09 14:05:13','2026-04-09 14:05:25'),(59,'App\\Models\\User',2,'auth_token','b62bf7a6b31d508334096eea2a56a20d394578cdc13d54d96f42c96b72ef821b','[\"*\"]','2026-04-13 11:47:37',NULL,'2026-04-13 11:46:49','2026-04-13 11:47:37'),(61,'App\\Models\\User',2,'auth_token','5b827e23448da0e4da6880a3a058c5a8c2f06bb168573527c3051a28196879a8','[\"*\"]','2026-04-14 01:10:07',NULL,'2026-04-13 23:48:09','2026-04-14 01:10:07'),(62,'App\\Models\\User',2,'auth_token','201c69fd65ae06b27d49e99872c733f441b34e659eb3a599336e45c509224663','[\"*\"]','2026-04-14 04:01:25',NULL,'2026-04-14 01:10:21','2026-04-14 04:01:25'),(63,'App\\Models\\User',1,'auth_token','ce0e49414008c58c2102b53505a3eb2d71c8afbb5375d3b49fc4bb52a2d0e1de','[\"*\"]','2026-04-18 09:27:57',NULL,'2026-04-14 04:04:12','2026-04-18 09:27:57'),(64,'App\\Models\\User',2,'auth_token','6d883bc4f626da7527c38304c4d6de0cdc39ed9501302abecbd0469f6f0a30c5','[\"*\"]','2026-04-14 08:05:50',NULL,'2026-04-14 05:16:21','2026-04-14 08:05:50'),(65,'App\\Models\\User',4,'auth_token','fb4e3aed15a8184fcee6e118ee9aaf2c65d522ce01ca8954f903caef2cb24d88','[\"*\"]','2026-04-28 10:22:40',NULL,'2026-04-14 07:54:49','2026-04-28 10:22:40'),(66,'App\\Models\\User',6,'auth_token','e8bf6977a0948c121d3c3b0248f8ec8cb5467d19bdf9eb75a5558e1f160a05d1','[\"*\"]','2026-04-14 09:17:09',NULL,'2026-04-14 08:06:01','2026-04-14 09:17:09'),(67,'App\\Models\\User',1,'auth_token','700a2c1972945e454cde541b68eb18a964e5ee70a9d5bb0996c6ed64f10e80db','[\"*\"]','2026-04-21 23:13:58',NULL,'2026-04-21 06:58:38','2026-04-21 23:13:58'),(68,'App\\Models\\User',1,'auth_token','f6f8c8ec2b3520afda6945ff24cda9d92462e11d40331c1074ffcb5fafd7a51b','[\"*\"]','2026-04-28 10:22:40',NULL,'2026-04-28 09:04:07','2026-04-28 10:22:40'),(69,'App\\Models\\User',3,'auth_token','86cc2421e065b1008e4855182f56a234be21420bbd01eaad738744c561b66701','[\"*\"]','2026-04-28 10:22:36',NULL,'2026-04-28 09:36:55','2026-04-28 10:22:36'),(70,'App\\Models\\User',1,'auth_token','30f3d04fd89644939064919d63c0dbe51e35d5da1e1a91d33d40a52166172c0e','[\"*\"]','2026-05-02 03:30:37',NULL,'2026-05-01 19:53:23','2026-05-02 03:30:37'),(71,'App\\Models\\User',1,'auth_token','0a55e00deb1ac46ca37d5e6ab2a73b29115e0d12638a587291877d5be40f0be6','[\"*\"]','2026-06-14 08:30:07',NULL,'2026-06-01 05:12:57','2026-06-14 08:30:07'); /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `positions` -- DROP TABLE IF EXISTS `positions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `positions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `positionName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `positionDescription` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `positions_positionname_unique` (`positionName`), KEY `positions_created_by_foreign` (`created_by`), CONSTRAINT `positions_created_by_foreign` FOREIGN KEY (`created_by`) 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 `positions` -- LOCK TABLES `positions` WRITE; /*!40000 ALTER TABLE `positions` DISABLE KEYS */; INSERT INTO `positions` VALUES (1,'Teacher',NULL,1,NULL,0,'2026-04-12 00:34:34','2026-04-12 00:34:34'); /*!40000 ALTER TABLE `positions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `privileges` -- DROP TABLE IF EXISTS `privileges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `privileges` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `display_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `Description` longtext COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `privileges_name_unique` (`name`), KEY `privileges_created_by_foreign` (`created_by`), CONSTRAINT `privileges_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `privileges` -- LOCK TABLES `privileges` WRITE; /*!40000 ALTER TABLE `privileges` DISABLE KEYS */; INSERT INTO `privileges` VALUES (1,'Dashboard_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(2,'Setting_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(3,'User_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(4,'Company_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(5,'Department_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(6,'User_Role_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(7,'Privilege_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(8,'Branch_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(9,'Theme_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(10,'Tax_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(11,'Other_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(12,'PunchDetails_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(13,'Schedule_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(14,'Payroll_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(15,'Staff_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(16,'Schedule_Edit',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(17,'Generate_Payroll',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(18,'Position_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(19,'email_view',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(20,'Student_View',NULL,NULL,1,1,0,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(21,'Classes_View',NULL,NULL,1,NULL,0,'2026-01-30 20:17:04','2026-01-30 20:17:04'),(22,'ClassSchedule_View','Class Schedule View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(23,'Attendance_View','Attendance View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(24,'Course_View','Course View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(25,'Assignment_View','Assignment View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(26,'Payment_View','Payment View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(27,'Invoice_View','Invoice View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(28,'Message_View','Message View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(29,'Notification_View','Notification View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(30,'Permission_View','Permission View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(31,'ActivityLog_View','Activity Log View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(32,'StaffAvailability_View','Staff Availability View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(33,'StudentNote_View','Student Note View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(34,'Report_View','Report View',NULL,1,NULL,0,'2026-03-28 09:57:44','2026-03-28 09:57:44'),(35,'Program_View','Program View',NULL,1,NULL,0,'2026-03-28 10:32:13','2026-03-28 10:32:13'),(36,'Program_Library_View','Program Library View',NULL,1,NULL,0,'2026-03-28 10:32:13','2026-03-28 10:32:13'),(37,'Workflow_View','Mastery Workflow View',NULL,1,NULL,0,'2026-03-28 10:32:13','2026-03-28 10:32:13'),(38,'PromptTemplate_View','Prompt Template View',NULL,1,NULL,0,'2026-03-28 10:32:13','2026-03-28 10:32:13'),(39,'SessionData_View','Session Data View',NULL,1,NULL,0,'2026-03-28 10:32:13','2026-03-28 10:32:13'),(40,'Parent_Portal_View','Parent Portal View',NULL,1,NULL,0,'2026-04-06 09:56:33','2026-04-06 09:56:33'),(41,'tag_View','Tag View',NULL,1,NULL,0,'2026-04-07 22:14:11','2026-04-07 22:14:11'); /*!40000 ALTER TABLE `privileges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `program_folders` -- DROP TABLE IF EXISTS `program_folders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `program_folders` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `folderName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `parentFolderId` bigint(20) unsigned DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `orderNumber` int(11) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `program_folders_parentfolderid_index` (`parentFolderId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `program_folders` -- LOCK TABLES `program_folders` WRITE; /*!40000 ALTER TABLE `program_folders` DISABLE KEYS */; /*!40000 ALTER TABLE `program_folders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `program_targets` -- DROP TABLE IF EXISTS `program_targets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `program_targets` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `programId` bigint(20) unsigned NOT NULL, `targetName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `orderNumber` int(11) NOT NULL DEFAULT '0', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting', `sdType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sdText` text COLLATE utf8mb4_unicode_ci, `promptTemplateId` bigint(20) unsigned DEFAULT NULL, `measurementType` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `masteryWorkflowId` bigint(20) unsigned DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `program_targets_prompttemplateid_foreign` (`promptTemplateId`), KEY `program_targets_masteryworkflowid_foreign` (`masteryWorkflowId`), KEY `program_targets_programid_status_index` (`programId`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `program_targets` -- LOCK TABLES `program_targets` WRITE; /*!40000 ALTER TABLE `program_targets` DISABLE KEYS */; /*!40000 ALTER TABLE `program_targets` 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 = utf8 */; CREATE TABLE `programs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `programName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `folderId` bigint(20) unsigned DEFAULT NULL, `studentId` bigint(20) unsigned DEFAULT NULL, `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Skill Acquisition', `measurementType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Percent Correct', `objective` text COLLATE utf8mb4_unicode_ci, `baselineNotes` text COLLATE utf8mb4_unicode_ci, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'waiting', `masteryWorkflowId` bigint(20) unsigned DEFAULT NULL, `promptTemplateId` bigint(20) unsigned DEFAULT NULL, `authorName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tags` json DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `programs_masteryworkflowid_foreign` (`masteryWorkflowId`), KEY `programs_prompttemplateid_foreign` (`promptTemplateId`), KEY `programs_folderid_status_index` (`folderId`,`status`), KEY `programs_studentid_index` (`studentId`) ) ENGINE=MyISAM 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 */; /*!40000 ALTER TABLE `programs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prompt_level_templates` -- DROP TABLE IF EXISTS `prompt_level_templates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prompt_level_templates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `templateName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `objective` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Increase Percent Correct', `isDefault` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `prompt_level_templates` -- LOCK TABLES `prompt_level_templates` WRITE; /*!40000 ALTER TABLE `prompt_level_templates` DISABLE KEYS */; /*!40000 ALTER TABLE `prompt_level_templates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prompt_levels` -- DROP TABLE IF EXISTS `prompt_levels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prompt_levels` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `templateId` bigint(20) unsigned NOT NULL, `levelName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `score` decimal(5,2) NOT NULL DEFAULT '0.00', `orderNumber` int(11) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `prompt_levels_templateid_index` (`templateId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `prompt_levels` -- LOCK TABLES `prompt_levels` WRITE; /*!40000 ALTER TABLE `prompt_levels` DISABLE KEYS */; /*!40000 ALTER TABLE `prompt_levels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `punch_out_of_locations` -- DROP TABLE IF EXISTS `punch_out_of_locations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `punch_out_of_locations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `perentTableId` int(11) DEFAULT NULL, `empid` int(11) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reason` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `actualTimestamp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isFacialPunch` tinyint(1) NOT NULL DEFAULT '0', `loaction` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `punch_out_of_locations_created_by_foreign` (`created_by`), CONSTRAINT `punch_out_of_locations_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `punch_out_of_locations` -- LOCK TABLES `punch_out_of_locations` WRITE; /*!40000 ALTER TABLE `punch_out_of_locations` DISABLE KEYS */; /*!40000 ALTER TABLE `punch_out_of_locations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `record_payroll_dates` -- DROP TABLE IF EXISTS `record_payroll_dates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `record_payroll_dates` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `payrollGenerateId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `LastUpdateDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_normal_hours` decimal(10,2) DEFAULT NULL, `total_ot_hours` decimal(10,2) DEFAULT NULL, `total_hours` decimal(10,2) DEFAULT NULL, `gross_salary` decimal(10,2) DEFAULT NULL, `ot_salary` decimal(10,2) DEFAULT NULL, `bonus_amount` decimal(10,2) DEFAULT NULL, `total_salary` decimal(10,2) DEFAULT NULL, `isPayrollGenerate` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `description` longtext COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `record_payroll_dates_created_by_foreign` (`created_by`), CONSTRAINT `record_payroll_dates_created_by_foreign` FOREIGN KEY (`created_by`) 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 `record_payroll_dates` -- LOCK TABLES `record_payroll_dates` WRITE; /*!40000 ALTER TABLE `record_payroll_dates` DISABLE KEYS */; INSERT INTO `record_payroll_dates` VALUES (1,'PR260126-01','2026-01-26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,1,NULL,0,NULL,'2026-01-26 07:24:23','2026-01-26 07:24:23'); /*!40000 ALTER TABLE `record_payroll_dates` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `relationship_tables` -- DROP TABLE IF EXISTS `relationship_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `relationship_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned DEFAULT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `relationship_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isPrimary` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `relationship_tables_created_by_foreign` (`created_by`), CONSTRAINT `relationship_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `relationship_tables` -- LOCK TABLES `relationship_tables` WRITE; /*!40000 ALTER TABLE `relationship_tables` DISABLE KEYS */; INSERT INTO `relationship_tables` VALUES (1,NULL,1,NULL,0,1,NULL,0,'2026-01-30 08:43:47','2026-01-30 08:43:47'),(2,NULL,3,NULL,0,1,NULL,0,'2026-01-30 08:44:20','2026-01-30 08:44:20'),(3,NULL,5,NULL,0,1,NULL,0,'2026-01-30 08:51:34','2026-01-30 08:51:34'),(4,1,6,'Parent',0,1,1,1,'2026-01-30 09:30:56','2026-01-30 19:57:10'),(5,1,5,'Parent',0,1,1,0,'2026-01-30 19:57:10','2026-01-30 20:27:48'),(6,7,7,'Parent',0,1,1,0,'2026-02-28 10:09:16','2026-02-28 10:14:37'),(7,8,8,'Parent',0,1,1,0,'2026-03-03 21:58:45','2026-03-05 10:52:07'),(8,9,7,'Parent',0,1,1,0,'2026-04-01 10:40:55','2026-04-07 09:50:03'),(9,9,9,'Parent',0,1,NULL,0,'2026-04-01 10:40:55','2026-04-07 09:50:03'),(10,9,16,'Guardian',1,1,NULL,0,'2026-04-07 09:28:47','2026-04-07 09:50:03'),(11,1,1,'Parent',1,1,NULL,0,'2026-04-09 10:46:15','2026-04-09 10:46:15'),(12,2,1,'Parent',1,1,1,0,'2026-04-13 09:40:55','2026-04-13 10:21:14'),(13,3,1,'Parent',0,1,NULL,0,'2026-04-14 07:26:48','2026-04-14 07:26:48'),(14,3,2,'Parent',1,1,NULL,0,'2026-04-14 07:26:48','2026-04-14 07:26:48'),(15,4,2,'Other',0,1,NULL,0,'2026-06-01 07:16:31','2026-06-01 07:16:31'),(16,4,1,'Parent',1,1,1,0,'2026-06-01 07:16:31','2026-06-01 21:39:26'); /*!40000 ALTER TABLE `relationship_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `restaurant_schedules` -- DROP TABLE IF EXISTS `restaurant_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `restaurant_schedules` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `restaurantsId` int(11) DEFAULT NULL, `day` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hourlySalary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `restaurant_schedules_created_by_foreign` (`created_by`), CONSTRAINT `restaurant_schedules_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `restaurant_schedules` -- LOCK TABLES `restaurant_schedules` WRITE; /*!40000 ALTER TABLE `restaurant_schedules` DISABLE KEYS */; /*!40000 ALTER TABLE `restaurant_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `restaurants` -- DROP TABLE IF EXISTS `restaurants`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `restaurants` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `restaurantsName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `restaurantsPhoneNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsAltPhoneNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsStreetAddress` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsStreetAddress2` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsCity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsProvince` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsPostalCode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsWebsite` longtext COLLATE utf8mb4_unicode_ci, `restaurantsTakeout` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsDelivery` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsDeliveryFee` decimal(10,2) DEFAULT NULL, `restaurantsMiniDeliveryAmount` decimal(10,2) DEFAULT NULL, `restaurantsFreeDeliveryAmount` decimal(10,2) DEFAULT NULL, `restaurantsDeliveryRadius` decimal(10,2) DEFAULT NULL, `restaurantsDescription` longtext COLLATE utf8mb4_unicode_ci, `availability` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `restaurants_created_by_foreign` (`created_by`), CONSTRAINT `restaurants_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `restaurants` -- LOCK TABLES `restaurants` WRITE; /*!40000 ALTER TABLE `restaurants` DISABLE KEYS */; /*!40000 ALTER TABLE `restaurants` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_permissions` -- DROP TABLE IF EXISTS `role_permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `role_permissions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `roleId` bigint(20) unsigned NOT NULL, `permissionId` bigint(20) unsigned NOT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `role_permissions_roleid_permissionid_unique` (`roleId`,`permissionId`), KEY `role_permissions_permissionid_foreign` (`permissionId`) ) ENGINE=MyISAM AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_permissions` -- LOCK TABLES `role_permissions` WRITE; /*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */; INSERT INTO `role_permissions` VALUES (1,1,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(2,1,2,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(3,1,3,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(4,1,4,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(5,1,5,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(6,1,6,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(7,1,7,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(8,1,8,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(9,1,9,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(10,1,10,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(11,1,11,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(12,1,12,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(13,1,13,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(14,1,14,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(15,1,15,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(16,1,16,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(17,1,17,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(18,1,18,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(19,1,19,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(20,1,20,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(21,1,21,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(22,1,22,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(23,1,23,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(24,1,24,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(25,1,25,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(26,1,26,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(27,1,27,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(28,1,28,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(29,1,29,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(30,1,30,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(31,1,31,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(32,1,32,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(33,1,33,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(34,1,34,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(35,1,35,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(36,1,36,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(37,1,37,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(38,1,38,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(39,1,39,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(40,1,40,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(41,1,41,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(42,4,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(43,4,20,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(44,4,33,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(45,4,15,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(46,4,18,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(47,4,32,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(48,4,21,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(49,4,22,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(50,4,13,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(51,4,16,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(52,4,23,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(53,4,35,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(54,4,36,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(55,4,24,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(56,4,25,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(57,4,26,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(58,4,27,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(59,4,28,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(60,4,29,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(61,4,19,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(62,4,34,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(63,4,31,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(64,4,40,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(65,5,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(66,5,20,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(67,5,33,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(68,5,21,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(69,5,22,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(70,5,13,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(71,5,23,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(72,5,28,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(73,5,29,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(74,5,40,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(75,6,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(76,6,20,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(77,6,26,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(78,6,27,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(79,6,14,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(80,6,17,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(81,6,10,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(82,6,34,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(83,7,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(84,7,20,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(85,7,33,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(86,7,21,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(87,7,22,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(88,7,23,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(89,7,35,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(90,7,36,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(91,7,24,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(92,7,25,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(93,7,37,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(94,7,38,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(95,7,39,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(96,7,28,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(97,3,1,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(98,3,40,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(99,3,28,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(100,3,26,0,1,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(101,2,1,0,1,'2026-04-07 22:04:48','2026-04-07 22:04:48'),(102,2,20,0,1,'2026-04-07 22:04:48','2026-04-07 22:04:48'),(103,2,21,0,1,'2026-04-07 22:04:48','2026-04-07 22:04:48'),(104,2,23,0,1,'2026-04-07 22:04:48','2026-04-07 22:04:48'),(105,2,13,0,1,'2026-04-07 22:04:48','2026-04-07 22:04:48'),(106,1,42,0,1,'2026-04-07 22:14:11','2026-04-07 22:14:11'),(107,4,14,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(108,4,17,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(109,4,12,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(110,4,5,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(111,4,37,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(112,4,38,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(113,4,39,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(114,5,16,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(115,5,19,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(116,5,26,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(117,5,27,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(118,5,15,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(119,6,15,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(120,6,12,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(121,6,31,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(122,6,33,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(123,6,28,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(124,7,13,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(125,7,29,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(126,3,23,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(127,3,22,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(128,3,27,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(129,3,29,0,1,'2026-04-07 22:17:11','2026-04-07 22:17:11'),(130,1,43,0,1,'2026-04-07 22:20:56','2026-04-07 22:20:56'),(131,2,43,0,1,'2026-04-07 22:20:56','2026-04-07 22:20:56'); /*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `save_emp_punch_details_records` -- DROP TABLE IF EXISTS `save_emp_punch_details_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `save_emp_punch_details_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `payrollId` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `punch_in_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_in_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_in_actual_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_out_actual_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isSchedule` tinyint(1) NOT NULL DEFAULT '0', `scheduleId` int(11) DEFAULT NULL, `reScheduleId` int(11) DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `save_emp_punch_details_records_created_by_foreign` (`created_by`), CONSTRAINT `save_emp_punch_details_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `save_emp_punch_details_records` -- LOCK TABLES `save_emp_punch_details_records` WRITE; /*!40000 ALTER TABLE `save_emp_punch_details_records` DISABLE KEYS */; /*!40000 ALTER TABLE `save_emp_punch_details_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `save_final_history_payroll_data` -- DROP TABLE IF EXISTS `save_final_history_payroll_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `save_final_history_payroll_data` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `payrollId` int(11) DEFAULT NULL, `is_Edited` tinyint(1) NOT NULL DEFAULT '0', `employee_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `employee_position_id` int(11) DEFAULT NULL, `total_normal_hours` decimal(10,2) DEFAULT NULL, `hourly_salary` decimal(10,2) DEFAULT NULL, `total_ot_hours` decimal(10,2) DEFAULT NULL, `ot_hourly_salary` decimal(10,2) DEFAULT NULL, `total_break_hours` decimal(10,2) DEFAULT NULL, `total_hours` decimal(10,2) DEFAULT NULL, `gross_salary` decimal(10,2) DEFAULT NULL, `ot_salary` decimal(10,2) DEFAULT NULL, `bonus_amount` decimal(10,2) DEFAULT NULL, `bonus_adjustments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `total_salary` decimal(10,2) DEFAULT NULL, `edited_reason` longtext COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `edited_by` int(11) DEFAULT NULL, `edited_at` timestamp NULL DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `save_final_history_payroll_data_created_by_foreign` (`created_by`), CONSTRAINT `save_final_history_payroll_data_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `save_final_history_payroll_data` -- LOCK TABLES `save_final_history_payroll_data` WRITE; /*!40000 ALTER TABLE `save_final_history_payroll_data` DISABLE KEYS */; /*!40000 ALTER TABLE `save_final_history_payroll_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `save_history_payroll_records` -- DROP TABLE IF EXISTS `save_history_payroll_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `save_history_payroll_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `empid` int(11) DEFAULT NULL, `payrollId` int(11) DEFAULT NULL, `recordDate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `normal_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `break_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `overtime_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `total_hours` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `save_history_payroll_records_created_by_foreign` (`created_by`), CONSTRAINT `save_history_payroll_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `save_history_payroll_records` -- LOCK TABLES `save_history_payroll_records` WRITE; /*!40000 ALTER TABLE `save_history_payroll_records` DISABLE KEYS */; /*!40000 ALTER TABLE `save_history_payroll_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `session_data_records` -- DROP TABLE IF EXISTS `session_data_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `session_data_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `targetId` bigint(20) unsigned NOT NULL, `programId` bigint(20) unsigned NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `staffId` bigint(20) unsigned NOT NULL, `sessionDate` date NOT NULL, `sessionNumber` int(11) NOT NULL DEFAULT '1', `trialsCompleted` int(11) NOT NULL DEFAULT '0', `correctTrials` int(11) NOT NULL DEFAULT '0', `percentCorrect` decimal(5,2) NOT NULL DEFAULT '0.00', `promptLevelUsed` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `durationMinutes` int(11) DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `trialDetails` json DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `session_data_records_programid_foreign` (`programId`), KEY `session_data_records_staffid_foreign` (`staffId`), KEY `session_data_records_targetid_sessiondate_index` (`targetId`,`sessionDate`), KEY `session_data_records_studentid_programid_index` (`studentId`,`programId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `session_data_records` -- LOCK TABLES `session_data_records` WRITE; /*!40000 ALTER TABLE `session_data_records` DISABLE KEYS */; /*!40000 ALTER TABLE `session_data_records` 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(15) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int(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 `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `settings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `companyName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyProvince` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyCity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyPostalCode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyStreetNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyStreetName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyMobileNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyAltMobileNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyWebSiteLink` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyPaymentMethod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `companyLogo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `logowidthPrint` int(11) DEFAULT NULL, `backgroundImg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_login_background_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_login_font_color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_login_background_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `punch_slider_items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `companyDescription` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `settings_created_by_foreign` (`created_by`), CONSTRAINT `settings_created_by_foreign` FOREIGN KEY (`created_by`) 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 `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; INSERT INTO `settings` VALUES (1,'Step Up Academy','On','Scarborough','M1X 0C1','Unit #201','3785 Mcnicoll Ave','info@stepupacademy.ca','4168791987',NULL,'https://stepupacademy.ca/',NULL,'https://stepupnew.cacart.ca/backend/public/storage/images/Xr95TRD9bGVl8CC89CKPWomn7yCFjeBYDGU8cEh9.png',NULL,'https://stepupnew.cacart.ca/backend/public/storage/images/rmzdKZuFVc2PYNv6Y64Dbhv4WFL1vHUBFgQimDWk.png',NULL,NULL,'https://stepupnew.cacart.ca/backend/public/storage/images/LAPem5bJMbis7PTylS55WfzW19kfN56sJHADxAoe.png','[]',NULL,0,1,1,'2026-02-27 22:18:46','2026-02-27 22:35:20'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sms_send_records` -- DROP TABLE IF EXISTS `sms_send_records`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sms_send_records` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `staffId` int(11) DEFAULT NULL, `requestId` int(11) DEFAULT NULL, `student_id` bigint(20) unsigned DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `toMobileNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fromMobileNumber` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message` longtext COLLATE utf8mb4_unicode_ci, `error_message` longtext COLLATE utf8mb4_unicode_ci, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `isRequestRecord` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `sms_send_records_created_by_foreign` (`created_by`), CONSTRAINT `sms_send_records_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `sms_send_records` -- LOCK TABLES `sms_send_records` WRITE; /*!40000 ALTER TABLE `sms_send_records` DISABLE KEYS */; /*!40000 ALTER TABLE `sms_send_records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff_availability` -- DROP TABLE IF EXISTS `staff_availability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_availability` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `staffId` bigint(20) unsigned NOT NULL, `dayOfWeek` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `startTime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `endTime` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `isRecurring` tinyint(1) NOT NULL DEFAULT '1', `effectiveFrom` date DEFAULT NULL, `effectiveTo` date DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `staff_availability_staffid_dayofweek_index` (`staffId`,`dayOfWeek`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff_availability` -- LOCK TABLES `staff_availability` WRITE; /*!40000 ALTER TABLE `staff_availability` DISABLE KEYS */; /*!40000 ALTER TABLE `staff_availability` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff_grades_subject_tables` -- DROP TABLE IF EXISTS `staff_grades_subject_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff_grades_subject_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `staff_id` bigint(20) unsigned DEFAULT NULL, `subject_grade_id` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `staff_grades_subject_tables_created_by_foreign` (`created_by`), CONSTRAINT `staff_grades_subject_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff_grades_subject_tables` -- LOCK TABLES `staff_grades_subject_tables` WRITE; /*!40000 ALTER TABLE `staff_grades_subject_tables` DISABLE KEYS */; INSERT INTO `staff_grades_subject_tables` VALUES (1,1,9,1,1,0,'2026-04-09 13:53:38','2026-04-09 13:53:38'),(2,1,10,1,1,0,'2026-04-09 13:53:38','2026-04-09 13:53:38'),(3,1,11,1,1,0,'2026-04-09 13:53:38','2026-04-09 13:53:38'),(4,1,8,1,1,0,'2026-04-09 13:53:47','2026-04-09 13:53:47'),(5,1,3,1,1,0,'2026-04-09 13:53:54','2026-04-09 13:53:54'),(6,1,6,1,1,0,'2026-04-09 13:53:54','2026-04-09 13:53:54'),(7,1,7,1,1,0,'2026-04-09 13:53:54','2026-04-09 13:53:54'),(8,1,5,1,1,0,'2026-04-09 14:03:02','2026-04-09 14:03:02'),(9,1,2,1,1,0,'2026-04-09 14:03:02','2026-04-09 14:03:02'),(10,2,9,1,1,0,'2026-04-12 09:07:40','2026-04-12 09:07:40'),(11,2,10,1,1,0,'2026-04-12 09:07:40','2026-04-12 09:07:40'),(12,2,11,1,1,0,'2026-04-12 09:07:40','2026-04-12 09:07:40'),(13,3,3,1,1,0,'2026-04-14 07:43:52','2026-04-14 07:43:52'); /*!40000 ALTER TABLE `staff_grades_subject_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_assessments` -- DROP TABLE IF EXISTS `student_assessments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_assessments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `studentId` bigint(20) unsigned NOT NULL, `subjectId` bigint(20) unsigned DEFAULT NULL, `focusArea` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `assessmentDate` date NOT NULL, `maxValue` decimal(8,2) NOT NULL DEFAULT '100.00', `marksObtained` decimal(8,2) DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending', `comment1` text COLLATE utf8mb4_unicode_ci, `comment2` text COLLATE utf8mb4_unicode_ci, `comment3` text COLLATE utf8mb4_unicode_ci, `assessedBy` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `student_assessments_studentid_status_index` (`studentId`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_assessments` -- LOCK TABLES `student_assessments` WRITE; /*!40000 ALTER TABLE `student_assessments` DISABLE KEYS */; /*!40000 ALTER TABLE `student_assessments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_challenges` -- DROP TABLE IF EXISTS `student_challenges`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_challenges` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `studentId` bigint(20) unsigned NOT NULL, `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Academic', `priority` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Medium', `progress` int(11) NOT NULL DEFAULT '0', `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'in_progress', `startDate` date DEFAULT NULL, `targetDate` date DEFAULT NULL, `notes` text COLLATE utf8mb4_unicode_ci, `nextSteps` text COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `student_challenges_studentid_status_index` (`studentId`,`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_challenges` -- LOCK TABLES `student_challenges` WRITE; /*!40000 ALTER TABLE `student_challenges` DISABLE KEYS */; /*!40000 ALTER TABLE `student_challenges` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_grades_subject_tables` -- DROP TABLE IF EXISTS `student_grades_subject_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_grades_subject_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned DEFAULT NULL, `subject_grade_id` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `student_grades_subject_tables_created_by_foreign` (`created_by`), CONSTRAINT `student_grades_subject_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_grades_subject_tables` -- LOCK TABLES `student_grades_subject_tables` WRITE; /*!40000 ALTER TABLE `student_grades_subject_tables` DISABLE KEYS */; INSERT INTO `student_grades_subject_tables` VALUES (1,2,9,1,1,0,'2026-04-13 09:50:03','2026-04-13 09:50:03'),(2,2,10,1,1,0,'2026-04-13 09:50:03','2026-04-13 09:50:03'),(3,2,11,1,1,0,'2026-04-13 09:50:03','2026-04-13 09:50:03'),(4,3,3,1,1,0,'2026-04-14 07:29:55','2026-04-14 07:29:55'),(5,3,7,1,1,0,'2026-04-14 07:30:05','2026-04-14 07:30:05'); /*!40000 ALTER TABLE `student_grades_subject_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_notes` -- DROP TABLE IF EXISTS `student_notes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_notes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `studentId` bigint(20) unsigned NOT NULL, `noteType` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'general', `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `content` text COLLATE utf8mb4_unicode_ci NOT NULL, `isPinned` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `student_notes_studentid_index` (`studentId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_notes` -- LOCK TABLES `student_notes` WRITE; /*!40000 ALTER TABLE `student_notes` DISABLE KEYS */; /*!40000 ALTER TABLE `student_notes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_parents` -- DROP TABLE IF EXISTS `student_parents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_parents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `middle_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_email_notification` tinyint(1) NOT NULL DEFAULT '0', `is_sms_notification` tinyint(1) NOT NULL DEFAULT '0', `notes` longtext COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `student_parents_email_unique` (`email`), KEY `student_parents_created_by_foreign` (`created_by`), CONSTRAINT `student_parents_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_parents` -- LOCK TABLES `student_parents` WRITE; /*!40000 ALTER TABLE `student_parents` DISABLE KEYS */; INSERT INTO `student_parents` VALUES (1,'Dinesh',NULL,'Kunanayagam','6476671647','dinesh@vmwebs.com',1,1,NULL,1,NULL,0,'2026-04-09 10:45:12','2026-04-09 10:45:12'),(2,'Kalakcika',NULL,'Dinesh','6476671649','kalakcika2@gmail.com',1,1,NULL,1,NULL,0,'2026-04-14 07:22:30','2026-04-14 07:22:30'); /*!40000 ALTER TABLE `student_parents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `student_strengths` -- DROP TABLE IF EXISTS `student_strengths`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `student_strengths` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `studentId` bigint(20) unsigned NOT NULL, `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `area` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` text COLLATE utf8mb4_unicode_ci, `subjectId` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `student_strengths_studentid_type_index` (`studentId`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `student_strengths` -- LOCK TABLES `student_strengths` WRITE; /*!40000 ALTER TABLE `student_strengths` DISABLE KEYS */; /*!40000 ALTER TABLE `student_strengths` 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 = utf8 */; CREATE TABLE `students` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `reference_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `middle_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_of_birth` date DEFAULT NULL, `joined_month` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `grade_id` bigint(20) unsigned DEFAULT NULL, `billing_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'monthly', `monthly_fee` decimal(10,2) DEFAULT NULL, `per_class_rate` decimal(10,2) DEFAULT NULL, `billing_day` int(11) NOT NULL DEFAULT '1', `address_id` bigint(20) unsigned DEFAULT NULL, `relationship_id` bigint(20) unsigned DEFAULT NULL, `tag_id` bigint(20) unsigned DEFAULT NULL, `study_mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `country_id` bigint(20) unsigned DEFAULT NULL, `location_id` bigint(20) unsigned DEFAULT NULL, `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `heard_from` longtext COLLATE utf8mb4_unicode_ci, `notes` longtext COLLATE utf8mb4_unicode_ci, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDrop` tinyint(1) NOT NULL DEFAULT '0', `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `students_created_by_foreign` (`created_by`), CONSTRAINT `students_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=5 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,NULL,'Adhiran',NULL,'Dinesh','Active','Male','2018-04-29','2026-04-09',1,2,'monthly',NULL,NULL,1,1,11,NULL,'Offline',1,NULL,'http://127.0.0.1:8000/storage/images/Jq0AIkZWlY9XsfNlKFa4EwlZwi0Vk2maEmLJBRcc.jpg','Social Media',NULL,1,NULL,0,0,'2026-04-09 10:46:15','2026-04-09 10:46:15'),(2,NULL,'Inithan',NULL,'Dinesh','Active',NULL,NULL,NULL,NULL,5,'monthly',200.00,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,0,0,'2026-04-13 09:40:55','2026-04-13 22:30:13'),(3,NULL,'Thileep',NULL,'Dinesh','Active',NULL,NULL,NULL,NULL,3,'monthly',200.00,NULL,5,8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,0,0,'2026-04-14 07:26:48','2026-04-14 07:51:10'),(4,NULL,'Dinesh',NULL,'Kunanayagam','Active','Male','2022-04-29',NULL,1,2,'monthly',500.00,NULL,1,9,16,NULL,NULL,NULL,NULL,'http://127.0.0.1:8000/storage/images/OU6YlvKgnmn3JqMjj4yZdB7Y2yV6d4Tp7P4iPz4T.jpg',NULL,NULL,1,1,0,0,'2026-06-01 07:16:31','2026-06-01 21:39:26'); /*!40000 ALTER TABLE `students` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjects_grades_tables` -- DROP TABLE IF EXISTS `subjects_grades_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subjects_grades_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_id` bigint(20) unsigned DEFAULT NULL, `grade_id` bigint(20) unsigned DEFAULT NULL, `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `subjects_grades_tables_created_by_foreign` (`created_by`), CONSTRAINT `subjects_grades_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subjects_grades_tables` -- LOCK TABLES `subjects_grades_tables` WRITE; /*!40000 ALTER TABLE `subjects_grades_tables` DISABLE KEYS */; INSERT INTO `subjects_grades_tables` VALUES (1,1,1,1,NULL,0,'2026-04-09 10:32:31','2026-04-09 10:32:31'),(2,1,2,1,NULL,0,'2026-04-09 10:32:31','2026-04-09 10:32:31'),(3,1,3,1,NULL,0,'2026-04-09 10:32:31','2026-04-09 10:32:31'),(4,2,1,1,NULL,0,'2026-04-09 10:32:41','2026-04-09 10:32:41'),(5,2,2,1,NULL,0,'2026-04-09 10:32:41','2026-04-09 10:32:41'),(6,2,3,1,NULL,0,'2026-04-09 10:32:41','2026-04-09 10:32:41'),(7,3,3,1,NULL,0,'2026-04-09 10:32:52','2026-04-09 10:32:52'),(8,1,4,1,NULL,0,'2026-04-09 10:38:08','2026-04-09 10:38:08'),(9,3,5,1,NULL,0,'2026-04-09 10:38:34','2026-04-09 10:38:34'),(10,2,5,1,NULL,0,'2026-04-09 10:38:35','2026-04-09 10:38:35'),(11,1,5,1,NULL,0,'2026-04-09 10:38:35','2026-04-09 10:38:35'); /*!40000 ALTER TABLE `subjects_grades_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjects_tables` -- DROP TABLE IF EXISTS `subjects_tables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subjects_tables` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `subjects_tables_created_by_foreign` (`created_by`), CONSTRAINT `subjects_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) 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_tables` -- LOCK TABLES `subjects_tables` WRITE; /*!40000 ALTER TABLE `subjects_tables` DISABLE KEYS */; INSERT INTO `subjects_tables` VALUES (1,'Math',1,1,NULL,0,'2026-04-09 10:32:31','2026-04-09 10:32:31'),(2,'English',1,1,NULL,0,'2026-04-09 10:32:41','2026-04-09 10:32:41'),(3,'Science',1,1,NULL,0,'2026-04-09 10:32:52','2026-04-09 10:32:52'); /*!40000 ALTER TABLE `subjects_tables` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tags` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `tagName` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `isActive` tinyint(1) NOT NULL DEFAULT '1', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `tags_tagname_unique` (`tagName`), KEY `tags_created_by_foreign` (`created_by`), CONSTRAINT `tags_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`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 `tags` -- LOCK TABLES `tags` WRITE; /*!40000 ALTER TABLE `tags` DISABLE KEYS */; /*!40000 ALTER TABLE `tags` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `teams` -- DROP TABLE IF EXISTS `teams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `teams` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `teamMobileNum` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `restaurantsId` int(11) DEFAULT NULL, `userPerentTableId` int(11) DEFAULT NULL, `teamDepartmentId` int(11) DEFAULT NULL, `teamPositionId` int(11) DEFAULT NULL, `teamHourlySalary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamOtHourlySalary` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamFirstName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `middle_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamLastName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_id` bigint(20) unsigned DEFAULT NULL, `location_id` text COLLATE utf8mb4_unicode_ci, `mode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamImg` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamStreet` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamCity` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamProvince` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamPostalCode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamAddress` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamAltMobileNum` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamEmail` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamUserName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_credential_reminder` tinyint(1) NOT NULL DEFAULT '0', `sms_credential_reminder` tinyint(1) NOT NULL DEFAULT '0', `is_class_reminder` tinyint(1) NOT NULL DEFAULT '0', `teamPassWord` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `teamDescription` longtext COLLATE utf8mb4_unicode_ci, `smsReminder` tinyint(1) NOT NULL DEFAULT '1', `emailReminder` tinyint(1) NOT NULL DEFAULT '1', `availability` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned NOT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `teams_created_by_foreign` (`created_by`), CONSTRAINT `teams_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `teams` -- LOCK TABLES `teams` WRITE; /*!40000 ALTER TABLE `teams` DISABLE KEYS */; INSERT INTO `teams` VALUES (1,'6476671647','001235',NULL,2,1,1,'20','30','Afzal',NULL,'Mohamed',NULL,'Male',2,'[3,2,1]','Online,InPerson','http://127.0.0.1:8000/storage/images/1kvCDYsBifASCCLFi62hTWFbhKJtsMkmma7uhbgk.jpg',NULL,NULL,NULL,NULL,NULL,NULL,'afzal@gmail.com',NULL,0,0,1,NULL,NULL,1,1,'[{\"day\":\"Sunday\",\"timeSlots\":[]},{\"day\":\"Monday\",\"timeSlots\":[]},{\"day\":\"Tuesday\",\"timeSlots\":[]},{\"day\":\"Wednesday\",\"timeSlots\":[]},{\"day\":\"Thursday\",\"timeSlots\":[]},{\"day\":\"Friday\",\"timeSlots\":[]},{\"day\":\"Saturday\",\"timeSlots\":[]}]',0,1,1,'2026-04-09 13:36:02','2026-04-12 01:18:14'),(2,'6476671649','S260412001',NULL,3,1,1,'20','29','David',NULL,'Rattno',NULL,'Male',3,'[3,1]','InPerson','http://127.0.0.1:8000/storage/images/dpyj4U0257HIgwZWA6YmQL2QIrq5Gg4JjqvB6OS5.jpg',NULL,NULL,NULL,NULL,NULL,NULL,'david@gmail.com',NULL,0,0,1,NULL,NULL,1,1,'[{\"day\":\"Sunday\",\"timeSlots\":[]},{\"day\":\"Monday\",\"timeSlots\":[]},{\"day\":\"Tuesday\",\"timeSlots\":[]},{\"day\":\"Wednesday\",\"timeSlots\":[]},{\"day\":\"Thursday\",\"timeSlots\":[]},{\"day\":\"Friday\",\"timeSlots\":[]},{\"day\":\"Saturday\",\"timeSlots\":[]}]',0,1,1,'2026-04-12 09:06:52','2026-04-13 20:39:26'),(3,'6476681647','S260414001',NULL,6,1,1,'20','30','Rukshanth',NULL,'David',NULL,'Male',7,'[1,3]','InPerson','http://127.0.0.1:8000/storage/images/a7kR5tU6lI9M8BUzAVZ9x7zfFlRWzZilwZGwBs9h.jpg',NULL,NULL,NULL,NULL,NULL,NULL,'rukshanth@gmail.com',NULL,0,0,1,NULL,NULL,1,1,'[{\"day\":\"Sunday\",\"timeSlots\":[]},{\"day\":\"Monday\",\"timeSlots\":[]},{\"day\":\"Tuesday\",\"timeSlots\":[]},{\"day\":\"Wednesday\",\"timeSlots\":[]},{\"day\":\"Thursday\",\"timeSlots\":[]},{\"day\":\"Friday\",\"timeSlots\":[]},{\"day\":\"Saturday\",\"timeSlots\":[]}]',0,1,NULL,'2026-04-14 07:43:10','2026-04-14 07:43:11'); /*!40000 ALTER TABLE `teams` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `transactions` -- DROP TABLE IF EXISTS `transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transactions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `reference_no` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` bigint(20) unsigned NOT NULL, `type` enum('credit','debit') COLLATE utf8mb4_unicode_ci NOT NULL, `amount` decimal(12,2) NOT NULL, `balance_after` decimal(12,2) NOT NULL, `category` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source_id` bigint(20) unsigned DEFAULT NULL, `transaction_date` date NOT NULL, `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `txn_source_unique` (`source_type`,`source_id`,`type`), KEY `transactions_account_id_transaction_date_index` (`account_id`,`transaction_date`), KEY `transactions_source_type_source_id_index` (`source_type`,`source_id`), KEY `transactions_category_index` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `transactions` -- LOCK TABLES `transactions` WRITE; /*!40000 ALTER TABLE `transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `transactions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tutoring_planners` -- DROP TABLE IF EXISTS `tutoring_planners`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tutoring_planners` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `classScheduleId` bigint(20) unsigned NOT NULL, `staffId` bigint(20) unsigned NOT NULL, `studentId` bigint(20) unsigned NOT NULL, `plannerDate` date NOT NULL, `schoolFocus` text COLLATE utf8mb4_unicode_ci, `assignedHomework` text COLLATE utf8mb4_unicode_ci, `homeworkDone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'no', `challengesNextSteps` text COLLATE utf8mb4_unicode_ci, `plannerNotes` text COLLATE utf8mb4_unicode_ci, `futurePlan` text COLLATE utf8mb4_unicode_ci, `sendReminder` tinyint(1) NOT NULL DEFAULT '0', `reminderMethod` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isSubmitted` tinyint(1) NOT NULL DEFAULT '0', `submittedAt` timestamp NULL DEFAULT NULL, `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `tutoring_planners_studentid_foreign` (`studentId`), KEY `tutoring_planners_staffid_plannerdate_index` (`staffId`,`plannerDate`), KEY `tutoring_planners_classscheduleid_index` (`classScheduleId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tutoring_planners` -- LOCK TABLES `tutoring_planners` WRITE; /*!40000 ALTER TABLE `tutoring_planners` DISABLE KEYS */; /*!40000 ALTER TABLE `tutoring_planners` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_roles` -- DROP TABLE IF EXISTS `user_roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `roleName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `privileges` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_roles_created_by_foreign` (`created_by`), CONSTRAINT `user_roles_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_roles` -- LOCK TABLES `user_roles` WRITE; /*!40000 ALTER TABLE `user_roles` DISABLE KEYS */; INSERT INTO `user_roles` VALUES (1,'Super Admin',NULL,0,NULL,NULL,NULL,NULL),(2,'Attendance Manager',NULL,0,NULL,NULL,NULL,NULL),(3,'Parent','[]',0,1,NULL,'2026-04-06 09:56:33','2026-04-06 09:56:33'),(4,'Staff - Manager','[]',0,1,NULL,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(5,'Staff - Front Desk','[]',0,1,NULL,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(6,'Staff - Finance','[]',0,1,NULL,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(7,'Staff - Tutor','[]',0,1,NULL,'2026-04-07 21:55:47','2026-04-07 21:55:47'); /*!40000 ALTER TABLE `user_roles` 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, `username` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `user_type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'employee', `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `desktop_password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `user_role` int(11) NOT NULL, `restaurantsId` int(11) DEFAULT NULL, `staffId` int(11) DEFAULT NULL, `parent_id` bigint(20) unsigned DEFAULT NULL, `branchIds` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `isDelete` tinyint(1) NOT NULL DEFAULT '0', `status` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active', `must_change_password` tinyint(1) NOT NULL DEFAULT '0', `created_by` bigint(20) unsigned DEFAULT NULL, `updated_by` bigint(20) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_username_unique` (`username`), KEY `users_created_by_foreign` (`created_by`), KEY `users_user_type_index` (`user_type`), KEY `users_parent_id_index` (`parent_id`), KEY `users_status_index` (`status`), CONSTRAINT `users_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=7 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,'stepupadmin@gmail.com','employee','$2y$12$K8wE9i3k8gH7FCsZYvgS6emB0mqqphBdCORz88PqsZsOc83oHBF2m','',1,NULL,NULL,NULL,NULL,NULL,0,'active',0,NULL,NULL,'2026-01-26 07:24:22','2026-01-26 07:24:22'),(2,'afzal@gmail.com','employee','$2y$12$tJY.Arq1MrtHTi6k/XT8f.4PbA3NTTFyh.XaPWPD2R1XRXXz5Rxtu','$2y$12$UXOJI06BSu4okG/mpJHmCeZTn/7uUZCtgSzlmRjEbhj8h5s1nmlti',7,NULL,1,NULL,NULL,NULL,0,'active',1,1,NULL,'2026-04-12 01:18:14','2026-04-12 01:18:14'),(3,'david@gmail.com','employee','$2y$12$Ip4uKqDA7AQFFdDd2jEm/exz23PY8yDyypaxiPZ90CaC3sSNMK/f.','$2y$12$iA1iB1N7li3piipM41P4eOyNfDlT451OfHMdtwdODcTQpWx/pC/UG',7,NULL,2,NULL,NULL,NULL,0,'active',1,1,1,'2026-04-12 09:06:52','2026-04-28 09:32:42'),(4,'dinesh@vmwebs.com','parent','$2y$12$K1LbSc7hBuIJZEqw6uY8OuaKGFZYlMzNm5XOD1eHzkxdLFgRTOt1C','$2y$12$37mdyV2iO1Gdad/pVufyFe27fT524DQ1yGX0PURXxXGO1xacSU7FG',3,NULL,NULL,1,NULL,NULL,0,'active',1,1,1,'2026-04-13 23:13:38','2026-04-14 07:29:14'),(5,'kalakcika2@gmail.com','parent','$2y$12$IENBNs8aS/aFYNK9pR5z2.C4uzrQKxz2ZAfW4uOdH7cN69g18I7Ae','$2y$12$QWomANITNkjGLRM9dL/AFuMoQ9I043FS66/KOSquUWiBZ412pO7gm',3,NULL,NULL,2,NULL,NULL,0,'active',1,1,NULL,'2026-04-14 07:28:01','2026-04-14 07:28:01'),(6,'rukshanth@gmail.com','employee','$2y$12$WEKg6HgLjdYw5WDyeYjElO9A9ycpR4C36vhC2z6E9dD58KijKNOpm','$2y$12$oMI.etlZNSfluDLVmSYLnOK2wV1tNarmfBnSk9l7XE4yfpXq.P.jm',7,NULL,3,NULL,NULL,NULL,0,'active',1,1,NULL,'2026-04-14 07:43:11','2026-04-14 07:43:11'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'stepup_admin_db' -- /*!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-06-14 0:30:08