From c1cf3d854967f127cb48906b1564895db0e650e5 Mon Sep 17 00:00:00 2001
From: Nick Clemens <nick@bywatersolutions.com>
Date: Thu, 31 Oct 2024 16:08:59 +0000
Subject: [PATCH] Bug 28633: DO NOT PUSH - Schema changes

---
 Koha/Schema/Result/Borrower.pm             | 13 +++++++++++--
 Koha/Schema/Result/BorrowerModification.pm | 13 +++++++++++--
 Koha/Schema/Result/Category.pm             | 22 +++++++++++-----------
 Koha/Schema/Result/Deletedborrower.pm      | 13 +++++++++++--
 4 files changed, 44 insertions(+), 17 deletions(-)

diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index bf8ba360308..7df41fd2455 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -53,6 +53,13 @@ patron/borrower's last name (surname)
 
 patron/borrower's first name
 
+=head2 preferred_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's preferred name
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -666,6 +673,8 @@ __PACKAGE__->add_columns(
   { data_type => "longtext", is_nullable => 1 },
   "firstname",
   { data_type => "mediumtext", is_nullable => 1 },
+  "preferred_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -2188,8 +2197,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-02 11:36:36
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jUOMoSonNmA3KwtZKVxqOA
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ApHapm26zCAu7HiNWc6iiw
 
 __PACKAGE__->has_many(
   "restrictions",
diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
index 4c7ab99ebb9..aedc1fae591 100644
--- a/Koha/Schema/Result/BorrowerModification.pm
+++ b/Koha/Schema/Result/BorrowerModification.pm
@@ -64,6 +64,13 @@ __PACKAGE__->table("borrower_modifications");
   data_type: 'mediumtext'
   is_nullable: 1
 
+=head2 preferred_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's preferred name
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -471,6 +478,8 @@ __PACKAGE__->add_columns(
   { data_type => "longtext", is_nullable => 1 },
   "firstname",
   { data_type => "mediumtext", is_nullable => 1 },
+  "preferred_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -646,8 +655,8 @@ __PACKAGE__->add_columns(
 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-08 13:26:34
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pgmClJsT12pxLZHRYrRY9g
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:19BAtUevEb192jlaHkkk2w
 
 sub koha_object_class {
     'Koha::Patron::Modification';
diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm
index 616677608d4..d32401bd4c0 100644
--- a/Koha/Schema/Result/Category.pm
+++ b/Koha/Schema/Result/Category.pm
@@ -187,6 +187,13 @@ set minimum password length for patrons in this category
 
 set required password strength for patrons in this category
 
+=head2 force_password_reset_when_set_by_staff
+
+  data_type: 'tinyint'
+  is_nullable: 1
+
+if patrons of this category are required to reset password after being created by a staff member
+
 =head2 exclude_from_local_holds_priority
 
   data_type: 'tinyint'
@@ -215,13 +222,6 @@ define maximum amount that the guarantees of a patron in this category can have
 
 define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked
 
-=head2 force_password_reset_when_set_by_staff
-
-  data_type: 'tinyint'
-  is_nullable: 1
-
-if patrons of this category are required to reset password after being created by a staff member
-
 =cut
 
 __PACKAGE__->add_columns(
@@ -283,6 +283,8 @@ __PACKAGE__->add_columns(
   { data_type => "smallint", is_nullable => 1 },
   "require_strong_password",
   { data_type => "tinyint", is_nullable => 1 },
+  "force_password_reset_when_set_by_staff",
+  { data_type => "tinyint", is_nullable => 1 },
   "exclude_from_local_holds_priority",
   { data_type => "tinyint", is_nullable => 1 },
   "noissuescharge",
@@ -291,8 +293,6 @@ __PACKAGE__->add_columns(
   { data_type => "integer", is_nullable => 1 },
   "noissueschargeguarantorswithguarantees",
   { data_type => "integer", is_nullable => 1 },
-  "force_password_reset_when_set_by_staff",
-  { data_type => "tinyint", is_nullable => 1 },
 );
 
 =head1 PRIMARY KEY
@@ -400,8 +400,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-09-17 17:34:19
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SZoU95HraPfIzszljOSHyQ
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ECLi+Ooct/DCa6UBWV7WoA
 
 # You can replace this text with custom code or comments, and it will be preserved on regeneration
 
diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
index 866b8b35377..ecdba1ecd29 100644
--- a/Koha/Schema/Result/Deletedborrower.pm
+++ b/Koha/Schema/Result/Deletedborrower.pm
@@ -53,6 +53,13 @@ patron/borrower's last name (surname)
 
 patron/borrower's first name
 
+=head2 preferred_name
+
+  data_type: 'longtext'
+  is_nullable: 1
+
+patron/borrower's preferred name
+
 =head2 middle_name
 
   data_type: 'longtext'
@@ -663,6 +670,8 @@ __PACKAGE__->add_columns(
   { data_type => "longtext", is_nullable => 1 },
   "firstname",
   { data_type => "mediumtext", is_nullable => 1 },
+  "preferred_name",
+  { data_type => "longtext", is_nullable => 1 },
   "middle_name",
   { data_type => "longtext", is_nullable => 1 },
   "title",
@@ -848,8 +857,8 @@ __PACKAGE__->add_columns(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-01 18:21:38
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WdNGUFdglTb3Heu+VjLWFw
+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v4Pf3bTCh/dMGkhcVrBBog
 
 __PACKAGE__->add_columns(
     '+anonymized'              => { is_boolean => 1 },
-- 
2.39.5