github.com/merlinepedra/gophish1@v0.9.0/db/db_mysql/migrations/20171027213457_0.4.1_maillogs.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  CREATE TABLE IF NOT EXISTS `mail_logs` (
     5      `id` integer primary key auto_increment,
     6      `campaign_id` integer,
     7      `user_id` integer,
     8      `send_date` datetime,
     9      `send_attempt` integer,
    10      `r_id` varchar(255),
    11      `processing` boolean);
    12  
    13  -- +goose Down
    14  -- SQL section 'Down' is executed when this migration is rolled back
    15  DROP TABLE `mail_logs`;