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

(-)a/installer/data/mysql/atomicupdate/bug_21288.perl (+9 lines)
Line 0 Link Here
1
$DBversion = 'XXX';  # will be replaced by the RM
2
if( CheckVersion( $DBversion ) ) {
3
    $dbh->do(q{
4
        CREATE INDEX `by_biblionumber` ON `subscription` (`biblionumber`)
5
    });
6
7
    SetVersion( $DBversion );
8
    print "Upgrade to $DBversion done (Bug 21288: Slowness in acquisition caused by GetInvoices\n";
9
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2115-2120 CREATE TABLE `subscription` ( -- information related to the subscription Link Here
2115
  `itemtype` VARCHAR( 10 ) NULL,
2115
  `itemtype` VARCHAR( 10 ) NULL,
2116
  `previousitemtype` VARCHAR( 10 ) NULL,
2116
  `previousitemtype` VARCHAR( 10 ) NULL,
2117
  PRIMARY KEY  (`subscriptionid`),
2117
  PRIMARY KEY  (`subscriptionid`),
2118
  KEY `by_biblionumber` (`biblionumber`),
2118
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2119
  CONSTRAINT subscription_ibfk_1 FOREIGN KEY (periodicity) REFERENCES subscription_frequencies (id) ON DELETE SET NULL ON UPDATE CASCADE,
2119
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2120
  CONSTRAINT subscription_ibfk_2 FOREIGN KEY (numberpattern) REFERENCES subscription_numberpatterns (id) ON DELETE SET NULL ON UPDATE CASCADE
2120
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2121
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2121
- 

Return to bug 21288