<?php
require_once __DIR__ . '/../config.php';
$pdo = db();

try {
    $pdo->exec("
        ALTER TABLE truck_owner_profiles 
        ADD COLUMN IF NOT EXISTS ctr_number VARCHAR(100) DEFAULT NULL,
        ADD COLUMN IF NOT EXISTS notes TEXT DEFAULT NULL;
    ");
    echo "Schema updated successfully.";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}