CREATE TABLE CallExamplesDataType
(
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    Node BIGINT UNSIGNED NOT NULL,
    Date CHAR(10) DEFAULT NULL,
    Time CHAR(8) DEFAULT NULL,
    Duration CHAR(8) DEFAULT NULL,
    Destination VARCHAR(255) DEFAULT NULL,
    CallId VARCHAR(100) DEFAULT NULL,
    IsHomerTrace INT UNSIGNED NOT NULL,
    CustomerDescription TEXT DEFAULT NULL,
    Source VARCHAR(255) DEFAULT NULL,
    TechnicalDescription TEXT DEFAULT NULL,
    CallIdLegB VARCHAR(250) DEFAULT NULL,
    SDPIP VARCHAR(15) DEFAULT NULL,
    IsPCAPTrace TINYINT DEFAULT NULL,
    LockId CHAR(32) DEFAULT NULL,
    IsAutoCompletePending TINYINT DEFAULT 0,
    PRIMARY KEY ( id ),
    UNIQUE KEY Node_2 ( Node,CallId ),
    KEY ( LockId ),
    KEY Node ( Node ),
    KEY CallId ( CallId ),
    KEY IsHomerTrace ( IsHomerTrace )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="Call examples";
