View | Details | Raw Unified | Return to bug 21753
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_21753.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    if( column_exists( 'issuingrules', 'chargename' ) ) {
4 
        $dbh->do( "ALTER TABLE issuingrules DROP chargename" );
5 
    }
6 

            

            

              7
              
    # Always end with this (adjust the bug info)

            

            

              8
              
    SetVersion( $DBversion );

            

            

              9
              
    print "Upgrade to $DBversion done (Bug 21753: Drop chargename from issuingrules )\n";

            

            

              10
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-2 lines)




  

    
      
            Lines 872-878
          CREATE TABLE `issuingrules` ( -- circulation and fine rules
      
      
        Link Here
      
    
  

        

          872
          
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged

          872
          
  `chargeperiod` int(11) default NULL, -- how often the fine amount is charged

        

        

          873
          
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period

          873
          
  `chargeperiod_charge_at` tinyint(1) NOT NULL DEFAULT '0', -- Should fine be given at the start ( 1 ) or the end ( 0 ) of the period

        

        

          874
          
  `accountsent` int(11) default NULL, -- not used? always NULL

          874
          
  `accountsent` int(11) default NULL, -- not used? always NULL

        

            

              875
              
  `chargename` varchar(100) default NULL, -- not used? always NULL

              
              
            

        

          876
          
  `maxissueqty` int(4) default NULL, -- total number of checkouts allowed

          875
          
  `maxissueqty` int(4) default NULL, -- total number of checkouts allowed

        

        

          877
          
  `maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed

          876
          
  `maxonsiteissueqty` int(4) default NULL, -- total number of on-site checkouts allowed

        

        

          878
          
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit

          877
          
  `issuelength` int(4) default NULL, -- length of checkout in the unit set in issuingrules.lengthunit

        

            

              879
              
- 

              
              
            






  

  Return to bug 21753