CREATE TABLE VoIPTrunkMonitor
(
    Trunk BIGINT UNSIGNED NOT NULL,
    Exchange CHAR(6) NOT NULL,
    DID CHAR(12) NOT NULL,
    Attempt TINYINT DEFAULT 0,
    Failed TINYINT DEFAULT 0,
    LastTs BIGINT UNSIGNED DEFAULT 0,
    LastOK BIGINT UNSIGNED DEFAULT 0,
    LastFail BIGINT UNSIGNED DEFAULT 0,
    KEY ( DID ),
    KEY ( Trunk )

) ENGINE=INNODB CHARSET=UTF8;
