Bugzilla – Attachment 85157 Details for
Bug 13515
Table messages is missing FK constraints and is never cleaned up
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13515: Fix constraint name before deleting it
Bug-13515-Fix-constraint-name-before-deleting-it.patch (text/plain), 1.07 KB, created by
Marcel de Rooy
on 2019-02-15 11:14:29 UTC
(
hide
)
Description:
Bug 13515: Fix constraint name before deleting it
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2019-02-15 11:14:29 UTC
Size:
1.07 KB
patch
obsolete
>From 1007b3137a210a2c4b699d68aa58110e8c78d147 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Thu, 14 Feb 2019 17:19:08 -0300 >Subject: [PATCH] Bug 13515: Fix constraint name before deleting it >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/atomicupdate/bug_13515.perl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_13515.perl b/installer/data/mysql/atomicupdate/bug_13515.perl >index 837ae458df..7a97061fba 100644 >--- a/installer/data/mysql/atomicupdate/bug_13515.perl >+++ b/installer/data/mysql/atomicupdate/bug_13515.perl >@@ -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 >-- >2.11.0
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13515
:
83367
|
83463
|
83508
|
83509
|
83510
|
85138
|
85155
|
85156
| 85157