CREATE TABLE IF NOT EXISTS ZohoEventTransmitterLogs (
                            id BIGINT unsigned NOT NULL AUTO_INCREMENT,
                            Zone BIGINT unsigned NOT NULL,
                            Event VARCHAR(50) NOT NULL,
                            EventInfo TEXT,
                            Message TEXT NOT NULL,
                            IsError TINYINT unsigned NOT NULL,
                            Extension BIGINT unsigned,
                            Ts BIGINT UNSIGNED NOT NULL,
                            PRIMARY KEY (id),
                            KEY(Zone,Ts),
                            KEY(Event)
                            ) ENGINE=INNODB;