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 (+23 lines)
Line 0 Link Here
1
#!/usr/bin/perl
2
3
use strict;
4
use warnings;
5
6
use C4::Context;
7
8
my $dbh = C4::Context->dbh;
9
my $db_name = $dbh->selectrow_array("SELECT DATABASE()");
10
11
my $sth = $dbh->prepare("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$db_name' AND TABLE_NAME = 'overduerules_transport_types'");
12
$sth->execute();
13
my $hash = $sth->fetchall_hashref('COLUMN_NAME');
14
15
if ( ! exists $hash->{'letternumber'} )
16
{
17
    $dbh->do("ALTER TABLE overduerules_transport_types ADD COLUMN letternumber INT(1) NOT NULL DEFAULT 1 AFTER id");
18
    print "Bug 16007: adding column 'letternumber' back into table 'overduerules_transport_types'\n";
19
}
20
else
21
{
22
    print "Bug 16007: your table 'overduerules_transport_types' already has a column 'letternumber'; nothing to do\n";
23
}
(-)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