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 7155-7160 if ( CheckVersion($DBversion) ) { Link Here
7155
    SetVersion($DBversion);
7155
    SetVersion($DBversion);
7156
}
7156
}
7157
7157
7158
$DBversion = "3.13.00.XXX";
7159
if ( CheckVersion($DBversion) ) {
7160
    $dbh->do("ALTER TABLE borrowers CHANGE password password VARCHAR(60);");
7161
    print "Upgrade to $DBversion done (Bug 9611 upgrading password storage system)\n";
7162
    SetVersion($DBversion);
7163
}
7164
7158
=head1 FUNCTIONS
7165
=head1 FUNCTIONS
7159
7166
7160
=head2 TableExists($table)
7167
=head2 TableExists($table)
7161
- 

Return to bug 9611