View | Details | Raw Unified | Return to bug 38436
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_38436.pl (-1 / +18 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "38436",
6
    description => "Adjust column names for holdings tables",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        say $dbh->do(q{
12
            UPDATE columns_settings
13
            SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '')
14
            WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table")
15
        });
16
        say_success( $out, "Column names renamed" );
17
    },
18
};

Return to bug 38436