[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