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 6758-6763 if ( CheckVersion($DBversion) ) { Link Here
6758
    SetVersion($DBversion);
6758
    SetVersion($DBversion);
6759
}
6759
}
6760
6760
6761
$DBversion = "3.11.00.XXX";
6762
if ( CheckVersion($DBversion) ) {
6763
    $dbh->do("ALTER TABLE borrowers CHANGE password password VARCHAR(60);");
6764
    print "Upgrade to $DBversion done (Bug 9611 upgrading password storage system)\n";
6765
    SetVersion($DBversion);
6766
}
6767
6761
=head1 FUNCTIONS
6768
=head1 FUNCTIONS
6762
6769
6763
=head2 TableExists($table)
6770
=head2 TableExists($table)
6764
- 

Return to bug 9611