-- Allow application plans to be archived.

ALTER TABLE application_plans
  DROP CONSTRAINT IF EXISTS application_plans_status_check;

ALTER TABLE application_plans
  ADD CONSTRAINT application_plans_status_check
  CHECK (status IN ('planned', 'in_progress', 'completed', 'cancelled', 'archived'));