From 389556233c79dcb52d479843db8fe53e082c08e7 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Fri, 15 Feb 2019 13:33:08 -0500 Subject: [PATCH] Lp 1802166: Purge User Name Keywords Add the name_keywords field to the fields that get set to null in actor.usr_delete. Signed-off-by: Jason Stephenson --- Open-ILS/src/sql/Pg/999.functions.global.sql | 1 + Open-ILS/src/sql/Pg/upgrade/XXXX.function.actor_usr_delete.sql | 1 + 2 files changed, 2 insertions(+) diff --git a/Open-ILS/src/sql/Pg/999.functions.global.sql b/Open-ILS/src/sql/Pg/999.functions.global.sql index b4c9cc6eca..8962640fbb 100644 --- a/Open-ILS/src/sql/Pg/999.functions.global.sql +++ b/Open-ILS/src/sql/Pg/999.functions.global.sql @@ -854,6 +854,7 @@ BEGIN pref_second_given_name = NULL, pref_family_name = NULL, pref_suffix = NULL, + name_keywords = NULL, create_date = now(), expire_date = now() WHERE diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.actor_usr_delete.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.actor_usr_delete.sql index 26bf71778e..48d945aac3 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.function.actor_usr_delete.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.function.actor_usr_delete.sql @@ -113,6 +113,7 @@ BEGIN pref_second_given_name = NULL, pref_family_name = NULL, pref_suffix = NULL, + name_keywords = NULL, create_date = now(), expire_date = now() WHERE -- 2.11.0