-- phpMyAdmin SQL Dump -- version 5.1.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 20 Feb 2023 pada 01.35 -- Versi server: 10.4.24-MariaDB -- Versi PHP: 7.4.29 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: `cbtmalela_laravel8` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `admins` -- CREATE TABLE `admins` ( `id` bigint(20) UNSIGNED NOT NULL, `nama_admin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` int(11) NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `detail_essay` -- CREATE TABLE `detail_essay` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `soal` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `detail_ujian` -- CREATE TABLE `detail_ujian` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `soal` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `pg_1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pg_2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pg_3` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pg_4` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `pg_5` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jawaban` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `email_settings` -- CREATE TABLE `email_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `notif_akun` int(11) NOT NULL DEFAULT 1, `notif_materi` int(11) NOT NULL DEFAULT 1, `notif_tugas` int(11) NOT NULL DEFAULT 1, `notif_ujian` int(11) NOT NULL DEFAULT 1, `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 `email_settings` -- INSERT INTO `email_settings` (`id`, `notif_akun`, `notif_materi`, `notif_tugas`, `notif_ujian`, `created_at`, `updated_at`) VALUES (1, 0, 0, 0, 0, '2022-11-14 17:00:00', '2022-11-15 09:57:50'); -- -------------------------------------------------------- -- -- Struktur dari tabel `essay_siswa` -- CREATE TABLE `essay_siswa` ( `id` bigint(20) UNSIGNED NOT NULL, `detail_ujian_id` int(11) NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siswa_id` int(11) NOT NULL, `jawaban` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ragu` tinyint(1) DEFAULT NULL, `nilai` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED NOT NULL, `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() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `files` -- CREATE TABLE `files` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `guru` -- CREATE TABLE `guru` ( `id` bigint(20) UNSIGNED NOT NULL, `nama_guru` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` int(11) NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `gurukelas` -- CREATE TABLE `gurukelas` ( `id` bigint(20) UNSIGNED NOT NULL, `guru_id` int(11) NOT NULL, `kelas_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `gurumapel` -- CREATE TABLE `gurumapel` ( `id` bigint(20) UNSIGNED NOT NULL, `guru_id` int(11) NOT NULL, `mapel_id` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) 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) COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext COLLATE utf8mb4_unicode_ci 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 `kelas` -- CREATE TABLE `kelas` ( `id` bigint(20) UNSIGNED NOT NULL, `nama_kelas` varchar(255) COLLATE utf8mb4_unicode_ci 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 `kelas` -- INSERT INTO `kelas` (`id`, `nama_kelas`, `created_at`, `updated_at`) VALUES (1, 'X-IPS-1', NULL, NULL), (2, 'X-IPS-2', NULL, NULL), (3, 'X-IPS-3', NULL, NULL); -- -------------------------------------------------------- -- -- Struktur dari tabel `mapel` -- CREATE TABLE `mapel` ( `id` bigint(20) UNSIGNED NOT NULL, `nama_mapel` varchar(255) COLLATE utf8mb4_unicode_ci 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 `mapel` -- INSERT INTO `mapel` (`id`, `nama_mapel`, `created_at`, `updated_at`) VALUES (1, 'Bahasa Indonesia', NULL, NULL), (2, 'Matematika', NULL, NULL), (3, 'Fisika', NULL, NULL); -- -------------------------------------------------------- -- -- Struktur dari tabel `materi` -- CREATE TABLE `materi` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `guru_id` int(11) NOT NULL, `kelas_id` int(11) NOT NULL, `mapel_id` int(11) NOT NULL, `nama_materi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `teks` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL 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) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `notifications` -- CREATE TABLE `notifications` ( `id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siswa_id` int(11) NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `pg_siswa` -- CREATE TABLE `pg_siswa` ( `id` bigint(20) UNSIGNED NOT NULL, `detail_ujian_id` int(11) NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siswa_id` int(11) NOT NULL, `jawaban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `benar` tinyint(1) DEFAULT NULL, `ragu` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `siswa` -- CREATE TABLE `siswa` ( `id` bigint(20) UNSIGNED NOT NULL, `nis` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama_siswa` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `gender` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `kelas_id` int(11) NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` int(11) NOT NULL, `is_active` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `tokens` -- CREATE TABLE `tokens` ( `id` bigint(20) UNSIGNED NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `tugas` -- CREATE TABLE `tugas` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `guru_id` int(11) NOT NULL, `kelas_id` int(11) NOT NULL, `mapel_id` int(11) NOT NULL, `nama_tugas` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `teks` longtext COLLATE utf8mb4_unicode_ci NOT NULL, `due_date` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `tugas_siswa` -- CREATE TABLE `tugas_siswa` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siswa_id` int(11) NOT NULL, `teks` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_send` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_telat` tinyint(1) DEFAULT NULL, `nilai` int(11) DEFAULT NULL, `catatan_guru` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `ujian` -- CREATE TABLE `ujian` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `jenis` int(11) NOT NULL, `guru_id` int(11) NOT NULL, `kelas_id` int(11) NOT NULL, `mapel_id` int(11) NOT NULL, `jam` int(11) NOT NULL, `menit` int(11) NOT NULL, `acak` int(11) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `userchat` -- CREATE TABLE `userchat` ( `id` bigint(20) UNSIGNED NOT NULL, `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `chat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `waktu_ujian` -- CREATE TABLE `waktu_ujian` ( `id` bigint(20) UNSIGNED NOT NULL, `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siswa_id` int(11) NOT NULL, `waktu_berakhir` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `selesai` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `admins` -- ALTER TABLE `admins` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `admins_email_unique` (`email`); -- -- Indeks untuk tabel `detail_essay` -- ALTER TABLE `detail_essay` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `detail_ujian` -- ALTER TABLE `detail_ujian` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `email_settings` -- ALTER TABLE `email_settings` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `essay_siswa` -- ALTER TABLE `essay_siswa` 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 `files` -- ALTER TABLE `files` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `guru` -- ALTER TABLE `guru` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `guru_email_unique` (`email`); -- -- Indeks untuk tabel `gurukelas` -- ALTER TABLE `gurukelas` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `gurumapel` -- ALTER TABLE `gurumapel` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `jobs` -- ALTER TABLE `jobs` ADD PRIMARY KEY (`id`), ADD KEY `jobs_queue_index` (`queue`); -- -- Indeks untuk tabel `kelas` -- ALTER TABLE `kelas` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `mapel` -- ALTER TABLE `mapel` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `materi` -- ALTER TABLE `materi` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `notifications` -- ALTER TABLE `notifications` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `pg_siswa` -- ALTER TABLE `pg_siswa` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `siswa` -- ALTER TABLE `siswa` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `siswa_nis_unique` (`nis`), ADD UNIQUE KEY `siswa_email_unique` (`email`); -- -- Indeks untuk tabel `tokens` -- ALTER TABLE `tokens` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `tugas` -- ALTER TABLE `tugas` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `tugas_siswa` -- ALTER TABLE `tugas_siswa` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `ujian` -- ALTER TABLE `ujian` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `userchat` -- ALTER TABLE `userchat` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `waktu_ujian` -- ALTER TABLE `waktu_ujian` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `admins` -- ALTER TABLE `admins` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `detail_essay` -- ALTER TABLE `detail_essay` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `detail_ujian` -- ALTER TABLE `detail_ujian` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `email_settings` -- ALTER TABLE `email_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT untuk tabel `essay_siswa` -- ALTER TABLE `essay_siswa` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `files` -- ALTER TABLE `files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `guru` -- ALTER TABLE `guru` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `gurukelas` -- ALTER TABLE `gurukelas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `gurumapel` -- ALTER TABLE `gurumapel` 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 `kelas` -- ALTER TABLE `kelas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `mapel` -- ALTER TABLE `mapel` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT untuk tabel `materi` -- ALTER TABLE `materi` 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 untuk tabel `notifications` -- ALTER TABLE `notifications` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `pg_siswa` -- ALTER TABLE `pg_siswa` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `siswa` -- ALTER TABLE `siswa` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `tokens` -- ALTER TABLE `tokens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `tugas` -- ALTER TABLE `tugas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `tugas_siswa` -- ALTER TABLE `tugas_siswa` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `ujian` -- ALTER TABLE `ujian` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `userchat` -- ALTER TABLE `userchat` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `waktu_ujian` -- ALTER TABLE `waktu_ujian` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; 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 */;