github.com/Ne0nd0g/gophish@v0.7.1-0.20190220040016-11493024a07d/db/db_mysql/migrations/20180524203752_0.7.0_result_last_modified.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  ALTER TABLE `results` ADD COLUMN modified_date DATETIME;
     5  
     6  UPDATE `results`
     7      SET `modified_date`= (
     8          SELECT max(events.time) FROM events
     9          WHERE events.email=results.email
    10          AND events.campaign_id=results.campaign_id
    11      );
    12  
    13  
    14  
    15  -- +goose Down
    16  -- SQL section 'Down' is executed when this migration is rolled back
    17