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

(-)a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl (-2 / +1 lines)
Lines 10-16 return { Link Here
10
        if ( column_exists( 'erm_eholdings_titles', 'preceeding_publication_title_id' ) ) {
10
        if ( column_exists( 'erm_eholdings_titles', 'preceeding_publication_title_id' ) ) {
11
            $dbh->do(
11
            $dbh->do(
12
                q{
12
                q{
13
                ALTER TABLE erm_eholdings_titles RENAME COLUMN preceeding_publication_title_id TO preceding_publication_title_id
13
                ALTER TABLE erm_eholdings_titles CHANGE COLUMN preceeding_publication_title_id preceding_publication_title_id varchar(255) DEFAULT NULL
14
            }
14
            }
15
            );
15
            );
16
            say $out 'Column renamed to preceding_publication_title_id';
16
            say $out 'Column renamed to preceding_publication_title_id';
17
- 

Return to bug 34789