Bug 27534: Add missing ON UPDATE/DELETE clause to message_transport_type_fk
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Wed, 27 Jan 2021 08:43:02 +0000 (09:43 +0100)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Tue, 23 Feb 2021 12:12:51 +0000 (13:12 +0100)
commit57a15eb474b5a8a6a199df1d324c30b7df0544d7
tree90f9a20915d1e29da06aaf3a7439bfec0983b367
parent63e3311b109797a60bf6dcaf34e16abb8e3f9fda
Bug 27534: Add missing ON UPDATE/DELETE clause to message_transport_type_fk

Bug 9016 (3.15.00.039) added message_transport_type_fk but the ON DELETE
CASCADE ON UPDATE CASCADE clause was missing from the updatedatabase
entry.
If we are upgrading from an old version, 20.06.00.058 will fail on
updating the message_transport_type, with
"Cannot delete or update a parent row: a foreign key constraint fails".

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
installer/data/mysql/updatedatabase.pl