CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) UNIQUE,
    password VARCHAR(50),
    role ENUM('Admin', 'Prof', 'Student')
);


INSERT INTO users (username, password, role) VALUES ('admin1', '1234', 'Admin');