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` (`surname`(255)),
275
  KEY `firstname` (`firstname`(255)),
276
  KEY `othernames` (`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 7743-7748 if(CheckVersion($DBversion)) { Link Here
7743
    SetVersion($DBversion);
7743
    SetVersion($DBversion);
7744
}
7744
}
7745
7745
7746
$DBversion = "3.13.00.XXX";
7747
if(CheckVersion($DBversion)) {
7748
    $dbh->do(q{
7749
        ALTER TABLE `borrowers`
7750
        ADD KEY `surname` (`surname`(255)),
7751
        ADD KEY `firstname` (`firstname`(255)),
7752
        ADD KEY `othernames` (`othernames`(255))
7753
    });
7754
    print "Upgrade to $DBversion done (Koha 3.14 beta)\n";
7755
    SetVersion($DBversion);
7756
}
7757
7746
=head1 FUNCTIONS
7758
=head1 FUNCTIONS
7747
7759
7748
=head2 TableExists($table)
7760
=head2 TableExists($table)
7749
- 

Return to bug 11249