From f31ac8f3c2dd0103ec2aab551717b000403f8141 Mon Sep 17 00:00:00 2001
From: Kyle Hall <kyle@bywatersolutions.com>
Date: Tue, 25 Jan 2022 14:06:41 -0500
Subject: [PATCH] Bug 27424: Update database

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
---
 installer/data/mysql/atomicupdate/bug_27424.pl | 11 +++++++++++
 1 file changed, 11 insertions(+)
 create mode 100755 installer/data/mysql/atomicupdate/bug_27424.pl

diff --git a/installer/data/mysql/atomicupdate/bug_27424.pl b/installer/data/mysql/atomicupdate/bug_27424.pl
new file mode 100755
index 0000000000..07d4ac56e6
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_27424.pl
@@ -0,0 +1,11 @@
+use Modern::Perl;
+
+return {
+    bug_number => "27424",
+    description => "Add column to specify an SMTP server as the default",
+    up => sub {
+        my ($args) = @_;
+        my ($dbh, $out) = @$args{qw(dbh out)};
+        $dbh->do(q{ALTER TABLE smtp_servers ADD COLUMN `is_default` tinyint(1) NOT NULL DEFAULT 0 AFTER debug});
+    },
+};
-- 
2.30.2