Open-ILS/src/sql/Pg/upgrade/0214.schema.acq.replace-claim-interval.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0214'); -- Scott McKellar
   4
   5 ALTER TABLE acq.acq_lineitem_history
   6         DROP COLUMN claim_interval;
   7
   8 ALTER TABLE acq.acq_lineitem_history
   9         ADD COLUMN claim_policy INT
  10                 REFERENCES acq.claim_policy
  11                 DEFERRABLE INITIALLY DEFERRED;
  12
  13 --SELECT acq.create_acq_lifecycle('acq', 'lineitem');
  14
  15 COMMIT;