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

     1  BEGIN;
     2    ALTER TABLE resource_configs
     3      DROP COLUMN unique_versions_resource_id,
     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  
     7    ALTER TABLE base_resource_types
     8      DROP COLUMN unique_version_history;
     9  COMMIT;