From 45a7af42ed41e6c2c073b815acba76bab3c8bfa9 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 23 Apr 2009 17:04:21 +0000 Subject: [PATCH] cut-and-paste-o when adding the collections warning penalty calc git-svn-id: svn://svn.open-ils.org/ILS/trunk@12977 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/100.circ_matrix.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/100.circ_matrix.sql b/Open-ILS/src/sql/Pg/100.circ_matrix.sql index b27fb735a6..892866f577 100644 --- a/Open-ILS/src/sql/Pg/100.circ_matrix.sql +++ b/Open-ILS/src/sql/Pg/100.circ_matrix.sql @@ -598,7 +598,7 @@ BEGIN FROM actor.usr_standing_penalty WHERE usr = match_user AND org_unit = max_fines.org_unit - AND standing_penalty = 1 + AND standing_penalty = 4 LOOP RETURN NEXT existing_sp_row; END LOOP; @@ -621,7 +621,7 @@ BEGIN IF current_fines >= max_fines.threshold THEN new_sp_row.usr := match_user; new_sp_row.org_unit := max_fines.org_unit; - new_sp_row.standing_penalty := 1; + new_sp_row.standing_penalty := 4; RETURN NEXT new_sp_row; END IF; END IF; -- 2.43.2