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