-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 09, 2026 at 03:31 PM -- Server version: 10.4.32-MariaDB -- PHP Version: 8.1.25 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: `db_sarpras` -- -- -------------------------------------------------------- -- -- Table structure for table `bangunan` -- CREATE TABLE `bangunan` ( `id` int(11) UNSIGNED NOT NULL, `kib` varchar(100) DEFAULT NULL, `kode_barang` varchar(100) DEFAULT NULL, `nama_bangunan` varchar(150) NOT NULL, `luas_bangunan` double NOT NULL DEFAULT 0, `jumlah_ruang` int(11) NOT NULL DEFAULT 0, `tahun_dibangun` year(4) DEFAULT NULL, `nilai_perolehan` double NOT NULL DEFAULT 0, `penyusutan_per_tahun` double NOT NULL DEFAULT 0, `nilai_sekarang` double NOT NULL DEFAULT 0, `kondisi` enum('Baik','Rusak Ringan','Rusak Berat') NOT NULL DEFAULT 'Baik', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `bangunan` -- INSERT INTO `bangunan` (`id`, `kib`, `kode_barang`, `nama_bangunan`, `luas_bangunan`, `jumlah_ruang`, `tahun_dibangun`, `nilai_perolehan`, `penyusutan_per_tahun`, `nilai_sekarang`, `kondisi`, `created_at`, `updated_at`) VALUES (1, 'A', '1.3.1.01.01', 'Gedung Timur', 20, 15, '2023', 5000000000, 1000000, 4997000000, 'Baik', '2026-05-18 09:31:14', '2026-06-09 12:30:02'); -- -------------------------------------------------------- -- -- Table structure for table `barang` -- CREATE TABLE `barang` ( `id` int(11) UNSIGNED NOT NULL, `kib` varchar(100) DEFAULT NULL, `kode_barang` varchar(50) NOT NULL, `nama_barang` varchar(150) NOT NULL, `id_jenis` int(11) UNSIGNED DEFAULT NULL, `merk` varchar(100) DEFAULT NULL, `spesifikasi` text DEFAULT NULL, `jumlah` int(11) NOT NULL DEFAULT 0, `harga_satuan` double NOT NULL DEFAULT 0, `harga_total` double NOT NULL DEFAULT 0, `id_sumber_dana` int(11) UNSIGNED DEFAULT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `foto` varchar(255) DEFAULT NULL, `tahun_perolehan` year(4) DEFAULT NULL, `umur_ekonomis` int(11) DEFAULT NULL, `penyusutan_per_tahun` double NOT NULL DEFAULT 0, `kondisi` enum('Baik','Rusak Ringan','Rusak Berat') NOT NULL DEFAULT 'Baik', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `barang` -- INSERT INTO `barang` (`id`, `kib`, `kode_barang`, `nama_barang`, `id_jenis`, `merk`, `spesifikasi`, `jumlah`, `harga_satuan`, `harga_total`, `id_sumber_dana`, `id_ruangan`, `foto`, `tahun_perolehan`, `umur_ekonomis`, `penyusutan_per_tahun`, `kondisi`, `created_at`, `updated_at`) VALUES (1, 'B', '1.3.2.01.01', 'Komputer', 1, 'HP', 'intel core i3', 1, 2000000, 2000000, 1, 2, '1780924032_df249aef16065c64f7f4.jpg', '2020', 7, 285714.28571429, 'Baik', '2026-06-08 13:07:12', '2026-06-09 09:11:33'), (2, 'B', '1.3.2.01.02', 'Proyektor', 1, 'Epson', 'XGA', 2, 5000000, 10000000, 2, 1, '1780924153_398dd9efc3bb83ee57f2.jpg', '2020', 10, 500000, 'Baik', '2026-06-08 13:09:13', '2026-06-08 14:30:53'), (3, 'B', '1.3.2.01.03', 'Kipas', NULL, 'Miyako', '', 5, 100000, 500000, 1, 21, NULL, '2022', 7, 14285.714285714, 'Baik', '2026-06-09 09:52:55', '2026-06-09 09:52:55'); -- -------------------------------------------------------- -- -- Table structure for table `buku` -- CREATE TABLE `buku` ( `id` int(11) UNSIGNED NOT NULL, `kib` varchar(100) DEFAULT NULL, `kode_barang` varchar(100) DEFAULT NULL, `tgl_pengadaan` date DEFAULT NULL, `id_sumber_dana` int(11) UNSIGNED DEFAULT NULL, `judul` varchar(200) NOT NULL, `jenis_bacaan` varchar(255) DEFAULT NULL, `pengarang` varchar(150) DEFAULT NULL, `penerbit` varchar(150) DEFAULT NULL, `tahun_terbit` year(4) DEFAULT NULL, `harga_satuan` double NOT NULL DEFAULT 0, `jumlah` int(11) NOT NULL DEFAULT 0, `total_harga` double NOT NULL DEFAULT 0, `kondisi` varchar(50) DEFAULT 'Baik', `foto` varchar(255) DEFAULT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `umur_ekonomis` int(11) DEFAULT 5, `penyusutan_per_tahun` double DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `buku` -- INSERT INTO `buku` (`id`, `kib`, `kode_barang`, `tgl_pengadaan`, `id_sumber_dana`, `judul`, `jenis_bacaan`, `pengarang`, `penerbit`, `tahun_terbit`, `harga_satuan`, `jumlah`, `total_harga`, `kondisi`, `foto`, `id_ruangan`, `created_at`, `updated_at`, `umur_ekonomis`, `penyusutan_per_tahun`) VALUES (9, '', '', '2025-01-01', 1, 'Cerita Kancil', 'Fiksi', 'Prabowo', 'Erlangga', '2014', 10000, 2, 20000, 'Rusak Ringan', '1780151131_d4eb8dc639abf6181964.jpg', 4, '2026-05-18 22:20:33', '2026-06-08 14:06:03', 10, 1000), (10, '', '', '2023-01-01', 2, 'Cerita Kancil', 'Fiksi', 'Prabowo', 'Erlangga', '2014', 10000, 3, 30000, 'Baik', NULL, 4, '2026-05-18 22:20:33', '2026-06-08 14:07:52', 9, 1111.1111111111), (11, NULL, '', '2017-01-01', 2, 'Cerita Kancil', 'Fiksi', 'Prabowo', 'Erlangga', '2014', 10000, 4, 40000, 'Baik', NULL, 4, '2026-05-18 22:20:33', '2026-06-08 14:13:18', 6, 1666.6666666667), (12, NULL, '', '2017-01-01', 3, 'Angkasa', 'Non Fiksi', 'Gibran', 'Yudhistira', '2015', 15000, 5, 75000, 'Baik', NULL, 4, '2026-05-18 22:20:33', '2026-06-08 14:12:36', 6, 2500), (13, NULL, '', '2017-01-01', 3, 'Angkasa', 'Non Fiksi', 'Gibran', 'Yudhistira', '2015', 15000, 6, 90000, 'Baik', NULL, 4, '2026-05-18 22:20:33', '2026-06-08 14:12:22', 4, 3750), (14, NULL, '', '2017-01-01', 5, 'Angkasa', 'Non Fiksi', 'Gibran', 'Yudhistira', '2015', 15000, 7, 105000, 'Baik', NULL, 4, '2026-05-18 22:20:33', '2026-06-08 14:13:07', 6, 2500); -- -------------------------------------------------------- -- -- Table structure for table `jenis_barang` -- CREATE TABLE `jenis_barang` ( `id` int(11) UNSIGNED NOT NULL, `nama_jenis` varchar(100) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `jenis_barang` -- INSERT INTO `jenis_barang` (`id`, `nama_jenis`, `created_at`, `updated_at`) VALUES (1, 'Peralatan Elektronik', NULL, '2026-06-01 10:07:01'), (3, 'Sarana Olah Raga', NULL, '2026-06-01 10:07:22'), (4, 'Sarana Pembelajaran', '2026-05-18 12:48:06', '2026-06-02 09:47:23'), (5, 'Teknologi Informasi', '2026-05-18 12:48:23', '2026-06-01 10:06:16'), (6, 'Perabot Sekolah', '2026-06-01 10:06:36', '2026-06-01 10:06:36'), (7, 'Peralatan Kantor', '2026-06-01 10:06:49', '2026-06-01 10:06:49'), (8, 'Sarana Ibadah', '2026-06-01 10:07:37', '2026-06-01 10:07:37'), (9, 'Bangunan dan Infrastruktur', '2026-06-01 10:08:00', '2026-06-01 10:08:00'), (10, 'Perabot Kelas', '2026-06-03 05:09:39', '2026-06-03 05:09:39'); -- -------------------------------------------------------- -- -- Table structure for table `kib_detail` -- CREATE TABLE `kib_detail` ( `id` int(11) UNSIGNED NOT NULL, `id_kib_kategori` int(11) UNSIGNED NOT NULL, `kode` varchar(100) NOT NULL, `nama_barang` varchar(200) NOT NULL, `keterangan` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `kib_detail` -- INSERT INTO `kib_detail` (`id`, `id_kib_kategori`, `kode`, `nama_barang`, `keterangan`, `created_at`, `updated_at`) VALUES (1, 1, '1.3.1.01.01', 'Tanah', 'Gedung Timur', '2026-05-19 01:22:20', '2026-05-19 01:22:20'), (3, 2, '1.3.2.01.01', 'Sarana Pembelajaran', NULL, '2026-05-19 01:25:43', '2026-06-09 09:33:55'), (4, 3, '1.3.3.01.01', 'Toilet', NULL, '2026-05-19 05:35:30', '2026-06-09 09:56:26'), (5, 2, '1.3.2.01.02', 'Peralatan Teknologi Informasi', NULL, '2026-05-19 09:40:00', '2026-06-09 09:35:54'), (6, 2, '1.3.2.01.03', 'Perabot Kelas', NULL, '2026-06-01 12:52:23', '2026-06-09 09:36:48'), (10, 2, '1.3.2.01.04', 'Peralatan Kantor', NULL, '2026-06-02 10:06:22', '2026-06-09 09:37:29'), (11, 2, '1.3.2.01.05', 'Peralatan Elektronik', NULL, '2026-06-02 10:06:29', '2026-06-09 09:38:34'), (12, 1, '1.3.1.01.02', 'Bangunan', NULL, '2026-06-09 09:39:46', '2026-06-09 09:39:46'); -- -------------------------------------------------------- -- -- Table structure for table `kib_kategori` -- CREATE TABLE `kib_kategori` ( `id` int(11) UNSIGNED NOT NULL, `nama_kib` varchar(50) NOT NULL, `kode_brg` varchar(50) NOT NULL, `keterangan` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `kib_kategori` -- INSERT INTO `kib_kategori` (`id`, `nama_kib`, `kode_brg`, `keterangan`, `created_at`, `updated_at`) VALUES (1, 'A', '1.3.1.01.', 'Tanah', '2026-05-19 01:21:48', '2026-05-30 22:53:21'), (2, 'B', '1.3.2.01.', 'Peralatan dan Mesin', '2026-05-19 01:25:13', '2026-05-30 22:53:30'), (3, 'C', '1.3.3.01.', 'Gedung dan Bangunan', '2026-05-19 05:34:42', '2026-05-30 22:53:53'), (4, 'D', '1.3.4.01.', 'jaringan & infrastruktur', '2026-05-19 10:01:00', '2026-05-30 22:54:09'), (5, 'E', '1.3.5.01.', 'Aset Koleksi/Lainnya', '2026-05-19 10:02:10', '2026-05-30 22:54:17'); -- -------------------------------------------------------- -- -- Table structure for table `migrations` -- CREATE TABLE `migrations` ( `id` bigint(20) UNSIGNED NOT NULL, `version` varchar(255) NOT NULL, `class` varchar(255) NOT NULL, `group` varchar(255) NOT NULL, `namespace` varchar(255) NOT NULL, `time` int(11) NOT NULL, `batch` int(11) UNSIGNED NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `migrations` -- INSERT INTO `migrations` (`id`, `version`, `class`, `group`, `namespace`, `time`, `batch`) VALUES (1, '2026-05-18-000001', 'App\\Database\\Migrations\\CreateSarprasTables', 'default', 'App', 1779088713, 1), (2, '2026-05-18-134629', 'App\\Database\\Migrations\\AddKibAndColumns', 'default', 'App', 1779112080, 2), (3, '2026-05-18-224756', 'App\\Database\\Migrations\\AddTransaksiColumns', 'default', 'App', 1779144853, 3), (4, '2026-05-19-011715', 'App\\Database\\Migrations\\CreateKibTables', 'default', 'App', 1779153480, 4), (5, '2026-05-19-052420', 'App\\Database\\Migrations\\AddKibToTanahBangunan', 'default', 'App', 1779168290, 5), (6, '2026-05-30-141825', 'App\\Database\\Migrations\\AddKondisiToBuku', 'default', 'App', 1780150845, 6); -- -------------------------------------------------------- -- -- Table structure for table `peminjaman` -- CREATE TABLE `peminjaman` ( `id` int(11) UNSIGNED NOT NULL, `id_barang` int(11) UNSIGNED DEFAULT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `tgl_peminjaman` date DEFAULT NULL, `tgl_pengembalian` date DEFAULT NULL, `biaya` double NOT NULL DEFAULT 0, `foto` varchar(255) DEFAULT NULL, `bukti_bayar` varchar(255) DEFAULT NULL, `keterangan` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `peminjaman` -- INSERT INTO `peminjaman` (`id`, `id_barang`, `id_ruangan`, `tgl_peminjaman`, `tgl_pengembalian`, `biaya`, `foto`, `bukti_bayar`, `keterangan`, `created_at`, `updated_at`) VALUES (1, 1, 6, '2026-05-18', '2026-05-18', 500000, '1779097458_01c4dccd5d675147df45.jpg', '1779182715_b8e0cef7f22fc86aa614.png', 'Pertemuan Komite', '2026-05-18 09:44:18', '2026-06-09 01:36:02'); -- -------------------------------------------------------- -- -- Table structure for table `pengajuan` -- CREATE TABLE `pengajuan` ( `id` int(11) UNSIGNED NOT NULL, `tgl_pengajuan` date DEFAULT NULL, `tgl_persetujuan` date DEFAULT NULL, `nama_barang` varchar(150) NOT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `biaya` double NOT NULL DEFAULT 0, `foto` varchar(255) DEFAULT NULL, `keterangan` text DEFAULT NULL, `status_realisasi` varchar(50) DEFAULT 'Pending', `bukti_bayar` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `pengajuan` -- INSERT INTO `pengajuan` (`id`, `tgl_pengajuan`, `tgl_persetujuan`, `nama_barang`, `id_ruangan`, `biaya`, `foto`, `keterangan`, `status_realisasi`, `bukti_bayar`, `created_at`, `updated_at`) VALUES (1, '2026-05-18', '2026-05-18', 'Komputer', 3, 500000, '1779169463_e66671af62e317c641ef.png', 'kebutuhan pembelajaran', 'Ditolak', '1779169218_9c996574201b86c0f8fb.png', '2026-05-18 09:46:17', '2026-05-19 05:49:28'); -- -------------------------------------------------------- -- -- Table structure for table `penghapusan` -- CREATE TABLE `penghapusan` ( `id` int(11) UNSIGNED NOT NULL, `tgl_kerusakan` date DEFAULT NULL, `tgl_persetujuan` date DEFAULT NULL, `id_barang` int(11) UNSIGNED DEFAULT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `foto` varchar(255) DEFAULT NULL, `keterangan` text DEFAULT NULL, `status_realisasi` varchar(50) DEFAULT NULL, `bukti_realisasi` varchar(255) DEFAULT NULL, `pemasukan` double DEFAULT 0, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `penghapusan` -- INSERT INTO `penghapusan` (`id`, `tgl_kerusakan`, `tgl_persetujuan`, `id_barang`, `id_ruangan`, `foto`, `keterangan`, `status_realisasi`, `bukti_realisasi`, `pemasukan`, `created_at`, `updated_at`) VALUES (1, '2026-05-18', '2026-05-18', 1, 2, '1779169329_83f5af3093b0c3203722.png', 'rusak', 'Dijual', '1779169367_c5014cd9fe20e06846bd.png', 50000, '2026-05-18 09:47:19', '2026-05-19 05:43:00'); -- -------------------------------------------------------- -- -- Table structure for table `perbaikan` -- CREATE TABLE `perbaikan` ( `id` int(11) UNSIGNED NOT NULL, `id_barang` int(11) UNSIGNED DEFAULT NULL, `id_ruangan` int(11) UNSIGNED DEFAULT NULL, `jenis_perbaikan` varchar(150) NOT NULL, `tgl_kerusakan` date DEFAULT NULL, `tgl_perbaikan` date DEFAULT NULL, `biaya` double NOT NULL DEFAULT 0, `foto` varchar(255) DEFAULT NULL, `bukti_bayar` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `perbaikan` -- INSERT INTO `perbaikan` (`id`, `id_barang`, `id_ruangan`, `jenis_perbaikan`, `tgl_kerusakan`, `tgl_perbaikan`, `biaya`, `foto`, `bukti_bayar`, `created_at`, `updated_at`) VALUES (1, 1, 3, 'Ganti PSU', '2026-05-18', '2026-05-23', 50000, '1779097520_44d29316948b4ad72849.jpg', '1779160296_7df5c2261f134fe13a27.png', '2026-05-18 09:45:20', '2026-05-19 03:11:36'), (2, 1, 2, 'Ganti Processor', '2026-06-09', '2026-06-10', 500000, '1780966798_1f877f6f0fa2316eb2bd.jpg', '1780966798_50127b44a5b02eeb1e87.png', '2026-06-09 00:59:58', '2026-06-09 00:59:58'); -- -------------------------------------------------------- -- -- Table structure for table `ruangan` -- CREATE TABLE `ruangan` ( `id` int(11) UNSIGNED NOT NULL, `nama_ruangan` varchar(100) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `ruangan` -- INSERT INTO `ruangan` (`id`, `nama_ruangan`, `created_at`, `updated_at`) VALUES (1, 'Kepala Madrasah', NULL, '2026-06-01 09:28:18'), (2, 'Ruang Guru', NULL, NULL), (3, 'Lab Komputer', NULL, NULL), (4, 'Perpustakaan', NULL, NULL), (6, 'Kelas 1A', '2026-05-20 22:26:21', '2026-05-20 22:26:21'), (7, 'Kelas 1B', '2026-05-20 22:26:30', '2026-05-20 22:26:30'), (8, 'Kelas 1C', '2026-05-20 22:26:39', '2026-05-20 22:26:39'), (9, 'Kelas 1D', '2026-05-20 22:26:49', '2026-05-20 22:26:49'), (10, 'Kelas 2A', '2026-05-20 22:27:14', '2026-05-20 22:27:14'), (11, 'Kelas 2B', '2026-05-20 22:27:24', '2026-05-20 22:27:24'), (12, 'Kelas 2C', '2026-05-20 22:27:33', '2026-05-20 22:27:33'), (14, 'Kelas 3A', '2026-06-01 09:26:03', '2026-06-01 09:26:03'), (15, 'Kelas 3B', '2026-06-01 09:26:11', '2026-06-01 09:26:11'), (16, 'Kelas 3C', '2026-06-01 09:26:18', '2026-06-01 09:26:18'), (17, 'Kelas 4A', '2026-06-01 09:26:34', '2026-06-01 09:26:34'), (18, 'Kelas 4B', '2026-06-01 09:26:52', '2026-06-01 09:26:52'), (19, 'Kelas 4C', '2026-06-01 09:26:58', '2026-06-01 09:26:58'), (20, 'Kelas 5A', '2026-06-01 09:27:12', '2026-06-01 09:27:12'), (21, 'Kelas 5B', '2026-06-01 09:27:19', '2026-06-01 09:27:19'), (22, 'Kelas 5C', '2026-06-01 09:27:27', '2026-06-01 09:27:27'), (23, 'Kelas 6A', '2026-06-01 09:27:35', '2026-06-01 09:27:35'), (24, 'Kelas 6B', '2026-06-01 09:27:44', '2026-06-01 09:27:44'), (25, 'Kelas 6C', '2026-06-01 09:27:52', '2026-06-01 09:27:52'), (26, 'Kantor/Administrasi', '2026-06-01 09:28:49', '2026-06-01 09:28:49'), (27, 'Kantin', '2026-06-01 09:29:35', '2026-06-01 09:29:35'), (28, 'Koperasi', '2026-06-01 09:29:50', '2026-06-01 09:29:50'), (29, 'Arsip', '2026-06-01 09:30:46', '2026-06-01 09:30:46'), (30, 'UKS', '2026-06-01 09:31:01', '2026-06-01 09:31:01'), (31, 'Markaz UMMI', '2026-06-01 09:31:09', '2026-06-01 09:33:14'), (32, 'Markaz Ustadz (BK)', '2026-06-01 09:31:49', '2026-06-01 09:33:04'), (33, 'Inventaris', '2026-06-01 09:32:12', '2026-06-01 09:32:12'), (34, 'Gudang', '2026-06-01 09:33:43', '2026-06-01 09:33:43'), (35, 'GOR', '2026-06-01 09:33:51', '2026-06-01 09:33:51'), (36, 'Teknisi (Service Center)', '2026-06-01 09:37:32', '2026-06-01 09:37:32'); -- -------------------------------------------------------- -- -- Table structure for table `sumber_dana` -- CREATE TABLE `sumber_dana` ( `id` int(11) UNSIGNED NOT NULL, `nama_sumber` varchar(100) NOT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `sumber_dana` -- INSERT INTO `sumber_dana` (`id`, `nama_sumber`, `created_at`, `updated_at`) VALUES (1, 'BOS Pusat', NULL, NULL), (2, 'BOPDA', NULL, '2026-05-18 12:47:23'), (3, 'Komite Sekolah', NULL, NULL), (5, 'PCM', '2026-05-18 13:54:02', '2026-05-18 13:54:02'), (6, 'Wali Murid', '2026-06-01 09:39:05', '2026-06-01 09:39:05'); -- -------------------------------------------------------- -- -- Table structure for table `tanah` -- CREATE TABLE `tanah` ( `id` int(11) UNSIGNED NOT NULL, `kib` varchar(100) DEFAULT NULL, `kode_barang` varchar(100) DEFAULT NULL, `nama_tanah` varchar(150) NOT NULL, `status_kepemilikan` varchar(100) NOT NULL, `luas` double NOT NULL DEFAULT 0, `lokasi` text NOT NULL, `tahun_perolehan` year(4) DEFAULT NULL, `nilai_perolehan` double NOT NULL DEFAULT 0, `kenaikan_per_tahun` double NOT NULL DEFAULT 0, `nilai_sekarang` double NOT NULL DEFAULT 0, `kondisi` varchar(100) NOT NULL, `keterangan` text DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `tanah` -- INSERT INTO `tanah` (`id`, `kib`, `kode_barang`, `nama_tanah`, `status_kepemilikan`, `luas`, `lokasi`, `tahun_perolehan`, `nilai_perolehan`, `kenaikan_per_tahun`, `nilai_sekarang`, `kondisi`, `keterangan`, `created_at`, `updated_at`) VALUES (3, 'A', '1.3.1.01.01', 'Kav 21', 'Milik Muhammadiyah', 800, 'Wonorejo Indah Timur No. 26', '2014', 4000000000, 4000000, 4048000000, 'Baik', '', '2026-06-09 12:28:13', '2026-06-09 12:29:05'), (4, 'A', '1.3.1.01.01', 'Kav 20', 'Milik Muhammadiyah', 300, 'Wono', '2015', 3000000000, 2000000, 3022000000, 'Baik', '', '2026-06-09 12:56:51', '2026-06-09 12:56:51'); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) UNSIGNED NOT NULL, `name` varchar(100) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(255) NOT NULL, `role` enum('admin','user') NOT NULL DEFAULT 'user', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `username`, `password`, `role`, `created_at`, `updated_at`) VALUES (1, 'Administrator', 'admin', '$2y$10$aJq981Bkpm9fooRBHAeCkedc3.CDO1U4hMmKCKLqqvytPAb/bNl8K', 'admin', '2026-05-18 07:18:37', '2026-05-18 07:18:37'), (2, 'User Biasa', 'user', '$2y$10$T.Smf2jOFJna8K8DYTMfD.i3HOa.UQHTripZqX2Aw5p.YsgNPjPSi', 'user', '2026-05-18 07:18:37', '2026-05-18 07:18:37'), (3, 'mustholikan', 'admin', '$2y$10$w7YPSM/d/M6lmgNtph3jX.o5cRgQ6nI3LgMBNPr8yifXu7/aDe0IW', 'admin', '2026-05-18 10:14:26', '2026-05-18 10:14:26'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bangunan` -- ALTER TABLE `bangunan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `barang` -- ALTER TABLE `barang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `buku` -- ALTER TABLE `buku` ADD PRIMARY KEY (`id`); -- -- Indexes for table `jenis_barang` -- ALTER TABLE `jenis_barang` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kib_detail` -- ALTER TABLE `kib_detail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `kib_kategori` -- ALTER TABLE `kib_kategori` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `peminjaman` -- ALTER TABLE `peminjaman` ADD PRIMARY KEY (`id`); -- -- Indexes for table `pengajuan` -- ALTER TABLE `pengajuan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `penghapusan` -- ALTER TABLE `penghapusan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `perbaikan` -- ALTER TABLE `perbaikan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ruangan` -- ALTER TABLE `ruangan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `sumber_dana` -- ALTER TABLE `sumber_dana` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tanah` -- ALTER TABLE `tanah` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bangunan` -- ALTER TABLE `bangunan` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `barang` -- ALTER TABLE `barang` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `buku` -- ALTER TABLE `buku` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `jenis_barang` -- ALTER TABLE `jenis_barang` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `kib_detail` -- ALTER TABLE `kib_detail` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `kib_kategori` -- ALTER TABLE `kib_kategori` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `migrations` -- ALTER TABLE `migrations` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `peminjaman` -- ALTER TABLE `peminjaman` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `pengajuan` -- ALTER TABLE `pengajuan` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `penghapusan` -- ALTER TABLE `penghapusan` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `perbaikan` -- ALTER TABLE `perbaikan` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `ruangan` -- ALTER TABLE `ruangan` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37; -- -- AUTO_INCREMENT for table `sumber_dana` -- ALTER TABLE `sumber_dana` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tanah` -- ALTER TABLE `tanah` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; 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 */;