<?php
include 'includes/db.php';

$sql = "ALTER TABLE applications 
        ADD COLUMN payment_status ENUM('Pending', 'Paid', 'Verification Pending') DEFAULT 'Pending', 
        ADD COLUMN payment_method VARCHAR(50), 
        ADD COLUMN transaction_id VARCHAR(100), 
        ADD COLUMN payment_date TIMESTAMP NULL";

if ($conn->query($sql) === TRUE) {
    echo "Database updated successfully";
} else {
    echo "Error updating database: " . $conn->error;
}
?>
