Attachment 117147 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.84 KB, created by Jonathan Druart on 2021-02-22 13:16:59 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2021-02-22 13:16:59 UTC

Size: 1.84 KB

patch

obsolete

>From 210c4c5d9a2bfb3c7481c0c9e46b2f96af09fa64 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>
>---
> 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 0000000000..a16c555bc0
>--- /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 952cd9d296..033a6f505a 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.20.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