DROP TABLE IF EXISTS path_nodes;
CREATE TABLE path_nodes (
    id          BIGINT          AUTO_INCREMENT PRIMARY KEY,
    node        VARCHAR(256)    NOT NULL,
    type		CHAR(1)
);

DROP TABLE IF EXISTS path_paths;
CREATE TABLE path_paths (
    id          BIGINT          AUTO_INCREMENT PRIMARY KEY,
    fromnode    BIGINT,
    tonode      BIGINT,
    pathlen		TINYINT,
    type		CHAR(1)
);

DROP TABLE IF EXISTS path_arcs;
CREATE TABLE path_arcs (
    pathid      BIGINT,
    seq         TINYINT,
    nodeid      BIGINT,
    label		VARCHAR(256),
    PRIMARY KEY (pathid, seq)
);
