CREATE TABLE WebEnterZone
(
    id BIGINT DEFAULT NULL,
    Person BIGINT UNSIGNED NOT NULL,
    Zone BIGINT UNSIGNED NOT NULL,
    ts BIGINT UNSIGNED NOT NULL,
    Role BIGINT UNSIGNED NOT NULL,
    Justification TEXT NOT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT,
    FOREIGN KEY ( Zone ) REFERENCES Zone ( id) ON DELETE CASCADE ON UPDATE CASCADE,
    FOREIGN KEY ( Person ) REFERENCES Person ( id) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Track accesses to customer zones by person/date";
