--
-- Host: 127.0.0.1    Database: belajar_alquran
-- ------------------------------------------------------


--
-- Table structure for table `ci_sessions`
--

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;

--
-- Dumping data for table `ci_sessions`
--


--
-- Table structure for table `detail_nilai`
--

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;

--
-- Dumping data for table `detail_nilai`
--

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);

--
-- Table structure for table `h_nilai`
--

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;

--
-- Dumping data for table `h_nilai`
--

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');

--
-- Table structure for table `ion_auth_groups`
--

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;

--
-- Dumping data for table `ion_auth_groups`
--

INSERT INTO `ion_auth_groups` VALUES (1,'admin','Administrator'),(2,'guru','Guru'),(3,'ortu','orang tua siswa');

--
-- Table structure for table `ion_auth_login_attempts`
--

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;

--
-- Dumping data for table `ion_auth_login_attempts`
--


--
-- Table structure for table `ion_auth_users_groups`
--

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;

--
-- Dumping data for table `ion_auth_users_groups`
--

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);

--
-- Table structure for table `konfigurasi`
--

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;

--
-- Dumping data for table `konfigurasi`
--

INSERT INTO `konfigurasi` VALUES (1,'tahun_ajaran','2025'),(2,'semester','ganjil');

--
-- Table structure for table `m_alquran`
--

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;

--
-- Dumping data for table `m_alquran`
--

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);

--
-- Table structure for table `m_jilid`
--

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;

--
-- Dumping data for table `m_jilid`
--

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);

--
-- Table structure for table `m_kelas`
--

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;

--
-- Dumping data for table `m_kelas`
--

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');

--
-- Table structure for table `m_parameter_nilai`
--

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;

--
-- Dumping data for table `m_parameter_nilai`
--

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');

--
-- Table structure for table `m_rombel`
--

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;

--
-- Dumping data for table `m_rombel`
--

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);

--
-- Table structure for table `m_siswa`
--

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;

--
-- Dumping data for table `m_siswa`
--

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);

--
-- Table structure for table `parameter_nilai_rombel`
--

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;

--
-- Dumping data for table `parameter_nilai_rombel`
--

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');

--
-- Temporary table structure for view `v_guru`
--

/*!50001 DROP VIEW IF EXISTS `v_guru`*/;
/*!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` */;

--
-- Temporary table structure for view `v_ortu`
--

/*!50001 DROP VIEW IF EXISTS `v_ortu`*/;
/*!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` */;

--
-- Temporary table structure for view `v_parameter_nilai_rombel`
--

/*!50001 DROP VIEW IF EXISTS `v_parameter_nilai_rombel`*/;
/*!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` */;

--
-- Temporary table structure for view `v_penilaian`
--

/*!50001 DROP VIEW IF EXISTS `v_penilaian`*/;
/*!50001 CREATE VIEW `v_penilaian` AS SELECT
 1 AS `h_nilai_id`,
  1 AS `tanggal_penilaian`,
  1 AS `siswa_id`,
  1 AS `alquran_id`,
  1 AS `ayat_awal`,
  1 AS `ayat_akhir`,
  1 AS `jilid`,
  1 AS `catatan`,
  1 AS `jenis_ujian`,
  1 AS `detail_id`,
  1 AS `nilai`,
  1 AS `surat_alquran`,
  1 AS `nama_parameter`,
  1 AS `jenis_parameter`,
  1 AS `keterangan_parameter`,
  1 AS `status` */;

--
-- Temporary table structure for view `v_siswa`
--

/*!50001 DROP VIEW IF EXISTS `v_siswa`*/;
/*!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` */;

--
-- Final view structure for view `v_guru`
--

/*!50001 DROP VIEW IF EXISTS `v_guru`*/;
/*!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' */;

--
-- Final view structure for view `v_ortu`
--

/*!50001 DROP VIEW IF EXISTS `v_ortu`*/;
/*!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' */;

--
-- Final view structure for view `v_parameter_nilai_rombel`
--

/*!50001 DROP VIEW IF EXISTS `v_parameter_nilai_rombel`*/;
/*!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`)) */;

--
-- Final view structure for view `v_penilaian`
--

/*!50001 DROP VIEW IF EXISTS `v_penilaian`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_penilaian` AS select `a`.`uniqid` AS `h_nilai_id`,`a`.`tanggal_penilaian` AS `tanggal_penilaian`,`a`.`siswa_id` AS `siswa_id`,`a`.`alquran_id` AS `alquran_id`,`a`.`ayat_awal` AS `ayat_awal`,`a`.`ayat_akhir` AS `ayat_akhir`,`a`.`jilid` AS `jilid`,`a`.`catatan` AS `catatan`,`a`.`jenis_ujian` AS `jenis_ujian`,`b`.`uniqid` AS `detail_id`,`b`.`nilai` AS `nilai`,`d`.`transliteration` AS `surat_alquran`,`e`.`nama_parameter` AS `nama_parameter`,`e`.`jenis_parameter` AS `jenis_parameter`,`e`.`keterangan` AS `keterangan_parameter`,`a`.`status` AS `status` from (((`h_nilai` `a` join `detail_nilai` `b` on(`b`.`header_id` = `a`.`uniqid`)) left join `m_alquran` `d` on(`d`.`id` = `a`.`alquran_id`)) left join `m_parameter_nilai` `e` on(`e`.`uniqid` = `b`.`parameter_id`)) */;

--
-- Final view structure for view `v_siswa`
--

/*!50001 DROP VIEW IF EXISTS `v_siswa`*/;
/*!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`)) */;


