migrate_db.php

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

// 1. Update users table roles
$sql_alter = "ALTER TABLE users MODIFY COLUMN role ENUM('admin', 'mahasiswa', 'dosen', 'kaprodi', 'dekan') DEFAULT 'mahasiswa'";
if (mysqli_query($conn, $sql_alter)) {
    echo "Users table updated successfully.\n";
} else {
    echo "Error updating users table: " . mysqli_error($conn) . "\n";
}

// 2. Create settings table
$sql_settings = "CREATE TABLE IF NOT EXISTS settings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    setting_key VARCHAR(50) UNIQUE NOT NULL,
    setting_value TEXT,
    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)";
if (mysqli_query($conn, $sql_settings)) {
    echo "Settings table created or already exists.\n";
    
    // Seed default settings
    $defaults = [
        ['site_name', 'SkillPath AI'],
        ['footer_text', '© 2026 SkillPath AI — Sistem Rekomendasi Skill Mahasiswa TI'],
        ['maintenance_mode', 'off']
    ];
    
    foreach ($defaults as $default) {
        $key = $default[0];
        $val = $default[1];
        mysqli_query($conn, "INSERT IGNORE INTO settings (setting_key, setting_value) VALUES ('$key', '$val')");
    }
    echo "Default settings seeded.\n";
} else {
    echo "Error creating settings table: " . mysqli_error($conn) . "\n";
}
?>