Open-ILS/src/sql/Pg/upgrade/0181.schema.acq-user-request-cancel-cause.sql

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