CREATE TABLE QueueNoAnswer
(
    id BIGINT UNSIGNED DEFAULT NULL,
    Queue BIGINT UNSIGNED DEFAULT NULL,
    Agent BIGINT UNSIGNED DEFAULT NULL,
    Name VARCHAR(20) DEFAULT NULL,
    Number VARCHAR(30) DEFAULT NULL,
    ts BIGINT UNSIGNED DEFAULT NULL,
    CallId VARCHAR(100) DEFAULT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT,
    KEY ( Queue ),
    KEY ( Agent )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Calls not answered by call center agent";
