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

(-)a/installer/data/mysql/atomicupdate/bug_29495.perl (+10 lines)
Line 0 Link Here
1 
$DBversion = 'XXX'; # will be replaced by the RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    if ( foreign_key_exists( 'return_claims', 'issue_id' ) ) {
4 
        $dbh->do(q{
5 
            ALTER TABLE return_claims DROP FOREIGN KEY issue_id
6 
        });
7 
    }
8 

            

            

              9
              
    NewVersion( $DBversion, 29495, "Issue link is lost in return claims when using 'MarkLostItemsAsReturned'");

            

            

              10
              
}

            



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




  

    
      
            Lines 4364-4370
          CREATE TABLE `return_claims` (
      
      
        Link Here
      
    
  

        

          4364
          
  KEY `rc_created_by_ibfk` (`created_by`),

          4364
          
  KEY `rc_created_by_ibfk` (`created_by`),

        

        

          4365
          
  KEY `rc_updated_by_ibfk` (`updated_by`),

          4365
          
  KEY `rc_updated_by_ibfk` (`updated_by`),

        

        

          4366
          
  KEY `rc_resolved_by_ibfk` (`resolved_by`),

          4366
          
  KEY `rc_resolved_by_ibfk` (`resolved_by`),

        

            

              4367
              
  CONSTRAINT `issue_id` FOREIGN KEY (`issue_id`) REFERENCES `issues` (`issue_id`) ON DELETE SET NULL ON UPDATE CASCADE,

              
              
            

        

          4368
          
  CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,

          4367
          
  CONSTRAINT `rc_borrowers_ibfk` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,

        

        

          4369
          
  CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,

          4368
          
  CONSTRAINT `rc_created_by_ibfk` FOREIGN KEY (`created_by`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,

        

        

          4370
          
  CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,

          4369
          
  CONSTRAINT `rc_items_ibfk` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE,

        

            

              4371
              
- 

              
              
            






  

  Return to bug 29495