github.com/Ne0nd0g/gophish@v0.7.1-0.20190220040016-11493024a07d/db/db_sqlite3/migrations/20180527213648_0.7.0_store_email_request.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  CREATE TABLE IF NOT EXISTS "email_requests" (
     5      "id" integer primary key autoincrement,
     6      "user_id" integer,
     7      "template_id" integer,
     8      "page_id" integer,
     9      "first_name" varchar(255),
    10      "last_name" varchar(255),
    11      "email" varchar(255),
    12      "position" varchar(255),
    13      "url" varchar(255),
    14      "r_id" varchar(255),
    15      "from_address" varchar(255)
    16  );
    17  
    18  
    19  -- +goose Down
    20  -- SQL section 'Down' is executed when this migration is rolled back
    21