From 43abf7d3750f97f33615a7570073fc6cbf966b4c Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Fri, 2 Nov 2018 10:04:46 +0000 Subject: [PATCH] Bug 21753: DBRev to remove the field from the database --- installer/data/mysql/atomicupdate/bug_21753.perl | 10 ++++++++++ installer/data/mysql/kohastructure.sql | 1 - 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_21753.perl diff --git a/installer/data/mysql/atomicupdate/bug_21753.perl b/installer/data/mysql/atomicupdate/bug_21753.perl new file mode 100644 index 0000000000..f5e5d442f1 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_21753.perl @@ -0,0 +1,10 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + if( column_exists( 'issuingrules', 'chargename' ) ) { + $dbh->do( "ALTER TABLE issuingrules DROP chargename" ); + } + + # Always end with this (adjust the bug info) + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 21753: Drop chargename from issuingrules )\n"; +} diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 629bc93569..09cfb9050d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -855,7 +855,6 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `chargeperiod` int(11) default NULL, -- how often the fine amount is charged `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period `accountsent` int(11) default NULL, -- not used? always NULL - `chargename` varchar(100) default NULL, -- not used? always NULL `maxissueqty` int(4) default NULL, -- total number of checkouts allowed `maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit -- 2.19.1