-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

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

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

