<?php
require_once __DIR__ . '/../config.php';
require_once __DIR__ . '/../includes/db.php';

$db = DB();
try {
    // Add category column
    $res1 = $db->query("ALTER TABLE notifications ADD COLUMN category VARCHAR(100) NULL AFTER content");
    if (!$res1) {
        echo "Failed category: " . $db->getLastError() . "\n";
    } else {
        echo "Added category column successfully.\n";
    }
    
    // Add session column
    $res2 = $db->query("ALTER TABLE notifications ADD COLUMN session VARCHAR(100) NULL AFTER category");
    if (!$res2) {
        echo "Failed session: " . $db->getLastError() . "\n";
    } else {
        echo "Added session column successfully.\n";
    }
    
} catch (Exception $e) {
    echo "Exception message: " . $e->getMessage() . "\n";
    echo "DB Error: " . $db->getLastError() . "\n";
}