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

     1  BEGIN;
     2    CREATE TABLE successful_build_outputs (
     3        "build_id" integer NOT NULL REFERENCES builds (id) ON DELETE CASCADE,
     4        "job_id" integer NOT NULL REFERENCES jobs (id) ON DELETE CASCADE,
     5        "outputs" jsonb NOT NULL
     6    );
     7  
     8    CREATE UNIQUE INDEX successful_build_outputs_build_id_idx ON successful_build_outputs (build_id);
     9  
    10    CREATE INDEX on successful_build_outputs USING GIN (outputs jsonb_path_ops) WITH (FASTUPDATE = false);
    11  
    12    CREATE INDEX successful_build_outputs_job_id_idx ON successful_build_outputs (job_id);
    13  COMMIT;