$DBversion = 'XXX';  # will be replaced by RM

if( CheckVersion( $DBversion ) ) {

    $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" );

    SetVersion( $DBversion );

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

}

-- Table: collections_tracking

--

DROP TABLE IF EXISTS collections_tracking;

CREATE TABLE collections_tracking (

  collections_tracking_id integer(11) NOT NULL auto_increment,

  colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId',

  itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber',

  PRIMARY KEY (collections_tracking_id)

) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `collections_tracking`

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

ALTER TABLE `collections_tracking`

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

--