From 45eedf09cec1d5457d101eb336c80eed42c572eb Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Thu, 25 Feb 2016 16:53:28 -0500 Subject: [PATCH] LP#1549505: Mark badge as having been recalculated Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql index d9cdb11491..9ea59142fa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.statisitcal-ratings.sql @@ -267,6 +267,9 @@ BEGIN DROP TABLE record_score_scratchpad; + -- Now, finally-finally, mark the badge as recalculated + UPDATE rating.badge SET last_calc = NOW() WHERE id = badge_id; + RETURN; END; $f$ LANGUAGE PLPGSQL; -- 2.11.0