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

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0211'); -- Scott McKellar
   4
   5 ALTER TABLE acq.lineitem
   6         DROP COLUMN claim_interval CASCADE;
   7
   8 ALTER TABLE acq.lineitem
   9         ADD COLUMN claim_policy INT
  10                 REFERENCES acq.claim_policy
  11                 DEFERRABLE INITIALLY DEFERRED;
  12
  13 ALTER TABLE acq.provider
  14         DROP COLUMN default_claim_interval;
  15
  16 ALTER TABLE acq.provider
  17         ADD COLUMN default_claim_policy INT
  18                 REFERENCES acq.claim_policy
  19                 DEFERRABLE INITIALLY DEFERRED;
  20
  21 COMMIT;