# ************************************************************
# Sequel Ace SQL dump
# Version 20096
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Host: 127.0.0.1 (MySQL 8.0.42)
# Database: snmb
# Generation Time: 2026-06-27 15:26:37 +0000
# ************************************************************


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE='NO_AUTO_VALUE_ON_ZERO', SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table announcement_settings
# ------------------------------------------------------------

CREATE TABLE `announcement_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `announcement_date` datetime DEFAULT NULL,
  `re_registration_start` datetime DEFAULT NULL,
  `re_registration_end` datetime DEFAULT NULL,
  `re_registration_place` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kop_header` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `head_master_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `head_master_nip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `announcement_settings` WRITE;
/*!40000 ALTER TABLE `announcement_settings` DISABLE KEYS */;

INSERT INTO `announcement_settings` (`id`, `announcement_date`, `re_registration_start`, `re_registration_end`, `re_registration_place`, `kop_header`, `signature_image`, `head_master_name`, `head_master_nip`, `created_at`, `updated_at`)
VALUES
	(1,'2026-04-23 09:25:00','2026-04-24 09:24:00','2026-04-30 09:24:00','Sekretariat PPDB MTs Negeri 1 Purbalingga',NULL,NULL,'Drs. H. Ahmad Syarif',NULL,'2026-04-21 02:07:30','2026-04-24 02:25:55');

/*!40000 ALTER TABLE `announcement_settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table auth_carousel_slides
# ------------------------------------------------------------

CREATE TABLE `auth_carousel_slides` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table cache
# ------------------------------------------------------------

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table cache_locks
# ------------------------------------------------------------

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int NOT NULL,
  PRIMARY KEY (`key`),
  KEY `cache_locks_expiration_index` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table failed_jobs
# ------------------------------------------------------------

CREATE TABLE `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;



# Dump of table general_settings
# ------------------------------------------------------------

CREATE TABLE `general_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `general_settings_key_unique` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `general_settings` WRITE;
/*!40000 ALTER TABLE `general_settings` DISABLE KEYS */;

INSERT INTO `general_settings` (`id`, `key`, `value`, `description`, `created_at`, `updated_at`)
VALUES
	(1,'show_exam_card_button','1','Menentukan apakah tombol cetak kartu ujian ditampilkan untuk siswa yang sudah diverifikasi.','2026-04-21 02:27:37','2026-04-21 02:27:37');

/*!40000 ALTER TABLE `general_settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table infografis
# ------------------------------------------------------------

CREATE TABLE `infografis` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambar` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `infografis` WRITE;
/*!40000 ALTER TABLE `infografis` DISABLE KEYS */;

INSERT INTO `infografis` (`id`, `judul`, `gambar`, `is_active`, `order`, `created_at`, `updated_at`)
VALUES
	(1,'Alur Pendaftaran SNMB','https://lh3.googleusercontent.com/aida-public/AB6AXuDi4yGQmluZOluwkqLbeYGB6fN7O9HCkjGAvh0wenY4DqXSSvJbgynDvnra4VAQmg4yTS6ge07nnEgO9guxlsWHVAWP-y8eA7vQpV2AdkpxTxXCv8XvxuO150IJn4bxK6BMxUElUpKuHfqlqlh5oRESUoSWQ4l2g8GLZIjSvVCZTyeLKjf1PFT_SVnCuGfYSUEqeEF_avtUDcHSDtrw77IC07HU5sO00log3ldkY9MFluUZlI8fMs9bcMtqzZToSJES_zyCLCrlTL4i',1,1,'2026-04-07 08:36:20','2026-04-07 08:36:20'),
	(2,'Persyaratan Pendaftaran','https://lh3.googleusercontent.com/aida-public/AB6AXuBb4KURsaM-OAXCo1kpx1tLzc-I5pD5GtohaXDQxESpuaOKVlKvqEoh0VL-4Di-_jEuAIeWhmFgAaVJ5wMlt9TAEE92743Gbssgt1PI0_XlciLKn_yQY8tproczZfeHus2pt7B8r1bI08ZQjc1tVrcttr2c8regufR2Zyy-Yo6l-_ClCKTHIE7YO98X8zWbCMF0E7DprVuVKzQAzpsXb7XHcv9JvTdYYavxjFRbjqezXiNkaINhnUcR1kRG_1tbcRxrXrAqjnAmadkg',1,2,'2026-04-07 08:36:20','2026-04-07 08:36:20'),
	(3,'Timeline Pelaksanaan SNMB','https://lh3.googleusercontent.com/aida-public/AB6AXuC9ga_FMamgHb3gcgyGnc16cPkoPt54vP9lwQzhGEBuuo0A7rGIIbQt6co3NZuD4TqLAo-TN43P1cY59UOzqurd-zcexfNJNkxW-IM7qXbKZnkU_Nj9XgMTy_i-kfqp2txi1DtlvYdTE8hs5eZkPZagDTG5DK8Yzf_T2CUWakQUMnP_OpiDCmtHA690kU-BAuxfiBlL85kUko1rtCV5Cq8d5ZmiHwGz5ffydHZIKF8h2sFuKTgSg0nLkCRNMmNMKFnRn3nsOAGNfUf',1,3,'2026-04-07 08:36:21','2026-04-07 08:36:21');

/*!40000 ALTER TABLE `infografis` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table jalur_seleksi_files
# ------------------------------------------------------------

CREATE TABLE `jalur_seleksi_files` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `jalur_seleksi_id` bigint unsigned NOT NULL,
  `nama_field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ekstensi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `max_size_kb` int NOT NULL DEFAULT '3072',
  `is_required` tinyint(1) NOT NULL DEFAULT '0',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jalur_seleksi_files_jalur_seleksi_id_foreign` (`jalur_seleksi_id`),
  CONSTRAINT `jalur_seleksi_files_jalur_seleksi_id_foreign` FOREIGN KEY (`jalur_seleksi_id`) REFERENCES `jalur_seleksis` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `jalur_seleksi_files` WRITE;
/*!40000 ALTER TABLE `jalur_seleksi_files` DISABLE KEYS */;

INSERT INTO `jalur_seleksi_files` (`id`, `jalur_seleksi_id`, `nama_field`, `label`, `ekstensi`, `max_size_kb`, `is_required`, `order`, `created_at`, `updated_at`)
VALUES
	(3,1,'file_pas_foto','Foto Siswa','.jpg,.jpeg,.png',500,1,0,'2026-04-24 09:47:52','2026-04-24 09:47:52'),
	(4,1,'file_akta_kk','Kartu Keluarga','.pdf,.jpg,.jpeg,.png',3072,1,1,'2026-04-24 09:47:52','2026-04-24 09:47:52'),
	(5,1,'file_akta_kelahiran','Akta Kelahiran','.pdf',3072,1,2,'2026-04-24 09:47:52','2026-04-24 09:47:52');

/*!40000 ALTER TABLE `jalur_seleksi_files` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table jalur_seleksis
# ------------------------------------------------------------

CREATE TABLE `jalur_seleksis` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'category',
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `registration_start_date` date DEFAULT NULL,
  `registration_end_date` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `jalur_seleksis_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `jalur_seleksis` WRITE;
/*!40000 ALTER TABLE `jalur_seleksis` DISABLE KEYS */;

INSERT INTO `jalur_seleksis` (`id`, `nama`, `slug`, `icon`, `deskripsi`, `is_active`, `order`, `created_at`, `updated_at`, `registration_start_date`, `registration_end_date`)
VALUES
	(1,'Gelombang 1','gelombang-1','looks_one','Pendaftaran Gelombang 1 untuk Tahun Ajaran 2026/2027.',1,1,'2026-04-07 08:36:21','2026-04-07 08:36:21','2025-10-01','2025-12-31'),
	(2,'Gelombang 2','gelombang-2','looks_two','Pendaftaran Gelombang 2 untuk Tahun Ajaran 2026/2027.',1,2,'2026-04-07 08:36:21','2026-04-07 08:36:21','2026-01-01','2026-03-31'),
	(3,'Gelombang 3','gelombang-3','looks_3','Pendaftaran Gelombang 3 untuk Tahun Ajaran 2026/2027.',1,3,'2026-04-07 08:36:21','2026-04-07 08:36:21','2026-04-01','2026-06-30');

/*!40000 ALTER TABLE `jalur_seleksis` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table job_batches
# ------------------------------------------------------------

CREATE TABLE `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;



# Dump of table jobs
# ------------------------------------------------------------

CREATE TABLE `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;



# Dump of table landing_settings
# ------------------------------------------------------------

CREATE TABLE `landing_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `hero_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hero_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `hero_notification_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hero_image` text COLLATE utf8mb4_unicode_ci,
  `video_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_thumbnail` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `video_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `copyright_text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `objective_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Seleksi Nasional Murid Baru (SNMB) Madrasah Unggulan',
  `objective_image` text COLLATE utf8mb4_unicode_ci,
  `objective_content` text COLLATE utf8mb4_unicode_ci,
  `logo` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `landing_settings` WRITE;
/*!40000 ALTER TABLE `landing_settings` DISABLE KEYS */;

INSERT INTO `landing_settings` (`id`, `hero_title`, `hero_description`, `hero_notification_text`, `hero_image`, `video_title`, `video_description`, `video_thumbnail`, `video_url`, `copyright_text`, `objective_title`, `objective_image`, `objective_content`, `logo`, `created_at`, `updated_at`)
VALUES
	(1,'Seleksi Nasional Murid Baru (SNMB) Madrasah Unggulan','SNMB Madrasah Unggulan adalah sistem seleksi nasional yang diselenggarakan oleh Kementerian Agama Republik Indonesia untuk menjaring peserta didik terbaik dari seluruh Indonesia menuju madrasah unggulan berbasis asrama dan prestasi.','Pendaftaran SNMB 2026/2027 Dibuka Mulai 2 Januari 2026','https://lh3.googleusercontent.com/aida-public/AB6AXuA0c7SVBQ4CWcpj_J3iKmtIAMg9yDF3KM2yIzJ9DG2ZTnMSm_iBg6r08OaDDGJYLyJ-e50WXaEzTWu_mZxJfVwpcMfCbz_lexvwaxKQzpnvGTZ_qB237B1ef5kjhEq2tE43iuYi0lt9hql7TR8Iw_1PhcSDClEdBw9klh-vTaxnciUeWayE0_KrE0pVTHuBJ-kZ4QU11WDwAGU02CAfmrldYlXwQMNDwfxdYFVbVkhT-8pTLVLpRVr3L7CNz4qRb8vVsuJYVVvgV3W4','Tutorial Cara Pendaftaran SNMB Tahun 2026','Simak video berikut untuk panduan cara mengisi dan mendaftar di SNMB Madrasah Unggulan Tahun Pelajaran 2026/2027','https://lh3.googleusercontent.com/aida-public/AB6AXuCOaQQi2_lRHIymGiarFeu2yJrczIPB1RL6YOE_7yfTBHM8duLlVY4t8-8Vjwexg3VvBALKosOhlNgYk0T18xRs2VNSKC675oTb8aT0csZ9tiqPV4yMuuPwRsEJYqq8qq5Wcs9hK8rLy0j0UfNm7DtLeHoN0WP8LvGgv4p-U56rZ9wcwUu2TQSdPyZmOzJxHX_KjcnEOnmNs7f8YaGW9RBFlSUr49e_b0O-Lh40s3UORLspNeeNdBDlzQ2Mizobl1-HR-b2r6qgvSYU','#','© 2025 KSKK Madrasah.','Seleksi Nasional Murid Baru (SNMB) Madrasah Unggulan','https://lh3.googleusercontent.com/aida-public/AB6AXuDYns6bMhgA6OLUv7UHwK86bAoHK_xS23QAjHd_DJgfUaQFzLSxcrdwe9c0H1hrfd4XdWJxA9lHYU7bY-KezW4xm95I_ql78dVb0HXgs7nMl5qMDWhKKI8sLxyXJr93CEz_muozACAUPQbt_4FRRFS9R18MNFpoA6-mDbM2j3l26lzLdOmzmuhbPYPkpbFQM81TrXGpD0hLMlRyEiE1yOfw40L1PT5lSXfAnSAJQAtpXZk0J9KRWvyLFP2XJMuSkGEOwxUqPpLRspsD','Memberikan kesempatan yang adil bagi lulusan terbaik MTs/SMP/PDF/Pendidikan Muadalah untuk mengakses pendidikan bermutu di madrasah unggulan nasional.\nMenjaring calon murid dengan prestasi akademik, keagamaan, dan karakter unggul dari seluruh Indonesia.\nMenjamin proses seleksi yang objektif, transparan, dan akuntabel untuk semua peserta.',NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21');

/*!40000 ALTER TABLE `landing_settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table migrations
# ------------------------------------------------------------

CREATE TABLE `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=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;

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_02_06_030739_create_registrations_table',1),
	(5,'2026_02_07_152233_create_jalur_seleksis_table',1),
	(6,'2026_02_07_152823_create_timelines_table',1),
	(7,'2026_02_07_171955_create_infografis_table',1),
	(8,'2026_02_07_173418_create_landing_settings_table',1),
	(9,'2026_02_07_174750_add_objective_title_to_landing_settings_table',1),
	(10,'2026_02_07_175101_add_objective_content_to_landing_settings_table',1),
	(11,'2026_02_07_180224_add_logo_to_landing_settings_table',1),
	(12,'2026_02_08_105944_create_auth_carousel_slides_table',1),
	(13,'2026_02_09_065929_create_registration_proof_settings_table',1),
	(14,'2026_02_09_103348_add_dates_to_jalur_seleksis_table',1),
	(15,'2026_02_09_144447_create_registration_settings_table',1),
	(16,'2026_02_18_071004_add_nilai_and_upload_fields_to_registrations_table',1),
	(17,'2026_02_18_140329_add_kelas_and_peminatan_to_registrations_table',1),
	(18,'2026_02_19_044122_add_nisn_to_users_table',1),
	(19,'2026_02_19_045444_add_no_kk_to_registrations_table',1),
	(20,'2026_02_19_054029_add_acceptance_status_to_registrations_table',1),
	(21,'2026_02_19_054030_create_announcement_settings_table',1),
	(22,'2026_04_17_000000_add_petugas_role_to_users_table',2),
	(23,'2026_04_17_010000_add_new_registration_step_fields',3),
	(24,'2026_04_18_015843_create_jalur_seleksi_files_table',4),
	(25,'2026_04_19_010000_update_nilai_fields_for_smp',5),
	(26,'2026_04_19_100000_add_kode_pendaftaran_to_registrations',6),
	(27,'2026_04_21_000000_add_additional_upload_fields_to_registrations_table',7),
	(28,'2026_04_21_010000_create_general_settings_table',8),
	(29,'2026_04_26_000001_add_jalur_pendaftaran_2_to_registrations',9);

/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table password_reset_tokens
# ------------------------------------------------------------

CREATE TABLE `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;



# Dump of table registration_proof_settings
# ------------------------------------------------------------

CREATE TABLE `registration_proof_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `institution_header` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Kementerian Agama Republik Indonesia',
  `title_main` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BUKTI PENDAFTARAN SELEKSI NASIONAL MURID BARU (SNMB)',
  `title_sub` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'MADRASAH ALIYAH UNGGULAN',
  `school_year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TAHUN PELAJARAN 2026/2027',
  `notes` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `registration_proof_settings` WRITE;
/*!40000 ALTER TABLE `registration_proof_settings` DISABLE KEYS */;

INSERT INTO `registration_proof_settings` (`id`, `institution_header`, `title_main`, `title_sub`, `school_year`, `notes`, `created_at`, `updated_at`)
VALUES
	(1,'Kementerian Agama Republik Indonesia','BUKTI PENDAFTARAN SELEKSI NASIONAL MURID BARU (SNMB)','MADRASAH ALIYAH UNGGULAN','TAHUN PELAJARAN 2026/2027',NULL,'2026-04-20 02:47:09','2026-04-20 02:47:09');

/*!40000 ALTER TABLE `registration_proof_settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table registration_settings
# ------------------------------------------------------------

CREATE TABLE `registration_settings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `is_open` tinyint(1) NOT NULL DEFAULT '1',
  `close_message_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `close_message_content` text COLLATE utf8mb4_unicode_ci,
  `contact_info` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `registration_settings` WRITE;
/*!40000 ALTER TABLE `registration_settings` DISABLE KEYS */;

INSERT INTO `registration_settings` (`id`, `is_open`, `close_message_title`, `close_message_content`, `contact_info`, `created_at`, `updated_at`)
VALUES
	(1,1,'Pendaftaran Sudah Ditutup','Maaf, periode pendaftaran telah berakhir. Anda tidak dapat melanjutkan atau mengubah pendaftaran yang belum selesai.','Untuk informasi lebih lanjut, silakan hubungi admin madrasah tujuan Anda.','2026-04-07 08:36:20','2026-04-07 08:36:20');

/*!40000 ALTER TABLE `registration_settings` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table registrations
# ------------------------------------------------------------

CREATE TABLE `registrations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `step` int NOT NULL DEFAULT '1',
  `kode_pendaftaran` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalur_pendaftaran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalur_pendaftaran_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kelas` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `peminatan` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nisn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_kk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_akte_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jenis_kelamin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tempat_lahir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `status_anak` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_keluarga` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `anak_ke` int DEFAULT NULL,
  `jumlah_saudara` int DEFAULT NULL,
  `asal_sekolah` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_sekolah_asal` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalan` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rt_rw` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kabupaten` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_telepon` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kebutuhan_khusus` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Tidak',
  `kebutuhan_khusus_detail` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `disabilitas` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Tidak',
  `disabilitas_detail` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hobi` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cita_cita` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_tempat_tinggal` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jarak_sekolah` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `waktu_tempuh` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transportasi` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tinggi_badan` smallint unsigned DEFAULT NULL,
  `berat_badan` smallint unsigned DEFAULT NULL,
  `nomor_pip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_kip` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_kks` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_pkh` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `peringkat_7_1` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_bind_7_1` decimal(5,2) DEFAULT NULL,
  `nilai_bing_7_1` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_7_1` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_7_1` decimal(5,2) DEFAULT NULL,
  `nilai_ips_7_1` decimal(5,2) DEFAULT NULL,
  `peringkat_7_2` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_bind_7_2` decimal(5,2) DEFAULT NULL,
  `nilai_bing_7_2` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_7_2` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_7_2` decimal(5,2) DEFAULT NULL,
  `nilai_ips_7_2` decimal(5,2) DEFAULT NULL,
  `peringkat_8_1` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_bind_8_1` decimal(5,2) DEFAULT NULL,
  `nilai_bing_8_1` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_8_1` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_8_1` decimal(5,2) DEFAULT NULL,
  `nilai_ips_8_1` decimal(5,2) DEFAULT NULL,
  `peringkat_8_2` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_bind_8_2` decimal(5,2) DEFAULT NULL,
  `nilai_bing_8_2` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_8_2` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_8_2` decimal(5,2) DEFAULT NULL,
  `nilai_ips_8_2` decimal(5,2) DEFAULT NULL,
  `peringkat_9_1` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_bind_9_1` decimal(5,2) DEFAULT NULL,
  `nilai_bing_9_1` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_9_1` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_9_1` decimal(5,2) DEFAULT NULL,
  `nilai_ips_9_1` decimal(5,2) DEFAULT NULL,
  `nilai_tka_mtk` decimal(5,2) DEFAULT NULL,
  `nilai_tka_bind` decimal(5,2) DEFAULT NULL,
  `ketua_osis_mpk` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ketua_pramuka` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `prestasi` json DEFAULT NULL,
  `status_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pekerjaan_ayah` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalan_ayah` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rt_rw_ayah` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa_ayah` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan_ayah` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kabupaten_ayah` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi_ayah` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos_ayah` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penghasilan_ayah` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pekerjaan_ibu` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalan_ibu` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rt_rw_ibu` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa_ibu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan_ibu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kabupaten_ibu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi_ibu` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos_ibu` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penghasilan_ibu` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pilih_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no_hp_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pekerjaan_wali` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jalan_wali` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rt_rw_wali` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desa_wali` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kecamatan_wali` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kabupaten_wali` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provinsi_wali` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kode_pos_wali` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `penghasilan_wali` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_pas_foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_akta_kk` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_kks` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_rapor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_rekomendasi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_surat_keterangan_lulus` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_sptjm_nilai_rapor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_sptjm_rangking` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_sptjm_sertifikat_lomba` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_sptjm_sk_ketua_organisasi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_sptjm_sertifikat_tka` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nilai_pai_5_1` decimal(5,2) DEFAULT NULL,
  `nilai_bind_5_1` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_5_1` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_5_1` decimal(5,2) DEFAULT NULL,
  `nilai_pai_5_2` decimal(5,2) DEFAULT NULL,
  `nilai_bind_5_2` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_5_2` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_5_2` decimal(5,2) DEFAULT NULL,
  `nilai_pai_6_1` decimal(5,2) DEFAULT NULL,
  `nilai_bind_6_1` decimal(5,2) DEFAULT NULL,
  `nilai_mtk_6_1` decimal(5,2) DEFAULT NULL,
  `nilai_ipa_6_1` decimal(5,2) DEFAULT NULL,
  `file_akta_kelahiran` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_ijazah_skhun` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_kip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_pkh` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verification_status` enum('pending','approved','rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `verification_notes` text COLLATE utf8mb4_unicode_ci,
  `verified_by` bigint unsigned DEFAULT NULL,
  `verified_at` timestamp NULL DEFAULT NULL,
  `acceptance_status` enum('received','rejected','reserved') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `registrations_kode_pendaftaran_unique` (`kode_pendaftaran`),
  KEY `registrations_user_id_foreign` (`user_id`),
  KEY `registrations_verified_by_foreign` (`verified_by`),
  CONSTRAINT `registrations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `registrations_verified_by_foreign` FOREIGN KEY (`verified_by`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `registrations` WRITE;
/*!40000 ALTER TABLE `registrations` DISABLE KEYS */;

INSERT INTO `registrations` (`id`, `user_id`, `step`, `kode_pendaftaran`, `jalur_pendaftaran`, `jalur_pendaftaran_2`, `kelas`, `peminatan`, `nisn`, `nik`, `no_kk`, `no_akte_lahir`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `status_anak`, `status_keluarga`, `anak_ke`, `jumlah_saudara`, `asal_sekolah`, `status_sekolah_asal`, `jalan`, `rt_rw`, `desa`, `kecamatan`, `kabupaten`, `provinsi`, `kode_pos`, `no_telepon`, `kebutuhan_khusus`, `kebutuhan_khusus_detail`, `disabilitas`, `disabilitas_detail`, `hobi`, `cita_cita`, `status_tempat_tinggal`, `jarak_sekolah`, `waktu_tempuh`, `transportasi`, `tinggi_badan`, `berat_badan`, `nomor_pip`, `nomor_kip`, `nomor_kks`, `nomor_pkh`, `peringkat_7_1`, `nilai_bind_7_1`, `nilai_bing_7_1`, `nilai_mtk_7_1`, `nilai_ipa_7_1`, `nilai_ips_7_1`, `peringkat_7_2`, `nilai_bind_7_2`, `nilai_bing_7_2`, `nilai_mtk_7_2`, `nilai_ipa_7_2`, `nilai_ips_7_2`, `peringkat_8_1`, `nilai_bind_8_1`, `nilai_bing_8_1`, `nilai_mtk_8_1`, `nilai_ipa_8_1`, `nilai_ips_8_1`, `peringkat_8_2`, `nilai_bind_8_2`, `nilai_bing_8_2`, `nilai_mtk_8_2`, `nilai_ipa_8_2`, `nilai_ips_8_2`, `peringkat_9_1`, `nilai_bind_9_1`, `nilai_bing_9_1`, `nilai_mtk_9_1`, `nilai_ipa_9_1`, `nilai_ips_9_1`, `nilai_tka_mtk`, `nilai_tka_bind`, `ketua_osis_mpk`, `ketua_pramuka`, `prestasi`, `status_ayah`, `nama_ayah`, `nik_ayah`, `no_hp_ayah`, `pekerjaan_ayah`, `jalan_ayah`, `rt_rw_ayah`, `desa_ayah`, `kecamatan_ayah`, `kabupaten_ayah`, `provinsi_ayah`, `kode_pos_ayah`, `penghasilan_ayah`, `status_ibu`, `nama_ibu`, `nik_ibu`, `no_hp_ibu`, `pekerjaan_ibu`, `jalan_ibu`, `rt_rw_ibu`, `desa_ibu`, `kecamatan_ibu`, `kabupaten_ibu`, `provinsi_ibu`, `kode_pos_ibu`, `penghasilan_ibu`, `pilih_wali`, `nama_wali`, `nik_wali`, `no_hp_wali`, `pekerjaan_wali`, `jalan_wali`, `rt_rw_wali`, `desa_wali`, `kecamatan_wali`, `kabupaten_wali`, `provinsi_wali`, `kode_pos_wali`, `penghasilan_wali`, `file_pas_foto`, `file_akta_kk`, `file_kks`, `file_rapor`, `file_rekomendasi`, `file_surat_keterangan_lulus`, `file_sptjm_nilai_rapor`, `file_sptjm_rangking`, `file_sptjm_sertifikat_lomba`, `file_sptjm_sk_ketua_organisasi`, `file_sptjm_sertifikat_tka`, `nilai_pai_5_1`, `nilai_bind_5_1`, `nilai_mtk_5_1`, `nilai_ipa_5_1`, `nilai_pai_5_2`, `nilai_bind_5_2`, `nilai_mtk_5_2`, `nilai_ipa_5_2`, `nilai_pai_6_1`, `nilai_bind_6_1`, `nilai_mtk_6_1`, `nilai_ipa_6_1`, `file_akta_kelahiran`, `file_ijazah_skhun`, `file_kip`, `file_pkh`, `verification_status`, `verification_notes`, `verified_by`, `verified_at`, `acceptance_status`, `created_at`, `updated_at`)
VALUES
	(1,3,10,NULL,'tes',NULL,NULL,NULL,'1002575817','32736456631300',NULL,NULL,'P','Jayapura','1970-05-27','Anak Angkat','Anak Kandung',3,9,'SMP Negeri 23 Surakarta','Swasta','Psr. Labu No. 412','039/045','Bekasi','Batam','Kendari','Sulawesi Tenggara','54803','(+62) 271 6449 1717','Tidak',NULL,'Tidak',NULL,'Olahraga','Guru','Kontrak','5-10 km','< 30 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Galih Maryadi','32739461965783','0858 8045 332','Karyawan Swasta','Jr. Umalas No. 396','026/023','Bengkulu','Singkawang','Sungai Penuh','DI Yogyakarta','40538','3.000.000 - 5.000.000','Masih Hidup','Bella Aryani','32734209006508','(+62) 642 5140 305','Pelaut','Gg. Baranang No. 20','052/039','Pangkal Pinang','Tegal','Parepare','Nusa Tenggara Timur','32308','< 1.000.000','Ayah','Tira Purwanti','32731284890091','0675 2342 7010','Belum / Tidak Bekerja','Jln. Laswi No. 538','089/070','Batam','Bogor','Administrasi Jakarta Utara','Riau','52707','3.000.000 - 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending','Consequuntur at nemo aut.',NULL,NULL,NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(2,4,10,NULL,'prestasi',NULL,NULL,NULL,'1003729688','32737545876099',NULL,NULL,'L','Subulussalam','1997-03-24','Anak Angkat','Anak Kandung',1,9,'SMP Negeri 40 Batu','Swasta','Ds. Cihampelas No. 80','083/010','Blitar','Metro','Cirebon','Kalimantan Tengah','97301','0790 6348 789','Tidak',NULL,'Tidak',NULL,'Membaca','Pengusaha','Milik Orang Tua','Kurang dari 1 km','> 60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Saadat Muni Wijaya S.Psi','32730253058011','(+62) 27 0665 8095','Perawat','Jr. Banceng Pondok No. 425','039/038','Sabang','Madiun','Depok','Bengkulu','07076','3.000.000 - 5.000.000','Masih Hidup','Jane Hariyah','32731699916778','0434 9576 635','Dosen','Gg. W.R. Supratman No. 538','089/029','Depok','Ambon','Balikpapan','Sumatera Barat','81959','1.000.000 - 3.000.000','Lainnya','Jarwa Indra Pranowo M.M.','32731636455079','(+62) 637 5943 454','Peneliti','Kpg. Kebangkitan Nasional No. 676','098/013','Magelang','Serang','Bima','Sulawesi Tengah','37221','< 1.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending','In perspiciatis velit aut quis vel.',NULL,NULL,NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(3,5,10,NULL,'prestasi',NULL,NULL,NULL,'1009302726','32733749755705',NULL,NULL,'L','Mataram','1976-11-20','Anak Kandung','Anak Angkat',3,7,'SMP Negeri 13 Probolinggo','Swasta','Kpg. Merdeka No. 470','038/065','Depok','Surakarta','Surakarta','Sumatera Utara','10106','(+62) 438 3573 661','Tidak',NULL,'Tidak',NULL,'Membaca','Pengusaha','Kos','5-10 km','< 30 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Kalim Artanto Saputra','32738729485102','(+62) 360 7240 5754','Petani / Pekebun','Ds. BKR No. 638','050/088','Bima','Pariaman','Pangkal Pinang','Kalimantan Tengah','70708','3.000.000 - 5.000.000','Masih Hidup','Farah Handayani S.IP','32736727600626','0460 5675 433','Belum / Tidak Bekerja','Psr. Imam No. 132','042/076','Kotamobagu','Tomohon','Batam','Jawa Timur','67709','< 1.000.000','Ayah','Elvina Nasyidah','32736381499768','0359 6886 007','Masinis','Psr. Jend. Sudirman No. 688','045/007','Tidore Kepulauan','Depok','Tidore Kepulauan','Kalimantan Barat','14679','1.000.000 - 3.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected',NULL,NULL,NULL,NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(4,6,10,NULL,'prestasi',NULL,NULL,NULL,'1004133173','32731603226149',NULL,NULL,'P','Batu','2010-12-20','Anak Angkat','Anak Kandung',4,5,'SMP Negeri 15 Medan','Negeri','Jr. Raden Saleh No. 733','005/026','Cimahi','Semarang','Administrasi Jakarta Timur','DKI Jakarta','83810','(+62) 232 8053 8841','Tidak',NULL,'Tidak',NULL,'Membaca','Guru','Milik Orang Tua','Lebih dari 10 km','30-60 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Cakrawala Cawisadi Hardiansyah M.Pd','32732546594326','(+62) 716 4041 7090','Pramusaji','Dk. Daan No. 661','052/066','Mataram','Pematangsiantar','Batu','Sulawesi Utara','39493','1.000.000 - 3.000.000','Masih Hidup','Oni Winarsih','32731962910529','0275 2975 1177','Perawat','Dk. Katamso No. 142','089/071','Sabang','Cimahi','Bandar Lampung','Papua Barat','79299','1.000.000 - 3.000.000','Ayah','Fitria Hastuti','32734265719096','027 0557 983','Notaris','Jln. Flora No. 867','060/079','Salatiga','Singkawang','Blitar','Riau','08133','3.000.000 - 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,NULL,NULL,NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(5,7,10,NULL,'tes',NULL,NULL,NULL,'1001824187','32738305988901',NULL,NULL,'L','Cirebon','1989-03-08','Anak Kandung','Anak Kandung',4,10,'SMP Negeri 8 Palopo','Swasta','Jln. Suniaraja No. 472','094/099','Jayapura','Lubuklinggau','Padangpanjang','DI Yogyakarta','44736','021 7616 5623','Tidak',NULL,'Tidak',NULL,'Menulis','Insinyur','Kontrak','Kurang dari 1 km','> 60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Kayun Elvin Situmorang S.Kom','32738564291540','0709 4958 1663','Nahkoda','Ds. Hang No. 714','026/071','Jayapura','Palangka Raya','Tebing Tinggi','Jawa Tengah','91427','< 1.000.000','Masih Hidup','Mutia Permata S.Farm','32736881030866','0720 5767 647','Tukang Listrik','Jln. Batako No. 298','075/049','Bandung','Bau-Bau','Denpasar','Kalimantan Selatan','12571','3.000.000 - 5.000.000','Lainnya','Nova Julia Hasanah','32736051682632','0417 6319 2363','Pengacara','Ki. K.H. Wahid Hasyim (Kopo) No. 914','094/091','Ambon','Balikpapan','Sabang','Bengkulu','91775','1.000.000 - 3.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected',NULL,NULL,NULL,NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(6,8,10,NULL,'tes',NULL,NULL,NULL,'1003026118','32738618293511',NULL,NULL,'L','Bima','1992-05-16','Anak Angkat','Anak Angkat',4,8,'SMP Negeri 44 Sabang','Negeri','Jln. Sudirman No. 830','056/042','Padangsidempuan','Sawahlunto','Cimahi','Maluku Utara','40405','(+62) 757 3001 7141','Tidak',NULL,'Tidak',NULL,'Olahraga','Insinyur','Milik Orang Tua','5-10 km','30-60 menit','Angkutan Umum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Slamet Irawan','32730660452182','0585 2173 0641','Nelayan / Perikanan','Ds. Dago No. 575','070/033','Tidore Kepulauan','Tangerang','Cimahi','Sumatera Utara','66488','1.000.000 - 3.000.000','Masih Hidup','Anastasia Melani','32735453692920','(+62) 28 3326 8910','Paraji','Kpg. Teuku Umar No. 942','009/015','Subulussalam','Semarang','Padang','Jawa Timur','63783','1.000.000 - 3.000.000','Ibu','Ibun Lembah Pradana','32732534559694','0727 6920 325','Seniman','Kpg. Otto No. 897','087/093','Langsa','Bekasi','Cirebon','Kepulauan Riau','96496','3.000.000 - 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,NULL,NULL,NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(7,9,10,NULL,'prestasi',NULL,NULL,NULL,'1006165934','32733090949718',NULL,NULL,'L','Probolinggo','1974-10-24','Anak Kandung','Anak Kandung',5,2,'SMP Negeri 13 Solok','Negeri','Jr. Baranang Siang No. 524','046/092','Mojokerto','Medan','Salatiga','Jawa Barat','88829','0839 3058 1526','Tidak',NULL,'Tidak',NULL,'Musik','Dokter','Kontrak','1-5 km','> 60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Rangga Nainggolan','32731855422321','0778 6527 814','Perdagangan','Kpg. Raden No. 479','077/091','Palopo','Gorontalo','Palu','DKI Jakarta','99861','> 5.000.000','Masih Hidup','Yessi Usamah S.Kom','32738967784975','(+62) 996 2915 4447','Jaksa','Ds. Cikutra Barat No. 583','095/088','Batam','Batam','Bau-Bau','DKI Jakarta','90993','1.000.000 - 3.000.000','Ibu','Darman Narpati','32737385233065','0563 5904 7530','Desainer','Ki. Cikutra Timur No. 310','047/068','Malang','Mojokerto','Gunungsitoli','Jambi','63403','< 1.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,NULL,NULL,NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(8,10,10,NULL,'prestasi',NULL,NULL,NULL,'1006690533','32731435198027',NULL,NULL,'P','Palu','2008-09-26','Anak Kandung','Anak Angkat',4,2,'SMP Negeri 47 Tegal','Negeri','Jr. Pintu Besar Selatan No. 958','091/000','Mataram','Gorontalo','Tual','Bengkulu','69599','0659 1985 6680','Tidak',NULL,'Tidak',NULL,'Olahraga','Pengusaha','Milik Orang Tua','1-5 km','< 30 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Gandi Napitupulu M.Farm','32735130874299','(+62) 809 4788 567','Desainer','Ds. Antapani Lama No. 261','091/015','Medan','Kotamobagu','Cimahi','Sumatera Utara','94113','< 1.000.000','Masih Hidup','Nabila Yolanda','32732930567048','0539 5699 3172','Pialang','Ds. Cihampelas No. 759','071/049','Manado','Bengkulu','Dumai','Jawa Barat','15038','< 1.000.000','Ayah','Daliono Dabukke','32733312008645','0383 4163 047','Tukang Cukur','Jln. Antapani Lama No. 984','047/001','Bandar Lampung','Pagar Alam','Bandar Lampung','Sumatera Selatan','93848','3.000.000 - 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected','Molestiae neque consequatur qui est neque adipisci.',NULL,NULL,NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(9,11,10,NULL,'tes',NULL,NULL,NULL,'1001945088','32737969277378',NULL,NULL,'P','Kediri','2000-05-17','Anak Kandung','Anak Kandung',4,5,'SMP Negeri 10 Tanjung Pinang','Negeri','Dk. Bakhita No. 582','009/050','Payakumbuh','Samarinda','Lhokseumawe','Kalimantan Selatan','63342','0997 3762 4257','Tidak',NULL,'Tidak',NULL,'Menulis','Insinyur','Kontrak','Lebih dari 10 km','30-60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Gantar Latupono','32735517495130','0959 0288 136','Satpam','Jln. Imam Bonjol No. 552','092/097','Sabang','Blitar','Sawahlunto','Kalimantan Tengah','13087','< 1.000.000','Masih Hidup','Uli Laksmiwati','32732335934832','0265 1655 572','Pilot','Jr. Rajawali No. 568','000/041','Tidore Kepulauan','Manado','Palembang','Kepulauan Bangka Belitung','84627','3.000.000 - 5.000.000','Ayah','Artawan Gaman Tamba S.Gz','32732703780576','0978 5965 374','Tukang Jahit','Ds. Kartini No. 680','027/014','Padangsidempuan','Padangpanjang','Palembang','Jawa Timur','47964','3.000.000 - 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected',NULL,NULL,NULL,NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(10,12,10,NULL,'tes',NULL,NULL,NULL,'1006581463','32732104259955',NULL,NULL,'P','Gorontalo','1973-04-30','Anak Kandung','Anak Kandung',4,7,'SMP Negeri 11 Subulussalam','Swasta','Ki. Bagis Utama No. 977','012/052','Salatiga','Surabaya','Bengkulu','Kepulauan Bangka Belitung','19173','029 2974 225','Tidak',NULL,'Tidak',NULL,'Menulis','Dokter','Kos','1-5 km','< 30 menit','Angkutan Umum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Olga Gatot Jailani M.Pd','32733273104278','(+62) 556 0974 3068','Tukang Listrik','Psr. Soekarno Hatta No. 534','042/002','Lubuklinggau','Tual','Solok','Jawa Tengah','94960','1.000.000 - 3.000.000','Masih Hidup','Vicky Puspita','32736261977536','(+62) 269 5996 110','Pilot','Gg. Ronggowarsito No. 273','036/012','Sibolga','Padangpanjang','Cilegon','Gorontalo','88019','< 1.000.000','Lainnya','Zizi Citra Fujiati M.TI.','32737151849308','0767 6274 7818','Dokter','Kpg. Bakhita No. 201','091/092','Bogor','Administrasi Jakarta Pusat','Surabaya','Sumatera Selatan','73722','> 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(11,13,10,NULL,'tes',NULL,NULL,NULL,'1006100137','32734236025716',NULL,NULL,'P','Mataram','1978-03-04','Anak Kandung','Anak Angkat',2,8,'SMP Negeri 49 Bandar Lampung','Swasta','Jln. Kyai Gede No. 199','014/035','Medan','Cirebon','Lubuklinggau','DI Yogyakarta','19967','(+62) 498 6413 5166','Tidak',NULL,'Tidak',NULL,'Olahraga','Dokter','Kontrak','1-5 km','30-60 menit','Sepeda',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Jati Hutasoit','32733491266031','(+62) 299 3032 4609','Penambang','Ki. Perintis Kemerdekaan No. 548','049/081','Jayapura','Bima','Bontang','Papua Barat','25674','3.000.000 - 5.000.000','Masih Hidup','Alika Titi Pertiwi','32736518773559','0436 8027 878','Pensiunan','Jr. Krakatau No. 323','024/025','Administrasi Jakarta Timur','Tebing Tinggi','Depok','Maluku','26470','< 1.000.000','Ibu','Ajimat Prayoga','32736593297515','(+62) 27 9475 7018','Tukang Cukur','Kpg. Baik No. 600','091/045','Gunungsitoli','Semarang','Serang','Sulawesi Barat','34361','< 1.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected','Dolorum repellat iusto ipsa cumque dolores quae minus ut.',NULL,NULL,NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(12,14,10,NULL,'prestasi',NULL,NULL,NULL,'1002529422','32739288340749',NULL,NULL,'L','Denpasar','1975-06-26','Anak Angkat','Anak Angkat',3,7,'SMP Negeri 28 Parepare','Swasta','Psr. Dago No. 808','004/069','Mataram','Parepare','Sorong','Jawa Tengah','15379','0957 6448 460','Tidak',NULL,'Tidak',NULL,'Olahraga','Pengusaha','Kos','5-10 km','< 30 menit','Sepeda',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Kanda Kasim Maulana S.Kom','32735609458662','0419 3394 3860','Atlet','Psr. Kyai Mojo No. 155','074/014','Pagar Alam','Palembang','Pematangsiantar','Gorontalo','50738','3.000.000 - 5.000.000','Masih Hidup','Olivia Ulya Wulandari S.I.Kom','32732220696750','0996 9810 5167','Tukang Sol Sepatu','Ds. Nakula No. 385','016/093','Sawahlunto','Bandung','Sungai Penuh','Sulawesi Tengah','30056','1.000.000 - 3.000.000','Lainnya','Surya Budiman','32733123529823','(+62) 627 6067 003','Buruh Peternakan','Ki. Perintis Kemerdekaan No. 552','080/048','Administrasi Jakarta Selatan','Cilegon','Manado','Sumatera Utara','96285','> 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved','Occaecati laborum molestiae exercitationem neque est omnis est.',NULL,NULL,NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(13,15,10,NULL,'tes',NULL,NULL,NULL,'1008937973','32735985187748',NULL,NULL,'L','Ambon','1975-08-28','Anak Angkat','Anak Angkat',2,1,'SMP Negeri 3 Bau-Bau','Swasta','Jr. Tambun No. 931','076/097','Padang','Kotamobagu','Surakarta','Jawa Tengah','73766','027 4830 307','Tidak',NULL,'Tidak',NULL,'Musik','Insinyur','Milik Orang Tua','Kurang dari 1 km','< 30 menit','Angkutan Umum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Kusuma Megantara','32732943031267','0420 3923 910','Konsultan','Kpg. Babadan No. 969','026/089','Banjarbaru','Bekasi','Bandar Lampung','Kalimantan Utara','58602','> 5.000.000','Masih Hidup','Nurul Nasyidah','32732933559381','(+62) 929 2814 8765','Pialang','Gg. Radio No. 518','021/039','Pontianak','Malang','Parepare','Sumatera Barat','71287','1.000.000 - 3.000.000','Lainnya','Hendra Ghani Kurniawan','32731799298986','(+62) 828 7088 3274','Tukang Las / Pandai Besi','Jln. Ciumbuleuit No. 932','023/021','Bogor','Pasuruan','Palembang','Kalimantan Tengah','02338','> 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected',NULL,NULL,NULL,NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(14,16,10,NULL,'tes',NULL,NULL,NULL,'1003112346','32732801585657',NULL,NULL,'P','Tomohon','1980-09-09','Anak Kandung','Anak Kandung',2,5,'SMP Negeri 10 Pontianak','Swasta','Gg. Casablanca No. 226','060/006','Malang','Singkawang','Padangpanjang','Kepulauan Bangka Belitung','83960','0888 643 631','Tidak',NULL,'Tidak',NULL,'Membaca','Guru','Kontrak','5-10 km','< 30 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Jayadi Teddy Santoso S.Pd','32735921490004','0947 7498 518','Kondektur','Dk. Bayam No. 434','096/010','Bandar Lampung','Serang','Padang','Sumatera Utara','58220','1.000.000 - 3.000.000','Masih Hidup','Alika Hastuti','32734867274205','0814 0523 1080','Atlet','Psr. Cikapayang No. 8','080/097','Tasikmalaya','Manado','Magelang','Aceh','38838','1.000.000 - 3.000.000','Ibu','Kanda Waluyo Mangunsong','32736604065982','(+62) 717 8663 1975','Karyawan BUMN','Jln. Panjaitan No. 706','003/073','Sawahlunto','Samarinda','Pematangsiantar','Papua Barat','79334','1.000.000 - 3.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,NULL,NULL,NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(15,17,10,NULL,'tes',NULL,NULL,NULL,'1001065038','32737719387464',NULL,NULL,'P','Administrasi Jakarta Pusat','1970-11-28','Anak Angkat','Anak Kandung',4,4,'SMP Negeri 2 Payakumbuh','Negeri','Ds. Laksamana No. 484','090/081','Bitung','Administrasi Jakarta Barat','Bekasi','Banten','30908','0703 0371 127','Tidak',NULL,'Tidak',NULL,'Membaca','Dokter','Kos','Lebih dari 10 km','30-60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Viman Hardi Saputra S.Pd','32734366378166','(+62) 292 3251 864','Dosen','Gg. Gotong Royong No. 44','028/060','Probolinggo','Cirebon','Mataram','Jawa Timur','81178','> 5.000.000','Masih Hidup','Ida Karen Widiastuti','32739634139342','0630 7208 493','Dokter','Dk. Warga No. 80','028/079','Tomohon','Parepare','Batu','DI Yogyakarta','27043','3.000.000 - 5.000.000','Lainnya','Wirda Yuniar','32733279405949','0834 9961 8210','Nelayan / Perikanan','Jln. Honggowongso No. 520','043/049','Tual','Lubuklinggau','Bandar Lampung','Maluku','13345','> 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved','Ut eum adipisci fuga fuga vel beatae.',NULL,NULL,NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(16,18,10,NULL,'tes',NULL,NULL,NULL,'1006466169','32739114301974',NULL,NULL,'P','Tangerang','1995-07-09','Anak Angkat','Anak Angkat',2,6,'SMP Negeri 43 Tidore Kepulauan','Negeri','Ds. Yos Sudarso No. 445','017/042','Banjarmasin','Palangka Raya','Subulussalam','Banten','52329','(+62) 606 5746 3687','Tidak',NULL,'Tidak',NULL,'Membaca','Pengusaha','Kos','1-5 km','30-60 menit','Angkutan Umum',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Cengkal Jasmani Najmudin S.H.','32731583226001','(+62) 965 2055 0562','Psikiater / Psikolog','Kpg. Bank Dagang Negara No. 367','071/090','Kotamobagu','Pematangsiantar','Padangsidempuan','Lampung','24662','> 5.000.000','Masih Hidup','Ajeng Citra Andriani','32735741627641','0253 6924 908','Pialang','Jr. Sutarjo No. 10','020/082','Serang','Administrasi Jakarta Selatan','Mojokerto','Papua Barat','30476','> 5.000.000','Ibu','Novi Rahmawati','32739012389096','0699 6255 914','Arsitek','Kpg. W.R. Supratman No. 513','048/074','Samarinda','Surabaya','Jambi','Maluku Utara','54246','< 1.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(17,19,10,NULL,'prestasi',NULL,NULL,NULL,'1007841818','32732800074965',NULL,NULL,'P','Bogor','1977-12-27','Anak Angkat','Anak Angkat',1,3,'SMP Negeri 7 Tidore Kepulauan','Negeri','Ki. Urip Sumoharjo No. 752','032/001','Blitar','Palu','Padang','DKI Jakarta','53944','0804 3678 8781','Tidak',NULL,'Tidak',NULL,'Membaca','Pengusaha','Kos','5-10 km','> 60 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Hasan Rangga Hakim','32735929531798','(+62) 311 6540 040','Buruh Nelayan / Perikanan','Ds. Padang No. 78','067/011','Kupang','Banjarmasin','Parepare','Papua Barat','15776','1.000.000 - 3.000.000','Masih Hidup','Rahayu Elma Nasyidah S.Farm','32739487500977','0521 9542 8716','Pialang','Psr. Babadan No. 100','017/071','Sorong','Probolinggo','Padangsidempuan','DKI Jakarta','36928','< 1.000.000','Ibu','Kala Situmorang','32730712215617','(+62) 946 6799 480','Tukang Listrik','Jln. Bacang No. 396','069/090','Palembang','Mojokerto','Bukittinggi','Jawa Tengah','97047','< 1.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved','Pariatur dolorem sit ullam veritatis et voluptas.',NULL,NULL,NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(18,20,10,NULL,'prestasi',NULL,NULL,NULL,'1004710104','32736979613377',NULL,NULL,'P','Lhokseumawe','1973-07-24','Anak Angkat','Anak Angkat',5,3,'SMP Negeri 23 Tanjungbalai','Negeri','Ds. Sunaryo No. 554','067/021','Cirebon','Kupang','Ternate','Sumatera Selatan','10405','0402 5459 7918','Tidak',NULL,'Tidak',NULL,'Musik','Guru','Kos','Kurang dari 1 km','< 30 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Purwadi Sirait M.M.','32730868876711','(+62) 28 7150 1077','Tukang Gigi','Ki. Samanhudi No. 14','092/047','Metro','Administrasi Jakarta Pusat','Batu','Aceh','07427','1.000.000 - 3.000.000','Masih Hidup','Nurul Tira Padmasari','32735123343059','(+62) 764 4077 5892','Arsitek','Ds. Dipenogoro No. 135','012/015','Pangkal Pinang','Mojokerto','Administrasi Jakarta Pusat','Kalimantan Tengah','72141','1.000.000 - 3.000.000','Ayah','Teguh Iswahyudi','32733109327800','0886 8798 8897','Programmer','Ds. Ciumbuleuit No. 930','054/096','Gorontalo','Bogor','Cimahi','Kalimantan Timur','72236','1.000.000 - 3.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,NULL,NULL,NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(19,21,10,NULL,'tes',NULL,NULL,NULL,'1008338512','32733321551777',NULL,NULL,'L','Bandar Lampung','1972-06-11','Anak Kandung','Anak Angkat',2,5,'SMP Negeri 31 Gorontalo','Swasta','Jr. Bakit  No. 902','075/057','Pematangsiantar','Dumai','Surabaya','Sulawesi Barat','67563','0838 2687 768','Tidak',NULL,'Tidak',NULL,'Membaca','Pengusaha','Kontrak','1-5 km','30-60 menit','Jalan Kaki',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Mursinin Maulana','32734311945404','(+62) 926 0699 442','Pramusaji','Kpg. Gading No. 349','048/080','Sungai Penuh','Ternate','Palangka Raya','Jawa Barat','01777','> 5.000.000','Masih Hidup','Fitria Vicky Pertiwi S.I.Kom','32738981109911','(+62) 583 8177 4570','Tukang Las / Pandai Besi','Kpg. Raden Saleh No. 124','046/071','Administrasi Jakarta Pusat','Manado','Sungai Penuh','Nusa Tenggara Barat','95017','3.000.000 - 5.000.000','Lainnya','Hafshah Karen Winarsih M.Kom.','32730873119247','(+62) 429 4134 3697','Tukang Las / Pandai Besi','Ds. Gambang No. 384','083/064','Tual','Tebing Tinggi','Surabaya','Sulawesi Tengah','42595','> 5.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(20,22,10,NULL,'prestasi',NULL,NULL,NULL,'1009208763','32738656441433',NULL,NULL,'P','Ternate','1998-03-09','Anak Angkat','Anak Kandung',2,4,'SMP Negeri 43 Tomohon','Swasta','Dk. Baabur Royan No. 983','086/027','Balikpapan','Cimahi','Padang','Nusa Tenggara Timur','11535','0574 5562 1760','Tidak',NULL,'Tidak',NULL,'Olahraga','Pengusaha','Kontrak','5-10 km','< 30 menit','Motor',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Irsad Nashiruddin S.Kom','32734007751357','(+62) 451 9562 818','Tentara Nasional Indonesia (TNI)','Dk. Sutarjo No. 578','044/058','Tual','Kupang','Singkawang','Kalimantan Selatan','99325','1.000.000 - 3.000.000','Masih Hidup','Aisyah Padmi Yuniar M.Ak','32739891086862','0331 8837 3505','Penyiar Televisi','Psr. Ir. H. Juanda No. 206','002/014','Denpasar','Bogor','Pontianak','Aceh','63919','< 1.000.000','Lainnya','Jais Kuswoyo','32737067542144','(+62) 753 2787 2023','Tentara Nasional Indonesia (TNI)','Ds. Imam No. 48','050/055','Administrasi Jakarta Barat','Pagar Alam','Pekanbaru','Maluku Utara','17696','1.000.000 - 3.000.000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'rejected','Et nobis totam sed doloribus sed quia.',NULL,NULL,NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(21,23,4,NULL,'gelombang-1',NULL,'Reguler','Akademik','0123365980','3321041212120004','3321041212120004',NULL,'Laki-laki','demak','2026-04-08','Anak Kandung',NULL,2,4,'SMP Futuhiyyah','Negeri','Jalan Suburan','002','Simpang','Bakongan Timur','Kabupaten Aceh Selatan','Aceh','50141','085886876254','Tidak',NULL,'Tidak',NULL,NULL,NULL,'Milik Sendiri',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Masih Hidup','Caket Situmorang','3321041212120004',NULL,'Karyawan Swasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Meninggal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Ayah','Caket Situmorang','3321041212120004',NULL,'Karyawan Swasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-08 14:16:11','2026-04-08 14:23:50'),
	(22,25,10,'SPMB20260002','gelombang-1',NULL,NULL,NULL,'0123365988',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bakongan','Kabupaten Aceh Selatan','Aceh',NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,1,'2026-04-20 02:55:52','received','2026-04-17 03:28:29','2026-04-20 02:58:04'),
	(23,2,9,NULL,'gelombang-1',NULL,NULL,NULL,NULL,'3321041212120004','3321041212120004',NULL,'Laki-laki','Semarang','2026-04-19','Anak Kandung',NULL,2,4,'SMP Negeri 31 Palembang','Negeri','Jalan Suburan','002','Simpang Belutu','Kandis','Kabupaten S I A K','Riau','59567','085886876254','Tidak',NULL,'Tidak',NULL,NULL,NULL,'Milik Sendiri',NULL,NULL,NULL,NULL,NULL,'800878879799','800878879799','787879808080','8787886767676776',NULL,80.00,80.00,98.00,88.00,90.00,NULL,80.00,90.00,99.00,80.00,90.00,NULL,88.00,88.00,88.00,99.00,88.00,NULL,77.00,90.00,88.00,78.00,90.00,NULL,90.00,77.00,90.00,88.00,90.00,90.00,81.00,'Ya','Ya','[{\"nama\": \"test\", \"tahun\": \"2016\", \"tingkat\": \"kabupaten_kota\", \"kategori\": \"individu\", \"peringkat\": \"juara_1\", \"kurasi_simt\": \"sudah\", \"link_kurasi\": \"https//:jhjhjdhjd\"}]','Masih Hidup','Caket Situmorang','3321041212120004','085886876254','Karyawan Swasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1.000.000 - 3.000.000','Masih Hidup','Silvia Susanti','32730559412926','0395 6776 570','Karyawan Swasta',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'> 5.000.000','Ayah',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'registrations/iMXd7UnHpnmwA2cziWKMxHU448IhMtc4VLto0Nzu.jpg','registrations/L8iHfHxjQAl1itC2wJYf1tJkdb1AwBctbC8Upq1u.pdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-19 01:28:09','2026-04-19 03:57:12'),
	(24,26,10,'SPMB20260001','gelombang-1',NULL,NULL,NULL,'0112995333',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-19 10:33:22','2026-04-19 10:34:04'),
	(25,27,8,NULL,'gelombang-1',NULL,NULL,NULL,'1009048111',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-21 02:03:51','2026-04-21 02:04:01'),
	(26,28,10,'SPMB20260003','gelombang-1',NULL,NULL,NULL,'0123365112',NULL,'3321041212120004',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]','Masih Hidup','Caket Situmorang',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,1,'2026-04-23 22:59:03','received','2026-04-23 22:54:20','2026-04-24 09:32:27'),
	(27,29,7,NULL,'gelombang-1',NULL,NULL,NULL,'0123365999',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-23 23:00:49','2026-04-23 23:00:56'),
	(28,30,10,'SPMB20260004','gelombang-1',NULL,NULL,NULL,'2952135562',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'registrations/kk_iran_at_irancom.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'registrations/akta_iran_at_irancom.pdf',NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-24 09:43:08','2026-04-26 15:15:31'),
	(29,31,10,'SPMB20260005','gelombang-1','gelombang-2',NULL,NULL,'0128865988',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Muaro Bodi','Iv Nagari','Kabupaten Sijunjung','Sumatera Barat',NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'umum_1',99.00,90.00,99.00,90.00,88.00,'umum_2',NULL,NULL,NULL,NULL,NULL,'umum_2',NULL,NULL,NULL,NULL,NULL,'umum_3',NULL,NULL,NULL,NULL,NULL,'umum_2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[{\"nama\": \"OSN\", \"tahun\": \"2022\", \"tingkat\": \"provinsi\", \"kategori\": \"beregu\", \"peringkat\": \"juara_2\", \"kurasi_simt\": \"belum\", \"link_kurasi\": null}]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'registrations/HbX4pGdLtLKdQC03NvIH5Rfo7fm0624JCkmazs32.jpg','registrations/kk_ugas_at_testcom.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'registrations/akta_ugas_at_testcom.pdf',NULL,NULL,NULL,'pending',NULL,NULL,NULL,NULL,'2026-04-26 15:26:19','2026-04-30 06:04:24'),
	(30,32,10,'SPMB20260006','gelombang-1','gelombang-2',NULL,NULL,'1119048231',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Tidak',NULL,'Tidak',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'[]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'approved',NULL,1,'2026-04-28 10:05:16','received','2026-04-27 05:33:46','2026-04-28 10:05:24');

/*!40000 ALTER TABLE `registrations` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table sessions
# ------------------------------------------------------------

CREATE TABLE `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;

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`)
VALUES
	('A5475iXVwKx4MrpNwHzYbwxyx2ehcO5IwIfqeqYN',NULL,'127.0.0.1','Mozilla/5.0 (Linux; Android 8.0.0; SM-G955U Build/R16NW) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Mobile Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoiT25kVUdVRDlIbEpTWVBBVE5Wdk5PVHk5ak5rN3hiNzJ6SnpEZlFqSSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9zbm1iLnRlc3QiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1780908917),
	('umBWJoAd9McHt1jwJZtBYqDbwXXwLuayyAwstOlb',NULL,'127.0.0.1','Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36','YTozOntzOjY6Il90b2tlbiI7czo0MDoielR3Q2JJTkl6dzlKejBVOGdQbTlCYVJHRjFUZ1BlYnFocnNlbnJlRSI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6MTY6Imh0dHA6Ly9zbm1iLnRlc3QiO3M6NToicm91dGUiO047fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1782573927);

/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table timelines
# ------------------------------------------------------------

CREATE TABLE `timelines` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` text COLLATE utf8mb4_unicode_ci,
  `jalur` enum('umum','prestasi','tes') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'umum',
  `tipe` enum('header','item','highlight','footer') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'item',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `order` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `timelines` WRITE;
/*!40000 ALTER TABLE `timelines` DISABLE KEYS */;

INSERT INTO `timelines` (`id`, `nama`, `tanggal`, `keterangan`, `jalur`, `tipe`, `is_active`, `order`, `created_at`, `updated_at`)
VALUES
	(1,'Informasi & Sosialisasi','17 Des 2025 - 7 Feb 2026','Sosialisasi SNMB kepada madrasah, sekolah, siswa, dan orang tua melalui kanal resmi','umum','header',1,1,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(2,'Pendaftaran Online','2 Jan - 2 Feb 2026',NULL,'prestasi','item',1,1,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(3,'Seleksi Berkas','3 Jan - 3 Feb 2026',NULL,'prestasi','item',1,2,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(4,'Pengumuman Lolos Berkas','5 Februari 2026',NULL,'prestasi','item',1,3,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(5,'Tes Lanjutan Jalur Prestasi','7 - 9 Feb 2026','Psikotes (MAN IC, MAKN, MAN PUN): 7 Feb\nTes Wawancara (MAN PK): 7 - 9 Feb','prestasi','item',1,4,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(6,'Pengumuman Kelulusan','13 Februari 2026',NULL,'prestasi','highlight',1,5,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(7,'Daftar Ulang','23 - 28 Feb 2026',NULL,'prestasi','item',1,6,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(8,'Pendaftaran Online','2 Jan - 7 Feb 2026',NULL,'tes','item',1,1,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(9,'Seleksi Berkas','3 Jan - 8 Feb 2026',NULL,'tes','item',1,2,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(10,'Pengumuman Lolos Berkas','9 Februari 2026',NULL,'tes','item',1,3,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(11,'Uji Coba CBT','12 - 13 Feb 2026',NULL,'tes','item',1,4,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(12,'Computer Based Test (CBT)','14 - 15 Feb 2026',NULL,'tes','item',1,5,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(13,'Pengumuman Kelulusan','6 Maret 2026',NULL,'tes','highlight',1,6,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(14,'Daftar Ulang','9 - 14 Maret 2026',NULL,'tes','item',1,7,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(15,'Masuk Asrama','11 Juli 2026','Awal Tahun Ajaran Baru - Seluruh peserta didik yang diterima wajib melapor dan masuk asrama','umum','footer',1,99,'2026-04-07 08:36:21','2026-04-07 08:36:21');

/*!40000 ALTER TABLE `timelines` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nisn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `role` enum('user','admin','petugas') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `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_nisn_unique` (`nisn`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`id`, `name`, `email`, `nisn`, `email_verified_at`, `password`, `role`, `remember_token`, `created_at`, `updated_at`)
VALUES
	(1,'Admin','admin@admin.com',NULL,NULL,'$2y$12$ymoI1kCElIBq9WLFiySyh.KiD97bi5IlIPVY53TkNc5bqHSQXbJU.','admin',NULL,'2026-04-07 08:36:20','2026-04-07 08:36:20'),
	(2,'User','user@user.com',NULL,NULL,'$2y$12$OJ8sYEYV3xMe8AoDfzwVQeHzED5uz51aJz/6yMuiqI3jOzH44RP76','user',NULL,'2026-04-07 08:36:20','2026-04-07 08:36:20'),
	(3,'Saka Dongoran','saka-dongoran@example.com',NULL,NULL,'$2y$12$TgpYhL6aaoyIwTfssZhs2OVd0AmC31tD36gRSM2sj6awYztq.ADTy','user',NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(4,'Latif Cakrawangsa Gunawan','latif-cakrawangsa-gunawan@example.com',NULL,NULL,'$2y$12$aUHS.DaD2HKtMT9Mjf5n/ueHBEtxtyOWorg1o9HPeM1nqTmrf9Ds2','user',NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(5,'Endra Mangunsong S.Kom','endra-mangunsong-skom@example.com',NULL,NULL,'$2y$12$TxPS7lAdIQJwNSFGT8XQK.PLPFiVPN7CoOi0RIf7Mo.eYjCya2e.u','user',NULL,'2026-04-07 08:36:21','2026-04-07 08:36:21'),
	(6,'Ratih Carla Andriani M.Pd','ratih-carla-andriani-mpd@example.com',NULL,NULL,'$2y$12$JACRFPHz/6ZdHt0Sp/3mwuhVXew9HYhV/EcbVoWazd7hCcTV2skg6','user',NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(7,'Indra Jarwi Hardiansyah M.Pd','indra-jarwi-hardiansyah-mpd@example.com',NULL,NULL,'$2y$12$fd2wsNovPYe24knSBv7XEe601DmtGoKv4NSuca/CGqcx/m4etr5/u','user',NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(8,'Pranawa Ardianto','pranawa-ardianto@example.com',NULL,NULL,'$2y$12$5ACEeBO79s4ZcbsuCddLduoObNFMLoaT2C.k91zHoOXQtLVqXNOby','user',NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(9,'Cayadi Kuswoyo','cayadi-kuswoyo@example.com',NULL,NULL,'$2y$12$LXVxnABsAflKFzf2lpKwr.XnUeA7PYNERpve6NlSFylp/wDxu9h6a','user',NULL,'2026-04-07 08:36:22','2026-04-07 08:36:22'),
	(10,'Zulaikha Yolanda S.Pt','zulaikha-yolanda-spt@example.com',NULL,NULL,'$2y$12$sdm7fgxYvwJnEkqDF.SMOex6f6RzD4som5QjcuGnzCSA1gUNe9nUS','user',NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(11,'Prayogo Manullang M.Farm','prayogo-manullang-mfarm@example.com',NULL,NULL,'$2y$12$QjW/uwXLD/m7/qum9CO9Mue2yMDvUjhx4bRBVH7nI/s0d/ya56m3S','user',NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(12,'Wage Hardiansyah','wage-hardiansyah@example.com',NULL,NULL,'$2y$12$b/Ff1djdbGPc2kzQ4WYDxu/C1SYyFFsDA/aqzmUCIX0AtFpho9RQO','user',NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(13,'Hesti Ulya Melani','hesti-ulya-melani@example.com',NULL,NULL,'$2y$12$PvIoak0tWenNCPFhLyXR6eMHreKH1o4i0BRPYCR5F1cWM8m0XSF82','user',NULL,'2026-04-07 08:36:23','2026-04-07 08:36:23'),
	(14,'Siti Putri Padmasari','siti-putri-padmasari@example.com',NULL,NULL,'$2y$12$HtziVJ0qan2RBlpLYpgviuvkNzxwwuQNWBiChdaSrVW3/ysgvZpyG','user',NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(15,'Nilam Mayasari','nilam-mayasari@example.com',NULL,NULL,'$2y$12$ApBn.D4HMhP54RGIKsUqGOrdBNWdxU2clbQ3WudvRVSnhkzvrjyty','user',NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(16,'Jane Safitri','jane-safitri@example.com',NULL,NULL,'$2y$12$AW6suOBrtxWzb9drP8szQ.mCi04SmN9MWKQ7/4l.WvQmm6gUfUIQG','user',NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(17,'Maria Prastuti','maria-prastuti@example.com',NULL,NULL,'$2y$12$Yo7pJ.fx1snZoLiUTByxPOtZxohxEnHtZuLA2zJbVk1nUhsNrCB86','user',NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(18,'Banawi Pradipta','banawi-pradipta@example.com',NULL,NULL,'$2y$12$Vu3whgCjL.8SqxRJPLgQOu3Z/Lu5zgrdIMbd79BMfqNBIE3EHM5r6','user',NULL,'2026-04-07 08:36:24','2026-04-07 08:36:24'),
	(19,'Jane Permata','jane-permata@example.com',NULL,NULL,'$2y$12$qxf1iPpRVZsYAsbdGZzC8.b.K2kmaAwrTbu4W2ZJGdLHXGin4ThMi','user',NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(20,'Wage Sirait','wage-sirait@example.com',NULL,NULL,'$2y$12$kYzjMujFO/Aat54aXDdiYe5AP5B1pSFX..rosvv/YUar3Ca8qXkv.','user',NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(21,'Yuliana Mandasari','yuliana-mandasari@example.com',NULL,NULL,'$2y$12$JbJrQQ.sKQPZolaEbTbRiuN/deF9I4vKmXbghKVJN1.zUx.CnX3ue','user',NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(22,'Lidya Purwanti','lidya-purwanti@example.com',NULL,NULL,'$2y$12$ld1YCVybzIWQfHNSGOuBB.4ahL/MRjXPMcGdCAZnPn9uH00EIrx3W','user',NULL,'2026-04-07 08:36:25','2026-04-07 08:36:25'),
	(23,'Elbark Store','admin@example.com','0123365980',NULL,'$2y$12$rlWvRX5NBIVUB4rGrWXZVeb2wQCFMBeY/TPZxUatIjKKF3ieOWaUW','user',NULL,'2026-04-08 14:15:53','2026-04-08 14:15:53'),
	(24,'umar','umar@umar.com',NULL,NULL,'$2y$12$GGxwI6/dEgn1xPMxBMQZLebx/q6uQtLYxg7z4twBp0KzabEn1vvE2','petugas',NULL,'2026-04-17 03:14:22','2026-04-17 03:14:22'),
	(25,'siswa@siswa.com','siswa@siswa.com','0123365988',NULL,'$2y$12$d4tlHyab0Vf21lXOO0mVL.cC7ijqM0lzswAsKZCCUa08Q7pnfE.cS','user',NULL,'2026-04-17 03:25:10','2026-04-17 03:25:10'),
	(26,'test@test.com','test@test.com','0112995333',NULL,'$2y$12$tB62On13jsSlH1sdCSJN6ulvsyBScT7nKA8bDDrO90I73JCZ6D9vK','user',NULL,'2026-04-19 10:32:56','2026-04-19 10:32:56'),
	(27,'ilham@ilham.com','ilham@ilham.com','1009048111',NULL,'$2y$12$priN8NZgs3n.6om.cU5SU.BO.7OOtaqwBkdDp8viyiZnVqttKjhQu','user',NULL,'2026-04-21 02:03:36','2026-04-21 02:03:36'),
	(28,'tedo@tedo.com','tedo@tedo.com','0123365112',NULL,'$2y$12$i076CmJXzBUhly2JQyXJCO3yKNnLI00R7jtt9STYeGpmWO.ZuAkP.','user',NULL,'2026-04-23 22:52:42','2026-04-23 22:52:42'),
	(29,'adah@adah.com','adah@adah.com','0123365999',NULL,'$2y$12$sHyrgGMxLEMAkf.M9Sc2tOGw/KIe1Q2Wy5eD5sbh2NriUV4DLmsxS','user',NULL,'2026-04-23 23:00:41','2026-04-23 23:00:41'),
	(30,'iran@iran.com','iran@iran.com','2952135562',NULL,'$2y$12$jnV4OexwO4OblLVN6Tr/F.rUTk6KA4y9hRnPOUVe33DOjYob/44jy','user',NULL,'2026-04-24 09:43:04','2026-04-24 09:43:04'),
	(31,'ugas@test.com','ugas@test.com','0128865988',NULL,'$2y$12$iHkx68AizjJxoz0aSi9AheKRu6Yp0qOEORKVbnmLJjGoiqcLVSOA2','user',NULL,'2026-04-26 15:26:11','2026-04-26 15:26:11'),
	(32,'umar@test.com','umar@test.com','1119048231',NULL,'$2y$12$N2t0ebi8W8WI7v/BUPvBj.0O5TtidmEqKJpDBFSR6IX5ahCVsXTzW','user',NULL,'2026-04-27 05:33:04','2026-04-28 17:10:55');

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
