mirror of https://github.com/gophish/gophish
18 lines
409 B
MySQL
18 lines
409 B
MySQL
|
|
||
|
|
-- +goose Up
|
||
|
|
-- SQL in section 'Up' is executed when this migration is applied
|
||
|
|
ALTER TABLE results ADD COLUMN modified_date DATETIME;
|
||
|
|
|
||
|
|
UPDATE results
|
||
|
|
SET `modified_date`= (
|
||
|
|
SELECT max(events.time) FROM events
|
||
|
|
WHERE events.email=results.email
|
||
|
|
AND events.campaign_id=results.campaign_id
|
||
|
|
);
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|
||
|
|
|