Danial HB
26 lines
1.0 KiB
SQL
26 lines
1.0 KiB
SQL
-- SQL Dump for database: spbu_gis
|
|
-- Generated on 2026-06-11T06:55:58.247Z
|
|
|
|
CREATE DATABASE IF NOT EXISTS `spbu_gis`;
|
|
USE `spbu_gis`;
|
|
|
|
DROP TABLE IF EXISTS `locations`;
|
|
CREATE TABLE `locations` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`name` varchar(255) NOT NULL,
|
|
`open_window` varchar(50) NOT NULL,
|
|
`spbu_number` double NOT NULL,
|
|
`lat` double NOT NULL,
|
|
`lng` double NOT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
|
|
-- Dumping data for table `locations`
|
|
INSERT INTO `locations` (`id`, `name`, `open_window`, `spbu_number`, `lat`, `lng`) VALUES
|
|
(1, 'SPBU KH. Ahmad Dahlan', 'not', 123456, -0.03439128192381424, 109.33191418647768),
|
|
(2, 'SPBU MT. Haryono', '24 hours', 56789, -0.04488944548087099, 109.33674216270448),
|
|
(3, 'SPBU Kota Baru', '24 hours', 69420, -0.047818416766280326, 109.31863188743593),
|
|
(4, 'SPBU Tanjungpura', 'not', 6767, -0.03147840341518462, 109.34521794319153),
|
|
(5, 'SPBU Paris 2', '24 hours', 567832, -0.06434081632654041, 109.35622572898866);
|
|
|