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

(-)a/installer/data/mysql/kohastructure.sql (+3 lines)
Lines 271-276 CREATE TABLE `borrowers` ( -- this table includes information about your patrons Link Here
271
  KEY `branchcode` (`branchcode`),
271
  KEY `branchcode` (`branchcode`),
272
  KEY `userid` (`userid`),
272
  KEY `userid` (`userid`),
273
  KEY `guarantorid` (`guarantorid`),
273
  KEY `guarantorid` (`guarantorid`),
274
  KEY `surname_idx` (`surname`(255)),
275
  KEY `firstname_idx` (`firstname`(255)),
276
  KEY `othernames_idx` (`othernames`(255)),
274
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
277
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
275
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
278
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)
276
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
279
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +12 lines)
Lines 7778-7783 if(CheckVersion($DBversion)) { Link Here
7778
    SetVersion($DBversion);
7778
    SetVersion($DBversion);
7779
}
7779
}
7780
7780
7781
$DBversion = "3.15.00.XXX";
7782
if(CheckVersion($DBversion)) {
7783
    $dbh->do(q{
7784
        ALTER TABLE `borrowers`
7785
        ADD KEY `surname_idx` (`surname`(255)),
7786
        ADD KEY `firstname_idx` (`firstname`(255)),
7787
        ADD KEY `othernames_idx` (`othernames`(255))
7788
    });
7789
    print "Upgrade to $DBversion done (Bug 11249 - Add db indexes on borrowers names)\n";
7790
    SetVersion($DBversion);
7791
}
7792
7781
=head1 FUNCTIONS
7793
=head1 FUNCTIONS
7782
7794
7783
=head2 TableExists($table)
7795
=head2 TableExists($table)
7784
- 

Return to bug 11249