Attachment 160717 Details for Bug 35724 – Bug 35724: Database changes

[patch] Bug 35724: Database changes

Bug-35724-Database-changes.patch (text/plain), 2.37 KB, created by Alex Buckley on 2024-01-09 18:57:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Alex Buckley

Created: 2024-01-09 18:57:33 UTC

Size: 2.37 KB

patch

obsolete

>From 88616c96285c59b54f2b135b7def08a1c7f920af Mon Sep 17 00:00:00 2001
>From: Alex Buckley <alexbuckley@catalyst.net.nz>
>Date: Mon, 8 Jan 2024 14:40:38 +0000
>Subject: [PATCH] Bug 35724: Database changes
>
>Sponsored-by: Waikato Institute of Technology, New Zealand
>---
> ...d_upload_port_and_download_port_columns.pl | 26 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  2 ++
> 2 files changed, 28 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_35724-add_upload_port_and_download_port_columns.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_35724-add_upload_port_and_download_port_columns.pl b/installer/data/mysql/atomicupdate/bug_35724-add_upload_port_and_download_port_columns.pl
>new file mode 100644
>index 00000000000..ae30bc55b63
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_35724-add_upload_port_and_download_port_columns.pl
>@@ -0,0 +1,26 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "35724",
>+    description => "Add new fields to EDI accounts for librarians to configure non-standard EDI SFTP port numbers",
>+    up => sub {
>+        my ($args) = @_; 
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+
>+        if( !column_exists( 'vendor_edi_accounts', 'upload_port' ) ) { 
>+          $dbh->do(q{
>+              ALTER TABLE vendor_edi_accounts ADD COLUMN `upload_port` varchar(40) DEFAULT '22' AFTER `password`
>+          });
>+
>+          say $out "Added column 'vendor_edi_accounts.upload_port'";
>+        }
>+
>+        if( !column_exists( 'vendor_edi_accounts', 'download_port' ) ) {
>+          $dbh->do(q{
>+              ALTER TABLE vendor_edi_accounts ADD COLUMN `download_port` varchar(40) DEFAULT '22' AFTER `password`
>+          });
>+
>+          say $out "Added column 'vendor_edi_accounts.download_port'";
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 16310f0f449..9b2f2d02fe3 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -6427,6 +6427,8 @@ CREATE TABLE `vendor_edi_accounts` (
>   `host` varchar(40) DEFAULT NULL,
>   `username` varchar(40) DEFAULT NULL,
>   `password` mediumtext DEFAULT NULL,
>+  `upload_port` varchar(40) DEFAULT NULL,
>+  `download_port` varchar(40) DEFAULT NULL,
>   `last_activity` date DEFAULT NULL,
>   `vendor_id` int(11) DEFAULT NULL,
>   `download_directory` mediumtext DEFAULT NULL,
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 35724: 160644 | 160645 | 160646 | 160717 | 160718 | 160719 | 160720 | 162494 | 162495 | 162496 | 162497 | 162498 | 162499