CREATE TABLE SMSTransportTEST_RPT
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT "unique id within the transport Queue",
    LockId CHAR(32) DEFAULT NULL COMMENT "universe unique id to allow multiple process scenarios",
    TsStart BIGINT UNSIGNED DEFAULT NULL COMMENT "start timestamp of transfer, can be set in the future to control when the transfer will occur",
    TsLast BIGINT UNSIGNED NOT NULL COMMENT "last timestamp of state change.",
    From VARCHAR(50) NOT NULL COMMENT "identity of the source of the transfer",
    To VARCHAR(50) NOT NULL COMMENT "identity of the destination for the transfer",
    Data TEXT NOT NULL COMMENT "payload of the transfer",
    State BIGINT UNSIGNED NOT NULL COMMENT "QUEUED | IN_PROGRESS | DONE OK | DONE FAIL",
    TransId VARCHAR(50) DEFAULT NULL COMMENT "transaction id that uniquely identifies a transfer with the transport service provider",
    PRIMARY KEY ( id ),
    KEY TransId ( TransId ),
    KEY State ( State ),
    KEY LockId ( LockId )

) ENGINE=INNODB CHARSET=UTF8;
