CREATE TABLE FaxDocumentDataType
(
    id BIGINT UNSIGNED DEFAULT NULL AUTO_INCREMENT,
    Node BIGINT UNSIGNED NOT NULL,
    ReceivedTime BIGINT UNSIGNED NOT NULL,
    CallerName VARCHAR(15) DEFAULT NULL,
    CallerNumber VARCHAR(30) DEFAULT NULL,
    Fax BLOB DEFAULT NULL,
    Status VARCHAR(75) DEFAULT NULL,
    Error VARCHAR(75) DEFAULT NULL,
    Speed VARCHAR(75) DEFAULT NULL,
    Pages INT UNSIGNED DEFAULT 0,
    RemoteStationId VARCHAR(75) DEFAULT NULL,
    TIFF BLOB DEFAULT NULL,
    FromNode BIGINT UNSIGNED DEFAULT NULL,
    PRIMARY KEY ( id ),
    KEY ( Node,ReceivedTime )

) ENGINE=INNODB CHARSET=UTF8;
