CREATE TABLE VoIPTrunkMonitor_Failures
(
    Source BIGINT UNSIGNED NOT NULL,
    Destination BIGINT UNSIGNED NOT NULL,
    Exchange CHAR(6) NOT NULL,
    DID CHAR(12) NOT NULL,
    Ts BIGINT UNSIGNED DEFAULT 0,
    CallId VARCHAR(255) DEFAULT NULL,
    Reason TEXT DEFAULT NULL,
    Cause CHAR(2) DEFAULT NULL,
    Causetxt CHAR(255) DEFAULT NULL,
    KEY ( DID ),
    KEY ( Destination ),
    KEY ( Source )

) ENGINE=INNODB CHARSET=UTF8;
