]> git.evergreen-ils.org Git - Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0233.schema.acq-invoice-inv_ident-constraint.sql
LP#1117808: Stamping upgrade scripts for extend use of merge profiles
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0233.schema.acq-invoice-inv_ident-constraint.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0233'); -- senator
4
5 ALTER TABLE acq.invoice
6     ADD CONSTRAINT inv_ident_once_per_provider UNIQUE(provider, inv_ident);
7
8 COMMIT;