mirror of https://github.com/gophish/gophish
25 lines
889 B
MySQL
25 lines
889 B
MySQL
|
-- +goose Up
|
||
|
|
-- SQL in section 'Up' is executed when this migration is applied
|
||
|
|
UPDATE results
|
||
|
|
SET status = "Submitted Data"
|
||
|
|
WHERE id IN (
|
||
|
|
SELECT results_tmp.id
|
||
|
|
FROM (SELECT * FROM results) AS results_tmp, events
|
||
|
|
WHERE results.status = "Success"
|
||
|
|
AND events.message="Submitted Data"
|
||
|
|
AND results_tmp.email = events.email
|
||
|
|
AND results_tmp.campaign_id = events.campaign_id);
|
||
|
|
|
||
|
|
UPDATE results
|
||
|
|
SET status = "Clicked Link"
|
||
|
|
WHERE id IN (
|
||
|
|
SELECT results_tmp.id
|
||
|
|
FROM (SELECT * FROM results) as results_tmp, events
|
||
|
|
WHERE results_tmp.status = "Success"
|
||
|
|
AND events.message="Clicked Link"
|
||
|
|
AND results_tmp.email = events.email
|
||
|
|
AND results_tmp.campaign_id = events.campaign_id);
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|