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

     1  BEGIN;
     2      DROP TRIGGER IF EXISTS pipeline_build_events_delete_trigger ON pipelines;
     3      DROP FUNCTION IF EXISTS on_pipeline_delete();
     4  
     5  	CREATE TABLE deleted_pipelines (
     6          id integer NOT NULL,
     7          deleted_at timestamp without time zone DEFAULT now() NOT NULL
     8  	);
     9  COMMIT;