Open-ILS/src/sql/Pg/upgrade/0160.schema.acq.line-item-alert-text.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0160'); -- Scott McKellar
   4
   5 CREATE TABLE acq.lineitem_alert_text (
   6         id               SERIAL         PRIMARY KEY,
   7         code             TEXT           UNIQUE NOT NULL,
   8         description      TEXT
   9 );
  10
  11 ALTER TABLE acq.lineitem_note
  12         ADD COLUMN alert_text    INT     REFERENCES acq.lineitem_alert_text(id)
  13                                          DEFERRABLE INITIALLY DEFERRED;
  14
  15 COMMIT;