Attachment 120667 Details for Bug 14723 – Bug 14723: Make DBrev idempotent

[patch] Bug 14723: Make DBrev idempotent

Bug-14723-Make-DBrev-idempotent.patch (text/plain), 1.20 KB, created by Jonathan Druart on 2021-05-07 09:49:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-05-07 09:49:59 UTC

Size: 1.20 KB

patch

obsolete

>From 8fd206bd1a678b86908882c164a846055352c6e9 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 7 May 2021 11:49:40 +0200
>Subject: [PATCH] Bug 14723: Make DBrev idempotent
>
>---
> .../Bug-14723_-_Additional_delivery_notes_to_messages.perl    | 4 +++-
> 1 file changed, 3 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl b/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl
>index 3d3098c5044..ad7007e2dc2 100644
>--- a/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl
>+++ b/installer/data/mysql/atomicupdate/Bug-14723_-_Additional_delivery_notes_to_messages.perl
>@@ -1,6 +1,8 @@
> $DBversion = 'XXX';  # will be replaced by the RM
> if( CheckVersion( $DBversion ) ) {
>-    $dbh->do("ALTER TABLE message_queue ADD delivery_note mediumtext AFTER content_type");
>+    unless ( column_exists('message_queue', 'delivery_note') ) {
>+        $dbh->do("ALTER TABLE message_queue ADD delivery_note mediumtext AFTER content_type");
>+    }
> 
>     # Always end with this (adjust the bug info)
>     SetVersion( $DBversion );
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 14723: 42053 | 42074 | 42159 | 42170 | 42227 | 42228 | 42384 | 42453 | 42455 | 42466 | 42505 | 42553 | 42574 | 42668 | 42669 | 44367 | 44413 | 62080 | 62138 | 78313 | 87525 | 87531 | 105776 | 105777 | 116642 | 116643 | 118225 | 120252 | 120309 | 120310 | 120312 | 120314 | 120376 | 120487 | 120488 | 120489 | 120490 | 120491 | 120492 | 120667