CREATE TABLE IF NOT EXISTS ZohoPhoneBridgeCallNotifyLogs (
        id BIGINT unsigned NOT NULL AUTO_INCREMENT,
        Zone BIGINT unsigned NOT NULL,
        Extension BIGINT unsigned NOT NULL,
        FromNumber VARCHAR(30) NOT NULL,
        ToNumber VARCHAR(30) NOT NULL,
        Type VARCHAR(30) NOT NULL,
        State VARCHAR(30)  NOT NULL,
        CallId VARCHAR(100) NOT NULL,
        Extras VARCHAR(200) DEFAULT NULL,
        ZohoUser VARCHAR(30) DEFAULT NULL,
        Result VARCHAR(200) DEFAULT NULL,
        Ts BIGINT UNSIGNED NOT NULL,
        PRIMARY KEY (id),
        KEY(Zone,Type),
        KEY(CallId)
        ) ENGINE=INNODB;