adding create_time column to match the IDL
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 28 Jan 2008 00:09:49 +0000 (00:09 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Mon, 28 Jan 2008 00:09:49 +0000 (00:09 +0000)
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

index 0e06d3b..e542877 100644 (file)
@@ -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