From efe82257383e40f3f02fc2d2678179011e7144cd Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Mon, 6 May 2024 09:35:59 -0300 Subject: [PATCH] Bug 25159: (QA follow-up) Make dbrev idempotent Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/db_revs/231200043.pl | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/db_revs/231200043.pl b/installer/data/mysql/db_revs/231200043.pl index 944f2e30418..315b9975c92 100755 --- a/installer/data/mysql/db_revs/231200043.pl +++ b/installer/data/mysql/db_revs/231200043.pl @@ -7,7 +7,10 @@ return { my ($args) = @_; my ( $dbh, $out ) = @$args{qw(dbh out)}; - $dbh->do(q{ALTER TABLE action_logs ADD COLUMN diff LONGTEXT NULL DEFAULT NULL AFTER trace;}); + unless ( column_exists( 'action_logs', 'diff' ) ) { + $dbh->do(q{ALTER TABLE action_logs ADD COLUMN diff LONGTEXT NULL DEFAULT NULL AFTER trace;}); + } + say $out "Added column 'action_logs.diff'"; }, }; -- 2.45.0