CREATE TABLE AdaptiveFaxReceiver
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    E164 VARCHAR(50) NOT NULL,
    Reason VARCHAR(75) DEFAULT NULL,
    Fax BIGINT UNSIGNED NOT NULL,
    ts BIGINT UNSIGNED NOT NULL,
    Result ENUM( "COMPLETE", "INCOMPLETE", "FAILURE"),
    IsT38 TINYINT NOT NULL,
    PRIMARY KEY ( id ) ,
    KEY ( Fax, E164, IsT38, Result, ts )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Log inbound virtual fax failures/successes/errors";
