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


SET GLOBAL FOREIGN_KEY_CHECKS = 0;

CREATE TABLE `angsurantoko` (
  `id_angsurantoko` varchar(10) NOT NULL,
  `id_hutangtoko` varchar(10) NOT NULL,
  `tanggal` date NOT NULL,
  `angsuran` int(11) NOT NULL,
  PRIMARY KEY (`id_angsurantoko`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO angsurantoko VALUES
("AP001","HT001","2022-06-09","10000");




CREATE TABLE `bulan` (
  `idBulan` varchar(15) NOT NULL DEFAULT '0',
  `nmBulan` varchar(25) DEFAULT NULL,
  `urutan` int(2) DEFAULT NULL,
  PRIMARY KEY (`idBulan`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO bulan VALUES
("1","Januari","7"),
("10","Oktober","4"),
("11","November","5"),
("12","Desember","6"),
("2","Februari","8"),
("3","Maret","9"),
("4","April","10"),
("5","Mei","11"),
("6","Juni","12"),
("7","Juli","1"),
("8","Agustus","2"),
("9","September","3");




CREATE TABLE `hari` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nmHari` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;


INSERT INTO hari VALUES
("1","Senin"),
("2","Selasa"),
("3","Rabu"),
("4","Kamis"),
("5","Jumat"),
("6","Sabtu");




CREATE TABLE `hutangtoko` (
  `id_hutangtoko` varchar(10) NOT NULL,
  `hutangke` varchar(50) NOT NULL,
  `tanggal` date NOT NULL,
  `ket` varchar(100) NOT NULL,
  `nominal` int(11) NOT NULL,
  `sisa` int(11) NOT NULL,
  PRIMARY KEY (`id_hutangtoko`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;






CREATE TABLE `identitas` (
  `npsn` varchar(8) NOT NULL,
  `nmSekolah` varchar(100) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `kabupaten` varchar(100) NOT NULL,
  `propinsi` varchar(100) NOT NULL,
  `nipKepsek` varchar(200) DEFAULT NULL,
  `nmKepsek` varchar(100) DEFAULT NULL,
  `serverKey` varchar(200) DEFAULT NULL,
  `clientKey` varchar(200) DEFAULT NULL,
  `link` varchar(200) NOT NULL,
  `biaya_admin` int(11) DEFAULT NULL,
  `link_one_sender` varchar(100) NOT NULL,
  `token` varchar(100) NOT NULL,
  `wa` varchar(100) NOT NULL,
  `idnya` int(11) NOT NULL,
  `statusWa` enum('Y','T') NOT NULL,
  `skl` varchar(100) NOT NULL,
  `tgl_skl` date NOT NULL,
  `nmBendahara` varchar(100) DEFAULT NULL,
  `logo_kiri` varchar(255) DEFAULT NULL,
  `logo_kanan` varchar(100) NOT NULL,
  `tema` varchar(100) NOT NULL,
  PRIMARY KEY (`npsn`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO identitas VALUES
("10700295","SMA QUEEN AL FALAH","Ds. Ploso Rt/Rw 02/03 Kec. Mojo Kab. Kediri - 64162","Kediri","Jawa Timur ","-","Dofir, S.HI., M.Pd.","SB-Mid-server-8P-SchDhj5bCx9avo8qW07C8","SB-Mid-client-64iSZxTqhp3wal6u","https://app.sandbox.midtrans.com/snap/snap.js","500","https://api.watsap.id/send-message","19e77cb8ec7912bd02034bbee7980a91549db0e2","6281387223331","7151","Y","085.55/Ma.28.05.0067/PP.01.7.1/05/2021","2022-03-07","Siti Muthmainnah, S.Pd.","cropped-LOGO-SMA-QUEEN-AL-FALAH-VERSI-PNG.png","tutwuri.jpg","green");




CREATE TABLE `jam` (
  `idJam` int(11) NOT NULL AUTO_INCREMENT,
  `nmJam` varchar(200) NOT NULL,
  `dariJam` time NOT NULL,
  `sampaiJam` time NOT NULL,
  PRIMARY KEY (`idJam`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;


INSERT INTO jam VALUES
("1","Jam Ke - 1","07:00:00","08:30:00"),
("2","Jam Ke - 2","08:30:00","09:30:00"),
("3","Jam Ke - 3 ","10:00:00","11:30:00"),
("4","Jam Ke - 4 ","11:00:00","12:30:00"),
("5","Jam Ke - 5","12:30:00","14:00:00");




CREATE TABLE `jenis_bayar` (
  `idJenisBayar` int(10) NOT NULL AUTO_INCREMENT,
  `idPosBayar` int(5) DEFAULT NULL,
  `idTahunAjaran` int(5) DEFAULT NULL,
  `nmJenisBayar` varchar(100) DEFAULT NULL,
  `tipeBayar` enum('bulanan','bebas') DEFAULT 'bulanan',
  PRIMARY KEY (`idJenisBayar`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;


INSERT INTO jenis_bayar VALUES
("73","11","11","SPP ","bulanan"),
("74","11","11","SERAGAM","bebas");




CREATE TABLE `jenis_pengeluaran` (
  `idPengeluaran` int(11) NOT NULL AUTO_INCREMENT,
  `nmPengeluaran` varchar(100) NOT NULL,
  `jenis` enum('Masuk','Keluar') NOT NULL,
  PRIMARY KEY (`idPengeluaran`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


INSERT INTO jenis_pengeluaran VALUES
("2","BOS","Masuk");




CREATE TABLE `jurnal_umum` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `idPengeluaran` int(11) DEFAULT NULL,
  `tgl` date DEFAULT NULL,
  `ket` varchar(100) DEFAULT NULL,
  `penerimaan` int(10) DEFAULT 0,
  `pengeluaran` int(10) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;






CREATE TABLE `kas` (
  `kode` int(11) NOT NULL AUTO_INCREMENT,
  `keterangan` varchar(300) NOT NULL,
  `idKelas` int(50) NOT NULL,
  `tgl` date NOT NULL,
  `jumlah` int(10) NOT NULL,
  `jenis` varchar(20) NOT NULL,
  `keluar` int(20) NOT NULL,
  PRIMARY KEY (`kode`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;






CREATE TABLE `kelas_siswa` (
  `idKelas` int(5) NOT NULL AUTO_INCREMENT,
  `nmKelas` varchar(20) DEFAULT NULL,
  `ketKelas` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idKelas`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;


INSERT INTO kelas_siswa VALUES
("1","X TKJ",""),
("2","XI",""),
("3","XII","12");




CREATE TABLE `menu` (
  `idMenu` int(11) NOT NULL AUTO_INCREMENT,
  `noMenu` int(11) DEFAULT NULL,
  `namaMenu` varchar(255) DEFAULT NULL,
  `iconMenu` varchar(100) DEFAULT NULL,
  `lokasiFileMenu` varchar(255) DEFAULT NULL,
  `ketMenu` varchar(255) DEFAULT NULL,
  `viewMenu` varchar(100) DEFAULT NULL,
  `level` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`idMenu`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=latin1;


INSERT INTO menu VALUES
("1","","Dashboard","fa fa-dashboard","admin/home_admin_row.php","Main Menu","home","Admin"),
("2","","Kesiswaan","fa fa-users","-","Main Menu","-","Admin"),
("4","2","Kelas","fa fa-circle-o","admin/master_kelas.php","Sub Menu 1","kelas","Admin"),
("6","2","Siswa","fa fa-circle-o","admin/master_siswa.php","Sub Menu 1","siswa","Admin"),
("10","","Master Guru","fa fa-suitcase","-","Main Menu","-","Admin"),
("12","10","Guru","fa fa-circle-o","admin/sease/master_guru.php","Sub Menu 1","guru","Admin"),
("13","","Akademik","fa fa-graduation-cap","-","Main Menu","-","Admin"),
("14","13","Tahun Ajaran","fa fa-circle-o","admin/master_tahun.php","Sub Menu 1","tahun ajaran","Admin"),
("15","13","Kenaikan Kelas","fa fa-circle-o","admin/master_kenaikankelas.php","Sub Menu 1","kenaikankelas","Admin"),
("16","13","Kelulusan","fa fa-circle-o","admin/master_kelulusan.php","Sub Menu 1","kelulusan","Admin"),
("17","","Keuangan","fa fa-money","-","Main Menu","-","Admin"),
("18","17","Pembayaran Siswa","fa fa-circle-o","admin/keuangan_pembayaran.php","Sub Menu 1","pembayaran","Admin"),
("19","17","Setting Pembayaran","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("21","19","Pos Bayar","fa fa-circle-o","admin/master_posbayar.php","Sub Menu 2","posbayar","Admin"),
("22","19","Jenis Bayar","fa fa-circle-o","admin/master_jenisbayar.php","Sub Menu 2","jenisbayar","Admin"),
("25","17","Tabungan","fa fa-circle-o","admin/com_transaksi/transaksi.php","Sub Menu 1","transaksi
\n","Admin"),
("26","17","Kas & Bank","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("27","26","Saldo Awal","fa fa-circle-o","admin/master_saldoawal.php","Sub Menu 2","saldo awal","Admin"),
("28","26","Kas Keluar","fa fa-circle-o","admin/master_kaskeluar.php","Sub Menu 2","kas keluar","Admin"),
("29","26","Kas Masuk","fa fa-circle-o","admin/master_kasmasuk.php","Sub Menu 2","kas masuk","Admin"),
("30","26","Transfer Kas","fa fa-circle-o","admin/master_transferkas.php","Sub Menu 2","transfer kas","Admin"),
("31","26","Rekonsiliasi Bank","fa fa-circle-o","admin/master_rekonsiliasibank.php","Sub Menu 2","rekonsiliasi bank","Admin"),
("32","17","Penggajian","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("33","32","Setting Gaji","fa fa-circle-o","admin/master_settinggaji.php","Sub Menu 2","setting gaji","Admin"),
("34","32","Slip Gaji","fa fa-circle-o","admin/master_slipgaji.php","Sub Menu 2","slip gaji","Admin"),
("35","17","Hutang","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("37","35","Setting Hutang","fa fa-circle-o","admin/master_settinghutang.php","Sub Menu 2","setting hutang","Admin"),
("38","35","Bayar Hutang","fa fa-circle-o","admin/master_bayarhutang.php","Sub Menu 2","bayar hutang","Admin"),
("39","17","Kirim Tagihan","fa fa-circle-o","admin/master_kirimtagihan.php","Sub Menu 1","kirimtagihan","Admin"),
("40","","Laporan","fa fa-file-text-o","-","Main Menu","-","Admin"),
("41","40","Lap. Pembayaran","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("42","41","Per Kelas","fa fa-circle-o","admin/master_laporanperkelas.php","Sub Menu 2","laporan perkelas","Admin"),
("43","41","Per Tanggal","fa fa-circle-o","admin/master_laporanpertanggal.php","Sub Menu 2","laporan pertanggal","Admin"),
("44","41","Tagihan Santri","fa fa-circle-o","admin/master_laporantagihansiswa.php","Sub Menu 2","laporan tagihan santri","Admin"),
("45","41","Rekap Pembayaran","fa fa-circle-o","admin/master_laporanrekappembayaran.php","Sub Menu 2","laporan rekap pembayaran","Admin"),
("46","40","Lap. Keuangan","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("47","46","Lap. Jurnal (Kas)","fa fa-circle-o","admin/master_laporanjurnal.php","Sub Menu 2","laporan kas tunai","Admin"),
("48","46","Lap. Kas Bank","fa fa-circle-o","admin/master_laporankasbank.php","Sub Menu 2","laporan kas bank","Admin"),
("49","46","Lap. Neraca","fa fa-circle-o","admin/master_laporanneraca.php","Sub Menu 2","laporan neraca","Admin"),
("50","40","Lap. Tabungan","	
\nfa fa-circle-o","admin/master_laporantabungan.php","Sub Menu 1","laporan tabungan","Admin"),
("51","","Pengaturan","fa fa-gear","-","Main Menu","-","Admin"),
("52","51","Identitas Sekolah","fa fa-circle-o","admin/master_identitassekolah.php","Sub Menu 1","identitas","Admin"),
("53","51","Bulan","fa fa-circle-o","admin/master_bulan.php","Sub Menu 1","bulan","Admin"),
("54","51","Informasi","fa fa-circle-o","admin/master_informasi.php","Sub Menu 1","informasi","Admin"),
("55","51","Manajemen Pengguna","fa fa-circle-o","admin/master_pengguna.php","Sub Menu 1","pengguna","Admin"),
("56","51","Pemeliharaan","fa fa-circle-o","admin/master_pemeliharaan.php","Sub Menu 1","pemeliharaan","Admin"),
("57","51","Logs Transaksi","fa fa-circle-o","admin/master_logtransaksi.php","Sub Menu 1","logs transaksi","Admin"),
("58","","Dashboard","fa fa-dashboard","siswa/home_siswa.php","Main Menu","dashboard","Siswa"),
("59","","Profil","fa fa-user","siswa/master_siswa.php","Main Menu","profil","Siswa"),
("60","","Pembayaran","fa fa-money","siswa/master_pembayaran.php","Main Menu","cek pembayaran","Siswa"),
("61","9","Perizinan","fa fa-circle-o","admin/master_perizinan.php","Sub Menu 2","perizinan","Admin"),
("62","9","Pelanggaran","fa fa-circle-o","admin/master_pelanggaran.php","Sub Menu 2","pelanggaran","Admin"),
("63","40","Lap. Kesehatan","fa fa-circle-o","admin/master_laporankesehatan.php","Sub Menu 1","laporan kesehatan","Admin"),
("64","40","Lap. Konseling","fa fa-circle-o","-","Sub Menu 1","-","Admin"),
("65","64","Lap. Perizinan","fa fa-circle-o","admin/master_laporanperizinan.php","Sub Menu 2","laporan perizinan","Admin"),
("66","64","Lap. Pelanggaran","fa fa-circle-o","admin/master_laporanpelanggaran.php","Sub Menu 2","laporan pelanggaran","Admin"),
("67","46","Lap. Kas Kasir","fa fa-circle-o","admin/master_laporankaskasir.php","Sub Menu 2","laporan kas kasir","Admin");




CREATE TABLE `payment` (
  `idPayment` int(11) NOT NULL AUTO_INCREMENT,
  `tglPayment` datetime NOT NULL,
  `paymentOrder` varchar(100) NOT NULL,
  `idSiswa` int(11) NOT NULL,
  `jenisTagihan` varchar(20) NOT NULL,
  `idTagihan` int(11) NOT NULL,
  `nominal` int(10) NOT NULL,
  `tipePayment` varchar(100) DEFAULT NULL,
  `noPayment` varchar(100) DEFAULT NULL,
  `status` varchar(11) NOT NULL,
  PRIMARY KEY (`idPayment`)
) ENGINE=InnoDB AUTO_INCREMENT=155 DEFAULT CHARSET=utf8mb4;






CREATE TABLE `pos_bayar` (
  `idPosBayar` int(5) NOT NULL AUTO_INCREMENT,
  `nmPosBayar` varchar(100) DEFAULT NULL,
  `ketPosBayar` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`idPosBayar`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;


INSERT INTO pos_bayar VALUES
("11","SMK","Sekolah Menengah Kejuruan");




CREATE TABLE `rb_absen` (
  `kode_kehadiran` varchar(5) NOT NULL,
  `nama_kehadiran` varchar(20) NOT NULL,
  `nilai` int(2) NOT NULL,
  `bobot` varchar(5) NOT NULL,
  PRIMARY KEY (`kode_kehadiran`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_absen VALUES
("I","Izin","1","0.5"),
("S","Sakit","1","0.5");




CREATE TABLE `rb_absensi_guru` (
  `id_absensi_guru` int(5) NOT NULL AUTO_INCREMENT,
  `nip` varchar(20) NOT NULL,
  `kode_kehadiran` varchar(5) NOT NULL,
  `tanggal` date NOT NULL,
  `waktu_input` timestamp NOT NULL DEFAULT current_timestamp(),
  `nama` varchar(200) NOT NULL,
  `ukuran` varchar(100) NOT NULL,
  `tipe` varchar(100) NOT NULL,
  `latlng` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_absensi_guru`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;






CREATE TABLE `rb_absensi_setting` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `type` varchar(60) NOT NULL,
  `value` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_absensi_setting VALUES
("8","waktuSetting","17:15,19:00"),
("26","polygonSetting","[{\"lat\":\"-8.416164724726235\",\"lng\":\"114.25090475917031\"},{\"lat\":\"-8.416621113870201\",\"lng\":\"114.24997115978083\"},{\"lat\":\"-8.417417140159564\",\"lng\":\"114.25117303485693\"},{\"lat\":\"-8.416737864495051\",\"lng\":\"114.25285780616896\"},{\"lat\":\"-8.416175338433384\",\"lng\":\"114.25138765540622\"}]");




CREATE TABLE `rb_absensi_siswa` (
  `id_absensi_siswa` int(5) NOT NULL AUTO_INCREMENT,
  `kodejdwl` int(11) NOT NULL,
  `nisn` varchar(20) NOT NULL,
  `idKelas` int(15) NOT NULL,
  `kode_kehadiran` varchar(5) NOT NULL,
  `tanggal` date NOT NULL,
  `waktu_input` datetime NOT NULL,
  `nama` varchar(100) NOT NULL,
  `ukuran` varchar(100) NOT NULL,
  `tipe` varchar(100) NOT NULL,
  `latlng` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_absensi_siswa`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;


INSERT INTO rb_absensi_siswa VALUES
("100","38","135649671","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("99","38","0129700638","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("98","38","3083268826","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("97","38","20190007","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("96","38","20190006","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("95","38","20190005","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("94","38","20190004","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("93","38","3116747886","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("92","38","20190003","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("91","38","20190002","1","I","2022-08-10","2022-08-10 17:34:34","","","","","",""),
("90","37","3111259301","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("89","37","0121670374","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("86","37","3083268826","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("87","37","0129700638","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("88","37","135649671","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("85","37","20190007","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("84","37","20190006","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("83","37","20190005","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("82","37","20190004","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("81","37","3116747886","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("80","37","20190003","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("79","37","20190002","1","H","2022-08-01","2022-08-01 17:44:49","","","","","",""),
("101","38","0121670374","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("102","38","3111259301","1","H","2022-08-10","2022-08-10 17:34:43","","","","","",""),
("103","0","20190002","1","I","2022-08-10","2022-08-10 17:34:51","","","","","",""),
("104","0","20190003","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("105","0","3116747886","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("106","0","20190004","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("107","0","20190005","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("108","0","20190006","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("109","0","20190007","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("110","0","3083268826","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("111","0","0129700638","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("112","0","135649671","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("113","0","0121670374","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("114","0","3111259301","1","H","2022-08-10","2022-08-10 17:34:53","","","","","",""),
("115","37","20190002","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("116","37","20190003","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("117","37","20190004","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("118","37","20190005","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("119","37","20190006","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("120","37","20190007","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("121","37","1324","1","H","2022-08-14","2022-08-14 17:59:24","","","","","",""),
("122","37","20190002","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("123","37","20190003","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("124","37","20190004","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("125","37","20190005","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("126","37","20190006","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("127","37","20190007","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("128","37","1324","1","H","2022-08-18","2022-08-18 15:45:13","","","","","",""),
("129","37","20190002","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("130","37","20190004","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("131","37","20190006","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("132","37","1324","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("133","37","20190003","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("134","37","20190005","1","H","2022-08-30","2022-08-30 21:33:18","","","","","",""),
("135","37","20190007","1","H","2022-08-30","2022-08-30 21:33:18","","","","","","");




CREATE TABLE `rb_agama` (
  `id_agama` int(5) NOT NULL,
  `nama_agama` varchar(100) NOT NULL,
  PRIMARY KEY (`id_agama`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_agama VALUES
("1","Islam"),
("2","Kristen"),
("3","Hindu"),
("4","Budha");




CREATE TABLE `rb_barang` (
  `idBarang` int(10) NOT NULL AUTO_INCREMENT,
  `nmBarang` varchar(100) NOT NULL,
  `jumlahBarang` int(10) NOT NULL,
  PRIMARY KEY (`idBarang`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_barang VALUES
("1","Papan Tulis","0");




CREATE TABLE `rb_bk` (
  `id_bk` int(10) NOT NULL AUTO_INCREMENT,
  `hari` varchar(100) NOT NULL,
  `kode_kelas` varchar(100) NOT NULL,
  `nama_siswa` varchar(100) NOT NULL,
  `penindak` varchar(100) NOT NULL,
  `tanggal` date NOT NULL,
  `pelanggaran` text NOT NULL,
  `penyelesaian` text NOT NULL,
  `waktu_input` datetime NOT NULL,
  `users` varchar(50) NOT NULL,
  PRIMARY KEY (`id_bk`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


INSERT INTO rb_bk VALUES
("2","Senin","11","ALFAREL FERNANDA SAVA YUDISTIRA","DAVANSYAH MINDA ARDIAN","2022-01-31","Gak tauss","Cukur gigi","2022-01-31 14:45:38","admin"),
("3","Minggu","11","ALFAREL FERNANDA SAVA YUDISTIRA","DAVANSYAH MINDA ARDIAN","2022-02-06","Gak tau","Gak tau juga
\n","2022-02-06 07:09:19","");




CREATE TABLE `rb_elearning` (
  `id_elearning` int(10) NOT NULL AUTO_INCREMENT,
  `id_kategori_elearning` int(5) NOT NULL,
  `kodejdwl` int(5) NOT NULL,
  `nama_file` varchar(255) NOT NULL,
  `link` varchar(200) NOT NULL,
  `file_upload` text NOT NULL,
  `tanggal_tugas` datetime NOT NULL,
  `tanggal_selesai` datetime NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_elearning`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;


INSERT INTO rb_elearning VALUES
("30","1","2","Video Pembelajaran","xxN-fXBnQqA","20220130205935-WhatsApp-Image-2021-01-23-at-23.28.28.jpeg","2022-01-30 20:59:01","2022-01-30 20:59:01","Pencak Silat"),
("34","2","2","COba","","20220311124719-Invoice-396.pdf","2022-12-11 12:47:09","2022-12-17 12:47:09","dsa"),
("33","1","2","COba","","20220310000457-PURCHASE ORDER-92680.pdf","2022-12-10 00:04:46","2022-12-17 00:04:46","sfda"),
("35","1","4","Bocil","","20220630211113-laporan_absen_300622020241.xls","2022-12-30 21:11:03","2022-12-30 21:11:03","PAgar");




CREATE TABLE `rb_elearning_jawab` (
  `id_elearning_jawab` int(5) NOT NULL AUTO_INCREMENT,
  `id_elearning` int(5) NOT NULL,
  `nisn` varchar(20) NOT NULL,
  `keterangan` text NOT NULL,
  `file_tugas` varchar(255) NOT NULL,
  `waktu` datetime NOT NULL,
  PRIMARY KEY (`id_elearning_jawab`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


INSERT INTO rb_elearning_jawab VALUES
("7","34","20190002","Halloo bujk","20220705210228-AKUN ADMIN.docx","2022-07-05 21:02:28");




CREATE TABLE `rb_forum_komentar` (
  `id_forum_komentar` int(10) NOT NULL AUTO_INCREMENT,
  `id_forum_topic` int(10) NOT NULL,
  `nisn_nip` varchar(20) NOT NULL,
  `isi_komentar` text NOT NULL,
  `waktu_komentar` datetime NOT NULL,
  PRIMARY KEY (`id_forum_komentar`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;






CREATE TABLE `rb_forum_topic` (
  `id_forum_topic` int(10) NOT NULL AUTO_INCREMENT,
  `kodejdwl` int(10) NOT NULL,
  `judul_topic` varchar(255) NOT NULL,
  `isi_topic` text NOT NULL,
  `waktu` datetime NOT NULL,
  PRIMARY KEY (`id_forum_topic`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;






CREATE TABLE `rb_golongan` (
  `id_golongan` int(5) NOT NULL,
  `nama_golongan` varchar(150) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_golongan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_golongan VALUES
("1","IV/a","Golongan IV/a");




CREATE TABLE `rb_guru` (
  `nip` varchar(30) NOT NULL,
  `password` varchar(255) NOT NULL,
  `nama_guru` varchar(150) NOT NULL,
  `id_jenis_kelamin` int(5) NOT NULL,
  `tempat_lahir` varchar(150) NOT NULL,
  `tanggal_lahir` date NOT NULL,
  `nik` varchar(50) NOT NULL,
  `idKelas` varchar(100) NOT NULL,
  `niy_nigk` varchar(50) NOT NULL,
  `nuptk` varchar(50) NOT NULL,
  `id_status_kepegawaian` int(5) NOT NULL,
  `id_jenis_ptk` int(5) NOT NULL,
  `pengawas_bidang_studi` varchar(150) NOT NULL,
  `id_agama` int(5) NOT NULL,
  `alamat_jalan` varchar(255) NOT NULL,
  `rt` varchar(5) NOT NULL,
  `rw` varchar(5) NOT NULL,
  `nama_dusun` varchar(100) NOT NULL,
  `desa_kelurahan` varchar(100) NOT NULL,
  `kecamatan` varchar(100) NOT NULL,
  `kode_pos` int(10) NOT NULL,
  `telepon` varchar(15) NOT NULL,
  `hp` varchar(15) NOT NULL,
  `email` varchar(150) NOT NULL,
  `tugas_tambahan` varchar(100) NOT NULL,
  `id_status_keaktifan` int(5) NOT NULL,
  `sk_cpns` varchar(150) NOT NULL,
  `tanggal_cpns` date NOT NULL,
  `sk_pengangkatan` varchar(150) NOT NULL,
  `tmt_pengangkatan` date NOT NULL,
  `lembaga_pengangkatan` varchar(150) NOT NULL,
  `id_golongan` int(5) NOT NULL,
  `keahlian_laboratorium` varchar(150) NOT NULL,
  `sumber_gaji` varchar(150) NOT NULL,
  `nama_ibu_kandung` varchar(100) NOT NULL,
  `id_status_pernikahan` int(5) NOT NULL,
  `nama_suami_istri` varchar(100) NOT NULL,
  `nip_suami_istri` varchar(30) NOT NULL,
  `pekerjaan_suami_istri` varchar(100) NOT NULL,
  `tmt_pns` date NOT NULL,
  `lisensi_kepsek` varchar(20) NOT NULL,
  `jumlah_sekolah_binaan` int(5) NOT NULL,
  `diklat_kepengawasan` varchar(20) NOT NULL,
  `mampu_handle_kk` varchar(20) NOT NULL,
  `keahlian_breile` varchar(20) NOT NULL,
  `keahlian_bahasa_isyarat` varchar(20) NOT NULL,
  `npwp` varchar(50) NOT NULL,
  `kewarganegaraan` varchar(50) NOT NULL,
  `foto` varchar(255) NOT NULL,
  `page_absen` enum('Y','T') NOT NULL,
  PRIMARY KEY (`nip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_guru VALUES
("20190012","123","DAVANSYAH MINDA ARDIAN","1","","0000-00-00","","2","","20190012","0","2","","1","","","","","","","0","","","","1","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","20220706211623-png-clipart-logo-bank-rakyat-indonesia-graphics-brand-product-design-blue-cdr-thumbnail.png","Y"),
("20190011","123","CINTA AUDINDRA MAISAROH","2","","0000-00-00","","","","20190011","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190010","123","CINDY AULIA MEILANI","2","","0000-00-00","","0","","20190010","0","3","","1","","","","","","","0","","","","0","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190009","123","BUNGA AYU NABILLAH","1","","0000-00-00","","","","20190009","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190008","123","BINTANG ANANDA PUTRA","1","","0000-00-00","","","","20190008","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190007","123","BELQIS LUTHFIAH NAYSILA","2","","0000-00-00","","","","20190007","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190006","123","ARGA ARDIANSAH","2","","0000-00-00","","","","20190006","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190005","123","ANYA DEWI NUR ELLYANI","1","","0000-00-00","","0","","20190005","0","2","","1","","","","","","","0","","","","0","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190004","123","ANISSA RAHMA SETYAWAN","1","","0000-00-00","","","","20190004","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190001","123","ALFAREL FERNANDA SAVA YUDISTIRA","1","","0000-00-00","","0","","20190001","0","3","","1","","","","","","","0","","","","0","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190002","123","ALIFANESYA BINTANG BINANDARI RIFANDA","2","","0000-00-00","","","","20190002","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("20190003","123","ANASTASYA RAMADHANI AZARINE PERMADI","2","","0000-00-00","","","","20190003","0","1","","1","","","","","","","0","","","","","1","","0000-00-00","","0000-00-00","","0","","","","0","","","","0000-00-00","","0","","","","","","","","Y"),
("202201001503504","123","Rivani Noer Maulidi","1","Banyuwangi ","1998-07-02","","1","","11111111111","1","2","","1","Sampangan Muncar","03","05","Muncar","Kedungrejo","Muncar","68472","","085156619657","theivhan@gmail.com","1","1","","0000-00-00","","0000-00-00","","0","","","","1","","","","0000-00-00","","0","","","","","","Indonesia","20220830213344-Rental-Mobil-Jepara-Logo-Maju-Trans-Jepara-11-150x150.png","Y");




CREATE TABLE `rb_inv_keluar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idBarang` int(11) NOT NULL,
  `tgl` date NOT NULL,
  `jumlahBarang` int(10) NOT NULL,
  `nmOrang` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_inv_keluar VALUES
("11","1","2022-02-06","100","Zaki Mubarok"),
("12","1","2022-02-06","20","Zaki Mubarok"),
("13","1","2022-02-06","30","Zaki Mubarok");




CREATE TABLE `rb_inv_masuk` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idBarang` int(11) NOT NULL,
  `tgl` date NOT NULL,
  `jumlahBarang` int(10) NOT NULL,
  `nmOrang` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;






CREATE TABLE `rb_inventaris` (
  `idInv` int(10) NOT NULL AUTO_INCREMENT,
  `idKelas` int(11) NOT NULL,
  `nmBarang` varchar(100) NOT NULL,
  `jumlahBarang` int(11) NOT NULL,
  PRIMARY KEY (`idInv`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_inventaris VALUES
("14","11","Kapur","100"),
("15","11","Papan Tulis","1");




CREATE TABLE `rb_jadwal_pelajaran` (
  `kodejdwl` int(10) NOT NULL AUTO_INCREMENT,
  `idTahunAjaran` int(5) NOT NULL,
  `idKelas` varchar(10) NOT NULL,
  `kode_pelajaran` varchar(10) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `nip` varchar(30) NOT NULL,
  `jam_ke` varchar(10) NOT NULL,
  `hari` varchar(20) NOT NULL,
  `aktif` enum('Ya','Tidak') NOT NULL,
  PRIMARY KEY (`kodejdwl`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;


INSERT INTO rb_jadwal_pelajaran VALUES
("41","11","1","BP","Semester Ganjil","","1","Selasa","Ya"),
("42","11","1","BP","Semester Ganjil","","2","Selasa","Ya"),
("43","11","1","MK17","Semester Ganjil","202201001503504","1","Senin","Ya"),
("40","11","1","MK17","Semester Ganjil","20190012","4","Selasa","Ya"),
("39","11","1","MK17","Semester Ganjil","20190012","3","Selasa","Ya"),
("37","11","1","001","Semester Ganjil","20190012","1","Senin","Ya"),
("38","11","1","001","Semester Ganjil","20190012","2","Senin","Ya"),
("44","11","1","MK17","Semester Ganjil","202201001503504","2","Senin","Ya"),
("45","11","1","MK17","Semester Ganjil","202201001503504","3","Senin","Ya");




CREATE TABLE `rb_jawaban_essai` (
  `id_jawaban_essai` int(5) NOT NULL AUTO_INCREMENT,
  `nisn` varchar(20) NOT NULL,
  `id_pertanyaan_essai` int(10) NOT NULL,
  `jawaban_essai` text NOT NULL,
  `waktu_tugas` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id_jawaban_essai`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;


INSERT INTO rb_jawaban_essai VALUES
("9","20190001 ","15","Awobuk
\n","2022-03-11 13:22:47"),
("10","20190002 ","17","Iya aku coba
\n","2022-06-30 08:29:01"),
("11","20190002 ","20","Jakarta
\n","2022-06-30 21:06:07"),
("12","20190002 ","19","Bulan","2022-06-30 21:06:16");




CREATE TABLE `rb_jawaban_objektif` (
  `id_jawaban_objektif` int(5) NOT NULL AUTO_INCREMENT,
  `nisn` varchar(20) NOT NULL,
  `id_pertanyaan_objektif` int(10) NOT NULL,
  `jawaban` varchar(2) NOT NULL,
  `waktu_objektif` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id_jawaban_objektif`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;


INSERT INTO rb_jawaban_objektif VALUES
("26","20190001 ","10","b","2022-03-11 13:28:28"),
("27","20190002 ","12","a","2022-07-05 20:56:02"),
("28","20190002 ","14","a","2022-06-30 21:06:19");




CREATE TABLE `rb_jenis_kelamin` (
  `id_jenis_kelamin` int(5) NOT NULL,
  `jenis_kelamin` varchar(50) NOT NULL,
  PRIMARY KEY (`id_jenis_kelamin`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_jenis_kelamin VALUES
("1","Laki-laki"),
("2","Perempuan");




CREATE TABLE `rb_jenis_ptk` (
  `id_jenis_ptk` int(5) NOT NULL AUTO_INCREMENT,
  `jenis_ptk` varchar(100) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_jenis_ptk`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;


INSERT INTO rb_jenis_ptk VALUES
("5","Tenaga Administrasi Sekolah",""),
("2","Guru Mapel",""),
("3","Guru BK",""),
("4","Wali Kelas",""),
("1","Kepala Sekolah","");




CREATE TABLE `rb_journal_list` (
  `id_journal` int(10) NOT NULL AUTO_INCREMENT,
  `kodejdwl` int(10) NOT NULL,
  `hari` varchar(20) NOT NULL,
  `tanggal` date NOT NULL,
  `jam_ke` varchar(50) NOT NULL,
  `materi` text NOT NULL,
  `keterangan` text NOT NULL,
  `waktu_input` datetime NOT NULL,
  `users` varchar(50) NOT NULL,
  PRIMARY KEY (`id_journal`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;


INSERT INTO rb_journal_list VALUES
("15","37","Senin","2022-08-01","1","<p>Sadasd<sup> fd<span style=\"font-size:10.8333px\">2</span></sup></p>
\n","sdad","2022-08-01 15:11:48","20190012");




CREATE TABLE `rb_kategori_elearning` (
  `id_kategori_elearning` int(5) NOT NULL AUTO_INCREMENT,
  `nama_kategori_elearning` varchar(50) NOT NULL,
  PRIMARY KEY (`id_kategori_elearning`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


INSERT INTO rb_kategori_elearning VALUES
("1","Bahan"),
("2","Tugas");




CREATE TABLE `rb_kategori_quiz_ujian` (
  `id_kategori_quiz_ujian` int(5) NOT NULL AUTO_INCREMENT,
  `kategori_quiz_ujian` varchar(50) NOT NULL,
  PRIMARY KEY (`id_kategori_quiz_ujian`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


INSERT INTO rb_kategori_quiz_ujian VALUES
("1","Quiz Online"),
("2","Ujian Online");




CREATE TABLE `rb_kehadiran` (
  `kode_kehadiran` varchar(5) NOT NULL,
  `nama_kehadiran` varchar(20) NOT NULL,
  `nilai` int(2) NOT NULL,
  `bobot` varchar(5) NOT NULL,
  PRIMARY KEY (`kode_kehadiran`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_kehadiran VALUES
("H","Hadir","1","1"),
("I","Izin","1","0.5"),
("S","Sakit","1","0.5"),
("A","Alpa","0","0"),
("T","Terlambat","1","0.5"),
("P","Pulang","1","0.5");




CREATE TABLE `rb_kelompok_mata_pelajaran` (
  `id_kelompok_mata_pelajaran` int(5) NOT NULL AUTO_INCREMENT,
  `jenis_kelompok_mata_pelajaran` varchar(50) NOT NULL,
  `nama_kelompok_mata_pelajaran` varchar(255) NOT NULL,
  PRIMARY KEY (`id_kelompok_mata_pelajaran`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;


INSERT INTO rb_kelompok_mata_pelajaran VALUES
("1","A","Kelompok A "),
("2","B","Kelompok B"),
("3","C","Kelompok C");




CREATE TABLE `rb_mata_pelajaran` (
  `kode_pelajaran` varchar(20) NOT NULL,
  `nip` varchar(30) NOT NULL,
  `namamatapelajaran` varchar(150) NOT NULL,
  `aktif` enum('Ya','Tidak') NOT NULL,
  PRIMARY KEY (`kode_pelajaran`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_mata_pelajaran VALUES
("001","20190012","Matematika","Ya"),
("MK17","20190011","Bahasa Indonesia","Ya"),
("BP","20190010","Bahasa Jepan","Ya"),
("IPA","20190004","Ilmu Pengetahuan Alam","Ya");




CREATE TABLE `rb_nasabah` (
  `nisnSiswa` int(100) NOT NULL AUTO_INCREMENT,
  `idKelas` int(100) NOT NULL,
  PRIMARY KEY (`nisnSiswa`)
) ENGINE=InnoDB AUTO_INCREMENT=2147483648 DEFAULT CHARSET=latin1;


INSERT INTO rb_nasabah VALUES
("20190002","11"),
("20190003","11"),
("20190004","11"),
("20190005","11"),
("20190006","11"),
("20190007","11"),
("121670374","1"),
("129700638","1"),
("135649671","1"),
("2147483647","1");




CREATE TABLE `rb_nilai` (
  `id_nilai_pengetahuan` int(10) NOT NULL AUTO_INCREMENT,
  `id_kelompok_mapel` int(10) NOT NULL,
  `paralel` int(10) NOT NULL,
  `kode` varchar(20) NOT NULL,
  `nisn` varchar(100) NOT NULL,
  `nama_mapel` varchar(200) NOT NULL,
  `nilai_peng` varchar(100) NOT NULL,
  `nilai_ket` varchar(100) NOT NULL,
  `user_akses` varchar(50) NOT NULL,
  `waktu` datetime NOT NULL,
  PRIMARY KEY (`id_nilai_pengetahuan`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=latin1;


INSERT INTO rb_nilai VALUES
("79","2","0","5","20190001","Pengantar Teknologi","89","89","1","2022-02-04 14:10:44"),
("78","2","0","4","20190001","Kalkulus","93","93","1","2022-02-04 14:10:44"),
("77","2","0","3","20190001","Aritmatika Dasar","90","90","1","2022-02-04 14:10:44"),
("76","1","0","2","20190001","Bahasa Inggris","80","80","1","2022-02-04 14:10:44"),
("75","1","0","11","20190001","Matematika","0","0","1","2022-02-04 14:10:44"),
("74","1","1","","20190001","SKI","88","88","1","2022-02-04 14:10:44"),
("73","1","1","","20190001","Aqidah","98","98","1","2022-02-04 14:10:44"),
("72","1","1","","20190001","Fikih","90","90","1","2022-02-04 14:10:44"),
("1","1","0","1","20190001","Pendidikan Agama Islam","89","89","1","2022-02-04 14:10:44"),
("80","3","0","6","20190001","Sejarah Indonesia","87","87","1","2022-02-04 14:10:44"),
("81","3","0","7","20190001","Pendidikan Pancasila","78","78","1","2022-02-04 14:10:44"),
("82","3","0","8","20190001","Seni Budaya","89","89","1","2022-02-04 14:10:44"),
("83","3","0","9","20190001","Pendidikan Olahraga","88","88","1","2022-02-04 14:10:44"),
("84","3","0","10","20190001","Prakarya Kewirausahaan","87","87","1","2022-02-04 14:10:44");




CREATE TABLE `rb_nilai_pertanyaan_essai` (
  `id_nilai_pertanyaan_essai` int(5) NOT NULL AUTO_INCREMENT,
  `id_quiz_ujian` int(5) NOT NULL,
  `nisn` varchar(20) NOT NULL,
  `nilai_essai` int(3) NOT NULL,
  PRIMARY KEY (`id_nilai_pertanyaan_essai`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;


INSERT INTO rb_nilai_pertanyaan_essai VALUES
("6","9","20190001","40"),
("7","13","20190002","20");




CREATE TABLE `rb_pertanyaan_essai` (
  `id_pertanyaan_essai` int(11) NOT NULL AUTO_INCREMENT,
  `id_quiz_ujian` int(5) NOT NULL,
  `pertanyaan_essai` text NOT NULL,
  PRIMARY KEY (`id_pertanyaan_essai`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;


INSERT INTO rb_pertanyaan_essai VALUES
("15","9","Wok
\n"),
("16","10","Haruskah aku mati "),
("17","11","Mencoba"),
("18","12","Coba jelaskan
\n"),
("19","13","Jelaskan Saja
\n"),
("20","13","Ibu Kota Indonesia ?
\n");




CREATE TABLE `rb_pertanyaan_objektif` (
  `id_pertanyaan_objektif` int(11) NOT NULL AUTO_INCREMENT,
  `id_quiz_ujian` int(11) NOT NULL,
  `pertanyaan_objektif` text NOT NULL,
  `jawab_a` varchar(255) NOT NULL,
  `jawab_b` varchar(255) NOT NULL,
  `jawab_c` varchar(255) NOT NULL,
  `jawab_d` varchar(255) NOT NULL,
  `jawab_e` varchar(255) NOT NULL,
  `kunci_jawaban` varchar(5) NOT NULL,
  PRIMARY KEY (`id_pertanyaan_objektif`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;


INSERT INTO rb_pertanyaan_objektif VALUES
("10","9","Bau","Hallo","Hai","Hula","Huna","Hanu","a"),
("11","10","Mencoba meresapi","Bocil","Bocol","Bucil","Bobol ","PAgar","a"),
("12","11","GAs ?","Halo","Hali","Halu","Halp","Hala","b"),
("13","12","Jelaskan saja","Makna","Arti","Coba","Saja","Pilih","c"),
("14","13","Menangis adalah kegiatan ?","Sedi","Gembira","Riang","Murung","Senang","a");




CREATE TABLE `rb_predikat` (
  `id_predikat` int(5) NOT NULL AUTO_INCREMENT,
  `kode_kelas` varchar(10) NOT NULL,
  `nilai_a` int(3) NOT NULL,
  `nilai_b` int(3) NOT NULL,
  `grade` varchar(5) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_predikat`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;


INSERT INTO rb_predikat VALUES
("1","0","86","100","A","Sangat Baik"),
("2","0","79","85","B","Baik"),
("3","0","77","78","C","Cukup"),
("4","0","0","77","D","Kurang");




CREATE TABLE `rb_prestasi` (
  `idPrestasi` int(10) NOT NULL AUTO_INCREMENT,
  `idSiswa` int(10) NOT NULL,
  `tahunAjaran` int(10) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `tgl` date DEFAULT NULL,
  `nmPrestasi` varchar(200) NOT NULL,
  `tingkatPrestasi` enum('Internasional','Nasional','Provinsi','Kabupaten/Kota','Kecamatan') NOT NULL DEFAULT 'Nasional',
  `juaraPrestasi` int(10) NOT NULL,
  `stdel` int(10) NOT NULL,
  PRIMARY KEY (`idPrestasi`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;


INSERT INTO rb_prestasi VALUES
("4","27","11","Ganjil","2022-02-06","Bulu tangkis","Internasional","2","0"),
("5","151","11","Ganjil","2022-07-05","Juara 1 Renang","Nasional","1","0");




CREATE TABLE `rb_quiz_ujian` (
  `id_quiz_ujian` int(5) NOT NULL AUTO_INCREMENT,
  `id_kategori_quiz_ujian` int(5) NOT NULL,
  `kodejdwl` int(5) NOT NULL,
  `keterangan` text NOT NULL,
  `batas_waktu` datetime NOT NULL,
  PRIMARY KEY (`id_quiz_ujian`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;


INSERT INTO rb_quiz_ujian VALUES
("9","2","2","COba","2022-03-16 12:00:11"),
("13","2","4","Bocil","2022-06-30 22:34:27"),
("11","1","2","kkxc","2022-12-30 09:00:25");




CREATE TABLE `rb_setting_absen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `waktu_masuk` time NOT NULL,
  `waktu_absen` time NOT NULL,
  `waktu_pulang` time NOT NULL,
  `waktu_batas_pulang` time NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_setting_absen VALUES
("1","17:00:00","14:00:00","17:30:00","21:30:00");




CREATE TABLE `rb_status_keaktifan` (
  `id_status_keaktifan` int(5) NOT NULL,
  `nama_status_keaktifan` varchar(255) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_status_keaktifan`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO rb_status_keaktifan VALUES
("1","Aktif",""),
("2","Tidak Aktif","");




CREATE TABLE `rb_status_kepegawaian` (
  `id_status_kepegawaian` int(5) NOT NULL AUTO_INCREMENT,
  `status_kepegawaian` varchar(255) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_status_kepegawaian`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;


INSERT INTO rb_status_kepegawaian VALUES
("1","Tenaga Honor Sekolah\n",""),
("2","Guru Honor Sekolah\n",""),
("3","ASN",""),
("4","NON ASN","");




CREATE TABLE `rb_status_pernikahan` (
  `id_status_pernikahan` int(5) NOT NULL AUTO_INCREMENT,
  `status_pernikahan` varchar(150) NOT NULL,
  `keterangan` text NOT NULL,
  PRIMARY KEY (`id_status_pernikahan`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;


INSERT INTO rb_status_pernikahan VALUES
("1","Menikah",""),
("2","Belum Menikah","");




CREATE TABLE `rb_tugas_tambahan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nmTugas` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;


INSERT INTO rb_tugas_tambahan VALUES
("1","Wali Kelas"),
("2","Wakil Kepala Sekolah"),
("3","Piket");




CREATE TABLE `rb_wa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;






CREATE TABLE `realisasi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idPengeluaran` int(11) NOT NULL,
  `uraian` varchar(100) NOT NULL,
  `pagu` varchar(100) NOT NULL,
  `realisasi` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;


INSERT INTO realisasi VALUES
("2","1","Memakan","100000","75000"),
("4","3","Beli 100","100000000","10500000");




CREATE TABLE `siswa` (
  `idSiswa` int(10) NOT NULL AUTO_INCREMENT,
  `nisSiswa` varchar(25) DEFAULT NULL,
  `nisnSiswa` varchar(25) DEFAULT NULL,
  `nmSiswa` varchar(100) DEFAULT NULL,
  `jkSiswa` varchar(15) DEFAULT NULL,
  `agamaSiswa` varchar(15) DEFAULT NULL,
  `tglLahirSiswa` date DEFAULT NULL,
  `tmptLahir` varchar(100) NOT NULL,
  `idKelas` int(5) DEFAULT NULL,
  `statusSiswa` enum('Aktif','Non Aktif','Pindah','Drop Out','Lulus') DEFAULT 'Aktif',
  `username` varchar(20) NOT NULL,
  `password` varchar(200) DEFAULT NULL,
  `level` varchar(10) NOT NULL,
  `statusKeluarga` varchar(100) DEFAULT NULL,
  `anakKe` varchar(100) DEFAULT NULL,
  `sekolah` varchar(100) DEFAULT NULL,
  `nmOrtuIbu` varchar(100) DEFAULT NULL,
  `nmOrtu` varchar(40) DEFAULT NULL,
  `alamatOrtu` varchar(100) DEFAULT NULL,
  `noHpOrtu` varchar(30) DEFAULT NULL,
  `noHpSis` varchar(200) NOT NULL,
  `saldo` double NOT NULL,
  `foto` varchar(200) NOT NULL,
  PRIMARY KEY (`idSiswa`),
  KEY `fk_kelas` (`idKelas`),
  KEY `fk_status` (`statusSiswa`)
) ENGINE=InnoDB AUTO_INCREMENT=177 DEFAULT CHARSET=latin1;


INSERT INTO siswa VALUES
("41","2","20190002","ALIFANESYA BINTANG BINANDARI RIFANDA","L","Islam","1999-07-02","","1","Aktif","siswa1","siswa","siswa","","","","Salika","Wali Murid","Lawangs","6285724413091","  62 ","-1610000","WhatsApp Image 2022-03-28 at 22.49.28.jpeg"),
("42","3","20190003","ANASTASYA RAMADHANI AZARINE PERMADI","P","Islam","","","1","Lulus","siswa2","siswa","siswa","","","","","Wali Murid","Lawang","  62 ","  62 ","0",""),
("43","4","20190004","ANISSA RAHMA SETYAWAN","P","Islam","","","1","Aktif","siswa3","siswa","siswa","","","","","Wali Murid","Lawang","  62 ","  62 ","0",""),
("44","5","20190005","ANYA DEWI NUR ELLYANI","P","Islam","","","1","Aktif","siswa4","siswa","siswa","","","","","Wali Murid","Lawang","  62 ","  62 ","0",""),
("45","6","20190006","ARGA ARDIANSAH","L","Islam","","","1","Aktif","siswa5","siswa","siswa","","","","","Wali Murid","Lawang","  62 ","  62 ","0",""),
("46","7","20190007","BELQIS LUTHFIAH NAYSILA","P","Islam","","","1","Aktif","siswa6","siswa","siswa","","","","","Wali Murid","Lawang","  62 ","  62 ","0",""),
("176","123456780","1324","RIVANI NOER M","L","Islam","2022-08-14","Banyuwangi","1","Aktif","aku","aku","siswa","","","SMK Aswaja","","","Sampangan Muncar","62","085233072661","0","");




CREATE TABLE `siswa_konseling` (
  `idKonseling` int(11) NOT NULL AUTO_INCREMENT,
  `siswa` int(11) NOT NULL,
  `tahunAjaran` int(11) NOT NULL,
  `tanggal` date NOT NULL,
  `pelanggaran` varchar(100) NOT NULL,
  `tindakan` varchar(100) NOT NULL,
  `poin` varchar(20) NOT NULL,
  `catatan` varchar(255) NOT NULL,
  `stdel` int(11) DEFAULT NULL,
  PRIMARY KEY (`idKonseling`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4;






CREATE TABLE `tagihan_bebas` (
  `idTagihanBebas` int(50) NOT NULL AUTO_INCREMENT,
  `idJenisBayar` int(5) DEFAULT NULL,
  `idSiswa` int(10) DEFAULT NULL,
  `idKelas` int(5) DEFAULT NULL,
  `idBulan` int(10) NOT NULL,
  `totalTagihan` int(10) DEFAULT NULL,
  `ref` varchar(100) NOT NULL,
  `statusBayar` enum('0','1','2') DEFAULT '0',
  PRIMARY KEY (`idTagihanBebas`),
  KEY `fk_t_jenis` (`idJenisBayar`),
  KEY `fk_t_siswa` (`idSiswa`),
  KEY `fk_t_kelas` (`idKelas`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;


INSERT INTO tagihan_bebas VALUES
("18","74","41","1","8","900000","","2"),
("19","74","43","1","8","900000","","0"),
("20","74","44","1","8","900000","","0"),
("21","74","45","1","8","900000","","0"),
("22","74","46","1","8","900000","","0"),
("23","74","176","1","8","900000","","0");




CREATE TABLE `tagihan_bebas_bayar` (
  `idTagihanBebasBayar` int(50) NOT NULL AUTO_INCREMENT,
  `idTagihanBebas` int(50) DEFAULT NULL,
  `tglBayar` date DEFAULT NULL,
  `jumlahBayar` int(10) DEFAULT NULL,
  `ketBayar` varchar(100) DEFAULT NULL,
  `caraBayar` enum('Tunai','Tabungan','Transfer Midtrans') DEFAULT 'Tunai',
  PRIMARY KEY (`idTagihanBebasBayar`),
  KEY `fkbayarbebas` (`idTagihanBebas`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;


INSERT INTO tagihan_bebas_bayar VALUES
("70","18","2022-09-16","100000","Lunas","Tunai");




CREATE TABLE `tagihan_bulanan` (
  `idTagihanBulanan` int(50) NOT NULL AUTO_INCREMENT,
  `idJenisBayar` int(5) DEFAULT NULL,
  `idSiswa` int(10) DEFAULT NULL,
  `idKelas` int(5) DEFAULT NULL,
  `idBulan` varchar(15) DEFAULT NULL,
  `jumlahBayar` int(10) DEFAULT NULL,
  `tglBayar` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `tglUpdate` datetime DEFAULT NULL ON UPDATE current_timestamp(),
  `inv` varchar(100) NOT NULL,
  `statusBayar` enum('0','1','2') DEFAULT '0',
  `caraBayar` enum('Tunai','Tabungan','Transfer Midtrans') DEFAULT 'Tunai',
  PRIMARY KEY (`idTagihanBulanan`),
  KEY `fk_t_jenis` (`idJenisBayar`),
  KEY `fk_t_siswa` (`idSiswa`),
  KEY `fk_t_kelas` (`idKelas`),
  KEY `fk_t_bulan` (`idBulan`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;


INSERT INTO tagihan_bulanan VALUES
("1","73","41","1","1","900000","","","","0","Tunai"),
("2","73","41","1","2","900000","","","","0","Tunai"),
("3","73","41","1","3","900000","","","","0","Tunai"),
("4","73","41","1","4","900000","","","","0","Tunai"),
("5","73","41","1","5","900000","","","","0","Tunai"),
("6","73","41","1","6","900000","","","","0","Tunai"),
("7","73","41","1","7","900000","2022-08-30 20:27:46","2022-08-30 20:27:44","","1","Tunai"),
("8","73","41","1","8","900000","2022-09-13 10:21:41","2022-09-13 10:21:36","","1","Tunai"),
("9","73","41","1","9","900000","2022-09-13 10:24:04","2022-09-13 10:23:57","","1","Tunai"),
("10","73","41","1","10","900000","2022-09-13 11:59:03","2022-09-13 11:58:31","","1","Tabungan"),
("11","73","41","1","11","900000","","","","0","Tunai"),
("12","73","41","1","12","900000","","","","0","Tunai"),
("13","73","43","1","1","900000","","","","0","Tunai"),
("14","73","43","1","2","900000","","","","0","Tunai"),
("15","73","43","1","3","900000","","","","0","Tunai"),
("16","73","43","1","4","900000","","","","0","Tunai"),
("17","73","43","1","5","900000","","","","0","Tunai"),
("18","73","43","1","6","900000","","","","0","Tunai"),
("19","73","43","1","7","900000","","","","0","Tunai"),
("20","73","43","1","8","900000","","","","0","Tunai"),
("21","73","43","1","9","900000","","","","0","Tunai"),
("22","73","43","1","10","900000","","","","0","Tunai"),
("23","73","43","1","11","900000","","","","0","Tunai"),
("24","73","43","1","12","900000","","","","0","Tunai"),
("25","73","44","1","1","900000","","","","0","Tunai"),
("26","73","44","1","2","900000","","","","0","Tunai"),
("27","73","44","1","3","900000","","","","0","Tunai"),
("28","73","44","1","4","900000","","","","0","Tunai"),
("29","73","44","1","5","900000","","","","0","Tunai"),
("30","73","44","1","6","900000","","","","0","Tunai"),
("31","73","44","1","7","900000","","","","0","Tunai"),
("32","73","44","1","8","900000","","","","0","Tunai"),
("33","73","44","1","9","900000","","","","0","Tunai"),
("34","73","44","1","10","900000","","","","0","Tunai"),
("35","73","44","1","11","900000","","","","0","Tunai"),
("36","73","44","1","12","900000","","","","0","Tunai"),
("37","73","45","1","1","900000","","","","0","Tunai"),
("38","73","45","1","2","900000","","","","0","Tunai"),
("39","73","45","1","3","900000","","","","0","Tunai"),
("40","73","45","1","4","900000","","","","0","Tunai"),
("41","73","45","1","5","900000","","","","0","Tunai"),
("42","73","45","1","6","900000","","","","0","Tunai"),
("43","73","45","1","7","900000","","","","0","Tunai"),
("44","73","45","1","8","900000","","","","0","Tunai"),
("45","73","45","1","9","900000","","","","0","Tunai"),
("46","73","45","1","10","900000","","","","0","Tunai"),
("47","73","45","1","11","900000","","","","0","Tunai"),
("48","73","45","1","12","900000","","","","0","Tunai"),
("49","73","46","1","1","900000","","","","0","Tunai"),
("50","73","46","1","2","900000","","","","0","Tunai"),
("51","73","46","1","3","900000","","","","0","Tunai"),
("52","73","46","1","4","900000","","","","0","Tunai"),
("53","73","46","1","5","900000","","","","0","Tunai"),
("54","73","46","1","6","900000","","","","0","Tunai"),
("55","73","46","1","7","900000","","","","0","Tunai"),
("56","73","46","1","8","900000","","","","0","Tunai"),
("57","73","46","1","9","900000","","","","0","Tunai"),
("58","73","46","1","10","900000","","","","0","Tunai"),
("59","73","46","1","11","900000","","","","0","Tunai"),
("60","73","46","1","12","900000","","","","0","Tunai"),
("61","73","176","1","1","900000","","","","0","Tunai"),
("62","73","176","1","2","900000","","","","0","Tunai"),
("63","73","176","1","3","900000","","","","0","Tunai"),
("64","73","176","1","4","900000","","","","0","Tunai"),
("65","73","176","1","5","900000","","","","0","Tunai"),
("66","73","176","1","6","900000","","","","0","Tunai"),
("67","73","176","1","7","900000","","","","0","Tunai"),
("68","73","176","1","8","900000","","","","0","Tunai"),
("69","73","176","1","9","900000","","","","0","Tunai"),
("70","73","176","1","10","900000","","","","0","Tunai"),
("71","73","176","1","11","900000","","","","0","Tunai"),
("72","73","176","1","12","900000","","","","0","Tunai");




CREATE TABLE `tahun_ajaran` (
  `idTahunAjaran` int(5) NOT NULL AUTO_INCREMENT,
  `nmTahunAjaran` varchar(9) DEFAULT NULL,
  `ket` varchar(200) NOT NULL,
  `aktif` enum('Y','T') DEFAULT 'Y',
  PRIMARY KEY (`idTahunAjaran`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;


INSERT INTO tahun_ajaran VALUES
("11","2021/2022","","T"),
("12","2022/2023","0","T"),
("13","2020/2021","Semester Ganjil","Y");




CREATE TABLE `transaksi` (
  `id_transaksi` varchar(50) NOT NULL,
  `nisnSiswa` varchar(50) NOT NULL,
  `tanggal` date NOT NULL,
  `debit` int(10) NOT NULL,
  `kredit` int(10) NOT NULL,
  `keterangan` varchar(50) NOT NULL,
  PRIMARY KEY (`id_transaksi`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO transaksi VALUES
("","20190002","2022-08-18","0","900000","Pembayaran Bulanan"),
("T0002","20190002","2022-08-01","90000","0",""),
("T0001","20190002","2022-08-01","100000","0",""),
("T0003","20190002","2022-09-13","0","900000","Pembayaran Bulanan");




CREATE TABLE `users` (
  `username` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `password` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `nama_lengkap` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `email` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `no_telp` varchar(20) COLLATE latin1_general_ci NOT NULL,
  `level` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT 'admin',
  `blokir` enum('Y','N') COLLATE latin1_general_ci NOT NULL DEFAULT 'N',
  `idKelas` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `fotoUser` varchar(255) COLLATE latin1_general_ci NOT NULL,
  `id_session` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `last_login` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;


INSERT INTO users VALUES
("admin","0192023a7bbd73250516f069df18b500","Rivani Noer MAulidi","theivhan@gmail.com","0852330726611","admin","N","","Logo.png","vgjkducma2cld9dq2a7ahg5f04","2022-09-16 11:11:05"),
("adminjuraganpay","202cb962ac59075b964b07152d234b70","Rivani Coysd","theivhan@gmail.com","68233072661","bendahara","N","","Harlah NU.png","","2022-09-13 13:13:09"),
("kepsek","8561863b55faf85b9ad67c52b3b851ac","Kepseks","theivhan@gmail.com","6282142484235","kepsek","N","","download.png","","2022-02-04 11:07:41");




CREATE TABLE `users_hak_akses` (
  `idHakAkses` int(11) NOT NULL AUTO_INCREMENT,
  `IdUsersLevel` int(11) NOT NULL,
  `idMenu` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`idHakAkses`)
) ENGINE=InnoDB AUTO_INCREMENT=130 DEFAULT CHARSET=latin1;


INSERT INTO users_hak_akses VALUES
("1","1","1"),
("2","1","51"),
("3","1","52"),
("4","1","53"),
("5","1","54"),
("6","1","55"),
("7","1","56"),
("8","1","57"),
("9","1","17"),
("10","1","18"),
("11","1","19"),
("12","1","20"),
("13","1","21"),
("14","1","22"),
("18","1","2"),
("19","1","3"),
("20","1","4"),
("21","1","5"),
("22","1","6"),
("23","1","7"),
("24","1","8"),
("25","1","9"),
("26","1","10"),
("27","1","11"),
("28","1","12"),
("29","1","13"),
("30","1","14"),
("31","1","15"),
("32","1","16"),
("33","1","23"),
("34","1","24"),
("35","1","25"),
("36","1","26"),
("37","1","27"),
("38","1","28"),
("39","1","29"),
("40","1","30"),
("41","1","31"),
("42","1","32"),
("43","1","33"),
("44","1","34"),
("45","1","35"),
("46","1","36"),
("47","1","37"),
("48","1","38"),
("49","1","39"),
("50","1","40"),
("51","1","41"),
("52","1","42"),
("53","1","43"),
("54","1","44"),
("55","1","45"),
("56","1","46"),
("57","1","47"),
("58","1","48"),
("59","1","49"),
("60","1","50"),
("63","8","2"),
("65","8","4"),
("67","8","6"),
("69","8","10"),
("70","8","11"),
("71","8","12"),
("72","8","13"),
("75","8","14"),
("76","8","15"),
("77","8","16"),
("78","8","17"),
("79","8","18"),
("80","8","19"),
("81","8","20"),
("82","8","21"),
("83","8","22"),
("84","8","23"),
("85","8","24"),
("86","8","25"),
("87","8","26"),
("88","8","27"),
("89","8","28"),
("90","8","29"),
("91","8","30"),
("92","8","31"),
("93","8","32"),
("94","8","33"),
("95","8","34"),
("96","8","36"),
("97","8","35"),
("98","8","37"),
("99","8","38"),
("100","8","39"),
("101","8","40"),
("102","8","41"),
("103","8","42"),
("104","8","43"),
("105","8","46"),
("106","8","45"),
("107","8","44"),
("108","8","47"),
("109","8","48"),
("110","8","49");
INSERT INTO users_hak_akses VALUES
("111","8","50"),
("113","8","1"),
("115","1","61"),
("116","1","62"),
("117","1","63"),
("118","1","64"),
("119","1","65"),
("120","1","66"),
("121","8","51"),
("122","8","52"),
("123","8","53"),
("124","8","54"),
("125","8","55"),
("126","8","56"),
("127","8","57"),
("128","1","67"),
("129","0","");




CREATE TABLE `users_level` (
  `idUsersLevel` int(11) NOT NULL AUTO_INCREMENT,
  `namaUsersLevel` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`idUsersLevel`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;


INSERT INTO users_level VALUES
("1","ADMIN"),
("2","KONSELING"),
("3","KESEHATAN"),
("4","AKADEMIK"),
("5","KESISWAAN"),
("6","TATA USAHA"),
("7","GURU"),
("8","KEUANGAN"),
("9","KASIR");




CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_detil_jenis_bayar` AS select `jenis_bayar`.`idJenisBayar` AS `idJenisBayar`,`jenis_bayar`.`idPosBayar` AS `idPosBayar`,`jenis_bayar`.`idTahunAjaran` AS `idTahunAjaran`,`jenis_bayar`.`nmJenisBayar` AS `nmJenisBayar`,`jenis_bayar`.`tipeBayar` AS `tipeBayar`,`pos_bayar`.`nmPosBayar` AS `nmPosBayar`,`tahun_ajaran`.`nmTahunAjaran` AS `nmTahunAjaran`,`tahun_ajaran`.`aktif` AS `aktif` from ((`jenis_bayar` join `pos_bayar` on(`jenis_bayar`.`idPosBayar` = `pos_bayar`.`idPosBayar`)) join `tahun_ajaran` on(`jenis_bayar`.`idTahunAjaran` = `tahun_ajaran`.`idTahunAjaran`));






CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_detil_siswa` AS select `siswa`.`idSiswa` AS `idSiswa`,`siswa`.`nisSiswa` AS `nisSiswa`,`siswa`.`nisnSiswa` AS `nisnSiswa`,`siswa`.`nmSiswa` AS `nmSiswa`,`siswa`.`jkSiswa` AS `jkSiswa`,`siswa`.`agamaSiswa` AS `agamaSiswa`,`siswa`.`tglLahirSiswa` AS `tglLahirSiswa`,`siswa`.`tmptLahir` AS `tmptLahir`,`siswa`.`idKelas` AS `idKelas`,`siswa`.`statusSiswa` AS `statusSiswa`,`kelas_siswa`.`nmKelas` AS `nmKelas`,`kelas_siswa`.`ketKelas` AS `ketKelas`,`siswa`.`nmOrtu` AS `nmOrtu`,`siswa`.`alamatOrtu` AS `alamatOrtu`,`siswa`.`noHpOrtu` AS `noHpOrtu`,`siswa`.`noHpSis` AS `noHpSis`,`siswa`.`saldo` AS `saldo`,`siswa`.`username` AS `username`,`siswa`.`password` AS `password`,`siswa`.`level` AS `level`,`siswa`.`statusKeluarga` AS `statusKeluarga`,`siswa`.`anakKe` AS `anakKe`,`siswa`.`sekolah` AS `sekolah`,`siswa`.`nmOrtuIbu` AS `nmOrtuIbu`,`siswa`.`foto` AS `foto` from (`siswa` join `kelas_siswa` on(`siswa`.`idKelas` = `kelas_siswa`.`idKelas`));






CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_laporan_bayar_bulanan` AS select `tagihan_bulanan`.`idTagihanBulanan` AS `idTagihanBulanan`,`tagihan_bulanan`.`idJenisBayar` AS `idJenisBayar`,`tagihan_bulanan`.`idSiswa` AS `idSiswa`,`tagihan_bulanan`.`idKelas` AS `idKelas`,`tagihan_bulanan`.`idBulan` AS `idBulan`,`tagihan_bulanan`.`jumlahBayar` AS `jumlahBayar`,`tagihan_bulanan`.`tglBayar` AS `tglBayar`,`tagihan_bulanan`.`tglUpdate` AS `tglUpdate`,`tagihan_bulanan`.`statusBayar` AS `statusBayar`,`jenis_bayar`.`idTahunAjaran` AS `idTahunAjaran`,`jenis_bayar`.`nmJenisBayar` AS `nmJenisBayar`,`tahun_ajaran`.`nmTahunAjaran` AS `nmTahunAjaran`,`siswa`.`nisSiswa` AS `nisSiswa`,`siswa`.`nmSiswa` AS `nmSiswa`,`kelas_siswa`.`nmKelas` AS `nmKelas`,`bulan`.`nmBulan` AS `nmBulan`,`bulan`.`urutan` AS `urutan`,`tagihan_bulanan`.`caraBayar` AS `caraBayar` from (((((`tagihan_bulanan` join `jenis_bayar` on(`tagihan_bulanan`.`idJenisBayar` = `jenis_bayar`.`idJenisBayar`)) join `tahun_ajaran` on(`jenis_bayar`.`idTahunAjaran` = `tahun_ajaran`.`idTahunAjaran`)) join `siswa` on(`tagihan_bulanan`.`idSiswa` = `siswa`.`idSiswa`)) join `kelas_siswa` on(`siswa`.`idKelas` = `kelas_siswa`.`idKelas`)) join `bulan` on(`tagihan_bulanan`.`idBulan` = `bulan`.`idBulan`));




SET GLOBAL FOREIGN_KEY_CHECKS = 1;

/*!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 */;