From 59b867ca3686cc85f450ad8a7fa94cd6d37a5406 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Fri, 21 Jan 2022 17:00:12 +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 d4c13f1f3d..0bcb8fd5d2 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", @@ -1905,8 +1915,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-09-20 12:00:15 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9g9WsdsdPINi2NP4H2A+CA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2022-01-20 11:19:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Eb7yQbnkqAKiHeMOlnH5uQ __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm index 567bf33329..0e1eecb2a6 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-01-20 11:19:08 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EaAYwWwpyyv6YrTI3u4TXA __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..f4e44c9693 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-01-20 11:53:36 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r7UpUE2yUjCf6OAnObzlew __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, -- 2.30.2