From 91ef6580f40efe28605fb5f03281c37aa8823066 Mon Sep 17 00:00:00 2001 From: Bernardo Gonzalez Kriegel Date: Fri, 18 Dec 2015 11:40:02 -0300 Subject: [PATCH] Bug 8643: (follow-up) atomic update Signed-off-by: Bernardo Gonzalez Kriegel --- .../mysql/atomicupdate/bug-8643-add_important_constraint.sql | 10 ++++++++++ installer/data/mysql/updatedatabase.pl | 8 -------- 2 files changed, 10 insertions(+), 8 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql diff --git a/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql b/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql new file mode 100644 index 0000000..0ffb746 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql @@ -0,0 +1,10 @@ +ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER mandatory; +ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER frameworkcode; + +-- $DBversion = "3.23.00.XXX"; +-- if ( CheckVersion($DBversion) ) { +-- $dbh->do("ALTER TABLE marc_subfield_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER mandatory"); +-- $dbh->do("ALTER TABLE marc_tag_structure ADD COLUMN important TINYINT(4) NOT NULL DEFAULT 0 AFTER frameworkcode"); +-- print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n"; +-- SetVersion($DBversion); +-- } diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 160f06a..b478c9b 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -11391,14 +11391,6 @@ if ( CheckVersion($DBversion) ) { SetVersion ($DBversion); } -$DBversion = "XXX"; -if ( CheckVersion($DBversion) ) { - $dbh->do("ALTER TABLE `marc_subfield_structure` ADD COLUMN `important` TINYINT(4) NOT NULL DEFAULT 0 AFTER `mandatory`"); - $dbh->do("ALTER TABLE `marc_tag_structure` ADD COLUMN `important` TINYINT(4) NOT NULL DEFAULT 0 AFTER `frameworkcode`"); - print "Upgrade to $DBversion done (Bug 8643 - Add important constraint to marc subfields)\n"; - SetVersion($DBversion); -} - # DEVELOPER PROCESS, search for anything to execute in the db_update directory # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. -- 1.9.1