From 731170375f9ac93b57e2e5caaf6cc647356b934c Mon Sep 17 00:00:00 2001 From: Hammat Wele Date: Thu, 9 May 2024 20:08:34 +0000 Subject: [PATCH] Bug 35145: (follow-up) Fix atomicupdate file and display_order's data type --- Koha/Schema/Result/BorrowerAttributeType.pm | 2 +- .../mysql/atomicupdate/bug_35145_order_patron_attributes.pl | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/Koha/Schema/Result/BorrowerAttributeType.pm b/Koha/Schema/Result/BorrowerAttributeType.pm index 6da0b23f84..a80886a1cd 100644 --- a/Koha/Schema/Result/BorrowerAttributeType.pm +++ b/Koha/Schema/Result/BorrowerAttributeType.pm @@ -187,7 +187,7 @@ __PACKAGE__->add_columns( "mandatory", { data_type => "tinyint", default_value => 0, is_nullable => 0 }, "display_order", - { data_type => "int", is_nullable => 1 }, + { data_type => "integer", is_nullable => 1 }, ); =head1 PRIMARY KEY diff --git a/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl b/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl index b1650cd378..084e0caa31 100755 --- a/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl +++ b/installer/data/mysql/atomicupdate/bug_35145_order_patron_attributes.pl @@ -11,12 +11,12 @@ return { $dbh->do( q{ ALTER TABLE borrower_attribute_types - ADD display_order int(11); + ADD COLUMN IF NOT EXISTS display_order int(11); } ); # Print useful stuff here # tables - say $out "Added column 'borrower_attribute_types.number'"; + say $out "Added column 'borrower_attribute_types.display_order'"; }, }; -- 2.34.1