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 / +7 lines)
Lines 6407-6412 if ( CheckVersion($DBversion) ) { Link Here
6407
   SetVersion ($DBversion);
6407
   SetVersion ($DBversion);
6408
}
6408
}
6409
6409
6410
$DBversion = "3.11.00.XXX";
6411
if ( CheckVersion($DBversion) ) {
6412
    $dbh->do("ALTER TABLE borrowers CHANGE password password VARCHAR(60);");
6413
    print "Upgrade to $DBversion done (Bug 9611 upgrading password storage system)\n";
6414
    SetVersion($DBversion);
6415
}
6416
6410
=head1 FUNCTIONS
6417
=head1 FUNCTIONS
6411
6418
6412
=head2 TableExists($table)
6419
=head2 TableExists($table)
6413
- 

Return to bug 9611