<?php
require_once __DIR__ . '/../config.php';

try {
    $pdo = db();
    echo "Modifying truck_owner_profiles table...\n";
    
    $queries = [
        "ALTER TABLE truck_owner_profiles MODIFY COLUMN truck_type VARCHAR(120) NULL",
        "ALTER TABLE truck_owner_profiles MODIFY COLUMN load_capacity DECIMAL(10,2) NULL",
        "ALTER TABLE truck_owner_profiles MODIFY COLUMN plate_no VARCHAR(80) NULL",
        "ALTER TABLE truck_owner_profiles MODIFY COLUMN truck_pic_path VARCHAR(255) NULL",
        "ALTER TABLE truck_owner_profiles MODIFY COLUMN registration_path TEXT NULL"
    ];

    foreach ($queries as $sql) {
        $pdo->exec($sql);
        echo "Executed: $sql\n";
    }

    echo "Migration completed successfully.\n";
} catch (PDOException $e) {
    echo "Migration failed: " . $e->getMessage() . "\n";
    exit(1);
}