<?php
require_once 'config.php';

try {
    $db = db();
    $sql = "
        CREATE TABLE IF NOT EXISTS `orders` (
            `id` INT AUTO_INCREMENT PRIMARY KEY,
            `user_id` INT NOT NULL,
            `total_amount` DECIMAL(10, 2) NOT NULL,
            `status` VARCHAR(50) NOT NULL DEFAULT 'Pending',
            `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            FOREIGN KEY (`user_id`) REFERENCES `users`(`id`)
        );
    ";
    $db->exec($sql);
    echo "Table 'orders' created successfully." . PHP_EOL;
} catch (PDOException $e) {
    die("Error creating table: " . $e->getMessage());
}
?>