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

(-)a/installer/data/mysql/db_revs/211200005.pl (-10 / +13 lines)
Lines 6-20 return { Link Here
6
    up => sub {
6
    up => sub {
7
        my ($args) = @_;
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        $dbh->do(q{
9
        # Run this only if 230600041 has not been run before
10
            DELETE FROM additional_contents
10
        if ( column_exists('additional_contents', 'lang') ) {
11
            WHERE code NOT IN (
11
            $dbh->do(q{
12
                SELECT code FROM (
12
                DELETE FROM additional_contents
13
                    SELECT code
13
                WHERE code NOT IN (
14
                    FROM additional_contents
14
                    SELECT code FROM (
15
                    WHERE lang = "default"
15
                        SELECT code
16
                ) as tmp
16
                        FROM additional_contents
17
            );
17
                        WHERE lang = "default"
18
        });
18
                    ) as tmp
19
                );
20
            });
21
        }
19
    },
22
    },
20
}
23
}
(-)a/installer/data/mysql/db_revs/211200013.pl (-6 / +7 lines)
Lines 48-58 return { Link Here
48
        });
48
        });
49
        say $out "Ensure additional_contents.code is VARCHAR(100)";
49
        say $out "Ensure additional_contents.code is VARCHAR(100)";
50
50
51
        $dbh->do(q{
51
        if ( column_exists('additional_contents', 'lang') ) {
52
                ALTER TABLE `additional_contents`
52
            $dbh->do(q{
53
                MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT ''
53
                    ALTER TABLE `additional_contents`
54
        });
54
                    MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT ''
55
        say $out "Ensure additional_contents.lang is VARCHAR(50)";
55
            });
56
            say $out "Ensure additional_contents.lang is VARCHAR(50)";
57
        }
56
58
57
        $dbh->do(q{
59
        $dbh->do(q{
58
            ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'
60
            ALTER TABLE search_marc_map MODIFY `marc_type` enum('marc21','unimarc') NOT NULL COMMENT 'what MARC type this map is for'
59
- 

Return to bug 31383