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

(-)a/installer/data/mysql/de-DE/mandatory/message_transport_types.sql (-1 lines)
Lines 4-8 values Link Here
4
('email'),
4
('email'),
5
('print'),
5
('print'),
6
('sms'),
6
('sms'),
7
('feed'),
8
('phone');
7
('phone');
(-)a/installer/data/mysql/en/mandatory/message_transport_types.sql (-1 lines)
Lines 4-8 values Link Here
4
('email'),
4
('email'),
5
('print'),
5
('print'),
6
('sms'),
6
('sms'),
7
('feed'),
8
('phone');
7
('phone');
(-)a/installer/data/mysql/es-ES/mandatory/message_transport_types.sql (-1 lines)
Lines 4-8 values Link Here
4
('email'),
4
('email'),
5
('print'),
5
('print'),
6
('sms'),
6
('sms'),
7
('feed'),
8
('phone');
7
('phone');
(-)a/installer/data/mysql/fr-FR/1-Obligatoire/message_transport_types.sql (-1 lines)
Lines 4-8 values Link Here
4
('print'),
4
('print'),
5
('email'),
5
('email'),
6
('sms'),
6
('sms'),
7
('feed'),
8
('phone');
7
('phone');
(-)a/installer/data/mysql/it-IT/necessari/message_transport_types.sql (-1 lines)
Lines 6-12 values Link Here
6
('email'),
6
('email'),
7
('print'),
7
('print'),
8
('sms'),
8
('sms'),
9
('feed'),
10
('phone');
9
('phone');
11
10
12
SET FOREIGN_KEY_CHECKS=1;
11
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/nb-NO/1-Obligatorisk/message_transport_types.sql (-1 lines)
Lines 25-29 values Link Here
25
('email'),
25
('email'),
26
('print'),
26
('print'),
27
('sms'),
27
('sms'),
28
('feed'),
29
('phone');
28
('phone');
(-)a/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql (-1 lines)
Lines 6-10 values Link Here
6
('email'),
6
('email'),
7
('print'),
7
('print'),
8
('sms'),
8
('sms'),
9
('feed'),
10
('phone');
9
('phone');
(-)a/installer/data/mysql/uk-UA/mandatory/message_transport_types.sql (-1 lines)
Lines 6-10 values Link Here
6
('email'),
6
('email'),
7
('print'),
7
('print'),
8
('sms'),
8
('sms'),
9
('feed'),
10
('phone');
9
('phone');
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +30 lines)
Lines 8603-8608 if ( CheckVersion($DBversion) ) { Link Here
8603
    SetVersion($DBversion);
8603
    SetVersion($DBversion);
8604
}
8604
}
8605
8605
8606
$DBversion = "3.15.00.XXX";
8607
if ( CheckVersion($DBversion) ) {
8608
    my $count_l = $dbh->selectcol_arrayref(q|
8609
        SELECT COUNT(*) FROM letter WHERE message_transport_type='feed'
8610
    |);
8611
    my $count_mq = $dbh->selectcol_arrayref(q|
8612
        SELECT COUNT(*) FROM message_queue WHERE message_transport_type='feed'
8613
    |);
8614
    my $count_ott = $dbh->selectcol_arrayref(q|
8615
        SELECT COUNT(*) FROM overduerules_transport_types WHERE message_transport_type='feed'
8616
    |);
8617
    my $count_mt = $dbh->selectcol_arrayref(q|
8618
        SELECT COUNT(*) FROM message_transports WHERE message_transport_type='feed'
8619
    |);
8620
    my $count_bmtp = $dbh->selectcol_arrayref(q|
8621
        SELECT COUNT(*) FROM borrower_message_transport_preferences WHERE message_transport_type='feed'
8622
    |);
8623
8624
    my $deleted = 0;
8625
    if ( $count_l->[0] == 0 and $count_mq->[0] == 0 and $count_ott->[0] == 0 and $count_mt->[0] == 0 and $count_bmtp->[0] == 0 ) {
8626
        $deleted = $dbh->do(q|
8627
            DELETE FROM message_transport_types where message_transport_type='feed'
8628
        |);
8629
        $deleted = $deleted ne '0E0' ? 1 : 0;
8630
    }
8631
8632
    print "Upgrade to $DBversion done (Bug 12298: Delete the 'feed' message transport type " . ($deleted ? '(deleted!)' : '(not deleted)') . ")\n";
8633
    SetVersion($DBversion);
8634
}
8635
8606
=head1 FUNCTIONS
8636
=head1 FUNCTIONS
8607
8637
8608
=head2 TableExists($table)
8638
=head2 TableExists($table)
8609
- 

Return to bug 12298