From b50a88dfcc2e5cf4f1e727480a4ca6990ff1a34b Mon Sep 17 00:00:00 2001 From: Fridolin Somers Date: Fri, 6 May 2022 09:34:26 -1000 Subject: [PATCH] Bug 29924: Update DBIC schema Signed-off-by: Fridolin Somers --- 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 39ef4fe02d..5d0cac62c4 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-04-29 11:09:16 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pQqp6+XsKkDrnO57fQ9dmg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-05-06 19:32:13 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lGlRQ4XvRdsrqTye6sDpYg __PACKAGE__->has_many( "extended_attributes", diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 6319df90d4..6ff19ac81e 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", @@ -344,8 +353,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-04-25 12:50:56 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:vEpp1HRkUOvPyWd/yAsxng +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-05-06 19:32:13 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:swAluUTlYu57KPUYB+00Dw __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..b36d2d3ede 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-05-06 19:32:13 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/LuHiaHNVRk1bAYDWvT34w __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, -- 2.39.5