-- -------------------------------------------------------- -- Host: 127.0.0.1 -- Server version: 8.0.30 - MySQL Community Server - GPL -- Server OS: Win64 -- HeidiSQL Version: 12.1.0.6537 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- Dumping database structure for db_absensi_muttaqin CREATE DATABASE IF NOT EXISTS `db_absensi_muttaqin` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `db_absensi_muttaqin`; -- Dumping structure for table db_absensi_muttaqin.absensis CREATE TABLE IF NOT EXISTS `absensis` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `siswa_id` bigint unsigned DEFAULT NULL, `guru_id` bigint unsigned DEFAULT NULL, `kategori` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal` date NOT NULL, `jam_scan` time NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Hadir', PRIMARY KEY (`id`), KEY `absensis_siswa_id_foreign` (`siswa_id`), KEY `absensis_guru_id_foreign` (`guru_id`), CONSTRAINT `absensis_guru_id_foreign` FOREIGN KEY (`guru_id`) REFERENCES `gurus` (`id`) ON DELETE CASCADE, CONSTRAINT `absensis_siswa_id_foreign` FOREIGN KEY (`siswa_id`) REFERENCES `siswas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=316 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.absensis: ~115 rows (approximately) INSERT INTO `absensis` (`id`, `siswa_id`, `guru_id`, `kategori`, `tanggal`, `jam_scan`, `created_at`, `updated_at`, `status`) VALUES (165, NULL, 58, 'Masuk', '2026-06-30', '11:27:00', '2026-06-30 04:27:27', '2026-06-30 04:27:27', 'Hadir'), (166, NULL, 56, 'Masuk', '2026-07-01', '06:49:00', '2026-06-30 23:49:22', '2026-06-30 23:49:22', 'Hadir'), (167, NULL, 58, 'Masuk', '2026-07-01', '06:50:00', '2026-06-30 23:50:09', '2026-06-30 23:50:09', 'Hadir'), (168, NULL, 57, 'Masuk', '2026-07-01', '06:50:00', '2026-06-30 23:50:25', '2026-06-30 23:50:25', 'Hadir'), (175, NULL, 57, 'Masuk', '2026-07-03', '09:38:00', '2026-07-03 02:38:37', '2026-07-03 02:38:37', 'Hadir'), (176, NULL, 58, 'Masuk', '2026-07-03', '09:41:00', '2026-07-03 02:41:17', '2026-07-03 02:41:17', 'Hadir'), (177, NULL, 56, 'Masuk', '2026-07-03', '09:41:00', '2026-07-03 02:41:58', '2026-07-03 02:41:58', 'Hadir'), (178, 521, NULL, 'Tadarus', '2026-07-03', '10:08:00', '2026-07-03 03:08:32', '2026-07-03 03:08:32', 'Hadir'), (179, 524, NULL, 'Tadarus', '2026-07-03', '10:08:00', '2026-07-03 03:08:41', '2026-07-03 03:08:41', 'Hadir'), (180, 522, NULL, 'Tadarus', '2026-07-03', '10:08:00', '2026-07-03 03:08:52', '2026-07-03 03:08:52', 'Hadir'), (181, 523, NULL, 'Tadarus', '2026-07-03', '10:09:00', '2026-07-03 03:09:11', '2026-07-03 03:09:11', 'Hadir'), (182, 526, NULL, 'Tadarus', '2026-07-03', '10:09:00', '2026-07-03 03:09:44', '2026-07-03 03:09:44', 'Hadir'), (183, 529, NULL, 'Tadarus', '2026-07-03', '10:09:00', '2026-07-03 03:09:55', '2026-07-03 03:09:55', 'Hadir'), (184, 532, NULL, 'Tadarus', '2026-07-03', '10:10:00', '2026-07-03 03:10:04', '2026-07-03 03:10:04', 'Hadir'), (185, 535, NULL, 'Tadarus', '2026-07-03', '10:10:00', '2026-07-03 03:10:13', '2026-07-03 03:10:13', 'Hadir'), (186, 538, NULL, 'Tadarus', '2026-07-03', '10:14:00', '2026-07-03 03:14:06', '2026-07-03 03:14:06', 'Hadir'), (187, 524, NULL, 'Duha', '2026-07-04', '08:46:00', '2026-07-04 01:46:50', '2026-07-04 01:46:50', 'Hadir'), (188, 530, NULL, 'Duha', '2026-07-04', '08:47:00', '2026-07-04 01:47:04', '2026-07-04 01:47:04', 'Hadir'), (189, 521, NULL, 'Duha', '2026-07-04', '08:49:00', '2026-07-04 01:49:07', '2026-07-04 01:49:07', 'Hadir'), (190, 527, NULL, 'Duha', '2026-07-04', '08:49:00', '2026-07-04 01:49:12', '2026-07-04 01:49:12', 'Hadir'), (191, 532, NULL, 'Duha', '2026-07-04', '08:49:00', '2026-07-04 01:49:28', '2026-07-04 01:49:28', 'Hadir'), (192, 531, NULL, 'Duha', '2026-07-04', '08:49:00', '2026-07-04 01:49:35', '2026-07-04 01:49:35', 'Hadir'), (193, 521, NULL, 'Dzuhur', '2026-07-04', '12:17:00', '2026-07-04 05:17:49', '2026-07-04 05:17:49', 'Hadir'), (194, 522, NULL, 'Dzuhur', '2026-07-04', '12:17:00', '2026-07-04 05:17:56', '2026-07-04 05:17:56', 'Hadir'), (195, 523, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:02', '2026-07-04 05:23:02', 'Hadir'), (196, 524, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:07', '2026-07-04 05:23:07', 'Hadir'), (197, 525, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:10', '2026-07-04 05:23:10', 'Hadir'), (198, 526, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:14', '2026-07-04 05:23:14', 'Hadir'), (199, 527, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:18', '2026-07-04 05:23:18', 'Hadir'), (200, 528, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:21', '2026-07-04 05:23:21', 'Hadir'), (201, 529, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:26', '2026-07-04 05:23:26', 'Hadir'), (202, 530, NULL, 'Dzuhur', '2026-07-04', '12:23:00', '2026-07-04 05:23:30', '2026-07-04 05:23:30', 'Hadir'), (203, 533, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:31', '2026-07-04 05:24:31', 'Hadir'), (204, 535, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:37', '2026-07-04 05:24:37', 'Hadir'), (205, 534, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:40', '2026-07-04 05:24:40', 'Hadir'), (206, 539, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:44', '2026-07-04 05:24:44', 'Hadir'), (207, 540, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:48', '2026-07-04 05:24:48', 'Hadir'), (208, 538, NULL, 'Dzuhur', '2026-07-04', '12:24:00', '2026-07-04 05:24:54', '2026-07-04 05:24:54', 'Hadir'), (209, 537, NULL, 'Dzuhur', '2026-07-04', '12:31:00', '2026-07-04 05:31:23', '2026-07-04 05:31:23', 'Hadir'), (210, 536, NULL, 'Dzuhur', '2026-07-04', '12:32:00', '2026-07-04 05:32:02', '2026-07-04 05:32:02', 'Hadir'), (211, NULL, 56, 'Pulang', '2026-07-04', '15:33:00', '2026-07-04 08:33:49', '2026-07-04 08:33:49', 'Hadir'), (212, NULL, 57, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:05', '2026-07-04 08:34:05', 'Hadir'), (213, NULL, 58, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:13', '2026-07-04 08:34:13', 'Hadir'), (214, NULL, 59, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:18', '2026-07-04 08:34:18', 'Hadir'), (215, NULL, 60, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:23', '2026-07-04 08:34:23', 'Hadir'), (216, NULL, 61, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:29', '2026-07-04 08:34:29', 'Hadir'), (217, NULL, 62, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:38', '2026-07-04 08:34:38', 'Hadir'), (218, NULL, 63, 'Pulang', '2026-07-04', '15:34:00', '2026-07-04 08:34:46', '2026-07-04 08:34:46', 'Hadir'), (220, NULL, 56, 'Masuk', '2026-07-06', '06:26:00', '2026-07-05 23:26:23', '2026-07-05 23:26:23', 'Hadir'), (221, 521, NULL, 'Upacara', '2026-07-06', '06:26:00', '2026-07-05 23:26:29', '2026-07-05 23:26:29', 'Hadir'), (222, 522, NULL, 'Upacara', '2026-07-06', '09:04:00', '2026-07-06 02:04:34', '2026-07-06 02:04:34', 'Hadir'), (223, 523, NULL, 'Upacara', '2026-07-06', '09:05:00', '2026-07-06 02:05:10', '2026-07-06 02:05:10', 'Hadir'), (224, NULL, 58, 'Masuk', '2026-07-06', '11:50:00', '2026-07-06 04:50:16', '2026-07-06 04:50:16', 'Hadir'), (225, 532, NULL, 'Upacara', '2026-07-06', '11:50:00', '2026-07-06 04:50:28', '2026-07-06 04:50:28', 'Hadir'), (226, 522, NULL, 'Duha', '2026-07-07', '11:19:00', '2026-07-07 04:19:13', '2026-07-07 04:19:13', 'Hadir'), (227, 523, NULL, 'Duha', '2026-07-07', '11:19:00', '2026-07-07 04:19:27', '2026-07-07 04:19:27', 'Hadir'), (228, 521, NULL, 'Duha', '2026-07-07', '11:20:00', '2026-07-07 04:20:01', '2026-07-07 04:20:01', 'Hadir'), (229, 524, NULL, 'Duha', '2026-07-07', '11:20:00', '2026-07-07 04:20:32', '2026-07-07 04:20:32', 'Sakit'), (230, 524, NULL, 'Dzuhur', '2026-07-07', '11:20:00', '2026-07-07 04:20:32', '2026-07-07 04:20:32', 'Sakit'), (231, NULL, 83, 'Masuk', '2026-07-07', '11:20:00', '2026-07-07 04:20:48', '2026-07-07 04:20:48', 'Izin'), (232, NULL, 83, 'Pulang', '2026-07-07', '11:20:00', '2026-07-07 04:20:48', '2026-07-07 04:20:48', 'Izin'), (233, 525, NULL, 'Duha', '2026-07-07', '11:21:00', '2026-07-07 04:21:39', '2026-07-07 04:21:39', 'Haid'), (234, NULL, 56, 'Masuk', '2026-07-07', '11:33:00', '2026-07-07 04:33:07', '2026-07-07 04:33:07', 'Hadir'), (235, NULL, 59, 'Masuk', '2026-07-07', '11:33:00', '2026-07-07 04:33:13', '2026-07-07 04:33:13', 'Hadir'), (236, NULL, 57, 'Masuk', '2026-07-07', '11:33:00', '2026-07-07 04:33:18', '2026-07-07 04:33:18', 'Hadir'), (237, NULL, 60, 'Masuk', '2026-07-07', '11:33:00', '2026-07-07 04:33:23', '2026-07-07 04:33:23', 'Hadir'), (238, NULL, 82, 'Masuk', '2026-07-07', '11:33:00', '2026-07-07 04:33:40', '2026-07-07 04:33:40', 'Sakit'), (239, NULL, 82, 'Pulang', '2026-07-07', '11:33:00', '2026-07-07 04:33:40', '2026-07-07 04:33:40', 'Sakit'), (240, 526, NULL, 'Duha', '2026-07-07', '11:34:00', '2026-07-07 04:34:09', '2026-07-07 04:34:09', 'Hadir'), (241, 527, NULL, 'Duha', '2026-07-07', '11:34:00', '2026-07-07 04:34:15', '2026-07-07 04:34:15', 'Hadir'), (242, 528, NULL, 'Duha', '2026-07-07', '11:34:00', '2026-07-07 04:34:19', '2026-07-07 04:34:19', 'Hadir'), (243, 529, NULL, 'Duha', '2026-07-07', '11:34:00', '2026-07-07 04:34:43', '2026-07-07 04:34:43', 'Izin'), (244, 529, NULL, 'Dzuhur', '2026-07-07', '11:34:00', '2026-07-07 04:34:43', '2026-07-07 04:34:43', 'Izin'), (245, 530, NULL, 'Duha', '2026-07-07', '11:34:00', '2026-07-07 04:34:53', '2026-07-07 04:34:53', 'Sakit'), (246, 530, NULL, 'Dzuhur', '2026-07-07', '11:34:00', '2026-07-07 04:34:53', '2026-07-07 04:34:53', 'Sakit'), (247, 532, NULL, 'Duha', '2026-07-07', '11:35:00', '2026-07-07 04:35:10', '2026-07-07 04:35:10', 'Haid'), (248, 531, NULL, 'Duha', '2026-07-07', '11:35:00', '2026-07-07 04:35:46', '2026-07-07 04:35:46', 'Hadir'), (249, 533, NULL, 'Duha', '2026-07-07', '11:35:00', '2026-07-07 04:35:55', '2026-07-07 04:35:55', 'Hadir'), (250, 534, NULL, 'Duha', '2026-07-07', '11:35:00', '2026-07-07 04:35:58', '2026-07-07 04:35:58', 'Hadir'), (251, 535, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:02', '2026-07-07 04:36:02', 'Hadir'), (252, 536, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:06', '2026-07-07 04:36:06', 'Hadir'), (253, 537, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:10', '2026-07-07 04:36:10', 'Hadir'), (254, 538, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:16', '2026-07-07 04:36:16', 'Hadir'), (255, 539, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:19', '2026-07-07 04:36:19', 'Hadir'), (256, 540, NULL, 'Duha', '2026-07-07', '11:36:00', '2026-07-07 04:36:23', '2026-07-07 04:36:23', 'Hadir'), (257, 521, NULL, 'Dzuhur', '2026-07-07', '12:13:00', '2026-07-07 05:13:07', '2026-07-07 05:13:07', 'Hadir'), (258, 522, NULL, 'Dzuhur', '2026-07-07', '12:13:00', '2026-07-07 05:13:19', '2026-07-07 05:13:19', 'Hadir'), (259, 523, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:15', '2026-07-07 05:54:15', 'Hadir'), (260, 526, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:19', '2026-07-07 05:54:19', 'Hadir'), (261, 527, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:23', '2026-07-07 05:54:23', 'Hadir'), (262, 528, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:27', '2026-07-07 05:54:27', 'Hadir'), (263, 531, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:39', '2026-07-07 05:54:39', 'Hadir'), (264, 533, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:42', '2026-07-07 05:54:42', 'Hadir'), (265, 534, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:45', '2026-07-07 05:54:45', 'Hadir'), (266, 535, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:48', '2026-07-07 05:54:48', 'Hadir'), (267, 536, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:52', '2026-07-07 05:54:52', 'Hadir'), (268, 537, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:55', '2026-07-07 05:54:55', 'Hadir'), (269, 538, NULL, 'Dzuhur', '2026-07-07', '12:54:00', '2026-07-07 05:54:58', '2026-07-07 05:54:58', 'Hadir'), (270, 539, NULL, 'Dzuhur', '2026-07-07', '12:55:00', '2026-07-07 05:55:02', '2026-07-07 05:55:02', 'Hadir'), (271, 540, NULL, 'Dzuhur', '2026-07-07', '12:55:00', '2026-07-07 05:55:05', '2026-07-07 05:55:05', 'Hadir'), (272, 525, NULL, 'Dzuhur', '2026-07-07', '12:55:00', '2026-07-07 05:55:43', '2026-07-07 05:55:43', 'Haid'), (273, 532, NULL, 'Dzuhur', '2026-07-07', '12:56:00', '2026-07-07 05:56:00', '2026-07-07 05:56:00', 'Haid'), (274, 523, NULL, 'Duha', '2026-07-08', '11:23:00', '2026-07-08 04:23:19', '2026-07-08 04:23:19', 'Izin'), (275, 523, NULL, 'Dzuhur', '2026-07-08', '11:23:00', '2026-07-08 04:23:19', '2026-07-08 04:23:19', 'Izin'), (276, 611, NULL, 'Duha', '2026-07-08', '11:23:00', '2026-07-08 04:23:29', '2026-07-08 04:23:29', 'Sakit'), (277, 611, NULL, 'Dzuhur', '2026-07-08', '11:23:00', '2026-07-08 04:23:29', '2026-07-08 04:23:29', 'Sakit'), (278, 526, NULL, 'Duha', '2026-07-08', '11:23:00', '2026-07-08 04:23:54', '2026-07-08 04:23:54', 'Sakit'), (279, 526, NULL, 'Dzuhur', '2026-07-08', '11:23:00', '2026-07-08 04:23:54', '2026-07-08 04:23:54', 'Sakit'), (280, 532, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:02', '2026-07-08 04:24:02', 'Hadir'), (281, 521, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:11', '2026-07-08 04:24:11', 'Hadir'), (282, 527, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:22', '2026-07-08 04:24:22', 'Hadir'), (283, 528, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:26', '2026-07-08 04:24:26', 'Hadir'), (284, 529, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:35', '2026-07-08 04:24:35', 'Hadir'), (285, 530, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:39', '2026-07-08 04:24:39', 'Hadir'), (286, 534, NULL, 'Duha', '2026-07-08', '11:24:00', '2026-07-08 04:24:48', '2026-07-08 04:24:48', 'Hadir'), (287, 537, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:07', '2026-07-08 04:25:07', 'Hadir'), (288, 538, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:12', '2026-07-08 04:25:12', 'Hadir'), (289, 539, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:19', '2026-07-08 04:25:19', 'Hadir'), (290, 540, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:24', '2026-07-08 04:25:24', 'Hadir'), (291, 522, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:28', '2026-07-08 04:25:28', 'Hadir'), (292, 524, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:32', '2026-07-08 04:25:32', 'Hadir'), (293, 525, NULL, 'Duha', '2026-07-08', '11:25:00', '2026-07-08 04:25:52', '2026-07-08 04:25:52', 'Haid'), (294, 536, NULL, 'Duha', '2026-07-08', '11:26:00', '2026-07-08 04:26:15', '2026-07-08 04:26:15', 'Haid'), (295, 521, NULL, 'Upacara', '2026-07-13', '06:29:00', '2026-07-12 23:29:30', '2026-07-12 23:29:30', 'Sakit'), (296, 521, NULL, 'Dzuhur', '2026-07-13', '06:29:00', '2026-07-12 23:29:30', '2026-07-12 23:29:30', 'Sakit'), (297, 524, NULL, 'Upacara', '2026-07-13', '06:51:00', '2026-07-12 23:51:48', '2026-07-12 23:51:48', 'Izin'), (298, 524, NULL, 'Dzuhur', '2026-07-13', '06:51:00', '2026-07-12 23:51:48', '2026-07-12 23:51:48', 'Izin'), (299, 525, NULL, 'Upacara', '2026-07-13', '07:12:00', '2026-07-13 00:12:26', '2026-07-13 00:12:26', 'Hadir'), (300, 529, NULL, 'Upacara', '2026-07-13', '07:29:00', '2026-07-13 00:29:26', '2026-07-13 00:29:26', 'Hadir'), (301, 536, NULL, 'Upacara', '2026-07-13', '07:31:00', '2026-07-13 00:31:40', '2026-07-13 00:31:40', 'Hadir'), (302, 533, NULL, 'Upacara', '2026-07-13', '07:31:00', '2026-07-13 00:31:48', '2026-07-13 00:31:48', 'Hadir'), (303, 531, NULL, 'Upacara', '2026-07-13', '07:31:00', '2026-07-13 00:31:52', '2026-07-13 00:31:52', 'Hadir'), (304, 532, NULL, 'Upacara', '2026-07-13', '07:31:00', '2026-07-13 00:31:58', '2026-07-13 00:31:58', 'Hadir'), (305, 523, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:06', '2026-07-13 00:32:06', 'Hadir'), (306, 526, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:10', '2026-07-13 00:32:10', 'Hadir'), (307, 527, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:14', '2026-07-13 00:32:14', 'Hadir'), (308, 528, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:18', '2026-07-13 00:32:18', 'Hadir'), (309, 530, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:27', '2026-07-13 00:32:27', 'Hadir'), (310, 535, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:32', '2026-07-13 00:32:32', 'Hadir'), (311, 534, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:36', '2026-07-13 00:32:36', 'Hadir'), (312, 537, NULL, 'Upacara', '2026-07-13', '07:32:00', '2026-07-13 00:32:41', '2026-07-13 00:32:41', 'Hadir'), (313, 538, NULL, 'Upacara', '2026-07-13', '07:33:00', '2026-07-13 00:33:52', '2026-07-13 00:33:52', 'Hadir'), (314, 539, NULL, 'Upacara', '2026-07-13', '07:33:00', '2026-07-13 00:33:56', '2026-07-13 00:33:56', 'Hadir'), (315, 540, NULL, 'Upacara', '2026-07-13', '07:34:00', '2026-07-13 00:34:01', '2026-07-13 00:34:01', 'Hadir'); -- Dumping structure for table db_absensi_muttaqin.absen_manuals CREATE TABLE IF NOT EXISTS `absen_manuals` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `siswa_id` bigint unsigned NOT NULL, `tanggal` date NOT NULL, `status_kehadiran` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `absen_manuals_siswa_id_foreign` (`siswa_id`), CONSTRAINT `absen_manuals_siswa_id_foreign` FOREIGN KEY (`siswa_id`) REFERENCES `siswas` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.absen_manuals: ~28 rows (approximately) INSERT INTO `absen_manuals` (`id`, `siswa_id`, `tanggal`, `status_kehadiran`, `created_at`, `updated_at`) VALUES (49, 523, '2026-07-04', 'Sakit', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (50, 525, '2026-07-04', 'Alfa', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (51, 529, '2026-07-04', 'Alfa', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (52, 534, '2026-07-04', 'Izin', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (53, 539, '2026-07-04', 'Izin', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (54, 540, '2026-07-04', 'Alfa', '2026-07-04 08:36:10', '2026-07-04 08:36:10'), (55, 545, '2026-07-04', 'Sakit', '2026-07-04 08:36:46', '2026-07-04 08:36:46'), (56, 558, '2026-07-04', 'Alfa', '2026-07-04 08:36:46', '2026-07-04 08:36:46'), (57, 582, '2026-07-04', 'Alfa', '2026-07-04 08:36:58', '2026-07-04 08:36:58'), (58, 583, '2026-07-04', 'Sakit', '2026-07-04 08:36:58', '2026-07-04 08:36:58'), (59, 585, '2026-07-04', 'Izin', '2026-07-04 08:36:58', '2026-07-04 08:36:58'), (60, 586, '2026-07-04', 'Sakit', '2026-07-04 08:37:04', '2026-07-04 08:37:04'), (61, 610, '2026-07-04', 'Alfa', '2026-07-04 08:37:13', '2026-07-04 08:37:13'), (62, 617, '2026-07-04', 'Alfa', '2026-07-04 08:37:13', '2026-07-04 08:37:13'), (63, 623, '2026-07-04', 'Izin', '2026-07-04 08:37:13', '2026-07-04 08:37:13'), (64, 628, '2026-07-04', 'Sakit', '2026-07-04 08:37:13', '2026-07-04 08:37:13'), (65, 634, '2026-07-04', 'Sakit', '2026-07-04 08:37:25', '2026-07-04 08:37:25'), (66, 652, '2026-07-04', 'Sakit', '2026-07-04 08:37:25', '2026-07-04 08:37:25'), (67, 656, '2026-07-04', 'Alfa', '2026-07-04 08:37:25', '2026-07-04 08:37:25'), (68, 673, '2026-07-04', 'Sakit', '2026-07-04 08:37:36', '2026-07-04 08:37:36'), (69, 679, '2026-07-04', 'Sakit', '2026-07-04 08:37:36', '2026-07-04 08:37:36'), (70, 692, '2026-07-04', 'Izin', '2026-07-04 08:37:47', '2026-07-04 08:37:47'), (71, 700, '2026-07-04', 'Alfa', '2026-07-04 08:37:47', '2026-07-04 08:37:47'), (72, 703, '2026-07-04', 'Alfa', '2026-07-04 08:37:47', '2026-07-04 08:37:47'), (73, 522, '2026-07-06', 'Izin', '2026-07-05 23:28:53', '2026-07-05 23:28:53'), (74, 527, '2026-07-06', 'Alfa', '2026-07-05 23:28:54', '2026-07-05 23:28:54'), (75, 532, '2026-07-06', 'Izin', '2026-07-05 23:28:54', '2026-07-05 23:28:54'), (76, 537, '2026-07-06', 'Alfa', '2026-07-05 23:28:54', '2026-07-05 23:28:54'), (77, 521, '2026-07-13', 'Sakit', '2026-07-13 00:13:45', '2026-07-13 00:13:45'), (78, 524, '2026-07-13', 'Izin', '2026-07-13 00:13:45', '2026-07-13 00:13:45'), (79, 538, '2026-07-13', 'Izin', '2026-07-13 00:13:45', '2026-07-13 00:13:45'), (80, 540, '2026-07-13', 'Alfa', '2026-07-13 00:13:45', '2026-07-13 00:13:45'); -- Dumping structure for table db_absensi_muttaqin.cache CREATE TABLE IF NOT EXISTS `cache` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.cache: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.cache_locks CREATE TABLE IF NOT EXISTS `cache_locks` ( `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `expiration` bigint NOT NULL, PRIMARY KEY (`key`), KEY `cache_locks_expiration_index` (`expiration`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.cache_locks: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.evaluasi_kehadirans CREATE TABLE IF NOT EXISTS `evaluasi_kehadirans` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tipe` enum('siswa','guru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'siswa', `siswa_id` bigint unsigned DEFAULT NULL, `guru_id` bigint unsigned DEFAULT NULL, `tahun` smallint unsigned NOT NULL, `bulan` tinyint unsigned NOT NULL, `minggu_ke` tinyint unsigned NOT NULL, `status` enum('belum','sudah') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'belum', `catatan` text COLLATE utf8mb4_unicode_ci, `dievaluasi_oleh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `tanggal_evaluasi` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `evaluasi_unik_per_minggu` (`tipe`,`siswa_id`,`guru_id`,`tahun`,`bulan`,`minggu_ke`), KEY `evaluasi_kehadirans_siswa_id_foreign` (`siswa_id`), KEY `evaluasi_kehadirans_guru_id_foreign` (`guru_id`), CONSTRAINT `evaluasi_kehadirans_guru_id_foreign` FOREIGN KEY (`guru_id`) REFERENCES `gurus` (`id`) ON DELETE SET NULL, CONSTRAINT `evaluasi_kehadirans_siswa_id_foreign` FOREIGN KEY (`siswa_id`) REFERENCES `siswas` (`id`) ON DELETE SET NULL ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.evaluasi_kehadirans: ~0 rows (approximately) INSERT INTO `evaluasi_kehadirans` (`id`, `tipe`, `siswa_id`, `guru_id`, `tahun`, `bulan`, `minggu_ke`, `status`, `catatan`, `dievaluasi_oleh`, `tanggal_evaluasi`, `created_at`, `updated_at`) VALUES (1, 'siswa', 521, NULL, 2026, 7, 1, 'sudah', 'sudah di panggila', 'Akmal Khalid', '2026-07-08 05:19:34', '2026-07-08 05:19:33', '2026-07-08 05:19:34'); -- Dumping structure for table db_absensi_muttaqin.failed_jobs CREATE TABLE IF NOT EXISTS `failed_jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.failed_jobs: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.gurus CREATE TABLE IF NOT EXISTS `gurus` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint unsigned NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jenis_identitas` enum('NIP','NUPTK','NRG','NPK','PegID','NIK') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NIP', `nomor_identitas` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `qr_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `jenis_kelamin` enum('L','P') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `gurus_nomor_identitas_unique` (`nomor_identitas`), KEY `gurus_user_id_foreign` (`user_id`), CONSTRAINT `gurus_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.gurus: ~30 rows (approximately) INSERT INTO `gurus` (`id`, `user_id`, `nama`, `jenis_identitas`, `nomor_identitas`, `qr_code`, `jenis_kelamin`, `created_at`, `updated_at`) VALUES (56, 60, 'Drs. H. Gaosul Adom, M.M.Pd.', 'NIP', '196607172007011029', 'MTs-Guru-196607172007011029', 'L', '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (57, 61, 'ABDUL HOLIK, S.Ag.M.Pd.', 'NIP', '196901112007011020', 'MTs-Guru-196901112007011020', 'L', '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (58, 62, 'ADE SAEPUL HIDAYAT, S.Pd.', 'NIP', '197005122007011042', 'MTs-Guru-197005122007011042', 'L', '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (59, 63, 'DEDEN SUADININGRAT, S.Ag.M.Pd.', 'NIP', '196903022007101001', 'MTs-Guru-196903022007101001', 'L', '2026-06-26 14:33:50', '2026-06-26 14:33:50'), (60, 64, 'MUMU,S.Ag', 'NIP', '197104172007101002', 'MTs-Guru-197104172007101002', 'P', '2026-06-26 14:33:50', '2026-06-26 14:33:50'), (61, 65, 'Hj. RATNA WULAN, S.Ag.', 'NIP', '197007232007102001', 'MTs-Guru-197007232007102001', 'P', '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (62, 66, 'ANI MULYANI, S.Pd.', 'NPK', '8790650176060', 'MTs-Guru-8790650176060', 'P', '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (63, 67, 'APIT INAYATILLAH, S.Pd.I', 'NPK', '4793300049032', 'MTs-Guru-4793300049032', 'P', '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (64, 68, 'DEDE RAHMAWATI, S.Pd.I', 'NPK', '6842460054004', 'MTs-Guru-6842460054004', 'P', '2026-06-26 14:33:52', '2026-06-26 14:33:52'), (65, 69, 'DELVIA MEGA SARI, S.Pd.I', 'NPK', '6820630085082', 'MTs-Guru-6820630085082', 'P', '2026-06-26 14:33:52', '2026-06-26 14:33:52'), (67, 71, 'INDA FAUZI RAHAYU, S.Pd.', 'NPK', '8802600117056', 'MTs-Guru-8802600117056', 'P', '2026-06-26 14:33:53', '2026-06-26 14:33:53'), (68, 72, 'NANDANG FARID, S.Pd.', 'NPK', '7800690067020', 'MTs-Guru-7800690067020', 'L', '2026-06-26 14:33:53', '2026-06-26 14:33:53'), (69, 73, 'RURI NURUL AISYAH, S.Pd.', 'NPK', '8861050105068', 'MTs-Guru-8861050105068', 'P', '2026-06-26 14:33:54', '2026-06-26 14:33:54'), (70, 74, 'SANTI KAMILAH, S.Pd.', 'NPK', '0790160054084', 'MTs-Guru-0790160054084', 'P', '2026-06-26 14:33:54', '2026-06-26 14:33:54'), (71, 75, 'H. MIMIH SAEPUL MILLAH, S.Pd.I', 'NPK', '5724530000013', 'MTs-Guru-5724530000013', 'L', '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (72, 76, 'RIDWAN ILYAS, S.Pd.I', 'NPK', '3841250064029', 'MTs-Guru-3841250064029', 'L', '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (73, 77, 'Dra. KARYATI', 'NPK', '4680360236039', 'MTs-Guru-4680360236039', 'P', '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (74, 78, 'RIMA SRI CAHYANI, S.Pd.', 'NPK', '0882010211079', 'MTs-Guru-0882010211079', 'P', '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (75, 79, 'PUPUNG PURWANTI KARTINI, S.Pd.', 'NPK', '0887000150069', 'MTs-Guru-0887000150069', 'P', '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (76, 80, 'ITA ROSITA', 'PegID', '20237736187001', 'MTs-Guru-20237736187001', 'P', '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (77, 81, 'HENDRIK RUSWANDI SAPUTRA', 'PegID', '20237736190002', 'MTs-Guru-20237736190002', 'L', '2026-06-26 14:33:57', '2026-06-26 14:33:57'), (78, 82, 'DESI NURARIANIE', 'PegID', '20237736195003', 'MTs-Guru-20237736195003', 'P', '2026-06-26 14:33:57', '2026-06-26 14:33:57'), (79, 83, 'AI FITRI SOPYANTI, S.Pd.', 'PegID', '20237736189002', 'MTs-Guru-20237736189002', 'P', '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (80, 84, 'MIMAH NURAISAH, S.Pd.', 'PegID', '20237736100002', 'MTs-Guru-20237736100002', 'P', '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (81, 85, 'ASEP KHOTIB MUWAHID, M.Pd.', 'PegID', '20237736100001', 'MTs-Guru-20237736100001', 'L', '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (82, 86, 'SINAR KHOTIMATUL HUSNA,S.Pd.', 'PegID', '20237736101001', 'MTs-Guru-20237736101001', 'P', '2026-06-26 14:33:59', '2026-06-26 14:33:59'), (83, 87, 'WANDI FIRMAN SUPRIANTO PUTRA, S.Pd.', 'PegID', '20237736102001', 'MTs-Guru-20237736102001', 'L', '2026-06-26 14:33:59', '2026-06-26 14:33:59'), (84, 88, 'NADA SULISTIANISA', 'PegID', '20237736103001', 'MTs-Guru-20237736103001', 'P', '2026-06-26 14:34:00', '2026-06-26 14:34:00'), (85, 89, 'CUCU,S.Pd.', 'PegID', '20214056197005', 'MTs-Guru-20214056197005', 'P', '2026-06-26 14:34:00', '2026-06-26 14:34:00'), (91, 99, 'H. II SIROJUL ARIFIN, S.Pd., M.Pd.', 'NIP', '3752110019037', 'GURU-3752110019037', 'L', '2026-07-13 00:17:19', '2026-07-13 00:17:19'); -- Dumping structure for table db_absensi_muttaqin.hari_liburs CREATE TABLE IF NOT EXISTS `hari_liburs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `tanggal_mulai` date NOT NULL, `tanggal_selesai` date DEFAULT NULL, `keterangan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `tipe` enum('nasional','semester','agenda_sekolah') COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.hari_liburs: ~23 rows (approximately) INSERT INTO `hari_liburs` (`id`, `tanggal_mulai`, `tanggal_selesai`, `keterangan`, `tipe`, `created_at`, `updated_at`) VALUES (1, '2026-01-01', '2026-01-01', 'Tahun Baru 2026 Masehi', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:18:37'), (2, '2026-04-03', '2026-04-03', 'Wafat Yesus Kristus (Jumat Agung)', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:23:50'), (3, '2026-04-05', '2026-04-05', 'Hari Paskah', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:23:26'), (4, '2026-05-01', '2026-05-01', 'Hari Buruh', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:32:29'), (5, '2026-05-14', '2026-05-14', 'Kenaikan Yesus Kristus', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:22:49'), (6, '2026-06-01', '2026-06-01', 'Hari Lahir Pancasila', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:21:47'), (7, '2026-08-17', '2026-08-17', 'Hari Kemerdekaan Republik Indonesia', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:18:52'), (8, '2026-12-25', '2026-12-25', 'Hari Raya Natal', 'nasional', '2026-04-22 02:23:15', '2026-05-01 01:16:08'), (9, '2026-01-16', '2026-01-16', 'Isra Mikraj Nabi Muhammad SAW', 'nasional', '2026-04-22 02:38:36', '2026-05-01 01:25:46'), (10, '2026-02-17', '2026-02-17', 'Tahun Baru Imlek 2577 Kongzili', 'nasional', '2026-04-22 02:38:36', '2026-05-01 01:26:06'), (11, '2026-03-19', '2026-03-19', 'Hari Suci Nyepi (Tahun Baru Saka 1948)', 'nasional', '2026-04-22 02:38:36', '2026-05-01 01:26:24'), (12, '2026-03-21', '2026-03-22', 'Hari Raya Idul Fitri 1447 H', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:24:58'), (18, '2026-05-31', '2026-05-31', 'Hari Raya Waisak 2570 BE', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:22:32'), (20, '2026-05-27', '2026-05-27', 'Hari Raya Idul Adha 1447 H', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:21:15'), (22, '2026-06-16', '2026-06-16', 'Tahun Baru Islam 1448 H', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:19:34'), (23, '2026-08-25', '2026-08-25', 'Maulid Nabi Muhammad SAW', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:20:43'), (24, '2026-12-24', '2026-12-24', 'Cuti Bersama Hari Raya Natal', 'nasional', '2026-04-22 02:38:37', '2026-05-01 01:17:23'), (29, '2026-03-20', '2026-03-24', 'Cuti Bersama Hari Raya Idul Fitri 1447 H', 'nasional', '2026-05-01 01:28:13', '2026-05-01 01:32:00'), (30, '2026-02-16', '2026-02-16', 'Cuti Bersama Tahun Baru Imlek 2577 Kongzil', 'nasional', '2026-05-01 01:29:42', '2026-05-01 01:29:42'), (31, '2026-05-15', '2026-05-15', 'Cuti Bersama Kenaikan Yesus Kristus', 'nasional', '2026-05-01 01:30:20', '2026-05-01 01:30:20'), (32, '2026-05-28', '2026-05-28', 'Cuti Bersama Hari Raya Idul Adha 1447 H', 'nasional', '2026-05-01 01:31:03', '2026-05-01 01:31:03'), (33, '2026-06-25', '2026-06-25', 'Sekolah Diliburkan Rapat guru', '', '2026-06-24 02:54:22', '2026-06-24 02:54:22'); -- Dumping structure for table db_absensi_muttaqin.jobs CREATE TABLE IF NOT EXISTS `jobs` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `attempts` tinyint unsigned NOT NULL, `reserved_at` int unsigned DEFAULT NULL, `available_at` int unsigned NOT NULL, `created_at` int unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.jobs: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.job_batches CREATE TABLE IF NOT EXISTS `job_batches` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `total_jobs` int NOT NULL, `pending_jobs` int NOT NULL, `failed_jobs` int NOT NULL, `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `options` mediumtext COLLATE utf8mb4_unicode_ci, `cancelled_at` int DEFAULT NULL, `created_at` int NOT NULL, `finished_at` int DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.job_batches: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.migrations CREATE TABLE IF NOT EXISTS `migrations` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.migrations: ~17 rows (approximately) INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '0001_01_01_000000_create_users_table', 1), (2, '0001_01_01_000001_create_cache_table', 1), (3, '0001_01_01_000002_create_jobs_table', 1), (4, '2026_04_20_233645_buat_tabel_absensi_lengkap', 1), (5, '2026_04_21_001946_add_role_to_users_table', 1), (6, '2026_04_21_021115_create_siswas_table', 2), (7, '2026_04_21_021205_create_absensis_table', 2), (8, '2026_04_21_031441_create_gurus_table', 3), (9, '2026_04_22_091001_create_hari_liburs_table', 4), (10, '2026_04_22_182318_ubah_nip_ke_nrg_di_tabel_gurus', 5), (11, '2026_04_22_182950_hapus_nrg_dari_tabel_gurus', 6), (12, '2026_04_22_193153_add_identity_and_gender_to_gurus_table', 7), (16, '2026_04_24_074558_fix_jenis_ibadah_column_in_absensis_table', 8), (17, '2026_04_29_184517_create_absensi_gurus_table', 8), (18, '2026_04_29_185412_add_qr_code_to_gurus_table', 8), (19, '2026_04_29_191755_drop_absensi_gurus_table', 8), (20, '2026_04_29_191913_update_absensis_table_for_general_use', 8), (21, '2026_06_17_114638_add_sumber_to_absensis_table', 9), (22, '2026_06_17_125028_create_absensi_harian_table', 10), (23, '2026_06_19_093725_create_absen_manuals_table', 11), (24, '2026_07_01_000000_ubah_role_petugas_ke_guru_di_tabel_users', 12), (25, '2026_07_07_115951_create_evaluasi_kehadirans_table', 13); -- Dumping structure for table db_absensi_muttaqin.password_reset_tokens CREATE TABLE IF NOT EXISTS `password_reset_tokens` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.password_reset_tokens: ~0 rows (approximately) -- Dumping structure for table db_absensi_muttaqin.sessions CREATE TABLE IF NOT EXISTS `sessions` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint unsigned DEFAULT NULL, `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_agent` text COLLATE utf8mb4_unicode_ci, `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`), KEY `sessions_user_id_index` (`user_id`), KEY `sessions_last_activity_index` (`last_activity`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.sessions: ~18 rows (approximately) INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('2NxKX8HOE9VeMbY5I1bJ1T5pMnRFsFcdNSsRDzWj', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJGUlVlTE5uclZTM1duS2VwUzVzcjlXbnQyQ0Z5aldGUHowcW9XdUFvIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776749318), ('9KGAISvUlOomGSArFcygOr8BErqeuqkDBrn8ACR6', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJpMFF1N3Vadm5pRlZZVGlzYzROdWlYSk5Fbm9IWmtUMXpRUDFUVXdEIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750821), ('DA0vQ5FTb5Nv2iAViLp8f2mrw5ZOo8P3gzhvgEao', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJ5djZLQWpnd2ZTVGt3dVd2OEVuNldkZW1PcjNHTmp1U2puTHNkQkhJIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cHM6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9', 1776749384), ('eIV8Ghl5Zweq74IU1jybaNQIH4qpxV0RwkmkRP9e', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJLemxlYW5YaVZBSGVQQ1hOeXlPNjQwNmRiNjhIRW9VUDI2SGpVNk00IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750240), ('eYh1asxvHpRLXfkqW2XlzfQaUNo6hNE8QRoBuiZI', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJQZjljVFJ1UHRVRmVSam5kQ3UzVzM2clluSDNsZFUwZ3NrY0o4RmVJIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750240), ('EYkojWTcazCmLXmwPgYUAMNlYAyfl2fzzuymlEe9', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJBVDl6dUVRQjNBVTl3SE1ZQTBTcDFLYVo1aW95SGJocU1UYm8zOERhIiwidXJsIjp7ImludGVuZGVkIjoiaHR0cHM6XC9cL2Fic2Vuc2lfbXV0dGFxaW5fdjIudGVzdFwvYWRtaW5cL3Npc3dhIn0sIl9wcmV2aW91cyI6eyJ1cmwiOiJodHRwczpcL1wvYWJzZW5zaV9tdXR0YXFpbl92Mi50ZXN0XC9hZG1pblwvc2lzd2EiLCJyb3V0ZSI6ImFkbWluLnNpc3dhLmluZGV4In0sIl9mbGFzaCI6eyJvbGQiOltdLCJuZXciOltdfX0=', 1781669216), ('fdQdFpAaivF5dAfyU8VNbXr3pqVodeBUKLAV8alY', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJYR21lVFZLRUZMbnFadHJCem9yVHNFV2x1M2Rsd1hvTFFCVXZkQWpBIiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776744953), ('Fgc4HoUJtYEPHheyhbXgDhgCWWAx4C9vJYotvW1E', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJac2l0NDR0VmcyRHFWM1hqTXJpVWFjbktNU1dzdzJQZ3JNVzE3MGU2IiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750834), ('g0mfZAY4ZI3d1BIxWWa98ji9mxqz8xWszMqCfPzt', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJ6MEx2SHNjc1JzdmdzQzNaS1ZZbkhJT0Q4NUFOdEtrUVViMWFmVWNqIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750764), ('GByJTTICRVH5eb9jAFu5m4d7VM5i6Bz1WI5CNION', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJFaVhNSWRab2w2NFVjZGVmMXVVbWpPdU1wN2s3dU93UGVhZlJ0TWh3IiwiX3ByZXZpb3VzIjp7InVybCI6Imh0dHA6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776745254), ('gRNgpXrHHXk6UBmO0fFLAtZZ8OxYUbwhXM5jkMm2', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiIzcWhITGo3QzV0MXEyeURRTkpyWjN5MUJEc2txeEJIbFRoQVVxYWcyIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750352), ('MQECJXomNihNeDIGLhuejG7luOgDeQ34tfokDxHr', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJIc2hZUHlubEJjanpJNEU0UXRucW9GWkJhMjJMbHQyYlRKV1E4S2loIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750717), ('n4DlMucKwIwR2Us6vIQX42PHgbfKQVXW2Z4OXGlI', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiI1S2RLWWFvNHVQc3pMQVJvVHNLanl1SlZxY1U4bnNjZkFqb2pOSWJsIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776745288), ('onjI8zPop5drA8H203FWstLtifGuSWoFxlJVDYjO', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJSeE1DTlpnRHFYN3BZSEZHSnpneEk4cWJhSlJXS3FBSHByN0NjbHZrIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119LCJfcHJldmlvdXMiOnsidXJsIjoiaHR0cHM6XC9cL2Fic2Vuc2lfbXV0dGFxaW4udGVzdCIsInJvdXRlIjoibG9naW4ifSwibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiOjF9', 1776749311), ('oPCdH82WyJMUrL3qBsN6da2sdHKQlxxUlsjRKecj', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJnME81cE1MU0RqMFp4SE5Hek53MlJLSkgwd2ZXeVV2b3R6cmtUM2JFIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750252), ('OquSIbKJPxHaOmQ5JAJSeukQHENmRtRmHtlbZ1V6', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJOWDhBREk4TXBqdHVnR0F4SDB5SmdhQkNFeUdOdFNsZno1b3dqQW40IiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776745002), ('sawQpTItDTFUcsOOpSb1sBzoFPHVwMwVNuoLatXA', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiIwR0NUM1RvejFIb2xOWWVQd3dVRGlsY2MwMjJYMTJJdmpxbWc1elhYIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776745166), ('Ufe1YDqC3UiZ8uNe9dZETUVUSD3YWEBQ6GOINt6D', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJYREltTDlJYU40blVteDRSb1VSZmlDV0V1bE9LYmgyRDk0OEdJeU00IiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750340), ('vfGEz8afWTolThpnm47AROkUMZgFdygZArznw3TC', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJteTFRZlJiQXBmVUlJa3VOTWQ4UGNVVzNWcGhMa3l3Wk5QUDRlazQwIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750333), ('XBCMnJURjL4oTH0yGAG0BJBs2edWohdGGVcg4bJw', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiI5dzlzd08yS3pzUTBNcENFUDNvek9Vb0tDUkdTWXpHSVlFb2VVa09UIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776748925), ('zMMNcst4YbdCzqqMQVz1CkWej5aK1IKqisqnE8Rb', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36', 'eyJfdG9rZW4iOiJDeW04dUxidEZCVElLbE5ETnNTZVNNRDhkTDl6T1BMV0VpdnR3MGNDIiwiX2ZsYXNoIjp7Im9sZCI6W10sIm5ldyI6W119fQ==', 1776750279); -- Dumping structure for table db_absensi_muttaqin.siswas CREATE TABLE IF NOT EXISTS `siswas` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `nisn` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kelas` enum('VII-A','VII-B','VII-C','VII-D','VIII-A','VIII-B','VIII-C','VIII-D','IX-A','IX-B','IX-C','IX-D','Lulus') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jenis_kelamin` enum('L','P') COLLATE utf8mb4_unicode_ci NOT NULL, `qr_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `siswas_nisn_unique` (`nisn`), UNIQUE KEY `siswas_qr_code_unique` (`qr_code`) ) ENGINE=InnoDB AUTO_INCREMENT=707 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.siswas: ~183 rows (approximately) INSERT INTO `siswas` (`id`, `nisn`, `nama`, `kelas`, `jenis_kelamin`, `qr_code`, `created_at`, `updated_at`) VALUES (521, '3129060317', 'ALIYA ANISA CIKAL', 'VIII-A', 'P', 'MTs-3129060317', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (522, '3123725136', 'ANAHATA RAMADHINA RHEVA', 'VIII-A', 'P', 'MTs-3123725136', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (523, '3137510827', 'BAYU YUDHISTIRA NINGRAT', 'VIII-A', 'L', 'MTs-3137510827', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (524, '3123797895', 'FIRMAN NURUL AZMI', 'VIII-A', 'L', 'MTs-3123797895', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (525, '3128783978', 'GISNI ALTAPUNISA', 'VIII-A', 'P', 'MTs-3128783978', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (526, '0115723786', 'HAFIZ MUHAMAD RIZKI', 'VIII-A', 'L', 'MTs-0115723786', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (527, '3124193424', 'HAIKAL PUTRA RAMADHAN', 'VIII-A', 'L', 'MTs-3124193424', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (528, '3127586928', 'HIKMAT HIDAYAT', 'VIII-A', 'L', 'MTs-3127586928', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (529, '3124925954', 'IRFAN', 'VIII-A', 'L', 'MTs-3124925954', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (530, '3128127528', 'MUHAMAD ADRIAN SCYAH', 'VIII-A', 'L', 'MTs-3128127528', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (531, '3124082212', 'MUHAMAD ARIYANSYAH GUMELAR', 'VIII-A', 'L', 'MTs-3124082212', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (532, '3111134629', 'NADYA ADHA NUR\'AENI', 'VIII-A', 'P', 'MTs-3111134629', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (533, '3119057876', 'REHAN RAMDHANI', 'VIII-A', 'L', 'MTs-3119057876', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (534, '3123267676', 'RENATA RAUDOTUN NISA', 'VIII-A', 'P', 'MTs-3123267676', '2026-07-02 22:53:54', '2026-07-13 00:10:45'), (535, '3122972170', 'RESTU MUHAMMAD MUBAROK', 'VIII-A', 'L', 'MTs-3122972170', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (536, '3124216911', 'SANTI NUR MARSELA', 'VIII-A', 'P', 'MTs-3124216911', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (537, '3121138146', 'SEPTIAN MAULANA NUGRAHA', 'VIII-A', 'L', 'MTs-3121138146', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (538, '3124942620', 'SITI AMINAH', 'VIII-A', 'P', 'MTs-3124942620', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (539, '0136283669', 'WIDA WIDIA', 'VIII-A', 'P', 'MTs-0136283669', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (540, '3129443231', 'YAZID VASA RAMDANI', 'VIII-A', 'L', 'MTs-3129443231', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (541, '0127170076', 'AHMAD JAWARI SA\'BANI', 'VIII-B', 'L', 'MTs-0127170076', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (542, '3127575610', 'AZRIL NURUL MUHAN', 'VIII-B', 'L', 'MTs-3127575610', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (543, '3125352101', 'DASTA MUHAMAD DIKRY', 'VIII-B', 'L', 'MTs-3125352101', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (544, '3125466380', 'FEBRI FAWAIJA FILHAJ', 'VIII-B', 'L', 'MTs-3125466380', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (545, '3112513770', 'HAFIZHA AZAHRA S', 'VIII-B', 'P', 'MTs-3112513770', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (546, '3128453150', 'IRSYAD AMANULLOH', 'VIII-B', 'L', 'MTs-3128453150', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (547, '0123947318', 'JAJANG NURJAMAN', 'VIII-B', 'L', 'MTs-0123947318', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (548, '0124138007', 'KRISNA DIPAYANA', 'VIII-B', 'L', 'MTs-0124138007', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (549, '0124337273', 'LIA ALIYAH', 'VIII-B', 'P', 'MTs-0124337273', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (550, '3122245759', 'MUHAEMIN AS\'ARI', 'VIII-B', 'L', 'MTs-3122245759', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (551, '3122525964', 'MUHAMAD FAUZI HAMZAH', 'VIII-B', 'L', 'MTs-3122525964', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (552, '3128974679', 'MUHAMAD ZIKRI MUBAROK', 'VIII-B', 'L', 'MTs-3128974679', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (553, '0117562973', 'MUHAMMAD AKHRAM FATIHUL IKHSAN', 'VIII-B', 'L', 'MTs-0117562973', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (554, '3123302419', 'MUHAMMAD FIKRY MUBARROK', 'VIII-B', 'L', 'MTs-3123302419', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (555, '3126374840', 'NISFA PRISKA NURZAHRA', 'VIII-B', 'P', 'MTs-3126374840', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (556, '0126356402', 'PANI APRILIANTI', 'VIII-B', 'P', 'MTs-0126356402', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (557, '3126310294', 'REISA SANIATUL APIPAH', 'VIII-B', 'P', 'MTs-3126310294', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (558, '3134201557', 'RIFALDI SEFTIANA MUKTI', 'VIII-B', 'L', 'MTs-3134201557', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (559, '3122969861', 'SINTA NUR MARSYA', 'VIII-B', 'P', 'MTs-3122969861', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (560, '3123122718', 'SYAKIRATUNIAIN SALSABILA', 'VIII-B', 'P', 'MTs-3123122718', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (561, '3124960116', 'ZAHRA ALIFATUNNISA', 'VIII-B', 'P', 'MTs-3124960116', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (562, '3122409768', 'ABDUL AZIZ', 'VIII-C', 'L', 'MTs-3122409768', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (563, '3126973693', 'AGIL RABBANI', 'VIII-C', 'L', 'MTs-3126973693', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (564, '3126537936', 'AL RESTU ADIKA PRATAMA', 'VIII-C', 'L', 'MTs-3126537936', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (565, '3124023489', 'ALBY FACHRY SEPTIAN RIZKY', 'VIII-C', 'L', 'MTs-3124023489', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (566, '0128466028', 'ANIIS MUTHMAINNAH', 'VIII-C', 'P', 'MTs-0128466028', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (567, '3120580726', 'BIMA RESTU WIJAYA', 'VIII-C', 'L', 'MTs-3120580726', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (568, '3128548051', 'CECEP KHOIRUL ISMI', 'VIII-C', 'L', 'MTs-3128548051', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (569, '3120063980', 'D ULFA NURHOLIFAH', 'VIII-C', 'P', 'MTs-3120063980', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (570, '3128869100', 'DAVI RESTU FADIL', 'VIII-C', 'L', 'MTs-3128869100', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (571, '0123609143', 'DILLA HASANATUL MUF\'IDAH', 'VIII-C', 'P', 'MTs-0123609143', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (572, '0137285940', 'HARLAN NURRIJKI SAPUTRA', 'VIII-C', 'L', 'MTs-0137285940', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (573, '0117055660', 'MUHAMAD SAHRUL ARYA PRATAMA', 'VIII-C', 'L', 'MTs-0117055660', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (574, '3127674977', 'MUHAMMAD HAIKAL', 'VIII-C', 'L', 'MTs-3127674977', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (575, '3122783331', 'NUGIE ILHAM RAMADHAN', 'VIII-C', 'L', 'MTs-3122783331', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (576, '0129621547', 'PITROTUL ALIYAH', 'VIII-C', 'P', 'MTs-0129621547', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (577, '3127503413', 'RENA MUZDALIPAH', 'VIII-C', 'P', 'MTs-3127503413', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (578, '3125182072', 'RISVA SOVIAH', 'VIII-C', 'P', 'MTs-3125182072', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (579, '3121867123', 'RISVI WILDA NINGSIH', 'VIII-C', 'P', 'MTs-3121867123', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (580, '3123261102', 'RIYAH KHAIRINNISA', 'VIII-C', 'P', 'MTs-3123261102', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (581, '3118924637', 'SAKTI MAULANA', 'VIII-C', 'L', 'MTs-3118924637', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (582, '3124007035', 'SARIF HIDAYATULLOH PERMANA SAPUTRA', 'VIII-C', 'L', 'MTs-3124007035', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (583, '3133654203', 'SITI LIM AWALIYAH', 'VIII-C', 'P', 'MTs-3133654203', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (584, '3121760802', 'SITI ROSMAWATI VARELINA APRILIA', 'VIII-C', 'P', 'MTs-3121760802', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (585, '3128389579', 'UDA NURHUDA', 'VIII-C', 'L', 'MTs-3128389579', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (586, '3124348346', 'AKBAR MURSYIDAN', 'VIII-D', 'L', 'MTs-3124348346', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (587, '3129993513', 'ALIFA FARHAH SANIYAH', 'VIII-D', 'P', 'MTs-3129993513', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (588, '3122363797', 'ALIYA LARASATI', 'VIII-D', 'P', 'MTs-3122363797', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (589, '0134094828', 'ALYA FADILA RAHMA', 'VIII-D', 'P', 'MTs-0134094828', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (590, '0136925322', 'AZHAR FALLAH ANDRIYANSAH', 'VIII-D', 'L', 'MTs-0136925322', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (591, '3104046972', 'DIMAS SUBAGJA', 'VIII-D', 'L', 'MTs-3104046972', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (592, '3125237378', 'DINA NURDIANI', 'VIII-D', 'P', 'MTs-3125237378', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (593, '0129692067', 'DINAR SASTRA MUKTI', 'VIII-D', 'L', 'MTs-0129692067', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (594, '3124838749', 'JALAL', 'VIII-D', 'L', 'MTs-3124838749', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (595, '0127998086', 'MAULANA APRIYADI', 'VIII-D', 'L', 'MTs-0127998086', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (596, '3121581163', 'MOCHAMAD AZMI JAELUDIN', 'VIII-D', 'L', 'MTs-3121581163', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (597, '0127457352', 'MUHAMAD HAFIZ ASSIDIQI', 'VIII-D', 'L', 'MTs-0127457352', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (598, '0122469410', 'MUHAMMAD IRGI FAHRIJI', 'VIII-D', 'L', 'MTs-0122469410', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (599, '3129976638', 'MUHAMMAD RIVA FAUZI DZULKARNAIN', 'VIII-D', 'L', 'MTs-3129976638', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (600, '3122741346', 'NISA TASNIYATUS SA\'BAN', 'VIII-D', 'P', 'MTs-3122741346', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (601, '3125566051', 'RAHMA DANI WINATA', 'VIII-D', 'P', 'MTs-3125566051', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (602, '3115440438', 'RAVA ADITIA', 'VIII-D', 'L', 'MTs-3115440438', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (603, '3116354147', 'RIPA SITI SOBARIAH', 'VIII-D', 'P', 'MTs-3116354147', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (604, '0122069411', 'SYIFA NURAZIZAH', 'VIII-D', 'P', 'MTs-0122069411', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (605, '0121911304', 'YOGI APRILLIANA', 'VIII-D', 'L', 'MTs-0121911304', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (606, '0136852828', 'ACEP AHMAD JAELANI', 'IX-A', 'L', 'MTs-0136852828', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (607, '3119491111', 'AGHNI NUR RAMADHANI', 'IX-A', 'P', 'MTs-3119491111', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (608, '0113790351', 'AGNI PATIMATUZ ZAHRA', 'IX-A', 'P', 'MTs-0113790351', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (609, '0111485086', 'AINI NUR SA\'BANI', 'IX-A', 'P', 'MTs-0111485086', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (610, '0119963399', 'ARDAN GIFARI GOZALI', 'IX-A', 'L', 'MTs-0119963399', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (611, '0000000003', 'AXELL EBRILLIO HARAPAN', 'IX-A', 'L', 'MTs-0000000003', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (612, '0117206150', 'DIGO KHOBILAH', 'IX-A', 'L', 'MTs-0117206150', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (613, '0111283655', 'FUTRI YASMIN INDAH KIRANA', 'IX-A', 'P', 'MTs-0111283655', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (614, '3105111343', 'HERPA APRIANA', 'IX-A', 'P', 'MTs-3105111343', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (615, '0112154552', 'IHSAM SYABANI', 'IX-A', 'L', 'MTs-0112154552', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (616, '0085250239', 'LUTFIE', 'IX-A', 'L', 'MTs-0085250239', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (617, '0128847942', 'MILKI LAULIA RAHIM', 'IX-A', 'L', 'MTs-0128847942', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (618, '0115318824', 'MOH FACHRIE WINDRIYANA SAPUTRA', 'IX-A', 'L', 'MTs-0115318824', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (619, '0119700009', 'MULYASARI', 'IX-A', 'P', 'MTs-0119700009', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (620, '0122815723', 'N. SYIFA NURSYAMSYAH', 'IX-A', 'P', 'MTs-0122815723', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (621, '0113106567', 'NIDA MARWAH ULFAH', 'IX-A', 'P', 'MTs-0113106567', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (622, '3116771815', 'RAI FADILLAH SOPWATILLAH', 'IX-A', 'P', 'MTs-3116771815', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (623, '0119944525', 'RAISA HENDRIANI', 'IX-A', 'P', 'MTs-0119944525', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (624, '3128941204', 'RICHEL JANUAR', 'IX-A', 'L', 'MTs-3128941204', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (625, '2425070570', 'RIZKY SEBASTIAN ARYA PRATAMA', 'IX-A', 'L', 'MTs-2425070570', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (626, '0117536140', 'SALMAN ALFARIZI', 'IX-A', 'L', 'MTs-0117536140', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (627, '0118952029', 'SASKIYA EL RAHMA', 'IX-A', 'P', 'MTs-0118952029', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (628, '0128036491', 'SITI NAZWA NURPADILAH', 'IX-A', 'P', 'MTs-0128036491', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (629, '0114912818', 'TANTRI AGNI LESTARI', 'IX-A', 'P', 'MTs-0114912818', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (630, '0114549458', 'AI PADILAH', 'IX-B', 'P', 'MTs-0114549458', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (631, '3115639122', 'AMI RATULSAH', 'IX-B', 'P', 'MTs-3115639122', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (632, '0118590664', 'ANISA NURUL FITRI', 'IX-B', 'P', 'MTs-0118590664', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (633, '0128422279', 'DEVI AMARA', 'IX-B', 'P', 'MTs-0128422279', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (634, '3110691334', 'DIMAS MAHARDIKA', 'IX-B', 'L', 'MTs-3110691334', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (635, '0119789098', 'HANI RAHMAHDANI', 'IX-B', 'P', 'MTs-0119789098', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (636, '3107548000', 'MUHAMAD ARYANA', 'IX-B', 'L', 'MTs-3107548000', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (637, '0000000040', 'MUHAMAD ILHAM DARAZAT', 'IX-B', 'L', 'MTs-0000000040', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (638, '0117155553', 'MUHAMAD IRWAN', 'IX-B', 'L', 'MTs-0117155553', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (639, '0128538297', 'MUHAMAD QURTUBI YALA ATUSTURI', 'IX-B', 'L', 'MTs-0128538297', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (640, '3111403929', 'MUHAMAD ZAENA RUSLI', 'IX-B', 'L', 'MTs-3111403929', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (641, '0121023323', 'MUHAMMAD REFI FADILLAH', 'IX-B', 'L', 'MTs-0121023323', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (642, '0121738860', 'NADIRA MARATUL SOLEHA', 'IX-B', 'P', 'MTs-0121738860', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (643, '0115333870', 'NAELA KHOERO DAHLAN', 'IX-B', 'P', 'MTs-0115333870', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (644, '0111012441', 'NIMA RAMADHANI GUNAWAN', 'IX-B', 'P', 'MTs-0111012441', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (645, '0000000016', 'NUR ALAM MIFTAH FARID', 'IX-B', 'L', 'MTs-0000000016', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (646, '0113830895', 'RAPA ALAWI', 'IX-B', 'L', 'MTs-0113830895', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (647, '0113627237', 'RAYA NUR WAHYUNI', 'IX-B', 'P', 'MTs-0113627237', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (648, '0126892903', 'RESTA CANTIKA', 'IX-B', 'P', 'MTs-0126892903', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (649, '0113144418', 'RESTI ARIYANTI', 'IX-B', 'P', 'MTs-0113144418', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (650, '0122352146', 'ROKI SABIL RAJABI', 'IX-B', 'L', 'MTs-0122352146', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (651, '3105316570', 'SA\'ARI ADRIANA', 'IX-B', 'L', 'MTs-3105316570', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (652, '0122221455', 'SASKIYA TANIA PUTRI', 'IX-B', 'P', 'MTs-0122221455', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (653, '0116042872', 'SITI HANNA ALAWIYAH', 'IX-B', 'P', 'MTs-0116042872', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (654, '0122561013', 'SITI MU\'NATUSARIPAH', 'IX-B', 'P', 'MTs-0122561013', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (655, '3114003486', 'TAREH PUAD MUSTOPA', 'IX-B', 'L', 'MTs-3114003486', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (656, '0119792375', 'ZAINI AHMAD RAMADAN', 'IX-B', 'L', 'MTs-0119792375', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (657, '0112446492', 'AHMAD RABBANI', 'IX-C', 'L', 'MTs-0112446492', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (658, '0118483161', 'AI RASTI NUR FADILAH', 'IX-C', 'P', 'MTs-0118483161', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (659, '0105964656', 'ANGGY LASMANA', 'IX-C', 'L', 'MTs-0105964656', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (660, '0111592371', 'ARSA SAPIALAWI', 'IX-C', 'L', 'MTs-0111592371', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (661, '0000000001', 'BAYU DWIKY RAHMAN', 'IX-C', 'L', 'MTs-0000000001', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (662, '0117916916', 'DELIA AYU PITRIYANI', 'IX-C', 'P', 'MTs-0117916916', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (663, '3117262776', 'FADIYA MAYLA HUWAYDA', 'IX-C', 'P', 'MTs-3117262776', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (664, '3115757009', 'FEBI NUR CAHYA DEWI', 'IX-C', 'P', 'MTs-3115757009', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (665, '0111616876', 'IQLIMA YASSIRLY AMRIYA', 'IX-C', 'P', 'MTs-0111616876', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (666, '0111819920', 'MOH. RANGGA SENA NUGRAHA', 'IX-C', 'L', 'MTs-0111819920', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (667, '0117719197', 'MUHAMAD IBNU RIPAL', 'IX-C', 'L', 'MTs-0117719197', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (668, '0119230470', 'MUHAMAD PADLAN ABDUL JABAR', 'IX-C', 'L', 'MTs-0119230470', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (669, '0115119345', 'MUHAMMAD ALFI ADILA AMRI', 'IX-C', 'L', 'MTs-0115119345', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (670, '0000000002', 'MUHAMMAD IRPAN NAWAWI', 'IX-C', 'L', 'MTs-0000000002', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (671, '0111838200', 'MUHAMMAD RAFA NUR HAKIM', 'IX-C', 'L', 'MTs-0111838200', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (672, '0116648148', 'NURI SAHROS SIYAMI', 'IX-C', 'P', 'MTs-0116648148', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (673, '0000000010', 'NURUL NUR AINI', 'IX-C', 'P', 'MTs-0000000010', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (674, '3110363015', 'RIFA PUSWIRA', 'IX-C', 'P', 'MTs-3110363015', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (675, '0115754427', 'RISYAD MUTHOBIQUL INSAN', 'IX-C', 'L', 'MTs-0115754427', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (676, '0113420007', 'SAVIRA NUR PADILAH', 'IX-C', 'P', 'MTs-0113420007', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (677, '3117057455', 'SITI ISMA YANTI', 'IX-C', 'P', 'MTs-3117057455', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (678, '0000000011', 'WILLIAM JABAR', 'IX-C', 'L', 'MTs-0000000011', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (679, '0125722980', 'ZAHRA AGUSTINA RAMADANI', 'IX-C', 'P', 'MTs-0125722980', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (680, '0114001432', 'AHMAD RIFKY YAMAMI', 'IX-D', 'L', 'MTs-0114001432', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (681, '3119306532', 'ARDI SUKMA DIANA', 'IX-D', 'L', 'MTs-3119306532', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (682, '0114359057', 'AZWAR ABDUL JABAR', 'IX-D', 'L', 'MTs-0114359057', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (683, '3127768295', 'CALISTA WIDYADARI\'AISY', 'IX-D', 'P', 'MTs-3127768295', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (684, '0113828579', 'EPA PUSPITA SARI', 'IX-D', 'P', 'MTs-0113828579', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (685, '3114786945', 'IQBAL NURSYAMSI', 'IX-D', 'L', 'MTs-3114786945', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (686, '3114471688', 'JIHAN KHOIRIL SALAMAH', 'IX-D', 'P', 'MTs-3114471688', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (687, '0112662205', 'LISNA NURALIPAH', 'IX-D', 'P', 'MTs-0112662205', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (688, '0116245777', 'MARSHA MAULIDA', 'IX-D', 'P', 'MTs-0116245777', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (689, '3113024061', 'MUHAMAD AZMI ROJABI', 'IX-D', 'L', 'MTs-3113024061', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (690, '0121153865', 'MUHAMAD NIZAM', 'IX-D', 'L', 'MTs-0121153865', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (691, '0000000013', 'MUHAMMAD ILHAM MUBAROK', 'IX-D', 'L', 'MTs-0000000013', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (692, '0111207715', 'MUHAMMAD IQBAL LAULIKKA', 'IX-D', 'L', 'MTs-0111207715', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (693, '3111203073', 'NADIA APRILIANA', 'IX-D', 'P', 'MTs-3111203073', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (694, '0115743910', 'NAZWA ZALIANTI NUR LATIFAH', 'IX-D', 'P', 'MTs-0115743910', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (695, '3129832668', 'PAUZAN MAULANA', 'IX-D', 'L', 'MTs-3129832668', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (696, '0112798486', 'RIVAN NUR MUDZAKIR', 'IX-D', 'L', 'MTs-0112798486', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (697, '3106240343', 'ROSITA', 'IX-D', 'P', 'MTs-3106240343', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (698, '0113487819', 'SHIFA QUEENY LATIVA', 'IX-D', 'P', 'MTs-0113487819', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (699, '0115463315', 'SILVA AYU NURWAFA', 'IX-D', 'P', 'MTs-0115463315', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (700, '3112922508', 'SITI NAJAHATUL IMTIHAN FAUZIAH', 'IX-D', 'P', 'MTs-3112922508', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (701, '0118221670', 'SRI RAHMA INDRIYANA', 'IX-D', 'P', 'MTs-0118221670', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (702, '0000000019', 'TASYA JAHLATUN NISA', 'IX-D', 'P', 'MTs-0000000019', '2026-07-02 22:53:55', '2026-07-13 00:10:45'), (703, '0117395681', 'WISNU ALBI HIDAYAT', 'IX-D', 'L', 'MTs-0117395681', '2026-07-02 22:53:55', '2026-07-13 00:10:45'); -- Dumping structure for table db_absensi_muttaqin.users CREATE TABLE IF NOT EXISTS `users` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('admin','guru') COLLATE utf8mb4_unicode_ci DEFAULT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_username_unique` (`username`) ) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Dumping data for table db_absensi_muttaqin.users: ~32 rows (approximately) INSERT INTO `users` (`id`, `name`, `username`, `email`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'Super Admin', 'superadmin', 'admin@gmail.com', NULL, '$2y$12$pAp0qTUlFyqCH68l8WwrjuAvYv3zAJhVrPjY597kzdefgKl8mnA2O', 'admin', NULL, '2026-04-20 17:45:38', '2026-07-12 23:21:52'), (60, 'Drs. H. Gaosul Adom, M.M.Pd.', 'gaosuladom', 'gaosuladom13@gmail.com', NULL, '$2y$12$fyeB7dp/e1L/CsC62CEJTu0wGtddDKJ1e4hiY1aHGW/2PejzYVoh2', 'guru', NULL, '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (61, 'ABDUL HOLIK, S.Ag.M.Pd.', 'abdulholik', 'abdulholik13@gmail.com', NULL, '$2y$12$KUqyDj6tyN9lCMZypLcSDO7eaDMlcMqYmNZhcmyd6b7E.vK19ZPGS', 'guru', NULL, '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (62, 'ADE SAEPUL HIDAYAT, S.Pd.', 'adesaepulhidayat', 'adesaepulhidayat13@gmail.com', NULL, '$2y$12$tHh8dq2xIh6yL1cUq3hXE.66w869UDdAnGqUH.t1QVuGMOU.B3zwW', 'guru', NULL, '2026-06-26 14:33:49', '2026-06-26 14:33:49'), (63, 'DEDEN SUADININGRAT, S.Ag.M.Pd.', 'dedensuadiningrat', 'dedensuadiningrat13@gmail.com', NULL, '$2y$12$wbO099.KRSqy5ED8ZcrpsOGj2aX8UJWBGgFycUZsveBLTlo2fhiSe', 'guru', NULL, '2026-06-26 14:33:50', '2026-06-26 14:33:50'), (64, 'MUMU,S.Ag', 'mumu', 'mumu13@gmail.com', NULL, '$2y$12$ggCuamdRVDZwlVe8/b/7ye4mfL1BlZtGMO2DbICGYEk1bgFiNHJZ.', 'guru', NULL, '2026-06-26 14:33:50', '2026-06-26 14:33:50'), (65, 'Hj. RATNA WULAN, S.Ag.', 'ratnawulan', 'ratnawulan13@gmail.com', NULL, '$2y$12$zrT.n3.mDy5fYOU6Mbw9gOkkx69bCRdi7ykax0cYxRKyo6cEygRee', 'guru', NULL, '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (66, 'ANI MULYANI, S.Pd.', 'animulyani', 'animulyani13@gmail.com', NULL, '$2y$12$quMx3QUMmzgfZ9YgP0TIHOPS18jkb1g2QWtxlnmPyejPoBRig4PL2', 'guru', NULL, '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (67, 'APIT INAYATILLAH, S.Pd.I', 'apitinayatillah', 'apitinayatillah13@gmail.com', NULL, '$2y$12$4FkI6Pyc5lmOMSFM09ZhB.jVlf6k1.dgNAGIdICCUFoR919GQT44W', 'guru', NULL, '2026-06-26 14:33:51', '2026-06-26 14:33:51'), (68, 'DEDE RAHMAWATI, S.Pd.I', 'dederahmawati', 'dederahmawati13@gmail.com', NULL, '$2y$12$.qa6k6K4DE04jXmNuwfRdeWtUySt/nx9SmhzKKaOHdvSaUQSPB3wK', 'guru', NULL, '2026-06-26 14:33:52', '2026-06-26 14:33:52'), (69, 'DELVIA MEGA SARI, S.Pd.I', 'delviamegasari', 'delviamegasari13@gmail.com', NULL, '$2y$12$WIFYBxqVWWhCeLumZe7mt.lcUJ847cQvPyiuiRbYhaqXyNLFDSYou', 'guru', NULL, '2026-06-26 14:33:52', '2026-06-26 14:33:52'), (71, 'INDA FAUZI RAHAYU, S.Pd.', 'indafauzirahayu', 'indafauzirahayu13@gmail.com', NULL, '$2y$12$oeNHF3LZ9TEe/ohIEKoHI.uEvbMfkNiIJJYv5MIrfQqrvXQHV07iu', 'guru', NULL, '2026-06-26 14:33:53', '2026-06-26 14:33:53'), (72, 'NANDANG FARID, S.Pd.', 'nandangfarid', 'nandangfarid13@gmail.com', NULL, '$2y$12$ywmbmQZN/eAJ0Xx4FRF99eKB1f2cf7bLLu1yQB2yG6UnqwY/xpsmW', 'guru', NULL, '2026-06-26 14:33:53', '2026-06-26 14:33:53'), (73, 'RURI NURUL AISYAH, S.Pd.', 'rurinurulaisyah', 'rurinurulaisyah13@gmail.com', NULL, '$2y$12$iu/tHnk6UeKAGtfoK6VngerAkY6CKZPICyMszbxd.J.51JSCjoGzG', 'guru', NULL, '2026-06-26 14:33:54', '2026-06-26 14:33:54'), (74, 'SANTI KAMILAH, S.Pd.', 'santikamilah', 'santikamilah13@gmail.com', NULL, '$2y$12$UhhlCXnAryb8YSXm5h0wwuxeaULMrssIBuJTL8YVMS5THiurcaWmS', 'guru', NULL, '2026-06-26 14:33:54', '2026-06-26 14:33:54'), (75, 'H. MIMIH SAEPUL MILLAH, S.Pd.I', 'mimihsaepulmillah', 'mimihsaepulmillah13@gmail.com', NULL, '$2y$12$8v4PFfT16kFCZh/0uJzVDeMSHrNkq0n/Mnf7kROWskDg6uvgD64tS', 'guru', NULL, '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (76, 'RIDWAN ILYAS, S.Pd.I', 'ridwanilyas', 'ridwanilyas13@gmail.com', NULL, '$2y$12$lV7ae5.0Ku8MCm3vHrm8/.2Usj530f7QHMGaT6FxfLuwEXH4QvtgO', 'guru', NULL, '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (77, 'Dra. KARYATI', 'karyati', 'karyati13@gmail.com', NULL, '$2y$12$oy51eHczIGhSA7gKlT04Uu2XfvyyQdh8BDssY/IEct7Bk6ycyg2Hi', 'guru', NULL, '2026-06-26 14:33:55', '2026-06-26 14:33:55'), (78, 'RIMA SRI CAHYANI, S.Pd.', 'rimasricahyani', 'rimasricahyani13@gmail.com', NULL, '$2y$12$D10jXSBYm67HQ/KdAz3F0OkAXQXAAyTnjsQbwU0mys7BjcNWKoDoW', 'guru', NULL, '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (79, 'PUPUNG PURWANTI KARTINI, S.Pd.', 'pupungpurwantikartini', 'pupungpurwantikartini13@gmail.com', NULL, '$2y$12$WpuZ.0fLgMqWyXKKCvouqOSEzWxqQRij3UDF7Va0F9sAutvCDAnny', 'guru', NULL, '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (80, 'ITA ROSITA', 'itarosita', 'itarosita13@gmail.com', NULL, '$2y$12$YZ15pxUELfPU5TkrTqo5oesILZiylFT.NlHChs7Jwz1ckCAhGlMc2', 'guru', NULL, '2026-06-26 14:33:56', '2026-06-26 14:33:56'), (81, 'HENDRIK RUSWANDI SAPUTRA', 'hendrikruswandisaputra', 'hendrikruswandisaputra13@gmail.com', NULL, '$2y$12$PmRJAljfIwHFu5vGydC3seq2klHF43GlLqw0aZ7jYHtzB8EDTBSuW', 'guru', NULL, '2026-06-26 14:33:57', '2026-06-26 14:33:57'), (82, 'DESI NURARIANIE', 'desinurarianie', 'desinurarianie13@gmail.com', NULL, '$2y$12$ftqsYBCgrrg1nF.QBBvjTOK7Al03ypjsNpJKRy4Xk5CokwaFGnA6u', 'guru', NULL, '2026-06-26 14:33:57', '2026-06-26 14:33:57'), (83, 'AI FITRI SOPYANTI, S.Pd.', 'aifitrisopyanti', 'aifitrisopyanti13@gmail.com', NULL, '$2y$12$YUo6xmqJPJREeV5Z8PjJKuK.rHIq/b3Xwd6ZB40PrTudvjVBIdEee', 'guru', NULL, '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (84, 'MIMAH NURAISAH, S.Pd.', 'mimahnuraisah', 'mimahnuraisah13@gmail.com', NULL, '$2y$12$icFUL7yPXqBNZK2eqZv/Meltw4CS50fMmpd1.JJ7CbibHDsi/eaWG', 'guru', NULL, '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (85, 'ASEP KHOTIB MUWAHID, M.Pd.', 'asepkhotibmuwahid', 'asepkhotibmuwahid13@gmail.com', NULL, '$2y$12$.i.HsWMoIFKUJpdkz7wLd.Mk7nfHyikxFj.o0lfmbN02LVFtR3z/K', 'guru', NULL, '2026-06-26 14:33:58', '2026-06-26 14:33:58'), (86, 'SINAR KHOTIMATUL HUSNA,S.Pd.', 'sinarkhotimatulhusna', 'sinarkhotimatulhusna13@gmail.com', NULL, '$2y$12$CmofrBptLuYRk6G63h.hqestuKKY/pOUSTfeDcdV7KNfJrF9LxYAu', 'guru', NULL, '2026-06-26 14:33:59', '2026-06-26 14:33:59'), (87, 'WANDI FIRMAN SUPRIANTO PUTRA, S.Pd.', 'wandifirmansupriantoputra', 'wandifirmansupriantoputra13@gmail.com', NULL, '$2y$12$sm8KtXgh1gOep8BZoq2k.ubRRhxmm5v6F9Wr5FVJQsRmbmmX7LPuu', 'guru', NULL, '2026-06-26 14:33:59', '2026-06-26 14:33:59'), (88, 'NADA SULISTIANISA', 'nadasulistianisa', 'nadasulistianisa13@gmail.com', NULL, '$2y$12$2TN6ssFFt6wKUWp8pwKeZOYpg4vgMeGFNGmeFDuQv9ZdTE4QtuPGq', 'guru', NULL, '2026-06-26 14:34:00', '2026-06-26 14:34:00'), (89, 'CUCU,S.Pd.', 'cucu', 'cucu13@gmail.com', NULL, '$2y$12$7U/2n7On3Hg0e2WorWUz.u5WhZWfFSyq8BoltIKGtsACt/xbYrVy.', 'guru', NULL, '2026-06-26 14:34:00', '2026-06-26 14:34:00'), (98, 'admin', 'admin', 'admin123@gmail.com', NULL, '$2y$12$YYFzAXQf3Cn39R7G8VGdgueR61/7n8YYAK6SCx8qlmWYG21x.QJxO', 'admin', NULL, '2026-07-12 23:25:48', '2026-07-12 23:25:48'), (99, 'H. II SIROJUL ARIFIN, S.Pd., M.Pd.', 'iisirojularifin', 'iisirojularifin13@gmail.com', NULL, '$2y$12$s5jsDsbVVhLMrTIGvBzx6eUiNWGLoZ/tWClrp29tyflgeUArlneDK', 'guru', NULL, '2026-07-13 00:17:19', '2026-07-13 00:17:19'); /*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */; /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */; /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;