Bugzilla – Attachment 173932 Details for
Bug 28633
Add a preferred name field to patrons
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 28633: DO NOT PUSH - Schema changes
Bug-28633-DO-NOT-PUSH---Schema-changes.patch (text/plain), 6.45 KB, created by
Martin Renvoize (ashimema)
on 2024-11-04 15:44:37 UTC
(
hide
)
Description:
Bug 28633: DO NOT PUSH - Schema changes
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2024-11-04 15:44:37 UTC
Size:
6.45 KB
patch
obsolete
>From c01b8b84d85322bd8d18b09faf7862849bd1db13 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Thu, 31 Oct 2024 16:08:59 +0000 >Subject: [PATCH] Bug 28633: DO NOT PUSH - Schema changes > >Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > Koha/Schema/Result/Borrower.pm | 13 +++++++++++-- > Koha/Schema/Result/BorrowerModification.pm | 13 +++++++++++-- > Koha/Schema/Result/Category.pm | 22 +++++++++++----------- > Koha/Schema/Result/Deletedborrower.pm | 13 +++++++++++-- > 4 files changed, 44 insertions(+), 17 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index bf8ba360308..7df41fd2455 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -53,6 +53,13 @@ patron/borrower's last name (surname) > > patron/borrower's first name > >+=head2 preferred_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's preferred name >+ > =head2 middle_name > > data_type: 'longtext' >@@ -666,6 +673,8 @@ __PACKAGE__->add_columns( > { data_type => "longtext", is_nullable => 1 }, > "firstname", > { data_type => "mediumtext", is_nullable => 1 }, >+ "preferred_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -2188,8 +2197,8 @@ Composing rels: L</user_permissions> -> permission > __PACKAGE__->many_to_many("permissions", "user_permissions", "permission"); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-02 11:36:36 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jUOMoSonNmA3KwtZKVxqOA >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ApHapm26zCAu7HiNWc6iiw > > __PACKAGE__->has_many( > "restrictions", >diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm >index 4c7ab99ebb9..aedc1fae591 100644 >--- a/Koha/Schema/Result/BorrowerModification.pm >+++ b/Koha/Schema/Result/BorrowerModification.pm >@@ -64,6 +64,13 @@ __PACKAGE__->table("borrower_modifications"); > data_type: 'mediumtext' > is_nullable: 1 > >+=head2 preferred_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's preferred name >+ > =head2 middle_name > > data_type: 'longtext' >@@ -471,6 +478,8 @@ __PACKAGE__->add_columns( > { data_type => "longtext", is_nullable => 1 }, > "firstname", > { data_type => "mediumtext", is_nullable => 1 }, >+ "preferred_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -646,8 +655,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-08 13:26:34 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pgmClJsT12pxLZHRYrRY9g >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:19BAtUevEb192jlaHkkk2w > > sub koha_object_class { > 'Koha::Patron::Modification'; >diff --git a/Koha/Schema/Result/Category.pm b/Koha/Schema/Result/Category.pm >index 616677608d4..d32401bd4c0 100644 >--- a/Koha/Schema/Result/Category.pm >+++ b/Koha/Schema/Result/Category.pm >@@ -187,6 +187,13 @@ set minimum password length for patrons in this category > > set required password strength for patrons in this category > >+=head2 force_password_reset_when_set_by_staff >+ >+ data_type: 'tinyint' >+ is_nullable: 1 >+ >+if patrons of this category are required to reset password after being created by a staff member >+ > =head2 exclude_from_local_holds_priority > > data_type: 'tinyint' >@@ -215,13 +222,6 @@ define maximum amount that the guarantees of a patron in this category can have > > define maximum amount that the guarantors with guarantees of a patron in this category can have outstanding before checkouts are blocked > >-=head2 force_password_reset_when_set_by_staff >- >- data_type: 'tinyint' >- is_nullable: 1 >- >-if patrons of this category are required to reset password after being created by a staff member >- > =cut > > __PACKAGE__->add_columns( >@@ -283,6 +283,8 @@ __PACKAGE__->add_columns( > { data_type => "smallint", is_nullable => 1 }, > "require_strong_password", > { data_type => "tinyint", is_nullable => 1 }, >+ "force_password_reset_when_set_by_staff", >+ { data_type => "tinyint", is_nullable => 1 }, > "exclude_from_local_holds_priority", > { data_type => "tinyint", is_nullable => 1 }, > "noissuescharge", >@@ -291,8 +293,6 @@ __PACKAGE__->add_columns( > { data_type => "integer", is_nullable => 1 }, > "noissueschargeguarantorswithguarantees", > { data_type => "integer", is_nullable => 1 }, >- "force_password_reset_when_set_by_staff", >- { data_type => "tinyint", is_nullable => 1 }, > ); > > =head1 PRIMARY KEY >@@ -400,8 +400,8 @@ __PACKAGE__->has_many( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-09-17 17:34:19 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:SZoU95HraPfIzszljOSHyQ >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ECLi+Ooct/DCa6UBWV7WoA > > # You can replace this text with custom code or comments, and it will be preserved on regeneration > >diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm >index 866b8b35377..ecdba1ecd29 100644 >--- a/Koha/Schema/Result/Deletedborrower.pm >+++ b/Koha/Schema/Result/Deletedborrower.pm >@@ -53,6 +53,13 @@ patron/borrower's last name (surname) > > patron/borrower's first name > >+=head2 preferred_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's preferred name >+ > =head2 middle_name > > data_type: 'longtext' >@@ -663,6 +670,8 @@ __PACKAGE__->add_columns( > { data_type => "longtext", is_nullable => 1 }, > "firstname", > { data_type => "mediumtext", is_nullable => 1 }, >+ "preferred_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -848,8 +857,8 @@ __PACKAGE__->add_columns( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-11-01 18:21:38 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WdNGUFdglTb3Heu+VjLWFw >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-31 16:08:18 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v4Pf3bTCh/dMGkhcVrBBog > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >-- >2.47.0
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 28633
:
123008
|
123009
|
123010
|
123658
|
125497
|
125498
|
125499
|
125500
|
126591
|
128968
|
128969
|
128970
|
130000
|
130001
|
130002
|
133445
|
133446
|
133447
|
133448
|
133449
|
133450
|
133451
|
133958
|
133959
|
133960
|
133961
|
133962
|
133963
|
133964
|
133965
|
166792
|
166793
|
166794
|
166813
|
166814
|
166815
|
166816
|
166817
|
167163
|
167164
|
173628
|
173629
|
173630
|
173631
|
173632
|
173633
|
173634
|
173664
|
173665
|
173666
|
173667
|
173668
|
173669
|
173670
|
173717
|
173718
|
173719
|
173813
|
173814
|
173815
|
173816
|
173826
|
173827
|
173828
|
173829
|
173930
|
173931
| 173932 |
173933
|
173934
|
173935
|
173936
|
174419
|
174420
|
174472
|
175177