From 238dca511c7df498bc590b21157489cdd4041602 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 6 Oct 2025 10:30:08 +0200 Subject: [PATCH] Bug 40292: Rename new_record_id if exists If some installs didn't notice the column was missing (not renamed) we can still do it now. Signed-off-by: Paul Derscheid --- .../data/mysql/atomicupdate/bug_40292.pl | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/bug_40292.pl diff --git a/installer/data/mysql/atomicupdate/bug_40292.pl b/installer/data/mysql/atomicupdate/bug_40292.pl new file mode 100755 index 00000000000..e6a7e54bd36 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_40292.pl @@ -0,0 +1,19 @@ +use Modern::Perl; +use Koha::Installer::Output qw(say_warning say_success say_info); + +return { + bug_number => "40292", + description => "Rename new_record_id if exists", + up => sub { + my ($args) = @_; + my ( $dbh, $out ) = @$args{qw(dbh out)}; + + if ( column_exists('additional_field_values', 'new_record_id') ) { + $dbh->do( + q{ ALTER TABLE additional_field_values CHANGE COLUMN new_record_id record_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT 'record_id'; } + ); + + say_success( $out, "Renamed new_record_id to record_id" ); + } + }, +}; -- 2.39.5