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 369-374 CREATE TABLE collections_tracking ( Link Here
369
  PRIMARY KEY (collections_tracking_id)
369
  PRIMARY KEY (collections_tracking_id)
370
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
370
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
371
371
372
ALTER TABLE `collections_tracking`
373
    ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;
374
375
ALTER TABLE `collections_tracking`
376
    ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
377
372
--
378
--
373
-- Table structure for table `branch_borrower_circ_rules`
379
-- Table structure for table `branch_borrower_circ_rules`
374
--
380
--
375
- 

Return to bug 18606