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