From 02ad767ac811d5dd40981d791480e5db41b691e5 Mon Sep 17 00:00:00 2001 From: Nick Clemens 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 -> 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