-- -----------------------------------------------------
-- Table nodeT
-- -----------------------------------------------------

alter table nodeT add parentNodeTypeCount INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'cache for distinct count of node type ids of parent nodes' after displayNode;

-- -----------------------------------------------------
-- Table nodeLinkT
-- -----------------------------------------------------

alter table nodeLinkT add intermediate INT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'if this link has way around it via other intermediate nodes' after metric;

create index nodelinktypeid_srcnodeid_intermediate_idx on nodeLinkT (nodeLinkTypeId ASC, srcNodeId ASC, intermediate ASC);
create index nodelinktypeid_dstnodeid_intermediate_idx on nodeLinkT (nodeLinkTypeId ASC, dstNodeId ASC, intermediate ASC);