2016-02-28 01:38:54 +00:00
|
|
|
|
|
|
|
|
-- +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
|
2016-02-28 03:16:42 +00:00
|
|
|
DROP TABLE smtp;
|
2016-02-28 01:38:54 +00:00
|
|
|
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
|
|
|
|
|
|
