-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `kos`
--

CREATE TABLE `kos` (
  `id_kos` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `nama_kos` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `pemilik` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `alamat` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `lokasi` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `kontak` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `harga` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `foto` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `fasilitas` varchar(5000) COLLATE utf8_unicode_ci NOT NULL,
  `tanggal` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `kos`
--

INSERT INTO `kos` (`id_kos`, `uid`, `nama_kos`, `pemilik`, `alamat`, `lokasi`, `kontak`, `harga`, `foto`, `fasilitas`, `tanggal`) VALUES
(4, 909, 'Kos Putri', 'Bapak Fadly', 'Jl. BTN Kanawa Poka ', '-3.646643344267842,128.19014254957438', '082195663076', '600.000', '361253253.jpg', '1. Kamar 3x3 \n2. Tersedia Air dan Listrik', '2022-11-05 02:14:18'),
(5, 909, 'Kos Ilfareba ', 'Ibu Ilda ', 'Jl. BTN Kanawa, Poka, Kec. Sirimau, Kota Ambon, Maluku', '-3.646656393561949,128.19015428423882', '082233971205', '400.000', '1694665553.jpg', '1. Kamar 3x3 \n2. Free air dan listrik ', '2022-11-05 17:32:03'),
(6, 909, 'Kos Eva', 'Ibu Neng', 'Jl.Aster Hative kecil, RT 01 RW 05', '-3.670952511565694,128.20120431482792', '081344201007', '800.000', '1736953614.jpg', '1. Kamar 3x3 (di lengkapi kamar mandi dan dapur)\n2. Springbad\n3. Free Wifi\n4. Area parkir motor', '2022-11-05 02:14:18'),
(8, 909, 'Kos R3', 'Bapak Ical ', 'Jl. Pasar Rumah Tiga, Belakang Toko Aneka Guna ', '-3.660019774970417,128.19212906062603', '082199234301', '600.000-675.000', '531569027.jpg', '1. Kamar ukuran 3x3\n2. Washtafel\n3. Tempat tidur + Kasur/Springbed ', '2022-11-13 19:07:00'),
(9, 897, 'Rita', 'Rayyan', 'Dr. Sitanala No.80, Kel Wainitu, Kec. Nusaniwe, Kota Ambon, Maluku 97115', '-3.701913427898462,128.17476276308298', '0821-3047-7438', '600.000', '624317577.jpg', '1. Kamar 3×3\n2. pulsa listrik\n3. Kamar Mandi Umum (Air kran)', '2022-11-15 15:36:43');

--
-- Indexes for table `kos`
--
ALTER TABLE `kos`
  ADD PRIMARY KEY (`id_kos`);

--
-- AUTO_INCREMENT for table `kos`
--
ALTER TABLE `kos`
  MODIFY `id_kos` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
COMMIT;

