| 
      
            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 | 
              };  |