2017-12-09 21:42:07 +00:00
|
|
|
|
|
|
|
|
-- +goose Up
|
|
|
|
|
-- SQL in section 'Up' is executed when this migration is applied
|
2018-12-27 16:23:54 +00:00
|
|
|
CREATE TABLE IF NOT EXISTS `mail_logs` (
|
|
|
|
|
`id` integer primary key auto_increment,
|
|
|
|
|
`campaign_id` integer,
|
|
|
|
|
`user_id` integer,
|
|
|
|
|
`send_date` datetime,
|
|
|
|
|
`send_attempt` integer,
|
|
|
|
|
`r_id` varchar(255),
|
|
|
|
|
`processing` boolean);
|
2017-12-09 21:42:07 +00:00
|
|
|
|
|
|
|
|
-- +goose Down
|
|
|
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|
2018-12-27 16:23:54 +00:00
|
|
|
DROP TABLE `mail_logs`;
|
