<?php

require_once __DIR__ . '/../config.php';

function migrate_005_add_role_to_users_table() {
    $pdo = db();
    try {
        $sql = '
        ALTER TABLE users
        ADD COLUMN role VARCHAR(50) NOT NULL DEFAULT \'user\';
        ';
        $pdo->exec($sql);
        echo "Migration 005: Added role column to users table successfully." . PHP_EOL;
    } catch (PDOException $e) {
        die("Migration 005 failed: " . $e->getMessage() . PHP_EOL);
    }
}

// Self-invocation check
if (basename(__FILE__) == basename($_SERVER["SCRIPT_FILENAME"])) {
    migrate_005_add_role_to_users_table();
}