Attachment 53664 Details for Bug 16573 – Bug 16573: Define virtualshelves.created_on as datetime for existing installs

[patch] Bug 16573: Define virtualshelves.created_on as datetime for existing installs

Bug-16573-Define-virtualshelvescreatedon-as-dateti.patch (text/plain), 1013 bytes, created by Mark Tompsett on 2016-07-22 19:34:22 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2016-07-22 19:34:22 UTC

Size: 1013 bytes

patch

obsolete

>From d163d0ee7a83ffd482efbbaed4019491c0c3868e Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Fri, 22 Jul 2016 09:51:00 +0100
>Subject: [PATCH] Bug 16573: Define virtualshelves.created_on as datetime for
> existing installs
>
>Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
>---
> installer/data/mysql/updatedatabase.pl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 372d6e4..d221aba 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -10387,7 +10387,7 @@ $DBversion = "3.19.00.038";
> if ( CheckVersion($DBversion) ) {
>     $dbh->do(q|
>         ALTER TABLE virtualshelves
>-        ADD COLUMN created_on TIMESTAMP NOT NULL AFTER lastmodified
>+        ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified
>     |);
>     # Set created_on = lastmodified
>     # I would say it's better than 0000-00-00
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 16573: 51727 | 51728 | 51741 | 51751 | 51760 | 51761 | 51762 | 53639 | 53664 | 53676 | 53677 | 53678 | 53679 | 54658