]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0243.schema.acq-inv-item-po-item.sql
LP#1117808: Stamping upgrade scripts for extend use of merge profiles
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0243.schema.acq-inv-item-po-item.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0243'); -- Scott McKellar
4
5 ALTER TABLE acq.invoice_item
6         ADD COLUMN po_item INT REFERENCES acq.po_item (id)
7                                DEFERRABLE INITIALLY DEFERRED;
8
9 COMMIT;