21 lines
787 B
SQL
21 lines
787 B
SQL
-- 1. Buat database dan gunakan
|
|
CREATE DATABASE IF NOT EXISTS webgis_spbu;
|
|
USE webgis_spbu;
|
|
|
|
-- 2. Buat tabel t_spbu
|
|
CREATE TABLE IF NOT EXISTS t_spbu (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama_spbu VARCHAR(255) NOT NULL,
|
|
latitude DECIMAL(10,6) NOT NULL,
|
|
longitude DECIMAL(10,6) NOT NULL,
|
|
status ENUM('24_jam','reguler') NOT NULL
|
|
);
|
|
|
|
-- 3. Data sampel SPBU Pontianak
|
|
INSERT INTO t_spbu (nama_spbu, latitude, longitude, status) VALUES
|
|
('SPBU 24 Jam Jl. Ahmad Yani', -0.020124, 109.341212, '24_jam'),
|
|
('SPBU 24 Jam Jl. Teuku Umar', -0.030689, 109.331485, '24_jam'),
|
|
('SPBU 24 Jam Jl. Jenderal Sudirman', -0.032510, 109.343810, '24_jam'),
|
|
('SPBU Reguler Jl. Gajah Mada', -0.025560, 109.352930, 'reguler'),
|
|
('SPBU Reguler Jl. Pahlawan', -0.019450, 109.348100, 'reguler');
|