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

(-)a/installer/data/mysql/updatedatabase.pl (-1 / +5 lines)
Lines 23195-23200 if( CheckVersion( $DBversion ) ) { Link Here
23195
        ALTER TABLE letter ADD CONSTRAINT message_transport_type_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types(message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE
23195
        ALTER TABLE letter ADD CONSTRAINT message_transport_type_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types(message_transport_type) ON DELETE CASCADE ON UPDATE CASCADE
23196
    } );
23196
    } );
23197
23197
23198
    # Foreign keys should prevent this, however, it has been found in many production databases
23199
    $dbh->do( q{
23200
        DELETE borrower_message_transport_preferences FROM borrower_message_transport_preferences LEFT JOIN borrower_message_preferences USING (borrower_message_preference_id) WHERE borrower_message_preferences.borrower_message_preference_id IS NULL
23201
    } );
23202
23198
    $dbh->do(q{
23203
    $dbh->do(q{
23199
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23204
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23200
    });
23205
    });
23201
- 

Return to bug 29409