Attachment 129158 Details for Bug 29605 – Bug 29605: additional_contents.lang

[patch] Bug 29605: additional_contents.lang

Bug-29605-additionalcontentslang.patch (text/plain), 2.56 KB, created by Nick Clemens (kidclamp) on 2022-01-07 13:16:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2022-01-07 13:16:25 UTC

Size: 2.56 KB

patch

obsolete

>From 94e2995c9454c973c8feca5c96e6c53eb76221ce Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 2 Dec 2021 12:29:37 +0100
>Subject: [PATCH] Bug 29605: additional_contents.lang
>
>Up to 50 on bug 23797 but bug 24387 switched it back to 25 (bad
>resolution conflict)
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> 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 5e973d7cd3..d07fc1f9a3 100755
>--- a/installer/data/mysql/atomicupdate/bug_29605.pl
>+++ b/installer/data/mysql/atomicupdate/bug_29605.pl
>@@ -51,6 +51,14 @@ return {
>         );
>         say $out "Ensure additional_contents.code is VARCHAR(100)";
> 
>+        $dbh->do(
>+            q{
>+                ALTER TABLE `additional_contents`
>+                MODIFY COLUMN `lang` VARCHAR(50) NOT NULL DEFAULT ''
>+            }
>+        );
>+        say $out "Ensure additional_contents.lang is VARCHAR(50)";
>+
>     },
> 
> }
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 292beedf5d..8a2c488ac1 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -196,7 +196,7 @@ CREATE TABLE `additional_contents` (
>   `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',
>   `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'the body of your additional content',
>-  `lang` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)',
>+  `lang` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'location for the additional content(koha is the staff interface, slip is the circulation receipt and language codes are for the opac)',
>   `published_on` date DEFAULT NULL COMMENT 'publication date',
>   `updated_on` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'last modification',
>   `expirationdate` date DEFAULT NULL COMMENT 'date the additional content is set to expire or no longer be visible',
>-- 
>2.30.2

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