From d378d53cc9b1d994d7b4a976a39bf781ae8a1022 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Mon, 2 Jun 2014 19:57:15 -0400 Subject: [PATCH] LP 1198475: Add LOSTANDPAID as valid stop_fines. Alter the check constraint on action.circulation.stop_fines, circulation_stop_fines_check, to allow 'LOSTANDPAID' as a valid value. Signed-off-by: Jason Stephenson Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/090.schema.action.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lost-and-paid-status.sql | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lost-and-paid-status.sql diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql index ad78f50e86..5a7832cfaa 100644 --- a/Open-ILS/src/sql/Pg/090.schema.action.sql +++ b/Open-ILS/src/sql/Pg/090.schema.action.sql @@ -139,7 +139,7 @@ CREATE TABLE action.circulation ( recurring_fine_rule TEXT NOT NULL, -- name of "circ fine" rule max_fine_rule TEXT NOT NULL, -- name of "max fine" rule stop_fines TEXT CHECK (stop_fines IN ( - 'CHECKIN','CLAIMSRETURNED','LOST','MAXFINES','RENEW','LONGOVERDUE','CLAIMSNEVERCHECKEDOUT')), + 'CHECKIN','CLAIMSRETURNED','LOST','MAXFINES','RENEW','LONGOVERDUE','CLAIMSNEVERCHECKEDOUT','LOSTANDPAID')), workstation INT REFERENCES actor.workstation(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lost-and-paid-status.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lost-and-paid-status.sql new file mode 100644 index 0000000000..e22feac7aa --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lost-and-paid-status.sql @@ -0,0 +1,6 @@ +ALTER TABLE action.circulation + DROP CONSTRAINT circulation_stop_fines_check; + +ALTER TABLE action.circulation + ADD CONSTRAINT circulation_stop_fines_check + CHECK (stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text, 'CLAIMSNEVERCHECKEDOUT'::text, 'LOSTANDPAID'::text])); -- 2.11.0