-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 10 Jun 2022 pada 01.47
-- Versi server: 10.4.11-MariaDB
-- Versi PHP: 7.4.5

START TRANSACTION;



--
-- 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 `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);

--
-- 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 `skl`
--
ALTER TABLE `skl`
  ADD PRIMARY KEY (`id_skl`);

--
-- 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;
COMMIT;

