github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1579713196_move_schedule_requested_to_jobs.up.sql (about)

     1  BEGIN;
     2    ALTER TABLE jobs
     3      ADD COLUMN schedule_requested timestamp with time zone DEFAULT '1970-01-01 00:00:00'::timestamp with time zone NOT NULL,
     4      ADD COLUMN last_scheduled timestamp with time zone DEFAULT '1970-01-01 00:00:00'::timestamp with time zone NOT NULL;
     5  
     6    ALTER TABLE pipelines
     7      DROP COLUMN schedule_requested,
     8      DROP COLUMN last_scheduled;
     9  COMMIT;