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

try {
    query("ALTER TABLE inventory_items ADD COLUMN buying_unit_price DECIMAL(15,2) DEFAULT 0.00 AFTER unit");
    echo "Column buying_unit_price added successfully.\n";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}
