]> git.koha-community.org Git - koha.git/commit
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)
committerFridolin Somers <fridolin.somers@biblibre.com>
Thu, 25 Feb 2021 09:25:10 +0000 (10:25 +0100)
commit5047073121369e0b4f6d30b448ec6ee6c1cde444
treed0d5fa397d1b3b547f011f90a9bf970c4eb4a564
parentfaec602d3ecf6379519a9499dea94a642cc7940b
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>
(cherry picked from commit 57a15eb474b5a8a6a199df1d324c30b7df0544d7)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
installer/data/mysql/updatedatabase.pl