CREATE TABLE kamailio.AsteriskManagerOriginate
(
    ActionId VARCHAR(50) PRIMARY KEY,

    Invite BIGINT UNSIGNED DEFAULT NULL COMMENT "Timestamp the INVITE was received",
    CallId VARCHAR(255) DEFAULT NULL COMMENT "SIP CallId",

    Ringing BIGINT UNSIGNED DEFAULT NULL COMMENT "Timestamp when 180 ringing was seen",
    SessionProgress BIGINT UNSIGNED DEFAULT NULL COMMENT "Timestamp when 183 Session Progress was seen",

    ReplyCode CHAR(3) DEFAULT NULL COMMENT "Final response",
    ReplyReason VARCHAR(100) DEFAULT NULL COMMENT "Final response text",
    ReplyTime BIGINT UNSIGNED DEFAULT NULL COMMENT "Final response time",

    Q850Code VARCHAR(255) DEFAULT NULL COMMENT "Q.805 Code, if available",
    Q850Reason VARCHAR(255) DEFAULT NULL COMMENT "Q.805 Reason, if available",

    Expires BIGINT NOT NULL COMMENT "When this row should be removed from the database"

) 
ENGINE=INNODB 
CHARSET=UTF8 
COMMENT="Storage for data being passed to omniconnect from Kamailio"; 
