CREATE TABLE CustomURL
(
    ZoneId BIGINT UNSIGNED DEFAULT NULL,
    URL VARCHAR(100) DEFAULT NULL,
    PageId BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( ZoneId,URL ),
    FOREIGN KEY ( ZoneId ) REFERENCES Zone ( id) ON DELETE CASCADE ON UPDATE CASCADE,
    FOREIGN KEY ( PageId ) REFERENCES nodes ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Custom URL for node access ( contextual to zone )";
