From f2192b12af5022784f9fd6a8fe0123573996cc83 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Tue, 13 Nov 2018 11:23:11 +0000 Subject: [PATCH] Bug 19893: (QA follow-up) Convert atomicupdate to .perl Signed-off-by: Martin Renvoize --- ...bug_19893_elasticsearch_index_status_sysprefs.perl | 11 +++++++++++ .../bug_19893_elasticsearch_index_status_sysprefs.sql | 2 -- 2 files changed, 11 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.perl delete mode 100644 installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.sql diff --git a/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.perl b/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.perl new file mode 100644 index 0000000000..ed95da0f05 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.perl @@ -0,0 +1,11 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if ( CheckVersion($DBversion) ) { + $dbh->do(q{ + INSERT IGNORE INTO `systempreferences` (`variable`,`value`,`explanation`,`options`,`type`) VALUES + ('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL), + ('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL) + }); + + SetVersion($DBversion); + print "Upgrade to $DBversion done (Bug 19893 - Add elasticsearch index status preferences)\n"; +} diff --git a/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.sql b/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.sql deleted file mode 100644 index 2412bcbc18..0000000000 --- a/installer/data/mysql/atomicupdate/bug_19893_elasticsearch_index_status_sysprefs.sql +++ /dev/null @@ -1,2 +0,0 @@ -INSERT IGNORE INTO systempreferences (variable, value, explanation, options, type) VALUES ('ElasticsearchIndexStatus_biblios', '0', 'Biblios index status', NULL, NULL); -INSERT IGNORE INTO systempreferences (variable, value, explanation, options, type) VALUES ('ElasticsearchIndexStatus_authorities', '0', 'Authorities index status', NULL, NULL); -- 2.19.1