From 0f4533c319d544d2b4934ca3dead9ecb1ffc5ae1 Mon Sep 17 00:00:00 2001 From: Josef Moravec Date: Mon, 18 Mar 2019 16:48:51 +0000 Subject: [PATCH] Bug 22532: Database update Content-Type: text/plain; charset=utf-8 Signed-off-by: Hayley Mapley Signed-off-by: Marcel de Rooy --- .../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