Attachment 53679 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), 1.06 KB, created by Jonathan Druart on 2016-07-25 10:49:10 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2016-07-25 10:49:10 UTC

Size: 1.06 KB

patch

obsolete

>From f9a20994367e2374d1bc0337c4df6e278887a32f 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>
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>---
> 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.8.1

Actions: View | Diff | Splinter Review

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