29 lines
1.1 KiB
PHP
29 lines
1.1 KiB
PHP
<?php
|
|
require_once 'config.php';
|
|
$db = getDB();
|
|
|
|
$queries = [
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN tanggal_lahir DATE NULL AFTER nama_pelapor",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN pendidikan VARCHAR(50) NULL AFTER tanggal_lahir",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN riwayat_penyakit VARCHAR(255) NULL AFTER pendidikan",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN skor_penghasilan INT NULL AFTER riwayat_penyakit",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN skor_rumah INT NULL AFTER skor_penghasilan",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN skor_makan INT NULL AFTER skor_rumah",
|
|
"ALTER TABLE laporan_masyarakat ADD COLUMN jumlah_kk INT DEFAULT 1 AFTER skor_makan"
|
|
];
|
|
|
|
foreach ($queries as $q) {
|
|
try {
|
|
if ($db->query($q)) {
|
|
echo "Success: $q\n<br>";
|
|
} else {
|
|
echo "Error/Skipped (might already exist): " . $db->error . " | Query: $q\n<br>";
|
|
}
|
|
} catch (Exception $e) {
|
|
echo "Exception/Skipped: " . $e->getMessage() . " | Query: $q\n<br>";
|
|
}
|
|
}
|
|
$db->close();
|
|
echo "Migration complete.\n";
|
|
?>
|