18 lines
649 B
SQL
18 lines
649 B
SQL
CREATE DATABASE IF NOT EXISTS db_spbu;
|
|
USE db_spbu;
|
|
|
|
CREATE TABLE IF NOT EXISTS `spbu` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`nama_spbu` varchar(100) NOT NULL,
|
|
`no_wa` varchar(20) NOT NULL,
|
|
`status` enum('yes','no') NOT NULL DEFAULT 'no',
|
|
`latitude` double NOT NULL,
|
|
`longitude` double NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
INSERT INTO `spbu` (`nama_spbu`, `no_wa`, `status`, `latitude`, `longitude`) VALUES
|
|
('SPBU Gajah Mada', '08115700101', 'yes', -0.0227, 109.3294),
|
|
('SPBU Ahmad Yani', '08115700102', 'no', -0.0350, 109.3350),
|
|
('SPBU Tanjungpura', '08115700103', 'yes', -0.0180, 109.3410);
|