text: -- phpMyAdmin SQL Dump
  -- version 4.7.0
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: May 16, 2019 at 04:23 PM
  -- Server version: 10.1.25-MariaDB
  -- PHP Version: 7.1.7
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  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: `rental_mobil1`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin`
  --
  
  CREATE TABLE `admin` (
    `admin_id` int(11) NOT NULL,
    `admin_nama` varchar(255) NOT NULL,
    `admin_username` varchar(255) NOT NULL,
    `admin_password` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admin`
  --
  
  INSERT INTO `admin` (`admin_id`, `admin_nama`, `admin_username`, `admin_password`) VALUES
  (1, 'Diki Alfarabi Hadi', 'diki', 'dffaa4c60a250f19dc4a79b1d05c8d53'),
  (2, 'latief', 'admin', '21232f297a57a5a743894a0e4a801fc3');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kostumer`
  --
  
  CREATE TABLE `kostumer` (
    `kostumer_id` int(11) NOT NULL,
    `kostumer_nama` varchar(255) NOT NULL,
    `kostumer_alamat` text NOT NULL,
    `kostumer_jk` varchar(10) NOT NULL,
    `kostumer_hp` varchar(20) NOT NULL,
    `kostumer_ktp` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `kostumer`
  --
  
  INSERT INTO `kostumer` (`kostumer_id`, `kostumer_nama`, `kostumer_alamat`, `kostumer_jk`, `kostumer_hp`, `kostumer_ktp`) VALUES
  (2, 'Samsul Alami', 'Krukuh', 'P', '833637363', 'qwertyuiu'),
  (3, 'Jamulidin S.E', 'Kuta Blang', 'L', '856567567', '234234234234'),
  (4, 'Imam Faluti', 'Krung Mane', 'L', '2147483647', '34234234324');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `mobil`
  --
  
  CREATE TABLE `mobil` (
    `mobil_id` int(11) NOT NULL,
    `mobil_merk` varchar(30) NOT NULL,
    `mobil_plat` varchar(20) NOT NULL,
    `mobil_warna` varchar(30) NOT NULL,
    `mobil_tahun` int(11) NOT NULL,
    `mobil_status` int(11) NOT NULL COMMENT '1 = tersedia, 2 = di pinjam'
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `mobil`
  --
  
  INSERT INTO `mobil` (`mobil_id`, `mobil_merk`, `mobil_plat`, `mobil_warna`, `mobil_tahun`, `mobil_status`) VALUES
  (2, 'Toyota Avanza Veloz', 'B 9879 UK', 'Hitam', 2016, 1),
  (3, 'Honda Jazz', 'B 2793 UI', 'Silver', 2002, 2),
  (4, 'Kijang Inova', 'B 3242 JJ', 'Putih', 2012, 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transaksi`
  --
  
  CREATE TABLE `transaksi` (
    `transaksi_id` int(11) NOT NULL,
    `transaksi_karyawan` int(11) NOT NULL,
    `transaksi_kostumer` int(11) NOT NULL,
    `transaksi_mobil` int(11) NOT NULL,
    `transaksi_tgl_pinjam` date NOT NULL,
    `transaksi_tgl_kembali` date NOT NULL,
    `transaksi_harga` int(11) NOT NULL,
    `transaksi_denda` int(11) NOT NULL,
    `transaksi_tgl` date NOT NULL,
    `transaksi_totaldenda` int(11) NOT NULL,
    `transaksi_status` int(11) NOT NULL,
    `transaksi_tgldikembalikan` date NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `transaksi`
  --
  
  INSERT INTO `transaksi` (`transaksi_id`, `transaksi_karyawan`, `transaksi_kostumer`, `transaksi_mobil`, `transaksi_tgl_pinjam`, `transaksi_tgl_kembali`, `transaksi_harga`, `transaksi_denda`, `transaksi_tgl`, `transaksi_totaldenda`, `transaksi_status`, `transaksi_tgldikembalikan`) VALUES
  (6, 1, 2, 2, '2017-09-01', '2017-09-09', 200000, 100000, '2017-09-28', 2100000, 1, '2017-09-30'),
  (7, 1, 3, 3, '2017-09-02', '2017-09-04', 400000, 100000, '2017-09-15', 200000, 1, '2017-09-06'),
  (8, 1, 2, 3, '2017-09-08', '2017-09-30', 200000, 100000, '2017-09-28', 0, 0, '0000-00-00');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `admin`
  --
  ALTER TABLE `admin`
    ADD PRIMARY KEY (`admin_id`);
  
  --
  -- Indexes for table `kostumer`
  --
  ALTER TABLE `kostumer`
    ADD PRIMARY KEY (`kostumer_id`);
  
  --
  -- Indexes for table `mobil`
  --
  ALTER TABLE `mobil`
    ADD PRIMARY KEY (`mobil_id`);
  
  --
  -- Indexes for table `transaksi`
  --
  ALTER TABLE `transaksi`
    ADD PRIMARY KEY (`transaksi_id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `admin`
  --
  ALTER TABLE `admin`
    MODIFY `admin_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  --
  -- AUTO_INCREMENT for table `kostumer`
  --
  ALTER TABLE `kostumer`
    MODIFY `kostumer_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `mobil`
  --
  ALTER TABLE `mobil`
    MODIFY `mobil_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  --
  -- AUTO_INCREMENT for table `transaksi`
  --
  ALTER TABLE `transaksi`
    MODIFY `transaksi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;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 */;
  