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 (-13 / +18 lines)
Lines 329-346 ALTER TABLE `collections` Link Here
329
  ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
329
  ADD CONSTRAINT `collections_ibfk_1` FOREIGN KEY (`colBranchcode`) REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;
330
330
331
--
331
--
332
-- Table: collections_tracking
333
--
334
335
DROP TABLE IF EXISTS collections_tracking;
336
CREATE TABLE collections_tracking (
337
  collections_tracking_id integer(11) NOT NULL auto_increment,
338
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
339
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
340
  PRIMARY KEY (collections_tracking_id)
341
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
342
343
--
344
-- Table structure for table `branch_borrower_circ_rules`
332
-- Table structure for table `branch_borrower_circ_rules`
345
--
333
--
346
334
Lines 975-980 CREATE TABLE `itemtypes` ( -- defines the item types Link Here
975
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
963
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
976
964
977
--
965
--
966
-- Table: collections_tracking
967
--
968
969
DROP TABLE IF EXISTS collections_tracking;
970
CREATE TABLE collections_tracking (
971
  collections_tracking_id integer(11) NOT NULL auto_increment,
972
  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',
973
  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',
974
  PRIMARY KEY (collections_tracking_id)
975
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
976
977
ALTER TABLE `collections_tracking`
978
  ADD CONSTRAINT `collections_tracking_ibfk_1` FOREIGN KEY (`colId`) REFERENCES `collections` (`colId`) ON DELETE CASCADE ON UPDATE CASCADE;
979
980
ALTER TABLE `collections_tracking`
981
  ADD CONSTRAINT `collections_tracking_ibfk_2` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE;
982
983
--
978
-- Table structure for table `default_branch_item_rules`
984
-- Table structure for table `default_branch_item_rules`
979
--
985
--
980
986
981
- 

Return to bug 18606