github.com/Ne0nd0g/gophish@v0.7.1-0.20190220040016-11493024a07d/db/db_sqlite3/migrations/20170104220731_0.2_result_statuses.sql (about) 1 2 -- +goose Up 3 -- SQL in section 'Up' is executed when this migration is applied 4 UPDATE results 5 SET status = "Submitted Data" 6 WHERE id IN ( 7 SELECT results.id 8 FROM results, events 9 WHERE results.status = "Success" 10 AND events.message="Submitted Data" 11 AND results.email = events.email 12 AND results.campaign_id = events.campaign_id); 13 14 UPDATE results 15 SET status = "Clicked Link" 16 WHERE id IN ( 17 SELECT results.id 18 FROM results, events 19 WHERE results.status = "Success" 20 AND events.message="Clicked Link" 21 AND results.email = events.email 22 AND results.campaign_id = events.campaign_id); 23 24 -- +goose Down 25 -- SQL section 'Down' is executed when this migration is rolled back 26