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

     1  BEGIN;
     2    DROP INDEX resource_caches_resource_config_id_version_md5_params_hash_uniq;
     3  
     4    ALTER TABLE resource_caches DROP COLUMN version_md5;
     5  
     6    CREATE UNIQUE INDEX resource_caches_resource_config_id_version_params_hash_uniq
     7    ON resource_caches (resource_config_id, md5(version::text), params_hash);
     8  COMMIT;