GuavaPopper
29 lines
906 B
SQL
29 lines
906 B
SQL
CREATE DATABASE IF NOT EXISTS webgis_jalan;
|
|
USE webgis_jalan;
|
|
|
|
CREATE TABLE IF NOT EXISTS jalan (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama_jalan VARCHAR(255) NOT NULL,
|
|
status ENUM('Jalan Nasional', 'Jalan Provinsi', 'Jalan Kabupaten') NOT NULL,
|
|
panjang DECIMAL(10, 2) NOT NULL,
|
|
geojson LONGTEXT NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS parsil (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
nama_pemilik VARCHAR(255) NOT NULL,
|
|
status ENUM('SHM', 'HGB', 'HGU', 'HP') NOT NULL,
|
|
luas DECIMAL(12, 2) NOT NULL,
|
|
geojson LONGTEXT NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS titik_rusak (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
keterangan VARCHAR(255) NOT NULL,
|
|
foto_url VARCHAR(255) NOT NULL,
|
|
geojson LONGTEXT NOT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
|
|
);
|