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

(-)a/installer/data/mysql/atomicupdate/bug_23260.pl (-2 / +9 lines)
Lines 4-14 use Koha::Installer::Output qw(say_warning say_success say_info); Link Here
4
return {
4
return {
5
    bug_number  => "23260",
5
    bug_number  => "23260",
6
    description =>
6
    description =>
7
        "Make borrowernumber from items_last_borrower nullable, and add AnonymizeLastBorrower and AnonymizeLastBorrowerDays preferences",
7
        "Make created_on from items_last_borrower not update to current timestamp ON UPDATE, and add AnonymizeLastBorrower and AnonymizeLastBorrowerDays preferences",
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
12
        $dbh->do(
13
            q{
14
            ALTER TABLE items_last_borrower
15
            MODIFY created_on timestamp NOT NULL DEFAULT current_timestamp()
16
        }
17
        );
18
        say_success( $out, "Fixed items_last_borrower.created_on column to prevent automatic timestamp updates" );
19
12
        $dbh->do(
20
        $dbh->do(
13
            q{
21
            q{
14
            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
22
            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
15
- 

Return to bug 23260