]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0609.schema.acq-lineitem-detail-receiver.sql
LP1779158 Angular7 and ng-lint updates
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0609.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('0609', :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;