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

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

Return to bug 38906