From c32a0b7df7d1ef0fcdf49bb7735d94823d57581a Mon Sep 17 00:00:00 2001
From: Sam Lau <samalau@gmail.com>
Date: Mon, 17 Jul 2023 20:20:38 +0000
Subject: [PATCH] Bug 33462: Update Schema Files [DO NOT PUSH]

This updates the schema files for Borrower.pm, BorrowerModification.pm, Category.pm, and Deletedborrower.pm.

Signed-off-by: Christopher Brannon <cbrannon@cdalibrary.org>
---
 Koha/Schema/Result/Borrower.pm             | 23 ++++++++++++++++------
 Koha/Schema/Result/BorrowerModification.pm | 17 ++++++++++++++--
 Koha/Schema/Result/Category.pm             | 20 ++++++++++++++-----
 Koha/Schema/Result/Deletedborrower.pm      | 17 +++++++++++++---
 4 files changed, 61 insertions(+), 16 deletions(-)

diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm
index 5576e8fcd2..00781195b4 100644
--- a/Koha/Schema/Result/Borrower.pm
+++ b/Koha/Schema/Result/Borrower.pm
@@ -647,6 +647,14 @@ flag for allowing auto-renewal
 
 useful for reporting purposes
 
+=head2 needs_password_reset
+
+  data_type: 'tinyint'
+  default_value: 0
+  is_nullable: 0
+
+tracks if a patron needs to reset their password after account creation
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -850,6 +858,8 @@ __PACKAGE__->add_columns(
   { data_type => "tinyint", default_value => 1, is_nullable => 0 },
   "primary_contact_method",
   { data_type => "varchar", is_nullable => 1, size => 45 },
+  "needs_password_reset",
+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 );
 
 =head1 PRIMARY KEY
@@ -2103,8 +2113,8 @@ Composing rels: L</user_permissions> -> permission
 __PACKAGE__->many_to_many("permissions", "user_permissions", "permission");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-06 15:46:57
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:f6omVb7EtiysdaWTX3IRzg
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-17 23:22:44
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:iUiJVr2tu8DvzM2zmKEeSA
 
 __PACKAGE__->has_many(
   "restrictions",
@@ -2121,11 +2131,12 @@ __PACKAGE__->has_many(
 );
 
 __PACKAGE__->add_columns(
-    '+anonymized'    => { is_boolean => 1 },
-    '+lost'          => { is_boolean => 1 },
-    '+gonenoaddress' => { is_boolean => 1 },
+    '+anonymized'              => { is_boolean => 1 },
+    '+lost'                    => { is_boolean => 1 },
+    '+gonenoaddress'           => { is_boolean => 1 },
     '+privacy_guarantor_fines' => { is_boolean => 1 },
-    '+autorenew_checkouts' => { is_boolean => 1 }
+    '+autorenew_checkouts'     => { is_boolean => 1 },
+    '+needs_password_reset'    => { is_boolean => 1 }
 );
 
 sub koha_objects_class {
diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm
index 4e58afdbd8..604462152e 100644
--- a/Koha/Schema/Result/BorrowerModification.pm
+++ b/Koha/Schema/Result/BorrowerModification.pm
@@ -443,6 +443,14 @@ data processing consent
 
 useful for reporting purposes
 
+=head2 needs_password_reset
+
+  data_type: 'tinyint'
+  default_value: 0
+  is_nullable: 0
+
+tracks if a patron needs to reset their password after account creation
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -621,6 +629,8 @@ __PACKAGE__->add_columns(
   },
   "primary_contact_method",
   { data_type => "varchar", is_nullable => 1, size => 45 },
+  "needs_password_reset",
+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 );
 
 =head1 PRIMARY KEY
@@ -638,8 +648,11 @@ __PACKAGE__->add_columns(
 __PACKAGE__->set_primary_key("verification_token", "borrowernumber");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-06 15:46:57
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:TzG6Q5PymhBXCVxJi3C/sA
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-18 02:31:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:AmzEOvpcBmijB4MFXJuTQg
+__PACKAGE__->add_columns(
+    '+needs_password_reset'        => { is_boolean => 1 }
+);
 
 sub koha_object_class {
     'Koha::Patron::Modification';
diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm
index d6281bf36a..06cd520d7a 100644
--- a/Koha/Schema/Result/Category.pm
+++ b/Koha/Schema/Result/Category.pm
@@ -205,6 +205,13 @@ set required password strength for patrons in this category
 
 Exclude patrons of this category from local holds priority
 
+=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(
@@ -271,6 +278,8 @@ __PACKAGE__->add_columns(
   { data_type => "tinyint", is_nullable => 1 },
   "exclude_from_local_holds_priority",
   { data_type => "tinyint", is_nullable => 1 },
+  "force_password_reset_when_set_by_staff",
+  { data_type => "tinyint", is_nullable => 1 },
 );
 
 =head1 PRIMARY KEY
@@ -378,8 +387,8 @@ __PACKAGE__->has_many(
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-11-08 17:35:26
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:B89OgAY/KnJbQaHpu5Xdfg
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-17 17:29:41
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xCGHoTwf0eY1aTzNW9wf8w
 
 sub koha_object_class {
     'Koha::Patron::Category';
@@ -389,9 +398,10 @@ sub koha_objects_class {
 }
 
 __PACKAGE__->add_columns(
-    '+can_be_guarantee'                  => { is_boolean => 1 },
-    '+exclude_from_local_holds_priority' => { is_boolean => 1 },
-    '+require_strong_password'           => { is_boolean => 1 },
+    '+can_be_guarantee'                       => { is_boolean => 1 },
+    '+exclude_from_local_holds_priority'      => { is_boolean => 1 },
+    '+require_strong_password'                => { is_boolean => 1 },
+    '+force_password_reset_when_set_by_staff' => { is_boolean => 1 },
 );
 
 1;
diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm
index 86fd6b190d..29a891a622 100644
--- a/Koha/Schema/Result/Deletedborrower.pm
+++ b/Koha/Schema/Result/Deletedborrower.pm
@@ -644,6 +644,14 @@ flag for allowing auto-renewal
 
 useful for reporting purposes
 
+=head2 needs_password_reset
+
+  data_type: 'tinyint'
+  default_value: 0
+  is_nullable: 0
+
+tracks if a patron needs to reset their password after account creation
+
 =cut
 
 __PACKAGE__->add_columns(
@@ -835,18 +843,21 @@ __PACKAGE__->add_columns(
   { data_type => "tinyint", default_value => 1, is_nullable => 0 },
   "primary_contact_method",
   { data_type => "varchar", is_nullable => 1, size => 45 },
+  "needs_password_reset",
+  { data_type => "tinyint", default_value => 0, is_nullable => 0 },
 );
 
 
-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-04-06 15:46:58
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dqGu9iDgO+u09l9X1G0NuA
+# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-07-18 02:31:30
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OGB0YGderUB7RAOQJenXvQ
 
 __PACKAGE__->add_columns(
     '+anonymized'    => { is_boolean => 1 },
     '+lost'          => { is_boolean => 1 },
     '+gonenoaddress' => { is_boolean => 1 },
     '+privacy_guarantor_fines' => { is_boolean => 1 },
-    '+autorenew_checkouts' => { is_boolean => 1 }
+    '+autorenew_checkouts' => { is_boolean => 1 },
+    '+needs_password_reset'   => { is_boolean => 1 }
 );
 
 sub koha_objects_class {
-- 
2.30.2