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

(-)a/installer/data/mysql/atomicupdate/rotatingCollections.perl (+7 lines)
Line 0 Link Here
1 
$DBversion = 'XXX';  # will be replaced by RM
2 
if( CheckVersion( $DBversion ) ) {
3 
    $dbh->do( "ALTER TABLE collections_tracking ADD CONSTRAINT collections_tracking_ibfk_1 FOREIGN KEY (colId) REFERENCES collections (colId) ON DELETE CASCADE ON UPDATE CASCADE" );    $dbh->do( "ALTER TABLE collections_tracking ADD CONSTRAINT collections_tracking_ibfk_2 FOREIGN KEY (itemnumber) REFERENCES items (itemnumber) ON DELETE CASCADE ON UPDATE CASCADE" );
4 

            

            

              5
              
    SetVersion( $DBversion );

            

            

              6
              
    print "Upgrade to $DBversion done (Bug XXXXX - Rotating collections objects)\n";

            

            

              7
              
}

            



(-)a/installer/data/mysql/kohastructure.sql
      (-1 / +6 lines)




  

    
      
            Lines 367-372
          CREATE TABLE collections_tracking (
      
      
        Link Here
      
    
  

        

          367
          
  PRIMARY KEY (collections_tracking_id)

          367
          
  PRIMARY KEY (collections_tracking_id)

        

        

          368
          
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

          368
          
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

        

        

          369
          

          369
          

        

            

              
              
              370
              
ALTER TABLE `collections_tracking`

            

            

              371
              
    ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;

            

            

              372
              

            

            

              373
              
ALTER TABLE `collections_tracking`

            

            

              374
              
    ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;

            

            

              375
              

            

        

          370
          
--

          376
          
--

        

        

          371
          
-- Table structure for table `branch_borrower_circ_rules`

          377
          
-- Table structure for table `branch_borrower_circ_rules`

        

        

          372
          
--

          378
          
--

        

            

              373
              
- 

              
              
            






  

  Return to bug 18606