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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +9 lines)
Lines 10801-10809 if ( CheckVersion($DBversion) ) { Link Here
10801
        LEFT JOIN course_items USING(ci_id)
10801
        LEFT JOIN course_items USING(ci_id)
10802
        WHERE course_items.ci_id IS NULL
10802
        WHERE course_items.ci_id IS NULL
10803
    });
10803
    });
10804
10805
    my ($print_error) = $dbh->{PrintError};
10806
    $dbh->{RaiseError} = 0;
10807
    $dbh->{PrintError} = 0;
10808
    $dbh->do(q{ALTER TABLE course_reserves DROP FOREIGN KEY course_reserves_ibfk_2});
10809
    $dbh->do(q{ALTER TABLE course_reserves DROP INDEX course_reserves_ibfk_2});
10810
    $dbh->{PrintError} = $print_error;
10811
10804
    $dbh->do(q{
10812
    $dbh->do(q{
10805
        ALTER IGNORE TABLE course_reserves
10813
        ALTER IGNORE TABLE course_reserves
10806
            add CONSTRAINT course_reserves_ibfk_2
10814
            ADD CONSTRAINT course_reserves_ibfk_2
10807
                FOREIGN KEY (ci_id) REFERENCES course_items (ci_id)
10815
                FOREIGN KEY (ci_id) REFERENCES course_items (ci_id)
10808
                ON DELETE CASCADE ON UPDATE CASCADE
10816
                ON DELETE CASCADE ON UPDATE CASCADE
10809
    });
10817
    });
10810
- 

Return to bug 15207