Attachment 158153 Details for Bug 34438 – Bug 34438: Database update

[patch] Bug 34438: Database update

Bug-34438-Database-update.patch (text/plain), 1.07 KB, created by Lucas Gass (lukeg) on 2023-10-31 17:56:20 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lucas Gass (lukeg)

Created: 2023-10-31 17:56:20 UTC

Size: 1.07 KB

patch

obsolete

>From a18bd9654fd1407aaca4fdf819c6a5111facfe2a Mon Sep 17 00:00:00 2001
>From: Lucas Gass <lucas@bywatersolutions.com>
>Date: Tue, 31 Oct 2023 17:52:51 +0000
>Subject: [PATCH] Bug 34438: Database update
>
>---
> installer/data/mysql/atomicupdate/bug_34438.pl | 15 +++++++++++++++
> 1 file changed, 15 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_34438.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_34438.pl b/installer/data/mysql/atomicupdate/bug_34438.pl
>new file mode 100755
>index 00000000000..0876ea5e775
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_34438.pl
>@@ -0,0 +1,15 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => "34438",
>+    description => "Add lang to to the borrower_modifications table",
>+    up          => sub {
>+        my ($args) = @_;
>+        my $dbh = $args->{dbh};
>+        if ( !column_exists( 'borrower_modifications', 'lang' ) ) {
>+            $dbh->do(
>+"ALTER TABLE `borrower_modifications` ADD COLUMN `lang` VARCHAR(25) DEFAULT NULL AFTER `primary_contact_method`"
>+            );
>+        }
>+    },
>+  }
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 34438: 154001 | 154002 | 155775 | 155776 | 158152 | 158153 | 158154 | 158155 | 158156 | 158157 | 158158 | 158159 | 158181 | 158182 | 158183 | 158184 | 158196 | 158197 | 158198 | 158199