Open-ILS/src/sql/Pg/upgrade/0641.schema.org_unit_setting_json_check.sql

   1 -- Evergreen DB patch 0641.schema.org_unit_setting_json_check.sql
   2 --
   3 --
   4 BEGIN;
   5
   6 -- check whether patch can be applied
   7 SELECT evergreen.upgrade_deps_block_check('0641', :eg_version);
   8
   9 ALTER TABLE actor.org_unit_setting ADD CONSTRAINT aous_must_be_json CHECK ( evergreen.is_json(value) );
  10
  11 COMMIT;