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;