Attachment 110346 Details for Bug 26145 – Bug 26145: Refactoring - Rename table biblioimages to cover_images

[patch] Bug 26145: Refactoring - Rename table biblioimages to cover_images

Bug-26145-Refactoring---Rename-table-biblioimages-.patch (text/plain), 2.08 KB, created by Jonathan Druart on 2020-09-18 10:23:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-09-18 10:23:03 UTC

Size: 2.08 KB

patch

obsolete

>From 34b24de4625d3837dafefbb92e0329dc623d0379 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 5 Aug 2020 16:27:06 +0200
>Subject: [PATCH] Bug 26145: Refactoring - Rename table biblioimages to
> cover_images
>
>Sponsored-by: Gerhard Sondermann Dialog e.K. (presseplus.de, presseshop.at, presseshop.ch)
>---
> installer/data/mysql/atomicupdate/bug_xxxxx.perl | 9 +++++++++
> installer/data/mysql/kohastructure.sql           | 6 +++---
> 2 files changed, 12 insertions(+), 3 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_xxxxx.perl b/installer/data/mysql/atomicupdate/bug_xxxxx.perl
>index 46e0614381..7e56febb5c 100644
>--- a/installer/data/mysql/atomicupdate/bug_xxxxx.perl
>+++ b/installer/data/mysql/atomicupdate/bug_xxxxx.perl
>@@ -17,4 +17,13 @@ if( CheckVersion( $DBversion ) ) {
>     }
> 
>     NewVersion( $DBversion, 'XXXXX', "Add the biblioimages.itemnumber column");
>+
>+    if( !TableExists('cover_images') ) {
>+        $dbh->do(q|
>+            ALTER TABLE biblioimages RENAME cover_images
>+        |);
>+    }
>+
>+    # Always end with this (adjust the bug info)
>+    NewVersion( $DBversion, "XXXXX", "Rename table biblioimages with cover_images");
> }
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index fec12b7f0f..3fb23707a8 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -3367,12 +3367,12 @@ CREATE TABLE transport_cost (
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
> --
>--- Table structure for table `biblioimages`
>+-- Table structure for table `cover_images`
> --
> 
>-DROP TABLE IF EXISTS `biblioimages`;
>+DROP TABLE IF EXISTS `cover_images`;
> 
>-CREATE TABLE `biblioimages` ( -- local cover images
>+CREATE TABLE `cover_images` ( -- local cover images
>  `imagenumber` int(11) NOT NULL AUTO_INCREMENT, -- unique identifier for the image
>  `biblionumber` int(11) DEFAULT NULL, -- foreign key from biblio table to link to biblionumber
>  `itemnumber` int(11) DEFAULT NULL, -- foreign key from item table to link to itemnumber
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 26145: 109225 | 109226 | 110342 | 110343 | 110344 | 110345 | 110346 | 110347 | 110348 | 110349 | 110350 | 110351 | 110352 | 110353 | 110354 | 110675 | 110676 | 110677 | 110678 | 110679 | 110680 | 110681 | 110682 | 110683 | 110684 | 110685 | 110800 | 110861 | 110862 | 110863 | 110864 | 110865 | 110866 | 110867 | 110868 | 110869 | 110870 | 110871 | 110872 | 110873 | 110874 | 110875 | 111446 | 111447 | 111448 | 111449 | 111450 | 111451 | 111452 | 111453 | 111454 | 111455 | 111456 | 111457 | 111458