github.com/ArminBerberovic/gophish@v0.9.0/db/db_mysql/migrations/20160227180335_0.1.2_store-smtp-settings.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  -- Move the relationship between campaigns and smtp to campaigns
     5  ALTER TABLE `campaigns` ADD COLUMN smtp_id bigint;
     6  -- Create a new table to store smtp records
     7  DROP TABLE `smtp`;
     8  CREATE TABLE `smtp`(
     9  	id integer primary key auto_increment,
    10  	user_id bigint,
    11  	interface_type varchar(255),
    12  	name varchar(255),
    13  	host varchar(255),
    14  	username varchar(255),
    15  	password varchar(255),
    16  	from_address varchar(255),
    17  	modified_date datetime,
    18  	ignore_cert_errors BOOLEAN
    19  );
    20  -- +goose Down
    21  -- SQL section 'Down' is executed when this migration is rolled back
    22