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 |
- |
|
|