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

(-)a/installer/data/mysql/atomicupdate/bz_33489.pl (+23 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "33489",
5
    description => "Add indices to default patron search fields",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        # Do you stuffs here
10
        unless ( index_exists( 'borrowers', 'cardnumber_idx' ) ) {
11
            $dbh->do(q{CREATE INDEX cardnumber_idx ON borrowers ( cardnumber )});
12
            say $out "Added new index on borrowers.cardnumber";
13
        }
14
        unless ( index_exists( 'borrowers', 'userid_idx' ) ) {
15
            $dbh->do(q{CREATE INDEX userid_idx ON borrowers ( userid )});
16
            say $out "Added new index on borrowers.userid";
17
        }
18
        unless ( index_exists( 'borrowers', 'middle_name_idx' ) ) {
19
            $dbh->do(q{CREATE INDEX middle_name_idx ON borrowers ( middle_name )});
20
            say $out "Added new index on borrowers.midddle_name";
21
        }
22
    },
23
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +3 lines)
Lines 1488-1493 CREATE TABLE `borrowers` ( Link Here
1488
  KEY `firstname_idx` (`firstname`(191)),
1488
  KEY `firstname_idx` (`firstname`(191)),
1489
  KEY `othernames_idx` (`othernames`(191)),
1489
  KEY `othernames_idx` (`othernames`(191)),
1490
  KEY `sms_provider_id` (`sms_provider_id`),
1490
  KEY `sms_provider_id` (`sms_provider_id`),
1491
  KEY `cardnumber_idx` (`cardnumber`),
1492
  KEY `userid_idx` (`userid`),
1493
  KEY `middle_name_idx` (`middle_name`(768)),
1491
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
1494
  CONSTRAINT `borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`),
1492
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1495
  CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
1493
  CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
1496
  CONSTRAINT `borrowers_ibfk_3` FOREIGN KEY (`sms_provider_id`) REFERENCES `sms_providers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
1494
- 

Return to bug 33489