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

     1  BEGIN;
     2    ALTER TABLE "workers" ADD COLUMN "certs_path" text;
     3    CREATE TABLE "worker_resource_certs" (
     4        "id" serial,
     5        "worker_name" text,
     6        "certs_path" text,
     7        PRIMARY KEY ("id"),
     8        CONSTRAINT "worker_resource_certs_worker_name_fkey" FOREIGN KEY ("worker_name") REFERENCES "workers"("name") ON DELETE CASCADE ON UPDATE SET NULL
     9    );
    10    ALTER TABLE "volumes"
    11    ADD COLUMN "worker_resource_certs_id" integer,
    12    ADD CONSTRAINT "worker_resource_certs_id_fkey" FOREIGN KEY ("worker_resource_certs_id") REFERENCES "worker_resource_certs"("id") ON DELETE SET NULL,
    13    DROP CONSTRAINT "cannot_invalidate_during_initialization",
    14    ADD CONSTRAINT "cannot_invalidate_during_initialization" CHECK ((state = ANY (ARRAY['created'::volume_state, 'destroying'::volume_state, 'failed'::volume_state])) AND worker_resource_cache_id IS NULL AND worker_base_resource_type_id IS NULL AND worker_task_cache_id IS NULL AND container_id IS NULL OR worker_resource_cache_id IS NOT NULL OR worker_base_resource_type_id IS NOT NULL OR worker_task_cache_id IS NOT NULL OR container_id IS NOT NULL OR worker_resource_certs_id IS NOT NULL);
    15  COMMIT;
    16