Bugzilla – Attachment 123009 Details for
Bug 28633
Add a preferred name field 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
Bug-28633-DO-NOT-PUSH-Schema-Changes.patch (text/plain), 5.67 KB, created by
Nick Clemens (kidclamp)
on 2021-07-21 11:14:54 UTC
(
hide
)
Description:
Bug 28633: DO NOT PUSH Schema Changes
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2021-07-21 11:14:54 UTC
Size:
5.67 KB
patch
obsolete
>From a5259c0c69ca9d8bfae50c8d06af1ab8a1998b51 Mon Sep 17 00:00:00 2001 >From: Nick Clemens <nick@bywatersolutions.com> >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</aqorder_users> -> 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
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
|
173628
|
173629
|
173630
|
173631
|
173632
|
173633
|
173634
|
173664
|
173665
|
173666
|
173667
|
173668
|
173669
|
173670
|
173717
|
173718
|
173719
|
173813
|
173814
|
173815
|
173816
|
173826
|
173827
|
173828
|
173829
|
173930
|
173931
|
173932
|
173933
|
173934
|
173935
|
173936
|
174419
|
174420
|
174472
|
175177