@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/bug-8643-add_important_constraint.sql +++ a/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); +-- } --