CREATE TABLE WebVoIPImport_Payload
(
    id BIGINT NOT NULL AUTO_INCREMENT,
    ImportId BIGINT NOT NULL,
    Zone BIGINT UNSIGNED NOT NULL,
    IsDryRun TINYINT DEFAULT 0,
    Person BIGINT UNSIGNED DEFAULT NULL,
    CSVRowNumber BIGINT UNSIGNED NOT NULL,
    Payload LONGTEXT DEFAULT NULL,
    LockId CHAR(32) DEFAULT NULL,
    Status ENUM("QUEUE", "ERROR", "WORKING", "OK") DEFAULT "QUEUE",
    Notes TEXT DEFAULT NULL,
    IsNewPerson TINYINT(1) DEFAULT 0,
    PRIMARY KEY ( id ),
    KEY ( Zone ),
    KEY ( ImportId ),
    KEY ( LockId ),
    KEY ( Status,LockId ),
    KEY ( Person )

) ENGINE=INNODB CHARSET=UTF8;
