/*M!999999\- enable the sandbox mode */ -- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (aarch64) -- -- Host: 127.0.0.1 Database: belajar_alquran -- ------------------------------------------------------ -- Server version 10.11.14-MariaDB-0+deb12u2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `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` -- /*!40000 ALTER TABLE `ci_sessions` DISABLE KEYS */; /*!40000 ALTER TABLE `ci_sessions` ENABLE KEYS */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!40000 ALTER TABLE `ion_auth_login_attempts` DISABLE KEYS */; /*!40000 ALTER TABLE `ion_auth_login_attempts` ENABLE KEYS */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!40000 ALTER TABLE `konfigurasi` DISABLE KEYS */; INSERT INTO `konfigurasi` VALUES (1,'tahun_ajaran','2025'), (2,'semester','ganjil'); /*!40000 ALTER TABLE `konfigurasi` ENABLE KEYS */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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` -- /*!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 */; -- -- 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 `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; -- -- Dumping routines for database 'belajar_alquran' -- -- -- 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_unicode_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`,`f`.`nama_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`,`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`)) join `v_siswa` `f` on(`f`.`id_siswa` = `a`.`siswa_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 */; /*!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-21 15:24:45