noooviiieee
32 lines
1.4 KiB
PHP
32 lines
1.4 KiB
PHP
<?php
|
|
$pdo = new PDO('mysql:host=localhost;dbname=webgis_baru;charset=utf8', 'root', '');
|
|
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
|
|
$sql = "CREATE TABLE IF NOT EXISTS laporan_warga (
|
|
id INT AUTO_INCREMENT PRIMARY KEY,
|
|
pelapor_id INT NOT NULL,
|
|
tipe_laporan ENUM('diri_sendiri','orang_lain') DEFAULT 'orang_lain',
|
|
nama_kk VARCHAR(150) NOT NULL,
|
|
jumlah_anggota INT DEFAULT 1,
|
|
alamat TEXT NOT NULL,
|
|
lat DECIMAL(10,7) DEFAULT 0,
|
|
lng DECIMAL(10,7) DEFAULT 0,
|
|
pekerjaan VARCHAR(100) DEFAULT '',
|
|
keterangan TEXT,
|
|
is_fakir_miskin TINYINT(1) DEFAULT 0,
|
|
is_dhuafa TINYINT(1) DEFAULT 0,
|
|
is_lansia_tunggal TINYINT(1) DEFAULT 0,
|
|
is_anak_yatim TINYINT(1) DEFAULT 0,
|
|
is_korban_bencana TINYINT(1) DEFAULT 0,
|
|
is_disabilitas TINYINT(1) DEFAULT 0,
|
|
status ENUM('menunggu','diverifikasi','ditolak') DEFAULT 'menunggu',
|
|
catatan_admin TEXT,
|
|
warga_id INT DEFAULT NULL,
|
|
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";
|
|
|
|
$pdo->exec($sql);
|
|
echo "OK: Tabel laporan_warga berhasil dibuat!\n";
|
|
echo "Kolom: " . implode(', ', array_column($pdo->query('DESCRIBE laporan_warga')->fetchAll(PDO::FETCH_ASSOC), 'Field')) . "\n";
|