text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jun 29, 2021 at 03:20 PM
  -- Server version: 10.4.13-MariaDB
  -- PHP Version: 7.2.31
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `dalak`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `kontak`
  --
  
  CREATE TABLE `kontak` (
    `id` int(11) NOT NULL,
    `email` varchar(250) NOT NULL,
    `noTelp` int(50) NOT NULL,
    `pesan` varchar(250) NOT NULL,
    `nama` varchar(250) NOT NULL,
    `alamat` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `peluanginvestasi`
  --
  
  CREATE TABLE `peluanginvestasi` (
    `idPeluangInvestasi` int(11) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `file` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `peluanginvestasi`
  --
  
  INSERT INTO `peluanginvestasi` (`idPeluangInvestasi`, `namaFile`, `file`) VALUES
  (1, 'Junico', '1.pdf');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `potensi_investasi`
  --
  
  CREATE TABLE `potensi_investasi` (
    `id` int(11) NOT NULL,
    `namaPotensi` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `potensi_investasi`
  --
  
  INSERT INTO `potensi_investasi` (`id`, `namaPotensi`, `namaFile`, `judul`, `caption`) VALUES
  (1, 'Kopi', 'junico.pdf', 'blabla', 'kopi sangat manis');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_bupati`
  --
  
  CREATE TABLE `produk_hukum_bupati` (
    `id` int(11) NOT NULL,
    `namaBupati` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_daerah`
  --
  
  CREATE TABLE `produk_hukum_daerah` (
    `id` int(11) NOT NULL,
    `namaDaerah` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_lainnya`
  --
  
  CREATE TABLE `produk_hukum_lainnya` (
    `id` int(11) NOT NULL,
    `namaLainnya` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_menteri`
  --
  
  CREATE TABLE `produk_hukum_menteri` (
    `id` int(11) NOT NULL,
    `namaMenteri` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_pemerintah`
  --
  
  CREATE TABLE `produk_hukum_pemerintah` (
    `id` int(11) NOT NULL,
    `namaPemerintah` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `produk_hukum_undang`
  --
  
  CREATE TABLE `produk_hukum_undang` (
    `id` int(11) NOT NULL,
    `namaUndang` varchar(250) NOT NULL,
    `namaFile` int(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_infrastruktur`
  --
  
  CREATE TABLE `profile_infrastruktur` (
    `id` int(11) NOT NULL,
    `namaInfrastruktur` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_jarak_tempuh`
  --
  
  CREATE TABLE `profile_jarak_tempuh` (
    `id` int(11) NOT NULL,
    `namaJarak` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_jumlah_penduduk`
  --
  
  CREATE TABLE `profile_jumlah_penduduk` (
    `id` int(11) NOT NULL,
    `namaJumlah` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_ketenagakerjaan`
  --
  
  CREATE TABLE `profile_ketenagakerjaan` (
    `id` int(11) NOT NULL,
    `namaKetenagakerjaan` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_kondisi_umum`
  --
  
  CREATE TABLE `profile_kondisi_umum` (
    `id` int(11) NOT NULL,
    `namaKondisi` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `profile_kondisi_umum`
  --
  
  INSERT INTO `profile_kondisi_umum` (`id`, `namaKondisi`, `namaFile`, `judul`, `caption`) VALUES
  (1, 'Hujan', 'Kopi.pdf', 'Kopi Semendo', 'Sangat Nikmat');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_pariwisata`
  --
  
  CREATE TABLE `profile_pariwisata` (
    `id` int(11) NOT NULL,
    `namaPariwisata` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile_umk`
  --
  
  CREATE TABLE `profile_umk` (
    `id` int(11) NOT NULL,
    `namaUmk` varchar(250) NOT NULL,
    `namaFile` varchar(250) NOT NULL,
    `judul` varchar(250) NOT NULL,
    `caption` varchar(250) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `realisasiinvestasi`
  --
  
  CREATE TABLE `realisasiinvestasi` (
    `idrealisasiinvestasi` int(11) NOT NULL,
    `judulrealisasiinvestasi` varchar(255) NOT NULL,
    `namafilerealisasiinvestasi` varchar(255) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `realisasiinvestasi`
  --
  
  INSERT INTO `realisasiinvestasi` (`idrealisasiinvestasi`, `judulrealisasiinvestasi`, `namafilerealisasiinvestasi`) VALUES
  (1, 'Grafik Realisasi Investasi PMA & PDMN Triwulan I 2019', '1.pdf'),
  (2, 'Grafik Realisasi Investasi PMA & PDMN Triwulan II 2019', 'Sistem_Pendukung_Keputusan_Pemilihan_Karyawan_Terb.pdf'),
  (5, 'Grafik Realisasi Investasi PMA & PDMN Triwulan II 2019', 'Sistem_Pendukung_Keputusan_Pemilihan_Karyawan_Terb.pdf'),
  (7, 'Grafik Realisasi Investasi PMA & PDMN Triwulan II 2020', '');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `tbl_user`
  --
  
  CREATE TABLE `tbl_user` (
    `id_user` int(11) NOT NULL,
    `nama` varchar(250) NOT NULL,
    `username` varchar(250) NOT NULL,
    `password` varchar(250) NOT NULL,
    `role_id` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  --
  -- Dumping data for table `tbl_user`
  --
  
  INSERT INTO `tbl_user` (`id_user`, `nama`, `username`, `password`, `role_id`) VALUES
  (2, 'junico', 'junico', '21232f297a57a5a743894a0e4a801fc3', 1);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `kontak`
  --
  ALTER TABLE `kontak`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `peluanginvestasi`
  --
  ALTER TABLE `peluanginvestasi`
    ADD PRIMARY KEY (`idPeluangInvestasi`);
  
  --
  -- Indexes for table `potensi_investasi`
  --
  ALTER TABLE `potensi_investasi`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_bupati`
  --
  ALTER TABLE `produk_hukum_bupati`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_daerah`
  --
  ALTER TABLE `produk_hukum_daerah`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_lainnya`
  --
  ALTER TABLE `produk_hukum_lainnya`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_menteri`
  --
  ALTER TABLE `produk_hukum_menteri`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_pemerintah`
  --
  ALTER TABLE `produk_hukum_pemerintah`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `produk_hukum_undang`
  --
  ALTER TABLE `produk_hukum_undang`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_infrastruktur`
  --
  ALTER TABLE `profile_infrastruktur`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_jarak_tempuh`
  --
  ALTER TABLE `profile_jarak_tempuh`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_jumlah_penduduk`
  --
  ALTER TABLE `profile_jumlah_penduduk`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_ketenagakerjaan`
  --
  ALTER TABLE `profile_ketenagakerjaan`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_kondisi_umum`
  --
  ALTER TABLE `profile_kondisi_umum`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_pariwisata`
  --
  ALTER TABLE `profile_pariwisata`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile_umk`
  --
  ALTER TABLE `profile_umk`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `realisasiinvestasi`
  --
  ALTER TABLE `realisasiinvestasi`
    ADD PRIMARY KEY (`idrealisasiinvestasi`);
  
  --
  -- Indexes for table `tbl_user`
  --
  ALTER TABLE `tbl_user`
    ADD PRIMARY KEY (`id_user`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `kontak`
  --
  ALTER TABLE `kontak`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `peluanginvestasi`
  --
  ALTER TABLE `peluanginvestasi`
    MODIFY `idPeluangInvestasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `potensi_investasi`
  --
  ALTER TABLE `potensi_investasi`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_bupati`
  --
  ALTER TABLE `produk_hukum_bupati`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_daerah`
  --
  ALTER TABLE `produk_hukum_daerah`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_lainnya`
  --
  ALTER TABLE `produk_hukum_lainnya`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_menteri`
  --
  ALTER TABLE `produk_hukum_menteri`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_pemerintah`
  --
  ALTER TABLE `produk_hukum_pemerintah`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `produk_hukum_undang`
  --
  ALTER TABLE `produk_hukum_undang`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_infrastruktur`
  --
  ALTER TABLE `profile_infrastruktur`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_jarak_tempuh`
  --
  ALTER TABLE `profile_jarak_tempuh`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_jumlah_penduduk`
  --
  ALTER TABLE `profile_jumlah_penduduk`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_ketenagakerjaan`
  --
  ALTER TABLE `profile_ketenagakerjaan`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_kondisi_umum`
  --
  ALTER TABLE `profile_kondisi_umum`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `profile_pariwisata`
  --
  ALTER TABLE `profile_pariwisata`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `profile_umk`
  --
  ALTER TABLE `profile_umk`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `realisasiinvestasi`
  --
  ALTER TABLE `realisasiinvestasi`
    MODIFY `idrealisasiinvestasi` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `tbl_user`
  --
  ALTER TABLE `tbl_user`
    MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  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 */;
  