/*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, `nilai_huruf` varchar(1) DEFAULT NULL, `parameter` text DEFAULT NULL, `catatan` 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 `detail_nilai` -- LOCK TABLES `detail_nilai` WRITE; /*!40000 ALTER TABLE `detail_nilai` DISABLE KEYS */; INSERT INTO `detail_nilai` VALUES ('detail693a9b11f13011.68116914','nilai693a9b11f0d726.46908801','b8fb8cc8-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f1cde4.89032595','nilai693a9b11f0d726.46908801','b8fb9337-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f21325.42468541','nilai693a9b11f0d726.46908801','b8fb94d5-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f2a474.89552234','nilai693a9b11f262d6.31179363','b8fb8cc8-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f2dd20.88514538','nilai693a9b11f262d6.31179363','b8fb9337-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f30df8.98461300','nilai693a9b11f262d6.31179363','b8fb94d5-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9b11f38766.58781024','nilai693a9b11f33ff9.61089180','1',20,NULL,NULL,NULL),('detail693a9b11f3c546.36796920','nilai693a9b11f33ff9.61089180','2',20,NULL,NULL,NULL),('detail693a9b11f40033.19199258','nilai693a9b11f33ff9.61089180','3',20,NULL,NULL,NULL),('detail693a9d429e23b8.01974442','nilai693a9d429dd153.65538155','b8fb8cc8-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d429e8ad4.46107617','nilai693a9d429dd153.65538155','b8fb9337-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d429ed260.55436147','nilai693a9d429dd153.65538155','b8fb94d5-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d429f6eb7.76627111','nilai693a9d429f2015.22426333','b8fb8cc8-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d429facd6.57233829','nilai693a9d429f2015.22426333','b8fb9337-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d429febc9.03826930','nilai693a9d429f2015.22426333','b8fb94d5-9846-11f0-9d98-701a04df3b83',30,NULL,NULL,NULL),('detail693a9d42a06f31.74303974','nilai693a9d42a02650.04332882','1',20,NULL,NULL,NULL),('detail693a9d42a0ba25.96734319','nilai693a9d42a02650.04332882','2',20,NULL,NULL,NULL),('detail693a9d42a0fc84.73980647','nilai693a9d42a02650.04332882','3',20,NULL,NULL,NULL),('detail693a9f0acc5836.15809141','nilai693a9f0acb7ff0.73315322','0d5cd62c-9854-11f0-9d98-701a04df3b83',NULL,'A',NULL,'baik'),('detail693a9f0acc9473.21552527','nilai693a9f0acb7ff0.73315322','1f401d57-9854-11f0-9d98-701a04df3b83',NULL,'A',NULL,'baik'),('detail693a9f0accc3f3.27588977','nilai693a9f0acb7ff0.73315322','dfdbddbc-9853-11f0-9d98-701a04df3b83',NULL,'A',NULL,'baik'),('detail693a9f0acd3127.45827962','nilai693a9f0accf885.29263999','b8fb8cc8-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0acd6506.10185743','nilai693a9f0accf885.29263999','b8fb9337-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0acd9f94.27909198','nilai693a9f0accf885.29263999','b8fb94d5-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0ace7f21.58253892','nilai693a9f0ace2c32.47006141','b8fb8cc8-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0acebc27.06077469','nilai693a9f0ace2c32.47006141','b8fb9337-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0acef1a2.41577392','nilai693a9f0ace2c32.47006141','b8fb94d5-9846-11f0-9d98-701a04df3b83',NULL,'3',NULL,NULL),('detail693a9f0acf7347.41857331','nilai693a9f0acf2ad6.52684217','1',NULL,'2',NULL,NULL),('detail693a9f0acfacb7.91431169','nilai693a9f0acf2ad6.52684217','2',NULL,'2',NULL,NULL),('detail693a9f0acfec07.15540574','nilai693a9f0acf2ad6.52684217','3',NULL,'2',NULL,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, `halaman` 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 ('nilai693a9b11ef6129.88745549','28','null',NULL,'2025-12-11',NULL,'Kelas 2','santun','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9b11f0d726.46908801','28','null','108','2025-12-11','ok','Kelas 2',NULL,'ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9b11f262d6.31179363','28','null','109','2025-12-11',NULL,'Kelas 2','tahfidz','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9b11f33ff9.61089180','28','null',NULL,'2025-12-11','baik','Kelas 2','tilawah','ganjil',2025,0,NULL,NULL,'1',NULL,'ujian_semester','1-2'),('nilai693a9d429d4ef3.67154066','28','null',NULL,'2025-12-11',NULL,'Kelas 2','santun','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9d429dd153.65538155','28','null','108','2025-12-11','ok','Kelas 2',NULL,'ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9d429f2015.22426333','28','null','109','2025-12-11',NULL,'Kelas 2','tahfidz','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9d42a02650.04332882','28','null',NULL,'2025-12-11','baik','Kelas 2','tilawah','ganjil',2025,0,NULL,NULL,'1',NULL,'ujian_semester','1-2'),('nilai693a9f0acb7ff0.73315322','28','null',NULL,'2025-12-11',NULL,'Kelas 2','santun','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9f0accf885.29263999','28','null','108','2025-12-11','ok','Kelas 2',NULL,'ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9f0ace2c32.47006141','28','null','109','2025-12-11',NULL,'Kelas 2','tahfidz','ganjil',2025,0,NULL,NULL,NULL,NULL,'ujian_semester',NULL),('nilai693a9f0acf2ad6.52684217','28','null',NULL,'2025-12-11','baik','Kelas 2','tilawah','ganjil',2025,0,NULL,NULL,'1',NULL,'ujian_semester','1-2'); /*!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,1764131498,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` 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_jilid` -- LOCK TABLES `m_jilid` WRITE; /*!40000 ALTER TABLE `m_jilid` DISABLE KEYS */; INSERT INTO `m_jilid` VALUES ('1','1'),('2','2'),('3','3'),('4','4'),('J1','Juz 1'),('J10','Juz 10'),('J11','Juz 11'),('J12','Juz 12'),('J13','Juz 13'),('J14','Juz 14'),('J15','Juz 15'),('J16','Juz 16'),('J17','Juz 17'),('J18','Juz 18'),('J19','Juz 19'),('J2','Juz 2'),('J20','Juz 20'),('J21','Juz 21'),('J22','Juz 22'),('J23','Juz 23'),('J24','Juz 24'),('J25','Juz 25'),('J26','Juz 26'),('J27','Juz 27'),('J28','Juz 28'),('J29','Juz 29'),('J3','Juz 3'),('J30','Juz 30'),('J4','Juz 4'),('J5','Juz 5'),('J6','Juz 6'),('J7','Juz 7'),('J8','Juz 8'),('J9','Juz 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; -- -- Table structure for table `target` -- DROP TABLE IF EXISTS `target`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8mb4 */; CREATE TABLE `target` ( `uniqid` int(11) NOT NULL AUTO_INCREMENT, `jenis_penilaian` varchar(45) DEFAULT NULL, `id_alquran` varchar(45) DEFAULT NULL, `id_jilid` varchar(45) DEFAULT NULL, `id_rombel` varchar(45) DEFAULT NULL, PRIMARY KEY (`uniqid`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `target` -- LOCK TABLES `target` WRITE; /*!40000 ALTER TABLE `target` DISABLE KEYS */; INSERT INTO `target` VALUES (1,'tahfidz','114',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(2,'tahfidz','113',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(3,'tahfidz','112',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(4,'tahfidz','111',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(5,'tahfidz','110',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(6,'tahfidz','109',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(7,'tahfidz','108',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(8,'tahfidz','107',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(9,'tahfidz','106',NULL,'bed25411-9842-11f0-9d98-701a04df3b83'),(10,'tahfidz','102',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(11,'tahfidz','101',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(12,'tahfidz','100',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(13,'tahfidz','99',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(14,'tahfidz','98',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(15,'tahfidz','97',NULL,'bed25b41-9842-11f0-9d98-701a04df3b83'),(16,'tahfidz','92',NULL,'bed25cbf-9842-11f0-9d98-701a04df3b83'),(17,'tahfidz','91',NULL,'bed25cbf-9842-11f0-9d98-701a04df3b83'),(18,'tahfidz','90',NULL,'bed25cbf-9842-11f0-9d98-701a04df3b83'),(19,'tahfidz','86',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(20,'tahfidz','85',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(21,'tahfidz','84',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(22,'tahfidz','83',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(23,'tahfidz','82',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(24,'tahfidz','81',NULL,'bed25dc9-9842-11f0-9d98-701a04df3b83'),(25,'tahfidz','70',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),(26,'tahfidz','71',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),(27,'tahfidz','72',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),(28,'tahfidz','73',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),(29,'tahfidz','74',NULL,'bed25e98-9842-11f0-9d98-701a04df3b83'),(30,'tahfidz','78',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(31,'tahfidz','79',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(32,'tahfidz','80',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(33,'tahfidz','81',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(34,'tahfidz','82',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(35,'tahfidz','83',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(36,'tahfidz','84',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(37,'tahfidz','85',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(38,'tahfidz','86',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(39,'tahfidz','87',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(40,'tahfidz','88',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(41,'tahfidz','89',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(42,'tahfidz','90',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(43,'tahfidz','91',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(44,'tahfidz','92',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(45,'tahfidz','93',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(46,'tahfidz','94',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(47,'tahfidz','95',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(48,'tahfidz','96',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(49,'tahfidz','97',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(50,'tahfidz','98',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(51,'tahfidz','99',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(52,'tahfidz','100',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(53,'tahfidz','101',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(54,'tahfidz','102',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(55,'tahfidz','103',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(56,'tahfidz','104',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(57,'tahfidz','105',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(58,'tahfidz','106',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(59,'tahfidz','107',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(60,'tahfidz','108',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(61,'tahfidz','109',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(62,'tahfidz','110',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(63,'tahfidz','111',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(64,'tahfidz','112',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(65,'tahfidz','113',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'),(66,'tahfidz','114',NULL,'bed25f62-9842-11f0-9d98-701a04df3b83'); /*!40000 ALTER TABLE `target` 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 `NISN`, 1 AS `nama_siswa`, 1 AS `kelas_id`, 1 AS `nama_kelas`, 1 AS `nama_rombel`, 1 AS `alquran_id`, 1 AS `ayat_awal`, 1 AS `ayat_akhir`, 1 AS `jilid`, 1 AS `catatan`, 1 AS `semester`, 1 AS `tahun_ajaran`, 1 AS `jenis_ujian`, 1 AS `detail_id`, 1 AS `nilai`, 1 AS `nilai_huruf`, 1 AS `catatan_detail`, 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; -- -- Temporary table structure for view `v_skor_harian` -- DROP TABLE IF EXISTS `v_skor_harian`; /*!50001 DROP VIEW IF EXISTS `v_skor_harian`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_skor_harian` AS SELECT 1 AS `h_nilai_id`, 1 AS `tanggal_penilaian`, 1 AS `siswa_id`, 1 AS `NISN`, 1 AS `nama_siswa`, 1 AS `kelas_id`, 1 AS `nama_kelas`, 1 AS `nama_rombel`, 1 AS `alquran_id`, 1 AS `ayat_awal`, 1 AS `ayat_akhir`, 1 AS `jilid`, 1 AS `catatan`, 1 AS `semester`, 1 AS `tahun_ajaran`, 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`, 1 AS `total_skor` */; SET character_set_client = @saved_cs_client; -- -- Temporary table structure for view `v_target_rombel` -- DROP TABLE IF EXISTS `v_target_rombel`; /*!50001 DROP VIEW IF EXISTS `v_target_rombel`*/; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8mb4; /*!50001 CREATE VIEW `v_target_rombel` AS SELECT 1 AS `uniqid`, 1 AS `jenis_penilaian`, 1 AS `id_alquran`, 1 AS `id_jilid`, 1 AS `id_rombel`, 1 AS `transliteration`, 1 AS `nama_rombel` */; 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`,`f`.`NISN` AS `NISN`,`f`.`Nama` AS `nama_siswa`,`f`.`kelas_id` AS `kelas_id`,`a`.`kelas` AS `nama_kelas`,`f`.`nama_rombel` AS `nama_rombel`,`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`.`semester` AS `semester`,`a`.`tahun_ajaran` AS `tahun_ajaran`,`a`.`jenis_ujian` AS `jenis_ujian`,`b`.`uniqid` AS `detail_id`,`b`.`nilai` AS `nilai`,`b`.`nilai_huruf` AS `nilai_huruf`,`b`.`catatan` AS `catatan_detail`,`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`)) join `v_siswa` `f` on(`f`.`id_siswa` = `a`.`siswa_id`)) 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 */; -- -- Final view structure for view `v_skor_harian` -- /*!50001 DROP VIEW IF EXISTS `v_skor_harian`*/; /*!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_unicode_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`fakhri`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_skor_harian` AS select `v_penilaian`.`h_nilai_id` AS `h_nilai_id`,`v_penilaian`.`tanggal_penilaian` AS `tanggal_penilaian`,`v_penilaian`.`siswa_id` AS `siswa_id`,`v_penilaian`.`NISN` AS `NISN`,`v_penilaian`.`nama_siswa` AS `nama_siswa`,`v_penilaian`.`kelas_id` AS `kelas_id`,`v_penilaian`.`nama_kelas` AS `nama_kelas`,`v_penilaian`.`nama_rombel` AS `nama_rombel`,`v_penilaian`.`alquran_id` AS `alquran_id`,`v_penilaian`.`ayat_awal` AS `ayat_awal`,`v_penilaian`.`ayat_akhir` AS `ayat_akhir`,`v_penilaian`.`jilid` AS `jilid`,`v_penilaian`.`catatan` AS `catatan`,`v_penilaian`.`semester` AS `semester`,`v_penilaian`.`tahun_ajaran` AS `tahun_ajaran`,`v_penilaian`.`jenis_ujian` AS `jenis_ujian`,`v_penilaian`.`detail_id` AS `detail_id`,`v_penilaian`.`nilai` AS `nilai`,`v_penilaian`.`surat_alquran` AS `surat_alquran`,`v_penilaian`.`nama_parameter` AS `nama_parameter`,`v_penilaian`.`jenis_parameter` AS `jenis_parameter`,`v_penilaian`.`keterangan_parameter` AS `keterangan_parameter`,`v_penilaian`.`status` AS `status`,sum(`v_penilaian`.`nilai`) AS `total_skor` from `v_penilaian` where `v_penilaian`.`jenis_ujian` = 'harian' group by `v_penilaian`.`siswa_id`,`v_penilaian`.`jenis_parameter` */; /*!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_target_rombel` -- /*!50001 DROP VIEW IF EXISTS `v_target_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=`fakhri`@`localhost` SQL SECURITY DEFINER */ /*!50001 VIEW `v_target_rombel` AS select `a`.`uniqid` AS `uniqid`,`a`.`jenis_penilaian` AS `jenis_penilaian`,`a`.`id_alquran` AS `id_alquran`,`a`.`id_jilid` AS `id_jilid`,`a`.`id_rombel` AS `id_rombel`,`b`.`transliteration` AS `transliteration`,`c`.`nama_rombel` AS `nama_rombel` from ((`target` `a` join `m_alquran` `b` on(`a`.`id_alquran` = `b`.`id`)) join `m_rombel` `c` on(`a`.`id_rombel` = `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-12-11 23:03:14