installer/data/mysql/atomicupdate/bug_18930.perl

   1 $DBversion = 'XXX';  # will be replaced by the RM
   2 if( CheckVersion( $DBversion ) ) {
   3
   4     if ( TableExists('refund_lost_item_fee_rules') ) {
   5         if ( column_exists( 'refund_lost_item_fee_rules', 'refund' ) ) {
   6             $dbh->do("
   7                 INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value )
   8                 SELECT NULL, IF(branchcode='*', NULL, branchcode), NULL, 'refund', refund
   9                 FROM refund_lost_item_fee_rules
  10             ");
  11             $dbh->do("DROP TABLE refund_lost_item_fee_rules");
  12         }
  13     }
  14
  15     SetVersion( $DBversion );
  16     print "Upgrade to $DBversion done (Bug 18930 - Move lost item refund rules to circulation_rules table)\n";
  17 }