github.com/ArminBerberovic/gophish@v0.9.0/db/db_mysql/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 auto_increment,
     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  DROP TABLE `email_requests`;