From 38da0a5141f9aa006855e86d293d4525efafb541 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Fri, 15 Nov 2024 15:28:08 +0100
Subject: [PATCH] Bug 38436: Rename columns_settings.columnname in DB

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Paul Derscheid <paul.derscheid@lmscloud.de>
---
 installer/data/mysql/atomicupdate/bug_38436.pl | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_38436.pl

diff --git a/installer/data/mysql/atomicupdate/bug_38436.pl b/installer/data/mysql/atomicupdate/bug_38436.pl
new file mode 100755
index 0000000000..428bf53fa9
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_38436.pl
@@ -0,0 +1,18 @@
+use Modern::Perl;
+use Koha::Installer::Output qw(say_warning say_success say_info);
+
+return {
+    bug_number  => "38436",
+    description => "Adjust column names for holdings tables",
+    up          => sub {
+        my ($args) = @_;
+        my ( $dbh, $out ) = @$args{qw(dbh out)};
+
+        say $dbh->do(q{
+            UPDATE columns_settings
+            SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '')
+            WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table")
+        });
+        say_success( $out, "Column names renamed" );
+    },
+};
-- 
2.39.5