[Koha-patches] [PATCH] Bug 3977 Follow up. Suppress unnecessary table update

Frédéric Demians f.demians at tamil.fr
Tue Feb 1 08:42:59 CET 2011


updatabase.pl try for v. 3.03.00.016 to add a new column 'privacy' to borrowers
table, but this column already exists: introduced by 3.01.00.072 version.
---
 installer/data/mysql/updatedatabase.pl |    1 -
 1 files changed, 0 insertions(+), 1 deletions(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index d91b295..1d24d66 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -3974,7 +3974,6 @@ $DBversion = '3.03.00.016';
 if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
     # reimplement OpacPrivacy system preference
     $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES('OpacPrivacy', '0', 'if ON, allows patrons to define their privacy rules (reading history)',NULL,'YesNo')");
-    $dbh->do("ALTER TABLE `borrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
     $dbh->do("ALTER TABLE `deletedborrowers` ADD `privacy` INTEGER NOT NULL DEFAULT 1;");
     print "Upgrade to $DBversion done (OpacPrivacy reimplementation)\n";
     SetVersion($DBversion);
-- 
1.7.3.5



More information about the Koha-patches mailing list