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

(-)a/installer/data/mysql/db_revs/240600064.pl (-2 / +1 lines)
Lines 10-16 return { Link Here
10
10
11
        say $dbh->do(q{
11
        say $dbh->do(q{
12
            UPDATE columns_settings
12
            UPDATE columns_settings
13
            SET columnname = REGEXP_REPLACE(columnname, '.*holdings_', '')
13
            SET columnname = SUBSTRING(columnname,LOCATE("_",columnname)+1)
14
            WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table")
14
            WHERE module="catalogue" AND page="detail" AND ( tablename="holdings_table" OR tablename="otherholdings_table")
15
        });
15
        });
16
        say_success( $out, "Column names renamed" );
16
        say_success( $out, "Column names renamed" );
17
- 

Return to bug 38906