Attachment 145700 Details for Bug 27424 – Bug 27424: Update database

[patch] Bug 27424: Update database

Bug-27424-Update-database.patch (text/plain), 1.07 KB, created by Kyle M Hall (khall) on 2023-01-26 18:45:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2023-01-26 18:45:01 UTC

Size: 1.07 KB

patch

obsolete

>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

Actions: View | Diff | Splinter Review

Attachments on bug 27424: 129673 | 129674 | 129675 | 129814 | 130168 | 130169 | 130170 | 130171 | 130172 | 130300 | 130301 | 130302 | 130303 | 130304 | 145697 | 145698 | 145699 | 145700 | 145701 | 145702 | 145705 | 145723 | 145724 | 145725 | 152192