From 2191eab11c16255d37143d1bee73be9e92745031 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 6 Feb 2009 15:24:02 +0000 Subject: [PATCH] /actually/ pin the ids, and set the sequence appropriately git-svn-id: svn://svn.open-ils.org/ILS/trunk@12092 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/090.schema.action.sql | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index f6c5bf00a0..44c45636b0 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -251,12 +251,13 @@ 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'); -- 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 +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (1,'Untargeted expiration'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (2,'Hold Shelf expiration'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (3,'Patron via phone'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (4,'Patron in person'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (5,'Staff forced'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (6,'Patron via OPAC'); +SELECT SETVAL('action.hold_request_cancel_cause_id_seq', 100); CREATE TABLE action.hold_request ( id SERIAL PRIMARY KEY, -- 2.11.0