From b68b0aa0bf6114f287570896aab407eeba83b710 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Mon, 25 Apr 2022 11:27:42 +0000 Subject: [PATCH] Bug 29924: DO NOT PUSH - Schema updates --- Koha/Schema/Result/Borrower.pm | 14 ++++++++++++-- Koha/Schema/Result/Category.pm | 13 +++++++++++-- Koha/Schema/Result/Deletedborrower.pm | 14 ++++++++++++-- 3 files changed, 35 insertions(+), 6 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 175710d0f5..9b58c2d3ec 100644 --- a/Koha/Schema/Result/Borrower.pm +++ b/Koha/Schema/Result/Borrower.pm @@ -296,6 +296,14 @@ date the patron was added to Koha (YYYY-MM-DD) date the patron/borrower's card is set to expire (YYYY-MM-DD) +=head2 password_expiration_date + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +date the patron/borrower's password is set to expire (YYYY-MM-DD) + =head2 date_renewed data_type: 'date' @@ -712,6 +720,8 @@ __PACKAGE__->add_columns( { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "dateexpiry", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "password_expiration_date", + { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "date_renewed", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "gonenoaddress", @@ -1955,8 +1965,8 @@ Composing rels: L -> permission __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-24 10:20:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:srYT5wjg7Jhy5CpmDjWv/g +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-04-25 11:26:01 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:MR/0Iid1sjLxbcbbr34G6w __PACKAGE__->has_many( "extended_attributes", diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 567bf33329..8764ea3644 100644 --- a/Koha/Schema/Result/Category.pm +++ b/Koha/Schema/Result/Category.pm @@ -54,6 +54,13 @@ number of months the patron is enrolled for (will be NULL if enrolmentperioddate date the patron is enrolled until (will be NULL if enrolmentperiod is set) +=head2 password_expiry_days + + data_type: 'smallint' + is_nullable: 1 + +number of days after which the patron must reset their password + =head2 upperagelimit data_type: 'smallint' @@ -201,6 +208,8 @@ __PACKAGE__->add_columns( { data_type => "smallint", is_nullable => 1 }, "enrolmentperioddate", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "password_expiry_days", + { data_type => "smallint", is_nullable => 1 }, "upperagelimit", { data_type => "smallint", is_nullable => 1 }, "dateofbirthrequired", @@ -329,8 +338,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-11-19 14:20:11 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xrnHXXv5sd3S2sMEKzHLmA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-04-25 11:26:01 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7hptS8P6QyEWLSaBUBm5lA __PACKAGE__->add_columns( '+exclude_from_local_holds_priority' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index 85ce2b707f..ec1896f76b 100644 --- a/Koha/Schema/Result/Deletedborrower.pm +++ b/Koha/Schema/Result/Deletedborrower.pm @@ -294,6 +294,14 @@ date the patron was added to Koha (YYYY-MM-DD) date the patron/borrower's card is set to expire (YYYY-MM-DD) +=head2 password_expiration_date + + data_type: 'date' + datetime_undef_if_invalid: 1 + is_nullable: 1 + +date the patron/borrower's password is set to expire (YYYY-MM-DD) + =head2 date_renewed data_type: 'date' @@ -697,6 +705,8 @@ __PACKAGE__->add_columns( { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "dateexpiry", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, + "password_expiration_date", + { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "date_renewed", { data_type => "date", datetime_undef_if_invalid => 1, is_nullable => 1 }, "gonenoaddress", @@ -810,8 +820,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-24 10:20:07 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:JvVxPJOrg5reWvl+gg9Q2A +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-04-25 11:26:01 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6/X2K+fPy63SQaM1AdlIcw __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, -- 2.30.2