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

(-)a/installer/data/mysql/atomicupdate/bug_32630.pl (-1 / +24 lines)
Line 0 Link Here
0
- 
1
use Modern::Perl;
2
use Koha::Installer::Output qw(say_warning say_success say_info);
3
4
return {
5
    bug_number  => "32630",
6
    description => "Don't delete illrequests when borrower is deleted",
7
    up          => sub {
8
        my ($args) = @_;
9
        my ( $dbh, $out ) = @$args{qw(dbh out)};
10
11
        $dbh->do(q{ ALTER TABLE illrequests DROP FOREIGN KEY illrequests_bnfk });
12
        $dbh->do(
13
            q{
14
                ALTER TABLE illrequests ADD CONSTRAINT illrequests_bnfk
15
                FOREIGN KEY(`borrowernumber`)
16
                REFERENCES `borrowers` (`borrowernumber`)
17
                ON DELETE SET NULL ON UPDATE CASCADE;
18
            }
19
        );
20
21
        # Other information
22
        say_success( $out, "Updated borrowernumber constraint" );
23
    },
24
};

Return to bug 32630