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