From cd16f12a473537c2c105eb074aa8335fcdf9b4bc Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Thu, 29 Jan 2009 05:07:09 -0500 Subject: [PATCH] kohabug 2934 - Wrong datatype causes artificial limit to label batch id's labels.batch_id should be int as the value is always an integer. This corrects the problem. [RM note: ported patch to HEAD. DB rev 024] Signed-off-by: Galen Charlton --- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 7 +++++++ kohaversion.pl | 2 +- 3 files changed, 9 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index a75cb090f3..26a40b6b12 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1222,7 +1222,7 @@ CREATE TABLE `itemtypes` ( DROP TABLE IF EXISTS `labels`; CREATE TABLE `labels` ( `labelid` int(11) NOT NULL auto_increment, - `batch_id` varchar(10) NOT NULL default 1, + `batch_id` int(10) NOT NULL default 1, `itemnumber` varchar(100) NOT NULL default '', `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`labelid`) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 4bd0075a8f..afe123df73 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2342,6 +2342,13 @@ if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { SetVersion ($DBversion); } +$DBversion = "3.01.00.024"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE labels MODIFY COLUMN batch_id int(10) NOT NULL default 1;"); + print "Upgrade to $DBversion done (change labels.batch_id from varchar to int)\n"; + SetVersion ($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index e58916c5c6..ac351ad065 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.023'; + our $VERSION = '3.01.00.024'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.2