github.com/glennzw/gophish@v0.8.1-0.20190824020715-24fe998a3aa0/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