text: -- phpMyAdmin SQL Dump
  -- version 4.7.7
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jul 04, 2019 at 02:55 AM
  -- Server version: 10.1.30-MariaDB
  -- PHP Version: 7.2.2
  
  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: `hijab`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `admin`
  --
  
  CREATE TABLE `admin` (
    `id_admin` int(11) NOT NULL,
    `username` varchar(25) NOT NULL,
    `password` varchar(125) NOT NULL,
    `nama` varchar(25) NOT NULL,
    `gambar` varchar(25) NOT NULL,
    `email` varchar(25) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `admin`
  --
  
  INSERT INTO `admin` (`id_admin`, `username`, `password`, `nama`, `gambar`, `email`) VALUES
  (2, 'admin', '81dc9bdb52d04dc20036dbd8313ed055', 'dariya', 'admin.jpg', 'dariya@gmail.com');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `barang`
  --
  
  CREATE TABLE `barang` (
    `id_barang` int(11) NOT NULL,
    `nama_barang` varchar(25) NOT NULL,
    `stok` int(11) NOT NULL,
    `harga` varchar(10) NOT NULL,
    `gambar` varchar(25) NOT NULL,
    `date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `batal` varchar(3) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `keranjang`
  --
  
  CREATE TABLE `keranjang` (
    `id_keranjang` int(11) NOT NULL,
    `id_user` int(11) NOT NULL,
    `tanggal` varchar(25) NOT NULL,
    `jumlah` varchar(25) NOT NULL,
    `alamat` varchar(25) NOT NULL,
    `id_barang` int(11) NOT NULL,
    `gambar` varchar(25) NOT NULL,
    `batal` varchar(5) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `sub_transaksi`
  --
  
  CREATE TABLE `sub_transaksi` (
    `id_subtransaksi` int(11) NOT NULL,
    `id_barang` int(11) NOT NULL,
    `id_transaksi` int(11) NOT NULL,
    `alamat` varchar(25) NOT NULL,
    `jumlah_beli` int(11) NOT NULL,
    `total_harga` varchar(20) NOT NULL,
    `date` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tempo`
  --
  
  CREATE TABLE `tempo` (
    `id_subtransaksi` int(11) NOT NULL,
    `id_barang` int(11) NOT NULL,
    `jumlah_beli` int(11) NOT NULL,
    `total_harga` varchar(20) NOT NULL,
    `trx` varchar(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `transaksi`
  --
  
  CREATE TABLE `transaksi` (
    `id_transaksi` int(11) NOT NULL,
    `id_user` varchar(25) NOT NULL,
    `nama_barang` varchar(20) NOT NULL,
    `no_tlp` int(15) NOT NULL,
    `total_bayar` varchar(20) NOT NULL,
    `id_keranjang` int(11) NOT NULL,
    `id_barang` int(11) NOT NULL,
    `gambar` varchar(25) NOT NULL,
    `harga` varchar(25) NOT NULL,
    `jumlah_barang` varchar(11) NOT NULL,
    `alamat` varchar(25) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `transaksi`
  --
  
  INSERT INTO `transaksi` (`id_transaksi`, `id_user`, `nama_barang`, `no_tlp`, `total_bayar`, `id_keranjang`, `id_barang`, `gambar`, `harga`, `jumlah_barang`, `alamat`) VALUES
  (8, '15', '-', 0, '', 0, 0, '-', '-', '', ''),
  (9, '16', '-', 0, '', 0, 0, '-', '-', '', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user`
  --
  
  CREATE TABLE `user` (
    `id_user` int(11) NOT NULL,
    `nama` varchar(25) NOT NULL,
    `alamat` varchar(25) NOT NULL,
    `email` varchar(25) NOT NULL,
    `gambar` varchar(45) NOT NULL,
    `password` varchar(45) NOT NULL,
    `date_created` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `user`
  --
  
  INSERT INTO `user` (`id_user`, `nama`, `alamat`, `email`, `gambar`, `password`, `date_created`) VALUES
  (16, 'MELGA', '', 'melga@gmail.com', 'default.jpg', '85bafba64a51dbcd1ffc6eca1c963be8', 1561637576);
  
  --
  -- 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 `keranjang`
  --
  ALTER TABLE `keranjang`
    ADD PRIMARY KEY (`id_keranjang`);
  
  --
  -- Indexes for table `sub_transaksi`
  --
  ALTER TABLE `sub_transaksi`
    ADD PRIMARY KEY (`id_subtransaksi`);
  
  --
  -- Indexes for table `tempo`
  --
  ALTER TABLE `tempo`
    ADD PRIMARY KEY (`id_subtransaksi`);
  
  --
  -- 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 `admin`
  --
  ALTER TABLE `admin`
    MODIFY `id_admin` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `barang`
  --
  ALTER TABLE `barang`
    MODIFY `id_barang` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `keranjang`
  --
  ALTER TABLE `keranjang`
    MODIFY `id_keranjang` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `sub_transaksi`
  --
  ALTER TABLE `sub_transaksi`
    MODIFY `id_subtransaksi` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `tempo`
  --
  ALTER TABLE `tempo`
    MODIFY `id_subtransaksi` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `transaksi`
  --
  ALTER TABLE `transaksi`
    MODIFY `id_transaksi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
  
  --
  -- AUTO_INCREMENT for table `user`
  --
  ALTER TABLE `user`
    MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
  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 */;
  