github.com/glennzw/gophish@v0.8.1-0.20190824020715-24fe998a3aa0/db/db_sqlite3/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 autoincrement,
     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"