CREATE TABLE ContactCentreActivityOutboundCall
(
    id BIGINT UNSIGNED NOT NULL,
    SIPCallId VARCHAR(100) DEFAULT NULL,
    CallerName VARCHAR(100) DEFAULT NULL COMMENT "Person name if calling an extension",
    CallerNumber VARCHAR(20) DEFAULT NULL,
    PRIMARY KEY ( id ),
    KEY ( SIPCallId ),
    FOREIGN KEY ( id ) REFERENCES ContactCentreActivity ( id ) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB CHARSET=UTF8;