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