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

(-)a/installer/data/mysql/updatedatabase.pl (-5 / +5 lines)
Lines 23186-23195 $DBversion = '20.06.00.058'; Link Here
23186
if( CheckVersion( $DBversion ) ) {
23186
if( CheckVersion( $DBversion ) ) {
23187
23187
23188
    # Adding the ON DELETE CASCASE ON UPDATE CASCADE, in case it's missing (from 9016 - 3.15.00.039)
23188
    # Adding the ON DELETE CASCASE ON UPDATE CASCADE, in case it's missing (from 9016 - 3.15.00.039)
23189
    $dbh->do( q{
23189
    if ( foreign_key_exists( 'letter', 'message_transport_type_fk' ) ) {
23190
        ALTER TABLE letter DROP FOREIGN KEY message_transport_type_fk
23190
        $dbh->do( q{
23191
    } );
23191
            ALTER TABLE letter DROP FOREIGN KEY message_transport_type_fk
23192
23192
        } );
23193
    }
23193
    $dbh->do( q{
23194
    $dbh->do( q{
23194
        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
23195
    } );
23196
    } );
23196
- 

Return to bug 29409