3 INSERT INTO config.upgrade_log (version) VALUES ('0161'); -- Scott McKellar
5 ALTER TABLE acq.lineitem_alert_text
6 ADD COLUMN owning_lib INT NOT NULL
7 REFERENCES actor.org_unit(id)
8 DEFERRABLE INITIALLY DEFERRED;
10 ALTER TABLE acq.lineitem_alert_text
11 DROP CONSTRAINT lineitem_alert_text_code_key;
13 ALTER TABLE acq.lineitem_alert_text
14 ADD CONSTRAINT alert_one_code_per_org UNIQUE (code, owning_lib);