From d6972d0a0379b3f059c304ccf2937a68852b59a0 Mon Sep 17 00:00:00 2001 From: Terran McCanna Date: Fri, 11 Nov 2022 11:37:25 -0500 Subject: [PATCH] Online Renewal - tweak SQL - Parentheses on first SQL generated error. - Set erenew default to FALSE instead of TRUE. Signed-off-by: Terran McCanna --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql index 8e835b413d..cf584015e7 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql @@ -1,12 +1,12 @@ BEGIN; -ALTER TABLE permission.grp_tree ADD COLUMN (erenew BOOL); +ALTER TABLE permission.grp_tree ADD COLUMN erenew BOOL; COMMIT; BEGIN; -UPDATE permission.grp_tree SET erenew = TRUE; +UPDATE permission.grp_tree SET erenew = FALSE; COMMIT; -- 2.11.0