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

(-)a/installer/data/mysql/atomicupdate/bug_28854.pl (+7 lines)
Lines 44-48 return { Link Here
44 
              ( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free')
 44 
              ( 'BundleNotLoanValue', $nfl_val, '', 'Sets the NOT_LOAN AV value that represents "Added to bundle" as a not for loan value', 'Free')
45 
        });
 45 
        });
46 
        say $out "System preferences added and set";
 46 
        say $out "System preferences added and set";
47 

            

            

              48
              
        if( index_exists( 'return_claims', 'issue_id' ) ) {

            

            

              49
              
            $dbh->do(q{

            

            

              50
              
                ALTER TABLE return_claims DROP INDEX issue_id

            

            

              51
              
            });

            

            

              52
              
            say $out "Dropped unique constraint on issue_id in return_claims";

            

            

              53
              
        }

            

        

          47
          
    }

          54
          
    }

        

        

          48
          
}

          55
          
}

        



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




  

    
      
            Lines 4462-4468
          CREATE TABLE `return_claims` (
      
      
        Link Here
      
    
  

        

          4462
          
  `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved',

          4462
          
  `resolved_on` timestamp NULL DEFAULT NULL COMMENT 'Time and date the claim was resolved',

        

        

          4463
          
  `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim',

          4463
          
  `resolved_by` int(11) DEFAULT NULL COMMENT 'ID of the staff member that resolved the claim',

        

        

          4464
          
  PRIMARY KEY (`id`),

          4464
          
  PRIMARY KEY (`id`),

        

            

              4465
              
  UNIQUE KEY `issue_id` (`issue_id`),

              
              
            

        

          4466
          
  KEY `itemnumber` (`itemnumber`),

          4465
          
  KEY `itemnumber` (`itemnumber`),

        

        

          4467
          
  KEY `rc_borrowers_ibfk` (`borrowernumber`),

          4466
          
  KEY `rc_borrowers_ibfk` (`borrowernumber`),

        

        

          4468
          
  KEY `rc_created_by_ibfk` (`created_by`),

          4467
          
  KEY `rc_created_by_ibfk` (`created_by`),

        

            

              4469
              
- 

              
              
            






  

  Return to bug 28854