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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 246-252 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
246
  `ethnicity` varchar(50) default NULL, -- unused in Koha
246
  `ethnicity` varchar(50) default NULL, -- unused in Koha
247
  `ethnotes` varchar(255) default NULL, -- unused in Koha
247
  `ethnotes` varchar(255) default NULL, -- unused in Koha
248
  `sex` varchar(1) default NULL, -- patron/borrower's gender
248
  `sex` varchar(1) default NULL, -- patron/borrower's gender
249
  `password` varchar(30) default NULL, -- patron/borrower's encrypted password
249
  `password` varchar(60) default NULL, -- patron/borrower's encrypted password
250
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
250
  `flags` int(11) default NULL, -- will include a number associated with the staff member's permissions
251
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
251
  `userid` varchar(75) default NULL, -- patron/borrower's opac and/or staff client log in
252
  `opacnote` mediumtext, -- a note on the patron/borrower's account that is visible in the OPAC and staff client
252
  `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 7067-7072 if ( CheckVersion($DBversion) ) { Link Here
7067
    SetVersion($DBversion);
7067
    SetVersion($DBversion);
7068
}
7068
}
7069
7069
7070
$DBversion = "3.11.00.XXX";
7071
if ( CheckVersion($DBversion) ) {
7072
    $dbh->do("ALTER TABLE borrowers CHANGE password password VARCHAR(60);");
7073
    print "Upgrade to $DBversion done (Bug 9611 upgrading password storage system)\n";
7074
    SetVersion($DBversion);
7075
}
7076
7070
=head1 FUNCTIONS
7077
=head1 FUNCTIONS
7071
7078
7072
=head2 TableExists($table)
7079
=head2 TableExists($table)
7073
- 

Return to bug 9611