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

     1  BEGIN;
     2    CREATE TABLE build_pipes (
     3      "from_build_id" integer NOT NULL REFERENCES builds (id) ON DELETE CASCADE,
     4      "to_build_id" integer NOT NULL REFERENCES builds (id) ON DELETE CASCADE
     5    );
     6  
     7    CREATE UNIQUE INDEX build_pipes_from_build_id_to_build_id_uniq
     8    ON build_pipes (from_build_id, to_build_id);
     9  
    10    CREATE TABLE next_build_pipes (
    11      "from_build_id" integer NOT NULL REFERENCES builds (id) ON DELETE CASCADE,
    12      "to_job_id" integer NOT NULL REFERENCES jobs (id) ON DELETE CASCADE
    13    );
    14  
    15    CREATE UNIQUE INDEX next_build_pipes_from_build_id_to_job_id_uniq
    16    ON next_build_pipes (from_build_id, to_job_id);
    17  COMMIT;