Attachment 175150 Details for Bug 38256 – Bug 38256: Add a column for a vendor

[patch] Bug 38256: Add a column for a vendor

Bug-38256-Add-a-column-for-a-vendor.patch (text/plain), 3.31 KB, created by Matt Blenkinsop on 2024-12-04 10:19:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Matt Blenkinsop

Created: 2024-12-04 10:19:04 UTC

Size: 3.31 KB

patch

obsolete

>From 7aca9e354d24a3a1ad4455e31d9cf2c7cb412ae1 Mon Sep 17 00:00:00 2001
>From: Matt Blenkinsop <matt.blenkinsop@ptfs-europe.com>
>Date: Thu, 24 Oct 2024 13:59:05 +0000
>Subject: [PATCH] Bug 38256: Add a column for a vendor
>
>(cherry picked from commit 757664a10e2bea8632c9c44bfe3e9d7f589903fc)
>---
> ...ug_38256-link_vendors_to_data_providers.pl | 37 +++++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  5 ++-
> 2 files changed, 41 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/bug_38256-link_vendors_to_data_providers.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_38256-link_vendors_to_data_providers.pl b/installer/data/mysql/atomicupdate/bug_38256-link_vendors_to_data_providers.pl
>new file mode 100644
>index 00000000000..17ab0069920
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_38256-link_vendors_to_data_providers.pl
>@@ -0,0 +1,37 @@
>+use Modern::Perl;
>+use Koha::Installer::Output qw(say_warning say_failure say_success say_info);
>+
>+return {
>+    bug_number  => "38256",
>+    description => "Link vendors to data providers",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        unless ( column_exists( 'erm_usage_data_providers', 'vendor_id' ) ) {
>+            $dbh->do(
>+                q{
>+                    ALTER TABLE erm_usage_data_providers
>+                        ADD COLUMN `vendor_id` int(11) DEFAULT NULL
>+                        COMMENT 'the vendor linked to this provider'
>+                        AFTER service_platform
>+            }
>+            );
>+
>+            say $out "Added new column 'erm_usage_data_providers.vendor'";
>+        }
>+
>+        unless ( foreign_key_exists( 'erm_usage_data_providers', 'erm_usage_data_providers_ibfk_1' ) ) {
>+            $dbh->do(
>+                q{
>+                    ALTER TABLE erm_usage_data_providers
>+                    ADD CONSTRAINT `erm_usage_data_providers_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>+                }
>+                ) == 1
>+                && say_success(
>+                $out,
>+                "Added foreign key 'erm_usage_data_providers_ibfk_1' to column 'erm_usage_data_providers.vendor_id'"
>+                );
>+        }
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index d56d37fd476..311c8f4f03f 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3230,7 +3230,10 @@ CREATE TABLE `erm_usage_data_providers` (
>   `requestor_email` varchar(80) DEFAULT NULL COMMENT 'requestor email',
>   `report_types` varchar(255) DEFAULT NULL COMMENT 'report types provided by the harvester',
>   `service_platform` varchar(80) DEFAULT NULL COMMENT 'platform if provider requires it',
>-  PRIMARY KEY (`erm_usage_data_provider_id`)
>+  `vendor_id` int(11) DEFAULT NULL COMMENT 'foreign key to aqbooksellers',
>+  PRIMARY KEY (`erm_usage_data_provider_id`),
>+  KEY `erm_usage_data_provider_ibfk_1` (`vendor_id`),
>+  CONSTRAINT `erm_usage_data_provider_ibfk_1` FOREIGN KEY (`vendor_id`) REFERENCES `aqbooksellers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> /*!40101 SET character_set_client = @saved_cs_client */;
> 
>-- 
>2.39.3 (Apple Git-146)

Actions: View | Diff | Splinter Review

Attachments on bug 38256: 175150 | 175151 | 175152 | 175153