final_db_fix.php

<?php
require_once 'config/database.php';

// 1. Add nama column to users table if not exists
$check_sql = "SHOW COLUMNS FROM users LIKE 'nama'";
$result = mysqli_query($conn, $check_sql);
if (mysqli_num_rows($result) == 0) {
    $alter_sql = "ALTER TABLE users ADD COLUMN nama VARCHAR(255) AFTER id";
    if (mysqli_query($conn, $alter_sql)) {
        echo "Column 'nama' added to 'users' table.\n";
    } else {
        echo "Error adding column: " . mysqli_error($conn) . "\n";
    }
} else {
    echo "Column 'nama' already exists.\n";
}

// 2. Ensure role enum is complete
$alter_role = "ALTER TABLE users MODIFY COLUMN role ENUM('admin', 'mahasiswa', 'dosen', 'kaprodi', 'dekan') DEFAULT 'mahasiswa'";
mysqli_query($conn, $alter_role);

// 3. Ensure rekomendasi table exists
$sql_rekomendasi = "CREATE TABLE IF NOT EXISTS rekomendasi (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    skill_id INT NOT NULL,
    skor_rekomendasi INT NOT NULL,
    alasan TEXT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (skill_id) REFERENCES skills(id) ON DELETE CASCADE
)";
mysqli_query($conn, $sql_rekomendasi);

echo "Database maintenance complete.\n";
?>