CREATE TABLE RTCP
(
    id BIGINT PRIMARY KEY AUTO_INCREMENT,

    CallId VARCHAR(255) NOT NULL,
    BridgeCallId VARCHAR(255) DEFAULT NULL,
    
    SSRC INT UNSIGNED DEFAULT NULL,
    PacketLoss INT UNSIGNED DEFAULT NULL,
    RxJitter DECIMAL(10,6 ) DEFAULT NULL,
    RxCount INT UNSIGNED DEFAULT NULL,

    TxSSRC INT UNSIGNED DEFAULT NULL,
    TxPacketLoss INT UNSIGNED DEFAULT NULL,
    TxJitter DECIMAL(10,6) DEFAULT NULL,
    TxCount INT UNSIGNED DEFAULT NULL,

    rtt DECIMAL(10,6) DEFAULT NULL ,

    ts BIGINT UNSIGNED,

    Score TINYINT DEFAULT NULL,

    INDEX(CallId),
    INDEX(BridgeCallId)

) ENGINE=INNODB CHARSET=UTF8 COMMENT="RTCP stored data for VoIP calls";
