text: -- phpMyAdmin SQL Dump
  -- version 4.5.1
  -- http://www.phpmyadmin.net
  --
  -- Host: 127.0.0.1
  -- Generation Time: 21 Sep 2018 pada 06.23
  -- Versi Server: 10.1.8-MariaDB
  -- PHP Version: 5.6.14
  
  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 utf8mb4 */;
  
  --
  -- Database: `ijenfunjava`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `destinasi`
  --
  
  CREATE TABLE `destinasi` (
    `id_destinasi` int(11) NOT NULL,
    `in_nama_destinasi` varchar(100) NOT NULL,
    `en_nama_destinasi` varchar(100) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `detail_paket`
  --
  
  CREATE TABLE `detail_paket` (
    `id_detail_paket` int(11) NOT NULL,
    `id_paket` int(11) NOT NULL,
    `in_deskripsi` text NOT NULL,
    `en_deskripsi` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `fasilitas`
  --
  
  CREATE TABLE `fasilitas` (
    `id_fasilitas` int(11) NOT NULL,
    `in_list_fasilitas` text NOT NULL,
    `en_list_fasilitas` text NOT NULL,
    `id_paket` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `list_harga`
  --
  
  CREATE TABLE `list_harga` (
    `id_list_harga` int(11) NOT NULL,
    `harga` varchar(20) NOT NULL,
    `id_paket` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `paket`
  --
  
  CREATE TABLE `paket` (
    `id_paket` int(11) NOT NULL,
    `in_nama_paket` varchar(100) NOT NULL,
    `en_nama_paket` varchar(100) NOT NULL,
    `gambar` text NOT NULL,
    `id_destinasi` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `rencana_perjalanan`
  --
  
  CREATE TABLE `rencana_perjalanan` (
    `id_rencana_perjalalan` int(11) NOT NULL,
    `id_paket` int(11) NOT NULL,
    `in_rencana_perjalanan` text NOT NULL,
    `en_rencana_perjalanan` text NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `destinasi`
  --
  ALTER TABLE `destinasi`
    ADD PRIMARY KEY (`id_destinasi`);
  
  --
  -- Indexes for table `detail_paket`
  --
  ALTER TABLE `detail_paket`
    ADD PRIMARY KEY (`id_detail_paket`);
  
  --
  -- Indexes for table `fasilitas`
  --
  ALTER TABLE `fasilitas`
    ADD PRIMARY KEY (`id_fasilitas`);
  
  --
  -- Indexes for table `list_harga`
  --
  ALTER TABLE `list_harga`
    ADD PRIMARY KEY (`id_list_harga`);
  
  --
  -- Indexes for table `paket`
  --
  ALTER TABLE `paket`
    ADD PRIMARY KEY (`id_paket`);
  
  --
  -- Indexes for table `rencana_perjalanan`
  --
  ALTER TABLE `rencana_perjalanan`
    ADD PRIMARY KEY (`id_rencana_perjalalan`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `destinasi`
  --
  ALTER TABLE `destinasi`
    MODIFY `id_destinasi` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `detail_paket`
  --
  ALTER TABLE `detail_paket`
    MODIFY `id_detail_paket` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `fasilitas`
  --
  ALTER TABLE `fasilitas`
    MODIFY `id_fasilitas` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `list_harga`
  --
  ALTER TABLE `list_harga`
    MODIFY `id_list_harga` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `paket`
  --
  ALTER TABLE `paket`
    MODIFY `id_paket` int(11) NOT NULL AUTO_INCREMENT;
  --
  -- AUTO_INCREMENT for table `rencana_perjalanan`
  --
  ALTER TABLE `rencana_perjalanan`
    MODIFY `id_rencana_perjalalan` int(11) NOT NULL AUTO_INCREMENT;
  /*!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 */;
  