-- http://www.phpmyadmin.net
--




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

--
-- Table structure for table `benpel`
--

CREATE TABLE IF NOT EXISTS `benpel` (
  `c_benpel` varchar(10) NOT NULL,
  `c_katbenpel` varchar(10) NOT NULL,
  `benpel` text NOT NULL,
  `bobot` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `benpel`
--

INSERT INTO `benpel` (`c_benpel`, `c_katbenpel`, `benpel`, `bobot`) VALUES
('5XafCJsV5', 'b4tFXbsU5', 'Berkelahi dengan sekolahan lain', 100),
('cn7rgthJl', 'FSyln8F5q', 'Berkata Kotor Dengan Guru', 50),
('jODakRHnk', 'jGC4JtGo0', 'Memasukkan Baju (Siswa Putri)', 2),
('kmIn6bv43', 'jGC4JtGo0', 'Bertato', 20),
('M8yHhFw6o', 'b4tFXbsU5', 'Terbukti melakukan kejahatan', 50),
('o6zIRf55a', 'wE2hDSZ0H', 'Meninggalkan Kelas Tanpa Izin', 5),
('qlW4RnkLE', 'jGC4JtGo0', 'Tidak Memasukkan Baju (Siswa Putra)', 20),
('rkCV0Qegy', 'jGC4JtGo0', 'Berambut Gondrong (Siswa Putra)/dicat/diwarna', 2),
('UtkxKRhBu', 'wE2hDSZ0H', 'Tidak Mengikuti Pelajaran Tanpa Izin', 10),
('y1Xs82Iud', 'wE2hDSZ0H', 'Tidak Mengikuti Upacara', 5),
('yYuI3otvA', 'FSyln8F5q', 'Mengejek Guru', 10);

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

--
-- Table structure for table `chat`
--

CREATE TABLE IF NOT EXISTS `chat` (
`c_chat` int(11) NOT NULL,
  `c_guru` varchar(10) NOT NULL,
  `c_orangtua` varchar(10) NOT NULL,
  `pesan` text NOT NULL,
  `at` datetime NOT NULL,
  `w_g` varchar(1) NOT NULL,
  `sg` varchar(1) NOT NULL,
  `sw` varchar(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `chat`
--

INSERT INTO `chat` (`c_chat`, `c_guru`, `c_orangtua`, `pesan`, `at`, `w_g`, `sg`, `sw`) VALUES
(1, 'DPCcMKMey', 'tW6FuMey0', 'Assalamualaikum', '2017-11-28 18:49:28', 'w', 'y', 'y'),
(2, 'DPCcMKMey', 'tW6FuMey0', 'Bapak?', '2017-11-28 18:56:49', 'w', 'y', 'y'),
(3, 'DPCcMKMey', '0vEcBeBgF', 'Bismillah', '2017-11-28 19:00:36', 'g', 'y', 'y'),
(4, 'DPCcMKMey', 'tW6FuMey0', 'Iya', '2017-11-29 05:38:34', 'g', 'y', 'y'),
(5, 'DPCcMKMey', 'tW6FuMey0', 'Anak Saya tolong dibimbing ya bapak', '2017-11-29 05:47:55', 'w', 'y', 'y'),
(6, 'DPCcMKMey', 'tW6FuMey0', 'insya Allah bapak, kami selalu berusaha seperti itu, dan juga mohon untuk dibimbing dari pihak keluarga', '2017-11-29 05:59:08', 'g', 'y', 'y'),
(7, 'DPCcMKMey', 'tW6FuMey0', 'Terimakasih bapak', '2017-11-29 05:59:36', 'w', 'y', 'y'),
(8, 'DPCcMKMey', 'tW6FuMey0', 'sama sama', '2017-12-01 06:33:32', 'g', 'y', 'n'),
(9, 'G2sSiWyoD', 'supyLA8lg', 'contoh', '2017-12-13 09:07:33', 'g', 'y', 'n'),
(10, 'DPCcMKMey', '0vEcBeBgF', 'halo', '2024-07-18 11:20:38', 'g', 'y', 'y'),
(11, 'DPCcMKMey', '0vEcBeBgF', 'hh', '2024-07-18 11:22:15', 'g', 'y', 'y'),
(12, 'DPCcMKMey', '0vEcBeBgF', 'yom', '2024-07-18 11:24:53', 'g', 'y', 'y'),
(13, 'DPCcMKMey', '0vEcBeBgF', 'halo', '2024-07-18 11:26:32', 'w', 'y', 'y'),
(14, 'DPCcMKMey', '0vEcBeBgF', 'halo bapak', '2024-07-18 11:28:22', 'w', 'y', 'y'),
(15, 'DPCcMKMey', '0vEcBeBgF', 'halo bapak bekti', '2024-07-18 11:28:46', 'w', 'y', 'y'),
(16, 'DPCcMKMey', '0vEcBeBgF', 'halo', '2024-07-18 11:28:51', 'g', 'y', 'y');

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

--
-- Table structure for table `katbenpel`
--

CREATE TABLE IF NOT EXISTS `katbenpel` (
  `c_katbenpel` varchar(10) NOT NULL,
  `katbenpel` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `katbenpel`
--

INSERT INTO `katbenpel` (`c_katbenpel`, `katbenpel`) VALUES
('b4tFXbsU5', 'KEJAHATAN'),
('FSyln8F5q', 'KESOPANAN'),
('jGC4JtGo0', 'KERAPIAN'),
('wE2hDSZ0H', 'KERAJINAN');

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

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

CREATE TABLE IF NOT EXISTS `kelas` (
  `c_kelas` varchar(10) NOT NULL,
  `kelas` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `kelas` (`c_kelas`, `kelas`) VALUES
('bf14I0amf', 'X RPL'),
('fi5IJXCDs', 'X TKJ'),
('g20VX0r3h', 'X TKR'),
('NFVN6oSIZ', 'X TPL');

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

--
-- Table structure for table `pelanggaran`
--

CREATE TABLE IF NOT EXISTS `pelanggaran` (
  `c_pelanggaran` varchar(5) NOT NULL,
  `c_siswa` varchar(10) NOT NULL,
  `c_kelas` varchar(10) NOT NULL,
  `c_benpel` varchar(10) NOT NULL,
  `bobot` int(4) NOT NULL,
  `c_guru` varchar(10) NOT NULL,
  `at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pelanggaran`
--

INSERT INTO `pelanggaran` (`c_pelanggaran`, `c_siswa`, `c_kelas`, `c_benpel`, `bobot`, `c_guru`, `at`) VALUES
('0qib', 'aYlxwzZu6', 'fi5IJXCDs', 'qlW4RnkLE', 20, 'DPCcMKMey', '2017-12-01 06:10:55'),
('0vnB', 'I73vNKyU9', 'fi5IJXCDs', 'UtkxKRhBu', 10, 'DPCcMKMey', '2017-11-29 08:48:16'),
('46kg', 'ukxWhAq84', 'bf14I0amf', 'o6zIRf55a', 5, 'G2sSiWyoD', '2017-11-28 11:34:54'),
('6mR4', '9sgiPEKLX', 'g20VX0r3h', 'yYuI3otvA', 10, 'DPCcMKMey', '2017-12-01 06:18:42'),
('9', 'XKHcfzVUR', 'fi5IJXCDs', 'qlW4RnkLE', 20, 'G2sSiWyoD', '2017-11-25 14:55:26'),
('AqI1', 'ukxWhAq84', 'bf14I0amf', 'qlW4RnkLE', 20, 'Ztknli361', '2017-12-01 06:02:29'),
('c11k', 'I73vNKyU9', 'fi5IJXCDs', 'y1Xs82Iud', 5, 'DPCcMKMey', '2017-11-29 08:36:36'),
('F6kZ', 'ukxWhAq84', 'bf14I0amf', 'UtkxKRhBu', 10, 'G2sSiWyoD', '2017-11-28 11:34:54'),
('FGWR', 'I73vNKyU9', 'fi5IJXCDs', 'rkCV0Qegy', 2, 'DPCcMKMey', '2024-07-18 11:14:03'),
('g9zH', '9sgiPEKLX', 'g20VX0r3h', 'qlW4RnkLE', 20, 'DPCcMKMey', '2017-12-01 06:18:42'),
('GnvK', 'unCWwBalF', 'bf14I0amf', 'o6zIRf55a', 5, 'G2sSiWyoD', '2017-12-13 09:09:54'),
('hA6I', 'I73vNKyU9', 'fi5IJXCDs', 'cn7rgthJl', 50, 'DPCcMKMey', '2017-12-01 06:16:59'),
('hLD0', '9sgiPEKLX', 'g20VX0r3h', 'y1Xs82Iud', 5, 'Ztknli361', '2017-12-02 08:58:38'),
('mfQQ', 'ukxWhAq84', 'bf14I0amf', 'o6zIRf55a', 5, 'G2sSiWyoD', '2017-12-13 09:09:54'),
('PxW7', 'NJOgsxL8z', 'bf14I0amf', 'cn7rgthJl', 50, 'G2sSiWyoD', '2017-11-27 06:26:59'),
('sNGD', 'AKbptUszm', 'g20VX0r3h', 'kmIn6bv43', 20, 'Ztknli361', '2017-12-01 05:56:49'),
('vy67', 'XKHcfzVUR', 'fi5IJXCDs', 'rkCV0Qegy', 2, 'DPCcMKMey', '2024-07-18 11:14:03'),
('y7Et', 'ukxWhAq84', 'bf14I0amf', 'qlW4RnkLE', 20, 'DPCcMKMey', '2017-11-28 18:47:52');

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

--
-- Table structure for table `relasichat`
--

CREATE TABLE IF NOT EXISTS `relasichat` (
`c_chat` int(11) NOT NULL,
  `c_guru` varchar(10) NOT NULL,
  `c_orangtua` varchar(10) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `relasichat`
--

INSERT INTO `relasichat` (`c_chat`, `c_guru`, `c_orangtua`) VALUES
(5, 'DPCcMKMey', '0vEcBeBgF'),
(7, 'DPCcMKMey', 'tW6FuMey0'),
(8, 'G2sSiWyoD', 'supyLA8lg');

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

--
-- Table structure for table `sanksi`
--

CREATE TABLE IF NOT EXISTS `sanksi` (
  `c_sanksi` varchar(10) NOT NULL,
  `kriteria` varchar(30) NOT NULL,
  `bobot_dari` int(3) NOT NULL,
  `bobot_sampai` int(3) NOT NULL,
  `sanksi` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sanksi`
--

INSERT INTO `sanksi` (`c_sanksi`, `kriteria`, `bobot_dari`, `bobot_sampai`, `sanksi`) VALUES
('0DhOeINEy', 'Pelanggaran Ringan', 1, 5, '1. Peringatan Lesan<br>2. Dicatat dalam buku pelanggaran'),
('d3e8l5Jts', 'Pelanggaran Sedang', 6, 20, '1. Dicatat<br>2. Membuat Surat Pernyataan'),
('Sk8x467Qm', 'Pelanggaran Berat', 50, 100, '1. Diberikan Peringatan dan Surat Perjanjian<br>2. BIla Melanggar Kembali dikeluarkan dari sekolahan');

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

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

CREATE TABLE IF NOT EXISTS `siswa` (
  `c_siswa` varchar(10) NOT NULL,
  `c_kelas` varchar(10) NOT NULL,
  `nisn` varchar(20) NOT NULL,
  `nama` varchar(100) NOT NULL,
  `jk` varchar(1) NOT NULL,
  `alamat` varchar(150) NOT NULL,
  `tl` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `siswa` (`c_siswa`, `c_kelas`, `nisn`, `nama`, `jk`, `alamat`, `tl`) VALUES
('3mPRqCUvC', 'fi5IJXCDs', '45643646', 'Irfan Bachdim', '', '', '0000-00-00'),
('8XmoU43aM', 'g20VX0r3h', '989898898', 'M. Lionel Messi', 'P', 'Barcelona', '1998-10-22'),
('9sgiPEKLX', 'g20VX0r3h', '123456789', 'Muhammad Ali', 'L', '', '0000-00-00'),
('AKbptUszm', 'g20VX0r3h', '9980802501', 'Muhammad Irfan Sukoco Basyuri', 'L', '', '0000-00-00'),
('aYlxwzZu6', 'fi5IJXCDs', '4374734626', 'Michael Essien Woi', 'L', 'Nganjuk', '1998-11-05'),
('BNlJPHC33', 'bf14I0amf', '43544354', 'Muhammad Nur Hidayat', '', '', '0000-00-00'),
('djrCE5y6z', 'fi5IJXCDs', '46437437', 'Amalia Utami', '', '', '0000-00-00'),
('I73vNKyU9', 'fi5IJXCDs', '362362362', 'Febri Hariyadi', '', '', '0000-00-00'),
('iYDGaCQDM', 'g20VX0r3h', '123123123', 'Khusnul Yuliansyah Putra', 'L', 'Baron', '1998-10-15'),
('j1gD4Sei6', 'g20VX0r3h', '39090909090', 'Diva Anggraini', 'P', 'Nganjuk', '1998-05-16'),
('NJOgsxL8z', 'bf14I0amf', '465437345', 'Muhammad Rizky Ridho', '', '', '0000-00-00'),
('ukxWhAq84', 'bf14I0amf', '46346436436', 'Evan Dimas Darmono', 'L', 'Surabaya', '1997-10-18'),
('unCWwBalF', 'bf14I0amf', '35326436436', 'M. Ronaldo', '', '', '0000-00-00'),
('XKHcfzVUR', 'fi5IJXCDs', '46436437437', 'Alvaro Morata', 'L', 'Lengkong', '1999-03-20');

--
-- Indexes for table `benpel`
--
ALTER TABLE `benpel`
 ADD PRIMARY KEY (`c_benpel`);

--
-- Indexes for table `chat`
--
ALTER TABLE `chat`
 ADD PRIMARY KEY (`c_chat`);

--
-- Indexes for table `katbenpel`
--
ALTER TABLE `katbenpel`
 ADD PRIMARY KEY (`c_katbenpel`);

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

--
-- Indexes for table `pelanggaran`
--
ALTER TABLE `pelanggaran`
 ADD PRIMARY KEY (`c_pelanggaran`);

--
-- Indexes for table `relasichat`
--
ALTER TABLE `relasichat`
 ADD PRIMARY KEY (`c_chat`);

--
-- Indexes for table `sanksi`
--
ALTER TABLE `sanksi`
 ADD PRIMARY KEY (`c_sanksi`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `chat`
--
ALTER TABLE `chat`
MODIFY `c_chat` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `relasichat`
--
ALTER TABLE `relasichat`
MODIFY `c_chat` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
