-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.30 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             12.1.0.6537
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;

-- Dumping structure for table flutterperpustakaanapi.anggota
CREATE TABLE IF NOT EXISTS `anggota` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `nis` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `kelas` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `telepon` varchar(30) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `pengguna_id` int unsigned DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table flutterperpustakaanapi.anggota: ~0 rows (approximately)
DELETE FROM `anggota`;
INSERT INTO `anggota` (`id`, `nama`, `nis`, `kelas`, `alamat`, `telepon`, `email`, `pengguna_id`, `created_at`) VALUES
	(4, 'Sudendev', '1234565432', '3', 'Banyuasin', '082277366455', 'sudendev@gmail.com', 3, '2026-07-13 17:40:06');

-- Dumping structure for table flutterperpustakaanapi.buku
CREATE TABLE IF NOT EXISTS `buku` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `kode_buku` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `judul` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `pengarang` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `penerbit` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `tahun_terbit` smallint unsigned NOT NULL,
  `kategori` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `jumlah` int unsigned NOT NULL DEFAULT '0',
  `tersedia` int unsigned NOT NULL DEFAULT '0',
  `foto` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table flutterperpustakaanapi.buku: ~1 rows (approximately)
DELETE FROM `buku`;
INSERT INTO `buku` (`id`, `kode_buku`, `judul`, `pengarang`, `penerbit`, `tahun_terbit`, `kategori`, `jumlah`, `tersedia`, `foto`, `created_at`) VALUES
	(4, '001', 'Algoritma dan Pemrograman', 'Hanif al Fatta', 'Erlangga', 2019, 'Teknologi', 9, 9, '/uploads/buku/img_6a54bdea86dd51.89381597.jpg', '2026-07-13 17:28:58');

-- Dumping structure for table flutterperpustakaanapi.peminjaman
CREATE TABLE IF NOT EXISTS `peminjaman` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `buku_id` int unsigned NOT NULL,
  `pengguna_id` int unsigned NOT NULL,
  `tanggal_pinjam` datetime DEFAULT NULL,
  `tanggal_kembali` datetime DEFAULT NULL,
  `status` enum('menunggu','dipinjam','dikembalikan','ditolak') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'menunggu',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table flutterperpustakaanapi.peminjaman: ~0 rows (approximately)
DELETE FROM `peminjaman`;

-- Dumping structure for table flutterperpustakaanapi.pemusnahan
CREATE TABLE IF NOT EXISTS `pemusnahan` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `buku_id` int unsigned NOT NULL,
  `alasan` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `jumlah` int unsigned NOT NULL DEFAULT '1',
  `tanggal` datetime NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table flutterperpustakaanapi.pemusnahan: ~0 rows (approximately)
DELETE FROM `pemusnahan`;
INSERT INTO `pemusnahan` (`id`, `buku_id`, `alasan`, `jumlah`, `tanggal`, `created_at`) VALUES
	(3, 4, 'hilang', 1, '2026-07-13 17:38:56', '2026-07-13 17:38:56');

-- Dumping structure for table flutterperpustakaanapi.pengguna
CREATE TABLE IF NOT EXISTS `pengguna` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_general_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `role` enum('petugas','anggota') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'anggota',
  `nis` varchar(50) COLLATE utf8mb4_general_ci DEFAULT '',
  `foto` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`),
  UNIQUE KEY `uq_pengguna_username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table flutterperpustakaanapi.pengguna: ~1 rows (approximately)
DELETE FROM `pengguna`;
INSERT INTO `pengguna` (`id`, `nama`, `username`, `email`, `password`, `role`, `nis`, `foto`, `created_at`) VALUES
	(1, 'Admin Petugas', 'petugas', 'petugas@gmail.com', '$2y$10$AK16cOscKRNkIizJ2vWyquBBA.z23UpXwAzh/HVD077/euVjU9JNi', 'petugas', '', '/uploads/profil/img_6a548f43f103e2.00252578.jpg', '2026-07-13 13:37:00'),
	(3, 'Sudendev', 'sudendev', 'sudendev@gmail.com', '$2y$10$5OhBRf1WqD41tepO.PhPbuPsDl1Qm9my8wBG/u9Kg3tsfkcb2o2Ei', 'anggota', '1234565432', '', '2026-07-13 17:40:06');

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;