From 802517c607ba9bfa3f2387b1a8f98240aaa721cd Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 10 Jan 2019 07:23:42 -0500 Subject: [PATCH] tweak parent/guardian data update --- Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql index 404ad1f3c1..e8d3488bdc 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql @@ -98,6 +98,6 @@ VALUES ( ); -- move parent/guardian field data to new field -UPDATE actor.usr SET guardian = ident_value2, ident_value2 = NULL WHERE NOT deleted AND ident_value2 IS NOT NULL; +UPDATE actor.usr SET guardian = ident_value2, ident_value2 = NULL WHERE NOT deleted AND ident_value2 IS NOT NULL AND ident_value2 <> ''; COMMIT; -- 2.11.0