-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: school_results -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `attendances` -- DROP TABLE IF EXISTS `attendances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `attendances` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned NOT NULL, `date` date NOT NULL, `status` enum('present','absent','late','half_day','leave') NOT NULL, `remarks` varchar(255) DEFAULT NULL, `is_published` tinyint(1) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `attendances_student_id_date_unique` (`student_id`,`date`), CONSTRAINT `attendances_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendances` -- LOCK TABLES `attendances` WRITE; /*!40000 ALTER TABLE `attendances` DISABLE KEYS */; INSERT INTO `attendances` VALUES (1,86,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(2,127,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(3,123,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(4,130,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(5,87,'2026-06-16','absent',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(6,126,'2026-06-16','late',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(7,84,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(8,122,'2026-06-16','absent',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(9,124,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(10,85,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(11,82,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(12,89,'2026-06-16','late',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(13,83,'2026-06-16','late',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(14,128,'2026-06-16','late',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(15,125,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(16,88,'2026-06-16','present',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(17,129,'2026-06-16','absent',NULL,0,'2026-06-17 05:01:11','2026-06-17 05:01:11'),(18,86,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(19,127,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(20,123,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(21,130,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(22,87,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(23,126,'2026-06-17','absent',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(24,84,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(25,122,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(26,124,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(27,85,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(28,82,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(29,89,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(30,83,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(31,128,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(32,125,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(33,88,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(34,129,'2026-06-17','present',NULL,0,'2026-06-17 05:01:51','2026-06-17 05:01:51'),(35,86,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(36,127,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(37,123,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(38,130,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(39,87,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(40,126,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(41,84,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(42,122,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(43,124,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(44,85,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(45,82,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(46,89,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(47,83,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(48,128,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(49,125,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(50,88,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(51,129,'2026-06-15','present',NULL,0,'2026-06-17 05:04:09','2026-06-17 05:04:09'),(52,86,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(53,127,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(54,123,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(55,130,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(56,87,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(57,126,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(58,84,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(59,122,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(60,124,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(61,85,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(62,82,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(63,89,'2026-06-18','present',NULL,0,'2026-06-17 05:05:10','2026-06-17 05:05:10'),(64,83,'2026-06-18','present',NULL,0,'2026-06-17 05:05:11','2026-06-17 05:05:11'),(65,128,'2026-06-18','present',NULL,0,'2026-06-17 05:05:11','2026-06-17 05:05:11'),(66,125,'2026-06-18','present',NULL,0,'2026-06-17 05:05:11','2026-06-17 05:05:11'),(67,88,'2026-06-18','present',NULL,0,'2026-06-17 05:05:11','2026-06-17 05:05:11'),(68,129,'2026-06-18','present',NULL,0,'2026-06-17 05:05:11','2026-06-17 05:05:11'),(69,86,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(70,127,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(71,123,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(72,130,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(73,87,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(74,126,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(75,84,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(76,122,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(77,124,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(78,85,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(79,82,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(80,89,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(81,83,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(82,128,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(83,125,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(84,88,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(85,129,'2026-06-19','present',NULL,0,'2026-06-17 05:05:39','2026-06-17 05:05:39'),(86,86,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(87,127,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(88,123,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(89,130,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(90,87,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(91,126,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(92,84,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(93,122,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(94,124,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(95,85,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(96,82,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(97,89,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(98,83,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(99,128,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(100,125,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(101,88,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(102,129,'2026-06-20','absent',NULL,0,'2026-06-17 05:05:54','2026-06-17 05:05:54'),(103,86,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(104,127,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(105,123,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(106,130,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(107,87,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(108,126,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(109,84,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(110,122,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(111,124,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(112,85,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(113,82,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(114,89,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(115,83,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(116,128,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(117,125,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(118,88,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(119,129,'2026-06-21','absent',NULL,0,'2026-06-17 05:06:18','2026-06-17 05:06:18'),(120,86,'2026-07-02','present',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(121,127,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(122,123,'2026-07-02','late',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(123,130,'2026-07-02','present',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(124,87,'2026-07-02','late',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(125,126,'2026-07-02','present',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(126,84,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(127,122,'2026-07-02','late',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(128,124,'2026-07-02','half_day',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(129,85,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(130,82,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(131,89,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(132,83,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(133,128,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:12','2026-07-02 17:15:05'),(134,125,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:13','2026-07-02 17:15:05'),(135,88,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:13','2026-07-02 17:15:05'),(136,129,'2026-07-02','absent',NULL,1,'2026-07-02 16:44:13','2026-07-02 17:15:05'),(137,68,'2026-07-02','present',NULL,1,'2026-07-02 17:21:47','2026-07-02 17:22:15'),(138,67,'2026-07-02','present',NULL,1,'2026-07-02 17:21:47','2026-07-02 17:22:15'),(139,72,'2026-07-02','present',NULL,1,'2026-07-02 17:21:47','2026-07-02 17:22:15'),(140,70,'2026-07-02','present',NULL,1,'2026-07-02 17:21:47','2026-07-02 17:22:15'),(141,71,'2026-07-02','present',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'),(142,69,'2026-07-02','present',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'),(143,66,'2026-07-02','present',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'),(144,65,'2026-07-02','absent',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'),(145,64,'2026-07-02','absent',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'),(146,73,'2026-07-02','late',NULL,1,'2026-07-02 17:21:48','2026-07-02 17:22:15'); /*!40000 ALTER TABLE `attendances` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `classes` -- DROP TABLE IF EXISTS `classes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `classes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `class_name` varchar(255) NOT NULL, `class_teacher` varchar(255) DEFAULT NULL, `teacher_id` bigint(20) unsigned DEFAULT NULL, `academic_year` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `classes_teacher_id_foreign` (`teacher_id`), CONSTRAINT `classes_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `classes` -- LOCK TABLES `classes` WRITE; /*!40000 ALTER TABLE `classes` DISABLE KEYS */; INSERT INTO `classes` VALUES (6,'FORM ONE','Katherine McGlynn PhD',NULL,'2025/2026','2026-06-06 08:28:48','2026-06-09 05:04:55'),(7,'FORM TWO',NULL,NULL,'2025/2026','2026-06-06 08:28:48','2026-07-01 11:16:13'),(8,'FORM THREE','Garrick Bosco',NULL,'2025/2026','2026-06-06 08:28:48','2026-06-09 05:04:55'),(9,'FORM FOUR',NULL,NULL,'2025/2026','2026-06-06 08:28:48','2026-07-01 10:09:19'),(14,'KG1',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-07-01 10:13:34'),(15,'KG2',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 20:47:44'),(16,'KG3',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 20:47:47'),(17,'CLASS 1A',NULL,NULL,'2025/2026','2026-06-09 04:57:16','2026-07-02 09:51:11'),(18,'CLASS 1B',NULL,NULL,'2025/2026','2026-06-09 04:57:16','2026-07-02 09:51:18'),(19,'CLASS 2A',NULL,NULL,'2025/2026','2026-06-09 04:57:16','2026-07-02 09:51:30'),(20,'CLASS 2B',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-07-02 16:11:05'),(21,'CLASS 3A',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-07-02 17:19:39'),(22,'CLASS 3B',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-07-01 10:14:29'),(23,'CLASS 4A','SHALON CHARLES KILAWA',NULL,NULL,'2026-06-09 04:57:16','2026-07-02 17:20:22'),(24,'CLASS 4B',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 04:57:16'),(25,'CLASS 5A',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 04:57:16'),(26,'CLASS 5B',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 04:57:16'),(27,'CLASS 6A',NULL,NULL,NULL,'2026-06-09 04:57:16','2026-06-09 04:57:16'),(28,'CLASS 6B',NULL,NULL,NULL,'2026-06-09 04:57:17','2026-07-02 17:19:39'),(29,'CLASS 7A',NULL,NULL,NULL,'2026-06-09 04:57:17','2026-06-09 04:57:17'),(30,'CLASS 7B',NULL,NULL,NULL,'2026-06-09 04:57:17','2026-06-09 04:57:17'); /*!40000 ALTER TABLE `classes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `database_backups` -- DROP TABLE IF EXISTS `database_backups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `database_backups` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `file_name` varchar(255) NOT NULL, `file_path` varchar(255) DEFAULT NULL, `file_size_mb` double DEFAULT NULL, `duration_seconds` int(11) DEFAULT NULL, `status` enum('Pending','Processing','Completed','Failed','Restoring','Deleted') NOT NULL DEFAULT 'Pending', `type` enum('manual','auto','temporary') NOT NULL DEFAULT 'manual', `storage_destination` varchar(255) NOT NULL DEFAULT 'local', `created_by` bigint(20) unsigned DEFAULT NULL, `error_message` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `database_backups_created_by_foreign` (`created_by`), CONSTRAINT `database_backups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `database_backups` -- LOCK TABLES `database_backups` WRITE; /*!40000 ALTER TABLE `database_backups` DISABLE KEYS */; INSERT INTO `database_backups` VALUES (12,'school_backup_2026_07_05_19_47_43.zip',NULL,NULL,0,'Failed','manual','local',52,'The dump process failed with a none successful exitcode.\nExitcode\n========\n2: Misuse of shell builtins\n\nOutput\n======\n\n\nError Output\n============\nmysqldump: Got error: 2004: \"Can\'t create TCP/IP socket (10106)\" when trying to connect\r\n','2026-07-05 16:47:43','2026-07-05 16:47:44'),(13,'school_backup_2026_07_05_20_00_25.zip',NULL,NULL,0,'Failed','manual','local',52,'The dump process failed with a none successful exitcode.\nExitcode\n========\n2: Misuse of shell builtins\n\nOutput\n======\n\n\nError Output\n============\nmysqldump: Got error: 2004: \"Can\'t create TCP/IP socket (10106)\" when trying to connect\r\n','2026-07-05 17:00:25','2026-07-05 17:00:25'); /*!40000 ALTER TABLE `database_backups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `exams` -- DROP TABLE IF EXISTS `exams`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exams` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `exam_name` varchar(255) NOT NULL, `exam_type` varchar(255) DEFAULT NULL, `term` varchar(255) DEFAULT NULL, `academic_year` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `exams` -- LOCK TABLES `exams` WRITE; /*!40000 ALTER TABLE `exams` DISABLE KEYS */; INSERT INTO `exams` VALUES (4,'Mid-Term 1','midterm','Term 1','2025/2026',NULL,NULL,'2026-06-06 08:28:48','2026-06-06 08:28:48'),(5,'End-Term 1','final','Term 1','2025/2026',NULL,NULL,'2026-06-06 08:28:48','2026-06-06 08:28:48'),(6,'Mid-Term 2','midterm','Term 2','2025/2026',NULL,NULL,'2026-06-06 08:28:48','2026-06-06 08:28:48'); /*!40000 ALTER TABLE `exams` 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(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext 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 `fee_payments` -- DROP TABLE IF EXISTS `fee_payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fee_payments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned NOT NULL, `receipt_no` varchar(255) NOT NULL, `amount_paid` decimal(12,2) NOT NULL, `payment_date` date NOT NULL, `payment_mode` varchar(255) NOT NULL DEFAULT 'CASH', `fee_type` varchar(255) NOT NULL DEFAULT 'Tuition', `term_or_month` varchar(255) DEFAULT NULL, `remarks` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `fee_payments_receipt_no_unique` (`receipt_no`), KEY `fee_payments_student_id_foreign` (`student_id`), CONSTRAINT `fee_payments_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fee_payments` -- LOCK TABLES `fee_payments` WRITE; /*!40000 ALTER TABLE `fee_payments` DISABLE KEYS */; INSERT INTO `fee_payments` VALUES (1,62,'RCP-2026-KGHFC',780000.00,'2026-06-17','CASH','Tuition','2024 - 2025',NULL,'2026-06-17 08:34:39','2026-06-17 08:34:39'),(2,63,'RCP-2026-4K1PH',300000.00,'2026-06-17','CASH','Tuition','2024 - 2025',NULL,'2026-06-17 09:04:54','2026-06-17 09:04:54'),(3,64,'RCP-2026-XUENA',780000.00,'2026-06-17','CASH','Tuition','2024 - 2025',NULL,'2026-06-17 09:20:41','2026-06-17 09:20:41'),(4,249,'RCP-2026-EWVWX',780000.00,'2026-07-01','CASH','Tuition','2024 - 2025','5899','2026-07-01 17:01:41','2026-07-01 17:01:41'),(5,246,'RCP-2026-01D9A',680000.00,'2026-07-01','CASH','Tuition','2024 - 2025','58910','2026-07-01 17:04:37','2026-07-01 17:04:37'),(6,67,'RCP-2026-SFZBO',100000.00,'2026-07-01','CASH','Transport','2024 - 2025',NULL,'2026-07-01 18:20:49','2026-07-01 18:20:49'),(7,221,'RCP-2026-BRSKU',1400000.00,'2026-07-02','CASH','Tuition','2024 - 2025',NULL,'2026-07-02 06:08:49','2026-07-02 06:08:49'),(8,221,'RCP-2026-28UFL',250000.00,'2026-07-02','CASH','Development ley','2024 - 2025',NULL,'2026-07-02 06:09:51','2026-07-02 06:09:51'),(9,285,'RCP-2026-HM9AI',350000.00,'2026-07-02','CASH','Development ley','2024 - 2025',NULL,'2026-07-02 06:11:07','2026-07-02 06:11:07'),(10,285,'RCP-2026-IVURZ',1000000.00,'2026-07-02','CASH','Development ley','2024 - 2025',NULL,'2026-07-02 06:12:12','2026-07-02 06:12:12'),(11,221,'TEST-002',500000.00,'2026-07-02','CASH','Tuition','Annual','Test partial','2026-07-02 06:20:34','2026-07-02 06:25:51'),(12,64,'RCP-2026-RPWDN',100000.00,'2026-07-02','CASH','Tuition','2024 - 2025',NULL,'2026-07-02 06:31:28','2026-07-02 06:31:28'),(13,285,'RCP-2026-VEQ38',100000.00,'2026-07-02','CASH','Tuition','2024 - 2025',NULL,'2026-07-02 08:04:43','2026-07-02 08:04:43'),(14,65,'RCP-2026-WRA2R',80000.00,'2026-07-02','CASH','Tuition','2024 - 2025',NULL,'2026-07-02 08:23:35','2026-07-02 08:23:35'),(15,66,'RCP-2026-O7HGN',780000.00,'2026-07-02','CASH','Tuition','2024 - 2025',NULL,'2026-07-02 17:43:12','2026-07-02 17:43:12'); /*!40000 ALTER TABLE `fee_payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `fee_structures` -- DROP TABLE IF EXISTS `fee_structures`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fee_structures` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `level` varchar(255) NOT NULL DEFAULT 'Primary', `scholar_type` varchar(255) DEFAULT NULL, `target_class` varchar(255) DEFAULT NULL, `category` varchar(255) NOT NULL, `amount` decimal(12,2) NOT NULL, `frequency` varchar(255) NOT NULL, `due_day` varchar(255) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `fee_structures` -- LOCK TABLES `fee_structures` WRITE; /*!40000 ALTER TABLE `fee_structures` DISABLE KEYS */; INSERT INTO `fee_structures` VALUES (1,'Primary','Day',NULL,'Tuition',780000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(2,'Primary','Day',NULL,'Development ley',100000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(3,'Primary','Day','STD 4','Development ley',275000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(4,'Primary','Day','STD 7','Development ley',275000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(5,'Secondary','Day',NULL,'Tuition',880000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(6,'Secondary','Day',NULL,'Development ley',250000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(7,'Secondary','Day','Form 2','Development ley',350000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(8,'Secondary','Day','Form 4','Development ley',350000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(9,'Primary','Boarding',NULL,'Tuition',1400000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(10,'Primary','Boarding',NULL,'Development ley',250000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(11,'Primary','Boarding','STD 4','Development ley',275000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(12,'Primary','Boarding','STD 7','Development ley',275000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(13,'Secondary','Boarding',NULL,'Tuition',1600000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(14,'Secondary','Boarding',NULL,'Development ley',350000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(15,'Secondary','Boarding','Form 2','Development ley',350000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'),(16,'Secondary','Boarding','Form 4','Development ley',350000.00,'Annual',NULL,1,'2026-07-02 03:43:12','2026-07-02 03:43:12'); /*!40000 ALTER TABLE `fee_structures` 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, `level` varchar(255) DEFAULT NULL, `name` varchar(255) NOT NULL, `min_score` int(11) NOT NULL, `max_score` int(11) NOT NULL, `remark` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `grades` -- LOCK TABLES `grades` WRITE; /*!40000 ALTER TABLE `grades` DISABLE KEYS */; INSERT INTO `grades` VALUES (1,'Primary','A',75,100,'Excellent','2026-06-13 04:23:34','2026-07-02 10:35:51'),(2,'Primary','B',65,74,'Very Good','2026-06-13 04:23:34','2026-07-02 10:35:51'),(3,'Primary','C',45,64,'Good','2026-06-13 04:23:34','2026-07-02 10:35:51'),(4,'Primary','D',30,44,'Satisfactory','2026-06-13 04:23:34','2026-07-02 10:35:51'),(5,'Primary','E',0,29,'Fail','2026-06-13 04:23:34','2026-07-02 10:42:17'),(6,'Kindergarten','A',75,100,'Excellent','2026-07-02 10:41:20','2026-07-02 10:41:20'),(7,'Kindergarten','B',65,74,'Very Good','2026-07-02 10:41:20','2026-07-02 10:41:20'),(8,'Kindergarten','C',45,64,'Good','2026-07-02 10:41:20','2026-07-02 10:41:20'),(9,'Kindergarten','D',30,44,'Satisfactory','2026-07-02 10:41:20','2026-07-02 10:41:20'),(10,'Kindergarten','E',0,29,'Fail','2026-07-02 10:41:20','2026-07-02 10:42:33'),(11,'Secondary','A',75,100,'Excellent','2026-07-02 10:41:20','2026-07-02 10:41:20'),(12,'Secondary','B',65,74,'Very Good','2026-07-02 10:41:20','2026-07-02 10:41:20'),(13,'Secondary','C',45,64,'Good','2026-07-02 10:41:20','2026-07-02 10:41:20'),(14,'Secondary','D',30,44,'Satisfactory','2026-07-02 10:41:20','2026-07-02 10:41:20'),(15,'Secondary','F',0,29,'Fail','2026-07-02 10:41:20','2026-07-02 10:41:20'); /*!40000 ALTER TABLE `grades` 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, `student_id` bigint(20) unsigned NOT NULL, `invoice_no` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `amount` decimal(12,2) NOT NULL, `paid_amount` decimal(12,2) NOT NULL DEFAULT 0.00, `due_date` date NOT NULL, `status` varchar(255) NOT NULL DEFAULT 'Pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `invoices_invoice_no_unique` (`invoice_no`), KEY `invoices_student_id_foreign` (`student_id`), CONSTRAINT `invoices_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoices` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; /*!40000 ALTER TABLE `invoices` 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(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=48 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,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_reset_tokens_table',1),(3,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2019_12_14_000001_create_personal_access_tokens_table',1),(5,'2026_06_02_000005_add_role_to_users_table',1),(6,'2026_06_02_000010_create_students_table',1),(7,'2026_06_02_000020_create_subjects_table',1),(8,'2026_06_02_000030_create_exams_table',1),(9,'2026_06_02_000040_create_classes_table',1),(10,'2026_06_02_000050_create_results_table',1),(11,'2026_06_02_000060_create_settings_table',1),(12,'2026_06_02_000070_add_portal_pin_to_students_table',1),(13,'2026_06_02_000080_extend_results_for_marks_entry',1),(14,'2026_06_02_000090_create_sms_tables',1),(15,'2026_06_03_120000_add_foreign_keys_and_cleanup_results',1),(16,'2026_06_03_130000_add_middle_name_to_students_table',1),(17,'2026_06_06_000100_add_otp_fields_to_users_table',1),(18,'2026_06_09_154658_add_photo_to_students_table',2),(19,'2026_06_10_145221_add_admission_fields_to_students_table',3),(20,'2026_06_12_184149_create_fee_payments_table',4),(21,'2026_06_12_213239_create_fee_structures_table',5),(22,'2026_06_13_072206_create_grades_table',6),(23,'2026_06_13_131216_create_school_parents_table',7),(24,'2026_06_14_061256_create_parent_meetings_table',8),(25,'2026_06_14_073626_create_staff_table',9),(26,'2026_06_14_091342_create_news_table',10),(27,'2026_06_14_111248_update_roles_and_class_teacher',11),(28,'2026_06_17_050906_add_boarding_type_to_students_table',12),(29,'2026_06_17_052543_add_scholar_shift_tracking_to_students_table',13),(30,'2026_06_17_060250_create_attendances_table',14),(31,'2026_06_17_114900_create_invoices_table',15),(32,'2026_06_27_070044_drop_sms_tables',16),(33,'2026_06_27_091109_create_subject_classes_table',17),(34,'2026_06_28_150000_add_payment_and_nin_to_staff_table',18),(35,'2026_06_28_152341_add_comprehensive_details_to_staff_table',19),(36,'2026_07_01_124739_add_email_to_staff_table',20),(37,'2026_07_01_132220_add_username_to_users_table',21),(38,'2026_07_01_215233_add_level_to_fee_structures_table',22),(39,'2026_07_01_222514_add_target_class_to_fee_structures_table',23),(40,'2026_07_02_063228_add_scholar_type_to_fee_structures_table',24),(41,'2026_07_02_130119_add_level_to_grades_table',25),(42,'2026_07_02_200233_add_is_published_to_attendances_table',26),(43,'2026_07_05_134816_add_two_factor_fields_to_users_table',27),(44,'2026_07_05_135503_create_webauthn_table',27),(45,'2026_07_05_161619_create_database_backups_table',28),(46,'2026_07_05_163901_add_super_admin_to_role_enum',29),(47,'2026_07_05_175055_add_storage_destination_to_database_backups_table',30); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `news` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `content` text NOT NULL, `published_date` date NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (1,'End of Term Examinations','Please be advised that the end of term examinations will commence next week.','2026-06-14',1,'2026-06-14 06:14:48','2026-06-14 06:14:48'),(2,'School Fees Reminder','All parents are reminded to clear any outstanding fee balances before the start of examinations.','2026-06-12',1,'2026-06-14 06:14:48','2026-06-14 06:14:48'),(3,'Upcoming Parent-Teacher Meeting','We will hold a virtual parent-teacher meeting at the end of the month. Zoom links will be shared soon.','2026-06-09',1,'2026-06-14 06:14:48','2026-06-14 06:14:48'); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parent_meetings` -- DROP TABLE IF EXISTS `parent_meetings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `parent_meetings` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `academic_year` varchar(255) NOT NULL, `meeting_number` varchar(255) NOT NULL, `meeting_date` date NOT NULL, `total_attended` int(11) NOT NULL DEFAULT 0, `agendas` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parent_meetings` -- LOCK TABLES `parent_meetings` WRITE; /*!40000 ALTER TABLE `parent_meetings` DISABLE KEYS */; INSERT INTO `parent_meetings` VALUES (1,'2025','Meeting 1','2025-08-15',120,'1. Welcome and Introductions\\n2. Review of Academic Calendar\\n3. Financial Policies Discussion\\n4. Q&A Session','2026-06-14 03:13:24','2026-06-14 03:16:21'),(2,'2025','Meeting 2','2025-12-10',85,'1. Mid-term Performance Review\\n2. Holiday Schedule\\n3. Upcoming Science Fair\\n4. Open Floor','2026-06-14 03:13:24','2026-06-14 03:16:21'); /*!40000 ALTER TABLE `parent_meetings` 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(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `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(255) NOT NULL, `tokenable_id` bigint(20) unsigned NOT NULL, `name` varchar(255) NOT NULL, `token` varchar(64) NOT NULL, `abilities` text DEFAULT NULL, `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 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 */; /*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `results` -- DROP TABLE IF EXISTS `results`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `results` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) unsigned NOT NULL, `subject_id` bigint(20) unsigned NOT NULL, `exam_id` bigint(20) unsigned DEFAULT NULL, `academic_year` varchar(20) DEFAULT NULL, `term` varchar(20) DEFAULT NULL, `class_name` varchar(50) DEFAULT NULL, `stream` varchar(10) DEFAULT NULL, `marks_obtained` decimal(5,2) DEFAULT NULL, `maximum_marks` decimal(5,2) NOT NULL DEFAULT 100.00, `assignment_marks` decimal(5,2) DEFAULT NULL, `quiz_marks` decimal(5,2) DEFAULT NULL, `midterm_marks` decimal(5,2) DEFAULT NULL, `final_exam_marks` decimal(5,2) DEFAULT NULL, `total_score` decimal(5,2) DEFAULT NULL, `grade` varchar(5) DEFAULT NULL, `remarks` varchar(255) DEFAULT NULL, `status` enum('draft','submitted','published') NOT NULL DEFAULT 'draft', `recorded_by` bigint(20) unsigned DEFAULT NULL, `recorded_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `results_student_subject_term_year_unique` (`student_id`,`subject_id`,`term`,`academic_year`), KEY `results_subject_id_foreign` (`subject_id`), KEY `results_exam_id_foreign` (`exam_id`), KEY `results_recorded_by_foreign` (`recorded_by`), CONSTRAINT `results_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE SET NULL, CONSTRAINT `results_recorded_by_foreign` FOREIGN KEY (`recorded_by`) REFERENCES `users` (`id`) ON DELETE SET NULL, CONSTRAINT `results_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE, CONSTRAINT `results_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=206 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `results` -- LOCK TABLES `results` WRITE; /*!40000 ALTER TABLE `results` DISABLE KEYS */; INSERT INTO `results` VALUES (1,132,93,NULL,'2025-2026','Term 1','class 3B','B',10.00,100.00,NULL,NULL,NULL,NULL,10.00,'F','Fail','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(2,132,87,NULL,'2025-2026','Term 1','class 3B','B',20.00,100.00,NULL,NULL,NULL,NULL,20.00,'F','Fail','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(3,132,58,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(4,132,50,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(5,132,44,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(6,132,54,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(7,132,56,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(8,136,93,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(9,136,87,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(10,136,58,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(11,136,50,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(12,136,44,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(13,136,54,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(14,136,56,NULL,'2025-2026','Term 1','class 3B','B',20.00,100.00,NULL,NULL,NULL,NULL,20.00,'F','Fail','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(15,134,93,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(16,134,87,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(17,134,58,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(18,134,50,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(19,134,44,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(20,134,54,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(21,134,56,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(22,135,93,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(23,135,87,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(24,135,58,NULL,'2025-2026','Term 1','class 3B','B',78.10,100.00,NULL,NULL,NULL,NULL,78.10,'A','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(25,135,50,NULL,'2025-2026','Term 1','class 3B','B',78.80,100.00,NULL,NULL,NULL,NULL,78.80,'A','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(26,135,44,NULL,'2025-2026','Term 1','class 3B','B',78.00,100.00,NULL,NULL,NULL,NULL,78.00,'A','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(27,135,54,NULL,'2025-2026','Term 1','class 3B','B',78.00,100.00,NULL,NULL,NULL,NULL,78.00,'A','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(28,135,56,NULL,'2025-2026','Term 1','class 3B','B',50.50,100.00,NULL,NULL,NULL,NULL,50.50,'C+','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(29,140,93,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(30,140,87,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(31,140,58,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(32,140,50,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(33,140,44,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(34,140,54,NULL,'2025-2026','Term 1','class 3B','B',30.00,100.00,NULL,NULL,NULL,NULL,30.00,'D','Pass','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(35,140,56,NULL,'2025-2026','Term 1','class 3B','B',80.60,100.00,NULL,NULL,NULL,NULL,80.60,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(36,137,93,NULL,'2025-2026','Term 1','class 3B','B',60.50,100.00,NULL,NULL,NULL,NULL,60.50,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(37,137,87,NULL,'2025-2026','Term 1','class 3B','B',60.70,100.00,NULL,NULL,NULL,NULL,60.70,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(38,137,58,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(39,137,50,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(40,137,44,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(41,137,54,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(42,137,56,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(43,131,93,NULL,'2025-2026','Term 1','class 3B','B',8.00,100.00,NULL,NULL,NULL,NULL,8.00,'F','Fail','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(44,131,87,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(45,131,58,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(46,131,50,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(47,131,44,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(48,131,54,NULL,'2025-2026','Term 1','class 3B','B',90.30,100.00,NULL,NULL,NULL,NULL,90.30,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(49,131,56,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(50,133,93,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(51,133,87,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(52,133,58,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(53,133,50,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(54,133,44,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(55,133,54,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(56,133,56,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(57,138,93,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(58,138,87,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(59,138,58,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(60,138,50,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(61,138,44,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(62,138,54,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(63,138,56,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(64,139,93,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(65,139,87,NULL,'2025-2026','Term 1','class 3B','B',78.10,100.00,NULL,NULL,NULL,NULL,78.10,'A','Excellent','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(66,139,58,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(67,139,50,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(68,139,44,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:21:46','2026-06-27 08:27:46'),(69,139,54,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(70,139,56,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:21:46','2026-06-27 08:21:46','2026-06-27 08:21:46'),(71,132,46,NULL,'2025-2026','Term 1','class 3B','B',10.00,100.00,NULL,NULL,NULL,NULL,10.00,'F','Fail','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(72,132,45,NULL,'2025-2026','Term 1','class 3B','B',20.00,100.00,NULL,NULL,NULL,NULL,20.00,'F','Fail','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(73,132,48,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(74,132,43,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(75,132,47,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(76,132,49,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(77,136,46,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(78,136,45,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(79,136,48,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(80,136,43,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(81,136,47,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(82,136,49,NULL,'2025-2026','Term 1','class 3B','B',20.00,100.00,NULL,NULL,NULL,NULL,20.00,'F','Fail','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(83,134,46,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(84,134,45,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(85,134,48,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(86,134,43,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(87,134,47,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(88,134,49,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(89,135,46,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(90,135,45,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(91,135,48,NULL,'2025-2026','Term 1','class 3B','B',78.10,100.00,NULL,NULL,NULL,NULL,78.10,'A','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(92,135,43,NULL,'2025-2026','Term 1','class 3B','B',78.80,100.00,NULL,NULL,NULL,NULL,78.80,'A','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(93,135,47,NULL,'2025-2026','Term 1','class 3B','B',78.00,100.00,NULL,NULL,NULL,NULL,78.00,'A','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(94,135,49,NULL,'2025-2026','Term 1','class 3B','B',50.50,100.00,NULL,NULL,NULL,NULL,50.50,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(95,140,46,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(96,140,45,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(97,140,48,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(98,140,43,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(99,140,47,NULL,'2025-2026','Term 1','class 3B','B',30.00,100.00,NULL,NULL,NULL,NULL,30.00,'D','Pass','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(100,140,49,NULL,'2025-2026','Term 1','class 3B','B',80.60,100.00,NULL,NULL,NULL,NULL,80.60,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(101,137,46,NULL,'2025-2026','Term 1','class 3B','B',60.50,100.00,NULL,NULL,NULL,NULL,60.50,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(102,137,45,NULL,'2025-2026','Term 1','class 3B','B',60.70,100.00,NULL,NULL,NULL,NULL,60.70,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(103,137,48,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(104,137,43,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(105,137,47,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(106,137,49,NULL,'2025-2026','Term 1','class 3B','B',70.00,100.00,NULL,NULL,NULL,NULL,70.00,'A-','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(107,131,46,NULL,'2025-2026','Term 1','class 3B','B',8.00,100.00,NULL,NULL,NULL,NULL,8.00,'F','Fail','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(108,131,45,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(109,131,48,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(110,131,43,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(111,131,47,NULL,'2025-2026','Term 1','class 3B','B',90.30,100.00,NULL,NULL,NULL,NULL,90.30,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(112,131,49,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(113,133,46,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(114,133,45,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(115,133,48,NULL,'2025-2026','Term 1','class 3B','B',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(116,133,43,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(117,133,47,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(118,133,49,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(119,138,46,NULL,'2025-2026','Term 1','class 3B','B',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(120,138,45,NULL,'2025-2026','Term 1','class 3B','B',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A+','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(121,138,48,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(122,138,43,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(123,138,47,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(124,138,49,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(125,139,46,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(126,139,45,NULL,'2025-2026','Term 1','class 3B','B',78.10,100.00,NULL,NULL,NULL,NULL,78.10,'A','Excellent','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(127,139,48,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(128,139,43,NULL,'2025-2026','Term 1','class 3B','B',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C+','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(129,139,47,NULL,'2025-2026','Term 1','class 3B','B',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'C-','Average','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(130,139,49,NULL,'2025-2026','Term 1','class 3B','B',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'B','Good','draft',30,'2026-06-27 08:27:46','2026-06-27 08:27:46','2026-06-27 08:27:46'),(131,284,31,NULL,'2025-2026','Term 1','CLASS 1A','A',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A','Excellent','submitted',30,'2026-07-03 06:08:56','2026-06-27 08:45:57','2026-07-03 06:08:56'),(132,284,32,NULL,'2025-2026','Term 1','CLASS 1A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:08:56','2026-06-27 08:45:57','2026-07-03 06:08:56'),(133,284,33,NULL,'2025-2026','Term 1','CLASS 1A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:08:56','2026-06-27 08:45:57','2026-07-03 06:08:56'),(134,284,34,NULL,'2025-2026','Term 1','CLASS 1A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:08:56','2026-06-27 08:45:57','2026-07-03 06:08:56'),(135,284,35,NULL,'2025-2026','Term 1','CLASS 1A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:08:56','2026-06-27 08:45:57','2026-07-03 06:08:56'),(136,68,99,NULL,'2025-2026','Term 1','class 4A','A',10.00,100.00,NULL,NULL,NULL,NULL,10.00,'E','Fail','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(137,68,98,NULL,'2025-2026','Term 1','class 4A','A',11.00,100.00,NULL,NULL,NULL,NULL,11.00,'E','Fail','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(138,68,101,NULL,'2025-2026','Term 1','class 4A','A',30.00,100.00,NULL,NULL,NULL,NULL,30.00,'D','Satisfactory','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(139,68,97,NULL,'2025-2026','Term 1','class 4A','A',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'D','Satisfactory','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(140,68,96,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(141,68,100,NULL,'2025-2026','Term 1','class 4A','A',20.00,100.00,NULL,NULL,NULL,NULL,20.00,'E','Fail','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(142,68,102,NULL,'2025-2026','Term 1','class 4A','A',39.00,100.00,NULL,NULL,NULL,NULL,39.00,'D','Satisfactory','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(143,67,99,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(144,67,98,NULL,'2025-2026','Term 1','class 4A','A',92.00,100.00,NULL,NULL,NULL,NULL,92.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(145,67,101,NULL,'2025-2026','Term 1','class 4A','A',38.00,100.00,NULL,NULL,NULL,NULL,38.00,'D','Satisfactory','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(146,67,97,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(147,67,96,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(148,67,100,NULL,'2025-2026','Term 1','class 4A','A',40.00,100.00,NULL,NULL,NULL,NULL,40.00,'D','Satisfactory','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(149,67,102,NULL,'2025-2026','Term 1','class 4A','A',78.00,100.00,NULL,NULL,NULL,NULL,78.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(150,72,99,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(151,72,98,NULL,'2025-2026','Term 1','class 4A','A',93.00,100.00,NULL,NULL,NULL,NULL,93.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(152,72,101,NULL,'2025-2026','Term 1','class 4A','A',94.00,100.00,NULL,NULL,NULL,NULL,94.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(153,72,97,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(154,72,96,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(155,72,100,NULL,'2025-2026','Term 1','class 4A','A',96.00,100.00,NULL,NULL,NULL,NULL,96.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(156,72,102,NULL,'2025-2026','Term 1','class 4A','A',97.00,100.00,NULL,NULL,NULL,NULL,97.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(157,70,99,NULL,'2025-2026','Term 1','class 4A','A',100.00,100.00,NULL,NULL,NULL,NULL,100.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(158,70,98,NULL,'2025-2026','Term 1','class 4A','A',94.00,100.00,NULL,NULL,NULL,NULL,94.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(159,70,101,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(160,70,97,NULL,'2025-2026','Term 1','class 4A','A',100.00,100.00,NULL,NULL,NULL,NULL,100.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(161,70,96,NULL,'2025-2026','Term 1','class 4A','A',100.00,100.00,NULL,NULL,NULL,NULL,100.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(162,70,100,NULL,'2025-2026','Term 1','class 4A','A',100.00,100.00,NULL,NULL,NULL,NULL,100.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(163,70,102,NULL,'2025-2026','Term 1','class 4A','A',99.00,100.00,NULL,NULL,NULL,NULL,99.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(164,71,99,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(165,71,98,NULL,'2025-2026','Term 1','class 4A','A',96.00,100.00,NULL,NULL,NULL,NULL,96.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(166,71,101,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(167,71,97,NULL,'2025-2026','Term 1','class 4A','A',89.00,100.00,NULL,NULL,NULL,NULL,89.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(168,71,96,NULL,'2025-2026','Term 1','class 4A','A',98.00,100.00,NULL,NULL,NULL,NULL,98.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(169,71,100,NULL,'2025-2026','Term 1','class 4A','A',98.00,100.00,NULL,NULL,NULL,NULL,98.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(170,71,102,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(171,69,99,NULL,'2025-2026','Term 1','class 4A','A',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(172,69,98,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(173,69,101,NULL,'2025-2026','Term 1','class 4A','A',59.00,100.00,NULL,NULL,NULL,NULL,59.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(174,69,97,NULL,'2025-2026','Term 1','class 4A','A',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(175,69,96,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(176,69,100,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(177,69,102,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(178,66,99,NULL,'2025-2026','Term 1','class 4A','A',88.00,100.00,NULL,NULL,NULL,NULL,88.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(179,66,98,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(180,66,101,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(181,66,97,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(182,66,96,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(183,66,100,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(184,66,102,NULL,'2025-2026','Term 1','class 4A','A',79.00,100.00,NULL,NULL,NULL,NULL,79.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(185,65,99,NULL,'2025-2026','Term 1','class 4A','A',86.00,100.00,NULL,NULL,NULL,NULL,86.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(186,65,98,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(187,65,101,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(188,65,97,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(189,65,96,NULL,'2025-2026','Term 1','class 4A','A',66.00,100.00,NULL,NULL,NULL,NULL,66.00,'B','Very Good','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(190,65,100,NULL,'2025-2026','Term 1','class 4A','A',78.00,100.00,NULL,NULL,NULL,NULL,78.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(191,65,102,NULL,'2025-2026','Term 1','class 4A','A',88.00,100.00,NULL,NULL,NULL,NULL,88.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(192,64,99,NULL,'2025-2026','Term 1','class 4A','A',76.00,100.00,NULL,NULL,NULL,NULL,76.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(193,64,98,NULL,'2025-2026','Term 1','class 4A','A',94.00,100.00,NULL,NULL,NULL,NULL,94.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(194,64,101,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(195,64,97,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(196,64,96,NULL,'2025-2026','Term 1','class 4A','A',95.00,100.00,NULL,NULL,NULL,NULL,95.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(197,64,100,NULL,'2025-2026','Term 1','class 4A','A',80.00,100.00,NULL,NULL,NULL,NULL,80.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(198,64,102,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:19','2026-07-03 03:16:31','2026-07-03 06:46:19'),(199,73,99,NULL,'2025-2026','Term 1','class 4A','A',90.00,100.00,NULL,NULL,NULL,NULL,90.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:31','2026-07-03 06:46:20'),(200,73,98,NULL,'2025-2026','Term 1','class 4A','A',93.00,100.00,NULL,NULL,NULL,NULL,93.00,'A','Excellent','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'),(201,73,101,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'),(202,73,97,NULL,'2025-2026','Term 1','class 4A','A',50.00,100.00,NULL,NULL,NULL,NULL,50.00,'C','Good','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'),(203,73,96,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'),(204,73,100,NULL,'2025-2026','Term 1','class 4A','A',60.00,100.00,NULL,NULL,NULL,NULL,60.00,'C','Good','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'),(205,73,102,NULL,'2025-2026','Term 1','class 4A','A',67.00,100.00,NULL,NULL,NULL,NULL,67.00,'B','Very Good','submitted',30,'2026-07-03 06:46:20','2026-07-03 03:16:32','2026-07-03 06:46:20'); /*!40000 ALTER TABLE `results` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `school_parents` -- DROP TABLE IF EXISTS `school_parents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `school_parents` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `relation` varchar(255) NOT NULL, `employer` varchar(255) DEFAULT NULL, `mobile` varchar(255) NOT NULL, `whatsapp` varchar(255) DEFAULT NULL, `preferred_contact` varchar(255) NOT NULL, `preferred_language` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `children_count` varchar(255) NOT NULL DEFAULT '1/1', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `school_parents` -- LOCK TABLES `school_parents` WRITE; /*!40000 ALTER TABLE `school_parents` DISABLE KEYS */; INSERT INTO `school_parents` VALUES (1,'Father 1','Father','Shell Eastern Petroleum','3212000001','3212000001','WhatsApp','EN','father1@demo.com','active','2/2','2026-06-13 10:13:05','2026-06-13 10:13:05'),(2,'Mother 1','Mother',NULL,'3453000001','3453000001','Email','EN','mother1@demo.com','active','1/2','2026-06-13 10:13:05','2026-06-13 10:13:05'),(3,'Father 2','Father','HSBC','3212000002',NULL,'SMS','EN','father2@demo.com','active','1/1','2026-06-13 10:13:05','2026-06-13 10:13:05'),(4,'Mother 2','Mother','LVMH','3453000002','3453000002','WhatsApp','FR','mother2@demo.com','active','1/1','2026-06-13 10:13:05','2026-06-13 10:13:05'); /*!40000 ALTER TABLE `school_parents` 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, `setting_key` varchar(255) NOT NULL, `setting_value` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `settings_setting_key_unique` (`setting_key`) ) ENGINE=InnoDB AUTO_INCREMENT=22 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 (5,'school_name','LUINDO SCHOOLS OF TANZANIA','2026-06-06 08:28:48','2026-06-09 09:20:38'),(6,'pass_mark','40','2026-06-06 08:28:48','2026-06-06 08:28:48'),(7,'academic_year','2025-2026','2026-06-06 08:28:48','2026-06-06 08:28:48'),(8,'sms_balance','14227','2026-06-06 08:28:48','2026-06-14 15:32:10'),(9,'school_address','P.O.BOX 1695 IRINGA','2026-06-09 09:20:38','2026-06-09 09:20:38'),(10,'school_motto','QUALITY EDUCATION FOR THE NEW GENERATION','2026-06-09 09:20:38','2026-06-09 09:20:38'),(11,'school_contact','0754 767 205 | 0763 337 177','2026-06-09 09:20:38','2026-06-09 09:20:38'),(12,'grade_a_pass','A=75%+','2026-06-09 09:20:38','2026-06-09 09:20:38'),(13,'grade_b_pass','75%+','2026-06-09 09:20:38','2026-06-09 09:20:38'),(14,'grade_c_pass','60%+','2026-06-09 09:20:38','2026-06-09 09:20:38'),(15,'grade_d_pass','55%+','2026-06-09 09:20:38','2026-06-09 09:20:38'),(16,'exam_1','Mid-Term','2026-06-09 09:20:38','2026-06-09 09:20:38'),(17,'exam_2','End-Term','2026-06-09 09:20:38','2026-06-09 09:20:38'),(18,'exam_3','National Mock','2026-06-09 09:20:38','2026-06-09 09:20:38'),(19,'school_logo','logos/wATrewJZ69xDGab1zgXNNiU3de6THuUeQgjusN7H.png','2026-06-09 09:29:38','2026-07-02 08:52:47'),(20,'results_portal_status','open','2026-07-03 05:52:22','2026-07-03 06:10:35'),(21,'auto_backup','1','2026-07-05 13:42:48','2026-07-05 16:02:33'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `staff` -- DROP TABLE IF EXISTS `staff`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `staff` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `role` varchar(255) NOT NULL, `phone` varchar(255) DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'active', `join_date` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `nin` varchar(255) DEFAULT NULL, `account_number` varchar(255) DEFAULT NULL, `salary` decimal(12,2) DEFAULT NULL, `dob` date DEFAULT NULL, `place_of_birth` varchar(255) DEFAULT NULL, `marital_status` varchar(255) DEFAULT NULL, `dependents` varchar(255) DEFAULT NULL, `academic_certificates` varchar(255) DEFAULT NULL, `professional_certificates` varchar(255) DEFAULT NULL, `tsc_number` varchar(255) DEFAULT NULL, `appointment_letter` varchar(255) DEFAULT NULL, `posting_letter` varchar(255) DEFAULT NULL, `medical_form` varchar(255) DEFAULT NULL, `attestation_form` varchar(255) DEFAULT NULL, `bank_name` varchar(255) DEFAULT NULL, `tin` varchar(255) DEFAULT NULL, `ssfn` varchar(255) DEFAULT NULL, `nhif` varchar(255) DEFAULT NULL, `nok_name` varchar(255) DEFAULT NULL, `nok_relationship` varchar(255) DEFAULT NULL, `nok_address` varchar(255) DEFAULT NULL, `nok_phone` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `staff` -- LOCK TABLES `staff` WRITE; /*!40000 ALTER TABLE `staff` DISABLE KEYS */; INSERT INTO `staff` VALUES (1,'kilamya','kilamlyavictoria00@gmail.com','Bus Driver','1234567890','active','2023-01-15',NULL,'2026-07-01 11:34:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'Jane Smith',NULL,'School Cleaner','255987654321','active','2023-05-20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Bob Security',NULL,'Security','5559876543','inactive','2022-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,'SHALON CHARLES KILAWA','shalonkilawa@gmail.com','Subject Teachers','255746439945','active','2026-06-28','2026-06-28 13:57:46','2026-07-01 09:58:46',NULL,'3939393849',NULL,'1997-07-19','Njombe','Single','2 children and 10 Wifes','staff_documents/vCGE5Arrw2EGqiGJBJ25l6Scr9anbdxiBBAsjWis.pdf','staff_documents/oMramgvig6GXjndNHURblqPsAabW5LaRypf5Ugas.pdf',NULL,'staff_documents/517mBUzA5ajxCzWLf0TzB3ePPGnsF16NTpYF0Yne.pdf','staff_documents/jzV8pTxtHNN8eKe29Ud7S3WLDDgqSw1qYd4usrSk.pdf','staff_documents/Y09DSA56OlPsKo8ZkkPax8fWUtVkCdT8DfsOj1Ub.pdf','staff_documents/lM83lFTDEWcwZ2lonWySpZOTWLjzlAa2c9zzajcp.pdf','NMB Bank Plc',NULL,NULL,NULL,'rahabu ruben sikore','Spouse','3050','0673812955'); /*!40000 ALTER TABLE `staff` 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, `admission_number` varchar(255) NOT NULL, `first_name` varchar(255) NOT NULL, `middle_name` varchar(255) DEFAULT NULL, `last_name` varchar(255) NOT NULL, `date_of_birth` date DEFAULT NULL, `gender` enum('male','female','other') DEFAULT NULL, `photo` varchar(255) DEFAULT NULL, `class` varchar(255) DEFAULT NULL, `boarding_type` enum('day','boarding') NOT NULL DEFAULT 'day', `previous_scholar_type` enum('day','boarding') DEFAULT NULL, `scholar_shifted_at` timestamp NULL DEFAULT NULL, `parent_phone` varchar(255) DEFAULT NULL, `parent_email` varchar(255) DEFAULT NULL, `portal_pin` varchar(10) DEFAULT NULL, `address` text DEFAULT NULL, `enrollment_date` date DEFAULT NULL, `status` enum('active','alumni','transferred') NOT NULL DEFAULT 'active', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `father_name` varchar(255) DEFAULT NULL, `mother_name` varchar(255) DEFAULT NULL, `guardian_name` varchar(255) DEFAULT NULL, `guardian_phone` varchar(255) DEFAULT NULL, `guardian_relation` varchar(255) DEFAULT NULL, `religion` varchar(255) DEFAULT NULL, `blood_group` varchar(255) DEFAULT NULL, `nationality` varchar(255) NOT NULL DEFAULT 'Tanzanian', `previous_school` varchar(255) DEFAULT NULL, `medical_history` text DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `students_admission_number_unique` (`admission_number`) ) ENGINE=InnoDB AUTO_INCREMENT=286 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `students` -- LOCK TABLES `students` WRITE; /*!40000 ALTER TABLE `students` DISABLE KEYS */; INSERT INTO `students` VALUES (31,'LST/2026/0001','Valentin',NULL,'Waelchi','2011-09-25','male',NULL,'Form 1','day',NULL,NULL,'(252) 902-8064','irempel@example.net','4535','482 Reichert Oval\nSuzanneton, OH 22538-6136','2025-04-16','active','2026-06-06 08:28:48','2026-06-09 11:34:02','2026-06-09 11:34:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(32,'LST/2026/0002','Sheridan','CHARLES','Greenholt','2013-05-01','female',NULL,'FORM ONE','day',NULL,NULL,'0746439945','arlie.hintz@example.com','4032','9445 Saul Overpass\r\nNew Madeline, FL 93475','2023-12-11','active','2026-06-06 08:28:48','2026-06-09 15:43:02','2026-06-09 15:43:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(33,'LST/2026/0003','Rosario',NULL,'Berge','2010-01-27','female',NULL,'Form 3','day',NULL,NULL,'1-607-476-2985','cartwright.titus@example.net','5521','33876 Miller Mountains\nHintzfurt, IL 08574','2024-04-18','active','2026-06-06 08:28:48','2026-06-09 15:43:11','2026-06-09 15:43:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(34,'LST/2026/0004','Adell','Zachery','Abernathy','2012-10-13','female',NULL,'Form 3','day',NULL,NULL,'+1 (979) 415-9740','wbeier@example.org','4517','724 Goyette Islands\nConnberg, MI 28705','2025-07-04','active','2026-06-06 08:28:48','2026-06-09 15:43:17','2026-06-09 15:43:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(35,'LST/2026/0005','Arne',NULL,'Brakus','2009-12-04','female',NULL,'Form 1','day',NULL,NULL,'+1-212-598-8217','mmoore@example.org','7109','5644 Bernardo Turnpike\nNew Gastonton, AZ 32898','2026-06-06','active','2026-06-06 08:28:48','2026-06-09 15:43:24','2026-06-09 15:43:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(36,'LST/2026/0006','Charles',NULL,'Dooley','2013-03-04','female',NULL,'Form 3','day',NULL,NULL,'+1.341.956.7255','gerry97@example.org','9762','8173 Garret Lock Suite 352\nKutchton, MO 63627-2208','2025-05-01','active','2026-06-06 08:28:48','2026-06-09 15:43:30','2026-06-09 15:43:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(37,'LST/2026/0007','Marilie','Shyann','Schroeder','2012-12-06','female',NULL,'Form 4','day',NULL,NULL,'(234) 679-6782','xlesch@example.com','3846','1314 Alfreda Trail\nSimonishaven, TX 71368-9294','2025-04-06','active','2026-06-06 08:28:48','2026-06-09 15:43:34','2026-06-09 15:43:34',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(38,'LST/2026/0008','Bryana',NULL,'Cormier','2012-05-02','female',NULL,'Form 4','day',NULL,NULL,'832.577.2261','theo.casper@example.com','3554','36857 Dooley Ranch Suite 119\nTerrytown, OK 10996','2023-12-05','active','2026-06-06 08:28:48','2026-06-09 15:43:40','2026-06-09 15:43:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(39,'LST/2026/0009','Agnes','Yasmine','Trantow','2010-02-19','male',NULL,'Form 1','day',NULL,NULL,'657.292.0121','emard.trent@example.com','8381','16747 Loma Shoals Apt. 831\nSouth Brook, NY 42599','2025-12-22','active','2026-06-06 08:28:48','2026-06-09 15:43:45','2026-06-09 15:43:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(40,'LST/2026/0010','Ubaldo',NULL,'Daugherty','2008-09-18','male',NULL,'Form 3','day',NULL,NULL,'347.278.3934','norris.deckow@example.org','7133','92408 Lon Mountains Suite 636\nWest Gregoriashire, MA 29511-5924','2025-02-26','active','2026-06-06 08:28:48','2026-06-09 15:43:51','2026-06-09 15:43:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(41,'LST/2026/0011','Winnifred',NULL,'Stamm','2011-11-21','female',NULL,'Form 1','day',NULL,NULL,'(240) 407-2940','taylor73@example.net','1728','82267 Becker Expressway Suite 983\nGregoriabury, CT 68581','2025-12-17','active','2026-06-06 08:28:48','2026-06-09 15:44:01','2026-06-09 15:44:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(42,'LST/2026/0012','Evan','Beau','Klocko','2009-04-23','male',NULL,'Form 4','day',NULL,NULL,'+1.631.938.5180','kaia.runolfsdottir@example.com','6783','781 Nelle Isle Suite 129\nKertzmannfort, NH 46964-8484','2023-11-05','active','2026-06-06 08:28:48','2026-06-09 15:44:06','2026-06-09 15:44:06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(43,'LST/2026/0013','Daphnee',NULL,'Daugherty','2011-10-08','female',NULL,'Form 1','day',NULL,NULL,'551-526-9106','nolan.soledad@example.net','6577','4313 Marcellus Brook Suite 070\nCartershire, LA 04184-2580','2026-02-09','active','2026-06-06 08:28:48','2026-06-09 15:44:11','2026-06-09 15:44:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(44,'LST/2026/0014','Marc','Lilian','Wiegand','2010-04-02','female',NULL,'Form 4','day',NULL,NULL,'719-243-4493','lemke.juliana@example.com','9523','40566 Doyle Flats Suite 613\nAdamschester, AZ 46321','2025-03-25','active','2026-06-06 08:28:48','2026-06-09 15:44:20','2026-06-09 15:44:20',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(45,'LST/2026/0015','Deonte','Jennings','Osinski','2009-07-14','male',NULL,'Form 2','day',NULL,NULL,'+1-828-461-4939','declan.runolfsdottir@example.com','9646','890 Swaniawski Vista\nAltaside, MN 36400','2024-08-16','active','2026-06-06 08:28:48','2026-06-09 15:45:38','2026-06-09 15:45:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(46,'LST/2026/0016','Mavis',NULL,'Hudson','2011-06-18','male',NULL,'Form 1','day',NULL,NULL,'1-364-345-6979','edwina20@example.com','7006','45677 Anderson Valley Suite 191\nMarquardtside, GA 00813-8318','2024-08-16','active','2026-06-06 08:28:48','2026-06-09 15:45:45','2026-06-09 15:45:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(47,'LST/2026/0017','Adeline',NULL,'Bradtke','2008-09-18','male',NULL,'Form 1','day',NULL,NULL,'+1-520-929-8913','lula43@example.net','6909','7576 Weimann Row\nWest Alifurt, LA 73637-4677','2026-05-31','active','2026-06-06 08:28:48','2026-06-09 15:45:50','2026-06-09 15:45:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(48,'LST/2026/0018','Cristal',NULL,'Hilpert','2009-06-22','male',NULL,'Form 3','day',NULL,NULL,'610.434.3378','ogerhold@example.org','4642','3573 Calista Parks\nEast Nealview, NY 00269','2025-08-13','active','2026-06-06 08:28:48','2026-06-09 15:45:55','2026-06-09 15:45:55',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(49,'LST/2026/0019','Orval','Nora','Nitzsche','2012-03-15','female',NULL,'Form 4','day',NULL,NULL,'1-628-491-6264','missouri76@example.com','9304','5042 Sunny Springs\nCierramouth, SD 14891-6475','2025-12-14','active','2026-06-06 08:28:48','2026-06-09 15:46:02','2026-06-09 15:46:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(50,'LST/2026/0020','Emmy','Zoe','Steuber','2009-02-01','female',NULL,'Form 4','day',NULL,NULL,'425.394.8251','arthur.mraz@example.net','3154','75925 Grady Spring\nFayberg, HI 90166-3515','2026-05-27','active','2026-06-06 08:28:48','2026-06-09 15:46:37','2026-06-09 15:46:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(51,'LST/2026/0021','Addie','Adah','Gleason','2009-05-22','male',NULL,'Form 1','day',NULL,NULL,'1-515-923-0190','jaren.zemlak@example.org','1579','9024 Shyanne Rest Suite 093\nPort Tyrique, IA 84398-3041','2024-02-08','active','2026-06-06 08:28:48','2026-06-09 15:46:42','2026-06-09 15:46:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(52,'LST/2026/0022','Robbie','Craig','O\'Conner','2009-01-01','female',NULL,'Form 3','day',NULL,NULL,'1-820-982-6173','tstoltenberg@example.net','6501','53677 Weston Overpass\nHammesmouth, OH 64794-7247','2026-05-03','active','2026-06-06 08:28:48','2026-06-09 15:46:23','2026-06-09 15:46:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(53,'LST/2026/0023','Reynold','Laury','Pacocha','2011-04-18','male',NULL,'Form 4','day',NULL,NULL,'615-415-9563','jaskolski.sabrina@example.net','2024','6870 O\'Conner Tunnel Suite 916\nChamplinfurt, SD 03774','2023-07-22','active','2026-06-06 08:28:48','2026-06-09 15:46:29','2026-06-09 15:46:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(54,'LST/2026/0024','Berta','Arch','Hyatt','2013-09-17','female',NULL,'Form 4','day',NULL,NULL,'580-830-0336','bulah97@example.net','2458','453 Breitenberg Ports\nBernierton, MA 28969-2998','2024-08-25','active','2026-06-06 08:28:48','2026-06-09 15:46:47','2026-06-09 15:46:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(55,'LST/2026/0025','Shaina',NULL,'Little','2013-12-11','female',NULL,'Form 1','day',NULL,NULL,'1-520-830-9646','damore.andrew@example.com','6275','4603 Beatty Landing Apt. 041\nRennertown, CO 84726-4188','2024-05-02','active','2026-06-06 08:28:48','2026-06-09 15:46:52','2026-06-09 15:46:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(56,'LST/2026/0026','Maurine','Katlyn','Rice','2011-04-27','female',NULL,'Form 2','day',NULL,NULL,'+1-727-264-9566','ogorczany@example.org','4527','9150 Newton Glens\nPort Jordichester, NM 94890-9756','2026-04-19','active','2026-06-06 08:28:48','2026-06-09 15:47:03','2026-06-09 15:47:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(57,'LST/2026/0027','Kirsten',NULL,'Kemmer','2012-10-19','male',NULL,'Form 4','day',NULL,NULL,'307.987.3862','brennon.gorczany@example.org','5724','507 Monty View Suite 754\nDarrenmouth, DC 56818-4785','2025-04-10','active','2026-06-06 08:28:48','2026-06-09 15:47:07','2026-06-09 15:47:07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(58,'LST/2026/0028','Evans','Drake','Heidenreich','2013-08-12','male',NULL,'Form 1','day',NULL,NULL,'678.503.0929','kristofer.heathcote@example.net','7393','4237 Purdy Glen Suite 447\nMichellestad, FL 88555-7988','2024-12-09','active','2026-06-06 08:28:48','2026-06-09 15:46:17','2026-06-09 15:46:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(59,'LST/2026/0029','Lottie',NULL,'Tremblay','2012-12-29','male',NULL,'Form 2','day',NULL,NULL,'+1.680.994.0558','eloisa30@example.net','9857','7025 Joanny Rue Apt. 175\nRobelshire, KY 19178-6751','2026-03-12','active','2026-06-06 08:28:48','2026-06-09 15:47:11','2026-06-09 15:47:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(60,'LST/2026/0030','Laurie','Nadia','Heidenreich','2010-07-10','female',NULL,'Form 2','day',NULL,NULL,'978.800.7470','mitchell75@example.org','4809','797 Wintheiser Trail\nNew Rudy, UT 08816','2025-01-24','active','2026-06-06 08:28:48','2026-06-09 15:46:56','2026-06-09 15:46:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(62,'LST/2026/0031','JACKSON','J','CHOTA','2003-10-08','female',NULL,'CLASS 6A','day','boarding','2026-06-17 02:35:00','+255746439945','shalonkilawa@gmail.com','4474','89','2026-06-09','active','2026-06-09 11:14:14','2026-06-26 20:30:24','2026-06-26 20:30:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(63,'LST/2026/0032','CAREN','C','NDUNGURU','2003-10-09','female',NULL,'CLASS 4B','boarding','day','2026-06-17 02:53:09','+255746439945','shalonkilawa@gmail.com','5467','89','2026-06-10','active','2026-06-09 11:15:08','2026-06-26 20:30:29','2026-06-26 20:30:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(64,'LST/2026/0033','ROSEMARY','M','MORATTY','2002-09-04','female',NULL,'class 4A','day',NULL,NULL,'255764895283','kilamlyavictoria00@gmail.com','2357','89','2026-06-11','active','2026-06-09 11:19:18','2026-07-02 11:53:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(65,'LST/2026/0034','PRISCA','I','IGNASY','2005-05-08','female',NULL,'class 4A','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','4125','89','2026-06-12','active','2026-06-09 11:21:14','2026-07-02 14:51:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(66,'LST/2026/0035','MOUREEN','S','LYIMO','2020-06-04','female',NULL,'class 4A','day',NULL,NULL,'255754767205','shalonkilawa@gmail.com','6548','89','2026-06-13','active','2026-06-09 11:36:05','2026-07-02 14:53:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(67,'LST/2026/0036','ETHAN ','F','FUNDISHA','2003-10-09','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-14','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(68,'LST/2026/0037','ANETH ','C','MWAGIKE','2002-09-04','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-15','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(69,'LST/2026/0038','JACKLINE ','S','KAMWELANGA','2005-05-08','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-16','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(70,'LST/2026/0039','FELIX','S','MWAKALUNDE','2020-06-04','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-17','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(71,'LST/2026/0040','GIAN ','T','HONGA','2003-10-09','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-18','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(72,'LST/2026/0041','EVELYNE ','D','MSIGWA','2002-09-04','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-19','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(73,'LST/2026/0042','ROSHNIE ','H','MGAO','2005-05-08','female',NULL,'class 4A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-20','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(74,'LST/2026/0043','ASLAM ','H','MBOYA','2020-06-04','female',NULL,'class 4B','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-21','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(75,'LST/2026/0044','ZIPORA ','S','MWANJALA','2003-10-09','female',NULL,'class 4B','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','','89','2026-06-22','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(76,'LST/2026/0045','DANIEL ','F','MAKOYE','2002-09-04','male',NULL,'class 4B','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','','89','2026-06-23','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(77,'LST/2026/0046','HELLEN','C',' MSUMBA','2005-05-08','male',NULL,'class 4B','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','','89','2026-06-24','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(78,'LST/2026/0047','CLARA ','S','MNEMBA','2020-06-04','male',NULL,'class 4B','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','','89','2026-06-25','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(79,'LST/2026/0048','CRISTER ','S','CHANDAFA','2020-06-05','male',NULL,'class 4B','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','','89','2026-06-26','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(80,'LST/2026/0049','MEHR ','T','MSUMARI','2020-06-06','male',NULL,'class 4B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-06-27','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(81,'LST/2026/0050','AIFA ','D','MUYINGA','2020-06-07','male',NULL,'class 4B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-06-28','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(82,'LST/2026/0051','GRACE ','H','FUNDISHA','2020-06-08','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-06-29','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(83,'LST/2026/0052','JANETH ','S','ONGENG\'ENA','2020-06-09','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-06-30','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(84,'LST/2026/0053','CLARA ','F','TARIMO','2020-06-10','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-01','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(85,'LST/2026/0054','GEORGE ','C','MASUKA','2020-06-11','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-02','active','2026-06-09 20:17:15','2026-06-09 20:26:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(86,'LST/2026/0055','ALLAN ','S','DICKSON','2020-06-12','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-03','active','2026-06-09 20:17:15','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(87,'LST/2026/0056','AYRAT ','S','ABDALLAH','2020-06-13','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-04','active','2026-06-09 20:17:15','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(88,'LST/2026/0057','RUMAYFAH ','T','SWAI','2020-06-14','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-05','active','2026-06-09 20:17:15','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(89,'LST/2026/0058','HERMAN ','D','MSAMBA','2020-06-15','male',NULL,'class 3A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-06','active','2026-06-09 20:17:15','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(90,'LST/2026/0059','FAHIMA ','S','HAMZA','2020-06-16','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-07','active','2026-06-09 20:17:15','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(91,'LST/2026/0060','BENAYA ','F','FUNGO','2020-06-17','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-08','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(92,'LST/2026/0061','BLESS ','C','KIBUGA','2020-06-18','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-09','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(93,'LST/2026/0062','MELVIN ','S','KAVINDI','2020-06-19','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-10','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(94,'LST/2026/0063','LAMECK ','S','MMBANDO','2020-06-20','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-11','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(95,'LST/2026/0064','BELINDA ','T','BENEDICT','2020-06-21','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-12','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(96,'LST/2026/0065','NURDEEN ','D','WARIOBA','2020-06-22','male',NULL,'class 7B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-13','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(97,'LST/2026/0066','ADAM ','H','HAULE','2020-06-23','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-14','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(98,'LST/2026/0067','ANGEL ','S','KIKOTI','2020-06-24','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-15','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(99,'LST/2026/0068','NIVAN ','F','KABISAMA','2020-06-25','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-16','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(100,'LST/2026/0069','ABDILLAH','C','MBWAMBO','2020-06-26','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-17','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(101,'LST/2026/0070','ERENEST ','S','JULIUS','2020-06-27','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-18','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(102,'LST/2026/0071','ILHAM ','S','BATTY','2020-06-28','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-19','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(103,'LST/2026/0072','JONAS ','T','MSOVELA','2020-06-29','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-20','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(104,'LST/2026/0073','SUMAIYA ','D','OBED','2020-06-30','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-21','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(105,'LST/2026/0074','SAMIA ','H','SALEHE','2020-07-01','male',NULL,'class 6A','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-22','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(106,'LST/2026/0075','DORIS ','H','MARWA','2020-07-02','male',NULL,'class 5B','day',NULL,NULL,'255622822858','nasri@gmail.com','','89','2026-07-23','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(107,'LST/2026/0076','CALORIN ','H','MVANDA','2020-07-03','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-24','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(108,'LST/2026/0077','NARDE ','H','SANGA','2020-07-04','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-25','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(109,'LST/2026/0078','CLAUDIA ','H','BALAMA','2020-07-05','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-26','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(110,'LST/2026/0079','ETHAN ','H','MWINGILA','2020-07-06','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-27','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(111,'LST/2026/0080','NAVEEN ','H','SHAYO','2020-07-07','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-28','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(112,'LST/2026/0081','LODRICK ','H','MWAKALINGA','2020-07-08','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-29','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(113,'LST/2026/0082','URICE ','H','JUMAPILI ','2020-07-09','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-30','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(114,'LST/2026/0083','WEMA ','H','NJOGOLO','2020-07-10','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-07-31','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(115,'LST/2026/0084','DERICK ','H','MGATA','2020-07-11','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-01','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(116,'LST/2026/0085','NAVEEN ','H','MBUGI','2020-07-12','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-02','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(117,'LST/2026/0086','ARIANA','H','CHARLES','2020-07-13','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-03','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(118,'LST/2026/0087','DANIEL ','H','MBANGULE','2020-07-14','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-04','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(119,'LST/2026/0088','COLLINS ','H','SANGA','2020-07-15','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-05','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(120,'LST/2026/0089','YASSIR ','H','IDDY','2020-07-16','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-06','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(121,'LST/2026/0090','JESCA ','H','SOLOMON','2020-07-17','male',NULL,'class 5B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-07','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(122,'LST/2026/0091','ELIA ','H','NGUGE','2020-07-18','male',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-08','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(123,'LST/2026/0092','AUSTIN ','H','MWASEMELE ','2020-07-19','male',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-09','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(124,'LST/2026/0093','EVANCE ','H','EMMANUEL','2020-07-20','male',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-10','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(125,'LST/2026/0094','KENDRICK ','H','NCHIMBI','2020-07-21','male',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-11','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(126,'LST/2026/0095','BARAKA ','H','KISWANYA','2020-07-22','female',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-12','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(127,'LST/2026/0096','ANTONIO ','H','GOODLUCK','2020-07-23','female',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-13','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(128,'LST/2026/0097','JAYDAN ','H','NCHIMBI','2020-07-24','female',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-14','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(129,'LST/2026/0098','YASSIR ','H','HAMISI','2020-07-25','female',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-15','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(130,'LST/2026/0099','AVIEL ','H','KIPONDA','2020-07-26','female',NULL,'class 3A','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-16','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(131,'LST/2026/0100','IVON ','H','MBATA','2020-07-27','female',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-17','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(132,'LST/2026/0101','AVIEL ','H','LYAUPE','2020-07-28','female',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-18','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(133,'LST/2026/0102','JAYDEN ','H','NSUBIS','2020-07-29','female',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-19','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(134,'LST/2026/0103','ELIAKIM ','H','NYAULINGO','2020-07-30','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-20','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(135,'LST/2026/0104','ERICK ','H','HAONGA','2020-07-31','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-21','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(136,'LST/2026/0105','CRESPO ','H','MLANDALI','2020-08-01','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-22','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(137,'LST/2026/0106','IVAN ','H','TEMBO','2020-08-02','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-23','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(138,'LST/2026/0107','NAIMA ','H','NTONGEKA','2020-08-03','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-24','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(139,'LST/2026/0108','NOREEN ','H','KALINGA','2020-08-04','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-25','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(140,'LST/2026/0109','GLORY ','H','NDOMBA','2020-08-05','male',NULL,'class 3B','day',NULL,NULL,'255746439945','nasri@gmail.com','','89','2026-08-26','active','2026-06-09 20:17:16','2026-06-09 20:26:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(141,'LST/2026/0110','JACKSON ','c','CHOTA','2003-10-08','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','9828','89','2026-06-09','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(142,'LST/2026/0111','CAREN ','g','NDUNGURU','2003-10-09','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','5805','89','2026-06-10','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(143,'LST/2026/0112','ROSEMARY ','h','MORATTY','2002-09-04','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7133','89','2026-06-11','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(144,'LST/2026/0113','PRISCA ','k','IGNASY','2005-05-08','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2260','89','2026-06-12','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(145,'LST/2026/0114','MOUREEN ','s','LYIMO','2020-06-04','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','3397','89','2026-06-13','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(146,'LST/2026/0115','ETHAN ','c','FUNDISHA','2003-10-09','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','5022','89','2026-06-14','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(147,'LST/2026/0116','ANETH ','C','MWAGIKE','2002-09-04','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7732','89','2026-06-15','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(148,'LST/2026/0117','JACKLINE ','S','KAMWELANGA','2005-05-08','male',NULL,'Form 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','0008','89','2026-06-16','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(149,'LST/2026/0118','FELIX','S','MWAKALUNDE','2020-06-04','male',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7138','89','2026-06-17','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(150,'LST/2026/0119','GIAN ','T','HONGA','2003-10-09','male',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','4559','89','2026-06-18','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(151,'LST/2026/0120','EVELYNE ','D','MSIGWA','2002-09-04','male',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7969','89','2026-06-19','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(152,'LST/2026/0121','ROSHNIE ','H','MGAO','2005-05-08','male',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','1756','89','2026-06-20','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(153,'LST/2026/0122','ASLAM ','H','MBOYA','2020-06-04','male',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','1288','89','2026-06-21','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(154,'LST/2026/0123','ZIPORA ','S','MWANJALA','2003-10-09','female',NULL,'Form 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','1354','89','2026-06-22','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(155,'LST/2026/0124','DANIEL ','F','MAKOYE','2002-09-04','female',NULL,'Form 2','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','6775','89','2026-06-23','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(156,'LST/2026/0125','HELLEN','C',' MSUMBA','2005-05-08','female',NULL,'Form 2','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','1438','89','2026-06-24','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(157,'LST/2026/0126','CLARA ','S','MNEMBA','2020-06-04','female',NULL,'Form 2','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','8197','89','2026-06-25','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(158,'LST/2026/0127','CRISTER ','S','CHANDAFA','2020-06-05','female',NULL,'Form 2','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','0347','89','2026-06-26','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(159,'LST/2026/0128','MEHR ','T','MSUMARI','2020-06-06','female',NULL,'Form 2','day',NULL,NULL,'255622822858','nasri@gmail.com','8144','89','2026-06-27','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(160,'LST/2026/0129','AIFA ','D','MUYINGA','2020-06-07','female',NULL,'Form 2','day',NULL,NULL,'255622822858','nasri@gmail.com','3859','89','2026-06-28','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(161,'LST/2026/0130','GRACE ','H','FUNDISHA','2020-06-08','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','1892','89','2026-06-29','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(162,'LST/2026/0131','JANETH ','S','ONGENG\'ENA','2020-06-09','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','0498','89','2026-06-30','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(163,'LST/2026/0132','CLARA ','F','TARIMO','2020-06-10','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','4215','89','2026-07-01','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(164,'LST/2026/0133','GEORGE ','C','MASUKA','2020-06-11','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','8224','89','2026-07-02','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(165,'LST/2026/0134','ALLAN ','S','DICKSON','2020-06-12','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','5115','89','2026-07-03','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(166,'LST/2026/0135','AYRAT ','S','ABDALLAH','2020-06-13','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','1212','89','2026-07-04','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(167,'LST/2026/0136','RUMAYFAH ','T','SWAI','2020-06-14','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','9083','89','2026-07-05','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(168,'LST/2026/0137','HERMAN ','D','MSAMBA','2020-06-15','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','7999','89','2026-07-06','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(169,'LST/2026/0138','FAHIMA ','S','HAMZA','2020-06-16','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','4190','89','2026-07-07','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(170,'LST/2026/0139','BENAYA ','F','FUNGO','2020-06-17','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','5978','89','2026-07-08','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(171,'LST/2026/0140','BLESS ','C','KIBUGA','2020-06-18','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','6878','89','2026-07-09','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(172,'LST/2026/0141','MELVIN ','S','KAVINDI','2020-06-19','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','5685','89','2026-07-10','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(173,'LST/2026/0142','LAMECK ','S','MMBANDO','2020-06-20','female',NULL,'Form 1','day',NULL,NULL,'255622822858','nasri@gmail.com','5815','89','2026-07-11','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(174,'LST/2026/0143','BELINDA ','T','BENEDICT','2020-06-21','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','0087','89','2026-07-12','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(175,'LST/2026/0144','NURDEEN ','D','WARIOBA','2020-06-22','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','3177','89','2026-07-13','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(176,'LST/2026/0145','ADAM ','H','HAULE','2020-06-23','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','4944','89','2026-07-14','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(177,'LST/2026/0146','ANGEL ','S','KIKOTI','2020-06-24','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','6201','89','2026-07-15','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(178,'LST/2026/0147','NIVAN ','F','KABISAMA','2020-06-25','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','4293','89','2026-07-16','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(179,'LST/2026/0148','ABDILLAH','C','MBWAMBO','2020-06-26','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','4317','89','2026-07-17','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(180,'LST/2026/0149','ERENEST ','S','JULIUS','2020-06-27','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','3700','89','2026-07-18','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(181,'LST/2026/0150','ILHAM ','S','BATTY','2020-06-28','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','2482','89','2026-07-19','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(182,'LST/2026/0151','JONAS ','T','MSOVELA','2020-06-29','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','9365','89','2026-07-20','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(183,'LST/2026/0152','SUMAIYA ','D','OBED','2020-06-30','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','8370','89','2026-07-21','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(184,'LST/2026/0153','SAMIA ','H','SALEHE','2020-07-01','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','4304','89','2026-07-22','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(185,'LST/2026/0154','DORIS ','H','MARWA','2020-07-02','female',NULL,'Form 3','day',NULL,NULL,'255622822858','nasri@gmail.com','8430','89','2026-07-23','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(186,'LST/2026/0155','CALORIN ','H','MVANDA','2020-07-03','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','5971','89','2026-07-24','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(187,'LST/2026/0156','NARDE ','H','SANGA','2020-07-04','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','3219','89','2026-07-25','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(188,'LST/2026/0157','CLAUDIA ','H','BALAMA','2020-07-05','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','8612','89','2026-07-26','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(189,'LST/2026/0158','ETHAN ','H','MWINGILA','2020-07-06','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','9743','89','2026-07-27','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(190,'LST/2026/0159','NAVEEN ','H','SHAYO','2020-07-07','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','4405','89','2026-07-28','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(191,'LST/2026/0160','LODRICK ','H','MWAKALINGA','2020-07-08','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','7692','89','2026-07-29','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(192,'LST/2026/0161','URICE ','H','JUMAPILI ','2020-07-09','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','4197','89','2026-07-30','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(193,'LST/2026/0162','WEMA ','H','NJOGOLO','2020-07-10','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','7430','89','2026-07-31','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(194,'LST/2026/0163','DERICK ','H','MGATA','2020-07-11','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','2440','89','2026-08-01','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(195,'LST/2026/0164','NAVEEN ','H','MBUGI','2020-07-12','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','0446','89','2026-08-02','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(196,'LST/2026/0165','ARIANA','H','CHARLES','2020-07-13','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','4111','89','2026-08-03','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(197,'LST/2026/0166','DANIEL ','H','MBANGULE','2020-07-14','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','1947','89','2026-08-04','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(198,'LST/2026/0167','COLLINS ','H','SANGA','2020-07-15','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','8471','89','2026-08-05','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(199,'LST/2026/0168','YASSIR ','H','IDDY','2020-07-16','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','8814','89','2026-08-06','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(200,'LST/2026/0169','JESCA ','H','SOLOMON','2020-07-17','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','9012','89','2026-08-07','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(201,'LST/2026/0170','ELIA ','H','NGUGE','2020-07-18','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','7937','89','2026-08-08','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(202,'LST/2026/0171','AUSTIN ','H','MWASEMELE ','2020-07-19','female',NULL,'Form 4','day',NULL,NULL,'255746439945','nasri@gmail.com','2221','89','2026-08-09','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(203,'LST/2026/0172','EVANCE ','H','EMMANUEL','2020-07-20','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','6735','89','2026-08-10','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(204,'LST/2026/0173','KENDRICK ','H','NCHIMBI','2020-07-21','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','8169','89','2026-08-11','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(205,'LST/2026/0174','BARAKA ','H','KISWANYA','2020-07-22','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','0105','89','2026-08-12','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(206,'LST/2026/0175','ANTONIO ','H','GOODLUCK','2020-07-23','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','0292','89','2026-08-13','active','2026-06-09 20:39:51','2026-06-09 20:39:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(207,'LST/2026/0176','JAYDAN ','H','NCHIMBI','2020-07-24','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','9087','89','2026-08-14','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(208,'LST/2026/0177','YASSIR ','H','HAMISI','2020-07-25','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','2407','89','2026-08-15','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(209,'LST/2026/0178','AVIEL ','H','KIPONDA','2020-07-26','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','6821','89','2026-08-16','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(210,'LST/2026/0179','IVON ','H','MBATA','2020-07-27','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','6509','89','2026-08-17','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(211,'LST/2026/0180','AVIEL ','H','LYAUPE','2020-07-28','male',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','0000','89','2026-08-18','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(212,'LST/2026/0181','JAYDEN ','H','NSUBIS','2020-07-29','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','1176','89','2026-08-19','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(213,'LST/2026/0182','ELIAKIM ','H','NYAULINGO','2020-07-30','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','7944','89','2026-08-20','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(214,'LST/2026/0183','ERICK ','H','HAONGA','2020-07-31','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','6753','89','2026-08-21','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(215,'LST/2026/0184','CRESPO ','H','MLANDALI','2020-08-01','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','8138','89','2026-08-22','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(216,'LST/2026/0185','IVAN ','H','TEMBO','2020-08-02','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','3065','89','2026-08-23','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(217,'LST/2026/0186','NAIMA ','H','NTONGEKA','2020-08-03','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','3995','89','2026-08-24','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(218,'LST/2026/0187','NOREEN ','H','KALINGA','2020-08-04','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','3802','89','2026-08-25','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(219,'LST/2026/0188','GLORY ','H','NDOMBA','2020-08-05','female',NULL,'Form 1','day',NULL,NULL,'255746439945','nasri@gmail.com','8224','89','2026-08-26','active','2026-06-09 20:39:52','2026-06-09 20:39:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(220,'LST/2026/0189','FELIX','S','MWAKALUNDE','2020-06-04','male',NULL,'KG 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','5686','89','2026-06-17','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(221,'LST/2026/0190','GIAN','T','HONGA','2003-10-09','male',NULL,'KG 1','boarding','day','2026-06-17 02:52:27','255746439945','shalonkilawa@gmail.com','4913','89','2026-06-18','active','2026-06-09 20:44:31','2026-06-17 02:52:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(222,'LST/2026/0191','EVELYNE ','D','MSIGWA','2002-09-04','male',NULL,'KG 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2762','89','2026-06-19','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(223,'LST/2026/0192','ROSHNIE ','H','MGAO','2005-05-08','male',NULL,'KG 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2487','89','2026-06-20','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(224,'LST/2026/0193','ASLAM ','H','MBOYA','2020-06-04','male',NULL,'KG 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2112','89','2026-06-21','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(225,'LST/2026/0194','ZIPORA ','S','MWANJALA','2003-10-09','female',NULL,'KG 1','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2051','89','2026-06-22','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(226,'LST/2026/0195','DANIEL ','F','MAKOYE','2002-09-04','female',NULL,'KG 1','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','4093','89','2026-06-23','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(227,'LST/2026/0196','HELLEN','C',' MSUMBA','2005-05-08','female',NULL,'KG 3','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','8228','89','2026-06-24','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(228,'LST/2026/0197','CLARA ','S','MNEMBA','2020-06-04','female',NULL,'KG 3','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','9778','89','2026-06-25','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(229,'LST/2026/0198','CRISTER ','S','CHANDAFA','2020-06-05','female',NULL,'KG 3','day',NULL,NULL,'255622822858','shalonkilawa@gmail.com','7540','89','2026-06-26','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(230,'LST/2026/0199','MEHR ','T','MSUMARI','2020-06-06','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','1006','89','2026-06-27','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(231,'LST/2026/0200','AIFA ','D','MUYINGA','2020-06-07','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','9496','89','2026-06-28','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(232,'LST/2026/0201','GRACE ','H','FUNDISHA','2020-06-08','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','4104','89','2026-06-29','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(233,'LST/2026/0202','JANETH ','S','ONGENG\'ENA','2020-06-09','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','9837','89','2026-06-30','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(234,'LST/2026/0203','CLARA ','F','TARIMO','2020-06-10','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','2486','89','2026-07-01','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(235,'LST/2026/0204','GEORGE ','C','MASUKA','2020-06-11','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','6592','89','2026-07-02','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(236,'LST/2026/0205','ALLAN ','S','DICKSON','2020-06-12','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','2029','89','2026-07-03','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(237,'LST/2026/0206','AYRAT ','S','ABDALLAH','2020-06-13','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','7598','89','2026-07-04','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(238,'LST/2026/0207','RUMAYFAH ','T','SWAI','2020-06-14','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','7295','89','2026-07-05','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(239,'LST/2026/0208','HERMAN ','D','MSAMBA','2020-06-15','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','3151','89','2026-07-06','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(240,'LST/2026/0209','FAHIMA ','S','HAMZA','2020-06-16','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','2873','89','2026-07-07','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(241,'LST/2026/0210','BENAYA ','F','FUNGO','2020-06-17','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','8845','89','2026-07-08','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(242,'LST/2026/0211','BLESS ','C','KIBUGA','2020-06-18','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','9003','89','2026-07-09','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(243,'LST/2026/0212','MELVIN ','S','KAVINDI','2020-06-19','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','3986','89','2026-07-10','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(244,'LST/2026/0213','LAMECK ','S','MMBANDO','2020-06-20','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','9747','89','2026-07-11','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(245,'LST/2026/0214','BELINDA ','T','BENEDICT','2020-06-21','female',NULL,'KG 3','day',NULL,NULL,'255622822858','nasri@gmail.com','1224','89','2026-07-12','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(246,'LST/2026/0215','JONAS ','T','MSOVELA','2020-06-29','female',NULL,'KG 2','day',NULL,NULL,'255622822858','nasri@gmail.com','6688','89','2026-07-20','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(247,'LST/2026/0216','SUMAIYA ','D','OBED','2020-06-30','female',NULL,'KG 2','day',NULL,NULL,'255622822858','nasri@gmail.com','5675','89','2026-07-21','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(248,'LST/2026/0217','SAMIA ','H','SALEHE','2020-07-01','female',NULL,'KG 2','day',NULL,NULL,'255622822858','nasri@gmail.com','7269','89','2026-07-22','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(249,'LST/2026/0218','DORIS ','H','MARWA','2020-07-02','female',NULL,'KG 2','day',NULL,NULL,'255622822858','nasri@gmail.com','3665','89','2026-07-23','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(250,'LST/2026/0219','CALORIN ','H','MVANDA','2020-07-03','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','5372','89','2026-07-24','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(251,'LST/2026/0220','NARDE ','H','SANGA','2020-07-04','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','3602','89','2026-07-25','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(252,'LST/2026/0221','CLAUDIA ','H','BALAMA','2020-07-05','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','7423','89','2026-07-26','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(253,'LST/2026/0222','ETHAN ','H','MWINGILA','2020-07-06','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','4675','89','2026-07-27','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(254,'LST/2026/0223','NAVEEN ','H','SHAYO','2020-07-07','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','0829','89','2026-07-28','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(255,'LST/2026/0224','LODRICK ','H','MWAKALINGA','2020-07-08','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','1632','89','2026-07-29','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(256,'LST/2026/0225','URICE ','H','JUMAPILI ','2020-07-09','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','1179','89','2026-07-30','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(257,'LST/2026/0226','WEMA ','H','NJOGOLO','2020-07-10','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','7885','89','2026-07-31','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(258,'LST/2026/0227','DERICK ','H','MGATA','2020-07-11','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','3949','89','2026-08-01','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(259,'LST/2026/0228','NAVEEN ','H','MBUGI','2020-07-12','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','7451','89','2026-08-02','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(260,'LST/2026/0229','ARIANA','H','CHARLES','2020-07-13','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','9536','89','2026-08-03','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(261,'LST/2026/0230','DANIEL ','H','MBANGULE','2020-07-14','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','7401','89','2026-08-04','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(262,'LST/2026/0231','COLLINS ','H','SANGA','2020-07-15','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','9004','89','2026-08-05','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(263,'LST/2026/0232','YASSIR ','H','IDDY','2020-07-16','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','4410','89','2026-08-06','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(264,'LST/2026/0233','JESCA ','H','SOLOMON','2020-07-17','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','0659','89','2026-08-07','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(265,'LST/2026/0234','ELIA ','H','NGUGE','2020-07-18','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','8277','89','2026-08-08','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(266,'LST/2026/0235','AUSTIN ','H','MWASEMELE ','2020-07-19','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','3050','89','2026-08-09','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(267,'LST/2026/0236','EVANCE ','H','EMMANUEL','2020-07-20','female',NULL,'KG 2','day',NULL,NULL,'255746439945','nasri@gmail.com','2816','89','2026-08-10','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(268,'LST/2026/0237','KENDRICK ','H','NCHIMBI','2020-07-21','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7290','89','2026-08-11','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(269,'LST/2026/0238','BARAKA ','H','KISWANYA','2020-07-22','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','0027','89','2026-08-12','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(270,'LST/2026/0239','ANTONIO ','H','GOODLUCK','2020-07-23','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2621','89','2026-08-13','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(271,'LST/2026/0240','JAYDAN ','H','NCHIMBI','2020-07-24','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','5758','89','2026-08-14','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(272,'LST/2026/0241','YASSIR ','H','HAMISI','2020-07-25','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','4413','89','2026-08-15','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(273,'LST/2026/0242','AVIEL ','H','KIPONDA','2020-07-26','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','1254','89','2026-08-16','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(274,'LST/2026/0243','IVON ','H','MBATA','2020-07-27','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','0782','89','2026-08-17','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(275,'LST/2026/0244','AVIEL ','H','LYAUPE','2020-07-28','male',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','5762','89','2026-08-18','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(276,'LST/2026/0245','JAYDEN ','H','NSUBIS','2020-07-29','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','7399','89','2026-08-19','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(277,'LST/2026/0246','ELIAKIM ','H','NYAULINGO','2020-07-30','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','3322','89','2026-08-20','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(278,'LST/2026/0247','ERICK ','H','HAONGA','2020-07-31','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','1521','89','2026-08-21','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(279,'LST/2026/0248','CRESPO ','H','MLANDALI','2020-08-01','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','3122','89','2026-08-22','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(280,'LST/2026/0249','IVAN ','H','TEMBO','2020-08-02','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','0980','89','2026-08-23','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(281,'LST/2026/0250','NAIMA ','H','NTONGEKA','2020-08-03','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','3002','89','2026-08-24','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(282,'LST/2026/0251','NOREEN ','H','KALINGA','2020-08-04','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','8936','89','2026-08-25','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(283,'LST/2026/0252','GLORY ','H','NDOMBA','2020-08-05','female',NULL,'KG 2','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','0718','89','2026-08-26','active','2026-06-09 20:44:31','2026-06-09 20:44:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tanzanian',NULL,NULL),(284,'LST/2026/0253','Charles','Charles','Kilawa','2012-06-20','male','students/XzpUJtZ12UEPwF4X39CjnKzxMcQ61z51vLsUfccc.jpg','CLASS 1A','day',NULL,NULL,'255746439945','shalonkilawa@gmail.com','2087','IRINGA','2026-06-17','active','2026-06-17 01:41:03','2026-06-17 01:41:03',NULL,'Shalon kilawa','Vic kil','Shalon kilawa','255746439945','Father','Iringa','O+','Tanzanian','-','-'),(285,'LST/2026/0254','DOREEN','CHARLES','KILAWA','2017-02-27','female',NULL,'FORM FOUR','boarding',NULL,NULL,'255746439945','shalonkilawa@gmail.com','8000','IRINGA','2026-06-26','active','2026-06-26 20:33:35','2026-06-26 20:33:35',NULL,'Shalon charles kilawa','Vk','Shalon kilawa','255746439945','Father','Iringa','O+','Tanzanian',NULL,NULL); /*!40000 ALTER TABLE `students` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subject_classes` -- DROP TABLE IF EXISTS `subject_classes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subject_classes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_id` bigint(20) unsigned NOT NULL, `class_name` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `subject_classes_subject_id_foreign` (`subject_id`), CONSTRAINT `subject_classes_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subject_classes` -- LOCK TABLES `subject_classes` WRITE; /*!40000 ALTER TABLE `subject_classes` DISABLE KEYS */; INSERT INTO `subject_classes` VALUES (26,31,'CLASS 1A','2026-06-27 06:20:16','2026-06-27 06:20:16'),(27,31,'CLASS 1B','2026-06-27 06:20:16','2026-06-27 06:20:16'),(30,32,'CLASS 1A','2026-06-27 06:21:53','2026-06-27 06:21:53'),(31,32,'CLASS 1B','2026-06-27 06:21:53','2026-06-27 06:21:53'),(32,33,'CLASS 1A','2026-06-27 06:22:21','2026-06-27 06:22:21'),(33,33,'CLASS 1B','2026-06-27 06:22:21','2026-06-27 06:22:21'),(34,34,'CLASS 1A','2026-06-27 06:22:58','2026-06-27 06:22:58'),(35,34,'CLASS 1B','2026-06-27 06:22:58','2026-06-27 06:22:58'),(36,35,'CLASS 1A','2026-06-27 06:27:34','2026-06-27 06:27:34'),(37,35,'CLASS 1B','2026-06-27 06:27:34','2026-06-27 06:27:34'),(38,36,'CLASS 2A','2026-06-27 06:29:09','2026-06-27 06:29:09'),(39,36,'CLASS 2B','2026-06-27 06:29:09','2026-06-27 06:29:09'),(40,37,'CLASS 2A','2026-06-27 06:29:35','2026-06-27 06:29:35'),(41,37,'CLASS 2B','2026-06-27 06:29:35','2026-06-27 06:29:35'),(42,38,'CLASS 2A','2026-06-27 06:37:02','2026-06-27 06:37:02'),(43,38,'CLASS 2B','2026-06-27 06:37:02','2026-06-27 06:37:02'),(44,39,'CLASS 2A','2026-06-27 06:37:20','2026-06-27 06:37:20'),(45,39,'CLASS 2B','2026-06-27 06:37:20','2026-06-27 06:37:20'),(46,40,'CLASS 2A','2026-06-27 06:37:40','2026-06-27 06:37:40'),(47,40,'CLASS 2B','2026-06-27 06:37:40','2026-06-27 06:37:40'),(48,41,'CLASS 2A','2026-06-27 06:38:11','2026-06-27 06:38:11'),(49,41,'CLASS 2B','2026-06-27 06:38:11','2026-06-27 06:38:11'),(50,42,'CLASS 2A','2026-06-27 06:38:27','2026-06-27 06:38:27'),(51,42,'CLASS 2B','2026-06-27 06:38:27','2026-06-27 06:38:27'),(52,43,'CLASS 3A','2026-06-27 06:39:23','2026-06-27 06:39:23'),(53,43,'CLASS 3B','2026-06-27 06:39:23','2026-06-27 06:39:23'),(54,44,'CLASS 3A','2026-06-27 06:39:36','2026-06-27 06:39:36'),(55,44,'CLASS 3B','2026-06-27 06:39:36','2026-06-27 06:39:36'),(56,45,'CLASS 3A','2026-06-27 06:44:44','2026-06-27 06:44:44'),(57,45,'CLASS 3B','2026-06-27 06:44:44','2026-06-27 06:44:44'),(58,46,'CLASS 3A','2026-06-27 06:45:19','2026-06-27 06:45:19'),(59,46,'CLASS 3B','2026-06-27 06:45:19','2026-06-27 06:45:19'),(60,47,'CLASS 3A','2026-06-27 06:45:35','2026-06-27 06:45:35'),(61,47,'CLASS 3B','2026-06-27 06:45:35','2026-06-27 06:45:35'),(62,48,'CLASS 3A','2026-06-27 06:45:55','2026-06-27 06:45:55'),(63,48,'CLASS 3B','2026-06-27 06:45:55','2026-06-27 06:45:55'),(64,49,'CLASS 3A','2026-06-27 06:46:10','2026-06-27 06:46:10'),(65,49,'CLASS 3B','2026-06-27 06:46:10','2026-06-27 06:46:10'),(66,50,'CLASS 5A','2026-06-27 06:47:16','2026-06-27 06:47:16'),(67,50,'CLASS 5B','2026-06-27 06:47:16','2026-06-27 06:47:16'),(68,51,'CLASS 5A','2026-06-27 06:47:35','2026-06-27 06:47:35'),(69,51,'CLASS 5B','2026-06-27 06:47:35','2026-06-27 06:47:35'),(70,52,'CLASS 5A','2026-06-27 06:47:49','2026-06-27 06:47:49'),(71,52,'CLASS 5B','2026-06-27 06:47:49','2026-06-27 06:47:49'),(72,53,'CLASS 5A','2026-06-27 06:48:03','2026-06-27 06:48:03'),(73,53,'CLASS 5B','2026-06-27 06:48:03','2026-06-27 06:48:03'),(74,54,'CLASS 5A','2026-06-27 06:48:18','2026-06-27 06:48:18'),(75,54,'CLASS 5B','2026-06-27 06:48:18','2026-06-27 06:48:18'),(76,55,'CLASS 5A','2026-06-27 06:48:33','2026-06-27 06:48:33'),(77,55,'CLASS 5B','2026-06-27 06:48:33','2026-06-27 06:48:33'),(78,56,'CLASS 5A','2026-06-27 06:48:50','2026-06-27 06:48:50'),(79,56,'CLASS 5B','2026-06-27 06:48:50','2026-06-27 06:48:50'),(80,57,'CLASS 6A','2026-06-27 06:49:55','2026-06-27 06:49:55'),(81,57,'CLASS 6B','2026-06-27 06:49:55','2026-06-27 06:49:55'),(82,58,'CLASS 6A','2026-06-27 06:50:11','2026-06-27 06:50:11'),(83,58,'CLASS 6B','2026-06-27 06:50:11','2026-06-27 06:50:11'),(84,59,'CLASS 6A','2026-06-27 06:50:25','2026-06-27 06:50:25'),(85,59,'CLASS 6B','2026-06-27 06:50:25','2026-06-27 06:50:25'),(86,60,'CLASS 6A','2026-06-27 06:50:37','2026-06-27 06:50:37'),(87,60,'CLASS 6B','2026-06-27 06:50:37','2026-06-27 06:50:37'),(88,61,'CLASS 6A','2026-06-27 06:50:51','2026-06-27 06:50:51'),(89,61,'CLASS 6B','2026-06-27 06:50:51','2026-06-27 06:50:51'),(90,62,'CLASS 6A','2026-06-27 06:51:06','2026-06-27 06:51:06'),(91,62,'CLASS 6B','2026-06-27 06:51:06','2026-06-27 06:51:06'),(92,63,'KG1','2026-06-27 06:52:11','2026-06-27 06:52:11'),(93,64,'KG1','2026-06-27 06:52:24','2026-06-27 06:52:24'),(94,65,'KG1','2026-06-27 06:52:35','2026-06-27 06:52:35'),(95,66,'KG1','2026-06-27 06:52:47','2026-06-27 06:52:47'),(96,67,'KG1','2026-06-27 06:52:58','2026-06-27 06:52:58'),(97,68,'KG2','2026-06-27 06:53:23','2026-06-27 06:53:23'),(98,69,'KG2','2026-06-27 06:53:44','2026-06-27 06:53:44'),(99,70,'KG2','2026-06-27 06:53:53','2026-06-27 06:53:53'),(100,71,'KG2','2026-06-27 06:54:04','2026-06-27 06:54:04'),(101,72,'KG3','2026-06-27 06:54:29','2026-06-27 06:54:29'),(102,73,'KG3','2026-06-27 06:54:39','2026-06-27 06:54:39'),(103,74,'KG3','2026-06-27 06:54:54','2026-06-27 06:54:54'),(104,75,'KG3','2026-06-27 06:55:13','2026-06-27 06:55:13'),(106,76,'FORM ONE','2026-06-27 06:57:58','2026-06-27 06:57:58'),(107,77,'FORM ONE','2026-06-27 06:58:09','2026-06-27 06:58:09'),(108,78,'FORM ONE','2026-06-27 06:58:20','2026-06-27 06:58:20'),(109,79,'FORM ONE','2026-06-27 06:58:32','2026-06-27 06:58:32'),(110,80,'FORM ONE','2026-06-27 06:58:43','2026-06-27 06:58:43'),(111,81,'FORM ONE','2026-06-27 06:58:53','2026-06-27 06:58:53'),(112,82,'FORM ONE','2026-06-27 06:59:06','2026-06-27 06:59:06'),(113,83,'FORM ONE','2026-06-27 06:59:17','2026-06-27 06:59:17'),(114,84,'FORM ONE','2026-06-27 06:59:26','2026-06-27 06:59:26'),(115,85,'FORM ONE','2026-06-27 06:59:37','2026-06-27 06:59:37'),(116,86,'FORM ONE','2026-06-27 06:59:48','2026-06-27 06:59:48'),(117,87,'FORM TWO','2026-06-27 07:00:22','2026-06-27 07:00:22'),(118,88,'FORM TWO','2026-06-27 07:00:34','2026-06-27 07:00:34'),(119,89,'FORM TWO','2026-06-27 07:00:44','2026-06-27 07:00:44'),(120,90,'FORM TWO','2026-06-27 07:00:54','2026-06-27 07:00:54'),(121,91,'FORM TWO','2026-06-27 07:01:10','2026-06-27 07:01:10'),(122,92,'FORM TWO','2026-06-27 07:01:20','2026-06-27 07:01:20'),(123,93,'FORM TWO','2026-06-27 07:01:30','2026-06-27 07:01:30'),(124,94,'FORM TWO','2026-06-27 07:01:41','2026-06-27 07:01:41'),(125,95,'FORM TWO','2026-06-27 07:01:51','2026-06-27 07:01:51'),(126,96,'CLASS 4A','2026-07-03 03:06:10','2026-07-03 03:06:10'),(127,96,'CLASS 4B','2026-07-03 03:06:10','2026-07-03 03:06:10'),(128,97,'CLASS 4A','2026-07-03 03:06:28','2026-07-03 03:06:28'),(129,97,'CLASS 4B','2026-07-03 03:06:28','2026-07-03 03:06:28'),(130,98,'CLASS 4A','2026-07-03 03:06:52','2026-07-03 03:06:52'),(131,98,'CLASS 4B','2026-07-03 03:06:52','2026-07-03 03:06:52'),(132,99,'CLASS 4A','2026-07-03 03:07:09','2026-07-03 03:07:09'),(133,99,'CLASS 4B','2026-07-03 03:07:09','2026-07-03 03:07:09'),(134,100,'CLASS 4A','2026-07-03 03:07:26','2026-07-03 03:07:26'),(135,100,'CLASS 4B','2026-07-03 03:07:26','2026-07-03 03:07:26'),(136,101,'CLASS 4A','2026-07-03 03:07:44','2026-07-03 03:07:44'),(137,101,'CLASS 4B','2026-07-03 03:07:44','2026-07-03 03:07:44'),(138,102,'CLASS 4A','2026-07-03 03:08:07','2026-07-03 03:08:07'),(139,102,'CLASS 4B','2026-07-03 03:08:07','2026-07-03 03:08:07'),(140,103,'CLASS 7A','2026-07-03 03:09:35','2026-07-03 03:09:35'),(141,103,'CLASS 7B','2026-07-03 03:09:35','2026-07-03 03:09:35'),(142,104,'CLASS 7A','2026-07-03 03:09:50','2026-07-03 03:09:50'),(143,104,'CLASS 7B','2026-07-03 03:09:50','2026-07-03 03:09:50'),(144,105,'CLASS 7A','2026-07-03 03:10:04','2026-07-03 03:10:04'),(145,105,'CLASS 7B','2026-07-03 03:10:04','2026-07-03 03:10:04'),(146,106,'CLASS 7A','2026-07-03 03:10:49','2026-07-03 03:10:49'),(147,106,'CLASS 7B','2026-07-03 03:10:49','2026-07-03 03:10:49'),(148,107,'CLASS 7A','2026-07-03 03:11:04','2026-07-03 03:11:04'),(149,107,'CLASS 7B','2026-07-03 03:11:04','2026-07-03 03:11:04'),(150,108,'CLASS 7A','2026-07-03 03:11:17','2026-07-03 03:11:17'),(151,108,'CLASS 7B','2026-07-03 03:11:17','2026-07-03 03:11:17'); /*!40000 ALTER TABLE `subject_classes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `subjects` -- DROP TABLE IF EXISTS `subjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subjects` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `subject_name` varchar(255) NOT NULL, `subject_code` varchar(255) DEFAULT NULL, `class` varchar(255) DEFAULT NULL, `description` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `subjects` -- LOCK TABLES `subjects` WRITE; /*!40000 ALTER TABLE `subjects` DISABLE KEYS */; INSERT INTO `subjects` VALUES (29,'KUSOMA','SUB-5452',NULL,NULL,'2026-06-27 06:14:12','2026-06-27 06:14:12'),(31,'ARITHMETIC','SUB-6285',NULL,NULL,'2026-06-27 06:20:16','2026-06-27 06:20:16'),(32,'WRITING','SUB-4799',NULL,NULL,'2026-06-27 06:21:19','2026-06-27 06:21:53'),(33,'READING','SUB-3224',NULL,NULL,'2026-06-27 06:22:21','2026-06-27 06:22:21'),(34,'HCE','SUB-6346',NULL,NULL,'2026-06-27 06:22:58','2026-06-27 06:22:58'),(35,'SPORTS','SUB-5334',NULL,NULL,'2026-06-27 06:27:34','2026-06-27 06:27:34'),(36,'NUMERACY','SUB-1466',NULL,NULL,'2026-06-27 06:29:09','2026-06-27 06:29:09'),(37,'KUSOMA','SUB-7338',NULL,NULL,'2026-06-27 06:29:35','2026-06-27 06:29:35'),(38,'KUANDIKA','SUB-8716',NULL,NULL,'2026-06-27 06:37:02','2026-06-27 06:37:02'),(39,'WRITING','SUB-5689',NULL,NULL,'2026-06-27 06:37:20','2026-06-27 06:37:20'),(40,'READING HCE','SUB-6532',NULL,NULL,'2026-06-27 06:37:40','2026-06-27 06:37:40'),(41,'HCE','SUB-1926',NULL,NULL,'2026-06-27 06:38:11','2026-06-27 06:38:11'),(42,'DSA','SUB-8847',NULL,NULL,'2026-06-27 06:38:27','2026-06-27 06:38:27'),(43,'HTM','SUB-8388',NULL,NULL,'2026-06-27 06:39:23','2026-06-27 06:39:23'),(44,'KISW','SUB-6906',NULL,NULL,'2026-06-27 06:39:36','2026-06-27 06:39:36'),(45,'GEOGRAPHY','SUB-5297',NULL,NULL,'2026-06-27 06:44:44','2026-06-27 06:44:44'),(46,'MATHEMATICS','SUB-7236',NULL,NULL,'2026-06-27 06:45:19','2026-06-27 06:45:19'),(47,'SCIENC','SUB-9677',NULL,NULL,'2026-06-27 06:45:35','2026-06-27 06:45:35'),(48,'ENGLISH','SUB-2602',NULL,NULL,'2026-06-27 06:45:55','2026-06-27 06:45:55'),(49,'SPORTS','SUB-3409',NULL,NULL,'2026-06-27 06:46:10','2026-06-27 06:46:10'),(50,'HTM','SUB-8042',NULL,NULL,'2026-06-27 06:47:16','2026-06-27 06:47:16'),(51,'KISWAHILI','SUB-3618',NULL,NULL,'2026-06-27 06:47:35','2026-06-27 06:47:35'),(52,'GEOGRAPHY','SUB-1070',NULL,NULL,'2026-06-27 06:47:49','2026-06-27 06:47:49'),(53,'MATHEMATICS','SUB-9177',NULL,NULL,'2026-06-27 06:48:03','2026-06-27 06:48:03'),(54,'SCIENC','SUB-4887',NULL,NULL,'2026-06-27 06:48:18','2026-06-27 06:48:18'),(55,'ENGLISH','SUB-7859',NULL,NULL,'2026-06-27 06:48:33','2026-06-27 06:48:33'),(56,'SPORTS','SUB-7674',NULL,NULL,'2026-06-27 06:48:50','2026-06-27 06:48:50'),(57,'KISWAHILI','SUB-6166',NULL,NULL,'2026-06-27 06:49:55','2026-06-27 06:49:55'),(58,'ENGLISH','SUB-6061',NULL,NULL,'2026-06-27 06:50:11','2026-06-27 06:50:11'),(59,'SCIENCE','SUB-4159',NULL,NULL,'2026-06-27 06:50:25','2026-06-27 06:50:25'),(60,'SST','SUB-4873',NULL,NULL,'2026-06-27 06:50:37','2026-06-27 06:50:37'),(61,'CIVIC','SUB-1407',NULL,NULL,'2026-06-27 06:50:51','2026-06-27 06:50:51'),(62,'MATHEMATICS','SUB-4703',NULL,NULL,'2026-06-27 06:51:06','2026-06-27 06:51:06'),(63,'ARITHMETIC','SUB-8549',NULL,NULL,'2026-06-27 06:52:11','2026-06-27 06:52:11'),(64,'COMMUNICATION','SUB-5338',NULL,NULL,'2026-06-27 06:52:24','2026-06-27 06:52:24'),(65,'ART','SUB-4259',NULL,NULL,'2026-06-27 06:52:35','2026-06-27 06:52:35'),(66,'HEALTH CARE','SUB-3662',NULL,NULL,'2026-06-27 06:52:47','2026-06-27 06:52:47'),(67,'RELATION','SUB-4423',NULL,NULL,'2026-06-27 06:52:58','2026-06-27 06:52:58'),(68,'ARTS','SUB-1848',NULL,NULL,'2026-06-27 06:53:23','2026-06-27 06:53:23'),(69,'HEC','SUB-7651',NULL,NULL,'2026-06-27 06:53:44','2026-06-27 06:53:44'),(70,'RELATION','SUB-7263',NULL,NULL,'2026-06-27 06:53:53','2026-06-27 06:53:53'),(71,'ARITHMETICS','SUB-7130',NULL,NULL,'2026-06-27 06:54:04','2026-06-27 06:54:04'),(72,'ARITHMETIC','SUB-9208',NULL,NULL,'2026-06-27 06:54:29','2026-06-27 06:54:29'),(73,'COMMUNICATION','SUB-2080',NULL,NULL,'2026-06-27 06:54:39','2026-06-27 06:54:39'),(74,'ARTS','SUB-1695',NULL,NULL,'2026-06-27 06:54:54','2026-06-27 06:54:54'),(75,'HEALTH','SUB-2320',NULL,NULL,'2026-06-27 06:55:13','2026-06-27 06:55:13'),(76,'GEOGRAPHY','SUB-5966',NULL,NULL,'2026-06-27 06:57:58','2026-06-27 06:57:58'),(77,'KISWAHILI','SUB-2503',NULL,NULL,'2026-06-27 06:58:09','2026-06-27 06:58:09'),(78,'ENGLISH LANGUAGE','SUB-8046',NULL,NULL,'2026-06-27 06:58:20','2026-06-27 06:58:20'),(79,'PHYSICS','SUB-7728',NULL,NULL,'2026-06-27 06:58:32','2026-06-27 06:58:32'),(80,'CHEMISTRY','SUB-4729',NULL,NULL,'2026-06-27 06:58:43','2026-06-27 06:58:43'),(81,'BIOLOGY','SUB-3966',NULL,NULL,'2026-06-27 06:58:53','2026-06-27 06:58:53'),(82,'MATHEMATICS','SUB-6633',NULL,NULL,'2026-06-27 06:59:06','2026-06-27 06:59:06'),(83,'HISTORIA YA TANZANIA NA MAADILI','SUB-2485',NULL,NULL,'2026-06-27 06:59:17','2026-06-27 06:59:17'),(84,'BUSINESS STUDIES','SUB-6401',NULL,NULL,'2026-06-27 06:59:26','2026-06-27 06:59:26'),(85,'INFORMATION COMPUTER STUDIES','SUB-5709',NULL,NULL,'2026-06-27 06:59:37','2026-06-27 06:59:37'),(86,'FOOD AND NUTRITION','SUB-4067',NULL,NULL,'2026-06-27 06:59:48','2026-06-27 06:59:48'),(87,'GEOGRAPHY','SUB-9683',NULL,NULL,'2026-06-27 07:00:22','2026-06-27 07:00:22'),(88,'KISWAHILI','SUB-4651',NULL,NULL,'2026-06-27 07:00:34','2026-06-27 07:00:34'),(89,'ENGLISH LANGUAGE','SUB-1123',NULL,NULL,'2026-06-27 07:00:44','2026-06-27 07:00:44'),(90,'PHYSICS','SUB-9026',NULL,NULL,'2026-06-27 07:00:54','2026-06-27 07:00:54'),(91,'CHEMISTRY','SUB-4275',NULL,NULL,'2026-06-27 07:01:10','2026-06-27 07:01:10'),(92,'BIOLOGY','SUB-9392',NULL,NULL,'2026-06-27 07:01:20','2026-06-27 07:01:20'),(93,'MATHEMATICS','SUB-2789',NULL,NULL,'2026-06-27 07:01:30','2026-06-27 07:01:30'),(94,'HISTORIA YA TANZANIA NA MAADILI','SUB-4364',NULL,NULL,'2026-06-27 07:01:41','2026-06-27 07:01:41'),(95,'BUSINESS STUDIES','SUB-8180',NULL,NULL,'2026-06-27 07:01:51','2026-06-27 07:01:51'),(96,'HTM','SUB-1832',NULL,NULL,'2026-07-03 03:06:10','2026-07-03 03:06:10'),(97,'KISWAHILI','SUB-8965',NULL,NULL,'2026-07-03 03:06:28','2026-07-03 03:06:28'),(98,'GEOGRAPHY','SUB-4161',NULL,NULL,'2026-07-03 03:06:52','2026-07-03 03:06:52'),(99,'MATHEMATICS','SUB-4246',NULL,NULL,'2026-07-03 03:07:09','2026-07-03 03:07:09'),(100,'SCIENCE','SUB-4809',NULL,NULL,'2026-07-03 03:07:26','2026-07-03 03:07:26'),(101,'ENGLISH','SUB-1925',NULL,NULL,'2026-07-03 03:07:44','2026-07-03 03:07:44'),(102,'SPORTS','SUB-7908',NULL,NULL,'2026-07-03 03:08:07','2026-07-03 03:08:07'),(103,'KISWAHILI','SUB-8311',NULL,NULL,'2026-07-03 03:09:35','2026-07-03 03:09:35'),(104,'ENGLISH','SUB-1899',NULL,NULL,'2026-07-03 03:09:50','2026-07-03 03:09:50'),(105,'SCIENCE','SUB-9825',NULL,NULL,'2026-07-03 03:10:04','2026-07-03 03:10:04'),(106,'SST','SUB-2448',NULL,NULL,'2026-07-03 03:10:49','2026-07-03 03:10:49'),(107,'CIVIC','SUB-9505',NULL,NULL,'2026-07-03 03:11:04','2026-07-03 03:11:04'),(108,'MATHEMATICS','SUB-1215',NULL,NULL,'2026-07-03 03:11:17','2026-07-03 03:11:17'); /*!40000 ALTER TABLE `subjects` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `username` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','teacher','academic','super_admin') NOT NULL DEFAULT 'teacher', `otp_code` varchar(255) DEFAULT NULL, `otp_expires_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `two_factor_method` varchar(255) NOT NULL DEFAULT 'none', `two_factor_destination` varchar(255) DEFAULT NULL, `two_factor_secret` text DEFAULT NULL, `two_factor_recovery_codes` text DEFAULT NULL, `two_factor_confirmed_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=53 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 (30,'System Admin',NULL,'admin@school.com',NULL,'$2y$10$cyDp5JghlLZGr9t86Rbe6e3/aGyfXDywy6t70wmQoa9DqnY7aBv/C','super_admin',NULL,NULL,NULL,'2026-06-06 08:28:48','2026-07-05 13:41:49','totp','shalonkilawa@gmail.com','SZK456H7YIJ22XGH',NULL,NULL),(43,'MADAMA DARIAA',NULL,'daria@gmail.com',NULL,'$2y$10$ReQ1L2/NluoJh1TvypOlveU2eI9op0RDlj.Fz6un12m.0hFqaWkNG','teacher','521011','2026-06-09 21:09:10',NULL,'2026-06-09 20:54:10','2026-07-05 11:59:32','none',NULL,NULL,NULL,NULL),(44,'Academic Manager',NULL,'academic@school.com',NULL,'$2y$10$Zycs7BiYNINYwtk/QkV0NOStIq4.N.fO0CMLJltssmNQpnIE.WaHS','academic',NULL,NULL,NULL,'2026-06-14 08:28:02','2026-07-05 11:59:32','none',NULL,NULL,NULL,NULL),(51,'SHALON CHARLES KILAWA','shalonkilawa@gmail.com','shalonkilawa@gmail.com',NULL,'$2y$10$q/2/5qzv15NtJIsVEXLrSOVZg9eBMzTuWFrIt3NOcYSpEciO1E1l6','teacher',NULL,NULL,NULL,'2026-07-02 17:20:22','2026-07-05 11:59:32','none',NULL,NULL,NULL,NULL),(52,'Super Administrator',NULL,'superadmin@school.com',NULL,'$2y$10$X8JzIIyrehOekmhRTqSyi.aPuvUMcVSlqdxoeWnPChNIbJhgqKgoq','super_admin',NULL,NULL,NULL,'2026-07-05 13:41:25','2026-07-05 13:41:25','none',NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webauthn_keys` -- DROP TABLE IF EXISTS `webauthn_keys`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webauthn_keys` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `name` varchar(255) DEFAULT NULL, `attachment_type` varchar(20) DEFAULT NULL, `credential_id` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `transports` text NOT NULL, `attestation_type` varchar(255) NOT NULL, `trust_path` text NOT NULL, `aaguid` text NOT NULL, `credential_public_key` text NOT NULL, `counter` bigint(20) unsigned NOT NULL, `last_used_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `webauthn_keys_user_id_foreign` (`user_id`), KEY `webauthn_keys_attachment_type_index` (`attachment_type`), KEY `webauthn_keys_credential_id_index` (`credential_id`), CONSTRAINT `webauthn_keys_user_id_foreign` FOREIGN KEY (`user_id`) 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 `webauthn_keys` -- LOCK TABLES `webauthn_keys` WRITE; /*!40000 ALTER TABLE `webauthn_keys` DISABLE KEYS */; /*!40000 ALTER TABLE `webauthn_keys` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-07-05 23:02:54