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

(-)a/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl (+45 lines)
Line 0 Link Here
1
#!/usr/bin/perl
2
3
use strict;
4
use warnings;
5
6
use C4::Context;
7
use C4::Members;
8
9
my $dbh = C4::Context->dbh;
10
my $sth = $dbh->prepare("SELECT * FROM overduerules_transport_types WHERE 0 = 1");
11
my $urv = $sth->execute();
12
13
my @data;
14
15
if ( $sth->{NUM_OF_FIELDS} > 0 )
16
{
17
    @data = @{$sth->{NAME}};
18
    my $letternumberExists = 0;
19
20
    for ( @data )
21
    {
22
        if ( $_ eq 'letternumber' )
23
        {
24
            $letternumberExists = 1;
25
            last;
26
        }
27
    }
28
29
    if ( ! $letternumberExists )
30
    {
31
        my $urv = $dbh->do("ALTER TABLE overduerules_transport_types ADD COLUMN letternumber INT(1) NOT NULL DEFAULT 1 AFTER id");
32
        print "Bug 16007: adding column 'letternumber' back into table 'overduerules_transport_types'\n";
33
    }
34
    else
35
    {
36
        print "Bug 16007: your table 'overduerules_transport_types' already has a column 'letternumber'; nothing to do\n";
37
    }
38
}
39
else
40
{
41
    # uselessly defensive programming ?
42
    # table overduerules_transport_types should exist by now, but let's
43
    # warn the user here just in case
44
    print "Bug 16007: [ERROR] your table 'overduerules_transport_types' does not exists ?!\n";
45
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 2625-2630 CREATE TABLE `message_transport_types` ( Link Here
2625
DROP TABLE IF EXISTS `overduerules_transport_types`;
2625
DROP TABLE IF EXISTS `overduerules_transport_types`;
2626
CREATE TABLE overduerules_transport_types(
2626
CREATE TABLE overduerules_transport_types(
2627
    `id` INT(11) NOT NULL AUTO_INCREMENT,
2627
    `id` INT(11) NOT NULL AUTO_INCREMENT,
2628
    `letternumber` INT(1) NOT NULL DEFAULT 1,
2628
    `message_transport_type` VARCHAR(20) NOT NULL DEFAULT 'email',
2629
    `message_transport_type` VARCHAR(20) NOT NULL DEFAULT 'email',
2629
    `overduerules_id` INT(11) NOT NULL,
2630
    `overduerules_id` INT(11) NOT NULL,
2630
    PRIMARY KEY (id),
2631
    PRIMARY KEY (id),
2631
- 

Return to bug 16007