@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 2 +- installer/data/mysql/updatedatabase.pl | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -244,7 +244,7 @@ CREATE TABLE `borrowers` ( `sex` varchar(1) default NULL, `password` varchar(30) default NULL, `flags` int(11) default NULL, - `userid` varchar(30) default NULL, + `userid` varchar(75) default NULL, `opacnote` mediumtext, `contactnote` varchar(255) default NULL, `sort1` varchar(80) default NULL, --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -4439,6 +4439,14 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { SetVersion($DBversion); } +$DBversion = "3.05.00.XXX"; +if (C4::Context->preference("Version") < TransformToNum($DBversion)) { + $dbh->do("ALTER TABLE `borrowers` MODIFY `userid` VARCHAR(75)"); + print "Modified userid column length into 75 in borrowers\n"; + SetVersion($DBversion); +} + + =head1 FUNCTIONS --