-- MySQL dump 10.13 Distrib 5.7.44, for Win64 (x86_64) -- -- 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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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=3 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,'password_reset_email','Reset your Step Up password','

Hi {{name}},

Click the link below to reset your password:

{{reset_link}}

This link expires in {{expiry_minutes}} minutes. If you did not request this, please ignore this email.

',NULL,NULL,NULL,0,1,NULL,'2026-06-14 09:54:08','2026-06-14 09:54:08'),(2,'password_reset_sms','Password reset code','Your Step Up password reset code is {{code}} (valid {{expiry_minutes}} minutes).',NULL,NULL,NULL,0,1,NULL,'2026-06-14 09:54:08','2026-06-14 09:54:08'); /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grades` -- LOCK TABLES `grades` WRITE; /*!40000 ALTER TABLE `grades` DISABLE KEYS */; /*!40000 ALTER TABLE `grades` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoice_items` -- LOCK TABLES `invoice_items` WRITE; /*!40000 ALTER TABLE `invoice_items` DISABLE KEYS */; /*!40000 ALTER TABLE `invoice_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = 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 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 */; /*!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 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 */; /*!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 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 */; /*!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=147 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),(143,'2026_06_14_000010_create_password_otps_table',24),(144,'2026_06_14_000011_widen_password_reset_tokens',25),(145,'2026_06_14_000020_seed_crud_permission_matrix',26),(146,'2026_06_14_000021_seed_default_role_permission_matrix',27); /*!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_otps` -- DROP TABLE IF EXISTS `password_otps`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_otps` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `reset_token` varchar(80) COLLATE utf8mb4_unicode_ci NOT NULL, `channel` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `destination` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `otp_hash` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint(3) unsigned NOT NULL DEFAULT '0', `expires_at` timestamp NOT NULL, `verified_at` timestamp NULL DEFAULT NULL, `used_at` timestamp NULL DEFAULT NULL, `last_sent_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `password_otps_reset_token_unique` (`reset_token`), KEY `password_otps_user_id_used_at_index` (`user_id`,`used_at`), KEY `password_otps_user_id_index` (`user_id`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_otps` -- LOCK TABLES `password_otps` WRITE; /*!40000 ALTER TABLE `password_otps` DISABLE KEYS */; /*!40000 ALTER TABLE `password_otps` 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(191) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `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=200 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-06-17 21:17:43'),(2,'Setting_View','Admin',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(3,'User_View','Admin',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(4,'Company_View','System Administration',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(5,'Department_View','Staff / HR',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(6,'User_Role_View','Admin',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(7,'Privilege_View','Admin',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(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','Staff / HR',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(13,'Schedule_View','Classes & Scheduling',NULL,0,'2026-04-07 21:55:47','2026-04-07 21:55:47'),(14,'Payroll_View','Staff / HR',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(15,'Staff_View','Staff / HR',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(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 / HR',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(19,'email_view','Communication',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(20,'Student_View','Student Management',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(21,'Classes_View','Academic',NULL,0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(22,'ClassSchedule_View','Academic','Class Schedule View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(23,'Attendance_View','Academic','Attendance View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(24,'Course_View','Academic','Course View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(25,'Assignment_View','Academic','Assignment View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(26,'Payment_View','Finance','Payment View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(27,'Invoice_View','Finance','Invoice View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(28,'Message_View','Communication','Message View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(29,'Notification_View','Communication','Notification View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(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 / HR','Staff Availability View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(33,'StudentNote_View','Student Management','Student Note View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(34,'Report_View','Reports','Report View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(35,'Program_View','ABA Therapy','Program View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(36,'Program_Library_View','ABA Therapy','Program Library View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(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','ABA Therapy','Session Data View',0,'2026-04-07 21:55:47','2026-06-17 21:17:43'),(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','Student Management','Tag View',0,'2026-04-07 22:14:11','2026-06-17 21:17:43'),(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'),(44,'Dashboard_Create','Dashboard','Dashboard — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(45,'Dashboard_Edit','Dashboard','Dashboard — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(46,'Dashboard_Delete','Dashboard','Dashboard — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(47,'Student_Create','Student Management','Students — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(48,'Student_Edit','Student Management','Students — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(49,'Student_Delete','Student Management','Students — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(50,'Parent_View','Student Management','Parents — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(51,'Parent_Create','Student Management','Parents — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(52,'Parent_Edit','Student Management','Parents — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(53,'Parent_Delete','Student Management','Parents — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(54,'StudentRelationship_View','Student Management','Student Relationships — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(55,'StudentRelationship_Create','Student Management','Student Relationships — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(56,'StudentRelationship_Edit','Student Management','Student Relationships — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(57,'StudentRelationship_Delete','Student Management','Student Relationships — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(58,'StudentNote_Create','Student Management','Student Notes — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(59,'StudentNote_Edit','Student Management','Student Notes — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(60,'StudentNote_Delete','Student Management','Student Notes — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(61,'Tag_Create','Student Management','Student Tags — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(62,'Tag_Edit','Student Management','Student Tags — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(63,'Tag_Delete','Student Management','Student Tags — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(64,'Classes_Create','Academic','Classes — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(65,'Classes_Edit','Academic','Classes — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(66,'Classes_Delete','Academic','Classes — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(67,'ClassSchedule_Create','Academic','Class Schedules — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(68,'ClassSchedule_Edit','Academic','Class Schedules — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(69,'ClassSchedule_Delete','Academic','Class Schedules — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(70,'Subject_View','Academic','Subjects — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(71,'Subject_Create','Academic','Subjects — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(72,'Subject_Edit','Academic','Subjects — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(73,'Subject_Delete','Academic','Subjects — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(74,'Grade_View','Academic','Grades — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(75,'Grade_Create','Academic','Grades — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(76,'Grade_Edit','Academic','Grades — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(77,'Grade_Delete','Academic','Grades — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(78,'Attendance_Create','Academic','Attendance — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(79,'Attendance_Edit','Academic','Attendance — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(80,'Attendance_Delete','Academic','Attendance — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(81,'AttendanceRecord_View','Academic','Attendance Records — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(82,'AttendanceRecord_Create','Academic','Attendance Records — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(83,'AttendanceRecord_Edit','Academic','Attendance Records — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(84,'AttendanceRecord_Delete','Academic','Attendance Records — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(85,'Course_Create','Academic','Courses — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(86,'Course_Edit','Academic','Courses — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(87,'Course_Delete','Academic','Courses — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(88,'Assignment_Create','Academic','Assignments — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(89,'Assignment_Edit','Academic','Assignments — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(90,'Assignment_Delete','Academic','Assignments — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(91,'Program_Library_Create','ABA Therapy','Program Library — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(92,'Program_Library_Edit','ABA Therapy','Program Library — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(93,'Program_Library_Delete','ABA Therapy','Program Library — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(94,'Program_Create','ABA Therapy','Programs — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(95,'Program_Edit','ABA Therapy','Programs — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(96,'Program_Delete','ABA Therapy','Programs — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(97,'ProgramTarget_View','ABA Therapy','Program Targets — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(98,'ProgramTarget_Create','ABA Therapy','Program Targets — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(99,'ProgramTarget_Edit','ABA Therapy','Program Targets — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(100,'ProgramTarget_Delete','ABA Therapy','Program Targets — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(101,'SessionData_Create','ABA Therapy','Session Data — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(102,'SessionData_Edit','ABA Therapy','Session Data — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(103,'SessionData_Delete','ABA Therapy','Session Data — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(104,'Mastery_View','ABA Therapy','Mastery — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(105,'Mastery_Create','ABA Therapy','Mastery — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(106,'Mastery_Edit','ABA Therapy','Mastery — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(107,'Mastery_Delete','ABA Therapy','Mastery — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(108,'Assessment_View','ABA Therapy','Assessments — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(109,'Assessment_Create','ABA Therapy','Assessments — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(110,'Assessment_Edit','ABA Therapy','Assessments — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(111,'Assessment_Delete','ABA Therapy','Assessments — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(112,'Staff_Create','Staff / HR','Staff — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(113,'Staff_Edit','Staff / HR','Staff — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(114,'Staff_Delete','Staff / HR','Staff — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(115,'Department_Create','Staff / HR','Departments — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(116,'Department_Edit','Staff / HR','Departments — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(117,'Department_Delete','Staff / HR','Departments — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(118,'Position_Create','Staff / HR','Positions — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(119,'Position_Edit','Staff / HR','Positions — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(120,'Position_Delete','Staff / HR','Positions — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(121,'Team_View','Staff / HR','Teams — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(122,'Team_Create','Staff / HR','Teams — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(123,'Team_Edit','Staff / HR','Teams — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(124,'Team_Delete','Staff / HR','Teams — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(125,'StaffAvailability_Create','Staff / HR','Staff Availability — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(126,'StaffAvailability_Edit','Staff / HR','Staff Availability — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(127,'StaffAvailability_Delete','Staff / HR','Staff Availability — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(128,'EmployeeSchedule_View','Staff / HR','Employee Schedule — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(129,'EmployeeSchedule_Create','Staff / HR','Employee Schedule — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(130,'EmployeeSchedule_Edit','Staff / HR','Employee Schedule — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(131,'EmployeeSchedule_Delete','Staff / HR','Employee Schedule — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(132,'PunchDetails_Create','Staff / HR','Punch — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(133,'PunchDetails_Edit','Staff / HR','Punch — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(134,'PunchDetails_Delete','Staff / HR','Punch — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(135,'Payroll_Create','Staff / HR','Payroll — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(136,'Payroll_Edit','Staff / HR','Payroll — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(137,'Payroll_Delete','Staff / HR','Payroll — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(138,'Invoice_Create','Finance','Invoices — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(139,'Invoice_Edit','Finance','Invoices — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(140,'Invoice_Delete','Finance','Invoices — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(141,'Payment_Create','Finance','Payments — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(142,'Payment_Edit','Finance','Payments — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(143,'Payment_Delete','Finance','Payments — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(144,'Receipt_View','Finance','Receipts — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(145,'Receipt_Create','Finance','Receipts — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(146,'Receipt_Edit','Finance','Receipts — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(147,'Receipt_Delete','Finance','Receipts — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(148,'Ledger_View','Finance','Ledger — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(149,'Ledger_Create','Finance','Ledger — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(150,'Ledger_Edit','Finance','Ledger — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(151,'Ledger_Delete','Finance','Ledger — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(152,'Expense_View','Finance','Expenses — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(153,'Expense_Create','Finance','Expenses — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(154,'Expense_Edit','Finance','Expenses — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(155,'Expense_Delete','Finance','Expenses — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(156,'Chat_View','Communication','Chat — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(157,'Chat_Create','Communication','Chat — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(158,'Chat_Edit','Communication','Chat — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(159,'Chat_Delete','Communication','Chat — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(160,'Message_Create','Communication','Messages — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(161,'Message_Edit','Communication','Messages — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(162,'Message_Delete','Communication','Messages — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(163,'Email_Create','Communication','Email — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(164,'Email_Edit','Communication','Email — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(165,'Email_Delete','Communication','Email — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(166,'Sms_View','Communication','SMS — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(167,'Sms_Create','Communication','SMS — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(168,'Sms_Edit','Communication','SMS — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(169,'Sms_Delete','Communication','SMS — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(170,'Notification_Create','Communication','Notifications — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(171,'Notification_Edit','Communication','Notifications — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(172,'Notification_Delete','Communication','Notifications — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(173,'Template_View','Communication','Templates — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(174,'Template_Create','Communication','Templates — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(175,'Template_Edit','Communication','Templates — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(176,'Template_Delete','Communication','Templates — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(177,'Report_Create','Reports','Reports — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(178,'Report_Edit','Reports','Reports — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(179,'Report_Delete','Reports','Reports — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(180,'ProgressReport_View','Reports','Progress Reports — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(181,'ProgressReport_Create','Reports','Progress Reports — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(182,'ProgressReport_Edit','Reports','Progress Reports — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(183,'ProgressReport_Delete','Reports','Progress Reports — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(184,'User_Create','Admin','Users — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(185,'User_Edit','Admin','Users — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(186,'User_Delete','Admin','Users — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(187,'User_Role_Create','Admin','Roles — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(188,'User_Role_Edit','Admin','Roles — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(189,'User_Role_Delete','Admin','Roles — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(190,'Privilege_Create','Admin','Privileges — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(191,'Privilege_Edit','Admin','Privileges — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(192,'Privilege_Delete','Admin','Privileges — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(193,'Setting_Create','Admin','Settings — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(194,'Setting_Edit','Admin','Settings — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(195,'Setting_Delete','Admin','Settings — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(196,'Location_View','Admin','Locations — View',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(197,'Location_Create','Admin','Locations — Create',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(198,'Location_Edit','Admin','Locations — Edit',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'),(199,'Location_Delete','Admin','Locations — Delete',0,'2026-06-17 21:17:43','2026-06-17 21:17:43'); /*!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=4 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','009a6e33dfabb8aa5e59a9355710dbac718d5eddb855476ded61a5fa9aafb8db','[\"*\"]','2026-06-17 01:42:46',NULL,'2026-06-16 21:49:40','2026-06-17 01:42:46'),(2,'App\\Models\\User',1,'auth_token','44521a68556aef8b7f28e03022eb81be6f5e75bf8211b88ccb0e60d2a2cbaaad','[\"*\"]','2026-06-17 22:49:03',NULL,'2026-06-17 20:48:45','2026-06-17 22:49:03'),(3,'App\\Models\\User',1,'auth_token','a0bb7b3a0561aed94dcafded899a5ccd57f8c32cd1442e56b4197a7eddcd824e','[\"*\"]','2026-06-17 22:50:39',NULL,'2026-06-17 22:49:33','2026-06-17 22:50:39'); /*!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 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 */; /*!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=41 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','Dashboard View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(2,'Setting_View','Setting View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(3,'User_View','User View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(4,'Company_View','Company View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(5,'Department_View','Department View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(6,'User_Role_View','User Role View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(7,'Privilege_View','Privilege View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(8,'Branch_View','Branch View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(9,'Theme_View','Theme View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(10,'Other_View','Other View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(11,'tag_View','Tag View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(12,'email_view','Email View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(13,'PunchDetails_View','PunchDetails View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(14,'Schedule_View','Schedule View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(15,'Payroll_View','Payroll View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(16,'Staff_View','Staff View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(17,'Position_View','Position View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(18,'Schedule_Edit','Schedule Edit',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(19,'Generate_Payroll','Generate Payroll',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(20,'Student_View','Student View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(21,'Classes_View','Classes View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(22,'ClassSchedule_View','ClassSchedule View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(23,'Attendance_View','Attendance View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(24,'Course_View','Course View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(25,'Assignment_View','Assignment View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(26,'Payment_View','Payment View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(27,'Invoice_View','Invoice View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(28,'Message_View','Message View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(29,'Notification_View','Notification View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(30,'Permission_View','Permission View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(31,'ActivityLog_View','ActivityLog View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(32,'StaffAvailability_View','StaffAvailability View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(33,'StudentNote_View','StudentNote View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(34,'Report_View','Report View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(35,'Parent_Portal_View','Parent Portal View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(36,'Program_View','Program View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(37,'Program_Library_View','Program Library View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(38,'Workflow_View','Workflow View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(39,'PromptTemplate_View','PromptTemplate View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'),(40,'SessionData_View','SessionData View',NULL,1,NULL,0,'2026-06-17 01:11:59','2026-06-17 01:11:59'); /*!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 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 */; /*!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 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 */; /*!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=587 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 (174,1,43,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(173,1,42,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(172,1,41,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(171,1,40,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(170,1,39,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(169,1,38,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(168,1,37,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(167,1,36,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(166,1,35,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(165,1,34,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(164,1,33,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(163,1,32,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(162,1,31,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(161,1,30,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(160,1,29,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(159,1,28,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(158,1,27,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(157,1,26,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(156,1,25,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(155,1,24,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(154,1,23,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(153,1,22,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(152,1,21,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(151,1,20,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(150,1,19,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(149,1,18,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(148,1,17,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(147,1,16,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(146,1,15,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(145,1,14,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(144,1,13,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(143,1,12,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(142,1,11,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(141,1,10,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(140,1,9,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(139,1,8,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(138,1,7,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(137,1,6,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(136,1,5,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(135,1,4,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(134,1,3,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(360,4,30,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(350,4,20,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(338,4,8,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(355,4,25,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(352,4,22,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(339,4,9,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(349,4,19,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(348,4,18,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(357,4,27,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(354,4,24,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(347,4,17,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(336,4,6,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(335,4,5,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(346,4,16,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(345,4,15,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(344,4,14,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(343,4,13,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(342,4,12,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(341,4,11,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(351,4,21,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(337,4,7,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(340,4,10,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(331,4,1,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(541,5,28,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(536,5,58,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(528,5,20,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(535,5,33,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(534,5,53,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(540,5,23,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(533,5,52,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(530,5,48,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(529,5,47,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(527,5,1,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(561,6,147,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(555,6,141,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(554,6,26,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(553,6,140,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(558,6,144,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(556,6,142,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(560,6,146,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(549,6,1,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(582,7,28,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(580,7,24,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(572,7,22,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(579,7,35,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(578,7,102,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(577,7,101,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(571,7,21,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(570,7,58,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(576,7,39,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(575,7,79,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(569,7,33,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(568,7,20,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(567,7,1,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(574,7,78,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(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'),(133,1,2,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(356,4,26,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(353,4,23,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(358,4,28,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(359,4,29,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(334,4,4,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(333,4,3,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(332,4,2,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(538,5,21,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(537,5,59,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(532,5,51,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(531,5,50,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(539,5,22,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(557,6,143,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(559,6,145,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(551,6,138,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(550,6,27,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(552,6,139,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(581,7,25,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(573,7,23,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(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'),(132,1,1,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(131,2,43,0,1,'2026-04-07 22:20:56','2026-04-07 22:20:56'),(175,1,44,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(176,1,45,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(177,1,46,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(178,1,47,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(179,1,48,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(180,1,49,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(181,1,50,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(182,1,51,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(183,1,52,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(184,1,53,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(185,1,54,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(186,1,55,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(187,1,56,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(188,1,57,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(189,1,58,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(190,1,59,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(191,1,60,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(192,1,61,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(193,1,62,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(194,1,63,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(195,1,64,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(196,1,65,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(197,1,66,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(198,1,67,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(199,1,68,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(200,1,69,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(201,1,70,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(202,1,71,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(203,1,72,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(204,1,73,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(205,1,74,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(206,1,75,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(207,1,76,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(208,1,77,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(209,1,78,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(210,1,79,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(211,1,80,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(212,1,81,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(213,1,82,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(214,1,83,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(215,1,84,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(216,1,85,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(217,1,86,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(218,1,87,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(219,1,88,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(220,1,89,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(221,1,90,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(222,1,91,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(223,1,92,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(224,1,93,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(225,1,94,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(226,1,95,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(227,1,96,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(228,1,97,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(229,1,98,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(230,1,99,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(231,1,100,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(232,1,101,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(233,1,102,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(234,1,103,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(235,1,104,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(236,1,105,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(237,1,106,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(238,1,107,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(239,1,108,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(240,1,109,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(241,1,110,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(242,1,111,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(243,1,112,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(244,1,113,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(245,1,114,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(246,1,115,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(247,1,116,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(248,1,117,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(249,1,118,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(250,1,119,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(251,1,120,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(252,1,121,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(253,1,122,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(254,1,123,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(255,1,124,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(256,1,125,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(257,1,126,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(258,1,127,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(259,1,128,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(260,1,129,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(261,1,130,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(262,1,131,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(263,1,132,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(264,1,133,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(265,1,134,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(266,1,135,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(267,1,136,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(268,1,137,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(269,1,138,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(270,1,139,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(271,1,140,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(272,1,141,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(273,1,142,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(274,1,143,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(275,1,144,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(276,1,145,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(277,1,146,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(278,1,147,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(279,1,148,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(280,1,149,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(281,1,150,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(282,1,151,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(283,1,152,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(284,1,153,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(285,1,154,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(286,1,155,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(287,1,156,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(288,1,157,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(289,1,158,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(290,1,159,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(291,1,160,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(292,1,161,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(293,1,162,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(294,1,163,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(295,1,164,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(296,1,165,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(297,1,166,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(298,1,167,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(299,1,168,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(300,1,169,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(301,1,170,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(302,1,171,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(303,1,172,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(304,1,173,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(305,1,174,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(306,1,175,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(307,1,176,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(308,1,177,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(309,1,178,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(310,1,179,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(311,1,180,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(312,1,181,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(313,1,182,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(314,1,183,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(315,1,184,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(316,1,185,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(317,1,186,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(318,1,187,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(319,1,188,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(320,1,189,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(321,1,190,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(322,1,191,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(323,1,192,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(324,1,193,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(325,1,194,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(326,1,195,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(327,1,196,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(328,1,197,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(329,1,198,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(330,1,199,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(361,4,31,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(362,4,32,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(363,4,33,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(364,4,34,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(365,4,35,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(366,4,36,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(367,4,37,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(368,4,38,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(369,4,39,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(370,4,40,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(371,4,42,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(372,4,43,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(373,4,44,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(374,4,45,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(375,4,46,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(376,4,47,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(377,4,48,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(378,4,49,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(379,4,50,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(380,4,51,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(381,4,52,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(382,4,53,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(383,4,54,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(384,4,55,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(385,4,56,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(386,4,57,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(387,4,58,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(388,4,59,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(389,4,60,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(390,4,61,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(391,4,62,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(392,4,63,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(393,4,64,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(394,4,65,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(395,4,66,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(396,4,67,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(397,4,68,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(398,4,69,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(399,4,70,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(400,4,71,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(401,4,72,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(402,4,73,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(403,4,74,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(404,4,75,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(405,4,76,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(406,4,77,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(407,4,78,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(408,4,79,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(409,4,80,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(410,4,81,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(411,4,82,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(412,4,83,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(413,4,84,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(414,4,85,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(415,4,86,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(416,4,87,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(417,4,88,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(418,4,89,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(419,4,90,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(420,4,91,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(421,4,92,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(422,4,93,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(423,4,94,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(424,4,95,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(425,4,96,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(426,4,97,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(427,4,98,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(428,4,99,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(429,4,100,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(430,4,101,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(431,4,102,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(432,4,103,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(433,4,104,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(434,4,105,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(435,4,106,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(436,4,107,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(437,4,108,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(438,4,109,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(439,4,110,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(440,4,111,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(441,4,112,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(442,4,113,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(443,4,114,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(444,4,115,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(445,4,116,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(446,4,117,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(447,4,118,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(448,4,119,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(449,4,120,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(450,4,121,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(451,4,122,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(452,4,123,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(453,4,124,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(454,4,125,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(455,4,126,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(456,4,127,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(457,4,128,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(458,4,129,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(459,4,130,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(460,4,131,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(461,4,132,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(462,4,133,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(463,4,134,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(464,4,135,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(465,4,136,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(466,4,137,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(467,4,138,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(468,4,139,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(469,4,140,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(470,4,141,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(471,4,142,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(472,4,143,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(473,4,144,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(474,4,145,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(475,4,146,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(476,4,147,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(477,4,148,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(478,4,149,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(479,4,150,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(480,4,151,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(481,4,152,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(482,4,153,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(483,4,154,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(484,4,155,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(485,4,156,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(486,4,157,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(487,4,158,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(488,4,159,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(489,4,160,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(490,4,161,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(491,4,162,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(492,4,163,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(493,4,164,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(494,4,165,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(495,4,166,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(496,4,167,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(497,4,168,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(498,4,169,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(499,4,170,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(500,4,171,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(501,4,172,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(502,4,173,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(503,4,174,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(504,4,175,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(505,4,176,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(506,4,177,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(507,4,178,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(508,4,179,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(509,4,180,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(510,4,181,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(511,4,182,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(512,4,183,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(513,4,184,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(514,4,185,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(515,4,187,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(516,4,188,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(517,4,189,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(518,4,190,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(519,4,191,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(520,4,192,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(521,4,193,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(522,4,194,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(523,4,196,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(524,4,197,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(525,4,198,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(526,4,199,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(542,5,160,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(543,5,161,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(544,5,162,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(545,5,29,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(546,5,170,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(547,5,171,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(548,5,172,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(562,6,148,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(563,6,152,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(564,6,153,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(565,6,154,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(566,6,34,0,1,'2026-06-17 21:48:25','2026-06-17 21:48:25'),(583,6,20,0,NULL,'2026-06-17 18:12:52','2026-06-17 18:12:52'),(584,7,81,0,NULL,'2026-06-17 18:30:51','2026-06-17 18:30:51'),(585,7,82,0,NULL,'2026-06-17 18:30:51','2026-06-17 18:30:51'),(586,7,83,0,NULL,'2026-06-17 18:30:51','2026-06-17 18:30:51'); /*!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-28 03:18:46','2026-02-28 03: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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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 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 */; /*!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=2 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,'vmadmin@gmail.com','employee','$2y$12$SfPLhZIS8OF3E5GtcrXCJOzyQhZ7o4u.kwtSq3M.x1agFAZtQt4hm','$2y$12$sIA9xQlApHbNK4y8A3N2qu/Z6hGO1v8cbutjujsuFWKeIIaTnjd06',1,NULL,NULL,NULL,NULL,NULL,0,'active',0,NULL,NULL,'2026-01-26 07:24:22','2026-06-16 21:49:18'); /*!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-17 14:50:40