From 5de1c9c2b99e299abe0a88667e0048a627e0ab1b Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Tue, 29 Oct 2024 12:21:34 +0000 Subject: [PATCH] Bug 28633: DO NOT PUSH: Schema changes --- 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 3513869573d..583b9bc4419 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 -> 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 9510eb58d04..5a2a870c31f 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 ab4bd0df235..0921073f1a3 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 e3f3437c948..d3245a49a0a 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 b941eddceed..6cda9097c49 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.39.5