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