@@ -, +, @@ 'overduerules_transport_types' --- ...ck_into_table_overduerules_transport_types.perl | 23 ++++++++++++++++++++++ installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 24 insertions(+) create mode 100755 installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl --- a/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl +++ a/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl @@ -0,0 +1,23 @@ +#!/usr/bin/perl + +use strict; +use warnings; + +use C4::Context; + +my $dbh = C4::Context->dbh; +my $db_name = $dbh->selectrow_array("SELECT DATABASE()"); + +my $sth = $dbh->prepare("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$db_name' AND TABLE_NAME = 'overduerules_transport_types'"); +$sth->execute(); +my $hash = $sth->fetchall_hashref('COLUMN_NAME'); + +if ( ! exists $hash->{'letternumber'} ) +{ + $dbh->do("ALTER TABLE overduerules_transport_types ADD COLUMN letternumber INT(1) NOT NULL DEFAULT 1 AFTER id"); + print "Bug 16007: adding column 'letternumber' back into table 'overduerules_transport_types'\n"; +} +else +{ + print "Bug 16007: your table 'overduerules_transport_types' already has a column 'letternumber'; nothing to do\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2625,6 +2625,7 @@ CREATE TABLE `message_transport_types` ( DROP TABLE IF EXISTS `overduerules_transport_types`; CREATE TABLE overduerules_transport_types( `id` INT(11) NOT NULL AUTO_INCREMENT, + `letternumber` INT(1) NOT NULL DEFAULT 1, `message_transport_type` VARCHAR(20) NOT NULL DEFAULT 'email', `overduerules_id` INT(11) NOT NULL, PRIMARY KEY (id), --