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

[patch] Bug 34438: Database update

Bug-34438-Database-update.patch (text/plain), 1.11 KB, created by David Nind on 2023-10-31 20:12:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Nind

Created: 2023-10-31 20:12:57 UTC

Size: 1.11 KB

patch

obsolete

>From 66bf1e163eefd346c2231315feac9c45dbc26d06 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
>
>Signed-off-by: David Nind <david@davidnind.com>
>---
> 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 0000000000..0876ea5e77
>--- /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