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

(-)a/installer/data/mysql/db_revs/240600045.pl (-7 / +8 lines)
Lines 8-20 return { Link Here
8
        my ($args) = @_;
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
10
11
        $dbh->do(
11
        if ( !column_exists( 'itemtypes', 'bookable' ) ) {
12
            q{
12
            $dbh->do(
13
            ALTER TABLE itemtypes ADD IF NOT EXISTS bookable INT(1) DEFAULT 0 AFTER automatic_checkin
13
                q{
14
                ALTER TABLE itemtypes ADD COLUMN bookable INT(1) DEFAULT 0 AFTER automatic_checkin
15
            }
16
            );
17
18
            say_success( $out, "Added column 'itemtypes.bookable'" );
14
        }
19
        }
15
        );
16
17
        say_success( $out, "Added column 'itemtypes.bookable'" );
18
20
19
        $dbh->do(
21
        $dbh->do(
20
            q{
22
            q{
21
- 

Return to bug 35906