Attachment 87825 Details for Bug 22532 – Bug 22532: Database update

[patch] Bug 22532: Database update

Bug-22532-Database-update.patch (text/plain), 2.05 KB, created by Hayley Pelham on 2019-04-11 23:42:49 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Hayley Pelham

Created: 2019-04-11 23:42:49 UTC

Size: 2.05 KB

patch

obsolete

>From cc7a012c45fc8793d51887a000c8bd1fcd7e20d2 Mon Sep 17 00:00:00 2001
>From: Josef Moravec <josef.moravec@gmail.com>
>Date: Mon, 18 Mar 2019 16:48:51 +0000
>Subject: [PATCH] Bug 22532: Database update
>
>Signed-off-by: Hayley Mapley <hayleymapley@catalyst.net.nz>
>
>Signed-off-by: Hayley Mapley <hayleymapley@catalyst.net.nz>
>---
> .../atomicupdate/Bug22532_remove_import_records_z39random.perl | 10 ++++++++++
> installer/data/mysql/kohastructure.sql                         |  1 -
> 2 files changed, 10 insertions(+), 1 deletion(-)
> create mode 100644 installer/data/mysql/atomicupdate/Bug22532_remove_import_records_z39random.perl
>
>diff --git a/installer/data/mysql/atomicupdate/Bug22532_remove_import_records_z39random.perl b/installer/data/mysql/atomicupdate/Bug22532_remove_import_records_z39random.perl
>new file mode 100644
>index 0000000000..553fb946f6
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/Bug22532_remove_import_records_z39random.perl
>@@ -0,0 +1,10 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    if( column_exists( 'import_records', 'z3950random' ) ) {
>+        $dbh->do( "ALTER TABLE import_records DROP COLUMN z3950random" );
>+    }
>+
>+    # Always end with this (adjust the bug info)
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug 22532 - Remove import_records z3950random column)\n";
>+}
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 8d7fee9872..1014eb38aa 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -738,7 +738,6 @@ CREATE TABLE `import_records` (
>   `status` enum('error', 'staged', 'imported', 'reverted', 'items_reverted', 'ignored') NOT NULL default 'staged',
>   `import_error` LONGTEXT,
>   `encoding` varchar(40) NOT NULL default '',
>-  `z3950random` varchar(40) default NULL,
>   PRIMARY KEY (`import_record_id`),
>   CONSTRAINT `import_records_ifbk_1` FOREIGN KEY (`import_batch_id`)
>              REFERENCES `import_batches` (`import_batch_id`) ON DELETE CASCADE ON UPDATE CASCADE,
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 22532: 86724 | 86725 | 87824 | 87825 | 87839 | 87840