-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 10 Jun 2022 pada 01.47
-- Versi server: 10.4.11-MariaDB
-- Versi PHP: 7.4.5

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

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

--
-- Struktur dari tabel `kelompok`
--

CREATE TABLE `kelompok` (
  `id_kelompok` varchar(2) NOT NULL,
  `nama_kelompok` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Struktur dari tabel `log`
--

CREATE TABLE `log` (
  `id_log` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `type` int(1) NOT NULL,
  `log` varchar(50) NOT NULL,
  `tgl` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `log`
--

INSERT INTO `log` (`id_log`, `id_user`, `type`, `log`, `tgl`) VALUES
(4, 1, 1, 'Membuka amplop kelulusan', '2020-04-27 08:00:53'),
(5, 3, 1, 'Membuka amplop kelulusan', '2022-06-07 17:30:13'),
(6, 2, 1, 'Membuka amplop kelulusan', '2022-06-09 20:50:15');

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

--
-- Struktur dari tabel `mapel`
--

CREATE TABLE `mapel` (
  `kode_mapel` varchar(50) NOT NULL,
  `nama_mapel` varchar(250) NOT NULL,
  `no_urut` int(2) NOT NULL,
  `kelompok` varchar(10) NOT NULL,
  `jurusan` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `mapel`
--

INSERT INTO `mapel` (`kode_mapel`, `nama_mapel`, `no_urut`, `kelompok`, `jurusan`) VALUES
('KODE1', 'MAPEL1', 1, 'A', 'semua'),
('KODE10', 'MAPEL10', 10, 'B', 'semua'),
('KODE11', 'MAPEL11', 11, 'B', 'semua'),
('KODE12', 'MAPEL12', 12, 'C', 'Teknik Komputer Jaringan'),
('KODE13', 'MAPEL13', 13, 'C', 'Teknik Komputer Jaringan'),
('KODE14', 'MAPEL14', 14, 'C', 'Teknik Komputer Jaringan'),
('KODE15', 'MAPEL15', 15, 'C', 'Teknik Komputer Jaringan'),
('KODE16', 'MAPEL16', 16, 'C', 'Teknik Pemesinan'),
('KODE17', 'MAPEL17', 17, 'C', 'Teknik Pemesinan'),
('KODE18', 'MAPEL18', 18, 'C', 'Teknik Pemesinan'),
('KODE19', 'MAPEL19', 19, 'C', 'Teknik Kendaraan Ringan'),
('KODE2', 'MAPEL2', 2, 'A', 'semua'),
('KODE20', 'MAPEL20', 20, 'C', 'Teknik Kendaraan Ringan'),
('KODE3', 'MAPEL3', 3, 'A', 'semua'),
('KODE4', 'MAPEL4', 4, 'A', 'semua'),
('KODE5', 'MAPEL5', 5, 'A', 'semua'),
('KODE6', 'MAPEL6', 6, 'A', 'semua'),
('KODE7', 'MAPEL7', 7, 'B', 'semua'),
('KODE8', 'MAPEL8', 8, 'B', 'semua'),
('KODE9', 'MAPEL9', 9, 'B', 'semua');

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

--
-- Struktur dari tabel `nilai`
--

CREATE TABLE `nilai` (
  `id_nilai` int(11) NOT NULL,
  `nis` varchar(50) NOT NULL,
  `kode_mapel` varchar(50) NOT NULL,
  `nilai` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `nilai`
--

INSERT INTO `nilai` (`id_nilai`, `nis`, `kode_mapel`, `nilai`) VALUES
(1, '171819001', 'KODE1', '70'),
(2, '171819002', 'KODE1', '71'),
(3, '171819003', 'KODE1', '72'),
(4, '171819004', 'KODE1', '73'),
(5, '171819005', 'KODE1', '74'),
(6, '171819006', 'KODE1', '75'),
(7, '171819007', 'KODE1', '76'),
(8, '171819008', 'KODE1', '77'),
(9, '171819009', 'KODE1', '78'),
(10, '171819010', 'KODE1', '79'),
(11, '171819011', 'KODE1', '80'),
(12, '171819012', 'KODE1', '81'),
(13, '171819013', 'KODE1', '82'),
(14, '171819014', 'KODE1', '83'),
(15, '171819015', 'KODE1', '84'),
(16, '171819016', 'KODE1', '85'),
(17, '171819017', 'KODE1', '86'),
(18, '171819018', 'KODE1', '87'),
(19, '171819019', 'KODE1', '88'),
(20, '171819020', 'KODE1', '89'),
(21, '171819001', 'KODE2', '60'),
(22, '171819002', 'KODE2', '61'),
(23, '171819003', 'KODE2', '62'),
(24, '171819004', 'KODE2', '63'),
(25, '171819005', 'KODE2', '64'),
(26, '171819006', 'KODE2', '65'),
(27, '171819007', 'KODE2', '66'),
(28, '171819008', 'KODE2', '67'),
(29, '171819009', 'KODE2', '68'),
(30, '171819010', 'KODE2', '69'),
(31, '171819011', 'KODE2', '70'),
(32, '171819012', 'KODE2', '71'),
(33, '171819013', 'KODE2', '72'),
(34, '171819014', 'KODE2', '73'),
(35, '171819015', 'KODE2', '74'),
(36, '171819016', 'KODE2', '75'),
(37, '171819017', 'KODE2', '76'),
(38, '171819018', 'KODE2', '77'),
(39, '171819019', 'KODE2', '78'),
(40, '171819020', 'KODE2', '79'),
(41, '171819001', 'KODE3', '65'),
(42, '171819002', 'KODE3', '66'),
(43, '171819003', 'KODE3', '67'),
(44, '171819004', 'KODE3', '68'),
(45, '171819005', 'KODE3', '69'),
(46, '171819006', 'KODE3', '70'),
(47, '171819007', 'KODE3', '71'),
(48, '171819008', 'KODE3', '72'),
(49, '171819009', 'KODE3', '73'),
(50, '171819010', 'KODE3', '74'),
(51, '171819011', 'KODE3', '75'),
(52, '171819012', 'KODE3', '76'),
(53, '171819013', 'KODE3', '77'),
(54, '171819014', 'KODE3', '78'),
(55, '171819015', 'KODE3', '79'),
(56, '171819016', 'KODE3', '80'),
(57, '171819017', 'KODE3', '81'),
(58, '171819018', 'KODE3', '82'),
(59, '171819019', 'KODE3', '83'),
(60, '171819020', 'KODE3', '84'),
(61, '171819001', 'KODE4', '70'),
(62, '171819002', 'KODE4', '71'),
(63, '171819003', 'KODE4', '72'),
(64, '171819004', 'KODE4', '73'),
(65, '171819005', 'KODE4', '74'),
(66, '171819006', 'KODE4', '75'),
(67, '171819007', 'KODE4', '76'),
(68, '171819008', 'KODE4', '77'),
(69, '171819009', 'KODE4', '78'),
(70, '171819010', 'KODE4', '79'),
(71, '171819011', 'KODE4', '80'),
(72, '171819012', 'KODE4', '81'),
(73, '171819013', 'KODE4', '82'),
(74, '171819014', 'KODE4', '83'),
(75, '171819015', 'KODE4', '84'),
(76, '171819016', 'KODE4', '85'),
(77, '171819017', 'KODE4', '86'),
(78, '171819018', 'KODE4', '87'),
(79, '171819019', 'KODE4', '88'),
(80, '171819020', 'KODE4', '89'),
(81, '171819001', 'KODE5', '60'),
(82, '171819002', 'KODE5', '61'),
(83, '171819003', 'KODE5', '62'),
(84, '171819004', 'KODE5', '63'),
(85, '171819005', 'KODE5', '64'),
(86, '171819006', 'KODE5', '65'),
(87, '171819007', 'KODE5', '66'),
(88, '171819008', 'KODE5', '67'),
(89, '171819009', 'KODE5', '68'),
(90, '171819010', 'KODE5', '69'),
(91, '171819011', 'KODE5', '70'),
(92, '171819012', 'KODE5', '71'),
(93, '171819013', 'KODE5', '72'),
(94, '171819014', 'KODE5', '73'),
(95, '171819015', 'KODE5', '74'),
(96, '171819016', 'KODE5', '75'),
(97, '171819017', 'KODE5', '76'),
(98, '171819018', 'KODE5', '77'),
(99, '171819019', 'KODE5', '78'),
(100, '171819020', 'KODE5', '79'),
(101, '171819001', 'KODE6', '65'),
(102, '171819002', 'KODE6', '66'),
(103, '171819003', 'KODE6', '67'),
(104, '171819004', 'KODE6', '68'),
(105, '171819005', 'KODE6', '69'),
(106, '171819006', 'KODE6', '70'),
(107, '171819007', 'KODE6', '71'),
(108, '171819008', 'KODE6', '72'),
(109, '171819009', 'KODE6', '73'),
(110, '171819010', 'KODE6', '74'),
(111, '171819011', 'KODE6', '75'),
(112, '171819012', 'KODE6', '76'),
(113, '171819013', 'KODE6', '77'),
(114, '171819014', 'KODE6', '78'),
(115, '171819015', 'KODE6', '79'),
(116, '171819016', 'KODE6', '80'),
(117, '171819017', 'KODE6', '81'),
(118, '171819018', 'KODE6', '82'),
(119, '171819019', 'KODE6', '83'),
(120, '171819020', 'KODE6', '84'),
(121, '171819001', 'KODE7', '70'),
(122, '171819002', 'KODE7', '71'),
(123, '171819003', 'KODE7', '72'),
(124, '171819004', 'KODE7', '73'),
(125, '171819005', 'KODE7', '74'),
(126, '171819006', 'KODE7', '75'),
(127, '171819007', 'KODE7', '76'),
(128, '171819008', 'KODE7', '77'),
(129, '171819009', 'KODE7', '78'),
(130, '171819010', 'KODE7', '79'),
(131, '171819011', 'KODE7', '80'),
(132, '171819012', 'KODE7', '81'),
(133, '171819013', 'KODE7', '82'),
(134, '171819014', 'KODE7', '83'),
(135, '171819015', 'KODE7', '84'),
(136, '171819016', 'KODE7', '85'),
(137, '171819017', 'KODE7', '86'),
(138, '171819018', 'KODE7', '87'),
(139, '171819019', 'KODE7', '88'),
(140, '171819020', 'KODE7', '89'),
(141, '171819001', 'KODE8', '60'),
(142, '171819002', 'KODE8', '61'),
(143, '171819003', 'KODE8', '62'),
(144, '171819004', 'KODE8', '63'),
(145, '171819005', 'KODE8', '64'),
(146, '171819006', 'KODE8', '65'),
(147, '171819007', 'KODE8', '66'),
(148, '171819008', 'KODE8', '67'),
(149, '171819009', 'KODE8', '68'),
(150, '171819010', 'KODE8', '69'),
(151, '171819011', 'KODE8', '70'),
(152, '171819012', 'KODE8', '71'),
(153, '171819013', 'KODE8', '72'),
(154, '171819014', 'KODE8', '73'),
(155, '171819015', 'KODE8', '74'),
(156, '171819016', 'KODE8', '75'),
(157, '171819017', 'KODE8', '76'),
(158, '171819018', 'KODE8', '77'),
(159, '171819019', 'KODE8', '78'),
(160, '171819020', 'KODE8', '79'),
(161, '171819001', 'KODE9', '65'),
(162, '171819002', 'KODE9', '66'),
(163, '171819003', 'KODE9', '67'),
(164, '171819004', 'KODE9', '68'),
(165, '171819005', 'KODE9', '69'),
(166, '171819006', 'KODE9', '70'),
(167, '171819007', 'KODE9', '71'),
(168, '171819008', 'KODE9', '72'),
(169, '171819009', 'KODE9', '73'),
(170, '171819010', 'KODE9', '74'),
(171, '171819011', 'KODE9', '75'),
(172, '171819012', 'KODE9', '76'),
(173, '171819013', 'KODE9', '77'),
(174, '171819014', 'KODE9', '78'),
(175, '171819015', 'KODE9', '79'),
(176, '171819016', 'KODE9', '80'),
(177, '171819017', 'KODE9', '81'),
(178, '171819018', 'KODE9', '82'),
(179, '171819019', 'KODE9', '83'),
(180, '171819020', 'KODE9', '84'),
(181, '171819001', 'KODE10', '70'),
(182, '171819002', 'KODE10', '71'),
(183, '171819003', 'KODE10', '72'),
(184, '171819004', 'KODE10', '73'),
(185, '171819005', 'KODE10', '74'),
(186, '171819006', 'KODE10', '75'),
(187, '171819007', 'KODE10', '76'),
(188, '171819008', 'KODE10', '77'),
(189, '171819009', 'KODE10', '78'),
(190, '171819010', 'KODE10', '79'),
(191, '171819011', 'KODE10', '80'),
(192, '171819012', 'KODE10', '81'),
(193, '171819013', 'KODE10', '82'),
(194, '171819014', 'KODE10', '83'),
(195, '171819015', 'KODE10', '84'),
(196, '171819016', 'KODE10', '85'),
(197, '171819017', 'KODE10', '86'),
(198, '171819018', 'KODE10', '87'),
(199, '171819019', 'KODE10', '88'),
(200, '171819020', 'KODE10', '89'),
(201, '171819001', 'KODE11', '60'),
(202, '171819002', 'KODE11', '61'),
(203, '171819003', 'KODE11', '62'),
(204, '171819004', 'KODE11', '63'),
(205, '171819005', 'KODE11', '64'),
(206, '171819006', 'KODE11', '65'),
(207, '171819007', 'KODE11', '66'),
(208, '171819008', 'KODE11', '67'),
(209, '171819009', 'KODE11', '68'),
(210, '171819010', 'KODE11', '69'),
(211, '171819011', 'KODE11', '70'),
(212, '171819012', 'KODE11', '71'),
(213, '171819013', 'KODE11', '72'),
(214, '171819014', 'KODE11', '73'),
(215, '171819015', 'KODE11', '74'),
(216, '171819016', 'KODE11', '75'),
(217, '171819017', 'KODE11', '76'),
(218, '171819018', 'KODE11', '77'),
(219, '171819019', 'KODE11', '78'),
(220, '171819020', 'KODE11', '79'),
(221, '171819001', 'KODE12', '65'),
(222, '171819002', 'KODE12', '66'),
(223, '171819003', 'KODE12', '67'),
(224, '171819004', 'KODE12', '68'),
(225, '171819005', 'KODE12', '69'),
(226, '171819006', 'KODE12', '70'),
(227, '171819007', 'KODE12', '71'),
(228, '171819008', 'KODE12', '72'),
(229, '171819009', 'KODE12', '73'),
(230, '171819010', 'KODE12', '74'),
(231, '171819011', 'KODE12', '75'),
(232, '171819012', 'KODE12', '76'),
(233, '171819013', 'KODE12', '77'),
(234, '171819014', 'KODE12', '78'),
(235, '171819015', 'KODE12', '79'),
(236, '171819016', 'KODE12', '80'),
(237, '171819017', 'KODE12', '81'),
(238, '171819018', 'KODE12', '82'),
(239, '171819019', 'KODE12', '83'),
(240, '171819020', 'KODE12', '84'),
(241, '171819001', 'KODE13', '70'),
(242, '171819002', 'KODE13', '71'),
(243, '171819003', 'KODE13', '72'),
(244, '171819004', 'KODE13', '73'),
(245, '171819005', 'KODE13', '74'),
(246, '171819006', 'KODE13', '75'),
(247, '171819007', 'KODE13', '76'),
(248, '171819008', 'KODE13', '77'),
(249, '171819009', 'KODE13', '78'),
(250, '171819010', 'KODE13', '79'),
(251, '171819011', 'KODE13', '80'),
(252, '171819012', 'KODE13', '81'),
(253, '171819013', 'KODE13', '82'),
(254, '171819014', 'KODE13', '83'),
(255, '171819015', 'KODE13', '84'),
(256, '171819016', 'KODE13', '85'),
(257, '171819017', 'KODE13', '86'),
(258, '171819018', 'KODE13', '87'),
(259, '171819019', 'KODE13', '88'),
(260, '171819020', 'KODE13', '89'),
(261, '171819001', 'KODE14', '60'),
(262, '171819002', 'KODE14', '61'),
(263, '171819003', 'KODE14', '62'),
(264, '171819004', 'KODE14', '63'),
(265, '171819005', 'KODE14', '64'),
(266, '171819006', 'KODE14', '65'),
(267, '171819007', 'KODE14', '66'),
(268, '171819008', 'KODE14', '67'),
(269, '171819009', 'KODE14', '68'),
(270, '171819010', 'KODE14', '69'),
(271, '171819011', 'KODE14', '70'),
(272, '171819012', 'KODE14', '71'),
(273, '171819013', 'KODE14', '72'),
(274, '171819014', 'KODE14', '73'),
(275, '171819015', 'KODE14', '74'),
(276, '171819016', 'KODE14', '75'),
(277, '171819017', 'KODE14', '76'),
(278, '171819018', 'KODE14', '77'),
(279, '171819019', 'KODE14', '78'),
(280, '171819020', 'KODE14', '79'),
(281, '171819001', 'KODE15', '65'),
(282, '171819002', 'KODE15', '66'),
(283, '171819003', 'KODE15', '67'),
(284, '171819004', 'KODE15', '68'),
(285, '171819005', 'KODE15', '69'),
(286, '171819006', 'KODE15', '70'),
(287, '171819007', 'KODE15', '71'),
(288, '171819008', 'KODE15', '72'),
(289, '171819009', 'KODE15', '73'),
(290, '171819010', 'KODE15', '74'),
(291, '171819011', 'KODE15', '75'),
(292, '171819012', 'KODE15', '76'),
(293, '171819013', 'KODE15', '77'),
(294, '171819014', 'KODE15', '78'),
(295, '171819015', 'KODE15', '79'),
(296, '171819016', 'KODE15', '80'),
(297, '171819017', 'KODE15', '81'),
(298, '171819018', 'KODE15', '82'),
(299, '171819019', 'KODE15', '83'),
(300, '171819020', 'KODE15', '84'),
(301, '171819001', 'KODE16', '70'),
(302, '171819002', 'KODE16', '71'),
(303, '171819003', 'KODE16', '72'),
(304, '171819004', 'KODE16', '73'),
(305, '171819005', 'KODE16', '74'),
(306, '171819006', 'KODE16', '75'),
(307, '171819007', 'KODE16', '76'),
(308, '171819008', 'KODE16', '77'),
(309, '171819009', 'KODE16', '78'),
(310, '171819010', 'KODE16', '79'),
(311, '171819011', 'KODE16', '80'),
(312, '171819012', 'KODE16', '81'),
(313, '171819013', 'KODE16', '82'),
(314, '171819014', 'KODE16', '83'),
(315, '171819015', 'KODE16', '84'),
(316, '171819016', 'KODE16', '85'),
(317, '171819017', 'KODE16', '86'),
(318, '171819018', 'KODE16', '87'),
(319, '171819019', 'KODE16', '88'),
(320, '171819020', 'KODE16', '89'),
(321, '171819001', 'KODE17', '60'),
(322, '171819002', 'KODE17', '61'),
(323, '171819003', 'KODE17', '62'),
(324, '171819004', 'KODE17', '63'),
(325, '171819005', 'KODE17', '64'),
(326, '171819006', 'KODE17', '65'),
(327, '171819007', 'KODE17', '66'),
(328, '171819008', 'KODE17', '67'),
(329, '171819009', 'KODE17', '68'),
(330, '171819010', 'KODE17', '69'),
(331, '171819011', 'KODE17', '70'),
(332, '171819012', 'KODE17', '71'),
(333, '171819013', 'KODE17', '72'),
(334, '171819014', 'KODE17', '73'),
(335, '171819015', 'KODE17', '74'),
(336, '171819016', 'KODE17', '75'),
(337, '171819017', 'KODE17', '76'),
(338, '171819018', 'KODE17', '77'),
(339, '171819019', 'KODE17', '78'),
(340, '171819020', 'KODE17', '79'),
(341, '171819001', 'KODE18', '65'),
(342, '171819002', 'KODE18', '66'),
(343, '171819003', 'KODE18', '67'),
(344, '171819004', 'KODE18', '68'),
(345, '171819005', 'KODE18', '69'),
(346, '171819006', 'KODE18', '70'),
(347, '171819007', 'KODE18', '71'),
(348, '171819008', 'KODE18', '72'),
(349, '171819009', 'KODE18', '73'),
(350, '171819010', 'KODE18', '74'),
(351, '171819011', 'KODE18', '75'),
(352, '171819012', 'KODE18', '76'),
(353, '171819013', 'KODE18', '77'),
(354, '171819014', 'KODE18', '78'),
(355, '171819015', 'KODE18', '79'),
(356, '171819016', 'KODE18', '80'),
(357, '171819017', 'KODE18', '81'),
(358, '171819018', 'KODE18', '82'),
(359, '171819019', 'KODE18', '83'),
(360, '171819020', 'KODE18', '84'),
(361, '171819001', 'KODE19', '60'),
(362, '171819002', 'KODE19', '61'),
(363, '171819003', 'KODE19', '62'),
(364, '171819004', 'KODE19', '63'),
(365, '171819005', 'KODE19', '64'),
(366, '171819006', 'KODE19', '65'),
(367, '171819007', 'KODE19', '66'),
(368, '171819008', 'KODE19', '67'),
(369, '171819009', 'KODE19', '68'),
(370, '171819010', 'KODE19', '69'),
(371, '171819011', 'KODE19', '70'),
(372, '171819012', 'KODE19', '71'),
(373, '171819013', 'KODE19', '72'),
(374, '171819014', 'KODE19', '73'),
(375, '171819015', 'KODE19', '74'),
(376, '171819016', 'KODE19', '75'),
(377, '171819017', 'KODE19', '76'),
(378, '171819018', 'KODE19', '77'),
(379, '171819019', 'KODE19', '78'),
(380, '171819020', 'KODE19', '79'),
(381, '171819001', 'KODE20', '65'),
(382, '171819002', 'KODE20', '66'),
(383, '171819003', 'KODE20', '67'),
(384, '171819004', 'KODE20', '68'),
(385, '171819005', 'KODE20', '69'),
(386, '171819006', 'KODE20', '70'),
(387, '171819007', 'KODE20', '71'),
(388, '171819008', 'KODE20', '72'),
(389, '171819009', 'KODE20', '73'),
(390, '171819010', 'KODE20', '74'),
(391, '171819011', 'KODE20', '75'),
(392, '171819012', 'KODE20', '76'),
(393, '171819013', 'KODE20', '77'),
(394, '171819014', 'KODE20', '78'),
(395, '171819015', 'KODE20', '79'),
(396, '171819016', 'KODE20', '80'),
(397, '171819017', 'KODE20', '81'),
(398, '171819018', 'KODE20', '82'),
(399, '171819019', 'KODE20', '83'),
(400, '171819020', 'KODE20', '84');

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

--
-- Struktur dari tabel `pengumuman`
--

CREATE TABLE `pengumuman` (
  `id_pengumuman` int(11) NOT NULL,
  `id_user` int(11) NOT NULL,
  `judul` varchar(255) DEFAULT NULL,
  `pengumuman` text DEFAULT NULL,
  `tgl` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `jenis` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `pengumuman`
--

INSERT INTO `pengumuman` (`id_pengumuman`, `id_user`, `judul`, `pengumuman`, `tgl`, `jenis`) VALUES
(2, 3, 'SURAT SKL', '<p>Untuk pengambilan Surat Keterangan Lulus (SKL) bisa diambil disekolah mulai hari Rabu 15 Juni 2022</p>', '2022-06-08 11:42:41', 1);

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

--
-- Struktur dari tabel `setting`
--

CREATE TABLE `setting` (
  `id_setting` int(1) NOT NULL,
  `nama_sekolah` varchar(100) NOT NULL,
  `npsn` varchar(30) DEFAULT NULL,
  `nama_kepsek` varchar(50) DEFAULT NULL,
  `nip_kepsek` varchar(50) DEFAULT NULL,
  `alamat` varchar(255) DEFAULT NULL,
  `kota` varchar(30) DEFAULT NULL,
  `provinsi` varchar(30) DEFAULT NULL,
  `logo` varchar(50) DEFAULT NULL,
  `favicon` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `no_telp` varchar(50) DEFAULT NULL,
  `tgl_pengumuman` datetime DEFAULT NULL,
  `klikchat` text DEFAULT NULL,
  `livechat` text DEFAULT NULL,
  `nolivechat` varchar(50) DEFAULT NULL,
  `infobayar` text DEFAULT NULL,
  `syarat` text DEFAULT NULL,
  `banner` varchar(50) DEFAULT NULL,
  `login` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `setting`
--

INSERT INTO `setting` (`id_setting`, `nama_sekolah`, `npsn`, `nama_kepsek`, `nip_kepsek`, `alamat`, `kota`, `provinsi`, `logo`, `favicon`, `email`, `no_telp`, `tgl_pengumuman`, `klikchat`, `livechat`, `nolivechat`, `infobayar`, `syarat`, `banner`, `login`) VALUES
(1, 'SMP ISLAM TERPADU NURUL HUDA', '69993153', 'HENDRA, S.Ag.', '-', 'Dusun Sukasari RT 026 RW 011 Desa Margajaya Kecamatan Pamarican', 'Ciamis', NULL, 'assets/img/logo/logo898.png', NULL, NULL, NULL, '2022-06-15 07:58:00', '', '', '08986204405', NULL, NULL, 'assets/img/header/banner345.jpg', 1);

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

--
-- Struktur dari tabel `siswa`
--

CREATE TABLE `siswa` (
  `id` int(11) NOT NULL,
  `nama` varchar(50) NOT NULL,
  `nis` varchar(50) NOT NULL,
  `nisn` varchar(15) NOT NULL,
  `nopes` varchar(50) NOT NULL,
  `kelas` varchar(30) NOT NULL,
  `jurusan` varchar(100) NOT NULL,
  `tempat` varchar(50) NOT NULL,
  `tgl_lahir` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `keterangan` int(1) NOT NULL,
  `skl` varchar(100) DEFAULT NULL,
  `status` int(1) NOT NULL,
  `nohp` varchar(13) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `siswa`
--

INSERT INTO `siswa` (`id`, `nama`, `nis`, `nisn`, `nopes`, `kelas`, `jurusan`, `tempat`, `tgl_lahir`, `password`, `keterangan`, `skl`, `status`, `nohp`) VALUES
(1, 'NAMA 1', '171819001', '171819001', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 1', 'TANGGAL 1', 'ps001', 1, NULL, 1, ''),
(2, 'NAMA 2', '171819002', '171819002', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 2', 'TANGGAL 2', 'ps002', 1, NULL, 1, ''),
(3, 'NAMA 3', '171819003', '171819003', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 3', 'TANGGAL 3', 'ps003', 1, NULL, 1, ''),
(4, 'NAMA 4', '171819004', '171819004', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 4', 'TANGGAL 4', 'ps004', 1, NULL, 1, ''),
(5, 'NAMA 5', '171819005', '171819005', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 5', 'TANGGAL 5', 'ps005', 1, NULL, 1, ''),
(6, 'NAMA 6', '171819006', '171819006', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 6', 'TANGGAL 6', 'ps006', 1, NULL, 1, ''),
(7, 'NAMA 7', '171819007', '171819007', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 7', 'TANGGAL 7', 'ps007', 1, NULL, 1, ''),
(8, 'NAMA 8', '171819008', '171819008', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 8', 'TANGGAL 8', 'ps008', 1, NULL, 1, ''),
(9, 'NAMA 9', '171819009', '171819009', '', 'XIITKJ', 'Teknik Komputer Jaringan', 'TEMPAT 9', 'TANGGAL 9', 'ps009', 1, NULL, 1, ''),
(10, 'NAMA 10', '171819010', '171819010', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 10', 'TANGGAL 10', 'ps010', 1, NULL, 1, ''),
(11, 'NAMA 11', '171819011', '171819011', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 11', 'TANGGAL 11', 'ps011', 1, NULL, 1, ''),
(12, 'NAMA 12', '171819012', '171819012', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 12', 'TANGGAL 12', 'ps012', 1, NULL, 1, ''),
(13, 'NAMA 13', '171819013', '171819013', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 13', 'TANGGAL 13', 'ps013', 1, NULL, 1, ''),
(14, 'NAMA 14', '171819014', '171819014', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 14', 'TANGGAL 14', 'ps014', 1, NULL, 1, ''),
(15, 'NAMA 15', '171819015', '171819015', '', 'XIITP', 'Teknik Pemesinan', 'TEMPAT 15', 'TANGGAL 15', 'ps015', 1, NULL, 1, ''),
(16, 'NAMA 16', '171819016', '171819016', '', 'XIITKR', 'Teknik Kendaraan Ringan', 'TEMPAT 16', 'TANGGAL 16', 'ps016', 1, NULL, 1, ''),
(17, 'NAMA 17', '171819017', '171819017', '', 'XIITKR', 'Teknik Kendaraan Ringan', 'TEMPAT 17', 'TANGGAL 17', 'ps017', 1, NULL, 1, ''),
(18, 'NAMA 18', '171819018', '171819018', '', 'XIITKR', 'Teknik Kendaraan Ringan', 'TEMPAT 18', 'TANGGAL 18', 'ps018', 1, NULL, 1, ''),
(19, 'NAMA 19', '171819019', '171819019', '', 'XIITKR', 'Teknik Kendaraan Ringan', 'TEMPAT 19', 'TANGGAL 19', 'ps019', 1, NULL, 1, ''),
(20, 'NAMA 20', '171819020', '171819020', '', 'XIITKR', 'Teknik Kendaraan Ringan', 'TEMPAT 20', 'TANGGAL 20', 'ps020', 1, NULL, 1, '');

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

--
-- Struktur dari tabel `skl`
--

CREATE TABLE `skl` (
  `id_skl` int(11) NOT NULL,
  `no_surat` varchar(50) NOT NULL,
  `nama_surat` varchar(50) NOT NULL,
  `tgl_surat` varchar(50) NOT NULL,
  `header` text NOT NULL,
  `pembuka` text NOT NULL,
  `isi_surat` text NOT NULL,
  `penutup` text NOT NULL,
  `ttd` text NOT NULL,
  `stempel` text NOT NULL,
  `wttd` varchar(50) NOT NULL,
  `wstempel` varchar(50) NOT NULL,
  `sttd` int(1) NOT NULL,
  `sstempel` int(1) NOT NULL,
  `nilai` int(1) NOT NULL,
  `kelompok` int(1) NOT NULL,
  `nilaisiswa` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `skl`
--

INSERT INTO `skl` (`id_skl`, `no_surat`, `nama_surat`, `tgl_surat`, `header`, `pembuka`, `isi_surat`, `penutup`, `ttd`, `stempel`, `wttd`, `wstempel`, `sttd`, `sstempel`, `nilai`, `kelompok`, `nilaisiswa`) VALUES
(1, '001/SPOTIPOST/SKL/V/2021', 'SURAT KETERANGAN LULUS', '15 Juni 2022', 'assets/img/header/header357.jpg', '<p>Berdasarkan hasil Rapat Dewan Guru SPOTI POST SCHOOL tanggal 13 Juni 2022, Kepala SMP Spoti Post School Kabupaten Ciamis, dengan ini menerangkan bahwa :</p>', 'Bahwa nama yang tersebut diatas adalah benar Siswa/Siswi SPOTI POST SCHOOL&nbsp;dan telah melaksanakan Ujian Sekolah serta dinyatakan :', 'Demikian Surat Keterangan Lulus (SKL) ini dibuat dengan sebenarnya untuk dapat digunakan sebagaimana mestinya menjelang diterbitkannya ijazah yang bersangkutan.', 'assets/img/header/ttdskl819.png', 'assets/img/header/stempel919.png', '160', '100', 1, 1, 1, 1, 1);

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

--
-- Struktur dari tabel `user`
--

CREATE TABLE `user` (
  `id_user` int(11) NOT NULL,
  `nama_user` varchar(128) NOT NULL,
  `level` varchar(128) NOT NULL,
  `username` varchar(128) NOT NULL,
  `password` text NOT NULL,
  `status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`id_user`, `nama_user`, `level`, `username`, `password`, `status`) VALUES
(4, 'Administrator', 'admin', 'admin', '$2y$10$j5STRMVkhno25h93TJGDUupdr4L7CDEQQZCOwyFyqFO5QfCteP3H.', 1),
(6, 'AAM MASBIHIN', 'admin', 'administrator', '$2y$10$61TAEBVivT5uY9v3asbMlemjtYe1G3uo.ut2ADbc3KUZqjQu0AwG.', 1);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `kelompok`
--
ALTER TABLE `kelompok`
  ADD PRIMARY KEY (`id_kelompok`);

--
-- Indeks untuk tabel `log`
--
ALTER TABLE `log`
  ADD PRIMARY KEY (`id_log`);

--
-- Indeks untuk tabel `mapel`
--
ALTER TABLE `mapel`
  ADD PRIMARY KEY (`kode_mapel`);

--
-- Indeks untuk tabel `nilai`
--
ALTER TABLE `nilai`
  ADD PRIMARY KEY (`id_nilai`);

--
-- Indeks untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  ADD PRIMARY KEY (`id_pengumuman`);

--
-- Indeks untuk tabel `setting`
--
ALTER TABLE `setting`
  ADD PRIMARY KEY (`id_setting`);

--
-- Indeks untuk tabel `siswa`
--
ALTER TABLE `siswa`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `nis` (`nis`);

--
-- Indeks untuk tabel `skl`
--
ALTER TABLE `skl`
  ADD PRIMARY KEY (`id_skl`);

--
-- Indeks untuk tabel `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `log`
--
ALTER TABLE `log`
  MODIFY `id_log` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT untuk tabel `nilai`
--
ALTER TABLE `nilai`
  MODIFY `id_nilai` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=401;

--
-- AUTO_INCREMENT untuk tabel `pengumuman`
--
ALTER TABLE `pengumuman`
  MODIFY `id_pengumuman` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT untuk tabel `siswa`
--
ALTER TABLE `siswa`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT untuk tabel `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
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 */;