From a5259c0c69ca9d8bfae50c8d06af1ab8a1998b51 Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Wed, 21 Jul 2021 10:43:19 +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/ItemsLastBorrower.pm | 15 ++++++++++----- 4 files changed, 43 insertions(+), 11 deletions(-) diff --git a/Koha/Schema/Result/Borrower.pm b/Koha/Schema/Result/Borrower.pm index 68abbc11aa..cbd61fd728 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 preferredname + + data_type: 'longtext' + is_nullable: 1 + +patron/borrower's preferred name + =head2 title data_type: 'longtext' @@ -620,6 +627,8 @@ __PACKAGE__->add_columns( { data_type => "longtext", is_nullable => 1 }, "firstname", { data_type => "mediumtext", is_nullable => 1 }, + "preferredname", + { data_type => "longtext", is_nullable => 1 }, "title", { data_type => "longtext", is_nullable => 1 }, "othernames", @@ -1875,8 +1884,8 @@ Composing rels: L -> ordernumber __PACKAGE__->many_to_many("ordernumbers", "aqorder_users", "ordernumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IKPb4912o8oCHtmFAi6FPQ +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-20 14:51:37 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1KA7z8wyo6flghnuHFSWoA __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/BorrowerModification.pm b/Koha/Schema/Result/BorrowerModification.pm index 81c5fed1fe..8c29415fbe 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 preferredname + + data_type: 'longtext' + is_nullable: 1 + +patron/borrower's preferred name + =head2 title data_type: 'longtext' @@ -453,6 +460,8 @@ __PACKAGE__->add_columns( { data_type => "longtext", is_nullable => 1 }, "firstname", { data_type => "mediumtext", is_nullable => 1 }, + "preferredname", + { data_type => "longtext", is_nullable => 1 }, "title", { data_type => "longtext", is_nullable => 1 }, "othernames", @@ -622,8 +631,8 @@ __PACKAGE__->add_columns( __PACKAGE__->set_primary_key("verification_token", "borrowernumber"); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:6giYT5URks8+6VnAs/rtkg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-21 11:10:20 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:WIFF97soKTUKbfel4FCzwA sub koha_object_class { 'Koha::Patron::Modification'; diff --git a/Koha/Schema/Result/Deletedborrower.pm b/Koha/Schema/Result/Deletedborrower.pm index f0d7395d8d..d6114df69c 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 preferredname + + data_type: 'longtext' + is_nullable: 1 + +patron/borrower's preferred name + =head2 title data_type: 'longtext' @@ -617,6 +624,8 @@ __PACKAGE__->add_columns( { data_type => "longtext", is_nullable => 1 }, "firstname", { data_type => "mediumtext", is_nullable => 1 }, + "preferredname", + { data_type => "longtext", is_nullable => 1 }, "title", { data_type => "longtext", is_nullable => 1 }, "othernames", @@ -785,8 +794,8 @@ __PACKAGE__->add_columns( ); -# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-12 13:40:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9q8LmKrfO6bAAFaJ4Z3Jrg +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-20 14:51:37 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:N4N0enOwRMZd+I1ps3lBlw __PACKAGE__->add_columns( '+anonymized' => { is_boolean => 1 }, diff --git a/Koha/Schema/Result/ItemsLastBorrower.pm b/Koha/Schema/Result/ItemsLastBorrower.pm index 1a97cd7673..f1fb87edea 100644 --- a/Koha/Schema/Result/ItemsLastBorrower.pm +++ b/Koha/Schema/Result/ItemsLastBorrower.pm @@ -39,7 +39,7 @@ __PACKAGE__->table("items_last_borrower"); data_type: 'integer' is_foreign_key: 1 - is_nullable: 0 + is_nullable: 1 =head2 created_on @@ -56,7 +56,7 @@ __PACKAGE__->add_columns( "itemnumber", { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, "borrowernumber", - { data_type => "integer", is_foreign_key => 1, is_nullable => 0 }, + { data_type => "integer", is_foreign_key => 1, is_nullable => 1 }, "created_on", { data_type => "timestamp", @@ -106,7 +106,12 @@ __PACKAGE__->belongs_to( "borrowernumber", "Koha::Schema::Result::Borrower", { borrowernumber => "borrowernumber" }, - { is_deferrable => 1, on_delete => "CASCADE", on_update => "CASCADE" }, + { + is_deferrable => 1, + join_type => "LEFT", + on_delete => "CASCADE", + on_update => "CASCADE", + }, ); =head2 itemnumber @@ -125,8 +130,8 @@ __PACKAGE__->belongs_to( ); -# Created by DBIx::Class::Schema::Loader v0.07040 @ 2015-10-02 12:33:33 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ByHKNZCEz4a1AqTnOJgUWA +# Created by DBIx::Class::Schema::Loader v0.07049 @ 2021-07-20 14:51:37 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uxC5Dg4346LA1KeAWiUT9A # You can replace this text with custom code or comments, and it will be preserved on regeneration -- 2.20.1