From 623c2799dd1511d3470bcc80eb70db9a74a48589 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Fri, 27 Jan 2023 13:49:29 -0500 Subject: [PATCH] LP1902937: Modify New Schema Upgrade SQL scripts Alter schema upgrade that adds the erenew column to set the column "NOT NULL DEFAULT FALSE." Remove the extra updates to set the current column values to FALSE and add the NOT NULL constraint. This new version does it all in 1 ALTER TABLE statement. Rename the Quipu standing penalty and erenew pgt column upgrade scripts so that the order that they should be run is obvious from the filenames. Signed-off-by: Jason Stephenson --- .../sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql | 17 ----------------- ...ding_penalty.sql => YYYY.quipu-standing-penalty.sql} | 0 .../sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql | 5 +++++ 3 files changed, 5 insertions(+), 17 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql rename Open-ILS/src/sql/Pg/upgrade/{XXXX-quipu-standing_penalty.sql => YYYY.quipu-standing-penalty.sql} (100%) create mode 100644 Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql 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 deleted file mode 100644 index cf584015e7..0000000000 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql +++ /dev/null @@ -1,17 +0,0 @@ -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; - -COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX-quipu-standing_penalty.sql b/Open-ILS/src/sql/Pg/upgrade/YYYY.quipu-standing-penalty.sql similarity index 100% rename from Open-ILS/src/sql/Pg/upgrade/XXXX-quipu-standing_penalty.sql rename to Open-ILS/src/sql/Pg/upgrade/YYYY.quipu-standing-penalty.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql new file mode 100644 index 0000000000..c047b32899 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql @@ -0,0 +1,5 @@ +BEGIN; + +ALTER TABLE permission.grp_tree ADD COLUMN erenew BOOL NOT NULL DEFAULT FALSE; + +COMMIT; -- 2.11.0