<?php
include('includes/config.php');

// Add business_number column to vendors table
$query = "ALTER TABLE vendors ADD COLUMN business_number VARCHAR(100) DEFAULT NULL AFTER business_type";
$result = mysqli_query($con, $query);

if ($result) {
    echo "Column 'business_number' added successfully.";
} else {
    // Check if duplicate column error to ignore
    if (mysqli_errno($con) == 1060) {
        echo "Column already exists.";
    } else {
        echo "Error adding column: " . mysqli_error($con);
    }
}
?>