Bugzilla – Attachment 167163 Details for
Bug 28633
Add a preferred_name field and an effective_name method 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 for sort_name
Bug-28633-DO-NOT-PUSH---Schema-changes-for-sortnam.patch (text/plain), 5.24 KB, created by
Nick Clemens (kidclamp)
on 2024-05-24 12:32:12 UTC
(
hide
)
Description:
Bug 28633: DO NOT PUSH - Schema changes for sort_name
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2024-05-24 12:32:12 UTC
Size:
5.24 KB
patch
obsolete
>From 02ad767ac811d5dd40981d791480e5db41b691e5 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >Date: Fri, 24 May 2024 12:30:28 +0000 >Subject: [PATCH] Bug 28633: DO NOT PUSH - Schema changes for sort_name > >--- > Koha/Schema/Result/Borrower.pm | 13 +++++++++++-- > Koha/Schema/Result/BorrowerModification.pm | 13 +++++++++++-- > Koha/Schema/Result/CreatorLayout.pm | 8 ++++---- > Koha/Schema/Result/Deletedborrower.pm | 13 +++++++++++-- > 4 files changed, 37 insertions(+), 10 deletions(-) > >diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm >index 3513869573d..d7c9038313e 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-05-24 12:15:07 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:bWEvN0rnVlxB0FfP2S4C5g > > __PACKAGE__->has_many( > "restrictions", >diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm >index 9510eb58d04..63eff266782 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-05-24 12:15:07 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:U4R5YRFz/y2XvOfw2rNa/Q > > sub koha_object_class { > 'Koha::Patron::Modification'; >diff --git a/Koha/Schema/Result/CreatorLayout.pm b/Koha/Schema/Result/CreatorLayout.pm >index 5a44faa0509..0a10736f35d 100644 >--- a/Koha/Schema/Result/CreatorLayout.pm >+++ b/Koha/Schema/Result/CreatorLayout.pm >@@ -84,7 +84,7 @@ __PACKAGE__->table("creator_layouts"); > =head2 scale_width > > data_type: 'decimal' >- default_value: 0.080000 >+ default_value: 0.800000 > is_nullable: 0 > size: [28,6] > >@@ -168,7 +168,7 @@ __PACKAGE__->add_columns( > "scale_width", > { > data_type => "decimal", >- default_value => "0.080000", >+ default_value => "0.800000", > is_nullable => 0, > size => [28, 6], > }, >@@ -216,8 +216,8 @@ __PACKAGE__->add_columns( > __PACKAGE__->set_primary_key("layout_id"); > > >-# Created by DBIx::Class::Schema::Loader v0.07049 @ 2023-10-25 14:33:42 >-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:L7tcMDvHqODxCgENIubFTQ >+# Created by DBIx::Class::Schema::Loader v0.07051 @ 2024-05-24 12:12:15 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:T2rvyh+/Oqhehc29lrATmA > > > # You can replace this text with custom content, and it will be preserved on regeneration >diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm >index ab4bd0df235..f9213f5c952 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-05-24 12:15:07 >+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:pHlJigxx/WIdZZf7jGfo7w > > __PACKAGE__->add_columns( > '+anonymized' => { is_boolean => 1 }, >-- >2.39.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 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