From a4450ce1500cb83f995d8811dcf7f03e7a6374c2 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 28 Nov 2012 10:44:14 -0500 Subject: [PATCH] New "patron via SIP" hold cancellation reason Seed data and upgrade script. Signed-off-by: Bill Erickson Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/090.schema.action.sql | 1 + .../src/sql/Pg/upgrade/XXXX.data.hold_cancel_via_sip.sql | 9 +++++++++ 2 files changed, 10 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.hold_cancel_via_sip.sql diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index 80a7e0fda2..908d8182bf 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -366,6 +366,7 @@ INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (3,'Patron via ph 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'); +INSERT INTO action.hold_request_cancel_cause (id,label) VALUES (7,'Patron via SIP'); SELECT SETVAL('action.hold_request_cancel_cause_id_seq', 100); CREATE TABLE action.hold_request ( diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.hold_cancel_via_sip.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.hold_cancel_via_sip.sql new file mode 100644 index 0000000000..fcf1783261 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.hold_cancel_via_sip.sql @@ -0,0 +1,9 @@ +BEGIN; + +-- check whether patch can be applied +-- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO action.hold_request_cancel_cause (id,label) + VALUES (7,'Patron via SIP'); + +COMMIT; -- 2.43.2