From da0bda6f53582c9f11c7de4cacb3bbdc21b7f8cb 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 ++++++++++ 1 file changed, 10 insertions(+) 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); +-- } -- 1.9.1