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

     1  BEGIN;
     2    ALTER TABLE resource_caches ADD COLUMN version_md5 text;
     3  
     4    UPDATE resource_caches SET version_md5 = md5(version::text);
     5  
     6    ALTER TABLE resource_caches ALTER COLUMN version_md5 SET NOT NULL;
     7  
     8    DROP INDEX resource_caches_resource_config_id_version_params_hash_uniq;
     9  
    10    CREATE UNIQUE INDEX resource_caches_resource_config_id_version_md5_params_hash_uniq
    11    ON resource_caches (resource_config_id, version_md5, params_hash);
    12  COMMIT;