add_erenew_column.patch

commit 09d58641324b7901cb123a0098f54b4bdbab885f
Author: Jason Stephenson <jason@sigio.com>
Date:   Tue Nov 29 15:19:18 2022 -0500

    Alter schema upgrade for erenew column

    Set the column to "NOT NULL DEFAULT FALSE" and remove the extra
    updates to set the current columsn to FALSE and add the NOT NULL
    constraint.  This new version does it all in 1 ALTER TABLE statement.

    Signed-off-by: Jason Stephenson <jstephenson@cwmars.org>

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 cf584015e7..c047b32899 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,17 +1,5 @@
 BEGIN;

-ALTER TABLE permission.grp_tree ADD COLUMN erenew BOOL;
-
-COMMIT;
-
-BEGIN;
-
-UPDATE permission.grp_tree SET erenew = FALSE;
-
-COMMIT;
-
-BEGIN;
-
-ALTER TABLE permission.grp_tree ALTER COLUMN erenew SET NOT NULL;
+ALTER TABLE permission.grp_tree ADD COLUMN erenew BOOL NOT NULL DEFAULT FALSE;

 COMMIT;