projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a3705d8) | patch
LP1902937: Modify New Schema Upgrade SQL scripts collab/dyrcona/lp1902937-quipu-integration+erenew
authorJason Stephenson <jason@sigio.com>
Fri, 27 Jan 2023 18:49:29 +0000 (13:49 -0500)
committerJason Stephenson <jason@sigio.com>
Thu, 6 Apr 2023 18:32:30 +0000 (14:32 -0400)
commit623c2799dd1511d3470bcc80eb70db9a74a48589
tree77183ae6296d144c57b552f36e6dda57ffc276c4tree
parenta3705d8610538599274716c27f37d20ed741451ccommit | diff
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 <jason@sigio.com>
Open-ILS/src/sql/Pg/upgrade/XXXX-quipu-standing_penalty.sql [deleted file] blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql [deleted file] blob | history
Open-ILS/src/sql/Pg/upgrade/YYYY.quipu-standing-penalty.sql [new file with mode: 0644] blob
Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.erenew_column_pgt.sql [new file with mode: 0644] blob
Evergreen ILS