From a2b1cd23fc63fc2d557df8a6f8cdf68ec9c92086 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 9 Jan 2020 16:23:42 -0500 Subject: [PATCH] remove unnecessary tasks --- .../src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql index 7be77785d1..da50be8572 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.3.3-3.4.0-upgrade-db.sql @@ -817,8 +817,8 @@ ALTER TABLE action.aged_circulation DISABLE TRIGGER USER; SELECT evergreen.upgrade_deps_block_check('1188', :eg_version); -UPDATE action.circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL; -UPDATE action.aged_circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL; +--UPDATE action.circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL; +--UPDATE action.aged_circulation SET auto_renewal = FALSE WHERE auto_renewal IS NULL; SELECT evergreen.upgrade_deps_block_check('1189', :eg_version); @@ -880,12 +880,12 @@ COMMIT; -- alter a table with pending transactions. They also need to occur -- after the above updates or the SET NOT NULL change will fail. -ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE; -ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET NOT NULL; +--ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE; +--ALTER TABLE action.circulation ALTER COLUMN auto_renewal SET NOT NULL; -ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE; -ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET NOT NULL; +--ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET DEFAULT FALSE; +--ALTER TABLE action.aged_circulation ALTER COLUMN auto_renewal SET NOT NULL; -- Update auditor tables to catch changes to source tables. -- Can be removed/skipped if there were no schema changes. -SELECT auditor.update_auditors(); +--SELECT auditor.update_auditors(); -- 2.11.0