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

try {
    echo "Adding 'pending_approval' to shipments status enum...\n";
    // MariaDB/MySQL ALTER TABLE to modify column
    $sql = "ALTER TABLE shipments MODIFY COLUMN status ENUM('pending_approval', 'posted','offered','confirmed','in_transit','delivered') NOT NULL DEFAULT 'posted'";
    db()->exec($sql);
    echo "Migration successful.\n";
} catch (PDOException $e) {
    echo "Migration failed: " . $e->getMessage() . "\n";
}