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

     1  BEGIN;
     2    CREATE TABLE worker_artifacts (
     3      id SERIAL PRIMARY KEY,
     4      name TEXT NOT NULL,
     5      build_id INTEGER NULL,
     6      created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW() NOT NULL
     7    );
     8  
     9    ALTER TABLE worker_artifacts
    10      ADD CONSTRAINT worker_artifacts_build_id_fkey FOREIGN KEY (build_id) REFERENCES builds(id) ON DELETE SET NULL;
    11  
    12    ALTER TABLE volumes
    13      ADD COLUMN worker_artifact_id INTEGER;
    14  
    15    ALTER TABLE volumes
    16      ADD CONSTRAINT volumes_worker_artifact_id_fkey FOREIGN KEY (worker_artifact_id) REFERENCES worker_artifacts(id) ON DELETE SET NULL;
    17  
    18  COMMIT;