github.com/glennzw/gophish@v0.8.1-0.20190824020715-24fe998a3aa0/db/db_sqlite3/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 autoincrement,
    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 default CURRENT_TIMESTAMP,
    18  	ignore_cert_errors BOOLEAN
    19  );
    20  -- +goose Down
    21  -- SQL section 'Down' is executed when this migration is rolled back
    22