github.com/jonathaningram/gophish@v0.3.1-0.20170829042651-ac3fe6aeae6c/db/db_sqlite3/migrations/20160605210903_0.2_campaign_scheduling.sql (about)

     1  
     2  -- +goose Up
     3  -- SQL in section 'Up' is executed when this migration is applied
     4  ALTER TABLE "campaigns" ADD COLUMN "launch_date" DATETIME;
     5  
     6  UPDATE "campaigns" SET "launch_date" = "created_date";
     7  -- +goose Down
     8  -- SQL section 'Down' is executed when this migration is rolled back
     9