LP#1812733: put in correct version of actor.usr_delete()
authorGalen Charlton <gmc@equinoxinitiative.org>
Mon, 18 Feb 2019 17:57:48 +0000 (12:57 -0500)
committerGalen Charlton <gmc@equinoxinitiative.org>
Mon, 18 Feb 2019 17:57:48 +0000 (12:57 -0500)
This fixes an issue in the previous patch where second_given_name
would never have been NULLed.

Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>

Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_actor_usr_delete_function.sql

index 0350dd4..aaf5c79 100644 (file)
@@ -87,10 +87,11 @@ BEGIN
                        photo_url = NULL,
                        prefix = NULL,
                        first_given_name = new_name,
-                       guardian = NULL,
+                       second_given_name = NULL,
                        family_name = new_name,
                        suffix = NULL,
                        alias = NULL,
+            guardian = NULL,
                        day_phone = NULL,
                        evening_phone = NULL,
                        other_phone = NULL,