From 00e163d928776eee5cf7d5fbf38f4be12719ae1a Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 25 Aug 2005 18:49:41 +0000 Subject: [PATCH] minor field reordering for better on-disk layout git-svn-id: svn://svn.open-ils.org/ILS/trunk@1736 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index e72e7cc465..4ea8be8799 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -114,13 +114,13 @@ CREATE TABLE action.hold_request ( return_time TIMESTAMP WITH TIME ZONE, prev_check_time TIMESTAMP WITH TIME ZONE, expire_time TIMESTAMP WITH TIME ZONE, - hold_type "char" NOT NULL CHECK (hold_type IN ('M','T','V','C')), target BIGINT NOT NULL, -- see hold_type current_copy BIGINT REFERENCES asset.copy (id) ON DELETE SET NULL, requestor INT NOT NULL REFERENCES actor.usr (id), usr INT NOT NULL REFERENCES actor.usr (id), selection_depth INT NOT NULL DEFAULT 0, pickup_lib INT NOT NULL REFERENCES actor.org_unit, + hold_type "char" NOT NULL CHECK (hold_type IN ('M','T','V','C')), holdable_formats TEXT, phone_notify TEXT, email_notify TEXT @@ -130,8 +130,8 @@ CREATE TABLE action.hold_request ( CREATE TABLE action.hold_notification ( id SERIAL PRIMARY KEY, hold INT NOT NULL REFERENCES action.hold_request (id), - method TEXT NOT NULL, -- eh... notify_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), + method TEXT NOT NULL, -- eh... note TEXT ); -- 2.43.2