-- Adds the "revision not ready" option to the Review (signoff) column.

alter table pages drop constraint if exists pages_signoff_check;

alter table pages add constraint pages_signoff_check
  check (signoff in ('not ready', 'ready for review', 'revision not ready', 'revision needed', 'approved'));
