From 37e7d9664e62aafd88791ae1b7ab83b2b60d6c42 Mon Sep 17 00:00:00 2001 From: Henri-Damien LAURENT Date: Tue, 17 Nov 2009 21:41:13 +0100 Subject: [PATCH] BZ2222 : db definition for frameworkcode in auth_subfield_structure incorrect db definition for frameworkcode was only varchar(8) corected to 10 --- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 12 +++++++++++- kohaversion.pl | 2 +- 3 files changed, 13 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index ba85b04275..a1bf59b8a9 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -55,7 +55,7 @@ CREATE TABLE `auth_subfield_structure` ( `hidden` tinyint(3) NOT NULL default 0, `linkid` tinyint(1) NOT NULL default 0, `kohafield` varchar(45) NULL default '', - `frameworkcode` varchar(8) NOT NULL default '', + `frameworkcode` varchar(10) NOT NULL default '', PRIMARY KEY (`authtypecode`,`tagfield`,`tagsubfield`), KEY `tab` (`authtypecode`,`tab`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 08e26276f7..f88fdd708a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -3277,7 +3277,17 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { ALTER TABLE aqbasketgroups ADD billingplace VARCHAR(10) NOT NULL AFTER deliverycomment; }); - print "Upgrade to $DBversion done (isbd updated)\n"; + print "Upgrade to $DBversion done (Adding billingplace to aqbasketgroups)\n"; + SetVersion ($DBversion); +} + +$DBversion = "3.01.00.128"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do(qq{ + ALTER TABLE auth_subfield_structure MODIFY frameworkcode VARCHAR(10) NULL; + }); + + print "Upgrade to $DBversion done (changing frameworkcode length in auth_subfield_structure)\n"; SetVersion ($DBversion); } diff --git a/kohaversion.pl b/kohaversion.pl index de92273ea4..2ef16680a3 100644 --- a/kohaversion.pl +++ b/kohaversion.pl @@ -10,7 +10,7 @@ use strict; sub kohaversion { - our $VERSION = '3.01.00.125'; + our $VERSION = '3.01.00.128'; # version needs to be set this way # so that it can be picked up by Makefile.PL # during install -- 2.39.5