mirror of https://github.com/gophish/gophish
16 lines
965 B
MySQL
16 lines
965 B
MySQL
|
|
||
|
|
-- +goose Up
|
||
|
|
-- SQL in section 'Up' is executed when this migration is applied
|
||
|
|
UPDATE campaigns SET created_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(created_date, 'utc'));
|
||
|
|
UPDATE campaigns SET completed_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(completed_date, 'utc'));
|
||
|
|
UPDATE campaigns SET launch_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(launch_date, 'utc'));
|
||
|
|
UPDATE events SET `time`=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(`time`, 'utc'));
|
||
|
|
UPDATE groups SET modified_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(modified_date, 'utc'));
|
||
|
|
UPDATE templates SET modified_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(modified_date, 'utc'));
|
||
|
|
UPDATE pages SET modified_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(modified_date, 'utc'));
|
||
|
|
UPDATE smtp SET modified_date=STRFTIME('%Y-%m-%d %H:%M:%S+00:00', DATETIME(modified_date, 'utc'));
|
||
|
|
|
||
|
|
-- +goose Down
|
||
|
|
-- SQL section 'Down' is executed when this migration is rolled back
|
||
|
|
|