|
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 |
- |
|
|