gophish/db/db_mysql/migrations/20160605210903_0.2_campaign...

10 lines
274 B
SQL

-- +goose Up
-- SQL in section 'Up' is executed when this migration is applied
ALTER TABLE `campaigns` ADD COLUMN launch_date DATETIME;
UPDATE `campaigns` SET launch_date = created_date;
-- +goose Down
-- SQL section 'Down' is executed when this migration is rolled back