mirror of https://github.com/gophish/gophish
27 lines
681 B
MySQL
27 lines
681 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.id
|
||
|
|
FROM results, events
|
||
|
|
WHERE results.status = "Success"
|
||
|
|
AND events.message="Submitted Data"
|
||
|
|
AND results.email = events.email
|
||
|
|
AND results.campaign_id = events.campaign_id);
|
||
|
|
|
||
|
|
UPDATE results
|
||
|
|
SET status = "Clicked Link"
|
||
|
|
WHERE id IN (
|
||
|
|
SELECT results.id
|
||
|
|
FROM results, events
|
||
|
|
WHERE results.status = "Success"
|
||
|
|
AND events.message="Clicked Link"
|
||
|
|
AND results.email = events.email
|
||
|
|
AND results.campaign_id = events.campaign_id);
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|
||
|
|
|