]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0190.schema.acq.po-prepayment-required.sql
LP#1759238: stamping upgrade script
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0190.schema.acq.po-prepayment-required.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0190'); -- Scott McKellar
4
5 ALTER TABLE acq.purchase_order
6         ADD COLUMN prepayment_required BOOLEAN NOT NULL DEFAULT FALSE;
7
8 ALTER TABLE acq.acq_purchase_order_history
9         ADD COLUMN prepayment_required BOOLEAN NOT NULL DEFAULT FALSE;
10
11 COMMIT;