     reason text,
     type varchar(20),
     status varchar(8),
-    smtp_id varchar(255),
+    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 (

    KEY (message_id),
    KEY (job_id),
    KEY (queue_id),
    KEY (event_type),
    KEY (result),
    KEY (email),
    KEY (is_test),
