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