-- Add role column to accounts if missing
ALTER TABLE accounts ADD COLUMN role ENUM('student','admin') NOT NULL DEFAULT 'student';
UPDATE accounts SET role = 'student' WHERE role IS NULL;

