BEGIN;
ALTER TABLE semester ALTER COLUMN year TYPE TEXT;
ALTER TABLE semester ALTER COLUMN semester TYPE TEXT;
COMMIT;
