From 12ff4dc9999b29ef2e684522dbab914ec681b8b8 Mon Sep 17 00:00:00 2001 From: Remington Steed Date: Thu, 29 Jan 2015 16:12:08 -0500 Subject: [PATCH] LP#1422379 Upgrade Script for moved money.billing timestamps Signed-off-by: Remington Steed Signed-off-by: Dan Wells --- .../upgrade/XXXX.data.move_fine_timestamps_back.sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.move_fine_timestamps_back.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.move_fine_timestamps_back.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.move_fine_timestamps_back.sql new file mode 100644 index 0000000000..18036ff14c --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.move_fine_timestamps_back.sql @@ -0,0 +1,19 @@ +BEGIN; + +--SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +--limit to btype=1 / 'Overdue Materials' +UPDATE money.billing mb + SET billing_ts = billing_ts - ac.fine_interval + interval '1 sec' + FROM action.circulation ac +WHERE mb.xact = ac.id + AND mb.btype = 1; + +UPDATE money.materialized_billable_xact_summary mmbxs + SET last_billing_ts = last_billing_ts - ac.fine_interval + interval '1 sec' + FROM action.circulation ac +WHERE mmbxs.id = ac.id + AND mmbxs.last_billing_type = 'Overdue materials' + AND mmbxs.xact_type = 'circulation'; + +COMMIT; -- 2.11.0