Attachment 117268 Details for Bug 8976 – Bug 8976: Add marc_subfield_structure.display_order

[patch] Bug 8976: Add marc_subfield_structure.display_order

Bug-8976-Add-marcsubfieldstructuredisplayorder.patch (text/plain), 1.90 KB, created by Tomás Cohen Arazi (tcohen) on 2021-02-24 15:26:53 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2021-02-24 15:26:53 UTC

Size: 1.90 KB

patch

obsolete

>From e56b12197dfa5cb7d9f9e5b7a89744ece0a0a28d Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Tue, 1 Dec 2020 18:11:35 +0100
>Subject: [PATCH] Bug 8976: Add marc_subfield_structure.display_order
>
>Sponsored-by: Orex Digital
>
>Signed-off-by: Michal Denar <black23@gmail.com>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
>---
> installer/data/mysql/atomicupdate/bug_8976.perl | 13 +++++++++++++
> installer/data/mysql/kohastructure.sql          |  1 +
> 2 files changed, 14 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_8976.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_8976.perl b/installer/data/mysql/atomicupdate/bug_8976.perl
>new file mode 100644
>index 00000000000..a16c555bc08
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_8976.perl
>@@ -0,0 +1,13 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+
>+    unless ( column_exists( 'marc_subfield_structure', 'display_order' ) ) {
>+        $dbh->do(q{
>+            ALTER TABLE marc_subfield_structure
>+            ADD COLUMN display_order INT(2) NOT NULL DEFAULT 0 AFTER maxlength
>+        });
>+    }
>+
>+    # Always end with this (adjust the bug info)
>+    NewVersion( $DBversion, XXXXX, "Description");
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 952cd9d2961..033a6f505af 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3454,6 +3454,7 @@ CREATE TABLE `marc_subfield_structure` (
>   `link` varchar(80) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   `defaultvalue` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
>   `maxlength` int(4) NOT NULL DEFAULT 9999,
>+  `display_order` int(2) NOT NULL DEFAULT 0,
>   PRIMARY KEY (`frameworkcode`,`tagfield`,`tagsubfield`),
>   KEY `kohafield_2` (`kohafield`),
>   KEY `tab` (`frameworkcode`,`tab`),
>-- 
>2.30.1

Actions: View | Diff | Splinter Review

Attachments on bug 8976: 114345 | 114346 | 114347 | 114348 | 114349 | 114350 | 114351 | 114352 | 114353 | 114354 | 114355 | 114492 | 114493 | 114494 | 114495 | 114496 | 114497 | 114498 | 117147 | 117148 | 117149 | 117150 | 117151 | 117152 | 117153 | 117268 | 117269 | 117270 | 117271 | 117272 | 117273 | 117274 | 117275 | 117276 | 117477 | 117478