CREATE TABLE IF NOT EXISTS SubscriptionEventTransmitterLogs (
                            id BIGINT unsigned NOT NULL AUTO_INCREMENT,
                            Subscription BIGINT unsigned NOT NULL,
                            Event text NOT NULL,
                            Target varchar(78) NOT NULL,
                            Success tinyint(1) UNSIGNED NOT NULL,
                            Ts BIGINT UNSIGNED NOT NULL,
                            PRIMARY KEY (id),
                            KEY(Subscription),
                            KEY(Subscription,Ts)
                            ) ENGINE=INNODB;