CREATE TABLE Role2Person
(
    Person BIGINT UNSIGNED DEFAULT NULL,
    Role BIGINT UNSIGNED DEFAULT NULL,
    Zone BIGINT UNSIGNED DEFAULT NULL,
    sort_order TINYINT DEFAULT NULL,
    PRIMARY KEY ( Person,Zone,Role ),
    KEY ( Zone,Role )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Static roles 2 person";
