<?php
require_once __DIR__ . '/config/db.php';
$database = new Database();
$db = $database->getConnection();

try {
    $stmt = $db->query("SHOW COLUMNS FROM products LIKE 'purchase_type'");
    if ($stmt->rowCount() === 0) {
        $db->exec("ALTER TABLE products ADD COLUMN purchase_type ENUM('normal', 'booking') DEFAULT 'normal' AFTER status");
        echo "Column 'purchase_type' added successfully!";
    } else {
        echo "Column 'purchase_type' already exists.";
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}