gophish/db/db_mysql/migrations/20171027213457_0.4.1_maillo...

16 lines
413 B
SQL

-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
CREATE TABLE IF NOT EXISTS mail_logs (
id integer primary key auto_increment,
campaign_id integer,
user_id integer,
send_date datetime,
send_attempt integer,
r_id varchar(255),
processing boolean);
-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back
DROP TABLE mail_logs;