From bc6e379765a849dab15c80a41729df2ff860ee31 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Tue, 29 Oct 2024 12:21:34 +0000
Subject: [PATCH] Bug 28633: DO NOT PUSH: Schema changes

Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov>
---
 Koha/Schema/Result/Borrower.pm             | 13 +++++++++++--
 Koha/Schema/Result/BorrowerModification.pm | 13 +++++++++++--
 Koha/Schema/Result/Deletedborrower.pm      | 13 +++++++++++--
 Koha/Schema/Result/OldReserve.pm           |  6 +++---
 Koha/Schema/Result/Reserve.pm              |  6 +++---
 5 files changed, 39 insertions(+), 12 deletions(-)

diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index 3513869573..583b9bc441 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -60,6 +60,13 @@ patron/borrower's first name
 
 patron/borrower's preferred name
 
+=head2 sort_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's name to be used for sorting
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -675,6 +682,8 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "preferred_name",
   { data_type => "longtext", is_nullable => 1 },
+  "sort_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -2197,8 +2206,8 @@ Composing rels: L</user_permissions> -> permission
 __PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-15 19:22:05
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FOSg3LfHkgeIvq0xdkNXXg
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e8whbktYiubU8yvMJ7uiqQ
 
 __PACKAGE__->has_many(
   "restrictions",
diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
index 9510eb58d0..5a2a870c31 100644
--- a/Koha/Schema/Result/BorrowerModification.pm
+++ b/Koha/Schema/Result/BorrowerModification.pm
@@ -71,6 +71,13 @@ __PACKAGE__->table("borrower_modifications");
 
 patron/borrower's preferred name
 
+=head2 sort_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's name to be used for sorting
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -480,6 +487,8 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "preferred_name",
   { data_type => "longtext", is_nullable => 1 },
+  "sort_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -655,8 +664,8 @@ __PACKAGE__->add_columns(
 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-15 19:22:05
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1wFpRHX6xJf6IAPjB8IKyQ
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HxX5Rax2PmyZdZFbm8tY0w
 
 sub koha_object_class {
     'Koha::Patron::Modification';
diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
index ab4bd0df23..0921073f1a 100644
--- a/Koha/Schema/Result/Deletedborrower.pm
+++ b/Koha/Schema/Result/Deletedborrower.pm
@@ -60,6 +60,13 @@ patron/borrower's first name
 
 patron/borrower's preferred name
 
+=head2 sort_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's name to be used for sorting
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -672,6 +679,8 @@ __PACKAGE__->add_columns(
   { data_type => "mediumtext", is_nullable => 1 },
   "preferred_name",
   { data_type => "longtext", is_nullable => 1 },
+  "sort_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -857,8 +866,8 @@ __PACKAGE__->add_columns(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-15 19:22:05
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bxcfsi4bNkMwri9aCRwtVw
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tb5MfoUee6l/UdvOXCtsFw
 
 __PACKAGE__->add_columns(
     '+anonymized'              => { is_boolean => 1 },
diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm
index e3f3437c94..d3245a49a0 100644
--- a/Koha/Schema/Result/OldReserve.pm
+++ b/Koha/Schema/Result/OldReserve.pm
@@ -59,7 +59,7 @@ foreign key from the biblio table defining which bib record this hold is on
   data_type: 'integer'
   is_nullable: 1
 
-links the reserve to the deleted bibliographic record (deletedbiblio.biblionumber)
+links the hold to the deleted bibliographic record (deletedbiblio.biblionumber)
 
 =head2 item_group_id
 
@@ -437,8 +437,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-28 18:50:07
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WVT+As1+G9EJ2laDaGWE4A
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BzrdZFqL3Vyw65X+Ibs2Bg
 
 __PACKAGE__->belongs_to(
   "item",
diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm
index b941eddcee..6cda9097c4 100644
--- a/Koha/Schema/Result/Reserve.pm
+++ b/Koha/Schema/Result/Reserve.pm
@@ -62,7 +62,7 @@ foreign key from the biblio table defining which bib record this hold is on
   data_type: 'integer'
   is_nullable: 1
 
-links the reserve to the deleted bibliographic record (deletedbiblio.biblionumber)
+links the hold to the deleted bibliographic record (deletedbiblio.biblionumber)
 
 =head2 item_group_id
 
@@ -465,8 +465,8 @@ __PACKAGE__->belongs_to(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-28 18:50:07
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6sYYJBDau/Ol8U95p4psKQ
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Um75uz+XcD7AoKc86F+7+g
 
 __PACKAGE__->belongs_to(
   "item",
-- 
2.34.1