   `nama` varchar(20) NOT NULL
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 
---
--- Dumping data for table `komentar_event`
---
-
-INSERT INTO `komentar_event` (`id_komentar`, `id_user`, `komentar`, `tgl_komentar`, `id_event`, `nama`) VALUES
-(1, 0, 'aku paling suka ini', '2017-04-27 06:14:08', 2, 'kemal'),
-(2, 0, 'ini paling seru deh', '2017-05-01 05:26:15', 2, 'reza saputra'),
-(3, 0, 'asudahlah', '2017-05-01 06:42:37', 1, 'admin');
-
--- --------------------------------------------------------
-
---
--- Table structure for table `komentar_penginapan`
+-- --------------------------------------------------------
+
+--
+-- Struktur dari tabel `komentar_penginapan`
 --
 
 CREATE TABLE `komentar_penginapan` (

  `nama_penginapan` varchar(100) NOT NULL,
  `alamat_penginapan` varchar(150) NOT NULL,
  `daerah_penginapan` varchar(150) NOT NULL,
  `ket_penginapan` varchar(150) NOT NULL,
  `harga_penginapan` int(10) NOT NULL,
  `long_penginapan` varchar(100) NOT NULL,
  `lat_penginapan` varchar(100) NOT NULL,

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`id_user`, `username`, `password`, `role`, `email`, `domisili`, `asal_daerah`, `no_hp_user`, `jk`, `nama_lengkap`) VALUES
(20, 'ajengpursita', '43317d3fd0d3344a7152250b9fd0dc2f', 'User', 'pursitasariajeng2@gmail.com', 'Bandung', 'Bekasi', '082240206708', 'Perempuan', 'Ajeng Pursitasari'),
(21, 'ivo', '20e04899c46cd16355f0f2ca77fa83b9', 'User', 'ivo@gmail.com', 'Bandung', 'Cirebon', '081222287583', 'Perempuan', 'Ivo Auliannisa S S'),
(22, 'sanah', '138d3ab7fedb3af29c9fa9dca7bcf8da', 'user', 'sanahsiz@gmail.com', 'Bandung', 'Jambi', '082374123515', 'Perempuan', 'Nurhasanah'),
(23, 'dimaspp', '2d1f04d16999e6831a24401efedda1d2', 'User', 'dimaspp@gmail.com', 'Bandung', 'Bekasi', '082240207809', 'Laki-Laki', 'Dimas Putra Pamungkas'),
(24, 'hafiya', '49ca10e1c37672a136ab1d89417fb77b', 'User', 'hafiya@gmail.com', 'Bandung', 'Bandung', '08936823632', 'Perempuan', 'Hafiya');

--
-- Indexes for dumped tables
