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

     1  BEGIN;
     2    ALTER TABLE "workers" DROP COLUMN "certs_path";
     3    ALTER TABLE "volumes"
     4    DROP CONSTRAINT "cannot_invalidate_during_initialization",
     5    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),
     6    DROP COLUMN "worker_resource_certs_id";
     7    DROP TABLE "worker_resource_certs";
     8  COMMIT;