CREATE TABLE SMSConversation
(
    id BIGINT UNSIGNED DEFAULT NULL,
    SMSNode BIGINT UNSIGNED DEFAULT NULL,
    ExpireTs BIGINT UNSIGNED NOT NULL,
    StallTs BIGINT UNSIGNED DEFAULT 0,
    StallCallback BLOB DEFAULT NULL,
    Payload BLOB DEFAULT NULL,
    Timeout BLOB DEFAULT NULL,
    LaunchId BIGINT UNSIGNED DEFAULT NULL,
    FromSmsCode VARCHAR(16) DEFAULT NULL,
    LockId CHAR(32) DEFAULT NULL,
    Mode VARCHAR(16) DEFAULT NULL,
    PRIMARY KEY ( id ) AUTO_INCREMENT,
    UNIQUE KEY ( FromSmsCode,SMSNode ),
    KEY ( ExpireTs ),
    KEY ( LockId ),
    KEY ( LaunchId )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Table for tracking opened SMS conversations and answers";
