text: -- phpMyAdmin SQL Dump
  -- version 5.1.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 30 Sep 2021 pada 03.24
  -- Versi server: 10.4.20-MariaDB
  -- Versi PHP: 7.4.22
  
  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: `spk_pm_employee`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `aspeks`
  --
  
  CREATE TABLE `aspeks` (
    `id_aspek` int(11) NOT NULL,
    `aspek` varchar(50) NOT NULL,
    `prosentase` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `aspeks`
  --
  
  INSERT INTO `aspeks` (`id_aspek`, `aspek`, `prosentase`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 'Aspek Kondisi', 80, '2021-09-18 02:52:35', '2021-09-18 02:52:35', NULL),
  (2, 'Aspek Sikap', 20, '2021-09-18 02:52:46', '2021-09-18 02:52:46', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `faktors`
  --
  
  CREATE TABLE `faktors` (
    `id_faktor` int(11) NOT NULL,
    `id_aspek` int(11) NOT NULL,
    `faktor` varchar(50) NOT NULL,
    `nilai_sub` int(11) NOT NULL,
    `kelompok` varchar(30) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `faktors`
  --
  
  INSERT INTO `faktors` (`id_faktor`, `id_aspek`, `faktor`, `nilai_sub`, `kelompok`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, 1, 'Memiliki KIS atau KPS', 4, 'Core', '2021-09-18 03:01:01', '2021-09-18 03:01:01', NULL),
  (2, 1, 'Tidak Memiliki KIS atau KPS', 2, 'Core', '2021-09-18 03:01:17', '2021-09-18 03:01:17', NULL),
  (3, 1, 'Yatim Piatu', 4, 'Core', '2021-09-18 03:02:18', '2021-09-18 03:02:18', NULL),
  (4, 1, 'Yatim atau Piatu', 3, 'Core', '2021-09-18 03:02:39', '2021-09-18 03:02:39', NULL),
  (5, 1, 'Masih Lengkap', 2, 'Core', '2021-09-18 03:03:00', '2021-09-18 03:03:00', NULL),
  (6, 1, 'Peserta Didik Berkebutuhan Khusus', 4, 'Core', '2021-09-18 03:03:33', '2021-09-18 03:03:33', NULL),
  (7, 1, 'Peserta Didik Tidak Berkebutuhan Khusus', 2, 'Core', '2021-09-18 03:05:00', '2021-09-18 03:05:00', NULL),
  (8, 1, 'Tempat Tinggal Panti Asuhan', 4, 'Secondary', '2021-09-18 03:05:37', '2021-09-18 03:05:37', NULL),
  (9, 1, 'Tempat Tinggal Bersama Wali', 3, 'Secondary', '2021-09-18 03:05:55', '2021-09-18 03:07:16', NULL),
  (10, 1, 'Tempat Tinggal Bersama Orang tua', 2, 'Secondary', '2021-09-18 03:06:10', '2021-09-18 03:06:10', NULL),
  (11, 2, 'Kesopanan Sangat Baik', 4, 'Core', '2021-09-18 03:08:31', '2021-09-18 03:08:31', NULL),
  (12, 2, 'Kesopanan Baik', 3, 'Core', '2021-09-18 03:08:46', '2021-09-18 03:08:46', NULL),
  (13, 2, 'Kesopanan Cukup', 2, 'Core', '2021-09-18 03:09:06', '2021-09-18 03:09:06', NULL),
  (14, 2, 'Kesopanan Kurang', 1, 'Core', '2021-09-18 03:09:20', '2021-09-18 03:09:20', NULL),
  (15, 2, 'Tingkah Laku Sangat Baik', 4, 'Secondary', '2021-09-18 03:09:43', '2021-09-18 03:09:43', NULL),
  (16, 2, 'Tingkah Laku Baik', 3, 'Secondary', '2021-09-18 03:10:00', '2021-09-18 03:10:00', NULL),
  (17, 2, 'Tingkah Laku Cukup', 2, 'Secondary', '2021-09-18 03:10:18', '2021-09-18 03:10:18', NULL),
  (18, 2, 'Tingkah Laku Kurang', 1, 'Secondary', '2021-09-18 03:10:33', '2021-09-18 03:10:33', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `gaps`
  --
  
  CREATE TABLE `gaps` (
    `id_gap` int(11) NOT NULL,
    `selisih` decimal(6,2) NOT NULL,
    `bobot` decimal(6,2) NOT NULL,
    `keterangan` text NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `gaps`
  --
  
  INSERT INTO `gaps` (`id_gap`, `selisih`, `bobot`, `keterangan`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (1, '0.00', '5.00', 'Tidak Ada Selisih (Kompetensi sesuai dengan yang dibutuhkan)', '2021-09-18 03:11:25', '2021-09-18 03:11:25', NULL),
  (2, '1.00', '4.50', 'Kompetensi Individu kelebihan 1 tingkat atau level', '2021-09-18 23:33:14', '2021-09-18 23:33:14', NULL),
  (3, '-1.00', '4.00', 'Kompetensi Individu kekurangan 1 tingkat atau level', '2021-09-18 23:36:23', '2021-09-18 23:36:23', NULL),
  (4, '2.00', '3.50', 'Kompetensi Individu kelebihan 2 tingkat atau level', '2021-09-18 23:37:01', '2021-09-18 23:37:01', NULL),
  (5, '-2.00', '3.00', 'Kompetensi Individu kekurangan 2 tingkat atau level', '2021-09-18 23:37:38', '2021-09-18 23:37:38', NULL),
  (6, '3.00', '2.50', 'Kompetensi Individu kelebihan 3 tingkat atau level', '2021-09-18 23:38:06', '2021-09-18 23:38:06', NULL),
  (7, '-3.00', '2.00', 'Kompetensi Individu kekurangan 3 tingkat atau level', '2021-09-18 23:38:34', '2021-09-18 23:38:34', NULL),
  (8, '4.00', '1.50', 'Kompetensi Individu kelebihan 4 tingkat atau level', '2021-09-18 23:38:52', '2021-09-18 23:38:52', NULL),
  (9, '-4.00', '1.00', 'Kompetensi Individu kekurangan 4 tingkat atau level', '2021-09-18 23:39:21', '2021-09-18 23:39:21', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `hasils`
  --
  
  CREATE TABLE `hasils` (
    `id` int(10) UNSIGNED NOT NULL,
    `pendaftar_id` int(11) NOT NULL,
    `jurusan_id` int(11) NOT NULL,
    `nilai_tpa` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nilai_wawancara` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nilai_uan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nilai_minat` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nilai_rata` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `penguji_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `tahun_ajaran` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `jurusans`
  --
  
  CREATE TABLE `jurusans` (
    `id` int(10) UNSIGNED NOT NULL,
    `nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nilai_lulus` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `kepseks`
  --
  
  CREATE TABLE `kepseks` (
    `id` int(10) UNSIGNED NOT NULL,
    `nip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `kepseks`
  --
  
  INSERT INTO `kepseks` (`id`, `nip`, `nama`, `created_at`, `updated_at`) VALUES
  (1, '098779389', 'RIRI HERNAWATI', '2021-09-29 03:17:16', '2021-09-29 03:17:16');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `migrations`
  --
  
  CREATE TABLE `migrations` (
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `migrations`
  --
  
  INSERT INTO `migrations` (`migration`, `batch`) VALUES
  ('2014_10_12_000000_create_users_table', 1),
  ('2014_10_12_100000_create_password_resets_table', 1),
  ('2016_06_27_050600_create_pendaftars_table', 1),
  ('2016_06_27_050609_create_jurusans_table', 1),
  ('2016_06_27_050626_create_pengujis_table', 1),
  ('2016_06_27_050644_create_kepseks_table', 1),
  ('2016_06_27_055359_create_hasils_table', 1),
  ('2017_02_13_124142_create_petugas_table', 1),
  ('2017_04_11_093932_create_table_test', 1),
  ('2017_04_11_094304_create_table_testss', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `nilais`
  --
  
  CREATE TABLE `nilais` (
    `id` int(11) NOT NULL,
    `nis` int(11) NOT NULL,
    `id_aspeks` int(11) NOT NULL,
    `id_faktor` int(11) NOT NULL,
    `nilai` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `nilais`
  --
  
  INSERT INTO `nilais` (`id`, `nis`, `id_aspeks`, `id_faktor`, `nilai`, `created_at`, `updated_at`) VALUES
  (1, 12345567, 1, 1, 3, '2021-09-18 23:41:44', '2021-09-18 23:41:44'),
  (2, 12345567, 1, 3, 4, '2021-09-18 23:41:58', '2021-09-18 23:41:58'),
  (3, 12345567, 1, 7, 2, '2021-09-18 23:42:11', '2021-09-18 23:42:11'),
  (4, 12345567, 1, 10, 2, '2021-09-18 23:42:24', '2021-09-18 23:42:24'),
  (5, 12345567, 2, 11, 4, '2021-09-18 23:42:32', '2021-09-18 23:42:32'),
  (6, 12345567, 2, 16, 3, '2021-09-18 23:42:43', '2021-09-18 23:42:43'),
  (7, 77783782, 1, 2, 2, '2021-09-18 23:42:52', '2021-09-18 23:42:52'),
  (8, 77783782, 1, 5, 3, '2021-09-18 23:43:06', '2021-09-18 23:43:06'),
  (9, 12345567, 1, 9, 3, '2021-09-18 23:43:20', '2021-09-18 23:43:20'),
  (10, 77783782, 2, 11, 4, '2021-09-18 23:43:37', '2021-09-18 23:43:37'),
  (11, 77783782, 2, 15, 4, '2021-09-18 23:43:49', '2021-09-18 23:43:49'),
  (12, 10119479, 1, 1, 3, '2021-09-18 23:43:59', '2021-09-18 23:43:59'),
  (13, 10119479, 1, 5, 2, '2021-09-18 23:44:15', '2021-09-18 23:44:15'),
  (14, 10119479, 1, 10, 2, '2021-09-18 23:44:29', '2021-09-18 23:44:29'),
  (16, 10119479, 2, 15, 4, '2021-09-18 23:44:55', '2021-09-18 23:44:55'),
  (17, 10119479, 2, 11, 4, '2021-09-19 01:00:20', '2021-09-19 01:00:20'),
  (18, 77783782, 1, 7, 3, '2021-09-19 01:47:27', '2021-09-19 01:47:27'),
  (19, 77783782, 1, 10, 2, '2021-09-19 01:48:51', '2021-09-19 01:48:51');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `pendaftars`
  --
  
  CREATE TABLE `pendaftars` (
    `id` int(10) UNSIGNED NOT NULL,
    `nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `tempat_lahir` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `tanggal_lahir` date NOT NULL,
    `jenis_kelamin` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `agama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `pengujis`
  --
  
  CREATE TABLE `pengujis` (
    `id` int(10) UNSIGNED NOT NULL,
    `nama` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `jabatan` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `petugas`
  --
  
  CREATE TABLE `petugas` (
    `id` int(10) UNSIGNED NOT NULL,
    `level` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `nik` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `roles`
  --
  
  CREATE TABLE `roles` (
    `id` int(2) NOT NULL,
    `role_name` varchar(100) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data untuk tabel `roles`
  --
  
  INSERT INTO `roles` (`id`, `role_name`, `created_at`, `updated_at`) VALUES
  (1, 'Admin', '2021-09-30 00:42:18', '2021-09-30 00:42:18'),
  (2, 'Kepala Sekolah', '2021-09-30 00:42:18', '2021-09-30 00:42:18');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `role_users`
  --
  
  CREATE TABLE `role_users` (
    `id` int(11) NOT NULL,
    `id_user` int(11) UNSIGNED NOT NULL,
    `id_role` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data untuk tabel `role_users`
  --
  
  INSERT INTO `role_users` (`id`, `id_user`, `id_role`) VALUES
  (1, 1, 1),
  (2, 2, 2);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `skalas`
  --
  
  CREATE TABLE `skalas` (
    `id` int(11) NOT NULL,
    `id_skala` int(11) NOT NULL,
    `skala` int(11) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `students`
  --
  
  CREATE TABLE `students` (
    `id` int(11) NOT NULL,
    `nis` varchar(50) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `tempat_lahir` varchar(30) NOT NULL,
    `tgl_lahir` varchar(10) NOT NULL,
    `kelamin` varchar(20) NOT NULL,
    `agama` varchar(10) NOT NULL,
    `phone` varchar(13) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `updated_at` timestamp NULL DEFAULT NULL,
    `deleted_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `students`
  --
  
  INSERT INTO `students` (`id`, `nis`, `nama`, `tempat_lahir`, `tgl_lahir`, `kelamin`, `agama`, `phone`, `created_at`, `updated_at`, `deleted_at`) VALUES
  (2, '12345567', 'Imong', 'Bandung', '1999-12-12', 'Pria', 'Islam', '085721874884', '2021-09-14 21:41:14', '2021-09-16 21:13:48', NULL),
  (3, '77783782', 'Tina', 'Jakarta', '2000-12-12', 'Pria', 'Kristen', '085721874884', '2021-09-14 21:41:51', '2021-09-14 21:41:51', NULL),
  (4, '10119479', 'Imam', 'Sukabumi', '1999-12-12', 'Wanita', 'Islam', '085721874884', '2021-09-16 21:11:54', '2021-09-16 21:11:54', NULL),
  (5, '34349999', 'sdsfd', 'fdfs', '1999-12-12', 'Pria', 'Islam', '085798970901', '2021-09-17 02:02:32', '2021-09-17 02:02:32', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `test`
  --
  
  CREATE TABLE `test` (
    `id` int(10) UNSIGNED NOT NULL,
    `tes` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `testss`
  --
  
  CREATE TABLE `testss` (
    `id` int(10) UNSIGNED NOT NULL,
    `tes` varchar(11) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `id_role` int(10) UNSIGNED NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  --
  -- Dumping data untuk tabel `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`, `id_role`) VALUES
  (1, 'Admin', 'admin@gmail.com', '$2y$10$8dfPtWV1TPyUyf5IiHfIaeob9CdnMzhrKsZo05f8NIWcPktF6qLQ2', 'uyrwqMDBgGcxC5D5q8woOjV3PemuU9JJQm4eflnHz1PpFKXCq7FQYnyYZav5', '2021-08-14 03:29:30', '2021-09-29 18:20:50', 1),
  (2, 'Kepala Sekolah', 'kepsek@gmail.com', '$2y$10$kiHhGKz57bLhA4dDIjo6U.GCBtZFDYPkOuo67qdx17APhBiBF21M.', '81dnnx4FzFC2MyXGEDcrku9zfHBgFuNOqdbYDLGpqCjlOjR4Mv39oCO0MbH3', '2021-09-29 11:56:47', '2021-09-29 18:24:42', 2);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `aspeks`
  --
  ALTER TABLE `aspeks`
    ADD PRIMARY KEY (`id_aspek`);
  
  --
  -- Indeks untuk tabel `faktors`
  --
  ALTER TABLE `faktors`
    ADD PRIMARY KEY (`id_faktor`);
  
  --
  -- Indeks untuk tabel `gaps`
  --
  ALTER TABLE `gaps`
    ADD PRIMARY KEY (`id_gap`);
  
  --
  -- Indeks untuk tabel `hasils`
  --
  ALTER TABLE `hasils`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `hasils_pendaftar_id_unique` (`pendaftar_id`);
  
  --
  -- Indeks untuk tabel `jurusans`
  --
  ALTER TABLE `jurusans`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `kepseks`
  --
  ALTER TABLE `kepseks`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `kepseks_nip_unique` (`nip`);
  
  --
  -- Indeks untuk tabel `nilais`
  --
  ALTER TABLE `nilais`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`),
    ADD KEY `password_resets_token_index` (`token`);
  
  --
  -- Indeks untuk tabel `pendaftars`
  --
  ALTER TABLE `pendaftars`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `pengujis`
  --
  ALTER TABLE `pengujis`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `petugas`
  --
  ALTER TABLE `petugas`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `petugas_email_unique` (`email`);
  
  --
  -- Indeks untuk tabel `roles`
  --
  ALTER TABLE `roles`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `role_users`
  --
  ALTER TABLE `role_users`
    ADD PRIMARY KEY (`id`),
    ADD KEY `id_role` (`id_role`),
    ADD KEY `id_user` (`id_user`);
  
  --
  -- Indeks untuk tabel `skalas`
  --
  ALTER TABLE `skalas`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `students`
  --
  ALTER TABLE `students`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `test`
  --
  ALTER TABLE `test`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `testss`
  --
  ALTER TABLE `testss`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_email_unique` (`email`);
  
  --
  -- AUTO_INCREMENT untuk tabel yang dibuang
  --
  
  --
  -- AUTO_INCREMENT untuk tabel `aspeks`
  --
  ALTER TABLE `aspeks`
    MODIFY `id_aspek` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT untuk tabel `faktors`
  --
  ALTER TABLE `faktors`
    MODIFY `id_faktor` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
  
  --
  -- AUTO_INCREMENT untuk tabel `gaps`
  --
  ALTER TABLE `gaps`
    MODIFY `id_gap` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT untuk tabel `hasils`
  --
  ALTER TABLE `hasils`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `jurusans`
  --
  ALTER TABLE `jurusans`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `kepseks`
  --
  ALTER TABLE `kepseks`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT untuk tabel `nilais`
  --
  ALTER TABLE `nilais`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;
  
  --
  -- AUTO_INCREMENT untuk tabel `pendaftars`
  --
  ALTER TABLE `pendaftars`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `pengujis`
  --
  ALTER TABLE `pengujis`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `petugas`
  --
  ALTER TABLE `petugas`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `role_users`
  --
  ALTER TABLE `role_users`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT untuk tabel `skalas`
  --
  ALTER TABLE `skalas`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `students`
  --
  ALTER TABLE `students`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT untuk tabel `test`
  --
  ALTER TABLE `test`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `testss`
  --
  ALTER TABLE `testss`
    MODIFY `id` 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=3;
  
  --
  -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
  --
  
  --
  -- Ketidakleluasaan untuk tabel `role_users`
  --
  ALTER TABLE `role_users`
    ADD CONSTRAINT `role_users_ibfk_1` FOREIGN KEY (`id_role`) REFERENCES `roles` (`id`),
    ADD CONSTRAINT `role_users_ibfk_2` FOREIGN KEY (`id_user`) REFERENCES `users` (`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 */;
  