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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +15 lines)
Lines 20707-20712 if( CheckVersion( $DBversion ) ) { Link Here
20707
        note
20707
        note
20708
    );
20708
    );
20709
20709
20710
    $dbh->do(q|
20711
        DELETE i FROM issuingrules i
20712
        LEFT JOIN itemtypes it ON i.itemtype=it.itemtype
20713
        WHERE it.itemtype IS NULL
20714
    |);
20715
    $dbh->do(q|
20716
        DELETE i FROM issuingrules i
20717
        LEFT JOIN branches b ON i.branchcode=b.branchcode
20718
        WHERE b.branchcode IS NULL
20719
    |);
20720
    $dbh->do(q|
20721
        DELETE i FROM issuingrules i
20722
        LEFT JOIN categories c ON i.categorycode=c.categorycode
20723
        WHERE c.categorycode IS NULL
20724
    |);
20710
    if ( column_exists( 'issuingrules', 'categorycode' ) ) {
20725
    if ( column_exists( 'issuingrules', 'categorycode' ) ) {
20711
        foreach my $column ( @columns ) {
20726
        foreach my $column ( @columns ) {
20712
            $dbh->do("
20727
            $dbh->do("
20713
- 

Return to bug 26911