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 |
} |