34 lines
1.2 KiB
SQL
34 lines
1.2 KiB
SQL
-- ============================================================
|
|
-- schema.sql
|
|
-- Jalankan query ini di phpMyAdmin atau MySQL CLI Laragon
|
|
-- untuk membuat database dan tabel project 04
|
|
-- ============================================================
|
|
|
|
-- Buat database (jika belum ada)
|
|
CREATE DATABASE IF NOT EXISTS `04_spbudb`
|
|
CHARACTER SET utf8mb4
|
|
COLLATE utf8mb4_unicode_ci;
|
|
|
|
-- Gunakan database yang baru dibuat
|
|
USE `04_spbudb`;
|
|
|
|
-- Hapus tabel jika sudah ada (untuk reset bersih)
|
|
DROP TABLE IF EXISTS `spbu`;
|
|
|
|
-- Buat tabel spbu
|
|
CREATE TABLE `spbu` (
|
|
`id` INT NOT NULL AUTO_INCREMENT,
|
|
`nama_spbu` VARCHAR(100) NOT NULL,
|
|
`status_ramai` ENUM('ramai','tidak_ramai') NOT NULL,
|
|
`buka_24_jam` ENUM('ya','tidak') NOT NULL,
|
|
`status_operasional` ENUM('buka','tutup') NOT NULL,
|
|
`nomor_hp` VARCHAR(20) NOT NULL,
|
|
`latitude` DOUBLE NOT NULL,
|
|
`longitude` DOUBLE NOT NULL,
|
|
`created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB
|
|
DEFAULT CHARSET=utf8mb4
|
|
COLLATE=utf8mb4_unicode_ci;
|