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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 269-275 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
269
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
269
  PRIMARY KEY `borrowernumber` (`borrowernumber`),
270
  KEY `categorycode` (`categorycode`),
270
  KEY `categorycode` (`categorycode`),
271
  KEY `branchcode` (`branchcode`),
271
  KEY `branchcode` (`branchcode`),
272
  KEY `userid` (`userid`),
272
  UNIQUE KEY `userid` (`userid`),
273
  KEY `guarantorid` (`guarantorid`),
273
  KEY `guarantorid` (`guarantorid`),
274
  KEY `surname_idx` (`surname`(255)),
274
  KEY `surname_idx` (`surname`(255)),
275
  KEY `firstname_idx` (`firstname`(255)),
275
  KEY `firstname_idx` (`firstname`(255)),
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +18 lines)
Lines 8600-8605 $DBversion = "3.17.00.013"; Link Here
8600
if ( CheckVersion($DBversion) ) {
8600
if ( CheckVersion($DBversion) ) {
8601
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('maxreserves',50,'System-wide maximum number of holds a patron can place','','Integer')");
8601
    $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('maxreserves',50,'System-wide maximum number of holds a patron can place','','Integer')");
8602
    print "Upgrade to $DBversion done (Re-add system preference maxreserves)\n";
8602
    print "Upgrade to $DBversion done (Re-add system preference maxreserves)\n";
8603
    SetVersion ($DBversion);
8604
}
8605
8606
8607
8608
$DBversion = "3.17.00.XXX";
8609
if ( CheckVersion($DBversion) ) {
8610
    $dbh->do(q{
8611
        UPDATE borrowers SET userid = NULL where userid = ""
8612
    });
8613
8614
    $dbh->do(q{
8615
        ALTER TABLE borrowers
8616
            DROP INDEX userid ,
8617
            ADD UNIQUE userid (userid)
8618
    });
8619
8620
    print "Upgrade to $DBversion done (Bug 1861 - Unique patrons logins not (totally) enforced)\n";
8603
    SetVersion($DBversion);
8621
    SetVersion($DBversion);
8604
}
8622
}
8605
8623
8606
- 

Return to bug 1861