luthfihadinugroho79
47 lines
1.9 KiB
SQL
47 lines
1.9 KiB
SQL
-- ============================================================
|
|
-- Schema MySQL untuk WebGIS SPBU Pontianak
|
|
-- ============================================================
|
|
-- CARA PAKAI:
|
|
-- 1. Buka phpMyAdmin
|
|
-- 2. Pilih database "data_spbu" (atau buat baru jika belum ada)
|
|
-- 3. Klik tab "SQL"
|
|
-- 4. Copy-paste seluruh isi file ini, lalu klik "Go"
|
|
-- ============================================================
|
|
|
|
-- CATATAN: nama tabel sengaja dibuat "tbl_spbu" (bukan "data_spbu")
|
|
-- karena MySQL tidak boleh memiliki nama tabel sama dengan nama database
|
|
-- (menyebabkan error errno: 121)
|
|
|
|
CREATE DATABASE IF NOT EXISTS `data_spbu`
|
|
CHARACTER SET utf8mb4
|
|
COLLATE utf8mb4_unicode_ci;
|
|
|
|
USE `data_spbu`;
|
|
|
|
-- Hapus tabel lama jika ada
|
|
DROP TABLE IF EXISTS `tbl_spbu`;
|
|
DROP TABLE IF EXISTS `data_spbu`;
|
|
|
|
-- Buat tabel dengan nama tbl_spbu
|
|
CREATE TABLE `tbl_spbu` (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama_spbu VARCHAR(255) NOT NULL,
|
|
no_wa VARCHAR(20) NOT NULL,
|
|
status_24_jam ENUM('yes','no') DEFAULT 'no',
|
|
lat DOUBLE NOT NULL,
|
|
lng DOUBLE NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
|
|
|
|
-- Data contoh
|
|
INSERT INTO `tbl_spbu` (nama_spbu, no_wa, status_24_jam, lat, lng) VALUES
|
|
('SPBU Jl. Ahmad Yani', '08123456789', 'yes', -0.0202, 109.3423),
|
|
('SPBU Jl. Gajah Mada', '08234567890', 'no', -0.0280, 109.3310),
|
|
('SPBU Sui Raya', '08345678901', 'yes', -0.0450, 109.3580),
|
|
('SPBU Jl. Tanjungpura', '08456789012', 'no', -0.0120, 109.3390),
|
|
('SPBU Jl. Imam Bonjol', '08567890123', 'yes', -0.0330, 109.3500),
|
|
('SPBU Siantan', '08678901234', 'no', 0.0050, 109.3350);
|
|
|
|
-- Cek hasil
|
|
SELECT 'Tabel tbl_spbu berhasil dibuat!' AS status, COUNT(*) AS jumlah_data FROM `tbl_spbu`;
|