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

(-)a/installer/data/mysql/updatedatabase.pl (-2 / +11 lines)
Lines 8300-8306 if ( CheckVersion($DBversion) ) { Link Here
8300
    } );
8300
    } );
8301
8301
8302
    $dbh->do( q{
8302
    $dbh->do( q{
8303
        ALTER TABLE letter ADD CONSTRAINT message_transport_type_fk FOREIGN KEY (message_transport_type) REFERENCES message_transport_types(message_transport_type);
8303
        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
8304
    } );
8304
    } );
8305
8305
8306
    $dbh->do( q{
8306
    $dbh->do( q{
Lines 23189-23194 if( CheckVersion( $DBversion ) ) { Link Here
23189
23189
23190
$DBversion = '20.06.00.058';
23190
$DBversion = '20.06.00.058';
23191
if( CheckVersion( $DBversion ) ) {
23191
if( CheckVersion( $DBversion ) ) {
23192
23193
    # Adding the ON DELETE CASCASE ON UPDATE CASCADE, in case it's missing (from 9016 - 3.15.00.039)
23194
    $dbh->do( q{
23195
    ALTER TABLE letter DROP FOREIGN KEY message_transport_type_fk
23196
    } );
23197
23198
    $dbh->do( q{
23199
        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
23200
    } );
23201
23192
    $dbh->do(q{
23202
    $dbh->do(q{
23193
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23203
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23194
    });
23204
    });
23195
- 

Return to bug 27534