-- MariaDB dump 10.19 Distrib 10.6.4-MariaDB, for osx10.15 (x86_64) -- -- Host: 127.0.0.1 Database: cbt_late -- ------------------------------------------------------ -- Server version 10.6.4-MariaDB /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `agamas` -- DROP TABLE IF EXISTS `agamas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `agamas` -- LOCK TABLES `agamas` WRITE; /*!40000 ALTER TABLE `agamas` DISABLE KEYS */; INSERT INTO `agamas` VALUES (1,'Islam',NULL,NULL),(2,'Protestan',NULL,NULL),(3,'Katolik',NULL,NULL),(4,'Hindu',NULL,NULL),(5,'Budha',NULL,NULL); /*!40000 ALTER TABLE `agamas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `banksoals` -- DROP TABLE IF EXISTS `banksoals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `banksoals` -- LOCK TABLES `banksoals` WRITE; /*!40000 ALTER TABLE `banksoals` DISABLE KEYS */; /*!40000 ALTER TABLE `banksoals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `directories` -- DROP TABLE IF EXISTS `directories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `directories` -- LOCK TABLES `directories` WRITE; /*!40000 ALTER TABLE `directories` DISABLE KEYS */; INSERT INTO `directories` VALUES (4,'WL3-2022-IKJ','wl3-2022-ikj','2022-01-29 00:40:31','2022-01-29 00:40:31'); /*!40000 ALTER TABLE `directories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `event_ujians` -- DROP TABLE IF EXISTS `event_ujians`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `event_ujians` -- LOCK TABLES `event_ujians` WRITE; /*!40000 ALTER TABLE `event_ujians` DISABLE KEYS */; /*!40000 ALTER TABLE `event_ujians` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `files` -- DROP TABLE IF EXISTS `files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `files` -- LOCK TABLES `files` WRITE; /*!40000 ALTER TABLE `files` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_members` -- DROP TABLE IF EXISTS `group_members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_members` -- LOCK TABLES `group_members` WRITE; /*!40000 ALTER TABLE `group_members` DISABLE KEYS */; /*!40000 ALTER TABLE `group_members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `groups` -- DROP TABLE IF EXISTS `groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `groups` -- LOCK TABLES `groups` WRITE; /*!40000 ALTER TABLE `groups` DISABLE KEYS */; /*!40000 ALTER TABLE `groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `hasil_ujians` -- DROP TABLE IF EXISTS `hasil_ujians`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `hasil_ujians` -- LOCK TABLES `hasil_ujians` WRITE; /*!40000 ALTER TABLE `hasil_ujians` DISABLE KEYS */; /*!40000 ALTER TABLE `hasil_ujians` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jadwals` -- DROP TABLE IF EXISTS `jadwals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jadwals` -- LOCK TABLES `jadwals` WRITE; /*!40000 ALTER TABLE `jadwals` DISABLE KEYS */; /*!40000 ALTER TABLE `jadwals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jawaban_esays` -- DROP TABLE IF EXISTS `jawaban_esays`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jawaban_esays` -- LOCK TABLES `jawaban_esays` WRITE; /*!40000 ALTER TABLE `jawaban_esays` DISABLE KEYS */; /*!40000 ALTER TABLE `jawaban_esays` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jawaban_pesertas` -- DROP TABLE IF EXISTS `jawaban_pesertas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jawaban_pesertas` -- LOCK TABLES `jawaban_pesertas` WRITE; /*!40000 ALTER TABLE `jawaban_pesertas` DISABLE KEYS */; /*!40000 ALTER TABLE `jawaban_pesertas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jawaban_soals` -- DROP TABLE IF EXISTS `jawaban_soals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jawaban_soals` -- LOCK TABLES `jawaban_soals` WRITE; /*!40000 ALTER TABLE `jawaban_soals` DISABLE KEYS */; /*!40000 ALTER TABLE `jawaban_soals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `jurusans` -- DROP TABLE IF EXISTS `jurusans`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `jurusans` -- LOCK TABLES `jurusans` WRITE; /*!40000 ALTER TABLE `jurusans` DISABLE KEYS */; /*!40000 ALTER TABLE `jurusans` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `matpels` -- DROP TABLE IF EXISTS `matpels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `matpels` -- LOCK TABLES `matpels` WRITE; /*!40000 ALTER TABLE `matpels` DISABLE KEYS */; /*!40000 ALTER TABLE `matpels` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_access_tokens` -- DROP TABLE IF EXISTS `oauth_access_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oauth_access_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `user_id` bigint(20) unsigned DEFAULT NULL, `client_id` bigint(20) unsigned NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_access_tokens_user_id_index` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_access_tokens` -- LOCK TABLES `oauth_access_tokens` WRITE; /*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */; INSERT INTO `oauth_access_tokens` VALUES ('3af7b7f09ee26c5c8f086ba166d0e9dd884e27f14adead387ec2a2d7308da1016e3f8457de8f696e',1,1,'Personal Access Token','[]',0,'2022-01-28 05:52:18','2022-01-28 05:52:18','2023-01-28 12:52:18'),('72e6de4882bb32f8d7b9a99f540c61f52f380a1d5022da4ea8be74d82b1d6d1dd610e7a93c162971',1,1,'Personal Access Token','[]',0,'2022-01-28 06:06:32','2022-01-28 06:06:32','2023-01-28 13:06:32'),('84c1622000a23dc3d9c3627f987082dc4b524c53db2ec4b8470d4edcc341477ca163b8695f930939',1,1,'Personal Access Token','[]',0,'2022-01-29 00:29:32','2022-01-29 00:29:32','2023-01-29 07:29:32'),('9c6bdba3bb6088ee6abb346ad6b6f68044aa2f72548957ef9bf891d7a7c1e4fad03cfe6fa12dfc66',1,1,'Personal Access Token','[]',0,'2022-01-28 03:29:33','2022-01-28 03:29:33','2023-01-28 10:29:33'),('fcfbb266d8dae9c5e5ff5f58f8f1dc2cbcd0dd1f14c6b17705a1fad2f658c7f2cc9602a43bc4c8c0',1,1,'Personal Access Token','[]',0,'2022-01-28 06:20:11','2022-01-28 06:20:11','2023-01-28 13:20:11'); /*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_auth_codes` -- DROP TABLE IF EXISTS `oauth_auth_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_auth_codes` -- LOCK TABLES `oauth_auth_codes` WRITE; /*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_clients` -- DROP TABLE IF EXISTS `oauth_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oauth_clients` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned DEFAULT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `provider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL, `personal_access_client` tinyint(1) NOT NULL, `password_client` tinyint(1) NOT NULL, `revoked` tinyint(1) NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), KEY `oauth_clients_user_id_index` (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_clients` -- LOCK TABLES `oauth_clients` WRITE; /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */; INSERT INTO `oauth_clients` VALUES (1,NULL,'Laravel Personal Access Client','VSVf4CbVDBVcBnVAsFKsSku9ucHcIH8WGTenfNxl',NULL,'http://localhost',1,0,0,'2022-01-28 03:21:00','2022-01-28 03:21:00'),(2,NULL,'Laravel Password Grant Client','4UHMj6zObVEP9ficn1TTNRmMf2q99Out1QSVyzLU','users','http://localhost',0,1,0,'2022-01-28 03:21:00','2022-01-28 03:21:00'); /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_personal_access_clients` -- DROP TABLE IF EXISTS `oauth_personal_access_clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_personal_access_clients` -- LOCK TABLES `oauth_personal_access_clients` WRITE; /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */; INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2022-01-28 03:21:00','2022-01-28 03:21:00'); /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `oauth_refresh_tokens` -- DROP TABLE IF EXISTS `oauth_refresh_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `oauth_refresh_tokens` ( `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL, `revoked` tinyint(1) NOT NULL, `expires_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `oauth_refresh_tokens` -- LOCK TABLES `oauth_refresh_tokens` WRITE; /*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */; /*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pesertas` -- DROP TABLE IF EXISTS `pesertas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pesertas` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `sesi` int(11) NOT NULL, `no_ujian` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL, `agama_id` int(11) NOT NULL, `jurusan_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `api_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `pesertas_no_ujian_unique` (`no_ujian`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pesertas` -- LOCK TABLES `pesertas` WRITE; /*!40000 ALTER TABLE `pesertas` DISABLE KEYS */; INSERT INTO `pesertas` VALUES (1,1,'001',2,'1','Ferdian','123','',1,'2022-01-28 06:07:14','2022-01-28 06:18:20'),(2,1,'K0010101010111',1,'2','SHELLREAN','123',NULL,1,'2022-01-29 00:50:14','2022-01-29 00:50:14'),(3,1,'002',1,'2','002','123','',1,'2022-01-29 00:59:56','2022-01-29 01:05:17'); /*!40000 ALTER TABLE `pesertas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sesi_schedules` -- DROP TABLE IF EXISTS `sesi_schedules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sesi_schedules` -- LOCK TABLES `sesi_schedules` WRITE; /*!40000 ALTER TABLE `sesi_schedules` DISABLE KEYS */; INSERT INTO `sesi_schedules` VALUES (1,4,1,'[1,2,3]','2022-01-29 01:00:27','2022-01-29 01:00:27'); /*!40000 ALTER TABLE `sesi_schedules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `settings` -- DROP TABLE IF EXISTS `settings`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `settings` -- LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `siswa_ujians` -- DROP TABLE IF EXISTS `siswa_ujians`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `siswa_ujians` -- LOCK TABLES `siswa_ujians` WRITE; /*!40000 ALTER TABLE `siswa_ujians` DISABLE KEYS */; /*!40000 ALTER TABLE `siswa_ujians` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `soals` -- DROP TABLE IF EXISTS `soals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `soals` -- LOCK TABLES `soals` WRITE; /*!40000 ALTER TABLE `soals` DISABLE KEYS */; /*!40000 ALTER TABLE `soals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tokens` -- DROP TABLE IF EXISTS `tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tokens` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('0','1') 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `tokens` -- LOCK TABLES `tokens` WRITE; /*!40000 ALTER TABLE `tokens` DISABLE KEYS */; INSERT INTO `tokens` VALUES (1,'RQ9BWF','0','2022-01-28 03:29:27','2022-01-29 01:06:30'); /*!40000 ALTER TABLE `tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ujians` -- DROP TABLE IF EXISTS `ujians`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `ujians` -- LOCK TABLES `ujians` WRITE; /*!40000 ALTER TABLE `ujians` DISABLE KEYS */; /*!40000 ALTER TABLE `ujians` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('admin','guru') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'guru', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Administrator','admin@shellrean.com',NULL,'$2y$10$zhj3hRdIouN.U60v.Xqdp.ZxAJ9LoqfEga4Ue4hQCEShINnniZG4S','admin','2022-01-28 03:29:27','2022-01-28 03:29:27'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-01-29 8:11:55