-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 15 Nov 2024 pada 03.53 -- Versi server: 10.4.32-MariaDB -- Versi PHP: 8.2.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `laravelspp` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `cache` -- CREATE TABLE `cache` ( `key` varchar(255) NOT NULL, `value` mediumtext NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `cache_locks` -- CREATE TABLE `cache_locks` ( `key` varchar(255) NOT NULL, `owner` varchar(255) NOT NULL, `expiration` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `class_rooms` -- CREATE TABLE `class_rooms` ( `id` bigint(20) UNSIGNED NOT NULL, `name_class` varchar(100) NOT NULL, `jurusan` varchar(50) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `class_rooms` -- INSERT INTO `class_rooms` (`id`, `name_class`, `jurusan`, `created_at`, `updated_at`) VALUES (1, 'Mesin A', 'Teknik Mesin', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (2, 'Mesin B', 'Teknik Mesin', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (3, 'Mesin C', 'Teknik Mesin', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (4, 'OTO A', 'Teknik Otomotif', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (5, 'OTO B', 'Teknik Otomotif', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (6, 'OTO C', 'Teknik Otomotif', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (7, 'RPL A', 'Rekayasa Perangkat Lunak', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (8, 'RPL B', 'Rekayasa Perangkat Lunak', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (9, 'RPL C', 'Rekayasa Perangkat Lunak', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (10, 'TPK A', 'Teknik Pembuatan Kain', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (11, 'TPK B', 'Teknik Pembuatan Kain', '2024-11-15 02:51:21', '2024-11-15 02:51:21'), (12, 'TPK C', 'Teknik Pembuatan Kain', '2024-11-15 02:51:21', '2024-11-15 02:51:21'); -- -------------------------------------------------------- -- -- Struktur dari tabel `configurations` -- CREATE TABLE `configurations` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `judul` varchar(100) NOT NULL, `alamat` varchar(255) NOT NULL, `phone` varchar(100) NOT NULL, `logo` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `configurations` -- INSERT INTO `configurations` (`id`, `name`, `email`, `judul`, `alamat`, `phone`, `logo`, `created_at`, `updated_at`) VALUES (1, 'SPPKU', 'smkbisa@gmail.com', 'PEMBAYARAN SPP', 'JL. Sriwijaya, Padangan, Jungke, Karanganyar, Jawa Tengah', '(0271)123456', 'defaut.png', '2024-11-15 02:51:22', '2024-11-15 02:51:22'); -- -------------------------------------------------------- -- -- Struktur dari tabel `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `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() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `jobs` -- CREATE TABLE `jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `job_batches` -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `migrations` -- CREATE TABLE `migrations` ( `id` int(10) UNSIGNED NOT NULL, `migration` varchar(255) NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `migrations` -- 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, '2024_05_20_222801_create_class_rooms_table', 1), (5, '2024_05_20_222802_create_students_table', 1), (6, '2024_05_27_121516_create_spps_table', 1), (7, '2024_05_27_123736_create_transactions_table', 1), (8, '2024_06_04_223535_create_configurations_table', 1), (9, '2024_10_16_080330_add_unique_to_name_class_in_class_rooms_table', 1); -- -------------------------------------------------------- -- -- Struktur dari tabel `password_reset_tokens` -- CREATE TABLE `password_reset_tokens` ( `email` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `sessions` -- 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 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `sessions` -- INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES ('CAuz4jwSQDyxgkgoHIL7etXU7IHUpeM3MXw1TPZJ', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiT05mdEFSVVFiOHNYMDdrZ21KY3J2VW9XbDBBT1EzeUxWZ0QxRVJUayI7czozOiJ1cmwiO2E6MTp7czo4OiJpbnRlbmRlZCI7czoyMToiaHR0cDovLzEyNy4wLjAuMTo4MDAwIjt9czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MjE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMCI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fX0=', 1731639100), ('ZsHVJfCUWZLgHI4e8ouSlMLOYZZBuuGUTFO7oMPp', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36', 'YTo2OntzOjY6Il90b2tlbiI7czo0MDoiWmVud3NwZG1RVFVSOEF0TmJucWhudjAyM2sxRjRYQklGdVJFaFVZUCI7czozOiJ1cmwiO2E6MDp7fXM6OToiX3ByZXZpb3VzIjthOjE6e3M6MzoidXJsIjtzOjI2OiJodHRwOi8vMTI3LjAuMC4xOjgwMDAvdXNlciI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MTg6ImZsYXNoZXI6OmVudmVsb3BlcyI7YTowOnt9czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1731639177); -- -------------------------------------------------------- -- -- Struktur dari tabel `spps` -- CREATE TABLE `spps` ( `id` bigint(20) UNSIGNED NOT NULL, `spp1` int(11) NOT NULL DEFAULT 0, `spp2` int(11) NOT NULL DEFAULT 0, `spp3` int(11) NOT NULL DEFAULT 0, `tahun_ajaran` varchar(100) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `spps` -- INSERT INTO `spps` (`id`, `spp1`, `spp2`, `spp3`, `tahun_ajaran`, `created_at`, `updated_at`) VALUES (1, 1200000, 1300000, 1800000, '2024/2025', '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (2, 1000000, 1200000, 1500000, '2023/2024', '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (3, 100000, 200000, 500000, '2022/2023', '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (4, 110000, 120000, 150000, '2021/2022', '2024-11-15 02:51:22', '2024-11-15 02:51:22'); -- -------------------------------------------------------- -- -- Struktur dari tabel `students` -- CREATE TABLE `students` ( `id` bigint(20) UNSIGNED NOT NULL, `nis` varchar(10) NOT NULL, `name` varchar(50) NOT NULL, `class_id` bigint(20) UNSIGNED NOT NULL, `gender` enum('Laki-Laki','Perempuan') NOT NULL, `telp` varchar(20) NOT NULL, `tahun_masuk` int(11) NOT NULL, `tanggal_lahir` date NOT NULL, `alamat` varchar(255) NOT NULL, `spp1` int(11) NOT NULL DEFAULT 0, `spp2` int(11) NOT NULL DEFAULT 0, `spp3` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `students` -- INSERT INTO `students` (`id`, `nis`, `name`, `class_id`, `gender`, `telp`, `tahun_masuk`, `tanggal_lahir`, `alamat`, `spp1`, `spp2`, `spp3`, `created_at`, `updated_at`) VALUES (1, '8178', 'Bagas Dwi Prasetyo', 11, 'Laki-Laki', '81235343', 2021, '2004-08-10', 'sas', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (2, '8603', 'Ardy Nur Saputra', 8, 'Laki-Laki', '81235343', 2022, '2007-01-05', 'kelaa', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (3, '8604', 'Bagas Mahardika Budiharto', 8, 'Laki-Laki', '81235343', 2022, '2007-08-10', 'Jungke', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (4, '8606', 'Deco Saputro', 8, 'Laki-Laki', '81235343', 2022, '2006-09-22', 'tegal', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (5, '8614', 'Filip Dwi Utomo', 8, 'Laki-Laki', '81235343', 2022, '2007-05-20', 'ploso', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (6, '9088', 'Muh Agung Permadi', 9, 'Laki-Laki', '81235343', 2023, '2007-07-22', 'jungke', 0, 0, 0, '2024-11-15 02:51:22', '2024-11-15 02:51:22'); -- -------------------------------------------------------- -- -- Struktur dari tabel `transactions` -- CREATE TABLE `transactions` ( `id` bigint(20) UNSIGNED NOT NULL, `nota` int(11) NOT NULL, `tahun_ajaran` varchar(100) NOT NULL, `tanggal_bayar` date NOT NULL, `student_id` bigint(20) UNSIGNED NOT NULL, `spp1` int(11) NOT NULL DEFAULT 0, `spp2` int(11) NOT NULL DEFAULT 0, `spp3` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `name` varchar(50) NOT NULL, `role` enum('Admin','Staff','Student') NOT NULL, `email` varchar(255) NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `remember_token` varchar(100) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `users` -- INSERT INTO `users` (`id`, `username`, `password`, `name`, `role`, `email`, `email_verified_at`, `remember_token`, `created_at`, `updated_at`) VALUES (1, 'admin', '$2y$12$Tw4zTjamPDacX3h7.bcYSOx6buigR0T6HMKS13F2dPxKC05l/Q5py', 'Bagas', 'Admin', 'bgs@gmail.com', '2024-11-15 02:51:21', '3afx9L9jGS', '2024-11-15 02:51:22', '2024-11-15 02:51:22'), (2, 'user', '$2y$12$/4qkVDGDj113J1If/Vz2geLXSbu1T0lnigxI7FsJv6jX.7avesuFe', 'Chiss', 'Staff', 'budi@gmail.com', '2024-11-15 02:51:22', 'QGPRPaKQPz', '2024-11-15 02:51:22', '2024-11-15 02:51:22'); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `cache` -- ALTER TABLE `cache` ADD PRIMARY KEY (`key`); -- -- Indeks untuk tabel `cache_locks` -- ALTER TABLE `cache_locks` ADD PRIMARY KEY (`key`); -- -- Indeks untuk tabel `class_rooms` -- ALTER TABLE `class_rooms` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `class_rooms_name_class_unique` (`name_class`); -- -- Indeks untuk tabel `configurations` -- ALTER TABLE `configurations` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`); -- -- Indeks untuk tabel `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indeks untuk tabel `job_batches` -- ALTER TABLE `job_batches` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `password_reset_tokens` -- ALTER TABLE `password_reset_tokens` ADD PRIMARY KEY (`email`); -- -- Indeks untuk tabel `sessions` -- ALTER TABLE `sessions` ADD PRIMARY KEY (`id`), ADD KEY `sessions_user_id_index` (`user_id`), ADD KEY `sessions_last_activity_index` (`last_activity`); -- -- Indeks untuk tabel `spps` -- ALTER TABLE `spps` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `students` -- ALTER TABLE `students` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `students_nis_unique` (`nis`), ADD KEY `class_id` (`class_id`); -- -- Indeks untuk tabel `transactions` -- ALTER TABLE `transactions` ADD PRIMARY KEY (`id`), ADD KEY `transactions_student_id` (`student_id`); -- -- Indeks untuk tabel `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_username_unique` (`username`), ADD UNIQUE KEY `users_email_unique` (`email`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `class_rooms` -- ALTER TABLE `class_rooms` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT untuk tabel `configurations` -- ALTER TABLE `configurations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `jobs` -- ALTER TABLE `jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10; -- -- AUTO_INCREMENT untuk tabel `spps` -- ALTER TABLE `spps` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `students` -- ALTER TABLE `students` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT untuk tabel `transactions` -- ALTER TABLE `transactions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `students` -- ALTER TABLE `students` ADD CONSTRAINT `class_id` FOREIGN KEY (`class_id`) REFERENCES `class_rooms` (`id`); -- -- Ketidakleluasaan untuk tabel `transactions` -- ALTER TABLE `transactions` ADD CONSTRAINT `transactions_student_id` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`); COMMIT; /*!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 */;