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