-- phpMyAdmin SQL Dump -- version 5.2.2 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Waktu pembuatan: 06 Apr 2026 pada 02.28 -- Versi server: 11.8.6-MariaDB-log -- Versi PHP: 7.2.34 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: `u768956174_lmsinsida` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `assignments` -- CREATE TABLE `assignments` ( `id` bigint(20) UNSIGNED NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `start_date` datetime NOT NULL, `end_date` datetime NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `allow_late_submission` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `assignments` -- INSERT INTO `assignments` (`id`, `meeting_id`, `title`, `description`, `file_path`, `start_date`, `end_date`, `created_at`, `updated_at`, `allow_late_submission`) VALUES (22, 94, 'asdfasd', NULL, 'assignments/BL8zNSbpZteOWjLSIWrEr8fMx288y5wB2lRIBHnx.xlsx', '2025-09-05 16:43:00', '2025-09-08 16:43:00', '2025-09-03 09:43:24', '2025-09-04 02:58:45', 0), (24, 96, 'xasdasdsa', NULL, 'assignments/ewecT9GqxotbhPeC33esUc2EJ3bTQaNtr5nsAhbq.png', '2025-09-06 09:56:00', '2025-09-12 09:56:00', '2025-09-04 02:56:59', '2025-09-04 02:56:59', 0), (25, 97, '2', NULL, 'assignments/XbK2JTevxoUdY5xHgAPLXPhkW88rdR1rby1BCzM2.png', '2025-09-06 09:57:00', '2025-09-08 09:57:00', '2025-09-04 02:58:06', '2025-09-06 09:39:15', 0), (26, 99, 'Es', NULL, 'assignments/6AR1nT3PWfCtaESgh4NcZvuFYvw37kHG0HrLSZus.png', '2025-09-04 10:10:00', '2025-09-08 10:10:00', '2025-09-04 03:11:40', '2025-09-04 03:11:40', 0), (28, 103, 'Tugas 1', NULL, 'assignments/RO0XsZvhshPZ7FLe5ziRbEsmW9W16SoTbCqegqCs.xlsx', '2025-09-06 14:01:00', '2025-09-06 16:01:00', '2025-09-06 07:02:04', '2025-09-06 07:02:04', 0), (29, 108, 'UTS', NULL, 'assignments/iFYA2Sin2xaAoAIqvRd0VAoG3OysLnONUiNCr9nO.png', '2025-09-08 13:49:00', '2025-09-08 13:54:00', '2025-09-08 06:49:41', '2025-09-08 06:49:41', 0), (30, 109, '12', NULL, 'assignments/RUonpYqXoAxs1j9gMGHhXMWBOULYREKSiQunuILI.png', '2025-09-08 13:49:00', '2025-09-08 13:54:00', '2025-09-08 06:50:00', '2025-09-08 06:50:00', 0), (35, 122, 'Tugas', NULL, 'assignments/7P6w9Heh0ux383praPsIhLKgBN2e7AuzBjDYqrdv.pdf', '2025-09-10 12:20:00', '2025-09-17 12:20:00', '2025-09-10 05:20:13', '2025-09-10 05:20:13', 0), (36, 130, 'Tugas', NULL, 'assignments/zKgK34UxWWEZ4mItp8jTY7mopa4ltfzQxHJWrwNe.pdf', '2025-09-12 09:45:00', '2025-09-18 09:45:00', '2025-09-11 02:45:34', '2025-09-11 02:45:34', 0), (37, 134, 'Tugas 1', NULL, 'assignments/q1AG3Oij93o3eOH9OGUuHOxH5khK1UQzZkB1OStN.pdf', '2025-09-11 10:22:00', '2025-09-12 10:22:00', '2025-09-11 03:22:18', '2025-09-11 03:22:18', 0), (38, 135, 'UTS', NULL, 'assignments/DLkkOhCzOWHz9Z743LaOXxJx3UHL98aaJsZbu5kd.pdf', '2025-09-11 10:23:00', '2025-09-11 12:23:00', '2025-09-11 03:23:53', '2025-09-11 03:23:53', 0); -- -------------------------------------------------------- -- -- Struktur dari tabel `attendances` -- CREATE TABLE `attendances` ( `id` bigint(20) UNSIGNED NOT NULL, `user_id` varchar(12) NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `status` enum('present','absent','izin') NOT NULL DEFAULT 'present', `proof_path` varchar(255) DEFAULT NULL, `attended_at` timestamp NULL DEFAULT current_timestamp(), `created_by_user_id` varchar(12) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `attendances` -- INSERT INTO `attendances` (`id`, `user_id`, `meeting_id`, `status`, `proof_path`, `attended_at`, `created_by_user_id`, `created_at`, `updated_at`) VALUES (21, '683e75af91f7', 98, 'present', NULL, '2025-09-06 02:21:50', '675bf741a3b0', '2025-09-06 02:21:50', '2025-09-08 02:16:13'), (22, 'a20452bb-91f', 102, 'present', NULL, '2025-09-06 07:04:16', NULL, '2025-09-06 07:04:16', '2025-09-06 07:04:16'), (23, 'a20452bb-91f', 105, 'present', NULL, '2025-09-06 09:50:12', NULL, '2025-09-06 09:50:12', '2025-09-06 09:50:12'), (24, 'a20452bb-91f', 98, 'present', NULL, '2025-09-08 02:16:13', '675bf741a3b0', '2025-09-08 02:16:13', '2025-09-08 02:24:18'), (25, 'a20452bb-91f', 110, 'present', NULL, '2025-09-08 09:26:50', NULL, '2025-09-08 09:26:50', '2025-09-08 09:26:50'), (28, '455fa3b2-2d4', 123, 'present', NULL, '2025-09-10 05:32:53', NULL, '2025-09-10 05:32:53', '2025-09-10 05:32:53'), (29, 'a20452bb-91f', 129, 'present', NULL, '2025-09-11 02:46:48', '6a066e7c-2bf', '2025-09-11 02:46:48', '2025-09-11 02:46:48'), (30, '10eee191-1c6', 131, 'absent', NULL, '2025-09-11 03:20:15', 'eecc4bdc-0e7', '2025-09-11 03:20:15', '2025-09-11 03:20:35'); -- -------------------------------------------------------- -- -- Struktur dari tabel `bobot` -- CREATE TABLE `bobot` ( `id` char(36) NOT NULL, `course_id` bigint(20) UNSIGNED NOT NULL, `nama_bobot` varchar(255) NOT NULL, `nilai_bobot` int(11) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `bobot` -- INSERT INTO `bobot` (`id`, `course_id`, `nama_bobot`, `nilai_bobot`, `created_at`, `updated_at`) VALUES ('0f44dcea-6b5a-44d2-87a4-0a03e44243a2', 84, 'uas', 40, '2025-09-08 09:47:08', '2025-09-08 09:47:08'), ('5191d650-472a-4966-beab-89463305e65e', 72, 'absensi', 10, '2025-09-09 06:44:26', '2025-09-09 06:44:26'), ('5a378306-eaca-4d8c-8986-5adabac7c38e', 72, 'uts', 30, '2025-09-09 06:44:26', '2025-09-09 06:44:26'), ('5c24a74e-57e2-44e6-b253-538378a06ac2', 72, 'uas', 50, '2025-09-09 06:44:26', '2025-09-09 06:44:26'), ('7ca94a68-294e-41ab-b179-fc2035934685', 87, 'absensi', 100, '2025-09-09 04:43:29', '2025-09-09 04:43:29'), ('a1c601f3-d48a-4a80-9ba4-9501e68495ae', 72, 'tugas', 10, '2025-09-09 06:44:26', '2025-09-09 06:44:26'), ('a531b3b6-44b4-4128-9f04-049c0bec485f', 84, 'uts', 40, '2025-09-08 09:47:08', '2025-09-08 09:47:08'), ('be5c8b8e-90d7-4842-93b2-60e9e87a20fb', 84, 'tugas', 20, '2025-09-08 09:47:08', '2025-09-08 09:47:08'), ('dd1b6afd-aa3a-418a-8a8e-96d2fd174624', 84, 'absensi', 0, '2025-09-08 09:47:08', '2025-09-08 09:47:08'); -- -------------------------------------------------------- -- -- Struktur dari tabel `comments` -- CREATE TABLE `comments` ( `id` int(10) UNSIGNED NOT NULL, `user_id` varchar(12) NOT NULL, `post_id` int(10) UNSIGNED NOT NULL, `parent_id` int(10) UNSIGNED DEFAULT NULL, `body` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `comments` -- INSERT INTO `comments` (`id`, `user_id`, `post_id`, `parent_id`, `body`, `created_at`, `updated_at`) VALUES (1, '978NutghekKl', 2, NULL, 'A', '2025-09-10 09:36:48', '2025-09-10 09:36:48'), (3, '978NutghekKl', 2, NULL, 'Ts', '2025-09-10 09:37:55', '2025-09-10 09:37:55'), (4, 'eecc4bdc-0e7', 3, NULL, 'Ayo coba isi, sebarkan pengetahuanmu', '2025-09-11 03:46:12', '2025-09-11 03:46:12'), (5, '10eee191-1c6', 3, NULL, 'Jadi gini', '2025-09-11 03:46:57', '2025-09-11 03:46:57'), (6, 'eecc4bdc-0e7', 3, NULL, 'Komen lagi', '2025-09-11 03:47:16', '2025-09-11 03:47:16'); -- -------------------------------------------------------- -- -- Struktur dari tabel `courses` -- CREATE TABLE `courses` ( `id` bigint(20) UNSIGNED NOT NULL, `id_jurusan` varchar(255) DEFAULT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `lecturer_name` varchar(255) NOT NULL, `code` varchar(255) NOT NULL, `base_code` varchar(50) DEFAULT NULL, `image_path` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `number_of_meetings` int(11) NOT NULL DEFAULT 14, `semester` enum('Ganjil','Genap','Pendek') NOT NULL DEFAULT 'Ganjil', `academic_year` varchar(10) NOT NULL DEFAULT '2025/2026' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `courses` -- INSERT INTO `courses` (`id`, `id_jurusan`, `title`, `description`, `lecturer_name`, `code`, `base_code`, `image_path`, `created_at`, `updated_at`, `number_of_meetings`, `semester`, `academic_year`) VALUES (72, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan Maternitas', NULL, 'reni', 'KEP204', 'KEP204', 'image/course/bg2.png', '2025-09-03 09:11:04', '2025-09-08 03:55:58', 14, 'Ganjil', '2025/2026'), (73, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Gizi dalam Keperawatan', NULL, 'bebelacsaiga', 'KEP105', 'KEP105', 'image/course/bg1.png', '2025-09-03 09:26:10', '2025-09-03 09:26:10', 14, 'Ganjil', '2025/2026'), (74, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan Gawat Darurat', NULL, 'bebelacsaiga', 'KEP205', 'KEP205', 'image/course/bg1.png', '2025-09-03 09:26:17', '2025-09-06 09:47:58', 14, 'Ganjil', '2025/2026'), (75, '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Etika dan Hukum Keperawatan', NULL, 'testing dosen', 'KEP102', 'KEP102', 'image/course/bg9.png', '2025-09-03 09:26:32', '2025-09-03 09:26:32', 14, 'Ganjil', '2025/2026'), (76, '4529c966-0a40-4778-844f-06065c948e87', 'CSS', NULL, 'bebelacsaiga', 'TI202512', 'TI202512', 'image/course/footer1.png', '2025-09-06 07:00:26', '2025-09-06 09:59:46', 15, 'Ganjil', '2025/2026'), (80, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Farmakologi', NULL, 'bebelacsaiga', 'SSI105', 'SSI105', 'image/course/bg3.png', '2025-09-08 08:16:35', '2025-09-08 08:16:35', 14, 'Ganjil', '2025/2026'), (81, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Maternitas', NULL, 'bebelacsaiga', 'SSI108', 'SSI108', 'image/course/bg5.png', '2025-09-08 08:19:10', '2025-09-08 08:19:10', 14, 'Ganjil', '2025/2026'), (84, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Anak', NULL, 'bebelacsaiga', 'SSI107', 'SSI107', 'image/course/bg7.png', '2025-09-08 09:47:08', '2025-09-08 09:47:08', 14, 'Ganjil', '2025/2026'), (85, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Etika dan Hukum Keperawatan', NULL, 'bebelacsaiga', 'SSI102', 'SSI102', 'image/course/bg10.png', '2025-09-08 09:56:55', '2025-09-08 09:56:55', 14, 'Ganjil', '2025/2026'), (86, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Medikal Bedah I', NULL, 'bebelacsaiga', 'SSI104', 'SSI104', 'image/course/bg11.png', '2025-09-08 10:00:30', '2025-09-08 10:00:30', 14, 'Ganjil', '2025/2026'), (87, 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'Keperawatan Gawat Darurat', NULL, 'bebelacsaiga', 'SSI109', 'SSI109', 'image/course/bg5.png', '2025-09-09 04:43:28', '2025-09-09 04:43:28', 14, 'Ganjil', '2025/2026'), (91, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-G2502', '1', 'image/course/bg11.png', '2025-09-09 07:17:54', '2025-09-09 07:17:54', 14, 'Ganjil', '2025/2026'), (93, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-E2502', '1', 'image/course/bg9.png', '2025-09-09 07:20:24', '2025-09-09 07:20:24', 14, 'Genap', '2025/2026'), (94, '4529c966-0a40-4778-844f-06065c948e87', '1111', NULL, 'bebelacsaiga', '1-G2602', '1', 'image/course/bg8.png', '2025-09-09 07:20:44', '2025-09-09 07:20:44', 14, 'Ganjil', '2026/2027'), (97, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Sejarah Kebudayaan Islam', NULL, 'dosen005', 'PAI102-G2502-G2502', 'PAI102-G2502', 'image/course/bg6.png', '2025-09-10 04:58:56', '2025-09-10 04:58:56', 14, 'Ganjil', '2025/2026'), (98, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Ilmu Fikih', NULL, 'dosen005', 'PAI103-G2502', 'PAI103', 'image/course/bg3.png', '2025-09-10 05:01:52', '2025-09-10 05:01:52', 14, 'Ganjil', '2025/2026'), (99, '1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'Ilmu Fikih', NULL, 'dosen005', 'PAI103-E2502', 'PAI103', 'image/course/bg1.png', '2025-09-10 06:02:06', '2025-09-10 06:02:06', 14, 'Genap', '2025/2026'), (100, '8f860a88-9c64-4c98-a445-932011d30f3e', 'Tes Matkul', NULL, 'dosen005', 'Tes-G2502', 'Tes', 'image/course/footer1.png', '2025-09-11 02:43:17', '2025-09-11 02:43:17', 14, 'Ganjil', '2025/2026'), (101, '84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', 'Algoritma Pemrograman', NULL, 'Dosen STMIK Arung Binang', 'MI3212-G2502', 'MI3212', 'image/course/bg6.png', '2025-09-11 03:14:51', '2025-09-11 03:18:53', 14, 'Ganjil', '2025/2026'); -- -------------------------------------------------------- -- -- Struktur dari tabel `enrolments` -- CREATE TABLE `enrolments` ( `enrol_id` bigint(20) NOT NULL, `user_id` varchar(20) DEFAULT NULL, `course_id` bigint(20) DEFAULT NULL, `final_grade` varchar(2) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `enrolments` -- INSERT INTO `enrolments` (`enrol_id`, `user_id`, `course_id`, `final_grade`, `created_at`, `updated_at`) VALUES (32, '675bf741a320', 1, NULL, '2025-08-21 20:32:27', '2025-08-21 20:32:27'), (33, '6788b5a79eff', 1, NULL, '2025-08-21 20:32:45', '2025-08-21 20:32:45'), (34, '6788b5a79eff', 2, NULL, '2025-08-21 20:33:20', '2025-08-21 20:33:20'), (40, '83bfe5e3-1a0', 3, NULL, '2025-08-22 01:35:51', '2025-08-22 01:35:51'), (42, '6cfd2a32-a28', 1, NULL, '2025-08-23 06:04:15', '2025-08-23 06:04:15'), (43, '6cfd2a32-a28', 2, NULL, '2025-08-23 09:17:11', '2025-08-23 09:17:11'), (61, '67b426db8b5b', 1, NULL, '2025-08-24 03:17:30', '2025-08-29 14:44:21'), (65, '67b426db8b5b', 4, NULL, '2025-08-26 03:20:24', '2025-08-29 14:44:25'), (66, '6788b5a79eff', 15, NULL, '2025-08-26 04:50:16', '2025-08-26 04:50:16'), (67, '675bf741a320', 15, NULL, '2025-08-26 04:59:51', '2025-08-26 04:59:51'), (70, '67b426db8b5b', 37, NULL, '2025-08-27 07:19:13', '2025-08-29 14:44:29'), (72, '67b426db8b5b', 39, NULL, '2025-08-27 07:19:22', '2025-08-29 14:45:06'), (73, '67b426db8b5b', 40, NULL, '2025-08-27 07:19:29', '2025-08-29 14:45:12'), (74, '978NutghekKl', 41, NULL, '2025-08-27 07:19:40', '2025-08-27 07:19:40'), (75, '978NutghekKl', 42, NULL, '2025-08-27 07:19:58', '2025-08-27 07:19:58'), (79, '683e75af91f7', 1, NULL, '2025-08-28 07:29:11', '2025-08-28 07:29:11'), (83, '683e75af91f7', 44, NULL, '2025-08-28 09:37:21', '2025-08-28 09:37:21'), (84, '6788b5a79eff', 38, NULL, '2025-08-29 06:40:17', '2025-08-29 06:40:17'), (85, '675bf741a3b0', 47, NULL, '2025-08-29 07:52:20', '2025-08-29 07:52:20'), (88, '6788b5a79eff', 49, NULL, '2025-08-29 09:52:54', '2025-08-29 09:52:54'), (89, '978NutghekKl', 1, NULL, '2025-08-30 02:08:20', '2025-08-30 02:08:20'), (90, '683e75af91f7', 50, NULL, '2025-08-30 02:13:48', '2025-08-30 02:13:48'), (91, '6788b5a79eff', 50, NULL, '2025-08-30 02:16:16', '2025-08-30 02:16:16'), (101, '1cd1a406-d18', 73, NULL, '2025-09-04 02:19:10', '2025-09-04 02:19:10'), (102, '675bf741a320', 73, NULL, '2025-09-04 02:19:46', '2025-09-04 02:19:46'), (103, '978NutghekKl', 74, NULL, '2025-09-04 02:20:11', '2025-09-04 02:20:11'), (104, '978NutghekKl', 75, NULL, '2025-09-04 02:23:55', '2025-09-04 02:23:55'), (105, '978NutghekKl', 73, NULL, '2025-09-04 02:24:20', '2025-09-04 02:24:20'), (106, '675bf741a3b0', 72, NULL, '2025-09-04 02:26:30', '2025-09-04 02:26:30'), (108, 'a20452bb-91f', 72, 'E', '2025-09-04 04:26:08', '2025-09-08 02:59:21'), (109, 'a20452bb-91f', 74, NULL, '2025-09-04 04:40:53', '2025-09-04 04:40:53'), (111, '1cd1a406-d18', 76, NULL, '2025-09-06 07:01:10', '2025-09-06 07:01:10'), (112, 'a20452bb-91f', 76, NULL, '2025-09-06 07:04:02', '2025-09-06 07:04:02'), (113, '978NutghekKl', 72, NULL, '2025-09-09 04:10:14', '2025-09-09 04:10:14'), (114, '683e75af91f7', 72, NULL, '2025-09-09 04:58:45', '2025-09-09 04:58:45'), (115, '6a066e7c-2bf', 95, NULL, '2025-09-10 03:03:52', '2025-09-10 03:03:52'), (116, '455fa3b2-2d4', 95, 'E', '2025-09-10 03:05:12', '2025-09-10 03:12:32'), (117, '6a066e7c-2bf', 98, NULL, '2025-09-10 05:02:15', '2025-09-10 05:02:15'), (118, '455fa3b2-2d4', 98, 'E', '2025-09-10 05:20:37', '2025-09-10 05:24:25'), (119, '6a066e7c-2bf', 100, NULL, '2025-09-11 02:44:21', '2025-09-11 02:44:21'), (120, 'a20452bb-91f', 100, 'E', '2025-09-11 02:45:56', '2025-09-11 02:46:39'), (121, 'eecc4bdc-0e7', 101, NULL, '2025-09-11 03:17:52', '2025-09-11 03:17:52'), (122, '10eee191-1c6', 101, 'E', '2025-09-11 03:18:16', '2025-09-11 03:23:09'); -- -------------------------------------------------------- -- -- Struktur dari tabel `jurusan` -- CREATE TABLE `jurusan` ( `id` varchar(36) NOT NULL, `nama` varchar(255) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `jurusan` -- INSERT INTO `jurusan` (`id`, `nama`, `created_at`, `updated_at`) VALUES ('17d85773-ff1b-4d98-a247-e029cb8a3c23', 'S1 Pendidikan Agama Islam', '2025-09-10 02:54:29', '2025-09-10 02:54:29'), ('1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', 'Keperawatan', '2025-09-03 03:17:24', '2025-09-08 07:11:47'), ('1c5b025c-f211-4dc2-b1a8-cc3244733a92', 'S1 Ilmu Hukum Islam', '2025-09-10 02:58:46', '2025-09-10 02:58:46'), ('4529c966-0a40-4778-844f-06065c948e87', 'S1 Teknik Informatika', '2025-09-06 06:57:31', '2025-09-06 06:57:31'), ('47124af2-b173-4656-bccc-47712b2c055f', 'S1 Testing', '2025-09-11 02:22:06', '2025-09-11 02:22:06'), ('5930bd94-a029-4778-af32-890c35c72475', 'Kebidanan', '2025-09-03 03:17:38', '2025-09-03 03:17:38'), ('84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', 'D3 Manajemen Informatik', '2025-09-11 03:12:01', '2025-09-11 03:12:01'), ('8f860a88-9c64-4c98-a445-932011d30f3e', 'S1 Ekosyar', '2025-09-11 02:17:59', '2025-09-11 02:17:59'), ('a0f2e5e0-108b-43c3-beb2-5c78fc790f89', 'S1 Sistem Informasi', '2025-09-08 06:05:29', '2025-09-08 06:05:29'); -- -------------------------------------------------------- -- -- Struktur dari tabel `mata_kuliah` -- CREATE TABLE `mata_kuliah` ( `id` varchar(36) NOT NULL, `kode_mk` varchar(255) NOT NULL, `judul_mk` varchar(255) NOT NULL, `sks` int(11) NOT NULL, `smt` enum('1','2','3','4','5','6','7','8','Umum') NOT NULL DEFAULT 'Umum', `jurusan_id` varchar(36) NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `mata_kuliah` -- INSERT INTO `mata_kuliah` (`id`, `kode_mk`, `judul_mk`, `sks`, `smt`, `jurusan_id`, `created_at`, `updated_at`) VALUES ('131801a2-1eff-48b6-ae3f-a8ca76b5dcaa', 'SSI104', 'Keperawatan Medikal Bedah I', 4, '3', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('14f61686-6981-4ffd-b58d-4b0f01b60769', 'TES137', 'Ilmu Dasar Keperawatan I', 6, '4', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'), ('1e2ed33a-b58e-4b5c-b8b3-20b2f4c50a67', 'TES139', 'Ilmu Dasar Keperawatan I', 5, '6', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('20f9b8f4-185d-42be-bb1b-2a27fc00b55b', 'TES140', 'Ilmu Dasar Keperawatan I', 5, '7', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('29710964-2325-4228-8a8a-bc6fd9c37d6c', 'KEP105', 'Gizi dalam Keperawatan', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('395390e5-b3bd-465a-9c27-5ed7f330a4ea', 'PAI102', 'Sejarah Kebudayaan Islam', 3, '1', '1c5b025c-f211-4dc2-b1a8-cc3244733a92', '2025-09-10 02:58:46', '2025-09-10 02:58:46'), ('3c03120d-e444-4be1-aa36-d2ef8f6264b9', 'SSI110', 'Gizi dalam Keperawatan', 2, 'Umum', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('3f638946-22ae-4402-9c25-cd4139338317', 'TES136', 'Ilmu Dasar Keperawatan I', 5, '3', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'), ('45534869-ce1c-4b00-9007-fba97855f90a', 'SSI105', 'Farmakologi', 3, '4', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('47d172ed-6946-45e4-bd98-d9bd99ac8a55', 'TES134', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:29:06', '2025-09-11 02:29:06'), ('49eef24f-db3c-4063-afcf-b7896585ce29', 'KEP205', 'Keperawatan Gawat Darurat', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('4a4e8ea8-54ae-40ea-b8fd-5800d88c91dd', 'KEP103', 'Komunikasi dalam Keperawatan', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('4c1dd1d4-790b-4f7f-9833-4a01eca866a5', 'TES119', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'), ('4ed3e39e-d8d0-438f-84a0-31864a4afa12', 'SSI109', 'Keperawatan Gawat Darurat', 3, '8', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('54e6481b-47cf-4101-8278-9b1108879051', 'TES124', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:28:05', '2025-09-11 02:28:05'), ('55096d0f-8b0c-4a83-9e79-d328a72af5e5', 'TES135', 'Ilmu Dasar Keperawatan I', 4, '2', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:31:43', '2025-09-11 02:31:43'), ('57dc64d9-69eb-4429-a5cf-a51595aff0d2', 'TES142', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('5b2c5328-bfe5-45b2-b9a0-b10c2943db44', 'TI202512', 'CSS', 4, '1', '4529c966-0a40-4778-844f-06065c948e87', '2025-09-06 06:59:52', '2025-09-10 04:49:48'), ('6967bca0-0e91-427d-a331-589f67645cf4', 'SSI102', 'Etika dan Hukum Keperawatan', 2, '1', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('6fdc1ecb-4b51-4349-8777-093d85d6ed22', 'T1232', 'Tes Matkul', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:42:14', '2025-09-03 04:42:14'), ('707695b4-252b-4094-bef5-d256de4bee16', 'Tes', 'Tes Matkul', 1, 'Umum', '8f860a88-9c64-4c98-a445-932011d30f3e', '2025-09-11 02:22:27', '2025-09-11 02:22:27'), ('762ad85f-9eb8-4ee3-a27d-bc38474cae60', 'SSI101', 'Ilmu Dasar Keperawatan I', 3, '1', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('7db6e7e9-c72c-4500-8bc7-72303b070f36', 'SSI106', 'Keperawatan Jiwa', 4, '5', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('8355ad72-aba6-4efc-997d-8abe6e203e56', 'KEP10122', 'Ilmu Dasar Keperawatan I', 3, '1', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-08 06:15:05', '2025-09-08 06:15:05'), ('94d95bea-927f-4447-8f9c-133eb60a9e73', 'TES146', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('99259372-edb8-484a-9b88-336dc9223a30', 'KEP102', 'Etika dan Hukum Keperawatan', 2, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('9a7f9618-ee10-40b6-b105-43bbed023025', 'MI3212', 'Algoritma Pemrograman', 2, '1', '84c0857b-8584-4ac1-8b5c-1c40cea7b2d1', '2025-09-11 03:12:39', '2025-09-11 03:12:39'), ('9c7e0400-33f2-4e4f-af89-8986104fa828', '2903', 'rama runcandel99', 3, 'Umum', '5930bd94-a029-4778-af32-890c35c72475', '2025-09-04 03:58:54', '2025-09-08 07:14:22'), ('a3b1465d-f5da-4643-a8c3-2bc8f8eba15b', 'TES141', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('a572c0c8-25bd-438b-9782-14c286fa3cc9', 'SSI107', 'Keperawatan Anak', 4, '6', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('af8bb77c-19b0-4ff2-83ea-31ac6cff19da', 'TES144', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('c0d1e473-c063-4697-bac2-b68b1ad6735c', 'KEP2333', 'Ilmu Dasar Keperawatan I', 3, '1', '8f860a88-9c64-4c98-a445-932011d30f3e', '2025-09-11 02:17:59', '2025-09-11 02:17:59'), ('c1dce2ac-8760-4858-b9c2-efda4366d0ee', 'PAI103', 'Ilmu Fikih', 2, '1', '1c5b025c-f211-4dc2-b1a8-cc3244733a92', '2025-09-10 02:58:46', '2025-09-10 02:58:46'), ('c60065de-7949-4c7a-a873-b1d1fd82c3c9', '1', '1111', 1, '7', '4529c966-0a40-4778-844f-06065c948e87', '2025-09-08 04:36:04', '2025-09-08 04:44:14'), ('c66f8c5d-0b30-402d-9c7b-8bca263a4664', 'KEP202', 'Keperawatan Jiwa', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('c9a4a06f-25a6-49e4-9c5c-b00af13be785', 'KEP104', 'Keperawatan Medikal Bedah I', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('c9eb46a7-0963-4f85-94fa-8c7b626b5f8e', 'TES145', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('cd11cec7-7bb5-4bca-a4f5-7dcbd7155c9b', 'TES143', 'Ilmu Dasar Keperawatan I', 5, '8', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:35:08', '2025-09-11 02:35:08'), ('cf0cfbbc-6221-4c5e-8f5e-2a0eca5b539c', 'TES123', 'Ilmu Dasar Keperawatan I', 3, '1', '47124af2-b173-4656-bccc-47712b2c055f', '2025-09-11 02:22:06', '2025-09-11 02:22:06'), ('cfe74de5-2316-420f-ace3-5316de22aef2', 'SSI103', 'Komunikasi dalam Keperawatan', 3, '2', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('de567388-9357-485a-b62b-9a4168acd13e', 'KEP201', 'Farmakologi', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('e958c79d-7614-441a-9d18-0d49fe96d36d', 'KEP101', 'Ilmu Dasar Keperawatan I', 3, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('f2d206ea-7eec-487f-b6a7-6fc256c5e51a', 'SSI108', 'Keperawatan Maternitas', 4, '7', 'a0f2e5e0-108b-43c3-beb2-5c78fc790f89', '2025-09-08 06:05:29', '2025-09-08 06:05:29'), ('f7f91d5f-314e-439a-8b22-84a7751c46d7', 'KEP203', 'Keperawatan Anak', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-03 04:45:51'), ('fb20d782-90f0-4c89-afee-ee9afd91abe6', 'KEP204', 'Keperawatan Maternitas', 4, 'Umum', '1b6e3f60-d66c-48dd-aa6f-b9d807ab1981', '2025-09-03 04:45:51', '2025-09-09 03:22:02'); -- -------------------------------------------------------- -- -- Struktur dari tabel `materials` -- CREATE TABLE `materials` ( `id` bigint(20) UNSIGNED NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `description` text DEFAULT NULL, `file_path` varchar(255) DEFAULT NULL, `video_link` varchar(255) 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 `materials` -- INSERT INTO `materials` (`id`, `meeting_id`, `title`, `description`, `file_path`, `video_link`, `created_at`, `updated_at`) VALUES (21, 132, 'Materi 1', NULL, 'materials/NMPbECpgfoOn26iX9OC75E3NioR2Y6yYGdk7aOZn.pdf', NULL, '2025-09-11 03:21:11', '2025-09-11 03:21:11'); -- -------------------------------------------------------- -- -- Struktur dari tabel `meetings` -- CREATE TABLE `meetings` ( `id` bigint(20) UNSIGNED NOT NULL, `course_code` varchar(255) NOT NULL, `meeting_number` int(11) NOT NULL, `title` varchar(255) NOT NULL, `description` longtext DEFAULT NULL, `type` varchar(50) NOT NULL DEFAULT 'materi', `start_date` datetime DEFAULT NULL, `end_date` datetime 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 `meetings` -- INSERT INTO `meetings` (`id`, `course_code`, `meeting_number`, `title`, `description`, `type`, `start_date`, `end_date`, `created_at`, `updated_at`) VALUES (94, 'KEP105', 1, 'asdfasd', NULL, 'tugas', NULL, NULL, '2025-09-03 09:43:24', '2025-09-03 09:43:24'), (96, 'KEP102', 1, 'xasdasdsa', NULL, 'tugas', NULL, NULL, '2025-09-04 02:56:59', '2025-09-04 02:56:59'), (97, 'KEP205', 1, '2', NULL, 'tugas', NULL, NULL, '2025-09-04 02:58:06', '2025-09-06 09:38:59'), (98, 'KEP204', 1, 'a', NULL, 'absensi', '2025-09-08 09:24:09', '2025-09-08 09:24:12', '2025-09-04 03:06:56', '2025-09-08 03:16:51'), (99, 'KEP204', 1, 'Es', NULL, 'tugas', NULL, NULL, '2025-09-04 03:11:40', '2025-09-04 03:11:40'), (101, 'KEP204', 1, 'Tes', NULL, 'url', NULL, NULL, '2025-09-04 04:00:43', '2025-09-04 04:00:43'), (102, 'TI202512', 1, 'Absensi 1', NULL, 'absensi', '2025-09-06 14:01:40', '2025-09-06 19:01:00', '2025-09-06 07:01:40', '2025-09-06 07:01:40'), (103, 'TI202512', 1, 'Tugas 1', NULL, 'tugas', NULL, NULL, '2025-09-06 07:02:04', '2025-09-06 07:02:04'), (105, 'TI202512', 2, 'Absensi 2', NULL, 'absensi', '2025-09-06 16:50:05', '2025-09-06 16:50:18', '2025-09-06 07:02:46', '2025-09-06 09:50:18'), (106, 'TI202512', 1, 'S', NULL, 'url', NULL, NULL, '2025-09-06 09:57:25', '2025-09-06 09:57:25'), (108, 'KEP204', 7, 'UTS', NULL, 'uts', NULL, NULL, '2025-09-08 06:49:41', '2025-09-08 06:49:41'), (109, 'KEP204', 2, '12', NULL, 'tugas', NULL, NULL, '2025-09-08 06:50:00', '2025-09-08 06:50:00'), (110, 'KEP204', 3, 'Ab', NULL, 'absensi', '2025-09-08 16:27:00', '2025-09-08 22:26:00', '2025-09-08 09:26:19', '2025-09-10 03:58:11'), (122, 'PAI103-G2502', 1, 'Tugas', NULL, 'tugas', NULL, NULL, '2025-09-10 05:20:13', '2025-09-10 05:20:13'), (123, 'PAI103-G2502', 1, 'Ab', NULL, 'absensi', '2025-09-10 12:32:00', '2025-09-17 12:32:00', '2025-09-10 05:32:41', '2025-09-10 05:32:41'), (126, 'KEP204', 2, 'Forum Diskusi Pertemuan 2', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:23:23', '2025-09-10 09:23:23'), (127, 'KEP204', 3, 'Forum Diskusi Pertemuan 3', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:29:37', '2025-09-10 09:29:37'), (128, 'KEP204', 4, 'Forum Diskusi Pertemuan 4', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-10 09:30:35', '2025-09-10 09:30:35'), (129, 'Tes-G2502', 1, 'Absen1', NULL, 'absensi', '2025-09-11 09:44:00', '2025-09-20 09:44:00', '2025-09-11 02:44:54', '2025-09-11 02:45:03'), (130, 'Tes-G2502', 1, 'Tugas', NULL, 'tugas', NULL, NULL, '2025-09-11 02:45:34', '2025-09-11 02:45:34'), (131, 'MI3212-G2502', 1, 'Absensi', NULL, 'absensi', '2025-09-11 10:19:00', '2025-09-11 10:20:37', '2025-09-11 03:19:15', '2025-09-11 03:20:37'), (132, 'MI3212-G2502', 1, 'Materi 1', NULL, 'materi', NULL, NULL, '2025-09-11 03:21:11', '2025-09-11 03:21:11'), (133, 'MI3212-G2502', 2, 'Absensi 2', NULL, 'absensi', '2025-09-18 10:21:00', '2025-09-18 13:21:00', '2025-09-11 03:21:34', '2025-09-11 03:21:34'), (134, 'MI3212-G2502', 2, 'Tugas 1', NULL, 'tugas', NULL, NULL, '2025-09-11 03:22:18', '2025-09-11 03:22:18'), (135, 'MI3212-G2502', 7, 'UTS', NULL, 'uts', NULL, NULL, '2025-09-11 03:23:53', '2025-09-11 03:23:53'), (136, 'MI3212-G2502', 2, 'Link Referensi jurnal', NULL, 'url', NULL, NULL, '2025-09-11 03:25:08', '2025-09-11 03:25:08'), (137, 'MI3212-G2502', 1, 'Forum Diskusi Pertemuan 1', 'Forum diskusi untuk pertemuan ini.', 'forum', NULL, NULL, '2025-09-11 03:44:52', '2025-09-11 03:44:52'); -- -------------------------------------------------------- -- -- Struktur dari tabel `meeting_urls` -- CREATE TABLE `meeting_urls` ( `id` bigint(20) UNSIGNED NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `url_link` varchar(2048) NOT NULL, `url_title` varchar(255) DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `meeting_urls` -- INSERT INTO `meeting_urls` (`id`, `meeting_id`, `url_link`, `url_title`, `created_at`, `updated_at`) VALUES (1, 101, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Buku 123', '2025-09-04 04:00:43', '2025-09-10 03:51:32'), (3, 101, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', NULL, '2025-09-04 04:10:27', '2025-09-10 03:51:32'), (5, 106, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Buku CSS', '2025-09-06 09:57:25', '2025-09-06 09:57:25'), (7, 136, 'https://books.google.co.id/books?hl=en&lr=&id=d5jJDAAAQBAJ&oi=fnd&pg=PA1&dq=sejarah+perkembangan+software+dan+hardware&ots=CS8EYyp4zi&sig=QYKtv2p36D_ks-Iq2ozhzxKaoKU&redir_esc=y#v=onepage&q=sejarah%20perkembangan%20software%20dan%20hardware&f=false', 'Jurnal algoritma pemrograman', '2025-09-11 03:25:08', '2025-09-11 03:25:08'); -- -------------------------------------------------------- -- -- Struktur dari tabel `panduan` -- CREATE TABLE `panduan` ( `id_panduan` int(10) NOT NULL, `kategori` text DEFAULT NULL, `file` varchar(55) DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `panduan` -- INSERT INTO `panduan` (`id_panduan`, `kategori`, `file`, `created_at`, `updated_at`) VALUES (13, 'pkkmb', 'panduan/E8WqVucrdy03VB5CsPgVbTheZIfE2N9YNKu7hqdr.pdf', '2025-09-11 03:15:34', '2025-09-11 03:15:34'); -- -------------------------------------------------------- -- -- Struktur dari tabel `posts` -- CREATE TABLE `posts` ( `id` int(10) UNSIGNED NOT NULL, `user_id` varchar(12) NOT NULL, `meeting_id` bigint(20) UNSIGNED NOT NULL, `title` varchar(255) NOT NULL, `body` text NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `posts` -- INSERT INTO `posts` (`id`, `user_id`, `meeting_id`, `title`, `body`, `created_at`, `updated_at`) VALUES (1, '978NutghekKl', 128, 'Tes', 'Tes', '2025-09-10 09:31:21', '2025-09-10 09:31:21'), (2, '978NutghekKl', 128, 'Tes 2', 'Tes 2', '2025-09-10 09:33:13', '2025-09-10 09:33:13'), (3, 'eecc4bdc-0e7', 137, 'Diskusi terkait database', 'Kenapa relational lebih cocok untuk data mahasiswa?', '2025-09-11 03:45:44', '2025-09-11 03:45:44'), (4, '10eee191-1c6', 137, 'Topik Baru', 'Topik Baru lagi', '2025-09-11 03:46:47', '2025-09-11 03:46:47'); -- -------------------------------------------------------- -- -- Struktur dari tabel `semester` -- CREATE TABLE `semester` ( `id` varchar(36) NOT NULL, `nama` varchar(255) NOT NULL, `tahun_akademik` varchar(255) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT 0, `start_date` date NOT NULL, `end_date` date NOT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Struktur dari tabel `submissions` -- CREATE TABLE `submissions` ( `id` bigint(20) UNSIGNED NOT NULL, `assignment_id` bigint(20) UNSIGNED NOT NULL, `user_id` varchar(20) NOT NULL, `file_path` varchar(255) DEFAULT NULL, `submission_date` datetime NOT NULL, `grade` int(11) DEFAULT NULL, `feedback` text DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `status` varchar(20) NOT NULL DEFAULT 'on-time' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `submissions` -- INSERT INTO `submissions` (`id`, `assignment_id`, `user_id`, `file_path`, `submission_date`, `grade`, `feedback`, `created_at`, `updated_at`, `status`) VALUES (21, 26, '683e75af91f7', 'submissions/1EO48TzdtWxaQW0KwKfniTBPua0h95jjO0iSkuan.png', '2025-09-06 08:58:34', 90, NULL, '2025-09-06 01:58:34', '2025-09-06 02:00:21', 'on-time'), (22, 28, 'a20452bb-91f', 'submissions/66FWPEbNiNdCTEHJpXpVYyrhF9ST1izwI8PqTubW.jpg', '2025-09-06 14:04:33', 83, NULL, '2025-09-06 07:04:33', '2025-09-06 07:04:48', 'on-time'), (24, 29, 'a20452bb-91f', NULL, '2025-09-08 13:53:47', 100, NULL, '2025-09-08 06:53:47', '2025-09-08 06:53:47', 'not submitted'), (25, 29, '683e75af91f7', NULL, '2025-09-08 13:53:47', 89, NULL, '2025-09-08 06:53:47', '2025-09-08 06:53:47', 'not submitted'), (26, 30, 'a20452bb-91f', NULL, '2025-09-08 14:13:57', 50, NULL, '2025-09-08 07:13:57', '2025-09-08 07:13:57', 'not submitted'), (27, 30, '683e75af91f7', NULL, '2025-09-08 14:13:57', 59, NULL, '2025-09-08 07:13:57', '2025-09-08 07:13:57', 'not submitted'), (28, 26, 'a20452bb-91f', 'submissions/OeH946KIBTy8TFMUcxIGzu9rCT7QqQC1UaMgSjFm.jpg', '2025-09-09 10:46:43', NULL, NULL, '2025-09-09 03:46:30', '2025-09-09 03:46:43', 'on-time'), (33, 35, '455fa3b2-2d4', NULL, '2025-09-10 12:24:25', 90, NULL, '2025-09-10 05:24:25', '2025-09-10 05:24:25', 'not submitted'), (34, 36, 'a20452bb-91f', 'submissions/WyWuZDOAOMhla43THsNnK3oq0Ayve3Z4UBVv69MS.pdf', '2025-09-11 09:46:09', 100, NULL, '2025-09-11 02:46:09', '2025-09-11 02:46:39', 'on-time'), (35, 37, '10eee191-1c6', 'submissions/P7EaXOIDs2962syPUMQJ5EQtdPWnFDMcC76tJzHf.pdf', '2025-09-11 10:22:50', 86, NULL, '2025-09-11 03:22:50', '2025-09-11 03:23:09', 'on-time'), (36, 38, '10eee191-1c6', NULL, '2025-09-11 10:24:18', 0, NULL, '2025-09-11 03:24:18', '2025-09-11 03:24:18', 'not submitted'); -- -------------------------------------------------------- -- -- Struktur dari tabel `user` -- CREATE TABLE `user` ( `id_user` varchar(12) NOT NULL, `username` varchar(100) NOT NULL, `no_pokok` varchar(20) DEFAULT NULL, `th_ajaran` varchar(100) DEFAULT NULL, `nohp` varchar(20) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `password` text NOT NULL, `nama` varchar(255) NOT NULL, `level` varchar(50) NOT NULL, `status` enum('inactive','active') NOT NULL, `created_at` datetime NOT NULL, `last_login` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data untuk tabel `user` -- INSERT INTO `user` (`id_user`, `username`, `no_pokok`, `th_ajaran`, `nohp`, `email`, `password`, `nama`, `level`, `status`, `created_at`, `last_login`) VALUES ('10eee191-1c6', 'tesmhs', '12345', 'Ganjil 2025/2026', '085717731737', 'asdfgh864207@gmail.com', '$2y$10$isepO9aWyungh5PSsvuo0.bOu49.OOQMB7e3hqHVwGuIuElrNu7AG', 'Tes mahasiswa Arung Binang', 'mahasiswa', 'active', '2025-09-11 10:09:45', '2025-09-11 10:17:16'), ('116bf384-d98', 'akademikakademik', NULL, '', NULL, NULL, '$2y$10$5QYmNATdihFnBN45WeeFHuC85FfOL8W9.67wN7zrGUWQciZ8lgDbO', 'test akademik', 'Akademik', 'active', '2025-08-29 10:18:34', '2025-08-29 10:18:34'), ('12a276c7-f6f', 'mhs003', '22001123', 'Genap 2024/2025', '898765432', 'mhs002@example.com', '$2y$10$RzaSryFk9FyL.SP4rt5i7.CJ55VjKI1KFq3vJLwPMlu32IHxOC0de', 'haha Mahasiswa', 'mahasiswa', 'active', '2025-09-08 11:42:43', '2025-09-08 11:42:43'), ('1cd1a406-d18', 'bebelacsaiga', NULL, '', NULL, NULL, '$2a$12$PNkhLco1bJs1EBoUS8d3AO1PB0p5YWk7t7C0godnQH3D0VomB1KfS', 'bebelacsaiga', 'dosen', 'active', '2025-09-03 09:46:24', '2025-09-06 16:49:59'), ('1d1031fc-123', 'mhs011', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$XHqEF8rKEUc0vcUBVuHXzOGNwLooX/7MlLohqzHLmCU7O0M.7xY6u', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('29902565-c1a', 'dosen', NULL, NULL, '898765432', 'mhs002@example.com', '$2y$10$8dSBPHjvLmYIh6L8vOLHfed/kWRv61xKygoongLe0ubKAoBLR0RhW', 'Andi', 'dosen', 'active', '2025-09-11 09:10:13', '2025-09-11 09:10:13'), ('373d98ee-6cd', 'mhs1112', '22001123', 'Genap 2024/2025', '898765432', 'mhs002@example.com', '$2y$10$yOfZWFduIvaJL8J5MoYpW.Ug355Pm7DGjBGoGcN/l3Ec5PKPi03bK', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-11 09:10:13', '2025-09-11 09:10:13'), ('37a8522e-224', 'mhs012', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$X10GAbMrSkyRvy.osP18IOKT/H1tUiUTvWYniM9DQD28sObkLxSx6', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('3a9c7dbd-e30', 'akademik123', NULL, '', NULL, NULL, '$2y$10$PahibSQMswD4FKtpScZj1uNU1E6BQY8KD1Bf70bByfa8jsQMGeCNe', 'akademik', 'Akademik', 'active', '2025-09-02 15:43:45', '2025-09-02 15:43:45'), ('40cba965-97a', 'ajeung', '23321024', '', '083128307602', 'ajengmesya028@gmail.com', '$2y$10$JABcYaXBT.V9/cx1ai992.iklCBIMXCDbmw/y4nuz2mkYTtC2t/r2', '20238701', 'mahasiswa', 'active', '2025-08-28 16:30:28', '2025-08-28 16:30:28'), ('455fa3b2-2d4', 'mhs004', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$NwA1LElctCo/E/8SphzukeUf5R3oNz9HXej5tG/bFzRE1.tF9Jwom', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:30', '2025-09-10 10:35:23'), ('59e38636-39b', 'dosendosen', NULL, '', NULL, NULL, '$2y$10$moyJUDE0sQuqpK6AQdZA0ed8XlPil3Hpm8/MB38Lz4ZPciJITyU3y', 'testing dosen', 'dosen', 'active', '2025-09-02 15:41:08', '2025-09-02 15:41:08'), ('675bf741a320', 'mhstes', 'KK822054', '', '0099987676', 'reni@gmail.com', '$2a$12$PNkhLco1bJs1EBoUS8d3AO1PB0p5YWk7t7C0godnQH3D0VomB1KfS', 'mhs1', 'mahasiswa', 'active', '2024-12-13 15:58:41', '2025-09-04 11:29:44'), ('675bf741a3b0', 'reni', 'KK822024', '', '0099987676', 'reni@gamil.com', '$2a$12$PNkhLco1bJs1EBoUS8d3AO1PB0p5YWk7t7C0godnQH3D0VomB1KfS', 'reni', 'dosen', 'active', '2024-12-13 15:58:41', '2025-09-10 16:37:15'), ('6780cbfa9ad7', 'iqbal', '77667766554', '', '0889877654667', 'iqbal@gmail.com', '8b9247873c59602e2f029ac2e79bf5ba', 'iqbal', 'kaprodi', 'active', '2025-01-10 14:27:54', '0000-00-00 00:00:00'), ('6788b5a79eff', 'indah', 'KK792024', '', '082118490093', 'indah@gmail.com', '$2a$12$PNkhLco1bJs1EBoUS8d3AO1PB0p5YWk7t7C0godnQH3D0VomB1KfS', 'Akademik Nilai', 'dosen', 'active', '2025-01-16 14:30:47', '2025-09-06 08:57:34'), ('67b426db8b5b', 'Akademik', '12345', '', '', 'Akademik@gmail.com', '$2a$12$7bUWFYlsejcmUrR2en/IbeqlUxL.2K3OfQGE/sFJefOnOMkzHGXoC', 'Akademik', 'Akademik', 'active', '2025-02-18 13:21:15', '2025-09-04 11:29:24'), ('683e75af91f7', 'Anggun', 'K239124025', '', '089877788', 'anggun@gmail.com', '$2a$12$PNkhLco1bJs1EBoUS8d3AO1PB0p5YWk7t7C0godnQH3D0VomB1KfS', 'Anggun', 'mahasiswa', 'active', '2025-06-03 11:10:23', '2025-09-09 11:21:19'), ('68957465b88e', 'cantik', 'K239124023', '', '32223232', 'admin@gmail.com', 'aae595fb2a787d325ddceb99dc733780', 'CANTIK RAHMA PUTRI', 'mahasiswa', 'active', '2025-08-08 10:52:05', '0000-00-00 00:00:00'), ('689ab2b9eb3d', 'iniakuntest', '334554', '', '087804681458', 'farhanyuswaa@gmail.com', 'c7304af346f97f36818331a8a587f4d7', 'tst', 'kaprodi', 'active', '2025-08-12 10:19:21', '0000-00-00 00:00:00'), ('689daffa836e', 'siti', '23321005', '', '087804681458', 'admin@gmail.com', '1f95d63aa25fd5b027af0df36ca34fb5', 'SITI YUMNAH', 'mahasiswa', 'active', '2025-08-14 16:44:26', '0000-00-00 00:00:00'), ('689ea28a7e70', 'Sri Heryanti', 'K239124035', '', '088887726773', 'sriheryanti@gmail.com', 'a5825a8daa9d9967d07d91f0b2280106', 'Sri Heryanti', 'mahasiswa', 'active', '2025-08-15 09:59:22', '0000-00-00 00:00:00'), ('68a3a03a-dfe', 'mhs009', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$i27OhFzyW5Ulj0KXkDg22OHIHLjEwh0wgI4YGOjk2OEkHrUDRr4HK', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('69ce0fab-5a3', 'farhanyuswa', NULL, '', NULL, NULL, '$2y$10$Z8cWka4BovGwOHsF6NxERebQogFXNB1Z6eUfrawtOFNaDKFtToEX.', 'farhan', 'dosen', 'active', '2025-08-29 11:50:04', '2025-08-29 11:50:04'), ('6a066e7c-2bf', 'dosen005', NULL, NULL, '89525313121', 'dosen@gmail.com', '$2y$10$8JPpY1M1Am54fBxZiMoSce5mmRlYP2XAU26cWvojeON6HSozFl81O', 'dosen005', 'dosen', 'active', '2025-09-10 09:52:48', '2025-09-11 09:43:49'), ('6cfd2a32-a28', 'akbar', '10119023', '', '0895 3525 30898', 'a.muh.akbarsyawal.h@gmail.com', '$2y$10$i.LmokuOdVGbQOm5bTlQwuBVukSyHLxDjlcdJQwyweTY8JYMjuK5m', 'akbar syawal', 'mahasiswa', 'active', '2025-08-22 16:48:54', '2025-08-29 14:57:29'), ('6d00a971-ad1', 'cutnurlela', NULL, '', '0895399920010', 'cutnurela39@gmail.com', '$2y$10$pJ9X0jpL7iClefS5R0HmbuGdnMbxu.GTZeIjz3OsCy1GFbABjNNX6', 'CUT NURELA', 'mahasiswa', 'active', '2025-08-29 11:49:38', '2025-08-29 11:49:38'), ('72d10fb5-9a1', 'mhs005', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs003@example.com', '$2y$10$/5YLCgUZcIBbX0Lt5pUlDeVWCVugYNMudQNm8RD0ALv1rLMfCwHHa', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('75457bfe-633', 'mhs008', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$/CBB6zb8MuEeKBTugztFu.zyiT6eJCozrs864FGstYO7tDb9Vb28u', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('893e0111-630', 'mhs007', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$DVkO1WETYF4OPFywxriJd.OA4R23v1o6ImWfEaZmSLt9l4zPZdPie', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('9029e3f1-a84', 'FarhanFarhan', '10119023', '', '0895 3525 30898', 'a.muh.akbarsyawal.h@gmail.com', '$2y$10$cKcjsUtC9W3dYoxcdpXOr.tdQPVSWszwV0QA8h7ofgI1WFl3PPFA2', 'Farhan Yuswa Biyanto', 'mahasiswa', 'active', '2025-09-02 15:44:29', '2025-09-02 15:44:29'), ('978NutghekKl', 'superadmin', '', '', '', 'admin@kampus.ac.id', '$2y$10$CoEe05H2Opp25vzB.JwCVegZeXNcKJxc2wuxOFHjyMZaITCwZmypG', 'Superadmin', 'superadmin', 'active', '2024-01-05 00:09:26', '2025-09-10 13:29:12'), ('9b031c47-188', 'adminadmin', NULL, '', NULL, NULL, '$2y$10$bKgWRlPLrHN0/jRaQopiYO84o.0hZe9zL970rnw/qMh9RR.mLyp1y', 'Khvide Khasbullah', 'dosen', 'active', '2025-08-29 10:19:08', '2025-08-29 10:19:08'), ('9b23a59e-69d', 'userakdm01', NULL, '', NULL, 'akademik@example.com', '$2y$10$OmyhwrCfqpNxqBClbvKEvewfcJVaA7ZgRwq0Bpv7.TvtsTKOm1JaO', 'Admin Akadem', 'Akademik', 'active', '2025-09-03 11:41:23', '2025-09-04 11:12:45'), ('a20452bb-91f', 'mhs001', '22001122', '', '0898765432', 'mhs@example.com', '$2y$10$kIdY8u7pB5q4dDHhq0fEzOUJK45NW0AajFPEpSYJG57QV./CThZzS', 'Ani Mahasisw', 'mahasiswa', 'active', '2025-09-03 11:41:23', '2025-09-11 09:45:47'), ('a528101b-53e', 'kaprodi', NULL, NULL, NULL, NULL, '$2y$10$ZAMSa0G68ywU6WdIKA89GubMnlhrQnFX51EUPfSQrO1LWxIQJjfPu', 'kaprodi', 'Akademik', 'active', '2025-09-10 09:03:58', '2025-09-11 10:27:19'), ('a7ebcfdd-83c', 'dosen001', NULL, '', '0812345678', 'dosen@example.com', '$2y$10$vN6Jo4SiWrTIRL/7CrSo8edk1lxMi6jdesXX8S1OoaX.QAxqFSqUe', 'Budi Santoso', 'dosen', 'active', '2025-09-03 11:41:23', '2025-09-08 10:33:26'), ('b43d33af-bb5', 'testtest', '23321024', '', '083128307602', 'ajengmesya028@gmail.com', '$2y$10$11Y2sZ4DhvojGa0Ch6EBLuI23n.YbQ1JBTNcqfHm0NvbVcrKU3oom', 'AJEUNG MESYA HERLIANSYAH', 'mahasiswa', 'active', '2025-08-29 10:15:28', '2025-08-29 10:59:41'), ('b5acdf62-8de', 'mhs010', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$gazoEzYyQPZHBfvq9VpVWeDC.kzS.QykSKLoeLNKiT6u24p8YXxrq', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('cb013071-ea4', 'mhs111', '22001123', 'Genap 2024/2025', '898765432', 'mhs002@example.com', '$2y$10$iaQfdloyyJjHJYOcjYdD6OiVrvWMqQMDRegi0SzW7WBcMQHatP/oq', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-11 09:08:58', '2025-09-11 09:08:58'), ('ce1efc81-b45', 'dosen002', NULL, '', NULL, NULL, '$2y$10$x1OC8F14CiNqjPZOUjP85OkEh4vdK1TU/jeP/Uq1JqaBJVjlCAuBW', 'dosen002', 'dosen', 'active', '2025-09-08 10:37:48', '2025-09-08 10:49:50'), ('cecb6b4b-822', 'mhs006', '22001123', 'Ganjil 2025/2026', '898765432', 'mhs002@example.com', '$2y$10$VWo9gSqTEwohKVIOBhVLpONNYIlpT9abowyOR9aqciv1dQOICHLcO', 'haha Mahasisw', 'mahasiswa', 'active', '2025-09-10 09:49:31', '2025-09-10 09:49:31'), ('d6e1f1c8-737', 'akbaresstera', NULL, '', NULL, NULL, '$2y$10$Lj8YIq2Y2oT7wguGutBsWuaSrA1f0x2XZuVnbZ1aklyCr1TpXYjr.', 'akbaresstera', 'Akademik', 'active', '2025-08-29 11:18:19', '2025-08-29 11:18:19'), ('ddfb7eff-86c', 'mhs002', 'mhs002', 'Ganjil 2025/2026', '083128307602', 'mhs002.h@gmail.com', '$2y$10$BLiFPVqmlkFD7.IZPZJ2U.AM9LndbmGDwTvhJUvx2mCeVQEON3d.u', 'mhs002', 'mahasiswa', 'active', '2025-09-08 11:35:59', '2025-09-08 11:35:59'), ('eecc4bdc-0e7', 'dosenstmik', NULL, NULL, NULL, NULL, '$2y$10$UbuZ4rLgtzLk24kT2qdCzux.DKYH.x2nMlqj7tB.z5jF69xxH/wvS', 'Dosen STMIK Arung Binang', 'dosen', 'active', '2025-09-11 10:10:25', '2025-09-11 10:40:42'); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `assignments` -- ALTER TABLE `assignments` ADD PRIMARY KEY (`id`), ADD KEY `fk_assignments_meeting_id` (`meeting_id`); -- -- Indeks untuk tabel `attendances` -- ALTER TABLE `attendances` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `attendances_user_id_meeting_id_unique` (`user_id`,`meeting_id`), ADD KEY `attendances_meeting_id_foreign` (`meeting_id`), ADD KEY `attendances_user_id_foreign` (`user_id`); -- -- Indeks untuk tabel `bobot` -- ALTER TABLE `bobot` ADD PRIMARY KEY (`id`), ADD KEY `course_id` (`course_id`); -- -- Indeks untuk tabel `comments` -- ALTER TABLE `comments` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `post_id` (`post_id`), ADD KEY `parent_id` (`parent_id`); -- -- Indeks untuk tabel `courses` -- ALTER TABLE `courses` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `courses_code_unique` (`code`); -- -- Indeks untuk tabel `enrolments` -- ALTER TABLE `enrolments` ADD PRIMARY KEY (`enrol_id`); -- -- Indeks untuk tabel `jurusan` -- ALTER TABLE `jurusan` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `mata_kuliah` -- ALTER TABLE `mata_kuliah` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `kode_mk_unique` (`kode_mk`), ADD KEY `mata_kuliah_ibfk_1` (`jurusan_id`); -- -- Indeks untuk tabel `materials` -- ALTER TABLE `materials` ADD PRIMARY KEY (`id`), ADD KEY `materials_meeting_id_foreign` (`meeting_id`); -- -- Indeks untuk tabel `meetings` -- ALTER TABLE `meetings` ADD PRIMARY KEY (`id`), ADD KEY `fk_meetings_course_code` (`course_code`); -- -- Indeks untuk tabel `meeting_urls` -- ALTER TABLE `meeting_urls` ADD PRIMARY KEY (`id`), ADD KEY `meeting_urls_meeting_id_foreign` (`meeting_id`); -- -- Indeks untuk tabel `panduan` -- ALTER TABLE `panduan` ADD PRIMARY KEY (`id_panduan`); -- -- Indeks untuk tabel `posts` -- ALTER TABLE `posts` ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `meeting_id` (`meeting_id`); -- -- Indeks untuk tabel `semester` -- ALTER TABLE `semester` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `submissions` -- ALTER TABLE `submissions` ADD PRIMARY KEY (`id`), ADD KEY `fk_submissions_assignment_id` (`assignment_id`), ADD KEY `fk_submissions_user_id` (`user_id`); -- -- Indeks untuk tabel `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id_user`), ADD UNIQUE KEY `email` (`username`), ADD KEY `nohp` (`nohp`) USING BTREE; -- -- AUTO_INCREMENT untuk tabel yang dibuang -- -- -- AUTO_INCREMENT untuk tabel `assignments` -- ALTER TABLE `assignments` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39; -- -- AUTO_INCREMENT untuk tabel `attendances` -- ALTER TABLE `attendances` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31; -- -- AUTO_INCREMENT untuk tabel `comments` -- ALTER TABLE `comments` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT untuk tabel `courses` -- ALTER TABLE `courses` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102; -- -- AUTO_INCREMENT untuk tabel `enrolments` -- ALTER TABLE `enrolments` MODIFY `enrol_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123; -- -- AUTO_INCREMENT untuk tabel `materials` -- ALTER TABLE `materials` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22; -- -- AUTO_INCREMENT untuk tabel `meetings` -- ALTER TABLE `meetings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138; -- -- AUTO_INCREMENT untuk tabel `meeting_urls` -- ALTER TABLE `meeting_urls` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT untuk tabel `panduan` -- ALTER TABLE `panduan` MODIFY `id_panduan` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT untuk tabel `posts` -- ALTER TABLE `posts` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT untuk tabel `submissions` -- ALTER TABLE `submissions` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `assignments` -- ALTER TABLE `assignments` ADD CONSTRAINT `fk_assignments_meeting_id` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `attendances` -- ALTER TABLE `attendances` ADD CONSTRAINT `attendances_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `bobot` -- ALTER TABLE `bobot` ADD CONSTRAINT `bobot_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `comments` -- ALTER TABLE `comments` ADD CONSTRAINT `comments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE, ADD CONSTRAINT `comments_ibfk_2` FOREIGN KEY (`post_id`) REFERENCES `posts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `comments_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `comments` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `mata_kuliah` -- ALTER TABLE `mata_kuliah` ADD CONSTRAINT `mata_kuliah_ibfk_1` FOREIGN KEY (`jurusan_id`) REFERENCES `jurusan` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `materials` -- ALTER TABLE `materials` ADD CONSTRAINT `materials_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `meetings` -- ALTER TABLE `meetings` ADD CONSTRAINT `fk_meetings_course_code` FOREIGN KEY (`course_code`) REFERENCES `courses` (`code`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `meeting_urls` -- ALTER TABLE `meeting_urls` ADD CONSTRAINT `meeting_urls_meeting_id_foreign` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `posts` -- ALTER TABLE `posts` ADD CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE, ADD CONSTRAINT `posts_ibfk_2` FOREIGN KEY (`meeting_id`) REFERENCES `meetings` (`id`) ON DELETE CASCADE; -- -- Ketidakleluasaan untuk tabel `submissions` -- ALTER TABLE `submissions` ADD CONSTRAINT `fk_submissions_assignment_id` FOREIGN KEY (`assignment_id`) REFERENCES `assignments` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `fk_submissions_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id_user`) ON DELETE CASCADE; 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 */;