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

     1  BEGIN;
     2    ALTER TABLE builds DROP CONSTRAINT builds_resource_id_key;
     3    CREATE INDEX builds_resource_id_idx ON builds (resource_id);
     4  
     5    ALTER TABLE resources ADD COLUMN build_id bigint REFERENCES builds (id) ON DELETE SET NULL;
     6  COMMIT;