-- MySQL dump 10.19  Distrib 10.3.39-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: syinpewa_sipp
-- ------------------------------------------------------
-- Server version	10.3.39-MariaDB-cll-lve

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `pelanggaran`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pelanggaran` (
  `id_pelanggaran` int(11) NOT NULL AUTO_INCREMENT,
  `nama_pelanggaran` varchar(100) DEFAULT NULL,
  `jenis_pelanggaran` enum('ringan','sedang','berat') DEFAULT NULL,
  `poin` int(11) DEFAULT NULL,
  `kode_pelanggaran` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_pelanggaran`),
  KEY `id_pelanggaran` (`id_pelanggaran`),
  CONSTRAINT `pelanggaran_ibfk_1` FOREIGN KEY (`id_pelanggaran`) REFERENCES `pelanggaran` (`id_pelanggaran`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `pelanggaran` WRITE;
/*!40000 ALTER TABLE `pelanggaran` DISABLE KEYS */;
INSERT INTO `pelanggaran` VALUES (12,'Terlambat Masuk Kelas Lebih Dari 10 Menit','ringan',1,1),(21,'Terlambat Mengikuti Kegiatan Pagi Dan Kegiatan Upacara Hari Senin','ringan',1,2),(22,'Tidak Mengikuti Kegiatan Upacara Hari Senin','ringan',4,3),(23,'Tidak Mengikuti Kegiatan Apel Pagi Dan Sholat Dhuha','ringan',2,4),(24,'Tidak Mengikuti Kegiatan Sekolah/ Osis','ringan',2,5),(25,'Tidak Mengikuti Taruna ','berat',10,6),(26,'Colut','ringan',3,7),(27,'Tidak Mengikuti Ekstrakulikuler Wajib Tanpa Izin','ringan',5,8),(28,'Tidak Masuk Sekolah Tanpa Izin','sedang',5,9),(29,'Membawa Barang yang Tidak Sesuai Dengan Dunia Pendidikan dan Kepesantrenan','ringan',2,10),(30,'Membuka Sosmed dan Situs-Situs Web Tidak Sesuai Dunia Pendidikan','ringan',4,11),(31,'Membawa HP di Sekolah/ Pondok ','berat',10,12),(32,'Tidak Membawa Buku Pelajaran','ringan',2,13),(33,'Mencoret Tembok, Dinding, Meja dan Kursi','ringan',1,14),(34,'Bertindak Tidak Wajar/ Berkata Kasar Terhadap Teman','ringan',3,15),(35,'Berkhalwat Dengan Lawan Jenis Dsb','berat',15,16),(36,'Tidak Sopan/ Melawan Kepada Guru','sedang',5,17),(37,'Memalsukan Tanda Tangan Pada Surat Izin','sedang',6,18),(38,'Bulliying','berat',10,19),(39,'Berkelahi','sedang',5,20),(40,'Merusak Sarana dan Prasarana Sekolah','ringan',3,21),(41,'Ghosob','berat',10,22),(42,'Membawa Atau Mengonsusmi Nrkoba','berat',20,23),(43,'Merokok di Jam Sekolah','sedang',5,24),(44,'Terlibat Tindak Kriminal (Kepolisian)','berat',80,25),(45,'Menghilangkan Inventaris Sekolah','ringan',3,26),(46,'Tidak Lengkap (Seragam dan Atribut)','ringan',1,27),(47,'Memakai Sendal','ringan',2,28),(49,'Seragam Tidak Rapi','ringan',2,29),(51,'Memakai Aksesoris yang Tidak Sepantasnya','ringan',1,30),(52,'Bermake Up Secara Berlebihan','ringan',2,31),(53,'Cukuran Tidak Sesuai SOP Sekolah','ringan',2,32),(54,'Mencoret dan Menggambari Seragam Sekolah','ringan',2,33),(55,'Bertato, Semir Rambut, Giwang (Putra)','ringan',3,34);
/*!40000 ALTER TABLE `pelanggaran` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `riwayat_pelanggaran`
--

DROP TABLE IF EXISTS `riwayat_pelanggaran`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `riwayat_pelanggaran` (
  `id_riwayat` int(11) NOT NULL AUTO_INCREMENT,
  `nama` varchar(50) DEFAULT NULL,
  `tanggal_riw` date DEFAULT NULL,
  `nis` varchar(11) DEFAULT NULL,
  `kode_pl` int(11) DEFAULT NULL,
  `poin_plg` int(11) DEFAULT NULL,
  `kelas` enum('10','11','12') DEFAULT NULL,
  `jurusan` enum('PPLG','AKL') NOT NULL,
  PRIMARY KEY (`id_riwayat`),
  KEY `kode` (`kode_pl`) USING BTREE,
  KEY `nis` (`nis`) USING BTREE,
  KEY `fk_riwayat_siswa` (`nis`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `riwayat_pelanggaran`
--

LOCK TABLES `riwayat_pelanggaran` WRITE;
/*!40000 ALTER TABLE `riwayat_pelanggaran` DISABLE KEYS */;
INSERT INTO `riwayat_pelanggaran` VALUES (129,'Siti Aminah','2026-01-22','87654321',31,10,NULL,'PPLG'),(130,'Siti Aminah','2026-01-22','87654321',42,20,NULL,'PPLG'),(131,'Siti Aminah','2026-01-22','87654321',36,5,NULL,'PPLG'),(132,'aldo','2026-01-22','000923',47,2,NULL,'PPLG');
/*!40000 ALTER TABLE `riwayat_pelanggaran` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `rw_tebus`
--

DROP TABLE IF EXISTS `rw_tebus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rw_tebus` (
  `id_rwt` int(11) NOT NULL AUTO_INCREMENT,
  `nis` int(11) DEFAULT NULL,
  `nama` varchar(50) DEFAULT NULL,
  `tanggal` date DEFAULT NULL,
  `kode` int(11) DEFAULT NULL,
  `poin` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_rwt`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rw_tebus`
--

LOCK TABLES `rw_tebus` WRITE;
/*!40000 ALTER TABLE `rw_tebus` DISABLE KEYS */;
INSERT INTO `rw_tebus` VALUES (24,2147483647,'Atodz Hikam','2026-01-20',5,2),(25,87654321,'Siti Aminah','2026-01-20',2,5),(26,12345678,'Budi Sntya','2026-01-20',7,10),(27,923,'aldo','2026-01-22',1,3),(28,923,'aldo','2026-01-22',3,2);
/*!40000 ALTER TABLE `rw_tebus` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `siswa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `siswa` (
  `id_siswa` int(11) NOT NULL AUTO_INCREMENT,
  `foto` varchar(1000) NOT NULL,
  `nama_siswa` varchar(50) NOT NULL,
  `nis` varchar(11) DEFAULT NULL,
  `tanggal_lahir` date NOT NULL,
  `kelas` enum('10','11','12') NOT NULL,
  `jurusan` enum('AKL','PPLG') NOT NULL,
  `gender` enum('L','P') NOT NULL,
  `poin_sis` int(10) unsigned zerofill DEFAULT 0000000000,
  PRIMARY KEY (`id_siswa`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `siswa` WRITE;
/*!40000 ALTER TABLE `siswa` DISABLE KEYS */;
INSERT INTO `siswa` VALUES (43,'','Aufa Ihabi','333','2007-03-04','11','AKL','L',0000000000),(48,'','ABDILLAH AZIZ','2147483647','2006-08-01','11','AKL','L',0000000032),(49,'','ADIT TIYA','66587939','2006-10-27','12','AKL','L',0000000000),(57,'masjid.jpg','hg','122312','3232-03-12','12','PPLG','L',0000000000),(58,'20260119224625_logo-sigap-brown (1).png','Budi Ramadhan','123456','2001-03-12','10','AKL','P',0000000010),(59,'','AHDIYANA FATWANI MAULAFIA','12323','2020-01-19','11','PPLG','L',0000000000),(60,'','asdasd','0000012323','2026-01-19','12','PPLG','P',0000000019),(62,'Peace, Love, and Mouse Vibes.jpeg','Budi Sntya','12345678','0000-00-00','10','AKL','P',0000000005),(63,'z shinobu.jpeg','Siti Aminah','87654321','6764-05-04','12','AKL','P',0000000035),(64,'0000000987_Tian Huo.jpeg','Arep Rohman','0000000987','9876-02-12','11','AKL','P',0000000002),(65,'12340000000_1768892465.jpeg','AHMAD AKBAR TAUFIQ','12340000000','2026-01-20','12','AKL','L',0000000000),(66,'12312312321_1768892605.jpeg','asdasd','12312312321','2026-01-20','10','PPLG','P',0000000000),(67,'nophoto.jpg','asdasdsdqwewq','12435465765','3343-03-23','12','PPLG','L',0000000000),(68,'nophoto.jpg','Asatidzal Hakiim;12345678901;20/07/2026;12;PPLG;P','','0000-00-00','','','',0000000000),(69,'Franz Bonaparta - Klaus Poppe.jfif','Atodz Hikam','12345678234','2008-05-20','10','PPLG','L',0000000000),(70,'nophoto.jpg','NAJMA FARICHA','87623423321','2009-02-14','10','AKL','P',0000000000),(71,'98765432101_1768907626.jpg','Asatidzal Al Hakiim','98765432101','2007-12-21','12','PPLG','L',0000000000),(72,'17369802736_1768907964.jpg','Hakiim Asatidz','17369802736','2026-01-20','12','AKL','L',0000000000),(73,'003956_1768920323.jfif','Jln Abdul Yahya','003956','2000-01-02','12','PPLG','L',0000000000),(74,'c5bc8f1ef78acbf5c7b8c836b116af50.jpg','Nata Dewi','987612','2013-12-20','12','AKL','L',0000000000),(75,'000923_1768968428.jpg','aldo','000923','2026-01-21','12','PPLG','P',0000000000);
/*!40000 ALTER TABLE `siswa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tebus`
--

DROP TABLE IF EXISTS `tebus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tebus` (
  `id_tebus` int(11) NOT NULL AUTO_INCREMENT,
  `nama_tebus` varchar(50) DEFAULT NULL,
  `poin_tebus` int(11) DEFAULT NULL,
  `kode_tebus` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_tebus`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tebus`
--

LOCK TABLES `tebus` WRITE;
/*!40000 ALTER TABLE `tebus` DISABLE KEYS */;
INSERT INTO `tebus` VALUES (15,'Menulis Surat Yaasin',3,1),(16,'Sowan Kepala Sekolah',5,2),(17,'Sowan Guru BK',2,3),(18,'Sowan Waka Kesiswaan',2,4),(19,'Menulis Surat Ar-Rohman',1,5),(23,'Sowan Kang Atidz',10,7);
/*!40000 ALTER TABLE `tebus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id_user` int(11) NOT NULL AUTO_INCREMENT,
  `nama_lengkap` varchar(50) DEFAULT NULL,
  `username` varchar(30) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `role` enum('55','66','77','88') DEFAULT NULL,
  PRIMARY KEY (`id_user`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Guru SMK BP','guru smk','7907d9556254ca65c4818171ff5f761c','55'),(2,'Osis SMK','osis','5ee4f2e5c3c3a0e841a8b216c6c28e88','66'),(3,'guru','gutu','gutuee11060c23ee','77'),(4,'gfhdsf','owner','72122ce96bfec66e2396d2e25225d70a','88');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'syinpewa_sipp'
--

--
-- Dumping routines for database 'syinpewa_sipp'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-01-22 14:17:20
