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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 245-251 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
245
  `ethnicity` varchar(50) default NULL, -- unused in Koha
245
  `ethnicity` varchar(50) default NULL, -- unused in Koha
246
  `ethnotes` varchar(255) default NULL, -- unused in Koha
246
  `ethnotes` varchar(255) default NULL, -- unused in Koha
247
  `sex` varchar(1) default NULL, -- patron/borrower's gender
247
  `sex` varchar(1) default NULL, -- patron/borrower's gender
248
  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
248
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
249
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
249
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
250
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
250
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
251
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
251
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +6 lines)
Lines 6399-6404 if ( CheckVersion($DBversion) ) { Link Here
6399
    SetVersion($DBversion);
6399
    SetVersion($DBversion);
6400
}
6400
}
6401
6401
6402
$DBversion = "XXX";
6403
if ( CheckVersion($DBversion) ) {
6404
    $dbh->do("ALTER TABLE borrowers CHANGE password password VARCHAR(60);");
6405
    print "Upgrade to $DBversion done (Bug 9611 upgrading password storage system)\n";
6406
    SetVersion($DBversion);
6407
}
6402
6408
6403
=head1 FUNCTIONS
6409
=head1 FUNCTIONS
6404
6410
6405
- 

Return to bug 9611