-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 03 Okt 2018 pada 18.53
-- Versi server: 10.1.34-MariaDB
-- Versi PHP: 7.1.19

START TRANSACTION;



--
-- Database: `akademik_kampus`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `customers`
--

CREATE TABLE `customers` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) 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 `customers`
--

INSERT INTO `customers` (`id`, `name`, `phone`, `created_at`, `updated_at`) VALUES
(2, 'Hafid Amirudin', '085349443978', '2018-08-20 08:44:52', '2018-08-20 08:44:52'),
(3, 'Hasan Yudi', '081225699675', '2018-08-20 08:55:35', '2018-08-20 08:55:35'),
(4, 'Aries setiyawan', '081330496884', '2018-08-20 08:57:34', '2018-08-20 08:57:34'),
(5, 'Irfrans Kusmarna', '081365906700', '2018-08-20 09:13:25', '2018-08-20 09:13:25'),
(6, 'Maskur', '085646554437', '2018-08-20 09:14:16', '2018-08-20 09:14:16'),
(8, 'ajie', '085710062017', '2018-08-20 09:23:50', '2018-08-20 09:23:50'),
(9, 'Fachrizal Hasbi', '085350039922', '2018-08-20 09:33:18', '2018-08-20 09:33:18'),
(10, 'Fachrizal Hasbi', '08115534581', '2018-08-20 09:33:33', '2018-08-20 09:33:33'),
(12, 'test', '+6282283350537', '2018-08-20 09:46:50', '2018-08-20 09:46:50'),
(13, 'Karjono', '+62817831237', '2018-08-20 11:08:56', '2018-08-20 11:08:56'),
(14, 'Robby Akbar', '+6289666549850', '2018-08-20 15:19:07', '2018-08-20 15:19:07'),
(15, 'Nuris telkomsel', '+6285315990012', '2018-08-20 15:43:44', '2018-08-20 15:43:44'),
(16, 'Syahruni', '6285248931813', '2018-08-20 16:22:55', '2018-08-20 16:22:55'),
(17, 'Rudy', '+628115994545', '2018-08-20 16:46:11', '2018-08-20 16:46:11'),
(18, 'Azi', '+6281316559322', '2018-08-20 17:06:43', '2018-08-20 17:06:43'),
(19, 'Azi', '+6281316559322', '2018-08-20 17:06:49', '2018-08-20 17:06:49'),
(20, 'Hasan Yudi', '+6281225699675', '2018-08-20 17:14:59', '2018-08-20 17:14:59'),
(21, 'isbuntoro', '+628125497944', '2018-08-20 17:24:17', '2018-08-20 17:24:17'),
(22, 'Moh. Romadhon', '+6281333805506', '2018-08-20 19:08:16', '2018-08-20 19:08:16'),
(23, 'Lino oke', '+6285248487470', '2018-08-20 19:15:42', '2018-08-20 19:15:42'),
(24, 'Rudiyanto', '+6285728886160', '2018-08-20 19:57:43', '2018-08-20 19:57:43'),
(25, 'Nandang Gozali Nursambas', '+6282240891040', '2018-08-20 20:10:37', '2018-08-20 20:10:37'),
(26, 'Safaruddin', '+628113212014', '2018-08-20 20:18:34', '2018-08-20 20:18:34'),
(27, 'AHMAD ALI KHAMDANI', '+6282331050413', '2018-08-20 22:32:51', '2018-08-20 22:32:51'),
(28, 'Mahmud Zunus Amirudin', '+6281229863888', '2018-08-20 22:33:10', '2018-08-20 22:33:10'),
(29, 'Alkaaf', '+6283899499818', '2018-08-20 22:38:57', '2018-08-20 22:38:57'),
(30, 'abdulhanan', '+6283817520840', '2018-08-20 22:39:13', '2018-08-20 22:39:13'),
(31, 'M Irvan Sukandar', '+6281284565077', '2018-08-20 22:45:45', '2018-08-20 22:45:45'),
(32, 'gema', '6285776412775', '2018-08-20 22:47:05', '2018-08-20 22:47:05'),
(33, 'Sri Tanto', '+6285717499754', '2018-08-20 22:50:54', '2018-08-20 22:50:54'),
(34, 'Dedy Setiawan', '+6281274816112', '2018-08-20 22:55:02', '2018-08-20 22:55:02'),
(35, 'Jupriadi', '+6285240920009', '2018-08-20 22:57:59', '2018-08-20 22:57:59'),
(36, 'Adi Kiswanto', '6285640206067', '2018-08-20 23:08:41', '2018-08-20 23:08:41'),
(37, 'Irwan', '+6285646554437', '2018-08-20 23:10:00', '2018-08-20 23:10:00'),
(38, 'ajie', '6285710062017', '2018-08-21 03:43:10', '2018-08-21 03:43:10');

-- --------------------------------------------------------

--
-- Struktur dari tabel `fakultas`
--

CREATE TABLE `fakultas` (
  `kode_fakultas` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_fakultas` varchar(191) 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 `fakultas`
--

INSERT INTO `fakultas` (`kode_fakultas`, `nama_fakultas`, `created_at`, `updated_at`) VALUES
('IFDK', 'Ilmu Komputer Dan Informatika', '2018-09-30 10:49:03', '2018-09-30 10:49:03'),
('TELT', 'Teknik Elektro Dan Otomasi', '2018-09-30 11:53:36', '2018-09-30 11:53:36'),
('TMSN', 'Teknik Mesin Industri', '2018-09-30 11:53:01', '2018-09-30 11:53:01');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jadwal_kuliah`
--

CREATE TABLE `jadwal_kuliah` (
  `id` int(10) UNSIGNED NOT NULL,
  `hari` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_dosen` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jam` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_jurusan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_ruangan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `semester` 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 `jadwal_kuliah`
--

INSERT INTO `jadwal_kuliah` (`id`, `hari`, `kode_mk`, `kode_dosen`, `jam`, `kode_jurusan`, `kode_ruangan`, `kode_tahun_akademik`, `semester`, `created_at`, `updated_at`) VALUES
(1, 'senin', 'DB01', 'NRSA', '1', 'IFD3', 'LT101', '20181', 1, '2018-09-30 10:58:49', '2018-09-30 10:58:49'),
(2, 'senin', 'MP01', 'DRHZ', '2', 'IFD3', 'LT101', '20181', 1, '2018-09-30 10:59:09', '2018-09-30 10:59:09'),
(3, 'selasa', 'SO01', 'NRSA', '1', 'IFD3', 'LT101', '20181', 1, '2018-09-30 10:59:34', '2018-09-30 10:59:34'),
(5, 'senin', 'KSW01', 'DRHZ', '1', 'IFD3', 'LT101', '20181', 1, '2018-09-30 11:02:12', '2018-09-30 11:02:12'),
(6, 'kamis', 'RPL01', 'DRHZ', '2', 'IFD3', 'LT101', '20181', 1, '2018-09-30 11:02:31', '2018-09-30 11:02:31'),
(7, 'senin', 'WP01', 'NRSA', '1', 'IFD3', 'LT101', '20181', 1, '2018-09-30 11:07:19', '2018-09-30 11:07:19');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jam_kuliah`
--

CREATE TABLE `jam_kuliah` (
  `id` int(11) NOT NULL,
  `jam` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `jam_kuliah`
--

INSERT INTO `jam_kuliah` (`id`, `jam`) VALUES
(1, '08:50 - 10:00'),
(2, '10:00 - 12.00'),
(3, '12.00 - 13.00'),
(4, '13.00 - 14.30');

-- --------------------------------------------------------

--
-- Struktur dari tabel `jurusan`
--

CREATE TABLE `jurusan` (
  `kode_jurusan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_jurusan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_fakultas` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenjang` varchar(191) 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 `jurusan`
--

INSERT INTO `jurusan` (`kode_jurusan`, `nama_jurusan`, `kode_fakultas`, `jenjang`, `created_at`, `updated_at`) VALUES
('IFD3', 'TEKNIK INFORMATIKA D3', 'IFDK', 'd3', '2018-09-30 10:49:37', '2018-09-30 10:49:37');

-- --------------------------------------------------------

--
-- Struktur dari tabel `kehadiran`
--

CREATE TABLE `kehadiran` (
  `id` int(10) UNSIGNED NOT NULL,
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_dosen` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_jurusan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_ruang` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `topik_pembahasan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pertemuan_ke` 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 `kehadiran`
--

INSERT INTO `kehadiran` (`id`, `kode_mk`, `kode_dosen`, `kode_jurusan`, `kode_ruang`, `kode_tahun_akademik`, `topik_pembahasan`, `pertemuan_ke`, `created_at`, `updated_at`) VALUES
(1, 'DB01', 'NRSA', 'IFD3', 'LT101', '20181', 'Fudamental Datatabase', 1, '2018-09-30 11:11:46', '2018-09-30 11:11:46'),
(2, 'DB01', 'NRSA', 'IFD3', 'LT101', '20181', 'Belajar MySQL', 2, '2018-09-30 11:12:46', '2018-09-30 11:12:46'),
(3, 'DB01', 'NRSA', 'IFD3', 'LT101', '20181', 'Tugas MySQL', 3, '2018-09-30 11:15:24', '2018-09-30 11:15:24'),
(4, 'DB01', 'NRSA', 'IFD3', 'LT101', '20181', 'Relasi Database', 4, '2018-10-01 03:32:21', '2018-10-01 03:32:21');

-- --------------------------------------------------------

--
-- Struktur dari tabel `khs`
--

CREATE TABLE `khs` (
  `id` int(10) UNSIGNED NOT NULL,
  `nim` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nilai_uts` int(11) NOT NULL,
  `nilai_uas` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nilai_tugas` int(11) NOT NULL,
  `nilai_kehadiran` int(11) NOT NULL,
  `kode_dosen` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `semester` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `khs`
--

INSERT INTO `khs` (`id`, `nim`, `kode_tahun_akademik`, `kode_mk`, `nilai_uts`, `nilai_uas`, `created_at`, `updated_at`, `nilai_tugas`, `nilai_kehadiran`, `kode_dosen`, `semester`) VALUES
(1, 'TI102132', '20181', 'DB01', 90, 90, '2018-09-30 11:08:07', '2018-09-30 11:08:07', 80, 90, 'NRSA', 1),
(2, 'TI102132', '20181', 'KSW01', 0, 0, '2018-09-30 11:08:07', '2018-09-30 11:08:07', 0, 0, 'DRHZ', 1),
(3, 'TI102132', '20181', 'MP01', 0, 0, '2018-09-30 11:08:07', '2018-09-30 11:08:07', 0, 0, 'DRHZ', 1),
(4, 'TI102132', '20181', 'RPL01', 0, 0, '2018-09-30 11:08:07', '2018-09-30 11:08:07', 0, 0, 'DRHZ', 1),
(5, 'TI102132', '20181', 'SO01', 0, 0, '2018-09-30 11:08:08', '2018-09-30 11:08:08', 0, 0, 'NRSA', 1),
(6, 'TI102132', '20181', 'WP01', 0, 0, '2018-09-30 11:08:08', '2018-09-30 11:08:08', 0, 0, 'NRSA', 1),
(7, 'TI102133', '20181', 'DB01', 89, 95, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 87, 80, 'NRSA', 1),
(8, 'TI102133', '20181', 'KSW01', 0, 0, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 0, 0, 'DRHZ', 1),
(9, 'TI102133', '20181', 'MP01', 0, 0, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 0, 0, 'DRHZ', 1),
(10, 'TI102133', '20181', 'RPL01', 0, 0, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 0, 0, 'DRHZ', 1),
(11, 'TI102133', '20181', 'SO01', 0, 0, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 0, 0, 'NRSA', 1),
(12, 'TI102133', '20181', 'WP01', 0, 0, '2018-09-30 11:10:18', '2018-09-30 11:10:18', 0, 0, 'NRSA', 1);

-- --------------------------------------------------------

--
-- Struktur dari tabel `krs`
--

CREATE TABLE `krs` (
  `id` int(10) UNSIGNED NOT NULL,
  `nim` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `semester` int(11) NOT NULL,
  `kode_dosen` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `krs`
--

INSERT INTO `krs` (`id`, `nim`, `kode_tahun_akademik`, `kode_mk`, `created_at`, `updated_at`, `semester`, `kode_dosen`) VALUES
(1, 'TI102132', '20181', 'DB01', '2018-09-30 11:05:03', '2018-09-30 11:05:03', 1, 'NRSA'),
(2, 'TI102132', '20181', 'KSW01', '2018-09-30 11:05:04', '2018-09-30 11:05:04', 1, 'DRHZ'),
(3, 'TI102132', '20181', 'MP01', '2018-09-30 11:05:05', '2018-09-30 11:05:05', 1, 'DRHZ'),
(4, 'TI102132', '20181', 'RPL01', '2018-09-30 11:05:06', '2018-09-30 11:05:06', 1, 'DRHZ'),
(5, 'TI102132', '20181', 'SO01', '2018-09-30 11:05:07', '2018-09-30 11:05:07', 1, 'NRSA'),
(7, 'TI102132', '20181', 'WP01', '2018-09-30 11:08:02', '2018-09-30 11:08:02', 1, 'NRSA'),
(8, 'TI102133', '20181', 'DB01', '2018-09-30 11:10:09', '2018-09-30 11:10:09', 1, 'NRSA'),
(9, 'TI102133', '20181', 'KSW01', '2018-09-30 11:10:10', '2018-09-30 11:10:10', 1, 'DRHZ'),
(10, 'TI102133', '20181', 'MP01', '2018-09-30 11:10:11', '2018-09-30 11:10:11', 1, 'DRHZ'),
(11, 'TI102133', '20181', 'RPL01', '2018-09-30 11:10:12', '2018-09-30 11:10:12', 1, 'DRHZ'),
(12, 'TI102133', '20181', 'SO01', '2018-09-30 11:10:13', '2018-09-30 11:10:13', 1, 'NRSA'),
(13, 'TI102133', '20181', 'WP01', '2018-09-30 11:10:14', '2018-09-30 11:10:14', 1, 'NRSA');

-- --------------------------------------------------------

--
-- Struktur dari tabel `kurikulum`
--

CREATE TABLE `kurikulum` (
  `id` int(10) UNSIGNED NOT NULL,
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `kode_jurusan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `semester` 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 `kurikulum`
--

INSERT INTO `kurikulum` (`id`, `kode_mk`, `kode_jurusan`, `semester`, `created_at`, `updated_at`) VALUES
(1, 'DB01', 'IFD3', 1, '2018-09-30 10:57:40', '2018-09-30 10:57:40'),
(2, 'KSW01', 'IFD3', 1, '2018-09-30 10:57:46', '2018-09-30 10:57:46'),
(3, 'MP01', 'IFD3', 1, '2018-09-30 10:57:54', '2018-09-30 10:57:54'),
(4, 'RPL01', 'IFD3', 1, '2018-09-30 10:58:00', '2018-09-30 10:58:00'),
(5, 'SO01', 'IFD3', 1, '2018-09-30 10:58:04', '2018-09-30 10:58:04'),
(6, 'WP01', 'IFD3', 1, '2018-09-30 10:58:10', '2018-09-30 10:58:10');

-- --------------------------------------------------------

--
-- Struktur dari tabel `matakuliah`
--

CREATE TABLE `matakuliah` (
  `kode_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_mk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jml_sks` varchar(191) 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 `matakuliah`
--

INSERT INTO `matakuliah` (`kode_mk`, `nama_mk`, `jml_sks`, `created_at`, `updated_at`) VALUES
('DB01', 'PEMOGRAMAN BASIS DATA', '3', '2018-09-30 10:56:46', '2018-09-30 10:56:46'),
('KSW01', 'KEWIRAUSAHAAN', '2', '2018-09-30 10:57:18', '2018-09-30 10:57:18'),
('MP01', 'MOBILE PROGRAMMING', '3', '2018-09-30 10:56:17', '2018-09-30 10:56:17'),
('RPL01', 'REKAYASA PERANGKAT LUNAK', '3', '2018-09-30 10:56:56', '2018-09-30 10:56:56'),
('SO01', 'SISTEM OPERASI', '3', '2018-09-30 10:56:27', '2018-09-30 10:56:27'),
('WP01', 'WEB PROGRAMMING', '3', '2018-09-30 10:56:03', '2018-09-30 10:56:03');

-- --------------------------------------------------------

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) 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
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_07_19_180421_create_table_matakuliah', 2),
(4, '2018_07_21_165939_create_dosens_table', 3),
(5, '2018_07_21_174622_create_table_fakultas', 4),
(6, '2018_07_21_182501_create_jurusans_table', 5),
(7, '2018_07_21_185846_create_ruangans_table', 6),
(8, '2018_07_21_191250_create_tahun_akademiks_table', 7),
(10, '2018_07_22_170110_create_kurikulums_table', 8),
(11, '2018_07_22_200308_create_settings_table', 9),
(13, '2018_07_23_183221_create_jadwalkuliahs_table', 10),
(14, '2018_07_24_180322_create_mahasiswas_table', 11),
(15, '2018_08_13_184050_create_krs_table', 12),
(16, '2018_08_13_195845_create_khs_table', 13),
(17, '2018_08_16_233451_add_column_password_to_dosen', 14),
(18, '2018_08_17_081930_add_tugas_kehadiran_to_khs', 15),
(19, '2018_08_17_082339_add_column_kode_dosen', 16),
(20, '2018_08_22_174121_create_kehadirans_table', 17),
(21, '2018_08_23_051021_create_kehadirans_table', 18),
(22, '2018_08_23_210906_create_table_riwayat_kehadiran', 19),
(23, '2018_09_25_001630_add_columns_to_tahun_akademik', 20),
(24, '2018_09_27_170804_add_kode_akademik_to_mahasiswa', 21),
(25, '2018_09_29_072206_add_kode_fakultas_to_dosen', 22),
(26, '2018_09_30_072620_add_semester_to_khs', 23),
(27, '2018_09_30_072651_add_semester_to_krs', 23),
(28, '2018_09_30_074221_add_kode_dosen_krs', 24),
(29, '2018_10_02_084105_add__wa_api_key_and_zenziva_to_setting', 25);

-- --------------------------------------------------------

--
-- Struktur dari tabel `riwayat_kehadiran`
--

CREATE TABLE `riwayat_kehadiran` (
  `id` int(10) UNSIGNED NOT NULL,
  `kehadiran_id` int(11) NOT NULL,
  `nim` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status_kehadiran` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pertemuan_ke` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `riwayat_kehadiran`
--

INSERT INTO `riwayat_kehadiran` (`id`, `kehadiran_id`, `nim`, `status_kehadiran`, `pertemuan_ke`) VALUES
(1, 3, 'TI102132', 'H', 3),
(2, 3, 'TI102133', 'H', 3),
(3, 4, 'TI102132', 'I', 4),
(4, 4, 'TI102133', 'S', 4);

-- --------------------------------------------------------

--
-- Struktur dari tabel `ruangan`
--

CREATE TABLE `ruangan` (
  `kode_ruangan` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama_ruangan` varchar(191) 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 `ruangan`
--

INSERT INTO `ruangan` (`kode_ruangan`, `nama_ruangan`, `created_at`, `updated_at`) VALUES
('LBKom', 'Lab Komputer', '2018-09-30 11:30:21', '2018-09-30 11:30:21'),
('LBTKJ', 'Lab Komputer Dan jaringan', '2018-09-30 11:30:37', '2018-09-30 11:30:37'),
('LT101', 'LT101 - Teori', '2018-09-30 10:55:27', '2018-09-30 10:55:27'),
('LT102', 'LT102  - Teori', '2018-09-30 11:30:10', '2018-09-30 11:30:10');

-- --------------------------------------------------------

--
-- Struktur dari tabel `tahun_akademik`
--

CREATE TABLE `tahun_akademik` (
  `kode_tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun_akademik` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('y','n') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `tanggal_awal_kuliah` date NOT NULL,
  `tanggal_akhir_kuliah` date NOT NULL,
  `tanggal_awal_uts` date NOT NULL,
  `tanggal_akhir_uts` date NOT NULL,
  `tanggal_awal_uas` date NOT NULL,
  `tanggal_akhir_uas` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `tahun_akademik`
--

INSERT INTO `tahun_akademik` (`kode_tahun_akademik`, `tahun_akademik`, `status`, `created_at`, `updated_at`, `tanggal_awal_kuliah`, `tanggal_akhir_kuliah`, `tanggal_awal_uts`, `tanggal_akhir_uts`, `tanggal_awal_uas`, `tanggal_akhir_uas`) VALUES
('20171', 'Tahun Akademik 2017 - 2018 Semester Ganjil', 'n', '2018-10-01 03:23:59', '2018-10-01 03:24:09', '2017-01-05', '2017-01-12', '2017-01-12', '2017-10-10', '2017-10-09', '2017-10-17'),
('20172', 'Tahun Akademik 2017 - 2018 Semester  Genap', 'n', '2018-10-01 03:25:43', '2018-10-01 03:25:51', '2017-10-12', '2017-10-10', '2017-10-11', '2017-10-09', '2017-10-10', '2017-10-16'),
('20181', '2018 - 2019 Semester Ganjil', 'y', '2018-09-30 10:47:45', '2018-09-30 10:47:45', '2018-10-01', '2018-10-31', '2018-10-01', '2018-10-31', '2018-10-01', '2018-10-01'),
('20182', '2018 - 2019 Semester genap', 'n', '2018-09-30 10:48:12', '2018-09-30 10:48:12', '2018-10-01', '2018-10-31', '2018-10-01', '2018-10-31', '2018-10-01', '2018-10-31');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `fakultas`
--
ALTER TABLE `fakultas`
  ADD PRIMARY KEY (`kode_fakultas`);

--
-- Indeks untuk tabel `jadwal_kuliah`
--
ALTER TABLE `jadwal_kuliah`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `jam_kuliah`
--
ALTER TABLE `jam_kuliah`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `jurusan`
--
ALTER TABLE `jurusan`
  ADD PRIMARY KEY (`kode_jurusan`);

--
-- Indeks untuk tabel `kehadiran`
--
ALTER TABLE `kehadiran`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `khs`
--
ALTER TABLE `khs`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `krs`
--
ALTER TABLE `krs`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `kurikulum`
--
ALTER TABLE `kurikulum`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `matakuliah`
--
ALTER TABLE `matakuliah`
  ADD PRIMARY KEY (`kode_mk`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `riwayat_kehadiran`
--
ALTER TABLE `riwayat_kehadiran`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `ruangan`
--
ALTER TABLE `ruangan`
  ADD PRIMARY KEY (`kode_ruangan`);

--
-- Indeks untuk tabel `tahun_akademik`
--
ALTER TABLE `tahun_akademik`
  ADD PRIMARY KEY (`kode_tahun_akademik`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `customers`
--
ALTER TABLE `customers`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT untuk tabel `jadwal_kuliah`
--
ALTER TABLE `jadwal_kuliah`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT untuk tabel `jam_kuliah`
--
ALTER TABLE `jam_kuliah`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `kehadiran`
--
ALTER TABLE `kehadiran`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT untuk tabel `khs`
--
ALTER TABLE `khs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `krs`
--
ALTER TABLE `krs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT untuk tabel `kurikulum`
--
ALTER TABLE `kurikulum`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT untuk tabel `riwayat_kehadiran`
--
ALTER TABLE `riwayat_kehadiran`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

