From bf4a56d2942c1ce393a0ac8b34110f4c7c11750b Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 6 Feb 2009 14:28:30 +0000 Subject: [PATCH] add patron-opac cause, and comments about IDs git-svn-id: svn://svn.open-ils.org/ILS/trunk@12090 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 8eb20006d4..f6c5bf00a0 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -251,11 +251,12 @@ CREATE TABLE action.hold_request_cancel_cause ( id SERIAL PRIMARY KEY, label TEXT UNIQUE ); -INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Untargeted expiration'); -INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Hold Shelf expiration'); -INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Patron via phone'); -INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Patron in person'); -INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Staff forced'); +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Untargeted expiration'); -- 1 +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Hold Shelf expiration'); -- 2 +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Patron via phone'); -- 3 +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Patron in person'); -- 4 +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Staff forced'); -- 5 +INSERT INTO action.hold_request_cancel_cause (label) VALUES ('Patron via OPAC'); -- 6 CREATE TABLE action.hold_request ( id SERIAL PRIMARY KEY, -- 2.43.2