text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 10 Agu 2021 pada 05.06
  -- Versi server: 10.4.20-MariaDB
  -- Versi PHP: 7.3.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: `db_phdb`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `bobot`
  --
  
  CREATE TABLE `bobot` (
    `id_proposal` int(11) NOT NULL,
    `id_sub_kriteria` int(11) NOT NULL,
    `tahap` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `bobot` 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 `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 `kriteria`
  --
  
  CREATE TABLE `kriteria` (
    `id_kriteria` int(10) UNSIGNED NOT NULL,
    `nama_kriteria` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `tahap` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data untuk tabel `kriteria`
  --
  
  INSERT INTO `kriteria` (`id_kriteria`, `nama_kriteria`, `tahap`, `created_at`, `updated_at`) VALUES
  (1, 'kriteria 1 tahap 1', 'tahap1', '2021-08-09 16:27:47', '2021-08-09 16:27:47'),
  (2, 'kriteria 2 tahap 1', 'tahap1', '2021-08-09 16:28:12', '2021-08-09 16:28:12'),
  (3, 'kriteria 3 tahap 1', 'tahap1', '2021-08-09 16:28:30', '2021-08-09 16:28:30'),
  (4, 'kriteria 4 tahap 1', 'tahap1', '2021-08-09 16:28:30', '2021-08-09 16:28:30'),
  (5, 'kriteria 1 tahap 2', 'tahap2', '2021-08-09 16:28:30', '2021-08-09 16:28:30'),
  (6, 'kriteria 2 tahap 2', 'tahap2', '2021-08-09 16:28:30', '2021-08-09 16:28:30'),
  (7, 'kriteria 3 tahap 2', 'tahap2', '2021-08-09 16:28:30', '2021-08-09 16:28:30'),
  (8, 'kriteria 4 tahap 2', 'tahap2', '2021-08-09 16:39:36', '2021-08-09 16:39:36'),
  (9, 'kriteria 5 tahap 2', 'tahap2', '2021-08-09 16:39:36', '2021-08-09 16:39:36'),
  (10, 'kriteria 6 tahap 2', 'tahap2', '2021-08-09 16:39:36', '2021-08-09 16:39:36'),
  (11, 'kriteria 7 tahap 2', 'tahap2', '2021-08-09 16:39:36', '2021-08-09 16:39:36');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `laporan`
  --
  
  CREATE TABLE `laporan` (
    `id_laporan` int(10) UNSIGNED NOT NULL,
    `judul` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ketua_tim` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ormawa` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `laporan_akhir_pdf` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `laporan_akhir_word` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `laporan_keuangan` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `poster_phdb` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `profil_phdb` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `artikel` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `laporancol` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alamat_link` varchar(45) 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;
  
  --
  -- Dumping data untuk tabel `migrations`
  --
  
  INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
  (48, '2014_10_12_000000_create_users_table', 1),
  (49, '2014_10_12_100000_create_password_resets_table', 1),
  (50, '2019_08_19_000000_create_failed_jobs_table', 1),
  (51, '2021_07_09_162811_create_monev_table', 1),
  (52, '2021_07_09_163452_create_tahap1_table', 1),
  (53, '2021_07_09_163457_create_tahap2_table', 1),
  (54, '2021_07_09_164827_create_prodi_table', 1),
  (55, '2021_07_09_164902_create_laporan_table', 1),
  (56, '2021_07_09_164917_create_unduhan_table', 1),
  (57, '2021_07_09_164929_create_pengumuman_table', 1),
  (58, '2021_07_09_164949_create_register_table', 1),
  (59, '2021_07_12_063002_create_detail_kriteria_table', 2),
  (60, '2021_07_12_063346_create_penilaian_table', 2),
  (61, '2021_08_05_091330_create_revisi_table', 2),
  (62, '2021_08_05_092508_create_kriteria_table', 2),
  (64, '2021_08_05_092724_create_sub_kriteria_table', 3),
  (65, '2021_08_09_160955_create_bobot_table', 4);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `monev`
  --
  
  CREATE TABLE `monev` (
    `id_monev` int(10) UNSIGNED NOT NULL,
    `tahap1_idtahap1` int(11) NOT NULL,
    `tahap2_idtahap2` 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 `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `pengumuman`
  --
  
  CREATE TABLE `pengumuman` (
    `id_pengumuman` int(10) UNSIGNED NOT NULL,
    `judul` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ketua_tim` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `id_prodi` 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 `penilaian`
  --
  
  CREATE TABLE `penilaian` (
    `id_penilaian` int(10) UNSIGNED NOT NULL,
    `id_kriteria` int(11) NOT NULL,
    `id_sub_kriteria` int(11) NOT NULL,
    `id_register` int(11) NOT NULL,
    `note_revisi` int(11) NOT NULL,
    `status_revisi` int(11) NOT NULL,
    `tahap_revisi` 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 `prodi`
  --
  
  CREATE TABLE `prodi` (
    `id_prodi` int(10) UNSIGNED NOT NULL,
    `nama_prodi` 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 `prodi`
  --
  
  INSERT INTO `prodi` (`id_prodi`, `nama_prodi`, `created_at`, `updated_at`) VALUES
  (1, 'sistem informasi', '2021-07-09 12:14:02', '2021-07-09 12:14:02'),
  (2, 'Energi Terbarukan', '2021-07-09 12:18:37', '2021-07-09 12:18:37'),
  (3, 'Sipil Informatika', '2021-07-09 12:19:14', '2021-07-09 12:19:14');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `register`
  --
  
  CREATE TABLE `register` (
    `id_register` int(10) UNSIGNED NOT NULL,
    `judul` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ketua_tim` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ormawa` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `proposal` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nim` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status_register` 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;
  
  --
  -- Dumping data untuk tabel `register`
  --
  
  INSERT INTO `register` (`id_register`, `judul`, `ketua_tim`, `ormawa`, `proposal`, `nim`, `status_register`, `created_at`, `updated_at`) VALUES
  (3, 'proposal baru', 'alexander', 'kendo kenceng', 'public/files_proposal/rrdAlpf6E0yIsxcmYgWYI2ZDCAQOde380YOMmRKa.pdf', '121212', 1, '2021-07-09 14:43:36', '2021-07-09 14:43:36'),
  (5, 'proposal amal', 'ikromii', 'hijrah kuy', 'public/files_proposal/ByzTQwNJ0r8QtzXwht7hjZlxB9rOlP8oECjlJtyv.pdf', '191919', 0, '2021-07-09 16:04:12', '2021-07-09 16:04:12');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `sub_kriteria`
  --
  
  CREATE TABLE `sub_kriteria` (
    `id_sub_kriteria` int(10) UNSIGNED NOT NULL,
    `id_kriteria` int(11) NOT NULL,
    `nama_sub_kriteria` 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 `sub_kriteria`
  --
  
  INSERT INTO `sub_kriteria` (`id_sub_kriteria`, `id_kriteria`, `nama_sub_kriteria`, `created_at`, `updated_at`) VALUES
  (1, 1, 'sub 1 kr 1 tahap 1', NULL, NULL),
  (2, 1, 'sub 2 kr 1 tahap 1', NULL, NULL),
  (3, 2, 'sub 1 kr 2 tahap 1', NULL, NULL),
  (4, 2, 'sub 2 kr 2 tahap 1', NULL, NULL),
  (5, 2, 'sub 2 kr 3 tahap 1', NULL, NULL),
  (6, 2, 'sub 3 kr 2 tahap 1', NULL, NULL),
  (7, 2, 'sub 4 kr 2 tahap 1', NULL, NULL),
  (8, 3, 'sub 1 kr 3 tahap 1', NULL, NULL),
  (9, 3, 'sub 2 kr 3 tahap 1', NULL, NULL),
  (10, 4, 'sub 1 kr 4 tahap 1', NULL, NULL),
  (11, 5, 'sub 1 kr 1 tahap 2', NULL, NULL),
  (12, 6, 'sub 1 kr 2 tahap 2', NULL, NULL),
  (13, 7, 'sub 1 kr 3 tahap 2', NULL, NULL),
  (14, 8, 'sub 1 kr 4 tahap 2', NULL, NULL),
  (15, 9, 'sub 1 kr 5 tahap 2', NULL, NULL),
  (16, 10, 'sub 1 kr 6 tahap 2', NULL, NULL),
  (17, 11, 'sub 1 kr 7  tahap 2', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `unduhan`
  --
  
  CREATE TABLE `unduhan` (
    `id_unduhan` int(10) UNSIGNED NOT NULL,
    `buku_pedoman` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `lampiran` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `laporan` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
    `poster` varchar(45) 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 `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nim` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `idlaporan` int(11) DEFAULT NULL,
    `idprodi` int(11) DEFAULT NULL,
    `idunduhan` int(11) DEFAULT NULL,
    `idpengumuman` int(11) DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `role` int(11) NOT NULL,
    `remember_token` varchar(100) 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;
  
  --
  -- Dumping data untuk tabel `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `nim`, `email`, `email_verified_at`, `idlaporan`, `idprodi`, `idunduhan`, `idpengumuman`, `password`, `role`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'dipta ikromi m', '123456', 'mdipta45@gmail.com', NULL, NULL, 0, NULL, NULL, '$2y$10$0j3h1lUzkX3F8YNh1DaHG.vRp2uaIcnj8/weYjA8nfHrWPj.QnYVa', 1, NULL, '2021-07-09 11:06:01', '2021-07-09 11:06:01'),
  (2, 'alexander', '121212', 'alex@gmail.com', NULL, NULL, 2, NULL, NULL, '$2y$10$a3oXgAtD1Uygrn2mUjWuyOb021/4YVEUPsJ4wVeIWUvtzchpnmS/y', 2, NULL, '2021-07-09 12:31:45', '2021-07-09 12:31:45'),
  (3, 'ikrome', '131313', 'ikrome@gmail.com', NULL, NULL, 2, NULL, NULL, '$2y$10$45PySNIMTExIqyadR9l/5ux2wetwHM4lvQkHgm0pgqqdhGfn4Sjo2', 2, NULL, '2021-07-09 12:34:01', '2021-07-09 12:34:01'),
  (4, 'coba', '141414', 'Vince@gmail.com', NULL, NULL, 3, NULL, NULL, '$2y$10$6UWMrr0PDRwFEcRRk1aIe.NjpGeKw2reIrCVRVXGVMNHQK/KrpNsS', 2, NULL, '2021-07-09 12:36:31', '2021-07-09 12:36:31'),
  (5, 'reviewer1', '1234567', 'admin@gmail.com', NULL, NULL, 1, NULL, NULL, '$2y$10$Z8XVWWFtwjnR9.jI7oI32.kcIjHk7qbIQeGl8eOLm3uVqWemvAD5W', 2, NULL, '2021-07-09 12:39:29', '2021-07-09 12:39:29'),
  (6, 'reviewer', '414141', 'ikee@gmail.com', NULL, NULL, NULL, NULL, NULL, '$2y$10$o7TajSiNj6D3Pg47izxGc.RDs.k3bQ.fByLbuToiAMEQN1YE0wWLe', 3, NULL, '2021-07-09 12:47:27', '2021-07-09 12:47:27'),
  (7, 'siswa', '191919', 'siswa@gmail.com', NULL, NULL, 2, NULL, NULL, '$2y$10$JjUK8sgvWWXvgF4xMvBYvepRfM/hr.6ZBevPGW8Gtjwy7fLqJxBSO', 2, NULL, '2021-07-09 16:03:40', '2021-07-09 16:03:40');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
  
  --
  -- Indeks untuk tabel `kriteria`
  --
  ALTER TABLE `kriteria`
    ADD PRIMARY KEY (`id_kriteria`);
  
  --
  -- Indeks untuk tabel `laporan`
  --
  ALTER TABLE `laporan`
    ADD PRIMARY KEY (`id_laporan`);
  
  --
  -- Indeks untuk tabel `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `monev`
  --
  ALTER TABLE `monev`
    ADD PRIMARY KEY (`id_monev`);
  
  --
  -- Indeks untuk tabel `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indeks untuk tabel `pengumuman`
  --
  ALTER TABLE `pengumuman`
    ADD PRIMARY KEY (`id_pengumuman`);
  
  --
  -- Indeks untuk tabel `penilaian`
  --
  ALTER TABLE `penilaian`
    ADD PRIMARY KEY (`id_penilaian`);
  
  --
  -- Indeks untuk tabel `prodi`
  --
  ALTER TABLE `prodi`
    ADD PRIMARY KEY (`id_prodi`);
  
  --
  -- Indeks untuk tabel `register`
  --
  ALTER TABLE `register`
    ADD PRIMARY KEY (`id_register`);
  
  --
  -- Indeks untuk tabel `sub_kriteria`
  --
  ALTER TABLE `sub_kriteria`
    ADD PRIMARY KEY (`id_sub_kriteria`);
  
  --
  -- Indeks untuk tabel `unduhan`
  --
  ALTER TABLE `unduhan`
    ADD PRIMARY KEY (`id_unduhan`);
  
  --
  -- Indeks untuk tabel `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_nim_unique` (`nim`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT untuk tabel yang dibuang
  --
  
  --
  -- AUTO_INCREMENT untuk tabel `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `kriteria`
  --
  ALTER TABLE `kriteria`
    MODIFY `id_kriteria` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
  
  --
  -- AUTO_INCREMENT untuk tabel `laporan`
  --
  ALTER TABLE `laporan`
    MODIFY `id_laporan` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;
  
  --
  -- AUTO_INCREMENT untuk tabel `monev`
  --
  ALTER TABLE `monev`
    MODIFY `id_monev` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `pengumuman`
  --
  ALTER TABLE `pengumuman`
    MODIFY `id_pengumuman` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `penilaian`
  --
  ALTER TABLE `penilaian`
    MODIFY `id_penilaian` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `prodi`
  --
  ALTER TABLE `prodi`
    MODIFY `id_prodi` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT untuk tabel `register`
  --
  ALTER TABLE `register`
    MODIFY `id_register` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT untuk tabel `sub_kriteria`
  --
  ALTER TABLE `sub_kriteria`
    MODIFY `id_sub_kriteria` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
  
  --
  -- AUTO_INCREMENT untuk tabel `unduhan`
  --
  ALTER TABLE `unduhan`
    MODIFY `id_unduhan` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `users`
  --
  ALTER TABLE `users`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  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 */;
  