text: -- --------------------------------------------------------
  -- Host:                         localhost
  -- Server version:               5.7.24 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             10.2.0.5599
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  
  -- Dumping database structure for db_rahmat
  DROP DATABASE IF EXISTS `db_rahmat`;
  CREATE DATABASE IF NOT EXISTS `db_rahmat` /*!40100 DEFAULT CHARACTER SET latin1 */;
  USE `db_rahmat`;
  
  -- Dumping structure for table db_rahmat.bahan_baku
  DROP TABLE IF EXISTS `bahan_baku`;
  CREATE TABLE IF NOT EXISTS `bahan_baku` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(25) NOT NULL,
    `jenis` varchar(20) NOT NULL,
    `harga_satuan` int(11) NOT NULL,
    `stok` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
  
  -- Dumping data for table db_rahmat.bahan_baku: ~1 rows (approximately)
  DELETE FROM `bahan_baku`;
  /*!40000 ALTER TABLE `bahan_baku` DISABLE KEYS */;
  INSERT INTO `bahan_baku` (`id`, `nama`, `jenis`, `harga_satuan`, `stok`) VALUES
  	(1, 'Spon Biasa', 'Busa', 80000, 201);
  /*!40000 ALTER TABLE `bahan_baku` ENABLE KEYS */;
  
  -- Dumping structure for table db_rahmat.barang
  DROP TABLE IF EXISTS `barang`;
  CREATE TABLE IF NOT EXISTS `barang` (
    `id` int(10) DEFAULT NULL,
    `nama` varchar(20) DEFAULT NULL,
    `harga` int(11) DEFAULT NULL,
    `jumlah` int(11) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- Dumping data for table db_rahmat.barang: ~0 rows (approximately)
  DELETE FROM `barang`;
  /*!40000 ALTER TABLE `barang` DISABLE KEYS */;
  /*!40000 ALTER TABLE `barang` ENABLE KEYS */;
  
  -- Dumping structure for table db_rahmat.pengguna
  DROP TABLE IF EXISTS `pengguna`;
  CREATE TABLE IF NOT EXISTS `pengguna` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(20) NOT NULL,
    `username` varchar(20) NOT NULL,
    `password` varchar(20) NOT NULL,
    `email` varchar(30) NOT NULL,
    `level` varchar(20) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
  
  -- Dumping data for table db_rahmat.pengguna: ~5 rows (approximately)
  DELETE FROM `pengguna`;
  /*!40000 ALTER TABLE `pengguna` DISABLE KEYS */;
  INSERT INTO `pengguna` (`id`, `nama`, `username`, `password`, `email`, `level`) VALUES
  	(1, 'Admin', 'admin', '1111', 'iqbal@email.com', 'admin'),
  	(2, 'Kamal', 'kamal', '2222', 'kamal@kamal.com', 'gudang'),
  	(4, 'Wahyu', 'wahyu', '3333', 'asep@mail.com', 'marketing'),
  	(5, 'Esa', 'esa', '4444', 'esa@ea.com', 'produksi'),
  	(6, 'Engkos', 'engkos', '5555', 'engkos@ongkos.com', 'pemasaran');
  /*!40000 ALTER TABLE `pengguna` ENABLE KEYS */;
  
  -- Dumping structure for table db_rahmat.suppliers
  DROP TABLE IF EXISTS `suppliers`;
  CREATE TABLE IF NOT EXISTS `suppliers` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama` varchar(40) NOT NULL,
    `alamat` varchar(50) NOT NULL,
    `no_telp` int(12) NOT NULL,
    `email` text NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
  
  -- Dumping data for table db_rahmat.suppliers: ~1 rows (approximately)
  DELETE FROM `suppliers`;
  /*!40000 ALTER TABLE `suppliers` DISABLE KEYS */;
  INSERT INTO `suppliers` (`id`, `nama`, `alamat`, `no_telp`, `email`) VALUES
  	(2, 'PT.Putra Timur prima spon tangerang', 'Tangerang', 21000000, 'ya@mail.com');
  /*!40000 ALTER TABLE `suppliers` ENABLE KEYS */;
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  