<?php
include 'db_config.php';

// Alter jobs table to add Pending and Rejected status
$sql = "ALTER TABLE jobs MODIFY COLUMN status ENUM('Pending', 'Open', 'Closed', 'Rejected') DEFAULT 'Pending'";

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

$conn->close();
?>
