@@ -, +, @@ --- 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(-) --- a/Koha/Schema/Result/Borrower.pm +++ a/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 }, --- a/Koha/Schema/Result/BorrowerModification.pm +++ a/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'; --- a/Koha/Schema/Result/Deletedborrower.pm +++ a/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 }, --- a/Koha/Schema/Result/ItemsLastBorrower.pm +++ a/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 --