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

(-)a/installer/data/mysql/atomicupdate/bug_36178.pl (+17 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number  => "36178",
5
    description => "Add index for status on message queue table",
6
    up          => sub {
7
        my ($args) = @_;
8
        my ( $dbh, $out ) = @$args{qw(dbh out)};
9
10
        unless ( index_exists( 'message_queue', 'language_subtag' ) ) {
11
            $dbh->do(q{
12
                ALTER TABLE message_queue ADD INDEX idx_mq_status (`status`)
13
            });
14
            say $out "Added new index 'idx_mq_status' on table 'message_queue'";
15
        }
16
    },
17
};
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 4647-4652 CREATE TABLE `message_queue` ( Link Here
4647
  KEY `borrowernumber` (`borrowernumber`),
4647
  KEY `borrowernumber` (`borrowernumber`),
4648
  KEY `message_transport_type` (`message_transport_type`),
4648
  KEY `message_transport_type` (`message_transport_type`),
4649
  KEY `letter_fk` (`letter_id`),
4649
  KEY `letter_fk` (`letter_id`),
4650
  INDEX idx_mq_status (`status`),
4650
  CONSTRAINT `letter_fk` FOREIGN KEY (`letter_id`) REFERENCES `letter` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
4651
  CONSTRAINT `letter_fk` FOREIGN KEY (`letter_id`) REFERENCES `letter` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
4651
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4652
  CONSTRAINT `messageq_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
4652
  CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON UPDATE CASCADE
4653
  CONSTRAINT `messageq_ibfk_2` FOREIGN KEY (`message_transport_type`) REFERENCES `message_transport_types` (`message_transport_type`) ON UPDATE CASCADE
4653
- 

Return to bug 36178