]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0124.schema.acq-credit-eff-date.sql
LP#1917826: tweaks to data update
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0124.schema.acq-credit-eff-date.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0124'); -- Scott McKellar
4
5 ALTER TABLE acq.funding_source_credit
6 ADD COLUMN effective_date TIMESTAMPTZ NOT NULL DEFAULT now();
7
8 COMMIT;