Bugzilla – Attachment 49401 Details for
Bug 16007
Correction of 'Remove columns branchcode, categorytype from table overduerules_transport_types'
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16007: Adding back column 'letternumber' to table 'overduerules_transport_types'
Bug-16007-Adding-back-column-letternumber-to-table.patch (text/plain), 3.00 KB, created by
Charles Farmer
on 2016-03-21 18:18:32 UTC
(
hide
)
Description:
Bug 16007: Adding back column 'letternumber' to table 'overduerules_transport_types'
Filename:
MIME Type:
Creator:
Charles Farmer
Created:
2016-03-21 18:18:32 UTC
Size:
3.00 KB
patch
obsolete
>From 18c66c8afc46e06600eb5752aff7926d8a80341b Mon Sep 17 00:00:00 2001 >From: charles <charles.farmer@inlibro.com> >Date: Mon, 21 Mar 2016 14:17:17 -0400 >Subject: [PATCH] Bug 16007: Adding back column 'letternumber' to table > 'overduerules_transport_types' > >Bug 13624 definitely broke the master by removing the column `overduerules_transport_type`.`letternumber` from kohastructure.sql. >This patch aims to fix the problem by adding the column back on systems which had their 'letternumber' removed. >--- > ...ck_into_table_overduerules_transport_types.perl | 45 ++++++++++++++++++++++ > installer/data/mysql/kohastructure.sql | 1 + > 2 files changed, 46 insertions(+) > create mode 100755 installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl > >diff --git a/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl b/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl >new file mode 100755 >index 0000000..924c7cb >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/Bug_16007_adding_column_letternumber_back_into_table_overduerules_transport_types.perl >@@ -0,0 +1,45 @@ >+#!/usr/bin/perl >+ >+use strict; >+use warnings; >+ >+use C4::Context; >+use C4::Members; >+ >+my $dbh = C4::Context->dbh; >+my $sth = $dbh->prepare("SELECT * FROM overduerules_transport_types WHERE 0 = 1"); >+my $urv = $sth->execute(); >+ >+my @data; >+ >+if ( $sth->{NUM_OF_FIELDS} > 0 ) >+{ >+ @data = @{$sth->{NAME}}; >+ my $letternumberExists = 0; >+ >+ for ( @data ) >+ { >+ if ( $_ eq 'letternumber' ) >+ { >+ $letternumberExists = 1; >+ last; >+ } >+ } >+ >+ if ( ! $letternumberExists ) >+ { >+ my $urv = $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"; >+ } >+} >+else >+{ >+ # uselessly defensive programming ? >+ # table overduerules_transport_types should exist by now, but let's >+ # warn the user here just in case >+ print "Bug 16007: [ERROR] your table 'overduerules_transport_types' does not exists ?!\n"; >+} >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 63fefe7..ccc13bd 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/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), >-- >1.9.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16007
:
49398
|
49401
|
49402
|
49403
|
49404
|
49455
|
49514
|
49515