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

[patch] Bug 31017: DB Updates

Bug-31017-DB-Updates.patch (text/plain), 2.26 KB, created by Nick Clemens (kidclamp) on 2022-06-23 11:02:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-06-23 11:02:59 UTC

Size: 2.26 KB

patch

obsolete

>From 076e1024e1beac94169298b43b8192b49f7fdc50 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
>
>---
> .../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 9d2e286c17..3b6f6cbb1b 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