CREATE TABLE SMSReport
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    RecvTs BIGINT UNSIGNED NOT NULL,
    SupplierRecvTs BIGINT UNSIGNED NOT NULL,
    Supplier VARCHAR(32) DEFAULT NULL,
    Sender VARCHAR(50) DEFAULT NULL,
    Receiver VARCHAR(50) DEFAULT NULL,
    SMSNumber BIGINT UNSIGNED DEFAULT NULL,
    Message TEXT DEFAULT NULL,
    Error TEXT DEFAULT NULL,

    PRIMARY KEY ( id )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Table for tracking inbound SMS";
