From 8fd206bd1a678b86908882c164a846055352c6e9 Mon Sep 17 00:00:00 2001 From: Jonathan Druart 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