Alter schema upgrade for erenew column
authorJason Stephenson <jstephenson@cwmars.org>
Tue, 29 Nov 2022 20:19:18 +0000 (15:19 -0500)
committerJason Stephenson <jstephenson@cwmars.org>
Tue, 29 Nov 2022 20:19:18 +0000 (15:19 -0500)
commit09d58641324b7901cb123a0098f54b4bdbab885f
treecda21841c259c105dccbf941ac85388aa6378219
parent925fdb9c40a4f852ec400dea807ac8f740f62284
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>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.erenew_column_pgt.sql