mirror of https://github.com/gophish/gophish
23 lines
645 B
MySQL
23 lines
645 B
MySQL
|
|
||
|
|
-- +goose Up
|
||
|
|
-- SQL in section 'Up' is executed when this migration is applied
|
||
|
|
-- Move the relationship between campaigns and smtp to campaigns
|
||
|
|
ALTER TABLE campaigns ADD COLUMN "smtp_id" bigint;
|
||
|
|
-- Create a new table to store smtp records
|
||
|
|
DROP TABLE smtp;
|
||
|
|
CREATE TABLE smtp(
|
||
|
|
id integer primary key autoincrement,
|
||
|
|
user_id bigint,
|
||
|
|
interface_type varchar(255),
|
||
|
|
name varchar(255),
|
||
|
|
host varchar(255),
|
||
|
|
username varchar(255),
|
||
|
|
password varchar(255),
|
||
|
|
from_address varchar(255),
|
||
|
|
modified_date datetime default CURRENT_TIMESTAMP,
|
||
|
|
ignore_cert_errors BOOLEAN
|
||
|
|
);
|
||
|
|
-- +goose Down
|
||
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|
||
|
|
|