text: -- phpMyAdmin SQL Dump
  -- version 4.0.4.1
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jan 28, 2021 at 06:45 AM
  -- Server version: 5.5.32
  -- PHP Version: 5.4.19
  
  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: `db_jual`
  --
  CREATE DATABASE IF NOT EXISTS `db_jual` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `db_jual`;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `penjualan`
  --
  
  CREATE TABLE IF NOT EXISTS `penjualan` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama_roti` varchar(255) DEFAULT NULL,
    `jumlah` varchar(255) DEFAULT NULL,
    `harga` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_daftar`
  --
  
  CREATE TABLE IF NOT EXISTS `tbl_daftar` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `kode_roti` varchar(255) DEFAULT NULL,
    `nama_roti` varchar(255) DEFAULT NULL,
    `jenis_roti` varchar(255) DEFAULT NULL,
    `jumlah` varchar(11) DEFAULT NULL,
    `tgl` date DEFAULT NULL,
    `harga` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
  
  --
  -- Dumping data for table `tbl_daftar`
  --
  
  INSERT INTO `tbl_daftar` (`id`, `kode_roti`, `nama_roti`, `jenis_roti`, `jumlah`, `tgl`, `harga`) VALUES
  (1, 'A-001', 'Cupcake', 'Cup', '2', NULL, '5000'),
  (2, 'A-002', 'Banana Cookies', 'Panggang', '3', NULL, '4500'),
  (4, 'A-003', 'Bolu Kukus', 'Kukus', '5', NULL, '20000');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `user`
  --
  
  CREATE TABLE IF NOT EXISTS `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) DEFAULT NULL,
    `paswd` varchar(255) DEFAULT NULL,
    `email` varchar(255) DEFAULT NULL,
    `nama` varchar(255) DEFAULT NULL,
    `level` varchar(255) DEFAULT NULL,
    `ket` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
  
  --
  -- Dumping data for table `user`
  --
  
  INSERT INTO `user` (`id`, `username`, `paswd`, `email`, `nama`, `level`, `ket`) VALUES
  (1, 'Amri', '202cb962ac59075b964b07152d234b70', 'amri12@gmail.com', 'Amri', '1', 'aktif');
  
  /*!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 */;
  