From d8e0f61f0ed374e8e25e3388046280f5efe98922 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Wed, 25 Jun 2008 15:24:41 -0500 Subject: [PATCH] bug 2176: fix typo in column name (DB rev 096) In borrower_message_preferences, wants_digets => wants_digest Note that the typo is present only in databases that had borrower_message_preferences created via updatedatabase.pl. Signed-off-by: Andrew Moore Signed-off-by: Joshua Ferraro --- installer/data/mysql/updatedatabase.pl | 10 ++++++++++ kohaversion.pl | 2 +- 2 files changed, 11 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index b52af71417..e008b6fa10 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -1825,6 +1825,16 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.096"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $sth = $dbh->prepare("SHOW COLUMNS FROM borrower_message_preferences LIKE 'wants_digets'"); + $sth->execute(); + if (my $row = $sth->fetchrow_hashref) { + $dbh->do("ALTER TABLE borrower_message_preferences CHANGE wants_digets wants_digest tinyint(1) NOT NULL default 0"); + } + print "Upgrade to $DBversion done (fix name borrower_message_preferences.wants_digest)\n"; + SetVersion ($DBversion); +} =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index 8d0cf55095..a3b0213b55 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = "3.00.00.095"; + our $VERSION = "3.00.00.096"; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5