From 0e0edd116a8c8af7a31a3e414f62e4c4c866e927 Mon Sep 17 00:00:00 2001 From: Danny Bouman Date: Wed, 19 Nov 2008 15:58:42 -0500 Subject: [PATCH] bug 2687: Increased length of borrower attribute fields Signed-off-by: Galen Charlton Signed-off-by: Henri-Damien LAURENT --- installer/data/mysql/updatedatabase.pl | 10 +++++++++- kohaversion.pl | 2 +- 2 files changed, 10 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 5f61244e00..03b9259618 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -2116,7 +2116,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } -$DBversion = "3.01.00.009"; +$DBversion = "3.00.04.009"; if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE permissions MODIFY `code` varchar(64) DEFAULT NULL"); $dbh->do("ALTER TABLE user_permissions MODIFY `code` varchar(64) DEFAULT NULL"); @@ -2126,6 +2126,14 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion ($DBversion); } +$DBversion = '3.00.04.010'; +if ( C4::Context->preference('Version') < TransformToNum($DBversion) ) { + $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `attribute` VARCHAR(64) DEFAULT NULL"); + $dbh->do("ALTER TABLE `borrower_attributes` MODIFY COLUMN `password` VARCHAR(64) DEFAULT NULL"); + print "Upgrade to $DBversion done (bug 2687: increase length of borrower attribute fields)\n"; + SetVersion($DBversion); +} + =item DropAllForeignKeys($table) Drop all foreign keys of the table $table diff --git a/kohaversion.pl b/kohaversion.pl index 1e3aa318a8..d4ab71c4db 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.00.04.009'; + our $VERSION = '3.00.04.010'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5