From 76fdf768643fd7ed658a55d8371d03be36c904e4 Mon Sep 17 00:00:00 2001 From: scottmk Date: Tue, 21 Apr 2009 19:29:55 +0000 Subject: [PATCH] Added create_time columns to acq.fund_debit and acq.fund_allocation. git-svn-id: svn://svn.open-ils.org/ILS/trunk@12948 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/200.schema.acq.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/200.schema.acq.sql b/Open-ILS/src/sql/Pg/200.schema.acq.sql index 85981226be..0d0c28fdc0 100644 --- a/Open-ILS/src/sql/Pg/200.schema.acq.sql +++ b/Open-ILS/src/sql/Pg/200.schema.acq.sql @@ -119,7 +119,8 @@ CREATE TABLE acq.fund_debit ( amount NUMERIC NOT NULL, encumbrance BOOL NOT NULL DEFAULT TRUE, debit_type TEXT NOT NULL, - xfer_destination INT REFERENCES acq.fund (id) DEFERRABLE INITIALLY DEFERRED + xfer_destination INT REFERENCES acq.fund (id) DEFERRABLE INITIALLY DEFERRED, + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); CREATE TABLE acq.fund_allocation ( @@ -130,6 +131,7 @@ CREATE TABLE acq.fund_allocation ( percent NUMERIC CHECK (percent IS NULL OR percent BETWEEN 0.0 AND 100.0), allocator INT NOT NULL REFERENCES actor.usr (id) DEFERRABLE INITIALLY DEFERRED, note TEXT, + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), CONSTRAINT allocation_amount_or_percent CHECK ((percent IS NULL AND amount IS NOT NULL) OR (percent IS NOT NULL AND amount IS NULL)) ); -- 2.11.0