CREATE TABLE QueueLongWait
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    Queue BIGINT UNSIGNED DEFAULT NULL,
    Skill BIGINT UNSIGNED DEFAULT NULL,
    Name VARCHAR(20) DEFAULT NULL,
    Number VARCHAR(30) DEFAULT NULL,
    Action ENUM("LongWaitAction", "Voicemail", "Hangup") DEFAULT NULL,
    Start BIGINT UNSIGNED DEFAULT NULL,
    End BIGINT UNSIGNED DEFAULT NULL,
    Duration INT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( id ),
    KEY ( Queue )
) ENGINE=INNODB CHARSET=UTF8 COMMENT="Count users who have been transferred to the voicemail or menu because their wait has exceeded the limit";