Bugzilla – Attachment 129706 Details for
Bug 29924
Introduce password expiration to patron categories
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 29924: DO NOT PUSH - Schema updates
Bug-29924-DO-NOT-PUSH---Schema-updates.patch (text/plain), 4.65 KB, created by
Nick Clemens (kidclamp)
on 2022-01-21 17:16:21 UTC
(
hide
)
Description:
Bug 29924: DO NOT PUSH - Schema updates
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2022-01-21 17:16:21 UTC
Size:
4.65 KB
patch
obsolete
>From 59b867ca3686cc85f450ad8a7fa94cd6d37a5406 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >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</aqorder_users> -> 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 29924
:
129705
|
129706
|
129707
|
129708
|
129762
|
129763
|
129764
|
129765
|
129766
|
129823
|
129953
|
129954
|
129955
|
129956
|
129957
|
130116
|
130117
|
130118
|
130119
|
130120
|
130495
|
130500
|
130501
|
130502
|
130503
|
130504
|
130505
|
130557
|
130558
|
130559
|
130560
|
130561
|
130562
|
130563
|
130677
|
130678
|
130679
|
130680
|
130681
|
130682
|
130683
|
131128
|
132059
|
132060
|
132061
|
132062
|
132063
|
132064
|
132065
|
132066
|
132084
|
132085
|
132086
|
132087
|
132088
|
132089
|
132090
|
132091
|
132092
|
133741
|
133742
|
133743
|
133744
|
133745
|
133746
|
133747
|
133748
|
133801
|
133802
|
133803
|
133804
|
133805
|
133806
|
133807
|
133808
|
133809
|
133810
|
133989
|
134758