ALTER TABLE generated_exams
    ADD COLUMN IF NOT EXISTS generator_used VARCHAR(50) NULL AFTER exam_data,
    ADD COLUMN IF NOT EXISTS generation_warnings TEXT NULL AFTER generator_used,
    ADD COLUMN IF NOT EXISTS updated_at TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER created_at,
    ADD COLUMN IF NOT EXISTS last_edited_by INT(11) NULL AFTER updated_at;

