3 INSERT INTO config.upgrade_log (version) VALUES ('0241'); -- Scott McKellar
5 CREATE TABLE acq.po_item (
7 purchase_order INT REFERENCES acq.purchase_order (id)
8 ON UPDATE CASCADE ON DELETE SET NULL
9 DEFERRABLE INITIALLY DEFERRED,
10 fund_debit INT REFERENCES acq.fund_debit (id)
11 DEFERRABLE INITIALLY DEFERRED,
12 inv_item_type TEXT NOT NULL
13 REFERENCES acq.invoice_item_type (code)
14 DEFERRABLE INITIALLY DEFERRED,
18 estimated_cost NUMERIC(8,2),
19 fund INT REFERENCES acq.fund (id)
20 DEFERRABLE INITIALLY DEFERRED