-- Run after 20261017_way_to_graduate.sql on existing installations.
ALTER TABLE graduation_requirements MODIFY course_id BIGINT UNSIGNED NULL;
ALTER TABLE student_projects MODIFY course_id BIGINT UNSIGNED NULL;
SET @graduation_add_delta = IF((SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='graduation_requirements' AND COLUMN_NAME='requirements_delta')=0,'ALTER TABLE graduation_requirements ADD COLUMN requirements_delta MEDIUMTEXT NULL AFTER requirements','SELECT 1');
PREPARE graduation_editor_upgrade FROM @graduation_add_delta;
EXECUTE graduation_editor_upgrade;
DEALLOCATE PREPARE graduation_editor_upgrade;
