Attachment 81788 Details for Bug 21682 – Bug 21682: Add update DB entry for existing installs

[patch] Bug 21682: Add update DB entry for existing installs

Bug-21682-Add-update-DB-entry-for-existing-install.patch (text/plain), 1.12 KB, created by Martin Renvoize (ashimema) on 2018-11-01 08:52:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Martin Renvoize (ashimema)

Created: 2018-11-01 08:52:25 UTC

Size: 1.12 KB

patch

obsolete

>From 1ad78fe6c89ef6b8ffc03c8938698dbda1055636 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 31 Oct 2018 15:36:21 -0300
>Subject: [PATCH] Bug 21682: Add update DB entry for existing installs
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>---
> installer/data/mysql/atomicupdate/bug_21620.perl | 9 +++++++++
> 1 file changed, 9 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_21620.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_21620.perl b/installer/data/mysql/atomicupdate/bug_21620.perl
>new file mode 100644
>index 0000000000..9634be5913
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_21620.perl
>@@ -0,0 +1,9 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    # you can use $dbh here like:
>+    $dbh->do( "ALTER TABLE stockrotationrotas CHANGE COLUMN description description text" );
>+
>+    # Always end with this (adjust the bug info)
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 21620 Remove default on stockrotationrotas.description)\n";
>+}
>-- 
>2.19.1

Actions: View | Diff | Splinter Review

Attachments on bug 21682: 81280 | 81347 | 81348 | 81525 | 81526 | 81527 | 81528 | 81529 | 81769 | 81770 | 81787 | 81788 | 81815