From ee20f5c2118d81a0a03962aeb62b655e18d078d5 Mon Sep 17 00:00:00 2001
From: Katrin Fischer <katrin.fischer.83@web.de>
Date: Mon, 21 Nov 2022 22:15:15 +0000
Subject: [PATCH] Bug 32291: Add missing column descriptions to borrowers table

Adds missing column descriptions for new features etc. to the
existing entry for borrowres columns descriptions.

To test:
* Go to reports > Guided reports
* Select patrons module
* Make sure all entries for the tables items and suggestions show
  up with nice descriptions

https://bugs.koha-community.org/show_bug.cgi?id=32292

Signed-off-by: David Nind <david@davidnind.com>
---
 Koha/Database/Columns.pm | 42 +++++++++++++++++++++++++++-------------
 1 file changed, 29 insertions(+), 13 deletions(-)

diff --git a/Koha/Database/Columns.pm b/Koha/Database/Columns.pm
index b533d50bf7..1288b2b3eb 100644
--- a/Koha/Database/Columns.pm
+++ b/Koha/Database/Columns.pm
@@ -166,19 +166,35 @@ sub columns {
             "sort2"               => __("Sort 2"),
             "dateenrolled"        => __("Registration date"),
             "dateexpiry"          => __("Expiry date"),
-            "opacnote"            => __("OPAC note"),
-            "borrowernotes"       => __("Circulation note"),
-            "userid"              => __("Username"),
-            "password"            => __("Password"),
-            "flags"               => __("System permissions"),
-            "gonenoaddress"       => __("Gone no address flag"),
-            "lost"                => __("Lost card flag"),
-            "debarred"            => __("Restricted [until] flag"),
-            "debarredcomment"     => __("Comment"),
-            "smsalertnumber"      => __("Mobile phone number"),
-            "privacy"             => __("Privacy settings"),
-            "autorenew_checkouts" => __("Allow auto-renewals"),
-        },
+            "password_expiration_date"    => __("Password expiration date"),
+            "date_renewed"                => __("Account renewal date"),
+            "opacnote"                    => __("OPAC note"),
+            "borrowernotes"               => __("Circulation note"),
+            "userid"                      => __("Username"),
+            "password"                    => __("Password"),
+            "secret"                      => __("Secret (2FA)"),
+            "auth_method"                 => __("Authentication method"),
+            "flags"                       => __("System permissions"),
+            "gonenoaddress"               => __("Gone no address flag"),
+            "lost"                        => __("Lost card flag"),
+            "debarred"                    => __("Restricted [until] flag"),
+            "debarredcomment"             => __("Comment"),
+            "smsalertnumber"              => __("Mobile phone number"),
+            "sms_provider_id"             => __("SMS provier ID (internal)"),
+            "privacy"                     => __("Privacy settings"),
+            "privacy_guarantor_fines"     => __("Show fines to guarantor"),
+            "privacy_guarantor_checkouts" => __("Show checkouts to guarantor"),
+            "checkprevcheckout"           => __("Check for previous checkouts"),
+            "updated_on"                  => __("Last update date"),
+            "lastseen"                    => __("Last activity date"),
+            "lang"                   => __("Preferred language for notices"),
+            "login_attempts"         => __("Number of failed login attempts"),
+            "overdrive_auth_token"   => __("Overdrive auth token"),
+            "anonymized"             => __("Data anonymization flag"),
+            "autorenew_checkouts"    => __("Allow auto-renewals"),
+            "primary_contact_method" => __("Primary contact method"),
+          },
+
         items => {
             "itemnumber"           => __("Item number (internal)"),
             "biblionumber"         => __("Biblio number (internal)"),
-- 
2.30.2