ocabacaa
23 lines
471 B
SQL
23 lines
471 B
SQL
CREATE TABLE spbu (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama_spbu VARCHAR(100),
|
|
alamat TEXT,
|
|
latitude DOUBLE,
|
|
longitude DOUBLE,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
ALTER TABLE spbu
|
|
ADD foto VARCHAR(255);
|
|
|
|
ALTER TABLE spbu
|
|
ADD buka_24_jam TINYINT(1) DEFAULT 0,
|
|
ADD jam_buka TIME,
|
|
ADD jam_tutup TIME;
|
|
|
|
CREATE TABLE objek_peta (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama VARCHAR(100),
|
|
tipe VARCHAR(20),
|
|
geojson LONGTEXT
|
|
); |