Attachment 99785 Details for Bug 24559 – Bug 24559: Database update

[patch] Bug 24559: Database update

Bug-24559-Database-update.patch (text/plain), 1.23 KB, created by Nick Clemens (kidclamp) on 2020-02-28 16:46:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2020-02-28 16:46:49 UTC

Size: 1.23 KB

patch

obsolete

>From 66e8b9bdf10fc04badef900a59a4a73f78b27c7a Mon Sep 17 00:00:00 2001
>From: Nick <nick@bywatersolutions.com>
>Date: Fri, 28 Feb 2020 11:38:46 -0500
>Subject: [PATCH] Bug 24559: Database update
>
>---
> installer/data/mysql/atomicupdate/bug_24559.perl | 19 +++++++++++++++++++
> 1 file changed, 19 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24559.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24559.perl b/installer/data/mysql/atomicupdate/bug_24559.perl
>new file mode 100644
>index 0000000000..37c112a615
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24559.perl
>@@ -0,0 +1,19 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do(q{
>+        ALTER TABLE search_field
>+        MODIFY COLUMN type enum(
>+            '',
>+            'string',
>+            'date',
>+            'year',
>+            'number',
>+            'boolean',
>+            'sum',
>+            'isbn',
>+            'stdno'
>+        ) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'what type of data this holds, relevant when storing it in the search engine'
>+    });
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 24559 - add year option to es types)\n";
>+}
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24559: 99626 | 99785 | 99791 | 99792