From 10dd4927dc2f54430429b7fc2066ce95e6f9e884 Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 5 Jan 2008 02:30:11 +0000 Subject: [PATCH] adding missing (overlooked, somehow) fund fkeys git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@8324 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index ac9719d72b..389f8cfb4d 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -56,12 +56,14 @@ CREATE TABLE acq.fund_share_map ( CREATE TABLE acq.fund_credit ( id SERIAL PRIMARY KEY, + fund INT NOT NULL REFERENCES acq.fund (id), amount NUMERIC NOT NULL, note TEXT ); CREATE TABLE acq.fund_debit ( id SERIAL PRIMARY KEY, + fund INT NOT NULL REFERENCES acq.fund (id), origin_amount NUMERIC NOT NULL, -- pre-exchange-rate amount origin_currency_type TEXT NOT NULL REFERENCES acq.currency_type (code), amount NUMERIC NOT NULL, -- 2.11.0