-- MariaDB dump 10.19 Distrib 10.4.32-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: spp_single -- ------------------------------------------------------ -- Server version 10.4.32-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `spp_single` -- /*!40000 DROP DATABASE IF EXISTS `spp_single`*/; CREATE DATABASE /*!32312 IF NOT EXISTS*/ `spp_single` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */; USE `spp_single`; -- -- Table structure for table `activity_logs` -- DROP TABLE IF EXISTS `activity_logs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity_logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned DEFAULT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `user_nama` varchar(255) DEFAULT NULL, `aksi` varchar(255) NOT NULL, `objek` varchar(255) NOT NULL, `deskripsi` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `activity_logs_school_id_index` (`school_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_logs` -- LOCK TABLES `activity_logs` WRITE; /*!40000 ALTER TABLE `activity_logs` DISABLE KEYS */; INSERT INTO `activity_logs` VALUES (1,1,1,'Administrator','dibuat','Siswa','Uji Runtime (9001)','2026-07-09 10:10:33','2026-07-09 10:10:33'); /*!40000 ALTER TABLE `activity_logs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache` -- DROP TABLE IF EXISTS `cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache` -- LOCK TABLES `cache` WRITE; /*!40000 ALTER TABLE `cache` DISABLE KEYS */; /*!40000 ALTER TABLE `cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cache_locks` -- DROP TABLE IF EXISTS `cache_locks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cache_locks` -- LOCK TABLES `cache_locks` WRITE; /*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */; /*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `failed_jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `uuid` varchar(255) NOT NULL, `connection` text NOT NULL, `queue` text NOT NULL, `payload` longtext NOT NULL, `exception` longtext 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `job_batches` -- DROP TABLE IF EXISTS `job_batches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `job_batches` ( `id` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `total_jobs` int(11) NOT NULL, `pending_jobs` int(11) NOT NULL, `failed_jobs` int(11) NOT NULL, `failed_job_ids` longtext NOT NULL, `options` mediumtext DEFAULT NULL, `cancelled_at` int(11) DEFAULT NULL, `created_at` int(11) NOT NULL, `finished_at` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `job_batches` -- LOCK TABLES `job_batches` WRITE; /*!40000 ALTER TABLE `job_batches` DISABLE KEYS */; /*!40000 ALTER TABLE `job_batches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jobs` -- DROP TABLE IF EXISTS `jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `jobs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `queue` varchar(255) NOT NULL, `payload` longtext NOT NULL, `attempts` tinyint(3) unsigned NOT NULL, `reserved_at` int(10) unsigned DEFAULT NULL, `available_at` int(10) unsigned NOT NULL, `created_at` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `jobs_queue_index` (`queue`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jobs` -- LOCK TABLES `jobs` WRITE; /*!40000 ALTER TABLE `jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` 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_01_01_000010_create_schools_table',1),(5,'2026_01_01_000020_create_students_table',1),(6,'2026_01_01_000030_create_payments_table',1),(7,'2026_01_01_000040_create_payment_items_table',1),(8,'2026_01_01_000070_add_wa_sekolah_to_schools',1),(9,'2026_01_01_000080_add_qris_and_payment_confirmations',1),(10,'2026_01_01_000090_create_activity_logs_table',1); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset_tokens` -- DROP TABLE IF EXISTS `password_reset_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset_tokens` -- LOCK TABLES `password_reset_tokens` WRITE; /*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_confirmations` -- DROP TABLE IF EXISTS `payment_confirmations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payment_confirmations` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned NOT NULL, `student_id` bigint(20) unsigned NOT NULL, `nama_pengirim` varchar(255) NOT NULL, `jumlah` bigint(20) unsigned NOT NULL, `metode` varchar(255) NOT NULL DEFAULT 'qris', `bukti` varchar(255) DEFAULT NULL, `catatan` text DEFAULT NULL, `status` varchar(255) NOT NULL DEFAULT 'pending', `catatan_admin` text DEFAULT NULL, `handled_by` bigint(20) unsigned DEFAULT NULL, `handled_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payment_confirmations_school_id_index` (`school_id`), KEY `payment_confirmations_student_id_index` (`student_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_confirmations` -- LOCK TABLES `payment_confirmations` WRITE; /*!40000 ALTER TABLE `payment_confirmations` DISABLE KEYS */; /*!40000 ALTER TABLE `payment_confirmations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment_items` -- DROP TABLE IF EXISTS `payment_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payment_items` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned NOT NULL, `payment_id` bigint(20) unsigned NOT NULL, `jenis` varchar(255) NOT NULL, `bulan` varchar(255) DEFAULT NULL, `slot` tinyint(3) unsigned DEFAULT NULL, `nama_jenis` varchar(255) NOT NULL, `jumlah` bigint(20) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `payment_items_school_id_foreign` (`school_id`), KEY `payment_items_payment_id_foreign` (`payment_id`), KEY `payment_items_jenis_bulan_index` (`jenis`,`bulan`), KEY `payment_items_slot_index` (`slot`), CONSTRAINT `payment_items_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE, CONSTRAINT `payment_items_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment_items` -- LOCK TABLES `payment_items` WRITE; /*!40000 ALTER TABLE `payment_items` DISABLE KEYS */; INSERT INTO `payment_items` VALUES (1,1,1,'spp','Juli',NULL,'SPP Juli',150000,'2026-07-09 10:07:03','2026-07-09 10:07:03'),(2,1,1,'spp','Agustus',NULL,'SPP Agustus',150000,'2026-07-09 10:07:03','2026-07-09 10:07:03'),(3,1,1,'tunggakan',NULL,NULL,'Angsuran Tunggakan',50000,'2026-07-09 10:07:03','2026-07-09 10:07:03'); /*!40000 ALTER TABLE `payment_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payments` -- DROP TABLE IF EXISTS `payments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `payments` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned NOT NULL, `no_transaksi` varchar(255) NOT NULL, `student_id` bigint(20) unsigned NOT NULL, `tanggal` date NOT NULL, `tahun_pelajaran` varchar(255) DEFAULT NULL, `total` bigint(20) NOT NULL DEFAULT 0, `bendahara` varchar(255) DEFAULT NULL, `catatan` varchar(255) DEFAULT NULL, `petugas` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `payments_school_id_no_transaksi_unique` (`school_id`,`no_transaksi`), KEY `payments_student_id_foreign` (`student_id`), CONSTRAINT `payments_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE, CONSTRAINT `payments_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payments` -- LOCK TABLES `payments` WRITE; /*!40000 ALTER TABLE `payments` DISABLE KEYS */; INSERT INTO `payments` VALUES (1,1,'TRX-20260701-0001',1,'2026-07-01','2025/2026',350000,'Siti Aminah, S.Pd',NULL,'admin','2026-07-09 10:07:03','2026-07-09 10:07:03'); /*!40000 ALTER TABLE `payments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `schools` -- DROP TABLE IF EXISTS `schools`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `schools` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(255) DEFAULT NULL, `nama_sekolah` varchar(255) NOT NULL, `alamat` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `telepon` varchar(255) DEFAULT NULL, `wa_sekolah` varchar(255) DEFAULT NULL, `kota` varchar(255) DEFAULT NULL, `tahun_pelajaran` varchar(255) NOT NULL DEFAULT '2025/2026', `logo` varchar(255) DEFAULT NULL, `qris` varchar(255) DEFAULT NULL, `bank_bayar` varchar(255) DEFAULT NULL, `norek_bayar` varchar(255) DEFAULT NULL, `atasnama_bayar` varchar(255) DEFAULT NULL, `bendahara` varchar(255) DEFAULT NULL, `nip_bendahara` varchar(255) DEFAULT NULL, `tarif_spp` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya1_nama` varchar(255) NOT NULL DEFAULT 'Uang Gedung', `lainnya2_nama` varchar(255) NOT NULL DEFAULT 'Uang Kegiatan', `lainnya3_nama` varchar(255) NOT NULL DEFAULT 'Seragam', `lainnya4_nama` varchar(255) NOT NULL DEFAULT 'Buku Paket', `lainnya5_nama` varchar(255) NOT NULL DEFAULT 'Uang Ujian', `lainnya6_nama` varchar(255) NOT NULL DEFAULT 'Study Tour', `lainnya1_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya2_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya3_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya4_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya5_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `lainnya6_tarif` bigint(20) unsigned NOT NULL DEFAULT 0, `wa_template` text 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `schools` -- LOCK TABLES `schools` WRITE; /*!40000 ALTER TABLE `schools` DISABLE KEYS */; INSERT INTO `schools` VALUES (1,'sekolah','SMP TUNAS BANGSA','Jl. Pendidikan No. 120, Jakarta','info@tunasbangsa.sch.id','021-1234567','6281234500001','Jakarta','2025/2026',NULL,NULL,NULL,NULL,NULL,'Siti Aminah, S.Pd','19850101 200901 2 001',150000,'Uang Gedung','Uang Kegiatan','Seragam','Buku Paket','Uang Ujian','Study Tour',1500000,500000,750000,600000,300000,850000,'Yth. Orang Tua/Wali dari *{nama}* (Kelas {kelas}),\n\nKami informasikan tagihan pembayaran di *{sekolah}*:\n{rincian}\n\nTotal tunggakan: *{total}*\n\nMohon dapat segera diselesaikan. Terima kasih.','2026-07-09 10:07:03','2026-07-09 10:07:03'); /*!40000 ALTER TABLE `schools` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sessions` -- DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( `id` varchar(255) NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `ip_address` varchar(45) DEFAULT NULL, `user_agent` text DEFAULT NULL, `payload` longtext NOT NULL, `last_activity` int(11) 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sessions` -- LOCK TABLES `sessions` WRITE; /*!40000 ALTER TABLE `sessions` DISABLE KEYS */; INSERT INTO `sessions` VALUES ('3BUHqBx5CDGJTQBQDa9r35KSAj8Afxhe4fVQuAvn',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZFVucU1wclZsVVpJSDYwYVpkdDNUcktKcEVhcVJ1Z1d6R2tLUU96aCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wb3J0YWwiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591752),('4A95eDFJzAEYndWaYc7Or6Agz4gvjiJhGjKmBXm9',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiamJpVFUwS0p0eFozNENwcnJvUjh4NDNiVVA4cXlYNlJSWkpmRjl0TyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjk6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9rYXJ0dS8xIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591729),('8zMsD7t7DGN6UgZ2N9B6JKdzajsMktsJqJmteuNJ',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiOWt4NGVxYVdpMGFIN1Boem0wUFAxa0RIeUdmR0JFYXlRRWh5RXlMSSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591647),('a5mF5E09BCNUSYIIFNMrU6YIaQCE9ZPwncbUWjTD',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiMDhscTVTdnBRUkduWk1qT0dQVU9tdVN1akJ2UHdhbHR1SkJFQ3FEMSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591645),('ATCOjKK5yVAxdyGi8AQD8cUZlHpT0FoUjI88jprk',2,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoidG1RUkl5MGVxemhEMTVsWTJBVENxZlFUR0dDU05LUU51dUkxZTRUNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9kYXNoYm9hcmQiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX1zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToyO30=',1783591755),('Cpsg4clPoou3znLt6uh6LdUFEmE2a7YqzRugbi88',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiR283NFNnSDh6ekczMUVGaEc3Rkg4enhyYzZNMUtTdldzYU4wUXdkdSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzQ6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC92ZXJpZmlrYXNpLzEiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591753),('fht2MoVJL1BMtRYBDvWiFTvUPDT3PSVk0V0iTNMp',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiaDlCWm82Y3NuYUZwWkpPWE9oTmtYZHJRSVhyRnJjSTFYTk9KWjExSyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjg6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wb3J0YWwiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19',1783591646),('mfCo95RZMtvLcb1sXn3QSeCBftfV2lZyvAABzVz4',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoieEhvM25sUWJacDAzQWpDTWZVNVZ5RTFnb1Zqd0VBZ05OQnRQOW5PTyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NDc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9wZW1iYXlhcmFuL2JhY2t1cC1sZW5na2FwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591754),('MIzAirxJCIj1LxMBnJaToLjXirIvq5IuXAi01eM2',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiZVlVM1Yya3J0eVhhbDhuYWgyOGt5SkRNOXVvRzFVRE9GMnVwV2ZENyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591646),('qu4nriujCKycSMwgZoqZOjy2tUnxydApqxyn4Iwb',NULL,'127.0.0.1','curl/8.6.0','YTozOntzOjY6Il90b2tlbiI7czo0MDoiQ0Y5d2lsMlRjbmt0T0NneERleFBzUGQ0WUp1cmFnRFhNMFZXbUZuNyI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6Mjc6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2dpbiI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=',1783591722),('wPqM80gmtSMfz4ZB75vA8wBEzqcOuAZLlBwW78mF',1,'127.0.0.1','curl/8.6.0','YTo0OntzOjY6Il90b2tlbiI7czo0MDoiOFdFeER4MG5XanNLc09xdHEzaTBtakhWS0VYS1VWbUdPZktkRkxzQiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzU6Imh0dHA6Ly8xMjcuMC4wLjE6ODMwMC9sb2ctYWt0aXZpdGFzIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9',1783591834); /*!40000 ALTER TABLE `sessions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `students` -- DROP TABLE IF EXISTS `students`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `students` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned NOT NULL, `no_induk` varchar(255) NOT NULL, `nama` varchar(255) NOT NULL, `kelas` varchar(255) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `tunggakan_awal` bigint(20) unsigned NOT NULL DEFAULT 0, `wa_ortu` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `students_school_id_no_induk_unique` (`school_id`,`no_induk`), CONSTRAINT `students_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `students` -- LOCK TABLES `students` WRITE; /*!40000 ALTER TABLE `students` DISABLE KEYS */; INSERT INTO `students` VALUES (1,1,'2025001','Andi Pratama','7A','Umum',300000,'6281234567001','2026-07-09 10:07:03','2026-07-09 10:07:03'),(2,1,'2025002','Bella Safitri','7A','Umum',0,'6281234567002','2026-07-09 10:07:03','2026-07-09 10:07:03'),(3,1,'2025003','Citra Dewi','7B','Yayasan',150000,'6281234567003','2026-07-09 10:07:03','2026-07-09 10:07:03'),(4,1,'2025004','Dimas Anggara','8A','Umum',0,'6281234567004','2026-07-09 10:07:03','2026-07-09 10:07:03'),(5,1,'2025005','Eka Putri','8B','Beasiswa',0,'6281234567005','2026-07-09 10:07:03','2026-07-09 10:07:03'),(6,1,'2025006','Fajar Nugroho','9A','Umum',450000,'6281234567006','2026-07-09 10:07:03','2026-07-09 10:07:03'); /*!40000 ALTER TABLE `students` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `school_id` bigint(20) unsigned DEFAULT NULL, `role` varchar(255) NOT NULL DEFAULT 'admin', `name` varchar(255) NOT NULL, `username` varchar(255) NOT NULL, `email` varchar(255) DEFAULT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) NOT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_username_unique` (`username`), KEY `users_school_id_index` (`school_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,1,'admin','Administrator','admin','admin@tunasbangsa.sch.id',NULL,'$2y$12$vFl4AbmbX8lX5l7c3Ciwn.viaiFOblIGbgpMWQ7Wvmk85xB03LCe2',NULL,'2026-07-09 10:07:03','2026-07-09 10:07:03'),(2,1,'petugas','Petugas Loket','petugas',NULL,NULL,'$2y$12$zhVgDeQjciY/JejiKj6F2uyeZ9zdlMwBXx5igr5KB3BECMduKi4cK',NULL,'2026-07-09 10:07:03','2026-07-09 10:07:03'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-07-09 17:22:01