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

(-)a/installer/data/mysql/db_revs/251200028.pl (-10 / +9 lines)
Lines 8-23 return { Link Here
8
    up => sub {
8
    up => sub {
9
        my ($args) = @_;
9
        my ($args) = @_;
10
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
        my ( $dbh, $out ) = @$args{qw(dbh out)};
11
11
        unless ( index_exists( 'items_last_borrower', 'items_last_borrower_ibfk_1' ) ) {
12
        $dbh->do(
12
            $dbh->do(
13
            q{
13
                q{
14
            ALTER TABLE items_last_borrower
14
                ALTER TABLE items_last_borrower
15
            MODIFY COLUMN borrowernumber int(11) NULL,
15
                MODIFY COLUMN borrowernumber int(11) NULL,
16
            MODIFY created_on timestamp NOT NULL DEFAULT current_timestamp()
16
                MODIFY created_on timestamp NOT NULL DEFAULT current_timestamp()
17
            }
18
            );
19
            say_success( $out, "Fixed items_last_borrower.created_on column to prevent automatic timestamp updates" );
17
        }
20
        }
18
        );
19
        say_success( $out, "Fixed items_last_borrower.created_on column to prevent automatic timestamp updates" );
20
21
        $dbh->do(
21
        $dbh->do(
22
            q{
22
            q{
23
            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
23
            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
24
- 

Return to bug 23260