Attachment 104526 Details for Bug 24807 – Bug 24807: Add database update script

[patch] Bug 24807: Add database update script

Bug-24807-Add-database-update-script.patch (text/plain), 1.26 KB, created by Nick Clemens (kidclamp) on 2020-05-07 16:27:46 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2020-05-07 16:27:46 UTC

Size: 1.26 KB

patch

obsolete

>From a543472091e84aad4b1f1ea824494786728db77c Mon Sep 17 00:00:00 2001
>From: David Gustafsson <david.gustafsson@ub.gu.se>
>Date: Thu, 5 Mar 2020 11:35:32 +0100
>Subject: [PATCH] Bug 24807: Add database update script
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> .../mysql/atomicupdate/bug_24807-add-year-search-field-type.perl   | 7 +++++++
> 1 file changed, 7 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24807-add-year-search-field-type.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24807-add-year-search-field-type.perl b/installer/data/mysql/atomicupdate/bug_24807-add-year-search-field-type.perl
>new file mode 100644
>index 0000000000..480072c880
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24807-add-year-search-field-type.perl
>@@ -0,0 +1,7 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do( "ALTER TABLE `search_field` MODIFY COLUMN `type` enum('','string','date','number','boolean','sum','isbn','stdno','year') NOT NULL" );
>+    $dbh->do( "UPDATE `search_field` SET type = 'year' WHERE name = 'date-of-publication'" );
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 14957 - Add 'year' type to improve sorting behaviour)\n";
>+}
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24807: 100170 | 100171 | 100176 | 102547 | 102548 | 103084 | 103085 | 103086 | 103087 | 103163 | 103277 | 104525 | 104526 | 104527 | 104528 | 104529 | 104530 | 104531 | 106768 | 108382 | 108383 | 108384 | 108385 | 108386 | 108387 | 108388 | 108389 | 109997 | 109998 | 109999 | 110000 | 110001 | 110002 | 110003 | 110004 | 110355 | 110884