From 10ea53306af0baadce1a3ad12309e57bd8641359 Mon Sep 17 00:00:00 2001 From: scottmk Date: Fri, 21 Aug 2009 12:38:47 +0000 Subject: [PATCH] Change uniqueness constraint on acq.fund.code so as to include org and year git-svn-id: svn://svn.open-ils.org/ILS/trunk@13912 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 9e62c0932c..71fbaef573 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -107,8 +107,9 @@ CREATE TABLE acq.fund ( name TEXT NOT NULL, year INT NOT NULL DEFAULT EXTRACT( YEAR FROM NOW() ), currency_type TEXT NOT NULL REFERENCES acq.currency_type (code) DEFERRABLE INITIALLY DEFERRED, - code TEXT UNIQUE, - CONSTRAINT name_once_per_org_year UNIQUE (org,name,year) + code TEXT, + CONSTRAINT name_once_per_org_year UNIQUE (org,name,year), + CONSTRAINT code_once_per_org_year UNIQUE (org, code, year) ); CREATE TABLE acq.fund_debit ( -- 2.43.2