From 09d58641324b7901cb123a0098f54b4bdbab885f Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Tue, 29 Nov 2022 15:19:18 -0500 Subject: [PATCH] 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 --- .../src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql | 14 +------------- 1 file changed, 1 insertion(+), 13 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 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; -- 2.11.0