142 lines
4.5 KiB
SQL
142 lines
4.5 KiB
SQL
-- phpMyAdmin SQL Dump
|
|
-- version 5.2.1
|
|
-- https://www.phpmyadmin.net/
|
|
--
|
|
-- Host: 127.0.0.1:3307
|
|
-- Waktu pembuatan: 11 Jun 2026 pada 15.19
|
|
-- Versi server: 10.4.32-MariaDB
|
|
-- Versi PHP: 8.2.12
|
|
|
|
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: `spbu_db`
|
|
--
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `garis`
|
|
--
|
|
|
|
CREATE TABLE `garis` (
|
|
`id` int(11) NOT NULL,
|
|
`coordinates` text DEFAULT NULL,
|
|
`status` varchar(50) DEFAULT NULL,
|
|
`panjang` double DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `garis`
|
|
--
|
|
|
|
INSERT INTO `garis` (`id`, `coordinates`, `status`, `panjang`) VALUES
|
|
(4, '[[-0.042614932899552066,109.33897376060487],[-0.042057033576748226,109.33959603309631],[-0.042057033576748226,109.33959603309631]]', 'Kabupaten', 92.93),
|
|
(5, '[[-0.015707015794464818,109.36280250549318],[-0.024976729555612715,109.36254501342775],[-0.02901077146547321,109.36160087585449],[-0.0321006758108682,109.36005592346193],[-0.03424644266299124,109.35670852661133],[-0.03716468550421756,109.3517303466797],[-0.04128455758476972,109.34580802917482],[-0.042057033576748226,109.34494972229005],[-0.04626273606199181,109.34237480163576],[-0.04626273606199181,109.34237480163576]]', 'Provinsi', 4438.68),
|
|
(6, '[[-0.03716468550421756,109.33499336242677],[-0.034332273336096036,109.3383836746216]]', '', 0);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `polygons`
|
|
--
|
|
|
|
CREATE TABLE `polygons` (
|
|
`id` int(11) NOT NULL,
|
|
`coordinates` text DEFAULT NULL,
|
|
`status` varchar(50) DEFAULT NULL,
|
|
`luas` double DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `polygons`
|
|
--
|
|
|
|
INSERT INTO `polygons` (`id`, `coordinates`, `status`, `luas`) VALUES
|
|
(1, '[[-0.04107954850956947,109.33617889881135],[-0.04164247166797875,109.3359696865082],[-0.04186764093026616,109.33652758598329],[-0.04134224598402135,109.33674216270448],[-0.04131007894636634,109.33674216270448]]', 'HGB', 4522.78),
|
|
(2, '{\"type\":\"Polygon\",\"coordinates\":[[[109.33680653572083,-0.04155339471819016],[109.33666706085206,-0.04182145336393277],[109.33696746826173,-0.04200373324252326],[109.33707475662233,-0.0417463969431915]]]}', NULL, NULL),
|
|
(3, '[[-0.04349469720803964,109.34812545776369],[-0.04461049582840643,109.34726715087892],[-0.04619836306659037,109.34941291809082],[-0.04510402213589856,109.3502712249756]]', NULL, NULL);
|
|
|
|
-- --------------------------------------------------------
|
|
|
|
--
|
|
-- Struktur dari tabel `spbu`
|
|
--
|
|
|
|
CREATE TABLE `spbu` (
|
|
`id` int(11) NOT NULL,
|
|
`nama` varchar(100) DEFAULT NULL,
|
|
`no_hp` varchar(20) DEFAULT NULL,
|
|
`buka_24jam` varchar(10) DEFAULT NULL,
|
|
`ramai` varchar(10) DEFAULT NULL,
|
|
`lat` double DEFAULT NULL,
|
|
`lng` double DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
|
|
|
--
|
|
-- Dumping data untuk tabel `spbu`
|
|
--
|
|
|
|
INSERT INTO `spbu` (`id`, `nama`, `no_hp`, `buka_24jam`, `ramai`, `lat`, `lng`) VALUES
|
|
(1, 'SPBU 1', '001', 'Tidak', 'Ya', -0.044906177737876, 109.3367421627),
|
|
(2, 'SPBU Imam Bonjol', '002', 'Ya', 'Ya', -0.046984846560675, 109.35455739498),
|
|
(3, 'SPBU Paris 1', '003', 'Ya', 'Ya', -0.055442708104727, 109.36264157295),
|
|
(4, 'SPBU Ahmad Yani', '004', 'Tidak', 'Ya', -0.064348204151511, 109.35621500015);
|
|
|
|
--
|
|
-- Indexes for dumped tables
|
|
--
|
|
|
|
--
|
|
-- Indeks untuk tabel `garis`
|
|
--
|
|
ALTER TABLE `garis`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `polygons`
|
|
--
|
|
ALTER TABLE `polygons`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- Indeks untuk tabel `spbu`
|
|
--
|
|
ALTER TABLE `spbu`
|
|
ADD PRIMARY KEY (`id`);
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel yang dibuang
|
|
--
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `garis`
|
|
--
|
|
ALTER TABLE `garis`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `polygons`
|
|
--
|
|
ALTER TABLE `polygons`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
|
|
|
|
--
|
|
-- AUTO_INCREMENT untuk tabel `spbu`
|
|
--
|
|
ALTER TABLE `spbu`
|
|
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
|
|
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 */;
|