From 929fa79054d0d3cd93fdc2665de995af2bb5ac07 Mon Sep 17 00:00:00 2001 From: Mason James Date: Thu, 8 Nov 2007 00:42:37 -0600 Subject: [PATCH] extended missed branchcode columns to 10 chars Signed-off-by: Chris Cormack Signed-off-by: Joshua Ferraro --- kohaversion.pl | 2 +- updater/updatedatabase | 15 +++++++++++++++ 2 files changed, 16 insertions(+), 1 deletion(-) diff --git a/kohaversion.pl b/kohaversion.pl index ff922c69a0..bf13e87884 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -8,7 +8,7 @@ # and is automatically called by Auth.pm when needed. sub kohaversion { - return "3.00.00.020"; + return "3.00.00.021"; } 1; diff --git a/updater/updatedatabase b/updater/updatedatabase index b531efe395..193874e50f 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -543,6 +543,21 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = "3.00.00.021"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE items CHANGE homebranch homebranch VARCHAR(10)"); + $dbh->do("ALTER TABLE deleteditems CHANGE homebranch homebranch VARCHAR(10)"); + $dbh->do("ALTER TABLE statistics CHANGE branch branch VARCHAR(10)"); + $dbh->do("ALTER TABLE subscription CHANGE lastbranch lastbranch VARCHAR(10)"); + print "Upgrade to $DBversion done (extended missed branchcode columns to 10 chars)\n"; + SetVersion ($DBversion); +} + + + + + + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table -- 2.39.2