From 0ed71ca7d0fa2ad3896657db84ad28de6012a5e3 Mon Sep 17 00:00:00 2001 From: Joe Atzberger Date: Thu, 3 Jan 2008 18:20:38 -0600 Subject: [PATCH] updatedatabase - DB version to 043 for 2 new columns in currency table Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- installer/data/mysql/updatedatabase.pl | 7 +++++++ kohaversion.pl | 2 +- 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index f61c87a41f..272fb31569 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -846,6 +846,13 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.043"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE `currency` ADD `symbol` varchar(5) default NULL, ADD `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP"); + print "Upgrade to $DBversion done (currency table: add symbol and timestamp columns)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index 05a2717cd8..ab6bf2d870 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = "3.00.00.042"; + our $VERSION = "3.00.00.043"; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5