From 2a02844f02fa7880164e71b50fe2af30f98cc89b 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

---
 .../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 b7356ad4a1..843cf4dd25 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