CREATE TABLE alumni (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(100) UNIQUE NOT NULL,
graduation_year YEAR NOT NULL,
major VARCHAR(50),
phone VARCHAR(15)
);
CREATE TABLE events (
id INT AUTO_INCREMENT PRIMARY KEY,
title VARCHAR(200) NOT NULL,
description TEXT,
start_date DATETIME,
end_date DATETIME,
location VARCHAR(200),
organizer_id INT,
FOREIGN KEY (organizer_id) REFERENCES alumni(id)
);
const postComment = async (alumniId, eventId, content) => {
try {
const response = await fetch('/api/comment', {
method: 'POST',
headers: { 'Content-Type': 'application/json' },
body: JSON.stringify({ alumniId, eventId, content })
});
if (!response.ok) throw new Error('Network response was not ok');
return await response.json();
} catch (error) {
console.error(error);
}
};