-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Sep 30, 2024 at 09:00 AM
-- Server version: 10.3.39-MariaDB-cll-lve
-- PHP Version: 8.1.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `prab7681_ujian`
--

-- --------------------------------------------------------

--
-- Table structure for table `kelas`
--

CREATE TABLE `kelas` (
  `id_kelas` int(5) NOT NULL,
  `kelas` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kelas`
--

INSERT INTO `kelas` (`id_kelas`, `kelas`) VALUES
(2, 'XI RPL SESI 1'),
(25, 'X RPL SESI 1'),
(26, 'X RPL SESI 2'),
(1, 'X RPL SESI 3'),
(21, 'XI RPL SESI 2'),
(19, 'XI RPL SESI 3'),
(27, 'XII RPL SESI 1'),
(28, 'XII RPL SESI 2'),
(29, 'XII RPL SESI 3');

-- --------------------------------------------------------

--
-- Table structure for table `kelas_ujian`
--

CREATE TABLE `kelas_ujian` (
  `id_ujian` int(5) NOT NULL,
  `id_kelas` int(5) NOT NULL,
  `aktif` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `kelas_ujian`
--

INSERT INTO `kelas_ujian` (`id_ujian`, `id_kelas`, `aktif`) VALUES
(11, 13, 'N'),
(14, 13, 'N'),
(9, 13, 'N'),
(10, 13, 'N'),
(15, 13, 'N'),
(13, 13, 'Y'),
(12, 13, 'N'),
(27, 25, 'Y'),
(22, 2, 'N'),
(22, 21, 'N'),
(22, 19, 'Y'),
(34, 2, 'N'),
(33, 25, 'N'),
(49, 27, 'Y'),
(44, 27, 'Y'),
(23, 27, 'Y'),
(39, 27, 'Y'),
(63, 27, 'N'),
(64, 27, 'Y'),
(24, 25, 'N'),
(62, 2, 'N'),
(62, 21, 'N'),
(62, 19, 'Y'),
(36, 19, 'Y'),
(43, 2, 'N'),
(16, 2, 'N'),
(16, 21, 'N'),
(16, 19, 'Y'),
(28, 2, 'N'),
(28, 21, 'N'),
(28, 19, 'Y'),
(57, 2, 'N'),
(57, 21, 'Y'),
(57, 19, 'N'),
(41, 2, 'N'),
(41, 21, 'Y'),
(41, 19, 'N'),
(17, 2, 'N'),
(17, 21, 'Y'),
(17, 19, 'N'),
(52, 2, 'N'),
(52, 21, 'Y'),
(52, 19, 'N'),
(48, 2, 'N'),
(48, 21, 'Y'),
(48, 19, 'N'),
(46, 2, 'N'),
(46, 21, 'N'),
(46, 19, 'Y'),
(59, 2, 'N'),
(59, 21, 'N'),
(59, 19, 'Y'),
(34, 21, 'N'),
(34, 19, 'Y'),
(60, 27, 'Y'),
(65, 27, 'Y'),
(38, 27, 'Y'),
(29, 27, 'Y'),
(45, 25, 'N'),
(45, 26, 'Y'),
(45, 1, 'N'),
(21, 25, 'N'),
(21, 26, 'Y'),
(21, 1, 'N'),
(26, 25, 'N'),
(26, 26, 'Y'),
(26, 1, 'N'),
(33, 26, 'Y'),
(33, 1, 'N'),
(43, 21, 'Y'),
(43, 19, 'N');

-- --------------------------------------------------------

--
-- Table structure for table `nilai`
--

CREATE TABLE `nilai` (
  `id_nilai` int(10) NOT NULL,
  `nis` varchar(20) NOT NULL,
  `id_ujian` int(5) NOT NULL,
  `acak_soal` text NOT NULL,
  `jawaban` text NOT NULL,
  `sisa_waktu` varchar(10) NOT NULL,
  `jml_benar` int(5) NOT NULL,
  `nilai` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `siswa`
--

CREATE TABLE `siswa` (
  `nis` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `password` varchar(50) NOT NULL,
  `id_kelas` int(5) NOT NULL,
  `status` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `soal`
--

CREATE TABLE `soal` (
  `id_soal` int(5) NOT NULL,
  `id_ujian` int(5) NOT NULL,
  `soal` text NOT NULL,
  `audio` varchar(100) NOT NULL,
  `pilihan_1` text NOT NULL,
  `pilihan_2` text NOT NULL,
  `pilihan_3` text NOT NULL,
  `pilihan_4` text NOT NULL,
  `pilihan_5` text NOT NULL,
  `kunci` int(2) NOT NULL,
  `urut` int(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ujian`
--

CREATE TABLE `ujian` (
  `id_ujian` int(5) NOT NULL,
  `judul` varchar(50) NOT NULL,
  `nama_mapel` varchar(50) NOT NULL,
  `tanggal` date NOT NULL,
  `waktu` int(5) NOT NULL,
  `jml_soal` int(3) NOT NULL,
  `id_user` int(5) NOT NULL,
  `acak_soal` enum('Y','N') NOT NULL,
  `acak_jawaban` enum('Y','N') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `ujian`
--

INSERT INTO `ujian` (`id_ujian`, `judul`, `nama_mapel`, `tanggal`, `waktu`, `jml_soal`, `id_user`, `acak_soal`, `acak_jawaban`) VALUES
(17, 'Pemrograman Web & Mobile Xl', 'Pemrograman Web & Mobile Xl', '2024-06-14', 60, 50, 2, 'Y', 'Y'),
(16, 'Basis Data Xl', 'Basis Data XI', '2024-03-22', 60, 30, 2, 'Y', 'Y'),
(18, 'Pendidikan Kewarganegaraan X', 'Pendidikan Kewarganegaraan X', '2023-09-27', 60, 60, 19, 'Y', 'Y'),
(19, 'Penddidikan Jasmani X', 'Penddidikan Jasmani X', '2023-10-06', 60, 30, 17, 'Y', 'Y'),
(20, 'Pendidikan Jasmani XI', 'Pendidikan Jasmani XI', '2023-10-06', 60, 30, 17, 'Y', 'Y'),
(21, 'Sejarah Indonesia X', 'Sejarah Indonesia X', '2024-03-27', 60, 30, 17, 'Y', 'Y'),
(22, 'Pendidikan Kewarganegaraan XI', 'Pendidikan Kewarganegaraan XI', '2024-03-19', 60, 30, 19, 'Y', 'Y'),
(23, 'Pendidikan Kewarganegaraan XII', 'Pendidikan Kewarganegaraan XII', '2024-03-02', 60, 50, 19, 'Y', 'Y'),
(24, 'Projek IPA X', 'Projek IPA X', '2023-10-06', 60, 30, 20, 'Y', 'Y'),
(25, 'Projek IPS X', 'Projek IPS X', '2023-10-06', 60, 30, 20, 'Y', 'Y'),
(26, 'Bahasa Inggris X', 'Bahasa Inggris X', '2024-03-27', 60, 30, 33, 'Y', 'Y'),
(27, 'Matematika X', 'Matematika X', '2023-10-12', 60, 30, 18, 'Y', 'Y'),
(28, 'Matematika XI', 'Matematika XI', '2024-03-22', 60, 25, 18, 'Y', 'Y'),
(29, 'Matematika XII', 'Matematika XII', '2024-03-27', 60, 40, 18, 'Y', 'Y'),
(30, 'Proses Bisnis X', 'Proses Bisnis X', '2023-10-06', 60, 30, 2, 'Y', 'Y'),
(31, 'Basis Data XII', 'Basis Data XII', '2023-10-06', 60, 30, 2, 'Y', 'Y'),
(32, 'Pemrograman Web & Mobile XlI', 'Pemrogramn Web & Mobile XII', '2023-10-06', 60, 30, 2, 'Y', 'Y'),
(33, 'Dasar Pengembangan PL & GIM X', 'Dasar Pengembangan PL & GIM X', '2024-03-27', 60, 20, 15, 'Y', 'Y'),
(34, 'Pemodelan Perangkat Lunak XI', 'Pemodelan Perangkat Lunak XI', '2024-03-27', 60, 30, 15, 'Y', 'Y'),
(35, 'Bahasa Indonesia X', 'Bahasa Indonesia X', '2023-10-06', 60, 30, 22, 'Y', 'Y'),
(36, 'Bahasa Indonesia XI', 'Bahasa Indonesia XI', '2024-03-20', 60, 30, 22, 'Y', 'Y'),
(37, 'Bahasa Indonesia XII', 'Bahasa Indonesia XII', '2023-10-06', 60, 30, 22, 'Y', 'Y'),
(38, 'Produk Kreatif Kewirausahaan XII', 'Produk Kreatif Kewirausahaan  XII', '2024-03-27', 60, 50, 22, 'Y', 'Y'),
(39, 'Pendidikan Agama Islam XII', 'Pendidikan Agama Islam XII', '2024-03-02', 60, 50, 23, 'Y', 'Y'),
(40, 'Perkembangan PL & GIM X', 'Perkembangan PL & GIM X', '2023-10-06', 60, 30, 24, 'Y', 'Y'),
(41, 'Produk Kreatif Kewirausahaan XI', 'Produk Kreatif Kewirausahaan  XI', '2024-06-14', 60, 50, 24, 'Y', 'Y'),
(42, 'Bahasa Daerah X', 'Bahasa Daerah X', '2023-10-06', 60, 30, 24, 'Y', 'Y'),
(44, 'Bahasa Daerah XII', 'Bahasa Daerah XII', '2024-03-01', 60, 50, 24, 'Y', 'Y'),
(45, 'Seni Budaya X', 'Seni Budaya X', '2024-03-27', 60, 30, 25, 'Y', 'Y'),
(46, 'Jawahirul Kalamiyah XI', 'Jawahirul Kalamiyah XI', '2024-03-26', 60, 30, 26, 'Y', 'Y'),
(47, 'Jawahirul Kalamiyah XII', 'Jawahirul Kalamiyah XII', '2023-10-06', 60, 30, 26, 'Y', 'Y'),
(48, 'Adabul Alim XI', 'Adabul Alim XI', '2024-06-14', 60, 50, 27, 'Y', 'Y'),
(49, 'Adabul Alim XII', 'Adabul Alim XII', '2024-03-01', 60, 50, 27, 'Y', 'Y'),
(50, 'Pendidikan Agama Islam X', 'Pendidikan Agama Islam X', '2023-10-06', 60, 30, 34, 'Y', 'Y'),
(51, 'Pendidikan Agama Islam XI', 'Pendidikan Agama Islam XI', '2023-10-06', 60, 30, 28, 'Y', 'Y'),
(52, 'Safinatun Najah XI', 'Safinatun Najah XI', '2024-06-14', 60, 50, 28, 'Y', 'Y'),
(53, 'Safinatun Najah XII', 'Safinatun Najah XII', '2023-10-06', 60, 30, 28, 'Y', 'Y'),
(54, 'Informatika X', 'Informatika X', '2023-10-06', 60, 30, 35, 'Y', 'Y'),
(55, 'Pemrograman Terstruktur X', 'Pemrograman Terstruktur X', '2023-09-06', 60, 30, 29, 'Y', 'Y'),
(56, 'Dasar Desain Grafis X', 'Dasar Desain Grafis X', '2023-09-06', 60, 30, 29, 'Y', 'Y'),
(57, 'Pemrograman Berorientasi Objek XI', 'Pemrograman Berorientasi Objek XI', '2024-06-14', 60, 50, 29, 'Y', 'Y'),
(58, 'Pemrograman Berorientasi Objek XII', 'Pemrograman Berorientasi Objek XII', '2023-09-06', 60, 30, 29, 'Y', 'Y'),
(59, 'Bahasa Inggris XI', 'Bahasa Inggris XI', '2024-03-27', 60, 30, 21, 'Y', 'Y'),
(60, 'Bahasa Inggris XII', 'Bahasa Inggris XII', '2024-03-27', 60, 50, 21, 'Y', 'Y'),
(43, 'Bahasa Daerah XI', 'Bahasa Daerah XI', '2024-06-14', 60, 50, 24, 'Y', 'Y'),
(62, 'Desain Grafis XI', 'Desain Grafis XI', '2024-03-19', 60, 30, 29, 'Y', 'Y'),
(63, 'LISTENING BAHASA INGGRIS XII', 'LISTENING BAHASA INGGRIS XII', '2024-03-25', 30, 15, 21, 'N', 'N'),
(64, 'USP Fisika XII', 'USP Fisika XII', '2024-03-27', 60, 50, 20, 'Y', 'Y'),
(65, 'Simulasi dan Komunikasi Digital XII', 'Simulasi dan Komunikasi Digital XII', '2024-03-27', 60, 50, 35, 'Y', 'Y'),
(66, 'USP Kimia XII ', 'USP Kimia XII ', '2024-03-30', 60, 50, 20, 'Y', 'Y'),
(67, 'USP Seni Budaya XII', 'USP Seni Budaya XII ', '2024-03-18', 60, 50, 25, 'Y', 'Y'),
(68, 'USP Sejarah Indonesia XII ', 'USP Sejarah Indonesia XII ', '2024-03-19', 60, 50, 17, 'Y', 'Y'),
(69, 'USP Pendidikan Jasmani XII ', 'USP Pendidikan Jasmani XII ', '2024-03-20', 60, 50, 17, 'Y', 'Y'),
(70, 'Kompetisi Kejujuran XII ', 'Kompetisi Kejujuran XII ', '2024-03-24', 60, 50, 2, 'Y', 'Y'),
(71, 'Dasar Program Keahlian XII ', 'Dasar Program Keahlian XII ', '2024-03-26', 60, 50, 2, 'Y', 'Y'),
(72, 'Sejaran Indonesia XI', 'Sejarah Indonesia XI', '2024-09-02', 60, 30, 20, 'Y', 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id_user` int(5) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(50) DEFAULT NULL,
  `level` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id_user`, `nama`, `username`, `password`, `level`) VALUES
(2, 'M. Subhan, S. Kom', 'subhan', '0457a19952c514497df1bd9e5af8c6ae', 'guru'),
(1, 'Administrator', 'admin', '87071fab966fd3a492dc3783487c4024', 'admin'),
(16, 'Rudi Khoirudin', 'rudi', '4b583376b2767b923c3e1da60d10de59', 'operator'),
(15, 'Rudi Khoirudin', 'rudi', '5c806bc4d0b60480470e77b3273e9e79', 'guru'),
(17, 'Abdullah Adhar SS, S. Pd', 'adhar', '5106a7fdbc55798332cdadf5a97879fd', 'guru'),
(18, 'Abdul Rouf Habibi, S. Pd', 'rouf', 'ae9cb30a83d8bdba35430df4aa6b13c7', 'guru'),
(19, 'Hj. Siti Marlilik, S. Pd', 'lilik', '08ec93b888edec52208236bb71ca1f79', 'guru'),
(20, 'Ita Purnawati, S. Pd', 'ita', '4bf93a19380b161d35dc4d570bd91795', 'guru'),
(21, 'Lailatul Fitriah, S. Pd', 'fitri', '13a08bc67d814cc8c4eb246ff60c4784', 'guru'),
(22, 'Yeni Nurrohmah, S.E, M.Pd', 'yeni', 'bdb75c4c3de06fc1b78c133d4c730e2f', 'guru'),
(23, 'Tri Yulianto Eko Saputro, SHI, M.PdI', 'eko', '8729ad13c5b452ec1ca62e5710d064d0', 'guru'),
(24, 'Mia Puspa Wahyuningtyas', 'mia', '13b5b944ba620c8977d81bf40afd46e4', 'guru'),
(25, 'Faridatul Indriyani, S. Pd', 'farid', 'acc0b7857abb226eaf7a347c477033ce', 'guru'),
(26, 'Abdul Ghofur, S. Pd', 'ghofur', '9e37c4c73b2adc656549037ac798315e', 'guru'),
(27, 'M. Muhsin, S. Pd', 'muhsin', '3ea99ccdbff732d0db63fe41ac572585', 'guru'),
(28, 'Ahmadi, S. Pd', 'ahmadi', '36245cf8af836e56607212e2ad8b6301', 'guru'),
(29, 'M. Alfan Hadi Prayogo', 'alfan', 'e7976e02c6e36b63038de1683db7236a', 'guru'),
(30, 'M. Alfan Hadi Prayogo', 'alfan', '4b583376b2767b923c3e1da60d10de59', 'operator'),
(31, 'Pengawas Ruang', 'pengawas', '4b583376b2767b923c3e1da60d10de59', 'operator'),
(34, 'Imam Sukardi, S.pd', 'sukardi', '8db6e5a89099097890e407dd9a0e1d9c', 'guru'),
(33, 'Laili Mahbubah, S.Pd', 'bubah', 'bd2e9382dd7d8ed4342aa2e3ccb6bde1', 'guru'),
(35, 'Fenti Andriana, S.Pd', 'fenti', 'db8816e188183a4de625346529c62ff4', 'guru');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `kelas`
--
ALTER TABLE `kelas`
  ADD PRIMARY KEY (`id_kelas`);

--
-- Indexes for table `nilai`
--
ALTER TABLE `nilai`
  ADD PRIMARY KEY (`id_nilai`);

--
-- Indexes for table `siswa`
--
ALTER TABLE `siswa`
  ADD PRIMARY KEY (`nis`);

--
-- Indexes for table `soal`
--
ALTER TABLE `soal`
  ADD PRIMARY KEY (`id_soal`);

--
-- Indexes for table `ujian`
--
ALTER TABLE `ujian`
  ADD PRIMARY KEY (`id_ujian`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `kelas`
--
ALTER TABLE `kelas`
  MODIFY `id_kelas` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `nilai`
--
ALTER TABLE `nilai`
  MODIFY `id_nilai` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=324;

--
-- AUTO_INCREMENT for table `soal`
--
ALTER TABLE `soal`
  MODIFY `id_soal` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=549945;

--
-- AUTO_INCREMENT for table `ujian`
--
ALTER TABLE `ujian`
  MODIFY `id_ujian` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;
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 */;
