From 6d4cfcab3a6c27e98a2fbd48219682d894925b26 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 --- .../mysql/atomicupdate/Bug11297_z3950servers_attributes.perl | 9 +++++++++ .../data/mysql/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 0000000..2250a26 --- /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 a4e56e5..0000000 --- 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.7.4