From bb74d5698d72215d8b4bed1e5757aabdd85e243e Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 28 Jan 2008 00:09:49 +0000 Subject: [PATCH] adding create_time column to match the IDL git-svn-id: svn://svn.open-ils.org/ILS/trunk@8506 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 0e06d3b43a..e54287782d 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -89,6 +89,7 @@ CREATE TABLE action.circulation ( due_date TIMESTAMP WITH TIME ZONE, stop_fines_time TIMESTAMP WITH TIME ZONE, checkin_time TIMESTAMP WITH TIME ZONE, + create_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), duration INTERVAL, -- derived from "circ duration" rule fine_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL, -- derived from "circ fine" rule recuring_fine NUMERIC(6,2), -- derived from "circ fine" rule -- 2.43.2