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

10 lines
280 B
MySQL
Raw Permalink Normal View History

-- +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