text: 
  /*---------------------------------------------------------------
    SQL DB BACKUP 03.02.2021 16:09 
    HOST: localhost
    DATABASE: cbt
    TABLES: *
    ---------------------------------------------------------------*/
  
  /*---------------------------------------------------------------
    TABLE: `agama`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `agama`;
  CREATE TABLE `agama` (
    `agamaku` varchar(25) CHARACTER SET latin1 DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  INSERT INTO `agama` VALUES   ('Islam');
  INSERT INTO `agama` VALUES ('Kristen Katolik');
  INSERT INTO `agama` VALUES ('Kristen Protestan');
  INSERT INTO `agama` VALUES ('Hindu');
  INSERT INTO `agama` VALUES ('Budha');
  INSERT INTO `agama` VALUES ('Konghucu');
  
  /*---------------------------------------------------------------
    TABLE: `berita`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `berita`;
  CREATE TABLE `berita` (
    `id_berita` int(10) NOT NULL AUTO_INCREMENT,
    `id_mapel` int(10) 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,
    `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,
    `tgl_ujian` varchar(20) DEFAULT NULL,
    PRIMARY KEY (`id_berita`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `file_pendukung`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `file_pendukung`;
  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(1) DEFAULT NULL,
    PRIMARY KEY (`id_file`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `jawaban`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `jawaban`;
  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(1) NOT NULL,
    `esai` text,
    `nilai_esai` int(5) NOT NULL DEFAULT '0',
    `ragu` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id_jawaban`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `jawaban_tugas`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `jawaban_tugas`;
  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,
    `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(1) DEFAULT NULL,
    PRIMARY KEY (`id_jawaban`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `jenis`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `jenis`;
  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` VALUES   ('PTS','Penilaian Tengah Semester','aktif');
  INSERT INTO `jenis` VALUES ('USBK','Ujian Sekolah','tidak');
  
  /*---------------------------------------------------------------
    TABLE: `jurusan`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `jurusan`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `kelas`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `kelas`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `level`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `level`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `log`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `log`;
  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=13 DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `mapel`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `mapel`;
  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(5) NOT NULL,
    `jml_esai` int(5) NOT NULL DEFAULT '0',
    `tampil_pg` int(5) NOT NULL,
    `tampil_esai` int(5) NOT NULL DEFAULT '0',
    `bobot_pg` int(5) NOT NULL,
    `bobot_esai` int(5) NOT NULL DEFAULT '0',
    `level` varchar(5) NOT NULL,
    `opsi` int(1) 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(3) DEFAULT NULL,
    `soal_agama` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id_mapel`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `mata_pelajaran`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `mata_pelajaran`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `materi`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `materi`;
  CREATE TABLE `materi` (
    `id_materi` int(255) NOT NULL AUTO_INCREMENT,
    `id_guru` int(255) NOT NULL DEFAULT '0',
    `kelas` text NOT NULL,
    `mapel` varchar(255) NOT NULL,
    `judul` varchar(50) NOT NULL,
    `materi` longtext,
    `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 DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `materi_komentar`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `materi_komentar`;
  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,
    `level` varchar(20) DEFAULT NULL,
    `create_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `nilai`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `nilai`;
  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(10) DEFAULT NULL,
    `jml_salah` int(10) DEFAULT NULL,
    `nilai_esai` varchar(10) DEFAULT NULL,
    `skor` varchar(10) DEFAULT NULL,
    `total` varchar(10) DEFAULT NULL,
    `status` int(1) DEFAULT NULL,
    `ipaddress` varchar(20) DEFAULT NULL,
    `hasil` int(2) NOT NULL,
    `jawaban` text,
    `jawaban_esai` longtext,
    `nilai_esai2` text,
    `online` int(1) NOT NULL DEFAULT '0',
    `id_soal` longtext,
    `id_opsi` longtext,
    `id_esai` text,
    `blok` int(1) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id_nilai`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `pengawas`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `pengawas`;
  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,
    `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(6) 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,
    `ruang` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id_pengawas`)
  ) ENGINE=InnoDB AUTO_INCREMENT=320 DEFAULT CHARSET=utf8;
  INSERT INTO `pengawas` VALUES   ('1','-','administrator','','admin','$2y$10$2rTCXEfsEIbKOCKKN5dQKeiJHFh1wlUC208yUKivwJU5rvL0ELGfa','admin','','','0000-00-00','','','','','','','','','','0','','','','','','','','','','','','','','0000-00-00','','','','',NULL,NULL,NULL);
  
  /*---------------------------------------------------------------
    TABLE: `pengumuman`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `pengumuman`;
  CREATE TABLE `pengumuman` (
    `id_pengumuman` int(5) NOT NULL AUTO_INCREMENT,
    `type` varchar(30) NOT NULL,
    `judul` varchar(255) NOT NULL,
    `user` int(3) NOT NULL,
    `text` longtext NOT NULL,
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id_pengumuman`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `pk`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `pk`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `referensi_jurusan`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `referensi_jurusan`;
  CREATE TABLE `referensi_jurusan` (
    `jurusan_id` varchar(10) NOT NULL,
    `nama_jurusan` varchar(100) DEFAULT NULL,
    `untuk_sma` int(1) NOT NULL,
    `untuk_smk` int(1) NOT NULL,
    `jenjang_pendidikan_id` int(1) DEFAULT NULL,
    PRIMARY KEY (`jurusan_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `registrasi_siswa`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `registrasi_siswa`;
  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(5) 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 DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `ruang`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `ruang`;
  CREATE TABLE `ruang` (
    `kode_ruang` varchar(10) NOT NULL,
    `keterangan` varchar(30) NOT NULL,
    PRIMARY KEY (`kode_ruang`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `savsoft_options`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `savsoft_options`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `savsoft_qbank`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `savsoft_qbank`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `semester`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `semester`;
  CREATE TABLE `semester` (
    `semester_id` varchar(5) NOT NULL,
    `tahun_ajaran_id` varchar(4) NOT NULL,
    `nama_semester` varchar(50) NOT NULL,
    `semester` int(1) 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;
  
  /*---------------------------------------------------------------
    TABLE: `server`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `server`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `sesi`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `sesi`;
  CREATE TABLE `sesi` (
    `kode_sesi` varchar(10) NOT NULL,
    `nama_sesi` varchar(30) NOT NULL,
    PRIMARY KEY (`kode_sesi`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  INSERT INTO `sesi` VALUES   ('1','Sesi Pagi');
  INSERT INTO `sesi` VALUES ('2','Sesi Siang');
  INSERT INTO `sesi` VALUES ('3','Sesi Sore');
  
  /*---------------------------------------------------------------
    TABLE: `session`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `session`;
  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;
  
  /*---------------------------------------------------------------
    TABLE: `setting`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `setting`;
  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,
    `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,
    `header` text,
    `header_kartu` text,
    `nama_ujian` text,
    `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;
  INSERT INTO `setting` VALUES   ('1','E-LEARNING SPM','-','SMK SPM NASIONAL PURWOKERTO','SMK','Dian Mukti Wibowo','-','Jalan Kyai Haji Wachid Hasyim No. 93, Karangklesem, Purwokerto Selatan','Purwokerto','Banyumas','0281 631 952','-','www.spmnasionalpwt.sch.id','spmnasionalpwt@gmail.com','dist/img/logo87.png','','KARTU PESERTA','Penilaian Tengah Semester','2.5','http://192.168.0.200/candycbt','Asia/Jakarta','lokal','SR01','xxxxxx','fqyhJuxulHCA90','8cce47df-aae7-4274-83cb-5af3093eab56','69787351','2.8.1');
  
  /*---------------------------------------------------------------
    TABLE: `sinkron`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `sinkron`;
  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;
  INSERT INTO `sinkron` VALUES   ('DATA1','siswa','','','0');
  INSERT INTO `sinkron` VALUES ('DATA2','bank soal','','','0');
  INSERT INTO `sinkron` VALUES ('DATA3','soal','','','0');
  INSERT INTO `sinkron` VALUES ('DATA4','jadwal','','','0');
  
  /*---------------------------------------------------------------
    TABLE: `siswa`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `siswa`;
  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(2) DEFAULT NULL,
    `username` varchar(50) DEFAULT NULL,
    `password` text,
    `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(10) DEFAULT NULL,
    `kebutuhan_khusus` varchar(20) DEFAULT NULL,
    `alamat` text,
    `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(10) 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(4) 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(4) DEFAULT NULL,
    `pendidikan_ibu` varchar(50) DEFAULT NULL,
    `pekerjaan_ibu` varchar(100) DEFAULT NULL,
    `penghasilan_ibu` varchar(100) DEFAULT NULL,
    `nohp_ibu` int(15) DEFAULT NULL,
    `nama_wali` varchar(150) DEFAULT NULL,
    `tahun_lahir_wali` int(4) DEFAULT NULL,
    `pendidikan_wali` varchar(50) DEFAULT NULL,
    `pekerjaan_wali` varchar(100) DEFAULT NULL,
    `penghasilan_wali` varchar(50) DEFAULT NULL,
    `angkatan` int(5) 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(1) DEFAULT '1',
    `online` int(1) DEFAULT '0',
    PRIMARY KEY (`id_siswa`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  /*---------------------------------------------------------------
    TABLE: `soal`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `soal`;
  CREATE TABLE `soal` (
    `id_soal` int(11) NOT NULL AUTO_INCREMENT,
    `id_mapel` int(11) NOT NULL,
    `nomor` int(5) DEFAULT NULL,
    `soal` longtext,
    `jenis` int(1) DEFAULT NULL,
    `pilA` longtext,
    `pilB` longtext,
    `pilC` longtext,
    `pilD` longtext,
    `pilE` longtext,
    `jawaban` varchar(1) DEFAULT NULL,
    `file` mediumtext,
    `file1` mediumtext,
    `fileA` mediumtext,
    `fileB` mediumtext,
    `fileC` mediumtext,
    `fileD` mediumtext,
    `fileE` mediumtext,
    PRIMARY KEY (`id_soal`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `token`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `token`;
  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=2 DEFAULT CHARSET=latin1;
  INSERT INTO `token` VALUES   ('1','ZAZJVV','2020-09-11 14:22:13','00:15:00');
  
  /*---------------------------------------------------------------
    TABLE: `tugas`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `tugas`;
  CREATE TABLE `tugas` (
    `id_tugas` int(255) NOT NULL AUTO_INCREMENT,
    `id_guru` int(255) 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 DEFAULT CHARSET=utf8;
  
  /*---------------------------------------------------------------
    TABLE: `ujian`
    ---------------------------------------------------------------*/
  DROP TABLE IF EXISTS `ujian`;
  CREATE TABLE `ujian` (
    `id_ujian` int(5) NOT NULL AUTO_INCREMENT,
    `kode_nama` varchar(255) DEFAULT '0',
    `id_pk` varchar(255) NOT NULL,
    `id_guru` int(5) NOT NULL,
    `id_mapel` int(5) NOT NULL,
    `kode_ujian` varchar(30) DEFAULT NULL,
    `nama` varchar(100) NOT NULL,
    `jml_soal` int(5) NOT NULL,
    `jml_esai` int(5) NOT NULL,
    `bobot_pg` int(5) NOT NULL,
    `opsi` int(1) NOT NULL,
    `bobot_esai` int(5) NOT NULL,
    `tampil_pg` int(5) NOT NULL,
    `tampil_esai` int(5) NOT NULL,
    `lama_ujian` int(5) 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(1) NOT NULL,
    `token` int(1) NOT NULL,
    `status` int(1) DEFAULT NULL,
    `hasil` int(1) DEFAULT NULL,
    `kkm` varchar(128) DEFAULT NULL,
    `ulang` int(2) DEFAULT NULL,
    `soal_agama` varchar(50) DEFAULT NULL,
    `reset` int(1) DEFAULT NULL,
    PRIMARY KEY (`id_ujian`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  