Bug 13515: Fix constraint name before deleting it
authorJonathan Druart <jonathan.druart@bugs.koha-community.org>
Thu, 14 Feb 2019 20:19:08 +0000 (17:19 -0300)
committerNick Clemens <nick@bywatersolutions.com>
Fri, 15 Feb 2019 13:12:22 +0000 (13:12 +0000)
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

installer/data/mysql/atomicupdate/bug_13515.perl

index 837ae45..7a97061 100644 (file)
@@ -1,7 +1,7 @@
 $DBversion = 'XXX';  # will be replaced by the RM
 if( CheckVersion( $DBversion ) ) {
 
-    unless( foreign_key_exists( 'messages', 'borrowernumber' ) ) {
+    unless( foreign_key_exists( 'messages', 'messages_borrowernumber' ) ) {
         $dbh->do(q|
             DELETE m FROM messages m
             LEFT JOIN borrowers b ON m.borrowernumber=b.borrowernumber