--
-- Host: 127.0.0.1    Database: cbt_late
-- ------------------------------------------------------


--
-- Table structure for table `agamas`
--

CREATE TABLE `agamas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `agamas`
--

INSERT INTO `agamas` VALUES (1,'Islam',NULL,NULL),(2,'Protestan',NULL,NULL),(3,'Katolik',NULL,NULL),(4,'Hindu',NULL,NULL),(5,'Budha',NULL,NULL);

--
-- Table structure for table `banksoals`
--

CREATE TABLE `banksoals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kode_banksoal` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jumlah_soal` int(11) NOT NULL COMMENT 'jumlah soal pilihan ganda',
  `jumlah_pilihan` int(11) NOT NULL DEFAULT 4 COMMENT 'jumlah pilihan / opsi pada pilihan ganda',
  `jumlah_soal_listening` int(11) NOT NULL DEFAULT 0 COMMENT 'jumlah soal listening',
  `jumlah_pilihan_listening` int(11) NOT NULL DEFAULT 4 COMMENT 'jumlah opsi listening',
  `jumlah_soal_esay` int(11) DEFAULT 0,
  `jumlah_soal_ganda_kompleks` int(11) NOT NULL DEFAULT 0 COMMENT 'jumlah soal pilihan ganda kompleks',
  `jumlah_isian_singkat` int(11) NOT NULL DEFAULT 0 COMMENT 'jumlah isian singkat',
  `jumlah_menjodohkan` int(11) NOT NULL DEFAULT 0 COMMENT 'jumlah menjodohkan',
  `persen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `matpel_id` bigint(20) unsigned NOT NULL,
  `author` bigint(20) unsigned NOT NULL,
  `directory_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `banksoals_matpel_id_foreign` (`matpel_id`),
  KEY `banksoals_author_foreign` (`author`),
  KEY `banksoals_directory_id_foreign` (`directory_id`),
  CONSTRAINT `banksoals_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `banksoals_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `banksoals_matpel_id_foreign` FOREIGN KEY (`matpel_id`) REFERENCES `matpels` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banksoals`
--


--
-- Table structure for table `directories`
--

CREATE TABLE `directories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `directories`
--

INSERT INTO `directories` VALUES (4,'WL3-2022-IKJ','wl3-2022-ikj','2022-01-29 00:40:31','2022-01-29 00:40:31');

--
-- Table structure for table `event_ujians`
--

CREATE TABLE `event_ujians` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `event_ujians`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `directory_id` bigint(20) unsigned NOT NULL,
  `dirname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `filename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `exstension` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` VALUES (7,2,'arc-2022-dda','20220128110046-WhatsApp Image 2022-01-27 at 8.10.25 PM.jpeg','public/arc-2022-dda/20220128110046-WhatsApp Image 2022-01-27 at 8.10.25 PM.jpeg','jpeg','109495','2022-01-28 04:00:46','2022-01-28 04:00:46'),(8,2,'arc-2022-dda','20220128110145-Screen Shot 2022-01-25 at 15.29.17.png','public/arc-2022-dda/20220128110145-Screen Shot 2022-01-25 at 15.29.17.png','png','156050','2022-01-28 04:01:45','2022-01-28 04:01:45'),(9,3,'vyn-2022-haha','16433505831.jpeg','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505831.jpeg','jpeg','0',NULL,NULL),(10,3,'vyn-2022-haha','16433505832.jpeg','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505832.jpeg','jpeg','0',NULL,NULL),(11,3,'vyn-2022-haha','16433505833.png','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505833.png','png','0',NULL,NULL),(12,3,'vyn-2022-haha','16433505834.jpeg','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505834.jpeg','jpeg','0',NULL,NULL),(13,3,'vyn-2022-haha','16433505835.jpeg','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505835.jpeg','jpeg','0',NULL,NULL),(14,3,'vyn-2022-haha','16433505836.jpeg','/Users/macpro/Documents/dev/prod/exo/exo-cbt/exo-cbt-service-late/public/wormhole/public/vyn-2022-haha/16433505836.jpeg','jpeg','0',NULL,NULL);

--
-- Table structure for table `group_members`
--

CREATE TABLE `group_members` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `student_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_members_group_id_foreign` (`group_id`),
  KEY `group_members_student_id_foreign` (`student_id`),
  CONSTRAINT `group_members_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `group_members_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_members`
--


--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--


--
-- Table structure for table `hasil_ujians`
--

CREATE TABLE `hasil_ujians` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `banksoal_id` bigint(20) unsigned NOT NULL,
  `peserta_id` bigint(20) unsigned NOT NULL,
  `jadwal_id` bigint(20) unsigned NOT NULL,
  `jumlah_salah` int(11) NOT NULL DEFAULT 0,
  `jumlah_benar` int(11) NOT NULL DEFAULT 0,
  `jumlah_benar_complek` int(11) NOT NULL DEFAULT 0,
  `jumlah_salah_complek` int(11) NOT NULL DEFAULT 0,
  `jumlah_benar_listening` int(11) NOT NULL DEFAULT 0,
  `jumlah_salah_listening` int(11) NOT NULL DEFAULT 0,
  `jumlah_benar_isian_singkat` int(11) NOT NULL DEFAULT 0,
  `jumlah_salah_isian_singkat` int(11) NOT NULL DEFAULT 0,
  `jumlah_benar_menjodohkan` int(11) NOT NULL DEFAULT 0,
  `jumlah_salah_menjodohkan` int(11) NOT NULL DEFAULT 0,
  `point_esay` double(8,2) NOT NULL,
  `tidak_diisi` int(11) NOT NULL,
  `hasil` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hasil_ujians_peserta_id_foreign` (`peserta_id`),
  KEY `hasil_ujians_banksoal_id_foreign` (`banksoal_id`),
  KEY `hasil_ujians_jadwal_id_foreign` (`jadwal_id`),
  CONSTRAINT `hasil_ujians_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hasil_ujians_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `hasil_ujians_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hasil_ujians`
--


--
-- Table structure for table `jadwals`
--

CREATE TABLE `jadwals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `banksoal_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `alias` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `mulai` time NOT NULL,
  `lama` int(11) NOT NULL,
  `status_ujian` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `sesi` int(11) NOT NULL DEFAULT 1,
  `setting` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mulai_sesi` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '{}',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jadwals`
--


--
-- Table structure for table `jawaban_esays`
--

CREATE TABLE `jawaban_esays` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `banksoal_id` bigint(20) unsigned NOT NULL,
  `peserta_id` bigint(20) unsigned NOT NULL,
  `jawab_id` bigint(20) unsigned NOT NULL,
  `corrected_by` bigint(20) unsigned NOT NULL,
  `point` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jawaban_esays_banksoal_id_foreign` (`banksoal_id`),
  KEY `jawaban_esays_peserta_id_foreign` (`peserta_id`),
  KEY `jawaban_esays_jawab_id_foreign` (`jawab_id`),
  KEY `jawaban_esays_corrected_by_foreign` (`corrected_by`),
  CONSTRAINT `jawaban_esays_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_esays_corrected_by_foreign` FOREIGN KEY (`corrected_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_esays_jawab_id_foreign` FOREIGN KEY (`jawab_id`) REFERENCES `jawaban_pesertas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_esays_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jawaban_esays`
--


--
-- Table structure for table `jawaban_pesertas`
--

CREATE TABLE `jawaban_pesertas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `banksoal_id` bigint(20) unsigned NOT NULL,
  `soal_id` bigint(20) unsigned NOT NULL,
  `peserta_id` bigint(20) unsigned NOT NULL,
  `jadwal_id` bigint(20) unsigned NOT NULL,
  `jawab` bigint(20) NOT NULL,
  `jawab_complex` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '[]',
  `esay` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ragu_ragu` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `iscorrect` char(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jawaban_pesertas_banksoal_id_foreign` (`banksoal_id`),
  KEY `jawaban_pesertas_soal_id_foreign` (`soal_id`),
  KEY `jawaban_pesertas_peserta_id_foreign` (`peserta_id`),
  KEY `jawaban_pesertas_jadwal_id_foreign` (`jadwal_id`),
  CONSTRAINT `jawaban_pesertas_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_pesertas_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_pesertas_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `jawaban_pesertas_soal_id_foreign` FOREIGN KEY (`soal_id`) REFERENCES `soals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jawaban_pesertas`
--


--
-- Table structure for table `jawaban_soals`
--

CREATE TABLE `jawaban_soals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `soal_id` bigint(20) unsigned NOT NULL,
  `text_jawaban` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `correct` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `jawaban_soals_soal_id_foreign` (`soal_id`),
  CONSTRAINT `jawaban_soals_soal_id_foreign` FOREIGN KEY (`soal_id`) REFERENCES `soals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jawaban_soals`
--


--
-- Table structure for table `jurusans`
--

CREATE TABLE `jurusans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jurusans`
--


--
-- Table structure for table `matpels`
--

CREATE TABLE `matpels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `kode_mapel` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jurusan_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agama_id` int(11) DEFAULT 0,
  `correctors` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `matpels`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2016_06_01_000001_create_oauth_auth_codes_table',1),(3,'2016_06_01_000002_create_oauth_access_tokens_table',1),(4,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(5,'2016_06_01_000004_create_oauth_clients_table',1),(6,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(7,'2019_08_19_000000_create_failed_jobs_table',1),(8,'2020_07_10_011018_create_jurusans_table',1),(9,'2020_07_10_011145_create_matpels_table',1),(10,'2020_07_10_011228_create_event_ujians_table',1),(11,'2020_07_10_011304_create_pesertas_table',1),(12,'2020_07_10_011355_create_directories_table',1),(13,'2020_07_10_011431_create_banksoals_table',1),(14,'2020_07_10_011535_create_files_table',1),(15,'2020_07_10_011609_create_jadwals_table',1),(16,'2020_07_10_011707_create_hasil_ujians_table',1),(17,'2020_07_10_011745_create_soals_table',1),(18,'2020_07_10_011826_create_jawaban_soals_table',1),(19,'2020_07_10_011852_create_jawaban_pesertas_table',1),(20,'2020_07_10_011939_create_jawaban_esays_table',1),(21,'2020_07_10_012014_create_agamas_table',1),(22,'2020_07_10_012151_create_settings_table',1),(23,'2020_07_11_112718_create_siswa_ujians_table',1),(24,'2020_07_15_120620_create_ujians_table',1),(25,'2020_07_15_145941_create_tokens_table',1),(26,'2020_10_18_102712_create_sesi_schedules_table',1),(27,'2021_03_09_184343_create_groups_table',1),(28,'2021_03_09_184914_create_group_members_table',1);

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2022-01-28 03:21:00','2022-01-28 03:21:00');

--
-- Table structure for table `sesi_schedules`
--

CREATE TABLE `sesi_schedules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `jadwal_id` bigint(20) unsigned NOT NULL,
  `sesi` int(11) NOT NULL DEFAULT 1,
  `peserta_ids` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sesi_schedules`
--

INSERT INTO `sesi_schedules` VALUES (1,4,1,'[1,2,3]','2022-01-29 01:00:27','2022-01-29 01:00:27');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'set_sekolah','sekolah','{\"logo\":\"\",\"nama_sekolah\":\"\",\"email\":\"\",\"alamat\":\"\",\"kepala_sekolah\":\"\",\"nip_kepsek\":\"\"}','2022-01-28 03:29:27','2022-01-29 00:32:18');

--
-- Table structure for table `siswa_ujians`
--

CREATE TABLE `siswa_ujians` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `peserta_id` bigint(20) unsigned NOT NULL,
  `jadwal_id` bigint(20) unsigned NOT NULL,
  `mulai_ujian` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mulai_ujian_shadow` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `uploaded` int(11) NOT NULL DEFAULT 0,
  `sisa_waktu` int(11) NOT NULL,
  `status_ujian` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `siswa_ujians_peserta_id_foreign` (`peserta_id`),
  KEY `siswa_ujians_jadwal_id_foreign` (`jadwal_id`),
  CONSTRAINT `siswa_ujians_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE,
  CONSTRAINT `siswa_ujians_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `siswa_ujians`
--


--
-- Table structure for table `soals`
--

CREATE TABLE `soals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `banksoal_id` bigint(20) unsigned NOT NULL,
  `tipe_soal` int(11) NOT NULL COMMENT '1: Pilihan Ganda | 2: Esay | 3: Listening',
  `pertanyaan` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `rujukan` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `analys` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `layout` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `soals_banksoal_id_foreign` (`banksoal_id`),
  CONSTRAINT `soals_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `soals`
--


--
-- Table structure for table `ujians`
--

CREATE TABLE `ujians` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `jadwal_id` bigint(20) unsigned NOT NULL,
  `status` enum('aktif','selesai') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aktif',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ujians`
--



