<?php
$pdo = require __DIR__ . '/config/pdo.php';

try {
    echo "Updating orders table status enum...\n";
    $sql = "ALTER TABLE orders MODIFY COLUMN status ENUM('pending','paid','packed','shipped','done','canceled','menunggu_verifikasi','ditolak') NOT NULL DEFAULT 'pending'";
    $pdo->exec($sql);
    echo "Successfully updated orders table status enum.\n";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
