Attachment 98599 Details for Bug 11297 – Bug 11297: Add atomicupdate patch and modify kohastructure.sql

[patch] Bug 11297: Add atomicupdate patch and modify kohastructure.sql

Bug-11297-Add-atomicupdate-patch-and-modify-kohast.patch (text/plain), 2.25 KB, created by David Nind on 2020-02-07 22:18:42 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: David Nind

Created: 2020-02-07 22:18:42 UTC

Size: 2.25 KB

patch

obsolete

>From eb8bbfec8434cb87c8acb255e8096cf9ef6b67bd Mon Sep 17 00:00:00 2001
>From: Charles Farmer <charles.farmer@inLibro.com>
>Date: Wed, 21 Feb 2018 15:12:42 -0500
>Subject: [PATCH] Bug 11297: Add atomicupdate patch and modify
> kohastructure.sql
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>
>Signed-off-by: David Nind <david@davidnind.com>
>---
> .../mysql/atomicupdate/Bug11297_z3950servers_attributes.perl     | 9 +++++++++
> installer/data/mysql/kohastructure.sql                           | 1 +
> 2 files changed, 10 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl
>
>diff --git a/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl b/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl
>new file mode 100644
>index 0000000000..2250a26cff
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl
>@@ -0,0 +1,9 @@
>+$DBversion = 'XXX';  # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    if( !column_exists( 'z3950servers', 'attributes' ) ) {
>+        $dbh->do( "ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt" );
>+    }
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 11297 - Add support for custom PQF attributes for Z39.50 server searches)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index a82a20830b..2ccdc885ca 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2202,6 +2202,7 @@ CREATE TABLE `z3950servers` ( -- connection information for the Z39.50 targets u
>   `sru_options` varchar(255) default NULL, -- options like sru=get, sru_version=1.1; will be passed to the server via ZOOM
>   `sru_fields` LONGTEXT default NULL, -- contains the mapping between the Z3950 search fields and the specific SRU server indexes
>   `add_xslt` LONGTEXT default NULL, -- zero or more paths to XSLT files to be processed on the search results
>+  `attributes` VARCHAR(255) default NULL, -- additional attributes passed to PQF queries
>   PRIMARY KEY  (`id`)
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
> 
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 11297: 23144 | 23145 | 40829 | 40889 | 48649 | 50415 | 50416 | 50420 | 50954 | 59448 | 62938 | 62939 | 70190 | 70191 | 70192 | 70193 | 70194 | 70195 | 70196 | 71992 | 71993 | 71994 | 72061 | 72062 | 72063 | 77718 | 77719 | 77720 | 77721 | 77722 | 77723 | 78294 | 78295 | 78296 | 78297 | 80372 | 80496 | 80497 | 80498 | 80499 | 81328 | 81342 | 81343 | 81344 | 81345 | 81346 | 92719 | 92720 | 92721 | 92722 | 98598 | 98599 | 98600 | 98601 | 99227 | 99228 | 99229 | 99230 | 99231