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 23191-23196 if( CheckVersion( $DBversion ) ) { Link Here
23191
23191
23192
$DBversion = '20.06.00.058';
23192
$DBversion = '20.06.00.058';
23193
if( CheckVersion( $DBversion ) ) {
23193
if( CheckVersion( $DBversion ) ) {
23194
23195
    # Adding the ON DELETE CASCASE ON UPDATE CASCADE, in case it's missing (from 9016 - 3.15.00.039)
23196
    $dbh->do( q{
23197
    ALTER TABLE letter DROP FOREIGN KEY message_transport_type_fk
23198
    } );
23199
23200
    $dbh->do( q{
23201
        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
23202
    } );
23203
23194
    $dbh->do(q{
23204
    $dbh->do(q{
23195
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23205
        UPDATE message_transport_types SET message_transport_type = "itiva" WHERE message_transport_type = "phone"
23196
    });
23206
    });
23197
- 

Return to bug 27534