text: -- phpMyAdmin SQL Dump
  -- version 4.5.4.1deb2ubuntu2.1
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost
  -- Generation Time: Oct 19, 2018 at 10:02 AM
  -- Server version: 5.7.23-0ubuntu0.16.04.1
  -- PHP Version: 7.0.32-2+ubuntu16.04.1+deb.sury.org+1
  
  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 utf8mb4 */;
  
  --
  -- Database: `ajc`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `biaya`
  --
  
  CREATE TABLE `biaya` (
    `id_biaya` int(10) NOT NULL,
    `jenis` varchar(50) NOT NULL,
    `biaya` int(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `biaya`
  --
  
  INSERT INTO `biaya` (`id_biaya`, `jenis`, `biaya`) VALUES
  (2, 'Sepeda Motor', 10000),
  (5, 'Mobil', 25000);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transaksi`
  --
  
  CREATE TABLE `transaksi` (
    `id_transaksi` int(10) NOT NULL,
    `no_nota` varchar(10) NOT NULL,
    `jenis` varchar(50) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `bayar` int(10) NOT NULL,
    `kembali` int(10) NOT NULL,
    `total` int(10) NOT NULL,
    `tanggal` date NOT NULL,
    `id_user` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user`
  --
  
  CREATE TABLE `user` (
    `id_user` tinyint(2) NOT NULL,
    `username` varchar(30) NOT NULL,
    `password` varchar(35) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `alamat` varchar(150) NOT NULL,
    `hp` varchar(20) NOT NULL,
    `level` tinyint(1) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `user`
  --
  
  INSERT INTO `user` (`id_user`, `username`, `password`, `nama`, `alamat`, `hp`, `level`) VALUES
  (1, 'masrud', '7d05dc02abe9cda729d0c798c886db47', 'M. Rudianto', 'Ds. Bareng, Kec. Sawahan Kab. Nganjuk - Jawa Timur', '085735501035', 1);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `biaya`
  --
  ALTER TABLE `biaya`
    ADD PRIMARY KEY (`id_biaya`);
  
  --
  -- Indexes for table `transaksi`
  --
  ALTER TABLE `transaksi`
    ADD PRIMARY KEY (`id_transaksi`);
  
  --
  -- Indexes for table `user`
  --
  ALTER TABLE `user`
    ADD PRIMARY KEY (`id_user`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `biaya`
  --
  ALTER TABLE `biaya`
    MODIFY `id_biaya` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  --
  -- AUTO_INCREMENT for table `transaksi`
  --
  ALTER TABLE `transaksi`
    MODIFY `id_transaksi` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63;
  --
  -- AUTO_INCREMENT for table `user`
  --
  ALTER TABLE `user`
    MODIFY `id_user` tinyint(2) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
  /*!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 */;
  