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

// Alter users table
$sql1 = "ALTER TABLE users MODIFY COLUMN academic_year VARCHAR(20)";
if ($conn->query($sql1) === TRUE) {
    echo "users.academic_year modified to VARCHAR(20)\n";
} else {
    echo "Error modifying users table: " . $conn->error . "\n";
}

// Alter applications table
$sql2 = "ALTER TABLE applications MODIFY COLUMN academic_year VARCHAR(20)";
if ($conn->query($sql2) === TRUE) {
    echo "applications.academic_year modified to VARCHAR(20)\n";
} else {
    echo "Error modifying applications table: " . $conn->error . "\n";
}

$conn->close();
?>
