Attachment 138116 Details for Bug 31017 – Bug 31017: DB Updates

[patch] Bug 31017: DB Updates

Bug-31017-DB-Updates.patch (text/plain), 2.32 KB, created by ByWater Sandboxes on 2022-07-26 07:01:30 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: ByWater Sandboxes

Created: 2022-07-26 07:01:30 UTC

Size: 2.32 KB

patch

obsolete

>From e7e6a8bc72b4fc9783d9478aead80ac70113f007 Mon Sep 17 00:00:00 2001
>From: Nick Clemens <nick@bywatersolutions.com>
>Date: Thu, 23 Jun 2022 10:57:31 +0000
>Subject: [PATCH] Bug 31017: DB Updates
>
>Signed-off-by: KIT Library Germany <michaela.sieber@kit.edu>
>---
> .../data/mysql/atomicupdate/bug_31017.pl      | 20 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  1 +
> 2 files changed, 21 insertions(+)
> create mode 100755 installer/data/mysql/atomicupdate/bug_31017.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_31017.pl b/installer/data/mysql/atomicupdate/bug_31017.pl
>new file mode 100755
>index 0000000000..bf97b870e1
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_31017.pl
>@@ -0,0 +1,20 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number => "31017",
>+    description => "Add type option to vendors",
>+    up => sub {
>+        my ($args) = @_;
>+        my ($dbh, $out) = @$args{qw(dbh out)};
>+        unless( column_exists('aqbooksellers','vendor_type') ){
>+            $dbh->do(q{
>+                ALTER TABLE aqbooksellers ADD COLUMN vendor_type varchar(255) DEFAULT NULL AFTER accountnumber
>+            });
>+            say $out "Added vendor_type column";
>+        }
>+        $dbh->do(q{
>+            INSERT IGNORE INTO authorised_value_categories( category_name, is_system ) VALUES ('VENDOR_TYPE', 1);
>+        });
>+        say $out "Added VENDOR_TYPE authorised value category";
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 6f43bdb954..1c42172886 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -403,6 +403,7 @@ CREATE TABLE `aqbooksellers` (
>   `address4` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'fourth line of vendor physical address',
>   `phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vendor phone number',
>   `accountnumber` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vendor account number',
>+  `vendor_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   `notes` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'order notes',
>   `postal` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vendor postal address (all lines)',
>   `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'vendor web address',
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 31017: 136443 | 136444 | 136445 | 136903 | 137134 | 138116 | 138117 | 138118 | 138942 | 138943 | 138944 | 138945 | 138964 | 138965 | 138966 | 138967 | 139007