From 6b442df3683e9f370be7065f813d21a43235ae60 Mon Sep 17 00:00:00 2001 From: Charles Farmer Date: Fri, 26 Oct 2018 14:32:25 -0400 Subject: [PATCH] Bug 11297: (QA follow-up) Make the database update script idempotent Signed-off-by: Martin Renvoize --- .../atomicupdate/Bug11297_z3950servers_attributes.perl | 9 +++++++++ .../atomicupdate/Bug11297_z3950servers_attributes.sql | 1 - 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.perl delete mode 100644 installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.sql 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/atomicupdate/Bug11297_z3950servers_attributes.sql b/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.sql deleted file mode 100644 index a4e56e5501..0000000000 --- a/installer/data/mysql/atomicupdate/Bug11297_z3950servers_attributes.sql +++ /dev/null @@ -1 +0,0 @@ - ALTER TABLE z3950servers ADD COLUMN attributes VARCHAR(255) after add_xslt; -- 2.19.1