text: -- Adminer 4.7.7 MySQL dump
  
  SET NAMES utf8;
  SET time_zone = '+00:00';
  SET foreign_key_checks = 0;
  SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
  
  SET NAMES utf8mb4;
  
  CREATE TABLE `absen_harian` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_user` int(11) NOT NULL,
    `level` varchar(20) DEFAULT 'siswa',
    `hadir` date DEFAULT NULL,
    `waktu` time DEFAULT NULL,
    `tahun` int(11) DEFAULT NULL,
    `bulan` tinyint(4) DEFAULT NULL,
    `hari` tinyint(4) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3627 DEFAULT CHARSET=utf8mb4;
  
  
  CREATE TABLE `agama` (
    `agamaku` varchar(25) CHARACTER SET latin1 DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  INSERT INTO `agama` (`agamaku`) VALUES
  ('Islam'),
  ('Kristen Katolik'),
  ('Kristen Protestan'),
  ('Hindu'),
  ('Buddha'),
  ('Kong Hu Cu'),
  ('Kristen');
  
  CREATE TABLE `berita` (
    `id_berita` int(11) NOT NULL AUTO_INCREMENT,
    `id_mapel` int(11) NOT NULL,
    `sesi` varchar(10) NOT NULL,
    `ruang` varchar(20) NOT NULL,
    `jenis` varchar(30) NOT NULL,
    `ikut` varchar(10) DEFAULT NULL,
    `susulan` varchar(10) DEFAULT NULL,
    `no_susulan` text DEFAULT NULL,
    `mulai` varchar(10) DEFAULT NULL,
    `selesai` varchar(10) DEFAULT NULL,
    `nama_proktor` varchar(50) DEFAULT NULL,
    `nip_proktor` varchar(50) DEFAULT NULL,
    `nama_pengawas` varchar(50) DEFAULT NULL,
    `nip_pengawas` varchar(50) DEFAULT NULL,
    `catatan` text DEFAULT NULL,
    `tgl_ujian` varchar(20) DEFAULT NULL,
    PRIMARY KEY (`id_berita`)
  ) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `file_pendukung` (
    `id_file` int(11) NOT NULL AUTO_INCREMENT,
    `id_mapel` int(11) DEFAULT 0,
    `nama_file` varchar(50) DEFAULT NULL,
    `status_file` int(11) DEFAULT NULL,
    PRIMARY KEY (`id_file`)
  ) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `jawaban` (
    `id_jawaban` int(11) NOT NULL AUTO_INCREMENT,
    `id_siswa` int(11) NOT NULL,
    `id_mapel` int(11) NOT NULL,
    `id_soal` int(11) NOT NULL,
    `id_ujian` int(11) NOT NULL,
    `jawaban` char(1) DEFAULT NULL,
    `jawabx` char(1) DEFAULT NULL,
    `jenis` int(11) NOT NULL,
    `esai` text DEFAULT NULL,
    `nilai_esai` int(11) NOT NULL DEFAULT 0,
    `ragu` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id_jawaban`)
  ) ENGINE=InnoDB AUTO_INCREMENT=171859 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `jawaban_tugas` (
    `id_jawaban` int(11) NOT NULL AUTO_INCREMENT,
    `id_siswa` int(11) DEFAULT NULL,
    `id_tugas` int(11) DEFAULT NULL,
    `jawaban` longtext DEFAULT NULL,
    `file` varchar(255) DEFAULT NULL,
    `tgl_dikerjakan` datetime DEFAULT NULL,
    `tgl_update` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `nilai` varchar(5) DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id_jawaban`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `jenis` (
    `id_jenis` varchar(30) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `status` varchar(20) DEFAULT NULL,
    PRIMARY KEY (`id_jenis`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO `jenis` (`id_jenis`, `nama`, `status`) VALUES
  ('PAS',	'Penilaian Akhir Semester',	'tidak'),
  ('PAT',	'Penilaian Akhir Tahun',	'tidak'),
  ('PTS',	'Penilaian Tengah Semester',	'aktif'),
  ('ULH',	'ULANGAN HARIAN',	'tidak'),
  ('USBK',	'Ujian Sekolah',	'tidak');
  
  CREATE TABLE `jurusan` (
    `jurusan_id` varchar(25) NOT NULL,
    `nama_jurusan_sp` varchar(100) DEFAULT NULL,
    `kurikulum` varchar(120) DEFAULT NULL,
    `jurusan_sp_id` varchar(50) DEFAULT NULL,
    `kurikulum_id` varchar(20) DEFAULT NULL,
    `sekolah_id` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`jurusan_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `kelas` (
    `id_kelas` varchar(11) NOT NULL,
    `level` varchar(20) NOT NULL,
    `nama` varchar(30) NOT NULL,
    `rombongan_belajar_id` varchar(50) DEFAULT NULL,
    `semester_id` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id_kelas`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO `kelas` (`id_kelas`, `level`, `nama`, `rombongan_belajar_id`, `semester_id`) VALUES
  ('X NA',	'X',	'X NA',	NULL,	NULL),
  ('X NB',	'X',	'X NB',	NULL,	NULL),
  ('X TA',	'X',	'X TA',	NULL,	NULL),
  ('X TB',	'X',	'X TB',	NULL,	NULL),
  ('XI NA',	'XI',	'XI NA',	NULL,	NULL),
  ('XI NB',	'XI ',	'XI NB',	NULL,	NULL),
  ('XI NC',	'XI',	'XI NC',	NULL,	NULL),
  ('XI TA',	'XI',	'XI TA',	NULL,	NULL),
  ('XI TB',	'XI',	'XI TB',	NULL,	NULL),
  ('XI TC',	'XI',	'XI TC',	NULL,	NULL),
  ('XII NA',	'XII',	'XII NA',	NULL,	NULL),
  ('XII NB',	'XII',	'XII NB',	NULL,	NULL),
  ('XII NC',	'XII',	'XII NC',	NULL,	NULL),
  ('XII ND',	'XII',	'XII ND',	NULL,	NULL),
  ('XII TA',	'XII',	'XII TA',	NULL,	NULL),
  ('XII TB',	'XII',	'XII TB',	NULL,	NULL),
  ('XII TC',	'XII',	'XII TC',	NULL,	NULL);
  
  CREATE TABLE `level` (
    `kode_level` varchar(5) NOT NULL,
    `keterangan` varchar(50) NOT NULL,
    `rombongan_belajar_id` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`kode_level`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO `level` (`kode_level`, `keterangan`, `rombongan_belajar_id`) VALUES
  ('EX',	'ALUMNI',	NULL),
  ('X',	'Kelas X',	NULL),
  ('XI',	'Kelas XI',	NULL),
  ('XII',	'Kelas XII',	NULL);
  
  CREATE TABLE `log` (
    `id_log` int(11) NOT NULL AUTO_INCREMENT,
    `id_siswa` int(11) NOT NULL,
    `type` varchar(20) NOT NULL,
    `text` varchar(20) NOT NULL,
    `date` varchar(20) NOT NULL,
    PRIMARY KEY (`id_log`)
  ) ENGINE=InnoDB AUTO_INCREMENT=33512 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `mapel` (
    `id_mapel` int(11) NOT NULL AUTO_INCREMENT,
    `kode` varchar(255) NOT NULL DEFAULT '0',
    `idpk` varchar(255) NOT NULL,
    `idguru` varchar(3) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `jml_soal` int(11) NOT NULL,
    `jml_esai` int(11) NOT NULL DEFAULT 0,
    `tampil_pg` int(11) NOT NULL,
    `tampil_esai` int(11) NOT NULL DEFAULT 0,
    `bobot_pg` int(11) NOT NULL,
    `bobot_esai` int(11) NOT NULL DEFAULT 0,
    `level` varchar(5) NOT NULL,
    `opsi` int(11) NOT NULL,
    `kelas` varchar(255) NOT NULL,
    `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `status` varchar(2) NOT NULL,
    `kkm` int(11) DEFAULT NULL,
    `soal_agama` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id_mapel`)
  ) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `mata_pelajaran` (
    `kode_mapel` varchar(20) NOT NULL,
    `nama_mapel` varchar(150) NOT NULL,
    `mata_pelajaran_id` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`kode_mapel`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `materi` (
    `id_materi` int(11) NOT NULL AUTO_INCREMENT,
    `id_guru` int(11) NOT NULL DEFAULT 0,
    `kelas` text NOT NULL,
    `mapel` varchar(255) NOT NULL,
    `judul` varchar(50) NOT NULL,
    `materi` longtext DEFAULT NULL,
    `file` varchar(255) DEFAULT NULL,
    `tgl_mulai` datetime NOT NULL,
    `youtube` varchar(255) DEFAULT NULL,
    `tgl` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id_materi`)
  ) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `materi_komentar` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_materi` int(11) NOT NULL,
    `id_user` int(11) DEFAULT NULL,
    `komentar` text DEFAULT NULL,
    `level` varchar(20) DEFAULT NULL,
    `create_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `meet` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `id_guru` int(11) DEFAULT NULL,
    `id_mapel` varchar(50) DEFAULT NULL,
    `id_kelas` varchar(11) DEFAULT NULL,
    `room` varchar(100) DEFAULT NULL,
    `judul` varchar(110) DEFAULT NULL,
    `deskripsi` varchar(250) DEFAULT NULL,
    `status` tinyint(1) DEFAULT 0,
    `create_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `nilai` (
    `id_nilai` int(11) NOT NULL AUTO_INCREMENT,
    `id_ujian` int(11) NOT NULL,
    `id_mapel` int(11) NOT NULL,
    `id_siswa` int(11) NOT NULL,
    `kode_ujian` varchar(30) NOT NULL,
    `ujian_mulai` varchar(20) NOT NULL,
    `ujian_berlangsung` varchar(20) DEFAULT NULL,
    `ujian_selesai` varchar(20) DEFAULT NULL,
    `jml_benar` int(11) DEFAULT NULL,
    `jml_salah` int(11) DEFAULT NULL,
    `nilai_esai` double DEFAULT NULL,
    `skor` double DEFAULT NULL,
    `total` double DEFAULT NULL,
    `status` int(11) DEFAULT NULL,
    `ipaddress` varchar(20) DEFAULT NULL,
    `hasil` int(11) NOT NULL,
    `jawaban` text DEFAULT NULL,
    `jawaban_esai` longtext DEFAULT NULL,
    `nilai_esai2` text DEFAULT NULL,
    `online` int(11) NOT NULL DEFAULT 0,
    `id_soal` longtext DEFAULT NULL,
    `id_opsi` longtext DEFAULT NULL,
    `id_esai` text DEFAULT NULL,
    `blok` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`id_nilai`)
  ) ENGINE=InnoDB AUTO_INCREMENT=11461 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `pengawas` (
    `id_pengawas` int(11) NOT NULL AUTO_INCREMENT,
    `nip` varchar(50) DEFAULT NULL,
    `nama` varchar(50) DEFAULT NULL,
    `jabatan` varchar(50) DEFAULT NULL,
    `username` varchar(30) DEFAULT NULL,
    `password` text DEFAULT NULL,
    `level` varchar(10) DEFAULT NULL,
    `no_ktp` varchar(16) DEFAULT NULL,
    `tempat_lahir` varchar(30) DEFAULT NULL,
    `tgl_lahir` date DEFAULT NULL,
    `jenis_kelamin` varchar(10) DEFAULT NULL,
    `agama` varchar(10) DEFAULT NULL,
    `no_hp` varchar(13) DEFAULT NULL,
    `email` varchar(50) DEFAULT NULL,
    `alamat_jalan` varchar(255) DEFAULT NULL,
    `rt_rw` varchar(8) DEFAULT NULL,
    `dusun` varchar(50) DEFAULT NULL,
    `kelurahan` varchar(50) DEFAULT NULL,
    `kecamatan` varchar(30) DEFAULT NULL,
    `kode_pos` int(11) DEFAULT NULL,
    `nuptk` varchar(20) DEFAULT NULL,
    `bidang_studi` varchar(50) DEFAULT NULL,
    `jenis_ptk` varchar(50) DEFAULT NULL,
    `tgs_tambahan` varchar(50) DEFAULT NULL,
    `status_pegawai` varchar(50) DEFAULT NULL,
    `status_aktif` varchar(20) DEFAULT NULL,
    `status_nikah` varchar(20) DEFAULT NULL,
    `sumber_gaji` varchar(30) DEFAULT NULL,
    `ahli_lab` varchar(10) DEFAULT NULL,
    `nama_ibu` varchar(40) DEFAULT NULL,
    `nama_suami` varchar(50) DEFAULT NULL,
    `nik_suami` varchar(20) DEFAULT NULL,
    `pekerjaan` varchar(20) DEFAULT NULL,
    `tmt` date DEFAULT NULL,
    `keahlian_isyarat` varchar(10) DEFAULT NULL,
    `kewarganegaraan` varchar(10) DEFAULT NULL,
    `npwp` varchar(16) DEFAULT NULL,
    `foto` varchar(50) DEFAULT NULL,
    `ptk_id` varchar(50) DEFAULT NULL,
    `password2` text DEFAULT NULL,
    `ruang` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id_pengawas`)
  ) ENGINE=InnoDB AUTO_INCREMENT=329 DEFAULT CHARSET=utf8;
  
  INSERT INTO `pengawas` (`id_pengawas`, `nip`, `nama`, `jabatan`, `username`, `password`, `level`, `no_ktp`, `tempat_lahir`, `tgl_lahir`, `jenis_kelamin`, `agama`, `no_hp`, `email`, `alamat_jalan`, `rt_rw`, `dusun`, `kelurahan`, `kecamatan`, `kode_pos`, `nuptk`, `bidang_studi`, `jenis_ptk`, `tgs_tambahan`, `status_pegawai`, `status_aktif`, `status_nikah`, `sumber_gaji`, `ahli_lab`, `nama_ibu`, `nama_suami`, `nik_suami`, `pekerjaan`, `tmt`, `keahlian_isyarat`, `kewarganegaraan`, `npwp`, `foto`, `ptk_id`, `password2`, `ruang`) VALUES
  (1,	'-',	'administrator',	'',	'admin',	'$2y$10$2rTCXEfsEIbKOCKKN5dQKeiJHFh1wlUC208yUKivwJU5rvL0ELGfa',	'admin',	'',	'',	'0000-00-00',	'',	'',	'',	'',	'',	'',	'',	'',	'',	0,	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'',	'0000-00-00',	'',	'',	'',	'',	NULL,	NULL,	NULL);
  
  CREATE TABLE `pengumuman` (
    `id_pengumuman` int(11) NOT NULL AUTO_INCREMENT,
    `type` varchar(30) NOT NULL,
    `judul` varchar(255) NOT NULL,
    `user` int(11) NOT NULL,
    `text` longtext NOT NULL,
    `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    PRIMARY KEY (`id_pengumuman`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `pk` (
    `id_pk` varchar(10) NOT NULL,
    `program_keahlian` varchar(50) NOT NULL,
    `jurusan_id` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id_pk`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO `pk` (`id_pk`, `program_keahlian`, `jurusan_id`) VALUES
  ('NAUTIKA',	'NAUTIKA KAPAL NIAGA',	NULL),
  ('semua',	'semua',	NULL),
  ('TEKNIKA',	'TEKNIKA KAPAL NIAGA',	NULL);
  
  CREATE TABLE `referensi_jurusan` (
    `jurusan_id` varchar(10) NOT NULL,
    `nama_jurusan` varchar(100) DEFAULT NULL,
    `untuk_sma` int(11) NOT NULL,
    `untuk_smk` int(11) NOT NULL,
    `jenjang_pendidikan_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`jurusan_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `registrasi_siswa` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nis` varchar(30) DEFAULT NULL,
    `nama_lengkap` varchar(50) DEFAULT NULL,
    `id_kelas` varchar(11) DEFAULT NULL,
    `alamat` varchar(250) DEFAULT NULL,
    `tempat_lahir` varchar(100) DEFAULT NULL,
    `tgl_lahir` date DEFAULT NULL,
    `jenis_kelamin` varchar(30) DEFAULT NULL,
    `agama` varchar(10) DEFAULT NULL,
    `nama_ayah` varchar(150) DEFAULT NULL,
    `nama_ibu` varchar(150) DEFAULT NULL,
    `th_masuk` int(11) DEFAULT NULL,
    `no_hp` varchar(15) DEFAULT NULL,
    `username_login` varchar(50) DEFAULT NULL,
    `password_login` varchar(255) DEFAULT NULL,
    `create_at` timestamp NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`),
    UNIQUE KEY `registrasi_nis_siswa` (`nis`)
  ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `ruang` (
    `kode_ruang` varchar(10) NOT NULL,
    `keterangan` varchar(30) NOT NULL,
    PRIMARY KEY (`kode_ruang`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  INSERT INTO `ruang` (`kode_ruang`, `keterangan`) VALUES
  ('R1',	'ROOM DARING 1'),
  ('R2',	'ROOM DARING 2'),
  ('R3',	'ROOM DARING 3');
  
  CREATE TABLE `savsoft_options` (
    `oid` int(11) NOT NULL AUTO_INCREMENT,
    `qid` int(11) NOT NULL,
    `q_option` text NOT NULL,
    `q_option_match` varchar(1000) DEFAULT NULL,
    `score` float NOT NULL DEFAULT 0,
    PRIMARY KEY (`oid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `savsoft_qbank` (
    `qid` int(11) NOT NULL AUTO_INCREMENT,
    `question_type` varchar(100) NOT NULL DEFAULT 'Multiple Choice Single Answer',
    `question` text NOT NULL,
    `description` text NOT NULL,
    `cid` int(11) NOT NULL,
    `lid` int(11) NOT NULL,
    `no_time_served` int(11) NOT NULL DEFAULT 0,
    `no_time_corrected` int(11) NOT NULL DEFAULT 0,
    `no_time_incorrected` int(11) NOT NULL DEFAULT 0,
    `no_time_unattempted` int(11) NOT NULL DEFAULT 0,
    PRIMARY KEY (`qid`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `semester` (
    `semester_id` varchar(5) NOT NULL,
    `tahun_ajaran_id` varchar(4) NOT NULL,
    `nama_semester` varchar(50) NOT NULL,
    `semester` int(11) NOT NULL,
    `periode_aktif` enum('1','0') NOT NULL,
    `tanggal_mulai` date NOT NULL,
    `tanggal_selesai` date NOT NULL,
    PRIMARY KEY (`semester_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `server` (
    `kode_server` varchar(20) NOT NULL,
    `nama_server` varchar(30) NOT NULL,
    `status` varchar(15) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `sesi` (
    `kode_sesi` varchar(10) NOT NULL,
    `nama_sesi` varchar(30) NOT NULL,
    PRIMARY KEY (`kode_sesi`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `session` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `session_time` varchar(10) NOT NULL,
    `session_hash` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `setting` (
    `id_setting` int(11) NOT NULL AUTO_INCREMENT,
    `aplikasi` varchar(100) DEFAULT NULL,
    `kode_sekolah` varchar(10) DEFAULT NULL,
    `sekolah` varchar(50) DEFAULT NULL,
    `jenjang` varchar(5) DEFAULT NULL,
    `kepsek` varchar(50) DEFAULT NULL,
    `nip` varchar(30) DEFAULT NULL,
    `alamat` text DEFAULT NULL,
    `kecamatan` varchar(50) DEFAULT NULL,
    `kota` varchar(30) DEFAULT NULL,
    `telp` varchar(20) DEFAULT NULL,
    `fax` varchar(20) DEFAULT NULL,
    `web` varchar(50) DEFAULT NULL,
    `email` varchar(50) DEFAULT NULL,
    `logo` text DEFAULT NULL,
    `header` text DEFAULT NULL,
    `header_kartu` text DEFAULT NULL,
    `nama_ujian` text DEFAULT NULL,
    `versi` varchar(10) DEFAULT NULL,
    `ip_server` varchar(100) DEFAULT NULL,
    `waktu` varchar(50) DEFAULT NULL,
    `server` varchar(50) DEFAULT NULL,
    `id_server` varchar(50) DEFAULT NULL,
    `url_host` varchar(50) DEFAULT NULL,
    `token_api` varchar(50) DEFAULT NULL,
    `sekolah_id` varchar(50) DEFAULT NULL,
    `npsn` varchar(10) DEFAULT NULL,
    `db_versi` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id_setting`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `sinkron` (
    `nama_data` varchar(50) NOT NULL,
    `data` varchar(50) DEFAULT NULL,
    `jumlah` varchar(50) DEFAULT NULL,
    `tanggal` varchar(50) DEFAULT NULL,
    `status_sinkron` int(11) DEFAULT NULL,
    PRIMARY KEY (`nama_data`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `siswa` (
    `id_siswa` int(11) NOT NULL AUTO_INCREMENT,
    `id_kelas` varchar(11) DEFAULT NULL,
    `idpk` varchar(10) DEFAULT NULL,
    `nis` varchar(30) DEFAULT NULL,
    `no_peserta` varchar(30) DEFAULT NULL,
    `nama` varchar(50) DEFAULT NULL,
    `level` varchar(5) DEFAULT NULL,
    `ruang` varchar(10) DEFAULT NULL,
    `sesi` int(11) DEFAULT NULL,
    `username` varchar(50) DEFAULT NULL,
    `password` text DEFAULT NULL,
    `foto` varchar(255) DEFAULT NULL,
    `server` varchar(255) DEFAULT NULL,
    `jenis_kelamin` varchar(30) DEFAULT NULL,
    `tempat_lahir` varchar(100) DEFAULT NULL,
    `tanggal_lahir` date DEFAULT NULL,
    `agama` varchar(50) DEFAULT NULL,
    `kebutuhan_khusus` varchar(20) DEFAULT NULL,
    `alamat` text DEFAULT NULL,
    `rt` varchar(5) DEFAULT NULL,
    `rw` varchar(5) DEFAULT NULL,
    `dusun` varchar(100) DEFAULT NULL,
    `kelurahan` varchar(100) DEFAULT NULL,
    `kecamatan` varchar(100) DEFAULT NULL,
    `kode_pos` int(11) DEFAULT NULL,
    `jenis_tinggal` varchar(100) DEFAULT NULL,
    `alat_transportasi` varchar(100) DEFAULT NULL,
    `hp` varchar(15) DEFAULT NULL,
    `email` varchar(150) DEFAULT NULL,
    `skhun` int(11) DEFAULT NULL,
    `no_kps` varchar(50) DEFAULT NULL,
    `nama_ayah` varchar(150) DEFAULT NULL,
    `tahun_lahir_ayah` int(11) DEFAULT NULL,
    `pendidikan_ayah` varchar(50) DEFAULT NULL,
    `pekerjaan_ayah` varchar(100) DEFAULT NULL,
    `penghasilan_ayah` varchar(100) DEFAULT NULL,
    `nohp_ayah` varchar(15) DEFAULT NULL,
    `nama_ibu` varchar(150) DEFAULT NULL,
    `tahun_lahir_ibu` int(11) DEFAULT NULL,
    `pendidikan_ibu` varchar(50) DEFAULT NULL,
    `pekerjaan_ibu` varchar(100) DEFAULT NULL,
    `penghasilan_ibu` varchar(100) DEFAULT NULL,
    `nohp_ibu` int(11) DEFAULT NULL,
    `nama_wali` varchar(150) DEFAULT NULL,
    `tahun_lahir_wali` int(11) DEFAULT NULL,
    `pendidikan_wali` varchar(50) DEFAULT NULL,
    `pekerjaan_wali` varchar(100) DEFAULT NULL,
    `penghasilan_wali` varchar(50) DEFAULT NULL,
    `angkatan` int(11) DEFAULT NULL,
    `nisn` varchar(50) DEFAULT NULL,
    `peserta_didik_id` varchar(50) DEFAULT NULL,
    `semester_id` varchar(10) DEFAULT NULL,
    `rombongan_belajar_id` varchar(50) DEFAULT NULL,
    `status` int(11) DEFAULT 1,
    `online` int(11) DEFAULT 0,
    PRIMARY KEY (`id_siswa`)
  ) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `soal` (
    `id_soal` int(11) NOT NULL AUTO_INCREMENT,
    `id_mapel` int(11) NOT NULL,
    `nomor` int(11) DEFAULT NULL,
    `soal` longtext DEFAULT NULL,
    `jenis` int(11) DEFAULT NULL,
    `pilA` longtext DEFAULT NULL,
    `pilB` longtext DEFAULT NULL,
    `pilC` longtext DEFAULT NULL,
    `pilD` longtext DEFAULT NULL,
    `pilE` longtext DEFAULT NULL,
    `jawaban` varchar(1) DEFAULT NULL,
    `file` mediumtext DEFAULT NULL,
    `file1` mediumtext DEFAULT NULL,
    `fileA` mediumtext DEFAULT NULL,
    `fileB` mediumtext DEFAULT NULL,
    `fileC` mediumtext DEFAULT NULL,
    `fileD` mediumtext DEFAULT NULL,
    `fileE` mediumtext DEFAULT NULL,
    PRIMARY KEY (`id_soal`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2998 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `token` (
    `id_token` int(11) NOT NULL AUTO_INCREMENT,
    `token` varchar(6) NOT NULL,
    `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `masa_berlaku` time NOT NULL,
    PRIMARY KEY (`id_token`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  
  CREATE TABLE `tugas` (
    `id_tugas` int(11) NOT NULL AUTO_INCREMENT,
    `id_guru` int(11) NOT NULL DEFAULT 0,
    `kelas` text NOT NULL,
    `mapel` varchar(255) NOT NULL,
    `judul` varchar(50) NOT NULL,
    `tugas` longtext NOT NULL,
    `file` varchar(255) DEFAULT NULL,
    `tgl_mulai` datetime NOT NULL,
    `tgl_selesai` datetime NOT NULL,
    `tgl` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `status` int(11) DEFAULT NULL,
    PRIMARY KEY (`id_tugas`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
  
  
  CREATE TABLE `ujian` (
    `id_ujian` int(11) NOT NULL AUTO_INCREMENT,
    `kode_nama` varchar(255) DEFAULT '0',
    `id_pk` varchar(255) NOT NULL,
    `id_guru` int(11) NOT NULL,
    `id_mapel` int(11) NOT NULL,
    `kode_ujian` varchar(30) DEFAULT NULL,
    `nama` varchar(100) NOT NULL,
    `jml_soal` int(11) NOT NULL,
    `jml_esai` int(11) NOT NULL,
    `bobot_pg` int(11) NOT NULL,
    `opsi` int(11) NOT NULL,
    `bobot_esai` int(11) NOT NULL,
    `tampil_pg` int(11) NOT NULL,
    `tampil_esai` int(11) NOT NULL,
    `lama_ujian` int(11) NOT NULL,
    `tgl_ujian` datetime NOT NULL,
    `tgl_selesai` datetime NOT NULL,
    `waktu_ujian` time DEFAULT NULL,
    `selesai_ujian` time DEFAULT NULL,
    `level` varchar(5) NOT NULL,
    `kelas` varchar(255) NOT NULL,
    `sesi` varchar(1) DEFAULT NULL,
    `acak` int(11) NOT NULL,
    `token` int(11) NOT NULL,
    `status` int(11) DEFAULT NULL,
    `hasil` int(11) DEFAULT NULL,
    `kkm` varchar(128) DEFAULT NULL,
    `ulang` int(11) DEFAULT NULL,
    `soal_agama` varchar(50) DEFAULT NULL,
    `reset` int(11) DEFAULT NULL,
    PRIMARY KEY (`id_ujian`)
  ) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=latin1;
  
  
  -- 2020-10-21 04:46:53
  