-- phpMyAdmin SQL Dump -- version 4.9.11 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Mar 13, 2023 at 12:17 AM -- Server version: 8.0.32-cll-lve -- PHP Version: 7.4.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; 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: `myforens_exocbt` -- -- -------------------------------------------------------- -- -- Table structure for table `agamas` -- CREATE TABLE `agamas` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `kode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `agamas` -- INSERT INTO `agamas` (`id`, `kode`, `nama`, `created_at`, `updated_at`) VALUES ('3aed771a-9458-4cce-9811-8b0b50bfe462', 'ISLAM', 'Islam', '2023-02-07 04:40:38', '2023-02-07 04:40:38'), ('6e4c117b-b057-44a3-98ab-d54d197030de', 'PROTESTAN', 'Protestan', '2023-02-07 04:40:38', '2023-02-07 04:40:38'), ('8194f3f2-501b-420f-a496-85fded97beb0', 'HINDU', 'Hindu', '2023-02-07 04:40:38', '2023-02-07 04:40:38'), ('b835ff17-369c-4250-a565-000a06953adf', 'BUDHA', 'Budha', '2023-02-07 04:40:38', '2023-02-07 04:40:38'), ('dae66fe2-5785-4b44-892b-6a40c1c2e1f1', 'KATOLIK', 'Katolik', '2023-02-07 04:40:38', '2023-02-07 04:40:38'); -- -------------------------------------------------------- -- -- Table structure for table `banksoals` -- CREATE TABLE `banksoals` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `kode_banksoal` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jumlah_soal` int NOT NULL COMMENT 'jumlah soal pilihan ganda', `jumlah_pilihan` int NOT NULL DEFAULT '4' COMMENT 'jumlah pilihan / opsi pada pilihan ganda', `jumlah_soal_listening` int NOT NULL DEFAULT '0' COMMENT 'jumlah soal listening', `jumlah_pilihan_listening` int NOT NULL DEFAULT '4' COMMENT 'jumlah opsi listening', `jumlah_soal_esay` int DEFAULT '0', `jumlah_soal_ganda_kompleks` int NOT NULL DEFAULT '0' COMMENT 'jumlah soal pilihan ganda kompleks', `jumlah_isian_singkat` int NOT NULL DEFAULT '0' COMMENT 'jumlah isian singkat', `jumlah_menjodohkan` int NOT NULL DEFAULT '0' COMMENT 'jumlah menjodohkan', `jumlah_mengurutkan` int NOT NULL DEFAULT '0' COMMENT 'jumlah mengurutkan', `jumlah_benar_salah` int NOT NULL DEFAULT '0' COMMENT 'jumlah benar-salah', `jumlah_setuju_tidak` int NOT NULL DEFAULT '0' COMMENT 'jumlah setuju-tidak', `is_locked` int NOT NULL DEFAULT '0', `key_lock` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lock_by` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `persen` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matpel_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `author` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `directory_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `banksoal_adaptif` -- CREATE TABLE `banksoal_adaptif` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `matpel_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `max_pg` int NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `directories` -- CREATE TABLE `directories` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `event_ujians` -- CREATE TABLE `event_ujians` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `exo_backups` -- CREATE TABLE `exo_backups` ( `id` bigint UNSIGNED NOT NULL, `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `version` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `generated_date` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `bak_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BACKUP', `status` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SUCCESS', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `feature_infos` -- CREATE TABLE `feature_infos` ( `id` bigint UNSIGNED NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `feature_infos` -- INSERT INTO `feature_infos` (`id`, `name`, `code`, `content`, `created_at`, `updated_at`) VALUES (1, 'form_setting_ujian_event', 'v1', '

Biasanya kita mengadakan ujian

inilah kita sebut 'event'

Bila kolom ini diisi, ujian akan menginduk kepada event yang kita buat pada menu ujian > event ujian

Kelebihan menggunakan event adalah

  1. Ubah setting sesi siswa tiap-tiap event sesuai kebutuhan.
  2. Jadwal dalam kartu ujian siswa
  3. Absensi
  4. Berita Acara
  5. dll

Pada ujian yang menginduk kepada event, sesi ujian siswa harus di setting pada menu event. Sesi pada event dapat berbeda dengan sesi default
Kosongkan kolom ini sehingga sesi tetap menggunakan default

ExtraordinaryCBT

', NULL, NULL), (2, 'page_peserta_tabel', 'v1', '

Manage peserta ujian.

Disini kamu bisa melihat data peserta ujian, yang mana mereka adalah orang-orang yang akan melakukan ujian bisa siswa/umum.

Data yang kamu lihat disini adalah data rahasia karena menyangkut dengan informasi login dan password yang digunakan untuk mengerjakan ujian.

Untuk penginputan data peserta anda bisa menggunakan 2 opsi:

  1. Menggunakan form manual
  2. Menggunakan file excel

Kami sangat menyarankan untuk menggunakan file excel karena dapat mempermudah anda dalam penginputan.

Pada halaman ini juga kamu dapat menghapus data peserta ujian namun harus diingat bahwa ketika anda menghapus peserta maka semua data yang terkait dengan peserta akan ikut terhapus termasuk juga data nilai dan analisa.

 

Extraordinary CBT 

', NULL, NULL), (3, 'page_grup_tabel', 'v1', '

Manage grup

Pada menu ini berisi grup pada ujian.

Apa kegunaan grup?

Grup akan digunakan untuk mengelompokkan peserta ujian. yang mana ini akan berguna pada penjadwalan dan reporting.

Pada grup terdapat 2 tipe yaitu parent dan children.

Parent adalah grup yang memiliki parent \"none\" atau kosong. sedangkan Child adalah grup yang memiliki parent selain \"none\".

Contoh penggunakan grup.

 

 

Pada grup ini juga anda bisa menambahkan anggota, perlu diingat sebaiknya anda menambahkan anggota hanya pada child bila kelas tersebut memiliki child. pada contoh diatas anda sebaiknya menambahkan grup hanya pada 7A, 7B, 7C, 8A tidak pada grup parent.

Jangan pernah menghapus grup bila grup ini telah atau sedang digunakan untuk ujian karena bisa menyebabkan gagal sistem pada saat scanning grup di jadwal.

 

Extraordinary CBT

', NULL, NULL), (4, 'page_jurusan_tabel', 'v1', '

Manage Jurusan

Pada halaman ini kamu dapat melihat data jurusan dalam bentuk tabel.

Jurusan berguna untuk pengelompokan peserta ujian pada jadwal dan reporting. Jurusan memiliki scope lebih besar dan lebih luas dari grup.

Kode jurusan bisa anda isi dengan unique atau biarkan sistem mengenerate otomatis.

Kode jurusan akan digunakan untuk import data peserta ujian.

Perlu diingat dan selalu diingat bahwa pada dasarnya kami sangat tidak menyarankan untuk menghapus data jurusan / mengubah kode jurusan ketika sudah dibuat. 

Sekali kamu menghapus data ujian maka semua data yang terkait dengan jurusan ini akan dihapus termasuk peserta dan saat peserta dihapus maka akan menghapus yang lainnya efek ini akan menjadi domino.

 

Extraordinary CBT

', NULL, NULL), (5, 'page_matpel_tabel', 'v1', '

Manage Matpel A.K.A Mata Pelajaran

Pada halaman ini kamu dapat melihat data mata pelajaran.

Mata pelajaran adalah suatu grup dalam soal.

Terdapat 3 matpel yang dapat kamu tentukan sesuai dengan kebutuhan.

Matpel umum digunakan dan akan dipakai oleh seluruh peserta didik tanpa terkecuali.

Matpel agama digunakan oleh peserta ujian dengan agama yang ditentukan.

Matpel khusus digunakan oleh peserta ujian dengan jurusan yang ditentukan. matpel khusus bisa ditambahkan lebih dari 1 jurusan.

Penggunaan matpel khusus bisa dicontohkan sebagai berikut:

Nama matpel: Matematika Teknik

Jurusan: Teknik Survei dan Pemetaan, Geomatika, Teknik Gambar Bangunan

 

Pada matpel juga anda harus mengisi pengoreksi yang akan memberikan penilaian pada tipe-tipe soal yang berhubungan dengan penilaian manual. Pengoreksi dapat berisi lebih dari 1.

', NULL, NULL), (6, 'page_user_tabel', 'v1', '

Manage user

Pada halaman ini kamu dapat melihat data user.

User dapat diinput menggunakan cara

Kami sangat menyarankan untuk membuat user menggunakan excel untuk kemudahan.

User dapat memiliki akses untuk melakukan penginputan soal dan bisa ditambahkan sebagai tim pengoreksi soal pada data matpel.

 

Extraordinary CBT

', NULL, NULL), (7, 'page_banksoal_tabel', 'v1', '

Manage Banksoal

Pada halaman ini kamu dapat melihat semua banksoal, kalau kamu adalah user standard maka kamu hanya dapat melihat banksoal yang dibuat oleh kamu sendiri.

Banksoal adalah cara aplikasi mengelompokkan soal-soal.

Kamu dapat melakukan edit, hapus, dan juga menghapus banksoal. 

Kami sangat menyarankan untuk mengunci banksoal bila telah selesai melakukan input soal, dengan begitu banksoal anda tidak dapat dilihat, diduplikat apalagi dihapus oleh orang lain termasuk oleh administrator. 

Tetapi kamu harus mengingat password kunci banksoal karena sekali anda lupa, banksoal ini tidak akan terbuka selamanya. tidak ada mekanisme pada aplikasi untuk membuka kunci.

Banksoal yang dikunci masih bisa digunakan untuk ujian siswa. jadi kamu tidak perlu membuka kunci bila banksoal akan digunakan untuk ujian.

Kami sangat tidak menyarankan untuk mengedit apalagi menghapus banksoal saat setelah/sedang dipakai untuk ujian pada jadwal. Kamu dapat menggunakan fitur duplikat.

 

Extraordinary CBT

', NULL, NULL), (8, 'page_soal_tabel', 'v1', '

Manage soal

Pada halaman ini kamu dapat melihat data soal yang berada didalam banksoal.

Soal yang kamu lihat adalah soal yang berurut berdasarkan waktu kamu membuat soal. 

Kamu dapat melihat soal dan opsi pada tabel dengan klik button detail.

 

Terdapat 3 cara input soal

Kami sangat menyarankan untuk menggunakan input form untuk hasil yang lebih baik dan komplek, gunakan import file bila dirasa soal itu berisi text sederhana.

Kami tidak menyarankan anda secara keras untuk mengedit / menekan tombol update meskipun kamu tidak melakukan update. Hal tersebut dapat menyebabkan gagal scanning soal pada analisa dan ujian.

 

Extraordinary CBT

', NULL, NULL), (9, 'page_soal_template_tabel', 'v1', '

Paste soal

Pada halaman ini kamu dapat membuat soal dengan paste soal pada input form yang disediakan. 

Kamu harus menggunakan format yang telah ada. Hanya ada 2 tipe yang dapat diinputkan pada halaman ini yaitu Pilihan Ganda dan Esay.

Pastikan soal yang kamu \"paste\" pada input form sesuai dengan Tipe soal yang dipilih.

 

Extraordinary CBT 

', NULL, NULL), (10, 'page_soal_doc_tabel', 'v1', '

Import soal

Pada halaman ini kamu dapat membuat soal dengan import soal .docx pada form yang disediakan.

Kami menyediakan 2 opsi template yang kamu bisa pakai

 

Pastikan kamu telah memilih tipe soal yang sesuai dengan yang anda akan import.

 

Extraordinary CBT

', NULL, NULL), (11, 'page_status_ujian_table', 'v1', '

Status ujian

Pada halaman ini kamu dapat melihat daftar ujian yang dilaksanakan. jadwal yang ditampilkan pada halaman ini adalah jadwal ujian yang sedang aktif.

Pada halaman ini juga ditampilkan token yang bisa kamu release bila belum aktif.

Setiap record jadwal dapat diganti sesia yang aktif dengan merubah dropdown lalu klik simpan.

 

Extraordinary CBT

', NULL, NULL), (12, 'page_status_peserta_table', 'v1', '

Status peserta

Pada halaman ini kamu dapat melihat peserta ujian yang masuk kedalam ujian. 

Kamu dapat melakukan reset dan force close pada tiap peserta. Force close hanya berlaku jika peserta belum menyelesaikan ujiannya.

Reset ujian akan menghapus nilai dan semua jawaban peserta.

Bila kamu mengaktifkan socket, kamu dimungkinkan untuk melihat status koneksi peserta.

Waktu pengerjaan peserta dimunginkan untuk ditambah bila dirasa mengalami kendala, penambahan waktu tidak diperbolehkan untuk melebihi waktu saat ini. perkirakan penambahan waktu dengan waktu idle peserta.

Contoh kasus: Seandainya peserta menunggu 10 menit untuk perbaikan atau pindah komputer, maka beri tambahan waktu 10 menit bila kamu menambah 15 menit sistem akan menolak request tersebut.

Peserta trouble pukul 09:00, trouble fix pukul 09:10, beri waktu tambahan 10 menit.

 

Extraordinary CBT

', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `files` -- CREATE TABLE `files` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `directory_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `dirname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `filename` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `path` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `exstension` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `size` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `groups` -- CREATE TABLE `groups` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `parent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `group_members` -- CREATE TABLE `group_members` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `group_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `student_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `hasil_ujians` -- CREATE TABLE `hasil_ujians` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ujian_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `banksoal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `peserta_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jumlah_salah` int NOT NULL DEFAULT '0', `jumlah_benar` int NOT NULL DEFAULT '0', `jumlah_benar_complek` int NOT NULL DEFAULT '0', `jumlah_salah_complek` int NOT NULL DEFAULT '0', `jumlah_benar_listening` int NOT NULL DEFAULT '0', `jumlah_salah_listening` int NOT NULL DEFAULT '0', `jumlah_benar_isian_singkat` int NOT NULL DEFAULT '0', `jumlah_salah_isian_singkat` int NOT NULL DEFAULT '0', `jumlah_benar_menjodohkan` int NOT NULL DEFAULT '0', `jumlah_salah_menjodohkan` int NOT NULL DEFAULT '0', `jumlah_benar_mengurutkan` int NOT NULL DEFAULT '0', `jumlah_salah_mengurutkan` int NOT NULL DEFAULT '0', `jumlah_benar_benar_salah` int NOT NULL DEFAULT '0', `jumlah_salah_benar_salah` int NOT NULL DEFAULT '0', `point_esay` double(8,2) NOT NULL, `point_setuju_tidak` double(8,2) NOT NULL, `tidak_diisi` int NOT NULL, `hasil` double(8,2) NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jadwals` -- CREATE TABLE `jadwals` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `banksoal_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `group_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `alias` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal` date NOT NULL, `mulai` time NOT NULL, `lama` int NOT NULL, `min_test` int NOT NULL DEFAULT '0', `status_ujian` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `event_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sesi` int NOT NULL DEFAULT '1', `setting` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mulai_sesi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `view_result` int NOT NULL DEFAULT '0', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jawaban_pesertas` -- CREATE TABLE `jawaban_pesertas` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `banksoal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `soal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `peserta_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jawab` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `jawab_complex` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '[]', `menjodohkan` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mengurutkan` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `benar_salah` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `setuju_tidak` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `esay` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `ragu_ragu` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `iscorrect` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `answered` tinyint(1) NOT NULL DEFAULT '0', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jawaban_soals` -- CREATE TABLE `jawaban_soals` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `soal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `text_jawaban` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `correct` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `jurusans` -- CREATE TABLE `jurusans` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `kode` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `jurusans` -- INSERT INTO `jurusans` (`id`, `kode`, `nama`, `deleted_by`, `deleted_at`) VALUES ('5ed8fa00-cea5-40af-85f6-e2407375ed4b', '1945', 'UMUM (tanpa-jurusan)', NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `matpels` -- CREATE TABLE `matpels` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `kode_mapel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jurusan_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `agama_id` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `correctors` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` int UNSIGNED NOT NULL, `migration` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1, '2014_10_12_000000_create_users_table', 1), (2, '2019_08_19_000000_create_failed_jobs_table', 1), (3, '2019_12_14_000001_create_personal_access_tokens_table', 1), (4, '2020_07_10_011018_create_jurusans_table', 1), (5, '2020_07_10_011145_create_matpels_table', 1), (6, '2020_07_10_011228_create_event_ujians_table', 1), (7, '2020_07_10_011304_create_pesertas_table', 1), (8, '2020_07_10_011355_create_directories_table', 1), (9, '2020_07_10_011431_create_banksoals_table', 1), (10, '2020_07_10_011535_create_files_table', 1), (11, '2020_07_10_011609_create_jadwals_table', 1), (12, '2020_07_10_011707_create_hasil_ujians_table', 1), (13, '2020_07_10_011745_create_soals_table', 1), (14, '2020_07_10_011826_create_jawaban_soals_table', 1), (15, '2020_07_10_011852_create_jawaban_pesertas_table', 1), (16, '2020_07_10_011939_create_jawaban_esays_table', 1), (17, '2020_07_10_012014_create_agamas_table', 1), (18, '2020_07_10_012151_create_settings_table', 1), (19, '2020_07_11_112718_create_siswa_ujians_table', 1), (20, '2020_07_15_120620_create_ujians_table', 1), (21, '2020_07_15_145941_create_tokens_table', 1), (22, '2020_10_18_102712_create_sesi_schedules_table', 1), (23, '2021_03_09_184343_create_groups_table', 1), (24, '2021_03_09_184914_create_group_members_table', 1), (25, '2021_05_12_093907_create_feature_infos_table', 1), (26, '2021_07_17_094457_create_banksoal_adaptif_table', 1), (27, '2021_10_11_102624_create_penilaian_argument_table', 1), (28, '2022_07_26_080234_create_exo_backups_table', 1); -- -------------------------------------------------------- -- -- Table structure for table `penilaian_argument` -- CREATE TABLE `penilaian_argument` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `banksoal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `peserta_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jawab_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `corrected_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `point` double(8,2) NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `penilaian_esay` -- CREATE TABLE `penilaian_esay` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `banksoal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `peserta_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jawab_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `corrected_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `point` double(8,2) NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `personal_access_tokens` -- CREATE TABLE `personal_access_tokens` ( `id` bigint UNSIGNED NOT NULL, `tokenable_type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `last_used_at` timestamp NULL 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 for table `personal_access_tokens` -- INSERT INTO `personal_access_tokens` (`id`, `tokenable_type`, `tokenable_id`, `name`, `token`, `abilities`, `last_used_at`, `created_at`, `updated_at`) VALUES (1, 'App\\User', '78b24c4d-714d-4cf9-a31c-3ec5f420479d', 'personal-token', '955883ca4680ed903194221c1caa4e200996b078867e0d96b548c356bd8e71b6', '[\"*\"]', '2023-03-12 17:16:40', '2023-03-12 15:50:06', '2023-03-12 17:16:40'); -- -------------------------------------------------------- -- -- Table structure for table `pesertas` -- CREATE TABLE `pesertas` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sesi` int NOT NULL, `no_ujian` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `agama_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jurusan_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `nama` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `api_token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int NOT NULL DEFAULT '1', `block_reason` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `antiblock` tinyint(1) NOT NULL DEFAULT '0', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sesi_schedules` -- CREATE TABLE `sesi_schedules` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `sesi` int NOT NULL DEFAULT '1', `peserta_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL 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 for table `settings` -- INSERT INTO `settings` (`id`, `name`, `type`, `value`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES ('314b101b-47c7-41dd-b937-52092e23b334', 'ujian', 'general', '{\"reset\":false}', NULL, NULL, '2023-02-07 04:40:38', '2023-02-07 04:40:38'), ('9f1f0593-2a0b-4046-9785-9740e531de30', 'set_sekolah', 'sekolah', '{\"logo\": \"\", \"nama_sekolah\":\"\",\"email\":\"\",\"alamat\":\"\",\"kepala_sekolah\":\"\",\"nip_kepsek\":\"\",\"tingkat\":\"SMK-SMA\"}', NULL, NULL, '2023-02-07 04:40:38', '2023-03-12 15:50:22'), ('c51fb8e3-cb10-4f31-b115-ba1c3794fdd2', 'token', 'general', '900', NULL, NULL, '2023-02-07 04:40:38', '2023-02-07 04:40:38'); -- -------------------------------------------------------- -- -- Table structure for table `siswa_ujians` -- CREATE TABLE `siswa_ujians` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `peserta_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mulai_ujian` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mulai_ujian_shadow` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `selesai_ujian` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `uploaded` int NOT NULL DEFAULT '0', `sisa_waktu` int NOT NULL, `status_ujian` char(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `out_ujian_counter` int NOT NULL DEFAULT '0', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `soals` -- CREATE TABLE `soals` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `banksoal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tipe_soal` int NOT NULL COMMENT '1: Pilihan Ganda | 2: Esay | 3: Listening', `case_sensitive` int NOT NULL DEFAULT '1', `pertanyaan` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `rujukan` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `audio` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `direction` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `analys` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `layout` int NOT NULL DEFAULT '1', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `tokens` -- CREATE TABLE `tokens` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('0','1') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `tokens` -- INSERT INTO `tokens` (`id`, `token`, `status`, `created_at`, `updated_at`) VALUES ('02a108ea-80d3-4cfd-aa1d-02f6e0a707fa', 'Q5WDOU', '0', '2023-02-07 04:40:38', '2023-03-12 17:10:08'); -- -------------------------------------------------------- -- -- Table structure for table `ujians` -- CREATE TABLE `ujians` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `jadwal_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` enum('aktif','selesai') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'aktif', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT NULL, `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `role` enum('admin','guru') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'guru', `deleted_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted_at` timestamp NULL 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 for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `role`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`) VALUES ('78b24c4d-714d-4cf9-a31c-3ec5f420479d', 'Administrator', 'admin@shellrean.com', NULL, '$2y$10$XiIyoTeTJWzc1JZ.8QLhVuPMeEQZz38hP.OfteOt6YFKQpKZ6worq', 'admin', NULL, NULL, '2023-02-07 04:40:38', '2023-02-07 04:40:38'); -- -- Indexes for dumped tables -- -- -- Indexes for table `agamas` -- ALTER TABLE `agamas` ADD PRIMARY KEY (`id`), ADD KEY `agamas_kode_index` (`kode`); -- -- Indexes for table `banksoals` -- ALTER TABLE `banksoals` ADD PRIMARY KEY (`id`), ADD KEY `banksoals_matpel_id_foreign` (`matpel_id`), ADD KEY `banksoals_author_foreign` (`author`), ADD KEY `banksoals_directory_id_foreign` (`directory_id`), ADD KEY `banksoals_kode_banksoal_matpel_id_author_directory_id_index` (`kode_banksoal`,`matpel_id`,`author`,`directory_id`); -- -- Indexes for table `banksoal_adaptif` -- ALTER TABLE `banksoal_adaptif` ADD PRIMARY KEY (`id`), ADD KEY `banksoal_adaptif_matpel_id_index` (`matpel_id`), ADD KEY `banksoal_adaptif_matpel_id_code_index` (`matpel_id`,`code`); -- -- Indexes for table `directories` -- ALTER TABLE `directories` ADD PRIMARY KEY (`id`), ADD KEY `directories_slug_index` (`slug`); -- -- Indexes for table `event_ujians` -- ALTER TABLE `event_ujians` ADD PRIMARY KEY (`id`); -- -- Indexes for table `exo_backups` -- ALTER TABLE `exo_backups` ADD PRIMARY KEY (`id`); -- -- Indexes for table `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `feature_infos` -- ALTER TABLE `feature_infos` ADD PRIMARY KEY (`id`), ADD KEY `feature_infos_name_index` (`name`); -- -- Indexes for table `files` -- ALTER TABLE `files` ADD PRIMARY KEY (`id`), ADD KEY `files_directory_id_dirname_filename_path_index` (`directory_id`,`dirname`,`filename`,`path`); -- -- Indexes for table `groups` -- ALTER TABLE `groups` ADD PRIMARY KEY (`id`), ADD KEY `groups_parent_id_name_index` (`parent_id`,`name`); -- -- Indexes for table `group_members` -- ALTER TABLE `group_members` ADD PRIMARY KEY (`id`), ADD KEY `group_members_student_id_foreign` (`student_id`), ADD KEY `group_members_group_id_student_id_index` (`group_id`,`student_id`); -- -- Indexes for table `hasil_ujians` -- ALTER TABLE `hasil_ujians` ADD PRIMARY KEY (`id`), ADD KEY `hasil_ujians_peserta_id_foreign` (`peserta_id`), ADD KEY `hasil_ujians_jadwal_id_foreign` (`jadwal_id`), ADD KEY `hasil_ujians_banksoal_id_peserta_id_jadwal_id_ujian_id_index` (`banksoal_id`,`peserta_id`,`jadwal_id`,`ujian_id`); -- -- Indexes for table `jadwals` -- ALTER TABLE `jadwals` ADD PRIMARY KEY (`id`), ADD KEY `jadwals_tanggal_status_ujian_event_id_index` (`tanggal`,`status_ujian`,`event_id`); -- -- Indexes for table `jawaban_pesertas` -- ALTER TABLE `jawaban_pesertas` ADD PRIMARY KEY (`id`), ADD KEY `jawaban_pesertas_soal_id_foreign` (`soal_id`), ADD KEY `jawaban_pesertas_peserta_id_foreign` (`peserta_id`), ADD KEY `jawaban_pesertas_jadwal_id_foreign` (`jadwal_id`), ADD KEY `jawaban_pesertas_banksoal_id_soal_id_peserta_id_jadwal_id_index` (`banksoal_id`,`soal_id`,`peserta_id`,`jadwal_id`); -- -- Indexes for table `jawaban_soals` -- ALTER TABLE `jawaban_soals` ADD PRIMARY KEY (`id`), ADD KEY `jawaban_soals_soal_id_correct_index` (`soal_id`,`correct`); -- -- Indexes for table `jurusans` -- ALTER TABLE `jurusans` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `kode` (`kode`), ADD KEY `jurusans_kode_index` (`kode`); -- -- Indexes for table `matpels` -- ALTER TABLE `matpels` ADD PRIMARY KEY (`id`), ADD KEY `matpels_kode_mapel_index` (`kode_mapel`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `penilaian_argument` -- ALTER TABLE `penilaian_argument` ADD PRIMARY KEY (`id`), ADD KEY `penilaian_argument_peserta_id_foreign` (`peserta_id`), ADD KEY `penilaian_argument_jawab_id_foreign` (`jawab_id`), ADD KEY `penilaian_argument_corrected_by_foreign` (`corrected_by`), ADD KEY `penilaian_argument_banksoal_id_peserta_id_jawab_id_index` (`banksoal_id`,`peserta_id`,`jawab_id`); -- -- Indexes for table `penilaian_esay` -- ALTER TABLE `penilaian_esay` ADD PRIMARY KEY (`id`), ADD KEY `penilaian_esay_peserta_id_foreign` (`peserta_id`), ADD KEY `penilaian_esay_jawab_id_foreign` (`jawab_id`), ADD KEY `penilaian_esay_corrected_by_foreign` (`corrected_by`), ADD KEY `penilian_esay_indexse` (`banksoal_id`,`peserta_id`,`jawab_id`,`corrected_by`); -- -- Indexes for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`), ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`); -- -- Indexes for table `pesertas` -- ALTER TABLE `pesertas` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `pesertas_no_ujian_unique` (`no_ujian`), ADD KEY `pesertas_no_ujian_api_token_index` (`no_ujian`,`api_token`); -- -- Indexes for table `sesi_schedules` -- ALTER TABLE `sesi_schedules` ADD PRIMARY KEY (`id`), ADD KEY `sesi_schedules_jadwal_id_sesi_index` (`jadwal_id`,`sesi`); -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`), ADD KEY `settings_name_index` (`name`); -- -- Indexes for table `siswa_ujians` -- ALTER TABLE `siswa_ujians` ADD PRIMARY KEY (`id`), ADD KEY `siswa_ujians_jadwal_id_foreign` (`jadwal_id`), ADD KEY `siswa_ujians_peserta_id_jadwal_id_status_ujian_index` (`peserta_id`,`jadwal_id`,`status_ujian`); -- -- Indexes for table `soals` -- ALTER TABLE `soals` ADD PRIMARY KEY (`id`), ADD KEY `soals_banksoal_id_tipe_soal_index` (`banksoal_id`,`tipe_soal`); -- -- Indexes for table `tokens` -- ALTER TABLE `tokens` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ujians` -- ALTER TABLE `ujians` ADD PRIMARY KEY (`id`), ADD KEY `ujians_jadwal_id_status_index` (`jadwal_id`,`status`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `users_email_unique` (`email`), ADD KEY `users_email_role_index` (`email`,`role`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `exo_backups` -- ALTER TABLE `exo_backups` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `feature_infos` -- ALTER TABLE `feature_infos` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `personal_access_tokens` -- ALTER TABLE `personal_access_tokens` MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- Constraints for dumped tables -- -- -- Constraints for table `banksoals` -- ALTER TABLE `banksoals` ADD CONSTRAINT `banksoals_author_foreign` FOREIGN KEY (`author`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `banksoals_directory_id_foreign` FOREIGN KEY (`directory_id`) REFERENCES `directories` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `banksoals_matpel_id_foreign` FOREIGN KEY (`matpel_id`) REFERENCES `matpels` (`id`) ON DELETE CASCADE; -- -- Constraints for table `group_members` -- ALTER TABLE `group_members` ADD CONSTRAINT `group_members_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `group_members_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `hasil_ujians` -- ALTER TABLE `hasil_ujians` ADD CONSTRAINT `hasil_ujians_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `hasil_ujians_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `hasil_ujians_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `jawaban_pesertas` -- ALTER TABLE `jawaban_pesertas` ADD CONSTRAINT `jawaban_pesertas_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `jawaban_pesertas_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `jawaban_pesertas_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `jawaban_pesertas_soal_id_foreign` FOREIGN KEY (`soal_id`) REFERENCES `soals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `jawaban_soals` -- ALTER TABLE `jawaban_soals` ADD CONSTRAINT `jawaban_soals_soal_id_foreign` FOREIGN KEY (`soal_id`) REFERENCES `soals` (`id`) ON DELETE CASCADE; -- -- Constraints for table `penilaian_argument` -- ALTER TABLE `penilaian_argument` ADD CONSTRAINT `penilaian_argument_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_argument_corrected_by_foreign` FOREIGN KEY (`corrected_by`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_argument_jawab_id_foreign` FOREIGN KEY (`jawab_id`) REFERENCES `jawaban_pesertas` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_argument_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `penilaian_esay` -- ALTER TABLE `penilaian_esay` ADD CONSTRAINT `penilaian_esay_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_esay_corrected_by_foreign` FOREIGN KEY (`corrected_by`) REFERENCES `users` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_esay_jawab_id_foreign` FOREIGN KEY (`jawab_id`) REFERENCES `jawaban_pesertas` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `penilaian_esay_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `siswa_ujians` -- ALTER TABLE `siswa_ujians` ADD CONSTRAINT `siswa_ujians_jadwal_id_foreign` FOREIGN KEY (`jadwal_id`) REFERENCES `jadwals` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `siswa_ujians_peserta_id_foreign` FOREIGN KEY (`peserta_id`) REFERENCES `pesertas` (`id`) ON DELETE CASCADE; -- -- Constraints for table `soals` -- ALTER TABLE `soals` ADD CONSTRAINT `soals_banksoal_id_foreign` FOREIGN KEY (`banksoal_id`) REFERENCES `banksoals` (`id`) 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 */;