text: -- phpMyAdmin SQL Dump
  -- version 4.2.11
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: 05 Feb 2019 pada 16.38
  -- Versi Server: 5.6.21
  -- PHP Version: 5.6.3
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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 utf8 */;
  
  --
  -- Database: `inventarisbarang`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `admin`
  --
  
  CREATE TABLE IF NOT EXISTS `admin` (
  `id_admin` int(11) NOT NULL,
    `username` varchar(50) NOT NULL,
    `password` varchar(50) NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `admin`
  --
  
  INSERT INTO `admin` (`id_admin`, `username`, `password`) VALUES
  (1, 'devano', 'devano');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `barang`
  --
  
  CREATE TABLE IF NOT EXISTS `barang` (
  `id_barang` int(11) NOT NULL,
    `nama_barang` varchar(50) NOT NULL,
    `tanggal_masuk` varchar(50) NOT NULL,
    `jumlah` varchar(50) NOT NULL,
    `keterangan` varchar(50) NOT NULL,
    `id_kategori` int(11) NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `barang`
  --
  
  INSERT INTO `barang` (`id_barang`, `nama_barang`, `tanggal_masuk`, `jumlah`, `keterangan`, `id_kategori`) VALUES
  (4, 'kursi', '1/01/2001', '200', 'new', 0),
  (5, 'Speaker', '13/04/2008', '50', 'new', 3),
  (6, 'LCD PROYEKTOR', '21/01/2019', '20', 'baru', 5),
  (7, 'Kipas Angin', '11/01/2019', '32', 'lama', 4),
  (8, 'Speaker', '01/02/2019', '70', 'baru', 6);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `kategori`
  --
  
  CREATE TABLE IF NOT EXISTS `kategori` (
  `id_kategori` int(11) NOT NULL,
    `nama_kategori` varchar(50) NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `kategori`
  --
  
  INSERT INTO `kategori` (`id_kategori`, `nama_kategori`) VALUES
  (4, 'kelas'),
  (5, 'sarpra'),
  (6, 'ruang guru');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `peminjam`
  --
  
  CREATE TABLE IF NOT EXISTS `peminjam` (
  `id_peminjam` int(11) NOT NULL,
    `nama_peminjam` varchar(100) NOT NULL,
    `telepon` varchar(100) NOT NULL,
    `alamat` varchar(100) NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `peminjam`
  --
  
  INSERT INTO `peminjam` (`id_peminjam`, `nama_peminjam`, `telepon`, `alamat`) VALUES
  (4, 'devano', '0895394038137', 'Jl Danau Ranau');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `transaksi`
  --
  
  CREATE TABLE IF NOT EXISTS `transaksi` (
  `id_transaksi` int(11) NOT NULL,
    `id_peminjam` int(11) NOT NULL,
    `tanggal_peminjam` varchar(100) NOT NULL,
    `id_barang` int(11) NOT NULL,
    `jumlah_barang` varchar(50) NOT NULL
  ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `transaksi`
  --
  
  INSERT INTO `transaksi` (`id_transaksi`, `id_peminjam`, `tanggal_peminjam`, `id_barang`, `jumlah_barang`) VALUES
  (5, 1, '20/09/2018', 6, '8'),
  (6, 2, '20/09/2018', 7, '10'),
  (7, 3, '11/11/2011', 8, '2'),
  (8, 4, '17', 8, '1');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admin`
  --
  ALTER TABLE `admin`
   ADD PRIMARY KEY (`id_admin`);
  
  --
  -- Indexes for table `barang`
  --
  ALTER TABLE `barang`
   ADD PRIMARY KEY (`id_barang`);
  
  --
  -- Indexes for table `kategori`
  --
  ALTER TABLE `kategori`
   ADD PRIMARY KEY (`id_kategori`);
  
  --
  -- Indexes for table `peminjam`
  --
  ALTER TABLE `peminjam`
   ADD PRIMARY KEY (`id_peminjam`);
  
  --
  -- Indexes for table `transaksi`
  --
  ALTER TABLE `transaksi`
   ADD PRIMARY KEY (`id_transaksi`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admin`
  --
  ALTER TABLE `admin`
  MODIFY `id_admin` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  --
  -- AUTO_INCREMENT for table `barang`
  --
  ALTER TABLE `barang`
  MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
  --
  -- AUTO_INCREMENT for table `kategori`
  --
  ALTER TABLE `kategori`
  MODIFY `id_kategori` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
  --
  -- AUTO_INCREMENT for table `peminjam`
  --
  ALTER TABLE `peminjam`
  MODIFY `id_peminjam` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `transaksi`
  --
  ALTER TABLE `transaksi`
  MODIFY `id_transaksi` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
  /*!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 */;
  