View | Details | Raw Unified | Return to bug 6761
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 244-250 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
244
  `sex` varchar(1) default NULL, -- patron/borrower's gender
244
  `sex` varchar(1) default NULL, -- patron/borrower's gender
245
  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
245
  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
246
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
246
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
247
  `userid` varchar(30) default NULL, -- patron/borrower's opac and/or staff client log in
247
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
248
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
248
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
249
  `contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address
249
  `contactnote` varchar(255) default NULL, -- a note related to the patron/borrower's alternate address
250
  `sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library
250
  `sort1` varchar(80) default NULL, -- a field that can be used for any information unique to the library
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +6 lines)
Lines 4446-4451 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4446
    SetVersion($DBversion);
4446
    SetVersion($DBversion);
4447
}
4447
}
4448
4448
4449
$DBversion = "3.05.00.XXX";
4450
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4451
    $dbh->do("ALTER TABLE `borrowers` MODIFY `userid` VARCHAR(75)");
4452
    print "Modified userid column length into 75 in borrowers\n";
4453
    SetVersion($DBversion);
4454
}
4449
4455
4450
=head1 FUNCTIONS
4456
=head1 FUNCTIONS
4451
4457
4452
- 

Return to bug 6761