     KEY (message_id),
     KEY (job_id),
     KEY (queue_id),
-    KEY (type),
+    KEY (event_type),
     KEY (result),
     KEY (email),
     KEY (is_test),

    reason text,
    type varchar(20),
    status varchar(8),
    smtp_id varchar(255),
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE click (

CREATE TABLE dropped (
    event_id int(10) unsigned PRIMARY KEY,
    reason varchar(255),
    smtp_id varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE open (
