From 32f63f48d6251cbb8d2181b86983a7275f7be022 Mon Sep 17 00:00:00 2001 From: Kyle Hall Date: Tue, 25 Jan 2022 14:06:41 -0500 Subject: [PATCH] Bug 27424: Update database --- 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 00000000000..07d4ac56e66 --- /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