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

START TRANSACTION;



--
-- Database: `id19783951_dbkos`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id_admin` int(11) NOT NULL,
  `username` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(100) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- 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');

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

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id_user` int(11) NOT NULL,
  `nama` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `hp` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
  `alamat_user` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ktp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status_akun` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`id_user`, `nama`, `hp`, `password`, `alamat_user`, `ktp`, `status_akun`) VALUES
(1, 'Angel', '0897', '123', 'waitatiri', '1283726423.jpg', 'Terverifikasi'),
(2, 'Angel', '909', '321', NULL, NULL, NULL),
(3, 'Simra pada', '081344937439', 'Yunabi1720', NULL, NULL, 'Terverifikasi'),
(4, 'Akun Baru', '0853649', '12345', NULL, NULL, 'Terverifikasi'),
(5, 'rahul', '082197961497', 'rahul', NULL, NULL, 'Terverifikasi');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`id_admin`);

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`id_user`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `id_admin` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `id_user` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

