@@ -, +, @@ 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 --- a/installer/data/mysql/atomicupdate/bug_21753.perl +++ a/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"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -872,7 +872,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 --