-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 03, 2022 at 01:53 PM
-- Server version: 5.7.24
-- PHP Version: 7.4.15

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: `simakadebs`
--

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

--
-- Table structure for table `absensi_guru`
--

create database simakadebs;
use simakadebs;

CREATE TABLE `absensi_guru` (
  `id_absensi` int(11) NOT NULL,
  `checkin` datetime DEFAULT NULL,
  `checkout` datetime DEFAULT NULL,
  `nip` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `absensi_siswa`
--

CREATE TABLE `absensi_siswa` (
  `id_absensi_siswa` int(11) NOT NULL,
  `checkin` datetime DEFAULT NULL,
  `nis` varchar(25) DEFAULT NULL,
  `mata_pelajaran_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `guru`
--

CREATE TABLE `guru` (
  `id_guru` int(11) NOT NULL,
  `nip` varchar(25) DEFAULT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `tempat_lahir` varchar(50) DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `pendidikan_terakhir` varchar(100) DEFAULT NULL,
  `jabatan` varchar(50) DEFAULT NULL,
  `mulai_bertugas` date DEFAULT NULL,
  `alamat` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guru`
--

INSERT INTO `guru` (`id_guru`, `nip`, `nama`, `tempat_lahir`, `tanggal_lahir`, `pendidikan_terakhir`, `jabatan`, `mulai_bertugas`, `alamat`) VALUES
(3, '8138747650200010', 'MOH. ALI ISMAIL MUSTOFA, S.Pd.', 'GRESIK', '1969-08-06', 'S1 STKIP BIM SURABAYA', 'KEPALA MADRASAH', '1995-07-16', 'SOOKO'),
(4, '6541743637200000', 'SUTEMIN, S.Pd.I', 'JOMBANG', '1965-02-09', 'S1 IAIN SUNAN AMPEL SURABAYA', 'GURU', '1986-09-02', 'GUPLONG'),
(5, '1439750656200000', 'A. MANSUR WAKID, S.Ag', 'GRESIK', '1972-01-07', 'S1 IAI TRI BHAKTI KEDIRI', 'GURU', '2002-07-17', 'SOOKO'),
(6, '4449754656300010', 'SITI ROHMATUN, S.Pd.I', 'GRESIK', '1976-11-17', 'S1 UNISLA LAMONGAN', 'GURU', '1996-12-11', 'SOOKO'),
(7, '9455761662300000', 'TITIK YOGI ARIYANTI, S.Pd.', 'GRESIK', '1983-01-23', 'S1 STKIP BIM SURABAYA', 'GURU', '2005-01-01', 'KESAMBEN KULON'),
(8, '5745762664300000', 'DURROTUN NASHUHA, S.Pd.', 'GRESIK', '1984-02-18', 'S1 STKIP BIM SURABAYA', 'GURU', '2004-07-16', 'SOOKO'),
(9, '5745762664110050', 'AHMAD BURHAN JAZULI, S.Pd.', 'GRESIK', '1984-04-13', 'S1 STAI AR-ROSYID SURABAYA', 'GURU', '2010-07-13', 'SOOKO'),
(10, '20500820189001', 'KHOIRUN NADZIROH, S.Pd.', 'GRESIK', '1989-08-07', 'S1 STAI AL-AZHAR MENGANTI GRESIK', 'GURU + OPS', '2012-12-03', 'SOOKO'),
(11, '20500820194001', 'NURUL ISNAINI FITRIYAH, S.Pd.', 'GRESIK', '1994-05-02', 'S1 UNSURI SURABYA', 'GURU', '2017-07-17', 'SOOKO'),
(12, '20591905187001', 'MOH. IKHSAN, S.Pd.', 'GRESIK', '1987-06-15', 'S1 IKIP BUDI UTOMO MALANG', 'GURU', '2017-07-17', 'SEMBUNG'),
(13, '20500820193001', 'HENNY ARING TIYAS, S.Pd.', 'GRESIK', '1993-08-14', 'S1 INKAFA GRESIK', 'GURU', '2017-07-17', 'SOOKO'),
(14, '20500820193002', 'IRIL AMALIA, S.Pd.', 'GRESIK', '1993-08-10', 'S1 UNIVERSITAS ADI BUANA SURABAYA', 'GURU', '2018-07-16', 'PEDAGANGAN'),
(15, '20500820196002', 'MUHAMMAD SYAFI\' AMRULLOH', 'GRESIK', '1996-03-16', 'S1 INKAFA GRESIK', 'GURU', '2020-07-13', 'SOOKO'),
(16, '20500820197001', 'LAILATUL ISTIQOMAH', 'GRESIK', '1997-06-21', 'S1 UNSURI SURABYA', 'GURU + BENDAHARA', '2020-07-13', 'SOOKO'),
(17, '20532004193001', 'MUH. KHOIRUL ANAM, S.Pd.', 'GRESIK', '1993-05-15', 'S1 STAI AR-ROSYID SURABAYA', 'GURU', '2020-07-13', 'SOOKO'),
(18, '20500820192001', 'INDATUL IMAROH, S.Pd.I', 'GRESIK', '1992-01-28', 'S1 STAI AR-ROSYID SURABAYA', 'TU', '2014-07-14', 'SOOKO'),
(19, '007', 'Testing', 'Surabaya', '2022-01-03', 'S1 Informatika ITATS', 'Guru', '2022-01-03', 'Lorem Ipsum'),
(20, '123', 'Guru 1', 'Surabaya', '2021-08-23', 'UPN', 'Guru', '2021-08-23', 'Sooko'),
(21, '1234', 'Guru 2', 'Gresik', '2021-08-23', 'UPN', 'Guru', '2021-08-23', 'Sooko');

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

--
-- Table structure for table `hak_akses`
--

CREATE TABLE `hak_akses` (
  `id_hak_akses` int(11) NOT NULL,
  `nama` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hak_akses`
--

INSERT INTO `hak_akses` (`id_hak_akses`, `nama`) VALUES
(1, 'Kepala Sekolah'),
(2, 'Guru'),
(3, 'Siswa'),
(4, 'Admin');

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

--
-- Table structure for table `hak_akses_users`
--

CREATE TABLE `hak_akses_users` (
  `id_hak_akses_users` int(11) NOT NULL,
  `hak_akses_id` int(11) DEFAULT NULL,
  `users_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hak_akses_users`
--

INSERT INTO `hak_akses_users` (`id_hak_akses_users`, `hak_akses_id`, `users_id`) VALUES
(1, 4, 1),
(5, 3, 5),
(6, 3, 6),
(7, 3, 7),
(8, 3, 8),
(9, 3, 9),
(10, 3, 10),
(11, 3, 11),
(12, 3, 12),
(13, 3, 13),
(14, 3, 14),
(15, 3, 15),
(16, 3, 16),
(17, 3, 17),
(18, 3, 18),
(19, 3, 19),
(20, 3, 20),
(21, 3, 21),
(22, 3, 22),
(23, 3, 23),
(24, 3, 24),
(25, 3, 25),
(26, 3, 26),
(27, 3, 27),
(28, 3, 28),
(29, 3, 29),
(30, 3, 30),
(31, 3, 31),
(32, 3, 32),
(33, 3, 33),
(34, 3, 34),
(35, 3, 35),
(36, 3, 36),
(37, 3, 37),
(38, 3, 38),
(39, 3, 39),
(40, 3, 40),
(41, 3, 41),
(42, 3, 42),
(43, 3, 43),
(44, 3, 44),
(45, 3, 45),
(46, 3, 46),
(47, 3, 47),
(48, 3, 48),
(49, 3, 49),
(50, 3, 50),
(51, 3, 51),
(52, 3, 52),
(53, 1, 53),
(54, 2, 54),
(55, 2, 55),
(56, 2, 56),
(57, 2, 57),
(58, 2, 58),
(59, 2, 59),
(60, 2, 60),
(61, 2, 61),
(62, 2, 62),
(63, 2, 63),
(64, 2, 64),
(65, 2, 65),
(66, 2, 66),
(67, 2, 67),
(68, 2, 68),
(69, 2, 69),
(70, 3, 70),
(71, 2, 71),
(72, 2, 72),
(73, 3, 73),
(74, 3, 74),
(75, 4, 75);

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

--
-- Table structure for table `jadwal_mata_pelajaran`
--

CREATE TABLE `jadwal_mata_pelajaran` (
  `id_jadwal_mata_pelajaran` int(11) NOT NULL,
  `mata_pelajaran_id` int(11) DEFAULT NULL,
  `kelas_siswa_id` int(11) DEFAULT NULL,
  `hari` int(11) DEFAULT NULL,
  `jam_mulai` time DEFAULT NULL,
  `jam_selesai` time DEFAULT NULL,
  `guru_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jadwal_mata_pelajaran`
--

INSERT INTO `jadwal_mata_pelajaran` (`id_jadwal_mata_pelajaran`, `mata_pelajaran_id`, `kelas_siswa_id`, `hari`, `jam_mulai`, `jam_selesai`, `guru_id`) VALUES
(1, 5, 4, 1, '07:00:00', '08:00:00', 3),
(2, 4, 4, 1, '08:01:00', '09:00:00', 7);

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

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

CREATE TABLE `kelas` (
  `id_kelas` int(11) NOT NULL,
  `nomer` int(11) DEFAULT NULL,
  `huruf` varchar(5) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `kelas` (`id_kelas`, `nomer`, `huruf`) VALUES
(1, 1, 'A'),
(3, 1, 'B'),
(4, 2, 'A'),
(5, 2, 'B');

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

--
-- Table structure for table `kelas_siswa`
--

CREATE TABLE `kelas_siswa` (
  `id_kelas_siswa` int(11) NOT NULL,
  `kelas_id` int(11) DEFAULT NULL,
  `guru_id` int(11) DEFAULT NULL,
  `periode_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kelas_siswa`
--

INSERT INTO `kelas_siswa` (`id_kelas_siswa`, `kelas_id`, `guru_id`, `periode_id`) VALUES
(4, 1, 3, 3),
(5, 1, 8, 2);

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

--
-- Table structure for table `kelas_siswa_detail`
--

CREATE TABLE `kelas_siswa_detail` (
  `id_kelas_siswa_detail` int(11) NOT NULL,
  `kelas_siswa_id` int(11) DEFAULT NULL,
  `siswa_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kelas_siswa_detail`
--

INSERT INTO `kelas_siswa_detail` (`id_kelas_siswa_detail`, `kelas_siswa_id`, `siswa_id`) VALUES
(24, 4, 104),
(25, 4, 103),
(26, 4, 102),
(27, 4, 101),
(28, 4, 100),
(29, 4, 99);

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

--
-- Table structure for table `kriteria_penilaian`
--

CREATE TABLE `kriteria_penilaian` (
  `id_kriteria_penilaian` int(11) NOT NULL,
  `kriteria` varchar(100) DEFAULT NULL,
  `bobot` float DEFAULT NULL,
  `tipe` set('max','min') DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kriteria_penilaian`
--

INSERT INTO `kriteria_penilaian` (`id_kriteria_penilaian`, `kriteria`, `bobot`, `tipe`) VALUES
(1, 'Nilai', 100, 'max');

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

--
-- Table structure for table `mata_pelajaran`
--

CREATE TABLE `mata_pelajaran` (
  `id_mata_pelajaran` int(11) NOT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `deskripsi` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mata_pelajaran`
--

INSERT INTO `mata_pelajaran` (`id_mata_pelajaran`, `nama`, `deskripsi`) VALUES
(1, 'Bahasa Indonesia', ''),
(3, 'IPA', ''),
(4, 'Matematika', ''),
(5, 'Olahraga', '-');

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

--
-- Table structure for table `nilai_siswa`
--

CREATE TABLE `nilai_siswa` (
  `id_nilai_siswa` int(11) NOT NULL,
  `kelas_siswa_id` int(11) DEFAULT NULL,
  `judul` varchar(100) DEFAULT NULL,
  `nilai` int(11) DEFAULT NULL,
  `siswa_id` int(11) DEFAULT NULL,
  `jadwal_mata_pelajaran_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pengumuman`
--

CREATE TABLE `pengumuman` (
  `id_pengumuman` int(11) NOT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `deskripsi` text,
  `tanggal_mulai` date DEFAULT NULL,
  `tanggal_akhir` date DEFAULT NULL,
  `kepada` int(11) DEFAULT NULL COMMENT '1. Kepala sekolah, 2. Guru, 3. Wali Kelas, 4. Siswa, 5. All',
  `kadaluarsa` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pengumuman`
--

INSERT INTO `pengumuman` (`id_pengumuman`, `nama`, `deskripsi`, `tanggal_mulai`, `tanggal_akhir`, `kepada`, `kadaluarsa`) VALUES
(2, 'Sesok Prei Lur', 'Kandani Sesok Prei kok sek gak percoyo lur', '2021-12-25', '2021-12-26', 5, '2021-12-26'),
(3, 'Kesel ri', 'Istirahat sek ri', '2021-12-28', '2021-12-28', 5, '2021-12-28'),
(4, 'Testing Pengumuman ke kepala sekolah', 'Pengumuman hari ini ada rapat', '2022-01-03', '2022-01-03', 1, '2022-01-03');

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

--
-- Table structure for table `periode`
--

CREATE TABLE `periode` (
  `id_periode` int(11) NOT NULL,
  `kode` varchar(20) DEFAULT NULL,
  `deskripsi` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT NULL COMMENT '1 Aktif, 2 Tidak aktif'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `periode`
--

INSERT INTO `periode` (`id_periode`, `kode`, `deskripsi`, `status`) VALUES
(2, '20212', '2021 - 2022 Genap', 2),
(3, '20221', '2022 - 2023 Ganjil', 1),
(4, '20222', '2022 - 2023 Genap', 2);

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

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

CREATE TABLE `siswa` (
  `id_siswa` int(11) NOT NULL,
  `nis` varchar(25) DEFAULT NULL,
  `nama` varchar(100) DEFAULT NULL,
  `jenis_kelamin` char(1) DEFAULT NULL,
  `tempat_lahir` varchar(50) DEFAULT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `nama_ayah` varchar(100) DEFAULT NULL,
  `nama_ibu` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `siswa`
--

INSERT INTO `siswa` (`id_siswa`, `nis`, `nama`, `jenis_kelamin`, `tempat_lahir`, `tanggal_lahir`, `nama_ayah`, `nama_ibu`) VALUES
(54, '1743', 'AHMAD SAHAL MAHFUD', 'L', 'GRESIK', '2010-09-13', 'BADRUS SHOLEH', 'SITI CHITMATIL UMMAROH'),
(55, '1771', 'AIDA WAFIROH NAFI\'AH', 'P', 'GRESIK', '2011-03-30', 'AHMAD ROBI', 'ERNAWATI'),
(56, '1772', 'AMIRA NUR ROFIFAH', 'P', 'GRESIK', '2011-05-06', 'SUWAJI', 'KEMISAH'),
(57, '1775', 'ASMA\'UL FATMILAH', 'P', 'GRESIK', '2011-01-14', 'NUR ROZI', 'UMMAH LIANAH'),
(58, '1746', 'BILQIS HABIBATUR RAHMAH', 'P', 'GRESIK', '2010-12-23', 'UTSMAN', 'UMMATIN MUTAMIMAH'),
(59, '1747', 'CINDY KUROTUL JANNAH', 'P', 'GRESIK', '2010-12-23', 'LUDIONO', 'SITI KHOIRIYATUN'),
(60, '1749', 'FAJAR HISBUL MAULANA', 'L', 'GRESIK', '2010-02-06', 'ABDUL GHOFUR', 'MUDHOWIYAH'),
(61, '1750', 'FAJAR SURYA WIJAYA', 'L', 'GRESIK', '2010-12-11', 'HADI SUTIKNO', 'NITA MULYANTI'),
(62, '1751', 'FITRAH MUSTIKA AZZAHRA', 'P', 'GRESIK', '2010-10-04', 'KUSNALI', 'NUR MAHMUDIYAH'),
(63, '1755', 'ILMI VANIA ANGELICA', 'P', 'GRESIK', '2011-01-24', 'SUMADI', 'KARTINI'),
(64, '1758', 'LAURA AVRILIA', 'P', 'GRESIK', '2010-04-04', 'NUR HABIBUR ROHMAN', 'NUR AINUL'),
(65, '1759', 'MAULIDIA DWI FEBRIANA', 'P', 'GRESIK', '2011-02-17', 'HERU SETIAWAN', 'FITRIA'),
(66, '1780', 'MUHAMMAD EGA SONY PRATAMA', 'L', 'GRESIK', '2011-03-23', 'ABDUS SHOMAD', 'SRI WAHYUNI'),
(67, '1781', 'MUHAMMAD EKA RAMADANI', 'L', 'GRESIK', '2010-08-14', 'EDIK CAHYONO', 'SITI NURI\'ANAH'),
(68, '1782', 'MUHAMMAD FAJAR MAULIDAN', 'L', 'GRESIK', '2010-12-03', 'SUKRI', 'SUNARTIN'),
(69, '1783', 'MUHAMMAD LUTFI', 'L', 'GRESIK', '2010-12-04', 'JAWAR', 'SITI NUR HASANAH'),
(70, '1762', 'MUHAMMAD REZA ALFIYANSYAH', 'L', 'GRESIK', '2011-03-13', 'TUKAN', 'ANNISA\' ULA ROHMATIN'),
(71, '1785', 'MUHAMMAD ROMADONI', 'L', 'GRESIK', '2010-09-04', 'EKO BUDI ARI WIBOWO', 'ASMAUL KHUSNAH'),
(72, '1784', 'MUHAMMAD SAHAL  MAHFUDZ', 'L', 'GRESIK', '2011-03-16', 'AHMAD THOHIR', 'SRI UTAMIMAH'),
(73, '1786', 'MUHAMMAD SHOKHIBUL MAROMI', 'L', 'GRESIK', '2011-03-28', 'MOCHAMAD MA\'ARIF', 'SITI MAKNUNAH'),
(74, '1764', 'NAHDLATUL SITI NUR ABIDAH', 'P', 'GRESIK', '2010-09-20', 'MARYONO', 'NUR ASTUTIK'),
(75, '1787', 'NAYLA AURELLIA EGITA PUTRI', 'P', 'GRESIK', '2010-11-19', 'NURUL MUHLAJIN', 'SUMIATI'),
(76, '1766', 'RICHATUN NAJWA', 'P', 'GRESIK', '2010-10-19', 'RAHMAD', 'ZUHRIYAH'),
(77, '1768', 'ROFI\'ATUL ILMIYAH', 'P', 'GRESIK', '2010-09-22', 'ARIFIN', 'JUMILAH'),
(78, '1769', 'SHIFA BUNGA MEYLANI', 'P', 'GRESIK', '2010-05-25', 'TOTOK HARIANTO', 'UCI TYA ANDRIYANTI'),
(79, '1789', 'VITA PUTRI OKTAVIANI', 'P', 'GRESIK', '2010-10-11', 'MOHAMMAD SHOHIB', 'LILIS FAUZIYAH'),
(80, '1742', 'AHMAD FADEL KAFABI', 'L', 'GRESIK', '2010-10-16', 'ABDUL WAHIB', 'WAHYU KURNIAH'),
(81, '1773', 'AHMAD ROZAQ AL MUZAKKY', 'L', 'GRESIK', '2010-06-29', 'MIONO', 'ISTINIK NINGSIH'),
(82, '1744', 'AHMAD YUDHA PERMANA', 'L', 'GRESIK', '2010-11-28', 'ABDUL SALAM', 'NUR LAILATUL MUFIDAH'),
(83, '1774', 'ANANDA PUTRA PRAYOGA', 'L', 'GRESIK', '2011-03-04', 'NUR KHASAN', 'KRISTANTI'),
(84, '1745', 'ANGELIA AZHAR NUR ZAHRA', 'P', 'GRESIK', '2010-12-05', 'MULYONO', 'SUHARLIK'),
(85, '1776', 'CLAURA OKTAVIANA', 'P', 'GRESIK', '2010-10-22', 'SUWANTO', 'SUTAMI'),
(86, '1748', 'DI AJENG AULIA WULAN SAFITRI', 'P', 'GRESIK', '2010-08-02', 'IMAM MAWARDI', 'IFAROHA'),
(87, '1777', 'DIMAS RAMDHANI', 'L', 'GRESIK', '2010-08-23', 'EDI KURNIAWAN', 'NUR FADILATUL UMAROH'),
(88, '1778', 'FARID ARDIANSYAH ROHMAN ', 'L', 'GRESIK', '2010-09-13', 'FATHUR ROHMAN', 'NAFIATUS SAADAH'),
(89, '1752', 'FITRIA RAMADHANI', 'P', 'GRESIK', '2010-09-13', 'SATUMAN', 'MARLIYAH'),
(90, '1753', 'HAMIDAH AZZAH FADHILAH', 'P', 'GRESIK', '2011-03-26', 'IMAM GHOZALI', 'SRI WAHYUNINGSIH'),
(91, '1754', 'IKHWAN MAULANA', 'L', 'GRESIK', '2010-06-29', 'SUM IMAM HADI', 'ASLAKAH'),
(92, '1756', 'INES ZULFATUS SUROYYA', 'P', 'GRESIK', '2010-08-30', 'MUIT', 'SUHARTINI'),
(93, '1757', 'IRMATUS SHOLIKHAH', 'P', 'GRESIK', '2010-07-23', 'MUHAMMAD NASRUL ', 'KURNIAH'),
(94, '1779', 'MUHAMMAD AGIEL SIRODJ', 'L', 'GRESIK', '2010-09-18', 'MUHAMMAD MA\'RUF', 'SUSIATI'),
(95, '1760', 'MUHAMMAD HAIKAL KAMIL', 'L', 'GRESIK', '2010-08-05', 'MUHAMMAD SUPRIYADI', 'SITI MASRUROTIN'),
(96, '1761', 'MUHAMMAD KHOIRI', 'L', 'GRESIK', '2010-05-10', 'SUTIYO', 'SENITRI'),
(97, '1763', 'NABILA FATIMATUZ ZAHROH', 'P', 'GRESIK', '2011-05-28', 'M. USEMAN', 'URIFAH'),
(98, '1765', 'PRANAYA RADISTY', 'P', 'GRESIK', '2010-11-08', 'PRAWITO', 'SITI ROHMATIN'),
(99, '1767', 'RIZKY AGUNG SAPUTRA', 'L', 'GRESIK', '2011-01-13', 'MUHAMMAD SAIFULLAH', 'NUR AIHAH'),
(100, '1788', 'TSANIA NUR KHIMAYAH', 'P', 'GRESIK', '2011-06-04', 'UMAR', 'ULFA HASANAH'),
(101, '1770', 'ZAHIRAH ADI WAHYUNINGSIH', 'P', 'GRESIK', '2011-01-01', 'SAMPIADI', 'SRIASIH'),
(102, '008', 'Siswa Baru', 'L', 'Surabaya', '2022-01-03', 'Ayah Baru', 'Ibu Baru'),
(103, '123123', 'Siswa 1', 'L', 'Surabaya', '2021-08-23', 'Ayah Nya', 'Ibu Nya'),
(104, '123456', 'Siswa 2', 'L', 'Surabaya', '2021-08-23', 'Ayah Nya', 'Ibu Nya');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id_users` int(11) NOT NULL,
  `username` varchar(25) DEFAULT NULL COMMENT 'di isi NIP / NIS',
  `password` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id_users`, `username`, `password`) VALUES
(1, 'admin', 'c7ad44cbad762a5da0a452f9e854fdc1e0e7a52a38015f23f3eab1d80b931dd472634dfac71cd34ebc35d16ab7fb8a90c81f975113d6c7538dc69dd8de9077ec'),
(5, '1743', 'de2dc9fce780c9547c6466ba9eb76ca45cf3e5c319662feb3255eb5edfe26bd5af12a3ad52dddfb4b13512dfcb9461833634b6712f95915df1864e25077633c6'),
(6, '1771', 'c6c8f5c44262ac9bf0d5cd61fabcf1952c73c2d53a4aee1a4b480b10456b4d873aa519312b8a8980f292f622f434007ed96ebf35fd44cc6ed8a7477eba1eaf1a'),
(7, '1772', '977103c09d28fb5b01f8c8435286e9b48452a87d061ccf72eba45f12d19c8ac53a3609f8a0ee7f01a1950ab7752d954fec72566e5f92bf3cca0e6eb66c40d8e3'),
(8, '1775', 'd1095bb5f3528f9be66cf9339e13aec7d32a1dbc08fe8c34c15cf9ab9740d17fac84f311a41778bd7569f099474deaaa6833c831cbb58b47debaceb8b67ced05'),
(9, '1746', '87a326a84d6dd3372649c7fe06092e5d11bfa90202fa14f58de1e927b68b12b15405d270324642f65f067efc4c906ab5a76020ccec281ddbd28d664fdd3984cb'),
(10, '1747', 'cbea69c6b6f93dd6996883e8fe9288ba437d774bce21e0588770099103019a3a0903d496d4e6f3c01ce466888d599351b384e320ada7fa456ad3d6347954b344'),
(11, '1749', 'bfcb415aa6a8d31050326c4662ec5e5840650181464e29753ed0248cbf871979fa19c84022718ef469da7facce83e715b15a63801e98c2f9608ad69a955509a1'),
(12, '1750', 'ea8aefc6664a54b81a4e516d5a05f1748c5aebc7820b7a4b1bb10aed76f365eaaba9298e000dec3057a870bd5b76862a9c00dbc6c50b89ae7856ef06982594c2'),
(13, '1751', 'b0b0da1c69ba70ffedecac802e9b41a86a85b35a2fd021931fb98c81d8f0cb3b52166ecd4e9f4a9dc190194e6bdabbe79ff3542652cb5bd350ed4e915246fec5'),
(14, '1755', 'f1272ea7b085b9aae2ae0d4fdf661d6649b57d8c00cc8ca7ea1fe45b2e9b62243350b47c549ee5fcbd6a6a207acad9aeb7365b026bcad7c9f267415238583ebd'),
(15, '1758', '0d649d29fc44825647732f9bf3173e0c2134aa7f9fbc86c65d7e560eec1105729cd60f96c20166396bbf2695d98948ef09879fcac215d85a528571e080547688'),
(16, '1759', '721835078ef8bebd6f896931a0a6256aebc47d525cfd12546642f6f871554f2a413c5c677f9a7f70acc9aae794c4d813f97f55ef0c3fef14ef25fe4a15030f4b'),
(17, '1780', 'f13a24d6cdd8105fb9a7777d87377d0f66c125301aefa4c73da39a5986a1adfcd47b4f126f359c711ae6f3ae07716e7d4e53779f08c650a49f0e3c15f17721f5'),
(18, '1781', '76000446d9de699a79859e448c80e55902f18a49f1020e27f43c1af06d1358ff6f69438aa2a8fbe6f9b1e6c0d13d5bdce95f31ab758ddb96b4e614418e21a98e'),
(19, '1782', '30040fbf8e24a8d1a4140ef674741d21d289936b9ad27321444710fe078110d811828d6b8c6c410f50fb9593924fe1a34121423645e434033335004cbee796dc'),
(20, '1783', '5eec3108c5b95d8a495cd7335c5736df78eaf5c80e0b5c3716ecb6a2b1e602476ebf0d1fc876ee205ef1ec4dd18e626a352f8fe07489ac4bc589d7a4d9a24049'),
(21, '1762', '11cd562412e386c9e8cc7913ee6dcd16ad8407b8a1572976c169e3337ab869760685e88c61c49479b4393a2e2f8c30307bd7e88e09c5b9f7cd13e63e7b727872'),
(22, '1785', '565a5883def70a1025a79d8309a4fecee7038fa92875b946a4c36f022eae56fad04a38aa40d3b6d5859f5541a58b3c19da925041db8abcaabde0fa4bccc5c59e'),
(23, '1784', '12e447520ffbdf585ab1f3567ea6439a7938f14b99b3b300cccde4cf16a16a8ee6859c0195149822e4655f06c134f660d8f1e0f8e1354f2dd566bcae9701c959'),
(24, '1786', '5fd54736ff34b0b2f99427cc5d84d76f4959116322328056380967b6ffaaffbc95d1a33cf9a589a01fb2a704547f79a29eb2407d948296b0bf19e3db6cd88b29'),
(25, '1764', 'c9cb6b95a2a0d505d6a295c1e9737965a3545013063f7662ba2859b5f80cdf42a2d4507bbbdd929b323040d4bdcad2d861a49783620623914a8ac0001c86b475'),
(26, '1787', 'ef4168a81d8d29e88570a8d16a546a8b99d46ed4c18c3c0e1b05ffa977d7525056bd61a48f470736393fa7169041985e88d123da881b35816d0989f7e13f6281'),
(27, '1766', 'b717ce3882bf03a04cdd74c75cd59f9fbf82f018b5867451c6d31ae3fa2672e53e0ced4885804443f6b5137f912383bb5835ea0f2624159e9765bba7a7474fc6'),
(28, '1768', '17e77777312017c29d1e5f7ec875c36ec23073f8ca504938d1601b19fa3ba1d6be5aa7f78bbe20a8faa6aea0b6341021fa073d34b7cc82d37ee782e8e790f604'),
(29, '1769', '7fb0702a01eb7738f253cc3889a308653e33a167cfa5d11a12b1cb22103cc93a3c8622e808f37db809a347dde81d8f425b1401a08936a5e5b1d754e580145b58'),
(30, '1789', '17ad794d0e6508c20180d8efdf8111b1c1178faceac21ac57106e328d7c9e204bf1c85ef933c4ba17c8d84d88c5ee6ca38a57d1d9ab1617a7a8a234df45c7a0b'),
(31, '1742', '304719e31e7b70d448c1ef132b415c36d3819c0b00ef2c93124f58ecb83b084fe116dc0fb7f099571e094e7245f2cb65d1150b575311e3e2c76fcdb5f5b10646'),
(32, '1773', '3a2dd6d658ad3e544746789ae6b9e4522feaabc67a11b04f816291ae2e21f44d49fe3fc2293a9a5f858b6c20ecd25f65e4b264a455ef8c7d077cbf8cf4c96fbb'),
(33, '1744', '7e946b2b431f21195347497d5b6f3d3a49784414d5a457f6f2b3d7bffc29fc4c50062cc8d1a4f8c1b2937e715634ae191d6b4fe88bd85d2a186c870054565274'),
(34, '1774', 'd2b16e2b85b89c08fed0a5a29ac8909d53204cebac8d355e93d8fe3c42fe6e7bf52a2358b2a48127b53bc157ad145bba8c309bd04fb3c3a3488f9f0594fd0a34'),
(35, '1745', '3fcb3d30837800ef7809a6d65fd340f193324d3b999f9d7682a3a890ae6466413e6f937396e92499e0920b4bba2df7af5a2e95ed8349db027a9880ea81ee539b'),
(36, '1776', 'e4b20912f79b60a3950116667d1d679da759071b361c9ec63a4c07cd0bd83a7f97932a9f101fb48a20d3091fb5c986a7fbf215afd7b44e72c6b8dd8bc927fadd'),
(37, '1748', '727c6c4344d387ee97128dc1818f63380d0229f21c14dc84ee1819a23b0ac719375da12fa35419568428d6fa7d48b840f8e03af2d1a44484f9dedef712db0a8a'),
(38, '1777', '7f92b6ac7d8af0463b85a251208d0dfc66249ef0db2cd46759b5e2e6c5a8852f3508c3c872881018fe945dee8a0a09312fc67db3baa0ea192fd8892410063f30'),
(39, '1778', '3dea0b70ff4f8cc9f9d222fcf66cc630339e6cb1fec49705eabdc04a2c4b283cc5ba58f035352d9a1e56e223c9611af5f3f95c550cc471717115b752a7988a41'),
(40, '1752', '086a327d6214eef9bb599e70c1b15bb7168382ef367dde0d1abc9deb9d60536014b946f118247d21bde8f03695a0f78e03cd89c0ac50431a130fa8c41c2933b1'),
(41, '1753', '0da6cfe80c519ee2fc77c73c9cecf37344d0de725f7486de09b0b9ccf21c693851c327db118264e5b554822e4fc27c409fc4a9dbc45683de817af83229653995'),
(42, '1754', 'cf9bbb7ed922b875cad68bfc1bae3f950a75a194985c8c1fcaf3c76a954f6f1a3eb1e50021cb5a187fe615b6eb27ff17ebaf0990546c441edd13f1447a1f952b'),
(43, '1756', '0853c30960d1487617af6b881c6067e3b47fcd0abdcd71623bf5ed9ba137bd7818767be04b1ad4f58d1fb48e6969e836ba5dce2abe2c7ca050f129e955512f76'),
(44, '1757', '6151bb537c9d2107504509430f32ff8deaeddc8e30b26c4a1995f2d91222d0869e9b69d02f4c98c7d110ccaefb7413191f83d64c436ad5cb6effcffd62a38ebd'),
(45, '1779', '35bd27df170e56c43bc78939b6d09e459f64ad4e0d2f9cf53a871276780efa45e30a1a787cb60028d45216fa9021070cdbd89efa271b9f3709324bfdb5a2b9ed'),
(46, '1760', 'bdfbd6010a1393a12d65d89d7738f289e5012da90d76e9be820b7629365743e43ab5c52ce35f0da8d16ef7a1ca49c1be7b25004d66d97d2df75c8734bd99a82e'),
(47, '1761', '6b71407bbb4f88ffcc0e5b2bf1061893115c134351960caa250f7be9769d8b1302d993bbfb3a9ff5d7762be3aa8252a87c8d6f4633f4cabc55c8e9667299b00c'),
(48, '1763', '85c47cfa7e3d4f7ee1034f80d5d8b5fdea9fb095b0198c6fe893c68ae7a19b3749fe4ead90b31bf75bc4cf26c9177fea2bb9fe208b5a334fc2cbfe046e4527b3'),
(49, '1765', 'bf3150b5787ea8207c5e38dd12f714873c92967dd35ef33b8dabe0fda7c350f8b852d914b71464927c83cd4b47d493a1771e980d87f867c6aa76ca45f85ab3be'),
(50, '1767', '569784be7ecfda0e930f69b34292ae9f3bad71a8a23dc9644bcfc847ed5b5c7cc05c4a608f70b1803bafd152fb15857ab0ef10731069aad47d90daace6fe2744'),
(51, '1788', 'a1fe4cbb952dcfa62a2f8cf8b23736976e515ac236f6ab4b91fd0c0380bc11cba3d6919baf76b7f2a24207dc0fde96371f8647027ecbce9cacebd97e79a0570a'),
(52, '1770', '37c503980e2d04a516d1a3a70ae410acd8b522f23e6094e38854ed9853177570bd362beedac12fa2bcee415cc8e3d3087d86138495793dd50d0e1b87325b844e'),
(53, '8138747650200010', 'ba981a810da99f3a593758b16d8558798452fbe3e30528057566e2b402630654fec146172ddf9d52331ccf326f69e179ddfd468526a75e2be36862ada8c1e2ab'),
(54, '6541743637200000', '4cac7d6580d3d1c09069590a6b5273530963ee597f4ad4b0f8bd0aa48f7483dcafe46e1ec9b9dc5d9d512bf49e87a79bf6b2d933f81e14d0cadfac157e75564a'),
(55, '1439750656200000', '61adb1edbb71d023982d69404e05ca3f1e24207046f7c2232cff33844ae57974df2a9e3e5f1d52a8c77783992cd8087a8d3de2980da8deacce1dfaacadfb531b'),
(56, '4449754656300010', '87bc287c6a3760efbac477d13acddad804ed5fd0cadc63842a7092c9d887c1d740830d136125567f123fbec9fca085ef8767cb1fbc23c182c800d53131a86f5a'),
(57, '9455761662300000', '7425606c5bd52cb4b515b026cf35075e80a97a0eddb1f99427b2fb6bbcbdb7e88c1d70c3c048a64d455f03406ebe412b955f6576c4c9ff15b52a17ab39d8c8cf'),
(58, '5745762664300000', '9690e3ed4b7f85c3db2d46f23bc7fd0ecd4ce00056e252f9a77c4d0ec7dbfd0ed03686f1c3ef911507ff5deb70e162fc8ca8689ec7c952c320aa623131a30479'),
(59, '5745762664110050', '565dfabfcec9696290b7867f023313342846015eb2de25fcf8027c997aa65022adc072ab1ff3a3abfd5affe3c22061c3e92bb7cdbf0a47d628e1c3cd214b9ff0'),
(60, '20500820189001', '5fb1f580c49de73464c0c21c5233173cc99467ffc0781bd00a76ccae55a8ccc79af4edb32ad22dacd6df349d03bad2b6d48120c227060cf625fa15a166b44bc2'),
(61, '20500820194001', 'f0b8b4b2a451bd267d0470170b78f9c8db68c5bda3ed959471f8096d1f0be2b9effb8b02e34a9eb27ff874b2a1070b0044de2a6b8bc08a523051ee670992350b'),
(62, '20591905187001', '7f2d74a784d631381d384f4199dfa3130b8486689c2b61b372ae36737657b047fba61f07e224b251064d68803dfaab8e8313be778142fceb9bb02a093fe71ab2'),
(63, '20500820193001', '5b9ffa295dcf1857276b936a3fdb91d53572be7a05a1e3582dcf56fbccac6ef4ed1ec4071ffb354e2fdfde14732448c40b7973371a397f5e696f7d4d1e33f685'),
(64, '20500820193002', '8bd59d91d9502819237b0d9977743b22c703750b65469d9c32ac0b24821c690fb24405dab82e34055dce4611138011e1dd275ef7e49afada1910e6dbe5836cbf'),
(65, '20500820196002', '3ab9dd6ccb7008a9503afbf72b7e75ecb503bb9f8ed24a2622f85b3ec9c6a342ca1413e77cd5789f6ff9802e18605843f776a27396aace342c48c6d09c98969d'),
(66, '20500820197001', '7e957a08d72bb15d96b1ef1e36525c25bc6e5d014e65d6109a57f48d1533e420841d3854924548a1498b28f991c0c27ad6e9cdc55d43969ef3fbf956074ab51c'),
(67, '20532004193001', 'dad264e55b13afac302e0b41a026cb31b82eefaaf0cf3ad60171b9e8d5bbeac2de5996a6ca196059c8836d35ed90fdbe8340acb03ea4858a4426006ce7f967d9'),
(68, '20500820192001', 'efd49253d0bad40989fce98aeca6d6d06e3445baeffafea2ee8df143b0dfaec5317d323161260f69373a626421c08d14a48b623dc40de36916346d59e1969f09'),
(69, '007', '123c6c34e9de8147ace558724bdeab84184701f3f5bdec6dced4ed8b440d36782842dcb7f9f19e29b31c7b7bcde0f0ad80f46cc77222db5dde76cfc55e2a2fc5'),
(70, '008', 'ca03ac7e9f0f4f3515b24e971d4cad2ae47db441974ff0a12931b6ecf1d553766e7a59c4bcb0f6d37f39e6035fa25d1e8a133ff42dbdae7596ecd37ec8626880'),
(71, '123', 'c2e42eb433d56996de35c20fdba1a07fcabaa0a3a0d66211df12dcd2bfae3280fa126906a6855657e73111b16b706151960c7b1bab3cc3318d9b95cdec564a41'),
(72, '1234', 'd404559f602eab6fd602ac7680dacbfaadd13630335e951f097af3900e9de176b6db28512f2e000b9d04fba5133e8b1c6e8df59db3a8ab9d60be4b97cc9e81db'),
(73, '123123', '263fec58861449aacc1c328a4aff64aff4c62df4a2d50b3f207fa89b6e242c9aa778e7a8baeffef85b6ca6d2e7dc16ff0a760d59c13c238f6bcdc32f8ce9cc62'),
(74, '123456', 'ba3253876aed6bc22d4a6ff53d8406c6ad864195ed144ab5c87621b6c233b548baeae6956df346ec8c17f5ea10f35ee3cbc514797ed7ddd3145464e2a0bab413'),
(75, 'superadmin', '964a5502faec7a27f63ab5f7bddbe1bd8a685616a90ffcba633b5ad404569bd8fed4693cc00474a4881f636f3831a3e5a36bda049c568a89cfe54b1285b0c13e');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absensi_guru`
--
ALTER TABLE `absensi_guru`
  ADD PRIMARY KEY (`id_absensi`),
  ADD KEY `nip` (`nip`);

--
-- Indexes for table `absensi_siswa`
--
ALTER TABLE `absensi_siswa`
  ADD PRIMARY KEY (`id_absensi_siswa`),
  ADD KEY `nis` (`nis`),
  ADD KEY `mata_pelajaran_id` (`mata_pelajaran_id`);

--
-- Indexes for table `guru`
--
ALTER TABLE `guru`
  ADD PRIMARY KEY (`id_guru`),
  ADD UNIQUE KEY `nip` (`nip`);

--
-- Indexes for table `hak_akses`
--
ALTER TABLE `hak_akses`
  ADD PRIMARY KEY (`id_hak_akses`);

--
-- Indexes for table `hak_akses_users`
--
ALTER TABLE `hak_akses_users`
  ADD PRIMARY KEY (`id_hak_akses_users`),
  ADD KEY `hak_akses_id` (`hak_akses_id`),
  ADD KEY `users_id` (`users_id`);

--
-- Indexes for table `jadwal_mata_pelajaran`
--
ALTER TABLE `jadwal_mata_pelajaran`
  ADD PRIMARY KEY (`id_jadwal_mata_pelajaran`),
  ADD KEY `mata_pelajaran_id` (`mata_pelajaran_id`),
  ADD KEY `guru_id` (`guru_id`),
  ADD KEY `jadwal_mata_pelajaran_ibfk_2` (`kelas_siswa_id`);

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

--
-- Indexes for table `kelas_siswa`
--
ALTER TABLE `kelas_siswa`
  ADD PRIMARY KEY (`id_kelas_siswa`),
  ADD KEY `kelas_id` (`kelas_id`),
  ADD KEY `guru_id` (`guru_id`),
  ADD KEY `periode_id` (`periode_id`);

--
-- Indexes for table `kelas_siswa_detail`
--
ALTER TABLE `kelas_siswa_detail`
  ADD PRIMARY KEY (`id_kelas_siswa_detail`),
  ADD KEY `kelas_siswa_id` (`kelas_siswa_id`),
  ADD KEY `siswa_id` (`siswa_id`);

--
-- Indexes for table `kriteria_penilaian`
--
ALTER TABLE `kriteria_penilaian`
  ADD PRIMARY KEY (`id_kriteria_penilaian`);

--
-- Indexes for table `mata_pelajaran`
--
ALTER TABLE `mata_pelajaran`
  ADD PRIMARY KEY (`id_mata_pelajaran`);

--
-- Indexes for table `nilai_siswa`
--
ALTER TABLE `nilai_siswa`
  ADD PRIMARY KEY (`id_nilai_siswa`),
  ADD KEY `kelas_siswa_id` (`kelas_siswa_id`),
  ADD KEY `siswa_id` (`siswa_id`),
  ADD KEY `jadwal_mata_pelajaran_id` (`jadwal_mata_pelajaran_id`);

--
-- Indexes for table `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD PRIMARY KEY (`id_pengumuman`);

--
-- Indexes for table `periode`
--
ALTER TABLE `periode`
  ADD PRIMARY KEY (`id_periode`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id_users`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absensi_guru`
--
ALTER TABLE `absensi_guru`
  MODIFY `id_absensi` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `absensi_siswa`
--
ALTER TABLE `absensi_siswa`
  MODIFY `id_absensi_siswa` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `guru`
--
ALTER TABLE `guru`
  MODIFY `id_guru` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `hak_akses`
--
ALTER TABLE `hak_akses`
  MODIFY `id_hak_akses` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `hak_akses_users`
--
ALTER TABLE `hak_akses_users`
  MODIFY `id_hak_akses_users` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- AUTO_INCREMENT for table `jadwal_mata_pelajaran`
--
ALTER TABLE `jadwal_mata_pelajaran`
  MODIFY `id_jadwal_mata_pelajaran` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `kelas_siswa`
--
ALTER TABLE `kelas_siswa`
  MODIFY `id_kelas_siswa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `kelas_siswa_detail`
--
ALTER TABLE `kelas_siswa_detail`
  MODIFY `id_kelas_siswa_detail` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `kriteria_penilaian`
--
ALTER TABLE `kriteria_penilaian`
  MODIFY `id_kriteria_penilaian` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `mata_pelajaran`
--
ALTER TABLE `mata_pelajaran`
  MODIFY `id_mata_pelajaran` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `nilai_siswa`
--
ALTER TABLE `nilai_siswa`
  MODIFY `id_nilai_siswa` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pengumuman`
--
ALTER TABLE `pengumuman`
  MODIFY `id_pengumuman` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `periode`
--
ALTER TABLE `periode`
  MODIFY `id_periode` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `siswa`
--
ALTER TABLE `siswa`
  MODIFY `id_siswa` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id_users` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=76;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `absensi_guru`
--
ALTER TABLE `absensi_guru`
  ADD CONSTRAINT `absensi_guru_ibfk_1` FOREIGN KEY (`nip`) REFERENCES `guru` (`nip`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `absensi_siswa`
--
ALTER TABLE `absensi_siswa`
  ADD CONSTRAINT `absensi_siswa_ibfk_1` FOREIGN KEY (`nis`) REFERENCES `siswa` (`nis`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `absensi_siswa_ibfk_2` FOREIGN KEY (`mata_pelajaran_id`) REFERENCES `mata_pelajaran` (`id_mata_pelajaran`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `hak_akses_users`
--
ALTER TABLE `hak_akses_users`
  ADD CONSTRAINT `hak_akses_users_ibfk_1` FOREIGN KEY (`hak_akses_id`) REFERENCES `hak_akses` (`id_hak_akses`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `hak_akses_users_ibfk_2` FOREIGN KEY (`users_id`) REFERENCES `users` (`id_users`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `jadwal_mata_pelajaran`
--
ALTER TABLE `jadwal_mata_pelajaran`
  ADD CONSTRAINT `jadwal_mata_pelajaran_ibfk_1` FOREIGN KEY (`mata_pelajaran_id`) REFERENCES `mata_pelajaran` (`id_mata_pelajaran`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jadwal_mata_pelajaran_ibfk_2` FOREIGN KEY (`kelas_siswa_id`) REFERENCES `kelas_siswa` (`id_kelas_siswa`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `jadwal_mata_pelajaran_ibfk_3` FOREIGN KEY (`guru_id`) REFERENCES `guru` (`id_guru`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelas_siswa`
--
ALTER TABLE `kelas_siswa`
  ADD CONSTRAINT `kelas_siswa_ibfk_1` FOREIGN KEY (`kelas_id`) REFERENCES `kelas` (`id_kelas`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelas_siswa_ibfk_2` FOREIGN KEY (`guru_id`) REFERENCES `guru` (`id_guru`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelas_siswa_ibfk_3` FOREIGN KEY (`periode_id`) REFERENCES `periode` (`id_periode`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `kelas_siswa_detail`
--
ALTER TABLE `kelas_siswa_detail`
  ADD CONSTRAINT `kelas_siswa_detail_ibfk_1` FOREIGN KEY (`kelas_siswa_id`) REFERENCES `kelas_siswa` (`id_kelas_siswa`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `kelas_siswa_detail_ibfk_2` FOREIGN KEY (`siswa_id`) REFERENCES `siswa` (`id_siswa`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `nilai_siswa`
--
ALTER TABLE `nilai_siswa`
  ADD CONSTRAINT `nilai_siswa_ibfk_1` FOREIGN KEY (`kelas_siswa_id`) REFERENCES `kelas_siswa` (`id_kelas_siswa`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `nilai_siswa_ibfk_2` FOREIGN KEY (`siswa_id`) REFERENCES `siswa` (`id_siswa`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `nilai_siswa_ibfk_3` FOREIGN KEY (`jadwal_mata_pelajaran_id`) REFERENCES `jadwal_mata_pelajaran` (`id_jadwal_mata_pelajaran`) ON DELETE CASCADE ON UPDATE 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 */;