1 Purge User Preferred Names
2 ^^^^^^^^^^^^^^^^^^^^^^^^^^
3 The new, user preferred name fields are now set to NULL in the
4 database when a user account is purged via the staff client or using
5 the actor.usr_delete function in the database.
7 To clear the preferred name fields from records that have already been
8 purged, run the following SQL update:
13 SET pref_prefix = NULL,
14 pref_first_given_name = NULL,
15 pref_second_given_name = NULL,
16 pref_family_name = NULL,
19 WHERE usrname ~ ('^' || id || '-PURGED')
23 pref_prefix IS NOT NULL OR
24 pref_first_given_name IS NOT NULL OR
25 pref_second_given_name IS NOT NULL OR
26 pref_family_name IS NOT NULL OR
27 pref_suffix IS NOT NULL OR
28 name_keywords IS NOT NULL