/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.6.22-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: 127.0.0.1 Database: belajar_alquran -- ------------------------------------------------------ -- Server version 10.6.22-MariaDB-0ubuntu0.22.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ci_sessions` -- DROP TABLE IF EXISTS `ci_sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ci_sessions` ( `id` varchar(128) NOT NULL, `ip_address` varchar(45) NOT NULL, `timestamp` int(10) unsigned NOT NULL DEFAULT 0, `data` blob NOT NULL, PRIMARY KEY (`id`), KEY `ci_sessions_timestamp` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ci_sessions` -- LOCK TABLES `ci_sessions` WRITE; /*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `detail_nilai` -- DROP TABLE IF EXISTS `detail_nilai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `detail_nilai` ( `uniqid` varchar(50) NOT NULL, `header_id` varchar(50) DEFAULT NULL, `parameter_id` varchar(50) DEFAULT NULL, `nilai` tinyint(4) DEFAULT NULL, `parameter` text DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `detail_nilai` -- LOCK TABLES `detail_nilai` WRITE; /*!40000 ALTER TABLE `detail_nilai` DISABLE KEYS */; INSERT INTO `detail_nilai` VALUES ('detail691ee21a830065.78076567','nilai691ee21a8215a8.19955152','0d5cd62c-9854-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a835e58.49967409','nilai691ee21a8215a8.19955152','1f401d57-9854-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a83c284.63449372','nilai691ee21a8215a8.19955152','dfdbddbc-9853-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a849212.91030879','nilai691ee21a843056.47752404','b8fb8cc8-9846-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a84ddb5.77462038','nilai691ee21a843056.47752404','b8fb9337-9846-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a852914.54123500','nilai691ee21a843056.47752404','b8fb94d5-9846-11f0-9d98-701a04df3b83',30,NULL),('detail691ee21a85e970.52938437','nilai691ee21a856db7.57081811','1',30,NULL),('detail691ee21a8673e6.96414873','nilai691ee21a856db7.57081811','2',30,NULL),('detail691ee21a86c167.36984367','nilai691ee21a856db7.57081811','3',30,NULL),('detail691ee2af4b5229.92871622','nilai691ee2af4af874.88645139','1',30,NULL),('detail691ee2af4b8fb0.04633154','nilai691ee2af4af874.88645139','2',30,NULL),('detail691ee2af4bced1.08493451','nilai691ee2af4af874.88645139','3',30,NULL); /*!40000 ALTER TABLE `detail_nilai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `h_nilai` -- DROP TABLE IF EXISTS `h_nilai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `h_nilai` ( `uniqid` varchar(50) NOT NULL, `siswa_id` varchar(50) DEFAULT NULL, `guru_id` varchar(50) DEFAULT NULL, `alquran_id` varchar(50) DEFAULT NULL, `tanggal_penilaian` date DEFAULT NULL, `catatan` text DEFAULT NULL, `kelas` varchar(45) DEFAULT NULL, `jenis_penilaian` varchar(45) DEFAULT NULL, `semester` varchar(15) DEFAULT 'ganjil', `tahun_ajaran` year(4) DEFAULT 2025, `status` tinyint(1) DEFAULT 0, `ayat_awal` tinyint(3) DEFAULT NULL, `ayat_akhir` tinyint(3) DEFAULT NULL, `jilid` varchar(45) DEFAULT NULL, `nilai_rata-rata` float DEFAULT NULL, `jenis_ujian` varchar(45) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `h_nilai` -- LOCK TABLES `h_nilai` WRITE; /*!40000 ALTER TABLE `h_nilai` DISABLE KEYS */; INSERT INTO `h_nilai` VALUES ('nilai691ee21a8215a8.19955152',NULL,'null',NULL,'2025-11-20','ok','Kelas 2','ujian_semester',NULL,NULL,0,NULL,NULL,NULL,NULL,'ujian_semester'),('nilai691ee21a843056.47752404',NULL,'null','1','2025-11-20','ok','Kelas 2','ujian_semester',NULL,NULL,0,NULL,NULL,NULL,NULL,'ujian_semester'),('nilai691ee21a856db7.57081811',NULL,'null',NULL,'2025-11-20','ok','Kelas 2','ujian_semester',NULL,NULL,0,NULL,NULL,'1',NULL,'ujian_semester'),('nilai691ee2af4af874.88645139','1','',NULL,'2025-11-20','baik','Kelas 1 A','tilawah','ganjil',2025,0,0,0,'1',NULL,'harian'); /*!40000 ALTER TABLE `h_nilai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ion_auth_groups` -- DROP TABLE IF EXISTS `ion_auth_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ion_auth_groups` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, `description` varchar(100) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ion_auth_groups` -- LOCK TABLES `ion_auth_groups` WRITE; /*!40000 ALTER TABLE `ion_auth_groups` DISABLE KEYS */; INSERT INTO `ion_auth_groups` VALUES (1,'admin','Administrator'),(2,'guru','Guru'),(3,'ortu','orang tua siswa'); /*!40000 ALTER TABLE `ion_auth_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ion_auth_login_attempts` -- DROP TABLE IF EXISTS `ion_auth_login_attempts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ion_auth_login_attempts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(45) NOT NULL, `login` varchar(100) NOT NULL, `time` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ion_auth_login_attempts` -- LOCK TABLES `ion_auth_login_attempts` WRITE; /*!40000 ALTER TABLE `ion_auth_login_attempts` DISABLE KEYS */; /*!40000 ALTER TABLE `ion_auth_login_attempts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ion_auth_users` -- DROP TABLE IF EXISTS `ion_auth_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ion_auth_users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ip_address` varchar(45) NOT NULL, `username` varchar(100) DEFAULT NULL, `password` varchar(255) NOT NULL, `salt` varchar(255) DEFAULT NULL, `email` varchar(254) NOT NULL, `activation_code` varchar(40) DEFAULT NULL, `forgotten_password_code` varchar(40) DEFAULT NULL, `forgotten_password_time` int(11) unsigned DEFAULT NULL, `remember_code` varchar(40) DEFAULT NULL, `created_on` int(11) unsigned NOT NULL, `last_login` int(11) unsigned DEFAULT NULL, `active` tinyint(1) unsigned DEFAULT NULL, `first_name` varchar(50) DEFAULT NULL, `last_name` varchar(50) DEFAULT NULL, `company` varchar(100) DEFAULT NULL, `phone` varchar(20) DEFAULT NULL, `no_ktp` varchar(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ion_auth_users` -- LOCK TABLES `ion_auth_users` WRITE; /*!40000 ALTER TABLE `ion_auth_users` DISABLE KEYS */; INSERT INTO `ion_auth_users` VALUES (1,'127.0.0.1','administrator','$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36','','admin@admin.com','','xGqjxq.8XAylrZkvWjcRuu5ca054c3920e3fa5ae',1718184173,NULL,1268889823,1762755700,1,'Admin','istrator','ADMIN','0',NULL),(30,'','lehabatubara0608@gmail.com','$2y$08$Dl2egkCFKcV2UZOOsMD.auWtg1coONAUkwGAFhEbIG5XM0FTSBmse','','lehabatubara0608@gmail.com','bced3a5f82bf4ebce5efe25bc191370e058b978b',NULL,NULL,NULL,0,1744273242,0,'KURNIA EFENDI YAHYA NST',NULL,NULL,NULL,NULL),(31,'','alfatihhasanabqari@gmail.com','$2y$08$A9e/BjVTQxppv.oyW6/OTer.mcP9zFz0/UoiqXIFzKu8tBbsTLBq.',NULL,'alfatihhasanabqari@gmail.com',NULL,'rRK2YIPInf6vZXaXarx0RO2724c8b322518e2a62',1731399666,NULL,0,1738823954,1,'HUMAIRA',NULL,NULL,NULL,NULL),(32,'','andibasoariaji.abri127@gmail.com','$2y$08$NzkIXql4aY5WpgEfbAsEh.Xn5J0xYMeMFwF4P7AC59uogdf75Wcpq',NULL,'andibasoariaji.abri127@gmail.com','059bf84a7cb16e6f8c0ef7893f5ba16653c270b8',NULL,NULL,NULL,0,1738894956,0,'ANDI BASO ARIAJI',NULL,NULL,NULL,NULL),(33,'','wibiaw89@gmail.com','$2y$08$Vxew2sukzy9QQklPoL3u/u0gH0YCriGvwaVUQgKpxU0W4bd5kaTQK',NULL,'wibiaw89@gmail.com',NULL,NULL,NULL,NULL,0,1725938850,1,'WIBI ARIE WIBOWO',NULL,NULL,NULL,NULL),(34,'','wagiran980@gmail.com','$2y$08$k.hEGzCvL.uMM7KYZ8ijyunFA9Xlj1dus7AiwEEwqdrpoHdZEawG6',NULL,'wagiran980@gmail.com',NULL,NULL,NULL,NULL,0,1726208424,1,'WAGIRAN',NULL,NULL,NULL,NULL),(35,'','hendro.mulyo11@gmail.com','$2y$08$3SPXr7lsHkpivbmReHmK3ORynSZaewAzacKPsnLrG7PV/otC1psFK',NULL,'hendro.mulyo11@gmail.com',NULL,'u8KD7l7qI-S3KafbN5NjZO10aa6588ea7b950945',1726110882,NULL,0,1756627590,1,'HENDRO MULYO',NULL,NULL,NULL,NULL),(36,'','riyandhi.agt@gmail.com','$2y$08$Xy.Wou0rhuwQhE7im6nl.uq82OOugqlMB3RytOqH1cGMSZVywkfUa',NULL,'riyandhi.agt@gmail.com',NULL,NULL,NULL,NULL,0,1727151035,1,'RENDI AGUSTRIYANDHI',NULL,NULL,NULL,NULL),(37,'','aprino323@gmail.com','$2y$08$lG.ayygftl7w/ZQOTMqd5OXSlWmOgg/Lpyua8IlOG0GzAdRvWxYoS',NULL,'aprino323@gmail.com',NULL,NULL,NULL,NULL,0,1726547961,1,'H. APRIANTO',NULL,NULL,NULL,NULL),(38,'','ayahilyah@gmail.com','$2y$08$d6n0SSRgbdZlUlgUkEp3tuz0tZQ9BDYFevWz9Uu8uEypKOCsVw8cC',NULL,'ayahilyah@gmail.com',NULL,NULL,NULL,NULL,0,1740387710,1,'IBNU AFFAN',NULL,NULL,NULL,NULL),(39,'','wagianto82@gmail.com','$2y$08$k.hEGzCvL.uMM7KYZ8ijyunFA9Xlj1dus7AiwEEwqdrpoHdZEawG6',NULL,'wagianto82@gmail.com',NULL,NULL,NULL,NULL,0,1755383299,1,'WAGIANTO',NULL,NULL,NULL,NULL),(40,'127.0.0.1','m.fakhri.g12@gmail.com','$2y$08$tQnYxxOh3kNs.EIz98KB9.nXQlLh9jQi1vggXIutGWZKt5/xYrfgK','','m.fakhri.g12@gmail.com','',NULL,NULL,NULL,1268889823,1728304119,1,'Muhammad Fakhri','','ADMIN','0',NULL),(41,'127.0.0.1','ortu001','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu001@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua1','Dummy',NULL,'0812000001',NULL),(42,'127.0.0.1','ortu002','$2a$07$SeBknntpZror9uyftVopmu61qg0ms8Qv1yV6FG.kQOSM.9QhmTo36',NULL,'ortu002@example.com',NULL,NULL,NULL,NULL,1761042923,1762758417,1,'OrangTua2','Dummy',NULL,'0812000002',NULL),(43,'127.0.0.1','ortu003','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu003@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua3','Dummy',NULL,'0812000003',NULL),(44,'127.0.0.1','ortu004','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu004@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua4','Dummy',NULL,'0812000004',NULL),(45,'127.0.0.1','ortu005','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu005@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua5','Dummy',NULL,'0812000005',NULL),(46,'127.0.0.1','ortu006','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu006@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua6','Dummy',NULL,'0812000006',NULL),(47,'127.0.0.1','ortu007','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu007@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua7','Dummy',NULL,'0812000007',NULL),(48,'127.0.0.1','ortu008','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu008@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua8','Dummy',NULL,'0812000008',NULL),(49,'127.0.0.1','ortu009','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu009@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua9','Dummy',NULL,'0812000009',NULL),(50,'127.0.0.1','ortu010','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu010@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua10','Dummy',NULL,'0812000010',NULL),(51,'127.0.0.1','ortu011','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu011@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua11','Dummy',NULL,'0812000011',NULL),(52,'127.0.0.1','ortu012','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu012@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua12','Dummy',NULL,'0812000012',NULL),(53,'127.0.0.1','ortu013','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu013@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua13','Dummy',NULL,'0812000013',NULL),(54,'127.0.0.1','ortu014','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu014@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua14','Dummy',NULL,'0812000014',NULL),(55,'127.0.0.1','ortu015','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu015@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua15','Dummy',NULL,'0812000015',NULL),(56,'127.0.0.1','ortu016','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu016@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua16','Dummy',NULL,'0812000016',NULL),(57,'127.0.0.1','ortu017','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu017@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua17','Dummy',NULL,'0812000017',NULL),(58,'127.0.0.1','ortu018','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu018@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua18','Dummy',NULL,'0812000018',NULL),(59,'127.0.0.1','ortu019','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu019@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua19','Dummy',NULL,'0812000019',NULL),(60,'127.0.0.1','ortu020','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu020@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua20','Dummy',NULL,'0812000020',NULL),(61,'127.0.0.1','ortu021','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu021@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua21','Dummy',NULL,'0812000021',NULL),(62,'127.0.0.1','ortu022','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu022@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua22','Dummy',NULL,'0812000022',NULL),(63,'127.0.0.1','ortu023','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu023@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua23','Dummy',NULL,'0812000023',NULL),(64,'127.0.0.1','ortu024','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu024@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua24','Dummy',NULL,'0812000024',NULL),(65,'127.0.0.1','ortu025','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu025@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua25','Dummy',NULL,'0812000025',NULL),(66,'127.0.0.1','ortu026','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu026@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua26','Dummy',NULL,'0812000026',NULL),(67,'127.0.0.1','ortu027','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu027@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua27','Dummy',NULL,'0812000027',NULL),(68,'127.0.0.1','ortu028','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu028@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua28','Dummy',NULL,'0812000028',NULL),(69,'127.0.0.1','ortu029','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu029@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua29','Dummy',NULL,'0812000029',NULL),(70,'127.0.0.1','ortu030','$2y$10$abcdefghijklmnopqrstuvABCDEFGHIJKLMNO1234567890ab',NULL,'ortu030@example.com',NULL,NULL,NULL,NULL,1761042923,NULL,1,'OrangTua30','Dummy',NULL,'0812000030',NULL); /*!40000 ALTER TABLE `ion_auth_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ion_auth_users_groups` -- DROP TABLE IF EXISTS `ion_auth_users_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `ion_auth_users_groups` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `group_id` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`), KEY `fk_users_groups_users1_idx` (`user_id`), KEY `fk_users_groups_groups1_idx` (`group_id`), CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `ion_auth_groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION, CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `ion_auth_users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ion_auth_users_groups` -- LOCK TABLES `ion_auth_users_groups` WRITE; /*!40000 ALTER TABLE `ion_auth_users_groups` DISABLE KEYS */; INSERT INTO `ion_auth_users_groups` VALUES (1,1,1),(6,30,2),(11,31,2),(10,32,2),(2,33,2),(3,34,2),(7,35,2),(5,36,2),(9,37,2),(8,38,2),(4,39,2),(12,40,2),(13,41,3),(14,42,3),(15,43,3); /*!40000 ALTER TABLE `ion_auth_users_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `konfigurasi` -- DROP TABLE IF EXISTS `konfigurasi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `konfigurasi` ( `uniqid` int(11) NOT NULL AUTO_INCREMENT, `nama_konfigurasi` varchar(45) DEFAULT NULL, `nilai` varchar(45) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `konfigurasi` -- LOCK TABLES `konfigurasi` WRITE; /*!40000 ALTER TABLE `konfigurasi` DISABLE KEYS */; INSERT INTO `konfigurasi` VALUES (1,'tahun_ajaran','2025'),(2,'semester','ganjil'); /*!40000 ALTER TABLE `konfigurasi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_alquran` -- DROP TABLE IF EXISTS `m_alquran`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_alquran` ( `id` int(11) NOT NULL, `arabic` varchar(255) DEFAULT NULL, `latin` varchar(255) DEFAULT NULL, `transliteration` varchar(255) DEFAULT NULL, `translation` varchar(255) DEFAULT NULL, `num_ayah` varchar(255) DEFAULT NULL, `page` varchar(255) DEFAULT NULL, `location` varchar(255) DEFAULT NULL, `updated_at` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_alquran` -- LOCK TABLES `m_alquran` WRITE; /*!40000 ALTER TABLE `m_alquran` DISABLE KEYS */; INSERT INTO `m_alquran` VALUES (1,' الفاتحة','Al-Fātiḥah ','Al-Fatihah','Pembuka','7','1','Makkiyah',NULL),(2,' البقرة','Al-Baqarah ','Al-Baqarah','Sapi','286','2','Madaniyah',NULL),(3,' اٰل عمرٰن','Āli ‘Imrān','Ali ‘Imran','Keluarga Imran','200','50','Madaniyah',NULL),(4,'النّساۤء','An-Nisā\' ','An-Nisa\'','Perempuan','176','77','Madaniyah',NULL),(5,' الماۤئدة','Al-Mā\'idah','Al-Ma\'idah','Hidangan','120','106','Madaniyah',NULL),(6,' الانعام','Al-An‘ām ','Al-An‘am','Binatang Ternak','165','128','Makkiyah',NULL),(7,' الاعراف','Al-A‘rāf','Al-A‘raf','Tempat Tertinggi','206','151','Makkiyah',NULL),(8,' الانفال','Al-Anfāl','Al-Anfal','Rampasan Perang','75','177','Madaniyah',NULL),(9,'التّوبة','At-Taubah','At-Taubah','Pengampunan','129','187','Madaniyah',NULL),(10,' يونس','Yūnus','Yunus','Yunus','109','208','Makkiyah',NULL),(11,' هود','Hūd','Hud','Hud','123','221','Makkiyah',NULL),(12,' يوسف','Yūsuf','Yusuf','Yusuf','111','235','Makkiyah',NULL),(13,' الرّعد','Ar-Ra‘d','Ar-Ra‘d','Guruh','43','249','Makkiyah',NULL),(14,' ابرٰهيم','Ibrāhīm','Ibrahim','Ibrahim','52','255','Makkiyah',NULL),(15,' الحجر','Al-Ḥijr','Al-Hijr','Hijr','99','262','Makkiyah',NULL),(16,'النّحل','An-Naḥl','An-Nahl','Lebah','128','267','Makkiyah',NULL),(17,' الاسراۤء','Al-Isrā\'','Al-Isra\'','Memperjalankan di Malam Hari','111','282','Makkiyah',NULL),(18,' الكهف','Al-Kahf','Al-Kahf','Gua','110','293','Makkiyah',NULL),(19,' مريم','Maryam','Maryam','Maryam','98','305','Makkiyah',NULL),(20,' طٰهٰ','Ṭāhā','Taha','Taha','135','312','Makkiyah',NULL),(21,' الانبياۤء','Al-Anbiyā\' ','Al-Anbiya\'','Para Nabi','112','322','Makkiyah',NULL),(22,'الحجّ','Al-Ḥajj','Al-Hajj','Haji','78','332','Madaniyah',NULL),(23,' المؤمنون','Al-Mu\'minūn','Al-Mu\'minun','Orang-Orang Mukmin','118','342','Makkiyah',NULL),(24,' النّور','An-Nūr','An-Nur','Cahaya','64','350','Madaniyah',NULL),(25,' الفرقان','Al-Furqān','Al-Furqan','Pembeda','77','359','Makkiyah',NULL),(26,'الشّعراۤء','Asy-Syu‘arā\'','Asy-Syu‘ara\'','Para Penyair','227','367','Makkiyah',NULL),(27,'النّمل','An-Naml','An-Naml','Semut','93','377','Makkiyah',NULL),(28,' القصص','Al-Qaṣaṣ','Al-Qasas','Kisah-Kisah','88','385','Makkiyah',NULL),(29,' العنكبوت','Al-‘Ankabūt','Al-‘Ankabut','Laba-Laba','69','396','Makkiyah',NULL),(30,' الرّوم','Ar-Rūm','Ar-Rum','Romawi','60','404','Makkiyah',NULL),(31,' لقمٰن','Luqmān ','Luqman','Luqman','34','411','Makkiyah',NULL),(32,' السّجدة','As-Sajdah','As-Sajdah','Sajdah','30','415','Makkiyah',NULL),(33,' الاحزاب','Al-Aḥzāb','Al-Ahzab','Golongan Yang Bersekutu','73','418','Madaniyah',NULL),(34,' سبأ','Saba\' ','Saba\'','Saba\'','54','428','Makkiyah',NULL),(35,' فاطر','Fāṭir','Fatir','Pencipta','45','434','Makkiyah',NULL),(36,' يٰسۤ','Yāsīn','Yasin','Yasin','83','440','Makkiyah',NULL),(37,' الصّٰۤفّٰت','Aṣ-Ṣāffāt','As-Saffat','Barisan-Barisan','182','446','Makkiyah',NULL),(38,'صۤ','Ṣād ','Sad','Ṣād ','88','453','Makkiyah',NULL),(39,'الزّمر','Az-Zumar','Az-Zumar','Rombongan','75','458','Makkiyah',NULL),(40,' غافر','Gāfir ','Gafir','Maha Pengampun','85','467','Makkiyah',NULL),(41,' فصّلت','Fuṣṣilat','Fussilat','Dijelaskan','54','477','Makkiyah',NULL),(42,'الشّورٰى','Asy-Syūrā','Asy-Syura','Musyawarah','53','483','Makkiyah',NULL),(43,'الزّخرف','Az-Zukhruf','Az-Zukhruf','Perhiasan dari Emas','89','489','Makkiyah',NULL),(44,'الدّخان','Ad-Dukhān','Ad-Dukhan','Kabut Asap','59','496','Makkiyah',NULL),(45,' الجاثية','Al-Jāṡiyah','Al-Jasiyah','Berlutut','37','499','Makkiyah',NULL),(46,' الاحقاف','Al-Aḥqāf','Al-Ahqaf','Ahqaf','35','502','Makkiyah',NULL),(47,' محمّد','Muḥammad ','Muhammad','Nabi Muhammad','38','507','Madaniyah',NULL),(48,' الفتح','Al-Fatḥ','Al-Fath','Kemenangan','29','511','Madaniyah',NULL),(49,' الحجرٰت','Al-Ḥujurāt','Al-Hujurat','Kamar-Kamar','18','515','Madaniyah',NULL),(50,'قۤ','Qāf','Qaf','Qaf','45','518','Makkiyah',NULL),(51,' الذّٰريٰت','Aż-Żāriyāt','Az-Zariyat','Yang Menerbangkan','60','520','Makkiyah',NULL),(52,'الطّور','Aṭ-Ṭūr','At-Tur','Gunung','49','523','Makkiyah',NULL),(53,'النّجم','An-Najm','An-Najm','Bintang','62','526','Makkiyah',NULL),(54,' القمر','Al-Qamar','Al-Qamar','Bulan','55','528','Makkiyah',NULL),(55,'الرّحمٰن','Ar-Raḥmān','Ar-Rahman','Yang Maha Pengasih','78','531','Makkiyah',NULL),(56,' الواقعة','Al-Wāqi‘ah','Al-Waqi‘ah','Hari Kiamat Yang Pasti Terjadi','96','534','Makkiyah',NULL),(57,' الحديد','Al-Ḥadīd','Al-Hadid','Besi','29','537','Madaniyah',NULL),(58,' المجادلة','Al-Mujādalah','Al-Mujadalah','Gugatan','22','542','Madaniyah',NULL),(59,' الحشر','Al-Ḥasyr','Al-Hasyr','Pengusiran','24','545','Madaniyah',NULL),(60,' الممتحنة','Al-Mumtaḥanah','Al-Mumtahanah','Wanita Yang Diuji','13','549','Madaniyah',NULL),(61,' الصّفّ','Aṣ-Ṣaff','As-Saff','Barisan','14','551','Madaniyah',NULL),(62,' الجمعة','Al-Jumu‘ah','Al-Jumu‘ah','Jumat','11','553','Madaniyah',NULL),(63,' المنٰفقون','Al-Munāfiqūn','Al-Munafiqun','Orang-Orang Munafik','11','554','Madaniyah',NULL),(64,'التّغابن','At-Tagābun','At-Tagabun','Pengungkapan Kesalahan','18','556','Madaniyah',NULL),(65,'الطّلاق','Aṭ-Ṭalāq','At-Talaq','Talak','12','558','Madaniyah',NULL),(66,'التّحريم','At-taḥrīm','At-tahrim','Pengharaman','12','560','Madaniyah',NULL),(67,'المُلك','Al-Mulk','Al-Mulk','Kerajaan','30','562','Makkiyah',NULL),(68,' القلم','Al-Qalam','Al-Qalam','Pena','52','564','Makkiyah',NULL),(69,' الحاۤقّة','Al-Ḥāqqah','Al-Haqqah','Hari Kiamat Yang Pasti Terjadi','52','566','Makkiyah',NULL),(70,' المعارج','Al-Ma‘ārij','Al-Ma‘arij','Tempat-Tempat Naik','44','568','Makkiyah',NULL),(71,' نوح','Nūḥ','Nuh','Nuh','28','570','Makkiyah',NULL),(72,'الجنّ','Al-Jinn','Al-Jinn','Jin','28','572','Makkiyah',NULL),(73,' المزّمّل','Al-Muzzammil','Al-Muzzammil','Orang Berkelumun','20','574','Makkiyah',NULL),(74,' المدّثّر','Al-Muddaṡṡir','Al-Muddassir','Orang Berselimut','56','575','Makkiyah',NULL),(75,' القيٰمة','Al-Qiyāmah','Al-Qiyamah','Hari Kiamat','40','577','Makkiyah',NULL),(76,' الانسان','Al-Insān','Al-Insan','Manusia','31','578','Madaniyah',NULL),(77,' المرسلٰت','Al-Mursalāt','Al-Mursalat','Malaikat Yang Diutus','50','580','Makkiyah',NULL),(78,'النّبأ','An-Naba\'','An-Naba\'','Berita','40','582','Makkiyah',NULL),(79,' النّٰزعٰت','An-Nāzi‘āt','An-Nazi‘at','Yang Mencabut Dengan Keras','46','583','Makkiyah',NULL),(80,' عبس','‘Abasa','‘Abasa','Berwajah Masam','42','585','Makkiyah',NULL),(81,'التّكوير','At-Takwīr','At-Takwir','Penggulungan','29','586','Makkiyah',NULL),(82,' الانفطار','Al-Infiṭār','Al-Infitar','Terbelah','19','587','Makkiyah',NULL),(83,' المطفّفين','Al-Muṭaffifīn','Al-Mutaffifin','Orang-Orang Yang Curang','36','587','Makkiyah',NULL),(84,' الانشقاق','Al-Insyiqāq','Al-Insyiqaq','Terbelah','25','589','Makkiyah',NULL),(85,' البروج','Al-Burūj','Al-Buruj','Gugusan Bintang','22','590','Makkiyah',NULL),(86,'الطّارق','Aṭ-Ṭāriq','At-Tariq','Yang Datang Pada Malam Hari','17','591','Makkiyah',NULL),(87,' الاعلى','Al-A‘lā','Al-A‘la','Yang Maha Tinggi','19','591','Makkiyah',NULL),(88,' الغاشية','Al-Gāsyiyah','Al-Gasyiyah','Hari Kiamat Yang Menghilangkan Kesadaran','26','592','Makkiyah',NULL),(89,' الفجر','Al-Fajr','Al-Fajr','Fajar','30','593','Makkiyah',NULL),(90,' البلد','Al-Balad','Al-Balad','Negeri','20','594','Makkiyah',NULL),(91,'الشّمس','Asy-Syams','Asy-Syams','Matahari','15','595','Makkiyah',NULL),(92,' الّيل','Al-Lail','Al-Lail','Malam','21','595','Makkiyah',NULL),(93,'الضّحى','Aḍ-Ḍuḥā','Ad-Duha','Duha','11','596','Makkiyah',NULL),(94,'الشّرح','Asy-Syarḥ','Asy-Syarh','Pelapangan','8','596','Makkiyah',NULL),(95,'التّين','At-Tīn','At-Tin','Buah Tin','8','597','Makkiyah',NULL),(96,' العلق','Al-‘Alaq','Al-‘Alaq','Segumpal Darah','19','597','Makkiyah',NULL),(97,' القدر','Al-Qadr','Al-Qadr','Al-Qadar','5','598','Makkiyah',NULL),(98,' البيّنة','Al-Bayyinah','Al-Bayyinah','Bukti Nyata','8','598','Madaniyah',NULL),(99,'الزّلزلة','Az-Zalzalah','Az-Zalzalah','Guncangan','8','599','Madaniyah',NULL),(100,' العٰديٰت','Al-‘Ādiyāt','Al-‘Adiyat','Kuda Perang Yang Berlari Kencang','11','599','Makkiyah',NULL),(101,' القارعة','Al-Qāri‘ah','Al-Qari‘ah','Al-Qāri‘ah','11','600','Makkiyah',NULL),(102,'التّكاثر','At-Takāṡur','At-Takasur','Berbangga-Bangga Dalam Memperbanyak Dunia','8','600','Makkiyah',NULL),(103,' العصر','Al-‘Aṣr','Al-‘Asr','Masa','3','601','Makkiyah',NULL),(104,' الهمزة','Al-Humazah','Al-Humazah','Pengumpat','9','601','Makkiyah',NULL),(105,' الفيل','Al-Fīl','Al-Fil','Gajah','5','601','Makkiyah',NULL),(106,' قريش','Quraisy','Quraisy','Orang Quraisy','4','602','Makkiyah',NULL),(107,' الماعون','Al-Mā‘ūn','Al-Ma‘un','Bantuan','7','602','Makkiyah',NULL),(108,' الكوثر','Al-Kauṡar','Al-Kausar','Nikmat Yang Banyak','3','602','Makkiyah',NULL),(109,' الكٰفرون','Al-Kāfirūn','Al-Kafirun','Orang-Orang kafir','6','603','Makkiyah',NULL),(110,'النّصر','An-Naṣr','An-Nasr','Pertolongan','3','603','Madaniyah',NULL),(111,'اللّهب','Al-Lahab','Al-Lahab','Gejolak Api','5','603','Makkiyah',NULL),(112,' الاخلاص','Al-Ikhlāṣ','Al-Ikhlas','Ikhlas','4','604','Makkiyah',NULL),(113,' الفلق','Al-Falaq','Al-Falaq','Fajar','5','604','Madaniyah',NULL),(114,'النّاس','An-Nās','An-Nas','Manusia','6','604','Madaniyah',NULL); /*!40000 ALTER TABLE `m_alquran` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_jilid` -- DROP TABLE IF EXISTS `m_jilid`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_jilid` ( `uniqid` varchar(50) NOT NULL, `jilid` tinyint(2) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_jilid` -- LOCK TABLES `m_jilid` WRITE; /*!40000 ALTER TABLE `m_jilid` DISABLE KEYS */; INSERT INTO `m_jilid` VALUES ('1',1),('10',10),('2',2),('3',3),('4',4),('5',5),('6',6),('7',7),('8',8),('9',9); /*!40000 ALTER TABLE `m_jilid` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_kelas` -- DROP TABLE IF EXISTS `m_kelas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_kelas` ( `uniqid` varchar(50) NOT NULL, `nama_kelas` varchar(255) NOT NULL, `guru_id` varchar(50) DEFAULT NULL, `rombel_id` varchar(50) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_kelas` -- LOCK TABLES `m_kelas` WRITE; /*!40000 ALTER TABLE `m_kelas` DISABLE KEYS */; INSERT INTO `m_kelas` VALUES ('05523343-a5e7-49bc-a516-83864f9d70a9','Kelas 4',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),('0e9ad064-d91f-4cce-bbff-57b19d8efd08','Kelas 2',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),('1e68ba47-758b-466c-92ba-4204e3b9315c','Kelas 5',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),('296bc209-4320-4afc-b634-ffe5521603bb','Kelas 6',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),('9782cca2-b7d6-4032-bf77-1824fafd3db6','Kelas 1 A',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),('e8f7f7d6-41a0-4b99-8058-7d785f18ad06','Kelas 1 B',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),('ed8bf207-5eeb-4540-a127-8d45fc702faf','Kelas 3',NULL,'bed25cbf-9842-11f0-9d98-701a04df3b83'); /*!40000 ALTER TABLE `m_kelas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_parameter_nilai` -- DROP TABLE IF EXISTS `m_parameter_nilai`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_parameter_nilai` ( `uniqid` varchar(50) NOT NULL, `nama_parameter` varchar(5) DEFAULT NULL, `jenis_parameter` varchar(45) DEFAULT NULL, `keterangan` varchar(255) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_parameter_nilai` -- LOCK TABLES `m_parameter_nilai` WRITE; /*!40000 ALTER TABLE `m_parameter_nilai` DISABLE KEYS */; INSERT INTO `m_parameter_nilai` VALUES ('0d5cd62c-9854-11f0-9d98-701a04df3b83','s12','santun','SIKAP MEMULIAKAN AL-QURAN'),('1','f4','tilawah','Qiraah'),('1f401d57-9854-11f0-9d98-701a04df3b83','s13','santun','ADAB TERHADAP SESAMA'),('2','f5','tilawah','Fashoha'),('3','f6','tilawah','Tajwid'),('a8aebc87-9844-11f0-9d98-701a04df3b83','s21','santun','Berlatih membiasakan tilawah dan mengulang hafalan di rumah sesuai jadwal yang telah dibuat sendiri.'),('a8aec1c5-9844-11f0-9d98-701a04df3b83','s22','santun','Terbiasa berwudhu dengan tertib sebelum membaca Al-Qur’an.'),('a8aeff82-9844-11f0-9d98-701a04df3b83','s23','santun','Terbiasa mengucapkan kata: Terima kasih, Meminta tolong, dan Meminta maaf, saat pembelajaran Al Qur’an.'),('b8fb8cc8-9846-11f0-9d98-701a04df3b83','f1','tahfidz','Hafalan'),('b8fb9337-9846-11f0-9d98-701a04df3b83','f2','tahfidz','Fashoha'),('b8fb94d5-9846-11f0-9d98-701a04df3b83','f3','tahfidz','Tajwid'),('dfdbddbc-9853-11f0-9d98-701a04df3b83','s11','santun','SENANG MEMBACA DAN MENGHAFAL AL-QUR\'AN'); /*!40000 ALTER TABLE `m_parameter_nilai` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_rombel` -- DROP TABLE IF EXISTS `m_rombel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_rombel` ( `uniqid` varchar(50) NOT NULL, `nama_rombel` tinyint(2) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_rombel` -- LOCK TABLES `m_rombel` WRITE; /*!40000 ALTER TABLE `m_rombel` DISABLE KEYS */; INSERT INTO `m_rombel` VALUES ('bed25411-9842-11f0-9d98-701a04df3b83',1),('bed25b41-9842-11f0-9d98-701a04df3b83',2),('bed25cbf-9842-11f0-9d98-701a04df3b83',3),('bed25dc9-9842-11f0-9d98-701a04df3b83',4),('bed25e98-9842-11f0-9d98-701a04df3b83',5),('bed25f62-9842-11f0-9d98-701a04df3b83',6); /*!40000 ALTER TABLE `m_rombel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `m_siswa` -- DROP TABLE IF EXISTS `m_siswa`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `m_siswa` ( `id` int(11) NOT NULL AUTO_INCREMENT, `NISN` varchar(20) DEFAULT NULL, `Nama` varchar(100) DEFAULT NULL, `kelas_id` varchar(50) DEFAULT NULL, `ortu_id` varchar(45) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `NISN` (`NISN`) ) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `m_siswa` -- LOCK TABLES `m_siswa` WRITE; /*!40000 ALTER TABLE `m_siswa` DISABLE KEYS */; INSERT INTO `m_siswa` VALUES (1,'3183484318','ADAM ABQORI RANGKUTI','9782cca2-b7d6-4032-bf77-1824fafd3db6','41'),(2,'3184549826','ADIBA KHANSA','9782cca2-b7d6-4032-bf77-1824fafd3db6','42'),(3,'3173492321','ALTHAF SHAQUILLE ATHAYA','9782cca2-b7d6-4032-bf77-1824fafd3db6','42'),(4,'3173278257','AQILA NATHANIA KAYANA','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(5,'3189095751','ARKANA LEANDRA TARIGAN','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(6,'3176413270','ATHAYA RENZA RAFISQY','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(7,'3187094679','FAKHRI ABIZAR','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(8,'3182628258','FATIYYA AZKADINA','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(9,'3187462556','GIBRAN MUSTHAFA HARDI','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(10,'3188677621','HABIB UWAIS AL QARNI','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(11,'3188188002','HASRAF ABIL SHIDDIQ','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(12,'3179901689','KHABIR AULIYA ABDILLAH','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(13,'3188052468','KIANO ALDIAN NARESWARA','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(14,'3182249115','KINZA ALFATIH RIZQANI PASARIBU','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(15,'3180395173','Muhammad Sajid Siregar','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(16,'3189936244','MUHAMMAD ZAYYAD ARSYADI SIREGAR','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(17,'3180634813','NUR ATIKA HAYANA SYAH NASUTION','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(18,'3160178873','RAJA ATHALLAH MALIK ALVARO','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(19,'3181410154','SARAH LILY FADHILAH','9782cca2-b7d6-4032-bf77-1824fafd3db6',NULL),(20,'3164848322','ALESHA AZ ZAHRA BR TARIGAN','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(21,'3164515511','ARSYAKA PUTRA ILHAM','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(22,'3170118185','GHAZZAWI ERBAKAN RITONGA','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(23,'3186719928','JIBRAN RIZKY ADROFIQ LUBIS','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(24,'3189302944','KHAIRUNNA AVA HUMAIRA','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(25,'3173280177','MAISAROH ALIYAH MAULANA','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(26,'3170703071','OK MHD KAZHIM AL-FATIH ARVY','e8f7f7d6-41a0-4b99-8058-7d785f18ad06',NULL),(27,'3166334806','ADHYASTHA VIRENDRA SIREGAR','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(28,'173049278','Ahmad Ashad Khalqi Hasibuan','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(29,'3162311958','ALIFA AFSHEEN SALSABILA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(30,'3161638795','ALMIRA NAZIYA FARZANA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(31,'3179326796','BOY NURADI','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(32,'3178837825','HASYA KALILA MARBUN','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(33,'3166829888','HISYAM KAMIL','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(34,'3178114128','ISKARIMA HASAN','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(35,'3163612020','JANNATUL FIRADAUSI NUZULA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(36,'3171679242','KHALID AHMAD AL KHALIFI WIBAWA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(37,'3172873419','Muhammad Abhizar','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(38,'3170037412','MUHAMMAD AYYASH','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(39,'3169111644','MUHAMMAD MISHARY RASYID','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(40,'3177212500','MUHAMMAD THAHA AL MUKHTAR','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(41,'3172889561','NADHIEF ZAFRAN ALFAYYADH SIAGIAN','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(42,'3162359347','RAZQA ZHAFRAN RAFFASYAH','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(43,'3168430077','SAFIYAH HAYATI KIRANI','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(44,'3162641203','TAHYA FELISTHIN RITONGA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(45,'3174032792','THARIQ MUHAMMAD ADROMIZA','0e9ad064-d91f-4cce-bbff-57b19d8efd08',NULL),(46,'3156634762','AHMAD DIPO NUGROHO PUTRA GIRI','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(47,'3160234412','AHMAD HASAN ISKANDAR','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(48,'3167257093','Aira Zahra','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(49,'3151514821','AKHSAN ATHARIQ LUBIS','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(50,'3158604481','ALI PASHA AL MUNTAZAR','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(51,'3167752301','AMIR KHALIF MUGHNI SITUMORANG','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(52,'3167204249','ASKANAH HANIFAH','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(53,'3153219614','ASMA\' TAQIYYA RIDHA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(54,'3160397799','DAVIN YAQDHANASA KHOIRULLAH','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(55,'3153626286','FARA DISYA FAYARZA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(56,'3156617592','HANDZOLA ARIFIN RITONGA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(57,'3163096594','IBRAHIM WILDAN HAKIM','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(58,'156915971','JAVIER AKTAM ELNAFAURA BARDI','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(59,'151601716','KHANSA ADEVA HIDAYAT','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(60,'152633360','MISYKA ZAYYAD \'ATHIRA SIREGAR','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(61,'3169463368','MUHAMMAD IQBAL TARUNA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(62,'3153471604','Muhammad Jadid Affandi','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(63,'3156725637','MUHAMMAD ZAKKI AL MALIK','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(64,'3165797489','NAURA SHAZIA SALSYAKIRA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(65,'3155096682','OEGRO HAMIZAN ASSALIH HARAHAP','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(66,'3165073670','QAIREEN LAIBA ZHA','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(67,'3166159805','RAFIF DZAKY AZZEMA LUBIS','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(68,'3166088213','YUMNA ABIDAH HARAHAP','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(69,'3165169462','ZIYAN ASKAN AYASI','ed8bf207-5eeb-4540-a127-8d45fc702faf',NULL),(70,'3149223140','ADAM FADHLIKA DARWANSYAH','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(71,'3144051223','ANINDYA SAMHA SAUFA LUBIS','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(72,'3156764748','ATIKAH KHODIJAH','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(73,'3158140553','DAONIMARA SIMAMORA','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(74,'3157403263','EMIR MUHAMMA AL-FATIH','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(75,'3152714128','FAIZ YAZID SIREGAR','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(76,'3158229674','HAYFA ADZKIYA BATUBARA','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(77,'137263048','NAZMA ATIQAH ZARLIS','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(78,'3157718036','MAHIRA ALHAURA TARIGAN','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(79,'3159094026','MUHAMMAD RAIHAN HANAFI','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(80,'3146177251','OK. MUHAMMAD KHALID AHZA ARVY','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(81,'142418379','RAYYAN FADHLA RAHMAN','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(82,'3159799046','SHAGUFTA ZIKRI FAUZI','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(83,'3155989264','SITI HANA ANISAH RAHMAH','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(84,'3150955231','ZAKIRAH NUSAIBAH SIREGAR','05523343-a5e7-49bc-a516-83864f9d70a9',NULL),(85,'3134243247','ADENIA HILYATUL JANNAH','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(86,'3139338892','AFIFAH ADZRA HAIDI','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(87,'3145324976','AISYAH AQILA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(88,'3147053902','AISYAH PUTRI CANDRA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(89,'3146067340','ALIF MHD RAIHAN DALIMUNTHE','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(90,'3137683868','ASKA ELDUTA KETAREN','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(91,'3133197687','AYYA SOPHIA ZAHWA BANUREA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(92,'3147328920','Faeyza Al Ghifari Batubara','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(93,'3147563729','FIKRI AL AZMI HARAHAP','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(94,'146481659','HAURI WASHFA KAMILA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(95,'3145416407','HAYFA ZHAFIRAH RAHMAH','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(96,'3141567862','KEISHA SASHIKIRANASATRIO','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(97,'3140578822','Muhammad Rasya Attaya','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(98,'3144532985','NABILAH HUSNA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(99,'3146668737','NADA FARAH MAULIDA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(100,'3147719917','NAURA WARDATUL ZHAHIRA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(101,'149330153','NUZULIYA MAHIRA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(102,'149138753','RAISYA ADELIA SINUHAJI','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(103,'3149087750','RENZY AKBAR APRILIO LUBIA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(104,'3145912127','REVAN PALUPI LUBIS','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(105,'3135330277','Rifat Arif Fadilah Saragih','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(106,'3138886824','SHAKILA SHAZIA AZZAHRA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(107,'3147999762','SHEIKHA ZIKRA FAUZI','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(108,'3148949109','SOLIHATUL ADZKIYA SIREGAR','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(109,'3148947548','ZAFIRA ALKHANSA','1e68ba47-758b-466c-92ba-4204e3b9315c',NULL),(110,'3125549787','Abdul Majid Siregar','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(111,'3138364473','AKHTAR RIZKI SIREGAR','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(112,'3139949773','AMIRA ANAQIE','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(113,'134181747','ARKAN ELHAQ BILFAQIH','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(114,'3139385112','AYASHA HAYFA HAJRI','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(115,'131881783','BINTANG REZKY ALFERDY','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(116,'3133163188','DARRIS HAMIZAN SIMAMORA','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(117,'3135241388','FARREL AULIA WALADY','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(118,'3133559103','FATHIYA ALMA RAHENDATRI','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(119,'3137468110','MUHAMMAD AFIQ FAUZAN','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(120,'3134348883','MUHAMMAD YUSUF HABIBIE','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(121,'139527900','MUHAMMAD ZAYYAD AHZA SIREGAR','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(122,'3136397245','NABIHAN PUTRA NOVARA','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(123,'127172842','Nabila Adelia Putri','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(124,'3135287533','NAUVAL APRILYANSYAH','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(125,'135740023','RAFA SAHPUTRA DAMANIK','296bc209-4320-4afc-b634-ffe5521603bb',NULL),(126,'3131916418','WAHYU WIBOWO','296bc209-4320-4afc-b634-ffe5521603bb',NULL); /*!40000 ALTER TABLE `m_siswa` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `parameter_nilai_rombel` -- DROP TABLE IF EXISTS `parameter_nilai_rombel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `parameter_nilai_rombel` ( `uniqid` int(11) NOT NULL AUTO_INCREMENT, `uniqid_parameter_nilai` varchar(50) NOT NULL, `uniqid_rombel` varchar(50) NOT NULL, PRIMARY KEY (`uniqid`), KEY `uniqid_parameter_nilai` (`uniqid_parameter_nilai`), KEY `uniqid_rombel` (`uniqid_rombel`), CONSTRAINT `parameter_nilai_rombel_ibfk_1` FOREIGN KEY (`uniqid_parameter_nilai`) REFERENCES `m_parameter_nilai` (`uniqid`) ON DELETE CASCADE, CONSTRAINT `parameter_nilai_rombel_ibfk_2` FOREIGN KEY (`uniqid_rombel`) REFERENCES `m_rombel` (`uniqid`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `parameter_nilai_rombel` -- LOCK TABLES `parameter_nilai_rombel` WRITE; /*!40000 ALTER TABLE `parameter_nilai_rombel` DISABLE KEYS */; INSERT INTO `parameter_nilai_rombel` VALUES (1,'a8aebc87-9844-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(2,'a8aec1c5-9844-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(3,'a8aeff82-9844-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(4,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(5,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(6,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25dc9-9842-11f0-9d98-701a04df3b83'),(7,'a8aebc87-9844-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(8,'a8aec1c5-9844-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(9,'a8aeff82-9844-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(10,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(11,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(12,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25e98-9842-11f0-9d98-701a04df3b83'),(13,'a8aebc87-9844-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(14,'a8aec1c5-9844-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(15,'a8aeff82-9844-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(16,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(17,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(18,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25f62-9842-11f0-9d98-701a04df3b83'),(32,'0d5cd62c-9854-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(33,'0d5cd62c-9854-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(34,'0d5cd62c-9854-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(35,'1f401d57-9854-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(36,'1f401d57-9854-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(37,'1f401d57-9854-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(38,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(39,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(40,'b8fb8cc8-9846-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(41,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(42,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(43,'b8fb9337-9846-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(44,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(45,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(46,'b8fb94d5-9846-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(47,'dfdbddbc-9853-11f0-9d98-701a04df3b83','bed25411-9842-11f0-9d98-701a04df3b83'),(48,'dfdbddbc-9853-11f0-9d98-701a04df3b83','bed25b41-9842-11f0-9d98-701a04df3b83'),(49,'dfdbddbc-9853-11f0-9d98-701a04df3b83','bed25cbf-9842-11f0-9d98-701a04df3b83'),(50,'1','bed25411-9842-11f0-9d98-701a04df3b83'),(51,'2','bed25411-9842-11f0-9d98-701a04df3b83'),(52,'3','bed25411-9842-11f0-9d98-701a04df3b83'),(53,'1','bed25b41-9842-11f0-9d98-701a04df3b83'),(54,'2','bed25b41-9842-11f0-9d98-701a04df3b83'),(55,'3','bed25b41-9842-11f0-9d98-701a04df3b83'),(56,'1','bed25cbf-9842-11f0-9d98-701a04df3b83'),(57,'2','bed25cbf-9842-11f0-9d98-701a04df3b83'),(58,'3','bed25cbf-9842-11f0-9d98-701a04df3b83'),(59,'1','bed25dc9-9842-11f0-9d98-701a04df3b83'),(60,'2','bed25dc9-9842-11f0-9d98-701a04df3b83'),(61,'3','bed25dc9-9842-11f0-9d98-701a04df3b83'),(62,'1','bed25e98-9842-11f0-9d98-701a04df3b83'),(63,'2','bed25e98-9842-11f0-9d98-701a04df3b83'),(64,'3','bed25e98-9842-11f0-9d98-701a04df3b83'),(65,'1','bed25f62-9842-11f0-9d98-701a04df3b83'),(66,'2','bed25f62-9842-11f0-9d98-701a04df3b83'),(67,'3','bed25f62-9842-11f0-9d98-701a04df3b83'); /*!40000 ALTER TABLE `parameter_nilai_rombel` ENABLE KEYS */; UNLOCK TABLES; -- -- Temporary table structure for view `v_guru` -- DROP TABLE IF EXISTS `v_guru`; /*!50001 DROP VIEW IF EXISTS `v_guru`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_guru` AS SELECT 1 AS `id`, 1 AS `first_name`, 1 AS `last_name`, 1 AS `nama_lengkap`, 1 AS `email`, 1 AS `nama_group` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v_ortu` -- DROP TABLE IF EXISTS `v_ortu`; /*!50001 DROP VIEW IF EXISTS `v_ortu`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_ortu` AS SELECT 1 AS `id`, 1 AS `first_name`, 1 AS `last_name`, 1 AS `nama_lengkap`, 1 AS `email`, 1 AS `nama_group` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v_parameter_nilai_rombel` -- DROP TABLE IF EXISTS `v_parameter_nilai_rombel`; /*!50001 DROP VIEW IF EXISTS `v_parameter_nilai_rombel`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_parameter_nilai_rombel` AS SELECT 1 AS `uniqid_kelas`, 1 AS `nama_kelas`, 1 AS `nama_rombel`, 1 AS `uniqid_parameter`, 1 AS `nama_parameter`, 1 AS `jenis_parameter`, 1 AS `keterangan`, 1 AS `uniqid_parameter_nilai`, 1 AS `uniqid_rombel` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v_penilaian` -- DROP TABLE IF EXISTS `v_penilaian`; /*!50001 DROP VIEW IF EXISTS `v_penilaian`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_penilaian` AS SELECT 1 AS `h_nilai_id`, 1 AS `tanggal_penilaian`, 1 AS `siswa_id`, 1 AS `alquran_id`, 1 AS `ayat_awal`, 1 AS `ayat_akhir`, 1 AS `jilid`, 1 AS `catatan`, 1 AS `jenis_ujian`, 1 AS `detail_id`, 1 AS `nilai`, 1 AS `surat_alquran`, 1 AS `nama_parameter`, 1 AS `jenis_parameter`, 1 AS `keterangan_parameter`, 1 AS `status` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v_siswa` -- DROP TABLE IF EXISTS `v_siswa`; /*!50001 DROP VIEW IF EXISTS `v_siswa`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_siswa` AS SELECT 1 AS `id_siswa`, 1 AS `NISN`, 1 AS `Nama`, 1 AS `nama_kelas`, 1 AS `kelas_id`, 1 AS `nama_rombel`, 1 AS `ortu_id`, 1 AS `nama_ortu` */; SET character_set_client = @saved_cs_client; -- -- Final view structure for view `v_guru` -- /*!50001 DROP VIEW IF EXISTS `v_guru`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_guru` AS select `a`.`id` AS `id`,`a`.`first_name` AS `first_name`,`a`.`last_name` AS `last_name`,concat(`a`.`first_name`,' ',`a`.`last_name`) AS `nama_lengkap`,`a`.`email` AS `email`,`c`.`name` AS `nama_group` from ((`ion_auth_users` `a` join `ion_auth_users_groups` `b` on(`a`.`id` = `b`.`user_id`)) join `ion_auth_groups` `c` on(`b`.`group_id` = `c`.`id`)) where `c`.`name` = 'guru' */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v_ortu` -- /*!50001 DROP VIEW IF EXISTS `v_ortu`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_ortu` AS select `a`.`id` AS `id`,`a`.`first_name` AS `first_name`,`a`.`last_name` AS `last_name`,concat(`a`.`first_name`,' ',`a`.`last_name`) AS `nama_lengkap`,`a`.`email` AS `email`,`c`.`name` AS `nama_group` from ((`ion_auth_users` `a` join `ion_auth_users_groups` `b` on(`a`.`id` = `b`.`user_id`)) join `ion_auth_groups` `c` on(`b`.`group_id` = `c`.`id`)) where `c`.`name` = 'ortu' */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v_parameter_nilai_rombel` -- /*!50001 DROP VIEW IF EXISTS `v_parameter_nilai_rombel`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_parameter_nilai_rombel` AS select `k`.`uniqid` AS `uniqid_kelas`,`k`.`nama_kelas` AS `nama_kelas`,`r`.`nama_rombel` AS `nama_rombel`,`p`.`uniqid` AS `uniqid_parameter`,`p`.`nama_parameter` AS `nama_parameter`,`p`.`jenis_parameter` AS `jenis_parameter`,`p`.`keterangan` AS `keterangan`,`rel`.`uniqid_parameter_nilai` AS `uniqid_parameter_nilai`,`rel`.`uniqid_rombel` AS `uniqid_rombel` from (((`parameter_nilai_rombel` `rel` join `m_parameter_nilai` `p` on(`rel`.`uniqid_parameter_nilai` = `p`.`uniqid`)) join `m_rombel` `r` on(`rel`.`uniqid_rombel` = `r`.`uniqid`)) join `m_kelas` `k` on(`r`.`uniqid` = `k`.`rombel_id`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v_penilaian` -- /*!50001 DROP VIEW IF EXISTS `v_penilaian`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_penilaian` AS select `a`.`uniqid` AS `h_nilai_id`,`a`.`tanggal_penilaian` AS `tanggal_penilaian`,`a`.`siswa_id` AS `siswa_id`,`a`.`alquran_id` AS `alquran_id`,`a`.`ayat_awal` AS `ayat_awal`,`a`.`ayat_akhir` AS `ayat_akhir`,`a`.`jilid` AS `jilid`,`a`.`catatan` AS `catatan`,`a`.`jenis_ujian` AS `jenis_ujian`,`b`.`uniqid` AS `detail_id`,`b`.`nilai` AS `nilai`,`d`.`transliteration` AS `surat_alquran`,`e`.`nama_parameter` AS `nama_parameter`,`e`.`jenis_parameter` AS `jenis_parameter`,`e`.`keterangan` AS `keterangan_parameter`,`a`.`status` AS `status` from (((`h_nilai` `a` join `detail_nilai` `b` on(`b`.`header_id` = `a`.`uniqid`)) left join `m_alquran` `d` on(`d`.`id` = `a`.`alquran_id`)) left join `m_parameter_nilai` `e` on(`e`.`uniqid` = `b`.`parameter_id`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; -- -- Final view structure for view `v_siswa` -- /*!50001 DROP VIEW IF EXISTS `v_siswa`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8mb4 */; /*!50001 SET character_set_results = utf8mb4 */; /*!50001 SET collation_connection = utf8mb4_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_siswa` AS select `a`.`id` AS `id_siswa`,`a`.`NISN` AS `NISN`,`a`.`Nama` AS `Nama`,`b`.`nama_kelas` AS `nama_kelas`,`a`.`kelas_id` AS `kelas_id`,`c`.`nama_rombel` AS `nama_rombel`,`d`.`id` AS `ortu_id`,concat(`d`.`first_name`,' ',`d`.`last_name`) AS `nama_ortu` from (((`m_siswa` `a` left join `v_ortu` `d` on(`a`.`ortu_id` = `d`.`id`)) join `m_kelas` `b` on(`a`.`kelas_id` = `b`.`uniqid`)) join `m_rombel` `c` on(`b`.`rombel_id` = `c`.`uniqid`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-11-20 16:53:38