From ede8d666573e60e892eadbd2a5211decaa6970da Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Thu, 21 Nov 2019 14:58:07 -0500 Subject: [PATCH] Avoid having to update all action.circulation rows! Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql index bc276b0d57..8a9940b914 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/3.1.5-3.2.0-upgrade-db.sql @@ -2159,13 +2159,13 @@ SELECT evergreen.upgrade_deps_block_check('1123', :eg_version); ADD column max_auto_renewals INTEGER; ALTER TABLE action.circulation - ADD column auto_renewal BOOLEAN; + ADD column auto_renewal BOOLEAN DEFAULT FALSE NOT NULL; ALTER TABLE action.circulation ADD column auto_renewal_remaining INTEGER; ALTER TABLE action.aged_circulation - ADD column auto_renewal BOOLEAN; + ADD column auto_renewal BOOLEAN DEFAULT FALSE NOT NULL; ALTER TABLE action.aged_circulation ADD column auto_renewal_remaining INTEGER; -- 2.11.0