Open-ILS/src/sql/Pg/upgrade/0722.schema.acq-po-state-constraint.sql

   1 -- Evergreen DB patch 0722.schema.acq-po-state-constraint.sql
   2 --
   3 BEGIN;
   4
   5
   6 -- check whether patch can be applied
   7 SELECT evergreen.upgrade_deps_block_check('0722', :eg_version);
   8
   9 ALTER TABLE acq.purchase_order ADD CONSTRAINT valid_po_state
  10     CHECK (state IN ('new','pending','on-order','received','cancelled'));
  11
  12 COMMIT;