<?php
// Check orders table columns
use Illuminate\Support\Facades\Schema;

require __DIR__ . '/../vendor/autoload.php';
$app = require_once __DIR__ . '/../bootstrap/app.php';
$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);
$kernel->bootstrap();

$columns = Schema::getColumnListing('orders');
echo "Orders table columns:\n";
print_r($columns);

// Check if shipping_method_id is nullable
$conn = DB::connection();
$tableInfo = $conn->select("SHOW COLUMNS FROM orders LIKE 'shipping_method_id'");
echo "\nColumn Info for shipping_method_id:\n";
print_r($tableInfo);
