From 5c6d9633b787dd5bf73dfb770371ae310c6fb2ff Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Fri, 24 Apr 2009 08:41:24 -0500 Subject: [PATCH] bug 2765: updatedatabase to increase width of ISBN columns Signed-off-by: Galen Charlton --- 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 e3a5606b6e..4bd0075a8f 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2332,6 +2332,16 @@ if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { SetVersion ($DBversion); } +$DBversion = '3.01.00.023'; +if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { + $dbh->do("ALTER TABLE biblioitems MODIFY COLUMN isbn VARCHAR(30) DEFAULT NULL"); + $dbh->do("ALTER TABLE deletedbiblioitems MODIFY COLUMN isbn VARCHAR(30) DEFAULT NULL"); + $dbh->do("ALTER TABLE import_biblios MODIFY COLUMN isbn VARCHAR(30) DEFAULT NULL"); + $dbh->do("ALTER TABLE suggestions MODIFY COLUMN isbn VARCHAR(30) DEFAULT NULL"); + print "Upgrade to $DBversion done (bug 2765: increase width of isbn column in several tables)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index 11e5c42a75..e58916c5c6 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.022'; + our $VERSION = '3.01.00.023'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.2