From 7ae9fa56ef5f4f8a299fc718559dfe4a47fbd50f Mon Sep 17 00:00:00 2001 From: scottmk Date: Wed, 22 Sep 2010 12:55:28 +0000 Subject: [PATCH] In acq.fund_transfer: drop the NOT NULL constraint from dest_fund and dest_amount, in order to accommodate deallocations -- where we move money out of a fund without moving it into another fund. This change was applied via upgrade script # 0135, but apparently was never applied to the base installation script. M Open-ILS/src/sql/Pg/200.schema.acq.sql git-svn-id: svn://svn.open-ils.org/ILS/trunk@17886 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 4 ++-- 1 file changed, 2 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 db632d284..13db4da10 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -673,9 +673,9 @@ CREATE TABLE acq.fund_transfer ( src_fund INT NOT NULL REFERENCES acq.fund( id ) DEFERRABLE INITIALLY DEFERRED, src_amount NUMERIC NOT NULL, - dest_fund INT NOT NULL REFERENCES acq.fund( id ) + dest_fund INT REFERENCES acq.fund( id ) DEFERRABLE INITIALLY DEFERRED, - dest_amount NUMERIC NOT NULL, + dest_amount NUMERIC, transfer_time TIMESTAMPTZ NOT NULL DEFAULT now(), transfer_user INT NOT NULL REFERENCES actor.usr( id ) DEFERRABLE INITIALLY DEFERRED, -- 2.11.0