Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-lineitem-detail-receiver.sql

   1 -- Evergreen DB patch XXXX.data.acq-copy-creator-from-receiver.sql
   2 BEGIN;
   3
   4 -- check whether patch can be applied
   5 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
   6
   7 ALTER TABLE acq.lineitem_detail
   8     ADD COLUMN receiver INT REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED;
   9
  10
  11 COMMIT;