Attachment 128154 Details for Bug 29605 – Bug 29605: additional_contents.code

[patch] Bug 29605: additional_contents.code

Bug-29605-additionalcontentscode.patch (text/plain), 2.14 KB, created by Jonathan Druart on 2021-12-02 12:09:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-12-02 12:09:27 UTC

Size: 2.14 KB

patch

obsolete

>From 1385a9e99febb324e44d0e2d7e4a36f724732e52 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 2 Dec 2021 12:28:23 +0100
>Subject: [PATCH] Bug 29605: additional_contents.code
>
>Added 100 on 210600016, but 20 in kohastructure
>---
> installer/data/mysql/atomicupdate/bug_29605.pl | 8 ++++++++
> installer/data/mysql/kohastructure.sql         | 2 +-
> 2 files changed, 9 insertions(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_29605.pl b/installer/data/mysql/atomicupdate/bug_29605.pl
>index a6bbbb08de8..5e973d7cd30 100755
>--- a/installer/data/mysql/atomicupdate/bug_29605.pl
>+++ b/installer/data/mysql/atomicupdate/bug_29605.pl
>@@ -43,6 +43,14 @@ return {
>         );
>         say $out "Ensure NOT NULL on account_offsets.type";
> 
>+        $dbh->do(
>+            q{
>+                ALTER TABLE `additional_contents`
>+                MODIFY COLUMN `code` VARCHAR(100) NOT NULL
>+            }
>+        );
>+        say $out "Ensure additional_contents.code is VARCHAR(100)";
>+
>     },
> 
> }
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 91877d51b38..292beedf5da 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -191,7 +191,7 @@ DROP TABLE IF EXISTS `additional_contents`;
> CREATE TABLE `additional_contents` (
>   `idnew` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the additional content',
>   `category` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'category for the additional content',
>-  `code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang',
>+  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'code to group content per lang',
>   `location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'location of the additional content',
>   `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'branch code users to create branch specific additional content, NULL is every branch.',
>   `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'title of the additional content',
>-- 
>2.25.1

Actions: View | Diff | Splinter Review

Attachments on bug 29605: 128113 | 128114 | 128152 | 128153 | 128154 | 128155 | 128156 | 128157 | 128158 | 128239 | 128313 | 128314 | 128437 | 128438 | 128439 | 128440 | 128441 | 128442 | 128443 | 128444 | 128445 | 128483 | 129153 | 129154 | 129155 | 129156 | 129157 | 129158 | 129159 | 129160 | 129161