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