Open-ILS/src/sql/Pg/upgrade/0230.schema.acq-inv-pmt-method.sql

   1 BEGIN;
   2
   3 INSERT INTO config.upgrade_log (version) VALUES ('0230'); -- Scott McKellar
   4
   5 CREATE TABLE acq.invoice_payment_method (
   6         code      TEXT     PRIMARY KEY,
   7         name      TEXT     NOT NULL
   8 );
   9
  10 ALTER TABLE acq.invoice
  11         ADD COLUMN payment_auth TEXT;
  12
  13 ALTER TABLE acq.invoice
  14         ADD COLUMN payment_method TEXT
  15                 REFERENCES acq.invoice_payment_method (code)
  16                 DEFERRABLE INITIALLY DEFERRED;
  17
  18 ALTER TABLE acq.invoice
  19         ADD COLUMN note TEXT;
  20
  21 COMMIT;