From 276ab0a48963da6723a586d1508a51e7596d0958 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Fri, 7 May 2021 11:49:40 +0200 Subject: [PATCH] Bug 14723: Make DB rev idempotent Signed-off-by: Jonathan Druart --- .../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 3d3098c504..ad7007e2dc 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.39.5