Open-ILS/src/sql/Pg/upgrade/0178.schema.acq.lid-cancel-reason.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0178'); -- Scott McKellar
   4
   5 ALTER TABLE acq.lineitem_detail
   6         ADD COLUMN cancel_reason        INT REFERENCES acq.cancel_reason( id )
   7                                             DEFERRABLE INITIALLY DEFERRED;
   8
   9 COMMIT;