1
-- Adds active column to problem_attempt table
2
-- This allows a group of problem attempts (ie. from previous semesters) to be
3
-- marked as 'inactive' and thus counting toward a problem being assessment for
4
-- the current semester.
6
ALTER TABLE problem_attempt ADD COLUMN active BOOLEAN NOT NULL DEFAULT true;