Bugzilla – Attachment 173670 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.03 KB, created by
Emily Lamancusa (emlam)
on 2024-10-29 15:45:59 UTC
(
hide
)
Description:
Bug 28633: DO NOT PUSH: Schema changes
Filename:
MIME Type:
Creator:
Emily Lamancusa (emlam)
Created:
2024-10-29 15:45:59 UTC
Size:
6.03 KB
patch
obsolete
>From bc6e379765a849dab15c80a41729df2ff860ee31 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Tue, 29 Oct 2024 12:21:34 +0000 >Subject: [PATCH] Bug 28633: DO NOT PUSH: Schema changes > >Signed-off-by: Emily Lamancusa <emily.lamancusa@montgomerycountymd.gov> >--- > Koha/Schema/Result/Borrower.pm | 13 +++++++++++-- > Koha/Schema/Result/BorrowerModification.pm | 13 +++++++++++-- > Koha/Schema/Result/Deletedborrower.pm | 13 +++++++++++-- > Koha/Schema/Result/OldReserve.pm | 6 +++--- > Koha/Schema/Result/Reserve.pm | 6 +++--- > 5 files changed, 39 insertions(+), 12 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 3513869573..583b9bc441 100644 >--- a/Koha/Schema/Result/Borrower.pm >+++ b/Koha/Schema/Result/Borrower.pm >@@ -60,6 +60,13 @@ patron/borrower's first name > > patron/borrower's preferred name > >+=head2 sort_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's name to be used for sorting >+ > =head2 middle_name > > data_type: 'longtext' >@@ -675,6 +682,8 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "preferred_name", > { data_type => "longtext", is_nullable => 1 }, >+ "sort_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -2197,8 +2206,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-15 19:22:05 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FOSg3LfHkgeIvq0xdkNXXg >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:e8whbktYiubU8yvMJ7uiqQ > > __PACKAGE__->has_many( > "restrictions", >diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm >index 9510eb58d0..5a2a870c31 100644 >--- a/Koha/Schema/Result/BorrowerModification.pm >+++ b/Koha/Schema/Result/BorrowerModification.pm >@@ -71,6 +71,13 @@ __PACKAGE__->table("borrower_modifications"); > > patron/borrower's preferred name > >+=head2 sort_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's name to be used for sorting >+ > =head2 middle_name > > data_type: 'longtext' >@@ -480,6 +487,8 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "preferred_name", > { data_type => "longtext", is_nullable => 1 }, >+ "sort_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -655,8 +664,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-15 19:22:05 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1wFpRHX6xJf6IAPjB8IKyQ >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HxX5Rax2PmyZdZFbm8tY0w > > sub koha_object_class { > 'Koha::Patron::Modification'; >diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm >index ab4bd0df23..0921073f1a 100644 >--- a/Koha/Schema/Result/Deletedborrower.pm >+++ b/Koha/Schema/Result/Deletedborrower.pm >@@ -60,6 +60,13 @@ patron/borrower's first name > > patron/borrower's preferred name > >+=head2 sort_name >+ >+ data_type: 'longtext' >+ is_nullable: 1 >+ >+patron/borrower's name to be used for sorting >+ > =head2 middle_name > > data_type: 'longtext' >@@ -672,6 +679,8 @@ __PACKAGE__->add_columns( > { data_type => "mediumtext", is_nullable => 1 }, > "preferred_name", > { data_type => "longtext", is_nullable => 1 }, >+ "sort_name", >+ { data_type => "longtext", is_nullable => 1 }, > "middle_name", > { data_type => "longtext", is_nullable => 1 }, > "title", >@@ -857,8 +866,8 @@ __PACKAGE__->add_columns( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-15 19:22:05 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bxcfsi4bNkMwri9aCRwtVw >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:tb5MfoUee6l/UdvOXCtsFw > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >diff --git a/Koha/Schema/Result/OldReserve.pm b/Koha/Schema/Result/OldReserve.pm >index e3f3437c94..d3245a49a0 100644 >--- a/Koha/Schema/Result/OldReserve.pm >+++ b/Koha/Schema/Result/OldReserve.pm >@@ -59,7 +59,7 @@ foreign key from the biblio table defining which bib record this hold is on > data_type: 'integer' > is_nullable: 1 > >-links the reserve to the deleted bibliographic record (deletedbiblio.biblionumber) >+links the hold to the deleted bibliographic record (deletedbiblio.biblionumber) > > =head2 item_group_id > >@@ -437,8 +437,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-28 18:50:07 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WVT+As1+G9EJ2laDaGWE4A >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:BzrdZFqL3Vyw65X+Ibs2Bg > > __PACKAGE__->belongs_to( > "item", >diff --git a/Koha/Schema/Result/Reserve.pm b/Koha/Schema/Result/Reserve.pm >index b941eddcee..6cda9097c4 100644 >--- a/Koha/Schema/Result/Reserve.pm >+++ b/Koha/Schema/Result/Reserve.pm >@@ -62,7 +62,7 @@ foreign key from the biblio table defining which bib record this hold is on > data_type: 'integer' > is_nullable: 1 > >-links the reserve to the deleted bibliographic record (deletedbiblio.biblionumber) >+links the hold to the deleted bibliographic record (deletedbiblio.biblionumber) > > =head2 item_group_id > >@@ -465,8 +465,8 @@ __PACKAGE__->belongs_to( > ); > > >-# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-28 18:50:07 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6sYYJBDau/Ol8U95p4psKQ >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-10-29 12:20:48 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Um75uz+XcD7AoKc86F+7+g > > __PACKAGE__->belongs_to( > "item", >-- >2.34.1
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