github.com/jonathaningram/gophish@v0.3.1-0.20170829042651-ac3fe6aeae6c/db/db_mysql/migrations/20170828220440_0.4_utc_dates.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  UPDATE campaigns SET `created_date`=CONVERT_TZ(`created_date`, @@session.time_zone, '+00:00');
     5  UPDATE campaigns SET `completed_date`=CONVERT_TZ(`completed_date`, @@session.time_zone, '+00:00');
     6  UPDATE campaigns SET `launch_date`=CONVERT_TZ(`launch_date`, @@session.time_zone, '+00:00');
     7  UPDATE events SET `time`=CONVERT_TZ(`time`, @@session.time_zone, '+00:00');
     8  UPDATE groups SET `modified_date`=CONVERT_TZ(`modified_date`, @@session.time_zone, '+00:00');
     9  UPDATE templates SET `modified_date`=CONVERT_TZ(`modified_date`, @@session.time_zone, '+00:00');
    10  UPDATE pages SET `modified_date`=CONVERT_TZ(`modified_date`, @@session.time_zone, '+00:00');
    11  UPDATE smtp SET `modified_date`=CONVERT_TZ(`modified_date`, @@session.time_zone, '+00:00');
    12  
    13  
    14  -- +goose Down
    15  -- SQL section 'Down' is executed when this migration is rolled back
    16