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

     1  BEGIN;
     2    ALTER TABLE ONLY resource_configs
     3        DROP CONSTRAINT resource_configs_resource_cache_id_base_resource_type_id_so_key,
     4        ADD CONSTRAINT resource_configs_resource_cache_id_so_key UNIQUE (resource_cache_id, source_hash),
     5        ADD CONSTRAINT resource_configs_base_resource_type_id_so_key UNIQUE (base_resource_type_id, source_hash);
     6  COMMIT;