<?php
require_once __DIR__ . '/../config.php';
try {
    $pdo = db();
    $pdo->exec("ALTER TABLE truck_owner_profiles ADD COLUMN bank_account VARCHAR(100) NULL AFTER plate_no;");
    $pdo->exec("ALTER TABLE truck_owner_profiles ADD COLUMN bank_name VARCHAR(100) NULL AFTER bank_account;");
    $pdo->exec("ALTER TABLE truck_owner_profiles ADD COLUMN bank_branch VARCHAR(100) NULL AFTER bank_name;");
    echo "Columns added.\n";
} catch (Exception $e) {
    echo "Error: " . $e->getMessage() . "\n";
}