<?php
require_once __DIR__ . '/config/Database.php';
try {
    $db = \App\Config\Database::getInstance()->getConnection();
    
    // Update ENUM for status
    $db->exec("ALTER TABLE inventory_batches MODIFY COLUMN status ENUM('active', 'inactive', 'returned') DEFAULT 'active'");
    // Update ENUM for stock_level
    $db->exec("ALTER TABLE inventory_batches MODIFY COLUMN stock_level ENUM('In-stock', 'low-stock', 'out-of stock', 'returned') DEFAULT 'In-stock'");
    
    echo "ENUM updated successfully.";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
