Attachment 154396 Details for Bug 33462 – Bug 33462: Update Schema Files [DO NOT PUSH]

[patch] Bug 33462: Update Schema Files [DO NOT PUSH]

Bug-33462-Update-Schema-Files-DO-NOT-PUSH.patch (text/plain), 7.17 KB, created by Biblibre Sandboxes on 2023-08-12 23:42:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Biblibre Sandboxes

Created: 2023-08-12 23:42:38 UTC

Size: 7.17 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 33462: 153687 | 153688 | 153689 | 154395 | 154396 | 154397 | 167582 | 167583 | 167584 | 167585 | 167586 | 167587 | 167981 | 167982 | 167983 | 167984 | 167985 | 167986 | 168413 | 168414 | 168415 | 168416 | 168417 | 168418 | 168452 | 168453 | 168454 | 168455 | 168456 | 168457 | 171634 | 171635 | 171636 | 171637 | 171638 | 171639 | 171640 | 172030 | 172031 | 172032 | 172033 | 172034 | 172035 | 172036 | 172064 | 172065 | 172066 | 172067 | 172068 | 172069 | 172070 | 172071 | 173864 | 173865