Open-ILS/src/sql/Pg/upgrade/0161.schema.acq.alert-text-org.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0161'); -- Scott McKellar
   4
   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;
   9
  10 ALTER TABLE acq.lineitem_alert_text
  11         DROP CONSTRAINT lineitem_alert_text_code_key;
  12
  13 ALTER TABLE acq.lineitem_alert_text
  14         ADD CONSTRAINT alert_one_code_per_org UNIQUE (code, owning_lib);
  15
  16 COMMIT;