From 6032aab604a8dc9ee055ccca095829b6b9f2f2b5 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Mon, 30 Jan 2023 14:13:00 -0500 Subject: [PATCH] Move from CWMARS fiscal calendar to the Default calendar The Angular acq client now pays attention to the fiscal calendar, so we're switching all of our fiscal year entries to be on the Default calendar rather than updating all of our organizations to use the CWMARS calendar. Signed-off-by: Jason Stephenson --- .../src/sql/Pg/version-upgrade/cwmars-3.7.3-3.10.0-upgrade-db.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.10.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.10.0-upgrade-db.sql index 05bd20c0e0..be40431086 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.10.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/cwmars-3.7.3-3.10.0-upgrade-db.sql @@ -7503,6 +7503,11 @@ SELECT evergreen.upgrade_deps_block_check('1312', :eg_version); CREATE INDEX aum_editor ON actor.usr_message (editor); +\qecho Move from CWMARS acq fiscal calendar to Default +UPDATE acq.fiscal_year +SET calendar = 1 +WHERE calendar = 2; + \qecho A partial reingest is necessary to get the full benefit of this change. \qecho It will take a while. You can cancel now withoug losing the effect of \qecho the rest of the upgrade script, and arrange the reingest later. -- 2.11.0