text: -- phpMyAdmin SQL Dump
  -- version 4.8.5
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Sep 28, 2020 at 08:49 AM
  -- Server version: 10.1.39-MariaDB
  -- PHP Version: 7.3.5
  
  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: `rinba_official`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `contact`
  --
  
  CREATE TABLE `contact` (
    `id_contact` int(11) NOT NULL,
    `jenis_contact` varchar(20) NOT NULL,
    `contact` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `contact`
  --
  
  INSERT INTO `contact` (`id_contact`, `jenis_contact`, `contact`) VALUES
  (1, 'Whatsapp', '6281229476730'),
  (2, 'Instagram', 'instagram.com/rinba.official');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kategori`
  --
  
  CREATE TABLE `kategori` (
    `id_kategori` int(11) NOT NULL,
    `nama_kategori` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `kategori`
  --
  
  INSERT INTO `kategori` (`id_kategori`, `nama_kategori`) VALUES
  (1, 'Pakaian'),
  (2, 'Tas'),
  (3, 'Hijab');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `petugas`
  --
  
  CREATE TABLE `petugas` (
    `id_petugas` int(11) NOT NULL,
    `username` varchar(20) NOT NULL,
    `nama_petugas` varchar(30) NOT NULL,
    `password` varchar(50) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `petugas`
  --
  
  INSERT INTO `petugas` (`id_petugas`, `username`, `nama_petugas`, `password`) VALUES
  (1, 'admin_1', 'Rina Budi', 'e10adc3949ba59abbe56e057f20f883e'),
  (5, 'admin_2', 'admin', 'e10adc3949ba59abbe56e057f20f883e');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk`
  --
  
  CREATE TABLE `produk` (
    `id_produk` int(11) NOT NULL,
    `id_kategori` int(11) NOT NULL,
    `nama_produk` varchar(30) NOT NULL,
    `deskripsi_produk` text NOT NULL,
    `gambar_produk_1` varchar(255) NOT NULL,
    `gambar_produk_2` varchar(255) NOT NULL,
    `harga` int(10) NOT NULL,
    `stok` int(10) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `produk`
  --
  
  INSERT INTO `produk` (`id_produk`, `id_kategori`, `nama_produk`, `deskripsi_produk`, `gambar_produk_1`, `gambar_produk_2`, `harga`, `stok`) VALUES
  (1, 1, 'Contoh Produk 1', 'A small river named Duden flows by their place and supplies it with the necessary regelialia. It is a paradisematic country, in which roasted parts of sentences fly into your mouth.\r\n\r\nOn her way she met a copy. The copy warned the Little Blind Text, that where it came from it would have been rewritten a thousand times and everything that was left from its origin would be the word \"and\" and the Little Blind Text should turn around and return to its own, safe country. But nothing the copy said could convince her and so it didn’t take long until a few insidious Copy Writers ambushed her, made her drunk with Longe and Parole and dragged her into their agency, where they abused her for their.', 'Rinba_Official.png', 'no_image.jpg', 300000000, 0),
  (2, 2, 'Contoh Produk 2', '-', 'no_image.jpg', 'no_image.jpg', 3000, 2),
  (3, 2, 'Sample Produk 3', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (4, 3, 'Contoh Produk 4', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (5, 3, 'Sample Produk 5', '-', 'no_image.jpg', 'no_image.jpg', 6000, 2),
  (6, 3, 'Sample Produk 6', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 0),
  (7, 3, 'Sample Produk 7', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (8, 3, 'Sample Produk 8', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (9, 3, 'Sample Produk 9', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (10, 3, 'Sample Produk 10', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (11, 3, 'Sample Produk 11', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2),
  (12, 3, 'Sample Produk 12', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 0),
  (29, 3, 'Sample Produk 13', '-', 'no_image.jpg', 'no_image.jpg', 300000000, 2);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `contact`
  --
  ALTER TABLE `contact`
    ADD PRIMARY KEY (`id_contact`);
  
  --
  -- Indexes for table `kategori`
  --
  ALTER TABLE `kategori`
    ADD PRIMARY KEY (`id_kategori`);
  
  --
  -- Indexes for table `petugas`
  --
  ALTER TABLE `petugas`
    ADD PRIMARY KEY (`id_petugas`);
  
  --
  -- Indexes for table `produk`
  --
  ALTER TABLE `produk`
    ADD PRIMARY KEY (`id_produk`),
    ADD KEY `id_kategori` (`id_kategori`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `contact`
  --
  ALTER TABLE `contact`
    MODIFY `id_contact` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `kategori`
  --
  ALTER TABLE `kategori`
    MODIFY `id_kategori` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `petugas`
  --
  ALTER TABLE `petugas`
    MODIFY `id_petugas` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `produk`
  --
  ALTER TABLE `produk`
    MODIFY `id_produk` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `produk`
  --
  ALTER TABLE `produk`
    ADD CONSTRAINT `produk_ibfk_1` FOREIGN KEY (`id_kategori`) REFERENCES `kategori` (`id_kategori`);
  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 */;
  