Attachment 157117 Details for Bug 31503 – Bug 31503: Change patron_consent.type

[patch] Bug 31503: Change patron_consent.type

Bug-31503-Change-patronconsenttype.patch (text/plain), 2.04 KB, created by Marcel de Rooy on 2023-10-13 15:37:01 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marcel de Rooy

Created: 2023-10-13 15:37:01 UTC

Size: 2.04 KB

patch

obsolete

>From 61d9287628f88f7a6e27dbb9855471371d552e88 Mon Sep 17 00:00:00 2001
>From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Date: Tue, 29 Aug 2023 14:09:09 +0200
>Subject: [PATCH] Bug 31503: Change patron_consent.type
>Content-Type: text/plain; charset=utf-8
>
>Test plan:
>Run db rev.
>
>Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
>Signed-off-by: David Nind <david@davidnind.com>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> installer/data/mysql/atomicupdate/bug31503.pl | 16 ++++++++++++++++
> installer/data/mysql/kohastructure.sql        |  2 +-
> 2 files changed, 17 insertions(+), 1 deletion(-)
> create mode 100755 installer/data/mysql/atomicupdate/bug31503.pl
>
>diff --git a/installer/data/mysql/atomicupdate/bug31503.pl b/installer/data/mysql/atomicupdate/bug31503.pl
>new file mode 100755
>index 0000000000..25871e187f
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug31503.pl
>@@ -0,0 +1,16 @@
>+use Modern::Perl;
>+
>+return {
>+    bug_number  => 31503,
>+    description => "Change patron_consent.type",
>+    up          => sub {
>+        my ($args) = @_;
>+        my ( $dbh, $out ) = @$args{qw(dbh out)};
>+
>+        $dbh->do(
>+            q{ALTER TABLE `patron_consent` MODIFY `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type'}
>+        );
>+
>+        say $out "Changed column 'patron_consent.type'";
>+    },
>+};
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index d91bd46b32..721e2b340c 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -4638,7 +4638,7 @@ DROP TABLE IF EXISTS `patron_consent`;
> CREATE TABLE `patron_consent` (
>   `id` int(11) NOT NULL AUTO_INCREMENT,
>   `borrowernumber` int(11) NOT NULL,
>-  `type` enum('GDPR_PROCESSING') DEFAULT NULL COMMENT 'allows for future extension',
>+  `type` tinytext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'consent type, could be custom type',
>   `given_on` datetime DEFAULT NULL,
>   `refused_on` datetime DEFAULT NULL,
>   PRIMARY KEY (`id`),
>-- 
>2.30.2

Actions: View | Diff | Splinter Review

Attachments on bug 31503: 140047 | 140048 | 140049 | 140050 | 140080 | 140081 | 140082 | 140083 | 140084 | 140085 | 140087 | 140088 | 140089 | 140090 | 140666 | 140667 | 140668 | 140669 | 140670 | 140671 | 140672 | 141216 | 141217 | 141218 | 141219 | 141220 | 141221 | 141222 | 141263 | 141264 | 141265 | 141266 | 141267 | 141268 | 141269 | 141302 | 141570 | 155000 | 155001 | 155002 | 155003 | 155177 | 155178 | 155179 | 155180 | 155189 | 155190 | 155191 | 155656 | 155657 | 155658 | 155659 | 155660 | 155661 | 155691 | 155694 | 155783 | 155784 | 155785 | 155786 | 155787 | 155788 | 155789 | 155790 | 155791 | 157117 | 157118 | 157119 | 157120 | 157121 | 157122 | 157123 | 157124 | 157125 | 157126 | 157773 | 157774 | 157775 | 157776 | 157777 | 157778 | 157779 | 157780 | 157781 | 157782 | 157783