From 26b152bf1248f23a6981f27d0d91d6ea39b383dd Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 23 Mar 2022 15:24:39 +0000 Subject: [PATCH] Bug 29924: DO NOT PUSH - Schema updates Signed-off-by: Andrew Fuerste-Henry --- 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 d2b5c6015f..3931f44b18 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' @@ -696,6 +704,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", @@ -1930,8 +1940,8 @@ Composing rels: L -> permission __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-15 06:51:43 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ozDOfb67H7/GHLI0o4DdyA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-23 15:22:51 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5GK0uqDS17mWUWSUTDDEZw __PACKAGE__->has_many( "extended_attributes", diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 567bf33329..acac3ffb28 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-03-23 15:22:51 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kPXiZ5ywOMrjrqsXzexpiA __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 f0d7395d8d..7792ed25d4 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' @@ -681,6 +689,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", @@ -785,8 +795,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-03-23 15:22:51 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:M0cPzuYz3+z4EJZ+oB+ycA __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, -- 2.30.2