27 lines
992 B
SQL
27 lines
992 B
SQL
-- Database dan tabel aplikasi WebGIS
|
|
CREATE DATABASE IF NOT EXISTS `03_webgisdb`
|
|
CHARACTER SET utf8mb4
|
|
COLLATE utf8mb4_general_ci;
|
|
|
|
USE `03_webgisdb`;
|
|
|
|
CREATE TABLE IF NOT EXISTS `jalan` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`nama_jalan` VARCHAR(150) NOT NULL,
|
|
`status_jalan` ENUM('nasional','provinsi','kabupaten') NOT NULL,
|
|
`panjang_meter` DOUBLE NOT NULL,
|
|
`geojson` LONGTEXT NOT NULL,
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE IF NOT EXISTS `parsil_tanah` (
|
|
`id` INT AUTO_INCREMENT PRIMARY KEY,
|
|
`nama_parsil` VARCHAR(150) NOT NULL,
|
|
`status_kepemilikan` ENUM('SHM','HGB','HGU','HP') NOT NULL,
|
|
`luas_meter` DOUBLE NOT NULL,
|
|
`geojson` LONGTEXT NOT NULL,
|
|
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|