Attachment 51762 Details for Bug 16573 – Bug 16573: change created_on type - atomic update

[patch] Bug 16573: change created_on type - atomic update

Bug-16573-change-createdon-type---atomic-update.patch (text/plain), 1.02 KB, created by Mark Tompsett on 2016-05-25 05:04:18 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Mark Tompsett

Created: 2016-05-25 05:04:18 UTC

Size: 1.02 KB

patch

obsolete

>From 3d061015b87318fd2ae202e5a7343f59a2776025 Mon Sep 17 00:00:00 2001
>From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
>Date: Tue, 24 May 2016 18:12:11 -0300
>Subject: [PATCH] Bug 16573: change created_on type - atomic update
>
>This patch change 'created_on' virtualshelves column to
>datetime type
>
>To test:
>1) Apply the patch
>2) Run updatedatabase.pl
>3) Verify type of 'created_on' column
>
>Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
>---
> installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql | 1 +
> 1 file changed, 1 insertion(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql b/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql
>new file mode 100644
>index 0000000..8b258fc
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug-16573-change-created_on-column.sql
>@@ -0,0 +1 @@
>+ALTER TABLE virtualshelves MODIFY COLUMN created_on DATETIME not NULL;
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

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